A dump/restore is not required for those running 14.X.
\nHowever, if you are upgrading from a version earlier than 14.4, see Section E.21.
", "compatibility_count": 0, "label": "14.7", "status_label": "Supported", "eol": "2026-11-12", "age_days": 1328, "support_days": 44}, "groups": [{"date": "2023-02-09", "build": "14.7", "major": "14", "minor": 7, "manual": "14", "status": "stable", "doc_git": "", "version": "14.7", "eol_date": "2026-11-12", "date_text": "2023-02-09", "supported": true, "manual_url": "/docs/14/release-14-7.html", "source_url": "/docs/release/14.7/", "entry_count": 47, "placeholder": false, "content_hash": "d9d8796ba513a14cd2b6e154e63ab7d625effac5434261a56071683bbfff222b", "manual_build": "14.24", "source_as_of": "", "changes_count": 47, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 14.X.
\nHowever, if you are upgrading from a version earlier than 14.4, see Section E.21.
", "compatibility_count": 0, "label": "14.7", "status_label": "Supported", "eol": "2026-11-12", "age_days": 1328, "support_days": 44, "entries": [{"id": "14.7-2dbd2730debe7f61", "cves": ["CVE-2022-41862"], "html": "libpq can leak memory contents after GSSAPI transport encryption initiation fails (Jacob Champion) §
\nA modified server, or an unauthenticated man-in-the-middle, can send a not-zero-terminated error message during setup of GSSAPI (Kerberos) transport encryption. libpq will then copy that string, as well as following bytes in application memory up to the next zero byte, to its error report. Depending on what the calling application does with the error report, this could result in disclosure of application memory contents. There is also a small probability of a crash due to reading beyond the end of memory. Fix by properly zero-terminating the server message. (CVE-2022-41862)
", "text": "libpq can leak memory contents after GSSAPI transport encryption initiation fails (Jacob Champion) § A modified server, or an unauthenticated man-in-the-middle, can send a not-zero-terminated error message during setup of GSSAPI (Kerberos) transport encryption. libpq will then copy that string, as well as following bytes in application memory up to the next zero byte, to its error report. Depending on what the calling application does with the error report, this could result in disclosure of application memory contents. There is also a small probability of a crash due to reading beyond the end of memory. Fix by properly zero-terminating the server message. (CVE-2022-41862)", "title": "libpq can leak memory contents after GSSAPI transport encryption initiation fails", "commits": ["626f2c1d6"], "section": "Changes", "category": "security", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "d0e1de06b927f40a270ab509acdfaefb835444fa8b80946fb245780d43698016", "section_path": ["Changes"], "commit_groups": [["3f7342671", "45a945ee9", "626f2c1d6", "715c345dd", "71c37797d"]], "identity_text": "libpq can leak memory contents after GSSAPI transport encryption initiation fails (Jacob Champion) A modified server, or an unauthenticated man-in-the-middle, can send a not-zero-terminated error message during setup of GSSAPI (Kerberos) transport encryption. libpq will then copy that string, as well as following bytes in application memory up to the next zero byte, to its error report. Depending on what the calling application does with the error report, this could result in disclosure of application memory contents. There is also a small probability of a crash due to reading beyond the end of memory. Fix by properly zero-terminating the server message. (CVE-2022-41862)", "commit_aliases": ["3f7342671", "45a945ee9", "626f2c1d6", "715c345dd", "71c37797d"], "source_commits": ["626f2c1d6"], "source_entry_id": "14.7/changes/001", "db_id": "84097a2dbd0e2416e528ec1b7e12655f", "patch_ids": ["142cd68f769e669eacd8f52bba9a8194"], "statement_hash": "f21c6966376d22108f84c4b98159922066b1883abb84007f1eda0a7248894956", "relations": [{"rule": 2, "type": "equivalent", "target": "44c395e376c7cd3c93049fcea68d1398", "evidence": {"same_day": true, "patch_ids": ["142cd68f769e669eacd8f52bba9a8194"], "statement_hash": "f21c6966376d22108f84c4b98159922066b1883abb84007f1eda0a7248894956"}}, {"rule": 2, "type": "equivalent", "target": "6972d6a9e3a94239c67a54106708d323", "evidence": {"same_day": true, "patch_ids": ["142cd68f769e669eacd8f52bba9a8194"], "statement_hash": "f21c6966376d22108f84c4b98159922066b1883abb84007f1eda0a7248894956"}}, {"rule": 2, "type": "equivalent", "target": "e645f7bfeb83e81c2ad8f0c9a3338368", "evidence": {"same_day": true, "patch_ids": ["142cd68f769e669eacd8f52bba9a8194"], "statement_hash": "f21c6966376d22108f84c4b98159922066b1883abb84007f1eda0a7248894956"}}], "version": "14.7", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "6972d6a9e3a94239c67a54106708d323", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "libpq can leak memory contents after GSSAPI transport encryption initiation fails", "evidence": {"same_day": true, "patch_ids": ["142cd68f769e669eacd8f52bba9a8194"], "statement_hash": "f21c6966376d22108f84c4b98159922066b1883abb84007f1eda0a7248894956"}, "url": "/docs/compare/?release=15.2#15.2-259471afd131584c", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "e645f7bfeb83e81c2ad8f0c9a3338368", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "libpq can leak memory contents after GSSAPI transport encryption initiation fails", "evidence": {"same_day": true, "patch_ids": ["142cd68f769e669eacd8f52bba9a8194"], "statement_hash": "f21c6966376d22108f84c4b98159922066b1883abb84007f1eda0a7248894956"}, "url": "/docs/compare/?release=13.10#13.10-23596c45357945bb", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "44c395e376c7cd3c93049fcea68d1398", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "libpq can leak memory contents after GSSAPI transport encryption initiation fails", "evidence": {"same_day": true, "patch_ids": ["142cd68f769e669eacd8f52bba9a8194"], "statement_hash": "f21c6966376d22108f84c4b98159922066b1883abb84007f1eda0a7248894956"}, "url": "/docs/compare/?release=12.14#12.14-3713e48c990849a8", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}]}, {"id": "14.7-7bccf392a64268ee", "cves": [], "html": "Fix calculation of which GENERATED columns need to be updated in child tables during an UPDATE on a partitioned table or inheritance tree (Amit Langote, Tom Lane) § §
This fixes failure to update GENERATED columns that do not exist in the parent table, or that have different dependencies than are in the parent column's generation expression.
Allow a WITH RECURSIVE ... CYCLE CTE to access its output column (Tom Lane) §
A reference to the SET column from within the CTE would fail with “cache lookup failed for type 0”.
Fix handling of pending inserts when doing a bulk insertion to a foreign table (Etsuro Fujita) § §
\nIn some cases pending insertions were not flushed to the FDW soon enough, leading to logical inconsistencies, for example BEFORE ROW triggers not seeing rows they should be able to see.
Allow REPLICA IDENTITY to be set on an index that's not (yet) valid (Tom Lane) §
When pg_dump dumps a partitioned index that's marked REPLICA IDENTITY, it generates a command sequence that applies REPLICA IDENTITY before the partitioned index has been marked valid, causing restore to fail. There seems no very good reason to prohibit doing it in that order, so allow it. The marking will have no effect anyway until the index becomes valid.
Fix handling of DEFAULT markers in rules that perform an INSERT from a multi-row VALUES list (Dean Rasheed) §
In some cases a DEFAULT marker would not get replaced with the proper default-value expression, leading to an “unrecognized node type” error.
Reject uses of undefined variables in jsonpath existence checks (Alexander Korotkov, David G. Johnston) §
While jsonpath match operators threw an error for an undefined variable in the path pattern, the existence operators silently treated it as a match.
Fix jsonb subscripting to cope with toasted subscript values (Tom Lane, David G. Johnston) §
Using a text value fetched directly from a table as a jsonb subscript was likely to fail. Fetches would usually not find any matching element. Assignments could store the value with a garbage key, although keys long enough to cause that problem are probably rare in the field.
Fix edge-case data corruption in parallel hash joins (Dmitry Astapov) §
\nIf the final chunk of a large tuple being written out to a temporary file was exactly 32760 bytes, it would be corrupted due to a fencepost bug. The query would typically fail later with corrupted-data symptoms.
", "text": "Fix edge-case data corruption in parallel hash joins (Dmitry Astapov) § If the final chunk of a large tuple being written out to a temporary file was exactly 32760 bytes, it would be corrupted due to a fencepost bug. The query would typically fail later with corrupted-data symptoms.", "title": "Fix edge-case data corruption in parallel hash joins", "commits": ["2f65b8468"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "768ed6e7892374b47dcd332747700d89583863a29ceb211c5b481d17eae4d31d", "section_path": ["Changes"], "commit_groups": [["1a5afe007", "2f65b8468", "b55303792", "d95dcc9ab", "d9f5345bf", "ffcf6f4cf"]], "identity_text": "Fix edge-case data corruption in parallel hash joins (Dmitry Astapov) If the final chunk of a large tuple being written out to a temporary file was exactly 32760 bytes, it would be corrupted due to a fencepost bug. The query would typically fail later with corrupted-data symptoms.", "commit_aliases": ["1a5afe007", "2f65b8468", "b55303792", "d95dcc9ab", "d9f5345bf", "ffcf6f4cf"], "source_commits": ["2f65b8468"], "source_entry_id": "14.7/changes/009", "db_id": "17baafcf991fbee7db5fd59cfa4ebe26", "patch_ids": ["ed4e4b8eef5b19e3626542d6943bb6b8"], "statement_hash": "4a51d715717e30be6e1cee4a61dd098e72b0b0e2c8099e317041336e054c13e8", "relations": [{"rule": 2, "type": "equivalent", "target": "58c1639ecc5c6ebcdfd574d1218a9233", "evidence": {"same_day": true, "patch_ids": ["ed4e4b8eef5b19e3626542d6943bb6b8"], "statement_hash": "4a51d715717e30be6e1cee4a61dd098e72b0b0e2c8099e317041336e054c13e8"}}, {"rule": 2, "type": "equivalent", "target": "8c118d8792453bb06a4ce9445538846a", "evidence": {"same_day": true, "patch_ids": ["ed4e4b8eef5b19e3626542d6943bb6b8"], "statement_hash": "4a51d715717e30be6e1cee4a61dd098e72b0b0e2c8099e317041336e054c13e8"}}, {"rule": 2, "type": "equivalent", "target": "9a4c9851e7901484319f65e80da16939", "evidence": {"same_day": true, "patch_ids": ["ed4e4b8eef5b19e3626542d6943bb6b8"], "statement_hash": "4a51d715717e30be6e1cee4a61dd098e72b0b0e2c8099e317041336e054c13e8"}}, {"rule": 2, "type": "equivalent", "target": "fcfcf4d0c5151a6b2a0296b2cbd0a33f", "evidence": {"same_day": true, "patch_ids": ["ed4e4b8eef5b19e3626542d6943bb6b8"], "statement_hash": "4a51d715717e30be6e1cee4a61dd098e72b0b0e2c8099e317041336e054c13e8"}}], "version": "14.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "fcfcf4d0c5151a6b2a0296b2cbd0a33f", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Fix edge-case data corruption in parallel hash joins", "evidence": {"same_day": true, "patch_ids": ["ed4e4b8eef5b19e3626542d6943bb6b8"], "statement_hash": "4a51d715717e30be6e1cee4a61dd098e72b0b0e2c8099e317041336e054c13e8"}, "url": "/docs/compare/?release=15.2#15.2-900dd95c4f11c9be", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "58c1639ecc5c6ebcdfd574d1218a9233", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Fix edge-case data corruption in parallel hash joins", "evidence": {"same_day": true, "patch_ids": ["ed4e4b8eef5b19e3626542d6943bb6b8"], "statement_hash": "4a51d715717e30be6e1cee4a61dd098e72b0b0e2c8099e317041336e054c13e8"}, "url": "/docs/compare/?release=13.10#13.10-ed92b3b2e5edc19f", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "9a4c9851e7901484319f65e80da16939", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Fix edge-case data corruption in parallel hash joins", "evidence": {"same_day": true, "patch_ids": ["ed4e4b8eef5b19e3626542d6943bb6b8"], "statement_hash": "4a51d715717e30be6e1cee4a61dd098e72b0b0e2c8099e317041336e054c13e8"}, "url": "/docs/compare/?release=12.14#12.14-85fcd213ed83aa7c", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "8c118d8792453bb06a4ce9445538846a", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "Fix edge-case data corruption in parallel hash joins", "evidence": {"same_day": true, "patch_ids": ["ed4e4b8eef5b19e3626542d6943bb6b8"], "statement_hash": "4a51d715717e30be6e1cee4a61dd098e72b0b0e2c8099e317041336e054c13e8"}, "url": "/docs/compare/?release=11.19#11.19-1057ba81081ccf89", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}, {"id": "14.7-432b3036d6f75e0a", "cves": [], "html": "Honor non-default settings of checkpoint_completion_target (Bharath Rupireddy) §
Internal state was not updated after a change in checkpoint_completion_target, possibly resulting in performing checkpoint I/O faster or slower than desired, especially if that setting was changed on-the-fly.
Log the correct ending timestamp in recovery_target_xid mode (Tom Lane) §
When ending recovery based on the recovery_target_xid setting with recovery_target_inclusive = off, we printed an incorrect timestamp (always 2000-01-01) in the “recovery stopping before ... transaction” log message.
Improve error reporting for some buffered file read failures (Peter Eisentraut) §
\nCorrectly report a short read, giving the numbers of bytes desired and actually read, instead of reporting an irrelevant error code. Most places got this right already, but some recently-written replication logic did not.
", "text": "Improve error reporting for some buffered file read failures (Peter Eisentraut) § Correctly report a short read, giving the numbers of bytes desired and actually read, instead of reporting an irrelevant error code. Most places got this right already, but some recently-written replication logic did not.", "title": "Improve error reporting for some buffered file read failures", "commits": ["f463335e1"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "3acd0ab433203d9877c27063dc4c5ddf9fb8c02bfc4d317564de00db6c205a8f", "section_path": ["Changes"], "commit_groups": [["1561612e3", "ac01fa647", "cf74b6ead", "f463335e1"]], "identity_text": "Improve error reporting for some buffered file read failures (Peter Eisentraut) Correctly report a short read, giving the numbers of bytes desired and actually read, instead of reporting an irrelevant error code. Most places got this right already, but some recently-written replication logic did not.", "commit_aliases": ["1561612e3", "ac01fa647", "cf74b6ead", "f463335e1"], "source_commits": ["f463335e1"], "source_entry_id": "14.7/changes/012", "db_id": "6bbfe331c8bd0d5751f0932248de5974", "patch_ids": ["d503528c415d00115660f603efdb4782"], "statement_hash": "ec70a702b05badf9af5df233a8180cb3381671e94deb6ee4799a910e8705dbc4", "relations": [{"rule": 2, "type": "equivalent", "target": "910a2fcdec010be9b0d2746fee475942", "evidence": {"same_day": true, "patch_ids": ["d503528c415d00115660f603efdb4782"], "statement_hash": "ec70a702b05badf9af5df233a8180cb3381671e94deb6ee4799a910e8705dbc4"}}, {"rule": 2, "type": "equivalent", "target": "bacb2dc45b0af2b34fb185ce6aa6b534", "evidence": {"same_day": true, "patch_ids": ["d503528c415d00115660f603efdb4782"], "statement_hash": "ec70a702b05badf9af5df233a8180cb3381671e94deb6ee4799a910e8705dbc4"}}], "version": "14.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "910a2fcdec010be9b0d2746fee475942", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Improve error reporting for some buffered file read failures", "evidence": {"same_day": true, "patch_ids": ["d503528c415d00115660f603efdb4782"], "statement_hash": "ec70a702b05badf9af5df233a8180cb3381671e94deb6ee4799a910e8705dbc4"}, "url": "/docs/compare/?release=15.2#15.2-a071a5627dd9cf41", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "bacb2dc45b0af2b34fb185ce6aa6b534", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Improve error reporting for some buffered file read failures", "evidence": {"same_day": true, "patch_ids": ["d503528c415d00115660f603efdb4782"], "statement_hash": "ec70a702b05badf9af5df233a8180cb3381671e94deb6ee4799a910e8705dbc4"}, "url": "/docs/compare/?release=13.10#13.10-1cdf3bd8c3aaf3ca", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}]}, {"id": "14.7-666515aaeaa83575", "cves": [], "html": "In extended query protocol, avoid an immediate commit after ANALYZE if we're running a pipeline (Tom Lane) §
If there's not been an explicit BEGIN TRANSACTION, ANALYZE would take it on itself to commit, which should not happen within a pipelined series of commands.
Reject cancel request packets having the wrong length (Andrey Borodin) §
\nThe server would process a cancel request even if its length word was too small. This led to reading beyond the end of the allocated buffer. In theory that could cause a segfault, but it seems quite unlikely to happen in practice, since the buffer would have to be very close to the end of memory. The more likely outcome was a bogus log message about wrong backend PID or cancel code. Complain about the wrong length, instead.
", "text": "Reject cancel request packets having the wrong length (Andrey Borodin) § The server would process a cancel request even if its length word was too small. This led to reading beyond the end of the allocated buffer. In theory that could cause a segfault, but it seems quite unlikely to happen in practice, since the buffer would have to be very close to the end of memory. The more likely outcome was a bogus log message about wrong backend PID or cancel code. Complain about the wrong length, instead.", "title": "Reject cancel request packets having the wrong length", "commits": ["6900aea67"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "896589c5cae9f8efd4c9e4bea2d294887199c4b8dc6898bc70d0579644260a89", "section_path": ["Changes"], "commit_groups": [["6900aea67", "8f70de7e0", "a9bccffe5", "b152bb7b2", "e52daaabf", "e75b5c855"]], "identity_text": "Reject cancel request packets having the wrong length (Andrey Borodin) The server would process a cancel request even if its length word was too small. This led to reading beyond the end of the allocated buffer. In theory that could cause a segfault, but it seems quite unlikely to happen in practice, since the buffer would have to be very close to the end of memory. The more likely outcome was a bogus log message about wrong backend PID or cancel code. Complain about the wrong length, instead.", "commit_aliases": ["6900aea67", "8f70de7e0", "a9bccffe5", "b152bb7b2", "e52daaabf", "e75b5c855"], "source_commits": ["6900aea67"], "source_entry_id": "14.7/changes/014", "db_id": "7fa280ab24f9d5ddd2a56f45d4ffca65", "patch_ids": ["4a585c04a8486d7d2d2fc0188102e7f2"], "statement_hash": "5934eb496fa5e338ee30f760357ba25b34ae3381414dec4210b32506b0e779a8", "relations": [{"rule": 2, "type": "equivalent", "target": "0ca75a37b68a2dc0bfeff23a25e77ba0", "evidence": {"same_day": true, "patch_ids": ["4a585c04a8486d7d2d2fc0188102e7f2"], "statement_hash": "5934eb496fa5e338ee30f760357ba25b34ae3381414dec4210b32506b0e779a8"}}, {"rule": 2, "type": "equivalent", "target": "704a6634c16ef7df7bcdf60048ae61a0", "evidence": {"same_day": true, "patch_ids": ["4a585c04a8486d7d2d2fc0188102e7f2"], "statement_hash": "5934eb496fa5e338ee30f760357ba25b34ae3381414dec4210b32506b0e779a8"}}, {"rule": 2, "type": "equivalent", "target": "9debe525460effd204276d88508b491c", "evidence": {"same_day": true, "patch_ids": ["4a585c04a8486d7d2d2fc0188102e7f2"], "statement_hash": "5934eb496fa5e338ee30f760357ba25b34ae3381414dec4210b32506b0e779a8"}}, {"rule": 2, "type": "equivalent", "target": "f77b12baef4c96feae19e6651e311743", "evidence": {"same_day": true, "patch_ids": ["4a585c04a8486d7d2d2fc0188102e7f2"], "statement_hash": "5934eb496fa5e338ee30f760357ba25b34ae3381414dec4210b32506b0e779a8"}}], "version": "14.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "704a6634c16ef7df7bcdf60048ae61a0", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Reject cancel request packets having the wrong length", "evidence": {"same_day": true, "patch_ids": ["4a585c04a8486d7d2d2fc0188102e7f2"], "statement_hash": "5934eb496fa5e338ee30f760357ba25b34ae3381414dec4210b32506b0e779a8"}, "url": "/docs/compare/?release=15.2#15.2-1a2f254299955365", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "9debe525460effd204276d88508b491c", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Reject cancel request packets having the wrong length", "evidence": {"same_day": true, "patch_ids": ["4a585c04a8486d7d2d2fc0188102e7f2"], "statement_hash": "5934eb496fa5e338ee30f760357ba25b34ae3381414dec4210b32506b0e779a8"}, "url": "/docs/compare/?release=13.10#13.10-36c77ab5f60c2fec", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "f77b12baef4c96feae19e6651e311743", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Reject cancel request packets having the wrong length", "evidence": {"same_day": true, "patch_ids": ["4a585c04a8486d7d2d2fc0188102e7f2"], "statement_hash": "5934eb496fa5e338ee30f760357ba25b34ae3381414dec4210b32506b0e779a8"}, "url": "/docs/compare/?release=12.14#12.14-6a979fa32fad601a", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "0ca75a37b68a2dc0bfeff23a25e77ba0", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "Reject cancel request packets having the wrong length", "evidence": {"same_day": true, "patch_ids": ["4a585c04a8486d7d2d2fc0188102e7f2"], "statement_hash": "5934eb496fa5e338ee30f760357ba25b34ae3381414dec4210b32506b0e779a8"}, "url": "/docs/compare/?release=11.19#11.19-8fc865ae005d5dbb", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}, {"id": "14.7-da8d00e103dbea9a", "cves": [], "html": "Add recursion and looping defenses in subquery pullup (Tom Lane) §
\nA contrived query can result in deep recursion and unreasonable amounts of time spent trying to flatten subqueries. A proper fix for that seems unduly invasive for a back-patch, but we can at least add stack depth checks and an interrupt check to allow the query to be cancelled.
", "text": "Add recursion and looping defenses in subquery pullup (Tom Lane) § A contrived query can result in deep recursion and unreasonable amounts of time spent trying to flatten subqueries. A proper fix for that seems unduly invasive for a back-patch, but we can at least add stack depth checks and an interrupt check to allow the query to be cancelled.", "title": "Add recursion and looping defenses in subquery pullup", "commits": ["97431d673"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "958af6b266c1b40dfd65ea4ce0360a74d05c61372fadd0121a70b939e9d9c15f", "section_path": ["Changes"], "commit_groups": [["1a3daa5bb", "4fceb454f", "5beb7881f", "8cd700cc5", "97431d673", "d572003f7"]], "identity_text": "Add recursion and looping defenses in subquery pullup (Tom Lane) A contrived query can result in deep recursion and unreasonable amounts of time spent trying to flatten subqueries. A proper fix for that seems unduly invasive for a back-patch, but we can at least add stack depth checks and an interrupt check to allow the query to be cancelled.", "commit_aliases": ["1a3daa5bb", "4fceb454f", "5beb7881f", "8cd700cc5", "97431d673", "d572003f7"], "source_commits": ["97431d673"], "source_entry_id": "14.7/changes/015", "db_id": "fdceeabfdcd8e34505ab07c4d5612bd4", "patch_ids": ["36ed289451f3942e317c05bea9704165"], "statement_hash": "b9bcf77ecf301d3825a33e1113dddf8b686f10adf99f609ff924f11fc765071f", "relations": [{"rule": 2, "type": "equivalent", "target": "362730489706fa81e58f4c999e886e0e", "evidence": {"same_day": true, "patch_ids": ["36ed289451f3942e317c05bea9704165"], "statement_hash": "b9bcf77ecf301d3825a33e1113dddf8b686f10adf99f609ff924f11fc765071f"}}, {"rule": 2, "type": "equivalent", "target": "5af068db3341269c18db67f0336598f0", "evidence": {"same_day": true, "patch_ids": ["36ed289451f3942e317c05bea9704165"], "statement_hash": "b9bcf77ecf301d3825a33e1113dddf8b686f10adf99f609ff924f11fc765071f"}}, {"rule": 2, "type": "equivalent", "target": "7c6d42673b3e4664bd79bc8f9f6ea38d", "evidence": {"same_day": true, "patch_ids": ["36ed289451f3942e317c05bea9704165"], "statement_hash": "b9bcf77ecf301d3825a33e1113dddf8b686f10adf99f609ff924f11fc765071f"}}, {"rule": 2, "type": "equivalent", "target": "c00645f9f75d71aa6acb6087397460db", "evidence": {"same_day": true, "patch_ids": ["36ed289451f3942e317c05bea9704165"], "statement_hash": "b9bcf77ecf301d3825a33e1113dddf8b686f10adf99f609ff924f11fc765071f"}}], "version": "14.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "362730489706fa81e58f4c999e886e0e", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Add recursion and looping defenses in subquery pullup", "evidence": {"same_day": true, "patch_ids": ["36ed289451f3942e317c05bea9704165"], "statement_hash": "b9bcf77ecf301d3825a33e1113dddf8b686f10adf99f609ff924f11fc765071f"}, "url": "/docs/compare/?release=15.2#15.2-5090984861bce8c8", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "c00645f9f75d71aa6acb6087397460db", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Add recursion and looping defenses in subquery pullup", "evidence": {"same_day": true, "patch_ids": ["36ed289451f3942e317c05bea9704165"], "statement_hash": "b9bcf77ecf301d3825a33e1113dddf8b686f10adf99f609ff924f11fc765071f"}, "url": "/docs/compare/?release=13.10#13.10-d35cca4c09de4185", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "7c6d42673b3e4664bd79bc8f9f6ea38d", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Add recursion and looping defenses in subquery pullup", "evidence": {"same_day": true, "patch_ids": ["36ed289451f3942e317c05bea9704165"], "statement_hash": "b9bcf77ecf301d3825a33e1113dddf8b686f10adf99f609ff924f11fc765071f"}, "url": "/docs/compare/?release=12.14#12.14-5ed3b667487988cc", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "5af068db3341269c18db67f0336598f0", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "Add recursion and looping defenses in subquery pullup", "evidence": {"same_day": true, "patch_ids": ["36ed289451f3942e317c05bea9704165"], "statement_hash": "b9bcf77ecf301d3825a33e1113dddf8b686f10adf99f609ff924f11fc765071f"}, "url": "/docs/compare/?release=11.19#11.19-d9d142d540ffa7c9", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}, {"id": "14.7-cafb265189ede67a", "cves": [], "html": "Fix planner issues when combining Memoize nodes with partitionwise joins or parameterized nestloops (Richard Guo) § §
\nThese errors could lead to not using Memoize in contexts where it would be useful, or possibly to wrong query plans.
", "text": "Fix planner issues when combining Memoize nodes with partitionwise joins or parameterized nestloops (Richard Guo) § § These errors could lead to not using Memoize in contexts where it would be useful, or possibly to wrong query plans.", "title": "Fix planner issues when combining Memoize nodes with partitionwise joins or parameterized nestloops", "commits": ["ce093aa18", "dc3648f65"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "cbc74cd714e0a7a54494a4a6bfb54250bf5a4f77e74559fee965f5342ca28916", "section_path": ["Changes"], "commit_groups": [["834d97c32", "ce093aa18", "e76913802"], ["c959f84c2", "d69d01ba9", "dc3648f65"]], "identity_text": "Fix planner issues when combining Memoize nodes with partitionwise joins or parameterized nestloops (Richard Guo) These errors could lead to not using Memoize in contexts where it would be useful, or possibly to wrong query plans.", "commit_aliases": ["834d97c32", "c959f84c2", "ce093aa18", "d69d01ba9", "dc3648f65", "e76913802"], "source_commits": ["ce093aa18", "dc3648f65"], "source_entry_id": "14.7/changes/016", "db_id": "c0d3ce9372df0afbbb3f47158c0867a0", "patch_ids": ["30370a4ec989b7239d5aef5278fc05ef", "5c6e090c8079ba9092c28d371b17bfd3"], "statement_hash": "094a4815119a5ab935b4ddcf7dfe72424b6cbbb8771db238a91bd2658c868599", "relations": [{"rule": 2, "type": "equivalent", "target": "fedab078255a227307e0fb716d19e1a6", "evidence": {"same_day": true, "patch_ids": ["30370a4ec989b7239d5aef5278fc05ef", "5c6e090c8079ba9092c28d371b17bfd3"], "statement_hash": "094a4815119a5ab935b4ddcf7dfe72424b6cbbb8771db238a91bd2658c868599"}}], "version": "14.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "fedab078255a227307e0fb716d19e1a6", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Fix planner issues when combining Memoize nodes with partitionwise joins or parameterized nestloops", "evidence": {"same_day": true, "patch_ids": ["30370a4ec989b7239d5aef5278fc05ef", "5c6e090c8079ba9092c28d371b17bfd3"], "statement_hash": "094a4815119a5ab935b4ddcf7dfe72424b6cbbb8771db238a91bd2658c868599"}, "url": "/docs/compare/?release=15.2#15.2-37d086b58245cb81", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}]}, {"id": "14.7-e378359afa593f1d", "cves": [], "html": "Fix partitionwise-join code to tolerate failure to produce a plan for each partition (Tom Lane) §
\nThis could result in “could not devise a query plan for the given query” errors.
", "text": "Fix partitionwise-join code to tolerate failure to produce a plan for each partition (Tom Lane) § This could result in “could not devise a query plan for the given query” errors.", "title": "Fix partitionwise-join code to tolerate failure to produce a plan for each partition", "commits": ["ec3daeec3"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "6a23a6566b6d9c265392263432e0d01cb777956c8dc63a130199eda4a4ad646a", "section_path": ["Changes"], "commit_groups": [["1ff549e84", "2df073313", "4ebca555c", "bf8fd64ff", "ec3daeec3", "fe12f2f8f"]], "identity_text": "Fix partitionwise-join code to tolerate failure to produce a plan for each partition (Tom Lane) This could result in could not devise a query plan for the given query errors.", "commit_aliases": ["1ff549e84", "2df073313", "4ebca555c", "bf8fd64ff", "ec3daeec3", "fe12f2f8f"], "source_commits": ["ec3daeec3"], "source_entry_id": "14.7/changes/017", "db_id": "ab574b7f4bc6aa7119791c39e91c1cb7", "patch_ids": ["778506c4256a633d97aea2b3679b38fd"], "statement_hash": "8216c4e7bc70057140e5130801b0779392eedb9ac4b5170e1009a8a85e6962e1", "relations": [{"rule": 2, "type": "equivalent", "target": "6f7131cf4cc9e66ad2f9645e81362450", "evidence": {"same_day": true, "patch_ids": ["778506c4256a633d97aea2b3679b38fd"], "statement_hash": "8216c4e7bc70057140e5130801b0779392eedb9ac4b5170e1009a8a85e6962e1"}}, {"rule": 2, "type": "equivalent", "target": "c2b696431dc7120dd5fcf12f4dceb1d2", "evidence": {"same_day": true, "patch_ids": ["778506c4256a633d97aea2b3679b38fd"], "statement_hash": "8216c4e7bc70057140e5130801b0779392eedb9ac4b5170e1009a8a85e6962e1"}}, {"rule": 2, "type": "equivalent", "target": "dbfc56a5f280f98acfb2ac22d3b85626", "evidence": {"same_day": true, "patch_ids": ["778506c4256a633d97aea2b3679b38fd"], "statement_hash": "8216c4e7bc70057140e5130801b0779392eedb9ac4b5170e1009a8a85e6962e1"}}, {"rule": 2, "type": "equivalent", "target": "ec7d05dbfdacc0d8ea27dd45d04add5a", "evidence": {"same_day": true, "patch_ids": ["778506c4256a633d97aea2b3679b38fd"], "statement_hash": "8216c4e7bc70057140e5130801b0779392eedb9ac4b5170e1009a8a85e6962e1"}}], "version": "14.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "6f7131cf4cc9e66ad2f9645e81362450", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Fix partitionwise-join code to tolerate failure to produce a plan for each partition", "evidence": {"same_day": true, "patch_ids": ["778506c4256a633d97aea2b3679b38fd"], "statement_hash": "8216c4e7bc70057140e5130801b0779392eedb9ac4b5170e1009a8a85e6962e1"}, "url": "/docs/compare/?release=15.2#15.2-bb867c3ad0f78911", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "c2b696431dc7120dd5fcf12f4dceb1d2", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Fix partitionwise-join code to tolerate failure to produce a plan for each partition", "evidence": {"same_day": true, "patch_ids": ["778506c4256a633d97aea2b3679b38fd"], "statement_hash": "8216c4e7bc70057140e5130801b0779392eedb9ac4b5170e1009a8a85e6962e1"}, "url": "/docs/compare/?release=13.10#13.10-cf603be7db67c148", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "ec7d05dbfdacc0d8ea27dd45d04add5a", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Fix partitionwise-join code to tolerate failure to produce a plan for each partition", "evidence": {"same_day": true, "patch_ids": ["778506c4256a633d97aea2b3679b38fd"], "statement_hash": "8216c4e7bc70057140e5130801b0779392eedb9ac4b5170e1009a8a85e6962e1"}, "url": "/docs/compare/?release=12.14#12.14-2a4e55e0fca50b50", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "dbfc56a5f280f98acfb2ac22d3b85626", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "Fix partitionwise-join code to tolerate failure to produce a plan for each partition", "evidence": {"same_day": true, "patch_ids": ["778506c4256a633d97aea2b3679b38fd"], "statement_hash": "8216c4e7bc70057140e5130801b0779392eedb9ac4b5170e1009a8a85e6962e1"}, "url": "/docs/compare/?release=11.19#11.19-ea58e9523a4b5b62", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}, {"id": "14.7-93ec24f4214cdded", "cves": [], "html": "Limit the amount of cleanup work done by get_actual_variable_range (Simon Riggs) §
Planner runs occurring just after deletion of a large number of tuples appearing at the end of an index could expend significant amounts of work setting the “killed” bits for those index entries. Limit the amount of work done in any one query by giving up on this process after examining 100 heap pages. All the cleanup will still happen eventually, but without so large a performance hiccup.
", "text": "Limit the amount of cleanup work done by get_actual_variable_range (Simon Riggs) § Planner runs occurring just after deletion of a large number of tuples appearing at the end of an index could expend significant amounts of work setting the “killed” bits for those index entries. Limit the amount of work done in any one query by giving up on this process after examining 100 heap pages. All the cleanup will still happen eventually, but without so large a performance hiccup.", "title": "Limit the amount of cleanup work done by get_actual_variable_range", "commits": ["bd06fe4de"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "df9ed3f43fc1706a26856bcd67f7f9de4a8d4feb2113e3603a6b8a695b4ec67f", "section_path": ["Changes"], "commit_groups": [["2debceed2", "6e639267a", "9c6ad5eaa", "b96a096db", "bd06fe4de", "ec10b6139"]], "identity_text": "Limit the amount of cleanup work done by get_actual_variable_range (Simon Riggs) Planner runs occurring just after deletion of a large number of tuples appearing at the end of an index could expend significant amounts of work setting the killed bits for those index entries. Limit the amount of work done in any one query by giving up on this process after examining 100 heap pages. All the cleanup will still happen eventually, but without so large a performance hiccup.", "commit_aliases": ["2debceed2", "6e639267a", "9c6ad5eaa", "b96a096db", "bd06fe4de", "ec10b6139"], "source_commits": ["bd06fe4de"], "source_entry_id": "14.7/changes/018", "db_id": "eac86512b06678574c831246bd1c4e1d", "patch_ids": ["f2b427eb4cc159b6f04039f441042743"], "statement_hash": "17ccc82a583063e6823e05dcea86b5110c4e09fc5e94afd1bf4c9b643a32c43c", "relations": [{"rule": 2, "type": "equivalent", "target": "3fa3289ac41ba3dae3f215446f66b446", "evidence": {"same_day": true, "patch_ids": ["f2b427eb4cc159b6f04039f441042743"], "statement_hash": "17ccc82a583063e6823e05dcea86b5110c4e09fc5e94afd1bf4c9b643a32c43c"}}, {"rule": 2, "type": "equivalent", "target": "7d30afa741c434b1e7cfa2c793c8d84e", "evidence": {"same_day": true, "patch_ids": ["f2b427eb4cc159b6f04039f441042743"], "statement_hash": "17ccc82a583063e6823e05dcea86b5110c4e09fc5e94afd1bf4c9b643a32c43c"}}, {"rule": 2, "type": "equivalent", "target": "a32635d021a34f24cf85a7d7dab70099", "evidence": {"same_day": true, "patch_ids": ["f2b427eb4cc159b6f04039f441042743"], "statement_hash": "17ccc82a583063e6823e05dcea86b5110c4e09fc5e94afd1bf4c9b643a32c43c"}}, {"rule": 2, "type": "equivalent", "target": "f8dd51a841516e40babc8e3afce49b0b", "evidence": {"same_day": true, "patch_ids": ["f2b427eb4cc159b6f04039f441042743"], "statement_hash": "17ccc82a583063e6823e05dcea86b5110c4e09fc5e94afd1bf4c9b643a32c43c"}}], "version": "14.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f8dd51a841516e40babc8e3afce49b0b", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Limit the amount of cleanup work done by get_actual_variable_range", "evidence": {"same_day": true, "patch_ids": ["f2b427eb4cc159b6f04039f441042743"], "statement_hash": "17ccc82a583063e6823e05dcea86b5110c4e09fc5e94afd1bf4c9b643a32c43c"}, "url": "/docs/compare/?release=15.2#15.2-11c232831ed252d3", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "3fa3289ac41ba3dae3f215446f66b446", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Limit the amount of cleanup work done by get_actual_variable_range", "evidence": {"same_day": true, "patch_ids": ["f2b427eb4cc159b6f04039f441042743"], "statement_hash": "17ccc82a583063e6823e05dcea86b5110c4e09fc5e94afd1bf4c9b643a32c43c"}, "url": "/docs/compare/?release=13.10#13.10-4eaf68022338e162", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "a32635d021a34f24cf85a7d7dab70099", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Limit the amount of cleanup work done by get_actual_variable_range", "evidence": {"same_day": true, "patch_ids": ["f2b427eb4cc159b6f04039f441042743"], "statement_hash": "17ccc82a583063e6823e05dcea86b5110c4e09fc5e94afd1bf4c9b643a32c43c"}, "url": "/docs/compare/?release=12.14#12.14-ffb0dcdce89b2abb", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "7d30afa741c434b1e7cfa2c793c8d84e", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "Limit the amount of cleanup work done by get_actual_variable_range", "evidence": {"same_day": true, "patch_ids": ["f2b427eb4cc159b6f04039f441042743"], "statement_hash": "17ccc82a583063e6823e05dcea86b5110c4e09fc5e94afd1bf4c9b643a32c43c"}, "url": "/docs/compare/?release=11.19#11.19-2fccd5dc63d91797", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}, {"id": "14.7-56b2472323fb9e5d", "cves": [], "html": "Fix under-parenthesized display of AT TIME ZONE constructs (Tom Lane) §
This could result in dump/restore failures for rules or views in which an argument of AT TIME ZONE is itself an expression.
Prevent clobbering of cached parsetrees for utility statements in SQL functions (Tom Lane, Daniel Gustafsson) §
\nIf a SQL-language function executes the same utility command more than once within a single calling query, it could crash or report strange errors such as “unrecognized node type”.
", "text": "Prevent clobbering of cached parsetrees for utility statements in SQL functions (Tom Lane, Daniel Gustafsson) § If a SQL-language function executes the same utility command more than once within a single calling query, it could crash or report strange errors such as “unrecognized node type”.", "title": "Prevent clobbering of cached parsetrees for utility statements in SQL functions", "commits": ["7715a3c24"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "e50c4de7380e8ccf6142d7269ea9e25a908acf589d1fc609368d228c8d08b623", "section_path": ["Changes"], "commit_groups": [["5dfc2b753", "7715a3c24", "8b47ccb62"]], "identity_text": "Prevent clobbering of cached parsetrees for utility statements in SQL functions (Tom Lane, Daniel Gustafsson) If a SQL-language function executes the same utility command more than once within a single calling query, it could crash or report strange errors such as unrecognized node type.", "commit_aliases": ["5dfc2b753", "7715a3c24", "8b47ccb62"], "source_commits": ["7715a3c24"], "source_entry_id": "14.7/changes/020", "db_id": "5932d72233fb08b740233e17f971dd05", "patch_ids": ["64eba7747a40b5dd917004452b48be41"], "statement_hash": "32611e8c578a67fed1bd4f23b5278f7b0eb0544cfdb1c8d2e8da9f0667bc92ef", "relations": [{"rule": 2, "type": "equivalent", "target": "6d20959eb1a0952e90d2a4749083efa3", "evidence": {"same_day": true, "patch_ids": ["64eba7747a40b5dd917004452b48be41"], "statement_hash": "32611e8c578a67fed1bd4f23b5278f7b0eb0544cfdb1c8d2e8da9f0667bc92ef"}}], "version": "14.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "6d20959eb1a0952e90d2a4749083efa3", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Prevent clobbering of cached parsetrees for utility statements in SQL functions", "evidence": {"same_day": true, "patch_ids": ["64eba7747a40b5dd917004452b48be41"], "statement_hash": "32611e8c578a67fed1bd4f23b5278f7b0eb0544cfdb1c8d2e8da9f0667bc92ef"}, "url": "/docs/compare/?release=15.2#15.2-e717031f4de7b017", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}]}, {"id": "14.7-b491b658c827f4a4", "cves": [], "html": "Ensure that execution of full-text-search queries can be cancelled while they are performing phrase matches (Tom Lane) §
", "text": "Ensure that execution of full-text-search queries can be cancelled while they are performing phrase matches (Tom Lane) §", "title": "Ensure that execution of full-text-search queries can be cancelled while they are performing phrase matches", "commits": ["1b9c04b13"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "bc5e0d29bbdcfe95051d2e83fa49bd6e88ec30823cc0154759ad3b5204d49ec2", "section_path": ["Changes"], "commit_groups": [["0353db996", "1aed4c4fd", "1b9c04b13", "5644d6f90", "74670688f", "c0eed8891"]], "identity_text": "Ensure that execution of full-text-search queries can be cancelled while they are performing phrase matches (Tom Lane)", "commit_aliases": ["0353db996", "1aed4c4fd", "1b9c04b13", "5644d6f90", "74670688f", "c0eed8891"], "source_commits": ["1b9c04b13"], "source_entry_id": "14.7/changes/021", "db_id": "78881f78a9428d46f9ba9a5886ed1e7f", "patch_ids": ["1a5edb79e8f4a758da21291728407b22"], "statement_hash": "c63c3bbac940f97fe499b5d2686636e41b0fe7f5add1d04c3b3fb9937b7f2911", "relations": [{"rule": 2, "type": "equivalent", "target": "6cc8179b75e5297003cc9046fd58b9ed", "evidence": {"same_day": true, "patch_ids": ["1a5edb79e8f4a758da21291728407b22"], "statement_hash": "c63c3bbac940f97fe499b5d2686636e41b0fe7f5add1d04c3b3fb9937b7f2911"}}, {"rule": 2, "type": "equivalent", "target": "74ee2d0de6ba6e2966d178a756911b7c", "evidence": {"same_day": true, "patch_ids": ["1a5edb79e8f4a758da21291728407b22"], "statement_hash": "c63c3bbac940f97fe499b5d2686636e41b0fe7f5add1d04c3b3fb9937b7f2911"}}, {"rule": 2, "type": "equivalent", "target": "b62f364b81e08ed5b7e390440fa47def", "evidence": {"same_day": true, "patch_ids": ["1a5edb79e8f4a758da21291728407b22"], "statement_hash": "c63c3bbac940f97fe499b5d2686636e41b0fe7f5add1d04c3b3fb9937b7f2911"}}, {"rule": 2, "type": "equivalent", "target": "d27a03f53291be3243997a24d6164d8f", "evidence": {"same_day": true, "patch_ids": ["1a5edb79e8f4a758da21291728407b22"], "statement_hash": "c63c3bbac940f97fe499b5d2686636e41b0fe7f5add1d04c3b3fb9937b7f2911"}}], "version": "14.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "d27a03f53291be3243997a24d6164d8f", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Ensure that execution of full-text-search queries can be cancelled while they are performing phrase matches", "evidence": {"same_day": true, "patch_ids": ["1a5edb79e8f4a758da21291728407b22"], "statement_hash": "c63c3bbac940f97fe499b5d2686636e41b0fe7f5add1d04c3b3fb9937b7f2911"}, "url": "/docs/compare/?release=15.2#15.2-e40640d70917b578", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "74ee2d0de6ba6e2966d178a756911b7c", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Ensure that execution of full-text-search queries can be cancelled while they are performing phrase matches", "evidence": {"same_day": true, "patch_ids": ["1a5edb79e8f4a758da21291728407b22"], "statement_hash": "c63c3bbac940f97fe499b5d2686636e41b0fe7f5add1d04c3b3fb9937b7f2911"}, "url": "/docs/compare/?release=13.10#13.10-1b8a10f16c43fb85", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "6cc8179b75e5297003cc9046fd58b9ed", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Ensure that execution of full-text-search queries can be cancelled while they are performing phrase matches", "evidence": {"same_day": true, "patch_ids": ["1a5edb79e8f4a758da21291728407b22"], "statement_hash": "c63c3bbac940f97fe499b5d2686636e41b0fe7f5add1d04c3b3fb9937b7f2911"}, "url": "/docs/compare/?release=12.14#12.14-cfb9990dc4aedde5", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "b62f364b81e08ed5b7e390440fa47def", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "Ensure that execution of full-text-search queries can be cancelled while they are performing phrase matches", "evidence": {"same_day": true, "patch_ids": ["1a5edb79e8f4a758da21291728407b22"], "statement_hash": "c63c3bbac940f97fe499b5d2686636e41b0fe7f5add1d04c3b3fb9937b7f2911"}, "url": "/docs/compare/?release=11.19#11.19-42be9cc756f31c49", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}, {"id": "14.7-f55d60a5c2b738ea", "cves": [], "html": "Fix memory leak in hashing strings with nondeterministic collations (Jeff Davis) §
", "text": "Fix memory leak in hashing strings with nondeterministic collations (Jeff Davis) §", "title": "Fix memory leak in hashing strings with nondeterministic collations", "commits": ["47e1224d5"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "d29844507406c9260acde7b621a04caedffab2d591412dd5d4bc61614c25626f", "section_path": ["Changes"], "commit_groups": [["47e1224d5", "9377b4f30", "a844052b5", "edf12e7bb", "f98c4fb1d"]], "identity_text": "Fix memory leak in hashing strings with nondeterministic collations (Jeff Davis)", "commit_aliases": ["47e1224d5", "9377b4f30", "a844052b5", "edf12e7bb", "f98c4fb1d"], "source_commits": ["47e1224d5"], "source_entry_id": "14.7/changes/022", "db_id": "0d55210ee4a7fa82ce3c1e004d22f631", "patch_ids": ["3f4ec5f23f6762bfb8f8a9541c39811d"], "statement_hash": "ecb659f7305e138eabbba1ebaac680f7bd7f0b317fa000ae0f0d44ddc294f236", "relations": [{"rule": 2, "type": "equivalent", "target": "143f0cdc057f5d55143b6fd4226c08fa", "evidence": {"same_day": true, "patch_ids": ["3f4ec5f23f6762bfb8f8a9541c39811d"], "statement_hash": "ecb659f7305e138eabbba1ebaac680f7bd7f0b317fa000ae0f0d44ddc294f236"}}, {"rule": 2, "type": "equivalent", "target": "2816c467f6dfc309bdc20da3bcb224d2", "evidence": {"same_day": true, "patch_ids": ["3f4ec5f23f6762bfb8f8a9541c39811d"], "statement_hash": "ecb659f7305e138eabbba1ebaac680f7bd7f0b317fa000ae0f0d44ddc294f236"}}, {"rule": 2, "type": "equivalent", "target": "9094d14461dc2e6dc506aea25465f637", "evidence": {"same_day": true, "patch_ids": ["3f4ec5f23f6762bfb8f8a9541c39811d"], "statement_hash": "ecb659f7305e138eabbba1ebaac680f7bd7f0b317fa000ae0f0d44ddc294f236"}}], "version": "14.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "9094d14461dc2e6dc506aea25465f637", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Fix memory leak in hashing strings with nondeterministic collations", "evidence": {"same_day": true, "patch_ids": ["3f4ec5f23f6762bfb8f8a9541c39811d"], "statement_hash": "ecb659f7305e138eabbba1ebaac680f7bd7f0b317fa000ae0f0d44ddc294f236"}, "url": "/docs/compare/?release=15.2#15.2-525f43a7a7d4e8fc", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "143f0cdc057f5d55143b6fd4226c08fa", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Fix memory leak in hashing strings with nondeterministic collations", "evidence": {"same_day": true, "patch_ids": ["3f4ec5f23f6762bfb8f8a9541c39811d"], "statement_hash": "ecb659f7305e138eabbba1ebaac680f7bd7f0b317fa000ae0f0d44ddc294f236"}, "url": "/docs/compare/?release=13.10#13.10-2717bdcca432d322", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "2816c467f6dfc309bdc20da3bcb224d2", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Fix memory leak in hashing strings with nondeterministic collations", "evidence": {"same_day": true, "patch_ids": ["3f4ec5f23f6762bfb8f8a9541c39811d"], "statement_hash": "ecb659f7305e138eabbba1ebaac680f7bd7f0b317fa000ae0f0d44ddc294f236"}, "url": "/docs/compare/?release=12.14#12.14-c40cfd49255afd45", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}]}, {"id": "14.7-ac07afbe25e1ac22", "cves": [], "html": "Fix deadlock between DROP DATABASE and logical replication worker process (Hou Zhijie) §
This was caused by an ill-advised choice to block interrupts while creating a logical replication slot in the worker. In version 15 that could lead to an undetected deadlock. In version 14, no deadlock has been observed, but it's still a bad idea to block interrupts while waiting for network I/O.
", "text": "Fix deadlock between DROP DATABASE and logical replication worker process (Hou Zhijie) § This was caused by an ill-advised choice to block interrupts while creating a logical replication slot in the worker. In version 15 that could lead to an undetected deadlock. In version 14, no deadlock has been observed, but it's still a bad idea to block interrupts while waiting for network I/O.", "title": "Fix deadlock between DROP DATABASE and logical replication worker process", "commits": ["fd270b728"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "7eb089c311654007461e8e2344cb2c394a3aef2205171a681953742396526bd2", "section_path": ["Changes"], "commit_groups": [["267135d01", "6c6d6ba3e", "fd270b728"]], "identity_text": "Fix deadlock between DROP DATABASE and logical replication worker process (Hou Zhijie) This was caused by an ill-advised choice to block interrupts while creating a logical replication slot in the worker. In version 15 that could lead to an undetected deadlock. In version 14, no deadlock has been observed, but it's still a bad idea to block interrupts while waiting for network I/O.", "commit_aliases": ["267135d01", "6c6d6ba3e", "fd270b728"], "source_commits": ["fd270b728"], "source_entry_id": "14.7/changes/023", "db_id": "c6dabc7bbb112e986d361df0ff0df408", "patch_ids": ["ebe1fc892db886300595c5916639e21e"], "statement_hash": "432aade79e957ae6c85f21995ce5319d4512cf90f215bf63e59a8bfbb710b84b", "relations": [{"rule": 2, "type": "equivalent", "target": "8a71f22da551c69f813c530c0d5c68a3", "evidence": {"same_day": true, "patch_ids": ["ebe1fc892db886300595c5916639e21e"], "statement_hash": "432aade79e957ae6c85f21995ce5319d4512cf90f215bf63e59a8bfbb710b84b"}}], "version": "14.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "8a71f22da551c69f813c530c0d5c68a3", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Fix deadlock between DROP DATABASE and logical replication worker process", "evidence": {"same_day": true, "patch_ids": ["ebe1fc892db886300595c5916639e21e"], "statement_hash": "432aade79e957ae6c85f21995ce5319d4512cf90f215bf63e59a8bfbb710b84b"}, "url": "/docs/compare/?release=15.2#15.2-4e3438199ed34589", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}]}, {"id": "14.7-d9c0f4cbb41b12d4", "cves": [], "html": "Clean up the libpq connection object after a failed replication connection attempt (Andres Freund) §
\nThe previous coding leaked the connection object. In background code paths that's pretty harmless because the calling process will give up and exit. But in commands such as CREATE SUBSCRIPTION, such a failure resulted in a small session-lifespan memory leak.
In hot-standby servers, reduce processing effort for tracking XIDs known to be active on the primary (Simon Riggs, Michail Nikolaev) §
\nInsufficiently-aggressive cleanup of the KnownAssignedXids array could lead to poor performance, particularly when max_connections is set to a large value on the standby.
Ignore invalidated logical-replication slots while determining oldest catalog xmin (Sirisha Chamarthi) §
\nA replication slot could prevent cleanup of dead tuples in the system catalogs even after it becomes invalidated due to exceeding max_slot_wal_keep_size. Thus, failure of a replication consumer could lead to indefinitely-large catalog bloat.
In logical decoding, notify the remote node when a transaction is detected to have crashed (Hou Zhijie) §
\nAfter a server restart, we'll re-stream the changes for transactions occurring shortly before the restart. Some of these transactions probably never completed; when we realize that one didn't we throw away the relevant decoding state locally, but we neglected to tell the subscriber about it. That led to the subscriber keeping useless streaming files until it's next restarted.
", "text": "In logical decoding, notify the remote node when a transaction is detected to have crashed (Hou Zhijie) § After a server restart, we'll re-stream the changes for transactions occurring shortly before the restart. Some of these transactions probably never completed; when we realize that one didn't we throw away the relevant decoding state locally, but we neglected to tell the subscriber about it. That led to the subscriber keeping useless streaming files until it's next restarted.", "title": "In logical decoding, notify the remote node when a transaction is detected to have crashed", "commits": ["b2cc5b810"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "f2b9997de6572f29959c23f1a3238314f62218dba71003b546a833785e768339", "section_path": ["Changes"], "commit_groups": [["18b81258a", "2b6df0546", "b2cc5b810"]], "identity_text": "In logical decoding, notify the remote node when a transaction is detected to have crashed (Hou Zhijie) After a server restart, we'll re-stream the changes for transactions occurring shortly before the restart. Some of these transactions probably never completed; when we realize that one didn't we throw away the relevant decoding state locally, but we neglected to tell the subscriber about it. That led to the subscriber keeping useless streaming files until it's next restarted.", "commit_aliases": ["18b81258a", "2b6df0546", "b2cc5b810"], "source_commits": ["b2cc5b810"], "source_entry_id": "14.7/changes/027", "db_id": "f732d611cd29941389c127553a73e2e4", "patch_ids": ["90f4763aa9b13208c51e548ce1cfb8f0"], "statement_hash": "d439ee88239826abed8cb4da12dcc964c53dfb375200c63b146308ba3f9b1d95", "relations": [{"rule": 2, "type": "equivalent", "target": "ee0222047d6b2abfe12f9cf43b75a1f8", "evidence": {"same_day": true, "patch_ids": ["90f4763aa9b13208c51e548ce1cfb8f0"], "statement_hash": "d439ee88239826abed8cb4da12dcc964c53dfb375200c63b146308ba3f9b1d95"}}], "version": "14.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "ee0222047d6b2abfe12f9cf43b75a1f8", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "In logical decoding, notify the remote node when a transaction is detected to have crashed", "evidence": {"same_day": true, "patch_ids": ["90f4763aa9b13208c51e548ce1cfb8f0"], "statement_hash": "d439ee88239826abed8cb4da12dcc964c53dfb375200c63b146308ba3f9b1d95"}, "url": "/docs/compare/?release=15.2#15.2-b0666858aaaef7cf", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}]}, {"id": "14.7-be106755a9eb8436", "cves": [], "html": "Fix uninitialized-memory usage in logical decoding (Masahiko Sawada) §
\nIn certain cases, resumption of logical decoding could try to re-use XID data that had already been freed, leading to unpredictable behavior.
", "text": "Fix uninitialized-memory usage in logical decoding (Masahiko Sawada) § In certain cases, resumption of logical decoding could try to re-use XID data that had already been freed, leading to unpredictable behavior.", "title": "Fix uninitialized-memory usage in logical decoding", "commits": ["9f2cc1a73"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "443eed76f4e1dcd245cf901d8a8db84c5d8202924162085dd728fdfc826db58a", "section_path": ["Changes"], "commit_groups": [["4ec157c15", "898ef41bf", "9b788aafd", "9f2cc1a73", "aa9d916f6"]], "identity_text": "Fix uninitialized-memory usage in logical decoding (Masahiko Sawada) In certain cases, resumption of logical decoding could try to re-use XID data that had already been freed, leading to unpredictable behavior.", "commit_aliases": ["4ec157c15", "898ef41bf", "9b788aafd", "9f2cc1a73", "aa9d916f6"], "source_commits": ["9f2cc1a73"], "source_entry_id": "14.7/changes/028", "db_id": "b08faea01215327f884c599883bd13d7", "patch_ids": ["54ae1dac7cc0c91279a50506dad9db29"], "statement_hash": "61b7e58053ccddb68e539c63541bd6b8102b98c9b55ce16574ca08224f578de7", "relations": [{"rule": 2, "type": "equivalent", "target": "2b970d6265b4bfd24a98f3b14beb6751", "evidence": {"same_day": true, "patch_ids": ["54ae1dac7cc0c91279a50506dad9db29"], "statement_hash": "61b7e58053ccddb68e539c63541bd6b8102b98c9b55ce16574ca08224f578de7"}}, {"rule": 2, "type": "equivalent", "target": "510672bfa376ef4c5b9b3aed67b94c80", "evidence": {"same_day": true, "patch_ids": ["54ae1dac7cc0c91279a50506dad9db29"], "statement_hash": "61b7e58053ccddb68e539c63541bd6b8102b98c9b55ce16574ca08224f578de7"}}, {"rule": 2, "type": "equivalent", "target": "66f773d42e99a014ae0c561bfc9cb9da", "evidence": {"same_day": true, "patch_ids": ["54ae1dac7cc0c91279a50506dad9db29"], "statement_hash": "61b7e58053ccddb68e539c63541bd6b8102b98c9b55ce16574ca08224f578de7"}}, {"rule": 2, "type": "equivalent", "target": "e9cf78d160177f53cbb57d9190944115", "evidence": {"same_day": true, "patch_ids": ["54ae1dac7cc0c91279a50506dad9db29"], "statement_hash": "61b7e58053ccddb68e539c63541bd6b8102b98c9b55ce16574ca08224f578de7"}}], "version": "14.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2b970d6265b4bfd24a98f3b14beb6751", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Fix uninitialized-memory usage in logical decoding", "evidence": {"same_day": true, "patch_ids": ["54ae1dac7cc0c91279a50506dad9db29"], "statement_hash": "61b7e58053ccddb68e539c63541bd6b8102b98c9b55ce16574ca08224f578de7"}, "url": "/docs/compare/?release=15.2#15.2-1bb0cfb2b80f606f", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "e9cf78d160177f53cbb57d9190944115", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Fix uninitialized-memory usage in logical decoding", "evidence": {"same_day": true, "patch_ids": ["54ae1dac7cc0c91279a50506dad9db29"], "statement_hash": "61b7e58053ccddb68e539c63541bd6b8102b98c9b55ce16574ca08224f578de7"}, "url": "/docs/compare/?release=13.10#13.10-4d8aa1ee7e4d9d41", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "510672bfa376ef4c5b9b3aed67b94c80", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Fix uninitialized-memory usage in logical decoding", "evidence": {"same_day": true, "patch_ids": ["54ae1dac7cc0c91279a50506dad9db29"], "statement_hash": "61b7e58053ccddb68e539c63541bd6b8102b98c9b55ce16574ca08224f578de7"}, "url": "/docs/compare/?release=12.14#12.14-0722376b3bc139ab", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "66f773d42e99a014ae0c561bfc9cb9da", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "Fix uninitialized-memory usage in logical decoding", "evidence": {"same_day": true, "patch_ids": ["54ae1dac7cc0c91279a50506dad9db29"], "statement_hash": "61b7e58053ccddb68e539c63541bd6b8102b98c9b55ce16574ca08224f578de7"}, "url": "/docs/compare/?release=11.19#11.19-d4641c137d565f7a", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}, {"id": "14.7-220682dca55317ae", "cves": [], "html": "Avoid rare “failed to acquire cleanup lock” panic during WAL replay of hash-index page split operations (Robert Haas) §
", "text": "Avoid rare “failed to acquire cleanup lock” panic during WAL replay of hash-index page split operations (Robert Haas) §", "title": "Avoid rare “failed to acquire cleanup lock” panic during WAL replay of hash-index page split operations", "commits": ["9693f1900"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "23069286e87da1857c642547a4f19e58cce37524d4ab6461a9cd74069acf6ce7", "section_path": ["Changes"], "commit_groups": [["1703033f8", "20c223336", "4dccccb37", "9693f1900", "e49e19181", "e848be60b"]], "identity_text": "Avoid rare failed to acquire cleanup lock panic during WAL replay of hash-index page split operations (Robert Haas)", "commit_aliases": ["1703033f8", "20c223336", "4dccccb37", "9693f1900", "e49e19181", "e848be60b"], "source_commits": ["9693f1900"], "source_entry_id": "14.7/changes/029", "db_id": "d44c8ce2360017200c118db7150b0959", "patch_ids": ["29854d45521ee2080e21ddcc93e498ff"], "statement_hash": "32cef32f2614309c1259caad8eeca4837594d3a359325052fb6751bf4729f6ab", "relations": [{"rule": 2, "type": "equivalent", "target": "0849b78754a69b45ba04b17b85d6ee62", "evidence": {"same_day": true, "patch_ids": ["29854d45521ee2080e21ddcc93e498ff"], "statement_hash": "32cef32f2614309c1259caad8eeca4837594d3a359325052fb6751bf4729f6ab"}}, {"rule": 2, "type": "equivalent", "target": "baca2b84f8363b6df4670bfa40bb37ea", "evidence": {"same_day": true, "patch_ids": ["29854d45521ee2080e21ddcc93e498ff"], "statement_hash": "32cef32f2614309c1259caad8eeca4837594d3a359325052fb6751bf4729f6ab"}}, {"rule": 2, "type": "equivalent", "target": "c4d5adea80e4ded277aca57d1a3a5a3f", "evidence": {"same_day": true, "patch_ids": ["29854d45521ee2080e21ddcc93e498ff"], "statement_hash": "32cef32f2614309c1259caad8eeca4837594d3a359325052fb6751bf4729f6ab"}}, {"rule": 2, "type": "equivalent", "target": "c5f664cc870917ed52ae681b793e1211", "evidence": {"same_day": true, "patch_ids": ["29854d45521ee2080e21ddcc93e498ff"], "statement_hash": "32cef32f2614309c1259caad8eeca4837594d3a359325052fb6751bf4729f6ab"}}], "version": "14.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "c5f664cc870917ed52ae681b793e1211", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Avoid rare “failed to acquire cleanup lock” panic during WAL replay of hash-index page split operations", "evidence": {"same_day": true, "patch_ids": ["29854d45521ee2080e21ddcc93e498ff"], "statement_hash": "32cef32f2614309c1259caad8eeca4837594d3a359325052fb6751bf4729f6ab"}, "url": "/docs/compare/?release=15.2#15.2-b73926495d107415", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "0849b78754a69b45ba04b17b85d6ee62", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Avoid rare “failed to acquire cleanup lock” panic during WAL replay of hash-index page split operations", "evidence": {"same_day": true, "patch_ids": ["29854d45521ee2080e21ddcc93e498ff"], "statement_hash": "32cef32f2614309c1259caad8eeca4837594d3a359325052fb6751bf4729f6ab"}, "url": "/docs/compare/?release=13.10#13.10-e14f0979a8451541", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "baca2b84f8363b6df4670bfa40bb37ea", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Avoid rare “failed to acquire cleanup lock” panic during WAL replay of hash-index page split operations", "evidence": {"same_day": true, "patch_ids": ["29854d45521ee2080e21ddcc93e498ff"], "statement_hash": "32cef32f2614309c1259caad8eeca4837594d3a359325052fb6751bf4729f6ab"}, "url": "/docs/compare/?release=12.14#12.14-068b9d90c2705bf2", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "c4d5adea80e4ded277aca57d1a3a5a3f", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "Avoid rare “failed to acquire cleanup lock” panic during WAL replay of hash-index page split operations", "evidence": {"same_day": true, "patch_ids": ["29854d45521ee2080e21ddcc93e498ff"], "statement_hash": "32cef32f2614309c1259caad8eeca4837594d3a359325052fb6751bf4729f6ab"}, "url": "/docs/compare/?release=11.19#11.19-2d1da09841968349", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}, {"id": "14.7-718290997b4c9316", "cves": [], "html": "Advance a heap page's LSN when setting its all-visible bit during WAL replay (Jeff Davis) §
\nFailure to do this left the page possibly different on standby servers than the primary, and violated some other expectations about when the LSN changes. This seems only a theoretical hazard so far as PostgreSQL itself is concerned, but it could upset third-party tools.
", "text": "Advance a heap page's LSN when setting its all-visible bit during WAL replay (Jeff Davis) § Failure to do this left the page possibly different on standby servers than the primary, and violated some other expectations about when the LSN changes. This seems only a theoretical hazard so far as PostgreSQL itself is concerned, but it could upset third-party tools.", "title": "Advance a heap page's LSN when setting its all-visible bit during WAL replay", "commits": ["f893af496"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "f823e553121e964fa09e280b6ff08187880577ba5d607eca915a2ec23a9bc89f", "section_path": ["Changes"], "commit_groups": [["58a45bb1d", "5eaf3e375", "7bf713dd2", "7dd39e9e8", "d6a3dbe14", "f893af496"]], "identity_text": "Advance a heap page's LSN when setting its all-visible bit during WAL replay (Jeff Davis) Failure to do this left the page possibly different on standby servers than the primary, and violated some other expectations about when the LSN changes. This seems only a theoretical hazard so far as PostgreSQL itself is concerned, but it could upset third-party tools.", "commit_aliases": ["58a45bb1d", "5eaf3e375", "7bf713dd2", "7dd39e9e8", "d6a3dbe14", "f893af496"], "source_commits": ["f893af496"], "source_entry_id": "14.7/changes/030", "db_id": "0a52af951983fba9bfed60788718abce", "patch_ids": ["f87c1cf9570073e580dbf6ed653b9355"], "statement_hash": "b7a250eff9f5d0b0df14c972ca79c74303b915933c3a21c300fb558c6bfbe03c", "relations": [{"rule": 2, "type": "equivalent", "target": "a849f5b97bde2347692ac39d9bb22fac", "evidence": {"same_day": true, "patch_ids": ["f87c1cf9570073e580dbf6ed653b9355"], "statement_hash": "b7a250eff9f5d0b0df14c972ca79c74303b915933c3a21c300fb558c6bfbe03c"}}, {"rule": 2, "type": "equivalent", "target": "d075e92a3d8b3a092881d4f990bd0d56", "evidence": {"same_day": true, "patch_ids": ["f87c1cf9570073e580dbf6ed653b9355"], "statement_hash": "b7a250eff9f5d0b0df14c972ca79c74303b915933c3a21c300fb558c6bfbe03c"}}, {"rule": 2, "type": "equivalent", "target": "d08b648a27abdbdb17fdafeb4c59538c", "evidence": {"same_day": true, "patch_ids": ["f87c1cf9570073e580dbf6ed653b9355"], "statement_hash": "b7a250eff9f5d0b0df14c972ca79c74303b915933c3a21c300fb558c6bfbe03c"}}, {"rule": 2, "type": "equivalent", "target": "f392d1567ccd1073c218f3b576032ce6", "evidence": {"same_day": true, "patch_ids": ["f87c1cf9570073e580dbf6ed653b9355"], "statement_hash": "b7a250eff9f5d0b0df14c972ca79c74303b915933c3a21c300fb558c6bfbe03c"}}], "version": "14.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f392d1567ccd1073c218f3b576032ce6", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Advance a heap page's LSN when setting its all-visible bit during WAL replay", "evidence": {"same_day": true, "patch_ids": ["f87c1cf9570073e580dbf6ed653b9355"], "statement_hash": "b7a250eff9f5d0b0df14c972ca79c74303b915933c3a21c300fb558c6bfbe03c"}, "url": "/docs/compare/?release=15.2#15.2-1b81bbf9b853920b", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "d08b648a27abdbdb17fdafeb4c59538c", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Advance a heap page's LSN when setting its all-visible bit during WAL replay", "evidence": {"same_day": true, "patch_ids": ["f87c1cf9570073e580dbf6ed653b9355"], "statement_hash": "b7a250eff9f5d0b0df14c972ca79c74303b915933c3a21c300fb558c6bfbe03c"}, "url": "/docs/compare/?release=13.10#13.10-765605010314565b", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "a849f5b97bde2347692ac39d9bb22fac", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Advance a heap page's LSN when setting its all-visible bit during WAL replay", "evidence": {"same_day": true, "patch_ids": ["f87c1cf9570073e580dbf6ed653b9355"], "statement_hash": "b7a250eff9f5d0b0df14c972ca79c74303b915933c3a21c300fb558c6bfbe03c"}, "url": "/docs/compare/?release=12.14#12.14-f8e2a39d2dce41bf", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "d075e92a3d8b3a092881d4f990bd0d56", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "Advance a heap page's LSN when setting its all-visible bit during WAL replay", "evidence": {"same_day": true, "patch_ids": ["f87c1cf9570073e580dbf6ed653b9355"], "statement_hash": "b7a250eff9f5d0b0df14c972ca79c74303b915933c3a21c300fb558c6bfbe03c"}, "url": "/docs/compare/?release=11.19#11.19-9647dd729ac675d6", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}, {"id": "14.7-9282c452a5462db8", "cves": [], "html": "Prevent unsafe usage of a relation cache entry's rd_smgr pointer (Amul Sul) §
Remove various assumptions that rd_smgr would stay valid over a series of operations, by wrapping all uses of it in a function that will recompute it if needed. This prevents bugs occurring when an unexpected cache flush occurs partway through such a series.
Fix int64_div_fast_to_numeric() to work for a wider range of inputs (Dean Rasheed) §
This function misbehaved with some values of its second argument. No such usages exist in core PostgreSQL, but it's clearly a hazard for external modules, so repair.
", "text": "Fix int64_div_fast_to_numeric() to work for a wider range of inputs (Dean Rasheed) § This function misbehaved with some values of its second argument. No such usages exist in core PostgreSQL, but it's clearly a hazard for external modules, so repair.", "title": "Fix int64_div_fast_to_numeric() to work for a wider range of inputs", "commits": ["86bfbeab4"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "1307b6b270b61ede8c8c591a39f91a70557e43f11f18075280d7853dca2cbf97", "section_path": ["Changes"], "commit_groups": [["4f74741a5", "86bfbeab4", "b2d479289"]], "identity_text": "Fix int64_div_fast_to_numeric() to work for a wider range of inputs (Dean Rasheed) This function misbehaved with some values of its second argument. No such usages exist in core PostgreSQL, but it's clearly a hazard for external modules, so repair.", "commit_aliases": ["4f74741a5", "86bfbeab4", "b2d479289"], "source_commits": ["86bfbeab4"], "source_entry_id": "14.7/changes/032", "db_id": "5e687e0a73382f6feca9a6ca47c6cd56", "patch_ids": ["1f6230921ece7850a37ec13872964f0e"], "statement_hash": "cb40a8c9ed9a1e80751f3eb83ca9ab7e58484a4223695784f130a61f45b1619b", "relations": [{"rule": 2, "type": "equivalent", "target": "7b9ee36407ad208b970aeadd4520f3ba", "evidence": {"same_day": true, "patch_ids": ["1f6230921ece7850a37ec13872964f0e"], "statement_hash": "cb40a8c9ed9a1e80751f3eb83ca9ab7e58484a4223695784f130a61f45b1619b"}}], "version": "14.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "7b9ee36407ad208b970aeadd4520f3ba", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Fix int64_div_fast_to_numeric() to work for a wider range of inputs", "evidence": {"same_day": true, "patch_ids": ["1f6230921ece7850a37ec13872964f0e"], "statement_hash": "cb40a8c9ed9a1e80751f3eb83ca9ab7e58484a4223695784f130a61f45b1619b"}, "url": "/docs/compare/?release=15.2#15.2-6dc5a4242f65ad0d", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}]}, {"id": "14.7-3b22e23382251f0b", "cves": [], "html": "Fix latent buffer-overrun problem in WaitEventSet logic (Thomas Munro) §
The epoll-based and kqueue-based implementations could ask the kernel for too many events if the size of their internal buffer was different from the size of the caller's output buffer. That case is not known to occur in released PostgreSQL versions, but this error is a hazard for external modules and future bug fixes.
Avoid nominally-undefined behavior when accessing shared memory in 32-bit builds (Andres Freund) §
\nclang's undefined-behavior sanitizer complained about use of a pointer that was less aligned than it should be. It's very unlikely that this would cause a problem in non-debug builds, but it's worth fixing for testing purposes.
", "text": "Avoid nominally-undefined behavior when accessing shared memory in 32-bit builds (Andres Freund) § clang's undefined-behavior sanitizer complained about use of a pointer that was less aligned than it should be. It's very unlikely that this would cause a problem in non-debug builds, but it's worth fixing for testing purposes.", "title": "Avoid nominally-undefined behavior when accessing shared memory in 32-bit builds", "commits": ["fc4154286"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "bc089de1fa243622de55a00befcb42a160f614ab81e0458f7651503a39a43285", "section_path": ["Changes"], "commit_groups": [["140c80372", "4cbcb7ed8", "8c954168c", "a0d35ebcc", "c13667b51", "fc4154286"]], "identity_text": "Avoid nominally-undefined behavior when accessing shared memory in 32-bit builds (Andres Freund) clang's undefined-behavior sanitizer complained about use of a pointer that was less aligned than it should be. It's very unlikely that this would cause a problem in non-debug builds, but it's worth fixing for testing purposes.", "commit_aliases": ["140c80372", "4cbcb7ed8", "8c954168c", "a0d35ebcc", "c13667b51", "fc4154286"], "source_commits": ["fc4154286"], "source_entry_id": "14.7/changes/034", "db_id": "43edb0cdb5fccf8270172256c2daedc3", "patch_ids": ["976a856dfb8144e65dc98e67319fa5e3"], "statement_hash": "e3efaba28490e51c8142b16232c30beaf7c61be065def1fdad6cfa554f21d483", "relations": [{"rule": 2, "type": "equivalent", "target": "016d79a9082f87912ace0132d1514cfb", "evidence": {"same_day": true, "patch_ids": ["976a856dfb8144e65dc98e67319fa5e3"], "statement_hash": "e3efaba28490e51c8142b16232c30beaf7c61be065def1fdad6cfa554f21d483"}}, {"rule": 2, "type": "equivalent", "target": "11c8fcd87fed2a9ea124fabc664def11", "evidence": {"same_day": true, "patch_ids": ["976a856dfb8144e65dc98e67319fa5e3"], "statement_hash": "e3efaba28490e51c8142b16232c30beaf7c61be065def1fdad6cfa554f21d483"}}, {"rule": 2, "type": "equivalent", "target": "959ef94c8c4ee4b5ae39ab6f43ba45b2", "evidence": {"same_day": true, "patch_ids": ["976a856dfb8144e65dc98e67319fa5e3"], "statement_hash": "e3efaba28490e51c8142b16232c30beaf7c61be065def1fdad6cfa554f21d483"}}, {"rule": 2, "type": "equivalent", "target": "9dd11604969448b896939bd025ea95ac", "evidence": {"same_day": true, "patch_ids": ["976a856dfb8144e65dc98e67319fa5e3"], "statement_hash": "e3efaba28490e51c8142b16232c30beaf7c61be065def1fdad6cfa554f21d483"}}], "version": "14.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "9dd11604969448b896939bd025ea95ac", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Avoid nominally-undefined behavior when accessing shared memory in 32-bit builds", "evidence": {"same_day": true, "patch_ids": ["976a856dfb8144e65dc98e67319fa5e3"], "statement_hash": "e3efaba28490e51c8142b16232c30beaf7c61be065def1fdad6cfa554f21d483"}, "url": "/docs/compare/?release=15.2#15.2-881f4c0b620ee19d", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "016d79a9082f87912ace0132d1514cfb", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Avoid nominally-undefined behavior when accessing shared memory in 32-bit builds", "evidence": {"same_day": true, "patch_ids": ["976a856dfb8144e65dc98e67319fa5e3"], "statement_hash": "e3efaba28490e51c8142b16232c30beaf7c61be065def1fdad6cfa554f21d483"}, "url": "/docs/compare/?release=13.10#13.10-11f5d479a631ba6d", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "959ef94c8c4ee4b5ae39ab6f43ba45b2", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Avoid nominally-undefined behavior when accessing shared memory in 32-bit builds", "evidence": {"same_day": true, "patch_ids": ["976a856dfb8144e65dc98e67319fa5e3"], "statement_hash": "e3efaba28490e51c8142b16232c30beaf7c61be065def1fdad6cfa554f21d483"}, "url": "/docs/compare/?release=12.14#12.14-cdc2f9259cdff3a9", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "11c8fcd87fed2a9ea124fabc664def11", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "Avoid nominally-undefined behavior when accessing shared memory in 32-bit builds", "evidence": {"same_day": true, "patch_ids": ["976a856dfb8144e65dc98e67319fa5e3"], "statement_hash": "e3efaba28490e51c8142b16232c30beaf7c61be065def1fdad6cfa554f21d483"}, "url": "/docs/compare/?release=11.19#11.19-3e82fab13db9bf52", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}, {"id": "14.7-aa145629e55e7ffd", "cves": [], "html": "Fix assertion failure in BRIN minmax-multi opclasses (Tomas Vondra) §
\nThe assertion was overly strict, so this mistake was harmless in non-assert builds.
", "text": "Fix assertion failure in BRIN minmax-multi opclasses (Tomas Vondra) § The assertion was overly strict, so this mistake was harmless in non-assert builds.", "title": "Fix assertion failure in BRIN minmax-multi opclasses", "commits": ["883dc0214"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "df323a28333dac87cede084544ef7666b624b0213c10d6250b06808dd954ede8", "section_path": ["Changes"], "commit_groups": [["02699bc1f", "883dc0214", "c4f64cfab"]], "identity_text": "Fix assertion failure in BRIN minmax-multi opclasses (Tomas Vondra) The assertion was overly strict, so this mistake was harmless in non-assert builds.", "commit_aliases": ["02699bc1f", "883dc0214", "c4f64cfab"], "source_commits": ["883dc0214"], "source_entry_id": "14.7/changes/035", "db_id": "ff4dcd89ded477032c44549fa8794445", "patch_ids": ["609cd06a11714310dc3229712096f406"], "statement_hash": "fa82363c7134e5eb734924371926008cb70a2caa6cbaf956cbf5e18732a83ace", "relations": [{"rule": 2, "type": "equivalent", "target": "93eb76c62bb301b0a3834e023bb10c88", "evidence": {"same_day": true, "patch_ids": ["609cd06a11714310dc3229712096f406"], "statement_hash": "fa82363c7134e5eb734924371926008cb70a2caa6cbaf956cbf5e18732a83ace"}}], "version": "14.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "93eb76c62bb301b0a3834e023bb10c88", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Fix assertion failure in BRIN minmax-multi opclasses", "evidence": {"same_day": true, "patch_ids": ["609cd06a11714310dc3229712096f406"], "statement_hash": "fa82363c7134e5eb734924371926008cb70a2caa6cbaf956cbf5e18732a83ace"}, "url": "/docs/compare/?release=15.2#15.2-a4ccb583e902b881", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}]}, {"id": "14.7-17195b2be94f4614", "cves": [], "html": "Remove faulty assertion in useless-RESULT-RTE optimization logic (Tom Lane) §
", "text": "Remove faulty assertion in useless-RESULT-RTE optimization logic (Tom Lane) §", "title": "Remove faulty assertion in useless-RESULT-RTE optimization logic", "commits": ["0224646be"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "b8716bc5b39e40a1163c2763b8dcdadc1e3e628adc4cc92ae535e4f9e02e3a37", "section_path": ["Changes"], "commit_groups": [["0224646be", "51dfaa0b0", "556c0b913", "aca695fb6", "bb8d48cb9"]], "identity_text": "Remove faulty assertion in useless-RESULT-RTE optimization logic (Tom Lane)", "commit_aliases": ["0224646be", "51dfaa0b0", "556c0b913", "aca695fb6", "bb8d48cb9"], "source_commits": ["0224646be"], "source_entry_id": "14.7/changes/036", "db_id": "970ef9a05690a1680569a5acd35118a4", "patch_ids": ["58506a6cee8ac5c3497e564d7f5a86a0"], "statement_hash": "cfdd89462d73930b717110313c8b418bbaa941a53fe12d23618c09a256f5ce50", "relations": [{"rule": 2, "type": "equivalent", "target": "1b9f799d12299dcab3e1cfdb258673cb", "evidence": {"same_day": true, "patch_ids": ["58506a6cee8ac5c3497e564d7f5a86a0"], "statement_hash": "cfdd89462d73930b717110313c8b418bbaa941a53fe12d23618c09a256f5ce50"}}, {"rule": 2, "type": "equivalent", "target": "201f3f89e807b9a5b51320b5ecdc4250", "evidence": {"same_day": true, "patch_ids": ["58506a6cee8ac5c3497e564d7f5a86a0"], "statement_hash": "cfdd89462d73930b717110313c8b418bbaa941a53fe12d23618c09a256f5ce50"}}, {"rule": 2, "type": "equivalent", "target": "5fbc219ae9be1094ffc7e766cbec510a", "evidence": {"same_day": true, "patch_ids": ["58506a6cee8ac5c3497e564d7f5a86a0"], "statement_hash": "cfdd89462d73930b717110313c8b418bbaa941a53fe12d23618c09a256f5ce50"}}], "version": "14.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "5fbc219ae9be1094ffc7e766cbec510a", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Remove faulty assertion in useless-RESULT-RTE optimization logic", "evidence": {"same_day": true, "patch_ids": ["58506a6cee8ac5c3497e564d7f5a86a0"], "statement_hash": "cfdd89462d73930b717110313c8b418bbaa941a53fe12d23618c09a256f5ce50"}, "url": "/docs/compare/?release=15.2#15.2-eec88e52a646ccef", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "201f3f89e807b9a5b51320b5ecdc4250", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Remove faulty assertion in useless-RESULT-RTE optimization logic", "evidence": {"same_day": true, "patch_ids": ["58506a6cee8ac5c3497e564d7f5a86a0"], "statement_hash": "cfdd89462d73930b717110313c8b418bbaa941a53fe12d23618c09a256f5ce50"}, "url": "/docs/compare/?release=13.10#13.10-1cc91b6f6d4cdb1b", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "1b9f799d12299dcab3e1cfdb258673cb", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Remove faulty assertion in useless-RESULT-RTE optimization logic", "evidence": {"same_day": true, "patch_ids": ["58506a6cee8ac5c3497e564d7f5a86a0"], "statement_hash": "cfdd89462d73930b717110313c8b418bbaa941a53fe12d23618c09a256f5ce50"}, "url": "/docs/compare/?release=12.14#12.14-8f23a953d8dbe34c", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}]}, {"id": "14.7-1f0629a5b710dd27", "cves": [], "html": "Fix copy-and-paste errors in cache-lookup-failure messages for ACL checks (Justin Pryzby) §
\nIn principle these errors should never be reached. But if they are, some of them reported the wrong type of object.
", "text": "Fix copy-and-paste errors in cache-lookup-failure messages for ACL checks (Justin Pryzby) § In principle these errors should never be reached. But if they are, some of them reported the wrong type of object.", "title": "Fix copy-and-paste errors in cache-lookup-failure messages for ACL checks", "commits": ["7ad458e06"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "8effd0a5fdd2d8d3376cb94d3dd35c3f099a6624c1eeb8af1a831296b2da4433", "section_path": ["Changes"], "commit_groups": [["2fcf685f6", "4dbe72d61", "7445869e1", "7ad458e06", "df6fea51f", "e3897a3a4"]], "identity_text": "Fix copy-and-paste errors in cache-lookup-failure messages for ACL checks (Justin Pryzby) In principle these errors should never be reached. But if they are, some of them reported the wrong type of object.", "commit_aliases": ["2fcf685f6", "4dbe72d61", "7445869e1", "7ad458e06", "df6fea51f", "e3897a3a4"], "source_commits": ["7ad458e06"], "source_entry_id": "14.7/changes/037", "db_id": "20a860f1e7551d1458908dc95a480324", "patch_ids": ["5f2d7f04390e7331c118a61d5827a14c"], "statement_hash": "db3b9620dd1b93003cb7ee4f4c950583143a13f74259b5013509bbd747c528d3", "relations": [{"rule": 2, "type": "equivalent", "target": "0b310f52b5402717e772cd7cc9f18573", "evidence": {"same_day": true, "patch_ids": ["5f2d7f04390e7331c118a61d5827a14c"], "statement_hash": "db3b9620dd1b93003cb7ee4f4c950583143a13f74259b5013509bbd747c528d3"}}, {"rule": 2, "type": "equivalent", "target": "61a21eb9aaf62495be06e179ff45e2ab", "evidence": {"same_day": true, "patch_ids": ["5f2d7f04390e7331c118a61d5827a14c"], "statement_hash": "db3b9620dd1b93003cb7ee4f4c950583143a13f74259b5013509bbd747c528d3"}}, {"rule": 2, "type": "equivalent", "target": "78f047c402bae655ff6f43bdcdf1c0cd", "evidence": {"same_day": true, "patch_ids": ["5f2d7f04390e7331c118a61d5827a14c"], "statement_hash": "db3b9620dd1b93003cb7ee4f4c950583143a13f74259b5013509bbd747c528d3"}}, {"rule": 2, "type": "equivalent", "target": "b26dad4290c55bbf5650cc06c44dd245", "evidence": {"same_day": true, "patch_ids": ["5f2d7f04390e7331c118a61d5827a14c"], "statement_hash": "db3b9620dd1b93003cb7ee4f4c950583143a13f74259b5013509bbd747c528d3"}}], "version": "14.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "b26dad4290c55bbf5650cc06c44dd245", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Fix copy-and-paste errors in cache-lookup-failure messages for ACL checks", "evidence": {"same_day": true, "patch_ids": ["5f2d7f04390e7331c118a61d5827a14c"], "statement_hash": "db3b9620dd1b93003cb7ee4f4c950583143a13f74259b5013509bbd747c528d3"}, "url": "/docs/compare/?release=15.2#15.2-3be72836e10f2f21", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "0b310f52b5402717e772cd7cc9f18573", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Fix copy-and-paste errors in cache-lookup-failure messages for ACL checks", "evidence": {"same_day": true, "patch_ids": ["5f2d7f04390e7331c118a61d5827a14c"], "statement_hash": "db3b9620dd1b93003cb7ee4f4c950583143a13f74259b5013509bbd747c528d3"}, "url": "/docs/compare/?release=13.10#13.10-37d66edae0310794", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "78f047c402bae655ff6f43bdcdf1c0cd", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Fix copy-and-paste errors in cache-lookup-failure messages for ACL checks", "evidence": {"same_day": true, "patch_ids": ["5f2d7f04390e7331c118a61d5827a14c"], "statement_hash": "db3b9620dd1b93003cb7ee4f4c950583143a13f74259b5013509bbd747c528d3"}, "url": "/docs/compare/?release=12.14#12.14-456bb06426415855", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "61a21eb9aaf62495be06e179ff45e2ab", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "Fix copy-and-paste errors in cache-lookup-failure messages for ACL checks", "evidence": {"same_day": true, "patch_ids": ["5f2d7f04390e7331c118a61d5827a14c"], "statement_hash": "db3b9620dd1b93003cb7ee4f4c950583143a13f74259b5013509bbd747c528d3"}, "url": "/docs/compare/?release=11.19#11.19-04359fb1d4b53103", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}, {"id": "14.7-6249ffc08d8795d0", "cves": [], "html": "In pg_dump, avoid calling unsafe server functions before we have locks on the tables to be examined (Tom Lane, Gilles Darold) § §
\npg_dump uses certain server functions that can fail if examining a table that gets dropped concurrently. Avoid this type of failure by ensuring that we obtain access share lock before inquiring too deeply into a table's properties, and that we don't apply such functions to tables we don't intend to dump at all.
", "text": "In pg_dump, avoid calling unsafe server functions before we have locks on the tables to be examined (Tom Lane, Gilles Darold) § § pg_dump uses certain server functions that can fail if examining a table that gets dropped concurrently. Avoid this type of failure by ensuring that we obtain access share lock before inquiring too deeply into a table's properties, and that we don't apply such functions to tables we don't intend to dump at all.", "title": "In pg_dump, avoid calling unsafe server functions before we have locks on the tables to be examined", "commits": ["03ac48549", "55f30e6c7"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "5936f05490b2432fb1e32d92623288d36b25b90d82f95e9b6f95576e054e0422", "section_path": ["Changes"], "commit_groups": [["03ac48549", "1ed6f1b91", "a5b26aaaf", "b7333e826"], ["344b78492", "55f30e6c7", "b1f106420", "e46e986ba"]], "identity_text": "In pg_dump, avoid calling unsafe server functions before we have locks on the tables to be examined (Tom Lane, Gilles Darold) pg_dump uses certain server functions that can fail if examining a table that gets dropped concurrently. Avoid this type of failure by ensuring that we obtain access share lock before inquiring too deeply into a table's properties, and that we don't apply such functions to tables we don't intend to dump at all.", "commit_aliases": ["03ac48549", "1ed6f1b91", "344b78492", "55f30e6c7", "a5b26aaaf", "b1f106420", "b7333e826", "e46e986ba"], "source_commits": ["03ac48549", "55f30e6c7"], "source_entry_id": "14.7/changes/038", "db_id": "26f226c5f77f417518c418c72af3a7b8", "patch_ids": ["4f6f6d03a7e87bb9337d423d82753b5f", "d241b3f190d6cec4835111e952ceed88"], "statement_hash": "37c196eb39e43cbd81fee8662875cb2379beee06ceb22e74a6ee18030410cc43", "relations": [{"rule": 2, "type": "equivalent", "target": "51d70bf9c0099708da3c214f2f856679", "evidence": {"same_day": true, "patch_ids": ["4f6f6d03a7e87bb9337d423d82753b5f", "d241b3f190d6cec4835111e952ceed88"], "statement_hash": "37c196eb39e43cbd81fee8662875cb2379beee06ceb22e74a6ee18030410cc43"}}, {"rule": 2, "type": "equivalent", "target": "bb875ec837473d6be4e66a1c050f7849", "evidence": {"same_day": true, "patch_ids": ["4f6f6d03a7e87bb9337d423d82753b5f", "d241b3f190d6cec4835111e952ceed88"], "statement_hash": "37c196eb39e43cbd81fee8662875cb2379beee06ceb22e74a6ee18030410cc43"}}, {"rule": 2, "type": "equivalent", "target": "e8b174a6ef2381ae54a3b32159b2a045", "evidence": {"same_day": true, "patch_ids": ["4f6f6d03a7e87bb9337d423d82753b5f", "d241b3f190d6cec4835111e952ceed88"], "statement_hash": "37c196eb39e43cbd81fee8662875cb2379beee06ceb22e74a6ee18030410cc43"}}], "version": "14.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "e8b174a6ef2381ae54a3b32159b2a045", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "In pg_dump, avoid calling unsafe server functions before we have locks on the tables to be examined", "evidence": {"same_day": true, "patch_ids": ["4f6f6d03a7e87bb9337d423d82753b5f", "d241b3f190d6cec4835111e952ceed88"], "statement_hash": "37c196eb39e43cbd81fee8662875cb2379beee06ceb22e74a6ee18030410cc43"}, "url": "/docs/compare/?release=13.10#13.10-cd9a8e6140af4152", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "51d70bf9c0099708da3c214f2f856679", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "In pg_dump, avoid calling unsafe server functions before we have locks on the tables to be examined", "evidence": {"same_day": true, "patch_ids": ["4f6f6d03a7e87bb9337d423d82753b5f", "d241b3f190d6cec4835111e952ceed88"], "statement_hash": "37c196eb39e43cbd81fee8662875cb2379beee06ceb22e74a6ee18030410cc43"}, "url": "/docs/compare/?release=12.14#12.14-f9cb17065fe92a56", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "bb875ec837473d6be4e66a1c050f7849", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "In pg_dump, avoid calling unsafe server functions before we have locks on the tables to be examined", "evidence": {"same_day": true, "patch_ids": ["4f6f6d03a7e87bb9337d423d82753b5f", "d241b3f190d6cec4835111e952ceed88"], "statement_hash": "37c196eb39e43cbd81fee8662875cb2379beee06ceb22e74a6ee18030410cc43"}, "url": "/docs/compare/?release=11.19#11.19-17f07db3d8445903", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}, {"id": "14.7-4d68d70405046e5c", "cves": [], "html": "Fix psql's \\sf and \\ef commands to handle SQL-language functions that have SQL-standard function bodies (Tom Lane) §
These commands misidentified the start of the function body when it used new-style syntax.
", "text": "Fix psql's \\sf and \\ef commands to handle SQL-language functions that have SQL-standard function bodies (Tom Lane) § These commands misidentified the start of the function body when it used new-style syntax.", "title": "Fix psql's \\sf and \\ef commands to handle SQL-language functions that have SQL-standard function bodies", "commits": ["303b26c1b"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "9f84ac255f4122ec650fc6e0e2a97b7d2b8058397c49634f94c1ad0e69986949", "section_path": ["Changes"], "commit_groups": [["303b26c1b", "97299cf99", "cabfb8241"]], "identity_text": "Fix psql's \\sf and \\ef commands to handle SQL-language functions that have SQL-standard function bodies (Tom Lane) These commands misidentified the start of the function body when it used new-style syntax.", "commit_aliases": ["303b26c1b", "97299cf99", "cabfb8241"], "source_commits": ["303b26c1b"], "source_entry_id": "14.7/changes/039", "db_id": "3ecf14fb94d92ffd52d323ce238d6582", "patch_ids": ["e03b9ef7edbba011f49e38f9ff67d2f3"], "statement_hash": "402d394f01d9cb8804c23077fe7ed8dff7c6799c0db237d7fd09eed8704ce602", "relations": [{"rule": 2, "type": "equivalent", "target": "b103d831e9cbd5ee48bed9c9888b9035", "evidence": {"same_day": true, "patch_ids": ["e03b9ef7edbba011f49e38f9ff67d2f3"], "statement_hash": "402d394f01d9cb8804c23077fe7ed8dff7c6799c0db237d7fd09eed8704ce602"}}], "version": "14.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "b103d831e9cbd5ee48bed9c9888b9035", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Fix psql's \\sf and \\ef commands to handle SQL-language functions that have SQL-standard function bodies", "evidence": {"same_day": true, "patch_ids": ["e03b9ef7edbba011f49e38f9ff67d2f3"], "statement_hash": "402d394f01d9cb8804c23077fe7ed8dff7c6799c0db237d7fd09eed8704ce602"}, "url": "/docs/compare/?release=15.2#15.2-e5dfb4e510f73e41", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}]}, {"id": "14.7-39bfcf79c2e688e4", "cves": [], "html": "Fix tab completion of ALTER FUNCTION/PROCEDURE/ROUTINE ... SET SCHEMA (Dean Rasheed) §
Fix contrib/seg to not crash or print garbage if an input number has more than 127 digits (Tom Lane) §
Fix build on Microsoft Visual Studio 2013 (Tom Lane) §
\nA previous patch supposed that all platforms of interest have snprintf(), but MSVC 2013 isn't quite there yet. Revert to using sprintf() on that platform.
Fix compile failure in building PL/Perl with MSVC when using Strawberry Perl (Andrew Dunstan) §
", "text": "Fix compile failure in building PL/Perl with MSVC when using Strawberry Perl (Andrew Dunstan) §", "title": "Fix compile failure in building PL/Perl with MSVC when using Strawberry Perl", "commits": ["f76191fd9"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "a31818aef0edb33af4f4b07947dc2c6c921b85dd51bc800c786cd895ca777ecf", "section_path": ["Changes"], "commit_groups": [["171c7fffa", "341f4e002", "9fe5cff14", "ae7c51213", "f76191fd9", "fed54fc9a"]], "identity_text": "Fix compile failure in building PL/Perl with MSVC when using Strawberry Perl (Andrew Dunstan)", "commit_aliases": ["171c7fffa", "341f4e002", "9fe5cff14", "ae7c51213", "f76191fd9", "fed54fc9a"], "source_commits": ["f76191fd9"], "source_entry_id": "14.7/changes/043", "db_id": "5c16a7fc4b7cccafa4fca346108fa06d", "patch_ids": ["e146361bb85a7ba5befe9b8bb0225ae5"], "statement_hash": "fd3ed3633236c287fcbb631c9ddfb73496350acdfefb9aeaacb0f422d39242fe", "relations": [{"rule": 2, "type": "equivalent", "target": "1d5b461d110093b7f4d80ee9d283249c", "evidence": {"same_day": true, "patch_ids": ["e146361bb85a7ba5befe9b8bb0225ae5"], "statement_hash": "fd3ed3633236c287fcbb631c9ddfb73496350acdfefb9aeaacb0f422d39242fe"}}, {"rule": 2, "type": "equivalent", "target": "9d36f1125ad1cc9d57d083e412864cda", "evidence": {"same_day": true, "patch_ids": ["e146361bb85a7ba5befe9b8bb0225ae5"], "statement_hash": "fd3ed3633236c287fcbb631c9ddfb73496350acdfefb9aeaacb0f422d39242fe"}}, {"rule": 2, "type": "equivalent", "target": "ab79678607c5ef6764e83bb4a22dc0e9", "evidence": {"same_day": true, "patch_ids": ["e146361bb85a7ba5befe9b8bb0225ae5"], "statement_hash": "fd3ed3633236c287fcbb631c9ddfb73496350acdfefb9aeaacb0f422d39242fe"}}, {"rule": 2, "type": "equivalent", "target": "da239ef55aff1b5eeb22e642463579b3", "evidence": {"same_day": true, "patch_ids": ["e146361bb85a7ba5befe9b8bb0225ae5"], "statement_hash": "fd3ed3633236c287fcbb631c9ddfb73496350acdfefb9aeaacb0f422d39242fe"}}], "version": "14.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "da239ef55aff1b5eeb22e642463579b3", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Fix compile failure in building PL/Perl with MSVC when using Strawberry Perl", "evidence": {"same_day": true, "patch_ids": ["e146361bb85a7ba5befe9b8bb0225ae5"], "statement_hash": "fd3ed3633236c287fcbb631c9ddfb73496350acdfefb9aeaacb0f422d39242fe"}, "url": "/docs/compare/?release=15.2#15.2-2ca836f020378d0d", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "ab79678607c5ef6764e83bb4a22dc0e9", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Fix compile failure in building PL/Perl with MSVC when using Strawberry Perl", "evidence": {"same_day": true, "patch_ids": ["e146361bb85a7ba5befe9b8bb0225ae5"], "statement_hash": "fd3ed3633236c287fcbb631c9ddfb73496350acdfefb9aeaacb0f422d39242fe"}, "url": "/docs/compare/?release=13.10#13.10-a76123c726b0a642", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "1d5b461d110093b7f4d80ee9d283249c", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Fix compile failure in building PL/Perl with MSVC when using Strawberry Perl", "evidence": {"same_day": true, "patch_ids": ["e146361bb85a7ba5befe9b8bb0225ae5"], "statement_hash": "fd3ed3633236c287fcbb631c9ddfb73496350acdfefb9aeaacb0f422d39242fe"}, "url": "/docs/compare/?release=12.14#12.14-6aa6eaaa14338d88", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "9d36f1125ad1cc9d57d083e412864cda", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "Fix compile failure in building PL/Perl with MSVC when using Strawberry Perl", "evidence": {"same_day": true, "patch_ids": ["e146361bb85a7ba5befe9b8bb0225ae5"], "statement_hash": "fd3ed3633236c287fcbb631c9ddfb73496350acdfefb9aeaacb0f422d39242fe"}, "url": "/docs/compare/?release=11.19#11.19-7c046381812f9455", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}, {"id": "14.7-a4320fafebb258b2", "cves": [], "html": "Fix mismatch of PL/Perl built with MSVC versus a Perl library built with gcc (Andrew Dunstan) §
\nSuch combinations could previously fail with “loadable library and perl binaries are mismatched” errors.
", "text": "Fix mismatch of PL/Perl built with MSVC versus a Perl library built with gcc (Andrew Dunstan) § Such combinations could previously fail with “loadable library and perl binaries are mismatched” errors.", "title": "Fix mismatch of PL/Perl built with MSVC versus a Perl library built with gcc", "commits": ["f3f70b8de"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "577f0406652fabac3217a3e90bbcd1323a6caa486688ae264dbae0d80af0fdc8", "section_path": ["Changes"], "commit_groups": [["68d89d80c", "724dd5649", "85565cbca", "b5d8fd418", "ccc59a83c", "f3f70b8de"]], "identity_text": "Fix mismatch of PL/Perl built with MSVC versus a Perl library built with gcc (Andrew Dunstan) Such combinations could previously fail with loadable library and perl binaries are mismatched errors.", "commit_aliases": ["68d89d80c", "724dd5649", "85565cbca", "b5d8fd418", "ccc59a83c", "f3f70b8de"], "source_commits": ["f3f70b8de"], "source_entry_id": "14.7/changes/044", "db_id": "7266b2d89f8ea246d409a64b64649cb3", "patch_ids": ["da4c5c966fed0d5ca572b4f0fbc648f4"], "statement_hash": "14a29a170eb83005db58c47c472e5915271304ce4dd40f466a3e27ef61627a6a", "relations": [{"rule": 2, "type": "equivalent", "target": "4f059006adb8bedecbf81dafc145a2fd", "evidence": {"same_day": true, "patch_ids": ["da4c5c966fed0d5ca572b4f0fbc648f4"], "statement_hash": "14a29a170eb83005db58c47c472e5915271304ce4dd40f466a3e27ef61627a6a"}}, {"rule": 2, "type": "equivalent", "target": "89e4e2690a29b8d1fc7680fbe9915348", "evidence": {"same_day": true, "patch_ids": ["da4c5c966fed0d5ca572b4f0fbc648f4"], "statement_hash": "14a29a170eb83005db58c47c472e5915271304ce4dd40f466a3e27ef61627a6a"}}, {"rule": 2, "type": "equivalent", "target": "90463d6cf4eebe1d8a06945bdda7187d", "evidence": {"same_day": true, "patch_ids": ["da4c5c966fed0d5ca572b4f0fbc648f4"], "statement_hash": "14a29a170eb83005db58c47c472e5915271304ce4dd40f466a3e27ef61627a6a"}}, {"rule": 2, "type": "equivalent", "target": "d725eb23a9abe1f2a27fbbc4f8513ac0", "evidence": {"same_day": true, "patch_ids": ["da4c5c966fed0d5ca572b4f0fbc648f4"], "statement_hash": "14a29a170eb83005db58c47c472e5915271304ce4dd40f466a3e27ef61627a6a"}}], "version": "14.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "d725eb23a9abe1f2a27fbbc4f8513ac0", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Fix mismatch of PL/Perl built with MSVC versus a Perl library built with gcc", "evidence": {"same_day": true, "patch_ids": ["da4c5c966fed0d5ca572b4f0fbc648f4"], "statement_hash": "14a29a170eb83005db58c47c472e5915271304ce4dd40f466a3e27ef61627a6a"}, "url": "/docs/compare/?release=15.2#15.2-84441a0c555a06da", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "89e4e2690a29b8d1fc7680fbe9915348", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Fix mismatch of PL/Perl built with MSVC versus a Perl library built with gcc", "evidence": {"same_day": true, "patch_ids": ["da4c5c966fed0d5ca572b4f0fbc648f4"], "statement_hash": "14a29a170eb83005db58c47c472e5915271304ce4dd40f466a3e27ef61627a6a"}, "url": "/docs/compare/?release=13.10#13.10-fd6a7f19c31305d7", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "90463d6cf4eebe1d8a06945bdda7187d", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Fix mismatch of PL/Perl built with MSVC versus a Perl library built with gcc", "evidence": {"same_day": true, "patch_ids": ["da4c5c966fed0d5ca572b4f0fbc648f4"], "statement_hash": "14a29a170eb83005db58c47c472e5915271304ce4dd40f466a3e27ef61627a6a"}, "url": "/docs/compare/?release=12.14#12.14-0d6a0bc7f9e3c868", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "4f059006adb8bedecbf81dafc145a2fd", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "Fix mismatch of PL/Perl built with MSVC versus a Perl library built with gcc", "evidence": {"same_day": true, "patch_ids": ["da4c5c966fed0d5ca572b4f0fbc648f4"], "statement_hash": "14a29a170eb83005db58c47c472e5915271304ce4dd40f466a3e27ef61627a6a"}, "url": "/docs/compare/?release=11.19#11.19-33629425061dff65", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}, {"id": "14.7-e3f0c52f0bca1397", "cves": [], "html": "Suppress compiler warnings from Perl's header files (Andres Freund) §
\nOur preferred compiler options provoke warnings about constructs appearing in recent versions of Perl's header files. When using gcc, we can suppress these warnings with a pragma.
", "text": "Suppress compiler warnings from Perl's header files (Andres Freund) § Our preferred compiler options provoke warnings about constructs appearing in recent versions of Perl's header files. When using gcc, we can suppress these warnings with a pragma.", "title": "Suppress compiler warnings from Perl's header files", "commits": ["7b5dec760"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "d616db9f42199a459ef3e63dc8af1d6d4c95c1c6019c69091a00c710fa38975a", "section_path": ["Changes"], "commit_groups": [["388e80132", "7b5dec760", "99f8bc335", "c6e75e4c2", "ce073d014", "f0e13802f"]], "identity_text": "Suppress compiler warnings from Perl's header files (Andres Freund) Our preferred compiler options provoke warnings about constructs appearing in recent versions of Perl's header files. When using gcc, we can suppress these warnings with a pragma.", "commit_aliases": ["388e80132", "7b5dec760", "99f8bc335", "c6e75e4c2", "ce073d014", "f0e13802f"], "source_commits": ["7b5dec760"], "source_entry_id": "14.7/changes/045", "db_id": "4b0ba7f3c8d9033f3bfcce2a2b06a2e6", "patch_ids": ["35caff6b7a01141d73cb1261ad2bf00e"], "statement_hash": "8ead208361fa3b4b8ba99ea421278aacd4bdb05c76c073719d02c43b2244c1fe", "relations": [{"rule": 2, "type": "equivalent", "target": "1a91bec2452d78574e0e24a9adfc5537", "evidence": {"same_day": true, "patch_ids": ["35caff6b7a01141d73cb1261ad2bf00e"], "statement_hash": "8ead208361fa3b4b8ba99ea421278aacd4bdb05c76c073719d02c43b2244c1fe"}}, {"rule": 2, "type": "equivalent", "target": "3e044c396d29210d6916dcf658bec97b", "evidence": {"same_day": true, "patch_ids": ["35caff6b7a01141d73cb1261ad2bf00e"], "statement_hash": "8ead208361fa3b4b8ba99ea421278aacd4bdb05c76c073719d02c43b2244c1fe"}}, {"rule": 2, "type": "equivalent", "target": "dc0a90e73f4c93c02c4f79a982bd4a22", "evidence": {"same_day": true, "patch_ids": ["35caff6b7a01141d73cb1261ad2bf00e"], "statement_hash": "8ead208361fa3b4b8ba99ea421278aacd4bdb05c76c073719d02c43b2244c1fe"}}, {"rule": 2, "type": "equivalent", "target": "f57c4063be96c687d8639dc462c312a6", "evidence": {"same_day": true, "patch_ids": ["35caff6b7a01141d73cb1261ad2bf00e"], "statement_hash": "8ead208361fa3b4b8ba99ea421278aacd4bdb05c76c073719d02c43b2244c1fe"}}], "version": "14.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f57c4063be96c687d8639dc462c312a6", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Suppress compiler warnings from Perl's header files", "evidence": {"same_day": true, "patch_ids": ["35caff6b7a01141d73cb1261ad2bf00e"], "statement_hash": "8ead208361fa3b4b8ba99ea421278aacd4bdb05c76c073719d02c43b2244c1fe"}, "url": "/docs/compare/?release=15.2#15.2-7684209475050573", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "1a91bec2452d78574e0e24a9adfc5537", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Suppress compiler warnings from Perl's header files", "evidence": {"same_day": true, "patch_ids": ["35caff6b7a01141d73cb1261ad2bf00e"], "statement_hash": "8ead208361fa3b4b8ba99ea421278aacd4bdb05c76c073719d02c43b2244c1fe"}, "url": "/docs/compare/?release=13.10#13.10-610c58870597877a", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "dc0a90e73f4c93c02c4f79a982bd4a22", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Suppress compiler warnings from Perl's header files", "evidence": {"same_day": true, "patch_ids": ["35caff6b7a01141d73cb1261ad2bf00e"], "statement_hash": "8ead208361fa3b4b8ba99ea421278aacd4bdb05c76c073719d02c43b2244c1fe"}, "url": "/docs/compare/?release=12.14#12.14-5e92240f55e56beb", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "3e044c396d29210d6916dcf658bec97b", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "Suppress compiler warnings from Perl's header files", "evidence": {"same_day": true, "patch_ids": ["35caff6b7a01141d73cb1261ad2bf00e"], "statement_hash": "8ead208361fa3b4b8ba99ea421278aacd4bdb05c76c073719d02c43b2244c1fe"}, "url": "/docs/compare/?release=11.19#11.19-87457641d8eaa960", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}, {"id": "14.7-fae0e7f5d4440689", "cves": [], "html": "Fix pg_waldump to build on compilers that don't discard unused static-inline functions (Tom Lane) §
", "text": "Fix pg_waldump to build on compilers that don't discard unused static-inline functions (Tom Lane) §", "title": "Fix pg_waldump to build on compilers that don't discard unused static-inline functions", "commits": ["21c058648"], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "5f726cfb8d213377c3dba8019631dd9288ad44edf7fa3a6bbb3aba0996f76c0e", "section_path": ["Changes"], "commit_groups": [["21c058648", "6d066d56b", "9a40a0311", "b69e9dfab", "c78f109b8"]], "identity_text": "Fix pg_waldump to build on compilers that don't discard unused static-inline functions (Tom Lane)", "commit_aliases": ["21c058648", "6d066d56b", "9a40a0311", "b69e9dfab", "c78f109b8"], "source_commits": ["21c058648"], "source_entry_id": "14.7/changes/046", "db_id": "5220c36750f3687b69555b7aa1d10e16", "patch_ids": ["88681ea8f27e40cdd7ae9165ed47e9f0"], "statement_hash": "7d48262705d9f59cb5f94fa61d667642d5e11e226d5e8de7a83a0768fab9c20b", "relations": [{"rule": 2, "type": "equivalent", "target": "3e83c5af6889e79a1e628ebed845ab12", "evidence": {"same_day": true, "patch_ids": ["88681ea8f27e40cdd7ae9165ed47e9f0"], "statement_hash": "7d48262705d9f59cb5f94fa61d667642d5e11e226d5e8de7a83a0768fab9c20b"}}, {"rule": 2, "type": "equivalent", "target": "892d7245d1c929ced8cbbfe02998c45f", "evidence": {"same_day": true, "patch_ids": ["88681ea8f27e40cdd7ae9165ed47e9f0"], "statement_hash": "7d48262705d9f59cb5f94fa61d667642d5e11e226d5e8de7a83a0768fab9c20b"}}, {"rule": 2, "type": "equivalent", "target": "dbecbce40ae24562c0522d3d4d1a411c", "evidence": {"same_day": true, "patch_ids": ["88681ea8f27e40cdd7ae9165ed47e9f0"], "statement_hash": "7d48262705d9f59cb5f94fa61d667642d5e11e226d5e8de7a83a0768fab9c20b"}}, {"rule": 2, "type": "equivalent", "target": "f49057c11f4d26365bc8a4a85d1fa83f", "evidence": {"same_day": true, "patch_ids": ["88681ea8f27e40cdd7ae9165ed47e9f0"], "statement_hash": "7d48262705d9f59cb5f94fa61d667642d5e11e226d5e8de7a83a0768fab9c20b"}}], "version": "14.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "892d7245d1c929ced8cbbfe02998c45f", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Fix pg_waldump to build on compilers that don't discard unused static-inline functions", "evidence": {"same_day": true, "patch_ids": ["88681ea8f27e40cdd7ae9165ed47e9f0"], "statement_hash": "7d48262705d9f59cb5f94fa61d667642d5e11e226d5e8de7a83a0768fab9c20b"}, "url": "/docs/compare/?release=15.2#15.2-c885a6aadebc34c7", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "f49057c11f4d26365bc8a4a85d1fa83f", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Fix pg_waldump to build on compilers that don't discard unused static-inline functions", "evidence": {"same_day": true, "patch_ids": ["88681ea8f27e40cdd7ae9165ed47e9f0"], "statement_hash": "7d48262705d9f59cb5f94fa61d667642d5e11e226d5e8de7a83a0768fab9c20b"}, "url": "/docs/compare/?release=13.10#13.10-587a77855be20a4e", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "3e83c5af6889e79a1e628ebed845ab12", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Fix pg_waldump to build on compilers that don't discard unused static-inline functions", "evidence": {"same_day": true, "patch_ids": ["88681ea8f27e40cdd7ae9165ed47e9f0"], "statement_hash": "7d48262705d9f59cb5f94fa61d667642d5e11e226d5e8de7a83a0768fab9c20b"}, "url": "/docs/compare/?release=12.14#12.14-43a9be42c571e574", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "dbecbce40ae24562c0522d3d4d1a411c", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "Fix pg_waldump to build on compilers that don't discard unused static-inline functions", "evidence": {"same_day": true, "patch_ids": ["88681ea8f27e40cdd7ae9165ed47e9f0"], "statement_hash": "7d48262705d9f59cb5f94fa61d667642d5e11e226d5e8de7a83a0768fab9c20b"}, "url": "/docs/compare/?release=11.19#11.19-712d0fafb3406680", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}, {"id": "14.7-7ed4e6ce88314171", "cves": [], "html": "Update time zone data files to tzdata release 2022g for DST law changes in Greenland and Mexico, plus historical corrections for northern Canada, Colombia, and Singapore. (Tom Lane) §
\nNotably, a new timezone America/Ciudad_Juarez has been split off from America/Ojinaga.
", "text": "Update time zone data files to tzdata release 2022g for DST law changes in Greenland and Mexico, plus historical corrections for northern Canada, Colombia, and Singapore. (Tom Lane) § Notably, a new timezone America/Ciudad_Juarez has been split off from America/Ojinaga.", "title": "Update time zone data files to tzdata release 2022g for DST law changes in Greenland and Mexico, plus historical corrections for northern Canada, Colombia, and Singapore.", "commits": ["7e6154779"], "section": "Changes", "category": "improvement", "source_url": "/docs/release/14.7/#id-1.11.6.23.5", "source_hash": "8c7ee6372c7841a1dd3e728f097a29eeff42823633c3a915d5021abd2aab6235", "section_path": ["Changes"], "commit_groups": [["20d9da107", "2c95d8776", "65f0d9d27", "758f44bc3", "7ddc428ef", "7e6154779"]], "identity_text": "Update time zone data files to tzdata release 2022g for DST law changes in Greenland and Mexico, plus historical corrections for northern Canada, Colombia, and Singapore. (Tom Lane) Notably, a new timezone America/Ciudad_Juarez has been split off from America/Ojinaga.", "commit_aliases": ["20d9da107", "2c95d8776", "65f0d9d27", "758f44bc3", "7ddc428ef", "7e6154779"], "source_commits": ["7e6154779"], "source_entry_id": "14.7/changes/047", "db_id": "7ca55307318c5a758acbe0ed71104f54", "patch_ids": ["26f414138b979e1a29fd81dde9bd6f58"], "statement_hash": "4fd9f7a6bd96261986ea31736e72935c49ba2dd576b7c420c58fd82c722fbc97", "relations": [{"rule": 2, "type": "equivalent", "target": "057311500b4f47f8510125cba87cb833", "evidence": {"same_day": true, "patch_ids": ["26f414138b979e1a29fd81dde9bd6f58"], "statement_hash": "4fd9f7a6bd96261986ea31736e72935c49ba2dd576b7c420c58fd82c722fbc97"}}, {"rule": 2, "type": "equivalent", "target": "9eea6485abce4ee4e523a1384e8405e0", "evidence": {"same_day": true, "patch_ids": ["26f414138b979e1a29fd81dde9bd6f58"], "statement_hash": "4fd9f7a6bd96261986ea31736e72935c49ba2dd576b7c420c58fd82c722fbc97"}}, {"rule": 2, "type": "equivalent", "target": "c065a78082e6143fac711a0805231ae7", "evidence": {"same_day": true, "patch_ids": ["26f414138b979e1a29fd81dde9bd6f58"], "statement_hash": "4fd9f7a6bd96261986ea31736e72935c49ba2dd576b7c420c58fd82c722fbc97"}}, {"rule": 2, "type": "equivalent", "target": "ebc834691b100667f797c42da9a7317e", "evidence": {"same_day": true, "patch_ids": ["26f414138b979e1a29fd81dde9bd6f58"]}}], "version": "14.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "057311500b4f47f8510125cba87cb833", "kind": "equivalent", "version": "15.2", "label": "15.2", "title": "Update time zone data files to tzdata release 2022g for DST law changes in Greenland and Mexico, plus historical corrections for northern Canada, Colombia, and Singapore.", "evidence": {"same_day": true, "patch_ids": ["26f414138b979e1a29fd81dde9bd6f58"], "statement_hash": "4fd9f7a6bd96261986ea31736e72935c49ba2dd576b7c420c58fd82c722fbc97"}, "url": "/docs/compare/?release=15.2#15.2-02f4f081ae3ada2d", "source_url": "/docs/release/15.2/#id-1.11.6.23.5"}, {"db_id": "9eea6485abce4ee4e523a1384e8405e0", "kind": "equivalent", "version": "13.10", "label": "13.10", "title": "Update time zone data files to tzdata release 2022g for DST law changes in Greenland and Mexico, plus historical corrections for northern Canada, Colombia, and Singapore.", "evidence": {"same_day": true, "patch_ids": ["26f414138b979e1a29fd81dde9bd6f58"], "statement_hash": "4fd9f7a6bd96261986ea31736e72935c49ba2dd576b7c420c58fd82c722fbc97"}, "url": "/docs/compare/?release=13.10#13.10-ba49e47882d4aa9f", "source_url": "/docs/release/13.10/#id-1.11.6.19.5"}, {"db_id": "c065a78082e6143fac711a0805231ae7", "kind": "equivalent", "version": "12.14", "label": "12.14", "title": "Update time zone data files to tzdata release 2022g for DST law changes in Greenland and Mexico, plus historical corrections for northern Canada, Colombia, and Singapore.", "evidence": {"same_day": true, "patch_ids": ["26f414138b979e1a29fd81dde9bd6f58"], "statement_hash": "4fd9f7a6bd96261986ea31736e72935c49ba2dd576b7c420c58fd82c722fbc97"}, "url": "/docs/compare/?release=12.14#12.14-533b478185ef1914", "source_url": "/docs/release/12.14/#id-1.11.6.14.5"}, {"db_id": "ebc834691b100667f797c42da9a7317e", "kind": "equivalent", "version": "11.19", "label": "11.19", "title": "Update time zone data files to tzdata release 2022g for DST law changes in Greenland and Mexico, plus historical corrections for northern Canada, Colombia, and Singapore.", "evidence": {"same_day": true, "patch_ids": ["26f414138b979e1a29fd81dde9bd6f58"]}, "url": "/docs/compare/?release=11.19#11.19-78768f63e929cf4b", "source_url": "/docs/release/11.19/#id-1.11.6.8.6"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 47}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 23}, {"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": 47, "release_count": 1, "cross_major": false, "cve_count": 1, "cves": [{"id": "CVE-2022-41862", "url": "https://www.postgresql.org/support/security/CVE-2022-41862/", "fixed": {"12": "12.14", "13": "13.10", "14": "14.7", "15": "15.2"}, "score": 3.7, "title": "libpq can leak memory contents after GSSAPI transport encryption initiation fails", "vector": "AV:N/AC:H/PR:N/UI:N/S:U/C:L/I:N/A:N", "affected": {"12": "12", "13": "13", "14": "14", "15": "15"}, "component": "client", "published": {"12": "2023-02-09", "13": "2023-02-09", "14": "2023-02-09", "15": "2023-02-09"}, "introduced": {}, "cvss_version": "3.0", "description_en": "A modified, unauthenticated server can send an unterminated string during the establishment of Kerberos transport encryption. When a libpq client application has a Kerberos credential cache and doesn't explicitly disable option gssencmode , a server can cause libpq to over-read and report an error message containing uninitialized bytes from and following its receive buffer. If libpq's caller somehow makes that message accessible to the attacker, this achieves a disclosure of the over-read bytes. We have not confirmed or ruled out viability of attacks that arrange for a crash or for presence of notable, confidential information in disclosed bytes.\n\nThe PostgreSQL project thanks Jacob Champion for reporting this problem.", "first_published": "2023-02-09", "fixed_version": "14.7"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 47, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}