A dump/restore is not required for those running 15.X.
\nHowever, if you are upgrading from a version earlier than 15.14, see Section E.6.
", "compatibility_count": 0, "label": "15.16", "status_label": "Supported", "eol": "2027-11-11", "age_days": 226, "support_days": 411}, "groups": [{"date": "2026-02-12", "build": "15.16", "major": "15", "minor": 16, "manual": "15", "status": "stable", "doc_git": "", "version": "15.16", "eol_date": "2027-11-11", "date_text": "2026-02-12", "supported": true, "manual_url": "/docs/15/release-15-16.html", "source_url": "/docs/release/15.16/", "entry_count": 40, "placeholder": false, "content_hash": "e69e2c20b49e64054c7e945189fcf4ddc123b7131a3841ee6f91adb6adf5a365", "manual_build": "15.19", "source_as_of": "", "changes_count": 40, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 15.X.
\nHowever, if you are upgrading from a version earlier than 15.14, see Section E.6.
", "compatibility_count": 0, "label": "15.16", "status_label": "Supported", "eol": "2027-11-11", "age_days": 226, "support_days": 411, "entries": [{"id": "15.16-cffa85682917fc25", "cves": ["CVE-2026-2003"], "html": "Guard against unexpected dimensions of oidvector/int2vector (Tom Lane) §
These data types are expected to be 1-dimensional arrays containing no nulls, but there are cast pathways that permit violating those expectations. Add checks to some functions that were depending on those expectations without verifying them, and could misbehave in consequence.
\nThe PostgreSQL Project thanks Altan Birler for reporting this problem. (CVE-2026-2003)
", "text": "Guard against unexpected dimensions of oidvector/int2vector (Tom Lane) § These data types are expected to be 1-dimensional arrays containing no nulls, but there are cast pathways that permit violating those expectations. Add checks to some functions that were depending on those expectations without verifying them, and could misbehave in consequence. The PostgreSQL Project thanks Altan Birler for reporting this problem. (CVE-2026-2003)", "title": "Guard against unexpected dimensions of oidvector/int2vector", "commits": ["429aeaebd"], "section": "Changes", "category": "security", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "4e251b25bfdfaf4fc7b6580e4720acb2ac5ae2e6527c067a9a2e06b1bca6755a", "section_path": ["Changes"], "commit_groups": [["3b6588cd9", "3d160401b", "429aeaebd", "595956fc7", "60e7ae41a", "b39d38139"]], "identity_text": "Guard against unexpected dimensions of oidvector/int2vector (Tom Lane) These data types are expected to be 1-dimensional arrays containing no nulls, but there are cast pathways that permit violating those expectations. Add checks to some functions that were depending on those expectations without verifying them, and could misbehave in consequence. The PostgreSQL Project thanks Altan Birler for reporting this problem. (CVE-2026-2003)", "commit_aliases": ["3b6588cd9", "3d160401b", "429aeaebd", "595956fc7", "60e7ae41a", "b39d38139"], "source_commits": ["429aeaebd"], "source_entry_id": "15.16/changes/001", "db_id": "8db55cd2cacfbefb7d8380baee0440a5", "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787", "relations": [{"rule": 2, "type": "equivalent", "target": "020aec6d98ff35dcd4eca87ecb7d21fd", "evidence": {"same_day": true, "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787"}}, {"rule": 2, "type": "equivalent", "target": "93680dc2fc005fc9bc0a92b7d80ee23b", "evidence": {"same_day": true, "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787"}}, {"rule": 2, "type": "equivalent", "target": "d474cd2cf9a4505bba396d502fe366fe", "evidence": {"same_day": true, "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787"}}, {"rule": 2, "type": "equivalent", "target": "dadfe1bd35a127e4b2350a876ce5f39d", "evidence": {"same_day": true, "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787"}}], "version": "15.16", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "020aec6d98ff35dcd4eca87ecb7d21fd", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Guard against unexpected dimensions of oidvector/int2vector", "evidence": {"same_day": true, "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787"}, "url": "/docs/compare/?release=18.2#18.2-5c52afa7301594c6", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "dadfe1bd35a127e4b2350a876ce5f39d", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Guard against unexpected dimensions of oidvector/int2vector", "evidence": {"same_day": true, "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787"}, "url": "/docs/compare/?release=17.8#17.8-a1109c4f32ae03d0", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "93680dc2fc005fc9bc0a92b7d80ee23b", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Guard against unexpected dimensions of oidvector/int2vector", "evidence": {"same_day": true, "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787"}, "url": "/docs/compare/?release=16.12#16.12-289361027e903f71", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "d474cd2cf9a4505bba396d502fe366fe", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Guard against unexpected dimensions of oidvector/int2vector", "evidence": {"same_day": true, "patch_ids": ["e625ea93052fd4dfb5ad354c3e4c3569"], "statement_hash": "ce3b678bc249d2400e6f33b017d19a152d1f885b7690423e0e17ba0530a55787"}, "url": "/docs/compare/?release=14.21#14.21-182abf620be79725", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-9ecdcfc6d990fa17", "cves": ["CVE-2026-2004"], "html": "Harden selectivity estimators against being attached to operators that accept unexpected data types (Tom Lane) § § §
\ncontrib/intarray contained a selectivity estimation function that could be abused for arbitrary code execution, because it did not check that its input was of the expected data type. Third-party extensions should check for similar hazards and add defenses using the technique intarray now uses. Since such extension fixes will take time, we now require superuser privilege to attach a non-built-in selectivity estimator to an operator.
The PostgreSQL Project thanks Daniel Firer, as part of zeroday.cloud, for reporting this problem. (CVE-2026-2004)
", "text": "Harden selectivity estimators against being attached to operators that accept unexpected data types (Tom Lane) § § § contrib/intarray contained a selectivity estimation function that could be abused for arbitrary code execution, because it did not check that its input was of the expected data type. Third-party extensions should check for similar hazards and add defenses using the technique intarray now uses. Since such extension fixes will take time, we now require superuser privilege to attach a non-built-in selectivity estimator to an operator. The PostgreSQL Project thanks Daniel Firer, as part of zeroday.cloud, for reporting this problem. (CVE-2026-2004)", "title": "Harden selectivity estimators against being attached to operators that accept unexpected data types", "commits": ["3ecc84cce", "b764b26f2", "deb464a40"], "section": "Changes", "category": "security", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "850e7c71f5a877f6529a7df8d6fd635e662a2577b70aef46f1164d6c08d17f10", "section_path": ["Changes"], "commit_groups": [["3ecc84cce", "9fa38c572", "d484bc260", "dbb09fd8e"], ["66ddac698", "841d42cc4", "91d7c0bfd", "b764b26f2", "bbf5bcf58", "ea3bf3498"], ["7e82d9a04", "8ebdf41c2", "b69af3dda", "c0887b39d", "dd3ad2a4d", "deb464a40"]], "identity_text": "Harden selectivity estimators against being attached to operators that accept unexpected data types (Tom Lane) contrib/intarray contained a selectivity estimation function that could be abused for arbitrary code execution, because it did not check that its input was of the expected data type. Third-party extensions should check for similar hazards and add defenses using the technique intarray now uses. Since such extension fixes will take time, we now require superuser privilege to attach a non-built-in selectivity estimator to an operator. The PostgreSQL Project thanks Daniel Firer, as part of zeroday.cloud, for reporting this problem. (CVE-2026-2004)", "commit_aliases": ["3ecc84cce", "66ddac698", "7e82d9a04", "841d42cc4", "8ebdf41c2", "91d7c0bfd", "9fa38c572", "b69af3dda", "b764b26f2", "bbf5bcf58", "c0887b39d", "d484bc260", "dbb09fd8e", "dd3ad2a4d", "deb464a40", "ea3bf3498"], "source_commits": ["3ecc84cce", "b764b26f2", "deb464a40"], "source_entry_id": "15.16/changes/002", "db_id": "b368f952921e7f029d36869bd2860743", "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4", "relations": [{"rule": 2, "type": "equivalent", "target": "184452363a4be8fbad69f06eb60df539", "evidence": {"same_day": true, "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4"}}, {"rule": 2, "type": "equivalent", "target": "3cfe051a6ace1086d9ff67af367a40f4", "evidence": {"same_day": true, "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4"}}, {"rule": 2, "type": "equivalent", "target": "853a0accddf2290afda1b4c5d74207ed", "evidence": {"same_day": true, "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4"}}, {"rule": 2, "type": "equivalent", "target": "eb75ba70d74784578edba6ea18a6aaf9", "evidence": {"same_day": true, "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4"}}], "version": "15.16", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "853a0accddf2290afda1b4c5d74207ed", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Harden selectivity estimators against being attached to operators that accept unexpected data types", "evidence": {"same_day": true, "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4"}, "url": "/docs/compare/?release=18.2#18.2-0a3add9d9f709ebd", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "eb75ba70d74784578edba6ea18a6aaf9", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Harden selectivity estimators against being attached to operators that accept unexpected data types", "evidence": {"same_day": true, "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4"}, "url": "/docs/compare/?release=17.8#17.8-66e960e22441cfaa", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "184452363a4be8fbad69f06eb60df539", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Harden selectivity estimators against being attached to operators that accept unexpected data types", "evidence": {"same_day": true, "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4"}, "url": "/docs/compare/?release=16.12#16.12-9d7c1c9d84e5292d", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "3cfe051a6ace1086d9ff67af367a40f4", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Harden selectivity estimators against being attached to operators that accept unexpected data types", "evidence": {"same_day": true, "patch_ids": ["2f2e483656bae2dbe55158c3365123bd", "356a9ce59861f3c9318ff0c7fe53f540", "4bc40137a21f6b104cb7a2aaf123c445"], "statement_hash": "bf854d211c57f15bce3aa7bbb099f8690284afbf8188626b5fdf9bd083214cc4"}, "url": "/docs/compare/?release=14.21#14.21-4f1356e5a78a8982", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-55f620c5255ec99f", "cves": ["CVE-2026-2005"], "html": "Fix buffer overrun in contrib/pgcrypto's PGP decryption functions (Michael Paquier) §
Decrypting a crafted message with an overlength session key caused a buffer overrun, with consequences as bad as arbitrary code execution.
\nThe PostgreSQL Project thanks Team Xint Code, as part of zeroday.cloud, for reporting this problem. (CVE-2026-2005)
", "text": "Fix buffer overrun in contrib/pgcrypto's PGP decryption functions (Michael Paquier) § Decrypting a crafted message with an overlength session key caused a buffer overrun, with consequences as bad as arbitrary code execution. The PostgreSQL Project thanks Team Xint Code, as part of zeroday.cloud, for reporting this problem. (CVE-2026-2005)", "title": "Fix buffer overrun in contrib/pgcrypto's PGP decryption functions", "commits": ["9a9982ec6"], "section": "Changes", "category": "security", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "d3340ce33dee6b34344e29023ed13f3391144847390682bf5d5af53fecfeb57f", "section_path": ["Changes"], "commit_groups": [["01de2e32d", "209f387b8", "379695d3c", "527b730f4", "7a7d9693c", "9a9982ec6"]], "identity_text": "Fix buffer overrun in contrib/pgcrypto's PGP decryption functions (Michael Paquier) Decrypting a crafted message with an overlength session key caused a buffer overrun, with consequences as bad as arbitrary code execution. The PostgreSQL Project thanks Team Xint Code, as part of zeroday.cloud, for reporting this problem. (CVE-2026-2005)", "commit_aliases": ["01de2e32d", "209f387b8", "379695d3c", "527b730f4", "7a7d9693c", "9a9982ec6"], "source_commits": ["9a9982ec6"], "source_entry_id": "15.16/changes/003", "db_id": "e4dd47f240a98be34ae099044d8a2b56", "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307", "relations": [{"rule": 2, "type": "equivalent", "target": "bdd4104dfc3659a38e0f0389ee19b847", "evidence": {"same_day": true, "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307"}}, {"rule": 2, "type": "equivalent", "target": "d0b0ce25a07e9ad598056180477520b6", "evidence": {"same_day": true, "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307"}}, {"rule": 2, "type": "equivalent", "target": "e7bf20473d33d5835462a40fa9fd5552", "evidence": {"same_day": true, "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307"}}, {"rule": 2, "type": "equivalent", "target": "ef4c4d388861428d41d8694448d1ec90", "evidence": {"same_day": true, "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307"}}], "version": "15.16", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "ef4c4d388861428d41d8694448d1ec90", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Fix buffer overrun in contrib/pgcrypto's PGP decryption functions", "evidence": {"same_day": true, "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307"}, "url": "/docs/compare/?release=18.2#18.2-c6669984145bd55c", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "d0b0ce25a07e9ad598056180477520b6", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Fix buffer overrun in contrib/pgcrypto's PGP decryption functions", "evidence": {"same_day": true, "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307"}, "url": "/docs/compare/?release=17.8#17.8-ad02898fb1831e36", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "e7bf20473d33d5835462a40fa9fd5552", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Fix buffer overrun in contrib/pgcrypto's PGP decryption functions", "evidence": {"same_day": true, "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307"}, "url": "/docs/compare/?release=16.12#16.12-a3ed183e10806004", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "bdd4104dfc3659a38e0f0389ee19b847", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Fix buffer overrun in contrib/pgcrypto's PGP decryption functions", "evidence": {"same_day": true, "patch_ids": ["8812c5ce4844c4609945e75b3dad003d"], "statement_hash": "643330e49824e6c84ee06b67cc1febd73b94c839951a2861efc8c384a23e8307"}, "url": "/docs/compare/?release=14.21#14.21-8072e6858a1ccb57", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-62940c666c30fc8b", "cves": ["CVE-2026-2006"], "html": "Fix inadequate validation of multibyte character lengths (Thomas Munro, Noah Misch) § § § § § §
\nAssorted bugs allowed an attacker able to issue crafted SQL to overrun string buffers, with consequences as bad as arbitrary code execution. After these fixes, applications may observe “invalid byte sequence for encoding” errors when string functions process invalid text that has been stored in the database.
\nThe PostgreSQL Project thanks Paul Gerste and Moritz Sanft, as part of zeroday.cloud, for reporting this problem. (CVE-2026-2006)
", "text": "Fix inadequate validation of multibyte character lengths (Thomas Munro, Noah Misch) § § § § § § Assorted bugs allowed an attacker able to issue crafted SQL to overrun string buffers, with consequences as bad as arbitrary code execution. After these fixes, applications may observe “invalid byte sequence for encoding” errors when string functions process invalid text that has been stored in the database. The PostgreSQL Project thanks Paul Gerste and Moritz Sanft, as part of zeroday.cloud, for reporting this problem. (CVE-2026-2006)", "title": "Fix inadequate validation of multibyte character lengths", "commits": ["50863be0b", "6f741bcb6", "757bf8145", "8f8b1ffac", "b2c81ac86", "fd82ddb67"], "section": "Changes", "category": "security", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "3274362f1d5a0338f397a01e642b2e8ee1fade7f537ae5374030ed707b6e57fd", "section_path": ["Changes"], "commit_groups": [["0c33d5608", "8373ed094", "8f8b1ffac", "b42709194", "d536aee55", "dc072a09a"], ["10ebc4bd6", "4c08960d9", "757bf8145", "b0f5d25bc", "c67bef3f3", "e7591254c"], ["1e7fe06c1", "319e8a644", "7b5fc85be", "cecedb912", "d837fb029", "fd82ddb67"], ["2a53db21e", "70ff9ede5", "838248b1b", "af79c30dc", "b2c81ac86", "df0852fe0"], ["4543b02af", "5301b2b7d", "6f741bcb6", "763671b74", "955433ebd", "c5dc75479"], ["50863be0b", "6ed116046", "74ee636cc", "7a522039f", "b0e3f5cf9", "efef05ba9"]], "identity_text": "Fix inadequate validation of multibyte character lengths (Thomas Munro, Noah Misch) Assorted bugs allowed an attacker able to issue crafted SQL to overrun string buffers, with consequences as bad as arbitrary code execution. After these fixes, applications may observe invalid byte sequence for encoding errors when string functions process invalid text that has been stored in the database. The PostgreSQL Project thanks Paul Gerste and Moritz Sanft, as part of zeroday.cloud, for reporting this problem. (CVE-2026-2006)", "commit_aliases": ["0c33d5608", "10ebc4bd6", "1e7fe06c1", "2a53db21e", "319e8a644", "4543b02af", "4c08960d9", "50863be0b", "5301b2b7d", "6ed116046", "6f741bcb6", "70ff9ede5", "74ee636cc", "757bf8145", "763671b74", "7a522039f", "7b5fc85be", "8373ed094", "838248b1b", "8f8b1ffac", "955433ebd", "af79c30dc", "b0e3f5cf9", "b0f5d25bc", "b2c81ac86", "b42709194", "c5dc75479", "c67bef3f3", "cecedb912", "d536aee55", "d837fb029", "dc072a09a", "df0852fe0", "e7591254c", "efef05ba9", "fd82ddb67"], "source_commits": ["50863be0b", "6f741bcb6", "757bf8145", "8f8b1ffac", "b2c81ac86", "fd82ddb67"], "source_entry_id": "15.16/changes/004", "db_id": "e5c2b929807dffd0fc80d18ac5ef27da", "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb", "relations": [{"rule": 2, "type": "equivalent", "target": "25b98554e64d0842a180907318bd502a", "evidence": {"same_day": true, "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb"}}, {"rule": 2, "type": "equivalent", "target": "2fee65050d60d6944038f5de1fd6e77f", "evidence": {"same_day": true, "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb"}}, {"rule": 2, "type": "equivalent", "target": "66ef8e4bb930ff6d7fb76f1509e60bdb", "evidence": {"same_day": true, "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb"}}, {"rule": 2, "type": "equivalent", "target": "c7f1c767af36d148849ecf12abc7b39c", "evidence": {"same_day": true, "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb"}}], "version": "15.16", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "66ef8e4bb930ff6d7fb76f1509e60bdb", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Fix inadequate validation of multibyte character lengths", "evidence": {"same_day": true, "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb"}, "url": "/docs/compare/?release=18.2#18.2-b28dc0bb7dc6b053", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "2fee65050d60d6944038f5de1fd6e77f", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Fix inadequate validation of multibyte character lengths", "evidence": {"same_day": true, "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb"}, "url": "/docs/compare/?release=17.8#17.8-0378679c62701a5e", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "c7f1c767af36d148849ecf12abc7b39c", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Fix inadequate validation of multibyte character lengths", "evidence": {"same_day": true, "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb"}, "url": "/docs/compare/?release=16.12#16.12-d657c6f02bbf824f", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "25b98554e64d0842a180907318bd502a", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Fix inadequate validation of multibyte character lengths", "evidence": {"same_day": true, "patch_ids": ["495ed616c5c9d01200b34ff986191d76", "8b94976f553df832eb256817e06f6e8e", "a8ccf4d965aea8d430069f2b4025b384", "b98e99e748716baf094e4d11553e19ae", "e1e546efb1e21ef2c167c052b7fc2c27", "ef48875931b707685e95ea56147ddbe5"], "statement_hash": "6c6e0d081c08625c5f6ce833f7e79f2bb277ec939453acd9d359f724272d34eb"}, "url": "/docs/compare/?release=14.21#14.21-0170b76fb58a4a02", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-dc510262703bad79", "cves": [], "html": "Don't allow CTE references in sub-selects to determine semantic levels of aggregate functions (Tom Lane) §
\nThis change undoes a change made two minor releases ago, instead throwing an error if a sub-select references a CTE that's below the semantic level that standard SQL rules would assign to the aggregate based on contained column references and aggregates. The attempted fix turned out to cause problems of its own, and it's unclear what to do instead. Since sub-selects within aggregates are disallowed altogether by the SQL standard, treating such cases as errors seems sufficient.
", "text": "Don't allow CTE references in sub-selects to determine semantic levels of aggregate functions (Tom Lane) § This change undoes a change made two minor releases ago, instead throwing an error if a sub-select references a CTE that's below the semantic level that standard SQL rules would assign to the aggregate based on contained column references and aggregates. The attempted fix turned out to cause problems of its own, and it's unclear what to do instead. Since sub-selects within aggregates are disallowed altogether by the SQL standard, treating such cases as errors seems sufficient.", "title": "Don't allow CTE references in sub-selects to determine semantic levels of aggregate functions", "commits": ["9f5a58aac"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "3f3e63830f8b41c872ad80692e74acd7a00bf17a39ae022d9e575e1e52080c55", "section_path": ["Changes"], "commit_groups": [["075a763e2", "12bc32917", "1c8c3206f", "35b5c62c3", "9f5a58aac", "b85397481"]], "identity_text": "Don't allow CTE references in sub-selects to determine semantic levels of aggregate functions (Tom Lane) This change undoes a change made two minor releases ago, instead throwing an error if a sub-select references a CTE that's below the semantic level that standard SQL rules would assign to the aggregate based on contained column references and aggregates. The attempted fix turned out to cause problems of its own, and it's unclear what to do instead. Since sub-selects within aggregates are disallowed altogether by the SQL standard, treating such cases as errors seems sufficient.", "commit_aliases": ["075a763e2", "12bc32917", "1c8c3206f", "35b5c62c3", "9f5a58aac", "b85397481"], "source_commits": ["9f5a58aac"], "source_entry_id": "15.16/changes/005", "db_id": "4864352d8953061a7f3e2f942fd405e2", "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059", "relations": [{"rule": 2, "type": "equivalent", "target": "128a16829eb01aeea2a683fa84040725", "evidence": {"same_day": true, "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059"}}, {"rule": 2, "type": "equivalent", "target": "968c190ce539c030cfe3824a0cddc761", "evidence": {"same_day": true, "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059"}}, {"rule": 2, "type": "equivalent", "target": "cc9e6465c86b962c0dda27e8afcac193", "evidence": {"same_day": true, "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059"}}, {"rule": 2, "type": "equivalent", "target": "dcc6e6d85b35d0422b8e17422a731c4a", "evidence": {"same_day": true, "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059"}}], "version": "15.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "968c190ce539c030cfe3824a0cddc761", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Don't allow CTE references in sub-selects to determine semantic levels of aggregate functions", "evidence": {"same_day": true, "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059"}, "url": "/docs/compare/?release=18.2#18.2-d6f0ddb2f2597bb2", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "128a16829eb01aeea2a683fa84040725", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Don't allow CTE references in sub-selects to determine semantic levels of aggregate functions", "evidence": {"same_day": true, "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059"}, "url": "/docs/compare/?release=17.8#17.8-69605b7e08548aa0", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "cc9e6465c86b962c0dda27e8afcac193", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Don't allow CTE references in sub-selects to determine semantic levels of aggregate functions", "evidence": {"same_day": true, "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059"}, "url": "/docs/compare/?release=16.12#16.12-e79313988f03e883", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "dcc6e6d85b35d0422b8e17422a731c4a", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Don't allow CTE references in sub-selects to determine semantic levels of aggregate functions", "evidence": {"same_day": true, "patch_ids": ["b900772ffaf16070ad5c6f3ee9476799"], "statement_hash": "aca5184caeda78eb5d5b9152a6295b4c451d3d7324fcbaae36c120961950e059"}, "url": "/docs/compare/?release=14.21#14.21-9f3dcc608f8165a8", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-3bdf28daf1c8fa5a", "cves": [], "html": "Fix trigger transition table capture for MERGE in CTE queries (Dean Rasheed) §
When executing a data-modifying CTE query containing both a MERGE and another DML operation on a table with statement-level AFTER triggers, the transition tables passed to the triggers would not include the rows affected by the MERGE, only those affected by the other operation(s).
Fix failure when all children of a partitioned target table of an update or delete have been pruned (Amit Langote) §
\nIn such cases, the executor could report “could not find junk ctid column” errors, even though nothing needs to be done.
", "text": "Fix failure when all children of a partitioned target table of an update or delete have been pruned (Amit Langote) § In such cases, the executor could report “could not find junk ctid column” errors, even though nothing needs to be done.", "title": "Fix failure when all children of a partitioned target table of an update or delete have been pruned", "commits": ["687533b39"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "46a1d047b6461ac78a819f12a5fd42d39690959f92359d1d37ef800825fbfc4a", "section_path": ["Changes"], "commit_groups": [["687533b39", "6d2fa44d2", "933f67fb6", "9f4b7bfc5", "f9a468c66", "fab386f74"]], "identity_text": "Fix failure when all children of a partitioned target table of an update or delete have been pruned (Amit Langote) In such cases, the executor could report could not find junk ctid column errors, even though nothing needs to be done.", "commit_aliases": ["687533b39", "6d2fa44d2", "933f67fb6", "9f4b7bfc5", "f9a468c66", "fab386f74"], "source_commits": ["687533b39"], "source_entry_id": "15.16/changes/007", "db_id": "179b2113d34cec63f6ed7d3339773014", "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3", "relations": [{"rule": 2, "type": "equivalent", "target": "4ced629daa2801c0202dec91097dd571", "evidence": {"same_day": true, "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3"}}, {"rule": 2, "type": "equivalent", "target": "63da9c3d80fbdcaacf4a6c8e130df7a3", "evidence": {"same_day": true, "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3"}}, {"rule": 2, "type": "equivalent", "target": "7a4315af35989c84209f54d435f1bc39", "evidence": {"same_day": true, "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3"}}, {"rule": 2, "type": "equivalent", "target": "f4b5a0c770a80f36d1c78eef1f635128", "evidence": {"same_day": true, "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3"}}], "version": "15.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "f4b5a0c770a80f36d1c78eef1f635128", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Fix failure when all children of a partitioned target table of an update or delete have been pruned", "evidence": {"same_day": true, "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3"}, "url": "/docs/compare/?release=18.2#18.2-6f5d6058ff3801ed", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "63da9c3d80fbdcaacf4a6c8e130df7a3", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Fix failure when all children of a partitioned target table of an update or delete have been pruned", "evidence": {"same_day": true, "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3"}, "url": "/docs/compare/?release=17.8#17.8-47d93f8afe450b73", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "7a4315af35989c84209f54d435f1bc39", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Fix failure when all children of a partitioned target table of an update or delete have been pruned", "evidence": {"same_day": true, "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3"}, "url": "/docs/compare/?release=16.12#16.12-4f022f27b3f533c3", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "4ced629daa2801c0202dec91097dd571", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Fix failure when all children of a partitioned target table of an update or delete have been pruned", "evidence": {"same_day": true, "patch_ids": ["9a0dd248bccac339f799f84ddd7d8025"], "statement_hash": "2d865ce2ec1c605811a5336cc6b79b917602006b9d88ed02a66f1499e94eb2b3"}, "url": "/docs/compare/?release=14.21#14.21-807fef0437b28900", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-818eabd46b773ca1", "cves": [], "html": "Allow indexscans on partial hash indexes even when the index's predicate implies the truth of the WHERE clause (Tom Lane) §
\nNormally we drop a WHERE clause that is implied by the predicate, since it's pointless to test it; it must hold for every index entry. However that can prevent creation of an indexscan plan if the index is one that requires a WHERE clause on the leading index key, as hash indexes do. Don't drop implied clauses when considering such an index.
", "text": "Allow indexscans on partial hash indexes even when the index's predicate implies the truth of the WHERE clause (Tom Lane) § Normally we drop a WHERE clause that is implied by the predicate, since it's pointless to test it; it must hold for every index entry. However that can prevent creation of an indexscan plan if the index is one that requires a WHERE clause on the leading index key, as hash indexes do. Don't drop implied clauses when considering such an index.", "title": "Allow indexscans on partial hash indexes even when the index's predicate implies the truth of the WHERE clause", "commits": ["f19502f04"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "1478bf6398405397a5f5b05c225db0fbfd098fe740128f6edff994a4aab95373", "section_path": ["Changes"], "commit_groups": [["5528e8d10", "9e77323fc", "a212877dc", "b497766a8", "e79b27662", "f19502f04"]], "identity_text": "Allow indexscans on partial hash indexes even when the index's predicate implies the truth of the WHERE clause (Tom Lane) Normally we drop a WHERE clause that is implied by the predicate, since it's pointless to test it; it must hold for every index entry. However that can prevent creation of an indexscan plan if the index is one that requires a WHERE clause on the leading index key, as hash indexes do. Don't drop implied clauses when considering such an index.", "commit_aliases": ["5528e8d10", "9e77323fc", "a212877dc", "b497766a8", "e79b27662", "f19502f04"], "source_commits": ["f19502f04"], "source_entry_id": "15.16/changes/008", "db_id": "b1cd37aac266a35b85d498fbf852a341", "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac", "relations": [{"rule": 2, "type": "equivalent", "target": "46491fe43c6b06ae0b36463bb9ec508d", "evidence": {"same_day": true, "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac"}}, {"rule": 2, "type": "equivalent", "target": "be90b044d06ac445fb5ba563113882da", "evidence": {"same_day": true, "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac"}}, {"rule": 2, "type": "equivalent", "target": "ed2a57d1a47eb0ac687c6d995081429b", "evidence": {"same_day": true, "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac"}}, {"rule": 2, "type": "equivalent", "target": "f2b4b6b2c2b28f97888464f6ce6ad3fa", "evidence": {"same_day": true, "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac"}}], "version": "15.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "ed2a57d1a47eb0ac687c6d995081429b", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Allow indexscans on partial hash indexes even when the index's predicate implies the truth of the WHERE clause", "evidence": {"same_day": true, "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac"}, "url": "/docs/compare/?release=18.2#18.2-61e225cdb2ce1f36", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "46491fe43c6b06ae0b36463bb9ec508d", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Allow indexscans on partial hash indexes even when the index's predicate implies the truth of the WHERE clause", "evidence": {"same_day": true, "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac"}, "url": "/docs/compare/?release=17.8#17.8-845083cdcffc5df5", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "be90b044d06ac445fb5ba563113882da", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Allow indexscans on partial hash indexes even when the index's predicate implies the truth of the WHERE clause", "evidence": {"same_day": true, "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac"}, "url": "/docs/compare/?release=16.12#16.12-576930101da7e4de", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "f2b4b6b2c2b28f97888464f6ce6ad3fa", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Allow indexscans on partial hash indexes even when the index's predicate implies the truth of the WHERE clause", "evidence": {"same_day": true, "patch_ids": ["371e0fb22b0b4c3ce7000e6e8780d0ab"], "statement_hash": "978f69342e3def3b8ca6380a3dacf1634fda30feb1db7c0f20d33cad5e6b4dac"}, "url": "/docs/compare/?release=14.21#14.21-a5950a5bc8025cc6", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-a50c7a9a9c1966f8", "cves": [], "html": "Do not emit WAL for unlogged BRIN indexes (Kirill Reshke) §
\nOne seldom-taken code path incorrectly emitted a WAL record relating to a BRIN index even if the index was marked unlogged. Crash recovery would then fail to replay that record, complaining that the file already exists.
", "text": "Do not emit WAL for unlogged BRIN indexes (Kirill Reshke) § One seldom-taken code path incorrectly emitted a WAL record relating to a BRIN index even if the index was marked unlogged. Crash recovery would then fail to replay that record, complaining that the file already exists.", "title": "Do not emit WAL for unlogged BRIN indexes", "commits": ["460d97020"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "863d4705761a03f2ea660f22a367e7922cd2712f32e7cddc384350b3cbd751ea", "section_path": ["Changes"], "commit_groups": [["460d97020", "4b6d096a0", "951b60f7a", "a5277700e", "ab4256869", "d77a5f981"]], "identity_text": "Do not emit WAL for unlogged BRIN indexes (Kirill Reshke) One seldom-taken code path incorrectly emitted a WAL record relating to a BRIN index even if the index was marked unlogged. Crash recovery would then fail to replay that record, complaining that the file already exists.", "commit_aliases": ["460d97020", "4b6d096a0", "951b60f7a", "a5277700e", "ab4256869", "d77a5f981"], "source_commits": ["460d97020"], "source_entry_id": "15.16/changes/009", "db_id": "5e595f6d6c44016c34bfdd305d261a1f", "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f", "relations": [{"rule": 2, "type": "equivalent", "target": "0937f4c4aaa8ff37a519ed8e315b4268", "evidence": {"same_day": true, "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f"}}, {"rule": 2, "type": "equivalent", "target": "293acf13040f24b30864b10bd699a3a0", "evidence": {"same_day": true, "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f"}}, {"rule": 2, "type": "equivalent", "target": "a7d18f384393c9a111537f87704719de", "evidence": {"same_day": true, "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f"}}, {"rule": 2, "type": "equivalent", "target": "e2905bab9de145b119d05715dee49169", "evidence": {"same_day": true, "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f"}}], "version": "15.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "0937f4c4aaa8ff37a519ed8e315b4268", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Do not emit WAL for unlogged BRIN indexes", "evidence": {"same_day": true, "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f"}, "url": "/docs/compare/?release=18.2#18.2-569b26ba06e60ceb", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "293acf13040f24b30864b10bd699a3a0", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Do not emit WAL for unlogged BRIN indexes", "evidence": {"same_day": true, "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f"}, "url": "/docs/compare/?release=17.8#17.8-91a20d38e502ab15", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "a7d18f384393c9a111537f87704719de", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Do not emit WAL for unlogged BRIN indexes", "evidence": {"same_day": true, "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f"}, "url": "/docs/compare/?release=16.12#16.12-1d78fb1ed6b323ce", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "e2905bab9de145b119d05715dee49169", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Do not emit WAL for unlogged BRIN indexes", "evidence": {"same_day": true, "patch_ids": ["548b71793684eb7a3b4dc68f7e774931"], "statement_hash": "14bc5b9ab44a24425a2aaf5ae8e65539cd475fa7e779fdd338932c2bec859e4f"}, "url": "/docs/compare/?release=14.21#14.21-7a0553ecbce106c9", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-33cc5dd7a3fa872f", "cves": [], "html": "Prevent truncation of CLOG that is still needed by unread NOTIFY messages (Joel Jacobson, Heikki Linnakangas) § § §
This fix prevents “could not access status of transaction” errors when a backend is slow to absorb NOTIFY messages.
Escalate errors occurring during NOTIFY message processing to FATAL, i.e. close the connection (Heikki Linnakangas) §
Formerly, if a backend got an error while absorbing a NOTIFY message, it would advance past that message, report the error to the client, and move on. That behavior was fraught with problems though. One big concern is that the client has no good way to know that a notification was lost, and certainly no way to know what was in it. Depending on the application logic, missing a notification could cause the application to get stuck waiting, for example. Also, any remaining messages would not get processed until someone sent a new NOTIFY.
Also, if the connection is idle at the time of receiving a NOTIFY signal, any ERROR would be escalated to FATAL anyway, due to unrelated concerns. Therefore, we've chosen to make that happen in all cases, for consistency and to provide a clear signal to the application that it might have missed some notifications.
Fix bug in following update chain when locking a tuple (Jasper Smit) §
\nThis code path neglected to check the xmin of the first new tuple in the update chain, making it possible to lock an unrelated tuple if the original updater aborted and the space was immediately reclaimed by VACUUM and then re-used. That could cause unexpected transaction delays or deadlocks. Errors associated with having identified the wrong tuple have also been observed.
Fix issues around in-place catalog updates (Noah Misch) § § §
\nSend a nontransactional invalidation message for an in-place update, since such an update will survive transaction rollback. Also ensure that the update is WAL-logged before other sessions can see it. These fixes primarily prevent scenarios in which relations' frozen-XID attributes become inconsistent, possibly allowing premature CLOG truncation and subsequent “could not access status of transaction” errors.
", "text": "Fix issues around in-place catalog updates (Noah Misch) § § § Send a nontransactional invalidation message for an in-place update, since such an update will survive transaction rollback. Also ensure that the update is WAL-logged before other sessions can see it. These fixes primarily prevent scenarios in which relations' frozen-XID attributes become inconsistent, possibly allowing premature CLOG truncation and subsequent “could not access status of transaction” errors.", "title": "Fix issues around in-place catalog updates", "commits": ["05d605b6c", "20a48c156", "86091202a"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "8e4b79aa44d37c8088720f85d7deceb05ef701bdc6d2c6d68b7bec2a3746a5e1", "section_path": ["Changes"], "commit_groups": [["05d605b6c", "0f69bedde", "1d7b02711", "811422471"], ["0dfbd191a", "27e4fad98", "86091202a", "bcb784e7d"], ["20a48c156", "720e9304f", "d3e5d8950", "e4b1986b9"]], "identity_text": "Fix issues around in-place catalog updates (Noah Misch) Send a nontransactional invalidation message for an in-place update, since such an update will survive transaction rollback. Also ensure that the update is WAL-logged before other sessions can see it. These fixes primarily prevent scenarios in which relations' frozen-XID attributes become inconsistent, possibly allowing premature CLOG truncation and subsequent could not access status of transaction errors.", "commit_aliases": ["05d605b6c", "0dfbd191a", "0f69bedde", "1d7b02711", "20a48c156", "27e4fad98", "720e9304f", "811422471", "86091202a", "bcb784e7d", "d3e5d8950", "e4b1986b9"], "source_commits": ["05d605b6c", "20a48c156", "86091202a"], "source_entry_id": "15.16/changes/013", "db_id": "1a1ca89a6f8b8a26e2fdc5c3adffee40", "patch_ids": ["1d2a4559a8d7276dbf544ec3c3139d64", "810b6ce6361bfec35a8994954d64ee9a", "eed66ab080408c0e6d006c6433746be2"], "statement_hash": "33139139d6db8add9f0014229fa4e27308c3f7fb8f4aeed7bb35cbc7df54153a", "relations": [{"rule": 2, "type": "equivalent", "target": "24d2c263d61d870ad15e04e37b9be312", "evidence": {"same_day": true, "patch_ids": ["1d2a4559a8d7276dbf544ec3c3139d64", "810b6ce6361bfec35a8994954d64ee9a", "eed66ab080408c0e6d006c6433746be2"], "statement_hash": "33139139d6db8add9f0014229fa4e27308c3f7fb8f4aeed7bb35cbc7df54153a"}}, {"rule": 2, "type": "equivalent", "target": "577989fe6b9f208495ce6a7ab6b002c6", "evidence": {"same_day": true, "patch_ids": ["1d2a4559a8d7276dbf544ec3c3139d64", "810b6ce6361bfec35a8994954d64ee9a", "eed66ab080408c0e6d006c6433746be2"], "statement_hash": "33139139d6db8add9f0014229fa4e27308c3f7fb8f4aeed7bb35cbc7df54153a"}}, {"rule": 2, "type": "equivalent", "target": "7e9c59cfc9b17218ff9e506d4b425a25", "evidence": {"same_day": true, "patch_ids": ["1d2a4559a8d7276dbf544ec3c3139d64", "810b6ce6361bfec35a8994954d64ee9a", "eed66ab080408c0e6d006c6433746be2"], "statement_hash": "33139139d6db8add9f0014229fa4e27308c3f7fb8f4aeed7bb35cbc7df54153a"}}], "version": "15.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "577989fe6b9f208495ce6a7ab6b002c6", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Fix issues around in-place catalog updates", "evidence": {"same_day": true, "patch_ids": ["1d2a4559a8d7276dbf544ec3c3139d64", "810b6ce6361bfec35a8994954d64ee9a", "eed66ab080408c0e6d006c6433746be2"], "statement_hash": "33139139d6db8add9f0014229fa4e27308c3f7fb8f4aeed7bb35cbc7df54153a"}, "url": "/docs/compare/?release=17.8#17.8-3bb47161eed5f310", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "24d2c263d61d870ad15e04e37b9be312", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Fix issues around in-place catalog updates", "evidence": {"same_day": true, "patch_ids": ["1d2a4559a8d7276dbf544ec3c3139d64", "810b6ce6361bfec35a8994954d64ee9a", "eed66ab080408c0e6d006c6433746be2"], "statement_hash": "33139139d6db8add9f0014229fa4e27308c3f7fb8f4aeed7bb35cbc7df54153a"}, "url": "/docs/compare/?release=16.12#16.12-630512d5e807ea1f", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "7e9c59cfc9b17218ff9e506d4b425a25", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Fix issues around in-place catalog updates", "evidence": {"same_day": true, "patch_ids": ["1d2a4559a8d7276dbf544ec3c3139d64", "810b6ce6361bfec35a8994954d64ee9a", "eed66ab080408c0e6d006c6433746be2"], "statement_hash": "33139139d6db8add9f0014229fa4e27308c3f7fb8f4aeed7bb35cbc7df54153a"}, "url": "/docs/compare/?release=14.21#14.21-6a189e5adbc60f03", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-4db75c5b481234d4", "cves": [], "html": "Fix potential backend process crash at process exit due to trying to release a lock in an already-unmapped shared memory segment (Rahila Syed) §
", "text": "Fix potential backend process crash at process exit due to trying to release a lock in an already-unmapped shared memory segment (Rahila Syed) §", "title": "Fix potential backend process crash at process exit due to trying to release a lock in an already-unmapped shared memory segment", "commits": ["b926ff137"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "63b81fa5065c2e020e922ac54923eee3e2f9be4a6bd9102015edd704a3fffb9b", "section_path": ["Changes"], "commit_groups": [["1943ceb38", "4071fe900", "980b7c736", "9cbb1d21d", "b926ff137", "f6df78173"]], "identity_text": "Fix potential backend process crash at process exit due to trying to release a lock in an already-unmapped shared memory segment (Rahila Syed)", "commit_aliases": ["1943ceb38", "4071fe900", "980b7c736", "9cbb1d21d", "b926ff137", "f6df78173"], "source_commits": ["b926ff137"], "source_entry_id": "15.16/changes/014", "db_id": "125f7282ee77b2dbf96db553539c22c4", "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3", "relations": [{"rule": 2, "type": "equivalent", "target": "45af7190ae2808ef37392b8f701626cf", "evidence": {"same_day": true, "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3"}}, {"rule": 2, "type": "equivalent", "target": "5ad3db5c0edaa4934f3f9d9b4709c52d", "evidence": {"same_day": true, "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3"}}, {"rule": 2, "type": "equivalent", "target": "7be6eebc70de0b6a710a45541a4092f0", "evidence": {"same_day": true, "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3"}}, {"rule": 2, "type": "equivalent", "target": "d2811b8c558ee3336f69ce2dee648262", "evidence": {"same_day": true, "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3"}}], "version": "15.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "5ad3db5c0edaa4934f3f9d9b4709c52d", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Fix potential backend process crash at process exit due to trying to release a lock in an already-unmapped shared memory segment", "evidence": {"same_day": true, "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3"}, "url": "/docs/compare/?release=18.2#18.2-c5a2be58244ca433", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "d2811b8c558ee3336f69ce2dee648262", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Fix potential backend process crash at process exit due to trying to release a lock in an already-unmapped shared memory segment", "evidence": {"same_day": true, "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3"}, "url": "/docs/compare/?release=17.8#17.8-ff65f3935e08be00", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "7be6eebc70de0b6a710a45541a4092f0", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Fix potential backend process crash at process exit due to trying to release a lock in an already-unmapped shared memory segment", "evidence": {"same_day": true, "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3"}, "url": "/docs/compare/?release=16.12#16.12-a697dba42d12b45f", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "45af7190ae2808ef37392b8f701626cf", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Fix potential backend process crash at process exit due to trying to release a lock in an already-unmapped shared memory segment", "evidence": {"same_day": true, "patch_ids": ["126653f8f3297278586a3928c56e06f3"], "statement_hash": "92dcd4d1c3bd738dad9644948eb1cd6efd94bdefcd3219e424732f890c0bceb3"}, "url": "/docs/compare/?release=14.21#14.21-c6d749d8181b360c", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-1c33da61822d76af", "cves": [], "html": "Guard against incorrect truncation of the multixact log after a crash (Heikki Linnakangas) §
", "text": "Guard against incorrect truncation of the multixact log after a crash (Heikki Linnakangas) §", "title": "Guard against incorrect truncation of the multixact log after a crash", "commits": ["a563ac619"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "1505757b8ff66f4d38f412f7dd15d96ef05f4ff72d7c4fa1a778ae1d77bab589", "section_path": ["Changes"], "commit_groups": [["09532a78b", "102bdaa9b", "46be454ca", "a563ac619", "c7946e6f3", "d3ad4cef6"]], "identity_text": "Guard against incorrect truncation of the multixact log after a crash (Heikki Linnakangas)", "commit_aliases": ["09532a78b", "102bdaa9b", "46be454ca", "a563ac619", "c7946e6f3", "d3ad4cef6"], "source_commits": ["a563ac619"], "source_entry_id": "15.16/changes/015", "db_id": "98b43daf45e235647020ad11a022bebb", "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad", "relations": [{"rule": 2, "type": "equivalent", "target": "06c8d0231b48925fde45dbbe5447711a", "evidence": {"same_day": true, "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad"}}, {"rule": 2, "type": "equivalent", "target": "3a7694cde691f1c0a64647d256362d79", "evidence": {"same_day": true, "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad"}}, {"rule": 2, "type": "equivalent", "target": "423a226c0afa155ba2f8b3bf4d809b9b", "evidence": {"same_day": true, "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad"}}, {"rule": 2, "type": "equivalent", "target": "543d98a0d64e54acd061d5327cda0d92", "evidence": {"same_day": true, "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad"}}], "version": "15.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "3a7694cde691f1c0a64647d256362d79", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Guard against incorrect truncation of the multixact log after a crash", "evidence": {"same_day": true, "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad"}, "url": "/docs/compare/?release=18.2#18.2-8b23c352cad22240", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "423a226c0afa155ba2f8b3bf4d809b9b", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Guard against incorrect truncation of the multixact log after a crash", "evidence": {"same_day": true, "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad"}, "url": "/docs/compare/?release=17.8#17.8-9e854c237f5aabf9", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "543d98a0d64e54acd061d5327cda0d92", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Guard against incorrect truncation of the multixact log after a crash", "evidence": {"same_day": true, "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad"}, "url": "/docs/compare/?release=16.12#16.12-1dcc130cbed466e7", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "06c8d0231b48925fde45dbbe5447711a", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Guard against incorrect truncation of the multixact log after a crash", "evidence": {"same_day": true, "patch_ids": ["67a73a4872f6b3f005ad7fe4e9077027"], "statement_hash": "dfecdaac190eb4e172c44ceae68abad6d5cc283f60c6a947351bcef843a944ad"}, "url": "/docs/compare/?release=14.21#14.21-82a8e8c00098deab", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-cd833dd2d455a71f", "cves": [], "html": "Fix possibly mis-encoded result of pg_stat_get_backend_activity() (Chao Li) §
The shared-memory buffer holding a session's activity string can end with an incomplete multibyte character. Readers are supposed to truncate off any such incomplete character, but this function failed to do so.
", "text": "Fix possibly mis-encoded result of pg_stat_get_backend_activity() (Chao Li) § The shared-memory buffer holding a session's activity string can end with an incomplete multibyte character. Readers are supposed to truncate off any such incomplete character, but this function failed to do so.", "title": "Fix possibly mis-encoded result of pg_stat_get_backend_activity()", "commits": ["300575fe2"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "cc9a131807ced320c2d22b56b2952a0bd74de352445f0cf9b171a0fb07cbb780", "section_path": ["Changes"], "commit_groups": [["06907e864", "300575fe2", "36b8f4974", "52b27f585", "c48829ed8", "ea3524cff"]], "identity_text": "Fix possibly mis-encoded result of pg_stat_get_backend_activity() (Chao Li) The shared-memory buffer holding a session's activity string can end with an incomplete multibyte character. Readers are supposed to truncate off any such incomplete character, but this function failed to do so.", "commit_aliases": ["06907e864", "300575fe2", "36b8f4974", "52b27f585", "c48829ed8", "ea3524cff"], "source_commits": ["300575fe2"], "source_entry_id": "15.16/changes/016", "db_id": "c6e97abc5a7f6b7dd2f4f8bbf960d054", "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178", "relations": [{"rule": 2, "type": "equivalent", "target": "1d61f99b846c4ede8289346c443c6eab", "evidence": {"same_day": true, "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178"}}, {"rule": 2, "type": "equivalent", "target": "2011af15ea6d97b67e6182e61860c8c7", "evidence": {"same_day": true, "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178"}}, {"rule": 2, "type": "equivalent", "target": "3fc6fbb291fd58ddb3732e1040a55913", "evidence": {"same_day": true, "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178"}}, {"rule": 2, "type": "equivalent", "target": "962171149258cdfb98c25d6f7cda03e4", "evidence": {"same_day": true, "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178"}}], "version": "15.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2011af15ea6d97b67e6182e61860c8c7", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Fix possibly mis-encoded result of pg_stat_get_backend_activity()", "evidence": {"same_day": true, "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178"}, "url": "/docs/compare/?release=18.2#18.2-08c685de487e23d3", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "962171149258cdfb98c25d6f7cda03e4", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Fix possibly mis-encoded result of pg_stat_get_backend_activity()", "evidence": {"same_day": true, "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178"}, "url": "/docs/compare/?release=17.8#17.8-5b4587fee1692efc", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "3fc6fbb291fd58ddb3732e1040a55913", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Fix possibly mis-encoded result of pg_stat_get_backend_activity()", "evidence": {"same_day": true, "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178"}, "url": "/docs/compare/?release=16.12#16.12-5dda0d4807cb6225", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "1d61f99b846c4ede8289346c443c6eab", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Fix possibly mis-encoded result of pg_stat_get_backend_activity()", "evidence": {"same_day": true, "patch_ids": ["b809be4e7827182df22fb9f71f25cf1d"], "statement_hash": "18f9c2bfb3fe8f5033800a59729a09db060ed74ea247b46aee7ee09268737178"}, "url": "/docs/compare/?release=14.21#14.21-e2ab71f43353e5cd", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-c5eabf46f29ea686", "cves": [], "html": "Guard against recursive memory context logging (Fujii Masao) §
\nA constant flow of signals requesting memory context logging could cause recursive execution of the logging code, which in theory could lead to stack overflow.
", "text": "Guard against recursive memory context logging (Fujii Masao) § A constant flow of signals requesting memory context logging could cause recursive execution of the logging code, which in theory could lead to stack overflow.", "title": "Guard against recursive memory context logging", "commits": ["0fc2f533a"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "a13e14917c2ad443c1071a7424836caddac6b82a07e7e3f9b75d3cd15bd0a0a3", "section_path": ["Changes"], "commit_groups": [["0fc2f533a", "1a9a49699", "3853f6168", "699293d27", "b3ccb0a2c", "b863d8d87"]], "identity_text": "Guard against recursive memory context logging (Fujii Masao) A constant flow of signals requesting memory context logging could cause recursive execution of the logging code, which in theory could lead to stack overflow.", "commit_aliases": ["0fc2f533a", "1a9a49699", "3853f6168", "699293d27", "b3ccb0a2c", "b863d8d87"], "source_commits": ["0fc2f533a"], "source_entry_id": "15.16/changes/017", "db_id": "6911fcfb9b3a10c2cb527c328b7e80dd", "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4", "relations": [{"rule": 2, "type": "equivalent", "target": "69b5630e62f581864e385c3537959829", "evidence": {"same_day": true, "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4"}}, {"rule": 2, "type": "equivalent", "target": "76d6a4cdde5956fd5fdf83af6a0f6953", "evidence": {"same_day": true, "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4"}}, {"rule": 2, "type": "equivalent", "target": "cdc054743d9f7923ca54a8a0dd5eba4d", "evidence": {"same_day": true, "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4"}}, {"rule": 2, "type": "equivalent", "target": "e532d3e562a8bcd039083d7610c4fe02", "evidence": {"same_day": true, "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4"}}], "version": "15.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "e532d3e562a8bcd039083d7610c4fe02", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Guard against recursive memory context logging", "evidence": {"same_day": true, "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4"}, "url": "/docs/compare/?release=18.2#18.2-92cabc87c606add7", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "76d6a4cdde5956fd5fdf83af6a0f6953", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Guard against recursive memory context logging", "evidence": {"same_day": true, "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4"}, "url": "/docs/compare/?release=17.8#17.8-a1b611399d727246", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "cdc054743d9f7923ca54a8a0dd5eba4d", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Guard against recursive memory context logging", "evidence": {"same_day": true, "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4"}, "url": "/docs/compare/?release=16.12#16.12-2616fc2b052bb88f", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "69b5630e62f581864e385c3537959829", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Guard against recursive memory context logging", "evidence": {"same_day": true, "patch_ids": ["5f2e29ee0f0a335aba7ffbb8c5262c9e"], "statement_hash": "b5c2d3f4f692a615b47c23616523ca27bef0dcd03455868cfc0d756ea0575dd4"}, "url": "/docs/compare/?release=14.21#14.21-0397158066e277a7", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-d2b6dee5909338ef", "cves": [], "html": "Fix memory context usage when reinitializing a parallel execution context (Jakub Wartak, Jeevan Chalke) §
\nThis error could result in a crash due to a subsidiary data structure having a shorter lifespan than the parallel context. The problem is not known to be reachable using only core PostgreSQL, but we have reports of trouble in extensions.
", "text": "Fix memory context usage when reinitializing a parallel execution context (Jakub Wartak, Jeevan Chalke) § This error could result in a crash due to a subsidiary data structure having a shorter lifespan than the parallel context. The problem is not known to be reachable using only core PostgreSQL, but we have reports of trouble in extensions.", "title": "Fix memory context usage when reinitializing a parallel execution context", "commits": ["bd2726d3e"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "0fee6af680f7f005af308eb548f7e49e6e0e76d974fede362ec64a4dac884e3b", "section_path": ["Changes"], "commit_groups": [["12c2f843c", "1d0fc2499", "1d9f7fbba", "57df5ab80", "bd2726d3e", "f1a6e622b"]], "identity_text": "Fix memory context usage when reinitializing a parallel execution context (Jakub Wartak, Jeevan Chalke) This error could result in a crash due to a subsidiary data structure having a shorter lifespan than the parallel context. The problem is not known to be reachable using only core PostgreSQL, but we have reports of trouble in extensions.", "commit_aliases": ["12c2f843c", "1d0fc2499", "1d9f7fbba", "57df5ab80", "bd2726d3e", "f1a6e622b"], "source_commits": ["bd2726d3e"], "source_entry_id": "15.16/changes/018", "db_id": "82f0fec30baf25cedac6f47fedd86a1a", "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0", "relations": [{"rule": 2, "type": "equivalent", "target": "0e538a4d4cac5aac8cab0d86cc46e6d8", "evidence": {"same_day": true, "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0"}}, {"rule": 2, "type": "equivalent", "target": "770932eb6650d49472c43e2db5c83969", "evidence": {"same_day": true, "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0"}}, {"rule": 2, "type": "equivalent", "target": "a0538505db5e86d813d403a8571068b8", "evidence": {"same_day": true, "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0"}}, {"rule": 2, "type": "equivalent", "target": "c0e0fccdb1ff80df5a7c450903b3c742", "evidence": {"same_day": true, "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0"}}], "version": "15.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "a0538505db5e86d813d403a8571068b8", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Fix memory context usage when reinitializing a parallel execution context", "evidence": {"same_day": true, "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0"}, "url": "/docs/compare/?release=18.2#18.2-f56daebc6196999a", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "c0e0fccdb1ff80df5a7c450903b3c742", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Fix memory context usage when reinitializing a parallel execution context", "evidence": {"same_day": true, "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0"}, "url": "/docs/compare/?release=17.8#17.8-cdcf22c5f5200747", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "0e538a4d4cac5aac8cab0d86cc46e6d8", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Fix memory context usage when reinitializing a parallel execution context", "evidence": {"same_day": true, "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0"}, "url": "/docs/compare/?release=16.12#16.12-9d7bd150ce599d54", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "770932eb6650d49472c43e2db5c83969", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Fix memory context usage when reinitializing a parallel execution context", "evidence": {"same_day": true, "patch_ids": ["4c076010d0ab56e908326be07c1b73c6"], "statement_hash": "b3c3fe87f6d12f96eb766c99214c419b7d35f4a67646f0e2ac1a8abac3576cb0"}, "url": "/docs/compare/?release=14.21#14.21-06477385d1974f88", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-639bc1c588a62efb", "cves": [], "html": "Set next multixid's offset when creating a new multixid, to remove the wait loop that was needed in corner cases (Andrey Borodin) § §
\nThe previous logic could get stuck waiting for an update that would never occur.
", "text": "Set next multixid's offset when creating a new multixid, to remove the wait loop that was needed in corner cases (Andrey Borodin) § § The previous logic could get stuck waiting for an update that would never occur.", "title": "Set next multixid's offset when creating a new multixid, to remove the wait loop that was needed in corner cases", "commits": ["8cfb174a6", "b9a02b978"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "1e99c477ea99114a14a182497cd175d0a2c7bfab852a922e553770a22184a216", "section_path": ["Changes"], "commit_groups": [["02ba5e3be", "489695554", "4d689a176", "4d936c3ff", "b9a02b978", "cad40cec2"], ["635166913", "789d65364", "81416e101", "8ba61bc06", "8cfb174a6", "e46041fd9"]], "identity_text": "Set next multixid's offset when creating a new multixid, to remove the wait loop that was needed in corner cases (Andrey Borodin) The previous logic could get stuck waiting for an update that would never occur.", "commit_aliases": ["02ba5e3be", "489695554", "4d689a176", "4d936c3ff", "635166913", "789d65364", "81416e101", "8ba61bc06", "8cfb174a6", "b9a02b978", "cad40cec2", "e46041fd9"], "source_commits": ["8cfb174a6", "b9a02b978"], "source_entry_id": "15.16/changes/019", "db_id": "2b4c07606e0901ac70bb0fbb4680ebbe", "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d", "relations": [{"rule": 2, "type": "equivalent", "target": "1d8beb2475d7ec3ee5619d442f62f4e4", "evidence": {"same_day": true, "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d"}}, {"rule": 2, "type": "equivalent", "target": "9d39be361a73eeb011b1508852d458c4", "evidence": {"same_day": true, "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d"}}, {"rule": 2, "type": "equivalent", "target": "df073012abdc28126571ebecafb9c308", "evidence": {"same_day": true, "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d"}}, {"rule": 2, "type": "equivalent", "target": "fff819d80d05a70e4ebf82ab7f9c951a", "evidence": {"same_day": true, "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d"}}], "version": "15.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "9d39be361a73eeb011b1508852d458c4", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Set next multixid's offset when creating a new multixid, to remove the wait loop that was needed in corner cases", "evidence": {"same_day": true, "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d"}, "url": "/docs/compare/?release=18.2#18.2-0eb611cc5bc18380", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "df073012abdc28126571ebecafb9c308", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Set next multixid's offset when creating a new multixid, to remove the wait loop that was needed in corner cases", "evidence": {"same_day": true, "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d"}, "url": "/docs/compare/?release=17.8#17.8-351e263e26b0031c", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "1d8beb2475d7ec3ee5619d442f62f4e4", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Set next multixid's offset when creating a new multixid, to remove the wait loop that was needed in corner cases", "evidence": {"same_day": true, "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d"}, "url": "/docs/compare/?release=16.12#16.12-90168bc8332f7a84", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "fff819d80d05a70e4ebf82ab7f9c951a", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Set next multixid's offset when creating a new multixid, to remove the wait loop that was needed in corner cases", "evidence": {"same_day": true, "patch_ids": ["7a935cadcf10c6b2317e3231e31323b6", "ee608729a6ebedc95a84b653d7e6f795"], "statement_hash": "3820414d3ddce5f6a358db922abd2d2d57a70d8990ca5c41a3b91f78a7e3261d"}, "url": "/docs/compare/?release=14.21#14.21-fc1711f590b7a7c5", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-fdb06078edbce9e9", "cves": [], "html": "Avoid rewriting data-modifying CTEs more than once (Bernice Southey, Dean Rasheed) §
\nFormerly, when updating an auto-updatable view or a relation with rules, if the original query had any data-modifying CTEs, the rewriter would rewrite those CTEs multiple times due to recursion. This was inefficient and could produce false errors if a CTE included an update of an always-generated column.
", "text": "Avoid rewriting data-modifying CTEs more than once (Bernice Southey, Dean Rasheed) § Formerly, when updating an auto-updatable view or a relation with rules, if the original query had any data-modifying CTEs, the rewriter would rewrite those CTEs multiple times due to recursion. This was inefficient and could produce false errors if a CTE included an update of an always-generated column.", "title": "Avoid rewriting data-modifying CTEs more than once", "commits": ["134a8ee22"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "829592d3da46613790fbc69ac2ffd62344d1a544b9f8fec96936df6ad3696c27", "section_path": ["Changes"], "commit_groups": [["134a8ee22", "2d5b97b8c", "3881561d7", "4d288e33b", "b880d9a02", "c09096503"]], "identity_text": "Avoid rewriting data-modifying CTEs more than once (Bernice Southey, Dean Rasheed) Formerly, when updating an auto-updatable view or a relation with rules, if the original query had any data-modifying CTEs, the rewriter would rewrite those CTEs multiple times due to recursion. This was inefficient and could produce false errors if a CTE included an update of an always-generated column.", "commit_aliases": ["134a8ee22", "2d5b97b8c", "3881561d7", "4d288e33b", "b880d9a02", "c09096503"], "source_commits": ["134a8ee22"], "source_entry_id": "15.16/changes/020", "db_id": "fa9d76713707441eef7a725233377166", "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb", "relations": [{"rule": 2, "type": "equivalent", "target": "6e6c8a0f6889fba17b9d4ea6308a8d7a", "evidence": {"same_day": true, "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb"}}, {"rule": 2, "type": "equivalent", "target": "b1252119d1b5ac0ac5230ba9b7fb844b", "evidence": {"same_day": true, "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb"}}, {"rule": 2, "type": "equivalent", "target": "c9710e1b97bbf384a5536e25246c2c1e", "evidence": {"same_day": true, "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb"}}, {"rule": 2, "type": "equivalent", "target": "f467408bfd650872bf1654f4ee4ec70d", "evidence": {"same_day": true, "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb"}}], "version": "15.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b1252119d1b5ac0ac5230ba9b7fb844b", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Avoid rewriting data-modifying CTEs more than once", "evidence": {"same_day": true, "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb"}, "url": "/docs/compare/?release=18.2#18.2-598e6b46a303e445", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "f467408bfd650872bf1654f4ee4ec70d", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Avoid rewriting data-modifying CTEs more than once", "evidence": {"same_day": true, "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb"}, "url": "/docs/compare/?release=17.8#17.8-fed0bc33b201283d", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "c9710e1b97bbf384a5536e25246c2c1e", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Avoid rewriting data-modifying CTEs more than once", "evidence": {"same_day": true, "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb"}, "url": "/docs/compare/?release=16.12#16.12-806ed942f9c5fd64", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "6e6c8a0f6889fba17b9d4ea6308a8d7a", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Avoid rewriting data-modifying CTEs more than once", "evidence": {"same_day": true, "patch_ids": ["e0f79f9c321f69bef485ae997c61c414"], "statement_hash": "45d7e282599aa005c97ba4f77c0f61900b8c96a1633aa3b113857a26515155bb"}, "url": "/docs/compare/?release=14.21#14.21-7e5820de57d7faff", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-61074b4b2db3b9f8", "cves": [], "html": "Fail recovery if WAL does not exist back to the redo point indicated by the checkpoint record (Nitin Jadhav) §
\nAdd an explicit check for this before starting recovery, so that no harm is done and a useful error message is provided. Previously, recovery might crash or corrupt the database in this situation.
", "text": "Fail recovery if WAL does not exist back to the redo point indicated by the checkpoint record (Nitin Jadhav) § Add an explicit check for this before starting recovery, so that no harm is done and a useful error message is provided. Previously, recovery might crash or corrupt the database in this situation.", "title": "Fail recovery if WAL does not exist back to the redo point indicated by the checkpoint record", "commits": ["95ef6f490"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "84f67e887930c4401bfaac9db37b63623a9ccf18a8e16715e17cf78e5afffa86", "section_path": ["Changes"], "commit_groups": [["14161bca4", "1aa57e9ed", "68ebdf2b0", "95ef6f490", "dc7c77f82", "f5927da4f"]], "identity_text": "Fail recovery if WAL does not exist back to the redo point indicated by the checkpoint record (Nitin Jadhav) Add an explicit check for this before starting recovery, so that no harm is done and a useful error message is provided. Previously, recovery might crash or corrupt the database in this situation.", "commit_aliases": ["14161bca4", "1aa57e9ed", "68ebdf2b0", "95ef6f490", "dc7c77f82", "f5927da4f"], "source_commits": ["95ef6f490"], "source_entry_id": "15.16/changes/021", "db_id": "ea5f140766dc7aa68dd175c861036247", "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034", "relations": [{"rule": 2, "type": "equivalent", "target": "011195db7fe270680db938124518987b", "evidence": {"same_day": true, "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034"}}, {"rule": 2, "type": "equivalent", "target": "3f4035b04c1c0e9ba08acef72e76fc91", "evidence": {"same_day": true, "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034"}}, {"rule": 2, "type": "equivalent", "target": "7e009c5e3ee2635f5a3f2d6750f1a823", "evidence": {"same_day": true, "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034"}}, {"rule": 2, "type": "equivalent", "target": "afebd143b96e516829ea82f80f213765", "evidence": {"same_day": true, "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034"}}], "version": "15.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "afebd143b96e516829ea82f80f213765", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Fail recovery if WAL does not exist back to the redo point indicated by the checkpoint record", "evidence": {"same_day": true, "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034"}, "url": "/docs/compare/?release=18.2#18.2-48e29718af30085d", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "3f4035b04c1c0e9ba08acef72e76fc91", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Fail recovery if WAL does not exist back to the redo point indicated by the checkpoint record", "evidence": {"same_day": true, "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034"}, "url": "/docs/compare/?release=17.8#17.8-3d4d2474ea729f43", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "7e009c5e3ee2635f5a3f2d6750f1a823", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Fail recovery if WAL does not exist back to the redo point indicated by the checkpoint record", "evidence": {"same_day": true, "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034"}, "url": "/docs/compare/?release=16.12#16.12-ac8c469b0c901db5", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "011195db7fe270680db938124518987b", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Fail recovery if WAL does not exist back to the redo point indicated by the checkpoint record", "evidence": {"same_day": true, "patch_ids": ["4b87107464945d5170bed63f81ff3790"], "statement_hash": "3acaee6f8628ca0f43630afaa8799cc5ced91cfb215bf493f91ad515f4af1034"}, "url": "/docs/compare/?release=14.21#14.21-c97498907e799420", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-a0b138a134556f43", "cves": [], "html": "Avoid scribbling on the source query tree during ALTER PUBLICATION (Sunil S) §
This error had the visible effect that an event trigger fired for the query would see only the first publish option, even if several had been specified. If such a query were set up as a prepared statement, re-executions would misbehave too.
Pass connection options specified in CREATE SUBSCRIPTION ... CONNECTION to the publisher's walsender (Fujii Masao) §
Before this fix, the options connection option (if any) was ignored, thus for example preventing setting custom server parameter values in the walsender session. It was intended for that to work, and it did work before refactoring in PostgreSQL version 15 broke it, so restore the previous behavior.
Prevent invalidation of newly created or newly synced replication slots (Zhijie Hou) §
\nA race condition with a concurrent checkpoint could allow WAL to be removed that is needed by the replication slot, causing the slot to immediately get marked invalid.
", "text": "Prevent invalidation of newly created or newly synced replication slots (Zhijie Hou) § A race condition with a concurrent checkpoint could allow WAL to be removed that is needed by the replication slot, causing the slot to immediately get marked invalid.", "title": "Prevent invalidation of newly created or newly synced replication slots", "commits": ["aae05622a"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "ff02422aa9db1fbec836f6b50bfcef0a7afbbbe64f40c64c45452ce4848a0962", "section_path": ["Changes"], "commit_groups": [["006dd4b2e", "24cce33c3", "3510ebeb0", "7406df605", "aae05622a", "d3ceb2084"], ["1c60f7236", "3a98f989e", "9649f1adf"], ["3243c0177", "851f6649c", "919c9fa13"]], "identity_text": "Prevent invalidation of newly created or newly synced replication slots (Zhijie Hou) A race condition with a concurrent checkpoint could allow WAL to be removed that is needed by the replication slot, causing the slot to immediately get marked invalid.", "commit_aliases": ["006dd4b2e", "1c60f7236", "24cce33c3", "3243c0177", "3510ebeb0", "3a98f989e", "7406df605", "851f6649c", "919c9fa13", "9649f1adf", "aae05622a", "d3ceb2084"], "source_commits": ["3a98f989e", "851f6649c", "aae05622a"], "source_entry_id": "15.16/changes/024", "db_id": "54b2a393bc7cb86ab19eb7c660bb2004", "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9", "relations": [{"rule": 2, "type": "equivalent", "target": "2e44c2dcd00ca731067ba5c1a7a9a31c", "evidence": {"same_day": true, "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9"}}, {"rule": 2, "type": "equivalent", "target": "7045b64c3c70e172ffa2ef8c1ae90896", "evidence": {"same_day": true, "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9"}}, {"rule": 2, "type": "equivalent", "target": "cb75695174eb56fb419b9a98e09580cc", "evidence": {"same_day": true, "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9"}}, {"rule": 2, "type": "equivalent", "target": "d1a860dc00a9dc81973d46ece96b0748", "evidence": {"same_day": true, "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9"}}], "version": "15.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "cb75695174eb56fb419b9a98e09580cc", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Prevent invalidation of newly created or newly synced replication slots", "evidence": {"same_day": true, "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9"}, "url": "/docs/compare/?release=18.2#18.2-882569f761ef0610", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "2e44c2dcd00ca731067ba5c1a7a9a31c", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Prevent invalidation of newly created or newly synced replication slots", "evidence": {"same_day": true, "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9"}, "url": "/docs/compare/?release=17.8#17.8-2ab0d69c3c8683d7", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "7045b64c3c70e172ffa2ef8c1ae90896", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Prevent invalidation of newly created or newly synced replication slots", "evidence": {"same_day": true, "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9"}, "url": "/docs/compare/?release=16.12#16.12-2c0a03a7293625cd", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "d1a860dc00a9dc81973d46ece96b0748", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Prevent invalidation of newly created or newly synced replication slots", "evidence": {"same_day": true, "patch_ids": ["52eeca007f2cc833bd086bea5398b6dd", "e27e8fc7ff675146f1b638a98637021e", "fd534fc2f99acb10d2ff04bf0f822f81"], "statement_hash": "a7634872b97f0a43a006c3dc4f9851bc65d8af6cd588b4009553b843b6ae22d9"}, "url": "/docs/compare/?release=14.21#14.21-39c6194420a5bf2b", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-a49381efba5b11d0", "cves": [], "html": "Fix race condition in computing a replication slot's required xmin (Zhijie Hou) §
\nThis could lead to the error “cannot build an initial slot snapshot as oldest safe xid follows snapshot's xmin”.
", "text": "Fix race condition in computing a replication slot's required xmin (Zhijie Hou) § This could lead to the error “cannot build an initial slot snapshot as oldest safe xid follows snapshot's xmin”.", "title": "Fix race condition in computing a replication slot's required xmin", "commits": ["fa557d300"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "059fc22583de086db2dbbd557d3d126545de203019cb4910bb1521509d239b76", "section_path": ["Changes"], "commit_groups": [["123b851ab", "2a5225b99", "57048d6e1", "821466722", "fa557d300", "fd7c86cfa"]], "identity_text": "Fix race condition in computing a replication slot's required xmin (Zhijie Hou) This could lead to the error cannot build an initial slot snapshot as oldest safe xid follows snapshot's xmin.", "commit_aliases": ["123b851ab", "2a5225b99", "57048d6e1", "821466722", "fa557d300", "fd7c86cfa"], "source_commits": ["fa557d300"], "source_entry_id": "15.16/changes/025", "db_id": "8dfd1735c21afd64306b7ba15b0a34a0", "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369", "relations": [{"rule": 2, "type": "equivalent", "target": "5b75bdc74484bae30e1e7fdc965c9335", "evidence": {"same_day": true, "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369"}}, {"rule": 2, "type": "equivalent", "target": "669fa902ee7eb1553fc960938aa0101f", "evidence": {"same_day": true, "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369"}}, {"rule": 2, "type": "equivalent", "target": "97d0bb3c79bb34e32cf7ac9c088a6cc5", "evidence": {"same_day": true, "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369"}}, {"rule": 2, "type": "equivalent", "target": "ed4968909e48309a69552757b02c2ad7", "evidence": {"same_day": true, "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369"}}], "version": "15.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "669fa902ee7eb1553fc960938aa0101f", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Fix race condition in computing a replication slot's required xmin", "evidence": {"same_day": true, "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369"}, "url": "/docs/compare/?release=18.2#18.2-7907d70dfbb36d36", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "5b75bdc74484bae30e1e7fdc965c9335", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Fix race condition in computing a replication slot's required xmin", "evidence": {"same_day": true, "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369"}, "url": "/docs/compare/?release=17.8#17.8-73bf563728deef29", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "97d0bb3c79bb34e32cf7ac9c088a6cc5", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Fix race condition in computing a replication slot's required xmin", "evidence": {"same_day": true, "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369"}, "url": "/docs/compare/?release=16.12#16.12-dc6c53055853a66a", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "ed4968909e48309a69552757b02c2ad7", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Fix race condition in computing a replication slot's required xmin", "evidence": {"same_day": true, "patch_ids": ["c967ad30d8508306bc9949d6c7504333"], "statement_hash": "8dd9f0879870a4299a9d543db5674a7348ed2b9228376a7028ea153ac3afb369"}, "url": "/docs/compare/?release=14.21#14.21-e0ac9a9b715f44f3", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-72eafe5fdeaf4699", "cves": [], "html": "During initial synchronization of a logical replication subscription, commit the addition of a pg_replication_origin entry before starting to copy data (Zhijie Hou) §
Previously, if the copy step failed, the new pg_replication_origin entry would be lost due to transaction rollback. This led to inconsistent state in shared memory.
Fix possible failure with “unexpected data beyond EOF” during restart of a streaming replica server (Anthonin Bonnefoy) §
", "text": "Fix possible failure with “unexpected data beyond EOF” during restart of a streaming replica server (Anthonin Bonnefoy) §", "title": "Fix possible failure with “unexpected data beyond EOF” during restart of a streaming replica server", "commits": ["ef8465588"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "d9c2373dccafe5269cb1677a3dfbe2b86b931da44d2d1be3f34d3a16b0f523de", "section_path": ["Changes"], "commit_groups": [["23b25586d", "2514f1c77", "9ed411e08", "a2eeb04f3", "c3770181c", "ef8465588"]], "identity_text": "Fix possible failure with unexpected data beyond EOF during restart of a streaming replica server (Anthonin Bonnefoy)", "commit_aliases": ["23b25586d", "2514f1c77", "9ed411e08", "a2eeb04f3", "c3770181c", "ef8465588"], "source_commits": ["ef8465588"], "source_entry_id": "15.16/changes/027", "db_id": "668c3f03c522a5db8d076f179e064027", "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab", "relations": [{"rule": 2, "type": "equivalent", "target": "06594efa4344da118700b1c48988f5e4", "evidence": {"same_day": true, "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab"}}, {"rule": 2, "type": "equivalent", "target": "8d924571fb5bee478b47c49ff89fa7f5", "evidence": {"same_day": true, "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab"}}, {"rule": 2, "type": "equivalent", "target": "a321a63cf72d9e7f3afd2ff1e5a2c814", "evidence": {"same_day": true, "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab"}}, {"rule": 2, "type": "equivalent", "target": "a79b7d220801497e224783e6369f7957", "evidence": {"same_day": true, "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab"}}], "version": "15.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "06594efa4344da118700b1c48988f5e4", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Fix possible failure with “unexpected data beyond EOF” during restart of a streaming replica server", "evidence": {"same_day": true, "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab"}, "url": "/docs/compare/?release=18.2#18.2-c52d288613257e1b", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "a79b7d220801497e224783e6369f7957", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Fix possible failure with “unexpected data beyond EOF” during restart of a streaming replica server", "evidence": {"same_day": true, "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab"}, "url": "/docs/compare/?release=17.8#17.8-ca1e290b0cb2dd09", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "a321a63cf72d9e7f3afd2ff1e5a2c814", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Fix possible failure with “unexpected data beyond EOF” during restart of a streaming replica server", "evidence": {"same_day": true, "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab"}, "url": "/docs/compare/?release=16.12#16.12-ce78056abed06c7f", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "8d924571fb5bee478b47c49ff89fa7f5", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Fix possible failure with “unexpected data beyond EOF” during restart of a streaming replica server", "evidence": {"same_day": true, "patch_ids": ["5162c78b0f9af44ee53c5daf07030ba8"], "statement_hash": "6b8e19ac39d2a905a6b06a59a41de464bc6a62cc815b31c6e858ae96438db9ab"}, "url": "/docs/compare/?release=14.21#14.21-56f9977d411ed1a0", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-ed7528c4bca01a17", "cves": [], "html": "Fix erroneous tracking of column position when parsing partition range bounds (myzhen) §
\nThis could, for example, lead to the wrong column name being cited in error messages about casting partition bound values to the column's data type.
", "text": "Fix erroneous tracking of column position when parsing partition range bounds (myzhen) § This could, for example, lead to the wrong column name being cited in error messages about casting partition bound values to the column's data type.", "title": "Fix erroneous tracking of column position when parsing partition range bounds", "commits": ["3ad05640b"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "99d1b0e3dce6037793a1ecabe7b47fabee6d1a6f245bff3809e978a249ec4075", "section_path": ["Changes"], "commit_groups": [["349107537", "3ad05640b", "821c4d27b", "84b787ae6", "a65995947", "c35e5dd9a"]], "identity_text": "Fix erroneous tracking of column position when parsing partition range bounds (myzhen) This could, for example, lead to the wrong column name being cited in error messages about casting partition bound values to the column's data type.", "commit_aliases": ["349107537", "3ad05640b", "821c4d27b", "84b787ae6", "a65995947", "c35e5dd9a"], "source_commits": ["3ad05640b"], "source_entry_id": "15.16/changes/028", "db_id": "775ee6e8b3e233efe9c85fc527d0a5d4", "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232", "relations": [{"rule": 2, "type": "equivalent", "target": "3d999c9c39b345cf00d6c149f77369bc", "evidence": {"same_day": true, "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232"}}, {"rule": 2, "type": "equivalent", "target": "8da33c76c87cf129799d93a7efd47d96", "evidence": {"same_day": true, "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232"}}, {"rule": 2, "type": "equivalent", "target": "bb4e430870bc5f4909df899b3e4e6a47", "evidence": {"same_day": true, "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232"}}, {"rule": 2, "type": "equivalent", "target": "bcd807761d1a951aa85d661bf8df019c", "evidence": {"same_day": true, "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232"}}], "version": "15.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "bcd807761d1a951aa85d661bf8df019c", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Fix erroneous tracking of column position when parsing partition range bounds", "evidence": {"same_day": true, "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232"}, "url": "/docs/compare/?release=18.2#18.2-3915ae13b44752be", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "3d999c9c39b345cf00d6c149f77369bc", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Fix erroneous tracking of column position when parsing partition range bounds", "evidence": {"same_day": true, "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232"}, "url": "/docs/compare/?release=17.8#17.8-1ae71997df1c5c19", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "bb4e430870bc5f4909df899b3e4e6a47", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Fix erroneous tracking of column position when parsing partition range bounds", "evidence": {"same_day": true, "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232"}, "url": "/docs/compare/?release=16.12#16.12-cf6cf28e524760ac", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "8da33c76c87cf129799d93a7efd47d96", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Fix erroneous tracking of column position when parsing partition range bounds", "evidence": {"same_day": true, "patch_ids": ["6f0c6912e975c2e11453b9af7373ff2b"], "statement_hash": "99c55def0f9f50d97f55530e56d1c92347af0e9dedfe788a482bbfd2a5b86232"}, "url": "/docs/compare/?release=14.21#14.21-cd4c9b00fed268c0", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-3b76c2a636f3fe46", "cves": [], "html": "Fix assorted minor errors in error messages (Man Zeng, Tianchen Zhang) § § §
\nFor example, an error report about mismatched timeline number in a backup manifest showed the starting timeline number where it meant to show the ending timeline number.
", "text": "Fix assorted minor errors in error messages (Man Zeng, Tianchen Zhang) § § § For example, an error report about mismatched timeline number in a backup manifest showed the starting timeline number where it meant to show the ending timeline number.", "title": "Fix assorted minor errors in error messages", "commits": ["4ec943f7d", "9dcd0b3de", "fbf8df580"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "6d40c379eb4f3f89941eded9fade20c6bae9e7278a1c4a73ca79cabc7b62df71", "section_path": ["Changes"], "commit_groups": [["05ef2371a", "69ee81932", "6bca4b50d", "e8fd6c9fd", "f1dc7a5b7", "fbf8df580"], ["1653ce523", "3e7bb39df", "5449fd261", "9dcd0b3de", "a7bdbbada", "cff2ef984"], ["263af458e", "2ca4464b6", "c8ec74713"], ["4ec943f7d", "67ad4387b", "74a116a79", "977a17a3e", "acfa422c3", "d32e17160"], ["5995135f1", "a9afa021e", "ab61f0087"]], "identity_text": "Fix assorted minor errors in error messages (Man Zeng, Tianchen Zhang) For example, an error report about mismatched timeline number in a backup manifest showed the starting timeline number where it meant to show the ending timeline number.", "commit_aliases": ["05ef2371a", "1653ce523", "263af458e", "2ca4464b6", "3e7bb39df", "4ec943f7d", "5449fd261", "5995135f1", "67ad4387b", "69ee81932", "6bca4b50d", "74a116a79", "977a17a3e", "9dcd0b3de", "a7bdbbada", "a9afa021e", "ab61f0087", "acfa422c3", "c8ec74713", "cff2ef984", "d32e17160", "e8fd6c9fd", "f1dc7a5b7", "fbf8df580"], "source_commits": ["4ec943f7d", "9dcd0b3de", "a9afa021e", "c8ec74713", "fbf8df580"], "source_entry_id": "15.16/changes/029", "db_id": "6391fdf7551cb6b17994c91b76215a9f", "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737", "relations": [{"rule": 2, "type": "equivalent", "target": "03e8508ea8a410388767d947c24e8eb3", "evidence": {"same_day": true, "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737"}}, {"rule": 2, "type": "equivalent", "target": "040254b8395148f9ed2820a7a9e7de75", "evidence": {"same_day": true, "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737"}}, {"rule": 2, "type": "equivalent", "target": "c28d793705797c568ae351065c8bf92d", "evidence": {"same_day": true, "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737"}}, {"rule": 2, "type": "equivalent", "target": "e4eecf733b283aee3b3d1c824dbc8e27", "evidence": {"same_day": true, "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737"}}], "version": "15.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c28d793705797c568ae351065c8bf92d", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Fix assorted minor errors in error messages", "evidence": {"same_day": true, "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737"}, "url": "/docs/compare/?release=18.2#18.2-2eb9c2c4100a1830", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "040254b8395148f9ed2820a7a9e7de75", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Fix assorted minor errors in error messages", "evidence": {"same_day": true, "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737"}, "url": "/docs/compare/?release=17.8#17.8-4eafc20a792cccfc", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "e4eecf733b283aee3b3d1c824dbc8e27", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Fix assorted minor errors in error messages", "evidence": {"same_day": true, "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737"}, "url": "/docs/compare/?release=16.12#16.12-3849a6578b12c6fe", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "03e8508ea8a410388767d947c24e8eb3", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Fix assorted minor errors in error messages", "evidence": {"same_day": true, "patch_ids": ["1b2d3003a616272db51c764aca05446f", "9747f7cd321d1b9a8c5ab680817d174b", "d322434f9f1579628716983e1ddfa411", "dafc2603cafe575939465f2fd551a6ac", "e9fdf560cb4a79421801e80c5b2933b7"], "statement_hash": "1c12bc1b49de92034a5abdd2caee35fcf65ab113a875838de01715e754830737"}, "url": "/docs/compare/?release=14.21#14.21-2f6c908c2dcee449", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-7077db49018d55b0", "cves": [], "html": "Fix failure to perform function inlining when doing JIT compilation with LLVM version 17 or later (Anthonin Bonnefoy) §
", "text": "Fix failure to perform function inlining when doing JIT compilation with LLVM version 17 or later (Anthonin Bonnefoy) §", "title": "Fix failure to perform function inlining when doing JIT compilation with LLVM version 17 or later", "commits": ["cbdd09ae1"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "012b562ccbbc031ef42ef1a9fa7a20aee6925e74a90edd2b5c22b954d555d531", "section_path": ["Changes"], "commit_groups": [["7600dc79c", "cbdd09ae1", "d0bb0e5b3", "de8081c30", "e5d99b4d9", "f1c6b153c"]], "identity_text": "Fix failure to perform function inlining when doing JIT compilation with LLVM version 17 or later (Anthonin Bonnefoy)", "commit_aliases": ["7600dc79c", "cbdd09ae1", "d0bb0e5b3", "de8081c30", "e5d99b4d9", "f1c6b153c"], "source_commits": ["cbdd09ae1"], "source_entry_id": "15.16/changes/030", "db_id": "da5340b311cf457b0c8052e7119f6c5c", "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af", "relations": [{"rule": 2, "type": "equivalent", "target": "1d826bf62f1c8707e84a00b08bca6cc2", "evidence": {"same_day": true, "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af"}}, {"rule": 2, "type": "equivalent", "target": "23db3b0771d0b80deb078c18239bf311", "evidence": {"same_day": true, "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af"}}, {"rule": 2, "type": "equivalent", "target": "41aa0fa812e386b3bf111e16e5ca824b", "evidence": {"same_day": true, "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af"}}, {"rule": 2, "type": "equivalent", "target": "6c8a23f42fdf36b27a5c63a60ef638ee", "evidence": {"same_day": true, "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af"}}], "version": "15.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "6c8a23f42fdf36b27a5c63a60ef638ee", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Fix failure to perform function inlining when doing JIT compilation with LLVM version 17 or later", "evidence": {"same_day": true, "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af"}, "url": "/docs/compare/?release=18.2#18.2-53f3b7ffe4f6fe06", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "23db3b0771d0b80deb078c18239bf311", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Fix failure to perform function inlining when doing JIT compilation with LLVM version 17 or later", "evidence": {"same_day": true, "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af"}, "url": "/docs/compare/?release=17.8#17.8-c185802f4eacb2ea", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "1d826bf62f1c8707e84a00b08bca6cc2", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Fix failure to perform function inlining when doing JIT compilation with LLVM version 17 or later", "evidence": {"same_day": true, "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af"}, "url": "/docs/compare/?release=16.12#16.12-e61e367302b48095", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "41aa0fa812e386b3bf111e16e5ca824b", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Fix failure to perform function inlining when doing JIT compilation with LLVM version 17 or later", "evidence": {"same_day": true, "patch_ids": ["5add9e288aea8ead5625b1ab17f4b389"], "statement_hash": "d9b663cb80004c186d8a4f9af93bb5b74dc9a0534dcc279ee72325534d3c24af"}, "url": "/docs/compare/?release=14.21#14.21-c9d25ce6f3b8c109", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-1709d5e654f518fa", "cves": [], "html": "Adjust our JIT code to work with LLVM 21 (Holger Hoffstätte) §
\nThe previous coding failed to compile on aarch64 machines.
", "text": "Adjust our JIT code to work with LLVM 21 (Holger Hoffstätte) § The previous coding failed to compile on aarch64 machines.", "title": "Adjust our JIT code to work with LLVM 21", "commits": ["55164852d"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "10c0e48ec50bb536608a51e64c26ce44746466d5112fedb7dd1de13a4e663598", "section_path": ["Changes"], "commit_groups": [["035a1f5ac", "0dceba21d", "55164852d", "600acd34b", "60215eae7", "912cfa314"]], "identity_text": "Adjust our JIT code to work with LLVM 21 (Holger Hoffstätte) The previous coding failed to compile on aarch64 machines.", "commit_aliases": ["035a1f5ac", "0dceba21d", "55164852d", "600acd34b", "60215eae7", "912cfa314"], "source_commits": ["55164852d"], "source_entry_id": "15.16/changes/031", "db_id": "084e13baf0a1aaa1b6831e50a2e8b014", "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc", "relations": [{"rule": 2, "type": "equivalent", "target": "51e665bd2f8466b41d80cf0223c7e413", "evidence": {"same_day": true, "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc"}}, {"rule": 2, "type": "equivalent", "target": "c7ea32ba825d2c7140b0017b02f1a3ec", "evidence": {"same_day": true, "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc"}}, {"rule": 2, "type": "equivalent", "target": "cff57c5be469c947c3ffe128e6ba5e35", "evidence": {"same_day": true, "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc"}}, {"rule": 2, "type": "equivalent", "target": "e7ed91f4e25921028767eb7d80e59575", "evidence": {"same_day": true, "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc"}}], "version": "15.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "e7ed91f4e25921028767eb7d80e59575", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Adjust our JIT code to work with LLVM 21", "evidence": {"same_day": true, "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc"}, "url": "/docs/compare/?release=18.2#18.2-bf063586f9119b1e", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "c7ea32ba825d2c7140b0017b02f1a3ec", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Adjust our JIT code to work with LLVM 21", "evidence": {"same_day": true, "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc"}, "url": "/docs/compare/?release=17.8#17.8-64e9296142cf419d", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "51e665bd2f8466b41d80cf0223c7e413", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Adjust our JIT code to work with LLVM 21", "evidence": {"same_day": true, "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc"}, "url": "/docs/compare/?release=16.12#16.12-f79746039ad9700e", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "cff57c5be469c947c3ffe128e6ba5e35", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Adjust our JIT code to work with LLVM 21", "evidence": {"same_day": true, "patch_ids": ["66d712c94d1e5df73fed0dd65d77b242"], "statement_hash": "3c6749ca7e34ce305cd7020f2256a99d6e58f6a41cedef18deedef24299c3cdc"}, "url": "/docs/compare/?release=14.21#14.21-cf7b1ea7a3d14458", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-03e934debe8d5e92", "cves": [], "html": "Support process title changes on GNU/Hurd (Michael Banck) §
", "text": "Support process title changes on GNU/Hurd (Michael Banck) §", "title": "Support process title changes on GNU/Hurd", "commits": ["3995e4a9d"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "8ff26fd10b3c5ef88d101c5187a012f564d273d061292924bb4564e14df8c413", "section_path": ["Changes"], "commit_groups": [["29a3e22f3", "32b236644", "3995e4a9d", "a1407dade", "bcfca332f", "d66a922f9"]], "identity_text": "Support process title changes on GNU/Hurd (Michael Banck)", "commit_aliases": ["29a3e22f3", "32b236644", "3995e4a9d", "a1407dade", "bcfca332f", "d66a922f9"], "source_commits": ["3995e4a9d"], "source_entry_id": "15.16/changes/032", "db_id": "d2f91f9760f28a721378c4e8d76ef619", "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f", "relations": [{"rule": 2, "type": "equivalent", "target": "45f431c4bd4cad50e4053b47f371bd3f", "evidence": {"same_day": true, "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f"}}, {"rule": 2, "type": "equivalent", "target": "465d44f8b93dc009feaa8d1fac573196", "evidence": {"same_day": true, "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f"}}, {"rule": 2, "type": "equivalent", "target": "92b88e55c652dfa1fcdde3f0953f3285", "evidence": {"same_day": true, "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f"}}, {"rule": 2, "type": "equivalent", "target": "b14342e6824ed37b82078bd9a6cc21e1", "evidence": {"same_day": true, "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f"}}], "version": "15.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "92b88e55c652dfa1fcdde3f0953f3285", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Support process title changes on GNU/Hurd", "evidence": {"same_day": true, "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f"}, "url": "/docs/compare/?release=18.2#18.2-e1336b6079ff8d5b", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "b14342e6824ed37b82078bd9a6cc21e1", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Support process title changes on GNU/Hurd", "evidence": {"same_day": true, "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f"}, "url": "/docs/compare/?release=17.8#17.8-3cbfa3eb5e11672e", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "45f431c4bd4cad50e4053b47f371bd3f", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Support process title changes on GNU/Hurd", "evidence": {"same_day": true, "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f"}, "url": "/docs/compare/?release=16.12#16.12-518eec4d74a9bdf5", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "465d44f8b93dc009feaa8d1fac573196", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Support process title changes on GNU/Hurd", "evidence": {"same_day": true, "patch_ids": ["f27aa5a2659577ffa2455a4c94564743"], "statement_hash": "c996e792f260f0d512b6a6524e3b46eed7769d4f17a4584a012601680f44fc4f"}, "url": "/docs/compare/?release=14.21#14.21-d81eba7f3eeb9460", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-3d69fa0131d029ba", "cves": [], "html": "Make pg_resetwal print the updated value when changing OldestXID (Heikki Linnakangas) §
\nIt already did that for every other variable it can change.
", "text": "Make pg_resetwal print the updated value when changing OldestXID (Heikki Linnakangas) § It already did that for every other variable it can change.", "title": "Make pg_resetwal print the updated value when changing OldestXID", "commits": ["7c494072b"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "c72a4b68640af141ee14ab61c2de8ca2c25f98456334b6456d4d6a3b72e782b9", "section_path": ["Changes"], "commit_groups": [["11cc0f452", "19594271c", "7c494072b", "890cc81b6", "d5b4f3a6d", "f2e0ca0af"]], "identity_text": "Make pg_resetwal print the updated value when changing OldestXID (Heikki Linnakangas) It already did that for every other variable it can change.", "commit_aliases": ["11cc0f452", "19594271c", "7c494072b", "890cc81b6", "d5b4f3a6d", "f2e0ca0af"], "source_commits": ["7c494072b"], "source_entry_id": "15.16/changes/033", "db_id": "47e617ce37a58405cf4c7f033f26b641", "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a", "relations": [{"rule": 2, "type": "equivalent", "target": "22be50f61755ecf5187af28b01545b41", "evidence": {"same_day": true, "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a"}}, {"rule": 2, "type": "equivalent", "target": "500d9d80888f7caeb4b4801bee95301d", "evidence": {"same_day": true, "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a"}}, {"rule": 2, "type": "equivalent", "target": "5f928cd7f1a940e12cd51a8ce19d06f6", "evidence": {"same_day": true, "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a"}}, {"rule": 2, "type": "equivalent", "target": "94c5ea9aed8ffadf4043f33f201ed4e5", "evidence": {"same_day": true, "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a"}}], "version": "15.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "5f928cd7f1a940e12cd51a8ce19d06f6", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Make pg_resetwal print the updated value when changing OldestXID", "evidence": {"same_day": true, "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a"}, "url": "/docs/compare/?release=18.2#18.2-12ea46c5ca32b0f2", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "500d9d80888f7caeb4b4801bee95301d", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Make pg_resetwal print the updated value when changing OldestXID", "evidence": {"same_day": true, "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a"}, "url": "/docs/compare/?release=17.8#17.8-0aca6daf3559b899", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "94c5ea9aed8ffadf4043f33f201ed4e5", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Make pg_resetwal print the updated value when changing OldestXID", "evidence": {"same_day": true, "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a"}, "url": "/docs/compare/?release=16.12#16.12-49d7c6db55fd3d90", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "22be50f61755ecf5187af28b01545b41", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Make pg_resetwal print the updated value when changing OldestXID", "evidence": {"same_day": true, "patch_ids": ["f29e862445ceccbb303aaae2f778a19b"], "statement_hash": "7e00b6482e7aa0b9a1cb427214f076ddb806bf1fa199c1cf0ab023c54c2dd96a"}, "url": "/docs/compare/?release=14.21#14.21-cd08367401e4956d", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-fed3a8dfafe193ba", "cves": [], "html": "Make pg_resetwal allow setting next multixact xid to 0 or next multixact offset to UINT32_MAX (Maxim Orlov) §
\nThese are valid values, so rejecting them was incorrect. In the worst case, if a pg_upgrade is attempted when exactly at the point of multixact wraparound, the upgrade would fail.
", "text": "Make pg_resetwal allow setting next multixact xid to 0 or next multixact offset to UINT32_MAX (Maxim Orlov) § These are valid values, so rejecting them was incorrect. In the worst case, if a pg_upgrade is attempted when exactly at the point of multixact wraparound, the upgrade would fail.", "title": "Make pg_resetwal allow setting next multixact xid to 0 or next multixact offset to UINT32_MAX", "commits": ["97cd4b65a"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "98976cf38e41c530fab66fd29be858bc6cd8993daed517aaa86d4c57c71d960f", "section_path": ["Changes"], "commit_groups": [["8747b969f", "94939c5f3", "97cd4b65a", "cb2ef0e92", "e039b09f8"]], "identity_text": "Make pg_resetwal allow setting next multixact xid to 0 or next multixact offset to UINT32_MAX (Maxim Orlov) These are valid values, so rejecting them was incorrect. In the worst case, if a pg_upgrade is attempted when exactly at the point of multixact wraparound, the upgrade would fail.", "commit_aliases": ["8747b969f", "94939c5f3", "97cd4b65a", "cb2ef0e92", "e039b09f8"], "source_commits": ["97cd4b65a"], "source_entry_id": "15.16/changes/034", "db_id": "4da7f3aac2517d05e54bea6d3c1ab25e", "patch_ids": ["0f6a9848b48d4b26e3e4691043d1c86b"], "statement_hash": "55f06afcc35f279a01bd7723ea6dc23f0393b803bcd2fbe9ea5c0600d99ed0ea", "relations": [{"rule": 2, "type": "equivalent", "target": "89127b250f2abea1a64f754f71c48c77", "evidence": {"same_day": true, "patch_ids": ["0f6a9848b48d4b26e3e4691043d1c86b"], "statement_hash": "55f06afcc35f279a01bd7723ea6dc23f0393b803bcd2fbe9ea5c0600d99ed0ea"}}, {"rule": 2, "type": "equivalent", "target": "a4ce7629005a43b316bb9b4fbdb478ad", "evidence": {"same_day": true, "patch_ids": ["0f6a9848b48d4b26e3e4691043d1c86b"], "statement_hash": "55f06afcc35f279a01bd7723ea6dc23f0393b803bcd2fbe9ea5c0600d99ed0ea"}}, {"rule": 2, "type": "equivalent", "target": "ba56a98c48c3c98e929510554c2c7d1f", "evidence": {"same_day": true, "patch_ids": ["0f6a9848b48d4b26e3e4691043d1c86b"], "statement_hash": "55f06afcc35f279a01bd7723ea6dc23f0393b803bcd2fbe9ea5c0600d99ed0ea"}}], "version": "15.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "a4ce7629005a43b316bb9b4fbdb478ad", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Make pg_resetwal allow setting next multixact xid to 0 or next multixact offset to UINT32_MAX", "evidence": {"same_day": true, "patch_ids": ["0f6a9848b48d4b26e3e4691043d1c86b"], "statement_hash": "55f06afcc35f279a01bd7723ea6dc23f0393b803bcd2fbe9ea5c0600d99ed0ea"}, "url": "/docs/compare/?release=18.2#18.2-b3adbf7cc127bf87", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "ba56a98c48c3c98e929510554c2c7d1f", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Make pg_resetwal allow setting next multixact xid to 0 or next multixact offset to UINT32_MAX", "evidence": {"same_day": true, "patch_ids": ["0f6a9848b48d4b26e3e4691043d1c86b"], "statement_hash": "55f06afcc35f279a01bd7723ea6dc23f0393b803bcd2fbe9ea5c0600d99ed0ea"}, "url": "/docs/compare/?release=17.8#17.8-6a1deb077e1799c1", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "89127b250f2abea1a64f754f71c48c77", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Make pg_resetwal allow setting next multixact xid to 0 or next multixact offset to UINT32_MAX", "evidence": {"same_day": true, "patch_ids": ["0f6a9848b48d4b26e3e4691043d1c86b"], "statement_hash": "55f06afcc35f279a01bd7723ea6dc23f0393b803bcd2fbe9ea5c0600d99ed0ea"}, "url": "/docs/compare/?release=16.12#16.12-be4ccb27fcd54b62", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}]}, {"id": "15.16-32e275050e59e4f0", "cves": [], "html": "In contrib/amcheck, use the correct snapshot for btree index parent checks (Mihail Nikalayeu) §
The previous coding caused spurious errors when examining indexes created with CREATE INDEX CONCURRENTLY.
Fix contrib/amcheck to handle “half-dead” btree index pages correctly (Heikki Linnakangas) §
amcheck expected such a page to have a parent downlink, but it does not, leading to a false error report about “mismatch between parent key and child high key”.
Fix contrib/amcheck to handle incomplete btree root page splits correctly (Heikki Linnakangas) §
amcheck could report a false error about “block is not true root”.
Fix edge-case integer overflow in contrib/intarray's selectivity estimator for @@ (Chao Li) §
This could cause poor selectivity estimates to be produced for cases involving the maximum integer value.
", "text": "Fix edge-case integer overflow in contrib/intarray's selectivity estimator for @@ (Chao Li) § This could cause poor selectivity estimates to be produced for cases involving the maximum integer value.", "title": "Fix edge-case integer overflow in contrib/intarray's selectivity estimator for @@", "commits": ["c89510431"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "34c9ef81372ea420b819849bba7ed52eff06df3feb5967340dfa8729cc82a658", "section_path": ["Changes"], "commit_groups": [["07c1c6ec5", "4f49e4b55", "54f82c4aa", "67a6fd507", "a5f2dc421", "c89510431"]], "identity_text": "Fix edge-case integer overflow in contrib/intarray's selectivity estimator for @@ (Chao Li) This could cause poor selectivity estimates to be produced for cases involving the maximum integer value.", "commit_aliases": ["07c1c6ec5", "4f49e4b55", "54f82c4aa", "67a6fd507", "a5f2dc421", "c89510431"], "source_commits": ["c89510431"], "source_entry_id": "15.16/changes/038", "db_id": "81dbabd3964ac7d16575fec8b0e775d4", "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf", "relations": [{"rule": 2, "type": "equivalent", "target": "1285579c66ecba8872eb8b17f3bc4e1b", "evidence": {"same_day": true, "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf"}}, {"rule": 2, "type": "equivalent", "target": "59e2d3bf9637de09505f940988dcd182", "evidence": {"same_day": true, "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf"}}, {"rule": 2, "type": "equivalent", "target": "8280d414e29b698e7a7b5bdab7d65a67", "evidence": {"same_day": true, "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf"}}, {"rule": 2, "type": "equivalent", "target": "e129aabe6a0e432884befb054f303449", "evidence": {"same_day": true, "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf"}}], "version": "15.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "e129aabe6a0e432884befb054f303449", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Fix edge-case integer overflow in contrib/intarray's selectivity estimator for @@", "evidence": {"same_day": true, "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf"}, "url": "/docs/compare/?release=18.2#18.2-a45188e655691d38", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "8280d414e29b698e7a7b5bdab7d65a67", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Fix edge-case integer overflow in contrib/intarray's selectivity estimator for @@", "evidence": {"same_day": true, "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf"}, "url": "/docs/compare/?release=17.8#17.8-ab6fdf5f76b2dd4a", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "1285579c66ecba8872eb8b17f3bc4e1b", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Fix edge-case integer overflow in contrib/intarray's selectivity estimator for @@", "evidence": {"same_day": true, "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf"}, "url": "/docs/compare/?release=16.12#16.12-5a125ae178db396f", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "59e2d3bf9637de09505f940988dcd182", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Fix edge-case integer overflow in contrib/intarray's selectivity estimator for @@", "evidence": {"same_day": true, "patch_ids": ["6827108dafb7fb952c98263cf81bfb12"], "statement_hash": "15b336d5589f6d629fe8bb0549cd193d78524753cdd06cfede921f7dce003daf"}, "url": "/docs/compare/?release=14.21#14.21-b90e49b89a9df63b", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}, {"id": "15.16-a86dbc9d880920b4", "cves": [], "html": "Fix multibyte-encoding issue in contrib/ltree (Jeff Davis) §
The previous coding could pass an incomplete multibyte character to lower(), probably resulting in incorrect behavior.
Update time zone data files to tzdata release 2025c (Tom Lane) §
\nThe only change is in historical data for pre-1976 timestamps in Baja California.
", "text": "Update time zone data files to tzdata release 2025c (Tom Lane) § The only change is in historical data for pre-1976 timestamps in Baja California.", "title": "Update time zone data files to tzdata release 2025c", "commits": ["00410b76d"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/15.16/#id-1.11.6.9.5", "source_hash": "9d5b124422c2836ccc4a8450343bf565b8df65e422336d13f5d197dfc528448a", "section_path": ["Changes"], "commit_groups": [["00410b76d", "228fe0c3e", "6574bee64", "8bbf28191", "d852d105e", "f87c0b84e"]], "identity_text": "Update time zone data files to tzdata release 2025c (Tom Lane) The only change is in historical data for pre-1976 timestamps in Baja California.", "commit_aliases": ["00410b76d", "228fe0c3e", "6574bee64", "8bbf28191", "d852d105e", "f87c0b84e"], "source_commits": ["00410b76d"], "source_entry_id": "15.16/changes/040", "db_id": "8fe4829a60aad3b491b6cf8cc56b6b67", "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b", "relations": [{"rule": 2, "type": "equivalent", "target": "1e212940a15748de8b9d8f9f8a00221c", "evidence": {"same_day": true, "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b"}}, {"rule": 2, "type": "equivalent", "target": "6a2a6f129d457a35195c94f742bac1c7", "evidence": {"same_day": true, "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b"}}, {"rule": 2, "type": "equivalent", "target": "af6fece6fb7485ca9609d00ddf419b69", "evidence": {"same_day": true, "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b"}}, {"rule": 2, "type": "equivalent", "target": "e11e7a4857357ba2a4255391b7eb4033", "evidence": {"same_day": true, "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b"}}], "version": "15.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "1e212940a15748de8b9d8f9f8a00221c", "kind": "equivalent", "version": "18.2", "label": "18.2", "title": "Update time zone data files to tzdata release 2025c", "evidence": {"same_day": true, "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b"}, "url": "/docs/compare/?release=18.2#18.2-4cbf16ee6dc57970", "source_url": "/docs/release/18.2/#RELEASE-18-2-CHANGES"}, {"db_id": "e11e7a4857357ba2a4255391b7eb4033", "kind": "equivalent", "version": "17.8", "label": "17.8", "title": "Update time zone data files to tzdata release 2025c", "evidence": {"same_day": true, "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b"}, "url": "/docs/compare/?release=17.8#17.8-6f023224ced53b65", "source_url": "/docs/release/17.8/#RELEASE-17-8-CHANGES"}, {"db_id": "6a2a6f129d457a35195c94f742bac1c7", "kind": "equivalent", "version": "16.12", "label": "16.12", "title": "Update time zone data files to tzdata release 2025c", "evidence": {"same_day": true, "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b"}, "url": "/docs/compare/?release=16.12#16.12-6eb2ba686b659281", "source_url": "/docs/release/16.12/#RELEASE-16-12-CHANGES"}, {"db_id": "af6fece6fb7485ca9609d00ddf419b69", "kind": "equivalent", "version": "14.21", "label": "14.21", "title": "Update time zone data files to tzdata release 2025c", "evidence": {"same_day": true, "patch_ids": ["248cd6c3eee33cd4c82f09ee1d6af621"], "statement_hash": "da0a28a77bd7a205873150e5d6559af4853f986168d43f9537c2dbe1b0158a5b"}, "url": "/docs/compare/?release=14.21#14.21-af62fd071fbac039", "source_url": "/docs/release/14.21/#id-1.11.6.9.6"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 40}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 17}, {"key": "security", "label": "Security", "count": 4}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 19}], "total": 40, "release_count": 1, "cross_major": false, "cve_count": 4, "cves": [{"id": "CVE-2026-2006", "url": "https://www.postgresql.org/support/security/CVE-2026-2006/", "fixed": {"14": "14.21", "15": "15.16", "16": "16.12", "17": "17.8", "18": "18.2"}, "score": 8.8, "title": "Fix inadequate validation of multibyte character lengths", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H", "cna_url": "https://cveawg.mitre.org/api/cve/CVE-2026-2006", "affected": {"14": "14", "15": "15", "16": "16", "17": "17", "18": "18"}, "component": "core server", "published": {"14": "2026-02-12", "15": "2026-02-12", "16": "2026-02-12", "17": "2026-02-12", "18": "2026-02-12"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Missing validation of multibyte character length in PostgreSQL text manipulation allows a database user to issue crafted queries that achieve a buffer overrun. That suffices to execute arbitrary code as the operating system user running the database. Versions before PostgreSQL 18.2, 17.8, 16.12, 15.16, and 14.21 are affected.", "affected_ranges": [{"from": "0", "until": "14.21"}, {"from": "15", "until": "15.16"}, {"from": "16", "until": "16.12"}, {"from": "17", "until": "17.8"}, {"from": "18", "until": "18.2"}], "first_published": "2026-02-12", "fixed_version": "15.16"}, {"id": "CVE-2026-2005", "url": "https://www.postgresql.org/support/security/CVE-2026-2005/", "fixed": {"14": "14.21", "15": "15.16", "16": "16.12", "17": "17.8", "18": "18.2"}, "score": 8.8, "title": "Fix buffer overrun in contrib/pgcrypto's PGP decryption functions", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H", "cna_url": "https://cveawg.mitre.org/api/cve/CVE-2026-2005", "affected": {"14": "14", "15": "15", "16": "16", "17": "17", "18": "18"}, "component": "contrib module", "published": {"14": "2026-02-12", "15": "2026-02-12", "16": "2026-02-12", "17": "2026-02-12", "18": "2026-02-12"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Heap buffer overflow in PostgreSQL pgcrypto allows a ciphertext provider to execute arbitrary code as the operating system user running the database. Versions before PostgreSQL 18.2, 17.8, 16.12, 15.16, and 14.21 are affected.", "affected_ranges": [{"from": "0", "until": "14.21"}, {"from": "15", "until": "15.16"}, {"from": "16", "until": "16.12"}, {"from": "17", "until": "17.8"}, {"from": "18", "until": "18.2"}], "first_published": "2026-02-12", "fixed_version": "15.16"}, {"id": "CVE-2026-2004", "url": "https://www.postgresql.org/support/security/CVE-2026-2004/", "fixed": {"14": "14.21", "15": "15.16", "16": "16.12", "17": "17.8", "18": "18.2"}, "score": 8.8, "title": "Harden selectivity estimators against being attached to operators that accept unexpected data types", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H", "cna_url": "https://cveawg.mitre.org/api/cve/CVE-2026-2004", "affected": {"14": "14", "15": "15", "16": "16", "17": "17", "18": "18"}, "component": "contrib module", "published": {"14": "2026-02-12", "15": "2026-02-12", "16": "2026-02-12", "17": "2026-02-12", "18": "2026-02-12"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Missing validation of type of input in PostgreSQL intarray extension selectivity estimator function allows an object creator to execute arbitrary code as the operating system user running the database. Versions before PostgreSQL 18.2, 17.8, 16.12, 15.16, and 14.21 are affected.", "affected_ranges": [{"from": "0", "until": "14.21"}, {"from": "15", "until": "15.16"}, {"from": "16", "until": "16.12"}, {"from": "17", "until": "17.8"}, {"from": "18", "until": "18.2"}], "first_published": "2026-02-12", "fixed_version": "15.16"}, {"id": "CVE-2026-2003", "url": "https://www.postgresql.org/support/security/CVE-2026-2003/", "fixed": {"14": "14.21", "15": "15.16", "16": "16.12", "17": "17.8", "18": "18.2"}, "score": 4.3, "title": "Guard against unexpected dimensions of oidvector/int2vector", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N", "cna_url": "https://cveawg.mitre.org/api/cve/CVE-2026-2003", "affected": {"14": "14", "15": "15", "16": "16", "17": "17", "18": "18"}, "component": "core server", "published": {"14": "2026-02-12", "15": "2026-02-12", "16": "2026-02-12", "17": "2026-02-12", "18": "2026-02-12"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Improper validation of type \"oidvector\" in PostgreSQL allows a database user to disclose a few bytes of server memory. We have not ruled out viability of attacks that arrange for presence of confidential information in disclosed bytes, but they seem unlikely. Versions before PostgreSQL 18.2, 17.8, 16.12, 15.16, and 14.21 are affected.", "affected_ranges": [{"from": "0", "until": "14.21"}, {"from": "15", "until": "15.16"}, {"from": "16", "until": "16.12"}, {"from": "17", "until": "17.8"}, {"from": "18", "until": "18.2"}], "first_published": "2026-02-12", "fixed_version": "15.16"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 40, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}