A dump/restore is not required for those running 13.X.
\nHowever, if you are upgrading from a version earlier than 13.2, see Section E.22.
", "compatibility_count": 0, "label": "13.3", "status_label": "Historical", "eol": "2025-11-13", "age_days": 1965, "support_days": -320}, "groups": [{"date": "2021-05-13", "build": "13.3", "major": "13", "minor": 3, "manual": "13", "status": "stable", "doc_git": "", "version": "13.3", "eol_date": "2025-11-13", "date_text": "2021-05-13", "supported": false, "manual_url": "/docs/13/release-13-3.html", "source_url": "/docs/release/13.3/", "entry_count": 48, "placeholder": false, "content_hash": "c495549d8c4e0902c6e9a7c1ca4f3ef9446fcdb7067582096caa493828cd3cad", "manual_build": "13.23", "source_as_of": "", "changes_count": 48, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 13.X.
\nHowever, if you are upgrading from a version earlier than 13.2, see Section E.22.
", "compatibility_count": 0, "label": "13.3", "status_label": "Historical", "eol": "2025-11-13", "age_days": 1965, "support_days": -320, "entries": [{"id": "13.3-662fbe650093c58f", "cves": ["CVE-2021-32027"], "html": "Prevent integer overflows in array subscripting calculations (Tom Lane) §
\nThe array code previously did not complain about cases where an array's lower bound plus length overflows an integer. This resulted in later entries in the array becoming inaccessible (since their subscripts could not be written as integers), but more importantly it confused subsequent assignment operations. This could lead to memory overwrites, with ensuing crashes or unwanted data modifications. (CVE-2021-32027)
", "text": "Prevent integer overflows in array subscripting calculations (Tom Lane) § The array code previously did not complain about cases where an array's lower bound plus length overflows an integer. This resulted in later entries in the array becoming inaccessible (since their subscripts could not be written as integers), but more importantly it confused subsequent assignment operations. This could lead to memory overwrites, with ensuing crashes or unwanted data modifications. (CVE-2021-32027)", "title": "Prevent integer overflows in array subscripting calculations", "commits": ["467395bfd"], "section": "Changes", "category": "security", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "17a0dbfc23b30e1662d703c521751291abf5bc4d5162b64273f000e2f1727e35", "section_path": ["Changes"], "commit_groups": [["06bfbe854", "0c1caa48d", "2fb809d3e", "3b0f6a7ae", "467395bfd", "f02b9085a"]], "identity_text": "Prevent integer overflows in array subscripting calculations (Tom Lane) The array code previously did not complain about cases where an array's lower bound plus length overflows an integer. This resulted in later entries in the array becoming inaccessible (since their subscripts could not be written as integers), but more importantly it confused subsequent assignment operations. This could lead to memory overwrites, with ensuing crashes or unwanted data modifications. (CVE-2021-32027)", "commit_aliases": ["06bfbe854", "0c1caa48d", "2fb809d3e", "3b0f6a7ae", "467395bfd", "f02b9085a"], "source_commits": ["467395bfd"], "source_entry_id": "13.3/changes/001", "db_id": "c8963e580f988547350ccc8ce6625481", "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e", "relations": [{"rule": 2, "type": "equivalent", "target": "4666021688be3025a677f523ae0c8c60", "evidence": {"same_day": true, "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e"}}, {"rule": 2, "type": "equivalent", "target": "585fcef5c692b598ea6a152292683b72", "evidence": {"same_day": true, "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e"}}, {"rule": 2, "type": "equivalent", "target": "7319e67c7fec827a36de6818c38d93d2", "evidence": {"same_day": true, "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e"}}, {"rule": 2, "type": "equivalent", "target": "e4fdf746e5ec58e73f25f64763b1d119", "evidence": {"same_day": true, "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e"}}], "version": "13.3", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "e4fdf746e5ec58e73f25f64763b1d119", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Prevent integer overflows in array subscripting calculations", "evidence": {"same_day": true, "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e"}, "url": "/docs/compare/?release=12.7#12.7-ac73d078ce65a7fd", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "7319e67c7fec827a36de6818c38d93d2", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Prevent integer overflows in array subscripting calculations", "evidence": {"same_day": true, "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e"}, "url": "/docs/compare/?release=11.12#11.12-bcea760f2375d254", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "585fcef5c692b598ea6a152292683b72", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Prevent integer overflows in array subscripting calculations", "evidence": {"same_day": true, "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e"}, "url": "/docs/compare/?release=10.17#10.17-bcea760f2375d254", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "4666021688be3025a677f523ae0c8c60", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "Prevent integer overflows in array subscripting calculations", "evidence": {"same_day": true, "patch_ids": ["db73052be15292b3bf2d6ac73b599dd7"], "statement_hash": "2e3bb88aaeea703978a5aa4c1677d3c53de4a1c353484fd9ba322845c504673e"}, "url": "/docs/compare/?release=9.6.22#9.6.22-bcea760f2375d254", "source_url": "/docs/release/9.6.22/#AEN132280"}]}, {"id": "13.3-0f677eeae1faab2b", "cves": ["CVE-2021-32028"], "html": "Fix mishandling of “junk” columns in INSERT ... ON CONFLICT ... UPDATE target lists (Tom Lane) §
If the UPDATE list contains any multi-column sub-selects (which give rise to junk columns in addition to the results proper), the UPDATE path would end up storing tuples that include the values of the extra junk columns. That's fairly harmless in the short run, but if new columns are added to the table then the values would become accessible, possibly leading to malfunctions if they don't match the datatypes of the added columns.
In addition, in versions supporting cross-partition updates, a cross-partition update triggered by such a case had the reverse problem: the junk columns were removed from the target list, typically causing an immediate crash due to malfunction of the multi-column sub-select mechanism. (CVE-2021-32028)
", "text": "Fix mishandling of “junk” columns in INSERT ... ON CONFLICT ... UPDATE target lists (Tom Lane) § If the UPDATE list contains any multi-column sub-selects (which give rise to junk columns in addition to the results proper), the UPDATE path would end up storing tuples that include the values of the extra junk columns. That's fairly harmless in the short run, but if new columns are added to the table then the values would become accessible, possibly leading to malfunctions if they don't match the datatypes of the added columns. In addition, in versions supporting cross-partition updates, a cross-partition update triggered by such a case had the reverse problem: the junk columns were removed from the target list, typically causing an immediate crash due to malfunction of the multi-column sub-select mechanism. (CVE-2021-32028)", "title": "Fix mishandling of “junk” columns in INSERT ... ON CONFLICT ... UPDATE target lists", "commits": ["4a8656a7e"], "section": "Changes", "category": "security", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "ef2c6243bb1ab46a774cc148a882e2f07557fcd607898a9bda9a6ed67c3243b5", "section_path": ["Changes"], "commit_groups": [["049e1e2ed", "0fcb8e2e0", "4a8656a7e", "52a441362", "a5fa3e067", "b7d1f32ff"]], "identity_text": "Fix mishandling of junk columns in INSERT ... ON CONFLICT ... UPDATE target lists (Tom Lane) If the UPDATE list contains any multi-column sub-selects (which give rise to junk columns in addition to the results proper), the UPDATE path would end up storing tuples that include the values of the extra junk columns. That's fairly harmless in the short run, but if new columns are added to the table then the values would become accessible, possibly leading to malfunctions if they don't match the datatypes of the added columns. In addition, in versions supporting cross-partition updates, a cross-partition update triggered by such a case had the reverse problem: the junk columns were removed from the target list, typically causing an immediate crash due to malfunction of the multi-column sub-select mechanism. (CVE-2021-32028)", "commit_aliases": ["049e1e2ed", "0fcb8e2e0", "4a8656a7e", "52a441362", "a5fa3e067", "b7d1f32ff"], "source_commits": ["4a8656a7e"], "source_entry_id": "13.3/changes/002", "db_id": "cfea65ca9d40576b1d0602eaccf39e2a", "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe", "relations": [{"rule": 2, "type": "equivalent", "target": "2ee7e4bc11ce6a07ec695882d5d4830d", "evidence": {"same_day": true, "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe"}}, {"rule": 2, "type": "equivalent", "target": "3f2c9193965eda4138ae7d054f8f1a9b", "evidence": {"same_day": true, "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe"}}, {"rule": 2, "type": "equivalent", "target": "402ddf1823a78b25bc4bae8aa78148a5", "evidence": {"same_day": true, "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe"}}, {"rule": 2, "type": "equivalent", "target": "d7b2c329c0c08a8f6a79de7573c441e0", "evidence": {"same_day": true, "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe"}}], "version": "13.3", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "d7b2c329c0c08a8f6a79de7573c441e0", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Fix mishandling of “junk” columns in INSERT ... ON CONFLICT ... UPDATE target lists", "evidence": {"same_day": true, "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe"}, "url": "/docs/compare/?release=12.7#12.7-99371ae3858378c5", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "402ddf1823a78b25bc4bae8aa78148a5", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Fix mishandling of “junk” columns in INSERT ... ON CONFLICT ... UPDATE target lists", "evidence": {"same_day": true, "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe"}, "url": "/docs/compare/?release=11.12#11.12-c8027d8487f3eecc", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "2ee7e4bc11ce6a07ec695882d5d4830d", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Fix mishandling of “junk” columns in INSERT ... ON CONFLICT ... UPDATE target lists", "evidence": {"same_day": true, "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe"}, "url": "/docs/compare/?release=10.17#10.17-c8027d8487f3eecc", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "3f2c9193965eda4138ae7d054f8f1a9b", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "Fix mishandling of \"junk\" columns in INSERT ... ON CONFLICT ... UPDATE target lists", "evidence": {"same_day": true, "patch_ids": ["ff3ef8c324c71352daad6839c64249d5"], "statement_hash": "7fb50e1e3c1cec9533ac76989dbe129a78800d8c1fe809989eb31f396296edfe"}, "url": "/docs/compare/?release=9.6.22#9.6.22-afa077a58ef515f6", "source_url": "/docs/release/9.6.22/#AEN132280"}]}, {"id": "13.3-461a1b783bb96232", "cves": ["CVE-2021-32029"], "html": "Fix possibly-incorrect computation of UPDATE ... RETURNING outputs for joined cross-partition updates (Amit Langote, Etsuro Fujita) § §
If an UPDATE for a partitioned table caused a row to be moved to another partition with a physically different row type (for example, one with a different set of dropped columns), computation of RETURNING results for that row could produce errors or wrong answers. No error is observed unless the UPDATE involves other tables being joined to the target table. (CVE-2021-32029)
Fix adjustment of constraint deferrability properties in partitioned tables (Álvaro Herrera) §
\nWhen applied to a foreign-key constraint of a partitioned table, ALTER TABLE ... ALTER CONSTRAINT failed to adjust the DEFERRABLE and/or INITIALLY DEFERRED markings of the constraints and triggers of leaf partitions. This led to unexpected behavior of such constraints. After updating to this version, any misbehaving partitioned tables can be fixed by executing a new ALTER command to set the desired properties.
This change also disallows applying such an ALTER directly to the constraints of leaf partitions. The only supported case is for the whole partitioning hierarchy to have identical constraint properties, so such ALTERs must be applied at the partition root.
When attaching a child table with ALTER TABLE ... INHERIT, insist that any generated columns in the parent be generated the same way in the child (Peter Eisentraut) §
Forbid marking an identity column as nullable (Vik Fearing) §
\nGENERATED ... AS IDENTITY implies NOT NULL, so don't allow it to be combined with an explicit NULL specification.
Allow ALTER ROLE/DATABASE ... SET to set the role, session_authorization, and temp_buffers parameters (Tom Lane) §
Previously, over-eager validity checks might reject these commands, even if the values would have worked when used later. This created a command ordering hazard for dump/reload and upgrade scenarios.
", "text": "Allow ALTER ROLE/DATABASE ... SET to set the role, session_authorization, and temp_buffers parameters (Tom Lane) § Previously, over-eager validity checks might reject these commands, even if the values would have worked when used later. This created a command ordering hazard for dump/reload and upgrade scenarios.", "title": "Allow ALTER ROLE/DATABASE ... SET to set the role, session_authorization, and temp_buffers parameters", "commits": ["c39aa1e87"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "006f05675827f428a7f67385acf06385d1de0549877af4bccafa3a43a7548656", "section_path": ["Changes"], "commit_groups": [["041f4efd2", "46b6635b7", "69d5ca484", "a7fcb6285", "c39aa1e87", "c7f0275fb"]], "identity_text": "Allow ALTER ROLE/DATABASE ... SET to set the role, session_authorization, and temp_buffers parameters (Tom Lane) Previously, over-eager validity checks might reject these commands, even if the values would have worked when used later. This created a command ordering hazard for dump/reload and upgrade scenarios.", "commit_aliases": ["041f4efd2", "46b6635b7", "69d5ca484", "a7fcb6285", "c39aa1e87", "c7f0275fb"], "source_commits": ["c39aa1e87"], "source_entry_id": "13.3/changes/007", "db_id": "d0451410730607800b5df7d2e7948715", "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3", "relations": [{"rule": 2, "type": "equivalent", "target": "043ff6cd519d8bec7a87d4f43ead62c5", "evidence": {"same_day": true, "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3"}}, {"rule": 2, "type": "equivalent", "target": "c3314c5d1c83f2209c3e6d3b60ed537c", "evidence": {"same_day": true, "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3"}}, {"rule": 2, "type": "equivalent", "target": "d86c969ac905b3cd2d03d2be6b46b1ae", "evidence": {"same_day": true, "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3"}}, {"rule": 2, "type": "equivalent", "target": "e97862062ce0ecf8f4295eda9e69b3e7", "evidence": {"same_day": true, "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3"}}], "version": "13.3", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "e97862062ce0ecf8f4295eda9e69b3e7", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Allow ALTER ROLE/DATABASE ... SET to set the role, session_authorization, and temp_buffers parameters", "evidence": {"same_day": true, "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3"}, "url": "/docs/compare/?release=12.7#12.7-5aef3b1587010883", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "d86c969ac905b3cd2d03d2be6b46b1ae", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Allow ALTER ROLE/DATABASE ... SET to set the role, session_authorization, and temp_buffers parameters", "evidence": {"same_day": true, "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3"}, "url": "/docs/compare/?release=11.12#11.12-5a2f143c8a31c92a", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "c3314c5d1c83f2209c3e6d3b60ed537c", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Allow ALTER ROLE/DATABASE ... SET to set the role, session_authorization, and temp_buffers parameters", "evidence": {"same_day": true, "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3"}, "url": "/docs/compare/?release=10.17#10.17-5a2f143c8a31c92a", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "043ff6cd519d8bec7a87d4f43ead62c5", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "Allow ALTER ROLE/DATABASE ... SET to set the role, session_authorization, and temp_buffers parameters", "evidence": {"same_day": true, "patch_ids": ["8ae2e83a5d291ced86d998b1ab7eee63"], "statement_hash": "b7f97fb8d75c806f24e4d3e965f7f5ca6fdcac93de0c9165a1ef89a5462795e3"}, "url": "/docs/compare/?release=9.6.22#9.6.22-5a2f143c8a31c92a", "source_url": "/docs/release/9.6.22/#AEN132280"}]}, {"id": "13.3-8c7c04a7d6b85c90", "cves": [], "html": "Ensure that REINDEX CONCURRENTLY preserves any statistics target that's been set for the index (Michael Paquier) § §
Fix COMMIT AND CHAIN to work correctly when the current transaction has live savepoints (Fujii Masao) §
Fix list-manipulation bug in WITH RECURSIVE processing (Michael Paquier, Tom Lane) §
Sufficiently deep nesting of WITH constructs (at least seven levels) triggered core dumps or incorrect complaints of faulty WITH nesting.
Fix bug with coercing the result of a COLLATE expression to a non-collatable type (Tom Lane) §
This led to a parse tree in which the COLLATE appears to be applied to a non-collatable value. While that normally has no real impact (since COLLATE has no effect at runtime), it was possible to construct views that would be rejected during dump/reload.
Fix use-after-free bug in saving tuples for AFTER triggers (Amit Langote) §
This could cause crashes in some situations.
", "text": "Fix use-after-free bug in saving tuples for AFTER triggers (Amit Langote) § This could cause crashes in some situations.", "title": "Fix use-after-free bug in saving tuples for AFTER triggers", "commits": ["2688852a4"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "722664df1ccb4101acef309588490a49540fb97ecf5f05078c4d14941cc35d08", "section_path": ["Changes"], "commit_groups": [["25936fd46", "262eb990c", "2688852a4"]], "identity_text": "Fix use-after-free bug in saving tuples for AFTER triggers (Amit Langote) This could cause crashes in some situations.", "commit_aliases": ["25936fd46", "262eb990c", "2688852a4"], "source_commits": ["2688852a4"], "source_entry_id": "13.3/changes/012", "db_id": "eeae21700f5b61c6da643158de541e80", "patch_ids": ["e930f83e6b676948d8ec23e440ef2b9e"], "statement_hash": "f33c46d06cc94392cd131fc9113ad371a29406aa2dc86176de4c7c7a9926cadb", "relations": [{"rule": 2, "type": "equivalent", "target": "815a9207b62cee7f514d44a006b40da3", "evidence": {"same_day": true, "patch_ids": ["e930f83e6b676948d8ec23e440ef2b9e"], "statement_hash": "f33c46d06cc94392cd131fc9113ad371a29406aa2dc86176de4c7c7a9926cadb"}}], "version": "13.3", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "815a9207b62cee7f514d44a006b40da3", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Fix use-after-free bug in saving tuples for AFTER triggers", "evidence": {"same_day": true, "patch_ids": ["e930f83e6b676948d8ec23e440ef2b9e"], "statement_hash": "f33c46d06cc94392cd131fc9113ad371a29406aa2dc86176de4c7c7a9926cadb"}, "url": "/docs/compare/?release=12.7#12.7-f726eb3230fd1762", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}]}, {"id": "13.3-073a4739a4f40fc4", "cves": [], "html": "Disallow calling window functions and procedures via the “fast path” wire protocol message (Tom Lane) §
\nOnly plain functions are supported here. While trying to call an aggregate function failed already, calling a window function would crash, and calling a procedure would work only if the procedure did no transaction control.
", "text": "Disallow calling window functions and procedures via the “fast path” wire protocol message (Tom Lane) § Only plain functions are supported here. While trying to call an aggregate function failed already, calling a window function would crash, and calling a procedure would work only if the procedure did no transaction control.", "title": "Disallow calling window functions and procedures via the “fast path” wire protocol message", "commits": ["4d225ba0e"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "c85dd1fe945e08a5554a43485649c87db233481e0586e7d0aafdcfa85fe50b8e", "section_path": ["Changes"], "commit_groups": [["0627f3630", "2efcd502e", "4d225ba0e", "73bad52a9", "89768ee69", "ebc2ff076"]], "identity_text": "Disallow calling window functions and procedures via the fast path wire protocol message (Tom Lane) Only plain functions are supported here. While trying to call an aggregate function failed already, calling a window function would crash, and calling a procedure would work only if the procedure did no transaction control.", "commit_aliases": ["0627f3630", "2efcd502e", "4d225ba0e", "73bad52a9", "89768ee69", "ebc2ff076"], "source_commits": ["4d225ba0e"], "source_entry_id": "13.3/changes/013", "db_id": "7778f3a32b2fa6ab9761805a1e3b4fba", "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1", "relations": [{"rule": 2, "type": "equivalent", "target": "03906a7c8653f859466c2026e48f63c6", "evidence": {"same_day": true, "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1"}}, {"rule": 2, "type": "equivalent", "target": "1b8f2a45a9d2e935788f99131bc2b253", "evidence": {"same_day": true, "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1"}}, {"rule": 2, "type": "equivalent", "target": "dea30517e2656d30b3618508113e7285", "evidence": {"same_day": true, "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1"}}, {"rule": 2, "type": "equivalent", "target": "e8af7a374034d509284f19f6cc78df61", "evidence": {"same_day": true, "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1"}}], "version": "13.3", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "03906a7c8653f859466c2026e48f63c6", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Disallow calling window functions and procedures via the “fast path” wire protocol message", "evidence": {"same_day": true, "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1"}, "url": "/docs/compare/?release=12.7#12.7-06b0536ea0d66ab4", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "dea30517e2656d30b3618508113e7285", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Disallow calling window functions and procedures via the “fast path” wire protocol message", "evidence": {"same_day": true, "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1"}, "url": "/docs/compare/?release=11.12#11.12-531f0c10b0a71a00", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "e8af7a374034d509284f19f6cc78df61", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Disallow calling window functions and procedures via the “fast path” wire protocol message", "evidence": {"same_day": true, "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1"}, "url": "/docs/compare/?release=10.17#10.17-531f0c10b0a71a00", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "1b8f2a45a9d2e935788f99131bc2b253", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "Disallow calling window functions and procedures via the \"fast path\" wire protocol message", "evidence": {"same_day": true, "patch_ids": ["667c9c9431f60d4a73a55e73368d7b0b"], "statement_hash": "34f948486de4d5d1f8593252025399f5242d545d3707015a511b6f7f873b0ca1"}, "url": "/docs/compare/?release=9.6.22#9.6.22-7207ba54cd66831d", "source_url": "/docs/release/9.6.22/#AEN132280"}]}, {"id": "13.3-288208cef0a2f9c4", "cves": [], "html": "Extend pg_identify_object_as_address() to support event triggers (Joel Jacobson) § §
Fix to_char()'s handling of Roman-numeral month format codes with negative intervals (Julien Rouhaud) §
Previously, such cases would usually cause a crash.
", "text": "Fix to_char()'s handling of Roman-numeral month format codes with negative intervals (Julien Rouhaud) § Previously, such cases would usually cause a crash.", "title": "Fix to_char()'s handling of Roman-numeral month format codes with negative intervals", "commits": ["be79debd9"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "ea1820ed800712f7d815a37c07c040e9d660088fa14e1dde8d2cc6e76fbb5fa4", "section_path": ["Changes"], "commit_groups": [["1cc110f68", "5656f2c3d", "6540322fa", "7a3972597", "82dd5706e", "be79debd9"]], "identity_text": "Fix to_char()'s handling of Roman-numeral month format codes with negative intervals (Julien Rouhaud) Previously, such cases would usually cause a crash.", "commit_aliases": ["1cc110f68", "5656f2c3d", "6540322fa", "7a3972597", "82dd5706e", "be79debd9"], "source_commits": ["be79debd9"], "source_entry_id": "13.3/changes/015", "db_id": "b7c10db782f367caba5ef19f3462459b", "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5", "relations": [{"rule": 2, "type": "equivalent", "target": "0a104851ab53b64998bf762315515496", "evidence": {"same_day": true, "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5"}}, {"rule": 2, "type": "equivalent", "target": "40cc08f45f115d84fadcd5703140f2f9", "evidence": {"same_day": true, "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5"}}, {"rule": 2, "type": "equivalent", "target": "9f5b7d05c6c1db76a9ca6065f9203b1a", "evidence": {"same_day": true, "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5"}}, {"rule": 2, "type": "equivalent", "target": "bd638f861b8f78c34f8208fab8338b52", "evidence": {"same_day": true, "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5"}}], "version": "13.3", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "bd638f861b8f78c34f8208fab8338b52", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Fix to_char()'s handling of Roman-numeral month format codes with negative intervals", "evidence": {"same_day": true, "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5"}, "url": "/docs/compare/?release=12.7#12.7-9d059568c66a3ba9", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "0a104851ab53b64998bf762315515496", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Fix to_char()'s handling of Roman-numeral month format codes with negative intervals", "evidence": {"same_day": true, "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5"}, "url": "/docs/compare/?release=11.12#11.12-4b8845d92b257d0a", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "40cc08f45f115d84fadcd5703140f2f9", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Fix to_char()'s handling of Roman-numeral month format codes with negative intervals", "evidence": {"same_day": true, "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5"}, "url": "/docs/compare/?release=10.17#10.17-4b8845d92b257d0a", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "9f5b7d05c6c1db76a9ca6065f9203b1a", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "Fix to_char()'s handling of Roman-numeral month format codes with negative intervals", "evidence": {"same_day": true, "patch_ids": ["7319000da5c8ae3f6b56ed68a4ee9dfa"], "statement_hash": "34e9a02c4aed166a4f2a8c97b0027c7ddda88f0bdc5d0a9f1e296dc78abc4ac5"}, "url": "/docs/compare/?release=9.6.22#9.6.22-4b8845d92b257d0a", "source_url": "/docs/release/9.6.22/#AEN132280"}]}, {"id": "13.3-7a4f40e4d3e3b444", "cves": [], "html": "Check that the argument of pg_import_system_collations() is a valid schema OID (Tom Lane) §
Fix use of uninitialized value while parsing an \\{ quantifier in a BRE-mode regular expression (Tom Lane) §m,n\\}
This error could cause the quantifier to act non-greedy, that is behave like an { quantifier would do in full regular expressions.m,n}?
Fix “could not find pathkey item to sort” planner errors in some situations where the sort key involves an aggregate or window function (James Coleman, Tom Lane) §
", "text": "Fix “could not find pathkey item to sort” planner errors in some situations where the sort key involves an aggregate or window function (James Coleman, Tom Lane) §", "title": "Fix “could not find pathkey item to sort” planner errors in some situations where the sort key involves an aggregate or window function", "commits": ["7bfba4f19"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "8bf317a522de5d1c824552a8e01e28b5cf529d06a3ab250882010112473f8658", "section_path": ["Changes"], "commit_groups": [["375398244", "7bfba4f19"]], "identity_text": "Fix could not find pathkey item to sort planner errors in some situations where the sort key involves an aggregate or window function (James Coleman, Tom Lane)", "commit_aliases": ["375398244", "7bfba4f19"], "source_commits": ["7bfba4f19"], "source_entry_id": "13.3/changes/018", "db_id": "b49655c38a59f0207df3e8cc8acba579", "patch_ids": ["e93c98efeec9552cf59199c181e969dd"], "statement_hash": "3f7e3564a071852f2b91d38084437abb3dd6a2710967920a2f92ee2a8fc3c575", "relations": [], "version": "13.3", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.3-c6e3802017718bb5", "cves": [], "html": "Don't ignore system columns when estimating the number of groups using extended statistics (Tomas Vondra) §
\nThis led to strange estimates for queries such as SELECT ... GROUP BY a, b, ctid.
Avoid divide-by-zero when estimating selectivity of a regular expression with a very long fixed prefix (Tom Lane) §
\nThis typically led to a NaN selectivity value, causing assertion failures or strange planner behavior.
Fix access-off-the-end-of-the-table error in BRIN index bitmap scans (Tomas Vondra) §
\nIf the page range size used by a BRIN index isn't a power of two, there were corner cases in which a bitmap scan could try to fetch pages past the actual end of the table, leading to “could not open file” errors.
", "text": "Fix access-off-the-end-of-the-table error in BRIN index bitmap scans (Tomas Vondra) § If the page range size used by a BRIN index isn't a power of two, there were corner cases in which a bitmap scan could try to fetch pages past the actual end of the table, leading to “could not open file” errors.", "title": "Fix access-off-the-end-of-the-table error in BRIN index bitmap scans", "commits": ["1aad1d181"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "0df4d1ef140dd76a4453faf05f21c38365d1406402ec0790a8d21c6d69b8a38e", "section_path": ["Changes"], "commit_groups": [["1aad1d181", "23607a815", "7d3a53461", "847612fda", "df97ee6ea", "e4f251be7"]], "identity_text": "Fix access-off-the-end-of-the-table error in BRIN index bitmap scans (Tomas Vondra) If the page range size used by a BRIN index isn't a power of two, there were corner cases in which a bitmap scan could try to fetch pages past the actual end of the table, leading to could not open file errors.", "commit_aliases": ["1aad1d181", "23607a815", "7d3a53461", "847612fda", "df97ee6ea", "e4f251be7"], "source_commits": ["1aad1d181"], "source_entry_id": "13.3/changes/021", "db_id": "61cbd7bfd3778343419ff4ea7ee70db1", "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606", "relations": [{"rule": 2, "type": "equivalent", "target": "a4a6211a7ccfce246a599ca2b95e1de9", "evidence": {"same_day": true, "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606"}}, {"rule": 2, "type": "equivalent", "target": "c5ed0e21fd32ad21603f4a15525170ee", "evidence": {"same_day": true, "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606"}}, {"rule": 2, "type": "equivalent", "target": "e4e4a8f913f2b8037c0c5747e48b0878", "evidence": {"same_day": true, "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606"}}, {"rule": 2, "type": "equivalent", "target": "fb32cff9c207c98871de91e331df5e47", "evidence": {"same_day": true, "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606"}}], "version": "13.3", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c5ed0e21fd32ad21603f4a15525170ee", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Fix access-off-the-end-of-the-table error in BRIN index bitmap scans", "evidence": {"same_day": true, "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606"}, "url": "/docs/compare/?release=12.7#12.7-9c1de227cc83156d", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "fb32cff9c207c98871de91e331df5e47", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Fix access-off-the-end-of-the-table error in BRIN index bitmap scans", "evidence": {"same_day": true, "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606"}, "url": "/docs/compare/?release=11.12#11.12-e1597b2a6f448b03", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "e4e4a8f913f2b8037c0c5747e48b0878", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Fix access-off-the-end-of-the-table error in BRIN index bitmap scans", "evidence": {"same_day": true, "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606"}, "url": "/docs/compare/?release=10.17#10.17-e1597b2a6f448b03", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "a4a6211a7ccfce246a599ca2b95e1de9", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "Fix access-off-the-end-of-the-table error in BRIN index bitmap scans", "evidence": {"same_day": true, "patch_ids": ["72b2c31661fd706661cb3df775127374"], "statement_hash": "9e7f4417857aca44e2394c35eef35625f6564172330efaf56c21706cb6229606"}, "url": "/docs/compare/?release=9.6.22#9.6.22-e1597b2a6f448b03", "source_url": "/docs/release/9.6.22/#AEN132280"}]}, {"id": "13.3-9251898da0d1b553", "cves": [], "html": "Fix potentially wrong answers from GIN tsvector index searches, when there are many matching tuples (Tom Lane) §
If the number of index matches became large enough to make the bitmap holding them become lossy (a threshold that depends on work_mem), the code could get confused about whether rechecks are required, allowing rows to be returned that don't actually match the query.
Fix concurrency issues with WAL segment recycling on Windows (Michael Paquier) §
\nThis reverts a change that caused intermittent “could not rename file ...: Permission denied” log messages. While there were not serious consequences, the log spam was annoying.
", "text": "Fix concurrency issues with WAL segment recycling on Windows (Michael Paquier) § This reverts a change that caused intermittent “could not rename file ...: Permission denied” log messages. While there were not serious consequences, the log spam was annoying.", "title": "Fix concurrency issues with WAL segment recycling on Windows", "commits": ["78c24e97d"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "3f11741fec566b31c1e1a886eeaf47767b7386c6052d821ccdb475e3a23b586f", "section_path": ["Changes"], "commit_groups": [["78c24e97d", "909b449e0"]], "identity_text": "Fix concurrency issues with WAL segment recycling on Windows (Michael Paquier) This reverts a change that caused intermittent could not rename file ...: Permission denied log messages. While there were not serious consequences, the log spam was annoying.", "commit_aliases": ["78c24e97d", "909b449e0"], "source_commits": ["78c24e97d"], "source_entry_id": "13.3/changes/023", "db_id": "e3696fd317ce4bc9ff6a769590e7570c", "patch_ids": ["fdedf35533a04515edb485e4577b9415"], "statement_hash": "b831103671db89a17330e56f5e424ce0d9f36f17e0c7f0d94cb64a0df06b8333", "relations": [], "version": "13.3", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.3-6caafe2c96cb71d0", "cves": [], "html": "Avoid incorrect timeline change while recovering uncommitted two-phase transactions from WAL (Soumyadeep Chakraborty, Jimmy Yih, Kevin Yeap) §
\nThis error could lead to subsequent WAL records being written under the wrong timeline ID, leading to consistency problems, or even complete failure to be able to restart the server, later on.
", "text": "Avoid incorrect timeline change while recovering uncommitted two-phase transactions from WAL (Soumyadeep Chakraborty, Jimmy Yih, Kevin Yeap) § This error could lead to subsequent WAL records being written under the wrong timeline ID, leading to consistency problems, or even complete failure to be able to restart the server, later on.", "title": "Avoid incorrect timeline change while recovering uncommitted two-phase transactions from WAL", "commits": ["6e5ce888a"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "0dff2217c3987d21388e7652b47b81091b1808bd6b85a47525ab8bf033756f8b", "section_path": ["Changes"], "commit_groups": [["1ec7162a8", "4b1dd9b1e", "595b9cba2", "6e5ce888a", "f1d550f18"]], "identity_text": "Avoid incorrect timeline change while recovering uncommitted two-phase transactions from WAL (Soumyadeep Chakraborty, Jimmy Yih, Kevin Yeap) This error could lead to subsequent WAL records being written under the wrong timeline ID, leading to consistency problems, or even complete failure to be able to restart the server, later on.", "commit_aliases": ["1ec7162a8", "4b1dd9b1e", "595b9cba2", "6e5ce888a", "f1d550f18"], "source_commits": ["6e5ce888a"], "source_entry_id": "13.3/changes/024", "db_id": "1b01f5f8148ce71942c1add860ebade0", "patch_ids": ["8555ef9033c6fdc9c3cf59ee6c6e74df"], "statement_hash": "386f25212cfbae5a11373c68371721dad1668575c47e26c81bd24bad4a00ce61", "relations": [{"rule": 2, "type": "equivalent", "target": "23f21299dd74193efff4e9202ddcda7d", "evidence": {"same_day": true, "patch_ids": ["8555ef9033c6fdc9c3cf59ee6c6e74df"], "statement_hash": "386f25212cfbae5a11373c68371721dad1668575c47e26c81bd24bad4a00ce61"}}, {"rule": 2, "type": "equivalent", "target": "eed0155770501dc8aeec531a7935e994", "evidence": {"same_day": true, "patch_ids": ["8555ef9033c6fdc9c3cf59ee6c6e74df"], "statement_hash": "386f25212cfbae5a11373c68371721dad1668575c47e26c81bd24bad4a00ce61"}}, {"rule": 2, "type": "equivalent", "target": "eed68915dba63eb3adcf429dd51b0809", "evidence": {"same_day": true, "patch_ids": ["8555ef9033c6fdc9c3cf59ee6c6e74df"], "statement_hash": "386f25212cfbae5a11373c68371721dad1668575c47e26c81bd24bad4a00ce61"}}], "version": "13.3", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "23f21299dd74193efff4e9202ddcda7d", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Avoid incorrect timeline change while recovering uncommitted two-phase transactions from WAL", "evidence": {"same_day": true, "patch_ids": ["8555ef9033c6fdc9c3cf59ee6c6e74df"], "statement_hash": "386f25212cfbae5a11373c68371721dad1668575c47e26c81bd24bad4a00ce61"}, "url": "/docs/compare/?release=12.7#12.7-1405be4ff510fdd0", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "eed68915dba63eb3adcf429dd51b0809", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Avoid incorrect timeline change while recovering uncommitted two-phase transactions from WAL", "evidence": {"same_day": true, "patch_ids": ["8555ef9033c6fdc9c3cf59ee6c6e74df"], "statement_hash": "386f25212cfbae5a11373c68371721dad1668575c47e26c81bd24bad4a00ce61"}, "url": "/docs/compare/?release=11.12#11.12-72db98433f014df8", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "eed0155770501dc8aeec531a7935e994", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Avoid incorrect timeline change while recovering uncommitted two-phase transactions from WAL", "evidence": {"same_day": true, "patch_ids": ["8555ef9033c6fdc9c3cf59ee6c6e74df"], "statement_hash": "386f25212cfbae5a11373c68371721dad1668575c47e26c81bd24bad4a00ce61"}, "url": "/docs/compare/?release=10.17#10.17-72db98433f014df8", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}]}, {"id": "13.3-09ab65777a171b7b", "cves": [], "html": "Ensure that locks are released while shutting down a standby server's startup process (Fujii Masao) §
\nWhen a standby server is shut down while still in recovery, some locks might be left held. This causes assertion failures in debug builds; it's unclear whether any serious consequence could occur in production builds.
", "text": "Ensure that locks are released while shutting down a standby server's startup process (Fujii Masao) § When a standby server is shut down while still in recovery, some locks might be left held. This causes assertion failures in debug builds; it's unclear whether any serious consequence could occur in production builds.", "title": "Ensure that locks are released while shutting down a standby server's startup process", "commits": ["e7bcfd717"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "8d8ca4a6de7ce4197e9ed3372dd86d4d2ecf52b6fbc08fcff527e568999535b6", "section_path": ["Changes"], "commit_groups": [["ad8b67492", "b59d3abaf", "b9cf9d7d3", "dd5b7e486", "e3bf96216", "e7bcfd717"]], "identity_text": "Ensure that locks are released while shutting down a standby server's startup process (Fujii Masao) When a standby server is shut down while still in recovery, some locks might be left held. This causes assertion failures in debug builds; it's unclear whether any serious consequence could occur in production builds.", "commit_aliases": ["ad8b67492", "b59d3abaf", "b9cf9d7d3", "dd5b7e486", "e3bf96216", "e7bcfd717"], "source_commits": ["e7bcfd717"], "source_entry_id": "13.3/changes/025", "db_id": "238c45b77c57b6ea46d88aee7653f60d", "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69", "relations": [{"rule": 2, "type": "equivalent", "target": "062b13769fd19e7beae52070c5a9e124", "evidence": {"same_day": true, "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69"}}, {"rule": 2, "type": "equivalent", "target": "073e827b10f6b1fc2d24b6b821f12348", "evidence": {"same_day": true, "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69"}}, {"rule": 2, "type": "equivalent", "target": "492876ca41b4c6bb5cff16a8c4788a61", "evidence": {"same_day": true, "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69"}}, {"rule": 2, "type": "equivalent", "target": "59acb9b03dd39c719f32a8eb23740b16", "evidence": {"same_day": true, "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69"}}], "version": "13.3", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "062b13769fd19e7beae52070c5a9e124", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Ensure that locks are released while shutting down a standby server's startup process", "evidence": {"same_day": true, "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69"}, "url": "/docs/compare/?release=12.7#12.7-ef3ade4b27c85a8b", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "492876ca41b4c6bb5cff16a8c4788a61", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Ensure that locks are released while shutting down a standby server's startup process", "evidence": {"same_day": true, "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69"}, "url": "/docs/compare/?release=11.12#11.12-f6d1724b83d2eb41", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "073e827b10f6b1fc2d24b6b821f12348", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Ensure that locks are released while shutting down a standby server's startup process", "evidence": {"same_day": true, "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69"}, "url": "/docs/compare/?release=10.17#10.17-f6d1724b83d2eb41", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "59acb9b03dd39c719f32a8eb23740b16", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "Ensure that locks are released while shutting down a standby server's startup process", "evidence": {"same_day": true, "patch_ids": ["133e532eeccc0cc0c1dd923f12b6c641"], "statement_hash": "df944c25880b38b9d6fed732f3099aca9cab9c0039cda7d6cec750cdb324fe69"}, "url": "/docs/compare/?release=9.6.22#9.6.22-f6d1724b83d2eb41", "source_url": "/docs/release/9.6.22/#AEN132280"}]}, {"id": "13.3-13b20c07e29ebfea", "cves": [], "html": "Fix crash when a logical replication worker does ALTER SUBSCRIPTION REFRESH (Peter Smith) §
The core code won't do this, but a replica trigger could.
", "text": "Fix crash when a logical replication worker does ALTER SUBSCRIPTION REFRESH (Peter Smith) § The core code won't do this, but a replica trigger could.", "title": "Fix crash when a logical replication worker does ALTER SUBSCRIPTION REFRESH", "commits": ["ef70b6f8e"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "e71a7818d809d7cd4504e5965e2abff6985cb9642fcc7edf236f3e4cc11a7377", "section_path": ["Changes"], "commit_groups": [["1803c7626", "4e8c0f1a0", "b40865ebd", "cfebc7080", "ef70b6f8e"]], "identity_text": "Fix crash when a logical replication worker does ALTER SUBSCRIPTION REFRESH (Peter Smith) The core code won't do this, but a replica trigger could.", "commit_aliases": ["1803c7626", "4e8c0f1a0", "b40865ebd", "cfebc7080", "ef70b6f8e"], "source_commits": ["ef70b6f8e"], "source_entry_id": "13.3/changes/026", "db_id": "0b57d686a4ccc9f24c5695fea460e4ec", "patch_ids": ["5a941a8e7785fcb6b12a3da522327a3d"], "statement_hash": "37d8dee6e5d2a40652f93803b47f5a7fae267a539707ad8d21172d6e3641da34", "relations": [{"rule": 2, "type": "equivalent", "target": "6fc3fe3ce8f06ff2ddc579dbcf9988a0", "evidence": {"same_day": true, "patch_ids": ["5a941a8e7785fcb6b12a3da522327a3d"], "statement_hash": "37d8dee6e5d2a40652f93803b47f5a7fae267a539707ad8d21172d6e3641da34"}}, {"rule": 2, "type": "equivalent", "target": "70738891bf9bb064baf7c8f329c0017f", "evidence": {"same_day": true, "patch_ids": ["5a941a8e7785fcb6b12a3da522327a3d"], "statement_hash": "37d8dee6e5d2a40652f93803b47f5a7fae267a539707ad8d21172d6e3641da34"}}, {"rule": 2, "type": "equivalent", "target": "ee7a35f7ec2fcc509c503e21c1539f2b", "evidence": {"same_day": true, "patch_ids": ["5a941a8e7785fcb6b12a3da522327a3d"], "statement_hash": "37d8dee6e5d2a40652f93803b47f5a7fae267a539707ad8d21172d6e3641da34"}}], "version": "13.3", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "6fc3fe3ce8f06ff2ddc579dbcf9988a0", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Fix crash when a logical replication worker does ALTER SUBSCRIPTION REFRESH", "evidence": {"same_day": true, "patch_ids": ["5a941a8e7785fcb6b12a3da522327a3d"], "statement_hash": "37d8dee6e5d2a40652f93803b47f5a7fae267a539707ad8d21172d6e3641da34"}, "url": "/docs/compare/?release=12.7#12.7-8b8cac53fef14fc8", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "ee7a35f7ec2fcc509c503e21c1539f2b", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Fix crash when a logical replication worker does ALTER SUBSCRIPTION REFRESH", "evidence": {"same_day": true, "patch_ids": ["5a941a8e7785fcb6b12a3da522327a3d"], "statement_hash": "37d8dee6e5d2a40652f93803b47f5a7fae267a539707ad8d21172d6e3641da34"}, "url": "/docs/compare/?release=11.12#11.12-8a33fb05029517a6", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "70738891bf9bb064baf7c8f329c0017f", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Fix crash when a logical replication worker does ALTER SUBSCRIPTION REFRESH", "evidence": {"same_day": true, "patch_ids": ["5a941a8e7785fcb6b12a3da522327a3d"], "statement_hash": "37d8dee6e5d2a40652f93803b47f5a7fae267a539707ad8d21172d6e3641da34"}, "url": "/docs/compare/?release=10.17#10.17-8a33fb05029517a6", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}]}, {"id": "13.3-8adb86c3113e8360", "cves": [], "html": "Ensure we default to wal_sync_method = fdatasync on recent FreeBSD (Thomas Munro) §
FreeBSD 13 supports open_datasync, which would normally become the default choice. However, it's unclear whether that is actually an improvement for Postgres, so preserve the existing default for now.
Disable the vacuum_cleanup_index_scale_factor parameter and storage option (Peter Geoghegan) § §
The notion of tracking “stale” index statistics proved to interact badly with the autovacuum_vacuum_insert_threshold parameter, resulting in unnecessary full-index scans and consequent degradation of autovacuum performance. The latter mechanism seems superior, so remove the stale-statistics logic. The control parameter for that, vacuum_cleanup_index_scale_factor, will be removed entirely in v14. In v13, it remains present to avoid breaking existing configuration files, but it no longer does anything.
Pass the correct trigger OID to object post-alter hooks during ALTER CONSTRAINT (Álvaro Herrera) §
When updating trigger properties during ALTER CONSTRAINT, the post-alter hook was told that we are updating a trigger, but the constraint's OID was passed instead of the trigger's.
Ensure we finish cleaning up when interrupted while detaching a DSM segment (Thomas Munro) §
\nThis error could result in temporary files not being cleaned up promptly after a parallel query.
", "text": "Ensure we finish cleaning up when interrupted while detaching a DSM segment (Thomas Munro) § This error could result in temporary files not being cleaned up promptly after a parallel query.", "title": "Ensure we finish cleaning up when interrupted while detaching a DSM segment", "commits": ["9fe40913c"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "1036c058b36ec0e7a3345849dd08eadd82dff6fcf9964723342013d99b23df33", "section_path": ["Changes"], "commit_groups": [["4b426f77c", "637668fb1", "840eda04e", "8a07e5bd8", "9fe40913c", "acafdd9ed"]], "identity_text": "Ensure we finish cleaning up when interrupted while detaching a DSM segment (Thomas Munro) This error could result in temporary files not being cleaned up promptly after a parallel query.", "commit_aliases": ["4b426f77c", "637668fb1", "840eda04e", "8a07e5bd8", "9fe40913c", "acafdd9ed"], "source_commits": ["9fe40913c"], "source_entry_id": "13.3/changes/030", "db_id": "d5d8252f9e52aa7f57a975f98746773e", "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc", "relations": [{"rule": 2, "type": "equivalent", "target": "39df208538fedc0bf3f262ba010b8933", "evidence": {"same_day": true, "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc"}}, {"rule": 2, "type": "equivalent", "target": "869cfb32e5b7b396c6b448739c9e20e2", "evidence": {"same_day": true, "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc"}}, {"rule": 2, "type": "equivalent", "target": "a2d067a132fbaf87a1e15613cfce2e0a", "evidence": {"same_day": true, "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc"}}, {"rule": 2, "type": "equivalent", "target": "e8c49727adfe23a3d9c02af29c178ab7", "evidence": {"same_day": true, "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc"}}], "version": "13.3", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "869cfb32e5b7b396c6b448739c9e20e2", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Ensure we finish cleaning up when interrupted while detaching a DSM segment", "evidence": {"same_day": true, "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc"}, "url": "/docs/compare/?release=12.7#12.7-9c8c5cc0a75b8ce2", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "a2d067a132fbaf87a1e15613cfce2e0a", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Ensure we finish cleaning up when interrupted while detaching a DSM segment", "evidence": {"same_day": true, "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc"}, "url": "/docs/compare/?release=11.12#11.12-7ca45f963b79b4e5", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "e8c49727adfe23a3d9c02af29c178ab7", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Ensure we finish cleaning up when interrupted while detaching a DSM segment", "evidence": {"same_day": true, "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc"}, "url": "/docs/compare/?release=10.17#10.17-7ca45f963b79b4e5", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "39df208538fedc0bf3f262ba010b8933", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "Ensure we finish cleaning up when interrupted while detaching a DSM segment", "evidence": {"same_day": true, "patch_ids": ["36ee67e9328b5f869d9e433419a6fd69"], "statement_hash": "71484cd6ce3dcccc079a86baf0a067d7e3284adf9afa30e9031048ecc2f610cc"}, "url": "/docs/compare/?release=9.6.22#9.6.22-7ca45f963b79b4e5", "source_url": "/docs/release/9.6.22/#AEN132280"}]}, {"id": "13.3-a60ee9865585f428", "cves": [], "html": "Fix assorted minor memory leaks in the server (Tom Lane, Andres Freund) § § § § § § §
", "text": "Fix assorted minor memory leaks in the server (Tom Lane, Andres Freund) § § § § § § §", "title": "Fix assorted minor memory leaks in the server", "commits": ["12354839e", "4b41f6923", "4d072bf2a", "536836970", "642b0b69b", "ea3989f34", "eba939551"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "cfd32cce1cd4ffaf88e4e296ad5e5a0018826d977c7ec551b86afcb59962a908", "section_path": ["Changes"], "commit_groups": [["099d2914f", "09e961929", "0b618ddf8", "92bc14a10", "d303849b0", "eba939551"], ["12354839e", "20f11ca0d", "4eca51d44", "9bacdf9f5", "ba986b7bc"], ["1452a0bb8", "415ffdc22", "ea3989f34"], ["26a3ae06d", "377b7a830", "5058e95a6", "642b0b69b", "7e2521770", "fc552f868"], ["28644fac1", "2bed650c4", "536836970", "967b693ea", "fbcc9fe33"], ["2f31414f4", "4b41f6923", "8c830148d", "ad6c19066", "e835e89a0"], ["4b12ab18c", "4d072bf2a", "6e3475556", "7ce7f2b79", "a2764d87d"]], "identity_text": "Fix assorted minor memory leaks in the server (Tom Lane, Andres Freund)", "commit_aliases": ["099d2914f", "09e961929", "0b618ddf8", "12354839e", "1452a0bb8", "20f11ca0d", "26a3ae06d", "28644fac1", "2bed650c4", "2f31414f4", "377b7a830", "415ffdc22", "4b12ab18c", "4b41f6923", "4d072bf2a", "4eca51d44", "5058e95a6", "536836970", "642b0b69b", "6e3475556", "7ce7f2b79", "7e2521770", "8c830148d", "92bc14a10", "967b693ea", "9bacdf9f5", "a2764d87d", "ad6c19066", "ba986b7bc", "d303849b0", "e835e89a0", "ea3989f34", "eba939551", "fbcc9fe33", "fc552f868"], "source_commits": ["12354839e", "4b41f6923", "4d072bf2a", "536836970", "642b0b69b", "ea3989f34", "eba939551"], "source_entry_id": "13.3/changes/031", "db_id": "47dd699457eb55393cedc2f4d22772ff", "patch_ids": ["00affaa59345fbfc31fc140f0b8b3faf", "02d53f0753f5babe8ee15a810765bf8e", "705ad3cfbd61ca546a36c96b0f8b79cb", "8e19f457a6c06d813e4fcd3e511e6652", "ad1f46fa8c991709164fb41cba57eb1d", "ef57775f040bdd51593eb3d9b31a1536", "f6d43276fc5d2c0d3cfc030158c970cf"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c", "relations": [{"rule": 2, "type": "equivalent", "target": "0b77a332a701d12618a8679c0ffa81bb", "evidence": {"same_day": true, "patch_ids": ["00affaa59345fbfc31fc140f0b8b3faf", "02d53f0753f5babe8ee15a810765bf8e", "705ad3cfbd61ca546a36c96b0f8b79cb", "8e19f457a6c06d813e4fcd3e511e6652", "ad1f46fa8c991709164fb41cba57eb1d", "ef57775f040bdd51593eb3d9b31a1536", "f6d43276fc5d2c0d3cfc030158c970cf"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c"}}, {"rule": 2, "type": "equivalent", "target": "1678dd9c9a9003a7d56ad21c3c3e2f3b", "evidence": {"same_day": true, "patch_ids": ["00affaa59345fbfc31fc140f0b8b3faf", "02d53f0753f5babe8ee15a810765bf8e", "705ad3cfbd61ca546a36c96b0f8b79cb", "8e19f457a6c06d813e4fcd3e511e6652", "ad1f46fa8c991709164fb41cba57eb1d", "ef57775f040bdd51593eb3d9b31a1536", "f6d43276fc5d2c0d3cfc030158c970cf"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c"}}, {"rule": 2, "type": "related", "target": "a7a165b7be91c9d1539502d4e43cb9a3", "evidence": {"same_day": true, "patch_ids": ["8e19f457a6c06d813e4fcd3e511e6652", "ef57775f040bdd51593eb3d9b31a1536"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c"}}, {"rule": 2, "type": "equivalent", "target": "f3d455c6804ccf0ec8d47e1b31d304ff", "evidence": {"same_day": true, "patch_ids": ["00affaa59345fbfc31fc140f0b8b3faf", "02d53f0753f5babe8ee15a810765bf8e", "705ad3cfbd61ca546a36c96b0f8b79cb", "8e19f457a6c06d813e4fcd3e511e6652", "ad1f46fa8c991709164fb41cba57eb1d", "ef57775f040bdd51593eb3d9b31a1536", "f6d43276fc5d2c0d3cfc030158c970cf"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c"}}], "version": "13.3", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "f3d455c6804ccf0ec8d47e1b31d304ff", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Fix assorted minor memory leaks in the server", "evidence": {"same_day": true, "patch_ids": ["00affaa59345fbfc31fc140f0b8b3faf", "02d53f0753f5babe8ee15a810765bf8e", "705ad3cfbd61ca546a36c96b0f8b79cb", "8e19f457a6c06d813e4fcd3e511e6652", "ad1f46fa8c991709164fb41cba57eb1d", "ef57775f040bdd51593eb3d9b31a1536", "f6d43276fc5d2c0d3cfc030158c970cf"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c"}, "url": "/docs/compare/?release=12.7#12.7-c0926c7d178ccdba", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "1678dd9c9a9003a7d56ad21c3c3e2f3b", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Fix assorted minor memory leaks in the server", "evidence": {"same_day": true, "patch_ids": ["00affaa59345fbfc31fc140f0b8b3faf", "02d53f0753f5babe8ee15a810765bf8e", "705ad3cfbd61ca546a36c96b0f8b79cb", "8e19f457a6c06d813e4fcd3e511e6652", "ad1f46fa8c991709164fb41cba57eb1d", "ef57775f040bdd51593eb3d9b31a1536", "f6d43276fc5d2c0d3cfc030158c970cf"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c"}, "url": "/docs/compare/?release=11.12#11.12-6d5875b18e073a24", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "0b77a332a701d12618a8679c0ffa81bb", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Fix assorted minor memory leaks in the server", "evidence": {"same_day": true, "patch_ids": ["00affaa59345fbfc31fc140f0b8b3faf", "02d53f0753f5babe8ee15a810765bf8e", "705ad3cfbd61ca546a36c96b0f8b79cb", "8e19f457a6c06d813e4fcd3e511e6652", "ad1f46fa8c991709164fb41cba57eb1d", "ef57775f040bdd51593eb3d9b31a1536", "f6d43276fc5d2c0d3cfc030158c970cf"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c"}, "url": "/docs/compare/?release=10.17#10.17-6d5875b18e073a24", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "a7a165b7be91c9d1539502d4e43cb9a3", "kind": "related", "version": "9.6.22", "label": "9.6.22", "title": "Fix assorted minor memory leaks in the server", "evidence": {"same_day": true, "patch_ids": ["8e19f457a6c06d813e4fcd3e511e6652", "ef57775f040bdd51593eb3d9b31a1536"], "statement_hash": "094a8ac0364fd9a6d0c65563febad094c830da53fa64add17406007d9c41640c"}, "url": "/docs/compare/?release=9.6.22#9.6.22-6d5875b18e073a24", "source_url": "/docs/release/9.6.22/#AEN132280"}]}, {"id": "13.3-eb425b76abadbb0f", "cves": [], "html": "Fix uninitialized variable in walreceiver's statistics in shared memory (Fujii Masao) §
\nThis error was harmless on most platforms, but could cause issues on platforms lacking atomic variables and/or spinlock support.
", "text": "Fix uninitialized variable in walreceiver's statistics in shared memory (Fujii Masao) § This error was harmless on most platforms, but could cause issues on platforms lacking atomic variables and/or spinlock support.", "title": "Fix uninitialized variable in walreceiver's statistics in shared memory", "commits": ["d4b667e93"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "6a491e7980b83030c0a86da0e80023b7ad4b28e97bfdc238be8bd9ff40d631fd", "section_path": ["Changes"], "commit_groups": [["614b7f18b", "d4b667e93"]], "identity_text": "Fix uninitialized variable in walreceiver's statistics in shared memory (Fujii Masao) This error was harmless on most platforms, but could cause issues on platforms lacking atomic variables and/or spinlock support.", "commit_aliases": ["614b7f18b", "d4b667e93"], "source_commits": ["d4b667e93"], "source_entry_id": "13.3/changes/032", "db_id": "4dfcfae8ab58d4a6ed350341b4896ed3", "patch_ids": ["16397dac7d384da807c481126fb5f4c6"], "statement_hash": "d0dcd960f9bf56c4da424a5288b1910d8bac1367aee448fbea24347991701a00", "relations": [], "version": "13.3", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.3-5f86528874f31d42", "cves": [], "html": "Reduce the overhead of dtrace probes for LWLock operations, when dtrace support is compiled in but not active (Peter Eisentraut) § §
", "text": "Reduce the overhead of dtrace probes for LWLock operations, when dtrace support is compiled in but not active (Peter Eisentraut) § §", "title": "Reduce the overhead of dtrace probes for LWLock operations, when dtrace support is compiled in but not active", "commits": ["0d204a4b0", "e48ce7ef0"], "section": "Changes", "category": "performance", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "b3b8e06dbe996c046302e241304b47594d06c3aaf72b913904394e7a1b857936", "section_path": ["Changes"], "commit_groups": [["0d204a4b0", "fa8fbadb9"], ["b94409a02", "e48ce7ef0"]], "identity_text": "Reduce the overhead of dtrace probes for LWLock operations, when dtrace support is compiled in but not active (Peter Eisentraut)", "commit_aliases": ["0d204a4b0", "b94409a02", "e48ce7ef0", "fa8fbadb9"], "source_commits": ["0d204a4b0", "e48ce7ef0"], "source_entry_id": "13.3/changes/033", "db_id": "5ad606177f6b9d17df2252e782823d28", "patch_ids": ["2175f03dd4c289ef956c8b75548c0bea", "9c1862a64d2cfe9ee8aee681067c641e"], "statement_hash": "11536147b13a028cb44878d094959c8476c32bc0fa857f04bd829bdc20e3c119", "relations": [], "version": "13.3", "category_label": "Performance", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.3-6cb8c6a49ab8caa0", "cves": [], "html": "Fix failure when a PL/pgSQL DO block makes use of both composite-type variables and transaction control (Tom Lane) §
Previously, such cases led to errors about leaked tuple descriptors.
", "text": "Fix failure when a PL/pgSQL DO block makes use of both composite-type variables and transaction control (Tom Lane) § Previously, such cases led to errors about leaked tuple descriptors.", "title": "Fix failure when a PL/pgSQL DO block makes use of both composite-type variables and transaction control", "commits": ["97b7ad468"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "757e82e7883f55c88a77936fdb357948ccc5540fc026e5d04f75f3b6abef37a6", "section_path": ["Changes"], "commit_groups": [["22f2a98cf", "6530df6c2", "97b7ad468", "c2db458c1"]], "identity_text": "Fix failure when a PL/pgSQL DO block makes use of both composite-type variables and transaction control (Tom Lane) Previously, such cases led to errors about leaked tuple descriptors.", "commit_aliases": ["22f2a98cf", "6530df6c2", "97b7ad468", "c2db458c1"], "source_commits": ["97b7ad468"], "source_entry_id": "13.3/changes/034", "db_id": "815af4f67c20802cb4925bf07f3cb9f2", "patch_ids": ["07335090719decc31badef76031fbe51"], "statement_hash": "a6e9b844dee0efcc894e9f14963c31f69fcd1064d2e3aba0cd8eecdde2b8f94e", "relations": [{"rule": 2, "type": "equivalent", "target": "06dd88a06d68630994b88beff68676c4", "evidence": {"same_day": true, "patch_ids": ["07335090719decc31badef76031fbe51"], "statement_hash": "a6e9b844dee0efcc894e9f14963c31f69fcd1064d2e3aba0cd8eecdde2b8f94e"}}, {"rule": 2, "type": "equivalent", "target": "f6dc76d2791f6e5d887ce9d9a043ef6e", "evidence": {"same_day": true, "patch_ids": ["07335090719decc31badef76031fbe51"], "statement_hash": "a6e9b844dee0efcc894e9f14963c31f69fcd1064d2e3aba0cd8eecdde2b8f94e"}}], "version": "13.3", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "f6dc76d2791f6e5d887ce9d9a043ef6e", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Fix failure when a PL/pgSQL DO block makes use of both composite-type variables and transaction control", "evidence": {"same_day": true, "patch_ids": ["07335090719decc31badef76031fbe51"], "statement_hash": "a6e9b844dee0efcc894e9f14963c31f69fcd1064d2e3aba0cd8eecdde2b8f94e"}, "url": "/docs/compare/?release=12.7#12.7-7444eb8ef76a8f49", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "06dd88a06d68630994b88beff68676c4", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Fix failure when a PL/pgSQL DO block makes use of both composite-type variables and transaction control", "evidence": {"same_day": true, "patch_ids": ["07335090719decc31badef76031fbe51"], "statement_hash": "a6e9b844dee0efcc894e9f14963c31f69fcd1064d2e3aba0cd8eecdde2b8f94e"}, "url": "/docs/compare/?release=11.12#11.12-a0b3e077da6306c4", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}]}, {"id": "13.3-d1b3e4574f126458", "cves": [], "html": "Prevent infinite loop in libpq if a ParameterDescription message with a corrupt length is received (Tom Lane) §
", "text": "Prevent infinite loop in libpq if a ParameterDescription message with a corrupt length is received (Tom Lane) §", "title": "Prevent infinite loop in libpq if a ParameterDescription message with a corrupt length is received", "commits": ["3580b4a0c"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "ae095282170d25677c2c1ff6cbfd0187f644e3af0bfbba8176a0474b9f7595bd", "section_path": ["Changes"], "commit_groups": [["3580b4a0c", "51c54bb60", "56defbdd0", "a98e53e10", "d2be6cdc5", "d3a557894"]], "identity_text": "Prevent infinite loop in libpq if a ParameterDescription message with a corrupt length is received (Tom Lane)", "commit_aliases": ["3580b4a0c", "51c54bb60", "56defbdd0", "a98e53e10", "d2be6cdc5", "d3a557894"], "source_commits": ["3580b4a0c"], "source_entry_id": "13.3/changes/035", "db_id": "46eef7218cafa404380daee2f63d31a0", "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287", "relations": [{"rule": 2, "type": "equivalent", "target": "20962137519d9b459e46e1ca576e6fec", "evidence": {"same_day": true, "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287"}}, {"rule": 2, "type": "equivalent", "target": "546f4a726fe3405762281da3367c949f", "evidence": {"same_day": true, "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287"}}, {"rule": 2, "type": "equivalent", "target": "cc3057e47b0e74abc43def86be80e4e8", "evidence": {"same_day": true, "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287"}}, {"rule": 2, "type": "equivalent", "target": "e0aaeb46fa67ca300769b7f407099603", "evidence": {"same_day": true, "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287"}}], "version": "13.3", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "546f4a726fe3405762281da3367c949f", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Prevent infinite loop in libpq if a ParameterDescription message with a corrupt length is received", "evidence": {"same_day": true, "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287"}, "url": "/docs/compare/?release=12.7#12.7-eec70e869190c282", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "e0aaeb46fa67ca300769b7f407099603", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Prevent infinite loop in libpq if a ParameterDescription message with a corrupt length is received", "evidence": {"same_day": true, "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287"}, "url": "/docs/compare/?release=11.12#11.12-493402d58e7e5cca", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "20962137519d9b459e46e1ca576e6fec", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Prevent infinite loop in libpq if a ParameterDescription message with a corrupt length is received", "evidence": {"same_day": true, "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287"}, "url": "/docs/compare/?release=10.17#10.17-493402d58e7e5cca", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "cc3057e47b0e74abc43def86be80e4e8", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "Prevent infinite loop in libpq if a ParameterDescription message with a corrupt length is received", "evidence": {"same_day": true, "patch_ids": ["e631b5efa78409f5018308a9f0603cc9"], "statement_hash": "d98e127ac7c9582f7c3856848e252c82ad536cbefe55f76fecd51f3e526a7287"}, "url": "/docs/compare/?release=9.6.22#9.6.22-493402d58e7e5cca", "source_url": "/docs/release/9.6.22/#AEN132280"}]}, {"id": "13.3-c3c388e0c2cee9ba", "cves": [], "html": "When initdb prints instructions about how to start the server, make the path shown for pg_ctl use backslash separators on Windows (Nitin Jadhav) §
", "text": "When initdb prints instructions about how to start the server, make the path shown for pg_ctl use backslash separators on Windows (Nitin Jadhav) §", "title": "When initdb prints instructions about how to start the server, make the path shown for pg_ctl use backslash separators on Windows", "commits": ["b52fd1e7c"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "bb26fc7660d735c43eac8a32864b9a5b827516a5e628cbc6179620e88b9e9d97", "section_path": ["Changes"], "commit_groups": [["75dbfe4ca", "926139dd0", "ae1c1d84e", "b52fd1e7c", "f92776791"]], "identity_text": "When initdb prints instructions about how to start the server, make the path shown for pg_ctl use backslash separators on Windows (Nitin Jadhav)", "commit_aliases": ["75dbfe4ca", "926139dd0", "ae1c1d84e", "b52fd1e7c", "f92776791"], "source_commits": ["b52fd1e7c"], "source_entry_id": "13.3/changes/036", "db_id": "ef96f3983ff07fbbec86298e689af748", "patch_ids": ["bd3100c6d9e187efb22c6c3a3630f4c6"], "statement_hash": "55f1cb3d6ba21a0f26227ade766559412f5666507b4235a5a6b2d886966290aa", "relations": [{"rule": 2, "type": "equivalent", "target": "978606246e68f045876e9a51bf1047d6", "evidence": {"same_day": true, "patch_ids": ["bd3100c6d9e187efb22c6c3a3630f4c6"], "statement_hash": "55f1cb3d6ba21a0f26227ade766559412f5666507b4235a5a6b2d886966290aa"}}, {"rule": 2, "type": "equivalent", "target": "c92d15a5b66a70b4adf3b3810d8dc87f", "evidence": {"same_day": true, "patch_ids": ["bd3100c6d9e187efb22c6c3a3630f4c6"], "statement_hash": "55f1cb3d6ba21a0f26227ade766559412f5666507b4235a5a6b2d886966290aa"}}, {"rule": 2, "type": "equivalent", "target": "e4e524dcabec6d412314a19b53e7894f", "evidence": {"same_day": true, "patch_ids": ["bd3100c6d9e187efb22c6c3a3630f4c6"], "statement_hash": "55f1cb3d6ba21a0f26227ade766559412f5666507b4235a5a6b2d886966290aa"}}], "version": "13.3", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "c92d15a5b66a70b4adf3b3810d8dc87f", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "When initdb prints instructions about how to start the server, make the path shown for pg_ctl use backslash separators on Windows", "evidence": {"same_day": true, "patch_ids": ["bd3100c6d9e187efb22c6c3a3630f4c6"], "statement_hash": "55f1cb3d6ba21a0f26227ade766559412f5666507b4235a5a6b2d886966290aa"}, "url": "/docs/compare/?release=12.7#12.7-f7f208d1cc9ef825", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "e4e524dcabec6d412314a19b53e7894f", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "When initdb prints instructions about how to start the server, make the path shown for pg_ctl use backslash separators on Windows", "evidence": {"same_day": true, "patch_ids": ["bd3100c6d9e187efb22c6c3a3630f4c6"], "statement_hash": "55f1cb3d6ba21a0f26227ade766559412f5666507b4235a5a6b2d886966290aa"}, "url": "/docs/compare/?release=11.12#11.12-845a702d5d8384ba", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "978606246e68f045876e9a51bf1047d6", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "When initdb prints instructions about how to start the server, make the path shown for pg_ctl use backslash separators on Windows", "evidence": {"same_day": true, "patch_ids": ["bd3100c6d9e187efb22c6c3a3630f4c6"], "statement_hash": "55f1cb3d6ba21a0f26227ade766559412f5666507b4235a5a6b2d886966290aa"}, "url": "/docs/compare/?release=10.17#10.17-845a702d5d8384ba", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}]}, {"id": "13.3-846e4f14cd80f245", "cves": [], "html": "Fix psql to restore the previous behavior of \\connect service= (Tom Lane) §something
A previous bug fix caused environment variables (such as PGPORT) to override entries in the service file in this context. Restore the previous behavior, in which the priority is the other way around.
Fix psql's ON_ERROR_ROLLBACK feature to handle COMMIT AND CHAIN commands correctly (Arthur Nascimento) §
Previously, this case failed with “savepoint \"pg_psql_temporary_savepoint\" does not exist”.
", "text": "Fix psql's ON_ERROR_ROLLBACK feature to handle COMMIT AND CHAIN commands correctly (Arthur Nascimento) § Previously, this case failed with “savepoint \"pg_psql_temporary_savepoint\" does not exist”.", "title": "Fix psql's ON_ERROR_ROLLBACK feature to handle COMMIT AND CHAIN commands correctly", "commits": ["be7485a1e"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "4261d5d9120eaa86bd7830b6e9dab3c748beed1214ffc9484fb0328e28bc598e", "section_path": ["Changes"], "commit_groups": [["67b3ee292", "be7485a1e", "fe06819f1"]], "identity_text": "Fix psql's ON_ERROR_ROLLBACK feature to handle COMMIT AND CHAIN commands correctly (Arthur Nascimento) Previously, this case failed with savepoint \"pg_psql_temporary_savepoint\" does not exist.", "commit_aliases": ["67b3ee292", "be7485a1e", "fe06819f1"], "source_commits": ["be7485a1e"], "source_entry_id": "13.3/changes/038", "db_id": "ba0102e30ddaddf1298eeed83e300e0c", "patch_ids": ["9c951d59b5ab2de56affd68fc6279f77"], "statement_hash": "9347ba15375638d7580d2e1d533c21c7882ff7e35ba05d7e0af0a685359ae502", "relations": [{"rule": 2, "type": "equivalent", "target": "a604a24fcdfd08328f9e35d6b7ad0289", "evidence": {"same_day": true, "patch_ids": ["9c951d59b5ab2de56affd68fc6279f77"], "statement_hash": "9347ba15375638d7580d2e1d533c21c7882ff7e35ba05d7e0af0a685359ae502"}}], "version": "13.3", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "a604a24fcdfd08328f9e35d6b7ad0289", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Fix psql's ON_ERROR_ROLLBACK feature to handle COMMIT AND CHAIN commands correctly", "evidence": {"same_day": true, "patch_ids": ["9c951d59b5ab2de56affd68fc6279f77"], "statement_hash": "9347ba15375638d7580d2e1d533c21c7882ff7e35ba05d7e0af0a685359ae502"}, "url": "/docs/compare/?release=12.7#12.7-125607d63501710b", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}]}, {"id": "13.3-ca8436d9586f9a88", "cves": [], "html": "In psql, avoid repeated “could not print result table” failures after the first such error (Álvaro Herrera) §
", "text": "In psql, avoid repeated “could not print result table” failures after the first such error (Álvaro Herrera) §", "title": "In psql, avoid repeated “could not print result table” failures after the first such error", "commits": ["f50dc2c72"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "acb9b2294fe2e2cf995a1d939c5faab5341daf309ae5a3b52c56420a1abbd7f0", "section_path": ["Changes"], "commit_groups": [["8d645a116", "f50dc2c72"]], "identity_text": "In psql, avoid repeated could not print result table failures after the first such error (Álvaro Herrera)", "commit_aliases": ["8d645a116", "f50dc2c72"], "source_commits": ["f50dc2c72"], "source_entry_id": "13.3/changes/039", "db_id": "9b04900aa416ab9eabadcf87d05ebe8e", "patch_ids": ["bc74b6fc382b184418d7f04dd8c2b4e9"], "statement_hash": "f1cc807ab416bdd22f6b1ed2a7b1a9ebca63dce700200d43665f747fd16cb763", "relations": [], "version": "13.3", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "13.3-57ede42ce642fa9a", "cves": [], "html": "Fix race condition in detection of file modification by psql's \\e and related commands (Laurenz Albe) §
A very fast typist could fool the code's file-timestamp-based detection of whether the temporary edit file was changed.
", "text": "Fix race condition in detection of file modification by psql's \\e and related commands (Laurenz Albe) § A very fast typist could fool the code's file-timestamp-based detection of whether the temporary edit file was changed.", "title": "Fix race condition in detection of file modification by psql's \\e and related commands", "commits": ["6ed059933"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "a58532f66a923cebe356236199d11036aa1faa797e61294a522134c7d48e8940", "section_path": ["Changes"], "commit_groups": [["33aa7d13d", "48d67fd89", "60e5c2b14", "6ed059933", "8915e7906", "a42c4438b"]], "identity_text": "Fix race condition in detection of file modification by psql's \\e and related commands (Laurenz Albe) A very fast typist could fool the code's file-timestamp-based detection of whether the temporary edit file was changed.", "commit_aliases": ["33aa7d13d", "48d67fd89", "60e5c2b14", "6ed059933", "8915e7906", "a42c4438b"], "source_commits": ["6ed059933"], "source_entry_id": "13.3/changes/040", "db_id": "9490d94d24adfc3753c23708e68ea756", "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433", "relations": [{"rule": 2, "type": "equivalent", "target": "629ec2f506257dac0541d0eb5f2df930", "evidence": {"same_day": true, "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433"}}, {"rule": 2, "type": "equivalent", "target": "789d0f31913e4825828aee505607146c", "evidence": {"same_day": true, "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433"}}, {"rule": 2, "type": "equivalent", "target": "a5b781e82406d8ec8e6110705c010700", "evidence": {"same_day": true, "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433"}}, {"rule": 2, "type": "equivalent", "target": "a97d6f6fa8cb0ec9888093363fd3bc91", "evidence": {"same_day": true, "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433"}}], "version": "13.3", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "a5b781e82406d8ec8e6110705c010700", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Fix race condition in detection of file modification by psql's \\e and related commands", "evidence": {"same_day": true, "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433"}, "url": "/docs/compare/?release=12.7#12.7-cc0b940141de7ebc", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "629ec2f506257dac0541d0eb5f2df930", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Fix race condition in detection of file modification by psql's \\e and related commands", "evidence": {"same_day": true, "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433"}, "url": "/docs/compare/?release=11.12#11.12-239b78c18beb55ea", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "789d0f31913e4825828aee505607146c", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Fix race condition in detection of file modification by psql's \\e and related commands", "evidence": {"same_day": true, "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433"}, "url": "/docs/compare/?release=10.17#10.17-239b78c18beb55ea", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "a97d6f6fa8cb0ec9888093363fd3bc91", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "Fix race condition in detection of file modification by psql's \\e and related commands", "evidence": {"same_day": true, "patch_ids": ["f1f2c42ed62775746fe26cc6baea91ff"], "statement_hash": "42d0c5c02ba2f856da532d2bbc9e8f9252a72c515c98c7ce7bb10187fd2dd433"}, "url": "/docs/compare/?release=9.6.22#9.6.22-239b78c18beb55ea", "source_url": "/docs/release/9.6.22/#AEN132280"}]}, {"id": "13.3-9dc3e8b14435c2da", "cves": [], "html": "Fix pg_dump's dumping of generated columns in partitioned tables (Peter Eisentraut) §
\nA fix introduced in the previous minor release should not be applied to partitioned tables, only traditionally-inherited tables.
", "text": "Fix pg_dump's dumping of generated columns in partitioned tables (Peter Eisentraut) § A fix introduced in the previous minor release should not be applied to partitioned tables, only traditionally-inherited tables.", "title": "Fix pg_dump's dumping of generated columns in partitioned tables", "commits": ["a6a3a274a"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "86c94bf8f8333c947f77d09faffbf044a1e915944ba274c87b5be6af9014a09b", "section_path": ["Changes"], "commit_groups": [["a6a3a274a", "bdaa0d2d7", "feb270d10"]], "identity_text": "Fix pg_dump's dumping of generated columns in partitioned tables (Peter Eisentraut) A fix introduced in the previous minor release should not be applied to partitioned tables, only traditionally-inherited tables.", "commit_aliases": ["a6a3a274a", "bdaa0d2d7", "feb270d10"], "source_commits": ["a6a3a274a"], "source_entry_id": "13.3/changes/041", "db_id": "1c6c0e97646846b873245ebc8f35cf6d", "patch_ids": ["d4768d7523874d6ec712498db061d2e4"], "statement_hash": "be201fe8e3427dde6b4b8e921b33cc47691d3bdecb873bd49c810db9d6f10db9", "relations": [{"rule": 2, "type": "equivalent", "target": "2575d6865024d36485ba52d9e2641094", "evidence": {"same_day": true, "patch_ids": ["d4768d7523874d6ec712498db061d2e4"], "statement_hash": "be201fe8e3427dde6b4b8e921b33cc47691d3bdecb873bd49c810db9d6f10db9"}}], "version": "13.3", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2575d6865024d36485ba52d9e2641094", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Fix pg_dump's dumping of generated columns in partitioned tables", "evidence": {"same_day": true, "patch_ids": ["d4768d7523874d6ec712498db061d2e4"], "statement_hash": "be201fe8e3427dde6b4b8e921b33cc47691d3bdecb873bd49c810db9d6f10db9"}, "url": "/docs/compare/?release=12.7#12.7-d4f5550c0d6b4e1a", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}]}, {"id": "13.3-130f7a85d04342ce", "cves": [], "html": "Fix missed file version check in pg_restore (Tom Lane) §
\nWhen reading a custom-format archive from a non-seekable source, pg_restore neglected to check the archive version. If it was fed a newer archive version than it can support, it would fail messily later on.
", "text": "Fix missed file version check in pg_restore (Tom Lane) § When reading a custom-format archive from a non-seekable source, pg_restore neglected to check the archive version. If it was fed a newer archive version than it can support, it would fail messily later on.", "title": "Fix missed file version check in pg_restore", "commits": ["35421a470"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "7b7abe973e403f2dec683b2721933578b9f0f31d79589cdb878988d8a75f7b0d", "section_path": ["Changes"], "commit_groups": [["1b6961c8f", "25fe401d5", "2c9b857af", "35421a470", "84c5e0dd2", "ec03f2df1"]], "identity_text": "Fix missed file version check in pg_restore (Tom Lane) When reading a custom-format archive from a non-seekable source, pg_restore neglected to check the archive version. If it was fed a newer archive version than it can support, it would fail messily later on.", "commit_aliases": ["1b6961c8f", "25fe401d5", "2c9b857af", "35421a470", "84c5e0dd2", "ec03f2df1"], "source_commits": ["35421a470"], "source_entry_id": "13.3/changes/042", "db_id": "66907a60b4852950edf387af36c10dbb", "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9", "relations": [{"rule": 2, "type": "equivalent", "target": "715fd254bd8a4717c986721fdf71070d", "evidence": {"same_day": true, "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9"}}, {"rule": 2, "type": "equivalent", "target": "a7163c4d0c78c39be674cefac9a50abc", "evidence": {"same_day": true, "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9"}}, {"rule": 2, "type": "equivalent", "target": "bf10eb31ef22649341d965fb9d13d2cc", "evidence": {"same_day": true, "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9"}}, {"rule": 2, "type": "equivalent", "target": "f9160e6dc2769150fb108fe831bb2531", "evidence": {"same_day": true, "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9"}}], "version": "13.3", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "f9160e6dc2769150fb108fe831bb2531", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Fix missed file version check in pg_restore", "evidence": {"same_day": true, "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9"}, "url": "/docs/compare/?release=12.7#12.7-215f5c04452b2f36", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "bf10eb31ef22649341d965fb9d13d2cc", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Fix missed file version check in pg_restore", "evidence": {"same_day": true, "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9"}, "url": "/docs/compare/?release=11.12#11.12-49e3e94032bb52a1", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "a7163c4d0c78c39be674cefac9a50abc", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Fix missed file version check in pg_restore", "evidence": {"same_day": true, "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9"}, "url": "/docs/compare/?release=10.17#10.17-49e3e94032bb52a1", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "715fd254bd8a4717c986721fdf71070d", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "Fix missed file version check in pg_restore", "evidence": {"same_day": true, "patch_ids": ["7e82d706ec05509f41bf6e5c2003df15"], "statement_hash": "30d3e9379809400f654c0a8f6ebf8190762357f8cce85f7ff85e913de51464b9"}, "url": "/docs/compare/?release=9.6.22#9.6.22-49e3e94032bb52a1", "source_url": "/docs/release/9.6.22/#AEN132280"}]}, {"id": "13.3-a1e79a1c9aa1137a", "cves": [], "html": "Add some more checks to pg_upgrade for user tables containing non-upgradable data types (Tom Lane) §
\nFix detection of some cases where a non-upgradable data type is embedded within a container type (such as an array or range). Also disallow upgrading when user tables contain columns of system-defined composite types, since those types' OIDs are not stable across versions.
", "text": "Add some more checks to pg_upgrade for user tables containing non-upgradable data types (Tom Lane) § Fix detection of some cases where a non-upgradable data type is embedded within a container type (such as an array or range). Also disallow upgrading when user tables contain columns of system-defined composite types, since those types' OIDs are not stable across versions.", "title": "Add some more checks to pg_upgrade for user tables containing non-upgradable data types", "commits": ["bbcfee0e5"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "1b7f7b5122e8b7bcfc712b400172e966540c59670f9d37f39e0bf159580dece1", "section_path": ["Changes"], "commit_groups": [["404946d40", "54a233071", "57c081de0", "ba86371b9", "bbcfee0e5", "d5722c927"]], "identity_text": "Add some more checks to pg_upgrade for user tables containing non-upgradable data types (Tom Lane) Fix detection of some cases where a non-upgradable data type is embedded within a container type (such as an array or range). Also disallow upgrading when user tables contain columns of system-defined composite types, since those types' OIDs are not stable across versions.", "commit_aliases": ["404946d40", "54a233071", "57c081de0", "ba86371b9", "bbcfee0e5", "d5722c927"], "source_commits": ["bbcfee0e5"], "source_entry_id": "13.3/changes/043", "db_id": "4a35a518c763a81d11486e7586282fdd", "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506", "relations": [{"rule": 2, "type": "equivalent", "target": "abc8e5d67ba0f03b572aa61fb16fa606", "evidence": {"same_day": true, "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506"}}, {"rule": 2, "type": "equivalent", "target": "b847847e95257ae080ca36d3c4db7c46", "evidence": {"same_day": true, "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506"}}, {"rule": 2, "type": "equivalent", "target": "bb329e3677e2f4a8187c163041b2467b", "evidence": {"same_day": true, "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506"}}, {"rule": 2, "type": "equivalent", "target": "bdd180e442b2457a080f8ede3edfb6cd", "evidence": {"same_day": true, "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506"}}], "version": "13.3", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "bdd180e442b2457a080f8ede3edfb6cd", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Add some more checks to pg_upgrade for user tables containing non-upgradable data types", "evidence": {"same_day": true, "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506"}, "url": "/docs/compare/?release=12.7#12.7-6fc52d428f2f81e1", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "bb329e3677e2f4a8187c163041b2467b", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Add some more checks to pg_upgrade for user tables containing non-upgradable data types", "evidence": {"same_day": true, "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506"}, "url": "/docs/compare/?release=11.12#11.12-35c9ddd9d42ee9ca", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "b847847e95257ae080ca36d3c4db7c46", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Add some more checks to pg_upgrade for user tables containing non-upgradable data types", "evidence": {"same_day": true, "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506"}, "url": "/docs/compare/?release=10.17#10.17-35c9ddd9d42ee9ca", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "abc8e5d67ba0f03b572aa61fb16fa606", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "Add some more checks to pg_upgrade for user tables containing non-upgradable data types", "evidence": {"same_day": true, "patch_ids": ["c890e278f33a1b7c3d576b02666e28af"], "statement_hash": "c5c1312b909085dfcbed2b85d264a298e20d86321a4f7cb883264aef8d03e506"}, "url": "/docs/compare/?release=9.6.22#9.6.22-35c9ddd9d42ee9ca", "source_url": "/docs/release/9.6.22/#AEN132280"}]}, {"id": "13.3-56211a9323cb831d", "cves": [], "html": "Fix incorrect progress-reporting calculation in pg_checksums (Shinya Kato) §
", "text": "Fix incorrect progress-reporting calculation in pg_checksums (Shinya Kato) §", "title": "Fix incorrect progress-reporting calculation in pg_checksums", "commits": ["104164361"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "e97e5e765664ca45ca6675831162ac866c0bedab24cabf46344462337cc427e1", "section_path": ["Changes"], "commit_groups": [["104164361", "24bcce3bd", "2eb1fc8b1"]], "identity_text": "Fix incorrect progress-reporting calculation in pg_checksums (Shinya Kato)", "commit_aliases": ["104164361", "24bcce3bd", "2eb1fc8b1"], "source_commits": ["104164361"], "source_entry_id": "13.3/changes/044", "db_id": "02b9ec1798ffc3c0418e8aba7016d5f8", "patch_ids": ["2d334b7b72c08943ee7ab7b49a2ba376"], "statement_hash": "2b80274fe47abd276817bf75acdfd9ff144eec623e8d892e49b56867f073834f", "relations": [{"rule": 2, "type": "equivalent", "target": "6273201352519e745fb31eb6211d2695", "evidence": {"same_day": true, "patch_ids": ["2d334b7b72c08943ee7ab7b49a2ba376"], "statement_hash": "2b80274fe47abd276817bf75acdfd9ff144eec623e8d892e49b56867f073834f"}}], "version": "13.3", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "6273201352519e745fb31eb6211d2695", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Fix incorrect progress-reporting calculation in pg_checksums", "evidence": {"same_day": true, "patch_ids": ["2d334b7b72c08943ee7ab7b49a2ba376"], "statement_hash": "2b80274fe47abd276817bf75acdfd9ff144eec623e8d892e49b56867f073834f"}, "url": "/docs/compare/?release=12.7#12.7-7a4ea0644dc4362c", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}]}, {"id": "13.3-650c9e32773ccb57", "cves": [], "html": "Fix pg_waldump to count XACT records correctly when generating per-record statistics (Kyotaro Horiguchi) §
Fix contrib/amcheck to not complain about the tuple flags HEAP_XMAX_LOCK_ONLY and HEAP_KEYS_UPDATED both being set (Julien Rouhaud) §
This is a valid state after SELECT FOR UPDATE.
Adjust VPATH build rules to support recent Oracle Developer Studio compiler versions (Noah Misch) §
", "text": "Adjust VPATH build rules to support recent Oracle Developer Studio compiler versions (Noah Misch) §", "title": "Adjust VPATH build rules to support recent Oracle Developer Studio compiler versions", "commits": ["13881199e"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "059ba252677d27dec2730a23671018c066ebb9453dd56c9c02a360756fbd55a5", "section_path": ["Changes"], "commit_groups": [["13881199e", "455dbc010", "4749c7ff4", "c8da16ba1", "f488d19f3", "fb9812b6c"]], "identity_text": "Adjust VPATH build rules to support recent Oracle Developer Studio compiler versions (Noah Misch)", "commit_aliases": ["13881199e", "455dbc010", "4749c7ff4", "c8da16ba1", "f488d19f3", "fb9812b6c"], "source_commits": ["13881199e"], "source_entry_id": "13.3/changes/047", "db_id": "5a1e2b32ba24f2105020cf405dee28aa", "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c", "relations": [{"rule": 2, "type": "equivalent", "target": "2431ed226eb3ece1ee012e119ee804d6", "evidence": {"same_day": true, "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c"}}, {"rule": 2, "type": "equivalent", "target": "67c6b59641c1e9a17f6bd874be7e694c", "evidence": {"same_day": true, "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c"}}, {"rule": 2, "type": "equivalent", "target": "77e1e3a9debc4e533cda64e3938174e2", "evidence": {"same_day": true, "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c"}}, {"rule": 2, "type": "equivalent", "target": "eb8154c18011d297b73acf6cd5836fa5", "evidence": {"same_day": true, "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c"}}], "version": "13.3", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "67c6b59641c1e9a17f6bd874be7e694c", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Adjust VPATH build rules to support recent Oracle Developer Studio compiler versions", "evidence": {"same_day": true, "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c"}, "url": "/docs/compare/?release=12.7#12.7-29df11f62dca7309", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "2431ed226eb3ece1ee012e119ee804d6", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Adjust VPATH build rules to support recent Oracle Developer Studio compiler versions", "evidence": {"same_day": true, "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c"}, "url": "/docs/compare/?release=11.12#11.12-da5cc852999bf2c1", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "77e1e3a9debc4e533cda64e3938174e2", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Adjust VPATH build rules to support recent Oracle Developer Studio compiler versions", "evidence": {"same_day": true, "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c"}, "url": "/docs/compare/?release=10.17#10.17-da5cc852999bf2c1", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "eb8154c18011d297b73acf6cd5836fa5", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "Adjust VPATH build rules to support recent Oracle Developer Studio compiler versions", "evidence": {"same_day": true, "patch_ids": ["27d590e27b4dcc514c6e09efc67cd898"], "statement_hash": "65954025781eb79b6d9db6bbf8a054c0bbfbb3855b258f5da4e82680abca0e9c"}, "url": "/docs/compare/?release=9.6.22#9.6.22-da5cc852999bf2c1", "source_url": "/docs/release/9.6.22/#AEN132280"}]}, {"id": "13.3-b1a59dd0a955e8eb", "cves": [], "html": "Fix testing of PL/Python for Python 3 on Solaris (Noah Misch) §
", "text": "Fix testing of PL/Python for Python 3 on Solaris (Noah Misch) §", "title": "Fix testing of PL/Python for Python 3 on Solaris", "commits": ["766c8fce5"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.3/#id-1.11.6.26.5", "source_hash": "a23eca3b33fe1e5b3f34d23f7a2f1ad3d441823f82790269f2accf67d482137e", "section_path": ["Changes"], "commit_groups": [["14652a19f", "4a3de4092", "72a9bd047", "766c8fce5", "c3556f6fa", "e3ac7d176"]], "identity_text": "Fix testing of PL/Python for Python 3 on Solaris (Noah Misch)", "commit_aliases": ["14652a19f", "4a3de4092", "72a9bd047", "766c8fce5", "c3556f6fa", "e3ac7d176"], "source_commits": ["766c8fce5"], "source_entry_id": "13.3/changes/048", "db_id": "b2d2752178e70fb98f83de3934d73d26", "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7", "relations": [{"rule": 2, "type": "equivalent", "target": "17dbeb20be5ddeb53681473f23bc4b25", "evidence": {"same_day": true, "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7"}}, {"rule": 2, "type": "equivalent", "target": "2344812cc386e14dd7dd54e4a4e882fe", "evidence": {"same_day": true, "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7"}}, {"rule": 2, "type": "equivalent", "target": "4f3f6954d89c0b65253f9600be8a9ec8", "evidence": {"same_day": true, "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7"}}, {"rule": 2, "type": "equivalent", "target": "a029a502265ccdbd46a66494d03d3a76", "evidence": {"same_day": true, "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7"}}], "version": "13.3", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4f3f6954d89c0b65253f9600be8a9ec8", "kind": "equivalent", "version": "12.7", "label": "12.7", "title": "Fix testing of PL/Python for Python 3 on Solaris", "evidence": {"same_day": true, "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7"}, "url": "/docs/compare/?release=12.7#12.7-676562672b5b8180", "source_url": "/docs/release/12.7/#id-1.11.6.21.5"}, {"db_id": "17dbeb20be5ddeb53681473f23bc4b25", "kind": "equivalent", "version": "11.12", "label": "11.12", "title": "Fix testing of PL/Python for Python 3 on Solaris", "evidence": {"same_day": true, "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7"}, "url": "/docs/compare/?release=11.12#11.12-aa98d04a63bae0ed", "source_url": "/docs/release/11.12/#id-1.11.6.15.5"}, {"db_id": "a029a502265ccdbd46a66494d03d3a76", "kind": "equivalent", "version": "10.17", "label": "10.17", "title": "Fix testing of PL/Python for Python 3 on Solaris", "evidence": {"same_day": true, "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7"}, "url": "/docs/compare/?release=10.17#10.17-aa98d04a63bae0ed", "source_url": "/docs/release/10.17/#id-1.11.6.11.5"}, {"db_id": "2344812cc386e14dd7dd54e4a4e882fe", "kind": "equivalent", "version": "9.6.22", "label": "9.6.22", "title": "Fix testing of PL/Python for Python 3 on Solaris", "evidence": {"same_day": true, "patch_ids": ["898933cc13535691a9f7159709882e71"], "statement_hash": "db875be06f10f73c6306bcdc30de080ff4b7a4ed322c869b57a5b7c71143a3c7"}, "url": "/docs/compare/?release=9.6.22#9.6.22-aa98d04a63bae0ed", "source_url": "/docs/release/9.6.22/#AEN132280"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 48}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 27}, {"key": "security", "label": "Security", "count": 3}, {"key": "performance", "label": "Performance", "count": 1}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 17}], "total": 48, "release_count": 1, "cross_major": false, "cve_count": 3, "cves": [{"id": "CVE-2021-32029", "url": "https://www.postgresql.org/support/security/CVE-2021-32029/", "fixed": {"11": "11.12", "12": "12.7", "13": "13.3"}, "score": 6.5, "title": "Fix possibly-incorrect computation of UPDATE ... RETURNING outputs for joined cross-partition updates", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N", "affected": {"11": "11", "12": "12", "13": "13"}, "component": "core server", "published": {"11": "2021-05-13", "12": "2021-05-13", "13": "2021-05-13"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Using an UPDATE ... RETURNING on a purpose-crafted partitioned table, an attacker can read arbitrary bytes of server memory. In the default configuration, any authenticated database user can create prerequisite objects and complete this attack at will. A user lacking the CREATE and TEMPORARY privileges on all databases and the CREATE privilege on all schemas typically cannot use this attack at will.\n\nThe PostgreSQL project thanks Tom Lane for reporting this problem.", "first_published": "2021-05-13", "fixed_version": "13.3"}, {"id": "CVE-2021-32028", "url": "https://www.postgresql.org/support/security/CVE-2021-32028/", "fixed": {"10": "10.17", "11": "11.12", "12": "12.7", "13": "13.3", "9.6": "9.6.22"}, "score": 6.5, "title": "Fix mishandling of “junk” columns in INSERT ... ON CONFLICT ... UPDATE target lists", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N", "affected": {"10": "10", "11": "11", "12": "12", "13": "13", "9.6": "9.6"}, "component": "core server", "published": {"10": "2021-05-13", "11": "2021-05-13", "12": "2021-05-13", "13": "2021-05-13", "9.6": "2021-05-13"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Using an INSERT ... ON CONFLICT ... DO UPDATE command on a purpose-crafted table, an attacker can read arbitrary bytes of server memory. In the default configuration, any authenticated database user can create prerequisite objects and complete this attack at will. A user lacking the CREATE and TEMPORARY privileges on all databases and the CREATE privilege on all schemas cannot use this attack at will.\n\nThe PostgreSQL project thanks Andres Freund for reporting this problem.", "first_published": "2021-05-13", "fixed_version": "13.3"}, {"id": "CVE-2021-32027", "url": "https://www.postgresql.org/support/security/CVE-2021-32027/", "fixed": {"10": "10.17", "11": "11.12", "12": "12.7", "13": "13.3", "9.6": "9.6.22"}, "score": 6.5, "title": "Prevent integer overflows in array subscripting calculations", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:H/A:N", "affected": {"10": "10", "11": "11", "12": "12", "13": "13", "9.6": "9.6"}, "component": "core server", "published": {"10": "2021-05-13", "11": "2021-05-13", "12": "2021-05-13", "13": "2021-05-13", "9.6": "2021-05-13"}, "introduced": {}, "cvss_version": "3.0", "description_en": "While modifying certain SQL array values, missing bounds checks let authenticated database users write arbitrary bytes to a wide area of server memory.\n\nThe PostgreSQL project thanks Tom Lane for reporting this problem.", "first_published": "2021-05-13", "fixed_version": "13.3"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 48, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}