A dump/restore is not required for those running 9.4.X.
\nHowever, if you use the contrib/intarray extension with a GiST index, and you rely on indexed searches for the <@ operator, see the entry below about that.
\nAlso, if you are upgrading from a version earlier than 9.4.18, see Section E.9.
", "compatibility_count": 0, "label": "9.4.25", "status_label": "Historical", "eol": "2020-02-13", "age_days": 2511, "support_days": -2420}, "groups": [{"date": "2019-11-14", "build": "9.4.25", "major": "9.4", "minor": 25, "manual": "9.4", "status": "stable", "doc_git": "", "version": "9.4.25", "eol_date": "2020-02-13", "date_text": "2019-11-14", "supported": false, "manual_url": "/docs/9.4/release-9-4-25.html", "source_url": "/docs/release/9.4.25/", "entry_count": 39, "placeholder": false, "content_hash": "428317b5ff410a903fa6665344f72448e35d07a5346b01383f73df762c10390c", "manual_build": "9.4.26", "source_as_of": "", "changes_count": 39, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 9.4.X.
\nHowever, if you use the contrib/intarray extension with a GiST index, and you rely on indexed searches for the <@ operator, see the entry below about that.
\nAlso, if you are upgrading from a version earlier than 9.4.18, see Section E.9.
", "compatibility_count": 0, "label": "9.4.25", "status_label": "Historical", "eol": "2020-02-13", "age_days": 2511, "support_days": -2420, "entries": [{"id": "9.4.25-176af074558fa8d0", "cves": [], "html": "Prevent VACUUM from trying to freeze an old multixact ID involving a still-running transaction (Nathan Bossart, Jeremy Schneider)
\nThis case would lead to VACUUM failing until the old transaction terminates.
", "text": "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.", "title": "Prevent VACUUM from trying to freeze an old multixact ID involving a still-running transaction", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "89f33034a3f8064dcb522fc5467a9fa0acaa91fe43a08aebd64b732fbeba64ad", "section_path": ["Changes"], "commit_groups": [["0640f032a", "080cf32d2", "486a8f152", "583d86f92", "6bda2af03", "6f1e336de", "c1443eebe"]], "identity_text": "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.", "commit_aliases": ["0640f032a", "080cf32d2", "486a8f152", "583d86f92", "6bda2af03", "6f1e336de", "c1443eebe"], "source_commits": ["080cf32d2"], "source_entry_id": "9.4.25/changes/001", "db_id": "3a32e884c53d7d9d998e171b2c0fee41", "patch_ids": ["9311cce21ebf176e990d4c8797dc5f4f"], "statement_hash": "cbef18f9f36d7cfabe7071d45c459f38d2c5fba3bcd661c85f3cda95f35e2123", "relations": [{"rule": 2, "type": "equivalent", "target": "522a4efb8f7025b59c955d4981799d03", "evidence": {"same_day": true, "patch_ids": ["9311cce21ebf176e990d4c8797dc5f4f"], "statement_hash": "cbef18f9f36d7cfabe7071d45c459f38d2c5fba3bcd661c85f3cda95f35e2123"}}, {"rule": 2, "type": "equivalent", "target": "5c6d43c35ae888f0c0b29165ff45738e", "evidence": {"same_day": true, "patch_ids": ["9311cce21ebf176e990d4c8797dc5f4f"], "statement_hash": "cbef18f9f36d7cfabe7071d45c459f38d2c5fba3bcd661c85f3cda95f35e2123"}}, {"rule": 2, "type": "equivalent", "target": "6c8551b80cab90994547479c3079c61c", "evidence": {"same_day": true, "patch_ids": ["9311cce21ebf176e990d4c8797dc5f4f"], "statement_hash": "cbef18f9f36d7cfabe7071d45c459f38d2c5fba3bcd661c85f3cda95f35e2123"}}, {"rule": 2, "type": "equivalent", "target": "f9a8ec5b02182ced9ecb5f30c93601e4", "evidence": {"same_day": true, "patch_ids": ["9311cce21ebf176e990d4c8797dc5f4f"], "statement_hash": "cbef18f9f36d7cfabe7071d45c459f38d2c5fba3bcd661c85f3cda95f35e2123"}}, {"rule": 2, "type": "equivalent", "target": "fa826bc875c8ea5b61b9dd7da2abdb9e", "evidence": {"same_day": true, "patch_ids": ["9311cce21ebf176e990d4c8797dc5f4f"], "statement_hash": "cbef18f9f36d7cfabe7071d45c459f38d2c5fba3bcd661c85f3cda95f35e2123"}}], "version": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "5c6d43c35ae888f0c0b29165ff45738e", "kind": "equivalent", "version": "12.1", "label": "12.1", "title": "Prevent VACUUM from trying to freeze an old multixact ID involving a still-running transaction", "evidence": {"same_day": true, "patch_ids": ["9311cce21ebf176e990d4c8797dc5f4f"], "statement_hash": "cbef18f9f36d7cfabe7071d45c459f38d2c5fba3bcd661c85f3cda95f35e2123"}, "url": "/docs/compare/?release=12.1#12.1-03ce7d8051285d3a", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"db_id": "522a4efb8f7025b59c955d4981799d03", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Prevent VACUUM from trying to freeze an old multixact ID involving a still-running transaction", "evidence": {"same_day": true, "patch_ids": ["9311cce21ebf176e990d4c8797dc5f4f"], "statement_hash": "cbef18f9f36d7cfabe7071d45c459f38d2c5fba3bcd661c85f3cda95f35e2123"}, "url": "/docs/compare/?release=11.6#11.6-176af074558fa8d0", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "fa826bc875c8ea5b61b9dd7da2abdb9e", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Prevent VACUUM from trying to freeze an old multixact ID involving a still-running transaction", "evidence": {"same_day": true, "patch_ids": ["9311cce21ebf176e990d4c8797dc5f4f"], "statement_hash": "cbef18f9f36d7cfabe7071d45c459f38d2c5fba3bcd661c85f3cda95f35e2123"}, "url": "/docs/compare/?release=10.11#10.11-176af074558fa8d0", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "6c8551b80cab90994547479c3079c61c", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Prevent VACUUM from trying to freeze an old multixact ID involving a still-running transaction", "evidence": {"same_day": true, "patch_ids": ["9311cce21ebf176e990d4c8797dc5f4f"], "statement_hash": "cbef18f9f36d7cfabe7071d45c459f38d2c5fba3bcd661c85f3cda95f35e2123"}, "url": "/docs/compare/?release=9.6.16#9.6.16-176af074558fa8d0", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "f9a8ec5b02182ced9ecb5f30c93601e4", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Prevent VACUUM from trying to freeze an old multixact ID involving a still-running transaction", "evidence": {"same_day": true, "patch_ids": ["9311cce21ebf176e990d4c8797dc5f4f"], "statement_hash": "cbef18f9f36d7cfabe7071d45c459f38d2c5fba3bcd661c85f3cda95f35e2123"}, "url": "/docs/compare/?release=9.5.20#9.5.20-176af074558fa8d0", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-13a4ad410ef361d3", "cves": [], "html": "Ensure that offset expressions in WINDOW clauses are processed when a query's expressions are manipulated (Andrew Gierth)
\nThis 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": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "383076da8651ea4ff9988899cd825b675a93c8ebdfd5a26ebf1107444eb5883e", "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": ["3473f81dd"], "source_entry_id": "9.4.25/changes/002", "db_id": "786a8eb68b27a6e848bfa72505a70b7b", "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": "87328496fe1ff4fe1e4cba6a35b8ff0e", "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": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "87328496fe1ff4fe1e4cba6a35b8ff0e", "kind": "equivalent", "version": "12.1", "label": "12.1", "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=12.1#12.1-119d50d0f6cf35b0", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"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"}]}, {"id": "9.4.25-b0f1a7681ca340c2", "cves": [], "html": "Fix handling of whole-row variables in WITH CHECK OPTION expressions and row-level-security policy expressions (Andres Freund)
\nPreviously, such usage might result in bogus errors about row type mismatches.
", "text": "Fix handling of whole-row variables in WITH CHECK OPTION expressions and row-level-security policy expressions (Andres Freund) Previously, such usage might result in bogus errors about row type mismatches.", "title": "Fix handling of whole-row variables in WITH CHECK OPTION expressions and row-level-security policy expressions", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "f3d308526a9653243c7df3d8cf577d4fba87a87c22b425040492cadd4757fa94", "section_path": ["Changes"], "commit_groups": [["5e9b18c78", "64d926f2b", "7f1f72c44", "aee5736f1", "b00132b9a", "b54cff2bf", "ca08ea52b"]], "identity_text": "Fix handling of whole-row variables in WITH CHECK OPTION expressions and row-level-security policy expressions (Andres Freund) Previously, such usage might result in bogus errors about row type mismatches.", "commit_aliases": ["5e9b18c78", "64d926f2b", "7f1f72c44", "aee5736f1", "b00132b9a", "b54cff2bf", "ca08ea52b"], "source_commits": ["ca08ea52b"], "source_entry_id": "9.4.25/changes/003", "db_id": "868013cfe87035bbb5e7e345fe7c7381", "patch_ids": ["eeff3aa8652467d6281ff77b8af22202"], "statement_hash": "0c297fc54fffed4bf901232ed4705af8f39907e1be087886adb9261df306853e", "relations": [{"rule": 2, "type": "equivalent", "target": "1ab3960ee0900882f2cc8d92c915ca7d", "evidence": {"same_day": true, "patch_ids": ["eeff3aa8652467d6281ff77b8af22202"], "statement_hash": "0c297fc54fffed4bf901232ed4705af8f39907e1be087886adb9261df306853e"}}, {"rule": 2, "type": "equivalent", "target": "24721a984f434daa6930df0de10a11f7", "evidence": {"same_day": true, "patch_ids": ["eeff3aa8652467d6281ff77b8af22202"], "statement_hash": "0c297fc54fffed4bf901232ed4705af8f39907e1be087886adb9261df306853e"}}, {"rule": 2, "type": "equivalent", "target": "31a9b445a9d3e78e0aff6ecc4d55e21a", "evidence": {"same_day": true, "patch_ids": ["eeff3aa8652467d6281ff77b8af22202"], "statement_hash": "0c297fc54fffed4bf901232ed4705af8f39907e1be087886adb9261df306853e"}}, {"rule": 2, "type": "equivalent", "target": "5c5790a7fa07258e86ce0fe8fe68ec63", "evidence": {"same_day": true, "patch_ids": ["eeff3aa8652467d6281ff77b8af22202"], "statement_hash": "0c297fc54fffed4bf901232ed4705af8f39907e1be087886adb9261df306853e"}}], "version": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "24721a984f434daa6930df0de10a11f7", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix handling of whole-row variables in WITH CHECK OPTION expressions and row-level-security policy expressions", "evidence": {"same_day": true, "patch_ids": ["eeff3aa8652467d6281ff77b8af22202"], "statement_hash": "0c297fc54fffed4bf901232ed4705af8f39907e1be087886adb9261df306853e"}, "url": "/docs/compare/?release=11.6#11.6-b0f1a7681ca340c2", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "31a9b445a9d3e78e0aff6ecc4d55e21a", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Fix handling of whole-row variables in WITH CHECK OPTION expressions and row-level-security policy expressions", "evidence": {"same_day": true, "patch_ids": ["eeff3aa8652467d6281ff77b8af22202"], "statement_hash": "0c297fc54fffed4bf901232ed4705af8f39907e1be087886adb9261df306853e"}, "url": "/docs/compare/?release=10.11#10.11-b0f1a7681ca340c2", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "1ab3960ee0900882f2cc8d92c915ca7d", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Fix handling of whole-row variables in WITH CHECK OPTION expressions and row-level-security policy expressions", "evidence": {"same_day": true, "patch_ids": ["eeff3aa8652467d6281ff77b8af22202"], "statement_hash": "0c297fc54fffed4bf901232ed4705af8f39907e1be087886adb9261df306853e"}, "url": "/docs/compare/?release=9.6.16#9.6.16-b0f1a7681ca340c2", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "5c5790a7fa07258e86ce0fe8fe68ec63", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Fix handling of whole-row variables in WITH CHECK OPTION expressions and row-level-security policy expressions", "evidence": {"same_day": true, "patch_ids": ["eeff3aa8652467d6281ff77b8af22202"], "statement_hash": "0c297fc54fffed4bf901232ed4705af8f39907e1be087886adb9261df306853e"}, "url": "/docs/compare/?release=9.5.20#9.5.20-b0f1a7681ca340c2", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-44fdfd958ed79908", "cves": [], "html": "Prevent possible double-free if a BEFORE UPDATE trigger returns the old tuple as-is, and it is not the last such trigger (Thomas Munro)
", "text": "Prevent possible double-free if a BEFORE UPDATE trigger returns the old tuple as-is, and it is not the last such trigger (Thomas Munro)", "title": "Prevent possible double-free if a BEFORE UPDATE trigger returns the old tuple as-is, and it is not the last such trigger", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "508164751652932620cbc963ccfc22a3af316af1deee03cc9d3e9e03e4646532", "section_path": ["Changes"], "commit_groups": [["03813a50e", "1ced082b9", "1fe8d209e", "60886965a", "aed967d69", "afa71d915", "cb0c79ae6"]], "identity_text": "Prevent possible double-free if a BEFORE UPDATE trigger returns the old tuple as-is, and it is not the last such trigger (Thomas Munro)", "commit_aliases": ["03813a50e", "1ced082b9", "1fe8d209e", "60886965a", "aed967d69", "afa71d915", "cb0c79ae6"], "source_commits": ["afa71d915"], "source_entry_id": "9.4.25/changes/004", "db_id": "f510b34b7d7b94340b025b5052b1f32f", "patch_ids": ["d276484a01556c3f5b9020bb4c178357"], "statement_hash": "20b88f9bb0f73e7d8437e8515f90daaba87126353f0859efca58966a23a76993", "relations": [{"rule": 2, "type": "equivalent", "target": "46df80f582a21228ddc984e055480492", "evidence": {"same_day": true, "patch_ids": ["d276484a01556c3f5b9020bb4c178357"], "statement_hash": "20b88f9bb0f73e7d8437e8515f90daaba87126353f0859efca58966a23a76993"}}, {"rule": 2, "type": "equivalent", "target": "49b4ce39a0e2802530d61bec2baddb7f", "evidence": {"same_day": true, "patch_ids": ["d276484a01556c3f5b9020bb4c178357"], "statement_hash": "20b88f9bb0f73e7d8437e8515f90daaba87126353f0859efca58966a23a76993"}}, {"rule": 2, "type": "equivalent", "target": "65587701cba227ebaaafe70e227c5cd3", "evidence": {"same_day": true, "patch_ids": ["d276484a01556c3f5b9020bb4c178357"], "statement_hash": "20b88f9bb0f73e7d8437e8515f90daaba87126353f0859efca58966a23a76993"}}, {"rule": 2, "type": "equivalent", "target": "a743e90ea3933afa52603f8108e08d01", "evidence": {"same_day": true, "patch_ids": ["d276484a01556c3f5b9020bb4c178357"], "statement_hash": "20b88f9bb0f73e7d8437e8515f90daaba87126353f0859efca58966a23a76993"}}], "version": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "a743e90ea3933afa52603f8108e08d01", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Prevent possible double-free if a BEFORE UPDATE trigger returns the old tuple as-is, and it is not the last such trigger", "evidence": {"same_day": true, "patch_ids": ["d276484a01556c3f5b9020bb4c178357"], "statement_hash": "20b88f9bb0f73e7d8437e8515f90daaba87126353f0859efca58966a23a76993"}, "url": "/docs/compare/?release=11.6#11.6-44fdfd958ed79908", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "46df80f582a21228ddc984e055480492", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Prevent possible double-free if a BEFORE UPDATE trigger returns the old tuple as-is, and it is not the last such trigger", "evidence": {"same_day": true, "patch_ids": ["d276484a01556c3f5b9020bb4c178357"], "statement_hash": "20b88f9bb0f73e7d8437e8515f90daaba87126353f0859efca58966a23a76993"}, "url": "/docs/compare/?release=10.11#10.11-44fdfd958ed79908", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "65587701cba227ebaaafe70e227c5cd3", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Prevent possible double-free if a BEFORE UPDATE trigger returns the old tuple as-is, and it is not the last such trigger", "evidence": {"same_day": true, "patch_ids": ["d276484a01556c3f5b9020bb4c178357"], "statement_hash": "20b88f9bb0f73e7d8437e8515f90daaba87126353f0859efca58966a23a76993"}, "url": "/docs/compare/?release=9.6.16#9.6.16-44fdfd958ed79908", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "49b4ce39a0e2802530d61bec2baddb7f", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Prevent possible double-free if a BEFORE UPDATE trigger returns the old tuple as-is, and it is not the last such trigger", "evidence": {"same_day": true, "patch_ids": ["d276484a01556c3f5b9020bb4c178357"], "statement_hash": "20b88f9bb0f73e7d8437e8515f90daaba87126353f0859efca58966a23a76993"}, "url": "/docs/compare/?release=9.5.20#9.5.20-44fdfd958ed79908", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-6af43d5ff4ff01ab", "cves": [], "html": "In serializable mode, ensure that row-level predicate locks are acquired on the correct version of the row (Thomas Munro, Heikki Linnakangas)
\nIf the visible version of the row is HOT-updated, the lock might be taken on its now-dead predecessor, resulting in subtle failures to guarantee serialization.
", "text": "In serializable mode, ensure that row-level predicate locks are acquired on the correct version of the row (Thomas Munro, Heikki Linnakangas) If the visible version of the row is HOT-updated, the lock might be taken on its now-dead predecessor, resulting in subtle failures to guarantee serialization.", "title": "In serializable mode, ensure that row-level predicate locks are acquired on the correct version of the row", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "0bca15d9e1008f49f78ddffd79d88c987fc6b1612f85e0408385628c8da01aee", "section_path": ["Changes"], "commit_groups": [["1169fcf12", "54c98fa71", "65468cc70", "75774cc22", "c5b796125", "f8d30182b", "fd298cd63"]], "identity_text": "In serializable mode, ensure that row-level predicate locks are acquired on the correct version of the row (Thomas Munro, Heikki Linnakangas) If the visible version of the row is HOT-updated, the lock might be taken on its now-dead predecessor, resulting in subtle failures to guarantee serialization.", "commit_aliases": ["1169fcf12", "54c98fa71", "65468cc70", "75774cc22", "c5b796125", "f8d30182b", "fd298cd63"], "source_commits": ["54c98fa71"], "source_entry_id": "9.4.25/changes/005", "db_id": "95dcd349ba1930c83ec31b31588a8608", "patch_ids": ["29f5bb509abaf651c6215efbaec834d4"], "statement_hash": "df42f17a722ff99a9ca75abbfa3cf1f7481359fe046366c4b777280bc8d81747", "relations": [{"rule": 2, "type": "equivalent", "target": "087c41a2e014444b7825712e6389481c", "evidence": {"same_day": true, "patch_ids": ["29f5bb509abaf651c6215efbaec834d4"], "statement_hash": "df42f17a722ff99a9ca75abbfa3cf1f7481359fe046366c4b777280bc8d81747"}}, {"rule": 2, "type": "equivalent", "target": "0e4e152032c826b8e9e4668aff0d6d14", "evidence": {"same_day": true, "patch_ids": ["29f5bb509abaf651c6215efbaec834d4"], "statement_hash": "df42f17a722ff99a9ca75abbfa3cf1f7481359fe046366c4b777280bc8d81747"}}, {"rule": 2, "type": "equivalent", "target": "30d1dc9a1eb4cbf83f7ef73adedf7d1e", "evidence": {"same_day": true, "patch_ids": ["29f5bb509abaf651c6215efbaec834d4"], "statement_hash": "df42f17a722ff99a9ca75abbfa3cf1f7481359fe046366c4b777280bc8d81747"}}, {"rule": 2, "type": "equivalent", "target": "c094bd6bd96b20452d2deeb24e56908b", "evidence": {"same_day": true, "patch_ids": ["29f5bb509abaf651c6215efbaec834d4"], "statement_hash": "df42f17a722ff99a9ca75abbfa3cf1f7481359fe046366c4b777280bc8d81747"}}], "version": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "087c41a2e014444b7825712e6389481c", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "In serializable mode, ensure that row-level predicate locks are acquired on the correct version of the row", "evidence": {"same_day": true, "patch_ids": ["29f5bb509abaf651c6215efbaec834d4"], "statement_hash": "df42f17a722ff99a9ca75abbfa3cf1f7481359fe046366c4b777280bc8d81747"}, "url": "/docs/compare/?release=11.6#11.6-6af43d5ff4ff01ab", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "30d1dc9a1eb4cbf83f7ef73adedf7d1e", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "In serializable mode, ensure that row-level predicate locks are acquired on the correct version of the row", "evidence": {"same_day": true, "patch_ids": ["29f5bb509abaf651c6215efbaec834d4"], "statement_hash": "df42f17a722ff99a9ca75abbfa3cf1f7481359fe046366c4b777280bc8d81747"}, "url": "/docs/compare/?release=10.11#10.11-6af43d5ff4ff01ab", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "0e4e152032c826b8e9e4668aff0d6d14", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "In serializable mode, ensure that row-level predicate locks are acquired on the correct version of the row", "evidence": {"same_day": true, "patch_ids": ["29f5bb509abaf651c6215efbaec834d4"], "statement_hash": "df42f17a722ff99a9ca75abbfa3cf1f7481359fe046366c4b777280bc8d81747"}, "url": "/docs/compare/?release=9.6.16#9.6.16-6af43d5ff4ff01ab", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "c094bd6bd96b20452d2deeb24e56908b", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "In serializable mode, ensure that row-level predicate locks are acquired on the correct version of the row", "evidence": {"same_day": true, "patch_ids": ["29f5bb509abaf651c6215efbaec834d4"], "statement_hash": "df42f17a722ff99a9ca75abbfa3cf1f7481359fe046366c4b777280bc8d81747"}, "url": "/docs/compare/?release=9.5.20#9.5.20-6af43d5ff4ff01ab", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-80b41c21e0d7a114", "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": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "c1520aab6ffa2a84778c59e069ffd3471464372e3249b8275d3a944c4ad764b3", "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": ["59800f7ce", "a586cc4b6"], "source_entry_id": "9.4.25/changes/006", "db_id": "b8e91545f28e39be358c8cb0aaccd1ce", "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": "73b65c3ca0a98f2f47a92ac14c9892a1", "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"}}], "version": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "73b65c3ca0a98f2f47a92ac14c9892a1", "kind": "equivalent", "version": "12.1", "label": "12.1", "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=12.1#12.1-379b4a761effb552", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"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"}]}, {"id": "9.4.25-b3487e0244bd1678", "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": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "de3717113daaaa5502dcf197f12ec4e810c9f0a4d1fbc7645cc6f8d79ec1ebf6", "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": ["6899be289"], "source_entry_id": "9.4.25/changes/007", "db_id": "875c0e4587609f405ccd5ffcf2b36ab2", "patch_ids": ["b59620aadb07a202a61119308e8705a3"], "statement_hash": "b00eedd46ac4216a9af5fe4a43bee7c45f6a7ba75da45a47d3da02bd1b18554a", "relations": [{"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": "e4b440de56d261ffc7855ea4fab821a0", "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": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "e4b440de56d261ffc7855ea4fab821a0", "kind": "equivalent", "version": "12.1", "label": "12.1", "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=12.1#12.1-4a8deb84dc97eccf", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"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"}]}, {"id": "9.4.25-d20bf1989ae9d504", "cves": [], "html": "Allow repalloc() to give back space when a large chunk is reduced in size (Tom Lane)
Avoid failure in archive recovery if recovery_min_apply_delay is enabled (Fujii Masao)
\nrecovery_min_apply_delay is not typically used in this configuration, but it should work.
", "text": "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.", "title": "Avoid failure in archive recovery if recovery_min_apply_delay is enabled", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "1e6b5f70f58911715084729feed94fcd58bb0f0308850e2c09cc3970a114a4c8", "section_path": ["Changes"], "commit_groups": [["14c59185b", "1b2ba8874", "579996bc2", "9dfbf9a04", "c455ee88c", "ec1259e88", "f7b70700b"]], "identity_text": "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.", "commit_aliases": ["14c59185b", "1b2ba8874", "579996bc2", "9dfbf9a04", "c455ee88c", "ec1259e88", "f7b70700b"], "source_commits": ["14c59185b"], "source_entry_id": "9.4.25/changes/009", "db_id": "5351f22144da31bd09273d698e148e9d", "patch_ids": ["e75885c6d2c42369afc35699bb66a795"], "statement_hash": "09f824fa7d7bbaa0a16df6a4623ac4b9ffa8763b9d5fa689d28fd9957afa50e8", "relations": [{"rule": 2, "type": "equivalent", "target": "2c676ad7ae5a140c73c5484e2a474f97", "evidence": {"same_day": true, "patch_ids": ["e75885c6d2c42369afc35699bb66a795"], "statement_hash": "09f824fa7d7bbaa0a16df6a4623ac4b9ffa8763b9d5fa689d28fd9957afa50e8"}}, {"rule": 2, "type": "equivalent", "target": "78eba3ce05625f4d39ef243ce787088e", "evidence": {"same_day": true, "patch_ids": ["e75885c6d2c42369afc35699bb66a795"], "statement_hash": "09f824fa7d7bbaa0a16df6a4623ac4b9ffa8763b9d5fa689d28fd9957afa50e8"}}, {"rule": 2, "type": "equivalent", "target": "86fe720617b772ba68ec054d99e2c4fb", "evidence": {"same_day": true, "patch_ids": ["e75885c6d2c42369afc35699bb66a795"], "statement_hash": "09f824fa7d7bbaa0a16df6a4623ac4b9ffa8763b9d5fa689d28fd9957afa50e8"}}, {"rule": 2, "type": "equivalent", "target": "fa558941bd8859034c26a7e06f232001", "evidence": {"same_day": true, "patch_ids": ["e75885c6d2c42369afc35699bb66a795"], "statement_hash": "09f824fa7d7bbaa0a16df6a4623ac4b9ffa8763b9d5fa689d28fd9957afa50e8"}}, {"rule": 2, "type": "equivalent", "target": "fd6bbf706f57582b1c80a0dc91d956ac", "evidence": {"same_day": true, "patch_ids": ["e75885c6d2c42369afc35699bb66a795"], "statement_hash": "09f824fa7d7bbaa0a16df6a4623ac4b9ffa8763b9d5fa689d28fd9957afa50e8"}}], "version": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "fa558941bd8859034c26a7e06f232001", "kind": "equivalent", "version": "12.1", "label": "12.1", "title": "Avoid failure in archive recovery if recovery_min_apply_delay is enabled", "evidence": {"same_day": true, "patch_ids": ["e75885c6d2c42369afc35699bb66a795"], "statement_hash": "09f824fa7d7bbaa0a16df6a4623ac4b9ffa8763b9d5fa689d28fd9957afa50e8"}, "url": "/docs/compare/?release=12.1#12.1-f78af228a28346b5", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"db_id": "fd6bbf706f57582b1c80a0dc91d956ac", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Avoid failure in archive recovery if recovery_min_apply_delay is enabled", "evidence": {"same_day": true, "patch_ids": ["e75885c6d2c42369afc35699bb66a795"], "statement_hash": "09f824fa7d7bbaa0a16df6a4623ac4b9ffa8763b9d5fa689d28fd9957afa50e8"}, "url": "/docs/compare/?release=11.6#11.6-8249b374acc73f3b", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "86fe720617b772ba68ec054d99e2c4fb", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Avoid failure in archive recovery if recovery_min_apply_delay is enabled", "evidence": {"same_day": true, "patch_ids": ["e75885c6d2c42369afc35699bb66a795"], "statement_hash": "09f824fa7d7bbaa0a16df6a4623ac4b9ffa8763b9d5fa689d28fd9957afa50e8"}, "url": "/docs/compare/?release=10.11#10.11-8249b374acc73f3b", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "78eba3ce05625f4d39ef243ce787088e", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Avoid failure in archive recovery if recovery_min_apply_delay is enabled", "evidence": {"same_day": true, "patch_ids": ["e75885c6d2c42369afc35699bb66a795"], "statement_hash": "09f824fa7d7bbaa0a16df6a4623ac4b9ffa8763b9d5fa689d28fd9957afa50e8"}, "url": "/docs/compare/?release=9.6.16#9.6.16-8249b374acc73f3b", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "2c676ad7ae5a140c73c5484e2a474f97", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Avoid failure in archive recovery if recovery_min_apply_delay is enabled", "evidence": {"same_day": true, "patch_ids": ["e75885c6d2c42369afc35699bb66a795"], "statement_hash": "09f824fa7d7bbaa0a16df6a4623ac4b9ffa8763b9d5fa689d28fd9957afa50e8"}, "url": "/docs/compare/?release=9.5.20#9.5.20-8249b374acc73f3b", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-69af6e903109ae8f", "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": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "39ada89efcd4c1066af22647c7f057ed0c4ccb2ce1c12ad025738d7d6ba6473b", "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": ["abd5071d2"], "source_entry_id": "9.4.25/changes/010", "db_id": "55db924fa4a72e2667fcd540c5f2ad31", "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": "823d796e301349805ab4d2ac9acbc490", "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": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "823d796e301349805ab4d2ac9acbc490", "kind": "equivalent", "version": "12.1", "label": "12.1", "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=12.1#12.1-9156f4650864dbe2", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"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"}]}, {"id": "9.4.25-e0d0ee5a35a08941", "cves": [], "html": "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.
", "text": "Correctly time-stamp replication messages for logical decoding (Jeff Janes) This oversight resulted, for example, in pg_stat_subscription.last_msg_send_time usually reading as NULL.", "title": "Correctly time-stamp replication messages for logical decoding", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "77964884e5d4422f97f6d2af329940dc24d6d369458340e33dab5cc18fcb3a4b", "section_path": ["Changes"], "commit_groups": [["15d90a02a", "16b43e091", "404d25f3c", "5f6b1eb0c", "9ae4bdadf", "cb6d7f985", "f7b0d0704"]], "identity_text": "Correctly time-stamp replication messages for logical decoding (Jeff Janes) This oversight resulted, for example, in pg_stat_subscription.last_msg_send_time usually reading as NULL.", "commit_aliases": ["15d90a02a", "16b43e091", "404d25f3c", "5f6b1eb0c", "9ae4bdadf", "cb6d7f985", "f7b0d0704"], "source_commits": ["15d90a02a"], "source_entry_id": "9.4.25/changes/011", "db_id": "7021c91f732261c9b0c2649153458065", "patch_ids": ["5b20656ac352ea2c7191a936062f6972"], "statement_hash": "c19a57cff82ca689249668b69a120e07040fa5792d96387c02e4fccd81d6d892", "relations": [{"rule": 2, "type": "equivalent", "target": "0b271fea6b0974ce6a01e39336dca929", "evidence": {"same_day": true, "patch_ids": ["5b20656ac352ea2c7191a936062f6972"], "statement_hash": "c19a57cff82ca689249668b69a120e07040fa5792d96387c02e4fccd81d6d892"}}, {"rule": 2, "type": "equivalent", "target": "162cf51033c717d6a9cc67ff386a5c57", "evidence": {"same_day": true, "patch_ids": ["5b20656ac352ea2c7191a936062f6972"], "statement_hash": "c19a57cff82ca689249668b69a120e07040fa5792d96387c02e4fccd81d6d892"}}, {"rule": 2, "type": "equivalent", "target": "3446fe6e4dee75dc2a6d3a7e1185dab1", "evidence": {"same_day": true, "patch_ids": ["5b20656ac352ea2c7191a936062f6972"], "statement_hash": "c19a57cff82ca689249668b69a120e07040fa5792d96387c02e4fccd81d6d892"}}, {"rule": 2, "type": "equivalent", "target": "3be07536ad9b2277d140c94c222b41c7", "evidence": {"same_day": true, "patch_ids": ["5b20656ac352ea2c7191a936062f6972"], "statement_hash": "c19a57cff82ca689249668b69a120e07040fa5792d96387c02e4fccd81d6d892"}}, {"rule": 2, "type": "equivalent", "target": "40cdffee03547d5befa5bcd7dabc89c3", "evidence": {"same_day": true, "patch_ids": ["5b20656ac352ea2c7191a936062f6972"], "statement_hash": "c19a57cff82ca689249668b69a120e07040fa5792d96387c02e4fccd81d6d892"}}], "version": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "3be07536ad9b2277d140c94c222b41c7", "kind": "equivalent", "version": "12.1", "label": "12.1", "title": "Correctly time-stamp replication messages for logical decoding", "evidence": {"same_day": true, "patch_ids": ["5b20656ac352ea2c7191a936062f6972"], "statement_hash": "c19a57cff82ca689249668b69a120e07040fa5792d96387c02e4fccd81d6d892"}, "url": "/docs/compare/?release=12.1#12.1-54e8617fa635fc6d", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"db_id": "40cdffee03547d5befa5bcd7dabc89c3", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Correctly time-stamp replication messages for logical decoding", "evidence": {"same_day": true, "patch_ids": ["5b20656ac352ea2c7191a936062f6972"], "statement_hash": "c19a57cff82ca689249668b69a120e07040fa5792d96387c02e4fccd81d6d892"}, "url": "/docs/compare/?release=11.6#11.6-e0d0ee5a35a08941", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "162cf51033c717d6a9cc67ff386a5c57", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Correctly time-stamp replication messages for logical decoding", "evidence": {"same_day": true, "patch_ids": ["5b20656ac352ea2c7191a936062f6972"], "statement_hash": "c19a57cff82ca689249668b69a120e07040fa5792d96387c02e4fccd81d6d892"}, "url": "/docs/compare/?release=10.11#10.11-e0d0ee5a35a08941", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "0b271fea6b0974ce6a01e39336dca929", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Correctly time-stamp replication messages for logical decoding", "evidence": {"same_day": true, "patch_ids": ["5b20656ac352ea2c7191a936062f6972"], "statement_hash": "c19a57cff82ca689249668b69a120e07040fa5792d96387c02e4fccd81d6d892"}, "url": "/docs/compare/?release=9.6.16#9.6.16-e0d0ee5a35a08941", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "3446fe6e4dee75dc2a6d3a7e1185dab1", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Correctly time-stamp replication messages for logical decoding", "evidence": {"same_day": true, "patch_ids": ["5b20656ac352ea2c7191a936062f6972"], "statement_hash": "c19a57cff82ca689249668b69a120e07040fa5792d96387c02e4fccd81d6d892"}, "url": "/docs/compare/?release=9.5.20#9.5.20-e0d0ee5a35a08941", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-1e149c1d850251ba", "cves": [], "html": "In logical decoding, ensure that sub-transactions are correctly accounted for when reconstructing a snapshot (Masahiko Sawada)
\nThis error leads to assertion failures; it's unclear whether any bad effects exist in production builds.
", "text": "In logical decoding, ensure that sub-transactions are correctly accounted for when reconstructing a snapshot (Masahiko Sawada) This error leads to assertion failures; it's unclear whether any bad effects exist in production builds.", "title": "In logical decoding, ensure that sub-transactions are correctly accounted for when reconstructing a snapshot", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "e863bca5d99e1fa12bfeefb9cab1242196fdbd5c1b039223829f68094dc94b56", "section_path": ["Changes"], "commit_groups": [["41f3d2626", "4f7dbf0ef", "7110f5c37", "96b5033e1", "ae4305f6d", "bac2fae05", "e8c7f40a1"]], "identity_text": "In logical decoding, ensure that sub-transactions are correctly accounted for when reconstructing a snapshot (Masahiko Sawada) This error leads to assertion failures; it's unclear whether any bad effects exist in production builds.", "commit_aliases": ["41f3d2626", "4f7dbf0ef", "7110f5c37", "96b5033e1", "ae4305f6d", "bac2fae05", "e8c7f40a1"], "source_commits": ["e8c7f40a1"], "source_entry_id": "9.4.25/changes/012", "db_id": "847bd0659d336f51389845f32708b1d5", "patch_ids": ["fedd14b16b61b06734d4f9b28bfc73c9"], "statement_hash": "f92c06454d4721287e52c538bb94202f5d912046aa15d37effc654899bd7b877", "relations": [{"rule": 2, "type": "equivalent", "target": "308e8ab67fc3974e5084f6aaa6b32c05", "evidence": {"same_day": true, "patch_ids": ["fedd14b16b61b06734d4f9b28bfc73c9"], "statement_hash": "f92c06454d4721287e52c538bb94202f5d912046aa15d37effc654899bd7b877"}}, {"rule": 2, "type": "equivalent", "target": "89557742c12809d014ad8c2b12d791fc", "evidence": {"same_day": true, "patch_ids": ["fedd14b16b61b06734d4f9b28bfc73c9"], "statement_hash": "f92c06454d4721287e52c538bb94202f5d912046aa15d37effc654899bd7b877"}}, {"rule": 2, "type": "equivalent", "target": "b086d67e28041e0fc0f494c505cb6831", "evidence": {"same_day": true, "patch_ids": ["fedd14b16b61b06734d4f9b28bfc73c9"], "statement_hash": "f92c06454d4721287e52c538bb94202f5d912046aa15d37effc654899bd7b877"}}, {"rule": 2, "type": "equivalent", "target": "c07a34db8f6cc31294fe8e4cb76242d0", "evidence": {"same_day": true, "patch_ids": ["fedd14b16b61b06734d4f9b28bfc73c9"], "statement_hash": "f92c06454d4721287e52c538bb94202f5d912046aa15d37effc654899bd7b877"}}], "version": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b086d67e28041e0fc0f494c505cb6831", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "In logical decoding, ensure that sub-transactions are correctly accounted for when reconstructing a snapshot", "evidence": {"same_day": true, "patch_ids": ["fedd14b16b61b06734d4f9b28bfc73c9"], "statement_hash": "f92c06454d4721287e52c538bb94202f5d912046aa15d37effc654899bd7b877"}, "url": "/docs/compare/?release=11.6#11.6-1e149c1d850251ba", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "c07a34db8f6cc31294fe8e4cb76242d0", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "In logical decoding, ensure that sub-transactions are correctly accounted for when reconstructing a snapshot", "evidence": {"same_day": true, "patch_ids": ["fedd14b16b61b06734d4f9b28bfc73c9"], "statement_hash": "f92c06454d4721287e52c538bb94202f5d912046aa15d37effc654899bd7b877"}, "url": "/docs/compare/?release=10.11#10.11-1e149c1d850251ba", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "308e8ab67fc3974e5084f6aaa6b32c05", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "In logical decoding, ensure that sub-transactions are correctly accounted for when reconstructing a snapshot", "evidence": {"same_day": true, "patch_ids": ["fedd14b16b61b06734d4f9b28bfc73c9"], "statement_hash": "f92c06454d4721287e52c538bb94202f5d912046aa15d37effc654899bd7b877"}, "url": "/docs/compare/?release=9.6.16#9.6.16-1e149c1d850251ba", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "89557742c12809d014ad8c2b12d791fc", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "In logical decoding, ensure that sub-transactions are correctly accounted for when reconstructing a snapshot", "evidence": {"same_day": true, "patch_ids": ["fedd14b16b61b06734d4f9b28bfc73c9"], "statement_hash": "f92c06454d4721287e52c538bb94202f5d912046aa15d37effc654899bd7b877"}, "url": "/docs/compare/?release=9.5.20#9.5.20-1e149c1d850251ba", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-eb3c21f292fb993b", "cves": [], "html": "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": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "c8b5e913b7f89a5d1b3c05235b26dd9508078b396430feef4e73ef5cf7cfbfcc", "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": ["f88f7206e"], "source_entry_id": "9.4.25/changes/013", "db_id": "4e314055a876588ca9d12be8b3c839e6", "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": "8cc965a6c7b1379876e047ae6dbdc5a6", "evidence": {"same_day": true, "patch_ids": ["4b3ea7c4276af2c59b503f7435657beb"], "statement_hash": "3789d1d50180cb6be08ab86cf5c8349bfd117d62b04c3ab06b7281c5e26eebc1"}}, {"rule": 2, "type": "equivalent", "target": "a01ee12cafc2d030088ea21e537886ee", "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": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "a01ee12cafc2d030088ea21e537886ee", "kind": "equivalent", "version": "12.1", "label": "12.1", "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=12.1#12.1-6c90cfa8ba825249", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"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"}]}, {"id": "9.4.25-f213c709a01f3b20", "cves": [], "html": "Fix ALTER SYSTEM to cope with duplicate entries in postgresql.auto.conf (Ian Barwick)
\nALTER SYSTEM itself will not generate such a state, but external tools that modify postgresql.auto.conf could do so. Duplicate entries for the target variable will now be removed, and then the new setting (if any) will be appended at the end.
", "text": "Fix ALTER SYSTEM to cope with duplicate entries in postgresql.auto.conf (Ian Barwick) ALTER SYSTEM itself will not generate such a state, but external tools that modify postgresql.auto.conf could do so. Duplicate entries for the target variable will now be removed, and then the new setting (if any) will be appended at the end.", "title": "Fix ALTER SYSTEM to cope with duplicate entries in postgresql.auto.conf", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "2a758441d4ca035442b55f78b8e4654b9a7cf4d655b4398b9b5680e63a524fe1", "section_path": ["Changes"], "commit_groups": [["29f9b1819", "32d38f54a", "4784ad7a3", "75b2f011f", "a4b0d955b", "f1bf619ac", "f8c9a0852"]], "identity_text": "Fix ALTER SYSTEM to cope with duplicate entries in postgresql.auto.conf (Ian Barwick) ALTER SYSTEM itself will not generate such a state, but external tools that modify postgresql.auto.conf could do so. Duplicate entries for the target variable will now be removed, and then the new setting (if any) will be appended at the end.", "commit_aliases": ["29f9b1819", "32d38f54a", "4784ad7a3", "75b2f011f", "a4b0d955b", "f1bf619ac", "f8c9a0852"], "source_commits": ["a4b0d955b"], "source_entry_id": "9.4.25/changes/014", "db_id": "d6798e4c7347c23429f678916a94b88a", "patch_ids": ["4130a27c8c81a139d7d50dc89d86da9c"], "statement_hash": "a3d02dbbda8e973f29cd2dda38b81e6f0190dedd02d6cd11722c5a069c7693d4", "relations": [{"rule": 2, "type": "equivalent", "target": "81a62b06a830c80c290b748a7b7cfa8b", "evidence": {"same_day": true, "patch_ids": ["4130a27c8c81a139d7d50dc89d86da9c"], "statement_hash": "a3d02dbbda8e973f29cd2dda38b81e6f0190dedd02d6cd11722c5a069c7693d4"}}, {"rule": 2, "type": "equivalent", "target": "991531246f99e1c57bcd18d6734f3068", "evidence": {"same_day": true, "patch_ids": ["4130a27c8c81a139d7d50dc89d86da9c"], "statement_hash": "a3d02dbbda8e973f29cd2dda38b81e6f0190dedd02d6cd11722c5a069c7693d4"}}, {"rule": 2, "type": "equivalent", "target": "b6ab242f7102e93a778f875231d85b27", "evidence": {"same_day": true, "patch_ids": ["4130a27c8c81a139d7d50dc89d86da9c"], "statement_hash": "a3d02dbbda8e973f29cd2dda38b81e6f0190dedd02d6cd11722c5a069c7693d4"}}, {"rule": 2, "type": "equivalent", "target": "d0ec309fbaeba9135750d492714772f3", "evidence": {"same_day": true, "patch_ids": ["4130a27c8c81a139d7d50dc89d86da9c"], "statement_hash": "a3d02dbbda8e973f29cd2dda38b81e6f0190dedd02d6cd11722c5a069c7693d4"}}], "version": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "b6ab242f7102e93a778f875231d85b27", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix ALTER SYSTEM to cope with duplicate entries in postgresql.auto.conf", "evidence": {"same_day": true, "patch_ids": ["4130a27c8c81a139d7d50dc89d86da9c"], "statement_hash": "a3d02dbbda8e973f29cd2dda38b81e6f0190dedd02d6cd11722c5a069c7693d4"}, "url": "/docs/compare/?release=11.6#11.6-f213c709a01f3b20", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "991531246f99e1c57bcd18d6734f3068", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Fix ALTER SYSTEM to cope with duplicate entries in postgresql.auto.conf", "evidence": {"same_day": true, "patch_ids": ["4130a27c8c81a139d7d50dc89d86da9c"], "statement_hash": "a3d02dbbda8e973f29cd2dda38b81e6f0190dedd02d6cd11722c5a069c7693d4"}, "url": "/docs/compare/?release=10.11#10.11-f213c709a01f3b20", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "81a62b06a830c80c290b748a7b7cfa8b", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Fix ALTER SYSTEM to cope with duplicate entries in postgresql.auto.conf", "evidence": {"same_day": true, "patch_ids": ["4130a27c8c81a139d7d50dc89d86da9c"], "statement_hash": "a3d02dbbda8e973f29cd2dda38b81e6f0190dedd02d6cd11722c5a069c7693d4"}, "url": "/docs/compare/?release=9.6.16#9.6.16-f213c709a01f3b20", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "d0ec309fbaeba9135750d492714772f3", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Fix ALTER SYSTEM to cope with duplicate entries in postgresql.auto.conf", "evidence": {"same_day": true, "patch_ids": ["4130a27c8c81a139d7d50dc89d86da9c"], "statement_hash": "a3d02dbbda8e973f29cd2dda38b81e6f0190dedd02d6cd11722c5a069c7693d4"}, "url": "/docs/compare/?release=9.5.20#9.5.20-f213c709a01f3b20", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-7d2801a7208a7ab0", "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": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "7749524f22a0094de543bed8c7abd281565515d514c903fcef856348e6b2d0ab", "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": ["762b25653"], "source_entry_id": "9.4.25/changes/015", "db_id": "649b888ac67da1c428bc4a931c4d7a3a", "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": "4e3562f65e838457039869a2ea8d4f43", "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": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "4e3562f65e838457039869a2ea8d4f43", "kind": "equivalent", "version": "12.1", "label": "12.1", "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=12.1#12.1-a58f485526548a94", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"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"}]}, {"id": "9.4.25-9ca34b46a8591f3c", "cves": [], "html": "Fix some cases where an incomplete date specification is not detected in time with time zone input (Alexander Lakhin)
\nIf a time zone with a time-varying UTC offset is specified, then a date must be as well, so that the offset can be resolved. Depending on the syntax used, this check was not enforced in some cases, allowing bogus output to be produced.
", "text": "Fix some cases where an incomplete date specification is not detected in time with time zone input (Alexander Lakhin) If a time zone with a time-varying UTC offset is specified, then a date must be as well, so that the offset can be resolved. Depending on the syntax used, this check was not enforced in some cases, allowing bogus output to be produced.", "title": "Fix some cases where an incomplete date specification is not detected in time with time zone input", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "c5e0a07bd5c21d8a6593abab8f24e9f69fd8b20129849a240a514e5cd71ed0cf", "section_path": ["Changes"], "commit_groups": [["1ba4d0fe4", "1de3e0589", "1f7943698", "64579be64", "7c64a2cd9", "d16d241a5", "d8652ec55"]], "identity_text": "Fix some cases where an incomplete date specification is not detected in time with time zone input (Alexander Lakhin) If a time zone with a time-varying UTC offset is specified, then a date must be as well, so that the offset can be resolved. Depending on the syntax used, this check was not enforced in some cases, allowing bogus output to be produced.", "commit_aliases": ["1ba4d0fe4", "1de3e0589", "1f7943698", "64579be64", "7c64a2cd9", "d16d241a5", "d8652ec55"], "source_commits": ["1f7943698"], "source_entry_id": "9.4.25/changes/016", "db_id": "9e914978d794c368b7a8e1ac8993679b", "patch_ids": ["60b8906e95f2b04ca4609706bcd142e7"], "statement_hash": "8a5ba70e7778132d1f23c29ec28daa30ca990282407e3208cceff830bdab2177", "relations": [{"rule": 2, "type": "equivalent", "target": "2a9e62be3ffc7276d860702b4081ff5c", "evidence": {"same_day": true, "patch_ids": ["60b8906e95f2b04ca4609706bcd142e7"], "statement_hash": "8a5ba70e7778132d1f23c29ec28daa30ca990282407e3208cceff830bdab2177"}}, {"rule": 2, "type": "equivalent", "target": "2bfe1ef2301830504e90b8803a43ae0e", "evidence": {"same_day": true, "patch_ids": ["60b8906e95f2b04ca4609706bcd142e7"], "statement_hash": "8a5ba70e7778132d1f23c29ec28daa30ca990282407e3208cceff830bdab2177"}}, {"rule": 2, "type": "equivalent", "target": "79937d972cd7886d0feafdfde64f0c08", "evidence": {"same_day": true, "patch_ids": ["60b8906e95f2b04ca4609706bcd142e7"], "statement_hash": "8a5ba70e7778132d1f23c29ec28daa30ca990282407e3208cceff830bdab2177"}}, {"rule": 2, "type": "equivalent", "target": "9d5359b840004ae92038794c6995b394", "evidence": {"same_day": true, "patch_ids": ["60b8906e95f2b04ca4609706bcd142e7"], "statement_hash": "8a5ba70e7778132d1f23c29ec28daa30ca990282407e3208cceff830bdab2177"}}], "version": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "9d5359b840004ae92038794c6995b394", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix some cases where an incomplete date specification is not detected in time with time zone input", "evidence": {"same_day": true, "patch_ids": ["60b8906e95f2b04ca4609706bcd142e7"], "statement_hash": "8a5ba70e7778132d1f23c29ec28daa30ca990282407e3208cceff830bdab2177"}, "url": "/docs/compare/?release=11.6#11.6-9ca34b46a8591f3c", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "2bfe1ef2301830504e90b8803a43ae0e", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Fix some cases where an incomplete date specification is not detected in time with time zone input", "evidence": {"same_day": true, "patch_ids": ["60b8906e95f2b04ca4609706bcd142e7"], "statement_hash": "8a5ba70e7778132d1f23c29ec28daa30ca990282407e3208cceff830bdab2177"}, "url": "/docs/compare/?release=10.11#10.11-9ca34b46a8591f3c", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "2a9e62be3ffc7276d860702b4081ff5c", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Fix some cases where an incomplete date specification is not detected in time with time zone input", "evidence": {"same_day": true, "patch_ids": ["60b8906e95f2b04ca4609706bcd142e7"], "statement_hash": "8a5ba70e7778132d1f23c29ec28daa30ca990282407e3208cceff830bdab2177"}, "url": "/docs/compare/?release=9.6.16#9.6.16-9ca34b46a8591f3c", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "79937d972cd7886d0feafdfde64f0c08", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Fix some cases where an incomplete date specification is not detected in time with time zone input", "evidence": {"same_day": true, "patch_ids": ["60b8906e95f2b04ca4609706bcd142e7"], "statement_hash": "8a5ba70e7778132d1f23c29ec28daa30ca990282407e3208cceff830bdab2177"}, "url": "/docs/compare/?release=9.5.20#9.5.20-9ca34b46a8591f3c", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-5a5893e40f010ae4", "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": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "7fd4821162c36467b60dae2c5e409b4a27870213b490f6e1ed7fa58b4cc8f53c", "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": ["8a17afe84", "b6a6c129f"], "source_entry_id": "9.4.25/changes/017", "db_id": "42d9304af3b1d055979da4409d578bd4", "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": "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": "b3087a5cf08f5bd2809940a9b7fca7fe", "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": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "b3087a5cf08f5bd2809940a9b7fca7fe", "kind": "equivalent", "version": "12.1", "label": "12.1", "title": "Fix misbehavior of bitshiftright()", "evidence": {"same_day": true, "patch_ids": ["645e773743ded66708bfdeed1cca150a", "80cc4b25f456fae0cb55503971e08d3c"], "statement_hash": "018dc62423a960f38f4e021a35d213e72a0e5646bed012cf2a6b496e0bd6b17f"}, "url": "/docs/compare/?release=12.1#12.1-47a035bc731f2d2c", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"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"}]}, {"id": "9.4.25-75de43d9a302d9de", "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": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "a8d3e066e9d5e0df453eccdb07c9697dcd3513ee60e1e608294360d710af1c66", "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": ["18622caa3", "8d380864a"], "source_entry_id": "9.4.25/changes/018", "db_id": "4f905d06a5c25d4b8d28e94c2622d366", "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": "7d17e70514638e9934682dd4384e78b1", "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": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "7d17e70514638e9934682dd4384e78b1", "kind": "equivalent", "version": "12.1", "label": "12.1", "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=12.1#12.1-0282ed12e06cabde", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"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"}]}, {"id": "9.4.25-f466e0af8b871c28", "cves": [], "html": "Fix incorrect compression logic for GIN posting lists (Heikki Linnakangas)
\nA GIN posting list item can require 7 bytes if the distance between adjacent indexed TIDs exceeds 16TB. One step in the logic was out of sync with that, and might try to write the value into a 6-byte buffer. In principle this could cause a stack overrun, but on most architectures it's likely that the next byte would be unused alignment padding, making the bug harmless. In any case the bug would be very difficult to hit.
", "text": "Fix incorrect compression logic for GIN posting lists (Heikki Linnakangas) A GIN posting list item can require 7 bytes if the distance between adjacent indexed TIDs exceeds 16TB. One step in the logic was out of sync with that, and might try to write the value into a 6-byte buffer. In principle this could cause a stack overrun, but on most architectures it's likely that the next byte would be unused alignment padding, making the bug harmless. In any case the bug would be very difficult to hit.", "title": "Fix incorrect compression logic for GIN posting lists", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "949a2510f94ed33dc75a7a98e8ca86e07633594a8cdaad1f0a46695fcb6afc15", "section_path": ["Changes"], "commit_groups": [["1c99acc6e", "6292cde1c", "6b7819a0b", "756178232", "bde7493d1", "cf00ca522", "e2e616579"], ["744c848dc"]], "identity_text": "Fix incorrect compression logic for GIN posting lists (Heikki Linnakangas) A GIN posting list item can require 7 bytes if the distance between adjacent indexed TIDs exceeds 16TB. One step in the logic was out of sync with that, and might try to write the value into a 6-byte buffer. In principle this could cause a stack overrun, but on most architectures it's likely that the next byte would be unused alignment padding, making the bug harmless. In any case the bug would be very difficult to hit.", "commit_aliases": ["1c99acc6e", "6292cde1c", "6b7819a0b", "744c848dc", "756178232", "bde7493d1", "cf00ca522", "e2e616579"], "source_commits": ["6292cde1c", "744c848dc"], "source_entry_id": "9.4.25/changes/019", "db_id": "3fc326e55a6b6b746dbddce853d76f45", "patch_ids": ["60acafcf1cabfbe9689d5648685a681d", "66bb22b045c63c243194aa0ae4579612"], "statement_hash": "fcfa6868976587d2621b5637da29698324069942fe27b2fe90d8e7597822d129", "relations": [{"rule": 2, "type": "equivalent", "target": "5be78007dca7c1c0fbedd0dcc358ab1d", "evidence": {"same_day": true, "patch_ids": ["60acafcf1cabfbe9689d5648685a681d", "66bb22b045c63c243194aa0ae4579612"], "statement_hash": "fcfa6868976587d2621b5637da29698324069942fe27b2fe90d8e7597822d129"}}, {"rule": 2, "type": "equivalent", "target": "8c49457da3d5a86e1b67cf7bf25b8fb2", "evidence": {"same_day": true, "patch_ids": ["60acafcf1cabfbe9689d5648685a681d", "66bb22b045c63c243194aa0ae4579612"], "statement_hash": "fcfa6868976587d2621b5637da29698324069942fe27b2fe90d8e7597822d129"}}, {"rule": 2, "type": "equivalent", "target": "b75d1389fbbfd02cdf24534c23cd800e", "evidence": {"same_day": true, "patch_ids": ["60acafcf1cabfbe9689d5648685a681d", "66bb22b045c63c243194aa0ae4579612"], "statement_hash": "fcfa6868976587d2621b5637da29698324069942fe27b2fe90d8e7597822d129"}}, {"rule": 2, "type": "equivalent", "target": "f0f6785a05bc6fa46583e2f8ef2f62a8", "evidence": {"same_day": true, "patch_ids": ["60acafcf1cabfbe9689d5648685a681d", "66bb22b045c63c243194aa0ae4579612"], "statement_hash": "fcfa6868976587d2621b5637da29698324069942fe27b2fe90d8e7597822d129"}}], "version": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "5be78007dca7c1c0fbedd0dcc358ab1d", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix incorrect compression logic for GIN posting lists", "evidence": {"same_day": true, "patch_ids": ["60acafcf1cabfbe9689d5648685a681d", "66bb22b045c63c243194aa0ae4579612"], "statement_hash": "fcfa6868976587d2621b5637da29698324069942fe27b2fe90d8e7597822d129"}, "url": "/docs/compare/?release=11.6#11.6-f466e0af8b871c28", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "f0f6785a05bc6fa46583e2f8ef2f62a8", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Fix incorrect compression logic for GIN posting lists", "evidence": {"same_day": true, "patch_ids": ["60acafcf1cabfbe9689d5648685a681d", "66bb22b045c63c243194aa0ae4579612"], "statement_hash": "fcfa6868976587d2621b5637da29698324069942fe27b2fe90d8e7597822d129"}, "url": "/docs/compare/?release=10.11#10.11-f466e0af8b871c28", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "b75d1389fbbfd02cdf24534c23cd800e", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Fix incorrect compression logic for GIN posting lists", "evidence": {"same_day": true, "patch_ids": ["60acafcf1cabfbe9689d5648685a681d", "66bb22b045c63c243194aa0ae4579612"], "statement_hash": "fcfa6868976587d2621b5637da29698324069942fe27b2fe90d8e7597822d129"}, "url": "/docs/compare/?release=9.6.16#9.6.16-f466e0af8b871c28", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "8c49457da3d5a86e1b67cf7bf25b8fb2", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Fix incorrect compression logic for GIN posting lists", "evidence": {"same_day": true, "patch_ids": ["60acafcf1cabfbe9689d5648685a681d", "66bb22b045c63c243194aa0ae4579612"], "statement_hash": "fcfa6868976587d2621b5637da29698324069942fe27b2fe90d8e7597822d129"}, "url": "/docs/compare/?release=9.5.20#9.5.20-f466e0af8b871c28", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-e445b06e9b344adb", "cves": [], "html": "Fix handling of infinity, NaN, and NULL values in KNN-GiST (Alexander Korotkov)
\nThe query's output order could be wrong (different from a plain sort's result) if some distances computed for non-null column values are infinity or NaN.
", "text": "Fix handling of infinity, NaN, and NULL values in KNN-GiST (Alexander Korotkov) The query's output order could be wrong (different from a plain sort's result) if some distances computed for non-null column values are infinity or NaN.", "title": "Fix handling of infinity, NaN, and NULL values in KNN-GiST", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "c4c25c01043e96a0fd10a449c4f2ce5f5361529641dd86ca3f9c4e3922330981", "section_path": ["Changes"], "commit_groups": [["02f90879e", "1df412304", "3c155bafa", "92f6b49c4", "a5431b7d5", "d807200b4", "e6af7b367"], ["111fb7e42", "749b04d1d", "8f724002e", "986319d46", "b2037afec", "bc67f4189", "e5d8f3596"]], "identity_text": "Fix handling of infinity, NaN, and NULL values in KNN-GiST (Alexander Korotkov) The query's output order could be wrong (different from a plain sort's result) if some distances computed for non-null column values are infinity or NaN.", "commit_aliases": ["02f90879e", "111fb7e42", "1df412304", "3c155bafa", "749b04d1d", "8f724002e", "92f6b49c4", "986319d46", "a5431b7d5", "b2037afec", "bc67f4189", "d807200b4", "e5d8f3596", "e6af7b367"], "source_commits": ["111fb7e42", "1df412304"], "source_entry_id": "9.4.25/changes/020", "db_id": "beda73fd9dd4d580e534c03f8985a729", "patch_ids": ["7b9ea18b56299a8d028ae8820497e4b7", "c24a7727ca7395afe3dc6605d984abda"], "statement_hash": "9986d70146d4c4a9030d03614e231aaffcb3caabc05c0a122a7ea222c3129e26", "relations": [{"rule": 2, "type": "equivalent", "target": "7a43cdba2247d6050186b24e9452d6b6", "evidence": {"same_day": true, "patch_ids": ["7b9ea18b56299a8d028ae8820497e4b7", "c24a7727ca7395afe3dc6605d984abda"], "statement_hash": "9986d70146d4c4a9030d03614e231aaffcb3caabc05c0a122a7ea222c3129e26"}}, {"rule": 2, "type": "equivalent", "target": "9d7bbd437cedcff2df4f71c25b584f97", "evidence": {"same_day": true, "patch_ids": ["7b9ea18b56299a8d028ae8820497e4b7", "c24a7727ca7395afe3dc6605d984abda"], "statement_hash": "9986d70146d4c4a9030d03614e231aaffcb3caabc05c0a122a7ea222c3129e26"}}, {"rule": 2, "type": "equivalent", "target": "c3ccaff31d0f9a62e817be93b67bd01d", "evidence": {"same_day": true, "patch_ids": ["7b9ea18b56299a8d028ae8820497e4b7", "c24a7727ca7395afe3dc6605d984abda"], "statement_hash": "9986d70146d4c4a9030d03614e231aaffcb3caabc05c0a122a7ea222c3129e26"}}, {"rule": 2, "type": "equivalent", "target": "d9b7dda1aa30309ccee427f287468c34", "evidence": {"same_day": true, "patch_ids": ["7b9ea18b56299a8d028ae8820497e4b7", "c24a7727ca7395afe3dc6605d984abda"], "statement_hash": "9986d70146d4c4a9030d03614e231aaffcb3caabc05c0a122a7ea222c3129e26"}}], "version": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "7a43cdba2247d6050186b24e9452d6b6", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix handling of infinity, NaN, and NULL values in KNN-GiST", "evidence": {"same_day": true, "patch_ids": ["7b9ea18b56299a8d028ae8820497e4b7", "c24a7727ca7395afe3dc6605d984abda"], "statement_hash": "9986d70146d4c4a9030d03614e231aaffcb3caabc05c0a122a7ea222c3129e26"}, "url": "/docs/compare/?release=11.6#11.6-e445b06e9b344adb", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "9d7bbd437cedcff2df4f71c25b584f97", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Fix handling of infinity, NaN, and NULL values in KNN-GiST", "evidence": {"same_day": true, "patch_ids": ["7b9ea18b56299a8d028ae8820497e4b7", "c24a7727ca7395afe3dc6605d984abda"], "statement_hash": "9986d70146d4c4a9030d03614e231aaffcb3caabc05c0a122a7ea222c3129e26"}, "url": "/docs/compare/?release=10.11#10.11-e445b06e9b344adb", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "c3ccaff31d0f9a62e817be93b67bd01d", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Fix handling of infinity, NaN, and NULL values in KNN-GiST", "evidence": {"same_day": true, "patch_ids": ["7b9ea18b56299a8d028ae8820497e4b7", "c24a7727ca7395afe3dc6605d984abda"], "statement_hash": "9986d70146d4c4a9030d03614e231aaffcb3caabc05c0a122a7ea222c3129e26"}, "url": "/docs/compare/?release=9.6.16#9.6.16-e445b06e9b344adb", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "d9b7dda1aa30309ccee427f287468c34", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Fix handling of infinity, NaN, and NULL values in KNN-GiST", "evidence": {"same_day": true, "patch_ids": ["7b9ea18b56299a8d028ae8820497e4b7", "c24a7727ca7395afe3dc6605d984abda"], "statement_hash": "9986d70146d4c4a9030d03614e231aaffcb3caabc05c0a122a7ea222c3129e26"}, "url": "/docs/compare/?release=9.5.20#9.5.20-e445b06e9b344adb", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-9463b4807cc67dc0", "cves": [], "html": "Fix handling of searches for NULL in KNN-SP-GiST (Nikita Glukhov)
", "text": "Fix handling of searches for NULL in KNN-SP-GiST (Nikita Glukhov)", "title": "Fix handling of searches for NULL in KNN-SP-GiST", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "f4b4e16e688c7a2ac1cae4b92b6e2dee16789cc300f760628c671d0b3571e527", "section_path": ["Changes"], "commit_groups": [["140b7b1f9", "2f0434e8e", "388939748", "984b9ba1d"], ["2da8e56db", "31cbd7605", "332eda5bd", "53d9cf2db", "6cae9d2c1", "ad458d0cd", "d6a90aac5"]], "identity_text": "Fix handling of searches for NULL in KNN-SP-GiST (Nikita Glukhov)", "commit_aliases": ["140b7b1f9", "2da8e56db", "2f0434e8e", "31cbd7605", "332eda5bd", "388939748", "53d9cf2db", "6cae9d2c1", "984b9ba1d", "ad458d0cd", "d6a90aac5"], "source_commits": ["332eda5bd", "984b9ba1d"], "source_entry_id": "9.4.25/changes/021", "db_id": "d01ed88fb942afa0ed5ffa43faba6308", "patch_ids": ["6ff6f0f4c73f1aca8888e2ef75427b6a", "fbead6a49176269f775eefbb62877c7f"], "statement_hash": "c0d9be5b78fc1c8a236e8a3b8f7a6cbc43467beaf85024d646f78b0c0b577425", "relations": [{"rule": 2, "type": "equivalent", "target": "7c8f69a9ab49e39d197b5a8392db3b48", "evidence": {"same_day": true, "patch_ids": ["6ff6f0f4c73f1aca8888e2ef75427b6a", "fbead6a49176269f775eefbb62877c7f"], "statement_hash": "c0d9be5b78fc1c8a236e8a3b8f7a6cbc43467beaf85024d646f78b0c0b577425"}}, {"rule": 2, "type": "equivalent", "target": "8e91a2f472a015ee7ff3b4d301c5238a", "evidence": {"same_day": true, "patch_ids": ["6ff6f0f4c73f1aca8888e2ef75427b6a", "fbead6a49176269f775eefbb62877c7f"], "statement_hash": "c0d9be5b78fc1c8a236e8a3b8f7a6cbc43467beaf85024d646f78b0c0b577425"}}, {"rule": 2, "type": "equivalent", "target": "ca618c300b2c0271b550bbc8508bc145", "evidence": {"same_day": true, "patch_ids": ["6ff6f0f4c73f1aca8888e2ef75427b6a", "fbead6a49176269f775eefbb62877c7f"], "statement_hash": "c0d9be5b78fc1c8a236e8a3b8f7a6cbc43467beaf85024d646f78b0c0b577425"}}, {"rule": 2, "type": "equivalent", "target": "cff95402d4659c1e9851118ce708bbc0", "evidence": {"same_day": true, "patch_ids": ["6ff6f0f4c73f1aca8888e2ef75427b6a", "fbead6a49176269f775eefbb62877c7f"], "statement_hash": "c0d9be5b78fc1c8a236e8a3b8f7a6cbc43467beaf85024d646f78b0c0b577425"}}], "version": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "cff95402d4659c1e9851118ce708bbc0", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix handling of searches for NULL in KNN-SP-GiST", "evidence": {"same_day": true, "patch_ids": ["6ff6f0f4c73f1aca8888e2ef75427b6a", "fbead6a49176269f775eefbb62877c7f"], "statement_hash": "c0d9be5b78fc1c8a236e8a3b8f7a6cbc43467beaf85024d646f78b0c0b577425"}, "url": "/docs/compare/?release=11.6#11.6-9463b4807cc67dc0", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "7c8f69a9ab49e39d197b5a8392db3b48", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Fix handling of searches for NULL in KNN-SP-GiST", "evidence": {"same_day": true, "patch_ids": ["6ff6f0f4c73f1aca8888e2ef75427b6a", "fbead6a49176269f775eefbb62877c7f"], "statement_hash": "c0d9be5b78fc1c8a236e8a3b8f7a6cbc43467beaf85024d646f78b0c0b577425"}, "url": "/docs/compare/?release=10.11#10.11-9463b4807cc67dc0", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "8e91a2f472a015ee7ff3b4d301c5238a", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Fix handling of searches for NULL in KNN-SP-GiST", "evidence": {"same_day": true, "patch_ids": ["6ff6f0f4c73f1aca8888e2ef75427b6a", "fbead6a49176269f775eefbb62877c7f"], "statement_hash": "c0d9be5b78fc1c8a236e8a3b8f7a6cbc43467beaf85024d646f78b0c0b577425"}, "url": "/docs/compare/?release=9.6.16#9.6.16-9463b4807cc67dc0", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "ca618c300b2c0271b550bbc8508bc145", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Fix handling of searches for NULL in KNN-SP-GiST", "evidence": {"same_day": true, "patch_ids": ["6ff6f0f4c73f1aca8888e2ef75427b6a", "fbead6a49176269f775eefbb62877c7f"], "statement_hash": "c0d9be5b78fc1c8a236e8a3b8f7a6cbc43467beaf85024d646f78b0c0b577425"}, "url": "/docs/compare/?release=9.5.20#9.5.20-9463b4807cc67dc0", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-58eb2a630e84cd10", "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": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "74954a1c0243d9b26e633e90f250ec6e2ba060beaf964283d741b43419d85c7d", "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": ["fedcab352"], "source_entry_id": "9.4.25/changes/022", "db_id": "26d29236bce72fa79bbb285e2ee96b25", "patch_ids": ["b4d55cbc4d3eb09a21b712947fc01446"], "statement_hash": "6365cced4f4ad597334c45749ccad9c902fd71e380f4a88b6dc5f99475529bf5", "relations": [{"rule": 2, "type": "equivalent", "target": "225febe7c77dd58718ec5f3f63a0812d", "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": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "225febe7c77dd58718ec5f3f63a0812d", "kind": "equivalent", "version": "12.1", "label": "12.1", "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=12.1#12.1-d61548fa25c77231", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"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"}]}, {"id": "9.4.25-ac11573e61fef935", "cves": [], "html": "Avoid compile failure if an ECPG client includes ecpglib.h while having ENABLE_NLS defined (Tom Lane)
\nThis risk was created by a misplaced declaration: ecpg_gettext() should not be visible to client code.
In psql, resynchronize internal state about the server after an unexpected connection loss and successful reconnection (Peter Billen, Tom Lane)
\nOrdinarily this is unnecessary since the state would be the same anyway. But it can matter in corner cases, such as where the connection might lead to one of several servers. This change causes psql to re-issue any interactive messages that it would have issued at startup, for example about whether SSL is in use.
", "text": "In psql, resynchronize internal state about the server after an unexpected connection loss and successful reconnection (Peter Billen, Tom Lane) Ordinarily this is unnecessary since the state would be the same anyway. But it can matter in corner cases, such as where the connection might lead to one of several servers. This change causes psql to re-issue any interactive messages that it would have issued at startup, for example about whether SSL is in use.", "title": "In psql, resynchronize internal state about the server after an unexpected connection loss and successful reconnection", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "e5c0657e50f74f633e45aaccf8fd3ca1c7e159ee9aac6e81d741efded313e9ed", "section_path": ["Changes"], "commit_groups": [["3080f8f61", "5524ef558", "62724bd95", "89535db97", "90433c38e", "aef362385", "b0b2ef25e"]], "identity_text": "In psql, resynchronize internal state about the server after an unexpected connection loss and successful reconnection (Peter Billen, Tom Lane) Ordinarily this is unnecessary since the state would be the same anyway. But it can matter in corner cases, such as where the connection might lead to one of several servers. This change causes psql to re-issue any interactive messages that it would have issued at startup, for example about whether SSL is in use.", "commit_aliases": ["3080f8f61", "5524ef558", "62724bd95", "89535db97", "90433c38e", "aef362385", "b0b2ef25e"], "source_commits": ["89535db97"], "source_entry_id": "9.4.25/changes/024", "db_id": "d71acd58d8299ec0820c244ccb30cd11", "patch_ids": ["989f4cbbc066103b978638607a6ad548"], "statement_hash": "efd5d1fb94fbba9a410c05a370faf129172241dc377afee41dc24cc9e5bafaac", "relations": [{"rule": 2, "type": "equivalent", "target": "1bc9918c5d1e2f5fc32c3478cb761f01", "evidence": {"same_day": true, "patch_ids": ["989f4cbbc066103b978638607a6ad548"], "statement_hash": "efd5d1fb94fbba9a410c05a370faf129172241dc377afee41dc24cc9e5bafaac"}}, {"rule": 2, "type": "equivalent", "target": "6d91276c5f102904cb599ad608de250b", "evidence": {"same_day": true, "patch_ids": ["989f4cbbc066103b978638607a6ad548"], "statement_hash": "efd5d1fb94fbba9a410c05a370faf129172241dc377afee41dc24cc9e5bafaac"}}, {"rule": 2, "type": "equivalent", "target": "7e6b80a38c92a835f9fafa759c9afc19", "evidence": {"same_day": true, "patch_ids": ["989f4cbbc066103b978638607a6ad548"], "statement_hash": "efd5d1fb94fbba9a410c05a370faf129172241dc377afee41dc24cc9e5bafaac"}}, {"rule": 2, "type": "equivalent", "target": "f54b57628fd594dde69ef0ce146a684b", "evidence": {"same_day": true, "patch_ids": ["989f4cbbc066103b978638607a6ad548"], "statement_hash": "efd5d1fb94fbba9a410c05a370faf129172241dc377afee41dc24cc9e5bafaac"}}], "version": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f54b57628fd594dde69ef0ce146a684b", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "In psql, resynchronize internal state about the server after an unexpected connection loss and successful reconnection", "evidence": {"same_day": true, "patch_ids": ["989f4cbbc066103b978638607a6ad548"], "statement_hash": "efd5d1fb94fbba9a410c05a370faf129172241dc377afee41dc24cc9e5bafaac"}, "url": "/docs/compare/?release=11.6#11.6-692375374a7f553a", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "7e6b80a38c92a835f9fafa759c9afc19", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "In psql, resynchronize internal state about the server after an unexpected connection loss and successful reconnection", "evidence": {"same_day": true, "patch_ids": ["989f4cbbc066103b978638607a6ad548"], "statement_hash": "efd5d1fb94fbba9a410c05a370faf129172241dc377afee41dc24cc9e5bafaac"}, "url": "/docs/compare/?release=10.11#10.11-692375374a7f553a", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "1bc9918c5d1e2f5fc32c3478cb761f01", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "In psql, resynchronize internal state about the server after an unexpected connection loss and successful reconnection", "evidence": {"same_day": true, "patch_ids": ["989f4cbbc066103b978638607a6ad548"], "statement_hash": "efd5d1fb94fbba9a410c05a370faf129172241dc377afee41dc24cc9e5bafaac"}, "url": "/docs/compare/?release=9.6.16#9.6.16-692375374a7f553a", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "6d91276c5f102904cb599ad608de250b", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "In psql, resynchronize internal state about the server after an unexpected connection loss and successful reconnection", "evidence": {"same_day": true, "patch_ids": ["989f4cbbc066103b978638607a6ad548"], "statement_hash": "efd5d1fb94fbba9a410c05a370faf129172241dc377afee41dc24cc9e5bafaac"}, "url": "/docs/compare/?release=9.5.20#9.5.20-692375374a7f553a", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-c00328ab3a6902ed", "cves": [], "html": "Avoid platform-specific null pointer dereference in psql (Quentin Rameau)
", "text": "Avoid platform-specific null pointer dereference in psql (Quentin Rameau)", "title": "Avoid platform-specific null pointer dereference in psql", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "1e532007a6b69675c5219f2400d048ce5dfdbf2eefb340e9321323c96677e42b", "section_path": ["Changes"], "commit_groups": [["28d2ce3c7", "363382521", "5fc7b1e93", "6338fa3e7", "65b1cad5a", "c693c5c49", "fb55e9539"]], "identity_text": "Avoid platform-specific null pointer dereference in psql (Quentin Rameau)", "commit_aliases": ["28d2ce3c7", "363382521", "5fc7b1e93", "6338fa3e7", "65b1cad5a", "c693c5c49", "fb55e9539"], "source_commits": ["c693c5c49"], "source_entry_id": "9.4.25/changes/025", "db_id": "3a8c1fb571a41d8585b0b8d44ef758b5", "patch_ids": ["4bc8bfc7475b0c29d9a65af50d248cc6"], "statement_hash": "f5c877897047f551b3de25260d824469a794ebddd94860e0eafdafda93cbed6f", "relations": [{"rule": 2, "type": "equivalent", "target": "1e07b974e12ac0a7794d59835c52b3b4", "evidence": {"same_day": true, "patch_ids": ["4bc8bfc7475b0c29d9a65af50d248cc6"], "statement_hash": "f5c877897047f551b3de25260d824469a794ebddd94860e0eafdafda93cbed6f"}}, {"rule": 2, "type": "equivalent", "target": "62b52148d969679de9c3081ee15b1012", "evidence": {"same_day": true, "patch_ids": ["4bc8bfc7475b0c29d9a65af50d248cc6"], "statement_hash": "f5c877897047f551b3de25260d824469a794ebddd94860e0eafdafda93cbed6f"}}, {"rule": 2, "type": "equivalent", "target": "a51574c5d195a832bc9c981a608a0c41", "evidence": {"same_day": true, "patch_ids": ["4bc8bfc7475b0c29d9a65af50d248cc6"], "statement_hash": "f5c877897047f551b3de25260d824469a794ebddd94860e0eafdafda93cbed6f"}}, {"rule": 2, "type": "equivalent", "target": "fad3a0a556016637fb89e50f4d5d1c5c", "evidence": {"same_day": true, "patch_ids": ["4bc8bfc7475b0c29d9a65af50d248cc6"], "statement_hash": "f5c877897047f551b3de25260d824469a794ebddd94860e0eafdafda93cbed6f"}}], "version": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "1e07b974e12ac0a7794d59835c52b3b4", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Avoid platform-specific null pointer dereference in psql", "evidence": {"same_day": true, "patch_ids": ["4bc8bfc7475b0c29d9a65af50d248cc6"], "statement_hash": "f5c877897047f551b3de25260d824469a794ebddd94860e0eafdafda93cbed6f"}, "url": "/docs/compare/?release=11.6#11.6-c00328ab3a6902ed", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "a51574c5d195a832bc9c981a608a0c41", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Avoid platform-specific null pointer dereference in psql", "evidence": {"same_day": true, "patch_ids": ["4bc8bfc7475b0c29d9a65af50d248cc6"], "statement_hash": "f5c877897047f551b3de25260d824469a794ebddd94860e0eafdafda93cbed6f"}, "url": "/docs/compare/?release=10.11#10.11-c00328ab3a6902ed", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "fad3a0a556016637fb89e50f4d5d1c5c", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Avoid platform-specific null pointer dereference in psql", "evidence": {"same_day": true, "patch_ids": ["4bc8bfc7475b0c29d9a65af50d248cc6"], "statement_hash": "f5c877897047f551b3de25260d824469a794ebddd94860e0eafdafda93cbed6f"}, "url": "/docs/compare/?release=9.6.16#9.6.16-c00328ab3a6902ed", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "62b52148d969679de9c3081ee15b1012", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Avoid platform-specific null pointer dereference in psql", "evidence": {"same_day": true, "patch_ids": ["4bc8bfc7475b0c29d9a65af50d248cc6"], "statement_hash": "f5c877897047f551b3de25260d824469a794ebddd94860e0eafdafda93cbed6f"}, "url": "/docs/compare/?release=9.5.20#9.5.20-c00328ab3a6902ed", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-6d7ba062a7f57628", "cves": [], "html": "Fix pg_dump's handling of circular dependencies in views (Tom Lane)
\nIn some cases a view may depend on an object that pg_dump needs to dump later than the view; the most common example is that a query using GROUP BY on a primary-key column may be semantically invalid without the primary key. This is now handled by emitting a dummy CREATE VIEW command that just establishes the view's column names and types, and then later emitting CREATE OR REPLACE VIEW with the full view definition. Previously, the dummy definition was actually a CREATE TABLE command, and this was automagically converted to a view by a later CREATE RULE command. The new approach has been used successfully in PostgreSQL version 10 and later. We are back-patching it into older releases now because of reports that the previous method causes bogus error messages about the view's replica identity status. This change also avoids problems when trying to use the --clean option during a restore involving such a view.
", "text": "Fix pg_dump's handling of circular dependencies in views (Tom Lane) In some cases a view may depend on an object that pg_dump needs to dump later than the view; the most common example is that a query using GROUP BY on a primary-key column may be semantically invalid without the primary key. This is now handled by emitting a dummy CREATE VIEW command that just establishes the view's column names and types, and then later emitting CREATE OR REPLACE VIEW with the full view definition. Previously, the dummy definition was actually a CREATE TABLE command, and this was automagically converted to a view by a later CREATE RULE command. The new approach has been used successfully in PostgreSQL version 10 and later. We are back-patching it into older releases now because of reports that the previous method causes bogus error messages about the view's replica identity status. This change also avoids problems when trying to use the --clean option during a restore involving such a view.", "title": "Fix pg_dump's handling of circular dependencies in views", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "ccfbdfbc5b8098880730e0c8af5151e30ad8daeabfea6bb1d095fad6cd8682f6", "section_path": ["Changes"], "commit_groups": [["404cbc562", "7fc50a8a7", "ddcc582a4"]], "identity_text": "Fix pg_dump's handling of circular dependencies in views (Tom Lane) In some cases a view may depend on an object that pg_dump needs to dump later than the view; the most common example is that a query using GROUP BY on a primary-key column may be semantically invalid without the primary key. This is now handled by emitting a dummy CREATE VIEW command that just establishes the view's column names and types, and then later emitting CREATE OR REPLACE VIEW with the full view definition. Previously, the dummy definition was actually a CREATE TABLE command, and this was automagically converted to a view by a later CREATE RULE command. The new approach has been used successfully in PostgreSQL version 10 and later. We are back-patching it into older releases now because of reports that the previous method causes bogus error messages about the view's replica identity status. This change also avoids problems when trying to use the --clean option during a restore involving such a view.", "commit_aliases": ["404cbc562", "7fc50a8a7", "ddcc582a4"], "source_commits": ["ddcc582a4"], "source_entry_id": "9.4.25/changes/026", "db_id": "64711bc6a1a211668b7189724ea23f4f", "patch_ids": ["9dc10dd0717a193622320052bdcb9bda"], "statement_hash": "016bc28c047d5fb021d8086f540daec9dbd962e3644b3b33673a8ea71347335e", "relations": [{"rule": 2, "type": "equivalent", "target": "37642a90e8cace463753046f59ed6f35", "evidence": {"same_day": true, "patch_ids": ["9dc10dd0717a193622320052bdcb9bda"], "statement_hash": "016bc28c047d5fb021d8086f540daec9dbd962e3644b3b33673a8ea71347335e"}}, {"rule": 2, "type": "equivalent", "target": "a89fa0b3fdcaac5d34bd88b36a8a11d6", "evidence": {"same_day": true, "patch_ids": ["9dc10dd0717a193622320052bdcb9bda"], "statement_hash": "016bc28c047d5fb021d8086f540daec9dbd962e3644b3b33673a8ea71347335e"}}], "version": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "a89fa0b3fdcaac5d34bd88b36a8a11d6", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Fix pg_dump's handling of circular dependencies in views", "evidence": {"same_day": true, "patch_ids": ["9dc10dd0717a193622320052bdcb9bda"], "statement_hash": "016bc28c047d5fb021d8086f540daec9dbd962e3644b3b33673a8ea71347335e"}, "url": "/docs/compare/?release=9.6.16#9.6.16-6d7ba062a7f57628", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "37642a90e8cace463753046f59ed6f35", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Fix pg_dump's handling of circular dependencies in views", "evidence": {"same_day": true, "patch_ids": ["9dc10dd0717a193622320052bdcb9bda"], "statement_hash": "016bc28c047d5fb021d8086f540daec9dbd962e3644b3b33673a8ea71347335e"}, "url": "/docs/compare/?release=9.5.20#9.5.20-6d7ba062a7f57628", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-06b38c70f27c77eb", "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": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "0a083836b3fb2abc1e11d62fdf2aca7c46a6da4d61d64c7cdd816c569949cac1", "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": ["da5cd7a68"], "source_entry_id": "9.4.25/changes/027", "db_id": "a8a5d43ed77e0081ab73103ceb2ae846", "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": "fa647ca113a1508559005eb20a936e44", "evidence": {"same_day": true, "patch_ids": ["942313a05555b57ba0897a803f711227"], "statement_hash": "cda6c53c513e726a6397771aeafd5bec7d15381a61afc0f0239a83be49bb9913"}}], "version": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "fa647ca113a1508559005eb20a936e44", "kind": "equivalent", "version": "12.1", "label": "12.1", "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=12.1#12.1-f86364d7db67984c", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"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"}]}, {"id": "9.4.25-0ba6ba8270466d4a", "cves": [], "html": "Fix pg_dump to work again with pre-8.3 source servers (Tom Lane)
\nA previous fix caused pg_dump to always try to query pg_opfamily, but that catalog doesn't exist before version 8.3.
", "text": "Fix pg_dump to work again with pre-8.3 source servers (Tom Lane) A previous fix caused pg_dump to always try to query pg_opfamily, but that catalog doesn't exist before version 8.3.", "title": "Fix pg_dump to work again with pre-8.3 source servers", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "7a6934a904b8720e9ae5f50bef73892cdb25405ed0af9c8125f8264deab36921", "section_path": ["Changes"], "commit_groups": [["2b608ba31", "31d43710f", "4dea8ad56", "63ae888a9", "6844adba5", "c56858487", "f2bdfebb9"]], "identity_text": "Fix pg_dump to work again with pre-8.3 source servers (Tom Lane) A previous fix caused pg_dump to always try to query pg_opfamily, but that catalog doesn't exist before version 8.3.", "commit_aliases": ["2b608ba31", "31d43710f", "4dea8ad56", "63ae888a9", "6844adba5", "c56858487", "f2bdfebb9"], "source_commits": ["63ae888a9"], "source_entry_id": "9.4.25/changes/028", "db_id": "82fdce4fab5c46291d9b290f873418af", "patch_ids": ["d71878ff6b815304b9b657e483172169"], "statement_hash": "88f87b255698fe87248479f9676e4fb380622d1b0d04add35c15fe00c06ea3e4", "relations": [{"rule": 2, "type": "equivalent", "target": "08dacd7c914334b0fc5cb6ac7f6474bf", "evidence": {"same_day": true, "patch_ids": ["d71878ff6b815304b9b657e483172169"], "statement_hash": "88f87b255698fe87248479f9676e4fb380622d1b0d04add35c15fe00c06ea3e4"}}, {"rule": 2, "type": "equivalent", "target": "165675768109d9e1a41b61e82087cb03", "evidence": {"same_day": true, "patch_ids": ["d71878ff6b815304b9b657e483172169"], "statement_hash": "88f87b255698fe87248479f9676e4fb380622d1b0d04add35c15fe00c06ea3e4"}}, {"rule": 2, "type": "equivalent", "target": "6f0c4ebd3da0800b96dc28acfed0f3c5", "evidence": {"same_day": true, "patch_ids": ["d71878ff6b815304b9b657e483172169"], "statement_hash": "88f87b255698fe87248479f9676e4fb380622d1b0d04add35c15fe00c06ea3e4"}}, {"rule": 2, "type": "equivalent", "target": "9080dd4647ee7e07e5928151f7ad708e", "evidence": {"same_day": true, "patch_ids": ["d71878ff6b815304b9b657e483172169"], "statement_hash": "88f87b255698fe87248479f9676e4fb380622d1b0d04add35c15fe00c06ea3e4"}}], "version": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "165675768109d9e1a41b61e82087cb03", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix pg_dump to work again with pre-8.3 source servers", "evidence": {"same_day": true, "patch_ids": ["d71878ff6b815304b9b657e483172169"], "statement_hash": "88f87b255698fe87248479f9676e4fb380622d1b0d04add35c15fe00c06ea3e4"}, "url": "/docs/compare/?release=11.6#11.6-0ba6ba8270466d4a", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "9080dd4647ee7e07e5928151f7ad708e", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Fix pg_dump to work again with pre-8.3 source servers", "evidence": {"same_day": true, "patch_ids": ["d71878ff6b815304b9b657e483172169"], "statement_hash": "88f87b255698fe87248479f9676e4fb380622d1b0d04add35c15fe00c06ea3e4"}, "url": "/docs/compare/?release=10.11#10.11-0ba6ba8270466d4a", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "6f0c4ebd3da0800b96dc28acfed0f3c5", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Fix pg_dump to work again with pre-8.3 source servers", "evidence": {"same_day": true, "patch_ids": ["d71878ff6b815304b9b657e483172169"], "statement_hash": "88f87b255698fe87248479f9676e4fb380622d1b0d04add35c15fe00c06ea3e4"}, "url": "/docs/compare/?release=9.6.16#9.6.16-0ba6ba8270466d4a", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "08dacd7c914334b0fc5cb6ac7f6474bf", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Fix pg_dump to work again with pre-8.3 source servers", "evidence": {"same_day": true, "patch_ids": ["d71878ff6b815304b9b657e483172169"], "statement_hash": "88f87b255698fe87248479f9676e4fb380622d1b0d04add35c15fe00c06ea3e4"}, "url": "/docs/compare/?release=9.5.20#9.5.20-0ba6ba8270466d4a", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-4ff2f6e3b66cd783", "cves": [], "html": "In pg_restore, treat -f - as meaning \"output to stdout\" (Álvaro Herrera)
\nThis synchronizes pg_restore's behavior with some other applications, and in particular makes pre-v12 branches act similarly to version 12's pg_restore, simplifying creation of dump/restore scripts that work across multiple PostgreSQL versions. Before this change, pg_restore interpreted such a switch as meaning \"output to a file named -\", but few people would want that.
", "text": "In pg_restore, treat -f - as meaning \"output to stdout\" (Álvaro Herrera) This synchronizes pg_restore's behavior with some other applications, and in particular makes pre-v12 branches act similarly to version 12's pg_restore, simplifying creation of dump/restore scripts that work across multiple PostgreSQL versions. Before this change, pg_restore interpreted such a switch as meaning \"output to a file named -\", but few people would want that.", "title": "In pg_restore, treat -f - as meaning \"output to stdout\"", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "6293be9197c2c3683c1df7ee5a491cbbed78a0fed5d3f27c7013933145be8b6a", "section_path": ["Changes"], "commit_groups": [["12a51e2eb", "3574c0ac0", "5ee8f0fe1", "9fb25fda6", "d38635725"]], "identity_text": "In pg_restore, treat -f - as meaning output to stdout (Álvaro Herrera) This synchronizes pg_restore's behavior with some other applications, and in particular makes pre-v12 branches act similarly to version 12's pg_restore, simplifying creation of dump/restore scripts that work across multiple PostgreSQL versions. Before this change, pg_restore interpreted such a switch as meaning output to a file named -, but few people would want that.", "commit_aliases": ["12a51e2eb", "3574c0ac0", "5ee8f0fe1", "9fb25fda6", "d38635725"], "source_commits": ["9fb25fda6"], "source_entry_id": "9.4.25/changes/029", "db_id": "17eef586257eb2b31052fd424787e1e0", "patch_ids": ["d543638e0adb6ae160d3d75e0395599c"], "statement_hash": "f582eb5274a2c01036cb5b6f4a3ded9c5b8c09a05deadf030b6853753865523e", "relations": [{"rule": 2, "type": "equivalent", "target": "0fb06bb61933820ce109f1fb57a07095", "evidence": {"same_day": true, "patch_ids": ["d543638e0adb6ae160d3d75e0395599c"], "statement_hash": "f582eb5274a2c01036cb5b6f4a3ded9c5b8c09a05deadf030b6853753865523e"}}, {"rule": 2, "type": "equivalent", "target": "71c71a9da18b3b766b2ead932528efd3", "evidence": {"same_day": true, "patch_ids": ["d543638e0adb6ae160d3d75e0395599c"], "statement_hash": "f582eb5274a2c01036cb5b6f4a3ded9c5b8c09a05deadf030b6853753865523e"}}, {"rule": 2, "type": "equivalent", "target": "ba7b4d90e9c3137c7ff24eb2f08ea42e", "evidence": {"same_day": true, "patch_ids": ["d543638e0adb6ae160d3d75e0395599c"], "statement_hash": "f582eb5274a2c01036cb5b6f4a3ded9c5b8c09a05deadf030b6853753865523e"}}, {"rule": 2, "type": "equivalent", "target": "cc6825921e4ad8915cb866b0258595d5", "evidence": {"same_day": true, "patch_ids": ["d543638e0adb6ae160d3d75e0395599c"], "statement_hash": "f582eb5274a2c01036cb5b6f4a3ded9c5b8c09a05deadf030b6853753865523e"}}], "version": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "cc6825921e4ad8915cb866b0258595d5", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "In pg_restore, treat -f - as meaning “output to stdout”", "evidence": {"same_day": true, "patch_ids": ["d543638e0adb6ae160d3d75e0395599c"], "statement_hash": "f582eb5274a2c01036cb5b6f4a3ded9c5b8c09a05deadf030b6853753865523e"}, "url": "/docs/compare/?release=11.6#11.6-b6a994bd24b85675", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "71c71a9da18b3b766b2ead932528efd3", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "In pg_restore, treat -f - as meaning “output to stdout”", "evidence": {"same_day": true, "patch_ids": ["d543638e0adb6ae160d3d75e0395599c"], "statement_hash": "f582eb5274a2c01036cb5b6f4a3ded9c5b8c09a05deadf030b6853753865523e"}, "url": "/docs/compare/?release=10.11#10.11-b6a994bd24b85675", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "ba7b4d90e9c3137c7ff24eb2f08ea42e", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "In pg_restore, treat -f - as meaning \"output to stdout\"", "evidence": {"same_day": true, "patch_ids": ["d543638e0adb6ae160d3d75e0395599c"], "statement_hash": "f582eb5274a2c01036cb5b6f4a3ded9c5b8c09a05deadf030b6853753865523e"}, "url": "/docs/compare/?release=9.6.16#9.6.16-4ff2f6e3b66cd783", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "0fb06bb61933820ce109f1fb57a07095", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "In pg_restore, treat -f - as meaning \"output to stdout\"", "evidence": {"same_day": true, "patch_ids": ["d543638e0adb6ae160d3d75e0395599c"], "statement_hash": "f582eb5274a2c01036cb5b6f4a3ded9c5b8c09a05deadf030b6853753865523e"}, "url": "/docs/compare/?release=9.5.20#9.5.20-4ff2f6e3b66cd783", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-c10ea15b98e44886", "cves": [], "html": "Improve pg_upgrade's checks for the use of a data type that has changed representation, such as line (Tomas Vondra)
\nThe 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": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "779c9e76560879b185d9f4e804c89731f23ca02aa2344dfbf09decf55d1b9971", "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": ["235a52ca0", "a524f50d0", "bc3a94dc0"], "source_entry_id": "9.4.25/changes/030", "db_id": "ca14a9b1b159c7912770289654a6f0b9", "patch_ids": ["0e623a704a7e6eb0fc8d588ecdb76af5", "199f05d03ba135f80467a01b7586ee3c", "64e1457e23cab5d9aa9fd7e39ad09645"], "statement_hash": "270077457021aa52ded0d5d6bc4e1f642f17f2bf5810b6cb9111f6006f565dbb", "relations": [{"rule": 2, "type": "equivalent", "target": "00e22fc3b19209ebf05ca425b9ea27ba", "evidence": {"same_day": true, "patch_ids": ["0e623a704a7e6eb0fc8d588ecdb76af5", "199f05d03ba135f80467a01b7586ee3c", "64e1457e23cab5d9aa9fd7e39ad09645"], "statement_hash": "270077457021aa52ded0d5d6bc4e1f642f17f2bf5810b6cb9111f6006f565dbb"}}, {"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": "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": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "00e22fc3b19209ebf05ca425b9ea27ba", "kind": "equivalent", "version": "12.1", "label": "12.1", "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=12.1#12.1-3bb64889a255ec2b", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"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"}]}, {"id": "9.4.25-117e1389974cdf42", "cves": [], "html": "Detect file read errors during pg_basebackup (Jeevan Chalke)
", "text": "Detect file read errors during pg_basebackup (Jeevan Chalke)", "title": "Detect file read errors during pg_basebackup", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "e4a8c865d7f49838d1cec6415d413cb112949c0a0ca70e7f21555cdf5cc6b8e0", "section_path": ["Changes"], "commit_groups": [["23df88226", "286af0ce1", "61c65cce4", "62fb12d7e", "ce5542d40", "f697c6396", "fbe897134"]], "identity_text": "Detect file read errors during pg_basebackup (Jeevan Chalke)", "commit_aliases": ["23df88226", "286af0ce1", "61c65cce4", "62fb12d7e", "ce5542d40", "f697c6396", "fbe897134"], "source_commits": ["fbe897134"], "source_entry_id": "9.4.25/changes/031", "db_id": "258c9775688910c3b0b5f22d79157cac", "patch_ids": ["61a893d87c64c143bf77bc39db4d7181"], "statement_hash": "f87d772bb065b32875fa22f62fdb08b62afabc7444aae76fa7dd24a9054e5a53", "relations": [{"rule": 2, "type": "equivalent", "target": "303d2ad86d113dd352d311cff972705e", "evidence": {"same_day": true, "patch_ids": ["61a893d87c64c143bf77bc39db4d7181"], "statement_hash": "f87d772bb065b32875fa22f62fdb08b62afabc7444aae76fa7dd24a9054e5a53"}}, {"rule": 2, "type": "equivalent", "target": "501bcee82b34378967ee99427d8e3f38", "evidence": {"same_day": true, "patch_ids": ["61a893d87c64c143bf77bc39db4d7181"], "statement_hash": "f87d772bb065b32875fa22f62fdb08b62afabc7444aae76fa7dd24a9054e5a53"}}, {"rule": 2, "type": "equivalent", "target": "57919907177d18a2f65b3c2618a02b5e", "evidence": {"same_day": true, "patch_ids": ["61a893d87c64c143bf77bc39db4d7181"], "statement_hash": "f87d772bb065b32875fa22f62fdb08b62afabc7444aae76fa7dd24a9054e5a53"}}, {"rule": 2, "type": "equivalent", "target": "a534d37ecfc7a597eb6d4bf090e2b440", "evidence": {"same_day": true, "patch_ids": ["61a893d87c64c143bf77bc39db4d7181"], "statement_hash": "f87d772bb065b32875fa22f62fdb08b62afabc7444aae76fa7dd24a9054e5a53"}}], "version": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "57919907177d18a2f65b3c2618a02b5e", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Detect file read errors during pg_basebackup", "evidence": {"same_day": true, "patch_ids": ["61a893d87c64c143bf77bc39db4d7181"], "statement_hash": "f87d772bb065b32875fa22f62fdb08b62afabc7444aae76fa7dd24a9054e5a53"}, "url": "/docs/compare/?release=11.6#11.6-117e1389974cdf42", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "501bcee82b34378967ee99427d8e3f38", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Detect file read errors during pg_basebackup", "evidence": {"same_day": true, "patch_ids": ["61a893d87c64c143bf77bc39db4d7181"], "statement_hash": "f87d772bb065b32875fa22f62fdb08b62afabc7444aae76fa7dd24a9054e5a53"}, "url": "/docs/compare/?release=10.11#10.11-117e1389974cdf42", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "303d2ad86d113dd352d311cff972705e", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Detect file read errors during pg_basebackup", "evidence": {"same_day": true, "patch_ids": ["61a893d87c64c143bf77bc39db4d7181"], "statement_hash": "f87d772bb065b32875fa22f62fdb08b62afabc7444aae76fa7dd24a9054e5a53"}, "url": "/docs/compare/?release=9.6.16#9.6.16-117e1389974cdf42", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "a534d37ecfc7a597eb6d4bf090e2b440", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Detect file read errors during pg_basebackup", "evidence": {"same_day": true, "patch_ids": ["61a893d87c64c143bf77bc39db4d7181"], "statement_hash": "f87d772bb065b32875fa22f62fdb08b62afabc7444aae76fa7dd24a9054e5a53"}, "url": "/docs/compare/?release=9.5.20#9.5.20-117e1389974cdf42", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-58b2bacc74988fba", "cves": [], "html": "Fix failure in pg_waldump with the -s option, when a continuation WAL record ends exactly at a page boundary (Andrey Lepikhov)
", "text": "Fix failure in pg_waldump with the -s option, when a continuation WAL record ends exactly at a page boundary (Andrey Lepikhov)", "title": "Fix failure in pg_waldump with the -s option, when a continuation WAL record ends exactly at a page boundary", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "fe96d5bb3adf06b50d9becc2e0d8d97aa68ca43e4ed16f4302d282f11eeaffbc", "section_path": ["Changes"], "commit_groups": [["127ad57f5", "1accf9974", "a0c96856e", "aa7cd6a8e", "b1bebc2ce", "e5cfb8cbb", "fb53c4c07"]], "identity_text": "Fix failure in pg_waldump with the -s option, when a continuation WAL record ends exactly at a page boundary (Andrey Lepikhov)", "commit_aliases": ["127ad57f5", "1accf9974", "a0c96856e", "aa7cd6a8e", "b1bebc2ce", "e5cfb8cbb", "fb53c4c07"], "source_commits": ["1accf9974"], "source_entry_id": "9.4.25/changes/032", "db_id": "4970c4c81427d42399ce716c0f0f4018", "patch_ids": ["b228afe783c311b1b43ff90892a58071"], "statement_hash": "302d2abc8965cf0a3067b66c0e6a3c7efc31898b6f47fa1d7f7139557bff6272", "relations": [{"rule": 2, "type": "equivalent", "target": "2369fe2c2a869184066de21b760a4519", "evidence": {"same_day": true, "patch_ids": ["b228afe783c311b1b43ff90892a58071"], "statement_hash": "302d2abc8965cf0a3067b66c0e6a3c7efc31898b6f47fa1d7f7139557bff6272"}}, {"rule": 2, "type": "equivalent", "target": "574a674aabeb09a243b13790922c5efa", "evidence": {"same_day": true, "patch_ids": ["b228afe783c311b1b43ff90892a58071"], "statement_hash": "302d2abc8965cf0a3067b66c0e6a3c7efc31898b6f47fa1d7f7139557bff6272"}}, {"rule": 2, "type": "equivalent", "target": "a2dc04935e730e361e88365cbe325fda", "evidence": {"same_day": true, "patch_ids": ["b228afe783c311b1b43ff90892a58071"], "statement_hash": "302d2abc8965cf0a3067b66c0e6a3c7efc31898b6f47fa1d7f7139557bff6272"}}, {"rule": 2, "type": "equivalent", "target": "c1c6b5f65ea570a78790482b40d232d5", "evidence": {"same_day": true, "patch_ids": ["b228afe783c311b1b43ff90892a58071"], "statement_hash": "302d2abc8965cf0a3067b66c0e6a3c7efc31898b6f47fa1d7f7139557bff6272"}}, {"rule": 2, "type": "equivalent", "target": "e110397ffcad28e37fd7a3608aa6799f", "evidence": {"same_day": true, "patch_ids": ["b228afe783c311b1b43ff90892a58071"], "statement_hash": "302d2abc8965cf0a3067b66c0e6a3c7efc31898b6f47fa1d7f7139557bff6272"}}], "version": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c1c6b5f65ea570a78790482b40d232d5", "kind": "equivalent", "version": "12.1", "label": "12.1", "title": "Fix failure in pg_waldump with the -s option, when a continuation WAL record ends exactly at a page boundary", "evidence": {"same_day": true, "patch_ids": ["b228afe783c311b1b43ff90892a58071"], "statement_hash": "302d2abc8965cf0a3067b66c0e6a3c7efc31898b6f47fa1d7f7139557bff6272"}, "url": "/docs/compare/?release=12.1#12.1-fe030c8bef799a16", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"db_id": "a2dc04935e730e361e88365cbe325fda", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix failure in pg_waldump with the -s option, when a continuation WAL record ends exactly at a page boundary", "evidence": {"same_day": true, "patch_ids": ["b228afe783c311b1b43ff90892a58071"], "statement_hash": "302d2abc8965cf0a3067b66c0e6a3c7efc31898b6f47fa1d7f7139557bff6272"}, "url": "/docs/compare/?release=11.6#11.6-58b2bacc74988fba", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "2369fe2c2a869184066de21b760a4519", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Fix failure in pg_waldump with the -s option, when a continuation WAL record ends exactly at a page boundary", "evidence": {"same_day": true, "patch_ids": ["b228afe783c311b1b43ff90892a58071"], "statement_hash": "302d2abc8965cf0a3067b66c0e6a3c7efc31898b6f47fa1d7f7139557bff6272"}, "url": "/docs/compare/?release=10.11#10.11-58b2bacc74988fba", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "e110397ffcad28e37fd7a3608aa6799f", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Fix failure in pg_waldump with the -s option, when a continuation WAL record ends exactly at a page boundary", "evidence": {"same_day": true, "patch_ids": ["b228afe783c311b1b43ff90892a58071"], "statement_hash": "302d2abc8965cf0a3067b66c0e6a3c7efc31898b6f47fa1d7f7139557bff6272"}, "url": "/docs/compare/?release=9.6.16#9.6.16-58b2bacc74988fba", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "574a674aabeb09a243b13790922c5efa", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Fix failure in pg_waldump with the -s option, when a continuation WAL record ends exactly at a page boundary", "evidence": {"same_day": true, "patch_ids": ["b228afe783c311b1b43ff90892a58071"], "statement_hash": "302d2abc8965cf0a3067b66c0e6a3c7efc31898b6f47fa1d7f7139557bff6272"}, "url": "/docs/compare/?release=9.5.20#9.5.20-58b2bacc74988fba", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-3f122217ad9dcf0d", "cves": [], "html": "Fix contrib/intarray's GiST opclasses to not fail for empty arrays with <@ (Tom Lane)
\nA clause like array_column <@ constant_array is considered indexable, but the index search may not find empty array values; of course, such entries should trivially match the search.
\nThe only practical back-patchable fix for this requires making <@ index searches scan the whole index, which is what this patch does. This is unfortunate: it means that the query performance is likely worse than a plain sequential scan would be.
\nApplications whose performance is adversely impacted by this change have a couple of options. They could switch to a GIN index, which doesn't have this bug, or they could replace array_column <@ constant_array with array_column <@ constant_array AND array_column && constant_array. That will provide about the same performance as before, and it will find all non-empty subsets of the given constant array, which is all that could reliably be expected of the query before.
", "text": "Fix contrib/intarray's GiST opclasses to not fail for empty arrays with <@ (Tom Lane) A clause like array_column <@ constant_array is considered indexable, but the index search may not find empty array values; of course, such entries should trivially match the search. The only practical back-patchable fix for this requires making <@ index searches scan the whole index, which is what this patch does. This is unfortunate: it means that the query performance is likely worse than a plain sequential scan would be. Applications whose performance is adversely impacted by this change have a couple of options. They could switch to a GIN index, which doesn't have this bug, or they could replace array_column <@ constant_array with array_column <@ constant_array AND array_column && constant_array. That will provide about the same performance as before, and it will find all non-empty subsets of the given constant array, which is all that could reliably be expected of the query before.", "title": "Fix contrib/intarray's GiST opclasses to not fail for empty arrays with <@", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "5b20dde1a7286d20e4b65e8f835c9e3d40171c2337a7e5da3780ff30e1b07fb8", "section_path": ["Changes"], "commit_groups": [["113b3d903", "2f76f4182", "5b3e6c13f", "614119d00", "ced272d2d", "e519eded6", "efc77cf5f"]], "identity_text": "Fix contrib/intarray's GiST opclasses to not fail for empty arrays with <@ (Tom Lane) A clause like array_column <@ constant_array is considered indexable, but the index search may not find empty array values; of course, such entries should trivially match the search. The only practical back-patchable fix for this requires making <@ index searches scan the whole index, which is what this patch does. This is unfortunate: it means that the query performance is likely worse than a plain sequential scan would be. Applications whose performance is adversely impacted by this change have a couple of options. They could switch to a GIN index, which doesn't have this bug, or they could replace array_column <@ constant_array with array_column <@ constant_array AND array_column && constant_array. That will provide about the same performance as before, and it will find all non-empty subsets of the given constant array, which is all that could reliably be expected of the query before.", "commit_aliases": ["113b3d903", "2f76f4182", "5b3e6c13f", "614119d00", "ced272d2d", "e519eded6", "efc77cf5f"], "source_commits": ["614119d00"], "source_entry_id": "9.4.25/changes/033", "db_id": "85ba616e74f33ab854bbdba4c2efb25a", "patch_ids": ["a31fe9b8f8907f88284116f7ea7acc4a"], "statement_hash": "00dc80375dc59960aae1c99004068ad1481c61dfaff14bdf361701e252e9d80e", "relations": [{"rule": 2, "type": "equivalent", "target": "095d1b932d2c8b19ac2c80541fa441c9", "evidence": {"same_day": true, "patch_ids": ["a31fe9b8f8907f88284116f7ea7acc4a"], "statement_hash": "00dc80375dc59960aae1c99004068ad1481c61dfaff14bdf361701e252e9d80e"}}, {"rule": 2, "type": "equivalent", "target": "1c9f43f55f1b5b56c782ba572b576692", "evidence": {"same_day": true, "patch_ids": ["a31fe9b8f8907f88284116f7ea7acc4a"], "statement_hash": "00dc80375dc59960aae1c99004068ad1481c61dfaff14bdf361701e252e9d80e"}}, {"rule": 2, "type": "equivalent", "target": "3aca8549b51328708bd5a5bf23277edc", "evidence": {"same_day": true, "patch_ids": ["a31fe9b8f8907f88284116f7ea7acc4a"], "statement_hash": "00dc80375dc59960aae1c99004068ad1481c61dfaff14bdf361701e252e9d80e"}}, {"rule": 2, "type": "equivalent", "target": "73e885c18b9f26670dcde44f3cce58b1", "evidence": {"same_day": true, "patch_ids": ["a31fe9b8f8907f88284116f7ea7acc4a"], "statement_hash": "00dc80375dc59960aae1c99004068ad1481c61dfaff14bdf361701e252e9d80e"}}], "version": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "3aca8549b51328708bd5a5bf23277edc", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix contrib/intarray's GiST opclasses to not fail for empty arrays with <@", "evidence": {"same_day": true, "patch_ids": ["a31fe9b8f8907f88284116f7ea7acc4a"], "statement_hash": "00dc80375dc59960aae1c99004068ad1481c61dfaff14bdf361701e252e9d80e"}, "url": "/docs/compare/?release=11.6#11.6-3f122217ad9dcf0d", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "095d1b932d2c8b19ac2c80541fa441c9", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Fix contrib/intarray's GiST opclasses to not fail for empty arrays with <@", "evidence": {"same_day": true, "patch_ids": ["a31fe9b8f8907f88284116f7ea7acc4a"], "statement_hash": "00dc80375dc59960aae1c99004068ad1481c61dfaff14bdf361701e252e9d80e"}, "url": "/docs/compare/?release=10.11#10.11-3f122217ad9dcf0d", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "73e885c18b9f26670dcde44f3cce58b1", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Fix contrib/intarray's GiST opclasses to not fail for empty arrays with <@", "evidence": {"same_day": true, "patch_ids": ["a31fe9b8f8907f88284116f7ea7acc4a"], "statement_hash": "00dc80375dc59960aae1c99004068ad1481c61dfaff14bdf361701e252e9d80e"}, "url": "/docs/compare/?release=9.6.16#9.6.16-3f122217ad9dcf0d", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "1c9f43f55f1b5b56c782ba572b576692", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Fix contrib/intarray's GiST opclasses to not fail for empty arrays with <@", "evidence": {"same_day": true, "patch_ids": ["a31fe9b8f8907f88284116f7ea7acc4a"], "statement_hash": "00dc80375dc59960aae1c99004068ad1481c61dfaff14bdf361701e252e9d80e"}, "url": "/docs/compare/?release=9.5.20#9.5.20-3f122217ad9dcf0d", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-ddabe02d733cbe5a", "cves": [], "html": "Allow configure --with-python to succeed when only python3 or only python2 can be found (Peter Eisentraut, Tom Lane)
\nSearch for python, then python3, then python2, so that configure can succeed in the increasingly-more-common situation where there is no executable named simply python. It's still possible to override this choice by setting the PYTHON environment variable.
", "text": "Allow configure --with-python to succeed when only python3 or only python2 can be found (Peter Eisentraut, Tom Lane) Search for python, then python3, then python2, so that configure can succeed in the increasingly-more-common situation where there is no executable named simply python. It's still possible to override this choice by setting the PYTHON environment variable.", "title": "Allow configure --with-python to succeed when only python3 or only python2 can be found", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "1c0c4abba217aaa76a382ebfc49f1901740d4c2bcce14c4f06b5dd66c64d9856", "section_path": ["Changes"], "commit_groups": [["96db9d5e2", "984ee0f6d", "f1a9abe61"]], "identity_text": "Allow configure --with-python to succeed when only python3 or only python2 can be found (Peter Eisentraut, Tom Lane) Search for python, then python3, then python2, so that configure can succeed in the increasingly-more-common situation where there is no executable named simply python. It's still possible to override this choice by setting the PYTHON environment variable.", "commit_aliases": ["96db9d5e2", "984ee0f6d", "f1a9abe61"], "source_commits": ["96db9d5e2"], "source_entry_id": "9.4.25/changes/034", "db_id": "402012e19ec0ab9ed28e6b4682d0dc8c", "patch_ids": ["67e39a6692bba2774bdcd45ec25628cc"], "statement_hash": "0b6ed230208cb419a97099405b5fd274b68c6581e22964080fe9d5022dfb7076", "relations": [{"rule": 2, "type": "equivalent", "target": "57f02b51b8d7f7427037ab5b1ef0526b", "evidence": {"same_day": true, "patch_ids": ["67e39a6692bba2774bdcd45ec25628cc"], "statement_hash": "0b6ed230208cb419a97099405b5fd274b68c6581e22964080fe9d5022dfb7076"}}, {"rule": 2, "type": "equivalent", "target": "5d3feaf75fa18f816dca6ddded915455", "evidence": {"same_day": true, "patch_ids": ["67e39a6692bba2774bdcd45ec25628cc"], "statement_hash": "0b6ed230208cb419a97099405b5fd274b68c6581e22964080fe9d5022dfb7076"}}], "version": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "57f02b51b8d7f7427037ab5b1ef0526b", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Allow configure --with-python to succeed when only python3 or only python2 can be found", "evidence": {"same_day": true, "patch_ids": ["67e39a6692bba2774bdcd45ec25628cc"], "statement_hash": "0b6ed230208cb419a97099405b5fd274b68c6581e22964080fe9d5022dfb7076"}, "url": "/docs/compare/?release=9.6.16#9.6.16-ddabe02d733cbe5a", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "5d3feaf75fa18f816dca6ddded915455", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Allow configure --with-python to succeed when only python3 or only python2 can be found", "evidence": {"same_day": true, "patch_ids": ["67e39a6692bba2774bdcd45ec25628cc"], "statement_hash": "0b6ed230208cb419a97099405b5fd274b68c6581e22964080fe9d5022dfb7076"}, "url": "/docs/compare/?release=9.5.20#9.5.20-ddabe02d733cbe5a", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-297ebba5b0d1ef73", "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.
", "text": "Fix configure's test for presence of libperl so that it works on recent Red Hat releases (Tom Lane) Previously, it could fail if the user sets CFLAGS to -O0.", "title": "Fix configure's test for presence of libperl so that it works on recent Red Hat releases", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "162e3f4919732025e8b946406a88af63616bf54c4e4058b1f024ae346f5e831b", "section_path": ["Changes"], "commit_groups": [["11330c311", "44273ce4f", "62ca50ad7", "727c2ccfe", "99c51d5ed", "aa5bb828a", "e167b1ae3"], ["328b81348", "34621cb12", "4e19bd41d", "6d2b18d07", "8835e0bd4", "ca658c91a", "d995fd667"]], "identity_text": "Fix configure's test for presence of libperl so that it works on recent Red Hat releases (Tom Lane) Previously, it could fail if the user sets CFLAGS to -O0.", "commit_aliases": ["11330c311", "328b81348", "34621cb12", "44273ce4f", "4e19bd41d", "62ca50ad7", "6d2b18d07", "727c2ccfe", "8835e0bd4", "99c51d5ed", "aa5bb828a", "ca658c91a", "d995fd667", "e167b1ae3"], "source_commits": ["6d2b18d07", "727c2ccfe"], "source_entry_id": "9.4.25/changes/035", "db_id": "c7cf81b808f75cf9c89123e47accd94d", "patch_ids": ["446147c285dc903dc3e4faf62644ce57", "6f6aa2e2923a811aa937c950e3174c37"], "statement_hash": "51afeab0645fe6584ab15ccc885ccc13c3eac17780ec49fd2b35619f90f68451", "relations": [{"rule": 2, "type": "equivalent", "target": "212dc5fe34c06a25c876b16b320e5689", "evidence": {"same_day": true, "patch_ids": ["446147c285dc903dc3e4faf62644ce57", "6f6aa2e2923a811aa937c950e3174c37"], "statement_hash": "51afeab0645fe6584ab15ccc885ccc13c3eac17780ec49fd2b35619f90f68451"}}, {"rule": 2, "type": "equivalent", "target": "25d5d7c59f2689f4c06c495b36e8d802", "evidence": {"same_day": true, "patch_ids": ["446147c285dc903dc3e4faf62644ce57", "6f6aa2e2923a811aa937c950e3174c37"], "statement_hash": "51afeab0645fe6584ab15ccc885ccc13c3eac17780ec49fd2b35619f90f68451"}}, {"rule": 2, "type": "equivalent", "target": "725903f3b8afeb5774cf49246f3755a9", "evidence": {"same_day": true, "patch_ids": ["446147c285dc903dc3e4faf62644ce57", "6f6aa2e2923a811aa937c950e3174c37"], "statement_hash": "51afeab0645fe6584ab15ccc885ccc13c3eac17780ec49fd2b35619f90f68451"}}, {"rule": 2, "type": "equivalent", "target": "75230e6bbe167a096994950e2e09aadf", "evidence": {"same_day": true, "patch_ids": ["446147c285dc903dc3e4faf62644ce57", "6f6aa2e2923a811aa937c950e3174c37"], "statement_hash": "51afeab0645fe6584ab15ccc885ccc13c3eac17780ec49fd2b35619f90f68451"}}, {"rule": 2, "type": "equivalent", "target": "e65a0bcc76d2449ccb89d3f468ee1eff", "evidence": {"same_day": true, "patch_ids": ["446147c285dc903dc3e4faf62644ce57", "6f6aa2e2923a811aa937c950e3174c37"], "statement_hash": "51afeab0645fe6584ab15ccc885ccc13c3eac17780ec49fd2b35619f90f68451"}}], "version": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "e65a0bcc76d2449ccb89d3f468ee1eff", "kind": "equivalent", "version": "12.1", "label": "12.1", "title": "Fix configure's test for presence of libperl so that it works on recent Red Hat releases", "evidence": {"same_day": true, "patch_ids": ["446147c285dc903dc3e4faf62644ce57", "6f6aa2e2923a811aa937c950e3174c37"], "statement_hash": "51afeab0645fe6584ab15ccc885ccc13c3eac17780ec49fd2b35619f90f68451"}, "url": "/docs/compare/?release=12.1#12.1-99f6039b4eeef498", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"db_id": "25d5d7c59f2689f4c06c495b36e8d802", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Fix configure's test for presence of libperl so that it works on recent Red Hat releases", "evidence": {"same_day": true, "patch_ids": ["446147c285dc903dc3e4faf62644ce57", "6f6aa2e2923a811aa937c950e3174c37"], "statement_hash": "51afeab0645fe6584ab15ccc885ccc13c3eac17780ec49fd2b35619f90f68451"}, "url": "/docs/compare/?release=11.6#11.6-297ebba5b0d1ef73", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "75230e6bbe167a096994950e2e09aadf", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Fix configure's test for presence of libperl so that it works on recent Red Hat releases", "evidence": {"same_day": true, "patch_ids": ["446147c285dc903dc3e4faf62644ce57", "6f6aa2e2923a811aa937c950e3174c37"], "statement_hash": "51afeab0645fe6584ab15ccc885ccc13c3eac17780ec49fd2b35619f90f68451"}, "url": "/docs/compare/?release=10.11#10.11-297ebba5b0d1ef73", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "212dc5fe34c06a25c876b16b320e5689", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Fix configure's test for presence of libperl so that it works on recent Red Hat releases", "evidence": {"same_day": true, "patch_ids": ["446147c285dc903dc3e4faf62644ce57", "6f6aa2e2923a811aa937c950e3174c37"], "statement_hash": "51afeab0645fe6584ab15ccc885ccc13c3eac17780ec49fd2b35619f90f68451"}, "url": "/docs/compare/?release=9.6.16#9.6.16-297ebba5b0d1ef73", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "725903f3b8afeb5774cf49246f3755a9", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Fix configure's test for presence of libperl so that it works on recent Red Hat releases", "evidence": {"same_day": true, "patch_ids": ["446147c285dc903dc3e4faf62644ce57", "6f6aa2e2923a811aa937c950e3174c37"], "statement_hash": "51afeab0645fe6584ab15ccc885ccc13c3eac17780ec49fd2b35619f90f68451"}, "url": "/docs/compare/?release=9.5.20#9.5.20-297ebba5b0d1ef73", "source_url": "/docs/release/9.5.20/#AEN128082"}]}, {"id": "9.4.25-4a277fab794acf32", "cves": [], "html": "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": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "b227f227d9b68ad51d4d6838edcabcec579b15510d6d0dfb9d7b14910d52536e", "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": ["930787c7f"], "source_entry_id": "9.4.25/changes/036", "db_id": "2c2c8ac71213410432d41370129ec1b1", "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": "30f686bb56c6183a946651745f6076b2", "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": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "30f686bb56c6183a946651745f6076b2", "kind": "equivalent", "version": "12.1", "label": "12.1", "title": "Ensure correct code generation for spinlocks on PowerPC", "evidence": {"same_day": true, "patch_ids": ["9e49644de8f316d79e920bb5c0ebf3b5"], "statement_hash": "fdd4a033e7ba3da61f1339c7ba266b5f8e802311fc4b0c72df81a5ede463a994"}, "url": "/docs/compare/?release=12.1#12.1-afaf21c56e603ca4", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"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"}]}, {"id": "9.4.25-c38156af66d97f9e", "cves": [], "html": "On AIX, don't use the compiler option -qsrcmsg (Noah Misch)
\nThis 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": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "39ed5724b71066b5e98f583d9e5d8f8bbc1cd1a787d88bcb595dfdce0bae3b96", "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": ["b705582b4"], "source_entry_id": "9.4.25/changes/037", "db_id": "416b05485065dc8bf461bb9a38cea5d5", "patch_ids": ["1599bea98b7d92f4dc430eb31aab3c06"], "statement_hash": "0435870f8b6f137509a3cee94109abae59caa3c0c4b218a4acb90dcba10d8b6c", "relations": [{"rule": 2, "type": "equivalent", "target": "5ff20ba9783100b29d6a950489beaf5c", "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": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "5ff20ba9783100b29d6a950489beaf5c", "kind": "equivalent", "version": "12.1", "label": "12.1", "title": "On AIX, don't use the compiler option -qsrcmsg", "evidence": {"same_day": true, "patch_ids": ["1599bea98b7d92f4dc430eb31aab3c06"], "statement_hash": "0435870f8b6f137509a3cee94109abae59caa3c0c4b218a4acb90dcba10d8b6c"}, "url": "/docs/compare/?release=12.1#12.1-95ff6454bde5ffe3", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"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"}]}, {"id": "9.4.25-e6f5b6f58d22adf5", "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": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "9c01c5e2e241ec7cb4a6e1d5766d44ff9d8a23c2a89a02a29b311832b871b86d", "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": ["8f8809091"], "source_entry_id": "9.4.25/changes/038", "db_id": "b15b4c64c40679e329e5756bfde4fbd6", "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": "928237d2a0d6a7f0f1d701177479ae8f", "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"}}], "version": "9.4.25", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "928237d2a0d6a7f0f1d701177479ae8f", "kind": "equivalent", "version": "12.1", "label": "12.1", "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=12.1#12.1-e3ccc580f9073809", "source_url": "/docs/release/12.1/#id-1.11.6.27.5"}, {"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"}]}, {"id": "9.4.25-bb98f9741f3da790", "cves": [], "html": "Update time zone data files to tzdata release 2019c for DST law changes in Fiji and Norfolk Island, plus historical corrections for Alberta, Austria, Belgium, British Columbia, Cambodia, Hong Kong, Indiana (Perry County), Kaliningrad, Kentucky, Michigan, Norfolk Island, South Korea, and Turkey.
", "text": "Update time zone data files to tzdata release 2019c for DST law changes in Fiji and Norfolk Island, plus historical corrections for Alberta, Austria, Belgium, British Columbia, Cambodia, Hong Kong, Indiana (Perry County), Kaliningrad, Kentucky, Michigan, Norfolk Island, South Korea, and Turkey.", "title": "Update time zone data files to tzdata release 2019c for DST law changes in Fiji and Norfolk Island, plus historical corrections for Alberta, Austria, Belgium, British Columbia, Cambodia, Hong Kong, Indiana (Perry County), Kaliningrad, Kentucky, Michigan, Norfolk Island, South Korea, and Turkey.", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.25/#AEN119951", "source_hash": "d02f73bf5785c1b98494f015c8055e45f1917ecc5c79ea4c85eb4e5055ff0cb7", "section_path": ["Changes"], "commit_groups": [["0bd64398e", "128abdef7", "24f64fba0", "2966e30e5", "29e47f83c", "769802ef9", "df4fbcd89"]], "identity_text": "Update time zone data files to tzdata release 2019c for DST law changes in Fiji and Norfolk Island, plus historical corrections for Alberta, Austria, Belgium, British Columbia, Cambodia, Hong Kong, Indiana (Perry County), Kaliningrad, Kentucky, Michigan, Norfolk Island, South Korea, and Turkey.", "commit_aliases": ["0bd64398e", "128abdef7", "24f64fba0", "2966e30e5", "29e47f83c", "769802ef9", "df4fbcd89"], "source_commits": ["29e47f83c"], "source_entry_id": "9.4.25/changes/039", "db_id": "5c4afc1a6f1af55d60cf633c13667ff3", "patch_ids": ["96b1ee10cb19eac730ff645a2ba36d15"], "statement_hash": "bf411d5dcf240ec41fce05ed6b498d7ecc24166e34da9e8742cc8584e49a4938", "relations": [{"rule": 2, "type": "equivalent", "target": "19e801c0f3b869957d5fab96c808e535", "evidence": {"same_day": true, "patch_ids": ["96b1ee10cb19eac730ff645a2ba36d15"], "statement_hash": "bf411d5dcf240ec41fce05ed6b498d7ecc24166e34da9e8742cc8584e49a4938"}}, {"rule": 2, "type": "equivalent", "target": "5b019aeb828713edb1e7e8cca7ae1621", "evidence": {"same_day": true, "patch_ids": ["96b1ee10cb19eac730ff645a2ba36d15"], "statement_hash": "bf411d5dcf240ec41fce05ed6b498d7ecc24166e34da9e8742cc8584e49a4938"}}, {"rule": 2, "type": "equivalent", "target": "8394234783f7c63cdd763ddbe772912d", "evidence": {"same_day": true, "patch_ids": ["96b1ee10cb19eac730ff645a2ba36d15"], "statement_hash": "bf411d5dcf240ec41fce05ed6b498d7ecc24166e34da9e8742cc8584e49a4938"}}, {"rule": 2, "type": "equivalent", "target": "ae92e6f03f6ea389f065a100e97c9eb6", "evidence": {"same_day": true, "patch_ids": ["96b1ee10cb19eac730ff645a2ba36d15"], "statement_hash": "bf411d5dcf240ec41fce05ed6b498d7ecc24166e34da9e8742cc8584e49a4938"}}], "version": "9.4.25", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "8394234783f7c63cdd763ddbe772912d", "kind": "equivalent", "version": "11.6", "label": "11.6", "title": "Update time zone data files to tzdata release 2019c for DST law changes in Fiji and Norfolk Island, plus historical corrections for Alberta, Austria, Belgium, British Columbia, Cambodia, Hong Kong, Indiana (Perry County), Kaliningrad, Kentucky, Michigan, Norfolk Island, South Korea, and Turkey.", "evidence": {"same_day": true, "patch_ids": ["96b1ee10cb19eac730ff645a2ba36d15"], "statement_hash": "bf411d5dcf240ec41fce05ed6b498d7ecc24166e34da9e8742cc8584e49a4938"}, "url": "/docs/compare/?release=11.6#11.6-bb98f9741f3da790", "source_url": "/docs/release/11.6/#id-1.11.6.21.5"}, {"db_id": "ae92e6f03f6ea389f065a100e97c9eb6", "kind": "equivalent", "version": "10.11", "label": "10.11", "title": "Update time zone data files to tzdata release 2019c for DST law changes in Fiji and Norfolk Island, plus historical corrections for Alberta, Austria, Belgium, British Columbia, Cambodia, Hong Kong, Indiana (Perry County), Kaliningrad, Kentucky, Michigan, Norfolk Island, South Korea, and Turkey.", "evidence": {"same_day": true, "patch_ids": ["96b1ee10cb19eac730ff645a2ba36d15"], "statement_hash": "bf411d5dcf240ec41fce05ed6b498d7ecc24166e34da9e8742cc8584e49a4938"}, "url": "/docs/compare/?release=10.11#10.11-bb98f9741f3da790", "source_url": "/docs/release/10.11/#id-1.11.6.17.5"}, {"db_id": "19e801c0f3b869957d5fab96c808e535", "kind": "equivalent", "version": "9.6.16", "label": "9.6.16", "title": "Update time zone data files to tzdata release 2019c for DST law changes in Fiji and Norfolk Island, plus historical corrections for Alberta, Austria, Belgium, British Columbia, Cambodia, Hong Kong, Indiana (Perry County), Kaliningrad, Kentucky, Michigan, Norfolk Island, South Korea, and Turkey.", "evidence": {"same_day": true, "patch_ids": ["96b1ee10cb19eac730ff645a2ba36d15"], "statement_hash": "bf411d5dcf240ec41fce05ed6b498d7ecc24166e34da9e8742cc8584e49a4938"}, "url": "/docs/compare/?release=9.6.16#9.6.16-bb98f9741f3da790", "source_url": "/docs/release/9.6.16/#AEN133252"}, {"db_id": "5b019aeb828713edb1e7e8cca7ae1621", "kind": "equivalent", "version": "9.5.20", "label": "9.5.20", "title": "Update time zone data files to tzdata release 2019c for DST law changes in Fiji and Norfolk Island, plus historical corrections for Alberta, Austria, Belgium, British Columbia, Cambodia, Hong Kong, Indiana (Perry County), Kaliningrad, Kentucky, Michigan, Norfolk Island, South Korea, and Turkey.", "evidence": {"same_day": true, "patch_ids": ["96b1ee10cb19eac730ff645a2ba36d15"], "statement_hash": "bf411d5dcf240ec41fce05ed6b498d7ecc24166e34da9e8742cc8584e49a4938"}, "url": "/docs/compare/?release=9.5.20#9.5.20-bb98f9741f3da790", "source_url": "/docs/release/9.5.20/#AEN128082"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 39}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 17}, {"key": "security", "label": "Security", "count": 0}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 22}], "total": 39, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 39, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}