{"already_in_source_count":0,"candidate_count":47,"cross_major":false,"cve_available":true,"cve_count":2,"cves":[{"affected":{"11":"11","12":"12","13":"13","14":"14","15":"15"},"component":"core server","cvss_version":"3.0","description_en":"An extension script is vulnerable if it uses @extowner@ , @extschema@ , or @extschema:...@ inside a quoting construct (dollar quoting, '' , or \"\" ). No bundled extension is vulnerable. Vulnerable uses do appear in a documentation example and in non-bundled extensions. Hence, the attack prerequisite is an administrator having installed files of a vulnerable, trusted, non-bundled extension. Subject to that prerequisite, this enables an attacker having database-level CREATE privilege to execute arbitrary code as the bootstrap superuser. PostgreSQL will block this attack in the core server, so there's no need to modify individual extensions.\n\nThe PostgreSQL project thanks Micah Gates, Valerie Woolard, Tim Carey-Smith, and Christoph Berg for reporting this problem.","first_published":"2023-08-10","fixed":{"11":"11.21","12":"12.16","13":"13.12","14":"14.9","15":"15.4"},"fixed_version":"15.4","id":"CVE-2023-39417","introduced":{},"published":{"11":"2023-08-10","12":"2023-08-10","13":"2023-08-10","14":"2023-08-10","15":"2023-08-10"},"score":7.5,"title":"Disallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign","url":"https://www.postgresql.org/support/security/CVE-2023-39417/","vector":"AV:N/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:H"},{"affected":{"15":"15"},"component":"core server","cvss_version":"3.0","description_en":"PostgreSQL 15 introduced the MERGE command, which fails to test new rows against row security policies defined for UPDATE and SELECT . If UPDATE and SELECT policies forbid some row that INSERT policies do not forbid, a user could store such rows. Subsequent consequences are application-dependent. This affects only databases that have used CREATE POLICY to define a row security policy.\n\nThe PostgreSQL project thanks Dean Rasheed for reporting this problem.","first_published":"2023-08-10","fixed":{"15":"15.4"},"fixed_version":"15.4","id":"CVE-2023-39418","introduced":{},"published":{"15":"2023-08-10"},"score":3.1,"title":"Fix MERGE to enforce row security policies properly","url":"https://www.postgresql.org/support/security/CVE-2023-39418/","vector":"AV:N/AC:H/PR:L/UI:N/S:U/C:N/I:L/A:N"}],"duplicate_count":0,"excluded_count":0,"exclusions":[],"from_release":null,"groups":[{"age_days":1200,"build":"15.4","changes_count":47,"compatibility_count":0,"content_hash":"d9fd82b773ce9a5d77042c14b19b328ecc87b3f1e1592c7ce3b5f7c476ba9861","date":"2023-08-10","date_text":"2023-08-10","doc_git":"b9f0e7232f60f380d642ac9b99226606c254b552","doc_loaded_at":"2026-11-12T17:14:13+00:00","entries":[{"also_in":[],"category":"security","category_label":"Security","commit_aliases":["919ebb023","b1b585e0f","cd5f2a357","d4648a74b","de494ec14","eb044d8f0","f53511010"],"commit_groups":[["919ebb023","b1b585e0f","cd5f2a357","d4648a74b","de494ec14","eb044d8f0","f53511010"]],"commits":["de494ec14"],"cves":["CVE-2023-39417"],"db_id":"5d760cb5505031c3afb75b8a5ded21c8","html":"\u003cp\u003eDisallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign (Noah Misch) \u003ca href=\"https://postgr.es/c/de494ec14\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThis restriction guards against SQL-injection hazards for trusted extensions.\u003c/p\u003e\n\u003cp\u003eThe \u003cspan\u003ePostgreSQL\u003c/span\u003e Project thanks Micah Gates, Valerie Woolard, Tim Carey-Smith, and Christoph Berg for reporting this problem. (CVE-2023-39417)\u003c/p\u003e","id":"15.4-916b73de52ac811a","identity_text":"Disallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign (Noah Misch) This restriction guards against SQL-injection hazards for trusted extensions. The PostgreSQL Project thanks Micah Gates, Valerie Woolard, Tim Carey-Smith, and Christoph Berg for reporting this problem. (CVE-2023-39417)","part":"changes","patch_ids":["d632a8310a44a1dd4482363722906e6f"],"related_changes":[{"db_id":"f94afefad5df63c780c9f2436c9d6dcf","evidence":{"patch_ids":["d632a8310a44a1dd4482363722906e6f"],"same_day":true,"statement_hash":"547bb828bb240e3feac6daf0dbbc30bca373c7b437959e2e15f19f38d18cdc81"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Disallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign","url":"/docs/compare/?release=14.9#14.9-478a82e9fe36e0eb","version":"14.9"},{"db_id":"905f10b00c23d8b9f0aa97f3673fee9a","evidence":{"patch_ids":["d632a8310a44a1dd4482363722906e6f"],"same_day":true,"statement_hash":"547bb828bb240e3feac6daf0dbbc30bca373c7b437959e2e15f19f38d18cdc81"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Disallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign","url":"/docs/compare/?release=13.12#13.12-7e7794e398a17981","version":"13.12"},{"db_id":"7fded6f9dac5a0280a2df87572e29a0d","evidence":{"patch_ids":["d632a8310a44a1dd4482363722906e6f"],"same_day":true,"statement_hash":"547bb828bb240e3feac6daf0dbbc30bca373c7b437959e2e15f19f38d18cdc81"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Disallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign","url":"/docs/compare/?release=12.16#12.16-9cd59e5c454decd6","version":"12.16"},{"db_id":"afe8a3657968f46801b50925881578a5","evidence":{"patch_ids":["d632a8310a44a1dd4482363722906e6f"],"same_day":true},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Disallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign","url":"/docs/compare/?release=11.21#11.21-cf02775dac7e070c","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["d632a8310a44a1dd4482363722906e6f"],"same_day":true,"statement_hash":"547bb828bb240e3feac6daf0dbbc30bca373c7b437959e2e15f19f38d18cdc81"},"rule":2,"target":"7fded6f9dac5a0280a2df87572e29a0d","type":"equivalent"},{"evidence":{"patch_ids":["d632a8310a44a1dd4482363722906e6f"],"same_day":true,"statement_hash":"547bb828bb240e3feac6daf0dbbc30bca373c7b437959e2e15f19f38d18cdc81"},"rule":2,"target":"905f10b00c23d8b9f0aa97f3673fee9a","type":"equivalent"},{"evidence":{"patch_ids":["d632a8310a44a1dd4482363722906e6f"],"same_day":true},"rule":2,"target":"afe8a3657968f46801b50925881578a5","type":"equivalent"},{"evidence":{"patch_ids":["d632a8310a44a1dd4482363722906e6f"],"same_day":true,"statement_hash":"547bb828bb240e3feac6daf0dbbc30bca373c7b437959e2e15f19f38d18cdc81"},"rule":2,"target":"f94afefad5df63c780c9f2436c9d6dcf","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["de494ec14"],"source_entry_id":"15.4/changes/001","source_hash":"4372137f54bf66988ab39a2e6125a76058b5a92ec7dbb2e81b92c131a09dcab8","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"547bb828bb240e3feac6daf0dbbc30bca373c7b437959e2e15f19f38d18cdc81","text":"Disallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign (Noah Misch) § This restriction guards against SQL-injection hazards for trusted extensions. The PostgreSQL Project thanks Micah Gates, Valerie Woolard, Tim Carey-Smith, and Christoph Berg for reporting this problem. (CVE-2023-39417)","title":"Disallow substituting a schema or owner name into an extension script if the name contains a quote, backslash, or dollar sign","variants":[],"version":"15.4"},{"also_in":[],"category":"security","category_label":"Security","commit_aliases":["67a007dc0","c2e08b04c","cb2ae5741"],"commit_groups":[["67a007dc0","c2e08b04c","cb2ae5741"]],"commits":["cb2ae5741"],"cves":["CVE-2023-39418"],"db_id":"f421a35b1ce0c78b826bb5de20733636","html":"\u003cp\u003eFix \u003ccode\u003eMERGE\u003c/code\u003e to enforce row security policies properly (Dean Rasheed) \u003ca href=\"https://postgr.es/c/cb2ae5741\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eWhen \u003ccode\u003eMERGE\u003c/code\u003e performs an \u003ccode\u003eUPDATE\u003c/code\u003e action, it should enforce any \u003ccode\u003eUPDATE\u003c/code\u003e or \u003ccode\u003eSELECT\u003c/code\u003e RLS policies defined on the target table, to be consistent with the way that a plain \u003ccode\u003eUPDATE\u003c/code\u003e with a \u003ccode\u003eWHERE\u003c/code\u003e clause works. Instead it was enforcing \u003ccode\u003eINSERT\u003c/code\u003e RLS policies for both \u003ccode\u003eINSERT\u003c/code\u003e and \u003ccode\u003eUPDATE\u003c/code\u003e actions.\u003c/p\u003e\n\u003cp\u003eIn addition, when \u003ccode\u003eMERGE\u003c/code\u003e performs a \u003ccode\u003eDO NOTHING\u003c/code\u003e action, it applied the target table's \u003ccode\u003eDELETE\u003c/code\u003e RLS policies to existing rows, even though those rows are not being deleted. While it's not a security problem, this could result in unwanted errors.\u003c/p\u003e\n\u003cp\u003eThe \u003cspan\u003ePostgreSQL\u003c/span\u003e Project thanks Dean Rasheed for reporting this problem. (CVE-2023-39418)\u003c/p\u003e","id":"15.4-2da949e7f1e67d5c","identity_text":"Fix MERGE to enforce row security policies properly (Dean Rasheed) When MERGE performs an UPDATE action, it should enforce any UPDATE or SELECT RLS policies defined on the target table, to be consistent with the way that a plain UPDATE with a WHERE clause works. Instead it was enforcing INSERT RLS policies for both INSERT and UPDATE actions. In addition, when MERGE performs a DO NOTHING action, it applied the target table's DELETE RLS policies to existing rows, even though those rows are not being deleted. While it's not a security problem, this could result in unwanted errors. The PostgreSQL Project thanks Dean Rasheed for reporting this problem. (CVE-2023-39418)","part":"changes","patch_ids":["c826aaea28d6c52b7ef5f6c10c8dc74e"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["cb2ae5741"],"source_entry_id":"15.4/changes/002","source_hash":"7e328fe7f96bb19c1a7958e4f486c10faa578cd93fcbb06e65ebd388c2ff0e0d","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"39abc23c0f046c3789ad12a1cf087a1993918dd4f2d356ce8e2941f989535cb9","text":"Fix MERGE to enforce row security policies properly (Dean Rasheed) § When MERGE performs an UPDATE action, it should enforce any UPDATE or SELECT RLS policies defined on the target table, to be consistent with the way that a plain UPDATE with a WHERE clause works. Instead it was enforcing INSERT RLS policies for both INSERT and UPDATE actions. In addition, when MERGE performs a DO NOTHING action, it applied the target table's DELETE RLS policies to existing rows, even though those rows are not being deleted. While it's not a security problem, this could result in unwanted errors. The PostgreSQL Project thanks Dean Rasheed for reporting this problem. (CVE-2023-39418)","title":"Fix MERGE to enforce row security policies properly","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["2b1ab28b9","3581cbdcd","3ec8a3bfb","3f1356e5d","40d465caf","6c512fc6e","80f64b900","b511d7323","d42ffda68","d78a66d92","e18769323","fc7dc728d"],"commit_groups":[["2b1ab28b9","3ec8a3bfb","3f1356e5d","80f64b900","b511d7323","d42ffda68"],["3581cbdcd","40d465caf","6c512fc6e","d78a66d92","e18769323","fc7dc728d"]],"commits":["80f64b900","e18769323"],"cves":[],"db_id":"9abc5f5a50d73214283c739d73f5cdfc","html":"\u003cp\u003eFix confusion between empty (no rows) ranges and all-NULL ranges in BRIN indexes, as well as incorrect merging of all-NULL summaries (Tomas Vondra) \u003ca href=\"https://postgr.es/c/e18769323\"\u003e§\u003c/a\u003e \u003ca href=\"https://postgr.es/c/80f64b900\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eEach of these oversights could result in forgetting that a BRIN index range contains any NULL values, potentially allowing subsequent queries that should return NULL values to miss doing so.\u003c/p\u003e\n\u003cp\u003eThis fix will not in itself correct faulty BRIN entries. It's recommended to \u003ccode\u003eREINDEX\u003c/code\u003e any BRIN indexes that may be used to search for nulls.\u003c/p\u003e","id":"15.4-ea955f29ecf4775a","identity_text":"Fix confusion between empty (no rows) ranges and all-NULL ranges in BRIN indexes, as well as incorrect merging of all-NULL summaries (Tomas Vondra) Each of these oversights could result in forgetting that a BRIN index range contains any NULL values, potentially allowing subsequent queries that should return NULL values to miss doing so. This fix will not in itself correct faulty BRIN entries. It's recommended to REINDEX any BRIN indexes that may be used to search for nulls.","part":"changes","patch_ids":["70439af6cb78988d1947cf69b8bf78c2","d68a660acabb371022bbe16aaec1d3f1"],"related_changes":[{"db_id":"7bc32e86e27a9d2d7da8107e0b7a7f09","evidence":{"patch_ids":["70439af6cb78988d1947cf69b8bf78c2","d68a660acabb371022bbe16aaec1d3f1"],"same_day":true,"statement_hash":"b7ca54d70850e1477128353afe1dddfb4d31f58e424300e25b68cd3d2d1330de"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Fix confusion between empty (no rows) ranges and all-NULL ranges in BRIN indexes, as well as incorrect merging of all-NULL summaries","url":"/docs/compare/?release=14.9#14.9-491640756e087ff4","version":"14.9"},{"db_id":"11b6ba567136afc52b96368060d9eb27","evidence":{"patch_ids":["70439af6cb78988d1947cf69b8bf78c2","d68a660acabb371022bbe16aaec1d3f1"],"same_day":true,"statement_hash":"b7ca54d70850e1477128353afe1dddfb4d31f58e424300e25b68cd3d2d1330de"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Fix confusion between empty (no rows) ranges and all-NULL ranges in BRIN indexes, as well as incorrect merging of all-NULL summaries","url":"/docs/compare/?release=13.12#13.12-c689e131b36b73fd","version":"13.12"},{"db_id":"d3bb49eb1df29529b45d0319f7795c1c","evidence":{"patch_ids":["70439af6cb78988d1947cf69b8bf78c2","d68a660acabb371022bbe16aaec1d3f1"],"same_day":true,"statement_hash":"b7ca54d70850e1477128353afe1dddfb4d31f58e424300e25b68cd3d2d1330de"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Fix confusion between empty (no rows) ranges and all-NULL ranges in BRIN indexes, as well as incorrect merging of all-NULL summaries","url":"/docs/compare/?release=12.16#12.16-4b47fe48c28b6057","version":"12.16"},{"db_id":"19135059bdecd2f32c93539aa1f3cfb6","evidence":{"patch_ids":["70439af6cb78988d1947cf69b8bf78c2","d68a660acabb371022bbe16aaec1d3f1"],"same_day":true,"statement_hash":"b7ca54d70850e1477128353afe1dddfb4d31f58e424300e25b68cd3d2d1330de"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Fix confusion between empty (no rows) ranges and all-NULL ranges in BRIN indexes, as well as incorrect merging of all-NULL summaries","url":"/docs/compare/?release=11.21#11.21-da97b6c8e20340aa","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["70439af6cb78988d1947cf69b8bf78c2","d68a660acabb371022bbe16aaec1d3f1"],"same_day":true,"statement_hash":"b7ca54d70850e1477128353afe1dddfb4d31f58e424300e25b68cd3d2d1330de"},"rule":2,"target":"11b6ba567136afc52b96368060d9eb27","type":"equivalent"},{"evidence":{"patch_ids":["70439af6cb78988d1947cf69b8bf78c2","d68a660acabb371022bbe16aaec1d3f1"],"same_day":true,"statement_hash":"b7ca54d70850e1477128353afe1dddfb4d31f58e424300e25b68cd3d2d1330de"},"rule":2,"target":"19135059bdecd2f32c93539aa1f3cfb6","type":"equivalent"},{"evidence":{"patch_ids":["70439af6cb78988d1947cf69b8bf78c2","d68a660acabb371022bbe16aaec1d3f1"],"same_day":true,"statement_hash":"b7ca54d70850e1477128353afe1dddfb4d31f58e424300e25b68cd3d2d1330de"},"rule":2,"target":"7bc32e86e27a9d2d7da8107e0b7a7f09","type":"equivalent"},{"evidence":{"patch_ids":["70439af6cb78988d1947cf69b8bf78c2","d68a660acabb371022bbe16aaec1d3f1"],"same_day":true,"statement_hash":"b7ca54d70850e1477128353afe1dddfb4d31f58e424300e25b68cd3d2d1330de"},"rule":2,"target":"d3bb49eb1df29529b45d0319f7795c1c","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["80f64b900","e18769323"],"source_entry_id":"15.4/changes/003","source_hash":"f5a83178b92e52a0e84b95c6188dddc35d21db549dea3ffdddbf6580ad4c3b35","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"b7ca54d70850e1477128353afe1dddfb4d31f58e424300e25b68cd3d2d1330de","text":"Fix confusion between empty (no rows) ranges and all-NULL ranges in BRIN indexes, as well as incorrect merging of all-NULL summaries (Tomas Vondra) § § Each of these oversights could result in forgetting that a BRIN index range contains any NULL values, potentially allowing subsequent queries that should return NULL values to miss doing so. This fix will not in itself correct faulty BRIN entries. It's recommended to REINDEX any BRIN indexes that may be used to search for nulls.","title":"Fix confusion between empty (no rows) ranges and all-NULL ranges in BRIN indexes, as well as incorrect merging of all-NULL summaries","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["034a9fcd2","1c38e7ae1","81ce00006","a4b4cc1d6","c66a7d75e","d11efe830","f66403749"],"commit_groups":[["034a9fcd2","1c38e7ae1","81ce00006","a4b4cc1d6","c66a7d75e","d11efe830","f66403749"]],"commits":["f66403749"],"cves":[],"db_id":"4e5e78a8ac4b3ad2d8ca8b4df3520288","html":"\u003cp\u003eAvoid leaving a corrupted database behind when \u003ccode\u003eDROP DATABASE\u003c/code\u003e is interrupted (Andres Freund) \u003ca href=\"https://postgr.es/c/f66403749\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eIf \u003ccode\u003eDROP DATABASE\u003c/code\u003e was interrupted after it had already begun taking irreversible steps, the target database remained accessible (because the removal of its \u003ccode\u003epg_database\u003c/code\u003e row would roll back), but it would have corrupt contents. Fix by marking the database as inaccessible before we begin to perform irreversible operations. A failure after that will leave the database still partially present, but nothing can be done with it except to issue another \u003ccode\u003eDROP DATABASE\u003c/code\u003e.\u003c/p\u003e","id":"15.4-a9627164d90bab31","identity_text":"Avoid leaving a corrupted database behind when DROP DATABASE is interrupted (Andres Freund) If DROP DATABASE was interrupted after it had already begun taking irreversible steps, the target database remained accessible (because the removal of its pg_database row would roll back), but it would have corrupt contents. Fix by marking the database as inaccessible before we begin to perform irreversible operations. A failure after that will leave the database still partially present, but nothing can be done with it except to issue another DROP DATABASE.","part":"changes","patch_ids":["1e9c51fdf4b43d9b8ae625cf8df11bc9"],"related_changes":[{"db_id":"352fb8fef4990f2385a9f9b77ace3a6e","evidence":{"patch_ids":["1e9c51fdf4b43d9b8ae625cf8df11bc9"],"same_day":true,"statement_hash":"0bdf1323b15ffee7eacc4e858004565cb6eecca5b364aabb764018a25447bd33"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Avoid leaving a corrupted database behind when DROP DATABASE is interrupted","url":"/docs/compare/?release=14.9#14.9-e4f9b891f851d9b6","version":"14.9"},{"db_id":"9caa5f4d628412099082fd1319969991","evidence":{"patch_ids":["1e9c51fdf4b43d9b8ae625cf8df11bc9"],"same_day":true,"statement_hash":"0bdf1323b15ffee7eacc4e858004565cb6eecca5b364aabb764018a25447bd33"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Avoid leaving a corrupted database behind when DROP DATABASE is interrupted","url":"/docs/compare/?release=13.12#13.12-ad34fa4802d33508","version":"13.12"},{"db_id":"f598fe4bfadb4f9b45ea0afd89a43b41","evidence":{"patch_ids":["1e9c51fdf4b43d9b8ae625cf8df11bc9"],"same_day":true,"statement_hash":"0bdf1323b15ffee7eacc4e858004565cb6eecca5b364aabb764018a25447bd33"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Avoid leaving a corrupted database behind when DROP DATABASE is interrupted","url":"/docs/compare/?release=12.16#12.16-a380f83a6d26b264","version":"12.16"},{"db_id":"d10b4e72de56a8c53ce083837e2ffd72","evidence":{"patch_ids":["1e9c51fdf4b43d9b8ae625cf8df11bc9"],"same_day":true,"statement_hash":"0bdf1323b15ffee7eacc4e858004565cb6eecca5b364aabb764018a25447bd33"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Avoid leaving a corrupted database behind when DROP DATABASE is interrupted","url":"/docs/compare/?release=11.21#11.21-90a1c6ef90a32e12","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["1e9c51fdf4b43d9b8ae625cf8df11bc9"],"same_day":true,"statement_hash":"0bdf1323b15ffee7eacc4e858004565cb6eecca5b364aabb764018a25447bd33"},"rule":2,"target":"352fb8fef4990f2385a9f9b77ace3a6e","type":"equivalent"},{"evidence":{"patch_ids":["1e9c51fdf4b43d9b8ae625cf8df11bc9"],"same_day":true,"statement_hash":"0bdf1323b15ffee7eacc4e858004565cb6eecca5b364aabb764018a25447bd33"},"rule":2,"target":"9caa5f4d628412099082fd1319969991","type":"equivalent"},{"evidence":{"patch_ids":["1e9c51fdf4b43d9b8ae625cf8df11bc9"],"same_day":true,"statement_hash":"0bdf1323b15ffee7eacc4e858004565cb6eecca5b364aabb764018a25447bd33"},"rule":2,"target":"d10b4e72de56a8c53ce083837e2ffd72","type":"equivalent"},{"evidence":{"patch_ids":["1e9c51fdf4b43d9b8ae625cf8df11bc9"],"same_day":true,"statement_hash":"0bdf1323b15ffee7eacc4e858004565cb6eecca5b364aabb764018a25447bd33"},"rule":2,"target":"f598fe4bfadb4f9b45ea0afd89a43b41","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["f66403749"],"source_entry_id":"15.4/changes/004","source_hash":"9d997c3814e447f7099a4401cf8fefeef26cc13701e5eb5e14ede557e8498350","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"0bdf1323b15ffee7eacc4e858004565cb6eecca5b364aabb764018a25447bd33","text":"Avoid leaving a corrupted database behind when DROP DATABASE is interrupted (Andres Freund) § If DROP DATABASE was interrupted after it had already begun taking irreversible steps, the target database remained accessible (because the removal of its pg_database row would roll back), but it would have corrupt contents. Fix by marking the database as inaccessible before we begin to perform irreversible operations. A failure after that will leave the database still partially present, but nothing can be done with it except to issue another DROP DATABASE.","title":"Avoid leaving a corrupted database behind when DROP DATABASE is interrupted","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["537b70b82","663b35f2d","c75c33de5","cb4ac3e56","cfc43aeb3","dbe0e5c56","f4691e2e7"],"commit_groups":[["537b70b82","663b35f2d","c75c33de5","cb4ac3e56","cfc43aeb3","dbe0e5c56","f4691e2e7"]],"commits":["cb4ac3e56"],"cves":[],"db_id":"2f1cce71fd84f222666907eaacdbb824","html":"\u003cp\u003eEnsure that partitioned indexes are correctly marked as valid or not at creation (Michael Paquier) \u003ca href=\"https://postgr.es/c/cb4ac3e56\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eIf a new partitioned index matches an existing but invalid index on one of the partitions, the partitioned index could end up being marked valid prematurely. This could lead to misbehavior or assertion failures in subsequent queries on the partitioned table.\u003c/p\u003e","id":"15.4-e17ec11ac9f95ac0","identity_text":"Ensure that partitioned indexes are correctly marked as valid or not at creation (Michael Paquier) If a new partitioned index matches an existing but invalid index on one of the partitions, the partitioned index could end up being marked valid prematurely. This could lead to misbehavior or assertion failures in subsequent queries on the partitioned table.","part":"changes","patch_ids":["405c2d4e234b31dfd4a7fc2992f60ed5"],"related_changes":[{"db_id":"72f9ee8a450e0fdabc5e0a6068bcd637","evidence":{"patch_ids":["405c2d4e234b31dfd4a7fc2992f60ed5"],"same_day":true,"statement_hash":"9e2b4dbad7d2d414bced58ea1c65258c434cb6df96396fc0dc070e473c8fdfc5"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Ensure that partitioned indexes are correctly marked as valid or not at creation","url":"/docs/compare/?release=14.9#14.9-23391a495c14e78b","version":"14.9"},{"db_id":"1f01376cbd13df07e7393a69cb30a5e1","evidence":{"patch_ids":["405c2d4e234b31dfd4a7fc2992f60ed5"],"same_day":true,"statement_hash":"9e2b4dbad7d2d414bced58ea1c65258c434cb6df96396fc0dc070e473c8fdfc5"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Ensure that partitioned indexes are correctly marked as valid or not at creation","url":"/docs/compare/?release=13.12#13.12-c4b4f1d4dd9ef0db","version":"13.12"},{"db_id":"b516a54d78d9a8327ab9f743eee9c4ce","evidence":{"patch_ids":["405c2d4e234b31dfd4a7fc2992f60ed5"],"same_day":true,"statement_hash":"9e2b4dbad7d2d414bced58ea1c65258c434cb6df96396fc0dc070e473c8fdfc5"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Ensure that partitioned indexes are correctly marked as valid or not at creation","url":"/docs/compare/?release=12.16#12.16-664a9c6409fbba88","version":"12.16"},{"db_id":"a6cb1831d983730abc579974f5ffd62e","evidence":{"patch_ids":["405c2d4e234b31dfd4a7fc2992f60ed5"],"same_day":true,"statement_hash":"9e2b4dbad7d2d414bced58ea1c65258c434cb6df96396fc0dc070e473c8fdfc5"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Ensure that partitioned indexes are correctly marked as valid or not at creation","url":"/docs/compare/?release=11.21#11.21-74edb6615e4c7df6","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["405c2d4e234b31dfd4a7fc2992f60ed5"],"same_day":true,"statement_hash":"9e2b4dbad7d2d414bced58ea1c65258c434cb6df96396fc0dc070e473c8fdfc5"},"rule":2,"target":"1f01376cbd13df07e7393a69cb30a5e1","type":"equivalent"},{"evidence":{"patch_ids":["405c2d4e234b31dfd4a7fc2992f60ed5"],"same_day":true,"statement_hash":"9e2b4dbad7d2d414bced58ea1c65258c434cb6df96396fc0dc070e473c8fdfc5"},"rule":2,"target":"72f9ee8a450e0fdabc5e0a6068bcd637","type":"equivalent"},{"evidence":{"patch_ids":["405c2d4e234b31dfd4a7fc2992f60ed5"],"same_day":true,"statement_hash":"9e2b4dbad7d2d414bced58ea1c65258c434cb6df96396fc0dc070e473c8fdfc5"},"rule":2,"target":"a6cb1831d983730abc579974f5ffd62e","type":"equivalent"},{"evidence":{"patch_ids":["405c2d4e234b31dfd4a7fc2992f60ed5"],"same_day":true,"statement_hash":"9e2b4dbad7d2d414bced58ea1c65258c434cb6df96396fc0dc070e473c8fdfc5"},"rule":2,"target":"b516a54d78d9a8327ab9f743eee9c4ce","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["cb4ac3e56"],"source_entry_id":"15.4/changes/005","source_hash":"6470e3ac39e8fef46cf417f717fa7887c6a776c8321350080913e5914793609f","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"9e2b4dbad7d2d414bced58ea1c65258c434cb6df96396fc0dc070e473c8fdfc5","text":"Ensure that partitioned indexes are correctly marked as valid or not at creation (Michael Paquier) § If a new partitioned index matches an existing but invalid index on one of the partitions, the partitioned index could end up being marked valid prematurely. This could lead to misbehavior or assertion failures in subsequent queries on the partitioned table.","title":"Ensure that partitioned indexes are correctly marked as valid or not at creation","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["6160e221d","63b292e73","7aa17b498","e90e9275f","f42844069","fc55c7ff8"],"commit_groups":[["6160e221d","63b292e73","7aa17b498","e90e9275f","f42844069","fc55c7ff8"]],"commits":["7aa17b498"],"cves":[],"db_id":"7db3a9e4fe3552005d5e3c4b3e85cc1e","html":"\u003cp\u003eIgnore invalid child indexes when matching partitioned indexes to child indexes during \u003ccode\u003eALTER TABLE ATTACH PARTITION\u003c/code\u003e (Michael Paquier) \u003ca href=\"https://postgr.es/c/7aa17b498\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eSuch an index will now be ignored, and a new child index created instead.\u003c/p\u003e","id":"15.4-1711c42d22b89f72","identity_text":"Ignore invalid child indexes when matching partitioned indexes to child indexes during ALTER TABLE ATTACH PARTITION (Michael Paquier) Such an index will now be ignored, and a new child index created instead.","part":"changes","patch_ids":["5b5839b1d237da8a07382b2aad037025"],"related_changes":[{"db_id":"19451ab9ffe34b7e1c649628113d80c9","evidence":{"patch_ids":["5b5839b1d237da8a07382b2aad037025"],"same_day":true,"statement_hash":"7e35e6978bcc5ff4df37fdb281dff58beebefdaa3550ecf671c4829f881c6034"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Ignore invalid child indexes when matching partitioned indexes to child indexes during ALTER TABLE ATTACH PARTITION","url":"/docs/compare/?release=14.9#14.9-2c2ad08c6863448a","version":"14.9"},{"db_id":"5303d949e3f9f743f72e15618d9ffb24","evidence":{"patch_ids":["5b5839b1d237da8a07382b2aad037025"],"same_day":true,"statement_hash":"7e35e6978bcc5ff4df37fdb281dff58beebefdaa3550ecf671c4829f881c6034"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Ignore invalid child indexes when matching partitioned indexes to child indexes during ALTER TABLE ATTACH PARTITION","url":"/docs/compare/?release=13.12#13.12-91adcf03c9da47e9","version":"13.12"},{"db_id":"b6be61b317cd1c448068d218b2e2f3cf","evidence":{"patch_ids":["5b5839b1d237da8a07382b2aad037025"],"same_day":true,"statement_hash":"7e35e6978bcc5ff4df37fdb281dff58beebefdaa3550ecf671c4829f881c6034"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Ignore invalid child indexes when matching partitioned indexes to child indexes during ALTER TABLE ATTACH PARTITION","url":"/docs/compare/?release=12.16#12.16-d49485ee25fe1c37","version":"12.16"},{"db_id":"f5b368ba16a4295aae7c91549f6528dc","evidence":{"patch_ids":["5b5839b1d237da8a07382b2aad037025"],"same_day":true,"statement_hash":"7e35e6978bcc5ff4df37fdb281dff58beebefdaa3550ecf671c4829f881c6034"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Ignore invalid child indexes when matching partitioned indexes to child indexes during ALTER TABLE ATTACH PARTITION","url":"/docs/compare/?release=11.21#11.21-ed8d2265f6fd20b6","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["5b5839b1d237da8a07382b2aad037025"],"same_day":true,"statement_hash":"7e35e6978bcc5ff4df37fdb281dff58beebefdaa3550ecf671c4829f881c6034"},"rule":2,"target":"19451ab9ffe34b7e1c649628113d80c9","type":"equivalent"},{"evidence":{"patch_ids":["5b5839b1d237da8a07382b2aad037025"],"same_day":true,"statement_hash":"7e35e6978bcc5ff4df37fdb281dff58beebefdaa3550ecf671c4829f881c6034"},"rule":2,"target":"5303d949e3f9f743f72e15618d9ffb24","type":"equivalent"},{"evidence":{"patch_ids":["5b5839b1d237da8a07382b2aad037025"],"same_day":true,"statement_hash":"7e35e6978bcc5ff4df37fdb281dff58beebefdaa3550ecf671c4829f881c6034"},"rule":2,"target":"b6be61b317cd1c448068d218b2e2f3cf","type":"equivalent"},{"evidence":{"patch_ids":["5b5839b1d237da8a07382b2aad037025"],"same_day":true,"statement_hash":"7e35e6978bcc5ff4df37fdb281dff58beebefdaa3550ecf671c4829f881c6034"},"rule":2,"target":"f5b368ba16a4295aae7c91549f6528dc","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["7aa17b498"],"source_entry_id":"15.4/changes/006","source_hash":"e257eb1bbc5a6181f582ec7282b697735f4f106589d70d3f8b8106ad6c696aa8","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"7e35e6978bcc5ff4df37fdb281dff58beebefdaa3550ecf671c4829f881c6034","text":"Ignore invalid child indexes when matching partitioned indexes to child indexes during ALTER TABLE ATTACH PARTITION (Michael Paquier) § Such an index will now be ignored, and a new child index created instead.","title":"Ignore invalid child indexes when matching partitioned indexes to child indexes during ALTER TABLE ATTACH PARTITION","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["31f9d41d6","38ea6aa90","954cc2139","c0dc97c7b","c89d74c18","ed2b58c15","f1d6bcdd8"],"commit_groups":[["31f9d41d6","38ea6aa90","954cc2139","c0dc97c7b","c89d74c18","ed2b58c15","f1d6bcdd8"]],"commits":["c0dc97c7b"],"cves":[],"db_id":"bb2aa5462487d25330c6fd6aa3a214ce","html":"\u003cp\u003eFix possible failure when marking a partitioned index valid after all of its partitions have been attached (Michael Paquier) \u003ca href=\"https://postgr.es/c/c0dc97c7b\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThe update of the index's \u003ccode\u003epg_index\u003c/code\u003e entry could use stale data for other columns. One reported symptom is an \u003cspan\u003e“\u003cspan\u003eattempted to update invisible tuple\u003c/span\u003e”\u003c/span\u003e error.\u003c/p\u003e","id":"15.4-4c4abb957905e6a9","identity_text":"Fix possible failure when marking a partitioned index valid after all of its partitions have been attached (Michael Paquier) The update of the index's pg_index entry could use stale data for other columns. One reported symptom is an attempted to update invisible tuple error.","part":"changes","patch_ids":["0839789bad3ba5e157fcbac6af6991f9"],"related_changes":[{"db_id":"5af2b222a4f40b592bc17f8629d7d7a6","evidence":{"patch_ids":["0839789bad3ba5e157fcbac6af6991f9"],"same_day":true,"statement_hash":"39ecebc872c0e01d20f0d17c8b07b5bbdc28d6ddc4d2b8217ce24d51bb6e321f"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Fix possible failure when marking a partitioned index valid after all of its partitions have been attached","url":"/docs/compare/?release=14.9#14.9-5249d06862a30ab4","version":"14.9"},{"db_id":"d50f495c4e556ab483bc7ede7963c4df","evidence":{"patch_ids":["0839789bad3ba5e157fcbac6af6991f9"],"same_day":true,"statement_hash":"39ecebc872c0e01d20f0d17c8b07b5bbdc28d6ddc4d2b8217ce24d51bb6e321f"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Fix possible failure when marking a partitioned index valid after all of its partitions have been attached","url":"/docs/compare/?release=13.12#13.12-4e10fd48a6e44c56","version":"13.12"},{"db_id":"595b19fa6c4adc4d0debb0ebfc3fcb8a","evidence":{"patch_ids":["0839789bad3ba5e157fcbac6af6991f9"],"same_day":true,"statement_hash":"39ecebc872c0e01d20f0d17c8b07b5bbdc28d6ddc4d2b8217ce24d51bb6e321f"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Fix possible failure when marking a partitioned index valid after all of its partitions have been attached","url":"/docs/compare/?release=12.16#12.16-1c1cef03e6a0caa5","version":"12.16"},{"db_id":"1ded5ac25852df0466006b18182129d0","evidence":{"patch_ids":["0839789bad3ba5e157fcbac6af6991f9"],"same_day":true,"statement_hash":"39ecebc872c0e01d20f0d17c8b07b5bbdc28d6ddc4d2b8217ce24d51bb6e321f"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Fix possible failure when marking a partitioned index valid after all of its partitions have been attached","url":"/docs/compare/?release=11.21#11.21-337616399ebba77d","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["0839789bad3ba5e157fcbac6af6991f9"],"same_day":true,"statement_hash":"39ecebc872c0e01d20f0d17c8b07b5bbdc28d6ddc4d2b8217ce24d51bb6e321f"},"rule":2,"target":"1ded5ac25852df0466006b18182129d0","type":"equivalent"},{"evidence":{"patch_ids":["0839789bad3ba5e157fcbac6af6991f9"],"same_day":true,"statement_hash":"39ecebc872c0e01d20f0d17c8b07b5bbdc28d6ddc4d2b8217ce24d51bb6e321f"},"rule":2,"target":"595b19fa6c4adc4d0debb0ebfc3fcb8a","type":"equivalent"},{"evidence":{"patch_ids":["0839789bad3ba5e157fcbac6af6991f9"],"same_day":true,"statement_hash":"39ecebc872c0e01d20f0d17c8b07b5bbdc28d6ddc4d2b8217ce24d51bb6e321f"},"rule":2,"target":"5af2b222a4f40b592bc17f8629d7d7a6","type":"equivalent"},{"evidence":{"patch_ids":["0839789bad3ba5e157fcbac6af6991f9"],"same_day":true,"statement_hash":"39ecebc872c0e01d20f0d17c8b07b5bbdc28d6ddc4d2b8217ce24d51bb6e321f"},"rule":2,"target":"d50f495c4e556ab483bc7ede7963c4df","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["c0dc97c7b"],"source_entry_id":"15.4/changes/007","source_hash":"79113537bd88e00c85ff04514dacb7cd1c6d2103ea92ee69199b41bca0c4325c","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"39ecebc872c0e01d20f0d17c8b07b5bbdc28d6ddc4d2b8217ce24d51bb6e321f","text":"Fix possible failure when marking a partitioned index valid after all of its partitions have been attached (Michael Paquier) § The update of the index's pg_index entry could use stale data for other columns. One reported symptom is an “attempted to update invisible tuple” error.","title":"Fix possible failure when marking a partitioned index valid after all of its partitions have been attached","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["02021f1b2","235e716bc","55c95f24c","914e72e6e","bd5ddbe86","d1e0f408c","f5b075adc"],"commit_groups":[["02021f1b2","235e716bc","55c95f24c","914e72e6e","bd5ddbe86","d1e0f408c","f5b075adc"]],"commits":["d1e0f408c"],"cves":[],"db_id":"ee572e2e78f4e94453e5a2c0d05c2787","html":"\u003cp\u003eFix \u003ccode\u003eALTER EXTENSION SET SCHEMA\u003c/code\u003e to complain if the extension contains any objects outside the extension's schema (Michael Paquier, Heikki Linnakangas) \u003ca href=\"https://postgr.es/c/d1e0f408c\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eErroring out if the extension contains objects in multiple schemas was always intended; but the check was mis-coded so that it would fail to detect some cases, leading to surprising behavior.\u003c/p\u003e","id":"15.4-54bad1819c5bb381","identity_text":"Fix ALTER EXTENSION SET SCHEMA to complain if the extension contains any objects outside the extension's schema (Michael Paquier, Heikki Linnakangas) Erroring out if the extension contains objects in multiple schemas was always intended; but the check was mis-coded so that it would fail to detect some cases, leading to surprising behavior.","part":"changes","patch_ids":["255d1f262a67d01dfc640fced2f0037d"],"related_changes":[{"db_id":"e0dceed4a03e1ebf0bc0e405f121201f","evidence":{"patch_ids":["255d1f262a67d01dfc640fced2f0037d"],"same_day":true,"statement_hash":"dbd71d5eaf563dab6a26fb79e6a94b5340c9294ffe5c77afd92769eb3bdf1389"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Fix ALTER EXTENSION SET SCHEMA to complain if the extension contains any objects outside the extension's schema","url":"/docs/compare/?release=14.9#14.9-fe4dce7bdf393bae","version":"14.9"},{"db_id":"e172161639ea39f4315e46286124faea","evidence":{"patch_ids":["255d1f262a67d01dfc640fced2f0037d"],"same_day":true,"statement_hash":"dbd71d5eaf563dab6a26fb79e6a94b5340c9294ffe5c77afd92769eb3bdf1389"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Fix ALTER EXTENSION SET SCHEMA to complain if the extension contains any objects outside the extension's schema","url":"/docs/compare/?release=13.12#13.12-29d076668929da6a","version":"13.12"},{"db_id":"f5a835497f9cfa508c293c67a80f1816","evidence":{"patch_ids":["255d1f262a67d01dfc640fced2f0037d"],"same_day":true,"statement_hash":"dbd71d5eaf563dab6a26fb79e6a94b5340c9294ffe5c77afd92769eb3bdf1389"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Fix ALTER EXTENSION SET SCHEMA to complain if the extension contains any objects outside the extension's schema","url":"/docs/compare/?release=12.16#12.16-72554a2aa1e7909d","version":"12.16"},{"db_id":"de8bad652152a2517920f970a3e432ff","evidence":{"patch_ids":["255d1f262a67d01dfc640fced2f0037d"],"same_day":true,"statement_hash":"dbd71d5eaf563dab6a26fb79e6a94b5340c9294ffe5c77afd92769eb3bdf1389"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Fix ALTER EXTENSION SET SCHEMA to complain if the extension contains any objects outside the extension's schema","url":"/docs/compare/?release=11.21#11.21-f1c55a5d7a05eae6","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["255d1f262a67d01dfc640fced2f0037d"],"same_day":true,"statement_hash":"dbd71d5eaf563dab6a26fb79e6a94b5340c9294ffe5c77afd92769eb3bdf1389"},"rule":2,"target":"de8bad652152a2517920f970a3e432ff","type":"equivalent"},{"evidence":{"patch_ids":["255d1f262a67d01dfc640fced2f0037d"],"same_day":true,"statement_hash":"dbd71d5eaf563dab6a26fb79e6a94b5340c9294ffe5c77afd92769eb3bdf1389"},"rule":2,"target":"e0dceed4a03e1ebf0bc0e405f121201f","type":"equivalent"},{"evidence":{"patch_ids":["255d1f262a67d01dfc640fced2f0037d"],"same_day":true,"statement_hash":"dbd71d5eaf563dab6a26fb79e6a94b5340c9294ffe5c77afd92769eb3bdf1389"},"rule":2,"target":"e172161639ea39f4315e46286124faea","type":"equivalent"},{"evidence":{"patch_ids":["255d1f262a67d01dfc640fced2f0037d"],"same_day":true,"statement_hash":"dbd71d5eaf563dab6a26fb79e6a94b5340c9294ffe5c77afd92769eb3bdf1389"},"rule":2,"target":"f5a835497f9cfa508c293c67a80f1816","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["d1e0f408c"],"source_entry_id":"15.4/changes/008","source_hash":"63e4210d4cc9eafc48525f4ed7aa5d7d19f443cc934b25b5b4ced63cf1aafa0d","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"dbd71d5eaf563dab6a26fb79e6a94b5340c9294ffe5c77afd92769eb3bdf1389","text":"Fix ALTER EXTENSION SET SCHEMA to complain if the extension contains any objects outside the extension's schema (Michael Paquier, Heikki Linnakangas) § Erroring out if the extension contains objects in multiple schemas was always intended; but the check was mis-coded so that it would fail to detect some cases, leading to surprising behavior.","title":"Fix ALTER EXTENSION SET SCHEMA to complain if the extension contains any objects outside the extension's schema","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["93401ec02","97d891010"],"commit_groups":[["93401ec02","97d891010"]],"commits":["93401ec02"],"cves":[],"db_id":"fb3e3860b973f8338c38ff8dbe3a21c1","html":"\u003cp\u003eFix tracking of tables' access method dependencies (Michael Paquier) \u003ca href=\"https://postgr.es/c/93401ec02\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003e\u003ccode\u003eALTER TABLE ... SET ACCESS METHOD\u003c/code\u003e failed to update relevant \u003ccode\u003epg_depend\u003c/code\u003e entries when changing a table's access method. When using non-built-in access methods, this creates a risk that an access method could be dropped even though tables still depend on it. This fix corrects the logic in \u003ccode\u003eALTER TABLE\u003c/code\u003e, but it will not adjust any already-missing \u003ccode\u003epg_depend\u003c/code\u003e entries.\u003c/p\u003e","id":"15.4-e656246161b29c42","identity_text":"Fix tracking of tables' access method dependencies (Michael Paquier) ALTER TABLE ... SET ACCESS METHOD failed to update relevant pg_depend entries when changing a table's access method. When using non-built-in access methods, this creates a risk that an access method could be dropped even though tables still depend on it. This fix corrects the logic in ALTER TABLE, but it will not adjust any already-missing pg_depend entries.","part":"changes","patch_ids":["ec6fa91603dbd87485ae21d02fae5057"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["93401ec02"],"source_entry_id":"15.4/changes/009","source_hash":"d60f56ad4bce8feb263ef7b8535dac1de992da717aa2f7c341a3815e2dd5f66d","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"299a875df70c71f5785187d781e30aa7352d3425b151d8f733ca97f2bac5408c","text":"Fix tracking of tables' access method dependencies (Michael Paquier) § ALTER TABLE ... SET ACCESS METHOD failed to update relevant pg_depend entries when changing a table's access method. When using non-built-in access methods, this creates a risk that an access method could be dropped even though tables still depend on it. This fix corrects the logic in ALTER TABLE, but it will not adjust any already-missing pg_depend entries.","title":"Fix tracking of tables' access method dependencies","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["06286f8a2","73f1c17fc","7fcd7ef2a","8f2ec8cc7","dcef5b052","f6345f03f"],"commit_groups":[["06286f8a2","73f1c17fc","7fcd7ef2a","8f2ec8cc7","dcef5b052","f6345f03f"]],"commits":["8f2ec8cc7"],"cves":[],"db_id":"dae596a0e523920e98e3aa3f6f64e748","html":"\u003cp\u003eDon't use partial unique indexes for uniqueness proofs in the planner (David Rowley) \u003ca href=\"https://postgr.es/c/8f2ec8cc7\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThis could give rise to incorrect plans, since the presumed uniqueness of rows read from a table might not hold if the index in question isn't used to scan the table.\u003c/p\u003e","id":"15.4-23bb86304490eb79","identity_text":"Don't use partial unique indexes for uniqueness proofs in the planner (David Rowley) This could give rise to incorrect plans, since the presumed uniqueness of rows read from a table might not hold if the index in question isn't used to scan the table.","part":"changes","patch_ids":["5afba1ce4cc69cc7e323fb1344fef312"],"related_changes":[{"db_id":"cc2306529c3a6971c1b90c20685a73c2","evidence":{"patch_ids":["5afba1ce4cc69cc7e323fb1344fef312"],"same_day":true,"statement_hash":"9ad02600c88cc5bc08a077a3c14df97ff15c1de9cf28c99c027dfdd631004db1"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Don't use partial unique indexes for uniqueness proofs in the planner","url":"/docs/compare/?release=14.9#14.9-3b1afded1691c1bd","version":"14.9"},{"db_id":"98cf114994cd59d18c8227e4df5bfac1","evidence":{"patch_ids":["5afba1ce4cc69cc7e323fb1344fef312"],"same_day":true,"statement_hash":"9ad02600c88cc5bc08a077a3c14df97ff15c1de9cf28c99c027dfdd631004db1"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Don't use partial unique indexes for uniqueness proofs in the planner","url":"/docs/compare/?release=13.12#13.12-5438b35bbfdcd1c0","version":"13.12"},{"db_id":"349d7f9017aaf8b9256d64ef6816ab78","evidence":{"patch_ids":["5afba1ce4cc69cc7e323fb1344fef312"],"same_day":true,"statement_hash":"9ad02600c88cc5bc08a077a3c14df97ff15c1de9cf28c99c027dfdd631004db1"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Don't use partial unique indexes for uniqueness proofs in the planner","url":"/docs/compare/?release=12.16#12.16-851daa9592e048c3","version":"12.16"},{"db_id":"366547fc23d4fc6b1e42aa62a1328f90","evidence":{"patch_ids":["5afba1ce4cc69cc7e323fb1344fef312"],"same_day":true,"statement_hash":"9ad02600c88cc5bc08a077a3c14df97ff15c1de9cf28c99c027dfdd631004db1"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Don't use partial unique indexes for uniqueness proofs in the planner","url":"/docs/compare/?release=11.21#11.21-1a7026fe4ee069e5","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["5afba1ce4cc69cc7e323fb1344fef312"],"same_day":true,"statement_hash":"9ad02600c88cc5bc08a077a3c14df97ff15c1de9cf28c99c027dfdd631004db1"},"rule":2,"target":"349d7f9017aaf8b9256d64ef6816ab78","type":"equivalent"},{"evidence":{"patch_ids":["5afba1ce4cc69cc7e323fb1344fef312"],"same_day":true,"statement_hash":"9ad02600c88cc5bc08a077a3c14df97ff15c1de9cf28c99c027dfdd631004db1"},"rule":2,"target":"366547fc23d4fc6b1e42aa62a1328f90","type":"equivalent"},{"evidence":{"patch_ids":["5afba1ce4cc69cc7e323fb1344fef312"],"same_day":true,"statement_hash":"9ad02600c88cc5bc08a077a3c14df97ff15c1de9cf28c99c027dfdd631004db1"},"rule":2,"target":"98cf114994cd59d18c8227e4df5bfac1","type":"equivalent"},{"evidence":{"patch_ids":["5afba1ce4cc69cc7e323fb1344fef312"],"same_day":true,"statement_hash":"9ad02600c88cc5bc08a077a3c14df97ff15c1de9cf28c99c027dfdd631004db1"},"rule":2,"target":"cc2306529c3a6971c1b90c20685a73c2","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["8f2ec8cc7"],"source_entry_id":"15.4/changes/010","source_hash":"f1690f26e67ab770d6ba9c4a74ab6b9362e9b9823e8cddf1ae22f5c66c84f22e","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"9ad02600c88cc5bc08a077a3c14df97ff15c1de9cf28c99c027dfdd631004db1","text":"Don't use partial unique indexes for uniqueness proofs in the planner (David Rowley) § This could give rise to incorrect plans, since the presumed uniqueness of rows read from a table might not hold if the index in question isn't used to scan the table.","title":"Don't use partial unique indexes for uniqueness proofs in the planner","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["71662373b","990c3650c","ae89129aa","bf315354e"],"commit_groups":[["71662373b","990c3650c","ae89129aa","bf315354e"]],"commits":["71662373b"],"cves":[],"db_id":"e15aa378d3a67c404640867c12b96067","html":"\u003cp\u003eDon't Memoize lateral joins with volatile join conditions (Richard Guo) \u003ca href=\"https://postgr.es/c/71662373b\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eApplying Memoize to a sub-plan that contains volatile filter conditions is likely to lead to wrong answers. The check to avoid doing this missed some cases that can arise when using \u003ccode\u003eLATERAL\u003c/code\u003e.\u003c/p\u003e","id":"15.4-2025b1523a216e42","identity_text":"Don't Memoize lateral joins with volatile join conditions (Richard Guo) Applying Memoize to a sub-plan that contains volatile filter conditions is likely to lead to wrong answers. The check to avoid doing this missed some cases that can arise when using LATERAL.","part":"changes","patch_ids":["15e0c1bdd4939b00e87b039816997f45"],"related_changes":[{"db_id":"9657cc0ec6ed1a0cab15aa9b4846aed2","evidence":{"patch_ids":["15e0c1bdd4939b00e87b039816997f45"],"same_day":true,"statement_hash":"fd36b842aadbb861ca6ad75c63bec5557718595c207372b396f750d8aad617ac"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Don't Memoize lateral joins with volatile join conditions","url":"/docs/compare/?release=14.9#14.9-94ff03e82d7e370c","version":"14.9"}],"relations":[{"evidence":{"patch_ids":["15e0c1bdd4939b00e87b039816997f45"],"same_day":true,"statement_hash":"fd36b842aadbb861ca6ad75c63bec5557718595c207372b396f750d8aad617ac"},"rule":2,"target":"9657cc0ec6ed1a0cab15aa9b4846aed2","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["71662373b"],"source_entry_id":"15.4/changes/011","source_hash":"54e1b7b0354074235980cb0c899c36006048d0561be143ad8b4a9df36dd8f90a","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"fd36b842aadbb861ca6ad75c63bec5557718595c207372b396f750d8aad617ac","text":"Don't Memoize lateral joins with volatile join conditions (Richard Guo) § Applying Memoize to a sub-plan that contains volatile filter conditions is likely to lead to wrong answers. The check to avoid doing this missed some cases that can arise when using LATERAL.","title":"Don't Memoize lateral joins with volatile join conditions","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["695f5deb7","6f80a8d9c","730f983ef","9edf72aa7","b0e390e6d","d1ef5631e","db01f2696"],"commit_groups":[["695f5deb7","6f80a8d9c","730f983ef","9edf72aa7","b0e390e6d","d1ef5631e","db01f2696"]],"commits":["d1ef5631e"],"cves":[],"db_id":"bf6ab4bf95c50bdff1de6312f9bdd33b","html":"\u003cp\u003eAvoid producing incorrect plans for foreign joins with pseudoconstant join clauses (Etsuro Fujita) \u003ca href=\"https://postgr.es/c/d1ef5631e\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThe planner currently lacks support for attaching pseudoconstant join clauses to a pushed-down remote join, so disable generation of remote joins in such cases. (A better solution will require ABI-breaking changes of planner data structures, so it will have to wait for a future major release.)\u003c/p\u003e","id":"15.4-97a659521f1258cf","identity_text":"Avoid producing incorrect plans for foreign joins with pseudoconstant join clauses (Etsuro Fujita) The planner currently lacks support for attaching pseudoconstant join clauses to a pushed-down remote join, so disable generation of remote joins in such cases. (A better solution will require ABI-breaking changes of planner data structures, so it will have to wait for a future major release.)","part":"changes","patch_ids":["e6c08c6d547d51143066c7f07d8502af"],"related_changes":[{"db_id":"248f46710f7b484572f953eb1f738125","evidence":{"patch_ids":["e6c08c6d547d51143066c7f07d8502af"],"same_day":true,"statement_hash":"8754d1ab51fe9cd86e7958f9f808235defe2e0f71736edd8c01debd820b36a1a"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Avoid producing incorrect plans for foreign joins with pseudoconstant join clauses","url":"/docs/compare/?release=14.9#14.9-ab3d99f72b4cc541","version":"14.9"},{"db_id":"eabb933b406335e4d506383e550c707b","evidence":{"patch_ids":["e6c08c6d547d51143066c7f07d8502af"],"same_day":true,"statement_hash":"8754d1ab51fe9cd86e7958f9f808235defe2e0f71736edd8c01debd820b36a1a"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Avoid producing incorrect plans for foreign joins with pseudoconstant join clauses","url":"/docs/compare/?release=13.12#13.12-8e08d9120f28cde9","version":"13.12"},{"db_id":"03adba3f4b7e31f4e1dd9d5c7ec6cb25","evidence":{"patch_ids":["e6c08c6d547d51143066c7f07d8502af"],"same_day":true,"statement_hash":"8754d1ab51fe9cd86e7958f9f808235defe2e0f71736edd8c01debd820b36a1a"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Avoid producing incorrect plans for foreign joins with pseudoconstant join clauses","url":"/docs/compare/?release=12.16#12.16-adfbcb77b96d8335","version":"12.16"},{"db_id":"0ad52b2709466527f18cb8accbe58f01","evidence":{"patch_ids":["e6c08c6d547d51143066c7f07d8502af"],"same_day":true,"statement_hash":"8754d1ab51fe9cd86e7958f9f808235defe2e0f71736edd8c01debd820b36a1a"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Avoid producing incorrect plans for foreign joins with pseudoconstant join clauses","url":"/docs/compare/?release=11.21#11.21-952f5e5f1a4a0048","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["e6c08c6d547d51143066c7f07d8502af"],"same_day":true,"statement_hash":"8754d1ab51fe9cd86e7958f9f808235defe2e0f71736edd8c01debd820b36a1a"},"rule":2,"target":"03adba3f4b7e31f4e1dd9d5c7ec6cb25","type":"equivalent"},{"evidence":{"patch_ids":["e6c08c6d547d51143066c7f07d8502af"],"same_day":true,"statement_hash":"8754d1ab51fe9cd86e7958f9f808235defe2e0f71736edd8c01debd820b36a1a"},"rule":2,"target":"0ad52b2709466527f18cb8accbe58f01","type":"equivalent"},{"evidence":{"patch_ids":["e6c08c6d547d51143066c7f07d8502af"],"same_day":true,"statement_hash":"8754d1ab51fe9cd86e7958f9f808235defe2e0f71736edd8c01debd820b36a1a"},"rule":2,"target":"248f46710f7b484572f953eb1f738125","type":"equivalent"},{"evidence":{"patch_ids":["e6c08c6d547d51143066c7f07d8502af"],"same_day":true,"statement_hash":"8754d1ab51fe9cd86e7958f9f808235defe2e0f71736edd8c01debd820b36a1a"},"rule":2,"target":"eabb933b406335e4d506383e550c707b","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["d1ef5631e"],"source_entry_id":"15.4/changes/012","source_hash":"76c594137e8a00625b7f936dbca16ebd56672dabd516598895c98930546efc6d","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"8754d1ab51fe9cd86e7958f9f808235defe2e0f71736edd8c01debd820b36a1a","text":"Avoid producing incorrect plans for foreign joins with pseudoconstant join clauses (Etsuro Fujita) § The planner currently lacks support for attaching pseudoconstant join clauses to a pushed-down remote join, so disable generation of remote joins in such cases. (A better solution will require ABI-breaking changes of planner data structures, so it will have to wait for a future major release.)","title":"Avoid producing incorrect plans for foreign joins with pseudoconstant join clauses","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["13192a324","792213f2e","a36d0014f","b4110bdbf","cc6974df1","d1423c52e"],"commit_groups":[["13192a324","792213f2e","a36d0014f","b4110bdbf","cc6974df1","d1423c52e"]],"commits":["cc6974df1"],"cves":[],"db_id":"7a2a3579a4515ef7d4074a28f62df14c","html":"\u003cp\u003eCorrectly handle sub-SELECTs in RLS policy expressions and security-barrier views when expanding rule actions (Tom Lane) \u003ca href=\"https://postgr.es/c/cc6974df1\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"15.4-8cef627212e99c40","identity_text":"Correctly handle sub-SELECTs in RLS policy expressions and security-barrier views when expanding rule actions (Tom Lane)","part":"changes","patch_ids":["87e5e637be2c84959550d4791a8a9a74"],"related_changes":[{"db_id":"ddd3e336c70ed38381f9b3ee9044e700","evidence":{"patch_ids":["87e5e637be2c84959550d4791a8a9a74"],"same_day":true,"statement_hash":"b8199d11cd0af526d9543c60563499d60722d7231613b4b60dd15fc9c5aa6f5f"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Correctly handle sub-SELECTs in RLS policy expressions and security-barrier views when expanding rule actions","url":"/docs/compare/?release=14.9#14.9-e65124a26c453b90","version":"14.9"},{"db_id":"6f926f1b8b91c542be33729c45060533","evidence":{"patch_ids":["87e5e637be2c84959550d4791a8a9a74"],"same_day":true,"statement_hash":"b8199d11cd0af526d9543c60563499d60722d7231613b4b60dd15fc9c5aa6f5f"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Correctly handle sub-SELECTs in RLS policy expressions and security-barrier views when expanding rule actions","url":"/docs/compare/?release=13.12#13.12-3a7d9526af7cba3a","version":"13.12"},{"db_id":"9dba8314c6f153a985b063fcdfae0be0","evidence":{"patch_ids":["87e5e637be2c84959550d4791a8a9a74"],"same_day":true,"statement_hash":"b8199d11cd0af526d9543c60563499d60722d7231613b4b60dd15fc9c5aa6f5f"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Correctly handle sub-SELECTs in RLS policy expressions and security-barrier views when expanding rule actions","url":"/docs/compare/?release=12.16#12.16-84d20c79549276d3","version":"12.16"},{"db_id":"654faad5c860e3eee5520bc62c44b6b0","evidence":{"patch_ids":["87e5e637be2c84959550d4791a8a9a74"],"same_day":true,"statement_hash":"b8199d11cd0af526d9543c60563499d60722d7231613b4b60dd15fc9c5aa6f5f"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Correctly handle sub-SELECTs in RLS policy expressions and security-barrier views when expanding rule actions","url":"/docs/compare/?release=11.21#11.21-8c467ed6a8203efa","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["87e5e637be2c84959550d4791a8a9a74"],"same_day":true,"statement_hash":"b8199d11cd0af526d9543c60563499d60722d7231613b4b60dd15fc9c5aa6f5f"},"rule":2,"target":"654faad5c860e3eee5520bc62c44b6b0","type":"equivalent"},{"evidence":{"patch_ids":["87e5e637be2c84959550d4791a8a9a74"],"same_day":true,"statement_hash":"b8199d11cd0af526d9543c60563499d60722d7231613b4b60dd15fc9c5aa6f5f"},"rule":2,"target":"6f926f1b8b91c542be33729c45060533","type":"equivalent"},{"evidence":{"patch_ids":["87e5e637be2c84959550d4791a8a9a74"],"same_day":true,"statement_hash":"b8199d11cd0af526d9543c60563499d60722d7231613b4b60dd15fc9c5aa6f5f"},"rule":2,"target":"9dba8314c6f153a985b063fcdfae0be0","type":"equivalent"},{"evidence":{"patch_ids":["87e5e637be2c84959550d4791a8a9a74"],"same_day":true,"statement_hash":"b8199d11cd0af526d9543c60563499d60722d7231613b4b60dd15fc9c5aa6f5f"},"rule":2,"target":"ddd3e336c70ed38381f9b3ee9044e700","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["cc6974df1"],"source_entry_id":"15.4/changes/013","source_hash":"489dbaeb7fa38abdc55c71467038ba923a60c5ad3316a69532aee9e89a961efc","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"b8199d11cd0af526d9543c60563499d60722d7231613b4b60dd15fc9c5aa6f5f","text":"Correctly handle sub-SELECTs in RLS policy expressions and security-barrier views when expanding rule actions (Tom Lane) §","title":"Correctly handle sub-SELECTs in RLS policy expressions and security-barrier views when expanding rule actions","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["0048c3b51","0cb1fb2c9","0f275b0ee","12529028a","126552c85","13f127800","17b8887c2","255a925d3","3f7d3a77e","814f3c8e4","8976ac5c5","8f705d7b9","ab265e985","ae6d536ed","bcc93a389","d03d9a261","d34aa0a2f","f9b7fc651","fb663f387","fc1547384","fe88497b4"],"commit_groups":[["0048c3b51","0cb1fb2c9","0f275b0ee","8f705d7b9","ae6d536ed","f9b7fc651","fe88497b4"],["12529028a","126552c85","13f127800","255a925d3","d34aa0a2f","fb663f387","fc1547384"],["17b8887c2","3f7d3a77e","814f3c8e4","8976ac5c5","ab265e985","bcc93a389","d03d9a261"]],"commits":["0f275b0ee","ab265e985","d34aa0a2f"],"cves":[],"db_id":"8f755eef006413880f27be47c33eb2b9","html":"\u003cp\u003eFix race conditions in conflict detection for \u003ccode\u003eSERIALIZABLE\u003c/code\u003e isolation mode (Thomas Munro) \u003ca href=\"https://postgr.es/c/d34aa0a2f\"\u003e§\u003c/a\u003e \u003ca href=\"https://postgr.es/c/ab265e985\"\u003e§\u003c/a\u003e \u003ca href=\"https://postgr.es/c/0f275b0ee\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eConflicts could be missed when using bitmap heap scans, when using GIN indexes, and when examining an initially-empty btree index. All these cases could lead to serializability failures due to improperly allowing conflicting transactions to commit.\u003c/p\u003e","id":"15.4-28c1ddb26ed27195","identity_text":"Fix race conditions in conflict detection for SERIALIZABLE isolation mode (Thomas Munro) Conflicts could be missed when using bitmap heap scans, when using GIN indexes, and when examining an initially-empty btree index. All these cases could lead to serializability failures due to improperly allowing conflicting transactions to commit.","part":"changes","patch_ids":["33733f0d75b3592e3c72db8cc1874a87","a83ca373b807defc3810c75de4fb1436","abb352b1f2a1704bd847ce368df8cadc"],"related_changes":[{"db_id":"b5671ea6a0618a2828055dbb8a059ad7","evidence":{"patch_ids":["33733f0d75b3592e3c72db8cc1874a87","a83ca373b807defc3810c75de4fb1436","abb352b1f2a1704bd847ce368df8cadc"],"same_day":true,"statement_hash":"be3e194e578eb6aabccabec8d8d2cc1b681792086b817c48b2add704b6424311"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Fix race conditions in conflict detection for SERIALIZABLE isolation mode","url":"/docs/compare/?release=14.9#14.9-3183d0ef06d07cfd","version":"14.9"},{"db_id":"78e330af3d5c6df297cc91602fad1de7","evidence":{"patch_ids":["33733f0d75b3592e3c72db8cc1874a87","a83ca373b807defc3810c75de4fb1436","abb352b1f2a1704bd847ce368df8cadc"],"same_day":true,"statement_hash":"be3e194e578eb6aabccabec8d8d2cc1b681792086b817c48b2add704b6424311"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Fix race conditions in conflict detection for SERIALIZABLE isolation mode","url":"/docs/compare/?release=13.12#13.12-80a7769d2d0c9b98","version":"13.12"},{"db_id":"d6fd42d045943f958886f18f139278ba","evidence":{"patch_ids":["33733f0d75b3592e3c72db8cc1874a87","a83ca373b807defc3810c75de4fb1436","abb352b1f2a1704bd847ce368df8cadc"],"same_day":true,"statement_hash":"be3e194e578eb6aabccabec8d8d2cc1b681792086b817c48b2add704b6424311"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Fix race conditions in conflict detection for SERIALIZABLE isolation mode","url":"/docs/compare/?release=12.16#12.16-43dad0cd22873c15","version":"12.16"},{"db_id":"ee2d689288b7738398bde54d793a757b","evidence":{"patch_ids":["33733f0d75b3592e3c72db8cc1874a87","a83ca373b807defc3810c75de4fb1436","abb352b1f2a1704bd847ce368df8cadc"],"same_day":true,"statement_hash":"be3e194e578eb6aabccabec8d8d2cc1b681792086b817c48b2add704b6424311"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Fix race conditions in conflict detection for SERIALIZABLE isolation mode","url":"/docs/compare/?release=11.21#11.21-9d2742618d728b77","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["33733f0d75b3592e3c72db8cc1874a87","a83ca373b807defc3810c75de4fb1436","abb352b1f2a1704bd847ce368df8cadc"],"same_day":true,"statement_hash":"be3e194e578eb6aabccabec8d8d2cc1b681792086b817c48b2add704b6424311"},"rule":2,"target":"78e330af3d5c6df297cc91602fad1de7","type":"equivalent"},{"evidence":{"patch_ids":["33733f0d75b3592e3c72db8cc1874a87","a83ca373b807defc3810c75de4fb1436","abb352b1f2a1704bd847ce368df8cadc"],"same_day":true,"statement_hash":"be3e194e578eb6aabccabec8d8d2cc1b681792086b817c48b2add704b6424311"},"rule":2,"target":"b5671ea6a0618a2828055dbb8a059ad7","type":"equivalent"},{"evidence":{"patch_ids":["33733f0d75b3592e3c72db8cc1874a87","a83ca373b807defc3810c75de4fb1436","abb352b1f2a1704bd847ce368df8cadc"],"same_day":true,"statement_hash":"be3e194e578eb6aabccabec8d8d2cc1b681792086b817c48b2add704b6424311"},"rule":2,"target":"d6fd42d045943f958886f18f139278ba","type":"equivalent"},{"evidence":{"patch_ids":["33733f0d75b3592e3c72db8cc1874a87","a83ca373b807defc3810c75de4fb1436","abb352b1f2a1704bd847ce368df8cadc"],"same_day":true,"statement_hash":"be3e194e578eb6aabccabec8d8d2cc1b681792086b817c48b2add704b6424311"},"rule":2,"target":"ee2d689288b7738398bde54d793a757b","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["0f275b0ee","ab265e985","d34aa0a2f"],"source_entry_id":"15.4/changes/014","source_hash":"6632c6756a1cdd87829200993a0605aac000bd84860616602344e724a4e6d840","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"be3e194e578eb6aabccabec8d8d2cc1b681792086b817c48b2add704b6424311","text":"Fix race conditions in conflict detection for SERIALIZABLE isolation mode (Thomas Munro) § § § Conflicts could be missed when using bitmap heap scans, when using GIN indexes, and when examining an initially-empty btree index. All these cases could lead to serializability failures due to improperly allowing conflicting transactions to commit.","title":"Fix race conditions in conflict detection for SERIALIZABLE isolation mode","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["4729d1e8a","70b42f279","f8320cc72"],"commit_groups":[["4729d1e8a","70b42f279","f8320cc72"]],"commits":["4729d1e8a"],"cves":[],"db_id":"761a5282cc19ba233f531b991de45209","html":"\u003cp\u003eFix misbehavior of EvalPlanQual checks with inherited or partitioned target tables (Tom Lane) \u003ca href=\"https://postgr.es/c/4729d1e8a\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThis oversight could lead to update or delete actions in \u003ccode\u003eREAD COMMITTED\u003c/code\u003e isolation mode getting performed when they should have been skipped because of a conflicting concurrent update.\u003c/p\u003e","id":"15.4-c88df69079c17939","identity_text":"Fix misbehavior of EvalPlanQual checks with inherited or partitioned target tables (Tom Lane) This oversight could lead to update or delete actions in READ COMMITTED isolation mode getting performed when they should have been skipped because of a conflicting concurrent update.","part":"changes","patch_ids":["b50c35f95954ec716e75e57e80f8ec90"],"related_changes":[{"db_id":"bfff5b7b59d460d93874c0eecd921592","evidence":{"patch_ids":["b50c35f95954ec716e75e57e80f8ec90"],"same_day":true,"statement_hash":"9d3a7dad16d098f233902e0836602ec6df41e3f25bf6a11509775ea2b40dd9fe"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Fix misbehavior of EvalPlanQual checks with inherited or partitioned target tables","url":"/docs/compare/?release=14.9#14.9-bfb22d390eb1ad2a","version":"14.9"}],"relations":[{"evidence":{"patch_ids":["b50c35f95954ec716e75e57e80f8ec90"],"same_day":true,"statement_hash":"9d3a7dad16d098f233902e0836602ec6df41e3f25bf6a11509775ea2b40dd9fe"},"rule":2,"target":"bfff5b7b59d460d93874c0eecd921592","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["4729d1e8a"],"source_entry_id":"15.4/changes/015","source_hash":"0228a1cbb5db7de172bb31bd8061279759fe9c9c7a8ec5c4a7c38fe838b6f0b1","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"9d3a7dad16d098f233902e0836602ec6df41e3f25bf6a11509775ea2b40dd9fe","text":"Fix misbehavior of EvalPlanQual checks with inherited or partitioned target tables (Tom Lane) § This oversight could lead to update or delete actions in READ COMMITTED isolation mode getting performed when they should have been skipped because of a conflicting concurrent update.","title":"Fix misbehavior of EvalPlanQual checks with inherited or partitioned target tables","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["2f97105e9","45392626c","9529b1eb1","c2f974fff","d911dce14"],"commit_groups":[["2f97105e9","45392626c","9529b1eb1","c2f974fff","d911dce14"]],"commits":["c2f974fff"],"cves":[],"db_id":"77d0a5e57043f62f908737de1bfd2073","html":"\u003cp\u003eFix hash join with an inner-side hash key that contains Params coming from an outer nested loop (Tom Lane) \u003ca href=\"https://postgr.es/c/c2f974fff\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eWhen rescanning the join after the values of such Params have changed, we must rebuild the hash table, but neglected to do so. This could result in missing join output rows.\u003c/p\u003e","id":"15.4-96de7f01a81340a9","identity_text":"Fix hash join with an inner-side hash key that contains Params coming from an outer nested loop (Tom Lane) When rescanning the join after the values of such Params have changed, we must rebuild the hash table, but neglected to do so. This could result in missing join output rows.","part":"changes","patch_ids":["14fa05caf16db0ec9c1b252ed430f545"],"related_changes":[{"db_id":"d8f1f52cd378b80d13c186ca2217e0f6","evidence":{"patch_ids":["14fa05caf16db0ec9c1b252ed430f545"],"same_day":true,"statement_hash":"fa9d6484ab97286bb7e19be3ef7103d3261a1747e010cadcf44047fb5d2806ee"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Fix hash join with an inner-side hash key that contains Params coming from an outer nested loop","url":"/docs/compare/?release=14.9#14.9-41e55e410bf1bac1","version":"14.9"},{"db_id":"bf698cb034fdc37f684d81bb251c3e9c","evidence":{"patch_ids":["14fa05caf16db0ec9c1b252ed430f545"],"same_day":true,"statement_hash":"fa9d6484ab97286bb7e19be3ef7103d3261a1747e010cadcf44047fb5d2806ee"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Fix hash join with an inner-side hash key that contains Params coming from an outer nested loop","url":"/docs/compare/?release=13.12#13.12-b4dd111f12242718","version":"13.12"},{"db_id":"131d6bcee186ed0dc03d13933d4440c2","evidence":{"patch_ids":["14fa05caf16db0ec9c1b252ed430f545"],"same_day":true,"statement_hash":"fa9d6484ab97286bb7e19be3ef7103d3261a1747e010cadcf44047fb5d2806ee"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Fix hash join with an inner-side hash key that contains Params coming from an outer nested loop","url":"/docs/compare/?release=12.16#12.16-bba531bb619e20c7","version":"12.16"}],"relations":[{"evidence":{"patch_ids":["14fa05caf16db0ec9c1b252ed430f545"],"same_day":true,"statement_hash":"fa9d6484ab97286bb7e19be3ef7103d3261a1747e010cadcf44047fb5d2806ee"},"rule":2,"target":"131d6bcee186ed0dc03d13933d4440c2","type":"equivalent"},{"evidence":{"patch_ids":["14fa05caf16db0ec9c1b252ed430f545"],"same_day":true,"statement_hash":"fa9d6484ab97286bb7e19be3ef7103d3261a1747e010cadcf44047fb5d2806ee"},"rule":2,"target":"bf698cb034fdc37f684d81bb251c3e9c","type":"equivalent"},{"evidence":{"patch_ids":["14fa05caf16db0ec9c1b252ed430f545"],"same_day":true,"statement_hash":"fa9d6484ab97286bb7e19be3ef7103d3261a1747e010cadcf44047fb5d2806ee"},"rule":2,"target":"d8f1f52cd378b80d13c186ca2217e0f6","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["c2f974fff"],"source_entry_id":"15.4/changes/016","source_hash":"ef30a09cbace073323e856e781f180ee76fe517acb66929811e2d34506603543","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"fa9d6484ab97286bb7e19be3ef7103d3261a1747e010cadcf44047fb5d2806ee","text":"Fix hash join with an inner-side hash key that contains Params coming from an outer nested loop (Tom Lane) § When rescanning the join after the values of such Params have changed, we must rebuild the hash table, but neglected to do so. This could result in missing join output rows.","title":"Fix hash join with an inner-side hash key that contains Params coming from an outer nested loop","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["0789b82a9","43af714de","53b93e853","7f11b7a9c","cc8cca3c2","d0ab203bc"],"commit_groups":[["0789b82a9","43af714de","53b93e853","7f11b7a9c","cc8cca3c2","d0ab203bc"]],"commits":["cc8cca3c2"],"cves":[],"db_id":"14da412cc36644c34b37e159cc8c0933","html":"\u003cp\u003eFix intermittent failures when trying to update a field of a composite column (Tom Lane) \u003ca href=\"https://postgr.es/c/cc8cca3c2\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eIf the overall value of the composite column is wide enough to require out-of-line toasting, then an unluckily-timed cache flush could cause errors or server crashes.\u003c/p\u003e","id":"15.4-3f973053e0f3679a","identity_text":"Fix intermittent failures when trying to update a field of a composite column (Tom Lane) If the overall value of the composite column is wide enough to require out-of-line toasting, then an unluckily-timed cache flush could cause errors or server crashes.","part":"changes","patch_ids":["778dc8501378e28fd91f069a6bf948c9"],"related_changes":[{"db_id":"581515a46fc41884212da9f328236b48","evidence":{"patch_ids":["778dc8501378e28fd91f069a6bf948c9"],"same_day":true,"statement_hash":"e8e66f7e93bec2d7b96c0cfc4a7f4b0cb538cd08618dd562ad29563a5ffce33e"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Fix intermittent failures when trying to update a field of a composite column","url":"/docs/compare/?release=14.9#14.9-53784fbdda01552e","version":"14.9"},{"db_id":"f33a929bb695c66a0bacc15be562f9bd","evidence":{"patch_ids":["778dc8501378e28fd91f069a6bf948c9"],"same_day":true,"statement_hash":"e8e66f7e93bec2d7b96c0cfc4a7f4b0cb538cd08618dd562ad29563a5ffce33e"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Fix intermittent failures when trying to update a field of a composite column","url":"/docs/compare/?release=13.12#13.12-a84646baeafa1234","version":"13.12"},{"db_id":"b50182df79de87c30571da4ae8fa33a8","evidence":{"patch_ids":["778dc8501378e28fd91f069a6bf948c9"],"same_day":true,"statement_hash":"e8e66f7e93bec2d7b96c0cfc4a7f4b0cb538cd08618dd562ad29563a5ffce33e"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Fix intermittent failures when trying to update a field of a composite column","url":"/docs/compare/?release=12.16#12.16-14349317dfb71dc6","version":"12.16"},{"db_id":"ddcffbccac79f08acd7af9c6ff9332fe","evidence":{"patch_ids":["778dc8501378e28fd91f069a6bf948c9"],"same_day":true,"statement_hash":"e8e66f7e93bec2d7b96c0cfc4a7f4b0cb538cd08618dd562ad29563a5ffce33e"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Fix intermittent failures when trying to update a field of a composite column","url":"/docs/compare/?release=11.21#11.21-aaea1191a7c0aa5b","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["778dc8501378e28fd91f069a6bf948c9"],"same_day":true,"statement_hash":"e8e66f7e93bec2d7b96c0cfc4a7f4b0cb538cd08618dd562ad29563a5ffce33e"},"rule":2,"target":"581515a46fc41884212da9f328236b48","type":"equivalent"},{"evidence":{"patch_ids":["778dc8501378e28fd91f069a6bf948c9"],"same_day":true,"statement_hash":"e8e66f7e93bec2d7b96c0cfc4a7f4b0cb538cd08618dd562ad29563a5ffce33e"},"rule":2,"target":"b50182df79de87c30571da4ae8fa33a8","type":"equivalent"},{"evidence":{"patch_ids":["778dc8501378e28fd91f069a6bf948c9"],"same_day":true,"statement_hash":"e8e66f7e93bec2d7b96c0cfc4a7f4b0cb538cd08618dd562ad29563a5ffce33e"},"rule":2,"target":"ddcffbccac79f08acd7af9c6ff9332fe","type":"equivalent"},{"evidence":{"patch_ids":["778dc8501378e28fd91f069a6bf948c9"],"same_day":true,"statement_hash":"e8e66f7e93bec2d7b96c0cfc4a7f4b0cb538cd08618dd562ad29563a5ffce33e"},"rule":2,"target":"f33a929bb695c66a0bacc15be562f9bd","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["cc8cca3c2"],"source_entry_id":"15.4/changes/017","source_hash":"f7fd56e3c1b97815424f2c997dceaf23c7fcc8a78f8c115d917a9140bf2cd14e","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"e8e66f7e93bec2d7b96c0cfc4a7f4b0cb538cd08618dd562ad29563a5ffce33e","text":"Fix intermittent failures when trying to update a field of a composite column (Tom Lane) § If the overall value of the composite column is wide enough to require out-of-line toasting, then an unluckily-timed cache flush could cause errors or server crashes.","title":"Fix intermittent failures when trying to update a field of a composite column","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["260dbf19a","54e1b8587","7ae4e7868","7f528e96c","984c23f6f","9cf85093b","c504aa857","ce5aaea8c","ee87f8b63","f24523672"],"commit_groups":[["260dbf19a","7ae4e7868","984c23f6f","9cf85093b","ce5aaea8c"],["54e1b8587","7f528e96c","c504aa857","ee87f8b63","f24523672"]],"commits":["7ae4e7868","ee87f8b63"],"cves":[],"db_id":"9b765c59a36433ec54c730804aebabfa","html":"\u003cp\u003ePrevent query-lifespan memory leaks in some \u003ccode\u003eUPDATE\u003c/code\u003e queries with triggers (Tomas Vondra) \u003ca href=\"https://postgr.es/c/ee87f8b63\"\u003e§\u003c/a\u003e \u003ca href=\"https://postgr.es/c/7ae4e7868\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"15.4-9f325dd88f8ec86c","identity_text":"Prevent query-lifespan memory leaks in some UPDATE queries with triggers (Tomas Vondra)","part":"changes","patch_ids":["3972da03a018ceba4162ec332f283a96","a9de48ea9b0829de583cda8a9704ef43"],"related_changes":[{"db_id":"d221ce3bd7c5a5d8d69121ab1014f849","evidence":{"patch_ids":["3972da03a018ceba4162ec332f283a96","a9de48ea9b0829de583cda8a9704ef43"],"same_day":true,"statement_hash":"14ffd2c0aafc242ca262a666ad5e329b4531d70e3adfb7e05a9c2c5949c1cf3c"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Prevent query-lifespan memory leaks in some UPDATE queries with triggers","url":"/docs/compare/?release=14.9#14.9-9ce4fe9a9efbfc12","version":"14.9"},{"db_id":"c44f76cf2db3a40525fc001d224f72a2","evidence":{"patch_ids":["3972da03a018ceba4162ec332f283a96","a9de48ea9b0829de583cda8a9704ef43"],"same_day":true,"statement_hash":"14ffd2c0aafc242ca262a666ad5e329b4531d70e3adfb7e05a9c2c5949c1cf3c"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Prevent query-lifespan memory leaks in some UPDATE queries with triggers","url":"/docs/compare/?release=13.12#13.12-b7f6bd606b71f8e4","version":"13.12"},{"db_id":"8367f3434c1e5eac676255b7d53d64cc","evidence":{"patch_ids":["3972da03a018ceba4162ec332f283a96","a9de48ea9b0829de583cda8a9704ef43"],"same_day":true,"statement_hash":"14ffd2c0aafc242ca262a666ad5e329b4531d70e3adfb7e05a9c2c5949c1cf3c"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Prevent query-lifespan memory leaks in some UPDATE queries with triggers","url":"/docs/compare/?release=12.16#12.16-00a595ab3aae09a2","version":"12.16"}],"relations":[{"evidence":{"patch_ids":["3972da03a018ceba4162ec332f283a96","a9de48ea9b0829de583cda8a9704ef43"],"same_day":true,"statement_hash":"14ffd2c0aafc242ca262a666ad5e329b4531d70e3adfb7e05a9c2c5949c1cf3c"},"rule":2,"target":"8367f3434c1e5eac676255b7d53d64cc","type":"equivalent"},{"evidence":{"patch_ids":["3972da03a018ceba4162ec332f283a96","a9de48ea9b0829de583cda8a9704ef43"],"same_day":true,"statement_hash":"14ffd2c0aafc242ca262a666ad5e329b4531d70e3adfb7e05a9c2c5949c1cf3c"},"rule":2,"target":"c44f76cf2db3a40525fc001d224f72a2","type":"equivalent"},{"evidence":{"patch_ids":["3972da03a018ceba4162ec332f283a96","a9de48ea9b0829de583cda8a9704ef43"],"same_day":true,"statement_hash":"14ffd2c0aafc242ca262a666ad5e329b4531d70e3adfb7e05a9c2c5949c1cf3c"},"rule":2,"target":"d221ce3bd7c5a5d8d69121ab1014f849","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["7ae4e7868","ee87f8b63"],"source_entry_id":"15.4/changes/018","source_hash":"4664433fc1c2c1f7dec9779062ef220774d1d46663c3eb4c029e557ee06e3cdb","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"14ffd2c0aafc242ca262a666ad5e329b4531d70e3adfb7e05a9c2c5949c1cf3c","text":"Prevent query-lifespan memory leaks in some UPDATE queries with triggers (Tomas Vondra) § §","title":"Prevent query-lifespan memory leaks in some UPDATE queries with triggers","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["0c5fe4ff6","3ce761d5c","98640f960","9ae7b5d1f","c1affa38c"],"commit_groups":[["0c5fe4ff6","3ce761d5c","98640f960","9ae7b5d1f","c1affa38c"]],"commits":["0c5fe4ff6"],"cves":[],"db_id":"9cb975297879c52de850e98714676468","html":"\u003cp\u003ePrevent query-lifespan memory leaks when an Incremental Sort plan node is rescanned (James Coleman, Laurenz Albe, Tom Lane) \u003ca href=\"https://postgr.es/c/0c5fe4ff6\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"15.4-78d6ce12e34a34b8","identity_text":"Prevent query-lifespan memory leaks when an Incremental Sort plan node is rescanned (James Coleman, Laurenz Albe, Tom Lane)","part":"changes","patch_ids":["331e004ba7f5611f51b9b6c9ceda4fa5"],"related_changes":[{"db_id":"1c87e2da26db592bd05ba42f1799f848","evidence":{"patch_ids":["331e004ba7f5611f51b9b6c9ceda4fa5"],"same_day":true,"statement_hash":"67649ccfe74cfbb9b52a7504941492699769d139e86cfaaf1088370d670cc4f7"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Prevent query-lifespan memory leaks when an Incremental Sort plan node is rescanned","url":"/docs/compare/?release=14.9#14.9-06033bf90d2c90cc","version":"14.9"},{"db_id":"cd71e892e4af373172a8cd94cbff78cf","evidence":{"patch_ids":["331e004ba7f5611f51b9b6c9ceda4fa5"],"same_day":true,"statement_hash":"67649ccfe74cfbb9b52a7504941492699769d139e86cfaaf1088370d670cc4f7"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Prevent query-lifespan memory leaks when an Incremental Sort plan node is rescanned","url":"/docs/compare/?release=13.12#13.12-f73d60eef865603c","version":"13.12"}],"relations":[{"evidence":{"patch_ids":["331e004ba7f5611f51b9b6c9ceda4fa5"],"same_day":true,"statement_hash":"67649ccfe74cfbb9b52a7504941492699769d139e86cfaaf1088370d670cc4f7"},"rule":2,"target":"1c87e2da26db592bd05ba42f1799f848","type":"equivalent"},{"evidence":{"patch_ids":["331e004ba7f5611f51b9b6c9ceda4fa5"],"same_day":true,"statement_hash":"67649ccfe74cfbb9b52a7504941492699769d139e86cfaaf1088370d670cc4f7"},"rule":2,"target":"cd71e892e4af373172a8cd94cbff78cf","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["0c5fe4ff6"],"source_entry_id":"15.4/changes/019","source_hash":"4eee196e4cfed47be21cf10149e4b27fb692f42d380e2b3c12a3de9a7dc361c9","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"67649ccfe74cfbb9b52a7504941492699769d139e86cfaaf1088370d670cc4f7","text":"Prevent query-lifespan memory leaks when an Incremental Sort plan node is rescanned (James Coleman, Laurenz Albe, Tom Lane) §","title":"Prevent query-lifespan memory leaks when an Incremental Sort plan node is rescanned","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["5eaa05f63","6f23b5f74","7398e2722","bd590d1fe"],"commit_groups":[["5eaa05f63","6f23b5f74","7398e2722","bd590d1fe"]],"commits":["bd590d1fe"],"cves":[],"db_id":"bf2aa8a9cd386e1dd40fc1babdb8be63","html":"\u003cp\u003eAccept fractional seconds in the input to \u003ccode\u003ejsonpath\u003c/code\u003e's \u003ccode\u003edatetime()\u003c/code\u003e method (Tom Lane) \u003ca href=\"https://postgr.es/c/bd590d1fe\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"15.4-09c8cad672dfe4dc","identity_text":"Accept fractional seconds in the input to jsonpath's datetime() method (Tom Lane)","part":"changes","patch_ids":["abec4bbd0370ce91443af1234ef3d034"],"related_changes":[{"db_id":"69be3f568166330e95aba0ef86371989","evidence":{"patch_ids":["abec4bbd0370ce91443af1234ef3d034"],"same_day":true,"statement_hash":"776df4292523025b401399a9b7bee4a5bb7809a72caf626ab469bb8bf1e9abc0"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Accept fractional seconds in the input to jsonpath's datetime() method","url":"/docs/compare/?release=14.9#14.9-0458106e2a11a401","version":"14.9"},{"db_id":"0391c164e732c59320ef6d457c47be65","evidence":{"patch_ids":["abec4bbd0370ce91443af1234ef3d034"],"same_day":true,"statement_hash":"776df4292523025b401399a9b7bee4a5bb7809a72caf626ab469bb8bf1e9abc0"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Accept fractional seconds in the input to jsonpath's datetime() method","url":"/docs/compare/?release=13.12#13.12-4cc3dd9fa65ce2aa","version":"13.12"}],"relations":[{"evidence":{"patch_ids":["abec4bbd0370ce91443af1234ef3d034"],"same_day":true,"statement_hash":"776df4292523025b401399a9b7bee4a5bb7809a72caf626ab469bb8bf1e9abc0"},"rule":2,"target":"0391c164e732c59320ef6d457c47be65","type":"equivalent"},{"evidence":{"patch_ids":["abec4bbd0370ce91443af1234ef3d034"],"same_day":true,"statement_hash":"776df4292523025b401399a9b7bee4a5bb7809a72caf626ab469bb8bf1e9abc0"},"rule":2,"target":"69be3f568166330e95aba0ef86371989","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["bd590d1fe"],"source_entry_id":"15.4/changes/020","source_hash":"a0e004bbe1b6c0de15f96bc8f5f156c566af4cbc7c4184efa5c904b8137bf515","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"776df4292523025b401399a9b7bee4a5bb7809a72caf626ab469bb8bf1e9abc0","text":"Accept fractional seconds in the input to jsonpath's datetime() method (Tom Lane) §","title":"Accept fractional seconds in the input to jsonpath's datetime() method","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["3b4580f5c","4c61afa47","691594acd","a77d90171","b6ab18a99","c7f33a197"],"commit_groups":[["3b4580f5c","4c61afa47","691594acd","a77d90171","b6ab18a99","c7f33a197"]],"commits":["a77d90171"],"cves":[],"db_id":"2e75ce2dc2c396b9760dbfd653ed53ba","html":"\u003cp\u003ePrevent stack-overflow crashes with very complex text search patterns (Tom Lane) \u003ca href=\"https://postgr.es/c/a77d90171\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"15.4-d6d59320737125d6","identity_text":"Prevent stack-overflow crashes with very complex text search patterns (Tom Lane)","part":"changes","patch_ids":["cc7d7f2b6488db8ad5766f488c9d45a6"],"related_changes":[{"db_id":"83139ba83e7ca914e14fb807404b1a8d","evidence":{"patch_ids":["cc7d7f2b6488db8ad5766f488c9d45a6"],"same_day":true,"statement_hash":"dda9b0426bfaa92a02734a7a77dbdc263cc5b869cc8cc20f05f3a320a0fa3fa0"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Prevent stack-overflow crashes with very complex text search patterns","url":"/docs/compare/?release=14.9#14.9-2d5b95a9be945d76","version":"14.9"},{"db_id":"c04476adb0206ac5adaca2039192ea21","evidence":{"patch_ids":["cc7d7f2b6488db8ad5766f488c9d45a6"],"same_day":true,"statement_hash":"dda9b0426bfaa92a02734a7a77dbdc263cc5b869cc8cc20f05f3a320a0fa3fa0"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Prevent stack-overflow crashes with very complex text search patterns","url":"/docs/compare/?release=13.12#13.12-33542d44241f9bed","version":"13.12"},{"db_id":"8331baa0174c66a0e5375f9f9beee432","evidence":{"patch_ids":["cc7d7f2b6488db8ad5766f488c9d45a6"],"same_day":true,"statement_hash":"dda9b0426bfaa92a02734a7a77dbdc263cc5b869cc8cc20f05f3a320a0fa3fa0"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Prevent stack-overflow crashes with very complex text search patterns","url":"/docs/compare/?release=12.16#12.16-8115dcf6abfb9447","version":"12.16"},{"db_id":"f462fd6e8ba0be366e12b98a5976117c","evidence":{"patch_ids":["cc7d7f2b6488db8ad5766f488c9d45a6"],"same_day":true,"statement_hash":"dda9b0426bfaa92a02734a7a77dbdc263cc5b869cc8cc20f05f3a320a0fa3fa0"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Prevent stack-overflow crashes with very complex text search patterns","url":"/docs/compare/?release=11.21#11.21-e9c2f70aa81e8ef0","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["cc7d7f2b6488db8ad5766f488c9d45a6"],"same_day":true,"statement_hash":"dda9b0426bfaa92a02734a7a77dbdc263cc5b869cc8cc20f05f3a320a0fa3fa0"},"rule":2,"target":"83139ba83e7ca914e14fb807404b1a8d","type":"equivalent"},{"evidence":{"patch_ids":["cc7d7f2b6488db8ad5766f488c9d45a6"],"same_day":true,"statement_hash":"dda9b0426bfaa92a02734a7a77dbdc263cc5b869cc8cc20f05f3a320a0fa3fa0"},"rule":2,"target":"8331baa0174c66a0e5375f9f9beee432","type":"equivalent"},{"evidence":{"patch_ids":["cc7d7f2b6488db8ad5766f488c9d45a6"],"same_day":true,"statement_hash":"dda9b0426bfaa92a02734a7a77dbdc263cc5b869cc8cc20f05f3a320a0fa3fa0"},"rule":2,"target":"c04476adb0206ac5adaca2039192ea21","type":"equivalent"},{"evidence":{"patch_ids":["cc7d7f2b6488db8ad5766f488c9d45a6"],"same_day":true,"statement_hash":"dda9b0426bfaa92a02734a7a77dbdc263cc5b869cc8cc20f05f3a320a0fa3fa0"},"rule":2,"target":"f462fd6e8ba0be366e12b98a5976117c","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["a77d90171"],"source_entry_id":"15.4/changes/021","source_hash":"760cef19f3d6ab7e6943120ffae0fe83210373c63fc69064b5fe1f4914855a8a","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"dda9b0426bfaa92a02734a7a77dbdc263cc5b869cc8cc20f05f3a320a0fa3fa0","text":"Prevent stack-overflow crashes with very complex text search patterns (Tom Lane) §","title":"Prevent stack-overflow crashes with very complex text search patterns","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["0660f74e8","1d031ad54","288b4288c","313ceda2f","341996248","38df84c65","de3f0e3fe"],"commit_groups":[["0660f74e8","1d031ad54","288b4288c","313ceda2f","341996248","38df84c65","de3f0e3fe"]],"commits":["313ceda2f"],"cves":[],"db_id":"bb6d76438d51fc5fa20cf73c0a0b64a3","html":"\u003cp\u003eAllow tokens up to 10240 bytes long in \u003ccode\u003epg_hba.conf\u003c/code\u003e and \u003ccode\u003epg_ident.conf\u003c/code\u003e (Tom Lane) \u003ca href=\"https://postgr.es/c/313ceda2f\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThe previous limit of 256 bytes has been found insufficient for some use-cases.\u003c/p\u003e","id":"15.4-7454c50b73348dca","identity_text":"Allow tokens up to 10240 bytes long in pg_hba.conf and pg_ident.conf (Tom Lane) The previous limit of 256 bytes has been found insufficient for some use-cases.","part":"changes","patch_ids":["98d67cdf3c0ead6326a2a33b279fe8d7"],"related_changes":[{"db_id":"c86f7037f349c6b765e98f879e584db3","evidence":{"patch_ids":["98d67cdf3c0ead6326a2a33b279fe8d7"],"same_day":false},"kind":"related","label":"16.0","source_url":"/docs/release/16.0/#RELEASE-16-PG-HBA","title":"Allow pg_hba.conf tokens to be of unlimited length","url":"/docs/compare/?release=16.0#16.0-5e33645ecdf297ca","version":"16.0"},{"db_id":"5052cdce2ff501e8882fe7b5bd665ea7","evidence":{"patch_ids":["98d67cdf3c0ead6326a2a33b279fe8d7"],"same_day":true,"statement_hash":"da90a61fea160c5840872e071681e8c69da781986b3995430f7e8f2826c1ef8d"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Allow tokens up to 10240 bytes long in pg_hba.conf and pg_ident.conf","url":"/docs/compare/?release=14.9#14.9-5bb3aebe0a3a7f93","version":"14.9"},{"db_id":"9f4d00733ec0b39cef55b609e58feb5e","evidence":{"patch_ids":["98d67cdf3c0ead6326a2a33b279fe8d7"],"same_day":true,"statement_hash":"da90a61fea160c5840872e071681e8c69da781986b3995430f7e8f2826c1ef8d"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Allow tokens up to 10240 bytes long in pg_hba.conf and pg_ident.conf","url":"/docs/compare/?release=13.12#13.12-973d3bc2dbc69d58","version":"13.12"},{"db_id":"c0284c475e03c7f703126c3dcc072f1b","evidence":{"patch_ids":["98d67cdf3c0ead6326a2a33b279fe8d7"],"same_day":true,"statement_hash":"da90a61fea160c5840872e071681e8c69da781986b3995430f7e8f2826c1ef8d"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Allow tokens up to 10240 bytes long in pg_hba.conf and pg_ident.conf","url":"/docs/compare/?release=12.16#12.16-4587afce7e4f52c0","version":"12.16"},{"db_id":"d12f6a5e5ec54da016372459d525434d","evidence":{"patch_ids":["98d67cdf3c0ead6326a2a33b279fe8d7"],"same_day":true,"statement_hash":"da90a61fea160c5840872e071681e8c69da781986b3995430f7e8f2826c1ef8d"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Allow tokens up to 10240 bytes long in pg_hba.conf and pg_ident.conf","url":"/docs/compare/?release=11.21#11.21-ad309aebae83af08","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["98d67cdf3c0ead6326a2a33b279fe8d7"],"same_day":true,"statement_hash":"da90a61fea160c5840872e071681e8c69da781986b3995430f7e8f2826c1ef8d"},"rule":2,"target":"5052cdce2ff501e8882fe7b5bd665ea7","type":"equivalent"},{"evidence":{"patch_ids":["98d67cdf3c0ead6326a2a33b279fe8d7"],"same_day":true,"statement_hash":"da90a61fea160c5840872e071681e8c69da781986b3995430f7e8f2826c1ef8d"},"rule":2,"target":"9f4d00733ec0b39cef55b609e58feb5e","type":"equivalent"},{"evidence":{"patch_ids":["98d67cdf3c0ead6326a2a33b279fe8d7"],"same_day":true,"statement_hash":"da90a61fea160c5840872e071681e8c69da781986b3995430f7e8f2826c1ef8d"},"rule":2,"target":"c0284c475e03c7f703126c3dcc072f1b","type":"equivalent"},{"evidence":{"patch_ids":["98d67cdf3c0ead6326a2a33b279fe8d7"],"same_day":false},"rule":2,"target":"c86f7037f349c6b765e98f879e584db3","type":"related"},{"evidence":{"patch_ids":["98d67cdf3c0ead6326a2a33b279fe8d7"],"same_day":true,"statement_hash":"da90a61fea160c5840872e071681e8c69da781986b3995430f7e8f2826c1ef8d"},"rule":2,"target":"d12f6a5e5ec54da016372459d525434d","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["313ceda2f"],"source_entry_id":"15.4/changes/022","source_hash":"bf8b29adb70fc465d256accd01744dffd4140225668eaff62786914f7d9b51f0","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"da90a61fea160c5840872e071681e8c69da781986b3995430f7e8f2826c1ef8d","text":"Allow tokens up to 10240 bytes long in pg_hba.conf and pg_ident.conf (Tom Lane) § The previous limit of 256 bytes has been found insufficient for some use-cases.","title":"Allow tokens up to 10240 bytes long in pg_hba.conf and pg_ident.conf","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["a5f312c58"],"commit_groups":[["a5f312c58"]],"commits":["a5f312c58"],"cves":[],"db_id":"328795fb8e7000bc34df28ffdb54eb61","html":"\u003cp\u003eEnsure that all existing placeholders are checked for matches when an extension declares its GUC prefix to be reserved (Karina Litskevich, Ekaterina Sokolova) \u003ca href=\"https://postgr.es/c/a5f312c58\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eFaulty loop logic could cause some entries to be skipped.\u003c/p\u003e","id":"15.4-7eb13fba3cfe8a4f","identity_text":"Ensure that all existing placeholders are checked for matches when an extension declares its GUC prefix to be reserved (Karina Litskevich, Ekaterina Sokolova) Faulty loop logic could cause some entries to be skipped.","part":"changes","patch_ids":["5d94ef663dd397e7a9e4cbde045d71d5"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["a5f312c58"],"source_entry_id":"15.4/changes/023","source_hash":"18dfab624c5dae0c067ee5ad536e94f328715192fe6fba5f18831005a88582bf","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"1ec47f5905daa42e98a31e4681a947a857a98eb1ff3fe4b8c8d294fbeabeff7a","text":"Ensure that all existing placeholders are checked for matches when an extension declares its GUC prefix to be reserved (Karina Litskevich, Ekaterina Sokolova) § Faulty loop logic could cause some entries to be skipped.","title":"Ensure that all existing placeholders are checked for matches when an extension declares its GUC prefix to be reserved","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["162aa47c3","2316ff1ae","4f4d73466","59c2a6fe9","bfb493dba","dc0b58417","fa96a74a0"],"commit_groups":[["162aa47c3","2316ff1ae","4f4d73466","59c2a6fe9","bfb493dba","dc0b58417","fa96a74a0"]],"commits":["fa96a74a0"],"cves":[],"db_id":"ae85f7f04a7d36b6403e07b39e6e4ddf","html":"\u003cp\u003eFix mishandling of C++ out-of-memory conditions (Heikki Linnakangas) \u003ca href=\"https://postgr.es/c/fa96a74a0\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eIf JIT is in use, running out of memory in a C++ \u003ccode\u003enew\u003c/code\u003e call would lead to a \u003cspan\u003ePostgreSQL\u003c/span\u003e FATAL error, instead of the expected C++ exception.\u003c/p\u003e","id":"15.4-1cf0313471a3d44a","identity_text":"Fix mishandling of C++ out-of-memory conditions (Heikki Linnakangas) If JIT is in use, running out of memory in a C++ new call would lead to a PostgreSQL FATAL error, instead of the expected C++ exception.","part":"changes","patch_ids":["0f2bb015425a1155e776a74158ca4a93"],"related_changes":[{"db_id":"f75d7d0b1dd8aa9b969fa8e88a6febe4","evidence":{"patch_ids":["0f2bb015425a1155e776a74158ca4a93"],"same_day":true,"statement_hash":"b74c6634d11cb3e66f64639c7ad351ac71400257ec790ae2a321eefe3d8cd41f"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Fix mishandling of C++ out-of-memory conditions","url":"/docs/compare/?release=14.9#14.9-b94609a53f1b3e2c","version":"14.9"},{"db_id":"7cebd2d79d0128bc94c2d77bf3728508","evidence":{"patch_ids":["0f2bb015425a1155e776a74158ca4a93"],"same_day":true,"statement_hash":"b74c6634d11cb3e66f64639c7ad351ac71400257ec790ae2a321eefe3d8cd41f"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Fix mishandling of C++ out-of-memory conditions","url":"/docs/compare/?release=13.12#13.12-ae7566497fb9c8c4","version":"13.12"},{"db_id":"96898e43e86461d367e2a37792585a0b","evidence":{"patch_ids":["0f2bb015425a1155e776a74158ca4a93"],"same_day":true,"statement_hash":"b74c6634d11cb3e66f64639c7ad351ac71400257ec790ae2a321eefe3d8cd41f"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Fix mishandling of C++ out-of-memory conditions","url":"/docs/compare/?release=12.16#12.16-be08c48a296dc03c","version":"12.16"},{"db_id":"757d3172dbdf2effbbbfc156a10c873f","evidence":{"patch_ids":["0f2bb015425a1155e776a74158ca4a93"],"same_day":true,"statement_hash":"b74c6634d11cb3e66f64639c7ad351ac71400257ec790ae2a321eefe3d8cd41f"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Fix mishandling of C++ out-of-memory conditions","url":"/docs/compare/?release=11.21#11.21-64eb52a28b8a8d32","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["0f2bb015425a1155e776a74158ca4a93"],"same_day":true,"statement_hash":"b74c6634d11cb3e66f64639c7ad351ac71400257ec790ae2a321eefe3d8cd41f"},"rule":2,"target":"757d3172dbdf2effbbbfc156a10c873f","type":"equivalent"},{"evidence":{"patch_ids":["0f2bb015425a1155e776a74158ca4a93"],"same_day":true,"statement_hash":"b74c6634d11cb3e66f64639c7ad351ac71400257ec790ae2a321eefe3d8cd41f"},"rule":2,"target":"7cebd2d79d0128bc94c2d77bf3728508","type":"equivalent"},{"evidence":{"patch_ids":["0f2bb015425a1155e776a74158ca4a93"],"same_day":true,"statement_hash":"b74c6634d11cb3e66f64639c7ad351ac71400257ec790ae2a321eefe3d8cd41f"},"rule":2,"target":"96898e43e86461d367e2a37792585a0b","type":"equivalent"},{"evidence":{"patch_ids":["0f2bb015425a1155e776a74158ca4a93"],"same_day":true,"statement_hash":"b74c6634d11cb3e66f64639c7ad351ac71400257ec790ae2a321eefe3d8cd41f"},"rule":2,"target":"f75d7d0b1dd8aa9b969fa8e88a6febe4","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["fa96a74a0"],"source_entry_id":"15.4/changes/024","source_hash":"fc2d36adb7dcb922a0340e564a01d19dbf3938a4c282a0ac3a06bd45dba61928","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"b74c6634d11cb3e66f64639c7ad351ac71400257ec790ae2a321eefe3d8cd41f","text":"Fix mishandling of C++ out-of-memory conditions (Heikki Linnakangas) § If JIT is in use, running out of memory in a C++ new call would lead to a PostgreSQL FATAL error, instead of the expected C++ exception.","title":"Fix mishandling of C++ out-of-memory conditions","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["10fd061bb","291c02540","9089287aa","c0f531396","fbaf65cd6"],"commit_groups":[["10fd061bb","291c02540","9089287aa","c0f531396","fbaf65cd6"]],"commits":["fbaf65cd6"],"cves":[],"db_id":"c379221b952ffe484034b056c8de56ea","html":"\u003cp\u003eFix rare null-pointer crash in \u003ccode\u003eplancache.c\u003c/code\u003e (Tom Lane) \u003ca href=\"https://postgr.es/c/fbaf65cd6\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"15.4-a2f319dae531d3ef","identity_text":"Fix rare null-pointer crash in plancache.c (Tom Lane)","part":"changes","patch_ids":["96c6c8d6c752b0095cc461cbc2ca623a"],"related_changes":[{"db_id":"0657ca49a3b5cf68484b851738ad1670","evidence":{"patch_ids":["96c6c8d6c752b0095cc461cbc2ca623a"],"same_day":true,"statement_hash":"edd65048cd8428912baf8e0c564ad37f1340bfc3012ee146c4ba8c1193c9f274"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Fix rare null-pointer crash in plancache.c","url":"/docs/compare/?release=14.9#14.9-f9e8d7d02893062a","version":"14.9"},{"db_id":"416a3641213c73a32bd35a963e4bee7f","evidence":{"patch_ids":["96c6c8d6c752b0095cc461cbc2ca623a"],"same_day":true,"statement_hash":"edd65048cd8428912baf8e0c564ad37f1340bfc3012ee146c4ba8c1193c9f274"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Fix rare null-pointer crash in plancache.c","url":"/docs/compare/?release=13.12#13.12-05b56ef9a5caea34","version":"13.12"}],"relations":[{"evidence":{"patch_ids":["96c6c8d6c752b0095cc461cbc2ca623a"],"same_day":true,"statement_hash":"edd65048cd8428912baf8e0c564ad37f1340bfc3012ee146c4ba8c1193c9f274"},"rule":2,"target":"0657ca49a3b5cf68484b851738ad1670","type":"equivalent"},{"evidence":{"patch_ids":["96c6c8d6c752b0095cc461cbc2ca623a"],"same_day":true,"statement_hash":"edd65048cd8428912baf8e0c564ad37f1340bfc3012ee146c4ba8c1193c9f274"},"rule":2,"target":"416a3641213c73a32bd35a963e4bee7f","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["fbaf65cd6"],"source_entry_id":"15.4/changes/025","source_hash":"31207e4995237aef0b1e6f059473c9dca1154dc347520a39051c629f98452fd3","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"edd65048cd8428912baf8e0c564ad37f1340bfc3012ee146c4ba8c1193c9f274","text":"Fix rare null-pointer crash in plancache.c (Tom Lane) §","title":"Fix rare null-pointer crash in plancache.c","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["66f8a1397","68a59f9e9","be8cae7e2"],"commit_groups":[["66f8a1397","68a59f9e9","be8cae7e2"]],"commits":["66f8a1397"],"cves":[],"db_id":"9d85982f43ed1cda1cc26db44cb64465","html":"\u003cp\u003eAvoid leaking a stats entry for a subscription when it is dropped (Masahiko Sawada) \u003ca href=\"https://postgr.es/c/66f8a1397\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"15.4-8256160517121d42","identity_text":"Avoid leaking a stats entry for a subscription when it is dropped (Masahiko Sawada)","part":"changes","patch_ids":["2e408468d0549181d78e0ad289af6775"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["66f8a1397"],"source_entry_id":"15.4/changes/026","source_hash":"35693d3778294ac20b642903676fb914efa4a077d068a61a5c2a25d525574525","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"42a83ba79da6aac08004ec48bf819838911f4e38ffed1c62cf1d576cba96ec1f","text":"Avoid leaking a stats entry for a subscription when it is dropped (Masahiko Sawada) §","title":"Avoid leaking a stats entry for a subscription when it is dropped","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["03f80daac","1605623ec","74ad9b0d1","9ffb10f18","a0003572f","af8f9ec66","b7ec66731"],"commit_groups":[["03f80daac","1605623ec","74ad9b0d1","9ffb10f18","a0003572f","af8f9ec66","b7ec66731"]],"commits":["9ffb10f18"],"cves":[],"db_id":"3b7137fa8ef0091fe6770800f3de0330","html":"\u003cp\u003eAvoid losing track of possibly-useful shared memory segments when a page free results in coalescing ranges of free space (Dongming Liu) \u003ca href=\"https://postgr.es/c/9ffb10f18\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eEnsure that the segment is moved into the appropriate \u003cspan\u003e“\u003cspan\u003ebin\u003c/span\u003e”\u003c/span\u003e for its new amount of free space, so that it will be found by subsequent searches.\u003c/p\u003e","id":"15.4-42666ece97db5e94","identity_text":"Avoid losing track of possibly-useful shared memory segments when a page free results in coalescing ranges of free space (Dongming Liu) Ensure that the segment is moved into the appropriate bin for its new amount of free space, so that it will be found by subsequent searches.","part":"changes","patch_ids":["42d563bce29c65d2de619aff4f52d2f3"],"related_changes":[{"db_id":"dd2140fa9c654962ce9162189f9e402c","evidence":{"patch_ids":["42d563bce29c65d2de619aff4f52d2f3"],"same_day":true,"statement_hash":"d96072c73a1c0a5c772e596a7a4474dd653e23167ee0da74dd828d6b588d03ec"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Avoid losing track of possibly-useful shared memory segments when a page free results in coalescing ranges of free space","url":"/docs/compare/?release=14.9#14.9-4098fc86ec39b3ae","version":"14.9"},{"db_id":"69cd2539014f8f414b8eb920e0de5c0a","evidence":{"patch_ids":["42d563bce29c65d2de619aff4f52d2f3"],"same_day":true,"statement_hash":"d96072c73a1c0a5c772e596a7a4474dd653e23167ee0da74dd828d6b588d03ec"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Avoid losing track of possibly-useful shared memory segments when a page free results in coalescing ranges of free space","url":"/docs/compare/?release=13.12#13.12-ef678d36af38c6a8","version":"13.12"},{"db_id":"f36b990b91a13485cb657c918030eb43","evidence":{"patch_ids":["42d563bce29c65d2de619aff4f52d2f3"],"same_day":true,"statement_hash":"d96072c73a1c0a5c772e596a7a4474dd653e23167ee0da74dd828d6b588d03ec"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Avoid losing track of possibly-useful shared memory segments when a page free results in coalescing ranges of free space","url":"/docs/compare/?release=12.16#12.16-14b5f40e281f3a33","version":"12.16"},{"db_id":"7aecad2319109a406bf6b86ff10bb49b","evidence":{"patch_ids":["42d563bce29c65d2de619aff4f52d2f3"],"same_day":true,"statement_hash":"d96072c73a1c0a5c772e596a7a4474dd653e23167ee0da74dd828d6b588d03ec"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Avoid losing track of possibly-useful shared memory segments when a page free results in coalescing ranges of free space","url":"/docs/compare/?release=11.21#11.21-f5ca500a22c7867a","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["42d563bce29c65d2de619aff4f52d2f3"],"same_day":true,"statement_hash":"d96072c73a1c0a5c772e596a7a4474dd653e23167ee0da74dd828d6b588d03ec"},"rule":2,"target":"69cd2539014f8f414b8eb920e0de5c0a","type":"equivalent"},{"evidence":{"patch_ids":["42d563bce29c65d2de619aff4f52d2f3"],"same_day":true,"statement_hash":"d96072c73a1c0a5c772e596a7a4474dd653e23167ee0da74dd828d6b588d03ec"},"rule":2,"target":"7aecad2319109a406bf6b86ff10bb49b","type":"equivalent"},{"evidence":{"patch_ids":["42d563bce29c65d2de619aff4f52d2f3"],"same_day":true,"statement_hash":"d96072c73a1c0a5c772e596a7a4474dd653e23167ee0da74dd828d6b588d03ec"},"rule":2,"target":"dd2140fa9c654962ce9162189f9e402c","type":"equivalent"},{"evidence":{"patch_ids":["42d563bce29c65d2de619aff4f52d2f3"],"same_day":true,"statement_hash":"d96072c73a1c0a5c772e596a7a4474dd653e23167ee0da74dd828d6b588d03ec"},"rule":2,"target":"f36b990b91a13485cb657c918030eb43","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["9ffb10f18"],"source_entry_id":"15.4/changes/027","source_hash":"4bdafe021479ec036767bae218cb6e1c0f8513c9c99f6a3507e22be372f8ee7a","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"d96072c73a1c0a5c772e596a7a4474dd653e23167ee0da74dd828d6b588d03ec","text":"Avoid losing track of possibly-useful shared memory segments when a page free results in coalescing ranges of free space (Dongming Liu) § Ensure that the segment is moved into the appropriate “bin” for its new amount of free space, so that it will be found by subsequent searches.","title":"Avoid losing track of possibly-useful shared memory segments when a page free results in coalescing ranges of free space","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["188dad680","322c9b340","355917c07","5abff197c","5f0762f14","63fa0deb3","642bec1f8","6983a5112","7ddba19eb","8f876d15c","a72b503ca","b6311824f"],"commit_groups":[["188dad680","322c9b340","5abff197c","6983a5112","8f876d15c","a72b503ca"],["355917c07","5f0762f14","63fa0deb3","642bec1f8","7ddba19eb","b6311824f"]],"commits":["642bec1f8","6983a5112"],"cves":[],"db_id":"fca791223a053223cf98f2d306ab4d4b","html":"\u003cp\u003eAllow \u003ccode\u003eVACUUM\u003c/code\u003e to continue after detecting certain types of b-tree index corruption (Peter Geoghegan) \u003ca href=\"https://postgr.es/c/642bec1f8\"\u003e§\u003c/a\u003e \u003ca href=\"https://postgr.es/c/6983a5112\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eIf an invalid sibling-page link is detected, log the issue and press on, rather than throwing an error as before. Nothing short of \u003ccode\u003eREINDEX\u003c/code\u003e will fix the broken index, but preventing \u003ccode\u003eVACUUM\u003c/code\u003e from completing until that is done risks making matters far worse.\u003c/p\u003e","id":"15.4-92ca09ecfe8e79ab","identity_text":"Allow VACUUM to continue after detecting certain types of b-tree index corruption (Peter Geoghegan) If an invalid sibling-page link is detected, log the issue and press on, rather than throwing an error as before. Nothing short of REINDEX will fix the broken index, but preventing VACUUM from completing until that is done risks making matters far worse.","part":"changes","patch_ids":["47fc332937773c1117907b8ce33587f5","9ad7b4d1741d7488476fc58c7cd30389"],"related_changes":[{"db_id":"2e1e0133c0014a8e79d055f84ec32255","evidence":{"patch_ids":["47fc332937773c1117907b8ce33587f5","9ad7b4d1741d7488476fc58c7cd30389"],"same_day":true,"statement_hash":"e375359809c4d5911f1549c1658db07da6de407caa8f6e0790c788ee51f7ec59"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Allow VACUUM to continue after detecting certain types of b-tree index corruption","url":"/docs/compare/?release=14.9#14.9-40be52d089b50eef","version":"14.9"},{"db_id":"a9141d6478c75bf3e881cad7473c3845","evidence":{"patch_ids":["47fc332937773c1117907b8ce33587f5","9ad7b4d1741d7488476fc58c7cd30389"],"same_day":true,"statement_hash":"e375359809c4d5911f1549c1658db07da6de407caa8f6e0790c788ee51f7ec59"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Allow VACUUM to continue after detecting certain types of b-tree index corruption","url":"/docs/compare/?release=13.12#13.12-b73d9abae9f91a71","version":"13.12"},{"db_id":"ffc290a79a16a36a3f6292aaf4ce8eba","evidence":{"patch_ids":["47fc332937773c1117907b8ce33587f5","9ad7b4d1741d7488476fc58c7cd30389"],"same_day":true,"statement_hash":"e375359809c4d5911f1549c1658db07da6de407caa8f6e0790c788ee51f7ec59"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Allow VACUUM to continue after detecting certain types of b-tree index corruption","url":"/docs/compare/?release=12.16#12.16-db3b03ae69b7b717","version":"12.16"},{"db_id":"0a89bb207effe674187e329750d0375e","evidence":{"patch_ids":["47fc332937773c1117907b8ce33587f5","9ad7b4d1741d7488476fc58c7cd30389"],"same_day":true,"statement_hash":"e375359809c4d5911f1549c1658db07da6de407caa8f6e0790c788ee51f7ec59"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Allow VACUUM to continue after detecting certain types of b-tree index corruption","url":"/docs/compare/?release=11.21#11.21-9c5d77f00347e603","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["47fc332937773c1117907b8ce33587f5","9ad7b4d1741d7488476fc58c7cd30389"],"same_day":true,"statement_hash":"e375359809c4d5911f1549c1658db07da6de407caa8f6e0790c788ee51f7ec59"},"rule":2,"target":"0a89bb207effe674187e329750d0375e","type":"equivalent"},{"evidence":{"patch_ids":["47fc332937773c1117907b8ce33587f5","9ad7b4d1741d7488476fc58c7cd30389"],"same_day":true,"statement_hash":"e375359809c4d5911f1549c1658db07da6de407caa8f6e0790c788ee51f7ec59"},"rule":2,"target":"2e1e0133c0014a8e79d055f84ec32255","type":"equivalent"},{"evidence":{"patch_ids":["47fc332937773c1117907b8ce33587f5","9ad7b4d1741d7488476fc58c7cd30389"],"same_day":true,"statement_hash":"e375359809c4d5911f1549c1658db07da6de407caa8f6e0790c788ee51f7ec59"},"rule":2,"target":"a9141d6478c75bf3e881cad7473c3845","type":"equivalent"},{"evidence":{"patch_ids":["47fc332937773c1117907b8ce33587f5","9ad7b4d1741d7488476fc58c7cd30389"],"same_day":true,"statement_hash":"e375359809c4d5911f1549c1658db07da6de407caa8f6e0790c788ee51f7ec59"},"rule":2,"target":"ffc290a79a16a36a3f6292aaf4ce8eba","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["642bec1f8","6983a5112"],"source_entry_id":"15.4/changes/028","source_hash":"3578236f6c2b50707e2e0a59e7af26e8f3477ded1dae34a1dabfd4a5cb983b67","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"e375359809c4d5911f1549c1658db07da6de407caa8f6e0790c788ee51f7ec59","text":"Allow VACUUM to continue after detecting certain types of b-tree index corruption (Peter Geoghegan) § § If an invalid sibling-page link is detected, log the issue and press on, rather than throwing an error as before. Nothing short of REINDEX will fix the broken index, but preventing VACUUM from completing until that is done risks making matters far worse.","title":"Allow VACUUM to continue after detecting certain types of b-tree index corruption","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["03ccc9569","1386f0987","53336e8f6","7aec84e4c","82e97b864","83ecfa9fa","e246fd423"],"commit_groups":[["03ccc9569","1386f0987","53336e8f6","7aec84e4c","82e97b864","83ecfa9fa","e246fd423"]],"commits":["82e97b864"],"cves":[],"db_id":"9e1c36701bee34cefa6f645874690e82","html":"\u003cp\u003eEnsure that \u003ccode\u003eWrapLimitsVacuumLock\u003c/code\u003e is released after \u003ccode\u003eVACUUM\u003c/code\u003e detects invalid data in \u003ccode\u003epg_database\u003c/code\u003e.\u003ccode\u003edatfrozenxid\u003c/code\u003e or \u003ccode\u003epg_database\u003c/code\u003e.\u003ccode\u003edatminmxid\u003c/code\u003e (Andres Freund) \u003ca href=\"https://postgr.es/c/82e97b864\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eFailure to release this lock could lead to a deadlock later, although the lock would be cleaned up if the session exits or encounters some other error.\u003c/p\u003e","id":"15.4-fc31e62c9d8f0773","identity_text":"Ensure that WrapLimitsVacuumLock is released after VACUUM detects invalid data in pg_database.datfrozenxid or pg_database.datminmxid (Andres Freund) Failure to release this lock could lead to a deadlock later, although the lock would be cleaned up if the session exits or encounters some other error.","part":"changes","patch_ids":["1b6b8275886323aadcadf7c2b11b0c8b"],"related_changes":[{"db_id":"00ed0ec03b25cebab6a578b7a1cb0d5e","evidence":{"patch_ids":["1b6b8275886323aadcadf7c2b11b0c8b"],"same_day":true,"statement_hash":"5672c1727ae63c393bcd3714d3a6af661200d977ae1ec6b2fb9517889007db99"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Ensure that WrapLimitsVacuumLock is released after VACUUM detects invalid data in pg_database.datfrozenxid or pg_database.datminmxid","url":"/docs/compare/?release=14.9#14.9-1dea824292b15109","version":"14.9"},{"db_id":"894f99c5b8c44b0f88369ccb5cf92d68","evidence":{"patch_ids":["1b6b8275886323aadcadf7c2b11b0c8b"],"same_day":true,"statement_hash":"5672c1727ae63c393bcd3714d3a6af661200d977ae1ec6b2fb9517889007db99"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Ensure that WrapLimitsVacuumLock is released after VACUUM detects invalid data in pg_database.datfrozenxid or pg_database.datminmxid","url":"/docs/compare/?release=13.12#13.12-5386073eae102d79","version":"13.12"},{"db_id":"ef3bd6456d4a5f2b6208d225b50d162e","evidence":{"patch_ids":["1b6b8275886323aadcadf7c2b11b0c8b"],"same_day":true,"statement_hash":"5672c1727ae63c393bcd3714d3a6af661200d977ae1ec6b2fb9517889007db99"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Ensure that WrapLimitsVacuumLock is released after VACUUM detects invalid data in pg_database.datfrozenxid or pg_database.datminmxid","url":"/docs/compare/?release=12.16#12.16-2cec84cf87742742","version":"12.16"},{"db_id":"d39abc48a5fe5355d64052920a291087","evidence":{"patch_ids":["1b6b8275886323aadcadf7c2b11b0c8b"],"same_day":true,"statement_hash":"5672c1727ae63c393bcd3714d3a6af661200d977ae1ec6b2fb9517889007db99"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Ensure that WrapLimitsVacuumLock is released after VACUUM detects invalid data in pg_database.datfrozenxid or pg_database.datminmxid","url":"/docs/compare/?release=11.21#11.21-8f2ff860420be278","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["1b6b8275886323aadcadf7c2b11b0c8b"],"same_day":true,"statement_hash":"5672c1727ae63c393bcd3714d3a6af661200d977ae1ec6b2fb9517889007db99"},"rule":2,"target":"00ed0ec03b25cebab6a578b7a1cb0d5e","type":"equivalent"},{"evidence":{"patch_ids":["1b6b8275886323aadcadf7c2b11b0c8b"],"same_day":true,"statement_hash":"5672c1727ae63c393bcd3714d3a6af661200d977ae1ec6b2fb9517889007db99"},"rule":2,"target":"894f99c5b8c44b0f88369ccb5cf92d68","type":"equivalent"},{"evidence":{"patch_ids":["1b6b8275886323aadcadf7c2b11b0c8b"],"same_day":true,"statement_hash":"5672c1727ae63c393bcd3714d3a6af661200d977ae1ec6b2fb9517889007db99"},"rule":2,"target":"d39abc48a5fe5355d64052920a291087","type":"equivalent"},{"evidence":{"patch_ids":["1b6b8275886323aadcadf7c2b11b0c8b"],"same_day":true,"statement_hash":"5672c1727ae63c393bcd3714d3a6af661200d977ae1ec6b2fb9517889007db99"},"rule":2,"target":"ef3bd6456d4a5f2b6208d225b50d162e","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["82e97b864"],"source_entry_id":"15.4/changes/029","source_hash":"2c09e891c67fdd2054a2fd62a4bc3681f68e4df6942f1ede0f5a87247ef899b9","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"5672c1727ae63c393bcd3714d3a6af661200d977ae1ec6b2fb9517889007db99","text":"Ensure that WrapLimitsVacuumLock is released after VACUUM detects invalid data in pg_database.datfrozenxid or pg_database.datminmxid (Andres Freund) § Failure to release this lock could lead to a deadlock later, although the lock would be cleaned up if the session exits or encounters some other error.","title":"Ensure that WrapLimitsVacuumLock is released after VACUUM detects invalid data in pg_database.datfrozenxid or pg_database.datminmxid","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["410a0d6bd","442749100","4e465aac3","6c7bffc09","763d26205","926aa6d11","a878eff6b","b3ca4f0a5","bc0581f8f","cb0cca188","d2ee542a2","db59108a2","f6ecd2622","f88bc9f38"],"commit_groups":[["410a0d6bd","4e465aac3","6c7bffc09","763d26205","926aa6d11","b3ca4f0a5","f6ecd2622"],["442749100","a878eff6b","bc0581f8f","cb0cca188","d2ee542a2","db59108a2","f88bc9f38"]],"commits":["a878eff6b","f6ecd2622"],"cves":[],"db_id":"6de9bddc7179e995dcbe61e6b02ea148","html":"\u003cp\u003eAvoid double replay of prepared transactions during crash recovery (suyu.cmj, Michael Paquier) \u003ca href=\"https://postgr.es/c/a878eff6b\"\u003e§\u003c/a\u003e \u003ca href=\"https://postgr.es/c/f6ecd2622\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eAfter a crash partway through a checkpoint with some two-phase transaction state data already flushed to disk by this checkpoint, crash recovery could attempt to replay the prepared transaction(s) twice, leading to a fatal error such as \u003cspan\u003e“\u003cspan\u003elock is already held\u003c/span\u003e”\u003c/span\u003e in the startup process.\u003c/p\u003e","id":"15.4-6bc807bdc7eebba6","identity_text":"Avoid double replay of prepared transactions during crash recovery (suyu.cmj, Michael Paquier) After a crash partway through a checkpoint with some two-phase transaction state data already flushed to disk by this checkpoint, crash recovery could attempt to replay the prepared transaction(s) twice, leading to a fatal error such as lock is already held in the startup process.","part":"changes","patch_ids":["3a45aa80b8b14881f3f8228d127209ec","6af3f18449915f359df7d07ca8fcc1d1"],"related_changes":[{"db_id":"35150195e25fe8d39793a02efbe04a98","evidence":{"patch_ids":["3a45aa80b8b14881f3f8228d127209ec","6af3f18449915f359df7d07ca8fcc1d1"],"same_day":true,"statement_hash":"65878e2d2f00a878c28a92bd762f98ee3c581256d85150f377dbdd4e3f6b3642"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Avoid double replay of prepared transactions during crash recovery","url":"/docs/compare/?release=14.9#14.9-0382da9acd961b32","version":"14.9"},{"db_id":"1dd0c2289a3930838087a741e59383ff","evidence":{"patch_ids":["3a45aa80b8b14881f3f8228d127209ec","6af3f18449915f359df7d07ca8fcc1d1"],"same_day":true,"statement_hash":"65878e2d2f00a878c28a92bd762f98ee3c581256d85150f377dbdd4e3f6b3642"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Avoid double replay of prepared transactions during crash recovery","url":"/docs/compare/?release=13.12#13.12-89bb2fdb46f2412c","version":"13.12"},{"db_id":"83c59769f8098ea6ed99f5811a142385","evidence":{"patch_ids":["3a45aa80b8b14881f3f8228d127209ec","6af3f18449915f359df7d07ca8fcc1d1"],"same_day":true,"statement_hash":"65878e2d2f00a878c28a92bd762f98ee3c581256d85150f377dbdd4e3f6b3642"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Avoid double replay of prepared transactions during crash recovery","url":"/docs/compare/?release=12.16#12.16-f9f6fd1df57a51a6","version":"12.16"},{"db_id":"93d6a8b730835d9767fd1c267a65ae5f","evidence":{"patch_ids":["3a45aa80b8b14881f3f8228d127209ec","6af3f18449915f359df7d07ca8fcc1d1"],"same_day":true,"statement_hash":"65878e2d2f00a878c28a92bd762f98ee3c581256d85150f377dbdd4e3f6b3642"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Avoid double replay of prepared transactions during crash recovery","url":"/docs/compare/?release=11.21#11.21-e8480a33af0d190b","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["3a45aa80b8b14881f3f8228d127209ec","6af3f18449915f359df7d07ca8fcc1d1"],"same_day":true,"statement_hash":"65878e2d2f00a878c28a92bd762f98ee3c581256d85150f377dbdd4e3f6b3642"},"rule":2,"target":"1dd0c2289a3930838087a741e59383ff","type":"equivalent"},{"evidence":{"patch_ids":["3a45aa80b8b14881f3f8228d127209ec","6af3f18449915f359df7d07ca8fcc1d1"],"same_day":true,"statement_hash":"65878e2d2f00a878c28a92bd762f98ee3c581256d85150f377dbdd4e3f6b3642"},"rule":2,"target":"35150195e25fe8d39793a02efbe04a98","type":"equivalent"},{"evidence":{"patch_ids":["3a45aa80b8b14881f3f8228d127209ec","6af3f18449915f359df7d07ca8fcc1d1"],"same_day":true,"statement_hash":"65878e2d2f00a878c28a92bd762f98ee3c581256d85150f377dbdd4e3f6b3642"},"rule":2,"target":"83c59769f8098ea6ed99f5811a142385","type":"equivalent"},{"evidence":{"patch_ids":["3a45aa80b8b14881f3f8228d127209ec","6af3f18449915f359df7d07ca8fcc1d1"],"same_day":true,"statement_hash":"65878e2d2f00a878c28a92bd762f98ee3c581256d85150f377dbdd4e3f6b3642"},"rule":2,"target":"93d6a8b730835d9767fd1c267a65ae5f","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["a878eff6b","f6ecd2622"],"source_entry_id":"15.4/changes/030","source_hash":"46907b2a80da0405d6ece0150e1d4db3a22907a55a59741f8f1d65637ed19504","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"65878e2d2f00a878c28a92bd762f98ee3c581256d85150f377dbdd4e3f6b3642","text":"Avoid double replay of prepared transactions during crash recovery (suyu.cmj, Michael Paquier) § § After a crash partway through a checkpoint with some two-phase transaction state data already flushed to disk by this checkpoint, crash recovery could attempt to replay the prepared transaction(s) twice, leading to a fatal error such as “lock is already held” in the startup process.","title":"Avoid double replay of prepared transactions during crash recovery","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["1b4f1c6f8","4b4798e13","6377f705c","acc8cdff4","d431644b4","d85bf0719","e24c02e4d"],"commit_groups":[["1b4f1c6f8","4b4798e13","6377f705c","acc8cdff4","d431644b4","d85bf0719","e24c02e4d"]],"commits":["e24c02e4d"],"cves":[],"db_id":"1f24d024d1cc473b2b88022f067a97fe","html":"\u003cp\u003eEnsure that a newly created, but still empty table is \u003ccode\u003efsync\u003c/code\u003e'ed at the next checkpoint (Heikki Linnakangas) \u003ca href=\"https://postgr.es/c/e24c02e4d\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eWithout this, if there is an operating system crash causing the empty file to disappear, subsequent operations on the table might fail with \u003cspan\u003e“\u003cspan\u003ecould not open file\u003c/span\u003e”\u003c/span\u003e errors.\u003c/p\u003e","id":"15.4-fca13900b4806e1f","identity_text":"Ensure that a newly created, but still empty table is fsync'ed at the next checkpoint (Heikki Linnakangas) Without this, if there is an operating system crash causing the empty file to disappear, subsequent operations on the table might fail with could not open file errors.","part":"changes","patch_ids":["049dbff6a2f0b385b517bcd7f437e841"],"related_changes":[{"db_id":"dca66afe674adc9dbbeb5b1b7a00fd1a","evidence":{"patch_ids":["049dbff6a2f0b385b517bcd7f437e841"],"same_day":true,"statement_hash":"409e8a3ed9e99529bd95c83d017e6409283d734d80888c2300621d3f46190a82"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Ensure that a newly created, but still empty table is fsync'ed at the next checkpoint","url":"/docs/compare/?release=14.9#14.9-467735f6fd2e0b6a","version":"14.9"},{"db_id":"5a60a576107e98788cfc7b1335fbb197","evidence":{"patch_ids":["049dbff6a2f0b385b517bcd7f437e841"],"same_day":true,"statement_hash":"409e8a3ed9e99529bd95c83d017e6409283d734d80888c2300621d3f46190a82"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Ensure that a newly created, but still empty table is fsync'ed at the next checkpoint","url":"/docs/compare/?release=13.12#13.12-6b802c88945c201c","version":"13.12"},{"db_id":"c151b4e1d63b94f408b7d1bb9ffea7eb","evidence":{"patch_ids":["049dbff6a2f0b385b517bcd7f437e841"],"same_day":true,"statement_hash":"409e8a3ed9e99529bd95c83d017e6409283d734d80888c2300621d3f46190a82"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Ensure that a newly created, but still empty table is fsync'ed at the next checkpoint","url":"/docs/compare/?release=12.16#12.16-db5ef5a9a2ec27de","version":"12.16"},{"db_id":"55d592fd4725d51ec5b28a0ff2347039","evidence":{"patch_ids":["049dbff6a2f0b385b517bcd7f437e841"],"same_day":true,"statement_hash":"409e8a3ed9e99529bd95c83d017e6409283d734d80888c2300621d3f46190a82"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Ensure that a newly created, but still empty table is fsync'ed at the next checkpoint","url":"/docs/compare/?release=11.21#11.21-523c4a4325d22e13","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["049dbff6a2f0b385b517bcd7f437e841"],"same_day":true,"statement_hash":"409e8a3ed9e99529bd95c83d017e6409283d734d80888c2300621d3f46190a82"},"rule":2,"target":"55d592fd4725d51ec5b28a0ff2347039","type":"equivalent"},{"evidence":{"patch_ids":["049dbff6a2f0b385b517bcd7f437e841"],"same_day":true,"statement_hash":"409e8a3ed9e99529bd95c83d017e6409283d734d80888c2300621d3f46190a82"},"rule":2,"target":"5a60a576107e98788cfc7b1335fbb197","type":"equivalent"},{"evidence":{"patch_ids":["049dbff6a2f0b385b517bcd7f437e841"],"same_day":true,"statement_hash":"409e8a3ed9e99529bd95c83d017e6409283d734d80888c2300621d3f46190a82"},"rule":2,"target":"c151b4e1d63b94f408b7d1bb9ffea7eb","type":"equivalent"},{"evidence":{"patch_ids":["049dbff6a2f0b385b517bcd7f437e841"],"same_day":true,"statement_hash":"409e8a3ed9e99529bd95c83d017e6409283d734d80888c2300621d3f46190a82"},"rule":2,"target":"dca66afe674adc9dbbeb5b1b7a00fd1a","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["e24c02e4d"],"source_entry_id":"15.4/changes/031","source_hash":"9772a60c2124d1d436767bf8936f813a0cbb5de26c90c327f0bdbf98acbbb2fd","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"409e8a3ed9e99529bd95c83d017e6409283d734d80888c2300621d3f46190a82","text":"Ensure that a newly created, but still empty table is fsync'ed at the next checkpoint (Heikki Linnakangas) § Without this, if there is an operating system crash causing the empty file to disappear, subsequent operations on the table might fail with “could not open file” errors.","title":"Ensure that a newly created, but still empty table is fsync'ed at the next checkpoint","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["25624c5d3","3142a8845","32f327f68","80abec387","988719b88","bf7b70e6b","c50b869ed"],"commit_groups":[["25624c5d3","3142a8845","32f327f68","80abec387","988719b88","bf7b70e6b","c50b869ed"]],"commits":["25624c5d3"],"cves":[],"db_id":"1a6f5bdececb46ec6b0cf4157dcbcaa5","html":"\u003cp\u003eEnsure that creation of the init fork of an unlogged index is WAL-logged (Heikki Linnakangas) \u003ca href=\"https://postgr.es/c/25624c5d3\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eWhile an unlogged index's main data fork is not WAL-logged, its init fork should be, to ensure that we have a consistent state to restore the index to after a crash. This step was missed if the init fork contains no data, which is a case not used by any standard index AM; but perhaps some extension behaves that way.\u003c/p\u003e","id":"15.4-53cd2b1f69e1e446","identity_text":"Ensure that creation of the init fork of an unlogged index is WAL-logged (Heikki Linnakangas) While an unlogged index's main data fork is not WAL-logged, its init fork should be, to ensure that we have a consistent state to restore the index to after a crash. This step was missed if the init fork contains no data, which is a case not used by any standard index AM; but perhaps some extension behaves that way.","part":"changes","patch_ids":["b78093f0d064b321d5d6e08d7eba300f"],"related_changes":[{"db_id":"6229c2037e3574a942ab71441502ffc2","evidence":{"patch_ids":["b78093f0d064b321d5d6e08d7eba300f"],"same_day":true,"statement_hash":"b28db5f39895a21a6b9a6ff2b1c31193f9326499fcc24fe6e56b63b22f21804c"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Ensure that creation of the init fork of an unlogged index is WAL-logged","url":"/docs/compare/?release=14.9#14.9-c6d8832fcb5e9cbe","version":"14.9"},{"db_id":"f8c6097b6641e980e7ef9b9b1dcb2e3e","evidence":{"patch_ids":["b78093f0d064b321d5d6e08d7eba300f"],"same_day":true,"statement_hash":"b28db5f39895a21a6b9a6ff2b1c31193f9326499fcc24fe6e56b63b22f21804c"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Ensure that creation of the init fork of an unlogged index is WAL-logged","url":"/docs/compare/?release=13.12#13.12-027cb2be867289ac","version":"13.12"},{"db_id":"8d016bdc03fd9080c3d091b869de5a48","evidence":{"patch_ids":["b78093f0d064b321d5d6e08d7eba300f"],"same_day":true,"statement_hash":"b28db5f39895a21a6b9a6ff2b1c31193f9326499fcc24fe6e56b63b22f21804c"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Ensure that creation of the init fork of an unlogged index is WAL-logged","url":"/docs/compare/?release=12.16#12.16-0a6d750c36e5e2d5","version":"12.16"},{"db_id":"d00152ea427a7e39ed1a638687d4812c","evidence":{"patch_ids":["b78093f0d064b321d5d6e08d7eba300f"],"same_day":true,"statement_hash":"b28db5f39895a21a6b9a6ff2b1c31193f9326499fcc24fe6e56b63b22f21804c"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Ensure that creation of the init fork of an unlogged index is WAL-logged","url":"/docs/compare/?release=11.21#11.21-62f8c79f3c4a9076","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["b78093f0d064b321d5d6e08d7eba300f"],"same_day":true,"statement_hash":"b28db5f39895a21a6b9a6ff2b1c31193f9326499fcc24fe6e56b63b22f21804c"},"rule":2,"target":"6229c2037e3574a942ab71441502ffc2","type":"equivalent"},{"evidence":{"patch_ids":["b78093f0d064b321d5d6e08d7eba300f"],"same_day":true,"statement_hash":"b28db5f39895a21a6b9a6ff2b1c31193f9326499fcc24fe6e56b63b22f21804c"},"rule":2,"target":"8d016bdc03fd9080c3d091b869de5a48","type":"equivalent"},{"evidence":{"patch_ids":["b78093f0d064b321d5d6e08d7eba300f"],"same_day":true,"statement_hash":"b28db5f39895a21a6b9a6ff2b1c31193f9326499fcc24fe6e56b63b22f21804c"},"rule":2,"target":"d00152ea427a7e39ed1a638687d4812c","type":"equivalent"},{"evidence":{"patch_ids":["b78093f0d064b321d5d6e08d7eba300f"],"same_day":true,"statement_hash":"b28db5f39895a21a6b9a6ff2b1c31193f9326499fcc24fe6e56b63b22f21804c"},"rule":2,"target":"f8c6097b6641e980e7ef9b9b1dcb2e3e","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["25624c5d3"],"source_entry_id":"15.4/changes/032","source_hash":"bb891081122c897dd994b5c2073f3be9fe3897ca3c2b5163087f32edbcf9b42c","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"b28db5f39895a21a6b9a6ff2b1c31193f9326499fcc24fe6e56b63b22f21804c","text":"Ensure that creation of the init fork of an unlogged index is WAL-logged (Heikki Linnakangas) § While an unlogged index's main data fork is not WAL-logged, its init fork should be, to ensure that we have a consistent state to restore the index to after a crash. This step was missed if the init fork contains no data, which is a case not used by any standard index AM; but perhaps some extension behaves that way.","title":"Ensure that creation of the init fork of an unlogged index is WAL-logged","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["4637a6ac0","76d5966b3","f50200c01"],"commit_groups":[["4637a6ac0","76d5966b3","f50200c01"]],"commits":["f50200c01"],"cves":[],"db_id":"a196b42d000689d89b5c95b8b3f459ec","html":"\u003cp\u003eSilence bogus \u003cspan\u003e“\u003cspan\u003emissing contrecord\u003c/span\u003e”\u003c/span\u003e errors (Thomas Munro) \u003ca href=\"https://postgr.es/c/f50200c01\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eTreat this case as plain end-of-WAL to avoid logging inaccurate complaints from \u003cspan\u003epg_waldump\u003c/span\u003e and \u003cspan\u003ewalsender\u003c/span\u003e.\u003c/p\u003e","id":"15.4-467d17596c2bc6fa","identity_text":"Silence bogus missing contrecord errors (Thomas Munro) Treat this case as plain end-of-WAL to avoid logging inaccurate complaints from pg_waldump and walsender.","part":"changes","patch_ids":["c66352f3fdce53d4dfb31b69ac93e548"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["f50200c01"],"source_entry_id":"15.4/changes/033","source_hash":"72b87b4f2758b97756b05ed0d608284226a75f0614806453bf382c2617db3a6d","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"3313ec2209a38e6c1828150d6719187c8629a60a537cebfbd097a31ca9a94ec3","text":"Silence bogus “missing contrecord” errors (Thomas Munro) § Treat this case as plain end-of-WAL to avoid logging inaccurate complaints from pg_waldump and walsender.","title":"Silence bogus “missing contrecord” errors","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["668990980","67f3a697b","74a5bf1b6","b25acc302","deae1657e","f457f2ef1"],"commit_groups":[["668990980","67f3a697b","74a5bf1b6","b25acc302","deae1657e","f457f2ef1"]],"commits":["67f3a697b"],"cves":[],"db_id":"a6ecf4710335a0726aa07a4577c4e91d","html":"\u003cp\u003eFix overly strict assertion in \u003ccode\u003ejsonpath\u003c/code\u003e code (David Rowley) \u003ca href=\"https://postgr.es/c/67f3a697b\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThis assertion failed if a query applied the \u003ccode\u003e.type()\u003c/code\u003e operator to a \u003ccode\u003elike_regex\u003c/code\u003e result. There was no bug in non-assert builds.\u003c/p\u003e","id":"15.4-f0de47016af19448","identity_text":"Fix overly strict assertion in jsonpath code (David Rowley) This assertion failed if a query applied the .type() operator to a like_regex result. There was no bug in non-assert builds.","part":"changes","patch_ids":["f1e37ee56ecf82bc0cd5a8071e7438c7"],"related_changes":[{"db_id":"e56effc9717ab8b4ae91c8416cb06cfa","evidence":{"patch_ids":["f1e37ee56ecf82bc0cd5a8071e7438c7"],"same_day":true,"statement_hash":"26966f1981e3ef64ced3ffa50131a7d15df38552fa949729a13421d17a5de2e6"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Fix overly strict assertion in jsonpath code","url":"/docs/compare/?release=14.9#14.9-6e94f765e357aea2","version":"14.9"},{"db_id":"3cc699b8ccba6ff8487aed923c5a41c9","evidence":{"patch_ids":["f1e37ee56ecf82bc0cd5a8071e7438c7"],"same_day":true,"statement_hash":"26966f1981e3ef64ced3ffa50131a7d15df38552fa949729a13421d17a5de2e6"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Fix overly strict assertion in jsonpath code","url":"/docs/compare/?release=13.12#13.12-709101d33587bcdc","version":"13.12"},{"db_id":"eba2f94412c31fb1523c3bf22fc4dddf","evidence":{"patch_ids":["f1e37ee56ecf82bc0cd5a8071e7438c7"],"same_day":true,"statement_hash":"26966f1981e3ef64ced3ffa50131a7d15df38552fa949729a13421d17a5de2e6"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Fix overly strict assertion in jsonpath code","url":"/docs/compare/?release=12.16#12.16-4eb2216c9abdbd96","version":"12.16"}],"relations":[{"evidence":{"patch_ids":["f1e37ee56ecf82bc0cd5a8071e7438c7"],"same_day":true,"statement_hash":"26966f1981e3ef64ced3ffa50131a7d15df38552fa949729a13421d17a5de2e6"},"rule":2,"target":"3cc699b8ccba6ff8487aed923c5a41c9","type":"equivalent"},{"evidence":{"patch_ids":["f1e37ee56ecf82bc0cd5a8071e7438c7"],"same_day":true,"statement_hash":"26966f1981e3ef64ced3ffa50131a7d15df38552fa949729a13421d17a5de2e6"},"rule":2,"target":"e56effc9717ab8b4ae91c8416cb06cfa","type":"equivalent"},{"evidence":{"patch_ids":["f1e37ee56ecf82bc0cd5a8071e7438c7"],"same_day":true,"statement_hash":"26966f1981e3ef64ced3ffa50131a7d15df38552fa949729a13421d17a5de2e6"},"rule":2,"target":"eba2f94412c31fb1523c3bf22fc4dddf","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["67f3a697b"],"source_entry_id":"15.4/changes/034","source_hash":"20fdd39e40edaf036c7da8c6a209eb31ad706e4ed4cc81447e84406b63ace4ea","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"26966f1981e3ef64ced3ffa50131a7d15df38552fa949729a13421d17a5de2e6","text":"Fix overly strict assertion in jsonpath code (David Rowley) § This assertion failed if a query applied the .type() operator to a like_regex result. There was no bug in non-assert builds.","title":"Fix overly strict assertion in jsonpath code","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["120ea65b8","555b929bb","a8be2356c","a98a04005","cb74f7bec","d1fc0f382"],"commit_groups":[["120ea65b8","555b929bb","a8be2356c","a98a04005","cb74f7bec","d1fc0f382"]],"commits":["cb74f7bec"],"cves":[],"db_id":"a258f42228ecb1f58c2f8504abc82b51","html":"\u003cp\u003eAvoid assertion failure when processing an empty statement via the extended query protocol in an already-aborted transaction (Tom Lane) \u003ca href=\"https://postgr.es/c/cb74f7bec\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"15.4-b063537f38db19e6","identity_text":"Avoid assertion failure when processing an empty statement via the extended query protocol in an already-aborted transaction (Tom Lane)","part":"changes","patch_ids":["76b8835b226ceae0e20b3baeb0deb57b"],"related_changes":[{"db_id":"b3a0cae2dd7ad118cf5a6e79b5429bf9","evidence":{"patch_ids":["76b8835b226ceae0e20b3baeb0deb57b"],"same_day":true,"statement_hash":"0685e7604a2f70426e9632d7348dd4ef1da6f6d4b3909b2e7def41ee3c48aab3"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Avoid assertion failure when processing an empty statement via the extended query protocol in an already-aborted transaction","url":"/docs/compare/?release=14.9#14.9-94c9bb6f5fac3128","version":"14.9"},{"db_id":"f5e21dd6c0032fa4626be77324640f51","evidence":{"patch_ids":["76b8835b226ceae0e20b3baeb0deb57b"],"same_day":true,"statement_hash":"0685e7604a2f70426e9632d7348dd4ef1da6f6d4b3909b2e7def41ee3c48aab3"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Avoid assertion failure when processing an empty statement via the extended query protocol in an already-aborted transaction","url":"/docs/compare/?release=13.12#13.12-b184e575728782e1","version":"13.12"},{"db_id":"a67f4c680121b50e3857df8af8ab3351","evidence":{"patch_ids":["76b8835b226ceae0e20b3baeb0deb57b"],"same_day":true,"statement_hash":"0685e7604a2f70426e9632d7348dd4ef1da6f6d4b3909b2e7def41ee3c48aab3"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Avoid assertion failure when processing an empty statement via the extended query protocol in an already-aborted transaction","url":"/docs/compare/?release=12.16#12.16-e194dff347229545","version":"12.16"},{"db_id":"d613743ac204fb3f51a645b90a6cd0f9","evidence":{"patch_ids":["76b8835b226ceae0e20b3baeb0deb57b"],"same_day":true,"statement_hash":"0685e7604a2f70426e9632d7348dd4ef1da6f6d4b3909b2e7def41ee3c48aab3"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Avoid assertion failure when processing an empty statement via the extended query protocol in an already-aborted transaction","url":"/docs/compare/?release=11.21#11.21-e465e6b1b45c42f9","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["76b8835b226ceae0e20b3baeb0deb57b"],"same_day":true,"statement_hash":"0685e7604a2f70426e9632d7348dd4ef1da6f6d4b3909b2e7def41ee3c48aab3"},"rule":2,"target":"a67f4c680121b50e3857df8af8ab3351","type":"equivalent"},{"evidence":{"patch_ids":["76b8835b226ceae0e20b3baeb0deb57b"],"same_day":true,"statement_hash":"0685e7604a2f70426e9632d7348dd4ef1da6f6d4b3909b2e7def41ee3c48aab3"},"rule":2,"target":"b3a0cae2dd7ad118cf5a6e79b5429bf9","type":"equivalent"},{"evidence":{"patch_ids":["76b8835b226ceae0e20b3baeb0deb57b"],"same_day":true,"statement_hash":"0685e7604a2f70426e9632d7348dd4ef1da6f6d4b3909b2e7def41ee3c48aab3"},"rule":2,"target":"d613743ac204fb3f51a645b90a6cd0f9","type":"equivalent"},{"evidence":{"patch_ids":["76b8835b226ceae0e20b3baeb0deb57b"],"same_day":true,"statement_hash":"0685e7604a2f70426e9632d7348dd4ef1da6f6d4b3909b2e7def41ee3c48aab3"},"rule":2,"target":"f5e21dd6c0032fa4626be77324640f51","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["cb74f7bec"],"source_entry_id":"15.4/changes/035","source_hash":"41586f66ae5afe89951ae1bf67500adffacd92ea26d08df1af745c649577c03e","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"0685e7604a2f70426e9632d7348dd4ef1da6f6d4b3909b2e7def41ee3c48aab3","text":"Avoid assertion failure when processing an empty statement via the extended query protocol in an already-aborted transaction (Tom Lane) §","title":"Avoid assertion failure when processing an empty statement via the extended query protocol in an already-aborted transaction","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["605994651","ccd21e1cf"],"commit_groups":[["605994651","ccd21e1cf"]],"commits":["ccd21e1cf"],"cves":[],"db_id":"ac1914b727378050fa74a3e3399f022d","html":"\u003cp\u003eAvoid assertion failure when the \u003ccode\u003estats_fetch_consistency\u003c/code\u003e setting is changed intra-transaction (Kyotaro Horiguchi) \u003ca href=\"https://postgr.es/c/ccd21e1cf\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"15.4-56e6a8c445bd7ea6","identity_text":"Avoid assertion failure when the stats_fetch_consistency setting is changed intra-transaction (Kyotaro Horiguchi)","part":"changes","patch_ids":["575f27e5f4899b7a6459367f64260252"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["ccd21e1cf"],"source_entry_id":"15.4/changes/036","source_hash":"ed659f059efe8e20dbac3ea7fa459d29fcdf6f30e9cc3c543d6a38018e272fb0","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"5ee490675a8e77687da62670daa0b90636871610fa414082f020812e9764c7c1","text":"Avoid assertion failure when the stats_fetch_consistency setting is changed intra-transaction (Kyotaro Horiguchi) §","title":"Avoid assertion failure when the stats_fetch_consistency setting is changed intra-transaction","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["0409c7fc7","0966291a4","1d369c9e9","8084bf9a4","ccd362325","eaf99e4c4"],"commit_groups":[["0409c7fc7","0966291a4","1d369c9e9","8084bf9a4","ccd362325","eaf99e4c4"]],"commits":["eaf99e4c4"],"cves":[],"db_id":"34d5b4cf8a88654524cbffb522fbc041","html":"\u003cp\u003eFix \u003ccode\u003econtrib/fuzzystrmatch\u003c/code\u003e's Soundex \u003ccode\u003edifference()\u003c/code\u003e function to handle empty input sanely (Alexander Lakhin, Tom Lane) \u003ca href=\"https://postgr.es/c/eaf99e4c4\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eAn input string containing no alphabetic characters resulted in unpredictable output.\u003c/p\u003e","id":"15.4-81dc287a31b9130c","identity_text":"Fix contrib/fuzzystrmatch's Soundex difference() function to handle empty input sanely (Alexander Lakhin, Tom Lane) An input string containing no alphabetic characters resulted in unpredictable output.","part":"changes","patch_ids":["3573a685e45d88a982ac87901164de13"],"related_changes":[{"db_id":"589ea7ef503eabaab241162ee498d78e","evidence":{"patch_ids":["3573a685e45d88a982ac87901164de13"],"same_day":true,"statement_hash":"41cfc6fd0465472261ed2041a5a196fd0b52c4932e72d4182522290e79522045"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Fix contrib/fuzzystrmatch's Soundex difference() function to handle empty input sanely","url":"/docs/compare/?release=14.9#14.9-0a97905cb225f378","version":"14.9"},{"db_id":"f044f495f143f1e40ea5915212b4ff95","evidence":{"patch_ids":["3573a685e45d88a982ac87901164de13"],"same_day":true,"statement_hash":"41cfc6fd0465472261ed2041a5a196fd0b52c4932e72d4182522290e79522045"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Fix contrib/fuzzystrmatch's Soundex difference() function to handle empty input sanely","url":"/docs/compare/?release=13.12#13.12-5efb34abb8063d41","version":"13.12"},{"db_id":"707bef99ea3bf43e9dee5969a332577e","evidence":{"patch_ids":["3573a685e45d88a982ac87901164de13"],"same_day":true,"statement_hash":"41cfc6fd0465472261ed2041a5a196fd0b52c4932e72d4182522290e79522045"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Fix contrib/fuzzystrmatch's Soundex difference() function to handle empty input sanely","url":"/docs/compare/?release=12.16#12.16-208f6a8de3b96b7a","version":"12.16"},{"db_id":"fe9f918f9bcecc834808b9cb4ea0a1f7","evidence":{"patch_ids":["3573a685e45d88a982ac87901164de13"],"same_day":true,"statement_hash":"41cfc6fd0465472261ed2041a5a196fd0b52c4932e72d4182522290e79522045"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Fix contrib/fuzzystrmatch's Soundex difference() function to handle empty input sanely","url":"/docs/compare/?release=11.21#11.21-53631a1688df68bc","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["3573a685e45d88a982ac87901164de13"],"same_day":true,"statement_hash":"41cfc6fd0465472261ed2041a5a196fd0b52c4932e72d4182522290e79522045"},"rule":2,"target":"589ea7ef503eabaab241162ee498d78e","type":"equivalent"},{"evidence":{"patch_ids":["3573a685e45d88a982ac87901164de13"],"same_day":true,"statement_hash":"41cfc6fd0465472261ed2041a5a196fd0b52c4932e72d4182522290e79522045"},"rule":2,"target":"707bef99ea3bf43e9dee5969a332577e","type":"equivalent"},{"evidence":{"patch_ids":["3573a685e45d88a982ac87901164de13"],"same_day":true,"statement_hash":"41cfc6fd0465472261ed2041a5a196fd0b52c4932e72d4182522290e79522045"},"rule":2,"target":"f044f495f143f1e40ea5915212b4ff95","type":"equivalent"},{"evidence":{"patch_ids":["3573a685e45d88a982ac87901164de13"],"same_day":true,"statement_hash":"41cfc6fd0465472261ed2041a5a196fd0b52c4932e72d4182522290e79522045"},"rule":2,"target":"fe9f918f9bcecc834808b9cb4ea0a1f7","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["eaf99e4c4"],"source_entry_id":"15.4/changes/037","source_hash":"ddadc60b904545750746cae203c3694d88f3a1035a46097b30cafe2c70dd2622","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"41cfc6fd0465472261ed2041a5a196fd0b52c4932e72d4182522290e79522045","text":"Fix contrib/fuzzystrmatch's Soundex difference() function to handle empty input sanely (Alexander Lakhin, Tom Lane) § An input string containing no alphabetic characters resulted in unpredictable output.","title":"Fix contrib/fuzzystrmatch's Soundex difference() function to handle empty input sanely","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["3a5222a43","78bf0a256","bbfc26d86","d522b05c8","e0e682945","edf1de65e"],"commit_groups":[["3a5222a43","78bf0a256","bbfc26d86","d522b05c8","e0e682945","edf1de65e"]],"commits":["3a5222a43"],"cves":[],"db_id":"b2bcc576e0da3c167f5c2cca7d134511","html":"\u003cp\u003eTighten whitespace checks in \u003ccode\u003econtrib/hstore\u003c/code\u003e input (Evan Jones) \u003ca href=\"https://postgr.es/c/3a5222a43\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eIn some cases, characters would be falsely recognized as whitespace and hence discarded.\u003c/p\u003e","id":"15.4-39befbe9153a0ab7","identity_text":"Tighten whitespace checks in contrib/hstore input (Evan Jones) In some cases, characters would be falsely recognized as whitespace and hence discarded.","part":"changes","patch_ids":["fd3f2c144444723a948e4bfe891dc921"],"related_changes":[{"db_id":"d5959c0e97bc0a541038e523bde30499","evidence":{"patch_ids":["fd3f2c144444723a948e4bfe891dc921"],"same_day":true,"statement_hash":"524580b5ff643de26ebae4f2d6897913f3d0edb29e845b3efa60e970e8711f79"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Tighten whitespace checks in contrib/hstore input","url":"/docs/compare/?release=14.9#14.9-ad615fa542616223","version":"14.9"},{"db_id":"70868303dc0cc8e7eb4715210981bc64","evidence":{"patch_ids":["fd3f2c144444723a948e4bfe891dc921"],"same_day":true,"statement_hash":"524580b5ff643de26ebae4f2d6897913f3d0edb29e845b3efa60e970e8711f79"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Tighten whitespace checks in contrib/hstore input","url":"/docs/compare/?release=13.12#13.12-1c322c720b1120e9","version":"13.12"},{"db_id":"9630e4e0d06e311eb7d387f0ffdc4153","evidence":{"patch_ids":["fd3f2c144444723a948e4bfe891dc921"],"same_day":true,"statement_hash":"524580b5ff643de26ebae4f2d6897913f3d0edb29e845b3efa60e970e8711f79"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Tighten whitespace checks in contrib/hstore input","url":"/docs/compare/?release=12.16#12.16-fcea2d21e85b5404","version":"12.16"},{"db_id":"a497c923fcbfeeba921329eb7569df78","evidence":{"patch_ids":["fd3f2c144444723a948e4bfe891dc921"],"same_day":true,"statement_hash":"524580b5ff643de26ebae4f2d6897913f3d0edb29e845b3efa60e970e8711f79"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Tighten whitespace checks in contrib/hstore input","url":"/docs/compare/?release=11.21#11.21-e6724eafa4a7cf98","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["fd3f2c144444723a948e4bfe891dc921"],"same_day":true,"statement_hash":"524580b5ff643de26ebae4f2d6897913f3d0edb29e845b3efa60e970e8711f79"},"rule":2,"target":"70868303dc0cc8e7eb4715210981bc64","type":"equivalent"},{"evidence":{"patch_ids":["fd3f2c144444723a948e4bfe891dc921"],"same_day":true,"statement_hash":"524580b5ff643de26ebae4f2d6897913f3d0edb29e845b3efa60e970e8711f79"},"rule":2,"target":"9630e4e0d06e311eb7d387f0ffdc4153","type":"equivalent"},{"evidence":{"patch_ids":["fd3f2c144444723a948e4bfe891dc921"],"same_day":true,"statement_hash":"524580b5ff643de26ebae4f2d6897913f3d0edb29e845b3efa60e970e8711f79"},"rule":2,"target":"a497c923fcbfeeba921329eb7569df78","type":"equivalent"},{"evidence":{"patch_ids":["fd3f2c144444723a948e4bfe891dc921"],"same_day":true,"statement_hash":"524580b5ff643de26ebae4f2d6897913f3d0edb29e845b3efa60e970e8711f79"},"rule":2,"target":"d5959c0e97bc0a541038e523bde30499","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["3a5222a43"],"source_entry_id":"15.4/changes/038","source_hash":"73633bd70e285db111451c18a3dfa5f95fed2bd3a42727814143844de3e6131f","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"524580b5ff643de26ebae4f2d6897913f3d0edb29e845b3efa60e970e8711f79","text":"Tighten whitespace checks in contrib/hstore input (Evan Jones) § In some cases, characters would be falsely recognized as whitespace and hence discarded.","title":"Tighten whitespace checks in contrib/hstore input","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["019a40d61","4be308ede","6ecc1c02a","ab40b0395","ae9aac64a","c00fbe89d"],"commit_groups":[["019a40d61","4be308ede","6ecc1c02a","ab40b0395","ae9aac64a","c00fbe89d"]],"commits":["4be308ede"],"cves":[],"db_id":"7ea5f5c4674eb601f9e72ef4cab013b0","html":"\u003cp\u003eDisallow oversize input arrays with \u003ccode\u003econtrib/intarray\u003c/code\u003e's \u003ccode\u003egist__int_ops\u003c/code\u003e index opclass (Ankit Kumar Pandey, Alexander Lakhin) \u003ca href=\"https://postgr.es/c/4be308ede\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003ePreviously this code would report a \u003ccode\u003eNOTICE\u003c/code\u003e but press on anyway, creating an invalid index entry that presents a risk of crashes when the index is read.\u003c/p\u003e","id":"15.4-1cffa0c8d86b1514","identity_text":"Disallow oversize input arrays with contrib/intarray's gist__int_ops index opclass (Ankit Kumar Pandey, Alexander Lakhin) Previously this code would report a NOTICE but press on anyway, creating an invalid index entry that presents a risk of crashes when the index is read.","part":"changes","patch_ids":["0109410501fac99f629213e8604443d1"],"related_changes":[{"db_id":"5e0e6d65dc2e4f4aaa42f607a04e9b0e","evidence":{"patch_ids":["0109410501fac99f629213e8604443d1"],"same_day":true,"statement_hash":"a478fa4c5073f50e1e10c2ab79b3ca3c6048ec0dc96e71ed4a7548e911e34a8e"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Disallow oversize input arrays with contrib/intarray's gist__int_ops index opclass","url":"/docs/compare/?release=14.9#14.9-5b4d36d637d423fd","version":"14.9"},{"db_id":"b11f905439066cd9aab8d7b64038369a","evidence":{"patch_ids":["0109410501fac99f629213e8604443d1"],"same_day":true,"statement_hash":"a478fa4c5073f50e1e10c2ab79b3ca3c6048ec0dc96e71ed4a7548e911e34a8e"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Disallow oversize input arrays with contrib/intarray's gist__int_ops index opclass","url":"/docs/compare/?release=13.12#13.12-78f1865b153b61c5","version":"13.12"},{"db_id":"7469e2c3cf3de774562c6a504ff42c34","evidence":{"patch_ids":["0109410501fac99f629213e8604443d1"],"same_day":true,"statement_hash":"a478fa4c5073f50e1e10c2ab79b3ca3c6048ec0dc96e71ed4a7548e911e34a8e"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Disallow oversize input arrays with contrib/intarray's gist__int_ops index opclass","url":"/docs/compare/?release=12.16#12.16-bfb87d662327dcea","version":"12.16"},{"db_id":"9d51556381941ed7ec438ef36bc5112a","evidence":{"patch_ids":["0109410501fac99f629213e8604443d1"],"same_day":true,"statement_hash":"a478fa4c5073f50e1e10c2ab79b3ca3c6048ec0dc96e71ed4a7548e911e34a8e"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Disallow oversize input arrays with contrib/intarray's gist__int_ops index opclass","url":"/docs/compare/?release=11.21#11.21-ee4119693b647c14","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["0109410501fac99f629213e8604443d1"],"same_day":true,"statement_hash":"a478fa4c5073f50e1e10c2ab79b3ca3c6048ec0dc96e71ed4a7548e911e34a8e"},"rule":2,"target":"5e0e6d65dc2e4f4aaa42f607a04e9b0e","type":"equivalent"},{"evidence":{"patch_ids":["0109410501fac99f629213e8604443d1"],"same_day":true,"statement_hash":"a478fa4c5073f50e1e10c2ab79b3ca3c6048ec0dc96e71ed4a7548e911e34a8e"},"rule":2,"target":"7469e2c3cf3de774562c6a504ff42c34","type":"equivalent"},{"evidence":{"patch_ids":["0109410501fac99f629213e8604443d1"],"same_day":true,"statement_hash":"a478fa4c5073f50e1e10c2ab79b3ca3c6048ec0dc96e71ed4a7548e911e34a8e"},"rule":2,"target":"9d51556381941ed7ec438ef36bc5112a","type":"equivalent"},{"evidence":{"patch_ids":["0109410501fac99f629213e8604443d1"],"same_day":true,"statement_hash":"a478fa4c5073f50e1e10c2ab79b3ca3c6048ec0dc96e71ed4a7548e911e34a8e"},"rule":2,"target":"b11f905439066cd9aab8d7b64038369a","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["4be308ede"],"source_entry_id":"15.4/changes/039","source_hash":"8c8228a4c63acdd56c756efbc3aff0b0157dfc04216d3d5f421e139637e5f351","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"a478fa4c5073f50e1e10c2ab79b3ca3c6048ec0dc96e71ed4a7548e911e34a8e","text":"Disallow oversize input arrays with contrib/intarray's gist__int_ops index opclass (Ankit Kumar Pandey, Alexander Lakhin) § Previously this code would report a NOTICE but press on anyway, creating an invalid index entry that presents a risk of crashes when the index is read.","title":"Disallow oversize input arrays with contrib/intarray's gist__int_ops index opclass","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["5cb461989","7fffcc2ee","8aac9759b","8d8f37149","9f70f6d4c","a6991f763","e27f3f52c"],"commit_groups":[["5cb461989","7fffcc2ee","8aac9759b","8d8f37149","9f70f6d4c","a6991f763","e27f3f52c"]],"commits":["5cb461989"],"cves":[],"db_id":"9ed9ace97321cdaa59223da10ca1b85b","html":"\u003cp\u003eAvoid useless double decompression of GiST index entries in \u003ccode\u003econtrib/intarray\u003c/code\u003e (Konstantin Knizhnik, Matthias van de Meent, Tom Lane) \u003ca href=\"https://postgr.es/c/5cb461989\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"15.4-3162ce8e4c581938","identity_text":"Avoid useless double decompression of GiST index entries in contrib/intarray (Konstantin Knizhnik, Matthias van de Meent, Tom Lane)","part":"changes","patch_ids":["2ab80b9da3cdc1e81922aeb27d0c66e7"],"related_changes":[{"db_id":"1c221c67fb081abd2d101126f4dfcc03","evidence":{"patch_ids":["2ab80b9da3cdc1e81922aeb27d0c66e7"],"same_day":true,"statement_hash":"6b26f1dd17b3679bdfc50529b671286bdf78b336f5848d2ac73885d6d43bbcd3"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Avoid useless double decompression of GiST index entries in contrib/intarray","url":"/docs/compare/?release=14.9#14.9-0e6226e50b9a1f9d","version":"14.9"},{"db_id":"9d392475f610082e5ffda498c1b1bc74","evidence":{"patch_ids":["2ab80b9da3cdc1e81922aeb27d0c66e7"],"same_day":true,"statement_hash":"6b26f1dd17b3679bdfc50529b671286bdf78b336f5848d2ac73885d6d43bbcd3"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Avoid useless double decompression of GiST index entries in contrib/intarray","url":"/docs/compare/?release=13.12#13.12-766c07d6aa929eb3","version":"13.12"},{"db_id":"504806bf47f0584c3363f741f732a9a5","evidence":{"patch_ids":["2ab80b9da3cdc1e81922aeb27d0c66e7"],"same_day":true,"statement_hash":"6b26f1dd17b3679bdfc50529b671286bdf78b336f5848d2ac73885d6d43bbcd3"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Avoid useless double decompression of GiST index entries in contrib/intarray","url":"/docs/compare/?release=12.16#12.16-19f79385caa15687","version":"12.16"},{"db_id":"0c7608e0799fa9d3bd7575889e780086","evidence":{"patch_ids":["2ab80b9da3cdc1e81922aeb27d0c66e7"],"same_day":true,"statement_hash":"6b26f1dd17b3679bdfc50529b671286bdf78b336f5848d2ac73885d6d43bbcd3"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Avoid useless double decompression of GiST index entries in contrib/intarray","url":"/docs/compare/?release=11.21#11.21-8a9191489c345396","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["2ab80b9da3cdc1e81922aeb27d0c66e7"],"same_day":true,"statement_hash":"6b26f1dd17b3679bdfc50529b671286bdf78b336f5848d2ac73885d6d43bbcd3"},"rule":2,"target":"0c7608e0799fa9d3bd7575889e780086","type":"equivalent"},{"evidence":{"patch_ids":["2ab80b9da3cdc1e81922aeb27d0c66e7"],"same_day":true,"statement_hash":"6b26f1dd17b3679bdfc50529b671286bdf78b336f5848d2ac73885d6d43bbcd3"},"rule":2,"target":"1c221c67fb081abd2d101126f4dfcc03","type":"equivalent"},{"evidence":{"patch_ids":["2ab80b9da3cdc1e81922aeb27d0c66e7"],"same_day":true,"statement_hash":"6b26f1dd17b3679bdfc50529b671286bdf78b336f5848d2ac73885d6d43bbcd3"},"rule":2,"target":"504806bf47f0584c3363f741f732a9a5","type":"equivalent"},{"evidence":{"patch_ids":["2ab80b9da3cdc1e81922aeb27d0c66e7"],"same_day":true,"statement_hash":"6b26f1dd17b3679bdfc50529b671286bdf78b336f5848d2ac73885d6d43bbcd3"},"rule":2,"target":"9d392475f610082e5ffda498c1b1bc74","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["5cb461989"],"source_entry_id":"15.4/changes/040","source_hash":"7169bd7e3b22a25c0dd5af986ebc423cd58564ea2b2333f3ea321ebaa4920c54","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"6b26f1dd17b3679bdfc50529b671286bdf78b336f5848d2ac73885d6d43bbcd3","text":"Avoid useless double decompression of GiST index entries in contrib/intarray (Konstantin Knizhnik, Matthias van de Meent, Tom Lane) §","title":"Avoid useless double decompression of GiST index entries in contrib/intarray","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["2dd778221","e72580232","e7bff46e5"],"commit_groups":[["2dd778221","e72580232","e7bff46e5"]],"commits":["2dd778221"],"cves":[],"db_id":"4176415f7e1fd1297caedf0610ab6a6c","html":"\u003cp\u003eFix \u003ccode\u003econtrib/pageinspect\u003c/code\u003e's \u003ccode\u003egist_page_items()\u003c/code\u003e function to work when there are included index columns (Alexander Lakhin, Michael Paquier) \u003ca href=\"https://postgr.es/c/2dd778221\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003ePreviously, if the index has included columns, \u003ccode\u003egist_page_items()\u003c/code\u003e would fail to display those values on index leaf pages, or crash outright on non-leaf pages.\u003c/p\u003e","id":"15.4-42af327f0e2b2d1e","identity_text":"Fix contrib/pageinspect's gist_page_items() function to work when there are included index columns (Alexander Lakhin, Michael Paquier) Previously, if the index has included columns, gist_page_items() would fail to display those values on index leaf pages, or crash outright on non-leaf pages.","part":"changes","patch_ids":["78c2fc73c8bc7f483ddcc710ba8ec11b"],"related_changes":[{"db_id":"8779fd3cff0da891a7c0a26f4e5f0fdf","evidence":{"patch_ids":["78c2fc73c8bc7f483ddcc710ba8ec11b"],"same_day":true,"statement_hash":"bc48b49203192d169927ccc366c2d34038d33cf9c3e8febcdd9363a08c74b048"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Fix contrib/pageinspect's gist_page_items() function to work when there are included index columns","url":"/docs/compare/?release=14.9#14.9-3d54376c6987b080","version":"14.9"}],"relations":[{"evidence":{"patch_ids":["78c2fc73c8bc7f483ddcc710ba8ec11b"],"same_day":true,"statement_hash":"bc48b49203192d169927ccc366c2d34038d33cf9c3e8febcdd9363a08c74b048"},"rule":2,"target":"8779fd3cff0da891a7c0a26f4e5f0fdf","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["2dd778221"],"source_entry_id":"15.4/changes/041","source_hash":"f236a2af44db88f8a650f9610c2430722d4ed89cc0fad2ac2313fa075d2f2ef5","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"bc48b49203192d169927ccc366c2d34038d33cf9c3e8febcdd9363a08c74b048","text":"Fix contrib/pageinspect's gist_page_items() function to work when there are included index columns (Alexander Lakhin, Michael Paquier) § Previously, if the index has included columns, gist_page_items() would fail to display those values on index leaf pages, or crash outright on non-leaf pages.","title":"Fix contrib/pageinspect's gist_page_items() function to work when there are included index columns","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["51b2c0879","bc478a0a8"],"commit_groups":[["51b2c0879","bc478a0a8"]],"commits":["bc478a0a8"],"cves":[],"db_id":"4bbc31bf476afdb32077be313bdc79b4","html":"\u003cp\u003eIn \u003cspan\u003epsql\u003c/span\u003e, ignore the \u003ccode\u003ePSQL_WATCH_PAGER\u003c/code\u003e environment variable when stdin/stdout are not a terminal (Tom Lane) \u003ca href=\"https://postgr.es/c/bc478a0a8\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThis corresponds to the treatment of \u003ccode\u003ePSQL_PAGER\u003c/code\u003e in commands besides \u003ccode\u003e\\watch\u003c/code\u003e.\u003c/p\u003e","id":"15.4-50ec1f8e459d06d1","identity_text":"In psql, ignore the PSQL_WATCH_PAGER environment variable when stdin/stdout are not a terminal (Tom Lane) This corresponds to the treatment of PSQL_PAGER in commands besides \\watch.","part":"changes","patch_ids":["8bf9e2c27c82ea7dea21623044b83ece"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["bc478a0a8"],"source_entry_id":"15.4/changes/042","source_hash":"e1fa2879a4db2865dbf014e1fd31614ba542ea8dba54cca1f5583753ac721679","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"6d23790e28e8d5922652ffde6b9d5a7f9807d7674135decfd2af60b57745916a","text":"In psql, ignore the PSQL_WATCH_PAGER environment variable when stdin/stdout are not a terminal (Tom Lane) § This corresponds to the treatment of PSQL_PAGER in commands besides \\watch.","title":"In psql, ignore the PSQL_WATCH_PAGER environment variable when stdin/stdout are not a terminal","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["016107478","ca9e79274","d6f549d7a"],"commit_groups":[["016107478","ca9e79274","d6f549d7a"]],"commits":["ca9e79274"],"cves":[],"db_id":"a9ed87cd7edf07c41e44368320f88119","html":"\u003cp\u003eFix \u003cspan\u003epg_dump\u003c/span\u003e to correctly handle new-style SQL-language functions whose bodies require parse-time dependencies on unique indexes (Tom Lane) \u003ca href=\"https://postgr.es/c/ca9e79274\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eSuch cases can arise from \u003ccode\u003eGROUP BY\u003c/code\u003e and \u003ccode\u003eON CONFLICT\u003c/code\u003e clauses, for example. The function must then be postponed until after the unique index in the dump output, but \u003cspan\u003epg_dump\u003c/span\u003e did not do that and instead printed a warning about \u003cspan\u003e“\u003cspan\u003ecould not resolve dependency loop\u003c/span\u003e”\u003c/span\u003e.\u003c/p\u003e","id":"15.4-cadc872ab1a9ca0d","identity_text":"Fix pg_dump to correctly handle new-style SQL-language functions whose bodies require parse-time dependencies on unique indexes (Tom Lane) Such cases can arise from GROUP BY and ON CONFLICT clauses, for example. The function must then be postponed until after the unique index in the dump output, but pg_dump did not do that and instead printed a warning about could not resolve dependency loop.","part":"changes","patch_ids":["6303958f154250b1c3f96051c43906ea"],"related_changes":[{"db_id":"7005d30295fd3ffeddf169ac94af3a8f","evidence":{"patch_ids":["6303958f154250b1c3f96051c43906ea"],"same_day":true,"statement_hash":"4650be529ca60d511e9cd6c8f38bbf2f4996e681f5f77e81c8afe8ce79194d44"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Fix pg_dump to correctly handle new-style SQL-language functions whose bodies require parse-time dependencies on unique indexes","url":"/docs/compare/?release=14.9#14.9-dc3c807443f52ad4","version":"14.9"}],"relations":[{"evidence":{"patch_ids":["6303958f154250b1c3f96051c43906ea"],"same_day":true,"statement_hash":"4650be529ca60d511e9cd6c8f38bbf2f4996e681f5f77e81c8afe8ce79194d44"},"rule":2,"target":"7005d30295fd3ffeddf169ac94af3a8f","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["ca9e79274"],"source_entry_id":"15.4/changes/043","source_hash":"f941be92da347a51a171460adb0a787adfb7d0aee59d29ce7083afd05f698d5f","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"4650be529ca60d511e9cd6c8f38bbf2f4996e681f5f77e81c8afe8ce79194d44","text":"Fix pg_dump to correctly handle new-style SQL-language functions whose bodies require parse-time dependencies on unique indexes (Tom Lane) § Such cases can arise from GROUP BY and ON CONFLICT clauses, for example. The function must then be postponed until after the unique index in the dump output, but pg_dump did not do that and instead printed a warning about “could not resolve dependency loop”.","title":"Fix pg_dump to correctly handle new-style SQL-language functions whose bodies require parse-time dependencies on unique indexes","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["751ba1a7c","b3f32a6c3"],"commit_groups":[["751ba1a7c","b3f32a6c3"]],"commits":["751ba1a7c"],"cves":[],"db_id":"81e8cc27018cfbdc12e5b5ad5610104b","html":"\u003cp\u003eImprove \u003cspan\u003epg_dump\u003c/span\u003e's display of details about dependency-loop problems (Tom Lane) \u003ca href=\"https://postgr.es/c/751ba1a7c\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"15.4-5bb7ce1fc5c85a67","identity_text":"Improve pg_dump's display of details about dependency-loop problems (Tom Lane)","part":"changes","patch_ids":["c455833941893d1525b090035baaaa25"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["751ba1a7c"],"source_entry_id":"15.4/changes/044","source_hash":"ca4290774cc9ce3fc772da71e2d41c14cde8db0b065559c2b527be8863e7f972","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"71fe26a4f0afd57965953712874e02de271256c58969857bd8e8b20bb6b6d6c1","text":"Improve pg_dump's display of details about dependency-loop problems (Tom Lane) §","title":"Improve pg_dump's display of details about dependency-loop problems","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["34f511965","8f5e42d33"],"commit_groups":[["34f511965","8f5e42d33"]],"commits":["34f511965"],"cves":[],"db_id":"8c8d147c8c54c614d8d0ed113fce4991","html":"\u003cp\u003eAvoid crash in \u003cspan\u003epgbench\u003c/span\u003e with an empty pipeline and prepared mode (Álvaro Herrera) \u003ca href=\"https://postgr.es/c/34f511965\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"15.4-c3d310a8904a1c1a","identity_text":"Avoid crash in pgbench with an empty pipeline and prepared mode (Álvaro Herrera)","part":"changes","patch_ids":["775b0d4dc0fc1fea6d1ae7e2ff9ead9c"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["34f511965"],"source_entry_id":"15.4/changes/045","source_hash":"db8053d4edb2f8643fc5336e964c4aaeba8c4476f5ece95b98b128c358192568","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"dba5a4fda53f1301e03ff145d73e3e82609a473677ea8175bf2fcccd3e3c31c7","text":"Avoid crash in pgbench with an empty pipeline and prepared mode (Álvaro Herrera) §","title":"Avoid crash in pgbench with an empty pipeline and prepared mode","variants":[],"version":"15.4"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["27da47122","7af65523a","7d27493b7","a5ea825f9","bdaaf1bf1","db9813819","eb3abec4b"],"commit_groups":[["27da47122","7af65523a","7d27493b7","a5ea825f9","bdaaf1bf1","db9813819","eb3abec4b"]],"commits":["eb3abec4b"],"cves":[],"db_id":"353be48d94116827aff24b74f626b228","html":"\u003cp\u003eEnsure that \u003ccode\u003epg_index\u003c/code\u003e.\u003ccode\u003eindisreplident\u003c/code\u003e is kept up-to-date in relation cache entries (Shruthi Gowda) \u003ca href=\"https://postgr.es/c/eb3abec4b\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThis value could be stale in some cases. There is no core code that relies on the relation cache's copy, so this is only a latent bug as far as Postgres itself is concerned; but there may be extensions for which it is a live bug.\u003c/p\u003e","id":"15.4-ec58eedd690d0c79","identity_text":"Ensure that pg_index.indisreplident is kept up-to-date in relation cache entries (Shruthi Gowda) This value could be stale in some cases. There is no core code that relies on the relation cache's copy, so this is only a latent bug as far as Postgres itself is concerned; but there may be extensions for which it is a live bug.","part":"changes","patch_ids":["7344652588632a0c4415c55b4b739c6f"],"related_changes":[{"db_id":"724745c515fac379552757a1fda318d9","evidence":{"patch_ids":["7344652588632a0c4415c55b4b739c6f"],"same_day":true,"statement_hash":"72937390549dfce012da639d78afc186c9d67156b38e53ace013fd39a45f8fcb"},"kind":"equivalent","label":"14.9","source_url":"/docs/release/14.9/#id-1.11.6.21.5","title":"Ensure that pg_index.indisreplident is kept up-to-date in relation cache entries","url":"/docs/compare/?release=14.9#14.9-79b655b3a5967899","version":"14.9"},{"db_id":"a6ed51f9d342c94f174bfd73f5766a1d","evidence":{"patch_ids":["7344652588632a0c4415c55b4b739c6f"],"same_day":true,"statement_hash":"72937390549dfce012da639d78afc186c9d67156b38e53ace013fd39a45f8fcb"},"kind":"equivalent","label":"13.12","source_url":"/docs/release/13.12/#id-1.11.6.17.5","title":"Ensure that pg_index.indisreplident is kept up-to-date in relation cache entries","url":"/docs/compare/?release=13.12#13.12-77ed1850dee16bc4","version":"13.12"},{"db_id":"8d608552460feb08bafd4f6346d4798a","evidence":{"patch_ids":["7344652588632a0c4415c55b4b739c6f"],"same_day":true,"statement_hash":"72937390549dfce012da639d78afc186c9d67156b38e53ace013fd39a45f8fcb"},"kind":"equivalent","label":"12.16","source_url":"/docs/release/12.16/#id-1.11.6.12.5","title":"Ensure that pg_index.indisreplident is kept up-to-date in relation cache entries","url":"/docs/compare/?release=12.16#12.16-a251d09b5796e2f8","version":"12.16"},{"db_id":"087a3d7bc0ccf63380150eb167de02c1","evidence":{"patch_ids":["7344652588632a0c4415c55b4b739c6f"],"same_day":true,"statement_hash":"72937390549dfce012da639d78afc186c9d67156b38e53ace013fd39a45f8fcb"},"kind":"equivalent","label":"11.21","source_url":"/docs/release/11.21/#id-1.11.6.6.6","title":"Ensure that pg_index.indisreplident is kept up-to-date in relation cache entries","url":"/docs/compare/?release=11.21#11.21-0effab04821f3794","version":"11.21"}],"relations":[{"evidence":{"patch_ids":["7344652588632a0c4415c55b4b739c6f"],"same_day":true,"statement_hash":"72937390549dfce012da639d78afc186c9d67156b38e53ace013fd39a45f8fcb"},"rule":2,"target":"087a3d7bc0ccf63380150eb167de02c1","type":"equivalent"},{"evidence":{"patch_ids":["7344652588632a0c4415c55b4b739c6f"],"same_day":true,"statement_hash":"72937390549dfce012da639d78afc186c9d67156b38e53ace013fd39a45f8fcb"},"rule":2,"target":"724745c515fac379552757a1fda318d9","type":"equivalent"},{"evidence":{"patch_ids":["7344652588632a0c4415c55b4b739c6f"],"same_day":true,"statement_hash":"72937390549dfce012da639d78afc186c9d67156b38e53ace013fd39a45f8fcb"},"rule":2,"target":"8d608552460feb08bafd4f6346d4798a","type":"equivalent"},{"evidence":{"patch_ids":["7344652588632a0c4415c55b4b739c6f"],"same_day":true,"statement_hash":"72937390549dfce012da639d78afc186c9d67156b38e53ace013fd39a45f8fcb"},"rule":2,"target":"a6ed51f9d342c94f174bfd73f5766a1d","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["eb3abec4b"],"source_entry_id":"15.4/changes/046","source_hash":"95e049ec0b86fc0c9ade64c65ae580658a427e643ba1affb61589f10f8af6ed1","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"72937390549dfce012da639d78afc186c9d67156b38e53ace013fd39a45f8fcb","text":"Ensure that pg_index.indisreplident is kept up-to-date in relation cache entries (Shruthi Gowda) § This value could be stale in some cases. There is no core code that relies on the relation cache's copy, so this is only a latent bug as far as Postgres itself is concerned; but there may be extensions for which it is a live bug.","title":"Ensure that pg_index.indisreplident is kept up-to-date in relation cache entries","variants":[],"version":"15.4"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["ae66716bf","af26f28b9"],"commit_groups":[["ae66716bf","af26f28b9"]],"commits":["af26f28b9"],"cves":[],"db_id":"afbe65f11e336c5ac604b31c3d3adfce","html":"\u003cp\u003eFix \u003cspan\u003emake_etags\u003c/span\u003e script to work with non-Exuberant \u003cspan\u003ectags\u003c/span\u003e (Masahiko Sawada) \u003ca href=\"https://postgr.es/c/af26f28b9\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"15.4-85c1284a1a93c76a","identity_text":"Fix make_etags script to work with non-Exuberant ctags (Masahiko Sawada)","part":"changes","patch_ids":["3d16098599d6b692aba447aac3a18325"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["af26f28b9"],"source_entry_id":"15.4/changes/047","source_hash":"a750f079ef8e17a5b9a8860bef4595bae0e7044b90acf14c1c1c4eac58a1484b","source_url":"/docs/release/15.4/#id-1.11.6.21.5","statement_hash":"0105d8d24d22b75a78d79dd16ee50c8818956336f4a2fee10e9554e8651c1a61","text":"Fix make_etags script to work with non-Exuberant ctags (Masahiko Sawada) §","title":"Fix make_etags script to work with non-Exuberant ctags","variants":[],"version":"15.4"}],"entry_count":47,"eol":"2027-11-11","eol_date":"2027-11-11","label":"15.4","major":"15","manual":"15","manual_build":"15.20","manual_url":"/docs/15/release-15-4.html","migration_html":"\u003cp\u003eA dump/restore is not required for those running 15.X.\u003c/p\u003e\n\u003cp\u003eHowever, if you use BRIN indexes, it may be advisable to reindex them; see the third changelog entry below.\u003c/p\u003e\n\u003cp\u003eAlso, if you are upgrading from a version earlier than 15.1, see \u003ca href=\"/docs/15/release-15-1.html\" title=\"E.19. Release 15.1\"\u003eSection E.19\u003c/a\u003e.\u003c/p\u003e","minor":4,"placeholder":false,"source_as_of":"","source_url":"/docs/release/15.4/","status":"stable","status_label":"Supported","support_days":354,"supported":true,"version":"15.4"}],"mode":"release","release_count":1,"remaining_cves":[],"security_as_of":"2026-09-26","security_regressions":[],"source_as_of":"2026-11-19","stats":[{"count":47,"key":"all","label":"All changes"},{"count":0,"key":"feature","label":"Features"},{"count":22,"key":"bugfix","label":"Bug fixes"},{"count":2,"key":"security","label":"Security"},{"count":0,"key":"performance","label":"Performance"},{"count":0,"key":"compatibility","label":"Compatibility"},{"count":23,"key":"improvement","label":"Improvements"}],"to_release":{"age_days":1200,"build":"15.4","changes_count":47,"compatibility_count":0,"content_hash":"d9fd82b773ce9a5d77042c14b19b328ecc87b3f1e1592c7ce3b5f7c476ba9861","date":"2023-08-10","date_text":"2023-08-10","doc_git":"b9f0e7232f60f380d642ac9b99226606c254b552","doc_loaded_at":"2026-11-12T17:14:13+00:00","entry_count":47,"eol":"2027-11-11","eol_date":"2027-11-11","label":"15.4","major":"15","manual":"15","manual_build":"15.20","manual_url":"/docs/15/release-15-4.html","migration_html":"\u003cp\u003eA dump/restore is not required for those running 15.X.\u003c/p\u003e\n\u003cp\u003eHowever, if you use BRIN indexes, it may be advisable to reindex them; see the third changelog entry below.\u003c/p\u003e\n\u003cp\u003eAlso, if you are upgrading from a version earlier than 15.1, see \u003ca href=\"/docs/15/release-15-1.html\" title=\"E.19. Release 15.1\"\u003eSection E.19\u003c/a\u003e.\u003c/p\u003e","minor":4,"placeholder":false,"source_as_of":"","source_url":"/docs/release/15.4/","status":"stable","status_label":"Supported","support_days":354,"supported":true,"version":"15.4"},"total":47,"warnings":[]}
