A dump/restore is not required for those running 11.X.
\nHowever, if you are upgrading from a version earlier than 11.6, see Section E.17.
", "compatibility_count": 0, "label": "11.7", "status_label": "Historical", "eol": "2023-11-09", "age_days": 2420, "support_days": -1055}, "groups": [{"date": "2020-02-13", "build": "11.7", "major": "11", "minor": 7, "manual": "11", "status": "stable", "doc_git": "", "version": "11.7", "eol_date": "2023-11-09", "date_text": "2020-02-13", "supported": false, "manual_url": "/docs/11/release-11-7.html", "source_url": "/docs/release/11.7/", "entry_count": 56, "placeholder": false, "content_hash": "98136367e137af04cbf1c69b542a02fb930941cbde48ca6c0e37e28bef879b9c", "manual_build": "11.22", "source_as_of": "", "changes_count": 56, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 11.X.
\nHowever, if you are upgrading from a version earlier than 11.6, see Section E.17.
", "compatibility_count": 0, "label": "11.7", "status_label": "Historical", "eol": "2023-11-09", "age_days": 2420, "support_days": -1055, "entries": [{"id": "11.7-3dc5ff4db456b492", "cves": ["CVE-2020-1720"], "html": "Add missing permissions checks for ALTER ... DEPENDS ON EXTENSION (Álvaro Herrera)
Marking an object as dependent on an extension did not have any privilege check whatsoever. This oversight allowed any user to mark routines, triggers, materialized views, or indexes as droppable by anyone able to drop an extension. Require that the calling user own the specified object (and hence have privilege to drop it). (CVE-2020-1720)
", "text": "Add missing permissions checks for ALTER ... DEPENDS ON EXTENSION (Álvaro Herrera) Marking an object as dependent on an extension did not have any privilege check whatsoever. This oversight allowed any user to mark routines, triggers, materialized views, or indexes as droppable by anyone able to drop an extension. Require that the calling user own the specified object (and hence have privilege to drop it). (CVE-2020-1720)", "title": "Add missing permissions checks for ALTER ... DEPENDS ON EXTENSION", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "d0fa67e696a624ffaee54fcc80de35cabb2415d61c297f3b562313504ae8714e", "section_path": ["Changes"], "commit_groups": [["2ad125322", "ac1a998ed", "b048f558d", "bdd19e48a", "e8b8eb937"]], "identity_text": "Add missing permissions checks for ALTER ... DEPENDS ON EXTENSION (Álvaro Herrera) Marking an object as dependent on an extension did not have any privilege check whatsoever. This oversight allowed any user to mark routines, triggers, materialized views, or indexes as droppable by anyone able to drop an extension. Require that the calling user own the specified object (and hence have privilege to drop it). (CVE-2020-1720)", "commit_aliases": ["2ad125322", "ac1a998ed", "b048f558d", "bdd19e48a", "e8b8eb937"], "source_commits": ["bdd19e48a"], "source_entry_id": "11.7/changes/001", "db_id": "0996f001cb1ffbb122a5bba8cf55764f", "patch_ids": ["63b3debbf84673645f7ac9b987c30ca0"], "statement_hash": "af764eb0a2c95d985bd43741228f2ce69db83bb4a9b5160bf1ab42bbd0a0fb7e", "relations": [{"rule": 2, "type": "equivalent", "target": "98301dcc33caa482d422a6f57fbf5957", "evidence": {"same_day": true, "patch_ids": ["63b3debbf84673645f7ac9b987c30ca0"], "statement_hash": "af764eb0a2c95d985bd43741228f2ce69db83bb4a9b5160bf1ab42bbd0a0fb7e"}}, {"rule": 2, "type": "equivalent", "target": "d70df0706df2abf1bfb334c185608edf", "evidence": {"same_day": true, "patch_ids": ["63b3debbf84673645f7ac9b987c30ca0"], "statement_hash": "af764eb0a2c95d985bd43741228f2ce69db83bb4a9b5160bf1ab42bbd0a0fb7e"}}, {"rule": 2, "type": "equivalent", "target": "e7c3294c568782d7f22c5b777ffb6235", "evidence": {"same_day": true, "patch_ids": ["63b3debbf84673645f7ac9b987c30ca0"], "statement_hash": "af764eb0a2c95d985bd43741228f2ce69db83bb4a9b5160bf1ab42bbd0a0fb7e"}}], "version": "11.7", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "d70df0706df2abf1bfb334c185608edf", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Add missing permissions checks for ALTER ... DEPENDS ON EXTENSION", "evidence": {"same_day": true, "patch_ids": ["63b3debbf84673645f7ac9b987c30ca0"], "statement_hash": "af764eb0a2c95d985bd43741228f2ce69db83bb4a9b5160bf1ab42bbd0a0fb7e"}, "url": "/docs/compare/?release=12.2#12.2-aa2ddd8e29f6283e", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "98301dcc33caa482d422a6f57fbf5957", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Add missing permissions checks for ALTER ... DEPENDS ON EXTENSION", "evidence": {"same_day": true, "patch_ids": ["63b3debbf84673645f7ac9b987c30ca0"], "statement_hash": "af764eb0a2c95d985bd43741228f2ce69db83bb4a9b5160bf1ab42bbd0a0fb7e"}, "url": "/docs/compare/?release=10.12#10.12-3dc5ff4db456b492", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "e7c3294c568782d7f22c5b777ffb6235", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Add missing permissions checks for ALTER ... DEPENDS ON EXTENSION", "evidence": {"same_day": true, "patch_ids": ["63b3debbf84673645f7ac9b987c30ca0"], "statement_hash": "af764eb0a2c95d985bd43741228f2ce69db83bb4a9b5160bf1ab42bbd0a0fb7e"}, "url": "/docs/compare/?release=9.6.17#9.6.17-3dc5ff4db456b492", "source_url": "/docs/release/9.6.17/#AEN133104"}]}, {"id": "11.7-e03caad12786e3e7", "cves": [], "html": "Ensure that row triggers on partitioned tables are correctly cloned to sub-partitions when appropriate (Álvaro Herrera)
\nUser-defined triggers (but not triggers for foreign key or deferred unique constraints) might be missed when creating or attaching a partition.
", "text": "Ensure that row triggers on partitioned tables are correctly cloned to sub-partitions when appropriate (Álvaro Herrera) User-defined triggers (but not triggers for foreign key or deferred unique constraints) might be missed when creating or attaching a partition.", "title": "Ensure that row triggers on partitioned tables are correctly cloned to sub-partitions when appropriate", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "c551dde011db5f081073d2fe51b55bdcae8dfba86ba84f2f7f059a97766366d5", "section_path": ["Changes"], "commit_groups": [["1fa846f1c", "adc9cb6f2", "d73214839"]], "identity_text": "Ensure that row triggers on partitioned tables are correctly cloned to sub-partitions when appropriate (Álvaro Herrera) User-defined triggers (but not triggers for foreign key or deferred unique constraints) might be missed when creating or attaching a partition.", "commit_aliases": ["1fa846f1c", "adc9cb6f2", "d73214839"], "source_commits": ["adc9cb6f2"], "source_entry_id": "11.7/changes/002", "db_id": "c9d4a4b5d44bdf0878eb6eea89916a96", "patch_ids": ["c649260ddaefae4f14d5d22606e12457"], "statement_hash": "8a992218772c140c8c1591929c4000c5d64663be1a0a05c88ac470378fbf0d0a", "relations": [{"rule": 2, "type": "equivalent", "target": "d9288b1e1cc68cc3c76ff12f092ceeee", "evidence": {"same_day": true, "patch_ids": ["c649260ddaefae4f14d5d22606e12457"], "statement_hash": "8a992218772c140c8c1591929c4000c5d64663be1a0a05c88ac470378fbf0d0a"}}], "version": "11.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "d9288b1e1cc68cc3c76ff12f092ceeee", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Ensure that row triggers on partitioned tables are correctly cloned to sub-partitions when appropriate", "evidence": {"same_day": true, "patch_ids": ["c649260ddaefae4f14d5d22606e12457"], "statement_hash": "8a992218772c140c8c1591929c4000c5d64663be1a0a05c88ac470378fbf0d0a"}, "url": "/docs/compare/?release=12.2#12.2-bcc5e969e212535e", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}]}, {"id": "11.7-2ce95f9b8d87a500", "cves": [], "html": "Fix logical replication subscriber code to execute per-column UPDATE triggers when appropriate (Peter Eisentraut)
Avoid failure in logical decoding when a large transaction must be spilled into many separate temporary files (Amit Khandekar)
", "text": "Avoid failure in logical decoding when a large transaction must be spilled into many separate temporary files (Amit Khandekar)", "title": "Avoid failure in logical decoding when a large transaction must be spilled into many separate temporary files", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "7eb53778167e5b3409b06f17f619be72f9afa6eef28c73bbad99d64013e003f4", "section_path": ["Changes"], "commit_groups": [["17869eca7", "ed7bb5c31", "f9e95252a", "fa1eaebfa"], ["1ad47e875", "27b5f48c7", "3e3a79735", "a6f4f407a", "ba5b4e506", "d20703805", "f8a6d8e71"]], "identity_text": "Avoid failure in logical decoding when a large transaction must be spilled into many separate temporary files (Amit Khandekar)", "commit_aliases": ["17869eca7", "1ad47e875", "27b5f48c7", "3e3a79735", "a6f4f407a", "ba5b4e506", "d20703805", "ed7bb5c31", "f8a6d8e71", "f9e95252a", "fa1eaebfa"], "source_commits": ["17869eca7", "3e3a79735"], "source_entry_id": "11.7/changes/004", "db_id": "c00a4ec8d0168caec4abb79741c56f83", "patch_ids": ["7873f3c15aeba6e04159e49c910ab6c5", "ba9fb0a08c7a9f3e14a8eef4a462b4f6"], "statement_hash": "cfce4214cc870b1929d4ffd6e6ea956c6b88212d0df22fe921f0b5bfc818b553", "relations": [{"rule": 2, "type": "equivalent", "target": "2d998ba88a4a32c7f02f2c0a1eec85f8", "evidence": {"same_day": true, "patch_ids": ["7873f3c15aeba6e04159e49c910ab6c5", "ba9fb0a08c7a9f3e14a8eef4a462b4f6"], "statement_hash": "cfce4214cc870b1929d4ffd6e6ea956c6b88212d0df22fe921f0b5bfc818b553"}}, {"rule": 2, "type": "equivalent", "target": "4c6102cafd4a5d2470d743e4aa779d47", "evidence": {"same_day": true, "patch_ids": ["7873f3c15aeba6e04159e49c910ab6c5", "ba9fb0a08c7a9f3e14a8eef4a462b4f6"], "statement_hash": "cfce4214cc870b1929d4ffd6e6ea956c6b88212d0df22fe921f0b5bfc818b553"}}, {"rule": 2, "type": "equivalent", "target": "513700ddaf2321d10b3500d50a8d1699", "evidence": {"same_day": true, "patch_ids": ["7873f3c15aeba6e04159e49c910ab6c5", "ba9fb0a08c7a9f3e14a8eef4a462b4f6"], "statement_hash": "cfce4214cc870b1929d4ffd6e6ea956c6b88212d0df22fe921f0b5bfc818b553"}}, {"rule": 2, "type": "equivalent", "target": "8152a6b8f545280daf022279f4c3d05d", "evidence": {"same_day": true, "patch_ids": ["7873f3c15aeba6e04159e49c910ab6c5", "ba9fb0a08c7a9f3e14a8eef4a462b4f6"], "statement_hash": "cfce4214cc870b1929d4ffd6e6ea956c6b88212d0df22fe921f0b5bfc818b553"}}, {"rule": 2, "type": "equivalent", "target": "f8dcaeea8d85b6d20f07efe349465535", "evidence": {"same_day": true, "patch_ids": ["7873f3c15aeba6e04159e49c910ab6c5", "ba9fb0a08c7a9f3e14a8eef4a462b4f6"], "statement_hash": "cfce4214cc870b1929d4ffd6e6ea956c6b88212d0df22fe921f0b5bfc818b553"}}], "version": "11.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f8dcaeea8d85b6d20f07efe349465535", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Avoid failure in logical decoding when a large transaction must be spilled into many separate temporary files", "evidence": {"same_day": true, "patch_ids": ["7873f3c15aeba6e04159e49c910ab6c5", "ba9fb0a08c7a9f3e14a8eef4a462b4f6"], "statement_hash": "cfce4214cc870b1929d4ffd6e6ea956c6b88212d0df22fe921f0b5bfc818b553"}, "url": "/docs/compare/?release=12.2#12.2-b7d94cbf0f06a3c9", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "4c6102cafd4a5d2470d743e4aa779d47", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Avoid failure in logical decoding when a large transaction must be spilled into many separate temporary files", "evidence": {"same_day": true, "patch_ids": ["7873f3c15aeba6e04159e49c910ab6c5", "ba9fb0a08c7a9f3e14a8eef4a462b4f6"], "statement_hash": "cfce4214cc870b1929d4ffd6e6ea956c6b88212d0df22fe921f0b5bfc818b553"}, "url": "/docs/compare/?release=10.12#10.12-b90d77af461bab22", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "8152a6b8f545280daf022279f4c3d05d", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Avoid failure in logical decoding when a large transaction must be spilled into many separate temporary files", "evidence": {"same_day": true, "patch_ids": ["7873f3c15aeba6e04159e49c910ab6c5", "ba9fb0a08c7a9f3e14a8eef4a462b4f6"], "statement_hash": "cfce4214cc870b1929d4ffd6e6ea956c6b88212d0df22fe921f0b5bfc818b553"}, "url": "/docs/compare/?release=9.6.17#9.6.17-b90d77af461bab22", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "513700ddaf2321d10b3500d50a8d1699", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "Avoid failure in logical decoding when a large transaction must be spilled into many separate temporary files", "evidence": {"same_day": true, "patch_ids": ["7873f3c15aeba6e04159e49c910ab6c5", "ba9fb0a08c7a9f3e14a8eef4a462b4f6"], "statement_hash": "cfce4214cc870b1929d4ffd6e6ea956c6b88212d0df22fe921f0b5bfc818b553"}, "url": "/docs/compare/?release=9.5.21#9.5.21-b90d77af461bab22", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "2d998ba88a4a32c7f02f2c0a1eec85f8", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "Avoid failure in logical decoding when a large transaction must be spilled into many separate temporary files", "evidence": {"same_day": true, "patch_ids": ["7873f3c15aeba6e04159e49c910ab6c5", "ba9fb0a08c7a9f3e14a8eef4a462b4f6"], "statement_hash": "cfce4214cc870b1929d4ffd6e6ea956c6b88212d0df22fe921f0b5bfc818b553"}, "url": "/docs/compare/?release=9.4.26#9.4.26-b90d77af461bab22", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-f07e0a6d124cad2d", "cves": [], "html": "Fix possible crash or data corruption when a logical replication subscriber processes a row update (Tom Lane, Tomas Vondra)
\nThis bug caused visible problems only if the subscriber's table contained columns that were not being copied from the publisher and had pass-by-reference data types.
", "text": "Fix possible crash or data corruption when a logical replication subscriber processes a row update (Tom Lane, Tomas Vondra) This bug caused visible problems only if the subscriber's table contained columns that were not being copied from the publisher and had pass-by-reference data types.", "title": "Fix possible crash or data corruption when a logical replication subscriber processes a row update", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "edad2fd605d23058e883ccca0d03e695f850e713668c6051c37e6ba3cdffffbb", "section_path": ["Changes"], "commit_groups": [["4d9ceb001", "5d3fcb53a", "a2aa224e0", "b72a44c51"]], "identity_text": "Fix possible crash or data corruption when a logical replication subscriber processes a row update (Tom Lane, Tomas Vondra) This bug caused visible problems only if the subscriber's table contained columns that were not being copied from the publisher and had pass-by-reference data types.", "commit_aliases": ["4d9ceb001", "5d3fcb53a", "a2aa224e0", "b72a44c51"], "source_commits": ["b72a44c51"], "source_entry_id": "11.7/changes/005", "db_id": "1e5d19fcd4364f3a93bebb2942cbb8a0", "patch_ids": ["02ccff19b2d4f2e2d050662bea496856"], "statement_hash": "6babcbe37a98b792208bff0acb48a4344bfb2a5fe0b8863f0ee01a73b2edc1e6", "relations": [{"rule": 2, "type": "equivalent", "target": "35242c2556c9f0ca478bb15f4278d49d", "evidence": {"same_day": true, "patch_ids": ["02ccff19b2d4f2e2d050662bea496856"], "statement_hash": "6babcbe37a98b792208bff0acb48a4344bfb2a5fe0b8863f0ee01a73b2edc1e6"}}, {"rule": 2, "type": "equivalent", "target": "d2c39d4802fa027719cde8909d3c08a0", "evidence": {"same_day": true, "patch_ids": ["02ccff19b2d4f2e2d050662bea496856"], "statement_hash": "6babcbe37a98b792208bff0acb48a4344bfb2a5fe0b8863f0ee01a73b2edc1e6"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "35242c2556c9f0ca478bb15f4278d49d", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Fix possible crash or data corruption when a logical replication subscriber processes a row update", "evidence": {"same_day": true, "patch_ids": ["02ccff19b2d4f2e2d050662bea496856"], "statement_hash": "6babcbe37a98b792208bff0acb48a4344bfb2a5fe0b8863f0ee01a73b2edc1e6"}, "url": "/docs/compare/?release=12.2#12.2-e0f225d5e9f20e2c", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "d2c39d4802fa027719cde8909d3c08a0", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Fix possible crash or data corruption when a logical replication subscriber processes a row update", "evidence": {"same_day": true, "patch_ids": ["02ccff19b2d4f2e2d050662bea496856"], "statement_hash": "6babcbe37a98b792208bff0acb48a4344bfb2a5fe0b8863f0ee01a73b2edc1e6"}, "url": "/docs/compare/?release=10.12#10.12-f07e0a6d124cad2d", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}]}, {"id": "11.7-c9c4d72e069a23da", "cves": [], "html": "Fix crash in logical replication subscriber after DDL changes on a subscribed relation (Jehan-Guillaume de Rorthais, Vignesh C)
", "text": "Fix crash in logical replication subscriber after DDL changes on a subscribed relation (Jehan-Guillaume de Rorthais, Vignesh C)", "title": "Fix crash in logical replication subscriber after DDL changes on a subscribed relation", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "0165d15ebaa61d71b5886bc0fb23dfa2c4267ddb985ffb573dc71fc026ba7f42", "section_path": ["Changes"], "commit_groups": [["046830164", "04c8a69c0", "c74111d8b", "d6eca4958"]], "identity_text": "Fix crash in logical replication subscriber after DDL changes on a subscribed relation (Jehan-Guillaume de Rorthais, Vignesh C)", "commit_aliases": ["046830164", "04c8a69c0", "c74111d8b", "d6eca4958"], "source_commits": ["046830164"], "source_entry_id": "11.7/changes/006", "db_id": "7e454725d333fe6942f2590245eda5fe", "patch_ids": ["348ac9906853ba2e124b3a2f08df2093"], "statement_hash": "241858a4f396711ef48c2270fb1934b27a7ff4e22ea38c5d26c406b2183c2d69", "relations": [{"rule": 2, "type": "equivalent", "target": "201b9fbc389c9b378b57adcb0be87e12", "evidence": {"same_day": true, "patch_ids": ["348ac9906853ba2e124b3a2f08df2093"], "statement_hash": "241858a4f396711ef48c2270fb1934b27a7ff4e22ea38c5d26c406b2183c2d69"}}, {"rule": 2, "type": "equivalent", "target": "c3305570f2600a29676bd8b1b5cd26fd", "evidence": {"same_day": true, "patch_ids": ["348ac9906853ba2e124b3a2f08df2093"], "statement_hash": "241858a4f396711ef48c2270fb1934b27a7ff4e22ea38c5d26c406b2183c2d69"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c3305570f2600a29676bd8b1b5cd26fd", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Fix crash in logical replication subscriber after DDL changes on a subscribed relation", "evidence": {"same_day": true, "patch_ids": ["348ac9906853ba2e124b3a2f08df2093"], "statement_hash": "241858a4f396711ef48c2270fb1934b27a7ff4e22ea38c5d26c406b2183c2d69"}, "url": "/docs/compare/?release=12.2#12.2-08e4bcb887b8c0cc", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "201b9fbc389c9b378b57adcb0be87e12", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Fix crash in logical replication subscriber after DDL changes on a subscribed relation", "evidence": {"same_day": true, "patch_ids": ["348ac9906853ba2e124b3a2f08df2093"], "statement_hash": "241858a4f396711ef48c2270fb1934b27a7ff4e22ea38c5d26c406b2183c2d69"}, "url": "/docs/compare/?release=10.12#10.12-c9c4d72e069a23da", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}]}, {"id": "11.7-6ea1a95af0a90afd", "cves": [], "html": "Fix failure in logical replication publisher after a database crash and restart (Vignesh C)
", "text": "Fix failure in logical replication publisher after a database crash and restart (Vignesh C)", "title": "Fix failure in logical replication publisher after a database crash and restart", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "f3e085313def01bd4942a676a22c9e7959daeafbbc93a033f0bccee00af750fa", "section_path": ["Changes"], "commit_groups": [["15cac3a52", "20a1dc1e3", "58997ace5", "bc2140627", "cdb14154b", "e3154aae3", "fe955ebee"]], "identity_text": "Fix failure in logical replication publisher after a database crash and restart (Vignesh C)", "commit_aliases": ["15cac3a52", "20a1dc1e3", "58997ace5", "bc2140627", "cdb14154b", "e3154aae3", "fe955ebee"], "source_commits": ["fe955ebee"], "source_entry_id": "11.7/changes/007", "db_id": "e09e97ef6771dfc7645f23e799878130", "patch_ids": ["f2ffa9572aba4ae2d2a48ee347082cf8"], "statement_hash": "6aa2b325bf72bd1e6c55231d63ce0dc8c7973d98bf84b5311b3b54dc630c7b0b", "relations": [{"rule": 2, "type": "equivalent", "target": "13a4ebbb62f816078b950dca41b5176f", "evidence": {"same_day": true, "patch_ids": ["f2ffa9572aba4ae2d2a48ee347082cf8"], "statement_hash": "6aa2b325bf72bd1e6c55231d63ce0dc8c7973d98bf84b5311b3b54dc630c7b0b"}}, {"rule": 2, "type": "equivalent", "target": "1439b88ee7359150b890bfd4fe23b881", "evidence": {"same_day": true, "patch_ids": ["f2ffa9572aba4ae2d2a48ee347082cf8"], "statement_hash": "6aa2b325bf72bd1e6c55231d63ce0dc8c7973d98bf84b5311b3b54dc630c7b0b"}}, {"rule": 2, "type": "equivalent", "target": "bb33ba157feb3169dd07ff305f37c896", "evidence": {"same_day": true, "patch_ids": ["f2ffa9572aba4ae2d2a48ee347082cf8"], "statement_hash": "6aa2b325bf72bd1e6c55231d63ce0dc8c7973d98bf84b5311b3b54dc630c7b0b"}}, {"rule": 2, "type": "equivalent", "target": "c97e1f22cceb95da773367228c582c34", "evidence": {"same_day": true, "patch_ids": ["f2ffa9572aba4ae2d2a48ee347082cf8"], "statement_hash": "6aa2b325bf72bd1e6c55231d63ce0dc8c7973d98bf84b5311b3b54dc630c7b0b"}}, {"rule": 2, "type": "equivalent", "target": "fb326a72fe79a9793c3b84416b31cf6e", "evidence": {"same_day": true, "patch_ids": ["f2ffa9572aba4ae2d2a48ee347082cf8"], "statement_hash": "6aa2b325bf72bd1e6c55231d63ce0dc8c7973d98bf84b5311b3b54dc630c7b0b"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "fb326a72fe79a9793c3b84416b31cf6e", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Fix failure in logical replication publisher after a database crash and restart", "evidence": {"same_day": true, "patch_ids": ["f2ffa9572aba4ae2d2a48ee347082cf8"], "statement_hash": "6aa2b325bf72bd1e6c55231d63ce0dc8c7973d98bf84b5311b3b54dc630c7b0b"}, "url": "/docs/compare/?release=12.2#12.2-9f094e8e9a48d1df", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "bb33ba157feb3169dd07ff305f37c896", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Fix failure in logical replication publisher after a database crash and restart", "evidence": {"same_day": true, "patch_ids": ["f2ffa9572aba4ae2d2a48ee347082cf8"], "statement_hash": "6aa2b325bf72bd1e6c55231d63ce0dc8c7973d98bf84b5311b3b54dc630c7b0b"}, "url": "/docs/compare/?release=10.12#10.12-6ea1a95af0a90afd", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "13a4ebbb62f816078b950dca41b5176f", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Fix failure in logical replication publisher after a database crash and restart", "evidence": {"same_day": true, "patch_ids": ["f2ffa9572aba4ae2d2a48ee347082cf8"], "statement_hash": "6aa2b325bf72bd1e6c55231d63ce0dc8c7973d98bf84b5311b3b54dc630c7b0b"}, "url": "/docs/compare/?release=9.6.17#9.6.17-6ea1a95af0a90afd", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "1439b88ee7359150b890bfd4fe23b881", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "Fix failure in logical replication publisher after a database crash and restart", "evidence": {"same_day": true, "patch_ids": ["f2ffa9572aba4ae2d2a48ee347082cf8"], "statement_hash": "6aa2b325bf72bd1e6c55231d63ce0dc8c7973d98bf84b5311b3b54dc630c7b0b"}, "url": "/docs/compare/?release=9.5.21#9.5.21-6ea1a95af0a90afd", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "c97e1f22cceb95da773367228c582c34", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "Fix failure in logical replication publisher after a database crash and restart", "evidence": {"same_day": true, "patch_ids": ["f2ffa9572aba4ae2d2a48ee347082cf8"], "statement_hash": "6aa2b325bf72bd1e6c55231d63ce0dc8c7973d98bf84b5311b3b54dc630c7b0b"}, "url": "/docs/compare/?release=9.4.26#9.4.26-6ea1a95af0a90afd", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-7a4437c11703c550", "cves": [], "html": "Ensure that the effect of pg_replication_slot_advance() on a physical replication slot will persist across restarts (Alexey Kondratov, Michael Paquier)
Improve efficiency of logical replication with REPLICA IDENTITY FULL (Konstantin Knizhnik)
When searching for an existing tuple during an update or delete operation, return the first matching tuple not the last one.
", "text": "Improve efficiency of logical replication with REPLICA IDENTITY FULL (Konstantin Knizhnik) When searching for an existing tuple during an update or delete operation, return the first matching tuple not the last one.", "title": "Improve efficiency of logical replication with REPLICA IDENTITY FULL", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "9a73832c49b1872b1b2b565eea06b691d505d6b9b61884f51ffb15e3a59e0d9b", "section_path": ["Changes"], "commit_groups": [["1c7a0b387", "380bc8829", "42e3187a8", "beefab654"]], "identity_text": "Improve efficiency of logical replication with REPLICA IDENTITY FULL (Konstantin Knizhnik) When searching for an existing tuple during an update or delete operation, return the first matching tuple not the last one.", "commit_aliases": ["1c7a0b387", "380bc8829", "42e3187a8", "beefab654"], "source_commits": ["beefab654"], "source_entry_id": "11.7/changes/009", "db_id": "b062535045ec22b512311e35be95aae5", "patch_ids": ["135487e98ef6f87f0569ef8649d6e53f"], "statement_hash": "b803474e060b9ed5d228ebf5b3bb7c6959b5c8a784c3a4f5afd7b53e5f0b4ce7", "relations": [{"rule": 2, "type": "equivalent", "target": "8d791911f4c9d5211e4f465a41a47261", "evidence": {"same_day": true, "patch_ids": ["135487e98ef6f87f0569ef8649d6e53f"], "statement_hash": "b803474e060b9ed5d228ebf5b3bb7c6959b5c8a784c3a4f5afd7b53e5f0b4ce7"}}, {"rule": 2, "type": "equivalent", "target": "b81caab467cb3126b5359e1a1f17e5db", "evidence": {"same_day": true, "patch_ids": ["135487e98ef6f87f0569ef8649d6e53f"], "statement_hash": "b803474e060b9ed5d228ebf5b3bb7c6959b5c8a784c3a4f5afd7b53e5f0b4ce7"}}], "version": "11.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b81caab467cb3126b5359e1a1f17e5db", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Improve efficiency of logical replication with REPLICA IDENTITY FULL", "evidence": {"same_day": true, "patch_ids": ["135487e98ef6f87f0569ef8649d6e53f"], "statement_hash": "b803474e060b9ed5d228ebf5b3bb7c6959b5c8a784c3a4f5afd7b53e5f0b4ce7"}, "url": "/docs/compare/?release=12.2#12.2-31ae7569e72b81ef", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "8d791911f4c9d5211e4f465a41a47261", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Improve efficiency of logical replication with REPLICA IDENTITY FULL", "evidence": {"same_day": true, "patch_ids": ["135487e98ef6f87f0569ef8649d6e53f"], "statement_hash": "b803474e060b9ed5d228ebf5b3bb7c6959b5c8a784c3a4f5afd7b53e5f0b4ce7"}, "url": "/docs/compare/?release=10.12#10.12-fd6916ca2a8ea3bb", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}]}, {"id": "11.7-91bee94b5621e3c4", "cves": [], "html": "Ensure parallel plans are always shut down at the correct time (Kyotaro Horiguchi)
\nThis oversight is known to result in “temporary file leak” warnings from multi-batch parallel hash joins.
", "text": "Ensure parallel plans are always shut down at the correct time (Kyotaro Horiguchi) This oversight is known to result in “temporary file leak” warnings from multi-batch parallel hash joins.", "title": "Ensure parallel plans are always shut down at the correct time", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "930da8ad2058d2f194a2655d34591b2fdd9324486a039a07ba93043801ccc844", "section_path": ["Changes"], "commit_groups": [["24897e1a1", "76cbfcdf3", "bc049d0d4"]], "identity_text": "Ensure parallel plans are always shut down at the correct time (Kyotaro Horiguchi) This oversight is known to result in temporary file leak warnings from multi-batch parallel hash joins.", "commit_aliases": ["24897e1a1", "76cbfcdf3", "bc049d0d4"], "source_commits": ["bc049d0d4"], "source_entry_id": "11.7/changes/010", "db_id": "e836e7423e1e7e9faed54038a493c8e3", "patch_ids": ["c026647abb74adbea1602509fc9c3bfa"], "statement_hash": "39cafd687b4a536c1dbb78a6ab62e8cfc2963fb4a64e317abc76ffa9e4959539", "relations": [{"rule": 2, "type": "equivalent", "target": "14676c0a505af517c82c2084d74d6857", "evidence": {"same_day": true, "patch_ids": ["c026647abb74adbea1602509fc9c3bfa"], "statement_hash": "39cafd687b4a536c1dbb78a6ab62e8cfc2963fb4a64e317abc76ffa9e4959539"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "14676c0a505af517c82c2084d74d6857", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Ensure parallel plans are always shut down at the correct time", "evidence": {"same_day": true, "patch_ids": ["c026647abb74adbea1602509fc9c3bfa"], "statement_hash": "39cafd687b4a536c1dbb78a6ab62e8cfc2963fb4a64e317abc76ffa9e4959539"}, "url": "/docs/compare/?release=12.2#12.2-af6bdc5723615702", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}]}, {"id": "11.7-51a1c6e2be2d2738", "cves": [], "html": "Prevent premature shutdown of a Gather or GatherMerge plan node that is underneath a Limit node (Amit Kapila)
\nThis avoids failure if such a plan node needs to be scanned more than once, as for instance if it is on the inside of a nestloop.
", "text": "Prevent premature shutdown of a Gather or GatherMerge plan node that is underneath a Limit node (Amit Kapila) This avoids failure if such a plan node needs to be scanned more than once, as for instance if it is on the inside of a nestloop.", "title": "Prevent premature shutdown of a Gather or GatherMerge plan node that is underneath a Limit node", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "5044f042baacaa08448d04861de44433908c0c6c273e1764f5099a4ebb38697e", "section_path": ["Changes"], "commit_groups": [["080313f82", "1ad0df67c", "1cc3a90c7", "d0ccfa9d6", "f7ae68aac"]], "identity_text": "Prevent premature shutdown of a Gather or GatherMerge plan node that is underneath a Limit node (Amit Kapila) This avoids failure if such a plan node needs to be scanned more than once, as for instance if it is on the inside of a nestloop.", "commit_aliases": ["080313f82", "1ad0df67c", "1cc3a90c7", "d0ccfa9d6", "f7ae68aac"], "source_commits": ["d0ccfa9d6"], "source_entry_id": "11.7/changes/011", "db_id": "5f88ee03759351364b6139686c2c4363", "patch_ids": ["ae20cbf89e29f4005017f037b249493b"], "statement_hash": "1f92ba2fffc4a678b50d81f64a3f0e9f14dd99adf8edc4996af62aade7874ca6", "relations": [{"rule": 2, "type": "equivalent", "target": "0736925131e2a1aa47c59c632711680f", "evidence": {"same_day": true, "patch_ids": ["ae20cbf89e29f4005017f037b249493b"], "statement_hash": "1f92ba2fffc4a678b50d81f64a3f0e9f14dd99adf8edc4996af62aade7874ca6"}}, {"rule": 2, "type": "equivalent", "target": "3b9453a17ccc702c506c79746e5ba421", "evidence": {"same_day": true, "patch_ids": ["ae20cbf89e29f4005017f037b249493b"], "statement_hash": "1f92ba2fffc4a678b50d81f64a3f0e9f14dd99adf8edc4996af62aade7874ca6"}}, {"rule": 2, "type": "equivalent", "target": "c522b4d56b52473e55baecaf0a9ee541", "evidence": {"same_day": true, "patch_ids": ["ae20cbf89e29f4005017f037b249493b"], "statement_hash": "1f92ba2fffc4a678b50d81f64a3f0e9f14dd99adf8edc4996af62aade7874ca6"}}], "version": "11.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "0736925131e2a1aa47c59c632711680f", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Prevent premature shutdown of a Gather or GatherMerge plan node that is underneath a Limit node", "evidence": {"same_day": true, "patch_ids": ["ae20cbf89e29f4005017f037b249493b"], "statement_hash": "1f92ba2fffc4a678b50d81f64a3f0e9f14dd99adf8edc4996af62aade7874ca6"}, "url": "/docs/compare/?release=12.2#12.2-f220ed06d9d08439", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "c522b4d56b52473e55baecaf0a9ee541", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Prevent premature shutdown of a Gather or GatherMerge plan node that is underneath a Limit node", "evidence": {"same_day": true, "patch_ids": ["ae20cbf89e29f4005017f037b249493b"], "statement_hash": "1f92ba2fffc4a678b50d81f64a3f0e9f14dd99adf8edc4996af62aade7874ca6"}, "url": "/docs/compare/?release=10.12#10.12-51a1c6e2be2d2738", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "3b9453a17ccc702c506c79746e5ba421", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Prevent premature shutdown of a Gather or GatherMerge plan node that is underneath a Limit node", "evidence": {"same_day": true, "patch_ids": ["ae20cbf89e29f4005017f037b249493b"], "statement_hash": "1f92ba2fffc4a678b50d81f64a3f0e9f14dd99adf8edc4996af62aade7874ca6"}, "url": "/docs/compare/?release=9.6.17#9.6.17-51a1c6e2be2d2738", "source_url": "/docs/release/9.6.17/#AEN133104"}]}, {"id": "11.7-463f8cbbe340574d", "cves": [], "html": "Improve efficiency of parallel hash join on CPUs with many cores (Gang Deng, Thomas Munro)
", "text": "Improve efficiency of parallel hash join on CPUs with many cores (Gang Deng, Thomas Munro)", "title": "Improve efficiency of parallel hash join on CPUs with many cores", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "6647b2fb455bbdfde45c7f55687c236013a218da7e8a9e684af497c2ba912e69", "section_path": ["Changes"], "commit_groups": [["3e4818e9d", "6a9fc75d0", "f9d0be241"]], "identity_text": "Improve efficiency of parallel hash join on CPUs with many cores (Gang Deng, Thomas Munro)", "commit_aliases": ["3e4818e9d", "6a9fc75d0", "f9d0be241"], "source_commits": ["6a9fc75d0"], "source_entry_id": "11.7/changes/012", "db_id": "5e0a8ac91766977c842e24df33861fb0", "patch_ids": ["beee1a24b3b1929196681d29657686cb"], "statement_hash": "5f17301d6c93d010a3109e7da91495e04bd633ce0096d031727dfac1ea910227", "relations": [{"rule": 2, "type": "equivalent", "target": "44fe0983425bc51fdfb3952569c11b42", "evidence": {"same_day": true, "patch_ids": ["beee1a24b3b1929196681d29657686cb"], "statement_hash": "5f17301d6c93d010a3109e7da91495e04bd633ce0096d031727dfac1ea910227"}}], "version": "11.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "44fe0983425bc51fdfb3952569c11b42", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Improve efficiency of parallel hash join on CPUs with many cores", "evidence": {"same_day": true, "patch_ids": ["beee1a24b3b1929196681d29657686cb"], "statement_hash": "5f17301d6c93d010a3109e7da91495e04bd633ce0096d031727dfac1ea910227"}, "url": "/docs/compare/?release=12.2#12.2-6481838bcea2fb94", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}]}, {"id": "11.7-81f3425b5690822b", "cves": [], "html": "Avoid crash in parallel CREATE INDEX when there are no free dynamic shared memory slots (Thomas Munro)
Fall back to a non-parallel index build, instead.
", "text": "Avoid crash in parallel CREATE INDEX when there are no free dynamic shared memory slots (Thomas Munro) Fall back to a non-parallel index build, instead.", "title": "Avoid crash in parallel CREATE INDEX when there are no free dynamic shared memory slots", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "89f4db3a19d0fcf2097681d38ddb2424fe429efc48118a2ecaad03ea799fa108", "section_path": ["Changes"], "commit_groups": [["1fcf62e0b", "2c56b3ac4", "74618e77b"], ["2e2351bd6", "c4a2041a4", "d9fe702a2"]], "identity_text": "Avoid crash in parallel CREATE INDEX when there are no free dynamic shared memory slots (Thomas Munro) Fall back to a non-parallel index build, instead.", "commit_aliases": ["1fcf62e0b", "2c56b3ac4", "2e2351bd6", "74618e77b", "c4a2041a4", "d9fe702a2"], "source_commits": ["2c56b3ac4", "c4a2041a4"], "source_entry_id": "11.7/changes/013", "db_id": "11292ee8cf3528f32adac037ce88e99c", "patch_ids": ["b950c23babcd00726596ac0dbd3c6cf9", "f540cac27a88faa64a6abf68f88a6019"], "statement_hash": "6d09ea57ac8d6b6aa919fd7a145a52308b0b766dac820ae3ebdb69d429d142c2", "relations": [{"rule": 2, "type": "equivalent", "target": "ed4e33d69e729b5a44d3503b020a32a1", "evidence": {"same_day": true, "patch_ids": ["b950c23babcd00726596ac0dbd3c6cf9", "f540cac27a88faa64a6abf68f88a6019"], "statement_hash": "6d09ea57ac8d6b6aa919fd7a145a52308b0b766dac820ae3ebdb69d429d142c2"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "ed4e33d69e729b5a44d3503b020a32a1", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Avoid crash in parallel CREATE INDEX when there are no free dynamic shared memory slots", "evidence": {"same_day": true, "patch_ids": ["b950c23babcd00726596ac0dbd3c6cf9", "f540cac27a88faa64a6abf68f88a6019"], "statement_hash": "6d09ea57ac8d6b6aa919fd7a145a52308b0b766dac820ae3ebdb69d429d142c2"}, "url": "/docs/compare/?release=12.2#12.2-fedf629849548cdf", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}]}, {"id": "11.7-ac59a54c3f8f1e33", "cves": [], "html": "Avoid memory leak when there are no free dynamic shared memory slots (Thomas Munro)
", "text": "Avoid memory leak when there are no free dynamic shared memory slots (Thomas Munro)", "title": "Avoid memory leak when there are no free dynamic shared memory slots", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "f1037c30413aa202e95448cccf2b74261a7dd8651f1993cc2aaf649272f76097", "section_path": ["Changes"], "commit_groups": [["24dd34af1", "600387f5d", "93745f1e0", "93be45245", "95936c795", "a5f45c3dd", "aab30cd4e"]], "identity_text": "Avoid memory leak when there are no free dynamic shared memory slots (Thomas Munro)", "commit_aliases": ["24dd34af1", "600387f5d", "93745f1e0", "93be45245", "95936c795", "a5f45c3dd", "aab30cd4e"], "source_commits": ["600387f5d"], "source_entry_id": "11.7/changes/014", "db_id": "2fbc97d14f34ee4610c171e22430c3eb", "patch_ids": ["8afd81caf08066e62fe0151510b70316"], "statement_hash": "d120380ee87a8eb9c6373c3e3dbe226784646299975215e18461754478df75bd", "relations": [{"rule": 2, "type": "equivalent", "target": "28e588ec50dad9c08c90a47528c2384a", "evidence": {"same_day": true, "patch_ids": ["8afd81caf08066e62fe0151510b70316"], "statement_hash": "d120380ee87a8eb9c6373c3e3dbe226784646299975215e18461754478df75bd"}}, {"rule": 2, "type": "equivalent", "target": "5e2f4f77c98c1824485cb030a9acdc86", "evidence": {"same_day": true, "patch_ids": ["8afd81caf08066e62fe0151510b70316"], "statement_hash": "d120380ee87a8eb9c6373c3e3dbe226784646299975215e18461754478df75bd"}}, {"rule": 2, "type": "equivalent", "target": "9030c00e8e7259264942b4fc186c7cff", "evidence": {"same_day": true, "patch_ids": ["8afd81caf08066e62fe0151510b70316"], "statement_hash": "d120380ee87a8eb9c6373c3e3dbe226784646299975215e18461754478df75bd"}}, {"rule": 2, "type": "equivalent", "target": "922f0696cbfcdd119487a61a4b5c3e0f", "evidence": {"same_day": true, "patch_ids": ["8afd81caf08066e62fe0151510b70316"], "statement_hash": "d120380ee87a8eb9c6373c3e3dbe226784646299975215e18461754478df75bd"}}, {"rule": 2, "type": "equivalent", "target": "a9adae9994911ba8a4cfc85bad76adb2", "evidence": {"same_day": true, "patch_ids": ["8afd81caf08066e62fe0151510b70316"], "statement_hash": "d120380ee87a8eb9c6373c3e3dbe226784646299975215e18461754478df75bd"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "9030c00e8e7259264942b4fc186c7cff", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Avoid memory leak when there are no free dynamic shared memory slots", "evidence": {"same_day": true, "patch_ids": ["8afd81caf08066e62fe0151510b70316"], "statement_hash": "d120380ee87a8eb9c6373c3e3dbe226784646299975215e18461754478df75bd"}, "url": "/docs/compare/?release=12.2#12.2-68dbd8d3853a1a9d", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "28e588ec50dad9c08c90a47528c2384a", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Avoid memory leak when there are no free dynamic shared memory slots", "evidence": {"same_day": true, "patch_ids": ["8afd81caf08066e62fe0151510b70316"], "statement_hash": "d120380ee87a8eb9c6373c3e3dbe226784646299975215e18461754478df75bd"}, "url": "/docs/compare/?release=10.12#10.12-ac59a54c3f8f1e33", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "5e2f4f77c98c1824485cb030a9acdc86", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Avoid memory leak when there are no free dynamic shared memory slots", "evidence": {"same_day": true, "patch_ids": ["8afd81caf08066e62fe0151510b70316"], "statement_hash": "d120380ee87a8eb9c6373c3e3dbe226784646299975215e18461754478df75bd"}, "url": "/docs/compare/?release=9.6.17#9.6.17-ac59a54c3f8f1e33", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "922f0696cbfcdd119487a61a4b5c3e0f", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "Avoid memory leak when there are no free dynamic shared memory slots", "evidence": {"same_day": true, "patch_ids": ["8afd81caf08066e62fe0151510b70316"], "statement_hash": "d120380ee87a8eb9c6373c3e3dbe226784646299975215e18461754478df75bd"}, "url": "/docs/compare/?release=9.5.21#9.5.21-ac59a54c3f8f1e33", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "a9adae9994911ba8a4cfc85bad76adb2", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "Avoid memory leak when there are no free dynamic shared memory slots", "evidence": {"same_day": true, "patch_ids": ["8afd81caf08066e62fe0151510b70316"], "statement_hash": "d120380ee87a8eb9c6373c3e3dbe226784646299975215e18461754478df75bd"}, "url": "/docs/compare/?release=9.4.26#9.4.26-ac59a54c3f8f1e33", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-a05621bc579f7f64", "cves": [], "html": "Ignore the CONCURRENTLY option when performing an index creation, drop, or rebuild on a temporary table (Michael Paquier, Heikki Linnakangas, Andres Freund)
This avoids strange failures if the temporary table has an ON COMMIT action. There is no benefit in using CONCURRENTLY for a temporary table anyway, since other sessions cannot access the table, making the extra processing pointless.
Fix possible failure when resetting expression indexes on temporary tables that are marked ON COMMIT DELETE ROWS (Tom Lane)
Fix possible crash in BRIN index operations with box, range and inet data types (Heikki Linnakangas)
Fix handling of deleted pages in GIN indexes (Alexander Korotkov)
\nAvoid possible deadlocks, incorrect updates of a deleted page's state, and failure to traverse through a recently-deleted page.
", "text": "Fix handling of deleted pages in GIN indexes (Alexander Korotkov) Avoid possible deadlocks, incorrect updates of a deleted page's state, and failure to traverse through a recently-deleted page.", "title": "Fix handling of deleted pages in GIN indexes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "d370ba5411edd13ee37c902a0718707541d83c4830bb49ec4243e295f7cfff13", "section_path": ["Changes"], "commit_groups": [["051c50c01", "21ad61ab3", "9f2927989", "e14641197"], ["1414821e1", "4fc485684", "99f5888d3", "ab64b474d", "c0bf35421", "d5ad7a09a", "ee437ca74"], ["4093ff573", "baf487123", "f91706b00"], ["7d467dee0", "a64e7e05a", "b10714080"]], "identity_text": "Fix handling of deleted pages in GIN indexes (Alexander Korotkov) Avoid possible deadlocks, incorrect updates of a deleted page's state, and failure to traverse through a recently-deleted page.", "commit_aliases": ["051c50c01", "1414821e1", "21ad61ab3", "4093ff573", "4fc485684", "7d467dee0", "99f5888d3", "9f2927989", "a64e7e05a", "ab64b474d", "b10714080", "baf487123", "c0bf35421", "d5ad7a09a", "e14641197", "ee437ca74", "f91706b00"], "source_commits": ["7d467dee0", "9f2927989", "c0bf35421", "f91706b00"], "source_entry_id": "11.7/changes/018", "db_id": "baa0df43bab5ee15154867b855376f70", "patch_ids": ["0fb51caa2a6599d8ae03ec723df72516", "2d779b29920a9156df03dacbfed95bdf", "5614389161137ab83fc478bb6dc593c7", "70da9dc7f21eb7c1acbaa8639acbac5e"], "statement_hash": "a4489e08e273e747212a8ae0efaec9bc58505c38caaac21cc5fa44b30e80bb46", "relations": [{"rule": 2, "type": "equivalent", "target": "163a1188a571ecf3210d6a867b91e4d2", "evidence": {"same_day": true, "patch_ids": ["0fb51caa2a6599d8ae03ec723df72516", "2d779b29920a9156df03dacbfed95bdf", "5614389161137ab83fc478bb6dc593c7", "70da9dc7f21eb7c1acbaa8639acbac5e"], "statement_hash": "a4489e08e273e747212a8ae0efaec9bc58505c38caaac21cc5fa44b30e80bb46"}}, {"rule": 2, "type": "equivalent", "target": "1c0ccf06670d2279d01e43d3f63aaab6", "evidence": {"same_day": true, "patch_ids": ["0fb51caa2a6599d8ae03ec723df72516", "2d779b29920a9156df03dacbfed95bdf", "5614389161137ab83fc478bb6dc593c7", "70da9dc7f21eb7c1acbaa8639acbac5e"], "statement_hash": "a4489e08e273e747212a8ae0efaec9bc58505c38caaac21cc5fa44b30e80bb46"}}, {"rule": 2, "type": "equivalent", "target": "382e9c585cfb14f9b1c242bd2db98948", "evidence": {"same_day": true, "patch_ids": ["0fb51caa2a6599d8ae03ec723df72516", "2d779b29920a9156df03dacbfed95bdf", "5614389161137ab83fc478bb6dc593c7", "70da9dc7f21eb7c1acbaa8639acbac5e"], "statement_hash": "a4489e08e273e747212a8ae0efaec9bc58505c38caaac21cc5fa44b30e80bb46"}}, {"rule": 2, "type": "equivalent", "target": "4f986828312e793956423c2975a5b2c8", "evidence": {"same_day": true, "patch_ids": ["0fb51caa2a6599d8ae03ec723df72516", "2d779b29920a9156df03dacbfed95bdf", "5614389161137ab83fc478bb6dc593c7", "70da9dc7f21eb7c1acbaa8639acbac5e"], "statement_hash": "a4489e08e273e747212a8ae0efaec9bc58505c38caaac21cc5fa44b30e80bb46"}}, {"rule": 2, "type": "equivalent", "target": "ba63d0d0210c6a9fd78797edfd452c32", "evidence": {"same_day": true, "patch_ids": ["0fb51caa2a6599d8ae03ec723df72516", "2d779b29920a9156df03dacbfed95bdf", "5614389161137ab83fc478bb6dc593c7", "70da9dc7f21eb7c1acbaa8639acbac5e"], "statement_hash": "a4489e08e273e747212a8ae0efaec9bc58505c38caaac21cc5fa44b30e80bb46"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4f986828312e793956423c2975a5b2c8", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Fix handling of deleted pages in GIN indexes", "evidence": {"same_day": true, "patch_ids": ["0fb51caa2a6599d8ae03ec723df72516", "2d779b29920a9156df03dacbfed95bdf", "5614389161137ab83fc478bb6dc593c7", "70da9dc7f21eb7c1acbaa8639acbac5e"], "statement_hash": "a4489e08e273e747212a8ae0efaec9bc58505c38caaac21cc5fa44b30e80bb46"}, "url": "/docs/compare/?release=12.2#12.2-5be8d704bafc0f2f", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "ba63d0d0210c6a9fd78797edfd452c32", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Fix handling of deleted pages in GIN indexes", "evidence": {"same_day": true, "patch_ids": ["0fb51caa2a6599d8ae03ec723df72516", "2d779b29920a9156df03dacbfed95bdf", "5614389161137ab83fc478bb6dc593c7", "70da9dc7f21eb7c1acbaa8639acbac5e"], "statement_hash": "a4489e08e273e747212a8ae0efaec9bc58505c38caaac21cc5fa44b30e80bb46"}, "url": "/docs/compare/?release=10.12#10.12-bf97d65b1d9a5b40", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "1c0ccf06670d2279d01e43d3f63aaab6", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Fix handling of deleted pages in GIN indexes", "evidence": {"same_day": true, "patch_ids": ["0fb51caa2a6599d8ae03ec723df72516", "2d779b29920a9156df03dacbfed95bdf", "5614389161137ab83fc478bb6dc593c7", "70da9dc7f21eb7c1acbaa8639acbac5e"], "statement_hash": "a4489e08e273e747212a8ae0efaec9bc58505c38caaac21cc5fa44b30e80bb46"}, "url": "/docs/compare/?release=9.6.17#9.6.17-bf97d65b1d9a5b40", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "163a1188a571ecf3210d6a867b91e4d2", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "Fix handling of deleted pages in GIN indexes", "evidence": {"same_day": true, "patch_ids": ["0fb51caa2a6599d8ae03ec723df72516", "2d779b29920a9156df03dacbfed95bdf", "5614389161137ab83fc478bb6dc593c7", "70da9dc7f21eb7c1acbaa8639acbac5e"], "statement_hash": "a4489e08e273e747212a8ae0efaec9bc58505c38caaac21cc5fa44b30e80bb46"}, "url": "/docs/compare/?release=9.5.21#9.5.21-bf97d65b1d9a5b40", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "382e9c585cfb14f9b1c242bd2db98948", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "Fix handling of deleted pages in GIN indexes", "evidence": {"same_day": true, "patch_ids": ["0fb51caa2a6599d8ae03ec723df72516", "2d779b29920a9156df03dacbfed95bdf", "5614389161137ab83fc478bb6dc593c7", "70da9dc7f21eb7c1acbaa8639acbac5e"], "statement_hash": "a4489e08e273e747212a8ae0efaec9bc58505c38caaac21cc5fa44b30e80bb46"}, "url": "/docs/compare/?release=9.4.26#9.4.26-bf97d65b1d9a5b40", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-cca012baa4023431", "cves": [], "html": "Fix possible crash with a SubPlan (sub-SELECT) within a multi-row VALUES list (Tom Lane)
Fix failure to insert default values for “missing” attributes during tuple conversion (Vik Fearing, Andrew Gierth)
\nThis could result in values incorrectly reading as NULL, when they come from columns that had been added by ALTER TABLE ADD COLUMN with a constant default.
Fix crash after FileClose() failure (Noah Misch)
\nThis issue could only be observed with data_sync_retry enabled, since otherwise FileClose() failure would be reported as a PANIC.
Fix unlikely crash with pass-by-reference aggregate transition states (Andres Freund, Teodor Sigaev)
", "text": "Fix unlikely crash with pass-by-reference aggregate transition states (Andres Freund, Teodor Sigaev)", "title": "Fix unlikely crash with pass-by-reference aggregate transition states", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "e3a8cde999f990b67762e4cfa5dc0d1119fd9b7d9fc37ebbf108f0be990593f6", "section_path": ["Changes"], "commit_groups": [["21fdfd0e8", "8bb006a41", "affdde2e1", "ba1dfbe22", "c8e0e560e", "d4c339924", "f651976d9"]], "identity_text": "Fix unlikely crash with pass-by-reference aggregate transition states (Andres Freund, Teodor Sigaev)", "commit_aliases": ["21fdfd0e8", "8bb006a41", "affdde2e1", "ba1dfbe22", "c8e0e560e", "d4c339924", "f651976d9"], "source_commits": ["c8e0e560e"], "source_entry_id": "11.7/changes/022", "db_id": "55eecb13c679c1b456e4f63a0afa50a3", "patch_ids": ["730f997a58a04f63067e9ce63b4b26a6"], "statement_hash": "247ecf8b0f57ea41bff13f5eb478cd6d22e7b98f79a7290a54702aa6470249b2", "relations": [{"rule": 2, "type": "equivalent", "target": "36852c66d198f3d3882a089f2fe0f1b9", "evidence": {"same_day": true, "patch_ids": ["730f997a58a04f63067e9ce63b4b26a6"], "statement_hash": "247ecf8b0f57ea41bff13f5eb478cd6d22e7b98f79a7290a54702aa6470249b2"}}, {"rule": 2, "type": "equivalent", "target": "7bbdbe671f37e7a8f307651f9934bbb5", "evidence": {"same_day": true, "patch_ids": ["730f997a58a04f63067e9ce63b4b26a6"], "statement_hash": "247ecf8b0f57ea41bff13f5eb478cd6d22e7b98f79a7290a54702aa6470249b2"}}, {"rule": 2, "type": "equivalent", "target": "7c398b24a82fde3f229eb10a248b5b97", "evidence": {"same_day": true, "patch_ids": ["730f997a58a04f63067e9ce63b4b26a6"], "statement_hash": "247ecf8b0f57ea41bff13f5eb478cd6d22e7b98f79a7290a54702aa6470249b2"}}, {"rule": 2, "type": "equivalent", "target": "a4516e116251828c608ebe40de67937c", "evidence": {"same_day": true, "patch_ids": ["730f997a58a04f63067e9ce63b4b26a6"], "statement_hash": "247ecf8b0f57ea41bff13f5eb478cd6d22e7b98f79a7290a54702aa6470249b2"}}, {"rule": 2, "type": "equivalent", "target": "aa38fe8a84a05ccb7d5ca2231a4a9ab2", "evidence": {"same_day": true, "patch_ids": ["730f997a58a04f63067e9ce63b4b26a6"], "statement_hash": "247ecf8b0f57ea41bff13f5eb478cd6d22e7b98f79a7290a54702aa6470249b2"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "7c398b24a82fde3f229eb10a248b5b97", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Fix unlikely crash with pass-by-reference aggregate transition states", "evidence": {"same_day": true, "patch_ids": ["730f997a58a04f63067e9ce63b4b26a6"], "statement_hash": "247ecf8b0f57ea41bff13f5eb478cd6d22e7b98f79a7290a54702aa6470249b2"}, "url": "/docs/compare/?release=12.2#12.2-30062929998dd8f5", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "7bbdbe671f37e7a8f307651f9934bbb5", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Fix unlikely crash with pass-by-reference aggregate transition states", "evidence": {"same_day": true, "patch_ids": ["730f997a58a04f63067e9ce63b4b26a6"], "statement_hash": "247ecf8b0f57ea41bff13f5eb478cd6d22e7b98f79a7290a54702aa6470249b2"}, "url": "/docs/compare/?release=10.12#10.12-4f2fb991fc6467c2", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "aa38fe8a84a05ccb7d5ca2231a4a9ab2", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Fix unlikely crash with pass-by-reference aggregate transition states", "evidence": {"same_day": true, "patch_ids": ["730f997a58a04f63067e9ce63b4b26a6"], "statement_hash": "247ecf8b0f57ea41bff13f5eb478cd6d22e7b98f79a7290a54702aa6470249b2"}, "url": "/docs/compare/?release=9.6.17#9.6.17-4f2fb991fc6467c2", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "a4516e116251828c608ebe40de67937c", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "Fix unlikely crash with pass-by-reference aggregate transition states", "evidence": {"same_day": true, "patch_ids": ["730f997a58a04f63067e9ce63b4b26a6"], "statement_hash": "247ecf8b0f57ea41bff13f5eb478cd6d22e7b98f79a7290a54702aa6470249b2"}, "url": "/docs/compare/?release=9.5.21#9.5.21-4f2fb991fc6467c2", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "36852c66d198f3d3882a089f2fe0f1b9", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "Fix unlikely crash with pass-by-reference aggregate transition states", "evidence": {"same_day": true, "patch_ids": ["730f997a58a04f63067e9ce63b4b26a6"], "statement_hash": "247ecf8b0f57ea41bff13f5eb478cd6d22e7b98f79a7290a54702aa6470249b2"}, "url": "/docs/compare/?release=9.4.26#9.4.26-4f2fb991fc6467c2", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-a3490fc12e8c889a", "cves": [], "html": "Improve error reporting in to_date() and to_timestamp() (Tom Lane, Álvaro Herrera)
Reports about incorrect month or day names in input strings could truncate the input in the middle of a multi-byte character, leading to an improperly encoded error message that could cause follow-on failures. Truncate at the next whitespace instead.
", "text": "Improve error reporting in to_date() and to_timestamp() (Tom Lane, Álvaro Herrera) Reports about incorrect month or day names in input strings could truncate the input in the middle of a multi-byte character, leading to an improperly encoded error message that could cause follow-on failures. Truncate at the next whitespace instead.", "title": "Improve error reporting in to_date() and to_timestamp()", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "b8e9685b7e0be50a64fe8219ed7bf855fea6068a7c7987125824976a871f1543", "section_path": ["Changes"], "commit_groups": [["0e63d9641", "451f50813", "7a9fef299", "8fc33e6cc", "9a3a75cb8", "d6a9548b2", "f309c812e"], ["212b870d6", "4c70098ff", "600b953d7", "9e24575f6", "a576f2a8f", "be13f227f", "fb12aefaa"]], "identity_text": "Improve error reporting in to_date() and to_timestamp() (Tom Lane, Álvaro Herrera) Reports about incorrect month or day names in input strings could truncate the input in the middle of a multi-byte character, leading to an improperly encoded error message that could cause follow-on failures. Truncate at the next whitespace instead.", "commit_aliases": ["0e63d9641", "212b870d6", "451f50813", "4c70098ff", "600b953d7", "7a9fef299", "8fc33e6cc", "9a3a75cb8", "9e24575f6", "a576f2a8f", "be13f227f", "d6a9548b2", "f309c812e", "fb12aefaa"], "source_commits": ["7a9fef299", "fb12aefaa"], "source_entry_id": "11.7/changes/023", "db_id": "70492e26779a8a1656d44ae93b8feaa6", "patch_ids": ["881a4ad4e73e5bd4a9e5a289b084a789", "b3676034f161a2b8e0f55f02dbf6ca1d"], "statement_hash": "9e20b30958a588fb9e31c02ef288f2ed5e1df59831e7e09f29ac2a8de8f66856", "relations": [{"rule": 2, "type": "equivalent", "target": "2e88f289c1234dc88f881d954d466e4a", "evidence": {"same_day": true, "patch_ids": ["881a4ad4e73e5bd4a9e5a289b084a789", "b3676034f161a2b8e0f55f02dbf6ca1d"], "statement_hash": "9e20b30958a588fb9e31c02ef288f2ed5e1df59831e7e09f29ac2a8de8f66856"}}, {"rule": 2, "type": "equivalent", "target": "39630b7768bb1c46d4b6752581ccf6ce", "evidence": {"same_day": true, "patch_ids": ["881a4ad4e73e5bd4a9e5a289b084a789", "b3676034f161a2b8e0f55f02dbf6ca1d"], "statement_hash": "9e20b30958a588fb9e31c02ef288f2ed5e1df59831e7e09f29ac2a8de8f66856"}}, {"rule": 2, "type": "equivalent", "target": "ba9b3b2bf6101c85ca968cf1bc4c2a39", "evidence": {"same_day": true, "patch_ids": ["881a4ad4e73e5bd4a9e5a289b084a789", "b3676034f161a2b8e0f55f02dbf6ca1d"], "statement_hash": "9e20b30958a588fb9e31c02ef288f2ed5e1df59831e7e09f29ac2a8de8f66856"}}, {"rule": 2, "type": "equivalent", "target": "cdbf4f801b3c350a10257de0582a1372", "evidence": {"same_day": true, "patch_ids": ["881a4ad4e73e5bd4a9e5a289b084a789", "b3676034f161a2b8e0f55f02dbf6ca1d"], "statement_hash": "9e20b30958a588fb9e31c02ef288f2ed5e1df59831e7e09f29ac2a8de8f66856"}}, {"rule": 2, "type": "equivalent", "target": "e5a881c43afb38e00e461fd4d589dc16", "evidence": {"same_day": true, "patch_ids": ["881a4ad4e73e5bd4a9e5a289b084a789", "b3676034f161a2b8e0f55f02dbf6ca1d"], "statement_hash": "9e20b30958a588fb9e31c02ef288f2ed5e1df59831e7e09f29ac2a8de8f66856"}}], "version": "11.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "2e88f289c1234dc88f881d954d466e4a", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Improve error reporting in to_date() and to_timestamp()", "evidence": {"same_day": true, "patch_ids": ["881a4ad4e73e5bd4a9e5a289b084a789", "b3676034f161a2b8e0f55f02dbf6ca1d"], "statement_hash": "9e20b30958a588fb9e31c02ef288f2ed5e1df59831e7e09f29ac2a8de8f66856"}, "url": "/docs/compare/?release=12.2#12.2-0bc48a9f176e3069", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "cdbf4f801b3c350a10257de0582a1372", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Improve error reporting in to_date() and to_timestamp()", "evidence": {"same_day": true, "patch_ids": ["881a4ad4e73e5bd4a9e5a289b084a789", "b3676034f161a2b8e0f55f02dbf6ca1d"], "statement_hash": "9e20b30958a588fb9e31c02ef288f2ed5e1df59831e7e09f29ac2a8de8f66856"}, "url": "/docs/compare/?release=10.12#10.12-a3490fc12e8c889a", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "ba9b3b2bf6101c85ca968cf1bc4c2a39", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Improve error reporting in to_date() and to_timestamp()", "evidence": {"same_day": true, "patch_ids": ["881a4ad4e73e5bd4a9e5a289b084a789", "b3676034f161a2b8e0f55f02dbf6ca1d"], "statement_hash": "9e20b30958a588fb9e31c02ef288f2ed5e1df59831e7e09f29ac2a8de8f66856"}, "url": "/docs/compare/?release=9.6.17#9.6.17-a3490fc12e8c889a", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "39630b7768bb1c46d4b6752581ccf6ce", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "Improve error reporting in to_date() and to_timestamp()", "evidence": {"same_day": true, "patch_ids": ["881a4ad4e73e5bd4a9e5a289b084a789", "b3676034f161a2b8e0f55f02dbf6ca1d"], "statement_hash": "9e20b30958a588fb9e31c02ef288f2ed5e1df59831e7e09f29ac2a8de8f66856"}, "url": "/docs/compare/?release=9.5.21#9.5.21-a3490fc12e8c889a", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "e5a881c43afb38e00e461fd4d589dc16", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "Improve error reporting in to_date() and to_timestamp()", "evidence": {"same_day": true, "patch_ids": ["881a4ad4e73e5bd4a9e5a289b084a789", "b3676034f161a2b8e0f55f02dbf6ca1d"], "statement_hash": "9e20b30958a588fb9e31c02ef288f2ed5e1df59831e7e09f29ac2a8de8f66856"}, "url": "/docs/compare/?release=9.4.26#9.4.26-a3490fc12e8c889a", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-b1e4398e3e3a18bf", "cves": [], "html": "Fix off-by-one result for EXTRACT(ISOYEAR FROM for BC dates (Tom Lane)timestamp)
Avoid stack overflow in information_schema views when a self-referential view exists in the system catalogs (Tom Lane)
A self-referential view can't work; it will always result in infinite recursion. We handled that situation correctly when trying to execute the view, but not when inquiring whether it is automatically updatable.
", "text": "Avoid stack overflow in information_schema views when a self-referential view exists in the system catalogs (Tom Lane) A self-referential view can't work; it will always result in infinite recursion. We handled that situation correctly when trying to execute the view, but not when inquiring whether it is automatically updatable.", "title": "Avoid stack overflow in information_schema views when a self-referential view exists in the system catalogs", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "4137c5b7625f4d5cc1e46b9daf3d378bd89d98b5eaeef8698089eddba7d7b424", "section_path": ["Changes"], "commit_groups": [["4a0aab14d", "5186f7625", "52434ba73", "669138ebd", "b9f3d7a53", "bcd541897", "f09829017"]], "identity_text": "Avoid stack overflow in information_schema views when a self-referential view exists in the system catalogs (Tom Lane) A self-referential view can't work; it will always result in infinite recursion. We handled that situation correctly when trying to execute the view, but not when inquiring whether it is automatically updatable.", "commit_aliases": ["4a0aab14d", "5186f7625", "52434ba73", "669138ebd", "b9f3d7a53", "bcd541897", "f09829017"], "source_commits": ["669138ebd"], "source_entry_id": "11.7/changes/025", "db_id": "e552e8dba5a3299576dfb60b582319bc", "patch_ids": ["ee445a89d96850907b66829bdd2041c7"], "statement_hash": "d38af59ef3e029aa8eb8934c03824ef4b851b43bc0892f344b143600ae7807ce", "relations": [{"rule": 2, "type": "equivalent", "target": "1b330957449f4b21da4a1725df3776af", "evidence": {"same_day": true, "patch_ids": ["ee445a89d96850907b66829bdd2041c7"], "statement_hash": "d38af59ef3e029aa8eb8934c03824ef4b851b43bc0892f344b143600ae7807ce"}}, {"rule": 2, "type": "equivalent", "target": "4c60a3ca30b315e9f22ac913e2ce2d4b", "evidence": {"same_day": true, "patch_ids": ["ee445a89d96850907b66829bdd2041c7"], "statement_hash": "d38af59ef3e029aa8eb8934c03824ef4b851b43bc0892f344b143600ae7807ce"}}, {"rule": 2, "type": "equivalent", "target": "acf1d52fad98389a471114b8df0c0fdc", "evidence": {"same_day": true, "patch_ids": ["ee445a89d96850907b66829bdd2041c7"], "statement_hash": "d38af59ef3e029aa8eb8934c03824ef4b851b43bc0892f344b143600ae7807ce"}}, {"rule": 2, "type": "equivalent", "target": "b491675de114029fc48083e9392427fe", "evidence": {"same_day": true, "patch_ids": ["ee445a89d96850907b66829bdd2041c7"], "statement_hash": "d38af59ef3e029aa8eb8934c03824ef4b851b43bc0892f344b143600ae7807ce"}}, {"rule": 2, "type": "equivalent", "target": "b933e5d77c8aa2e81fd04399a0e55040", "evidence": {"same_day": true, "patch_ids": ["ee445a89d96850907b66829bdd2041c7"], "statement_hash": "d38af59ef3e029aa8eb8934c03824ef4b851b43bc0892f344b143600ae7807ce"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "acf1d52fad98389a471114b8df0c0fdc", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Avoid stack overflow in information_schema views when a self-referential view exists in the system catalogs", "evidence": {"same_day": true, "patch_ids": ["ee445a89d96850907b66829bdd2041c7"], "statement_hash": "d38af59ef3e029aa8eb8934c03824ef4b851b43bc0892f344b143600ae7807ce"}, "url": "/docs/compare/?release=12.2#12.2-78335de878eb3d78", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "b491675de114029fc48083e9392427fe", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Avoid stack overflow in information_schema views when a self-referential view exists in the system catalogs", "evidence": {"same_day": true, "patch_ids": ["ee445a89d96850907b66829bdd2041c7"], "statement_hash": "d38af59ef3e029aa8eb8934c03824ef4b851b43bc0892f344b143600ae7807ce"}, "url": "/docs/compare/?release=10.12#10.12-6aaadabb2026b4f3", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "1b330957449f4b21da4a1725df3776af", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Avoid stack overflow in information_schema views when a self-referential view exists in the system catalogs", "evidence": {"same_day": true, "patch_ids": ["ee445a89d96850907b66829bdd2041c7"], "statement_hash": "d38af59ef3e029aa8eb8934c03824ef4b851b43bc0892f344b143600ae7807ce"}, "url": "/docs/compare/?release=9.6.17#9.6.17-6aaadabb2026b4f3", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "b933e5d77c8aa2e81fd04399a0e55040", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "Avoid stack overflow in information_schema views when a self-referential view exists in the system catalogs", "evidence": {"same_day": true, "patch_ids": ["ee445a89d96850907b66829bdd2041c7"], "statement_hash": "d38af59ef3e029aa8eb8934c03824ef4b851b43bc0892f344b143600ae7807ce"}, "url": "/docs/compare/?release=9.5.21#9.5.21-6aaadabb2026b4f3", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "4c60a3ca30b315e9f22ac913e2ce2d4b", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "Avoid stack overflow in information_schema views when a self-referential view exists in the system catalogs", "evidence": {"same_day": true, "patch_ids": ["ee445a89d96850907b66829bdd2041c7"], "statement_hash": "d38af59ef3e029aa8eb8934c03824ef4b851b43bc0892f344b143600ae7807ce"}, "url": "/docs/compare/?release=9.4.26#9.4.26-6aaadabb2026b4f3", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-c52ccd4440ec9dbf", "cves": [], "html": "Ensure that walsender processes always show NULL for transaction start time in pg_stat_activity (Álvaro Herrera)
Previously, the xact_start column would sometimes show the process start time.
Improve performance of hash joins with very large inner relations (Thomas Munro)
", "text": "Improve performance of hash joins with very large inner relations (Thomas Munro)", "title": "Improve performance of hash joins with very large inner relations", "commits": [], "section": "Changes", "category": "performance", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "ea9c247303cf1e473b9f46057f918da380615d1a49456fcadda768eaa113d832", "section_path": ["Changes"], "commit_groups": [["15861deb6", "5c0a132cf", "8052aaf52", "893eaf0be", "8e89bc6df", "9e551a14c", "e69d64454"]], "identity_text": "Improve performance of hash joins with very large inner relations (Thomas Munro)", "commit_aliases": ["15861deb6", "5c0a132cf", "8052aaf52", "893eaf0be", "8e89bc6df", "9e551a14c", "e69d64454"], "source_commits": ["9e551a14c"], "source_entry_id": "11.7/changes/027", "db_id": "d2e309cdc378e915039257fd8823d0bf", "patch_ids": ["4fd40ea9c8ea4eadf6c96b64d56d3642"], "statement_hash": "2df267ae22df679eccfb91c9e704ed41b727a5277b344abfcc0fa5ca790fe3bd", "relations": [{"rule": 2, "type": "equivalent", "target": "0895ef11a5e64d19ab1da8f1b5310d96", "evidence": {"same_day": true, "patch_ids": ["4fd40ea9c8ea4eadf6c96b64d56d3642"], "statement_hash": "2df267ae22df679eccfb91c9e704ed41b727a5277b344abfcc0fa5ca790fe3bd"}}, {"rule": 2, "type": "equivalent", "target": "116f6d8659176bcd964a41e0209aedea", "evidence": {"same_day": true, "patch_ids": ["4fd40ea9c8ea4eadf6c96b64d56d3642"], "statement_hash": "2df267ae22df679eccfb91c9e704ed41b727a5277b344abfcc0fa5ca790fe3bd"}}, {"rule": 2, "type": "equivalent", "target": "17ab53f94dcefd2c93fabf044fcac49e", "evidence": {"same_day": true, "patch_ids": ["4fd40ea9c8ea4eadf6c96b64d56d3642"], "statement_hash": "2df267ae22df679eccfb91c9e704ed41b727a5277b344abfcc0fa5ca790fe3bd"}}, {"rule": 2, "type": "equivalent", "target": "470ba833faa3f091a2c921a50dcf0786", "evidence": {"same_day": true, "patch_ids": ["4fd40ea9c8ea4eadf6c96b64d56d3642"], "statement_hash": "2df267ae22df679eccfb91c9e704ed41b727a5277b344abfcc0fa5ca790fe3bd"}}, {"rule": 2, "type": "equivalent", "target": "b3cb781746ac72afd92d36eb4d30e449", "evidence": {"same_day": true, "patch_ids": ["4fd40ea9c8ea4eadf6c96b64d56d3642"], "statement_hash": "2df267ae22df679eccfb91c9e704ed41b727a5277b344abfcc0fa5ca790fe3bd"}}], "version": "11.7", "category_label": "Performance", "also_in": [], "variants": [], "related_changes": [{"db_id": "17ab53f94dcefd2c93fabf044fcac49e", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Improve performance of hash joins with very large inner relations", "evidence": {"same_day": true, "patch_ids": ["4fd40ea9c8ea4eadf6c96b64d56d3642"], "statement_hash": "2df267ae22df679eccfb91c9e704ed41b727a5277b344abfcc0fa5ca790fe3bd"}, "url": "/docs/compare/?release=12.2#12.2-fd4ec8b7ca5e3534", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "116f6d8659176bcd964a41e0209aedea", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Improve performance of hash joins with very large inner relations", "evidence": {"same_day": true, "patch_ids": ["4fd40ea9c8ea4eadf6c96b64d56d3642"], "statement_hash": "2df267ae22df679eccfb91c9e704ed41b727a5277b344abfcc0fa5ca790fe3bd"}, "url": "/docs/compare/?release=10.12#10.12-3d3ac8ff7ffdc9ac", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "b3cb781746ac72afd92d36eb4d30e449", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Improve performance of hash joins with very large inner relations", "evidence": {"same_day": true, "patch_ids": ["4fd40ea9c8ea4eadf6c96b64d56d3642"], "statement_hash": "2df267ae22df679eccfb91c9e704ed41b727a5277b344abfcc0fa5ca790fe3bd"}, "url": "/docs/compare/?release=9.6.17#9.6.17-3d3ac8ff7ffdc9ac", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "470ba833faa3f091a2c921a50dcf0786", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "Improve performance of hash joins with very large inner relations", "evidence": {"same_day": true, "patch_ids": ["4fd40ea9c8ea4eadf6c96b64d56d3642"], "statement_hash": "2df267ae22df679eccfb91c9e704ed41b727a5277b344abfcc0fa5ca790fe3bd"}, "url": "/docs/compare/?release=9.5.21#9.5.21-3d3ac8ff7ffdc9ac", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "0895ef11a5e64d19ab1da8f1b5310d96", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "Improve performance of hash joins with very large inner relations", "evidence": {"same_day": true, "patch_ids": ["4fd40ea9c8ea4eadf6c96b64d56d3642"], "statement_hash": "2df267ae22df679eccfb91c9e704ed41b727a5277b344abfcc0fa5ca790fe3bd"}, "url": "/docs/compare/?release=9.4.26#9.4.26-3d3ac8ff7ffdc9ac", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-fb4126233c0f4e7c", "cves": [], "html": "Fix placement of “Subplans Removed” field in EXPLAIN output (Daniel Gustafsson, Tom Lane)
In non-text output formats, this field was emitted inside the “Plans” sub-group, resulting in syntactically invalid output. Attach it to the parent Append or MergeAppend plan node as intended. This causes the field to change position in text output format too: if there are any InitPlans attached to the same plan node, “Subplans Removed” will now appear before those.
", "text": "Fix placement of “Subplans Removed” field in EXPLAIN output (Daniel Gustafsson, Tom Lane) In non-text output formats, this field was emitted inside the “Plans” sub-group, resulting in syntactically invalid output. Attach it to the parent Append or MergeAppend plan node as intended. This causes the field to change position in text output format too: if there are any InitPlans attached to the same plan node, “Subplans Removed” will now appear before those.", "title": "Fix placement of “Subplans Removed” field in EXPLAIN output", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "74a42be95fa121eebcde932962a77670d435ee04b8bf7294f82fd97ee59607f4", "section_path": ["Changes"], "commit_groups": [["7d91b604d", "842a23efa", "9a85860e1"]], "identity_text": "Fix placement of Subplans Removed field in EXPLAIN output (Daniel Gustafsson, Tom Lane) In non-text output formats, this field was emitted inside the Plans sub-group, resulting in syntactically invalid output. Attach it to the parent Append or MergeAppend plan node as intended. This causes the field to change position in text output format too: if there are any InitPlans attached to the same plan node, Subplans Removed will now appear before those.", "commit_aliases": ["7d91b604d", "842a23efa", "9a85860e1"], "source_commits": ["842a23efa"], "source_entry_id": "11.7/changes/028", "db_id": "7cf06c475ec341605c50f158ab1a715f", "patch_ids": ["58061b8f985d096b982fa4ceb05c0ab6"], "statement_hash": "856f7d91f834ce928ceecd171551c51861617b17913bad4fb549339510a7917c", "relations": [{"rule": 2, "type": "equivalent", "target": "d7fe7d8f42ced7d0a415580180c7d395", "evidence": {"same_day": true, "patch_ids": ["58061b8f985d096b982fa4ceb05c0ab6"], "statement_hash": "856f7d91f834ce928ceecd171551c51861617b17913bad4fb549339510a7917c"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "d7fe7d8f42ced7d0a415580180c7d395", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Fix placement of “Subplans Removed” field in EXPLAIN output", "evidence": {"same_day": true, "patch_ids": ["58061b8f985d096b982fa4ceb05c0ab6"], "statement_hash": "856f7d91f834ce928ceecd171551c51861617b17913bad4fb549339510a7917c"}, "url": "/docs/compare/?release=12.2#12.2-1880ff83964f45c1", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}]}, {"id": "11.7-c89489fc8ef0fdca", "cves": ["CVE-2017-7484"], "html": "Allow the planner to apply potentially-leaky tests to child-table statistics, if the user can read the corresponding column of the table that's actually named in the query (Dilip Kumar, Amit Langote)
\nThis change fixes a performance problem for partitioned tables that was created by the fix for CVE-2017-7484. That security fix disallowed applying leaky operators to statistics for columns that the current user doesn't have permission to read directly. However, it's somewhat common to grant permissions only on the parent partitioned table and not bother to do so on individual partitions. In such cases, the user can read the column via the parent, so there's no point in this security restriction; it only results in poorer planner estimates than necessary.
", "text": "Allow the planner to apply potentially-leaky tests to child-table statistics, if the user can read the corresponding column of the table that's actually named in the query (Dilip Kumar, Amit Langote) This change fixes a performance problem for partitioned tables that was created by the fix for CVE-2017-7484. That security fix disallowed applying leaky operators to statistics for columns that the current user doesn't have permission to read directly. However, it's somewhat common to grant permissions only on the parent partitioned table and not bother to do so on individual partitions. In such cases, the user can read the column via the parent, so there's no point in this security restriction; it only results in poorer planner estimates than necessary.", "title": "Allow the planner to apply potentially-leaky tests to child-table statistics, if the user can read the corresponding column of the table that's actually named in the query", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "67a88ba71e3092d540b79bf01d5fa7b89b3bc07d9721ec85e0f37ce886386f7d", "section_path": ["Changes"], "commit_groups": [["1d9056f56", "21a4edd12", "553d2ec27"]], "identity_text": "Allow the planner to apply potentially-leaky tests to child-table statistics, if the user can read the corresponding column of the table that's actually named in the query (Dilip Kumar, Amit Langote) This change fixes a performance problem for partitioned tables that was created by the fix for CVE-2017-7484. That security fix disallowed applying leaky operators to statistics for columns that the current user doesn't have permission to read directly. However, it's somewhat common to grant permissions only on the parent partitioned table and not bother to do so on individual partitions. In such cases, the user can read the column via the parent, so there's no point in this security restriction; it only results in poorer planner estimates than necessary.", "commit_aliases": ["1d9056f56", "21a4edd12", "553d2ec27"], "source_commits": ["1d9056f56"], "source_entry_id": "11.7/changes/029", "db_id": "a90b57abd6e848cb7abf46b553248794", "patch_ids": ["72dcc06904ac46655bb87ff0354be463"], "statement_hash": "822c7fc5021c979a7f65bd9806d3e9c6b5971a1f5404a48d6b9b2c82a7d1e00c", "relations": [{"rule": 2, "type": "equivalent", "target": "820f3a9747b516cee727dbff0c4ed14a", "evidence": {"same_day": true, "patch_ids": ["72dcc06904ac46655bb87ff0354be463"], "statement_hash": "822c7fc5021c979a7f65bd9806d3e9c6b5971a1f5404a48d6b9b2c82a7d1e00c"}}], "version": "11.7", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "820f3a9747b516cee727dbff0c4ed14a", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Allow the planner to apply potentially-leaky tests to child-table statistics, if the user can read the corresponding column of the table that's actually named in the query", "evidence": {"same_day": true, "patch_ids": ["72dcc06904ac46655bb87ff0354be463"], "statement_hash": "822c7fc5021c979a7f65bd9806d3e9c6b5971a1f5404a48d6b9b2c82a7d1e00c"}, "url": "/docs/compare/?release=12.2#12.2-f4fac18590db9602", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}]}, {"id": "11.7-849ac04e5e57a7e0", "cves": [], "html": "Fix edge-case crashes and misestimations in selectivity calculations for the <@ and @> range operators (Michael Paquier, Andrey Borodin, Tom Lane)
Ignore system columns when applying most-common-value extended statistics (Tomas Vondra)
\nThis prevents “negative bitmapset member not allowed” planner errors for affected queries.
", "text": "Ignore system columns when applying most-common-value extended statistics (Tomas Vondra) This prevents “negative bitmapset member not allowed” planner errors for affected queries.", "title": "Ignore system columns when applying most-common-value extended statistics", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "87012089358e25f204d095d95f2c24baeb331366391b25fc32aedd4cdc61f232", "section_path": ["Changes"], "commit_groups": [["0b0f281cc", "25a9ff6ca", "28555a53c", "d482f7f86"]], "identity_text": "Ignore system columns when applying most-common-value extended statistics (Tomas Vondra) This prevents negative bitmapset member not allowed planner errors for affected queries.", "commit_aliases": ["0b0f281cc", "25a9ff6ca", "28555a53c", "d482f7f86"], "source_commits": ["25a9ff6ca"], "source_entry_id": "11.7/changes/031", "db_id": "235115ab672a975158cc7ccb26062c74", "patch_ids": ["96ba8ca9610f2287c238750ebccdcf94"], "statement_hash": "dd36733b043482c1c6f1c8fb0bb1d59651a07d217d31929e0f18ea878d2f6180", "relations": [{"rule": 2, "type": "equivalent", "target": "311335e3704bad4579466f89d6d853f2", "evidence": {"same_day": true, "patch_ids": ["96ba8ca9610f2287c238750ebccdcf94"], "statement_hash": "dd36733b043482c1c6f1c8fb0bb1d59651a07d217d31929e0f18ea878d2f6180"}}, {"rule": 2, "type": "equivalent", "target": "805234959af205982439a5d05728244c", "evidence": {"same_day": true, "patch_ids": ["96ba8ca9610f2287c238750ebccdcf94"], "statement_hash": "dd36733b043482c1c6f1c8fb0bb1d59651a07d217d31929e0f18ea878d2f6180"}}], "version": "11.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "311335e3704bad4579466f89d6d853f2", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Ignore system columns when applying most-common-value extended statistics", "evidence": {"same_day": true, "patch_ids": ["96ba8ca9610f2287c238750ebccdcf94"], "statement_hash": "dd36733b043482c1c6f1c8fb0bb1d59651a07d217d31929e0f18ea878d2f6180"}, "url": "/docs/compare/?release=12.2#12.2-cc69a791fb8db83f", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "805234959af205982439a5d05728244c", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Ignore system columns when applying most-common-value extended statistics", "evidence": {"same_day": true, "patch_ids": ["96ba8ca9610f2287c238750ebccdcf94"], "statement_hash": "dd36733b043482c1c6f1c8fb0bb1d59651a07d217d31929e0f18ea878d2f6180"}, "url": "/docs/compare/?release=10.12#10.12-2b2ed75e96be4392", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}]}, {"id": "11.7-a08ac5b8376ee08f", "cves": [], "html": "Fix BRIN index logic to support hypothetical BRIN indexes (Julien Rouhaud, Heikki Linnakangas)
\nPreviously, if an “index adviser” extension tried to get the planner to produce a plan involving a hypothetical BRIN index, that would fail, because the BRIN cost estimation code would always try to physically access the index's metapage. Now it checks to see if the index is only hypothetical, and uses default assumptions about the index parameters if so.
", "text": "Fix BRIN index logic to support hypothetical BRIN indexes (Julien Rouhaud, Heikki Linnakangas) Previously, if an “index adviser” extension tried to get the planner to produce a plan involving a hypothetical BRIN index, that would fail, because the BRIN cost estimation code would always try to physically access the index's metapage. Now it checks to see if the index is only hypothetical, and uses default assumptions about the index parameters if so.", "title": "Fix BRIN index logic to support hypothetical BRIN indexes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "6c5b2aa89a4ff473ded4b3eb24ff4aaf8c5f4f6d845c3dabe6262456b2aa09b5", "section_path": ["Changes"], "commit_groups": [["168d20640", "62074a343", "c644407f7", "f4095026c"]], "identity_text": "Fix BRIN index logic to support hypothetical BRIN indexes (Julien Rouhaud, Heikki Linnakangas) Previously, if an index adviser extension tried to get the planner to produce a plan involving a hypothetical BRIN index, that would fail, because the BRIN cost estimation code would always try to physically access the index's metapage. Now it checks to see if the index is only hypothetical, and uses default assumptions about the index parameters if so.", "commit_aliases": ["168d20640", "62074a343", "c644407f7", "f4095026c"], "source_commits": ["62074a343"], "source_entry_id": "11.7/changes/032", "db_id": "0a655a806d574bb157d2a23dd9e014d8", "patch_ids": ["d68b8299e26a21beb1f0b6f1660d8f41"], "statement_hash": "733794d623b8e62fe8ccde27abeccdf154aa1c36bb05570031707b6c88e6b8fc", "relations": [{"rule": 2, "type": "equivalent", "target": "52d26431ac43d35d4d3d2d3c78c293e0", "evidence": {"same_day": true, "patch_ids": ["d68b8299e26a21beb1f0b6f1660d8f41"], "statement_hash": "733794d623b8e62fe8ccde27abeccdf154aa1c36bb05570031707b6c88e6b8fc"}}, {"rule": 2, "type": "equivalent", "target": "c87bd5538dcf9e870ce22e2343d59c39", "evidence": {"same_day": true, "patch_ids": ["d68b8299e26a21beb1f0b6f1660d8f41"], "statement_hash": "733794d623b8e62fe8ccde27abeccdf154aa1c36bb05570031707b6c88e6b8fc"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "52d26431ac43d35d4d3d2d3c78c293e0", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Fix BRIN index logic to support hypothetical BRIN indexes", "evidence": {"same_day": true, "patch_ids": ["d68b8299e26a21beb1f0b6f1660d8f41"], "statement_hash": "733794d623b8e62fe8ccde27abeccdf154aa1c36bb05570031707b6c88e6b8fc"}, "url": "/docs/compare/?release=12.2#12.2-a7e0f193bc30c70e", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "c87bd5538dcf9e870ce22e2343d59c39", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Fix BRIN index logic to support hypothetical BRIN indexes", "evidence": {"same_day": true, "patch_ids": ["d68b8299e26a21beb1f0b6f1660d8f41"], "statement_hash": "733794d623b8e62fe8ccde27abeccdf154aa1c36bb05570031707b6c88e6b8fc"}, "url": "/docs/compare/?release=10.12#10.12-a08ac5b8376ee08f", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}]}, {"id": "11.7-6c94c2e3e06c2e5f", "cves": [], "html": "Improve error reporting for attempts to use automatic updating of views with conditional INSTEAD rules (Dean Rasheed)
This has never been supported, but previously the error was thrown only at execution time, so that it could be masked by planner errors.
", "text": "Improve error reporting for attempts to use automatic updating of views with conditional INSTEAD rules (Dean Rasheed) This has never been supported, but previously the error was thrown only at execution time, so that it could be masked by planner errors.", "title": "Improve error reporting for attempts to use automatic updating of views with conditional INSTEAD rules", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "a90ed90b9c10030cfb638ad722558ef71e3bd32b52fe92e49de8fc4105422549", "section_path": ["Changes"], "commit_groups": [["353cd826f", "9bdb1f0e3", "9be6fcb3e", "bb09a9414", "d751ba523", "fd5476b79", "fd87262de"]], "identity_text": "Improve error reporting for attempts to use automatic updating of views with conditional INSTEAD rules (Dean Rasheed) This has never been supported, but previously the error was thrown only at execution time, so that it could be masked by planner errors.", "commit_aliases": ["353cd826f", "9bdb1f0e3", "9be6fcb3e", "bb09a9414", "d751ba523", "fd5476b79", "fd87262de"], "source_commits": ["9bdb1f0e3"], "source_entry_id": "11.7/changes/033", "db_id": "6442085995f48457f67674804be68be5", "patch_ids": ["83c7e47d9b1c9e8c2a4bac13bbbac361"], "statement_hash": "640c1858997877f97952553ab17f0024c19eabd56a1824f1e665ebe039970517", "relations": [{"rule": 2, "type": "equivalent", "target": "646ae9c6eeaa9bddece446e464cf5a8b", "evidence": {"same_day": true, "patch_ids": ["83c7e47d9b1c9e8c2a4bac13bbbac361"], "statement_hash": "640c1858997877f97952553ab17f0024c19eabd56a1824f1e665ebe039970517"}}, {"rule": 2, "type": "equivalent", "target": "9d92be7c89b9bc2ab41a36e67bd07fa3", "evidence": {"same_day": true, "patch_ids": ["83c7e47d9b1c9e8c2a4bac13bbbac361"], "statement_hash": "640c1858997877f97952553ab17f0024c19eabd56a1824f1e665ebe039970517"}}, {"rule": 2, "type": "equivalent", "target": "ab7f2c29a2205a2026611703391223db", "evidence": {"same_day": true, "patch_ids": ["83c7e47d9b1c9e8c2a4bac13bbbac361"], "statement_hash": "640c1858997877f97952553ab17f0024c19eabd56a1824f1e665ebe039970517"}}, {"rule": 2, "type": "equivalent", "target": "c9ab6a2569ad820f5fcbce804d8d3c80", "evidence": {"same_day": true, "patch_ids": ["83c7e47d9b1c9e8c2a4bac13bbbac361"], "statement_hash": "640c1858997877f97952553ab17f0024c19eabd56a1824f1e665ebe039970517"}}, {"rule": 2, "type": "equivalent", "target": "f0ee5749c0a83d8cc1d5c36dd742602e", "evidence": {"same_day": true, "patch_ids": ["83c7e47d9b1c9e8c2a4bac13bbbac361"], "statement_hash": "640c1858997877f97952553ab17f0024c19eabd56a1824f1e665ebe039970517"}}], "version": "11.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "9d92be7c89b9bc2ab41a36e67bd07fa3", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Improve error reporting for attempts to use automatic updating of views with conditional INSTEAD rules", "evidence": {"same_day": true, "patch_ids": ["83c7e47d9b1c9e8c2a4bac13bbbac361"], "statement_hash": "640c1858997877f97952553ab17f0024c19eabd56a1824f1e665ebe039970517"}, "url": "/docs/compare/?release=12.2#12.2-d1508c69413dbdc4", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "c9ab6a2569ad820f5fcbce804d8d3c80", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Improve error reporting for attempts to use automatic updating of views with conditional INSTEAD rules", "evidence": {"same_day": true, "patch_ids": ["83c7e47d9b1c9e8c2a4bac13bbbac361"], "statement_hash": "640c1858997877f97952553ab17f0024c19eabd56a1824f1e665ebe039970517"}, "url": "/docs/compare/?release=10.12#10.12-6c94c2e3e06c2e5f", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "646ae9c6eeaa9bddece446e464cf5a8b", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Improve error reporting for attempts to use automatic updating of views with conditional INSTEAD rules", "evidence": {"same_day": true, "patch_ids": ["83c7e47d9b1c9e8c2a4bac13bbbac361"], "statement_hash": "640c1858997877f97952553ab17f0024c19eabd56a1824f1e665ebe039970517"}, "url": "/docs/compare/?release=9.6.17#9.6.17-6c94c2e3e06c2e5f", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "f0ee5749c0a83d8cc1d5c36dd742602e", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "Improve error reporting for attempts to use automatic updating of views with conditional INSTEAD rules", "evidence": {"same_day": true, "patch_ids": ["83c7e47d9b1c9e8c2a4bac13bbbac361"], "statement_hash": "640c1858997877f97952553ab17f0024c19eabd56a1824f1e665ebe039970517"}, "url": "/docs/compare/?release=9.5.21#9.5.21-6c94c2e3e06c2e5f", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "ab7f2c29a2205a2026611703391223db", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "Improve error reporting for attempts to use automatic updating of views with conditional INSTEAD rules", "evidence": {"same_day": true, "patch_ids": ["83c7e47d9b1c9e8c2a4bac13bbbac361"], "statement_hash": "640c1858997877f97952553ab17f0024c19eabd56a1824f1e665ebe039970517"}, "url": "/docs/compare/?release=9.4.26#9.4.26-6c94c2e3e06c2e5f", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-f86b10238b581079", "cves": [], "html": "Prevent a composite type from being included in itself indirectly via a range type (Tom Lane, Julien Rouhaud)
", "text": "Prevent a composite type from being included in itself indirectly via a range type (Tom Lane, Julien Rouhaud)", "title": "Prevent a composite type from being included in itself indirectly via a range type", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "42113818971343b95c7d380201570a8dad0f7bd57c6dcb8fa907e3c7a655a9a0", "section_path": ["Changes"], "commit_groups": [["0d245d13c", "31dfa40a8", "354d913f9", "4af2531d0", "6609c3ad9", "976cb11f6", "fc7695891"], ["25dc267a1", "59047b6d0", "65aa15513", "742c646c1", "74b35eb46", "de3d2df75", "f521ef0ae"]], "identity_text": "Prevent a composite type from being included in itself indirectly via a range type (Tom Lane, Julien Rouhaud)", "commit_aliases": ["0d245d13c", "25dc267a1", "31dfa40a8", "354d913f9", "4af2531d0", "59047b6d0", "65aa15513", "6609c3ad9", "742c646c1", "74b35eb46", "976cb11f6", "de3d2df75", "f521ef0ae", "fc7695891"], "source_commits": ["25dc267a1", "31dfa40a8"], "source_entry_id": "11.7/changes/034", "db_id": "fb5b776882ac9cf61570568881850052", "patch_ids": ["c52b1e33ff03c0a7dd458178601d99df", "d106744efdd32c05bf5cf6e0d1da13bc"], "statement_hash": "f1d1bba4b13cb2d41b5076b349c2869b1a75ad694d10325d17019e4f1e158ef0", "relations": [{"rule": 2, "type": "equivalent", "target": "2d785e978a00eda25468d8fb4cfb2f75", "evidence": {"same_day": true, "patch_ids": ["c52b1e33ff03c0a7dd458178601d99df", "d106744efdd32c05bf5cf6e0d1da13bc"], "statement_hash": "f1d1bba4b13cb2d41b5076b349c2869b1a75ad694d10325d17019e4f1e158ef0"}}, {"rule": 2, "type": "equivalent", "target": "35c56caabddafddc3571fbc8e4d52531", "evidence": {"same_day": true, "patch_ids": ["c52b1e33ff03c0a7dd458178601d99df", "d106744efdd32c05bf5cf6e0d1da13bc"], "statement_hash": "f1d1bba4b13cb2d41b5076b349c2869b1a75ad694d10325d17019e4f1e158ef0"}}, {"rule": 2, "type": "equivalent", "target": "a2f957278a64b12dad6638c4a2a238a3", "evidence": {"same_day": true, "patch_ids": ["c52b1e33ff03c0a7dd458178601d99df", "d106744efdd32c05bf5cf6e0d1da13bc"], "statement_hash": "f1d1bba4b13cb2d41b5076b349c2869b1a75ad694d10325d17019e4f1e158ef0"}}, {"rule": 2, "type": "equivalent", "target": "e67d212ae0c11e78088262e4b34e72aa", "evidence": {"same_day": true, "patch_ids": ["c52b1e33ff03c0a7dd458178601d99df", "d106744efdd32c05bf5cf6e0d1da13bc"], "statement_hash": "f1d1bba4b13cb2d41b5076b349c2869b1a75ad694d10325d17019e4f1e158ef0"}}, {"rule": 2, "type": "equivalent", "target": "fffa3fefd5d79f160d2ddf4bf5538921", "evidence": {"same_day": true, "patch_ids": ["c52b1e33ff03c0a7dd458178601d99df", "d106744efdd32c05bf5cf6e0d1da13bc"], "statement_hash": "f1d1bba4b13cb2d41b5076b349c2869b1a75ad694d10325d17019e4f1e158ef0"}}], "version": "11.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "e67d212ae0c11e78088262e4b34e72aa", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Prevent a composite type from being included in itself indirectly via a range type", "evidence": {"same_day": true, "patch_ids": ["c52b1e33ff03c0a7dd458178601d99df", "d106744efdd32c05bf5cf6e0d1da13bc"], "statement_hash": "f1d1bba4b13cb2d41b5076b349c2869b1a75ad694d10325d17019e4f1e158ef0"}, "url": "/docs/compare/?release=12.2#12.2-497f5e61d9c1b201", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "35c56caabddafddc3571fbc8e4d52531", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Prevent a composite type from being included in itself indirectly via a range type", "evidence": {"same_day": true, "patch_ids": ["c52b1e33ff03c0a7dd458178601d99df", "d106744efdd32c05bf5cf6e0d1da13bc"], "statement_hash": "f1d1bba4b13cb2d41b5076b349c2869b1a75ad694d10325d17019e4f1e158ef0"}, "url": "/docs/compare/?release=10.12#10.12-f86b10238b581079", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "a2f957278a64b12dad6638c4a2a238a3", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Prevent a composite type from being included in itself indirectly via a range type", "evidence": {"same_day": true, "patch_ids": ["c52b1e33ff03c0a7dd458178601d99df", "d106744efdd32c05bf5cf6e0d1da13bc"], "statement_hash": "f1d1bba4b13cb2d41b5076b349c2869b1a75ad694d10325d17019e4f1e158ef0"}, "url": "/docs/compare/?release=9.6.17#9.6.17-f86b10238b581079", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "fffa3fefd5d79f160d2ddf4bf5538921", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "Prevent a composite type from being included in itself indirectly via a range type", "evidence": {"same_day": true, "patch_ids": ["c52b1e33ff03c0a7dd458178601d99df", "d106744efdd32c05bf5cf6e0d1da13bc"], "statement_hash": "f1d1bba4b13cb2d41b5076b349c2869b1a75ad694d10325d17019e4f1e158ef0"}, "url": "/docs/compare/?release=9.5.21#9.5.21-f86b10238b581079", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "2d785e978a00eda25468d8fb4cfb2f75", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "Prevent a composite type from being included in itself indirectly via a range type", "evidence": {"same_day": true, "patch_ids": ["c52b1e33ff03c0a7dd458178601d99df", "d106744efdd32c05bf5cf6e0d1da13bc"], "statement_hash": "f1d1bba4b13cb2d41b5076b349c2869b1a75ad694d10325d17019e4f1e158ef0"}, "url": "/docs/compare/?release=9.4.26#9.4.26-f86b10238b581079", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-a33a7610f11fbc55", "cves": [], "html": "Disallow partition key expressions that return pseudo-types, such as record (Tom Lane)
Fix error reporting for index expressions of prohibited types (Amit Langote)
", "text": "Fix error reporting for index expressions of prohibited types (Amit Langote)", "title": "Fix error reporting for index expressions of prohibited types", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "20695d5a33e1805e533c87ae85745b0a899879353436f132c357a9fc5646b576", "section_path": ["Changes"], "commit_groups": [["275a8ac4f", "298d056d9", "2acab054b", "5c5a268c6", "97ba30fab", "da5dd4218", "fc449abc3"]], "identity_text": "Fix error reporting for index expressions of prohibited types (Amit Langote)", "commit_aliases": ["275a8ac4f", "298d056d9", "2acab054b", "5c5a268c6", "97ba30fab", "da5dd4218", "fc449abc3"], "source_commits": ["fc449abc3"], "source_entry_id": "11.7/changes/036", "db_id": "d703eb963ada69f3f8f94e175186b02a", "patch_ids": ["9ebd2a16b818858b89002e88642403f2"], "statement_hash": "28d1e927697d02690e4caea98e721555cea4c2b840ec748b42cd629016dc759c", "relations": [{"rule": 2, "type": "equivalent", "target": "1bdd4656461fd2b6d206dbe16e040209", "evidence": {"same_day": true, "patch_ids": ["9ebd2a16b818858b89002e88642403f2"], "statement_hash": "28d1e927697d02690e4caea98e721555cea4c2b840ec748b42cd629016dc759c"}}, {"rule": 2, "type": "equivalent", "target": "4c8354beb60a5626a666682abda93b92", "evidence": {"same_day": true, "patch_ids": ["9ebd2a16b818858b89002e88642403f2"], "statement_hash": "28d1e927697d02690e4caea98e721555cea4c2b840ec748b42cd629016dc759c"}}, {"rule": 2, "type": "equivalent", "target": "c67e1dcc68db8ad7eaad8c63d5deabf3", "evidence": {"same_day": true, "patch_ids": ["9ebd2a16b818858b89002e88642403f2"], "statement_hash": "28d1e927697d02690e4caea98e721555cea4c2b840ec748b42cd629016dc759c"}}, {"rule": 2, "type": "equivalent", "target": "c68cb246482528c6d028f8424cbc1206", "evidence": {"same_day": true, "patch_ids": ["9ebd2a16b818858b89002e88642403f2"], "statement_hash": "28d1e927697d02690e4caea98e721555cea4c2b840ec748b42cd629016dc759c"}}, {"rule": 2, "type": "equivalent", "target": "e8ba847993f879f935751b4d4f862b2c", "evidence": {"same_day": true, "patch_ids": ["9ebd2a16b818858b89002e88642403f2"], "statement_hash": "28d1e927697d02690e4caea98e721555cea4c2b840ec748b42cd629016dc759c"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "e8ba847993f879f935751b4d4f862b2c", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Fix error reporting for index expressions of prohibited types", "evidence": {"same_day": true, "patch_ids": ["9ebd2a16b818858b89002e88642403f2"], "statement_hash": "28d1e927697d02690e4caea98e721555cea4c2b840ec748b42cd629016dc759c"}, "url": "/docs/compare/?release=12.2#12.2-6143d250a536d32b", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "1bdd4656461fd2b6d206dbe16e040209", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Fix error reporting for index expressions of prohibited types", "evidence": {"same_day": true, "patch_ids": ["9ebd2a16b818858b89002e88642403f2"], "statement_hash": "28d1e927697d02690e4caea98e721555cea4c2b840ec748b42cd629016dc759c"}, "url": "/docs/compare/?release=10.12#10.12-72e209f03cc010b2", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "4c8354beb60a5626a666682abda93b92", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Fix error reporting for index expressions of prohibited types", "evidence": {"same_day": true, "patch_ids": ["9ebd2a16b818858b89002e88642403f2"], "statement_hash": "28d1e927697d02690e4caea98e721555cea4c2b840ec748b42cd629016dc759c"}, "url": "/docs/compare/?release=9.6.17#9.6.17-72e209f03cc010b2", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "c68cb246482528c6d028f8424cbc1206", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "Fix error reporting for index expressions of prohibited types", "evidence": {"same_day": true, "patch_ids": ["9ebd2a16b818858b89002e88642403f2"], "statement_hash": "28d1e927697d02690e4caea98e721555cea4c2b840ec748b42cd629016dc759c"}, "url": "/docs/compare/?release=9.5.21#9.5.21-72e209f03cc010b2", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "c67e1dcc68db8ad7eaad8c63d5deabf3", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "Fix error reporting for index expressions of prohibited types", "evidence": {"same_day": true, "patch_ids": ["9ebd2a16b818858b89002e88642403f2"], "statement_hash": "28d1e927697d02690e4caea98e721555cea4c2b840ec748b42cd629016dc759c"}, "url": "/docs/compare/?release=9.4.26#9.4.26-72e209f03cc010b2", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-69f1c5275fe41a47", "cves": [], "html": "Fix dumping of views that contain only a VALUES list to handle cases where a view output column has been renamed (Tom Lane)
Ensure that data types and collations used in XMLTABLE constructs are accounted for when computing dependencies of a view or rule (Tom Lane)
Previously it was possible to break a view using XMLTABLE by dropping a type, if the type was not otherwise referenced in the view. This fix does not correct the dependencies already recorded for existing views, only for newly-created ones.
Prevent unwanted downcasing and truncation of RADIUS authentication parameters (Marcos David)
\nThe pg_hba.conf parser mistakenly treated these fields as SQL identifiers, which in general they aren't.
Transmit incoming NOTIFY messages to the client before sending ReadyForQuery, rather than after (Tom Lane)
This change ensures that, with libpq and other client libraries that act similarly to it, any notifications received during a transaction will be available by the time the client thinks the transaction is complete. This probably makes no difference in practical applications (which would need to cope with asynchronous notifications in any case); but it makes it easier to build test cases with reproducible behavior.
", "text": "Transmit incoming NOTIFY messages to the client before sending ReadyForQuery, rather than after (Tom Lane) This change ensures that, with libpq and other client libraries that act similarly to it, any notifications received during a transaction will be available by the time the client thinks the transaction is complete. This probably makes no difference in practical applications (which would need to cope with asynchronous notifications in any case); but it makes it easier to build test cases with reproducible behavior.", "title": "Transmit incoming NOTIFY messages to the client before sending ReadyForQuery, rather than after", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "53741ecbef9c45c8cca27f721f703a9cd58e483c8986fca31daa2903b96341d3", "section_path": ["Changes"], "commit_groups": [["111298aa6", "377d1b95b", "790026972", "c47f498c9", "dbe15524b"]], "identity_text": "Transmit incoming NOTIFY messages to the client before sending ReadyForQuery, rather than after (Tom Lane) This change ensures that, with libpq and other client libraries that act similarly to it, any notifications received during a transaction will be available by the time the client thinks the transaction is complete. This probably makes no difference in practical applications (which would need to cope with asynchronous notifications in any case); but it makes it easier to build test cases with reproducible behavior.", "commit_aliases": ["111298aa6", "377d1b95b", "790026972", "c47f498c9", "dbe15524b"], "source_commits": ["377d1b95b"], "source_entry_id": "11.7/changes/040", "db_id": "0d54b92cb025561e0cae46f0875d9f49", "patch_ids": ["143ac7220b04444a8a549b7e07106f4c"], "statement_hash": "8312a6e591ff94226aa79fbd57a837b0f77fedcc878f005bd0cf9b138118552a", "relations": [{"rule": 2, "type": "equivalent", "target": "a39c1e72595c5bfe66bdafb5f1287cbf", "evidence": {"same_day": true, "patch_ids": ["143ac7220b04444a8a549b7e07106f4c"], "statement_hash": "8312a6e591ff94226aa79fbd57a837b0f77fedcc878f005bd0cf9b138118552a"}}, {"rule": 2, "type": "equivalent", "target": "c119abea7e9d42151b4f9b00b579082b", "evidence": {"same_day": true, "patch_ids": ["143ac7220b04444a8a549b7e07106f4c"], "statement_hash": "8312a6e591ff94226aa79fbd57a837b0f77fedcc878f005bd0cf9b138118552a"}}, {"rule": 2, "type": "equivalent", "target": "f7b4edeffd8f7e2bbd60da7e8191bcaf", "evidence": {"same_day": true, "patch_ids": ["143ac7220b04444a8a549b7e07106f4c"], "statement_hash": "8312a6e591ff94226aa79fbd57a837b0f77fedcc878f005bd0cf9b138118552a"}}], "version": "11.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "a39c1e72595c5bfe66bdafb5f1287cbf", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Transmit incoming NOTIFY messages to the client before sending ReadyForQuery, rather than after", "evidence": {"same_day": true, "patch_ids": ["143ac7220b04444a8a549b7e07106f4c"], "statement_hash": "8312a6e591ff94226aa79fbd57a837b0f77fedcc878f005bd0cf9b138118552a"}, "url": "/docs/compare/?release=12.2#12.2-889874eb8cc1b3e7", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "c119abea7e9d42151b4f9b00b579082b", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Transmit incoming NOTIFY messages to the client before sending ReadyForQuery, rather than after", "evidence": {"same_day": true, "patch_ids": ["143ac7220b04444a8a549b7e07106f4c"], "statement_hash": "8312a6e591ff94226aa79fbd57a837b0f77fedcc878f005bd0cf9b138118552a"}, "url": "/docs/compare/?release=10.12#10.12-acdbfd45dd03734f", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "f7b4edeffd8f7e2bbd60da7e8191bcaf", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Transmit incoming NOTIFY messages to the client before sending ReadyForQuery, rather than after", "evidence": {"same_day": true, "patch_ids": ["143ac7220b04444a8a549b7e07106f4c"], "statement_hash": "8312a6e591ff94226aa79fbd57a837b0f77fedcc878f005bd0cf9b138118552a"}, "url": "/docs/compare/?release=9.6.17#9.6.17-acdbfd45dd03734f", "source_url": "/docs/release/9.6.17/#AEN133104"}]}, {"id": "11.7-fd3753fb5e6d92ac", "cves": [], "html": "Allow libpq to parse all GSS-related connection parameters even when the GSSAPI code hasn't been compiled in (Tom Lane)
\nThis makes the behavior similar to our SSL support, where it was long ago deemed to be a good idea to always accept all the related parameters, even if some are ignored or restricted due to lack of the feature in a particular build.
", "text": "Allow libpq to parse all GSS-related connection parameters even when the GSSAPI code hasn't been compiled in (Tom Lane) This makes the behavior similar to our SSL support, where it was long ago deemed to be a good idea to always accept all the related parameters, even if some are ignored or restricted due to lack of the feature in a particular build.", "title": "Allow libpq to parse all GSS-related connection parameters even when the GSSAPI code hasn't been compiled in", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "6bb4a12738abdd750816a2c4baebcd5ca131dcbd4bc10b862310251e5731286d", "section_path": ["Changes"], "commit_groups": [["1a77ea02d", "5e22a1111", "875c7d70d", "c11bd6c10", "d09cfa3e2", "e60b480d3", "e8f60e6fe"]], "identity_text": "Allow libpq to parse all GSS-related connection parameters even when the GSSAPI code hasn't been compiled in (Tom Lane) This makes the behavior similar to our SSL support, where it was long ago deemed to be a good idea to always accept all the related parameters, even if some are ignored or restricted due to lack of the feature in a particular build.", "commit_aliases": ["1a77ea02d", "5e22a1111", "875c7d70d", "c11bd6c10", "d09cfa3e2", "e60b480d3", "e8f60e6fe"], "source_commits": ["1a77ea02d"], "source_entry_id": "11.7/changes/041", "db_id": "1bb2f6337ba2898734544030a669e49d", "patch_ids": ["545032ece7d355adeec65ef480fad60d"], "statement_hash": "1206a1ac182d983384194ddf901975451c4f893e2c798f2df70cc5614c46e763", "relations": [{"rule": 2, "type": "equivalent", "target": "2d073031d898b2ce379669b11bf00500", "evidence": {"same_day": true, "patch_ids": ["545032ece7d355adeec65ef480fad60d"], "statement_hash": "1206a1ac182d983384194ddf901975451c4f893e2c798f2df70cc5614c46e763"}}, {"rule": 2, "type": "equivalent", "target": "403244521d4fdb482380e481cc2ced93", "evidence": {"same_day": true, "patch_ids": ["545032ece7d355adeec65ef480fad60d"], "statement_hash": "1206a1ac182d983384194ddf901975451c4f893e2c798f2df70cc5614c46e763"}}, {"rule": 2, "type": "equivalent", "target": "484d7d42670f34504842f8b64f8610bc", "evidence": {"same_day": true, "patch_ids": ["545032ece7d355adeec65ef480fad60d"], "statement_hash": "1206a1ac182d983384194ddf901975451c4f893e2c798f2df70cc5614c46e763"}}, {"rule": 2, "type": "equivalent", "target": "784fb8e33c762755c78c61d3c0255575", "evidence": {"same_day": true, "patch_ids": ["545032ece7d355adeec65ef480fad60d"], "statement_hash": "1206a1ac182d983384194ddf901975451c4f893e2c798f2df70cc5614c46e763"}}, {"rule": 2, "type": "equivalent", "target": "b722089a0263aa3d6c363961a1789ede", "evidence": {"same_day": true, "patch_ids": ["545032ece7d355adeec65ef480fad60d"], "statement_hash": "1206a1ac182d983384194ddf901975451c4f893e2c798f2df70cc5614c46e763"}}], "version": "11.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b722089a0263aa3d6c363961a1789ede", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Allow libpq to parse all GSS-related connection parameters even when the GSSAPI code hasn't been compiled in", "evidence": {"same_day": true, "patch_ids": ["545032ece7d355adeec65ef480fad60d"], "statement_hash": "1206a1ac182d983384194ddf901975451c4f893e2c798f2df70cc5614c46e763"}, "url": "/docs/compare/?release=12.2#12.2-fe8985d3df13efcf", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "784fb8e33c762755c78c61d3c0255575", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Allow libpq to parse all GSS-related connection parameters even when the GSSAPI code hasn't been compiled in", "evidence": {"same_day": true, "patch_ids": ["545032ece7d355adeec65ef480fad60d"], "statement_hash": "1206a1ac182d983384194ddf901975451c4f893e2c798f2df70cc5614c46e763"}, "url": "/docs/compare/?release=10.12#10.12-fd3753fb5e6d92ac", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "403244521d4fdb482380e481cc2ced93", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Allow libpq to parse all GSS-related connection parameters even when the GSSAPI code hasn't been compiled in", "evidence": {"same_day": true, "patch_ids": ["545032ece7d355adeec65ef480fad60d"], "statement_hash": "1206a1ac182d983384194ddf901975451c4f893e2c798f2df70cc5614c46e763"}, "url": "/docs/compare/?release=9.6.17#9.6.17-fd3753fb5e6d92ac", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "2d073031d898b2ce379669b11bf00500", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "Allow libpq to parse all GSS-related connection parameters even when the GSSAPI code hasn't been compiled in", "evidence": {"same_day": true, "patch_ids": ["545032ece7d355adeec65ef480fad60d"], "statement_hash": "1206a1ac182d983384194ddf901975451c4f893e2c798f2df70cc5614c46e763"}, "url": "/docs/compare/?release=9.5.21#9.5.21-fd3753fb5e6d92ac", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "484d7d42670f34504842f8b64f8610bc", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "Allow libpq to parse all GSS-related connection parameters even when the GSSAPI code hasn't been compiled in", "evidence": {"same_day": true, "patch_ids": ["545032ece7d355adeec65ef480fad60d"], "statement_hash": "1206a1ac182d983384194ddf901975451c4f893e2c798f2df70cc5614c46e763"}, "url": "/docs/compare/?release=9.4.26#9.4.26-fd3753fb5e6d92ac", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-4538742d254d3040", "cves": [], "html": "Fix incorrect handling of %b and %B format codes in ecpg's PGTYPEStimestamp_fmt_asc() function (Tomas Vondra)
Due to an off-by-one error, these codes would print the wrong month name, or possibly crash.
", "text": "Fix incorrect handling of %b and %B format codes in ecpg's PGTYPEStimestamp_fmt_asc() function (Tomas Vondra) Due to an off-by-one error, these codes would print the wrong month name, or possibly crash.", "title": "Fix incorrect handling of %b and %B format codes in ecpg's PGTYPEStimestamp_fmt_asc() function", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "cb73abd0179aff744368d094303667835d295d77290fd6eeab3f343c6f3389fd", "section_path": ["Changes"], "commit_groups": [["0dafed6fe", "3ff660bbe", "9668bf5d5", "a17602de1", "c59414da7", "d9b974e99", "f71b22f53"]], "identity_text": "Fix incorrect handling of %b and %B format codes in ecpg's PGTYPEStimestamp_fmt_asc() function (Tomas Vondra) Due to an off-by-one error, these codes would print the wrong month name, or possibly crash.", "commit_aliases": ["0dafed6fe", "3ff660bbe", "9668bf5d5", "a17602de1", "c59414da7", "d9b974e99", "f71b22f53"], "source_commits": ["9668bf5d5"], "source_entry_id": "11.7/changes/042", "db_id": "4c483fea559a83716ed5879fc5f8ebc4", "patch_ids": ["98ce3485e7421c58dabcd04707a8b4dc"], "statement_hash": "55f40e67e7ff67ce051d1e229c5b9805045fa9e0750b98da37f72bd574814bf6", "relations": [{"rule": 2, "type": "equivalent", "target": "07c9c08c3f6d8a9d7bb489a91bc7bfad", "evidence": {"same_day": true, "patch_ids": ["98ce3485e7421c58dabcd04707a8b4dc"], "statement_hash": "55f40e67e7ff67ce051d1e229c5b9805045fa9e0750b98da37f72bd574814bf6"}}, {"rule": 2, "type": "equivalent", "target": "7fc768077bbbaba7bb2800f2d9790945", "evidence": {"same_day": true, "patch_ids": ["98ce3485e7421c58dabcd04707a8b4dc"], "statement_hash": "55f40e67e7ff67ce051d1e229c5b9805045fa9e0750b98da37f72bd574814bf6"}}, {"rule": 2, "type": "equivalent", "target": "a18b89f65dd1e0d20dfd4b9c304a3ed2", "evidence": {"same_day": true, "patch_ids": ["98ce3485e7421c58dabcd04707a8b4dc"], "statement_hash": "55f40e67e7ff67ce051d1e229c5b9805045fa9e0750b98da37f72bd574814bf6"}}, {"rule": 2, "type": "equivalent", "target": "ccd200283e6eaabea774bf29b3a5c9b0", "evidence": {"same_day": true, "patch_ids": ["98ce3485e7421c58dabcd04707a8b4dc"], "statement_hash": "55f40e67e7ff67ce051d1e229c5b9805045fa9e0750b98da37f72bd574814bf6"}}, {"rule": 2, "type": "equivalent", "target": "f7eb19a202cef3c275a0ac6028d63ec8", "evidence": {"same_day": true, "patch_ids": ["98ce3485e7421c58dabcd04707a8b4dc"], "statement_hash": "55f40e67e7ff67ce051d1e229c5b9805045fa9e0750b98da37f72bd574814bf6"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "7fc768077bbbaba7bb2800f2d9790945", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Fix incorrect handling of %b and %B format codes in ecpg's PGTYPEStimestamp_fmt_asc() function", "evidence": {"same_day": true, "patch_ids": ["98ce3485e7421c58dabcd04707a8b4dc"], "statement_hash": "55f40e67e7ff67ce051d1e229c5b9805045fa9e0750b98da37f72bd574814bf6"}, "url": "/docs/compare/?release=12.2#12.2-1e9b09723b65ec71", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "f7eb19a202cef3c275a0ac6028d63ec8", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Fix incorrect handling of %b and %B format codes in ecpg's PGTYPEStimestamp_fmt_asc() function", "evidence": {"same_day": true, "patch_ids": ["98ce3485e7421c58dabcd04707a8b4dc"], "statement_hash": "55f40e67e7ff67ce051d1e229c5b9805045fa9e0750b98da37f72bd574814bf6"}, "url": "/docs/compare/?release=10.12#10.12-4538742d254d3040", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "ccd200283e6eaabea774bf29b3a5c9b0", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Fix incorrect handling of %b and %B format codes in ecpg's PGTYPEStimestamp_fmt_asc() function", "evidence": {"same_day": true, "patch_ids": ["98ce3485e7421c58dabcd04707a8b4dc"], "statement_hash": "55f40e67e7ff67ce051d1e229c5b9805045fa9e0750b98da37f72bd574814bf6"}, "url": "/docs/compare/?release=9.6.17#9.6.17-4538742d254d3040", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "a18b89f65dd1e0d20dfd4b9c304a3ed2", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "Fix incorrect handling of %b and %B format codes in ecpg's PGTYPEStimestamp_fmt_asc() function", "evidence": {"same_day": true, "patch_ids": ["98ce3485e7421c58dabcd04707a8b4dc"], "statement_hash": "55f40e67e7ff67ce051d1e229c5b9805045fa9e0750b98da37f72bd574814bf6"}, "url": "/docs/compare/?release=9.5.21#9.5.21-4538742d254d3040", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "07c9c08c3f6d8a9d7bb489a91bc7bfad", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "Fix incorrect handling of %b and %B format codes in ecpg's PGTYPEStimestamp_fmt_asc() function", "evidence": {"same_day": true, "patch_ids": ["98ce3485e7421c58dabcd04707a8b4dc"], "statement_hash": "55f40e67e7ff67ce051d1e229c5b9805045fa9e0750b98da37f72bd574814bf6"}, "url": "/docs/compare/?release=9.4.26#9.4.26-4538742d254d3040", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-9154659a24fa6fad", "cves": [], "html": "Fix parallel pg_dump/pg_restore to more gracefully handle failure to create worker processes (Tom Lane)
", "text": "Fix parallel pg_dump/pg_restore to more gracefully handle failure to create worker processes (Tom Lane)", "title": "Fix parallel pg_dump/pg_restore to more gracefully handle failure to create worker processes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "9297ce6cbade008bd268013fec521839ec1a8b8b3d42f4f968b22e26010e0d94", "section_path": ["Changes"], "commit_groups": [["0c84199f7", "1b78759a6", "2425f8f71", "5d60df830", "63634883f", "8b1d447a7", "cb4c04a4e"]], "identity_text": "Fix parallel pg_dump/pg_restore to more gracefully handle failure to create worker processes (Tom Lane)", "commit_aliases": ["0c84199f7", "1b78759a6", "2425f8f71", "5d60df830", "63634883f", "8b1d447a7", "cb4c04a4e"], "source_commits": ["63634883f"], "source_entry_id": "11.7/changes/043", "db_id": "a1d22ded062e9e3096bacd967cdc61ef", "patch_ids": ["0d7f5bc545ea1e1a61a67392cf699588"], "statement_hash": "7e204789eeadc31c686e16ec9957cb9befb4b28d48d5c03d21cddfba4184ac1b", "relations": [{"rule": 2, "type": "equivalent", "target": "0ab31d1c876e317b3b92455400a0ad54", "evidence": {"same_day": true, "patch_ids": ["0d7f5bc545ea1e1a61a67392cf699588"], "statement_hash": "7e204789eeadc31c686e16ec9957cb9befb4b28d48d5c03d21cddfba4184ac1b"}}, {"rule": 2, "type": "equivalent", "target": "8a9244297667d21859c24d9abc30e876", "evidence": {"same_day": true, "patch_ids": ["0d7f5bc545ea1e1a61a67392cf699588"], "statement_hash": "7e204789eeadc31c686e16ec9957cb9befb4b28d48d5c03d21cddfba4184ac1b"}}, {"rule": 2, "type": "equivalent", "target": "a3267b55c0fd1e4e3eb579367cfbf7d5", "evidence": {"same_day": true, "patch_ids": ["0d7f5bc545ea1e1a61a67392cf699588"], "statement_hash": "7e204789eeadc31c686e16ec9957cb9befb4b28d48d5c03d21cddfba4184ac1b"}}, {"rule": 2, "type": "equivalent", "target": "c1a394e88df8828ac55b88015435150b", "evidence": {"same_day": true, "patch_ids": ["0d7f5bc545ea1e1a61a67392cf699588"], "statement_hash": "7e204789eeadc31c686e16ec9957cb9befb4b28d48d5c03d21cddfba4184ac1b"}}, {"rule": 2, "type": "equivalent", "target": "e0a38ce313ac6d1f4adca0f715b2100c", "evidence": {"same_day": true, "patch_ids": ["0d7f5bc545ea1e1a61a67392cf699588"], "statement_hash": "7e204789eeadc31c686e16ec9957cb9befb4b28d48d5c03d21cddfba4184ac1b"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "8a9244297667d21859c24d9abc30e876", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Fix parallel pg_dump/pg_restore to more gracefully handle failure to create worker processes", "evidence": {"same_day": true, "patch_ids": ["0d7f5bc545ea1e1a61a67392cf699588"], "statement_hash": "7e204789eeadc31c686e16ec9957cb9befb4b28d48d5c03d21cddfba4184ac1b"}, "url": "/docs/compare/?release=12.2#12.2-e74f446ac1d82f13", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "c1a394e88df8828ac55b88015435150b", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Fix parallel pg_dump/pg_restore to more gracefully handle failure to create worker processes", "evidence": {"same_day": true, "patch_ids": ["0d7f5bc545ea1e1a61a67392cf699588"], "statement_hash": "7e204789eeadc31c686e16ec9957cb9befb4b28d48d5c03d21cddfba4184ac1b"}, "url": "/docs/compare/?release=10.12#10.12-9154659a24fa6fad", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "0ab31d1c876e317b3b92455400a0ad54", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Fix parallel pg_dump/pg_restore to more gracefully handle failure to create worker processes", "evidence": {"same_day": true, "patch_ids": ["0d7f5bc545ea1e1a61a67392cf699588"], "statement_hash": "7e204789eeadc31c686e16ec9957cb9befb4b28d48d5c03d21cddfba4184ac1b"}, "url": "/docs/compare/?release=9.6.17#9.6.17-9154659a24fa6fad", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "a3267b55c0fd1e4e3eb579367cfbf7d5", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "Fix parallel pg_dump/pg_restore to more gracefully handle failure to create worker processes", "evidence": {"same_day": true, "patch_ids": ["0d7f5bc545ea1e1a61a67392cf699588"], "statement_hash": "7e204789eeadc31c686e16ec9957cb9befb4b28d48d5c03d21cddfba4184ac1b"}, "url": "/docs/compare/?release=9.5.21#9.5.21-9154659a24fa6fad", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "e0a38ce313ac6d1f4adca0f715b2100c", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "Fix parallel pg_dump/pg_restore to more gracefully handle failure to create worker processes", "evidence": {"same_day": true, "patch_ids": ["0d7f5bc545ea1e1a61a67392cf699588"], "statement_hash": "7e204789eeadc31c686e16ec9957cb9befb4b28d48d5c03d21cddfba4184ac1b"}, "url": "/docs/compare/?release=9.4.26#9.4.26-9154659a24fa6fad", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-db25c7a3d6b6bc9d", "cves": [], "html": "Prevent possible crash or lockup when attempting to terminate a parallel pg_dump/pg_restore run via a signal (Tom Lane)
", "text": "Prevent possible crash or lockup when attempting to terminate a parallel pg_dump/pg_restore run via a signal (Tom Lane)", "title": "Prevent possible crash or lockup when attempting to terminate a parallel pg_dump/pg_restore run via a signal", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "5fcb64b657a1d223789fd2fb7a27ea6bb84a238b5886bac1410bb8d3a04be770", "section_path": ["Changes"], "commit_groups": [["208e262f9", "42e538fe6", "4ea5cf403", "6f6daa1be", "71b121f42", "b1392a950", "cd23a2019"]], "identity_text": "Prevent possible crash or lockup when attempting to terminate a parallel pg_dump/pg_restore run via a signal (Tom Lane)", "commit_aliases": ["208e262f9", "42e538fe6", "4ea5cf403", "6f6daa1be", "71b121f42", "b1392a950", "cd23a2019"], "source_commits": ["4ea5cf403"], "source_entry_id": "11.7/changes/044", "db_id": "0646cf398136f66e7d5ea03ec7db8d18", "patch_ids": ["e1cd77d183d2459836ef8973a423eb92"], "statement_hash": "4c13e614942a0d58d6085d345b46b5cdafb2d5bc4ba245d4f7cae8ffa05c14ad", "relations": [{"rule": 2, "type": "equivalent", "target": "1a15011a7e46a553a64c592b19223755", "evidence": {"same_day": true, "patch_ids": ["e1cd77d183d2459836ef8973a423eb92"], "statement_hash": "4c13e614942a0d58d6085d345b46b5cdafb2d5bc4ba245d4f7cae8ffa05c14ad"}}, {"rule": 2, "type": "equivalent", "target": "30c6a89696ef02370e40ff591f5789bf", "evidence": {"same_day": true, "patch_ids": ["e1cd77d183d2459836ef8973a423eb92"], "statement_hash": "4c13e614942a0d58d6085d345b46b5cdafb2d5bc4ba245d4f7cae8ffa05c14ad"}}, {"rule": 2, "type": "equivalent", "target": "59290e6cad80d05142e78788b0a3d970", "evidence": {"same_day": true, "patch_ids": ["e1cd77d183d2459836ef8973a423eb92"], "statement_hash": "4c13e614942a0d58d6085d345b46b5cdafb2d5bc4ba245d4f7cae8ffa05c14ad"}}, {"rule": 2, "type": "equivalent", "target": "791b656bd54dbd56091c423512e75420", "evidence": {"same_day": true, "patch_ids": ["e1cd77d183d2459836ef8973a423eb92"], "statement_hash": "4c13e614942a0d58d6085d345b46b5cdafb2d5bc4ba245d4f7cae8ffa05c14ad"}}, {"rule": 2, "type": "equivalent", "target": "c8a304f2379323f0227ce2a1b8869c64", "evidence": {"same_day": true, "patch_ids": ["e1cd77d183d2459836ef8973a423eb92"], "statement_hash": "4c13e614942a0d58d6085d345b46b5cdafb2d5bc4ba245d4f7cae8ffa05c14ad"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "59290e6cad80d05142e78788b0a3d970", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Prevent possible crash or lockup when attempting to terminate a parallel pg_dump/pg_restore run via a signal", "evidence": {"same_day": true, "patch_ids": ["e1cd77d183d2459836ef8973a423eb92"], "statement_hash": "4c13e614942a0d58d6085d345b46b5cdafb2d5bc4ba245d4f7cae8ffa05c14ad"}, "url": "/docs/compare/?release=12.2#12.2-8e1bf144ec0b5547", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "791b656bd54dbd56091c423512e75420", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Prevent possible crash or lockup when attempting to terminate a parallel pg_dump/pg_restore run via a signal", "evidence": {"same_day": true, "patch_ids": ["e1cd77d183d2459836ef8973a423eb92"], "statement_hash": "4c13e614942a0d58d6085d345b46b5cdafb2d5bc4ba245d4f7cae8ffa05c14ad"}, "url": "/docs/compare/?release=10.12#10.12-db25c7a3d6b6bc9d", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "30c6a89696ef02370e40ff591f5789bf", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Prevent possible crash or lockup when attempting to terminate a parallel pg_dump/pg_restore run via a signal", "evidence": {"same_day": true, "patch_ids": ["e1cd77d183d2459836ef8973a423eb92"], "statement_hash": "4c13e614942a0d58d6085d345b46b5cdafb2d5bc4ba245d4f7cae8ffa05c14ad"}, "url": "/docs/compare/?release=9.6.17#9.6.17-db25c7a3d6b6bc9d", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "1a15011a7e46a553a64c592b19223755", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "Prevent possible crash or lockup when attempting to terminate a parallel pg_dump/pg_restore run via a signal", "evidence": {"same_day": true, "patch_ids": ["e1cd77d183d2459836ef8973a423eb92"], "statement_hash": "4c13e614942a0d58d6085d345b46b5cdafb2d5bc4ba245d4f7cae8ffa05c14ad"}, "url": "/docs/compare/?release=9.5.21#9.5.21-db25c7a3d6b6bc9d", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "c8a304f2379323f0227ce2a1b8869c64", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "Prevent possible crash or lockup when attempting to terminate a parallel pg_dump/pg_restore run via a signal", "evidence": {"same_day": true, "patch_ids": ["e1cd77d183d2459836ef8973a423eb92"], "statement_hash": "4c13e614942a0d58d6085d345b46b5cdafb2d5bc4ba245d4f7cae8ffa05c14ad"}, "url": "/docs/compare/?release=9.4.26#9.4.26-db25c7a3d6b6bc9d", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-c248a869b953df54", "cves": [], "html": "In pg_upgrade, look inside arrays and ranges while searching for non-upgradable data types in tables (Tom Lane)
", "text": "In pg_upgrade, look inside arrays and ranges while searching for non-upgradable data types in tables (Tom Lane)", "title": "In pg_upgrade, look inside arrays and ranges while searching for non-upgradable data types in tables", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "507c565109d1038112f26259c4d59f0ff3b3d272974b269b9533a8c5a46d4d48", "section_path": ["Changes"], "commit_groups": [["1cd57b05e", "29aeda6e4", "56c06999d", "8e4ef3287", "c443e3c43", "f378d4dac", "fb26754af"]], "identity_text": "In pg_upgrade, look inside arrays and ranges while searching for non-upgradable data types in tables (Tom Lane)", "commit_aliases": ["1cd57b05e", "29aeda6e4", "56c06999d", "8e4ef3287", "c443e3c43", "f378d4dac", "fb26754af"], "source_commits": ["8e4ef3287"], "source_entry_id": "11.7/changes/045", "db_id": "37b9438c61c71a41a14ec10f666bad3e", "patch_ids": ["74d41ab4c40159181bb8920ee36a3c7e"], "statement_hash": "a5dd0a05f1c41159d81f38173b9d06bd1a19f0b19513ef285505231dcf1cba9c", "relations": [{"rule": 2, "type": "equivalent", "target": "02eab376408822d258054b57c978ee9a", "evidence": {"same_day": true, "patch_ids": ["74d41ab4c40159181bb8920ee36a3c7e"], "statement_hash": "a5dd0a05f1c41159d81f38173b9d06bd1a19f0b19513ef285505231dcf1cba9c"}}, {"rule": 2, "type": "equivalent", "target": "0ab2f2ca5c2b135c457c21f3595980b8", "evidence": {"same_day": true, "patch_ids": ["74d41ab4c40159181bb8920ee36a3c7e"], "statement_hash": "a5dd0a05f1c41159d81f38173b9d06bd1a19f0b19513ef285505231dcf1cba9c"}}, {"rule": 2, "type": "equivalent", "target": "74783fe19c389a77224012f635160ade", "evidence": {"same_day": true, "patch_ids": ["74d41ab4c40159181bb8920ee36a3c7e"], "statement_hash": "a5dd0a05f1c41159d81f38173b9d06bd1a19f0b19513ef285505231dcf1cba9c"}}, {"rule": 2, "type": "equivalent", "target": "904360e0029d096e5daae91d6704e4d5", "evidence": {"same_day": true, "patch_ids": ["74d41ab4c40159181bb8920ee36a3c7e"], "statement_hash": "a5dd0a05f1c41159d81f38173b9d06bd1a19f0b19513ef285505231dcf1cba9c"}}, {"rule": 2, "type": "equivalent", "target": "d375731f1521db7f32c2863cc0c09f10", "evidence": {"same_day": true, "patch_ids": ["74d41ab4c40159181bb8920ee36a3c7e"], "statement_hash": "a5dd0a05f1c41159d81f38173b9d06bd1a19f0b19513ef285505231dcf1cba9c"}}], "version": "11.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "02eab376408822d258054b57c978ee9a", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "In pg_upgrade, look inside arrays and ranges while searching for non-upgradable data types in tables", "evidence": {"same_day": true, "patch_ids": ["74d41ab4c40159181bb8920ee36a3c7e"], "statement_hash": "a5dd0a05f1c41159d81f38173b9d06bd1a19f0b19513ef285505231dcf1cba9c"}, "url": "/docs/compare/?release=12.2#12.2-f82145fb208b3b57", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "74783fe19c389a77224012f635160ade", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "In pg_upgrade, look inside arrays and ranges while searching for non-upgradable data types in tables", "evidence": {"same_day": true, "patch_ids": ["74d41ab4c40159181bb8920ee36a3c7e"], "statement_hash": "a5dd0a05f1c41159d81f38173b9d06bd1a19f0b19513ef285505231dcf1cba9c"}, "url": "/docs/compare/?release=10.12#10.12-c248a869b953df54", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "0ab2f2ca5c2b135c457c21f3595980b8", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "In pg_upgrade, look inside arrays and ranges while searching for non-upgradable data types in tables", "evidence": {"same_day": true, "patch_ids": ["74d41ab4c40159181bb8920ee36a3c7e"], "statement_hash": "a5dd0a05f1c41159d81f38173b9d06bd1a19f0b19513ef285505231dcf1cba9c"}, "url": "/docs/compare/?release=9.6.17#9.6.17-c248a869b953df54", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "904360e0029d096e5daae91d6704e4d5", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "In pg_upgrade, look inside arrays and ranges while searching for non-upgradable data types in tables", "evidence": {"same_day": true, "patch_ids": ["74d41ab4c40159181bb8920ee36a3c7e"], "statement_hash": "a5dd0a05f1c41159d81f38173b9d06bd1a19f0b19513ef285505231dcf1cba9c"}, "url": "/docs/compare/?release=9.5.21#9.5.21-c248a869b953df54", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "d375731f1521db7f32c2863cc0c09f10", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "In pg_upgrade, look inside arrays and ranges while searching for non-upgradable data types in tables", "evidence": {"same_day": true, "patch_ids": ["74d41ab4c40159181bb8920ee36a3c7e"], "statement_hash": "a5dd0a05f1c41159d81f38173b9d06bd1a19f0b19513ef285505231dcf1cba9c"}, "url": "/docs/compare/?release=9.4.26#9.4.26-c248a869b953df54", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-c82669648badfdbd", "cves": [], "html": "Apply more thorough syntax checking to createuser's --connection-limit option (Álvaro Herrera)
Cope with changes of the specific type referenced by a PL/pgSQL composite-type variable in more cases (Ashutosh Sharma, Tom Lane)
\nDropping and re-creating the composite type referenced by a PL/pgSQL variable could lead to “could not open relation with OID NNNN” errors.
Avoid crash in postgres_fdw when trying to send a command like UPDATE remote_tab SET (x,y) = (SELECT ...) to the remote server (Tom Lane)
In contrib/dict_int, reject maxlen settings less than one (Tomas Vondra)
This prevents a possible crash with silly settings for that parameter.
", "text": "In contrib/dict_int, reject maxlen settings less than one (Tomas Vondra) This prevents a possible crash with silly settings for that parameter.", "title": "In contrib/dict_int, reject maxlen settings less than one", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "3adc0776daf9fa8018174f6f048b202a5d4a675bb49458ccba5f578bd5e619a0", "section_path": ["Changes"], "commit_groups": [["267eb954c", "44381b1af", "46ce37b67", "a2fdeb786", "a8a8c6b29", "b52739436", "fabdad822"]], "identity_text": "In contrib/dict_int, reject maxlen settings less than one (Tomas Vondra) This prevents a possible crash with silly settings for that parameter.", "commit_aliases": ["267eb954c", "44381b1af", "46ce37b67", "a2fdeb786", "a8a8c6b29", "b52739436", "fabdad822"], "source_commits": ["267eb954c"], "source_entry_id": "11.7/changes/049", "db_id": "58302165faa498ba63d2b7016ca2c1f1", "patch_ids": ["78950363d28b5b851c829de00fe014dd"], "statement_hash": "d3ed30d197b4f05dcc2cc52d1553b7542cc1246fc43ff2c7d37678facadf864b", "relations": [{"rule": 2, "type": "equivalent", "target": "96dd0d425154ac899e6e4b526f92e194", "evidence": {"same_day": true, "patch_ids": ["78950363d28b5b851c829de00fe014dd"], "statement_hash": "d3ed30d197b4f05dcc2cc52d1553b7542cc1246fc43ff2c7d37678facadf864b"}}, {"rule": 2, "type": "equivalent", "target": "a8e549afa20e818e690acee052bb0448", "evidence": {"same_day": true, "patch_ids": ["78950363d28b5b851c829de00fe014dd"], "statement_hash": "d3ed30d197b4f05dcc2cc52d1553b7542cc1246fc43ff2c7d37678facadf864b"}}, {"rule": 2, "type": "equivalent", "target": "bf83de008875737dca0e646e1d486e02", "evidence": {"same_day": true, "patch_ids": ["78950363d28b5b851c829de00fe014dd"], "statement_hash": "d3ed30d197b4f05dcc2cc52d1553b7542cc1246fc43ff2c7d37678facadf864b"}}, {"rule": 2, "type": "equivalent", "target": "c5e06cb8326bc8a725a74efea95e71ec", "evidence": {"same_day": true, "patch_ids": ["78950363d28b5b851c829de00fe014dd"], "statement_hash": "d3ed30d197b4f05dcc2cc52d1553b7542cc1246fc43ff2c7d37678facadf864b"}}, {"rule": 2, "type": "equivalent", "target": "ed1985f91bf6854da58a13ad7b975fa2", "evidence": {"same_day": true, "patch_ids": ["78950363d28b5b851c829de00fe014dd"], "statement_hash": "d3ed30d197b4f05dcc2cc52d1553b7542cc1246fc43ff2c7d37678facadf864b"}}], "version": "11.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "ed1985f91bf6854da58a13ad7b975fa2", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "In contrib/dict_int, reject maxlen settings less than one", "evidence": {"same_day": true, "patch_ids": ["78950363d28b5b851c829de00fe014dd"], "statement_hash": "d3ed30d197b4f05dcc2cc52d1553b7542cc1246fc43ff2c7d37678facadf864b"}, "url": "/docs/compare/?release=12.2#12.2-7cdd017124b2400a", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "bf83de008875737dca0e646e1d486e02", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "In contrib/dict_int, reject maxlen settings less than one", "evidence": {"same_day": true, "patch_ids": ["78950363d28b5b851c829de00fe014dd"], "statement_hash": "d3ed30d197b4f05dcc2cc52d1553b7542cc1246fc43ff2c7d37678facadf864b"}, "url": "/docs/compare/?release=10.12#10.12-227a20364adab964", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "c5e06cb8326bc8a725a74efea95e71ec", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "In contrib/dict_int, reject maxlen settings less than one", "evidence": {"same_day": true, "patch_ids": ["78950363d28b5b851c829de00fe014dd"], "statement_hash": "d3ed30d197b4f05dcc2cc52d1553b7542cc1246fc43ff2c7d37678facadf864b"}, "url": "/docs/compare/?release=9.6.17#9.6.17-227a20364adab964", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "96dd0d425154ac899e6e4b526f92e194", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "In contrib/dict_int, reject maxlen settings less than one", "evidence": {"same_day": true, "patch_ids": ["78950363d28b5b851c829de00fe014dd"], "statement_hash": "d3ed30d197b4f05dcc2cc52d1553b7542cc1246fc43ff2c7d37678facadf864b"}, "url": "/docs/compare/?release=9.5.21#9.5.21-227a20364adab964", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "a8e549afa20e818e690acee052bb0448", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "In contrib/dict_int, reject maxlen settings less than one", "evidence": {"same_day": true, "patch_ids": ["78950363d28b5b851c829de00fe014dd"], "statement_hash": "d3ed30d197b4f05dcc2cc52d1553b7542cc1246fc43ff2c7d37678facadf864b"}, "url": "/docs/compare/?release=9.4.26#9.4.26-227a20364adab964", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-614650e052f4f656", "cves": [], "html": "Disallow NULL category values in contrib/tablefunc's crosstab() function (Joe Conway)
This case never worked usefully, and it would crash on some platforms.
", "text": "Disallow NULL category values in contrib/tablefunc's crosstab() function (Joe Conway) This case never worked usefully, and it would crash on some platforms.", "title": "Disallow NULL category values in contrib/tablefunc's crosstab() function", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "2f2dbc7486f1dbc6a2455690eb9820298baef953d4326e31d0b555c6c121ed90", "section_path": ["Changes"], "commit_groups": [["3757c1640", "4a3cdb531", "70fc6c4ef", "81be0c57e", "b5e7569dd", "d5b9c2baf", "f49e5efbc"]], "identity_text": "Disallow NULL category values in contrib/tablefunc's crosstab() function (Joe Conway) This case never worked usefully, and it would crash on some platforms.", "commit_aliases": ["3757c1640", "4a3cdb531", "70fc6c4ef", "81be0c57e", "b5e7569dd", "d5b9c2baf", "f49e5efbc"], "source_commits": ["f49e5efbc"], "source_entry_id": "11.7/changes/050", "db_id": "b22fe0463a8bcce1b8fec6a9c289d8b5", "patch_ids": ["f2a9c1eb425c6456d03f47fabd3d3e7e"], "statement_hash": "0bde96774dd728bfb5560fb48ede623d28e36ff4adc4a371bf0dd6f6456a87fe", "relations": [{"rule": 2, "type": "equivalent", "target": "09f5d81b24b38998d7a990a50ac72fc3", "evidence": {"same_day": true, "patch_ids": ["f2a9c1eb425c6456d03f47fabd3d3e7e"], "statement_hash": "0bde96774dd728bfb5560fb48ede623d28e36ff4adc4a371bf0dd6f6456a87fe"}}, {"rule": 2, "type": "equivalent", "target": "0b8ef0b2e246e06e7f1a9fc3eaf980ff", "evidence": {"same_day": true, "patch_ids": ["f2a9c1eb425c6456d03f47fabd3d3e7e"], "statement_hash": "0bde96774dd728bfb5560fb48ede623d28e36ff4adc4a371bf0dd6f6456a87fe"}}, {"rule": 2, "type": "equivalent", "target": "0c98a8da40ed6ad88d98ca9f21729dfc", "evidence": {"same_day": true, "patch_ids": ["f2a9c1eb425c6456d03f47fabd3d3e7e"], "statement_hash": "0bde96774dd728bfb5560fb48ede623d28e36ff4adc4a371bf0dd6f6456a87fe"}}, {"rule": 2, "type": "equivalent", "target": "23016bbb0168f2db4667294c322483f7", "evidence": {"same_day": true, "patch_ids": ["f2a9c1eb425c6456d03f47fabd3d3e7e"], "statement_hash": "0bde96774dd728bfb5560fb48ede623d28e36ff4adc4a371bf0dd6f6456a87fe"}}, {"rule": 2, "type": "equivalent", "target": "f83454331b5ef1e28904b1610d5ddd72", "evidence": {"same_day": true, "patch_ids": ["f2a9c1eb425c6456d03f47fabd3d3e7e"], "statement_hash": "0bde96774dd728bfb5560fb48ede623d28e36ff4adc4a371bf0dd6f6456a87fe"}}], "version": "11.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "23016bbb0168f2db4667294c322483f7", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Disallow NULL category values in contrib/tablefunc's crosstab() function", "evidence": {"same_day": true, "patch_ids": ["f2a9c1eb425c6456d03f47fabd3d3e7e"], "statement_hash": "0bde96774dd728bfb5560fb48ede623d28e36ff4adc4a371bf0dd6f6456a87fe"}, "url": "/docs/compare/?release=12.2#12.2-1cc3d7186ea0c38f", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "f83454331b5ef1e28904b1610d5ddd72", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Disallow NULL category values in contrib/tablefunc's crosstab() function", "evidence": {"same_day": true, "patch_ids": ["f2a9c1eb425c6456d03f47fabd3d3e7e"], "statement_hash": "0bde96774dd728bfb5560fb48ede623d28e36ff4adc4a371bf0dd6f6456a87fe"}, "url": "/docs/compare/?release=10.12#10.12-614650e052f4f656", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "0c98a8da40ed6ad88d98ca9f21729dfc", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "Disallow NULL category values in contrib/tablefunc's crosstab() function", "evidence": {"same_day": true, "patch_ids": ["f2a9c1eb425c6456d03f47fabd3d3e7e"], "statement_hash": "0bde96774dd728bfb5560fb48ede623d28e36ff4adc4a371bf0dd6f6456a87fe"}, "url": "/docs/compare/?release=9.6.17#9.6.17-614650e052f4f656", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "09f5d81b24b38998d7a990a50ac72fc3", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "Disallow NULL category values in contrib/tablefunc's crosstab() function", "evidence": {"same_day": true, "patch_ids": ["f2a9c1eb425c6456d03f47fabd3d3e7e"], "statement_hash": "0bde96774dd728bfb5560fb48ede623d28e36ff4adc4a371bf0dd6f6456a87fe"}, "url": "/docs/compare/?release=9.5.21#9.5.21-614650e052f4f656", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "0b8ef0b2e246e06e7f1a9fc3eaf980ff", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "Disallow NULL category values in contrib/tablefunc's crosstab() function", "evidence": {"same_day": true, "patch_ids": ["f2a9c1eb425c6456d03f47fabd3d3e7e"], "statement_hash": "0bde96774dd728bfb5560fb48ede623d28e36ff4adc4a371bf0dd6f6456a87fe"}, "url": "/docs/compare/?release=9.4.26#9.4.26-614650e052f4f656", "source_url": "/docs/release/9.4.26/#AEN119822"}]}, {"id": "11.7-23f7ac707e75885b", "cves": [], "html": "Fix configure's probe for OpenSSL's SSL_clear_options() function so that it works with OpenSSL versions before 1.1.0 (Michael Paquier, Daniel Gustafsson)
This problem could lead to failure to set the SSL compression option as desired, when PostgreSQL is built against an old version of OpenSSL.
", "text": "Fix configure's probe for OpenSSL's SSL_clear_options() function so that it works with OpenSSL versions before 1.1.0 (Michael Paquier, Daniel Gustafsson) This problem could lead to failure to set the SSL compression option as desired, when PostgreSQL is built against an old version of OpenSSL.", "title": "Fix configure's probe for OpenSSL's SSL_clear_options() function so that it works with OpenSSL versions before 1.1.0", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "4a95cbc90dc2360455935fdc30e7be973cbc817f18dd1e9ea4e3adf51332ea92", "section_path": ["Changes"], "commit_groups": [["7ad544fd8", "7d0bcb047", "902276ff1"]], "identity_text": "Fix configure's probe for OpenSSL's SSL_clear_options() function so that it works with OpenSSL versions before 1.1.0 (Michael Paquier, Daniel Gustafsson) This problem could lead to failure to set the SSL compression option as desired, when PostgreSQL is built against an old version of OpenSSL.", "commit_aliases": ["7ad544fd8", "7d0bcb047", "902276ff1"], "source_commits": ["7ad544fd8"], "source_entry_id": "11.7/changes/051", "db_id": "c53db75accf4eb42a59ebbf1617d4639", "patch_ids": ["a3af96f60931b92e2820bc32238fb808"], "statement_hash": "f99980f2e8067c6f709e6b72a60d2820a4a268817c75ccaefe9c7206eec04f57", "relations": [{"rule": 2, "type": "equivalent", "target": "7fe0c37d2fef050f15dcec6bf871dcb2", "evidence": {"same_day": true, "patch_ids": ["a3af96f60931b92e2820bc32238fb808"], "statement_hash": "f99980f2e8067c6f709e6b72a60d2820a4a268817c75ccaefe9c7206eec04f57"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "7fe0c37d2fef050f15dcec6bf871dcb2", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Fix configure's probe for OpenSSL's SSL_clear_options() function so that it works with OpenSSL versions before 1.1.0", "evidence": {"same_day": true, "patch_ids": ["a3af96f60931b92e2820bc32238fb808"], "statement_hash": "f99980f2e8067c6f709e6b72a60d2820a4a268817c75ccaefe9c7206eec04f57"}, "url": "/docs/compare/?release=12.2#12.2-421bd296ff2ec2cf", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}]}, {"id": "11.7-d5fd423015c1a507", "cves": [], "html": "Mark some timeout and statistics-tracking GUC variables as PGDLLIMPORT, to allow extensions to access them on Windows (Pascal Legrand)
This applies to idle_in_transaction_session_timeout, lock_timeout, statement_timeout, track_activities, track_counts, and track_functions.
Avoid memory leak in sanity checks for “slab” memory contexts (Tomas Vondra)
\nThis isn't an issue for production builds, since they wouldn't ordinarily have memory context checking enabled; but the leak could be quite severe in a debug build.
", "text": "Avoid memory leak in sanity checks for “slab” memory contexts (Tomas Vondra) This isn't an issue for production builds, since they wouldn't ordinarily have memory context checking enabled; but the leak could be quite severe in a debug build.", "title": "Avoid memory leak in sanity checks for “slab” memory contexts", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "9b9dcc64e3d46b2a54aceafe23d7598aa6f9c4822dddb303a7f97c5139851d40", "section_path": ["Changes"], "commit_groups": [["162c951df", "543852fd8", "8c37e4469", "a801452c9"]], "identity_text": "Avoid memory leak in sanity checks for slab memory contexts (Tomas Vondra) This isn't an issue for production builds, since they wouldn't ordinarily have memory context checking enabled; but the leak could be quite severe in a debug build.", "commit_aliases": ["162c951df", "543852fd8", "8c37e4469", "a801452c9"], "source_commits": ["8c37e4469"], "source_entry_id": "11.7/changes/053", "db_id": "b040cacec93c526d6f8045a1c4409637", "patch_ids": ["2415e06c3b6a2f2d0cfd58352b77b276"], "statement_hash": "c29c1600c9463b877d9882e04cc1b4b8b43eb199478e414c74a86cee95b9d008", "relations": [{"rule": 2, "type": "equivalent", "target": "0d32ad5ea6ecce2ce28859d0a916f224", "evidence": {"same_day": true, "patch_ids": ["2415e06c3b6a2f2d0cfd58352b77b276"], "statement_hash": "c29c1600c9463b877d9882e04cc1b4b8b43eb199478e414c74a86cee95b9d008"}}, {"rule": 2, "type": "equivalent", "target": "f710962f9e1676054b073ea4fde7287b", "evidence": {"same_day": true, "patch_ids": ["2415e06c3b6a2f2d0cfd58352b77b276"], "statement_hash": "c29c1600c9463b877d9882e04cc1b4b8b43eb199478e414c74a86cee95b9d008"}}], "version": "11.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "f710962f9e1676054b073ea4fde7287b", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "Avoid memory leak in sanity checks for “slab” memory contexts", "evidence": {"same_day": true, "patch_ids": ["2415e06c3b6a2f2d0cfd58352b77b276"], "statement_hash": "c29c1600c9463b877d9882e04cc1b4b8b43eb199478e414c74a86cee95b9d008"}, "url": "/docs/compare/?release=12.2#12.2-4b66ce98e56205d6", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "0d32ad5ea6ecce2ce28859d0a916f224", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "Avoid memory leak in sanity checks for “slab” memory contexts", "evidence": {"same_day": true, "patch_ids": ["2415e06c3b6a2f2d0cfd58352b77b276"], "statement_hash": "c29c1600c9463b877d9882e04cc1b4b8b43eb199478e414c74a86cee95b9d008"}, "url": "/docs/compare/?release=10.12#10.12-ecce1549e00d60b8", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}]}, {"id": "11.7-4c239160fb81ea09", "cves": [], "html": "Fix multiple statistics entries reported by the LWLock statistics mechanism (Fujii Masao)
\nThe LWLock statistics code (which is not built by default; it requires compiling with -DLWLOCK_STATS) could report multiple entries for the same LWLock and backend process, as a result of faulty hashtable key creation.
Fix race condition that led to delayed delivery of interprocess signals on Windows (Amit Kapila)
\nThis caused visible timing oddities in NOTIFY, and perhaps other misbehavior.
On Windows, retry a few times after an ERROR_ACCESS_DENIED file access failure (Alexander Lakhin, Tom Lane)
This helps cope with cases where a file open attempt fails because the targeted file is flagged for deletion but not yet actually gone. pg_ctl, for example, frequently failed with such an error when probing to see if the postmaster had shut down yet.
", "text": "On Windows, retry a few times after an ERROR_ACCESS_DENIED file access failure (Alexander Lakhin, Tom Lane) This helps cope with cases where a file open attempt fails because the targeted file is flagged for deletion but not yet actually gone. pg_ctl, for example, frequently failed with such an error when probing to see if the postmaster had shut down yet.", "title": "On Windows, retry a few times after an ERROR_ACCESS_DENIED file access failure", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.7/#id-1.11.6.20.5", "source_hash": "a6ca48ebb47ed5e5f6b9f28158bacd166e163792bad79d611b1313312a937fb6", "section_path": ["Changes"], "commit_groups": [["2cf51809b", "65cb25e4f", "6d7547c21", "81b052c31", "95f43fee9", "cd0380351", "cfb2a4cce"], ["35b28d983", "5406513e9", "739201b0e", "90281a3a2", "a69f5697a", "b3c4e2418", "f1a4020ef"]], "identity_text": "On Windows, retry a few times after an ERROR_ACCESS_DENIED file access failure (Alexander Lakhin, Tom Lane) This helps cope with cases where a file open attempt fails because the targeted file is flagged for deletion but not yet actually gone. pg_ctl, for example, frequently failed with such an error when probing to see if the postmaster had shut down yet.", "commit_aliases": ["2cf51809b", "35b28d983", "5406513e9", "65cb25e4f", "6d7547c21", "739201b0e", "81b052c31", "90281a3a2", "95f43fee9", "a69f5697a", "b3c4e2418", "cd0380351", "cfb2a4cce", "f1a4020ef"], "source_commits": ["2cf51809b", "b3c4e2418"], "source_entry_id": "11.7/changes/056", "db_id": "80aca2c94c46e49f87b47a2d683f97b6", "patch_ids": ["4f7ddde8569db93f4efb985cf2c73797", "68e4da864468904995c0aca64baa124e"], "statement_hash": "16ed9ee98fe9b2fb52af29cd28ebb8aa2415c20fbc64574b03e075722d2f85a4", "relations": [{"rule": 2, "type": "equivalent", "target": "1d45d0746c2abeca715f89146c079d6e", "evidence": {"same_day": true, "patch_ids": ["4f7ddde8569db93f4efb985cf2c73797", "68e4da864468904995c0aca64baa124e"], "statement_hash": "16ed9ee98fe9b2fb52af29cd28ebb8aa2415c20fbc64574b03e075722d2f85a4"}}, {"rule": 2, "type": "equivalent", "target": "a372cd6f4bd6a46b1f446180790f0018", "evidence": {"same_day": true, "patch_ids": ["4f7ddde8569db93f4efb985cf2c73797", "68e4da864468904995c0aca64baa124e"], "statement_hash": "16ed9ee98fe9b2fb52af29cd28ebb8aa2415c20fbc64574b03e075722d2f85a4"}}, {"rule": 2, "type": "equivalent", "target": "b36d231a96c8ce7e12ef094f264e0d1e", "evidence": {"same_day": true, "patch_ids": ["4f7ddde8569db93f4efb985cf2c73797", "68e4da864468904995c0aca64baa124e"], "statement_hash": "16ed9ee98fe9b2fb52af29cd28ebb8aa2415c20fbc64574b03e075722d2f85a4"}}, {"rule": 2, "type": "equivalent", "target": "c95685b48848407590a5d75c6e7a9d6c", "evidence": {"same_day": true, "patch_ids": ["4f7ddde8569db93f4efb985cf2c73797", "68e4da864468904995c0aca64baa124e"], "statement_hash": "16ed9ee98fe9b2fb52af29cd28ebb8aa2415c20fbc64574b03e075722d2f85a4"}}, {"rule": 2, "type": "equivalent", "target": "fc0d9ffac866b09801c18dae5e11590a", "evidence": {"same_day": true, "patch_ids": ["4f7ddde8569db93f4efb985cf2c73797", "68e4da864468904995c0aca64baa124e"], "statement_hash": "16ed9ee98fe9b2fb52af29cd28ebb8aa2415c20fbc64574b03e075722d2f85a4"}}], "version": "11.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b36d231a96c8ce7e12ef094f264e0d1e", "kind": "equivalent", "version": "12.2", "label": "12.2", "title": "On Windows, retry a few times after an ERROR_ACCESS_DENIED file access failure", "evidence": {"same_day": true, "patch_ids": ["4f7ddde8569db93f4efb985cf2c73797", "68e4da864468904995c0aca64baa124e"], "statement_hash": "16ed9ee98fe9b2fb52af29cd28ebb8aa2415c20fbc64574b03e075722d2f85a4"}, "url": "/docs/compare/?release=12.2#12.2-c7311c612ca2a77c", "source_url": "/docs/release/12.2/#id-1.11.6.26.5"}, {"db_id": "a372cd6f4bd6a46b1f446180790f0018", "kind": "equivalent", "version": "10.12", "label": "10.12", "title": "On Windows, retry a few times after an ERROR_ACCESS_DENIED file access failure", "evidence": {"same_day": true, "patch_ids": ["4f7ddde8569db93f4efb985cf2c73797", "68e4da864468904995c0aca64baa124e"], "statement_hash": "16ed9ee98fe9b2fb52af29cd28ebb8aa2415c20fbc64574b03e075722d2f85a4"}, "url": "/docs/compare/?release=10.12#10.12-d4abbc9d3203741e", "source_url": "/docs/release/10.12/#id-1.11.6.16.5"}, {"db_id": "fc0d9ffac866b09801c18dae5e11590a", "kind": "equivalent", "version": "9.6.17", "label": "9.6.17", "title": "On Windows, retry a few times after an ERROR_ACCESS_DENIED file access failure", "evidence": {"same_day": true, "patch_ids": ["4f7ddde8569db93f4efb985cf2c73797", "68e4da864468904995c0aca64baa124e"], "statement_hash": "16ed9ee98fe9b2fb52af29cd28ebb8aa2415c20fbc64574b03e075722d2f85a4"}, "url": "/docs/compare/?release=9.6.17#9.6.17-d4abbc9d3203741e", "source_url": "/docs/release/9.6.17/#AEN133104"}, {"db_id": "1d45d0746c2abeca715f89146c079d6e", "kind": "equivalent", "version": "9.5.21", "label": "9.5.21", "title": "On Windows, retry a few times after an ERROR_ACCESS_DENIED file access failure", "evidence": {"same_day": true, "patch_ids": ["4f7ddde8569db93f4efb985cf2c73797", "68e4da864468904995c0aca64baa124e"], "statement_hash": "16ed9ee98fe9b2fb52af29cd28ebb8aa2415c20fbc64574b03e075722d2f85a4"}, "url": "/docs/compare/?release=9.5.21#9.5.21-d4abbc9d3203741e", "source_url": "/docs/release/9.5.21/#AEN127951"}, {"db_id": "c95685b48848407590a5d75c6e7a9d6c", "kind": "equivalent", "version": "9.4.26", "label": "9.4.26", "title": "On Windows, retry a few times after an ERROR_ACCESS_DENIED file access failure", "evidence": {"same_day": true, "patch_ids": ["4f7ddde8569db93f4efb985cf2c73797", "68e4da864468904995c0aca64baa124e"], "statement_hash": "16ed9ee98fe9b2fb52af29cd28ebb8aa2415c20fbc64574b03e075722d2f85a4"}, "url": "/docs/compare/?release=9.4.26#9.4.26-d4abbc9d3203741e", "source_url": "/docs/release/9.4.26/#AEN119822"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 56}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 29}, {"key": "security", "label": "Security", "count": 2}, {"key": "performance", "label": "Performance", "count": 1}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 24}], "total": 56, "release_count": 1, "cross_major": false, "cve_count": 2, "cves": [{"id": "CVE-2017-7484", "url": "https://www.postgresql.org/support/security/CVE-2017-7484/", "fixed": {"9.2": "9.2.21", "9.3": "9.3.17", "9.4": "9.4.12", "9.5": "9.5.7", "9.6": "9.6.3"}, "score": 4.3, "title": "Allow the planner to apply potentially-leaky tests to child-table statistics, if the user can read the corresponding column of the table that's actually named in the query", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N", "affected": {"9.2": "9.2", "9.3": "9.3", "9.4": "9.4", "9.5": "9.5", "9.6": "9.6"}, "component": "core server", "published": {"9.2": "2017-05-11", "9.3": "2017-05-11", "9.4": "2017-05-11", "9.5": "2017-05-11", "9.6": "2017-05-11"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2017-05-11", "fixed_version": ""}, {"id": "CVE-2020-1720", "url": "https://www.postgresql.org/support/security/CVE-2020-1720/", "fixed": {"10": "10.12", "11": "11.7", "12": "12.2", "9.6": "9.6.17"}, "score": 3.1, "title": "Add missing permissions checks for ALTER ... DEPENDS ON EXTENSION", "vector": "AV:N/AC:H/PR:L/UI:N/S:U/C:N/I:L/A:N", "affected": {"10": "10", "11": "11", "12": "12", "9.6": "9.6"}, "component": "core server", "published": {"10": "2020-02-13", "11": "2020-02-13", "12": "2020-02-13", "9.6": "2020-02-13"}, "introduced": {}, "cvss_version": "3.0", "description_en": "The ALTER ... DEPENDS ON EXTENSION sub-commands do not perform authorization checks, which can allow an unprivileged user to drop any function, procedure, materialized view, index, or trigger under certain conditions. This attack is possible if an administrator has installed an extension and an unprivileged user can CREATE , or an extension owner either executes DROP EXTENSION predictably or can be convinced to execute DROP EXTENSION .\n\nThe PostgreSQL project thanks Tom Lane for reporting this problem.", "first_published": "2020-02-13", "fixed_version": "11.7"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 56, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}