A dump/restore is not required for those running 9.6.X.
\nHowever, if you use contrib/cube's ~> operator, see the entry below about that.
\nAlso, if you are upgrading from a version earlier than 9.6.6, see Section E.19.
", "compatibility_count": 0, "label": "9.6.7", "status_label": "Historical", "eol": "2021-11-11", "age_days": 3155, "support_days": -1783}, "groups": [{"date": "2018-02-08", "build": "9.6.7", "major": "9.6", "minor": 7, "manual": "9.6", "status": "stable", "doc_git": "", "version": "9.6.7", "eol_date": "2021-11-11", "date_text": "2018-02-08", "supported": false, "manual_url": "/docs/9.6/release-9-6-7.html", "source_url": "/docs/release/9.6.7/", "entry_count": 37, "placeholder": false, "content_hash": "614dd763fe908afa4727baf4ed62dc04ff074778f5497a936af4b85c8486e042", "manual_build": "9.6.24", "source_as_of": "", "changes_count": 37, "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 contrib/cube's ~> operator, see the entry below about that.
\nAlso, if you are upgrading from a version earlier than 9.6.6, see Section E.19.
", "compatibility_count": 0, "label": "9.6.7", "status_label": "Historical", "eol": "2021-11-11", "age_days": 3155, "support_days": -1783, "entries": [{"id": "9.6.7-4f881ffec7e1b506", "cves": ["CVE-2018-1053"], "html": "Ensure that all temporary files made by pg_upgrade are non-world-readable (Tom Lane, Noah Misch)
\npg_upgrade normally restricts its temporary files to be readable and writable only by the calling user. But the temporary file containing pg_dumpall -g output would be group- or world-readable, or even writable, if the user's umask setting allows. In typical usage on multi-user machines, the umask and/or the working directory's permissions would be tight enough to prevent problems; but there may be people using pg_upgrade in scenarios where this oversight would permit disclosure of database passwords to unfriendly eyes. (CVE-2018-1053)
", "text": "Ensure that all temporary files made by pg_upgrade are non-world-readable (Tom Lane, Noah Misch) pg_upgrade normally restricts its temporary files to be readable and writable only by the calling user. But the temporary file containing pg_dumpall -g output would be group- or world-readable, or even writable, if the user's umask setting allows. In typical usage on multi-user machines, the umask and/or the working directory's permissions would be tight enough to prevent problems; but there may be people using pg_upgrade in scenarios where this oversight would permit disclosure of database passwords to unfriendly eyes. (CVE-2018-1053)", "title": "Ensure that all temporary files made by pg_upgrade are non-world-readable", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "021daaebd3ce7bf335e347579188952bd5a5f24eb03e913409c3a6c9379d3d69", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ensure that all temporary files made by pg_upgrade are non-world-readable (Tom Lane, Noah Misch) pg_upgrade normally restricts its temporary files to be readable and writable only by the calling user. But the temporary file containing pg_dumpall -g output would be group- or world-readable, or even writable, if the user's umask setting allows. In typical usage on multi-user machines, the umask and/or the working directory's permissions would be tight enough to prevent problems; but there may be people using pg_upgrade in scenarios where this oversight would permit disclosure of database passwords to unfriendly eyes. (CVE-2018-1053)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/001", "db_id": "502a24d61bdbdddb5ce51397266ec1e3", "patch_ids": [], "statement_hash": "6dd22481d519ada003cf3022956ebe0c3ac5fbe8a27e2352c0e114ad33528372", "relations": [{"rule": 2, "type": "equivalent", "target": "3e27a2a85656b964f66c860c70248836", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6dd22481d519ada003cf3022956ebe0c3ac5fbe8a27e2352c0e114ad33528372"}}, {"rule": 2, "type": "equivalent", "target": "83f37cc5a00730f2f6efdc8b47a82ae5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6dd22481d519ada003cf3022956ebe0c3ac5fbe8a27e2352c0e114ad33528372"}}, {"rule": 2, "type": "equivalent", "target": "a787a63eb7d46a13fb49da1d7154952c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6dd22481d519ada003cf3022956ebe0c3ac5fbe8a27e2352c0e114ad33528372"}}, {"rule": 2, "type": "equivalent", "target": "fa6f83f05c1fadac3a27a2a9b3013242", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6dd22481d519ada003cf3022956ebe0c3ac5fbe8a27e2352c0e114ad33528372"}}], "version": "9.6.7", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "fa6f83f05c1fadac3a27a2a9b3013242", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Ensure that all temporary files made by pg_upgrade are non-world-readable", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6dd22481d519ada003cf3022956ebe0c3ac5fbe8a27e2352c0e114ad33528372"}, "url": "/docs/compare/?release=10.2#10.2-4f881ffec7e1b506", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "3e27a2a85656b964f66c860c70248836", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Ensure that all temporary files made by pg_upgrade are non-world-readable", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6dd22481d519ada003cf3022956ebe0c3ac5fbe8a27e2352c0e114ad33528372"}, "url": "/docs/compare/?release=9.5.11#9.5.11-4f881ffec7e1b506", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "a787a63eb7d46a13fb49da1d7154952c", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Ensure that all temporary files made by pg_upgrade are non-world-readable", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6dd22481d519ada003cf3022956ebe0c3ac5fbe8a27e2352c0e114ad33528372"}, "url": "/docs/compare/?release=9.4.16#9.4.16-4f881ffec7e1b506", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "83f37cc5a00730f2f6efdc8b47a82ae5", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Ensure that all temporary files made by pg_upgrade are non-world-readable", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6dd22481d519ada003cf3022956ebe0c3ac5fbe8a27e2352c0e114ad33528372"}, "url": "/docs/compare/?release=9.3.21#9.3.21-4f881ffec7e1b506", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-42b765941060ed1e", "cves": [], "html": "Fix vacuuming of tuples that were updated while key-share locked (Andres Freund, Álvaro Herrera)
\nIn some cases VACUUM would fail to remove such tuples even though they are now dead, leading to assorted data corruption scenarios.
", "text": "Fix vacuuming of tuples that were updated while key-share locked (Andres Freund, Álvaro Herrera) In some cases VACUUM would fail to remove such tuples even though they are now dead, leading to assorted data corruption scenarios.", "title": "Fix vacuuming of tuples that were updated while key-share locked", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "73e84b6632cf99773637b29c40021b5b5d75a976b2e4acd3679a9f2e20abf97a", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix vacuuming of tuples that were updated while key-share locked (Andres Freund, Álvaro Herrera) In some cases VACUUM would fail to remove such tuples even though they are now dead, leading to assorted data corruption scenarios.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/002", "db_id": "578e6835f4779011e8832306cd6043a0", "patch_ids": [], "statement_hash": "c8ad791f7bf84f5505a2365b8e22d4c29e36943486f64cccbe995c52c6650bb4", "relations": [{"rule": 2, "type": "equivalent", "target": "2a6b2f9569c99147470015ad187b73cd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c8ad791f7bf84f5505a2365b8e22d4c29e36943486f64cccbe995c52c6650bb4"}}, {"rule": 2, "type": "equivalent", "target": "7131bc8c16e7a2bcdc9804fe19434a5a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c8ad791f7bf84f5505a2365b8e22d4c29e36943486f64cccbe995c52c6650bb4"}}, {"rule": 2, "type": "equivalent", "target": "f216ffc4af1e2efa4c6cbec02cfda9a9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c8ad791f7bf84f5505a2365b8e22d4c29e36943486f64cccbe995c52c6650bb4"}}, {"rule": 2, "type": "equivalent", "target": "f46cd1a709ac4d44c8b5ef458c63bb01", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c8ad791f7bf84f5505a2365b8e22d4c29e36943486f64cccbe995c52c6650bb4"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2a6b2f9569c99147470015ad187b73cd", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Fix vacuuming of tuples that were updated while key-share locked", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c8ad791f7bf84f5505a2365b8e22d4c29e36943486f64cccbe995c52c6650bb4"}, "url": "/docs/compare/?release=10.2#10.2-42b765941060ed1e", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "7131bc8c16e7a2bcdc9804fe19434a5a", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Fix vacuuming of tuples that were updated while key-share locked", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c8ad791f7bf84f5505a2365b8e22d4c29e36943486f64cccbe995c52c6650bb4"}, "url": "/docs/compare/?release=9.5.11#9.5.11-42b765941060ed1e", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "f46cd1a709ac4d44c8b5ef458c63bb01", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Fix vacuuming of tuples that were updated while key-share locked", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c8ad791f7bf84f5505a2365b8e22d4c29e36943486f64cccbe995c52c6650bb4"}, "url": "/docs/compare/?release=9.4.16#9.4.16-42b765941060ed1e", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "f216ffc4af1e2efa4c6cbec02cfda9a9", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Fix vacuuming of tuples that were updated while key-share locked", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c8ad791f7bf84f5505a2365b8e22d4c29e36943486f64cccbe995c52c6650bb4"}, "url": "/docs/compare/?release=9.3.21#9.3.21-42b765941060ed1e", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-9bb9edfcfc8a326f", "cves": [], "html": "Ensure that vacuum will always clean up the pending-insertions list of a GIN index (Masahiko Sawada)
\nThis is necessary to ensure that dead index entries get removed. The old code got it backwards, allowing vacuum to skip the cleanup if some other process were running cleanup concurrently, thus risking invalid entries being left behind in the index.
", "text": "Ensure that vacuum will always clean up the pending-insertions list of a GIN index (Masahiko Sawada) This is necessary to ensure that dead index entries get removed. The old code got it backwards, allowing vacuum to skip the cleanup if some other process were running cleanup concurrently, thus risking invalid entries being left behind in the index.", "title": "Ensure that vacuum will always clean up the pending-insertions list of a GIN index", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "8c8c1ac28d34b9a9de72426bb720f5b15c93fd782a12f6cd2ad61893426d52f9", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ensure that vacuum will always clean up the pending-insertions list of a GIN index (Masahiko Sawada) This is necessary to ensure that dead index entries get removed. The old code got it backwards, allowing vacuum to skip the cleanup if some other process were running cleanup concurrently, thus risking invalid entries being left behind in the index.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/003", "db_id": "3194dc650475d6976ab52d8f1a97adf3", "patch_ids": [], "statement_hash": "76b4a9828b68ca6c3b82cc1056de5eea5b938a6794b1b4ed051156cad5908aef", "relations": [{"rule": 2, "type": "equivalent", "target": "b052376bfcaef1ae4208dc25fdf5d24e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "76b4a9828b68ca6c3b82cc1056de5eea5b938a6794b1b4ed051156cad5908aef"}}], "version": "9.6.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b052376bfcaef1ae4208dc25fdf5d24e", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Ensure that vacuum will always clean up the pending-insertions list of a GIN index", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "76b4a9828b68ca6c3b82cc1056de5eea5b938a6794b1b4ed051156cad5908aef"}, "url": "/docs/compare/?release=10.2#10.2-9bb9edfcfc8a326f", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}]}, {"id": "9.6.7-e2aab45cf3aa2f85", "cves": [], "html": "Fix inadequate buffer locking in some LSN fetches (Jacob Champion, Asim Praveen, Ashwin Agrawal)
\nThese errors could result in misbehavior under concurrent load. The potential consequences have not been characterized fully.
", "text": "Fix inadequate buffer locking in some LSN fetches (Jacob Champion, Asim Praveen, Ashwin Agrawal) These errors could result in misbehavior under concurrent load. The potential consequences have not been characterized fully.", "title": "Fix inadequate buffer locking in some LSN fetches", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "b9f784f1e9e7fd807d5f1e94730ee26a9a2f4a0e38f26aed7cd5704a9ab074b2", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix inadequate buffer locking in some LSN fetches (Jacob Champion, Asim Praveen, Ashwin Agrawal) These errors could result in misbehavior under concurrent load. The potential consequences have not been characterized fully.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/004", "db_id": "2d24e732ff8f4bf60445f8ca110160ff", "patch_ids": [], "statement_hash": "2fdf21253cff1d6e2b11e41b8b952086c87381ddcf2bf60a738711cf34c146e5", "relations": [{"rule": 2, "type": "equivalent", "target": "7bb15c94de58df30ec8b8a47c835f471", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2fdf21253cff1d6e2b11e41b8b952086c87381ddcf2bf60a738711cf34c146e5"}}, {"rule": 2, "type": "equivalent", "target": "82385f5d32d884d22eed0db877d748be", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2fdf21253cff1d6e2b11e41b8b952086c87381ddcf2bf60a738711cf34c146e5"}}, {"rule": 2, "type": "equivalent", "target": "c6fdf4a4bb76269450a22fb6669dce9e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2fdf21253cff1d6e2b11e41b8b952086c87381ddcf2bf60a738711cf34c146e5"}}, {"rule": 2, "type": "equivalent", "target": "cbe59a3d9acef7ea5d799d47bce471b6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2fdf21253cff1d6e2b11e41b8b952086c87381ddcf2bf60a738711cf34c146e5"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "82385f5d32d884d22eed0db877d748be", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Fix inadequate buffer locking in some LSN fetches", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2fdf21253cff1d6e2b11e41b8b952086c87381ddcf2bf60a738711cf34c146e5"}, "url": "/docs/compare/?release=10.2#10.2-e2aab45cf3aa2f85", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "c6fdf4a4bb76269450a22fb6669dce9e", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Fix inadequate buffer locking in some LSN fetches", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2fdf21253cff1d6e2b11e41b8b952086c87381ddcf2bf60a738711cf34c146e5"}, "url": "/docs/compare/?release=9.5.11#9.5.11-e2aab45cf3aa2f85", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "7bb15c94de58df30ec8b8a47c835f471", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Fix inadequate buffer locking in some LSN fetches", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2fdf21253cff1d6e2b11e41b8b952086c87381ddcf2bf60a738711cf34c146e5"}, "url": "/docs/compare/?release=9.4.16#9.4.16-e2aab45cf3aa2f85", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "cbe59a3d9acef7ea5d799d47bce471b6", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Fix inadequate buffer locking in some LSN fetches", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2fdf21253cff1d6e2b11e41b8b952086c87381ddcf2bf60a738711cf34c146e5"}, "url": "/docs/compare/?release=9.3.21#9.3.21-e2aab45cf3aa2f85", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-7425d0ded14582fe", "cves": [], "html": "Fix incorrect query results from cases involving flattening of subqueries whose outputs are used in GROUPING SETS (Heikki Linnakangas)
", "text": "Fix incorrect query results from cases involving flattening of subqueries whose outputs are used in GROUPING SETS (Heikki Linnakangas)", "title": "Fix incorrect query results from cases involving flattening of subqueries whose outputs are used in GROUPING SETS", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "f49414060226a661b896c2320d71b19f6cf72770f400b4b577ec7a053c88cf36", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix incorrect query results from cases involving flattening of subqueries whose outputs are used in GROUPING SETS (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/005", "db_id": "1e0db148d19ff96a80e807156fb3b3e5", "patch_ids": [], "statement_hash": "21458917a4d7b5687a9910b6104024d1bff708ab774c45d67dd4119b07fcd080", "relations": [{"rule": 2, "type": "equivalent", "target": "48a53102476b3fb46a92ca6184adc3ba", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "21458917a4d7b5687a9910b6104024d1bff708ab774c45d67dd4119b07fcd080"}}, {"rule": 2, "type": "equivalent", "target": "5eff949fb375b872424760800cecea1d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "21458917a4d7b5687a9910b6104024d1bff708ab774c45d67dd4119b07fcd080"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "5eff949fb375b872424760800cecea1d", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Fix incorrect query results from cases involving flattening of subqueries whose outputs are used in GROUPING SETS", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "21458917a4d7b5687a9910b6104024d1bff708ab774c45d67dd4119b07fcd080"}, "url": "/docs/compare/?release=10.2#10.2-7425d0ded14582fe", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "48a53102476b3fb46a92ca6184adc3ba", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Fix incorrect query results from cases involving flattening of subqueries whose outputs are used in GROUPING SETS", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "21458917a4d7b5687a9910b6104024d1bff708ab774c45d67dd4119b07fcd080"}, "url": "/docs/compare/?release=9.5.11#9.5.11-7425d0ded14582fe", "source_url": "/docs/release/9.5.11/#AEN129473"}]}, {"id": "9.6.7-935b8d2a45586110", "cves": [], "html": "Avoid unnecessary failure in a query on an inheritance tree that occurs concurrently with some child table being removed from the tree by ALTER TABLE NO INHERIT (Tom Lane)
", "text": "Avoid unnecessary failure in a query on an inheritance tree that occurs concurrently with some child table being removed from the tree by ALTER TABLE NO INHERIT (Tom Lane)", "title": "Avoid unnecessary failure in a query on an inheritance tree that occurs concurrently with some child table being removed from the tree by ALTER TABLE NO INHERIT", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "f7cdd7b383b17a3cf012a58f7581f08db56919aab250fe8e8d3e4d7f77611fb1", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid unnecessary failure in a query on an inheritance tree that occurs concurrently with some child table being removed from the tree by ALTER TABLE NO INHERIT (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/006", "db_id": "af9fa0cdaebba6178e8ef3cee771b2d0", "patch_ids": [], "statement_hash": "cc654b379a0c8eec41d04ee7d796df284eb42e201413f8cb411fbbbf252c6725", "relations": [{"rule": 2, "type": "equivalent", "target": "0cc55490249e34237083218340c88c0c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc654b379a0c8eec41d04ee7d796df284eb42e201413f8cb411fbbbf252c6725"}}, {"rule": 2, "type": "equivalent", "target": "12a200b06d9b476c5a0186fd8e184492", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc654b379a0c8eec41d04ee7d796df284eb42e201413f8cb411fbbbf252c6725"}}, {"rule": 2, "type": "equivalent", "target": "1ae9a2ace3d085bedb8f5883b1a43fd9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc654b379a0c8eec41d04ee7d796df284eb42e201413f8cb411fbbbf252c6725"}}, {"rule": 2, "type": "equivalent", "target": "df486aeeee65140082a7b3c49b8ffdb2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc654b379a0c8eec41d04ee7d796df284eb42e201413f8cb411fbbbf252c6725"}}], "version": "9.6.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "12a200b06d9b476c5a0186fd8e184492", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Avoid unnecessary failure in a query on an inheritance tree that occurs concurrently with some child table being removed from the tree by ALTER TABLE NO INHERIT", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc654b379a0c8eec41d04ee7d796df284eb42e201413f8cb411fbbbf252c6725"}, "url": "/docs/compare/?release=10.2#10.2-935b8d2a45586110", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "df486aeeee65140082a7b3c49b8ffdb2", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Avoid unnecessary failure in a query on an inheritance tree that occurs concurrently with some child table being removed from the tree by ALTER TABLE NO INHERIT", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc654b379a0c8eec41d04ee7d796df284eb42e201413f8cb411fbbbf252c6725"}, "url": "/docs/compare/?release=9.5.11#9.5.11-935b8d2a45586110", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "1ae9a2ace3d085bedb8f5883b1a43fd9", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Avoid unnecessary failure in a query on an inheritance tree that occurs concurrently with some child table being removed from the tree by ALTER TABLE NO INHERIT", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc654b379a0c8eec41d04ee7d796df284eb42e201413f8cb411fbbbf252c6725"}, "url": "/docs/compare/?release=9.4.16#9.4.16-935b8d2a45586110", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "0cc55490249e34237083218340c88c0c", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Avoid unnecessary failure in a query on an inheritance tree that occurs concurrently with some child table being removed from the tree by ALTER TABLE NO INHERIT", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc654b379a0c8eec41d04ee7d796df284eb42e201413f8cb411fbbbf252c6725"}, "url": "/docs/compare/?release=9.3.21#9.3.21-935b8d2a45586110", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-58092772296e39aa", "cves": [], "html": "Fix spurious deadlock failures when multiple sessions are running CREATE INDEX CONCURRENTLY (Jeff Janes)
", "text": "Fix spurious deadlock failures when multiple sessions are running CREATE INDEX CONCURRENTLY (Jeff Janes)", "title": "Fix spurious deadlock failures when multiple sessions are running CREATE INDEX CONCURRENTLY", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "4a894834f3f70c6908444950c4f48c1ec5f525c1567b725c7bf619fefb4bac77", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix spurious deadlock failures when multiple sessions are running CREATE INDEX CONCURRENTLY (Jeff Janes)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/007", "db_id": "7b69a997555b1585a940774080a73459", "patch_ids": [], "statement_hash": "675b0b8c3696c290e15447ec5ff11f8f3bfb8d96dfa0d1acfc3ea611d4083532", "relations": [{"rule": 2, "type": "equivalent", "target": "4212e1f3b3e1916a6ba7fcc40ecd4a40", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "675b0b8c3696c290e15447ec5ff11f8f3bfb8d96dfa0d1acfc3ea611d4083532"}}, {"rule": 2, "type": "equivalent", "target": "598b8ce23eb7e5f07150c5e0eebe750f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "675b0b8c3696c290e15447ec5ff11f8f3bfb8d96dfa0d1acfc3ea611d4083532"}}, {"rule": 2, "type": "equivalent", "target": "e9d4f66d5fafb02f5fa5704380c481b7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "675b0b8c3696c290e15447ec5ff11f8f3bfb8d96dfa0d1acfc3ea611d4083532"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4212e1f3b3e1916a6ba7fcc40ecd4a40", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Fix spurious deadlock failures when multiple sessions are running CREATE INDEX CONCURRENTLY", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "675b0b8c3696c290e15447ec5ff11f8f3bfb8d96dfa0d1acfc3ea611d4083532"}, "url": "/docs/compare/?release=10.2#10.2-58092772296e39aa", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "598b8ce23eb7e5f07150c5e0eebe750f", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Fix spurious deadlock failures when multiple sessions are running CREATE INDEX CONCURRENTLY", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "675b0b8c3696c290e15447ec5ff11f8f3bfb8d96dfa0d1acfc3ea611d4083532"}, "url": "/docs/compare/?release=9.5.11#9.5.11-58092772296e39aa", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "e9d4f66d5fafb02f5fa5704380c481b7", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Fix spurious deadlock failures when multiple sessions are running CREATE INDEX CONCURRENTLY", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "675b0b8c3696c290e15447ec5ff11f8f3bfb8d96dfa0d1acfc3ea611d4083532"}, "url": "/docs/compare/?release=9.4.16#9.4.16-58092772296e39aa", "source_url": "/docs/release/9.4.16/#AEN121175"}]}, {"id": "9.6.7-be4c8f4b95287a31", "cves": [], "html": "Fix failures when an inheritance tree contains foreign child tables (Etsuro Fujita)
\nA mix of regular and foreign tables in an inheritance tree resulted in creation of incorrect plans for UPDATE and DELETE queries. This led to visible failures in some cases, notably when there are row-level triggers on a foreign child table.
", "text": "Fix failures when an inheritance tree contains foreign child tables (Etsuro Fujita) A mix of regular and foreign tables in an inheritance tree resulted in creation of incorrect plans for UPDATE and DELETE queries. This led to visible failures in some cases, notably when there are row-level triggers on a foreign child table.", "title": "Fix failures when an inheritance tree contains foreign child tables", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "d0c8234e62f5764913ee42a707d7f0bc3e4a47fff6e29615801b15c572472af3", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix failures when an inheritance tree contains foreign child tables (Etsuro Fujita) A mix of regular and foreign tables in an inheritance tree resulted in creation of incorrect plans for UPDATE and DELETE queries. This led to visible failures in some cases, notably when there are row-level triggers on a foreign child table.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/008", "db_id": "3e219e430a3ac60fe3c0ae8b96261e5e", "patch_ids": [], "statement_hash": "7a12ea3210f4b16f86cc574f39f934f265e36c24ac1419c03685b50bc4e74f39", "relations": [{"rule": 2, "type": "equivalent", "target": "0daca53b9d435a9015e518004011a4fe", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7a12ea3210f4b16f86cc574f39f934f265e36c24ac1419c03685b50bc4e74f39"}}, {"rule": 2, "type": "equivalent", "target": "9d3ee6e07bdd121f21a643cf4929c09b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7a12ea3210f4b16f86cc574f39f934f265e36c24ac1419c03685b50bc4e74f39"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "9d3ee6e07bdd121f21a643cf4929c09b", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Fix failures when an inheritance tree contains foreign child tables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7a12ea3210f4b16f86cc574f39f934f265e36c24ac1419c03685b50bc4e74f39"}, "url": "/docs/compare/?release=10.2#10.2-be4c8f4b95287a31", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "0daca53b9d435a9015e518004011a4fe", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Fix failures when an inheritance tree contains foreign child tables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7a12ea3210f4b16f86cc574f39f934f265e36c24ac1419c03685b50bc4e74f39"}, "url": "/docs/compare/?release=9.5.11#9.5.11-be4c8f4b95287a31", "source_url": "/docs/release/9.5.11/#AEN129473"}]}, {"id": "9.6.7-bca10a34b0d3758c", "cves": [], "html": "Repair failure with correlated sub-SELECT inside VALUES inside a LATERAL subquery (Tom Lane)
", "text": "Repair failure with correlated sub-SELECT inside VALUES inside a LATERAL subquery (Tom Lane)", "title": "Repair failure with correlated sub-SELECT inside VALUES inside a LATERAL subquery", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "aaf87391ba4793ce3343e4b693af384dae1d7fef1fdc8585c58e64af130356ba", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Repair failure with correlated sub-SELECT inside VALUES inside a LATERAL subquery (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/009", "db_id": "8c72ac6b2fba11c344919a4d10bf6d22", "patch_ids": [], "statement_hash": "7e2bf5803eece4b3b275459218bd07eda11a84298021b5808f5fec7c2c6a7d9c", "relations": [{"rule": 2, "type": "equivalent", "target": "08317401be83c287ffb1e92b829f98c8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7e2bf5803eece4b3b275459218bd07eda11a84298021b5808f5fec7c2c6a7d9c"}}, {"rule": 2, "type": "equivalent", "target": "24e4a244bb80527b6b2f75d88c341130", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7e2bf5803eece4b3b275459218bd07eda11a84298021b5808f5fec7c2c6a7d9c"}}, {"rule": 2, "type": "equivalent", "target": "3cdb2c132ad40c77431e35911ee4b48b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7e2bf5803eece4b3b275459218bd07eda11a84298021b5808f5fec7c2c6a7d9c"}}, {"rule": 2, "type": "equivalent", "target": "65fc85b0b47fabd240409d5f2054d96d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7e2bf5803eece4b3b275459218bd07eda11a84298021b5808f5fec7c2c6a7d9c"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "65fc85b0b47fabd240409d5f2054d96d", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Repair failure with correlated sub-SELECT inside VALUES inside a LATERAL subquery", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7e2bf5803eece4b3b275459218bd07eda11a84298021b5808f5fec7c2c6a7d9c"}, "url": "/docs/compare/?release=10.2#10.2-bca10a34b0d3758c", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "3cdb2c132ad40c77431e35911ee4b48b", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Repair failure with correlated sub-SELECT inside VALUES inside a LATERAL subquery", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7e2bf5803eece4b3b275459218bd07eda11a84298021b5808f5fec7c2c6a7d9c"}, "url": "/docs/compare/?release=9.5.11#9.5.11-bca10a34b0d3758c", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "08317401be83c287ffb1e92b829f98c8", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Repair failure with correlated sub-SELECT inside VALUES inside a LATERAL subquery", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7e2bf5803eece4b3b275459218bd07eda11a84298021b5808f5fec7c2c6a7d9c"}, "url": "/docs/compare/?release=9.4.16#9.4.16-bca10a34b0d3758c", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "24e4a244bb80527b6b2f75d88c341130", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Repair failure with correlated sub-SELECT inside VALUES inside a LATERAL subquery", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7e2bf5803eece4b3b275459218bd07eda11a84298021b5808f5fec7c2c6a7d9c"}, "url": "/docs/compare/?release=9.3.21#9.3.21-bca10a34b0d3758c", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-c5fd2f943c3b4e06", "cves": [], "html": "Fix \"could not devise a query plan for the given query\" planner failure for some cases involving nested UNION ALL inside a lateral subquery (Tom Lane)
", "text": "Fix \"could not devise a query plan for the given query\" planner failure for some cases involving nested UNION ALL inside a lateral subquery (Tom Lane)", "title": "Fix \"could not devise a query plan for the given query\" planner failure for some cases involving nested UNION ALL inside a lateral subquery", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "095a42ddbde897f61eaf240d65d3391c5618373a0a78213b468c27f2f76ec9ee", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix could not devise a query plan for the given query planner failure for some cases involving nested UNION ALL inside a lateral subquery (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/010", "db_id": "67468e944bb781e37724ba62e3ac6fd3", "patch_ids": [], "statement_hash": "2aa1c52310e2be0f968414a985940c6922ea17ebbcd5d5d0d2dcc1c8836c237c", "relations": [{"rule": 2, "type": "equivalent", "target": "11be3b46e5562e568dcf3eb498fbd102", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2aa1c52310e2be0f968414a985940c6922ea17ebbcd5d5d0d2dcc1c8836c237c"}}, {"rule": 2, "type": "equivalent", "target": "9f7497c7d9ffed7fc37192d093b636fe", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2aa1c52310e2be0f968414a985940c6922ea17ebbcd5d5d0d2dcc1c8836c237c"}}, {"rule": 2, "type": "equivalent", "target": "dbfdbb67dd1039ecbc3a40ba6a034d26", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2aa1c52310e2be0f968414a985940c6922ea17ebbcd5d5d0d2dcc1c8836c237c"}}, {"rule": 2, "type": "equivalent", "target": "f942ad4f0a998777c3ce08593d956283", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2aa1c52310e2be0f968414a985940c6922ea17ebbcd5d5d0d2dcc1c8836c237c"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "f942ad4f0a998777c3ce08593d956283", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Fix “could not devise a query plan for the given query” planner failure for some cases involving nested UNION ALL inside a lateral subquery", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2aa1c52310e2be0f968414a985940c6922ea17ebbcd5d5d0d2dcc1c8836c237c"}, "url": "/docs/compare/?release=10.2#10.2-d9371c686cd14aed", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "dbfdbb67dd1039ecbc3a40ba6a034d26", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Fix \"could not devise a query plan for the given query\" planner failure for some cases involving nested UNION ALL inside a lateral subquery", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2aa1c52310e2be0f968414a985940c6922ea17ebbcd5d5d0d2dcc1c8836c237c"}, "url": "/docs/compare/?release=9.5.11#9.5.11-c5fd2f943c3b4e06", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "11be3b46e5562e568dcf3eb498fbd102", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Fix \"could not devise a query plan for the given query\" planner failure for some cases involving nested UNION ALL inside a lateral subquery", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2aa1c52310e2be0f968414a985940c6922ea17ebbcd5d5d0d2dcc1c8836c237c"}, "url": "/docs/compare/?release=9.4.16#9.4.16-c5fd2f943c3b4e06", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "9f7497c7d9ffed7fc37192d093b636fe", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Fix \"could not devise a query plan for the given query\" planner failure for some cases involving nested UNION ALL inside a lateral subquery", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2aa1c52310e2be0f968414a985940c6922ea17ebbcd5d5d0d2dcc1c8836c237c"}, "url": "/docs/compare/?release=9.3.21#9.3.21-c5fd2f943c3b4e06", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-15df424cd64573cc", "cves": [], "html": "Fix logical decoding to correctly clean up disk files for crashed transactions (Atsushi Torikoshi)
\nLogical decoding may spill WAL records to disk for transactions generating many WAL records. Normally these files are cleaned up after the transaction's commit or abort record arrives; but if no such record is ever seen, the removal code misbehaved.
", "text": "Fix logical decoding to correctly clean up disk files for crashed transactions (Atsushi Torikoshi) Logical decoding may spill WAL records to disk for transactions generating many WAL records. Normally these files are cleaned up after the transaction's commit or abort record arrives; but if no such record is ever seen, the removal code misbehaved.", "title": "Fix logical decoding to correctly clean up disk files for crashed transactions", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "bbf1d7514f30a07c9305af1bd6d08da857a6b22272d1d1e33f0b5a29123994c2", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix logical decoding to correctly clean up disk files for crashed transactions (Atsushi Torikoshi) Logical decoding may spill WAL records to disk for transactions generating many WAL records. Normally these files are cleaned up after the transaction's commit or abort record arrives; but if no such record is ever seen, the removal code misbehaved.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/011", "db_id": "83dd6050e0a3001070dd3a37e3608644", "patch_ids": [], "statement_hash": "22ecb423ef2550addbdb9b0640c074d3b7932d794dd1520927386a27c8c41f58", "relations": [{"rule": 2, "type": "equivalent", "target": "9497dcb4664035e25dea5719273f7775", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "22ecb423ef2550addbdb9b0640c074d3b7932d794dd1520927386a27c8c41f58"}}, {"rule": 2, "type": "equivalent", "target": "c1380b5003065cde8718f6de81c5e697", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "22ecb423ef2550addbdb9b0640c074d3b7932d794dd1520927386a27c8c41f58"}}, {"rule": 2, "type": "equivalent", "target": "fa34b7fe4ae72800b6f3457f5a514f70", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "22ecb423ef2550addbdb9b0640c074d3b7932d794dd1520927386a27c8c41f58"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "9497dcb4664035e25dea5719273f7775", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Fix logical decoding to correctly clean up disk files for crashed transactions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "22ecb423ef2550addbdb9b0640c074d3b7932d794dd1520927386a27c8c41f58"}, "url": "/docs/compare/?release=10.2#10.2-15df424cd64573cc", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "fa34b7fe4ae72800b6f3457f5a514f70", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Fix logical decoding to correctly clean up disk files for crashed transactions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "22ecb423ef2550addbdb9b0640c074d3b7932d794dd1520927386a27c8c41f58"}, "url": "/docs/compare/?release=9.5.11#9.5.11-15df424cd64573cc", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "c1380b5003065cde8718f6de81c5e697", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Fix logical decoding to correctly clean up disk files for crashed transactions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "22ecb423ef2550addbdb9b0640c074d3b7932d794dd1520927386a27c8c41f58"}, "url": "/docs/compare/?release=9.4.16#9.4.16-15df424cd64573cc", "source_url": "/docs/release/9.4.16/#AEN121175"}]}, {"id": "9.6.7-7dce1a2a04a483ba", "cves": [], "html": "Fix walsender timeout failure and failure to respond to interrupts when processing a large transaction (Petr Jelinek)
", "text": "Fix walsender timeout failure and failure to respond to interrupts when processing a large transaction (Petr Jelinek)", "title": "Fix walsender timeout failure and failure to respond to interrupts when processing a large transaction", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "e1b11784ef50f9815f76c92e1a245481d522baf99f20048fbbbc106816541378", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix walsender timeout failure and failure to respond to interrupts when processing a large transaction (Petr Jelinek)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/012", "db_id": "04df9533a2e0c239993c4f25740c3f2c", "patch_ids": [], "statement_hash": "3688b7e06c4f12e21fd0acc9101d472bcb1ebb84425dc9932b6b565cc9913df2", "relations": [{"rule": 2, "type": "equivalent", "target": "0641ecfcd209be620a7f15faf0c8b1d3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3688b7e06c4f12e21fd0acc9101d472bcb1ebb84425dc9932b6b565cc9913df2"}}, {"rule": 2, "type": "equivalent", "target": "49d5a018edca09aa50a64ee6c2dcb3cf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3688b7e06c4f12e21fd0acc9101d472bcb1ebb84425dc9932b6b565cc9913df2"}}, {"rule": 2, "type": "equivalent", "target": "8c59f13b8514866cfb7e0fec2a8151dc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3688b7e06c4f12e21fd0acc9101d472bcb1ebb84425dc9932b6b565cc9913df2"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "49d5a018edca09aa50a64ee6c2dcb3cf", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Fix walsender timeout failure and failure to respond to interrupts when processing a large transaction", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3688b7e06c4f12e21fd0acc9101d472bcb1ebb84425dc9932b6b565cc9913df2"}, "url": "/docs/compare/?release=10.2#10.2-7dce1a2a04a483ba", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "0641ecfcd209be620a7f15faf0c8b1d3", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Fix walsender timeout failure and failure to respond to interrupts when processing a large transaction", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3688b7e06c4f12e21fd0acc9101d472bcb1ebb84425dc9932b6b565cc9913df2"}, "url": "/docs/compare/?release=9.5.11#9.5.11-7dce1a2a04a483ba", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "8c59f13b8514866cfb7e0fec2a8151dc", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Fix walsender timeout failure and failure to respond to interrupts when processing a large transaction", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3688b7e06c4f12e21fd0acc9101d472bcb1ebb84425dc9932b6b565cc9913df2"}, "url": "/docs/compare/?release=9.4.16#9.4.16-7dce1a2a04a483ba", "source_url": "/docs/release/9.4.16/#AEN121175"}]}, {"id": "9.6.7-5b1d6228e4082f50", "cves": [], "html": "Fix has_sequence_privilege() to support WITH GRANT OPTION tests, as other privilege-testing functions do (Joe Conway)
In databases using UTF8 encoding, ignore any XML declaration that asserts a different encoding (Pavel Stehule, Noah Misch)
\nWe always store XML strings in the database encoding, so allowing libxml to act on a declaration of another encoding gave wrong results. In encodings other than UTF8, we don't promise to support non-ASCII XML data anyway, so retain the previous behavior for bug compatibility. This change affects only xpath() and related functions; other XML code paths already acted this way.
Provide for forward compatibility with future minor protocol versions (Robert Haas, Badrul Chowdhury)
\nUp to now, PostgreSQL servers simply rejected requests to use protocol versions newer than 3.0, so that there was no functional difference between the major and minor parts of the protocol version number. Allow clients to request versions 3.x without failing, sending back a message showing that the server only understands 3.0. This makes no difference at the moment, but back-patching this change should allow speedier introduction of future minor protocol upgrades.
", "text": "Provide for forward compatibility with future minor protocol versions (Robert Haas, Badrul Chowdhury) Up to now, PostgreSQL servers simply rejected requests to use protocol versions newer than 3.0, so that there was no functional difference between the major and minor parts of the protocol version number. Allow clients to request versions 3.x without failing, sending back a message showing that the server only understands 3.0. This makes no difference at the moment, but back-patching this change should allow speedier introduction of future minor protocol upgrades.", "title": "Provide for forward compatibility with future minor protocol versions", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "a632191843cf1a6c894698424ba743faea2866623ef6f7ef17779ccc74e37ae8", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Provide for forward compatibility with future minor protocol versions (Robert Haas, Badrul Chowdhury) Up to now, PostgreSQL servers simply rejected requests to use protocol versions newer than 3.0, so that there was no functional difference between the major and minor parts of the protocol version number. Allow clients to request versions 3.x without failing, sending back a message showing that the server only understands 3.0. This makes no difference at the moment, but back-patching this change should allow speedier introduction of future minor protocol upgrades.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/015", "db_id": "922f5e76b2fc8a6ef5a033bb14730ec4", "patch_ids": [], "statement_hash": "081ebb6ea2f10d0f8e9f995ca705489cb715775481b5634ab2e759b1fc27937f", "relations": [{"rule": 2, "type": "equivalent", "target": "3bca875f15d6646be2ba689accfac0d0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "081ebb6ea2f10d0f8e9f995ca705489cb715775481b5634ab2e759b1fc27937f"}}, {"rule": 2, "type": "equivalent", "target": "4b25bdea5725fec36e838fba1cc4807f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "081ebb6ea2f10d0f8e9f995ca705489cb715775481b5634ab2e759b1fc27937f"}}, {"rule": 2, "type": "equivalent", "target": "5808ced71469317610618ca1565949c6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "081ebb6ea2f10d0f8e9f995ca705489cb715775481b5634ab2e759b1fc27937f"}}, {"rule": 2, "type": "equivalent", "target": "fc71934fa6f0e20f15e2a3d74cf2224c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "081ebb6ea2f10d0f8e9f995ca705489cb715775481b5634ab2e759b1fc27937f"}}], "version": "9.6.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "3bca875f15d6646be2ba689accfac0d0", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Provide for forward compatibility with future minor protocol versions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "081ebb6ea2f10d0f8e9f995ca705489cb715775481b5634ab2e759b1fc27937f"}, "url": "/docs/compare/?release=10.2#10.2-021962a240435bb8", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "5808ced71469317610618ca1565949c6", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Provide for forward compatibility with future minor protocol versions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "081ebb6ea2f10d0f8e9f995ca705489cb715775481b5634ab2e759b1fc27937f"}, "url": "/docs/compare/?release=9.5.11#9.5.11-021962a240435bb8", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "4b25bdea5725fec36e838fba1cc4807f", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Provide for forward compatibility with future minor protocol versions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "081ebb6ea2f10d0f8e9f995ca705489cb715775481b5634ab2e759b1fc27937f"}, "url": "/docs/compare/?release=9.4.16#9.4.16-021962a240435bb8", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "fc71934fa6f0e20f15e2a3d74cf2224c", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Provide for forward compatibility with future minor protocol versions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "081ebb6ea2f10d0f8e9f995ca705489cb715775481b5634ab2e759b1fc27937f"}, "url": "/docs/compare/?release=9.3.21#9.3.21-021962a240435bb8", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-04ba434270e4f9b4", "cves": [], "html": "Cope with failure to start a parallel worker process (Amit Kapila, Robert Haas)
\nParallel query previously tended to hang indefinitely if a worker could not be started, as the result of fork() failure or other low-probability problems.
", "text": "Cope with failure to start a parallel worker process (Amit Kapila, Robert Haas) Parallel query previously tended to hang indefinitely if a worker could not be started, as the result of fork() failure or other low-probability problems.", "title": "Cope with failure to start a parallel worker process", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "087fdf232879c1e771e8b8b7a1a9e340f185c3b22511dee44eb4d7ba5ef22423", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Cope with failure to start a parallel worker process (Amit Kapila, Robert Haas) Parallel query previously tended to hang indefinitely if a worker could not be started, as the result of fork() failure or other low-probability problems.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/016", "db_id": "912057b0fb784495baa32fbcad51b36e", "patch_ids": [], "statement_hash": "f7f60e1ef443b57d289fa9095d7ea04d5e2c567acccda0a53c262f05943efa05", "relations": [{"rule": 2, "type": "equivalent", "target": "28e0f5c1a56cedd75a944b0038dc3930", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f7f60e1ef443b57d289fa9095d7ea04d5e2c567acccda0a53c262f05943efa05"}}, {"rule": 2, "type": "equivalent", "target": "4e971de322b6927fa12fd621eb383aa1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f7f60e1ef443b57d289fa9095d7ea04d5e2c567acccda0a53c262f05943efa05"}}, {"rule": 2, "type": "equivalent", "target": "5f433863c9741c37f4bc74b83c759469", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f7f60e1ef443b57d289fa9095d7ea04d5e2c567acccda0a53c262f05943efa05"}}], "version": "9.6.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "4e971de322b6927fa12fd621eb383aa1", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Cope with failure to start a parallel worker process", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f7f60e1ef443b57d289fa9095d7ea04d5e2c567acccda0a53c262f05943efa05"}, "url": "/docs/compare/?release=10.2#10.2-04ba434270e4f9b4", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "5f433863c9741c37f4bc74b83c759469", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Cope with failure to start a parallel worker process", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f7f60e1ef443b57d289fa9095d7ea04d5e2c567acccda0a53c262f05943efa05"}, "url": "/docs/compare/?release=9.5.11#9.5.11-04ba434270e4f9b4", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "28e0f5c1a56cedd75a944b0038dc3930", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Cope with failure to start a parallel worker process", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f7f60e1ef443b57d289fa9095d7ea04d5e2c567acccda0a53c262f05943efa05"}, "url": "/docs/compare/?release=9.4.16#9.4.16-04ba434270e4f9b4", "source_url": "/docs/release/9.4.16/#AEN121175"}]}, {"id": "9.6.7-a093b7201177cb46", "cves": [], "html": "Fix collection of EXPLAIN statistics from parallel workers (Amit Kapila, Thomas Munro)
", "text": "Fix collection of EXPLAIN statistics from parallel workers (Amit Kapila, Thomas Munro)", "title": "Fix collection of EXPLAIN statistics from parallel workers", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "3e0aa6ae7c7a5ad3b5672136d4bf14ad9ed07669fa5e6c477e3e76cbf952848b", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix collection of EXPLAIN statistics from parallel workers (Amit Kapila, Thomas Munro)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/017", "db_id": "2b7b460c370c084ee5adff225624057c", "patch_ids": [], "statement_hash": "7a672b8d8f1c4092225782922038e5288a69abaea2d95765f2dbcbec011dd224", "relations": [{"rule": 2, "type": "equivalent", "target": "925d351afafe20b26cffd43e5a213e30", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7a672b8d8f1c4092225782922038e5288a69abaea2d95765f2dbcbec011dd224"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "925d351afafe20b26cffd43e5a213e30", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Fix collection of EXPLAIN statistics from parallel workers", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7a672b8d8f1c4092225782922038e5288a69abaea2d95765f2dbcbec011dd224"}, "url": "/docs/compare/?release=10.2#10.2-a093b7201177cb46", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}]}, {"id": "9.6.7-af50ff7adc2950f9", "cves": [], "html": "Avoid unsafe alignment assumptions when working with __int128 (Tom Lane)
\nTypically, compilers assume that __int128 variables are aligned on 16-byte boundaries, but our memory allocation infrastructure isn't prepared to guarantee that, and increasing the setting of MAXALIGN seems infeasible for multiple reasons. Adjust the code to allow use of __int128 only when we can tell the compiler to assume lesser alignment. The only known symptom of this problem so far is crashes in some parallel aggregation queries.
", "text": "Avoid unsafe alignment assumptions when working with __int128 (Tom Lane) Typically, compilers assume that __int128 variables are aligned on 16-byte boundaries, but our memory allocation infrastructure isn't prepared to guarantee that, and increasing the setting of MAXALIGN seems infeasible for multiple reasons. Adjust the code to allow use of __int128 only when we can tell the compiler to assume lesser alignment. The only known symptom of this problem so far is crashes in some parallel aggregation queries.", "title": "Avoid unsafe alignment assumptions when working with __int128", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "a747071d2edc7988c4e107f054f5ec3c5d0f93b0c956f514c3d66ea1e5ecb65c", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid unsafe alignment assumptions when working with __int128 (Tom Lane) Typically, compilers assume that __int128 variables are aligned on 16-byte boundaries, but our memory allocation infrastructure isn't prepared to guarantee that, and increasing the setting of MAXALIGN seems infeasible for multiple reasons. Adjust the code to allow use of __int128 only when we can tell the compiler to assume lesser alignment. The only known symptom of this problem so far is crashes in some parallel aggregation queries.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/018", "db_id": "358035aaa951e105360b91b0086db322", "patch_ids": [], "statement_hash": "5ab4008c7c39c4c8d221a32ef9ccce2a76645415e05419661f903f8111dade77", "relations": [{"rule": 2, "type": "equivalent", "target": "8254372163ea60d86d0db416238a1a46", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5ab4008c7c39c4c8d221a32ef9ccce2a76645415e05419661f903f8111dade77"}}, {"rule": 2, "type": "equivalent", "target": "f992d405a4f26889b01734117727425a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5ab4008c7c39c4c8d221a32ef9ccce2a76645415e05419661f903f8111dade77"}}], "version": "9.6.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "8254372163ea60d86d0db416238a1a46", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Avoid unsafe alignment assumptions when working with __int128", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5ab4008c7c39c4c8d221a32ef9ccce2a76645415e05419661f903f8111dade77"}, "url": "/docs/compare/?release=10.2#10.2-af50ff7adc2950f9", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "f992d405a4f26889b01734117727425a", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Avoid unsafe alignment assumptions when working with __int128", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5ab4008c7c39c4c8d221a32ef9ccce2a76645415e05419661f903f8111dade77"}, "url": "/docs/compare/?release=9.5.11#9.5.11-af50ff7adc2950f9", "source_url": "/docs/release/9.5.11/#AEN129473"}]}, {"id": "9.6.7-a751b0b65fe5df8f", "cves": [], "html": "Prevent stack-overflow crashes when planning extremely deeply nested set operations (UNION/INTERSECT/EXCEPT) (Tom Lane)
", "text": "Prevent stack-overflow crashes when planning extremely deeply nested set operations (UNION/INTERSECT/EXCEPT) (Tom Lane)", "title": "Prevent stack-overflow crashes when planning extremely deeply nested set operations (UNION/INTERSECT/EXCEPT)", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "f3a60e65ce141907b511296cc3f9d8e16fd63c74c849e6364f71803b4721fc5f", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent stack-overflow crashes when planning extremely deeply nested set operations (UNION/INTERSECT/EXCEPT) (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/019", "db_id": "c0ab81df51c3929d239015f3a85d7c4d", "patch_ids": [], "statement_hash": "2e5305bde5e99938d4c50d70c4ff02af420da9937f6e79fea3652a574956dc37", "relations": [{"rule": 2, "type": "equivalent", "target": "01146443770f86ec5e5ca59fa9dbf321", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2e5305bde5e99938d4c50d70c4ff02af420da9937f6e79fea3652a574956dc37"}}, {"rule": 2, "type": "equivalent", "target": "568acb1455a8e36310b0b1c93fa873e3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2e5305bde5e99938d4c50d70c4ff02af420da9937f6e79fea3652a574956dc37"}}, {"rule": 2, "type": "equivalent", "target": "70e56a68f5bcb62b2cfbed2160e0f4dd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2e5305bde5e99938d4c50d70c4ff02af420da9937f6e79fea3652a574956dc37"}}, {"rule": 2, "type": "equivalent", "target": "c39c8bd24f5ac242f0b32c2b20b718a4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2e5305bde5e99938d4c50d70c4ff02af420da9937f6e79fea3652a574956dc37"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c39c8bd24f5ac242f0b32c2b20b718a4", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Prevent stack-overflow crashes when planning extremely deeply nested set operations (UNION/INTERSECT/EXCEPT)", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2e5305bde5e99938d4c50d70c4ff02af420da9937f6e79fea3652a574956dc37"}, "url": "/docs/compare/?release=10.2#10.2-a751b0b65fe5df8f", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "01146443770f86ec5e5ca59fa9dbf321", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Prevent stack-overflow crashes when planning extremely deeply nested set operations (UNION/INTERSECT/EXCEPT)", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2e5305bde5e99938d4c50d70c4ff02af420da9937f6e79fea3652a574956dc37"}, "url": "/docs/compare/?release=9.5.11#9.5.11-a751b0b65fe5df8f", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "568acb1455a8e36310b0b1c93fa873e3", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Prevent stack-overflow crashes when planning extremely deeply nested set operations (UNION/INTERSECT/EXCEPT)", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2e5305bde5e99938d4c50d70c4ff02af420da9937f6e79fea3652a574956dc37"}, "url": "/docs/compare/?release=9.4.16#9.4.16-a751b0b65fe5df8f", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "70e56a68f5bcb62b2cfbed2160e0f4dd", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Prevent stack-overflow crashes when planning extremely deeply nested set operations (UNION/INTERSECT/EXCEPT)", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2e5305bde5e99938d4c50d70c4ff02af420da9937f6e79fea3652a574956dc37"}, "url": "/docs/compare/?release=9.3.21#9.3.21-a751b0b65fe5df8f", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-8f2090d9eb69a73e", "cves": [], "html": "Fix null-pointer crashes for some types of LDAP URLs appearing in pg_hba.conf (Thomas Munro)
", "text": "Fix null-pointer crashes for some types of LDAP URLs appearing in pg_hba.conf (Thomas Munro)", "title": "Fix null-pointer crashes for some types of LDAP URLs appearing in pg_hba.conf", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "74022c27a629fc833d1351c27ccbd81ddae31e4000de86377fc43566c1263205", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix null-pointer crashes for some types of LDAP URLs appearing in pg_hba.conf (Thomas Munro)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/020", "db_id": "ae63d513a9079f9c6cc772c910b8b247", "patch_ids": [], "statement_hash": "4e409fb26b969875e83a5d241117f7cd7d1f1c459ac34ccbe22266ac96a40f46", "relations": [{"rule": 2, "type": "equivalent", "target": "3c9d22b3c22a6f1ca4e410e0748abf03", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4e409fb26b969875e83a5d241117f7cd7d1f1c459ac34ccbe22266ac96a40f46"}}, {"rule": 2, "type": "equivalent", "target": "7f352f1f8330378d049091ee91844a5b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4e409fb26b969875e83a5d241117f7cd7d1f1c459ac34ccbe22266ac96a40f46"}}, {"rule": 2, "type": "equivalent", "target": "bca9bf5667364948df95ee66aa7f939d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4e409fb26b969875e83a5d241117f7cd7d1f1c459ac34ccbe22266ac96a40f46"}}, {"rule": 2, "type": "equivalent", "target": "beca6294db18ff71808c71309eef783e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4e409fb26b969875e83a5d241117f7cd7d1f1c459ac34ccbe22266ac96a40f46"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "7f352f1f8330378d049091ee91844a5b", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Fix null-pointer crashes for some types of LDAP URLs appearing in pg_hba.conf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4e409fb26b969875e83a5d241117f7cd7d1f1c459ac34ccbe22266ac96a40f46"}, "url": "/docs/compare/?release=10.2#10.2-8f2090d9eb69a73e", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "beca6294db18ff71808c71309eef783e", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Fix null-pointer crashes for some types of LDAP URLs appearing in pg_hba.conf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4e409fb26b969875e83a5d241117f7cd7d1f1c459ac34ccbe22266ac96a40f46"}, "url": "/docs/compare/?release=9.5.11#9.5.11-8f2090d9eb69a73e", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "bca9bf5667364948df95ee66aa7f939d", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Fix null-pointer crashes for some types of LDAP URLs appearing in pg_hba.conf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4e409fb26b969875e83a5d241117f7cd7d1f1c459ac34ccbe22266ac96a40f46"}, "url": "/docs/compare/?release=9.4.16#9.4.16-8f2090d9eb69a73e", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "3c9d22b3c22a6f1ca4e410e0748abf03", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Fix null-pointer crashes for some types of LDAP URLs appearing in pg_hba.conf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4e409fb26b969875e83a5d241117f7cd7d1f1c459ac34ccbe22266ac96a40f46"}, "url": "/docs/compare/?release=9.3.21#9.3.21-8f2090d9eb69a73e", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-6562b96e9e27abc2", "cves": [], "html": "Fix sample INSTR() functions in the PL/pgSQL documentation (Yugo Nagata, Tom Lane)
These functions are stated to be Oracle® compatible, but they weren't exactly. In particular, there was a discrepancy in the interpretation of a negative third parameter: Oracle thinks that a negative value indicates the last place where the target substring can begin, whereas our functions took it as the last place where the target can end. Also, Oracle throws an error for a zero or negative fourth parameter, whereas our functions returned zero.
\nThe sample code has been adjusted to match Oracle's behavior more precisely. Users who have copied this code into their applications may wish to update their copies.
", "text": "Fix sample INSTR() functions in the PL/pgSQL documentation (Yugo Nagata, Tom Lane) These functions are stated to be Oracle® compatible, but they weren't exactly. In particular, there was a discrepancy in the interpretation of a negative third parameter: Oracle thinks that a negative value indicates the last place where the target substring can begin, whereas our functions took it as the last place where the target can end. Also, Oracle throws an error for a zero or negative fourth parameter, whereas our functions returned zero. The sample code has been adjusted to match Oracle's behavior more precisely. Users who have copied this code into their applications may wish to update their copies.", "title": "Fix sample INSTR() functions in the PL/pgSQL documentation", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "bb98c8dab7afd9a70dcc6ab2ecaa3069abbd7c7158b59b071b436bc1d41789f7", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix sample INSTR() functions in the PL/pgSQL documentation (Yugo Nagata, Tom Lane) These functions are stated to be Oracle compatible, but they weren't exactly. In particular, there was a discrepancy in the interpretation of a negative third parameter: Oracle thinks that a negative value indicates the last place where the target substring can begin, whereas our functions took it as the last place where the target can end. Also, Oracle throws an error for a zero or negative fourth parameter, whereas our functions returned zero. The sample code has been adjusted to match Oracle's behavior more precisely. Users who have copied this code into their applications may wish to update their copies.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/021", "db_id": "bb1989d6670ac970ea2dad251fc2a4f4", "patch_ids": [], "statement_hash": "de23639739a3c95ef29580cb3daca5a44562b6f62313f3abf54e2536496a9aba", "relations": [{"rule": 2, "type": "equivalent", "target": "074fbd98682930dbc3e7ac9e8e70373a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "de23639739a3c95ef29580cb3daca5a44562b6f62313f3abf54e2536496a9aba"}}, {"rule": 2, "type": "equivalent", "target": "4122a38677a7d168668c054735ce38bf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "de23639739a3c95ef29580cb3daca5a44562b6f62313f3abf54e2536496a9aba"}}, {"rule": 2, "type": "equivalent", "target": "4deafbbde1d67134a3ba61a5633ecec4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "de23639739a3c95ef29580cb3daca5a44562b6f62313f3abf54e2536496a9aba"}}, {"rule": 2, "type": "equivalent", "target": "f21202afc895bb07ec2a18d95aa85e98", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "de23639739a3c95ef29580cb3daca5a44562b6f62313f3abf54e2536496a9aba"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4deafbbde1d67134a3ba61a5633ecec4", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Fix sample INSTR() functions in the PL/pgSQL documentation", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "de23639739a3c95ef29580cb3daca5a44562b6f62313f3abf54e2536496a9aba"}, "url": "/docs/compare/?release=10.2#10.2-6562b96e9e27abc2", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "4122a38677a7d168668c054735ce38bf", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Fix sample INSTR() functions in the PL/pgSQL documentation", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "de23639739a3c95ef29580cb3daca5a44562b6f62313f3abf54e2536496a9aba"}, "url": "/docs/compare/?release=9.5.11#9.5.11-6562b96e9e27abc2", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "f21202afc895bb07ec2a18d95aa85e98", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Fix sample INSTR() functions in the PL/pgSQL documentation", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "de23639739a3c95ef29580cb3daca5a44562b6f62313f3abf54e2536496a9aba"}, "url": "/docs/compare/?release=9.4.16#9.4.16-6562b96e9e27abc2", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "074fbd98682930dbc3e7ac9e8e70373a", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Fix sample INSTR() functions in the PL/pgSQL documentation", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "de23639739a3c95ef29580cb3daca5a44562b6f62313f3abf54e2536496a9aba"}, "url": "/docs/compare/?release=9.3.21#9.3.21-6562b96e9e27abc2", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-81ab19703e058dea", "cves": [], "html": "Fix pg_dump to make ACL (permissions), comment, and security label entries reliably identifiable in archive output formats (Tom Lane)
\nThe \"tag\" portion of an ACL archive entry was usually just the name of the associated object. Make it start with the object type instead, bringing ACLs into line with the convention already used for comment and security label archive entries. Also, fix the comment and security label entries for the whole database, if present, to make their tags start with DATABASE so that they also follow this convention. This prevents false matches in code that tries to identify large-object-related entries by seeing if the tag starts with LARGE OBJECT. That could have resulted in misclassifying entries as data rather than schema, with undesirable results in a schema-only or data-only dump.
\nNote that this change has user-visible results in the output of pg_restore --list.
", "text": "Fix pg_dump to make ACL (permissions), comment, and security label entries reliably identifiable in archive output formats (Tom Lane) The \"tag\" portion of an ACL archive entry was usually just the name of the associated object. Make it start with the object type instead, bringing ACLs into line with the convention already used for comment and security label archive entries. Also, fix the comment and security label entries for the whole database, if present, to make their tags start with DATABASE so that they also follow this convention. This prevents false matches in code that tries to identify large-object-related entries by seeing if the tag starts with LARGE OBJECT. That could have resulted in misclassifying entries as data rather than schema, with undesirable results in a schema-only or data-only dump. Note that this change has user-visible results in the output of pg_restore --list.", "title": "Fix pg_dump to make ACL (permissions), comment, and security label entries reliably identifiable in archive output formats", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "5f63c24c21e64f67c5613c4b6beeeab02124e75920f3b4131215884e6ff67966", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix pg_dump to make ACL (permissions), comment, and security label entries reliably identifiable in archive output formats (Tom Lane) The tag portion of an ACL archive entry was usually just the name of the associated object. Make it start with the object type instead, bringing ACLs into line with the convention already used for comment and security label archive entries. Also, fix the comment and security label entries for the whole database, if present, to make their tags start with DATABASE so that they also follow this convention. This prevents false matches in code that tries to identify large-object-related entries by seeing if the tag starts with LARGE OBJECT. That could have resulted in misclassifying entries as data rather than schema, with undesirable results in a schema-only or data-only dump. Note that this change has user-visible results in the output of pg_restore --list.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/022", "db_id": "f7bf3dce4ce6e4a65a97b8e49bdff2f7", "patch_ids": [], "statement_hash": "208a1a037b4317c83088494c3af0cafb5ec6a9a8911bd2f31dce7ca085cc4acc", "relations": [{"rule": 2, "type": "equivalent", "target": "0ca9e270193416cad270eafba608b5f8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "208a1a037b4317c83088494c3af0cafb5ec6a9a8911bd2f31dce7ca085cc4acc"}}, {"rule": 2, "type": "equivalent", "target": "3b1f9393e931bb132457f7b3910110ac", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "208a1a037b4317c83088494c3af0cafb5ec6a9a8911bd2f31dce7ca085cc4acc"}}, {"rule": 2, "type": "equivalent", "target": "81373cee02430fe4af2cf207aa51dde5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "208a1a037b4317c83088494c3af0cafb5ec6a9a8911bd2f31dce7ca085cc4acc"}}, {"rule": 2, "type": "equivalent", "target": "f35413a1afcd2620afa667bd34efb3af", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "208a1a037b4317c83088494c3af0cafb5ec6a9a8911bd2f31dce7ca085cc4acc"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "3b1f9393e931bb132457f7b3910110ac", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Fix pg_dump to make ACL (permissions), comment, and security label entries reliably identifiable in archive output formats", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "208a1a037b4317c83088494c3af0cafb5ec6a9a8911bd2f31dce7ca085cc4acc"}, "url": "/docs/compare/?release=10.2#10.2-81ab19703e058dea", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "0ca9e270193416cad270eafba608b5f8", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Fix pg_dump to make ACL (permissions), comment, and security label entries reliably identifiable in archive output formats", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "208a1a037b4317c83088494c3af0cafb5ec6a9a8911bd2f31dce7ca085cc4acc"}, "url": "/docs/compare/?release=9.5.11#9.5.11-81ab19703e058dea", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "81373cee02430fe4af2cf207aa51dde5", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Fix pg_dump to make ACL (permissions), comment, and security label entries reliably identifiable in archive output formats", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "208a1a037b4317c83088494c3af0cafb5ec6a9a8911bd2f31dce7ca085cc4acc"}, "url": "/docs/compare/?release=9.4.16#9.4.16-81ab19703e058dea", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "f35413a1afcd2620afa667bd34efb3af", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Fix pg_dump to make ACL (permissions), comment, and security label entries reliably identifiable in archive output formats", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "208a1a037b4317c83088494c3af0cafb5ec6a9a8911bd2f31dce7ca085cc4acc"}, "url": "/docs/compare/?release=9.3.21#9.3.21-81ab19703e058dea", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-3363010fb1b9023b", "cves": [], "html": "Rename pg_rewind's copy_file_range function to avoid conflict with new Linux system call of that name (Andres Freund)
This change prevents build failures with newer glibc versions.
", "text": "Rename pg_rewind's copy_file_range function to avoid conflict with new Linux system call of that name (Andres Freund) This change prevents build failures with newer glibc versions.", "title": "Rename pg_rewind's copy_file_range function to avoid conflict with new Linux system call of that name", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "ed7bc836f3aa6373a3d5cb861d6397ff37ff0a24894c1c260e3fa7c2072d95c0", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Rename pg_rewind's copy_file_range function to avoid conflict with new Linux system call of that name (Andres Freund) This change prevents build failures with newer glibc versions.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/023", "db_id": "15df591343519b5476d876f19c9dc608", "patch_ids": [], "statement_hash": "da9577ec4bb49012598aca2938ad76c6d61619463721cf0fa473934d0a58ae5a", "relations": [{"rule": 2, "type": "equivalent", "target": "9a54b364bbc9fab1b05ea2a58c02e7f3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "da9577ec4bb49012598aca2938ad76c6d61619463721cf0fa473934d0a58ae5a"}}, {"rule": 2, "type": "equivalent", "target": "ab3d0a759d27a52424c5ee4b0e2d568c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "da9577ec4bb49012598aca2938ad76c6d61619463721cf0fa473934d0a58ae5a"}}], "version": "9.6.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "9a54b364bbc9fab1b05ea2a58c02e7f3", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Rename pg_rewind's copy_file_range function to avoid conflict with new Linux system call of that name", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "da9577ec4bb49012598aca2938ad76c6d61619463721cf0fa473934d0a58ae5a"}, "url": "/docs/compare/?release=10.2#10.2-3363010fb1b9023b", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "ab3d0a759d27a52424c5ee4b0e2d568c", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Rename pg_rewind's copy_file_range function to avoid conflict with new Linux system call of that name", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "da9577ec4bb49012598aca2938ad76c6d61619463721cf0fa473934d0a58ae5a"}, "url": "/docs/compare/?release=9.5.11#9.5.11-3363010fb1b9023b", "source_url": "/docs/release/9.5.11/#AEN129473"}]}, {"id": "9.6.7-83a12e39fbbae989", "cves": [], "html": "In ecpg, detect indicator arrays that do not have the correct length and report an error (David Rader)
", "text": "In ecpg, detect indicator arrays that do not have the correct length and report an error (David Rader)", "title": "In ecpg, detect indicator arrays that do not have the correct length and report an error", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "e917bd7fe303afbf67e7b7281e4d1696c885c40b4091a2694b25e2b859c03012", "section_path": ["Changes"], "commit_groups": [], "identity_text": "In ecpg, detect indicator arrays that do not have the correct length and report an error (David Rader)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/024", "db_id": "bc90c3b158d533f1785a76400861ddf8", "patch_ids": [], "statement_hash": "ed91a447df7c2fcd805aae2a9f8790c8bef46440b9d8232781dfb58a4b2f8867", "relations": [{"rule": 2, "type": "equivalent", "target": "23ebd41798b308ffaef0b9ec76885108", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ed91a447df7c2fcd805aae2a9f8790c8bef46440b9d8232781dfb58a4b2f8867"}}, {"rule": 2, "type": "equivalent", "target": "2bcc6c70c126ca045982a7568dd1c2a0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ed91a447df7c2fcd805aae2a9f8790c8bef46440b9d8232781dfb58a4b2f8867"}}, {"rule": 2, "type": "equivalent", "target": "30fd542104a3cc71e9b017949639401e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ed91a447df7c2fcd805aae2a9f8790c8bef46440b9d8232781dfb58a4b2f8867"}}, {"rule": 2, "type": "equivalent", "target": "ed00656fc4d0e1c664f2d46f7e9fdb9e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ed91a447df7c2fcd805aae2a9f8790c8bef46440b9d8232781dfb58a4b2f8867"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "23ebd41798b308ffaef0b9ec76885108", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "In ecpg, detect indicator arrays that do not have the correct length and report an error", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ed91a447df7c2fcd805aae2a9f8790c8bef46440b9d8232781dfb58a4b2f8867"}, "url": "/docs/compare/?release=10.2#10.2-83a12e39fbbae989", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "ed00656fc4d0e1c664f2d46f7e9fdb9e", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "In ecpg, detect indicator arrays that do not have the correct length and report an error", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ed91a447df7c2fcd805aae2a9f8790c8bef46440b9d8232781dfb58a4b2f8867"}, "url": "/docs/compare/?release=9.5.11#9.5.11-83a12e39fbbae989", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "2bcc6c70c126ca045982a7568dd1c2a0", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "In ecpg, detect indicator arrays that do not have the correct length and report an error", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ed91a447df7c2fcd805aae2a9f8790c8bef46440b9d8232781dfb58a4b2f8867"}, "url": "/docs/compare/?release=9.4.16#9.4.16-83a12e39fbbae989", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "30fd542104a3cc71e9b017949639401e", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "In ecpg, detect indicator arrays that do not have the correct length and report an error", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ed91a447df7c2fcd805aae2a9f8790c8bef46440b9d8232781dfb58a4b2f8867"}, "url": "/docs/compare/?release=9.3.21#9.3.21-83a12e39fbbae989", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-1bae79d9dc47f06f", "cves": [], "html": "Change the behavior of contrib/cube's cube ~> int operator to make it compatible with KNN search (Alexander Korotkov)
\nThe meaning of the second argument (the dimension selector) has been changed to make it predictable which value is selected even when dealing with cubes of varying dimensionalities.
\nThis is an incompatible change, but since the point of the operator was to be used in KNN searches, it seems rather useless as-is. After installing this update, any expression indexes or materialized views using this operator will need to be reindexed/refreshed.
", "text": "Change the behavior of contrib/cube's cube ~> int operator to make it compatible with KNN search (Alexander Korotkov) The meaning of the second argument (the dimension selector) has been changed to make it predictable which value is selected even when dealing with cubes of varying dimensionalities. This is an incompatible change, but since the point of the operator was to be used in KNN searches, it seems rather useless as-is. After installing this update, any expression indexes or materialized views using this operator will need to be reindexed/refreshed.", "title": "Change the behavior of contrib/cube's cube ~> int operator to make it compatible with KNN search", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "68897ffc75c672a04a0512dc7c32d009a5e51d4579022443b66521e4d60f2f9e", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Change the behavior of contrib/cube's cube ~> int operator to make it compatible with KNN search (Alexander Korotkov) The meaning of the second argument (the dimension selector) has been changed to make it predictable which value is selected even when dealing with cubes of varying dimensionalities. This is an incompatible change, but since the point of the operator was to be used in KNN searches, it seems rather useless as-is. After installing this update, any expression indexes or materialized views using this operator will need to be reindexed/refreshed.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/025", "db_id": "d0b16e0b4537c63a0e077219d1edfc1c", "patch_ids": [], "statement_hash": "06a632f718d0eb5585bb9171aa1bc9c412fe238936e76fef4ec377f2c4bac6f1", "relations": [{"rule": 2, "type": "equivalent", "target": "c082d0c5c448afa028fc402be054813f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "06a632f718d0eb5585bb9171aa1bc9c412fe238936e76fef4ec377f2c4bac6f1"}}], "version": "9.6.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "c082d0c5c448afa028fc402be054813f", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Change the behavior of contrib/cube's cube ~> int operator to make it compatible with KNN search", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "06a632f718d0eb5585bb9171aa1bc9c412fe238936e76fef4ec377f2c4bac6f1"}, "url": "/docs/compare/?release=10.2#10.2-1bae79d9dc47f06f", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}]}, {"id": "9.6.7-666beaa4c3c9861a", "cves": [], "html": "Avoid triggering a libc assertion in contrib/hstore, due to use of memcpy() with equal source and destination pointers (Tomas Vondra)
Fix incorrect display of tuples' null bitmaps in contrib/pageinspect (Maksim Milyutin)
", "text": "Fix incorrect display of tuples' null bitmaps in contrib/pageinspect (Maksim Milyutin)", "title": "Fix incorrect display of tuples' null bitmaps in contrib/pageinspect", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "16c2397d450c973d672bc96f68c2ef74368e5f0e280d8fc5d3144916ebd1e28c", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix incorrect display of tuples' null bitmaps in contrib/pageinspect (Maksim Milyutin)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/027", "db_id": "35e7abc5cdc4509d7cc0bff47f9afd46", "patch_ids": [], "statement_hash": "4091577f7f431cb5c01aa8ba5bb905a88f38071efa98e796f4e68912a8dac63c", "relations": [{"rule": 2, "type": "equivalent", "target": "3e16904f4a6b92fd4d34b1f2577f80ee", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4091577f7f431cb5c01aa8ba5bb905a88f38071efa98e796f4e68912a8dac63c"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "3e16904f4a6b92fd4d34b1f2577f80ee", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Fix incorrect display of tuples' null bitmaps in contrib/pageinspect", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4091577f7f431cb5c01aa8ba5bb905a88f38071efa98e796f4e68912a8dac63c"}, "url": "/docs/compare/?release=10.2#10.2-97cae1e31529d3d7", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}]}, {"id": "9.6.7-421b0a8211177c23", "cves": [], "html": "In contrib/postgres_fdw, avoid \"outer pathkeys do not match mergeclauses\" planner error when constructing a plan involving a remote join (Robert Haas)
", "text": "In contrib/postgres_fdw, avoid \"outer pathkeys do not match mergeclauses\" planner error when constructing a plan involving a remote join (Robert Haas)", "title": "In contrib/postgres_fdw, avoid \"outer pathkeys do not match mergeclauses\" planner error when constructing a plan involving a remote join", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "abc2cdb4ba405e4de2be956af8194fec89d5df9d47513f8530683075bb217dfa", "section_path": ["Changes"], "commit_groups": [], "identity_text": "In contrib/postgres_fdw, avoid outer pathkeys do not match mergeclauses planner error when constructing a plan involving a remote join (Robert Haas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/028", "db_id": "600bbd6c0b48df27ca3351eecec28c35", "patch_ids": [], "statement_hash": "57b83516ee8ef736f75a5c5261096f79752f7515642de945899e026f8480cc98", "relations": [{"rule": 2, "type": "equivalent", "target": "2b40f94240b67916dab3ec3c10ed06d9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "57b83516ee8ef736f75a5c5261096f79752f7515642de945899e026f8480cc98"}}], "version": "9.6.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "2b40f94240b67916dab3ec3c10ed06d9", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "In contrib/postgres_fdw, avoid “outer pathkeys do not match mergeclauses” planner error when constructing a plan involving a remote join", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "57b83516ee8ef736f75a5c5261096f79752f7515642de945899e026f8480cc98"}, "url": "/docs/compare/?release=10.2#10.2-d71c7a94c77efeef", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}]}, {"id": "9.6.7-c8da12d7d8b28b51", "cves": [], "html": "Provide modern examples of how to auto-start Postgres on macOS (Tom Lane)
\nThe scripts in contrib/start-scripts/osx use infrastructure that's been deprecated for over a decade, and which no longer works at all in macOS releases of the last couple of years. Add a new subdirectory contrib/start-scripts/macos containing scripts that use the newer launchd infrastructure.
", "text": "Provide modern examples of how to auto-start Postgres on macOS (Tom Lane) The scripts in contrib/start-scripts/osx use infrastructure that's been deprecated for over a decade, and which no longer works at all in macOS releases of the last couple of years. Add a new subdirectory contrib/start-scripts/macos containing scripts that use the newer launchd infrastructure.", "title": "Provide modern examples of how to auto-start Postgres on macOS", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "4bf30ef67c502cce1f2ec63e802b358ad46dedc0cbc0a6ab7f623320e9932818", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Provide modern examples of how to auto-start Postgres on macOS (Tom Lane) The scripts in contrib/start-scripts/osx use infrastructure that's been deprecated for over a decade, and which no longer works at all in macOS releases of the last couple of years. Add a new subdirectory contrib/start-scripts/macos containing scripts that use the newer launchd infrastructure.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/029", "db_id": "24dc5e73850a35319c0666b533a1aa3a", "patch_ids": [], "statement_hash": "e99512b72b91312511653d4652583a17ade6b802743b3c40fcb8bfaca59d10b8", "relations": [{"rule": 2, "type": "equivalent", "target": "0fdc2e226045f15715881ba8537fe99e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e99512b72b91312511653d4652583a17ade6b802743b3c40fcb8bfaca59d10b8"}}, {"rule": 2, "type": "equivalent", "target": "a157895cacd9516d8a3e9d6a31ee8b63", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e99512b72b91312511653d4652583a17ade6b802743b3c40fcb8bfaca59d10b8"}}, {"rule": 2, "type": "equivalent", "target": "bb7559029434b895fcfddb50d9d1ece6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e99512b72b91312511653d4652583a17ade6b802743b3c40fcb8bfaca59d10b8"}}, {"rule": 2, "type": "equivalent", "target": "f05d3a9513c452c22d1e9a2c91061922", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e99512b72b91312511653d4652583a17ade6b802743b3c40fcb8bfaca59d10b8"}}], "version": "9.6.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "0fdc2e226045f15715881ba8537fe99e", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Provide modern examples of how to auto-start Postgres on macOS", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e99512b72b91312511653d4652583a17ade6b802743b3c40fcb8bfaca59d10b8"}, "url": "/docs/compare/?release=10.2#10.2-c8da12d7d8b28b51", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "f05d3a9513c452c22d1e9a2c91061922", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Provide modern examples of how to auto-start Postgres on macOS", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e99512b72b91312511653d4652583a17ade6b802743b3c40fcb8bfaca59d10b8"}, "url": "/docs/compare/?release=9.5.11#9.5.11-c8da12d7d8b28b51", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "a157895cacd9516d8a3e9d6a31ee8b63", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Provide modern examples of how to auto-start Postgres on macOS", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e99512b72b91312511653d4652583a17ade6b802743b3c40fcb8bfaca59d10b8"}, "url": "/docs/compare/?release=9.4.16#9.4.16-c8da12d7d8b28b51", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "bb7559029434b895fcfddb50d9d1ece6", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Provide modern examples of how to auto-start Postgres on macOS", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e99512b72b91312511653d4652583a17ade6b802743b3c40fcb8bfaca59d10b8"}, "url": "/docs/compare/?release=9.3.21#9.3.21-c8da12d7d8b28b51", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-befb61f36a968b2c", "cves": [], "html": "Fix incorrect selection of configuration-specific libraries for OpenSSL on Windows (Andrew Dunstan)
", "text": "Fix incorrect selection of configuration-specific libraries for OpenSSL on Windows (Andrew Dunstan)", "title": "Fix incorrect selection of configuration-specific libraries for OpenSSL on Windows", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "91975b8135e316b95a058f972d6ee5bfcf59c0caf51c44af7a2259f4d129db7a", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix incorrect selection of configuration-specific libraries for OpenSSL on Windows (Andrew Dunstan)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/030", "db_id": "11e979639d15d29074555e35b178314a", "patch_ids": [], "statement_hash": "1ea908d647320216739f789ef04442d13d52aa2ea310bed5173281be2efd9399", "relations": [{"rule": 2, "type": "equivalent", "target": "03fbe5da453e704a9f7b2c31d5f56b09", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1ea908d647320216739f789ef04442d13d52aa2ea310bed5173281be2efd9399"}}, {"rule": 2, "type": "equivalent", "target": "1821ace7637e06949219db456023ab75", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1ea908d647320216739f789ef04442d13d52aa2ea310bed5173281be2efd9399"}}, {"rule": 2, "type": "equivalent", "target": "35c027c555fdb7b27909b2417b5e53f7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1ea908d647320216739f789ef04442d13d52aa2ea310bed5173281be2efd9399"}}, {"rule": 2, "type": "equivalent", "target": "b6f28f745dffb36a98c91b630a747ea6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1ea908d647320216739f789ef04442d13d52aa2ea310bed5173281be2efd9399"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "03fbe5da453e704a9f7b2c31d5f56b09", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Fix incorrect selection of configuration-specific libraries for OpenSSL on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1ea908d647320216739f789ef04442d13d52aa2ea310bed5173281be2efd9399"}, "url": "/docs/compare/?release=10.2#10.2-befb61f36a968b2c", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "35c027c555fdb7b27909b2417b5e53f7", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Fix incorrect selection of configuration-specific libraries for OpenSSL on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1ea908d647320216739f789ef04442d13d52aa2ea310bed5173281be2efd9399"}, "url": "/docs/compare/?release=9.5.11#9.5.11-befb61f36a968b2c", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "b6f28f745dffb36a98c91b630a747ea6", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Fix incorrect selection of configuration-specific libraries for OpenSSL on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1ea908d647320216739f789ef04442d13d52aa2ea310bed5173281be2efd9399"}, "url": "/docs/compare/?release=9.4.16#9.4.16-befb61f36a968b2c", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "1821ace7637e06949219db456023ab75", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Fix incorrect selection of configuration-specific libraries for OpenSSL on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1ea908d647320216739f789ef04442d13d52aa2ea310bed5173281be2efd9399"}, "url": "/docs/compare/?release=9.3.21#9.3.21-befb61f36a968b2c", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-d1acb0f9ffeea28d", "cves": [], "html": "Support linking to MinGW-built versions of libperl (Noah Misch)
\nThis allows building PL/Perl with some common Perl distributions for Windows.
", "text": "Support linking to MinGW-built versions of libperl (Noah Misch) This allows building PL/Perl with some common Perl distributions for Windows.", "title": "Support linking to MinGW-built versions of libperl", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "f9faec3d53575a886ab2c42a250402cde6332d4a5207bef51b7f173c048fc8b6", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Support linking to MinGW-built versions of libperl (Noah Misch) This allows building PL/Perl with some common Perl distributions for Windows.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/031", "db_id": "7fbe36a96fb9befdcfc79ef52fa232c8", "patch_ids": [], "statement_hash": "214e3ac903ee3de3b960092db729643de8ac6fbd795d40971fddd79038f8bc92", "relations": [{"rule": 2, "type": "equivalent", "target": "039685f6945228e7540d88a1d1dae4c3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "214e3ac903ee3de3b960092db729643de8ac6fbd795d40971fddd79038f8bc92"}}, {"rule": 2, "type": "equivalent", "target": "049293f62d03819db6748a8f3a024190", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "214e3ac903ee3de3b960092db729643de8ac6fbd795d40971fddd79038f8bc92"}}, {"rule": 2, "type": "equivalent", "target": "227e18bb740b98a43e3c0590d886e950", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "214e3ac903ee3de3b960092db729643de8ac6fbd795d40971fddd79038f8bc92"}}, {"rule": 2, "type": "equivalent", "target": "27c3ee1b4261beeaa64885e79865a075", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "214e3ac903ee3de3b960092db729643de8ac6fbd795d40971fddd79038f8bc92"}}], "version": "9.6.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "227e18bb740b98a43e3c0590d886e950", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Support linking to MinGW-built versions of libperl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "214e3ac903ee3de3b960092db729643de8ac6fbd795d40971fddd79038f8bc92"}, "url": "/docs/compare/?release=10.2#10.2-d1acb0f9ffeea28d", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "049293f62d03819db6748a8f3a024190", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Support linking to MinGW-built versions of libperl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "214e3ac903ee3de3b960092db729643de8ac6fbd795d40971fddd79038f8bc92"}, "url": "/docs/compare/?release=9.5.11#9.5.11-d1acb0f9ffeea28d", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "039685f6945228e7540d88a1d1dae4c3", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Support linking to MinGW-built versions of libperl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "214e3ac903ee3de3b960092db729643de8ac6fbd795d40971fddd79038f8bc92"}, "url": "/docs/compare/?release=9.4.16#9.4.16-d1acb0f9ffeea28d", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "27c3ee1b4261beeaa64885e79865a075", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Support linking to MinGW-built versions of libperl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "214e3ac903ee3de3b960092db729643de8ac6fbd795d40971fddd79038f8bc92"}, "url": "/docs/compare/?release=9.3.21#9.3.21-d1acb0f9ffeea28d", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-6d63080ea6f321a6", "cves": [], "html": "Fix MSVC build to test whether 32-bit libperl needs -D_USE_32BIT_TIME_T (Noah Misch)
\nAvailable Perl distributions are inconsistent about what they expect, and lack any reliable means of reporting it, so resort to a build-time test on what the library being used actually does.
", "text": "Fix MSVC build to test whether 32-bit libperl needs -D_USE_32BIT_TIME_T (Noah Misch) Available Perl distributions are inconsistent about what they expect, and lack any reliable means of reporting it, so resort to a build-time test on what the library being used actually does.", "title": "Fix MSVC build to test whether 32-bit libperl needs -D_USE_32BIT_TIME_T", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "02431a2bcbc5c56e281b3e121553e71733c5f4fb6318ca0f196d651cea4e44ad", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix MSVC build to test whether 32-bit libperl needs -D_USE_32BIT_TIME_T (Noah Misch) Available Perl distributions are inconsistent about what they expect, and lack any reliable means of reporting it, so resort to a build-time test on what the library being used actually does.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/032", "db_id": "1a22595b7cd68b734f8a5a7551f89247", "patch_ids": [], "statement_hash": "0144077964ae151b8e72c535635da4e71ec263df554af7bd8f8ce7339fa45327", "relations": [{"rule": 2, "type": "equivalent", "target": "28df853935fd6bd79efc4f4325c6c920", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0144077964ae151b8e72c535635da4e71ec263df554af7bd8f8ce7339fa45327"}}, {"rule": 2, "type": "equivalent", "target": "4f10b5d5ac6eea55b9df82af9a09d0e7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0144077964ae151b8e72c535635da4e71ec263df554af7bd8f8ce7339fa45327"}}, {"rule": 2, "type": "equivalent", "target": "9036a968392bb422875a906ff6485fee", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0144077964ae151b8e72c535635da4e71ec263df554af7bd8f8ce7339fa45327"}}, {"rule": 2, "type": "equivalent", "target": "f4b0040686d69756f3ebb2c84af1d349", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0144077964ae151b8e72c535635da4e71ec263df554af7bd8f8ce7339fa45327"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4f10b5d5ac6eea55b9df82af9a09d0e7", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Fix MSVC build to test whether 32-bit libperl needs -D_USE_32BIT_TIME_T", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0144077964ae151b8e72c535635da4e71ec263df554af7bd8f8ce7339fa45327"}, "url": "/docs/compare/?release=10.2#10.2-6d63080ea6f321a6", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "9036a968392bb422875a906ff6485fee", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Fix MSVC build to test whether 32-bit libperl needs -D_USE_32BIT_TIME_T", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0144077964ae151b8e72c535635da4e71ec263df554af7bd8f8ce7339fa45327"}, "url": "/docs/compare/?release=9.5.11#9.5.11-6d63080ea6f321a6", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "28df853935fd6bd79efc4f4325c6c920", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Fix MSVC build to test whether 32-bit libperl needs -D_USE_32BIT_TIME_T", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0144077964ae151b8e72c535635da4e71ec263df554af7bd8f8ce7339fa45327"}, "url": "/docs/compare/?release=9.4.16#9.4.16-6d63080ea6f321a6", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "f4b0040686d69756f3ebb2c84af1d349", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Fix MSVC build to test whether 32-bit libperl needs -D_USE_32BIT_TIME_T", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0144077964ae151b8e72c535635da4e71ec263df554af7bd8f8ce7339fa45327"}, "url": "/docs/compare/?release=9.3.21#9.3.21-6d63080ea6f321a6", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-e20742db81bc6e15", "cves": [], "html": "On Windows, install the crash dump handler earlier in postmaster startup (Takayuki Tsunakawa)
\nThis may allow collection of a core dump for some early-startup failures that did not produce a dump before.
", "text": "On Windows, install the crash dump handler earlier in postmaster startup (Takayuki Tsunakawa) This may allow collection of a core dump for some early-startup failures that did not produce a dump before.", "title": "On Windows, install the crash dump handler earlier in postmaster startup", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "ce105f3523581cbd2f792b698f8af1cfa3729182b3a38f3161d31b5acc76aca3", "section_path": ["Changes"], "commit_groups": [], "identity_text": "On Windows, install the crash dump handler earlier in postmaster startup (Takayuki Tsunakawa) This may allow collection of a core dump for some early-startup failures that did not produce a dump before.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/033", "db_id": "adff4c7ba3dce256d567d3d96ba5193a", "patch_ids": [], "statement_hash": "9d690b43ddeaf0923b8a4df4179413defe61d92e6f3553f0a0d216ff5bb49823", "relations": [{"rule": 2, "type": "equivalent", "target": "001d2b44e15d4d920614bd624a7b8300", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d690b43ddeaf0923b8a4df4179413defe61d92e6f3553f0a0d216ff5bb49823"}}, {"rule": 2, "type": "equivalent", "target": "0f385e3a2a82eed547dcc4fabbcf8d25", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d690b43ddeaf0923b8a4df4179413defe61d92e6f3553f0a0d216ff5bb49823"}}, {"rule": 2, "type": "equivalent", "target": "65514a44c9c68979d1f15a1eba134f81", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d690b43ddeaf0923b8a4df4179413defe61d92e6f3553f0a0d216ff5bb49823"}}, {"rule": 2, "type": "equivalent", "target": "b52e37a6f1f6b19e88494b484af71ed9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d690b43ddeaf0923b8a4df4179413defe61d92e6f3553f0a0d216ff5bb49823"}}], "version": "9.6.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "001d2b44e15d4d920614bd624a7b8300", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "On Windows, install the crash dump handler earlier in postmaster startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d690b43ddeaf0923b8a4df4179413defe61d92e6f3553f0a0d216ff5bb49823"}, "url": "/docs/compare/?release=10.2#10.2-e20742db81bc6e15", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "b52e37a6f1f6b19e88494b484af71ed9", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "On Windows, install the crash dump handler earlier in postmaster startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d690b43ddeaf0923b8a4df4179413defe61d92e6f3553f0a0d216ff5bb49823"}, "url": "/docs/compare/?release=9.5.11#9.5.11-e20742db81bc6e15", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "65514a44c9c68979d1f15a1eba134f81", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "On Windows, install the crash dump handler earlier in postmaster startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d690b43ddeaf0923b8a4df4179413defe61d92e6f3553f0a0d216ff5bb49823"}, "url": "/docs/compare/?release=9.4.16#9.4.16-e20742db81bc6e15", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "0f385e3a2a82eed547dcc4fabbcf8d25", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "On Windows, install the crash dump handler earlier in postmaster startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d690b43ddeaf0923b8a4df4179413defe61d92e6f3553f0a0d216ff5bb49823"}, "url": "/docs/compare/?release=9.3.21#9.3.21-e20742db81bc6e15", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-7e0eb220fdf83d31", "cves": [], "html": "On Windows, avoid encoding-conversion-related crashes when emitting messages very early in postmaster startup (Takayuki Tsunakawa)
", "text": "On Windows, avoid encoding-conversion-related crashes when emitting messages very early in postmaster startup (Takayuki Tsunakawa)", "title": "On Windows, avoid encoding-conversion-related crashes when emitting messages very early in postmaster startup", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "3febb714b92e36f6c9ed4feaeced8a12f0e74783d3f1a0809f930d4d05f4f883", "section_path": ["Changes"], "commit_groups": [], "identity_text": "On Windows, avoid encoding-conversion-related crashes when emitting messages very early in postmaster startup (Takayuki Tsunakawa)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/034", "db_id": "b8c7d687fe34c827987df0ddbfd57bfc", "patch_ids": [], "statement_hash": "190592ac5ae8f15ffceec4270edb7e145088448fa4d1c40af56ebf90d5745e89", "relations": [{"rule": 2, "type": "equivalent", "target": "2649af25929b0e8b46307c46840fa986", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "190592ac5ae8f15ffceec4270edb7e145088448fa4d1c40af56ebf90d5745e89"}}, {"rule": 2, "type": "equivalent", "target": "3acbfa7fb5bd1041b24a68cd293fd1fe", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "190592ac5ae8f15ffceec4270edb7e145088448fa4d1c40af56ebf90d5745e89"}}, {"rule": 2, "type": "equivalent", "target": "f1804d79b68ca97f970ea754ca5a5e38", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "190592ac5ae8f15ffceec4270edb7e145088448fa4d1c40af56ebf90d5745e89"}}, {"rule": 2, "type": "equivalent", "target": "f7f1ccca62f5a4c6b703f051f441b902", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "190592ac5ae8f15ffceec4270edb7e145088448fa4d1c40af56ebf90d5745e89"}}], "version": "9.6.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2649af25929b0e8b46307c46840fa986", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "On Windows, avoid encoding-conversion-related crashes when emitting messages very early in postmaster startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "190592ac5ae8f15ffceec4270edb7e145088448fa4d1c40af56ebf90d5745e89"}, "url": "/docs/compare/?release=10.2#10.2-7e0eb220fdf83d31", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "3acbfa7fb5bd1041b24a68cd293fd1fe", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "On Windows, avoid encoding-conversion-related crashes when emitting messages very early in postmaster startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "190592ac5ae8f15ffceec4270edb7e145088448fa4d1c40af56ebf90d5745e89"}, "url": "/docs/compare/?release=9.5.11#9.5.11-7e0eb220fdf83d31", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "f7f1ccca62f5a4c6b703f051f441b902", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "On Windows, avoid encoding-conversion-related crashes when emitting messages very early in postmaster startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "190592ac5ae8f15ffceec4270edb7e145088448fa4d1c40af56ebf90d5745e89"}, "url": "/docs/compare/?release=9.4.16#9.4.16-7e0eb220fdf83d31", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "f1804d79b68ca97f970ea754ca5a5e38", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "On Windows, avoid encoding-conversion-related crashes when emitting messages very early in postmaster startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "190592ac5ae8f15ffceec4270edb7e145088448fa4d1c40af56ebf90d5745e89"}, "url": "/docs/compare/?release=9.3.21#9.3.21-7e0eb220fdf83d31", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-1507510022f78d57", "cves": [], "html": "Use our existing Motorola 68K spinlock code on OpenBSD as well as NetBSD (David Carlier)
", "text": "Use our existing Motorola 68K spinlock code on OpenBSD as well as NetBSD (David Carlier)", "title": "Use our existing Motorola 68K spinlock code on OpenBSD as well as NetBSD", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "6657bb175f4ea208475c428c6020c41e61cf688b8bf34a3029eaaf52aa6c3d33", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Use our existing Motorola 68K spinlock code on OpenBSD as well as NetBSD (David Carlier)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/035", "db_id": "2aaebb6e760e502605973f17c8ba4806", "patch_ids": [], "statement_hash": "c20caac556ee970db5ae07ee8c0a7b8691e4e47a807be85bc948c5c9c7997200", "relations": [{"rule": 2, "type": "equivalent", "target": "47c8164f89a81b8d4eb4b24ddf579ad5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c20caac556ee970db5ae07ee8c0a7b8691e4e47a807be85bc948c5c9c7997200"}}, {"rule": 2, "type": "equivalent", "target": "9b9ca2ad753ce490361c99a2856541f1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c20caac556ee970db5ae07ee8c0a7b8691e4e47a807be85bc948c5c9c7997200"}}, {"rule": 2, "type": "equivalent", "target": "caaff26961c06d094ce0f189421e2ec3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c20caac556ee970db5ae07ee8c0a7b8691e4e47a807be85bc948c5c9c7997200"}}, {"rule": 2, "type": "equivalent", "target": "dae1c877f244be94962949c6c6134b4e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c20caac556ee970db5ae07ee8c0a7b8691e4e47a807be85bc948c5c9c7997200"}}], "version": "9.6.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "dae1c877f244be94962949c6c6134b4e", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Use our existing Motorola 68K spinlock code on OpenBSD as well as NetBSD", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c20caac556ee970db5ae07ee8c0a7b8691e4e47a807be85bc948c5c9c7997200"}, "url": "/docs/compare/?release=10.2#10.2-1507510022f78d57", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "9b9ca2ad753ce490361c99a2856541f1", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Use our existing Motorola 68K spinlock code on OpenBSD as well as NetBSD", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c20caac556ee970db5ae07ee8c0a7b8691e4e47a807be85bc948c5c9c7997200"}, "url": "/docs/compare/?release=9.5.11#9.5.11-1507510022f78d57", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "caaff26961c06d094ce0f189421e2ec3", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Use our existing Motorola 68K spinlock code on OpenBSD as well as NetBSD", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c20caac556ee970db5ae07ee8c0a7b8691e4e47a807be85bc948c5c9c7997200"}, "url": "/docs/compare/?release=9.4.16#9.4.16-1507510022f78d57", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "47c8164f89a81b8d4eb4b24ddf579ad5", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Use our existing Motorola 68K spinlock code on OpenBSD as well as NetBSD", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c20caac556ee970db5ae07ee8c0a7b8691e4e47a807be85bc948c5c9c7997200"}, "url": "/docs/compare/?release=9.3.21#9.3.21-1507510022f78d57", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-08454666a4cc6839", "cves": [], "html": "Add support for spinlocks on Motorola 88K (David Carlier)
", "text": "Add support for spinlocks on Motorola 88K (David Carlier)", "title": "Add support for spinlocks on Motorola 88K", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "f3fd1dbc61144f8442662aafb353ae37db22211908a10b4bdba6251b73f71615", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Add support for spinlocks on Motorola 88K (David Carlier)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/036", "db_id": "cc385b4c4d8fce475f44782ab00544e5", "patch_ids": [], "statement_hash": "5f134771cb25ac5515e65273a619914280b19de080ffe2ae8d9daae52a9aff0a", "relations": [{"rule": 2, "type": "equivalent", "target": "0cd70096e5dd4b175a9d088a39c8b3b3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f134771cb25ac5515e65273a619914280b19de080ffe2ae8d9daae52a9aff0a"}}, {"rule": 2, "type": "equivalent", "target": "592b0e3550c45d12fa249c7f3a184a35", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f134771cb25ac5515e65273a619914280b19de080ffe2ae8d9daae52a9aff0a"}}, {"rule": 2, "type": "equivalent", "target": "8e5a1db0a07f57f25b8c7ad53e78bfb3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f134771cb25ac5515e65273a619914280b19de080ffe2ae8d9daae52a9aff0a"}}, {"rule": 2, "type": "equivalent", "target": "bfa9a28cc40a79a97ae78a5019724377", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f134771cb25ac5515e65273a619914280b19de080ffe2ae8d9daae52a9aff0a"}}], "version": "9.6.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "592b0e3550c45d12fa249c7f3a184a35", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Add support for spinlocks on Motorola 88K", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f134771cb25ac5515e65273a619914280b19de080ffe2ae8d9daae52a9aff0a"}, "url": "/docs/compare/?release=10.2#10.2-08454666a4cc6839", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "8e5a1db0a07f57f25b8c7ad53e78bfb3", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Add support for spinlocks on Motorola 88K", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f134771cb25ac5515e65273a619914280b19de080ffe2ae8d9daae52a9aff0a"}, "url": "/docs/compare/?release=9.5.11#9.5.11-08454666a4cc6839", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "0cd70096e5dd4b175a9d088a39c8b3b3", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Add support for spinlocks on Motorola 88K", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f134771cb25ac5515e65273a619914280b19de080ffe2ae8d9daae52a9aff0a"}, "url": "/docs/compare/?release=9.4.16#9.4.16-08454666a4cc6839", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "bfa9a28cc40a79a97ae78a5019724377", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Add support for spinlocks on Motorola 88K", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f134771cb25ac5515e65273a619914280b19de080ffe2ae8d9daae52a9aff0a"}, "url": "/docs/compare/?release=9.3.21#9.3.21-08454666a4cc6839", "source_url": "/docs/release/9.3.21/#AEN115635"}]}, {"id": "9.6.7-550386be5fa47ecc", "cves": [], "html": "Update time zone data files to tzdata release 2018c for DST law changes in Brazil, Sao Tome and Principe, plus historical corrections for Bolivia, Japan, and South Sudan. The US/Pacific-New zone has been removed (it was only an alias for America/Los_Angeles anyway).
", "text": "Update time zone data files to tzdata release 2018c for DST law changes in Brazil, Sao Tome and Principe, plus historical corrections for Bolivia, Japan, and South Sudan. The US/Pacific-New zone has been removed (it was only an alias for America/Los_Angeles anyway).", "title": "Update time zone data files to tzdata release 2018c for DST law changes in Brazil, Sao Tome and Principe, plus historical corrections for Bolivia, Japan, and South Sudan. The US/Pacific-New zone has been removed (it was only an alias for America/Los_Angeles anyway).", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.7/#AEN134783", "source_hash": "1433d781ba7b3786fac50812a2d08c464f18c515f70b422e4724a11cdd21dee5", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Update time zone data files to tzdata release 2018c for DST law changes in Brazil, Sao Tome and Principe, plus historical corrections for Bolivia, Japan, and South Sudan. The US/Pacific-New zone has been removed (it was only an alias for America/Los_Angeles anyway).", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.6.7/changes/037", "db_id": "64f0bacd61bdbcb4e7b5df04e7613b9e", "patch_ids": [], "statement_hash": "a9794a54502ba2eddd355ac36658530cbf5c51ebaf339249b1dbb9b3fe754dd9", "relations": [{"rule": 2, "type": "equivalent", "target": "44697021345d02256c38845c2989b023", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9794a54502ba2eddd355ac36658530cbf5c51ebaf339249b1dbb9b3fe754dd9"}}, {"rule": 2, "type": "equivalent", "target": "685247e6871674bcf06f3eb8ac95fc7f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9794a54502ba2eddd355ac36658530cbf5c51ebaf339249b1dbb9b3fe754dd9"}}, {"rule": 2, "type": "equivalent", "target": "96a6cd7de5daa3706770e0012b49d3e4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9794a54502ba2eddd355ac36658530cbf5c51ebaf339249b1dbb9b3fe754dd9"}}, {"rule": 2, "type": "equivalent", "target": "f9d5a9c145d7ccd1631d90c6f64f72da", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9794a54502ba2eddd355ac36658530cbf5c51ebaf339249b1dbb9b3fe754dd9"}}], "version": "9.6.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "96a6cd7de5daa3706770e0012b49d3e4", "kind": "equivalent", "version": "10.2", "label": "10.2", "title": "Update time zone data files to tzdata release 2018c for DST law changes in Brazil, Sao Tome and Principe, plus historical corrections for Bolivia, Japan, and South Sudan. The US/Pacific-New zone has been removed (it was only an alias for America/Los_Angeles anyway).", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9794a54502ba2eddd355ac36658530cbf5c51ebaf339249b1dbb9b3fe754dd9"}, "url": "/docs/compare/?release=10.2#10.2-550386be5fa47ecc", "source_url": "/docs/release/10.2/#id-1.11.6.26.5"}, {"db_id": "44697021345d02256c38845c2989b023", "kind": "equivalent", "version": "9.5.11", "label": "9.5.11", "title": "Update time zone data files to tzdata release 2018c for DST law changes in Brazil, Sao Tome and Principe, plus historical corrections for Bolivia, Japan, and South Sudan. The US/Pacific-New zone has been removed (it was only an alias for America/Los_Angeles anyway).", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9794a54502ba2eddd355ac36658530cbf5c51ebaf339249b1dbb9b3fe754dd9"}, "url": "/docs/compare/?release=9.5.11#9.5.11-550386be5fa47ecc", "source_url": "/docs/release/9.5.11/#AEN129473"}, {"db_id": "685247e6871674bcf06f3eb8ac95fc7f", "kind": "equivalent", "version": "9.4.16", "label": "9.4.16", "title": "Update time zone data files to tzdata release 2018c for DST law changes in Brazil, Sao Tome and Principe, plus historical corrections for Bolivia, Japan, and South Sudan. The US/Pacific-New zone has been removed (it was only an alias for America/Los_Angeles anyway).", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9794a54502ba2eddd355ac36658530cbf5c51ebaf339249b1dbb9b3fe754dd9"}, "url": "/docs/compare/?release=9.4.16#9.4.16-550386be5fa47ecc", "source_url": "/docs/release/9.4.16/#AEN121175"}, {"db_id": "f9d5a9c145d7ccd1631d90c6f64f72da", "kind": "equivalent", "version": "9.3.21", "label": "9.3.21", "title": "Update time zone data files to tzdata release 2018c for DST law changes in Brazil, Sao Tome and Principe, plus historical corrections for Bolivia, Japan, and South Sudan. The US/Pacific-New zone has been removed (it was only an alias for America/Los_Angeles anyway).", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9794a54502ba2eddd355ac36658530cbf5c51ebaf339249b1dbb9b3fe754dd9"}, "url": "/docs/compare/?release=9.3.21#9.3.21-550386be5fa47ecc", "source_url": "/docs/release/9.3.21/#AEN115635"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 37}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 20}, {"key": "security", "label": "Security", "count": 1}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 16}], "total": 37, "release_count": 1, "cross_major": false, "cve_count": 1, "cves": [{"id": "CVE-2018-1053", "url": "https://www.postgresql.org/support/security/CVE-2018-1053/", "fixed": {"10": "10.2", "9.3": "9.3.21", "9.4": "9.4.16", "9.5": "9.5.11", "9.6": "9.6.7"}, "score": 6.7, "title": "Ensure that all temporary files made by pg_upgrade are non-world-readable", "vector": "AV:L/AC:H/PR:L/UI:R/S:U/C:H/I:H/A:H", "affected": {"10": "10", "9.3": "9.3", "9.4": "9.4", "9.5": "9.5", "9.6": "9.6"}, "component": "client", "published": {"10": "2018-02-08", "9.3": "2018-02-08", "9.4": "2018-02-08", "9.5": "2018-02-08", "9.6": "2018-02-08"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2018-02-08", "fixed_version": "9.6.7"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 37, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}