A dump/restore is not required for those running 13.X.
\nHowever, if you have any GiST indexes on columns of type ltree (supplied by the contrib/ltree extension), you should re-index them after updating. See the second changelog entry below.
Also, if you are upgrading from a version earlier than 13.6, see Section E.18.
", "compatibility_count": 0, "label": "13.7", "status_label": "Historical", "eol": "2025-11-13", "age_days": 1601, "support_days": -320}, "groups": [{"date": "2022-05-12", "build": "13.7", "major": "13", "minor": 7, "manual": "13", "status": "stable", "doc_git": "", "version": "13.7", "eol_date": "2025-11-13", "date_text": "2022-05-12", "supported": false, "manual_url": "/docs/13/release-13-7.html", "source_url": "/docs/release/13.7/", "entry_count": 38, "placeholder": false, "content_hash": "0e0a098b30452e1aa7be3e30e4ad91ec5a4051f8c9a4e1ed1bfb5600194157c8", "manual_build": "13.23", "source_as_of": "", "changes_count": 38, "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 have any GiST indexes on columns of type ltree (supplied by the contrib/ltree extension), you should re-index them after updating. See the second changelog entry below.
Also, if you are upgrading from a version earlier than 13.6, see Section E.18.
", "compatibility_count": 0, "label": "13.7", "status_label": "Historical", "eol": "2025-11-13", "age_days": 1601, "support_days": -320, "entries": [{"id": "13.7-7c751a4817cbcd26", "cves": ["CVE-2022-1552"], "html": "Confine additional operations within “security restricted operation” sandboxes (Sergey Shinderuk, Noah Misch) § §
\nAutovacuum, CLUSTER, CREATE INDEX, REINDEX, REFRESH MATERIALIZED VIEW, and pg_amcheck activated the “security restricted operation” protection mechanism too late, or even not at all in some code paths. A user having permission to create non-temporary objects within a database could define an object that would execute arbitrary SQL code with superuser permissions the next time that autovacuum processed the object, or that some superuser ran one of the affected commands against it.
The PostgreSQL Project thanks Alexander Lakhin for reporting this problem. (CVE-2022-1552)
", "text": "Confine additional operations within “security restricted operation” sandboxes (Sergey Shinderuk, Noah Misch) § § Autovacuum, CLUSTER, CREATE INDEX, REINDEX, REFRESH MATERIALIZED VIEW, and pg_amcheck activated the “security restricted operation” protection mechanism too late, or even not at all in some code paths. A user having permission to create non-temporary objects within a database could define an object that would execute arbitrary SQL code with superuser permissions the next time that autovacuum processed the object, or that some superuser ran one of the affected commands against it. The PostgreSQL Project thanks Alexander Lakhin for reporting this problem. (CVE-2022-1552)", "title": "Confine additional operations within “security restricted operation” sandboxes", "commits": ["35edcc0ce", "88743d581"], "section": "Changes", "category": "security", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "1aa0adc0a851c1a535f91d23ad1da189a30bde807cec5d835169e10bb3a276bc", "section_path": ["Changes"], "commit_groups": [["0abc1a059", "34ff15660", "677a49478", "880511cb0", "88743d581", "f26d57028"], ["35edcc0ce", "48ca2904c", "7f098f7b5", "a117cebd6", "ab49ce7c3", "ef792f785"]], "identity_text": "Confine additional operations within security restricted operation sandboxes (Sergey Shinderuk, Noah Misch) Autovacuum, CLUSTER, CREATE INDEX, REINDEX, REFRESH MATERIALIZED VIEW, and pg_amcheck activated the security restricted operation protection mechanism too late, or even not at all in some code paths. A user having permission to create non-temporary objects within a database could define an object that would execute arbitrary SQL code with superuser permissions the next time that autovacuum processed the object, or that some superuser ran one of the affected commands against it. The PostgreSQL Project thanks Alexander Lakhin for reporting this problem. (CVE-2022-1552)", "commit_aliases": ["0abc1a059", "34ff15660", "35edcc0ce", "48ca2904c", "677a49478", "7f098f7b5", "880511cb0", "88743d581", "a117cebd6", "ab49ce7c3", "ef792f785", "f26d57028"], "source_commits": ["35edcc0ce", "88743d581"], "source_entry_id": "13.7/changes/001", "db_id": "a5b83ef3758e795df0c7a6b30e6a53c7", "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93", "relations": [{"rule": 2, "type": "equivalent", "target": "1ac54926400c94d0acb3b2bb0d1cb714", "evidence": {"same_day": true, "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93"}}, {"rule": 2, "type": "equivalent", "target": "670752f6faecb1221ddd1f4e1948ef86", "evidence": {"same_day": true, "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93"}}, {"rule": 2, "type": "equivalent", "target": "7c535db7e63d3466361dd5ae7cb611e7", "evidence": {"same_day": true, "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93"}}, {"rule": 2, "type": "equivalent", "target": "aae3e4d08f49bbe829bd6f85df92c72f", "evidence": {"same_day": true, "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93"}}], "version": "13.7", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "7c535db7e63d3466361dd5ae7cb611e7", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Confine additional operations within “security restricted operation” sandboxes", "evidence": {"same_day": true, "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93"}, "url": "/docs/compare/?release=14.3#14.3-a23393de94e369b8", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "aae3e4d08f49bbe829bd6f85df92c72f", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Confine additional operations within “security restricted operation” sandboxes", "evidence": {"same_day": true, "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93"}, "url": "/docs/compare/?release=12.11#12.11-3bd03835132773e3", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "670752f6faecb1221ddd1f4e1948ef86", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Confine additional operations within “security restricted operation” sandboxes", "evidence": {"same_day": true, "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93"}, "url": "/docs/compare/?release=11.16#11.16-be04a56eb411086e", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "1ac54926400c94d0acb3b2bb0d1cb714", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Confine additional operations within “security restricted operation” sandboxes", "evidence": {"same_day": true, "patch_ids": ["30beed43c541f07f5687c6a461848d9b", "89023da045b10033fa8ce30b0b27a2d9"], "statement_hash": "e96f9d058511f8acf5b59744b34caebec829f29fa7411d4c5b3636fdde9a5e93"}, "url": "/docs/compare/?release=10.21#10.21-be04a56eb411086e", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-df3c90fa3e053575", "cves": [], "html": "Fix default signature length for gist_ltree_ops indexes (Tomas Vondra, Alexander Korotkov) §
The default signature length (hash size) for GiST indexes on ltree columns was accidentally changed while upgrading that operator class to support operator class parameters. If any operations had been done on such an index without first upgrading the ltree extension to version 1.2, they were done assuming that the signature length was 28 bytes rather than the intended 8. This means it is very likely that such indexes are now corrupt. For safety we recommend re-indexing all GiST indexes on ltree columns after installing this update. (Note that GiST indexes on ltree[] columns, that is arrays of ltree, are not affected.)
Stop using query-provided column aliases for the columns of whole-row variables that refer to plain tables (Tom Lane) §
\nThe column names in tuples produced by a whole-row variable (such as tbl.* in contexts other than the top level of a SELECT list) are now always those of the associated named composite type, if there is one. We'd previously attempted to make them track any column aliases that had been applied to the FROM entry the variable refers to. But that's semantically dubious, because really then the output of the variable is not at all of the composite type it claims to be. Previous attempts to deal with that inconsistency had bad results up to and including storing unreadable data on disk, so just give up on the whole idea.
In cases where it's important to be able to relabel such columns, a workaround is to introduce an extra level of sub-SELECT, so that the whole-row variable is referring to the sub-SELECT's output and not to a plain table. Then the variable is of type record to begin with and there's no issue.
Fix incorrect output for types timestamptz and timetz in table_to_xmlschema() and allied functions (Renan Soares Lopes) §
The xmlschema output for these types included a malformed regular expression.
", "text": "Fix incorrect output for types timestamptz and timetz in table_to_xmlschema() and allied functions (Renan Soares Lopes) § The xmlschema output for these types included a malformed regular expression.", "title": "Fix incorrect output for types timestamptz and timetz in table_to_xmlschema() and allied functions", "commits": ["88ae77588"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "17b7faedc00af0fc44fb7924ddbbee27c174d3baf162e60caa890d4fbb329dc3", "section_path": ["Changes"], "commit_groups": [["068739fb4", "840729fd1", "84f3ecdaa", "88ae77588", "ae8ec7feb", "e6fd4a3da"]], "identity_text": "Fix incorrect output for types timestamptz and timetz in table_to_xmlschema() and allied functions (Renan Soares Lopes) The xmlschema output for these types included a malformed regular expression.", "commit_aliases": ["068739fb4", "840729fd1", "84f3ecdaa", "88ae77588", "ae8ec7feb", "e6fd4a3da"], "source_commits": ["88ae77588"], "source_entry_id": "13.7/changes/004", "db_id": "a13f3240245934b132260a24490e7277", "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766", "relations": [{"rule": 2, "type": "equivalent", "target": "8431c7c2370d34325416722917ede31c", "evidence": {"same_day": true, "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766"}}, {"rule": 2, "type": "equivalent", "target": "cc636bb0e6243df1c5f2fca898a67312", "evidence": {"same_day": true, "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766"}}, {"rule": 2, "type": "equivalent", "target": "d8f0644985f5ea7f13e738a7c833da64", "evidence": {"same_day": true, "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766"}}, {"rule": 2, "type": "equivalent", "target": "de93d3abf896b187c9efb28d02ee9afa", "evidence": {"same_day": true, "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766"}}], "version": "13.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "d8f0644985f5ea7f13e738a7c833da64", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Fix incorrect output for types timestamptz and timetz in table_to_xmlschema() and allied functions", "evidence": {"same_day": true, "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766"}, "url": "/docs/compare/?release=14.3#14.3-ddd5fbca25fa8477", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "cc636bb0e6243df1c5f2fca898a67312", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Fix incorrect output for types timestamptz and timetz in table_to_xmlschema() and allied functions", "evidence": {"same_day": true, "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766"}, "url": "/docs/compare/?release=12.11#12.11-a34ad631cde543a1", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "8431c7c2370d34325416722917ede31c", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Fix incorrect output for types timestamptz and timetz in table_to_xmlschema() and allied functions", "evidence": {"same_day": true, "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766"}, "url": "/docs/compare/?release=11.16#11.16-759b3ea171acc0a4", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "de93d3abf896b187c9efb28d02ee9afa", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Fix incorrect output for types timestamptz and timetz in table_to_xmlschema() and allied functions", "evidence": {"same_day": true, "patch_ids": ["ee3fa63ff0f53ff1e2df3d279ace5e53"], "statement_hash": "0b698a0060535155a18203271ac4d82a836a6e3b5b7f1b6c0110098f6882c766"}, "url": "/docs/compare/?release=10.21#10.21-759b3ea171acc0a4", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-a23dbadc1d425b27", "cves": [], "html": "Avoid core dump in parser for a VALUES clause with zero columns (Tom Lane) §
Fix planner errors for GROUPING() constructs that reference outer query levels (Richard Guo, Tom Lane) §
Fix plan generation for index-only scans on indexes with both returnable and non-returnable columns (Tom Lane) §
\nThe previous coding could try to read non-returnable columns in addition to the returnable ones. This was fairly harmless because it didn't actually do anything with the bogus values, but it fell foul of a recently-added error check that rejected such a plan.
", "text": "Fix plan generation for index-only scans on indexes with both returnable and non-returnable columns (Tom Lane) § The previous coding could try to read non-returnable columns in addition to the returnable ones. This was fairly harmless because it didn't actually do anything with the bogus values, but it fell foul of a recently-added error check that rejected such a plan.", "title": "Fix plan generation for index-only scans on indexes with both returnable and non-returnable columns", "commits": ["0778b24ce"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "2c577e67fc3d8de3a0a33e86310463177ac1c6853ccab93431abab0334fee3f8", "section_path": ["Changes"], "commit_groups": [["0778b24ce", "14ee565f3", "277e744ae", "32e801676", "b6f869bee", "e5691cc91"]], "identity_text": "Fix plan generation for index-only scans on indexes with both returnable and non-returnable columns (Tom Lane) The previous coding could try to read non-returnable columns in addition to the returnable ones. This was fairly harmless because it didn't actually do anything with the bogus values, but it fell foul of a recently-added error check that rejected such a plan.", "commit_aliases": ["0778b24ce", "14ee565f3", "277e744ae", "32e801676", "b6f869bee", "e5691cc91"], "source_commits": ["0778b24ce"], "source_entry_id": "13.7/changes/007", "db_id": "8706c720624356138c9ddaea3cb34215", "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372", "relations": [{"rule": 2, "type": "equivalent", "target": "1b0812852c836d4e66b06f7612514190", "evidence": {"same_day": true, "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372"}}, {"rule": 2, "type": "equivalent", "target": "27a8bf4c09c5ea2d76fb7f98c7ccd2b2", "evidence": {"same_day": true, "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372"}}, {"rule": 2, "type": "equivalent", "target": "4f83aeb5cff810bc4a104b3a0c9f2ac4", "evidence": {"same_day": true, "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372"}}, {"rule": 2, "type": "equivalent", "target": "e9ad0f812c136b8ccc25549130b5b91b", "evidence": {"same_day": true, "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372"}}], "version": "13.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "27a8bf4c09c5ea2d76fb7f98c7ccd2b2", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Fix plan generation for index-only scans on indexes with both returnable and non-returnable columns", "evidence": {"same_day": true, "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372"}, "url": "/docs/compare/?release=14.3#14.3-489835e8667c2fae", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "4f83aeb5cff810bc4a104b3a0c9f2ac4", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Fix plan generation for index-only scans on indexes with both returnable and non-returnable columns", "evidence": {"same_day": true, "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372"}, "url": "/docs/compare/?release=12.11#12.11-203c04fd55d9fe6a", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "1b0812852c836d4e66b06f7612514190", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Fix plan generation for index-only scans on indexes with both returnable and non-returnable columns", "evidence": {"same_day": true, "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372"}, "url": "/docs/compare/?release=11.16#11.16-1fa029d92af3adf5", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "e9ad0f812c136b8ccc25549130b5b91b", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Fix plan generation for index-only scans on indexes with both returnable and non-returnable columns", "evidence": {"same_day": true, "patch_ids": ["f05f0c5d161778c651730b867834ad6c"], "statement_hash": "69c32c07229c0c53698643c37d964f6d7d84daacf3ea8868714c94195b9ba372"}, "url": "/docs/compare/?release=10.21#10.21-1fa029d92af3adf5", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-8f9979f60c3d2998", "cves": [], "html": "Avoid accessing a no-longer-pinned shared buffer while attempting to lock an outdated tuple during EvalPlanQual (Tom Lane) §
\nThe code would touch the buffer a couple more times after releasing its pin. In theory another process could recycle the buffer (or more likely, try to defragment its free space) as soon as the pin is gone, probably leading to failure to find the newer version of the tuple.
", "text": "Avoid accessing a no-longer-pinned shared buffer while attempting to lock an outdated tuple during EvalPlanQual (Tom Lane) § The code would touch the buffer a couple more times after releasing its pin. In theory another process could recycle the buffer (or more likely, try to defragment its free space) as soon as the pin is gone, probably leading to failure to find the newer version of the tuple.", "title": "Avoid accessing a no-longer-pinned shared buffer while attempting to lock an outdated tuple during EvalPlanQual", "commits": ["44096c31e"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "583e8e9f1a854d29bea8b5e40c261f885d2b2b1dc37b54ec63d6d3e00cdb8ba6", "section_path": ["Changes"], "commit_groups": [["44096c31e", "7b7ed046c", "c590e514a", "e0ed20d0b"]], "identity_text": "Avoid accessing a no-longer-pinned shared buffer while attempting to lock an outdated tuple during EvalPlanQual (Tom Lane) The code would touch the buffer a couple more times after releasing its pin. In theory another process could recycle the buffer (or more likely, try to defragment its free space) as soon as the pin is gone, probably leading to failure to find the newer version of the tuple.", "commit_aliases": ["44096c31e", "7b7ed046c", "c590e514a", "e0ed20d0b"], "source_commits": ["44096c31e"], "source_entry_id": "13.7/changes/008", "db_id": "4f7eb15e2bfaffd2e80fdc412d38692f", "patch_ids": ["963dc8bca8c81b58484406954f1264a3"], "statement_hash": "d79e2936778e835c2173199b788d8c0beefe8c8838af3d8acb671ae5c690235c", "relations": [{"rule": 2, "type": "equivalent", "target": "4afaf7cea38a16b9514e5c3df614b073", "evidence": {"same_day": true, "patch_ids": ["963dc8bca8c81b58484406954f1264a3"], "statement_hash": "d79e2936778e835c2173199b788d8c0beefe8c8838af3d8acb671ae5c690235c"}}, {"rule": 2, "type": "equivalent", "target": "bceb364ad0e7e97713f78c0cbef3aa20", "evidence": {"same_day": true, "patch_ids": ["963dc8bca8c81b58484406954f1264a3"], "statement_hash": "d79e2936778e835c2173199b788d8c0beefe8c8838af3d8acb671ae5c690235c"}}], "version": "13.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "bceb364ad0e7e97713f78c0cbef3aa20", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Avoid accessing a no-longer-pinned shared buffer while attempting to lock an outdated tuple during EvalPlanQual", "evidence": {"same_day": true, "patch_ids": ["963dc8bca8c81b58484406954f1264a3"], "statement_hash": "d79e2936778e835c2173199b788d8c0beefe8c8838af3d8acb671ae5c690235c"}, "url": "/docs/compare/?release=14.3#14.3-c09fbe521f15ebe6", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "4afaf7cea38a16b9514e5c3df614b073", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Avoid accessing a no-longer-pinned shared buffer while attempting to lock an outdated tuple during EvalPlanQual", "evidence": {"same_day": true, "patch_ids": ["963dc8bca8c81b58484406954f1264a3"], "statement_hash": "d79e2936778e835c2173199b788d8c0beefe8c8838af3d8acb671ae5c690235c"}, "url": "/docs/compare/?release=12.11#12.11-4cfde300fbe83c9c", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}]}, {"id": "13.7-eea350e990077f35", "cves": [], "html": "Fix query-lifespan memory leak in an IndexScan node that is performing reordering (Aliaksandr Kalenik) §
", "text": "Fix query-lifespan memory leak in an IndexScan node that is performing reordering (Aliaksandr Kalenik) §", "title": "Fix query-lifespan memory leak in an IndexScan node that is performing reordering", "commits": ["ac2303aa0"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "09447dec67944c734e237c39dbc0046de591d0d25036676333e31bdaf8431bc6", "section_path": ["Changes"], "commit_groups": [["0d554775b", "2e9033a54", "3f74daa8d", "7a12a9e3c", "ac2303aa0", "c76665edc"]], "identity_text": "Fix query-lifespan memory leak in an IndexScan node that is performing reordering (Aliaksandr Kalenik)", "commit_aliases": ["0d554775b", "2e9033a54", "3f74daa8d", "7a12a9e3c", "ac2303aa0", "c76665edc"], "source_commits": ["ac2303aa0"], "source_entry_id": "13.7/changes/009", "db_id": "e754f05172c47425f13728c730c2b6cb", "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c", "relations": [{"rule": 2, "type": "equivalent", "target": "5e20fe6d76ddabf53f4be2f89d20e818", "evidence": {"same_day": true, "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c"}}, {"rule": 2, "type": "equivalent", "target": "67e54ee90f61b5ba4f10c442bccd81e7", "evidence": {"same_day": true, "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c"}}, {"rule": 2, "type": "equivalent", "target": "8b428e03a852b24df2398da6fce496f9", "evidence": {"same_day": true, "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c"}}, {"rule": 2, "type": "equivalent", "target": "c4dc002e8eff145c0a822b7c88deaea8", "evidence": {"same_day": true, "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c"}}], "version": "13.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "67e54ee90f61b5ba4f10c442bccd81e7", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Fix query-lifespan memory leak in an IndexScan node that is performing reordering", "evidence": {"same_day": true, "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c"}, "url": "/docs/compare/?release=14.3#14.3-88ea6eb77fb41d9d", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "5e20fe6d76ddabf53f4be2f89d20e818", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Fix query-lifespan memory leak in an IndexScan node that is performing reordering", "evidence": {"same_day": true, "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c"}, "url": "/docs/compare/?release=12.11#12.11-eb0eaa83057dd926", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "c4dc002e8eff145c0a822b7c88deaea8", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Fix query-lifespan memory leak in an IndexScan node that is performing reordering", "evidence": {"same_day": true, "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c"}, "url": "/docs/compare/?release=11.16#11.16-863893d1401fceb9", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "8b428e03a852b24df2398da6fce496f9", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Fix query-lifespan memory leak in an IndexScan node that is performing reordering", "evidence": {"same_day": true, "patch_ids": ["9cf0ef0843729535ecc47c7563d0f8f3"], "statement_hash": "bb2869647998c700f76b62d86ada7faee68fa2561d4f6b4dd4d33ba16485306c"}, "url": "/docs/compare/?release=10.21#10.21-863893d1401fceb9", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-98a1bd07b8159af5", "cves": [], "html": "Fix ALTER FUNCTION to support changing a function's parallelism property and its SET-variable list in the same command (Tom Lane) §
The parallelism property change was lost if the same command also updated the function's SET clause.
Fix bogus errors from attempts to alter system columns of tables (Tom Lane) §
\nThe system should just tell you that you can't do it, but sometimes it would report “no owned sequence found” instead.
", "text": "Fix bogus errors from attempts to alter system columns of tables (Tom Lane) § The system should just tell you that you can't do it, but sometimes it would report “no owned sequence found” instead.", "title": "Fix bogus errors from attempts to alter system columns of tables", "commits": ["69cefb3fb"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "962c58bed32b88031daac227e4d91560f476d4f367f47db7d0bd03befe649070", "section_path": ["Changes"], "commit_groups": [["0795da869", "36d4efe77", "69cefb3fb", "e805735a8"]], "identity_text": "Fix bogus errors from attempts to alter system columns of tables (Tom Lane) The system should just tell you that you can't do it, but sometimes it would report no owned sequence found instead.", "commit_aliases": ["0795da869", "36d4efe77", "69cefb3fb", "e805735a8"], "source_commits": ["69cefb3fb"], "source_entry_id": "13.7/changes/011", "db_id": "ef9e1f537e8d284e574236fa072b7fe6", "patch_ids": ["0075b415ba109a42ad865648b0098e59"], "statement_hash": "6cf37fb43592f2d2cb84f8007ecf1bc131f42d95ba2767fee76006369ef13f7d", "relations": [{"rule": 2, "type": "equivalent", "target": "69809cbbfc46c5af9e9e182495de80b7", "evidence": {"same_day": true, "patch_ids": ["0075b415ba109a42ad865648b0098e59"], "statement_hash": "6cf37fb43592f2d2cb84f8007ecf1bc131f42d95ba2767fee76006369ef13f7d"}}, {"rule": 2, "type": "equivalent", "target": "f2304ea8823d7d4619678c05992a0c42", "evidence": {"same_day": true, "patch_ids": ["0075b415ba109a42ad865648b0098e59"], "statement_hash": "6cf37fb43592f2d2cb84f8007ecf1bc131f42d95ba2767fee76006369ef13f7d"}}], "version": "13.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "f2304ea8823d7d4619678c05992a0c42", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Fix bogus errors from attempts to alter system columns of tables", "evidence": {"same_day": true, "patch_ids": ["0075b415ba109a42ad865648b0098e59"], "statement_hash": "6cf37fb43592f2d2cb84f8007ecf1bc131f42d95ba2767fee76006369ef13f7d"}, "url": "/docs/compare/?release=14.3#14.3-d0f336bd4c6ec2b5", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "69809cbbfc46c5af9e9e182495de80b7", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Fix bogus errors from attempts to alter system columns of tables", "evidence": {"same_day": true, "patch_ids": ["0075b415ba109a42ad865648b0098e59"], "statement_hash": "6cf37fb43592f2d2cb84f8007ecf1bc131f42d95ba2767fee76006369ef13f7d"}, "url": "/docs/compare/?release=12.11#12.11-9028416fc7fefe23", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}]}, {"id": "13.7-c19c6dc51403a951", "cves": [], "html": "Fix mis-sorting of table rows when CLUSTERing using an index whose leading key is an expression (Peter Geoghegan, Thomas Munro) §
The table would be rebuilt with the correct data, but in an order having little to do with the index order.
", "text": "Fix mis-sorting of table rows when CLUSTERing using an index whose leading key is an expression (Peter Geoghegan, Thomas Munro) § The table would be rebuilt with the correct data, but in an order having little to do with the index order.", "title": "Fix mis-sorting of table rows when CLUSTERing using an index whose leading key is an expression", "commits": ["1272630a2"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "7cea74603ad114ce767dd4f692d7004c529af802b28623bd66e8f08665268f5d", "section_path": ["Changes"], "commit_groups": [["1272630a2", "5487585e3", "8ab0ebb9a", "a903895b3", "adb2d84fc", "e4521841a"]], "identity_text": "Fix mis-sorting of table rows when CLUSTERing using an index whose leading key is an expression (Peter Geoghegan, Thomas Munro) The table would be rebuilt with the correct data, but in an order having little to do with the index order.", "commit_aliases": ["1272630a2", "5487585e3", "8ab0ebb9a", "a903895b3", "adb2d84fc", "e4521841a"], "source_commits": ["1272630a2"], "source_entry_id": "13.7/changes/012", "db_id": "eeadfde9c6478270c9cc562840a40f6b", "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca", "relations": [{"rule": 2, "type": "equivalent", "target": "00d8cc4d2df09875b843bd1510c7912c", "evidence": {"same_day": true, "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca"}}, {"rule": 2, "type": "equivalent", "target": "12527d4d3cfb55406276951c18a2d33e", "evidence": {"same_day": true, "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca"}}, {"rule": 2, "type": "equivalent", "target": "18154cd75fda1ba65fa17913f5ebe458", "evidence": {"same_day": true, "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca"}}, {"rule": 2, "type": "equivalent", "target": "9ef5206aa477e4189e0fc1416397a897", "evidence": {"same_day": true, "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca"}}], "version": "13.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "9ef5206aa477e4189e0fc1416397a897", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Fix mis-sorting of table rows when CLUSTERing using an index whose leading key is an expression", "evidence": {"same_day": true, "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca"}, "url": "/docs/compare/?release=14.3#14.3-2c8715e3c1588e6b", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "18154cd75fda1ba65fa17913f5ebe458", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Fix mis-sorting of table rows when CLUSTERing using an index whose leading key is an expression", "evidence": {"same_day": true, "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca"}, "url": "/docs/compare/?release=12.11#12.11-a09e04543c50e358", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "12527d4d3cfb55406276951c18a2d33e", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Fix mis-sorting of table rows when CLUSTERing using an index whose leading key is an expression", "evidence": {"same_day": true, "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca"}, "url": "/docs/compare/?release=11.16#11.16-b4eacb4bfb1c77f3", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "00d8cc4d2df09875b843bd1510c7912c", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Fix mis-sorting of table rows when CLUSTERing using an index whose leading key is an expression", "evidence": {"same_day": true, "patch_ids": ["beb8b29b6b7a279fd9c643c75dfec048"], "statement_hash": "c89ead64dcfa64fe0cc30d999a82b58716a4655d95bb47ffcb27f728c59a83ca"}, "url": "/docs/compare/?release=10.21#10.21-b4eacb4bfb1c77f3", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-b7f8cef792190b43", "cves": [], "html": "Fix risk of deadlock failures while dropping a partitioned index (Jimmy Yih, Gaurab Dey, Tom Lane) §
\nEnsure that the required table and index locks are taken in the standard order (parents before children, tables before indexes). The previous coding for DROP INDEX did it differently, and so could deadlock against concurrent queries taking these locks in the standard order.
Fix race condition between DROP TABLESPACE and checkpointing (Nathan Bossart) §
The checkpoint forced by DROP TABLESPACE could sometimes fail to remove all dead files from the tablespace's directory, leading to a bogus “tablespace is not empty” error.
Fix possible trouble in crash recovery after a TRUNCATE command that overlaps a checkpoint (Kyotaro Horiguchi, Heikki Linnakangas, Robert Haas) § §
TRUNCATE must ensure that the table's disk file is truncated before the checkpoint is allowed to complete. Otherwise, replay starting from that checkpoint might find unexpected data in the supposedly-removed pages, possibly causing replay failure.
Fix unsafe toast-data accesses during temporary object cleanup (Andres Freund) §
\nTemporary-object deletion during server process exit could fail with “FATAL: cannot fetch toast data without an active snapshot”. This was usually harmless since the next use of that temporary schema would clean up successfully.
", "text": "Fix unsafe toast-data accesses during temporary object cleanup (Andres Freund) § Temporary-object deletion during server process exit could fail with “FATAL: cannot fetch toast data without an active snapshot”. This was usually harmless since the next use of that temporary schema would clean up successfully.", "title": "Fix unsafe toast-data accesses during temporary object cleanup", "commits": ["c2551483e"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "a4f178ce93169f58cb47ef1c3e7153f9f49618a1f569d0423af263a45c2402d1", "section_path": ["Changes"], "commit_groups": [["0033fc63f", "3faa21bb7", "7bbfe5994", "7c38ef2a5", "c2551483e", "cebc54b90"]], "identity_text": "Fix unsafe toast-data accesses during temporary object cleanup (Andres Freund) Temporary-object deletion during server process exit could fail with FATAL: cannot fetch toast data without an active snapshot. This was usually harmless since the next use of that temporary schema would clean up successfully.", "commit_aliases": ["0033fc63f", "3faa21bb7", "7bbfe5994", "7c38ef2a5", "c2551483e", "cebc54b90"], "source_commits": ["c2551483e"], "source_entry_id": "13.7/changes/016", "db_id": "7fe45e5fb801a18a0572d9b1f633fcfe", "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f", "relations": [{"rule": 2, "type": "equivalent", "target": "032efc6442217e5375f6d528eb22bb61", "evidence": {"same_day": true, "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f"}}, {"rule": 2, "type": "equivalent", "target": "1de9775a50fcc38cb20f848f22f0c990", "evidence": {"same_day": true, "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f"}}, {"rule": 2, "type": "equivalent", "target": "8a604d943f999d3621ddd702ae5361bd", "evidence": {"same_day": true, "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f"}}, {"rule": 2, "type": "equivalent", "target": "e09ae6f09ca06e58a50e74ead9e74406", "evidence": {"same_day": true, "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f"}}], "version": "13.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "1de9775a50fcc38cb20f848f22f0c990", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Fix unsafe toast-data accesses during temporary object cleanup", "evidence": {"same_day": true, "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f"}, "url": "/docs/compare/?release=14.3#14.3-180c178af2d9ff42", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "e09ae6f09ca06e58a50e74ead9e74406", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Fix unsafe toast-data accesses during temporary object cleanup", "evidence": {"same_day": true, "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f"}, "url": "/docs/compare/?release=12.11#12.11-5241c5c0dfa9c25e", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "032efc6442217e5375f6d528eb22bb61", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Fix unsafe toast-data accesses during temporary object cleanup", "evidence": {"same_day": true, "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f"}, "url": "/docs/compare/?release=11.16#11.16-f7d55d6e06eafd95", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "8a604d943f999d3621ddd702ae5361bd", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Fix unsafe toast-data accesses during temporary object cleanup", "evidence": {"same_day": true, "patch_ids": ["26c8eced86f6a3a6ca54273b5b528cb5"], "statement_hash": "d68a03834adaf6467c3f014833d53caeae4a45aa56d4c32aad2fec7fce33789f"}, "url": "/docs/compare/?release=10.21#10.21-f7d55d6e06eafd95", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-68d39c4fa71c5adc", "cves": [], "html": "Improve wait logic in RegisterSyncRequest (Thomas Munro) §
\nIf we run out of space in the checkpointer sync request queue (which is hopefully rare on real systems, but is common when testing with a very small buffer pool), we wait for it to drain. While waiting, we should report that as a wait event so that users know what is going on, and also watch for postmaster death, since otherwise the loop might never terminate if the checkpointer has already exited.
", "text": "Improve wait logic in RegisterSyncRequest (Thomas Munro) § If we run out of space in the checkpointer sync request queue (which is hopefully rare on real systems, but is common when testing with a very small buffer pool), we wait for it to drain. While waiting, we should report that as a wait event so that users know what is going on, and also watch for postmaster death, since otherwise the loop might never terminate if the checkpointer has already exited.", "title": "Improve wait logic in RegisterSyncRequest", "commits": ["cfdb303be"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "08be8e9bb806931e2a3496adb6bd7a7c421fddeb2c68ef7d46c8d00f5bdf2c62", "section_path": ["Changes"], "commit_groups": [["1396b5c6e", "3390ef1b7", "368ffdeee", "cfdb303be"]], "identity_text": "Improve wait logic in RegisterSyncRequest (Thomas Munro) If we run out of space in the checkpointer sync request queue (which is hopefully rare on real systems, but is common when testing with a very small buffer pool), we wait for it to drain. While waiting, we should report that as a wait event so that users know what is going on, and also watch for postmaster death, since otherwise the loop might never terminate if the checkpointer has already exited.", "commit_aliases": ["1396b5c6e", "3390ef1b7", "368ffdeee", "cfdb303be"], "source_commits": ["cfdb303be"], "source_entry_id": "13.7/changes/017", "db_id": "bf212a65b2fd693ae19befc18338f6c1", "patch_ids": ["46e0a416007f6b4cf10784401f9bb8c1"], "statement_hash": "6e15a12c633408194a7ef1ba841934d022706173260452535c1da77108e1c3ea", "relations": [{"rule": 2, "type": "equivalent", "target": "665bdc3277aa51e51724742aecb12435", "evidence": {"same_day": true, "patch_ids": ["46e0a416007f6b4cf10784401f9bb8c1"], "statement_hash": "6e15a12c633408194a7ef1ba841934d022706173260452535c1da77108e1c3ea"}}, {"rule": 2, "type": "equivalent", "target": "66edf7fd9bc7ac6ac3bf7370ef47246f", "evidence": {"same_day": true, "patch_ids": ["46e0a416007f6b4cf10784401f9bb8c1"], "statement_hash": "6e15a12c633408194a7ef1ba841934d022706173260452535c1da77108e1c3ea"}}], "version": "13.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "66edf7fd9bc7ac6ac3bf7370ef47246f", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Improve wait logic in RegisterSyncRequest", "evidence": {"same_day": true, "patch_ids": ["46e0a416007f6b4cf10784401f9bb8c1"], "statement_hash": "6e15a12c633408194a7ef1ba841934d022706173260452535c1da77108e1c3ea"}, "url": "/docs/compare/?release=14.3#14.3-1f83e4ce172a5625", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "665bdc3277aa51e51724742aecb12435", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Improve wait logic in RegisterSyncRequest", "evidence": {"same_day": true, "patch_ids": ["46e0a416007f6b4cf10784401f9bb8c1"], "statement_hash": "6e15a12c633408194a7ef1ba841934d022706173260452535c1da77108e1c3ea"}, "url": "/docs/compare/?release=12.11#12.11-a4c5f5fded4ca26b", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}]}, {"id": "13.7-f3fabf8f11d45a79", "cves": [], "html": "Fix “PANIC: xlog flush request is not satisfied” failure during standby promotion when there is a missing WAL continuation record (Sami Imseih) §
", "text": "Fix “PANIC: xlog flush request is not satisfied” failure during standby promotion when there is a missing WAL continuation record (Sami Imseih) §", "title": "Fix “PANIC: xlog flush request is not satisfied” failure during standby promotion when there is a missing WAL continuation record", "commits": ["98eb3e06c"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "c176540cf7e2de3a10f2eeb970c88eb686d3472e82ef5cd255787faf1bce616a", "section_path": ["Changes"], "commit_groups": [["199cd7b59", "98eb3e06c", "9ade3c09a", "9d92582ab", "c714ebd0e", "caaeb88ff"]], "identity_text": "Fix PANIC: xlog flush request is not satisfied failure during standby promotion when there is a missing WAL continuation record (Sami Imseih)", "commit_aliases": ["199cd7b59", "98eb3e06c", "9ade3c09a", "9d92582ab", "c714ebd0e", "caaeb88ff"], "source_commits": ["98eb3e06c"], "source_entry_id": "13.7/changes/018", "db_id": "4616f6f989728145ab6c6ddc011d81bd", "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553", "relations": [{"rule": 2, "type": "equivalent", "target": "584a81401b973825070db064f4c5ffed", "evidence": {"same_day": true, "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553"}}, {"rule": 2, "type": "equivalent", "target": "bf04d49f808aa1ddd6d6de22354000eb", "evidence": {"same_day": true, "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553"}}, {"rule": 2, "type": "equivalent", "target": "e912bf1a48b6907073e2fd8968bbc3a9", "evidence": {"same_day": true, "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553"}}, {"rule": 2, "type": "equivalent", "target": "efed42fc416ec8b749584b57596f52e1", "evidence": {"same_day": true, "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553"}}], "version": "13.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "efed42fc416ec8b749584b57596f52e1", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Fix “PANIC: xlog flush request is not satisfied” failure during standby promotion when there is a missing WAL continuation record", "evidence": {"same_day": true, "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553"}, "url": "/docs/compare/?release=14.3#14.3-67de1df9ca9c590c", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "584a81401b973825070db064f4c5ffed", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Fix “PANIC: xlog flush request is not satisfied” failure during standby promotion when there is a missing WAL continuation record", "evidence": {"same_day": true, "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553"}, "url": "/docs/compare/?release=12.11#12.11-a981739bfb0bdb1f", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "bf04d49f808aa1ddd6d6de22354000eb", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Fix “PANIC: xlog flush request is not satisfied” failure during standby promotion when there is a missing WAL continuation record", "evidence": {"same_day": true, "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553"}, "url": "/docs/compare/?release=11.16#11.16-64c666717bb49df5", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "e912bf1a48b6907073e2fd8968bbc3a9", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Fix “PANIC: xlog flush request is not satisfied” failure during standby promotion when there is a missing WAL continuation record", "evidence": {"same_day": true, "patch_ids": ["d7366202c2ac6174b1562618eed0022c"], "statement_hash": "dec3ba5ab3cc03a148a8eb03d352a62214c1a3a2b0b6b184984ef06882a33553"}, "url": "/docs/compare/?release=10.21#10.21-64c666717bb49df5", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-68e9a1cfd8eb8d19", "cves": [], "html": "Fix possibility of self-deadlock in hot standby conflict handling (Andres Freund) § § §
\nWith unlucky timing, the WAL-applying process could get stuck while waiting for some other process to release a buffer lock.
", "text": "Fix possibility of self-deadlock in hot standby conflict handling (Andres Freund) § § § With unlucky timing, the WAL-applying process could get stuck while waiting for some other process to release a buffer lock.", "title": "Fix possibility of self-deadlock in hot standby conflict handling", "commits": ["0446d3bf3", "57c5ad168", "90abe1e17"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "31f2dff18fa5b38dd7f023cd55232bfbc7e97ab98bc872b0f759259742081866", "section_path": ["Changes"], "commit_groups": [["0446d3bf3", "25d5494e2", "a5ede1391", "b1f35a36e", "f74496dd6"], ["2adb8debe", "5ab8e8014", "5c8b14a71", "90abe1e17", "e8a0cf9b2"], ["57c5ad168", "8f1537d10", "9ab3b2bdb", "9cda785b4", "cbc47ad7e", "edfc03ec9"]], "identity_text": "Fix possibility of self-deadlock in hot standby conflict handling (Andres Freund) With unlucky timing, the WAL-applying process could get stuck while waiting for some other process to release a buffer lock.", "commit_aliases": ["0446d3bf3", "25d5494e2", "2adb8debe", "57c5ad168", "5ab8e8014", "5c8b14a71", "8f1537d10", "90abe1e17", "9ab3b2bdb", "9cda785b4", "a5ede1391", "b1f35a36e", "cbc47ad7e", "e8a0cf9b2", "edfc03ec9", "f74496dd6"], "source_commits": ["0446d3bf3", "57c5ad168", "90abe1e17"], "source_entry_id": "13.7/changes/019", "db_id": "cbd21a3d7d5f7b9494e7b9ea5f925594", "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225", "relations": [{"rule": 2, "type": "equivalent", "target": "7c662f5bf745a4d32c2bd4d67e7dcddd", "evidence": {"same_day": true, "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225"}}, {"rule": 2, "type": "equivalent", "target": "8326850f199485395083b431edd51d72", "evidence": {"same_day": true, "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225"}}, {"rule": 2, "type": "equivalent", "target": "9917635a38b20d66db9f32a624027fdc", "evidence": {"same_day": true, "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225"}}, {"rule": 2, "type": "equivalent", "target": "bfe754562d7efef753ac505f1ce64640", "evidence": {"same_day": true, "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225"}}], "version": "13.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "9917635a38b20d66db9f32a624027fdc", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Fix possibility of self-deadlock in hot standby conflict handling", "evidence": {"same_day": true, "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225"}, "url": "/docs/compare/?release=14.3#14.3-e3d892048c4eb17c", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "8326850f199485395083b431edd51d72", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Fix possibility of self-deadlock in hot standby conflict handling", "evidence": {"same_day": true, "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225"}, "url": "/docs/compare/?release=12.11#12.11-d5cf271c00b45f44", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "bfe754562d7efef753ac505f1ce64640", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Fix possibility of self-deadlock in hot standby conflict handling", "evidence": {"same_day": true, "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225"}, "url": "/docs/compare/?release=11.16#11.16-d63bc2772d07cc5d", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "7c662f5bf745a4d32c2bd4d67e7dcddd", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Fix possibility of self-deadlock in hot standby conflict handling", "evidence": {"same_day": true, "patch_ids": ["3ae1cebdc882ce86c9a9663ee9119370", "c987d4f0bef2ed1a878ce690db4a3580", "eec58c9f45ac6d4e8fa18aaf0b176062"], "statement_hash": "19df3615567e3172b048f5f3d28c721d1edc9a0b102de72d3ae1c105016dd225"}, "url": "/docs/compare/?release=10.21#10.21-d63bc2772d07cc5d", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-0df9d4ae5a52837b", "cves": [], "html": "Fix possible mis-identification of the correct ancestor relation to publish logical replication changes through (Tomas Vondra, Hou zj, Amit Kapila) §
\nIf publish_via_partition_root is enabled, and there are multiple publications naming different ancestors of the currently-modified relation, the wrong ancestor might be chosen for reporting the change.
Ensure that logical replication apply workers can be restarted even when we're up against the max_sync_workers_per_subscription limit (Amit Kapila) §
Faulty coding of the limit check caused a restarted worker to exit immediately, leaving fewer workers than there should be.
", "text": "Ensure that logical replication apply workers can be restarted even when we're up against the max_sync_workers_per_subscription limit (Amit Kapila) § Faulty coding of the limit check caused a restarted worker to exit immediately, leaving fewer workers than there should be.", "title": "Ensure that logical replication apply workers can be restarted even when we're up against the max_sync_workers_per_subscription limit", "commits": ["82d4a17a1"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "ec850510dc1f6237bb7e37f4c2e90864f0d5385b32c29661f468f799ededae2e", "section_path": ["Changes"], "commit_groups": [["59348fbde", "82d4a17a1", "a90de822e", "be46985be", "c9dea58e2", "dd4ab6fd6"]], "identity_text": "Ensure that logical replication apply workers can be restarted even when we're up against the max_sync_workers_per_subscription limit (Amit Kapila) Faulty coding of the limit check caused a restarted worker to exit immediately, leaving fewer workers than there should be.", "commit_aliases": ["59348fbde", "82d4a17a1", "a90de822e", "be46985be", "c9dea58e2", "dd4ab6fd6"], "source_commits": ["82d4a17a1"], "source_entry_id": "13.7/changes/021", "db_id": "65dc9f700963dfd29d410cfed4b78859", "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd", "relations": [{"rule": 2, "type": "equivalent", "target": "4d77101a0dcfa5ea847fb5373636fcc1", "evidence": {"same_day": true, "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd"}}, {"rule": 2, "type": "equivalent", "target": "6cb0508f0a9e0afafb73a70f702a7705", "evidence": {"same_day": true, "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd"}}, {"rule": 2, "type": "equivalent", "target": "c8faa35f51a3c0ace4a4fc31fc4be4fa", "evidence": {"same_day": true, "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd"}}, {"rule": 2, "type": "equivalent", "target": "d4225ea6fb86c887ba568cca78d6125a", "evidence": {"same_day": true, "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd"}}], "version": "13.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "d4225ea6fb86c887ba568cca78d6125a", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Ensure that logical replication apply workers can be restarted even when we're up against the max_sync_workers_per_subscription limit", "evidence": {"same_day": true, "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd"}, "url": "/docs/compare/?release=14.3#14.3-93ffe1cf73218ab0", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "4d77101a0dcfa5ea847fb5373636fcc1", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Ensure that logical replication apply workers can be restarted even when we're up against the max_sync_workers_per_subscription limit", "evidence": {"same_day": true, "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd"}, "url": "/docs/compare/?release=12.11#12.11-6dc41deb32f0c4ba", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "c8faa35f51a3c0ace4a4fc31fc4be4fa", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Ensure that logical replication apply workers can be restarted even when we're up against the max_sync_workers_per_subscription limit", "evidence": {"same_day": true, "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd"}, "url": "/docs/compare/?release=11.16#11.16-02b486ef2671e7ee", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "6cb0508f0a9e0afafb73a70f702a7705", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Ensure that logical replication apply workers can be restarted even when we're up against the max_sync_workers_per_subscription limit", "evidence": {"same_day": true, "patch_ids": ["561261d9082b5d0459ff5d89d6c93d8a"], "statement_hash": "207014b7edd7ff2728e5b44fc727fdcbd375add4bad184d028de0b84c36747bd"}, "url": "/docs/compare/?release=10.21#10.21-02b486ef2671e7ee", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-74763003b2707c52", "cves": [], "html": "Include unchanged replica identity key columns in the WAL log for an update, if they are stored out-of-line (Dilip Kumar, Amit Kapila) §
\nOtherwise subscribers cannot see the values and will fail to replicate the update.
", "text": "Include unchanged replica identity key columns in the WAL log for an update, if they are stored out-of-line (Dilip Kumar, Amit Kapila) § Otherwise subscribers cannot see the values and will fail to replicate the update.", "title": "Include unchanged replica identity key columns in the WAL log for an update, if they are stored out-of-line", "commits": ["caa231be9"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "f91242ebfd442303a7fcba6e6c0c6a1dc35399b02d97598f506ede7ac2e81225", "section_path": ["Changes"], "commit_groups": [["04645bbca", "1cd5802ac", "5e01001ff", "b5e060473", "caa231be9", "ce349cf17"]], "identity_text": "Include unchanged replica identity key columns in the WAL log for an update, if they are stored out-of-line (Dilip Kumar, Amit Kapila) Otherwise subscribers cannot see the values and will fail to replicate the update.", "commit_aliases": ["04645bbca", "1cd5802ac", "5e01001ff", "b5e060473", "caa231be9", "ce349cf17"], "source_commits": ["caa231be9"], "source_entry_id": "13.7/changes/022", "db_id": "9a94d67ddddbd742c503f9c8324b18e4", "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e", "relations": [{"rule": 2, "type": "equivalent", "target": "07858b021e0e853308156789e418cd2a", "evidence": {"same_day": true, "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e"}}, {"rule": 2, "type": "equivalent", "target": "bf5d4be3e90daa1d7d78f997c974599d", "evidence": {"same_day": true, "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e"}}, {"rule": 2, "type": "equivalent", "target": "d788e8137114d6bd76da60ed58066080", "evidence": {"same_day": true, "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e"}}, {"rule": 2, "type": "equivalent", "target": "e91345693e41d6a01bb1111c14f73dcb", "evidence": {"same_day": true, "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e"}}], "version": "13.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "d788e8137114d6bd76da60ed58066080", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Include unchanged replica identity key columns in the WAL log for an update, if they are stored out-of-line", "evidence": {"same_day": true, "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e"}, "url": "/docs/compare/?release=14.3#14.3-1969eb606850e557", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "bf5d4be3e90daa1d7d78f997c974599d", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Include unchanged replica identity key columns in the WAL log for an update, if they are stored out-of-line", "evidence": {"same_day": true, "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e"}, "url": "/docs/compare/?release=12.11#12.11-8cdc19f514753e90", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "07858b021e0e853308156789e418cd2a", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Include unchanged replica identity key columns in the WAL log for an update, if they are stored out-of-line", "evidence": {"same_day": true, "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e"}, "url": "/docs/compare/?release=11.16#11.16-e637b6b4698fba59", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "e91345693e41d6a01bb1111c14f73dcb", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Include unchanged replica identity key columns in the WAL log for an update, if they are stored out-of-line", "evidence": {"same_day": true, "patch_ids": ["b2780ab671c5f1c7f301a12c222edd0c"], "statement_hash": "9bc9aa05fa13870cfff1ba36ad448452ead9698c9994699a261d92c2ae40e84e"}, "url": "/docs/compare/?release=10.21#10.21-e637b6b4698fba59", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-08d770fa949bbfe5", "cves": [], "html": "Cope correctly with platforms that have no support for altering the server process's display in ps(1) (Andrew Dunstan) §
\nFew platforms are like this (the only supported one is Cygwin), so we'd managed not to notice that refactoring introduced a potential memory clobber.
", "text": "Cope correctly with platforms that have no support for altering the server process's display in ps(1) (Andrew Dunstan) § Few platforms are like this (the only supported one is Cygwin), so we'd managed not to notice that refactoring introduced a potential memory clobber.", "title": "Cope correctly with platforms that have no support for altering the server process's display in ps(1)", "commits": ["9016a2a3d"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "a687cd3f421fb656591d87ab10843a8a8879f03352900eee0b5626be03feaee0", "section_path": ["Changes"], "commit_groups": [["0fb6954aa", "3f7a59c59", "9016a2a3d"]], "identity_text": "Cope correctly with platforms that have no support for altering the server process's display in ps(1) (Andrew Dunstan) Few platforms are like this (the only supported one is Cygwin), so we'd managed not to notice that refactoring introduced a potential memory clobber.", "commit_aliases": ["0fb6954aa", "3f7a59c59", "9016a2a3d"], "source_commits": ["9016a2a3d"], "source_entry_id": "13.7/changes/023", "db_id": "b15b4a1a7796351246e4e897a487e7fa", "patch_ids": ["a394bea248916dfe044423489ee85068"], "statement_hash": "90389f7e3c89e6f2477cae43dec4f96f16fe5137cb48070225e6e2d848b8fdd0", "relations": [{"rule": 2, "type": "equivalent", "target": "ccd4be25c2fcbabd0a3d631bbf746371", "evidence": {"same_day": true, "patch_ids": ["a394bea248916dfe044423489ee85068"], "statement_hash": "90389f7e3c89e6f2477cae43dec4f96f16fe5137cb48070225e6e2d848b8fdd0"}}], "version": "13.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "ccd4be25c2fcbabd0a3d631bbf746371", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Cope correctly with platforms that have no support for altering the server process's display in ps(1)", "evidence": {"same_day": true, "patch_ids": ["a394bea248916dfe044423489ee85068"], "statement_hash": "90389f7e3c89e6f2477cae43dec4f96f16fe5137cb48070225e6e2d848b8fdd0"}, "url": "/docs/compare/?release=14.3#14.3-6a66ef768080de2b", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}]}, {"id": "13.7-0088434181bc2fc0", "cves": [], "html": "Disallow execution of SPI functions during PL/Perl function compilation (Tom Lane) §
\nPerl can be convinced to execute user-defined code during compilation of a PL/Perl function. However, it's not okay for such code to try to invoke SQL operations via SPI. That results in a crash, and if it didn't crash it would be a security hazard, because we really don't want code execution during function validation. Put in a check to give a friendlier error message instead.
", "text": "Disallow execution of SPI functions during PL/Perl function compilation (Tom Lane) § Perl can be convinced to execute user-defined code during compilation of a PL/Perl function. However, it's not okay for such code to try to invoke SQL operations via SPI. That results in a crash, and if it didn't crash it would be a security hazard, because we really don't want code execution during function validation. Put in a check to give a friendlier error message instead.", "title": "Disallow execution of SPI functions during PL/Perl function compilation", "commits": ["9b2d762a2"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "f7ef605ab3b1b5d29acda4cccd4cda329fca8044cb15ab11edd8787d167d49dc", "section_path": ["Changes"], "commit_groups": [["0f7b62f29", "31befa6be", "4936747c4", "638300fef", "9b2d762a2", "ac910bb23"]], "identity_text": "Disallow execution of SPI functions during PL/Perl function compilation (Tom Lane) Perl can be convinced to execute user-defined code during compilation of a PL/Perl function. However, it's not okay for such code to try to invoke SQL operations via SPI. That results in a crash, and if it didn't crash it would be a security hazard, because we really don't want code execution during function validation. Put in a check to give a friendlier error message instead.", "commit_aliases": ["0f7b62f29", "31befa6be", "4936747c4", "638300fef", "9b2d762a2", "ac910bb23"], "source_commits": ["9b2d762a2"], "source_entry_id": "13.7/changes/024", "db_id": "1a769f4c529fcb545534198ce41903c3", "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38", "relations": [{"rule": 2, "type": "equivalent", "target": "66a04bbfc201325edeb1e8fe449982c6", "evidence": {"same_day": true, "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38"}}, {"rule": 2, "type": "equivalent", "target": "708c5ef046b16665e0cf6c92805f5d03", "evidence": {"same_day": true, "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38"}}, {"rule": 2, "type": "equivalent", "target": "81e7823dbdbf09d737aff84f180d06e4", "evidence": {"same_day": true, "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38"}}, {"rule": 2, "type": "equivalent", "target": "9a37b80a76e4afc35be9feda8bc2f008", "evidence": {"same_day": true, "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38"}}], "version": "13.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "81e7823dbdbf09d737aff84f180d06e4", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Disallow execution of SPI functions during PL/Perl function compilation", "evidence": {"same_day": true, "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38"}, "url": "/docs/compare/?release=14.3#14.3-d861627a634d055a", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "9a37b80a76e4afc35be9feda8bc2f008", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Disallow execution of SPI functions during PL/Perl function compilation", "evidence": {"same_day": true, "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38"}, "url": "/docs/compare/?release=12.11#12.11-819ab4d7947c42d8", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "66a04bbfc201325edeb1e8fe449982c6", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Disallow execution of SPI functions during PL/Perl function compilation", "evidence": {"same_day": true, "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38"}, "url": "/docs/compare/?release=11.16#11.16-859b2f1177b15a8d", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "708c5ef046b16665e0cf6c92805f5d03", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Disallow execution of SPI functions during PL/Perl function compilation", "evidence": {"same_day": true, "patch_ids": ["2186991ab188d506d8112dda5b368d35"], "statement_hash": "b7ec6b2f1b4477fc029413efa316e769c6f2039060f1da925b6b8fd2b845aa38"}, "url": "/docs/compare/?release=10.21#10.21-859b2f1177b15a8d", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-297b099bb3862120", "cves": [], "html": "Make libpq accept root-owned SSL private key files (David Steele) § §
\nThis change synchronizes libpq's rules for safe ownership and permissions of SSL key files with the rules the server has used since release 9.6. Namely, in addition to the current rules, allow the case where the key file is owned by root and has permissions rw-r----- or less. This is helpful for system-wide management of key files.
Fix behavior of libpq's PQisBusy() function after a connection failure (Tom Lane) §
If we'd detected a write failure, PQisBusy() would always return true, which is the wrong thing: we want input processing to carry on normally until we've read whatever is available from the server. The practical effect of this error is that applications using libpq's async-query API would typically detect connection loss only when PQconsumeInput() returns a hard failure. With this fix, a connection loss will normally be reported via an error PGresult object, which is a much cleaner behavior for most applications.
Make pg_ctl recheck postmaster aliveness while waiting for stop/restart/promote actions (Tom Lane) §
\npg_ctl would verify that the postmaster is alive as a side-effect of sending the stop or promote signal, but then it just naively waited to see the on-disk state change. If the postmaster died uncleanly without having removed its PID file or updated the control file, pg_ctl would wait until timeout. Instead make it recheck every so often that the postmaster process is still there.
", "text": "Make pg_ctl recheck postmaster aliveness while waiting for stop/restart/promote actions (Tom Lane) § pg_ctl would verify that the postmaster is alive as a side-effect of sending the stop or promote signal, but then it just naively waited to see the on-disk state change. If the postmaster died uncleanly without having removed its PID file or updated the control file, pg_ctl would wait until timeout. Instead make it recheck every so often that the postmaster process is still there.", "title": "Make pg_ctl recheck postmaster aliveness while waiting for stop/restart/promote actions", "commits": ["d0e1fd958"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "b4e3f399008d83c3863320b1be757111b3aba56ec8a62936e21ba839dd479745", "section_path": ["Changes"], "commit_groups": [["1e8c5cf7c", "34523933b", "61c20a5ea", "69cc15c31", "a745b9365", "d0e1fd958"]], "identity_text": "Make pg_ctl recheck postmaster aliveness while waiting for stop/restart/promote actions (Tom Lane) pg_ctl would verify that the postmaster is alive as a side-effect of sending the stop or promote signal, but then it just naively waited to see the on-disk state change. If the postmaster died uncleanly without having removed its PID file or updated the control file, pg_ctl would wait until timeout. Instead make it recheck every so often that the postmaster process is still there.", "commit_aliases": ["1e8c5cf7c", "34523933b", "61c20a5ea", "69cc15c31", "a745b9365", "d0e1fd958"], "source_commits": ["d0e1fd958"], "source_entry_id": "13.7/changes/027", "db_id": "4dfa47cd00fd62c8e09003015eead70b", "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da", "relations": [{"rule": 2, "type": "equivalent", "target": "34e228fe7feaf05f81e9c42f38121b9d", "evidence": {"same_day": true, "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da"}}, {"rule": 2, "type": "equivalent", "target": "90cf21300bd071aadc57d55aebd19b4c", "evidence": {"same_day": true, "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da"}}, {"rule": 2, "type": "equivalent", "target": "9bc45a590ac3fb2d68c48c532cc62b14", "evidence": {"same_day": true, "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da"}}, {"rule": 2, "type": "equivalent", "target": "c7a94a5f0922f7af615dda1c9d643669", "evidence": {"same_day": true, "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da"}}], "version": "13.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "c7a94a5f0922f7af615dda1c9d643669", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Make pg_ctl recheck postmaster aliveness while waiting for stop/restart/promote actions", "evidence": {"same_day": true, "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da"}, "url": "/docs/compare/?release=14.3#14.3-d026366bb6adde15", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "9bc45a590ac3fb2d68c48c532cc62b14", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Make pg_ctl recheck postmaster aliveness while waiting for stop/restart/promote actions", "evidence": {"same_day": true, "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da"}, "url": "/docs/compare/?release=12.11#12.11-57b7c908c94fa0ec", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "90cf21300bd071aadc57d55aebd19b4c", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Make pg_ctl recheck postmaster aliveness while waiting for stop/restart/promote actions", "evidence": {"same_day": true, "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da"}, "url": "/docs/compare/?release=11.16#11.16-3835b2168126e4a6", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "34e228fe7feaf05f81e9c42f38121b9d", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Make pg_ctl recheck postmaster aliveness while waiting for stop/restart/promote actions", "evidence": {"same_day": true, "patch_ids": ["0bb132275b9eba5fcdda1fbd544ef5e9"], "statement_hash": "2be54ada8e5bc704427ebc6389811723ded88977581679b61761d562f50240da"}, "url": "/docs/compare/?release=10.21#10.21-3835b2168126e4a6", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-014395f2752bce59", "cves": [], "html": "Fix error handling in pg_waldump (Kyotaro Horiguchi, Andres Freund) § §
\nWhile trying to read a WAL file to determine the WAL segment size, pg_waldump would report an incorrect error for the case of a too-short file. In addition, the file name reported in this and related error messages could be garbage.
", "text": "Fix error handling in pg_waldump (Kyotaro Horiguchi, Andres Freund) § § While trying to read a WAL file to determine the WAL segment size, pg_waldump would report an incorrect error for the case of a too-short file. In addition, the file name reported in this and related error messages could be garbage.", "title": "Fix error handling in pg_waldump", "commits": ["0b1020a96", "344d89abf"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "94178c48e0db4d9d396d73ed4eef26d5d6df22e1248eff8a1cd836d3935f89d5", "section_path": ["Changes"], "commit_groups": [["0b1020a96", "51c341656", "5407241a8", "9ff7fd906", "cd83cb953"], ["264d28492", "344d89abf", "5ebd262dc", "6839aa7a6", "7d935bdf7"]], "identity_text": "Fix error handling in pg_waldump (Kyotaro Horiguchi, Andres Freund) While trying to read a WAL file to determine the WAL segment size, pg_waldump would report an incorrect error for the case of a too-short file. In addition, the file name reported in this and related error messages could be garbage.", "commit_aliases": ["0b1020a96", "264d28492", "344d89abf", "51c341656", "5407241a8", "5ebd262dc", "6839aa7a6", "7d935bdf7", "9ff7fd906", "cd83cb953"], "source_commits": ["0b1020a96", "344d89abf"], "source_entry_id": "13.7/changes/028", "db_id": "f4eb8320018c5e6ac1be52a5970e77d6", "patch_ids": ["095b1d385e0e0816c29d0898b5f49da3", "1065a2b8ff3c053438c283781c258fad"], "statement_hash": "1aa4730866ec2f79ebc8e6357544c58ea0603bed69bcd00ef417c5e93b08b413", "relations": [{"rule": 2, "type": "equivalent", "target": "719ec32d683fde3303b6e02d07e86839", "evidence": {"same_day": true, "patch_ids": ["095b1d385e0e0816c29d0898b5f49da3", "1065a2b8ff3c053438c283781c258fad"], "statement_hash": "1aa4730866ec2f79ebc8e6357544c58ea0603bed69bcd00ef417c5e93b08b413"}}, {"rule": 2, "type": "equivalent", "target": "867f2d88d0460a093fd991b9ce78ed56", "evidence": {"same_day": true, "patch_ids": ["095b1d385e0e0816c29d0898b5f49da3", "1065a2b8ff3c053438c283781c258fad"], "statement_hash": "1aa4730866ec2f79ebc8e6357544c58ea0603bed69bcd00ef417c5e93b08b413"}}, {"rule": 2, "type": "equivalent", "target": "8721860a4d9262ff26da7fd8e4d4fa59", "evidence": {"same_day": true, "patch_ids": ["095b1d385e0e0816c29d0898b5f49da3", "1065a2b8ff3c053438c283781c258fad"], "statement_hash": "1aa4730866ec2f79ebc8e6357544c58ea0603bed69bcd00ef417c5e93b08b413"}}], "version": "13.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "867f2d88d0460a093fd991b9ce78ed56", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Fix error handling in pg_waldump", "evidence": {"same_day": true, "patch_ids": ["095b1d385e0e0816c29d0898b5f49da3", "1065a2b8ff3c053438c283781c258fad"], "statement_hash": "1aa4730866ec2f79ebc8e6357544c58ea0603bed69bcd00ef417c5e93b08b413"}, "url": "/docs/compare/?release=14.3#14.3-d605260bcffbd76f", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "719ec32d683fde3303b6e02d07e86839", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Fix error handling in pg_waldump", "evidence": {"same_day": true, "patch_ids": ["095b1d385e0e0816c29d0898b5f49da3", "1065a2b8ff3c053438c283781c258fad"], "statement_hash": "1aa4730866ec2f79ebc8e6357544c58ea0603bed69bcd00ef417c5e93b08b413"}, "url": "/docs/compare/?release=12.11#12.11-5b5a77dca7d6b9d9", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "8721860a4d9262ff26da7fd8e4d4fa59", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Fix error handling in pg_waldump", "evidence": {"same_day": true, "patch_ids": ["095b1d385e0e0816c29d0898b5f49da3", "1065a2b8ff3c053438c283781c258fad"], "statement_hash": "1aa4730866ec2f79ebc8e6357544c58ea0603bed69bcd00ef417c5e93b08b413"}, "url": "/docs/compare/?release=11.16#11.16-48ac2b57ea880a41", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "13.7-6a5b3a08c8e30123", "cves": [], "html": "Ensure that contrib/pageinspect functions cope with all-zero pages (Michael Paquier) §
This is a legitimate edge case, but the module was mostly unprepared for it. Arrange to return nulls, or no rows, as appropriate; that seems more useful than raising an error.
", "text": "Ensure that contrib/pageinspect functions cope with all-zero pages (Michael Paquier) § This is a legitimate edge case, but the module was mostly unprepared for it. Arrange to return nulls, or no rows, as appropriate; that seems more useful than raising an error.", "title": "Ensure that contrib/pageinspect functions cope with all-zero pages", "commits": ["2275d044d"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "cf6ddb565b2ebb741eb64941d9d48518883f036da6f59d1eb7cefacd43a439ce", "section_path": ["Changes"], "commit_groups": [["12d32b7bc", "2275d044d", "5378d55cb", "79fed072b", "cd4868a57", "df6bbe73b"]], "identity_text": "Ensure that contrib/pageinspect functions cope with all-zero pages (Michael Paquier) This is a legitimate edge case, but the module was mostly unprepared for it. Arrange to return nulls, or no rows, as appropriate; that seems more useful than raising an error.", "commit_aliases": ["12d32b7bc", "2275d044d", "5378d55cb", "79fed072b", "cd4868a57", "df6bbe73b"], "source_commits": ["2275d044d"], "source_entry_id": "13.7/changes/029", "db_id": "bfe0b6dd19d5cc9a5935136923c14453", "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14", "relations": [{"rule": 2, "type": "equivalent", "target": "6191ffd8e15d53d8989da3a4601b97f4", "evidence": {"same_day": true, "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14"}}, {"rule": 2, "type": "equivalent", "target": "ac629facc0ab6d2ce561818a9622e876", "evidence": {"same_day": true, "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14"}}, {"rule": 2, "type": "equivalent", "target": "e551302d98b39d821362609674fcc686", "evidence": {"same_day": true, "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14"}}, {"rule": 2, "type": "equivalent", "target": "fa0abcafe43664b59c9c2d2232e9842f", "evidence": {"same_day": true, "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14"}}], "version": "13.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "6191ffd8e15d53d8989da3a4601b97f4", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Ensure that contrib/pageinspect functions cope with all-zero pages", "evidence": {"same_day": true, "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14"}, "url": "/docs/compare/?release=14.3#14.3-73e8847f0bbbd8ec", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "ac629facc0ab6d2ce561818a9622e876", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Ensure that contrib/pageinspect functions cope with all-zero pages", "evidence": {"same_day": true, "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14"}, "url": "/docs/compare/?release=12.11#12.11-7ceeb7a6a550aad4", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "fa0abcafe43664b59c9c2d2232e9842f", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Ensure that contrib/pageinspect functions cope with all-zero pages", "evidence": {"same_day": true, "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14"}, "url": "/docs/compare/?release=11.16#11.16-eef5cd7bb1384ae4", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "e551302d98b39d821362609674fcc686", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Ensure that contrib/pageinspect functions cope with all-zero pages", "evidence": {"same_day": true, "patch_ids": ["8ab33d6259c498b53cea69b3ebad4f8b"], "statement_hash": "08ccc5cbe2611baffc6749b8e9ccc5b5ffbaf7dae210a0d3e944e42fd5a39c14"}, "url": "/docs/compare/?release=10.21#10.21-eef5cd7bb1384ae4", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-f0da7fa66068ee81", "cves": [], "html": "In contrib/pageinspect, add defenses against incorrect page “special space” contents, tighten checks for correct page size, and add some missing checks that an index is of the expected type (Michael Paquier, Justin Pryzby, Julien Rouhaud) § § §
These changes make it less likely that the module will crash on bad data.
", "text": "In contrib/pageinspect, add defenses against incorrect page “special space” contents, tighten checks for correct page size, and add some missing checks that an index is of the expected type (Michael Paquier, Justin Pryzby, Julien Rouhaud) § § § These changes make it less likely that the module will crash on bad data.", "title": "In contrib/pageinspect, add defenses against incorrect page “special space” contents, tighten checks for correct page size, and add some missing checks that an index is of the expected type", "commits": ["028a3c6b1", "3d4d6dee0", "d3a9b83c3"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "e3cd502abcf315cb54a4e562ff7b288b0d40f78141ca180014923c77930ee373", "section_path": ["Changes"], "commit_groups": [["028a3c6b1", "07e343513", "09c97746d", "4477dcb20", "5cb770210", "dc5b3bdae"], ["076f4d953", "2389ee8dd", "af8a8eb54", "b61e6214c", "c42b88932", "d3a9b83c3"], ["1a2fdf86a", "27d384441", "291e517a4", "3d4d6dee0", "5ca2aa2f2", "ab80b0fbb"]], "identity_text": "In contrib/pageinspect, add defenses against incorrect page special space contents, tighten checks for correct page size, and add some missing checks that an index is of the expected type (Michael Paquier, Justin Pryzby, Julien Rouhaud) These changes make it less likely that the module will crash on bad data.", "commit_aliases": ["028a3c6b1", "076f4d953", "07e343513", "09c97746d", "1a2fdf86a", "2389ee8dd", "27d384441", "291e517a4", "3d4d6dee0", "4477dcb20", "5ca2aa2f2", "5cb770210", "ab80b0fbb", "af8a8eb54", "b61e6214c", "c42b88932", "d3a9b83c3", "dc5b3bdae"], "source_commits": ["028a3c6b1", "3d4d6dee0", "d3a9b83c3"], "source_entry_id": "13.7/changes/030", "db_id": "f3ec0de8907ed8bd48aa2e24d2ff9051", "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1", "relations": [{"rule": 2, "type": "equivalent", "target": "060ab6b486e576912a33b8a5be3d7986", "evidence": {"same_day": true, "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1"}}, {"rule": 2, "type": "equivalent", "target": "098e6bf95bd71cfb98640d7744439858", "evidence": {"same_day": true, "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1"}}, {"rule": 2, "type": "equivalent", "target": "b78c4305db7549066a102a9ff77dc776", "evidence": {"same_day": true, "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1"}}, {"rule": 2, "type": "equivalent", "target": "dde9027e9aa0573fa1221a6edbd691cb", "evidence": {"same_day": true, "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1"}}], "version": "13.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "060ab6b486e576912a33b8a5be3d7986", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "In contrib/pageinspect, add defenses against incorrect page “special space” contents, tighten checks for correct page size, and add some missing checks that an index is of the expected type", "evidence": {"same_day": true, "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1"}, "url": "/docs/compare/?release=14.3#14.3-3c9236b5f498c8a3", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "dde9027e9aa0573fa1221a6edbd691cb", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "In contrib/pageinspect, add defenses against incorrect page “special space” contents, tighten checks for correct page size, and add some missing checks that an index is of the expected type", "evidence": {"same_day": true, "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1"}, "url": "/docs/compare/?release=12.11#12.11-517cbd25e017e26a", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "098e6bf95bd71cfb98640d7744439858", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "In contrib/pageinspect, add defenses against incorrect page “special space” contents, tighten checks for correct page size, and add some missing checks that an index is of the expected type", "evidence": {"same_day": true, "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1"}, "url": "/docs/compare/?release=11.16#11.16-707eddeed69d6f6b", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "b78c4305db7549066a102a9ff77dc776", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "In contrib/pageinspect, add defenses against incorrect page “special space” contents, tighten checks for correct page size, and add some missing checks that an index is of the expected type", "evidence": {"same_day": true, "patch_ids": ["855b42a8ad9959693aceacf1b2362adc", "8da000940707720fb4b10a212601a0ba", "9ca66143dff59768c448fa29d63f61b8"], "statement_hash": "cf0bdd9de5ad84c3863df965f58afa5ab618fd97a1fcb6164b363778ddf70aa1"}, "url": "/docs/compare/?release=10.21#10.21-707eddeed69d6f6b", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-37691f3afe89cc39", "cves": [], "html": "In contrib/postgres_fdw, verify that ORDER BY clauses are safe to ship before requesting a remotely-ordered query, and include a USING clause if necessary (Ronan Dunklau) §
This fix prevents situations where the remote server might sort in a different order than we intend. While sometimes that would be only cosmetic, it could produce thoroughly wrong results if the remote data is used as input for a locally-performed merge join.
", "text": "In contrib/postgres_fdw, verify that ORDER BY clauses are safe to ship before requesting a remotely-ordered query, and include a USING clause if necessary (Ronan Dunklau) § This fix prevents situations where the remote server might sort in a different order than we intend. While sometimes that would be only cosmetic, it could produce thoroughly wrong results if the remote data is used as input for a locally-performed merge join.", "title": "In contrib/postgres_fdw, verify that ORDER BY clauses are safe to ship before requesting a remotely-ordered query, and include a USING clause if necessary", "commits": ["79df1d20c"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "22399b192a5ada0656785aab25a4a7bd2662690efe74830323c4c650ef52407c", "section_path": ["Changes"], "commit_groups": [["728fc0f9a", "79df1d20c", "989d3e4a2", "9f9489aa2", "b9eb0412f", "f3dd9fe1d"]], "identity_text": "In contrib/postgres_fdw, verify that ORDER BY clauses are safe to ship before requesting a remotely-ordered query, and include a USING clause if necessary (Ronan Dunklau) This fix prevents situations where the remote server might sort in a different order than we intend. While sometimes that would be only cosmetic, it could produce thoroughly wrong results if the remote data is used as input for a locally-performed merge join.", "commit_aliases": ["728fc0f9a", "79df1d20c", "989d3e4a2", "9f9489aa2", "b9eb0412f", "f3dd9fe1d"], "source_commits": ["79df1d20c"], "source_entry_id": "13.7/changes/031", "db_id": "4d12d497d451885c60889308c95c0823", "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f", "relations": [{"rule": 2, "type": "equivalent", "target": "0a310b1d6edafdd573a1fa8c9864b4fc", "evidence": {"same_day": true, "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f"}}, {"rule": 2, "type": "equivalent", "target": "3a5681320ca0fff47d6360af1bffaa6b", "evidence": {"same_day": true, "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f"}}, {"rule": 2, "type": "equivalent", "target": "b840abba475c1568c0a88b3a8610386f", "evidence": {"same_day": true, "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f"}}, {"rule": 2, "type": "equivalent", "target": "eaca980b6aa1c3fc4733353accc0ad86", "evidence": {"same_day": true, "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f"}}], "version": "13.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "0a310b1d6edafdd573a1fa8c9864b4fc", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "In contrib/postgres_fdw, verify that ORDER BY clauses are safe to ship before requesting a remotely-ordered query, and include a USING clause if necessary", "evidence": {"same_day": true, "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f"}, "url": "/docs/compare/?release=14.3#14.3-b9c8663e58947d88", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "b840abba475c1568c0a88b3a8610386f", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "In contrib/postgres_fdw, verify that ORDER BY clauses are safe to ship before requesting a remotely-ordered query, and include a USING clause if necessary", "evidence": {"same_day": true, "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f"}, "url": "/docs/compare/?release=12.11#12.11-cca701d7ed235a61", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "3a5681320ca0fff47d6360af1bffaa6b", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "In contrib/postgres_fdw, verify that ORDER BY clauses are safe to ship before requesting a remotely-ordered query, and include a USING clause if necessary", "evidence": {"same_day": true, "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f"}, "url": "/docs/compare/?release=11.16#11.16-638d67e736664614", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "eaca980b6aa1c3fc4733353accc0ad86", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "In contrib/postgres_fdw, verify that ORDER BY clauses are safe to ship before requesting a remotely-ordered query, and include a USING clause if necessary", "evidence": {"same_day": true, "patch_ids": ["c602880703239f008be80868c7e5e14b"], "statement_hash": "e04a05f9174546572536f14d030fc54061c8ef18b84c673e9796dbfbda598b6f"}, "url": "/docs/compare/?release=10.21#10.21-638d67e736664614", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-c2d663cf361b5759", "cves": [], "html": "Update JIT code to work with LLVM 14 (Thomas Munro) §
", "text": "Update JIT code to work with LLVM 14 (Thomas Munro) §", "title": "Update JIT code to work with LLVM 14", "commits": ["5610411ac"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "e8f488fceb63b6ab4ac0570fea9b88e63195e402b768d7f0f436530e3d15cd6e", "section_path": ["Changes"], "commit_groups": [["45a469eb2", "5610411ac", "986d24042", "d9f7ad54e"], ["807fee1a3"], ["a56e7b660"], ["e6a760020"]], "identity_text": "Update JIT code to work with LLVM 14 (Thomas Munro)", "commit_aliases": ["45a469eb2", "5610411ac", "807fee1a3", "986d24042", "a56e7b660", "d9f7ad54e", "e6a760020"], "source_commits": ["5610411ac", "807fee1a3", "a56e7b660", "e6a760020"], "source_entry_id": "13.7/changes/032", "db_id": "9bc3515338a3cb1c7cb330415a6fd1b7", "patch_ids": ["2bfa44b3cc8e5dd9ebcd44dd6ad7329f", "bbf5e53e6f226749d3a8e07211bb1f80", "ce2e178820b06375db5e23d8738920ac", "fb4f51c19adfa0e5c36b68d562bd59b9"], "statement_hash": "8fa29fee1dffd922edb7b94688ad3332eae78aa2483f617577894d9e7b61f0fd", "relations": [{"rule": 2, "type": "equivalent", "target": "6dbca2ccbeb3d820e4f3c61ff3127fbf", "evidence": {"same_day": true, "patch_ids": ["2bfa44b3cc8e5dd9ebcd44dd6ad7329f", "bbf5e53e6f226749d3a8e07211bb1f80", "ce2e178820b06375db5e23d8738920ac", "fb4f51c19adfa0e5c36b68d562bd59b9"], "statement_hash": "8fa29fee1dffd922edb7b94688ad3332eae78aa2483f617577894d9e7b61f0fd"}}, {"rule": 2, "type": "equivalent", "target": "9cad89e55bd9cb67c762c6445ec42106", "evidence": {"same_day": true, "patch_ids": ["2bfa44b3cc8e5dd9ebcd44dd6ad7329f", "bbf5e53e6f226749d3a8e07211bb1f80", "ce2e178820b06375db5e23d8738920ac", "fb4f51c19adfa0e5c36b68d562bd59b9"], "statement_hash": "8fa29fee1dffd922edb7b94688ad3332eae78aa2483f617577894d9e7b61f0fd"}}, {"rule": 2, "type": "equivalent", "target": "bbc59affca8ba7468f63e5c50e11ac84", "evidence": {"same_day": true, "patch_ids": ["2bfa44b3cc8e5dd9ebcd44dd6ad7329f", "bbf5e53e6f226749d3a8e07211bb1f80", "ce2e178820b06375db5e23d8738920ac", "fb4f51c19adfa0e5c36b68d562bd59b9"], "statement_hash": "8fa29fee1dffd922edb7b94688ad3332eae78aa2483f617577894d9e7b61f0fd"}}], "version": "13.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "6dbca2ccbeb3d820e4f3c61ff3127fbf", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Update JIT code to work with LLVM 14", "evidence": {"same_day": true, "patch_ids": ["2bfa44b3cc8e5dd9ebcd44dd6ad7329f", "bbf5e53e6f226749d3a8e07211bb1f80", "ce2e178820b06375db5e23d8738920ac", "fb4f51c19adfa0e5c36b68d562bd59b9"], "statement_hash": "8fa29fee1dffd922edb7b94688ad3332eae78aa2483f617577894d9e7b61f0fd"}, "url": "/docs/compare/?release=14.3#14.3-47a72e7b39c3bb96", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "bbc59affca8ba7468f63e5c50e11ac84", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Update JIT code to work with LLVM 14", "evidence": {"same_day": true, "patch_ids": ["2bfa44b3cc8e5dd9ebcd44dd6ad7329f", "bbf5e53e6f226749d3a8e07211bb1f80", "ce2e178820b06375db5e23d8738920ac", "fb4f51c19adfa0e5c36b68d562bd59b9"], "statement_hash": "8fa29fee1dffd922edb7b94688ad3332eae78aa2483f617577894d9e7b61f0fd"}, "url": "/docs/compare/?release=12.11#12.11-122fe568dd4607b1", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "9cad89e55bd9cb67c762c6445ec42106", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Update JIT code to work with LLVM 14", "evidence": {"same_day": true, "patch_ids": ["2bfa44b3cc8e5dd9ebcd44dd6ad7329f", "bbf5e53e6f226749d3a8e07211bb1f80", "ce2e178820b06375db5e23d8738920ac", "fb4f51c19adfa0e5c36b68d562bd59b9"], "statement_hash": "8fa29fee1dffd922edb7b94688ad3332eae78aa2483f617577894d9e7b61f0fd"}, "url": "/docs/compare/?release=11.16#11.16-46cfbfa50408b7a1", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}]}, {"id": "13.7-38fb84e955f1b0fe", "cves": [], "html": "Clean up assorted failures under clang's -fsanitize=undefined checks (Tom Lane, Andres Freund, Zhihong Yu) § § § § §
Most of these changes are just for pro-forma compliance with the letter of the C and POSIX standards, and are unlikely to have any effect on production builds.
", "text": "Clean up assorted failures under clang's -fsanitize=undefined checks (Tom Lane, Andres Freund, Zhihong Yu) § § § § § Most of these changes are just for pro-forma compliance with the letter of the C and POSIX standards, and are unlikely to have any effect on production builds.", "title": "Clean up assorted failures under clang's -fsanitize=undefined checks", "commits": ["1a027e6b7", "7c163aa93", "8014c61eb", "97031f440", "c0f99bb52"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "55ea4e015293e38d45b7978d92f0b23af18f97132851a789560c98071a169a90", "section_path": ["Changes"], "commit_groups": [["0fbdfaf79", "18c04d157", "4b0696b36", "566e1c04d", "5c9d17e94", "97031f440"], ["1a027e6b7", "46ab07ffd", "b0bc196e5", "cfbe87bd6", "f2087e26e", "f727b6ea8"], ["1c6bb380e", "2121d5809", "5f4615b9d", "8014c61eb", "89a94c24a", "c5b60a68c"], ["2a9193726", "6a767bc2e", "7c163aa93", "a77dddb42", "e52e9bd57", "e71c76fca"], ["3ac7d0241", "61a007fee", "81045e1e1", "c0f99bb52"]], "identity_text": "Clean up assorted failures under clang's -fsanitize=undefined checks (Tom Lane, Andres Freund, Zhihong Yu) Most of these changes are just for pro-forma compliance with the letter of the C and POSIX standards, and are unlikely to have any effect on production builds.", "commit_aliases": ["0fbdfaf79", "18c04d157", "1a027e6b7", "1c6bb380e", "2121d5809", "2a9193726", "3ac7d0241", "46ab07ffd", "4b0696b36", "566e1c04d", "5c9d17e94", "5f4615b9d", "61a007fee", "6a767bc2e", "7c163aa93", "8014c61eb", "81045e1e1", "89a94c24a", "97031f440", "a77dddb42", "b0bc196e5", "c0f99bb52", "c5b60a68c", "cfbe87bd6", "e52e9bd57", "e71c76fca", "f2087e26e", "f727b6ea8"], "source_commits": ["1a027e6b7", "7c163aa93", "8014c61eb", "97031f440", "c0f99bb52"], "source_entry_id": "13.7/changes/033", "db_id": "f6600566bc0907e18a48fb7684eacda6", "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942", "relations": [{"rule": 2, "type": "equivalent", "target": "1ba55827f92e2c6ea9cfec3ca73ab12e", "evidence": {"same_day": true, "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942"}}, {"rule": 2, "type": "equivalent", "target": "353fc8fa668aded1c66902f54af68647", "evidence": {"same_day": true, "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942"}}, {"rule": 2, "type": "equivalent", "target": "a0790335ab7f1b0c63f65ceb5ab63a5c", "evidence": {"same_day": true, "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942"}}, {"rule": 2, "type": "equivalent", "target": "d228dc7accd64617730fb4fcbf8aae50", "evidence": {"same_day": true, "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942"}}], "version": "13.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "1ba55827f92e2c6ea9cfec3ca73ab12e", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Clean up assorted failures under clang's -fsanitize=undefined checks", "evidence": {"same_day": true, "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942"}, "url": "/docs/compare/?release=14.3#14.3-cc9c7d2bfe015357", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "d228dc7accd64617730fb4fcbf8aae50", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Clean up assorted failures under clang's -fsanitize=undefined checks", "evidence": {"same_day": true, "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942"}, "url": "/docs/compare/?release=12.11#12.11-195a4e6ea629c9ef", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "a0790335ab7f1b0c63f65ceb5ab63a5c", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Clean up assorted failures under clang's -fsanitize=undefined checks", "evidence": {"same_day": true, "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942"}, "url": "/docs/compare/?release=11.16#11.16-999c7ee9199fa77d", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "353fc8fa668aded1c66902f54af68647", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Clean up assorted failures under clang's -fsanitize=undefined checks", "evidence": {"same_day": true, "patch_ids": ["0dd69d275262fc3d302f27360b63a26c", "514b7f83036bed711e93847ee1c74e69", "a5d5c23b7c291f9aca560a4677539954", "d652e4a690a1042c68db92842349e02a", "e1ef61bbc9a0f163bdf871952d35854e"], "statement_hash": "3063fef579ae04837c00c7570d88dad4b63ae2ff5269f5125c2da91f1ac70942"}, "url": "/docs/compare/?release=10.21#10.21-999c7ee9199fa77d", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-a40674cdee3d1d18", "cves": [], "html": "Fix PL/Perl so it builds on C compilers that don't support statements nested within expressions (Tom Lane) §
", "text": "Fix PL/Perl so it builds on C compilers that don't support statements nested within expressions (Tom Lane) §", "title": "Fix PL/Perl so it builds on C compilers that don't support statements nested within expressions", "commits": ["5ea3b99de"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "b69845de9260264a0675ab86e427881e7d6ddb3d37637fd2bdf8d572fb5fb67e", "section_path": ["Changes"], "commit_groups": [["1a8b6f055", "3a6e3a890", "5ea3b99de", "d5c2a91e5", "e327291e4", "eba0f095c"]], "identity_text": "Fix PL/Perl so it builds on C compilers that don't support statements nested within expressions (Tom Lane)", "commit_aliases": ["1a8b6f055", "3a6e3a890", "5ea3b99de", "d5c2a91e5", "e327291e4", "eba0f095c"], "source_commits": ["5ea3b99de"], "source_entry_id": "13.7/changes/034", "db_id": "96b56feff8862e295303f535aa5944ac", "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7", "relations": [{"rule": 2, "type": "equivalent", "target": "6fafea750d6291d1e58805ed19286913", "evidence": {"same_day": true, "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7"}}, {"rule": 2, "type": "equivalent", "target": "8526092f304acb2e40c18ccdadfd4900", "evidence": {"same_day": true, "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7"}}, {"rule": 2, "type": "equivalent", "target": "95fc5e39fc229c01b37b16cc4d19feb7", "evidence": {"same_day": true, "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7"}}, {"rule": 2, "type": "equivalent", "target": "dfbd146779579adaf8b4852554ca08d6", "evidence": {"same_day": true, "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7"}}], "version": "13.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "95fc5e39fc229c01b37b16cc4d19feb7", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Fix PL/Perl so it builds on C compilers that don't support statements nested within expressions", "evidence": {"same_day": true, "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7"}, "url": "/docs/compare/?release=14.3#14.3-e20812ae73528fc9", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "dfbd146779579adaf8b4852554ca08d6", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Fix PL/Perl so it builds on C compilers that don't support statements nested within expressions", "evidence": {"same_day": true, "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7"}, "url": "/docs/compare/?release=12.11#12.11-f9c55ea5b95087d8", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "8526092f304acb2e40c18ccdadfd4900", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Fix PL/Perl so it builds on C compilers that don't support statements nested within expressions", "evidence": {"same_day": true, "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7"}, "url": "/docs/compare/?release=11.16#11.16-d2e0eddb6959bbf9", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "6fafea750d6291d1e58805ed19286913", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Fix PL/Perl so it builds on C compilers that don't support statements nested within expressions", "evidence": {"same_day": true, "patch_ids": ["d41acf7eaed2c10cc521af8bea1bac53"], "statement_hash": "3ae0b08f64ec20da1c034181096ebacdf0f2cbe6edb3b8b1e9a76b9773cb3ab7"}, "url": "/docs/compare/?release=10.21#10.21-d2e0eddb6959bbf9", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-21e3f1962bbc0d9b", "cves": [], "html": "Fix possible build failure of pg_dumpall on Windows, when not using MSVC to build (Andres Freund) §
", "text": "Fix possible build failure of pg_dumpall on Windows, when not using MSVC to build (Andres Freund) §", "title": "Fix possible build failure of pg_dumpall on Windows, when not using MSVC to build", "commits": ["f183e23cc"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "9754fa75fff13ecd48762e9e87ee8a4fe4f5fcb71394bcd433814dbfe8bb9c43", "section_path": ["Changes"], "commit_groups": [["083031aa9", "097786fbb", "2d608c960", "4553b960f", "cd1951ba0", "f183e23cc"]], "identity_text": "Fix possible build failure of pg_dumpall on Windows, when not using MSVC to build (Andres Freund)", "commit_aliases": ["083031aa9", "097786fbb", "2d608c960", "4553b960f", "cd1951ba0", "f183e23cc"], "source_commits": ["f183e23cc"], "source_entry_id": "13.7/changes/035", "db_id": "b135168dd83c102cae7007b575a5a268", "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c", "relations": [{"rule": 2, "type": "equivalent", "target": "136dec1ec7cc4cd6cd615874cc7d068d", "evidence": {"same_day": true, "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c"}}, {"rule": 2, "type": "equivalent", "target": "7a559b3239971072b49defcf79e20758", "evidence": {"same_day": true, "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c"}}, {"rule": 2, "type": "equivalent", "target": "dd0986eb3f544ad27adf0fbc2b79d8d0", "evidence": {"same_day": true, "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c"}}, {"rule": 2, "type": "equivalent", "target": "ea09b650605ce0e5102cfb939e448aac", "evidence": {"same_day": true, "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c"}}], "version": "13.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "136dec1ec7cc4cd6cd615874cc7d068d", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Fix possible build failure of pg_dumpall on Windows, when not using MSVC to build", "evidence": {"same_day": true, "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c"}, "url": "/docs/compare/?release=14.3#14.3-c8ab89c0f28e83c6", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "dd0986eb3f544ad27adf0fbc2b79d8d0", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Fix possible build failure of pg_dumpall on Windows, when not using MSVC to build", "evidence": {"same_day": true, "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c"}, "url": "/docs/compare/?release=12.11#12.11-a9beb79d03d2529d", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "ea09b650605ce0e5102cfb939e448aac", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Fix possible build failure of pg_dumpall on Windows, when not using MSVC to build", "evidence": {"same_day": true, "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c"}, "url": "/docs/compare/?release=11.16#11.16-e382c1bdda807917", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "7a559b3239971072b49defcf79e20758", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Fix possible build failure of pg_dumpall on Windows, when not using MSVC to build", "evidence": {"same_day": true, "patch_ids": ["53eba1003de2950ed67dfbff031905c0"], "statement_hash": "ade62856fe2c126dc52f3359f370bd99b3166ff4a2a76cc2ec5b1addabd7a70c"}, "url": "/docs/compare/?release=10.21#10.21-e382c1bdda807917", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-2427c69aa60b6085", "cves": [], "html": "In Windows builds, use gendef instead of pexports to build DEF files (Andrew Dunstan) §
\nThis adapts the build process to work on recent MSys tool chains.
", "text": "In Windows builds, use gendef instead of pexports to build DEF files (Andrew Dunstan) § This adapts the build process to work on recent MSys tool chains.", "title": "In Windows builds, use gendef instead of pexports to build DEF files", "commits": ["eec7c640f"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "a084c2ee8abe5ff81e05d5d80420fe9bddc5d08bb4e6a4c5fe27500cdebff50c", "section_path": ["Changes"], "commit_groups": [["3a5034b5e", "622ab6a34", "64dd64807", "92f60f536", "a5eef80c2", "c76164ea0", "e2d104e19", "ea09a75e1", "eec7c640f"]], "identity_text": "In Windows builds, use gendef instead of pexports to build DEF files (Andrew Dunstan) This adapts the build process to work on recent MSys tool chains.", "commit_aliases": ["3a5034b5e", "622ab6a34", "64dd64807", "92f60f536", "a5eef80c2", "c76164ea0", "e2d104e19", "ea09a75e1", "eec7c640f"], "source_commits": ["eec7c640f"], "source_entry_id": "13.7/changes/036", "db_id": "d0633561b5bfb357c77b8a40fd8f5e25", "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481", "relations": [{"rule": 2, "type": "equivalent", "target": "38602682966155948dd26cd8216edbb9", "evidence": {"same_day": true, "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481"}}, {"rule": 2, "type": "equivalent", "target": "55e5a5f8857f60ac511eb488d2861179", "evidence": {"same_day": true, "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481"}}, {"rule": 2, "type": "equivalent", "target": "57262888cf6c5f577a5b3183ebff660b", "evidence": {"same_day": true, "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481"}}, {"rule": 2, "type": "equivalent", "target": "cc44da5011e0a29d2b43d6eb82ebb151", "evidence": {"same_day": true, "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481"}}], "version": "13.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "57262888cf6c5f577a5b3183ebff660b", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "In Windows builds, use gendef instead of pexports to build DEF files", "evidence": {"same_day": true, "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481"}, "url": "/docs/compare/?release=14.3#14.3-81a042fc4b04b977", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "cc44da5011e0a29d2b43d6eb82ebb151", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "In Windows builds, use gendef instead of pexports to build DEF files", "evidence": {"same_day": true, "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481"}, "url": "/docs/compare/?release=12.11#12.11-83962fae8e47a715", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "38602682966155948dd26cd8216edbb9", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "In Windows builds, use gendef instead of pexports to build DEF files", "evidence": {"same_day": true, "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481"}, "url": "/docs/compare/?release=11.16#11.16-86e9673c0234341a", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "55e5a5f8857f60ac511eb488d2861179", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "In Windows builds, use gendef instead of pexports to build DEF files", "evidence": {"same_day": true, "patch_ids": ["9764c0e504424a4795b055398b9ced43"], "statement_hash": "a0badcac28edbb02afb253aa37416e89ca737e75ff377504f5c3bb83c2edf481"}, "url": "/docs/compare/?release=10.21#10.21-86e9673c0234341a", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-193de4c12bd1c5bc", "cves": [], "html": "Prevent extra expansion of shell wildcard patterns in programs built under MinGW (Andrew Dunstan) §
\nFor some reason the C library provided by MinGW will expand shell wildcard characters in a program's command-line arguments by default. This is confusing, not least because it doesn't happen under MSVC, so turn it off.
", "text": "Prevent extra expansion of shell wildcard patterns in programs built under MinGW (Andrew Dunstan) § For some reason the C library provided by MinGW will expand shell wildcard characters in a program's command-line arguments by default. This is confusing, not least because it doesn't happen under MSVC, so turn it off.", "title": "Prevent extra expansion of shell wildcard patterns in programs built under MinGW", "commits": ["d9cede2c3"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "b5adba3d7cf546ee78f599c39465dbda4d54ddc7d2adcc905c4208ee80bb7d17", "section_path": ["Changes"], "commit_groups": [["01f2bc5af", "58887d58c", "71f394667", "b787c554c", "b90ce0dd7", "d9cede2c3"]], "identity_text": "Prevent extra expansion of shell wildcard patterns in programs built under MinGW (Andrew Dunstan) For some reason the C library provided by MinGW will expand shell wildcard characters in a program's command-line arguments by default. This is confusing, not least because it doesn't happen under MSVC, so turn it off.", "commit_aliases": ["01f2bc5af", "58887d58c", "71f394667", "b787c554c", "b90ce0dd7", "d9cede2c3"], "source_commits": ["d9cede2c3"], "source_entry_id": "13.7/changes/037", "db_id": "24641f84a59b30379e129e690ef2b967", "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7", "relations": [{"rule": 2, "type": "equivalent", "target": "3132fffa1766a85302e18428b852d9c1", "evidence": {"same_day": true, "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7"}}, {"rule": 2, "type": "equivalent", "target": "cb5bc30d2bb9bca6ad937c232ba3f3d3", "evidence": {"same_day": true, "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7"}}, {"rule": 2, "type": "equivalent", "target": "f4ddbc73c7844f2cbb2ee355f9e76775", "evidence": {"same_day": true, "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7"}}, {"rule": 2, "type": "equivalent", "target": "f89d93baa0ca465846f88287eb623da7", "evidence": {"same_day": true, "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7"}}], "version": "13.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f89d93baa0ca465846f88287eb623da7", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Prevent extra expansion of shell wildcard patterns in programs built under MinGW", "evidence": {"same_day": true, "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7"}, "url": "/docs/compare/?release=14.3#14.3-051c3424c7635887", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "f4ddbc73c7844f2cbb2ee355f9e76775", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Prevent extra expansion of shell wildcard patterns in programs built under MinGW", "evidence": {"same_day": true, "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7"}, "url": "/docs/compare/?release=12.11#12.11-4ad00e23c24660ab", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "3132fffa1766a85302e18428b852d9c1", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Prevent extra expansion of shell wildcard patterns in programs built under MinGW", "evidence": {"same_day": true, "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7"}, "url": "/docs/compare/?release=11.16#11.16-89736f5fb4c299b0", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "cb5bc30d2bb9bca6ad937c232ba3f3d3", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Prevent extra expansion of shell wildcard patterns in programs built under MinGW", "evidence": {"same_day": true, "patch_ids": ["79ece83653c1ea395afa16ed15c15142"], "statement_hash": "6af4af0ec380777b31629826decb1af825d7143bed418cbd0ecc64b8c73857b7"}, "url": "/docs/compare/?release=10.21#10.21-89736f5fb4c299b0", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}, {"id": "13.7-6acaf1c4d3653dec", "cves": [], "html": "Update time zone data files to tzdata release 2022a for DST law changes in Palestine, plus historical corrections for Chile and Ukraine. (Tom Lane) §
", "text": "Update time zone data files to tzdata release 2022a for DST law changes in Palestine, plus historical corrections for Chile and Ukraine. (Tom Lane) §", "title": "Update time zone data files to tzdata release 2022a for DST law changes in Palestine, plus historical corrections for Chile and Ukraine.", "commits": ["e9735d1af"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/13.7/#id-1.11.6.22.5", "source_hash": "e0353961bcad3dac263ecef0235c16dfdfb5a0b890e4d276076884c3cbe586ae", "section_path": ["Changes"], "commit_groups": [["2bb9f7501", "77ee14ed9", "ab3479bf5", "bc334ec9f", "da72ff09b", "e9735d1af"]], "identity_text": "Update time zone data files to tzdata release 2022a for DST law changes in Palestine, plus historical corrections for Chile and Ukraine. (Tom Lane)", "commit_aliases": ["2bb9f7501", "77ee14ed9", "ab3479bf5", "bc334ec9f", "da72ff09b", "e9735d1af"], "source_commits": ["e9735d1af"], "source_entry_id": "13.7/changes/038", "db_id": "9f6b656c627674cf49a116215c8cad0f", "patch_ids": ["afac83603605cad010e22cefc1e1d288"], "statement_hash": "bce26289d7f7c07546e4d6cc760b6fe5f21606c5e4b2ee68bc4bef5142a90032", "relations": [{"rule": 2, "type": "equivalent", "target": "39da68ea256e3f02b57d4a358143919b", "evidence": {"same_day": true, "patch_ids": ["afac83603605cad010e22cefc1e1d288"], "statement_hash": "bce26289d7f7c07546e4d6cc760b6fe5f21606c5e4b2ee68bc4bef5142a90032"}}, {"rule": 2, "type": "equivalent", "target": "488b0c51a051523d2d93074eff3f63d6", "evidence": {"same_day": true, "patch_ids": ["afac83603605cad010e22cefc1e1d288"]}}, {"rule": 2, "type": "equivalent", "target": "70f22e6f1a90f4854ab95213c75fb6cc", "evidence": {"same_day": true, "patch_ids": ["afac83603605cad010e22cefc1e1d288"]}}, {"rule": 2, "type": "equivalent", "target": "b1e39c9b8af63dee0774bd1afb5933d8", "evidence": {"same_day": true, "patch_ids": ["afac83603605cad010e22cefc1e1d288"], "statement_hash": "bce26289d7f7c07546e4d6cc760b6fe5f21606c5e4b2ee68bc4bef5142a90032"}}], "version": "13.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b1e39c9b8af63dee0774bd1afb5933d8", "kind": "equivalent", "version": "14.3", "label": "14.3", "title": "Update time zone data files to tzdata release 2022a for DST law changes in Palestine, plus historical corrections for Chile and Ukraine.", "evidence": {"same_day": true, "patch_ids": ["afac83603605cad010e22cefc1e1d288"], "statement_hash": "bce26289d7f7c07546e4d6cc760b6fe5f21606c5e4b2ee68bc4bef5142a90032"}, "url": "/docs/compare/?release=14.3#14.3-f0d1b98fe7331ec6", "source_url": "/docs/release/14.3/#id-1.11.6.27.5"}, {"db_id": "39da68ea256e3f02b57d4a358143919b", "kind": "equivalent", "version": "12.11", "label": "12.11", "title": "Update time zone data files to tzdata release 2022a for DST law changes in Palestine, plus historical corrections for Chile and Ukraine.", "evidence": {"same_day": true, "patch_ids": ["afac83603605cad010e22cefc1e1d288"], "statement_hash": "bce26289d7f7c07546e4d6cc760b6fe5f21606c5e4b2ee68bc4bef5142a90032"}, "url": "/docs/compare/?release=12.11#12.11-f733876a271a1f8c", "source_url": "/docs/release/12.11/#id-1.11.6.17.5"}, {"db_id": "488b0c51a051523d2d93074eff3f63d6", "kind": "equivalent", "version": "11.16", "label": "11.16", "title": "Update time zone data files to tzdata release 2022a for DST law changes in Palestine, plus historical corrections for Chile and Ukraine.", "evidence": {"same_day": true, "patch_ids": ["afac83603605cad010e22cefc1e1d288"]}, "url": "/docs/compare/?release=11.16#11.16-0f574b2b7533e171", "source_url": "/docs/release/11.16/#id-1.11.6.11.5"}, {"db_id": "70f22e6f1a90f4854ab95213c75fb6cc", "kind": "equivalent", "version": "10.21", "label": "10.21", "title": "Update time zone data files to tzdata release 2022a for DST law changes in Palestine, plus historical corrections for Chile and Ukraine.", "evidence": {"same_day": true, "patch_ids": ["afac83603605cad010e22cefc1e1d288"]}, "url": "/docs/compare/?release=10.21#10.21-0f574b2b7533e171", "source_url": "/docs/release/10.21/#id-1.11.6.7.6"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 38}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 20}, {"key": "security", "label": "Security", "count": 1}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 17}], "total": 38, "release_count": 1, "cross_major": false, "cve_count": 1, "cves": [{"id": "CVE-2022-1552", "url": "https://www.postgresql.org/support/security/CVE-2022-1552/", "fixed": {"10": "10.21", "11": "11.16", "12": "12.11", "13": "13.7", "14": "14.3"}, "score": 8.8, "title": "Confine additional operations within “security restricted operation” sandboxes", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H", "affected": {"10": "10", "11": "11", "12": "12", "13": "13", "14": "14"}, "component": "core server", "published": {"10": "2022-05-12", "11": "2022-05-12", "12": "2022-05-12", "13": "2022-05-12", "14": "2022-05-12"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Autovacuum, REINDEX , CREATE INDEX , REFRESH MATERIALIZED VIEW , CLUSTER , and pg_amcheck made incomplete efforts to operate safely when a privileged user is maintaining another user's objects. Those commands activated relevant protections too late or not at all. An attacker having permission to create non-temp objects in at least one schema could execute arbitrary SQL functions under a superuser identity.\n\nWhile promptly updating PostgreSQL is the best remediation for most users, a user unable to do that can work around the vulnerability by disabling autovacuum, not manually running the above commands, and not restoring from output of the pg_dump command. Performance may degrade quickly under this workaround. VACUUM is safe, and all commands are fine when a trusted user owns the target object.\n\nThe PostgreSQL project thanks Alexander Lakhin for reporting this problem.", "first_published": "2022-05-12", "fixed_version": "13.7"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 38, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}