{"already_in_source_count":0,"candidate_count":61,"cross_major":false,"cve_available":true,"cve_count":1,"cves":[{"affected":{"13":"13","14":"14","15":"15","16":"16","17":"17"},"affected_ranges":[{"from":"0","until":"13.21"},{"from":"14","until":"14.18"},{"from":"15","until":"15.13"},{"from":"16","until":"16.9"},{"from":"17","until":"17.5"}],"cna_url":"https://cveawg.mitre.org/api/cve/CVE-2025-4207","component":"core server","cvss_version":"3.0","description_en":"Buffer over-read in PostgreSQL GB18030 encoding validation allows a database input provider to achieve temporary denial of service on platforms where a 1-byte over-read can elicit process termination. This affects the database server and also libpq. Versions before PostgreSQL 17.5, 16.9, 15.13, 14.18, and 13.21 are affected.","first_published":"2025-05-08","fixed":{"13":"13.21","14":"14.18","15":"15.13","16":"16.9","17":"17.5"},"fixed_version":"17.5","id":"CVE-2025-4207","introduced":{},"published":{"13":"2025-05-08","14":"2025-05-08","15":"2025-05-08","16":"2025-05-08","17":"2025-05-08"},"score":5.9,"title":"Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding","url":"https://www.postgresql.org/support/security/CVE-2025-4207/","vector":"AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:N/A:H"}],"duplicate_count":0,"excluded_count":0,"exclusions":[],"from_release":null,"groups":[{"age_days":553,"build":"17.5","changes_count":61,"compatibility_count":0,"content_hash":"6f6271e72a010ddbca12968df7f7a798728b72bccb0e56b6679a663d0d959e9c","date":"2025-05-08","date_text":"2025-05-08","doc_git":"","doc_loaded_at":"2026-09-25T02:22:44.760693","entries":[{"also_in":[],"category":"security","category_label":"Security","commit_aliases":["258cde839","3f2ab7393","44ba3f55f","45fe7e08f","5be213caa","617d34908","627acc3ca","7279e5820","cbadeaca9","d1264948f","ec5f89e8a","f3bb0b2c4"],"commit_groups":[["258cde839","45fe7e08f","5be213caa","617d34908","7279e5820","f3bb0b2c4"],["3f2ab7393","44ba3f55f","627acc3ca","cbadeaca9","d1264948f","ec5f89e8a"]],"commits":["617d34908","ec5f89e8a"],"cves":["CVE-2025-4207"],"db_id":"b709e1b3e9d8624be870988b036fd152","html":"\u003cp\u003eAvoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding (Noah Misch, Andres Freund) \u003ca href=\"https://postgr.es/c/ec5f89e8a\"\u003e§\u003c/a\u003e \u003ca href=\"https://postgr.es/c/617d34908\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eWhile unlikely, a SIGSEGV crash could occur if an incomplete multibyte character appeared at the end of memory. This was possible both in the server and in \u003cspan\u003elibpq\u003c/span\u003e-using applications. (CVE-2025-4207)\u003c/p\u003e","id":"17.5-811aed0b2b3689f8","identity_text":"Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding (Noah Misch, Andres Freund) While unlikely, a SIGSEGV crash could occur if an incomplete multibyte character appeared at the end of memory. This was possible both in the server and in libpq-using applications. (CVE-2025-4207)","part":"changes","patch_ids":["46c8bf47167ab191e3280201c2564861","76df84f28287d373c8422ff9fd4dc342"],"related_changes":[{"db_id":"52b291d40b26e80bfcbda168216ed19c","evidence":{"patch_ids":["46c8bf47167ab191e3280201c2564861","76df84f28287d373c8422ff9fd4dc342"],"same_day":true,"statement_hash":"de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding","url":"/docs/compare/?release=16.9#16.9-9333e72b42f314f4","version":"16.9"},{"db_id":"324c2d77afbaedc0b35dc9fa474e1a3c","evidence":{"patch_ids":["46c8bf47167ab191e3280201c2564861","76df84f28287d373c8422ff9fd4dc342"],"same_day":true,"statement_hash":"de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding","url":"/docs/compare/?release=15.13#15.13-ac5445ebcc0439eb","version":"15.13"},{"db_id":"dd8842462b8fd9529571acc51a1f45c1","evidence":{"patch_ids":["46c8bf47167ab191e3280201c2564861","76df84f28287d373c8422ff9fd4dc342"],"same_day":true,"statement_hash":"de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding","url":"/docs/compare/?release=14.18#14.18-e7c0d482f98a0ba1","version":"14.18"},{"db_id":"90816d8cb748849f968f5acd56673365","evidence":{"patch_ids":["46c8bf47167ab191e3280201c2564861","76df84f28287d373c8422ff9fd4dc342"],"same_day":true,"statement_hash":"de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding","url":"/docs/compare/?release=13.21#13.21-bc601768f2de7a35","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["46c8bf47167ab191e3280201c2564861","76df84f28287d373c8422ff9fd4dc342"],"same_day":true,"statement_hash":"de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af"},"rule":2,"target":"324c2d77afbaedc0b35dc9fa474e1a3c","type":"equivalent"},{"evidence":{"patch_ids":["46c8bf47167ab191e3280201c2564861","76df84f28287d373c8422ff9fd4dc342"],"same_day":true,"statement_hash":"de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af"},"rule":2,"target":"52b291d40b26e80bfcbda168216ed19c","type":"equivalent"},{"evidence":{"patch_ids":["46c8bf47167ab191e3280201c2564861","76df84f28287d373c8422ff9fd4dc342"],"same_day":true,"statement_hash":"de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af"},"rule":2,"target":"90816d8cb748849f968f5acd56673365","type":"equivalent"},{"evidence":{"patch_ids":["46c8bf47167ab191e3280201c2564861","76df84f28287d373c8422ff9fd4dc342"],"same_day":true,"statement_hash":"de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af"},"rule":2,"target":"dd8842462b8fd9529571acc51a1f45c1","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["617d34908","ec5f89e8a"],"source_entry_id":"17.5/changes/001","source_hash":"60947e0669682c6d8f98a37f50f6140e5824a66d04fc50f6fd7c3837d54fd664","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"de9bc622c1afed2365e92af367e89d9502a1c466f4c6dba55f3cf061e1d932af","text":"Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding (Noah Misch, Andres Freund) § § While unlikely, a SIGSEGV crash could occur if an incomplete multibyte character appeared at the end of memory. This was possible both in the server and in libpq-using applications. (CVE-2025-4207)","title":"Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["1649d153a","1817d62ec","6ba979cf5","b3a9c536d","c83a38758","f51ae3187"],"commit_groups":[["1649d153a","1817d62ec","6ba979cf5","b3a9c536d","c83a38758","f51ae3187"]],"commits":["f51ae3187"],"cves":[],"db_id":"74b0b653fc4b7867d9664b6f47e83cf2","html":"\u003cp\u003eHandle self-referential foreign keys on partitioned tables correctly (Álvaro Herrera) \u003ca href=\"https://postgr.es/c/f51ae3187\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eCreating or attaching partitions failed to make the required catalog entries for a foreign-key constraint, if the table referenced by the constraint was the same partitioned table. This resulted in failure to enforce the constraint fully.\u003c/p\u003e\n\u003cp\u003eTo fix this, you should drop and recreate any self-referential foreign keys on partitioned tables, if partitions have been created or attached since the constraint was created. Bear in mind that violating rows might already be present, in which case recreating the constraint will fail, and you'll need to fix up those rows before trying again.\u003c/p\u003e","id":"17.5-33e46d9a26056cb4","identity_text":"Handle self-referential foreign keys on partitioned tables correctly (Álvaro Herrera) Creating or attaching partitions failed to make the required catalog entries for a foreign-key constraint, if the table referenced by the constraint was the same partitioned table. This resulted in failure to enforce the constraint fully. To fix this, you should drop and recreate any self-referential foreign keys on partitioned tables, if partitions have been created or attached since the constraint was created. Bear in mind that violating rows might already be present, in which case recreating the constraint will fail, and you'll need to fix up those rows before trying again.","part":"changes","patch_ids":["ad242ea23eebb0296f36fddb8b8111c0"],"related_changes":[{"db_id":"2e82178a9bafbe73cfec49a0a0c3913b","evidence":{"patch_ids":["ad242ea23eebb0296f36fddb8b8111c0"],"same_day":true,"statement_hash":"0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Handle self-referential foreign keys on partitioned tables correctly","url":"/docs/compare/?release=16.9#16.9-957bda7d3c81adad","version":"16.9"},{"db_id":"80e3cc10f3858300ca77df2904c1925d","evidence":{"patch_ids":["ad242ea23eebb0296f36fddb8b8111c0"],"same_day":true,"statement_hash":"0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Handle self-referential foreign keys on partitioned tables correctly","url":"/docs/compare/?release=15.13#15.13-0a90d92fac91acc0","version":"15.13"},{"db_id":"00a212cca3e46b43408a50bfb3f001a2","evidence":{"patch_ids":["ad242ea23eebb0296f36fddb8b8111c0"],"same_day":true,"statement_hash":"0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Handle self-referential foreign keys on partitioned tables correctly","url":"/docs/compare/?release=14.18#14.18-8508a57f7675f008","version":"14.18"},{"db_id":"1597348d9b84b108c65df5a25ccdad57","evidence":{"patch_ids":["ad242ea23eebb0296f36fddb8b8111c0"],"same_day":true,"statement_hash":"0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Handle self-referential foreign keys on partitioned tables correctly","url":"/docs/compare/?release=13.21#13.21-5dfcd8e50f9f1cd7","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["ad242ea23eebb0296f36fddb8b8111c0"],"same_day":true,"statement_hash":"0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03"},"rule":2,"target":"00a212cca3e46b43408a50bfb3f001a2","type":"equivalent"},{"evidence":{"patch_ids":["ad242ea23eebb0296f36fddb8b8111c0"],"same_day":true,"statement_hash":"0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03"},"rule":2,"target":"1597348d9b84b108c65df5a25ccdad57","type":"equivalent"},{"evidence":{"patch_ids":["ad242ea23eebb0296f36fddb8b8111c0"],"same_day":true,"statement_hash":"0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03"},"rule":2,"target":"2e82178a9bafbe73cfec49a0a0c3913b","type":"equivalent"},{"evidence":{"patch_ids":["ad242ea23eebb0296f36fddb8b8111c0"],"same_day":true,"statement_hash":"0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03"},"rule":2,"target":"80e3cc10f3858300ca77df2904c1925d","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["f51ae3187"],"source_entry_id":"17.5/changes/002","source_hash":"34acb88862cc01e1b3f535250ed1681aef05f3008636829b816b8cf75d88ab3e","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"0c1635d2fbe51396a0afda654bfd96a5b65735f5ba956c95dbfb5862805e3a03","text":"Handle self-referential foreign keys on partitioned tables correctly (Álvaro Herrera) § Creating or attaching partitions failed to make the required catalog entries for a foreign-key constraint, if the table referenced by the constraint was the same partitioned table. This resulted in failure to enforce the constraint fully. To fix this, you should drop and recreate any self-referential foreign keys on partitioned tables, if partitions have been created or attached since the constraint was created. Bear in mind that violating rows might already be present, in which case recreating the constraint will fail, and you'll need to fix up those rows before trying again.","title":"Handle self-referential foreign keys on partitioned tables correctly","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["6be02bbc8","818245506","cb0ad70b8","e064b770c","ebcc799a7"],"commit_groups":[["6be02bbc8","818245506","cb0ad70b8","e064b770c","ebcc799a7"]],"commits":["cb0ad70b8"],"cves":[],"db_id":"485bff3c834029add3cd04127b9baf3b","html":"\u003cp\u003eAvoid data loss when merging compressed BRIN summaries in \u003ccode\u003ebrin_bloom_union()\u003c/code\u003e (Tomas Vondra) \u003ca href=\"https://postgr.es/c/cb0ad70b8\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThe code failed to account for decompression results not being identical to the input objects, which would result in failure to add some of the data to the merged summary, leading to missed rows in index searches.\u003c/p\u003e\n\u003cp\u003eThis mistake was present back to v14 where BRIN bloom indexes were introduced, but this code path was only rarely reached then. It's substantially more likely to be hit in v17 because parallel index builds now use the code.\u003c/p\u003e","id":"17.5-713c7047a302325a","identity_text":"Avoid data loss when merging compressed BRIN summaries in brin_bloom_union() (Tomas Vondra) The code failed to account for decompression results not being identical to the input objects, which would result in failure to add some of the data to the merged summary, leading to missed rows in index searches. This mistake was present back to v14 where BRIN bloom indexes were introduced, but this code path was only rarely reached then. It's substantially more likely to be hit in v17 because parallel index builds now use the code.","part":"changes","patch_ids":["e7679010570c027f03bd2cfeabb18277"],"related_changes":[{"db_id":"4843f13cf3d1c267a1482aff53d43829","evidence":{"patch_ids":["e7679010570c027f03bd2cfeabb18277"],"same_day":true,"statement_hash":"4b381913723c5c4a3d0d3be5e7454df4efc248655249905dff5dc8a58a402609"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Avoid data loss when merging compressed BRIN summaries in brin_bloom_union()","url":"/docs/compare/?release=16.9#16.9-00a18a3ddf7896ba","version":"16.9"},{"db_id":"3a11ecf5fadca551924c452d89cfd2ae","evidence":{"patch_ids":["e7679010570c027f03bd2cfeabb18277"],"same_day":true,"statement_hash":"4b381913723c5c4a3d0d3be5e7454df4efc248655249905dff5dc8a58a402609"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Avoid data loss when merging compressed BRIN summaries in brin_bloom_union()","url":"/docs/compare/?release=15.13#15.13-32fb0ac8af362319","version":"15.13"},{"db_id":"bbe2be1a596ba923c5a319334510b4f8","evidence":{"patch_ids":["e7679010570c027f03bd2cfeabb18277"],"same_day":true,"statement_hash":"4b381913723c5c4a3d0d3be5e7454df4efc248655249905dff5dc8a58a402609"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Avoid data loss when merging compressed BRIN summaries in brin_bloom_union()","url":"/docs/compare/?release=14.18#14.18-f538b53a2f7f69ca","version":"14.18"}],"relations":[{"evidence":{"patch_ids":["e7679010570c027f03bd2cfeabb18277"],"same_day":true,"statement_hash":"4b381913723c5c4a3d0d3be5e7454df4efc248655249905dff5dc8a58a402609"},"rule":2,"target":"3a11ecf5fadca551924c452d89cfd2ae","type":"equivalent"},{"evidence":{"patch_ids":["e7679010570c027f03bd2cfeabb18277"],"same_day":true,"statement_hash":"4b381913723c5c4a3d0d3be5e7454df4efc248655249905dff5dc8a58a402609"},"rule":2,"target":"4843f13cf3d1c267a1482aff53d43829","type":"equivalent"},{"evidence":{"patch_ids":["e7679010570c027f03bd2cfeabb18277"],"same_day":true,"statement_hash":"4b381913723c5c4a3d0d3be5e7454df4efc248655249905dff5dc8a58a402609"},"rule":2,"target":"bbe2be1a596ba923c5a319334510b4f8","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["cb0ad70b8"],"source_entry_id":"17.5/changes/003","source_hash":"19fd566382389b19294889a03476f67bcac50ecf5f649586d03ba5f32366a873","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"4b381913723c5c4a3d0d3be5e7454df4efc248655249905dff5dc8a58a402609","text":"Avoid data loss when merging compressed BRIN summaries in brin_bloom_union() (Tomas Vondra) § The code failed to account for decompression results not being identical to the input objects, which would result in failure to add some of the data to the merged summary, leading to missed rows in index searches. This mistake was present back to v14 where BRIN bloom indexes were introduced, but this code path was only rarely reached then. It's substantially more likely to be hit in v17 because parallel index builds now use the code.","title":"Avoid data loss when merging compressed BRIN summaries in brin_bloom_union()","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["1a20bc946","28a7e31d0","317aba70e","39af32f78","584f17a90","7713f4592","ae0be2f0b","b200180de","ca0830e5a","d3a29ae6a","f4e7756ef","fec43428c"],"commit_groups":[["1a20bc946","7713f4592","b200180de"],["28a7e31d0","317aba70e","584f17a90"],["39af32f78","ae0be2f0b","ca0830e5a","d3a29ae6a","f4e7756ef","fec43428c"]],"commits":["ca0830e5a"],"cves":[],"db_id":"7a02987633308bab11c9305847a877d0","html":"\u003cp\u003eFix unexpected \u003cspan\u003e“\u003cspan\u003eattribute has wrong type\u003c/span\u003e”\u003c/span\u003e errors in \u003ccode\u003eUPDATE\u003c/code\u003e, \u003ccode\u003eDELETE\u003c/code\u003e, and \u003ccode\u003eMERGE\u003c/code\u003e queries that use whole-row table references to views or functions in \u003ccode\u003eFROM\u003c/code\u003e (Tom Lane) \u003ca href=\"https://postgr.es/c/ca0830e5a\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-4ee041283b8d7df3","identity_text":"Fix unexpected attribute has wrong type errors in UPDATE, DELETE, and MERGE queries that use whole-row table references to views or functions in FROM (Tom Lane)","part":"changes","patch_ids":["15bc8ca0e3cd0f7d7090dc8454de3307","48fefa97f07c981f3d50626a2693f764","59a3817ba039f85b8c7fd855a6cd7c4f"],"related_changes":[{"db_id":"6d9a4033cdb647a5127ebda891f45303","evidence":{"patch_ids":["15bc8ca0e3cd0f7d7090dc8454de3307","48fefa97f07c981f3d50626a2693f764","59a3817ba039f85b8c7fd855a6cd7c4f"],"same_day":true,"statement_hash":"bfb3da86e84e7549dc5b96dc76b02432005d15b99e43155b4cbfbb516d6cbf54"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Fix unexpected “attribute has wrong type” errors in UPDATE, DELETE, and MERGE queries that use whole-row table references to views or functions in FROM","url":"/docs/compare/?release=16.9#16.9-285f67adcbce3ca8","version":"16.9"},{"db_id":"172f587e40b738a117b3f312ab43c52e","evidence":{"patch_ids":["15bc8ca0e3cd0f7d7090dc8454de3307","48fefa97f07c981f3d50626a2693f764","59a3817ba039f85b8c7fd855a6cd7c4f"],"same_day":true,"statement_hash":"bfb3da86e84e7549dc5b96dc76b02432005d15b99e43155b4cbfbb516d6cbf54"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Fix unexpected “attribute has wrong type” errors in UPDATE, DELETE, and MERGE queries that use whole-row table references to views or functions in FROM","url":"/docs/compare/?release=15.13#15.13-77004cecd223761f","version":"15.13"},{"db_id":"faecba315a6ff460195de2ac7c2156a1","evidence":{"patch_ids":["15bc8ca0e3cd0f7d7090dc8454de3307","48fefa97f07c981f3d50626a2693f764","59a3817ba039f85b8c7fd855a6cd7c4f"],"same_day":true,"statement_hash":"bfb3da86e84e7549dc5b96dc76b02432005d15b99e43155b4cbfbb516d6cbf54"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Fix unexpected “attribute has wrong type” errors in UPDATE, DELETE, and MERGE queries that use whole-row table references to views or functions in FROM","url":"/docs/compare/?release=14.18#14.18-410db6a272093912","version":"14.18"},{"db_id":"78144efed294da8a2d5e820954befe01","evidence":{"patch_ids":["15bc8ca0e3cd0f7d7090dc8454de3307","48fefa97f07c981f3d50626a2693f764","59a3817ba039f85b8c7fd855a6cd7c4f"],"same_day":true,"statement_hash":"bfb3da86e84e7549dc5b96dc76b02432005d15b99e43155b4cbfbb516d6cbf54"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Fix unexpected “attribute has wrong type” errors in UPDATE, DELETE, and MERGE queries that use whole-row table references to views or functions in FROM","url":"/docs/compare/?release=13.21#13.21-b31af4ef04e8f4e8","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["15bc8ca0e3cd0f7d7090dc8454de3307","48fefa97f07c981f3d50626a2693f764","59a3817ba039f85b8c7fd855a6cd7c4f"],"same_day":true,"statement_hash":"bfb3da86e84e7549dc5b96dc76b02432005d15b99e43155b4cbfbb516d6cbf54"},"rule":2,"target":"172f587e40b738a117b3f312ab43c52e","type":"equivalent"},{"evidence":{"patch_ids":["15bc8ca0e3cd0f7d7090dc8454de3307","48fefa97f07c981f3d50626a2693f764","59a3817ba039f85b8c7fd855a6cd7c4f"],"same_day":true,"statement_hash":"bfb3da86e84e7549dc5b96dc76b02432005d15b99e43155b4cbfbb516d6cbf54"},"rule":2,"target":"6d9a4033cdb647a5127ebda891f45303","type":"equivalent"},{"evidence":{"patch_ids":["15bc8ca0e3cd0f7d7090dc8454de3307","48fefa97f07c981f3d50626a2693f764","59a3817ba039f85b8c7fd855a6cd7c4f"],"same_day":true,"statement_hash":"bfb3da86e84e7549dc5b96dc76b02432005d15b99e43155b4cbfbb516d6cbf54"},"rule":2,"target":"78144efed294da8a2d5e820954befe01","type":"equivalent"},{"evidence":{"patch_ids":["15bc8ca0e3cd0f7d7090dc8454de3307","48fefa97f07c981f3d50626a2693f764","59a3817ba039f85b8c7fd855a6cd7c4f"],"same_day":true,"statement_hash":"bfb3da86e84e7549dc5b96dc76b02432005d15b99e43155b4cbfbb516d6cbf54"},"rule":2,"target":"faecba315a6ff460195de2ac7c2156a1","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["317aba70e","7713f4592","ca0830e5a"],"source_entry_id":"17.5/changes/004","source_hash":"d17c663a548153bd2774df9407219838e541f29352e557ca88f1bb63f080d4c8","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"bfb3da86e84e7549dc5b96dc76b02432005d15b99e43155b4cbfbb516d6cbf54","text":"Fix unexpected “attribute has wrong type” errors in UPDATE, DELETE, and MERGE queries that use whole-row table references to views or functions in FROM (Tom Lane) §","title":"Fix unexpected “attribute has wrong type” errors in UPDATE, DELETE, and MERGE queries that use whole-row table references to views or functions in FROM","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["14a33d3f0","25303678a","8b6a0e239","8d4cd3b4a"],"commit_groups":[["14a33d3f0","25303678a","8b6a0e239","8d4cd3b4a"]],"commits":["25303678a"],"cves":[],"db_id":"86af16fcd8c6b4a784b7476a3d942894","html":"\u003cp\u003eFix \u003ccode\u003eMERGE\u003c/code\u003e into a partitioned table with \u003ccode\u003eDO NOTHING\u003c/code\u003e actions (Tender Wang) \u003ca href=\"https://postgr.es/c/25303678a\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eSome cases failed with \u003cspan\u003e“\u003cspan\u003eunknown action in MERGE WHEN clause\u003c/span\u003e”\u003c/span\u003e errors.\u003c/p\u003e","id":"17.5-fb1ef27e6ad12133","identity_text":"Fix MERGE into a partitioned table with DO NOTHING actions (Tender Wang) Some cases failed with unknown action in MERGE WHEN clause errors.","part":"changes","patch_ids":["513aa4deebdf3df8839bb06bae87b2de"],"related_changes":[{"db_id":"52e2c1747d54581c28441d3730cd211c","evidence":{"patch_ids":["513aa4deebdf3df8839bb06bae87b2de"],"same_day":true,"statement_hash":"5fe417a7181c1d7cf2c97d0d55ffbacd8690db7faa1ee767a09dea3ed7953532"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Fix MERGE into a partitioned table with DO NOTHING actions","url":"/docs/compare/?release=16.9#16.9-e85808310d3df6a7","version":"16.9"},{"db_id":"62735bf2bbcc5084c2a05ae3d376af22","evidence":{"patch_ids":["513aa4deebdf3df8839bb06bae87b2de"],"same_day":true,"statement_hash":"5fe417a7181c1d7cf2c97d0d55ffbacd8690db7faa1ee767a09dea3ed7953532"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Fix MERGE into a partitioned table with DO NOTHING actions","url":"/docs/compare/?release=15.13#15.13-573e0d1c859813ca","version":"15.13"}],"relations":[{"evidence":{"patch_ids":["513aa4deebdf3df8839bb06bae87b2de"],"same_day":true,"statement_hash":"5fe417a7181c1d7cf2c97d0d55ffbacd8690db7faa1ee767a09dea3ed7953532"},"rule":2,"target":"52e2c1747d54581c28441d3730cd211c","type":"equivalent"},{"evidence":{"patch_ids":["513aa4deebdf3df8839bb06bae87b2de"],"same_day":true,"statement_hash":"5fe417a7181c1d7cf2c97d0d55ffbacd8690db7faa1ee767a09dea3ed7953532"},"rule":2,"target":"62735bf2bbcc5084c2a05ae3d376af22","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["25303678a"],"source_entry_id":"17.5/changes/005","source_hash":"3dee2ba0540a4c784d18020fef92a582551c0b8093cb9d0c6dd383827cceeb60","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"5fe417a7181c1d7cf2c97d0d55ffbacd8690db7faa1ee767a09dea3ed7953532","text":"Fix MERGE into a partitioned table with DO NOTHING actions (Tender Wang) § Some cases failed with “unknown action in MERGE WHEN clause” errors.","title":"Fix MERGE into a partitioned table with DO NOTHING actions","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["3c39c000c","4604928ed","7c8728494","97d671672","f04e0faa3"],"commit_groups":[["3c39c000c","4604928ed","7c8728494","97d671672","f04e0faa3"]],"commits":["3c39c000c"],"cves":[],"db_id":"a4bb8d60d9ad06081b90421ad2dae048","html":"\u003cp\u003ePrevent failure in \u003ccode\u003eINSERT\u003c/code\u003e commands when the table has a \u003ccode\u003eGENERATED\u003c/code\u003e column of a domain data type and the domain's constraints disallow null values (Jian He) \u003ca href=\"https://postgr.es/c/3c39c000c\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eConstraint failure was reported even if the generation expression produced a perfectly okay result.\u003c/p\u003e","id":"17.5-6526003e508c4382","identity_text":"Prevent failure in INSERT commands when the table has a GENERATED column of a domain data type and the domain's constraints disallow null values (Jian He) Constraint failure was reported even if the generation expression produced a perfectly okay result.","part":"changes","patch_ids":["511a283a7a0968a300bcd6f1f483561c"],"related_changes":[{"db_id":"1abab24628ec9d80474ca478204b54b6","evidence":{"patch_ids":["511a283a7a0968a300bcd6f1f483561c"],"same_day":true,"statement_hash":"b1bc50fa6460403502ac286fc1da724e43781afb7c442739f4cf1015e30f28d1"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Prevent failure in INSERT commands when the table has a GENERATED column of a domain data type and the domain's constraints disallow null values","url":"/docs/compare/?release=16.9#16.9-9a8a93e856ab5a0d","version":"16.9"},{"db_id":"90be6e04fee2db08987030dda7e61c1c","evidence":{"patch_ids":["511a283a7a0968a300bcd6f1f483561c"],"same_day":true,"statement_hash":"b1bc50fa6460403502ac286fc1da724e43781afb7c442739f4cf1015e30f28d1"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Prevent failure in INSERT commands when the table has a GENERATED column of a domain data type and the domain's constraints disallow null values","url":"/docs/compare/?release=15.13#15.13-dc64f1cefed2c049","version":"15.13"},{"db_id":"9968353971b2d90aabe2974ce8ca0b17","evidence":{"patch_ids":["511a283a7a0968a300bcd6f1f483561c"],"same_day":true,"statement_hash":"b1bc50fa6460403502ac286fc1da724e43781afb7c442739f4cf1015e30f28d1"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Prevent failure in INSERT commands when the table has a GENERATED column of a domain data type and the domain's constraints disallow null values","url":"/docs/compare/?release=14.18#14.18-0db2ae0d4a6db748","version":"14.18"}],"relations":[{"evidence":{"patch_ids":["511a283a7a0968a300bcd6f1f483561c"],"same_day":true,"statement_hash":"b1bc50fa6460403502ac286fc1da724e43781afb7c442739f4cf1015e30f28d1"},"rule":2,"target":"1abab24628ec9d80474ca478204b54b6","type":"equivalent"},{"evidence":{"patch_ids":["511a283a7a0968a300bcd6f1f483561c"],"same_day":true,"statement_hash":"b1bc50fa6460403502ac286fc1da724e43781afb7c442739f4cf1015e30f28d1"},"rule":2,"target":"90be6e04fee2db08987030dda7e61c1c","type":"equivalent"},{"evidence":{"patch_ids":["511a283a7a0968a300bcd6f1f483561c"],"same_day":true,"statement_hash":"b1bc50fa6460403502ac286fc1da724e43781afb7c442739f4cf1015e30f28d1"},"rule":2,"target":"9968353971b2d90aabe2974ce8ca0b17","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["3c39c000c"],"source_entry_id":"17.5/changes/006","source_hash":"c7996034d5500676b26c555afba4c2e547bc01b378e2db52814f15785576400d","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"b1bc50fa6460403502ac286fc1da724e43781afb7c442739f4cf1015e30f28d1","text":"Prevent failure in INSERT commands when the table has a GENERATED column of a domain data type and the domain's constraints disallow null values (Jian He) § Constraint failure was reported even if the generation expression produced a perfectly okay result.","title":"Prevent failure in INSERT commands when the table has a GENERATED column of a domain data type and the domain's constraints disallow null values","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["1980ec2bc","5e7be43f4","691836405","754a3d82d","e276b5829","ede29a1e4"],"commit_groups":[["1980ec2bc","5e7be43f4","691836405","754a3d82d","e276b5829","ede29a1e4"]],"commits":["5e7be43f4"],"cves":[],"db_id":"fe87096f3ff10f413ee4fd00bc85e2d2","html":"\u003cp\u003eCorrectly process references to outer CTE names that appear within a \u003ccode\u003eWITH\u003c/code\u003e clause attached to an \u003ccode\u003eINSERT\u003c/code\u003e/\u003ccode\u003eUPDATE\u003c/code\u003e/\u003ccode\u003eDELETE\u003c/code\u003e/\u003ccode\u003eMERGE\u003c/code\u003e command that's inside \u003ccode\u003eWITH\u003c/code\u003e (Tom Lane) \u003ca href=\"https://postgr.es/c/5e7be43f4\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThe parser failed to detect disallowed recursion cases, nor did it account for such references when sorting CTEs into a usable order.\u003c/p\u003e","id":"17.5-b36cfca9c709aa6d","identity_text":"Correctly process references to outer CTE names that appear within a WITH clause attached to an INSERT/UPDATE/DELETE/MERGE command that's inside WITH (Tom Lane) The parser failed to detect disallowed recursion cases, nor did it account for such references when sorting CTEs into a usable order.","part":"changes","patch_ids":["d1ef004bfb3ff87f530f4c58b02fe0f0"],"related_changes":[{"db_id":"7b32eae49c92985982175f39b0e0cd4e","evidence":{"patch_ids":["d1ef004bfb3ff87f530f4c58b02fe0f0"],"same_day":true,"statement_hash":"bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Correctly process references to outer CTE names that appear within a WITH clause attached to an INSERT/UPDATE/DELETE/MERGE command that's inside WITH","url":"/docs/compare/?release=16.9#16.9-a8bff3d57a355b2b","version":"16.9"},{"db_id":"f6ef109aaf444cf2a6cefa7c247f050b","evidence":{"patch_ids":["d1ef004bfb3ff87f530f4c58b02fe0f0"],"same_day":true,"statement_hash":"bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Correctly process references to outer CTE names that appear within a WITH clause attached to an INSERT/UPDATE/DELETE/MERGE command that's inside WITH","url":"/docs/compare/?release=15.13#15.13-f4e8b698cacd5fe8","version":"15.13"},{"db_id":"43ef4362d82abd89c632923c19c63abe","evidence":{"patch_ids":["d1ef004bfb3ff87f530f4c58b02fe0f0"],"same_day":true,"statement_hash":"bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Correctly process references to outer CTE names that appear within a WITH clause attached to an INSERT/UPDATE/DELETE/MERGE command that's inside WITH","url":"/docs/compare/?release=14.18#14.18-1dfb1187293403b9","version":"14.18"},{"db_id":"4e1153d84247e7968ad2cf656d1b8054","evidence":{"patch_ids":["d1ef004bfb3ff87f530f4c58b02fe0f0"],"same_day":true,"statement_hash":"bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Correctly process references to outer CTE names that appear within a WITH clause attached to an INSERT/UPDATE/DELETE/MERGE command that's inside WITH","url":"/docs/compare/?release=13.21#13.21-a47f4cde204a1376","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["d1ef004bfb3ff87f530f4c58b02fe0f0"],"same_day":true,"statement_hash":"bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096"},"rule":2,"target":"43ef4362d82abd89c632923c19c63abe","type":"equivalent"},{"evidence":{"patch_ids":["d1ef004bfb3ff87f530f4c58b02fe0f0"],"same_day":true,"statement_hash":"bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096"},"rule":2,"target":"4e1153d84247e7968ad2cf656d1b8054","type":"equivalent"},{"evidence":{"patch_ids":["d1ef004bfb3ff87f530f4c58b02fe0f0"],"same_day":true,"statement_hash":"bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096"},"rule":2,"target":"7b32eae49c92985982175f39b0e0cd4e","type":"equivalent"},{"evidence":{"patch_ids":["d1ef004bfb3ff87f530f4c58b02fe0f0"],"same_day":true,"statement_hash":"bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096"},"rule":2,"target":"f6ef109aaf444cf2a6cefa7c247f050b","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["5e7be43f4"],"source_entry_id":"17.5/changes/007","source_hash":"41343876fa355b03d904819fea3fe490a54642bb7e824a3f8102c5692fdd9305","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"bf2a0f590bb786488e65266418e36c3bf742fa81f661e219e66623e07c6f0096","text":"Correctly process references to outer CTE names that appear within a WITH clause attached to an INSERT/UPDATE/DELETE/MERGE command that's inside WITH (Tom Lane) § The parser failed to detect disallowed recursion cases, nor did it account for such references when sorting CTEs into a usable order.","title":"Correctly process references to outer CTE names that appear within a WITH clause attached to an INSERT/UPDATE/DELETE/MERGE command that's inside WITH","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["8b2392ae3","d4f79865d"],"commit_groups":[["8b2392ae3","d4f79865d"]],"commits":["8b2392ae3"],"cves":[],"db_id":"2309db51c4c5ea921a3deb10efc32663","html":"\u003cp\u003eFix misprocessing of casts within the keys of JSON constructor expressions (Amit Langote) \u003ca href=\"https://postgr.es/c/8b2392ae3\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-814797145ffde8c2","identity_text":"Fix misprocessing of casts within the keys of JSON constructor expressions (Amit Langote)","part":"changes","patch_ids":["2e3af970cf9ac9dd3bef967ba9b5cfeb"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["8b2392ae3"],"source_entry_id":"17.5/changes/008","source_hash":"fcfcf0bb0f82e92794a286079df7f9629641f9ff74b559c65c0ea9114cf7b547","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"e69b5539b0febf22bd50365eec0a43bfed4e7a8a55ba9535becee3ea9aed9258","text":"Fix misprocessing of casts within the keys of JSON constructor expressions (Amit Langote) §","title":"Fix misprocessing of casts within the keys of JSON constructor expressions","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["43847dd5e","a7aa9f21f","fedfcf665"],"commit_groups":[["43847dd5e","a7aa9f21f","fedfcf665"]],"commits":["43847dd5e"],"cves":[],"db_id":"235124161002d7e5c1a271f73cacb961","html":"\u003cp\u003eDon't try to parallelize \u003ccode\u003earray_agg()\u003c/code\u003e when the argument is of an anonymous record type (Richard Guo, Tom Lane) \u003ca href=\"https://postgr.es/c/43847dd5e\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThe protocol for communicating with parallel workers doesn't support identifying the concrete record type that a worker is returning.\u003c/p\u003e","id":"17.5-477036bbba5fb502","identity_text":"Don't try to parallelize array_agg() when the argument is of an anonymous record type (Richard Guo, Tom Lane) The protocol for communicating with parallel workers doesn't support identifying the concrete record type that a worker is returning.","part":"changes","patch_ids":["15e8c83408c9fb3acf8a91c7ba3bfabb"],"related_changes":[{"db_id":"0267f7695c15b591593396acd795b113","evidence":{"patch_ids":["15e8c83408c9fb3acf8a91c7ba3bfabb"],"same_day":true,"statement_hash":"63fcdc0732060f30e3f494f2a82ffdeea43bf9da5df487f9f94243940f063c17"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Don't try to parallelize array_agg() when the argument is of an anonymous record type","url":"/docs/compare/?release=16.9#16.9-633282a04bcf0545","version":"16.9"}],"relations":[{"evidence":{"patch_ids":["15e8c83408c9fb3acf8a91c7ba3bfabb"],"same_day":true,"statement_hash":"63fcdc0732060f30e3f494f2a82ffdeea43bf9da5df487f9f94243940f063c17"},"rule":2,"target":"0267f7695c15b591593396acd795b113","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["43847dd5e"],"source_entry_id":"17.5/changes/009","source_hash":"c44f4602c5603b17285a7a30ef3e028d638285eea7dec8d8469974307d25f30a","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"63fcdc0732060f30e3f494f2a82ffdeea43bf9da5df487f9f94243940f063c17","text":"Don't try to parallelize array_agg() when the argument is of an anonymous record type (Richard Guo, Tom Lane) § The protocol for communicating with parallel workers doesn't support identifying the concrete record type that a worker is returning.","title":"Don't try to parallelize array_agg() when the argument is of an anonymous record type","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["0405982c7","13dd6f772","4618045be","474aee3df","c826cd1b1","f7ae51312"],"commit_groups":[["0405982c7","13dd6f772","4618045be","474aee3df","c826cd1b1","f7ae51312"]],"commits":["c826cd1b1"],"cves":[],"db_id":"3222441c7723d9224344f9adaa6fdf0e","html":"\u003cp\u003eFix \u003ccode\u003eARRAY(\u003cem\u003e\u003ccode\u003esubquery\u003c/code\u003e\u003c/em\u003e)\u003c/code\u003e and \u003ccode\u003eARRAY[\u003cem\u003e\u003ccode\u003eexpression, ...\u003c/code\u003e\u003c/em\u003e]\u003c/code\u003e constructs to produce sane results when the input is of type \u003ccode\u003eint2vector\u003c/code\u003e or \u003ccode\u003eoidvector\u003c/code\u003e (Tom Lane) \u003ca href=\"https://postgr.es/c/c826cd1b1\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThis patch restores the behavior that existed before \u003cspan\u003ePostgreSQL\u003c/span\u003e 9.5: the result is of type \u003ccode\u003eint2vector[]\u003c/code\u003e or \u003ccode\u003eoidvector[]\u003c/code\u003e.\u003c/p\u003e","id":"17.5-4a9dd248dfb091b7","identity_text":"Fix ARRAY(subquery) and ARRAY[expression, ...] constructs to produce sane results when the input is of type int2vector or oidvector (Tom Lane) This patch restores the behavior that existed before PostgreSQL 9.5: the result is of type int2vector[] or oidvector[].","part":"changes","patch_ids":["59bbe3085e9bcfcbfff1d9fc5b4c1c56"],"related_changes":[{"db_id":"efaaf4024f5f5de0ba0862f7f3d99696","evidence":{"patch_ids":["59bbe3085e9bcfcbfff1d9fc5b4c1c56"],"same_day":true,"statement_hash":"7afc60033c3c40c571fedbd57a2c2e696aadfd82fb0b2198db9afe0faeb53944"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Fix ARRAY(subquery) and ARRAY[expression, ...] constructs to produce sane results when the input is of type int2vector or oidvector","url":"/docs/compare/?release=16.9#16.9-5ed49886adc3d34a","version":"16.9"},{"db_id":"a7950d93d654d654b785213f157499c7","evidence":{"patch_ids":["59bbe3085e9bcfcbfff1d9fc5b4c1c56"],"same_day":true,"statement_hash":"7afc60033c3c40c571fedbd57a2c2e696aadfd82fb0b2198db9afe0faeb53944"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Fix ARRAY(subquery) and ARRAY[expression, ...] constructs to produce sane results when the input is of type int2vector or oidvector","url":"/docs/compare/?release=15.13#15.13-c6423740dd58b9c5","version":"15.13"},{"db_id":"34305a36a827e7b4f59256045ef7ec72","evidence":{"patch_ids":["59bbe3085e9bcfcbfff1d9fc5b4c1c56"],"same_day":true,"statement_hash":"7afc60033c3c40c571fedbd57a2c2e696aadfd82fb0b2198db9afe0faeb53944"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Fix ARRAY(subquery) and ARRAY[expression, ...] constructs to produce sane results when the input is of type int2vector or oidvector","url":"/docs/compare/?release=14.18#14.18-70198d240c4e5136","version":"14.18"},{"db_id":"776a870e5f87a27f3d8fd7999acd7ce5","evidence":{"patch_ids":["59bbe3085e9bcfcbfff1d9fc5b4c1c56"],"same_day":true,"statement_hash":"7afc60033c3c40c571fedbd57a2c2e696aadfd82fb0b2198db9afe0faeb53944"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Fix ARRAY(subquery) and ARRAY[expression, ...] constructs to produce sane results when the input is of type int2vector or oidvector","url":"/docs/compare/?release=13.21#13.21-5479a3227697d975","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["59bbe3085e9bcfcbfff1d9fc5b4c1c56"],"same_day":true,"statement_hash":"7afc60033c3c40c571fedbd57a2c2e696aadfd82fb0b2198db9afe0faeb53944"},"rule":2,"target":"34305a36a827e7b4f59256045ef7ec72","type":"equivalent"},{"evidence":{"patch_ids":["59bbe3085e9bcfcbfff1d9fc5b4c1c56"],"same_day":true,"statement_hash":"7afc60033c3c40c571fedbd57a2c2e696aadfd82fb0b2198db9afe0faeb53944"},"rule":2,"target":"776a870e5f87a27f3d8fd7999acd7ce5","type":"equivalent"},{"evidence":{"patch_ids":["59bbe3085e9bcfcbfff1d9fc5b4c1c56"],"same_day":true,"statement_hash":"7afc60033c3c40c571fedbd57a2c2e696aadfd82fb0b2198db9afe0faeb53944"},"rule":2,"target":"a7950d93d654d654b785213f157499c7","type":"equivalent"},{"evidence":{"patch_ids":["59bbe3085e9bcfcbfff1d9fc5b4c1c56"],"same_day":true,"statement_hash":"7afc60033c3c40c571fedbd57a2c2e696aadfd82fb0b2198db9afe0faeb53944"},"rule":2,"target":"efaaf4024f5f5de0ba0862f7f3d99696","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["c826cd1b1"],"source_entry_id":"17.5/changes/010","source_hash":"e82446c9d55e9f7df3d6ea237c417d9579749ccbaec90dc9681e0807f14a13b7","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"7afc60033c3c40c571fedbd57a2c2e696aadfd82fb0b2198db9afe0faeb53944","text":"Fix ARRAY(subquery) and ARRAY[expression, ...] constructs to produce sane results when the input is of type int2vector or oidvector (Tom Lane) § This patch restores the behavior that existed before PostgreSQL 9.5: the result is of type int2vector[] or oidvector[].","title":"Fix ARRAY(subquery) and ARRAY[expression, ...] constructs to produce sane results when the input is of type int2vector or oidvector","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["61513da08","7fb880102","99c01aadf","da85544ae","e2921c0e9","f1c1bafcd"],"commit_groups":[["61513da08","7fb880102","99c01aadf","da85544ae","e2921c0e9","f1c1bafcd"]],"commits":["99c01aadf"],"cves":[],"db_id":"b921604055772bbf7e6449d7cc0b59cc","html":"\u003cp\u003eFix possible erroneous reports of invalid affixes while parsing \u003cspan\u003eIspell\u003c/span\u003e dictionaries (Jacob Brazeal) \u003ca href=\"https://postgr.es/c/99c01aadf\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-d1d934652e8cc19f","identity_text":"Fix possible erroneous reports of invalid affixes while parsing Ispell dictionaries (Jacob Brazeal)","part":"changes","patch_ids":["f2484a0ea37309c0a083683b6f24f404"],"related_changes":[{"db_id":"8937ea7c9fd026836a5c262c8569963e","evidence":{"patch_ids":["f2484a0ea37309c0a083683b6f24f404"],"same_day":true,"statement_hash":"a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Fix possible erroneous reports of invalid affixes while parsing Ispell dictionaries","url":"/docs/compare/?release=16.9#16.9-120195bfc62f85d9","version":"16.9"},{"db_id":"2d395b5defef434bec7ea4da45b42ad7","evidence":{"patch_ids":["f2484a0ea37309c0a083683b6f24f404"],"same_day":true,"statement_hash":"a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Fix possible erroneous reports of invalid affixes while parsing Ispell dictionaries","url":"/docs/compare/?release=15.13#15.13-327c96a58899c1ae","version":"15.13"},{"db_id":"8d306975e4b0a9c39e7fff8c8ad3613e","evidence":{"patch_ids":["f2484a0ea37309c0a083683b6f24f404"],"same_day":true,"statement_hash":"a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Fix possible erroneous reports of invalid affixes while parsing Ispell dictionaries","url":"/docs/compare/?release=14.18#14.18-60d7303621919c68","version":"14.18"},{"db_id":"eb58cef266f21c9edb703764403f7168","evidence":{"patch_ids":["f2484a0ea37309c0a083683b6f24f404"],"same_day":true,"statement_hash":"a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Fix possible erroneous reports of invalid affixes while parsing Ispell dictionaries","url":"/docs/compare/?release=13.21#13.21-c84be53354aebbd7","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["f2484a0ea37309c0a083683b6f24f404"],"same_day":true,"statement_hash":"a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666"},"rule":2,"target":"2d395b5defef434bec7ea4da45b42ad7","type":"equivalent"},{"evidence":{"patch_ids":["f2484a0ea37309c0a083683b6f24f404"],"same_day":true,"statement_hash":"a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666"},"rule":2,"target":"8937ea7c9fd026836a5c262c8569963e","type":"equivalent"},{"evidence":{"patch_ids":["f2484a0ea37309c0a083683b6f24f404"],"same_day":true,"statement_hash":"a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666"},"rule":2,"target":"8d306975e4b0a9c39e7fff8c8ad3613e","type":"equivalent"},{"evidence":{"patch_ids":["f2484a0ea37309c0a083683b6f24f404"],"same_day":true,"statement_hash":"a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666"},"rule":2,"target":"eb58cef266f21c9edb703764403f7168","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["99c01aadf"],"source_entry_id":"17.5/changes/011","source_hash":"c69cbcecbbdadc504ceb6c9f2c01e7195390e8fc25e96a1fa9a6b1d84d5eef14","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"a99d8bf2396babe0930adb5536a57eee692561e5efed988b319c441a85e28666","text":"Fix possible erroneous reports of invalid affixes while parsing Ispell dictionaries (Jacob Brazeal) §","title":"Fix possible erroneous reports of invalid affixes while parsing Ispell dictionaries","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["053222a97","0941aadcd","1d180931c","2d6cfb0cd","95f650674","aac07b562","bd178960c","c75c830e2","d31d39cfe","d6dd2a02b","dd34cbfce","edc3bccd0"],"commit_groups":[["053222a97","0941aadcd","2d6cfb0cd","bd178960c","d31d39cfe","dd34cbfce"],["1d180931c","95f650674","aac07b562","c75c830e2","d6dd2a02b","edc3bccd0"]],"commits":["0941aadcd","d6dd2a02b"],"cves":[],"db_id":"bda06720441f8b94b004bc75152072f7","html":"\u003cp\u003eFix \u003ccode\u003eALTER TABLE ADD COLUMN\u003c/code\u003e to correctly handle the case of a domain type that has a default (Jian He, Tom Lane, Tender Wang) \u003ca href=\"https://postgr.es/c/d6dd2a02b\"\u003e§\u003c/a\u003e \u003ca href=\"https://postgr.es/c/0941aadcd\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eIf a domain type has a default, adding a column of that type (without any explicit \u003ccode\u003eDEFAULT\u003c/code\u003e clause) failed to install the domain's default value in existing rows, instead leaving the new column null.\u003c/p\u003e","id":"17.5-2de3ea680928346f","identity_text":"Fix ALTER TABLE ADD COLUMN to correctly handle the case of a domain type that has a default (Jian He, Tom Lane, Tender Wang) If a domain type has a default, adding a column of that type (without any explicit DEFAULT clause) failed to install the domain's default value in existing rows, instead leaving the new column null.","part":"changes","patch_ids":["63b929a73acffed8834764ac057b1130","90edbbe7a64e4f9be0183e7d3a909fcb"],"related_changes":[{"db_id":"b21fa0b3c6540e52538f3695fe644b48","evidence":{"patch_ids":["63b929a73acffed8834764ac057b1130","90edbbe7a64e4f9be0183e7d3a909fcb"],"same_day":true,"statement_hash":"9dde4454d5d016960324b8efe0e0cbc6cb88a91609eec3a0aac95a6b33e97448"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Fix ALTER TABLE ADD COLUMN to correctly handle the case of a domain type that has a default","url":"/docs/compare/?release=16.9#16.9-f431ea6a5d783302","version":"16.9"},{"db_id":"e7731739d7e0e48daada65e0f3f2f700","evidence":{"patch_ids":["63b929a73acffed8834764ac057b1130","90edbbe7a64e4f9be0183e7d3a909fcb"],"same_day":true,"statement_hash":"9dde4454d5d016960324b8efe0e0cbc6cb88a91609eec3a0aac95a6b33e97448"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Fix ALTER TABLE ADD COLUMN to correctly handle the case of a domain type that has a default","url":"/docs/compare/?release=15.13#15.13-15397e28cacbb50b","version":"15.13"},{"db_id":"37a827dba2a507a5634eda2d0066034c","evidence":{"patch_ids":["63b929a73acffed8834764ac057b1130","90edbbe7a64e4f9be0183e7d3a909fcb"],"same_day":true,"statement_hash":"9dde4454d5d016960324b8efe0e0cbc6cb88a91609eec3a0aac95a6b33e97448"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Fix ALTER TABLE ADD COLUMN to correctly handle the case of a domain type that has a default","url":"/docs/compare/?release=14.18#14.18-338b3f4c18daa9a7","version":"14.18"},{"db_id":"67b1fe09f72f93e8e744403275b7aa4e","evidence":{"patch_ids":["63b929a73acffed8834764ac057b1130","90edbbe7a64e4f9be0183e7d3a909fcb"],"same_day":true,"statement_hash":"9dde4454d5d016960324b8efe0e0cbc6cb88a91609eec3a0aac95a6b33e97448"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Fix ALTER TABLE ADD COLUMN to correctly handle the case of a domain type that has a default","url":"/docs/compare/?release=13.21#13.21-524aff75bb28f7d8","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["63b929a73acffed8834764ac057b1130","90edbbe7a64e4f9be0183e7d3a909fcb"],"same_day":true,"statement_hash":"9dde4454d5d016960324b8efe0e0cbc6cb88a91609eec3a0aac95a6b33e97448"},"rule":2,"target":"37a827dba2a507a5634eda2d0066034c","type":"equivalent"},{"evidence":{"patch_ids":["63b929a73acffed8834764ac057b1130","90edbbe7a64e4f9be0183e7d3a909fcb"],"same_day":true,"statement_hash":"9dde4454d5d016960324b8efe0e0cbc6cb88a91609eec3a0aac95a6b33e97448"},"rule":2,"target":"67b1fe09f72f93e8e744403275b7aa4e","type":"equivalent"},{"evidence":{"patch_ids":["63b929a73acffed8834764ac057b1130","90edbbe7a64e4f9be0183e7d3a909fcb"],"same_day":true,"statement_hash":"9dde4454d5d016960324b8efe0e0cbc6cb88a91609eec3a0aac95a6b33e97448"},"rule":2,"target":"b21fa0b3c6540e52538f3695fe644b48","type":"equivalent"},{"evidence":{"patch_ids":["63b929a73acffed8834764ac057b1130","90edbbe7a64e4f9be0183e7d3a909fcb"],"same_day":true,"statement_hash":"9dde4454d5d016960324b8efe0e0cbc6cb88a91609eec3a0aac95a6b33e97448"},"rule":2,"target":"e7731739d7e0e48daada65e0f3f2f700","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["0941aadcd","d6dd2a02b"],"source_entry_id":"17.5/changes/012","source_hash":"e17bd486396d8f506b105d991bc248edfaadb8f4800c80e28135962eda527fc2","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"9dde4454d5d016960324b8efe0e0cbc6cb88a91609eec3a0aac95a6b33e97448","text":"Fix ALTER TABLE ADD COLUMN to correctly handle the case of a domain type that has a default (Jian He, Tom Lane, Tender Wang) § § If a domain type has a default, adding a column of that type (without any explicit DEFAULT clause) failed to install the domain's default value in existing rows, instead leaving the new column null.","title":"Fix ALTER TABLE ADD COLUMN to correctly handle the case of a domain type that has a default","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["43b8e6c4a","5e6e97fbf","f5069f026","fb3a77fd9"],"commit_groups":[["43b8e6c4a","5e6e97fbf","f5069f026","fb3a77fd9"]],"commits":["5e6e97fbf"],"cves":[],"db_id":"0a757a37fd2e72cdf597d7af06e9a5cc","html":"\u003cp\u003eRepair misbehavior when there are duplicate column names in a foreign key constraint's \u003ccode\u003eON DELETE SET DEFAULT\u003c/code\u003e or \u003ccode\u003eSET NULL\u003c/code\u003e action (Tom Lane) \u003ca href=\"https://postgr.es/c/5e6e97fbf\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-9ca373aa755a5d32","identity_text":"Repair misbehavior when there are duplicate column names in a foreign key constraint's ON DELETE SET DEFAULT or SET NULL action (Tom Lane)","part":"changes","patch_ids":["0463a615e1593dccb7b87c1603d1023e"],"related_changes":[{"db_id":"f425eb6588619efaa05c5627ecfd1982","evidence":{"patch_ids":["0463a615e1593dccb7b87c1603d1023e"],"same_day":true,"statement_hash":"a71e56dee58800f016c8ea1ef9b1e6877059d15b1990a7f5fdc2c9072d744ff9"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Repair misbehavior when there are duplicate column names in a foreign key constraint's ON DELETE SET DEFAULT or SET NULL action","url":"/docs/compare/?release=16.9#16.9-1a5ffc33369b1eaa","version":"16.9"},{"db_id":"b3fe742dcc4f9be7c3fc225a8ac3f45c","evidence":{"patch_ids":["0463a615e1593dccb7b87c1603d1023e"],"same_day":true,"statement_hash":"a71e56dee58800f016c8ea1ef9b1e6877059d15b1990a7f5fdc2c9072d744ff9"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Repair misbehavior when there are duplicate column names in a foreign key constraint's ON DELETE SET DEFAULT or SET NULL action","url":"/docs/compare/?release=15.13#15.13-70f292a582324966","version":"15.13"}],"relations":[{"evidence":{"patch_ids":["0463a615e1593dccb7b87c1603d1023e"],"same_day":true,"statement_hash":"a71e56dee58800f016c8ea1ef9b1e6877059d15b1990a7f5fdc2c9072d744ff9"},"rule":2,"target":"b3fe742dcc4f9be7c3fc225a8ac3f45c","type":"equivalent"},{"evidence":{"patch_ids":["0463a615e1593dccb7b87c1603d1023e"],"same_day":true,"statement_hash":"a71e56dee58800f016c8ea1ef9b1e6877059d15b1990a7f5fdc2c9072d744ff9"},"rule":2,"target":"f425eb6588619efaa05c5627ecfd1982","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["5e6e97fbf"],"source_entry_id":"17.5/changes/013","source_hash":"d1a8fc4908f6d35969d49c0f8ac6082c2ad19bca10fde48f9c9f7348f2ef50d5","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"a71e56dee58800f016c8ea1ef9b1e6877059d15b1990a7f5fdc2c9072d744ff9","text":"Repair misbehavior when there are duplicate column names in a foreign key constraint's ON DELETE SET DEFAULT or SET NULL action (Tom Lane) §","title":"Repair misbehavior when there are duplicate column names in a foreign key constraint's ON DELETE SET DEFAULT or SET NULL action","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["0f354e080","4e026be5f","7bbc46213","931a1c023","9ea5fe5b6","bf1e2d2db"],"commit_groups":[["0f354e080","4e026be5f","7bbc46213","931a1c023","9ea5fe5b6","bf1e2d2db"]],"commits":["4e026be5f"],"cves":[],"db_id":"c85aaec4454f3f6c178e25e80fc110f7","html":"\u003cp\u003eImprove the error message for disallowed attempts to alter the properties of a foreign key constraint (Álvaro Herrera) \u003ca href=\"https://postgr.es/c/4e026be5f\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-4a57902eda945b83","identity_text":"Improve the error message for disallowed attempts to alter the properties of a foreign key constraint (Álvaro Herrera)","part":"changes","patch_ids":["728bdeda1a76ff257ed4bba316259080"],"related_changes":[{"db_id":"5627f1c1d8a4f69c29448aee864c6b84","evidence":{"patch_ids":["728bdeda1a76ff257ed4bba316259080"],"same_day":true,"statement_hash":"69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Improve the error message for disallowed attempts to alter the properties of a foreign key constraint","url":"/docs/compare/?release=16.9#16.9-d72b0590a5240169","version":"16.9"},{"db_id":"dfe47a550f472aa86b315fdfc03d4aa5","evidence":{"patch_ids":["728bdeda1a76ff257ed4bba316259080"],"same_day":true,"statement_hash":"69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Improve the error message for disallowed attempts to alter the properties of a foreign key constraint","url":"/docs/compare/?release=15.13#15.13-5a8186c93235cabd","version":"15.13"},{"db_id":"0b9e876fbe15368f7eb3e73dd5bde6fd","evidence":{"patch_ids":["728bdeda1a76ff257ed4bba316259080"],"same_day":true,"statement_hash":"69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Improve the error message for disallowed attempts to alter the properties of a foreign key constraint","url":"/docs/compare/?release=14.18#14.18-c2054eb401976a11","version":"14.18"},{"db_id":"0d1236e87dc3b61c47a965fdf13a3b6e","evidence":{"patch_ids":["728bdeda1a76ff257ed4bba316259080"],"same_day":true,"statement_hash":"69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Improve the error message for disallowed attempts to alter the properties of a foreign key constraint","url":"/docs/compare/?release=13.21#13.21-5056a890e5317fea","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["728bdeda1a76ff257ed4bba316259080"],"same_day":true,"statement_hash":"69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e"},"rule":2,"target":"0b9e876fbe15368f7eb3e73dd5bde6fd","type":"equivalent"},{"evidence":{"patch_ids":["728bdeda1a76ff257ed4bba316259080"],"same_day":true,"statement_hash":"69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e"},"rule":2,"target":"0d1236e87dc3b61c47a965fdf13a3b6e","type":"equivalent"},{"evidence":{"patch_ids":["728bdeda1a76ff257ed4bba316259080"],"same_day":true,"statement_hash":"69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e"},"rule":2,"target":"5627f1c1d8a4f69c29448aee864c6b84","type":"equivalent"},{"evidence":{"patch_ids":["728bdeda1a76ff257ed4bba316259080"],"same_day":true,"statement_hash":"69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e"},"rule":2,"target":"dfe47a550f472aa86b315fdfc03d4aa5","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["4e026be5f"],"source_entry_id":"17.5/changes/014","source_hash":"639ca778e678bc1b49463be358ace32122d5ddce59cd19f9cb4ca7143fde374f","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"69d10dbdc12bb154d1a6cea5ee9e09a2b99194bd690c1fcb18cb3ef905c1e82e","text":"Improve the error message for disallowed attempts to alter the properties of a foreign key constraint (Álvaro Herrera) §","title":"Improve the error message for disallowed attempts to alter the properties of a foreign key constraint","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["2d5350cfb","5905e9935","a61b67cd0","d0a049987","d34b671a6","e0f53e669"],"commit_groups":[["2d5350cfb","5905e9935","a61b67cd0","d0a049987","d34b671a6","e0f53e669"]],"commits":["d0a049987"],"cves":[],"db_id":"c500adf4525e7393fbb98cdb336cc64a","html":"\u003cp\u003eAvoid error when resetting the \u003ccode\u003erelhassubclass\u003c/code\u003e flag of a temporary table that's marked \u003ccode\u003eON COMMIT DELETE ROWS\u003c/code\u003e (Noah Misch) \u003ca href=\"https://postgr.es/c/d0a049987\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-b17b36d23abec8d7","identity_text":"Avoid error when resetting the relhassubclass flag of a temporary table that's marked ON COMMIT DELETE ROWS (Noah Misch)","part":"changes","patch_ids":["094a862179c0b39d921a9e561fa15870"],"related_changes":[{"db_id":"b6d27235f074c918e62b489bdf3cfbba","evidence":{"patch_ids":["094a862179c0b39d921a9e561fa15870"],"same_day":true,"statement_hash":"6a67c492f1ab19533dfcea2a041a797a78f234546ded977e8443af5eed897716"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Avoid error when resetting the relhassubclass flag of a temporary table that's marked ON COMMIT DELETE ROWS","url":"/docs/compare/?release=16.9#16.9-1420db24bb1e2cab","version":"16.9"},{"db_id":"89ce417881f616fe136cb14aa40da99f","evidence":{"patch_ids":["094a862179c0b39d921a9e561fa15870"],"same_day":true,"statement_hash":"6a67c492f1ab19533dfcea2a041a797a78f234546ded977e8443af5eed897716"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Avoid error when resetting the relhassubclass flag of a temporary table that's marked ON COMMIT DELETE ROWS","url":"/docs/compare/?release=15.13#15.13-aeab43b9af8c9591","version":"15.13"},{"db_id":"2970c113ec75804e2bbeaf779747bffa","evidence":{"patch_ids":["094a862179c0b39d921a9e561fa15870"],"same_day":true,"statement_hash":"6a67c492f1ab19533dfcea2a041a797a78f234546ded977e8443af5eed897716"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Avoid error when resetting the relhassubclass flag of a temporary table that's marked ON COMMIT DELETE ROWS","url":"/docs/compare/?release=14.18#14.18-fc90ad8d130d1aa5","version":"14.18"},{"db_id":"efa1ed5e465f24cd978e2e5f6a028f46","evidence":{"patch_ids":["094a862179c0b39d921a9e561fa15870"],"same_day":true,"statement_hash":"6a67c492f1ab19533dfcea2a041a797a78f234546ded977e8443af5eed897716"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Avoid error when resetting the relhassubclass flag of a temporary table that's marked ON COMMIT DELETE ROWS","url":"/docs/compare/?release=13.21#13.21-23bb14178943d8c3","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["094a862179c0b39d921a9e561fa15870"],"same_day":true,"statement_hash":"6a67c492f1ab19533dfcea2a041a797a78f234546ded977e8443af5eed897716"},"rule":2,"target":"2970c113ec75804e2bbeaf779747bffa","type":"equivalent"},{"evidence":{"patch_ids":["094a862179c0b39d921a9e561fa15870"],"same_day":true,"statement_hash":"6a67c492f1ab19533dfcea2a041a797a78f234546ded977e8443af5eed897716"},"rule":2,"target":"89ce417881f616fe136cb14aa40da99f","type":"equivalent"},{"evidence":{"patch_ids":["094a862179c0b39d921a9e561fa15870"],"same_day":true,"statement_hash":"6a67c492f1ab19533dfcea2a041a797a78f234546ded977e8443af5eed897716"},"rule":2,"target":"b6d27235f074c918e62b489bdf3cfbba","type":"equivalent"},{"evidence":{"patch_ids":["094a862179c0b39d921a9e561fa15870"],"same_day":true,"statement_hash":"6a67c492f1ab19533dfcea2a041a797a78f234546ded977e8443af5eed897716"},"rule":2,"target":"efa1ed5e465f24cd978e2e5f6a028f46","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["d0a049987"],"source_entry_id":"17.5/changes/015","source_hash":"3d12b7913cce11eb22a6fda6877f733ba76b3dd7bc6f44e800728d0a010a6b29","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"6a67c492f1ab19533dfcea2a041a797a78f234546ded977e8443af5eed897716","text":"Avoid error when resetting the relhassubclass flag of a temporary table that's marked ON COMMIT DELETE ROWS (Noah Misch) §","title":"Avoid error when resetting the relhassubclass flag of a temporary table that's marked ON COMMIT DELETE ROWS","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["0af3ae468","2e0f93d7c","310907aaf","514d47dfb","665cafe8a","984410b92"],"commit_groups":[["0af3ae468","2e0f93d7c","984410b92"],["310907aaf","514d47dfb","665cafe8a"]],"commits":["2e0f93d7c","310907aaf"],"cves":[],"db_id":"fac8b7c36ee577ad4e7f8247c9b5bd1a","html":"\u003cp\u003eAdd missing deparsing of the \u003ccode\u003eINDENT\u003c/code\u003e option of \u003ccode\u003eXMLSERIALIZE()\u003c/code\u003e (Jim Jones) \u003ca href=\"https://postgr.es/c/2e0f93d7c\"\u003e§\u003c/a\u003e \u003ca href=\"https://postgr.es/c/310907aaf\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003ePreviously, views or rules using \u003ccode\u003eXMLSERIALIZE(... INDENT)\u003c/code\u003e were dumped without the \u003ccode\u003eINDENT\u003c/code\u003e clause, causing incorrect results after restore.\u003c/p\u003e","id":"17.5-e343d9b64061a702","identity_text":"Add missing deparsing of the INDENT option of XMLSERIALIZE() (Jim Jones) Previously, views or rules using XMLSERIALIZE(... INDENT) were dumped without the INDENT clause, causing incorrect results after restore.","part":"changes","patch_ids":["0e2fe4b8c0fea258d3eca04823f059eb","e0b0a75a7474c639be152892f60539d8"],"related_changes":[{"db_id":"d6c5420ccf434fdda6d425a9e7102916","evidence":{"patch_ids":["0e2fe4b8c0fea258d3eca04823f059eb","e0b0a75a7474c639be152892f60539d8"],"same_day":true,"statement_hash":"aadbeee94ef75446661d8a14331bd7e22063ff420d9c00bac7a44bd7465a8be1"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Add missing deparsing of the INDENT option of XMLSERIALIZE()","url":"/docs/compare/?release=16.9#16.9-898af344fbc35455","version":"16.9"}],"relations":[{"evidence":{"patch_ids":["0e2fe4b8c0fea258d3eca04823f059eb","e0b0a75a7474c639be152892f60539d8"],"same_day":true,"statement_hash":"aadbeee94ef75446661d8a14331bd7e22063ff420d9c00bac7a44bd7465a8be1"},"rule":2,"target":"d6c5420ccf434fdda6d425a9e7102916","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["2e0f93d7c","310907aaf"],"source_entry_id":"17.5/changes/016","source_hash":"59d8ebec7aae58ffe41ab03fef781b0fbc608ced2445748583eab92bab9cf804","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"aadbeee94ef75446661d8a14331bd7e22063ff420d9c00bac7a44bd7465a8be1","text":"Add missing deparsing of the INDENT option of XMLSERIALIZE() (Jim Jones) § § Previously, views or rules using XMLSERIALIZE(... INDENT) were dumped without the INDENT clause, causing incorrect results after restore.","title":"Add missing deparsing of the INDENT option of XMLSERIALIZE()","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["065ce49a1","887a23237","d47f92224"],"commit_groups":[["065ce49a1","887a23237","d47f92224"]],"commits":["065ce49a1"],"cves":[],"db_id":"e4dc0edd266ed1d136ff781d1eec9630","html":"\u003cp\u003eAvoid premature evaluation of the arguments of an aggregate function that has both \u003ccode\u003eFILTER\u003c/code\u003e and \u003ccode\u003eORDER BY\u003c/code\u003e (or \u003ccode\u003eDISTINCT\u003c/code\u003e) options (David Rowley) \u003ca href=\"https://postgr.es/c/065ce49a1\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eIf there is \u003ccode\u003eORDER BY\u003c/code\u003e or \u003ccode\u003eDISTINCT\u003c/code\u003e, we consider pre-sorting the aggregate input values rather than doing the sort within the Agg plan node. But this is problematic if the aggregate inputs include expressions that could fail (for example, a division where some of the input divisors could be zero) and there is a \u003ccode\u003eFILTER\u003c/code\u003e clause that's meant to prevent such failures. Pre-sorting would push the expression evaluations to before the \u003ccode\u003eFILTER\u003c/code\u003e test, allowing the failures to happen anyway. Avoid this by not pre-sorting if there's a \u003ccode\u003eFILTER\u003c/code\u003e and the input expressions are anything more complex than a simple Var or Const.\u003c/p\u003e","id":"17.5-268ffcaef0e5d586","identity_text":"Avoid premature evaluation of the arguments of an aggregate function that has both FILTER and ORDER BY (or DISTINCT) options (David Rowley) If there is ORDER BY or DISTINCT, we consider pre-sorting the aggregate input values rather than doing the sort within the Agg plan node. But this is problematic if the aggregate inputs include expressions that could fail (for example, a division where some of the input divisors could be zero) and there is a FILTER clause that's meant to prevent such failures. Pre-sorting would push the expression evaluations to before the FILTER test, allowing the failures to happen anyway. Avoid this by not pre-sorting if there's a FILTER and the input expressions are anything more complex than a simple Var or Const.","part":"changes","patch_ids":["742ea1bd97564d94d0ecee8eef10eb62"],"related_changes":[{"db_id":"c913ccbca6ac5f49a0fc52ab0ca8b1db","evidence":{"patch_ids":["742ea1bd97564d94d0ecee8eef10eb62"],"same_day":true,"statement_hash":"fae5ed1fcfde906d6e900be5faed1152ce433ff93c2a1ecc5b453e89addeb053"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Avoid premature evaluation of the arguments of an aggregate function that has both FILTER and ORDER BY (or DISTINCT) options","url":"/docs/compare/?release=16.9#16.9-3193d187af7b68f6","version":"16.9"}],"relations":[{"evidence":{"patch_ids":["742ea1bd97564d94d0ecee8eef10eb62"],"same_day":true,"statement_hash":"fae5ed1fcfde906d6e900be5faed1152ce433ff93c2a1ecc5b453e89addeb053"},"rule":2,"target":"c913ccbca6ac5f49a0fc52ab0ca8b1db","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["065ce49a1"],"source_entry_id":"17.5/changes/017","source_hash":"d9a3e385ebd30dd8e1d8dcdc911db422bbb6658cf3977907c75f81dff9c6f259","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"fae5ed1fcfde906d6e900be5faed1152ce433ff93c2a1ecc5b453e89addeb053","text":"Avoid premature evaluation of the arguments of an aggregate function that has both FILTER and ORDER BY (or DISTINCT) options (David Rowley) § If there is ORDER BY or DISTINCT, we consider pre-sorting the aggregate input values rather than doing the sort within the Agg plan node. But this is problematic if the aggregate inputs include expressions that could fail (for example, a division where some of the input divisors could be zero) and there is a FILTER clause that's meant to prevent such failures. Pre-sorting would push the expression evaluations to before the FILTER test, allowing the failures to happen anyway. Avoid this by not pre-sorting if there's a FILTER and the input expressions are anything more complex than a simple Var or Const.","title":"Avoid premature evaluation of the arguments of an aggregate function that has both FILTER and ORDER BY (or DISTINCT) options","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["716a051aa","bc5a08af3"],"commit_groups":[["716a051aa","bc5a08af3"]],"commits":["bc5a08af3"],"cves":[],"db_id":"a813a8612a6abc5ae0686ac8f4dafc07","html":"\u003cp\u003eFix erroneous deductions from column \u003ccode\u003eNOT NULL\u003c/code\u003e constraints in the presence of outer joins (Richard Guo) \u003ca href=\"https://postgr.es/c/bc5a08af3\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eIn some cases the planner would discard an \u003ccode\u003eIS NOT NULL\u003c/code\u003e query condition, even though the condition applies after an outer join and thus is not redundant.\u003c/p\u003e","id":"17.5-5028569f04e4503f","identity_text":"Fix erroneous deductions from column NOT NULL constraints in the presence of outer joins (Richard Guo) In some cases the planner would discard an IS NOT NULL query condition, even though the condition applies after an outer join and thus is not redundant.","part":"changes","patch_ids":["5c319dc4d44e3317c4492713897da0aa"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["bc5a08af3"],"source_entry_id":"17.5/changes/018","source_hash":"9e023c72d90d859ec578eef50f9734c9db4f59d390603ce2b10613becf099f21","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"2c84e6ddea4b46fa12877ac183f691d5839558b52f2bbd4a1d4e93081ef6e30f","text":"Fix erroneous deductions from column NOT NULL constraints in the presence of outer joins (Richard Guo) § In some cases the planner would discard an IS NOT NULL query condition, even though the condition applies after an outer join and thus is not redundant.","title":"Fix erroneous deductions from column NOT NULL constraints in the presence of outer joins","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["46b4ba533","b8b1e87b7"],"commit_groups":[["46b4ba533","b8b1e87b7"]],"commits":["b8b1e87b7"],"cves":[],"db_id":"6b787d35e5ff2fd4eb4e3ddb600aaca2","html":"\u003cp\u003eAvoid incorrect optimizations based on \u003ccode\u003eIS [NOT] NULL\u003c/code\u003e tests that are applied to composite values (Bruce Momjian) \u003ca href=\"https://postgr.es/c/b8b1e87b7\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-0c9207e6c326d46d","identity_text":"Avoid incorrect optimizations based on IS [NOT] NULL tests that are applied to composite values (Bruce Momjian)","part":"changes","patch_ids":["daa1c2e7e970bed57e3a6753e1571f9d"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["b8b1e87b7"],"source_entry_id":"17.5/changes/019","source_hash":"258915c03e2d0b77176cf9363f6c1924385dd07a0f9bcdf847fb4ad5ec3f81d9","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"a47263022e83d25644a39d9f6cfc1982c30dced0b6bcda3dadeaf4f3d9c649b3","text":"Avoid incorrect optimizations based on IS [NOT] NULL tests that are applied to composite values (Bruce Momjian) §","title":"Avoid incorrect optimizations based on IS [NOT] NULL tests that are applied to composite values","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["5672a8399","5a0840b76","a7f213b11","b136db07c","b68f664bb"],"commit_groups":[["5672a8399","5a0840b76","a7f213b11","b136db07c","b68f664bb"]],"commits":["5672a8399"],"cves":[],"db_id":"c150b87872d0c81d516fa614daf2b7d7","html":"\u003cp\u003eFix planner's failure to identify more than one hashable ScalarArrayOpExpr subexpression within a top-level expression (David Geier) \u003ca href=\"https://postgr.es/c/5672a8399\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThis resulted in unnecessarily-inefficient execution of any additional subexpressions that could have been processed with a hash table (that is, \u003ccode\u003eIN\u003c/code\u003e, \u003ccode\u003eNOT IN\u003c/code\u003e, or \u003ccode\u003e= ANY\u003c/code\u003e clauses with all-constant right-hand sides).\u003c/p\u003e","id":"17.5-72f6f2b7819f75e2","identity_text":"Fix planner's failure to identify more than one hashable ScalarArrayOpExpr subexpression within a top-level expression (David Geier) This resulted in unnecessarily-inefficient execution of any additional subexpressions that could have been processed with a hash table (that is, IN, NOT IN, or = ANY clauses with all-constant right-hand sides).","part":"changes","patch_ids":["7715be38dbf205b60f1999a58eaaafa5"],"related_changes":[{"db_id":"112b9b34138b4b2bd64079c8b58a28f4","evidence":{"patch_ids":["7715be38dbf205b60f1999a58eaaafa5"],"same_day":true,"statement_hash":"ebfd648fd24c795f3956756f7b503d27494bb599defa7b236acca07321b7d437"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Fix planner's failure to identify more than one hashable ScalarArrayOpExpr subexpression within a top-level expression","url":"/docs/compare/?release=16.9#16.9-2d186c53852fc3ec","version":"16.9"},{"db_id":"e34f77635f11982d50f3bce9f2835399","evidence":{"patch_ids":["7715be38dbf205b60f1999a58eaaafa5"],"same_day":true,"statement_hash":"ebfd648fd24c795f3956756f7b503d27494bb599defa7b236acca07321b7d437"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Fix planner's failure to identify more than one hashable ScalarArrayOpExpr subexpression within a top-level expression","url":"/docs/compare/?release=15.13#15.13-157a0b9b63a2cd20","version":"15.13"},{"db_id":"66f870b5ef1cd244a3b518e906ac9cd2","evidence":{"patch_ids":["7715be38dbf205b60f1999a58eaaafa5"],"same_day":true,"statement_hash":"ebfd648fd24c795f3956756f7b503d27494bb599defa7b236acca07321b7d437"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Fix planner's failure to identify more than one hashable ScalarArrayOpExpr subexpression within a top-level expression","url":"/docs/compare/?release=14.18#14.18-29258c00393168bc","version":"14.18"}],"relations":[{"evidence":{"patch_ids":["7715be38dbf205b60f1999a58eaaafa5"],"same_day":true,"statement_hash":"ebfd648fd24c795f3956756f7b503d27494bb599defa7b236acca07321b7d437"},"rule":2,"target":"112b9b34138b4b2bd64079c8b58a28f4","type":"equivalent"},{"evidence":{"patch_ids":["7715be38dbf205b60f1999a58eaaafa5"],"same_day":true,"statement_hash":"ebfd648fd24c795f3956756f7b503d27494bb599defa7b236acca07321b7d437"},"rule":2,"target":"66f870b5ef1cd244a3b518e906ac9cd2","type":"equivalent"},{"evidence":{"patch_ids":["7715be38dbf205b60f1999a58eaaafa5"],"same_day":true,"statement_hash":"ebfd648fd24c795f3956756f7b503d27494bb599defa7b236acca07321b7d437"},"rule":2,"target":"e34f77635f11982d50f3bce9f2835399","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["5672a8399"],"source_entry_id":"17.5/changes/020","source_hash":"3d39ce4f5f32767c25aa12f00fa0afa0c5cd8eba04a79e2a31f6a49facb18df6","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"ebfd648fd24c795f3956756f7b503d27494bb599defa7b236acca07321b7d437","text":"Fix planner's failure to identify more than one hashable ScalarArrayOpExpr subexpression within a top-level expression (David Geier) § This resulted in unnecessarily-inefficient execution of any additional subexpressions that could have been processed with a hash table (that is, IN, NOT IN, or = ANY clauses with all-constant right-hand sides).","title":"Fix planner's failure to identify more than one hashable ScalarArrayOpExpr subexpression within a top-level expression","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["587b6aa3f","9ba7bcc89"],"commit_groups":[["587b6aa3f","9ba7bcc89"]],"commits":["587b6aa3f"],"cves":[],"db_id":"f8b3993efe4b1cc33a7d48d17ca578d2","html":"\u003cp\u003eFix incorrect table size estimate with low fill factor (Tomas Vondra) \u003ca href=\"https://postgr.es/c/587b6aa3f\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eWhen the planner estimates the number of rows in a never-yet-analyzed table, it uses the table's fillfactor setting in the estimation, but it neglected to clamp the result to at least one row per page. A low fillfactor could thus result in an unreasonably small estimate.\u003c/p\u003e","id":"17.5-6384325bf343b02a","identity_text":"Fix incorrect table size estimate with low fill factor (Tomas Vondra) When the planner estimates the number of rows in a never-yet-analyzed table, it uses the table's fillfactor setting in the estimation, but it neglected to clamp the result to at least one row per page. A low fillfactor could thus result in an unreasonably small estimate.","part":"changes","patch_ids":["816261129d787a6f2bd0989a506895f7"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["587b6aa3f"],"source_entry_id":"17.5/changes/021","source_hash":"d224e4d08dc951edfe8da840ccff1d1b5c2620349732393899fedfbd65080db2","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"59e83ab85d03a81a8f45c9e421e1703076c446148a9887625820f400efdb89b2","text":"Fix incorrect table size estimate with low fill factor (Tomas Vondra) § When the planner estimates the number of rows in a never-yet-analyzed table, it uses the table's fillfactor setting in the estimation, but it neglected to clamp the result to at least one row per page. A low fillfactor could thus result in an unreasonably small estimate.","title":"Fix incorrect table size estimate with low fill factor","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["459e7bf8e","4934d3875","77d90d6d6","78cb2466f","980727b84","b9ec8125d"],"commit_groups":[["459e7bf8e","4934d3875","77d90d6d6","78cb2466f","980727b84","b9ec8125d"]],"commits":["78cb2466f"],"cves":[],"db_id":"623c2024106007645fec5d71fb5712bb","html":"\u003cp\u003eDisable \u003cspan\u003e“\u003cspan\u003eskip fetch\u003c/span\u003e”\u003c/span\u003e optimization in bitmap heap scan (Matthias van de Meent) \u003ca href=\"https://postgr.es/c/78cb2466f\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eIt turns out that this optimization can result in returning dead tuples when a concurrent vacuum marks a page all-visible.\u003c/p\u003e","id":"17.5-d0e0aee72000234f","identity_text":"Disable skip fetch optimization in bitmap heap scan (Matthias van de Meent) It turns out that this optimization can result in returning dead tuples when a concurrent vacuum marks a page all-visible.","part":"changes","patch_ids":["24bd9f8c7d1c77a2c13ebf151d4f8c78"],"related_changes":[{"db_id":"b694546a946a05eab3a70dbe84ca5802","evidence":{"patch_ids":["24bd9f8c7d1c77a2c13ebf151d4f8c78"],"same_day":true,"statement_hash":"8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Disable “skip fetch” optimization in bitmap heap scan","url":"/docs/compare/?release=16.9#16.9-ec226192f4ec4117","version":"16.9"},{"db_id":"fac79d43b3a211db66f6f7439608ee0d","evidence":{"patch_ids":["24bd9f8c7d1c77a2c13ebf151d4f8c78"],"same_day":true,"statement_hash":"8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Disable “skip fetch” optimization in bitmap heap scan","url":"/docs/compare/?release=15.13#15.13-0fcfc7db639b5e6d","version":"15.13"},{"db_id":"5b84c530a1833db604577188570826f0","evidence":{"patch_ids":["24bd9f8c7d1c77a2c13ebf151d4f8c78"],"same_day":true,"statement_hash":"8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Disable “skip fetch” optimization in bitmap heap scan","url":"/docs/compare/?release=14.18#14.18-7fee35a12ed31c20","version":"14.18"},{"db_id":"aad339e7e9006b00a0a084b4f930d309","evidence":{"patch_ids":["24bd9f8c7d1c77a2c13ebf151d4f8c78"],"same_day":true,"statement_hash":"8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Disable “skip fetch” optimization in bitmap heap scan","url":"/docs/compare/?release=13.21#13.21-a23918277d20303c","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["24bd9f8c7d1c77a2c13ebf151d4f8c78"],"same_day":true,"statement_hash":"8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67"},"rule":2,"target":"5b84c530a1833db604577188570826f0","type":"equivalent"},{"evidence":{"patch_ids":["24bd9f8c7d1c77a2c13ebf151d4f8c78"],"same_day":true,"statement_hash":"8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67"},"rule":2,"target":"aad339e7e9006b00a0a084b4f930d309","type":"equivalent"},{"evidence":{"patch_ids":["24bd9f8c7d1c77a2c13ebf151d4f8c78"],"same_day":true,"statement_hash":"8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67"},"rule":2,"target":"b694546a946a05eab3a70dbe84ca5802","type":"equivalent"},{"evidence":{"patch_ids":["24bd9f8c7d1c77a2c13ebf151d4f8c78"],"same_day":true,"statement_hash":"8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67"},"rule":2,"target":"fac79d43b3a211db66f6f7439608ee0d","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["78cb2466f"],"source_entry_id":"17.5/changes/022","source_hash":"8fcf0cdbdd47a77b3865bbc4c9085216fd1bc0e335fd83ac73a821d4426112a7","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"8f4cf3b56c19d886317615b5f6a44c5d0e2b2b6a87c82a344367ba093f15aa67","text":"Disable “skip fetch” optimization in bitmap heap scan (Matthias van de Meent) § It turns out that this optimization can result in returning dead tuples when a concurrent vacuum marks a page all-visible.","title":"Disable “skip fetch” optimization in bitmap heap scan","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["0f21db36d","1b47a112a","2d313375c","308d0d443","4b65b085a","8c153fcfa","9094eb25b","9a8c16aec","c7597a1d3","d52221cf0","e2a6934a8","e708ffe79"],"commit_groups":[["0f21db36d","2d313375c","308d0d443","9094eb25b","d52221cf0","e2a6934a8"],["1b47a112a","4b65b085a","8c153fcfa","9a8c16aec","c7597a1d3","e708ffe79"]],"commits":["8c153fcfa","9094eb25b"],"cves":[],"db_id":"c2e95259bc7f81ee87e2761072380865","html":"\u003cp\u003eFix performance issues in GIN index search startup when there are many search keys (Tom Lane, Vinod Sridharan) \u003ca href=\"https://postgr.es/c/9094eb25b\"\u003e§\u003c/a\u003e \u003ca href=\"https://postgr.es/c/8c153fcfa\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eAn indexable clause with many keys (for example, \u003ccode\u003ejsonbcol ?| array[...]\u003c/code\u003e with tens of thousands of array elements) took O(N\u003csup\u003e2\u003c/sup\u003e) time to start up, and was uncancelable for that interval too.\u003c/p\u003e","id":"17.5-6b61702f0e96682e","identity_text":"Fix performance issues in GIN index search startup when there are many search keys (Tom Lane, Vinod Sridharan) An indexable clause with many keys (for example, jsonbcol ?| array[...] with tens of thousands of array elements) took O(N2) time to start up, and was uncancelable for that interval too.","part":"changes","patch_ids":["de4829b5fcffd69ee19e71256ee340b9","ec9c3e41474954f7fb3b16769b3eaf5f"],"related_changes":[{"db_id":"707313a20483b8bc0146a58eceddd16a","evidence":{"patch_ids":["de4829b5fcffd69ee19e71256ee340b9","ec9c3e41474954f7fb3b16769b3eaf5f"],"same_day":true,"statement_hash":"93737b3baf31ce844a14e13d2cb447939c4de0b0f6567d19e55d971b065c60b0"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Fix performance issues in GIN index search startup when there are many search keys","url":"/docs/compare/?release=16.9#16.9-76f9b8a1ec89763d","version":"16.9"},{"db_id":"65badec0734fc6d175300062388f4788","evidence":{"patch_ids":["de4829b5fcffd69ee19e71256ee340b9","ec9c3e41474954f7fb3b16769b3eaf5f"],"same_day":true,"statement_hash":"93737b3baf31ce844a14e13d2cb447939c4de0b0f6567d19e55d971b065c60b0"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Fix performance issues in GIN index search startup when there are many search keys","url":"/docs/compare/?release=15.13#15.13-2d5e284461370519","version":"15.13"},{"db_id":"1ab0dec254a916d8527a62996788c2ae","evidence":{"patch_ids":["de4829b5fcffd69ee19e71256ee340b9","ec9c3e41474954f7fb3b16769b3eaf5f"],"same_day":true,"statement_hash":"93737b3baf31ce844a14e13d2cb447939c4de0b0f6567d19e55d971b065c60b0"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Fix performance issues in GIN index search startup when there are many search keys","url":"/docs/compare/?release=14.18#14.18-84519914d6f02e17","version":"14.18"},{"db_id":"e9ec96a7119ad1ceca446c7f063da569","evidence":{"patch_ids":["de4829b5fcffd69ee19e71256ee340b9","ec9c3e41474954f7fb3b16769b3eaf5f"],"same_day":true,"statement_hash":"93737b3baf31ce844a14e13d2cb447939c4de0b0f6567d19e55d971b065c60b0"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Fix performance issues in GIN index search startup when there are many search keys","url":"/docs/compare/?release=13.21#13.21-8e25b16da69e5339","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["de4829b5fcffd69ee19e71256ee340b9","ec9c3e41474954f7fb3b16769b3eaf5f"],"same_day":true,"statement_hash":"93737b3baf31ce844a14e13d2cb447939c4de0b0f6567d19e55d971b065c60b0"},"rule":2,"target":"1ab0dec254a916d8527a62996788c2ae","type":"equivalent"},{"evidence":{"patch_ids":["de4829b5fcffd69ee19e71256ee340b9","ec9c3e41474954f7fb3b16769b3eaf5f"],"same_day":true,"statement_hash":"93737b3baf31ce844a14e13d2cb447939c4de0b0f6567d19e55d971b065c60b0"},"rule":2,"target":"65badec0734fc6d175300062388f4788","type":"equivalent"},{"evidence":{"patch_ids":["de4829b5fcffd69ee19e71256ee340b9","ec9c3e41474954f7fb3b16769b3eaf5f"],"same_day":true,"statement_hash":"93737b3baf31ce844a14e13d2cb447939c4de0b0f6567d19e55d971b065c60b0"},"rule":2,"target":"707313a20483b8bc0146a58eceddd16a","type":"equivalent"},{"evidence":{"patch_ids":["de4829b5fcffd69ee19e71256ee340b9","ec9c3e41474954f7fb3b16769b3eaf5f"],"same_day":true,"statement_hash":"93737b3baf31ce844a14e13d2cb447939c4de0b0f6567d19e55d971b065c60b0"},"rule":2,"target":"e9ec96a7119ad1ceca446c7f063da569","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["8c153fcfa","9094eb25b"],"source_entry_id":"17.5/changes/023","source_hash":"2a01d04211f2ad6ab8211c369bb80d4f167e071b761d491e7241c57ce08b370a","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"93737b3baf31ce844a14e13d2cb447939c4de0b0f6567d19e55d971b065c60b0","text":"Fix performance issues in GIN index search startup when there are many search keys (Tom Lane, Vinod Sridharan) § § An indexable clause with many keys (for example, jsonbcol ?| array[...] with tens of thousands of array elements) took O(N2) time to start up, and was uncancelable for that interval too.","title":"Fix performance issues in GIN index search startup when there are many search keys","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["17ce344f8","5144e1f8f","5d8c58800","ade976f8b","e0d8f49a3","f5b4a0b49"],"commit_groups":[["17ce344f8","5144e1f8f","5d8c58800","ade976f8b","e0d8f49a3","f5b4a0b49"]],"commits":["ade976f8b"],"cves":[],"db_id":"5267301b9758c9e418c0bd305338d9d1","html":"\u003cp\u003eDetect missing support procedures in a BRIN index operator class, and report an error instead of crashing (Álvaro Herrera) \u003ca href=\"https://postgr.es/c/ade976f8b\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-71d6a890dc54737c","identity_text":"Detect missing support procedures in a BRIN index operator class, and report an error instead of crashing (Álvaro Herrera)","part":"changes","patch_ids":["a6ad3f27f4898d4cf7e1f8d5714f4623"],"related_changes":[{"db_id":"81a8c631d535b28a942e5afb558c8727","evidence":{"patch_ids":["a6ad3f27f4898d4cf7e1f8d5714f4623"],"same_day":true,"statement_hash":"434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Detect missing support procedures in a BRIN index operator class, and report an error instead of crashing","url":"/docs/compare/?release=16.9#16.9-d751d04da9ab2a78","version":"16.9"},{"db_id":"52095fe055fa798df8e06d9733eeeee4","evidence":{"patch_ids":["a6ad3f27f4898d4cf7e1f8d5714f4623"],"same_day":true,"statement_hash":"434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Detect missing support procedures in a BRIN index operator class, and report an error instead of crashing","url":"/docs/compare/?release=15.13#15.13-b46b133391a86774","version":"15.13"},{"db_id":"07795445e3fa35543669ce4ac06e9c03","evidence":{"patch_ids":["a6ad3f27f4898d4cf7e1f8d5714f4623"],"same_day":true,"statement_hash":"434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Detect missing support procedures in a BRIN index operator class, and report an error instead of crashing","url":"/docs/compare/?release=14.18#14.18-c82d8eee5284ac1f","version":"14.18"},{"db_id":"5013f22cc83ed83185fae40ec6f85d0c","evidence":{"patch_ids":["a6ad3f27f4898d4cf7e1f8d5714f4623"],"same_day":true,"statement_hash":"434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Detect missing support procedures in a BRIN index operator class, and report an error instead of crashing","url":"/docs/compare/?release=13.21#13.21-96cb58bb59f0ca93","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["a6ad3f27f4898d4cf7e1f8d5714f4623"],"same_day":true,"statement_hash":"434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276"},"rule":2,"target":"07795445e3fa35543669ce4ac06e9c03","type":"equivalent"},{"evidence":{"patch_ids":["a6ad3f27f4898d4cf7e1f8d5714f4623"],"same_day":true,"statement_hash":"434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276"},"rule":2,"target":"5013f22cc83ed83185fae40ec6f85d0c","type":"equivalent"},{"evidence":{"patch_ids":["a6ad3f27f4898d4cf7e1f8d5714f4623"],"same_day":true,"statement_hash":"434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276"},"rule":2,"target":"52095fe055fa798df8e06d9733eeeee4","type":"equivalent"},{"evidence":{"patch_ids":["a6ad3f27f4898d4cf7e1f8d5714f4623"],"same_day":true,"statement_hash":"434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276"},"rule":2,"target":"81a8c631d535b28a942e5afb558c8727","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["ade976f8b"],"source_entry_id":"17.5/changes/024","source_hash":"f36755eb23e6b931c7fd525b71ef93166a8e6a3f0841ba4759a854adc2edfcaa","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"434633f2d6ebbae84da60c5fa9e653325724888f4ced50a9c929141223e20276","text":"Detect missing support procedures in a BRIN index operator class, and report an error instead of crashing (Álvaro Herrera) §","title":"Detect missing support procedures in a BRIN index operator class, and report an error instead of crashing","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["004dbbd72","af717317a","d2fb076be","d4d34c08c","e731e9d5e"],"commit_groups":[["004dbbd72","af717317a","d2fb076be","d4d34c08c","e731e9d5e"]],"commits":["e731e9d5e"],"cves":[],"db_id":"bc6275afdb9fe4237e597f5a8a0f7d1e","html":"\u003cp\u003eRespond to interrupts (such as query cancel) while waiting for asynchronous subplans of an Append plan node (Heikki Linnakangas) \u003ca href=\"https://postgr.es/c/e731e9d5e\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003ePreviously, nothing would happen until one of the subplans becomes ready.\u003c/p\u003e","id":"17.5-3b760fb385f5b7f6","identity_text":"Respond to interrupts (such as query cancel) while waiting for asynchronous subplans of an Append plan node (Heikki Linnakangas) Previously, nothing would happen until one of the subplans becomes ready.","part":"changes","patch_ids":["c064a1921c86b2d8f990d5d2c678cf3f"],"related_changes":[{"db_id":"266ac90fa5b9b2152af01edeb08fb5b7","evidence":{"patch_ids":["c064a1921c86b2d8f990d5d2c678cf3f"],"same_day":true,"statement_hash":"f35a3ca56391c5cc0085b028fe9770aec4c6158b8a3e85b4f85a689282d9f1c3"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Respond to interrupts (such as query cancel) while waiting for asynchronous subplans of an Append plan node","url":"/docs/compare/?release=16.9#16.9-43771120e2df4821","version":"16.9"},{"db_id":"f65f31a24c7b824da5419e0fce1173eb","evidence":{"patch_ids":["c064a1921c86b2d8f990d5d2c678cf3f"],"same_day":true,"statement_hash":"f35a3ca56391c5cc0085b028fe9770aec4c6158b8a3e85b4f85a689282d9f1c3"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Respond to interrupts (such as query cancel) while waiting for asynchronous subplans of an Append plan node","url":"/docs/compare/?release=15.13#15.13-e2829c92cb9c1878","version":"15.13"},{"db_id":"f96c8bb00838600eb0266dddb8c5497e","evidence":{"patch_ids":["c064a1921c86b2d8f990d5d2c678cf3f"],"same_day":true,"statement_hash":"f35a3ca56391c5cc0085b028fe9770aec4c6158b8a3e85b4f85a689282d9f1c3"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Respond to interrupts (such as query cancel) while waiting for asynchronous subplans of an Append plan node","url":"/docs/compare/?release=14.18#14.18-ebb42881c8090b7d","version":"14.18"}],"relations":[{"evidence":{"patch_ids":["c064a1921c86b2d8f990d5d2c678cf3f"],"same_day":true,"statement_hash":"f35a3ca56391c5cc0085b028fe9770aec4c6158b8a3e85b4f85a689282d9f1c3"},"rule":2,"target":"266ac90fa5b9b2152af01edeb08fb5b7","type":"equivalent"},{"evidence":{"patch_ids":["c064a1921c86b2d8f990d5d2c678cf3f"],"same_day":true,"statement_hash":"f35a3ca56391c5cc0085b028fe9770aec4c6158b8a3e85b4f85a689282d9f1c3"},"rule":2,"target":"f65f31a24c7b824da5419e0fce1173eb","type":"equivalent"},{"evidence":{"patch_ids":["c064a1921c86b2d8f990d5d2c678cf3f"],"same_day":true,"statement_hash":"f35a3ca56391c5cc0085b028fe9770aec4c6158b8a3e85b4f85a689282d9f1c3"},"rule":2,"target":"f96c8bb00838600eb0266dddb8c5497e","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["e731e9d5e"],"source_entry_id":"17.5/changes/025","source_hash":"5a4c306f5ed769a084ac7cfbbd73fb5e514e1af0fbcdff92eac4f0c162e5b6f9","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"f35a3ca56391c5cc0085b028fe9770aec4c6158b8a3e85b4f85a689282d9f1c3","text":"Respond to interrupts (such as query cancel) while waiting for asynchronous subplans of an Append plan node (Heikki Linnakangas) § Previously, nothing would happen until one of the subplans becomes ready.","title":"Respond to interrupts (such as query cancel) while waiting for asynchronous subplans of an Append plan node","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["039549d70","5cbbe70a9","e2a82cd23"],"commit_groups":[["039549d70","5cbbe70a9","e2a82cd23"]],"commits":["5cbbe70a9"],"cves":[],"db_id":"c6a8797988841f09f0c29279d25dfd35","html":"\u003cp\u003eReport the I/O statistics of active WAL senders more frequently (Bertrand Drouvot) \u003ca href=\"https://postgr.es/c/5cbbe70a9\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003ePreviously, the \u003ccode\u003epg_stat_io\u003c/code\u003e view failed to accumulate I/O performed by a WAL sender until that process exited. Now such I/O will be reported after at most one second's delay.\u003c/p\u003e","id":"17.5-cbbabe25f7f4e5fc","identity_text":"Report the I/O statistics of active WAL senders more frequently (Bertrand Drouvot) Previously, the pg_stat_io view failed to accumulate I/O performed by a WAL sender until that process exited. Now such I/O will be reported after at most one second's delay.","part":"changes","patch_ids":["bdaccba25b03ab7ba7cbed793dd7fd96"],"related_changes":[{"db_id":"ae2dee9ed8dfc12d0eacbb0ebe5a0ee9","evidence":{"patch_ids":["bdaccba25b03ab7ba7cbed793dd7fd96"],"same_day":true,"statement_hash":"e7e172475538692976735d86dc7117709ccbd2bd59cddcb8451cb30cd4894f37"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Report the I/O statistics of active WAL senders more frequently","url":"/docs/compare/?release=16.9#16.9-d302b1d61e06a034","version":"16.9"}],"relations":[{"evidence":{"patch_ids":["bdaccba25b03ab7ba7cbed793dd7fd96"],"same_day":true,"statement_hash":"e7e172475538692976735d86dc7117709ccbd2bd59cddcb8451cb30cd4894f37"},"rule":2,"target":"ae2dee9ed8dfc12d0eacbb0ebe5a0ee9","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["5cbbe70a9"],"source_entry_id":"17.5/changes/026","source_hash":"77608c5172b1ae5a2f80c7f31154ce5b83c8c000b2fe0d8828ba8fb1f46632f9","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"e7e172475538692976735d86dc7117709ccbd2bd59cddcb8451cb30cd4894f37","text":"Report the I/O statistics of active WAL senders more frequently (Bertrand Drouvot) § Previously, the pg_stat_io view failed to accumulate I/O performed by a WAL sender until that process exited. Now such I/O will be reported after at most one second's delay.","title":"Report the I/O statistics of active WAL senders more frequently","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["2e5779083","3339847cc","873aff945","c922ae2c4","e2f42f812","ec59500a1"],"commit_groups":[["2e5779083","3339847cc","873aff945","c922ae2c4","e2f42f812","ec59500a1"]],"commits":["3339847cc"],"cves":[],"db_id":"9daf50395d2f4aead8175d388ace78ce","html":"\u003cp\u003eFix race condition in handling of \u003ccode\u003esynchronous_standby_names\u003c/code\u003e immediately after startup (Melnikov Maksim, Michael Paquier) \u003ca href=\"https://postgr.es/c/3339847cc\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eFor a short period after system startup, backends might fail to wait for synchronous commit even though \u003ccode\u003esynchronous_standby_names\u003c/code\u003e is enabled.\u003c/p\u003e","id":"17.5-f91016ff67d3fd61","identity_text":"Fix race condition in handling of synchronous_standby_names immediately after startup (Melnikov Maksim, Michael Paquier) For a short period after system startup, backends might fail to wait for synchronous commit even though synchronous_standby_names is enabled.","part":"changes","patch_ids":["b2c5c57c59d2226fd83183d134c26bfb"],"related_changes":[{"db_id":"dfb958de881085e4bc9b09b3e0e8e2ad","evidence":{"patch_ids":["b2c5c57c59d2226fd83183d134c26bfb"],"same_day":true,"statement_hash":"1bff9c7be1dcaac9e45a1e59931ceb888f07976bdf3e98fa0402ce01d5069e14"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Fix race condition in handling of synchronous_standby_names immediately after startup","url":"/docs/compare/?release=16.9#16.9-e1d42624d237cb4c","version":"16.9"},{"db_id":"025a2fc043dac6b32bb98f471a1aabd7","evidence":{"patch_ids":["b2c5c57c59d2226fd83183d134c26bfb"],"same_day":true,"statement_hash":"1bff9c7be1dcaac9e45a1e59931ceb888f07976bdf3e98fa0402ce01d5069e14"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Fix race condition in handling of synchronous_standby_names immediately after startup","url":"/docs/compare/?release=15.13#15.13-bcea9256969a7e79","version":"15.13"},{"db_id":"9b50aea034b0d7075666b593cc8d7a51","evidence":{"patch_ids":["b2c5c57c59d2226fd83183d134c26bfb"],"same_day":true,"statement_hash":"1bff9c7be1dcaac9e45a1e59931ceb888f07976bdf3e98fa0402ce01d5069e14"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Fix race condition in handling of synchronous_standby_names immediately after startup","url":"/docs/compare/?release=14.18#14.18-5c3390e2c8ae7fd4","version":"14.18"},{"db_id":"f619fee730a419517f64c1c847ade820","evidence":{"patch_ids":["b2c5c57c59d2226fd83183d134c26bfb"],"same_day":true,"statement_hash":"1bff9c7be1dcaac9e45a1e59931ceb888f07976bdf3e98fa0402ce01d5069e14"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Fix race condition in handling of synchronous_standby_names immediately after startup","url":"/docs/compare/?release=13.21#13.21-3cf6ae8c0b81ee2a","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["b2c5c57c59d2226fd83183d134c26bfb"],"same_day":true,"statement_hash":"1bff9c7be1dcaac9e45a1e59931ceb888f07976bdf3e98fa0402ce01d5069e14"},"rule":2,"target":"025a2fc043dac6b32bb98f471a1aabd7","type":"equivalent"},{"evidence":{"patch_ids":["b2c5c57c59d2226fd83183d134c26bfb"],"same_day":true,"statement_hash":"1bff9c7be1dcaac9e45a1e59931ceb888f07976bdf3e98fa0402ce01d5069e14"},"rule":2,"target":"9b50aea034b0d7075666b593cc8d7a51","type":"equivalent"},{"evidence":{"patch_ids":["b2c5c57c59d2226fd83183d134c26bfb"],"same_day":true,"statement_hash":"1bff9c7be1dcaac9e45a1e59931ceb888f07976bdf3e98fa0402ce01d5069e14"},"rule":2,"target":"dfb958de881085e4bc9b09b3e0e8e2ad","type":"equivalent"},{"evidence":{"patch_ids":["b2c5c57c59d2226fd83183d134c26bfb"],"same_day":true,"statement_hash":"1bff9c7be1dcaac9e45a1e59931ceb888f07976bdf3e98fa0402ce01d5069e14"},"rule":2,"target":"f619fee730a419517f64c1c847ade820","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["3339847cc"],"source_entry_id":"17.5/changes/027","source_hash":"e8cf6745fdfa668c21ce33e911f107ca1dde5e236c879ca9c6f95556276f3e87","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"1bff9c7be1dcaac9e45a1e59931ceb888f07976bdf3e98fa0402ce01d5069e14","text":"Fix race condition in handling of synchronous_standby_names immediately after startup (Melnikov Maksim, Michael Paquier) § For a short period after system startup, backends might fail to wait for synchronous commit even though synchronous_standby_names is enabled.","title":"Fix race condition in handling of synchronous_standby_names immediately after startup","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["75da2bece","e27346807"],"commit_groups":[["75da2bece","e27346807"]],"commits":["e27346807"],"cves":[],"db_id":"0ec6f542da5cb9117e0ea17bcb4a3f26","html":"\u003cp\u003eCope with possible intra-query changes of \u003ccode\u003eio_combine_limit\u003c/code\u003e (Thomas Munro) \u003ca href=\"https://postgr.es/c/e27346807\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-7801aa547de6646c","identity_text":"Cope with possible intra-query changes of io_combine_limit (Thomas Munro)","part":"changes","patch_ids":["1525082485b8703fa2f89b52860a2d04"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["e27346807"],"source_entry_id":"17.5/changes/028","source_hash":"e36962f782e9839c442dece8b62fe7fde598d45b68a93c515c44e2bce3c15a88","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"0b929fd9f18ace427e1a09c7fb44d965d7ce028c9b15275647c50e33df7e8986","text":"Cope with possible intra-query changes of io_combine_limit (Thomas Munro) §","title":"Cope with possible intra-query changes of io_combine_limit","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["34fbfe1f5","7c82b4f71","de1484736"],"commit_groups":[["34fbfe1f5","7c82b4f71","de1484736"]],"commits":["34fbfe1f5"],"cves":[],"db_id":"fd83db271349449bd2ee6899024d9e9b","html":"\u003cp\u003eAvoid infinite loop if \u003ccode\u003escram_iterations\u003c/code\u003e is set to \u003cspan\u003eINT_MAX\u003c/span\u003e (Kevin K Biju) \u003ca href=\"https://postgr.es/c/34fbfe1f5\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-3f171945da52b986","identity_text":"Avoid infinite loop if scram_iterations is set to INT_MAX (Kevin K Biju)","part":"changes","patch_ids":["c0f8d7e4d168b551c094cdcbdf19b934"],"related_changes":[{"db_id":"364851aa8c68be771246b6cfc55e40c2","evidence":{"patch_ids":["c0f8d7e4d168b551c094cdcbdf19b934"],"same_day":true,"statement_hash":"945ae6facd593547c345aa235f3bf1e34891c2f88a1d28d6bad96424e3f822d9"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Avoid infinite loop if scram_iterations is set to INT_MAX","url":"/docs/compare/?release=16.9#16.9-620608f12dc07284","version":"16.9"}],"relations":[{"evidence":{"patch_ids":["c0f8d7e4d168b551c094cdcbdf19b934"],"same_day":true,"statement_hash":"945ae6facd593547c345aa235f3bf1e34891c2f88a1d28d6bad96424e3f822d9"},"rule":2,"target":"364851aa8c68be771246b6cfc55e40c2","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["34fbfe1f5"],"source_entry_id":"17.5/changes/029","source_hash":"8f7f4f457391afce26e9f6957dc34fb0bf054350742b1a8725c56addf566590e","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"945ae6facd593547c345aa235f3bf1e34891c2f88a1d28d6bad96424e3f822d9","text":"Avoid infinite loop if scram_iterations is set to INT_MAX (Kevin K Biju) §","title":"Avoid infinite loop if scram_iterations is set to INT_MAX","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["717e8a1e5","ca54f9b70","e33f2335a"],"commit_groups":[["717e8a1e5","ca54f9b70","e33f2335a"]],"commits":["717e8a1e5"],"cves":[],"db_id":"bf925633d6d7ef18ab00166f249e799a","html":"\u003cp\u003eAvoid possible crashes due to double transformation of \u003ccode\u003ejson_array()\u003c/code\u003e's subquery (Tom Lane) \u003ca href=\"https://postgr.es/c/717e8a1e5\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-b514267485be5146","identity_text":"Avoid possible crashes due to double transformation of json_array()'s subquery (Tom Lane)","part":"changes","patch_ids":["eb010ef2e4458e606c1119a25a5a2267"],"related_changes":[{"db_id":"56ec9ed6dc4ab869b00615c0c007122f","evidence":{"patch_ids":["eb010ef2e4458e606c1119a25a5a2267"],"same_day":true,"statement_hash":"742ef4d824ddafe968a93a312648fba638d1a2b3a7734b138151cb886648836d"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Avoid possible crashes due to double transformation of json_array()'s subquery","url":"/docs/compare/?release=16.9#16.9-77b663f616c56781","version":"16.9"}],"relations":[{"evidence":{"patch_ids":["eb010ef2e4458e606c1119a25a5a2267"],"same_day":true,"statement_hash":"742ef4d824ddafe968a93a312648fba638d1a2b3a7734b138151cb886648836d"},"rule":2,"target":"56ec9ed6dc4ab869b00615c0c007122f","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["717e8a1e5"],"source_entry_id":"17.5/changes/030","source_hash":"30992705ab717e379e2d217f31331da63b899c8302043bfb5e0f9a7c5862dbfd","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"742ef4d824ddafe968a93a312648fba638d1a2b3a7734b138151cb886648836d","text":"Avoid possible crashes due to double transformation of json_array()'s subquery (Tom Lane) §","title":"Avoid possible crashes due to double transformation of json_array()'s subquery","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["00d61a08c","5c64ece8a","76fbb38ef","c7303f01c","d69c78108","ebe919e95"],"commit_groups":[["00d61a08c","5c64ece8a","76fbb38ef","c7303f01c","d69c78108","ebe919e95"]],"commits":["d69c78108"],"cves":[],"db_id":"c50ce57a6db50401acd8695788584541","html":"\u003cp\u003eFix \u003ccode\u003epg_strtof()\u003c/code\u003e to not crash with null endptr (Alexander Lakhin, Tom Lane) \u003ca href=\"https://postgr.es/c/d69c78108\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-8e29d20712a0fb85","identity_text":"Fix pg_strtof() to not crash with null endptr (Alexander Lakhin, Tom Lane)","part":"changes","patch_ids":["cf60307fd4303d87ba2e2b826fe85843"],"related_changes":[{"db_id":"7f2b718202a5a9c141d5f9543c3d8422","evidence":{"patch_ids":["cf60307fd4303d87ba2e2b826fe85843"],"same_day":true,"statement_hash":"6f00ddb45ac2f0ee4d0f0c3be7297735b4cbfce76dda50a1e9284695b618f980"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Fix pg_strtof() to not crash with null endptr","url":"/docs/compare/?release=16.9#16.9-9cb2e21ff3e54366","version":"16.9"},{"db_id":"5a9fac352de1c6dc8c61e9196414a07f","evidence":{"patch_ids":["cf60307fd4303d87ba2e2b826fe85843"],"same_day":true,"statement_hash":"6f00ddb45ac2f0ee4d0f0c3be7297735b4cbfce76dda50a1e9284695b618f980"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Fix pg_strtof() to not crash with null endptr","url":"/docs/compare/?release=15.13#15.13-3832bc9bcdef8ae6","version":"15.13"},{"db_id":"291c1b10af654d11c4f58eca3ba7f03a","evidence":{"patch_ids":["cf60307fd4303d87ba2e2b826fe85843"],"same_day":true,"statement_hash":"6f00ddb45ac2f0ee4d0f0c3be7297735b4cbfce76dda50a1e9284695b618f980"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Fix pg_strtof() to not crash with null endptr","url":"/docs/compare/?release=14.18#14.18-faecb4df8b710ad1","version":"14.18"},{"db_id":"ccd517602e74f9b689358e51afeece0f","evidence":{"patch_ids":["cf60307fd4303d87ba2e2b826fe85843"],"same_day":true,"statement_hash":"6f00ddb45ac2f0ee4d0f0c3be7297735b4cbfce76dda50a1e9284695b618f980"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Fix pg_strtof() to not crash with null endptr","url":"/docs/compare/?release=13.21#13.21-7c56dbb1dfbb40f8","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["cf60307fd4303d87ba2e2b826fe85843"],"same_day":true,"statement_hash":"6f00ddb45ac2f0ee4d0f0c3be7297735b4cbfce76dda50a1e9284695b618f980"},"rule":2,"target":"291c1b10af654d11c4f58eca3ba7f03a","type":"equivalent"},{"evidence":{"patch_ids":["cf60307fd4303d87ba2e2b826fe85843"],"same_day":true,"statement_hash":"6f00ddb45ac2f0ee4d0f0c3be7297735b4cbfce76dda50a1e9284695b618f980"},"rule":2,"target":"5a9fac352de1c6dc8c61e9196414a07f","type":"equivalent"},{"evidence":{"patch_ids":["cf60307fd4303d87ba2e2b826fe85843"],"same_day":true,"statement_hash":"6f00ddb45ac2f0ee4d0f0c3be7297735b4cbfce76dda50a1e9284695b618f980"},"rule":2,"target":"7f2b718202a5a9c141d5f9543c3d8422","type":"equivalent"},{"evidence":{"patch_ids":["cf60307fd4303d87ba2e2b826fe85843"],"same_day":true,"statement_hash":"6f00ddb45ac2f0ee4d0f0c3be7297735b4cbfce76dda50a1e9284695b618f980"},"rule":2,"target":"ccd517602e74f9b689358e51afeece0f","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["d69c78108"],"source_entry_id":"17.5/changes/031","source_hash":"06f8d809b8e81658e66f614ba9a2131742fa4c039bc8454ed3231b25d4d2d223","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"6f00ddb45ac2f0ee4d0f0c3be7297735b4cbfce76dda50a1e9284695b618f980","text":"Fix pg_strtof() to not crash with null endptr (Alexander Lakhin, Tom Lane) §","title":"Fix pg_strtof() to not crash with null endptr","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["058b5152f","8afec4ef6","8d48e84c5"],"commit_groups":[["058b5152f","8afec4ef6","8d48e84c5"]],"commits":["8afec4ef6"],"cves":[],"db_id":"23ab01db1072a15e27055e650563ed70","html":"\u003cp\u003eFix crash after out-of-memory in certain GUC assignments (Daniel Gustafsson) \u003ca href=\"https://postgr.es/c/8afec4ef6\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-9e7394eed41b4e55","identity_text":"Fix crash after out-of-memory in certain GUC assignments (Daniel Gustafsson)","part":"changes","patch_ids":["b961dd64c1458fef941542b2e8a23e07"],"related_changes":[{"db_id":"c6f996699b4b5ce09633d8bc53e3e8c3","evidence":{"patch_ids":["b961dd64c1458fef941542b2e8a23e07"],"same_day":true,"statement_hash":"9cd377fdfeddf7651326fcb6374f6a13ae7cef4cceb4a82af30847a078caf330"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Fix crash after out-of-memory in certain GUC assignments","url":"/docs/compare/?release=16.9#16.9-2747f0582bb26746","version":"16.9"}],"relations":[{"evidence":{"patch_ids":["b961dd64c1458fef941542b2e8a23e07"],"same_day":true,"statement_hash":"9cd377fdfeddf7651326fcb6374f6a13ae7cef4cceb4a82af30847a078caf330"},"rule":2,"target":"c6f996699b4b5ce09633d8bc53e3e8c3","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["8afec4ef6"],"source_entry_id":"17.5/changes/032","source_hash":"03e4f63f99f6de6e481027a5b40271b70f812faf05bb9917546fb1e3ebdce37f","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"9cd377fdfeddf7651326fcb6374f6a13ae7cef4cceb4a82af30847a078caf330","text":"Fix crash after out-of-memory in certain GUC assignments (Daniel Gustafsson) §","title":"Fix crash after out-of-memory in certain GUC assignments","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["197427fb3","7edd2cbc5","8388cae55","9c46d902b","b464e51ab","c0c364fa1"],"commit_groups":[["197427fb3","7edd2cbc5","8388cae55","9c46d902b","b464e51ab","c0c364fa1"]],"commits":["7edd2cbc5"],"cves":[],"db_id":"fe6fa87c7f7a2f01e5226fc8b75d4395","html":"\u003cp\u003eAvoid crash when a Snowball stemmer encounters an out-of-memory condition (Maksim Korotkov) \u003ca href=\"https://postgr.es/c/7edd2cbc5\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-88fad50b7b3b2e15","identity_text":"Avoid crash when a Snowball stemmer encounters an out-of-memory condition (Maksim Korotkov)","part":"changes","patch_ids":["d20fbffc83ee90d1348f1d03836b8f18"],"related_changes":[{"db_id":"d02c90e2590d4a47f73a5782496b4966","evidence":{"patch_ids":["d20fbffc83ee90d1348f1d03836b8f18"],"same_day":false},"kind":"related","label":"18.0","source_url":"/docs/release/18.0/#RELEASE-18-DATATYPES","title":"Add full text search stemming for Estonian","url":"/docs/compare/?release=18.0#18.0-5f1391509757dd6d","version":"18.0"},{"db_id":"c2850458f2850974df366bef8a85488e","evidence":{"patch_ids":["d20fbffc83ee90d1348f1d03836b8f18"],"same_day":true,"statement_hash":"6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Avoid crash when a Snowball stemmer encounters an out-of-memory condition","url":"/docs/compare/?release=16.9#16.9-71f38ed0f1b64f88","version":"16.9"},{"db_id":"00feddbb8384a7a8cefe4217cd497215","evidence":{"patch_ids":["d20fbffc83ee90d1348f1d03836b8f18"],"same_day":true,"statement_hash":"6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Avoid crash when a Snowball stemmer encounters an out-of-memory condition","url":"/docs/compare/?release=15.13#15.13-6fa1c30b53ef4a7a","version":"15.13"},{"db_id":"d6bf0f560b8ac8cad3c1d6a070b45594","evidence":{"patch_ids":["d20fbffc83ee90d1348f1d03836b8f18"],"same_day":true,"statement_hash":"6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Avoid crash when a Snowball stemmer encounters an out-of-memory condition","url":"/docs/compare/?release=14.18#14.18-813abffbc8584526","version":"14.18"},{"db_id":"43dbc69a435522e8a12bbf37193bcbca","evidence":{"patch_ids":["d20fbffc83ee90d1348f1d03836b8f18"],"same_day":true,"statement_hash":"6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Avoid crash when a Snowball stemmer encounters an out-of-memory condition","url":"/docs/compare/?release=13.21#13.21-7de382d5402e6e82","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["d20fbffc83ee90d1348f1d03836b8f18"],"same_day":true,"statement_hash":"6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5"},"rule":2,"target":"00feddbb8384a7a8cefe4217cd497215","type":"equivalent"},{"evidence":{"patch_ids":["d20fbffc83ee90d1348f1d03836b8f18"],"same_day":true,"statement_hash":"6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5"},"rule":2,"target":"43dbc69a435522e8a12bbf37193bcbca","type":"equivalent"},{"evidence":{"patch_ids":["d20fbffc83ee90d1348f1d03836b8f18"],"same_day":true,"statement_hash":"6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5"},"rule":2,"target":"c2850458f2850974df366bef8a85488e","type":"equivalent"},{"evidence":{"patch_ids":["d20fbffc83ee90d1348f1d03836b8f18"],"same_day":false},"rule":2,"target":"d02c90e2590d4a47f73a5782496b4966","type":"related"},{"evidence":{"patch_ids":["d20fbffc83ee90d1348f1d03836b8f18"],"same_day":true,"statement_hash":"6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5"},"rule":2,"target":"d6bf0f560b8ac8cad3c1d6a070b45594","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["7edd2cbc5"],"source_entry_id":"17.5/changes/033","source_hash":"863a6d6b30d6296b5cc226db53c7adb643459be9731c11a3ceadfee06537e461","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"6c8d8c6f1cd71c3e595998d2cabe403f95a5078a14911e8bf0245a28e047a7c5","text":"Avoid crash when a Snowball stemmer encounters an out-of-memory condition (Maksim Korotkov) §","title":"Avoid crash when a Snowball stemmer encounters an out-of-memory condition","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["727bc6ac3","c39392eba"],"commit_groups":[["727bc6ac3","c39392eba"]],"commits":["727bc6ac3"],"cves":[],"db_id":"ebdda7e082e30154b83d9936a391bd88","html":"\u003cp\u003eFix over-enthusiastic freeing of SpecialJoinInfo structs during planning (Richard Guo) \u003ca href=\"https://postgr.es/c/727bc6ac3\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThis led to crashes during planning if partitionwise joining is enabled.\u003c/p\u003e","id":"17.5-7710d321654aba90","identity_text":"Fix over-enthusiastic freeing of SpecialJoinInfo structs during planning (Richard Guo) This led to crashes during planning if partitionwise joining is enabled.","part":"changes","patch_ids":["42ec8138b2a25ccf518470e4df4202b0"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["727bc6ac3"],"source_entry_id":"17.5/changes/034","source_hash":"67f2fd66d17d12bc0127432dc4a1ee621254e71141bab1304f4bcbe4ee5b0445","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"15ded82f73c70eec7feb88b753b5810fd5a76ddd53da757ee29f9cbb1203e6e1","text":"Fix over-enthusiastic freeing of SpecialJoinInfo structs during planning (Richard Guo) § This led to crashes during planning if partitionwise joining is enabled.","title":"Fix over-enthusiastic freeing of SpecialJoinInfo structs during planning","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["87e8599e0","a4309e85f","fd09c1316"],"commit_groups":[["87e8599e0","a4309e85f","fd09c1316"]],"commits":["a4309e85f"],"cves":[],"db_id":"25b777c14569e1cb00949eac804f9143","html":"\u003cp\u003eDisallow copying of invalidated replication slots (Shlok Kyal) \u003ca href=\"https://postgr.es/c/a4309e85f\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThis prevents trouble when the invalid slot points to WAL that's already been removed.\u003c/p\u003e","id":"17.5-329d6dcb7a52243f","identity_text":"Disallow copying of invalidated replication slots (Shlok Kyal) This prevents trouble when the invalid slot points to WAL that's already been removed.","part":"changes","patch_ids":["69ebb07e5bcd7b2d9d9bfa4f1d54662d"],"related_changes":[{"db_id":"0c8d1ecbb6aae9ff0d34325d9b83d568","evidence":{"patch_ids":["69ebb07e5bcd7b2d9d9bfa4f1d54662d"],"same_day":true,"statement_hash":"9d0ca5ad3289b329470f78c6ea4f4c49eb5ca655ffe9bef3b6a98b1a0e87484f"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Disallow copying of invalidated replication slots","url":"/docs/compare/?release=16.9#16.9-80b936166da650b8","version":"16.9"}],"relations":[{"evidence":{"patch_ids":["69ebb07e5bcd7b2d9d9bfa4f1d54662d"],"same_day":true,"statement_hash":"9d0ca5ad3289b329470f78c6ea4f4c49eb5ca655ffe9bef3b6a98b1a0e87484f"},"rule":2,"target":"0c8d1ecbb6aae9ff0d34325d9b83d568","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["a4309e85f"],"source_entry_id":"17.5/changes/035","source_hash":"90fba1c2bb06ca3edc0ddf0131e65964d8004b1f6a4695f42c1733ffc84c3355","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"9d0ca5ad3289b329470f78c6ea4f4c49eb5ca655ffe9bef3b6a98b1a0e87484f","text":"Disallow copying of invalidated replication slots (Shlok Kyal) § This prevents trouble when the invalid slot points to WAL that's already been removed.","title":"Disallow copying of invalidated replication slots","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["174952ece","48796a98d","cc628f661"],"commit_groups":[["174952ece","48796a98d","cc628f661"]],"commits":["174952ece"],"cves":[],"db_id":"c06de49303a4c6fd14a3ebfcad60b460","html":"\u003cp\u003eDisallow restoring logical replication slots on standby servers that are not in hot-standby mode (Masahiko Sawada) \u003ca href=\"https://postgr.es/c/174952ece\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThis prevents a scenario where the slot could remain valid after promotion even if \u003ccode\u003ewal_level\u003c/code\u003e is too low.\u003c/p\u003e","id":"17.5-d0e83697be29c629","identity_text":"Disallow restoring logical replication slots on standby servers that are not in hot-standby mode (Masahiko Sawada) This prevents a scenario where the slot could remain valid after promotion even if wal_level is too low.","part":"changes","patch_ids":["d009a8193192a9656ba9d52c14536f2c"],"related_changes":[{"db_id":"c0d6d9bba3854572f15633401bb427a9","evidence":{"patch_ids":["d009a8193192a9656ba9d52c14536f2c"],"same_day":true,"statement_hash":"b36cf74a9c1046069cdebf9c23f7250189b432d674d47be3d6145a44fffad35e"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Disallow restoring logical replication slots on standby servers that are not in hot-standby mode","url":"/docs/compare/?release=16.9#16.9-ef0155b0291bc435","version":"16.9"}],"relations":[{"evidence":{"patch_ids":["d009a8193192a9656ba9d52c14536f2c"],"same_day":true,"statement_hash":"b36cf74a9c1046069cdebf9c23f7250189b432d674d47be3d6145a44fffad35e"},"rule":2,"target":"c0d6d9bba3854572f15633401bb427a9","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["174952ece"],"source_entry_id":"17.5/changes/036","source_hash":"8d1283c3d162832ab66b516b9d886e8deeebb52a9520e2df8d06d1340f6f29aa","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"b36cf74a9c1046069cdebf9c23f7250189b432d674d47be3d6145a44fffad35e","text":"Disallow restoring logical replication slots on standby servers that are not in hot-standby mode (Masahiko Sawada) § This prevents a scenario where the slot could remain valid after promotion even if wal_level is too low.","title":"Disallow restoring logical replication slots on standby servers that are not in hot-standby mode","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["1f63b3626","21a7caeeb","36148b22e","aaf9e95e8","d65485b02","f6429bd7d"],"commit_groups":[["1f63b3626","21a7caeeb","36148b22e","aaf9e95e8","d65485b02","f6429bd7d"]],"commits":["36148b22e"],"cves":[],"db_id":"db9ffe506fd9139225111a635c8cd253","html":"\u003cp\u003ePrevent over-advancement of catalog xmin in \u003cspan\u003e“\u003cspan\u003efast forward\u003c/span\u003e”\u003c/span\u003e mode of logical decoding (Zhijie Hou) \u003ca href=\"https://postgr.es/c/36148b22e\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThis mistake could allow deleted catalog entries to be vacuumed away even though they were still potentially needed by the WAL-reading process.\u003c/p\u003e","id":"17.5-2bb0e54648533251","identity_text":"Prevent over-advancement of catalog xmin in fast forward mode of logical decoding (Zhijie Hou) This mistake could allow deleted catalog entries to be vacuumed away even though they were still potentially needed by the WAL-reading process.","part":"changes","patch_ids":["c6475433b3466d0d333287697a22d76c"],"related_changes":[{"db_id":"ddf70cdfdcf26f0a407827ed50eeab10","evidence":{"patch_ids":["c6475433b3466d0d333287697a22d76c"],"same_day":true,"statement_hash":"31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Prevent over-advancement of catalog xmin in “fast forward” mode of logical decoding","url":"/docs/compare/?release=16.9#16.9-c9dae01c18776f9c","version":"16.9"},{"db_id":"cfae289c787a92c54518341586bfbe9a","evidence":{"patch_ids":["c6475433b3466d0d333287697a22d76c"],"same_day":true,"statement_hash":"31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Prevent over-advancement of catalog xmin in “fast forward” mode of logical decoding","url":"/docs/compare/?release=15.13#15.13-bb45c4bf697c7ebc","version":"15.13"},{"db_id":"3ab082e1dcff51c82a077f2f62e6407c","evidence":{"patch_ids":["c6475433b3466d0d333287697a22d76c"],"same_day":true,"statement_hash":"31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Prevent over-advancement of catalog xmin in “fast forward” mode of logical decoding","url":"/docs/compare/?release=14.18#14.18-bec28c31b4951bab","version":"14.18"},{"db_id":"57b3f47815396fdd9a70a193be305bf1","evidence":{"patch_ids":["c6475433b3466d0d333287697a22d76c"],"same_day":true,"statement_hash":"31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Prevent over-advancement of catalog xmin in “fast forward” mode of logical decoding","url":"/docs/compare/?release=13.21#13.21-0d96e68077e9aca8","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["c6475433b3466d0d333287697a22d76c"],"same_day":true,"statement_hash":"31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a"},"rule":2,"target":"3ab082e1dcff51c82a077f2f62e6407c","type":"equivalent"},{"evidence":{"patch_ids":["c6475433b3466d0d333287697a22d76c"],"same_day":true,"statement_hash":"31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a"},"rule":2,"target":"57b3f47815396fdd9a70a193be305bf1","type":"equivalent"},{"evidence":{"patch_ids":["c6475433b3466d0d333287697a22d76c"],"same_day":true,"statement_hash":"31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a"},"rule":2,"target":"cfae289c787a92c54518341586bfbe9a","type":"equivalent"},{"evidence":{"patch_ids":["c6475433b3466d0d333287697a22d76c"],"same_day":true,"statement_hash":"31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a"},"rule":2,"target":"ddf70cdfdcf26f0a407827ed50eeab10","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["36148b22e"],"source_entry_id":"17.5/changes/037","source_hash":"f4bf34acb275b131516221a7e9876ac9db8182e152764c449b6c329ee9bc81f4","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"31124da856306a5fd3e362458ee2fb654f10aae3d57980427c12efefa655eb2a","text":"Prevent over-advancement of catalog xmin in “fast forward” mode of logical decoding (Zhijie Hou) § This mistake could allow deleted catalog entries to be vacuumed away even though they were still potentially needed by the WAL-reading process.","title":"Prevent over-advancement of catalog xmin in “fast forward” mode of logical decoding","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["0434033e8","247ee9415","4164d6976","4909b38af","50b8ad30f","90bc4523f","9987c9466","9a2f8b4f0","9f21be08e","bb1bc9fa9","cadaf0ac4","d96206f25"],"commit_groups":[["0434033e8","247ee9415","4909b38af","9a2f8b4f0","9f21be08e","cadaf0ac4"],["4164d6976","50b8ad30f","90bc4523f","9987c9466","bb1bc9fa9","d96206f25"]],"commits":["cadaf0ac4","d96206f25"],"cves":[],"db_id":"8e6377590f7704ee937288d5751d0fe8","html":"\u003cp\u003eAvoid data loss when DDL operations that don't take a strong lock affect tables that are being logically replicated (Shlok Kyal, Hayato Kuroda) \u003ca href=\"https://postgr.es/c/cadaf0ac4\"\u003e§\u003c/a\u003e \u003ca href=\"https://postgr.es/c/d96206f25\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThe catalog changes caused by the DDL command were not reflected into WAL-decoding processes, allowing them to decode subsequent changes using stale catalog data, probably resulting in data corruption.\u003c/p\u003e","id":"17.5-e21de69a327984e5","identity_text":"Avoid data loss when DDL operations that don't take a strong lock affect tables that are being logically replicated (Shlok Kyal, Hayato Kuroda) The catalog changes caused by the DDL command were not reflected into WAL-decoding processes, allowing them to decode subsequent changes using stale catalog data, probably resulting in data corruption.","part":"changes","patch_ids":["3b9707f5e94616c6b08bba7b727d1833","7aa92ec4c1375172371c770fad1e069d"],"related_changes":[{"db_id":"db54a729c489a33329efd16078c5f632","evidence":{"patch_ids":["3b9707f5e94616c6b08bba7b727d1833","7aa92ec4c1375172371c770fad1e069d"],"same_day":true,"statement_hash":"5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Avoid data loss when DDL operations that don't take a strong lock affect tables that are being logically replicated","url":"/docs/compare/?release=16.9#16.9-99af33434b873ed3","version":"16.9"},{"db_id":"19e936ef0715c52fd027234b084245a4","evidence":{"patch_ids":["3b9707f5e94616c6b08bba7b727d1833","7aa92ec4c1375172371c770fad1e069d"],"same_day":true,"statement_hash":"5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Avoid data loss when DDL operations that don't take a strong lock affect tables that are being logically replicated","url":"/docs/compare/?release=15.13#15.13-2f66029919c20aba","version":"15.13"},{"db_id":"f2d1d9e7b4a609d7869646462b740f14","evidence":{"patch_ids":["3b9707f5e94616c6b08bba7b727d1833","7aa92ec4c1375172371c770fad1e069d"],"same_day":true,"statement_hash":"5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Avoid data loss when DDL operations that don't take a strong lock affect tables that are being logically replicated","url":"/docs/compare/?release=14.18#14.18-f53a16ec53117501","version":"14.18"},{"db_id":"ee4a2645d0b3d70cbf64253af5bf4bbd","evidence":{"patch_ids":["3b9707f5e94616c6b08bba7b727d1833","7aa92ec4c1375172371c770fad1e069d"],"same_day":true,"statement_hash":"5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Avoid data loss when DDL operations that don't take a strong lock affect tables that are being logically replicated","url":"/docs/compare/?release=13.21#13.21-c43037ec57336487","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["3b9707f5e94616c6b08bba7b727d1833","7aa92ec4c1375172371c770fad1e069d"],"same_day":true,"statement_hash":"5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a"},"rule":2,"target":"19e936ef0715c52fd027234b084245a4","type":"equivalent"},{"evidence":{"patch_ids":["3b9707f5e94616c6b08bba7b727d1833","7aa92ec4c1375172371c770fad1e069d"],"same_day":true,"statement_hash":"5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a"},"rule":2,"target":"db54a729c489a33329efd16078c5f632","type":"equivalent"},{"evidence":{"patch_ids":["3b9707f5e94616c6b08bba7b727d1833","7aa92ec4c1375172371c770fad1e069d"],"same_day":true,"statement_hash":"5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a"},"rule":2,"target":"ee4a2645d0b3d70cbf64253af5bf4bbd","type":"equivalent"},{"evidence":{"patch_ids":["3b9707f5e94616c6b08bba7b727d1833","7aa92ec4c1375172371c770fad1e069d"],"same_day":true,"statement_hash":"5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a"},"rule":2,"target":"f2d1d9e7b4a609d7869646462b740f14","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["cadaf0ac4","d96206f25"],"source_entry_id":"17.5/changes/038","source_hash":"859430c59211b2c40bad258ebf9a0117a784bbddbd35b1aa58d382c0c5acd03c","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"5087b6eeaa58053beb4e5956f3a1760c3fdcd576933d1be27f37a897f9b40e9a","text":"Avoid data loss when DDL operations that don't take a strong lock affect tables that are being logically replicated (Shlok Kyal, Hayato Kuroda) § § The catalog changes caused by the DDL command were not reflected into WAL-decoding processes, allowing them to decode subsequent changes using stale catalog data, probably resulting in data corruption.","title":"Avoid data loss when DDL operations that don't take a strong lock affect tables that are being logically replicated","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["05676d87e","0de091a4b","0e091ce40"],"commit_groups":[["05676d87e","0de091a4b","0e091ce40"]],"commits":["05676d87e"],"cves":[],"db_id":"97fc95fe95eed695a9fba5b146e4972e","html":"\u003cp\u003ePrevent incorrect reset of replication origin when an apply worker encounters an error but the error is caught and does not result in worker exit (Hayato Kuroda) \u003ca href=\"https://postgr.es/c/05676d87e\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThis mistake could allow duplicate data to be applied.\u003c/p\u003e","id":"17.5-76d7d613d8c9d02f","identity_text":"Prevent incorrect reset of replication origin when an apply worker encounters an error but the error is caught and does not result in worker exit (Hayato Kuroda) This mistake could allow duplicate data to be applied.","part":"changes","patch_ids":["3f57aa19ed6dd957d617a77afd66ca76"],"related_changes":[{"db_id":"c8feb35ceaa7026c93c8c635b74fe68a","evidence":{"patch_ids":["3f57aa19ed6dd957d617a77afd66ca76"],"same_day":true,"statement_hash":"34fb209a9078179d510b0d8ddd2899638bfb64344ca3c532392dcbafdf15fe64"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Prevent incorrect reset of replication origin when an apply worker encounters an error but the error is caught and does not result in worker exit","url":"/docs/compare/?release=16.9#16.9-4269b86b0113c792","version":"16.9"}],"relations":[{"evidence":{"patch_ids":["3f57aa19ed6dd957d617a77afd66ca76"],"same_day":true,"statement_hash":"34fb209a9078179d510b0d8ddd2899638bfb64344ca3c532392dcbafdf15fe64"},"rule":2,"target":"c8feb35ceaa7026c93c8c635b74fe68a","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["05676d87e"],"source_entry_id":"17.5/changes/039","source_hash":"ebab63d5309df5859384f55a3a70385705d9503e7d28d057b679d7b2920df907","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"34fb209a9078179d510b0d8ddd2899638bfb64344ca3c532392dcbafdf15fe64","text":"Prevent incorrect reset of replication origin when an apply worker encounters an error but the error is caught and does not result in worker exit (Hayato Kuroda) § This mistake could allow duplicate data to be applied.","title":"Prevent incorrect reset of replication origin when an apply worker encounters an error but the error is caught and does not result in worker exit","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["788baa9a2","9ff68679b"],"commit_groups":[["788baa9a2","9ff68679b"]],"commits":["788baa9a2"],"cves":[],"db_id":"4437e7e953c6617616f898acb66311be","html":"\u003cp\u003eFix crash in logical replication if the subscriber's partitioned table has a BRIN index (Tom Lane) \u003ca href=\"https://postgr.es/c/788baa9a2\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-695e58875a412993","identity_text":"Fix crash in logical replication if the subscriber's partitioned table has a BRIN index (Tom Lane)","part":"changes","patch_ids":["a275b46b93cee650f3a78dd55b93f1bd"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["788baa9a2"],"source_entry_id":"17.5/changes/040","source_hash":"d84fdf9b85f2349cdb4e77f44a430312497a3ac5a7fb01d59a901f52ad50266c","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"25566aca909c4ee454884d933f692e4c902ba99d38c37468b2f76c8f9ed1a85d","text":"Fix crash in logical replication if the subscriber's partitioned table has a BRIN index (Tom Lane) §","title":"Fix crash in logical replication if the subscriber's partitioned table has a BRIN index","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["136e68b46","236750317","2ef048855","324e0b656","50c589992","6c1e79589","8171d2dae","9b3914f18","c1dd3a944","d765226cb","f1ef111a0","f7c566a1a"],"commit_groups":[["136e68b46","324e0b656","6c1e79589","d765226cb","f1ef111a0","f7c566a1a"],["236750317","2ef048855","50c589992","8171d2dae","9b3914f18","c1dd3a944"]],"commits":["c1dd3a944","f1ef111a0"],"cves":[],"db_id":"68a6f444e2dd1111866e1692a09eaee9","html":"\u003cp\u003eAvoid duplicate snapshot creation in logical replication index lookups (Heikki Linnakangas) \u003ca href=\"https://postgr.es/c/c1dd3a944\"\u003e§\u003c/a\u003e \u003ca href=\"https://postgr.es/c/f1ef111a0\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-2069efadcbfce474","identity_text":"Avoid duplicate snapshot creation in logical replication index lookups (Heikki Linnakangas)","part":"changes","patch_ids":["1adc95ac621663bc7fa51f18ad33a68d","809047aed79be0ed50900ccbf42f80fa"],"related_changes":[{"db_id":"c4856066739f35020574380d1ebe619e","evidence":{"patch_ids":["1adc95ac621663bc7fa51f18ad33a68d","809047aed79be0ed50900ccbf42f80fa"],"same_day":true,"statement_hash":"16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Avoid duplicate snapshot creation in logical replication index lookups","url":"/docs/compare/?release=16.9#16.9-844f220134ec081b","version":"16.9"},{"db_id":"4cbd410dcacccd81b5e565436db7bc7a","evidence":{"patch_ids":["1adc95ac621663bc7fa51f18ad33a68d","809047aed79be0ed50900ccbf42f80fa"],"same_day":true,"statement_hash":"16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Avoid duplicate snapshot creation in logical replication index lookups","url":"/docs/compare/?release=15.13#15.13-a7ab6f2ad8ceed1e","version":"15.13"},{"db_id":"62d7ad831c6b591f2d8c9f0a041d221b","evidence":{"patch_ids":["1adc95ac621663bc7fa51f18ad33a68d","809047aed79be0ed50900ccbf42f80fa"],"same_day":true,"statement_hash":"16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Avoid duplicate snapshot creation in logical replication index lookups","url":"/docs/compare/?release=14.18#14.18-8a94534beb8d394b","version":"14.18"},{"db_id":"27c56fefd26a3de8d757bbd085e3ccf7","evidence":{"patch_ids":["1adc95ac621663bc7fa51f18ad33a68d","809047aed79be0ed50900ccbf42f80fa"],"same_day":true,"statement_hash":"16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Avoid duplicate snapshot creation in logical replication index lookups","url":"/docs/compare/?release=13.21#13.21-b909fdf92799340c","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["1adc95ac621663bc7fa51f18ad33a68d","809047aed79be0ed50900ccbf42f80fa"],"same_day":true,"statement_hash":"16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9"},"rule":2,"target":"27c56fefd26a3de8d757bbd085e3ccf7","type":"equivalent"},{"evidence":{"patch_ids":["1adc95ac621663bc7fa51f18ad33a68d","809047aed79be0ed50900ccbf42f80fa"],"same_day":true,"statement_hash":"16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9"},"rule":2,"target":"4cbd410dcacccd81b5e565436db7bc7a","type":"equivalent"},{"evidence":{"patch_ids":["1adc95ac621663bc7fa51f18ad33a68d","809047aed79be0ed50900ccbf42f80fa"],"same_day":true,"statement_hash":"16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9"},"rule":2,"target":"62d7ad831c6b591f2d8c9f0a041d221b","type":"equivalent"},{"evidence":{"patch_ids":["1adc95ac621663bc7fa51f18ad33a68d","809047aed79be0ed50900ccbf42f80fa"],"same_day":true,"statement_hash":"16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9"},"rule":2,"target":"c4856066739f35020574380d1ebe619e","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["c1dd3a944","f1ef111a0"],"source_entry_id":"17.5/changes/041","source_hash":"90d0201eb3e09e67418e69ae62d6919644033c126b99c25ef89c740adc02a9a4","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"16fba735d9e2dacfd355019baedc5bac39309c551378ee63052a10c4debdade9","text":"Avoid duplicate snapshot creation in logical replication index lookups (Heikki Linnakangas) § §","title":"Avoid duplicate snapshot creation in logical replication index lookups","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["0ae1245e0","1c2a2354c","b4e0d0c53"],"commit_groups":[["0ae1245e0","1c2a2354c","b4e0d0c53"]],"commits":["0ae1245e0"],"cves":[],"db_id":"44f32c590db44e0e093238175b097e5c","html":"\u003cp\u003eImprove detection of mixed-origin subscriptions (Hou Zhijie, Shlok Kyal) \u003ca href=\"https://postgr.es/c/0ae1245e0\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eSubscription creation gives a warning if a subscribed-to table is also being followed through other publications, since that could cause duplicate data to be received. This change improves that logic to also detect cases where a partition parent or child table is the one being followed through another publication.\u003c/p\u003e","id":"17.5-35844b784dd5bae0","identity_text":"Improve detection of mixed-origin subscriptions (Hou Zhijie, Shlok Kyal) Subscription creation gives a warning if a subscribed-to table is also being followed through other publications, since that could cause duplicate data to be received. This change improves that logic to also detect cases where a partition parent or child table is the one being followed through another publication.","part":"changes","patch_ids":["a9dcfd6c5ab2c0d0072c9c34d19ba607"],"related_changes":[{"db_id":"9f81f44ae53fd35d2b6ab6323f017683","evidence":{"patch_ids":["a9dcfd6c5ab2c0d0072c9c34d19ba607"],"same_day":true,"statement_hash":"a8411c07b850b1506fee93c6db5a926461b099a56d515bc2a262b9bfde26492b"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Improve detection of mixed-origin subscriptions","url":"/docs/compare/?release=16.9#16.9-5ae54dbf9fc83b1d","version":"16.9"}],"relations":[{"evidence":{"patch_ids":["a9dcfd6c5ab2c0d0072c9c34d19ba607"],"same_day":true,"statement_hash":"a8411c07b850b1506fee93c6db5a926461b099a56d515bc2a262b9bfde26492b"},"rule":2,"target":"9f81f44ae53fd35d2b6ab6323f017683","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["0ae1245e0"],"source_entry_id":"17.5/changes/042","source_hash":"1ecc4b6db4538add2189b14996b49c502d9677d4d0c8471c2ade7da1e67ba5a0","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"a8411c07b850b1506fee93c6db5a926461b099a56d515bc2a262b9bfde26492b","text":"Improve detection of mixed-origin subscriptions (Hou Zhijie, Shlok Kyal) § Subscription creation gives a warning if a subscribed-to table is also being followed through other publications, since that could cause duplicate data to be received. This change improves that logic to also detect cases where a partition parent or child table is the one being followed through another publication.","title":"Improve detection of mixed-origin subscriptions","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["29cce279b","62bed7bb0","71f17823b","b4969a296"],"commit_groups":[["29cce279b","62bed7bb0","71f17823b","b4969a296"]],"commits":["29cce279b"],"cves":[],"db_id":"a246338555d823bc8f689670b84ea7a0","html":"\u003cp\u003eFix wrong checkpoint details in error message about incorrect recovery timeline choice (David Steele) \u003ca href=\"https://postgr.es/c/29cce279b\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eIf the requested recovery timeline is not reachable, the reported checkpoint and timeline should be the values read from the backup_label, if there is one. This message previously reported values from the control file, which is correct when recovering from the control file without a backup_label, but not when there is a backup_label.\u003c/p\u003e","id":"17.5-5d0c95873c035713","identity_text":"Fix wrong checkpoint details in error message about incorrect recovery timeline choice (David Steele) If the requested recovery timeline is not reachable, the reported checkpoint and timeline should be the values read from the backup_label, if there is one. This message previously reported values from the control file, which is correct when recovering from the control file without a backup_label, but not when there is a backup_label.","part":"changes","patch_ids":["791e0478918d750ff09e10d599952384"],"related_changes":[{"db_id":"98f7fe84bec7c123507049c72ef3a854","evidence":{"patch_ids":["791e0478918d750ff09e10d599952384"],"same_day":true,"statement_hash":"e2dfc107fdae95cf7907303d4f0659f00f9b7c145f7fc3cf16d5b0f4d82af4ff"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Fix wrong checkpoint details in error message about incorrect recovery timeline choice","url":"/docs/compare/?release=16.9#16.9-a1968804eab98396","version":"16.9"},{"db_id":"54c2c91919ba0bb07a3b8c1d61f42e31","evidence":{"patch_ids":["791e0478918d750ff09e10d599952384"],"same_day":true,"statement_hash":"e2dfc107fdae95cf7907303d4f0659f00f9b7c145f7fc3cf16d5b0f4d82af4ff"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Fix wrong checkpoint details in error message about incorrect recovery timeline choice","url":"/docs/compare/?release=15.13#15.13-a501f629b2353dfa","version":"15.13"}],"relations":[{"evidence":{"patch_ids":["791e0478918d750ff09e10d599952384"],"same_day":true,"statement_hash":"e2dfc107fdae95cf7907303d4f0659f00f9b7c145f7fc3cf16d5b0f4d82af4ff"},"rule":2,"target":"54c2c91919ba0bb07a3b8c1d61f42e31","type":"equivalent"},{"evidence":{"patch_ids":["791e0478918d750ff09e10d599952384"],"same_day":true,"statement_hash":"e2dfc107fdae95cf7907303d4f0659f00f9b7c145f7fc3cf16d5b0f4d82af4ff"},"rule":2,"target":"98f7fe84bec7c123507049c72ef3a854","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["29cce279b"],"source_entry_id":"17.5/changes/043","source_hash":"4a11d4bbc124f676a937847b289634056e22305c96388148c6589a244d33525a","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"e2dfc107fdae95cf7907303d4f0659f00f9b7c145f7fc3cf16d5b0f4d82af4ff","text":"Fix wrong checkpoint details in error message about incorrect recovery timeline choice (David Steele) § If the requested recovery timeline is not reachable, the reported checkpoint and timeline should be the values read from the backup_label, if there is one. This message previously reported values from the control file, which is correct when recovering from the control file without a backup_label, but not when there is a backup_label.","title":"Fix wrong checkpoint details in error message about incorrect recovery timeline choice","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["499faf906","ee578921b"],"commit_groups":[["499faf906","ee578921b"]],"commits":["ee578921b"],"cves":[],"db_id":"e9a50ec7ca67f2c4679255406d0c6a77","html":"\u003cp\u003eFix order of operations in \u003ccode\u003esmgropen()\u003c/code\u003e (Andres Freund) \u003ca href=\"https://postgr.es/c/ee578921b\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eEnsure that the SMgrRelation object is fully initialized before calling the smgr_open callback, so that it can be cleaned up properly if the callback fails.\u003c/p\u003e","id":"17.5-9bcbd09b8a148aa1","identity_text":"Fix order of operations in smgropen() (Andres Freund) Ensure that the SMgrRelation object is fully initialized before calling the smgr_open callback, so that it can be cleaned up properly if the callback fails.","part":"changes","patch_ids":["f481d5337e18827c4d8faa8c466bd4df"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["ee578921b"],"source_entry_id":"17.5/changes/044","source_hash":"a12840fe271d563a4282c4d0c898af06886299f61d8c58d93ccecf5ae16865eb","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"cb989da0ed651666f73571842ce104ed836dcfc77ac8d00535a608e0ab8d5c3d","text":"Fix order of operations in smgropen() (Andres Freund) § Ensure that the SMgrRelation object is fully initialized before calling the smgr_open callback, so that it can be cleaned up properly if the callback fails.","title":"Fix order of operations in smgropen()","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["1f7878c33","4b6331e0f","c1201ffcf","e9ab8677b"],"commit_groups":[["1f7878c33","4b6331e0f","c1201ffcf","e9ab8677b"]],"commits":["4b6331e0f"],"cves":[],"db_id":"740b501f9ad0d12d3e015bea5033032e","html":"\u003cp\u003eRemove incorrect assertion in \u003ccode\u003epgstat_report_stat()\u003c/code\u003e (Michael Paquier) \u003ca href=\"https://postgr.es/c/4b6331e0f\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-6642898be230c9df","identity_text":"Remove incorrect assertion in pgstat_report_stat() (Michael Paquier)","part":"changes","patch_ids":["9f5de7a945360ec8523628333d065282"],"related_changes":[{"db_id":"3535c68f62f90779f5719aab87e0d3b2","evidence":{"patch_ids":["9f5de7a945360ec8523628333d065282"],"same_day":true,"statement_hash":"cf1b85c19947fa249a82f4ae4067e568fd8c2f2d25abdbbb20a28ea87cb119b4"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Remove incorrect assertion in pgstat_report_stat()","url":"/docs/compare/?release=16.9#16.9-fb310d1507562369","version":"16.9"},{"db_id":"3d0463cc82249270c6297e0a99ee2a87","evidence":{"patch_ids":["9f5de7a945360ec8523628333d065282"],"same_day":true,"statement_hash":"cf1b85c19947fa249a82f4ae4067e568fd8c2f2d25abdbbb20a28ea87cb119b4"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Remove incorrect assertion in pgstat_report_stat()","url":"/docs/compare/?release=15.13#15.13-f82e2e1180369446","version":"15.13"}],"relations":[{"evidence":{"patch_ids":["9f5de7a945360ec8523628333d065282"],"same_day":true,"statement_hash":"cf1b85c19947fa249a82f4ae4067e568fd8c2f2d25abdbbb20a28ea87cb119b4"},"rule":2,"target":"3535c68f62f90779f5719aab87e0d3b2","type":"equivalent"},{"evidence":{"patch_ids":["9f5de7a945360ec8523628333d065282"],"same_day":true,"statement_hash":"cf1b85c19947fa249a82f4ae4067e568fd8c2f2d25abdbbb20a28ea87cb119b4"},"rule":2,"target":"3d0463cc82249270c6297e0a99ee2a87","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["4b6331e0f"],"source_entry_id":"17.5/changes/045","source_hash":"2e07f89c12b772f2f0c402a638857ac32e0750a52049ce20b2cbdb79ca358e76","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"cf1b85c19947fa249a82f4ae4067e568fd8c2f2d25abdbbb20a28ea87cb119b4","text":"Remove incorrect assertion in pgstat_report_stat() (Michael Paquier) §","title":"Remove incorrect assertion in pgstat_report_stat()","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["3c0fe75c4","419321398","6526d0794","7afca7ede","a749c6f18","b92482dc3"],"commit_groups":[["3c0fe75c4","419321398","6526d0794","7afca7ede","a749c6f18","b92482dc3"]],"commits":["6526d0794"],"cves":[],"db_id":"ca5aa9bfc0cd6a3986c25a9bb834efea","html":"\u003cp\u003eFix overly-strict assertion in \u003ccode\u003egistFindCorrectParent()\u003c/code\u003e (Heikki Linnakangas) \u003ca href=\"https://postgr.es/c/6526d0794\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-2088f11ca5c4831c","identity_text":"Fix overly-strict assertion in gistFindCorrectParent() (Heikki Linnakangas)","part":"changes","patch_ids":["0fbdfd9512143481ddba29600dae91de"],"related_changes":[{"db_id":"8d4744d9a3fed01ed5b740a2da43b6eb","evidence":{"patch_ids":["0fbdfd9512143481ddba29600dae91de"],"same_day":true,"statement_hash":"7991ac5c15dda3f769161967c88693ea957ab1e582f1ecb61df8823d0f1d4f43"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Fix overly-strict assertion in gistFindCorrectParent()","url":"/docs/compare/?release=16.9#16.9-4c94d4fcc8fe7123","version":"16.9"},{"db_id":"47c7b886e00ee5dd3ededee611b2d16a","evidence":{"patch_ids":["0fbdfd9512143481ddba29600dae91de"],"same_day":true,"statement_hash":"7991ac5c15dda3f769161967c88693ea957ab1e582f1ecb61df8823d0f1d4f43"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Fix overly-strict assertion in gistFindCorrectParent()","url":"/docs/compare/?release=15.13#15.13-62cae577b4df954b","version":"15.13"},{"db_id":"27a1adb1cdf9f664d38d47c14da8e9a1","evidence":{"patch_ids":["0fbdfd9512143481ddba29600dae91de"],"same_day":true,"statement_hash":"7991ac5c15dda3f769161967c88693ea957ab1e582f1ecb61df8823d0f1d4f43"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Fix overly-strict assertion in gistFindCorrectParent()","url":"/docs/compare/?release=14.18#14.18-6a368ff09e31fc48","version":"14.18"},{"db_id":"e6d6bd528a6a18567eddf6d6d0bd348d","evidence":{"patch_ids":["0fbdfd9512143481ddba29600dae91de"],"same_day":true,"statement_hash":"7991ac5c15dda3f769161967c88693ea957ab1e582f1ecb61df8823d0f1d4f43"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Fix overly-strict assertion in gistFindCorrectParent()","url":"/docs/compare/?release=13.21#13.21-43c27eaaeb1d9bf4","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["0fbdfd9512143481ddba29600dae91de"],"same_day":true,"statement_hash":"7991ac5c15dda3f769161967c88693ea957ab1e582f1ecb61df8823d0f1d4f43"},"rule":2,"target":"27a1adb1cdf9f664d38d47c14da8e9a1","type":"equivalent"},{"evidence":{"patch_ids":["0fbdfd9512143481ddba29600dae91de"],"same_day":true,"statement_hash":"7991ac5c15dda3f769161967c88693ea957ab1e582f1ecb61df8823d0f1d4f43"},"rule":2,"target":"47c7b886e00ee5dd3ededee611b2d16a","type":"equivalent"},{"evidence":{"patch_ids":["0fbdfd9512143481ddba29600dae91de"],"same_day":true,"statement_hash":"7991ac5c15dda3f769161967c88693ea957ab1e582f1ecb61df8823d0f1d4f43"},"rule":2,"target":"8d4744d9a3fed01ed5b740a2da43b6eb","type":"equivalent"},{"evidence":{"patch_ids":["0fbdfd9512143481ddba29600dae91de"],"same_day":true,"statement_hash":"7991ac5c15dda3f769161967c88693ea957ab1e582f1ecb61df8823d0f1d4f43"},"rule":2,"target":"e6d6bd528a6a18567eddf6d6d0bd348d","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["6526d0794"],"source_entry_id":"17.5/changes/046","source_hash":"5fbab8b18410903c5e6847d364b97ee6bbef3c108cc25608524ca4910cf354c6","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"7991ac5c15dda3f769161967c88693ea957ab1e582f1ecb61df8823d0f1d4f43","text":"Fix overly-strict assertion in gistFindCorrectParent() (Heikki Linnakangas) §","title":"Fix overly-strict assertion in gistFindCorrectParent()","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["a38dce3c4","f4290f20d"],"commit_groups":[["a38dce3c4","f4290f20d"]],"commits":["a38dce3c4"],"cves":[],"db_id":"4a59e8cde523f7b227bdcca9060be71c","html":"\u003cp\u003eAvoid assertion failure in parallel vacuum when \u003ccode\u003emaintenance_work_mem\u003c/code\u003e has a very small value (Masahiko Sawada) \u003ca href=\"https://postgr.es/c/a38dce3c4\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-b6dc5aea73fb8657","identity_text":"Avoid assertion failure in parallel vacuum when maintenance_work_mem has a very small value (Masahiko Sawada)","part":"changes","patch_ids":["e813e6bf3fa89401d4818880c27a6cd2"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["a38dce3c4"],"source_entry_id":"17.5/changes/047","source_hash":"32f9930857cc65d6bf6859fee5a0a4df0acebc6df5bb89dc4cd4968080301c56","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"084b11091bb977a3ce1342c08943b766950ad0a7784b50423a83e560ff1e3d4a","text":"Avoid assertion failure in parallel vacuum when maintenance_work_mem has a very small value (Masahiko Sawada) §","title":"Avoid assertion failure in parallel vacuum when maintenance_work_mem has a very small value","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["2817525f0","2f33de3cd","302ce5bd9","66235baab","b30c77a0e"],"commit_groups":[["2817525f0","2f33de3cd","302ce5bd9","66235baab","b30c77a0e"]],"commits":["302ce5bd9"],"cves":[],"db_id":"2e5dab43fa75fedfa20b60368b606121","html":"\u003cp\u003eFix rare assertion failure in standby servers when the primary is restarted (Heikki Linnakangas) \u003ca href=\"https://postgr.es/c/302ce5bd9\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-aad4bd1803b8b133","identity_text":"Fix rare assertion failure in standby servers when the primary is restarted (Heikki Linnakangas)","part":"changes","patch_ids":["9563520801fea9e205ae16e82ea7855b"],"related_changes":[{"db_id":"b243add7e25b9349d3df07b8524bbb10","evidence":{"patch_ids":["9563520801fea9e205ae16e82ea7855b"],"same_day":true,"statement_hash":"e03ba0b3fc8a8995594cd92902313647f941a8d013faea0b71e91ba7c6dcbd47"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Fix rare assertion failure in standby servers when the primary is restarted","url":"/docs/compare/?release=16.9#16.9-d4a51d0e3bd64212","version":"16.9"},{"db_id":"66b073699b174d84b287cd5ba0bb5c0b","evidence":{"patch_ids":["9563520801fea9e205ae16e82ea7855b"],"same_day":true,"statement_hash":"e03ba0b3fc8a8995594cd92902313647f941a8d013faea0b71e91ba7c6dcbd47"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Fix rare assertion failure in standby servers when the primary is restarted","url":"/docs/compare/?release=15.13#15.13-a5839a410d8f1699","version":"15.13"},{"db_id":"92378c11f17a7de0c034937e90f5f438","evidence":{"patch_ids":["9563520801fea9e205ae16e82ea7855b"],"same_day":true,"statement_hash":"e03ba0b3fc8a8995594cd92902313647f941a8d013faea0b71e91ba7c6dcbd47"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Fix rare assertion failure in standby servers when the primary is restarted","url":"/docs/compare/?release=14.18#14.18-c0e9cfa3a39cfe3a","version":"14.18"}],"relations":[{"evidence":{"patch_ids":["9563520801fea9e205ae16e82ea7855b"],"same_day":true,"statement_hash":"e03ba0b3fc8a8995594cd92902313647f941a8d013faea0b71e91ba7c6dcbd47"},"rule":2,"target":"66b073699b174d84b287cd5ba0bb5c0b","type":"equivalent"},{"evidence":{"patch_ids":["9563520801fea9e205ae16e82ea7855b"],"same_day":true,"statement_hash":"e03ba0b3fc8a8995594cd92902313647f941a8d013faea0b71e91ba7c6dcbd47"},"rule":2,"target":"92378c11f17a7de0c034937e90f5f438","type":"equivalent"},{"evidence":{"patch_ids":["9563520801fea9e205ae16e82ea7855b"],"same_day":true,"statement_hash":"e03ba0b3fc8a8995594cd92902313647f941a8d013faea0b71e91ba7c6dcbd47"},"rule":2,"target":"b243add7e25b9349d3df07b8524bbb10","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["302ce5bd9"],"source_entry_id":"17.5/changes/048","source_hash":"aa4b6026d251c1bfa1a3979952d3fad2379c2ebb2330085a44a74725c6290c3f","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"e03ba0b3fc8a8995594cd92902313647f941a8d013faea0b71e91ba7c6dcbd47","text":"Fix rare assertion failure in standby servers when the primary is restarted (Heikki Linnakangas) §","title":"Fix rare assertion failure in standby servers when the primary is restarted","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["0f60e1fba","1353b1161","5e56efa7c","7fe312f60","a28c1fb61","c196c610b"],"commit_groups":[["0f60e1fba","1353b1161","5e56efa7c","7fe312f60","a28c1fb61","c196c610b"]],"commits":["1353b1161"],"cves":[],"db_id":"5d327155f21daa11c824f675329dd129","html":"\u003cp\u003eIn PL/pgSQL, avoid \u003cspan\u003e“\u003cspan\u003eunexpected plan node type\u003c/span\u003e”\u003c/span\u003e error when a scrollable cursor is defined on a simple \u003ccode\u003eSELECT \u003cem\u003e\u003ccode\u003eexpression\u003c/code\u003e\u003c/em\u003e\u003c/code\u003e query (Andrei Lepikhov) \u003ca href=\"https://postgr.es/c/1353b1161\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-49aae01e3ea0240a","identity_text":"In PL/pgSQL, avoid unexpected plan node type error when a scrollable cursor is defined on a simple SELECT expression query (Andrei Lepikhov)","part":"changes","patch_ids":["f12a136931a2c9b85092405b258f239d"],"related_changes":[{"db_id":"3d77b38c14caf8186c9c4c8d7073f660","evidence":{"patch_ids":["f12a136931a2c9b85092405b258f239d"],"same_day":true,"statement_hash":"b4aad974b17bda0a76dd37ef72496e590fcabf2c46a61ba4894df2a3e4e60bf8"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"In PL/pgSQL, avoid “unexpected plan node type” error when a scrollable cursor is defined on a simple SELECT expression query","url":"/docs/compare/?release=16.9#16.9-5a72f158f19fb45f","version":"16.9"},{"db_id":"1cf4e3ccb27beb351563e92204699ddf","evidence":{"patch_ids":["f12a136931a2c9b85092405b258f239d"],"same_day":true,"statement_hash":"b4aad974b17bda0a76dd37ef72496e590fcabf2c46a61ba4894df2a3e4e60bf8"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"In PL/pgSQL, avoid “unexpected plan node type” error when a scrollable cursor is defined on a simple SELECT expression query","url":"/docs/compare/?release=15.13#15.13-4f40d70662d8882c","version":"15.13"},{"db_id":"3e2662777ac979f38f4588bb5b04a2d3","evidence":{"patch_ids":["f12a136931a2c9b85092405b258f239d"],"same_day":true,"statement_hash":"b4aad974b17bda0a76dd37ef72496e590fcabf2c46a61ba4894df2a3e4e60bf8"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"In PL/pgSQL, avoid “unexpected plan node type” error when a scrollable cursor is defined on a simple SELECT expression query","url":"/docs/compare/?release=14.18#14.18-d202fbcf25295587","version":"14.18"},{"db_id":"7c6fc81e4da27ce44047105c6c5470d3","evidence":{"patch_ids":["f12a136931a2c9b85092405b258f239d"],"same_day":true,"statement_hash":"b4aad974b17bda0a76dd37ef72496e590fcabf2c46a61ba4894df2a3e4e60bf8"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"In PL/pgSQL, avoid “unexpected plan node type” error when a scrollable cursor is defined on a simple SELECT expression query","url":"/docs/compare/?release=13.21#13.21-3bd8b23d952a1816","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["f12a136931a2c9b85092405b258f239d"],"same_day":true,"statement_hash":"b4aad974b17bda0a76dd37ef72496e590fcabf2c46a61ba4894df2a3e4e60bf8"},"rule":2,"target":"1cf4e3ccb27beb351563e92204699ddf","type":"equivalent"},{"evidence":{"patch_ids":["f12a136931a2c9b85092405b258f239d"],"same_day":true,"statement_hash":"b4aad974b17bda0a76dd37ef72496e590fcabf2c46a61ba4894df2a3e4e60bf8"},"rule":2,"target":"3d77b38c14caf8186c9c4c8d7073f660","type":"equivalent"},{"evidence":{"patch_ids":["f12a136931a2c9b85092405b258f239d"],"same_day":true,"statement_hash":"b4aad974b17bda0a76dd37ef72496e590fcabf2c46a61ba4894df2a3e4e60bf8"},"rule":2,"target":"3e2662777ac979f38f4588bb5b04a2d3","type":"equivalent"},{"evidence":{"patch_ids":["f12a136931a2c9b85092405b258f239d"],"same_day":true,"statement_hash":"b4aad974b17bda0a76dd37ef72496e590fcabf2c46a61ba4894df2a3e4e60bf8"},"rule":2,"target":"7c6fc81e4da27ce44047105c6c5470d3","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["1353b1161"],"source_entry_id":"17.5/changes/049","source_hash":"66ff0186feb54b477156c90be2e710f07c835c8f1ca45e63b0ea303011bd1176","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"b4aad974b17bda0a76dd37ef72496e590fcabf2c46a61ba4894df2a3e4e60bf8","text":"In PL/pgSQL, avoid “unexpected plan node type” error when a scrollable cursor is defined on a simple SELECT expression query (Andrei Lepikhov) §","title":"In PL/pgSQL, avoid “unexpected plan node type” error when a scrollable cursor is defined on a simple SELECT expression query","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["148cc0105","1fc340362","3424c1075","6a3e57865","7144cd538","a25f21d99"],"commit_groups":[["148cc0105","1fc340362","3424c1075","6a3e57865","7144cd538","a25f21d99"]],"commits":["3424c1075"],"cves":[],"db_id":"4b6e027be9c24d09a0bd8e953edf317c","html":"\u003cp\u003eDon't try to drop individual index partitions in \u003cspan\u003epg_dump\u003c/span\u003e's \u003ccode\u003e--clean\u003c/code\u003e mode (Jian He) \u003ca href=\"https://postgr.es/c/3424c1075\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThe server rejects such \u003ccode\u003eDROP\u003c/code\u003e commands. That has no real consequences, since the partitions will go away anyway in the subsequent \u003ccode\u003eDROP\u003c/code\u003es of either their parent tables or their partitioned index. However, the error reported for the attempted drop causes problems when restoring in \u003ccode\u003e--single-transaction\u003c/code\u003e mode.\u003c/p\u003e","id":"17.5-130186541e057b56","identity_text":"Don't try to drop individual index partitions in pg_dump's --clean mode (Jian He) The server rejects such DROP commands. That has no real consequences, since the partitions will go away anyway in the subsequent DROPs of either their parent tables or their partitioned index. However, the error reported for the attempted drop causes problems when restoring in --single-transaction mode.","part":"changes","patch_ids":["9cc39f67b2112ad724d3dd4a32e53e3b"],"related_changes":[{"db_id":"69851138f2b853be3168d802588a9520","evidence":{"patch_ids":["9cc39f67b2112ad724d3dd4a32e53e3b"],"same_day":true,"statement_hash":"e67fba1cf484eebaf3c4c42d5ece9796503851f5392fb5c05c0952acff3b2b13"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Don't try to drop individual index partitions in pg_dump's --clean mode","url":"/docs/compare/?release=16.9#16.9-5ae9f3957cb2bed6","version":"16.9"},{"db_id":"eb7b42e15648d7b8b3c440a7101915a2","evidence":{"patch_ids":["9cc39f67b2112ad724d3dd4a32e53e3b"],"same_day":true,"statement_hash":"e67fba1cf484eebaf3c4c42d5ece9796503851f5392fb5c05c0952acff3b2b13"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Don't try to drop individual index partitions in pg_dump's --clean mode","url":"/docs/compare/?release=15.13#15.13-48059b5256fc8763","version":"15.13"},{"db_id":"d6903e20c3eee4fa2356e0d2b2c154d8","evidence":{"patch_ids":["9cc39f67b2112ad724d3dd4a32e53e3b"],"same_day":true,"statement_hash":"e67fba1cf484eebaf3c4c42d5ece9796503851f5392fb5c05c0952acff3b2b13"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Don't try to drop individual index partitions in pg_dump's --clean mode","url":"/docs/compare/?release=14.18#14.18-a62c77db7183ddb7","version":"14.18"},{"db_id":"42df3da7d8c6955067fbe63c28f79b7f","evidence":{"patch_ids":["9cc39f67b2112ad724d3dd4a32e53e3b"],"same_day":true,"statement_hash":"e67fba1cf484eebaf3c4c42d5ece9796503851f5392fb5c05c0952acff3b2b13"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Don't try to drop individual index partitions in pg_dump's --clean mode","url":"/docs/compare/?release=13.21#13.21-ae695bef185b433b","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["9cc39f67b2112ad724d3dd4a32e53e3b"],"same_day":true,"statement_hash":"e67fba1cf484eebaf3c4c42d5ece9796503851f5392fb5c05c0952acff3b2b13"},"rule":2,"target":"42df3da7d8c6955067fbe63c28f79b7f","type":"equivalent"},{"evidence":{"patch_ids":["9cc39f67b2112ad724d3dd4a32e53e3b"],"same_day":true,"statement_hash":"e67fba1cf484eebaf3c4c42d5ece9796503851f5392fb5c05c0952acff3b2b13"},"rule":2,"target":"69851138f2b853be3168d802588a9520","type":"equivalent"},{"evidence":{"patch_ids":["9cc39f67b2112ad724d3dd4a32e53e3b"],"same_day":true,"statement_hash":"e67fba1cf484eebaf3c4c42d5ece9796503851f5392fb5c05c0952acff3b2b13"},"rule":2,"target":"d6903e20c3eee4fa2356e0d2b2c154d8","type":"equivalent"},{"evidence":{"patch_ids":["9cc39f67b2112ad724d3dd4a32e53e3b"],"same_day":true,"statement_hash":"e67fba1cf484eebaf3c4c42d5ece9796503851f5392fb5c05c0952acff3b2b13"},"rule":2,"target":"eb7b42e15648d7b8b3c440a7101915a2","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["3424c1075"],"source_entry_id":"17.5/changes/050","source_hash":"9038104609a2da33715983cf892c666084865aad6f20830ab023c597c1686906","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"e67fba1cf484eebaf3c4c42d5ece9796503851f5392fb5c05c0952acff3b2b13","text":"Don't try to drop individual index partitions in pg_dump's --clean mode (Jian He) § The server rejects such DROP commands. That has no real consequences, since the partitions will go away anyway in the subsequent DROPs of either their parent tables or their partitioned index. However, the error reported for the attempted drop causes problems when restoring in --single-transaction mode.","title":"Don't try to drop individual index partitions in pg_dump's --clean mode","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["16eff4261","29d75b25b","5302ff95c","6df3be415","ce1475acd","d850a6600"],"commit_groups":[["16eff4261","29d75b25b","5302ff95c","6df3be415","ce1475acd","d850a6600"]],"commits":["16eff4261"],"cves":[],"db_id":"14be69327836b06f72a5afffc236458d","html":"\u003cp\u003eIn \u003cspan\u003epg_dumpall\u003c/span\u003e, avoid emitting invalid role \u003ccode\u003eGRANT\u003c/code\u003e commands if \u003ccode\u003epg_auth_members\u003c/code\u003e contains invalid role OIDs (Tom Lane) \u003ca href=\"https://postgr.es/c/16eff4261\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eInstead, print a warning and skip the entry. This copes better with catalog corruption that has been seen to occur in back branches as a result of race conditions between \u003ccode\u003eGRANT\u003c/code\u003e and \u003ccode\u003eDROP ROLE\u003c/code\u003e.\u003c/p\u003e","id":"17.5-2696110d8fb93792","identity_text":"In pg_dumpall, avoid emitting invalid role GRANT commands if pg_auth_members contains invalid role OIDs (Tom Lane) Instead, print a warning and skip the entry. This copes better with catalog corruption that has been seen to occur in back branches as a result of race conditions between GRANT and DROP ROLE.","part":"changes","patch_ids":["f2b1be5bd5a37e4c2f6310eac9a9677e"],"related_changes":[{"db_id":"4220609cab0faa9ff9b9847d6eaf69af","evidence":{"patch_ids":["f2b1be5bd5a37e4c2f6310eac9a9677e"],"same_day":true,"statement_hash":"6729e0781366fce928be3cedd2434b59ba0db94ff9e8f2492dfbca532d833f8a"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"In pg_dumpall, avoid emitting invalid role GRANT commands if pg_auth_members contains invalid role OIDs","url":"/docs/compare/?release=16.9#16.9-9ea97d37c27d913b","version":"16.9"},{"db_id":"e29abb4009fe4358d8ffa797134f6858","evidence":{"patch_ids":["f2b1be5bd5a37e4c2f6310eac9a9677e"],"same_day":true,"statement_hash":"6729e0781366fce928be3cedd2434b59ba0db94ff9e8f2492dfbca532d833f8a"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"In pg_dumpall, avoid emitting invalid role GRANT commands if pg_auth_members contains invalid role OIDs","url":"/docs/compare/?release=15.13#15.13-f1fceade151b6e7f","version":"15.13"},{"db_id":"592072835cdff737b256d67238063430","evidence":{"patch_ids":["f2b1be5bd5a37e4c2f6310eac9a9677e"],"same_day":true,"statement_hash":"6729e0781366fce928be3cedd2434b59ba0db94ff9e8f2492dfbca532d833f8a"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"In pg_dumpall, avoid emitting invalid role GRANT commands if pg_auth_members contains invalid role OIDs","url":"/docs/compare/?release=14.18#14.18-3480ee8713990fb4","version":"14.18"},{"db_id":"037e06a9150261d4225482652afbae69","evidence":{"patch_ids":["f2b1be5bd5a37e4c2f6310eac9a9677e"],"same_day":true,"statement_hash":"6729e0781366fce928be3cedd2434b59ba0db94ff9e8f2492dfbca532d833f8a"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"In pg_dumpall, avoid emitting invalid role GRANT commands if pg_auth_members contains invalid role OIDs","url":"/docs/compare/?release=13.21#13.21-70bdf129a37d033e","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["f2b1be5bd5a37e4c2f6310eac9a9677e"],"same_day":true,"statement_hash":"6729e0781366fce928be3cedd2434b59ba0db94ff9e8f2492dfbca532d833f8a"},"rule":2,"target":"037e06a9150261d4225482652afbae69","type":"equivalent"},{"evidence":{"patch_ids":["f2b1be5bd5a37e4c2f6310eac9a9677e"],"same_day":true,"statement_hash":"6729e0781366fce928be3cedd2434b59ba0db94ff9e8f2492dfbca532d833f8a"},"rule":2,"target":"4220609cab0faa9ff9b9847d6eaf69af","type":"equivalent"},{"evidence":{"patch_ids":["f2b1be5bd5a37e4c2f6310eac9a9677e"],"same_day":true,"statement_hash":"6729e0781366fce928be3cedd2434b59ba0db94ff9e8f2492dfbca532d833f8a"},"rule":2,"target":"592072835cdff737b256d67238063430","type":"equivalent"},{"evidence":{"patch_ids":["f2b1be5bd5a37e4c2f6310eac9a9677e"],"same_day":true,"statement_hash":"6729e0781366fce928be3cedd2434b59ba0db94ff9e8f2492dfbca532d833f8a"},"rule":2,"target":"e29abb4009fe4358d8ffa797134f6858","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["16eff4261"],"source_entry_id":"17.5/changes/051","source_hash":"1f0947569a450b13443eecb9bf880865f29e2beea35725eb3331e81331dfec88","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"6729e0781366fce928be3cedd2434b59ba0db94ff9e8f2492dfbca532d833f8a","text":"In pg_dumpall, avoid emitting invalid role GRANT commands if pg_auth_members contains invalid role OIDs (Tom Lane) § Instead, print a warning and skip the entry. This copes better with catalog corruption that has been seen to occur in back branches as a result of race conditions between GRANT and DROP ROLE.","title":"In pg_dumpall, avoid emitting invalid role GRANT commands if pg_auth_members contains invalid role OIDs","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["0851b6573","2a083ab80","35a591a04","48e4ae9a0","57467ec7b","816149dc6","945126234","9ca2145b0","ec741d480","ee78823ff","f903d4da9"],"commit_groups":[["0851b6573","57467ec7b","945126234"],["2a083ab80","9ca2145b0","ee78823ff"],["35a591a04","48e4ae9a0","816149dc6","ec741d480","f903d4da9"]],"commits":["0851b6573","ee78823ff","f903d4da9"],"cves":[],"db_id":"8a119f30aebe8217bd24c84ac83c5357","html":"\u003cp\u003eIn \u003cspan\u003epg_amcheck\u003c/span\u003e and \u003cspan\u003epg_upgrade\u003c/span\u003e, use the correct function to free allocations made by \u003cspan\u003elibpq\u003c/span\u003e (Michael Paquier, Ranier Vilela) \u003ca href=\"https://postgr.es/c/ee78823ff\"\u003e§\u003c/a\u003e \u003ca href=\"https://postgr.es/c/0851b6573\"\u003e§\u003c/a\u003e \u003ca href=\"https://postgr.es/c/f903d4da9\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThese oversights could result in crashes in certain Windows build configurations, such as a debug build of \u003cspan\u003elibpq\u003c/span\u003e used by a non-debug build of the calling application.\u003c/p\u003e","id":"17.5-5ad323aca8e79aef","identity_text":"In pg_amcheck and pg_upgrade, use the correct function to free allocations made by libpq (Michael Paquier, Ranier Vilela) These oversights could result in crashes in certain Windows build configurations, such as a debug build of libpq used by a non-debug build of the calling application.","part":"changes","patch_ids":["34b26a2c0bc11f53689f56c106a22dd3","5db415aa9fa83b6f5da048d1aaff9003","7d2d1045e1e8db0bcdd0ec88b43e297b"],"related_changes":[{"db_id":"60340d64ebc76c76673aee7bbdf1bf84","evidence":{"patch_ids":["34b26a2c0bc11f53689f56c106a22dd3","5db415aa9fa83b6f5da048d1aaff9003","7d2d1045e1e8db0bcdd0ec88b43e297b"],"same_day":true,"statement_hash":"147a35118d1eb034a96eb96159a572da3cddff6637a9f24a2dbd4d0497d59fb6"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"In pg_amcheck and pg_upgrade, use the correct function to free allocations made by libpq","url":"/docs/compare/?release=16.9#16.9-76778728b70e985f","version":"16.9"},{"db_id":"ec8806ac157013d5a48910bd3a2696f9","evidence":{"patch_ids":["34b26a2c0bc11f53689f56c106a22dd3","5db415aa9fa83b6f5da048d1aaff9003","7d2d1045e1e8db0bcdd0ec88b43e297b"],"same_day":true,"statement_hash":"147a35118d1eb034a96eb96159a572da3cddff6637a9f24a2dbd4d0497d59fb6"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"In pg_amcheck and pg_upgrade, use the correct function to free allocations made by libpq","url":"/docs/compare/?release=15.13#15.13-9bad788e9e990512","version":"15.13"},{"db_id":"ef4d0bd11b44a555d9ff5417d9062b2d","evidence":{"patch_ids":["34b26a2c0bc11f53689f56c106a22dd3","5db415aa9fa83b6f5da048d1aaff9003","7d2d1045e1e8db0bcdd0ec88b43e297b"],"same_day":true,"statement_hash":"147a35118d1eb034a96eb96159a572da3cddff6637a9f24a2dbd4d0497d59fb6"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"In pg_amcheck and pg_upgrade, use the correct function to free allocations made by libpq","url":"/docs/compare/?release=14.18#14.18-7a70a94b4f51a3ee","version":"14.18"}],"relations":[{"evidence":{"patch_ids":["34b26a2c0bc11f53689f56c106a22dd3","5db415aa9fa83b6f5da048d1aaff9003","7d2d1045e1e8db0bcdd0ec88b43e297b"],"same_day":true,"statement_hash":"147a35118d1eb034a96eb96159a572da3cddff6637a9f24a2dbd4d0497d59fb6"},"rule":2,"target":"60340d64ebc76c76673aee7bbdf1bf84","type":"equivalent"},{"evidence":{"patch_ids":["34b26a2c0bc11f53689f56c106a22dd3","5db415aa9fa83b6f5da048d1aaff9003","7d2d1045e1e8db0bcdd0ec88b43e297b"],"same_day":true,"statement_hash":"147a35118d1eb034a96eb96159a572da3cddff6637a9f24a2dbd4d0497d59fb6"},"rule":2,"target":"ec8806ac157013d5a48910bd3a2696f9","type":"equivalent"},{"evidence":{"patch_ids":["34b26a2c0bc11f53689f56c106a22dd3","5db415aa9fa83b6f5da048d1aaff9003","7d2d1045e1e8db0bcdd0ec88b43e297b"],"same_day":true,"statement_hash":"147a35118d1eb034a96eb96159a572da3cddff6637a9f24a2dbd4d0497d59fb6"},"rule":2,"target":"ef4d0bd11b44a555d9ff5417d9062b2d","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["0851b6573","ee78823ff","f903d4da9"],"source_entry_id":"17.5/changes/052","source_hash":"00f8f6c6fde75a5bfd02f8963be768516755c2d26974f33d832891c2dd5b97e5","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"147a35118d1eb034a96eb96159a572da3cddff6637a9f24a2dbd4d0497d59fb6","text":"In pg_amcheck and pg_upgrade, use the correct function to free allocations made by libpq (Michael Paquier, Ranier Vilela) § § § These oversights could result in crashes in certain Windows build configurations, such as a debug build of libpq used by a non-debug build of the calling application.","title":"In pg_amcheck and pg_upgrade, use the correct function to free allocations made by libpq","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["09ef2f8df","682c5be25"],"commit_groups":[["09ef2f8df","682c5be25"]],"commits":["09ef2f8df"],"cves":[],"db_id":"575a07a33fc92b96172ff638298c2451","html":"\u003cp\u003eFix \u003cspan\u003ereindexdb\u003c/span\u003e's scheduling of parallel reindex operations (Alexander Korotkov) \u003ca href=\"https://postgr.es/c/09ef2f8df\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThe original coding failed to achieve the expected amount of parallelism.\u003c/p\u003e","id":"17.5-60ef3907c8e8a85d","identity_text":"Fix reindexdb's scheduling of parallel reindex operations (Alexander Korotkov) The original coding failed to achieve the expected amount of parallelism.","part":"changes","patch_ids":["421c3df946e276be2ee09356d0dadc82"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["09ef2f8df"],"source_entry_id":"17.5/changes/053","source_hash":"c53a21e29754c5bb26c2e9f0e24672eb9f1f662f2d0df792260f3229ed0981ab","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"95350f6e9c6d80196cea726acee69d0fd313959d0375bd8a7921ad3d3c8050d6","text":"Fix reindexdb's scheduling of parallel reindex operations (Alexander Korotkov) § The original coding failed to achieve the expected amount of parallelism.","title":"Fix reindexdb's scheduling of parallel reindex operations","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["2d33cf7b8","3c2ea65bd","3f9132ed2","90a3fd811","d05996340","ecb8e5641"],"commit_groups":[["2d33cf7b8","3c2ea65bd","3f9132ed2","90a3fd811","d05996340","ecb8e5641"]],"commits":["ecb8e5641"],"cves":[],"db_id":"ce0bbe28db794f9f70b7f7db6b8181ea","html":"\u003cp\u003eAvoid crashing with corrupt input data in \u003ccode\u003econtrib/pageinspect\u003c/code\u003e's \u003ccode\u003eheap_page_items()\u003c/code\u003e (Dmitry Kovalenko) \u003ca href=\"https://postgr.es/c/ecb8e5641\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-0e11947bab051637","identity_text":"Avoid crashing with corrupt input data in contrib/pageinspect's heap_page_items() (Dmitry Kovalenko)","part":"changes","patch_ids":["2435530dffce06becc5d751283d5f833"],"related_changes":[{"db_id":"8881e1af5842b40914bd9c207c6751b0","evidence":{"patch_ids":["2435530dffce06becc5d751283d5f833"],"same_day":true,"statement_hash":"790d101cd9311d28874a47621867e0f86ac13af8fc3973712618b15dc6acdf40"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Avoid crashing with corrupt input data in contrib/pageinspect's heap_page_items()","url":"/docs/compare/?release=16.9#16.9-4e36ed5d94cadcea","version":"16.9"},{"db_id":"ace2bc25865466ba2e780658d626980b","evidence":{"patch_ids":["2435530dffce06becc5d751283d5f833"],"same_day":true,"statement_hash":"790d101cd9311d28874a47621867e0f86ac13af8fc3973712618b15dc6acdf40"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Avoid crashing with corrupt input data in contrib/pageinspect's heap_page_items()","url":"/docs/compare/?release=15.13#15.13-a090ff4536e44a9a","version":"15.13"},{"db_id":"582e08e155bdd58b1d1937a654a61592","evidence":{"patch_ids":["2435530dffce06becc5d751283d5f833"],"same_day":true,"statement_hash":"790d101cd9311d28874a47621867e0f86ac13af8fc3973712618b15dc6acdf40"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Avoid crashing with corrupt input data in contrib/pageinspect's heap_page_items()","url":"/docs/compare/?release=14.18#14.18-5b312ef265127ea5","version":"14.18"},{"db_id":"aa20cf1d90a687514d529cf07c387ac3","evidence":{"patch_ids":["2435530dffce06becc5d751283d5f833"],"same_day":true,"statement_hash":"790d101cd9311d28874a47621867e0f86ac13af8fc3973712618b15dc6acdf40"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Avoid crashing with corrupt input data in contrib/pageinspect's heap_page_items()","url":"/docs/compare/?release=13.21#13.21-fd890674555ab03b","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["2435530dffce06becc5d751283d5f833"],"same_day":true,"statement_hash":"790d101cd9311d28874a47621867e0f86ac13af8fc3973712618b15dc6acdf40"},"rule":2,"target":"582e08e155bdd58b1d1937a654a61592","type":"equivalent"},{"evidence":{"patch_ids":["2435530dffce06becc5d751283d5f833"],"same_day":true,"statement_hash":"790d101cd9311d28874a47621867e0f86ac13af8fc3973712618b15dc6acdf40"},"rule":2,"target":"8881e1af5842b40914bd9c207c6751b0","type":"equivalent"},{"evidence":{"patch_ids":["2435530dffce06becc5d751283d5f833"],"same_day":true,"statement_hash":"790d101cd9311d28874a47621867e0f86ac13af8fc3973712618b15dc6acdf40"},"rule":2,"target":"aa20cf1d90a687514d529cf07c387ac3","type":"equivalent"},{"evidence":{"patch_ids":["2435530dffce06becc5d751283d5f833"],"same_day":true,"statement_hash":"790d101cd9311d28874a47621867e0f86ac13af8fc3973712618b15dc6acdf40"},"rule":2,"target":"ace2bc25865466ba2e780658d626980b","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["ecb8e5641"],"source_entry_id":"17.5/changes/054","source_hash":"463ce6b974b8c70fd49fa4d82fff889e2f7b1abed62e380390a3f8e121514487","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"790d101cd9311d28874a47621867e0f86ac13af8fc3973712618b15dc6acdf40","text":"Avoid crashing with corrupt input data in contrib/pageinspect's heap_page_items() (Dmitry Kovalenko) §","title":"Avoid crashing with corrupt input data in contrib/pageinspect's heap_page_items()","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["0e86bad38","41ed749e4","4623d7144","51d038da8","5ff827389","db8238da4"],"commit_groups":[["0e86bad38","41ed749e4","4623d7144","51d038da8","5ff827389","db8238da4"]],"commits":["51d038da8"],"cves":[],"db_id":"ed681893dd2413de875556a68dd1f326","html":"\u003cp\u003ePrevent assertion failure in \u003ccode\u003econtrib/pg_freespacemap\u003c/code\u003e's \u003ccode\u003epg_freespacemap()\u003c/code\u003e (Tender Wang) \u003ca href=\"https://postgr.es/c/51d038da8\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eApplying \u003ccode\u003epg_freespacemap()\u003c/code\u003e to a relation lacking storage (such as a view) caused an assertion failure, although there was no ill effect in non-assert builds. Add an error check to reject that case.\u003c/p\u003e","id":"17.5-1dffc3d6b9d4a839","identity_text":"Prevent assertion failure in contrib/pg_freespacemap's pg_freespacemap() (Tender Wang) Applying pg_freespacemap() to a relation lacking storage (such as a view) caused an assertion failure, although there was no ill effect in non-assert builds. Add an error check to reject that case.","part":"changes","patch_ids":["3e5cc9e814c9dece1afb8c66792c24b0"],"related_changes":[{"db_id":"a31972a05b0a88178f98582dd5a915ab","evidence":{"patch_ids":["3e5cc9e814c9dece1afb8c66792c24b0"],"same_day":true,"statement_hash":"ac76386686f5a22f3f9f87e3acb88251eb3917b665302519ad233f4c0b2cd83d"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Prevent assertion failure in contrib/pg_freespacemap's pg_freespacemap()","url":"/docs/compare/?release=16.9#16.9-7f0fd7a665d6f996","version":"16.9"},{"db_id":"2b6a0f3f7be35f404a9c6d630e81966f","evidence":{"patch_ids":["3e5cc9e814c9dece1afb8c66792c24b0"],"same_day":true,"statement_hash":"ac76386686f5a22f3f9f87e3acb88251eb3917b665302519ad233f4c0b2cd83d"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Prevent assertion failure in contrib/pg_freespacemap's pg_freespacemap()","url":"/docs/compare/?release=15.13#15.13-c355b8b2ba341fdd","version":"15.13"},{"db_id":"81e603618cc6cfaecbb907958d188bb0","evidence":{"patch_ids":["3e5cc9e814c9dece1afb8c66792c24b0"],"same_day":true,"statement_hash":"ac76386686f5a22f3f9f87e3acb88251eb3917b665302519ad233f4c0b2cd83d"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Prevent assertion failure in contrib/pg_freespacemap's pg_freespacemap()","url":"/docs/compare/?release=14.18#14.18-d9a739915b758a3d","version":"14.18"},{"db_id":"adfcc6ef0adfbe59858de60aa47488f2","evidence":{"patch_ids":["3e5cc9e814c9dece1afb8c66792c24b0"],"same_day":true,"statement_hash":"ac76386686f5a22f3f9f87e3acb88251eb3917b665302519ad233f4c0b2cd83d"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Prevent assertion failure in contrib/pg_freespacemap's pg_freespacemap()","url":"/docs/compare/?release=13.21#13.21-de4430d9db2f49d8","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["3e5cc9e814c9dece1afb8c66792c24b0"],"same_day":true,"statement_hash":"ac76386686f5a22f3f9f87e3acb88251eb3917b665302519ad233f4c0b2cd83d"},"rule":2,"target":"2b6a0f3f7be35f404a9c6d630e81966f","type":"equivalent"},{"evidence":{"patch_ids":["3e5cc9e814c9dece1afb8c66792c24b0"],"same_day":true,"statement_hash":"ac76386686f5a22f3f9f87e3acb88251eb3917b665302519ad233f4c0b2cd83d"},"rule":2,"target":"81e603618cc6cfaecbb907958d188bb0","type":"equivalent"},{"evidence":{"patch_ids":["3e5cc9e814c9dece1afb8c66792c24b0"],"same_day":true,"statement_hash":"ac76386686f5a22f3f9f87e3acb88251eb3917b665302519ad233f4c0b2cd83d"},"rule":2,"target":"a31972a05b0a88178f98582dd5a915ab","type":"equivalent"},{"evidence":{"patch_ids":["3e5cc9e814c9dece1afb8c66792c24b0"],"same_day":true,"statement_hash":"ac76386686f5a22f3f9f87e3acb88251eb3917b665302519ad233f4c0b2cd83d"},"rule":2,"target":"adfcc6ef0adfbe59858de60aa47488f2","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["51d038da8"],"source_entry_id":"17.5/changes/055","source_hash":"8bbcf6ae5666b22dc834a4168a4fa01d97f95e2a9e196220c76c36117d654996","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"ac76386686f5a22f3f9f87e3acb88251eb3917b665302519ad233f4c0b2cd83d","text":"Prevent assertion failure in contrib/pg_freespacemap's pg_freespacemap() (Tender Wang) § Applying pg_freespacemap() to a relation lacking storage (such as a view) caused an assertion failure, although there was no ill effect in non-assert builds. Add an error check to reject that case.","title":"Prevent assertion failure in contrib/pg_freespacemap's pg_freespacemap()","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["023fb5127","729fe699e"],"commit_groups":[["023fb5127","729fe699e"]],"commits":["729fe699e"],"cves":[],"db_id":"59b59c4ce5bad86f8bc9e6ec18d4e3da","html":"\u003cp\u003eIn \u003ccode\u003econtrib/postgres_fdw\u003c/code\u003e, avoid pulling up restriction conditions from subqueries (Alexander Pyhalov) \u003ca href=\"https://postgr.es/c/729fe699e\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThis fix prevents rare cases of \u003cspan\u003e“\u003cspan\u003eunexpected expression in subquery output\u003c/span\u003e”\u003c/span\u003e errors.\u003c/p\u003e","id":"17.5-63cd4b0e852d85d1","identity_text":"In contrib/postgres_fdw, avoid pulling up restriction conditions from subqueries (Alexander Pyhalov) This fix prevents rare cases of unexpected expression in subquery output errors.","part":"changes","patch_ids":["50afeb520a37af80d551b825565a54fe"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["729fe699e"],"source_entry_id":"17.5/changes/056","source_hash":"8c2b58f0befb5f3f89b421dbdc8c2c864e29fde69143b433e21b23f676399505","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"069b46634cf58ca16329cb076bebb0e156339c298d752ec151fa02f9a6dde690","text":"In contrib/postgres_fdw, avoid pulling up restriction conditions from subqueries (Alexander Pyhalov) § This fix prevents rare cases of “unexpected expression in subquery output” errors.","title":"In contrib/postgres_fdw, avoid pulling up restriction conditions from subqueries","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["cb36f8ec2","f186f90e5"],"commit_groups":[["cb36f8ec2","f186f90e5"]],"commits":["f186f90e5"],"cves":[],"db_id":"90a957ac31162ec698d5b94b49a40c6f","html":"\u003cp\u003eFix build failure when an old version of \u003ccode\u003elibpq_fe.h\u003c/code\u003e is present in system include directories (Tom Lane) \u003ca href=\"https://postgr.es/c/f186f90e5\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-277d2ff2ba18f1fa","identity_text":"Fix build failure when an old version of libpq_fe.h is present in system include directories (Tom Lane)","part":"changes","patch_ids":["eeffc9704828887ca584ad5271c75467"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["f186f90e5"],"source_entry_id":"17.5/changes/057","source_hash":"3d3c63d2b721fde7c6fb7a13104df5f02c01b4c474b20097062b2beed71e84b6","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"298dfeada71ab57b70ba273250758000a5b4bc89167836ff5b7bae2e7d5d5439","text":"Fix build failure when an old version of libpq_fe.h is present in system include directories (Tom Lane) §","title":"Fix build failure when an old version of libpq_fe.h is present in system include directories","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["0de9560ba","6da2ba1d8","71790aef1","915e88968","a39eb9c77","e4440a73c"],"commit_groups":[["0de9560ba","6da2ba1d8","71790aef1","915e88968","a39eb9c77","e4440a73c"]],"commits":["915e88968"],"cves":[],"db_id":"de586d1393e514a8fd81f47aaa090f70","html":"\u003cp\u003eFix build failure on macOS 15.4 (Tom Lane, Peter Eisentraut) \u003ca href=\"https://postgr.es/c/915e88968\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThis macOS update broke our configuration probe for \u003ccode\u003estrchrnul()\u003c/code\u003e.\u003c/p\u003e","id":"17.5-d6e8a72bfcea4b53","identity_text":"Fix build failure on macOS 15.4 (Tom Lane, Peter Eisentraut) This macOS update broke our configuration probe for strchrnul().","part":"changes","patch_ids":["2c43c28d6c52dc62356a0bdf9130845e"],"related_changes":[{"db_id":"d81851b981e6555614e00ec1b2accc47","evidence":{"patch_ids":["2c43c28d6c52dc62356a0bdf9130845e"],"same_day":true,"statement_hash":"dc558bd7f237a01581ee701a0432e3c4e6a8a5891bf7de9f894b410cd957d189"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Fix build failure on macOS 15.4","url":"/docs/compare/?release=16.9#16.9-d09a72f3b5c71225","version":"16.9"},{"db_id":"b63702f305707fa1db21237db0526102","evidence":{"patch_ids":["2c43c28d6c52dc62356a0bdf9130845e"],"same_day":true,"statement_hash":"dc558bd7f237a01581ee701a0432e3c4e6a8a5891bf7de9f894b410cd957d189"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Fix build failure on macOS 15.4","url":"/docs/compare/?release=15.13#15.13-6538bafc805a3489","version":"15.13"},{"db_id":"ff82d3e77efcd654ca0d58a8b8a7b301","evidence":{"patch_ids":["2c43c28d6c52dc62356a0bdf9130845e"],"same_day":true,"statement_hash":"dc558bd7f237a01581ee701a0432e3c4e6a8a5891bf7de9f894b410cd957d189"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Fix build failure on macOS 15.4","url":"/docs/compare/?release=14.18#14.18-9c9b5926d69ff118","version":"14.18"},{"db_id":"df8ba4ebb72714714838bb3067224a56","evidence":{"patch_ids":["2c43c28d6c52dc62356a0bdf9130845e"],"same_day":true,"statement_hash":"dc558bd7f237a01581ee701a0432e3c4e6a8a5891bf7de9f894b410cd957d189"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Fix build failure on macOS 15.4","url":"/docs/compare/?release=13.21#13.21-1d245447bc27aad2","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["2c43c28d6c52dc62356a0bdf9130845e"],"same_day":true,"statement_hash":"dc558bd7f237a01581ee701a0432e3c4e6a8a5891bf7de9f894b410cd957d189"},"rule":2,"target":"b63702f305707fa1db21237db0526102","type":"equivalent"},{"evidence":{"patch_ids":["2c43c28d6c52dc62356a0bdf9130845e"],"same_day":true,"statement_hash":"dc558bd7f237a01581ee701a0432e3c4e6a8a5891bf7de9f894b410cd957d189"},"rule":2,"target":"d81851b981e6555614e00ec1b2accc47","type":"equivalent"},{"evidence":{"patch_ids":["2c43c28d6c52dc62356a0bdf9130845e"],"same_day":true,"statement_hash":"dc558bd7f237a01581ee701a0432e3c4e6a8a5891bf7de9f894b410cd957d189"},"rule":2,"target":"df8ba4ebb72714714838bb3067224a56","type":"equivalent"},{"evidence":{"patch_ids":["2c43c28d6c52dc62356a0bdf9130845e"],"same_day":true,"statement_hash":"dc558bd7f237a01581ee701a0432e3c4e6a8a5891bf7de9f894b410cd957d189"},"rule":2,"target":"ff82d3e77efcd654ca0d58a8b8a7b301","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["915e88968"],"source_entry_id":"17.5/changes/058","source_hash":"b86c1b55597f6cbbafa0f80cd63463a229a996c69c7ecdbcf5ce1121e2f0be60","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"dc558bd7f237a01581ee701a0432e3c4e6a8a5891bf7de9f894b410cd957d189","text":"Fix build failure on macOS 15.4 (Tom Lane, Peter Eisentraut) § This macOS update broke our configuration probe for strchrnul().","title":"Fix build failure on macOS 15.4","variants":[],"version":"17.5"},{"also_in":[],"category":"bugfix","category_label":"Bug fixes","commit_aliases":["2509b857c","2a8a00674","57dca6faa"],"commit_groups":[["2509b857c","57dca6faa"],["2a8a00674"]],"commits":["57dca6faa"],"cves":[],"db_id":"c6006e297ecf4038064cd1324250371a","html":"\u003cp\u003eFix valgrind labeling of per-buffer data of read streams (Thomas Munro) \u003ca href=\"https://postgr.es/c/57dca6faa\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThis affects no core code in released versions of \u003cspan\u003ePostgreSQL\u003c/span\u003e, but an extension using the per-buffer data feature might have encountered spurious failures when being tested under valgrind.\u003c/p\u003e","id":"17.5-78ef6df2040d37e7","identity_text":"Fix valgrind labeling of per-buffer data of read streams (Thomas Munro) This affects no core code in released versions of PostgreSQL, but an extension using the per-buffer data feature might have encountered spurious failures when being tested under valgrind.","part":"changes","patch_ids":["491722e2b97dbaeb2888757ef951adce","d7cb4d88d5e633a66c791dab78fc17aa"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["2a8a00674","57dca6faa"],"source_entry_id":"17.5/changes/059","source_hash":"274259667367bb8986ecfc5bc79d9a4747768ca05b611b8e37cc5e837d54c741","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"ea7fd31dbfa9be720f1721891c1b9aaccecce920825505fcbe565b8ce8132714","text":"Fix valgrind labeling of per-buffer data of read streams (Thomas Munro) § This affects no core code in released versions of PostgreSQL, but an extension using the per-buffer data feature might have encountered spurious failures when being tested under valgrind.","title":"Fix valgrind labeling of per-buffer data of read streams","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["0600d276d","fde7c0164"],"commit_groups":[["0600d276d","fde7c0164"]],"commits":["fde7c0164"],"cves":[],"db_id":"1f341c0f67dfa32ebeb22ab0463e650b","html":"\u003cp\u003eAvoid valgrind complaints about string hashing code (John Naylor) \u003ca href=\"https://postgr.es/c/fde7c0164\"\u003e§\u003c/a\u003e\u003c/p\u003e","id":"17.5-ef528f149d478c78","identity_text":"Avoid valgrind complaints about string hashing code (John Naylor)","part":"changes","patch_ids":["87fc177fd7286e5d7228fe1945112c77"],"related_changes":[],"relations":[],"section":"Changes","section_path":["Changes"],"source_commits":["fde7c0164"],"source_entry_id":"17.5/changes/060","source_hash":"1c6833d0f5dc0a2d330b2412c1183a030b72fa397987440f6b827220cb5cfff3","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"4bf381bd6569b8a6a184430a7870d66d2bf517ddfbdf9674ee35d21f3bea62c2","text":"Avoid valgrind complaints about string hashing code (John Naylor) §","title":"Avoid valgrind complaints about string hashing code","variants":[],"version":"17.5"},{"also_in":[],"category":"improvement","category_label":"Improvements","commit_aliases":["368c3fbf9","5d5970b9f","9da548df3","a144cf145","e076120d9","fa4244a43"],"commit_groups":[["368c3fbf9","5d5970b9f","9da548df3","a144cf145","e076120d9","fa4244a43"]],"commits":["5d5970b9f"],"cves":[],"db_id":"b46b51b6ab58678c9616193380655da3","html":"\u003cp\u003eUpdate time zone data files to \u003cspan\u003etzdata\u003c/span\u003e release 2025b for DST law changes in Chile, plus historical corrections for Iran (Tom Lane) \u003ca href=\"https://postgr.es/c/5d5970b9f\"\u003e§\u003c/a\u003e\u003c/p\u003e\n\u003cp\u003eThere is a new time zone America/Coyhaique for Chile's Aysén Region, to account for it changing to UTC-03 year-round and thus diverging from America/Santiago.\u003c/p\u003e","id":"17.5-1787eeef076438cb","identity_text":"Update time zone data files to tzdata release 2025b for DST law changes in Chile, plus historical corrections for Iran (Tom Lane) There is a new time zone America/Coyhaique for Chile's Aysén Region, to account for it changing to UTC-03 year-round and thus diverging from America/Santiago.","part":"changes","patch_ids":["37a58a33f41e391eeea747c321eac090"],"related_changes":[{"db_id":"89bbdc6060fef88d085afd6409e10416","evidence":{"patch_ids":["37a58a33f41e391eeea747c321eac090"],"same_day":true,"statement_hash":"c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4"},"kind":"equivalent","label":"16.9","source_url":"/docs/release/16.9/#RELEASE-16-9-CHANGES","title":"Update time zone data files to tzdata release 2025b for DST law changes in Chile, plus historical corrections for Iran","url":"/docs/compare/?release=16.9#16.9-edae619b47bafc29","version":"16.9"},{"db_id":"2e73cf839c165cbbaf867b7175690bd0","evidence":{"patch_ids":["37a58a33f41e391eeea747c321eac090"],"same_day":true,"statement_hash":"c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4"},"kind":"equivalent","label":"15.13","source_url":"/docs/release/15.13/#id-1.11.6.12.5","title":"Update time zone data files to tzdata release 2025b for DST law changes in Chile, plus historical corrections for Iran","url":"/docs/compare/?release=15.13#15.13-7905b2aef76f37fd","version":"15.13"},{"db_id":"85360ac1e18899dc279978e17903e0fd","evidence":{"patch_ids":["37a58a33f41e391eeea747c321eac090"],"same_day":true,"statement_hash":"c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4"},"kind":"equivalent","label":"14.18","source_url":"/docs/release/14.18/#id-1.11.6.12.5","title":"Update time zone data files to tzdata release 2025b for DST law changes in Chile, plus historical corrections for Iran","url":"/docs/compare/?release=14.18#14.18-08e4060ba79b5c53","version":"14.18"},{"db_id":"c1730518d55761ba90941aa06c170dfb","evidence":{"patch_ids":["37a58a33f41e391eeea747c321eac090"],"same_day":true,"statement_hash":"c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4"},"kind":"equivalent","label":"13.21","source_url":"/docs/release/13.21/#id-1.11.6.8.6","title":"Update time zone data files to tzdata release 2025b for DST law changes in Chile, plus historical corrections for Iran","url":"/docs/compare/?release=13.21#13.21-fa15b367f3d46c9d","version":"13.21"}],"relations":[{"evidence":{"patch_ids":["37a58a33f41e391eeea747c321eac090"],"same_day":true,"statement_hash":"c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4"},"rule":2,"target":"2e73cf839c165cbbaf867b7175690bd0","type":"equivalent"},{"evidence":{"patch_ids":["37a58a33f41e391eeea747c321eac090"],"same_day":true,"statement_hash":"c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4"},"rule":2,"target":"85360ac1e18899dc279978e17903e0fd","type":"equivalent"},{"evidence":{"patch_ids":["37a58a33f41e391eeea747c321eac090"],"same_day":true,"statement_hash":"c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4"},"rule":2,"target":"89bbdc6060fef88d085afd6409e10416","type":"equivalent"},{"evidence":{"patch_ids":["37a58a33f41e391eeea747c321eac090"],"same_day":true,"statement_hash":"c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4"},"rule":2,"target":"c1730518d55761ba90941aa06c170dfb","type":"equivalent"}],"section":"Changes","section_path":["Changes"],"source_commits":["5d5970b9f"],"source_entry_id":"17.5/changes/061","source_hash":"162778503a7ccc4a487dfcb0fd2c1a4a1147a3e60e11eb85a122c3a26963e300","source_url":"/docs/release/17.5/#RELEASE-17-5-CHANGES","statement_hash":"c09a94c4e1b7ddfa12a3f8c5c4ab5fff67151ab86b10b4c4da218d744a15f8b4","text":"Update time zone data files to tzdata release 2025b for DST law changes in Chile, plus historical corrections for Iran (Tom Lane) § There is a new time zone America/Coyhaique for Chile's Aysén Region, to account for it changing to UTC-03 year-round and thus diverging from America/Santiago.","title":"Update time zone data files to tzdata release 2025b for DST law changes in Chile, plus historical corrections for Iran","variants":[],"version":"17.5"}],"entry_count":61,"eol":"2029-11-08","eol_date":"2029-11-08","label":"17.5","major":"17","manual":"17","manual_build":"17.11","manual_url":"/docs/17/release-17-5.html","migration_html":"\u003cp\u003eA dump/restore is not required for those running 17.X.\u003c/p\u003e\n\u003cp\u003eHowever, if you have any self-referential foreign key constraints on partitioned tables, it may be necessary to recreate those constraints to ensure that they are being enforced correctly. See the second changelog entry below.\u003c/p\u003e\n\u003cp\u003eAlso, if you have any BRIN bloom indexes, it may be advisable to reindex them after updating. See the third changelog entry below.\u003c/p\u003e\n\u003cp\u003eAlso, if you are upgrading from a version earlier than 17.1, see \u003ca href=\"/docs/17/release-17-1.html\" title=\"E.11. Release 17.1\"\u003eSection E.11\u003c/a\u003e.\u003c/p\u003e","minor":5,"placeholder":false,"source_as_of":"","source_url":"/docs/release/17.5/","status":"stable","status_label":"Supported","support_days":1092,"supported":true,"version":"17.5"}],"mode":"release","release_count":1,"remaining_cves":[],"security_as_of":"2026-09-26","security_regressions":[],"source_as_of":"2026-09-26","stats":[{"count":61,"key":"all","label":"All changes"},{"count":0,"key":"feature","label":"Features"},{"count":28,"key":"bugfix","label":"Bug fixes"},{"count":1,"key":"security","label":"Security"},{"count":0,"key":"performance","label":"Performance"},{"count":0,"key":"compatibility","label":"Compatibility"},{"count":32,"key":"improvement","label":"Improvements"}],"to_release":{"age_days":553,"build":"17.5","changes_count":61,"compatibility_count":0,"content_hash":"6f6271e72a010ddbca12968df7f7a798728b72bccb0e56b6679a663d0d959e9c","date":"2025-05-08","date_text":"2025-05-08","doc_git":"","doc_loaded_at":"2026-09-25T02:22:44.760693","entry_count":61,"eol":"2029-11-08","eol_date":"2029-11-08","label":"17.5","major":"17","manual":"17","manual_build":"17.11","manual_url":"/docs/17/release-17-5.html","migration_html":"\u003cp\u003eA dump/restore is not required for those running 17.X.\u003c/p\u003e\n\u003cp\u003eHowever, if you have any self-referential foreign key constraints on partitioned tables, it may be necessary to recreate those constraints to ensure that they are being enforced correctly. See the second changelog entry below.\u003c/p\u003e\n\u003cp\u003eAlso, if you have any BRIN bloom indexes, it may be advisable to reindex them after updating. See the third changelog entry below.\u003c/p\u003e\n\u003cp\u003eAlso, if you are upgrading from a version earlier than 17.1, see \u003ca href=\"/docs/17/release-17-1.html\" title=\"E.11. Release 17.1\"\u003eSection E.11\u003c/a\u003e.\u003c/p\u003e","minor":5,"placeholder":false,"source_as_of":"","source_url":"/docs/release/17.5/","status":"stable","status_label":"Supported","support_days":1092,"supported":true,"version":"17.5"},"total":61,"warnings":[]}