A dump/restore is not required for those running 13.X.
\nHowever, see the first changelog item below concerning a possible need to update stored views. Also see the third and fourth changelog items, which describe cases in which reindexing indexes after the upgrade may be advisable.
", "compatibility_count": 0, "label": "13.2", "status_label": "Historical", "eol": "2025-11-13", "age_days": 2056, "support_days": -320}, "groups": [{"date": "2021-02-11", "build": "13.2", "major": "13", "minor": 2, "manual": "13", "status": "stable", "doc_git": "", "version": "13.2", "eol_date": "2025-11-13", "date_text": "2021-02-11", "supported": false, "manual_url": "/docs/13/release-13-2.html", "source_url": "/docs/release/13.2/", "entry_count": 80, "placeholder": false, "content_hash": "6141e2aaeab943170b8f82aaba7b497b2b048a7f445cc064cfeb7b2f5c4d74e7", "manual_build": "13.23", "source_as_of": "", "changes_count": 80, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 13.X.
\nHowever, see the first changelog item below concerning a possible need to update stored views. Also see the third and fourth changelog items, which describe cases in which reindexing indexes after the upgrade may be advisable.
", "compatibility_count": 0, "label": "13.2", "status_label": "Historical", "eol": "2025-11-13", "age_days": 2056, "support_days": -320, "entries": [{"id": "13.2-d5a989a0616fcbe6", "cves": ["CVE-2021-20229"], "html": "Fix failure to check per-column SELECT privileges in some join queries (Tom Lane) §
In some cases involving joins, the parser failed to record all the columns read by a query in the column-usage bitmaps that are used for permissions checking. Although the executor would still insist on some sort of SELECT privilege to run the query, this meant that a user having SELECT privilege on only one column of a table could nonetheless read all its columns through a suitably crafted query.
A stored view that is subject to this problem will have incomplete column-usage bitmaps, and thus permissions will still not be enforced properly on the view after updating. In installations that depend on column-level permissions for security, it is recommended to CREATE OR REPLACE all user-defined views to cause them to be re-parsed.
The PostgreSQL Project thanks Sven Klemm for reporting this problem. (CVE-2021-20229)
", "text": "Fix failure to check per-column SELECT privileges in some join queries (Tom Lane) § In some cases involving joins, the parser failed to record all the columns read by a query in the column-usage bitmaps that are used for permissions checking. Although the executor would still insist on some sort of SELECT privilege to run the query, this meant that a user having SELECT privilege on only one column of a table could nonetheless read all its columns through a suitably crafted query. A stored view that is subject to this problem will have incomplete column-usage bitmaps, and thus permissions will still not be enforced properly on the view after updating. In installations that depend on column-level permissions for security, it is recommended to CREATE OR REPLACE all user-defined views to cause them to be re-parsed. The PostgreSQL Project thanks Sven Klemm for reporting this problem. (CVE-2021-20229)", "title": "Fix failure to check per-column SELECT privileges in some join queries", "commits": ["d525fbcfd"], "section": "Changes", "category": "security", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "a7a6c40660e2f7ea9ad415847ad2a434ad4d17e2489647b1907b880fc4c396cd", "section_path": ["Changes"], "commit_groups": [["c028faf2a", "d525fbcfd"]], "identity_text": "Fix failure to check per-column SELECT privileges in some join queries (Tom Lane) In some cases involving joins, the parser failed to record all the columns read by a query in the column-usage bitmaps that are used for permissions checking. Although the executor would still insist on some sort of SELECT privilege to run the query, this meant that a user having SELECT privilege on only one column of a table could nonetheless read all its columns through a suitably crafted query. A stored view that is subject to this problem will have incomplete column-usage bitmaps, and thus permissions will still not be enforced properly on the view after updating. In installations that depend on column-level permissions for security, it is recommended to CREATE OR REPLACE all user-defined views to cause them to be re-parsed. The PostgreSQL Project thanks Sven Klemm for reporting this problem. (CVE-2021-20229)", "commit_aliases": ["c028faf2a", "d525fbcfd"], "source_commits": ["d525fbcfd"], "source_entry_id": "13.2/changes/001", "db_id": "37a7b1ca406cd761cd51879f3be2fc52", "patch_ids": ["c376e1e1f5b3401b87f4a1dba5b5a2fe"], "statement_hash": "2f908f6733a8f24911c35b6db583fc3fc4be53b0cd432ccb6b120345b6b52e79", "relations": [], "version": "13.2", "category_label": "Security", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.2-360109c41051c8db", "cves": ["CVE-2021-3393"], "html": "Fix information leakage in constraint-violation error messages (Heikki Linnakangas) §
\nIf an UPDATE command attempts to move a row to a different partition but finds that it violates some constraint on the new partition, and the columns in that partition are in different physical positions than in the parent table, the error message could reveal the contents of columns that the user does not have SELECT privilege on. (CVE-2021-3393)
Fix incorrect detection of concurrent page splits while inserting into a GiST index (Heikki Linnakangas) §
\nConcurrent insertions could lead to a corrupt index with entries placed in the wrong pages. It's recommended to reindex any GiST index that's been subject to concurrent insertions.
", "text": "Fix incorrect detection of concurrent page splits while inserting into a GiST index (Heikki Linnakangas) § Concurrent insertions could lead to a corrupt index with entries placed in the wrong pages. It's recommended to reindex any GiST index that's been subject to concurrent insertions.", "title": "Fix incorrect detection of concurrent page splits while inserting into a GiST index", "commits": ["b8403d140"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "899ef43e958843c5812e4aba8919f7bb67b32bf01c8490841df154e603b99e2e", "section_path": ["Changes"], "commit_groups": [["0326635dd", "6b4d3046f", "b8403d140"]], "identity_text": "Fix incorrect detection of concurrent page splits while inserting into a GiST index (Heikki Linnakangas) Concurrent insertions could lead to a corrupt index with entries placed in the wrong pages. It's recommended to reindex any GiST index that's been subject to concurrent insertions.", "commit_aliases": ["0326635dd", "6b4d3046f", "b8403d140"], "source_commits": ["b8403d140"], "source_entry_id": "13.2/changes/003", "db_id": "0aed66a9eb4d6bd7ef3501cb44a0305f", "patch_ids": ["e744ef48651703b8219a17cf2f30388e"], "statement_hash": "7f938e25fdf090d4bd36f293f2423a183f5e4c359de9e83019216c986b89d889", "relations": [{"rule": 2, "type": "equivalent", "target": "882e05379d16b7c841f3a24d26e00365", "evidence": {"same_day": true, "patch_ids": ["e744ef48651703b8219a17cf2f30388e"], "statement_hash": "7f938e25fdf090d4bd36f293f2423a183f5e4c359de9e83019216c986b89d889"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "882e05379d16b7c841f3a24d26e00365", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Fix incorrect detection of concurrent page splits while inserting into a GiST index", "evidence": {"same_day": true, "patch_ids": ["e744ef48651703b8219a17cf2f30388e"], "statement_hash": "7f938e25fdf090d4bd36f293f2423a183f5e4c359de9e83019216c986b89d889"}, "url": "/docs/compare/?release=12.6#12.6-fe2b33a97e73bdc4", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}]}, {"id": "13.2-4a1b9e91efb7fc9f", "cves": [], "html": "Fix CREATE INDEX CONCURRENTLY to wait for concurrent prepared transactions (Andrey Borodin) §
At the point where CREATE INDEX CONCURRENTLY waits for all concurrent transactions to complete so that it can see rows they inserted, it must also wait for all prepared transactions to complete, for the same reason. Its failure to do so meant that rows inserted by prepared transactions might be omitted from the new index, causing queries relying on the index to miss such rows. In installations that have enabled prepared transactions (max_prepared_transactions > 0), it's recommended to reindex any concurrently-built indexes in case this problem occurred when they were built.
Avoid crash when trying to rescan an aggregation plan node that has both hashed and sorted grouping sets (Jeff Davis) § § §
", "text": "Avoid crash when trying to rescan an aggregation plan node that has both hashed and sorted grouping sets (Jeff Davis) § § §", "title": "Avoid crash when trying to rescan an aggregation plan node that has both hashed and sorted grouping sets", "commits": ["6669cc769", "7b8692eaf", "cd7d8cde7"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "09cd228cf15c0eddf3f6e230f8bd78d53fe892aa69e4e9819a281ffe5e8e5277", "section_path": ["Changes"], "commit_groups": [["05c025896", "7b8692eaf"], ["6669cc769", "fa0fdf051"], ["cd7d8cde7", "facad3147"]], "identity_text": "Avoid crash when trying to rescan an aggregation plan node that has both hashed and sorted grouping sets (Jeff Davis)", "commit_aliases": ["05c025896", "6669cc769", "7b8692eaf", "cd7d8cde7", "fa0fdf051", "facad3147"], "source_commits": ["6669cc769", "7b8692eaf", "cd7d8cde7"], "source_entry_id": "13.2/changes/005", "db_id": "f6184c2fd90f93ec48fee0f2583b5c0d", "patch_ids": ["7a2d01e075af0587c08b00bef41ff649", "83361afec476eae5605c2ecdc4f9dbc2", "bd052573c72b22b12545b3d202f99741"], "statement_hash": "31d72f37e07535ca3e28a3eaac443eff4a128d6ce68e942bfd5029fb18aa59ab", "relations": [], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.2-17d37f71415af1c2", "cves": [], "html": "Fix possible incorrect query results when a hash aggregation node spills some tuples to disk (Tom Lane) §
\nIt was possible for aggregation grouping values to be replaced by nulls when the tuples are read back in, leading to wrong answers.
", "text": "Fix possible incorrect query results when a hash aggregation node spills some tuples to disk (Tom Lane) § It was possible for aggregation grouping values to be replaced by nulls when the tuples are read back in, leading to wrong answers.", "title": "Fix possible incorrect query results when a hash aggregation node spills some tuples to disk", "commits": ["6467661b6"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "72457d49e5625d932198a011df261512f0fe06c43dcc8f6aaac4a307ea26c992", "section_path": ["Changes"], "commit_groups": [["0ff865fbe", "6467661b6"]], "identity_text": "Fix possible incorrect query results when a hash aggregation node spills some tuples to disk (Tom Lane) It was possible for aggregation grouping values to be replaced by nulls when the tuples are read back in, leading to wrong answers.", "commit_aliases": ["0ff865fbe", "6467661b6"], "source_commits": ["6467661b6"], "source_entry_id": "13.2/changes/006", "db_id": "905ba02e60fd25cc2186c327e9795495", "patch_ids": ["601d58fadd9021a1f0eff3131f59474d"], "statement_hash": "27ec4889057d017b13cdbb084ed10118163112d1b1772b7b648237eaae45b6b5", "relations": [], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.2-8963adef47e0b110", "cves": [], "html": "Fix edge case in incremental sort (Neil Chen) §
\nIf the last tuple of a sort batch chanced to be the first tuple of the next group of already-sorted tuples, the code did the wrong thing. This could lead to “retrieved too many tuples in a bounded sort” error messages, or to silently-wrong sorting results.
", "text": "Fix edge case in incremental sort (Neil Chen) § If the last tuple of a sort batch chanced to be the first tuple of the next group of already-sorted tuples, the code did the wrong thing. This could lead to “retrieved too many tuples in a bounded sort” error messages, or to silently-wrong sorting results.", "title": "Fix edge case in incremental sort", "commits": ["10fcb83da"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "ba73f88fc0fe01b8210c440e5ee05dec7853ff46dc0086fa94e1bfae9b6dec43", "section_path": ["Changes"], "commit_groups": [["10fcb83da", "82e0e2930"]], "identity_text": "Fix edge case in incremental sort (Neil Chen) If the last tuple of a sort batch chanced to be the first tuple of the next group of already-sorted tuples, the code did the wrong thing. This could lead to retrieved too many tuples in a bounded sort error messages, or to silently-wrong sorting results.", "commit_aliases": ["10fcb83da", "82e0e2930"], "source_commits": ["10fcb83da"], "source_entry_id": "13.2/changes/007", "db_id": "e5b1513e2448782f3909fef6762d6b5c", "patch_ids": ["52d9127858175b24620076dd56877128"], "statement_hash": "95097b179d726c9dc8234ac20c9ae78b6b2f75ed9cc93dc77b5ebd7853654ddd", "relations": [], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.2-dee8aee3216c89eb", "cves": [], "html": "Avoid crash when a CALL or DO statement that performs a transaction rollback is executed via extended query protocol (Thomas Munro, Tom Lane) §
In PostgreSQL 13, this case reliably caused a null-pointer dereference. In earlier versions the bug seems to have no visible symptoms, but it's not quite clear that it could never cause a problem.
", "text": "Avoid crash when a CALL or DO statement that performs a transaction rollback is executed via extended query protocol (Thomas Munro, Tom Lane) § In PostgreSQL 13, this case reliably caused a null-pointer dereference. In earlier versions the bug seems to have no visible symptoms, but it's not quite clear that it could never cause a problem.", "title": "Avoid crash when a CALL or DO statement that performs a transaction rollback is executed via extended query protocol", "commits": ["57868d957"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "4054ebb2509b511e0771e42b27905856e9c1ec9d520b440e5832fb81873d8fc6", "section_path": ["Changes"], "commit_groups": [["1c3a87746", "57868d957", "77e760d5c", "9624321ec"]], "identity_text": "Avoid crash when a CALL or DO statement that performs a transaction rollback is executed via extended query protocol (Thomas Munro, Tom Lane) In PostgreSQL 13, this case reliably caused a null-pointer dereference. In earlier versions the bug seems to have no visible symptoms, but it's not quite clear that it could never cause a problem.", "commit_aliases": ["1c3a87746", "57868d957", "77e760d5c", "9624321ec"], "source_commits": ["57868d957"], "source_entry_id": "13.2/changes/008", "db_id": "d808e9c12d1853862d1cf02a81f6f44d", "patch_ids": ["ec56012fd13b688279537557a875cb9a"], "statement_hash": "dd344c302fe03f2ae70588da942a4f597b1bd9da50397b2365b07443b03a9ff3", "relations": [{"rule": 2, "type": "equivalent", "target": "16c0e9efc5c1fd650988645206555f16", "evidence": {"same_day": true, "patch_ids": ["ec56012fd13b688279537557a875cb9a"], "statement_hash": "dd344c302fe03f2ae70588da942a4f597b1bd9da50397b2365b07443b03a9ff3"}}, {"rule": 2, "type": "equivalent", "target": "567dddc39e04e2fca1f40d5f019efc41", "evidence": {"same_day": true, "patch_ids": ["ec56012fd13b688279537557a875cb9a"], "statement_hash": "dd344c302fe03f2ae70588da942a4f597b1bd9da50397b2365b07443b03a9ff3"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "16c0e9efc5c1fd650988645206555f16", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Avoid crash when a CALL or DO statement that performs a transaction rollback is executed via extended query protocol", "evidence": {"same_day": true, "patch_ids": ["ec56012fd13b688279537557a875cb9a"], "statement_hash": "dd344c302fe03f2ae70588da942a4f597b1bd9da50397b2365b07443b03a9ff3"}, "url": "/docs/compare/?release=12.6#12.6-4a7e50ff91abbda0", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "567dddc39e04e2fca1f40d5f019efc41", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Avoid crash when a CALL or DO statement that performs a transaction rollback is executed via extended query protocol", "evidence": {"same_day": true, "patch_ids": ["ec56012fd13b688279537557a875cb9a"], "statement_hash": "dd344c302fe03f2ae70588da942a4f597b1bd9da50397b2365b07443b03a9ff3"}, "url": "/docs/compare/?release=11.11#11.11-3b112f74f9982370", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}]}, {"id": "13.2-0f5284823fa112d9", "cves": [], "html": "Avoid unnecessary errors with BEFORE UPDATE triggers on partitioned tables (Álvaro Herrera) §
A BEFORE UPDATE FOR EACH ROW trigger that modified the row in any way prevented UPDATE from moving the row to another partition when needed; but there is no longer any reason for this restriction.
Fix partition pruning logic to handle asymmetric hash partition sets (Tom Lane) §
\nIf a hash-partitioned table has unequally-sized partitions (that is, varying modulus values), or it lacks partitions for some remainder values, then the planner's pruning logic could mistakenly conclude that some partitions don't need to be scanned, leading to failure to find rows that the query should find.
", "text": "Fix partition pruning logic to handle asymmetric hash partition sets (Tom Lane) § If a hash-partitioned table has unequally-sized partitions (that is, varying modulus values), or it lacks partitions for some remainder values, then the planner's pruning logic could mistakenly conclude that some partitions don't need to be scanned, leading to failure to find rows that the query should find.", "title": "Fix partition pruning logic to handle asymmetric hash partition sets", "commits": ["7f1921cb9"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "a21c45b57163ccfbce6ec2ac746ad11801c9f1e9ce8663f31c4da97b116ab492", "section_path": ["Changes"], "commit_groups": [["1d9351a87", "6f94531b0", "7c53a8067", "7f1921cb9"]], "identity_text": "Fix partition pruning logic to handle asymmetric hash partition sets (Tom Lane) If a hash-partitioned table has unequally-sized partitions (that is, varying modulus values), or it lacks partitions for some remainder values, then the planner's pruning logic could mistakenly conclude that some partitions don't need to be scanned, leading to failure to find rows that the query should find.", "commit_aliases": ["1d9351a87", "6f94531b0", "7c53a8067", "7f1921cb9"], "source_commits": ["7f1921cb9"], "source_entry_id": "13.2/changes/010", "db_id": "538b30f52ae3914046ec9c75a30729a9", "patch_ids": ["e7c21b82ef336e2e41c7dbe540e51d1a"], "statement_hash": "185bb33b1db74f6f423109cbe112e2c0c1239cb53a7e897c89493703256a45d8", "relations": [{"rule": 2, "type": "equivalent", "target": "595dcafb55c75453682c569e0a0ecc9a", "evidence": {"same_day": true, "patch_ids": ["e7c21b82ef336e2e41c7dbe540e51d1a"], "statement_hash": "185bb33b1db74f6f423109cbe112e2c0c1239cb53a7e897c89493703256a45d8"}}, {"rule": 2, "type": "equivalent", "target": "f7cf34c80b9edef0f9ff3dd609dd0faa", "evidence": {"same_day": true, "patch_ids": ["e7c21b82ef336e2e41c7dbe540e51d1a"], "statement_hash": "185bb33b1db74f6f423109cbe112e2c0c1239cb53a7e897c89493703256a45d8"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "595dcafb55c75453682c569e0a0ecc9a", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Fix partition pruning logic to handle asymmetric hash partition sets", "evidence": {"same_day": true, "patch_ids": ["e7c21b82ef336e2e41c7dbe540e51d1a"], "statement_hash": "185bb33b1db74f6f423109cbe112e2c0c1239cb53a7e897c89493703256a45d8"}, "url": "/docs/compare/?release=12.6#12.6-f16e69ebab6cf1b4", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "f7cf34c80b9edef0f9ff3dd609dd0faa", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Fix partition pruning logic to handle asymmetric hash partition sets", "evidence": {"same_day": true, "patch_ids": ["e7c21b82ef336e2e41c7dbe540e51d1a"], "statement_hash": "185bb33b1db74f6f423109cbe112e2c0c1239cb53a7e897c89493703256a45d8"}, "url": "/docs/compare/?release=11.11#11.11-badcf8cce4f68210", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}]}, {"id": "13.2-ed0ebabe1f9c3168", "cves": [], "html": "Avoid incorrect results when WHERE CURRENT OF is applied to a cursor whose plan contains a MergeAppend node (Tom Lane) §
This case is unsupported (in general, a cursor using ORDER BY is not guaranteed to be simply updatable); but the code previously did not reject it, and could silently give false matches.
Fix crash when WHERE CURRENT OF is applied to a cursor whose plan contains a custom scan node (David Geier) §
Fix planner's mishandling of placeholders whose evaluation should be delayed by an outer join (Tom Lane) §
\nThis occurs in particular with trivial subqueries containing lateral references to outer-join outputs. The mistake could result in a malformed plan. The known cases trigger a “failed to assign all NestLoopParams to plan nodes” error, but other symptoms may be possible.
", "text": "Fix planner's mishandling of placeholders whose evaluation should be delayed by an outer join (Tom Lane) § This occurs in particular with trivial subqueries containing lateral references to outer-join outputs. The mistake could result in a malformed plan. The known cases trigger a “failed to assign all NestLoopParams to plan nodes” error, but other symptoms may be possible.", "title": "Fix planner's mishandling of placeholders whose evaluation should be delayed by an outer join", "commits": ["73fc2e5ba"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "fddcb9496ea1bad7267c21064425d80be7f65ef0c5c125032cabb937d5c9c36f", "section_path": ["Changes"], "commit_groups": [["1cce024fd", "55dc86eca", "73fc2e5ba"]], "identity_text": "Fix planner's mishandling of placeholders whose evaluation should be delayed by an outer join (Tom Lane) This occurs in particular with trivial subqueries containing lateral references to outer-join outputs. The mistake could result in a malformed plan. The known cases trigger a failed to assign all NestLoopParams to plan nodes error, but other symptoms may be possible.", "commit_aliases": ["1cce024fd", "55dc86eca", "73fc2e5ba"], "source_commits": ["73fc2e5ba"], "source_entry_id": "13.2/changes/013", "db_id": "34a189f90167176833034217e3c539b8", "patch_ids": ["8ad1c62bfa5de030cd329d3d5596c679"], "statement_hash": "d202e6ef2fb92dcca98729a575771eb1f07b4f538104afa90d8818a812a69df1", "relations": [{"rule": 2, "type": "equivalent", "target": "5285182069652152a7237d87e5ae204c", "evidence": {"same_day": true, "patch_ids": ["8ad1c62bfa5de030cd329d3d5596c679"], "statement_hash": "d202e6ef2fb92dcca98729a575771eb1f07b4f538104afa90d8818a812a69df1"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "5285182069652152a7237d87e5ae204c", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Fix planner's mishandling of placeholders whose evaluation should be delayed by an outer join", "evidence": {"same_day": true, "patch_ids": ["8ad1c62bfa5de030cd329d3d5596c679"], "statement_hash": "d202e6ef2fb92dcca98729a575771eb1f07b4f538104afa90d8818a812a69df1"}, "url": "/docs/compare/?release=12.6#12.6-d7cb2a1b00202b34", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}]}, {"id": "13.2-d7c8414ca9495b1c", "cves": [], "html": "Fix planner's handling of placeholders during removal of useless RESULT RTEs (Tom Lane) §
\nThis oversight could lead to “no relation entry for relid N” planner errors.
Fix planner's handling of a placeholder that is computed at some join level and used only at that same level (Tom Lane) §
\nThis oversight could lead to “failed to build any N-way joins” planner errors.
Consider unsorted subpaths when planning a Gather Merge operation (James Coleman) §
\nIt's possible to use such a path by adding an explicit Sort node, and in some cases that gives rise to a superior plan.
", "text": "Consider unsorted subpaths when planning a Gather Merge operation (James Coleman) § It's possible to use such a path by adding an explicit Sort node, and in some cases that gives rise to a superior plan.", "title": "Consider unsorted subpaths when planning a Gather Merge operation", "commits": ["ea190ed14"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "5f1f3c3d69dc220b7f4d142b97d79e4d35fce0a82a43679e710cccc5c9f4f3eb", "section_path": ["Changes"], "commit_groups": [["ea190ed14", "f4a3c0b06"]], "identity_text": "Consider unsorted subpaths when planning a Gather Merge operation (James Coleman) It's possible to use such a path by adding an explicit Sort node, and in some cases that gives rise to a superior plan.", "commit_aliases": ["ea190ed14", "f4a3c0b06"], "source_commits": ["ea190ed14"], "source_entry_id": "13.2/changes/016", "db_id": "b81256e58c3167c61f3801c26df9393e", "patch_ids": ["70b9722de8a02b9fb1ed409f2fad07e3"], "statement_hash": "c9ed6de5d1aaf3ab8c92e44a0abb8b557e1c6390449413e21a6b34cd79459faa", "relations": [], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.2-d21fddecd3a2a678", "cves": [], "html": "Do not consider ORDER BY expressions involving parallel-restricted functions or set-returning functions when trying to parallelize sorts (James Coleman) § §
Such cases cannot safely be pushed into worker processes, but the incremental sort feature accidentally made us consider them.
", "text": "Do not consider ORDER BY expressions involving parallel-restricted functions or set-returning functions when trying to parallelize sorts (James Coleman) § § Such cases cannot safely be pushed into worker processes, but the incremental sort feature accidentally made us consider them.", "title": "Do not consider ORDER BY expressions involving parallel-restricted functions or set-returning functions when trying to parallelize sorts", "commits": ["be9c3cd18", "d0167631e"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "b71ca618b1fdec4e66a4c875acaf075374470b007c5a7ac767cc680a2c8e78e7", "section_path": ["Changes"], "commit_groups": [["86b7cca72", "be9c3cd18"], ["d0167631e", "fac1b470a"]], "identity_text": "Do not consider ORDER BY expressions involving parallel-restricted functions or set-returning functions when trying to parallelize sorts (James Coleman) Such cases cannot safely be pushed into worker processes, but the incremental sort feature accidentally made us consider them.", "commit_aliases": ["86b7cca72", "be9c3cd18", "d0167631e", "fac1b470a"], "source_commits": ["be9c3cd18", "d0167631e"], "source_entry_id": "13.2/changes/017", "db_id": "7ecbe7716ff52a5287e313adf34f604d", "patch_ids": ["40de3095024ab576c1993b5ec5ea2755", "53701039460cafa196f445cf255662ab"], "statement_hash": "02754352a39d64ff98c293c22ac4d43438aeebf4f6c3d9d06ad2e6e0d0fbd33c", "relations": [], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.2-81bc777702fa6586", "cves": [], "html": "Be more careful about whether index AMs support mark/restore (Andrew Gierth) §
\nThis prevents errors about missing support functions in rare edge cases.
", "text": "Be more careful about whether index AMs support mark/restore (Andrew Gierth) § This prevents errors about missing support functions in rare edge cases.", "title": "Be more careful about whether index AMs support mark/restore", "commits": ["6dda05704"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "b1cb74f3440969eeb99b52dbf405ac04135870d1940aa04a8248a61fe885d03e", "section_path": ["Changes"], "commit_groups": [["018e7d98d", "321c87e5c", "59ed45e27", "6402afd98", "660b89928", "6dda05704", "ae5aa26dc"]], "identity_text": "Be more careful about whether index AMs support mark/restore (Andrew Gierth) This prevents errors about missing support functions in rare edge cases.", "commit_aliases": ["018e7d98d", "321c87e5c", "59ed45e27", "6402afd98", "660b89928", "6dda05704", "ae5aa26dc"], "source_commits": ["6dda05704"], "source_entry_id": "13.2/changes/018", "db_id": "5ccd5b246b38d774e71b7453a3682bd7", "patch_ids": ["749840e3c6ceb36efe87cb701e4462d4"], "statement_hash": "f53f3f70ebe52fca4dd085ea8ca596c6215cae44cf52ad6aa3c0ca701f01c185", "relations": [{"rule": 2, "type": "equivalent", "target": "57b6c2a714b843a87d0747aa8252c1f6", "evidence": {"same_day": true, "patch_ids": ["749840e3c6ceb36efe87cb701e4462d4"], "statement_hash": "f53f3f70ebe52fca4dd085ea8ca596c6215cae44cf52ad6aa3c0ca701f01c185"}}, {"rule": 2, "type": "equivalent", "target": "ac4838555b4a14755d3dc36a71dcf02f", "evidence": {"same_day": true, "patch_ids": ["749840e3c6ceb36efe87cb701e4462d4"], "statement_hash": "f53f3f70ebe52fca4dd085ea8ca596c6215cae44cf52ad6aa3c0ca701f01c185"}}, {"rule": 2, "type": "equivalent", "target": "e30a1be42c0ba1ec75f41eaad102da5e", "evidence": {"same_day": true, "patch_ids": ["749840e3c6ceb36efe87cb701e4462d4"], "statement_hash": "f53f3f70ebe52fca4dd085ea8ca596c6215cae44cf52ad6aa3c0ca701f01c185"}}, {"rule": 2, "type": "equivalent", "target": "e72e53f518365fa9545ab0f09475a9af", "evidence": {"same_day": true, "patch_ids": ["749840e3c6ceb36efe87cb701e4462d4"], "statement_hash": "f53f3f70ebe52fca4dd085ea8ca596c6215cae44cf52ad6aa3c0ca701f01c185"}}, {"rule": 2, "type": "equivalent", "target": "e74a9337e2fcd7bc439207ba18a84bdb", "evidence": {"same_day": true, "patch_ids": ["749840e3c6ceb36efe87cb701e4462d4"], "statement_hash": "f53f3f70ebe52fca4dd085ea8ca596c6215cae44cf52ad6aa3c0ca701f01c185"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "ac4838555b4a14755d3dc36a71dcf02f", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Be more careful about whether index AMs support mark/restore", "evidence": {"same_day": true, "patch_ids": ["749840e3c6ceb36efe87cb701e4462d4"], "statement_hash": "f53f3f70ebe52fca4dd085ea8ca596c6215cae44cf52ad6aa3c0ca701f01c185"}, "url": "/docs/compare/?release=12.6#12.6-3ad714e7827b363a", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "57b6c2a714b843a87d0747aa8252c1f6", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Be more careful about whether index AMs support mark/restore", "evidence": {"same_day": true, "patch_ids": ["749840e3c6ceb36efe87cb701e4462d4"], "statement_hash": "f53f3f70ebe52fca4dd085ea8ca596c6215cae44cf52ad6aa3c0ca701f01c185"}, "url": "/docs/compare/?release=11.11#11.11-af5d0580e00a76a7", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "e74a9337e2fcd7bc439207ba18a84bdb", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Be more careful about whether index AMs support mark/restore", "evidence": {"same_day": true, "patch_ids": ["749840e3c6ceb36efe87cb701e4462d4"], "statement_hash": "f53f3f70ebe52fca4dd085ea8ca596c6215cae44cf52ad6aa3c0ca701f01c185"}, "url": "/docs/compare/?release=10.16#10.16-af5d0580e00a76a7", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "e72e53f518365fa9545ab0f09475a9af", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "Be more careful about whether index AMs support mark/restore", "evidence": {"same_day": true, "patch_ids": ["749840e3c6ceb36efe87cb701e4462d4"], "statement_hash": "f53f3f70ebe52fca4dd085ea8ca596c6215cae44cf52ad6aa3c0ca701f01c185"}, "url": "/docs/compare/?release=9.6.21#9.6.21-af5d0580e00a76a7", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "e30a1be42c0ba1ec75f41eaad102da5e", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "Be more careful about whether index AMs support mark/restore", "evidence": {"same_day": true, "patch_ids": ["749840e3c6ceb36efe87cb701e4462d4"], "statement_hash": "f53f3f70ebe52fca4dd085ea8ca596c6215cae44cf52ad6aa3c0ca701f01c185"}, "url": "/docs/compare/?release=9.5.25#9.5.25-af5d0580e00a76a7", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-e2f66796e43a370a", "cves": [], "html": "Fix overestimate of the amount of shared memory needed for parallel queries (Takayuki Tsunakawa) §
", "text": "Fix overestimate of the amount of shared memory needed for parallel queries (Takayuki Tsunakawa) §", "title": "Fix overestimate of the amount of shared memory needed for parallel queries", "commits": ["60369db86"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "fc34f593993d05eafc5b8bb5bd8c305afb17ad57a87ba4ba229fe2d96d2a2f1f", "section_path": ["Changes"], "commit_groups": [["19a1d7685", "2ad78a87f", "60369db86", "97b025ebe"]], "identity_text": "Fix overestimate of the amount of shared memory needed for parallel queries (Takayuki Tsunakawa)", "commit_aliases": ["19a1d7685", "2ad78a87f", "60369db86", "97b025ebe"], "source_commits": ["60369db86"], "source_entry_id": "13.2/changes/019", "db_id": "ae18b4c696c4390430ffab12cdc042c7", "patch_ids": ["012a62df5934165d52049922c5ba12a1"], "statement_hash": "449c4211d1a7572e059ea8bbcfd1a5070e271276115ff3554e61e0f809a40860", "relations": [{"rule": 2, "type": "equivalent", "target": "b9cca3cd970d41521f270e8bcbe8f3f8", "evidence": {"same_day": true, "patch_ids": ["012a62df5934165d52049922c5ba12a1"], "statement_hash": "449c4211d1a7572e059ea8bbcfd1a5070e271276115ff3554e61e0f809a40860"}}, {"rule": 2, "type": "equivalent", "target": "ca3ef9756eeca73e467126ce1439be02", "evidence": {"same_day": true, "patch_ids": ["012a62df5934165d52049922c5ba12a1"], "statement_hash": "449c4211d1a7572e059ea8bbcfd1a5070e271276115ff3554e61e0f809a40860"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "ca3ef9756eeca73e467126ce1439be02", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Fix overestimate of the amount of shared memory needed for parallel queries", "evidence": {"same_day": true, "patch_ids": ["012a62df5934165d52049922c5ba12a1"], "statement_hash": "449c4211d1a7572e059ea8bbcfd1a5070e271276115ff3554e61e0f809a40860"}, "url": "/docs/compare/?release=12.6#12.6-ac0172fe4e2c8606", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "b9cca3cd970d41521f270e8bcbe8f3f8", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Fix overestimate of the amount of shared memory needed for parallel queries", "evidence": {"same_day": true, "patch_ids": ["012a62df5934165d52049922c5ba12a1"], "statement_hash": "449c4211d1a7572e059ea8bbcfd1a5070e271276115ff3554e61e0f809a40860"}, "url": "/docs/compare/?release=11.11#11.11-5f285e16c25c6a73", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}]}, {"id": "13.2-4b47c52c3d1e42d3", "cves": [], "html": "Fix ALTER DEFAULT PRIVILEGES to handle duplicated arguments safely (Michael Paquier) §
Duplicate role or schema names within the same command could lead to “tuple already updated by self” errors or unique-constraint violations.
", "text": "Fix ALTER DEFAULT PRIVILEGES to handle duplicated arguments safely (Michael Paquier) § Duplicate role or schema names within the same command could lead to “tuple already updated by self” errors or unique-constraint violations.", "title": "Fix ALTER DEFAULT PRIVILEGES to handle duplicated arguments safely", "commits": ["31e0f9d76"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "88059ef353968ac96f131bf22e33e7738c98a604067f41af45daab3b15be6770", "section_path": ["Changes"], "commit_groups": [["0ddb529cf", "1c3a4d44d", "21378e1fe", "31e0f9d76", "5ad672fc2", "74ee3abcf", "7dc3be9df"]], "identity_text": "Fix ALTER DEFAULT PRIVILEGES to handle duplicated arguments safely (Michael Paquier) Duplicate role or schema names within the same command could lead to tuple already updated by self errors or unique-constraint violations.", "commit_aliases": ["0ddb529cf", "1c3a4d44d", "21378e1fe", "31e0f9d76", "5ad672fc2", "74ee3abcf", "7dc3be9df"], "source_commits": ["31e0f9d76"], "source_entry_id": "13.2/changes/020", "db_id": "033e71517443ed8592642e7692090256", "patch_ids": ["a0c6a2e491da1fb8e4b1a21f34272605"], "statement_hash": "108f17490f863784eb6f9bdbade7fa76b54b75d89fcc6c1a882af5d59652cb24", "relations": [{"rule": 2, "type": "equivalent", "target": "9ed5f0e33fbbefff8170d512c8e42a97", "evidence": {"same_day": true, "patch_ids": ["a0c6a2e491da1fb8e4b1a21f34272605"], "statement_hash": "108f17490f863784eb6f9bdbade7fa76b54b75d89fcc6c1a882af5d59652cb24"}}, {"rule": 2, "type": "equivalent", "target": "c8c62e21e0bd403c5dab1f4ed86dfad6", "evidence": {"same_day": true, "patch_ids": ["a0c6a2e491da1fb8e4b1a21f34272605"], "statement_hash": "108f17490f863784eb6f9bdbade7fa76b54b75d89fcc6c1a882af5d59652cb24"}}, {"rule": 2, "type": "equivalent", "target": "cda3edcd94b5fcfc7addadcb6b6dcb74", "evidence": {"same_day": true, "patch_ids": ["a0c6a2e491da1fb8e4b1a21f34272605"], "statement_hash": "108f17490f863784eb6f9bdbade7fa76b54b75d89fcc6c1a882af5d59652cb24"}}, {"rule": 2, "type": "equivalent", "target": "e9014b95101a24369f0504a5e24d5026", "evidence": {"same_day": true, "patch_ids": ["a0c6a2e491da1fb8e4b1a21f34272605"], "statement_hash": "108f17490f863784eb6f9bdbade7fa76b54b75d89fcc6c1a882af5d59652cb24"}}, {"rule": 2, "type": "equivalent", "target": "f580b4b2ea35354c971a0096c1ffcc3d", "evidence": {"same_day": true, "patch_ids": ["a0c6a2e491da1fb8e4b1a21f34272605"], "statement_hash": "108f17490f863784eb6f9bdbade7fa76b54b75d89fcc6c1a882af5d59652cb24"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "cda3edcd94b5fcfc7addadcb6b6dcb74", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Fix ALTER DEFAULT PRIVILEGES to handle duplicated arguments safely", "evidence": {"same_day": true, "patch_ids": ["a0c6a2e491da1fb8e4b1a21f34272605"], "statement_hash": "108f17490f863784eb6f9bdbade7fa76b54b75d89fcc6c1a882af5d59652cb24"}, "url": "/docs/compare/?release=12.6#12.6-436d765ebc16733b", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "f580b4b2ea35354c971a0096c1ffcc3d", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Fix ALTER DEFAULT PRIVILEGES to handle duplicated arguments safely", "evidence": {"same_day": true, "patch_ids": ["a0c6a2e491da1fb8e4b1a21f34272605"], "statement_hash": "108f17490f863784eb6f9bdbade7fa76b54b75d89fcc6c1a882af5d59652cb24"}, "url": "/docs/compare/?release=11.11#11.11-c34a8ae108865a8b", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "c8c62e21e0bd403c5dab1f4ed86dfad6", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Fix ALTER DEFAULT PRIVILEGES to handle duplicated arguments safely", "evidence": {"same_day": true, "patch_ids": ["a0c6a2e491da1fb8e4b1a21f34272605"], "statement_hash": "108f17490f863784eb6f9bdbade7fa76b54b75d89fcc6c1a882af5d59652cb24"}, "url": "/docs/compare/?release=10.16#10.16-c34a8ae108865a8b", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "9ed5f0e33fbbefff8170d512c8e42a97", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "Fix ALTER DEFAULT PRIVILEGES to handle duplicated arguments safely", "evidence": {"same_day": true, "patch_ids": ["a0c6a2e491da1fb8e4b1a21f34272605"], "statement_hash": "108f17490f863784eb6f9bdbade7fa76b54b75d89fcc6c1a882af5d59652cb24"}, "url": "/docs/compare/?release=9.6.21#9.6.21-c34a8ae108865a8b", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "e9014b95101a24369f0504a5e24d5026", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "Fix ALTER DEFAULT PRIVILEGES to handle duplicated arguments safely", "evidence": {"same_day": true, "patch_ids": ["a0c6a2e491da1fb8e4b1a21f34272605"], "statement_hash": "108f17490f863784eb6f9bdbade7fa76b54b75d89fcc6c1a882af5d59652cb24"}, "url": "/docs/compare/?release=9.5.25#9.5.25-c34a8ae108865a8b", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-d17a09f2cbc4b675", "cves": [], "html": "Flush ACL-related caches when pg_authid changes (Noah Misch) §
This change ensures that permissions-related decisions will promptly reflect the results of ALTER ROLE ... [NO] INHERIT.
Fix failure to detect “snapshot too old” conditions in tables rewritten in the current transaction (Kyotaro Horiguchi, Noah Misch) §
\nThis is only a hazard when wal_level is set to minimal and the rewrite is performed by ALTER TABLE SET TABLESPACE.
Fix spurious failure of CREATE PUBLICATION when applied to a table created or rewritten in the current transaction (Kyotaro Horiguchi) §
This is only a hazard when wal_level is set to minimal.
Prevent misprocessing of ambiguous CREATE TABLE LIKE clauses (Tom Lane) §
A LIKE clause is re-examined after initial creation of the new table, to handle importation of indexes and such. It was possible for this re-examination to find a different table of the same name, causing unexpected behavior; one example is where the new table is a temporary table of the same name as the LIKE target.
Rearrange order of operations in CREATE TABLE LIKE so that indexes are cloned before building foreign key constraints (Tom Lane) §
This fixes the case where a self-referential foreign key constraint declared in the outer CREATE TABLE depends on an index that's coming from the LIKE clause.
Disallow CREATE STATISTICS on system catalogs (Tomas Vondra) §
Disallow converting an inheritance child table to a view (Tom Lane) §
", "text": "Disallow converting an inheritance child table to a view (Tom Lane) §", "title": "Disallow converting an inheritance child table to a view", "commits": ["4353bc878"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "76e0475f7df3088a6ebdd79bedc3ed9e1ed2e00bb4065d13436a22d423fc28f6", "section_path": ["Changes"], "commit_groups": [["4353bc878", "580069037", "5ad03374b", "7736ab05f", "ad85e5efa", "dd705a039", "f73321957"]], "identity_text": "Disallow converting an inheritance child table to a view (Tom Lane)", "commit_aliases": ["4353bc878", "580069037", "5ad03374b", "7736ab05f", "ad85e5efa", "dd705a039", "f73321957"], "source_commits": ["4353bc878"], "source_entry_id": "13.2/changes/027", "db_id": "979f38103a244f175d742166a38b3027", "patch_ids": ["836946a2bd2e3da747d1b07b44a23c75"], "statement_hash": "434aa69d3d17fa25d9921282c0e17d7bbca55de5c1d442d36de556cb83a32be4", "relations": [{"rule": 2, "type": "equivalent", "target": "12ef8b02516a4bf938446a4d0010aca5", "evidence": {"same_day": true, "patch_ids": ["836946a2bd2e3da747d1b07b44a23c75"], "statement_hash": "434aa69d3d17fa25d9921282c0e17d7bbca55de5c1d442d36de556cb83a32be4"}}, {"rule": 2, "type": "equivalent", "target": "49e84999d920619f74274e63abddbdcc", "evidence": {"same_day": true, "patch_ids": ["836946a2bd2e3da747d1b07b44a23c75"], "statement_hash": "434aa69d3d17fa25d9921282c0e17d7bbca55de5c1d442d36de556cb83a32be4"}}, {"rule": 2, "type": "equivalent", "target": "61efb2638743b6c6a19bd3c5ef0f7667", "evidence": {"same_day": true, "patch_ids": ["836946a2bd2e3da747d1b07b44a23c75"], "statement_hash": "434aa69d3d17fa25d9921282c0e17d7bbca55de5c1d442d36de556cb83a32be4"}}, {"rule": 2, "type": "equivalent", "target": "8ba9b28638ea299c1e985749523345bf", "evidence": {"same_day": true, "patch_ids": ["836946a2bd2e3da747d1b07b44a23c75"], "statement_hash": "434aa69d3d17fa25d9921282c0e17d7bbca55de5c1d442d36de556cb83a32be4"}}, {"rule": 2, "type": "equivalent", "target": "95bac125c0f7972cc51bb60f17c0542e", "evidence": {"same_day": true, "patch_ids": ["836946a2bd2e3da747d1b07b44a23c75"], "statement_hash": "434aa69d3d17fa25d9921282c0e17d7bbca55de5c1d442d36de556cb83a32be4"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "95bac125c0f7972cc51bb60f17c0542e", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Disallow converting an inheritance child table to a view", "evidence": {"same_day": true, "patch_ids": ["836946a2bd2e3da747d1b07b44a23c75"], "statement_hash": "434aa69d3d17fa25d9921282c0e17d7bbca55de5c1d442d36de556cb83a32be4"}, "url": "/docs/compare/?release=12.6#12.6-dfe2f9b97f434670", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "61efb2638743b6c6a19bd3c5ef0f7667", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Disallow converting an inheritance child table to a view", "evidence": {"same_day": true, "patch_ids": ["836946a2bd2e3da747d1b07b44a23c75"], "statement_hash": "434aa69d3d17fa25d9921282c0e17d7bbca55de5c1d442d36de556cb83a32be4"}, "url": "/docs/compare/?release=11.11#11.11-c4a4939e02fe209e", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "49e84999d920619f74274e63abddbdcc", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Disallow converting an inheritance child table to a view", "evidence": {"same_day": true, "patch_ids": ["836946a2bd2e3da747d1b07b44a23c75"], "statement_hash": "434aa69d3d17fa25d9921282c0e17d7bbca55de5c1d442d36de556cb83a32be4"}, "url": "/docs/compare/?release=10.16#10.16-c4a4939e02fe209e", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "12ef8b02516a4bf938446a4d0010aca5", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "Disallow converting an inheritance child table to a view", "evidence": {"same_day": true, "patch_ids": ["836946a2bd2e3da747d1b07b44a23c75"], "statement_hash": "434aa69d3d17fa25d9921282c0e17d7bbca55de5c1d442d36de556cb83a32be4"}, "url": "/docs/compare/?release=9.6.21#9.6.21-c4a4939e02fe209e", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "8ba9b28638ea299c1e985749523345bf", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "Disallow converting an inheritance child table to a view", "evidence": {"same_day": true, "patch_ids": ["836946a2bd2e3da747d1b07b44a23c75"], "statement_hash": "434aa69d3d17fa25d9921282c0e17d7bbca55de5c1d442d36de556cb83a32be4"}, "url": "/docs/compare/?release=9.5.25#9.5.25-c4a4939e02fe209e", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-c47a5cddf73ea8ed", "cves": [], "html": "Ensure that disk space allocated for a dropped relation is released promptly at commit (Thomas Munro) §
\nPreviously, if the dropped relation spanned multiple 1GB segments, only the first segment was truncated immediately. Other segments were simply unlinked, which doesn't authorize the kernel to release the storage so long as any other backends still have the files open.
", "text": "Ensure that disk space allocated for a dropped relation is released promptly at commit (Thomas Munro) § Previously, if the dropped relation spanned multiple 1GB segments, only the first segment was truncated immediately. Other segments were simply unlinked, which doesn't authorize the kernel to release the storage so long as any other backends still have the files open.", "title": "Ensure that disk space allocated for a dropped relation is released promptly at commit", "commits": ["fd3a75d82"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "35673da4a9e0ebf40726cfda8da9c5b392ca7686736cdc899cfe0c43fbdd279b", "section_path": ["Changes"], "commit_groups": [["22701755d", "50f338574", "9f35f9437", "d0bbe2122", "d5706ad7b", "e00928de8", "fd3a75d82"]], "identity_text": "Ensure that disk space allocated for a dropped relation is released promptly at commit (Thomas Munro) Previously, if the dropped relation spanned multiple 1GB segments, only the first segment was truncated immediately. Other segments were simply unlinked, which doesn't authorize the kernel to release the storage so long as any other backends still have the files open.", "commit_aliases": ["22701755d", "50f338574", "9f35f9437", "d0bbe2122", "d5706ad7b", "e00928de8", "fd3a75d82"], "source_commits": ["fd3a75d82"], "source_entry_id": "13.2/changes/028", "db_id": "e41c7c0f90f56e4a2d06f7ae8276c637", "patch_ids": ["9a4fd327bc5dd3b37cfc3812f035c0d4"], "statement_hash": "aebfb9c3dffc144a48a2e672b5a0c64bb4ce8370cab25e69f7c81659350e83fe", "relations": [{"rule": 2, "type": "equivalent", "target": "03596b748ef6b859b5360dc3098acc41", "evidence": {"same_day": true, "patch_ids": ["9a4fd327bc5dd3b37cfc3812f035c0d4"], "statement_hash": "aebfb9c3dffc144a48a2e672b5a0c64bb4ce8370cab25e69f7c81659350e83fe"}}, {"rule": 2, "type": "equivalent", "target": "504fa4cb832d7d3abdd8340498c93a8e", "evidence": {"same_day": true, "patch_ids": ["9a4fd327bc5dd3b37cfc3812f035c0d4"], "statement_hash": "aebfb9c3dffc144a48a2e672b5a0c64bb4ce8370cab25e69f7c81659350e83fe"}}, {"rule": 2, "type": "equivalent", "target": "9363d693d2e0464a5a6f1e5ed52c50d7", "evidence": {"same_day": true, "patch_ids": ["9a4fd327bc5dd3b37cfc3812f035c0d4"], "statement_hash": "aebfb9c3dffc144a48a2e672b5a0c64bb4ce8370cab25e69f7c81659350e83fe"}}, {"rule": 2, "type": "equivalent", "target": "9df8843b80b823c7a414a43eef881153", "evidence": {"same_day": true, "patch_ids": ["9a4fd327bc5dd3b37cfc3812f035c0d4"], "statement_hash": "aebfb9c3dffc144a48a2e672b5a0c64bb4ce8370cab25e69f7c81659350e83fe"}}, {"rule": 2, "type": "equivalent", "target": "c9d3233197479c3689485c037f0828c1", "evidence": {"same_day": true, "patch_ids": ["9a4fd327bc5dd3b37cfc3812f035c0d4"], "statement_hash": "aebfb9c3dffc144a48a2e672b5a0c64bb4ce8370cab25e69f7c81659350e83fe"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "c9d3233197479c3689485c037f0828c1", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Ensure that disk space allocated for a dropped relation is released promptly at commit", "evidence": {"same_day": true, "patch_ids": ["9a4fd327bc5dd3b37cfc3812f035c0d4"], "statement_hash": "aebfb9c3dffc144a48a2e672b5a0c64bb4ce8370cab25e69f7c81659350e83fe"}, "url": "/docs/compare/?release=12.6#12.6-d2890c650882e77f", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "504fa4cb832d7d3abdd8340498c93a8e", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Ensure that disk space allocated for a dropped relation is released promptly at commit", "evidence": {"same_day": true, "patch_ids": ["9a4fd327bc5dd3b37cfc3812f035c0d4"], "statement_hash": "aebfb9c3dffc144a48a2e672b5a0c64bb4ce8370cab25e69f7c81659350e83fe"}, "url": "/docs/compare/?release=11.11#11.11-54b616588dc8200c", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "9363d693d2e0464a5a6f1e5ed52c50d7", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Ensure that disk space allocated for a dropped relation is released promptly at commit", "evidence": {"same_day": true, "patch_ids": ["9a4fd327bc5dd3b37cfc3812f035c0d4"], "statement_hash": "aebfb9c3dffc144a48a2e672b5a0c64bb4ce8370cab25e69f7c81659350e83fe"}, "url": "/docs/compare/?release=10.16#10.16-54b616588dc8200c", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "03596b748ef6b859b5360dc3098acc41", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "Ensure that disk space allocated for a dropped relation is released promptly at commit", "evidence": {"same_day": true, "patch_ids": ["9a4fd327bc5dd3b37cfc3812f035c0d4"], "statement_hash": "aebfb9c3dffc144a48a2e672b5a0c64bb4ce8370cab25e69f7c81659350e83fe"}, "url": "/docs/compare/?release=9.6.21#9.6.21-54b616588dc8200c", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "9df8843b80b823c7a414a43eef881153", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "Ensure that disk space allocated for a dropped relation is released promptly at commit", "evidence": {"same_day": true, "patch_ids": ["9a4fd327bc5dd3b37cfc3812f035c0d4"], "statement_hash": "aebfb9c3dffc144a48a2e672b5a0c64bb4ce8370cab25e69f7c81659350e83fe"}, "url": "/docs/compare/?release=9.5.25#9.5.25-54b616588dc8200c", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-cbd76aeb6434fc99", "cves": [], "html": "Prevent dropping a tablespace that is referenced by a partitioned relation, but is not used for any actual storage (Álvaro Herrera) §
\nPreviously this was allowed, but subsequent operations on the partitioned relation would fail.
", "text": "Prevent dropping a tablespace that is referenced by a partitioned relation, but is not used for any actual storage (Álvaro Herrera) § Previously this was allowed, but subsequent operations on the partitioned relation would fail.", "title": "Prevent dropping a tablespace that is referenced by a partitioned relation, but is not used for any actual storage", "commits": ["5b01a6f13"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "8b0ddf00bdab1ea36b7d951bb4ad0b5aac4552b4d7e0bab9685ea51ec95d579a", "section_path": ["Changes"], "commit_groups": [["5b01a6f13", "c442b32c2", "c9b702552", "ebfe2dbd6"]], "identity_text": "Prevent dropping a tablespace that is referenced by a partitioned relation, but is not used for any actual storage (Álvaro Herrera) Previously this was allowed, but subsequent operations on the partitioned relation would fail.", "commit_aliases": ["5b01a6f13", "c442b32c2", "c9b702552", "ebfe2dbd6"], "source_commits": ["5b01a6f13"], "source_entry_id": "13.2/changes/029", "db_id": "f3555a3cdc4f456c748a9f3182832ae9", "patch_ids": ["cd96419eb67c205e8e5e6e161207aff7"], "statement_hash": "1b242455afe9bbc1e5ca313b4d1168bbb369d77acf581a83d48e8adac82e320d", "relations": [{"rule": 2, "type": "equivalent", "target": "22a821e63ed0d901cca25054f4079606", "evidence": {"same_day": true, "patch_ids": ["cd96419eb67c205e8e5e6e161207aff7"], "statement_hash": "1b242455afe9bbc1e5ca313b4d1168bbb369d77acf581a83d48e8adac82e320d"}}, {"rule": 2, "type": "equivalent", "target": "7e8ee5bd962961ccc1ca440bc4341d8e", "evidence": {"same_day": true, "patch_ids": ["cd96419eb67c205e8e5e6e161207aff7"], "statement_hash": "1b242455afe9bbc1e5ca313b4d1168bbb369d77acf581a83d48e8adac82e320d"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "7e8ee5bd962961ccc1ca440bc4341d8e", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Prevent dropping a tablespace that is referenced by a partitioned relation, but is not used for any actual storage", "evidence": {"same_day": true, "patch_ids": ["cd96419eb67c205e8e5e6e161207aff7"], "statement_hash": "1b242455afe9bbc1e5ca313b4d1168bbb369d77acf581a83d48e8adac82e320d"}, "url": "/docs/compare/?release=12.6#12.6-41a3bde3e5cb2ef6", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "22a821e63ed0d901cca25054f4079606", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Prevent dropping a tablespace that is referenced by a partitioned relation, but is not used for any actual storage", "evidence": {"same_day": true, "patch_ids": ["cd96419eb67c205e8e5e6e161207aff7"], "statement_hash": "1b242455afe9bbc1e5ca313b4d1168bbb369d77acf581a83d48e8adac82e320d"}, "url": "/docs/compare/?release=11.11#11.11-0a898d218cc67206", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}]}, {"id": "13.2-9e9876a76c57a075", "cves": [], "html": "Fix progress reporting for CLUSTER (Matthias van de Meent) §
Fix handling of backslash-escaped multibyte characters in COPY FROM (Heikki Linnakangas) §
A backslash followed by a multibyte character was not handled correctly. In some client character encodings, this could lead to misinterpreting part of a multibyte character as a field separator or end-of-copy-data marker.
", "text": "Fix handling of backslash-escaped multibyte characters in COPY FROM (Heikki Linnakangas) § A backslash followed by a multibyte character was not handled correctly. In some client character encodings, this could lead to misinterpreting part of a multibyte character as a field separator or end-of-copy-data marker.", "title": "Fix handling of backslash-escaped multibyte characters in COPY FROM", "commits": ["c87cbd51e"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "5d0d0ed123da3a8842f8768a032903a593c418bf428e14d3b974de8c249423e3", "section_path": ["Changes"], "commit_groups": [["9b0ce8957", "aaf266157", "c06632e48", "c444472af", "c87cbd51e", "d9b4163c5", "e152ccc7f"]], "identity_text": "Fix handling of backslash-escaped multibyte characters in COPY FROM (Heikki Linnakangas) A backslash followed by a multibyte character was not handled correctly. In some client character encodings, this could lead to misinterpreting part of a multibyte character as a field separator or end-of-copy-data marker.", "commit_aliases": ["9b0ce8957", "aaf266157", "c06632e48", "c444472af", "c87cbd51e", "d9b4163c5", "e152ccc7f"], "source_commits": ["c87cbd51e"], "source_entry_id": "13.2/changes/031", "db_id": "94c3dc3f04b7d0b45cacb5b6966c3453", "patch_ids": ["461834a457f95e1e46e3f5f853762185"], "statement_hash": "a17e1d9ba5b15acc4ec34752b30d9a8117208c92aa6ae3f0a770360600bf6170", "relations": [{"rule": 2, "type": "equivalent", "target": "24a0975624b55034a36cc45c82dda4fa", "evidence": {"same_day": true, "patch_ids": ["461834a457f95e1e46e3f5f853762185"], "statement_hash": "a17e1d9ba5b15acc4ec34752b30d9a8117208c92aa6ae3f0a770360600bf6170"}}, {"rule": 2, "type": "equivalent", "target": "2ff2a9fef7757aea510f778f3aef08f9", "evidence": {"same_day": true, "patch_ids": ["461834a457f95e1e46e3f5f853762185"], "statement_hash": "a17e1d9ba5b15acc4ec34752b30d9a8117208c92aa6ae3f0a770360600bf6170"}}, {"rule": 2, "type": "equivalent", "target": "6a24303fb124f0e6a1b631499dbc5513", "evidence": {"same_day": true, "patch_ids": ["461834a457f95e1e46e3f5f853762185"], "statement_hash": "a17e1d9ba5b15acc4ec34752b30d9a8117208c92aa6ae3f0a770360600bf6170"}}, {"rule": 2, "type": "equivalent", "target": "c9c4eb396a62b6f9b564bb3623096201", "evidence": {"same_day": true, "patch_ids": ["461834a457f95e1e46e3f5f853762185"], "statement_hash": "a17e1d9ba5b15acc4ec34752b30d9a8117208c92aa6ae3f0a770360600bf6170"}}, {"rule": 2, "type": "equivalent", "target": "cdac1aaac0da3071bf9f337dbf09252b", "evidence": {"same_day": true, "patch_ids": ["461834a457f95e1e46e3f5f853762185"], "statement_hash": "a17e1d9ba5b15acc4ec34752b30d9a8117208c92aa6ae3f0a770360600bf6170"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "6a24303fb124f0e6a1b631499dbc5513", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Fix handling of backslash-escaped multibyte characters in COPY FROM", "evidence": {"same_day": true, "patch_ids": ["461834a457f95e1e46e3f5f853762185"], "statement_hash": "a17e1d9ba5b15acc4ec34752b30d9a8117208c92aa6ae3f0a770360600bf6170"}, "url": "/docs/compare/?release=12.6#12.6-3f4fe8706c75c1ad", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "c9c4eb396a62b6f9b564bb3623096201", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Fix handling of backslash-escaped multibyte characters in COPY FROM", "evidence": {"same_day": true, "patch_ids": ["461834a457f95e1e46e3f5f853762185"], "statement_hash": "a17e1d9ba5b15acc4ec34752b30d9a8117208c92aa6ae3f0a770360600bf6170"}, "url": "/docs/compare/?release=11.11#11.11-62de32e12f7c03e4", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "2ff2a9fef7757aea510f778f3aef08f9", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Fix handling of backslash-escaped multibyte characters in COPY FROM", "evidence": {"same_day": true, "patch_ids": ["461834a457f95e1e46e3f5f853762185"], "statement_hash": "a17e1d9ba5b15acc4ec34752b30d9a8117208c92aa6ae3f0a770360600bf6170"}, "url": "/docs/compare/?release=10.16#10.16-62de32e12f7c03e4", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "24a0975624b55034a36cc45c82dda4fa", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "Fix handling of backslash-escaped multibyte characters in COPY FROM", "evidence": {"same_day": true, "patch_ids": ["461834a457f95e1e46e3f5f853762185"], "statement_hash": "a17e1d9ba5b15acc4ec34752b30d9a8117208c92aa6ae3f0a770360600bf6170"}, "url": "/docs/compare/?release=9.6.21#9.6.21-62de32e12f7c03e4", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "cdac1aaac0da3071bf9f337dbf09252b", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "Fix handling of backslash-escaped multibyte characters in COPY FROM", "evidence": {"same_day": true, "patch_ids": ["461834a457f95e1e46e3f5f853762185"], "statement_hash": "a17e1d9ba5b15acc4ec34752b30d9a8117208c92aa6ae3f0a770360600bf6170"}, "url": "/docs/compare/?release=9.5.25#9.5.25-62de32e12f7c03e4", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-82cfab27199806cf", "cves": [], "html": "Avoid preallocating executor hash tables in EXPLAIN without ANALYZE (Alexey Bashtanov) §
Fix recently-introduced race condition in LISTEN/NOTIFY queue handling (Tom Lane) §
A newly-listening backend could attempt to read SLRU pages that were in process of being truncated, possibly causing an error.
", "text": "Fix recently-introduced race condition in LISTEN/NOTIFY queue handling (Tom Lane) § A newly-listening backend could attempt to read SLRU pages that were in process of being truncated, possibly causing an error.", "title": "Fix recently-introduced race condition in LISTEN/NOTIFY queue handling", "commits": ["f5de090cc"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "0b01fbdf063c83b049cb06b73bbd251315320f4aaf6cfcfd9411e5a5368093d8", "section_path": ["Changes"], "commit_groups": [["40f2fbe71", "60d6c7143", "8a4069766", "9c83b54a9", "cbc7a7a10", "f5de090cc", "f6324bbbe"]], "identity_text": "Fix recently-introduced race condition in LISTEN/NOTIFY queue handling (Tom Lane) A newly-listening backend could attempt to read SLRU pages that were in process of being truncated, possibly causing an error.", "commit_aliases": ["40f2fbe71", "60d6c7143", "8a4069766", "9c83b54a9", "cbc7a7a10", "f5de090cc", "f6324bbbe"], "source_commits": ["f5de090cc"], "source_entry_id": "13.2/changes/033", "db_id": "7f1b660f6cf2d7c9e7f41a8bc976dc8c", "patch_ids": ["ea98013d52c6be2ab647d4476de3a52f"], "statement_hash": "235fcd797da69ad2776036c170dbd3809d2986c66605d663bd09b980513001f3", "relations": [{"rule": 2, "type": "equivalent", "target": "0bf73cc3e92e396b8b7b8ef47ad0ed94", "evidence": {"same_day": true, "patch_ids": ["ea98013d52c6be2ab647d4476de3a52f"]}}, {"rule": 2, "type": "equivalent", "target": "4f36e867669616cefd25a3591d90ffd3", "evidence": {"same_day": true, "patch_ids": ["ea98013d52c6be2ab647d4476de3a52f"]}}, {"rule": 2, "type": "equivalent", "target": "7440d30cb4ded44aef75709a7d425fe4", "evidence": {"same_day": true, "patch_ids": ["ea98013d52c6be2ab647d4476de3a52f"]}}, {"rule": 2, "type": "equivalent", "target": "8d4a739a104f6fcb2e552035812da17f", "evidence": {"same_day": true, "patch_ids": ["ea98013d52c6be2ab647d4476de3a52f"]}}, {"rule": 2, "type": "equivalent", "target": "9eac3ad779207a104ee19f411657cc23", "evidence": {"same_day": true, "patch_ids": ["ea98013d52c6be2ab647d4476de3a52f"]}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4f36e867669616cefd25a3591d90ffd3", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Fix recently-introduced race conditions in LISTEN/NOTIFY queue handling", "evidence": {"same_day": true, "patch_ids": ["ea98013d52c6be2ab647d4476de3a52f"]}, "url": "/docs/compare/?release=12.6#12.6-4318846d64653bfa", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "0bf73cc3e92e396b8b7b8ef47ad0ed94", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Fix recently-introduced race conditions in LISTEN/NOTIFY queue handling", "evidence": {"same_day": true, "patch_ids": ["ea98013d52c6be2ab647d4476de3a52f"]}, "url": "/docs/compare/?release=11.11#11.11-132bdd0c97ac1a58", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "9eac3ad779207a104ee19f411657cc23", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Fix recently-introduced race conditions in LISTEN/NOTIFY queue handling", "evidence": {"same_day": true, "patch_ids": ["ea98013d52c6be2ab647d4476de3a52f"]}, "url": "/docs/compare/?release=10.16#10.16-132bdd0c97ac1a58", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "7440d30cb4ded44aef75709a7d425fe4", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "Fix recently-introduced race conditions in LISTEN/NOTIFY queue handling", "evidence": {"same_day": true, "patch_ids": ["ea98013d52c6be2ab647d4476de3a52f"]}, "url": "/docs/compare/?release=9.6.21#9.6.21-132bdd0c97ac1a58", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "8d4a739a104f6fcb2e552035812da17f", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "Fix recently-introduced race conditions in LISTEN/NOTIFY queue handling", "evidence": {"same_day": true, "patch_ids": ["ea98013d52c6be2ab647d4476de3a52f"]}, "url": "/docs/compare/?release=9.5.25#9.5.25-132bdd0c97ac1a58", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-e3de59e9f6540723", "cves": [], "html": "Allow the jsonb concatenation operator to handle all combinations of JSON data types (Tom Lane) §
We can concatenate two JSON objects or two JSON arrays. Handle other cases by wrapping non-array inputs in one-element arrays, then performing an array concatenation. Previously, some combinations of inputs followed this rule but others arbitrarily threw an error.
", "text": "Allow the jsonb concatenation operator to handle all combinations of JSON data types (Tom Lane) § We can concatenate two JSON objects or two JSON arrays. Handle other cases by wrapping non-array inputs in one-element arrays, then performing an array concatenation. Previously, some combinations of inputs followed this rule but others arbitrarily threw an error.", "title": "Allow the jsonb concatenation operator to handle all combinations of JSON data types", "commits": ["38d30a14b"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "f7a08b05e5b5402489b2ea139de17745516f384a990fee942b830c3b7672534d", "section_path": ["Changes"], "commit_groups": [["1d5f3f976", "38bef9e43", "38d30a14b", "542248f9d", "75c8ef5ae", "edcdbc44e", "ff5d5611c"]], "identity_text": "Allow the jsonb concatenation operator to handle all combinations of JSON data types (Tom Lane) We can concatenate two JSON objects or two JSON arrays. Handle other cases by wrapping non-array inputs in one-element arrays, then performing an array concatenation. Previously, some combinations of inputs followed this rule but others arbitrarily threw an error.", "commit_aliases": ["1d5f3f976", "38bef9e43", "38d30a14b", "542248f9d", "75c8ef5ae", "edcdbc44e", "ff5d5611c"], "source_commits": ["38d30a14b"], "source_entry_id": "13.2/changes/034", "db_id": "93d7b6ccd36ac19c542c07094682ad7b", "patch_ids": ["5ed799927271d5a1dcd801fb141eeaf0"], "statement_hash": "403ddc45ba47e71aa239099a08f7217e5f8adfb12b59c6860d4d562f6053dd5d", "relations": [{"rule": 2, "type": "equivalent", "target": "0c2bc94740c986e4ff61424643df510c", "evidence": {"same_day": true, "patch_ids": ["5ed799927271d5a1dcd801fb141eeaf0"], "statement_hash": "403ddc45ba47e71aa239099a08f7217e5f8adfb12b59c6860d4d562f6053dd5d"}}, {"rule": 2, "type": "equivalent", "target": "7f671eec85cdff6361bb278d507f2096", "evidence": {"same_day": true, "patch_ids": ["5ed799927271d5a1dcd801fb141eeaf0"], "statement_hash": "403ddc45ba47e71aa239099a08f7217e5f8adfb12b59c6860d4d562f6053dd5d"}}, {"rule": 2, "type": "equivalent", "target": "87044083e958310e18dffe61a245164f", "evidence": {"same_day": true, "patch_ids": ["5ed799927271d5a1dcd801fb141eeaf0"], "statement_hash": "403ddc45ba47e71aa239099a08f7217e5f8adfb12b59c6860d4d562f6053dd5d"}}, {"rule": 2, "type": "equivalent", "target": "b6c0b49e9ab8978617cd32bb25db2d9a", "evidence": {"same_day": true, "patch_ids": ["5ed799927271d5a1dcd801fb141eeaf0"], "statement_hash": "403ddc45ba47e71aa239099a08f7217e5f8adfb12b59c6860d4d562f6053dd5d"}}, {"rule": 2, "type": "equivalent", "target": "b6ecd32d870e73bdcc62baa1fb18206e", "evidence": {"same_day": true, "patch_ids": ["5ed799927271d5a1dcd801fb141eeaf0"], "statement_hash": "403ddc45ba47e71aa239099a08f7217e5f8adfb12b59c6860d4d562f6053dd5d"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "87044083e958310e18dffe61a245164f", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Allow the jsonb concatenation operator to handle all combinations of JSON data types", "evidence": {"same_day": true, "patch_ids": ["5ed799927271d5a1dcd801fb141eeaf0"], "statement_hash": "403ddc45ba47e71aa239099a08f7217e5f8adfb12b59c6860d4d562f6053dd5d"}, "url": "/docs/compare/?release=12.6#12.6-5fcd429eb0b12445", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "0c2bc94740c986e4ff61424643df510c", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Allow the jsonb concatenation operator to handle all combinations of JSON data types", "evidence": {"same_day": true, "patch_ids": ["5ed799927271d5a1dcd801fb141eeaf0"], "statement_hash": "403ddc45ba47e71aa239099a08f7217e5f8adfb12b59c6860d4d562f6053dd5d"}, "url": "/docs/compare/?release=11.11#11.11-8da0775e5c491738", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "b6ecd32d870e73bdcc62baa1fb18206e", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Allow the jsonb concatenation operator to handle all combinations of JSON data types", "evidence": {"same_day": true, "patch_ids": ["5ed799927271d5a1dcd801fb141eeaf0"], "statement_hash": "403ddc45ba47e71aa239099a08f7217e5f8adfb12b59c6860d4d562f6053dd5d"}, "url": "/docs/compare/?release=10.16#10.16-8da0775e5c491738", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "7f671eec85cdff6361bb278d507f2096", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "Allow the jsonb concatenation operator to handle all combinations of JSON data types", "evidence": {"same_day": true, "patch_ids": ["5ed799927271d5a1dcd801fb141eeaf0"], "statement_hash": "403ddc45ba47e71aa239099a08f7217e5f8adfb12b59c6860d4d562f6053dd5d"}, "url": "/docs/compare/?release=9.6.21#9.6.21-8da0775e5c491738", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "b6c0b49e9ab8978617cd32bb25db2d9a", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "Allow the jsonb concatenation operator to handle all combinations of JSON data types", "evidence": {"same_day": true, "patch_ids": ["5ed799927271d5a1dcd801fb141eeaf0"], "statement_hash": "403ddc45ba47e71aa239099a08f7217e5f8adfb12b59c6860d4d562f6053dd5d"}, "url": "/docs/compare/?release=9.5.25#9.5.25-8da0775e5c491738", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-3b1628b56821d4af", "cves": [], "html": "Fix use of uninitialized value while parsing a * quantifier in a BRE-mode regular expression (Tom Lane) §
This error could cause the quantifier to act non-greedy, that is behave like a *? quantifier would do in full regular expressions.
Fix numeric power() for the case where the exponent is exactly INT_MIN (-2147483648) (Dean Rasheed) § §
Previously, a result with no significant digits was produced.
", "text": "Fix numeric power() for the case where the exponent is exactly INT_MIN (-2147483648) (Dean Rasheed) § § Previously, a result with no significant digits was produced.", "title": "Fix numeric power() for the case where the exponent is exactly INT_MIN (-2147483648)", "commits": ["5777b6ea2", "e15c384d7"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "1652b5646bf2c13fad36a1cc78aa9ac85a669564171339de0f1ddc6c44016274", "section_path": ["Changes"], "commit_groups": [["0097193b1", "5777b6ea2", "740780a61", "ab042d010", "f0b9bada5", "fead67c24"], ["160a9e425", "258b77005", "275b190b3", "9a299dff2", "bc43b7c2c", "e15c384d7"]], "identity_text": "Fix numeric power() for the case where the exponent is exactly INT_MIN (-2147483648) (Dean Rasheed) Previously, a result with no significant digits was produced.", "commit_aliases": ["0097193b1", "160a9e425", "258b77005", "275b190b3", "5777b6ea2", "740780a61", "9a299dff2", "ab042d010", "bc43b7c2c", "e15c384d7", "f0b9bada5", "fead67c24"], "source_commits": ["5777b6ea2", "e15c384d7"], "source_entry_id": "13.2/changes/036", "db_id": "abfa8a6eff35112bbc03ff90d6b33906", "patch_ids": ["125709d508d3d5036d8c334168321c69", "f908550d1714b44d15d1881ae34843ab"], "statement_hash": "f15243a16f9c7a505a28136b6eca2480248a3843a3724cdd55f94daa6ec50db7", "relations": [{"rule": 2, "type": "equivalent", "target": "179170dc05245b90ed197c554d114bbe", "evidence": {"same_day": true, "patch_ids": ["125709d508d3d5036d8c334168321c69", "f908550d1714b44d15d1881ae34843ab"], "statement_hash": "f15243a16f9c7a505a28136b6eca2480248a3843a3724cdd55f94daa6ec50db7"}}, {"rule": 2, "type": "equivalent", "target": "4126106c6893a65f3ca17d3c82a5e2b8", "evidence": {"same_day": true, "patch_ids": ["125709d508d3d5036d8c334168321c69", "f908550d1714b44d15d1881ae34843ab"], "statement_hash": "f15243a16f9c7a505a28136b6eca2480248a3843a3724cdd55f94daa6ec50db7"}}, {"rule": 2, "type": "equivalent", "target": "5e89f04f10b69e2b238fd3dfd74ad14e", "evidence": {"same_day": true, "patch_ids": ["125709d508d3d5036d8c334168321c69", "f908550d1714b44d15d1881ae34843ab"], "statement_hash": "f15243a16f9c7a505a28136b6eca2480248a3843a3724cdd55f94daa6ec50db7"}}, {"rule": 2, "type": "equivalent", "target": "c361685144e7623aadb747f0957e72ce", "evidence": {"same_day": true, "patch_ids": ["125709d508d3d5036d8c334168321c69", "f908550d1714b44d15d1881ae34843ab"], "statement_hash": "f15243a16f9c7a505a28136b6eca2480248a3843a3724cdd55f94daa6ec50db7"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c361685144e7623aadb747f0957e72ce", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Fix numeric power() for the case where the exponent is exactly INT_MIN (-2147483648)", "evidence": {"same_day": true, "patch_ids": ["125709d508d3d5036d8c334168321c69", "f908550d1714b44d15d1881ae34843ab"], "statement_hash": "f15243a16f9c7a505a28136b6eca2480248a3843a3724cdd55f94daa6ec50db7"}, "url": "/docs/compare/?release=12.6#12.6-a0c631e509e87510", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "4126106c6893a65f3ca17d3c82a5e2b8", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Fix numeric power() for the case where the exponent is exactly INT_MIN (-2147483648)", "evidence": {"same_day": true, "patch_ids": ["125709d508d3d5036d8c334168321c69", "f908550d1714b44d15d1881ae34843ab"], "statement_hash": "f15243a16f9c7a505a28136b6eca2480248a3843a3724cdd55f94daa6ec50db7"}, "url": "/docs/compare/?release=11.11#11.11-af98e826fdfea51c", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "179170dc05245b90ed197c554d114bbe", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Fix numeric power() for the case where the exponent is exactly INT_MIN (-2147483648)", "evidence": {"same_day": true, "patch_ids": ["125709d508d3d5036d8c334168321c69", "f908550d1714b44d15d1881ae34843ab"], "statement_hash": "f15243a16f9c7a505a28136b6eca2480248a3843a3724cdd55f94daa6ec50db7"}, "url": "/docs/compare/?release=10.16#10.16-af98e826fdfea51c", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "5e89f04f10b69e2b238fd3dfd74ad14e", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "Fix numeric power() for the case where the exponent is exactly INT_MIN (-2147483648)", "evidence": {"same_day": true, "patch_ids": ["125709d508d3d5036d8c334168321c69", "f908550d1714b44d15d1881ae34843ab"], "statement_hash": "f15243a16f9c7a505a28136b6eca2480248a3843a3724cdd55f94daa6ec50db7"}, "url": "/docs/compare/?release=9.6.21#9.6.21-af98e826fdfea51c", "source_url": "/docs/release/9.6.21/#AEN132403"}]}, {"id": "13.2-604959b1e3c17442", "cves": [], "html": "Fix integer-overflow cases in substring() functions (Tom Lane, Pavel Stehule) §
If the specified starting index and length overflow an integer when added together, substring() misbehaved, either throwing a bogus “negative substring length” error for a case that should succeed, or failing to complain that a negative length is negative (and instead returning the whole string, in most cases).
Prevent possible data loss from incorrect detection of the wraparound point of an SLRU log (Noah Misch) §
\nThe wraparound point typically falls in the middle of a page, which must be rounded off to a page boundary, and that was not done correctly. No issue could arise unless an installation had gotten to within one page of SLRU overflow, which is unlikely in a properly-functioning system. If this did happen, it would manifest in later “apparent wraparound” or “could not access status of transaction” errors.
", "text": "Prevent possible data loss from incorrect detection of the wraparound point of an SLRU log (Noah Misch) § The wraparound point typically falls in the middle of a page, which must be rounded off to a page boundary, and that was not done correctly. No issue could arise unless an installation had gotten to within one page of SLRU overflow, which is unlikely in a properly-functioning system. If this did happen, it would manifest in later “apparent wraparound” or “could not access status of transaction” errors.", "title": "Prevent possible data loss from incorrect detection of the wraparound point of an SLRU log", "commits": ["6eb3fc7fc"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "8adee13f4eeb7b0ef9bd1eeae57aace45ed69c7df92c328dafb40db0041e9486", "section_path": ["Changes"], "commit_groups": [["1a31d8c52", "66087f7e9", "677f6cb1d", "6db992833", "6eb3fc7fc", "9afba9b0e", "c424c75f5"]], "identity_text": "Prevent possible data loss from incorrect detection of the wraparound point of an SLRU log (Noah Misch) The wraparound point typically falls in the middle of a page, which must be rounded off to a page boundary, and that was not done correctly. No issue could arise unless an installation had gotten to within one page of SLRU overflow, which is unlikely in a properly-functioning system. If this did happen, it would manifest in later apparent wraparound or could not access status of transaction errors.", "commit_aliases": ["1a31d8c52", "66087f7e9", "677f6cb1d", "6db992833", "6eb3fc7fc", "9afba9b0e", "c424c75f5"], "source_commits": ["6eb3fc7fc"], "source_entry_id": "13.2/changes/038", "db_id": "9d6fefefda4424ff256117d078fb3a83", "patch_ids": ["43edf42b8d0af7448c1134c6e0a51932"], "statement_hash": "74815865e964e4a540aa47551ac5f1743036a88d734402c5d1dbbc0f631dda41", "relations": [{"rule": 2, "type": "equivalent", "target": "15976083a26505a6d47ec9965e23b80b", "evidence": {"same_day": true, "patch_ids": ["43edf42b8d0af7448c1134c6e0a51932"], "statement_hash": "74815865e964e4a540aa47551ac5f1743036a88d734402c5d1dbbc0f631dda41"}}, {"rule": 2, "type": "equivalent", "target": "3e20cf24a2c485ff94decaa8471617f6", "evidence": {"same_day": true, "patch_ids": ["43edf42b8d0af7448c1134c6e0a51932"], "statement_hash": "74815865e964e4a540aa47551ac5f1743036a88d734402c5d1dbbc0f631dda41"}}, {"rule": 2, "type": "equivalent", "target": "8a91acd484f811761b08816ea4a34663", "evidence": {"same_day": true, "patch_ids": ["43edf42b8d0af7448c1134c6e0a51932"], "statement_hash": "74815865e964e4a540aa47551ac5f1743036a88d734402c5d1dbbc0f631dda41"}}, {"rule": 2, "type": "equivalent", "target": "a8dcf351c2c3ebb25cf0c94c4cdccd8b", "evidence": {"same_day": true, "patch_ids": ["43edf42b8d0af7448c1134c6e0a51932"], "statement_hash": "74815865e964e4a540aa47551ac5f1743036a88d734402c5d1dbbc0f631dda41"}}, {"rule": 2, "type": "equivalent", "target": "d78826c6d098cf8fdd1a0a4ed2e9b95d", "evidence": {"same_day": true, "patch_ids": ["43edf42b8d0af7448c1134c6e0a51932"], "statement_hash": "74815865e964e4a540aa47551ac5f1743036a88d734402c5d1dbbc0f631dda41"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "15976083a26505a6d47ec9965e23b80b", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Prevent possible data loss from incorrect detection of the wraparound point of an SLRU log", "evidence": {"same_day": true, "patch_ids": ["43edf42b8d0af7448c1134c6e0a51932"], "statement_hash": "74815865e964e4a540aa47551ac5f1743036a88d734402c5d1dbbc0f631dda41"}, "url": "/docs/compare/?release=12.6#12.6-b019c5b0cb3344a6", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "3e20cf24a2c485ff94decaa8471617f6", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Prevent possible data loss from incorrect detection of the wraparound point of an SLRU log", "evidence": {"same_day": true, "patch_ids": ["43edf42b8d0af7448c1134c6e0a51932"], "statement_hash": "74815865e964e4a540aa47551ac5f1743036a88d734402c5d1dbbc0f631dda41"}, "url": "/docs/compare/?release=11.11#11.11-5f0c2f4bc2aa5bcb", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "8a91acd484f811761b08816ea4a34663", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Prevent possible data loss from incorrect detection of the wraparound point of an SLRU log", "evidence": {"same_day": true, "patch_ids": ["43edf42b8d0af7448c1134c6e0a51932"], "statement_hash": "74815865e964e4a540aa47551ac5f1743036a88d734402c5d1dbbc0f631dda41"}, "url": "/docs/compare/?release=10.16#10.16-5f0c2f4bc2aa5bcb", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "d78826c6d098cf8fdd1a0a4ed2e9b95d", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "Prevent possible data loss from incorrect detection of the wraparound point of an SLRU log", "evidence": {"same_day": true, "patch_ids": ["43edf42b8d0af7448c1134c6e0a51932"], "statement_hash": "74815865e964e4a540aa47551ac5f1743036a88d734402c5d1dbbc0f631dda41"}, "url": "/docs/compare/?release=9.6.21#9.6.21-5f0c2f4bc2aa5bcb", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "a8dcf351c2c3ebb25cf0c94c4cdccd8b", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "Prevent possible data loss from incorrect detection of the wraparound point of an SLRU log", "evidence": {"same_day": true, "patch_ids": ["43edf42b8d0af7448c1134c6e0a51932"], "statement_hash": "74815865e964e4a540aa47551ac5f1743036a88d734402c5d1dbbc0f631dda41"}, "url": "/docs/compare/?release=9.5.25#9.5.25-5f0c2f4bc2aa5bcb", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-e61c6810e5170d84", "cves": [], "html": "Fix WAL-reading logic to handle timeline switches correctly (Kyotaro Horiguchi, Fujii Masao) § §
\nPreviously, if WAL archiving is enabled, a standby could fail to follow a primary running on a newer timeline, with errors like “requested WAL segment has already been removed”.
", "text": "Fix WAL-reading logic to handle timeline switches correctly (Kyotaro Horiguchi, Fujii Masao) § § Previously, if WAL archiving is enabled, a standby could fail to follow a primary running on a newer timeline, with errors like “requested WAL segment has already been removed”.", "title": "Fix WAL-reading logic to handle timeline switches correctly", "commits": ["8523a0971", "94f52929a"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "c3414a686c15086a26843108f151c05508483b5d1b97c8399e57d5b7c74a0631", "section_path": ["Changes"], "commit_groups": [["424d7a9b2", "8523a0971"], ["94f52929a", "fef5b47f6"]], "identity_text": "Fix WAL-reading logic to handle timeline switches correctly (Kyotaro Horiguchi, Fujii Masao) Previously, if WAL archiving is enabled, a standby could fail to follow a primary running on a newer timeline, with errors like requested WAL segment has already been removed.", "commit_aliases": ["424d7a9b2", "8523a0971", "94f52929a", "fef5b47f6"], "source_commits": ["8523a0971", "94f52929a"], "source_entry_id": "13.2/changes/039", "db_id": "b9b731c37833b0bc5a52097a7c70e51d", "patch_ids": ["c696a1265247323e78143df104b42a5d", "fa91ebabc4e2e842a07174e895d5e510"], "statement_hash": "932359d0aa7db1902b1f178964f4d1ffee5ff785f8d151c6a8e3a77a9f3cac9a", "relations": [], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.2-56ad1633a063bb4f", "cves": [], "html": "Fix memory leak in walsender processes while sending new snapshots for logical decoding (Amit Kapila) §
", "text": "Fix memory leak in walsender processes while sending new snapshots for logical decoding (Amit Kapila) §", "title": "Fix memory leak in walsender processes while sending new snapshots for logical decoding", "commits": ["0685c5c1b"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "c91bf12545a21e40c4ea9c1d2c9c2d6fb9ac514d7f4e8c85049296642d864e2c", "section_path": ["Changes"], "commit_groups": [["0685c5c1b", "0b2ae3c92", "4bccceaa9", "636b6f99c", "7adc408f4", "ee1b38f65", "f2b268ee0"]], "identity_text": "Fix memory leak in walsender processes while sending new snapshots for logical decoding (Amit Kapila)", "commit_aliases": ["0685c5c1b", "0b2ae3c92", "4bccceaa9", "636b6f99c", "7adc408f4", "ee1b38f65", "f2b268ee0"], "source_commits": ["0685c5c1b"], "source_entry_id": "13.2/changes/040", "db_id": "992b0a7048f1421bf7e451c45670a527", "patch_ids": ["5a1af854c74760936661b82bc4b40315"], "statement_hash": "0ba2c7d74cf0adba0015be64d2a810dbd7a648f4709426abca4f90e2a93d379b", "relations": [{"rule": 2, "type": "equivalent", "target": "223acd474f4edb99eabbb5ddb2c1de17", "evidence": {"same_day": true, "patch_ids": ["5a1af854c74760936661b82bc4b40315"], "statement_hash": "0ba2c7d74cf0adba0015be64d2a810dbd7a648f4709426abca4f90e2a93d379b"}}, {"rule": 2, "type": "equivalent", "target": "248168c9b873abc8f01b193d4ea3db8b", "evidence": {"same_day": true, "patch_ids": ["5a1af854c74760936661b82bc4b40315"], "statement_hash": "0ba2c7d74cf0adba0015be64d2a810dbd7a648f4709426abca4f90e2a93d379b"}}, {"rule": 2, "type": "equivalent", "target": "a6aa39364fd044803679df8a8b257492", "evidence": {"same_day": true, "patch_ids": ["5a1af854c74760936661b82bc4b40315"], "statement_hash": "0ba2c7d74cf0adba0015be64d2a810dbd7a648f4709426abca4f90e2a93d379b"}}, {"rule": 2, "type": "equivalent", "target": "ae92861fd5ea74b7c9fbe52d83cb6080", "evidence": {"same_day": true, "patch_ids": ["5a1af854c74760936661b82bc4b40315"], "statement_hash": "0ba2c7d74cf0adba0015be64d2a810dbd7a648f4709426abca4f90e2a93d379b"}}, {"rule": 2, "type": "equivalent", "target": "c9d476cdfa617702645106e5d7708479", "evidence": {"same_day": true, "patch_ids": ["5a1af854c74760936661b82bc4b40315"], "statement_hash": "0ba2c7d74cf0adba0015be64d2a810dbd7a648f4709426abca4f90e2a93d379b"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "223acd474f4edb99eabbb5ddb2c1de17", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Fix memory leak in walsender processes while sending new snapshots for logical decoding", "evidence": {"same_day": true, "patch_ids": ["5a1af854c74760936661b82bc4b40315"], "statement_hash": "0ba2c7d74cf0adba0015be64d2a810dbd7a648f4709426abca4f90e2a93d379b"}, "url": "/docs/compare/?release=12.6#12.6-8e850d071919e267", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "a6aa39364fd044803679df8a8b257492", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Fix memory leak in walsender processes while sending new snapshots for logical decoding", "evidence": {"same_day": true, "patch_ids": ["5a1af854c74760936661b82bc4b40315"], "statement_hash": "0ba2c7d74cf0adba0015be64d2a810dbd7a648f4709426abca4f90e2a93d379b"}, "url": "/docs/compare/?release=11.11#11.11-c9e68f11c1faa8a8", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "ae92861fd5ea74b7c9fbe52d83cb6080", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Fix memory leak in walsender processes while sending new snapshots for logical decoding", "evidence": {"same_day": true, "patch_ids": ["5a1af854c74760936661b82bc4b40315"], "statement_hash": "0ba2c7d74cf0adba0015be64d2a810dbd7a648f4709426abca4f90e2a93d379b"}, "url": "/docs/compare/?release=10.16#10.16-c9e68f11c1faa8a8", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "248168c9b873abc8f01b193d4ea3db8b", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "Fix memory leak in walsender processes while sending new snapshots for logical decoding", "evidence": {"same_day": true, "patch_ids": ["5a1af854c74760936661b82bc4b40315"], "statement_hash": "0ba2c7d74cf0adba0015be64d2a810dbd7a648f4709426abca4f90e2a93d379b"}, "url": "/docs/compare/?release=9.6.21#9.6.21-c9e68f11c1faa8a8", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "c9d476cdfa617702645106e5d7708479", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "Fix memory leak in walsender processes while sending new snapshots for logical decoding", "evidence": {"same_day": true, "patch_ids": ["5a1af854c74760936661b82bc4b40315"], "statement_hash": "0ba2c7d74cf0adba0015be64d2a810dbd7a648f4709426abca4f90e2a93d379b"}, "url": "/docs/compare/?release=9.5.25#9.5.25-c9e68f11c1faa8a8", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-192175330b82bbf8", "cves": [], "html": "Fix relation cache leak in walsender processes while sending row changes via the root of a partitioned relation during logical replication (Amit Langote, Mark Zhao) §
", "text": "Fix relation cache leak in walsender processes while sending row changes via the root of a partitioned relation during logical replication (Amit Langote, Mark Zhao) §", "title": "Fix relation cache leak in walsender processes while sending row changes via the root of a partitioned relation during logical replication", "commits": ["decf3fe61"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "d19fe148b4a08cc2101b58c15c2e78e4830abd3f95fb4b1340f1293f9db92700", "section_path": ["Changes"], "commit_groups": [["044aa9e70", "decf3fe61"]], "identity_text": "Fix relation cache leak in walsender processes while sending row changes via the root of a partitioned relation during logical replication (Amit Langote, Mark Zhao)", "commit_aliases": ["044aa9e70", "decf3fe61"], "source_commits": ["decf3fe61"], "source_entry_id": "13.2/changes/041", "db_id": "0ef0bc413e9a732336db2d016ae9cc40", "patch_ids": ["6b401fbd2dce839629205ba3bb2a31f0"], "statement_hash": "f6345524365af6cce57d1a96123280318cdf27269b2230b5caa21dbd703af0c4", "relations": [], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.2-0b79d4c96da2de06", "cves": [], "html": "Fix walsender to accept additional commands after terminating replication (Jeff Davis) §
", "text": "Fix walsender to accept additional commands after terminating replication (Jeff Davis) §", "title": "Fix walsender to accept additional commands after terminating replication", "commits": ["fde5f130c"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "19d177123a234bf5c7750e5a4d36e0cc52dda88d232480926150d96a4e52ffb9", "section_path": ["Changes"], "commit_groups": [["133a0906d", "4ee058a3b", "706d84fe7", "a58db3aa1", "ac7df6e8f", "f10da1e9c", "fde5f130c"]], "identity_text": "Fix walsender to accept additional commands after terminating replication (Jeff Davis)", "commit_aliases": ["133a0906d", "4ee058a3b", "706d84fe7", "a58db3aa1", "ac7df6e8f", "f10da1e9c", "fde5f130c"], "source_commits": ["fde5f130c"], "source_entry_id": "13.2/changes/042", "db_id": "240031eb7995d8d60b8259f6c86980ea", "patch_ids": ["114cacbd887f524b6efa39b9f1d67e16"], "statement_hash": "01c3cb4c26a2db836e3f6f75e2c3671456523c119069cb514345dd36e0043832", "relations": [{"rule": 2, "type": "equivalent", "target": "1bb31949c4d46ef10ecabc97100f5a93", "evidence": {"same_day": true, "patch_ids": ["114cacbd887f524b6efa39b9f1d67e16"], "statement_hash": "01c3cb4c26a2db836e3f6f75e2c3671456523c119069cb514345dd36e0043832"}}, {"rule": 2, "type": "equivalent", "target": "35f7f3f04c0302d296b43b7ec1d07903", "evidence": {"same_day": true, "patch_ids": ["114cacbd887f524b6efa39b9f1d67e16"], "statement_hash": "01c3cb4c26a2db836e3f6f75e2c3671456523c119069cb514345dd36e0043832"}}, {"rule": 2, "type": "equivalent", "target": "48424e1920bdbaf65bcbaa1ff3f5926f", "evidence": {"same_day": true, "patch_ids": ["114cacbd887f524b6efa39b9f1d67e16"], "statement_hash": "01c3cb4c26a2db836e3f6f75e2c3671456523c119069cb514345dd36e0043832"}}, {"rule": 2, "type": "equivalent", "target": "6ccf02ea61116b34c5472f0412965cd5", "evidence": {"same_day": true, "patch_ids": ["114cacbd887f524b6efa39b9f1d67e16"], "statement_hash": "01c3cb4c26a2db836e3f6f75e2c3671456523c119069cb514345dd36e0043832"}}, {"rule": 2, "type": "equivalent", "target": "e3632533a1b490faf0a6e7adf0c7bbe5", "evidence": {"same_day": true, "patch_ids": ["114cacbd887f524b6efa39b9f1d67e16"], "statement_hash": "01c3cb4c26a2db836e3f6f75e2c3671456523c119069cb514345dd36e0043832"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "35f7f3f04c0302d296b43b7ec1d07903", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Fix walsender to accept additional commands after terminating replication", "evidence": {"same_day": true, "patch_ids": ["114cacbd887f524b6efa39b9f1d67e16"], "statement_hash": "01c3cb4c26a2db836e3f6f75e2c3671456523c119069cb514345dd36e0043832"}, "url": "/docs/compare/?release=12.6#12.6-3c6889ebbbc7cca0", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "6ccf02ea61116b34c5472f0412965cd5", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Fix walsender to accept additional commands after terminating replication", "evidence": {"same_day": true, "patch_ids": ["114cacbd887f524b6efa39b9f1d67e16"], "statement_hash": "01c3cb4c26a2db836e3f6f75e2c3671456523c119069cb514345dd36e0043832"}, "url": "/docs/compare/?release=11.11#11.11-4931bede6d1f26af", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "1bb31949c4d46ef10ecabc97100f5a93", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Fix walsender to accept additional commands after terminating replication", "evidence": {"same_day": true, "patch_ids": ["114cacbd887f524b6efa39b9f1d67e16"], "statement_hash": "01c3cb4c26a2db836e3f6f75e2c3671456523c119069cb514345dd36e0043832"}, "url": "/docs/compare/?release=10.16#10.16-4931bede6d1f26af", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "48424e1920bdbaf65bcbaa1ff3f5926f", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "Fix walsender to accept additional commands after terminating replication", "evidence": {"same_day": true, "patch_ids": ["114cacbd887f524b6efa39b9f1d67e16"], "statement_hash": "01c3cb4c26a2db836e3f6f75e2c3671456523c119069cb514345dd36e0043832"}, "url": "/docs/compare/?release=9.6.21#9.6.21-4931bede6d1f26af", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "e3632533a1b490faf0a6e7adf0c7bbe5", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "Fix walsender to accept additional commands after terminating replication", "evidence": {"same_day": true, "patch_ids": ["114cacbd887f524b6efa39b9f1d67e16"], "statement_hash": "01c3cb4c26a2db836e3f6f75e2c3671456523c119069cb514345dd36e0043832"}, "url": "/docs/compare/?release=9.5.25#9.5.25-4931bede6d1f26af", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-8fb6618f0c0008bc", "cves": [], "html": "Ensure detection of deadlocks between hot standby backends and the startup (WAL-application) process (Fujii Masao) §
\nThe startup process did not run the deadlock detection code, so that in situations where the startup process is last to join a circular wait situation, the deadlock might never be recognized.
", "text": "Ensure detection of deadlocks between hot standby backends and the startup (WAL-application) process (Fujii Masao) § The startup process did not run the deadlock detection code, so that in situations where the startup process is last to join a circular wait situation, the deadlock might never be recognized.", "title": "Ensure detection of deadlocks between hot standby backends and the startup (WAL-application) process", "commits": ["0f8977b3f"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "95c75f8d4cd9278201f8589df9cfebe89ad97588f3e75d9773a756613ec27357", "section_path": ["Changes"], "commit_groups": [["0307b98d8", "0f8977b3f", "4c20e78f1", "8900b5a9d", "9f540f840", "e83771880"]], "identity_text": "Ensure detection of deadlocks between hot standby backends and the startup (WAL-application) process (Fujii Masao) The startup process did not run the deadlock detection code, so that in situations where the startup process is last to join a circular wait situation, the deadlock might never be recognized.", "commit_aliases": ["0307b98d8", "0f8977b3f", "4c20e78f1", "8900b5a9d", "9f540f840", "e83771880"], "source_commits": ["0f8977b3f"], "source_entry_id": "13.2/changes/043", "db_id": "436439ec95a41f87a0f329d48bcda1dd", "patch_ids": ["d2e02a8277baac4766bf87577edfbc58"], "statement_hash": "8dfe882b6e40bab79ce2dda4d6fd93d0a82f988001228534e873ecc6f1fb7a03", "relations": [{"rule": 2, "type": "equivalent", "target": "3b66d211bec114dc35a6189045c9c808", "evidence": {"same_day": true, "patch_ids": ["d2e02a8277baac4766bf87577edfbc58"], "statement_hash": "8dfe882b6e40bab79ce2dda4d6fd93d0a82f988001228534e873ecc6f1fb7a03"}}, {"rule": 2, "type": "equivalent", "target": "9582949b0e17b4be4348a40989470b2a", "evidence": {"same_day": true, "patch_ids": ["d2e02a8277baac4766bf87577edfbc58"], "statement_hash": "8dfe882b6e40bab79ce2dda4d6fd93d0a82f988001228534e873ecc6f1fb7a03"}}, {"rule": 2, "type": "equivalent", "target": "bc1cb2744ffcefaf578008c3d1c71c72", "evidence": {"same_day": true, "patch_ids": ["d2e02a8277baac4766bf87577edfbc58"], "statement_hash": "8dfe882b6e40bab79ce2dda4d6fd93d0a82f988001228534e873ecc6f1fb7a03"}}, {"rule": 2, "type": "equivalent", "target": "ff508ecb1cc82a838ee9f0ae6555f776", "evidence": {"same_day": true, "patch_ids": ["d2e02a8277baac4766bf87577edfbc58"], "statement_hash": "8dfe882b6e40bab79ce2dda4d6fd93d0a82f988001228534e873ecc6f1fb7a03"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "3b66d211bec114dc35a6189045c9c808", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Ensure detection of deadlocks between hot standby backends and the startup (WAL-application) process", "evidence": {"same_day": true, "patch_ids": ["d2e02a8277baac4766bf87577edfbc58"], "statement_hash": "8dfe882b6e40bab79ce2dda4d6fd93d0a82f988001228534e873ecc6f1fb7a03"}, "url": "/docs/compare/?release=12.6#12.6-32ed92971214fc61", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "ff508ecb1cc82a838ee9f0ae6555f776", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Ensure detection of deadlocks between hot standby backends and the startup (WAL-application) process", "evidence": {"same_day": true, "patch_ids": ["d2e02a8277baac4766bf87577edfbc58"], "statement_hash": "8dfe882b6e40bab79ce2dda4d6fd93d0a82f988001228534e873ecc6f1fb7a03"}, "url": "/docs/compare/?release=11.11#11.11-c7739ae74d60561c", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "bc1cb2744ffcefaf578008c3d1c71c72", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Ensure detection of deadlocks between hot standby backends and the startup (WAL-application) process", "evidence": {"same_day": true, "patch_ids": ["d2e02a8277baac4766bf87577edfbc58"], "statement_hash": "8dfe882b6e40bab79ce2dda4d6fd93d0a82f988001228534e873ecc6f1fb7a03"}, "url": "/docs/compare/?release=10.16#10.16-c7739ae74d60561c", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "9582949b0e17b4be4348a40989470b2a", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "Ensure detection of deadlocks between hot standby backends and the startup (WAL-application) process", "evidence": {"same_day": true, "patch_ids": ["d2e02a8277baac4766bf87577edfbc58"], "statement_hash": "8dfe882b6e40bab79ce2dda4d6fd93d0a82f988001228534e873ecc6f1fb7a03"}, "url": "/docs/compare/?release=9.6.21#9.6.21-c7739ae74d60561c", "source_url": "/docs/release/9.6.21/#AEN132403"}]}, {"id": "13.2-14d9d57cc1253cae", "cves": [], "html": "Fix possible failure to detect recovery conflicts while deleting an index entry that references a HOT chain (Peter Geoghegan) § §
\nThe code failed to traverse the HOT chain and might thus compute a too-old XID horizon, which could lead to incorrect conflict processing in hot standby. The practical impact of this bug is limited; in most cases the correct XID horizon would be found anyway from nearby operations.
", "text": "Fix possible failure to detect recovery conflicts while deleting an index entry that references a HOT chain (Peter Geoghegan) § § The code failed to traverse the HOT chain and might thus compute a too-old XID horizon, which could lead to incorrect conflict processing in hot standby. The practical impact of this bug is limited; in most cases the correct XID horizon would be found anyway from nearby operations.", "title": "Fix possible failure to detect recovery conflicts while deleting an index entry that references a HOT chain", "commits": ["55e535226", "7a57960ba"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "61d686b52d3236be84fbc74114cb35513913aa56b5dba2ccfc6128bf6e43f8d2", "section_path": ["Changes"], "commit_groups": [["32d6287d2", "55e535226", "5f95664e1"], ["422881744", "4f70e0910", "7a57960ba"]], "identity_text": "Fix possible failure to detect recovery conflicts while deleting an index entry that references a HOT chain (Peter Geoghegan) The code failed to traverse the HOT chain and might thus compute a too-old XID horizon, which could lead to incorrect conflict processing in hot standby. The practical impact of this bug is limited; in most cases the correct XID horizon would be found anyway from nearby operations.", "commit_aliases": ["32d6287d2", "422881744", "4f70e0910", "55e535226", "5f95664e1", "7a57960ba"], "source_commits": ["55e535226", "7a57960ba"], "source_entry_id": "13.2/changes/044", "db_id": "3ddc0e06c15948c1e58d48cd12543471", "patch_ids": ["7bd28cb094b4573480ebc380b2dbfc5c", "8c6bb452250079f2112ad31437892b4f"], "statement_hash": "25219df77b914c8f0de7cc8d3204f443b3a89d586689642804fd57d05cd81887", "relations": [{"rule": 2, "type": "equivalent", "target": "c06bf6218ea32e61d020df50fb1c4a22", "evidence": {"same_day": true, "patch_ids": ["7bd28cb094b4573480ebc380b2dbfc5c", "8c6bb452250079f2112ad31437892b4f"], "statement_hash": "25219df77b914c8f0de7cc8d3204f443b3a89d586689642804fd57d05cd81887"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c06bf6218ea32e61d020df50fb1c4a22", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Fix possible failure to detect recovery conflicts while deleting an index entry that references a HOT chain", "evidence": {"same_day": true, "patch_ids": ["7bd28cb094b4573480ebc380b2dbfc5c", "8c6bb452250079f2112ad31437892b4f"], "statement_hash": "25219df77b914c8f0de7cc8d3204f443b3a89d586689642804fd57d05cd81887"}, "url": "/docs/compare/?release=12.6#12.6-8c9c86782214cb3b", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}]}, {"id": "13.2-75ba04d19281205a", "cves": [], "html": "Ensure that a nonempty value of krb_server_keyfile always overrides any setting of KRB5_KTNAME in the server's environment (Tom Lane) §
Previously, which setting took precedence depended on whether the client requests GSS encryption.
", "text": "Ensure that a nonempty value of krb_server_keyfile always overrides any setting of KRB5_KTNAME in the server's environment (Tom Lane) § Previously, which setting took precedence depended on whether the client requests GSS encryption.", "title": "Ensure that a nonempty value of krb_server_keyfile always overrides any setting of KRB5_KTNAME in the server's environment", "commits": ["861e96717"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "5dac37fcdb2340ee68bbd79aa7423d7119fd16af7a54a79a53c8d925f049fd21", "section_path": ["Changes"], "commit_groups": [["3ca19490b", "860fe27ee", "861e96717"]], "identity_text": "Ensure that a nonempty value of krb_server_keyfile always overrides any setting of KRB5_KTNAME in the server's environment (Tom Lane) Previously, which setting took precedence depended on whether the client requests GSS encryption.", "commit_aliases": ["3ca19490b", "860fe27ee", "861e96717"], "source_commits": ["861e96717"], "source_entry_id": "13.2/changes/045", "db_id": "b078e35851c674f3ba264037d90fcc66", "patch_ids": ["2e6e1277de70fc4978f730deb00ca332"], "statement_hash": "fd0839729c00f311dda94f6c5e5db914f5ee2e4141932f8753dc142008e01677", "relations": [{"rule": 2, "type": "equivalent", "target": "43c997cb6a0e678ec67c0f22bcf6ef7a", "evidence": {"same_day": true, "patch_ids": ["2e6e1277de70fc4978f730deb00ca332"], "statement_hash": "fd0839729c00f311dda94f6c5e5db914f5ee2e4141932f8753dc142008e01677"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "43c997cb6a0e678ec67c0f22bcf6ef7a", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Ensure that a nonempty value of krb_server_keyfile always overrides any setting of KRB5_KTNAME in the server's environment", "evidence": {"same_day": true, "patch_ids": ["2e6e1277de70fc4978f730deb00ca332"], "statement_hash": "fd0839729c00f311dda94f6c5e5db914f5ee2e4141932f8753dc142008e01677"}, "url": "/docs/compare/?release=12.6#12.6-d45e52e4ccc71e5e", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}]}, {"id": "13.2-f7cfeeb61444b784", "cves": [], "html": "In server log messages about failing to match connections to pg_hba.conf entries, include details about whether GSS encryption has been activated (Kyotaro Horiguchi, Tom Lane) §
This is relevant data if hostgssenc or hostnogssenc entries exist.
Fix assorted issues in server's support for GSS encryption (Tom Lane) §
\nRemove pointless restriction that only GSS authentication can be used on a GSS-encrypted connection. Add GSS encryption information to connection-authorized log messages. Include GSS-related space when computing the required size of shared memory (this omission could have caused problems with very high max_connections settings). Avoid possible infinite recursion when reporting an unrecoverable GSS encryption error.
Ensure that unserviced requests for background workers are cleaned up when the postmaster begins a “smart” or “fast” shutdown sequence (Tom Lane) §
\nPreviously, there was a race condition whereby a child process that had requested a background worker just before shutdown could wait indefinitely, preventing shutdown from completing.
", "text": "Ensure that unserviced requests for background workers are cleaned up when the postmaster begins a “smart” or “fast” shutdown sequence (Tom Lane) § Previously, there was a race condition whereby a child process that had requested a background worker just before shutdown could wait indefinitely, preventing shutdown from completing.", "title": "Ensure that unserviced requests for background workers are cleaned up when the postmaster begins a “smart” or “fast” shutdown sequence", "commits": ["0217ad806"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "3e271249ca850cb151d5e55840221e0b71ef695be669eddebf9a47b9e9c2a031", "section_path": ["Changes"], "commit_groups": [["0217ad806", "1a6b1c460", "3d8068edc", "7519bd16d", "b99b6b9d6"]], "identity_text": "Ensure that unserviced requests for background workers are cleaned up when the postmaster begins a smart or fast shutdown sequence (Tom Lane) Previously, there was a race condition whereby a child process that had requested a background worker just before shutdown could wait indefinitely, preventing shutdown from completing.", "commit_aliases": ["0217ad806", "1a6b1c460", "3d8068edc", "7519bd16d", "b99b6b9d6"], "source_commits": ["0217ad806"], "source_entry_id": "13.2/changes/048", "db_id": "8c9a37452faeeb6cb872bb4bc15a779f", "patch_ids": ["0a0c94e82bf5109ff0fe7a667be6a037"], "statement_hash": "3369e1986ecc7b35720d8c0854c60a156a2360c1a9594feb8ccbe89645e56ec2", "relations": [{"rule": 2, "type": "equivalent", "target": "8e51a09dba1c293e69268edc1b291ec6", "evidence": {"same_day": true, "patch_ids": ["0a0c94e82bf5109ff0fe7a667be6a037"], "statement_hash": "3369e1986ecc7b35720d8c0854c60a156a2360c1a9594feb8ccbe89645e56ec2"}}, {"rule": 2, "type": "equivalent", "target": "e00cb104c6412debbe3ff69d6fb23c2e", "evidence": {"same_day": true, "patch_ids": ["0a0c94e82bf5109ff0fe7a667be6a037"], "statement_hash": "3369e1986ecc7b35720d8c0854c60a156a2360c1a9594feb8ccbe89645e56ec2"}}, {"rule": 2, "type": "equivalent", "target": "f7301bf401817d4c067599828d75269b", "evidence": {"same_day": true, "patch_ids": ["0a0c94e82bf5109ff0fe7a667be6a037"], "statement_hash": "3369e1986ecc7b35720d8c0854c60a156a2360c1a9594feb8ccbe89645e56ec2"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f7301bf401817d4c067599828d75269b", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Ensure that unserviced requests for background workers are cleaned up when the postmaster begins a “smart” or “fast” shutdown sequence", "evidence": {"same_day": true, "patch_ids": ["0a0c94e82bf5109ff0fe7a667be6a037"], "statement_hash": "3369e1986ecc7b35720d8c0854c60a156a2360c1a9594feb8ccbe89645e56ec2"}, "url": "/docs/compare/?release=12.6#12.6-7155a18dc0a76fe0", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "e00cb104c6412debbe3ff69d6fb23c2e", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Ensure that unserviced requests for background workers are cleaned up when the postmaster begins a “smart” or “fast” shutdown sequence", "evidence": {"same_day": true, "patch_ids": ["0a0c94e82bf5109ff0fe7a667be6a037"], "statement_hash": "3369e1986ecc7b35720d8c0854c60a156a2360c1a9594feb8ccbe89645e56ec2"}, "url": "/docs/compare/?release=11.11#11.11-ce38165ad6ec3017", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "8e51a09dba1c293e69268edc1b291ec6", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Ensure that unserviced requests for background workers are cleaned up when the postmaster begins a “smart” or “fast” shutdown sequence", "evidence": {"same_day": true, "patch_ids": ["0a0c94e82bf5109ff0fe7a667be6a037"], "statement_hash": "3369e1986ecc7b35720d8c0854c60a156a2360c1a9594feb8ccbe89645e56ec2"}, "url": "/docs/compare/?release=10.16#10.16-ce38165ad6ec3017", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}]}, {"id": "13.2-1f07cae731648722", "cves": [], "html": "Fix portability problem in parsing of recovery_target_xid values (Michael Paquier) §
The target XID is potentially 64 bits wide, but it was parsed with strtoul(), causing misbehavior on platforms where long is 32 bits (such as Windows).
Avoid trying to use parallel index build in a standalone backend (Yulin Pei) §
", "text": "Avoid trying to use parallel index build in a standalone backend (Yulin Pei) §", "title": "Avoid trying to use parallel index build in a standalone backend", "commits": ["fac31b2cd"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "c3e7ee6afb1097c56a040f65a2b552a35143fdff61d4a39dbbe0f2380814102e", "section_path": ["Changes"], "commit_groups": [["16a1e1ea4", "275b3411d", "942e441ee", "fac31b2cd"]], "identity_text": "Avoid trying to use parallel index build in a standalone backend (Yulin Pei)", "commit_aliases": ["16a1e1ea4", "275b3411d", "942e441ee", "fac31b2cd"], "source_commits": ["fac31b2cd"], "source_entry_id": "13.2/changes/050", "db_id": "a951db549182bd89530e83765d97bbf6", "patch_ids": ["05574121bc536bd938fe87664b6ceda5"], "statement_hash": "eaf2c9fbbf64721e0c626578bc21ae908ce73156969446d00011dff9edfbdf49", "relations": [{"rule": 2, "type": "equivalent", "target": "1d2ce9ee6d724b317edb45a3ec96facd", "evidence": {"same_day": true, "patch_ids": ["05574121bc536bd938fe87664b6ceda5"], "statement_hash": "eaf2c9fbbf64721e0c626578bc21ae908ce73156969446d00011dff9edfbdf49"}}, {"rule": 2, "type": "equivalent", "target": "6b7b79cc75b7cb569e4f1ecfcf29c61e", "evidence": {"same_day": true, "patch_ids": ["05574121bc536bd938fe87664b6ceda5"], "statement_hash": "eaf2c9fbbf64721e0c626578bc21ae908ce73156969446d00011dff9edfbdf49"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "1d2ce9ee6d724b317edb45a3ec96facd", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Avoid trying to use parallel index build in a standalone backend", "evidence": {"same_day": true, "patch_ids": ["05574121bc536bd938fe87664b6ceda5"], "statement_hash": "eaf2c9fbbf64721e0c626578bc21ae908ce73156969446d00011dff9edfbdf49"}, "url": "/docs/compare/?release=12.6#12.6-4b83360f6329b683", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "6b7b79cc75b7cb569e4f1ecfcf29c61e", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Avoid trying to use parallel index build in a standalone backend", "evidence": {"same_day": true, "patch_ids": ["05574121bc536bd938fe87664b6ceda5"], "statement_hash": "eaf2c9fbbf64721e0c626578bc21ae908ce73156969446d00011dff9edfbdf49"}, "url": "/docs/compare/?release=11.11#11.11-30b668015c8b3c7a", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}]}, {"id": "13.2-1699bdaaa71e93b7", "cves": [], "html": "Allow index AMs to support included columns without necessarily supporting multiple key columns (Tom Lane) §
", "text": "Allow index AMs to support included columns without necessarily supporting multiple key columns (Tom Lane) §", "title": "Allow index AMs to support included columns without necessarily supporting multiple key columns", "commits": ["7c89246d0"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "366c2f3741626b11d5f04c4d6ed436cd12762b944feb3cd96e499d1892da8090", "section_path": ["Changes"], "commit_groups": [["29d29d652", "4ac8ee9d4", "7c89246d0", "9cebe4952"]], "identity_text": "Allow index AMs to support included columns without necessarily supporting multiple key columns (Tom Lane)", "commit_aliases": ["29d29d652", "4ac8ee9d4", "7c89246d0", "9cebe4952"], "source_commits": ["7c89246d0"], "source_entry_id": "13.2/changes/051", "db_id": "70632f92aee85314e4daa321f650cebe", "patch_ids": ["6ea586c4ae569f484e91ad7328565cd0"], "statement_hash": "1684522d5a45ad3760d9988273f44755d255310796dc8cf81374493d3e09f34a", "relations": [{"rule": 2, "type": "equivalent", "target": "6497fd74f57289e3b676d64e5e337591", "evidence": {"same_day": true, "patch_ids": ["6ea586c4ae569f484e91ad7328565cd0"], "statement_hash": "1684522d5a45ad3760d9988273f44755d255310796dc8cf81374493d3e09f34a"}}, {"rule": 2, "type": "equivalent", "target": "70327adc9bf6a731dd3d5d2c4f6d8a77", "evidence": {"same_day": true, "patch_ids": ["6ea586c4ae569f484e91ad7328565cd0"], "statement_hash": "1684522d5a45ad3760d9988273f44755d255310796dc8cf81374493d3e09f34a"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "6497fd74f57289e3b676d64e5e337591", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Allow index AMs to support included columns without necessarily supporting multiple key columns", "evidence": {"same_day": true, "patch_ids": ["6ea586c4ae569f484e91ad7328565cd0"], "statement_hash": "1684522d5a45ad3760d9988273f44755d255310796dc8cf81374493d3e09f34a"}, "url": "/docs/compare/?release=12.6#12.6-35ae3004ecdab826", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "70327adc9bf6a731dd3d5d2c4f6d8a77", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Allow index AMs to support included columns without necessarily supporting multiple key columns", "evidence": {"same_day": true, "patch_ids": ["6ea586c4ae569f484e91ad7328565cd0"], "statement_hash": "1684522d5a45ad3760d9988273f44755d255310796dc8cf81374493d3e09f34a"}, "url": "/docs/compare/?release=11.11#11.11-d88468166a7fadea", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}]}, {"id": "13.2-9146d9c3e595a0b2", "cves": [], "html": "While taking a base backup, avoid executing any SHA256 code if a backup manifest is not needed (Michael Paquier) §
\nWhen using OpenSSL operating in FIPS mode, SHA256 hashing is rejected, leading to an error. This change makes it possible to take a base backup on such a platform, so long as --no-manifest is specified.
Avoid assertion failure during parallel aggregation of an aggregate with a non-strict deserialization function (Andrew Gierth) §
\nNo such aggregate functions exist in core PostgreSQL, but some extensions such as PostGIS provide some. The mistake is harmless anyway in a non-assert build.
", "text": "Avoid assertion failure during parallel aggregation of an aggregate with a non-strict deserialization function (Andrew Gierth) § No such aggregate functions exist in core PostgreSQL, but some extensions such as PostGIS provide some. The mistake is harmless anyway in a non-assert build.", "title": "Avoid assertion failure during parallel aggregation of an aggregate with a non-strict deserialization function", "commits": ["75e3cca42"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "0e630e80ab277f3de89dc126d301f4dbdb98d5d63101718403b5a22c0592a9f4", "section_path": ["Changes"], "commit_groups": [["30f912a41", "75e3cca42", "a3367aa3c", "f7f2a28d4"]], "identity_text": "Avoid assertion failure during parallel aggregation of an aggregate with a non-strict deserialization function (Andrew Gierth) No such aggregate functions exist in core PostgreSQL, but some extensions such as PostGIS provide some. The mistake is harmless anyway in a non-assert build.", "commit_aliases": ["30f912a41", "75e3cca42", "a3367aa3c", "f7f2a28d4"], "source_commits": ["75e3cca42"], "source_entry_id": "13.2/changes/053", "db_id": "96b208642314916b921d51936f636d69", "patch_ids": ["b1a0c0bea78c03ba36e74d6686e7d4c8"], "statement_hash": "21977849d07bfbd5cdc5b4bd24c88201a2bb6aa82cbb768d94a6438a6bf583a6", "relations": [{"rule": 2, "type": "equivalent", "target": "125382849c3d2911382780c3f0547e5d", "evidence": {"same_day": true, "patch_ids": ["b1a0c0bea78c03ba36e74d6686e7d4c8"], "statement_hash": "21977849d07bfbd5cdc5b4bd24c88201a2bb6aa82cbb768d94a6438a6bf583a6"}}, {"rule": 2, "type": "equivalent", "target": "3ef0e8de2218cedb9f8b210fa657a2fe", "evidence": {"same_day": true, "patch_ids": ["b1a0c0bea78c03ba36e74d6686e7d4c8"], "statement_hash": "21977849d07bfbd5cdc5b4bd24c88201a2bb6aa82cbb768d94a6438a6bf583a6"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "125382849c3d2911382780c3f0547e5d", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Avoid assertion failure during parallel aggregation of an aggregate with a non-strict deserialization function", "evidence": {"same_day": true, "patch_ids": ["b1a0c0bea78c03ba36e74d6686e7d4c8"], "statement_hash": "21977849d07bfbd5cdc5b4bd24c88201a2bb6aa82cbb768d94a6438a6bf583a6"}, "url": "/docs/compare/?release=12.6#12.6-22a29056914fcdeb", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "3ef0e8de2218cedb9f8b210fa657a2fe", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Avoid assertion failure during parallel aggregation of an aggregate with a non-strict deserialization function", "evidence": {"same_day": true, "patch_ids": ["b1a0c0bea78c03ba36e74d6686e7d4c8"], "statement_hash": "21977849d07bfbd5cdc5b4bd24c88201a2bb6aa82cbb768d94a6438a6bf583a6"}, "url": "/docs/compare/?release=11.11#11.11-1ef7892c8d62a8fb", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}]}, {"id": "13.2-410b354d77a1aa49", "cves": [], "html": "Avoid assertion failure in pg_get_functiondef() when examining a function with a TRANSFORM option (Tom Lane) §
Fix data structure misallocation in PL/pgSQL's CALL statement (Tom Lane) § §
A CALL in a PL/pgSQL procedure, to another procedure that has OUT parameters, would fail if the called procedure did a COMMIT or ROLLBACK.
In libpq, do not skip trying SSL after GSS encryption (Tom Lane) §
\nIf we successfully made a GSS-encrypted connection, but then failed during authentication, we would fall back to an unencrypted connection rather than next trying an SSL-encrypted connection. This could lead to unexpected connection failure, or to silently getting an unencrypted connection where an encrypted one is expected. Fortunately, GSS encryption could only succeed if both client and server hold valid tickets in the same Kerberos infrastructure. It seems unlikely for that to be true in an environment that requires SSL encryption instead.
", "text": "In libpq, do not skip trying SSL after GSS encryption (Tom Lane) § If we successfully made a GSS-encrypted connection, but then failed during authentication, we would fall back to an unencrypted connection rather than next trying an SSL-encrypted connection. This could lead to unexpected connection failure, or to silently getting an unencrypted connection where an encrypted one is expected. Fortunately, GSS encryption could only succeed if both client and server hold valid tickets in the same Kerberos infrastructure. It seems unlikely for that to be true in an environment that requires SSL encryption instead.", "title": "In libpq, do not skip trying SSL after GSS encryption", "commits": ["06b844c2b"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "660b25fe7c041c6ff8ede423fa6e4916df7ce4fefefe933a3a63e60b214db3d8", "section_path": ["Changes"], "commit_groups": [["06b844c2b", "b3a5bf719", "ff6ce9a3a"]], "identity_text": "In libpq, do not skip trying SSL after GSS encryption (Tom Lane) If we successfully made a GSS-encrypted connection, but then failed during authentication, we would fall back to an unencrypted connection rather than next trying an SSL-encrypted connection. This could lead to unexpected connection failure, or to silently getting an unencrypted connection where an encrypted one is expected. Fortunately, GSS encryption could only succeed if both client and server hold valid tickets in the same Kerberos infrastructure. It seems unlikely for that to be true in an environment that requires SSL encryption instead.", "commit_aliases": ["06b844c2b", "b3a5bf719", "ff6ce9a3a"], "source_commits": ["06b844c2b"], "source_entry_id": "13.2/changes/056", "db_id": "7a15d3203d2c0b86220ce6a5ec0eb02d", "patch_ids": ["d1f5caaa03470a486d8dd9da4f67b2db"], "statement_hash": "f8de94b60cb61842ef485530f3cc7d89c877464c814ff1a4956f43705c429035", "relations": [{"rule": 2, "type": "equivalent", "target": "b527e8ee4f6db9c5d43424392d5ee05d", "evidence": {"same_day": true, "patch_ids": ["d1f5caaa03470a486d8dd9da4f67b2db"], "statement_hash": "f8de94b60cb61842ef485530f3cc7d89c877464c814ff1a4956f43705c429035"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b527e8ee4f6db9c5d43424392d5ee05d", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "In libpq, do not skip trying SSL after GSS encryption", "evidence": {"same_day": true, "patch_ids": ["d1f5caaa03470a486d8dd9da4f67b2db"], "statement_hash": "f8de94b60cb61842ef485530f3cc7d89c877464c814ff1a4956f43705c429035"}, "url": "/docs/compare/?release=12.6#12.6-f93710a71812f832", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}]}, {"id": "13.2-eabaffeb76416d9b", "cves": [], "html": "Make libpq's PQconndefaults() function report the correct default value for channel_binding (Daniele Varrazzo) §
In psql, re-allow including a password in a connection_string argument of a \\connect command (Tom Lane) §
This used to work, but a recent bug fix caused the password to be ignored (resulting in prompting for a password).
", "text": "In psql, re-allow including a password in a connection_string argument of a \\connect command (Tom Lane) § This used to work, but a recent bug fix caused the password to be ignored (resulting in prompting for a password).", "title": "In psql, re-allow including a password in a connection_string argument of a \\connect command", "commits": ["72b930f50"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "a4c02709f30cdfdcc26df39953e8110e7a71e3af2627a2515a88df47e4b35ce1", "section_path": ["Changes"], "commit_groups": [["3958abdad", "3f59a05f0", "72b930f50", "777ac03a6", "7e5e1bba0", "946277fd4", "e2d5de150"]], "identity_text": "In psql, re-allow including a password in a connection_string argument of a \\connect command (Tom Lane) This used to work, but a recent bug fix caused the password to be ignored (resulting in prompting for a password).", "commit_aliases": ["3958abdad", "3f59a05f0", "72b930f50", "777ac03a6", "7e5e1bba0", "946277fd4", "e2d5de150"], "source_commits": ["72b930f50"], "source_entry_id": "13.2/changes/058", "db_id": "09b5a087c22bf206ee9d103d890fa85a", "patch_ids": ["e02be74e0a481c81f894cd7a231efb62"], "statement_hash": "9b914552672df8415de82ef578971eece6fe580bed6eaaba49ccb7321b567710", "relations": [{"rule": 2, "type": "equivalent", "target": "738cdf20526fdb30ff11c437290c0fcb", "evidence": {"same_day": true, "patch_ids": ["e02be74e0a481c81f894cd7a231efb62"], "statement_hash": "9b914552672df8415de82ef578971eece6fe580bed6eaaba49ccb7321b567710"}}, {"rule": 2, "type": "equivalent", "target": "8448f70b74221637125f8f640aaa199c", "evidence": {"same_day": true, "patch_ids": ["e02be74e0a481c81f894cd7a231efb62"], "statement_hash": "9b914552672df8415de82ef578971eece6fe580bed6eaaba49ccb7321b567710"}}, {"rule": 2, "type": "equivalent", "target": "8ff5c4e0e8e16923d3a32b4962370668", "evidence": {"same_day": true, "patch_ids": ["e02be74e0a481c81f894cd7a231efb62"], "statement_hash": "9b914552672df8415de82ef578971eece6fe580bed6eaaba49ccb7321b567710"}}, {"rule": 2, "type": "equivalent", "target": "9f809e3dbb722ce78c5acca3d5adea6d", "evidence": {"same_day": true, "patch_ids": ["e02be74e0a481c81f894cd7a231efb62"], "statement_hash": "9b914552672df8415de82ef578971eece6fe580bed6eaaba49ccb7321b567710"}}, {"rule": 2, "type": "equivalent", "target": "b212d7783359ee0af735b70cbfa125c2", "evidence": {"same_day": true, "patch_ids": ["e02be74e0a481c81f894cd7a231efb62"], "statement_hash": "9b914552672df8415de82ef578971eece6fe580bed6eaaba49ccb7321b567710"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "9f809e3dbb722ce78c5acca3d5adea6d", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "In psql, re-allow including a password in a connection_string argument of a \\connect command", "evidence": {"same_day": true, "patch_ids": ["e02be74e0a481c81f894cd7a231efb62"], "statement_hash": "9b914552672df8415de82ef578971eece6fe580bed6eaaba49ccb7321b567710"}, "url": "/docs/compare/?release=12.6#12.6-e53e029b4fb54864", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "8ff5c4e0e8e16923d3a32b4962370668", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "In psql, re-allow including a password in a connection_string argument of a \\connect command", "evidence": {"same_day": true, "patch_ids": ["e02be74e0a481c81f894cd7a231efb62"], "statement_hash": "9b914552672df8415de82ef578971eece6fe580bed6eaaba49ccb7321b567710"}, "url": "/docs/compare/?release=11.11#11.11-01b4f20b80a32a6e", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "b212d7783359ee0af735b70cbfa125c2", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "In psql, re-allow including a password in a connection_string argument of a \\connect command", "evidence": {"same_day": true, "patch_ids": ["e02be74e0a481c81f894cd7a231efb62"], "statement_hash": "9b914552672df8415de82ef578971eece6fe580bed6eaaba49ccb7321b567710"}, "url": "/docs/compare/?release=10.16#10.16-01b4f20b80a32a6e", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "738cdf20526fdb30ff11c437290c0fcb", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "In psql, re-allow including a password in a connection_string argument of a \\connect command", "evidence": {"same_day": true, "patch_ids": ["e02be74e0a481c81f894cd7a231efb62"], "statement_hash": "9b914552672df8415de82ef578971eece6fe580bed6eaaba49ccb7321b567710"}, "url": "/docs/compare/?release=9.6.21#9.6.21-01b4f20b80a32a6e", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "8448f70b74221637125f8f640aaa199c", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "In psql, re-allow including a password in a connection_string argument of a \\connect command", "evidence": {"same_day": true, "patch_ids": ["e02be74e0a481c81f894cd7a231efb62"], "statement_hash": "9b914552672df8415de82ef578971eece6fe580bed6eaaba49ccb7321b567710"}, "url": "/docs/compare/?release=9.5.25#9.5.25-01b4f20b80a32a6e", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-f731dbab7dbbc3b6", "cves": [], "html": "In psql's \\d commands, don't truncate the display of column default values (Tom Lane) §
Formerly, they were arbitrarily truncated at 128 characters.
", "text": "In psql's \\d commands, don't truncate the display of column default values (Tom Lane) § Formerly, they were arbitrarily truncated at 128 characters.", "title": "In psql's \\d commands, don't truncate the display of column default values", "commits": ["a0ef08172"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "f449b3a4df1e2d4d96ad23b50d6dd29de51ef63978c9feb8dc26979b56a5b249", "section_path": ["Changes"], "commit_groups": [["314fb9bae", "a0ef08172", "ea7a167da"]], "identity_text": "In psql's \\d commands, don't truncate the display of column default values (Tom Lane) Formerly, they were arbitrarily truncated at 128 characters.", "commit_aliases": ["314fb9bae", "a0ef08172", "ea7a167da"], "source_commits": ["a0ef08172"], "source_entry_id": "13.2/changes/059", "db_id": "a2949c4b2708707a411caacbc427b7aa", "patch_ids": ["d22ce2d2785686b5303d63b107ea7dda"], "statement_hash": "e0145b5c59e0d4a9734d4fbf7ceff56a58f6b7ff7990fce0f66e67227ebb0f23", "relations": [{"rule": 2, "type": "equivalent", "target": "0ed199f775b59d85a49932b22edb109f", "evidence": {"same_day": true, "patch_ids": ["d22ce2d2785686b5303d63b107ea7dda"], "statement_hash": "e0145b5c59e0d4a9734d4fbf7ceff56a58f6b7ff7990fce0f66e67227ebb0f23"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "0ed199f775b59d85a49932b22edb109f", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "In psql's \\d commands, don't truncate the display of column default values", "evidence": {"same_day": true, "patch_ids": ["d22ce2d2785686b5303d63b107ea7dda"], "statement_hash": "e0145b5c59e0d4a9734d4fbf7ceff56a58f6b7ff7990fce0f66e67227ebb0f23"}, "url": "/docs/compare/?release=12.6#12.6-dc3e8261676a7be0", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}]}, {"id": "13.2-e90a55ab80aa53e9", "cves": [], "html": "Fix assorted bugs in psql's \\help command (Kyotaro Horiguchi, Tom Lane) §
\\help with two argument words failed to find a command description using only the first word, for example \\help reset all should show the help for RESET but did not. Also, \\help often failed to invoke the pager when it should. It also leaked memory.
Fix pg_dump's dumping of inherited generated columns (Peter Eisentraut) §
\nThe previous behavior resulted in (harmless) errors during restore.
", "text": "Fix pg_dump's dumping of inherited generated columns (Peter Eisentraut) § The previous behavior resulted in (harmless) errors during restore.", "title": "Fix pg_dump's dumping of inherited generated columns", "commits": ["1d3ce0223"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "d1ea6bf21e5de5b39e3b230043032aab3457af6c82cef03cf5461420327393ff", "section_path": ["Changes"], "commit_groups": [["0bf83648a", "1d3ce0223", "1dd6baf78"]], "identity_text": "Fix pg_dump's dumping of inherited generated columns (Peter Eisentraut) The previous behavior resulted in (harmless) errors during restore.", "commit_aliases": ["0bf83648a", "1d3ce0223", "1dd6baf78"], "source_commits": ["1d3ce0223"], "source_entry_id": "13.2/changes/061", "db_id": "afafa525f8230317cb2288fc0398a51e", "patch_ids": ["6229221e256521e1c6313d994a411d5f"], "statement_hash": "b233cb2e8901fb464319799fd5df1c8757e4277031ebf481a9dc3b2e79fb2d1e", "relations": [{"rule": 2, "type": "equivalent", "target": "5898a137fde23c2d63bb61dd05f8e757", "evidence": {"same_day": true, "patch_ids": ["6229221e256521e1c6313d994a411d5f"], "statement_hash": "b233cb2e8901fb464319799fd5df1c8757e4277031ebf481a9dc3b2e79fb2d1e"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "5898a137fde23c2d63bb61dd05f8e757", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Fix pg_dump's dumping of inherited generated columns", "evidence": {"same_day": true, "patch_ids": ["6229221e256521e1c6313d994a411d5f"], "statement_hash": "b233cb2e8901fb464319799fd5df1c8757e4277031ebf481a9dc3b2e79fb2d1e"}, "url": "/docs/compare/?release=12.6#12.6-a25b3fb256a9f690", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}]}, {"id": "13.2-1c32b2d583bdf3ed", "cves": [], "html": "In pg_dump, ensure that the restore script runs ALTER PUBLICATION ADD TABLE commands as the owner of the publication, and similarly runs ALTER INDEX ATTACH PARTITION commands as the owner of the partitioned index (Tom Lane) § §
Previously, these commands would be run by the role that started the restore script; which will usually work, but in corner cases that role might not have adequate permissions.
", "text": "In pg_dump, ensure that the restore script runs ALTER PUBLICATION ADD TABLE commands as the owner of the publication, and similarly runs ALTER INDEX ATTACH PARTITION commands as the owner of the partitioned index (Tom Lane) § § Previously, these commands would be run by the role that started the restore script; which will usually work, but in corner cases that role might not have adequate permissions.", "title": "In pg_dump, ensure that the restore script runs ALTER PUBLICATION ADD TABLE commands as the owner of the publication, and similarly runs ALTER INDEX ATTACH PARTITION commands as the owner of the partitioned index", "commits": ["0011c5a0f", "79d3ac72f"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "9a7c355ec0ac1c7efa3a80689f322a174c6796e54ce3ce762e0e45606651b88c", "section_path": ["Changes"], "commit_groups": [["0011c5a0f", "436d9c5ca", "9eabfe300", "9f15188a1"], ["0d221ecec", "1c9791f66", "79d3ac72f", "8e396a773", "bb12a7f42"]], "identity_text": "In pg_dump, ensure that the restore script runs ALTER PUBLICATION ADD TABLE commands as the owner of the publication, and similarly runs ALTER INDEX ATTACH PARTITION commands as the owner of the partitioned index (Tom Lane) Previously, these commands would be run by the role that started the restore script; which will usually work, but in corner cases that role might not have adequate permissions.", "commit_aliases": ["0011c5a0f", "0d221ecec", "1c9791f66", "436d9c5ca", "79d3ac72f", "8e396a773", "9eabfe300", "9f15188a1", "bb12a7f42"], "source_commits": ["0011c5a0f", "79d3ac72f"], "source_entry_id": "13.2/changes/062", "db_id": "411cf34ffe0b5c859fb1aa35799ba1b2", "patch_ids": ["6d3960bd3efe2a1c01997e185dc4a71e", "ae03b7611893b5cfa1857d4dada6214b"], "statement_hash": "11bc0387060dfa41d0ab9308884dc928127fb716ea542dca895ef056e30e6205", "relations": [{"rule": 2, "type": "equivalent", "target": "630aa05009f29fcdc8416de2bba0a237", "evidence": {"same_day": true, "patch_ids": ["6d3960bd3efe2a1c01997e185dc4a71e", "ae03b7611893b5cfa1857d4dada6214b"], "statement_hash": "11bc0387060dfa41d0ab9308884dc928127fb716ea542dca895ef056e30e6205"}}, {"rule": 2, "type": "equivalent", "target": "c4add25dcf0809a4fcfd6e695752af93", "evidence": {"same_day": true, "patch_ids": ["6d3960bd3efe2a1c01997e185dc4a71e", "ae03b7611893b5cfa1857d4dada6214b"], "statement_hash": "11bc0387060dfa41d0ab9308884dc928127fb716ea542dca895ef056e30e6205"}}, {"rule": 2, "type": "equivalent", "target": "e0734417d84c67dcb45c79df7a2c9e4e", "evidence": {"same_day": true, "patch_ids": ["6d3960bd3efe2a1c01997e185dc4a71e", "ae03b7611893b5cfa1857d4dada6214b"]}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "630aa05009f29fcdc8416de2bba0a237", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "In pg_dump, ensure that the restore script runs ALTER PUBLICATION ADD TABLE commands as the owner of the publication, and similarly runs ALTER INDEX ATTACH PARTITION commands as the owner of the partitioned index", "evidence": {"same_day": true, "patch_ids": ["6d3960bd3efe2a1c01997e185dc4a71e", "ae03b7611893b5cfa1857d4dada6214b"], "statement_hash": "11bc0387060dfa41d0ab9308884dc928127fb716ea542dca895ef056e30e6205"}, "url": "/docs/compare/?release=12.6#12.6-e1fe1e0b0850d55d", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "c4add25dcf0809a4fcfd6e695752af93", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "In pg_dump, ensure that the restore script runs ALTER PUBLICATION ADD TABLE commands as the owner of the publication, and similarly runs ALTER INDEX ATTACH PARTITION commands as the owner of the partitioned index", "evidence": {"same_day": true, "patch_ids": ["6d3960bd3efe2a1c01997e185dc4a71e", "ae03b7611893b5cfa1857d4dada6214b"], "statement_hash": "11bc0387060dfa41d0ab9308884dc928127fb716ea542dca895ef056e30e6205"}, "url": "/docs/compare/?release=11.11#11.11-24b84ccc528a1243", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "e0734417d84c67dcb45c79df7a2c9e4e", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "In pg_dump, ensure that the restore script runs ALTER PUBLICATION ADD TABLE commands as the owner of the publication", "evidence": {"same_day": true, "patch_ids": ["6d3960bd3efe2a1c01997e185dc4a71e", "ae03b7611893b5cfa1857d4dada6214b"]}, "url": "/docs/compare/?release=10.16#10.16-696ac9d3187d3f85", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}]}, {"id": "13.2-1240d5e72e26aac2", "cves": [], "html": "Fix pg_dump to handle WITH GRANT OPTION in an extension's initial privileges (Noah Misch) §
If an extension's script creates an object and grants privileges on it with grant option, then later the user revokes such privileges, pg_dump would generate incorrect SQL for reproducing the situation. (Few if any extensions do this today.)
", "text": "Fix pg_dump to handle WITH GRANT OPTION in an extension's initial privileges (Noah Misch) § If an extension's script creates an object and grants privileges on it with grant option, then later the user revokes such privileges, pg_dump would generate incorrect SQL for reproducing the situation. (Few if any extensions do this today.)", "title": "Fix pg_dump to handle WITH GRANT OPTION in an extension's initial privileges", "commits": ["b8daf894f"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "22778159db4d7a4d11f49627d62d9a96a625060d1708519567f876d7a98aab82", "section_path": ["Changes"], "commit_groups": [["a0d31b1c9", "ad2b7c9bb", "b8daf894f", "b933c9c0b", "c6ff165f9", "f713ff7c6"]], "identity_text": "Fix pg_dump to handle WITH GRANT OPTION in an extension's initial privileges (Noah Misch) If an extension's script creates an object and grants privileges on it with grant option, then later the user revokes such privileges, pg_dump would generate incorrect SQL for reproducing the situation. (Few if any extensions do this today.)", "commit_aliases": ["a0d31b1c9", "ad2b7c9bb", "b8daf894f", "b933c9c0b", "c6ff165f9", "f713ff7c6"], "source_commits": ["b8daf894f"], "source_entry_id": "13.2/changes/063", "db_id": "8710c3eb334af6ae8b3da8f520d55574", "patch_ids": ["c9d3d979639038a8af13c6df31c5bac2"], "statement_hash": "462efa2d4dab4d135ad2ff732cd342d16a63a6bf1166438f0816cab8e58bc7bd", "relations": [{"rule": 2, "type": "equivalent", "target": "4d4a47f55a2ffaa490b2e6a852497a47", "evidence": {"same_day": true, "patch_ids": ["c9d3d979639038a8af13c6df31c5bac2"], "statement_hash": "462efa2d4dab4d135ad2ff732cd342d16a63a6bf1166438f0816cab8e58bc7bd"}}, {"rule": 2, "type": "equivalent", "target": "862b7ba39a0506a65cfb52cf115db81a", "evidence": {"same_day": true, "patch_ids": ["c9d3d979639038a8af13c6df31c5bac2"], "statement_hash": "462efa2d4dab4d135ad2ff732cd342d16a63a6bf1166438f0816cab8e58bc7bd"}}, {"rule": 2, "type": "equivalent", "target": "b747a2140ea168d1045ba4bd99b99172", "evidence": {"same_day": true, "patch_ids": ["c9d3d979639038a8af13c6df31c5bac2"], "statement_hash": "462efa2d4dab4d135ad2ff732cd342d16a63a6bf1166438f0816cab8e58bc7bd"}}, {"rule": 2, "type": "equivalent", "target": "ee665e4e21b683575a88c52e8e062124", "evidence": {"same_day": true, "patch_ids": ["c9d3d979639038a8af13c6df31c5bac2"], "statement_hash": "462efa2d4dab4d135ad2ff732cd342d16a63a6bf1166438f0816cab8e58bc7bd"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "862b7ba39a0506a65cfb52cf115db81a", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Fix pg_dump to handle WITH GRANT OPTION in an extension's initial privileges", "evidence": {"same_day": true, "patch_ids": ["c9d3d979639038a8af13c6df31c5bac2"], "statement_hash": "462efa2d4dab4d135ad2ff732cd342d16a63a6bf1166438f0816cab8e58bc7bd"}, "url": "/docs/compare/?release=12.6#12.6-8849dc8edb638778", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "ee665e4e21b683575a88c52e8e062124", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Fix pg_dump to handle WITH GRANT OPTION in an extension's initial privileges", "evidence": {"same_day": true, "patch_ids": ["c9d3d979639038a8af13c6df31c5bac2"], "statement_hash": "462efa2d4dab4d135ad2ff732cd342d16a63a6bf1166438f0816cab8e58bc7bd"}, "url": "/docs/compare/?release=11.11#11.11-c07098eca0ac9f8b", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "b747a2140ea168d1045ba4bd99b99172", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Fix pg_dump to handle WITH GRANT OPTION in an extension's initial privileges", "evidence": {"same_day": true, "patch_ids": ["c9d3d979639038a8af13c6df31c5bac2"], "statement_hash": "462efa2d4dab4d135ad2ff732cd342d16a63a6bf1166438f0816cab8e58bc7bd"}, "url": "/docs/compare/?release=10.16#10.16-c07098eca0ac9f8b", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "4d4a47f55a2ffaa490b2e6a852497a47", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "Fix pg_dump to handle WITH GRANT OPTION in an extension's initial privileges", "evidence": {"same_day": true, "patch_ids": ["c9d3d979639038a8af13c6df31c5bac2"], "statement_hash": "462efa2d4dab4d135ad2ff732cd342d16a63a6bf1166438f0816cab8e58bc7bd"}, "url": "/docs/compare/?release=9.6.21#9.6.21-c07098eca0ac9f8b", "source_url": "/docs/release/9.6.21/#AEN132403"}]}, {"id": "13.2-68d6cfb174a9d797", "cves": [], "html": "In pg_rewind, ensure that all WAL is accounted for when rewinding a standby server (Ian Barwick, Heikki Linnakangas) § § §
", "text": "In pg_rewind, ensure that all WAL is accounted for when rewinding a standby server (Ian Barwick, Heikki Linnakangas) § § §", "title": "In pg_rewind, ensure that all WAL is accounted for when rewinding a standby server", "commits": ["abd0abfb7", "e41a2efbc", "e6dc04d43"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "0e3802380e16518c3ef7bab1f208db5e6ae005ba72290dcb7d136797f6cbe919", "section_path": ["Changes"], "commit_groups": [["020f153db", "0740857de", "2b4f31303", "63e316f0b", "81e3c868f", "8b5c353ec", "abd0abfb7"], ["10d9c9d03", "3ea8e660c", "6ba581cf1", "98f8cdd48", "beb6b45ab", "d137b14c3", "e6dc04d43"], ["1dd608bba", "36a4ac20f", "45d363145", "a075c84f2", "ad3fb04b9", "cda50f211", "e41a2efbc"]], "identity_text": "In pg_rewind, ensure that all WAL is accounted for when rewinding a standby server (Ian Barwick, Heikki Linnakangas)", "commit_aliases": ["020f153db", "0740857de", "10d9c9d03", "1dd608bba", "2b4f31303", "36a4ac20f", "3ea8e660c", "45d363145", "63e316f0b", "6ba581cf1", "81e3c868f", "8b5c353ec", "98f8cdd48", "a075c84f2", "abd0abfb7", "ad3fb04b9", "beb6b45ab", "cda50f211", "d137b14c3", "e41a2efbc", "e6dc04d43"], "source_commits": ["abd0abfb7", "e41a2efbc", "e6dc04d43"], "source_entry_id": "13.2/changes/064", "db_id": "999c85b5ef55bec51f9a0f8624f198fb", "patch_ids": ["5f4932b73328390ee5662160cbe90a71", "71c91d3a82ceaa59e7cac093de229314", "f375855d90ee10018cb753e0fcb48b10"], "statement_hash": "014ba33559110a324b22c635ae5f052eb12e2d55677225ec9841e4bfdda2818e", "relations": [{"rule": 2, "type": "equivalent", "target": "0d52501b668c02c4ed399b56199c008f", "evidence": {"same_day": true, "patch_ids": ["5f4932b73328390ee5662160cbe90a71", "71c91d3a82ceaa59e7cac093de229314", "f375855d90ee10018cb753e0fcb48b10"], "statement_hash": "014ba33559110a324b22c635ae5f052eb12e2d55677225ec9841e4bfdda2818e"}}, {"rule": 2, "type": "equivalent", "target": "1d47de8a57452fe3c338210ffbd91e81", "evidence": {"same_day": true, "patch_ids": ["5f4932b73328390ee5662160cbe90a71", "71c91d3a82ceaa59e7cac093de229314", "f375855d90ee10018cb753e0fcb48b10"], "statement_hash": "014ba33559110a324b22c635ae5f052eb12e2d55677225ec9841e4bfdda2818e"}}, {"rule": 2, "type": "equivalent", "target": "5f906c0ba42fcccf9df10cc1fabcab65", "evidence": {"same_day": true, "patch_ids": ["5f4932b73328390ee5662160cbe90a71", "71c91d3a82ceaa59e7cac093de229314", "f375855d90ee10018cb753e0fcb48b10"], "statement_hash": "014ba33559110a324b22c635ae5f052eb12e2d55677225ec9841e4bfdda2818e"}}, {"rule": 2, "type": "equivalent", "target": "7c02c8d27f0f2fc55ec230579dfd0f9b", "evidence": {"same_day": true, "patch_ids": ["5f4932b73328390ee5662160cbe90a71", "71c91d3a82ceaa59e7cac093de229314", "f375855d90ee10018cb753e0fcb48b10"], "statement_hash": "014ba33559110a324b22c635ae5f052eb12e2d55677225ec9841e4bfdda2818e"}}, {"rule": 2, "type": "equivalent", "target": "f8986f1636c4d1816f59d95d9a0747b3", "evidence": {"same_day": true, "patch_ids": ["5f4932b73328390ee5662160cbe90a71", "71c91d3a82ceaa59e7cac093de229314", "f375855d90ee10018cb753e0fcb48b10"], "statement_hash": "014ba33559110a324b22c635ae5f052eb12e2d55677225ec9841e4bfdda2818e"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "0d52501b668c02c4ed399b56199c008f", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "In pg_rewind, ensure that all WAL is accounted for when rewinding a standby server", "evidence": {"same_day": true, "patch_ids": ["5f4932b73328390ee5662160cbe90a71", "71c91d3a82ceaa59e7cac093de229314", "f375855d90ee10018cb753e0fcb48b10"], "statement_hash": "014ba33559110a324b22c635ae5f052eb12e2d55677225ec9841e4bfdda2818e"}, "url": "/docs/compare/?release=12.6#12.6-55211c0a896ce5d0", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "f8986f1636c4d1816f59d95d9a0747b3", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "In pg_rewind, ensure that all WAL is accounted for when rewinding a standby server", "evidence": {"same_day": true, "patch_ids": ["5f4932b73328390ee5662160cbe90a71", "71c91d3a82ceaa59e7cac093de229314", "f375855d90ee10018cb753e0fcb48b10"], "statement_hash": "014ba33559110a324b22c635ae5f052eb12e2d55677225ec9841e4bfdda2818e"}, "url": "/docs/compare/?release=11.11#11.11-154e3c78e6dfec4c", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "7c02c8d27f0f2fc55ec230579dfd0f9b", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "In pg_rewind, ensure that all WAL is accounted for when rewinding a standby server", "evidence": {"same_day": true, "patch_ids": ["5f4932b73328390ee5662160cbe90a71", "71c91d3a82ceaa59e7cac093de229314", "f375855d90ee10018cb753e0fcb48b10"], "statement_hash": "014ba33559110a324b22c635ae5f052eb12e2d55677225ec9841e4bfdda2818e"}, "url": "/docs/compare/?release=10.16#10.16-154e3c78e6dfec4c", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "5f906c0ba42fcccf9df10cc1fabcab65", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "In pg_rewind, ensure that all WAL is accounted for when rewinding a standby server", "evidence": {"same_day": true, "patch_ids": ["5f4932b73328390ee5662160cbe90a71", "71c91d3a82ceaa59e7cac093de229314", "f375855d90ee10018cb753e0fcb48b10"], "statement_hash": "014ba33559110a324b22c635ae5f052eb12e2d55677225ec9841e4bfdda2818e"}, "url": "/docs/compare/?release=9.6.21#9.6.21-154e3c78e6dfec4c", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "1d47de8a57452fe3c338210ffbd91e81", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "In pg_rewind, ensure that all WAL is accounted for when rewinding a standby server", "evidence": {"same_day": true, "patch_ids": ["5f4932b73328390ee5662160cbe90a71", "71c91d3a82ceaa59e7cac093de229314", "f375855d90ee10018cb753e0fcb48b10"], "statement_hash": "014ba33559110a324b22c635ae5f052eb12e2d55677225ec9841e4bfdda2818e"}, "url": "/docs/compare/?release=9.5.25#9.5.25-154e3c78e6dfec4c", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-41b55e9660635d32", "cves": [], "html": "In pgbench, disallow a digit as the first character of a variable name (Fabien Coelho) §
\nThis prevents trying to substitute variables into timestamp literal values, which may contain strings like 12:34.
Report the correct database name in connection failure error messages from some client programs (Álvaro Herrera) §
\nIf the database name was defaulted rather than given on the command line, pg_dumpall, pgbench, oid2name, and vacuumlo would produce misleading error messages after a connection failure.
", "text": "Report the correct database name in connection failure error messages from some client programs (Álvaro Herrera) § If the database name was defaulted rather than given on the command line, pg_dumpall, pgbench, oid2name, and vacuumlo would produce misleading error messages after a connection failure.", "title": "Report the correct database name in connection failure error messages from some client programs", "commits": ["f17e8f33f"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "461d875ef63f215c54de5b5838e3c57da89490d0ea3c9cfc3ab589dbe1faf935", "section_path": ["Changes"], "commit_groups": [["11a708f81", "bcae842b9", "f17e8f33f", "f2dc96236", "fdd405c63", "fdf9d0054"]], "identity_text": "Report the correct database name in connection failure error messages from some client programs (Álvaro Herrera) If the database name was defaulted rather than given on the command line, pg_dumpall, pgbench, oid2name, and vacuumlo would produce misleading error messages after a connection failure.", "commit_aliases": ["11a708f81", "bcae842b9", "f17e8f33f", "f2dc96236", "fdd405c63", "fdf9d0054"], "source_commits": ["f17e8f33f"], "source_entry_id": "13.2/changes/066", "db_id": "c8826738a862b233b1c200ad0693533a", "patch_ids": ["2b87d6ffadc4f296858b94a2654cd70e"], "statement_hash": "b18e3c734bcc5032229b5acf57479a5e24ef13f1a8bed16d7fb261dbb6b947fa", "relations": [{"rule": 2, "type": "equivalent", "target": "2d89274d1836cabf0316bd99c10a7622", "evidence": {"same_day": true, "patch_ids": ["2b87d6ffadc4f296858b94a2654cd70e"], "statement_hash": "b18e3c734bcc5032229b5acf57479a5e24ef13f1a8bed16d7fb261dbb6b947fa"}}, {"rule": 2, "type": "equivalent", "target": "7ad568b9bae3112bc90120296eeaa02b", "evidence": {"same_day": true, "patch_ids": ["2b87d6ffadc4f296858b94a2654cd70e"], "statement_hash": "b18e3c734bcc5032229b5acf57479a5e24ef13f1a8bed16d7fb261dbb6b947fa"}}, {"rule": 2, "type": "equivalent", "target": "99907bc48e9c7e79be3ee046790b0db0", "evidence": {"same_day": true, "patch_ids": ["2b87d6ffadc4f296858b94a2654cd70e"], "statement_hash": "b18e3c734bcc5032229b5acf57479a5e24ef13f1a8bed16d7fb261dbb6b947fa"}}, {"rule": 2, "type": "equivalent", "target": "ae8df56bc2e6d9cfacb34fa93a1164e9", "evidence": {"same_day": true, "patch_ids": ["2b87d6ffadc4f296858b94a2654cd70e"], "statement_hash": "b18e3c734bcc5032229b5acf57479a5e24ef13f1a8bed16d7fb261dbb6b947fa"}}, {"rule": 2, "type": "equivalent", "target": "cc31da39bb4e66c231813b95922060ea", "evidence": {"same_day": true, "patch_ids": ["2b87d6ffadc4f296858b94a2654cd70e"], "statement_hash": "b18e3c734bcc5032229b5acf57479a5e24ef13f1a8bed16d7fb261dbb6b947fa"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "cc31da39bb4e66c231813b95922060ea", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Report the correct database name in connection failure error messages from some client programs", "evidence": {"same_day": true, "patch_ids": ["2b87d6ffadc4f296858b94a2654cd70e"], "statement_hash": "b18e3c734bcc5032229b5acf57479a5e24ef13f1a8bed16d7fb261dbb6b947fa"}, "url": "/docs/compare/?release=12.6#12.6-8c81f45f60567695", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "2d89274d1836cabf0316bd99c10a7622", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Report the correct database name in connection failure error messages from some client programs", "evidence": {"same_day": true, "patch_ids": ["2b87d6ffadc4f296858b94a2654cd70e"], "statement_hash": "b18e3c734bcc5032229b5acf57479a5e24ef13f1a8bed16d7fb261dbb6b947fa"}, "url": "/docs/compare/?release=11.11#11.11-3eb53acd200c441d", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "99907bc48e9c7e79be3ee046790b0db0", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Report the correct database name in connection failure error messages from some client programs", "evidence": {"same_day": true, "patch_ids": ["2b87d6ffadc4f296858b94a2654cd70e"], "statement_hash": "b18e3c734bcc5032229b5acf57479a5e24ef13f1a8bed16d7fb261dbb6b947fa"}, "url": "/docs/compare/?release=10.16#10.16-3eb53acd200c441d", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "7ad568b9bae3112bc90120296eeaa02b", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "Report the correct database name in connection failure error messages from some client programs", "evidence": {"same_day": true, "patch_ids": ["2b87d6ffadc4f296858b94a2654cd70e"], "statement_hash": "b18e3c734bcc5032229b5acf57479a5e24ef13f1a8bed16d7fb261dbb6b947fa"}, "url": "/docs/compare/?release=9.6.21#9.6.21-3eb53acd200c441d", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "ae8df56bc2e6d9cfacb34fa93a1164e9", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "Report the correct database name in connection failure error messages from some client programs", "evidence": {"same_day": true, "patch_ids": ["2b87d6ffadc4f296858b94a2654cd70e"], "statement_hash": "b18e3c734bcc5032229b5acf57479a5e24ef13f1a8bed16d7fb261dbb6b947fa"}, "url": "/docs/compare/?release=9.5.25#9.5.25-3eb53acd200c441d", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-cbe385d241588429", "cves": [], "html": "Fix memory leak in contrib/auto_explain (Japin Li) §
Memory consumed while producing the EXPLAIN output was not freed until the end of the current transaction (for a top-level statement) or the end of the surrounding statement (for a nested statement). This was particularly a problem with log_nested_statements enabled.
In contrib/postgres_fdw, avoid leaking open connections to remote servers when a user mapping or foreign server object is dropped (Bharath Rupireddy) §
Open connections that depend on a dropped user mapping or foreign server can no longer be referenced, but formerly they were kept around anyway for the duration of the local session.
", "text": "In contrib/postgres_fdw, avoid leaking open connections to remote servers when a user mapping or foreign server object is dropped (Bharath Rupireddy) § Open connections that depend on a dropped user mapping or foreign server can no longer be referenced, but formerly they were kept around anyway for the duration of the local session.", "title": "In contrib/postgres_fdw, avoid leaking open connections to remote servers when a user mapping or foreign server object is dropped", "commits": ["546f14374"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "f44642096f1b84bb3f30f9f45e212c5cd17c76daa9750c6010da3b1c528139f9", "section_path": ["Changes"], "commit_groups": [["03b7a1ee7", "294cdd7d0", "546f14374", "744357d84", "b5c73eef8", "e3ebcca84", "e792ca4ac"]], "identity_text": "In contrib/postgres_fdw, avoid leaking open connections to remote servers when a user mapping or foreign server object is dropped (Bharath Rupireddy) Open connections that depend on a dropped user mapping or foreign server can no longer be referenced, but formerly they were kept around anyway for the duration of the local session.", "commit_aliases": ["03b7a1ee7", "294cdd7d0", "546f14374", "744357d84", "b5c73eef8", "e3ebcca84", "e792ca4ac"], "source_commits": ["546f14374"], "source_entry_id": "13.2/changes/068", "db_id": "412ddff9cf704bd6c0c68cf92fbc60a4", "patch_ids": ["3c76f22ef8913b94c4e6ead338845f49"], "statement_hash": "461409a705919445b3634fdc54051f13092bd1ba78d22aebeb8aa91ad8ac3cff", "relations": [{"rule": 2, "type": "equivalent", "target": "07b3d52fcd6588730c7b19a3496d631f", "evidence": {"same_day": true, "patch_ids": ["3c76f22ef8913b94c4e6ead338845f49"], "statement_hash": "461409a705919445b3634fdc54051f13092bd1ba78d22aebeb8aa91ad8ac3cff"}}, {"rule": 2, "type": "equivalent", "target": "83172563daa129fb8c64ae34ed53bf2f", "evidence": {"same_day": true, "patch_ids": ["3c76f22ef8913b94c4e6ead338845f49"], "statement_hash": "461409a705919445b3634fdc54051f13092bd1ba78d22aebeb8aa91ad8ac3cff"}}, {"rule": 2, "type": "equivalent", "target": "a2d068e904b5c1a58640118c8012a8c1", "evidence": {"same_day": true, "patch_ids": ["3c76f22ef8913b94c4e6ead338845f49"], "statement_hash": "461409a705919445b3634fdc54051f13092bd1ba78d22aebeb8aa91ad8ac3cff"}}, {"rule": 2, "type": "equivalent", "target": "d50c2a7314e2f31bc3bfd21c1d90889d", "evidence": {"same_day": true, "patch_ids": ["3c76f22ef8913b94c4e6ead338845f49"], "statement_hash": "461409a705919445b3634fdc54051f13092bd1ba78d22aebeb8aa91ad8ac3cff"}}, {"rule": 2, "type": "equivalent", "target": "f399b562c0bb929bd1ccbaae305e8cce", "evidence": {"same_day": true, "patch_ids": ["3c76f22ef8913b94c4e6ead338845f49"], "statement_hash": "461409a705919445b3634fdc54051f13092bd1ba78d22aebeb8aa91ad8ac3cff"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "07b3d52fcd6588730c7b19a3496d631f", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "In contrib/postgres_fdw, avoid leaking open connections to remote servers when a user mapping or foreign server object is dropped", "evidence": {"same_day": true, "patch_ids": ["3c76f22ef8913b94c4e6ead338845f49"], "statement_hash": "461409a705919445b3634fdc54051f13092bd1ba78d22aebeb8aa91ad8ac3cff"}, "url": "/docs/compare/?release=12.6#12.6-3e8b8f5cb238e924", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "83172563daa129fb8c64ae34ed53bf2f", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "In contrib/postgres_fdw, avoid leaking open connections to remote servers when a user mapping or foreign server object is dropped", "evidence": {"same_day": true, "patch_ids": ["3c76f22ef8913b94c4e6ead338845f49"], "statement_hash": "461409a705919445b3634fdc54051f13092bd1ba78d22aebeb8aa91ad8ac3cff"}, "url": "/docs/compare/?release=11.11#11.11-609238d82f69fe5a", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "a2d068e904b5c1a58640118c8012a8c1", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "In contrib/postgres_fdw, avoid leaking open connections to remote servers when a user mapping or foreign server object is dropped", "evidence": {"same_day": true, "patch_ids": ["3c76f22ef8913b94c4e6ead338845f49"], "statement_hash": "461409a705919445b3634fdc54051f13092bd1ba78d22aebeb8aa91ad8ac3cff"}, "url": "/docs/compare/?release=10.16#10.16-609238d82f69fe5a", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "f399b562c0bb929bd1ccbaae305e8cce", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "In contrib/postgres_fdw, avoid leaking open connections to remote servers when a user mapping or foreign server object is dropped", "evidence": {"same_day": true, "patch_ids": ["3c76f22ef8913b94c4e6ead338845f49"], "statement_hash": "461409a705919445b3634fdc54051f13092bd1ba78d22aebeb8aa91ad8ac3cff"}, "url": "/docs/compare/?release=9.6.21#9.6.21-609238d82f69fe5a", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "d50c2a7314e2f31bc3bfd21c1d90889d", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "In contrib/postgres_fdw, avoid leaking open connections to remote servers when a user mapping or foreign server object is dropped", "evidence": {"same_day": true, "patch_ids": ["3c76f22ef8913b94c4e6ead338845f49"], "statement_hash": "461409a705919445b3634fdc54051f13092bd1ba78d22aebeb8aa91ad8ac3cff"}, "url": "/docs/compare/?release=9.5.25#9.5.25-609238d82f69fe5a", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-51a9e7a501a335a7", "cves": [], "html": "Fix faulty assertion in contrib/postgres_fdw (Etsuro Fujita) §
In contrib/pgcrypto, check for error returns from OpenSSL's EVP functions (Michael Paquier) §
We do not really expect errors here, but this change silences warnings from static analysis tools.
", "text": "In contrib/pgcrypto, check for error returns from OpenSSL's EVP functions (Michael Paquier) § We do not really expect errors here, but this change silences warnings from static analysis tools.", "title": "In contrib/pgcrypto, check for error returns from OpenSSL's EVP functions", "commits": ["dfd8bf2b9"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "e90cf8d48af2e0a762c3093ffe1fd1599969b805355356942782adc50e31a407", "section_path": ["Changes"], "commit_groups": [["28d1601ad", "5ba1df0f1", "95992e5ed", "b88afd8b6", "d7ecba937", "dfd8bf2b9", "f95d9fd81"]], "identity_text": "In contrib/pgcrypto, check for error returns from OpenSSL's EVP functions (Michael Paquier) We do not really expect errors here, but this change silences warnings from static analysis tools.", "commit_aliases": ["28d1601ad", "5ba1df0f1", "95992e5ed", "b88afd8b6", "d7ecba937", "dfd8bf2b9", "f95d9fd81"], "source_commits": ["dfd8bf2b9"], "source_entry_id": "13.2/changes/070", "db_id": "e812da2a129f90601c5b5a5f8bac146e", "patch_ids": ["816638745287462ad4cd0683af7bef88"], "statement_hash": "b49651f0b46e73a62dc0192cd979d9ad3784314b3e238a18f1a422b06027e0a3", "relations": [{"rule": 2, "type": "equivalent", "target": "611e79b45feb395f9f5b49589f5f36b0", "evidence": {"same_day": true, "patch_ids": ["816638745287462ad4cd0683af7bef88"], "statement_hash": "b49651f0b46e73a62dc0192cd979d9ad3784314b3e238a18f1a422b06027e0a3"}}, {"rule": 2, "type": "equivalent", "target": "a76720e667d44c9e133e8d3af6b1285e", "evidence": {"same_day": true, "patch_ids": ["816638745287462ad4cd0683af7bef88"], "statement_hash": "b49651f0b46e73a62dc0192cd979d9ad3784314b3e238a18f1a422b06027e0a3"}}, {"rule": 2, "type": "equivalent", "target": "cbb7bc3f0b65264df75ce5df285704b4", "evidence": {"same_day": true, "patch_ids": ["816638745287462ad4cd0683af7bef88"], "statement_hash": "b49651f0b46e73a62dc0192cd979d9ad3784314b3e238a18f1a422b06027e0a3"}}, {"rule": 2, "type": "equivalent", "target": "cbe074842e9ede704031080b60dea276", "evidence": {"same_day": true, "patch_ids": ["816638745287462ad4cd0683af7bef88"], "statement_hash": "b49651f0b46e73a62dc0192cd979d9ad3784314b3e238a18f1a422b06027e0a3"}}, {"rule": 2, "type": "equivalent", "target": "ea3d57be655e7c2c6425c025119b4135", "evidence": {"same_day": true, "patch_ids": ["816638745287462ad4cd0683af7bef88"], "statement_hash": "b49651f0b46e73a62dc0192cd979d9ad3784314b3e238a18f1a422b06027e0a3"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "ea3d57be655e7c2c6425c025119b4135", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "In contrib/pgcrypto, check for error returns from OpenSSL's EVP functions", "evidence": {"same_day": true, "patch_ids": ["816638745287462ad4cd0683af7bef88"], "statement_hash": "b49651f0b46e73a62dc0192cd979d9ad3784314b3e238a18f1a422b06027e0a3"}, "url": "/docs/compare/?release=12.6#12.6-2adaac067666f9cc", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "a76720e667d44c9e133e8d3af6b1285e", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "In contrib/pgcrypto, check for error returns from OpenSSL's EVP functions", "evidence": {"same_day": true, "patch_ids": ["816638745287462ad4cd0683af7bef88"], "statement_hash": "b49651f0b46e73a62dc0192cd979d9ad3784314b3e238a18f1a422b06027e0a3"}, "url": "/docs/compare/?release=11.11#11.11-41d052aeb15e6f9c", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "611e79b45feb395f9f5b49589f5f36b0", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "In contrib/pgcrypto, check for error returns from OpenSSL's EVP functions", "evidence": {"same_day": true, "patch_ids": ["816638745287462ad4cd0683af7bef88"], "statement_hash": "b49651f0b46e73a62dc0192cd979d9ad3784314b3e238a18f1a422b06027e0a3"}, "url": "/docs/compare/?release=10.16#10.16-41d052aeb15e6f9c", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "cbb7bc3f0b65264df75ce5df285704b4", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "In contrib/pgcrypto, check for error returns from OpenSSL's EVP functions", "evidence": {"same_day": true, "patch_ids": ["816638745287462ad4cd0683af7bef88"], "statement_hash": "b49651f0b46e73a62dc0192cd979d9ad3784314b3e238a18f1a422b06027e0a3"}, "url": "/docs/compare/?release=9.6.21#9.6.21-41d052aeb15e6f9c", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "cbe074842e9ede704031080b60dea276", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "In contrib/pgcrypto, check for error returns from OpenSSL's EVP functions", "evidence": {"same_day": true, "patch_ids": ["816638745287462ad4cd0683af7bef88"], "statement_hash": "b49651f0b46e73a62dc0192cd979d9ad3784314b3e238a18f1a422b06027e0a3"}, "url": "/docs/compare/?release=9.5.25#9.5.25-41d052aeb15e6f9c", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-96bd1796f5fd244a", "cves": [], "html": "Make contrib/pg_prewarm more robust when the cluster is shut down before prewarming is complete (Tom Lane) §
Previously, autoprewarm would rewrite its status file with only the block numbers that it had managed to load so far, thus perhaps largely disabling the prewarm functionality in the next startup. Instead, suppress status file updates until the initial loading pass is complete.
", "text": "Make contrib/pg_prewarm more robust when the cluster is shut down before prewarming is complete (Tom Lane) § Previously, autoprewarm would rewrite its status file with only the block numbers that it had managed to load so far, thus perhaps largely disabling the prewarm functionality in the next startup. Instead, suppress status file updates until the initial loading pass is complete.", "title": "Make contrib/pg_prewarm more robust when the cluster is shut down before prewarming is complete", "commits": ["4b0292253"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "6061a128c73b21100593fa05c4e05270cdcb6a4b64f5b617d19bc6c246a3ebc9", "section_path": ["Changes"], "commit_groups": [["4b0292253", "a1bd14d54", "f581e5383", "ff769831e"]], "identity_text": "Make contrib/pg_prewarm more robust when the cluster is shut down before prewarming is complete (Tom Lane) Previously, autoprewarm would rewrite its status file with only the block numbers that it had managed to load so far, thus perhaps largely disabling the prewarm functionality in the next startup. Instead, suppress status file updates until the initial loading pass is complete.", "commit_aliases": ["4b0292253", "a1bd14d54", "f581e5383", "ff769831e"], "source_commits": ["4b0292253"], "source_entry_id": "13.2/changes/071", "db_id": "c2a6118520e3c3fad0a1a6e90931aeb7", "patch_ids": ["8bdc3d279deb85e7b85fac5d64e3538b"], "statement_hash": "7032185baaca78b233eb577dad1f34de8834445ab339accfb83ec85d98c357f4", "relations": [{"rule": 2, "type": "equivalent", "target": "7c1e90eadc2afb9a4c4187c7835fe946", "evidence": {"same_day": true, "patch_ids": ["8bdc3d279deb85e7b85fac5d64e3538b"], "statement_hash": "7032185baaca78b233eb577dad1f34de8834445ab339accfb83ec85d98c357f4"}}, {"rule": 2, "type": "equivalent", "target": "d1913b31d8995ca3637ace5d865c9f17", "evidence": {"same_day": true, "patch_ids": ["8bdc3d279deb85e7b85fac5d64e3538b"], "statement_hash": "7032185baaca78b233eb577dad1f34de8834445ab339accfb83ec85d98c357f4"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "d1913b31d8995ca3637ace5d865c9f17", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Make contrib/pg_prewarm more robust when the cluster is shut down before prewarming is complete", "evidence": {"same_day": true, "patch_ids": ["8bdc3d279deb85e7b85fac5d64e3538b"], "statement_hash": "7032185baaca78b233eb577dad1f34de8834445ab339accfb83ec85d98c357f4"}, "url": "/docs/compare/?release=12.6#12.6-6f5a35f9de050901", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "7c1e90eadc2afb9a4c4187c7835fe946", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Make contrib/pg_prewarm more robust when the cluster is shut down before prewarming is complete", "evidence": {"same_day": true, "patch_ids": ["8bdc3d279deb85e7b85fac5d64e3538b"], "statement_hash": "7032185baaca78b233eb577dad1f34de8834445ab339accfb83ec85d98c357f4"}, "url": "/docs/compare/?release=11.11#11.11-3bdd066bda677c6e", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}]}, {"id": "13.2-0873fefda9178ae4", "cves": [], "html": "In contrib/pg_trgm's GiST index support, avoid crash in the rare case that picksplit is called on exactly two index items (Andrew Gierth, Alexander Korotkov) §
Fix miscalculation of timeouts in contrib/pg_prewarm and contrib/postgres_fdw (Alexey Kondratov, Tom Lane) §
The main loop in contrib/pg_prewarm's autoprewarm parent process underestimated its desired sleep time by a factor of 1000, causing it to consume much more CPU than intended. When waiting for a result from a remote server, contrib/postgres_fdw overestimated the desired timeout by a factor of 1000 (though this error had been mitigated by imposing a clamp to 60 seconds).
Both of these errors stemmed from incorrectly converting seconds-and-microseconds to milliseconds. Introduce a new API TimestampDifferenceMilliseconds() to make it easier to get this right in the future.
Improve configure's heuristics for selecting PG_SYSROOT on macOS (Tom Lane) § §
The new method is more likely to produce desirable results when Xcode is newer than the underlying operating system. Choosing a sysroot that does not match the OS version may result in nonfunctional executables.
", "text": "Improve configure's heuristics for selecting PG_SYSROOT on macOS (Tom Lane) § § The new method is more likely to produce desirable results when Xcode is newer than the underlying operating system. Choosing a sysroot that does not match the OS version may result in nonfunctional executables.", "title": "Improve configure's heuristics for selecting PG_SYSROOT on macOS", "commits": ["6671e8194", "f44ae4db5"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "b293b420aa26a88826c6996cdd340bf8e5d6a4783dba4bdb29e219c63e90d0e8", "section_path": ["Changes"], "commit_groups": [["046c8face", "3934543c2", "4823621db", "5fa060c8f", "f44ae4db5", "f5d044eae", "fc6d08b27"], ["175f716a8", "561dd8d8a", "6671e8194", "9d23c15a0", "a3345383d", "cbcf7b130", "cbcff1729"]], "identity_text": "Improve configure's heuristics for selecting PG_SYSROOT on macOS (Tom Lane) The new method is more likely to produce desirable results when Xcode is newer than the underlying operating system. Choosing a sysroot that does not match the OS version may result in nonfunctional executables.", "commit_aliases": ["046c8face", "175f716a8", "3934543c2", "4823621db", "561dd8d8a", "5fa060c8f", "6671e8194", "9d23c15a0", "a3345383d", "cbcf7b130", "cbcff1729", "f44ae4db5", "f5d044eae", "fc6d08b27"], "source_commits": ["6671e8194", "f44ae4db5"], "source_entry_id": "13.2/changes/074", "db_id": "ecda54d3e1145aa5606148955d54fd33", "patch_ids": ["b98de5497cc4e1bedaa602e65ed903c3", "ffb94247fc42b8a6e9cf9a9bb7bd68ef"], "statement_hash": "16d396557e7e198bde05a3d447117a5a2e509700efc43f3a2dd68fa0bc0f941f", "relations": [{"rule": 2, "type": "equivalent", "target": "0d35ad6bcaa8006c1bfdbd27bc228140", "evidence": {"same_day": true, "patch_ids": ["b98de5497cc4e1bedaa602e65ed903c3", "ffb94247fc42b8a6e9cf9a9bb7bd68ef"], "statement_hash": "16d396557e7e198bde05a3d447117a5a2e509700efc43f3a2dd68fa0bc0f941f"}}, {"rule": 2, "type": "equivalent", "target": "28ae8e08a4c561e54d615965283db54d", "evidence": {"same_day": true, "patch_ids": ["b98de5497cc4e1bedaa602e65ed903c3", "ffb94247fc42b8a6e9cf9a9bb7bd68ef"], "statement_hash": "16d396557e7e198bde05a3d447117a5a2e509700efc43f3a2dd68fa0bc0f941f"}}, {"rule": 2, "type": "equivalent", "target": "332172d08954d7c312db25147cab116e", "evidence": {"same_day": true, "patch_ids": ["b98de5497cc4e1bedaa602e65ed903c3", "ffb94247fc42b8a6e9cf9a9bb7bd68ef"], "statement_hash": "16d396557e7e198bde05a3d447117a5a2e509700efc43f3a2dd68fa0bc0f941f"}}, {"rule": 2, "type": "equivalent", "target": "6afa264d9210ef5c24db0048e08c4cbd", "evidence": {"same_day": true, "patch_ids": ["b98de5497cc4e1bedaa602e65ed903c3", "ffb94247fc42b8a6e9cf9a9bb7bd68ef"], "statement_hash": "16d396557e7e198bde05a3d447117a5a2e509700efc43f3a2dd68fa0bc0f941f"}}, {"rule": 2, "type": "equivalent", "target": "94f9a8122f50186e2c25690304ebbe59", "evidence": {"same_day": true, "patch_ids": ["b98de5497cc4e1bedaa602e65ed903c3", "ffb94247fc42b8a6e9cf9a9bb7bd68ef"], "statement_hash": "16d396557e7e198bde05a3d447117a5a2e509700efc43f3a2dd68fa0bc0f941f"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "28ae8e08a4c561e54d615965283db54d", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Improve configure's heuristics for selecting PG_SYSROOT on macOS", "evidence": {"same_day": true, "patch_ids": ["b98de5497cc4e1bedaa602e65ed903c3", "ffb94247fc42b8a6e9cf9a9bb7bd68ef"], "statement_hash": "16d396557e7e198bde05a3d447117a5a2e509700efc43f3a2dd68fa0bc0f941f"}, "url": "/docs/compare/?release=12.6#12.6-6bc9f88081a9f69b", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "0d35ad6bcaa8006c1bfdbd27bc228140", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Improve configure's heuristics for selecting PG_SYSROOT on macOS", "evidence": {"same_day": true, "patch_ids": ["b98de5497cc4e1bedaa602e65ed903c3", "ffb94247fc42b8a6e9cf9a9bb7bd68ef"], "statement_hash": "16d396557e7e198bde05a3d447117a5a2e509700efc43f3a2dd68fa0bc0f941f"}, "url": "/docs/compare/?release=11.11#11.11-42170eb96496b72f", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "6afa264d9210ef5c24db0048e08c4cbd", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Improve configure's heuristics for selecting PG_SYSROOT on macOS", "evidence": {"same_day": true, "patch_ids": ["b98de5497cc4e1bedaa602e65ed903c3", "ffb94247fc42b8a6e9cf9a9bb7bd68ef"], "statement_hash": "16d396557e7e198bde05a3d447117a5a2e509700efc43f3a2dd68fa0bc0f941f"}, "url": "/docs/compare/?release=10.16#10.16-42170eb96496b72f", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "94f9a8122f50186e2c25690304ebbe59", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "Improve configure's heuristics for selecting PG_SYSROOT on macOS", "evidence": {"same_day": true, "patch_ids": ["b98de5497cc4e1bedaa602e65ed903c3", "ffb94247fc42b8a6e9cf9a9bb7bd68ef"], "statement_hash": "16d396557e7e198bde05a3d447117a5a2e509700efc43f3a2dd68fa0bc0f941f"}, "url": "/docs/compare/?release=9.6.21#9.6.21-42170eb96496b72f", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "332172d08954d7c312db25147cab116e", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "Improve configure's heuristics for selecting PG_SYSROOT on macOS", "evidence": {"same_day": true, "patch_ids": ["b98de5497cc4e1bedaa602e65ed903c3", "ffb94247fc42b8a6e9cf9a9bb7bd68ef"], "statement_hash": "16d396557e7e198bde05a3d447117a5a2e509700efc43f3a2dd68fa0bc0f941f"}, "url": "/docs/compare/?release=9.5.25#9.5.25-42170eb96496b72f", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-a7db8bd1f039decd", "cves": [], "html": "While building on macOS, specify -isysroot in link steps as well as compile steps (James Hilliard) §
This likewise improves the results when Xcode is out of sync with the operating system.
", "text": "While building on macOS, specify -isysroot in link steps as well as compile steps (James Hilliard) § This likewise improves the results when Xcode is out of sync with the operating system.", "title": "While building on macOS, specify -isysroot in link steps as well as compile steps", "commits": ["9e9a31bd0"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "93bf60ebd499e128cb34c90dd75049f1bc936b376b8ac945ea03cedc45b42053", "section_path": ["Changes"], "commit_groups": [["153bf8d20", "2bb8c0f1d", "49407dc32", "5b8360427", "9e9a31bd0", "d01e37845", "e7abc1111"]], "identity_text": "While building on macOS, specify -isysroot in link steps as well as compile steps (James Hilliard) This likewise improves the results when Xcode is out of sync with the operating system.", "commit_aliases": ["153bf8d20", "2bb8c0f1d", "49407dc32", "5b8360427", "9e9a31bd0", "d01e37845", "e7abc1111"], "source_commits": ["9e9a31bd0"], "source_entry_id": "13.2/changes/075", "db_id": "e12b96d5455ac0d984ccdbb7cc5e7b09", "patch_ids": ["80130960bc3c7445ce6eed2f109cc92b"], "statement_hash": "d045eecb04941f70ac530e0e53b2b1ef916a0750a18a1105c60364660f4df848", "relations": [{"rule": 2, "type": "equivalent", "target": "00db00872ee8dd93b8ad2fddef7d7caa", "evidence": {"same_day": true, "patch_ids": ["80130960bc3c7445ce6eed2f109cc92b"], "statement_hash": "d045eecb04941f70ac530e0e53b2b1ef916a0750a18a1105c60364660f4df848"}}, {"rule": 2, "type": "equivalent", "target": "2522eabd5feafb099b7f0b87e4ee4167", "evidence": {"same_day": true, "patch_ids": ["80130960bc3c7445ce6eed2f109cc92b"], "statement_hash": "d045eecb04941f70ac530e0e53b2b1ef916a0750a18a1105c60364660f4df848"}}, {"rule": 2, "type": "equivalent", "target": "8de8a5a4d24b7e9f21adea1c8492904a", "evidence": {"same_day": true, "patch_ids": ["80130960bc3c7445ce6eed2f109cc92b"], "statement_hash": "d045eecb04941f70ac530e0e53b2b1ef916a0750a18a1105c60364660f4df848"}}, {"rule": 2, "type": "equivalent", "target": "aeff8a687ff80c37bd0151fb3b282a9f", "evidence": {"same_day": true, "patch_ids": ["80130960bc3c7445ce6eed2f109cc92b"], "statement_hash": "d045eecb04941f70ac530e0e53b2b1ef916a0750a18a1105c60364660f4df848"}}, {"rule": 2, "type": "equivalent", "target": "c2af11e4ba24a0887d5a17c0dbbbcc87", "evidence": {"same_day": true, "patch_ids": ["80130960bc3c7445ce6eed2f109cc92b"], "statement_hash": "d045eecb04941f70ac530e0e53b2b1ef916a0750a18a1105c60364660f4df848"}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "c2af11e4ba24a0887d5a17c0dbbbcc87", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "While building on macOS, specify -isysroot in link steps as well as compile steps", "evidence": {"same_day": true, "patch_ids": ["80130960bc3c7445ce6eed2f109cc92b"], "statement_hash": "d045eecb04941f70ac530e0e53b2b1ef916a0750a18a1105c60364660f4df848"}, "url": "/docs/compare/?release=12.6#12.6-84b4eae14087132f", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "8de8a5a4d24b7e9f21adea1c8492904a", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "While building on macOS, specify -isysroot in link steps as well as compile steps", "evidence": {"same_day": true, "patch_ids": ["80130960bc3c7445ce6eed2f109cc92b"], "statement_hash": "d045eecb04941f70ac530e0e53b2b1ef916a0750a18a1105c60364660f4df848"}, "url": "/docs/compare/?release=11.11#11.11-82804fd26368c1ed", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "aeff8a687ff80c37bd0151fb3b282a9f", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "While building on macOS, specify -isysroot in link steps as well as compile steps", "evidence": {"same_day": true, "patch_ids": ["80130960bc3c7445ce6eed2f109cc92b"], "statement_hash": "d045eecb04941f70ac530e0e53b2b1ef916a0750a18a1105c60364660f4df848"}, "url": "/docs/compare/?release=10.16#10.16-82804fd26368c1ed", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "00db00872ee8dd93b8ad2fddef7d7caa", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "While building on macOS, specify -isysroot in link steps as well as compile steps", "evidence": {"same_day": true, "patch_ids": ["80130960bc3c7445ce6eed2f109cc92b"], "statement_hash": "d045eecb04941f70ac530e0e53b2b1ef916a0750a18a1105c60364660f4df848"}, "url": "/docs/compare/?release=9.6.21#9.6.21-82804fd26368c1ed", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "2522eabd5feafb099b7f0b87e4ee4167", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "While building on macOS, specify -isysroot in link steps as well as compile steps", "evidence": {"same_day": true, "patch_ids": ["80130960bc3c7445ce6eed2f109cc92b"], "statement_hash": "d045eecb04941f70ac530e0e53b2b1ef916a0750a18a1105c60364660f4df848"}, "url": "/docs/compare/?release=9.5.25#9.5.25-82804fd26368c1ed", "source_url": "/docs/release/9.5.25/#AEN127304"}]}, {"id": "13.2-214b09fcfe776ff6", "cves": [], "html": "Fix JIT compilation to be compatible with LLVM 11 and LLVM 12 (Andres Freund) § §
", "text": "Fix JIT compilation to be compatible with LLVM 11 and LLVM 12 (Andres Freund) § §", "title": "Fix JIT compilation to be compatible with LLVM 11 and LLVM 12", "commits": ["4f64daf73", "6a192c77d"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "06c73fee09746a2855a74058222d2e44c54eb2ffcc9583422a83a7a1970fe0fe", "section_path": ["Changes"], "commit_groups": [["4f64daf73", "9543f0861", "b07490b91", "f4f924b3e"], ["6a192c77d", "6c57f2ed1", "90eb343ef", "fa7a52fb9"]], "identity_text": "Fix JIT compilation to be compatible with LLVM 11 and LLVM 12 (Andres Freund)", "commit_aliases": ["4f64daf73", "6a192c77d", "6c57f2ed1", "90eb343ef", "9543f0861", "b07490b91", "f4f924b3e", "fa7a52fb9"], "source_commits": ["4f64daf73", "6a192c77d"], "source_entry_id": "13.2/changes/076", "db_id": "fff2593fb3db34e7d28cf52cad770917", "patch_ids": ["6873195cd38f6166a1b0f007a1b9d943", "7409de92db5bba303439e4ed29f94ee4"], "statement_hash": "21f093f8b8a267c7fe96646df384b10d36017fa2af4c6cc2821bf492c8f04ac7", "relations": [{"rule": 2, "type": "equivalent", "target": "04eea6763c68cc0f210cb5d49d7f9a45", "evidence": {"same_day": true, "patch_ids": ["6873195cd38f6166a1b0f007a1b9d943", "7409de92db5bba303439e4ed29f94ee4"], "statement_hash": "21f093f8b8a267c7fe96646df384b10d36017fa2af4c6cc2821bf492c8f04ac7"}}, {"rule": 2, "type": "related", "target": "953eea49ea13be68e1ba18f192f409e3", "evidence": {"same_day": false, "patch_ids": ["6873195cd38f6166a1b0f007a1b9d943"]}}, {"rule": 2, "type": "equivalent", "target": "aed82f7d691f0c4b2650925d9b422ec1", "evidence": {"same_day": true, "patch_ids": ["6873195cd38f6166a1b0f007a1b9d943", "7409de92db5bba303439e4ed29f94ee4"], "statement_hash": "21f093f8b8a267c7fe96646df384b10d36017fa2af4c6cc2821bf492c8f04ac7"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "953eea49ea13be68e1ba18f192f409e3", "kind": "related", "version": "14.0", "label": "14.0", "title": "Add support for LLVM version 12", "evidence": {"same_day": false, "patch_ids": ["6873195cd38f6166a1b0f007a1b9d943"]}, "url": "/docs/compare/?release=14.0#14.0-3ef61bd8dfaf8c16", "source_url": "/docs/release/14.0/#id-1.11.6.30.5.14"}, {"db_id": "04eea6763c68cc0f210cb5d49d7f9a45", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Fix JIT compilation to be compatible with LLVM 11 and LLVM 12", "evidence": {"same_day": true, "patch_ids": ["6873195cd38f6166a1b0f007a1b9d943", "7409de92db5bba303439e4ed29f94ee4"], "statement_hash": "21f093f8b8a267c7fe96646df384b10d36017fa2af4c6cc2821bf492c8f04ac7"}, "url": "/docs/compare/?release=12.6#12.6-3d21210372887692", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "aed82f7d691f0c4b2650925d9b422ec1", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Fix JIT compilation to be compatible with LLVM 11 and LLVM 12", "evidence": {"same_day": true, "patch_ids": ["6873195cd38f6166a1b0f007a1b9d943", "7409de92db5bba303439e4ed29f94ee4"], "statement_hash": "21f093f8b8a267c7fe96646df384b10d36017fa2af4c6cc2821bf492c8f04ac7"}, "url": "/docs/compare/?release=11.11#11.11-90ab23b3636d2482", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}]}, {"id": "13.2-b8315fdc558c9b59", "cves": [], "html": "Fix potential mishandling of references to boolean variables in JIT expression compilation (Andres Freund) §
\nNo field reports attributable to this have been seen, but it seems likely that it could cause problems on some architectures.
", "text": "Fix potential mishandling of references to boolean variables in JIT expression compilation (Andres Freund) § No field reports attributable to this have been seen, but it seems likely that it could cause problems on some architectures.", "title": "Fix potential mishandling of references to boolean variables in JIT expression compilation", "commits": ["01c6370a3"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "89e0c5eed2b508dc996d9ada2d7b12920d617a837d0f98aaf289160188847d9e", "section_path": ["Changes"], "commit_groups": [["01c6370a3", "1e16ad101", "27b57f806", "5da871bfa"]], "identity_text": "Fix potential mishandling of references to boolean variables in JIT expression compilation (Andres Freund) No field reports attributable to this have been seen, but it seems likely that it could cause problems on some architectures.", "commit_aliases": ["01c6370a3", "1e16ad101", "27b57f806", "5da871bfa"], "source_commits": ["01c6370a3"], "source_entry_id": "13.2/changes/077", "db_id": "8eae359108ef1d9c225f5b97bc4850b6", "patch_ids": ["60aabc4ccc1c43b9552f355a4079e1d4"], "statement_hash": "00a08efe466e91a2139a50ff65057b9b5a0ed6030fdf2f2931bf7ae512be81f3", "relations": [{"rule": 2, "type": "equivalent", "target": "2328be01a3546227d1b6f164e2f3407f", "evidence": {"same_day": true, "patch_ids": ["60aabc4ccc1c43b9552f355a4079e1d4"], "statement_hash": "00a08efe466e91a2139a50ff65057b9b5a0ed6030fdf2f2931bf7ae512be81f3"}}, {"rule": 2, "type": "equivalent", "target": "e994878e225581cee40beb5b5b89ab84", "evidence": {"same_day": true, "patch_ids": ["60aabc4ccc1c43b9552f355a4079e1d4"], "statement_hash": "00a08efe466e91a2139a50ff65057b9b5a0ed6030fdf2f2931bf7ae512be81f3"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2328be01a3546227d1b6f164e2f3407f", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Fix potential mishandling of references to boolean variables in JIT expression compilation", "evidence": {"same_day": true, "patch_ids": ["60aabc4ccc1c43b9552f355a4079e1d4"], "statement_hash": "00a08efe466e91a2139a50ff65057b9b5a0ed6030fdf2f2931bf7ae512be81f3"}, "url": "/docs/compare/?release=12.6#12.6-0a2c1e822bc4fe50", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "e994878e225581cee40beb5b5b89ab84", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Fix potential mishandling of references to boolean variables in JIT expression compilation", "evidence": {"same_day": true, "patch_ids": ["60aabc4ccc1c43b9552f355a4079e1d4"], "statement_hash": "00a08efe466e91a2139a50ff65057b9b5a0ed6030fdf2f2931bf7ae512be81f3"}, "url": "/docs/compare/?release=11.11#11.11-d0bae580d8af6d4b", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}]}, {"id": "13.2-7fdec63863c7be50", "cves": [], "html": "Fix compile failure with ICU 68 and later (Tom Lane) §
", "text": "Fix compile failure with ICU 68 and later (Tom Lane) §", "title": "Fix compile failure with ICU 68 and later", "commits": ["53c7b4f62"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "f3722690b6a088e9020275b6cdb94ee0ae63eeff0b0ea434a841e6344b592ad6", "section_path": ["Changes"], "commit_groups": [["029fa664e", "53c7b4f62", "89aa30a17", "ad84ecc98"]], "identity_text": "Fix compile failure with ICU 68 and later (Tom Lane)", "commit_aliases": ["029fa664e", "53c7b4f62", "89aa30a17", "ad84ecc98"], "source_commits": ["53c7b4f62"], "source_entry_id": "13.2/changes/078", "db_id": "fdbbc55d23112ae5bc76e6174063a172", "patch_ids": ["56184858121f351bd92d2b22beb4d2e4"], "statement_hash": "0cb806773f4e96336e4037911a8333ea573321f5a233bc8f01779855f75603c9", "relations": [{"rule": 2, "type": "equivalent", "target": "1b62d6e267ae61803134e52887c8239c", "evidence": {"same_day": true, "patch_ids": ["56184858121f351bd92d2b22beb4d2e4"], "statement_hash": "0cb806773f4e96336e4037911a8333ea573321f5a233bc8f01779855f75603c9"}}, {"rule": 2, "type": "equivalent", "target": "37dec7fc33abb1131383996bbef7b008", "evidence": {"same_day": true, "patch_ids": ["56184858121f351bd92d2b22beb4d2e4"], "statement_hash": "0cb806773f4e96336e4037911a8333ea573321f5a233bc8f01779855f75603c9"}}], "version": "13.2", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "37dec7fc33abb1131383996bbef7b008", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Fix compile failure with ICU 68 and later", "evidence": {"same_day": true, "patch_ids": ["56184858121f351bd92d2b22beb4d2e4"], "statement_hash": "0cb806773f4e96336e4037911a8333ea573321f5a233bc8f01779855f75603c9"}, "url": "/docs/compare/?release=12.6#12.6-4d8e13a0294da695", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "1b62d6e267ae61803134e52887c8239c", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Fix compile failure with ICU 68 and later", "evidence": {"same_day": true, "patch_ids": ["56184858121f351bd92d2b22beb4d2e4"], "statement_hash": "0cb806773f4e96336e4037911a8333ea573321f5a233bc8f01779855f75603c9"}, "url": "/docs/compare/?release=11.11#11.11-5a8f60b82fd3d17d", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}]}, {"id": "13.2-4ee021d0d5a16c8f", "cves": [], "html": "Avoid memcpy() with a NULL source pointer and zero count during partitioned index creation (Álvaro Herrera) §
While such a call is not known to cause problems in itself, some compilers assume that the arguments of memcpy() are never NULL, which could result in incorrect optimization of nearby code.
Update time zone data files to tzdata release 2021a for DST law changes in Russia (Volgograd zone) and South Sudan, plus historical corrections for Australia, Bahamas, Belize, Bermuda, Ghana, Israel, Kenya, Nigeria, Palestine, Seychelles, and Vanuatu. (Tom Lane) §
\nNotably, the Australia/Currie zone has been corrected to the point where it is identical to Australia/Hobart.
", "text": "Update time zone data files to tzdata release 2021a for DST law changes in Russia (Volgograd zone) and South Sudan, plus historical corrections for Australia, Bahamas, Belize, Bermuda, Ghana, Israel, Kenya, Nigeria, Palestine, Seychelles, and Vanuatu. (Tom Lane) § Notably, the Australia/Currie zone has been corrected to the point where it is identical to Australia/Hobart.", "title": "Update time zone data files to tzdata release 2021a for DST law changes in Russia (Volgograd zone) and South Sudan, plus historical corrections for Australia, Bahamas, Belize, Bermuda, Ghana, Israel, Kenya, Nigeria, Palestine, Seychelles, and Vanuatu.", "commits": ["58a545344"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.2/#id-1.11.6.27.5", "source_hash": "0fa2c05ce030564f1cc1329aea93fc8f13d7faa607fa1c3483334cd012c054a8", "section_path": ["Changes"], "commit_groups": [["58a545344", "5db6ba303", "728971d5f", "7e0786751", "c26a0865d", "c7edf4ac2", "c82c015b5"]], "identity_text": "Update time zone data files to tzdata release 2021a for DST law changes in Russia (Volgograd zone) and South Sudan, plus historical corrections for Australia, Bahamas, Belize, Bermuda, Ghana, Israel, Kenya, Nigeria, Palestine, Seychelles, and Vanuatu. (Tom Lane) Notably, the Australia/Currie zone has been corrected to the point where it is identical to Australia/Hobart.", "commit_aliases": ["58a545344", "5db6ba303", "728971d5f", "7e0786751", "c26a0865d", "c7edf4ac2", "c82c015b5"], "source_commits": ["58a545344"], "source_entry_id": "13.2/changes/080", "db_id": "a8793fc6cdc85db585208fac7583d7c2", "patch_ids": ["7a5adfdb0365a88b0dba369addc9e369"], "statement_hash": "821528ba5c1d91d3f74f59b5100c13d12547669a201f371c82cdc74e24d9937c", "relations": [{"rule": 2, "type": "equivalent", "target": "13b3d5c0d37ba51a84d68cc873bc98b7", "evidence": {"same_day": true, "patch_ids": ["7a5adfdb0365a88b0dba369addc9e369"], "statement_hash": "821528ba5c1d91d3f74f59b5100c13d12547669a201f371c82cdc74e24d9937c"}}, {"rule": 2, "type": "equivalent", "target": "b38670a4a6df6b0f68d2a68e55b07fd3", "evidence": {"same_day": true, "patch_ids": ["7a5adfdb0365a88b0dba369addc9e369"]}}, {"rule": 2, "type": "equivalent", "target": "cb9124df6411b29fcb6c954a1393bf96", "evidence": {"same_day": true, "patch_ids": ["7a5adfdb0365a88b0dba369addc9e369"]}}, {"rule": 2, "type": "equivalent", "target": "da40f8f97e1684da7e34d005f155d61a", "evidence": {"same_day": true, "patch_ids": ["7a5adfdb0365a88b0dba369addc9e369"]}}, {"rule": 2, "type": "equivalent", "target": "ef8fcf4bc85f6a2f84c3cc4000f5ff63", "evidence": {"same_day": true, "patch_ids": ["7a5adfdb0365a88b0dba369addc9e369"]}}], "version": "13.2", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "13b3d5c0d37ba51a84d68cc873bc98b7", "kind": "equivalent", "version": "12.6", "label": "12.6", "title": "Update time zone data files to tzdata release 2021a for DST law changes in Russia (Volgograd zone) and South Sudan, plus historical corrections for Australia, Bahamas, Belize, Bermuda, Ghana, Israel, Kenya, Nigeria, Palestine, Seychelles, and Vanuatu.", "evidence": {"same_day": true, "patch_ids": ["7a5adfdb0365a88b0dba369addc9e369"], "statement_hash": "821528ba5c1d91d3f74f59b5100c13d12547669a201f371c82cdc74e24d9937c"}, "url": "/docs/compare/?release=12.6#12.6-15453ed360de50a6", "source_url": "/docs/release/12.6/#id-1.11.6.22.5"}, {"db_id": "ef8fcf4bc85f6a2f84c3cc4000f5ff63", "kind": "equivalent", "version": "11.11", "label": "11.11", "title": "Update time zone data files to tzdata release 2021a for DST law changes in Russia (Volgograd zone) and South Sudan, plus historical corrections for Australia, Bahamas, Belize, Bermuda, Ghana, Israel, Kenya, Nigeria, Palestine, Seychelles, and Vanuatu.", "evidence": {"same_day": true, "patch_ids": ["7a5adfdb0365a88b0dba369addc9e369"]}, "url": "/docs/compare/?release=11.11#11.11-b3a953c12b1da546", "source_url": "/docs/release/11.11/#id-1.11.6.16.5"}, {"db_id": "cb9124df6411b29fcb6c954a1393bf96", "kind": "equivalent", "version": "10.16", "label": "10.16", "title": "Update time zone data files to tzdata release 2021a for DST law changes in Russia (Volgograd zone) and South Sudan, plus historical corrections for Australia, Bahamas, Belize, Bermuda, Ghana, Israel, Kenya, Nigeria, Palestine, Seychelles, and Vanuatu.", "evidence": {"same_day": true, "patch_ids": ["7a5adfdb0365a88b0dba369addc9e369"]}, "url": "/docs/compare/?release=10.16#10.16-b3a953c12b1da546", "source_url": "/docs/release/10.16/#id-1.11.6.12.5"}, {"db_id": "da40f8f97e1684da7e34d005f155d61a", "kind": "equivalent", "version": "9.6.21", "label": "9.6.21", "title": "Update time zone data files to tzdata release 2021a for DST law changes in Russia (Volgograd zone) and South Sudan, plus historical corrections for Australia, Bahamas, Belize, Bermuda, Ghana, Israel, Kenya, Nigeria, Palestine, Seychelles, and Vanuatu.", "evidence": {"same_day": true, "patch_ids": ["7a5adfdb0365a88b0dba369addc9e369"]}, "url": "/docs/compare/?release=9.6.21#9.6.21-b3a953c12b1da546", "source_url": "/docs/release/9.6.21/#AEN132403"}, {"db_id": "b38670a4a6df6b0f68d2a68e55b07fd3", "kind": "equivalent", "version": "9.5.25", "label": "9.5.25", "title": "Update time zone data files to tzdata release 2021a for DST law changes in Russia (Volgograd zone) and South Sudan, plus historical corrections for Australia, Bahamas, Belize, Bermuda, Ghana, Israel, Kenya, Nigeria, Palestine, Seychelles, and Vanuatu.", "evidence": {"same_day": true, "patch_ids": ["7a5adfdb0365a88b0dba369addc9e369"]}, "url": "/docs/compare/?release=9.5.25#9.5.25-b3a953c12b1da546", "source_url": "/docs/release/9.5.25/#AEN127304"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 80}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 42}, {"key": "security", "label": "Security", "count": 2}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 36}], "total": 80, "release_count": 1, "cross_major": false, "cve_count": 2, "cves": [{"id": "CVE-2021-3393", "url": "https://www.postgresql.org/support/security/CVE-2021-3393/", "fixed": {"11": "11.11", "12": "12.6", "13": "13.2"}, "score": 3.1, "title": "Fix information leakage in constraint-violation error messages", "vector": "AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:N/A:N", "affected": {"11": "11", "12": "12", "13": "13"}, "component": "core server", "published": {"11": "2021-02-11", "12": "2021-02-11", "13": "2021-02-11"}, "introduced": {}, "cvss_version": "3.0", "description_en": "A user having an UPDATE privilege on a partitioned table but lacking the SELECT privilege on some column may be able to acquire denied-column values from an error message. This is similar to CVE-2014-8161 , but the conditions to exploit are more rare.\n\nThe PostgreSQL project thanks Heikki Linnakangas for reporting this problem.", "first_published": "2021-02-11", "fixed_version": "13.2"}, {"id": "CVE-2021-20229", "url": "https://www.postgresql.org/support/security/CVE-2021-20229/", "fixed": {"13": "13.2"}, "score": 3.1, "title": "Fix failure to check per-column SELECT privileges in some join queries", "vector": "AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:N/A:N", "affected": {"13": "13"}, "component": "core server", "published": {"13": "2021-02-11"}, "introduced": {}, "cvss_version": "3.0", "description_en": "A user having a SELECT privilege on an individual column can craft a special query that returns all columns of the table.\n\nAdditionally, a stored view that uses column-level privileges will have incomplete column-usage bitmaps. In installations that depend on column-level permissions for security, it is recommended to execute CREATE OR REPLACE on all user-defined views to force them to be re-parsed.\n\nThe PostgreSQL project thanks Sven Klemm for reporting this problem.", "first_published": "2021-02-11", "fixed_version": "13.2"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 80, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}