A dump/restore is not required for those running 16.X.
\nHowever, if you are upgrading from a version earlier than 16.10, see Section E.6.
", "compatibility_count": 0, "label": "16.14", "status_label": "Supported", "eol": "2028-11-09", "age_days": 135, "support_days": 775}, "groups": [{"date": "2026-05-14", "build": "16.14", "major": "16", "minor": 14, "manual": "16", "status": "stable", "doc_git": "", "version": "16.14", "eol_date": "2028-11-09", "date_text": "2026-05-14", "supported": true, "manual_url": "/docs/16/release-16-14.html", "source_url": "/docs/release/16.14/", "entry_count": 50, "placeholder": false, "content_hash": "63b537936e710d863b01db748292d24e0be90652e58566ec5db999f922bac656", "manual_build": "16.15", "source_as_of": "", "changes_count": 50, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 16.X.
\nHowever, if you are upgrading from a version earlier than 16.10, see Section E.6.
", "compatibility_count": 0, "label": "16.14", "status_label": "Supported", "eol": "2028-11-09", "age_days": 135, "support_days": 775, "entries": [{"id": "16.14-f224cad17d1e5128", "cves": ["CVE-2026-6479"], "html": "Prevent unbounded recursion while processing startup packets (Michael Paquier) § §
\nA malicious client could crash the connected backend by alternating rejected SSL and GSS encryption requests indefinitely.
\nThe PostgreSQL Project thanks Calif.io (in collaboration with Claude and Anthropic Research) for reporting this problem. (CVE-2026-6479)
", "text": "Prevent unbounded recursion while processing startup packets (Michael Paquier) § § A malicious client could crash the connected backend by alternating rejected SSL and GSS encryption requests indefinitely. The PostgreSQL Project thanks Calif.io (in collaboration with Claude and Anthropic Research) for reporting this problem. (CVE-2026-6479)", "title": "Prevent unbounded recursion while processing startup packets", "commits": ["66cf26b9e", "c2e6ef863"], "section": "Changes", "category": "security", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "ba943d19f4d19e150ef40eec07a2904c2fe844524b5126c2a4b870291e71d8dd", "section_path": ["Changes"], "commit_groups": [["14a4a7040", "16fda4df6", "6dffaeb8e", "c2e6ef863"], ["32a4ce55c", "3b4e66739", "3fb66d302", "66cf26b9e", "b63f25bdd", "f7a191f53"]], "identity_text": "Prevent unbounded recursion while processing startup packets (Michael Paquier) A malicious client could crash the connected backend by alternating rejected SSL and GSS encryption requests indefinitely. The PostgreSQL Project thanks Calif.io (in collaboration with Claude and Anthropic Research) for reporting this problem. (CVE-2026-6479)", "commit_aliases": ["14a4a7040", "16fda4df6", "32a4ce55c", "3b4e66739", "3fb66d302", "66cf26b9e", "6dffaeb8e", "b63f25bdd", "c2e6ef863", "f7a191f53"], "source_commits": ["66cf26b9e", "c2e6ef863"], "source_entry_id": "16.14/changes/001", "db_id": "473b135d9b59dfa88e1611d1141570ee", "patch_ids": ["4309351724f2df44d6eb12d700f03a90", "fce882e6fdda4deccb44245cc5966b20"], "statement_hash": "879026f1f07a4d172337b9e457cc300e4ed2d558396bcc627770e4ef108f69d4", "relations": [{"rule": 2, "type": "equivalent", "target": "1ca6ff4a849ed2960fad43a403e2b932", "evidence": {"same_day": true, "patch_ids": ["4309351724f2df44d6eb12d700f03a90", "fce882e6fdda4deccb44245cc5966b20"], "statement_hash": "879026f1f07a4d172337b9e457cc300e4ed2d558396bcc627770e4ef108f69d4"}}, {"rule": 2, "type": "equivalent", "target": "3d1e0d9f6f6214fb84bb4b9d4f9402aa", "evidence": {"same_day": true, "patch_ids": ["4309351724f2df44d6eb12d700f03a90", "fce882e6fdda4deccb44245cc5966b20"], "statement_hash": "879026f1f07a4d172337b9e457cc300e4ed2d558396bcc627770e4ef108f69d4"}}, {"rule": 2, "type": "equivalent", "target": "91cb80c58929d3256c8543b647d98328", "evidence": {"same_day": true, "patch_ids": ["4309351724f2df44d6eb12d700f03a90", "fce882e6fdda4deccb44245cc5966b20"], "statement_hash": "879026f1f07a4d172337b9e457cc300e4ed2d558396bcc627770e4ef108f69d4"}}, {"rule": 2, "type": "equivalent", "target": "e49a23129f6590195a74fcbcc51115f9", "evidence": {"same_day": true, "patch_ids": ["4309351724f2df44d6eb12d700f03a90", "fce882e6fdda4deccb44245cc5966b20"], "statement_hash": "879026f1f07a4d172337b9e457cc300e4ed2d558396bcc627770e4ef108f69d4"}}], "version": "16.14", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "1ca6ff4a849ed2960fad43a403e2b932", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Prevent unbounded recursion while processing startup packets", "evidence": {"same_day": true, "patch_ids": ["4309351724f2df44d6eb12d700f03a90", "fce882e6fdda4deccb44245cc5966b20"], "statement_hash": "879026f1f07a4d172337b9e457cc300e4ed2d558396bcc627770e4ef108f69d4"}, "url": "/docs/compare/?release=18.4#18.4-63ab78ae660e7424", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "91cb80c58929d3256c8543b647d98328", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Prevent unbounded recursion while processing startup packets", "evidence": {"same_day": true, "patch_ids": ["4309351724f2df44d6eb12d700f03a90", "fce882e6fdda4deccb44245cc5966b20"], "statement_hash": "879026f1f07a4d172337b9e457cc300e4ed2d558396bcc627770e4ef108f69d4"}, "url": "/docs/compare/?release=17.10#17.10-11e46f0b0085f2d6", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "e49a23129f6590195a74fcbcc51115f9", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Prevent unbounded recursion while processing startup packets", "evidence": {"same_day": true, "patch_ids": ["4309351724f2df44d6eb12d700f03a90", "fce882e6fdda4deccb44245cc5966b20"], "statement_hash": "879026f1f07a4d172337b9e457cc300e4ed2d558396bcc627770e4ef108f69d4"}, "url": "/docs/compare/?release=15.18#15.18-6e37155a4c84008d", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "3d1e0d9f6f6214fb84bb4b9d4f9402aa", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Prevent unbounded recursion while processing startup packets", "evidence": {"same_day": true, "patch_ids": ["4309351724f2df44d6eb12d700f03a90", "fce882e6fdda4deccb44245cc5966b20"], "statement_hash": "879026f1f07a4d172337b9e457cc300e4ed2d558396bcc627770e4ef108f69d4"}, "url": "/docs/compare/?release=14.23#14.23-c632f730b154b207", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-effcbd2d1a71fba3", "cves": ["CVE-2026-6473"], "html": "Fix assorted integer overflows in memory-allocation calculations (Tom Lane, Nathan Bossart, Heikki Linnakangas) § § § § § § § § § §
\nVarious places were incautious about the possibility of integer overflow in calculations of how much memory to allocate. Overflow would lead to allocating a too-small buffer which the caller would then write past the end of. This would at least trigger server crashes, and probably could be exploited for arbitrary code execution. In many but by no means all cases, the hazard exists only in 32-bit builds.
\nThe PostgreSQL Project thanks Xint Code, Bruce Dang, Sven Klemm, and Pavel Kohout for reporting these problems. (CVE-2026-6473)
", "text": "Fix assorted integer overflows in memory-allocation calculations (Tom Lane, Nathan Bossart, Heikki Linnakangas) § § § § § § § § § § Various places were incautious about the possibility of integer overflow in calculations of how much memory to allocate. Overflow would lead to allocating a too-small buffer which the caller would then write past the end of. This would at least trigger server crashes, and probably could be exploited for arbitrary code execution. In many but by no means all cases, the hazard exists only in 32-bit builds. The PostgreSQL Project thanks Xint Code, Bruce Dang, Sven Klemm, and Pavel Kohout for reporting these problems. (CVE-2026-6473)", "title": "Fix assorted integer overflows in memory-allocation calculations", "commits": ["32c525eb6", "47dae5e74", "924b3e943", "a4f089c79", "aff71f87b", "c25973124", "cfb610eaa", "e24fb3247", "e42598a41", "f20b84081"], "section": "Changes", "category": "security", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "ad9d5153c05e06e431cf866cdf4523aefb770b61ac54188e8f2c700a5f831086", "section_path": ["Changes"], "commit_groups": [["00e243e67", "37842f3dc", "924b3e943", "c7fb9f765", "d75b1dc96"], ["01b5ef7df", "01e568b8c", "4032c9d98", "aff71f87b", "c55cea529", "e31ef0720"], ["066b7b144", "3e0eba196", "8d1489d50", "b11c3eadf", "ebcfa7867", "f20b84081"], ["0dc1fdc75", "39bc8f2ca", "7fdb0907e", "a4f089c79", "e3a2bea41", "f3cee4dc4"], ["137013f60", "32c525eb6", "55328e3a9", "6a985e71e", "87357a606", "986753361"], ["26dd3cac2", "b2869ebc4", "bcfd848e7", "c25973124", "dd8af778d", "fb0bc321d"], ["3c41f5534", "67dd6243d", "6d68fcb28", "8e81995de", "e24fb3247", "e49e9590d"], ["3fbec9e50", "8e909812d", "c3f7dde39", "c9447b8bd", "dc6c85ff4", "e42598a41"], ["46593aea0", "61a9b4b6e", "bfc5cea76", "cfb610eaa", "e1c30458a", "fe2720c45"], ["47dae5e74", "6a423a256", "d106295b6", "e5babf754"]], "identity_text": "Fix assorted integer overflows in memory-allocation calculations (Tom Lane, Nathan Bossart, Heikki Linnakangas) Various places were incautious about the possibility of integer overflow in calculations of how much memory to allocate. Overflow would lead to allocating a too-small buffer which the caller would then write past the end of. This would at least trigger server crashes, and probably could be exploited for arbitrary code execution. In many but by no means all cases, the hazard exists only in 32-bit builds. The PostgreSQL Project thanks Xint Code, Bruce Dang, Sven Klemm, and Pavel Kohout for reporting these problems. (CVE-2026-6473)", "commit_aliases": ["00e243e67", "01b5ef7df", "01e568b8c", "066b7b144", "0dc1fdc75", "137013f60", "26dd3cac2", "32c525eb6", "37842f3dc", "39bc8f2ca", "3c41f5534", "3e0eba196", "3fbec9e50", "4032c9d98", "46593aea0", "47dae5e74", "55328e3a9", "61a9b4b6e", "67dd6243d", "6a423a256", "6a985e71e", "6d68fcb28", "7fdb0907e", "87357a606", "8d1489d50", "8e81995de", "8e909812d", "924b3e943", "986753361", "a4f089c79", "aff71f87b", "b11c3eadf", "b2869ebc4", "bcfd848e7", "bfc5cea76", "c25973124", "c3f7dde39", "c55cea529", "c7fb9f765", "c9447b8bd", "cfb610eaa", "d106295b6", "d75b1dc96", "dc6c85ff4", "dd8af778d", "e1c30458a", "e24fb3247", "e31ef0720", "e3a2bea41", "e42598a41", "e49e9590d", "e5babf754", "ebcfa7867", "f20b84081", "f3cee4dc4", "fb0bc321d", "fe2720c45"], "source_commits": ["32c525eb6", "47dae5e74", "924b3e943", "a4f089c79", "aff71f87b", "c25973124", "cfb610eaa", "e24fb3247", "e42598a41", "f20b84081"], "source_entry_id": "16.14/changes/002", "db_id": "8efe22f93b8d48d1a299e86b11c402e5", "patch_ids": ["0ef31353c016842f07a477e36bffc11a", "18b75605d90ace7a2cf8047352074614", "522ba1e579ed17edbf8f9a554cef9734", "5ee943f19c8b14a26d6f6e850b4c2e4a", "67e33d81b6d11e90e4032802100b1f9a", "722cd5796fd759e519e27c59ed0f5bc7", "8b4c7be6720ec411561a3216285eb5c2", "9be6f17ccc7861ac218a3159257353f5", "9c6a62a34c14fe610b5925191c0d43bf", "ac6798245b6fb47cbaf616c47755bec8"], "statement_hash": "e134dbaa858fe12a3a5fc6391ac874300d57d4269c0f25b416434cdc943690d8", "relations": [{"rule": 2, "type": "equivalent", "target": "2566881ea25d8a61c2245b4b04c49f1a", "evidence": {"same_day": true, "patch_ids": ["0ef31353c016842f07a477e36bffc11a", "18b75605d90ace7a2cf8047352074614", "522ba1e579ed17edbf8f9a554cef9734", "5ee943f19c8b14a26d6f6e850b4c2e4a", "67e33d81b6d11e90e4032802100b1f9a", "722cd5796fd759e519e27c59ed0f5bc7", "8b4c7be6720ec411561a3216285eb5c2", "9be6f17ccc7861ac218a3159257353f5", "9c6a62a34c14fe610b5925191c0d43bf", "ac6798245b6fb47cbaf616c47755bec8"], "statement_hash": "e134dbaa858fe12a3a5fc6391ac874300d57d4269c0f25b416434cdc943690d8"}}, {"rule": 2, "type": "equivalent", "target": "295b1d4dab2d6e770a4f53cf19a7aaa0", "evidence": {"same_day": true, "patch_ids": ["0ef31353c016842f07a477e36bffc11a", "18b75605d90ace7a2cf8047352074614", "522ba1e579ed17edbf8f9a554cef9734", "5ee943f19c8b14a26d6f6e850b4c2e4a", "67e33d81b6d11e90e4032802100b1f9a", "722cd5796fd759e519e27c59ed0f5bc7", "8b4c7be6720ec411561a3216285eb5c2", "9be6f17ccc7861ac218a3159257353f5", "9c6a62a34c14fe610b5925191c0d43bf", "ac6798245b6fb47cbaf616c47755bec8"], "statement_hash": "e134dbaa858fe12a3a5fc6391ac874300d57d4269c0f25b416434cdc943690d8"}}, {"rule": 2, "type": "equivalent", "target": "acba67a334312f97f378ad9d28899a71", "evidence": {"same_day": true, "patch_ids": ["0ef31353c016842f07a477e36bffc11a", "18b75605d90ace7a2cf8047352074614", "522ba1e579ed17edbf8f9a554cef9734", "5ee943f19c8b14a26d6f6e850b4c2e4a", "67e33d81b6d11e90e4032802100b1f9a", "722cd5796fd759e519e27c59ed0f5bc7", "8b4c7be6720ec411561a3216285eb5c2", "9be6f17ccc7861ac218a3159257353f5", "9c6a62a34c14fe610b5925191c0d43bf", "ac6798245b6fb47cbaf616c47755bec8"], "statement_hash": "e134dbaa858fe12a3a5fc6391ac874300d57d4269c0f25b416434cdc943690d8"}}, {"rule": 2, "type": "equivalent", "target": "f0345a5abb8aa96f05fce3fbd32e6535", "evidence": {"same_day": true, "patch_ids": ["0ef31353c016842f07a477e36bffc11a", "18b75605d90ace7a2cf8047352074614", "522ba1e579ed17edbf8f9a554cef9734", "5ee943f19c8b14a26d6f6e850b4c2e4a", "67e33d81b6d11e90e4032802100b1f9a", "722cd5796fd759e519e27c59ed0f5bc7", "8b4c7be6720ec411561a3216285eb5c2", "9be6f17ccc7861ac218a3159257353f5", "9c6a62a34c14fe610b5925191c0d43bf", "ac6798245b6fb47cbaf616c47755bec8"], "statement_hash": "e134dbaa858fe12a3a5fc6391ac874300d57d4269c0f25b416434cdc943690d8"}}], "version": "16.14", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "acba67a334312f97f378ad9d28899a71", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Fix assorted integer overflows in memory-allocation calculations", "evidence": {"same_day": true, "patch_ids": ["0ef31353c016842f07a477e36bffc11a", "18b75605d90ace7a2cf8047352074614", "522ba1e579ed17edbf8f9a554cef9734", "5ee943f19c8b14a26d6f6e850b4c2e4a", "67e33d81b6d11e90e4032802100b1f9a", "722cd5796fd759e519e27c59ed0f5bc7", "8b4c7be6720ec411561a3216285eb5c2", "9be6f17ccc7861ac218a3159257353f5", "9c6a62a34c14fe610b5925191c0d43bf", "ac6798245b6fb47cbaf616c47755bec8"], "statement_hash": "e134dbaa858fe12a3a5fc6391ac874300d57d4269c0f25b416434cdc943690d8"}, "url": "/docs/compare/?release=18.4#18.4-0ecf0348f34312bf", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "f0345a5abb8aa96f05fce3fbd32e6535", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Fix assorted integer overflows in memory-allocation calculations", "evidence": {"same_day": true, "patch_ids": ["0ef31353c016842f07a477e36bffc11a", "18b75605d90ace7a2cf8047352074614", "522ba1e579ed17edbf8f9a554cef9734", "5ee943f19c8b14a26d6f6e850b4c2e4a", "67e33d81b6d11e90e4032802100b1f9a", "722cd5796fd759e519e27c59ed0f5bc7", "8b4c7be6720ec411561a3216285eb5c2", "9be6f17ccc7861ac218a3159257353f5", "9c6a62a34c14fe610b5925191c0d43bf", "ac6798245b6fb47cbaf616c47755bec8"], "statement_hash": "e134dbaa858fe12a3a5fc6391ac874300d57d4269c0f25b416434cdc943690d8"}, "url": "/docs/compare/?release=17.10#17.10-a0bf50b47f7c6ba2", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "295b1d4dab2d6e770a4f53cf19a7aaa0", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Fix assorted integer overflows in memory-allocation calculations", "evidence": {"same_day": true, "patch_ids": ["0ef31353c016842f07a477e36bffc11a", "18b75605d90ace7a2cf8047352074614", "522ba1e579ed17edbf8f9a554cef9734", "5ee943f19c8b14a26d6f6e850b4c2e4a", "67e33d81b6d11e90e4032802100b1f9a", "722cd5796fd759e519e27c59ed0f5bc7", "8b4c7be6720ec411561a3216285eb5c2", "9be6f17ccc7861ac218a3159257353f5", "9c6a62a34c14fe610b5925191c0d43bf", "ac6798245b6fb47cbaf616c47755bec8"], "statement_hash": "e134dbaa858fe12a3a5fc6391ac874300d57d4269c0f25b416434cdc943690d8"}, "url": "/docs/compare/?release=15.18#15.18-77623f915f7592d9", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "2566881ea25d8a61c2245b4b04c49f1a", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Fix assorted integer overflows in memory-allocation calculations", "evidence": {"same_day": true, "patch_ids": ["0ef31353c016842f07a477e36bffc11a", "18b75605d90ace7a2cf8047352074614", "522ba1e579ed17edbf8f9a554cef9734", "5ee943f19c8b14a26d6f6e850b4c2e4a", "67e33d81b6d11e90e4032802100b1f9a", "722cd5796fd759e519e27c59ed0f5bc7", "8b4c7be6720ec411561a3216285eb5c2", "9be6f17ccc7861ac218a3159257353f5", "9c6a62a34c14fe610b5925191c0d43bf", "ac6798245b6fb47cbaf616c47755bec8"], "statement_hash": "e134dbaa858fe12a3a5fc6391ac874300d57d4269c0f25b416434cdc943690d8"}, "url": "/docs/compare/?release=14.23#14.23-1cae472cd8aafd7d", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-de346e2ac011900c", "cves": ["CVE-2026-6638"], "html": "Properly quote object names in logical replication origin checks (Pavel Kohout) §
\nALTER SUBSCRIPTION ... REFRESH PUBLICATION interpolated schema and relation names into SQL commands without quoting them, allowing execution of arbitrary SQL on the publisher.
The PostgreSQL Project thanks Pavel Kohout for reporting this problem. (CVE-2026-6638)
", "text": "Properly quote object names in logical replication origin checks (Pavel Kohout) § ALTER SUBSCRIPTION ... REFRESH PUBLICATION interpolated schema and relation names into SQL commands without quoting them, allowing execution of arbitrary SQL on the publisher. The PostgreSQL Project thanks Pavel Kohout for reporting this problem. (CVE-2026-6638)", "title": "Properly quote object names in logical replication origin checks", "commits": ["248a433cd"], "section": "Changes", "category": "security", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "c295ccf2192e9c1ff37976ff56c8eff6417c92edeb628a6c6b5bc23b41b9d649", "section_path": ["Changes"], "commit_groups": [["248a433cd", "46b4f5c11", "cb35d7306", "f0f59b658"]], "identity_text": "Properly quote object names in logical replication origin checks (Pavel Kohout) ALTER SUBSCRIPTION ... REFRESH PUBLICATION interpolated schema and relation names into SQL commands without quoting them, allowing execution of arbitrary SQL on the publisher. The PostgreSQL Project thanks Pavel Kohout for reporting this problem. (CVE-2026-6638)", "commit_aliases": ["248a433cd", "46b4f5c11", "cb35d7306", "f0f59b658"], "source_commits": ["248a433cd"], "source_entry_id": "16.14/changes/003", "db_id": "f75aecc1c0c865955094a916f7c78463", "patch_ids": ["a9b5d94f4021c4259f919029b9984225"], "statement_hash": "13a92db4a9747d0e4148764ace1c5b2427bc1582543dea88fe555dd3a4b24743", "relations": [{"rule": 2, "type": "equivalent", "target": "160fa6992f90d49b5edf0769aa32c248", "evidence": {"same_day": true, "patch_ids": ["a9b5d94f4021c4259f919029b9984225"], "statement_hash": "13a92db4a9747d0e4148764ace1c5b2427bc1582543dea88fe555dd3a4b24743"}}, {"rule": 2, "type": "equivalent", "target": "6b9ad77c2d8c8cf7ed6c43c56746b015", "evidence": {"same_day": true, "patch_ids": ["a9b5d94f4021c4259f919029b9984225"], "statement_hash": "13a92db4a9747d0e4148764ace1c5b2427bc1582543dea88fe555dd3a4b24743"}}], "version": "16.14", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "160fa6992f90d49b5edf0769aa32c248", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Properly quote object names in logical replication origin checks", "evidence": {"same_day": true, "patch_ids": ["a9b5d94f4021c4259f919029b9984225"], "statement_hash": "13a92db4a9747d0e4148764ace1c5b2427bc1582543dea88fe555dd3a4b24743"}, "url": "/docs/compare/?release=18.4#18.4-a09de455386cd30a", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "6b9ad77c2d8c8cf7ed6c43c56746b015", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Properly quote object names in logical replication origin checks", "evidence": {"same_day": true, "patch_ids": ["a9b5d94f4021c4259f919029b9984225"], "statement_hash": "13a92db4a9747d0e4148764ace1c5b2427bc1582543dea88fe555dd3a4b24743"}, "url": "/docs/compare/?release=17.10#17.10-fdd0ba1867f4cdc1", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}]}, {"id": "16.14-d9ce899f638fe2e1", "cves": ["CVE-2026-6473"], "html": "Reject over-length options in ts_headline() (Michael Paquier) §
The StartSel, StopSel and FragmentDelimiter strings must not exceed 32Kb in length, but this was not checked for. An over-length value would typically crash the server.
The PostgreSQL Project thanks Xint Code for reporting this problem. (CVE-2026-6473)
", "text": "Reject over-length options in ts_headline() (Michael Paquier) § The StartSel, StopSel and FragmentDelimiter strings must not exceed 32Kb in length, but this was not checked for. An over-length value would typically crash the server. The PostgreSQL Project thanks Xint Code for reporting this problem. (CVE-2026-6473)", "title": "Reject over-length options in ts_headline()", "commits": ["5919e0005"], "section": "Changes", "category": "security", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "30d5fa26a3d0a094524af63f89671c0a552f81055155d276e29364e212a56585", "section_path": ["Changes"], "commit_groups": [["2d267ffc4", "3ed3dbbf4", "5919e0005", "62ad26266", "7fe365693", "d388e1d7f"]], "identity_text": "Reject over-length options in ts_headline() (Michael Paquier) The StartSel, StopSel and FragmentDelimiter strings must not exceed 32Kb in length, but this was not checked for. An over-length value would typically crash the server. The PostgreSQL Project thanks Xint Code for reporting this problem. (CVE-2026-6473)", "commit_aliases": ["2d267ffc4", "3ed3dbbf4", "5919e0005", "62ad26266", "7fe365693", "d388e1d7f"], "source_commits": ["5919e0005"], "source_entry_id": "16.14/changes/004", "db_id": "4e96017be5ce2c6f1d23bf476a962747", "patch_ids": ["8457c408eab825cef1442be8b008d331"], "statement_hash": "fa5b62f6b191298714caf3ad9670542a5ca5106f71c0bcc2d9d2de48ba2a0330", "relations": [{"rule": 2, "type": "equivalent", "target": "0d396ecb6f57179d943c76706100debf", "evidence": {"same_day": true, "patch_ids": ["8457c408eab825cef1442be8b008d331"], "statement_hash": "fa5b62f6b191298714caf3ad9670542a5ca5106f71c0bcc2d9d2de48ba2a0330"}}, {"rule": 2, "type": "equivalent", "target": "afe38bbdb09239daec9610fc4bf0002f", "evidence": {"same_day": true, "patch_ids": ["8457c408eab825cef1442be8b008d331"], "statement_hash": "fa5b62f6b191298714caf3ad9670542a5ca5106f71c0bcc2d9d2de48ba2a0330"}}, {"rule": 2, "type": "equivalent", "target": "c2a972753505f1b0a01bf236c883ccad", "evidence": {"same_day": true, "patch_ids": ["8457c408eab825cef1442be8b008d331"], "statement_hash": "fa5b62f6b191298714caf3ad9670542a5ca5106f71c0bcc2d9d2de48ba2a0330"}}, {"rule": 2, "type": "equivalent", "target": "ca39bd1c4d36eb3d5c6808cd66068408", "evidence": {"same_day": true, "patch_ids": ["8457c408eab825cef1442be8b008d331"], "statement_hash": "fa5b62f6b191298714caf3ad9670542a5ca5106f71c0bcc2d9d2de48ba2a0330"}}], "version": "16.14", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "afe38bbdb09239daec9610fc4bf0002f", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Reject over-length options in ts_headline()", "evidence": {"same_day": true, "patch_ids": ["8457c408eab825cef1442be8b008d331"], "statement_hash": "fa5b62f6b191298714caf3ad9670542a5ca5106f71c0bcc2d9d2de48ba2a0330"}, "url": "/docs/compare/?release=18.4#18.4-2463210164fd4e42", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "0d396ecb6f57179d943c76706100debf", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Reject over-length options in ts_headline()", "evidence": {"same_day": true, "patch_ids": ["8457c408eab825cef1442be8b008d331"], "statement_hash": "fa5b62f6b191298714caf3ad9670542a5ca5106f71c0bcc2d9d2de48ba2a0330"}, "url": "/docs/compare/?release=17.10#17.10-b66b265350df29d2", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "c2a972753505f1b0a01bf236c883ccad", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Reject over-length options in ts_headline()", "evidence": {"same_day": true, "patch_ids": ["8457c408eab825cef1442be8b008d331"], "statement_hash": "fa5b62f6b191298714caf3ad9670542a5ca5106f71c0bcc2d9d2de48ba2a0330"}, "url": "/docs/compare/?release=15.18#15.18-c3608e796458d13b", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "ca39bd1c4d36eb3d5c6808cd66068408", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Reject over-length options in ts_headline()", "evidence": {"same_day": true, "patch_ids": ["8457c408eab825cef1442be8b008d331"], "statement_hash": "fa5b62f6b191298714caf3ad9670542a5ca5106f71c0bcc2d9d2de48ba2a0330"}, "url": "/docs/compare/?release=14.23#14.23-c4c6b68f62616df1", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-168ea3bfaefc6d61", "cves": ["CVE-2026-6474"], "html": "Guard against malicious time zone names in timeofday() and pg_strftime() (Tom Lane) § §
A crafted time zone setting could pass % sequences to snprintf(), potentially causing crashes or disclosure of server memory. Another path to similar results was to overflow the limited-size output buffer used by pg_strftime().
The PostgreSQL Project thanks Xint Code for reporting this problem. (CVE-2026-6474)
", "text": "Guard against malicious time zone names in timeofday() and pg_strftime() (Tom Lane) § § A crafted time zone setting could pass % sequences to snprintf(), potentially causing crashes or disclosure of server memory. Another path to similar results was to overflow the limited-size output buffer used by pg_strftime(). The PostgreSQL Project thanks Xint Code for reporting this problem. (CVE-2026-6474)", "title": "Guard against malicious time zone names in timeofday() and pg_strftime()", "commits": ["24e0e3254", "79b7847c7"], "section": "Changes", "category": "security", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "041c0f0cdaf2077b626de2da5987212cba25e63a7077d04fd58f0665e7e8e04e", "section_path": ["Changes"], "commit_groups": [["126a236ba", "24e0e3254", "4197c880c", "76ab76f87", "a50ae8306", "ba27389c2"], ["2c8226f52", "79b7847c7", "a386d14fe", "c3fff3950", "c6e7a9ef3", "ec8ded4b3"]], "identity_text": "Guard against malicious time zone names in timeofday() and pg_strftime() (Tom Lane) A crafted time zone setting could pass % sequences to snprintf(), potentially causing crashes or disclosure of server memory. Another path to similar results was to overflow the limited-size output buffer used by pg_strftime(). The PostgreSQL Project thanks Xint Code for reporting this problem. (CVE-2026-6474)", "commit_aliases": ["126a236ba", "24e0e3254", "2c8226f52", "4197c880c", "76ab76f87", "79b7847c7", "a386d14fe", "a50ae8306", "ba27389c2", "c3fff3950", "c6e7a9ef3", "ec8ded4b3"], "source_commits": ["24e0e3254", "79b7847c7"], "source_entry_id": "16.14/changes/005", "db_id": "c35bb2a8a5d8d6153139912fa574f1be", "patch_ids": ["3f00e8116f67649860ad5a155650db89", "b65bcdf6c5ef035597912c09e793606a"], "statement_hash": "28222af75396ae38d496fb3a6ca7635e107ba94454753d5b681b8db434552806", "relations": [{"rule": 2, "type": "equivalent", "target": "2a60ebdc5466fdb8ded5b7dd70ff560e", "evidence": {"same_day": true, "patch_ids": ["3f00e8116f67649860ad5a155650db89", "b65bcdf6c5ef035597912c09e793606a"], "statement_hash": "28222af75396ae38d496fb3a6ca7635e107ba94454753d5b681b8db434552806"}}, {"rule": 2, "type": "equivalent", "target": "4746c5c97c413c4b367427dcc53d74f9", "evidence": {"same_day": true, "patch_ids": ["3f00e8116f67649860ad5a155650db89", "b65bcdf6c5ef035597912c09e793606a"], "statement_hash": "28222af75396ae38d496fb3a6ca7635e107ba94454753d5b681b8db434552806"}}, {"rule": 2, "type": "equivalent", "target": "943c74b8816c45111e8f6f3e4682a426", "evidence": {"same_day": true, "patch_ids": ["3f00e8116f67649860ad5a155650db89", "b65bcdf6c5ef035597912c09e793606a"], "statement_hash": "28222af75396ae38d496fb3a6ca7635e107ba94454753d5b681b8db434552806"}}, {"rule": 2, "type": "equivalent", "target": "f0c61a3ee0b896c91466e00b431d94ba", "evidence": {"same_day": true, "patch_ids": ["3f00e8116f67649860ad5a155650db89", "b65bcdf6c5ef035597912c09e793606a"], "statement_hash": "28222af75396ae38d496fb3a6ca7635e107ba94454753d5b681b8db434552806"}}], "version": "16.14", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "2a60ebdc5466fdb8ded5b7dd70ff560e", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Guard against malicious time zone names in timeofday() and pg_strftime()", "evidence": {"same_day": true, "patch_ids": ["3f00e8116f67649860ad5a155650db89", "b65bcdf6c5ef035597912c09e793606a"], "statement_hash": "28222af75396ae38d496fb3a6ca7635e107ba94454753d5b681b8db434552806"}, "url": "/docs/compare/?release=18.4#18.4-3645e80ffc91fcb0", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "943c74b8816c45111e8f6f3e4682a426", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Guard against malicious time zone names in timeofday() and pg_strftime()", "evidence": {"same_day": true, "patch_ids": ["3f00e8116f67649860ad5a155650db89", "b65bcdf6c5ef035597912c09e793606a"], "statement_hash": "28222af75396ae38d496fb3a6ca7635e107ba94454753d5b681b8db434552806"}, "url": "/docs/compare/?release=17.10#17.10-f68835d296474e15", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "f0c61a3ee0b896c91466e00b431d94ba", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Guard against malicious time zone names in timeofday() and pg_strftime()", "evidence": {"same_day": true, "patch_ids": ["3f00e8116f67649860ad5a155650db89", "b65bcdf6c5ef035597912c09e793606a"], "statement_hash": "28222af75396ae38d496fb3a6ca7635e107ba94454753d5b681b8db434552806"}, "url": "/docs/compare/?release=15.18#15.18-f5ceddac85b73b26", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "4746c5c97c413c4b367427dcc53d74f9", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Guard against malicious time zone names in timeofday() and pg_strftime()", "evidence": {"same_day": true, "patch_ids": ["3f00e8116f67649860ad5a155650db89", "b65bcdf6c5ef035597912c09e793606a"], "statement_hash": "28222af75396ae38d496fb3a6ca7635e107ba94454753d5b681b8db434552806"}, "url": "/docs/compare/?release=14.23#14.23-4b161a739a37e73b", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-c48a9f98e69b525d", "cves": ["CVE-2026-6472"], "html": "When creating a multirange type, ensure the user has CREATE privilege on the schema specified for the multirange type (Jelte Fennema-Nio) §
The multirange type can be put into a different schema than its parent range type, but we neglected to apply the required privilege check when doing so.
\nThe PostgreSQL Project thanks Jelte Fennema-Nio for reporting this problem. (CVE-2026-6472)
", "text": "When creating a multirange type, ensure the user has CREATE privilege on the schema specified for the multirange type (Jelte Fennema-Nio) § The multirange type can be put into a different schema than its parent range type, but we neglected to apply the required privilege check when doing so. The PostgreSQL Project thanks Jelte Fennema-Nio for reporting this problem. (CVE-2026-6472)", "title": "When creating a multirange type, ensure the user has CREATE privilege on the schema specified for the multirange type", "commits": ["d92852d62"], "section": "Changes", "category": "security", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "2dad77ea12dc913b6233561e786abe9d3dd3e0adde8c7f58b4bc36cb72f8dc0a", "section_path": ["Changes"], "commit_groups": [["08c397b02", "4793fc41f", "8bca85e9f", "a44780f41", "c27ba08cd", "d92852d62"]], "identity_text": "When creating a multirange type, ensure the user has CREATE privilege on the schema specified for the multirange type (Jelte Fennema-Nio) The multirange type can be put into a different schema than its parent range type, but we neglected to apply the required privilege check when doing so. The PostgreSQL Project thanks Jelte Fennema-Nio for reporting this problem. (CVE-2026-6472)", "commit_aliases": ["08c397b02", "4793fc41f", "8bca85e9f", "a44780f41", "c27ba08cd", "d92852d62"], "source_commits": ["d92852d62"], "source_entry_id": "16.14/changes/006", "db_id": "65fdc90a340d7a6f096d34d54ccaf154", "patch_ids": ["1c201360c1e263b311b7234d83ff89be"], "statement_hash": "d04d5cbb5906b8e6e39e901491618574dca51ad80d7a3a625a786fceaddfddfd", "relations": [{"rule": 2, "type": "equivalent", "target": "482afe166c3411e42aa15c76ef043f3e", "evidence": {"same_day": true, "patch_ids": ["1c201360c1e263b311b7234d83ff89be"], "statement_hash": "d04d5cbb5906b8e6e39e901491618574dca51ad80d7a3a625a786fceaddfddfd"}}, {"rule": 2, "type": "equivalent", "target": "8f0e03a85bb45cde24bbedf7f781a5d5", "evidence": {"same_day": true, "patch_ids": ["1c201360c1e263b311b7234d83ff89be"], "statement_hash": "d04d5cbb5906b8e6e39e901491618574dca51ad80d7a3a625a786fceaddfddfd"}}, {"rule": 2, "type": "equivalent", "target": "c06039568f80f491221fd94687f0285e", "evidence": {"same_day": true, "patch_ids": ["1c201360c1e263b311b7234d83ff89be"], "statement_hash": "d04d5cbb5906b8e6e39e901491618574dca51ad80d7a3a625a786fceaddfddfd"}}, {"rule": 2, "type": "equivalent", "target": "d9b882bba9a59b55e34aa99621e22473", "evidence": {"same_day": true, "patch_ids": ["1c201360c1e263b311b7234d83ff89be"], "statement_hash": "d04d5cbb5906b8e6e39e901491618574dca51ad80d7a3a625a786fceaddfddfd"}}], "version": "16.14", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "d9b882bba9a59b55e34aa99621e22473", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "When creating a multirange type, ensure the user has CREATE privilege on the schema specified for the multirange type", "evidence": {"same_day": true, "patch_ids": ["1c201360c1e263b311b7234d83ff89be"], "statement_hash": "d04d5cbb5906b8e6e39e901491618574dca51ad80d7a3a625a786fceaddfddfd"}, "url": "/docs/compare/?release=18.4#18.4-5cd7cd57980a1193", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "482afe166c3411e42aa15c76ef043f3e", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "When creating a multirange type, ensure the user has CREATE privilege on the schema specified for the multirange type", "evidence": {"same_day": true, "patch_ids": ["1c201360c1e263b311b7234d83ff89be"], "statement_hash": "d04d5cbb5906b8e6e39e901491618574dca51ad80d7a3a625a786fceaddfddfd"}, "url": "/docs/compare/?release=17.10#17.10-7b894433ca4b5fde", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "8f0e03a85bb45cde24bbedf7f781a5d5", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "When creating a multirange type, ensure the user has CREATE privilege on the schema specified for the multirange type", "evidence": {"same_day": true, "patch_ids": ["1c201360c1e263b311b7234d83ff89be"], "statement_hash": "d04d5cbb5906b8e6e39e901491618574dca51ad80d7a3a625a786fceaddfddfd"}, "url": "/docs/compare/?release=15.18#15.18-5774e1af35e1add1", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "c06039568f80f491221fd94687f0285e", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "When creating a multirange type, ensure the user has CREATE privilege on the schema specified for the multirange type", "evidence": {"same_day": true, "patch_ids": ["1c201360c1e263b311b7234d83ff89be"], "statement_hash": "d04d5cbb5906b8e6e39e901491618574dca51ad80d7a3a625a786fceaddfddfd"}, "url": "/docs/compare/?release=14.23#14.23-9d3fa6790baf242e", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-827503d5fab7e32f", "cves": ["CVE-2026-6478"], "html": "Use timing-safe string comparisons in authentication code (Michael Paquier) § §
\nUse timingsafe_bcmp() instead of memcmp() or strcmp() when checking passwords, hashes, etc. It is not known whether the data dependency of those functions is usefully exploitable in any of these places, but in the interests of safety, replace them.
The PostgreSQL Project thanks Joe Conway for reporting this problem. (CVE-2026-6478)
", "text": "Use timing-safe string comparisons in authentication code (Michael Paquier) § § Use timingsafe_bcmp() instead of memcmp() or strcmp() when checking passwords, hashes, etc. It is not known whether the data dependency of those functions is usefully exploitable in any of these places, but in the interests of safety, replace them. The PostgreSQL Project thanks Joe Conway for reporting this problem. (CVE-2026-6478)", "title": "Use timing-safe string comparisons in authentication code", "commits": ["00e27235e", "1604939b2"], "section": "Changes", "category": "security", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "37920732e50ee020b31d871570335e12897b043641e2a7e9b7a845d26a203f5d", "section_path": ["Changes"], "commit_groups": [["00e27235e", "4608619a1", "5924e256c", "c4e7435b3", "c95275f18", "d93ef4131"], ["1604939b2", "8e34acfda", "9dcfcb92f", "b282280e9"]], "identity_text": "Use timing-safe string comparisons in authentication code (Michael Paquier) Use timingsafe_bcmp() instead of memcmp() or strcmp() when checking passwords, hashes, etc. It is not known whether the data dependency of those functions is usefully exploitable in any of these places, but in the interests of safety, replace them. The PostgreSQL Project thanks Joe Conway for reporting this problem. (CVE-2026-6478)", "commit_aliases": ["00e27235e", "1604939b2", "4608619a1", "5924e256c", "8e34acfda", "9dcfcb92f", "b282280e9", "c4e7435b3", "c95275f18", "d93ef4131"], "source_commits": ["00e27235e", "1604939b2"], "source_entry_id": "16.14/changes/007", "db_id": "0851fa23f0d4449b2336783af8c0b37f", "patch_ids": ["4f5cfd9b1166f378c5d2d04fe94dad87", "7fbe706dd59ebe4eced7f18fe6cbf482"], "statement_hash": "7b7eca3255c6f7cb268565088cc6e073ca0b27ad15442af2772a39e51cbfd149", "relations": [{"rule": 2, "type": "equivalent", "target": "049d75b9e50ceb48ee3ba2c6a5d0f494", "evidence": {"same_day": true, "patch_ids": ["4f5cfd9b1166f378c5d2d04fe94dad87", "7fbe706dd59ebe4eced7f18fe6cbf482"], "statement_hash": "7b7eca3255c6f7cb268565088cc6e073ca0b27ad15442af2772a39e51cbfd149"}}, {"rule": 2, "type": "equivalent", "target": "15b60135e3ecea3f472e4441792a26d0", "evidence": {"same_day": true, "patch_ids": ["4f5cfd9b1166f378c5d2d04fe94dad87", "7fbe706dd59ebe4eced7f18fe6cbf482"], "statement_hash": "7b7eca3255c6f7cb268565088cc6e073ca0b27ad15442af2772a39e51cbfd149"}}, {"rule": 2, "type": "equivalent", "target": "c468a98baa6993bf40cb569c73528c72", "evidence": {"same_day": true, "patch_ids": ["4f5cfd9b1166f378c5d2d04fe94dad87", "7fbe706dd59ebe4eced7f18fe6cbf482"], "statement_hash": "7b7eca3255c6f7cb268565088cc6e073ca0b27ad15442af2772a39e51cbfd149"}}, {"rule": 2, "type": "equivalent", "target": "f4fc92fe7fa973d00f46d80cff768f2c", "evidence": {"same_day": true, "patch_ids": ["4f5cfd9b1166f378c5d2d04fe94dad87", "7fbe706dd59ebe4eced7f18fe6cbf482"], "statement_hash": "7b7eca3255c6f7cb268565088cc6e073ca0b27ad15442af2772a39e51cbfd149"}}], "version": "16.14", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "c468a98baa6993bf40cb569c73528c72", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Use timing-safe string comparisons in authentication code", "evidence": {"same_day": true, "patch_ids": ["4f5cfd9b1166f378c5d2d04fe94dad87", "7fbe706dd59ebe4eced7f18fe6cbf482"], "statement_hash": "7b7eca3255c6f7cb268565088cc6e073ca0b27ad15442af2772a39e51cbfd149"}, "url": "/docs/compare/?release=18.4#18.4-81a3fe71f66e6eb4", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "f4fc92fe7fa973d00f46d80cff768f2c", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Use timing-safe string comparisons in authentication code", "evidence": {"same_day": true, "patch_ids": ["4f5cfd9b1166f378c5d2d04fe94dad87", "7fbe706dd59ebe4eced7f18fe6cbf482"], "statement_hash": "7b7eca3255c6f7cb268565088cc6e073ca0b27ad15442af2772a39e51cbfd149"}, "url": "/docs/compare/?release=17.10#17.10-61c7a5bccb286bea", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "15b60135e3ecea3f472e4441792a26d0", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Use timing-safe string comparisons in authentication code", "evidence": {"same_day": true, "patch_ids": ["4f5cfd9b1166f378c5d2d04fe94dad87", "7fbe706dd59ebe4eced7f18fe6cbf482"], "statement_hash": "7b7eca3255c6f7cb268565088cc6e073ca0b27ad15442af2772a39e51cbfd149"}, "url": "/docs/compare/?release=15.18#15.18-94e55aad3ebd8168", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "049d75b9e50ceb48ee3ba2c6a5d0f494", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Use timing-safe string comparisons in authentication code", "evidence": {"same_day": true, "patch_ids": ["4f5cfd9b1166f378c5d2d04fe94dad87", "7fbe706dd59ebe4eced7f18fe6cbf482"], "statement_hash": "7b7eca3255c6f7cb268565088cc6e073ca0b27ad15442af2772a39e51cbfd149"}, "url": "/docs/compare/?release=14.23#14.23-cc5cacc93416a361", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-0f3817e9da4bdc58", "cves": ["CVE-2026-6477"], "html": "Mark PQfn() as unsafe, and avoid using it within libpq (Nathan Bossart) §
For a non-integral result type, PQfn() is not passed the size of the output buffer, so it cannot check that the data returned by the server will fit. A malicious server could therefore overwrite client memory. This is unfixable without an API change, so mark the function as deprecated. Internally to libpq, use a variant version that can apply the missing check.
The PostgreSQL Project thanks Yu Kunpeng and Martin Heistermann for reporting this problem. (CVE-2026-6477)
", "text": "Mark PQfn() as unsafe, and avoid using it within libpq (Nathan Bossart) § For a non-integral result type, PQfn() is not passed the size of the output buffer, so it cannot check that the data returned by the server will fit. A malicious server could therefore overwrite client memory. This is unfixable without an API change, so mark the function as deprecated. Internally to libpq, use a variant version that can apply the missing check. The PostgreSQL Project thanks Yu Kunpeng and Martin Heistermann for reporting this problem. (CVE-2026-6477)", "title": "Mark PQfn() as unsafe, and avoid using it within libpq", "commits": ["614474996"], "section": "Changes", "category": "security", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "ea0d3dce1898d94c20b819c4b6764e9d335882ab5fb269f3ad4c43291b4e3989", "section_path": ["Changes"], "commit_groups": [["614474996", "8ac723b2b", "bd4811493", "be0136440", "d88c7be15", "e3a1f83ea"]], "identity_text": "Mark PQfn() as unsafe, and avoid using it within libpq (Nathan Bossart) For a non-integral result type, PQfn() is not passed the size of the output buffer, so it cannot check that the data returned by the server will fit. A malicious server could therefore overwrite client memory. This is unfixable without an API change, so mark the function as deprecated. Internally to libpq, use a variant version that can apply the missing check. The PostgreSQL Project thanks Yu Kunpeng and Martin Heistermann for reporting this problem. (CVE-2026-6477)", "commit_aliases": ["614474996", "8ac723b2b", "bd4811493", "be0136440", "d88c7be15", "e3a1f83ea"], "source_commits": ["614474996"], "source_entry_id": "16.14/changes/008", "db_id": "4ab9970767b3ef4f9da60c3566967c2b", "patch_ids": ["751c917289b90832d6991f8f4911d6cc"], "statement_hash": "1bf9b2e2db6cb6f0cc68cfddc7ca5a446d8e7408a35bce897eda2f59aec7605b", "relations": [{"rule": 2, "type": "equivalent", "target": "5659c5fab9b3c23718775a073679d763", "evidence": {"same_day": true, "patch_ids": ["751c917289b90832d6991f8f4911d6cc"], "statement_hash": "1bf9b2e2db6cb6f0cc68cfddc7ca5a446d8e7408a35bce897eda2f59aec7605b"}}, {"rule": 2, "type": "equivalent", "target": "847daceb397313a24d7c441b2b0558f1", "evidence": {"same_day": true, "patch_ids": ["751c917289b90832d6991f8f4911d6cc"], "statement_hash": "1bf9b2e2db6cb6f0cc68cfddc7ca5a446d8e7408a35bce897eda2f59aec7605b"}}, {"rule": 2, "type": "equivalent", "target": "954548c0ee471a5891175ee04e881030", "evidence": {"same_day": true, "patch_ids": ["751c917289b90832d6991f8f4911d6cc"], "statement_hash": "1bf9b2e2db6cb6f0cc68cfddc7ca5a446d8e7408a35bce897eda2f59aec7605b"}}, {"rule": 2, "type": "equivalent", "target": "fcce310e332c33500cf3c168aae9bd79", "evidence": {"same_day": true, "patch_ids": ["751c917289b90832d6991f8f4911d6cc"], "statement_hash": "1bf9b2e2db6cb6f0cc68cfddc7ca5a446d8e7408a35bce897eda2f59aec7605b"}}], "version": "16.14", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "847daceb397313a24d7c441b2b0558f1", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Mark PQfn() as unsafe, and avoid using it within libpq", "evidence": {"same_day": true, "patch_ids": ["751c917289b90832d6991f8f4911d6cc"], "statement_hash": "1bf9b2e2db6cb6f0cc68cfddc7ca5a446d8e7408a35bce897eda2f59aec7605b"}, "url": "/docs/compare/?release=18.4#18.4-d46d3c9f5a15e9ff", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "5659c5fab9b3c23718775a073679d763", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Mark PQfn() as unsafe, and avoid using it within libpq", "evidence": {"same_day": true, "patch_ids": ["751c917289b90832d6991f8f4911d6cc"], "statement_hash": "1bf9b2e2db6cb6f0cc68cfddc7ca5a446d8e7408a35bce897eda2f59aec7605b"}, "url": "/docs/compare/?release=17.10#17.10-a3a6ffe2e68f9c70", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "fcce310e332c33500cf3c168aae9bd79", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Mark PQfn() as unsafe, and avoid using it within libpq", "evidence": {"same_day": true, "patch_ids": ["751c917289b90832d6991f8f4911d6cc"], "statement_hash": "1bf9b2e2db6cb6f0cc68cfddc7ca5a446d8e7408a35bce897eda2f59aec7605b"}, "url": "/docs/compare/?release=15.18#15.18-aa006983b88ec66f", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "954548c0ee471a5891175ee04e881030", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Mark PQfn() as unsafe, and avoid using it within libpq", "evidence": {"same_day": true, "patch_ids": ["751c917289b90832d6991f8f4911d6cc"], "statement_hash": "1bf9b2e2db6cb6f0cc68cfddc7ca5a446d8e7408a35bce897eda2f59aec7605b"}, "url": "/docs/compare/?release=14.23#14.23-0894c376482213b5", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-4c65f6e78638d7b8", "cves": ["CVE-2026-6475"], "html": "Prevent path traversal in pg_basebackup and pg_rewind (Michael Paquier) §
\nThese applications failed to validate output file paths read from their input, so that a malicious source could overwrite any file writable by these applications. Constrain where data can be written by rejecting paths that are absolute or contain parent-directory references.
\nThe PostgreSQL Project thanks XlabAI Team of Tencent Xuanwu Lab and Valery Gubanov for reporting this problem. (CVE-2026-6475)
", "text": "Prevent path traversal in pg_basebackup and pg_rewind (Michael Paquier) § These applications failed to validate output file paths read from their input, so that a malicious source could overwrite any file writable by these applications. Constrain where data can be written by rejecting paths that are absolute or contain parent-directory references. The PostgreSQL Project thanks XlabAI Team of Tencent Xuanwu Lab and Valery Gubanov for reporting this problem. (CVE-2026-6475)", "title": "Prevent path traversal in pg_basebackup and pg_rewind", "commits": ["6778af13e"], "section": "Changes", "category": "security", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "a02d277a8220653829cecaf9ffc986feb2a83b0be8612e01d81f9cac15ff5a62", "section_path": ["Changes"], "commit_groups": [["0c83fe8e4", "498829dca", "6778af13e", "6a67c540a", "8f881e188", "a1063eece"]], "identity_text": "Prevent path traversal in pg_basebackup and pg_rewind (Michael Paquier) These applications failed to validate output file paths read from their input, so that a malicious source could overwrite any file writable by these applications. Constrain where data can be written by rejecting paths that are absolute or contain parent-directory references. The PostgreSQL Project thanks XlabAI Team of Tencent Xuanwu Lab and Valery Gubanov for reporting this problem. (CVE-2026-6475)", "commit_aliases": ["0c83fe8e4", "498829dca", "6778af13e", "6a67c540a", "8f881e188", "a1063eece"], "source_commits": ["6778af13e"], "source_entry_id": "16.14/changes/009", "db_id": "5bc8c04625ad184faa480aea65f22c87", "patch_ids": ["642e466aa03c3fea1f14f662cc164373"], "statement_hash": "f4e8ae9e638997395a0957d148112ff560c0e68ac13f1311986f81899f914d10", "relations": [{"rule": 2, "type": "equivalent", "target": "4327318e7057209dbe42b98400f9d4be", "evidence": {"same_day": true, "patch_ids": ["642e466aa03c3fea1f14f662cc164373"], "statement_hash": "f4e8ae9e638997395a0957d148112ff560c0e68ac13f1311986f81899f914d10"}}, {"rule": 2, "type": "equivalent", "target": "4bae8e6eba13d8b7f663721c981765fa", "evidence": {"same_day": true, "patch_ids": ["642e466aa03c3fea1f14f662cc164373"], "statement_hash": "f4e8ae9e638997395a0957d148112ff560c0e68ac13f1311986f81899f914d10"}}, {"rule": 2, "type": "equivalent", "target": "869c70a85bc692a897810d4c6c2c8001", "evidence": {"same_day": true, "patch_ids": ["642e466aa03c3fea1f14f662cc164373"], "statement_hash": "f4e8ae9e638997395a0957d148112ff560c0e68ac13f1311986f81899f914d10"}}, {"rule": 2, "type": "equivalent", "target": "a4a793034a07393a1194f5d901c7e563", "evidence": {"same_day": true, "patch_ids": ["642e466aa03c3fea1f14f662cc164373"], "statement_hash": "f4e8ae9e638997395a0957d148112ff560c0e68ac13f1311986f81899f914d10"}}], "version": "16.14", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "4327318e7057209dbe42b98400f9d4be", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Prevent path traversal in pg_basebackup and pg_rewind", "evidence": {"same_day": true, "patch_ids": ["642e466aa03c3fea1f14f662cc164373"], "statement_hash": "f4e8ae9e638997395a0957d148112ff560c0e68ac13f1311986f81899f914d10"}, "url": "/docs/compare/?release=18.4#18.4-ad40fa4da3cebaa2", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "4bae8e6eba13d8b7f663721c981765fa", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Prevent path traversal in pg_basebackup and pg_rewind", "evidence": {"same_day": true, "patch_ids": ["642e466aa03c3fea1f14f662cc164373"], "statement_hash": "f4e8ae9e638997395a0957d148112ff560c0e68ac13f1311986f81899f914d10"}, "url": "/docs/compare/?release=17.10#17.10-91d502adb9e9905a", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "a4a793034a07393a1194f5d901c7e563", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Prevent path traversal in pg_basebackup and pg_rewind", "evidence": {"same_day": true, "patch_ids": ["642e466aa03c3fea1f14f662cc164373"], "statement_hash": "f4e8ae9e638997395a0957d148112ff560c0e68ac13f1311986f81899f914d10"}, "url": "/docs/compare/?release=15.18#15.18-3178339f2560c1fe", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "869c70a85bc692a897810d4c6c2c8001", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Prevent path traversal in pg_basebackup and pg_rewind", "evidence": {"same_day": true, "patch_ids": ["642e466aa03c3fea1f14f662cc164373"], "statement_hash": "f4e8ae9e638997395a0957d148112ff560c0e68ac13f1311986f81899f914d10"}, "url": "/docs/compare/?release=14.23#14.23-1e7e9c27c7b963a2", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-21fce6af887a0371", "cves": ["CVE-2026-6473"], "html": "Guard against field overflow within contrib/intarray's query_int type and contrib/ltree's ltxtquery type (Tom Lane) § §
Parsing of these query structures did not check for overflow of 16-bit fields, so that construction of an invalid query tree was possible. This can crash the server when executing the query.
\nThe PostgreSQL Project thanks Xint Code for reporting this problem. (CVE-2026-6473)
", "text": "Guard against field overflow within contrib/intarray's query_int type and contrib/ltree's ltxtquery type (Tom Lane) § § Parsing of these query structures did not check for overflow of 16-bit fields, so that construction of an invalid query tree was possible. This can crash the server when executing the query. The PostgreSQL Project thanks Xint Code for reporting this problem. (CVE-2026-6473)", "title": "Guard against field overflow within contrib/intarray's query_int type and contrib/ltree's ltxtquery type", "commits": ["5c1069c35", "6f0bff33d"], "section": "Changes", "category": "security", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "7953fc38e5db41007ac6fd91245cb26d824e12ef7c5604da189f1845bd26d256", "section_path": ["Changes"], "commit_groups": [["05e73b5c3", "2b429d887", "479823a71", "6f0bff33d", "906ea101d", "fc1fd3d97"], ["074702525", "43451a7a2", "5c1069c35", "84a9f2641", "c4d04cc48", "c5790ec4f"]], "identity_text": "Guard against field overflow within contrib/intarray's query_int type and contrib/ltree's ltxtquery type (Tom Lane) Parsing of these query structures did not check for overflow of 16-bit fields, so that construction of an invalid query tree was possible. This can crash the server when executing the query. The PostgreSQL Project thanks Xint Code for reporting this problem. (CVE-2026-6473)", "commit_aliases": ["05e73b5c3", "074702525", "2b429d887", "43451a7a2", "479823a71", "5c1069c35", "6f0bff33d", "84a9f2641", "906ea101d", "c4d04cc48", "c5790ec4f", "fc1fd3d97"], "source_commits": ["5c1069c35", "6f0bff33d"], "source_entry_id": "16.14/changes/010", "db_id": "0423b242e381085c16cb62849b04525f", "patch_ids": ["6f7401152b77a4e4d59e752f19e8486b", "b419665d09a38659e641b360731e56da"], "statement_hash": "eab56845994726033024137f96b0dd1e892a863aae111c3043e8a088bf26c0d7", "relations": [{"rule": 2, "type": "equivalent", "target": "2ad1fdfa4b929eb7b74591983f7fe071", "evidence": {"same_day": true, "patch_ids": ["6f7401152b77a4e4d59e752f19e8486b", "b419665d09a38659e641b360731e56da"], "statement_hash": "eab56845994726033024137f96b0dd1e892a863aae111c3043e8a088bf26c0d7"}}, {"rule": 2, "type": "equivalent", "target": "9a6b47b64707d2aaa7ed6ba0484070e5", "evidence": {"same_day": true, "patch_ids": ["6f7401152b77a4e4d59e752f19e8486b", "b419665d09a38659e641b360731e56da"], "statement_hash": "eab56845994726033024137f96b0dd1e892a863aae111c3043e8a088bf26c0d7"}}, {"rule": 2, "type": "equivalent", "target": "9f97314dd0efbba664c1f83e75fb5fa1", "evidence": {"same_day": true, "patch_ids": ["6f7401152b77a4e4d59e752f19e8486b", "b419665d09a38659e641b360731e56da"], "statement_hash": "eab56845994726033024137f96b0dd1e892a863aae111c3043e8a088bf26c0d7"}}, {"rule": 2, "type": "equivalent", "target": "d29898a37787b811ca1a66114dcaa530", "evidence": {"same_day": true, "patch_ids": ["6f7401152b77a4e4d59e752f19e8486b", "b419665d09a38659e641b360731e56da"], "statement_hash": "eab56845994726033024137f96b0dd1e892a863aae111c3043e8a088bf26c0d7"}}], "version": "16.14", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "9a6b47b64707d2aaa7ed6ba0484070e5", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Guard against field overflow within contrib/intarray's query_int type and contrib/ltree's ltxtquery type", "evidence": {"same_day": true, "patch_ids": ["6f7401152b77a4e4d59e752f19e8486b", "b419665d09a38659e641b360731e56da"], "statement_hash": "eab56845994726033024137f96b0dd1e892a863aae111c3043e8a088bf26c0d7"}, "url": "/docs/compare/?release=18.4#18.4-2061b554e1b2edfa", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "9f97314dd0efbba664c1f83e75fb5fa1", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Guard against field overflow within contrib/intarray's query_int type and contrib/ltree's ltxtquery type", "evidence": {"same_day": true, "patch_ids": ["6f7401152b77a4e4d59e752f19e8486b", "b419665d09a38659e641b360731e56da"], "statement_hash": "eab56845994726033024137f96b0dd1e892a863aae111c3043e8a088bf26c0d7"}, "url": "/docs/compare/?release=17.10#17.10-992f2d3fb9146406", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "2ad1fdfa4b929eb7b74591983f7fe071", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Guard against field overflow within contrib/intarray's query_int type and contrib/ltree's ltxtquery type", "evidence": {"same_day": true, "patch_ids": ["6f7401152b77a4e4d59e752f19e8486b", "b419665d09a38659e641b360731e56da"], "statement_hash": "eab56845994726033024137f96b0dd1e892a863aae111c3043e8a088bf26c0d7"}, "url": "/docs/compare/?release=15.18#15.18-b4e159c1c3614019", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "d29898a37787b811ca1a66114dcaa530", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Guard against field overflow within contrib/intarray's query_int type and contrib/ltree's ltxtquery type", "evidence": {"same_day": true, "patch_ids": ["6f7401152b77a4e4d59e752f19e8486b", "b419665d09a38659e641b360731e56da"], "statement_hash": "eab56845994726033024137f96b0dd1e892a863aae111c3043e8a088bf26c0d7"}, "url": "/docs/compare/?release=14.23#14.23-73b4c72ec19c85bf", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-9f75dab6c6486a53", "cves": ["CVE-2026-6473"], "html": "Guard against overly long values of contrib/ltree's lquery type (Michael Paquier) §
Values with more than 64K items caused internal overflows, potentially resulting in stack smashes or wrong answers.
\nThe PostgreSQL Project thanks Vergissmeinnicht, A1ex, and Jihe Wang for reporting this problem. (CVE-2026-6473)
", "text": "Guard against overly long values of contrib/ltree's lquery type (Michael Paquier) § Values with more than 64K items caused internal overflows, potentially resulting in stack smashes or wrong answers. The PostgreSQL Project thanks Vergissmeinnicht, A1ex, and Jihe Wang for reporting this problem. (CVE-2026-6473)", "title": "Guard against overly long values of contrib/ltree's lquery type", "commits": ["6b6b26fde"], "section": "Changes", "category": "security", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "1053d22939a1f5e92c04127c4b231313d544751a945af5ebe0510cc686c9f035", "section_path": ["Changes"], "commit_groups": [["2f1b16e86", "6b6b26fde", "7f019f341", "8c3426110", "9c2fa5b6a", "b545c3787"]], "identity_text": "Guard against overly long values of contrib/ltree's lquery type (Michael Paquier) Values with more than 64K items caused internal overflows, potentially resulting in stack smashes or wrong answers. The PostgreSQL Project thanks Vergissmeinnicht, A1ex, and Jihe Wang for reporting this problem. (CVE-2026-6473)", "commit_aliases": ["2f1b16e86", "6b6b26fde", "7f019f341", "8c3426110", "9c2fa5b6a", "b545c3787"], "source_commits": ["6b6b26fde"], "source_entry_id": "16.14/changes/011", "db_id": "6aa8f69f3021e6633c690bc4d069a359", "patch_ids": ["82d1afadeb06a657e558ea1b226d290b"], "statement_hash": "0f082737f7f109cba8da33aebd4d21f85a8ca0c9ac333cd92d1eafa83684e6e1", "relations": [{"rule": 2, "type": "equivalent", "target": "abd21d034ac90949aacffcced38f44c8", "evidence": {"same_day": true, "patch_ids": ["82d1afadeb06a657e558ea1b226d290b"], "statement_hash": "0f082737f7f109cba8da33aebd4d21f85a8ca0c9ac333cd92d1eafa83684e6e1"}}, {"rule": 2, "type": "equivalent", "target": "b026af4117fde9e94388242432e381e0", "evidence": {"same_day": true, "patch_ids": ["82d1afadeb06a657e558ea1b226d290b"], "statement_hash": "0f082737f7f109cba8da33aebd4d21f85a8ca0c9ac333cd92d1eafa83684e6e1"}}, {"rule": 2, "type": "equivalent", "target": "e57528b755cb641d030a2490a8ecb83e", "evidence": {"same_day": true, "patch_ids": ["82d1afadeb06a657e558ea1b226d290b"], "statement_hash": "0f082737f7f109cba8da33aebd4d21f85a8ca0c9ac333cd92d1eafa83684e6e1"}}, {"rule": 2, "type": "equivalent", "target": "f1ea7b13a59ce4a556a97a665b13ddd9", "evidence": {"same_day": true, "patch_ids": ["82d1afadeb06a657e558ea1b226d290b"], "statement_hash": "0f082737f7f109cba8da33aebd4d21f85a8ca0c9ac333cd92d1eafa83684e6e1"}}], "version": "16.14", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "f1ea7b13a59ce4a556a97a665b13ddd9", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Guard against overly long values of contrib/ltree's lquery type", "evidence": {"same_day": true, "patch_ids": ["82d1afadeb06a657e558ea1b226d290b"], "statement_hash": "0f082737f7f109cba8da33aebd4d21f85a8ca0c9ac333cd92d1eafa83684e6e1"}, "url": "/docs/compare/?release=18.4#18.4-eb36ae972f5e73e4", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "e57528b755cb641d030a2490a8ecb83e", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Guard against overly long values of contrib/ltree's lquery type", "evidence": {"same_day": true, "patch_ids": ["82d1afadeb06a657e558ea1b226d290b"], "statement_hash": "0f082737f7f109cba8da33aebd4d21f85a8ca0c9ac333cd92d1eafa83684e6e1"}, "url": "/docs/compare/?release=17.10#17.10-ac24cc16660e8737", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "abd21d034ac90949aacffcced38f44c8", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Guard against overly long values of contrib/ltree's lquery type", "evidence": {"same_day": true, "patch_ids": ["82d1afadeb06a657e558ea1b226d290b"], "statement_hash": "0f082737f7f109cba8da33aebd4d21f85a8ca0c9ac333cd92d1eafa83684e6e1"}, "url": "/docs/compare/?release=15.18#15.18-f7162bdebe6fb249", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "b026af4117fde9e94388242432e381e0", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Guard against overly long values of contrib/ltree's lquery type", "evidence": {"same_day": true, "patch_ids": ["82d1afadeb06a657e558ea1b226d290b"], "statement_hash": "0f082737f7f109cba8da33aebd4d21f85a8ca0c9ac333cd92d1eafa83684e6e1"}, "url": "/docs/compare/?release=14.23#14.23-466881ae2d66f716", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-5c04fa5074420944", "cves": ["CVE-2026-6637"], "html": "Prevent SQL injection and buffer overruns in contrib/spi (Nathan Bossart) §
check_foreign_key() was insufficiently careful about quoting key values, and also used fixed-length buffers for constructing queries. While this module is only meant as example code, it still shouldn't contain such dangerous errors.
The PostgreSQL Project thanks Nikolay Samokhvalov for reporting this problem. (CVE-2026-6637)
", "text": "Prevent SQL injection and buffer overruns in contrib/spi (Nathan Bossart) § check_foreign_key() was insufficiently careful about quoting key values, and also used fixed-length buffers for constructing queries. While this module is only meant as example code, it still shouldn't contain such dangerous errors. The PostgreSQL Project thanks Nikolay Samokhvalov for reporting this problem. (CVE-2026-6637)", "title": "Prevent SQL injection and buffer overruns in contrib/spi", "commits": ["710995782"], "section": "Changes", "category": "security", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "9274a48a42f2465115f4cc7d67d4d3813ac6cdf2ec696d4e47787c37bed4f205", "section_path": ["Changes"], "commit_groups": [["1ebda7da9", "260e97733", "2b026df29", "2dc64ef28", "710995782", "8053235ab"]], "identity_text": "Prevent SQL injection and buffer overruns in contrib/spi (Nathan Bossart) check_foreign_key() was insufficiently careful about quoting key values, and also used fixed-length buffers for constructing queries. While this module is only meant as example code, it still shouldn't contain such dangerous errors. The PostgreSQL Project thanks Nikolay Samokhvalov for reporting this problem. (CVE-2026-6637)", "commit_aliases": ["1ebda7da9", "260e97733", "2b026df29", "2dc64ef28", "710995782", "8053235ab"], "source_commits": ["710995782"], "source_entry_id": "16.14/changes/012", "db_id": "47e292139214a78fca35c140daf58270", "patch_ids": ["41547e1e28b3ed62af00bb9fe154772c"], "statement_hash": "7b1c0422aa1716161960ade63e1f312c46555a948c91e3b00a8e5c748e70d047", "relations": [{"rule": 2, "type": "equivalent", "target": "5c27c1f393abf9296bda616730209a61", "evidence": {"same_day": true, "patch_ids": ["41547e1e28b3ed62af00bb9fe154772c"], "statement_hash": "7b1c0422aa1716161960ade63e1f312c46555a948c91e3b00a8e5c748e70d047"}}, {"rule": 2, "type": "equivalent", "target": "7f0c9646c89bca074cd9e0bbd964087f", "evidence": {"same_day": true, "patch_ids": ["41547e1e28b3ed62af00bb9fe154772c"], "statement_hash": "7b1c0422aa1716161960ade63e1f312c46555a948c91e3b00a8e5c748e70d047"}}, {"rule": 2, "type": "equivalent", "target": "80646ad1b79ca8538cfec18dd2e574d7", "evidence": {"same_day": true, "patch_ids": ["41547e1e28b3ed62af00bb9fe154772c"], "statement_hash": "7b1c0422aa1716161960ade63e1f312c46555a948c91e3b00a8e5c748e70d047"}}, {"rule": 2, "type": "equivalent", "target": "b9f0b8c87f7b233c50090282e467d8ed", "evidence": {"same_day": true, "patch_ids": ["41547e1e28b3ed62af00bb9fe154772c"], "statement_hash": "7b1c0422aa1716161960ade63e1f312c46555a948c91e3b00a8e5c748e70d047"}}], "version": "16.14", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "7f0c9646c89bca074cd9e0bbd964087f", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Prevent SQL injection and buffer overruns in contrib/spi", "evidence": {"same_day": true, "patch_ids": ["41547e1e28b3ed62af00bb9fe154772c"], "statement_hash": "7b1c0422aa1716161960ade63e1f312c46555a948c91e3b00a8e5c748e70d047"}, "url": "/docs/compare/?release=18.4#18.4-723bbbf2b375795c", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "80646ad1b79ca8538cfec18dd2e574d7", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Prevent SQL injection and buffer overruns in contrib/spi", "evidence": {"same_day": true, "patch_ids": ["41547e1e28b3ed62af00bb9fe154772c"], "statement_hash": "7b1c0422aa1716161960ade63e1f312c46555a948c91e3b00a8e5c748e70d047"}, "url": "/docs/compare/?release=17.10#17.10-24a0ab68af146f7d", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "5c27c1f393abf9296bda616730209a61", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Prevent SQL injection and buffer overruns in contrib/spi", "evidence": {"same_day": true, "patch_ids": ["41547e1e28b3ed62af00bb9fe154772c"], "statement_hash": "7b1c0422aa1716161960ade63e1f312c46555a948c91e3b00a8e5c748e70d047"}, "url": "/docs/compare/?release=15.18#15.18-9aab90e2decdd59b", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "b9f0b8c87f7b233c50090282e467d8ed", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Prevent SQL injection and buffer overruns in contrib/spi", "evidence": {"same_day": true, "patch_ids": ["41547e1e28b3ed62af00bb9fe154772c"], "statement_hash": "7b1c0422aa1716161960ade63e1f312c46555a948c91e3b00a8e5c748e70d047"}, "url": "/docs/compare/?release=14.23#14.23-6193d19850500f38", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-92fc9301e29135e9", "cves": [], "html": "Check for nondeterministic collations before assuming that an equality condition on a collatable type implies uniqueness (Richard Guo) § §
\nNumerous planner optimizations assume that, for example, at most one table row can satisfy WHERE x = 'abc' if there is a unique index on x. However this conclusion is unsafe in general if the index and the WHERE clause have different collations attached. It is safe when both collations are deterministic, because that property essentially requires that equality of two strings means bitwise equality. But nondeterministic collations don't act that way, so that optimizing on the assumption of unique matches can give wrong query answers if either the WHERE clause or the index has a nondeterministic collation.
Fix incomplete removal of relation references in RestrictInfo structs during join removal (Tom Lane) § §
This oversight has been shown to result in planner failures such as unexpected “FULL JOIN is only supported with merge-joinable or hash-joinable join conditions” errors. It may also have caused failure to consider valid plans in other cases.
", "text": "Fix incomplete removal of relation references in RestrictInfo structs during join removal (Tom Lane) § § This oversight has been shown to result in planner failures such as unexpected “FULL JOIN is only supported with merge-joinable or hash-joinable join conditions” errors. It may also have caused failure to consider valid plans in other cases.", "title": "Fix incomplete removal of relation references in RestrictInfo structs during join removal", "commits": ["798dabe83", "d509be4ac"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "54191ccaac339b9b36b7cbb78754ff0391f629dee190d7e42ddf3118a0de36b1", "section_path": ["Changes"], "commit_groups": [["16fb94605", "766d40286", "cfcd57111", "d509be4ac"], ["53cb4ec1d", "798dabe83", "f0ac6d494"]], "identity_text": "Fix incomplete removal of relation references in RestrictInfo structs during join removal (Tom Lane) This oversight has been shown to result in planner failures such as unexpected FULL JOIN is only supported with merge-joinable or hash-joinable join conditions errors. It may also have caused failure to consider valid plans in other cases.", "commit_aliases": ["16fb94605", "53cb4ec1d", "766d40286", "798dabe83", "cfcd57111", "d509be4ac", "f0ac6d494"], "source_commits": ["798dabe83", "d509be4ac"], "source_entry_id": "16.14/changes/014", "db_id": "53d5de052cfe73ed3dbffe04ba42ff12", "patch_ids": ["22c06d077427cb5284041785d0e8cde1", "8989faf5448f269deb8ac79dc2a63860"], "statement_hash": "bbc0a2274d4af257fa49e43eafaf28ca0f12217996c9c00ed63e12bf89b35109", "relations": [{"rule": 2, "type": "equivalent", "target": "0a61b6485e0144413b6e68fbe7763a8f", "evidence": {"same_day": true, "patch_ids": ["22c06d077427cb5284041785d0e8cde1", "8989faf5448f269deb8ac79dc2a63860"], "statement_hash": "bbc0a2274d4af257fa49e43eafaf28ca0f12217996c9c00ed63e12bf89b35109"}}, {"rule": 2, "type": "equivalent", "target": "cbba3da86525413deddd8a183780866b", "evidence": {"same_day": true, "patch_ids": ["22c06d077427cb5284041785d0e8cde1", "8989faf5448f269deb8ac79dc2a63860"], "statement_hash": "bbc0a2274d4af257fa49e43eafaf28ca0f12217996c9c00ed63e12bf89b35109"}}], "version": "16.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "cbba3da86525413deddd8a183780866b", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Fix incomplete removal of relation references in RestrictInfo structs during join removal", "evidence": {"same_day": true, "patch_ids": ["22c06d077427cb5284041785d0e8cde1", "8989faf5448f269deb8ac79dc2a63860"], "statement_hash": "bbc0a2274d4af257fa49e43eafaf28ca0f12217996c9c00ed63e12bf89b35109"}, "url": "/docs/compare/?release=18.4#18.4-316d774d0290fc1b", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "0a61b6485e0144413b6e68fbe7763a8f", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Fix incomplete removal of relation references in RestrictInfo structs during join removal", "evidence": {"same_day": true, "patch_ids": ["22c06d077427cb5284041785d0e8cde1", "8989faf5448f269deb8ac79dc2a63860"], "statement_hash": "bbc0a2274d4af257fa49e43eafaf28ca0f12217996c9c00ed63e12bf89b35109"}, "url": "/docs/compare/?release=17.10#17.10-d93df01ed01294f0", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}]}, {"id": "16.14-06d72fdc65f84e98", "cves": [], "html": "Fix incorrect handling of NEW generated columns in rule actions and rule qualifications (Richard Guo, Dean Rasheed) §
Previously, such column references would produce NULL in INSERT cases, or be equivalent to the OLD value in UPDATE cases.
Fix spurious “generated columns are not supported in COPY FROM WHERE conditions” errors (Tom Lane) §
\nUse of a system column in a COPY FROM WHERE condition could sometimes incorrectly report this error.
Correctly report a serialization failure when MERGE encounters a concurrently-updated tuple in repeatable-read or serializable mode (Tender Wang) §
Previously, such cases behaved the same as in lower isolation levels.
", "text": "Correctly report a serialization failure when MERGE encounters a concurrently-updated tuple in repeatable-read or serializable mode (Tender Wang) § Previously, such cases behaved the same as in lower isolation levels.", "title": "Correctly report a serialization failure when MERGE encounters a concurrently-updated tuple in repeatable-read or serializable mode", "commits": ["f6e63d4b8"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "a154e64fd0492e6907bd39db72770abd3c370ed24144238bff91516db9fcbdcd", "section_path": ["Changes"], "commit_groups": [["13fab378e", "177037341", "2dcac93c0", "8bfaae6fb", "f6e63d4b8"]], "identity_text": "Correctly report a serialization failure when MERGE encounters a concurrently-updated tuple in repeatable-read or serializable mode (Tender Wang) Previously, such cases behaved the same as in lower isolation levels.", "commit_aliases": ["13fab378e", "177037341", "2dcac93c0", "8bfaae6fb", "f6e63d4b8"], "source_commits": ["f6e63d4b8"], "source_entry_id": "16.14/changes/017", "db_id": "6827747aec40694708ad07aebaf4d3c0", "patch_ids": ["569476436f6f49fe3fc1c20af4157acf"], "statement_hash": "298c05dfef81a90cfb05f72e7375c2ceb55354d2b8c327b08b686d82ad2857b4", "relations": [{"rule": 2, "type": "equivalent", "target": "3f720165e3e8a599ba151cefd48b97e8", "evidence": {"same_day": true, "patch_ids": ["569476436f6f49fe3fc1c20af4157acf"], "statement_hash": "298c05dfef81a90cfb05f72e7375c2ceb55354d2b8c327b08b686d82ad2857b4"}}, {"rule": 2, "type": "equivalent", "target": "bfb26a4ca22c86d79dfde428bbcc3c24", "evidence": {"same_day": true, "patch_ids": ["569476436f6f49fe3fc1c20af4157acf"], "statement_hash": "298c05dfef81a90cfb05f72e7375c2ceb55354d2b8c327b08b686d82ad2857b4"}}, {"rule": 2, "type": "equivalent", "target": "f9969f9244f4ca14ba57359448274286", "evidence": {"same_day": true, "patch_ids": ["569476436f6f49fe3fc1c20af4157acf"], "statement_hash": "298c05dfef81a90cfb05f72e7375c2ceb55354d2b8c327b08b686d82ad2857b4"}}], "version": "16.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "bfb26a4ca22c86d79dfde428bbcc3c24", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Correctly report a serialization failure when MERGE encounters a concurrently-updated tuple in repeatable-read or serializable mode", "evidence": {"same_day": true, "patch_ids": ["569476436f6f49fe3fc1c20af4157acf"], "statement_hash": "298c05dfef81a90cfb05f72e7375c2ceb55354d2b8c327b08b686d82ad2857b4"}, "url": "/docs/compare/?release=18.4#18.4-34de9da81adc1f79", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "f9969f9244f4ca14ba57359448274286", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Correctly report a serialization failure when MERGE encounters a concurrently-updated tuple in repeatable-read or serializable mode", "evidence": {"same_day": true, "patch_ids": ["569476436f6f49fe3fc1c20af4157acf"], "statement_hash": "298c05dfef81a90cfb05f72e7375c2ceb55354d2b8c327b08b686d82ad2857b4"}, "url": "/docs/compare/?release=17.10#17.10-7ae06d40b417bc3b", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "3f720165e3e8a599ba151cefd48b97e8", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Correctly report a serialization failure when MERGE encounters a concurrently-updated tuple in repeatable-read or serializable mode", "evidence": {"same_day": true, "patch_ids": ["569476436f6f49fe3fc1c20af4157acf"], "statement_hash": "298c05dfef81a90cfb05f72e7375c2ceb55354d2b8c327b08b686d82ad2857b4"}, "url": "/docs/compare/?release=15.18#15.18-7ceac60eaa54d492", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}]}, {"id": "16.14-659db987f4321cc2", "cves": [], "html": "Fix CREATE TABLE ... LIKE ... INCLUDING STATISTICS for cases where the source table has dropped column(s) (Julien Tachoires) §
In such cases, extended statistics objects could be copied incorrectly, or the command could give an incorrect error.
", "text": "Fix CREATE TABLE ... LIKE ... INCLUDING STATISTICS for cases where the source table has dropped column(s) (Julien Tachoires) § In such cases, extended statistics objects could be copied incorrectly, or the command could give an incorrect error.", "title": "Fix CREATE TABLE ... LIKE ... INCLUDING STATISTICS for cases where the source table has dropped column(s)", "commits": ["7bb519635"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "1bf4c83f58be2987f3ac1ecff591f638f23007006551690b8d4b5f66758975ea", "section_path": ["Changes"], "commit_groups": [["149c875fc", "6cf49e804", "76d15a7ee", "7bb519635", "81b56b47c", "a0104b447"]], "identity_text": "Fix CREATE TABLE ... LIKE ... INCLUDING STATISTICS for cases where the source table has dropped column(s) (Julien Tachoires) In such cases, extended statistics objects could be copied incorrectly, or the command could give an incorrect error.", "commit_aliases": ["149c875fc", "6cf49e804", "76d15a7ee", "7bb519635", "81b56b47c", "a0104b447"], "source_commits": ["7bb519635"], "source_entry_id": "16.14/changes/018", "db_id": "d68baf1e5d412f66c44df3a681238123", "patch_ids": ["910e6f19667b7b2c274a7cfa4cfbf09c"], "statement_hash": "468cd074434d5b124a2f3ad7e4d4363935368333f67c114d461285e65aadff62", "relations": [{"rule": 2, "type": "equivalent", "target": "259f6916a28a7dd3bbeb72cc130b41a9", "evidence": {"same_day": true, "patch_ids": ["910e6f19667b7b2c274a7cfa4cfbf09c"], "statement_hash": "468cd074434d5b124a2f3ad7e4d4363935368333f67c114d461285e65aadff62"}}, {"rule": 2, "type": "equivalent", "target": "2e2724c6cc505b0329f5a78d83fd96cb", "evidence": {"same_day": true, "patch_ids": ["910e6f19667b7b2c274a7cfa4cfbf09c"], "statement_hash": "468cd074434d5b124a2f3ad7e4d4363935368333f67c114d461285e65aadff62"}}, {"rule": 2, "type": "equivalent", "target": "4b8420c7de509df1179d8ee1c1364ee6", "evidence": {"same_day": true, "patch_ids": ["910e6f19667b7b2c274a7cfa4cfbf09c"], "statement_hash": "468cd074434d5b124a2f3ad7e4d4363935368333f67c114d461285e65aadff62"}}, {"rule": 2, "type": "equivalent", "target": "e7ce3c2946bfdef059fc3d3621ffd79d", "evidence": {"same_day": true, "patch_ids": ["910e6f19667b7b2c274a7cfa4cfbf09c"], "statement_hash": "468cd074434d5b124a2f3ad7e4d4363935368333f67c114d461285e65aadff62"}}], "version": "16.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4b8420c7de509df1179d8ee1c1364ee6", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Fix CREATE TABLE ... LIKE ... INCLUDING STATISTICS for cases where the source table has dropped column(s)", "evidence": {"same_day": true, "patch_ids": ["910e6f19667b7b2c274a7cfa4cfbf09c"], "statement_hash": "468cd074434d5b124a2f3ad7e4d4363935368333f67c114d461285e65aadff62"}, "url": "/docs/compare/?release=18.4#18.4-da4a103ca5dfdddc", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "e7ce3c2946bfdef059fc3d3621ffd79d", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Fix CREATE TABLE ... LIKE ... INCLUDING STATISTICS for cases where the source table has dropped column(s)", "evidence": {"same_day": true, "patch_ids": ["910e6f19667b7b2c274a7cfa4cfbf09c"], "statement_hash": "468cd074434d5b124a2f3ad7e4d4363935368333f67c114d461285e65aadff62"}, "url": "/docs/compare/?release=17.10#17.10-b893eef62a42d4d7", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "259f6916a28a7dd3bbeb72cc130b41a9", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Fix CREATE TABLE ... LIKE ... INCLUDING STATISTICS for cases where the source table has dropped column(s)", "evidence": {"same_day": true, "patch_ids": ["910e6f19667b7b2c274a7cfa4cfbf09c"], "statement_hash": "468cd074434d5b124a2f3ad7e4d4363935368333f67c114d461285e65aadff62"}, "url": "/docs/compare/?release=15.18#15.18-442a4e22f7b920a0", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "2e2724c6cc505b0329f5a78d83fd96cb", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Fix CREATE TABLE ... LIKE ... INCLUDING STATISTICS for cases where the source table has dropped column(s)", "evidence": {"same_day": true, "patch_ids": ["910e6f19667b7b2c274a7cfa4cfbf09c"], "statement_hash": "468cd074434d5b124a2f3ad7e4d4363935368333f67c114d461285e65aadff62"}, "url": "/docs/compare/?release=14.23#14.23-8c2e835d537dac09", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-afd48d79cce62769", "cves": [], "html": "Allow ALTER INDEX ... ATTACH PARTITION to mark the parent index valid if appropriate (Sami Imseih) §
There are edge cases in which a partitioned index might remain marked as invalid even when all its leaf indexes are valid. This change provides a mechanism whereby a user can correct such a situation without resorting to manual catalog updates.
", "text": "Allow ALTER INDEX ... ATTACH PARTITION to mark the parent index valid if appropriate (Sami Imseih) § There are edge cases in which a partitioned index might remain marked as invalid even when all its leaf indexes are valid. This change provides a mechanism whereby a user can correct such a situation without resorting to manual catalog updates.", "title": "Allow ALTER INDEX ... ATTACH PARTITION to mark the parent index valid if appropriate", "commits": ["313355d68"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "d1f5094c6694279b601390a4c1fbd9899936713c325a580dd29930c3055d99ce", "section_path": ["Changes"], "commit_groups": [["0859000d0", "313355d68", "5713ac248", "9d3e094f1", "becf6d269", "d809b16d1"]], "identity_text": "Allow ALTER INDEX ... ATTACH PARTITION to mark the parent index valid if appropriate (Sami Imseih) There are edge cases in which a partitioned index might remain marked as invalid even when all its leaf indexes are valid. This change provides a mechanism whereby a user can correct such a situation without resorting to manual catalog updates.", "commit_aliases": ["0859000d0", "313355d68", "5713ac248", "9d3e094f1", "becf6d269", "d809b16d1"], "source_commits": ["313355d68"], "source_entry_id": "16.14/changes/019", "db_id": "3b47c18aac1b9d5d839c6ae4de3ae964", "patch_ids": ["6f61faf076a411f9a9c18c51b74befa0"], "statement_hash": "d56280bb59ca7a2079394584e577949d3d1706a31278203bdc18b376a97f5ff5", "relations": [{"rule": 2, "type": "equivalent", "target": "15a0dfb907bce338c1244951e2379584", "evidence": {"same_day": true, "patch_ids": ["6f61faf076a411f9a9c18c51b74befa0"], "statement_hash": "d56280bb59ca7a2079394584e577949d3d1706a31278203bdc18b376a97f5ff5"}}, {"rule": 2, "type": "equivalent", "target": "73eae229fd96afa624d3ae9343724889", "evidence": {"same_day": true, "patch_ids": ["6f61faf076a411f9a9c18c51b74befa0"], "statement_hash": "d56280bb59ca7a2079394584e577949d3d1706a31278203bdc18b376a97f5ff5"}}, {"rule": 2, "type": "equivalent", "target": "9efa82150808ee72d1b174825d7f47d3", "evidence": {"same_day": true, "patch_ids": ["6f61faf076a411f9a9c18c51b74befa0"], "statement_hash": "d56280bb59ca7a2079394584e577949d3d1706a31278203bdc18b376a97f5ff5"}}, {"rule": 2, "type": "equivalent", "target": "ef8cca025501a2f559a921e005a2df3a", "evidence": {"same_day": true, "patch_ids": ["6f61faf076a411f9a9c18c51b74befa0"], "statement_hash": "d56280bb59ca7a2079394584e577949d3d1706a31278203bdc18b376a97f5ff5"}}], "version": "16.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "9efa82150808ee72d1b174825d7f47d3", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Allow ALTER INDEX ... ATTACH PARTITION to mark the parent index valid if appropriate", "evidence": {"same_day": true, "patch_ids": ["6f61faf076a411f9a9c18c51b74befa0"], "statement_hash": "d56280bb59ca7a2079394584e577949d3d1706a31278203bdc18b376a97f5ff5"}, "url": "/docs/compare/?release=18.4#18.4-720217f77930b818", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "73eae229fd96afa624d3ae9343724889", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Allow ALTER INDEX ... ATTACH PARTITION to mark the parent index valid if appropriate", "evidence": {"same_day": true, "patch_ids": ["6f61faf076a411f9a9c18c51b74befa0"], "statement_hash": "d56280bb59ca7a2079394584e577949d3d1706a31278203bdc18b376a97f5ff5"}, "url": "/docs/compare/?release=17.10#17.10-a232240e214fd3cc", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "15a0dfb907bce338c1244951e2379584", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Allow ALTER INDEX ... ATTACH PARTITION to mark the parent index valid if appropriate", "evidence": {"same_day": true, "patch_ids": ["6f61faf076a411f9a9c18c51b74befa0"], "statement_hash": "d56280bb59ca7a2079394584e577949d3d1706a31278203bdc18b376a97f5ff5"}, "url": "/docs/compare/?release=15.18#15.18-216b3db2d84f9f35", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "ef8cca025501a2f559a921e005a2df3a", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Allow ALTER INDEX ... ATTACH PARTITION to mark the parent index valid if appropriate", "evidence": {"same_day": true, "patch_ids": ["6f61faf076a411f9a9c18c51b74befa0"], "statement_hash": "d56280bb59ca7a2079394584e577949d3d1706a31278203bdc18b376a97f5ff5"}, "url": "/docs/compare/?release=14.23#14.23-eb7da046cd9a17ab", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-7bc648cad1956f2b", "cves": [], "html": "Fix ALTER FOREIGN DATA WRAPPER to not drop the wrapper object's dependency on its handler function (Jeff Davis) §
Disallow making a composite type be a member of itself via a multirange (Heikki Linnakangas) §
\nWe already forbade such cases when the intermediate type is a domain, array, composite type, or range; but multiranges were overlooked.
", "text": "Disallow making a composite type be a member of itself via a multirange (Heikki Linnakangas) § We already forbade such cases when the intermediate type is a domain, array, composite type, or range; but multiranges were overlooked.", "title": "Disallow making a composite type be a member of itself via a multirange", "commits": ["06e304524"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "0f6069ac3e521193ddb6f18b4a303259676811764d5b420e81b06f2bfa1615a6", "section_path": ["Changes"], "commit_groups": [["06e304524", "34ebeb15c", "54343f6f9", "c7a1d5fc6", "dd4069197", "ff8f27d6e"]], "identity_text": "Disallow making a composite type be a member of itself via a multirange (Heikki Linnakangas) We already forbade such cases when the intermediate type is a domain, array, composite type, or range; but multiranges were overlooked.", "commit_aliases": ["06e304524", "34ebeb15c", "54343f6f9", "c7a1d5fc6", "dd4069197", "ff8f27d6e"], "source_commits": ["06e304524"], "source_entry_id": "16.14/changes/021", "db_id": "aaf1253e3301e7ce01966fdecb2168ff", "patch_ids": ["31c00f6d7ed28a6712dcf1e113075156"], "statement_hash": "6b4527853dd5e8e984500173324ec598d423dfc66e71302f1bdff48a4af1e5d2", "relations": [{"rule": 2, "type": "equivalent", "target": "db27ce7162c0f5f66e5e36b2b4394be0", "evidence": {"same_day": true, "patch_ids": ["31c00f6d7ed28a6712dcf1e113075156"], "statement_hash": "6b4527853dd5e8e984500173324ec598d423dfc66e71302f1bdff48a4af1e5d2"}}, {"rule": 2, "type": "equivalent", "target": "dbfa0390a811562580299aed6addef7f", "evidence": {"same_day": true, "patch_ids": ["31c00f6d7ed28a6712dcf1e113075156"], "statement_hash": "6b4527853dd5e8e984500173324ec598d423dfc66e71302f1bdff48a4af1e5d2"}}, {"rule": 2, "type": "equivalent", "target": "e0d6011d1ad1750ec99d7b452609aa5c", "evidence": {"same_day": true, "patch_ids": ["31c00f6d7ed28a6712dcf1e113075156"], "statement_hash": "6b4527853dd5e8e984500173324ec598d423dfc66e71302f1bdff48a4af1e5d2"}}, {"rule": 2, "type": "equivalent", "target": "e65839c47b604979321948f58b376888", "evidence": {"same_day": true, "patch_ids": ["31c00f6d7ed28a6712dcf1e113075156"], "statement_hash": "6b4527853dd5e8e984500173324ec598d423dfc66e71302f1bdff48a4af1e5d2"}}], "version": "16.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "e65839c47b604979321948f58b376888", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Disallow making a composite type be a member of itself via a multirange", "evidence": {"same_day": true, "patch_ids": ["31c00f6d7ed28a6712dcf1e113075156"], "statement_hash": "6b4527853dd5e8e984500173324ec598d423dfc66e71302f1bdff48a4af1e5d2"}, "url": "/docs/compare/?release=18.4#18.4-ccc5811ee220170a", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "dbfa0390a811562580299aed6addef7f", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Disallow making a composite type be a member of itself via a multirange", "evidence": {"same_day": true, "patch_ids": ["31c00f6d7ed28a6712dcf1e113075156"], "statement_hash": "6b4527853dd5e8e984500173324ec598d423dfc66e71302f1bdff48a4af1e5d2"}, "url": "/docs/compare/?release=17.10#17.10-a17faaa60c3b23db", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "db27ce7162c0f5f66e5e36b2b4394be0", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Disallow making a composite type be a member of itself via a multirange", "evidence": {"same_day": true, "patch_ids": ["31c00f6d7ed28a6712dcf1e113075156"], "statement_hash": "6b4527853dd5e8e984500173324ec598d423dfc66e71302f1bdff48a4af1e5d2"}, "url": "/docs/compare/?release=15.18#15.18-1b434ad500a69006", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "e0d6011d1ad1750ec99d7b452609aa5c", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Disallow making a composite type be a member of itself via a multirange", "evidence": {"same_day": true, "patch_ids": ["31c00f6d7ed28a6712dcf1e113075156"], "statement_hash": "6b4527853dd5e8e984500173324ec598d423dfc66e71302f1bdff48a4af1e5d2"}, "url": "/docs/compare/?release=14.23#14.23-50453b6dffac196c", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-8586f1e2f65191db", "cves": [], "html": "Fix datum-image comparisons to be insensitive to sign-extension variations (David Rowley) §
\nThis fixes some situations that previously led to “could not find memoization table entry” errors or wrong query results.
", "text": "Fix datum-image comparisons to be insensitive to sign-extension variations (David Rowley) § This fixes some situations that previously led to “could not find memoization table entry” errors or wrong query results.", "title": "Fix datum-image comparisons to be insensitive to sign-extension variations", "commits": ["1bd90c887"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "b8d1b98019404775500286e0b88d912a20745113ba767300d1e8b664cd28f68f", "section_path": ["Changes"], "commit_groups": [["0d866282b", "1bd90c887", "49315de0c", "6b2e091f0", "6ce5c310b", "d29808e35"]], "identity_text": "Fix datum-image comparisons to be insensitive to sign-extension variations (David Rowley) This fixes some situations that previously led to could not find memoization table entry errors or wrong query results.", "commit_aliases": ["0d866282b", "1bd90c887", "49315de0c", "6b2e091f0", "6ce5c310b", "d29808e35"], "source_commits": ["1bd90c887"], "source_entry_id": "16.14/changes/022", "db_id": "e186e88d722a03078d4189e25842fa12", "patch_ids": ["8b2152dc84fbefe58a465b0d497fe197"], "statement_hash": "95b38df8932c40bbb6eed0884f5ec817fd4ee7218c45df42545da1f44dd8095a", "relations": [{"rule": 2, "type": "equivalent", "target": "5cabc37ab2a14b9bb0980c3ed400e023", "evidence": {"same_day": true, "patch_ids": ["8b2152dc84fbefe58a465b0d497fe197"], "statement_hash": "95b38df8932c40bbb6eed0884f5ec817fd4ee7218c45df42545da1f44dd8095a"}}, {"rule": 2, "type": "equivalent", "target": "6de901a8850aaba4f6cb4f60757fd10b", "evidence": {"same_day": true, "patch_ids": ["8b2152dc84fbefe58a465b0d497fe197"], "statement_hash": "95b38df8932c40bbb6eed0884f5ec817fd4ee7218c45df42545da1f44dd8095a"}}, {"rule": 2, "type": "equivalent", "target": "c5c180d0b102c66e23f3e5c67497661a", "evidence": {"same_day": true, "patch_ids": ["8b2152dc84fbefe58a465b0d497fe197"], "statement_hash": "95b38df8932c40bbb6eed0884f5ec817fd4ee7218c45df42545da1f44dd8095a"}}, {"rule": 2, "type": "equivalent", "target": "f9a962dc778922758842bad523e4e935", "evidence": {"same_day": true, "patch_ids": ["8b2152dc84fbefe58a465b0d497fe197"], "statement_hash": "95b38df8932c40bbb6eed0884f5ec817fd4ee7218c45df42545da1f44dd8095a"}}], "version": "16.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c5c180d0b102c66e23f3e5c67497661a", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Fix datum-image comparisons to be insensitive to sign-extension variations", "evidence": {"same_day": true, "patch_ids": ["8b2152dc84fbefe58a465b0d497fe197"], "statement_hash": "95b38df8932c40bbb6eed0884f5ec817fd4ee7218c45df42545da1f44dd8095a"}, "url": "/docs/compare/?release=18.4#18.4-4ed3df97c772ff79", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "f9a962dc778922758842bad523e4e935", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Fix datum-image comparisons to be insensitive to sign-extension variations", "evidence": {"same_day": true, "patch_ids": ["8b2152dc84fbefe58a465b0d497fe197"], "statement_hash": "95b38df8932c40bbb6eed0884f5ec817fd4ee7218c45df42545da1f44dd8095a"}, "url": "/docs/compare/?release=17.10#17.10-0fb5ea65c461a113", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "6de901a8850aaba4f6cb4f60757fd10b", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Fix datum-image comparisons to be insensitive to sign-extension variations", "evidence": {"same_day": true, "patch_ids": ["8b2152dc84fbefe58a465b0d497fe197"], "statement_hash": "95b38df8932c40bbb6eed0884f5ec817fd4ee7218c45df42545da1f44dd8095a"}, "url": "/docs/compare/?release=15.18#15.18-35c4133cc110d098", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "5cabc37ab2a14b9bb0980c3ed400e023", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Fix datum-image comparisons to be insensitive to sign-extension variations", "evidence": {"same_day": true, "patch_ids": ["8b2152dc84fbefe58a465b0d497fe197"], "statement_hash": "95b38df8932c40bbb6eed0884f5ec817fd4ee7218c45df42545da1f44dd8095a"}, "url": "/docs/compare/?release=14.23#14.23-92e44334a5563e50", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-0eb4bde24f0d6fca", "cves": [], "html": "Fix incorrect logic for hashed IN/NOT IN with non-strict equality operator (Chengpeng Yan) §
The previous coding could crash or give wrong answers. All built-in data types have strict equality operators, so that this issue could only arise with an extension data type.
", "text": "Fix incorrect logic for hashed IN/NOT IN with non-strict equality operator (Chengpeng Yan) § The previous coding could crash or give wrong answers. All built-in data types have strict equality operators, so that this issue could only arise with an extension data type.", "title": "Fix incorrect logic for hashed IN/NOT IN with non-strict equality operator", "commits": ["a2a0060d5"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "8c84ca1705b094eecee6f7a93b5978ef6ef4b55c127402dd956ae3e9cd9ca627", "section_path": ["Changes"], "commit_groups": [["035c520db", "109de35b7", "3fda3e12f", "622f8b530", "94219a73f", "a2a0060d5"]], "identity_text": "Fix incorrect logic for hashed IN/NOT IN with non-strict equality operator (Chengpeng Yan) The previous coding could crash or give wrong answers. All built-in data types have strict equality operators, so that this issue could only arise with an extension data type.", "commit_aliases": ["035c520db", "109de35b7", "3fda3e12f", "622f8b530", "94219a73f", "a2a0060d5"], "source_commits": ["a2a0060d5"], "source_entry_id": "16.14/changes/023", "db_id": "c26aa4cfe9a48bc8f6b4f3924802efa7", "patch_ids": ["73bcd2dbc996c0415640dea74d4f247f"], "statement_hash": "f620e21c617639503e22ec199ea3bdfd888287e95b5e026131bfa74e2fd18e5d", "relations": [{"rule": 2, "type": "equivalent", "target": "2a86497013a318262f46769723449b63", "evidence": {"same_day": true, "patch_ids": ["73bcd2dbc996c0415640dea74d4f247f"], "statement_hash": "f620e21c617639503e22ec199ea3bdfd888287e95b5e026131bfa74e2fd18e5d"}}, {"rule": 2, "type": "equivalent", "target": "450e4329b437178c4c67084a2ce52024", "evidence": {"same_day": true, "patch_ids": ["73bcd2dbc996c0415640dea74d4f247f"], "statement_hash": "f620e21c617639503e22ec199ea3bdfd888287e95b5e026131bfa74e2fd18e5d"}}, {"rule": 2, "type": "equivalent", "target": "6a9e4a1d32172e81ee680d6f0342ca63", "evidence": {"same_day": true, "patch_ids": ["73bcd2dbc996c0415640dea74d4f247f"], "statement_hash": "f620e21c617639503e22ec199ea3bdfd888287e95b5e026131bfa74e2fd18e5d"}}, {"rule": 2, "type": "equivalent", "target": "d1a95a788ffc450fd8a8b393d2c3e55d", "evidence": {"same_day": true, "patch_ids": ["73bcd2dbc996c0415640dea74d4f247f"], "statement_hash": "f620e21c617639503e22ec199ea3bdfd888287e95b5e026131bfa74e2fd18e5d"}}], "version": "16.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "d1a95a788ffc450fd8a8b393d2c3e55d", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Fix incorrect logic for hashed IN/NOT IN with non-strict equality operator", "evidence": {"same_day": true, "patch_ids": ["73bcd2dbc996c0415640dea74d4f247f"], "statement_hash": "f620e21c617639503e22ec199ea3bdfd888287e95b5e026131bfa74e2fd18e5d"}, "url": "/docs/compare/?release=18.4#18.4-e5344bf8a6d35197", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "6a9e4a1d32172e81ee680d6f0342ca63", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Fix incorrect logic for hashed IN/NOT IN with non-strict equality operator", "evidence": {"same_day": true, "patch_ids": ["73bcd2dbc996c0415640dea74d4f247f"], "statement_hash": "f620e21c617639503e22ec199ea3bdfd888287e95b5e026131bfa74e2fd18e5d"}, "url": "/docs/compare/?release=17.10#17.10-c7e5a864f1920ba5", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "450e4329b437178c4c67084a2ce52024", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Fix incorrect logic for hashed IN/NOT IN with non-strict equality operator", "evidence": {"same_day": true, "patch_ids": ["73bcd2dbc996c0415640dea74d4f247f"], "statement_hash": "f620e21c617639503e22ec199ea3bdfd888287e95b5e026131bfa74e2fd18e5d"}, "url": "/docs/compare/?release=15.18#15.18-60c7c179902fa568", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "2a86497013a318262f46769723449b63", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Fix incorrect logic for hashed IN/NOT IN with non-strict equality operator", "evidence": {"same_day": true, "patch_ids": ["73bcd2dbc996c0415640dea74d4f247f"], "statement_hash": "f620e21c617639503e22ec199ea3bdfd888287e95b5e026131bfa74e2fd18e5d"}, "url": "/docs/compare/?release=14.23#14.23-7486ce91b98a0959", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-eda4c756b58b4a86", "cves": [], "html": "Truncate overly-long locale-specific numeric symbols in to_char() (Tom Lane) §
If a locale specified a currency symbol, thousands separator, or decimal or sign symbol more than 8 bytes long, a buffer overrun was possible. No such locales exist in the real world, and it's impractical for an unprivileged attacker to install a malicious locale definition underneath a Postgres server; but for safety's sake check for overlength symbols and truncate if needed.
", "text": "Truncate overly-long locale-specific numeric symbols in to_char() (Tom Lane) § If a locale specified a currency symbol, thousands separator, or decimal or sign symbol more than 8 bytes long, a buffer overrun was possible. No such locales exist in the real world, and it's impractical for an unprivileged attacker to install a malicious locale definition underneath a Postgres server; but for safety's sake check for overlength symbols and truncate if needed.", "title": "Truncate overly-long locale-specific numeric symbols in to_char()", "commits": ["e1e60f148"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "8115432cd72a0f7acc07558adbf8e8ff94e2517455a4de00a661cff32cfef2d4", "section_path": ["Changes"], "commit_groups": [["580e7be88", "8a6f08c0c", "a50777680", "c97a28618", "e1e60f148", "f60d25986"]], "identity_text": "Truncate overly-long locale-specific numeric symbols in to_char() (Tom Lane) If a locale specified a currency symbol, thousands separator, or decimal or sign symbol more than 8 bytes long, a buffer overrun was possible. No such locales exist in the real world, and it's impractical for an unprivileged attacker to install a malicious locale definition underneath a Postgres server; but for safety's sake check for overlength symbols and truncate if needed.", "commit_aliases": ["580e7be88", "8a6f08c0c", "a50777680", "c97a28618", "e1e60f148", "f60d25986"], "source_commits": ["e1e60f148"], "source_entry_id": "16.14/changes/024", "db_id": "7477baaf42cc60c640f8610e0225343b", "patch_ids": ["a55b3cc17f0905d7ae426fd181a6dfc3"], "statement_hash": "faa5531634d9cdfe864f4512cf61a4628efe72bf20a627237eac6e0fc2e723b0", "relations": [{"rule": 2, "type": "equivalent", "target": "07daab7dbccbfcc34db05980b3a74098", "evidence": {"same_day": true, "patch_ids": ["a55b3cc17f0905d7ae426fd181a6dfc3"], "statement_hash": "faa5531634d9cdfe864f4512cf61a4628efe72bf20a627237eac6e0fc2e723b0"}}, {"rule": 2, "type": "equivalent", "target": "29acc0aac3cc6b0ee03ac19b4559887d", "evidence": {"same_day": true, "patch_ids": ["a55b3cc17f0905d7ae426fd181a6dfc3"], "statement_hash": "faa5531634d9cdfe864f4512cf61a4628efe72bf20a627237eac6e0fc2e723b0"}}, {"rule": 2, "type": "equivalent", "target": "606d4464f34532059b31083c8d4b85db", "evidence": {"same_day": true, "patch_ids": ["a55b3cc17f0905d7ae426fd181a6dfc3"], "statement_hash": "faa5531634d9cdfe864f4512cf61a4628efe72bf20a627237eac6e0fc2e723b0"}}, {"rule": 2, "type": "equivalent", "target": "da89f430482b72634ad3d2f296bb5a93", "evidence": {"same_day": true, "patch_ids": ["a55b3cc17f0905d7ae426fd181a6dfc3"], "statement_hash": "faa5531634d9cdfe864f4512cf61a4628efe72bf20a627237eac6e0fc2e723b0"}}], "version": "16.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "606d4464f34532059b31083c8d4b85db", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Truncate overly-long locale-specific numeric symbols in to_char()", "evidence": {"same_day": true, "patch_ids": ["a55b3cc17f0905d7ae426fd181a6dfc3"], "statement_hash": "faa5531634d9cdfe864f4512cf61a4628efe72bf20a627237eac6e0fc2e723b0"}, "url": "/docs/compare/?release=18.4#18.4-695d3a73d2ecfb3e", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "07daab7dbccbfcc34db05980b3a74098", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Truncate overly-long locale-specific numeric symbols in to_char()", "evidence": {"same_day": true, "patch_ids": ["a55b3cc17f0905d7ae426fd181a6dfc3"], "statement_hash": "faa5531634d9cdfe864f4512cf61a4628efe72bf20a627237eac6e0fc2e723b0"}, "url": "/docs/compare/?release=17.10#17.10-ead7a4370e3d50c0", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "29acc0aac3cc6b0ee03ac19b4559887d", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Truncate overly-long locale-specific numeric symbols in to_char()", "evidence": {"same_day": true, "patch_ids": ["a55b3cc17f0905d7ae426fd181a6dfc3"], "statement_hash": "faa5531634d9cdfe864f4512cf61a4628efe72bf20a627237eac6e0fc2e723b0"}, "url": "/docs/compare/?release=15.18#15.18-d044032a493dc642", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "da89f430482b72634ad3d2f296bb5a93", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Truncate overly-long locale-specific numeric symbols in to_char()", "evidence": {"same_day": true, "patch_ids": ["a55b3cc17f0905d7ae426fd181a6dfc3"], "statement_hash": "faa5531634d9cdfe864f4512cf61a4628efe72bf20a627237eac6e0fc2e723b0"}, "url": "/docs/compare/?release=14.23#14.23-a905b9ca587d8842", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-0a0d8d6349e3929d", "cves": [], "html": "Prevent buffer overruns when parsing an affix file for an Ispell dictionary (Tom Lane) § §
A corrupt or malicious affix file could crash the server. This is not considered a security issue because text search configuration files are presumed trustworthy, but it still seems worth fixing.
", "text": "Prevent buffer overruns when parsing an affix file for an Ispell dictionary (Tom Lane) § § A corrupt or malicious affix file could crash the server. This is not considered a security issue because text search configuration files are presumed trustworthy, but it still seems worth fixing.", "title": "Prevent buffer overruns when parsing an affix file for an Ispell dictionary", "commits": ["17f72e037", "42383d32d"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "ce1b9b7b5f6e4f6a24863c1b589da5e76876bdfb1e9fb1832637bcc9787618ae", "section_path": ["Changes"], "commit_groups": [["00c6e0819", "0b196d3db", "21a24d709", "42383d32d", "d7970e7e9", "ea5f0d176"], ["17f72e037", "6cae0c2bd", "844bb90d4", "a5426dbf8", "c2bfeb3bb", "f852c9093"]], "identity_text": "Prevent buffer overruns when parsing an affix file for an Ispell dictionary (Tom Lane) A corrupt or malicious affix file could crash the server. This is not considered a security issue because text search configuration files are presumed trustworthy, but it still seems worth fixing.", "commit_aliases": ["00c6e0819", "0b196d3db", "17f72e037", "21a24d709", "42383d32d", "6cae0c2bd", "844bb90d4", "a5426dbf8", "c2bfeb3bb", "d7970e7e9", "ea5f0d176", "f852c9093"], "source_commits": ["17f72e037", "42383d32d"], "source_entry_id": "16.14/changes/025", "db_id": "cd403cd225ef88fed48df9f593dd683b", "patch_ids": ["3b2347be1395aa44c1c6ae6a8fa24149", "fb61cc9fc6ef6ecc94c4f87d31a648bd"], "statement_hash": "6442ebdc43f39cc7a336c76cc8f8bcdfb68cc5683190ee35457bd8a1cd9e22d8", "relations": [{"rule": 2, "type": "equivalent", "target": "12f322f4feb75f55804ad196b114a9d6", "evidence": {"same_day": true, "patch_ids": ["3b2347be1395aa44c1c6ae6a8fa24149", "fb61cc9fc6ef6ecc94c4f87d31a648bd"], "statement_hash": "6442ebdc43f39cc7a336c76cc8f8bcdfb68cc5683190ee35457bd8a1cd9e22d8"}}, {"rule": 2, "type": "equivalent", "target": "2b5095497f4832976becc4b644155c51", "evidence": {"same_day": true, "patch_ids": ["3b2347be1395aa44c1c6ae6a8fa24149", "fb61cc9fc6ef6ecc94c4f87d31a648bd"], "statement_hash": "6442ebdc43f39cc7a336c76cc8f8bcdfb68cc5683190ee35457bd8a1cd9e22d8"}}, {"rule": 2, "type": "equivalent", "target": "5f8b6d695a4f9576cfb99b263e2e4ff7", "evidence": {"same_day": true, "patch_ids": ["3b2347be1395aa44c1c6ae6a8fa24149", "fb61cc9fc6ef6ecc94c4f87d31a648bd"], "statement_hash": "6442ebdc43f39cc7a336c76cc8f8bcdfb68cc5683190ee35457bd8a1cd9e22d8"}}, {"rule": 2, "type": "equivalent", "target": "f2129c1b029d4e186640295ff2fd808d", "evidence": {"same_day": true, "patch_ids": ["3b2347be1395aa44c1c6ae6a8fa24149", "fb61cc9fc6ef6ecc94c4f87d31a648bd"], "statement_hash": "6442ebdc43f39cc7a336c76cc8f8bcdfb68cc5683190ee35457bd8a1cd9e22d8"}}], "version": "16.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "12f322f4feb75f55804ad196b114a9d6", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Prevent buffer overruns when parsing an affix file for an Ispell dictionary", "evidence": {"same_day": true, "patch_ids": ["3b2347be1395aa44c1c6ae6a8fa24149", "fb61cc9fc6ef6ecc94c4f87d31a648bd"], "statement_hash": "6442ebdc43f39cc7a336c76cc8f8bcdfb68cc5683190ee35457bd8a1cd9e22d8"}, "url": "/docs/compare/?release=18.4#18.4-e6587b3cd0787b2e", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "2b5095497f4832976becc4b644155c51", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Prevent buffer overruns when parsing an affix file for an Ispell dictionary", "evidence": {"same_day": true, "patch_ids": ["3b2347be1395aa44c1c6ae6a8fa24149", "fb61cc9fc6ef6ecc94c4f87d31a648bd"], "statement_hash": "6442ebdc43f39cc7a336c76cc8f8bcdfb68cc5683190ee35457bd8a1cd9e22d8"}, "url": "/docs/compare/?release=17.10#17.10-666b81e0c79b2b28", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "5f8b6d695a4f9576cfb99b263e2e4ff7", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Prevent buffer overruns when parsing an affix file for an Ispell dictionary", "evidence": {"same_day": true, "patch_ids": ["3b2347be1395aa44c1c6ae6a8fa24149", "fb61cc9fc6ef6ecc94c4f87d31a648bd"], "statement_hash": "6442ebdc43f39cc7a336c76cc8f8bcdfb68cc5683190ee35457bd8a1cd9e22d8"}, "url": "/docs/compare/?release=15.18#15.18-87e3f08b5312ecda", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "f2129c1b029d4e186640295ff2fd808d", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Prevent buffer overruns when parsing an affix file for an Ispell dictionary", "evidence": {"same_day": true, "patch_ids": ["3b2347be1395aa44c1c6ae6a8fa24149", "fb61cc9fc6ef6ecc94c4f87d31a648bd"], "statement_hash": "6442ebdc43f39cc7a336c76cc8f8bcdfb68cc5683190ee35457bd8a1cd9e22d8"}, "url": "/docs/compare/?release=14.23#14.23-1446a031fd4414f4", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-ed110186d7aac633", "cves": [], "html": "Guard against integer overflow in calculations of frame start and end positions for window aggregates (Richard Guo) §
\nVery large user-specified offsets (close to INT64_MAX) could result in errors or incorrect query results.
", "text": "Guard against integer overflow in calculations of frame start and end positions for window aggregates (Richard Guo) § Very large user-specified offsets (close to INT64_MAX) could result in errors or incorrect query results.", "title": "Guard against integer overflow in calculations of frame start and end positions for window aggregates", "commits": ["0fe032e6a"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "0da55467a4e64b6be539db3036c6f16cc63586f862326eaa588b58dd8eedabc5", "section_path": ["Changes"], "commit_groups": [["0fe032e6a", "305cf0df0", "4da71fc37", "8b6c89e37", "bfc7dff26", "f8736f8bc"]], "identity_text": "Guard against integer overflow in calculations of frame start and end positions for window aggregates (Richard Guo) Very large user-specified offsets (close to INT64_MAX) could result in errors or incorrect query results.", "commit_aliases": ["0fe032e6a", "305cf0df0", "4da71fc37", "8b6c89e37", "bfc7dff26", "f8736f8bc"], "source_commits": ["0fe032e6a"], "source_entry_id": "16.14/changes/026", "db_id": "9a742821f3f95e4a90a5c8c342890d50", "patch_ids": ["55f185c77388b5ccf5f79078a7a19b0b"], "statement_hash": "84aa1ad98df37853c6497eff68ec71c4a468e09bd91604bc168bf3a8ad45d544", "relations": [{"rule": 2, "type": "equivalent", "target": "511c913495519e0301f1fb895b89e0e3", "evidence": {"same_day": true, "patch_ids": ["55f185c77388b5ccf5f79078a7a19b0b"], "statement_hash": "84aa1ad98df37853c6497eff68ec71c4a468e09bd91604bc168bf3a8ad45d544"}}, {"rule": 2, "type": "equivalent", "target": "8ad5f4df6d3f1b7115577a0c720eb3e0", "evidence": {"same_day": true, "patch_ids": ["55f185c77388b5ccf5f79078a7a19b0b"], "statement_hash": "84aa1ad98df37853c6497eff68ec71c4a468e09bd91604bc168bf3a8ad45d544"}}, {"rule": 2, "type": "equivalent", "target": "cac7bd4fb899dfb735baa61da9c859ec", "evidence": {"same_day": true, "patch_ids": ["55f185c77388b5ccf5f79078a7a19b0b"], "statement_hash": "84aa1ad98df37853c6497eff68ec71c4a468e09bd91604bc168bf3a8ad45d544"}}, {"rule": 2, "type": "equivalent", "target": "f1cd95144d4553602b7e2fbfe36961ad", "evidence": {"same_day": true, "patch_ids": ["55f185c77388b5ccf5f79078a7a19b0b"], "statement_hash": "84aa1ad98df37853c6497eff68ec71c4a468e09bd91604bc168bf3a8ad45d544"}}], "version": "16.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "511c913495519e0301f1fb895b89e0e3", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Guard against integer overflow in calculations of frame start and end positions for window aggregates", "evidence": {"same_day": true, "patch_ids": ["55f185c77388b5ccf5f79078a7a19b0b"], "statement_hash": "84aa1ad98df37853c6497eff68ec71c4a468e09bd91604bc168bf3a8ad45d544"}, "url": "/docs/compare/?release=18.4#18.4-e679f36c64f131bf", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "f1cd95144d4553602b7e2fbfe36961ad", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Guard against integer overflow in calculations of frame start and end positions for window aggregates", "evidence": {"same_day": true, "patch_ids": ["55f185c77388b5ccf5f79078a7a19b0b"], "statement_hash": "84aa1ad98df37853c6497eff68ec71c4a468e09bd91604bc168bf3a8ad45d544"}, "url": "/docs/compare/?release=17.10#17.10-9cc0aae20d353dbd", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "8ad5f4df6d3f1b7115577a0c720eb3e0", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Guard against integer overflow in calculations of frame start and end positions for window aggregates", "evidence": {"same_day": true, "patch_ids": ["55f185c77388b5ccf5f79078a7a19b0b"], "statement_hash": "84aa1ad98df37853c6497eff68ec71c4a468e09bd91604bc168bf3a8ad45d544"}, "url": "/docs/compare/?release=15.18#15.18-41f6cd511e262ba3", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "cac7bd4fb899dfb735baa61da9c859ec", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Guard against integer overflow in calculations of frame start and end positions for window aggregates", "evidence": {"same_day": true, "patch_ids": ["55f185c77388b5ccf5f79078a7a19b0b"], "statement_hash": "84aa1ad98df37853c6497eff68ec71c4a468e09bd91604bc168bf3a8ad45d544"}, "url": "/docs/compare/?release=14.23#14.23-170736a74064aa19", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-1a064ff9422dee0d", "cves": [], "html": "Fix array_agg_array_combine() to combine the arrays' null bitmaps correctly (Dmytro Astapov) §
This mistake resulted in sometimes-incorrect output from parallelized array_agg(anyarray) calculations.
Retry sync_file_range() if it returns error code EINTR (DaeMyung Kang) §
Fix incorrect behavior of pg_stat_reset_single_table_counters() on a shared catalog (Chao Li) §
Such cases had a side-effect of resetting the current database's stat_reset_timestamp, which was unintended.
Update activity statistics when a parallel apply worker is idle (Zhijie Hou) §
\nPreviously, statistics from a recently-completed transaction might go unreported for long intervals, particularly if the workload is light.
", "text": "Update activity statistics when a parallel apply worker is idle (Zhijie Hou) § Previously, statistics from a recently-completed transaction might go unreported for long intervals, particularly if the workload is light.", "title": "Update activity statistics when a parallel apply worker is idle", "commits": ["d052f6c7d"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "fef4715b7f1b5a32f6ace791ca4daf5877e936bb96fc298a80d8104a96b463b5", "section_path": ["Changes"], "commit_groups": [["090c4297e", "44c8dc280", "88d7fdcc9", "d052f6c7d"]], "identity_text": "Update activity statistics when a parallel apply worker is idle (Zhijie Hou) Previously, statistics from a recently-completed transaction might go unreported for long intervals, particularly if the workload is light.", "commit_aliases": ["090c4297e", "44c8dc280", "88d7fdcc9", "d052f6c7d"], "source_commits": ["d052f6c7d"], "source_entry_id": "16.14/changes/030", "db_id": "677b87203fcf8da98790d6378484a333", "patch_ids": ["2d9114e9de0545265b46f9271e79774e"], "statement_hash": "1425951cf41b73475715e34b86444749dadef32d8dd753ca05fb84c5dcab7db0", "relations": [{"rule": 2, "type": "equivalent", "target": "96a3e2b2d17bbc2072d29a84e39fe9f0", "evidence": {"same_day": true, "patch_ids": ["2d9114e9de0545265b46f9271e79774e"], "statement_hash": "1425951cf41b73475715e34b86444749dadef32d8dd753ca05fb84c5dcab7db0"}}, {"rule": 2, "type": "equivalent", "target": "980b17cc0e380660feb5723048978d0c", "evidence": {"same_day": true, "patch_ids": ["2d9114e9de0545265b46f9271e79774e"], "statement_hash": "1425951cf41b73475715e34b86444749dadef32d8dd753ca05fb84c5dcab7db0"}}], "version": "16.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "980b17cc0e380660feb5723048978d0c", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Update activity statistics when a parallel apply worker is idle", "evidence": {"same_day": true, "patch_ids": ["2d9114e9de0545265b46f9271e79774e"], "statement_hash": "1425951cf41b73475715e34b86444749dadef32d8dd753ca05fb84c5dcab7db0"}, "url": "/docs/compare/?release=18.4#18.4-c51eded9a9ad369c", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "96a3e2b2d17bbc2072d29a84e39fe9f0", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Update activity statistics when a parallel apply worker is idle", "evidence": {"same_day": true, "patch_ids": ["2d9114e9de0545265b46f9271e79774e"], "statement_hash": "1425951cf41b73475715e34b86444749dadef32d8dd753ca05fb84c5dcab7db0"}, "url": "/docs/compare/?release=17.10#17.10-ab22f7a64370fbd6", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}]}, {"id": "16.14-43db7f38ffec18ea", "cves": [], "html": "Fix buffer overread when pglz_decompress() receives corrupt input (Andrew Dunstan) §
It was possible to read a few bytes past the end of the input, which in very unlucky cases might cause a crash.
", "text": "Fix buffer overread when pglz_decompress() receives corrupt input (Andrew Dunstan) § It was possible to read a few bytes past the end of the input, which in very unlucky cases might cause a crash.", "title": "Fix buffer overread when pglz_decompress() receives corrupt input", "commits": ["e630f65d0"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "39d752ba4f7e212951ceedc6170db744512ac99932e5568e4e13b3150af227f4", "section_path": ["Changes"], "commit_groups": [["2b5ba2a0a", "c05c3baf1", "c3e436b1c", "c88ad3a21", "de32a01e7", "e630f65d0"]], "identity_text": "Fix buffer overread when pglz_decompress() receives corrupt input (Andrew Dunstan) It was possible to read a few bytes past the end of the input, which in very unlucky cases might cause a crash.", "commit_aliases": ["2b5ba2a0a", "c05c3baf1", "c3e436b1c", "c88ad3a21", "de32a01e7", "e630f65d0"], "source_commits": ["e630f65d0"], "source_entry_id": "16.14/changes/031", "db_id": "f313199e743d40f3a6df92ac0387bcfa", "patch_ids": ["c0bb5d07bdfbe114b7578587383a80fa"], "statement_hash": "bd7b2a40bb8d7d7798cf8ecb76df72f44a9455b09e9d2f6b36769b9fa697b84d", "relations": [{"rule": 2, "type": "equivalent", "target": "0ae0f8c53b17ca5f253bbab76a0d9b74", "evidence": {"same_day": true, "patch_ids": ["c0bb5d07bdfbe114b7578587383a80fa"], "statement_hash": "bd7b2a40bb8d7d7798cf8ecb76df72f44a9455b09e9d2f6b36769b9fa697b84d"}}, {"rule": 2, "type": "equivalent", "target": "31b4e32fc9a04113a1aeaa4d2e794a7e", "evidence": {"same_day": true, "patch_ids": ["c0bb5d07bdfbe114b7578587383a80fa"], "statement_hash": "bd7b2a40bb8d7d7798cf8ecb76df72f44a9455b09e9d2f6b36769b9fa697b84d"}}, {"rule": 2, "type": "equivalent", "target": "7d77c3cf4d2df5b2b05bab302e7d6447", "evidence": {"same_day": true, "patch_ids": ["c0bb5d07bdfbe114b7578587383a80fa"], "statement_hash": "bd7b2a40bb8d7d7798cf8ecb76df72f44a9455b09e9d2f6b36769b9fa697b84d"}}, {"rule": 2, "type": "equivalent", "target": "8f0710244d42d6ab314f2ef4a78fa91d", "evidence": {"same_day": true, "patch_ids": ["c0bb5d07bdfbe114b7578587383a80fa"], "statement_hash": "bd7b2a40bb8d7d7798cf8ecb76df72f44a9455b09e9d2f6b36769b9fa697b84d"}}], "version": "16.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "0ae0f8c53b17ca5f253bbab76a0d9b74", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Fix buffer overread when pglz_decompress() receives corrupt input", "evidence": {"same_day": true, "patch_ids": ["c0bb5d07bdfbe114b7578587383a80fa"], "statement_hash": "bd7b2a40bb8d7d7798cf8ecb76df72f44a9455b09e9d2f6b36769b9fa697b84d"}, "url": "/docs/compare/?release=18.4#18.4-1b7a6be51f8649d8", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "7d77c3cf4d2df5b2b05bab302e7d6447", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Fix buffer overread when pglz_decompress() receives corrupt input", "evidence": {"same_day": true, "patch_ids": ["c0bb5d07bdfbe114b7578587383a80fa"], "statement_hash": "bd7b2a40bb8d7d7798cf8ecb76df72f44a9455b09e9d2f6b36769b9fa697b84d"}, "url": "/docs/compare/?release=17.10#17.10-fc2a0ba457a12efa", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "8f0710244d42d6ab314f2ef4a78fa91d", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Fix buffer overread when pglz_decompress() receives corrupt input", "evidence": {"same_day": true, "patch_ids": ["c0bb5d07bdfbe114b7578587383a80fa"], "statement_hash": "bd7b2a40bb8d7d7798cf8ecb76df72f44a9455b09e9d2f6b36769b9fa697b84d"}, "url": "/docs/compare/?release=15.18#15.18-e99de70478646f68", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "31b4e32fc9a04113a1aeaa4d2e794a7e", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Fix buffer overread when pglz_decompress() receives corrupt input", "evidence": {"same_day": true, "patch_ids": ["c0bb5d07bdfbe114b7578587383a80fa"], "statement_hash": "bd7b2a40bb8d7d7798cf8ecb76df72f44a9455b09e9d2f6b36769b9fa697b84d"}, "url": "/docs/compare/?release=14.23#14.23-a9f0074e1ae26260", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-aae90f52ee7bf039", "cves": [], "html": "Ensure that tuplestore data structures are internally consistent even after an error (Tom Lane) §
\nThe code was previously careless about this, which is fine most of the time but is problematic for the tuplestore backing a WITH HOLD cursor. In v15 and before this leads to easily-reproducible crashes; later branches are not known to be vulnerable, but it seems best to preserve consistency in all.
Fix premature NULL lag reporting in pg_stat_replication (Shinya Kato) §
The lag columns frequently read as NULL even while replication activity was happening.
", "text": "Fix premature NULL lag reporting in pg_stat_replication (Shinya Kato) § The lag columns frequently read as NULL even while replication activity was happening.", "title": "Fix premature NULL lag reporting in pg_stat_replication", "commits": ["f42105001"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "4f82cfebd7c299d586af3252a4fd428e7b6836ecc3dc6cc46f1dfa26083bde96", "section_path": ["Changes"], "commit_groups": [["246c296f0", "98e96e579", "bf7ecf353", "eef1ba704", "f42105001", "fdce5de55"]], "identity_text": "Fix premature NULL lag reporting in pg_stat_replication (Shinya Kato) The lag columns frequently read as NULL even while replication activity was happening.", "commit_aliases": ["246c296f0", "98e96e579", "bf7ecf353", "eef1ba704", "f42105001", "fdce5de55"], "source_commits": ["f42105001"], "source_entry_id": "16.14/changes/033", "db_id": "65eb4d53da31a74e1d2b5ae72a4b3f98", "patch_ids": ["7704c6b94c92f272f76de1954c53eb5b"], "statement_hash": "bcd10a6c1d43f2b961925210744b26778b15baa46851120a0a4df4d6146ed920", "relations": [{"rule": 2, "type": "equivalent", "target": "5851dbb38f0eb77c8633d934a8c81fbc", "evidence": {"same_day": true, "patch_ids": ["7704c6b94c92f272f76de1954c53eb5b"], "statement_hash": "bcd10a6c1d43f2b961925210744b26778b15baa46851120a0a4df4d6146ed920"}}, {"rule": 2, "type": "equivalent", "target": "8f5d9efb9934b105d69fddf797f34e0b", "evidence": {"same_day": true, "patch_ids": ["7704c6b94c92f272f76de1954c53eb5b"], "statement_hash": "bcd10a6c1d43f2b961925210744b26778b15baa46851120a0a4df4d6146ed920"}}, {"rule": 2, "type": "equivalent", "target": "915ec8a085b4d90eb64720a431768f9b", "evidence": {"same_day": true, "patch_ids": ["7704c6b94c92f272f76de1954c53eb5b"], "statement_hash": "bcd10a6c1d43f2b961925210744b26778b15baa46851120a0a4df4d6146ed920"}}, {"rule": 2, "type": "equivalent", "target": "bf6218705be170d40b881423fbe0391f", "evidence": {"same_day": true, "patch_ids": ["7704c6b94c92f272f76de1954c53eb5b"], "statement_hash": "bcd10a6c1d43f2b961925210744b26778b15baa46851120a0a4df4d6146ed920"}}], "version": "16.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "bf6218705be170d40b881423fbe0391f", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Fix premature NULL lag reporting in pg_stat_replication", "evidence": {"same_day": true, "patch_ids": ["7704c6b94c92f272f76de1954c53eb5b"], "statement_hash": "bcd10a6c1d43f2b961925210744b26778b15baa46851120a0a4df4d6146ed920"}, "url": "/docs/compare/?release=18.4#18.4-8789ffc8666b33f9", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "5851dbb38f0eb77c8633d934a8c81fbc", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Fix premature NULL lag reporting in pg_stat_replication", "evidence": {"same_day": true, "patch_ids": ["7704c6b94c92f272f76de1954c53eb5b"], "statement_hash": "bcd10a6c1d43f2b961925210744b26778b15baa46851120a0a4df4d6146ed920"}, "url": "/docs/compare/?release=17.10#17.10-aef7dca4bced6a82", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "915ec8a085b4d90eb64720a431768f9b", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Fix premature NULL lag reporting in pg_stat_replication", "evidence": {"same_day": true, "patch_ids": ["7704c6b94c92f272f76de1954c53eb5b"], "statement_hash": "bcd10a6c1d43f2b961925210744b26778b15baa46851120a0a4df4d6146ed920"}, "url": "/docs/compare/?release=15.18#15.18-fea30dc889e7ae5f", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "8f5d9efb9934b105d69fddf797f34e0b", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Fix premature NULL lag reporting in pg_stat_replication", "evidence": {"same_day": true, "patch_ids": ["7704c6b94c92f272f76de1954c53eb5b"], "statement_hash": "bcd10a6c1d43f2b961925210744b26778b15baa46851120a0a4df4d6146ed920"}, "url": "/docs/compare/?release=14.23#14.23-bcb3e939d63d9120", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-0b6ea33dc78e8d08", "cves": [], "html": "Avoid rare flush failure when working with non-WAL-logged GiST indexes (Tomas Vondra) §
\nA non-logged GiST index could nonetheless sometimes produce “xlog flush request n/nnnn is not satisfied” errors, due to incorrect selection of a “fake LSN” to represent an insertion point.
Fix underestimate of required size of DSA page maps for odd-size segments (Paul Bunn) §
\nThis miscalculation led to out-of-bounds accesses and hence server crashes.
", "text": "Fix underestimate of required size of DSA page maps for odd-size segments (Paul Bunn) § This miscalculation led to out-of-bounds accesses and hence server crashes.", "title": "Fix underestimate of required size of DSA page maps for odd-size segments", "commits": ["0af5e64e9"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "d3810818eefb1950a048351ad01fe3f1cd0e1e966bc6f3be6fcd0d16cf4ad25c", "section_path": ["Changes"], "commit_groups": [["0af5e64e9", "2543b9ea9", "46c93b705", "4da2afd01", "a0f38604d", "eb11d7a91"]], "identity_text": "Fix underestimate of required size of DSA page maps for odd-size segments (Paul Bunn) This miscalculation led to out-of-bounds accesses and hence server crashes.", "commit_aliases": ["0af5e64e9", "2543b9ea9", "46c93b705", "4da2afd01", "a0f38604d", "eb11d7a91"], "source_commits": ["0af5e64e9"], "source_entry_id": "16.14/changes/035", "db_id": "6c9b24cf6c2959b6e084b0f1468cc147", "patch_ids": ["51396541ad50c671641591d5c032f25c"], "statement_hash": "b77594e65c1a09137763e6965f04edfa079771b8c115cc6bbea72232ff10e97e", "relations": [{"rule": 2, "type": "equivalent", "target": "132eccad33a03f9808709ff243633e21", "evidence": {"same_day": true, "patch_ids": ["51396541ad50c671641591d5c032f25c"], "statement_hash": "b77594e65c1a09137763e6965f04edfa079771b8c115cc6bbea72232ff10e97e"}}, {"rule": 2, "type": "equivalent", "target": "c0162fa5c8bd731ee869a6a910d5a618", "evidence": {"same_day": true, "patch_ids": ["51396541ad50c671641591d5c032f25c"], "statement_hash": "b77594e65c1a09137763e6965f04edfa079771b8c115cc6bbea72232ff10e97e"}}, {"rule": 2, "type": "equivalent", "target": "d358ff7daadf000c76becae39274dcc8", "evidence": {"same_day": true, "patch_ids": ["51396541ad50c671641591d5c032f25c"], "statement_hash": "b77594e65c1a09137763e6965f04edfa079771b8c115cc6bbea72232ff10e97e"}}, {"rule": 2, "type": "equivalent", "target": "feb50a4056ee0c9561081c3bd1a5fd94", "evidence": {"same_day": true, "patch_ids": ["51396541ad50c671641591d5c032f25c"], "statement_hash": "b77594e65c1a09137763e6965f04edfa079771b8c115cc6bbea72232ff10e97e"}}], "version": "16.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c0162fa5c8bd731ee869a6a910d5a618", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Fix underestimate of required size of DSA page maps for odd-size segments", "evidence": {"same_day": true, "patch_ids": ["51396541ad50c671641591d5c032f25c"], "statement_hash": "b77594e65c1a09137763e6965f04edfa079771b8c115cc6bbea72232ff10e97e"}, "url": "/docs/compare/?release=18.4#18.4-6a31304d211cadfa", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "feb50a4056ee0c9561081c3bd1a5fd94", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Fix underestimate of required size of DSA page maps for odd-size segments", "evidence": {"same_day": true, "patch_ids": ["51396541ad50c671641591d5c032f25c"], "statement_hash": "b77594e65c1a09137763e6965f04edfa079771b8c115cc6bbea72232ff10e97e"}, "url": "/docs/compare/?release=17.10#17.10-530a8cbdc6f714b9", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "132eccad33a03f9808709ff243633e21", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Fix underestimate of required size of DSA page maps for odd-size segments", "evidence": {"same_day": true, "patch_ids": ["51396541ad50c671641591d5c032f25c"], "statement_hash": "b77594e65c1a09137763e6965f04edfa079771b8c115cc6bbea72232ff10e97e"}, "url": "/docs/compare/?release=15.18#15.18-1a4308d681901087", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "d358ff7daadf000c76becae39274dcc8", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Fix underestimate of required size of DSA page maps for odd-size segments", "evidence": {"same_day": true, "patch_ids": ["51396541ad50c671641591d5c032f25c"], "statement_hash": "b77594e65c1a09137763e6965f04edfa079771b8c115cc6bbea72232ff10e97e"}, "url": "/docs/compare/?release=14.23#14.23-11bc13dcca69d74b", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-0be3354f36793154", "cves": [], "html": "Fix possible server crash when processing extended statistics on expressions of extension data types (Michael Paquier) §
\nNULL pointer dereferences were possible if the data type's typanalyze function does not compute any useful statistics. No in-core typanalyze function behaves that way, but extensions could.
", "text": "Fix possible server crash when processing extended statistics on expressions of extension data types (Michael Paquier) § NULL pointer dereferences were possible if the data type's typanalyze function does not compute any useful statistics. No in-core typanalyze function behaves that way, but extensions could.", "title": "Fix possible server crash when processing extended statistics on expressions of extension data types", "commits": ["04745ba9c"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "5aa9ae8e8ff4d8506c2393cb7e275f54734a687b501a2da8e0f3c75b53d2a6db", "section_path": ["Changes"], "commit_groups": [["038c7d4a3", "04745ba9c", "3b7a6fa15", "530b6b02f", "83671c0da", "f033abc6c"]], "identity_text": "Fix possible server crash when processing extended statistics on expressions of extension data types (Michael Paquier) NULL pointer dereferences were possible if the data type's typanalyze function does not compute any useful statistics. No in-core typanalyze function behaves that way, but extensions could.", "commit_aliases": ["038c7d4a3", "04745ba9c", "3b7a6fa15", "530b6b02f", "83671c0da", "f033abc6c"], "source_commits": ["04745ba9c"], "source_entry_id": "16.14/changes/036", "db_id": "1c1afd4ac22d6baac4a29928c824292c", "patch_ids": ["57808080730ecfb17eedfbeb01bceb92"], "statement_hash": "0b6cefc1fdc0c8f91af788bfe5a8b6d0b6b4059af142c8779ab898a1590a8d8a", "relations": [{"rule": 2, "type": "equivalent", "target": "11bb9497f3c67aace227015bc936b98e", "evidence": {"same_day": true, "patch_ids": ["57808080730ecfb17eedfbeb01bceb92"], "statement_hash": "0b6cefc1fdc0c8f91af788bfe5a8b6d0b6b4059af142c8779ab898a1590a8d8a"}}, {"rule": 2, "type": "equivalent", "target": "7060172e893faabd38e47a052f25c75c", "evidence": {"same_day": true, "patch_ids": ["57808080730ecfb17eedfbeb01bceb92"], "statement_hash": "0b6cefc1fdc0c8f91af788bfe5a8b6d0b6b4059af142c8779ab898a1590a8d8a"}}, {"rule": 2, "type": "equivalent", "target": "80939c27c6a18cbd33af67b54738ffbb", "evidence": {"same_day": true, "patch_ids": ["57808080730ecfb17eedfbeb01bceb92"], "statement_hash": "0b6cefc1fdc0c8f91af788bfe5a8b6d0b6b4059af142c8779ab898a1590a8d8a"}}, {"rule": 2, "type": "equivalent", "target": "e3fcd13894196d38b7fdafd82a39872b", "evidence": {"same_day": true, "patch_ids": ["57808080730ecfb17eedfbeb01bceb92"], "statement_hash": "0b6cefc1fdc0c8f91af788bfe5a8b6d0b6b4059af142c8779ab898a1590a8d8a"}}], "version": "16.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "e3fcd13894196d38b7fdafd82a39872b", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Fix possible server crash when processing extended statistics on expressions of extension data types", "evidence": {"same_day": true, "patch_ids": ["57808080730ecfb17eedfbeb01bceb92"], "statement_hash": "0b6cefc1fdc0c8f91af788bfe5a8b6d0b6b4059af142c8779ab898a1590a8d8a"}, "url": "/docs/compare/?release=18.4#18.4-d17ff570c253e2a4", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "80939c27c6a18cbd33af67b54738ffbb", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Fix possible server crash when processing extended statistics on expressions of extension data types", "evidence": {"same_day": true, "patch_ids": ["57808080730ecfb17eedfbeb01bceb92"], "statement_hash": "0b6cefc1fdc0c8f91af788bfe5a8b6d0b6b4059af142c8779ab898a1590a8d8a"}, "url": "/docs/compare/?release=17.10#17.10-55b28f30732d7db3", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "7060172e893faabd38e47a052f25c75c", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Fix possible server crash when processing extended statistics on expressions of extension data types", "evidence": {"same_day": true, "patch_ids": ["57808080730ecfb17eedfbeb01bceb92"], "statement_hash": "0b6cefc1fdc0c8f91af788bfe5a8b6d0b6b4059af142c8779ab898a1590a8d8a"}, "url": "/docs/compare/?release=15.18#15.18-66aee329c6813e82", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "11bb9497f3c67aace227015bc936b98e", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Fix possible server crash when processing extended statistics on expressions of extension data types", "evidence": {"same_day": true, "patch_ids": ["57808080730ecfb17eedfbeb01bceb92"], "statement_hash": "0b6cefc1fdc0c8f91af788bfe5a8b6d0b6b4059af142c8779ab898a1590a8d8a"}, "url": "/docs/compare/?release=14.23#14.23-4ba256fc57391391", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-9c6d58940b19e710", "cves": [], "html": "Fix minor memory leaks in ICU-based string processing (Jeff Davis) §
", "text": "Fix minor memory leaks in ICU-based string processing (Jeff Davis) §", "title": "Fix minor memory leaks in ICU-based string processing", "commits": ["a4515c9b4"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "aee828dc046136fde1ce382cd287da3f098ff22d43af5acfc802a5886001c84e", "section_path": ["Changes"], "commit_groups": [["4761f2eee", "4abf63c62", "a4515c9b4", "d942511f0"]], "identity_text": "Fix minor memory leaks in ICU-based string processing (Jeff Davis)", "commit_aliases": ["4761f2eee", "4abf63c62", "a4515c9b4", "d942511f0"], "source_commits": ["a4515c9b4"], "source_entry_id": "16.14/changes/037", "db_id": "50b72add33aaee1a9925c87cbf7716b3", "patch_ids": ["6d9d38d08dbad42448b9071321caaf61"], "statement_hash": "b7a1562c011305e92a0b8937cd9fca1c2e7a7555c23e50eef91b5ced9490aa97", "relations": [{"rule": 2, "type": "equivalent", "target": "837bd67b8c3f6368b3c27a6551f80927", "evidence": {"same_day": true, "patch_ids": ["6d9d38d08dbad42448b9071321caaf61"], "statement_hash": "b7a1562c011305e92a0b8937cd9fca1c2e7a7555c23e50eef91b5ced9490aa97"}}, {"rule": 2, "type": "equivalent", "target": "bd584e4f7982ffc4b076ab2f17b9df9c", "evidence": {"same_day": true, "patch_ids": ["6d9d38d08dbad42448b9071321caaf61"], "statement_hash": "b7a1562c011305e92a0b8937cd9fca1c2e7a7555c23e50eef91b5ced9490aa97"}}], "version": "16.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "837bd67b8c3f6368b3c27a6551f80927", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Fix minor memory leaks in ICU-based string processing", "evidence": {"same_day": true, "patch_ids": ["6d9d38d08dbad42448b9071321caaf61"], "statement_hash": "b7a1562c011305e92a0b8937cd9fca1c2e7a7555c23e50eef91b5ced9490aa97"}, "url": "/docs/compare/?release=18.4#18.4-d03de691fc9de456", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "bd584e4f7982ffc4b076ab2f17b9df9c", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Fix minor memory leaks in ICU-based string processing", "evidence": {"same_day": true, "patch_ids": ["6d9d38d08dbad42448b9071321caaf61"], "statement_hash": "b7a1562c011305e92a0b8937cd9fca1c2e7a7555c23e50eef91b5ced9490aa97"}, "url": "/docs/compare/?release=17.10#17.10-e802516615666acf", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}]}, {"id": "16.14-0b7f6a3235e38857", "cves": [], "html": "If the startup process fails, properly shut down other child processes before exiting the postmaster (Ayush Tiwari) §
\nThe handling of this situation relied on a long-obsolete assumption that no other postmaster children exist while the startup process is running, so that immediate postmaster exit is acceptable. Orphaned children would eventually notice the postmaster's death and exit on their own, but a cleaner shutdown procedure is desirable.
", "text": "If the startup process fails, properly shut down other child processes before exiting the postmaster (Ayush Tiwari) § The handling of this situation relied on a long-obsolete assumption that no other postmaster children exist while the startup process is running, so that immediate postmaster exit is acceptable. Orphaned children would eventually notice the postmaster's death and exit on their own, but a cleaner shutdown procedure is desirable.", "title": "If the startup process fails, properly shut down other child processes before exiting the postmaster", "commits": ["2d347f2cd"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "db66636fe6af3a83d9c9acff3ccde1ffd1f60176149822d11c24f21e73b83a86", "section_path": ["Changes"], "commit_groups": [["23cebf672", "2d347f2cd", "9b43e6793", "affdb2dd5", "e381843cf"]], "identity_text": "If the startup process fails, properly shut down other child processes before exiting the postmaster (Ayush Tiwari) The handling of this situation relied on a long-obsolete assumption that no other postmaster children exist while the startup process is running, so that immediate postmaster exit is acceptable. Orphaned children would eventually notice the postmaster's death and exit on their own, but a cleaner shutdown procedure is desirable.", "commit_aliases": ["23cebf672", "2d347f2cd", "9b43e6793", "affdb2dd5", "e381843cf"], "source_commits": ["2d347f2cd"], "source_entry_id": "16.14/changes/038", "db_id": "35889e010982e213ace67b19129690cc", "patch_ids": ["336655f61a8e613f6d655ff5a808f10d"], "statement_hash": "cb4e5d59e127aafd8bb2c9e2c73437dd551d9591dd8c7309ec60a48a3299d4f5", "relations": [{"rule": 2, "type": "equivalent", "target": "1258e1d70ad8d20566f8bef565afb542", "evidence": {"same_day": true, "patch_ids": ["336655f61a8e613f6d655ff5a808f10d"], "statement_hash": "cb4e5d59e127aafd8bb2c9e2c73437dd551d9591dd8c7309ec60a48a3299d4f5"}}, {"rule": 2, "type": "equivalent", "target": "2a31a83d114004ec62a45d4511e6eea8", "evidence": {"same_day": true, "patch_ids": ["336655f61a8e613f6d655ff5a808f10d"], "statement_hash": "cb4e5d59e127aafd8bb2c9e2c73437dd551d9591dd8c7309ec60a48a3299d4f5"}}, {"rule": 2, "type": "equivalent", "target": "60187dd7a7a6b60a0c3449316b65aa78", "evidence": {"same_day": true, "patch_ids": ["336655f61a8e613f6d655ff5a808f10d"], "statement_hash": "cb4e5d59e127aafd8bb2c9e2c73437dd551d9591dd8c7309ec60a48a3299d4f5"}}], "version": "16.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "60187dd7a7a6b60a0c3449316b65aa78", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "If the startup process fails, properly shut down other child processes before exiting the postmaster", "evidence": {"same_day": true, "patch_ids": ["336655f61a8e613f6d655ff5a808f10d"], "statement_hash": "cb4e5d59e127aafd8bb2c9e2c73437dd551d9591dd8c7309ec60a48a3299d4f5"}, "url": "/docs/compare/?release=18.4#18.4-fbb8a60e8a0fb7fa", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "1258e1d70ad8d20566f8bef565afb542", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "If the startup process fails, properly shut down other child processes before exiting the postmaster", "evidence": {"same_day": true, "patch_ids": ["336655f61a8e613f6d655ff5a808f10d"], "statement_hash": "cb4e5d59e127aafd8bb2c9e2c73437dd551d9591dd8c7309ec60a48a3299d4f5"}, "url": "/docs/compare/?release=17.10#17.10-ae6a8b961252ec16", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "2a31a83d114004ec62a45d4511e6eea8", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "If the startup process fails, properly shut down other child processes before exiting the postmaster", "evidence": {"same_day": true, "patch_ids": ["336655f61a8e613f6d655ff5a808f10d"], "statement_hash": "cb4e5d59e127aafd8bb2c9e2c73437dd551d9591dd8c7309ec60a48a3299d4f5"}, "url": "/docs/compare/?release=15.18#15.18-59e230aa6a0adc1d", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}]}, {"id": "16.14-b3cb622e85e826dc", "cves": [], "html": "Fix race condition between WAL replay of checkpoints and multixact ID creations (Heikki Linnakangas) §
\nA standby server following WAL from a primary of an older minor version could get into a crash-and-restart loop complaining about “could not access status of transaction”.
", "text": "Fix race condition between WAL replay of checkpoints and multixact ID creations (Heikki Linnakangas) § A standby server following WAL from a primary of an older minor version could get into a crash-and-restart loop complaining about “could not access status of transaction”.", "title": "Fix race condition between WAL replay of checkpoints and multixact ID creations", "commits": ["77dff5d93"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "0589e821ed02043cd186fd72fda61597721f08cd7a42360cc43fc5549d0d7980", "section_path": ["Changes"], "commit_groups": [["0852643e1", "1ca385032", "77dff5d93", "a5f412107", "e35e466f6"]], "identity_text": "Fix race condition between WAL replay of checkpoints and multixact ID creations (Heikki Linnakangas) A standby server following WAL from a primary of an older minor version could get into a crash-and-restart loop complaining about could not access status of transaction.", "commit_aliases": ["0852643e1", "1ca385032", "77dff5d93", "a5f412107", "e35e466f6"], "source_commits": ["77dff5d93"], "source_entry_id": "16.14/changes/039", "db_id": "bdf695af62de33084d77c352623dcee3", "patch_ids": ["bc2293c8457ac75a2ee41b1da5cae860"], "statement_hash": "966d18f3bd64c03cfe6fcbf5ad572276df81e74e4f0e0228686357c47c7ba192", "relations": [{"rule": 2, "type": "equivalent", "target": "2dd877a931aebbb79cf02748fddc6985", "evidence": {"same_day": true, "patch_ids": ["bc2293c8457ac75a2ee41b1da5cae860"], "statement_hash": "966d18f3bd64c03cfe6fcbf5ad572276df81e74e4f0e0228686357c47c7ba192"}}, {"rule": 2, "type": "equivalent", "target": "61f30ae9ddadfa030207bdea7cb12e70", "evidence": {"same_day": true, "patch_ids": ["bc2293c8457ac75a2ee41b1da5cae860"], "statement_hash": "966d18f3bd64c03cfe6fcbf5ad572276df81e74e4f0e0228686357c47c7ba192"}}, {"rule": 2, "type": "equivalent", "target": "7656c6c266fb5f623679c473e6534cb4", "evidence": {"same_day": true, "patch_ids": ["bc2293c8457ac75a2ee41b1da5cae860"], "statement_hash": "966d18f3bd64c03cfe6fcbf5ad572276df81e74e4f0e0228686357c47c7ba192"}}, {"rule": 2, "type": "equivalent", "target": "85b276d385b6533daa45fb10a83fcdc6", "evidence": {"same_day": true, "patch_ids": ["bc2293c8457ac75a2ee41b1da5cae860"], "statement_hash": "966d18f3bd64c03cfe6fcbf5ad572276df81e74e4f0e0228686357c47c7ba192"}}], "version": "16.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2dd877a931aebbb79cf02748fddc6985", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Fix race condition between WAL replay of checkpoints and multixact ID creations", "evidence": {"same_day": true, "patch_ids": ["bc2293c8457ac75a2ee41b1da5cae860"], "statement_hash": "966d18f3bd64c03cfe6fcbf5ad572276df81e74e4f0e0228686357c47c7ba192"}, "url": "/docs/compare/?release=18.4#18.4-b95009e302c19df6", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "7656c6c266fb5f623679c473e6534cb4", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Fix race condition between WAL replay of checkpoints and multixact ID creations", "evidence": {"same_day": true, "patch_ids": ["bc2293c8457ac75a2ee41b1da5cae860"], "statement_hash": "966d18f3bd64c03cfe6fcbf5ad572276df81e74e4f0e0228686357c47c7ba192"}, "url": "/docs/compare/?release=17.10#17.10-b851403e0c059925", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "85b276d385b6533daa45fb10a83fcdc6", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Fix race condition between WAL replay of checkpoints and multixact ID creations", "evidence": {"same_day": true, "patch_ids": ["bc2293c8457ac75a2ee41b1da5cae860"], "statement_hash": "966d18f3bd64c03cfe6fcbf5ad572276df81e74e4f0e0228686357c47c7ba192"}, "url": "/docs/compare/?release=15.18#15.18-729165d8f77b8c3e", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "61f30ae9ddadfa030207bdea7cb12e70", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Fix race condition between WAL replay of checkpoints and multixact ID creations", "evidence": {"same_day": true, "patch_ids": ["bc2293c8457ac75a2ee41b1da5cae860"], "statement_hash": "966d18f3bd64c03cfe6fcbf5ad572276df81e74e4f0e0228686357c47c7ba192"}, "url": "/docs/compare/?release=14.23#14.23-c6d1cb4b3f13c969", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-817a820bc49c0dcf", "cves": [], "html": "Prevent indefinite wait in shutdown of a walsender process (Anthonin Bonnefoy) § §
\nAt shutdown of a cluster that is publishing logical replication data, the walsender waits for all pending WAL to be written out. But it did not correctly request that to happen, so that in some cases this could become an indefinite wait.
", "text": "Prevent indefinite wait in shutdown of a walsender process (Anthonin Bonnefoy) § § At shutdown of a cluster that is publishing logical replication data, the walsender waits for all pending WAL to be written out. But it did not correctly request that to happen, so that in some cases this could become an indefinite wait.", "title": "Prevent indefinite wait in shutdown of a walsender process", "commits": ["82935467a", "da21ecf57"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "a628025a3d9bb11306cbb386b6b79ecd6547d0cbfd6814d1d3a7e6e14401ad4a", "section_path": ["Changes"], "commit_groups": [["3bf6f22ce", "3eb2fecdb", "42734f296", "6eedb2a5f", "82935467a", "bbbc0888b"], ["8ee536c89", "980498138", "d927b4bd9", "da21ecf57", "f15471464", "fa9f2e317"]], "identity_text": "Prevent indefinite wait in shutdown of a walsender process (Anthonin Bonnefoy) At shutdown of a cluster that is publishing logical replication data, the walsender waits for all pending WAL to be written out. But it did not correctly request that to happen, so that in some cases this could become an indefinite wait.", "commit_aliases": ["3bf6f22ce", "3eb2fecdb", "42734f296", "6eedb2a5f", "82935467a", "8ee536c89", "980498138", "bbbc0888b", "d927b4bd9", "da21ecf57", "f15471464", "fa9f2e317"], "source_commits": ["82935467a", "da21ecf57"], "source_entry_id": "16.14/changes/040", "db_id": "58a67f2d4d7fff6342315f22db6849a6", "patch_ids": ["472a5975808282fa6bd581c79c39f9ea", "76b367fc789f138e1eeabf0d364392af"], "statement_hash": "82e19a553da5241f427aaa49312a19ba9fb5200bffa8a85355d78e7c64e1a530", "relations": [{"rule": 2, "type": "equivalent", "target": "45420fcd1c11fe55a25c2e6f51f48363", "evidence": {"same_day": true, "patch_ids": ["472a5975808282fa6bd581c79c39f9ea", "76b367fc789f138e1eeabf0d364392af"], "statement_hash": "82e19a553da5241f427aaa49312a19ba9fb5200bffa8a85355d78e7c64e1a530"}}, {"rule": 2, "type": "equivalent", "target": "a7b932fcfa614135f399c6d16936a3ee", "evidence": {"same_day": true, "patch_ids": ["472a5975808282fa6bd581c79c39f9ea", "76b367fc789f138e1eeabf0d364392af"], "statement_hash": "82e19a553da5241f427aaa49312a19ba9fb5200bffa8a85355d78e7c64e1a530"}}, {"rule": 2, "type": "equivalent", "target": "dd2e9c6da8c31f99c801d2fd16385b3c", "evidence": {"same_day": true, "patch_ids": ["472a5975808282fa6bd581c79c39f9ea", "76b367fc789f138e1eeabf0d364392af"], "statement_hash": "82e19a553da5241f427aaa49312a19ba9fb5200bffa8a85355d78e7c64e1a530"}}, {"rule": 2, "type": "equivalent", "target": "f5dd9be5d5ba1e08ae8e1a43cf926484", "evidence": {"same_day": true, "patch_ids": ["472a5975808282fa6bd581c79c39f9ea", "76b367fc789f138e1eeabf0d364392af"], "statement_hash": "82e19a553da5241f427aaa49312a19ba9fb5200bffa8a85355d78e7c64e1a530"}}], "version": "16.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "dd2e9c6da8c31f99c801d2fd16385b3c", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Prevent indefinite wait in shutdown of a walsender process", "evidence": {"same_day": true, "patch_ids": ["472a5975808282fa6bd581c79c39f9ea", "76b367fc789f138e1eeabf0d364392af"], "statement_hash": "82e19a553da5241f427aaa49312a19ba9fb5200bffa8a85355d78e7c64e1a530"}, "url": "/docs/compare/?release=18.4#18.4-a9cb192589c0f7aa", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "a7b932fcfa614135f399c6d16936a3ee", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Prevent indefinite wait in shutdown of a walsender process", "evidence": {"same_day": true, "patch_ids": ["472a5975808282fa6bd581c79c39f9ea", "76b367fc789f138e1eeabf0d364392af"], "statement_hash": "82e19a553da5241f427aaa49312a19ba9fb5200bffa8a85355d78e7c64e1a530"}, "url": "/docs/compare/?release=17.10#17.10-3ccf02812257acd0", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "45420fcd1c11fe55a25c2e6f51f48363", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Prevent indefinite wait in shutdown of a walsender process", "evidence": {"same_day": true, "patch_ids": ["472a5975808282fa6bd581c79c39f9ea", "76b367fc789f138e1eeabf0d364392af"], "statement_hash": "82e19a553da5241f427aaa49312a19ba9fb5200bffa8a85355d78e7c64e1a530"}, "url": "/docs/compare/?release=15.18#15.18-1a0fb49c7d011cf8", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "f5dd9be5d5ba1e08ae8e1a43cf926484", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Prevent indefinite wait in shutdown of a walsender process", "evidence": {"same_day": true, "patch_ids": ["472a5975808282fa6bd581c79c39f9ea", "76b367fc789f138e1eeabf0d364392af"], "statement_hash": "82e19a553da5241f427aaa49312a19ba9fb5200bffa8a85355d78e7c64e1a530"}, "url": "/docs/compare/?release=14.23#14.23-b352d254dd3297f4", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-8125cf51d6ed071a", "cves": [], "html": "Ensure that changes to tables' free space maps are persisted during recovery (Alexey Makhmutov) §
\nPreviously, while WAL replay did update the free space map while replaying operations that should change it, the map page buffer did not get marked dirty if checksums are enabled, so that the changes might never get written out. On a standby server, over time this would result in a map wildly at variance with the table's actual contents. While the map is only used as a hint, this condition could cause significant performance degradation for some period of time after the standby server is promoted to be active, until most of the map has been repaired by updates.
", "text": "Ensure that changes to tables' free space maps are persisted during recovery (Alexey Makhmutov) § Previously, while WAL replay did update the free space map while replaying operations that should change it, the map page buffer did not get marked dirty if checksums are enabled, so that the changes might never get written out. On a standby server, over time this would result in a map wildly at variance with the table's actual contents. While the map is only used as a hint, this condition could cause significant performance degradation for some period of time after the standby server is promoted to be active, until most of the map has been repaired by updates.", "title": "Ensure that changes to tables' free space maps are persisted during recovery", "commits": ["54537de35"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "31e369179c4c8f4a6dc65453e254c79c6be6e8849a62756891e8bb2f9bdc87dd", "section_path": ["Changes"], "commit_groups": [["1cf010f21", "54537de35", "ac3b97db3", "c06d1a4ba", "ca259b084", "f5d1038d9"]], "identity_text": "Ensure that changes to tables' free space maps are persisted during recovery (Alexey Makhmutov) Previously, while WAL replay did update the free space map while replaying operations that should change it, the map page buffer did not get marked dirty if checksums are enabled, so that the changes might never get written out. On a standby server, over time this would result in a map wildly at variance with the table's actual contents. While the map is only used as a hint, this condition could cause significant performance degradation for some period of time after the standby server is promoted to be active, until most of the map has been repaired by updates.", "commit_aliases": ["1cf010f21", "54537de35", "ac3b97db3", "c06d1a4ba", "ca259b084", "f5d1038d9"], "source_commits": ["54537de35"], "source_entry_id": "16.14/changes/041", "db_id": "ef79709e772e43cd7f13cd40fd54ce08", "patch_ids": ["290b85a9a01972ea333ff078f1b803bd"], "statement_hash": "94dbd19b3ba5c2d1d6d0c3e547d4c2b99593a3f783f7d830b8bd54b62553c5ba", "relations": [{"rule": 2, "type": "equivalent", "target": "0a850a82a0e101c371b76446a16834eb", "evidence": {"same_day": true, "patch_ids": ["290b85a9a01972ea333ff078f1b803bd"], "statement_hash": "94dbd19b3ba5c2d1d6d0c3e547d4c2b99593a3f783f7d830b8bd54b62553c5ba"}}, {"rule": 2, "type": "equivalent", "target": "0ab544ccf54b9ef9d9a67d11e0edd7e6", "evidence": {"same_day": true, "patch_ids": ["290b85a9a01972ea333ff078f1b803bd"], "statement_hash": "94dbd19b3ba5c2d1d6d0c3e547d4c2b99593a3f783f7d830b8bd54b62553c5ba"}}, {"rule": 2, "type": "equivalent", "target": "5d55832b6f7b480606ba52039c22d06e", "evidence": {"same_day": true, "patch_ids": ["290b85a9a01972ea333ff078f1b803bd"], "statement_hash": "94dbd19b3ba5c2d1d6d0c3e547d4c2b99593a3f783f7d830b8bd54b62553c5ba"}}, {"rule": 2, "type": "equivalent", "target": "d0b2b7eb40b300341a738f0c8f9b9486", "evidence": {"same_day": true, "patch_ids": ["290b85a9a01972ea333ff078f1b803bd"], "statement_hash": "94dbd19b3ba5c2d1d6d0c3e547d4c2b99593a3f783f7d830b8bd54b62553c5ba"}}], "version": "16.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "0ab544ccf54b9ef9d9a67d11e0edd7e6", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Ensure that changes to tables' free space maps are persisted during recovery", "evidence": {"same_day": true, "patch_ids": ["290b85a9a01972ea333ff078f1b803bd"], "statement_hash": "94dbd19b3ba5c2d1d6d0c3e547d4c2b99593a3f783f7d830b8bd54b62553c5ba"}, "url": "/docs/compare/?release=18.4#18.4-97e2910c41fa9a19", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "d0b2b7eb40b300341a738f0c8f9b9486", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Ensure that changes to tables' free space maps are persisted during recovery", "evidence": {"same_day": true, "patch_ids": ["290b85a9a01972ea333ff078f1b803bd"], "statement_hash": "94dbd19b3ba5c2d1d6d0c3e547d4c2b99593a3f783f7d830b8bd54b62553c5ba"}, "url": "/docs/compare/?release=17.10#17.10-fe407982706e6121", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "0a850a82a0e101c371b76446a16834eb", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Ensure that changes to tables' free space maps are persisted during recovery", "evidence": {"same_day": true, "patch_ids": ["290b85a9a01972ea333ff078f1b803bd"], "statement_hash": "94dbd19b3ba5c2d1d6d0c3e547d4c2b99593a3f783f7d830b8bd54b62553c5ba"}, "url": "/docs/compare/?release=15.18#15.18-c1ccf41821cc2c15", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "5d55832b6f7b480606ba52039c22d06e", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Ensure that changes to tables' free space maps are persisted during recovery", "evidence": {"same_day": true, "patch_ids": ["290b85a9a01972ea333ff078f1b803bd"], "statement_hash": "94dbd19b3ba5c2d1d6d0c3e547d4c2b99593a3f783f7d830b8bd54b62553c5ba"}, "url": "/docs/compare/?release=14.23#14.23-01e5d1d4b9c66a74", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-44793a559af5c464", "cves": [], "html": "Fix crashes in some ecpg functions when called without any established connection (Shruthi Gowda) §
", "text": "Fix crashes in some ecpg functions when called without any established connection (Shruthi Gowda) §", "title": "Fix crashes in some ecpg functions when called without any established connection", "commits": ["7e4c871f4"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "a409f600e60af17a96d6da1092e0cd4ee9804753a483913e5827681672e43ef3", "section_path": ["Changes"], "commit_groups": [["5d67549d9", "6916f4410", "7e4c871f4", "c34a280c8", "e2688ea5e", "f0e3f9732"]], "identity_text": "Fix crashes in some ecpg functions when called without any established connection (Shruthi Gowda)", "commit_aliases": ["5d67549d9", "6916f4410", "7e4c871f4", "c34a280c8", "e2688ea5e", "f0e3f9732"], "source_commits": ["7e4c871f4"], "source_entry_id": "16.14/changes/042", "db_id": "7907242716f81b2600bf11b638097726", "patch_ids": ["c7a6bafc62f4feae4e980b1e35da2b80"], "statement_hash": "d082bcf56e345df427e58be27130fd3aa6a1679e210b9c2dac559e63adb7e00a", "relations": [{"rule": 2, "type": "equivalent", "target": "80c1fd60cd9f0d7c266d99b227c860c1", "evidence": {"same_day": true, "patch_ids": ["c7a6bafc62f4feae4e980b1e35da2b80"], "statement_hash": "d082bcf56e345df427e58be27130fd3aa6a1679e210b9c2dac559e63adb7e00a"}}, {"rule": 2, "type": "equivalent", "target": "bdf9527e3b31fa7d5ae8f9823d072d3d", "evidence": {"same_day": true, "patch_ids": ["c7a6bafc62f4feae4e980b1e35da2b80"], "statement_hash": "d082bcf56e345df427e58be27130fd3aa6a1679e210b9c2dac559e63adb7e00a"}}, {"rule": 2, "type": "equivalent", "target": "c0c7dfbc8d8c6bcae16ae7205d190917", "evidence": {"same_day": true, "patch_ids": ["c7a6bafc62f4feae4e980b1e35da2b80"], "statement_hash": "d082bcf56e345df427e58be27130fd3aa6a1679e210b9c2dac559e63adb7e00a"}}, {"rule": 2, "type": "equivalent", "target": "feefd46320fbb1731e40ec3e06323dbb", "evidence": {"same_day": true, "patch_ids": ["c7a6bafc62f4feae4e980b1e35da2b80"], "statement_hash": "d082bcf56e345df427e58be27130fd3aa6a1679e210b9c2dac559e63adb7e00a"}}], "version": "16.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c0c7dfbc8d8c6bcae16ae7205d190917", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Fix crashes in some ecpg functions when called without any established connection", "evidence": {"same_day": true, "patch_ids": ["c7a6bafc62f4feae4e980b1e35da2b80"], "statement_hash": "d082bcf56e345df427e58be27130fd3aa6a1679e210b9c2dac559e63adb7e00a"}, "url": "/docs/compare/?release=18.4#18.4-7aa817666dd07903", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "bdf9527e3b31fa7d5ae8f9823d072d3d", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Fix crashes in some ecpg functions when called without any established connection", "evidence": {"same_day": true, "patch_ids": ["c7a6bafc62f4feae4e980b1e35da2b80"], "statement_hash": "d082bcf56e345df427e58be27130fd3aa6a1679e210b9c2dac559e63adb7e00a"}, "url": "/docs/compare/?release=17.10#17.10-4e8f75e7518f8860", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "80c1fd60cd9f0d7c266d99b227c860c1", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Fix crashes in some ecpg functions when called without any established connection", "evidence": {"same_day": true, "patch_ids": ["c7a6bafc62f4feae4e980b1e35da2b80"], "statement_hash": "d082bcf56e345df427e58be27130fd3aa6a1679e210b9c2dac559e63adb7e00a"}, "url": "/docs/compare/?release=15.18#15.18-c008865e32c5c2bd", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "feefd46320fbb1731e40ec3e06323dbb", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "Fix crashes in some ecpg functions when called without any established connection", "evidence": {"same_day": true, "patch_ids": ["c7a6bafc62f4feae4e980b1e35da2b80"], "statement_hash": "d082bcf56e345df427e58be27130fd3aa6a1679e210b9c2dac559e63adb7e00a"}, "url": "/docs/compare/?release=14.23#14.23-0d4724d0f0edd35d", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-55b8ddc2c336b3f6", "cves": [], "html": "Fix assorted bugs in backup decompression and tar-parsing code (Andrew Dunstan, Tom Lane, Chao Li) § § §
\nThe decompression and tar-file reading code used in pg_basebackup and pg_verifybackup mishandled tar-file padding data, could corrupt LZ4-compressed data in edge cases, failed to check for some unusual error conditions, failed to exit after compression/decompression errors (leading to cascading error reports), and leaked memory.
", "text": "Fix assorted bugs in backup decompression and tar-parsing code (Andrew Dunstan, Tom Lane, Chao Li) § § § The decompression and tar-file reading code used in pg_basebackup and pg_verifybackup mishandled tar-file padding data, could corrupt LZ4-compressed data in edge cases, failed to check for some unusual error conditions, failed to exit after compression/decompression errors (leading to cascading error reports), and leaked memory.", "title": "Fix assorted bugs in backup decompression and tar-parsing code", "commits": ["1590723f0", "415cc943f", "cce939c71"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "58e0200bbe585825503b98c56dde3f11d3a08e8d6eeba624db633b3c176cbb57", "section_path": ["Changes"], "commit_groups": [["01d58d7e3", "1590723f0", "5095f3f4a", "d3bb7841b", "f1298a4c2"], ["2640c5ba7", "415cc943f", "4548e8746", "78dc9a808", "c70f6dc6b"], ["8b198b093", "9a42888a3", "a01a592b1", "ac0accafd", "cce939c71"]], "identity_text": "Fix assorted bugs in backup decompression and tar-parsing code (Andrew Dunstan, Tom Lane, Chao Li) The decompression and tar-file reading code used in pg_basebackup and pg_verifybackup mishandled tar-file padding data, could corrupt LZ4-compressed data in edge cases, failed to check for some unusual error conditions, failed to exit after compression/decompression errors (leading to cascading error reports), and leaked memory.", "commit_aliases": ["01d58d7e3", "1590723f0", "2640c5ba7", "415cc943f", "4548e8746", "5095f3f4a", "78dc9a808", "8b198b093", "9a42888a3", "a01a592b1", "ac0accafd", "c70f6dc6b", "cce939c71", "d3bb7841b", "f1298a4c2"], "source_commits": ["1590723f0", "415cc943f", "cce939c71"], "source_entry_id": "16.14/changes/043", "db_id": "212902cab1e6fcee0bcc358f8fa492ef", "patch_ids": ["776d5a67dae4e90312023436a1a121e4", "a09bdaf76ce8e50fc1ed232d629496d1", "e611dc8dc55e1b7e28e7918dce0a5440"], "statement_hash": "14975a7d452ebd245adc06195cb53e296e97faf277282e3324587b2fcb641829", "relations": [{"rule": 2, "type": "equivalent", "target": "2c1767e33fbd2c5b0ad76b3984a83f2d", "evidence": {"same_day": true, "patch_ids": ["776d5a67dae4e90312023436a1a121e4", "a09bdaf76ce8e50fc1ed232d629496d1", "e611dc8dc55e1b7e28e7918dce0a5440"], "statement_hash": "14975a7d452ebd245adc06195cb53e296e97faf277282e3324587b2fcb641829"}}, {"rule": 2, "type": "equivalent", "target": "34c5828614b646d0ee1635c733748049", "evidence": {"same_day": true, "patch_ids": ["776d5a67dae4e90312023436a1a121e4", "a09bdaf76ce8e50fc1ed232d629496d1", "e611dc8dc55e1b7e28e7918dce0a5440"], "statement_hash": "14975a7d452ebd245adc06195cb53e296e97faf277282e3324587b2fcb641829"}}, {"rule": 2, "type": "equivalent", "target": "bb9e0889e1a5adbf796ceaf3f2bba54a", "evidence": {"same_day": true, "patch_ids": ["776d5a67dae4e90312023436a1a121e4", "a09bdaf76ce8e50fc1ed232d629496d1", "e611dc8dc55e1b7e28e7918dce0a5440"], "statement_hash": "14975a7d452ebd245adc06195cb53e296e97faf277282e3324587b2fcb641829"}}], "version": "16.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2c1767e33fbd2c5b0ad76b3984a83f2d", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "Fix assorted bugs in backup decompression and tar-parsing code", "evidence": {"same_day": true, "patch_ids": ["776d5a67dae4e90312023436a1a121e4", "a09bdaf76ce8e50fc1ed232d629496d1", "e611dc8dc55e1b7e28e7918dce0a5440"], "statement_hash": "14975a7d452ebd245adc06195cb53e296e97faf277282e3324587b2fcb641829"}, "url": "/docs/compare/?release=18.4#18.4-3efb2ed246686260", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "bb9e0889e1a5adbf796ceaf3f2bba54a", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "Fix assorted bugs in backup decompression and tar-parsing code", "evidence": {"same_day": true, "patch_ids": ["776d5a67dae4e90312023436a1a121e4", "a09bdaf76ce8e50fc1ed232d629496d1", "e611dc8dc55e1b7e28e7918dce0a5440"], "statement_hash": "14975a7d452ebd245adc06195cb53e296e97faf277282e3324587b2fcb641829"}, "url": "/docs/compare/?release=17.10#17.10-608dfcd402c79cc9", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "34c5828614b646d0ee1635c733748049", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "Fix assorted bugs in backup decompression and tar-parsing code", "evidence": {"same_day": true, "patch_ids": ["776d5a67dae4e90312023436a1a121e4", "a09bdaf76ce8e50fc1ed232d629496d1", "e611dc8dc55e1b7e28e7918dce0a5440"], "statement_hash": "14975a7d452ebd245adc06195cb53e296e97faf277282e3324587b2fcb641829"}, "url": "/docs/compare/?release=15.18#15.18-bb7e1f982c3d3fbb", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}]}, {"id": "16.14-4e7525a189b69460", "cves": [], "html": "In pg_dumpall, don't skip role GRANTs with dangling grantor OIDs (Tom Lane) §
Instead, handle such cases by emitting GRANT without any GRANTED BY clause, as we did before v16. This avoids losing the grant in foreseeable cases, since pre-v16 servers didn't prevent dropping the grantor role. Continue to emit a warning about the missing grantor, but only if the source server is v16 or later.
In pg_upgrade, take care to use the correct protocol version when connecting to older source servers (Jacob Champion) §
\nThis could be problematic when attempting to upgrade from a pre-2018 server.
", "text": "In pg_upgrade, take care to use the correct protocol version when connecting to older source servers (Jacob Champion) § This could be problematic when attempting to upgrade from a pre-2018 server.", "title": "In pg_upgrade, take care to use the correct protocol version when connecting to older source servers", "commits": ["a38ed212f"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "e69c1ffc1ded9c910a0a9d14702b53e4aaf9d59a7b6d54675bcd850b115d8ce2", "section_path": ["Changes"], "commit_groups": [["1b2773179", "a38ed212f", "a60a10338", "ad7fc3f1f", "c47744ede", "e726620d2"]], "identity_text": "In pg_upgrade, take care to use the correct protocol version when connecting to older source servers (Jacob Champion) This could be problematic when attempting to upgrade from a pre-2018 server.", "commit_aliases": ["1b2773179", "a38ed212f", "a60a10338", "ad7fc3f1f", "c47744ede", "e726620d2"], "source_commits": ["a38ed212f"], "source_entry_id": "16.14/changes/045", "db_id": "df5ddbd0c6e2f445b5c35f53b9f74046", "patch_ids": ["566020049e5cf4849b3dd9a9935a3aba"], "statement_hash": "6ea9a20b0f199ebe33de09e3497f924a73ae542c7d6af134326d0792ad8e087c", "relations": [{"rule": 2, "type": "equivalent", "target": "29ee5ab07783ca431d54fc60a7a68ac6", "evidence": {"same_day": true, "patch_ids": ["566020049e5cf4849b3dd9a9935a3aba"], "statement_hash": "6ea9a20b0f199ebe33de09e3497f924a73ae542c7d6af134326d0792ad8e087c"}}, {"rule": 2, "type": "equivalent", "target": "330e067151809e2b5b18a2ce11b3f4a8", "evidence": {"same_day": true, "patch_ids": ["566020049e5cf4849b3dd9a9935a3aba"], "statement_hash": "6ea9a20b0f199ebe33de09e3497f924a73ae542c7d6af134326d0792ad8e087c"}}, {"rule": 2, "type": "equivalent", "target": "6e7bc01c77ad0b62b80fffc021e1f621", "evidence": {"same_day": true, "patch_ids": ["566020049e5cf4849b3dd9a9935a3aba"], "statement_hash": "6ea9a20b0f199ebe33de09e3497f924a73ae542c7d6af134326d0792ad8e087c"}}, {"rule": 2, "type": "equivalent", "target": "b441ea3af4b648902039f9d5d3831785", "evidence": {"same_day": true, "patch_ids": ["566020049e5cf4849b3dd9a9935a3aba"], "statement_hash": "6ea9a20b0f199ebe33de09e3497f924a73ae542c7d6af134326d0792ad8e087c"}}], "version": "16.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "b441ea3af4b648902039f9d5d3831785", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "In pg_upgrade, take care to use the correct protocol version when connecting to older source servers", "evidence": {"same_day": true, "patch_ids": ["566020049e5cf4849b3dd9a9935a3aba"], "statement_hash": "6ea9a20b0f199ebe33de09e3497f924a73ae542c7d6af134326d0792ad8e087c"}, "url": "/docs/compare/?release=18.4#18.4-f5f35647f03db5de", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "29ee5ab07783ca431d54fc60a7a68ac6", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "In pg_upgrade, take care to use the correct protocol version when connecting to older source servers", "evidence": {"same_day": true, "patch_ids": ["566020049e5cf4849b3dd9a9935a3aba"], "statement_hash": "6ea9a20b0f199ebe33de09e3497f924a73ae542c7d6af134326d0792ad8e087c"}, "url": "/docs/compare/?release=17.10#17.10-cf34513657c8c0c2", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "330e067151809e2b5b18a2ce11b3f4a8", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "In pg_upgrade, take care to use the correct protocol version when connecting to older source servers", "evidence": {"same_day": true, "patch_ids": ["566020049e5cf4849b3dd9a9935a3aba"], "statement_hash": "6ea9a20b0f199ebe33de09e3497f924a73ae542c7d6af134326d0792ad8e087c"}, "url": "/docs/compare/?release=15.18#15.18-e68e0ef207bfd5a9", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "6e7bc01c77ad0b62b80fffc021e1f621", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "In pg_upgrade, take care to use the correct protocol version when connecting to older source servers", "evidence": {"same_day": true, "patch_ids": ["566020049e5cf4849b3dd9a9935a3aba"], "statement_hash": "6ea9a20b0f199ebe33de09e3497f924a73ae542c7d6af134326d0792ad8e087c"}, "url": "/docs/compare/?release=14.23#14.23-2b24a61f4f7f3458", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-63d7fb0d7caa58c8", "cves": [], "html": "In contrib/basic_archive, allow the archive directory to be missing at startup (Nathan Bossart) §
Previously, the setting of basic_archive.archive_directory was rejected if it didn't point to an existing directory. This is undesirable because archiving will be stuck indefinitely, even if the directory appears later.
Fix contrib/ltree to cope when case-folding changes a string's byte length (Jeff Davis) §
Previously, lquery patterns specifying case-insensitive matching might fail to match labels they should match.
In contrib/pg_stat_statements, don't leak memory if an error occurs while parsing the pgss_query_texts.stat file (Heikki Linnakangas) §
In contrib/postgres_fdw, avoid crash due to premature cleanup of a failed connection (Etsuro Fujita) §
If a remote connection fails abort cleanup, we can't use it any longer. But delay closing the connection object until end of transaction, because there might still be references to it within data structures such as open cursors.
", "text": "In contrib/postgres_fdw, avoid crash due to premature cleanup of a failed connection (Etsuro Fujita) § If a remote connection fails abort cleanup, we can't use it any longer. But delay closing the connection object until end of transaction, because there might still be references to it within data structures such as open cursors.", "title": "In contrib/postgres_fdw, avoid crash due to premature cleanup of a failed connection", "commits": ["1352651c2"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.14/#RELEASE-16-14-CHANGES", "source_hash": "dcf7bdc0e5549798176032bcdbdb5e5c039b69b4a9d269fa1a1078def7d4b319", "section_path": ["Changes"], "commit_groups": [["1352651c2", "34c18a225", "648818ba3", "af8f9248f", "c318777da", "fd5b36ab1"]], "identity_text": "In contrib/postgres_fdw, avoid crash due to premature cleanup of a failed connection (Etsuro Fujita) If a remote connection fails abort cleanup, we can't use it any longer. But delay closing the connection object until end of transaction, because there might still be references to it within data structures such as open cursors.", "commit_aliases": ["1352651c2", "34c18a225", "648818ba3", "af8f9248f", "c318777da", "fd5b36ab1"], "source_commits": ["1352651c2"], "source_entry_id": "16.14/changes/049", "db_id": "8c8ea6b283a201d99cb3d8c9f57cd142", "patch_ids": ["73eecb88ff1f4197b1eb6900521746ca"], "statement_hash": "c7e9961353a3aad5643e55ab0c89f89d4bd050418724e45b79a4a1fb13cd1c48", "relations": [{"rule": 2, "type": "equivalent", "target": "5debbdff219f6645c34f0afc23c6c9a8", "evidence": {"same_day": true, "patch_ids": ["73eecb88ff1f4197b1eb6900521746ca"], "statement_hash": "c7e9961353a3aad5643e55ab0c89f89d4bd050418724e45b79a4a1fb13cd1c48"}}, {"rule": 2, "type": "equivalent", "target": "701d8322decc496c951bc0d7ecfdd513", "evidence": {"same_day": true, "patch_ids": ["73eecb88ff1f4197b1eb6900521746ca"], "statement_hash": "c7e9961353a3aad5643e55ab0c89f89d4bd050418724e45b79a4a1fb13cd1c48"}}, {"rule": 2, "type": "equivalent", "target": "9bcb1c284d9f8abb68fce372f4df9301", "evidence": {"same_day": true, "patch_ids": ["73eecb88ff1f4197b1eb6900521746ca"], "statement_hash": "c7e9961353a3aad5643e55ab0c89f89d4bd050418724e45b79a4a1fb13cd1c48"}}, {"rule": 2, "type": "equivalent", "target": "b0783885375212755fb05950c3052a4a", "evidence": {"same_day": true, "patch_ids": ["73eecb88ff1f4197b1eb6900521746ca"], "statement_hash": "c7e9961353a3aad5643e55ab0c89f89d4bd050418724e45b79a4a1fb13cd1c48"}}], "version": "16.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "5debbdff219f6645c34f0afc23c6c9a8", "kind": "equivalent", "version": "18.4", "label": "18.4", "title": "In contrib/postgres_fdw, avoid crash due to premature cleanup of a failed connection", "evidence": {"same_day": true, "patch_ids": ["73eecb88ff1f4197b1eb6900521746ca"], "statement_hash": "c7e9961353a3aad5643e55ab0c89f89d4bd050418724e45b79a4a1fb13cd1c48"}, "url": "/docs/compare/?release=18.4#18.4-78a75773cc77437b", "source_url": "/docs/release/18.4/#RELEASE-18-4-CHANGES"}, {"db_id": "9bcb1c284d9f8abb68fce372f4df9301", "kind": "equivalent", "version": "17.10", "label": "17.10", "title": "In contrib/postgres_fdw, avoid crash due to premature cleanup of a failed connection", "evidence": {"same_day": true, "patch_ids": ["73eecb88ff1f4197b1eb6900521746ca"], "statement_hash": "c7e9961353a3aad5643e55ab0c89f89d4bd050418724e45b79a4a1fb13cd1c48"}, "url": "/docs/compare/?release=17.10#17.10-488be0605ad9d4ad", "source_url": "/docs/release/17.10/#RELEASE-17-10-CHANGES"}, {"db_id": "701d8322decc496c951bc0d7ecfdd513", "kind": "equivalent", "version": "15.18", "label": "15.18", "title": "In contrib/postgres_fdw, avoid crash due to premature cleanup of a failed connection", "evidence": {"same_day": true, "patch_ids": ["73eecb88ff1f4197b1eb6900521746ca"], "statement_hash": "c7e9961353a3aad5643e55ab0c89f89d4bd050418724e45b79a4a1fb13cd1c48"}, "url": "/docs/compare/?release=15.18#15.18-9110118db586478d", "source_url": "/docs/release/15.18/#id-1.11.6.7.5"}, {"db_id": "b0783885375212755fb05950c3052a4a", "kind": "equivalent", "version": "14.23", "label": "14.23", "title": "In contrib/postgres_fdw, avoid crash due to premature cleanup of a failed connection", "evidence": {"same_day": true, "patch_ids": ["73eecb88ff1f4197b1eb6900521746ca"], "statement_hash": "c7e9961353a3aad5643e55ab0c89f89d4bd050418724e45b79a4a1fb13cd1c48"}, "url": "/docs/compare/?release=14.23#14.23-c4a00b3d7115895d", "source_url": "/docs/release/14.23/#id-1.11.6.7.6"}]}, {"id": "16.14-d0a6ee4c3af9be4b", "cves": [], "html": "Update time zone data files to tzdata release 2026b (Tom Lane) §
\nBritish Columbia (America/Vancouver) will be on year-round UTC-07 (effectively, permanent DST) beginning in November 2026. This release assumes that their TZ abbreviation will be MST from that time forward. That seems likely to change, but it's unclear what new abbreviation will be used. Also a historical correction for Moldova: they have followed EU DST transition times since 2022.