{"format": 1, "mode": "release", "from_release": null, "to_release": {"date": "2016-03-31", "build": "9.5.2", "major": "9.5", "minor": 2, "manual": "9.5", "status": "stable", "doc_git": "", "version": "9.5.2", "eol_date": "2021-02-11", "date_text": "2016-03-31", "supported": false, "manual_url": "/docs/9.5/release-9-5-2.html", "source_url": "/docs/release/9.5.2/", "entry_count": 33, "placeholder": false, "content_hash": "2445e33491479754d218b52df59a3a2751d312d1d7992bd086b450035ce3c5e8", "manual_build": "9.5.25", "source_as_of": "", "changes_count": 33, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "

A dump/restore is not required for those running 9.5.X.

\n

However, you may need to REINDEX some indexes after applying the update, as per the first changelog entry below.

", "compatibility_count": 0, "label": "9.5.2", "status_label": "Historical", "eol": "2021-02-11", "age_days": 3834, "support_days": -2056}, "groups": [{"date": "2016-03-31", "build": "9.5.2", "major": "9.5", "minor": 2, "manual": "9.5", "status": "stable", "doc_git": "", "version": "9.5.2", "eol_date": "2021-02-11", "date_text": "2016-03-31", "supported": false, "manual_url": "/docs/9.5/release-9-5-2.html", "source_url": "/docs/release/9.5.2/", "entry_count": 33, "placeholder": false, "content_hash": "2445e33491479754d218b52df59a3a2751d312d1d7992bd086b450035ce3c5e8", "manual_build": "9.5.25", "source_as_of": "", "changes_count": 33, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "

A dump/restore is not required for those running 9.5.X.

\n

However, you may need to REINDEX some indexes after applying the update, as per the first changelog entry below.

", "compatibility_count": 0, "label": "9.5.2", "status_label": "Historical", "eol": "2021-02-11", "age_days": 3834, "support_days": -2056, "entries": [{"id": "9.5.2-d1eb5e2f93c23078", "cves": [], "html": "

Disable abbreviated keys for string sorting in non-C locales (Robert Haas)

\n

PostgreSQL 9.5 introduced logic for speeding up comparisons of string data types by using the standard C library function strxfrm() as a substitute for strcoll(). It now emerges that most versions of glibc (Linux's implementation of the C library) have buggy implementations of strxfrm() that, in some locales, can produce string comparison results that do not match strcoll(). Until this problem can be better characterized, disable the optimization in all non-C locales. (C locale is safe since it uses neither strcoll() nor strxfrm().)

\n

Unfortunately, this problem affects not only sorting but also entry ordering in B-tree indexes, which means that B-tree indexes on text, varchar, or char columns may now be corrupt if they sort according to an affected locale and were built or modified under PostgreSQL 9.5.0 or 9.5.1. Users should REINDEX indexes that might be affected.

\n

It is not possible at this time to give an exhaustive list of known-affected locales. C locale is known safe, and there is no evidence of trouble in English-based locales such as en_US, but some other popular locales such as de_DE are affected in most glibc versions.

", "text": "Disable abbreviated keys for string sorting in non-C locales (Robert Haas) PostgreSQL 9.5 introduced logic for speeding up comparisons of string data types by using the standard C library function strxfrm() as a substitute for strcoll(). It now emerges that most versions of glibc (Linux's implementation of the C library) have buggy implementations of strxfrm() that, in some locales, can produce string comparison results that do not match strcoll(). Until this problem can be better characterized, disable the optimization in all non-C locales. (C locale is safe since it uses neither strcoll() nor strxfrm().) Unfortunately, this problem affects not only sorting but also entry ordering in B-tree indexes, which means that B-tree indexes on text, varchar, or char columns may now be corrupt if they sort according to an affected locale and were built or modified under PostgreSQL 9.5.0 or 9.5.1. Users should REINDEX indexes that might be affected. It is not possible at this time to give an exhaustive list of known-affected locales. C locale is known safe, and there is no evidence of trouble in English-based locales such as en_US, but some other popular locales such as de_DE are affected in most glibc versions.", "title": "Disable abbreviated keys for string sorting in non-C locales", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "d2e6263077eb1118e024f36add4ee9f70c9c211c96c9d82dd3824c11abb15718", "section_path": ["Changes"], "commit_groups": [["3df9c374e", "8aa6e9780"]], "identity_text": "Disable abbreviated keys for string sorting in non-C locales (Robert Haas) PostgreSQL 9.5 introduced logic for speeding up comparisons of string data types by using the standard C library function strxfrm() as a substitute for strcoll(). It now emerges that most versions of glibc (Linux's implementation of the C library) have buggy implementations of strxfrm() that, in some locales, can produce string comparison results that do not match strcoll(). Until this problem can be better characterized, disable the optimization in all non-C locales. (C locale is safe since it uses neither strcoll() nor strxfrm().) Unfortunately, this problem affects not only sorting but also entry ordering in B-tree indexes, which means that B-tree indexes on text, varchar, or char columns may now be corrupt if they sort according to an affected locale and were built or modified under PostgreSQL 9.5.0 or 9.5.1. Users should REINDEX indexes that might be affected. It is not possible at this time to give an exhaustive list of known-affected locales. C locale is known safe, and there is no evidence of trouble in English-based locales such as en_US, but some other popular locales such as de_DE are affected in most glibc versions.", "commit_aliases": ["3df9c374e", "8aa6e9780"], "source_commits": ["8aa6e9780"], "source_entry_id": "9.5.2/changes/001", "db_id": "d97b2e2384b1de73d3bbdc8cbef4a4ed", "patch_ids": ["8e3b49fd1d31a5fd4169332626a3567c"], "statement_hash": "d5db6d738c9d2a67ec06558caa13f97a73c89a3c9b94c441ed9198b583dd53cf", "relations": [], "version": "9.5.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.2-5929a36480c80635", "cves": ["CVE-2016-2193"], "html": "

Maintain row-security status properly in cached plans (Stephen Frost)

\n

In a session that performs queries as more than one role, the plan cache might incorrectly re-use a plan that was generated for another role ID, thus possibly applying the wrong set of policies when row-level security (RLS) is in use. (CVE-2016-2193)

", "text": "Maintain row-security status properly in cached plans (Stephen Frost) In a session that performs queries as more than one role, the plan cache might incorrectly re-use a plan that was generated for another role ID, thus possibly applying the wrong set of policies when row-level security (RLS) is in use. (CVE-2016-2193)", "title": "Maintain row-security status properly in cached plans", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "296cd730789319e286e1f2bc9fc7a1a9c350595ea2bd8422b7c4be2f3e93fb70", "section_path": ["Changes"], "commit_groups": [["86ebf30fd", "db69e58a0"]], "identity_text": "Maintain row-security status properly in cached plans (Stephen Frost) In a session that performs queries as more than one role, the plan cache might incorrectly re-use a plan that was generated for another role ID, thus possibly applying the wrong set of policies when row-level security (RLS) is in use. (CVE-2016-2193)", "commit_aliases": ["86ebf30fd", "db69e58a0"], "source_commits": ["db69e58a0"], "source_entry_id": "9.5.2/changes/002", "db_id": "1b4c922fb7cdcffcb400fca44612cd3a", "patch_ids": ["5ebfea40f182589e892508911e100198"], "statement_hash": "5e162fd5284e3f6069ecf82efd82cd126c9fbbd08f98c51f96d5235f3913c8e6", "relations": [], "version": "9.5.2", "category_label": "Security", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.2-65317f6b66094ce0", "cves": ["CVE-2016-3065"], "html": "

Add must-be-superuser checks to some new contrib/pageinspect functions (Andreas Seltenreich)

\n

Most functions in the pageinspect extension that inspect bytea values disallow calls by non-superusers, but brin_page_type() and brin_metapage_info() failed to do so. Passing contrived bytea values to them might crash the server or disclose a few bytes of server memory. Add the missing permissions checks to prevent misuse. (CVE-2016-3065)

", "text": "Add must-be-superuser checks to some new contrib/pageinspect functions (Andreas Seltenreich) Most functions in the pageinspect extension that inspect bytea values disallow calls by non-superusers, but brin_page_type() and brin_metapage_info() failed to do so. Passing contrived bytea values to them might crash the server or disclose a few bytes of server memory. Add the missing permissions checks to prevent misuse. (CVE-2016-3065)", "title": "Add must-be-superuser checks to some new contrib/pageinspect functions", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "45dcc7b058485dfd9aff47b1ffbf1205cfbb95b91903043cb22c15bf5f8c3fff", "section_path": ["Changes"], "commit_groups": [["3e1338475", "bf78a6f10"]], "identity_text": "Add must-be-superuser checks to some new contrib/pageinspect functions (Andreas Seltenreich) Most functions in the pageinspect extension that inspect bytea values disallow calls by non-superusers, but brin_page_type() and brin_metapage_info() failed to do so. Passing contrived bytea values to them might crash the server or disclose a few bytes of server memory. Add the missing permissions checks to prevent misuse. (CVE-2016-3065)", "commit_aliases": ["3e1338475", "bf78a6f10"], "source_commits": ["bf78a6f10"], "source_entry_id": "9.5.2/changes/003", "db_id": "84ff398a798daa834f88937565518ecb", "patch_ids": ["78d71ab01112e7f7a56a4e1e2cf0f738"], "statement_hash": "b109e7da724a3a05cbbf90b753763698fbea347fc4c020946ac423312c6f5a18", "relations": [], "version": "9.5.2", "category_label": "Security", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.2-6f0532de726e00e6", "cves": [], "html": "

Fix incorrect handling of indexed ROW() comparisons (Simon Riggs)

\n

Flaws in a minor optimization introduced in 9.5 caused incorrect results if the ROW() comparison matches the index ordering partially but not exactly (for example, differing column order, or the index contains both ASC and DESC columns). Pending a better solution, the optimization has been removed.

", "text": "Fix incorrect handling of indexed ROW() comparisons (Simon Riggs) Flaws in a minor optimization introduced in 9.5 caused incorrect results if the ROW() comparison matches the index ordering partially but not exactly (for example, differing column order, or the index contains both ASC and DESC columns). Pending a better solution, the optimization has been removed.", "title": "Fix incorrect handling of indexed ROW() comparisons", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "eff799923bcfd16ba4cbadb54a74785745f8897e0db62bfff4a7589653c1cc3c", "section_path": ["Changes"], "commit_groups": [["bf7ced5e2", "c7111d11b"]], "identity_text": "Fix incorrect handling of indexed ROW() comparisons (Simon Riggs) Flaws in a minor optimization introduced in 9.5 caused incorrect results if the ROW() comparison matches the index ordering partially but not exactly (for example, differing column order, or the index contains both ASC and DESC columns). Pending a better solution, the optimization has been removed.", "commit_aliases": ["bf7ced5e2", "c7111d11b"], "source_commits": ["bf7ced5e2"], "source_entry_id": "9.5.2/changes/004", "db_id": "92d3563ad910c37e851860686be1bc03", "patch_ids": ["3b5c3181387f8d0acfad93474ff55011"], "statement_hash": "6fdbe24b78fe5192d497c7068b47071ef6bdead02c251d88e8e09cb5be3f6878", "relations": [], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.2-a5711f852b131e7b", "cves": [], "html": "

Fix incorrect handling of NULL index entries in indexed ROW() comparisons (Tom Lane)

\n

An index search using a row comparison such as ROW(a, b) > ROW('x', 'y') would stop upon reaching a NULL entry in the b column, ignoring the fact that there might be non-NULL b values associated with later values of a.

", "text": "Fix incorrect handling of NULL index entries in indexed ROW() comparisons (Tom Lane) An index search using a row comparison such as ROW(a, b) > ROW('x', 'y') would stop upon reaching a NULL entry in the b column, ignoring the fact that there might be non-NULL b values associated with later values of a.", "title": "Fix incorrect handling of NULL index entries in indexed ROW() comparisons", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "49a0542558f4805ad257063f94247a38424afd6f95fef3da860ff25b8fdc1476", "section_path": ["Changes"], "commit_groups": [["1ab7a160f", "a298a1e06", "b2ce9485b", "c8e059724", "d485d9581", "da936200d"]], "identity_text": "Fix incorrect handling of NULL index entries in indexed ROW() comparisons (Tom Lane) An index search using a row comparison such as ROW(a, b) > ROW('x', 'y') would stop upon reaching a NULL entry in the b column, ignoring the fact that there might be non-NULL b values associated with later values of a.", "commit_aliases": ["1ab7a160f", "a298a1e06", "b2ce9485b", "c8e059724", "d485d9581", "da936200d"], "source_commits": ["b2ce9485b"], "source_entry_id": "9.5.2/changes/005", "db_id": "fcaef37c43b439b3d192a695fc0c7f55", "patch_ids": ["21e2d2e5bdfac359bfdb1d81726978c4"], "statement_hash": "e5122ba5033c022dd9cae0cc394f98918f4c8094feacc04c0d0a507ffb280c61", "relations": [{"rule": 2, "type": "equivalent", "target": "771229a171201c695d4c34c21216b6e7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e5122ba5033c022dd9cae0cc394f98918f4c8094feacc04c0d0a507ffb280c61"}}, {"rule": 2, "type": "equivalent", "target": "80a8664f234b02e933cb1aaed80af795", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e5122ba5033c022dd9cae0cc394f98918f4c8094feacc04c0d0a507ffb280c61"}}, {"rule": 2, "type": "equivalent", "target": "920faefa1e4c1d58dec990f4a90f46b5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e5122ba5033c022dd9cae0cc394f98918f4c8094feacc04c0d0a507ffb280c61"}}, {"rule": 2, "type": "equivalent", "target": "f7f1d0e5c88def4e0c0ab9bb7d00e041", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e5122ba5033c022dd9cae0cc394f98918f4c8094feacc04c0d0a507ffb280c61"}}], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "771229a171201c695d4c34c21216b6e7", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Fix incorrect handling of NULL index entries in indexed ROW() comparisons", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e5122ba5033c022dd9cae0cc394f98918f4c8094feacc04c0d0a507ffb280c61"}, "url": "/docs/compare/?release=9.4.7#9.4.7-a5711f852b131e7b", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "f7f1d0e5c88def4e0c0ab9bb7d00e041", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "Fix incorrect handling of NULL index entries in indexed ROW() comparisons", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e5122ba5033c022dd9cae0cc394f98918f4c8094feacc04c0d0a507ffb280c61"}, "url": "/docs/compare/?release=9.3.12#9.3.12-a5711f852b131e7b", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "80a8664f234b02e933cb1aaed80af795", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "Fix incorrect handling of NULL index entries in indexed ROW() comparisons", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e5122ba5033c022dd9cae0cc394f98918f4c8094feacc04c0d0a507ffb280c61"}, "url": "/docs/compare/?release=9.2.16#9.2.16-a5711f852b131e7b", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "920faefa1e4c1d58dec990f4a90f46b5", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "Fix incorrect handling of NULL index entries in indexed ROW() comparisons", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e5122ba5033c022dd9cae0cc394f98918f4c8094feacc04c0d0a507ffb280c61"}, "url": "/docs/compare/?release=9.1.21#9.1.21-a5711f852b131e7b", "source_url": "/docs/release/9.1.21/#AEN107251"}]}, {"id": "9.5.2-9c6bd90458423d4e", "cves": [], "html": "

Avoid unlikely data-loss scenarios due to renaming files without adequate fsync() calls before and after (Michael Paquier, Tomas Vondra, Andres Freund)

", "text": "Avoid unlikely data-loss scenarios due to renaming files without adequate fsync() calls before and after (Michael Paquier, Tomas Vondra, Andres Freund)", "title": "Avoid unlikely data-loss scenarios due to renaming files without adequate fsync() calls before and after", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "f6b233ff914bca4ce7f8cc4bf5b141186e6110d58665e38db87e8b4020b0882f", "section_path": ["Changes"], "commit_groups": [["1d4a0ab19", "301cc3549", "4f37d0916", "a62714fae", "bfa282a02", "ce8f42919"], ["43b491a81", "606e0f984", "63b06e8fa", "c224d44f7", "d0e47bcd4", "e069848a3"]], "identity_text": "Avoid unlikely data-loss scenarios due to renaming files without adequate fsync() calls before and after (Michael Paquier, Tomas Vondra, Andres Freund)", "commit_aliases": ["1d4a0ab19", "301cc3549", "43b491a81", "4f37d0916", "606e0f984", "63b06e8fa", "a62714fae", "bfa282a02", "c224d44f7", "ce8f42919", "d0e47bcd4", "e069848a3"], "source_commits": ["301cc3549", "63b06e8fa"], "source_entry_id": "9.5.2/changes/006", "db_id": "a9854d76e1cad326241bf36f0d4fc81d", "patch_ids": ["0f795b9ef5f267faf61d73bc9a3e653a", "a7e01f96f6aff5674919ae99d28d45f9"], "statement_hash": "0344fa52ee3e1cf1eb149644ace2f3310367246c524f009b8868fce648ca8af2", "relations": [{"rule": 2, "type": "equivalent", "target": "3e2c0c4a1b5b42e37f23d751fd0773fb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0344fa52ee3e1cf1eb149644ace2f3310367246c524f009b8868fce648ca8af2"}}, {"rule": 2, "type": "equivalent", "target": "7e62b8610521a272fc3912882e152551", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0344fa52ee3e1cf1eb149644ace2f3310367246c524f009b8868fce648ca8af2"}}, {"rule": 2, "type": "equivalent", "target": "a5765102546e298c1a6d8ed7e2e12411", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0344fa52ee3e1cf1eb149644ace2f3310367246c524f009b8868fce648ca8af2"}}, {"rule": 2, "type": "equivalent", "target": "cbb7557e521d0a5bb82799a1e8f65f08", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0344fa52ee3e1cf1eb149644ace2f3310367246c524f009b8868fce648ca8af2"}}], "version": "9.5.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "3e2c0c4a1b5b42e37f23d751fd0773fb", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Avoid unlikely data-loss scenarios due to renaming files without adequate fsync() calls before and after", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0344fa52ee3e1cf1eb149644ace2f3310367246c524f009b8868fce648ca8af2"}, "url": "/docs/compare/?release=9.4.7#9.4.7-9c6bd90458423d4e", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "a5765102546e298c1a6d8ed7e2e12411", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "Avoid unlikely data-loss scenarios due to renaming files without adequate fsync() calls before and after", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0344fa52ee3e1cf1eb149644ace2f3310367246c524f009b8868fce648ca8af2"}, "url": "/docs/compare/?release=9.3.12#9.3.12-9c6bd90458423d4e", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "7e62b8610521a272fc3912882e152551", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "Avoid unlikely data-loss scenarios due to renaming files without adequate fsync() calls before and after", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0344fa52ee3e1cf1eb149644ace2f3310367246c524f009b8868fce648ca8af2"}, "url": "/docs/compare/?release=9.2.16#9.2.16-9c6bd90458423d4e", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "cbb7557e521d0a5bb82799a1e8f65f08", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "Avoid unlikely data-loss scenarios due to renaming files without adequate fsync() calls before and after", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0344fa52ee3e1cf1eb149644ace2f3310367246c524f009b8868fce648ca8af2"}, "url": "/docs/compare/?release=9.1.21#9.1.21-9c6bd90458423d4e", "source_url": "/docs/release/9.1.21/#AEN107251"}]}, {"id": "9.5.2-0708256ba9b59e38", "cves": [], "html": "

Fix incorrect behavior when rechecking a just-modified row in a query that does SELECT FOR UPDATE/SHARE and contains some relations that need not be locked (Tom Lane)

\n

Rows from non-locked relations were incorrectly treated as containing all NULLs during the recheck, which could result in incorrectly deciding that the updated row no longer passes the WHERE condition, or in incorrectly outputting NULLs.

", "text": "Fix incorrect behavior when rechecking a just-modified row in a query that does SELECT FOR UPDATE/SHARE and contains some relations that need not be locked (Tom Lane) Rows from non-locked relations were incorrectly treated as containing all NULLs during the recheck, which could result in incorrectly deciding that the updated row no longer passes the WHERE condition, or in incorrectly outputting NULLs.", "title": "Fix incorrect behavior when rechecking a just-modified row in a query that does SELECT FOR UPDATE/SHARE and contains some relations that need not be locked", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "012c0daba027cbf14e3a87bcc782981a6cb24f9f086d9d23df091bba4cf03342", "section_path": ["Changes"], "commit_groups": [["71404af2a", "d8d5a00b1"]], "identity_text": "Fix incorrect behavior when rechecking a just-modified row in a query that does SELECT FOR UPDATE/SHARE and contains some relations that need not be locked (Tom Lane) Rows from non-locked relations were incorrectly treated as containing all NULLs during the recheck, which could result in incorrectly deciding that the updated row no longer passes the WHERE condition, or in incorrectly outputting NULLs.", "commit_aliases": ["71404af2a", "d8d5a00b1"], "source_commits": ["d8d5a00b1"], "source_entry_id": "9.5.2/changes/007", "db_id": "f899984bd9c0961ea96148bdd3bf6b96", "patch_ids": ["596f16b8ad3a405ef6e04d27bbfa8b7b"], "statement_hash": "2a12b4e9be153e6444bf00feebccffcdb5f09be7c3eccc650e5361f72a523254", "relations": [], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.2-12be466959d2a19b", "cves": [], "html": "

Fix bug in json_to_record() when a field of its input object contains a sub-object with a field name matching one of the requested output column names (Tom Lane)

", "text": "Fix bug in json_to_record() when a field of its input object contains a sub-object with a field name matching one of the requested output column names (Tom Lane)", "title": "Fix bug in json_to_record() when a field of its input object contains a sub-object with a field name matching one of the requested output column names", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "d842bfa1ca3e9013e42c704f02e6476cac51a978c404b7e90d89e02577a635b4", "section_path": ["Changes"], "commit_groups": [["429d68465", "597e41e45", "a9d199f6d"]], "identity_text": "Fix bug in json_to_record() when a field of its input object contains a sub-object with a field name matching one of the requested output column names (Tom Lane)", "commit_aliases": ["429d68465", "597e41e45", "a9d199f6d"], "source_commits": ["429d68465"], "source_entry_id": "9.5.2/changes/008", "db_id": "468d32caa50ed7eeb024a0b427083bed", "patch_ids": ["ca3d9204bfea9369c12598671e634042"], "statement_hash": "0b2ae473c9353f028b51a40d41b573f41272172dd1b9bd882e0642caebd9bb26", "relations": [{"rule": 2, "type": "equivalent", "target": "c4e7dcd1aec9b5613d6d607be4917e0c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0b2ae473c9353f028b51a40d41b573f41272172dd1b9bd882e0642caebd9bb26"}}], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c4e7dcd1aec9b5613d6d607be4917e0c", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Fix bug in json_to_record() when a field of its input object contains a sub-object with a field name matching one of the requested output column names", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0b2ae473c9353f028b51a40d41b573f41272172dd1b9bd882e0642caebd9bb26"}, "url": "/docs/compare/?release=9.4.7#9.4.7-12be466959d2a19b", "source_url": "/docs/release/9.4.7/#AEN122557"}]}, {"id": "9.5.2-d9270e169dffe8f0", "cves": [], "html": "

Fix nonsense result from two-argument form of jsonb_object() when called with empty arrays (Michael Paquier, Andrew Dunstan)

", "text": "Fix nonsense result from two-argument form of jsonb_object() when called with empty arrays (Michael Paquier, Andrew Dunstan)", "title": "Fix nonsense result from two-argument form of jsonb_object() when called with empty arrays", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "636ef565bb9ee45112d21a0bcb0a622a6879363573f273ef17f2596abb43b0d8", "section_path": ["Changes"], "commit_groups": [["68d68ff83", "94c745eb1"]], "identity_text": "Fix nonsense result from two-argument form of jsonb_object() when called with empty arrays (Michael Paquier, Andrew Dunstan)", "commit_aliases": ["68d68ff83", "94c745eb1"], "source_commits": ["68d68ff83"], "source_entry_id": "9.5.2/changes/009", "db_id": "646b31e4268f68e16b0bd9d64f58c6bc", "patch_ids": ["eff56458af615f902c85623b52e76c19"], "statement_hash": "18660ac19123fea997139f1bcc3a1e5056216b40e402895c8ce91a7cd8bbc6f1", "relations": [], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.2-5e5b8476515b7c00", "cves": [], "html": "

Fix misbehavior in jsonb_set() when converting a path array element into an integer for use as an array subscript (Michael Paquier)

", "text": "Fix misbehavior in jsonb_set() when converting a path array element into an integer for use as an array subscript (Michael Paquier)", "title": "Fix misbehavior in jsonb_set() when converting a path array element into an integer for use as an array subscript", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "dff6988a4a01c9b324ee767f30299f867dfcdb476a7eb365b56c4833636f3284", "section_path": ["Changes"], "commit_groups": [["384dfbde1", "5f95521b3"]], "identity_text": "Fix misbehavior in jsonb_set() when converting a path array element into an integer for use as an array subscript (Michael Paquier)", "commit_aliases": ["384dfbde1", "5f95521b3"], "source_commits": ["5f95521b3"], "source_entry_id": "9.5.2/changes/010", "db_id": "230a0aa961d66d770c4905964a110d98", "patch_ids": ["bc3b28ba05f143a8314dde69a19fa778"], "statement_hash": "047f7c6cbbfb521eb180ee97d3bab49f0a0f690bac6c8b46aa93cd88368e7139", "relations": [], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.2-e815b532dacef1d2", "cves": [], "html": "

Fix misformatting of negative time zone offsets by to_char()'s OF format code (Thomas Munro, Tom Lane)

", "text": "Fix misformatting of negative time zone offsets by to_char()'s OF format code (Thomas Munro, Tom Lane)", "title": "Fix misformatting of negative time zone offsets by to_char()'s OF format code", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "0fa6f740d6d3529a1fcb12c90c9c91f8c7dc80ca1e250e64417aad667d1779d6", "section_path": ["Changes"], "commit_groups": [["17a250b18", "55c3a04d6", "d0a585c69"]], "identity_text": "Fix misformatting of negative time zone offsets by to_char()'s OF format code (Thomas Munro, Tom Lane)", "commit_aliases": ["17a250b18", "55c3a04d6", "d0a585c69"], "source_commits": ["d0a585c69"], "source_entry_id": "9.5.2/changes/011", "db_id": "5a86e831c5690c7911ab51d48468842c", "patch_ids": ["2c25b734d50f26e8bb5b7fa182e50bf5"], "statement_hash": "9088b92bf18ecc3bdfc1df2b8f7bbc7ffa21f1f77bfa5b7d1b83a08b6e79ec5a", "relations": [{"rule": 2, "type": "equivalent", "target": "33acdc644575e9fd02cb4991e51086f2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9088b92bf18ecc3bdfc1df2b8f7bbc7ffa21f1f77bfa5b7d1b83a08b6e79ec5a"}}], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "33acdc644575e9fd02cb4991e51086f2", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Fix misformatting of negative time zone offsets by to_char()'s OF format code", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9088b92bf18ecc3bdfc1df2b8f7bbc7ffa21f1f77bfa5b7d1b83a08b6e79ec5a"}, "url": "/docs/compare/?release=9.4.7#9.4.7-e815b532dacef1d2", "source_url": "/docs/release/9.4.7/#AEN122557"}]}, {"id": "9.5.2-97ee8d9e43c37b02", "cves": [], "html": "

Fix possible incorrect logging of waits done by INSERT ... ON CONFLICT (Peter Geoghegan)

\n

Log messages would sometimes claim that the wait was due to an exclusion constraint although no such constraint was responsible.

", "text": "Fix possible incorrect logging of waits done by INSERT ... ON CONFLICT (Peter Geoghegan) Log messages would sometimes claim that the wait was due to an exclusion constraint although no such constraint was responsible.", "title": "Fix possible incorrect logging of waits done by INSERT ... ON CONFLICT", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "8c071ba747db5c1bfb10b321bc17d7373eb4df4104a818b9d7b0ef1bb0404da5", "section_path": ["Changes"], "commit_groups": [["3f14d8d59", "fd658dbb3"]], "identity_text": "Fix possible incorrect logging of waits done by INSERT ... ON CONFLICT (Peter Geoghegan) Log messages would sometimes claim that the wait was due to an exclusion constraint although no such constraint was responsible.", "commit_aliases": ["3f14d8d59", "fd658dbb3"], "source_commits": ["3f14d8d59"], "source_entry_id": "9.5.2/changes/012", "db_id": "fa3e2e8bbdb2c2a8c90af66d7ec1df76", "patch_ids": ["506cfc1cfcb0b9a3523f5ce5862cf09c"], "statement_hash": "74c201999780714a7880364df7101ee8229bfeffcbbcaf53fefca857f1ed6c48", "relations": [], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.2-1f67987adadcaf46", "cves": [], "html": "

Ignore recovery_min_apply_delay parameter until recovery has reached a consistent state (Michael Paquier)

\n

Previously, standby servers would delay application of WAL records in response to recovery_min_apply_delay even while replaying the initial portion of WAL needed to make their database state valid. Since the standby is useless until it's reached a consistent database state, this was deemed unhelpful.

", "text": "Ignore recovery_min_apply_delay parameter until recovery has reached a consistent state (Michael Paquier) Previously, standby servers would delay application of WAL records in response to recovery_min_apply_delay even while replaying the initial portion of WAL needed to make their database state valid. Since the standby is useless until it's reached a consistent database state, this was deemed unhelpful.", "title": "Ignore recovery_min_apply_delay parameter until recovery has reached a consistent state", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "38f3da33424d35bbde30d87d6fb6a02f385f2dbff78d16b00cbe385a4033ad65", "section_path": ["Changes"], "commit_groups": [["a9613ee69", "d34794f7d", "f95f1ce00"]], "identity_text": "Ignore recovery-min-apply-delay parameter until recovery has reached a consistent state (Michael Paquier) Previously, standby servers would delay application of WAL records in response to recovery_min_apply_delay even while replaying the initial portion of WAL needed to make their database state valid. Since the standby is useless until it's reached a consistent database state, this was deemed unhelpful.", "commit_aliases": ["a9613ee69", "d34794f7d", "f95f1ce00"], "source_commits": ["f95f1ce00"], "source_entry_id": "9.5.2/changes/013", "db_id": "b691817565939e087ebbf6f5a5c34b92", "patch_ids": ["79ca0306da9ee3d46c21fa14786c5b9e"], "statement_hash": "a5e8e5c9da2cf9115c00eec76cc41dffcad53ea25b3648926e4b71f39f0e59d6", "relations": [{"rule": 2, "type": "equivalent", "target": "9e0ee9977dc4d09e2e90e554e5d8009c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a5e8e5c9da2cf9115c00eec76cc41dffcad53ea25b3648926e4b71f39f0e59d6"}}], "version": "9.5.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "9e0ee9977dc4d09e2e90e554e5d8009c", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Ignore recovery_min_apply_delay parameter until recovery has reached a consistent state", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a5e8e5c9da2cf9115c00eec76cc41dffcad53ea25b3648926e4b71f39f0e59d6"}, "url": "/docs/compare/?release=9.4.7#9.4.7-1f67987adadcaf46", "source_url": "/docs/release/9.4.7/#AEN122557"}]}, {"id": "9.5.2-c36e51e765a26d1d", "cves": [], "html": "

Correctly handle cases where pg_subtrans is close to XID wraparound during server startup (Jeff Janes)

", "text": "Correctly handle cases where pg_subtrans is close to XID wraparound during server startup (Jeff Janes)", "title": "Correctly handle cases where pg_subtrans is close to XID wraparound during server startup", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "1f989d7d97bdca5803fe31bfebe936c9f11cbd0a28ebb7ae2c81554ad5b31aa3", "section_path": ["Changes"], "commit_groups": [["481725c0b", "6830cae5f", "71e3cff2e", "c063d3c43", "c479024d3", "ca32f125b"]], "identity_text": "Correctly handle cases where pg_subtrans is close to XID wraparound during server startup (Jeff Janes)", "commit_aliases": ["481725c0b", "6830cae5f", "71e3cff2e", "c063d3c43", "c479024d3", "ca32f125b"], "source_commits": ["c479024d3"], "source_entry_id": "9.5.2/changes/014", "db_id": "edde2d207ba61807520cac74c0ead514", "patch_ids": ["ea858193ebee1dce9c283c88bb411c9e"], "statement_hash": "0158441d73b68354dbc20f46732c51a45faf732b80c65bad0074da15750fd45f", "relations": [{"rule": 2, "type": "equivalent", "target": "2b09b6fa046ed8bd01564446564b4b61", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0158441d73b68354dbc20f46732c51a45faf732b80c65bad0074da15750fd45f"}}, {"rule": 2, "type": "equivalent", "target": "3fde9b8a31c98892454ad1413d29137a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0158441d73b68354dbc20f46732c51a45faf732b80c65bad0074da15750fd45f"}}, {"rule": 2, "type": "equivalent", "target": "81a9826977181e23621a765e7e44682e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0158441d73b68354dbc20f46732c51a45faf732b80c65bad0074da15750fd45f"}}, {"rule": 2, "type": "equivalent", "target": "bc2156c60c4cbf304d2e93eed86e8716", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0158441d73b68354dbc20f46732c51a45faf732b80c65bad0074da15750fd45f"}}], "version": "9.5.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "2b09b6fa046ed8bd01564446564b4b61", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Correctly handle cases where pg_subtrans is close to XID wraparound during server startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0158441d73b68354dbc20f46732c51a45faf732b80c65bad0074da15750fd45f"}, "url": "/docs/compare/?release=9.4.7#9.4.7-c36e51e765a26d1d", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "81a9826977181e23621a765e7e44682e", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "Correctly handle cases where pg_subtrans is close to XID wraparound during server startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0158441d73b68354dbc20f46732c51a45faf732b80c65bad0074da15750fd45f"}, "url": "/docs/compare/?release=9.3.12#9.3.12-c36e51e765a26d1d", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "bc2156c60c4cbf304d2e93eed86e8716", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "Correctly handle cases where pg_subtrans is close to XID wraparound during server startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0158441d73b68354dbc20f46732c51a45faf732b80c65bad0074da15750fd45f"}, "url": "/docs/compare/?release=9.2.16#9.2.16-c36e51e765a26d1d", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "3fde9b8a31c98892454ad1413d29137a", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "Correctly handle cases where pg_subtrans is close to XID wraparound during server startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0158441d73b68354dbc20f46732c51a45faf732b80c65bad0074da15750fd45f"}, "url": "/docs/compare/?release=9.1.21#9.1.21-c36e51e765a26d1d", "source_url": "/docs/release/9.1.21/#AEN107251"}]}, {"id": "9.5.2-d1888ca5fd203d39", "cves": [], "html": "

Fix assorted bugs in logical decoding (Andres Freund)

\n

Trouble cases included tuples larger than one page when replica identity is FULL, UPDATEs that change a primary key within a transaction large enough to be spooled to disk, incorrect reports of \"subxact logged without previous toplevel record\", and incorrect reporting of a transaction's commit time.

", "text": "Fix assorted bugs in logical decoding (Andres Freund) Trouble cases included tuples larger than one page when replica identity is FULL, UPDATEs that change a primary key within a transaction large enough to be spooled to disk, incorrect reports of \"subxact logged without previous toplevel record\", and incorrect reporting of a transaction's commit time.", "title": "Fix assorted bugs in logical decoding", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "03a7e90297c013e621bd42855aaaec7717e1d56f9c9e01f259d8bf0871dfc3b5", "section_path": ["Changes"], "commit_groups": [["0bda14d54", "a50f50a65", "e76e365be"], ["250e5bd71", "b63bea5fd", "e3e84fd35"], ["3b94b3a49", "5990a034a", "c8f621c43"], ["465dd92d9", "6e759cefe", "d9e903f3c"], ["5d1826fe7", "fb3ea0465", "fd45d16f6"], ["7c17aac69", "f8a75881f"]], "identity_text": "Fix assorted bugs in logical decoding (Andres Freund) Trouble cases included tuples larger than one page when replica identity is FULL, UPDATEs that change a primary key within a transaction large enough to be spooled to disk, incorrect reports of subxact logged without previous toplevel record, and incorrect reporting of a transaction's commit time.", "commit_aliases": ["0bda14d54", "250e5bd71", "3b94b3a49", "465dd92d9", "5990a034a", "5d1826fe7", "6e759cefe", "7c17aac69", "a50f50a65", "b63bea5fd", "c8f621c43", "d9e903f3c", "e3e84fd35", "e76e365be", "f8a75881f", "fb3ea0465", "fd45d16f6"], "source_commits": ["250e5bd71", "5990a034a", "5d1826fe7", "6e759cefe", "e76e365be", "f8a75881f"], "source_entry_id": "9.5.2/changes/015", "db_id": "c7c7ec1b553742e8f690553f7d4cb814", "patch_ids": ["07e438bd82c8c9cae9938827436f8ff9", "2df3b5726eab7c6c5b93c4d73de09242", "66a8a046f7b950c72d677ab613cc32b4", "bc120e66724171521f24f0aac01aec6d", "ccaff44b679b7fc0b095657912204c41", "d3cad63feb1e81093b86e69352712e0c"], "statement_hash": "2312da4f60220c490df959cb263ac933619d759f817dec76ded8c36eeebbadd0", "relations": [{"rule": 2, "type": "equivalent", "target": "3bf401c3ad350e91cbe2a85de0fd9f03", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2312da4f60220c490df959cb263ac933619d759f817dec76ded8c36eeebbadd0"}}], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "3bf401c3ad350e91cbe2a85de0fd9f03", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Fix assorted bugs in logical decoding", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2312da4f60220c490df959cb263ac933619d759f817dec76ded8c36eeebbadd0"}, "url": "/docs/compare/?release=9.4.7#9.4.7-d1888ca5fd203d39", "source_url": "/docs/release/9.4.7/#AEN122557"}]}, {"id": "9.5.2-86e89ff70e2c222b", "cves": [], "html": "

Fix planner error with nested security barrier views when the outer view has a WHERE clause containing a correlated subquery (Dean Rasheed)

", "text": "Fix planner error with nested security barrier views when the outer view has a WHERE clause containing a correlated subquery (Dean Rasheed)", "title": "Fix planner error with nested security barrier views when the outer view has a WHERE clause containing a correlated subquery", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "0736ed5ff13957583cd82b82f57cd81cba5c68b2fa10f47a7a3b60ac2d5b4b00", "section_path": ["Changes"], "commit_groups": [["41fedc246", "9b69d5c1d", "f1dfcf63d"]], "identity_text": "Fix planner error with nested security barrier views when the outer view has a WHERE clause containing a correlated subquery (Dean Rasheed)", "commit_aliases": ["41fedc246", "9b69d5c1d", "f1dfcf63d"], "source_commits": ["f1dfcf63d"], "source_entry_id": "9.5.2/changes/016", "db_id": "46e18df8a2978a020ccb59a43ce89221", "patch_ids": ["319f2df54feeb30270ce554781e44137"], "statement_hash": "19e1f73da124c9118483898fb889d7873cc7d4acb82b3af5d196158b0433f903", "relations": [{"rule": 2, "type": "equivalent", "target": "b5b6188dad1c87544a812a3a8902330a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "19e1f73da124c9118483898fb889d7873cc7d4acb82b3af5d196158b0433f903"}}], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "b5b6188dad1c87544a812a3a8902330a", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Fix planner error with nested security barrier views when the outer view has a WHERE clause containing a correlated subquery", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "19e1f73da124c9118483898fb889d7873cc7d4acb82b3af5d196158b0433f903"}, "url": "/docs/compare/?release=9.4.7#9.4.7-86e89ff70e2c222b", "source_url": "/docs/release/9.4.7/#AEN122557"}]}, {"id": "9.5.2-34aa22c32b4e9796", "cves": [], "html": "

Fix memory leak in GIN index searches (Tom Lane)

", "text": "Fix memory leak in GIN index searches (Tom Lane)", "title": "Fix memory leak in GIN index searches", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "6742ab6ab6b7b4fa53eb43bd09c9f4973bd3422013ceb739f086d46d7bcdc848", "section_path": ["Changes"], "commit_groups": [["aa9c4e71c", "ab4ff2889"]], "identity_text": "Fix memory leak in GIN index searches (Tom Lane)", "commit_aliases": ["aa9c4e71c", "ab4ff2889"], "source_commits": ["aa9c4e71c"], "source_entry_id": "9.5.2/changes/017", "db_id": "cf6bb17373d6e325f4234cb2a92d06a7", "patch_ids": ["af8d30fd928feae8df6640dfaa492f6f"], "statement_hash": "47175c73bb9a6abafe8592b7c822a2929e4c13a030b9a7856685d5acf2414be4", "relations": [], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.2-5cbd9ce64d7e693d", "cves": [], "html": "

Fix corner-case crash due to trying to free localeconv() output strings more than once (Tom Lane)

", "text": "Fix corner-case crash due to trying to free localeconv() output strings more than once (Tom Lane)", "title": "Fix corner-case crash due to trying to free localeconv() output strings more than once", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "c56d93ae0302eb2cecb534060f020deb8de094011052375b74f3e9077909622c", "section_path": ["Changes"], "commit_groups": [["0c4457de8", "2d43c45e9", "47792639c", "7d6c58aa1", "80c925c7b", "907e4dd2b"]], "identity_text": "Fix corner-case crash due to trying to free localeconv() output strings more than once (Tom Lane)", "commit_aliases": ["0c4457de8", "2d43c45e9", "47792639c", "7d6c58aa1", "80c925c7b", "907e4dd2b"], "source_commits": ["2d43c45e9"], "source_entry_id": "9.5.2/changes/018", "db_id": "28908ba79b9c1e5bb55d3ae675261b3e", "patch_ids": ["f6386134927ac6e8dff7e0dee3ce6aa7"], "statement_hash": "8cd14a267756bfdbb1d5a62d534a859316635c4bf51ccc8c8a8081382f673c86", "relations": [{"rule": 2, "type": "equivalent", "target": "1e16994993bbc7623cb98bcfe96b28d4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8cd14a267756bfdbb1d5a62d534a859316635c4bf51ccc8c8a8081382f673c86"}}, {"rule": 2, "type": "equivalent", "target": "235a516decf1402498291a6d4f402c91", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8cd14a267756bfdbb1d5a62d534a859316635c4bf51ccc8c8a8081382f673c86"}}, {"rule": 2, "type": "equivalent", "target": "669e54092457faa0ba706b9875baefca", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8cd14a267756bfdbb1d5a62d534a859316635c4bf51ccc8c8a8081382f673c86"}}, {"rule": 2, "type": "equivalent", "target": "ba10a02a98eb847f645b4cd5daf06a7a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8cd14a267756bfdbb1d5a62d534a859316635c4bf51ccc8c8a8081382f673c86"}}], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "ba10a02a98eb847f645b4cd5daf06a7a", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Fix corner-case crash due to trying to free localeconv() output strings more than once", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8cd14a267756bfdbb1d5a62d534a859316635c4bf51ccc8c8a8081382f673c86"}, "url": "/docs/compare/?release=9.4.7#9.4.7-5cbd9ce64d7e693d", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "235a516decf1402498291a6d4f402c91", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "Fix corner-case crash due to trying to free localeconv() output strings more than once", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8cd14a267756bfdbb1d5a62d534a859316635c4bf51ccc8c8a8081382f673c86"}, "url": "/docs/compare/?release=9.3.12#9.3.12-5cbd9ce64d7e693d", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "669e54092457faa0ba706b9875baefca", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "Fix corner-case crash due to trying to free localeconv() output strings more than once", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8cd14a267756bfdbb1d5a62d534a859316635c4bf51ccc8c8a8081382f673c86"}, "url": "/docs/compare/?release=9.2.16#9.2.16-5cbd9ce64d7e693d", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "1e16994993bbc7623cb98bcfe96b28d4", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "Fix corner-case crash due to trying to free localeconv() output strings more than once", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8cd14a267756bfdbb1d5a62d534a859316635c4bf51ccc8c8a8081382f673c86"}, "url": "/docs/compare/?release=9.1.21#9.1.21-5cbd9ce64d7e693d", "source_url": "/docs/release/9.1.21/#AEN107251"}]}, {"id": "9.5.2-57b41530221e293d", "cves": [], "html": "

Fix parsing of affix files for ispell dictionaries (Tom Lane)

\n

The code could go wrong if the affix file contained any characters whose byte length changes during case-folding, for example I in Turkish UTF8 locales.

", "text": "Fix parsing of affix files for ispell dictionaries (Tom Lane) The code could go wrong if the affix file contained any characters whose byte length changes during case-folding, for example I in Turkish UTF8 locales.", "title": "Fix parsing of affix files for ispell dictionaries", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "62950ca3270b8b55d8ca7d8fb1dc5719bafb6a8a019f3c52e4b9b005f0c5b861", "section_path": ["Changes"], "commit_groups": [["3fa4715c5", "8894c9f79", "a35f85a52", "b3e05097e", "c2d61adc3", "fe747b741"]], "identity_text": "Fix parsing of affix files for ispell dictionaries (Tom Lane) The code could go wrong if the affix file contained any characters whose byte length changes during case-folding, for example I in Turkish UTF8 locales.", "commit_aliases": ["3fa4715c5", "8894c9f79", "a35f85a52", "b3e05097e", "c2d61adc3", "fe747b741"], "source_commits": ["c2d61adc3"], "source_entry_id": "9.5.2/changes/019", "db_id": "76586173c2650432008d4e8966144dab", "patch_ids": ["57af1df2cdfef650075af96700a016d7"], "statement_hash": "91b9f322747a4aaf1fd71d40ce554d8ba153d4e3c9be1d862c6cec405450cdfb", "relations": [{"rule": 2, "type": "equivalent", "target": "60f40d6665f2eda889115b868df32ea0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "91b9f322747a4aaf1fd71d40ce554d8ba153d4e3c9be1d862c6cec405450cdfb"}}, {"rule": 2, "type": "equivalent", "target": "c6a8dff9325306582b92037ebbd4684e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "91b9f322747a4aaf1fd71d40ce554d8ba153d4e3c9be1d862c6cec405450cdfb"}}, {"rule": 2, "type": "equivalent", "target": "ca82c2d5aa89d76f1c86f8c722bc8c98", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "91b9f322747a4aaf1fd71d40ce554d8ba153d4e3c9be1d862c6cec405450cdfb"}}, {"rule": 2, "type": "equivalent", "target": "e0bfc50bf2c245d8978a0af0edcf816f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "91b9f322747a4aaf1fd71d40ce554d8ba153d4e3c9be1d862c6cec405450cdfb"}}], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c6a8dff9325306582b92037ebbd4684e", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Fix parsing of affix files for ispell dictionaries", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "91b9f322747a4aaf1fd71d40ce554d8ba153d4e3c9be1d862c6cec405450cdfb"}, "url": "/docs/compare/?release=9.4.7#9.4.7-57b41530221e293d", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "ca82c2d5aa89d76f1c86f8c722bc8c98", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "Fix parsing of affix files for ispell dictionaries", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "91b9f322747a4aaf1fd71d40ce554d8ba153d4e3c9be1d862c6cec405450cdfb"}, "url": "/docs/compare/?release=9.3.12#9.3.12-57b41530221e293d", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "60f40d6665f2eda889115b868df32ea0", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "Fix parsing of affix files for ispell dictionaries", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "91b9f322747a4aaf1fd71d40ce554d8ba153d4e3c9be1d862c6cec405450cdfb"}, "url": "/docs/compare/?release=9.2.16#9.2.16-57b41530221e293d", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "e0bfc50bf2c245d8978a0af0edcf816f", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "Fix parsing of affix files for ispell dictionaries", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "91b9f322747a4aaf1fd71d40ce554d8ba153d4e3c9be1d862c6cec405450cdfb"}, "url": "/docs/compare/?release=9.1.21#9.1.21-57b41530221e293d", "source_url": "/docs/release/9.1.21/#AEN107251"}]}, {"id": "9.5.2-4a7ef100c19d55e9", "cves": [], "html": "

Avoid use of sscanf() to parse ispell dictionary files (Artur Zakirov)

\n

This dodges a portability problem on FreeBSD-derived platforms (including macOS).

", "text": "Avoid use of sscanf() to parse ispell dictionary files (Artur Zakirov) This dodges a portability problem on FreeBSD-derived platforms (including macOS).", "title": "Avoid use of sscanf() to parse ispell dictionary files", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "4c380c84cebce887e35f906d2b39e79240d06735f955c2dd9e7a0daaf3726e01", "section_path": ["Changes"], "commit_groups": [["19e469410", "24ce5754a", "51e78ab4f", "64f99a2ee", "b10635bb5", "e56acbe2a"]], "identity_text": "Avoid use of sscanf() to parse ispell dictionary files (Artur Zakirov) This dodges a portability problem on FreeBSD-derived platforms (including macOS).", "commit_aliases": ["19e469410", "24ce5754a", "51e78ab4f", "64f99a2ee", "b10635bb5", "e56acbe2a"], "source_commits": ["b10635bb5"], "source_entry_id": "9.5.2/changes/020", "db_id": "5139f4844fa6b2876ad917eab539c98c", "patch_ids": ["4c56633e005b1072f6889ca57bb2b527"], "statement_hash": "06140c81127637c6f34b0b8196e40fa3bdbeadfd0427afda8fac298b64b70dc0", "relations": [{"rule": 2, "type": "equivalent", "target": "8342501c11463266bbc84589eef9babd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "06140c81127637c6f34b0b8196e40fa3bdbeadfd0427afda8fac298b64b70dc0"}}, {"rule": 2, "type": "equivalent", "target": "a076e4e7bdc2b958d21081b9ecf089b4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "06140c81127637c6f34b0b8196e40fa3bdbeadfd0427afda8fac298b64b70dc0"}}, {"rule": 2, "type": "equivalent", "target": "af2c1f2e6140b269e64299e51a2e2735", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "06140c81127637c6f34b0b8196e40fa3bdbeadfd0427afda8fac298b64b70dc0"}}, {"rule": 2, "type": "equivalent", "target": "b7cc67e5e207ac3296a14d59932ed1e5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "06140c81127637c6f34b0b8196e40fa3bdbeadfd0427afda8fac298b64b70dc0"}}], "version": "9.5.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b7cc67e5e207ac3296a14d59932ed1e5", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Avoid use of sscanf() to parse ispell dictionary files", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "06140c81127637c6f34b0b8196e40fa3bdbeadfd0427afda8fac298b64b70dc0"}, "url": "/docs/compare/?release=9.4.7#9.4.7-4a7ef100c19d55e9", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "8342501c11463266bbc84589eef9babd", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "Avoid use of sscanf() to parse ispell dictionary files", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "06140c81127637c6f34b0b8196e40fa3bdbeadfd0427afda8fac298b64b70dc0"}, "url": "/docs/compare/?release=9.3.12#9.3.12-4a7ef100c19d55e9", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "a076e4e7bdc2b958d21081b9ecf089b4", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "Avoid use of sscanf() to parse ispell dictionary files", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "06140c81127637c6f34b0b8196e40fa3bdbeadfd0427afda8fac298b64b70dc0"}, "url": "/docs/compare/?release=9.2.16#9.2.16-4a7ef100c19d55e9", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "af2c1f2e6140b269e64299e51a2e2735", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "Avoid use of sscanf() to parse ispell dictionary files", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "06140c81127637c6f34b0b8196e40fa3bdbeadfd0427afda8fac298b64b70dc0"}, "url": "/docs/compare/?release=9.1.21#9.1.21-4a7ef100c19d55e9", "source_url": "/docs/release/9.1.21/#AEN107251"}]}, {"id": "9.5.2-1838248320a517aa", "cves": [], "html": "

Fix atomic-operations code used on PPC with IBM's xlc compiler (Noah Misch)

\n

This error led to rare failures of concurrent operations on that platform.

", "text": "Fix atomic-operations code used on PPC with IBM's xlc compiler (Noah Misch) This error led to rare failures of concurrent operations on that platform.", "title": "Fix atomic-operations code used on PPC with IBM's xlc compiler", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "7f1384768a2a926c2964dcf27382b78013176dbffd1a9d777212081d136b7076", "section_path": ["Changes"], "commit_groups": [["377a1af56", "5882ca668"]], "identity_text": "Fix atomic-operations code used on PPC with IBM's xlc compiler (Noah Misch) This error led to rare failures of concurrent operations on that platform.", "commit_aliases": ["377a1af56", "5882ca668"], "source_commits": ["377a1af56"], "source_entry_id": "9.5.2/changes/021", "db_id": "d20f1ff2bf7c119f89b8042f164d936e", "patch_ids": ["74ce0ead7a4adf71e382c84115b5c6c0"], "statement_hash": "33af02d4552bd20ee055099bf950f40f5ba9a0eabf85c84900a543ec3b1db991", "relations": [], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.2-4f9b0b94451952a3", "cves": [], "html": "

Avoid a crash on old Windows versions (before 7SP1/2008R2SP1) with an AVX2-capable CPU and a Postgres build done with Visual Studio 2013 (Christian Ullrich)

\n

This is a workaround for a bug in Visual Studio 2013's runtime library, which Microsoft have stated they will not fix in that version.

", "text": "Avoid a crash on old Windows versions (before 7SP1/2008R2SP1) with an AVX2-capable CPU and a Postgres build done with Visual Studio 2013 (Christian Ullrich) This is a workaround for a bug in Visual Studio 2013's runtime library, which Microsoft have stated they will not fix in that version.", "title": "Avoid a crash on old Windows versions (before 7SP1/2008R2SP1) with an AVX2-capable CPU and a Postgres build done with Visual Studio 2013", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "c53e1ec4378136ae81183fb56c0f34a21916b3a4b0f3e148ddb1da421611766f", "section_path": ["Changes"], "commit_groups": [["270d8a12e", "3e6385e27", "78b597808", "8857488b6", "9d9038824", "ad9a15d3f"]], "identity_text": "Avoid a crash on old Windows versions (before 7SP1/2008R2SP1) with an AVX2-capable CPU and a Postgres build done with Visual Studio 2013 (Christian Ullrich) This is a workaround for a bug in Visual Studio 2013's runtime library, which Microsoft have stated they will not fix in that version.", "commit_aliases": ["270d8a12e", "3e6385e27", "78b597808", "8857488b6", "9d9038824", "ad9a15d3f"], "source_commits": ["ad9a15d3f"], "source_entry_id": "9.5.2/changes/022", "db_id": "0a5a919cea37eb591575f80c20998e8b", "patch_ids": ["c1a8901c1ec78335e5ca260f02d0fe2d"], "statement_hash": "a29aab8615c280500bd3f14f488e61ca7c8836f9983df15092c5fdae99b9cf60", "relations": [{"rule": 2, "type": "equivalent", "target": "12c9f1dae306af82d9c2358a6fcf14a3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a29aab8615c280500bd3f14f488e61ca7c8836f9983df15092c5fdae99b9cf60"}}, {"rule": 2, "type": "equivalent", "target": "7f61ba8f775e71e515bad2fd9a6ee267", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a29aab8615c280500bd3f14f488e61ca7c8836f9983df15092c5fdae99b9cf60"}}, {"rule": 2, "type": "equivalent", "target": "bf7b51735f20090f3fca477596063a5e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a29aab8615c280500bd3f14f488e61ca7c8836f9983df15092c5fdae99b9cf60"}}, {"rule": 2, "type": "equivalent", "target": "f27e6e530c2890c80f9f0ce1c3199bee", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a29aab8615c280500bd3f14f488e61ca7c8836f9983df15092c5fdae99b9cf60"}}], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "bf7b51735f20090f3fca477596063a5e", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Avoid a crash on old Windows versions (before 7SP1/2008R2SP1) with an AVX2-capable CPU and a Postgres build done with Visual Studio 2013", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a29aab8615c280500bd3f14f488e61ca7c8836f9983df15092c5fdae99b9cf60"}, "url": "/docs/compare/?release=9.4.7#9.4.7-4f9b0b94451952a3", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "7f61ba8f775e71e515bad2fd9a6ee267", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "Avoid a crash on old Windows versions (before 7SP1/2008R2SP1) with an AVX2-capable CPU and a Postgres build done with Visual Studio 2013", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a29aab8615c280500bd3f14f488e61ca7c8836f9983df15092c5fdae99b9cf60"}, "url": "/docs/compare/?release=9.3.12#9.3.12-4f9b0b94451952a3", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "f27e6e530c2890c80f9f0ce1c3199bee", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "Avoid a crash on old Windows versions (before 7SP1/2008R2SP1) with an AVX2-capable CPU and a Postgres build done with Visual Studio 2013", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a29aab8615c280500bd3f14f488e61ca7c8836f9983df15092c5fdae99b9cf60"}, "url": "/docs/compare/?release=9.2.16#9.2.16-4f9b0b94451952a3", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "12c9f1dae306af82d9c2358a6fcf14a3", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "Avoid a crash on old Windows versions (before 7SP1/2008R2SP1) with an AVX2-capable CPU and a Postgres build done with Visual Studio 2013", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a29aab8615c280500bd3f14f488e61ca7c8836f9983df15092c5fdae99b9cf60"}, "url": "/docs/compare/?release=9.1.21#9.1.21-4f9b0b94451952a3", "source_url": "/docs/release/9.1.21/#AEN107251"}]}, {"id": "9.5.2-1ef5c45fd7fbed0c", "cves": [], "html": "

Fix psql's tab completion logic to handle multibyte characters properly (Kyotaro Horiguchi, Robert Haas)

", "text": "Fix psql's tab completion logic to handle multibyte characters properly (Kyotaro Horiguchi, Robert Haas)", "title": "Fix psql's tab completion logic to handle multibyte characters properly", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "d56e884eba8ad8aece7f9bcb274d9ec8091b58f7a043ace717116269d2c4604d", "section_path": ["Changes"], "commit_groups": [["0315dfa8f", "54139ac22", "8de488d00", "9445db925", "b4895bf79", "c658d5a9b"]], "identity_text": "Fix psql's tab completion logic to handle multibyte characters properly (Kyotaro Horiguchi, Robert Haas)", "commit_aliases": ["0315dfa8f", "54139ac22", "8de488d00", "9445db925", "b4895bf79", "c658d5a9b"], "source_commits": ["0315dfa8f"], "source_entry_id": "9.5.2/changes/023", "db_id": "05039f3be720eaebbfdb8a768f4c3528", "patch_ids": ["8476c6391191d802fa8756f81e438ef5"], "statement_hash": "c109770e055ca5188d5c682d8d264e37c7c864e36ecdcc096a554baa44e4c88c", "relations": [{"rule": 2, "type": "equivalent", "target": "908087803e3a5dfed04a6c9765911d40", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c109770e055ca5188d5c682d8d264e37c7c864e36ecdcc096a554baa44e4c88c"}}, {"rule": 2, "type": "equivalent", "target": "929e94972cd3e7215325f627736556d9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c109770e055ca5188d5c682d8d264e37c7c864e36ecdcc096a554baa44e4c88c"}}, {"rule": 2, "type": "equivalent", "target": "e67ac613545bfcb35b6dc5b547898977", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c109770e055ca5188d5c682d8d264e37c7c864e36ecdcc096a554baa44e4c88c"}}, {"rule": 2, "type": "equivalent", "target": "f03ece35225e3c129b3cf2889a6bbb8a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c109770e055ca5188d5c682d8d264e37c7c864e36ecdcc096a554baa44e4c88c"}}], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "929e94972cd3e7215325f627736556d9", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Fix psql's tab completion logic to handle multibyte characters properly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c109770e055ca5188d5c682d8d264e37c7c864e36ecdcc096a554baa44e4c88c"}, "url": "/docs/compare/?release=9.4.7#9.4.7-1ef5c45fd7fbed0c", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "e67ac613545bfcb35b6dc5b547898977", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "Fix psql's tab completion logic to handle multibyte characters properly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c109770e055ca5188d5c682d8d264e37c7c864e36ecdcc096a554baa44e4c88c"}, "url": "/docs/compare/?release=9.3.12#9.3.12-1ef5c45fd7fbed0c", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "908087803e3a5dfed04a6c9765911d40", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "Fix psql's tab completion logic to handle multibyte characters properly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c109770e055ca5188d5c682d8d264e37c7c864e36ecdcc096a554baa44e4c88c"}, "url": "/docs/compare/?release=9.2.16#9.2.16-1ef5c45fd7fbed0c", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "f03ece35225e3c129b3cf2889a6bbb8a", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "Fix psql's tab completion logic to handle multibyte characters properly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c109770e055ca5188d5c682d8d264e37c7c864e36ecdcc096a554baa44e4c88c"}, "url": "/docs/compare/?release=9.1.21#9.1.21-1ef5c45fd7fbed0c", "source_url": "/docs/release/9.1.21/#AEN107251"}]}, {"id": "9.5.2-ab9536ca3b0f9367", "cves": [], "html": "

Fix psql's tab completion for SECURITY LABEL (Tom Lane)

\n

Pressing TAB after SECURITY LABEL might cause a crash or offering of inappropriate keywords.

", "text": "Fix psql's tab completion for SECURITY LABEL (Tom Lane) Pressing TAB after SECURITY LABEL might cause a crash or offering of inappropriate keywords.", "title": "Fix psql's tab completion for SECURITY LABEL", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "0093c19fb3d68779906db6f622d1fa8894d2ebe013cce808ea59e381a1a2148d", "section_path": ["Changes"], "commit_groups": [["0576de5c7", "13108dd0e", "1bee54e51", "2d61d88d8", "39b3ea714"]], "identity_text": "Fix psql's tab completion for SECURITY LABEL (Tom Lane) Pressing TAB after SECURITY LABEL might cause a crash or offering of inappropriate keywords.", "commit_aliases": ["0576de5c7", "13108dd0e", "1bee54e51", "2d61d88d8", "39b3ea714"], "source_commits": ["1bee54e51"], "source_entry_id": "9.5.2/changes/024", "db_id": "330fce3a940bb76dfe4ae4670f52dcf0", "patch_ids": ["44ef66919a33b2ae7be4a1a918946797"], "statement_hash": "1d6fd89f614b2122f6d609f1ff8e3075cf765c2f12a03ba3947fb0e6b4afd207", "relations": [{"rule": 2, "type": "equivalent", "target": "25b99e768c6a6ff8cc251b5e48dab173", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1d6fd89f614b2122f6d609f1ff8e3075cf765c2f12a03ba3947fb0e6b4afd207"}}, {"rule": 2, "type": "equivalent", "target": "2f7b7917801d1d02befe7d82d3f66b82", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1d6fd89f614b2122f6d609f1ff8e3075cf765c2f12a03ba3947fb0e6b4afd207"}}, {"rule": 2, "type": "equivalent", "target": "33cdf93285ebc9e8fdaaa7fb1d88942a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1d6fd89f614b2122f6d609f1ff8e3075cf765c2f12a03ba3947fb0e6b4afd207"}}, {"rule": 2, "type": "equivalent", "target": "b37868f34b15e59b920d0b227549b9bb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1d6fd89f614b2122f6d609f1ff8e3075cf765c2f12a03ba3947fb0e6b4afd207"}}], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2f7b7917801d1d02befe7d82d3f66b82", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Fix psql's tab completion for SECURITY LABEL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1d6fd89f614b2122f6d609f1ff8e3075cf765c2f12a03ba3947fb0e6b4afd207"}, "url": "/docs/compare/?release=9.4.7#9.4.7-ab9536ca3b0f9367", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "b37868f34b15e59b920d0b227549b9bb", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "Fix psql's tab completion for SECURITY LABEL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1d6fd89f614b2122f6d609f1ff8e3075cf765c2f12a03ba3947fb0e6b4afd207"}, "url": "/docs/compare/?release=9.3.12#9.3.12-ab9536ca3b0f9367", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "33cdf93285ebc9e8fdaaa7fb1d88942a", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "Fix psql's tab completion for SECURITY LABEL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1d6fd89f614b2122f6d609f1ff8e3075cf765c2f12a03ba3947fb0e6b4afd207"}, "url": "/docs/compare/?release=9.2.16#9.2.16-ab9536ca3b0f9367", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "25b99e768c6a6ff8cc251b5e48dab173", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "Fix psql's tab completion for SECURITY LABEL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1d6fd89f614b2122f6d609f1ff8e3075cf765c2f12a03ba3947fb0e6b4afd207"}, "url": "/docs/compare/?release=9.1.21#9.1.21-ab9536ca3b0f9367", "source_url": "/docs/release/9.1.21/#AEN107251"}]}, {"id": "9.5.2-baa0cb46efa84977", "cves": [], "html": "

Make pg_ctl accept a wait timeout from the PGCTLTIMEOUT environment variable, if none is specified on the command line (Noah Misch)

\n

This eases testing of slower buildfarm members by allowing them to globally specify a longer-than-normal timeout for postmaster startup and shutdown.

", "text": "Make pg_ctl accept a wait timeout from the PGCTLTIMEOUT environment variable, if none is specified on the command line (Noah Misch) This eases testing of slower buildfarm members by allowing them to globally specify a longer-than-normal timeout for postmaster startup and shutdown.", "title": "Make pg_ctl accept a wait timeout from the PGCTLTIMEOUT environment variable, if none is specified on the command line", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "128687b4d70904dfcce68ccf38a7d64b836fa194f5ede960c407125566ba75e4", "section_path": ["Changes"], "commit_groups": [["198242ede", "2ffa86962", "4421b5253", "4492ab53b", "725f0ce29", "f97664cf5"]], "identity_text": "Make pg_ctl accept a wait timeout from the PGCTLTIMEOUT environment variable, if none is specified on the command line (Noah Misch) This eases testing of slower buildfarm members by allowing them to globally specify a longer-than-normal timeout for postmaster startup and shutdown.", "commit_aliases": ["198242ede", "2ffa86962", "4421b5253", "4492ab53b", "725f0ce29", "f97664cf5"], "source_commits": ["725f0ce29"], "source_entry_id": "9.5.2/changes/025", "db_id": "3e3103297f7fc68db95b29dc324cf63a", "patch_ids": ["5255b241438d895fabf84869b87c331e"], "statement_hash": "3c3e7f701f9750eaa417b1b8a4b567eed7838383dde020ece4e47bb715381061", "relations": [{"rule": 2, "type": "equivalent", "target": "015e9ade51f46846b1d306bd50767303", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c3e7f701f9750eaa417b1b8a4b567eed7838383dde020ece4e47bb715381061"}}, {"rule": 2, "type": "equivalent", "target": "52a76d826437999152d53bf7c83a320e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c3e7f701f9750eaa417b1b8a4b567eed7838383dde020ece4e47bb715381061"}}, {"rule": 2, "type": "equivalent", "target": "9cc9b97ba872651502d3c1a593585cf9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c3e7f701f9750eaa417b1b8a4b567eed7838383dde020ece4e47bb715381061"}}, {"rule": 2, "type": "equivalent", "target": "9d3a6b02a5aa0bb2b2fe10cab0073f76", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c3e7f701f9750eaa417b1b8a4b567eed7838383dde020ece4e47bb715381061"}}], "version": "9.5.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "015e9ade51f46846b1d306bd50767303", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Make pg_ctl accept a wait timeout from the PGCTLTIMEOUT environment variable, if none is specified on the command line", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c3e7f701f9750eaa417b1b8a4b567eed7838383dde020ece4e47bb715381061"}, "url": "/docs/compare/?release=9.4.7#9.4.7-baa0cb46efa84977", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "52a76d826437999152d53bf7c83a320e", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "Make pg_ctl accept a wait timeout from the PGCTLTIMEOUT environment variable, if none is specified on the command line", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c3e7f701f9750eaa417b1b8a4b567eed7838383dde020ece4e47bb715381061"}, "url": "/docs/compare/?release=9.3.12#9.3.12-baa0cb46efa84977", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "9cc9b97ba872651502d3c1a593585cf9", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "Make pg_ctl accept a wait timeout from the PGCTLTIMEOUT environment variable, if none is specified on the command line", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c3e7f701f9750eaa417b1b8a4b567eed7838383dde020ece4e47bb715381061"}, "url": "/docs/compare/?release=9.2.16#9.2.16-baa0cb46efa84977", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "9d3a6b02a5aa0bb2b2fe10cab0073f76", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "Make pg_ctl accept a wait timeout from the PGCTLTIMEOUT environment variable, if none is specified on the command line", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c3e7f701f9750eaa417b1b8a4b567eed7838383dde020ece4e47bb715381061"}, "url": "/docs/compare/?release=9.1.21#9.1.21-baa0cb46efa84977", "source_url": "/docs/release/9.1.21/#AEN107251"}]}, {"id": "9.5.2-2ae6ce751a70cf10", "cves": [], "html": "

Fix incorrect test for Windows service status in pg_ctl (Manuel Mathar)

\n

The previous set of minor releases attempted to fix pg_ctl to properly determine whether to send log messages to Window's Event Log, but got the test backwards.

", "text": "Fix incorrect test for Windows service status in pg_ctl (Manuel Mathar) The previous set of minor releases attempted to fix pg_ctl to properly determine whether to send log messages to Window's Event Log, but got the test backwards.", "title": "Fix incorrect test for Windows service status in pg_ctl", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "06b9b66a9fd84169e16f4f79f5caac844b303c80f229141c16161f591afc738f", "section_path": ["Changes"], "commit_groups": [["15d43196c", "45b87cc57", "5a39c7395", "89f8372cb", "b642e50ae", "b73e81605"]], "identity_text": "Fix incorrect test for Windows service status in pg_ctl (Manuel Mathar) The previous set of minor releases attempted to fix pg_ctl to properly determine whether to send log messages to Window's Event Log, but got the test backwards.", "commit_aliases": ["15d43196c", "45b87cc57", "5a39c7395", "89f8372cb", "b642e50ae", "b73e81605"], "source_commits": ["45b87cc57"], "source_entry_id": "9.5.2/changes/026", "db_id": "3fa11732ac1705220018943f03a527bb", "patch_ids": ["fa49e5247dd72c45f4ba2c3116ad4fdf"], "statement_hash": "5f915e3283e4f7a13ad493fdc64a77ec0f2cc184abf6760212d8ec8544cec6fb", "relations": [{"rule": 2, "type": "equivalent", "target": "14b147d92a5360ac5da4cca5c1cd996b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f915e3283e4f7a13ad493fdc64a77ec0f2cc184abf6760212d8ec8544cec6fb"}}, {"rule": 2, "type": "equivalent", "target": "5266004fb3ff87e116d7fa0b4b782fad", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f915e3283e4f7a13ad493fdc64a77ec0f2cc184abf6760212d8ec8544cec6fb"}}, {"rule": 2, "type": "equivalent", "target": "60707bb1e90fab808b81859693f4d9c7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f915e3283e4f7a13ad493fdc64a77ec0f2cc184abf6760212d8ec8544cec6fb"}}, {"rule": 2, "type": "equivalent", "target": "afd79e39a27baaa2d06cca92a65eb4fd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f915e3283e4f7a13ad493fdc64a77ec0f2cc184abf6760212d8ec8544cec6fb"}}], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "afd79e39a27baaa2d06cca92a65eb4fd", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Fix incorrect test for Windows service status in pg_ctl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f915e3283e4f7a13ad493fdc64a77ec0f2cc184abf6760212d8ec8544cec6fb"}, "url": "/docs/compare/?release=9.4.7#9.4.7-2ae6ce751a70cf10", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "60707bb1e90fab808b81859693f4d9c7", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "Fix incorrect test for Windows service status in pg_ctl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f915e3283e4f7a13ad493fdc64a77ec0f2cc184abf6760212d8ec8544cec6fb"}, "url": "/docs/compare/?release=9.3.12#9.3.12-2ae6ce751a70cf10", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "5266004fb3ff87e116d7fa0b4b782fad", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "Fix incorrect test for Windows service status in pg_ctl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f915e3283e4f7a13ad493fdc64a77ec0f2cc184abf6760212d8ec8544cec6fb"}, "url": "/docs/compare/?release=9.2.16#9.2.16-2ae6ce751a70cf10", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "14b147d92a5360ac5da4cca5c1cd996b", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "Fix incorrect test for Windows service status in pg_ctl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f915e3283e4f7a13ad493fdc64a77ec0f2cc184abf6760212d8ec8544cec6fb"}, "url": "/docs/compare/?release=9.1.21#9.1.21-2ae6ce751a70cf10", "source_url": "/docs/release/9.1.21/#AEN107251"}]}, {"id": "9.5.2-7eac88507f0f7149", "cves": [], "html": "

Fix pgbench to correctly handle the combination of -C and -M prepared options (Tom Lane)

", "text": "Fix pgbench to correctly handle the combination of -C and -M prepared options (Tom Lane)", "title": "Fix pgbench to correctly handle the combination of -C and -M prepared options", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "b0c6e6f7373cb4b4203a4ef281dea31e72016a389f67e74e10048ffaf020a0a8", "section_path": ["Changes"], "commit_groups": [["1965a8ce1", "23cb32660", "47211af17", "8ee2e5f78", "be6f9ea2e", "c02aae418"]], "identity_text": "Fix pgbench to correctly handle the combination of -C and -M prepared options (Tom Lane)", "commit_aliases": ["1965a8ce1", "23cb32660", "47211af17", "8ee2e5f78", "be6f9ea2e", "c02aae418"], "source_commits": ["8ee2e5f78"], "source_entry_id": "9.5.2/changes/027", "db_id": "f5b5236200491a54b9c7942a7fdcf1c6", "patch_ids": ["ae341ab945613b0631eaf409340a0fb5"], "statement_hash": "e9c796d5f66966db7fd61486fce08527037870306a859e892aa285596c4c17c8", "relations": [{"rule": 2, "type": "equivalent", "target": "5ea202397e5bc63f4be4231d2351680e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e9c796d5f66966db7fd61486fce08527037870306a859e892aa285596c4c17c8"}}, {"rule": 2, "type": "equivalent", "target": "77936f452cfca78c0b5c84f05d9e42c4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e9c796d5f66966db7fd61486fce08527037870306a859e892aa285596c4c17c8"}}, {"rule": 2, "type": "equivalent", "target": "783b7129442dfff6a593129ed932cb68", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e9c796d5f66966db7fd61486fce08527037870306a859e892aa285596c4c17c8"}}, {"rule": 2, "type": "equivalent", "target": "ff902fb1a17619997ca69802f94ce5e2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e9c796d5f66966db7fd61486fce08527037870306a859e892aa285596c4c17c8"}}], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "77936f452cfca78c0b5c84f05d9e42c4", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Fix pgbench to correctly handle the combination of -C and -M prepared options", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e9c796d5f66966db7fd61486fce08527037870306a859e892aa285596c4c17c8"}, "url": "/docs/compare/?release=9.4.7#9.4.7-7eac88507f0f7149", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "ff902fb1a17619997ca69802f94ce5e2", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "Fix pgbench to correctly handle the combination of -C and -M prepared options", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e9c796d5f66966db7fd61486fce08527037870306a859e892aa285596c4c17c8"}, "url": "/docs/compare/?release=9.3.12#9.3.12-7eac88507f0f7149", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "5ea202397e5bc63f4be4231d2351680e", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "Fix pgbench to correctly handle the combination of -C and -M prepared options", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e9c796d5f66966db7fd61486fce08527037870306a859e892aa285596c4c17c8"}, "url": "/docs/compare/?release=9.2.16#9.2.16-7eac88507f0f7149", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "783b7129442dfff6a593129ed932cb68", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "Fix pgbench to correctly handle the combination of -C and -M prepared options", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e9c796d5f66966db7fd61486fce08527037870306a859e892aa285596c4c17c8"}, "url": "/docs/compare/?release=9.1.21#9.1.21-7eac88507f0f7149", "source_url": "/docs/release/9.1.21/#AEN107251"}]}, {"id": "9.5.2-86a6fbb65935f93c", "cves": [], "html": "

In pg_upgrade, skip creating a deletion script when the new data directory is inside the old data directory (Bruce Momjian)

\n

Blind application of the script in such cases would result in loss of the new data directory.

", "text": "In pg_upgrade, skip creating a deletion script when the new data directory is inside the old data directory (Bruce Momjian) Blind application of the script in such cases would result in loss of the new data directory.", "title": "In pg_upgrade, skip creating a deletion script when the new data directory is inside the old data directory", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "3af3fb0f0b5f6e74f1b5b591313fc1e845cb2de529879e1dfb042c7ffe83a5d1", "section_path": ["Changes"], "commit_groups": [["3386f34cd", "6f43c4d34", "bec4d0ffb", "bf26c4f44"]], "identity_text": "In pg_upgrade, skip creating a deletion script when the new data directory is inside the old data directory (Bruce Momjian) Blind application of the script in such cases would result in loss of the new data directory.", "commit_aliases": ["3386f34cd", "6f43c4d34", "bec4d0ffb", "bf26c4f44"], "source_commits": ["6f43c4d34"], "source_entry_id": "9.5.2/changes/028", "db_id": "f280eb4e3f1c7198dbcde9ffabe24b68", "patch_ids": ["64f11857ff99acb8225a4ec55ddd2e86"], "statement_hash": "9bfc6501fd92ab3f6ac7beb2189709e40319914d2278bd265fbdd5ca5ba9d65f", "relations": [{"rule": 2, "type": "equivalent", "target": "66b6ab9215882c0828986842f03761e1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9bfc6501fd92ab3f6ac7beb2189709e40319914d2278bd265fbdd5ca5ba9d65f"}}, {"rule": 2, "type": "equivalent", "target": "d55e2335c062f411bb106fd4243f5690", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9bfc6501fd92ab3f6ac7beb2189709e40319914d2278bd265fbdd5ca5ba9d65f"}}], "version": "9.5.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "66b6ab9215882c0828986842f03761e1", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "In pg_upgrade, skip creating a deletion script when the new data directory is inside the old data directory", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9bfc6501fd92ab3f6ac7beb2189709e40319914d2278bd265fbdd5ca5ba9d65f"}, "url": "/docs/compare/?release=9.4.7#9.4.7-86a6fbb65935f93c", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "d55e2335c062f411bb106fd4243f5690", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "In pg_upgrade, skip creating a deletion script when the new data directory is inside the old data directory", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9bfc6501fd92ab3f6ac7beb2189709e40319914d2278bd265fbdd5ca5ba9d65f"}, "url": "/docs/compare/?release=9.3.12#9.3.12-86a6fbb65935f93c", "source_url": "/docs/release/9.3.12/#AEN116808"}]}, {"id": "9.5.2-2e2c6311eaec7526", "cves": [], "html": "

In PL/Perl, properly translate empty Postgres arrays into empty Perl arrays (Alex Hunsaker)

", "text": "In PL/Perl, properly translate empty Postgres arrays into empty Perl arrays (Alex Hunsaker)", "title": "In PL/Perl, properly translate empty Postgres arrays into empty Perl arrays", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "7ad58ea4551b1552dfd9dc819664f30ff9d5d6f235026b2ce87fe882c7610625", "section_path": ["Changes"], "commit_groups": [["44f9f1f2d", "6041d388c", "68dababfe", "c5f1fbbfb", "e66197fa2", "ee06c97e4"]], "identity_text": "In PL/Perl, properly translate empty Postgres arrays into empty Perl arrays (Alex Hunsaker)", "commit_aliases": ["44f9f1f2d", "6041d388c", "68dababfe", "c5f1fbbfb", "e66197fa2", "ee06c97e4"], "source_commits": ["68dababfe"], "source_entry_id": "9.5.2/changes/029", "db_id": "c37a865a38dce101c0dd0632f059de35", "patch_ids": ["2918f0e69c754c631442050b992a55fa"], "statement_hash": "9ba992c95929f75b7d110ed1658b5b693b60ab6cf4c08ab73e449edcf44c793e", "relations": [{"rule": 2, "type": "equivalent", "target": "46db9fea72dbf0e47f32bd2e0d1c4244", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba992c95929f75b7d110ed1658b5b693b60ab6cf4c08ab73e449edcf44c793e"}}, {"rule": 2, "type": "equivalent", "target": "87080dd7f94387eb373e7003cd170cd3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba992c95929f75b7d110ed1658b5b693b60ab6cf4c08ab73e449edcf44c793e"}}, {"rule": 2, "type": "equivalent", "target": "bd354c3d34b489612975701fc78b2af2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba992c95929f75b7d110ed1658b5b693b60ab6cf4c08ab73e449edcf44c793e"}}, {"rule": 2, "type": "equivalent", "target": "ef5c5d76994d430a8a57fc1047c0fb87", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba992c95929f75b7d110ed1658b5b693b60ab6cf4c08ab73e449edcf44c793e"}}], "version": "9.5.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "ef5c5d76994d430a8a57fc1047c0fb87", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "In PL/Perl, properly translate empty Postgres arrays into empty Perl arrays", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba992c95929f75b7d110ed1658b5b693b60ab6cf4c08ab73e449edcf44c793e"}, "url": "/docs/compare/?release=9.4.7#9.4.7-2e2c6311eaec7526", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "bd354c3d34b489612975701fc78b2af2", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "In PL/Perl, properly translate empty Postgres arrays into empty Perl arrays", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba992c95929f75b7d110ed1658b5b693b60ab6cf4c08ab73e449edcf44c793e"}, "url": "/docs/compare/?release=9.3.12#9.3.12-2e2c6311eaec7526", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "46db9fea72dbf0e47f32bd2e0d1c4244", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "In PL/Perl, properly translate empty Postgres arrays into empty Perl arrays", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba992c95929f75b7d110ed1658b5b693b60ab6cf4c08ab73e449edcf44c793e"}, "url": "/docs/compare/?release=9.2.16#9.2.16-2e2c6311eaec7526", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "87080dd7f94387eb373e7003cd170cd3", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "In PL/Perl, properly translate empty Postgres arrays into empty Perl arrays", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9ba992c95929f75b7d110ed1658b5b693b60ab6cf4c08ab73e449edcf44c793e"}, "url": "/docs/compare/?release=9.1.21#9.1.21-2e2c6311eaec7526", "source_url": "/docs/release/9.1.21/#AEN107251"}]}, {"id": "9.5.2-812d311819ca1727", "cves": [], "html": "

Make PL/Python cope with function names that aren't valid Python identifiers (Jim Nasby)

", "text": "Make PL/Python cope with function names that aren't valid Python identifiers (Jim Nasby)", "title": "Make PL/Python cope with function names that aren't valid Python identifiers", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "3cf0ba7c6ceac3b8b9fe19a42ea92f23db01243040e976af3b637c10d08a6a57", "section_path": ["Changes"], "commit_groups": [["2ce19f8a5", "66f503868", "7d48349fd", "875973f5d", "b3ec98c8b", "f461fa7d0"]], "identity_text": "Make PL/Python cope with function names that aren't valid Python identifiers (Jim Nasby)", "commit_aliases": ["2ce19f8a5", "66f503868", "7d48349fd", "875973f5d", "b3ec98c8b", "f461fa7d0"], "source_commits": ["2ce19f8a5"], "source_entry_id": "9.5.2/changes/030", "db_id": "2743cc66071dc9bb1be2ce36cd5751ae", "patch_ids": ["021f999d58ad50973f51ca6e10f28979"], "statement_hash": "a163fe870ff975fa4b0e07469eaa2f86b438bd3eca9046047cc3cdb2588b01dc", "relations": [{"rule": 2, "type": "equivalent", "target": "1cb2fb6c72d5cd3026db84494981d9a2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a163fe870ff975fa4b0e07469eaa2f86b438bd3eca9046047cc3cdb2588b01dc"}}, {"rule": 2, "type": "equivalent", "target": "6327a06ad4a84e8447d5ccb69e3a4a93", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a163fe870ff975fa4b0e07469eaa2f86b438bd3eca9046047cc3cdb2588b01dc"}}, {"rule": 2, "type": "equivalent", "target": "defc8ab2c8a3d5f2c4ff4a271c5c866d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a163fe870ff975fa4b0e07469eaa2f86b438bd3eca9046047cc3cdb2588b01dc"}}, {"rule": 2, "type": "equivalent", "target": "e5e1465d0800a8451e752895c6999c38", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a163fe870ff975fa4b0e07469eaa2f86b438bd3eca9046047cc3cdb2588b01dc"}}], "version": "9.5.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "defc8ab2c8a3d5f2c4ff4a271c5c866d", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Make PL/Python cope with function names that aren't valid Python identifiers", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a163fe870ff975fa4b0e07469eaa2f86b438bd3eca9046047cc3cdb2588b01dc"}, "url": "/docs/compare/?release=9.4.7#9.4.7-812d311819ca1727", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "6327a06ad4a84e8447d5ccb69e3a4a93", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "Make PL/Python cope with function names that aren't valid Python identifiers", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a163fe870ff975fa4b0e07469eaa2f86b438bd3eca9046047cc3cdb2588b01dc"}, "url": "/docs/compare/?release=9.3.12#9.3.12-812d311819ca1727", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "1cb2fb6c72d5cd3026db84494981d9a2", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "Make PL/Python cope with function names that aren't valid Python identifiers", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a163fe870ff975fa4b0e07469eaa2f86b438bd3eca9046047cc3cdb2588b01dc"}, "url": "/docs/compare/?release=9.2.16#9.2.16-812d311819ca1727", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "e5e1465d0800a8451e752895c6999c38", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "Make PL/Python cope with function names that aren't valid Python identifiers", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a163fe870ff975fa4b0e07469eaa2f86b438bd3eca9046047cc3cdb2588b01dc"}, "url": "/docs/compare/?release=9.1.21#9.1.21-812d311819ca1727", "source_url": "/docs/release/9.1.21/#AEN107251"}]}, {"id": "9.5.2-babaa3f460759958", "cves": [], "html": "

Fix multiple mistakes in the statistics returned by contrib/pgstattuple's pgstatindex() function (Tom Lane)

", "text": "Fix multiple mistakes in the statistics returned by contrib/pgstattuple's pgstatindex() function (Tom Lane)", "title": "Fix multiple mistakes in the statistics returned by contrib/pgstattuple's pgstatindex() function", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "bdbba9ae9f037f1be18f017bccd6fac1cf9afe42b93c47a0d45ab90ed2864666", "section_path": ["Changes"], "commit_groups": [["0276bbd62", "0f359c7de", "29f299728", "48e6c943e", "9dfb5b940", "b7547166f"]], "identity_text": "Fix multiple mistakes in the statistics returned by contrib/pgstattuple's pgstatindex() function (Tom Lane)", "commit_aliases": ["0276bbd62", "0f359c7de", "29f299728", "48e6c943e", "9dfb5b940", "b7547166f"], "source_commits": ["0276bbd62"], "source_entry_id": "9.5.2/changes/031", "db_id": "df8612e33097be9e1f28ac742d692ffc", "patch_ids": ["9ecee23cd62554d91204ffcb45df49da"], "statement_hash": "7f95a59dda74c81c687886866b6b034b30f6bdaef2211c1641ccaaf7c9e7b2f5", "relations": [{"rule": 2, "type": "equivalent", "target": "4f781d915d20642909263bcc729cdd25", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7f95a59dda74c81c687886866b6b034b30f6bdaef2211c1641ccaaf7c9e7b2f5"}}, {"rule": 2, "type": "equivalent", "target": "99d0798bc013c314df9fdaa71161f84d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7f95a59dda74c81c687886866b6b034b30f6bdaef2211c1641ccaaf7c9e7b2f5"}}, {"rule": 2, "type": "equivalent", "target": "9d2ea0da995c1f6a973344c2297bea92", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7f95a59dda74c81c687886866b6b034b30f6bdaef2211c1641ccaaf7c9e7b2f5"}}, {"rule": 2, "type": "equivalent", "target": "c82ce1cf9224cadc8ae894ae7784f80d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7f95a59dda74c81c687886866b6b034b30f6bdaef2211c1641ccaaf7c9e7b2f5"}}], "version": "9.5.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c82ce1cf9224cadc8ae894ae7784f80d", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Fix multiple mistakes in the statistics returned by contrib/pgstattuple's pgstatindex() function", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7f95a59dda74c81c687886866b6b034b30f6bdaef2211c1641ccaaf7c9e7b2f5"}, "url": "/docs/compare/?release=9.4.7#9.4.7-babaa3f460759958", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "4f781d915d20642909263bcc729cdd25", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "Fix multiple mistakes in the statistics returned by contrib/pgstattuple's pgstatindex() function", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7f95a59dda74c81c687886866b6b034b30f6bdaef2211c1641ccaaf7c9e7b2f5"}, "url": "/docs/compare/?release=9.3.12#9.3.12-babaa3f460759958", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "9d2ea0da995c1f6a973344c2297bea92", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "Fix multiple mistakes in the statistics returned by contrib/pgstattuple's pgstatindex() function", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7f95a59dda74c81c687886866b6b034b30f6bdaef2211c1641ccaaf7c9e7b2f5"}, "url": "/docs/compare/?release=9.2.16#9.2.16-babaa3f460759958", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "99d0798bc013c314df9fdaa71161f84d", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "Fix multiple mistakes in the statistics returned by contrib/pgstattuple's pgstatindex() function", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7f95a59dda74c81c687886866b6b034b30f6bdaef2211c1641ccaaf7c9e7b2f5"}, "url": "/docs/compare/?release=9.1.21#9.1.21-babaa3f460759958", "source_url": "/docs/release/9.1.21/#AEN107251"}]}, {"id": "9.5.2-6aa3459d896d04c8", "cves": [], "html": "

Remove dependency on psed in MSVC builds, since it's no longer provided by core Perl (Michael Paquier, Andrew Dunstan)

", "text": "Remove dependency on psed in MSVC builds, since it's no longer provided by core Perl (Michael Paquier, Andrew Dunstan)", "title": "Remove dependency on psed in MSVC builds, since it's no longer provided by core Perl", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "b6901ebdabbbef0e5d15f0f5800804e39d49cd0da1a58355bc1c958264cbb265", "section_path": ["Changes"], "commit_groups": [["2aa9fd963", "2f38b3e7d", "5d0320105", "6336ca916", "89bf78a9b", "a0adf3852"]], "identity_text": "Remove dependency on psed in MSVC builds, since it's no longer provided by core Perl (Michael Paquier, Andrew Dunstan)", "commit_aliases": ["2aa9fd963", "2f38b3e7d", "5d0320105", "6336ca916", "89bf78a9b", "a0adf3852"], "source_commits": ["2f38b3e7d"], "source_entry_id": "9.5.2/changes/032", "db_id": "3fe9e49777d0e1c4b80678c4b9088c61", "patch_ids": ["671212f4dc813cedf1ca7d4817da82c9"], "statement_hash": "53876e2d019c482ca067c88e9b35480c6ea90d8c106d1dcf82102a4ee05f7b94", "relations": [{"rule": 2, "type": "equivalent", "target": "5fa13ba1ba92ac22571505655aad9031", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "53876e2d019c482ca067c88e9b35480c6ea90d8c106d1dcf82102a4ee05f7b94"}}, {"rule": 2, "type": "equivalent", "target": "afc93e54af7805085cdd71f2fec7a48f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "53876e2d019c482ca067c88e9b35480c6ea90d8c106d1dcf82102a4ee05f7b94"}}, {"rule": 2, "type": "equivalent", "target": "d0e095b1f4354992945fa49d79febe89", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "53876e2d019c482ca067c88e9b35480c6ea90d8c106d1dcf82102a4ee05f7b94"}}, {"rule": 2, "type": "equivalent", "target": "f5f4f708b4bd22692cc17c73f16631e0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "53876e2d019c482ca067c88e9b35480c6ea90d8c106d1dcf82102a4ee05f7b94"}}], "version": "9.5.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "d0e095b1f4354992945fa49d79febe89", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Remove dependency on psed in MSVC builds, since it's no longer provided by core Perl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "53876e2d019c482ca067c88e9b35480c6ea90d8c106d1dcf82102a4ee05f7b94"}, "url": "/docs/compare/?release=9.4.7#9.4.7-6aa3459d896d04c8", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "afc93e54af7805085cdd71f2fec7a48f", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "Remove dependency on psed in MSVC builds, since it's no longer provided by core Perl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "53876e2d019c482ca067c88e9b35480c6ea90d8c106d1dcf82102a4ee05f7b94"}, "url": "/docs/compare/?release=9.3.12#9.3.12-6aa3459d896d04c8", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "5fa13ba1ba92ac22571505655aad9031", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "Remove dependency on psed in MSVC builds, since it's no longer provided by core Perl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "53876e2d019c482ca067c88e9b35480c6ea90d8c106d1dcf82102a4ee05f7b94"}, "url": "/docs/compare/?release=9.2.16#9.2.16-6aa3459d896d04c8", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "f5f4f708b4bd22692cc17c73f16631e0", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "Remove dependency on psed in MSVC builds, since it's no longer provided by core Perl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "53876e2d019c482ca067c88e9b35480c6ea90d8c106d1dcf82102a4ee05f7b94"}, "url": "/docs/compare/?release=9.1.21#9.1.21-6aa3459d896d04c8", "source_url": "/docs/release/9.1.21/#AEN107251"}]}, {"id": "9.5.2-9333eb0670b4b84a", "cves": [], "html": "

Update time zone data files to tzdata release 2016c for DST law changes in Azerbaijan, Chile, Haiti, Palestine, and Russia (Altai, Astrakhan, Kirov, Sakhalin, Ulyanovsk regions), plus historical corrections for Lithuania, Moldova, and Russia (Kaliningrad, Samara, Volgograd).

", "text": "Update time zone data files to tzdata release 2016c for DST law changes in Azerbaijan, Chile, Haiti, Palestine, and Russia (Altai, Astrakhan, Kirov, Sakhalin, Ulyanovsk regions), plus historical corrections for Lithuania, Moldova, and Russia (Kaliningrad, Samara, Volgograd).", "title": "Update time zone data files to tzdata release 2016c for DST law changes in Azerbaijan, Chile, Haiti, Palestine, and Russia (Altai, Astrakhan, Kirov, Sakhalin, Ulyanovsk regions), plus historical corrections for Lithuania, Moldova, and Russia (Kaliningrad, Samara, Volgograd).", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.2/#AEN131101", "source_hash": "001491d3b81576e028f6d9ef6080dce06fd62d33dcfa9c8d2e23ad59d09ceb16", "section_path": ["Changes"], "commit_groups": [["31d02ebf7", "676265eb7", "8e16592d4", "96fa37459", "de371e68a", "e5fd35cc5"]], "identity_text": "Update time zone data files to tzdata release 2016c for DST law changes in Azerbaijan, Chile, Haiti, Palestine, and Russia (Altai, Astrakhan, Kirov, Sakhalin, Ulyanovsk regions), plus historical corrections for Lithuania, Moldova, and Russia (Kaliningrad, Samara, Volgograd).", "commit_aliases": ["31d02ebf7", "676265eb7", "8e16592d4", "96fa37459", "de371e68a", "e5fd35cc5"], "source_commits": ["31d02ebf7"], "source_entry_id": "9.5.2/changes/033", "db_id": "11bcd623c4695ea3676739b08b72d6b9", "patch_ids": ["fb173328d743e2386418ccacf0c56101"], "statement_hash": "622a517e919a21515902322cf894a7f5ff6bb97ca3542babb0bf8a71177d00e0", "relations": [{"rule": 2, "type": "equivalent", "target": "1cfca3d2934db698b31aff12cf0a4f90", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "622a517e919a21515902322cf894a7f5ff6bb97ca3542babb0bf8a71177d00e0"}}, {"rule": 2, "type": "equivalent", "target": "31540a243c445f396514cdadc0987a72", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "622a517e919a21515902322cf894a7f5ff6bb97ca3542babb0bf8a71177d00e0"}}, {"rule": 2, "type": "equivalent", "target": "6831386b58658c333c783df37fedc92f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "622a517e919a21515902322cf894a7f5ff6bb97ca3542babb0bf8a71177d00e0"}}, {"rule": 2, "type": "equivalent", "target": "a7e96d3f5e5d40500670e78d528e0db7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "622a517e919a21515902322cf894a7f5ff6bb97ca3542babb0bf8a71177d00e0"}}], "version": "9.5.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "31540a243c445f396514cdadc0987a72", "kind": "equivalent", "version": "9.4.7", "label": "9.4.7", "title": "Update time zone data files to tzdata release 2016c for DST law changes in Azerbaijan, Chile, Haiti, Palestine, and Russia (Altai, Astrakhan, Kirov, Sakhalin, Ulyanovsk regions), plus historical corrections for Lithuania, Moldova, and Russia (Kaliningrad, Samara, Volgograd).", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "622a517e919a21515902322cf894a7f5ff6bb97ca3542babb0bf8a71177d00e0"}, "url": "/docs/compare/?release=9.4.7#9.4.7-9333eb0670b4b84a", "source_url": "/docs/release/9.4.7/#AEN122557"}, {"db_id": "a7e96d3f5e5d40500670e78d528e0db7", "kind": "equivalent", "version": "9.3.12", "label": "9.3.12", "title": "Update time zone data files to tzdata release 2016c for DST law changes in Azerbaijan, Chile, Haiti, Palestine, and Russia (Altai, Astrakhan, Kirov, Sakhalin, Ulyanovsk regions), plus historical corrections for Lithuania, Moldova, and Russia (Kaliningrad, Samara, Volgograd).", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "622a517e919a21515902322cf894a7f5ff6bb97ca3542babb0bf8a71177d00e0"}, "url": "/docs/compare/?release=9.3.12#9.3.12-9333eb0670b4b84a", "source_url": "/docs/release/9.3.12/#AEN116808"}, {"db_id": "6831386b58658c333c783df37fedc92f", "kind": "equivalent", "version": "9.2.16", "label": "9.2.16", "title": "Update time zone data files to tzdata release 2016c for DST law changes in Azerbaijan, Chile, Haiti, Palestine, and Russia (Altai, Astrakhan, Kirov, Sakhalin, Ulyanovsk regions), plus historical corrections for Lithuania, Moldova, and Russia (Kaliningrad, Samara, Volgograd).", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "622a517e919a21515902322cf894a7f5ff6bb97ca3542babb0bf8a71177d00e0"}, "url": "/docs/compare/?release=9.2.16#9.2.16-9333eb0670b4b84a", "source_url": "/docs/release/9.2.16/#AEN111718"}, {"db_id": "1cfca3d2934db698b31aff12cf0a4f90", "kind": "equivalent", "version": "9.1.21", "label": "9.1.21", "title": "Update time zone data files to tzdata release 2016c for DST law changes in Azerbaijan, Chile, Haiti, Palestine, and Russia (Altai, Astrakhan, Kirov, Sakhalin, Ulyanovsk regions), plus historical corrections for Lithuania, Moldova, and Russia (Kaliningrad, Samara, Volgograd).", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "622a517e919a21515902322cf894a7f5ff6bb97ca3542babb0bf8a71177d00e0"}, "url": "/docs/compare/?release=9.1.21#9.1.21-9333eb0670b4b84a", "source_url": "/docs/release/9.1.21/#AEN107251"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 33}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 20}, {"key": "security", "label": "Security", "count": 2}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 11}], "total": 33, "release_count": 1, "cross_major": false, "cve_count": 2, "cves": [{"id": "CVE-2016-2193", "url": "https://www.postgresql.org/support/security/CVE-2016-2193/", "fixed": {"9.5": "9.5.2"}, "score": 4.2, "title": "Maintain row-security status properly in cached plans", "vector": "AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:N", "affected": {"9.5": "9.5"}, "component": "core server", "published": {"9.5": "2016-03-31"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2016-03-31", "fixed_version": "9.5.2"}, {"id": "CVE-2016-3065", "url": "https://www.postgresql.org/support/security/CVE-2016-3065/", "fixed": {"9.5": "9.5.2"}, "score": 3.1, "title": "Add must-be-superuser checks to some new contrib/pageinspect functions", "vector": "AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:N/A:N", "affected": {"9.5": "9.5"}, "component": "contrib module", "published": {"9.5": "2016-03-31"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2016-03-31", "fixed_version": "9.5.2"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 33, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}