A dump/restore is not required for those running 16.X.
\nHowever, if you are upgrading from a version earlier than 16.5, see Section E.11.
", "compatibility_count": 0, "label": "16.7", "status_label": "Supported", "eol": "2028-11-09", "age_days": 593, "support_days": 772}, "groups": [{"date": "2025-02-13", "build": "16.7", "major": "16", "minor": 7, "manual": "16", "status": "stable", "doc_git": "", "version": "16.7", "eol_date": "2028-11-09", "date_text": "2025-02-13", "supported": true, "manual_url": "/docs/16/release-16-7.html", "source_url": "/docs/release/16.7/", "entry_count": 55, "placeholder": false, "content_hash": "4159102352f3e8e9b0d2d1f6dc0a75d0312774bfc3db18e038795200909da7f7", "manual_build": "16.15", "source_as_of": "", "changes_count": 55, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 16.X.
\nHowever, if you are upgrading from a version earlier than 16.5, see Section E.11.
", "compatibility_count": 0, "label": "16.7", "status_label": "Supported", "eol": "2028-11-09", "age_days": 593, "support_days": 772, "entries": [{"id": "16.7-76a3b23ceb65c9a6", "cves": ["CVE-2025-1094"], "html": "Harden PQescapeString and allied functions against invalidly-encoded input strings (Andres Freund, Noah Misch) § § § § § §
Data-quoting functions supplied by libpq now fully check the encoding validity of their input. If invalid characters are detected, they report an error if possible. For the ones that lack an error return convention, the output string is adjusted to ensure that the server will report invalid encoding and no intervening processing will be fooled by bytes that might happen to match single quote, backslash, etc.
\nThe purpose of this change is to guard against SQL-injection attacks that are possible if one of these functions is used to quote crafted input. There is no hazard when the resulting string is sent directly to a PostgreSQL server (which would check its encoding anyway), but there is a risk when it is passed through psql or other client-side code. Historically such code has not carefully vetted encoding, and in many cases it's not clear what it should do if it did detect such a problem.
\nThis fix is effective only if the data-quoting function, the server, and any intermediate processing agree on the character encoding that's being used. Applications that insert untrusted input into SQL commands should take special care to ensure that that's true.
\nApplications and drivers that quote untrusted input without using these libpq functions may be at risk of similar problems. They should first confirm the data is valid in the encoding expected by the server.
\nThe PostgreSQL Project thanks Stephen Fewer for reporting this problem. (CVE-2025-1094)
", "text": "Harden PQescapeString and allied functions against invalidly-encoded input strings (Andres Freund, Noah Misch) § § § § § § Data-quoting functions supplied by libpq now fully check the encoding validity of their input. If invalid characters are detected, they report an error if possible. For the ones that lack an error return convention, the output string is adjusted to ensure that the server will report invalid encoding and no intervening processing will be fooled by bytes that might happen to match single quote, backslash, etc. The purpose of this change is to guard against SQL-injection attacks that are possible if one of these functions is used to quote crafted input. There is no hazard when the resulting string is sent directly to a PostgreSQL server (which would check its encoding anyway), but there is a risk when it is passed through psql or other client-side code. Historically such code has not carefully vetted encoding, and in many cases it's not clear what it should do if it did detect such a problem. This fix is effective only if the data-quoting function, the server, and any intermediate processing agree on the character encoding that's being used. Applications that insert untrusted input into SQL commands should take special care to ensure that that's true. Applications and drivers that quote untrusted input without using these libpq functions may be at risk of similar problems. They should first confirm the data is valid in the encoding expected by the server. The PostgreSQL Project thanks Stephen Fewer for reporting this problem. (CVE-2025-1094)", "title": "Harden PQescapeString and allied functions against invalidly-encoded input strings", "commits": ["0075a5c6c", "01784793f", "41343f840", "56aa2dcdd", "6e05b195d", "92e4170f4"], "section": "Changes", "category": "security", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "fa5f8d2e04b9d7d5265ed9fe38f61537073bef7a70cb881695a57b9c712a5a17", "section_path": ["Changes"], "commit_groups": [["0075a5c6c", "5bf12323b", "85c1fcc65", "9862de917", "e1f1b030d", "f9fceef6e"], ["00f1a1f66"], ["01784793f", "02d4d87ac", "46ddf98df", "4ea3f5ef3", "ac00ff1c9", "de4b92f33"], ["05abb0f83", "41343f840", "4a6825c76", "7beb2af5e", "979205e47", "a085fa731"], ["2ae54ae17", "3e98c8ce5", "56aa2dcdd", "5df4e1632", "61ad93cdd", "b1756da75"], ["370c94d4c", "43a77239d", "5dc1e42b4", "92e4170f4", "c906bfe1b", "e0ef3d776"], ["4dc289635", "5bc33cbea", "6e05b195d", "703b3fd5d", "7d43ca6fe", "db3eb0e82"]], "identity_text": "Harden PQescapeString and allied functions against invalidly-encoded input strings (Andres Freund, Noah Misch) Data-quoting functions supplied by libpq now fully check the encoding validity of their input. If invalid characters are detected, they report an error if possible. For the ones that lack an error return convention, the output string is adjusted to ensure that the server will report invalid encoding and no intervening processing will be fooled by bytes that might happen to match single quote, backslash, etc. The purpose of this change is to guard against SQL-injection attacks that are possible if one of these functions is used to quote crafted input. There is no hazard when the resulting string is sent directly to a PostgreSQL server (which would check its encoding anyway), but there is a risk when it is passed through psql or other client-side code. Historically such code has not carefully vetted encoding, and in many cases it's not clear what it should do if it did detect such a problem. This fix is effective only if the data-quoting function, the server, and any intermediate processing agree on the character encoding that's being used. Applications that insert untrusted input into SQL commands should take special care to ensure that that's true. Applications and drivers that quote untrusted input without using these libpq functions may be at risk of similar problems. They should first confirm the data is valid in the encoding expected by the server. The PostgreSQL Project thanks Stephen Fewer for reporting this problem. (CVE-2025-1094)", "commit_aliases": ["0075a5c6c", "00f1a1f66", "01784793f", "02d4d87ac", "05abb0f83", "2ae54ae17", "370c94d4c", "3e98c8ce5", "41343f840", "43a77239d", "46ddf98df", "4a6825c76", "4dc289635", "4ea3f5ef3", "56aa2dcdd", "5bc33cbea", "5bf12323b", "5dc1e42b4", "5df4e1632", "61ad93cdd", "6e05b195d", "703b3fd5d", "7beb2af5e", "7d43ca6fe", "85c1fcc65", "92e4170f4", "979205e47", "9862de917", "a085fa731", "ac00ff1c9", "b1756da75", "c906bfe1b", "db3eb0e82", "de4b92f33", "e0ef3d776", "e1f1b030d", "f9fceef6e"], "source_commits": ["0075a5c6c", "00f1a1f66", "01784793f", "41343f840", "56aa2dcdd", "6e05b195d", "92e4170f4"], "source_entry_id": "16.7/changes/001", "db_id": "90ded14b63ff2f1ce6a02628434a92b8", "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510", "relations": [{"rule": 2, "type": "equivalent", "target": "c67f7d11537493045db911b0c721db16", "evidence": {"same_day": true, "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510"}}, {"rule": 2, "type": "equivalent", "target": "d394c7dd9345d5f8b712225bcd0d756b", "evidence": {"same_day": true, "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510"}}, {"rule": 2, "type": "equivalent", "target": "f13ab6baf3e95ab97b902e09323ae11f", "evidence": {"same_day": true, "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510"}}, {"rule": 2, "type": "equivalent", "target": "f649b02262a5f42707d74fc679509c8c", "evidence": {"same_day": true, "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510"}}], "version": "16.7", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "d394c7dd9345d5f8b712225bcd0d756b", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Harden PQescapeString and allied functions against invalidly-encoded input strings", "evidence": {"same_day": true, "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510"}, "url": "/docs/compare/?release=17.3#17.3-ec56c13500d18830", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "f649b02262a5f42707d74fc679509c8c", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Harden PQescapeString and allied functions against invalidly-encoded input strings", "evidence": {"same_day": true, "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510"}, "url": "/docs/compare/?release=15.11#15.11-ed0b0c5a5ce7c384", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "c67f7d11537493045db911b0c721db16", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Harden PQescapeString and allied functions against invalidly-encoded input strings", "evidence": {"same_day": true, "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510"}, "url": "/docs/compare/?release=14.16#14.16-84a4341a43ed7fd0", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "f13ab6baf3e95ab97b902e09323ae11f", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Harden PQescapeString and allied functions against invalidly-encoded input strings", "evidence": {"same_day": true, "patch_ids": ["36d050a352e3681f016aae85ff33c242", "42bd3444d87759f098d683bb0621758f", "68db3958432c71bd49dc86922fdd9429", "a77ed2598533109291af8fa46693bc0f", "cb6e008bedd5c5651ea8f3a6308364cd", "ccab9b95f046d8825dd5e7383acac8d9", "cf569d785ea56dc3e8e51265eb2a2173"], "statement_hash": "3c8d46a332df9f37c7dd23c123b5dd02657355e121999f59dd6c72e35750c510"}, "url": "/docs/compare/?release=13.19#13.19-53e824654163768f", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-5d0e5552310bdb12", "cves": [], "html": "Exclude parallel workers from connection privilege checks and limits (Tom Lane) §
\nDo not check datallowconn, rolcanlogin, and ACL_CONNECT privileges when starting a parallel worker, instead assuming that it's enough for the leader process to have passed similar checks originally. This avoids, for example, unexpected failures of parallelized queries when the leader is running as a role that lacks login privilege. In the same vein, enforce ReservedConnections, datconnlimit, and rolconnlimit limits only against regular backends, and count only regular backends while checking if the limits were already reached. Those limits are meant to prevent excessive consumption of process slots for regular backends --- but parallel workers and other special processes have their own pools of process slots with their own limit checks.
Fix possible re-use of stale results in window aggregates (David Rowley) §
\nA window aggregate with a “run condition” optimization and a pass-by-reference result type might incorrectly return the result from the previous partition instead of performing a fresh calculation.
", "text": "Fix possible re-use of stale results in window aggregates (David Rowley) § A window aggregate with a “run condition” optimization and a pass-by-reference result type might incorrectly return the result from the previous partition instead of performing a fresh calculation.", "title": "Fix possible re-use of stale results in window aggregates", "commits": ["c1d6506ac"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "ffaa5585cbf1f8246ae58d057b39d9726d90f1ffe2165a3fcdd65bde7c2e48cb", "section_path": ["Changes"], "commit_groups": [["1fe5a347e", "9d5ce4f1a", "c1d6506ac", "d54378e98"]], "identity_text": "Fix possible re-use of stale results in window aggregates (David Rowley) A window aggregate with a run condition optimization and a pass-by-reference result type might incorrectly return the result from the previous partition instead of performing a fresh calculation.", "commit_aliases": ["1fe5a347e", "9d5ce4f1a", "c1d6506ac", "d54378e98"], "source_commits": ["c1d6506ac"], "source_entry_id": "16.7/changes/003", "db_id": "c57a5e58b3071a80c1237977113f07bc", "patch_ids": ["dc92bb8a053fda23c6cdbb5d527dab86"], "statement_hash": "3348968e1772f69b37843c78b6190a0dfa50788f92ee1c5992a55373fd833936", "relations": [{"rule": 2, "type": "equivalent", "target": "8e257e8176086cef546cb8c600a2fb7b", "evidence": {"same_day": true, "patch_ids": ["dc92bb8a053fda23c6cdbb5d527dab86"], "statement_hash": "3348968e1772f69b37843c78b6190a0dfa50788f92ee1c5992a55373fd833936"}}, {"rule": 2, "type": "equivalent", "target": "ee143dad58aee392b913c703e066d97d", "evidence": {"same_day": true, "patch_ids": ["dc92bb8a053fda23c6cdbb5d527dab86"], "statement_hash": "3348968e1772f69b37843c78b6190a0dfa50788f92ee1c5992a55373fd833936"}}], "version": "16.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "8e257e8176086cef546cb8c600a2fb7b", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Fix possible re-use of stale results in window aggregates", "evidence": {"same_day": true, "patch_ids": ["dc92bb8a053fda23c6cdbb5d527dab86"], "statement_hash": "3348968e1772f69b37843c78b6190a0dfa50788f92ee1c5992a55373fd833936"}, "url": "/docs/compare/?release=17.3#17.3-f3848e6992b5ba8d", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "ee143dad58aee392b913c703e066d97d", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Fix possible re-use of stale results in window aggregates", "evidence": {"same_day": true, "patch_ids": ["dc92bb8a053fda23c6cdbb5d527dab86"], "statement_hash": "3348968e1772f69b37843c78b6190a0dfa50788f92ee1c5992a55373fd833936"}, "url": "/docs/compare/?release=15.11#15.11-ff23c1f288dbecc9", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}]}, {"id": "16.7-ab66fa2b5cecb35b", "cves": [], "html": "Keep TransactionXmin in sync with MyProc->xmin (Heikki Linnakangas) §
This oversight could permit a process to try to access data that had already been vacuumed away. One known consequence is transient “could not access status of transaction” errors.
", "text": "Keep TransactionXmin in sync with MyProc->xmin (Heikki Linnakangas) § This oversight could permit a process to try to access data that had already been vacuumed away. One known consequence is transient “could not access status of transaction” errors.", "title": "Keep TransactionXmin in sync with MyProc->xmin", "commits": ["9d8ab2c46"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "c8c3665d62d1abb5b52658359aa0e233ed9bd0e1dbc5ae9eec1d5f41dfe2ebdc", "section_path": ["Changes"], "commit_groups": [["41eafbb49", "578a7fe7b", "7cfdb4d1e", "9c1afd344", "9d8ab2c46", "acd5c28db"]], "identity_text": "Keep TransactionXmin in sync with MyProc->xmin (Heikki Linnakangas) This oversight could permit a process to try to access data that had already been vacuumed away. One known consequence is transient could not access status of transaction errors.", "commit_aliases": ["41eafbb49", "578a7fe7b", "7cfdb4d1e", "9c1afd344", "9d8ab2c46", "acd5c28db"], "source_commits": ["9d8ab2c46"], "source_entry_id": "16.7/changes/004", "db_id": "c65490f6c757feec0acb4cae39b05bd5", "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533", "relations": [{"rule": 2, "type": "equivalent", "target": "0f7d09315a70377991e6a72997b3ba55", "evidence": {"same_day": true, "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533"}}, {"rule": 2, "type": "equivalent", "target": "95bc5c6b6c30d84fe3e9651574bf0744", "evidence": {"same_day": true, "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533"}}, {"rule": 2, "type": "equivalent", "target": "b17ef1f417debb4410a01a0a5a78dc49", "evidence": {"same_day": true, "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533"}}, {"rule": 2, "type": "equivalent", "target": "f41d1eff08bdff771230aeb8e3ed62d7", "evidence": {"same_day": true, "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533"}}], "version": "16.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f41d1eff08bdff771230aeb8e3ed62d7", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Keep TransactionXmin in sync with MyProc->xmin", "evidence": {"same_day": true, "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533"}, "url": "/docs/compare/?release=17.3#17.3-64d8331c91e7da7b", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "b17ef1f417debb4410a01a0a5a78dc49", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Keep TransactionXmin in sync with MyProc->xmin", "evidence": {"same_day": true, "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533"}, "url": "/docs/compare/?release=15.11#15.11-10d6ee2ef80e51a0", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "0f7d09315a70377991e6a72997b3ba55", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Keep TransactionXmin in sync with MyProc->xmin", "evidence": {"same_day": true, "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533"}, "url": "/docs/compare/?release=14.16#14.16-354f959d2328db47", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "95bc5c6b6c30d84fe3e9651574bf0744", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Keep TransactionXmin in sync with MyProc->xmin", "evidence": {"same_day": true, "patch_ids": ["bc04e75a3557ff0fba978b0ee94d9217"], "statement_hash": "e1ee6f02ac8b75a16565bcc611feee1f00fac45626cbddd73089d3e79e6aa533"}, "url": "/docs/compare/?release=13.19#13.19-2a0429c69913222c", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-d3e1ddb3e3b864fa", "cves": [], "html": "Fix race condition that could cause failure to add a newly-inserted catalog entry to a catalog cache list (Heikki Linnakangas) §
\nThis could result, for example, in failure to use a newly-created function within an existing session.
", "text": "Fix race condition that could cause failure to add a newly-inserted catalog entry to a catalog cache list (Heikki Linnakangas) § This could result, for example, in failure to use a newly-created function within an existing session.", "title": "Fix race condition that could cause failure to add a newly-inserted catalog entry to a catalog cache list", "commits": ["91fc447c2"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "62023767715baa76b37779e3778ba694f5bf5f5a4c8fb42861fbec27bbbff250", "section_path": ["Changes"], "commit_groups": [["91fc447c2", "96e61b279", "af8cd1639", "ce7c406f0", "f217c4105", "fce17c3a5"]], "identity_text": "Fix race condition that could cause failure to add a newly-inserted catalog entry to a catalog cache list (Heikki Linnakangas) This could result, for example, in failure to use a newly-created function within an existing session.", "commit_aliases": ["91fc447c2", "96e61b279", "af8cd1639", "ce7c406f0", "f217c4105", "fce17c3a5"], "source_commits": ["91fc447c2"], "source_entry_id": "16.7/changes/005", "db_id": "819024b2a3054af412673022665b0b12", "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13", "relations": [{"rule": 2, "type": "equivalent", "target": "428eec456d3609f76929a2b038f85e8a", "evidence": {"same_day": true, "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13"}}, {"rule": 2, "type": "equivalent", "target": "ba88944c6494770af7de1c741188a801", "evidence": {"same_day": true, "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13"}}, {"rule": 2, "type": "equivalent", "target": "cd11a1e538f07e62b6fc668dbd1402ac", "evidence": {"same_day": true, "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13"}}, {"rule": 2, "type": "equivalent", "target": "f825fa61541437a3b4bb7f8ede4da592", "evidence": {"same_day": true, "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13"}}], "version": "16.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "f825fa61541437a3b4bb7f8ede4da592", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Fix race condition that could cause failure to add a newly-inserted catalog entry to a catalog cache list", "evidence": {"same_day": true, "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13"}, "url": "/docs/compare/?release=17.3#17.3-d49aa538a89c2e9d", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "428eec456d3609f76929a2b038f85e8a", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Fix race condition that could cause failure to add a newly-inserted catalog entry to a catalog cache list", "evidence": {"same_day": true, "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13"}, "url": "/docs/compare/?release=15.11#15.11-27d7ae34526121f3", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "ba88944c6494770af7de1c741188a801", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Fix race condition that could cause failure to add a newly-inserted catalog entry to a catalog cache list", "evidence": {"same_day": true, "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13"}, "url": "/docs/compare/?release=14.16#14.16-e9c0b08aff686af1", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "cd11a1e538f07e62b6fc668dbd1402ac", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Fix race condition that could cause failure to add a newly-inserted catalog entry to a catalog cache list", "evidence": {"same_day": true, "patch_ids": ["30a0b58db53c2dde7b527eb3351b6729"], "statement_hash": "0787edc695f81f699e49d8b9bb26054790beb156285a90f41a407c4582951c13"}, "url": "/docs/compare/?release=13.19#13.19-feed443fed43a11e", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-a055f3b905c546b3", "cves": [], "html": "Prevent possible catalog corruption when a system catalog is vacuumed concurrently with an update (Noah Misch) §
", "text": "Prevent possible catalog corruption when a system catalog is vacuumed concurrently with an update (Noah Misch) §", "title": "Prevent possible catalog corruption when a system catalog is vacuumed concurrently with an update", "commits": ["9311fcb86"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "e7b1f9373d3647668ac0b7ad3d03ca7160c866b01a0c5c17a035446b0fe86a77", "section_path": ["Changes"], "commit_groups": [["1587f7b9f", "81772a495"], ["25e99483c", "8bfd2ceba", "9311fcb86", "d28cd3e7b", "dc02b98bd", "f4af4515b"]], "identity_text": "Prevent possible catalog corruption when a system catalog is vacuumed concurrently with an update (Noah Misch)", "commit_aliases": ["1587f7b9f", "25e99483c", "81772a495", "8bfd2ceba", "9311fcb86", "d28cd3e7b", "dc02b98bd", "f4af4515b"], "source_commits": ["81772a495", "9311fcb86"], "source_entry_id": "16.7/changes/006", "db_id": "1c538425f3222136473c1bd1f195a41c", "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382", "relations": [{"rule": 2, "type": "equivalent", "target": "53e2d4d1a5f179c948796b4a85c497a0", "evidence": {"same_day": true, "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382"}}, {"rule": 2, "type": "equivalent", "target": "d552bf163f629e4ce3880b1314bf6e2f", "evidence": {"same_day": true, "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382"}}, {"rule": 2, "type": "equivalent", "target": "e2fc775ae660cbfe5909a35ba85930cf", "evidence": {"same_day": true, "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382"}}, {"rule": 2, "type": "equivalent", "target": "f3712147b2c17e6407c3aaa1c6b905b5", "evidence": {"same_day": true, "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382"}}], "version": "16.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "53e2d4d1a5f179c948796b4a85c497a0", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Prevent possible catalog corruption when a system catalog is vacuumed concurrently with an update", "evidence": {"same_day": true, "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382"}, "url": "/docs/compare/?release=17.3#17.3-f3e54e13e653a3e5", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "f3712147b2c17e6407c3aaa1c6b905b5", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Prevent possible catalog corruption when a system catalog is vacuumed concurrently with an update", "evidence": {"same_day": true, "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382"}, "url": "/docs/compare/?release=15.11#15.11-a1d8fcc306540815", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "e2fc775ae660cbfe5909a35ba85930cf", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Prevent possible catalog corruption when a system catalog is vacuumed concurrently with an update", "evidence": {"same_day": true, "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382"}, "url": "/docs/compare/?release=14.16#14.16-9f57888fe6641937", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "d552bf163f629e4ce3880b1314bf6e2f", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Prevent possible catalog corruption when a system catalog is vacuumed concurrently with an update", "evidence": {"same_day": true, "patch_ids": ["1da4fd752464ea7b33c418f1ffc2761f", "5a322d332e5b2574706cfef626d68da0"], "statement_hash": "e69a8422a00ac3a14bdfa2cbfda1c75d28c90905a13e9a277cff4a0bc8136382"}, "url": "/docs/compare/?release=13.19#13.19-cb91e58d180e62e3", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-adc6f7d2ce7990fa", "cves": [], "html": "Fix data corruption when relation truncation fails (Thomas Munro) § § §
\nThe filesystem calls needed to perform relation truncation could fail, leaving inconsistent state on disk (for example, effectively reviving deleted data). We can't really prevent that, but we can recover by dint of making such failures into PANICs, so that consistency is restored by replaying from WAL up to just before the attempted truncation. This isn't a hugely desirable behavior, but such failures are rare enough that it seems an acceptable solution.
", "text": "Fix data corruption when relation truncation fails (Thomas Munro) § § § The filesystem calls needed to perform relation truncation could fail, leaving inconsistent state on disk (for example, effectively reviving deleted data). We can't really prevent that, but we can recover by dint of making such failures into PANICs, so that consistency is restored by replaying from WAL up to just before the attempted truncation. This isn't a hugely desirable behavior, but such failures are rare enough that it seems an acceptable solution.", "title": "Fix data corruption when relation truncation fails", "commits": ["9defaaa1d", "ba02d24ba", "c957d7444"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "9324d67a1aa12072e78fbfc11c8c04b2a8e803a460fd283da066281a4757c03e", "section_path": ["Changes"], "commit_groups": [["0350b876b", "228091216", "23c743b64", "38c579b08", "ba02d24ba", "fb540b6aa"], ["049c8cb9a", "190054e61", "417d41c65", "45aef9f6b", "9defaaa1d"], ["3181befdc", "66aaabe7a", "a1d17a894", "c957d7444", "f154f028d"]], "identity_text": "Fix data corruption when relation truncation fails (Thomas Munro) The filesystem calls needed to perform relation truncation could fail, leaving inconsistent state on disk (for example, effectively reviving deleted data). We can't really prevent that, but we can recover by dint of making such failures into PANICs, so that consistency is restored by replaying from WAL up to just before the attempted truncation. This isn't a hugely desirable behavior, but such failures are rare enough that it seems an acceptable solution.", "commit_aliases": ["0350b876b", "049c8cb9a", "190054e61", "228091216", "23c743b64", "3181befdc", "38c579b08", "417d41c65", "45aef9f6b", "66aaabe7a", "9defaaa1d", "a1d17a894", "ba02d24ba", "c957d7444", "f154f028d", "fb540b6aa"], "source_commits": ["9defaaa1d", "ba02d24ba", "c957d7444"], "source_entry_id": "16.7/changes/007", "db_id": "a705757c88e8dc114469492bca11380e", "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90", "relations": [{"rule": 2, "type": "equivalent", "target": "29a3dd579cd7acb075f4eb7f34cadf6d", "evidence": {"same_day": true, "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90"}}, {"rule": 2, "type": "equivalent", "target": "6e2d54cee98be477c06d5503209286d2", "evidence": {"same_day": true, "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90"}}, {"rule": 2, "type": "equivalent", "target": "affd693034e908911e8335280c40337c", "evidence": {"same_day": true, "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90"}}, {"rule": 2, "type": "equivalent", "target": "c876272e00edeea60adb978f3ab1e194", "evidence": {"same_day": true, "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90"}}], "version": "16.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c876272e00edeea60adb978f3ab1e194", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Fix data corruption when relation truncation fails", "evidence": {"same_day": true, "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90"}, "url": "/docs/compare/?release=17.3#17.3-1628e1c1870a7451", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "6e2d54cee98be477c06d5503209286d2", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Fix data corruption when relation truncation fails", "evidence": {"same_day": true, "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90"}, "url": "/docs/compare/?release=15.11#15.11-bfc0aa4fc8a74702", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "29a3dd579cd7acb075f4eb7f34cadf6d", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Fix data corruption when relation truncation fails", "evidence": {"same_day": true, "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90"}, "url": "/docs/compare/?release=14.16#14.16-80a213144aae7b2c", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "affd693034e908911e8335280c40337c", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Fix data corruption when relation truncation fails", "evidence": {"same_day": true, "patch_ids": ["13b727a8d3d7e0cd9bc0c3b68e1e7642", "22bba484f561f9abb1172fd40d38d02e", "ed7a32160204c88287960b3de8181d7c"], "statement_hash": "e288a5da590e21c8e69da460b1fc2e484df1e640552bad1d8e596c1194c10a90"}, "url": "/docs/compare/?release=13.19#13.19-122ddb0a90db2f62", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-d552b4e09791f05c", "cves": [], "html": "Prevent checkpoints from starting during relation truncation (Robert Haas) §
\nThis avoids a race condition wherein the modified file might not get fsync'd before completing the checkpoint, creating a risk of data corruption if the operating system crashes soon after.
", "text": "Prevent checkpoints from starting during relation truncation (Robert Haas) § This avoids a race condition wherein the modified file might not get fsync'd before completing the checkpoint, creating a risk of data corruption if the operating system crashes soon after.", "title": "Prevent checkpoints from starting during relation truncation", "commits": ["ad5aa7bfd"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "5a1d8f55cedf769e355f1852c4978a62c7ed641013f3ac13b85bce181603fb5e", "section_path": ["Changes"], "commit_groups": [["1168acbca", "75818b3af", "7d0b91a28", "a501fe5a9", "ad5aa7bfd", "d4ffbf47b"]], "identity_text": "Prevent checkpoints from starting during relation truncation (Robert Haas) This avoids a race condition wherein the modified file might not get fsync'd before completing the checkpoint, creating a risk of data corruption if the operating system crashes soon after.", "commit_aliases": ["1168acbca", "75818b3af", "7d0b91a28", "a501fe5a9", "ad5aa7bfd", "d4ffbf47b"], "source_commits": ["ad5aa7bfd"], "source_entry_id": "16.7/changes/008", "db_id": "48e63346cf5f2bd983ad4aa906ad04c3", "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d", "relations": [{"rule": 2, "type": "equivalent", "target": "470f2470a3f35434fb1d59ff2b3944f7", "evidence": {"same_day": true, "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d"}}, {"rule": 2, "type": "equivalent", "target": "563d9f0f77b3eee26c49723296ec9b79", "evidence": {"same_day": true, "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d"}}, {"rule": 2, "type": "equivalent", "target": "a574173fa6e03fae58fa4d27b0e1c766", "evidence": {"same_day": true, "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d"}}, {"rule": 2, "type": "equivalent", "target": "b014a39e8931c48ade8177ec91e5da8e", "evidence": {"same_day": true, "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d"}}], "version": "16.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "a574173fa6e03fae58fa4d27b0e1c766", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Prevent checkpoints from starting during relation truncation", "evidence": {"same_day": true, "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d"}, "url": "/docs/compare/?release=17.3#17.3-39227326b9aa5e8e", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "470f2470a3f35434fb1d59ff2b3944f7", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Prevent checkpoints from starting during relation truncation", "evidence": {"same_day": true, "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d"}, "url": "/docs/compare/?release=15.11#15.11-be8211ced912411c", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "563d9f0f77b3eee26c49723296ec9b79", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Prevent checkpoints from starting during relation truncation", "evidence": {"same_day": true, "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d"}, "url": "/docs/compare/?release=14.16#14.16-c9b2392b6b20c044", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "b014a39e8931c48ade8177ec91e5da8e", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Prevent checkpoints from starting during relation truncation", "evidence": {"same_day": true, "patch_ids": ["c12b962bcfc7f1116a0a1e82ac97d466"], "statement_hash": "5a7f80ce273dd03c64be48fd9f34bac3e72ea14b376b7fd414f3f61971e9c70d"}, "url": "/docs/compare/?release=13.19#13.19-e9956e400bc3e5e5", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-80f6efebe5169fa5", "cves": [], "html": "Avoid possibly losing an update of pg_database.datfrozenxid when VACUUM runs concurrently with a REASSIGN OWNED that changes that database's owner (Kirill Reshke) §
Fix incorrect tg_updatedcols values passed to AFTER UPDATE triggers (Tom Lane) §
In some cases the tg_updatedcols bitmap could describe the set of columns updated by an earlier command in the same transaction, fooling the trigger into doing the wrong thing.
Also, prevent memory bloat caused by making too many copies of the tg_updatedcols bitmap.
Fix detach of a partition that has its own foreign-key constraint referencing a partitioned table (Amul Sul) §
\nIn common cases, foreign keys are defined on a partitioned table's top level; but if instead one is defined on a partition and references a partitioned table, and the referencing partition is detached, the relevant pg_constraint entries were updated incorrectly. This led to errors like “could not find ON INSERT check triggers of foreign key constraint”.
Fix mis-processing of to_timestamp's FF format codes (Tom Lane) §n
An integer format code immediately preceding FF would consume all available digits, leaving none for nFF.n
When deparsing an XMLTABLE() expression, ensure that XML namespace names are double-quoted when necessary (Dean Rasheed) §
Include the ldapscheme option in pg_hba_file_rules() output (Laurenz Albe) § §
Don't merge UNION operations if their column collations aren't consistent (Tom Lane) §
Previously we ignored collations when deciding if it's safe to merge UNION steps into a single N-way UNION operation. This was arguably valid before the introduction of nondeterministic collations, but it's not anymore, since the collation in use can affect the definition of uniqueness.
Prevent “wrong varnullingrels” planner errors after pulling up a subquery that's underneath an outer join (Tom Lane) § §
", "text": "Prevent “wrong varnullingrels” planner errors after pulling up a subquery that's underneath an outer join (Tom Lane) § §", "title": "Prevent “wrong varnullingrels” planner errors after pulling up a subquery that's underneath an outer join", "commits": ["7b456f040", "85990e2fd"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "e72630504f07cadeaf07c4c1a29988b636e01e5423843cc20cb55d3957b81fc0", "section_path": ["Changes"], "commit_groups": [["5c9d8636d", "72822a99d", "85990e2fd"], ["78883cd90", "7b456f040", "e032e4c7d"]], "identity_text": "Prevent wrong varnullingrels planner errors after pulling up a subquery that's underneath an outer join (Tom Lane)", "commit_aliases": ["5c9d8636d", "72822a99d", "78883cd90", "7b456f040", "85990e2fd", "e032e4c7d"], "source_commits": ["7b456f040", "85990e2fd"], "source_entry_id": "16.7/changes/016", "db_id": "15e3faca0d01e2124183a4fe2a717da7", "patch_ids": ["8779e21e34c76266f909cace4bf46334", "cca7c628610742166bcfeb586b971a8d"], "statement_hash": "e51cd2872d798cf56d5fea424d6e175ef48b4df7592c4a95a1c52e7ec692aaf5", "relations": [{"rule": 2, "type": "equivalent", "target": "35d6fcb358c16df19f7c8d219cc311a2", "evidence": {"same_day": true, "patch_ids": ["8779e21e34c76266f909cace4bf46334", "cca7c628610742166bcfeb586b971a8d"], "statement_hash": "e51cd2872d798cf56d5fea424d6e175ef48b4df7592c4a95a1c52e7ec692aaf5"}}], "version": "16.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "35d6fcb358c16df19f7c8d219cc311a2", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Prevent “wrong varnullingrels” planner errors after pulling up a subquery that's underneath an outer join", "evidence": {"same_day": true, "patch_ids": ["8779e21e34c76266f909cace4bf46334", "cca7c628610742166bcfeb586b971a8d"], "statement_hash": "e51cd2872d798cf56d5fea424d6e175ef48b4df7592c4a95a1c52e7ec692aaf5"}, "url": "/docs/compare/?release=17.3#17.3-0322df66c1b6d2d4", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}]}, {"id": "16.7-686d9c5e0e07b261", "cves": [], "html": "Ignore nulling-relation marker bits when looking up statistics (Richard Guo) §
\nThis oversight could lead to failure to use relevant statistics about expressions, or to “corrupt MVNDistinct entry” errors.
", "text": "Ignore nulling-relation marker bits when looking up statistics (Richard Guo) § This oversight could lead to failure to use relevant statistics about expressions, or to “corrupt MVNDistinct entry” errors.", "title": "Ignore nulling-relation marker bits when looking up statistics", "commits": ["a1a9120c7"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "bb5943dc2f0efc861d30a3400c5c7608a5689bb8a2446b0145784f39e9dc6ba2", "section_path": ["Changes"], "commit_groups": [["297b280ab", "a1a9120c7", "e28033fe1"]], "identity_text": "Ignore nulling-relation marker bits when looking up statistics (Richard Guo) This oversight could lead to failure to use relevant statistics about expressions, or to corrupt MVNDistinct entry errors.", "commit_aliases": ["297b280ab", "a1a9120c7", "e28033fe1"], "source_commits": ["a1a9120c7"], "source_entry_id": "16.7/changes/017", "db_id": "256cc3b4dcc5eaf921a1d651a2c67e80", "patch_ids": ["101d91c908f087d8a718ce1891305aaf"], "statement_hash": "6aeaa1d32c6cf0a1044a748ef2ee197c84c9ce13bc46ff0b73d099c2527f2951", "relations": [{"rule": 2, "type": "equivalent", "target": "4a7b2af0753b35ec155e5155ce304110", "evidence": {"same_day": true, "patch_ids": ["101d91c908f087d8a718ce1891305aaf"], "statement_hash": "6aeaa1d32c6cf0a1044a748ef2ee197c84c9ce13bc46ff0b73d099c2527f2951"}}], "version": "16.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "4a7b2af0753b35ec155e5155ce304110", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Ignore nulling-relation marker bits when looking up statistics", "evidence": {"same_day": true, "patch_ids": ["101d91c908f087d8a718ce1891305aaf"], "statement_hash": "6aeaa1d32c6cf0a1044a748ef2ee197c84c9ce13bc46ff0b73d099c2527f2951"}, "url": "/docs/compare/?release=17.3#17.3-2052529fad628663", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}]}, {"id": "16.7-7e432f19a9f91448", "cves": [], "html": "Fix missed expression processing for partition pruning steps (Tom Lane) §
\nThis oversight could lead to “unrecognized node type” errors, and perhaps other problems, in queries accessing partitioned tables.
", "text": "Fix missed expression processing for partition pruning steps (Tom Lane) § This oversight could lead to “unrecognized node type” errors, and perhaps other problems, in queries accessing partitioned tables.", "title": "Fix missed expression processing for partition pruning steps", "commits": ["94c02bd33"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "ce415f7337d4fba716e1bb28db6a1b97f2ab2cd4f6e5373cdfe52520f3e19299", "section_path": ["Changes"], "commit_groups": [["0671a71e0", "45004f527", "5f725648f", "724ebebb1", "94c02bd33", "bf826ea06"]], "identity_text": "Fix missed expression processing for partition pruning steps (Tom Lane) This oversight could lead to unrecognized node type errors, and perhaps other problems, in queries accessing partitioned tables.", "commit_aliases": ["0671a71e0", "45004f527", "5f725648f", "724ebebb1", "94c02bd33", "bf826ea06"], "source_commits": ["94c02bd33"], "source_entry_id": "16.7/changes/018", "db_id": "92378b1193935bbe98423ded57c0f7a0", "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b", "relations": [{"rule": 2, "type": "equivalent", "target": "54bec316da2ce059adbac0a0dbc8e9b6", "evidence": {"same_day": true, "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b"}}, {"rule": 2, "type": "equivalent", "target": "64aaf6067e2f499a849b519969ab7e4b", "evidence": {"same_day": true, "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b"}}, {"rule": 2, "type": "equivalent", "target": "d03371888cc7150b3deafc4ad1b65c61", "evidence": {"same_day": true, "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b"}}, {"rule": 2, "type": "equivalent", "target": "f57a46c5163b3e5919b130be79f25ce5", "evidence": {"same_day": true, "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b"}}], "version": "16.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "54bec316da2ce059adbac0a0dbc8e9b6", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Fix missed expression processing for partition pruning steps", "evidence": {"same_day": true, "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b"}, "url": "/docs/compare/?release=17.3#17.3-13c2873d21939448", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "f57a46c5163b3e5919b130be79f25ce5", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Fix missed expression processing for partition pruning steps", "evidence": {"same_day": true, "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b"}, "url": "/docs/compare/?release=15.11#15.11-126d9ceb0a19d1f7", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "d03371888cc7150b3deafc4ad1b65c61", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Fix missed expression processing for partition pruning steps", "evidence": {"same_day": true, "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b"}, "url": "/docs/compare/?release=14.16#14.16-e76cb5deecce3a19", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "64aaf6067e2f499a849b519969ab7e4b", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Fix missed expression processing for partition pruning steps", "evidence": {"same_day": true, "patch_ids": ["5551cc7fd0dd9d66c578783ac84f1896"], "statement_hash": "a179f258a05f2c3cfdf6806107736461e71d0130f204ff5a764c84b4d924406b"}, "url": "/docs/compare/?release=13.19#13.19-bb60e571dcd1116e", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-0c925e1e9ecd0922", "cves": [], "html": "Allow dshash tables to grow past 1GB (Matthias van de Meent) §
\nThis avoids errors like “invalid DSA memory alloc request size”. The case can occur for example in transactions that process several million tables.
", "text": "Allow dshash tables to grow past 1GB (Matthias van de Meent) § This avoids errors like “invalid DSA memory alloc request size”. The case can occur for example in transactions that process several million tables.", "title": "Allow dshash tables to grow past 1GB", "commits": ["2a7402322"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "9e095986418f78e5de0df6540862fd2c7520836feebd43bb786cafd248251c1e", "section_path": ["Changes"], "commit_groups": [["18452b70a", "2a7402322", "84dc1303c", "84f1b0b03", "853cef097", "9f7b7d516"]], "identity_text": "Allow dshash tables to grow past 1GB (Matthias van de Meent) This avoids errors like invalid DSA memory alloc request size. The case can occur for example in transactions that process several million tables.", "commit_aliases": ["18452b70a", "2a7402322", "84dc1303c", "84f1b0b03", "853cef097", "9f7b7d516"], "source_commits": ["2a7402322"], "source_entry_id": "16.7/changes/019", "db_id": "c1707a3dbd154a011972a406a0fe3177", "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8", "relations": [{"rule": 2, "type": "equivalent", "target": "559be1008e5dc3b8471a163d74e0e555", "evidence": {"same_day": true, "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8"}}, {"rule": 2, "type": "equivalent", "target": "6356be9dc3a4ccb3d25583a601b052d7", "evidence": {"same_day": true, "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8"}}, {"rule": 2, "type": "equivalent", "target": "c32bee4d5d51b2dfdb45db1d2db22cb1", "evidence": {"same_day": true, "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8"}}, {"rule": 2, "type": "equivalent", "target": "c51c9c918546c72f7a773592db3d7108", "evidence": {"same_day": true, "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8"}}], "version": "16.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "6356be9dc3a4ccb3d25583a601b052d7", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Allow dshash tables to grow past 1GB", "evidence": {"same_day": true, "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8"}, "url": "/docs/compare/?release=17.3#17.3-01e60c1471a16974", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "c32bee4d5d51b2dfdb45db1d2db22cb1", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Allow dshash tables to grow past 1GB", "evidence": {"same_day": true, "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8"}, "url": "/docs/compare/?release=15.11#15.11-bd0deef2a9ca340c", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "559be1008e5dc3b8471a163d74e0e555", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Allow dshash tables to grow past 1GB", "evidence": {"same_day": true, "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8"}, "url": "/docs/compare/?release=14.16#14.16-d37432d80add9128", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "c51c9c918546c72f7a773592db3d7108", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Allow dshash tables to grow past 1GB", "evidence": {"same_day": true, "patch_ids": ["4a1c75d9a6546bdd5d261ba5d3a227c1"], "statement_hash": "faf10a7922a2f18a9774d93e321afa5a0c92f8c3c8987552c55415bd13c387e8"}, "url": "/docs/compare/?release=13.19#13.19-6c810fa8b81fd565", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-b97ed85237994136", "cves": [], "html": "Avoid possible integer overflow in bringetbitmap() (James Hunter, Evgeniy Gorbanyov) §
Since the result is only used for statistical purposes, the effects of this error were mostly cosmetic.
", "text": "Avoid possible integer overflow in bringetbitmap() (James Hunter, Evgeniy Gorbanyov) § Since the result is only used for statistical purposes, the effects of this error were mostly cosmetic.", "title": "Avoid possible integer overflow in bringetbitmap()", "commits": ["bfda7d8dd"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "916e113d8a19e31f8850b76a3e73f9f33576e53956ce04d214c0010e3c7c56b2", "section_path": ["Changes"], "commit_groups": [["332023e2d", "720e52984", "9e9f30139", "bfda7d8dd", "e027ee990", "e35ff6520"]], "identity_text": "Avoid possible integer overflow in bringetbitmap() (James Hunter, Evgeniy Gorbanyov) Since the result is only used for statistical purposes, the effects of this error were mostly cosmetic.", "commit_aliases": ["332023e2d", "720e52984", "9e9f30139", "bfda7d8dd", "e027ee990", "e35ff6520"], "source_commits": ["bfda7d8dd"], "source_entry_id": "16.7/changes/020", "db_id": "921aaf580d2aca9ce93450c0492e7423", "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec", "relations": [{"rule": 2, "type": "equivalent", "target": "1fe83d7e0b7aa17a1f0f729b4a0c12f0", "evidence": {"same_day": true, "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec"}}, {"rule": 2, "type": "equivalent", "target": "3382e0a80f8ca0563eb8cac40f2d851b", "evidence": {"same_day": true, "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec"}}, {"rule": 2, "type": "equivalent", "target": "3c029255e641bec15f2ee6842ff93a77", "evidence": {"same_day": true, "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec"}}, {"rule": 2, "type": "equivalent", "target": "4c0001cec4b021e935b71b3a37aa73fe", "evidence": {"same_day": true, "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec"}}], "version": "16.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "3382e0a80f8ca0563eb8cac40f2d851b", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Avoid possible integer overflow in bringetbitmap()", "evidence": {"same_day": true, "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec"}, "url": "/docs/compare/?release=17.3#17.3-a04d6e576513146f", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "1fe83d7e0b7aa17a1f0f729b4a0c12f0", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Avoid possible integer overflow in bringetbitmap()", "evidence": {"same_day": true, "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec"}, "url": "/docs/compare/?release=15.11#15.11-4f9db6103a233435", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "4c0001cec4b021e935b71b3a37aa73fe", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Avoid possible integer overflow in bringetbitmap()", "evidence": {"same_day": true, "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec"}, "url": "/docs/compare/?release=14.16#14.16-b175488683721a19", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "3c029255e641bec15f2ee6842ff93a77", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Avoid possible integer overflow in bringetbitmap()", "evidence": {"same_day": true, "patch_ids": ["43a263cfc4076d37afa82ad82a07bdb5"], "statement_hash": "0df21d34231d373da53a6bee55e2b328ac8048d21323da7f65a482bc0db673ec"}, "url": "/docs/compare/?release=13.19#13.19-65695708975bb439", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-c9b569de46610159", "cves": [], "html": "Ensure that an already-set process latch doesn't prevent the postmaster from noticing socket events (Thomas Munro) §
\nAn extremely heavy workload of backends launching workers and workers exiting could prevent the postmaster from responding to incoming client connections in a timely fashion.
", "text": "Ensure that an already-set process latch doesn't prevent the postmaster from noticing socket events (Thomas Munro) § An extremely heavy workload of backends launching workers and workers exiting could prevent the postmaster from responding to incoming client connections in a timely fashion.", "title": "Ensure that an already-set process latch doesn't prevent the postmaster from noticing socket events", "commits": ["b4b52c911"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "9ed3605e03cdd18cb6395be91f1241a77f4fde3997ecf07cd5d27fe14c31eee4", "section_path": ["Changes"], "commit_groups": [["44f400fbc", "73f6b9a3b", "b4b52c911"]], "identity_text": "Ensure that an already-set process latch doesn't prevent the postmaster from noticing socket events (Thomas Munro) An extremely heavy workload of backends launching workers and workers exiting could prevent the postmaster from responding to incoming client connections in a timely fashion.", "commit_aliases": ["44f400fbc", "73f6b9a3b", "b4b52c911"], "source_commits": ["b4b52c911"], "source_entry_id": "16.7/changes/021", "db_id": "58f560957a49bc1a7b13f51ab753f20d", "patch_ids": ["26f3c294fc4c7a4dc5f79c68f8c5e836"], "statement_hash": "7043ffdabadf088472c9cf1cc1be25f1750238a6e51989cbe311cbc8af37dbf1", "relations": [{"rule": 2, "type": "equivalent", "target": "0aeeea30a1398421ffc19c9b88e3d47d", "evidence": {"same_day": true, "patch_ids": ["26f3c294fc4c7a4dc5f79c68f8c5e836"], "statement_hash": "7043ffdabadf088472c9cf1cc1be25f1750238a6e51989cbe311cbc8af37dbf1"}}], "version": "16.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "0aeeea30a1398421ffc19c9b88e3d47d", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Ensure that an already-set process latch doesn't prevent the postmaster from noticing socket events", "evidence": {"same_day": true, "patch_ids": ["26f3c294fc4c7a4dc5f79c68f8c5e836"], "statement_hash": "7043ffdabadf088472c9cf1cc1be25f1750238a6e51989cbe311cbc8af37dbf1"}, "url": "/docs/compare/?release=17.3#17.3-2f52ccd04b3c82e8", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}]}, {"id": "16.7-df1eee243145f866", "cves": [], "html": "Prevent streaming standby servers from looping infinitely when reading a WAL record that crosses pages (Kyotaro Horiguchi, Alexander Kukushkin) §
\nThis would happen when the record's continuation is on a page that needs to be read from a different WAL source.
", "text": "Prevent streaming standby servers from looping infinitely when reading a WAL record that crosses pages (Kyotaro Horiguchi, Alexander Kukushkin) § This would happen when the record's continuation is on a page that needs to be read from a different WAL source.", "title": "Prevent streaming standby servers from looping infinitely when reading a WAL record that crosses pages", "commits": ["2c2e1d4f4"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "4cc70e9d72dcf3ce18fc2a0119e22318951ddecc4baf741b314305a9df01de22", "section_path": ["Changes"], "commit_groups": [["0f0431e91", "26554facc", "2c2e1d4f4", "6cf1647d8", "a2d4f806c", "e6767c0ed"]], "identity_text": "Prevent streaming standby servers from looping infinitely when reading a WAL record that crosses pages (Kyotaro Horiguchi, Alexander Kukushkin) This would happen when the record's continuation is on a page that needs to be read from a different WAL source.", "commit_aliases": ["0f0431e91", "26554facc", "2c2e1d4f4", "6cf1647d8", "a2d4f806c", "e6767c0ed"], "source_commits": ["2c2e1d4f4"], "source_entry_id": "16.7/changes/022", "db_id": "44f9cbeda7bc216ab467698d3eef592e", "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac", "relations": [{"rule": 2, "type": "equivalent", "target": "6659c5f8e0df6f1f962f8df015c68b49", "evidence": {"same_day": true, "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac"}}, {"rule": 2, "type": "equivalent", "target": "67dafb471f2271a6320dfe0f290a0ce0", "evidence": {"same_day": true, "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac"}}, {"rule": 2, "type": "equivalent", "target": "76f611c374c0323f13dc341fb4721c32", "evidence": {"same_day": true, "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac"}}, {"rule": 2, "type": "equivalent", "target": "fdc72a7668046cce65c8c39dedeb9249", "evidence": {"same_day": true, "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac"}}], "version": "16.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "6659c5f8e0df6f1f962f8df015c68b49", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Prevent streaming standby servers from looping infinitely when reading a WAL record that crosses pages", "evidence": {"same_day": true, "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac"}, "url": "/docs/compare/?release=17.3#17.3-e9e73d99c1cfb098", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "67dafb471f2271a6320dfe0f290a0ce0", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Prevent streaming standby servers from looping infinitely when reading a WAL record that crosses pages", "evidence": {"same_day": true, "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac"}, "url": "/docs/compare/?release=15.11#15.11-9354a205b1e1b91e", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "76f611c374c0323f13dc341fb4721c32", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Prevent streaming standby servers from looping infinitely when reading a WAL record that crosses pages", "evidence": {"same_day": true, "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac"}, "url": "/docs/compare/?release=14.16#14.16-b3b12c0bad0d0bc8", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "fdc72a7668046cce65c8c39dedeb9249", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Prevent streaming standby servers from looping infinitely when reading a WAL record that crosses pages", "evidence": {"same_day": true, "patch_ids": ["6bd1862645031c383d6f5fa3e87d128a"], "statement_hash": "8163d04f4c6709be020365b3558ab3cfb180c7df4e85776a541cc615047564ac"}, "url": "/docs/compare/?release=13.19#13.19-4169e9202c255d82", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-795da8c683c4ad88", "cves": [], "html": "Fix unintended promotion of FATAL errors to PANIC during early process startup (Noah Misch) §
\nThis fixes some unlikely cases that would result in “PANIC: proc_exit() called in child process”.
", "text": "Fix unintended promotion of FATAL errors to PANIC during early process startup (Noah Misch) § This fixes some unlikely cases that would result in “PANIC: proc_exit() called in child process”.", "title": "Fix unintended promotion of FATAL errors to PANIC during early process startup", "commits": ["ac4a2b403"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "e3e9005c1f5e67eaadb74131331d2d61e45c388814e997e319b4a0c987632bf7", "section_path": ["Changes"], "commit_groups": [["315264d70", "4bd9de3f4", "6151769f6", "839da50bd", "8b9cbf492", "ac4a2b403"]], "identity_text": "Fix unintended promotion of FATAL errors to PANIC during early process startup (Noah Misch) This fixes some unlikely cases that would result in PANIC: proc_exit() called in child process.", "commit_aliases": ["315264d70", "4bd9de3f4", "6151769f6", "839da50bd", "8b9cbf492", "ac4a2b403"], "source_commits": ["ac4a2b403"], "source_entry_id": "16.7/changes/023", "db_id": "b14c042be747a937c3c74162b1b09321", "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4", "relations": [{"rule": 2, "type": "equivalent", "target": "93eca6f7915b54f74b93e375c2513842", "evidence": {"same_day": true, "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4"}}, {"rule": 2, "type": "equivalent", "target": "da9210bd08299df78861342f7e09c5d9", "evidence": {"same_day": true, "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4"}}, {"rule": 2, "type": "equivalent", "target": "f984d853bfadab0b79bd0501cc75f59c", "evidence": {"same_day": true, "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4"}}, {"rule": 2, "type": "equivalent", "target": "fc52476d2fcf5579cadcfd273916020c", "evidence": {"same_day": true, "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4"}}], "version": "16.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "93eca6f7915b54f74b93e375c2513842", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Fix unintended promotion of FATAL errors to PANIC during early process startup", "evidence": {"same_day": true, "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4"}, "url": "/docs/compare/?release=17.3#17.3-96bd4a8fad85c533", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "da9210bd08299df78861342f7e09c5d9", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Fix unintended promotion of FATAL errors to PANIC during early process startup", "evidence": {"same_day": true, "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4"}, "url": "/docs/compare/?release=15.11#15.11-e74c5a37c2620a7b", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "f984d853bfadab0b79bd0501cc75f59c", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Fix unintended promotion of FATAL errors to PANIC during early process startup", "evidence": {"same_day": true, "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4"}, "url": "/docs/compare/?release=14.16#14.16-a449a8f550e33341", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "fc52476d2fcf5579cadcfd273916020c", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Fix unintended promotion of FATAL errors to PANIC during early process startup", "evidence": {"same_day": true, "patch_ids": ["3dc2ed380d29cd0391ceb9c75aa1e4af"], "statement_hash": "bb23336aef9609b55069d3a3682e82c4adb4c0d727e67333f854df824add2da4"}, "url": "/docs/compare/?release=13.19#13.19-e7ab576b34d2feae", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-c657434a0bda78ba", "cves": [], "html": "Fix cases where an operator family member operator or support procedure could become a dangling reference (Tom Lane) § §
\nIn some cases a data type could be dropped while references to its OID still remain in pg_amop or pg_amproc. While that caused no immediate issues, an attempt to drop the owning operator family would fail, and pg_dump would produce bogus output when dumping the operator family. This fix causes creation and modification of operator families/classes to add needed dependency entries so that dropping a data type will also drop any dependent operator family elements. That does not help vulnerable pre-existing operator families, though, so a band-aid has also been added to DROP OPERATOR FAMILY to prevent failure when dropping a family that has dangling members.
Fix multiple memory leaks in logical decoding output (Vignesh C, Masahiko Sawada, Boyu Yang) § § §
", "text": "Fix multiple memory leaks in logical decoding output (Vignesh C, Masahiko Sawada, Boyu Yang) § § §", "title": "Fix multiple memory leaks in logical decoding output", "commits": ["4d45e7490", "e3a27fd06", "e749eaf46"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "1c3e8f2edf015617d8ff034151e73c7ead1a1c2327076e7006e0042272f8cb13", "section_path": ["Changes"], "commit_groups": [["4d45e7490", "6c9b39754", "ba230ce40", "bbe68c13a", "cfd6cbcf9"], ["6fc30c24c", "afe9b0d9f", "e749eaf46", "ea792bfd9"], ["836435424", "a786cf04d", "c53d90bb4", "c9b3d4909", "da8bd5d42", "e3a27fd06"]], "identity_text": "Fix multiple memory leaks in logical decoding output (Vignesh C, Masahiko Sawada, Boyu Yang)", "commit_aliases": ["4d45e7490", "6c9b39754", "6fc30c24c", "836435424", "a786cf04d", "afe9b0d9f", "ba230ce40", "bbe68c13a", "c53d90bb4", "c9b3d4909", "cfd6cbcf9", "da8bd5d42", "e3a27fd06", "e749eaf46", "ea792bfd9"], "source_commits": ["4d45e7490", "e3a27fd06", "e749eaf46"], "source_entry_id": "16.7/changes/025", "db_id": "13d179398909add9970f46ab481b9189", "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3", "relations": [{"rule": 2, "type": "equivalent", "target": "4d10718ab097a65a0eb68ddf6be4859c", "evidence": {"same_day": true, "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3"}}, {"rule": 2, "type": "equivalent", "target": "72d566e30a8d7b411efea718bcd02235", "evidence": {"same_day": true, "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3"}}, {"rule": 2, "type": "equivalent", "target": "7b50a2183c182642d28afec0183d605b", "evidence": {"same_day": true, "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3"}}, {"rule": 2, "type": "equivalent", "target": "d3be3c9794f3530e444e4a59e5badd78", "evidence": {"same_day": true, "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3"}}], "version": "16.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "72d566e30a8d7b411efea718bcd02235", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Fix multiple memory leaks in logical decoding output", "evidence": {"same_day": true, "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3"}, "url": "/docs/compare/?release=17.3#17.3-f8da83cc6b6fcff8", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "d3be3c9794f3530e444e4a59e5badd78", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Fix multiple memory leaks in logical decoding output", "evidence": {"same_day": true, "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3"}, "url": "/docs/compare/?release=15.11#15.11-4ddb503d2428c1e4", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "7b50a2183c182642d28afec0183d605b", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Fix multiple memory leaks in logical decoding output", "evidence": {"same_day": true, "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3"}, "url": "/docs/compare/?release=14.16#14.16-bfc8d46c250ae217", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "4d10718ab097a65a0eb68ddf6be4859c", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Fix multiple memory leaks in logical decoding output", "evidence": {"same_day": true, "patch_ids": ["083b3d92b52591987156749d03a56ca8", "29a2d645a1b73678c67988f3f9010a5b", "50035a0a455b496bdee09300ecbd87d5"], "statement_hash": "d36acd9215ab16034e1e7aa511f9ed84121072688abdeba96f8e7547f04a32f3"}, "url": "/docs/compare/?release=13.19#13.19-fbacd441376f2672", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-d336a23747dfe511", "cves": [], "html": "Fix small memory leak when updating the application_name or cluster_name settings (Tofig Aliev) §
Avoid integer overflow while testing wal_skip_threshold condition (Tom Lane) §
A transaction that created a very large relation could mistakenly decide to ensure durability by copying the relation into WAL instead of fsync'ing it, thereby negating the point of wal_skip_threshold. (This only matters when wal_level is set to minimal, else a WAL copy is required anyway.)
Fix unsafe order of operations during cache lookups (Noah Misch) §
\nThe only known consequence was a usually-harmless “you don't own a lock of type ExclusiveLock” warning during GRANT TABLESPACE.
Fix possible “failed to resolve name” failures when using JIT on older ARM platforms (Thomas Munro) §
\nThis could occur as a consequence of inconsistency about the default setting of -moutline-atomics between gcc and clang. At least Debian and Ubuntu are known to ship gcc and clang compilers that target armv8-a but differ on the use of outline atomics by default.
Fix assertion failure in WITH RECURSIVE ... UNION queries (David Rowley) §
Avoid assertion failure in rule deparsing if a set operation leaf query contains set operations (Man Zeng, Tom Lane) §
", "text": "Avoid assertion failure in rule deparsing if a set operation leaf query contains set operations (Man Zeng, Tom Lane) §", "title": "Avoid assertion failure in rule deparsing if a set operation leaf query contains set operations", "commits": ["fe084039e"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "a838df4a4d8e93f9d9dae416ef610c2ab07558fb8378e1fa3b401bf8d584b0b6", "section_path": ["Changes"], "commit_groups": [["3eb26524c", "630520c22", "94131cd53", "9b9689e26", "fe084039e", "fea81aee8"]], "identity_text": "Avoid assertion failure in rule deparsing if a set operation leaf query contains set operations (Man Zeng, Tom Lane)", "commit_aliases": ["3eb26524c", "630520c22", "94131cd53", "9b9689e26", "fe084039e", "fea81aee8"], "source_commits": ["fe084039e"], "source_entry_id": "16.7/changes/031", "db_id": "7f4412cd75dc72714d7ab2bc7274e4b1", "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6", "relations": [{"rule": 2, "type": "equivalent", "target": "430ea600c60e03d11df898e94770372a", "evidence": {"same_day": true, "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6"}}, {"rule": 2, "type": "equivalent", "target": "50000347e8a508f0aaef39e9f6f46b3a", "evidence": {"same_day": true, "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6"}}, {"rule": 2, "type": "equivalent", "target": "788662ba7d1019b44607912fceb78494", "evidence": {"same_day": true, "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6"}}, {"rule": 2, "type": "equivalent", "target": "fb21bd83fba5eb8385f3edc1dbf0a7f3", "evidence": {"same_day": true, "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6"}}], "version": "16.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "fb21bd83fba5eb8385f3edc1dbf0a7f3", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Avoid assertion failure in rule deparsing if a set operation leaf query contains set operations", "evidence": {"same_day": true, "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6"}, "url": "/docs/compare/?release=17.3#17.3-298a145035b17ae1", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "50000347e8a508f0aaef39e9f6f46b3a", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Avoid assertion failure in rule deparsing if a set operation leaf query contains set operations", "evidence": {"same_day": true, "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6"}, "url": "/docs/compare/?release=15.11#15.11-9782e96a5d6e6210", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "788662ba7d1019b44607912fceb78494", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Avoid assertion failure in rule deparsing if a set operation leaf query contains set operations", "evidence": {"same_day": true, "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6"}, "url": "/docs/compare/?release=14.16#14.16-f9a2837076e3ff29", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "430ea600c60e03d11df898e94770372a", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Avoid assertion failure in rule deparsing if a set operation leaf query contains set operations", "evidence": {"same_day": true, "patch_ids": ["35f4eaf8ee261956e392123bcc2aed5e"], "statement_hash": "d49aa748ad3e4a3666aabd63408b98480407e26d03b35fa0e4c40aeaa81830f6"}, "url": "/docs/compare/?release=13.19#13.19-5492d6a199377d8e", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-98a37c42135391b3", "cves": [], "html": "Avoid edge-case assertion failure in parallel query startup (Tom Lane) §
", "text": "Avoid edge-case assertion failure in parallel query startup (Tom Lane) §", "title": "Avoid edge-case assertion failure in parallel query startup", "commits": ["bb649b553"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "529d4762a64639a3683f38523facc6edd905ead0934c9cc2e86f3628b88543d9", "section_path": ["Changes"], "commit_groups": [["3eea7a0c9", "4089b9bd6", "4d20bad5e", "556f7b7bc", "8a95ad3b2", "bb649b553"]], "identity_text": "Avoid edge-case assertion failure in parallel query startup (Tom Lane)", "commit_aliases": ["3eea7a0c9", "4089b9bd6", "4d20bad5e", "556f7b7bc", "8a95ad3b2", "bb649b553"], "source_commits": ["bb649b553"], "source_entry_id": "16.7/changes/032", "db_id": "3abae71410ce108faa00b2da6ec38a1a", "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7", "relations": [{"rule": 2, "type": "equivalent", "target": "afb62e2219d6171b37153e1b07c79a3c", "evidence": {"same_day": true, "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7"}}, {"rule": 2, "type": "equivalent", "target": "bfd249fdf1d29e1a2671b588f5c25368", "evidence": {"same_day": true, "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7"}}, {"rule": 2, "type": "equivalent", "target": "f773276377191676df7c3642b74798a8", "evidence": {"same_day": true, "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7"}}, {"rule": 2, "type": "equivalent", "target": "fd91c149b0074746d42181c8ca343d83", "evidence": {"same_day": true, "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7"}}], "version": "16.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "afb62e2219d6171b37153e1b07c79a3c", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Avoid edge-case assertion failure in parallel query startup", "evidence": {"same_day": true, "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7"}, "url": "/docs/compare/?release=17.3#17.3-722a0397cafeb199", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "bfd249fdf1d29e1a2671b588f5c25368", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Avoid edge-case assertion failure in parallel query startup", "evidence": {"same_day": true, "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7"}, "url": "/docs/compare/?release=15.11#15.11-5e432f4b08cbf92e", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "f773276377191676df7c3642b74798a8", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Avoid edge-case assertion failure in parallel query startup", "evidence": {"same_day": true, "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7"}, "url": "/docs/compare/?release=14.16#14.16-89a40fa712bb947f", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "fd91c149b0074746d42181c8ca343d83", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Avoid edge-case assertion failure in parallel query startup", "evidence": {"same_day": true, "patch_ids": ["f298e10f6df8ed0882f70ae44117812c"], "statement_hash": "b1ddf81bce204c8887e79d306680fe956f6af3c784286f19c74ced31e3063be7"}, "url": "/docs/compare/?release=13.19#13.19-382281fdd907f983", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-99006adb7f39a151", "cves": [], "html": "Fix assertion failure at shutdown when writing out the statistics file (Michael Paquier) §
", "text": "Fix assertion failure at shutdown when writing out the statistics file (Michael Paquier) §", "title": "Fix assertion failure at shutdown when writing out the statistics file", "commits": ["ae77bcc3a"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "6dd72a3ead5cd76f6d2e3b20222ed73c602db24aa5ca71ae92a7e4e0e0144346", "section_path": ["Changes"], "commit_groups": [["1df1e1e78", "ae77bcc3a", "da99fedf8", "dc5f90541"]], "identity_text": "Fix assertion failure at shutdown when writing out the statistics file (Michael Paquier)", "commit_aliases": ["1df1e1e78", "ae77bcc3a", "da99fedf8", "dc5f90541"], "source_commits": ["ae77bcc3a"], "source_entry_id": "16.7/changes/033", "db_id": "66b75237d9decf1c873e08d8ad836a17", "patch_ids": ["139f4351ce5e8f64631532154fb0e296"], "statement_hash": "c58e651d917e83b95ccf1437733fc06beb988fea87a791145e15976beeb98d5a", "relations": [{"rule": 2, "type": "equivalent", "target": "e0fb3503c73b1acbb61df48fa10a26ff", "evidence": {"same_day": true, "patch_ids": ["139f4351ce5e8f64631532154fb0e296"], "statement_hash": "c58e651d917e83b95ccf1437733fc06beb988fea87a791145e15976beeb98d5a"}}, {"rule": 2, "type": "equivalent", "target": "fc6b8ece9dca73b6ed8a677cad5d3a41", "evidence": {"same_day": true, "patch_ids": ["139f4351ce5e8f64631532154fb0e296"], "statement_hash": "c58e651d917e83b95ccf1437733fc06beb988fea87a791145e15976beeb98d5a"}}], "version": "16.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "fc6b8ece9dca73b6ed8a677cad5d3a41", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Fix assertion failure at shutdown when writing out the statistics file", "evidence": {"same_day": true, "patch_ids": ["139f4351ce5e8f64631532154fb0e296"], "statement_hash": "c58e651d917e83b95ccf1437733fc06beb988fea87a791145e15976beeb98d5a"}, "url": "/docs/compare/?release=17.3#17.3-e2b39e4cdc7369bf", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "e0fb3503c73b1acbb61df48fa10a26ff", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Fix assertion failure at shutdown when writing out the statistics file", "evidence": {"same_day": true, "patch_ids": ["139f4351ce5e8f64631532154fb0e296"], "statement_hash": "c58e651d917e83b95ccf1437733fc06beb988fea87a791145e15976beeb98d5a"}, "url": "/docs/compare/?release=15.11#15.11-d3a085ec168d2201", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}]}, {"id": "16.7-1b29d32f9782ec60", "cves": [], "html": "In NULLIF(), avoid passing a read-write expanded object pointer to the data type's equality function (Tom Lane) §
The equality function could modify or delete the object if it's given a read-write pointer, which would be bad if we decide to return it as the NULLIF() result. There is probably no problem with any built-in equality function, but it's easy to demonstrate a failure with one coded in PL/pgSQL.
Ensure that expression preprocessing is applied to a default null value in INSERT (Tom Lane) §
If the target column is of a domain type, the planner must insert a coerce-to-domain step not just a null constant, and this expression missed going through some required processing steps. There is no known consequence with domains based on core data types, but in theory an error could occur with domains based on extension types.
", "text": "Ensure that expression preprocessing is applied to a default null value in INSERT (Tom Lane) § If the target column is of a domain type, the planner must insert a coerce-to-domain step not just a null constant, and this expression missed going through some required processing steps. There is no known consequence with domains based on core data types, but in theory an error could occur with domains based on extension types.", "title": "Ensure that expression preprocessing is applied to a default null value in INSERT", "commits": ["6655d931c"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "a0cbb1aaba8bc0b71802de7d23b9dd7b9b66c0f7dcaddf124c01c78bd963f1cf", "section_path": ["Changes"], "commit_groups": [["0da39aa76", "6655d931c", "6e41e9e5e", "bb85d0935", "c05268e6e"]], "identity_text": "Ensure that expression preprocessing is applied to a default null value in INSERT (Tom Lane) If the target column is of a domain type, the planner must insert a coerce-to-domain step not just a null constant, and this expression missed going through some required processing steps. There is no known consequence with domains based on core data types, but in theory an error could occur with domains based on extension types.", "commit_aliases": ["0da39aa76", "6655d931c", "6e41e9e5e", "bb85d0935", "c05268e6e"], "source_commits": ["6655d931c"], "source_entry_id": "16.7/changes/035", "db_id": "f058a89b390c55869f483a660569b0aa", "patch_ids": ["81912066ba5e75af1340feda03524ddb"], "statement_hash": "c981aff907b93603eaf7ded2109968ea62ca66b71894982bce348a2ddd2a1483", "relations": [{"rule": 2, "type": "equivalent", "target": "5c924d14c948271fbc38c8d281ec24e1", "evidence": {"same_day": true, "patch_ids": ["81912066ba5e75af1340feda03524ddb"], "statement_hash": "c981aff907b93603eaf7ded2109968ea62ca66b71894982bce348a2ddd2a1483"}}, {"rule": 2, "type": "equivalent", "target": "e38ec1d2b1103ec9341c5b1123335159", "evidence": {"same_day": true, "patch_ids": ["81912066ba5e75af1340feda03524ddb"], "statement_hash": "c981aff907b93603eaf7ded2109968ea62ca66b71894982bce348a2ddd2a1483"}}, {"rule": 2, "type": "equivalent", "target": "e461e7ee096e6254fa7012871a9c1f40", "evidence": {"same_day": true, "patch_ids": ["81912066ba5e75af1340feda03524ddb"], "statement_hash": "c981aff907b93603eaf7ded2109968ea62ca66b71894982bce348a2ddd2a1483"}}], "version": "16.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "5c924d14c948271fbc38c8d281ec24e1", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Ensure that expression preprocessing is applied to a default null value in INSERT", "evidence": {"same_day": true, "patch_ids": ["81912066ba5e75af1340feda03524ddb"], "statement_hash": "c981aff907b93603eaf7ded2109968ea62ca66b71894982bce348a2ddd2a1483"}, "url": "/docs/compare/?release=17.3#17.3-7be5325298b8f565", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "e38ec1d2b1103ec9341c5b1123335159", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Ensure that expression preprocessing is applied to a default null value in INSERT", "evidence": {"same_day": true, "patch_ids": ["81912066ba5e75af1340feda03524ddb"], "statement_hash": "c981aff907b93603eaf7ded2109968ea62ca66b71894982bce348a2ddd2a1483"}, "url": "/docs/compare/?release=15.11#15.11-7e089e52061bb4f6", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "e461e7ee096e6254fa7012871a9c1f40", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Ensure that expression preprocessing is applied to a default null value in INSERT", "evidence": {"same_day": true, "patch_ids": ["81912066ba5e75af1340feda03524ddb"], "statement_hash": "c981aff907b93603eaf7ded2109968ea62ca66b71894982bce348a2ddd2a1483"}, "url": "/docs/compare/?release=14.16#14.16-5ed580f6f0ac7b55", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}]}, {"id": "16.7-7450148e9cea4451", "cves": [], "html": "Repair memory leaks in PL/Python (Mat Arye, Tom Lane) §
\nRepeated use of PLyPlan.execute or plpy.cursor resulted in memory leakage for the duration of the calling PL/Python function.
Fix PL/Tcl to compile with Tcl 9 (Peter Eisentraut) §
", "text": "Fix PL/Tcl to compile with Tcl 9 (Peter Eisentraut) §", "title": "Fix PL/Tcl to compile with Tcl 9", "commits": ["07c77803c"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "4b2f85d994659823b7f0113980eeb6fc0c79e22ec5ec89afd3be344d782fd5bb", "section_path": ["Changes"], "commit_groups": [["07c77803c", "17d081a6f", "32a2aa77e", "a5f9cbde9", "f230e27a2", "f979197eb"]], "identity_text": "Fix PL/Tcl to compile with Tcl 9 (Peter Eisentraut)", "commit_aliases": ["07c77803c", "17d081a6f", "32a2aa77e", "a5f9cbde9", "f230e27a2", "f979197eb"], "source_commits": ["07c77803c"], "source_entry_id": "16.7/changes/037", "db_id": "43ec78dc409230e526b689e924ccab90", "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24", "relations": [{"rule": 2, "type": "equivalent", "target": "0d6f80ed82ee1b2e80a6f8ca9c87a12d", "evidence": {"same_day": true, "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24"}}, {"rule": 2, "type": "equivalent", "target": "129c07a2f63ef2dd97017ea2d4602005", "evidence": {"same_day": true, "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24"}}, {"rule": 2, "type": "equivalent", "target": "b5e22eeed852a78978fa5b94ff645acf", "evidence": {"same_day": true, "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24"}}, {"rule": 2, "type": "equivalent", "target": "eab1bcb0a34c2e2111bf60e2805ede38", "evidence": {"same_day": true, "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24"}}], "version": "16.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "eab1bcb0a34c2e2111bf60e2805ede38", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Fix PL/Tcl to compile with Tcl 9", "evidence": {"same_day": true, "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24"}, "url": "/docs/compare/?release=17.3#17.3-3ed7f6c30ba4fca8", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "129c07a2f63ef2dd97017ea2d4602005", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Fix PL/Tcl to compile with Tcl 9", "evidence": {"same_day": true, "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24"}, "url": "/docs/compare/?release=15.11#15.11-3d33af5f4d4ad225", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "b5e22eeed852a78978fa5b94ff645acf", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Fix PL/Tcl to compile with Tcl 9", "evidence": {"same_day": true, "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24"}, "url": "/docs/compare/?release=14.16#14.16-b84663fdc8246216", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "0d6f80ed82ee1b2e80a6f8ca9c87a12d", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Fix PL/Tcl to compile with Tcl 9", "evidence": {"same_day": true, "patch_ids": ["ec3541438c80f52fc50bed404695777e"], "statement_hash": "3bf0856bd07cd27e1b94839bf3ad9387face99c5bba929e356d86223f0660f24"}, "url": "/docs/compare/?release=13.19#13.19-c88b3b083e0ea08f", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-5309e9bb99c52b63", "cves": [], "html": "In the ecpg preprocessor, fix possible misprocessing of cursors that reference out-of-scope variables (Tom Lane) §
", "text": "In the ecpg preprocessor, fix possible misprocessing of cursors that reference out-of-scope variables (Tom Lane) §", "title": "In the ecpg preprocessor, fix possible misprocessing of cursors that reference out-of-scope variables", "commits": ["cca34f68c"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "da45b96c8bbd5d6f3c1cb133fdc2ec2f14ba881be3e2c14bdc2463d75be01a77", "section_path": ["Changes"], "commit_groups": [["2f696453d", "52c7a44e9", "60b47525c", "a963abd54", "cca34f68c", "e359cbb84"]], "identity_text": "In the ecpg preprocessor, fix possible misprocessing of cursors that reference out-of-scope variables (Tom Lane)", "commit_aliases": ["2f696453d", "52c7a44e9", "60b47525c", "a963abd54", "cca34f68c", "e359cbb84"], "source_commits": ["cca34f68c"], "source_entry_id": "16.7/changes/038", "db_id": "f1227cacc29d5455e9dce3398b0622d4", "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33", "relations": [{"rule": 2, "type": "equivalent", "target": "20aa43ec07c27d96fa929c253c41d044", "evidence": {"same_day": true, "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33"}}, {"rule": 2, "type": "equivalent", "target": "36dfe57940df538e7fb47cd7fdbd37be", "evidence": {"same_day": true, "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33"}}, {"rule": 2, "type": "equivalent", "target": "674e320ee70fdf11884316cc30475c46", "evidence": {"same_day": true, "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33"}}, {"rule": 2, "type": "equivalent", "target": "c4ec9fcca2f80cbbf22f2737f8f5fcb6", "evidence": {"same_day": true, "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33"}}], "version": "16.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c4ec9fcca2f80cbbf22f2737f8f5fcb6", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "In the ecpg preprocessor, fix possible misprocessing of cursors that reference out-of-scope variables", "evidence": {"same_day": true, "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33"}, "url": "/docs/compare/?release=17.3#17.3-dfe5a8c2c2423920", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "674e320ee70fdf11884316cc30475c46", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "In the ecpg preprocessor, fix possible misprocessing of cursors that reference out-of-scope variables", "evidence": {"same_day": true, "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33"}, "url": "/docs/compare/?release=15.11#15.11-0c6c96c4fed5dcb6", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "20aa43ec07c27d96fa929c253c41d044", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "In the ecpg preprocessor, fix possible misprocessing of cursors that reference out-of-scope variables", "evidence": {"same_day": true, "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33"}, "url": "/docs/compare/?release=14.16#14.16-e15053be8332fda8", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "36dfe57940df538e7fb47cd7fdbd37be", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "In the ecpg preprocessor, fix possible misprocessing of cursors that reference out-of-scope variables", "evidence": {"same_day": true, "patch_ids": ["652db5485711a687b7406349a4c34e0e"], "statement_hash": "e0ed27912744c40aae8cb5494cb7622520121573dc0119e7c295c1e55156bc33"}, "url": "/docs/compare/?release=13.19#13.19-96df37ab6e655d81", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-5ec2b4f354ab6cca", "cves": [], "html": "In ecpg, fix compile-time warnings about unsupported use of COPY ... FROM STDIN (Ryo Kanbayashi) §
Previously, the intended warning was not issued due to a typo.
", "text": "In ecpg, fix compile-time warnings about unsupported use of COPY ... FROM STDIN (Ryo Kanbayashi) § Previously, the intended warning was not issued due to a typo.", "title": "In ecpg, fix compile-time warnings about unsupported use of COPY ... FROM STDIN", "commits": ["5c7c34db2"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "21567f4bad3f23023b0896c6ad7ef15a48108505fd16b806788d6e89967b8ace", "section_path": ["Changes"], "commit_groups": [["226c9048d", "5c7c34db2", "71ef47cf0", "94b914f60", "ba2dbedd5", "d06ab3c0c"]], "identity_text": "In ecpg, fix compile-time warnings about unsupported use of COPY ... FROM STDIN (Ryo Kanbayashi) Previously, the intended warning was not issued due to a typo.", "commit_aliases": ["226c9048d", "5c7c34db2", "71ef47cf0", "94b914f60", "ba2dbedd5", "d06ab3c0c"], "source_commits": ["5c7c34db2"], "source_entry_id": "16.7/changes/039", "db_id": "bec199ad48fa75cf12e6e0349c6252cf", "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f", "relations": [{"rule": 2, "type": "equivalent", "target": "16348925260a3ff03e3723c9dd8c2397", "evidence": {"same_day": true, "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f"}}, {"rule": 2, "type": "equivalent", "target": "3ff78f3d2c970b520dbfb8115656b8f2", "evidence": {"same_day": true, "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f"}}, {"rule": 2, "type": "equivalent", "target": "84b39b054b34211ea1d18a290c6cddf4", "evidence": {"same_day": true, "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f"}}, {"rule": 2, "type": "equivalent", "target": "bb2b663ff581a3c13fc37566fef8aea2", "evidence": {"same_day": true, "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f"}}], "version": "16.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "84b39b054b34211ea1d18a290c6cddf4", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "In ecpg, fix compile-time warnings about unsupported use of COPY ... FROM STDIN", "evidence": {"same_day": true, "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f"}, "url": "/docs/compare/?release=17.3#17.3-fe0d2d65c5d4aa3b", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "3ff78f3d2c970b520dbfb8115656b8f2", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "In ecpg, fix compile-time warnings about unsupported use of COPY ... FROM STDIN", "evidence": {"same_day": true, "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f"}, "url": "/docs/compare/?release=15.11#15.11-18a63d75a25dde2a", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "16348925260a3ff03e3723c9dd8c2397", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "In ecpg, fix compile-time warnings about unsupported use of COPY ... FROM STDIN", "evidence": {"same_day": true, "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f"}, "url": "/docs/compare/?release=14.16#14.16-56ba6358d3159b1f", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "bb2b663ff581a3c13fc37566fef8aea2", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "In ecpg, fix compile-time warnings about unsupported use of COPY ... FROM STDIN", "evidence": {"same_day": true, "patch_ids": ["859d58d96aa40e53f1e9fef9aa3f19a9"], "statement_hash": "697f5927852e7b4fbd940f3cf6672127a6ee3d4e28a3272462181a43d4f07b0f"}, "url": "/docs/compare/?release=13.19#13.19-6b7efc6e2fb6ea0b", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-00c7350e9e33d14d", "cves": [], "html": "Fix psql to safely handle file path names that are encoded in SJIS (Tom Lane) §
\nSome two-byte characters in SJIS have a second byte that is equal to ASCII backslash (\\). These characters were corrupted by path name normalization, preventing access to files whose names include such characters.
Fix use of wrong version of pqsignal() in pgbench and psql (Fujii Masao, Tom Lane) §
This error could lead to misbehavior when using the -T option in pgbench or the \\watch command in psql, due to interrupted system calls not being resumed as expected.
Fix misexecution of some nested \\if constructs in pgbench (Michail Nikolaev) §
An \\if command appearing within a false (not-being-executed) \\if branch was incorrectly treated the same as \\elif.
In pgbench, fix possible misdisplay of progress messages during table initialization (Yushi Ogiwara, Tatsuo Ishii, Fujii Masao) § §
", "text": "In pgbench, fix possible misdisplay of progress messages during table initialization (Yushi Ogiwara, Tatsuo Ishii, Fujii Masao) § §", "title": "In pgbench, fix possible misdisplay of progress messages during table initialization", "commits": ["1cf646957", "21b815f92"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "35e5b57def9569404ea8ef6a5787f2c813c6ae43184a723d994791cb9e27c713", "section_path": ["Changes"], "commit_groups": [["0f13e1a78", "1cf646957", "1e46f7351", "adb103fca", "af35fe501", "f1cb5e51f"], ["21b815f92", "499d1cf55", "5addea71c", "b6decfc1d", "e35d396ec", "fb056564e"]], "identity_text": "In pgbench, fix possible misdisplay of progress messages during table initialization (Yushi Ogiwara, Tatsuo Ishii, Fujii Masao)", "commit_aliases": ["0f13e1a78", "1cf646957", "1e46f7351", "21b815f92", "499d1cf55", "5addea71c", "adb103fca", "af35fe501", "b6decfc1d", "e35d396ec", "f1cb5e51f", "fb056564e"], "source_commits": ["1cf646957", "21b815f92"], "source_entry_id": "16.7/changes/043", "db_id": "ae3970b18e126ca505a736ef0e883895", "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76", "relations": [{"rule": 2, "type": "equivalent", "target": "4d088578b652179ddacd9d70bbb67986", "evidence": {"same_day": true, "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76"}}, {"rule": 2, "type": "equivalent", "target": "519999f09977133cde405726c01a0d11", "evidence": {"same_day": true, "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76"}}, {"rule": 2, "type": "equivalent", "target": "54b30b07e73ec94fa147169ad6a3af52", "evidence": {"same_day": true, "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76"}}, {"rule": 2, "type": "equivalent", "target": "8f2041403d7330cc62885e5b2bb1b72c", "evidence": {"same_day": true, "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76"}}], "version": "16.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "519999f09977133cde405726c01a0d11", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "In pgbench, fix possible misdisplay of progress messages during table initialization", "evidence": {"same_day": true, "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76"}, "url": "/docs/compare/?release=17.3#17.3-f7e58e392f141f50", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "54b30b07e73ec94fa147169ad6a3af52", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "In pgbench, fix possible misdisplay of progress messages during table initialization", "evidence": {"same_day": true, "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76"}, "url": "/docs/compare/?release=15.11#15.11-d8a80d74420572fa", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "4d088578b652179ddacd9d70bbb67986", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "In pgbench, fix possible misdisplay of progress messages during table initialization", "evidence": {"same_day": true, "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76"}, "url": "/docs/compare/?release=14.16#14.16-a825ab8faa66bc93", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "8f2041403d7330cc62885e5b2bb1b72c", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "In pgbench, fix possible misdisplay of progress messages during table initialization", "evidence": {"same_day": true, "patch_ids": ["0a5560582674fb45b4e6f22746d1bef2", "e270f759bbf6626c1840935d15c5fbea"], "statement_hash": "685f8c62e53f6f81d21dd2fc16a858df233322c8a6f14aff5be0703a71d2ba76"}, "url": "/docs/compare/?release=13.19#13.19-531838d465c87787", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-64ff08963af3c3de", "cves": [], "html": "Make pg_controldata more robust against corrupted pg_control files (Ilyasov Ian, Anton Voloshin) §
Since pg_controldata will attempt to print the contents of pg_control even if the CRC check fails, it must take care not to misbehave for invalid field values. This patch fixes some issues triggered by invalid timestamps and apparently-negative WAL segment sizes.
Fix possible crash in pg_dump with identity sequences attached to tables that are extension members (Tom Lane) §
", "text": "Fix possible crash in pg_dump with identity sequences attached to tables that are extension members (Tom Lane) §", "title": "Fix possible crash in pg_dump with identity sequences attached to tables that are extension members", "commits": ["782cc1aa3"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "e1f5de94506b8e646b155869075df84f7ea2bed582e6966f044eaca08e74986a", "section_path": ["Changes"], "commit_groups": [["6978129b4", "782cc1aa3", "7b8cb9cd6", "ad950ea98", "b6df2d6e5", "c7f3c414f"]], "identity_text": "Fix possible crash in pg_dump with identity sequences attached to tables that are extension members (Tom Lane)", "commit_aliases": ["6978129b4", "782cc1aa3", "7b8cb9cd6", "ad950ea98", "b6df2d6e5", "c7f3c414f"], "source_commits": ["782cc1aa3"], "source_entry_id": "16.7/changes/045", "db_id": "c0991c19a95931f5a1fb7aff94c40366", "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e", "relations": [{"rule": 2, "type": "equivalent", "target": "477e86c272f9e2c3dbeca3e4c5fcc955", "evidence": {"same_day": true, "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e"}}, {"rule": 2, "type": "equivalent", "target": "7f23a5667f7e389c5f499ce86c38be10", "evidence": {"same_day": true, "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e"}}, {"rule": 2, "type": "equivalent", "target": "8d305380dee5f3d46413d953276a0dad", "evidence": {"same_day": true, "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e"}}, {"rule": 2, "type": "equivalent", "target": "fac028cab5754384359540890bb37419", "evidence": {"same_day": true, "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e"}}], "version": "16.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "7f23a5667f7e389c5f499ce86c38be10", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Fix possible crash in pg_dump with identity sequences attached to tables that are extension members", "evidence": {"same_day": true, "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e"}, "url": "/docs/compare/?release=17.3#17.3-11aed5731d7ba38d", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "477e86c272f9e2c3dbeca3e4c5fcc955", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Fix possible crash in pg_dump with identity sequences attached to tables that are extension members", "evidence": {"same_day": true, "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e"}, "url": "/docs/compare/?release=15.11#15.11-335b0c9dfbab5ea3", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "8d305380dee5f3d46413d953276a0dad", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Fix possible crash in pg_dump with identity sequences attached to tables that are extension members", "evidence": {"same_day": true, "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e"}, "url": "/docs/compare/?release=14.16#14.16-4cd4c5bf7ebc45dc", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "fac028cab5754384359540890bb37419", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Fix possible crash in pg_dump with identity sequences attached to tables that are extension members", "evidence": {"same_day": true, "patch_ids": ["b9eaf84f0baf1dfcbda334cf6921c7c2"], "statement_hash": "dc91f6a071dd8a9fa613462ac52d080a59f42dd4940b888412cfb27b4262447e"}, "url": "/docs/compare/?release=13.19#13.19-5c1a4b77b70a416c", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}, {"id": "16.7-a9fdcc16c16b7460", "cves": [], "html": "Fix memory leak in pg_restore with zstd-compressed data (Tom Lane) §
\nThe leak was per-decompression-operation, so would be most noticeable with a dump containing many tables or large objects.
", "text": "Fix memory leak in pg_restore with zstd-compressed data (Tom Lane) § The leak was per-decompression-operation, so would be most noticeable with a dump containing many tables or large objects.", "title": "Fix memory leak in pg_restore with zstd-compressed data", "commits": ["8cfff087b"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "40a9dc81aab6467874b9aff8b4d438fc2fd368b2521b21f0580afb8521cc85b2", "section_path": ["Changes"], "commit_groups": [["04b860198", "3f0632470", "8cfff087b"]], "identity_text": "Fix memory leak in pg_restore with zstd-compressed data (Tom Lane) The leak was per-decompression-operation, so would be most noticeable with a dump containing many tables or large objects.", "commit_aliases": ["04b860198", "3f0632470", "8cfff087b"], "source_commits": ["8cfff087b"], "source_entry_id": "16.7/changes/046", "db_id": "cad2e74ea43f4fcfbec539f141f9d823", "patch_ids": ["7eb6902f7552709b0ef56d1ac3fb0aad"], "statement_hash": "4fe197941538b9a34f6e43181edb550ddf8c6a08d9b4475398ab4c5536c2816f", "relations": [{"rule": 2, "type": "equivalent", "target": "adb5998aed434cca9c15b8fd23383274", "evidence": {"same_day": true, "patch_ids": ["7eb6902f7552709b0ef56d1ac3fb0aad"], "statement_hash": "4fe197941538b9a34f6e43181edb550ddf8c6a08d9b4475398ab4c5536c2816f"}}], "version": "16.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "adb5998aed434cca9c15b8fd23383274", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Fix memory leak in pg_restore with zstd-compressed data", "evidence": {"same_day": true, "patch_ids": ["7eb6902f7552709b0ef56d1ac3fb0aad"], "statement_hash": "4fe197941538b9a34f6e43181edb550ddf8c6a08d9b4475398ab4c5536c2816f"}, "url": "/docs/compare/?release=17.3#17.3-36b1dae489af1a17", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}]}, {"id": "16.7-27d6b77578650b92", "cves": [], "html": "Fix pg_basebackup to correctly handle pg_wal.tar files exceeding 2GB on Windows (Davinder Singh, Thomas Munro) § §
Use SQL-standard function bodies in the declarations of contrib/earthdistance's SQL-language functions (Tom Lane, Ronan Dunklau) §
This change allows their references to contrib/cube to be resolved during extension creation, reducing the risk of search-path-based failures and possible attacks.
In particular, this restores their usability in contexts like generated columns, for which PostgreSQL v17 restricts the search path on security grounds. We have received reports of databases failing to be upgraded to v17 because of that. This patch has been included in v16 to provide a workaround: updating the earthdistance extension to this version beforehand should allow an upgrade to succeed.
Update configuration probes that determine the compiler switches needed to access ARM CRC instructions (Tom Lane) §
\nOn ARM platforms where the baseline CPU target lacks CRC instructions, we need to supply a -march switch to persuade the compiler to compile such instructions. Recent versions of gcc reject the value we were trying, leading to silently falling back to software CRC.
Fix meson build system to support old OpenSSL libraries on Windows (Darek Slusarczyk) §
\nAdd support for the legacy library names ssleay32 and libeay32.
In Windows builds using meson, ensure all libcommon and libpgport functions are exported (Vladlen Popolitov, Heikki Linnakangas) § §
\nThis fixes “unresolved external symbol” build errors for extensions.
", "text": "In Windows builds using meson, ensure all libcommon and libpgport functions are exported (Vladlen Popolitov, Heikki Linnakangas) § § This fixes “unresolved external symbol” build errors for extensions.", "title": "In Windows builds using meson, ensure all libcommon and libpgport functions are exported", "commits": ["4e0d71ff2", "643efb18b"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "c7adb462054927e9bb3a525ff5ac48211e52cf63861310bc822f311c5238bfff", "section_path": ["Changes"], "commit_groups": [["07f902bd7", "643efb18b", "d8b0c6411"], ["2571c1d5c", "4e0d71ff2", "c80acbc6f"]], "identity_text": "In Windows builds using meson, ensure all libcommon and libpgport functions are exported (Vladlen Popolitov, Heikki Linnakangas) This fixes unresolved external symbol build errors for extensions.", "commit_aliases": ["07f902bd7", "2571c1d5c", "4e0d71ff2", "643efb18b", "c80acbc6f", "d8b0c6411"], "source_commits": ["4e0d71ff2", "643efb18b"], "source_entry_id": "16.7/changes/051", "db_id": "4b26119fdb134955f7779c7a65f8d6d4", "patch_ids": ["65debd777c59314281870528f7dea135", "b169d5a0d35fa5bc464bb73a0ff399cb"], "statement_hash": "1928d3b1486463c44887b3f92a72c78378a987baeb1989c718feeaa08f8753e9", "relations": [{"rule": 2, "type": "equivalent", "target": "da327ea5a2357f6b7a56dcff1f652dbf", "evidence": {"same_day": true, "patch_ids": ["65debd777c59314281870528f7dea135", "b169d5a0d35fa5bc464bb73a0ff399cb"], "statement_hash": "1928d3b1486463c44887b3f92a72c78378a987baeb1989c718feeaa08f8753e9"}}], "version": "16.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "da327ea5a2357f6b7a56dcff1f652dbf", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "In Windows builds using meson, ensure all libcommon and libpgport functions are exported", "evidence": {"same_day": true, "patch_ids": ["65debd777c59314281870528f7dea135", "b169d5a0d35fa5bc464bb73a0ff399cb"], "statement_hash": "1928d3b1486463c44887b3f92a72c78378a987baeb1989c718feeaa08f8753e9"}, "url": "/docs/compare/?release=17.3#17.3-cdfcf7e830c92c76", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}]}, {"id": "16.7-53819fbc94910874", "cves": [], "html": "Fix meson configuration process to correctly detect OSSP's uuid.h header file under MSVC (Andrew Dunstan) §
When building with meson, install pgevent in pkglibdir not bindir (Peter Eisentraut) §
This matches the behavior of the make-based build system and the old MSVC build system.
", "text": "When building with meson, install pgevent in pkglibdir not bindir (Peter Eisentraut) § This matches the behavior of the make-based build system and the old MSVC build system.", "title": "When building with meson, install pgevent in pkglibdir not bindir", "commits": ["766b0b40a"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "81b43c14d219a73870c88fc36123c8df95a6463a0576c5231fc4366d7e696738", "section_path": ["Changes"], "commit_groups": [["4ee130c6e", "766b0b40a", "e00c1e249"]], "identity_text": "When building with meson, install pgevent in pkglibdir not bindir (Peter Eisentraut) This matches the behavior of the make-based build system and the old MSVC build system.", "commit_aliases": ["4ee130c6e", "766b0b40a", "e00c1e249"], "source_commits": ["766b0b40a"], "source_entry_id": "16.7/changes/053", "db_id": "87581ff0c0fbe8029a5aefd20ca85eca", "patch_ids": ["a1e0da7f877b2369bacd3ae49ee9a11e"], "statement_hash": "54ba556cda2e41fd738d93e0aaa441935a1429ebf065528d74879655ada50780", "relations": [{"rule": 2, "type": "equivalent", "target": "bee7fa30399678db283a444722fb509c", "evidence": {"same_day": true, "patch_ids": ["a1e0da7f877b2369bacd3ae49ee9a11e"], "statement_hash": "54ba556cda2e41fd738d93e0aaa441935a1429ebf065528d74879655ada50780"}}], "version": "16.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "bee7fa30399678db283a444722fb509c", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "When building with meson, install pgevent in pkglibdir not bindir", "evidence": {"same_day": true, "patch_ids": ["a1e0da7f877b2369bacd3ae49ee9a11e"], "statement_hash": "54ba556cda2e41fd738d93e0aaa441935a1429ebf065528d74879655ada50780"}, "url": "/docs/compare/?release=17.3#17.3-160a2816ff517421", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}]}, {"id": "16.7-2d6261fb725ebb47", "cves": [], "html": "When building with meson, install sepgsql.sql under share/contrib/ not share/extension/ (Peter Eisentraut) §
This matches what the make-based build system does.
", "text": "When building with meson, install sepgsql.sql under share/contrib/ not share/extension/ (Peter Eisentraut) § This matches what the make-based build system does.", "title": "When building with meson, install sepgsql.sql under share/contrib/ not share/extension/", "commits": ["155d6162e"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "76b7a93ea835c0eee030873e7516385c12cbcc9f00ad92cf348ae0b36ab8be42", "section_path": ["Changes"], "commit_groups": [["02ed3c2bd", "155d6162e", "24c5b73eb"]], "identity_text": "When building with meson, install sepgsql.sql under share/contrib/ not share/extension/ (Peter Eisentraut) This matches what the make-based build system does.", "commit_aliases": ["02ed3c2bd", "155d6162e", "24c5b73eb"], "source_commits": ["155d6162e"], "source_entry_id": "16.7/changes/054", "db_id": "47127e8eaea3452c65bdc178df3adc86", "patch_ids": ["4e11fad9a4c5664cf294ef38993f602c"], "statement_hash": "2c092e252cb03be63e1603b863560e7f70047da9a0e836a8fa8d5175f0224c6a", "relations": [{"rule": 2, "type": "equivalent", "target": "8e7ad12fc517c61dc6a91d2b881cb496", "evidence": {"same_day": true, "patch_ids": ["4e11fad9a4c5664cf294ef38993f602c"], "statement_hash": "2c092e252cb03be63e1603b863560e7f70047da9a0e836a8fa8d5175f0224c6a"}}], "version": "16.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "8e7ad12fc517c61dc6a91d2b881cb496", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "When building with meson, install sepgsql.sql under share/contrib/ not share/extension/", "evidence": {"same_day": true, "patch_ids": ["4e11fad9a4c5664cf294ef38993f602c"], "statement_hash": "2c092e252cb03be63e1603b863560e7f70047da9a0e836a8fa8d5175f0224c6a"}, "url": "/docs/compare/?release=17.3#17.3-2b777acca3f50926", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}]}, {"id": "16.7-3c5219a3c087cbf0", "cves": [], "html": "Update time zone data files to tzdata release 2025a for DST law changes in Paraguay, plus historical corrections for the Philippines (Tom Lane) §
", "text": "Update time zone data files to tzdata release 2025a for DST law changes in Paraguay, plus historical corrections for the Philippines (Tom Lane) §", "title": "Update time zone data files to tzdata release 2025a for DST law changes in Paraguay, plus historical corrections for the Philippines", "commits": ["d62403c51"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/16.7/#RELEASE-16-7-CHANGES", "source_hash": "a9b971fda29004803cd0dd46de89689945eeba760f5e71e6d4ffb2d1471d2bdb", "section_path": ["Changes"], "commit_groups": [["20b4819d0", "48bc95d0d", "60c513f8f", "6397819c8", "d62403c51", "e292ba333"]], "identity_text": "Update time zone data files to tzdata release 2025a for DST law changes in Paraguay, plus historical corrections for the Philippines (Tom Lane)", "commit_aliases": ["20b4819d0", "48bc95d0d", "60c513f8f", "6397819c8", "d62403c51", "e292ba333"], "source_commits": ["d62403c51"], "source_entry_id": "16.7/changes/055", "db_id": "96dcfa4106a9d8c891112ee991959a59", "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b", "relations": [{"rule": 2, "type": "equivalent", "target": "142b6f5b8f5412088d8a118b9747bbd1", "evidence": {"same_day": true, "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b"}}, {"rule": 2, "type": "equivalent", "target": "b2eef5973920bcf8f3be6ddb2e79db35", "evidence": {"same_day": true, "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b"}}, {"rule": 2, "type": "equivalent", "target": "c7a079298874b849c2e215248946734d", "evidence": {"same_day": true, "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b"}}, {"rule": 2, "type": "equivalent", "target": "f6f570a8d6d74874c021872f79b537b9", "evidence": {"same_day": true, "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b"}}], "version": "16.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "142b6f5b8f5412088d8a118b9747bbd1", "kind": "equivalent", "version": "17.3", "label": "17.3", "title": "Update time zone data files to tzdata release 2025a for DST law changes in Paraguay, plus historical corrections for the Philippines", "evidence": {"same_day": true, "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b"}, "url": "/docs/compare/?release=17.3#17.3-bf7d1c9ccfa2521e", "source_url": "/docs/release/17.3/#RELEASE-17-3-CHANGES"}, {"db_id": "c7a079298874b849c2e215248946734d", "kind": "equivalent", "version": "15.11", "label": "15.11", "title": "Update time zone data files to tzdata release 2025a for DST law changes in Paraguay, plus historical corrections for the Philippines", "evidence": {"same_day": true, "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b"}, "url": "/docs/compare/?release=15.11#15.11-3a998d6879710842", "source_url": "/docs/release/15.11/#id-1.11.6.14.5"}, {"db_id": "f6f570a8d6d74874c021872f79b537b9", "kind": "equivalent", "version": "14.16", "label": "14.16", "title": "Update time zone data files to tzdata release 2025a for DST law changes in Paraguay, plus historical corrections for the Philippines", "evidence": {"same_day": true, "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b"}, "url": "/docs/compare/?release=14.16#14.16-6c536e8b80eb9696", "source_url": "/docs/release/14.16/#id-1.11.6.14.5"}, {"db_id": "b2eef5973920bcf8f3be6ddb2e79db35", "kind": "equivalent", "version": "13.19", "label": "13.19", "title": "Update time zone data files to tzdata release 2025a for DST law changes in Paraguay, plus historical corrections for the Philippines", "evidence": {"same_day": true, "patch_ids": ["b96e4bf70e6c7d6fc7f41c80dad551de"], "statement_hash": "5346ed21e02631d4697c45a0336cf64356b252cb09dfea4366d7c5b3f02cc25b"}, "url": "/docs/compare/?release=13.19#13.19-e9856e484813a85d", "source_url": "/docs/release/13.19/#id-1.11.6.10.6"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 55}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 31}, {"key": "security", "label": "Security", "count": 1}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 23}], "total": 55, "release_count": 1, "cross_major": false, "cve_count": 1, "cves": [{"id": "CVE-2025-1094", "url": "https://www.postgresql.org/support/security/CVE-2025-1094/", "fixed": {"13": "13.19", "14": "14.16", "15": "15.11", "16": "16.7", "17": "17.3"}, "score": 8.1, "title": "Harden PQescapeString and allied functions against invalidly-encoded input strings", "vector": "AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:H/A:H", "cna_url": "https://cveawg.mitre.org/api/cve/CVE-2025-1094", "affected": {"13": "13", "14": "14", "15": "15", "16": "16", "17": "17"}, "component": "core server", "published": {"13": "2025-02-13", "14": "2025-02-13", "15": "2025-02-13", "16": "2025-02-13", "17": "2025-02-13"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Improper neutralization of quoting syntax in PostgreSQL libpq functions PQescapeLiteral(), PQescapeIdentifier(), PQescapeString(), and PQescapeStringConn() allows a database input provider to achieve SQL injection in certain usage patterns. Specifically, SQL injection requires the application to use the function result to construct input to psql, the PostgreSQL interactive terminal. Similarly, improper neutralization of quoting syntax in PostgreSQL command line utility programs allows a source of command line arguments to achieve SQL injection when client_encoding is BIG5 and server_encoding is one of EUC_TW or MULE_INTERNAL. Versions before PostgreSQL 17.3, 16.7, 15.11, 14.16, and 13.19 are affected.", "affected_ranges": [{"from": "0", "until": "13.19"}, {"from": "14", "until": "14.16"}, {"from": "15", "until": "15.11"}, {"from": "16", "until": "16.7"}, {"from": "17", "until": "17.3"}], "first_published": "2025-02-13", "fixed_version": "16.7"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 55, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}