A dump/restore is not required for those running 9.6.X.
\nHowever, if you use BRIN indexes, see the fourth changelog entry below.
\nAlso, if you are upgrading from a version earlier than 9.6.4, see Section E.21.
", "compatibility_count": 0, "label": "9.6.6", "status_label": "Historical", "eol": "2021-11-11", "age_days": 3246, "support_days": -1783}, "groups": [{"date": "2017-11-09", "build": "9.6.6", "major": "9.6", "minor": 6, "manual": "9.6", "status": "stable", "doc_git": "", "version": "9.6.6", "eol_date": "2021-11-11", "date_text": "2017-11-09", "supported": false, "manual_url": "/docs/9.6/release-9-6-6.html", "source_url": "/docs/release/9.6.6/", "entry_count": 38, "placeholder": false, "content_hash": "854f3a7425759943d5e7e953b0140109b623233b5e44d19bd56d64fdd90b3a72", "manual_build": "9.6.24", "source_as_of": "", "changes_count": 38, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 9.6.X.
\nHowever, if you use BRIN indexes, see the fourth changelog entry below.
\nAlso, if you are upgrading from a version earlier than 9.6.4, see Section E.21.
", "compatibility_count": 0, "label": "9.6.6", "status_label": "Historical", "eol": "2021-11-11", "age_days": 3246, "support_days": -1783, "entries": [{"id": "9.6.6-2dbffb70763fdb21", "cves": ["CVE-2017-15099"], "html": "Ensure that INSERT ... ON CONFLICT DO UPDATE checks table permissions and RLS policies in all cases (Dean Rasheed)
\nThe update path of INSERT ... ON CONFLICT DO UPDATE requires SELECT permission on the columns of the arbiter index, but it failed to check for that in the case of an arbiter specified by constraint name. In addition, for a table with row level security enabled, it failed to check updated rows against the table's SELECT policies (regardless of how the arbiter index was specified). (CVE-2017-15099)
", "text": "Ensure that INSERT ... ON CONFLICT DO UPDATE checks table permissions and RLS policies in all cases (Dean Rasheed) The update path of INSERT ... ON CONFLICT DO UPDATE requires SELECT permission on the columns of the arbiter index, but it failed to check for that in the case of an arbiter specified by constraint name. In addition, for a table with row level security enabled, it failed to check updated rows against the table's SELECT policies (regardless of how the arbiter index was specified). (CVE-2017-15099)", "title": "Ensure that INSERT ... ON CONFLICT DO UPDATE checks table permissions and RLS policies in all cases", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "ad95f0bb915c37b3bdc31c0c08e55207936989064014b08bcb3f48c03e7aec3d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ensure that INSERT ... ON CONFLICT DO UPDATE checks table permissions and RLS policies in all cases (Dean Rasheed) The update path of INSERT ... ON CONFLICT DO UPDATE requires SELECT permission on the columns of the arbiter index, but it failed to check for that in the case of an arbiter specified by constraint name. In addition, for a table with row level security enabled, it failed to check updated rows against the table's SELECT policies (regardless of how the arbiter index was specified). (CVE-2017-15099)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/001", "db_id": "66a5de7ed1ca2500e13ee943ddddeed2", "patch_ids": [], "statement_hash": "bdc7b72eb6e30c77a50b455cdec45ebcf7510aef8909d086284ef0df873502c0", "relations": [{"rule": 2, "type": "equivalent", "target": "380f4bcd3b093f63238d5eb7ca39ec32", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bdc7b72eb6e30c77a50b455cdec45ebcf7510aef8909d086284ef0df873502c0"}}, {"rule": 2, "type": "equivalent", "target": "401afe0c5f64400e64b520a851b9dee3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bdc7b72eb6e30c77a50b455cdec45ebcf7510aef8909d086284ef0df873502c0"}}], "version": "9.6.6", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "380f4bcd3b093f63238d5eb7ca39ec32", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Ensure that INSERT ... ON CONFLICT DO UPDATE checks table permissions and RLS policies in all cases", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bdc7b72eb6e30c77a50b455cdec45ebcf7510aef8909d086284ef0df873502c0"}, "url": "/docs/compare/?release=10.1#10.1-2dbffb70763fdb21", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "401afe0c5f64400e64b520a851b9dee3", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Ensure that INSERT ... ON CONFLICT DO UPDATE checks table permissions and RLS policies in all cases", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bdc7b72eb6e30c77a50b455cdec45ebcf7510aef8909d086284ef0df873502c0"}, "url": "/docs/compare/?release=9.5.10#9.5.10-2dbffb70763fdb21", "source_url": "/docs/release/9.5.10/#AEN129619"}]}, {"id": "9.6.6-8f5e43f4393b2f79", "cves": ["CVE-2017-15098"], "html": "Fix crash due to rowtype mismatch in json{b}_populate_recordset() (Michael Paquier, Tom Lane)
These functions used the result rowtype specified in the FROM ... AS clause without checking that it matched the actual rowtype of the supplied tuple value. If it didn't, that would usually result in a crash, though disclosure of server memory contents seems possible as well. (CVE-2017-15098)
", "text": "Fix crash due to rowtype mismatch in json{b}_populate_recordset() (Michael Paquier, Tom Lane) These functions used the result rowtype specified in the FROM ... AS clause without checking that it matched the actual rowtype of the supplied tuple value. If it didn't, that would usually result in a crash, though disclosure of server memory contents seems possible as well. (CVE-2017-15098)", "title": "Fix crash due to rowtype mismatch in json{b}_populate_recordset()", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "ef466fc108438644ee2dc61b75f79e9bac08d4dc2756adf24052f57bd91bad06", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix crash due to rowtype mismatch in json{b}_populate_recordset() (Michael Paquier, Tom Lane) These functions used the result rowtype specified in the FROM ... AS clause without checking that it matched the actual rowtype of the supplied tuple value. If it didn't, that would usually result in a crash, though disclosure of server memory contents seems possible as well. (CVE-2017-15098)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/002", "db_id": "191926bdadf659c16bd799b814e0d447", "patch_ids": [], "statement_hash": "a69b26be09366182ddf5eb40831198aab8c3cc1e4caed1e36f829ab7d9245ebf", "relations": [{"rule": 2, "type": "equivalent", "target": "37b394189e78d2a3b737d155e68d704d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a69b26be09366182ddf5eb40831198aab8c3cc1e4caed1e36f829ab7d9245ebf"}}, {"rule": 2, "type": "equivalent", "target": "399e2c79d4fb41c334e3d99840aff867", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a69b26be09366182ddf5eb40831198aab8c3cc1e4caed1e36f829ab7d9245ebf"}}, {"rule": 2, "type": "equivalent", "target": "b357626c41922e96515309927cc03818", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a69b26be09366182ddf5eb40831198aab8c3cc1e4caed1e36f829ab7d9245ebf"}}, {"rule": 2, "type": "equivalent", "target": "ea0d6ab24e73c65a676e3d498331a15d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a69b26be09366182ddf5eb40831198aab8c3cc1e4caed1e36f829ab7d9245ebf"}}], "version": "9.6.6", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "37b394189e78d2a3b737d155e68d704d", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Fix crash due to rowtype mismatch in json{b}_populate_recordset()", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a69b26be09366182ddf5eb40831198aab8c3cc1e4caed1e36f829ab7d9245ebf"}, "url": "/docs/compare/?release=10.1#10.1-8f5e43f4393b2f79", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "ea0d6ab24e73c65a676e3d498331a15d", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Fix crash due to rowtype mismatch in json{b}_populate_recordset()", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a69b26be09366182ddf5eb40831198aab8c3cc1e4caed1e36f829ab7d9245ebf"}, "url": "/docs/compare/?release=9.5.10#9.5.10-8f5e43f4393b2f79", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "399e2c79d4fb41c334e3d99840aff867", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Fix crash due to rowtype mismatch in json{b}_populate_recordset()", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a69b26be09366182ddf5eb40831198aab8c3cc1e4caed1e36f829ab7d9245ebf"}, "url": "/docs/compare/?release=9.4.15#9.4.15-8f5e43f4393b2f79", "source_url": "/docs/release/9.4.15/#AEN121301"}, {"db_id": "b357626c41922e96515309927cc03818", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "Fix crash due to rowtype mismatch in json{b}_populate_recordset()", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a69b26be09366182ddf5eb40831198aab8c3cc1e4caed1e36f829ab7d9245ebf"}, "url": "/docs/compare/?release=9.3.20#9.3.20-8f5e43f4393b2f79", "source_url": "/docs/release/9.3.20/#AEN115749"}]}, {"id": "9.6.6-2ffb7678a5f366f4", "cves": ["CVE-2017-12172"], "html": "Fix sample server-start scripts to become $PGUSER before opening $PGLOG (Noah Misch)
\nPreviously, the postmaster log file was opened while still running as root. The database owner could therefore mount an attack against another system user by making $PGLOG be a symbolic link to some other file, which would then become corrupted by appending log messages.
\nBy default, these scripts are not installed anywhere. Users who have made use of them will need to manually recopy them, or apply the same changes to their modified versions. If the existing $PGLOG file is root-owned, it will need to be removed or renamed out of the way before restarting the server with the corrected script. (CVE-2017-12172)
", "text": "Fix sample server-start scripts to become $PGUSER before opening $PGLOG (Noah Misch) Previously, the postmaster log file was opened while still running as root. The database owner could therefore mount an attack against another system user by making $PGLOG be a symbolic link to some other file, which would then become corrupted by appending log messages. By default, these scripts are not installed anywhere. Users who have made use of them will need to manually recopy them, or apply the same changes to their modified versions. If the existing $PGLOG file is root-owned, it will need to be removed or renamed out of the way before restarting the server with the corrected script. (CVE-2017-12172)", "title": "Fix sample server-start scripts to become $PGUSER before opening $PGLOG", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "17f45a4e936bdb211703990d45e492564f7733ce7f335aa8398a2a6cdd12bfa0", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix sample server-start scripts to become $PGUSER before opening $PGLOG (Noah Misch) Previously, the postmaster log file was opened while still running as root. The database owner could therefore mount an attack against another system user by making $PGLOG be a symbolic link to some other file, which would then become corrupted by appending log messages. By default, these scripts are not installed anywhere. Users who have made use of them will need to manually recopy them, or apply the same changes to their modified versions. If the existing $PGLOG file is root-owned, it will need to be removed or renamed out of the way before restarting the server with the corrected script. (CVE-2017-12172)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/003", "db_id": "a859dd3ad16413efde5ed5f881f08378", "patch_ids": [], "statement_hash": "a05e5494d35e22e6034cd6cf9b331d83ceac1c7dd16696fb61f89bfd812c00de", "relations": [{"rule": 2, "type": "equivalent", "target": "061da361dc80476b681c7c5d03fc708b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a05e5494d35e22e6034cd6cf9b331d83ceac1c7dd16696fb61f89bfd812c00de"}}, {"rule": 2, "type": "equivalent", "target": "1841cb200c58de883289108126c8e6b6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a05e5494d35e22e6034cd6cf9b331d83ceac1c7dd16696fb61f89bfd812c00de"}}, {"rule": 2, "type": "equivalent", "target": "58dc708b44515e2bcbaa8e8e039dbcca", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a05e5494d35e22e6034cd6cf9b331d83ceac1c7dd16696fb61f89bfd812c00de"}}, {"rule": 2, "type": "equivalent", "target": "a81505d07ebbef14783cac259f1cc534", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a05e5494d35e22e6034cd6cf9b331d83ceac1c7dd16696fb61f89bfd812c00de"}}, {"rule": 2, "type": "equivalent", "target": "e16d073a3ea0513c2861cddeed4600e4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a05e5494d35e22e6034cd6cf9b331d83ceac1c7dd16696fb61f89bfd812c00de"}}], "version": "9.6.6", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "061da361dc80476b681c7c5d03fc708b", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Fix sample server-start scripts to become $PGUSER before opening $PGLOG", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a05e5494d35e22e6034cd6cf9b331d83ceac1c7dd16696fb61f89bfd812c00de"}, "url": "/docs/compare/?release=10.1#10.1-2ffb7678a5f366f4", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "e16d073a3ea0513c2861cddeed4600e4", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Fix sample server-start scripts to become $PGUSER before opening $PGLOG", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a05e5494d35e22e6034cd6cf9b331d83ceac1c7dd16696fb61f89bfd812c00de"}, "url": "/docs/compare/?release=9.5.10#9.5.10-2ffb7678a5f366f4", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "1841cb200c58de883289108126c8e6b6", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Fix sample server-start scripts to become $PGUSER before opening $PGLOG", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a05e5494d35e22e6034cd6cf9b331d83ceac1c7dd16696fb61f89bfd812c00de"}, "url": "/docs/compare/?release=9.4.15#9.4.15-2ffb7678a5f366f4", "source_url": "/docs/release/9.4.15/#AEN121301"}, {"db_id": "58dc708b44515e2bcbaa8e8e039dbcca", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "Fix sample server-start scripts to become $PGUSER before opening $PGLOG", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a05e5494d35e22e6034cd6cf9b331d83ceac1c7dd16696fb61f89bfd812c00de"}, "url": "/docs/compare/?release=9.3.20#9.3.20-2ffb7678a5f366f4", "source_url": "/docs/release/9.3.20/#AEN115749"}, {"db_id": "a81505d07ebbef14783cac259f1cc534", "kind": "equivalent", "version": "9.2.24", "label": "9.2.24", "title": "Fix sample server-start scripts to become $PGUSER before opening $PGLOG", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a05e5494d35e22e6034cd6cf9b331d83ceac1c7dd16696fb61f89bfd812c00de"}, "url": "/docs/compare/?release=9.2.24#9.2.24-2ffb7678a5f366f4", "source_url": "/docs/release/9.2.24/#AEN110823"}]}, {"id": "9.6.6-3bcf8b8acae537e7", "cves": [], "html": "Fix BRIN index summarization to handle concurrent table extension correctly (Álvaro Herrera)
\nPreviously, a race condition allowed some table rows to be omitted from the index. It may be necessary to reindex existing BRIN indexes to recover from past occurrences of this problem.
", "text": "Fix BRIN index summarization to handle concurrent table extension correctly (Álvaro Herrera) Previously, a race condition allowed some table rows to be omitted from the index. It may be necessary to reindex existing BRIN indexes to recover from past occurrences of this problem.", "title": "Fix BRIN index summarization to handle concurrent table extension correctly", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "94f35bab3d4627f03ccd1538f7f8aec79faed15192a65af6b5c5587026627413", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix BRIN index summarization to handle concurrent table extension correctly (Álvaro Herrera) Previously, a race condition allowed some table rows to be omitted from the index. It may be necessary to reindex existing BRIN indexes to recover from past occurrences of this problem.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/004", "db_id": "e2e56d22bb5f4dd25374a23426836aee", "patch_ids": [], "statement_hash": "cfdd83034fb7a4ef3ed6e058436900c59d58fb5805ca06dcc36b12967b68fe0b", "relations": [{"rule": 2, "type": "equivalent", "target": "d21d9848fa1bd9d7a5ae1cf39c315556", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cfdd83034fb7a4ef3ed6e058436900c59d58fb5805ca06dcc36b12967b68fe0b"}}, {"rule": 2, "type": "equivalent", "target": "fef51c07bf244be99a243ef30589e76e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cfdd83034fb7a4ef3ed6e058436900c59d58fb5805ca06dcc36b12967b68fe0b"}}], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "d21d9848fa1bd9d7a5ae1cf39c315556", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Fix BRIN index summarization to handle concurrent table extension correctly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cfdd83034fb7a4ef3ed6e058436900c59d58fb5805ca06dcc36b12967b68fe0b"}, "url": "/docs/compare/?release=10.1#10.1-3bcf8b8acae537e7", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "fef51c07bf244be99a243ef30589e76e", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Fix BRIN index summarization to handle concurrent table extension correctly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cfdd83034fb7a4ef3ed6e058436900c59d58fb5805ca06dcc36b12967b68fe0b"}, "url": "/docs/compare/?release=9.5.10#9.5.10-3bcf8b8acae537e7", "source_url": "/docs/release/9.5.10/#AEN129619"}]}, {"id": "9.6.6-e7c2ea76824d95fa", "cves": [], "html": "Fix possible failures during concurrent updates of a BRIN index (Tom Lane)
\nThese race conditions could result in errors like \"invalid index offnum\" or \"inconsistent range map\".
", "text": "Fix possible failures during concurrent updates of a BRIN index (Tom Lane) These race conditions could result in errors like \"invalid index offnum\" or \"inconsistent range map\".", "title": "Fix possible failures during concurrent updates of a BRIN index", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "8d80917ee37ecab2e6e609b396458c77315c669303eb94deb32ba96082280cf7", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix possible failures during concurrent updates of a BRIN index (Tom Lane) These race conditions could result in errors like invalid index offnum or inconsistent range map.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/005", "db_id": "08985ba0a6ef6963aa3d32a2df40e916", "patch_ids": [], "statement_hash": "725c1bbdc816d1d29cf9d27cfffb287c3995e518ceadcdaa4ec968ba2f1d6aa8", "relations": [{"rule": 2, "type": "equivalent", "target": "7b4faca00f475c7c2c6e98dabd155d51", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "725c1bbdc816d1d29cf9d27cfffb287c3995e518ceadcdaa4ec968ba2f1d6aa8"}}, {"rule": 2, "type": "equivalent", "target": "b0bcb6ca9d897036eb61462af2c9cca3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "725c1bbdc816d1d29cf9d27cfffb287c3995e518ceadcdaa4ec968ba2f1d6aa8"}}], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "7b4faca00f475c7c2c6e98dabd155d51", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Fix possible failures during concurrent updates of a BRIN index", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "725c1bbdc816d1d29cf9d27cfffb287c3995e518ceadcdaa4ec968ba2f1d6aa8"}, "url": "/docs/compare/?release=10.1#10.1-e7c2ea76824d95fa", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "b0bcb6ca9d897036eb61462af2c9cca3", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Fix possible failures during concurrent updates of a BRIN index", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "725c1bbdc816d1d29cf9d27cfffb287c3995e518ceadcdaa4ec968ba2f1d6aa8"}, "url": "/docs/compare/?release=9.5.10#9.5.10-e7c2ea76824d95fa", "source_url": "/docs/release/9.5.10/#AEN129619"}]}, {"id": "9.6.6-4104c5bff17cc43f", "cves": [], "html": "Fix crash when logical decoding is invoked from a SPI-using function, in particular any function written in a PL language (Tom Lane)
", "text": "Fix crash when logical decoding is invoked from a SPI-using function, in particular any function written in a PL language (Tom Lane)", "title": "Fix crash when logical decoding is invoked from a SPI-using function, in particular any function written in a PL language", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "b360085a0ce51ecd6986abe0e1f8eae8af49c24478d8cf872a50e48f23e334fa", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix crash when logical decoding is invoked from a SPI-using function, in particular any function written in a PL language (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/006", "db_id": "900b590dedd3fa57b2276a470d16c59c", "patch_ids": [], "statement_hash": "5d534d90b091782b7e8e6fb63af1326c4234a870ddcc902aadfd0ba2ec12577b", "relations": [{"rule": 2, "type": "equivalent", "target": "d7712c8f429e00f2ff58d6d97cfb681b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5d534d90b091782b7e8e6fb63af1326c4234a870ddcc902aadfd0ba2ec12577b"}}, {"rule": 2, "type": "equivalent", "target": "d9b5032f1d268347b703e11848bd7e28", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5d534d90b091782b7e8e6fb63af1326c4234a870ddcc902aadfd0ba2ec12577b"}}, {"rule": 2, "type": "equivalent", "target": "da2723bbe135add5ce39c87e8667a6ed", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5d534d90b091782b7e8e6fb63af1326c4234a870ddcc902aadfd0ba2ec12577b"}}], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "d7712c8f429e00f2ff58d6d97cfb681b", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Fix crash when logical decoding is invoked from a SPI-using function, in particular any function written in a PL language", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5d534d90b091782b7e8e6fb63af1326c4234a870ddcc902aadfd0ba2ec12577b"}, "url": "/docs/compare/?release=10.1#10.1-4104c5bff17cc43f", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "d9b5032f1d268347b703e11848bd7e28", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Fix crash when logical decoding is invoked from a SPI-using function, in particular any function written in a PL language", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5d534d90b091782b7e8e6fb63af1326c4234a870ddcc902aadfd0ba2ec12577b"}, "url": "/docs/compare/?release=9.5.10#9.5.10-4104c5bff17cc43f", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "da2723bbe135add5ce39c87e8667a6ed", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Fix crash when logical decoding is invoked from a SPI-using function, in particular any function written in a PL language", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5d534d90b091782b7e8e6fb63af1326c4234a870ddcc902aadfd0ba2ec12577b"}, "url": "/docs/compare/?release=9.4.15#9.4.15-4104c5bff17cc43f", "source_url": "/docs/release/9.4.15/#AEN121301"}]}, {"id": "9.6.6-80cd98f2eabf7cf3", "cves": [], "html": "Fix incorrect query results when multiple GROUPING SETS columns contain the same simple variable (Tom Lane)
", "text": "Fix incorrect query results when multiple GROUPING SETS columns contain the same simple variable (Tom Lane)", "title": "Fix incorrect query results when multiple GROUPING SETS columns contain the same simple variable", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "3f3de2c1b36ca4b569dfeb214b490de3ca3a3c40093167b1fed909a2fd8394bd", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix incorrect query results when multiple GROUPING SETS columns contain the same simple variable (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/007", "db_id": "4b06ce4f978351a14779b1338f4319ff", "patch_ids": [], "statement_hash": "daccd3681d0a273bdb75c69c5bfd491f5974666fe560bde32acf42475720718a", "relations": [{"rule": 2, "type": "equivalent", "target": "8e496fc9d11aa4b3960a410c2366181a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "daccd3681d0a273bdb75c69c5bfd491f5974666fe560bde32acf42475720718a"}}], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "8e496fc9d11aa4b3960a410c2366181a", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Fix incorrect query results when multiple GROUPING SETS columns contain the same simple variable", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "daccd3681d0a273bdb75c69c5bfd491f5974666fe560bde32acf42475720718a"}, "url": "/docs/compare/?release=10.1#10.1-80cd98f2eabf7cf3", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}]}, {"id": "9.6.6-d1a6afa62078fed4", "cves": [], "html": "Fix incorrect parallelization decisions for nested queries (Amit Kapila, Kuntal Ghosh)
", "text": "Fix incorrect parallelization decisions for nested queries (Amit Kapila, Kuntal Ghosh)", "title": "Fix incorrect parallelization decisions for nested queries", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "d3bbeac5b867517b2bbbf6fc98847e22666b42b53df03963da192c8e5d8990c5", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix incorrect parallelization decisions for nested queries (Amit Kapila, Kuntal Ghosh)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/008", "db_id": "1e2cd78c3594ff86aeccadac0ff8e234", "patch_ids": [], "statement_hash": "d056890804a7e5090d308192b26573b4018efaf824df54bf2b41652dbff0c7e6", "relations": [{"rule": 2, "type": "equivalent", "target": "1efed301fe4077ac7dfb7606c4fe638c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d056890804a7e5090d308192b26573b4018efaf824df54bf2b41652dbff0c7e6"}}], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "1efed301fe4077ac7dfb7606c4fe638c", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Fix incorrect parallelization decisions for nested queries", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d056890804a7e5090d308192b26573b4018efaf824df54bf2b41652dbff0c7e6"}, "url": "/docs/compare/?release=10.1#10.1-d1a6afa62078fed4", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}]}, {"id": "9.6.6-f369d9198d7bb432", "cves": [], "html": "Fix parallel query handling to not fail when a recently-used role is dropped (Amit Kapila)
", "text": "Fix parallel query handling to not fail when a recently-used role is dropped (Amit Kapila)", "title": "Fix parallel query handling to not fail when a recently-used role is dropped", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "c70b742ba431472af48b55a21e72c4a1c13a80730c72e32574523236cadb4fdd", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix parallel query handling to not fail when a recently-used role is dropped (Amit Kapila)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/009", "db_id": "7d3c64014b1cfe7c5c584f1c155750fc", "patch_ids": [], "statement_hash": "15887a9513fa819ff294c6b771d6c3c3f38f1227ebe99e989704178051263aea", "relations": [{"rule": 2, "type": "equivalent", "target": "78fefaa0b6095d499b2030e8a4711de3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "15887a9513fa819ff294c6b771d6c3c3f38f1227ebe99e989704178051263aea"}}], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "78fefaa0b6095d499b2030e8a4711de3", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Fix parallel query handling to not fail when a recently-used role is dropped", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "15887a9513fa819ff294c6b771d6c3c3f38f1227ebe99e989704178051263aea"}, "url": "/docs/compare/?release=10.1#10.1-f369d9198d7bb432", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}]}, {"id": "9.6.6-d3b081bf5044991c", "cves": [], "html": "Fix json_build_array(), json_build_object(), and their jsonb equivalents to handle explicit VARIADIC arguments correctly (Michael Paquier)
Properly reject attempts to convert infinite float values to type numeric (Tom Lane, KaiGai Kohei)
\nPreviously the behavior was platform-dependent.
", "text": "Properly reject attempts to convert infinite float values to type numeric (Tom Lane, KaiGai Kohei) Previously the behavior was platform-dependent.", "title": "Properly reject attempts to convert infinite float values to type numeric", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "c1b81b9ee792fa19da26b9365fc906bb399d53e755553eb7e7c570177bb2404e", "section_path": ["Changes"], "commit_groups": [["07ea925e2", "2e82fba0e", "72d4fd08e", "7769fc000", "ad56dbd6c", "c38575edc", "def03e4bf"]], "identity_text": "Properly reject attempts to convert infinite float values to type numeric (Tom Lane, KaiGai Kohei) Previously the behavior was platform-dependent.", "commit_aliases": ["07ea925e2", "2e82fba0e", "72d4fd08e", "7769fc000", "ad56dbd6c", "c38575edc", "def03e4bf"], "source_commits": ["def03e4bf"], "source_entry_id": "9.6.6/changes/011", "db_id": "f478875aa928332b3c7de8354b92e99d", "patch_ids": ["99f6ab58d300457d4a6fb41d776c284d"], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9", "relations": [{"rule": 2, "type": "equivalent", "target": "1c3b664e169e7db957bffb63f49a583a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9"}}, {"rule": 2, "type": "equivalent", "target": "37d688fc8a40beae324922612cd078f9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9"}}, {"rule": 2, "type": "equivalent", "target": "4099b281f3b22fd6d6338ef9038b428f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9"}}, {"rule": 2, "type": "equivalent", "target": "6fb383dce08a3cd1787f8492c5c597a7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9"}}], "version": "9.6.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "4099b281f3b22fd6d6338ef9038b428f", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Properly reject attempts to convert infinite float values to type numeric", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9"}, "url": "/docs/compare/?release=9.5.10#9.5.10-5aa7071df376ef50", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "37d688fc8a40beae324922612cd078f9", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Properly reject attempts to convert infinite float values to type numeric", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9"}, "url": "/docs/compare/?release=9.4.15#9.4.15-5aa7071df376ef50", "source_url": "/docs/release/9.4.15/#AEN121301"}, {"db_id": "1c3b664e169e7db957bffb63f49a583a", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "Properly reject attempts to convert infinite float values to type numeric", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9"}, "url": "/docs/compare/?release=9.3.20#9.3.20-5aa7071df376ef50", "source_url": "/docs/release/9.3.20/#AEN115749"}, {"db_id": "6fb383dce08a3cd1787f8492c5c597a7", "kind": "equivalent", "version": "9.2.24", "label": "9.2.24", "title": "Properly reject attempts to convert infinite float values to type numeric", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "12edbb64bce651f60a1ebd2487b209c3463a4ce2a7efa8fdbdcdbe56807c60d9"}, "url": "/docs/compare/?release=9.2.24#9.2.24-5aa7071df376ef50", "source_url": "/docs/release/9.2.24/#AEN110823"}]}, {"id": "9.6.6-590c319d616dd274", "cves": [], "html": "Fix corner-case crashes when columns have been added to the end of a view (Tom Lane)
", "text": "Fix corner-case crashes when columns have been added to the end of a view (Tom Lane)", "title": "Fix corner-case crashes when columns have been added to the end of a view", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "7665bd6471f17435461f82cd3ba33cc010afeb4080c8a8cd7897c3dd32b6ff69", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix corner-case crashes when columns have been added to the end of a view (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/012", "db_id": "8a7b9b004774c09111b17cb617d4a36d", "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf", "relations": [{"rule": 2, "type": "equivalent", "target": "5dd9112df0daa106089cd18015b5f07c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}}, {"rule": 2, "type": "equivalent", "target": "89c8e733fdead3c204e3786e2b7c350d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}}, {"rule": 2, "type": "equivalent", "target": "8df8e065b7c9084d432bf1eb20ebef6f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}}, {"rule": 2, "type": "equivalent", "target": "ecb8d6ca4538276779e5fb096fe8c30a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}}, {"rule": 2, "type": "equivalent", "target": "ef97718edf710920c1ada79e912a7394", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}}], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "ef97718edf710920c1ada79e912a7394", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Fix corner-case crashes when columns have been added to the end of a view", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}, "url": "/docs/compare/?release=10.1#10.1-590c319d616dd274", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "89c8e733fdead3c204e3786e2b7c350d", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Fix corner-case crashes when columns have been added to the end of a view", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}, "url": "/docs/compare/?release=9.5.10#9.5.10-590c319d616dd274", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "ecb8d6ca4538276779e5fb096fe8c30a", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Fix corner-case crashes when columns have been added to the end of a view", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}, "url": "/docs/compare/?release=9.4.15#9.4.15-590c319d616dd274", "source_url": "/docs/release/9.4.15/#AEN121301"}, {"db_id": "5dd9112df0daa106089cd18015b5f07c", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "Fix corner-case crashes when columns have been added to the end of a view", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}, "url": "/docs/compare/?release=9.3.20#9.3.20-590c319d616dd274", "source_url": "/docs/release/9.3.20/#AEN115749"}, {"db_id": "8df8e065b7c9084d432bf1eb20ebef6f", "kind": "equivalent", "version": "9.2.24", "label": "9.2.24", "title": "Fix corner-case crashes when columns have been added to the end of a view", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc202eac201ec2d89727efc9ffc5da3f77abe288bd9c4cc36aebb013c0eb2adf"}, "url": "/docs/compare/?release=9.2.24#9.2.24-590c319d616dd274", "source_url": "/docs/release/9.2.24/#AEN110823"}]}, {"id": "9.6.6-1743e4c9326cf361", "cves": [], "html": "Record proper dependencies when a view or rule contains FieldSelect or FieldStore expression nodes (Tom Lane)
\nLack of these dependencies could allow a column or data type DROP to go through when it ought to fail, thereby causing later uses of the view or rule to get errors. This patch does not do anything to protect existing views/rules, only ones created in the future.
", "text": "Record proper dependencies when a view or rule contains FieldSelect or FieldStore expression nodes (Tom Lane) Lack of these dependencies could allow a column or data type DROP to go through when it ought to fail, thereby causing later uses of the view or rule to get errors. This patch does not do anything to protect existing views/rules, only ones created in the future.", "title": "Record proper dependencies when a view or rule contains FieldSelect or FieldStore expression nodes", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "e9f7909483f9b08a0ed13a4381e0bdd6560859e627903da859b4835cfbbbec95", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Record proper dependencies when a view or rule contains FieldSelect or FieldStore expression nodes (Tom Lane) Lack of these dependencies could allow a column or data type DROP to go through when it ought to fail, thereby causing later uses of the view or rule to get errors. This patch does not do anything to protect existing views/rules, only ones created in the future.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/013", "db_id": "160e5bf639315788f17597b7c9e70f34", "patch_ids": [], "statement_hash": "7775d77748b10aa76c0f45a180ac575974ae1a2723d9c049b532d8392ef5ce70", "relations": [{"rule": 2, "type": "equivalent", "target": "007bd13b9c4a811e28128c420f3c0bd1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7775d77748b10aa76c0f45a180ac575974ae1a2723d9c049b532d8392ef5ce70"}}, {"rule": 2, "type": "equivalent", "target": "1cd6dd04f06a325fa1e38208d26fc0fc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7775d77748b10aa76c0f45a180ac575974ae1a2723d9c049b532d8392ef5ce70"}}, {"rule": 2, "type": "equivalent", "target": "1fb24dcf409901f8e7de3ac50cbca74d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7775d77748b10aa76c0f45a180ac575974ae1a2723d9c049b532d8392ef5ce70"}}, {"rule": 2, "type": "equivalent", "target": "290321f4e086f8b0cff30252c554c661", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7775d77748b10aa76c0f45a180ac575974ae1a2723d9c049b532d8392ef5ce70"}}, {"rule": 2, "type": "equivalent", "target": "7e1c2a52c11eebe68320cb6819bb6842", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7775d77748b10aa76c0f45a180ac575974ae1a2723d9c049b532d8392ef5ce70"}}], "version": "9.6.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "1fb24dcf409901f8e7de3ac50cbca74d", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Record proper dependencies when a view or rule contains FieldSelect or FieldStore expression nodes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7775d77748b10aa76c0f45a180ac575974ae1a2723d9c049b532d8392ef5ce70"}, "url": "/docs/compare/?release=10.1#10.1-1743e4c9326cf361", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "290321f4e086f8b0cff30252c554c661", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Record proper dependencies when a view or rule contains FieldSelect or FieldStore expression nodes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7775d77748b10aa76c0f45a180ac575974ae1a2723d9c049b532d8392ef5ce70"}, "url": "/docs/compare/?release=9.5.10#9.5.10-1743e4c9326cf361", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "007bd13b9c4a811e28128c420f3c0bd1", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Record proper dependencies when a view or rule contains FieldSelect or FieldStore expression nodes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7775d77748b10aa76c0f45a180ac575974ae1a2723d9c049b532d8392ef5ce70"}, "url": "/docs/compare/?release=9.4.15#9.4.15-1743e4c9326cf361", "source_url": "/docs/release/9.4.15/#AEN121301"}, {"db_id": "7e1c2a52c11eebe68320cb6819bb6842", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "Record proper dependencies when a view or rule contains FieldSelect or FieldStore expression nodes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7775d77748b10aa76c0f45a180ac575974ae1a2723d9c049b532d8392ef5ce70"}, "url": "/docs/compare/?release=9.3.20#9.3.20-1743e4c9326cf361", "source_url": "/docs/release/9.3.20/#AEN115749"}, {"db_id": "1cd6dd04f06a325fa1e38208d26fc0fc", "kind": "equivalent", "version": "9.2.24", "label": "9.2.24", "title": "Record proper dependencies when a view or rule contains FieldSelect or FieldStore expression nodes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7775d77748b10aa76c0f45a180ac575974ae1a2723d9c049b532d8392ef5ce70"}, "url": "/docs/compare/?release=9.2.24#9.2.24-1743e4c9326cf361", "source_url": "/docs/release/9.2.24/#AEN110823"}]}, {"id": "9.6.6-ece7eb6bb8c13696", "cves": [], "html": "Correctly detect hashability of range data types (Tom Lane)
\nThe planner mistakenly assumed that any range type could be hashed for use in hash joins or hash aggregation, but actually it must check whether the range's subtype has hash support. This does not affect any of the built-in range types, since they're all hashable anyway.
", "text": "Correctly detect hashability of range data types (Tom Lane) The planner mistakenly assumed that any range type could be hashed for use in hash joins or hash aggregation, but actually it must check whether the range's subtype has hash support. This does not affect any of the built-in range types, since they're all hashable anyway.", "title": "Correctly detect hashability of range data types", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "e17e39b07ccca74744ce6855712b2c1ad5406c1fa916a31f2f3135f8a87ccc32", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Correctly detect hashability of range data types (Tom Lane) The planner mistakenly assumed that any range type could be hashed for use in hash joins or hash aggregation, but actually it must check whether the range's subtype has hash support. This does not affect any of the built-in range types, since they're all hashable anyway.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/014", "db_id": "c320085ab5e747c8994f3bccf936161f", "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f", "relations": [{"rule": 2, "type": "equivalent", "target": "1f0ededa100214388e94db4ee785cdd1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}}, {"rule": 2, "type": "equivalent", "target": "29fb35dd9919703bc165f056b889dd49", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}}, {"rule": 2, "type": "equivalent", "target": "402b5b239a6a0c7dee3485212563f74e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}}, {"rule": 2, "type": "equivalent", "target": "7d936341e4451a5527c1deda00cdb8e5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}}, {"rule": 2, "type": "equivalent", "target": "879a1f89d800c2786255bd2ed0d83cfb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}}], "version": "9.6.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "7d936341e4451a5527c1deda00cdb8e5", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Correctly detect hashability of range data types", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}, "url": "/docs/compare/?release=10.1#10.1-ece7eb6bb8c13696", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "29fb35dd9919703bc165f056b889dd49", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Correctly detect hashability of range data types", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}, "url": "/docs/compare/?release=9.5.10#9.5.10-ece7eb6bb8c13696", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "1f0ededa100214388e94db4ee785cdd1", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Correctly detect hashability of range data types", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}, "url": "/docs/compare/?release=9.4.15#9.4.15-ece7eb6bb8c13696", "source_url": "/docs/release/9.4.15/#AEN121301"}, {"db_id": "402b5b239a6a0c7dee3485212563f74e", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "Correctly detect hashability of range data types", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}, "url": "/docs/compare/?release=9.3.20#9.3.20-ece7eb6bb8c13696", "source_url": "/docs/release/9.3.20/#AEN115749"}, {"db_id": "879a1f89d800c2786255bd2ed0d83cfb", "kind": "equivalent", "version": "9.2.24", "label": "9.2.24", "title": "Correctly detect hashability of range data types", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0b606e4b09094861042b0ffff48bff8657aed6e11d3bf9e6b011dd299ca085f"}, "url": "/docs/compare/?release=9.2.24#9.2.24-ece7eb6bb8c13696", "source_url": "/docs/release/9.2.24/#AEN110823"}]}, {"id": "9.6.6-a5e5ac4bdf8d86d6", "cves": [], "html": "Correctly ignore RelabelType expression nodes when determining relation distinctness (David Rowley)
\nThis allows the intended optimization to occur when a subquery has a result column of type varchar.
", "text": "Correctly ignore RelabelType expression nodes when determining relation distinctness (David Rowley) This allows the intended optimization to occur when a subquery has a result column of type varchar.", "title": "Correctly ignore RelabelType expression nodes when determining relation distinctness", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "c0509eb5307b85a4af3fa3b3f5760ec7961da87d421dce1fd394e03d5b88491b", "section_path": ["Changes"], "commit_groups": [["244b4a37e", "6f44fe7f1", "86e4ebb9a", "eeff68396"]], "identity_text": "Correctly ignore RelabelType expression nodes when determining relation distinctness (David Rowley) This allows the intended optimization to occur when a subquery has a result column of type varchar.", "commit_aliases": ["244b4a37e", "6f44fe7f1", "86e4ebb9a", "eeff68396"], "source_commits": ["86e4ebb9a"], "source_entry_id": "9.6.6/changes/015", "db_id": "055b7a3d1881daac24591a733af4f270", "patch_ids": ["b4a8f2c2bd224b16c58bb9154832eaf3"], "statement_hash": "8f7514d306dea285c9cca407aeca4858e7ba70ac2aa72aeea3ebd16891bf6277", "relations": [{"rule": 2, "type": "equivalent", "target": "45d61419995cecc90ff03f20cfaf190b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8f7514d306dea285c9cca407aeca4858e7ba70ac2aa72aeea3ebd16891bf6277"}}], "version": "9.6.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "45d61419995cecc90ff03f20cfaf190b", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Correctly ignore RelabelType expression nodes when determining relation distinctness", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8f7514d306dea285c9cca407aeca4858e7ba70ac2aa72aeea3ebd16891bf6277"}, "url": "/docs/compare/?release=9.5.10#9.5.10-a5e5ac4bdf8d86d6", "source_url": "/docs/release/9.5.10/#AEN129619"}]}, {"id": "9.6.6-293295e0d54666fc", "cves": [], "html": "Prevent sharing transition states between ordered-set aggregates (David Rowley)
\nThis causes a crash with the built-in ordered-set aggregates, and probably with user-written ones as well. v11 and later will include provisions for dealing with such cases safely, but in released branches, just disable the optimization.
", "text": "Prevent sharing transition states between ordered-set aggregates (David Rowley) This causes a crash with the built-in ordered-set aggregates, and probably with user-written ones as well. v11 and later will include provisions for dealing with such cases safely, but in released branches, just disable the optimization.", "title": "Prevent sharing transition states between ordered-set aggregates", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "ea82a6b9a01e6d6c7e5af0cc3585d158dd110337d1f8619c278b7251afce1039", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent sharing transition states between ordered-set aggregates (David Rowley) This causes a crash with the built-in ordered-set aggregates, and probably with user-written ones as well. v11 and later will include provisions for dealing with such cases safely, but in released branches, just disable the optimization.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/016", "db_id": "f3f87a093accaa73052ce9f861e27076", "patch_ids": [], "statement_hash": "0ae8a96a2138ea108fc1473043ff0d43e3cdb4e1a57297037e75b2bce354af6d", "relations": [{"rule": 2, "type": "equivalent", "target": "092e6001cb9a8aa9620c94ad14d364c7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0ae8a96a2138ea108fc1473043ff0d43e3cdb4e1a57297037e75b2bce354af6d"}}], "version": "9.6.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "092e6001cb9a8aa9620c94ad14d364c7", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Prevent sharing transition states between ordered-set aggregates", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0ae8a96a2138ea108fc1473043ff0d43e3cdb4e1a57297037e75b2bce354af6d"}, "url": "/docs/compare/?release=10.1#10.1-293295e0d54666fc", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}]}, {"id": "9.6.6-983dfc0d8681f8be", "cves": [], "html": "Prevent idle_in_transaction_session_timeout from being ignored when a statement_timeout occurred earlier (Lukas Fittl)
", "text": "Prevent idle_in_transaction_session_timeout from being ignored when a statement_timeout occurred earlier (Lukas Fittl)", "title": "Prevent idle_in_transaction_session_timeout from being ignored when a statement_timeout occurred earlier", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "40bfb8a1b9d27babf0a43603fabad86436538c60b08685d2e5706dfca143c424", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent idle_in_transaction_session_timeout from being ignored when a statement_timeout occurred earlier (Lukas Fittl)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/017", "db_id": "548e8d4c4601d14a738a0815679be008", "patch_ids": [], "statement_hash": "ec39841585f2537053b662802fdd93ddef2bb612927f51113af166f8e5e428f2", "relations": [{"rule": 2, "type": "equivalent", "target": "f7d9555b105297a9173d9a3b77e6a376", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ec39841585f2537053b662802fdd93ddef2bb612927f51113af166f8e5e428f2"}}], "version": "9.6.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f7d9555b105297a9173d9a3b77e6a376", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Prevent idle_in_transaction_session_timeout from being ignored when a statement_timeout occurred earlier", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ec39841585f2537053b662802fdd93ddef2bb612927f51113af166f8e5e428f2"}, "url": "/docs/compare/?release=10.1#10.1-983dfc0d8681f8be", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}]}, {"id": "9.6.6-4793898a071dc3cb", "cves": [], "html": "Fix low-probability loss of NOTIFY messages due to XID wraparound (Marko Tiikkaja, Tom Lane)
\nIf a session executed no queries, but merely listened for notifications, for more than 2 billion transactions, it started to miss some notifications from concurrently-committing transactions.
", "text": "Fix low-probability loss of NOTIFY messages due to XID wraparound (Marko Tiikkaja, Tom Lane) If a session executed no queries, but merely listened for notifications, for more than 2 billion transactions, it started to miss some notifications from concurrently-committing transactions.", "title": "Fix low-probability loss of NOTIFY messages due to XID wraparound", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "145f9966f0f7ba240fcf6250d93d493c03c8d85a939083ff03de885b2fbf8ba7", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix low-probability loss of NOTIFY messages due to XID wraparound (Marko Tiikkaja, Tom Lane) If a session executed no queries, but merely listened for notifications, for more than 2 billion transactions, it started to miss some notifications from concurrently-committing transactions.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/018", "db_id": "05363bfd016c01f9ff8549467d914e00", "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33", "relations": [{"rule": 2, "type": "equivalent", "target": "4b506c21e755bed67a575660d8226d50", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}}, {"rule": 2, "type": "equivalent", "target": "6e8a2efa855582392f8aa8b4b0e0a368", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}}, {"rule": 2, "type": "equivalent", "target": "89fcaef7b09acb5d6956f7d490688e6c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}}, {"rule": 2, "type": "equivalent", "target": "b1531f77e7bfc7c36f8dcd1febcf51d1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}}, {"rule": 2, "type": "equivalent", "target": "bd64297a2b9915f0c99497279540ff3d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}}], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4b506c21e755bed67a575660d8226d50", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Fix low-probability loss of NOTIFY messages due to XID wraparound", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}, "url": "/docs/compare/?release=10.1#10.1-4793898a071dc3cb", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "b1531f77e7bfc7c36f8dcd1febcf51d1", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Fix low-probability loss of NOTIFY messages due to XID wraparound", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}, "url": "/docs/compare/?release=9.5.10#9.5.10-4793898a071dc3cb", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "89fcaef7b09acb5d6956f7d490688e6c", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Fix low-probability loss of NOTIFY messages due to XID wraparound", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}, "url": "/docs/compare/?release=9.4.15#9.4.15-4793898a071dc3cb", "source_url": "/docs/release/9.4.15/#AEN121301"}, {"db_id": "bd64297a2b9915f0c99497279540ff3d", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "Fix low-probability loss of NOTIFY messages due to XID wraparound", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}, "url": "/docs/compare/?release=9.3.20#9.3.20-4793898a071dc3cb", "source_url": "/docs/release/9.3.20/#AEN115749"}, {"db_id": "6e8a2efa855582392f8aa8b4b0e0a368", "kind": "equivalent", "version": "9.2.24", "label": "9.2.24", "title": "Fix low-probability loss of NOTIFY messages due to XID wraparound", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "754f0a11ae061b425afa23f87b58cd950497aa5342bd49183f136207b584ef33"}, "url": "/docs/compare/?release=9.2.24#9.2.24-4793898a071dc3cb", "source_url": "/docs/release/9.2.24/#AEN110823"}]}, {"id": "9.6.6-7e92d640e8bc0413", "cves": [], "html": "Avoid SIGBUS crash on Linux when a DSM memory request exceeds the space available in tmpfs (Thomas Munro)
", "text": "Avoid SIGBUS crash on Linux when a DSM memory request exceeds the space available in tmpfs (Thomas Munro)", "title": "Avoid SIGBUS crash on Linux when a DSM memory request exceeds the space available in tmpfs", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "185f7aa71c2da70b91abc08a9a6b821aa33d6b63e2362179656390cdd05c3514", "section_path": ["Changes"], "commit_groups": [["05297416f", "175061222", "3a07a6f3e", "4621c7f7a", "899bd785c"], ["06852f215", "12ac252f9", "5ea96efaa", "d29f30d8c", "e5c058e2e"]], "identity_text": "Avoid SIGBUS crash on Linux when a DSM memory request exceeds the space available in tmpfs (Thomas Munro)", "commit_aliases": ["05297416f", "06852f215", "12ac252f9", "175061222", "3a07a6f3e", "4621c7f7a", "5ea96efaa", "899bd785c", "d29f30d8c", "e5c058e2e"], "source_commits": ["12ac252f9", "175061222"], "source_entry_id": "9.6.6/changes/019", "db_id": "9e790a7a15bc8950390531ea4cda9ba6", "patch_ids": ["1b868ad994c5520b36974010f3e8d33f", "82de841c4f04697489d4214228bac85b"], "statement_hash": "f8dce9fdbf4e026c64abe11362da8dd5fcec4e8b3c73a1814ceb1510ec9c1196", "relations": [{"rule": 2, "type": "equivalent", "target": "24b2167678273fe5bee5ca0dcc18d287", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f8dce9fdbf4e026c64abe11362da8dd5fcec4e8b3c73a1814ceb1510ec9c1196"}}, {"rule": 2, "type": "equivalent", "target": "4fc31ab5ac996071dfe1717b6a669cb9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f8dce9fdbf4e026c64abe11362da8dd5fcec4e8b3c73a1814ceb1510ec9c1196"}}], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4fc31ab5ac996071dfe1717b6a669cb9", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Avoid SIGBUS crash on Linux when a DSM memory request exceeds the space available in tmpfs", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f8dce9fdbf4e026c64abe11362da8dd5fcec4e8b3c73a1814ceb1510ec9c1196"}, "url": "/docs/compare/?release=9.5.10#9.5.10-7e92d640e8bc0413", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "24b2167678273fe5bee5ca0dcc18d287", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Avoid SIGBUS crash on Linux when a DSM memory request exceeds the space available in tmpfs", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f8dce9fdbf4e026c64abe11362da8dd5fcec4e8b3c73a1814ceb1510ec9c1196"}, "url": "/docs/compare/?release=9.4.15#9.4.15-7e92d640e8bc0413", "source_url": "/docs/release/9.4.15/#AEN121301"}]}, {"id": "9.6.6-00e0c63431b33e34", "cves": [], "html": "Reduce the frequency of data flush requests during bulk file copies to avoid performance problems on macOS, particularly with its new APFS file system (Tom Lane)
", "text": "Reduce the frequency of data flush requests during bulk file copies to avoid performance problems on macOS, particularly with its new APFS file system (Tom Lane)", "title": "Reduce the frequency of data flush requests during bulk file copies to avoid performance problems on macOS, particularly with its new APFS file system", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "0786c2c1a621b0354c95253d09e6e1504e9750a08f47c55ecf66ec0618974928", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Reduce the frequency of data flush requests during bulk file copies to avoid performance problems on macOS, particularly with its new APFS file system (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/020", "db_id": "7af6a10c699a0e7429de09f3bc986c2b", "patch_ids": [], "statement_hash": "8196320450dbb8e30d8bfec61d3c92c38a7b4a1b5997ab726901f9d2f08c34fd", "relations": [{"rule": 2, "type": "equivalent", "target": "f4829dad9a01faefb9645777c6032660", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8196320450dbb8e30d8bfec61d3c92c38a7b4a1b5997ab726901f9d2f08c34fd"}}], "version": "9.6.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f4829dad9a01faefb9645777c6032660", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Reduce the frequency of data flush requests during bulk file copies to avoid performance problems on macOS, particularly with its new APFS file system", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8196320450dbb8e30d8bfec61d3c92c38a7b4a1b5997ab726901f9d2f08c34fd"}, "url": "/docs/compare/?release=10.1#10.1-00e0c63431b33e34", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}]}, {"id": "9.6.6-f0db94bb1263e7ec", "cves": [], "html": "Prevent low-probability crash in processing of nested trigger firings (Tom Lane)
", "text": "Prevent low-probability crash in processing of nested trigger firings (Tom Lane)", "title": "Prevent low-probability crash in processing of nested trigger firings", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "e4658d09348010a0e0d8dedb5c7dbd213849a6939fb3fdc72b38441f02268900", "section_path": ["Changes"], "commit_groups": [["27c6619e9", "4cd6cd21d", "66fe509be", "825fac5d3", "b1be33593", "bc0974703", "c0d21bdb8"]], "identity_text": "Prevent low-probability crash in processing of nested trigger firings (Tom Lane)", "commit_aliases": ["27c6619e9", "4cd6cd21d", "66fe509be", "825fac5d3", "b1be33593", "bc0974703", "c0d21bdb8"], "source_commits": ["c0d21bdb8"], "source_entry_id": "9.6.6/changes/021", "db_id": "ed52e2c3034cd22ee4499e231c7702e6", "patch_ids": ["680c7f4565370541f0a8df8b83d41215"], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27", "relations": [{"rule": 2, "type": "equivalent", "target": "0a1940517915a4c2940506f17a5eb707", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27"}}, {"rule": 2, "type": "equivalent", "target": "90bab2f383d8aeb7b288d90321649ca0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27"}}, {"rule": 2, "type": "equivalent", "target": "cf10bd02853e41f70bc1a6f1202f41a5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27"}}, {"rule": 2, "type": "equivalent", "target": "ee96714487e8ca74fd6a107b83a6e2ff", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27"}}], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "cf10bd02853e41f70bc1a6f1202f41a5", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Prevent low-probability crash in processing of nested trigger firings", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27"}, "url": "/docs/compare/?release=9.5.10#9.5.10-f0db94bb1263e7ec", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "ee96714487e8ca74fd6a107b83a6e2ff", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Prevent low-probability crash in processing of nested trigger firings", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27"}, "url": "/docs/compare/?release=9.4.15#9.4.15-f0db94bb1263e7ec", "source_url": "/docs/release/9.4.15/#AEN121301"}, {"db_id": "0a1940517915a4c2940506f17a5eb707", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "Prevent low-probability crash in processing of nested trigger firings", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27"}, "url": "/docs/compare/?release=9.3.20#9.3.20-f0db94bb1263e7ec", "source_url": "/docs/release/9.3.20/#AEN115749"}, {"db_id": "90bab2f383d8aeb7b288d90321649ca0", "kind": "equivalent", "version": "9.2.24", "label": "9.2.24", "title": "Prevent low-probability crash in processing of nested trigger firings", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "006d1de97c84b7cbcfe2e0d1777726daef03c004b4898572ce009e40f3381b27"}, "url": "/docs/compare/?release=9.2.24#9.2.24-f0db94bb1263e7ec", "source_url": "/docs/release/9.2.24/#AEN110823"}]}, {"id": "9.6.6-67a9113d10db4bee", "cves": [], "html": "Allow COPY's FREEZE option to work when the transaction isolation level is REPEATABLE READ or higher (Noah Misch)
\nThis case was unintentionally broken by a previous bug fix.
", "text": "Allow COPY's FREEZE option to work when the transaction isolation level is REPEATABLE READ or higher (Noah Misch) This case was unintentionally broken by a previous bug fix.", "title": "Allow COPY's FREEZE option to work when the transaction isolation level is REPEATABLE READ or higher", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "ebcd21e543a7ce4054ee755ec64f6b7122ba06de631805c8f16d6dbbc67f5752", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Allow COPY's FREEZE option to work when the transaction isolation level is REPEATABLE READ or higher (Noah Misch) This case was unintentionally broken by a previous bug fix.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/022", "db_id": "4e0fe875dc1a2ae9bddc4bfe63ee0c51", "patch_ids": [], "statement_hash": "8c830e72f0a41855906c9743651b44272397678a246d067b0e85f51a046cd8e0", "relations": [{"rule": 2, "type": "equivalent", "target": "a1eff8bc8516f95566bc09b3bdf0a4cd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8c830e72f0a41855906c9743651b44272397678a246d067b0e85f51a046cd8e0"}}, {"rule": 2, "type": "equivalent", "target": "a42f98563f1d49a9c7113c9b2b1e6cb8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8c830e72f0a41855906c9743651b44272397678a246d067b0e85f51a046cd8e0"}}, {"rule": 2, "type": "equivalent", "target": "e1adadf3a7387c490ac8d6d40225524d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8c830e72f0a41855906c9743651b44272397678a246d067b0e85f51a046cd8e0"}}], "version": "9.6.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "e1adadf3a7387c490ac8d6d40225524d", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Allow COPY's FREEZE option to work when the transaction isolation level is REPEATABLE READ or higher", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8c830e72f0a41855906c9743651b44272397678a246d067b0e85f51a046cd8e0"}, "url": "/docs/compare/?release=10.1#10.1-67a9113d10db4bee", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "a42f98563f1d49a9c7113c9b2b1e6cb8", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Allow COPY's FREEZE option to work when the transaction isolation level is REPEATABLE READ or higher", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8c830e72f0a41855906c9743651b44272397678a246d067b0e85f51a046cd8e0"}, "url": "/docs/compare/?release=9.5.10#9.5.10-67a9113d10db4bee", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "a1eff8bc8516f95566bc09b3bdf0a4cd", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Allow COPY's FREEZE option to work when the transaction isolation level is REPEATABLE READ or higher", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8c830e72f0a41855906c9743651b44272397678a246d067b0e85f51a046cd8e0"}, "url": "/docs/compare/?release=9.4.15#9.4.15-67a9113d10db4bee", "source_url": "/docs/release/9.4.15/#AEN121301"}]}, {"id": "9.6.6-7291d0eedffe77a2", "cves": [], "html": "Correctly restore the umask setting when file creation fails in COPY or lo_export() (Peter Eisentraut)
Give a better error message for duplicate column names in ANALYZE (Nathan Bossart)
", "text": "Give a better error message for duplicate column names in ANALYZE (Nathan Bossart)", "title": "Give a better error message for duplicate column names in ANALYZE", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "ced8dd65787dca5f11b90b7a2e301888f37f16198d642e848536bd5e49fdd501", "section_path": ["Changes"], "commit_groups": [["122289a66", "714805010", "a09d8be7d", "a2b1eb234", "b572b435c", "e56facd8b", "ea31541f5"]], "identity_text": "Give a better error message for duplicate column names in ANALYZE (Nathan Bossart)", "commit_aliases": ["122289a66", "714805010", "a09d8be7d", "a2b1eb234", "b572b435c", "e56facd8b", "ea31541f5"], "source_commits": ["ea31541f5"], "source_entry_id": "9.6.6/changes/024", "db_id": "22ac0a7eb2efae8442a871ca457ff739", "patch_ids": ["4c0aede2c793df86a80d063c18d12983"], "statement_hash": "ab8b2493e7abc59672d45cd7637ea419c460e20a440a56c06836d9f415cf8276", "relations": [{"rule": 2, "type": "equivalent", "target": "60275a3ec51db1818065d73cfdeb4050", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ab8b2493e7abc59672d45cd7637ea419c460e20a440a56c06836d9f415cf8276"}}, {"rule": 2, "type": "equivalent", "target": "a11193b5badad905ca7dbc014dd5ee37", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ab8b2493e7abc59672d45cd7637ea419c460e20a440a56c06836d9f415cf8276"}}, {"rule": 2, "type": "equivalent", "target": "c46de2bed8e8f98249da82f83534b4d2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ab8b2493e7abc59672d45cd7637ea419c460e20a440a56c06836d9f415cf8276"}}, {"rule": 2, "type": "equivalent", "target": "dc7ffa3d7d47edfdffb350d21143fdf2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ab8b2493e7abc59672d45cd7637ea419c460e20a440a56c06836d9f415cf8276"}}], "version": "9.6.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "dc7ffa3d7d47edfdffb350d21143fdf2", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Give a better error message for duplicate column names in ANALYZE", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ab8b2493e7abc59672d45cd7637ea419c460e20a440a56c06836d9f415cf8276"}, "url": "/docs/compare/?release=9.5.10#9.5.10-08f9d8fab898f0d1", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "60275a3ec51db1818065d73cfdeb4050", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Give a better error message for duplicate column names in ANALYZE", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ab8b2493e7abc59672d45cd7637ea419c460e20a440a56c06836d9f415cf8276"}, "url": "/docs/compare/?release=9.4.15#9.4.15-08f9d8fab898f0d1", "source_url": "/docs/release/9.4.15/#AEN121301"}, {"db_id": "c46de2bed8e8f98249da82f83534b4d2", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "Give a better error message for duplicate column names in ANALYZE", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ab8b2493e7abc59672d45cd7637ea419c460e20a440a56c06836d9f415cf8276"}, "url": "/docs/compare/?release=9.3.20#9.3.20-08f9d8fab898f0d1", "source_url": "/docs/release/9.3.20/#AEN115749"}, {"db_id": "a11193b5badad905ca7dbc014dd5ee37", "kind": "equivalent", "version": "9.2.24", "label": "9.2.24", "title": "Give a better error message for duplicate column names in ANALYZE", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ab8b2493e7abc59672d45cd7637ea419c460e20a440a56c06836d9f415cf8276"}, "url": "/docs/compare/?release=9.2.24#9.2.24-08f9d8fab898f0d1", "source_url": "/docs/release/9.2.24/#AEN110823"}]}, {"id": "9.6.6-b02310257887d6dd", "cves": [], "html": "Add missing cases in GetCommandLogLevel(), preventing errors when certain SQL commands are used while log_statement is set to ddl (Michael Paquier)
Fix mis-parsing of the last line in a non-newline-terminated pg_hba.conf file (Tom Lane)
", "text": "Fix mis-parsing of the last line in a non-newline-terminated pg_hba.conf file (Tom Lane)", "title": "Fix mis-parsing of the last line in a non-newline-terminated pg_hba.conf file", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "7a8052a7c622151150bcff10910d40cb49acdea2e9fb749d82212ecdf0c51a39", "section_path": ["Changes"], "commit_groups": [["06b2a73ed", "2ac598874", "38f17e8ee", "9e20276e1"]], "identity_text": "Fix mis-parsing of the last line in a non-newline-terminated pg_hba.conf file (Tom Lane)", "commit_aliases": ["06b2a73ed", "2ac598874", "38f17e8ee", "9e20276e1"], "source_commits": ["2ac598874"], "source_entry_id": "9.6.6/changes/026", "db_id": "11cf45e625f2b309d4c896522cf13112", "patch_ids": ["5c18c40ff35964174537cfdd356a97a8"], "statement_hash": "381c0589ac81ca1c181c68e0f41b792798010dcb34432d48a70c8d2b305960c7", "relations": [{"rule": 2, "type": "equivalent", "target": "456f7cb7fea159f4dd066881991deddd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "381c0589ac81ca1c181c68e0f41b792798010dcb34432d48a70c8d2b305960c7"}}, {"rule": 2, "type": "equivalent", "target": "47e452aa71db8034a712239a3964e3a5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "381c0589ac81ca1c181c68e0f41b792798010dcb34432d48a70c8d2b305960c7"}}, {"rule": 2, "type": "equivalent", "target": "5eddd6c4577d73a939cab58edd99a776", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "381c0589ac81ca1c181c68e0f41b792798010dcb34432d48a70c8d2b305960c7"}}], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "47e452aa71db8034a712239a3964e3a5", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Fix mis-parsing of the last line in a non-newline-terminated pg_hba.conf file", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "381c0589ac81ca1c181c68e0f41b792798010dcb34432d48a70c8d2b305960c7"}, "url": "/docs/compare/?release=9.5.10#9.5.10-aa34866028bf645a", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "456f7cb7fea159f4dd066881991deddd", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Fix mis-parsing of the last line in a non-newline-terminated pg_hba.conf file", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "381c0589ac81ca1c181c68e0f41b792798010dcb34432d48a70c8d2b305960c7"}, "url": "/docs/compare/?release=9.4.15#9.4.15-aa34866028bf645a", "source_url": "/docs/release/9.4.15/#AEN121301"}, {"db_id": "5eddd6c4577d73a939cab58edd99a776", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "Fix mis-parsing of the last line in a non-newline-terminated pg_hba.conf file", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "381c0589ac81ca1c181c68e0f41b792798010dcb34432d48a70c8d2b305960c7"}, "url": "/docs/compare/?release=9.3.20#9.3.20-aa34866028bf645a", "source_url": "/docs/release/9.3.20/#AEN115749"}]}, {"id": "9.6.6-2aa6ab7f9c617a3d", "cves": [], "html": "Fix AggGetAggref() to return the correct Aggref nodes to aggregate final functions whose transition calculations have been merged (Tom Lane)
Fix pg_dump to ensure that it emits GRANT commands in a valid order (Stephen Frost)
", "text": "Fix pg_dump to ensure that it emits GRANT commands in a valid order (Stephen Frost)", "title": "Fix pg_dump to ensure that it emits GRANT commands in a valid order", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "bef1d48d630b5c51fdb9f8c0785ff96430de07e009ec2517d7f930ed63a2dc8e", "section_path": ["Changes"], "commit_groups": [["68a7c24fd", "caae416aa", "d2e40b310"]], "identity_text": "Fix pg_dump to ensure that it emits GRANT commands in a valid order (Stephen Frost)", "commit_aliases": ["68a7c24fd", "caae416aa", "d2e40b310"], "source_commits": ["caae416aa"], "source_entry_id": "9.6.6/changes/028", "db_id": "d7e776aa58c4295adfa29f4668a9b0f1", "patch_ids": ["ca1ccf52f94c460c5e7f992d4ce5469f"], "statement_hash": "69edc7ba24abd84493fea5dafae083d2432ce3ec3992272d9bef03d0def12338", "relations": [], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.6.6-4a5795e726af8f3f", "cves": [], "html": "Fix pg_basebackup's matching of tablespace paths to canonicalize both paths before comparing (Michael Paquier)
\nThis is particularly helpful on Windows.
", "text": "Fix pg_basebackup's matching of tablespace paths to canonicalize both paths before comparing (Michael Paquier) This is particularly helpful on Windows.", "title": "Fix pg_basebackup's matching of tablespace paths to canonicalize both paths before comparing", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "a0e1957cd6ced6e11599b3f13c75e6431d4c259db64485165a18231c5bbe3727", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix pg_basebackup's matching of tablespace paths to canonicalize both paths before comparing (Michael Paquier) This is particularly helpful on Windows.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/029", "db_id": "06da3821bc1aeeb6ec454dd8a41f92ee", "patch_ids": [], "statement_hash": "05133eb0e9c7259378c49cda408c3e752eb8377fe2baf017ba74ae43ffd96017", "relations": [{"rule": 2, "type": "equivalent", "target": "07f287a6847514888fd4b882d3cec52f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "05133eb0e9c7259378c49cda408c3e752eb8377fe2baf017ba74ae43ffd96017"}}, {"rule": 2, "type": "equivalent", "target": "997f624922337f5d4a85a2fb9d4a0891", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "05133eb0e9c7259378c49cda408c3e752eb8377fe2baf017ba74ae43ffd96017"}}], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "997f624922337f5d4a85a2fb9d4a0891", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Fix pg_basebackup's matching of tablespace paths to canonicalize both paths before comparing", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "05133eb0e9c7259378c49cda408c3e752eb8377fe2baf017ba74ae43ffd96017"}, "url": "/docs/compare/?release=10.1#10.1-4a5795e726af8f3f", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "07f287a6847514888fd4b882d3cec52f", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Fix pg_basebackup's matching of tablespace paths to canonicalize both paths before comparing", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "05133eb0e9c7259378c49cda408c3e752eb8377fe2baf017ba74ae43ffd96017"}, "url": "/docs/compare/?release=9.5.10#9.5.10-4a5795e726af8f3f", "source_url": "/docs/release/9.5.10/#AEN129619"}]}, {"id": "9.6.6-e666dee3eca6c648", "cves": [], "html": "Fix libpq to not require user's home directory to exist (Tom Lane)
\nIn v10, failure to find the home directory while trying to read ~/.pgpass was treated as a hard error, but it should just cause that file to not be found. Both v10 and previous release branches made the same mistake when reading ~/.pg_service.conf, though this was less obvious since that file is not sought unless a service name is specified.
", "text": "Fix libpq to not require user's home directory to exist (Tom Lane) In v10, failure to find the home directory while trying to read ~/.pgpass was treated as a hard error, but it should just cause that file to not be found. Both v10 and previous release branches made the same mistake when reading ~/.pg_service.conf, though this was less obvious since that file is not sought unless a service name is specified.", "title": "Fix libpq to not require user's home directory to exist", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "8d3352bdcd8434b4857ee81bb20337deab45a7bee961b18341c52c4e33d1a651", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix libpq to not require user's home directory to exist (Tom Lane) In v10, failure to find the home directory while trying to read ~/.pgpass was treated as a hard error, but it should just cause that file to not be found. Both v10 and previous release branches made the same mistake when reading ~/.pg_service.conf, though this was less obvious since that file is not sought unless a service name is specified.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/030", "db_id": "d518c7c5ea325860a92385a76d35cbc7", "patch_ids": [], "statement_hash": "ef4d1a424bbe09876057233a76fc1698ea9ec3d219478a9f56f6e6eebd2ed467", "relations": [{"rule": 2, "type": "equivalent", "target": "006b88f929e042ebc8300b75f7f27246", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ef4d1a424bbe09876057233a76fc1698ea9ec3d219478a9f56f6e6eebd2ed467"}}, {"rule": 2, "type": "equivalent", "target": "102daed46570ca19e49b298bfa3ba3e2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ef4d1a424bbe09876057233a76fc1698ea9ec3d219478a9f56f6e6eebd2ed467"}}, {"rule": 2, "type": "equivalent", "target": "7ec2fb78308cd9103547c1a0c812b9b1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ef4d1a424bbe09876057233a76fc1698ea9ec3d219478a9f56f6e6eebd2ed467"}}, {"rule": 2, "type": "equivalent", "target": "b0cb3ef81cd549c25017579634b98ae7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ef4d1a424bbe09876057233a76fc1698ea9ec3d219478a9f56f6e6eebd2ed467"}}, {"rule": 2, "type": "equivalent", "target": "b71d6a1a44ecb249aeffd4cc931c9999", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ef4d1a424bbe09876057233a76fc1698ea9ec3d219478a9f56f6e6eebd2ed467"}}], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "b0cb3ef81cd549c25017579634b98ae7", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Fix libpq to not require user's home directory to exist", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ef4d1a424bbe09876057233a76fc1698ea9ec3d219478a9f56f6e6eebd2ed467"}, "url": "/docs/compare/?release=10.1#10.1-e666dee3eca6c648", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "7ec2fb78308cd9103547c1a0c812b9b1", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Fix libpq to not require user's home directory to exist", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ef4d1a424bbe09876057233a76fc1698ea9ec3d219478a9f56f6e6eebd2ed467"}, "url": "/docs/compare/?release=9.5.10#9.5.10-e666dee3eca6c648", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "006b88f929e042ebc8300b75f7f27246", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Fix libpq to not require user's home directory to exist", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ef4d1a424bbe09876057233a76fc1698ea9ec3d219478a9f56f6e6eebd2ed467"}, "url": "/docs/compare/?release=9.4.15#9.4.15-e666dee3eca6c648", "source_url": "/docs/release/9.4.15/#AEN121301"}, {"db_id": "102daed46570ca19e49b298bfa3ba3e2", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "Fix libpq to not require user's home directory to exist", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ef4d1a424bbe09876057233a76fc1698ea9ec3d219478a9f56f6e6eebd2ed467"}, "url": "/docs/compare/?release=9.3.20#9.3.20-e666dee3eca6c648", "source_url": "/docs/release/9.3.20/#AEN115749"}, {"db_id": "b71d6a1a44ecb249aeffd4cc931c9999", "kind": "equivalent", "version": "9.2.24", "label": "9.2.24", "title": "Fix libpq to not require user's home directory to exist", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ef4d1a424bbe09876057233a76fc1698ea9ec3d219478a9f56f6e6eebd2ed467"}, "url": "/docs/compare/?release=9.2.24#9.2.24-e666dee3eca6c648", "source_url": "/docs/release/9.2.24/#AEN110823"}]}, {"id": "9.6.6-457bfaae059cf2f0", "cves": [], "html": "Fix libpq to guard against integer overflow in the row count of a PGresult (Michael Paquier)
", "text": "Fix libpq to guard against integer overflow in the row count of a PGresult (Michael Paquier)", "title": "Fix libpq to guard against integer overflow in the row count of a PGresult", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "e8304e64289b56447869f2911c050983580927d6d237d08cb13558097e7afad0", "section_path": ["Changes"], "commit_groups": [["1305186de", "3a0f8e7d3", "53863ebeb", "9d6b160d7", "dd344de67", "f2fe1cbef", "f60a236ba"], ["1c53722ff", "2e70d6b5e", "a07058a6d", "b481b39b8", "bc95e5874", "d391fb6c3", "dfd1042c6"]], "identity_text": "Fix libpq to guard against integer overflow in the row count of a PGresult (Michael Paquier)", "commit_aliases": ["1305186de", "1c53722ff", "2e70d6b5e", "3a0f8e7d3", "53863ebeb", "9d6b160d7", "a07058a6d", "b481b39b8", "bc95e5874", "d391fb6c3", "dd344de67", "dfd1042c6", "f2fe1cbef", "f60a236ba"], "source_commits": ["3a0f8e7d3", "bc95e5874"], "source_entry_id": "9.6.6/changes/031", "db_id": "86c1fafaa843061ad1e84402e625e9cd", "patch_ids": ["09fee003806353f18efa266b8994e9d4", "ff54cc30b3bf23228335293694813567"], "statement_hash": "50f672800a6bf3311e001ef2aefd1dd5abc1cf6fc9a4cc3e87a213448ee64e7a", "relations": [{"rule": 2, "type": "equivalent", "target": "37e1e5cf1498b87470b54ee71a0e67ab", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "50f672800a6bf3311e001ef2aefd1dd5abc1cf6fc9a4cc3e87a213448ee64e7a"}}, {"rule": 2, "type": "equivalent", "target": "3c1c024ed8f25be27c5657f0e5286342", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "50f672800a6bf3311e001ef2aefd1dd5abc1cf6fc9a4cc3e87a213448ee64e7a"}}, {"rule": 2, "type": "equivalent", "target": "79d49467885ae1d412bdf9b307596c0f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "50f672800a6bf3311e001ef2aefd1dd5abc1cf6fc9a4cc3e87a213448ee64e7a"}}, {"rule": 2, "type": "equivalent", "target": "b56f562ef59390b0c10ee313ce357e14", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "50f672800a6bf3311e001ef2aefd1dd5abc1cf6fc9a4cc3e87a213448ee64e7a"}}], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "b56f562ef59390b0c10ee313ce357e14", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Fix libpq to guard against integer overflow in the row count of a PGresult", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "50f672800a6bf3311e001ef2aefd1dd5abc1cf6fc9a4cc3e87a213448ee64e7a"}, "url": "/docs/compare/?release=9.5.10#9.5.10-457bfaae059cf2f0", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "37e1e5cf1498b87470b54ee71a0e67ab", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Fix libpq to guard against integer overflow in the row count of a PGresult", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "50f672800a6bf3311e001ef2aefd1dd5abc1cf6fc9a4cc3e87a213448ee64e7a"}, "url": "/docs/compare/?release=9.4.15#9.4.15-457bfaae059cf2f0", "source_url": "/docs/release/9.4.15/#AEN121301"}, {"db_id": "3c1c024ed8f25be27c5657f0e5286342", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "Fix libpq to guard against integer overflow in the row count of a PGresult", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "50f672800a6bf3311e001ef2aefd1dd5abc1cf6fc9a4cc3e87a213448ee64e7a"}, "url": "/docs/compare/?release=9.3.20#9.3.20-457bfaae059cf2f0", "source_url": "/docs/release/9.3.20/#AEN115749"}, {"db_id": "79d49467885ae1d412bdf9b307596c0f", "kind": "equivalent", "version": "9.2.24", "label": "9.2.24", "title": "Fix libpq to guard against integer overflow in the row count of a PGresult", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "50f672800a6bf3311e001ef2aefd1dd5abc1cf6fc9a4cc3e87a213448ee64e7a"}, "url": "/docs/compare/?release=9.2.24#9.2.24-457bfaae059cf2f0", "source_url": "/docs/release/9.2.24/#AEN110823"}]}, {"id": "9.6.6-9658a795413ab4d3", "cves": [], "html": "Fix ecpg's handling of out-of-scope cursor declarations with pointer or array variables (Michael Meskes)
", "text": "Fix ecpg's handling of out-of-scope cursor declarations with pointer or array variables (Michael Meskes)", "title": "Fix ecpg's handling of out-of-scope cursor declarations with pointer or array variables", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "87e36bbe300f363192dec359267655d3fe69062b6e1f7a8376c874d5e17706fa", "section_path": ["Changes"], "commit_groups": [["149cfdb3a", "35e156882", "3a5aa7de3", "59b5a3e5c", "75fbf8ad1", "e5b8b771e"]], "identity_text": "Fix ecpg's handling of out-of-scope cursor declarations with pointer or array variables (Michael Meskes)", "commit_aliases": ["149cfdb3a", "35e156882", "3a5aa7de3", "59b5a3e5c", "75fbf8ad1", "e5b8b771e"], "source_commits": ["59b5a3e5c"], "source_entry_id": "9.6.6/changes/032", "db_id": "ced4bc1b74d9e880ae2b6b5a746ee285", "patch_ids": ["f06990a7cfa4b39c0283ec3585d055dd"], "statement_hash": "626f04291bc7fee1b5ab88f2f39d11f79eea4a5f6642182d355b06bf96ca1de9", "relations": [{"rule": 2, "type": "equivalent", "target": "4e6b2fc6b347eac6afcc794106f2785c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "626f04291bc7fee1b5ab88f2f39d11f79eea4a5f6642182d355b06bf96ca1de9"}}, {"rule": 2, "type": "equivalent", "target": "77b4e508a729e39bd48db59a6b54ffaf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "626f04291bc7fee1b5ab88f2f39d11f79eea4a5f6642182d355b06bf96ca1de9"}}, {"rule": 2, "type": "equivalent", "target": "ec4a2d746d8f1ee0cfba9bf344b85661", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "626f04291bc7fee1b5ab88f2f39d11f79eea4a5f6642182d355b06bf96ca1de9"}}], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "ec4a2d746d8f1ee0cfba9bf344b85661", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Fix ecpg's handling of out-of-scope cursor declarations with pointer or array variables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "626f04291bc7fee1b5ab88f2f39d11f79eea4a5f6642182d355b06bf96ca1de9"}, "url": "/docs/compare/?release=9.5.10#9.5.10-9658a795413ab4d3", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "77b4e508a729e39bd48db59a6b54ffaf", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Fix ecpg's handling of out-of-scope cursor declarations with pointer or array variables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "626f04291bc7fee1b5ab88f2f39d11f79eea4a5f6642182d355b06bf96ca1de9"}, "url": "/docs/compare/?release=9.4.15#9.4.15-9658a795413ab4d3", "source_url": "/docs/release/9.4.15/#AEN121301"}, {"db_id": "4e6b2fc6b347eac6afcc794106f2785c", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "Fix ecpg's handling of out-of-scope cursor declarations with pointer or array variables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "626f04291bc7fee1b5ab88f2f39d11f79eea4a5f6642182d355b06bf96ca1de9"}, "url": "/docs/compare/?release=9.3.20#9.3.20-9658a795413ab4d3", "source_url": "/docs/release/9.3.20/#AEN115749"}]}, {"id": "9.6.6-fa0e54065b67df9f", "cves": [], "html": "In ecpglib, correctly handle backslashes in string literals depending on whether standard_conforming_strings is set (Tsunakawa Takayuki)
", "text": "In ecpglib, correctly handle backslashes in string literals depending on whether standard_conforming_strings is set (Tsunakawa Takayuki)", "title": "In ecpglib, correctly handle backslashes in string literals depending on whether standard_conforming_strings is set", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "5629c071ea4af7b5855a626bf9f0e98147bd663ea0c63e51d55f9cb0bb98ef75", "section_path": ["Changes"], "commit_groups": [], "identity_text": "In ecpglib, correctly handle backslashes in string literals depending on whether standard_conforming_strings is set (Tsunakawa Takayuki)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/033", "db_id": "c5d4d801e5662c99d1d1b7036d903d07", "patch_ids": [], "statement_hash": "75d74e83fd6e41320843a7950c077aa0de97e7ed9aad29725e94eb10a0a6f2cf", "relations": [{"rule": 2, "type": "equivalent", "target": "168a74663d229ad0ce14364661bc495c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "75d74e83fd6e41320843a7950c077aa0de97e7ed9aad29725e94eb10a0a6f2cf"}}, {"rule": 2, "type": "equivalent", "target": "547d8af011856c3b80ac12cae523ff61", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "75d74e83fd6e41320843a7950c077aa0de97e7ed9aad29725e94eb10a0a6f2cf"}}, {"rule": 2, "type": "equivalent", "target": "6804ac8e13b0fe3eff142d76f3855b8f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "75d74e83fd6e41320843a7950c077aa0de97e7ed9aad29725e94eb10a0a6f2cf"}}], "version": "9.6.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "168a74663d229ad0ce14364661bc495c", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "In ecpglib, correctly handle backslashes in string literals depending on whether standard_conforming_strings is set", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "75d74e83fd6e41320843a7950c077aa0de97e7ed9aad29725e94eb10a0a6f2cf"}, "url": "/docs/compare/?release=10.1#10.1-fa0e54065b67df9f", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "547d8af011856c3b80ac12cae523ff61", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "In ecpglib, correctly handle backslashes in string literals depending on whether standard_conforming_strings is set", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "75d74e83fd6e41320843a7950c077aa0de97e7ed9aad29725e94eb10a0a6f2cf"}, "url": "/docs/compare/?release=9.5.10#9.5.10-fa0e54065b67df9f", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "6804ac8e13b0fe3eff142d76f3855b8f", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "In ecpglib, correctly handle backslashes in string literals depending on whether standard_conforming_strings is set", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "75d74e83fd6e41320843a7950c077aa0de97e7ed9aad29725e94eb10a0a6f2cf"}, "url": "/docs/compare/?release=9.4.15#9.4.15-fa0e54065b67df9f", "source_url": "/docs/release/9.4.15/#AEN121301"}]}, {"id": "9.6.6-2b73a61e1b7487ec", "cves": [], "html": "Make ecpglib's Informix-compatibility mode ignore fractional digits in integer input strings, as expected (Gao Zengqi, Michael Meskes)
", "text": "Make ecpglib's Informix-compatibility mode ignore fractional digits in integer input strings, as expected (Gao Zengqi, Michael Meskes)", "title": "Make ecpglib's Informix-compatibility mode ignore fractional digits in integer input strings, as expected", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "0bb55d5fd107a5536e200eb87ef818a2c008a01ef13256e528f5352b212eef8f", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Make ecpglib's Informix-compatibility mode ignore fractional digits in integer input strings, as expected (Gao Zengqi, Michael Meskes)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/034", "db_id": "2cc74143087d0baf26e69f81883a4d7c", "patch_ids": [], "statement_hash": "da5c23f1166bd60b7e38bb6b7bdd69493fbaa86814ea539935938b6f19b5c03f", "relations": [{"rule": 2, "type": "equivalent", "target": "327951f097966e1bf73354a3b969072e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "da5c23f1166bd60b7e38bb6b7bdd69493fbaa86814ea539935938b6f19b5c03f"}}, {"rule": 2, "type": "equivalent", "target": "3c9edd46a25977cbd2b2b1fb160b7dae", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "da5c23f1166bd60b7e38bb6b7bdd69493fbaa86814ea539935938b6f19b5c03f"}}, {"rule": 2, "type": "equivalent", "target": "89c449856b27a1bc18eeb794c6cebedb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "da5c23f1166bd60b7e38bb6b7bdd69493fbaa86814ea539935938b6f19b5c03f"}}, {"rule": 2, "type": "equivalent", "target": "a5569d283bfc07fbb4c56ca6b143f8ca", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "da5c23f1166bd60b7e38bb6b7bdd69493fbaa86814ea539935938b6f19b5c03f"}}], "version": "9.6.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "a5569d283bfc07fbb4c56ca6b143f8ca", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Make ecpglib's Informix-compatibility mode ignore fractional digits in integer input strings, as expected", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "da5c23f1166bd60b7e38bb6b7bdd69493fbaa86814ea539935938b6f19b5c03f"}, "url": "/docs/compare/?release=10.1#10.1-2b73a61e1b7487ec", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "327951f097966e1bf73354a3b969072e", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Make ecpglib's Informix-compatibility mode ignore fractional digits in integer input strings, as expected", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "da5c23f1166bd60b7e38bb6b7bdd69493fbaa86814ea539935938b6f19b5c03f"}, "url": "/docs/compare/?release=9.5.10#9.5.10-2b73a61e1b7487ec", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "3c9edd46a25977cbd2b2b1fb160b7dae", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Make ecpglib's Informix-compatibility mode ignore fractional digits in integer input strings, as expected", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "da5c23f1166bd60b7e38bb6b7bdd69493fbaa86814ea539935938b6f19b5c03f"}, "url": "/docs/compare/?release=9.4.15#9.4.15-2b73a61e1b7487ec", "source_url": "/docs/release/9.4.15/#AEN121301"}, {"db_id": "89c449856b27a1bc18eeb794c6cebedb", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "Make ecpglib's Informix-compatibility mode ignore fractional digits in integer input strings, as expected", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "da5c23f1166bd60b7e38bb6b7bdd69493fbaa86814ea539935938b6f19b5c03f"}, "url": "/docs/compare/?release=9.3.20#9.3.20-2b73a61e1b7487ec", "source_url": "/docs/release/9.3.20/#AEN115749"}]}, {"id": "9.6.6-977efc37084fd90e", "cves": [], "html": "Fix ecpg's regression tests to work reliably on Windows (Christian Ullrich, Michael Meskes)
", "text": "Fix ecpg's regression tests to work reliably on Windows (Christian Ullrich, Michael Meskes)", "title": "Fix ecpg's regression tests to work reliably on Windows", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "a8cbc54f32d9d05c13dd80dfd354a47319ca60839c4d6c658c768e7bf67d629e", "section_path": ["Changes"], "commit_groups": [["04fbe0e45", "407e66078", "eaf7001eb"], ["38d7cb67f", "839ee1811", "a772624b1"]], "identity_text": "Fix ecpg's regression tests to work reliably on Windows (Christian Ullrich, Michael Meskes)", "commit_aliases": ["04fbe0e45", "38d7cb67f", "407e66078", "839ee1811", "a772624b1", "eaf7001eb"], "source_commits": ["407e66078", "839ee1811"], "source_entry_id": "9.6.6/changes/035", "db_id": "f9024a6b4756773fcdab35778fe3b77f", "patch_ids": ["19ca68448c17b1d96ead336dff7c5804", "a9f917dae4b3c13cbcfe323028e98ad6"], "statement_hash": "6224e845c0a4a0b3652b323fd6a4ad6a1f8ad200c969a203db2f93bd070448c8", "relations": [], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.6.6-78816bf0925ce858", "cves": [], "html": "Fix missing temp-install prerequisites for check-like Make targets (Noah Misch)
\nSome non-default test procedures that are meant to work like make check failed to ensure that the temporary installation was up to date.
", "text": "Fix missing temp-install prerequisites for check-like Make targets (Noah Misch) Some non-default test procedures that are meant to work like make check failed to ensure that the temporary installation was up to date.", "title": "Fix missing temp-install prerequisites for check-like Make targets", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "8d3a95b8e6d7fb19acb92ba4770489ae415904f488d68dc16a1b45ee7a814eb6", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix missing temp-install prerequisites for check-like Make targets (Noah Misch) Some non-default test procedures that are meant to work like make check failed to ensure that the temporary installation was up to date.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/036", "db_id": "c85a49c083768d9a7a41e16279df58c0", "patch_ids": [], "statement_hash": "adf838e56daaf91faf158a31e7924ee6c6bc92c87aae15962a3221ba62bc38df", "relations": [{"rule": 2, "type": "equivalent", "target": "084cff448678bc1c1f7c2bc0199d2688", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "adf838e56daaf91faf158a31e7924ee6c6bc92c87aae15962a3221ba62bc38df"}}, {"rule": 2, "type": "equivalent", "target": "727e420b2bbb58ff1295e9371b8cabad", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "adf838e56daaf91faf158a31e7924ee6c6bc92c87aae15962a3221ba62bc38df"}}], "version": "9.6.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "727e420b2bbb58ff1295e9371b8cabad", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Fix missing temp-install prerequisites for check-like Make targets", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "adf838e56daaf91faf158a31e7924ee6c6bc92c87aae15962a3221ba62bc38df"}, "url": "/docs/compare/?release=10.1#10.1-78816bf0925ce858", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "084cff448678bc1c1f7c2bc0199d2688", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Fix missing temp-install prerequisites for check-like Make targets", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "adf838e56daaf91faf158a31e7924ee6c6bc92c87aae15962a3221ba62bc38df"}, "url": "/docs/compare/?release=9.5.10#9.5.10-78816bf0925ce858", "source_url": "/docs/release/9.5.10/#AEN129619"}]}, {"id": "9.6.6-12a5d6cd963461ae", "cves": [], "html": "Sync our copy of the timezone library with IANA release tzcode2017c (Tom Lane)
\nThis fixes various issues; the only one likely to be user-visible is that the default DST rules for a POSIX-style zone name, if no posixrules file exists in the timezone data directory, now match current US law rather than what it was a dozen years ago.
", "text": "Sync our copy of the timezone library with IANA release tzcode2017c (Tom Lane) This fixes various issues; the only one likely to be user-visible is that the default DST rules for a POSIX-style zone name, if no posixrules file exists in the timezone data directory, now match current US law rather than what it was a dozen years ago.", "title": "Sync our copy of the timezone library with IANA release tzcode2017c", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "25cc5ff434913660955ffee22f00813a2dda6bfbf7949ecb7c7d88836e10528f", "section_path": ["Changes"], "commit_groups": [["1317d1301", "173b7a4a7", "24a1897ab", "4b433a8b0", "876e076eb", "9c74dd2d5", "dffe7fbc2"], ["2020f90bf", "3876b16ce", "47f849a3c", "89f02e17a", "a07105afa", "dbd6099fb", "e25f4401d"]], "identity_text": "Sync our copy of the timezone library with IANA release tzcode2017c (Tom Lane) This fixes various issues; the only one likely to be user-visible is that the default DST rules for a POSIX-style zone name, if no posixrules file exists in the timezone data directory, now match current US law rather than what it was a dozen years ago.", "commit_aliases": ["1317d1301", "173b7a4a7", "2020f90bf", "24a1897ab", "3876b16ce", "47f849a3c", "4b433a8b0", "876e076eb", "89f02e17a", "9c74dd2d5", "a07105afa", "dbd6099fb", "dffe7fbc2", "e25f4401d"], "source_commits": ["173b7a4a7", "e25f4401d"], "source_entry_id": "9.6.6/changes/037", "db_id": "0a2566d962dc17066b0858eccb1ec8ca", "patch_ids": ["392f613428a8a821e8a507efe798bccc", "aae1a35bf0a6df11a874a38593b8162e"], "statement_hash": "8985edb7ded2d38773ddc64598a39e38bbe5d8b73e649685024b1e356e36406d", "relations": [{"rule": 2, "type": "equivalent", "target": "06a4e590689a5f30eb58e6b5354b43a6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8985edb7ded2d38773ddc64598a39e38bbe5d8b73e649685024b1e356e36406d"}}, {"rule": 2, "type": "equivalent", "target": "3323050002a438fd4c496cad0d082d3a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8985edb7ded2d38773ddc64598a39e38bbe5d8b73e649685024b1e356e36406d"}}, {"rule": 2, "type": "equivalent", "target": "85e927695bfabb0a66f2b593f41aea7e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8985edb7ded2d38773ddc64598a39e38bbe5d8b73e649685024b1e356e36406d"}}, {"rule": 2, "type": "equivalent", "target": "bab62d963c9727b928254af48d27401f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8985edb7ded2d38773ddc64598a39e38bbe5d8b73e649685024b1e356e36406d"}}], "version": "9.6.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "bab62d963c9727b928254af48d27401f", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Sync our copy of the timezone library with IANA release tzcode2017c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8985edb7ded2d38773ddc64598a39e38bbe5d8b73e649685024b1e356e36406d"}, "url": "/docs/compare/?release=9.5.10#9.5.10-12a5d6cd963461ae", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "3323050002a438fd4c496cad0d082d3a", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Sync our copy of the timezone library with IANA release tzcode2017c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8985edb7ded2d38773ddc64598a39e38bbe5d8b73e649685024b1e356e36406d"}, "url": "/docs/compare/?release=9.4.15#9.4.15-12a5d6cd963461ae", "source_url": "/docs/release/9.4.15/#AEN121301"}, {"db_id": "06a4e590689a5f30eb58e6b5354b43a6", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "Sync our copy of the timezone library with IANA release tzcode2017c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8985edb7ded2d38773ddc64598a39e38bbe5d8b73e649685024b1e356e36406d"}, "url": "/docs/compare/?release=9.3.20#9.3.20-12a5d6cd963461ae", "source_url": "/docs/release/9.3.20/#AEN115749"}, {"db_id": "85e927695bfabb0a66f2b593f41aea7e", "kind": "equivalent", "version": "9.2.24", "label": "9.2.24", "title": "Sync our copy of the timezone library with IANA release tzcode2017c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8985edb7ded2d38773ddc64598a39e38bbe5d8b73e649685024b1e356e36406d"}, "url": "/docs/compare/?release=9.2.24#9.2.24-12a5d6cd963461ae", "source_url": "/docs/release/9.2.24/#AEN110823"}]}, {"id": "9.6.6-b4cc87018e2d5aa0", "cves": [], "html": "Update time zone data files to tzdata release 2017c for DST law changes in Fiji, Namibia, Northern Cyprus, Sudan, Tonga, and Turks & Caicos Islands, plus historical corrections for Alaska, Apia, Burma, Calcutta, Detroit, Ireland, Namibia, and Pago Pago.
", "text": "Update time zone data files to tzdata release 2017c for DST law changes in Fiji, Namibia, Northern Cyprus, Sudan, Tonga, and Turks & Caicos Islands, plus historical corrections for Alaska, Apia, Burma, Calcutta, Detroit, Ireland, Namibia, and Pago Pago.", "title": "Update time zone data files to tzdata release 2017c for DST law changes in Fiji, Namibia, Northern Cyprus, Sudan, Tonga, and Turks & Caicos Islands, plus historical corrections for Alaska, Apia, Burma, Calcutta, Detroit, Ireland, Namibia, and Pago Pago.", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.6/#AEN134950", "source_hash": "76d48a43ee33c8746bb6f8063ec88e7cadb450bdd45a77f4e13059ff3ce47ce1", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Update time zone data files to tzdata release 2017c for DST law changes in Fiji, Namibia, Northern Cyprus, Sudan, Tonga, and Turks & Caicos Islands, plus historical corrections for Alaska, Apia, Burma, Calcutta, Detroit, Ireland, Namibia, and Pago Pago.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.6/changes/038", "db_id": "293143bd1bebf2fa099b043849086024", "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8", "relations": [{"rule": 2, "type": "equivalent", "target": "41fa2b66666f8560149b4e828a789f52", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}}, {"rule": 2, "type": "equivalent", "target": "5063230b1a3750ce6e2d9f3ced8caedc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}}, {"rule": 2, "type": "equivalent", "target": "85588d39e9c7e704df909e151fc0201f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}}, {"rule": 2, "type": "equivalent", "target": "cc4690a822d3cdb953a0494112d06b92", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}}, {"rule": 2, "type": "equivalent", "target": "ecc97112734f3476d067fd7dbbf430da", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}}], "version": "9.6.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "ecc97112734f3476d067fd7dbbf430da", "kind": "equivalent", "version": "10.1", "label": "10.1", "title": "Update time zone data files to tzdata release 2017c for DST law changes in Fiji, Namibia, Northern Cyprus, Sudan, Tonga, and Turks & Caicos Islands, plus historical corrections for Alaska, Apia, Burma, Calcutta, Detroit, Ireland, Namibia, and Pago Pago.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}, "url": "/docs/compare/?release=10.1#10.1-b4cc87018e2d5aa0", "source_url": "/docs/release/10.1/#id-1.11.6.27.5"}, {"db_id": "85588d39e9c7e704df909e151fc0201f", "kind": "equivalent", "version": "9.5.10", "label": "9.5.10", "title": "Update time zone data files to tzdata release 2017c for DST law changes in Fiji, Namibia, Northern Cyprus, Sudan, Tonga, and Turks & Caicos Islands, plus historical corrections for Alaska, Apia, Burma, Calcutta, Detroit, Ireland, Namibia, and Pago Pago.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}, "url": "/docs/compare/?release=9.5.10#9.5.10-b4cc87018e2d5aa0", "source_url": "/docs/release/9.5.10/#AEN129619"}, {"db_id": "5063230b1a3750ce6e2d9f3ced8caedc", "kind": "equivalent", "version": "9.4.15", "label": "9.4.15", "title": "Update time zone data files to tzdata release 2017c for DST law changes in Fiji, Namibia, Northern Cyprus, Sudan, Tonga, and Turks & Caicos Islands, plus historical corrections for Alaska, Apia, Burma, Calcutta, Detroit, Ireland, Namibia, and Pago Pago.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}, "url": "/docs/compare/?release=9.4.15#9.4.15-b4cc87018e2d5aa0", "source_url": "/docs/release/9.4.15/#AEN121301"}, {"db_id": "41fa2b66666f8560149b4e828a789f52", "kind": "equivalent", "version": "9.3.20", "label": "9.3.20", "title": "Update time zone data files to tzdata release 2017c for DST law changes in Fiji, Namibia, Northern Cyprus, Sudan, Tonga, and Turks & Caicos Islands, plus historical corrections for Alaska, Apia, Burma, Calcutta, Detroit, Ireland, Namibia, and Pago Pago.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}, "url": "/docs/compare/?release=9.3.20#9.3.20-b4cc87018e2d5aa0", "source_url": "/docs/release/9.3.20/#AEN115749"}, {"db_id": "cc4690a822d3cdb953a0494112d06b92", "kind": "equivalent", "version": "9.2.24", "label": "9.2.24", "title": "Update time zone data files to tzdata release 2017c for DST law changes in Fiji, Namibia, Northern Cyprus, Sudan, Tonga, and Turks & Caicos Islands, plus historical corrections for Alaska, Apia, Burma, Calcutta, Detroit, Ireland, Namibia, and Pago Pago.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3243bb08f79e29c95895ca9e1b7d57c80b961cfd148b11214ab2ca70959afea8"}, "url": "/docs/compare/?release=9.2.24#9.2.24-b4cc87018e2d5aa0", "source_url": "/docs/release/9.2.24/#AEN110823"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 38}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 20}, {"key": "security", "label": "Security", "count": 3}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 15}], "total": 38, "release_count": 1, "cross_major": false, "cve_count": 3, "cves": [{"id": "CVE-2017-12172", "url": "https://www.postgresql.org/support/security/CVE-2017-12172/", "fixed": {"10": "10.1", "9.2": "9.2.24", "9.3": "9.3.20", "9.4": "9.4.15", "9.5": "9.5.10", "9.6": "9.6.6"}, "score": 8.4, "title": "Fix sample server-start scripts to become $PGUSER before opening $PGLOG", "vector": "AV:N/AC:L/PR:H/UI:R/S:C/C:H/I:H/A:H", "affected": {"10": "10", "9.2": "9.2", "9.3": "9.3", "9.4": "9.4", "9.5": "9.5", "9.6": "9.6"}, "component": "contrib module", "published": {"10": "2017-11-09", "9.2": "2017-11-09", "9.3": "2017-11-09", "9.4": "2017-11-09", "9.5": "2017-11-09", "9.6": "2017-11-09"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2017-11-09", "fixed_version": "9.6.6"}, {"id": "CVE-2017-15098", "url": "https://www.postgresql.org/support/security/CVE-2017-15098/", "fixed": {"10": "10.1", "9.3": "9.3.20", "9.4": "9.4.15", "9.5": "9.5.10", "9.6": "9.6.6"}, "score": 4.3, "title": "Fix crash due to rowtype mismatch in json{b}_populate_recordset()", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:N/A:N", "affected": {"10": "10", "9.3": "9.3", "9.4": "9.4", "9.5": "9.5", "9.6": "9.6"}, "component": "core server", "published": {"10": "2017-11-09", "9.3": "2017-11-09", "9.4": "2017-11-09", "9.5": "2017-11-09", "9.6": "2017-11-09"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2017-11-09", "fixed_version": "9.6.6"}, {"id": "CVE-2017-15099", "url": "https://www.postgresql.org/support/security/CVE-2017-15099/", "fixed": {"10": "10.1", "9.5": "9.5.10", "9.6": "9.6.6"}, "score": 3.1, "title": "Ensure that INSERT ... ON CONFLICT DO UPDATE checks table permissions and RLS policies in all cases", "vector": "AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:N/A:N", "affected": {"10": "10", "9.5": "9.5", "9.6": "9.6"}, "component": "core server", "published": {"10": "2017-11-09", "9.5": "2017-11-09", "9.6": "2017-11-09"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2017-11-09", "fixed_version": "9.6.6"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 38, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}