A dump/restore is not required for those running 12.X.
\nHowever, if you are upgrading from a version earlier than 12.2, see Section E.21.
", "compatibility_count": 0, "label": "12.5", "status_label": "Historical", "eol": "2024-11-21", "age_days": 2147, "support_days": -677}, "groups": [{"date": "2020-11-12", "build": "12.5", "major": "12", "minor": 5, "manual": "12", "status": "stable", "doc_git": "", "version": "12.5", "eol_date": "2024-11-21", "date_text": "2020-11-12", "supported": false, "manual_url": "/docs/12/release-12-5.html", "source_url": "/docs/release/12.5/", "entry_count": 58, "placeholder": false, "content_hash": "8b0ca2b6bf2ee85d9b3b91e4f1cfd27470801ac5fbd72026c1611617c72db856", "manual_build": "12.22", "source_as_of": "", "changes_count": 58, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 12.X.
\nHowever, if you are upgrading from a version earlier than 12.2, see Section E.21.
", "compatibility_count": 0, "label": "12.5", "status_label": "Historical", "eol": "2024-11-21", "age_days": 2147, "support_days": -677, "entries": [{"id": "12.5-58ffc2453b836b7c", "cves": ["CVE-2020-25695"], "html": "Block DECLARE CURSOR ... WITH HOLD and firing of deferred triggers within index expressions and materialized view queries (Noah Misch) §
This is essentially a leak in the “security restricted operation” sandbox mechanism. An attacker having permission to create non-temporary SQL objects could parlay this leak to execute arbitrary SQL code as a superuser.
\nThe PostgreSQL Project thanks Etienne Stalmans for reporting this problem. (CVE-2020-25695)
", "text": "Block DECLARE CURSOR ... WITH HOLD and firing of deferred triggers within index expressions and materialized view queries (Noah Misch) § This is essentially a leak in the “security restricted operation” sandbox mechanism. An attacker having permission to create non-temporary SQL objects could parlay this leak to execute arbitrary SQL code as a superuser. The PostgreSQL Project thanks Etienne Stalmans for reporting this problem. (CVE-2020-25695)", "title": "Block DECLARE CURSOR ... WITH HOLD and firing of deferred triggers within index expressions and materialized view queries", "commits": ["ac8f6243c"], "section": "Changes", "category": "security", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "45a39c6b0f7bd6a435d12091ee8109ca663a82dabe33886133d1611e61518ef0", "section_path": ["Changes"], "commit_groups": [["0c3185e96", "43ebfea5a", "ac8f6243c", "aefc625de", "c90c84b3f", "f97ecea1e", "ff3de4c21"]], "identity_text": "Block DECLARE CURSOR ... WITH HOLD and firing of deferred triggers within index expressions and materialized view queries (Noah Misch) This is essentially a leak in the security restricted operation sandbox mechanism. An attacker having permission to create non-temporary SQL objects could parlay this leak to execute arbitrary SQL code as a superuser. The PostgreSQL Project thanks Etienne Stalmans for reporting this problem. (CVE-2020-25695)", "commit_aliases": ["0c3185e96", "43ebfea5a", "ac8f6243c", "aefc625de", "c90c84b3f", "f97ecea1e", "ff3de4c21"], "source_commits": ["ac8f6243c"], "source_entry_id": "12.5/changes/001", "db_id": "754d0fa35c630453e7e8be4195e0d8a5", "patch_ids": ["e898d0dfc6b33d9b63abd3fb0e8b1a11"], "statement_hash": "2795b2a9007ce3ac53806d982078b9bd14dcfd9c5923177aaaf24805ed203d24", "relations": [{"rule": 2, "type": "equivalent", "target": "27b2bc4c97af3cc7f3e3232b22c140cb", "evidence": {"same_day": true, "patch_ids": ["e898d0dfc6b33d9b63abd3fb0e8b1a11"], "statement_hash": "2795b2a9007ce3ac53806d982078b9bd14dcfd9c5923177aaaf24805ed203d24"}}, {"rule": 2, "type": "equivalent", "target": "32a38be39164587561246274bce57c11", "evidence": {"same_day": true, "patch_ids": ["e898d0dfc6b33d9b63abd3fb0e8b1a11"], "statement_hash": "2795b2a9007ce3ac53806d982078b9bd14dcfd9c5923177aaaf24805ed203d24"}}, {"rule": 2, "type": "equivalent", "target": "b80a99246721d0a6d0290a38f05221c7", "evidence": {"same_day": true, "patch_ids": ["e898d0dfc6b33d9b63abd3fb0e8b1a11"], "statement_hash": "2795b2a9007ce3ac53806d982078b9bd14dcfd9c5923177aaaf24805ed203d24"}}, {"rule": 2, "type": "equivalent", "target": "c1e18d9b246a26244718162c48be2564", "evidence": {"same_day": true, "patch_ids": ["e898d0dfc6b33d9b63abd3fb0e8b1a11"], "statement_hash": "2795b2a9007ce3ac53806d982078b9bd14dcfd9c5923177aaaf24805ed203d24"}}, {"rule": 2, "type": "equivalent", "target": "d25e683f09292446d7a493aa4076cf0a", "evidence": {"same_day": true, "patch_ids": ["e898d0dfc6b33d9b63abd3fb0e8b1a11"], "statement_hash": "2795b2a9007ce3ac53806d982078b9bd14dcfd9c5923177aaaf24805ed203d24"}}], "version": "12.5", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "d25e683f09292446d7a493aa4076cf0a", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Block DECLARE CURSOR ... WITH HOLD and firing of deferred triggers within index expressions and materialized view queries", "evidence": {"same_day": true, "patch_ids": ["e898d0dfc6b33d9b63abd3fb0e8b1a11"], "statement_hash": "2795b2a9007ce3ac53806d982078b9bd14dcfd9c5923177aaaf24805ed203d24"}, "url": "/docs/compare/?release=13.1#13.1-72b4bd56189200a8", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}, {"db_id": "27b2bc4c97af3cc7f3e3232b22c140cb", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Block DECLARE CURSOR ... WITH HOLD and firing of deferred triggers within index expressions and materialized view queries", "evidence": {"same_day": true, "patch_ids": ["e898d0dfc6b33d9b63abd3fb0e8b1a11"], "statement_hash": "2795b2a9007ce3ac53806d982078b9bd14dcfd9c5923177aaaf24805ed203d24"}, "url": "/docs/compare/?release=11.10#11.10-8d0573c737d42e9b", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "c1e18d9b246a26244718162c48be2564", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Block DECLARE CURSOR ... WITH HOLD and firing of deferred triggers within index expressions and materialized view queries", "evidence": {"same_day": true, "patch_ids": ["e898d0dfc6b33d9b63abd3fb0e8b1a11"], "statement_hash": "2795b2a9007ce3ac53806d982078b9bd14dcfd9c5923177aaaf24805ed203d24"}, "url": "/docs/compare/?release=10.15#10.15-8d0573c737d42e9b", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "32a38be39164587561246274bce57c11", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Block DECLARE CURSOR ... WITH HOLD and firing of deferred triggers within index expressions and materialized view queries", "evidence": {"same_day": true, "patch_ids": ["e898d0dfc6b33d9b63abd3fb0e8b1a11"], "statement_hash": "2795b2a9007ce3ac53806d982078b9bd14dcfd9c5923177aaaf24805ed203d24"}, "url": "/docs/compare/?release=9.6.20#9.6.20-8d0573c737d42e9b", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "b80a99246721d0a6d0290a38f05221c7", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Block DECLARE CURSOR ... WITH HOLD and firing of deferred triggers within index expressions and materialized view queries", "evidence": {"same_day": true, "patch_ids": ["e898d0dfc6b33d9b63abd3fb0e8b1a11"], "statement_hash": "2795b2a9007ce3ac53806d982078b9bd14dcfd9c5923177aaaf24805ed203d24"}, "url": "/docs/compare/?release=9.5.24#9.5.24-8d0573c737d42e9b", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-66ca83b99f74f9b0", "cves": ["CVE-2020-25694"], "html": "Fix usage of complex connection-string parameters in pg_dump, pg_restore, clusterdb, reindexdb, and vacuumdb (Tom Lane) § §
\nThe -d parameter of pg_dump and pg_restore, or the --maintenance-db parameter of the other programs mentioned, can be a “connection string” containing multiple connection parameters rather than just a database name. In cases where these programs need to initiate additional connections, such as parallel processing or processing of multiple databases, the connection string was forgotten and just the basic connection parameters (database name, host, port, and username) were used for the additional connections. This could lead to connection failures if the connection string included any other essential information, such as non-default SSL or GSS parameters. Worse, the connection might succeed but not be encrypted as intended, or be vulnerable to man-in-the-middle attacks that the intended connection parameters would have prevented. (CVE-2020-25694)
When psql's \\connect command re-uses connection parameters, ensure that all non-overridden parameters from a previous connection string are re-used (Tom Lane) §
This avoids cases where reconnection might fail due to omission of relevant parameters, such as non-default SSL or GSS options. Worse, the reconnection might succeed but not be encrypted as intended, or be vulnerable to man-in-the-middle attacks that the intended connection parameters would have prevented. This is largely the same problem as just cited for pg_dump et al, although psql's behavior is more complex since the user may intentionally override some connection parameters. (CVE-2020-25694)
", "text": "When psql's \\connect command re-uses connection parameters, ensure that all non-overridden parameters from a previous connection string are re-used (Tom Lane) § This avoids cases where reconnection might fail due to omission of relevant parameters, such as non-default SSL or GSS options. Worse, the reconnection might succeed but not be encrypted as intended, or be vulnerable to man-in-the-middle attacks that the intended connection parameters would have prevented. This is largely the same problem as just cited for pg_dump et al, although psql's behavior is more complex since the user may intentionally override some connection parameters. (CVE-2020-25694)", "title": "When psql's \\connect command re-uses connection parameters, ensure that all non-overridden parameters from a previous connection string are re-used", "commits": ["f656517ec"], "section": "Changes", "category": "security", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "ebfc15e6666ae869642f91b81e3ecc9fd54d6d96430fe2a17641fdff70b586e9", "section_path": ["Changes"], "commit_groups": [["20be76d5c", "2e4af4110", "6997da09a", "8175da6e7", "85c54287a", "870a23230", "f656517ec"]], "identity_text": "When psql's \\connect command re-uses connection parameters, ensure that all non-overridden parameters from a previous connection string are re-used (Tom Lane) This avoids cases where reconnection might fail due to omission of relevant parameters, such as non-default SSL or GSS options. Worse, the reconnection might succeed but not be encrypted as intended, or be vulnerable to man-in-the-middle attacks that the intended connection parameters would have prevented. This is largely the same problem as just cited for pg_dump et al, although psql's behavior is more complex since the user may intentionally override some connection parameters. (CVE-2020-25694)", "commit_aliases": ["20be76d5c", "2e4af4110", "6997da09a", "8175da6e7", "85c54287a", "870a23230", "f656517ec"], "source_commits": ["f656517ec"], "source_entry_id": "12.5/changes/003", "db_id": "504ed64a289c20845de663a4c9b24733", "patch_ids": ["f12917222401547fc494ff9ed23244f8"], "statement_hash": "c429c25e5fedc5fe9b57bbe1c06653278c0be6639212de7e0e29caca1239c8af", "relations": [{"rule": 2, "type": "equivalent", "target": "048a4d116a491d8b2e54c00d82075af2", "evidence": {"same_day": true, "patch_ids": ["f12917222401547fc494ff9ed23244f8"], "statement_hash": "c429c25e5fedc5fe9b57bbe1c06653278c0be6639212de7e0e29caca1239c8af"}}, {"rule": 2, "type": "equivalent", "target": "09d652b358d89152448ded204db7f698", "evidence": {"same_day": true, "patch_ids": ["f12917222401547fc494ff9ed23244f8"], "statement_hash": "c429c25e5fedc5fe9b57bbe1c06653278c0be6639212de7e0e29caca1239c8af"}}, {"rule": 2, "type": "equivalent", "target": "33dcaa91db9a340ad489a4dab2bf38de", "evidence": {"same_day": true, "patch_ids": ["f12917222401547fc494ff9ed23244f8"], "statement_hash": "c429c25e5fedc5fe9b57bbe1c06653278c0be6639212de7e0e29caca1239c8af"}}, {"rule": 2, "type": "equivalent", "target": "9c07eaa4cc364eeece248d77060d68a6", "evidence": {"same_day": true, "patch_ids": ["f12917222401547fc494ff9ed23244f8"], "statement_hash": "c429c25e5fedc5fe9b57bbe1c06653278c0be6639212de7e0e29caca1239c8af"}}, {"rule": 2, "type": "equivalent", "target": "eb6bb7847df32de22ae4279f01bac757", "evidence": {"same_day": true, "patch_ids": ["f12917222401547fc494ff9ed23244f8"], "statement_hash": "c429c25e5fedc5fe9b57bbe1c06653278c0be6639212de7e0e29caca1239c8af"}}], "version": "12.5", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "33dcaa91db9a340ad489a4dab2bf38de", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "When psql's \\connect command re-uses connection parameters, ensure that all non-overridden parameters from a previous connection string are re-used", "evidence": {"same_day": true, "patch_ids": ["f12917222401547fc494ff9ed23244f8"], "statement_hash": "c429c25e5fedc5fe9b57bbe1c06653278c0be6639212de7e0e29caca1239c8af"}, "url": "/docs/compare/?release=13.1#13.1-f1badba1aaec4ac5", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}, {"db_id": "048a4d116a491d8b2e54c00d82075af2", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "When psql's \\connect command re-uses connection parameters, ensure that all non-overridden parameters from a previous connection string are re-used", "evidence": {"same_day": true, "patch_ids": ["f12917222401547fc494ff9ed23244f8"], "statement_hash": "c429c25e5fedc5fe9b57bbe1c06653278c0be6639212de7e0e29caca1239c8af"}, "url": "/docs/compare/?release=11.10#11.10-52aa2871324aa6e9", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "9c07eaa4cc364eeece248d77060d68a6", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "When psql's \\connect command re-uses connection parameters, ensure that all non-overridden parameters from a previous connection string are re-used", "evidence": {"same_day": true, "patch_ids": ["f12917222401547fc494ff9ed23244f8"], "statement_hash": "c429c25e5fedc5fe9b57bbe1c06653278c0be6639212de7e0e29caca1239c8af"}, "url": "/docs/compare/?release=10.15#10.15-52aa2871324aa6e9", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "09d652b358d89152448ded204db7f698", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "When psql's \\connect command re-uses connection parameters, ensure that all non-overridden parameters from a previous connection string are re-used", "evidence": {"same_day": true, "patch_ids": ["f12917222401547fc494ff9ed23244f8"], "statement_hash": "c429c25e5fedc5fe9b57bbe1c06653278c0be6639212de7e0e29caca1239c8af"}, "url": "/docs/compare/?release=9.6.20#9.6.20-52aa2871324aa6e9", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "eb6bb7847df32de22ae4279f01bac757", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "When psql's \\connect command re-uses connection parameters, ensure that all non-overridden parameters from a previous connection string are re-used", "evidence": {"same_day": true, "patch_ids": ["f12917222401547fc494ff9ed23244f8"], "statement_hash": "c429c25e5fedc5fe9b57bbe1c06653278c0be6639212de7e0e29caca1239c8af"}, "url": "/docs/compare/?release=9.5.24#9.5.24-52aa2871324aa6e9", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-729d850c2da92e5e", "cves": ["CVE-2020-25696"], "html": "Prevent psql's \\gset command from modifying specially-treated variables (Noah Misch) §
\\gset without a prefix would overwrite whatever variables the server told it to. Thus, a compromised server could set specially-treated variables such as PROMPT1, giving the ability to execute arbitrary shell code in the user's session.
The PostgreSQL Project thanks Nick Cleaton for reporting this problem. (CVE-2020-25696)
", "text": "Prevent psql's \\gset command from modifying specially-treated variables (Noah Misch) § \\gset without a prefix would overwrite whatever variables the server told it to. Thus, a compromised server could set specially-treated variables such as PROMPT1, giving the ability to execute arbitrary shell code in the user's session. The PostgreSQL Project thanks Nick Cleaton for reporting this problem. (CVE-2020-25696)", "title": "Prevent psql's \\gset command from modifying specially-treated variables", "commits": ["3855e5b47"], "section": "Changes", "category": "security", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "34ca492818c31a15f946bd19b0199488b9244cada30675d6bf2e90391bce2147", "section_path": ["Changes"], "commit_groups": [["098fb0079", "12fd81cb7", "3855e5b47", "67029845b", "7b356c78f", "a498db87b", "a54dfbee1"]], "identity_text": "Prevent psql's \\gset command from modifying specially-treated variables (Noah Misch) \\gset without a prefix would overwrite whatever variables the server told it to. Thus, a compromised server could set specially-treated variables such as PROMPT1, giving the ability to execute arbitrary shell code in the user's session. The PostgreSQL Project thanks Nick Cleaton for reporting this problem. (CVE-2020-25696)", "commit_aliases": ["098fb0079", "12fd81cb7", "3855e5b47", "67029845b", "7b356c78f", "a498db87b", "a54dfbee1"], "source_commits": ["3855e5b47"], "source_entry_id": "12.5/changes/004", "db_id": "684e218336a5bfa28d8f2dfa9d6632e6", "patch_ids": ["e7d80384f9cb93cf2c18f344e115c1c5"], "statement_hash": "5eecb4487916b732023d7b29b21dff0bacb46f067826f409f98fd30f36abb576", "relations": [{"rule": 2, "type": "equivalent", "target": "048000d3411816dd2fc965b0cd624522", "evidence": {"same_day": true, "patch_ids": ["e7d80384f9cb93cf2c18f344e115c1c5"], "statement_hash": "5eecb4487916b732023d7b29b21dff0bacb46f067826f409f98fd30f36abb576"}}, {"rule": 2, "type": "equivalent", "target": "370feb049d035ea22d0a1524d0be1028", "evidence": {"same_day": true, "patch_ids": ["e7d80384f9cb93cf2c18f344e115c1c5"], "statement_hash": "5eecb4487916b732023d7b29b21dff0bacb46f067826f409f98fd30f36abb576"}}, {"rule": 2, "type": "equivalent", "target": "435fccf471fec61c697ec3f4e10aac11", "evidence": {"same_day": true, "patch_ids": ["e7d80384f9cb93cf2c18f344e115c1c5"], "statement_hash": "5eecb4487916b732023d7b29b21dff0bacb46f067826f409f98fd30f36abb576"}}, {"rule": 2, "type": "equivalent", "target": "5a10d3cd862859a12f76a3057dc3036d", "evidence": {"same_day": true, "patch_ids": ["e7d80384f9cb93cf2c18f344e115c1c5"], "statement_hash": "5eecb4487916b732023d7b29b21dff0bacb46f067826f409f98fd30f36abb576"}}, {"rule": 2, "type": "equivalent", "target": "ed15ca1feec24d6238cd80fae70f0817", "evidence": {"same_day": true, "patch_ids": ["e7d80384f9cb93cf2c18f344e115c1c5"], "statement_hash": "5eecb4487916b732023d7b29b21dff0bacb46f067826f409f98fd30f36abb576"}}], "version": "12.5", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "ed15ca1feec24d6238cd80fae70f0817", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Prevent psql's \\gset command from modifying specially-treated variables", "evidence": {"same_day": true, "patch_ids": ["e7d80384f9cb93cf2c18f344e115c1c5"], "statement_hash": "5eecb4487916b732023d7b29b21dff0bacb46f067826f409f98fd30f36abb576"}, "url": "/docs/compare/?release=13.1#13.1-9070105c8a130c54", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}, {"db_id": "5a10d3cd862859a12f76a3057dc3036d", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Prevent psql's \\gset command from modifying specially-treated variables", "evidence": {"same_day": true, "patch_ids": ["e7d80384f9cb93cf2c18f344e115c1c5"], "statement_hash": "5eecb4487916b732023d7b29b21dff0bacb46f067826f409f98fd30f36abb576"}, "url": "/docs/compare/?release=11.10#11.10-7dc4e1c329885bcc", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "048000d3411816dd2fc965b0cd624522", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Prevent psql's \\gset command from modifying specially-treated variables", "evidence": {"same_day": true, "patch_ids": ["e7d80384f9cb93cf2c18f344e115c1c5"], "statement_hash": "5eecb4487916b732023d7b29b21dff0bacb46f067826f409f98fd30f36abb576"}, "url": "/docs/compare/?release=10.15#10.15-7dc4e1c329885bcc", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "370feb049d035ea22d0a1524d0be1028", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Prevent psql's \\gset command from modifying specially-treated variables", "evidence": {"same_day": true, "patch_ids": ["e7d80384f9cb93cf2c18f344e115c1c5"], "statement_hash": "5eecb4487916b732023d7b29b21dff0bacb46f067826f409f98fd30f36abb576"}, "url": "/docs/compare/?release=9.6.20#9.6.20-7dc4e1c329885bcc", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "435fccf471fec61c697ec3f4e10aac11", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Prevent psql's \\gset command from modifying specially-treated variables", "evidence": {"same_day": true, "patch_ids": ["e7d80384f9cb93cf2c18f344e115c1c5"], "statement_hash": "5eecb4487916b732023d7b29b21dff0bacb46f067826f409f98fd30f36abb576"}, "url": "/docs/compare/?release=9.5.24#9.5.24-7dc4e1c329885bcc", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-bcc58e84b0ea3b33", "cves": [], "html": "Prevent possible data loss from concurrent truncations of SLRU logs (Noah Misch) § §
\nThis rare problem would manifest in later “apparent wraparound” or “could not access status of transaction” errors.
", "text": "Prevent possible data loss from concurrent truncations of SLRU logs (Noah Misch) § § This rare problem would manifest in later “apparent wraparound” or “could not access status of transaction” errors.", "title": "Prevent possible data loss from concurrent truncations of SLRU logs", "commits": ["06e50d8f7", "30e68a2ab"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "0f97989ca2ef862f047350701956079452ae42c375406726e1563bca131da5e1", "section_path": ["Changes"], "commit_groups": [["06e50d8f7", "6af0b12a5", "85aa22cb1", "d8a22a387", "e8e44e890"], ["30e68a2ab", "3fbbf64ce", "566372b3d", "592a589a0", "5ae01df6f", "d4031d784", "e525770dd"]], "identity_text": "Prevent possible data loss from concurrent truncations of SLRU logs (Noah Misch) This rare problem would manifest in later apparent wraparound or could not access status of transaction errors.", "commit_aliases": ["06e50d8f7", "30e68a2ab", "3fbbf64ce", "566372b3d", "592a589a0", "5ae01df6f", "6af0b12a5", "85aa22cb1", "d4031d784", "d8a22a387", "e525770dd", "e8e44e890"], "source_commits": ["06e50d8f7", "30e68a2ab"], "source_entry_id": "12.5/changes/005", "db_id": "142e35fb126cfad46a4c91ec3c25b333", "patch_ids": ["59c84036c83e92632eb26a24f7169cc5", "e110a891c56974765e1d1c8995307adc"], "statement_hash": "3608d7c697c0d9f2eb5f8baff64ac9352cc06fd5f64dfdf21a60dbfec1f6a1df", "relations": [{"rule": 2, "type": "equivalent", "target": "4008c0c7b4bea421ebc95a611a6b3bb2", "evidence": {"same_day": true, "patch_ids": ["59c84036c83e92632eb26a24f7169cc5", "e110a891c56974765e1d1c8995307adc"], "statement_hash": "3608d7c697c0d9f2eb5f8baff64ac9352cc06fd5f64dfdf21a60dbfec1f6a1df"}}, {"rule": 2, "type": "equivalent", "target": "647df48e15d2e4550c179c178f286a29", "evidence": {"same_day": true, "patch_ids": ["59c84036c83e92632eb26a24f7169cc5", "e110a891c56974765e1d1c8995307adc"], "statement_hash": "3608d7c697c0d9f2eb5f8baff64ac9352cc06fd5f64dfdf21a60dbfec1f6a1df"}}, {"rule": 2, "type": "equivalent", "target": "9fe8cdab84f6de7b1358c60c093715c9", "evidence": {"same_day": true, "patch_ids": ["59c84036c83e92632eb26a24f7169cc5", "e110a891c56974765e1d1c8995307adc"], "statement_hash": "3608d7c697c0d9f2eb5f8baff64ac9352cc06fd5f64dfdf21a60dbfec1f6a1df"}}, {"rule": 2, "type": "equivalent", "target": "caa345643a6e9dcea5b73e8716e2cd8a", "evidence": {"same_day": true, "patch_ids": ["59c84036c83e92632eb26a24f7169cc5", "e110a891c56974765e1d1c8995307adc"], "statement_hash": "3608d7c697c0d9f2eb5f8baff64ac9352cc06fd5f64dfdf21a60dbfec1f6a1df"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "9fe8cdab84f6de7b1358c60c093715c9", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Prevent possible data loss from concurrent truncations of SLRU logs", "evidence": {"same_day": true, "patch_ids": ["59c84036c83e92632eb26a24f7169cc5", "e110a891c56974765e1d1c8995307adc"], "statement_hash": "3608d7c697c0d9f2eb5f8baff64ac9352cc06fd5f64dfdf21a60dbfec1f6a1df"}, "url": "/docs/compare/?release=11.10#11.10-8fcd08fc58452d2b", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "caa345643a6e9dcea5b73e8716e2cd8a", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Prevent possible data loss from concurrent truncations of SLRU logs", "evidence": {"same_day": true, "patch_ids": ["59c84036c83e92632eb26a24f7169cc5", "e110a891c56974765e1d1c8995307adc"], "statement_hash": "3608d7c697c0d9f2eb5f8baff64ac9352cc06fd5f64dfdf21a60dbfec1f6a1df"}, "url": "/docs/compare/?release=10.15#10.15-8fcd08fc58452d2b", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "4008c0c7b4bea421ebc95a611a6b3bb2", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Prevent possible data loss from concurrent truncations of SLRU logs", "evidence": {"same_day": true, "patch_ids": ["59c84036c83e92632eb26a24f7169cc5", "e110a891c56974765e1d1c8995307adc"], "statement_hash": "3608d7c697c0d9f2eb5f8baff64ac9352cc06fd5f64dfdf21a60dbfec1f6a1df"}, "url": "/docs/compare/?release=9.6.20#9.6.20-8fcd08fc58452d2b", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "647df48e15d2e4550c179c178f286a29", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Prevent possible data loss from concurrent truncations of SLRU logs", "evidence": {"same_day": true, "patch_ids": ["59c84036c83e92632eb26a24f7169cc5", "e110a891c56974765e1d1c8995307adc"], "statement_hash": "3608d7c697c0d9f2eb5f8baff64ac9352cc06fd5f64dfdf21a60dbfec1f6a1df"}, "url": "/docs/compare/?release=9.5.24#9.5.24-8fcd08fc58452d2b", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-3775a45a913e90e4", "cves": [], "html": "Ensure that SLRU directories are properly fsync'd during checkpoints (Thomas Munro) §
\nThis prevents possible data loss in a subsequent operating system crash.
", "text": "Ensure that SLRU directories are properly fsync'd during checkpoints (Thomas Munro) § This prevents possible data loss in a subsequent operating system crash.", "title": "Ensure that SLRU directories are properly fsync'd during checkpoints", "commits": ["7664cc869"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "adb87ae23d975005d14467905c45bda22adca7f995ef480e39991f91e23c0b70", "section_path": ["Changes"], "commit_groups": [["052014a20", "23d8b3577", "7664cc869", "aca74843e", "c5a5bd0bb", "d38e15979", "dd36d6b00"]], "identity_text": "Ensure that SLRU directories are properly fsync'd during checkpoints (Thomas Munro) This prevents possible data loss in a subsequent operating system crash.", "commit_aliases": ["052014a20", "23d8b3577", "7664cc869", "aca74843e", "c5a5bd0bb", "d38e15979", "dd36d6b00"], "source_commits": ["7664cc869"], "source_entry_id": "12.5/changes/006", "db_id": "4eccc1a2390eb87494a76e3a5985f5d3", "patch_ids": ["a2c4e9bfb6dc7d28acd67d5e9096d0d3"], "statement_hash": "fccebdc7516b398ea8dca003a5f4ce75d9a565c46bd658c74e04807ecda7c7d7", "relations": [{"rule": 2, "type": "equivalent", "target": "5be2e7c4790799ca4c539a2d54536a91", "evidence": {"same_day": true, "patch_ids": ["a2c4e9bfb6dc7d28acd67d5e9096d0d3"], "statement_hash": "fccebdc7516b398ea8dca003a5f4ce75d9a565c46bd658c74e04807ecda7c7d7"}}, {"rule": 2, "type": "equivalent", "target": "80cc9ce2bd43fa57595f97e3853bcd2c", "evidence": {"same_day": true, "patch_ids": ["a2c4e9bfb6dc7d28acd67d5e9096d0d3"], "statement_hash": "fccebdc7516b398ea8dca003a5f4ce75d9a565c46bd658c74e04807ecda7c7d7"}}, {"rule": 2, "type": "equivalent", "target": "aa4a15ce9bf437e318685c548b299a9b", "evidence": {"same_day": true, "patch_ids": ["a2c4e9bfb6dc7d28acd67d5e9096d0d3"], "statement_hash": "fccebdc7516b398ea8dca003a5f4ce75d9a565c46bd658c74e04807ecda7c7d7"}}, {"rule": 2, "type": "equivalent", "target": "b06ef39e998c1dc910700de06c681e9a", "evidence": {"same_day": true, "patch_ids": ["a2c4e9bfb6dc7d28acd67d5e9096d0d3"], "statement_hash": "fccebdc7516b398ea8dca003a5f4ce75d9a565c46bd658c74e04807ecda7c7d7"}}, {"rule": 2, "type": "equivalent", "target": "fb47558544b98f8abc71ea371925ccce", "evidence": {"same_day": true, "patch_ids": ["a2c4e9bfb6dc7d28acd67d5e9096d0d3"], "statement_hash": "fccebdc7516b398ea8dca003a5f4ce75d9a565c46bd658c74e04807ecda7c7d7"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b06ef39e998c1dc910700de06c681e9a", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Ensure that SLRU directories are properly fsync'd during checkpoints", "evidence": {"same_day": true, "patch_ids": ["a2c4e9bfb6dc7d28acd67d5e9096d0d3"], "statement_hash": "fccebdc7516b398ea8dca003a5f4ce75d9a565c46bd658c74e04807ecda7c7d7"}, "url": "/docs/compare/?release=13.1#13.1-fdad27ed414f6e2a", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}, {"db_id": "fb47558544b98f8abc71ea371925ccce", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Ensure that SLRU directories are properly fsync'd during checkpoints", "evidence": {"same_day": true, "patch_ids": ["a2c4e9bfb6dc7d28acd67d5e9096d0d3"], "statement_hash": "fccebdc7516b398ea8dca003a5f4ce75d9a565c46bd658c74e04807ecda7c7d7"}, "url": "/docs/compare/?release=11.10#11.10-a1d413abbcacd52c", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "5be2e7c4790799ca4c539a2d54536a91", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Ensure that SLRU directories are properly fsync'd during checkpoints", "evidence": {"same_day": true, "patch_ids": ["a2c4e9bfb6dc7d28acd67d5e9096d0d3"], "statement_hash": "fccebdc7516b398ea8dca003a5f4ce75d9a565c46bd658c74e04807ecda7c7d7"}, "url": "/docs/compare/?release=10.15#10.15-a1d413abbcacd52c", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "aa4a15ce9bf437e318685c548b299a9b", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Ensure that SLRU directories are properly fsync'd during checkpoints", "evidence": {"same_day": true, "patch_ids": ["a2c4e9bfb6dc7d28acd67d5e9096d0d3"], "statement_hash": "fccebdc7516b398ea8dca003a5f4ce75d9a565c46bd658c74e04807ecda7c7d7"}, "url": "/docs/compare/?release=9.6.20#9.6.20-a1d413abbcacd52c", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "80cc9ce2bd43fa57595f97e3853bcd2c", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Ensure that SLRU directories are properly fsync'd during checkpoints", "evidence": {"same_day": true, "patch_ids": ["a2c4e9bfb6dc7d28acd67d5e9096d0d3"], "statement_hash": "fccebdc7516b398ea8dca003a5f4ce75d9a565c46bd658c74e04807ecda7c7d7"}, "url": "/docs/compare/?release=9.5.24#9.5.24-a1d413abbcacd52c", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-f0bc8a0333a4e23a", "cves": [], "html": "Fix ALTER ROLE for users with the BYPASSRLS attribute (Tom Lane, Stephen Frost) §
The BYPASSRLS attribute is only allowed to be changed by superusers, but other ALTER ROLE operations, such as password changes, should be allowed with only ordinary permission checks. The previous coding erroneously restricted all changes on such a role to superusers.
Ensure that ALTER TABLE ONLY ... ENABLE/DISABLE TRIGGER does not recurse to child tables (Álvaro Herrera) §
Previously the ONLY flag was ignored.
Avoid unnecessary recursion to partitions in ALTER TABLE SET NOT NULL, when the target column is already marked NOT NULL (Tom Lane) §
This avoids a potential deadlock in parallel pg_restore.
", "text": "Avoid unnecessary recursion to partitions in ALTER TABLE SET NOT NULL, when the target column is already marked NOT NULL (Tom Lane) § This avoids a potential deadlock in parallel pg_restore.", "title": "Avoid unnecessary recursion to partitions in ALTER TABLE SET NOT NULL, when the target column is already marked NOT NULL", "commits": ["511690ec5"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "b6bbca5739056af215b095fc058e15bdd14d6591daa0cd06aedbb8d38e38fec5", "section_path": ["Changes"], "commit_groups": [["17280b31c", "511690ec5", "e5fac1cb1"]], "identity_text": "Avoid unnecessary recursion to partitions in ALTER TABLE SET NOT NULL, when the target column is already marked NOT NULL (Tom Lane) This avoids a potential deadlock in parallel pg_restore.", "commit_aliases": ["17280b31c", "511690ec5", "e5fac1cb1"], "source_commits": ["511690ec5"], "source_entry_id": "12.5/changes/009", "db_id": "b571734d32bd1cf2af24e0c5fcd1c36d", "patch_ids": ["faee22ef6a37a265040f6e4b8a0d3d3e"], "statement_hash": "f35632cac0a77c088cbe65669c7df89f781a4109c56cfc34bd8dd17c6a3a4a40", "relations": [], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "12.5-c05f13c9bb569892", "cves": [], "html": "Fix handling of expressions in CREATE TABLE LIKE with inheritance (Tom Lane) § §
If a CREATE TABLE command uses both LIKE and traditional inheritance, column references in CHECK constraints and expression indexes that came from a LIKE parent table tended to get mis-numbered, resulting in wrong answers and/or bizarre error messages. The same could happen in GENERATED expressions, in branches that have that feature.
Disallow DROP INDEX CONCURRENTLY on a partitioned table (Álvaro Herrera, Michael Paquier) §
This case failed anyway, but with a confusing error message.
", "text": "Disallow DROP INDEX CONCURRENTLY on a partitioned table (Álvaro Herrera, Michael Paquier) § This case failed anyway, but with a confusing error message.", "title": "Disallow DROP INDEX CONCURRENTLY on a partitioned table", "commits": ["7067ba1b4"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "504a4606f48ae5b469726fb9a6ffb0557e48e7bacd2d3c007b15fe9886f2f6c3", "section_path": ["Changes"], "commit_groups": [["15dad5776", "7067ba1b4", "afc7e0ad5", "f00f5e0c1"]], "identity_text": "Disallow DROP INDEX CONCURRENTLY on a partitioned table (Álvaro Herrera, Michael Paquier) This case failed anyway, but with a confusing error message.", "commit_aliases": ["15dad5776", "7067ba1b4", "afc7e0ad5", "f00f5e0c1"], "source_commits": ["7067ba1b4"], "source_entry_id": "12.5/changes/011", "db_id": "918820ea09118274cb315cdb541ca8d0", "patch_ids": ["0c18be1f8b08ff0528ee52d175db63ca"], "statement_hash": "c2fe75845d8bca010e280f6ec4a57442aec28569f701134e5eb23ee4c22cdae8", "relations": [{"rule": 2, "type": "equivalent", "target": "9cdc4f36c5032d5b9459ac37efd46633", "evidence": {"same_day": true, "patch_ids": ["0c18be1f8b08ff0528ee52d175db63ca"], "statement_hash": "c2fe75845d8bca010e280f6ec4a57442aec28569f701134e5eb23ee4c22cdae8"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "9cdc4f36c5032d5b9459ac37efd46633", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Disallow DROP INDEX CONCURRENTLY on a partitioned table", "evidence": {"same_day": true, "patch_ids": ["0c18be1f8b08ff0528ee52d175db63ca"], "statement_hash": "c2fe75845d8bca010e280f6ec4a57442aec28569f701134e5eb23ee4c22cdae8"}, "url": "/docs/compare/?release=11.10#11.10-0c45a740967c86c6", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}]}, {"id": "12.5-5c8f797b238b95d5", "cves": [], "html": "Allow LOCK TABLE to succeed on a self-referential view (Tom Lane) §
It previously threw an error complaining about infinite recursion, but there seems no need to disallow the case.
", "text": "Allow LOCK TABLE to succeed on a self-referential view (Tom Lane) § It previously threw an error complaining about infinite recursion, but there seems no need to disallow the case.", "title": "Allow LOCK TABLE to succeed on a self-referential view", "commits": ["0bdf1ef3d"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "c2be39848331991ec48fd2133ad3f578848df8513975857056938bbefe78f73a", "section_path": ["Changes"], "commit_groups": [["0bdf1ef3d", "44b973b91", "5b7bfc397", "7dc18c619"]], "identity_text": "Allow LOCK TABLE to succeed on a self-referential view (Tom Lane) It previously threw an error complaining about infinite recursion, but there seems no need to disallow the case.", "commit_aliases": ["0bdf1ef3d", "44b973b91", "5b7bfc397", "7dc18c619"], "source_commits": ["0bdf1ef3d"], "source_entry_id": "12.5/changes/012", "db_id": "b18cca0fe5884749592bcb9c306e8ed8", "patch_ids": ["e80a6d62a308549fca3dca43cf214e58"], "statement_hash": "c48c786d6aefa3b2ef2bde9f2098ebab17fa00b0da9d6978ef895b89fb823222", "relations": [{"rule": 2, "type": "equivalent", "target": "2d9a7d9cd258cf795bfe09ac728c2093", "evidence": {"same_day": true, "patch_ids": ["e80a6d62a308549fca3dca43cf214e58"], "statement_hash": "c48c786d6aefa3b2ef2bde9f2098ebab17fa00b0da9d6978ef895b89fb823222"}}, {"rule": 2, "type": "equivalent", "target": "3935a2bfda3c217a89c73379e751c30f", "evidence": {"same_day": true, "patch_ids": ["e80a6d62a308549fca3dca43cf214e58"], "statement_hash": "c48c786d6aefa3b2ef2bde9f2098ebab17fa00b0da9d6978ef895b89fb823222"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "2d9a7d9cd258cf795bfe09ac728c2093", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Allow LOCK TABLE to succeed on a self-referential view", "evidence": {"same_day": true, "patch_ids": ["e80a6d62a308549fca3dca43cf214e58"], "statement_hash": "c48c786d6aefa3b2ef2bde9f2098ebab17fa00b0da9d6978ef895b89fb823222"}, "url": "/docs/compare/?release=13.1#13.1-658bba060786a9be", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}, {"db_id": "3935a2bfda3c217a89c73379e751c30f", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Allow LOCK TABLE to succeed on a self-referential view", "evidence": {"same_day": true, "patch_ids": ["e80a6d62a308549fca3dca43cf214e58"], "statement_hash": "c48c786d6aefa3b2ef2bde9f2098ebab17fa00b0da9d6978ef895b89fb823222"}, "url": "/docs/compare/?release=11.10#11.10-fc4bcf5b57454f08", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}]}, {"id": "12.5-aad9ec0f4672573e", "cves": [], "html": "Retain statistics about an index across REINDEX CONCURRENTLY (Michael Paquier, Fabrízio de Royes Mello) §
Non-concurrent reindexing has always preserved such statistics.
", "text": "Retain statistics about an index across REINDEX CONCURRENTLY (Michael Paquier, Fabrízio de Royes Mello) § Non-concurrent reindexing has always preserved such statistics.", "title": "Retain statistics about an index across REINDEX CONCURRENTLY", "commits": ["41a033b50"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "89fd2e795595b12c15ba67f0e5bfe7727ddb6b05f2b3e16fb4e23d75d6347ec1", "section_path": ["Changes"], "commit_groups": [["41a033b50", "b17ff07aa", "bb62df46b"]], "identity_text": "Retain statistics about an index across REINDEX CONCURRENTLY (Michael Paquier, Fabrízio de Royes Mello) Non-concurrent reindexing has always preserved such statistics.", "commit_aliases": ["41a033b50", "b17ff07aa", "bb62df46b"], "source_commits": ["41a033b50"], "source_entry_id": "12.5/changes/013", "db_id": "6f499e8e479f0c4070ca4654bbffe8c5", "patch_ids": ["4616682d99b4a9614c6f50c95b8f9808"], "statement_hash": "df824fc429752478a9fa50b60c52c5b43407e36003b5466d2f7642bb0dd5d8ab", "relations": [{"rule": 2, "type": "equivalent", "target": "968d3cde895dc97b388757887ad30210", "evidence": {"same_day": true, "patch_ids": ["4616682d99b4a9614c6f50c95b8f9808"], "statement_hash": "df824fc429752478a9fa50b60c52c5b43407e36003b5466d2f7642bb0dd5d8ab"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "968d3cde895dc97b388757887ad30210", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Retain statistics about an index across REINDEX CONCURRENTLY", "evidence": {"same_day": true, "patch_ids": ["4616682d99b4a9614c6f50c95b8f9808"], "statement_hash": "df824fc429752478a9fa50b60c52c5b43407e36003b5466d2f7642bb0dd5d8ab"}, "url": "/docs/compare/?release=13.1#13.1-98a14985b3433129", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}]}, {"id": "12.5-93ed92223ac87f9a", "cves": [], "html": "Fix incorrect progress reporting from REINDEX CONCURRENTLY (Matthias van de Meent, Michael Paquier) §
Ensure that GENERATED columns are updated when the column(s) they depend on are updated via a rule or an updatable view (Tom Lane) §
This fix also takes care of possible failure to fire a column-specific trigger in such cases.
", "text": "Ensure that GENERATED columns are updated when the column(s) they depend on are updated via a rule or an updatable view (Tom Lane) § This fix also takes care of possible failure to fire a column-specific trigger in such cases.", "title": "Ensure that GENERATED columns are updated when the column(s) they depend on are updated via a rule or an updatable view", "commits": ["43330cdd4"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "0c2dfff6c407041c5b95e751f8ef0926798d4167623c6a157c4e21b0fc2339d7", "section_path": ["Changes"], "commit_groups": [["43330cdd4", "70492195b", "ad77039fa"]], "identity_text": "Ensure that GENERATED columns are updated when the column(s) they depend on are updated via a rule or an updatable view (Tom Lane) This fix also takes care of possible failure to fire a column-specific trigger in such cases.", "commit_aliases": ["43330cdd4", "70492195b", "ad77039fa"], "source_commits": ["43330cdd4"], "source_entry_id": "12.5/changes/015", "db_id": "32954ad404f6b50f2e286068e3f41e5a", "patch_ids": ["4eee3ee8c400465bab30b28c8d723ef0"], "statement_hash": "eff768f3c78ee5cbf1190b31ba0e199a717089101bc5523812af12ca673f8e66", "relations": [{"rule": 2, "type": "equivalent", "target": "a45fb8720bc700e17cab673f382333c0", "evidence": {"same_day": true, "patch_ids": ["4eee3ee8c400465bab30b28c8d723ef0"], "statement_hash": "eff768f3c78ee5cbf1190b31ba0e199a717089101bc5523812af12ca673f8e66"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "a45fb8720bc700e17cab673f382333c0", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Ensure that GENERATED columns are updated when the column(s) they depend on are updated via a rule or an updatable view", "evidence": {"same_day": true, "patch_ids": ["4eee3ee8c400465bab30b28c8d723ef0"], "statement_hash": "eff768f3c78ee5cbf1190b31ba0e199a717089101bc5523812af12ca673f8e66"}, "url": "/docs/compare/?release=13.1#13.1-b92d780874dfee1e", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}]}, {"id": "12.5-36e156ad83274672", "cves": [], "html": "Recheck default partition constraints while routing an inserted or updated tuple to the correct partition (Amit Langote, Álvaro Herrera) §
\nThis fixes race conditions when partitions are added concurrently with the insertion.
", "text": "Recheck default partition constraints while routing an inserted or updated tuple to the correct partition (Amit Langote, Álvaro Herrera) § This fixes race conditions when partitions are added concurrently with the insertion.", "title": "Recheck default partition constraints while routing an inserted or updated tuple to the correct partition", "commits": ["ef1e1250e"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "aa0b555bd2f09ecc2283ef1ef0b1ae2b4f5f3d91a789b0d472b1770bca899e7d", "section_path": ["Changes"], "commit_groups": [["d0230a43f", "ef1e1250e", "f481d2823"]], "identity_text": "Recheck default partition constraints while routing an inserted or updated tuple to the correct partition (Amit Langote, Álvaro Herrera) This fixes race conditions when partitions are added concurrently with the insertion.", "commit_aliases": ["d0230a43f", "ef1e1250e", "f481d2823"], "source_commits": ["ef1e1250e"], "source_entry_id": "12.5/changes/016", "db_id": "6f2a048c81ef864936b6d3d306f80f3d", "patch_ids": ["e96b529d65f941ebb84c10ee2b7154cc"], "statement_hash": "30c37a55362d83ccd75f6d5f8457064cc450bef17ab3e6a18e5f4d6ba736a4ab", "relations": [], "version": "12.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "12.5-a16c81750495646b", "cves": [], "html": "Fix failures with collation-dependent partition bound expressions (Tom Lane) §
", "text": "Fix failures with collation-dependent partition bound expressions (Tom Lane) §", "title": "Fix failures with collation-dependent partition bound expressions", "commits": ["29f20db85"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "0d962560a561061a0acc79ba71e53775be6adcf8060b3203a0678ad60244507d", "section_path": ["Changes"], "commit_groups": [["29f20db85", "61a78c71a", "72647ac3b"]], "identity_text": "Fix failures with collation-dependent partition bound expressions (Tom Lane)", "commit_aliases": ["29f20db85", "61a78c71a", "72647ac3b"], "source_commits": ["29f20db85"], "source_entry_id": "12.5/changes/017", "db_id": "e0a9794cb9f97d7ff10346b1d05f8fe2", "patch_ids": ["17920f371d7cd8c0a562e75329b01763"], "statement_hash": "61abd944044ae9390ecaae79d89a6d44bf926a75a31ba6a6d8683a7b3b259731", "relations": [{"rule": 2, "type": "equivalent", "target": "3aa94aaa97fbf3e45fb9a446ddb201ff", "evidence": {"same_day": true, "patch_ids": ["17920f371d7cd8c0a562e75329b01763"], "statement_hash": "61abd944044ae9390ecaae79d89a6d44bf926a75a31ba6a6d8683a7b3b259731"}}], "version": "12.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "3aa94aaa97fbf3e45fb9a446ddb201ff", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Fix failures with collation-dependent partition bound expressions", "evidence": {"same_day": true, "patch_ids": ["17920f371d7cd8c0a562e75329b01763"], "statement_hash": "61abd944044ae9390ecaae79d89a6d44bf926a75a31ba6a6d8683a7b3b259731"}, "url": "/docs/compare/?release=13.1#13.1-c89429de410fa194", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}]}, {"id": "12.5-517a824cfc0e71db", "cves": [], "html": "Support hashing of text arrays (Peter Eisentraut) §
\nArray hashing failed if the array element type is collatable. Notably, this prevented using hash partitioning with a text array column as partition key.
", "text": "Support hashing of text arrays (Peter Eisentraut) § Array hashing failed if the array element type is collatable. Notably, this prevented using hash partitioning with a text array column as partition key.", "title": "Support hashing of text arrays", "commits": ["ea9087938"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "61e85ac61f6cd72c8a966140273bb4ac26a72b083705d6dba40e32a3b3377269", "section_path": ["Changes"], "commit_groups": [["560564d3a", "82d4a2a7d", "ea9087938"]], "identity_text": "Support hashing of text arrays (Peter Eisentraut) Array hashing failed if the array element type is collatable. Notably, this prevented using hash partitioning with a text array column as partition key.", "commit_aliases": ["560564d3a", "82d4a2a7d", "ea9087938"], "source_commits": ["ea9087938"], "source_entry_id": "12.5/changes/018", "db_id": "f22891ac3918002c7c2efa185329bc78", "patch_ids": ["113621db64df6ffdcd3e25b5f5a174ad"], "statement_hash": "f6987b0505dbb0d9cc27b1bc10d127ca08fbd9257cda5bba707d544e40a0bf5f", "relations": [{"rule": 2, "type": "equivalent", "target": "93b6025e4e4e57c6621930dccc5f805a", "evidence": {"same_day": true, "patch_ids": ["113621db64df6ffdcd3e25b5f5a174ad"], "statement_hash": "f6987b0505dbb0d9cc27b1bc10d127ca08fbd9257cda5bba707d544e40a0bf5f"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "93b6025e4e4e57c6621930dccc5f805a", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Support hashing of text arrays", "evidence": {"same_day": true, "patch_ids": ["113621db64df6ffdcd3e25b5f5a174ad"], "statement_hash": "f6987b0505dbb0d9cc27b1bc10d127ca08fbd9257cda5bba707d544e40a0bf5f"}, "url": "/docs/compare/?release=13.1#13.1-c548f033df2a3cfd", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}]}, {"id": "12.5-4d8b4715108b70a4", "cves": [], "html": "Fix off-by-one conversion of negative years to BC dates in to_date() and to_timestamp() (Dar Alathar-Yemen, Tom Lane) §
Also, arrange for the combination of a negative year and an explicit “BC” marker to cancel out and produce AD.
", "text": "Fix off-by-one conversion of negative years to BC dates in to_date() and to_timestamp() (Dar Alathar-Yemen, Tom Lane) § Also, arrange for the combination of a negative year and an explicit “BC” marker to cancel out and produce AD.", "title": "Fix off-by-one conversion of negative years to BC dates in to_date() and to_timestamp()", "commits": ["c5232dca8"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "1064e47cf61c0dd81fc8ccc196c8478038161bde7152b939de7da54583365332", "section_path": ["Changes"], "commit_groups": [["19e798268", "4857e6fe1", "489c9c340", "99fd38c02", "b0fe0b022", "c5232dca8", "db96be24c"]], "identity_text": "Fix off-by-one conversion of negative years to BC dates in to_date() and to_timestamp() (Dar Alathar-Yemen, Tom Lane) Also, arrange for the combination of a negative year and an explicit BC marker to cancel out and produce AD.", "commit_aliases": ["19e798268", "4857e6fe1", "489c9c340", "99fd38c02", "b0fe0b022", "c5232dca8", "db96be24c"], "source_commits": ["c5232dca8"], "source_entry_id": "12.5/changes/019", "db_id": "76c32d6fff44d9fe7f6ce0693e97bd23", "patch_ids": ["da4f71a59db3b584259538afe5bece44"], "statement_hash": "cf5dea2934e0b734f3f2ada8610ca274cf4ea8d1d1be4c871000ab64bc4ccbec", "relations": [{"rule": 2, "type": "equivalent", "target": "2fd0b94406c1d907f7cb0ca75b2f92ae", "evidence": {"same_day": true, "patch_ids": ["da4f71a59db3b584259538afe5bece44"], "statement_hash": "cf5dea2934e0b734f3f2ada8610ca274cf4ea8d1d1be4c871000ab64bc4ccbec"}}, {"rule": 2, "type": "equivalent", "target": "428678237c4649112cd18135a78fceab", "evidence": {"same_day": true, "patch_ids": ["da4f71a59db3b584259538afe5bece44"], "statement_hash": "cf5dea2934e0b734f3f2ada8610ca274cf4ea8d1d1be4c871000ab64bc4ccbec"}}, {"rule": 2, "type": "equivalent", "target": "84784e380c670115a62107d0b20c4f11", "evidence": {"same_day": true, "patch_ids": ["da4f71a59db3b584259538afe5bece44"], "statement_hash": "cf5dea2934e0b734f3f2ada8610ca274cf4ea8d1d1be4c871000ab64bc4ccbec"}}, {"rule": 2, "type": "equivalent", "target": "c9d9de197271b1d2bd42dfae5adabae0", "evidence": {"same_day": true, "patch_ids": ["da4f71a59db3b584259538afe5bece44"], "statement_hash": "cf5dea2934e0b734f3f2ada8610ca274cf4ea8d1d1be4c871000ab64bc4ccbec"}}, {"rule": 2, "type": "equivalent", "target": "f41231159e971c7ec0aead8f8434fc68", "evidence": {"same_day": true, "patch_ids": ["da4f71a59db3b584259538afe5bece44"], "statement_hash": "cf5dea2934e0b734f3f2ada8610ca274cf4ea8d1d1be4c871000ab64bc4ccbec"}}], "version": "12.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2fd0b94406c1d907f7cb0ca75b2f92ae", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Fix off-by-one conversion of negative years to BC dates in to_date() and to_timestamp()", "evidence": {"same_day": true, "patch_ids": ["da4f71a59db3b584259538afe5bece44"], "statement_hash": "cf5dea2934e0b734f3f2ada8610ca274cf4ea8d1d1be4c871000ab64bc4ccbec"}, "url": "/docs/compare/?release=13.1#13.1-7d9550883a39e120", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}, {"db_id": "428678237c4649112cd18135a78fceab", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Fix off-by-one conversion of negative years to BC dates in to_date() and to_timestamp()", "evidence": {"same_day": true, "patch_ids": ["da4f71a59db3b584259538afe5bece44"], "statement_hash": "cf5dea2934e0b734f3f2ada8610ca274cf4ea8d1d1be4c871000ab64bc4ccbec"}, "url": "/docs/compare/?release=11.10#11.10-6abb5979d20e0e0d", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "c9d9de197271b1d2bd42dfae5adabae0", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Fix off-by-one conversion of negative years to BC dates in to_date() and to_timestamp()", "evidence": {"same_day": true, "patch_ids": ["da4f71a59db3b584259538afe5bece44"], "statement_hash": "cf5dea2934e0b734f3f2ada8610ca274cf4ea8d1d1be4c871000ab64bc4ccbec"}, "url": "/docs/compare/?release=10.15#10.15-6abb5979d20e0e0d", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "84784e380c670115a62107d0b20c4f11", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Fix off-by-one conversion of negative years to BC dates in to_date() and to_timestamp()", "evidence": {"same_day": true, "patch_ids": ["da4f71a59db3b584259538afe5bece44"], "statement_hash": "cf5dea2934e0b734f3f2ada8610ca274cf4ea8d1d1be4c871000ab64bc4ccbec"}, "url": "/docs/compare/?release=9.6.20#9.6.20-6abb5979d20e0e0d", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "f41231159e971c7ec0aead8f8434fc68", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Fix off-by-one conversion of negative years to BC dates in to_date() and to_timestamp()", "evidence": {"same_day": true, "patch_ids": ["da4f71a59db3b584259538afe5bece44"], "statement_hash": "cf5dea2934e0b734f3f2ada8610ca274cf4ea8d1d1be4c871000ab64bc4ccbec"}, "url": "/docs/compare/?release=9.5.24#9.5.24-6abb5979d20e0e0d", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-2b36622fcf63cc8d", "cves": [], "html": "Ensure that standby servers will archive WAL timeline history files when archive_mode is set to always (Grigory Smolkin, Fujii Masao) §
This oversight could lead to failure of subsequent PITR recovery attempts.
", "text": "Ensure that standby servers will archive WAL timeline history files when archive_mode is set to always (Grigory Smolkin, Fujii Masao) § This oversight could lead to failure of subsequent PITR recovery attempts.", "title": "Ensure that standby servers will archive WAL timeline history files when archive_mode is set to always", "commits": ["4d342b9d4"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "e07f9165119c27d926c70212dc2094b6938aea6679335bca42a37a40cb509f5e", "section_path": ["Changes"], "commit_groups": [["059caf36c", "334417538", "40a8fb1e0", "462ff7966", "4d342b9d4", "7be02a3bf", "fd26f7823"]], "identity_text": "Ensure that standby servers will archive WAL timeline history files when archive_mode is set to always (Grigory Smolkin, Fujii Masao) This oversight could lead to failure of subsequent PITR recovery attempts.", "commit_aliases": ["059caf36c", "334417538", "40a8fb1e0", "462ff7966", "4d342b9d4", "7be02a3bf", "fd26f7823"], "source_commits": ["4d342b9d4"], "source_entry_id": "12.5/changes/020", "db_id": "053c209c339b478e67a27125edb9d08e", "patch_ids": ["b93e2d7b5411b5d576ba054ba43323f9"], "statement_hash": "2ca3bd2d6b9f535b99ead4347a591d4486a7f1d97750c5ba17bb7fa2da698587", "relations": [{"rule": 2, "type": "equivalent", "target": "1da516870d70e895fa4515a85374ec9e", "evidence": {"same_day": true, "patch_ids": ["b93e2d7b5411b5d576ba054ba43323f9"], "statement_hash": "2ca3bd2d6b9f535b99ead4347a591d4486a7f1d97750c5ba17bb7fa2da698587"}}, {"rule": 2, "type": "equivalent", "target": "64226a4dd5aec9b9132c2923c3ee3d1c", "evidence": {"same_day": true, "patch_ids": ["b93e2d7b5411b5d576ba054ba43323f9"], "statement_hash": "2ca3bd2d6b9f535b99ead4347a591d4486a7f1d97750c5ba17bb7fa2da698587"}}, {"rule": 2, "type": "equivalent", "target": "6a9a910ffb65d51355590d4f0c108eb3", "evidence": {"same_day": true, "patch_ids": ["b93e2d7b5411b5d576ba054ba43323f9"], "statement_hash": "2ca3bd2d6b9f535b99ead4347a591d4486a7f1d97750c5ba17bb7fa2da698587"}}, {"rule": 2, "type": "equivalent", "target": "75be688416a161ae255e49f6b3ac3332", "evidence": {"same_day": true, "patch_ids": ["b93e2d7b5411b5d576ba054ba43323f9"], "statement_hash": "2ca3bd2d6b9f535b99ead4347a591d4486a7f1d97750c5ba17bb7fa2da698587"}}, {"rule": 2, "type": "equivalent", "target": "b27e4f45c04f28b1ef32f985c43dc224", "evidence": {"same_day": true, "patch_ids": ["b93e2d7b5411b5d576ba054ba43323f9"], "statement_hash": "2ca3bd2d6b9f535b99ead4347a591d4486a7f1d97750c5ba17bb7fa2da698587"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "64226a4dd5aec9b9132c2923c3ee3d1c", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Ensure that standby servers will archive WAL timeline history files when archive_mode is set to always", "evidence": {"same_day": true, "patch_ids": ["b93e2d7b5411b5d576ba054ba43323f9"], "statement_hash": "2ca3bd2d6b9f535b99ead4347a591d4486a7f1d97750c5ba17bb7fa2da698587"}, "url": "/docs/compare/?release=13.1#13.1-f18215fa3b715eca", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}, {"db_id": "6a9a910ffb65d51355590d4f0c108eb3", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Ensure that standby servers will archive WAL timeline history files when archive_mode is set to always", "evidence": {"same_day": true, "patch_ids": ["b93e2d7b5411b5d576ba054ba43323f9"], "statement_hash": "2ca3bd2d6b9f535b99ead4347a591d4486a7f1d97750c5ba17bb7fa2da698587"}, "url": "/docs/compare/?release=11.10#11.10-d0d61746c386be8d", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "b27e4f45c04f28b1ef32f985c43dc224", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Ensure that standby servers will archive WAL timeline history files when archive_mode is set to always", "evidence": {"same_day": true, "patch_ids": ["b93e2d7b5411b5d576ba054ba43323f9"], "statement_hash": "2ca3bd2d6b9f535b99ead4347a591d4486a7f1d97750c5ba17bb7fa2da698587"}, "url": "/docs/compare/?release=10.15#10.15-d0d61746c386be8d", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "1da516870d70e895fa4515a85374ec9e", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Ensure that standby servers will archive WAL timeline history files when archive_mode is set to always", "evidence": {"same_day": true, "patch_ids": ["b93e2d7b5411b5d576ba054ba43323f9"], "statement_hash": "2ca3bd2d6b9f535b99ead4347a591d4486a7f1d97750c5ba17bb7fa2da698587"}, "url": "/docs/compare/?release=9.6.20#9.6.20-d0d61746c386be8d", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "75be688416a161ae255e49f6b3ac3332", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Ensure that standby servers will archive WAL timeline history files when archive_mode is set to always", "evidence": {"same_day": true, "patch_ids": ["b93e2d7b5411b5d576ba054ba43323f9"], "statement_hash": "2ca3bd2d6b9f535b99ead4347a591d4486a7f1d97750c5ba17bb7fa2da698587"}, "url": "/docs/compare/?release=9.5.24#9.5.24-d0d61746c386be8d", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-b66c911717914165", "cves": [], "html": "Fix “cache lookup failed for relation 0” failures in logical replication workers (Tom Lane) §
\nThe real-world impact is small, since the failure is unlikely, and if it does happen the worker would just exit and be restarted.
", "text": "Fix “cache lookup failed for relation 0” failures in logical replication workers (Tom Lane) § The real-world impact is small, since the failure is unlikely, and if it does happen the worker would just exit and be restarted.", "title": "Fix “cache lookup failed for relation 0” failures in logical replication workers", "commits": ["8580631ff"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "c173b2f9dd5306e669931c7c1f5a197d2162af9a9b7f823ea2f7407d260dc76f", "section_path": ["Changes"], "commit_groups": [["2c74f7139", "3d65b0593", "3e3f8f202", "8580631ff", "d6d70f89a"]], "identity_text": "Fix cache lookup failed for relation 0 failures in logical replication workers (Tom Lane) The real-world impact is small, since the failure is unlikely, and if it does happen the worker would just exit and be restarted.", "commit_aliases": ["2c74f7139", "3d65b0593", "3e3f8f202", "8580631ff", "d6d70f89a"], "source_commits": ["8580631ff"], "source_entry_id": "12.5/changes/021", "db_id": "8c1531618861a5eb2d213fe7aaefdb44", "patch_ids": ["b3f4ce5a5b2c180084072f5f86d1510d"], "statement_hash": "f7cbfb42445608d79a07254be2610dab56c711ed55f1ad845464f034778b3feb", "relations": [{"rule": 2, "type": "equivalent", "target": "699bc8f76f46cdadc358bd8f4cdecea5", "evidence": {"same_day": true, "patch_ids": ["b3f4ce5a5b2c180084072f5f86d1510d"], "statement_hash": "f7cbfb42445608d79a07254be2610dab56c711ed55f1ad845464f034778b3feb"}}, {"rule": 2, "type": "equivalent", "target": "c620768b846ef6e1b003de9a4364d154", "evidence": {"same_day": true, "patch_ids": ["b3f4ce5a5b2c180084072f5f86d1510d"], "statement_hash": "f7cbfb42445608d79a07254be2610dab56c711ed55f1ad845464f034778b3feb"}}], "version": "12.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c620768b846ef6e1b003de9a4364d154", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Fix “cache lookup failed for relation 0” failures in logical replication workers", "evidence": {"same_day": true, "patch_ids": ["b3f4ce5a5b2c180084072f5f86d1510d"], "statement_hash": "f7cbfb42445608d79a07254be2610dab56c711ed55f1ad845464f034778b3feb"}, "url": "/docs/compare/?release=11.10#11.10-704c334d2153b308", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "699bc8f76f46cdadc358bd8f4cdecea5", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Fix “cache lookup failed for relation 0” failures in logical replication workers", "evidence": {"same_day": true, "patch_ids": ["b3f4ce5a5b2c180084072f5f86d1510d"], "statement_hash": "f7cbfb42445608d79a07254be2610dab56c711ed55f1ad845464f034778b3feb"}, "url": "/docs/compare/?release=10.15#10.15-704c334d2153b308", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}]}, {"id": "12.5-31d7919a13bbdc42", "cves": [], "html": "Prevent logical replication workers from sending redundant ping requests (Tom Lane) §
", "text": "Prevent logical replication workers from sending redundant ping requests (Tom Lane) §", "title": "Prevent logical replication workers from sending redundant ping requests", "commits": ["9b47ee6e7"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "993662a6cd6c9adc67168cfcff18f758f05f2129b886f4a2b9352f255a004a16", "section_path": ["Changes"], "commit_groups": [["7156a0eac", "9b47ee6e7", "9b81a30f9", "9b8a8516e", "c8746f999"]], "identity_text": "Prevent logical replication workers from sending redundant ping requests (Tom Lane)", "commit_aliases": ["7156a0eac", "9b47ee6e7", "9b81a30f9", "9b8a8516e", "c8746f999"], "source_commits": ["9b47ee6e7"], "source_entry_id": "12.5/changes/022", "db_id": "f04b4d0cac3dc8d841d443b05ab30b77", "patch_ids": ["8cd4c03f9b2af0240b03b6822bb35eb6"], "statement_hash": "02816616f5fbb313ca548d54f9773c45913a8323c8927e62331960a760763022", "relations": [{"rule": 2, "type": "equivalent", "target": "6fcf00e98b328058ce057bbb09b9d799", "evidence": {"same_day": true, "patch_ids": ["8cd4c03f9b2af0240b03b6822bb35eb6"], "statement_hash": "02816616f5fbb313ca548d54f9773c45913a8323c8927e62331960a760763022"}}, {"rule": 2, "type": "equivalent", "target": "c9f9609f921316cd81d479afaefd49bf", "evidence": {"same_day": true, "patch_ids": ["8cd4c03f9b2af0240b03b6822bb35eb6"], "statement_hash": "02816616f5fbb313ca548d54f9773c45913a8323c8927e62331960a760763022"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "6fcf00e98b328058ce057bbb09b9d799", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Prevent logical replication workers from sending redundant ping requests", "evidence": {"same_day": true, "patch_ids": ["8cd4c03f9b2af0240b03b6822bb35eb6"], "statement_hash": "02816616f5fbb313ca548d54f9773c45913a8323c8927e62331960a760763022"}, "url": "/docs/compare/?release=11.10#11.10-ff5f8ac5051d7f30", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "c9f9609f921316cd81d479afaefd49bf", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Prevent logical replication workers from sending redundant ping requests", "evidence": {"same_day": true, "patch_ids": ["8cd4c03f9b2af0240b03b6822bb35eb6"], "statement_hash": "02816616f5fbb313ca548d54f9773c45913a8323c8927e62331960a760763022"}, "url": "/docs/compare/?release=10.15#10.15-ff5f8ac5051d7f30", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}]}, {"id": "12.5-b52567248e8954ab", "cves": [], "html": "During “smart” shutdown, don't terminate background processes until all client (foreground) sessions are done (Tom Lane) §
\nThe previous behavior broke parallel query processing, since the postmaster would terminate parallel workers and refuse to launch any new ones. It also caused autovacuum to cease functioning, which could have dire long-term effects if the surviving client sessions make a lot of data changes.
", "text": "During “smart” shutdown, don't terminate background processes until all client (foreground) sessions are done (Tom Lane) § The previous behavior broke parallel query processing, since the postmaster would terminate parallel workers and refuse to launch any new ones. It also caused autovacuum to cease functioning, which could have dire long-term effects if the surviving client sessions make a lot of data changes.", "title": "During “smart” shutdown, don't terminate background processes until all client (foreground) sessions are done", "commits": ["42566a250"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "798c60cf7f2e463c83119f813c2a3d242c7c9686f8ff8a700207be958bfe4430", "section_path": ["Changes"], "commit_groups": [["0038f9438", "1c6066fbd", "250aaa2de", "326b5fe0f", "42566a250", "b4d8be9f6"]], "identity_text": "During smart shutdown, don't terminate background processes until all client (foreground) sessions are done (Tom Lane) The previous behavior broke parallel query processing, since the postmaster would terminate parallel workers and refuse to launch any new ones. It also caused autovacuum to cease functioning, which could have dire long-term effects if the surviving client sessions make a lot of data changes.", "commit_aliases": ["0038f9438", "1c6066fbd", "250aaa2de", "326b5fe0f", "42566a250", "b4d8be9f6"], "source_commits": ["42566a250"], "source_entry_id": "12.5/changes/023", "db_id": "e35232ff306351c6f3a7961aa36f4606", "patch_ids": ["83b5b8fc30512f647704f3b18d8da575"], "statement_hash": "9ea36dc6594a0057b296f3eda7cb0d5310d371473b4ee1dc297be85c37fb4c02", "relations": [{"rule": 2, "type": "equivalent", "target": "8c8cafc304613bf258b91c56b3098bdc", "evidence": {"same_day": true, "patch_ids": ["83b5b8fc30512f647704f3b18d8da575"], "statement_hash": "9ea36dc6594a0057b296f3eda7cb0d5310d371473b4ee1dc297be85c37fb4c02"}}, {"rule": 2, "type": "equivalent", "target": "cd3ff34bda7c9613674a785b3b93f3d7", "evidence": {"same_day": true, "patch_ids": ["83b5b8fc30512f647704f3b18d8da575"], "statement_hash": "9ea36dc6594a0057b296f3eda7cb0d5310d371473b4ee1dc297be85c37fb4c02"}}, {"rule": 2, "type": "equivalent", "target": "d32e57284eb71b59557faaac2ca029c2", "evidence": {"same_day": true, "patch_ids": ["83b5b8fc30512f647704f3b18d8da575"], "statement_hash": "9ea36dc6594a0057b296f3eda7cb0d5310d371473b4ee1dc297be85c37fb4c02"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "d32e57284eb71b59557faaac2ca029c2", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "During “smart” shutdown, don't terminate background processes until all client (foreground) sessions are done", "evidence": {"same_day": true, "patch_ids": ["83b5b8fc30512f647704f3b18d8da575"], "statement_hash": "9ea36dc6594a0057b296f3eda7cb0d5310d371473b4ee1dc297be85c37fb4c02"}, "url": "/docs/compare/?release=11.10#11.10-bd1252199c9021ca", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "cd3ff34bda7c9613674a785b3b93f3d7", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "During “smart” shutdown, don't terminate background processes until all client (foreground) sessions are done", "evidence": {"same_day": true, "patch_ids": ["83b5b8fc30512f647704f3b18d8da575"], "statement_hash": "9ea36dc6594a0057b296f3eda7cb0d5310d371473b4ee1dc297be85c37fb4c02"}, "url": "/docs/compare/?release=10.15#10.15-bd1252199c9021ca", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "8c8cafc304613bf258b91c56b3098bdc", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "During \"smart\" shutdown, don't terminate background processes until all client (foreground) sessions are done", "evidence": {"same_day": true, "patch_ids": ["83b5b8fc30512f647704f3b18d8da575"], "statement_hash": "9ea36dc6594a0057b296f3eda7cb0d5310d371473b4ee1dc297be85c37fb4c02"}, "url": "/docs/compare/?release=9.6.20#9.6.20-ab3beb63701f08a0", "source_url": "/docs/release/9.6.20/#AEN132588"}]}, {"id": "12.5-b352e771268a35c9", "cves": [], "html": "Avoid recursive consumption of stack space while processing signals in the postmaster (Tom Lane) §
\nHeavy use of parallel processing has been observed to cause postmaster crashes due to too many concurrent signals requesting creation of a parallel worker process.
", "text": "Avoid recursive consumption of stack space while processing signals in the postmaster (Tom Lane) § Heavy use of parallel processing has been observed to cause postmaster crashes due to too many concurrent signals requesting creation of a parallel worker process.", "title": "Avoid recursive consumption of stack space while processing signals in the postmaster", "commits": ["8b53dbada"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "a863d5e5613c1bc82435cdbc6ad596cdc337689741dd271a6440ce10528ac96a", "section_path": ["Changes"], "commit_groups": [["4e95733b0", "7753ca49d", "85834023a", "8b53dbada", "9abb2bfc0"]], "identity_text": "Avoid recursive consumption of stack space while processing signals in the postmaster (Tom Lane) Heavy use of parallel processing has been observed to cause postmaster crashes due to too many concurrent signals requesting creation of a parallel worker process.", "commit_aliases": ["4e95733b0", "7753ca49d", "85834023a", "8b53dbada", "9abb2bfc0"], "source_commits": ["8b53dbada"], "source_entry_id": "12.5/changes/024", "db_id": "f7c5a40480ff68f0a8385fbc84f6b9be", "patch_ids": ["3b0f1d49759fcb378d014b2046e23800"], "statement_hash": "b89337693106918c4876f9c173e4d593f986db5b65715e7236e072b93b54a4a3", "relations": [{"rule": 2, "type": "equivalent", "target": "1669de05b54fd9a042a0ac27f7a60de7", "evidence": {"same_day": true, "patch_ids": ["3b0f1d49759fcb378d014b2046e23800"], "statement_hash": "b89337693106918c4876f9c173e4d593f986db5b65715e7236e072b93b54a4a3"}}, {"rule": 2, "type": "equivalent", "target": "19678d08dd91a3e441f15bf787de395a", "evidence": {"same_day": true, "patch_ids": ["3b0f1d49759fcb378d014b2046e23800"], "statement_hash": "b89337693106918c4876f9c173e4d593f986db5b65715e7236e072b93b54a4a3"}}, {"rule": 2, "type": "equivalent", "target": "afe2369bc994cb5968c32d96522c8317", "evidence": {"same_day": true, "patch_ids": ["3b0f1d49759fcb378d014b2046e23800"], "statement_hash": "b89337693106918c4876f9c173e4d593f986db5b65715e7236e072b93b54a4a3"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "19678d08dd91a3e441f15bf787de395a", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Avoid recursive consumption of stack space while processing signals in the postmaster", "evidence": {"same_day": true, "patch_ids": ["3b0f1d49759fcb378d014b2046e23800"], "statement_hash": "b89337693106918c4876f9c173e4d593f986db5b65715e7236e072b93b54a4a3"}, "url": "/docs/compare/?release=11.10#11.10-aa5a0ba3f61fe645", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "afe2369bc994cb5968c32d96522c8317", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Avoid recursive consumption of stack space while processing signals in the postmaster", "evidence": {"same_day": true, "patch_ids": ["3b0f1d49759fcb378d014b2046e23800"], "statement_hash": "b89337693106918c4876f9c173e4d593f986db5b65715e7236e072b93b54a4a3"}, "url": "/docs/compare/?release=10.15#10.15-aa5a0ba3f61fe645", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "1669de05b54fd9a042a0ac27f7a60de7", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Avoid recursive consumption of stack space while processing signals in the postmaster", "evidence": {"same_day": true, "patch_ids": ["3b0f1d49759fcb378d014b2046e23800"], "statement_hash": "b89337693106918c4876f9c173e4d593f986db5b65715e7236e072b93b54a4a3"}, "url": "/docs/compare/?release=9.6.20#9.6.20-aa5a0ba3f61fe645", "source_url": "/docs/release/9.6.20/#AEN132588"}]}, {"id": "12.5-d128efa24a8cdd19", "cves": [], "html": "Avoid running atexit handlers when exiting due to SIGQUIT (Kyotaro Horiguchi, Tom Lane) § §
\nMost server processes followed this practice already, but the archiver process was overlooked. Backends that were still waiting for a client startup packet got it wrong, too.
", "text": "Avoid running atexit handlers when exiting due to SIGQUIT (Kyotaro Horiguchi, Tom Lane) § § Most server processes followed this practice already, but the archiver process was overlooked. Backends that were still waiting for a client startup packet got it wrong, too.", "title": "Avoid running atexit handlers when exiting due to SIGQUIT", "commits": ["4e10c0c8a", "d038c6c63"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "c390fe1603e7760cc270632de43ac268dfe733c8dffac4a456d42a2ec57f7779", "section_path": ["Changes"], "commit_groups": [["35e59398a", "581855b6a", "67dde49a3", "95cd8902e", "b2eaddd9b", "bedadc732", "d038c6c63"], ["3f29aa48b", "4e10c0c8a", "58c6feccf", "93871b693", "ac695b8f2", "dc71c6409", "e2c9bedc9"]], "identity_text": "Avoid running atexit handlers when exiting due to SIGQUIT (Kyotaro Horiguchi, Tom Lane) Most server processes followed this practice already, but the archiver process was overlooked. Backends that were still waiting for a client startup packet got it wrong, too.", "commit_aliases": ["35e59398a", "3f29aa48b", "4e10c0c8a", "581855b6a", "58c6feccf", "67dde49a3", "93871b693", "95cd8902e", "ac695b8f2", "b2eaddd9b", "bedadc732", "d038c6c63", "dc71c6409", "e2c9bedc9"], "source_commits": ["4e10c0c8a", "d038c6c63"], "source_entry_id": "12.5/changes/025", "db_id": "86b0c8d81f28cb6de6d3e02d1c2cdb38", "patch_ids": ["6fc50702807c244fcf4500f783819777", "97c2daa6592be20230d5f63250760bea"], "statement_hash": "f9175be4ed8812d92b08079b22d55686f12a1016305f6bf94ceff3570bc35097", "relations": [{"rule": 2, "type": "equivalent", "target": "3cfc1b4563212a1453ea78730175510e", "evidence": {"same_day": true, "patch_ids": ["6fc50702807c244fcf4500f783819777", "97c2daa6592be20230d5f63250760bea"], "statement_hash": "f9175be4ed8812d92b08079b22d55686f12a1016305f6bf94ceff3570bc35097"}}, {"rule": 2, "type": "equivalent", "target": "5c177b095513e9b3c4d433c01b8e550d", "evidence": {"same_day": true, "patch_ids": ["6fc50702807c244fcf4500f783819777", "97c2daa6592be20230d5f63250760bea"], "statement_hash": "f9175be4ed8812d92b08079b22d55686f12a1016305f6bf94ceff3570bc35097"}}, {"rule": 2, "type": "equivalent", "target": "d54b4345a603ab0508f16bf041986ca7", "evidence": {"same_day": true, "patch_ids": ["6fc50702807c244fcf4500f783819777", "97c2daa6592be20230d5f63250760bea"], "statement_hash": "f9175be4ed8812d92b08079b22d55686f12a1016305f6bf94ceff3570bc35097"}}, {"rule": 2, "type": "equivalent", "target": "f2da64c370514fe62a3fd63fb720bcee", "evidence": {"same_day": true, "patch_ids": ["6fc50702807c244fcf4500f783819777", "97c2daa6592be20230d5f63250760bea"], "statement_hash": "f9175be4ed8812d92b08079b22d55686f12a1016305f6bf94ceff3570bc35097"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "3cfc1b4563212a1453ea78730175510e", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Avoid running atexit handlers when exiting due to SIGQUIT", "evidence": {"same_day": true, "patch_ids": ["6fc50702807c244fcf4500f783819777", "97c2daa6592be20230d5f63250760bea"], "statement_hash": "f9175be4ed8812d92b08079b22d55686f12a1016305f6bf94ceff3570bc35097"}, "url": "/docs/compare/?release=11.10#11.10-7fc65c0962d0a4ce", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "d54b4345a603ab0508f16bf041986ca7", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Avoid running atexit handlers when exiting due to SIGQUIT", "evidence": {"same_day": true, "patch_ids": ["6fc50702807c244fcf4500f783819777", "97c2daa6592be20230d5f63250760bea"], "statement_hash": "f9175be4ed8812d92b08079b22d55686f12a1016305f6bf94ceff3570bc35097"}, "url": "/docs/compare/?release=10.15#10.15-7fc65c0962d0a4ce", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "5c177b095513e9b3c4d433c01b8e550d", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Avoid running atexit handlers when exiting due to SIGQUIT", "evidence": {"same_day": true, "patch_ids": ["6fc50702807c244fcf4500f783819777", "97c2daa6592be20230d5f63250760bea"], "statement_hash": "f9175be4ed8812d92b08079b22d55686f12a1016305f6bf94ceff3570bc35097"}, "url": "/docs/compare/?release=9.6.20#9.6.20-7fc65c0962d0a4ce", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "f2da64c370514fe62a3fd63fb720bcee", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Avoid running atexit handlers when exiting due to SIGQUIT", "evidence": {"same_day": true, "patch_ids": ["6fc50702807c244fcf4500f783819777", "97c2daa6592be20230d5f63250760bea"], "statement_hash": "f9175be4ed8812d92b08079b22d55686f12a1016305f6bf94ceff3570bc35097"}, "url": "/docs/compare/?release=9.5.24#9.5.24-7fc65c0962d0a4ce", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-f7afa19d2e53fc4e", "cves": [], "html": "Avoid misoptimization of subquery qualifications that reference apparently-constant grouping columns (Tom Lane) §
\nA “constant” subquery output column isn't really constant if it is a grouping column that appears in only some of the grouping sets.
", "text": "Avoid misoptimization of subquery qualifications that reference apparently-constant grouping columns (Tom Lane) § A “constant” subquery output column isn't really constant if it is a grouping column that appears in only some of the grouping sets.", "title": "Avoid misoptimization of subquery qualifications that reference apparently-constant grouping columns", "commits": ["6b701eaaa"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "2ef1829cfe3796472592aef47b01fb8aa36c8dc7b88f4e4e902706fab6a3f430", "section_path": ["Changes"], "commit_groups": [["4d346def1", "6b701eaaa", "6fa403e61", "7edd36eae", "b439adcab", "d3701bc8a", "de627adaa"]], "identity_text": "Avoid misoptimization of subquery qualifications that reference apparently-constant grouping columns (Tom Lane) A constant subquery output column isn't really constant if it is a grouping column that appears in only some of the grouping sets.", "commit_aliases": ["4d346def1", "6b701eaaa", "6fa403e61", "7edd36eae", "b439adcab", "d3701bc8a", "de627adaa"], "source_commits": ["6b701eaaa"], "source_entry_id": "12.5/changes/026", "db_id": "f66e915b7e2bb206744e4e30e62bf660", "patch_ids": ["c1bb4b9085437890cd101c057ebf3c1c"], "statement_hash": "6958d4b39bfaed5615534e5cd09b9198ca7e46c3b54f9b7507f94de6676f7e42", "relations": [{"rule": 2, "type": "equivalent", "target": "68b64d3d47b9acb936df521fb7f5c8f9", "evidence": {"same_day": true, "patch_ids": ["c1bb4b9085437890cd101c057ebf3c1c"], "statement_hash": "6958d4b39bfaed5615534e5cd09b9198ca7e46c3b54f9b7507f94de6676f7e42"}}, {"rule": 2, "type": "equivalent", "target": "890b5052ce09fdf2f0343fd75f919b07", "evidence": {"same_day": true, "patch_ids": ["c1bb4b9085437890cd101c057ebf3c1c"], "statement_hash": "6958d4b39bfaed5615534e5cd09b9198ca7e46c3b54f9b7507f94de6676f7e42"}}, {"rule": 2, "type": "equivalent", "target": "8b9119c81dce1d109b27e0691f2c9625", "evidence": {"same_day": true, "patch_ids": ["c1bb4b9085437890cd101c057ebf3c1c"], "statement_hash": "6958d4b39bfaed5615534e5cd09b9198ca7e46c3b54f9b7507f94de6676f7e42"}}, {"rule": 2, "type": "equivalent", "target": "d0ed26f8f54ad887ef4e0cca7062ceeb", "evidence": {"same_day": true, "patch_ids": ["c1bb4b9085437890cd101c057ebf3c1c"], "statement_hash": "6958d4b39bfaed5615534e5cd09b9198ca7e46c3b54f9b7507f94de6676f7e42"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "68b64d3d47b9acb936df521fb7f5c8f9", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Avoid misoptimization of subquery qualifications that reference apparently-constant grouping columns", "evidence": {"same_day": true, "patch_ids": ["c1bb4b9085437890cd101c057ebf3c1c"], "statement_hash": "6958d4b39bfaed5615534e5cd09b9198ca7e46c3b54f9b7507f94de6676f7e42"}, "url": "/docs/compare/?release=11.10#11.10-51e6992fd8d39931", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "8b9119c81dce1d109b27e0691f2c9625", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Avoid misoptimization of subquery qualifications that reference apparently-constant grouping columns", "evidence": {"same_day": true, "patch_ids": ["c1bb4b9085437890cd101c057ebf3c1c"], "statement_hash": "6958d4b39bfaed5615534e5cd09b9198ca7e46c3b54f9b7507f94de6676f7e42"}, "url": "/docs/compare/?release=10.15#10.15-51e6992fd8d39931", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "890b5052ce09fdf2f0343fd75f919b07", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Avoid misoptimization of subquery qualifications that reference apparently-constant grouping columns", "evidence": {"same_day": true, "patch_ids": ["c1bb4b9085437890cd101c057ebf3c1c"], "statement_hash": "6958d4b39bfaed5615534e5cd09b9198ca7e46c3b54f9b7507f94de6676f7e42"}, "url": "/docs/compare/?release=9.6.20#9.6.20-51e6992fd8d39931", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "d0ed26f8f54ad887ef4e0cca7062ceeb", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Avoid misoptimization of subquery qualifications that reference apparently-constant grouping columns", "evidence": {"same_day": true, "patch_ids": ["c1bb4b9085437890cd101c057ebf3c1c"], "statement_hash": "6958d4b39bfaed5615534e5cd09b9198ca7e46c3b54f9b7507f94de6676f7e42"}, "url": "/docs/compare/?release=9.5.24#9.5.24-51e6992fd8d39931", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-28baac7d04b5dce7", "cves": [], "html": "Fix possible crash when considering partition-wise joins during GEQO planning (Tom Lane) §
", "text": "Fix possible crash when considering partition-wise joins during GEQO planning (Tom Lane) §", "title": "Fix possible crash when considering partition-wise joins during GEQO planning", "commits": ["3d69efc4f"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "3692bfcbb382341510659c22a89acd4154a7b48363555e73eb926bd65b974e76", "section_path": ["Changes"], "commit_groups": [["3d69efc4f", "b7f166efa", "d7885b1f8"]], "identity_text": "Fix possible crash when considering partition-wise joins during GEQO planning (Tom Lane)", "commit_aliases": ["3d69efc4f", "b7f166efa", "d7885b1f8"], "source_commits": ["3d69efc4f"], "source_entry_id": "12.5/changes/027", "db_id": "5e974e3e4a96fc28a8813100c7838344", "patch_ids": ["12fc209d644e2561968709cfba9ee098"], "statement_hash": "c6c5b2b3cd624ee5deeaee98c0ed57040b2ab370c3b31016bbc9910fcd7741a3", "relations": [{"rule": 2, "type": "equivalent", "target": "9967ce7aad3dd5dd2ef99246f9879800", "evidence": {"same_day": true, "patch_ids": ["12fc209d644e2561968709cfba9ee098"], "statement_hash": "c6c5b2b3cd624ee5deeaee98c0ed57040b2ab370c3b31016bbc9910fcd7741a3"}}], "version": "12.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "9967ce7aad3dd5dd2ef99246f9879800", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Fix possible crash when considering partition-wise joins during GEQO planning", "evidence": {"same_day": true, "patch_ids": ["12fc209d644e2561968709cfba9ee098"], "statement_hash": "c6c5b2b3cd624ee5deeaee98c0ed57040b2ab370c3b31016bbc9910fcd7741a3"}, "url": "/docs/compare/?release=13.1#13.1-c208ca7e521b0be0", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}]}, {"id": "12.5-d1079979f356661a", "cves": [], "html": "Avoid failure when SQL function inlining changes the shape of a potentially-hashable subplan comparison expression (Tom Lane) §
", "text": "Avoid failure when SQL function inlining changes the shape of a potentially-hashable subplan comparison expression (Tom Lane) §", "title": "Avoid failure when SQL function inlining changes the shape of a potentially-hashable subplan comparison expression", "commits": ["912fb290c"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "a0f7f890f0c763bf95d752fb606b82ebd5974635b1a671ef06bd1d661d9f7fcc", "section_path": ["Changes"], "commit_groups": [["1e7629d2c", "5190707d7", "7241edc4f", "912fb290c", "9d472b51e", "b538e83f1", "dea07098a"]], "identity_text": "Avoid failure when SQL function inlining changes the shape of a potentially-hashable subplan comparison expression (Tom Lane)", "commit_aliases": ["1e7629d2c", "5190707d7", "7241edc4f", "912fb290c", "9d472b51e", "b538e83f1", "dea07098a"], "source_commits": ["912fb290c"], "source_entry_id": "12.5/changes/028", "db_id": "aa7c2b63f381d58c6c73fe1431979899", "patch_ids": ["6555c6cf831e2195928e96ed9a5c15b1"], "statement_hash": "03b483637a5b1d523482262aace74db288932221be91ae705615c4f479f798e1", "relations": [{"rule": 2, "type": "equivalent", "target": "7b97c574c2b4409d6c5f68b2ed629cea", "evidence": {"same_day": true, "patch_ids": ["6555c6cf831e2195928e96ed9a5c15b1"], "statement_hash": "03b483637a5b1d523482262aace74db288932221be91ae705615c4f479f798e1"}}, {"rule": 2, "type": "equivalent", "target": "9fc2c7b38aac3a5f73bff0c462cbbbc8", "evidence": {"same_day": true, "patch_ids": ["6555c6cf831e2195928e96ed9a5c15b1"], "statement_hash": "03b483637a5b1d523482262aace74db288932221be91ae705615c4f479f798e1"}}, {"rule": 2, "type": "equivalent", "target": "b47ca63cb6d953dc73dbc9bc599eda4d", "evidence": {"same_day": true, "patch_ids": ["6555c6cf831e2195928e96ed9a5c15b1"], "statement_hash": "03b483637a5b1d523482262aace74db288932221be91ae705615c4f479f798e1"}}, {"rule": 2, "type": "equivalent", "target": "f0729bd29c0b8c01cc6dbc6bfd6934c2", "evidence": {"same_day": true, "patch_ids": ["6555c6cf831e2195928e96ed9a5c15b1"], "statement_hash": "03b483637a5b1d523482262aace74db288932221be91ae705615c4f479f798e1"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "7b97c574c2b4409d6c5f68b2ed629cea", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Avoid failure when SQL function inlining changes the shape of a potentially-hashable subplan comparison expression", "evidence": {"same_day": true, "patch_ids": ["6555c6cf831e2195928e96ed9a5c15b1"], "statement_hash": "03b483637a5b1d523482262aace74db288932221be91ae705615c4f479f798e1"}, "url": "/docs/compare/?release=11.10#11.10-7c510c98fb0e45ea", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "b47ca63cb6d953dc73dbc9bc599eda4d", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Avoid failure when SQL function inlining changes the shape of a potentially-hashable subplan comparison expression", "evidence": {"same_day": true, "patch_ids": ["6555c6cf831e2195928e96ed9a5c15b1"], "statement_hash": "03b483637a5b1d523482262aace74db288932221be91ae705615c4f479f798e1"}, "url": "/docs/compare/?release=10.15#10.15-7c510c98fb0e45ea", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "9fc2c7b38aac3a5f73bff0c462cbbbc8", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Avoid failure when SQL function inlining changes the shape of a potentially-hashable subplan comparison expression", "evidence": {"same_day": true, "patch_ids": ["6555c6cf831e2195928e96ed9a5c15b1"], "statement_hash": "03b483637a5b1d523482262aace74db288932221be91ae705615c4f479f798e1"}, "url": "/docs/compare/?release=9.6.20#9.6.20-7c510c98fb0e45ea", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "f0729bd29c0b8c01cc6dbc6bfd6934c2", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Avoid failure when SQL function inlining changes the shape of a potentially-hashable subplan comparison expression", "evidence": {"same_day": true, "patch_ids": ["6555c6cf831e2195928e96ed9a5c15b1"], "statement_hash": "03b483637a5b1d523482262aace74db288932221be91ae705615c4f479f798e1"}, "url": "/docs/compare/?release=9.5.24#9.5.24-7c510c98fb0e45ea", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-26b5029246faa887", "cves": [], "html": "While building or re-building an index, tolerate the appearance of new HOT chains due to concurrent updates (Anastasia Lubennikova, Álvaro Herrera) § §
\nThis oversight could lead to “failed to find parent tuple for heap-only tuple” errors.
", "text": "While building or re-building an index, tolerate the appearance of new HOT chains due to concurrent updates (Anastasia Lubennikova, Álvaro Herrera) § § This oversight could lead to “failed to find parent tuple for heap-only tuple” errors.", "title": "While building or re-building an index, tolerate the appearance of new HOT chains due to concurrent updates", "commits": ["1122a903e", "4f47c8e7d"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "68d2c46184581a8a085fc131d447c070770e4a39fb956d7d2f0efbdece0ef685", "section_path": ["Changes"], "commit_groups": [["060e5bd70", "3a45ac076", "4f47c8e7d", "6e70443ed", "aa4da2674", "b83f1bcca", "d4d214903"], ["1122a903e", "2f29fd4cb", "385cbe8e4", "40bceae7b", "704de3739", "a811ea5bd", "e5902117d"]], "identity_text": "While building or re-building an index, tolerate the appearance of new HOT chains due to concurrent updates (Anastasia Lubennikova, Álvaro Herrera) This oversight could lead to failed to find parent tuple for heap-only tuple errors.", "commit_aliases": ["060e5bd70", "1122a903e", "2f29fd4cb", "385cbe8e4", "3a45ac076", "40bceae7b", "4f47c8e7d", "6e70443ed", "704de3739", "a811ea5bd", "aa4da2674", "b83f1bcca", "d4d214903", "e5902117d"], "source_commits": ["1122a903e", "4f47c8e7d"], "source_entry_id": "12.5/changes/029", "db_id": "f01bdaa7fa6b88bc37ff331a23ea5daf", "patch_ids": ["46cd787dd1882f412c4f11c627cb8acc", "56b3562b6e7b8d132a3175b860d0b191"], "statement_hash": "cd21d032f41fe297a6331aac99e7b3ebf1e290c600221de3faed1db013606cc8", "relations": [{"rule": 2, "type": "equivalent", "target": "0c4157e8416c7478182d070c3e580ab0", "evidence": {"same_day": true, "patch_ids": ["46cd787dd1882f412c4f11c627cb8acc", "56b3562b6e7b8d132a3175b860d0b191"], "statement_hash": "cd21d032f41fe297a6331aac99e7b3ebf1e290c600221de3faed1db013606cc8"}}, {"rule": 2, "type": "equivalent", "target": "36fa7bda094380e83e6ec02244c144a7", "evidence": {"same_day": true, "patch_ids": ["46cd787dd1882f412c4f11c627cb8acc", "56b3562b6e7b8d132a3175b860d0b191"], "statement_hash": "cd21d032f41fe297a6331aac99e7b3ebf1e290c600221de3faed1db013606cc8"}}, {"rule": 2, "type": "equivalent", "target": "7e709106d3315058aaef8144b520c3e3", "evidence": {"same_day": true, "patch_ids": ["46cd787dd1882f412c4f11c627cb8acc", "56b3562b6e7b8d132a3175b860d0b191"], "statement_hash": "cd21d032f41fe297a6331aac99e7b3ebf1e290c600221de3faed1db013606cc8"}}, {"rule": 2, "type": "equivalent", "target": "f8342c93d24e87e03679db8fd4c15bbe", "evidence": {"same_day": true, "patch_ids": ["46cd787dd1882f412c4f11c627cb8acc", "56b3562b6e7b8d132a3175b860d0b191"], "statement_hash": "cd21d032f41fe297a6331aac99e7b3ebf1e290c600221de3faed1db013606cc8"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "36fa7bda094380e83e6ec02244c144a7", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "While building or re-building an index, tolerate the appearance of new HOT chains due to concurrent updates", "evidence": {"same_day": true, "patch_ids": ["46cd787dd1882f412c4f11c627cb8acc", "56b3562b6e7b8d132a3175b860d0b191"], "statement_hash": "cd21d032f41fe297a6331aac99e7b3ebf1e290c600221de3faed1db013606cc8"}, "url": "/docs/compare/?release=11.10#11.10-f67cae713607ad06", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "0c4157e8416c7478182d070c3e580ab0", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "While building or re-building an index, tolerate the appearance of new HOT chains due to concurrent updates", "evidence": {"same_day": true, "patch_ids": ["46cd787dd1882f412c4f11c627cb8acc", "56b3562b6e7b8d132a3175b860d0b191"], "statement_hash": "cd21d032f41fe297a6331aac99e7b3ebf1e290c600221de3faed1db013606cc8"}, "url": "/docs/compare/?release=10.15#10.15-f67cae713607ad06", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "7e709106d3315058aaef8144b520c3e3", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "While building or re-building an index, tolerate the appearance of new HOT chains due to concurrent updates", "evidence": {"same_day": true, "patch_ids": ["46cd787dd1882f412c4f11c627cb8acc", "56b3562b6e7b8d132a3175b860d0b191"], "statement_hash": "cd21d032f41fe297a6331aac99e7b3ebf1e290c600221de3faed1db013606cc8"}, "url": "/docs/compare/?release=9.6.20#9.6.20-f67cae713607ad06", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "f8342c93d24e87e03679db8fd4c15bbe", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "While building or re-building an index, tolerate the appearance of new HOT chains due to concurrent updates", "evidence": {"same_day": true, "patch_ids": ["46cd787dd1882f412c4f11c627cb8acc", "56b3562b6e7b8d132a3175b860d0b191"], "statement_hash": "cd21d032f41fe297a6331aac99e7b3ebf1e290c600221de3faed1db013606cc8"}, "url": "/docs/compare/?release=9.5.24#9.5.24-f67cae713607ad06", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-1b657abeeb19d5fe", "cves": [], "html": "Fix failure of parallel B-tree index scans when the index condition is unsatisfiable (James Hunter) §
", "text": "Fix failure of parallel B-tree index scans when the index condition is unsatisfiable (James Hunter) §", "title": "Fix failure of parallel B-tree index scans when the index condition is unsatisfiable", "commits": ["4bc63462d"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "1891d00bc8a9cecaedbf0072bb84eb487b5994897f97f472d9a56ecf615c2543", "section_path": ["Changes"], "commit_groups": [["0abd9cd2f", "4bc63462d", "956891fab", "b7f2dd959", "fcc3665a0"]], "identity_text": "Fix failure of parallel B-tree index scans when the index condition is unsatisfiable (James Hunter)", "commit_aliases": ["0abd9cd2f", "4bc63462d", "956891fab", "b7f2dd959", "fcc3665a0"], "source_commits": ["4bc63462d"], "source_entry_id": "12.5/changes/030", "db_id": "d3f03c886e38959f44d5fb7b6ca4ab8b", "patch_ids": ["833c9f7eeef4ee73941ace82e76138ad"], "statement_hash": "90ebc6d9bad8a80cca417e8d282060488efa6789599d3ab2085e9866c9caa9e2", "relations": [{"rule": 2, "type": "equivalent", "target": "57dbe7559f88a2d5dcbb93f9f3babe3c", "evidence": {"same_day": true, "patch_ids": ["833c9f7eeef4ee73941ace82e76138ad"], "statement_hash": "90ebc6d9bad8a80cca417e8d282060488efa6789599d3ab2085e9866c9caa9e2"}}, {"rule": 2, "type": "equivalent", "target": "8574d865168ee9bdb3b8af64caa5c784", "evidence": {"same_day": true, "patch_ids": ["833c9f7eeef4ee73941ace82e76138ad"], "statement_hash": "90ebc6d9bad8a80cca417e8d282060488efa6789599d3ab2085e9866c9caa9e2"}}], "version": "12.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "8574d865168ee9bdb3b8af64caa5c784", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Fix failure of parallel B-tree index scans when the index condition is unsatisfiable", "evidence": {"same_day": true, "patch_ids": ["833c9f7eeef4ee73941ace82e76138ad"], "statement_hash": "90ebc6d9bad8a80cca417e8d282060488efa6789599d3ab2085e9866c9caa9e2"}, "url": "/docs/compare/?release=11.10#11.10-625235f297daf261", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "57dbe7559f88a2d5dcbb93f9f3babe3c", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Fix failure of parallel B-tree index scans when the index condition is unsatisfiable", "evidence": {"same_day": true, "patch_ids": ["833c9f7eeef4ee73941ace82e76138ad"], "statement_hash": "90ebc6d9bad8a80cca417e8d282060488efa6789599d3ab2085e9866c9caa9e2"}, "url": "/docs/compare/?release=10.15#10.15-625235f297daf261", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}]}, {"id": "12.5-5dba5e2a1baab5c8", "cves": [], "html": "Ensure that data is detoasted before being inserted into a BRIN index (Tomas Vondra) §
\nIndex entries are not supposed to contain out-of-line TOAST pointers, but BRIN didn't get that memo. This could lead to errors like “missing chunk number 0 for toast value NNN”. (If you are faced with such an error from an existing index, REINDEX should be enough to fix it.)
Handle concurrent desummarization correctly during BRIN index scans (Alexander Lakhin, Álvaro Herrera) §
\nPreviously, if a page range was desummarized at just the wrong time, an index scan might falsely raise an error indicating index corruption.
", "text": "Handle concurrent desummarization correctly during BRIN index scans (Alexander Lakhin, Álvaro Herrera) § Previously, if a page range was desummarized at just the wrong time, an index scan might falsely raise an error indicating index corruption.", "title": "Handle concurrent desummarization correctly during BRIN index scans", "commits": ["0426c75e7"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "04e9930eb4705bc3238e7e32436847f04da26fd52ab69efb66be7ce7d1c5c144", "section_path": ["Changes"], "commit_groups": [["0426c75e7", "1f42d35a1", "721ef4d28", "7a3c261fb", "7af39993a", "8782ea2f3", "ce3a8fde8"]], "identity_text": "Handle concurrent desummarization correctly during BRIN index scans (Alexander Lakhin, Álvaro Herrera) Previously, if a page range was desummarized at just the wrong time, an index scan might falsely raise an error indicating index corruption.", "commit_aliases": ["0426c75e7", "1f42d35a1", "721ef4d28", "7a3c261fb", "7af39993a", "8782ea2f3", "ce3a8fde8"], "source_commits": ["0426c75e7"], "source_entry_id": "12.5/changes/032", "db_id": "96d3a54ff2f798dd521091a2bf32abef", "patch_ids": ["d2a569906c031d1485855cbad9d5244a"], "statement_hash": "b396b35af535447444e7f8afbbcf759a4b55ed99f99cc757070fc4bf0a296dc1", "relations": [{"rule": 2, "type": "equivalent", "target": "0a3ab21daf4706eff4f4f2df196c4b50", "evidence": {"same_day": true, "patch_ids": ["d2a569906c031d1485855cbad9d5244a"], "statement_hash": "b396b35af535447444e7f8afbbcf759a4b55ed99f99cc757070fc4bf0a296dc1"}}, {"rule": 2, "type": "equivalent", "target": "82130add7738c3d78e474a0a8d8e4203", "evidence": {"same_day": true, "patch_ids": ["d2a569906c031d1485855cbad9d5244a"], "statement_hash": "b396b35af535447444e7f8afbbcf759a4b55ed99f99cc757070fc4bf0a296dc1"}}, {"rule": 2, "type": "equivalent", "target": "b0d851f55446341f7d688770837b557d", "evidence": {"same_day": true, "patch_ids": ["d2a569906c031d1485855cbad9d5244a"], "statement_hash": "b396b35af535447444e7f8afbbcf759a4b55ed99f99cc757070fc4bf0a296dc1"}}, {"rule": 2, "type": "equivalent", "target": "d091137bf92885fadfe180dc9f63789c", "evidence": {"same_day": true, "patch_ids": ["d2a569906c031d1485855cbad9d5244a"], "statement_hash": "b396b35af535447444e7f8afbbcf759a4b55ed99f99cc757070fc4bf0a296dc1"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b0d851f55446341f7d688770837b557d", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Handle concurrent desummarization correctly during BRIN index scans", "evidence": {"same_day": true, "patch_ids": ["d2a569906c031d1485855cbad9d5244a"], "statement_hash": "b396b35af535447444e7f8afbbcf759a4b55ed99f99cc757070fc4bf0a296dc1"}, "url": "/docs/compare/?release=11.10#11.10-6f0f9d15911c0efa", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "0a3ab21daf4706eff4f4f2df196c4b50", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Handle concurrent desummarization correctly during BRIN index scans", "evidence": {"same_day": true, "patch_ids": ["d2a569906c031d1485855cbad9d5244a"], "statement_hash": "b396b35af535447444e7f8afbbcf759a4b55ed99f99cc757070fc4bf0a296dc1"}, "url": "/docs/compare/?release=10.15#10.15-6f0f9d15911c0efa", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "82130add7738c3d78e474a0a8d8e4203", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Handle concurrent desummarization correctly during BRIN index scans", "evidence": {"same_day": true, "patch_ids": ["d2a569906c031d1485855cbad9d5244a"], "statement_hash": "b396b35af535447444e7f8afbbcf759a4b55ed99f99cc757070fc4bf0a296dc1"}, "url": "/docs/compare/?release=9.6.20#9.6.20-6f0f9d15911c0efa", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "d091137bf92885fadfe180dc9f63789c", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Handle concurrent desummarization correctly during BRIN index scans", "evidence": {"same_day": true, "patch_ids": ["d2a569906c031d1485855cbad9d5244a"], "statement_hash": "b396b35af535447444e7f8afbbcf759a4b55ed99f99cc757070fc4bf0a296dc1"}, "url": "/docs/compare/?release=9.5.24#9.5.24-6f0f9d15911c0efa", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-0e610eea7b5d8349", "cves": [], "html": "Fix rare “lost saved point in index” errors in scans of multicolumn GIN indexes (Tom Lane) §
", "text": "Fix rare “lost saved point in index” errors in scans of multicolumn GIN indexes (Tom Lane) §", "title": "Fix rare “lost saved point in index” errors in scans of multicolumn GIN indexes", "commits": ["ff3c16d1e"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "d9f95582437f07caae650cdf0c92ae730f6b81c146fc593bd3a8a9b31831f423", "section_path": ["Changes"], "commit_groups": [["0d3ad6540", "0dfec43c8", "10564ee02", "11ecf4bd2", "1df14a566", "fabd2f9c9", "ff3c16d1e"]], "identity_text": "Fix rare lost saved point in index errors in scans of multicolumn GIN indexes (Tom Lane)", "commit_aliases": ["0d3ad6540", "0dfec43c8", "10564ee02", "11ecf4bd2", "1df14a566", "fabd2f9c9", "ff3c16d1e"], "source_commits": ["ff3c16d1e"], "source_entry_id": "12.5/changes/033", "db_id": "064186f416a1a4aad8799c66c67a5447", "patch_ids": ["b924aefe2f76cd5bce604a07e377c598"], "statement_hash": "86104ab659d2ff370250d7157a2b7c23f91dfd1dfca52879c01db4ca63908536", "relations": [{"rule": 2, "type": "equivalent", "target": "52d30363c69dac2bb8f3ae4975eb7ac9", "evidence": {"same_day": true, "patch_ids": ["b924aefe2f76cd5bce604a07e377c598"], "statement_hash": "86104ab659d2ff370250d7157a2b7c23f91dfd1dfca52879c01db4ca63908536"}}, {"rule": 2, "type": "equivalent", "target": "c334255955eec6880b1d2779cd57e4e4", "evidence": {"same_day": true, "patch_ids": ["b924aefe2f76cd5bce604a07e377c598"], "statement_hash": "86104ab659d2ff370250d7157a2b7c23f91dfd1dfca52879c01db4ca63908536"}}, {"rule": 2, "type": "equivalent", "target": "d541c04c0ca1ab8ab4f6fe954c577657", "evidence": {"same_day": true, "patch_ids": ["b924aefe2f76cd5bce604a07e377c598"], "statement_hash": "86104ab659d2ff370250d7157a2b7c23f91dfd1dfca52879c01db4ca63908536"}}, {"rule": 2, "type": "equivalent", "target": "fbe37de2248d241f2356e247421d66de", "evidence": {"same_day": true, "patch_ids": ["b924aefe2f76cd5bce604a07e377c598"], "statement_hash": "86104ab659d2ff370250d7157a2b7c23f91dfd1dfca52879c01db4ca63908536"}}], "version": "12.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "d541c04c0ca1ab8ab4f6fe954c577657", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Fix rare “lost saved point in index” errors in scans of multicolumn GIN indexes", "evidence": {"same_day": true, "patch_ids": ["b924aefe2f76cd5bce604a07e377c598"], "statement_hash": "86104ab659d2ff370250d7157a2b7c23f91dfd1dfca52879c01db4ca63908536"}, "url": "/docs/compare/?release=11.10#11.10-c466c174baf26b3e", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "52d30363c69dac2bb8f3ae4975eb7ac9", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Fix rare “lost saved point in index” errors in scans of multicolumn GIN indexes", "evidence": {"same_day": true, "patch_ids": ["b924aefe2f76cd5bce604a07e377c598"], "statement_hash": "86104ab659d2ff370250d7157a2b7c23f91dfd1dfca52879c01db4ca63908536"}, "url": "/docs/compare/?release=10.15#10.15-c466c174baf26b3e", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "fbe37de2248d241f2356e247421d66de", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Fix rare \"lost saved point in index\" errors in scans of multicolumn GIN indexes", "evidence": {"same_day": true, "patch_ids": ["b924aefe2f76cd5bce604a07e377c598"], "statement_hash": "86104ab659d2ff370250d7157a2b7c23f91dfd1dfca52879c01db4ca63908536"}, "url": "/docs/compare/?release=9.6.20#9.6.20-c36601db2bfd488d", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "c334255955eec6880b1d2779cd57e4e4", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Fix rare \"lost saved point in index\" errors in scans of multicolumn GIN indexes", "evidence": {"same_day": true, "patch_ids": ["b924aefe2f76cd5bce604a07e377c598"], "statement_hash": "86104ab659d2ff370250d7157a2b7c23f91dfd1dfca52879c01db4ca63908536"}, "url": "/docs/compare/?release=9.5.24#9.5.24-c36601db2bfd488d", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-33d1ac73a3c7711b", "cves": [], "html": "Fix buffered GiST index builds to work when the index has included columns (Pavel Borisov) §
", "text": "Fix buffered GiST index builds to work when the index has included columns (Pavel Borisov) §", "title": "Fix buffered GiST index builds to work when the index has included columns", "commits": ["12945874e"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "ecdabc5afa7fb9dff76cc26a295a28b1f6a301439615e96f08ab7f0076bcf0fe", "section_path": ["Changes"], "commit_groups": [["12945874e", "371668a83", "962ab473e"]], "identity_text": "Fix buffered GiST index builds to work when the index has included columns (Pavel Borisov)", "commit_aliases": ["12945874e", "371668a83", "962ab473e"], "source_commits": ["12945874e"], "source_entry_id": "12.5/changes/034", "db_id": "c6609f80bbb5bbc7d296f261f020647e", "patch_ids": ["15503c210c7190b67cc55fc711d48d48"], "statement_hash": "1a2c941f1c8128911ad42c6eaf55db66fe2c3a1e7d0c761e9b8305473f32bd79", "relations": [{"rule": 2, "type": "equivalent", "target": "ae591682bcbfaa811e33a6b790a536bb", "evidence": {"same_day": true, "patch_ids": ["15503c210c7190b67cc55fc711d48d48"], "statement_hash": "1a2c941f1c8128911ad42c6eaf55db66fe2c3a1e7d0c761e9b8305473f32bd79"}}], "version": "12.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "ae591682bcbfaa811e33a6b790a536bb", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Fix buffered GiST index builds to work when the index has included columns", "evidence": {"same_day": true, "patch_ids": ["15503c210c7190b67cc55fc711d48d48"], "statement_hash": "1a2c941f1c8128911ad42c6eaf55db66fe2c3a1e7d0c761e9b8305473f32bd79"}, "url": "/docs/compare/?release=13.1#13.1-4ec796bc827d056e", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}]}, {"id": "12.5-7342525e4b825b80", "cves": [], "html": "Fix unportable use of getnameinfo() in pg_hba_file_rules view (Tom Lane) §
On FreeBSD 11, and possibly other platforms, the view's address and netmask columns were always null due to this error.
Avoid crash if debug_query_string is NULL when starting a parallel worker (Noah Misch) §
Fix use-after-free hazard when an event trigger monitors an ALTER TABLE operation (Jehan-Guillaume de Rorthais) §
Avoid failures when a BEFORE ROW UPDATE trigger returns the “old” row of a table having dropped or “missing” columns (Amit Langote, Tom Lane) § §
This method of suppressing an update could result in crashes, unexpected CHECK constraint failures, or incorrect RETURNING output, because “missing” columns would read as NULLs for those purposes. (A column is “missing” for this purpose if it was added by ALTER TABLE ADD COLUMN with a non-NULL, but constant, default value.) Dropped columns could cause trouble as well.
Fix incorrect error message about inconsistent moving-aggregate data types (Jeff Janes) §
", "text": "Fix incorrect error message about inconsistent moving-aggregate data types (Jeff Janes) §", "title": "Fix incorrect error message about inconsistent moving-aggregate data types", "commits": ["f45dd3fed"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "cf419a0504352da5d50ebe9fa2e0ae5cb5470591ab3535f4dc0a7566d1194c32", "section_path": ["Changes"], "commit_groups": [["19ad7e1d7", "2939f613f", "baef6e5e9", "e0b4c7dd0", "f04203ab7", "f45dd3fed", "f71b93b86"]], "identity_text": "Fix incorrect error message about inconsistent moving-aggregate data types (Jeff Janes)", "commit_aliases": ["19ad7e1d7", "2939f613f", "baef6e5e9", "e0b4c7dd0", "f04203ab7", "f45dd3fed", "f71b93b86"], "source_commits": ["f45dd3fed"], "source_entry_id": "12.5/changes/039", "db_id": "b7734d735931a2594d8d810c0da0d263", "patch_ids": ["a6ee29024df492c5d25c7bde4de9462d"], "statement_hash": "2f86d5f772282f0258a4d8de711614f88964da3100750473f47d12c277bdeeea", "relations": [{"rule": 2, "type": "equivalent", "target": "5ba9e6ba479940ad29508d9f1f5f4557", "evidence": {"same_day": true, "patch_ids": ["a6ee29024df492c5d25c7bde4de9462d"], "statement_hash": "2f86d5f772282f0258a4d8de711614f88964da3100750473f47d12c277bdeeea"}}, {"rule": 2, "type": "equivalent", "target": "75d932c479a5ee215f22f5cbe20fac12", "evidence": {"same_day": true, "patch_ids": ["a6ee29024df492c5d25c7bde4de9462d"], "statement_hash": "2f86d5f772282f0258a4d8de711614f88964da3100750473f47d12c277bdeeea"}}, {"rule": 2, "type": "equivalent", "target": "79da3f5b1b63a3182fa29eb6dd66f0ac", "evidence": {"same_day": true, "patch_ids": ["a6ee29024df492c5d25c7bde4de9462d"], "statement_hash": "2f86d5f772282f0258a4d8de711614f88964da3100750473f47d12c277bdeeea"}}, {"rule": 2, "type": "equivalent", "target": "b92857f8895e8e33ac12acfd3b0da7b7", "evidence": {"same_day": true, "patch_ids": ["a6ee29024df492c5d25c7bde4de9462d"], "statement_hash": "2f86d5f772282f0258a4d8de711614f88964da3100750473f47d12c277bdeeea"}}], "version": "12.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "b92857f8895e8e33ac12acfd3b0da7b7", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Fix incorrect error message about inconsistent moving-aggregate data types", "evidence": {"same_day": true, "patch_ids": ["a6ee29024df492c5d25c7bde4de9462d"], "statement_hash": "2f86d5f772282f0258a4d8de711614f88964da3100750473f47d12c277bdeeea"}, "url": "/docs/compare/?release=11.10#11.10-bc5344f5e57d9eda", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "75d932c479a5ee215f22f5cbe20fac12", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Fix incorrect error message about inconsistent moving-aggregate data types", "evidence": {"same_day": true, "patch_ids": ["a6ee29024df492c5d25c7bde4de9462d"], "statement_hash": "2f86d5f772282f0258a4d8de711614f88964da3100750473f47d12c277bdeeea"}, "url": "/docs/compare/?release=10.15#10.15-bc5344f5e57d9eda", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "5ba9e6ba479940ad29508d9f1f5f4557", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Fix incorrect error message about inconsistent moving-aggregate data types", "evidence": {"same_day": true, "patch_ids": ["a6ee29024df492c5d25c7bde4de9462d"], "statement_hash": "2f86d5f772282f0258a4d8de711614f88964da3100750473f47d12c277bdeeea"}, "url": "/docs/compare/?release=9.6.20#9.6.20-bc5344f5e57d9eda", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "79da3f5b1b63a3182fa29eb6dd66f0ac", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Fix incorrect error message about inconsistent moving-aggregate data types", "evidence": {"same_day": true, "patch_ids": ["a6ee29024df492c5d25c7bde4de9462d"], "statement_hash": "2f86d5f772282f0258a4d8de711614f88964da3100750473f47d12c277bdeeea"}, "url": "/docs/compare/?release=9.5.24#9.5.24-bc5344f5e57d9eda", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-81a3e4982fc1d917", "cves": [], "html": "Avoid lockup when a parallel worker reports a very long error message (Vignesh C) §
", "text": "Avoid lockup when a parallel worker reports a very long error message (Vignesh C) §", "title": "Avoid lockup when a parallel worker reports a very long error message", "commits": ["82dd373f2"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "d3b89537fc7ac14c9d03f76c782bc8b0ff740ce2240bb1264319a0d857b0280e", "section_path": ["Changes"], "commit_groups": [["17424e79d", "2500e51e7", "2a938c793", "3738651f5", "526df0a23", "82dd373f2", "be4b0c007"]], "identity_text": "Avoid lockup when a parallel worker reports a very long error message (Vignesh C)", "commit_aliases": ["17424e79d", "2500e51e7", "2a938c793", "3738651f5", "526df0a23", "82dd373f2", "be4b0c007"], "source_commits": ["82dd373f2"], "source_entry_id": "12.5/changes/040", "db_id": "6603b8505054465791635c102026e763", "patch_ids": ["c2dea10c2eaf9a14751919026d5a82f0"], "statement_hash": "9a1afa7cc019b644f33876e98b16a00d4e3796963507f87a87e058aaebe1fabe", "relations": [{"rule": 2, "type": "equivalent", "target": "38691d1ad3e39be8aa41d7fb3c16628c", "evidence": {"same_day": true, "patch_ids": ["c2dea10c2eaf9a14751919026d5a82f0"], "statement_hash": "9a1afa7cc019b644f33876e98b16a00d4e3796963507f87a87e058aaebe1fabe"}}, {"rule": 2, "type": "equivalent", "target": "66672a1540adc34224fa39b4fbc3deff", "evidence": {"same_day": true, "patch_ids": ["c2dea10c2eaf9a14751919026d5a82f0"], "statement_hash": "9a1afa7cc019b644f33876e98b16a00d4e3796963507f87a87e058aaebe1fabe"}}, {"rule": 2, "type": "equivalent", "target": "adf19289b8ccad8481294cf61720a125", "evidence": {"same_day": true, "patch_ids": ["c2dea10c2eaf9a14751919026d5a82f0"], "statement_hash": "9a1afa7cc019b644f33876e98b16a00d4e3796963507f87a87e058aaebe1fabe"}}, {"rule": 2, "type": "equivalent", "target": "ca2fe3f27731efae36e979cc401b5d26", "evidence": {"same_day": true, "patch_ids": ["c2dea10c2eaf9a14751919026d5a82f0"], "statement_hash": "9a1afa7cc019b644f33876e98b16a00d4e3796963507f87a87e058aaebe1fabe"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "adf19289b8ccad8481294cf61720a125", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Avoid lockup when a parallel worker reports a very long error message", "evidence": {"same_day": true, "patch_ids": ["c2dea10c2eaf9a14751919026d5a82f0"], "statement_hash": "9a1afa7cc019b644f33876e98b16a00d4e3796963507f87a87e058aaebe1fabe"}, "url": "/docs/compare/?release=11.10#11.10-8dcefcc2da9e8171", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "66672a1540adc34224fa39b4fbc3deff", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Avoid lockup when a parallel worker reports a very long error message", "evidence": {"same_day": true, "patch_ids": ["c2dea10c2eaf9a14751919026d5a82f0"], "statement_hash": "9a1afa7cc019b644f33876e98b16a00d4e3796963507f87a87e058aaebe1fabe"}, "url": "/docs/compare/?release=10.15#10.15-8dcefcc2da9e8171", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "38691d1ad3e39be8aa41d7fb3c16628c", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Avoid lockup when a parallel worker reports a very long error message", "evidence": {"same_day": true, "patch_ids": ["c2dea10c2eaf9a14751919026d5a82f0"], "statement_hash": "9a1afa7cc019b644f33876e98b16a00d4e3796963507f87a87e058aaebe1fabe"}, "url": "/docs/compare/?release=9.6.20#9.6.20-8dcefcc2da9e8171", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "ca2fe3f27731efae36e979cc401b5d26", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Avoid lockup when a parallel worker reports a very long error message", "evidence": {"same_day": true, "patch_ids": ["c2dea10c2eaf9a14751919026d5a82f0"], "statement_hash": "9a1afa7cc019b644f33876e98b16a00d4e3796963507f87a87e058aaebe1fabe"}, "url": "/docs/compare/?release=9.5.24#9.5.24-8dcefcc2da9e8171", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-7887982efb40aae8", "cves": [], "html": "Avoid unnecessary failure when transferring very large payloads through shared memory queues (Markus Wanner) §
", "text": "Avoid unnecessary failure when transferring very large payloads through shared memory queues (Markus Wanner) §", "title": "Avoid unnecessary failure when transferring very large payloads through shared memory queues", "commits": ["bd0677bb8"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "04fee37e5328ee9f1612feec8ef01dee9a27e70812c18d5708d8689003bb7cda", "section_path": ["Changes"], "commit_groups": [["1f53d0b9f", "6e03a8a30", "bd0677bb8", "d27c18d26", "d4e654d15", "f78ebbe68"]], "identity_text": "Avoid unnecessary failure when transferring very large payloads through shared memory queues (Markus Wanner)", "commit_aliases": ["1f53d0b9f", "6e03a8a30", "bd0677bb8", "d27c18d26", "d4e654d15", "f78ebbe68"], "source_commits": ["bd0677bb8"], "source_entry_id": "12.5/changes/041", "db_id": "12ff41f26722da3cc3a0ed8a75a9eec6", "patch_ids": ["f1543ff09429b9ab4c2897da71522546"], "statement_hash": "9b370220379a888f4a09f8f6cdaa9cfeaf1a181713b0a53730f6f0128b090878", "relations": [{"rule": 2, "type": "equivalent", "target": "4ba2ea381edaca1a2af12cc610701790", "evidence": {"same_day": true, "patch_ids": ["f1543ff09429b9ab4c2897da71522546"], "statement_hash": "9b370220379a888f4a09f8f6cdaa9cfeaf1a181713b0a53730f6f0128b090878"}}, {"rule": 2, "type": "equivalent", "target": "722acae857036426760487d25452bcc2", "evidence": {"same_day": true, "patch_ids": ["f1543ff09429b9ab4c2897da71522546"], "statement_hash": "9b370220379a888f4a09f8f6cdaa9cfeaf1a181713b0a53730f6f0128b090878"}}, {"rule": 2, "type": "equivalent", "target": "bb9141f24650e5106970fe90e0922e78", "evidence": {"same_day": true, "patch_ids": ["f1543ff09429b9ab4c2897da71522546"], "statement_hash": "9b370220379a888f4a09f8f6cdaa9cfeaf1a181713b0a53730f6f0128b090878"}}, {"rule": 2, "type": "equivalent", "target": "dece852415693fdfc7ab729e403fbc5e", "evidence": {"same_day": true, "patch_ids": ["f1543ff09429b9ab4c2897da71522546"], "statement_hash": "9b370220379a888f4a09f8f6cdaa9cfeaf1a181713b0a53730f6f0128b090878"}}, {"rule": 2, "type": "equivalent", "target": "e93b23d1f0a5d1a9e2736c1b8a37d392", "evidence": {"same_day": true, "patch_ids": ["f1543ff09429b9ab4c2897da71522546"], "statement_hash": "9b370220379a888f4a09f8f6cdaa9cfeaf1a181713b0a53730f6f0128b090878"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "dece852415693fdfc7ab729e403fbc5e", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Avoid unnecessary failure when transferring very large payloads through shared memory queues", "evidence": {"same_day": true, "patch_ids": ["f1543ff09429b9ab4c2897da71522546"], "statement_hash": "9b370220379a888f4a09f8f6cdaa9cfeaf1a181713b0a53730f6f0128b090878"}, "url": "/docs/compare/?release=13.1#13.1-210e18fd8bf5ac2c", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}, {"db_id": "4ba2ea381edaca1a2af12cc610701790", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Avoid unnecessary failure when transferring very large payloads through shared memory queues", "evidence": {"same_day": true, "patch_ids": ["f1543ff09429b9ab4c2897da71522546"], "statement_hash": "9b370220379a888f4a09f8f6cdaa9cfeaf1a181713b0a53730f6f0128b090878"}, "url": "/docs/compare/?release=11.10#11.10-41571a99709b559e", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "e93b23d1f0a5d1a9e2736c1b8a37d392", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Avoid unnecessary failure when transferring very large payloads through shared memory queues", "evidence": {"same_day": true, "patch_ids": ["f1543ff09429b9ab4c2897da71522546"], "statement_hash": "9b370220379a888f4a09f8f6cdaa9cfeaf1a181713b0a53730f6f0128b090878"}, "url": "/docs/compare/?release=10.15#10.15-41571a99709b559e", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "bb9141f24650e5106970fe90e0922e78", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Avoid unnecessary failure when transferring very large payloads through shared memory queues", "evidence": {"same_day": true, "patch_ids": ["f1543ff09429b9ab4c2897da71522546"], "statement_hash": "9b370220379a888f4a09f8f6cdaa9cfeaf1a181713b0a53730f6f0128b090878"}, "url": "/docs/compare/?release=9.6.20#9.6.20-41571a99709b559e", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "722acae857036426760487d25452bcc2", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Avoid unnecessary failure when transferring very large payloads through shared memory queues", "evidence": {"same_day": true, "patch_ids": ["f1543ff09429b9ab4c2897da71522546"], "statement_hash": "9b370220379a888f4a09f8f6cdaa9cfeaf1a181713b0a53730f6f0128b090878"}, "url": "/docs/compare/?release=9.5.24#9.5.24-41571a99709b559e", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-c8bb8dc7c5c97a78", "cves": [], "html": "Fix incorrect handling of template function attributes in JIT code generation (Andres Freund) § §
\nThis has been shown to cause crashes on s390x, and very possibly there are other cases on other platforms.
Fix relation cache memory leaks with RLS policies (Tom Lane) §
", "text": "Fix relation cache memory leaks with RLS policies (Tom Lane) §", "title": "Fix relation cache memory leaks with RLS policies", "commits": ["bda32733c"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "3deeea70a5b87f4cac811ffa62385d293b627a2c7febd5b0846962e59c246a75", "section_path": ["Changes"], "commit_groups": [["acab757ce", "bda32733c", "bf34ae930", "dd89ba578", "de6725deb", "e55f718fc", "f7873900f"]], "identity_text": "Fix relation cache memory leaks with RLS policies (Tom Lane)", "commit_aliases": ["acab757ce", "bda32733c", "bf34ae930", "dd89ba578", "de6725deb", "e55f718fc", "f7873900f"], "source_commits": ["bda32733c"], "source_entry_id": "12.5/changes/043", "db_id": "1d1e000571e98ddba13a80b34159607c", "patch_ids": ["c24aa3c25cf4a9d607cd0598510176a8"], "statement_hash": "79cb4e31c8b65a7fae0c050240167102daaf3fa393b29d81235d95db94f424a6", "relations": [{"rule": 2, "type": "equivalent", "target": "07c3f5f11a8d2c9b2f973d49833ab88a", "evidence": {"same_day": true, "patch_ids": ["c24aa3c25cf4a9d607cd0598510176a8"], "statement_hash": "79cb4e31c8b65a7fae0c050240167102daaf3fa393b29d81235d95db94f424a6"}}, {"rule": 2, "type": "equivalent", "target": "3d75c60cd5c1cd0602d6a8ef90e7175f", "evidence": {"same_day": true, "patch_ids": ["c24aa3c25cf4a9d607cd0598510176a8"], "statement_hash": "79cb4e31c8b65a7fae0c050240167102daaf3fa393b29d81235d95db94f424a6"}}, {"rule": 2, "type": "equivalent", "target": "7b847625301e69666a78bf22a37c5dbb", "evidence": {"same_day": true, "patch_ids": ["c24aa3c25cf4a9d607cd0598510176a8"], "statement_hash": "79cb4e31c8b65a7fae0c050240167102daaf3fa393b29d81235d95db94f424a6"}}, {"rule": 2, "type": "equivalent", "target": "96cd0fff2b6e9846599349b6ba5d2bd9", "evidence": {"same_day": true, "patch_ids": ["c24aa3c25cf4a9d607cd0598510176a8"], "statement_hash": "79cb4e31c8b65a7fae0c050240167102daaf3fa393b29d81235d95db94f424a6"}}, {"rule": 2, "type": "equivalent", "target": "b391f3e10b25d2204b81bd3ea8bad6d7", "evidence": {"same_day": true, "patch_ids": ["c24aa3c25cf4a9d607cd0598510176a8"], "statement_hash": "79cb4e31c8b65a7fae0c050240167102daaf3fa393b29d81235d95db94f424a6"}}], "version": "12.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "3d75c60cd5c1cd0602d6a8ef90e7175f", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Fix relation cache memory leaks with RLS policies", "evidence": {"same_day": true, "patch_ids": ["c24aa3c25cf4a9d607cd0598510176a8"], "statement_hash": "79cb4e31c8b65a7fae0c050240167102daaf3fa393b29d81235d95db94f424a6"}, "url": "/docs/compare/?release=13.1#13.1-fc30b1fb28ea1177", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}, {"db_id": "96cd0fff2b6e9846599349b6ba5d2bd9", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Fix relation cache memory leaks with RLS policies", "evidence": {"same_day": true, "patch_ids": ["c24aa3c25cf4a9d607cd0598510176a8"], "statement_hash": "79cb4e31c8b65a7fae0c050240167102daaf3fa393b29d81235d95db94f424a6"}, "url": "/docs/compare/?release=11.10#11.10-0c9348abde59c6b4", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "07c3f5f11a8d2c9b2f973d49833ab88a", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Fix relation cache memory leaks with RLS policies", "evidence": {"same_day": true, "patch_ids": ["c24aa3c25cf4a9d607cd0598510176a8"], "statement_hash": "79cb4e31c8b65a7fae0c050240167102daaf3fa393b29d81235d95db94f424a6"}, "url": "/docs/compare/?release=10.15#10.15-0c9348abde59c6b4", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "b391f3e10b25d2204b81bd3ea8bad6d7", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Fix relation cache memory leaks with RLS policies", "evidence": {"same_day": true, "patch_ids": ["c24aa3c25cf4a9d607cd0598510176a8"], "statement_hash": "79cb4e31c8b65a7fae0c050240167102daaf3fa393b29d81235d95db94f424a6"}, "url": "/docs/compare/?release=9.6.20#9.6.20-0c9348abde59c6b4", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "7b847625301e69666a78bf22a37c5dbb", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Fix relation cache memory leaks with RLS policies", "evidence": {"same_day": true, "patch_ids": ["c24aa3c25cf4a9d607cd0598510176a8"], "statement_hash": "79cb4e31c8b65a7fae0c050240167102daaf3fa393b29d81235d95db94f424a6"}, "url": "/docs/compare/?release=9.5.24#9.5.24-0c9348abde59c6b4", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-80bb1a21a38a3a1c", "cves": [], "html": "Fix edge-case memory leak in index_get_partition() (Justin Pryzby) §
Fix small memory leak when SIGHUP processing decides that a new GUC variable value cannot be applied without a restart (Tom Lane) §
", "text": "Fix small memory leak when SIGHUP processing decides that a new GUC variable value cannot be applied without a restart (Tom Lane) §", "title": "Fix small memory leak when SIGHUP processing decides that a new GUC variable value cannot be applied without a restart", "commits": ["f35c11770"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "5da505ffe072bd02d31fe54e82be7d9993138a9cee4c458666676cbd65c2e212", "section_path": ["Changes"], "commit_groups": [["397ea901e", "43ca5e07d", "9343bfefa", "a5c77e6b8", "c7573ab1e", "cfa4cff30", "f35c11770"]], "identity_text": "Fix small memory leak when SIGHUP processing decides that a new GUC variable value cannot be applied without a restart (Tom Lane)", "commit_aliases": ["397ea901e", "43ca5e07d", "9343bfefa", "a5c77e6b8", "c7573ab1e", "cfa4cff30", "f35c11770"], "source_commits": ["f35c11770"], "source_entry_id": "12.5/changes/045", "db_id": "509d82dee875e19aea96bee48e3e49bf", "patch_ids": ["c33393f6e879fadc7ea327660916e5c1"], "statement_hash": "ebb2c0e9b0854b0d6d7dad9a3f3dfa2d53fea99cc4b20ca90b674c1555c26f00", "relations": [{"rule": 2, "type": "equivalent", "target": "0be0283de15f1b9d28b4fe88d79cf481", "evidence": {"same_day": true, "patch_ids": ["c33393f6e879fadc7ea327660916e5c1"], "statement_hash": "ebb2c0e9b0854b0d6d7dad9a3f3dfa2d53fea99cc4b20ca90b674c1555c26f00"}}, {"rule": 2, "type": "equivalent", "target": "82baed7f6bc4e4089d9fa33cd5906ed1", "evidence": {"same_day": true, "patch_ids": ["c33393f6e879fadc7ea327660916e5c1"], "statement_hash": "ebb2c0e9b0854b0d6d7dad9a3f3dfa2d53fea99cc4b20ca90b674c1555c26f00"}}, {"rule": 2, "type": "equivalent", "target": "a373153a55f8a80e8ddf4a2c75367c01", "evidence": {"same_day": true, "patch_ids": ["c33393f6e879fadc7ea327660916e5c1"], "statement_hash": "ebb2c0e9b0854b0d6d7dad9a3f3dfa2d53fea99cc4b20ca90b674c1555c26f00"}}, {"rule": 2, "type": "equivalent", "target": "e3ce1a7779af456eb60753c476539994", "evidence": {"same_day": true, "patch_ids": ["c33393f6e879fadc7ea327660916e5c1"], "statement_hash": "ebb2c0e9b0854b0d6d7dad9a3f3dfa2d53fea99cc4b20ca90b674c1555c26f00"}}, {"rule": 2, "type": "equivalent", "target": "fb7d08b18e099bd56d514ea6ca3b5ea0", "evidence": {"same_day": true, "patch_ids": ["c33393f6e879fadc7ea327660916e5c1"], "statement_hash": "ebb2c0e9b0854b0d6d7dad9a3f3dfa2d53fea99cc4b20ca90b674c1555c26f00"}}], "version": "12.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "a373153a55f8a80e8ddf4a2c75367c01", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Fix small memory leak when SIGHUP processing decides that a new GUC variable value cannot be applied without a restart", "evidence": {"same_day": true, "patch_ids": ["c33393f6e879fadc7ea327660916e5c1"], "statement_hash": "ebb2c0e9b0854b0d6d7dad9a3f3dfa2d53fea99cc4b20ca90b674c1555c26f00"}, "url": "/docs/compare/?release=13.1#13.1-6cc9fe20ad617d75", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}, {"db_id": "0be0283de15f1b9d28b4fe88d79cf481", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Fix small memory leak when SIGHUP processing decides that a new GUC variable value cannot be applied without a restart", "evidence": {"same_day": true, "patch_ids": ["c33393f6e879fadc7ea327660916e5c1"], "statement_hash": "ebb2c0e9b0854b0d6d7dad9a3f3dfa2d53fea99cc4b20ca90b674c1555c26f00"}, "url": "/docs/compare/?release=11.10#11.10-d1936a4ef35bd840", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "e3ce1a7779af456eb60753c476539994", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Fix small memory leak when SIGHUP processing decides that a new GUC variable value cannot be applied without a restart", "evidence": {"same_day": true, "patch_ids": ["c33393f6e879fadc7ea327660916e5c1"], "statement_hash": "ebb2c0e9b0854b0d6d7dad9a3f3dfa2d53fea99cc4b20ca90b674c1555c26f00"}, "url": "/docs/compare/?release=10.15#10.15-d1936a4ef35bd840", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "fb7d08b18e099bd56d514ea6ca3b5ea0", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Fix small memory leak when SIGHUP processing decides that a new GUC variable value cannot be applied without a restart", "evidence": {"same_day": true, "patch_ids": ["c33393f6e879fadc7ea327660916e5c1"], "statement_hash": "ebb2c0e9b0854b0d6d7dad9a3f3dfa2d53fea99cc4b20ca90b674c1555c26f00"}, "url": "/docs/compare/?release=9.6.20#9.6.20-d1936a4ef35bd840", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "82baed7f6bc4e4089d9fa33cd5906ed1", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Fix small memory leak when SIGHUP processing decides that a new GUC variable value cannot be applied without a restart", "evidence": {"same_day": true, "patch_ids": ["c33393f6e879fadc7ea327660916e5c1"], "statement_hash": "ebb2c0e9b0854b0d6d7dad9a3f3dfa2d53fea99cc4b20ca90b674c1555c26f00"}, "url": "/docs/compare/?release=9.5.24#9.5.24-d1936a4ef35bd840", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-866265e1d961abac", "cves": [], "html": "Fix memory leaks in PL/pgsql's CALL processing (Pavel Stehule, Tom Lane) §
Make libpq support arbitrary-length lines in .pgpass files (Tom Lane) § §
This is mostly useful to allow using very long security tokens as passwords.
", "text": "Make libpq support arbitrary-length lines in .pgpass files (Tom Lane) § § This is mostly useful to allow using very long security tokens as passwords.", "title": "Make libpq support arbitrary-length lines in .pgpass files", "commits": ["55aea0c70", "fc37c6f61"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "0c0f958bb775b35189248c78693dfe8c693be2aa767bb8771f12a4c77d75a226", "section_path": ["Changes"], "commit_groups": [["0c0a3a859", "4178b7499", "55aea0c70", "8d486cfbf", "b55b4dad9", "ba23174dd", "df8020b32"], ["4d41823c5", "546479f34", "8df601bd4", "d7ae549e3", "fc37c6f61"]], "identity_text": "Make libpq support arbitrary-length lines in .pgpass files (Tom Lane) This is mostly useful to allow using very long security tokens as passwords.", "commit_aliases": ["0c0a3a859", "4178b7499", "4d41823c5", "546479f34", "55aea0c70", "8d486cfbf", "8df601bd4", "b55b4dad9", "ba23174dd", "d7ae549e3", "df8020b32", "fc37c6f61"], "source_commits": ["55aea0c70", "fc37c6f61"], "source_entry_id": "12.5/changes/047", "db_id": "42985fac1d65c9be84f4309528a5cc93", "patch_ids": ["2951f41d3eeb6c1a9df52e929f7316a7", "c7b0b5432d7230e7d6eaec7c119c6292"], "statement_hash": "b34f03452c03656619e8482178cbd67b9a43704fb74edfb899e9320794189587", "relations": [{"rule": 2, "type": "equivalent", "target": "226b9718830bf38fe8891045cd1d0647", "evidence": {"same_day": true, "patch_ids": ["2951f41d3eeb6c1a9df52e929f7316a7", "c7b0b5432d7230e7d6eaec7c119c6292"], "statement_hash": "b34f03452c03656619e8482178cbd67b9a43704fb74edfb899e9320794189587"}}, {"rule": 2, "type": "equivalent", "target": "7ab509524aab4c60c5a68bcd37aa7242", "evidence": {"same_day": true, "patch_ids": ["2951f41d3eeb6c1a9df52e929f7316a7", "c7b0b5432d7230e7d6eaec7c119c6292"], "statement_hash": "b34f03452c03656619e8482178cbd67b9a43704fb74edfb899e9320794189587"}}, {"rule": 2, "type": "equivalent", "target": "92c53642b4a035ddb2479098010e33a5", "evidence": {"same_day": true, "patch_ids": ["2951f41d3eeb6c1a9df52e929f7316a7", "c7b0b5432d7230e7d6eaec7c119c6292"], "statement_hash": "b34f03452c03656619e8482178cbd67b9a43704fb74edfb899e9320794189587"}}, {"rule": 2, "type": "equivalent", "target": "a8756cf7c9f018cdc0b1de84f1974ed2", "evidence": {"same_day": true, "patch_ids": ["2951f41d3eeb6c1a9df52e929f7316a7", "c7b0b5432d7230e7d6eaec7c119c6292"], "statement_hash": "b34f03452c03656619e8482178cbd67b9a43704fb74edfb899e9320794189587"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "7ab509524aab4c60c5a68bcd37aa7242", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Make libpq support arbitrary-length lines in .pgpass files", "evidence": {"same_day": true, "patch_ids": ["2951f41d3eeb6c1a9df52e929f7316a7", "c7b0b5432d7230e7d6eaec7c119c6292"], "statement_hash": "b34f03452c03656619e8482178cbd67b9a43704fb74edfb899e9320794189587"}, "url": "/docs/compare/?release=11.10#11.10-475f920e9b250528", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "92c53642b4a035ddb2479098010e33a5", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Make libpq support arbitrary-length lines in .pgpass files", "evidence": {"same_day": true, "patch_ids": ["2951f41d3eeb6c1a9df52e929f7316a7", "c7b0b5432d7230e7d6eaec7c119c6292"], "statement_hash": "b34f03452c03656619e8482178cbd67b9a43704fb74edfb899e9320794189587"}, "url": "/docs/compare/?release=10.15#10.15-475f920e9b250528", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "226b9718830bf38fe8891045cd1d0647", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Make libpq support arbitrary-length lines in .pgpass files", "evidence": {"same_day": true, "patch_ids": ["2951f41d3eeb6c1a9df52e929f7316a7", "c7b0b5432d7230e7d6eaec7c119c6292"], "statement_hash": "b34f03452c03656619e8482178cbd67b9a43704fb74edfb899e9320794189587"}, "url": "/docs/compare/?release=9.6.20#9.6.20-475f920e9b250528", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "a8756cf7c9f018cdc0b1de84f1974ed2", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Make libpq support arbitrary-length lines in .pgpass files", "evidence": {"same_day": true, "patch_ids": ["2951f41d3eeb6c1a9df52e929f7316a7", "c7b0b5432d7230e7d6eaec7c119c6292"], "statement_hash": "b34f03452c03656619e8482178cbd67b9a43704fb74edfb899e9320794189587"}, "url": "/docs/compare/?release=9.5.24#9.5.24-475f920e9b250528", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-e80962d233c1a58a", "cves": [], "html": "In libpq for Windows, call WSAStartup() once per process and WSACleanup() not at all (Tom Lane, Alexander Lakhin) §
Previously, libpq invoked WSAStartup() at connection start and WSACleanup() at connection cleanup. However, it appears that calling WSACleanup() can interfere with other program operations; notably, we have observed rare failures to emit expected output to stdout. There appear to be no ill effects from omitting the call, so do that. (This also eliminates a performance issue from repeated DLL loads and unloads when a program performs a series of database connections.)
Fix ecpg library's per-thread initialization logic for Windows (Tom Lane, Alexander Lakhin) §
\nMulti-threaded ecpg applications could suffer rare misbehavior due to incorrect locking.
", "text": "Fix ecpg library's per-thread initialization logic for Windows (Tom Lane, Alexander Lakhin) § Multi-threaded ecpg applications could suffer rare misbehavior due to incorrect locking.", "title": "Fix ecpg library's per-thread initialization logic for Windows", "commits": ["bdc79ddd1"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "790d9002a888c8ccf966a9e06cd12f1c9f12b01c23f2b1b545249ba73ad25038", "section_path": ["Changes"], "commit_groups": [["12a73f29f", "21d36747d", "379c43bda", "758b45e83", "bdc79ddd1", "f38b66ec0", "fd048e0cb"]], "identity_text": "Fix ecpg library's per-thread initialization logic for Windows (Tom Lane, Alexander Lakhin) Multi-threaded ecpg applications could suffer rare misbehavior due to incorrect locking.", "commit_aliases": ["12a73f29f", "21d36747d", "379c43bda", "758b45e83", "bdc79ddd1", "f38b66ec0", "fd048e0cb"], "source_commits": ["bdc79ddd1"], "source_entry_id": "12.5/changes/049", "db_id": "c250772a9e8ab85f9074deec9d995871", "patch_ids": ["bb9293718d8ff1ab911d92ebe44317c6"], "statement_hash": "bff07dc16c24f2d4b16cc80208cbf23717742f46ffffda22427c03dfe30950c6", "relations": [{"rule": 2, "type": "equivalent", "target": "0c91ba08f7a39546e2d58212d390fb9f", "evidence": {"same_day": true, "patch_ids": ["bb9293718d8ff1ab911d92ebe44317c6"], "statement_hash": "bff07dc16c24f2d4b16cc80208cbf23717742f46ffffda22427c03dfe30950c6"}}, {"rule": 2, "type": "equivalent", "target": "1ed5dde67f6486babd2a0d24dffdc57d", "evidence": {"same_day": true, "patch_ids": ["bb9293718d8ff1ab911d92ebe44317c6"], "statement_hash": "bff07dc16c24f2d4b16cc80208cbf23717742f46ffffda22427c03dfe30950c6"}}, {"rule": 2, "type": "equivalent", "target": "694cc9062e942a7e36d2268cc47ca86b", "evidence": {"same_day": true, "patch_ids": ["bb9293718d8ff1ab911d92ebe44317c6"], "statement_hash": "bff07dc16c24f2d4b16cc80208cbf23717742f46ffffda22427c03dfe30950c6"}}, {"rule": 2, "type": "equivalent", "target": "b685c8ce1e0ac047162d851829393e09", "evidence": {"same_day": true, "patch_ids": ["bb9293718d8ff1ab911d92ebe44317c6"], "statement_hash": "bff07dc16c24f2d4b16cc80208cbf23717742f46ffffda22427c03dfe30950c6"}}, {"rule": 2, "type": "equivalent", "target": "bdf254d55b6f5ae4944f832d4e4aba90", "evidence": {"same_day": true, "patch_ids": ["bb9293718d8ff1ab911d92ebe44317c6"], "statement_hash": "bff07dc16c24f2d4b16cc80208cbf23717742f46ffffda22427c03dfe30950c6"}}], "version": "12.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "694cc9062e942a7e36d2268cc47ca86b", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Fix ecpg library's per-thread initialization logic for Windows", "evidence": {"same_day": true, "patch_ids": ["bb9293718d8ff1ab911d92ebe44317c6"], "statement_hash": "bff07dc16c24f2d4b16cc80208cbf23717742f46ffffda22427c03dfe30950c6"}, "url": "/docs/compare/?release=13.1#13.1-2267e558b078d8ca", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}, {"db_id": "b685c8ce1e0ac047162d851829393e09", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Fix ecpg library's per-thread initialization logic for Windows", "evidence": {"same_day": true, "patch_ids": ["bb9293718d8ff1ab911d92ebe44317c6"], "statement_hash": "bff07dc16c24f2d4b16cc80208cbf23717742f46ffffda22427c03dfe30950c6"}, "url": "/docs/compare/?release=11.10#11.10-8e679dd8b51f3233", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "0c91ba08f7a39546e2d58212d390fb9f", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Fix ecpg library's per-thread initialization logic for Windows", "evidence": {"same_day": true, "patch_ids": ["bb9293718d8ff1ab911d92ebe44317c6"], "statement_hash": "bff07dc16c24f2d4b16cc80208cbf23717742f46ffffda22427c03dfe30950c6"}, "url": "/docs/compare/?release=10.15#10.15-8e679dd8b51f3233", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "bdf254d55b6f5ae4944f832d4e4aba90", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Fix ecpg library's per-thread initialization logic for Windows", "evidence": {"same_day": true, "patch_ids": ["bb9293718d8ff1ab911d92ebe44317c6"], "statement_hash": "bff07dc16c24f2d4b16cc80208cbf23717742f46ffffda22427c03dfe30950c6"}, "url": "/docs/compare/?release=9.6.20#9.6.20-8e679dd8b51f3233", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "1ed5dde67f6486babd2a0d24dffdc57d", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Fix ecpg library's per-thread initialization logic for Windows", "evidence": {"same_day": true, "patch_ids": ["bb9293718d8ff1ab911d92ebe44317c6"], "statement_hash": "bff07dc16c24f2d4b16cc80208cbf23717742f46ffffda22427c03dfe30950c6"}, "url": "/docs/compare/?release=9.5.24#9.5.24-8e679dd8b51f3233", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-57376eee8ffa54c5", "cves": [], "html": "On Windows, make psql read the output of a backtick command in text mode, not binary mode (Tom Lane) §
\nThis ensures proper handling of newlines.
", "text": "On Windows, make psql read the output of a backtick command in text mode, not binary mode (Tom Lane) § This ensures proper handling of newlines.", "title": "On Windows, make psql read the output of a backtick command in text mode, not binary mode", "commits": ["cb0982ba9"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "4e28d09e189f54d42f49c5e1a3088f0aaf55d7329bbe0280d104e06395734077", "section_path": ["Changes"], "commit_groups": [["204d77969", "504f963f7", "66f8687a8", "9eb250339", "aff06436c", "ba4f5413e", "cb0982ba9"]], "identity_text": "On Windows, make psql read the output of a backtick command in text mode, not binary mode (Tom Lane) This ensures proper handling of newlines.", "commit_aliases": ["204d77969", "504f963f7", "66f8687a8", "9eb250339", "aff06436c", "ba4f5413e", "cb0982ba9"], "source_commits": ["cb0982ba9"], "source_entry_id": "12.5/changes/050", "db_id": "acc4b62da548c94c0aaf301e49228dab", "patch_ids": ["f0676a6fd578633b244e3954ef8f397e"], "statement_hash": "147d56f6b961c6a8edec12ec9b0202a87651e641b126376307f1ceff34e989e0", "relations": [{"rule": 2, "type": "equivalent", "target": "12b9e9de7e0b7392bbc1d550c6cd6df6", "evidence": {"same_day": true, "patch_ids": ["f0676a6fd578633b244e3954ef8f397e"], "statement_hash": "147d56f6b961c6a8edec12ec9b0202a87651e641b126376307f1ceff34e989e0"}}, {"rule": 2, "type": "equivalent", "target": "4913189de70c687d45c2182a4f59108c", "evidence": {"same_day": true, "patch_ids": ["f0676a6fd578633b244e3954ef8f397e"], "statement_hash": "147d56f6b961c6a8edec12ec9b0202a87651e641b126376307f1ceff34e989e0"}}, {"rule": 2, "type": "equivalent", "target": "53bb8143f97e643054b70a519a5cd076", "evidence": {"same_day": true, "patch_ids": ["f0676a6fd578633b244e3954ef8f397e"], "statement_hash": "147d56f6b961c6a8edec12ec9b0202a87651e641b126376307f1ceff34e989e0"}}, {"rule": 2, "type": "equivalent", "target": "9b1ff42f9ce9a78c5329d18bf7b57a2c", "evidence": {"same_day": true, "patch_ids": ["f0676a6fd578633b244e3954ef8f397e"], "statement_hash": "147d56f6b961c6a8edec12ec9b0202a87651e641b126376307f1ceff34e989e0"}}, {"rule": 2, "type": "equivalent", "target": "f6660ce4942f7be69fae916d43edbb2c", "evidence": {"same_day": true, "patch_ids": ["f0676a6fd578633b244e3954ef8f397e"], "statement_hash": "147d56f6b961c6a8edec12ec9b0202a87651e641b126376307f1ceff34e989e0"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "4913189de70c687d45c2182a4f59108c", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "On Windows, make psql read the output of a backtick command in text mode, not binary mode", "evidence": {"same_day": true, "patch_ids": ["f0676a6fd578633b244e3954ef8f397e"], "statement_hash": "147d56f6b961c6a8edec12ec9b0202a87651e641b126376307f1ceff34e989e0"}, "url": "/docs/compare/?release=13.1#13.1-56791cce9174d808", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}, {"db_id": "53bb8143f97e643054b70a519a5cd076", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "On Windows, make psql read the output of a backtick command in text mode, not binary mode", "evidence": {"same_day": true, "patch_ids": ["f0676a6fd578633b244e3954ef8f397e"], "statement_hash": "147d56f6b961c6a8edec12ec9b0202a87651e641b126376307f1ceff34e989e0"}, "url": "/docs/compare/?release=11.10#11.10-ef2569d92ee33183", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "f6660ce4942f7be69fae916d43edbb2c", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "On Windows, make psql read the output of a backtick command in text mode, not binary mode", "evidence": {"same_day": true, "patch_ids": ["f0676a6fd578633b244e3954ef8f397e"], "statement_hash": "147d56f6b961c6a8edec12ec9b0202a87651e641b126376307f1ceff34e989e0"}, "url": "/docs/compare/?release=10.15#10.15-ef2569d92ee33183", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "9b1ff42f9ce9a78c5329d18bf7b57a2c", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "On Windows, make psql read the output of a backtick command in text mode, not binary mode", "evidence": {"same_day": true, "patch_ids": ["f0676a6fd578633b244e3954ef8f397e"], "statement_hash": "147d56f6b961c6a8edec12ec9b0202a87651e641b126376307f1ceff34e989e0"}, "url": "/docs/compare/?release=9.6.20#9.6.20-ef2569d92ee33183", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "12b9e9de7e0b7392bbc1d550c6cd6df6", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "On Windows, make psql read the output of a backtick command in text mode, not binary mode", "evidence": {"same_day": true, "patch_ids": ["f0676a6fd578633b244e3954ef8f397e"], "statement_hash": "147d56f6b961c6a8edec12ec9b0202a87651e641b126376307f1ceff34e989e0"}, "url": "/docs/compare/?release=9.5.24#9.5.24-ef2569d92ee33183", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-dfe9b23fbfb99337", "cves": [], "html": "Ensure that pg_dump collects per-column information about extension configuration tables (Fabrízio de Royes Mello, Tom Lane) § §
\nFailure to do this led to crashes when specifying --inserts, or underspecified (though usually correct) COPY commands when using COPY to reload the tables' data.
Ensure that parallel pg_restore processes foreign keys referencing partitioned tables in the correct order (Álvaro Herrera) §
\nPreviously, it might try to restore a foreign key constraint before the required indexes were all in place, leading to an error.
", "text": "Ensure that parallel pg_restore processes foreign keys referencing partitioned tables in the correct order (Álvaro Herrera) § Previously, it might try to restore a foreign key constraint before the required indexes were all in place, leading to an error.", "title": "Ensure that parallel pg_restore processes foreign keys referencing partitioned tables in the correct order", "commits": ["3dadcb2b3"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "521c386b57971d76d881ff0bf31eb07d694ddf2cd992fa67f480bb5c752bb26a", "section_path": ["Changes"], "commit_groups": [["2ba5b2db7", "3dadcb2b3", "b7cc21c57"]], "identity_text": "Ensure that parallel pg_restore processes foreign keys referencing partitioned tables in the correct order (Álvaro Herrera) Previously, it might try to restore a foreign key constraint before the required indexes were all in place, leading to an error.", "commit_aliases": ["2ba5b2db7", "3dadcb2b3", "b7cc21c57"], "source_commits": ["3dadcb2b3"], "source_entry_id": "12.5/changes/052", "db_id": "d980b9a4ef30e87698a836ec3eac7630", "patch_ids": ["414f39b5253bbf918c8c5ecb36af0372"], "statement_hash": "63ef5d9b26432a77e204de8dccf3e48492fd95b4afc1936fa43e0be34b578198", "relations": [], "version": "12.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "12.5-4b61295613a298fd", "cves": [], "html": "Make pg_upgrade check for pre-existence of tablespace directories in the target cluster (Bruce Momjian) § §
", "text": "Make pg_upgrade check for pre-existence of tablespace directories in the target cluster (Bruce Momjian) § §", "title": "Make pg_upgrade check for pre-existence of tablespace directories in the target cluster", "commits": ["0ab7ca98a", "a106236d8"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "c41f0d97d3caaf9418bf312ec214dacbbb71bf9da3af0fd719f56825d6462de0", "section_path": ["Changes"], "commit_groups": [["0ab7ca98a", "16be4e435", "536de14e2", "6e34cc8ab", "79fe23465", "9dcffe69a", "b05672c72"], ["39c23c199", "3c0471b5f", "59cfff65b", "85fedf39f", "a106236d8", "d9ae2297b", "eb421c83b"]], "identity_text": "Make pg_upgrade check for pre-existence of tablespace directories in the target cluster (Bruce Momjian)", "commit_aliases": ["0ab7ca98a", "16be4e435", "39c23c199", "3c0471b5f", "536de14e2", "59cfff65b", "6e34cc8ab", "79fe23465", "85fedf39f", "9dcffe69a", "a106236d8", "b05672c72", "d9ae2297b", "eb421c83b"], "source_commits": ["0ab7ca98a", "a106236d8"], "source_entry_id": "12.5/changes/053", "db_id": "487015ba212a94883add480a0161d282", "patch_ids": ["385da7b634c4d18cad66323aed6e5396", "3d023e2eb93a8c3bf9b9c1a6fcef7726"], "statement_hash": "5753b5a81159391dd0515c2940fa9293fcd8bb43236bb449f206e9af55aed740", "relations": [{"rule": 2, "type": "equivalent", "target": "6359b4855420c50bac500e091bcf21ac", "evidence": {"same_day": true, "patch_ids": ["385da7b634c4d18cad66323aed6e5396", "3d023e2eb93a8c3bf9b9c1a6fcef7726"], "statement_hash": "5753b5a81159391dd0515c2940fa9293fcd8bb43236bb449f206e9af55aed740"}}, {"rule": 2, "type": "equivalent", "target": "97763d342fba71c440133e01ec21602b", "evidence": {"same_day": true, "patch_ids": ["385da7b634c4d18cad66323aed6e5396", "3d023e2eb93a8c3bf9b9c1a6fcef7726"], "statement_hash": "5753b5a81159391dd0515c2940fa9293fcd8bb43236bb449f206e9af55aed740"}}, {"rule": 2, "type": "equivalent", "target": "98c82203e1de7fa217bd04b22e341a62", "evidence": {"same_day": true, "patch_ids": ["385da7b634c4d18cad66323aed6e5396", "3d023e2eb93a8c3bf9b9c1a6fcef7726"], "statement_hash": "5753b5a81159391dd0515c2940fa9293fcd8bb43236bb449f206e9af55aed740"}}, {"rule": 2, "type": "equivalent", "target": "9cabfbf717fd03e9b875f151dac12f27", "evidence": {"same_day": true, "patch_ids": ["385da7b634c4d18cad66323aed6e5396", "3d023e2eb93a8c3bf9b9c1a6fcef7726"], "statement_hash": "5753b5a81159391dd0515c2940fa9293fcd8bb43236bb449f206e9af55aed740"}}, {"rule": 2, "type": "equivalent", "target": "d0d308a14a919dcdd011ad9f5ffbb853", "evidence": {"same_day": true, "patch_ids": ["385da7b634c4d18cad66323aed6e5396", "3d023e2eb93a8c3bf9b9c1a6fcef7726"], "statement_hash": "5753b5a81159391dd0515c2940fa9293fcd8bb43236bb449f206e9af55aed740"}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "98c82203e1de7fa217bd04b22e341a62", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Make pg_upgrade check for pre-existence of tablespace directories in the target cluster", "evidence": {"same_day": true, "patch_ids": ["385da7b634c4d18cad66323aed6e5396", "3d023e2eb93a8c3bf9b9c1a6fcef7726"], "statement_hash": "5753b5a81159391dd0515c2940fa9293fcd8bb43236bb449f206e9af55aed740"}, "url": "/docs/compare/?release=13.1#13.1-75fe4af2348b834a", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}, {"db_id": "97763d342fba71c440133e01ec21602b", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Make pg_upgrade check for pre-existence of tablespace directories in the target cluster", "evidence": {"same_day": true, "patch_ids": ["385da7b634c4d18cad66323aed6e5396", "3d023e2eb93a8c3bf9b9c1a6fcef7726"], "statement_hash": "5753b5a81159391dd0515c2940fa9293fcd8bb43236bb449f206e9af55aed740"}, "url": "/docs/compare/?release=11.10#11.10-c50014afb3902573", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "6359b4855420c50bac500e091bcf21ac", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Make pg_upgrade check for pre-existence of tablespace directories in the target cluster", "evidence": {"same_day": true, "patch_ids": ["385da7b634c4d18cad66323aed6e5396", "3d023e2eb93a8c3bf9b9c1a6fcef7726"], "statement_hash": "5753b5a81159391dd0515c2940fa9293fcd8bb43236bb449f206e9af55aed740"}, "url": "/docs/compare/?release=10.15#10.15-c50014afb3902573", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "d0d308a14a919dcdd011ad9f5ffbb853", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Make pg_upgrade check for pre-existence of tablespace directories in the target cluster", "evidence": {"same_day": true, "patch_ids": ["385da7b634c4d18cad66323aed6e5396", "3d023e2eb93a8c3bf9b9c1a6fcef7726"], "statement_hash": "5753b5a81159391dd0515c2940fa9293fcd8bb43236bb449f206e9af55aed740"}, "url": "/docs/compare/?release=9.6.20#9.6.20-c50014afb3902573", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "9cabfbf717fd03e9b875f151dac12f27", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Make pg_upgrade check for pre-existence of tablespace directories in the target cluster", "evidence": {"same_day": true, "patch_ids": ["385da7b634c4d18cad66323aed6e5396", "3d023e2eb93a8c3bf9b9c1a6fcef7726"], "statement_hash": "5753b5a81159391dd0515c2940fa9293fcd8bb43236bb449f206e9af55aed740"}, "url": "/docs/compare/?release=9.5.24#9.5.24-c50014afb3902573", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-d5c4b8e65d7a01af", "cves": [], "html": "Fix potential memory leak in contrib/pgcrypto (Michael Paquier) §
Add check for an unlikely failure case in contrib/pgcrypto (Daniel Gustafsson) §
Fix recently-added timetz test case so it works when the USA is not observing daylight savings time (Tom Lane) §
Update time zone data files to tzdata release 2020d for DST law changes in Fiji, Morocco, Palestine, the Canadian Yukon, Macquarie Island, and Casey Station (Antarctica); plus historical corrections for France, Hungary, Monaco, and Palestine. (Tom Lane) § §
", "text": "Update time zone data files to tzdata release 2020d for DST law changes in Fiji, Morocco, Palestine, the Canadian Yukon, Macquarie Island, and Casey Station (Antarctica); plus historical corrections for France, Hungary, Monaco, and Palestine. (Tom Lane) § §", "title": "Update time zone data files to tzdata release 2020d for DST law changes in Fiji, Morocco, Palestine, the Canadian Yukon, Macquarie Island, and Casey Station (Antarctica); plus historical corrections for France, Hungary, Monaco, and Palestine.", "commits": ["78ccf7f42", "b39c94097"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.5/#id-1.11.6.23.5", "source_hash": "8da8e6ec6354e05ab441cca3876295b469fbecd4e32564c313e816a90a93bba2", "section_path": ["Changes"], "commit_groups": [["02f86d523", "05a36321a", "0abebb58f", "78ccf7f42", "7d6d6bce4", "96ed2ae93", "a357cc05d"], ["13dbf4ab8", "2b9166dbc", "3f26dca76", "aae4097b0", "b39c94097", "c4a803ac7", "c8cb243cb"]], "identity_text": "Update time zone data files to tzdata release 2020d for DST law changes in Fiji, Morocco, Palestine, the Canadian Yukon, Macquarie Island, and Casey Station (Antarctica); plus historical corrections for France, Hungary, Monaco, and Palestine. (Tom Lane)", "commit_aliases": ["02f86d523", "05a36321a", "0abebb58f", "13dbf4ab8", "2b9166dbc", "3f26dca76", "78ccf7f42", "7d6d6bce4", "96ed2ae93", "a357cc05d", "aae4097b0", "b39c94097", "c4a803ac7", "c8cb243cb"], "source_commits": ["78ccf7f42", "b39c94097"], "source_entry_id": "12.5/changes/057", "db_id": "c58c928aec65249ba5f1bb5034af5752", "patch_ids": ["6b7844d473905050493fea203fa69475", "fe3bd98ff6db91aad632edf88c490930"], "statement_hash": "c77e3801ff3941d2d01739806c015eda2ca4a03ab1bb652efed7a98081d3486e", "relations": [{"rule": 2, "type": "equivalent", "target": "0c059116f712fa34ddefc1f3c11c86f8", "evidence": {"same_day": true, "patch_ids": ["6b7844d473905050493fea203fa69475", "fe3bd98ff6db91aad632edf88c490930"]}}, {"rule": 2, "type": "equivalent", "target": "17ad90072e2a8914a07d4372466d24e4", "evidence": {"same_day": true, "patch_ids": ["6b7844d473905050493fea203fa69475", "fe3bd98ff6db91aad632edf88c490930"], "statement_hash": "c77e3801ff3941d2d01739806c015eda2ca4a03ab1bb652efed7a98081d3486e"}}, {"rule": 2, "type": "equivalent", "target": "24974773d2daa01debb16ce936e6bdc1", "evidence": {"same_day": true, "patch_ids": ["6b7844d473905050493fea203fa69475", "fe3bd98ff6db91aad632edf88c490930"]}}, {"rule": 2, "type": "equivalent", "target": "5971ee3b479e16b4b8d6835dad1bb9e3", "evidence": {"same_day": true, "patch_ids": ["6b7844d473905050493fea203fa69475", "fe3bd98ff6db91aad632edf88c490930"]}}, {"rule": 2, "type": "equivalent", "target": "5feb640716a0600d1dca369557b946b5", "evidence": {"same_day": true, "patch_ids": ["6b7844d473905050493fea203fa69475", "fe3bd98ff6db91aad632edf88c490930"]}}], "version": "12.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "17ad90072e2a8914a07d4372466d24e4", "kind": "equivalent", "version": "13.1", "label": "13.1", "title": "Update time zone data files to tzdata release 2020d for DST law changes in Fiji, Morocco, Palestine, the Canadian Yukon, Macquarie Island, and Casey Station (Antarctica); plus historical corrections for France, Hungary, Monaco, and Palestine.", "evidence": {"same_day": true, "patch_ids": ["6b7844d473905050493fea203fa69475", "fe3bd98ff6db91aad632edf88c490930"], "statement_hash": "c77e3801ff3941d2d01739806c015eda2ca4a03ab1bb652efed7a98081d3486e"}, "url": "/docs/compare/?release=13.1#13.1-69c39fa41c88aa05", "source_url": "/docs/release/13.1/#id-1.11.6.28.5"}, {"db_id": "5feb640716a0600d1dca369557b946b5", "kind": "equivalent", "version": "11.10", "label": "11.10", "title": "Update time zone data files to tzdata release 2020d for DST law changes in Fiji, Morocco, Palestine, the Canadian Yukon, Macquarie Island, and Casey Station (Antarctica); plus historical corrections for France, Hungary, Monaco, and Palestine.", "evidence": {"same_day": true, "patch_ids": ["6b7844d473905050493fea203fa69475", "fe3bd98ff6db91aad632edf88c490930"]}, "url": "/docs/compare/?release=11.10#11.10-1792872fe017c648", "source_url": "/docs/release/11.10/#id-1.11.6.17.5"}, {"db_id": "0c059116f712fa34ddefc1f3c11c86f8", "kind": "equivalent", "version": "10.15", "label": "10.15", "title": "Update time zone data files to tzdata release 2020d for DST law changes in Fiji, Morocco, Palestine, the Canadian Yukon, Macquarie Island, and Casey Station (Antarctica); plus historical corrections for France, Hungary, Monaco, and Palestine.", "evidence": {"same_day": true, "patch_ids": ["6b7844d473905050493fea203fa69475", "fe3bd98ff6db91aad632edf88c490930"]}, "url": "/docs/compare/?release=10.15#10.15-1792872fe017c648", "source_url": "/docs/release/10.15/#id-1.11.6.13.5"}, {"db_id": "24974773d2daa01debb16ce936e6bdc1", "kind": "equivalent", "version": "9.6.20", "label": "9.6.20", "title": "Update time zone data files to tzdata release 2020d for DST law changes in Fiji, Morocco, Palestine, the Canadian Yukon, Macquarie Island, and Casey Station (Antarctica); plus historical corrections for France, Hungary, Monaco, and Palestine.", "evidence": {"same_day": true, "patch_ids": ["6b7844d473905050493fea203fa69475", "fe3bd98ff6db91aad632edf88c490930"]}, "url": "/docs/compare/?release=9.6.20#9.6.20-1792872fe017c648", "source_url": "/docs/release/9.6.20/#AEN132588"}, {"db_id": "5971ee3b479e16b4b8d6835dad1bb9e3", "kind": "equivalent", "version": "9.5.24", "label": "9.5.24", "title": "Update time zone data files to tzdata release 2020d for DST law changes in Fiji, Morocco, Palestine, the Canadian Yukon, Macquarie Island, and Casey Station (Antarctica); plus historical corrections for France, Hungary, Monaco, and Palestine.", "evidence": {"same_day": true, "patch_ids": ["6b7844d473905050493fea203fa69475", "fe3bd98ff6db91aad632edf88c490930"]}, "url": "/docs/compare/?release=9.5.24#9.5.24-1792872fe017c648", "source_url": "/docs/release/9.5.24/#AEN127471"}]}, {"id": "12.5-e5bcd809852f6361", "cves": [], "html": "Sync our copy of the timezone library with IANA tzcode release 2020d (Tom Lane) § §
\nThis absorbs upstream's change of zic's default output option from “fat” to “slim”. That's just cosmetic for our purposes, as we continue to select the “fat” mode in pre-v13 branches. This change also ensures that strftime() does not change errno unless it fails.