A dump/restore is not required for those running 12.X.
", "compatibility_count": 0, "label": "12.1", "status_label": "Historical", "eol": "2024-11-21", "age_days": 2511, "support_days": -677}, "groups": [{"date": "2019-11-14", "build": "12.1", "major": "12", "minor": 1, "manual": "12", "status": "stable", "doc_git": "", "version": "12.1", "eol_date": "2024-11-21", "date_text": "2019-11-14", "supported": false, "manual_url": "/docs/12/release-12-1.html", "source_url": "/docs/release/12.1/", "entry_count": 51, "placeholder": false, "content_hash": "0d1981e5896e23ab96394ae8053de372eb2236e0351bd1e25ba6c62f92b70ba4", "manual_build": "12.22", "source_as_of": "", "changes_count": 51, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 12.X.
", "compatibility_count": 0, "label": "12.1", "status_label": "Historical", "eol": "2024-11-21", "age_days": 2511, "support_days": -677, "entries": [{"id": "12.1-1a60920d2a5aae19", "cves": [], "html": "Fix crash when ALTER TABLE adds a column without a default value along with making other changes that require a table rewrite (Andres Freund) § §
Fix lock handling in REINDEX CONCURRENTLY (Michael Paquier) § §
REINDEX CONCURRENTLY neglected to take a session-level lock on the new index version, potentially allowing other sessions to manipulate it too soon. Also, a query-cancel or session-termination interrupt arriving at the wrong time could result in failure to release the session-level locks that REINDEX CONCURRENTLY does hold.
Avoid crash due to race condition when reporting the progress of a CREATE INDEX CONCURRENTLY or REINDEX CONCURRENTLY command (Álvaro Herrera) §
Avoid creating duplicate dependency entries during REINDEX CONCURRENTLY (Michael Paquier) §
This bug resulted in bloat in pg_depend, but no worse consequences than that.
Prevent VACUUM from trying to freeze an old multixact ID involving a still-running transaction (Nathan Bossart, Jeremy Schneider) §
This case would lead to VACUUM failing until the old transaction terminates.
Fix “wrong type of slot” error when trying to CLUSTER on an expression index (Andres Freund) §
SET CONSTRAINTS ... DEFERRED failed on partitioned tables, incorrectly complaining about lack of triggers (Álvaro Herrera) §
Fix failure when creating indexes for a partition, if the parent partitioned table contains any dropped columns (Michael Paquier) §
", "text": "Fix failure when creating indexes for a partition, if the parent partitioned table contains any dropped columns (Michael Paquier) §", "title": "Fix failure when creating indexes for a partition, if the parent partitioned table contains any dropped columns", "commits": ["7963c4c4b"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "b8139be1b0b8acd6f28b7c04dc510614a9c5073b34bf1d7e488abbfec2a9e8a4", "section_path": ["Changes"], "commit_groups": [["7963c4c4b", "dc816e581", "f10815c5b"]], "identity_text": "Fix failure when creating indexes for a partition, if the parent partitioned table contains any dropped columns (Michael Paquier)", "commit_aliases": ["7963c4c4b", "dc816e581", "f10815c5b"], "source_commits": ["7963c4c4b"], "source_entry_id": "12.1/changes/008", "db_id": "2ed536683fefc30c6111710d7c42fa25", "patch_ids": ["af7ab2ddb0f267b1950b0d2d4d36de68"], "statement_hash": "9d77ccbfeb1d4e7bf04c0e00a05eac901a7a3a251818ac67fe0d1734567bd7ff", "relations": [{"rule": 2, "type": "equivalent", "target": "ab1ceaca016cc84dee00c4ad5f08cc82", "evidence": {"same_day": true, "patch_ids": ["af7ab2ddb0f267b1950b0d2d4d36de68"], "statement_hash": "9d77ccbfeb1d4e7bf04c0e00a05eac901a7a3a251818ac67fe0d1734567bd7ff"}}], "version": "12.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "ab1ceaca016cc84dee00c4ad5f08cc82", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix failure when creating indexes for a partition, if the parent partitioned table contains any dropped columns", "evidence": {"same_day": true, "patch_ids": ["af7ab2ddb0f267b1950b0d2d4d36de68"], "statement_hash": "9d77ccbfeb1d4e7bf04c0e00a05eac901a7a3a251818ac67fe0d1734567bd7ff"}, "url": "/docs/compare/?release=11.6#11.6-6132fb5e2792c4b8", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}]}, {"id": "12.1-d196a7b3422ee01c", "cves": [], "html": "Fix dropping of indexed columns in partitioned tables (Amit Langote, Michael Paquier) § §
\nPreviously this might fail with an error message complaining about the dependencies of the indexes. It should automatically drop the indexes, instead.
", "text": "Fix dropping of indexed columns in partitioned tables (Amit Langote, Michael Paquier) § § Previously this might fail with an error message complaining about the dependencies of the indexes. It should automatically drop the indexes, instead.", "title": "Fix dropping of indexed columns in partitioned tables", "commits": ["3a58c5f14", "9fd9af97f"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "539cf17308fafb27798378e7ae263079366847ab60fc9f7332df6dca8e2d35e2", "section_path": ["Changes"], "commit_groups": [["14ac4237c", "9fd9af97f"], ["1df5875d3", "3a58c5f14"]], "identity_text": "Fix dropping of indexed columns in partitioned tables (Amit Langote, Michael Paquier) Previously this might fail with an error message complaining about the dependencies of the indexes. It should automatically drop the indexes, instead.", "commit_aliases": ["14ac4237c", "1df5875d3", "3a58c5f14", "9fd9af97f"], "source_commits": ["3a58c5f14", "9fd9af97f"], "source_entry_id": "12.1/changes/009", "db_id": "cc17f8133f62291da23279a1dc405aa6", "patch_ids": ["d043a201d56b3a28a2a4dac285c154da", "ff6b5ebbd460c918c0896819b1f21291"], "statement_hash": "afcf3581f7b7e676712387c418fc287e5f65aeb80e49b3374fcabcb0aecea944", "relations": [], "version": "12.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "12.1-a6682d4feb3ffcad", "cves": [], "html": "Ensure that a partition index can be dropped after a failure to reindex it concurrently (Michael Paquier) §
\nThe index's pg_class.relispartition flag was left in the wrong state in such a case, causing DROP INDEX to fail.
Fix handling of equivalence class members for partition-wise joins (Amit Langote) §
\nThis oversight could lead either to failure to use a feasible partition-wise join plan, or to a “could not find pathkey item to sort” planner failure.
", "text": "Fix handling of equivalence class members for partition-wise joins (Amit Langote) § This oversight could lead either to failure to use a feasible partition-wise join plan, or to a “could not find pathkey item to sort” planner failure.", "title": "Fix handling of equivalence class members for partition-wise joins", "commits": ["a9db37a18"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "aa9ba613f9300cb1b108112e610fee1845db7a5b6e7fefc590d562b2beaa5880", "section_path": ["Changes"], "commit_groups": [["529ebb20a", "a9db37a18"]], "identity_text": "Fix handling of equivalence class members for partition-wise joins (Amit Langote) This oversight could lead either to failure to use a feasible partition-wise join plan, or to a could not find pathkey item to sort planner failure.", "commit_aliases": ["529ebb20a", "a9db37a18"], "source_commits": ["a9db37a18"], "source_entry_id": "12.1/changes/011", "db_id": "7f02e360a4f51896c422a97795c7a65f", "patch_ids": ["cbaaa6d2bd82ff913e0cbde3344c14f5"], "statement_hash": "ce7cc07655667abbf5e224a77829ac4ce54c8f4cd7b892c1fa75970a8d8aec5b", "relations": [], "version": "12.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "12.1-119d50d0f6cf35b0", "cves": [], "html": "Ensure that offset expressions in WINDOW clauses are processed when a query's expressions are manipulated (Andrew Gierth) §
This oversight could result in assorted failures when the offsets are nontrivial expressions. One example is that a function parameter reference in such an expression would fail if the function was inlined.
", "text": "Ensure that offset expressions in WINDOW clauses are processed when a query's expressions are manipulated (Andrew Gierth) § This oversight could result in assorted failures when the offsets are nontrivial expressions. One example is that a function parameter reference in such an expression would fail if the function was inlined.", "title": "Ensure that offset expressions in WINDOW clauses are processed when a query's expressions are manipulated", "commits": ["0b11dc019"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "818794a03777f8ce3ec93c41cbe3cb2724e110c17f8b1e69d21ca3b02f9c9182", "section_path": ["Changes"], "commit_groups": [["0a445f279", "0b11dc019", "3473f81dd", "6db0d7f35", "b7a1c5539", "d2427f11b", "ede0ab6cc"]], "identity_text": "Ensure that offset expressions in WINDOW clauses are processed when a query's expressions are manipulated (Andrew Gierth) This oversight could result in assorted failures when the offsets are nontrivial expressions. One example is that a function parameter reference in such an expression would fail if the function was inlined.", "commit_aliases": ["0a445f279", "0b11dc019", "3473f81dd", "6db0d7f35", "b7a1c5539", "d2427f11b", "ede0ab6cc"], "source_commits": ["0b11dc019"], "source_entry_id": "12.1/changes/012", "db_id": "87328496fe1ff4fe1e4cba6a35b8ff0e", "patch_ids": ["8235cc73f9a36fb23483c21b4d478ab6"], "statement_hash": "9367d99ad3c83d87b1b66563cc87db04a17a16aad9c314c1aa66646533c1d89e", "relations": [{"rule": 2, "type": "equivalent", "target": "051cfcbf21f9ff3ad7f3b7145cfb8239", "evidence": {"same_day": true, "patch_ids": ["8235cc73f9a36fb23483c21b4d478ab6"], "statement_hash": "9367d99ad3c83d87b1b66563cc87db04a17a16aad9c314c1aa66646533c1d89e"}}, {"rule": 2, "type": "equivalent", "target": "253f8c0da0e1b976098cbde686e376f0", "evidence": {"same_day": true, "patch_ids": ["8235cc73f9a36fb23483c21b4d478ab6"], "statement_hash": "9367d99ad3c83d87b1b66563cc87db04a17a16aad9c314c1aa66646533c1d89e"}}, {"rule": 2, "type": "equivalent", "target": "514ca97d8fc5e1b9913fa206c2ab3b7c", "evidence": {"same_day": true, "patch_ids": ["8235cc73f9a36fb23483c21b4d478ab6"], "statement_hash": "9367d99ad3c83d87b1b66563cc87db04a17a16aad9c314c1aa66646533c1d89e"}}, {"rule": 2, "type": "equivalent", "target": "786a8eb68b27a6e848bfa72505a70b7b", "evidence": {"same_day": true, "patch_ids": ["8235cc73f9a36fb23483c21b4d478ab6"], "statement_hash": "9367d99ad3c83d87b1b66563cc87db04a17a16aad9c314c1aa66646533c1d89e"}}, {"rule": 2, "type": "equivalent", "target": "b353f1899827134e9fe629738825aa8a", "evidence": {"same_day": true, "patch_ids": ["8235cc73f9a36fb23483c21b4d478ab6"], "statement_hash": "9367d99ad3c83d87b1b66563cc87db04a17a16aad9c314c1aa66646533c1d89e"}}], "version": "12.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "514ca97d8fc5e1b9913fa206c2ab3b7c", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Ensure that offset expressions in WINDOW clauses are processed when a query's expressions are manipulated", "evidence": {"same_day": true, "patch_ids": ["8235cc73f9a36fb23483c21b4d478ab6"], "statement_hash": "9367d99ad3c83d87b1b66563cc87db04a17a16aad9c314c1aa66646533c1d89e"}, "url": "/docs/compare/?release=11.6#11.6-13a4ad410ef361d3", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "051cfcbf21f9ff3ad7f3b7145cfb8239", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Ensure that offset expressions in WINDOW clauses are processed when a query's expressions are manipulated", "evidence": {"same_day": true, "patch_ids": ["8235cc73f9a36fb23483c21b4d478ab6"], "statement_hash": "9367d99ad3c83d87b1b66563cc87db04a17a16aad9c314c1aa66646533c1d89e"}, "url": "/docs/compare/?release=10.11#10.11-13a4ad410ef361d3", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "b353f1899827134e9fe629738825aa8a", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Ensure that offset expressions in WINDOW clauses are processed when a query's expressions are manipulated", "evidence": {"same_day": true, "patch_ids": ["8235cc73f9a36fb23483c21b4d478ab6"], "statement_hash": "9367d99ad3c83d87b1b66563cc87db04a17a16aad9c314c1aa66646533c1d89e"}, "url": "/docs/compare/?release=9.6.16#9.6.16-13a4ad410ef361d3", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "253f8c0da0e1b976098cbde686e376f0", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Ensure that offset expressions in WINDOW clauses are processed when a query's expressions are manipulated", "evidence": {"same_day": true, "patch_ids": ["8235cc73f9a36fb23483c21b4d478ab6"], "statement_hash": "9367d99ad3c83d87b1b66563cc87db04a17a16aad9c314c1aa66646533c1d89e"}, "url": "/docs/compare/?release=9.5.20#9.5.20-13a4ad410ef361d3", "source_url": "/docs/release/9.5.20/#AEN128082"}, {"db_id": "786a8eb68b27a6e848bfa72505a70b7b", "kind": "equivalent", "version": "9.4.25", "label": "9.4.25", "title": "Ensure that offset expressions in WINDOW clauses are processed when a query's expressions are manipulated", "evidence": {"same_day": true, "patch_ids": ["8235cc73f9a36fb23483c21b4d478ab6"], "statement_hash": "9367d99ad3c83d87b1b66563cc87db04a17a16aad9c314c1aa66646533c1d89e"}, "url": "/docs/compare/?release=9.4.25#9.4.25-13a4ad410ef361d3", "source_url": "/docs/release/9.4.25/#AEN119951"}]}, {"id": "12.1-1ee3e3dab4caeacf", "cves": [], "html": "Avoid postmaster failure if a parallel query requests a background worker when no postmaster child process array slots remain free (Tom Lane) §
", "text": "Avoid postmaster failure if a parallel query requests a background worker when no postmaster child process array slots remain free (Tom Lane) §", "title": "Avoid postmaster failure if a parallel query requests a background worker when no postmaster child process array slots remain free", "commits": ["7e8d0eb63"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "3a05162fae59c17ff90eaf6891c10e8ade71eab931f24b3f85cfb52e56002ca7", "section_path": ["Changes"], "commit_groups": [["021065aac", "1b5c2ddcd", "3887e9455", "7e8d0eb63", "8c2910ce5", "c69e982a6"]], "identity_text": "Avoid postmaster failure if a parallel query requests a background worker when no postmaster child process array slots remain free (Tom Lane)", "commit_aliases": ["021065aac", "1b5c2ddcd", "3887e9455", "7e8d0eb63", "8c2910ce5", "c69e982a6"], "source_commits": ["7e8d0eb63"], "source_entry_id": "12.1/changes/013", "db_id": "6d5136787092da5d45ab2ca5be03299b", "patch_ids": ["96d0aacaad882c2d32ec347beb727443"], "statement_hash": "59eaa010be2a4d75cef37cd13bf56abb667da2b61444f4abcbb1f9498e5c7977", "relations": [{"rule": 2, "type": "equivalent", "target": "2796791ad0615cd972274fc27cfa15c2", "evidence": {"same_day": true, "patch_ids": ["96d0aacaad882c2d32ec347beb727443"], "statement_hash": "59eaa010be2a4d75cef37cd13bf56abb667da2b61444f4abcbb1f9498e5c7977"}}, {"rule": 2, "type": "equivalent", "target": "34b9e07ede55d67ae654c7c040b465b5", "evidence": {"same_day": true, "patch_ids": ["96d0aacaad882c2d32ec347beb727443"], "statement_hash": "59eaa010be2a4d75cef37cd13bf56abb667da2b61444f4abcbb1f9498e5c7977"}}, {"rule": 2, "type": "equivalent", "target": "6cb33d9008a7674a50e355939da5e32a", "evidence": {"same_day": true, "patch_ids": ["96d0aacaad882c2d32ec347beb727443"], "statement_hash": "59eaa010be2a4d75cef37cd13bf56abb667da2b61444f4abcbb1f9498e5c7977"}}, {"rule": 2, "type": "equivalent", "target": "998e1240a8474fc87758996a60323d84", "evidence": {"same_day": true, "patch_ids": ["96d0aacaad882c2d32ec347beb727443"], "statement_hash": "59eaa010be2a4d75cef37cd13bf56abb667da2b61444f4abcbb1f9498e5c7977"}}], "version": "12.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "2796791ad0615cd972274fc27cfa15c2", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Avoid postmaster failure if a parallel query requests a background worker when no postmaster child process array slots remain free", "evidence": {"same_day": true, "patch_ids": ["96d0aacaad882c2d32ec347beb727443"], "statement_hash": "59eaa010be2a4d75cef37cd13bf56abb667da2b61444f4abcbb1f9498e5c7977"}, "url": "/docs/compare/?release=11.6#11.6-0931c6ad49339251", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "34b9e07ede55d67ae654c7c040b465b5", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Avoid postmaster failure if a parallel query requests a background worker when no postmaster child process array slots remain free", "evidence": {"same_day": true, "patch_ids": ["96d0aacaad882c2d32ec347beb727443"], "statement_hash": "59eaa010be2a4d75cef37cd13bf56abb667da2b61444f4abcbb1f9498e5c7977"}, "url": "/docs/compare/?release=10.11#10.11-0931c6ad49339251", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "6cb33d9008a7674a50e355939da5e32a", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Avoid postmaster failure if a parallel query requests a background worker when no postmaster child process array slots remain free", "evidence": {"same_day": true, "patch_ids": ["96d0aacaad882c2d32ec347beb727443"], "statement_hash": "59eaa010be2a4d75cef37cd13bf56abb667da2b61444f4abcbb1f9498e5c7977"}, "url": "/docs/compare/?release=9.6.16#9.6.16-0931c6ad49339251", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "998e1240a8474fc87758996a60323d84", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Avoid postmaster failure if a parallel query requests a background worker when no postmaster child process array slots remain free", "evidence": {"same_day": true, "patch_ids": ["96d0aacaad882c2d32ec347beb727443"], "statement_hash": "59eaa010be2a4d75cef37cd13bf56abb667da2b61444f4abcbb1f9498e5c7977"}, "url": "/docs/compare/?release=9.5.20#9.5.20-0931c6ad49339251", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "12.1-b3af97076f938b28", "cves": [], "html": "Fix crash triggered by an EvalPlanQual recheck on a table with a BEFORE UPDATE trigger (Andres Freund) §
Fix “unexpected relkind” error when a query tries to access a TOAST table (John Hsu, Michael Paquier, Tom Lane) §
\nThe error should say that permission is denied, but this case got broken during code refactoring.
", "text": "Fix “unexpected relkind” error when a query tries to access a TOAST table (John Hsu, Michael Paquier, Tom Lane) § The error should say that permission is denied, but this case got broken during code refactoring.", "title": "Fix “unexpected relkind” error when a query tries to access a TOAST table", "commits": ["791864193"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "13b930900aace1600502c72fd274fbe08b43c47b2501f58af8d9a3be83c293cf", "section_path": ["Changes"], "commit_groups": [["2bfe015b5", "791864193", "a30531c5c"]], "identity_text": "Fix unexpected relkind error when a query tries to access a TOAST table (John Hsu, Michael Paquier, Tom Lane) The error should say that permission is denied, but this case got broken during code refactoring.", "commit_aliases": ["2bfe015b5", "791864193", "a30531c5c"], "source_commits": ["791864193"], "source_entry_id": "12.1/changes/015", "db_id": "b1ac0f531f9ceaf6a8763e41ce5dd827", "patch_ids": ["838081d3b1b6e8a5ea52066d7b96572d"], "statement_hash": "79e26bd775cf765ffb65aeefc9746ff590c003124c7cd091a9b8fa18d15bb253", "relations": [{"rule": 2, "type": "equivalent", "target": "b31d41d1020b770977ec490b4391f980", "evidence": {"same_day": true, "patch_ids": ["838081d3b1b6e8a5ea52066d7b96572d"], "statement_hash": "79e26bd775cf765ffb65aeefc9746ff590c003124c7cd091a9b8fa18d15bb253"}}], "version": "12.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "b31d41d1020b770977ec490b4391f980", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix “unexpected relkind” error when a query tries to access a TOAST table", "evidence": {"same_day": true, "patch_ids": ["838081d3b1b6e8a5ea52066d7b96572d"], "statement_hash": "79e26bd775cf765ffb65aeefc9746ff590c003124c7cd091a9b8fa18d15bb253"}, "url": "/docs/compare/?release=11.6#11.6-5da92a48dc833f76", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}]}, {"id": "12.1-0f140a3388870cc6", "cves": [], "html": "Provide a relevant error context line when an error occurs while setting GUC parameters during parallel worker startup (Thomas Munro) §
", "text": "Provide a relevant error context line when an error occurs while setting GUC parameters during parallel worker startup (Thomas Munro) §", "title": "Provide a relevant error context line when an error occurs while setting GUC parameters during parallel worker startup", "commits": ["3af7c64fe"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "3823613c05feee52dd7be08a06f998a8f8c50fb10a312202f31a39b106ffcde5", "section_path": ["Changes"], "commit_groups": [["3af7c64fe", "3c8c55dd5", "6737111a7", "89a3cdb32", "cdbb39213", "fd5ffa425"]], "identity_text": "Provide a relevant error context line when an error occurs while setting GUC parameters during parallel worker startup (Thomas Munro)", "commit_aliases": ["3af7c64fe", "3c8c55dd5", "6737111a7", "89a3cdb32", "cdbb39213", "fd5ffa425"], "source_commits": ["3af7c64fe"], "source_entry_id": "12.1/changes/016", "db_id": "4ea3d2bdb5ed937268773fde22216293", "patch_ids": ["1243fa5b0921820b1c554a187d60091f"], "statement_hash": "8baec96ef39b036a484908e57df8cc57b9eb9abcb96cc830db572873e8dde69d", "relations": [{"rule": 2, "type": "equivalent", "target": "194858126ea4e7dfa00ddcca88d219a1", "evidence": {"same_day": true, "patch_ids": ["1243fa5b0921820b1c554a187d60091f"], "statement_hash": "8baec96ef39b036a484908e57df8cc57b9eb9abcb96cc830db572873e8dde69d"}}, {"rule": 2, "type": "equivalent", "target": "1cdeecd950f87ad9f78cd449aa611815", "evidence": {"same_day": true, "patch_ids": ["1243fa5b0921820b1c554a187d60091f"], "statement_hash": "8baec96ef39b036a484908e57df8cc57b9eb9abcb96cc830db572873e8dde69d"}}, {"rule": 2, "type": "equivalent", "target": "4c52b47c2e732d9889ddec4ca22e4589", "evidence": {"same_day": true, "patch_ids": ["1243fa5b0921820b1c554a187d60091f"], "statement_hash": "8baec96ef39b036a484908e57df8cc57b9eb9abcb96cc830db572873e8dde69d"}}, {"rule": 2, "type": "equivalent", "target": "ffba4d83f366131db32533d2cf3a8fc8", "evidence": {"same_day": true, "patch_ids": ["1243fa5b0921820b1c554a187d60091f"], "statement_hash": "8baec96ef39b036a484908e57df8cc57b9eb9abcb96cc830db572873e8dde69d"}}], "version": "12.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "1cdeecd950f87ad9f78cd449aa611815", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Provide a relevant error context line when an error occurs while setting GUC parameters during parallel worker startup", "evidence": {"same_day": true, "patch_ids": ["1243fa5b0921820b1c554a187d60091f"], "statement_hash": "8baec96ef39b036a484908e57df8cc57b9eb9abcb96cc830db572873e8dde69d"}, "url": "/docs/compare/?release=11.6#11.6-b45b89e51c27805a", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "ffba4d83f366131db32533d2cf3a8fc8", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Provide a relevant error context line when an error occurs while setting GUC parameters during parallel worker startup", "evidence": {"same_day": true, "patch_ids": ["1243fa5b0921820b1c554a187d60091f"], "statement_hash": "8baec96ef39b036a484908e57df8cc57b9eb9abcb96cc830db572873e8dde69d"}, "url": "/docs/compare/?release=10.11#10.11-b45b89e51c27805a", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "194858126ea4e7dfa00ddcca88d219a1", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Provide a relevant error context line when an error occurs while setting GUC parameters during parallel worker startup", "evidence": {"same_day": true, "patch_ids": ["1243fa5b0921820b1c554a187d60091f"], "statement_hash": "8baec96ef39b036a484908e57df8cc57b9eb9abcb96cc830db572873e8dde69d"}, "url": "/docs/compare/?release=9.6.16#9.6.16-b45b89e51c27805a", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "4c52b47c2e732d9889ddec4ca22e4589", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Provide a relevant error context line when an error occurs while setting GUC parameters during parallel worker startup", "evidence": {"same_day": true, "patch_ids": ["1243fa5b0921820b1c554a187d60091f"], "statement_hash": "8baec96ef39b036a484908e57df8cc57b9eb9abcb96cc830db572873e8dde69d"}, "url": "/docs/compare/?release=9.5.20#9.5.20-b45b89e51c27805a", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "12.1-379b4a761effb552", "cves": [], "html": "Ensure that fsync() is applied only to files that are opened read/write (Andres Freund, Michael Paquier) § §
Some code paths tried to do this after opening a file read-only, but on some platforms that causes “bad file descriptor” or similar errors.
", "text": "Ensure that fsync() is applied only to files that are opened read/write (Andres Freund, Michael Paquier) § § Some code paths tried to do this after opening a file read-only, but on some platforms that causes “bad file descriptor” or similar errors.", "title": "Ensure that fsync() is applied only to files that are opened read/write", "commits": ["07c314968", "c025165da"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "43967b465dcbf86b172f73f3f3fe9db09506ce7eb52d392fcd449a442dd6feb2", "section_path": ["Changes"], "commit_groups": [["07c314968", "4e7a8874a", "59800f7ce", "b8e19b932", "c50f95272", "e34358c43", "fbfc835b4"], ["a586cc4b6", "c025165da"]], "identity_text": "Ensure that fsync() is applied only to files that are opened read/write (Andres Freund, Michael Paquier) Some code paths tried to do this after opening a file read-only, but on some platforms that causes bad file descriptor or similar errors.", "commit_aliases": ["07c314968", "4e7a8874a", "59800f7ce", "a586cc4b6", "b8e19b932", "c025165da", "c50f95272", "e34358c43", "fbfc835b4"], "source_commits": ["07c314968", "c025165da"], "source_entry_id": "12.1/changes/017", "db_id": "73b65c3ca0a98f2f47a92ac14c9892a1", "patch_ids": ["20b648680404cadc5d357f6df2e8fc6a", "c84eb292a1f31e0c5216e30f34748b01"], "statement_hash": "811b1d7801f5dd7f13522b0ebdbbb031a29ab9ae3676e32a9f2c69c46c6510c4", "relations": [{"rule": 2, "type": "equivalent", "target": "1590e5d3da6e6a81c25d73c6d83b4ebb", "evidence": {"same_day": true, "patch_ids": ["20b648680404cadc5d357f6df2e8fc6a", "c84eb292a1f31e0c5216e30f34748b01"], "statement_hash": "811b1d7801f5dd7f13522b0ebdbbb031a29ab9ae3676e32a9f2c69c46c6510c4"}}, {"rule": 2, "type": "equivalent", "target": "2418c9453b30b777ebc1c9534c0e47b8", "evidence": {"same_day": true, "patch_ids": ["20b648680404cadc5d357f6df2e8fc6a", "c84eb292a1f31e0c5216e30f34748b01"], "statement_hash": "811b1d7801f5dd7f13522b0ebdbbb031a29ab9ae3676e32a9f2c69c46c6510c4"}}, {"rule": 2, "type": "equivalent", "target": "92ea24556125b7bc544c03fdd7e3d122", "evidence": {"same_day": true, "patch_ids": ["20b648680404cadc5d357f6df2e8fc6a", "c84eb292a1f31e0c5216e30f34748b01"], "statement_hash": "811b1d7801f5dd7f13522b0ebdbbb031a29ab9ae3676e32a9f2c69c46c6510c4"}}, {"rule": 2, "type": "equivalent", "target": "9937db66c444f4b87967159a57f1736f", "evidence": {"same_day": true, "patch_ids": ["20b648680404cadc5d357f6df2e8fc6a", "c84eb292a1f31e0c5216e30f34748b01"], "statement_hash": "811b1d7801f5dd7f13522b0ebdbbb031a29ab9ae3676e32a9f2c69c46c6510c4"}}, {"rule": 2, "type": "equivalent", "target": "b8e91545f28e39be358c8cb0aaccd1ce", "evidence": {"same_day": true, "patch_ids": ["20b648680404cadc5d357f6df2e8fc6a", "c84eb292a1f31e0c5216e30f34748b01"], "statement_hash": "811b1d7801f5dd7f13522b0ebdbbb031a29ab9ae3676e32a9f2c69c46c6510c4"}}], "version": "12.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "2418c9453b30b777ebc1c9534c0e47b8", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Ensure that fsync() is applied only to files that are opened read/write", "evidence": {"same_day": true, "patch_ids": ["20b648680404cadc5d357f6df2e8fc6a", "c84eb292a1f31e0c5216e30f34748b01"], "statement_hash": "811b1d7801f5dd7f13522b0ebdbbb031a29ab9ae3676e32a9f2c69c46c6510c4"}, "url": "/docs/compare/?release=11.6#11.6-80b41c21e0d7a114", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "1590e5d3da6e6a81c25d73c6d83b4ebb", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Ensure that fsync() is applied only to files that are opened read/write", "evidence": {"same_day": true, "patch_ids": ["20b648680404cadc5d357f6df2e8fc6a", "c84eb292a1f31e0c5216e30f34748b01"], "statement_hash": "811b1d7801f5dd7f13522b0ebdbbb031a29ab9ae3676e32a9f2c69c46c6510c4"}, "url": "/docs/compare/?release=10.11#10.11-80b41c21e0d7a114", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "92ea24556125b7bc544c03fdd7e3d122", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Ensure that fsync() is applied only to files that are opened read/write", "evidence": {"same_day": true, "patch_ids": ["20b648680404cadc5d357f6df2e8fc6a", "c84eb292a1f31e0c5216e30f34748b01"], "statement_hash": "811b1d7801f5dd7f13522b0ebdbbb031a29ab9ae3676e32a9f2c69c46c6510c4"}, "url": "/docs/compare/?release=9.6.16#9.6.16-80b41c21e0d7a114", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "9937db66c444f4b87967159a57f1736f", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Ensure that fsync() is applied only to files that are opened read/write", "evidence": {"same_day": true, "patch_ids": ["20b648680404cadc5d357f6df2e8fc6a", "c84eb292a1f31e0c5216e30f34748b01"], "statement_hash": "811b1d7801f5dd7f13522b0ebdbbb031a29ab9ae3676e32a9f2c69c46c6510c4"}, "url": "/docs/compare/?release=9.5.20#9.5.20-80b41c21e0d7a114", "source_url": "/docs/release/9.5.20/#AEN128082"}, {"db_id": "b8e91545f28e39be358c8cb0aaccd1ce", "kind": "equivalent", "version": "9.4.25", "label": "9.4.25", "title": "Ensure that fsync() is applied only to files that are opened read/write", "evidence": {"same_day": true, "patch_ids": ["20b648680404cadc5d357f6df2e8fc6a", "c84eb292a1f31e0c5216e30f34748b01"], "statement_hash": "811b1d7801f5dd7f13522b0ebdbbb031a29ab9ae3676e32a9f2c69c46c6510c4"}, "url": "/docs/compare/?release=9.4.25#9.4.25-80b41c21e0d7a114", "source_url": "/docs/release/9.4.25/#AEN119951"}]}, {"id": "12.1-4a8deb84dc97eccf", "cves": [], "html": "Allow encoding conversion to succeed on longer strings than before (Álvaro Herrera, Tom Lane) §
\nPreviously, there was a hard limit of 0.25GB on the input string, but now it will work as long as the converted output is not over 1GB.
", "text": "Allow encoding conversion to succeed on longer strings than before (Álvaro Herrera, Tom Lane) § Previously, there was a hard limit of 0.25GB on the input string, but now it will work as long as the converted output is not over 1GB.", "title": "Allow encoding conversion to succeed on longer strings than before", "commits": ["8381242df"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "ff24dcace6c7fa81669d77d6c8704f668c2a423bc35b6165c5798d320012d311", "section_path": ["Changes"], "commit_groups": [["226551e7c", "54d641da0", "677989cc0", "6899be289", "8381242df", "8e10405c7", "e5ff97571"]], "identity_text": "Allow encoding conversion to succeed on longer strings than before (Álvaro Herrera, Tom Lane) Previously, there was a hard limit of 0.25GB on the input string, but now it will work as long as the converted output is not over 1GB.", "commit_aliases": ["226551e7c", "54d641da0", "677989cc0", "6899be289", "8381242df", "8e10405c7", "e5ff97571"], "source_commits": ["8381242df"], "source_entry_id": "12.1/changes/018", "db_id": "e4b440de56d261ffc7855ea4fab821a0", "patch_ids": ["b59620aadb07a202a61119308e8705a3"], "statement_hash": "b00eedd46ac4216a9af5fe4a43bee7c45f6a7ba75da45a47d3da02bd1b18554a", "relations": [{"rule": 2, "type": "equivalent", "target": "875c0e4587609f405ccd5ffcf2b36ab2", "evidence": {"same_day": true, "patch_ids": ["b59620aadb07a202a61119308e8705a3"], "statement_hash": "b00eedd46ac4216a9af5fe4a43bee7c45f6a7ba75da45a47d3da02bd1b18554a"}}, {"rule": 2, "type": "equivalent", "target": "91d77091fad5f269b2db456b44d2a1e5", "evidence": {"same_day": true, "patch_ids": ["b59620aadb07a202a61119308e8705a3"], "statement_hash": "b00eedd46ac4216a9af5fe4a43bee7c45f6a7ba75da45a47d3da02bd1b18554a"}}, {"rule": 2, "type": "equivalent", "target": "cb4474cbfaedad6fefc693785965ee50", "evidence": {"same_day": true, "patch_ids": ["b59620aadb07a202a61119308e8705a3"], "statement_hash": "b00eedd46ac4216a9af5fe4a43bee7c45f6a7ba75da45a47d3da02bd1b18554a"}}, {"rule": 2, "type": "equivalent", "target": "e3986eda3d8a8bbe46aaaf7f25f8bce1", "evidence": {"same_day": true, "patch_ids": ["b59620aadb07a202a61119308e8705a3"], "statement_hash": "b00eedd46ac4216a9af5fe4a43bee7c45f6a7ba75da45a47d3da02bd1b18554a"}}, {"rule": 2, "type": "equivalent", "target": "e879d6402b17f3116c0664f3906d21a2", "evidence": {"same_day": true, "patch_ids": ["b59620aadb07a202a61119308e8705a3"], "statement_hash": "b00eedd46ac4216a9af5fe4a43bee7c45f6a7ba75da45a47d3da02bd1b18554a"}}], "version": "12.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "e3986eda3d8a8bbe46aaaf7f25f8bce1", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Allow encoding conversion to succeed on longer strings than before", "evidence": {"same_day": true, "patch_ids": ["b59620aadb07a202a61119308e8705a3"], "statement_hash": "b00eedd46ac4216a9af5fe4a43bee7c45f6a7ba75da45a47d3da02bd1b18554a"}, "url": "/docs/compare/?release=11.6#11.6-b3487e0244bd1678", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "91d77091fad5f269b2db456b44d2a1e5", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Allow encoding conversion to succeed on longer strings than before", "evidence": {"same_day": true, "patch_ids": ["b59620aadb07a202a61119308e8705a3"], "statement_hash": "b00eedd46ac4216a9af5fe4a43bee7c45f6a7ba75da45a47d3da02bd1b18554a"}, "url": "/docs/compare/?release=10.11#10.11-b3487e0244bd1678", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "cb4474cbfaedad6fefc693785965ee50", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Allow encoding conversion to succeed on longer strings than before", "evidence": {"same_day": true, "patch_ids": ["b59620aadb07a202a61119308e8705a3"], "statement_hash": "b00eedd46ac4216a9af5fe4a43bee7c45f6a7ba75da45a47d3da02bd1b18554a"}, "url": "/docs/compare/?release=9.6.16#9.6.16-b3487e0244bd1678", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "e879d6402b17f3116c0664f3906d21a2", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Allow encoding conversion to succeed on longer strings than before", "evidence": {"same_day": true, "patch_ids": ["b59620aadb07a202a61119308e8705a3"], "statement_hash": "b00eedd46ac4216a9af5fe4a43bee7c45f6a7ba75da45a47d3da02bd1b18554a"}, "url": "/docs/compare/?release=9.5.20#9.5.20-b3487e0244bd1678", "source_url": "/docs/release/9.5.20/#AEN128082"}, {"db_id": "875c0e4587609f405ccd5ffcf2b36ab2", "kind": "equivalent", "version": "9.4.25", "label": "9.4.25", "title": "Allow encoding conversion to succeed on longer strings than before", "evidence": {"same_day": true, "patch_ids": ["b59620aadb07a202a61119308e8705a3"], "statement_hash": "b00eedd46ac4216a9af5fe4a43bee7c45f6a7ba75da45a47d3da02bd1b18554a"}, "url": "/docs/compare/?release=9.4.25#9.4.25-b3487e0244bd1678", "source_url": "/docs/release/9.4.25/#AEN119951"}]}, {"id": "12.1-f5c75d3ed183214d", "cves": [], "html": "Avoid creating unnecessarily-bulky tuple stores for window functions (Andrew Gierth) §
\nIn some cases the tuple storage would include all columns of the source table(s), not just the ones that are needed by the query.
", "text": "Avoid creating unnecessarily-bulky tuple stores for window functions (Andrew Gierth) § In some cases the tuple storage would include all columns of the source table(s), not just the ones that are needed by the query.", "title": "Avoid creating unnecessarily-bulky tuple stores for window functions", "commits": ["f57c63107"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "7b866e9219d93b3a7de1e7860cf3ed3e2218ab3e7e10521789aef0c5c3b8ab26", "section_path": ["Changes"], "commit_groups": [["6da5310e8", "747aac88f", "a9056cc63", "be99485b9", "f57c63107"]], "identity_text": "Avoid creating unnecessarily-bulky tuple stores for window functions (Andrew Gierth) In some cases the tuple storage would include all columns of the source table(s), not just the ones that are needed by the query.", "commit_aliases": ["6da5310e8", "747aac88f", "a9056cc63", "be99485b9", "f57c63107"], "source_commits": ["f57c63107"], "source_entry_id": "12.1/changes/019", "db_id": "c9ecc9c454fc3825dbe98be81173fe68", "patch_ids": ["077ab1f10e9b6607b8d2de77233fc395"], "statement_hash": "dea0ff8dd73fb79808c36402906348dd94bd297fb10d52e4b38e6f3fdee0ca15", "relations": [{"rule": 2, "type": "equivalent", "target": "3d8474a55daa92357bdbbe434b361227", "evidence": {"same_day": true, "patch_ids": ["077ab1f10e9b6607b8d2de77233fc395"], "statement_hash": "dea0ff8dd73fb79808c36402906348dd94bd297fb10d52e4b38e6f3fdee0ca15"}}, {"rule": 2, "type": "equivalent", "target": "b002daf8b62be7cd6900ee4c2bb24abe", "evidence": {"same_day": true, "patch_ids": ["077ab1f10e9b6607b8d2de77233fc395"], "statement_hash": "dea0ff8dd73fb79808c36402906348dd94bd297fb10d52e4b38e6f3fdee0ca15"}}, {"rule": 2, "type": "equivalent", "target": "cefc20e114fe712d603a8c303183312a", "evidence": {"same_day": true, "patch_ids": ["077ab1f10e9b6607b8d2de77233fc395"], "statement_hash": "dea0ff8dd73fb79808c36402906348dd94bd297fb10d52e4b38e6f3fdee0ca15"}}], "version": "12.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b002daf8b62be7cd6900ee4c2bb24abe", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Avoid creating unnecessarily-bulky tuple stores for window functions", "evidence": {"same_day": true, "patch_ids": ["077ab1f10e9b6607b8d2de77233fc395"], "statement_hash": "dea0ff8dd73fb79808c36402906348dd94bd297fb10d52e4b38e6f3fdee0ca15"}, "url": "/docs/compare/?release=11.6#11.6-8ad71f10e58318ab", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "cefc20e114fe712d603a8c303183312a", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Avoid creating unnecessarily-bulky tuple stores for window functions", "evidence": {"same_day": true, "patch_ids": ["077ab1f10e9b6607b8d2de77233fc395"], "statement_hash": "dea0ff8dd73fb79808c36402906348dd94bd297fb10d52e4b38e6f3fdee0ca15"}, "url": "/docs/compare/?release=10.11#10.11-8ad71f10e58318ab", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "3d8474a55daa92357bdbbe434b361227", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Avoid creating unnecessarily-bulky tuple stores for window functions", "evidence": {"same_day": true, "patch_ids": ["077ab1f10e9b6607b8d2de77233fc395"], "statement_hash": "dea0ff8dd73fb79808c36402906348dd94bd297fb10d52e4b38e6f3fdee0ca15"}, "url": "/docs/compare/?release=9.6.16#9.6.16-8ad71f10e58318ab", "source_url": "/docs/release/9.6.16/#AEN133252"}]}, {"id": "12.1-a2ec2f586645e8e1", "cves": [], "html": "Allow repalloc() to give back space when a large chunk is reduced in size (Tom Lane) §
Ensure that temporary WAL and history files are removed at the end of archive recovery (Sawada Masahiko) §
", "text": "Ensure that temporary WAL and history files are removed at the end of archive recovery (Sawada Masahiko) §", "title": "Ensure that temporary WAL and history files are removed at the end of archive recovery", "commits": ["2a724cdbf"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "990a333f7f602ba740e0820fc3ce5749f7fe05806baad441b29aaaed3f595bee", "section_path": ["Changes"], "commit_groups": [["2a724cdbf", "7ca35472c", "ac1efdd08", "ae205dfe6", "b978de0eb", "df86e52ca"]], "identity_text": "Ensure that temporary WAL and history files are removed at the end of archive recovery (Sawada Masahiko)", "commit_aliases": ["2a724cdbf", "7ca35472c", "ac1efdd08", "ae205dfe6", "b978de0eb", "df86e52ca"], "source_commits": ["2a724cdbf"], "source_entry_id": "12.1/changes/021", "db_id": "b3a030c28ed4cda30af5cca05ade9f8a", "patch_ids": ["eccec0a934f6b798a4ca948a6e5ed54f"], "statement_hash": "d9171030eaa0d655092fd4688db8b2e56f3529964d1e2d2c0b2c5e9b0624166d", "relations": [{"rule": 2, "type": "equivalent", "target": "0a3d67e35b576d9c2bd99c64ce426a2f", "evidence": {"same_day": true, "patch_ids": ["eccec0a934f6b798a4ca948a6e5ed54f"], "statement_hash": "d9171030eaa0d655092fd4688db8b2e56f3529964d1e2d2c0b2c5e9b0624166d"}}, {"rule": 2, "type": "equivalent", "target": "c1828ccc97f9d3e0be5e49a6b93cf6f5", "evidence": {"same_day": true, "patch_ids": ["eccec0a934f6b798a4ca948a6e5ed54f"], "statement_hash": "d9171030eaa0d655092fd4688db8b2e56f3529964d1e2d2c0b2c5e9b0624166d"}}, {"rule": 2, "type": "equivalent", "target": "c6f2ad7ebe26a63bb7848f935183d7e0", "evidence": {"same_day": true, "patch_ids": ["eccec0a934f6b798a4ca948a6e5ed54f"], "statement_hash": "d9171030eaa0d655092fd4688db8b2e56f3529964d1e2d2c0b2c5e9b0624166d"}}, {"rule": 2, "type": "equivalent", "target": "f506a3173b1e3502d0666e1319af57c5", "evidence": {"same_day": true, "patch_ids": ["eccec0a934f6b798a4ca948a6e5ed54f"], "statement_hash": "d9171030eaa0d655092fd4688db8b2e56f3529964d1e2d2c0b2c5e9b0624166d"}}], "version": "12.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "c1828ccc97f9d3e0be5e49a6b93cf6f5", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Ensure that temporary WAL and history files are removed at the end of archive recovery", "evidence": {"same_day": true, "patch_ids": ["eccec0a934f6b798a4ca948a6e5ed54f"], "statement_hash": "d9171030eaa0d655092fd4688db8b2e56f3529964d1e2d2c0b2c5e9b0624166d"}, "url": "/docs/compare/?release=11.6#11.6-7d836926ea0ad4ec", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "0a3d67e35b576d9c2bd99c64ce426a2f", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Ensure that temporary WAL and history files are removed at the end of archive recovery", "evidence": {"same_day": true, "patch_ids": ["eccec0a934f6b798a4ca948a6e5ed54f"], "statement_hash": "d9171030eaa0d655092fd4688db8b2e56f3529964d1e2d2c0b2c5e9b0624166d"}, "url": "/docs/compare/?release=10.11#10.11-7d836926ea0ad4ec", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "c6f2ad7ebe26a63bb7848f935183d7e0", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Ensure that temporary WAL and history files are removed at the end of archive recovery", "evidence": {"same_day": true, "patch_ids": ["eccec0a934f6b798a4ca948a6e5ed54f"], "statement_hash": "d9171030eaa0d655092fd4688db8b2e56f3529964d1e2d2c0b2c5e9b0624166d"}, "url": "/docs/compare/?release=9.6.16#9.6.16-7d836926ea0ad4ec", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "f506a3173b1e3502d0666e1319af57c5", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Ensure that temporary WAL and history files are removed at the end of archive recovery", "evidence": {"same_day": true, "patch_ids": ["eccec0a934f6b798a4ca948a6e5ed54f"], "statement_hash": "d9171030eaa0d655092fd4688db8b2e56f3529964d1e2d2c0b2c5e9b0624166d"}, "url": "/docs/compare/?release=9.5.20#9.5.20-7d836926ea0ad4ec", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "12.1-f78af228a28346b5", "cves": [], "html": "Avoid failure in archive recovery if recovery_min_apply_delay is enabled (Fujii Masao) §
recovery_min_apply_delay is not typically used in this configuration, but it should work.
Ignore restore_command, recovery_end_command, and recovery_min_apply_delay settings during crash recovery (Fujii Masao) § §
Now that these settings can be specified in postgresql.conf, they could be turned on during crash recovery, but honoring them then is undesirable. Ignore these settings until crash recovery is complete.
Fix logical replication failure when publisher and subscriber have different ideas about a table's replica identity columns (Jehan-Guillaume de Rorthais, Peter Eisentraut) § §
\nDeclaring a column as part of the replica identity on the subscriber, when it does not exist at all on the publisher, led to “negative bitmapset member not allowed” errors.
", "text": "Fix logical replication failure when publisher and subscriber have different ideas about a table's replica identity columns (Jehan-Guillaume de Rorthais, Peter Eisentraut) § § Declaring a column as part of the replica identity on the subscriber, when it does not exist at all on the publisher, led to “negative bitmapset member not allowed” errors.", "title": "Fix logical replication failure when publisher and subscriber have different ideas about a table's replica identity columns", "commits": ["d891d2c89", "f96756304"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "c7c31259c5c5084d120803d6a11b6c1b14e451c318aae65507119927c6751e94", "section_path": ["Changes"], "commit_groups": [["1c60e40ad", "2e00d5976", "7961da188", "d891d2c89"], ["806f9dc02", "aa9884578", "ef8fcbff5", "f96756304"]], "identity_text": "Fix logical replication failure when publisher and subscriber have different ideas about a table's replica identity columns (Jehan-Guillaume de Rorthais, Peter Eisentraut) Declaring a column as part of the replica identity on the subscriber, when it does not exist at all on the publisher, led to negative bitmapset member not allowed errors.", "commit_aliases": ["1c60e40ad", "2e00d5976", "7961da188", "806f9dc02", "aa9884578", "d891d2c89", "ef8fcbff5", "f96756304"], "source_commits": ["d891d2c89", "f96756304"], "source_entry_id": "12.1/changes/024", "db_id": "39d190e039df31b7769394fa2a757f17", "patch_ids": ["01bee7ee93a21f586fad49a6d03a4cff", "63e62199d910422917e20e7fddced293"], "statement_hash": "2d3205b5f95e63e135f0420ee555e22f5c84775b1611c879d2f54b392de376ca", "relations": [{"rule": 2, "type": "equivalent", "target": "06dcbe81968c5663a09fb913c4aaeae7", "evidence": {"same_day": true, "patch_ids": ["01bee7ee93a21f586fad49a6d03a4cff", "63e62199d910422917e20e7fddced293"], "statement_hash": "2d3205b5f95e63e135f0420ee555e22f5c84775b1611c879d2f54b392de376ca"}}, {"rule": 2, "type": "equivalent", "target": "a81899d12dd8e2823d50116dafd4d87f", "evidence": {"same_day": true, "patch_ids": ["01bee7ee93a21f586fad49a6d03a4cff", "63e62199d910422917e20e7fddced293"], "statement_hash": "2d3205b5f95e63e135f0420ee555e22f5c84775b1611c879d2f54b392de376ca"}}], "version": "12.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "06dcbe81968c5663a09fb913c4aaeae7", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix logical replication failure when publisher and subscriber have different ideas about a table's replica identity columns", "evidence": {"same_day": true, "patch_ids": ["01bee7ee93a21f586fad49a6d03a4cff", "63e62199d910422917e20e7fddced293"], "statement_hash": "2d3205b5f95e63e135f0420ee555e22f5c84775b1611c879d2f54b392de376ca"}, "url": "/docs/compare/?release=11.6#11.6-5eff3f641b4ec74a", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "a81899d12dd8e2823d50116dafd4d87f", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Fix logical replication failure when publisher and subscriber have different ideas about a table's replica identity columns", "evidence": {"same_day": true, "patch_ids": ["01bee7ee93a21f586fad49a6d03a4cff", "63e62199d910422917e20e7fddced293"], "statement_hash": "2d3205b5f95e63e135f0420ee555e22f5c84775b1611c879d2f54b392de376ca"}, "url": "/docs/compare/?release=10.11#10.11-5eff3f641b4ec74a", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}]}, {"id": "12.1-9156f4650864dbe2", "cves": [], "html": "Avoid unwanted delay during shutdown of a logical replication walsender (Craig Ringer, Álvaro Herrera) §
", "text": "Avoid unwanted delay during shutdown of a logical replication walsender (Craig Ringer, Álvaro Herrera) §", "title": "Avoid unwanted delay during shutdown of a logical replication walsender", "commits": ["1391c13ce"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "376572f0c56b0d04e61e351adabe3a1e3e1fcbdb9ee63d272c9464cb799df0cc", "section_path": ["Changes"], "commit_groups": [["0d9fcbada", "1391c13ce", "38ddeab13", "45e4067c0", "5f038991e", "abd5071d2", "b2ab06e02"]], "identity_text": "Avoid unwanted delay during shutdown of a logical replication walsender (Craig Ringer, Álvaro Herrera)", "commit_aliases": ["0d9fcbada", "1391c13ce", "38ddeab13", "45e4067c0", "5f038991e", "abd5071d2", "b2ab06e02"], "source_commits": ["1391c13ce"], "source_entry_id": "12.1/changes/025", "db_id": "823d796e301349805ab4d2ac9acbc490", "patch_ids": ["e55df08a6f9e29930aef6f293862575c"], "statement_hash": "9e7d15d882673512c3d1da08242816a71acc3100093a83564d9ded908580e8f6", "relations": [{"rule": 2, "type": "equivalent", "target": "09624a4b7d028d79469bd522109140be", "evidence": {"same_day": true, "patch_ids": ["e55df08a6f9e29930aef6f293862575c"], "statement_hash": "9e7d15d882673512c3d1da08242816a71acc3100093a83564d9ded908580e8f6"}}, {"rule": 2, "type": "equivalent", "target": "285efa4027b4403c87885822e031d662", "evidence": {"same_day": true, "patch_ids": ["e55df08a6f9e29930aef6f293862575c"], "statement_hash": "9e7d15d882673512c3d1da08242816a71acc3100093a83564d9ded908580e8f6"}}, {"rule": 2, "type": "equivalent", "target": "55db924fa4a72e2667fcd540c5f2ad31", "evidence": {"same_day": true, "patch_ids": ["e55df08a6f9e29930aef6f293862575c"], "statement_hash": "9e7d15d882673512c3d1da08242816a71acc3100093a83564d9ded908580e8f6"}}, {"rule": 2, "type": "equivalent", "target": "9d38fb0ff879db91f1511d933dadcfd1", "evidence": {"same_day": true, "patch_ids": ["e55df08a6f9e29930aef6f293862575c"], "statement_hash": "9e7d15d882673512c3d1da08242816a71acc3100093a83564d9ded908580e8f6"}}, {"rule": 2, "type": "equivalent", "target": "f69d528db1bdcb00d217b3b5a9ca45c0", "evidence": {"same_day": true, "patch_ids": ["e55df08a6f9e29930aef6f293862575c"], "statement_hash": "9e7d15d882673512c3d1da08242816a71acc3100093a83564d9ded908580e8f6"}}], "version": "12.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "9d38fb0ff879db91f1511d933dadcfd1", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Avoid unwanted delay during shutdown of a logical replication walsender", "evidence": {"same_day": true, "patch_ids": ["e55df08a6f9e29930aef6f293862575c"], "statement_hash": "9e7d15d882673512c3d1da08242816a71acc3100093a83564d9ded908580e8f6"}, "url": "/docs/compare/?release=11.6#11.6-69af6e903109ae8f", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "285efa4027b4403c87885822e031d662", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Avoid unwanted delay during shutdown of a logical replication walsender", "evidence": {"same_day": true, "patch_ids": ["e55df08a6f9e29930aef6f293862575c"], "statement_hash": "9e7d15d882673512c3d1da08242816a71acc3100093a83564d9ded908580e8f6"}, "url": "/docs/compare/?release=10.11#10.11-69af6e903109ae8f", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "09624a4b7d028d79469bd522109140be", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Avoid unwanted delay during shutdown of a logical replication walsender", "evidence": {"same_day": true, "patch_ids": ["e55df08a6f9e29930aef6f293862575c"], "statement_hash": "9e7d15d882673512c3d1da08242816a71acc3100093a83564d9ded908580e8f6"}, "url": "/docs/compare/?release=9.6.16#9.6.16-69af6e903109ae8f", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "f69d528db1bdcb00d217b3b5a9ca45c0", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Avoid unwanted delay during shutdown of a logical replication walsender", "evidence": {"same_day": true, "patch_ids": ["e55df08a6f9e29930aef6f293862575c"], "statement_hash": "9e7d15d882673512c3d1da08242816a71acc3100093a83564d9ded908580e8f6"}, "url": "/docs/compare/?release=9.5.20#9.5.20-69af6e903109ae8f", "source_url": "/docs/release/9.5.20/#AEN128082"}, {"db_id": "55db924fa4a72e2667fcd540c5f2ad31", "kind": "equivalent", "version": "9.4.25", "label": "9.4.25", "title": "Avoid unwanted delay during shutdown of a logical replication walsender", "evidence": {"same_day": true, "patch_ids": ["e55df08a6f9e29930aef6f293862575c"], "statement_hash": "9e7d15d882673512c3d1da08242816a71acc3100093a83564d9ded908580e8f6"}, "url": "/docs/compare/?release=9.4.25#9.4.25-69af6e903109ae8f", "source_url": "/docs/release/9.4.25/#AEN119951"}]}, {"id": "12.1-56812038d2a3fd33", "cves": [], "html": "Fix timeout handling in logical replication walreceiver processes (Julien Rouhaud) §
\nErroneous logic prevented wal_receiver_timeout from working in logical replication deployments.
Correctly time-stamp replication messages for logical decoding (Jeff Janes) §
\nThis oversight resulted, for example, in pg_stat_subscription.last_msg_send_time usually reading as NULL.
Fix race condition during backend exit, when the backend process has previously waited for synchronous replication to occur (Dongming Liu) §
", "text": "Fix race condition during backend exit, when the backend process has previously waited for synchronous replication to occur (Dongming Liu) §", "title": "Fix race condition during backend exit, when the backend process has previously waited for synchronous replication to occur", "commits": ["7b8c2de64"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "4a604906d60473ec9f9fd852c31ee1c1595f4f2d1ada327a0858b01fce715615", "section_path": ["Changes"], "commit_groups": [["0927d0c25", "20345197f", "52684bc7d", "61f238392", "7b8c2de64", "b99bfc3c9", "f88f7206e"]], "identity_text": "Fix race condition during backend exit, when the backend process has previously waited for synchronous replication to occur (Dongming Liu)", "commit_aliases": ["0927d0c25", "20345197f", "52684bc7d", "61f238392", "7b8c2de64", "b99bfc3c9", "f88f7206e"], "source_commits": ["7b8c2de64"], "source_entry_id": "12.1/changes/028", "db_id": "a01ee12cafc2d030088ea21e537886ee", "patch_ids": ["4b3ea7c4276af2c59b503f7435657beb"], "statement_hash": "3789d1d50180cb6be08ab86cf5c8349bfd117d62b04c3ab06b7281c5e26eebc1", "relations": [{"rule": 2, "type": "equivalent", "target": "252e3bebcac161cd2a788bee45dbbf68", "evidence": {"same_day": true, "patch_ids": ["4b3ea7c4276af2c59b503f7435657beb"], "statement_hash": "3789d1d50180cb6be08ab86cf5c8349bfd117d62b04c3ab06b7281c5e26eebc1"}}, {"rule": 2, "type": "equivalent", "target": "31c3805880f27375b26c15d27836bd54", "evidence": {"same_day": true, "patch_ids": ["4b3ea7c4276af2c59b503f7435657beb"], "statement_hash": "3789d1d50180cb6be08ab86cf5c8349bfd117d62b04c3ab06b7281c5e26eebc1"}}, {"rule": 2, "type": "equivalent", "target": "4e314055a876588ca9d12be8b3c839e6", "evidence": {"same_day": true, "patch_ids": ["4b3ea7c4276af2c59b503f7435657beb"], "statement_hash": "3789d1d50180cb6be08ab86cf5c8349bfd117d62b04c3ab06b7281c5e26eebc1"}}, {"rule": 2, "type": "equivalent", "target": "8cc965a6c7b1379876e047ae6dbdc5a6", "evidence": {"same_day": true, "patch_ids": ["4b3ea7c4276af2c59b503f7435657beb"], "statement_hash": "3789d1d50180cb6be08ab86cf5c8349bfd117d62b04c3ab06b7281c5e26eebc1"}}, {"rule": 2, "type": "equivalent", "target": "eb3c8ddca3d37c6b609a8844f3b368ad", "evidence": {"same_day": true, "patch_ids": ["4b3ea7c4276af2c59b503f7435657beb"], "statement_hash": "3789d1d50180cb6be08ab86cf5c8349bfd117d62b04c3ab06b7281c5e26eebc1"}}], "version": "12.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "eb3c8ddca3d37c6b609a8844f3b368ad", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix race condition during backend exit, when the backend process has previously waited for synchronous replication to occur", "evidence": {"same_day": true, "patch_ids": ["4b3ea7c4276af2c59b503f7435657beb"], "statement_hash": "3789d1d50180cb6be08ab86cf5c8349bfd117d62b04c3ab06b7281c5e26eebc1"}, "url": "/docs/compare/?release=11.6#11.6-eb3c21f292fb993b", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "8cc965a6c7b1379876e047ae6dbdc5a6", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Fix race condition during backend exit, when the backend process has previously waited for synchronous replication to occur", "evidence": {"same_day": true, "patch_ids": ["4b3ea7c4276af2c59b503f7435657beb"], "statement_hash": "3789d1d50180cb6be08ab86cf5c8349bfd117d62b04c3ab06b7281c5e26eebc1"}, "url": "/docs/compare/?release=10.11#10.11-eb3c21f292fb993b", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "31c3805880f27375b26c15d27836bd54", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Fix race condition during backend exit, when the backend process has previously waited for synchronous replication to occur", "evidence": {"same_day": true, "patch_ids": ["4b3ea7c4276af2c59b503f7435657beb"], "statement_hash": "3789d1d50180cb6be08ab86cf5c8349bfd117d62b04c3ab06b7281c5e26eebc1"}, "url": "/docs/compare/?release=9.6.16#9.6.16-eb3c21f292fb993b", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "252e3bebcac161cd2a788bee45dbbf68", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Fix race condition during backend exit, when the backend process has previously waited for synchronous replication to occur", "evidence": {"same_day": true, "patch_ids": ["4b3ea7c4276af2c59b503f7435657beb"], "statement_hash": "3789d1d50180cb6be08ab86cf5c8349bfd117d62b04c3ab06b7281c5e26eebc1"}, "url": "/docs/compare/?release=9.5.20#9.5.20-eb3c21f292fb993b", "source_url": "/docs/release/9.5.20/#AEN128082"}, {"db_id": "4e314055a876588ca9d12be8b3c839e6", "kind": "equivalent", "version": "9.4.25", "label": "9.4.25", "title": "Fix race condition during backend exit, when the backend process has previously waited for synchronous replication to occur", "evidence": {"same_day": true, "patch_ids": ["4b3ea7c4276af2c59b503f7435657beb"], "statement_hash": "3789d1d50180cb6be08ab86cf5c8349bfd117d62b04c3ab06b7281c5e26eebc1"}, "url": "/docs/compare/?release=9.4.25#9.4.25-eb3c21f292fb993b", "source_url": "/docs/release/9.4.25/#AEN119951"}]}, {"id": "12.1-a58f485526548a94", "cves": [], "html": "Avoid logging complaints about abandoned connections when using PAM authentication (Tom Lane) §
\nlibpq-based clients will typically make two connection attempts when a password is required, since they don't prompt their user for a password until their first connection attempt fails. Therefore the server is coded not to generate useless log spam when a client closes the connection upon being asked for a password. However, the PAM authentication code hadn't gotten that memo, and would generate several messages about a phantom authentication failure.
", "text": "Avoid logging complaints about abandoned connections when using PAM authentication (Tom Lane) § libpq-based clients will typically make two connection attempts when a password is required, since they don't prompt their user for a password until their first connection attempt fails. Therefore the server is coded not to generate useless log spam when a client closes the connection upon being asked for a password. However, the PAM authentication code hadn't gotten that memo, and would generate several messages about a phantom authentication failure.", "title": "Avoid logging complaints about abandoned connections when using PAM authentication", "commits": ["f9bd3b6d9"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "b67ef0cf4bb08e65e5c0eab99de175a9d9cd4220d88594e38e464179dc51592c", "section_path": ["Changes"], "commit_groups": [["0238a5028", "383602f9a", "3affe76ef", "762b25653", "970372037", "97ddc47b9", "f9bd3b6d9"]], "identity_text": "Avoid logging complaints about abandoned connections when using PAM authentication (Tom Lane) libpq-based clients will typically make two connection attempts when a password is required, since they don't prompt their user for a password until their first connection attempt fails. Therefore the server is coded not to generate useless log spam when a client closes the connection upon being asked for a password. However, the PAM authentication code hadn't gotten that memo, and would generate several messages about a phantom authentication failure.", "commit_aliases": ["0238a5028", "383602f9a", "3affe76ef", "762b25653", "970372037", "97ddc47b9", "f9bd3b6d9"], "source_commits": ["f9bd3b6d9"], "source_entry_id": "12.1/changes/029", "db_id": "4e3562f65e838457039869a2ea8d4f43", "patch_ids": ["9e1aa7a240466d5c5bfb5b1b5fe5c0ad"], "statement_hash": "f7c9739fb7a42f1d1dc795c7b7b8fc2774be6248f728701017feabfd341abb64", "relations": [{"rule": 2, "type": "equivalent", "target": "21738c6288ddbe93871d642b6a7eab9a", "evidence": {"same_day": true, "patch_ids": ["9e1aa7a240466d5c5bfb5b1b5fe5c0ad"], "statement_hash": "f7c9739fb7a42f1d1dc795c7b7b8fc2774be6248f728701017feabfd341abb64"}}, {"rule": 2, "type": "equivalent", "target": "2cdbc623a7314338e7308414a6d64af8", "evidence": {"same_day": true, "patch_ids": ["9e1aa7a240466d5c5bfb5b1b5fe5c0ad"], "statement_hash": "f7c9739fb7a42f1d1dc795c7b7b8fc2774be6248f728701017feabfd341abb64"}}, {"rule": 2, "type": "equivalent", "target": "649b888ac67da1c428bc4a931c4d7a3a", "evidence": {"same_day": true, "patch_ids": ["9e1aa7a240466d5c5bfb5b1b5fe5c0ad"], "statement_hash": "f7c9739fb7a42f1d1dc795c7b7b8fc2774be6248f728701017feabfd341abb64"}}, {"rule": 2, "type": "equivalent", "target": "ab75a00c1d4c744db8203ddd46fc32dc", "evidence": {"same_day": true, "patch_ids": ["9e1aa7a240466d5c5bfb5b1b5fe5c0ad"], "statement_hash": "f7c9739fb7a42f1d1dc795c7b7b8fc2774be6248f728701017feabfd341abb64"}}, {"rule": 2, "type": "equivalent", "target": "fddc39c7b2ccc6541d31f1838c6c31b6", "evidence": {"same_day": true, "patch_ids": ["9e1aa7a240466d5c5bfb5b1b5fe5c0ad"], "statement_hash": "f7c9739fb7a42f1d1dc795c7b7b8fc2774be6248f728701017feabfd341abb64"}}], "version": "12.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "2cdbc623a7314338e7308414a6d64af8", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Avoid logging complaints about abandoned connections when using PAM authentication", "evidence": {"same_day": true, "patch_ids": ["9e1aa7a240466d5c5bfb5b1b5fe5c0ad"], "statement_hash": "f7c9739fb7a42f1d1dc795c7b7b8fc2774be6248f728701017feabfd341abb64"}, "url": "/docs/compare/?release=11.6#11.6-7d2801a7208a7ab0", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "ab75a00c1d4c744db8203ddd46fc32dc", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Avoid logging complaints about abandoned connections when using PAM authentication", "evidence": {"same_day": true, "patch_ids": ["9e1aa7a240466d5c5bfb5b1b5fe5c0ad"], "statement_hash": "f7c9739fb7a42f1d1dc795c7b7b8fc2774be6248f728701017feabfd341abb64"}, "url": "/docs/compare/?release=10.11#10.11-7d2801a7208a7ab0", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "fddc39c7b2ccc6541d31f1838c6c31b6", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Avoid logging complaints about abandoned connections when using PAM authentication", "evidence": {"same_day": true, "patch_ids": ["9e1aa7a240466d5c5bfb5b1b5fe5c0ad"], "statement_hash": "f7c9739fb7a42f1d1dc795c7b7b8fc2774be6248f728701017feabfd341abb64"}, "url": "/docs/compare/?release=9.6.16#9.6.16-7d2801a7208a7ab0", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "21738c6288ddbe93871d642b6a7eab9a", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Avoid logging complaints about abandoned connections when using PAM authentication", "evidence": {"same_day": true, "patch_ids": ["9e1aa7a240466d5c5bfb5b1b5fe5c0ad"], "statement_hash": "f7c9739fb7a42f1d1dc795c7b7b8fc2774be6248f728701017feabfd341abb64"}, "url": "/docs/compare/?release=9.5.20#9.5.20-7d2801a7208a7ab0", "source_url": "/docs/release/9.5.20/#AEN128082"}, {"db_id": "649b888ac67da1c428bc4a931c4d7a3a", "kind": "equivalent", "version": "9.4.25", "label": "9.4.25", "title": "Avoid logging complaints about abandoned connections when using PAM authentication", "evidence": {"same_day": true, "patch_ids": ["9e1aa7a240466d5c5bfb5b1b5fe5c0ad"], "statement_hash": "f7c9739fb7a42f1d1dc795c7b7b8fc2774be6248f728701017feabfd341abb64"}, "url": "/docs/compare/?release=9.4.25#9.4.25-7d2801a7208a7ab0", "source_url": "/docs/release/9.4.25/#AEN119951"}]}, {"id": "12.1-47a035bc731f2d2c", "cves": [], "html": "Fix misbehavior of bitshiftright() (Tom Lane) § §
The bitstring right shift operator failed to zero out padding space that exists in the last byte of the result when the bitstring length is not a multiple of 8. While invisible to most operations, any nonzero bits there would result in unexpected comparison behavior, since bitstring comparisons don't bother to ignore the extra bits, expecting them to always be zero.
\nIf you have inconsistent data as a result of saving the output of bitshiftright() in a table, it's possible to fix it with something like
UPDATE mytab SET bitcol = ~(~bitcol) WHERE bitcol != ~(~bitcol);\n", "text": "Fix misbehavior of bitshiftright() (Tom Lane) § § The bitstring right shift operator failed to zero out padding space that exists in the last byte of the result when the bitstring length is not a multiple of 8. While invisible to most operations, any nonzero bits there would result in unexpected comparison behavior, since bitstring comparisons don't bother to ignore the extra bits, expecting them to always be zero. If you have inconsistent data as a result of saving the output of bitshiftright() in a table, it's possible to fix it with something like UPDATE mytab SET bitcol = ~(~bitcol) WHERE bitcol != ~(~bitcol);", "title": "Fix misbehavior of bitshiftright()", "commits": ["6c3b6406d", "860216efa"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "ffb0d7bac4505a6adae770162ce3de84cbf370e932f5c62dd1a4fa0642e69470", "section_path": ["Changes"], "commit_groups": [["096d34c3b", "35eb13270", "5ac0d9360", "6ddd164aa", "7e7abed05", "860216efa", "8a17afe84"], ["30e5b3bbe", "61aa9f544", "6c3b6406d", "8b77f783b", "9faa9794f", "b6a6c129f", "b8ddf0bdf"]], "identity_text": "Fix misbehavior of bitshiftright() (Tom Lane) The bitstring right shift operator failed to zero out padding space that exists in the last byte of the result when the bitstring length is not a multiple of 8. While invisible to most operations, any nonzero bits there would result in unexpected comparison behavior, since bitstring comparisons don't bother to ignore the extra bits, expecting them to always be zero. If you have inconsistent data as a result of saving the output of bitshiftright() in a table, it's possible to fix it with something like UPDATE mytab SET bitcol = ~(~bitcol) WHERE bitcol != ~(~bitcol);", "commit_aliases": ["096d34c3b", "30e5b3bbe", "35eb13270", "5ac0d9360", "61aa9f544", "6c3b6406d", "6ddd164aa", "7e7abed05", "860216efa", "8a17afe84", "8b77f783b", "9faa9794f", "b6a6c129f", "b8ddf0bdf"], "source_commits": ["6c3b6406d", "860216efa"], "source_entry_id": "12.1/changes/030", "db_id": "b3087a5cf08f5bd2809940a9b7fca7fe", "patch_ids": ["645e773743ded66708bfdeed1cca150a", "80cc4b25f456fae0cb55503971e08d3c"], "statement_hash": "018dc62423a960f38f4e021a35d213e72a0e5646bed012cf2a6b496e0bd6b17f", "relations": [{"rule": 2, "type": "equivalent", "target": "256c5f9a61f3e86e84e844f9956eb853", "evidence": {"same_day": true, "patch_ids": ["645e773743ded66708bfdeed1cca150a", "80cc4b25f456fae0cb55503971e08d3c"], "statement_hash": "018dc62423a960f38f4e021a35d213e72a0e5646bed012cf2a6b496e0bd6b17f"}}, {"rule": 2, "type": "equivalent", "target": "42d9304af3b1d055979da4409d578bd4", "evidence": {"same_day": true, "patch_ids": ["645e773743ded66708bfdeed1cca150a", "80cc4b25f456fae0cb55503971e08d3c"], "statement_hash": "018dc62423a960f38f4e021a35d213e72a0e5646bed012cf2a6b496e0bd6b17f"}}, {"rule": 2, "type": "equivalent", "target": "5bb57a83dbd452f009809b6376428161", "evidence": {"same_day": true, "patch_ids": ["645e773743ded66708bfdeed1cca150a", "80cc4b25f456fae0cb55503971e08d3c"], "statement_hash": "018dc62423a960f38f4e021a35d213e72a0e5646bed012cf2a6b496e0bd6b17f"}}, {"rule": 2, "type": "equivalent", "target": "b28c4dab180e3c439120ed5a9c176c4f", "evidence": {"same_day": true, "patch_ids": ["645e773743ded66708bfdeed1cca150a", "80cc4b25f456fae0cb55503971e08d3c"], "statement_hash": "018dc62423a960f38f4e021a35d213e72a0e5646bed012cf2a6b496e0bd6b17f"}}, {"rule": 2, "type": "equivalent", "target": "b31f85a3ca08998a31dc57a7946f8561", "evidence": {"same_day": true, "patch_ids": ["645e773743ded66708bfdeed1cca150a", "80cc4b25f456fae0cb55503971e08d3c"], "statement_hash": "018dc62423a960f38f4e021a35d213e72a0e5646bed012cf2a6b496e0bd6b17f"}}], "version": "12.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "5bb57a83dbd452f009809b6376428161", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix misbehavior of bitshiftright()", "evidence": {"same_day": true, "patch_ids": ["645e773743ded66708bfdeed1cca150a", "80cc4b25f456fae0cb55503971e08d3c"], "statement_hash": "018dc62423a960f38f4e021a35d213e72a0e5646bed012cf2a6b496e0bd6b17f"}, "url": "/docs/compare/?release=11.6#11.6-5a5893e40f010ae4", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "b28c4dab180e3c439120ed5a9c176c4f", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Fix misbehavior of bitshiftright()", "evidence": {"same_day": true, "patch_ids": ["645e773743ded66708bfdeed1cca150a", "80cc4b25f456fae0cb55503971e08d3c"], "statement_hash": "018dc62423a960f38f4e021a35d213e72a0e5646bed012cf2a6b496e0bd6b17f"}, "url": "/docs/compare/?release=10.11#10.11-5a5893e40f010ae4", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "b31f85a3ca08998a31dc57a7946f8561", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Fix misbehavior of bitshiftright()", "evidence": {"same_day": true, "patch_ids": ["645e773743ded66708bfdeed1cca150a", "80cc4b25f456fae0cb55503971e08d3c"], "statement_hash": "018dc62423a960f38f4e021a35d213e72a0e5646bed012cf2a6b496e0bd6b17f"}, "url": "/docs/compare/?release=9.6.16#9.6.16-5a5893e40f010ae4", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "256c5f9a61f3e86e84e844f9956eb853", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Fix misbehavior of bitshiftright()", "evidence": {"same_day": true, "patch_ids": ["645e773743ded66708bfdeed1cca150a", "80cc4b25f456fae0cb55503971e08d3c"], "statement_hash": "018dc62423a960f38f4e021a35d213e72a0e5646bed012cf2a6b496e0bd6b17f"}, "url": "/docs/compare/?release=9.5.20#9.5.20-5a5893e40f010ae4", "source_url": "/docs/release/9.5.20/#AEN128082"}, {"db_id": "42d9304af3b1d055979da4409d578bd4", "kind": "equivalent", "version": "9.4.25", "label": "9.4.25", "title": "Fix misbehavior of bitshiftright()", "evidence": {"same_day": true, "patch_ids": ["645e773743ded66708bfdeed1cca150a", "80cc4b25f456fae0cb55503971e08d3c"], "statement_hash": "018dc62423a960f38f4e021a35d213e72a0e5646bed012cf2a6b496e0bd6b17f"}, "url": "/docs/compare/?release=9.4.25#9.4.25-5a5893e40f010ae4", "source_url": "/docs/release/9.4.25/#AEN119951"}]}, {"id": "12.1-3b1362d8224ce0d9", "cves": [], "html": "
Fix result of text position() function (also known as strpos()) for an empty search string (Tom Lane) §
Historically, and per the SQL standard, the result should be one in such cases, but 12.0 returned zero.
", "text": "Fix result of text position() function (also known as strpos()) for an empty search string (Tom Lane) § Historically, and per the SQL standard, the result should be one in such cases, but 12.0 returned zero.", "title": "Fix result of text position() function (also known as strpos()) for an empty search string", "commits": ["43e43771b"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "e58d4c9f14c314f4e25739e52a80a597501358630199663f4952730636fb0ffa", "section_path": ["Changes"], "commit_groups": [["43e43771b", "bd1ef5799"]], "identity_text": "Fix result of text position() function (also known as strpos()) for an empty search string (Tom Lane) Historically, and per the SQL standard, the result should be one in such cases, but 12.0 returned zero.", "commit_aliases": ["43e43771b", "bd1ef5799"], "source_commits": ["43e43771b"], "source_entry_id": "12.1/changes/031", "db_id": "2216e9d90394efe3dab7383cf53df4cb", "patch_ids": ["cb4c8273ea50bc5988ab9f4e221f3316"], "statement_hash": "1c6ccbc727eb03889251f43d2f67ee59b0620d4535c49627000215c7d7806336", "relations": [], "version": "12.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "12.1-0282ed12e06cabde", "cves": [], "html": "Fix detection of edge-case integer overflow in interval multiplication (Yuya Watari) §
", "text": "Fix detection of edge-case integer overflow in interval multiplication (Yuya Watari) §", "title": "Fix detection of edge-case integer overflow in interval multiplication", "commits": ["f6e72dc9c"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "6995f83c1c139da7b538f2785779b23fbe1813a99852013788b3e7479b358e3e", "section_path": ["Changes"], "commit_groups": [["15783d057", "5f794f757", "84780d468", "8d380864a", "a7145f6bc", "b49b7f944", "f6e72dc9c"], ["18622caa3", "30f6998ff", "a55018760"]], "identity_text": "Fix detection of edge-case integer overflow in interval multiplication (Yuya Watari)", "commit_aliases": ["15783d057", "18622caa3", "30f6998ff", "5f794f757", "84780d468", "8d380864a", "a55018760", "a7145f6bc", "b49b7f944", "f6e72dc9c"], "source_commits": ["a55018760", "f6e72dc9c"], "source_entry_id": "12.1/changes/032", "db_id": "7d17e70514638e9934682dd4384e78b1", "patch_ids": ["6133e47aab47749c29b127f2f4a7bdf4", "908fa4f29f05192ee59958f469e36ce1"], "statement_hash": "7cdcf76c6bf97331d0630b099eab8609f4d7f07848a4458a40876333a5abf76c", "relations": [{"rule": 2, "type": "equivalent", "target": "109a8cfa77f3b4114f60c8757e03e330", "evidence": {"same_day": true, "patch_ids": ["6133e47aab47749c29b127f2f4a7bdf4", "908fa4f29f05192ee59958f469e36ce1"], "statement_hash": "7cdcf76c6bf97331d0630b099eab8609f4d7f07848a4458a40876333a5abf76c"}}, {"rule": 2, "type": "equivalent", "target": "17545ebb5db752cf1bb80acb0053f9b0", "evidence": {"same_day": true, "patch_ids": ["6133e47aab47749c29b127f2f4a7bdf4", "908fa4f29f05192ee59958f469e36ce1"], "statement_hash": "7cdcf76c6bf97331d0630b099eab8609f4d7f07848a4458a40876333a5abf76c"}}, {"rule": 2, "type": "equivalent", "target": "4f905d06a5c25d4b8d28e94c2622d366", "evidence": {"same_day": true, "patch_ids": ["6133e47aab47749c29b127f2f4a7bdf4", "908fa4f29f05192ee59958f469e36ce1"], "statement_hash": "7cdcf76c6bf97331d0630b099eab8609f4d7f07848a4458a40876333a5abf76c"}}, {"rule": 2, "type": "equivalent", "target": "aa81f2865b69a4270c2849c5addde2d9", "evidence": {"same_day": true, "patch_ids": ["6133e47aab47749c29b127f2f4a7bdf4", "908fa4f29f05192ee59958f469e36ce1"], "statement_hash": "7cdcf76c6bf97331d0630b099eab8609f4d7f07848a4458a40876333a5abf76c"}}, {"rule": 2, "type": "equivalent", "target": "f33041de3179ff43aa931a193e8e70b2", "evidence": {"same_day": true, "patch_ids": ["6133e47aab47749c29b127f2f4a7bdf4", "908fa4f29f05192ee59958f469e36ce1"], "statement_hash": "7cdcf76c6bf97331d0630b099eab8609f4d7f07848a4458a40876333a5abf76c"}}], "version": "12.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "f33041de3179ff43aa931a193e8e70b2", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix detection of edge-case integer overflow in interval multiplication", "evidence": {"same_day": true, "patch_ids": ["6133e47aab47749c29b127f2f4a7bdf4", "908fa4f29f05192ee59958f469e36ce1"], "statement_hash": "7cdcf76c6bf97331d0630b099eab8609f4d7f07848a4458a40876333a5abf76c"}, "url": "/docs/compare/?release=11.6#11.6-75de43d9a302d9de", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "17545ebb5db752cf1bb80acb0053f9b0", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Fix detection of edge-case integer overflow in interval multiplication", "evidence": {"same_day": true, "patch_ids": ["6133e47aab47749c29b127f2f4a7bdf4", "908fa4f29f05192ee59958f469e36ce1"], "statement_hash": "7cdcf76c6bf97331d0630b099eab8609f4d7f07848a4458a40876333a5abf76c"}, "url": "/docs/compare/?release=10.11#10.11-75de43d9a302d9de", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "109a8cfa77f3b4114f60c8757e03e330", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Fix detection of edge-case integer overflow in interval multiplication", "evidence": {"same_day": true, "patch_ids": ["6133e47aab47749c29b127f2f4a7bdf4", "908fa4f29f05192ee59958f469e36ce1"], "statement_hash": "7cdcf76c6bf97331d0630b099eab8609f4d7f07848a4458a40876333a5abf76c"}, "url": "/docs/compare/?release=9.6.16#9.6.16-75de43d9a302d9de", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "aa81f2865b69a4270c2849c5addde2d9", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Fix detection of edge-case integer overflow in interval multiplication", "evidence": {"same_day": true, "patch_ids": ["6133e47aab47749c29b127f2f4a7bdf4", "908fa4f29f05192ee59958f469e36ce1"], "statement_hash": "7cdcf76c6bf97331d0630b099eab8609f4d7f07848a4458a40876333a5abf76c"}, "url": "/docs/compare/?release=9.5.20#9.5.20-75de43d9a302d9de", "source_url": "/docs/release/9.5.20/#AEN128082"}, {"db_id": "4f905d06a5c25d4b8d28e94c2622d366", "kind": "equivalent", "version": "9.4.25", "label": "9.4.25", "title": "Fix detection of edge-case integer overflow in interval multiplication", "evidence": {"same_day": true, "patch_ids": ["6133e47aab47749c29b127f2f4a7bdf4", "908fa4f29f05192ee59958f469e36ce1"], "statement_hash": "7cdcf76c6bf97331d0630b099eab8609f4d7f07848a4458a40876333a5abf76c"}, "url": "/docs/compare/?release=9.4.25#9.4.25-75de43d9a302d9de", "source_url": "/docs/release/9.4.25/#AEN119951"}]}, {"id": "12.1-6ec3b334cd31d5fc", "cves": [], "html": "Avoid crashes if ispell text search dictionaries contain wrong affix data (Arthur Zakirov) § §
Avoid memory leak while vacuuming a GiST index (Dilip Kumar) §
", "text": "Avoid memory leak while vacuuming a GiST index (Dilip Kumar) §", "title": "Avoid memory leak while vacuuming a GiST index", "commits": ["62f4dd379"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "2d31adcac91cd8e906eff05559919fc950785eecabb59aa3d3ad8e602f23166a", "section_path": ["Changes"], "commit_groups": [["62f4dd379", "70a6c37d5"]], "identity_text": "Avoid memory leak while vacuuming a GiST index (Dilip Kumar)", "commit_aliases": ["62f4dd379", "70a6c37d5"], "source_commits": ["62f4dd379"], "source_entry_id": "12.1/changes/034", "db_id": "d760b62974fd3051f55218f0a8177e4a", "patch_ids": ["4c115fe827afb228ce89e63a1387ad96"], "statement_hash": "f6bec5a45f30fe8c5320384406a952cfaa7a134199a5229061d4733acb1adff7", "relations": [], "version": "12.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "12.1-d61548fa25c77231", "cves": [], "html": "On Windows, recognize additional spellings of the “Norwegian (Bokmål)” locale name (Tom Lane) §
", "text": "On Windows, recognize additional spellings of the “Norwegian (Bokmål)” locale name (Tom Lane) §", "title": "On Windows, recognize additional spellings of the “Norwegian (Bokmål)” locale name", "commits": ["4f2ad5226"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "04c3d2daca07f5664a592b4ebf4aafbed0abea34e330a699da607a7b0d087b0d", "section_path": ["Changes"], "commit_groups": [["185253ab8", "4f2ad5226", "a05a04d0e", "aebe3ef0e", "db477b691", "e3267407e", "fedcab352"]], "identity_text": "On Windows, recognize additional spellings of the Norwegian (Bokmål) locale name (Tom Lane)", "commit_aliases": ["185253ab8", "4f2ad5226", "a05a04d0e", "aebe3ef0e", "db477b691", "e3267407e", "fedcab352"], "source_commits": ["4f2ad5226"], "source_entry_id": "12.1/changes/035", "db_id": "225febe7c77dd58718ec5f3f63a0812d", "patch_ids": ["b4d55cbc4d3eb09a21b712947fc01446"], "statement_hash": "6365cced4f4ad597334c45749ccad9c902fd71e380f4a88b6dc5f99475529bf5", "relations": [{"rule": 2, "type": "equivalent", "target": "26d29236bce72fa79bbb285e2ee96b25", "evidence": {"same_day": true, "patch_ids": ["b4d55cbc4d3eb09a21b712947fc01446"], "statement_hash": "6365cced4f4ad597334c45749ccad9c902fd71e380f4a88b6dc5f99475529bf5"}}, {"rule": 2, "type": "equivalent", "target": "605dd65b38b1599763cf75961ffcd71b", "evidence": {"same_day": true, "patch_ids": ["b4d55cbc4d3eb09a21b712947fc01446"], "statement_hash": "6365cced4f4ad597334c45749ccad9c902fd71e380f4a88b6dc5f99475529bf5"}}, {"rule": 2, "type": "equivalent", "target": "73495a6bf973b70836e3aca3f2c2ac51", "evidence": {"same_day": true, "patch_ids": ["b4d55cbc4d3eb09a21b712947fc01446"], "statement_hash": "6365cced4f4ad597334c45749ccad9c902fd71e380f4a88b6dc5f99475529bf5"}}, {"rule": 2, "type": "equivalent", "target": "789cec58ca9f82e639ee2a2dae1500f0", "evidence": {"same_day": true, "patch_ids": ["b4d55cbc4d3eb09a21b712947fc01446"], "statement_hash": "6365cced4f4ad597334c45749ccad9c902fd71e380f4a88b6dc5f99475529bf5"}}, {"rule": 2, "type": "equivalent", "target": "be67afb148dc3575454e6d95f868998f", "evidence": {"same_day": true, "patch_ids": ["b4d55cbc4d3eb09a21b712947fc01446"], "statement_hash": "6365cced4f4ad597334c45749ccad9c902fd71e380f4a88b6dc5f99475529bf5"}}], "version": "12.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "be67afb148dc3575454e6d95f868998f", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "On Windows, recognize additional spellings of the “Norwegian (Bokmål)” locale name", "evidence": {"same_day": true, "patch_ids": ["b4d55cbc4d3eb09a21b712947fc01446"], "statement_hash": "6365cced4f4ad597334c45749ccad9c902fd71e380f4a88b6dc5f99475529bf5"}, "url": "/docs/compare/?release=11.6#11.6-5651fd91046288e4", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "605dd65b38b1599763cf75961ffcd71b", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "On Windows, recognize additional spellings of the “Norwegian (Bokmål)” locale name", "evidence": {"same_day": true, "patch_ids": ["b4d55cbc4d3eb09a21b712947fc01446"], "statement_hash": "6365cced4f4ad597334c45749ccad9c902fd71e380f4a88b6dc5f99475529bf5"}, "url": "/docs/compare/?release=10.11#10.11-5651fd91046288e4", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "73495a6bf973b70836e3aca3f2c2ac51", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "On Windows, recognize additional spellings of the \"Norwegian (Bokmål)\" locale name", "evidence": {"same_day": true, "patch_ids": ["b4d55cbc4d3eb09a21b712947fc01446"], "statement_hash": "6365cced4f4ad597334c45749ccad9c902fd71e380f4a88b6dc5f99475529bf5"}, "url": "/docs/compare/?release=9.6.16#9.6.16-58eb2a630e84cd10", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "789cec58ca9f82e639ee2a2dae1500f0", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "On Windows, recognize additional spellings of the \"Norwegian (Bokmål)\" locale name", "evidence": {"same_day": true, "patch_ids": ["b4d55cbc4d3eb09a21b712947fc01446"], "statement_hash": "6365cced4f4ad597334c45749ccad9c902fd71e380f4a88b6dc5f99475529bf5"}, "url": "/docs/compare/?release=9.5.20#9.5.20-58eb2a630e84cd10", "source_url": "/docs/release/9.5.20/#AEN128082"}, {"db_id": "26d29236bce72fa79bbb285e2ee96b25", "kind": "equivalent", "version": "9.4.25", "label": "9.4.25", "title": "On Windows, recognize additional spellings of the \"Norwegian (Bokmål)\" locale name", "evidence": {"same_day": true, "patch_ids": ["b4d55cbc4d3eb09a21b712947fc01446"], "statement_hash": "6365cced4f4ad597334c45749ccad9c902fd71e380f4a88b6dc5f99475529bf5"}, "url": "/docs/compare/?release=9.4.25#9.4.25-58eb2a630e84cd10", "source_url": "/docs/release/9.4.25/#AEN119951"}]}, {"id": "12.1-b3bfdf50212bc594", "cves": [], "html": "Fix libpq to allow trailing whitespace in the string values of integer parameters (Michael Paquier) § §
\nVersion 12 tightened libpq's validation of integer parameters, but disallowing trailing whitespace seems undesirable.
", "text": "Fix libpq to allow trailing whitespace in the string values of integer parameters (Michael Paquier) § § Version 12 tightened libpq's validation of integer parameters, but disallowing trailing whitespace seems undesirable.", "title": "Fix libpq to allow trailing whitespace in the string values of integer parameters", "commits": ["2b0f959b5", "a6a95d4f3"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "227ce51121e957d5e0571bba13b3347d22b2e5b58a472c29884f5aa43317a463", "section_path": ["Changes"], "commit_groups": [["2b0f959b5", "4f4061b2d"], ["57379cd5a", "a6a95d4f3"]], "identity_text": "Fix libpq to allow trailing whitespace in the string values of integer parameters (Michael Paquier) Version 12 tightened libpq's validation of integer parameters, but disallowing trailing whitespace seems undesirable.", "commit_aliases": ["2b0f959b5", "4f4061b2d", "57379cd5a", "a6a95d4f3"], "source_commits": ["2b0f959b5", "a6a95d4f3"], "source_entry_id": "12.1/changes/036", "db_id": "756be4af3d72176f92a32520620d788d", "patch_ids": ["5d94f1749888b2b97972a4e00e0c536c", "7239af6a7bc0deb26fbf98dd336d3caf"], "statement_hash": "68d9124f8eebed62ff17a91dc3e02c6a95ddddb2864b67ecc58b81c1042e3537", "relations": [], "version": "12.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "12.1-3c879b6dcf67d4be", "cves": [], "html": "In libpq, correctly report CONNECTION_BAD connection status after a failure caused by a syntactically invalid connect_timeout parameter value (Lars Kanis) §
Avoid compile failure if an ECPG client includes ecpglib.h while having ENABLE_NLS defined (Tom Lane) §
This risk was created by a misplaced declaration: ecpg_gettext() should not be visible to client code.
Fix scheduling of parallel restore of a foreign key constraint on a partitioned table (Álvaro Herrera) §
\npg_dump failed to emit full dependency information for partitioned tables' foreign keys. This could allow parallel pg_restore to try to recreate a foreign key constraint too soon.
", "text": "Fix scheduling of parallel restore of a foreign key constraint on a partitioned table (Álvaro Herrera) § pg_dump failed to emit full dependency information for partitioned tables' foreign keys. This could allow parallel pg_restore to try to recreate a foreign key constraint too soon.", "title": "Fix scheduling of parallel restore of a foreign key constraint on a partitioned table", "commits": ["b304b2b65"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "905c2702c790ab979170d7ac2eca093ed3c4b22f595626ef0a0cc8eb31748c0f", "section_path": ["Changes"], "commit_groups": [["1752e3516", "b304b2b65"]], "identity_text": "Fix scheduling of parallel restore of a foreign key constraint on a partitioned table (Álvaro Herrera) pg_dump failed to emit full dependency information for partitioned tables' foreign keys. This could allow parallel pg_restore to try to recreate a foreign key constraint too soon.", "commit_aliases": ["1752e3516", "b304b2b65"], "source_commits": ["b304b2b65"], "source_entry_id": "12.1/changes/039", "db_id": "88a1c5e4a5c6c9fa58526357c4111d9c", "patch_ids": ["adeacf4df6acf3281f7e6f6e3a171d92"], "statement_hash": "83bd701e513b64b4ac350d22a82280d822783d79ad1981a01ba2a7b2d4b43c71", "relations": [], "version": "12.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "12.1-f86364d7db67984c", "cves": [], "html": "In pg_dump, ensure stable output order for similarly-named triggers and row-level-security policy objects (Benjie Gillam) §
\nPreviously, if two triggers on different tables had the same names, they would be sorted in OID-based order, which is less desirable than sorting them by table name. Likewise for RLS policies.
", "text": "In pg_dump, ensure stable output order for similarly-named triggers and row-level-security policy objects (Benjie Gillam) § Previously, if two triggers on different tables had the same names, they would be sorted in OID-based order, which is less desirable than sorting them by table name. Likewise for RLS policies.", "title": "In pg_dump, ensure stable output order for similarly-named triggers and row-level-security policy objects", "commits": ["ca27a84c9"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "0f65b47b65b87507c697edc04487c7b51e771cb44112bbf43afd0a6a1be6b873", "section_path": ["Changes"], "commit_groups": [["078f5bc8e", "5102f3944", "648f17879", "74d32ee70", "ca27a84c9", "da5cd7a68", "ee8b95f26"]], "identity_text": "In pg_dump, ensure stable output order for similarly-named triggers and row-level-security policy objects (Benjie Gillam) Previously, if two triggers on different tables had the same names, they would be sorted in OID-based order, which is less desirable than sorting them by table name. Likewise for RLS policies.", "commit_aliases": ["078f5bc8e", "5102f3944", "648f17879", "74d32ee70", "ca27a84c9", "da5cd7a68", "ee8b95f26"], "source_commits": ["ca27a84c9"], "source_entry_id": "12.1/changes/040", "db_id": "fa647ca113a1508559005eb20a936e44", "patch_ids": ["942313a05555b57ba0897a803f711227"], "statement_hash": "cda6c53c513e726a6397771aeafd5bec7d15381a61afc0f0239a83be49bb9913", "relations": [{"rule": 2, "type": "equivalent", "target": "1eb55e45430b0c45783250806e8815e0", "evidence": {"same_day": true, "patch_ids": ["942313a05555b57ba0897a803f711227"], "statement_hash": "cda6c53c513e726a6397771aeafd5bec7d15381a61afc0f0239a83be49bb9913"}}, {"rule": 2, "type": "equivalent", "target": "23135c2ddd64175efaa2b46647c07c11", "evidence": {"same_day": true, "patch_ids": ["942313a05555b57ba0897a803f711227"], "statement_hash": "cda6c53c513e726a6397771aeafd5bec7d15381a61afc0f0239a83be49bb9913"}}, {"rule": 2, "type": "equivalent", "target": "25bd821359a3753038ddadded63e6f3a", "evidence": {"same_day": true, "patch_ids": ["942313a05555b57ba0897a803f711227"], "statement_hash": "cda6c53c513e726a6397771aeafd5bec7d15381a61afc0f0239a83be49bb9913"}}, {"rule": 2, "type": "equivalent", "target": "921c2a7e63d27aaae4036e625c6887fd", "evidence": {"same_day": true, "patch_ids": ["942313a05555b57ba0897a803f711227"], "statement_hash": "cda6c53c513e726a6397771aeafd5bec7d15381a61afc0f0239a83be49bb9913"}}, {"rule": 2, "type": "equivalent", "target": "a8a5d43ed77e0081ab73103ceb2ae846", "evidence": {"same_day": true, "patch_ids": ["942313a05555b57ba0897a803f711227"], "statement_hash": "cda6c53c513e726a6397771aeafd5bec7d15381a61afc0f0239a83be49bb9913"}}], "version": "12.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "23135c2ddd64175efaa2b46647c07c11", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "In pg_dump, ensure stable output order for similarly-named triggers and row-level-security policy objects", "evidence": {"same_day": true, "patch_ids": ["942313a05555b57ba0897a803f711227"], "statement_hash": "cda6c53c513e726a6397771aeafd5bec7d15381a61afc0f0239a83be49bb9913"}, "url": "/docs/compare/?release=11.6#11.6-06b38c70f27c77eb", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "921c2a7e63d27aaae4036e625c6887fd", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "In pg_dump, ensure stable output order for similarly-named triggers and row-level-security policy objects", "evidence": {"same_day": true, "patch_ids": ["942313a05555b57ba0897a803f711227"], "statement_hash": "cda6c53c513e726a6397771aeafd5bec7d15381a61afc0f0239a83be49bb9913"}, "url": "/docs/compare/?release=10.11#10.11-06b38c70f27c77eb", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "25bd821359a3753038ddadded63e6f3a", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "In pg_dump, ensure stable output order for similarly-named triggers and row-level-security policy objects", "evidence": {"same_day": true, "patch_ids": ["942313a05555b57ba0897a803f711227"], "statement_hash": "cda6c53c513e726a6397771aeafd5bec7d15381a61afc0f0239a83be49bb9913"}, "url": "/docs/compare/?release=9.6.16#9.6.16-06b38c70f27c77eb", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "1eb55e45430b0c45783250806e8815e0", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "In pg_dump, ensure stable output order for similarly-named triggers and row-level-security policy objects", "evidence": {"same_day": true, "patch_ids": ["942313a05555b57ba0897a803f711227"], "statement_hash": "cda6c53c513e726a6397771aeafd5bec7d15381a61afc0f0239a83be49bb9913"}, "url": "/docs/compare/?release=9.5.20#9.5.20-06b38c70f27c77eb", "source_url": "/docs/release/9.5.20/#AEN128082"}, {"db_id": "a8a5d43ed77e0081ab73103ceb2ae846", "kind": "equivalent", "version": "9.4.25", "label": "9.4.25", "title": "In pg_dump, ensure stable output order for similarly-named triggers and row-level-security policy objects", "evidence": {"same_day": true, "patch_ids": ["942313a05555b57ba0897a803f711227"], "statement_hash": "cda6c53c513e726a6397771aeafd5bec7d15381a61afc0f0239a83be49bb9913"}, "url": "/docs/compare/?release=9.4.25#9.4.25-06b38c70f27c77eb", "source_url": "/docs/release/9.4.25/#AEN119951"}]}, {"id": "12.1-3bca93f5bb28ed2c", "cves": [], "html": "In pg_upgrade, reject tables with columns of type sql_identifier, as that has changed representation in version 12 (Tomas Vondra) § §
Improve pg_upgrade's checks for the use of a data type that has changed representation, such as line (Tomas Vondra) § §
The previous coding could be fooled by cases where the data type of interest underlies a stored column of a domain or composite type.
", "text": "Improve pg_upgrade's checks for the use of a data type that has changed representation, such as line (Tomas Vondra) § § The previous coding could be fooled by cases where the data type of interest underlies a stored column of a domain or composite type.", "title": "Improve pg_upgrade's checks for the use of a data type that has changed representation, such as line", "commits": ["a8e49ae0c", "ebb4caa91"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "f6786d49c71026969481a22463b4d5a9cf80113fef052a7dd9b26c749510e0da", "section_path": ["Changes"], "commit_groups": [["0a643de08", "2218fdca4", "235a52ca0", "8d48e6a72", "a970b6cde", "ebb4caa91", "f57b01dd7"], ["984aa0ede", "bc3a94dc0", "e09ab32a2"], ["a524f50d0", "a8e49ae0c", "d071a2539", "e86ece221"]], "identity_text": "Improve pg_upgrade's checks for the use of a data type that has changed representation, such as line (Tomas Vondra) The previous coding could be fooled by cases where the data type of interest underlies a stored column of a domain or composite type.", "commit_aliases": ["0a643de08", "2218fdca4", "235a52ca0", "8d48e6a72", "984aa0ede", "a524f50d0", "a8e49ae0c", "a970b6cde", "bc3a94dc0", "d071a2539", "e09ab32a2", "e86ece221", "ebb4caa91", "f57b01dd7"], "source_commits": ["a8e49ae0c", "e09ab32a2", "ebb4caa91"], "source_entry_id": "12.1/changes/042", "db_id": "00e22fc3b19209ebf05ca425b9ea27ba", "patch_ids": ["0e623a704a7e6eb0fc8d588ecdb76af5", "199f05d03ba135f80467a01b7586ee3c", "64e1457e23cab5d9aa9fd7e39ad09645"], "statement_hash": "270077457021aa52ded0d5d6bc4e1f642f17f2bf5810b6cb9111f6006f565dbb", "relations": [{"rule": 2, "type": "equivalent", "target": "072900c922faab2411c7ca0e25dc834b", "evidence": {"same_day": true, "patch_ids": ["0e623a704a7e6eb0fc8d588ecdb76af5", "199f05d03ba135f80467a01b7586ee3c", "64e1457e23cab5d9aa9fd7e39ad09645"], "statement_hash": "270077457021aa52ded0d5d6bc4e1f642f17f2bf5810b6cb9111f6006f565dbb"}}, {"rule": 2, "type": "equivalent", "target": "c6dbec348b8c1f9ac693d8cfecf5b92e", "evidence": {"same_day": true, "patch_ids": ["0e623a704a7e6eb0fc8d588ecdb76af5", "199f05d03ba135f80467a01b7586ee3c", "64e1457e23cab5d9aa9fd7e39ad09645"], "statement_hash": "270077457021aa52ded0d5d6bc4e1f642f17f2bf5810b6cb9111f6006f565dbb"}}, {"rule": 2, "type": "equivalent", "target": "ca14a9b1b159c7912770289654a6f0b9", "evidence": {"same_day": true, "patch_ids": ["0e623a704a7e6eb0fc8d588ecdb76af5", "199f05d03ba135f80467a01b7586ee3c", "64e1457e23cab5d9aa9fd7e39ad09645"], "statement_hash": "270077457021aa52ded0d5d6bc4e1f642f17f2bf5810b6cb9111f6006f565dbb"}}, {"rule": 2, "type": "equivalent", "target": "dc3f72604090aa81b343e5c1103d3d82", "evidence": {"same_day": true, "patch_ids": ["0e623a704a7e6eb0fc8d588ecdb76af5", "199f05d03ba135f80467a01b7586ee3c", "64e1457e23cab5d9aa9fd7e39ad09645"], "statement_hash": "270077457021aa52ded0d5d6bc4e1f642f17f2bf5810b6cb9111f6006f565dbb"}}, {"rule": 2, "type": "equivalent", "target": "f5f7037586fa92a8bf4ff4d15a9afea2", "evidence": {"same_day": true, "patch_ids": ["0e623a704a7e6eb0fc8d588ecdb76af5", "199f05d03ba135f80467a01b7586ee3c", "64e1457e23cab5d9aa9fd7e39ad09645"], "statement_hash": "270077457021aa52ded0d5d6bc4e1f642f17f2bf5810b6cb9111f6006f565dbb"}}], "version": "12.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "c6dbec348b8c1f9ac693d8cfecf5b92e", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Improve pg_upgrade's checks for the use of a data type that has changed representation, such as line", "evidence": {"same_day": true, "patch_ids": ["0e623a704a7e6eb0fc8d588ecdb76af5", "199f05d03ba135f80467a01b7586ee3c", "64e1457e23cab5d9aa9fd7e39ad09645"], "statement_hash": "270077457021aa52ded0d5d6bc4e1f642f17f2bf5810b6cb9111f6006f565dbb"}, "url": "/docs/compare/?release=11.6#11.6-c10ea15b98e44886", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "dc3f72604090aa81b343e5c1103d3d82", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Improve pg_upgrade's checks for the use of a data type that has changed representation, such as line", "evidence": {"same_day": true, "patch_ids": ["0e623a704a7e6eb0fc8d588ecdb76af5", "199f05d03ba135f80467a01b7586ee3c", "64e1457e23cab5d9aa9fd7e39ad09645"], "statement_hash": "270077457021aa52ded0d5d6bc4e1f642f17f2bf5810b6cb9111f6006f565dbb"}, "url": "/docs/compare/?release=10.11#10.11-c10ea15b98e44886", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "072900c922faab2411c7ca0e25dc834b", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Improve pg_upgrade's checks for the use of a data type that has changed representation, such as line", "evidence": {"same_day": true, "patch_ids": ["0e623a704a7e6eb0fc8d588ecdb76af5", "199f05d03ba135f80467a01b7586ee3c", "64e1457e23cab5d9aa9fd7e39ad09645"], "statement_hash": "270077457021aa52ded0d5d6bc4e1f642f17f2bf5810b6cb9111f6006f565dbb"}, "url": "/docs/compare/?release=9.6.16#9.6.16-c10ea15b98e44886", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "f5f7037586fa92a8bf4ff4d15a9afea2", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Improve pg_upgrade's checks for the use of a data type that has changed representation, such as line", "evidence": {"same_day": true, "patch_ids": ["0e623a704a7e6eb0fc8d588ecdb76af5", "199f05d03ba135f80467a01b7586ee3c", "64e1457e23cab5d9aa9fd7e39ad09645"], "statement_hash": "270077457021aa52ded0d5d6bc4e1f642f17f2bf5810b6cb9111f6006f565dbb"}, "url": "/docs/compare/?release=9.5.20#9.5.20-c10ea15b98e44886", "source_url": "/docs/release/9.5.20/#AEN128082"}, {"db_id": "ca14a9b1b159c7912770289654a6f0b9", "kind": "equivalent", "version": "9.4.25", "label": "9.4.25", "title": "Improve pg_upgrade's checks for the use of a data type that has changed representation, such as line", "evidence": {"same_day": true, "patch_ids": ["0e623a704a7e6eb0fc8d588ecdb76af5", "199f05d03ba135f80467a01b7586ee3c", "64e1457e23cab5d9aa9fd7e39ad09645"], "statement_hash": "270077457021aa52ded0d5d6bc4e1f642f17f2bf5810b6cb9111f6006f565dbb"}, "url": "/docs/compare/?release=9.4.25#9.4.25-c10ea15b98e44886", "source_url": "/docs/release/9.4.25/#AEN119951"}]}, {"id": "12.1-363be92f4ceb0b6a", "cves": [], "html": "In pg_rewind with the --dry-run option, avoid updating pg_control (Alexey Kondratov) §
This could lead to failures in subsequent pg_rewind attempts.
", "text": "In pg_rewind with the --dry-run option, avoid updating pg_control (Alexey Kondratov) § This could lead to failures in subsequent pg_rewind attempts.", "title": "In pg_rewind with the --dry-run option, avoid updating pg_control", "commits": ["c2e3b311d"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "241fbaa33518276f01b80e7a572593c6c0383d6642e88ec0be0961a469fdf4e8", "section_path": ["Changes"], "commit_groups": [["6f3823b03", "c2e3b311d"]], "identity_text": "In pg_rewind with the --dry-run option, avoid updating pg_control (Alexey Kondratov) This could lead to failures in subsequent pg_rewind attempts.", "commit_aliases": ["6f3823b03", "c2e3b311d"], "source_commits": ["c2e3b311d"], "source_entry_id": "12.1/changes/043", "db_id": "4bc094599788ccef2a105c73648fafa4", "patch_ids": ["a4b7dbb55d7d3bbe61283e600002866c"], "statement_hash": "5d54fd95b6e6688ceb1d4b450a2f93e49d0cf69040901672dde206ab1063a68b", "relations": [], "version": "12.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "12.1-fe030c8bef799a16", "cves": [], "html": "Fix failure in pg_waldump with the -s option, when a continuation WAL record ends exactly at a page boundary (Andrey Lepikhov) §
In pg_waldump with the --bkp-details option, avoid emitting extra newlines for WAL records involving full-page writes (Andres Freund) §
Fix small memory leak in pg_waldump (Andres Freund) §
", "text": "Fix small memory leak in pg_waldump (Andres Freund) §", "title": "Fix small memory leak in pg_waldump", "commits": ["4ab353c47"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "a8a964575b9acfcd734a2bb7b8fc34fed5cb09fbd6728d76b855ca96923fe133", "section_path": ["Changes"], "commit_groups": [["4ab353c47", "95f2efd50", "af67aee69", "c3882f8b8", "e0f76f204", "e3ff8c360"]], "identity_text": "Fix small memory leak in pg_waldump (Andres Freund)", "commit_aliases": ["4ab353c47", "95f2efd50", "af67aee69", "c3882f8b8", "e0f76f204", "e3ff8c360"], "source_commits": ["4ab353c47"], "source_entry_id": "12.1/changes/046", "db_id": "bebccf73c4af811901025375ccdfbebd", "patch_ids": ["45bc406d2f100371b2941471e0b0b54e"], "statement_hash": "67fcd239598e1e156ee1c8a966633149eaaca4043e732f859d0dafb16f0a8513", "relations": [{"rule": 2, "type": "equivalent", "target": "004531c58099418b981264409ffab976", "evidence": {"same_day": true, "patch_ids": ["45bc406d2f100371b2941471e0b0b54e"], "statement_hash": "67fcd239598e1e156ee1c8a966633149eaaca4043e732f859d0dafb16f0a8513"}}, {"rule": 2, "type": "equivalent", "target": "1460ba3faf2cd8d16684769788c3075a", "evidence": {"same_day": true, "patch_ids": ["45bc406d2f100371b2941471e0b0b54e"], "statement_hash": "67fcd239598e1e156ee1c8a966633149eaaca4043e732f859d0dafb16f0a8513"}}, {"rule": 2, "type": "equivalent", "target": "3872e4058f1918ff68c2e88e1098e7b4", "evidence": {"same_day": true, "patch_ids": ["45bc406d2f100371b2941471e0b0b54e"], "statement_hash": "67fcd239598e1e156ee1c8a966633149eaaca4043e732f859d0dafb16f0a8513"}}, {"rule": 2, "type": "equivalent", "target": "b16a64bdaeba1cc341e7fd8a07edced3", "evidence": {"same_day": true, "patch_ids": ["45bc406d2f100371b2941471e0b0b54e"], "statement_hash": "67fcd239598e1e156ee1c8a966633149eaaca4043e732f859d0dafb16f0a8513"}}], "version": "12.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "1460ba3faf2cd8d16684769788c3075a", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix small memory leak in pg_waldump", "evidence": {"same_day": true, "patch_ids": ["45bc406d2f100371b2941471e0b0b54e"], "statement_hash": "67fcd239598e1e156ee1c8a966633149eaaca4043e732f859d0dafb16f0a8513"}, "url": "/docs/compare/?release=11.6#11.6-f2aba24c7e8edc21", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "3872e4058f1918ff68c2e88e1098e7b4", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Fix small memory leak in pg_waldump", "evidence": {"same_day": true, "patch_ids": ["45bc406d2f100371b2941471e0b0b54e"], "statement_hash": "67fcd239598e1e156ee1c8a966633149eaaca4043e732f859d0dafb16f0a8513"}, "url": "/docs/compare/?release=10.11#10.11-f2aba24c7e8edc21", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "b16a64bdaeba1cc341e7fd8a07edced3", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Fix small memory leak in pg_waldump", "evidence": {"same_day": true, "patch_ids": ["45bc406d2f100371b2941471e0b0b54e"], "statement_hash": "67fcd239598e1e156ee1c8a966633149eaaca4043e732f859d0dafb16f0a8513"}, "url": "/docs/compare/?release=9.6.16#9.6.16-f2aba24c7e8edc21", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "004531c58099418b981264409ffab976", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Fix small memory leak in pg_waldump", "evidence": {"same_day": true, "patch_ids": ["45bc406d2f100371b2941471e0b0b54e"], "statement_hash": "67fcd239598e1e156ee1c8a966633149eaaca4043e732f859d0dafb16f0a8513"}, "url": "/docs/compare/?release=9.5.20#9.5.20-f2aba24c7e8edc21", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "12.1-1d236a7f8e383809", "cves": [], "html": "Put back pqsignal() as an exported libpq symbol (Tom Lane) §
This function was removed on the grounds that no clients should be using it, but that turns out to break usage of current libpq with very old versions of psql, and perhaps other applications.
", "text": "Put back pqsignal() as an exported libpq symbol (Tom Lane) § This function was removed on the grounds that no clients should be using it, but that turns out to break usage of current libpq with very old versions of psql, and perhaps other applications.", "title": "Put back pqsignal() as an exported libpq symbol", "commits": ["7ed1bcaed"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "cbf347b4520f26010c324a15c07df73aafb9ac80f38d88fb583b290f41db9544", "section_path": ["Changes"], "commit_groups": [["06a367c38", "7ed1bcaed"]], "identity_text": "Put back pqsignal() as an exported libpq symbol (Tom Lane) This function was removed on the grounds that no clients should be using it, but that turns out to break usage of current libpq with very old versions of psql, and perhaps other applications.", "commit_aliases": ["06a367c38", "7ed1bcaed"], "source_commits": ["7ed1bcaed"], "source_entry_id": "12.1/changes/047", "db_id": "f46f478dae43046bf2685ae481352115", "patch_ids": ["538f3731929efb5ed7bd727ae693fd33"], "statement_hash": "98c939966fa696835f3fe337118b1f2416fc193500506bde5807ce95972a0466", "relations": [], "version": "12.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "12.1-99f6039b4eeef498", "cves": [], "html": "Fix configure's test for presence of libperl so that it works on recent Red Hat releases (Tom Lane) § §
\nPreviously, it could fail if the user sets CFLAGS to -O0.
Ensure correct code generation for spinlocks on PowerPC (Noah Misch) §
\nThe previous spinlock coding allowed the compiler to select register zero for use with an assembly instruction that does not accept that register, causing a build failure. We have seen only one long-ago report that matches this bug, but it could cause problems for people trying to build modified PostgreSQL code or use atypical compiler options.
", "text": "Ensure correct code generation for spinlocks on PowerPC (Noah Misch) § The previous spinlock coding allowed the compiler to select register zero for use with an assembly instruction that does not accept that register, causing a build failure. We have seen only one long-ago report that matches this bug, but it could cause problems for people trying to build modified PostgreSQL code or use atypical compiler options.", "title": "Ensure correct code generation for spinlocks on PowerPC", "commits": ["ef13f914e"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "b840ba13528d33cabe75db24cd72372d61abb1eda68b9ba69392255f328aacf9", "section_path": ["Changes"], "commit_groups": [["083929372", "09d74aef3", "62e881946", "89b4d7744", "930787c7f", "af4477b00", "ef13f914e"]], "identity_text": "Ensure correct code generation for spinlocks on PowerPC (Noah Misch) The previous spinlock coding allowed the compiler to select register zero for use with an assembly instruction that does not accept that register, causing a build failure. We have seen only one long-ago report that matches this bug, but it could cause problems for people trying to build modified PostgreSQL code or use atypical compiler options.", "commit_aliases": ["083929372", "09d74aef3", "62e881946", "89b4d7744", "930787c7f", "af4477b00", "ef13f914e"], "source_commits": ["ef13f914e"], "source_entry_id": "12.1/changes/049", "db_id": "30f686bb56c6183a946651745f6076b2", "patch_ids": ["9e49644de8f316d79e920bb5c0ebf3b5"], "statement_hash": "fdd4a033e7ba3da61f1339c7ba266b5f8e802311fc4b0c72df81a5ede463a994", "relations": [{"rule": 2, "type": "equivalent", "target": "2aa3efae39f2f031a040399699d14a89", "evidence": {"same_day": true, "patch_ids": ["9e49644de8f316d79e920bb5c0ebf3b5"], "statement_hash": "fdd4a033e7ba3da61f1339c7ba266b5f8e802311fc4b0c72df81a5ede463a994"}}, {"rule": 2, "type": "equivalent", "target": "2c2c8ac71213410432d41370129ec1b1", "evidence": {"same_day": true, "patch_ids": ["9e49644de8f316d79e920bb5c0ebf3b5"], "statement_hash": "fdd4a033e7ba3da61f1339c7ba266b5f8e802311fc4b0c72df81a5ede463a994"}}, {"rule": 2, "type": "equivalent", "target": "4f9266e65955529ae7ace087cf3c8721", "evidence": {"same_day": true, "patch_ids": ["9e49644de8f316d79e920bb5c0ebf3b5"], "statement_hash": "fdd4a033e7ba3da61f1339c7ba266b5f8e802311fc4b0c72df81a5ede463a994"}}, {"rule": 2, "type": "equivalent", "target": "7814bc4e330e8e50c0034a932fc6bed3", "evidence": {"same_day": true, "patch_ids": ["9e49644de8f316d79e920bb5c0ebf3b5"], "statement_hash": "fdd4a033e7ba3da61f1339c7ba266b5f8e802311fc4b0c72df81a5ede463a994"}}, {"rule": 2, "type": "equivalent", "target": "c4af76c82f44bec31f14ff0296b77b40", "evidence": {"same_day": true, "patch_ids": ["9e49644de8f316d79e920bb5c0ebf3b5"], "statement_hash": "fdd4a033e7ba3da61f1339c7ba266b5f8e802311fc4b0c72df81a5ede463a994"}}], "version": "12.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2aa3efae39f2f031a040399699d14a89", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Ensure correct code generation for spinlocks on PowerPC", "evidence": {"same_day": true, "patch_ids": ["9e49644de8f316d79e920bb5c0ebf3b5"], "statement_hash": "fdd4a033e7ba3da61f1339c7ba266b5f8e802311fc4b0c72df81a5ede463a994"}, "url": "/docs/compare/?release=11.6#11.6-4a277fab794acf32", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "7814bc4e330e8e50c0034a932fc6bed3", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Ensure correct code generation for spinlocks on PowerPC", "evidence": {"same_day": true, "patch_ids": ["9e49644de8f316d79e920bb5c0ebf3b5"], "statement_hash": "fdd4a033e7ba3da61f1339c7ba266b5f8e802311fc4b0c72df81a5ede463a994"}, "url": "/docs/compare/?release=10.11#10.11-4a277fab794acf32", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "c4af76c82f44bec31f14ff0296b77b40", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Ensure correct code generation for spinlocks on PowerPC", "evidence": {"same_day": true, "patch_ids": ["9e49644de8f316d79e920bb5c0ebf3b5"], "statement_hash": "fdd4a033e7ba3da61f1339c7ba266b5f8e802311fc4b0c72df81a5ede463a994"}, "url": "/docs/compare/?release=9.6.16#9.6.16-4a277fab794acf32", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "4f9266e65955529ae7ace087cf3c8721", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Ensure correct code generation for spinlocks on PowerPC", "evidence": {"same_day": true, "patch_ids": ["9e49644de8f316d79e920bb5c0ebf3b5"], "statement_hash": "fdd4a033e7ba3da61f1339c7ba266b5f8e802311fc4b0c72df81a5ede463a994"}, "url": "/docs/compare/?release=9.5.20#9.5.20-4a277fab794acf32", "source_url": "/docs/release/9.5.20/#AEN128082"}, {"db_id": "2c2c8ac71213410432d41370129ec1b1", "kind": "equivalent", "version": "9.4.25", "label": "9.4.25", "title": "Ensure correct code generation for spinlocks on PowerPC", "evidence": {"same_day": true, "patch_ids": ["9e49644de8f316d79e920bb5c0ebf3b5"], "statement_hash": "fdd4a033e7ba3da61f1339c7ba266b5f8e802311fc4b0c72df81a5ede463a994"}, "url": "/docs/compare/?release=9.4.25#9.4.25-4a277fab794acf32", "source_url": "/docs/release/9.4.25/#AEN119951"}]}, {"id": "12.1-95ff6454bde5ffe3", "cves": [], "html": "On AIX, don't use the compiler option -qsrcmsg (Noah Misch) §
This avoids an internal compiler error with xlc v16.1.0, with little consequence other than changing the format of compiler error messages.
", "text": "On AIX, don't use the compiler option -qsrcmsg (Noah Misch) § This avoids an internal compiler error with xlc v16.1.0, with little consequence other than changing the format of compiler error messages.", "title": "On AIX, don't use the compiler option -qsrcmsg", "commits": ["3fb14cfcb"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "b75905a63fb87b8b62863142f464ef6d1a2d3d4a87398ee02122a78e0ff721e1", "section_path": ["Changes"], "commit_groups": [["3fb14cfcb", "5f3d271d0", "77cc4a595", "b705582b4", "c73f4f680", "e40eb31c0", "e5b4926ef"]], "identity_text": "On AIX, don't use the compiler option -qsrcmsg (Noah Misch) This avoids an internal compiler error with xlc v16.1.0, with little consequence other than changing the format of compiler error messages.", "commit_aliases": ["3fb14cfcb", "5f3d271d0", "77cc4a595", "b705582b4", "c73f4f680", "e40eb31c0", "e5b4926ef"], "source_commits": ["3fb14cfcb"], "source_entry_id": "12.1/changes/050", "db_id": "5ff20ba9783100b29d6a950489beaf5c", "patch_ids": ["1599bea98b7d92f4dc430eb31aab3c06"], "statement_hash": "0435870f8b6f137509a3cee94109abae59caa3c0c4b218a4acb90dcba10d8b6c", "relations": [{"rule": 2, "type": "equivalent", "target": "416b05485065dc8bf461bb9a38cea5d5", "evidence": {"same_day": true, "patch_ids": ["1599bea98b7d92f4dc430eb31aab3c06"], "statement_hash": "0435870f8b6f137509a3cee94109abae59caa3c0c4b218a4acb90dcba10d8b6c"}}, {"rule": 2, "type": "equivalent", "target": "760aa42d630d7db3ee283c2c1bf4e8a4", "evidence": {"same_day": true, "patch_ids": ["1599bea98b7d92f4dc430eb31aab3c06"], "statement_hash": "0435870f8b6f137509a3cee94109abae59caa3c0c4b218a4acb90dcba10d8b6c"}}, {"rule": 2, "type": "equivalent", "target": "822c329930f6839fd4e003bb6199daad", "evidence": {"same_day": true, "patch_ids": ["1599bea98b7d92f4dc430eb31aab3c06"], "statement_hash": "0435870f8b6f137509a3cee94109abae59caa3c0c4b218a4acb90dcba10d8b6c"}}, {"rule": 2, "type": "equivalent", "target": "d96568514755bd9c64b47ceb2569ea10", "evidence": {"same_day": true, "patch_ids": ["1599bea98b7d92f4dc430eb31aab3c06"], "statement_hash": "0435870f8b6f137509a3cee94109abae59caa3c0c4b218a4acb90dcba10d8b6c"}}, {"rule": 2, "type": "equivalent", "target": "e1709c0b2254841b5b2e038b0d095cd0", "evidence": {"same_day": true, "patch_ids": ["1599bea98b7d92f4dc430eb31aab3c06"], "statement_hash": "0435870f8b6f137509a3cee94109abae59caa3c0c4b218a4acb90dcba10d8b6c"}}], "version": "12.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "e1709c0b2254841b5b2e038b0d095cd0", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "On AIX, don't use the compiler option -qsrcmsg", "evidence": {"same_day": true, "patch_ids": ["1599bea98b7d92f4dc430eb31aab3c06"], "statement_hash": "0435870f8b6f137509a3cee94109abae59caa3c0c4b218a4acb90dcba10d8b6c"}, "url": "/docs/compare/?release=11.6#11.6-c38156af66d97f9e", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "d96568514755bd9c64b47ceb2569ea10", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "On AIX, don't use the compiler option -qsrcmsg", "evidence": {"same_day": true, "patch_ids": ["1599bea98b7d92f4dc430eb31aab3c06"], "statement_hash": "0435870f8b6f137509a3cee94109abae59caa3c0c4b218a4acb90dcba10d8b6c"}, "url": "/docs/compare/?release=10.11#10.11-c38156af66d97f9e", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "822c329930f6839fd4e003bb6199daad", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "On AIX, don't use the compiler option -qsrcmsg", "evidence": {"same_day": true, "patch_ids": ["1599bea98b7d92f4dc430eb31aab3c06"], "statement_hash": "0435870f8b6f137509a3cee94109abae59caa3c0c4b218a4acb90dcba10d8b6c"}, "url": "/docs/compare/?release=9.6.16#9.6.16-c38156af66d97f9e", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "760aa42d630d7db3ee283c2c1bf4e8a4", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "On AIX, don't use the compiler option -qsrcmsg", "evidence": {"same_day": true, "patch_ids": ["1599bea98b7d92f4dc430eb31aab3c06"], "statement_hash": "0435870f8b6f137509a3cee94109abae59caa3c0c4b218a4acb90dcba10d8b6c"}, "url": "/docs/compare/?release=9.5.20#9.5.20-c38156af66d97f9e", "source_url": "/docs/release/9.5.20/#AEN128082"}, {"db_id": "416b05485065dc8bf461bb9a38cea5d5", "kind": "equivalent", "version": "9.4.25", "label": "9.4.25", "title": "On AIX, don't use the compiler option -qsrcmsg", "evidence": {"same_day": true, "patch_ids": ["1599bea98b7d92f4dc430eb31aab3c06"], "statement_hash": "0435870f8b6f137509a3cee94109abae59caa3c0c4b218a4acb90dcba10d8b6c"}, "url": "/docs/compare/?release=9.4.25#9.4.25-c38156af66d97f9e", "source_url": "/docs/release/9.4.25/#AEN119951"}]}, {"id": "12.1-e3ccc580f9073809", "cves": [], "html": "Fix MSVC build process to cope with spaces in the file path of OpenSSL (Andrew Dunstan) §
", "text": "Fix MSVC build process to cope with spaces in the file path of OpenSSL (Andrew Dunstan) §", "title": "Fix MSVC build process to cope with spaces in the file path of OpenSSL", "commits": ["ec38d2311"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/12.1/#id-1.11.6.27.5", "source_hash": "af641bb2864b7a0751b79315ad22e6610997e72b1b8d2d7acf66072fb7b4794e", "section_path": ["Changes"], "commit_groups": [["1e9a0487d", "3b9c22700", "62d2caed6", "6ca51b155", "8f8809091", "ad7595b89", "ec38d2311"]], "identity_text": "Fix MSVC build process to cope with spaces in the file path of OpenSSL (Andrew Dunstan)", "commit_aliases": ["1e9a0487d", "3b9c22700", "62d2caed6", "6ca51b155", "8f8809091", "ad7595b89", "ec38d2311"], "source_commits": ["ec38d2311"], "source_entry_id": "12.1/changes/051", "db_id": "928237d2a0d6a7f0f1d701177479ae8f", "patch_ids": ["26f1bde951b659e5d5df4cc603319c36"], "statement_hash": "6329ec64f2b04403d027d3c8f47f3500d7f507364e5a0b4c15a85144769fa607", "relations": [{"rule": 2, "type": "equivalent", "target": "0893554c398dc6e15ad4901312cba282", "evidence": {"same_day": true, "patch_ids": ["26f1bde951b659e5d5df4cc603319c36"], "statement_hash": "6329ec64f2b04403d027d3c8f47f3500d7f507364e5a0b4c15a85144769fa607"}}, {"rule": 2, "type": "equivalent", "target": "90f6af2221cf19865a9a78e940ca4f64", "evidence": {"same_day": true, "patch_ids": ["26f1bde951b659e5d5df4cc603319c36"], "statement_hash": "6329ec64f2b04403d027d3c8f47f3500d7f507364e5a0b4c15a85144769fa607"}}, {"rule": 2, "type": "equivalent", "target": "9e8d143fba38db76992300f11c8d84f9", "evidence": {"same_day": true, "patch_ids": ["26f1bde951b659e5d5df4cc603319c36"], "statement_hash": "6329ec64f2b04403d027d3c8f47f3500d7f507364e5a0b4c15a85144769fa607"}}, {"rule": 2, "type": "equivalent", "target": "a6f8353053480f849627a17f462805c4", "evidence": {"same_day": true, "patch_ids": ["26f1bde951b659e5d5df4cc603319c36"], "statement_hash": "6329ec64f2b04403d027d3c8f47f3500d7f507364e5a0b4c15a85144769fa607"}}, {"rule": 2, "type": "equivalent", "target": "b15b4c64c40679e329e5756bfde4fbd6", "evidence": {"same_day": true, "patch_ids": ["26f1bde951b659e5d5df4cc603319c36"], "statement_hash": "6329ec64f2b04403d027d3c8f47f3500d7f507364e5a0b4c15a85144769fa607"}}], "version": "12.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "0893554c398dc6e15ad4901312cba282", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix MSVC build process to cope with spaces in the file path of OpenSSL", "evidence": {"same_day": true, "patch_ids": ["26f1bde951b659e5d5df4cc603319c36"], "statement_hash": "6329ec64f2b04403d027d3c8f47f3500d7f507364e5a0b4c15a85144769fa607"}, "url": "/docs/compare/?release=11.6#11.6-e6f5b6f58d22adf5", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "90f6af2221cf19865a9a78e940ca4f64", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Fix MSVC build process to cope with spaces in the file path of OpenSSL", "evidence": {"same_day": true, "patch_ids": ["26f1bde951b659e5d5df4cc603319c36"], "statement_hash": "6329ec64f2b04403d027d3c8f47f3500d7f507364e5a0b4c15a85144769fa607"}, "url": "/docs/compare/?release=10.11#10.11-e6f5b6f58d22adf5", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "a6f8353053480f849627a17f462805c4", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Fix MSVC build process to cope with spaces in the file path of OpenSSL", "evidence": {"same_day": true, "patch_ids": ["26f1bde951b659e5d5df4cc603319c36"], "statement_hash": "6329ec64f2b04403d027d3c8f47f3500d7f507364e5a0b4c15a85144769fa607"}, "url": "/docs/compare/?release=9.6.16#9.6.16-e6f5b6f58d22adf5", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "9e8d143fba38db76992300f11c8d84f9", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Fix MSVC build process to cope with spaces in the file path of OpenSSL", "evidence": {"same_day": true, "patch_ids": ["26f1bde951b659e5d5df4cc603319c36"], "statement_hash": "6329ec64f2b04403d027d3c8f47f3500d7f507364e5a0b4c15a85144769fa607"}, "url": "/docs/compare/?release=9.5.20#9.5.20-e6f5b6f58d22adf5", "source_url": "/docs/release/9.5.20/#AEN128082"}, {"db_id": "b15b4c64c40679e329e5756bfde4fbd6", "kind": "equivalent", "version": "9.4.25", "label": "9.4.25", "title": "Fix MSVC build process to cope with spaces in the file path of OpenSSL", "evidence": {"same_day": true, "patch_ids": ["26f1bde951b659e5d5df4cc603319c36"], "statement_hash": "6329ec64f2b04403d027d3c8f47f3500d7f507364e5a0b4c15a85144769fa607"}, "url": "/docs/compare/?release=9.4.25#9.4.25-e6f5b6f58d22adf5", "source_url": "/docs/release/9.4.25/#AEN119951"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 51}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 24}, {"key": "security", "label": "Security", "count": 0}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 27}], "total": 51, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 51, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}