A dump/restore is not required for those running 9.6.X.
\nHowever, if you are upgrading from a version earlier than 9.6.9, see Section E.16.
", "compatibility_count": 0, "label": "9.6.14", "status_label": "Historical", "eol": "2021-11-11", "age_days": 2658, "support_days": -1783}, "groups": [{"date": "2019-06-20", "build": "9.6.14", "major": "9.6", "minor": 14, "manual": "9.6", "status": "stable", "doc_git": "", "version": "9.6.14", "eol_date": "2021-11-11", "date_text": "2019-06-20", "supported": false, "manual_url": "/docs/9.6/release-9-6-14.html", "source_url": "/docs/release/9.6.14/", "entry_count": 17, "placeholder": false, "content_hash": "f86eabfca16468ac37e14e84b2260b04986e1151b35cb984d680508d7d76c523", "manual_build": "9.6.24", "source_as_of": "", "changes_count": 17, "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 are upgrading from a version earlier than 9.6.9, see Section E.16.
", "compatibility_count": 0, "label": "9.6.14", "status_label": "Historical", "eol": "2021-11-11", "age_days": 2658, "support_days": -1783, "entries": [{"id": "9.6.14-e4223bd140057e5e", "cves": [], "html": "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when the table has a partial exclusion constraint (Tom Lane)
", "text": "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when the table has a partial exclusion constraint (Tom Lane)", "title": "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when the table has a partial exclusion constraint", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "dd78f5c3da031fb7de4219cc56e03160053a03e93a28807fed0b1aed84bc501f", "section_path": ["Changes"], "commit_groups": [["0b6edb9fb", "2981e5a61", "77d45b790", "9695ecf36", "e76de8861", "f7e99de95"]], "identity_text": "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when the table has a partial exclusion constraint (Tom Lane)", "commit_aliases": ["0b6edb9fb", "2981e5a61", "77d45b790", "9695ecf36", "e76de8861", "f7e99de95"], "source_commits": ["77d45b790"], "source_entry_id": "9.6.14/changes/001", "db_id": "85f75aeb03f367134a4e7d7856d2df24", "patch_ids": ["0e3bf0fa29dc56c919833424b8035491"], "statement_hash": "4f5a1cb1f01b73c9908be379bcccd6339796aaaf2fa7c86619f298a20d421a2d", "relations": [{"rule": 2, "type": "equivalent", "target": "18897c934331d00b6064b3b740544c2f", "evidence": {"same_day": true, "patch_ids": ["0e3bf0fa29dc56c919833424b8035491"], "statement_hash": "4f5a1cb1f01b73c9908be379bcccd6339796aaaf2fa7c86619f298a20d421a2d"}}, {"rule": 2, "type": "equivalent", "target": "1b3fbedb7ce3b15faea5f177e5baf868", "evidence": {"same_day": true, "patch_ids": ["0e3bf0fa29dc56c919833424b8035491"], "statement_hash": "4f5a1cb1f01b73c9908be379bcccd6339796aaaf2fa7c86619f298a20d421a2d"}}, {"rule": 2, "type": "equivalent", "target": "419daf02f3a6d744d20dc80723fff2eb", "evidence": {"same_day": true, "patch_ids": ["0e3bf0fa29dc56c919833424b8035491"], "statement_hash": "4f5a1cb1f01b73c9908be379bcccd6339796aaaf2fa7c86619f298a20d421a2d"}}, {"rule": 2, "type": "equivalent", "target": "c48bc4f5d4f181dca0cb27b2d1bed2fe", "evidence": {"same_day": true, "patch_ids": ["0e3bf0fa29dc56c919833424b8035491"], "statement_hash": "4f5a1cb1f01b73c9908be379bcccd6339796aaaf2fa7c86619f298a20d421a2d"}}], "version": "9.6.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "18897c934331d00b6064b3b740544c2f", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when the table has a partial exclusion constraint", "evidence": {"same_day": true, "patch_ids": ["0e3bf0fa29dc56c919833424b8035491"], "statement_hash": "4f5a1cb1f01b73c9908be379bcccd6339796aaaf2fa7c86619f298a20d421a2d"}, "url": "/docs/compare/?release=11.4#11.4-e4223bd140057e5e", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "c48bc4f5d4f181dca0cb27b2d1bed2fe", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when the table has a partial exclusion constraint", "evidence": {"same_day": true, "patch_ids": ["0e3bf0fa29dc56c919833424b8035491"], "statement_hash": "4f5a1cb1f01b73c9908be379bcccd6339796aaaf2fa7c86619f298a20d421a2d"}, "url": "/docs/compare/?release=10.9#10.9-e4223bd140057e5e", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}, {"db_id": "419daf02f3a6d744d20dc80723fff2eb", "kind": "equivalent", "version": "9.5.18", "label": "9.5.18", "title": "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when the table has a partial exclusion constraint", "evidence": {"same_day": true, "patch_ids": ["0e3bf0fa29dc56c919833424b8035491"], "statement_hash": "4f5a1cb1f01b73c9908be379bcccd6339796aaaf2fa7c86619f298a20d421a2d"}, "url": "/docs/compare/?release=9.5.18#9.5.18-e4223bd140057e5e", "source_url": "/docs/release/9.5.18/#AEN128426"}, {"db_id": "1b3fbedb7ce3b15faea5f177e5baf868", "kind": "equivalent", "version": "9.4.23", "label": "9.4.23", "title": "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when the table has a partial exclusion constraint", "evidence": {"same_day": true, "patch_ids": ["0e3bf0fa29dc56c919833424b8035491"], "statement_hash": "4f5a1cb1f01b73c9908be379bcccd6339796aaaf2fa7c86619f298a20d421a2d"}, "url": "/docs/compare/?release=9.4.23#9.4.23-e4223bd140057e5e", "source_url": "/docs/release/9.4.23/#AEN120257"}]}, {"id": "9.6.14-6507d4fd27ee687c", "cves": [], "html": "Fix failure of COMMENT command for comments on domain constraints (Daniel Gustafsson, Michael Paquier)
", "text": "Fix failure of COMMENT command for comments on domain constraints (Daniel Gustafsson, Michael Paquier)", "title": "Fix failure of COMMENT command for comments on domain constraints", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "daea23416499ddc5020ab071839ca70d116367a0418554c88b9e053cbc431b82", "section_path": ["Changes"], "commit_groups": [["13f4b462d", "56a932533", "ceac4505d", "fa5f3a4bc", "ff1a25601"]], "identity_text": "Fix failure of COMMENT command for comments on domain constraints (Daniel Gustafsson, Michael Paquier)", "commit_aliases": ["13f4b462d", "56a932533", "ceac4505d", "fa5f3a4bc", "ff1a25601"], "source_commits": ["ff1a25601"], "source_entry_id": "9.6.14/changes/002", "db_id": "ee498eacefe406ea41e1f63a6327d0e1", "patch_ids": ["936628d057adde522ee7f95a04c65be1"], "statement_hash": "2e0bf2804f397de360996c3647e4189cf37cb23b2c22eb1a9f4025ac87792959", "relations": [{"rule": 2, "type": "equivalent", "target": "3a66c80262abd3c1e5dd6dd62c58ff1d", "evidence": {"same_day": true, "patch_ids": ["936628d057adde522ee7f95a04c65be1"], "statement_hash": "2e0bf2804f397de360996c3647e4189cf37cb23b2c22eb1a9f4025ac87792959"}}, {"rule": 2, "type": "equivalent", "target": "79a41d1452c9d46df4bec0272f1d4838", "evidence": {"same_day": true, "patch_ids": ["936628d057adde522ee7f95a04c65be1"], "statement_hash": "2e0bf2804f397de360996c3647e4189cf37cb23b2c22eb1a9f4025ac87792959"}}, {"rule": 2, "type": "equivalent", "target": "c5f7cdf209f60043884dc3da739e8029", "evidence": {"same_day": true, "patch_ids": ["936628d057adde522ee7f95a04c65be1"], "statement_hash": "2e0bf2804f397de360996c3647e4189cf37cb23b2c22eb1a9f4025ac87792959"}}], "version": "9.6.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c5f7cdf209f60043884dc3da739e8029", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "Fix failure of COMMENT command for comments on domain constraints", "evidence": {"same_day": true, "patch_ids": ["936628d057adde522ee7f95a04c65be1"], "statement_hash": "2e0bf2804f397de360996c3647e4189cf37cb23b2c22eb1a9f4025ac87792959"}, "url": "/docs/compare/?release=11.4#11.4-6507d4fd27ee687c", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "79a41d1452c9d46df4bec0272f1d4838", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "Fix failure of COMMENT command for comments on domain constraints", "evidence": {"same_day": true, "patch_ids": ["936628d057adde522ee7f95a04c65be1"], "statement_hash": "2e0bf2804f397de360996c3647e4189cf37cb23b2c22eb1a9f4025ac87792959"}, "url": "/docs/compare/?release=10.9#10.9-6507d4fd27ee687c", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}, {"db_id": "3a66c80262abd3c1e5dd6dd62c58ff1d", "kind": "equivalent", "version": "9.5.18", "label": "9.5.18", "title": "Fix failure of COMMENT command for comments on domain constraints", "evidence": {"same_day": true, "patch_ids": ["936628d057adde522ee7f95a04c65be1"], "statement_hash": "2e0bf2804f397de360996c3647e4189cf37cb23b2c22eb1a9f4025ac87792959"}, "url": "/docs/compare/?release=9.5.18#9.5.18-6507d4fd27ee687c", "source_url": "/docs/release/9.5.18/#AEN128426"}]}, {"id": "9.6.14-06b27f5ead8be3f1", "cves": [], "html": "Fix faulty generation of merge-append plans (Tom Lane)
\nThis mistake could lead to \"could not find pathkey item to sort\" errors.
", "text": "Fix faulty generation of merge-append plans (Tom Lane) This mistake could lead to \"could not find pathkey item to sort\" errors.", "title": "Fix faulty generation of merge-append plans", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "ec39dbf4e47a8a606b547aa9d61bc67e805d8c039326763aacb4376bed573c3d", "section_path": ["Changes"], "commit_groups": [["24c19e9f6", "3203714c3", "946cdf9ff", "e7eed0baa"]], "identity_text": "Fix faulty generation of merge-append plans (Tom Lane) This mistake could lead to could not find pathkey item to sort errors.", "commit_aliases": ["24c19e9f6", "3203714c3", "946cdf9ff", "e7eed0baa"], "source_commits": ["3203714c3"], "source_entry_id": "9.6.14/changes/003", "db_id": "b32f124390c285c0e20c08d549e13970", "patch_ids": ["363084a9954b00c7f8fe32ec5f126608"], "statement_hash": "627a469b6c79c8c5dd8282d7d80999ba306640e08bfe0ce2fe4515e3cd4b566f", "relations": [{"rule": 2, "type": "equivalent", "target": "62554619cae9c1ecfe9f3de71c890f8f", "evidence": {"same_day": true, "patch_ids": ["363084a9954b00c7f8fe32ec5f126608"], "statement_hash": "627a469b6c79c8c5dd8282d7d80999ba306640e08bfe0ce2fe4515e3cd4b566f"}}, {"rule": 2, "type": "equivalent", "target": "edfe87ff847c896915764836605aa6d6", "evidence": {"same_day": true, "patch_ids": ["363084a9954b00c7f8fe32ec5f126608"], "statement_hash": "627a469b6c79c8c5dd8282d7d80999ba306640e08bfe0ce2fe4515e3cd4b566f"}}], "version": "9.6.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "edfe87ff847c896915764836605aa6d6", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "Fix faulty generation of merge-append plans", "evidence": {"same_day": true, "patch_ids": ["363084a9954b00c7f8fe32ec5f126608"], "statement_hash": "627a469b6c79c8c5dd8282d7d80999ba306640e08bfe0ce2fe4515e3cd4b566f"}, "url": "/docs/compare/?release=11.4#11.4-06b27f5ead8be3f1", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "62554619cae9c1ecfe9f3de71c890f8f", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "Fix faulty generation of merge-append plans", "evidence": {"same_day": true, "patch_ids": ["363084a9954b00c7f8fe32ec5f126608"], "statement_hash": "627a469b6c79c8c5dd8282d7d80999ba306640e08bfe0ce2fe4515e3cd4b566f"}, "url": "/docs/compare/?release=10.9#10.9-06b27f5ead8be3f1", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}]}, {"id": "9.6.14-ac952532f49a472a", "cves": [], "html": "Fix incorrect printing of queries with duplicate join names (Philip Dubé)
\nThis oversight caused a dump/restore failure for views containing such queries.
", "text": "Fix incorrect printing of queries with duplicate join names (Philip Dubé) This oversight caused a dump/restore failure for views containing such queries.", "title": "Fix incorrect printing of queries with duplicate join names", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "9ee159ed3109c4b0f0bf1c1ffffedca601b89fb052b78ff94e7c67f0079c35ab", "section_path": ["Changes"], "commit_groups": [["30d3df0a7", "3d99a8139", "8ace51a6b", "ad3e61b28", "bf612fd3a", "f95d8f810"]], "identity_text": "Fix incorrect printing of queries with duplicate join names (Philip Dubé) This oversight caused a dump/restore failure for views containing such queries.", "commit_aliases": ["30d3df0a7", "3d99a8139", "8ace51a6b", "ad3e61b28", "bf612fd3a", "f95d8f810"], "source_commits": ["ad3e61b28"], "source_entry_id": "9.6.14/changes/004", "db_id": "da9f7a3369239a5bbd2afff9bc43dcf1", "patch_ids": ["58dc2880d650759c2ee405bf3a9b2fdd"], "statement_hash": "9330ff3ed22edad6c481ad437d7f285101418275e0baf7a9dd075e2620dca9a1", "relations": [{"rule": 2, "type": "equivalent", "target": "2656cbfb941f38df372fc01f0006353b", "evidence": {"same_day": true, "patch_ids": ["58dc2880d650759c2ee405bf3a9b2fdd"], "statement_hash": "9330ff3ed22edad6c481ad437d7f285101418275e0baf7a9dd075e2620dca9a1"}}, {"rule": 2, "type": "equivalent", "target": "7a23f8ee65e5b7bcee65cd28cfc4b10c", "evidence": {"same_day": true, "patch_ids": ["58dc2880d650759c2ee405bf3a9b2fdd"], "statement_hash": "9330ff3ed22edad6c481ad437d7f285101418275e0baf7a9dd075e2620dca9a1"}}, {"rule": 2, "type": "equivalent", "target": "b99a1ae1d7541f85fbc0194f8c662e0d", "evidence": {"same_day": true, "patch_ids": ["58dc2880d650759c2ee405bf3a9b2fdd"], "statement_hash": "9330ff3ed22edad6c481ad437d7f285101418275e0baf7a9dd075e2620dca9a1"}}, {"rule": 2, "type": "equivalent", "target": "ce621bfa11fdf4057e33a07171485043", "evidence": {"same_day": true, "patch_ids": ["58dc2880d650759c2ee405bf3a9b2fdd"], "statement_hash": "9330ff3ed22edad6c481ad437d7f285101418275e0baf7a9dd075e2620dca9a1"}}], "version": "9.6.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2656cbfb941f38df372fc01f0006353b", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "Fix incorrect printing of queries with duplicate join names", "evidence": {"same_day": true, "patch_ids": ["58dc2880d650759c2ee405bf3a9b2fdd"], "statement_hash": "9330ff3ed22edad6c481ad437d7f285101418275e0baf7a9dd075e2620dca9a1"}, "url": "/docs/compare/?release=11.4#11.4-ac952532f49a472a", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "ce621bfa11fdf4057e33a07171485043", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "Fix incorrect printing of queries with duplicate join names", "evidence": {"same_day": true, "patch_ids": ["58dc2880d650759c2ee405bf3a9b2fdd"], "statement_hash": "9330ff3ed22edad6c481ad437d7f285101418275e0baf7a9dd075e2620dca9a1"}, "url": "/docs/compare/?release=10.9#10.9-ac952532f49a472a", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}, {"db_id": "7a23f8ee65e5b7bcee65cd28cfc4b10c", "kind": "equivalent", "version": "9.5.18", "label": "9.5.18", "title": "Fix incorrect printing of queries with duplicate join names", "evidence": {"same_day": true, "patch_ids": ["58dc2880d650759c2ee405bf3a9b2fdd"], "statement_hash": "9330ff3ed22edad6c481ad437d7f285101418275e0baf7a9dd075e2620dca9a1"}, "url": "/docs/compare/?release=9.5.18#9.5.18-ac952532f49a472a", "source_url": "/docs/release/9.5.18/#AEN128426"}, {"db_id": "b99a1ae1d7541f85fbc0194f8c662e0d", "kind": "equivalent", "version": "9.4.23", "label": "9.4.23", "title": "Fix incorrect printing of queries with duplicate join names", "evidence": {"same_day": true, "patch_ids": ["58dc2880d650759c2ee405bf3a9b2fdd"], "statement_hash": "9330ff3ed22edad6c481ad437d7f285101418275e0baf7a9dd075e2620dca9a1"}, "url": "/docs/compare/?release=9.4.23#9.4.23-ac952532f49a472a", "source_url": "/docs/release/9.4.23/#AEN120257"}]}, {"id": "9.6.14-262ec571d71ef23c", "cves": [], "html": "Fix misoptimization of {1,1} quantifiers in regular expressions (Tom Lane)
\nSuch quantifiers were treated as no-ops and optimized away; but the documentation specifies that they impose greediness, or non-greediness in the case of the non-greedy variant {1,1}?, on the subexpression they're attached to, and this did not happen. The misbehavior occurred only if the subexpression contained capturing parentheses or a back-reference.
", "text": "Fix misoptimization of {1,1} quantifiers in regular expressions (Tom Lane) Such quantifiers were treated as no-ops and optimized away; but the documentation specifies that they impose greediness, or non-greediness in the case of the non-greedy variant {1,1}?, on the subexpression they're attached to, and this did not happen. The misbehavior occurred only if the subexpression contained capturing parentheses or a back-reference.", "title": "Fix misoptimization of {1,1} quantifiers in regular expressions", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "d81285e2a6306328b7c7897fbe58a4cf22c84c87d06d87f42e658d55b790921f", "section_path": ["Changes"], "commit_groups": [["2a3dbc151", "72ce7acaf", "8a29ed053", "940f64792", "b1ca28e57", "d6de52636"]], "identity_text": "Fix misoptimization of {1,1} quantifiers in regular expressions (Tom Lane) Such quantifiers were treated as no-ops and optimized away; but the documentation specifies that they impose greediness, or non-greediness in the case of the non-greedy variant {1,1}?, on the subexpression they're attached to, and this did not happen. The misbehavior occurred only if the subexpression contained capturing parentheses or a back-reference.", "commit_aliases": ["2a3dbc151", "72ce7acaf", "8a29ed053", "940f64792", "b1ca28e57", "d6de52636"], "source_commits": ["2a3dbc151"], "source_entry_id": "9.6.14/changes/005", "db_id": "eefeca727b65b78b84cd66b05dece669", "patch_ids": ["2b2b512f4caed9ee4828dfded7a7c4e2"], "statement_hash": "a6ff7faab782fac8567b0242386fd8b7832cf4c10ab1541c8b994d495869c94e", "relations": [{"rule": 2, "type": "equivalent", "target": "5e71394b1e33172a8be827640e5a6a78", "evidence": {"same_day": true, "patch_ids": ["2b2b512f4caed9ee4828dfded7a7c4e2"], "statement_hash": "a6ff7faab782fac8567b0242386fd8b7832cf4c10ab1541c8b994d495869c94e"}}, {"rule": 2, "type": "equivalent", "target": "73174114b265ccd1c2f268378a985efd", "evidence": {"same_day": true, "patch_ids": ["2b2b512f4caed9ee4828dfded7a7c4e2"], "statement_hash": "a6ff7faab782fac8567b0242386fd8b7832cf4c10ab1541c8b994d495869c94e"}}, {"rule": 2, "type": "equivalent", "target": "b4eb6bb752d8331ff2cfbda5d1e99af5", "evidence": {"same_day": true, "patch_ids": ["2b2b512f4caed9ee4828dfded7a7c4e2"], "statement_hash": "a6ff7faab782fac8567b0242386fd8b7832cf4c10ab1541c8b994d495869c94e"}}, {"rule": 2, "type": "equivalent", "target": "e7491dfd0c36ebf8bbd54223bb1aa144", "evidence": {"same_day": true, "patch_ids": ["2b2b512f4caed9ee4828dfded7a7c4e2"], "statement_hash": "a6ff7faab782fac8567b0242386fd8b7832cf4c10ab1541c8b994d495869c94e"}}], "version": "9.6.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "5e71394b1e33172a8be827640e5a6a78", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "Fix misoptimization of {1,1} quantifiers in regular expressions", "evidence": {"same_day": true, "patch_ids": ["2b2b512f4caed9ee4828dfded7a7c4e2"], "statement_hash": "a6ff7faab782fac8567b0242386fd8b7832cf4c10ab1541c8b994d495869c94e"}, "url": "/docs/compare/?release=11.4#11.4-262ec571d71ef23c", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "e7491dfd0c36ebf8bbd54223bb1aa144", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "Fix misoptimization of {1,1} quantifiers in regular expressions", "evidence": {"same_day": true, "patch_ids": ["2b2b512f4caed9ee4828dfded7a7c4e2"], "statement_hash": "a6ff7faab782fac8567b0242386fd8b7832cf4c10ab1541c8b994d495869c94e"}, "url": "/docs/compare/?release=10.9#10.9-262ec571d71ef23c", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}, {"db_id": "73174114b265ccd1c2f268378a985efd", "kind": "equivalent", "version": "9.5.18", "label": "9.5.18", "title": "Fix misoptimization of {1,1} quantifiers in regular expressions", "evidence": {"same_day": true, "patch_ids": ["2b2b512f4caed9ee4828dfded7a7c4e2"], "statement_hash": "a6ff7faab782fac8567b0242386fd8b7832cf4c10ab1541c8b994d495869c94e"}, "url": "/docs/compare/?release=9.5.18#9.5.18-262ec571d71ef23c", "source_url": "/docs/release/9.5.18/#AEN128426"}, {"db_id": "b4eb6bb752d8331ff2cfbda5d1e99af5", "kind": "equivalent", "version": "9.4.23", "label": "9.4.23", "title": "Fix misoptimization of {1,1} quantifiers in regular expressions", "evidence": {"same_day": true, "patch_ids": ["2b2b512f4caed9ee4828dfded7a7c4e2"], "statement_hash": "a6ff7faab782fac8567b0242386fd8b7832cf4c10ab1541c8b994d495869c94e"}, "url": "/docs/compare/?release=9.4.23#9.4.23-262ec571d71ef23c", "source_url": "/docs/release/9.4.23/#AEN120257"}]}, {"id": "9.6.14-76f825a644b399ef", "cves": [], "html": "Avoid possible failures while initializing a new process's pg_stat_activity data (Tom Lane)
\nCertain operations that could fail, such as converting strings extracted from an SSL certificate into the database encoding, were being performed inside a critical section. Failure there would result in database-wide lockup due to violating the access protocol for shared pg_stat_activity data.
", "text": "Avoid possible failures while initializing a new process's pg_stat_activity data (Tom Lane) Certain operations that could fail, such as converting strings extracted from an SSL certificate into the database encoding, were being performed inside a critical section. Failure there would result in database-wide lockup due to violating the access protocol for shared pg_stat_activity data.", "title": "Avoid possible failures while initializing a new process's pg_stat_activity data", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "29634793872d0eb4e9b98fcd6dc8c6784a0775f5265fd6d17854857226f28767", "section_path": ["Changes"], "commit_groups": [["27d3394b0", "85ccb6899", "899f943ca", "c3d113136", "eb97242c2"]], "identity_text": "Avoid possible failures while initializing a new process's pg_stat_activity data (Tom Lane) Certain operations that could fail, such as converting strings extracted from an SSL certificate into the database encoding, were being performed inside a critical section. Failure there would result in database-wide lockup due to violating the access protocol for shared pg_stat_activity data.", "commit_aliases": ["27d3394b0", "85ccb6899", "899f943ca", "c3d113136", "eb97242c2"], "source_commits": ["27d3394b0"], "source_entry_id": "9.6.14/changes/006", "db_id": "492bd8985c7481282eea942553923e5f", "patch_ids": ["d8f43e3cfee247f6edbf4cb359c63fa9"], "statement_hash": "437f5a5cebeee4a0dc7c04664750c2672893e6eaafc7f6c2d486394ff529b2e2", "relations": [{"rule": 2, "type": "equivalent", "target": "43e222b888f6d339b2194a80c5baae97", "evidence": {"same_day": true, "patch_ids": ["d8f43e3cfee247f6edbf4cb359c63fa9"], "statement_hash": "437f5a5cebeee4a0dc7c04664750c2672893e6eaafc7f6c2d486394ff529b2e2"}}, {"rule": 2, "type": "equivalent", "target": "46e0c783bccee3bc419a5a80c387d23d", "evidence": {"same_day": true, "patch_ids": ["d8f43e3cfee247f6edbf4cb359c63fa9"], "statement_hash": "437f5a5cebeee4a0dc7c04664750c2672893e6eaafc7f6c2d486394ff529b2e2"}}, {"rule": 2, "type": "equivalent", "target": "9136839290a792e7abadf4853fa80afc", "evidence": {"same_day": true, "patch_ids": ["d8f43e3cfee247f6edbf4cb359c63fa9"], "statement_hash": "437f5a5cebeee4a0dc7c04664750c2672893e6eaafc7f6c2d486394ff529b2e2"}}], "version": "9.6.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "43e222b888f6d339b2194a80c5baae97", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "Avoid possible failures while initializing a new process's pg_stat_activity data", "evidence": {"same_day": true, "patch_ids": ["d8f43e3cfee247f6edbf4cb359c63fa9"], "statement_hash": "437f5a5cebeee4a0dc7c04664750c2672893e6eaafc7f6c2d486394ff529b2e2"}, "url": "/docs/compare/?release=11.4#11.4-76f825a644b399ef", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "46e0c783bccee3bc419a5a80c387d23d", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "Avoid possible failures while initializing a new process's pg_stat_activity data", "evidence": {"same_day": true, "patch_ids": ["d8f43e3cfee247f6edbf4cb359c63fa9"], "statement_hash": "437f5a5cebeee4a0dc7c04664750c2672893e6eaafc7f6c2d486394ff529b2e2"}, "url": "/docs/compare/?release=10.9#10.9-76f825a644b399ef", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}, {"db_id": "9136839290a792e7abadf4853fa80afc", "kind": "equivalent", "version": "9.5.18", "label": "9.5.18", "title": "Avoid possible failures while initializing a new process's pg_stat_activity data", "evidence": {"same_day": true, "patch_ids": ["d8f43e3cfee247f6edbf4cb359c63fa9"], "statement_hash": "437f5a5cebeee4a0dc7c04664750c2672893e6eaafc7f6c2d486394ff529b2e2"}, "url": "/docs/compare/?release=9.5.18#9.5.18-76f825a644b399ef", "source_url": "/docs/release/9.5.18/#AEN128426"}]}, {"id": "9.6.14-c0973e3e278ca076", "cves": [], "html": "Fix race condition in check to see whether a pre-existing shared memory segment is still in use by a conflicting postmaster (Tom Lane)
", "text": "Fix race condition in check to see whether a pre-existing shared memory segment is still in use by a conflicting postmaster (Tom Lane)", "title": "Fix race condition in check to see whether a pre-existing shared memory segment is still in use by a conflicting postmaster", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "6b410dc547bb255e33e18eaf615e83fe2390eb910f81b8796832a72dcf253fb8", "section_path": ["Changes"], "commit_groups": [["3dcf45af5", "610747d86", "803f90ab7", "91a05390c", "a73c8caea", "b1cde67a4"]], "identity_text": "Fix race condition in check to see whether a pre-existing shared memory segment is still in use by a conflicting postmaster (Tom Lane)", "commit_aliases": ["3dcf45af5", "610747d86", "803f90ab7", "91a05390c", "a73c8caea", "b1cde67a4"], "source_commits": ["a73c8caea"], "source_entry_id": "9.6.14/changes/007", "db_id": "78c86fc36a8a5f6abd288250eaf289f1", "patch_ids": ["7bd7781fee3550eb7607c07befef081a"], "statement_hash": "dd879be66b00ecee021da17e7068e63e61bdac9b9606c0740bb936aaf5bd26da", "relations": [{"rule": 2, "type": "equivalent", "target": "2b65208026195e9279c5a53ceba66228", "evidence": {"same_day": true, "patch_ids": ["7bd7781fee3550eb7607c07befef081a"], "statement_hash": "dd879be66b00ecee021da17e7068e63e61bdac9b9606c0740bb936aaf5bd26da"}}, {"rule": 2, "type": "equivalent", "target": "9fdc1030c6b13b64ab065e3b76c5248f", "evidence": {"same_day": true, "patch_ids": ["7bd7781fee3550eb7607c07befef081a"], "statement_hash": "dd879be66b00ecee021da17e7068e63e61bdac9b9606c0740bb936aaf5bd26da"}}, {"rule": 2, "type": "equivalent", "target": "d7fe2a0ebf38ee8098fe1d6d28299d08", "evidence": {"same_day": true, "patch_ids": ["7bd7781fee3550eb7607c07befef081a"], "statement_hash": "dd879be66b00ecee021da17e7068e63e61bdac9b9606c0740bb936aaf5bd26da"}}, {"rule": 2, "type": "equivalent", "target": "ebcf9d6b59071557e6ee1fbdc63e94b6", "evidence": {"same_day": true, "patch_ids": ["7bd7781fee3550eb7607c07befef081a"], "statement_hash": "dd879be66b00ecee021da17e7068e63e61bdac9b9606c0740bb936aaf5bd26da"}}], "version": "9.6.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "9fdc1030c6b13b64ab065e3b76c5248f", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "Fix race condition in check to see whether a pre-existing shared memory segment is still in use by a conflicting postmaster", "evidence": {"same_day": true, "patch_ids": ["7bd7781fee3550eb7607c07befef081a"], "statement_hash": "dd879be66b00ecee021da17e7068e63e61bdac9b9606c0740bb936aaf5bd26da"}, "url": "/docs/compare/?release=11.4#11.4-c0973e3e278ca076", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "2b65208026195e9279c5a53ceba66228", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "Fix race condition in check to see whether a pre-existing shared memory segment is still in use by a conflicting postmaster", "evidence": {"same_day": true, "patch_ids": ["7bd7781fee3550eb7607c07befef081a"], "statement_hash": "dd879be66b00ecee021da17e7068e63e61bdac9b9606c0740bb936aaf5bd26da"}, "url": "/docs/compare/?release=10.9#10.9-c0973e3e278ca076", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}, {"db_id": "ebcf9d6b59071557e6ee1fbdc63e94b6", "kind": "equivalent", "version": "9.5.18", "label": "9.5.18", "title": "Fix race condition in check to see whether a pre-existing shared memory segment is still in use by a conflicting postmaster", "evidence": {"same_day": true, "patch_ids": ["7bd7781fee3550eb7607c07befef081a"], "statement_hash": "dd879be66b00ecee021da17e7068e63e61bdac9b9606c0740bb936aaf5bd26da"}, "url": "/docs/compare/?release=9.5.18#9.5.18-c0973e3e278ca076", "source_url": "/docs/release/9.5.18/#AEN128426"}, {"db_id": "d7fe2a0ebf38ee8098fe1d6d28299d08", "kind": "equivalent", "version": "9.4.23", "label": "9.4.23", "title": "Fix race condition in check to see whether a pre-existing shared memory segment is still in use by a conflicting postmaster", "evidence": {"same_day": true, "patch_ids": ["7bd7781fee3550eb7607c07befef081a"], "statement_hash": "dd879be66b00ecee021da17e7068e63e61bdac9b9606c0740bb936aaf5bd26da"}, "url": "/docs/compare/?release=9.4.23#9.4.23-c0973e3e278ca076", "source_url": "/docs/release/9.4.23/#AEN120257"}]}, {"id": "9.6.14-be382d6252dd5084", "cves": [], "html": "Avoid attempting to do database accesses for parameter checking in processes that are not connected to a specific database (Vignesh C, Andres Freund)
\nThis error could result in failures like \"cannot read pg_class without having selected a database\".
", "text": "Avoid attempting to do database accesses for parameter checking in processes that are not connected to a specific database (Vignesh C, Andres Freund) This error could result in failures like \"cannot read pg_class without having selected a database\".", "title": "Avoid attempting to do database accesses for parameter checking in processes that are not connected to a specific database", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "cc03b84e150e13131d76dd41ba5f9cffacd7c6a63ab680f2e8b0b2d2bc3bcb77", "section_path": ["Changes"], "commit_groups": [["483b2d7ae", "52ad5fc0a", "69f32206d", "b8607e15e", "c01556017", "fff2a7d7b"]], "identity_text": "Avoid attempting to do database accesses for parameter checking in processes that are not connected to a specific database (Vignesh C, Andres Freund) This error could result in failures like cannot read pg_class without having selected a database.", "commit_aliases": ["483b2d7ae", "52ad5fc0a", "69f32206d", "b8607e15e", "c01556017", "fff2a7d7b"], "source_commits": ["b8607e15e"], "source_entry_id": "9.6.14/changes/008", "db_id": "93eb49d1a9fa05b38f11502f6653af76", "patch_ids": ["eb7ca5a3deb1764915b19a4212f1d25e"], "statement_hash": "1a7670883364a8b3a9b3127f168808c3902ef044f9e9a3683497cbacab1e08c7", "relations": [{"rule": 2, "type": "equivalent", "target": "827a6d2e0daa51d02fae5f72e9ed1c60", "evidence": {"same_day": true, "patch_ids": ["eb7ca5a3deb1764915b19a4212f1d25e"], "statement_hash": "1a7670883364a8b3a9b3127f168808c3902ef044f9e9a3683497cbacab1e08c7"}}, {"rule": 2, "type": "equivalent", "target": "8a9e52a1d52618e73a157df3f8bb3bec", "evidence": {"same_day": true, "patch_ids": ["eb7ca5a3deb1764915b19a4212f1d25e"], "statement_hash": "1a7670883364a8b3a9b3127f168808c3902ef044f9e9a3683497cbacab1e08c7"}}, {"rule": 2, "type": "equivalent", "target": "90744f89a54c75c9d18bbda103670c0b", "evidence": {"same_day": true, "patch_ids": ["eb7ca5a3deb1764915b19a4212f1d25e"], "statement_hash": "1a7670883364a8b3a9b3127f168808c3902ef044f9e9a3683497cbacab1e08c7"}}, {"rule": 2, "type": "equivalent", "target": "b0a2c3f14f56fa7697ddbdcfd9782707", "evidence": {"same_day": true, "patch_ids": ["eb7ca5a3deb1764915b19a4212f1d25e"], "statement_hash": "1a7670883364a8b3a9b3127f168808c3902ef044f9e9a3683497cbacab1e08c7"}}], "version": "9.6.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b0a2c3f14f56fa7697ddbdcfd9782707", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "Avoid attempting to do database accesses for parameter checking in processes that are not connected to a specific database", "evidence": {"same_day": true, "patch_ids": ["eb7ca5a3deb1764915b19a4212f1d25e"], "statement_hash": "1a7670883364a8b3a9b3127f168808c3902ef044f9e9a3683497cbacab1e08c7"}, "url": "/docs/compare/?release=11.4#11.4-be382d6252dd5084", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "8a9e52a1d52618e73a157df3f8bb3bec", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "Avoid attempting to do database accesses for parameter checking in processes that are not connected to a specific database", "evidence": {"same_day": true, "patch_ids": ["eb7ca5a3deb1764915b19a4212f1d25e"], "statement_hash": "1a7670883364a8b3a9b3127f168808c3902ef044f9e9a3683497cbacab1e08c7"}, "url": "/docs/compare/?release=10.9#10.9-be382d6252dd5084", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}, {"db_id": "90744f89a54c75c9d18bbda103670c0b", "kind": "equivalent", "version": "9.5.18", "label": "9.5.18", "title": "Avoid attempting to do database accesses for parameter checking in processes that are not connected to a specific database", "evidence": {"same_day": true, "patch_ids": ["eb7ca5a3deb1764915b19a4212f1d25e"], "statement_hash": "1a7670883364a8b3a9b3127f168808c3902ef044f9e9a3683497cbacab1e08c7"}, "url": "/docs/compare/?release=9.5.18#9.5.18-be382d6252dd5084", "source_url": "/docs/release/9.5.18/#AEN128426"}, {"db_id": "827a6d2e0daa51d02fae5f72e9ed1c60", "kind": "equivalent", "version": "9.4.23", "label": "9.4.23", "title": "Avoid attempting to do database accesses for parameter checking in processes that are not connected to a specific database", "evidence": {"same_day": true, "patch_ids": ["eb7ca5a3deb1764915b19a4212f1d25e"], "statement_hash": "1a7670883364a8b3a9b3127f168808c3902ef044f9e9a3683497cbacab1e08c7"}, "url": "/docs/compare/?release=9.4.23#9.4.23-be382d6252dd5084", "source_url": "/docs/release/9.4.23/#AEN120257"}]}, {"id": "9.6.14-67f1f3f9da9a2674", "cves": [], "html": "Avoid possible hang in libpq if using SSL and OpenSSL's pending-data buffer contains an exact multiple of 256 bytes (David Binderman)
", "text": "Avoid possible hang in libpq if using SSL and OpenSSL's pending-data buffer contains an exact multiple of 256 bytes (David Binderman)", "title": "Avoid possible hang in libpq if using SSL and OpenSSL's pending-data buffer contains an exact multiple of 256 bytes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "10f72050c28b6fbdaea74574e2b1389281e6dbc3e54cb5d9ad410d4fc802005c", "section_path": ["Changes"], "commit_groups": [["0ec3d2ab2", "6b0e9411f", "8eaba0b93", "ddf927fb1", "e3bf3c0f8"]], "identity_text": "Avoid possible hang in libpq if using SSL and OpenSSL's pending-data buffer contains an exact multiple of 256 bytes (David Binderman)", "commit_aliases": ["0ec3d2ab2", "6b0e9411f", "8eaba0b93", "ddf927fb1", "e3bf3c0f8"], "source_commits": ["8eaba0b93"], "source_entry_id": "9.6.14/changes/009", "db_id": "15e672bae169e5cd252f630b18a1d999", "patch_ids": ["0ddf689374641b24ad9b32c07a6d3b25"], "statement_hash": "5b71b4978f6a2e1c17c50d9d6ced5eb2c62a34a8526033fd5b36f7dabc1fe80e", "relations": [{"rule": 2, "type": "equivalent", "target": "070be28dd028f1fa3df358e99ae6bb1e", "evidence": {"same_day": true, "patch_ids": ["0ddf689374641b24ad9b32c07a6d3b25"], "statement_hash": "5b71b4978f6a2e1c17c50d9d6ced5eb2c62a34a8526033fd5b36f7dabc1fe80e"}}, {"rule": 2, "type": "equivalent", "target": "79f9916a73bfa81f171c0fe62097cf42", "evidence": {"same_day": true, "patch_ids": ["0ddf689374641b24ad9b32c07a6d3b25"], "statement_hash": "5b71b4978f6a2e1c17c50d9d6ced5eb2c62a34a8526033fd5b36f7dabc1fe80e"}}, {"rule": 2, "type": "equivalent", "target": "9d356c18f9d74f27357cb54c80b03d74", "evidence": {"same_day": true, "patch_ids": ["0ddf689374641b24ad9b32c07a6d3b25"], "statement_hash": "5b71b4978f6a2e1c17c50d9d6ced5eb2c62a34a8526033fd5b36f7dabc1fe80e"}}], "version": "9.6.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "070be28dd028f1fa3df358e99ae6bb1e", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "Avoid possible hang in libpq if using SSL and OpenSSL's pending-data buffer contains an exact multiple of 256 bytes", "evidence": {"same_day": true, "patch_ids": ["0ddf689374641b24ad9b32c07a6d3b25"], "statement_hash": "5b71b4978f6a2e1c17c50d9d6ced5eb2c62a34a8526033fd5b36f7dabc1fe80e"}, "url": "/docs/compare/?release=11.4#11.4-67f1f3f9da9a2674", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "79f9916a73bfa81f171c0fe62097cf42", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "Avoid possible hang in libpq if using SSL and OpenSSL's pending-data buffer contains an exact multiple of 256 bytes", "evidence": {"same_day": true, "patch_ids": ["0ddf689374641b24ad9b32c07a6d3b25"], "statement_hash": "5b71b4978f6a2e1c17c50d9d6ced5eb2c62a34a8526033fd5b36f7dabc1fe80e"}, "url": "/docs/compare/?release=10.9#10.9-67f1f3f9da9a2674", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}, {"db_id": "9d356c18f9d74f27357cb54c80b03d74", "kind": "equivalent", "version": "9.5.18", "label": "9.5.18", "title": "Avoid possible hang in libpq if using SSL and OpenSSL's pending-data buffer contains an exact multiple of 256 bytes", "evidence": {"same_day": true, "patch_ids": ["0ddf689374641b24ad9b32c07a6d3b25"], "statement_hash": "5b71b4978f6a2e1c17c50d9d6ced5eb2c62a34a8526033fd5b36f7dabc1fe80e"}, "url": "/docs/compare/?release=9.5.18#9.5.18-67f1f3f9da9a2674", "source_url": "/docs/release/9.5.18/#AEN128426"}]}, {"id": "9.6.14-d3315b83db12d0f7", "cves": [], "html": "Improve initdb's handling of multiple equivalent names for the system time zone (Tom Lane, Andrew Gierth)
\nMake initdb examine the /etc/localtime symbolic link, if that exists, to break ties between equivalent names for the system time zone. This makes initdb more likely to select the time zone name that the user would expect when multiple identical time zones exist. It will not change the behavior if /etc/localtime is not a symlink to a zone data file, nor if the time zone is determined from the TZ environment variable.
\nSeparately, prefer UTC over other spellings of that time zone, when neither TZ nor /etc/localtime provide a hint. This fixes an annoyance introduced by tzdata 2019a's change to make the UCT and UTC zone names equivalent: initdb was then preferring UCT, which almost nobody wants.
", "text": "Improve initdb's handling of multiple equivalent names for the system time zone (Tom Lane, Andrew Gierth) Make initdb examine the /etc/localtime symbolic link, if that exists, to break ties between equivalent names for the system time zone. This makes initdb more likely to select the time zone name that the user would expect when multiple identical time zones exist. It will not change the behavior if /etc/localtime is not a symlink to a zone data file, nor if the time zone is determined from the TZ environment variable. Separately, prefer UTC over other spellings of that time zone, when neither TZ nor /etc/localtime provide a hint. This fixes an annoyance introduced by tzdata 2019a's change to make the UCT and UTC zone names equivalent: initdb was then preferring UCT, which almost nobody wants.", "title": "Improve initdb's handling of multiple equivalent names for the system time zone", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "a9324abefcb86490993f6500694a188b344669e2a048e4c4962ab76976573426", "section_path": ["Changes"], "commit_groups": [["23bd3cec6", "37011bcb3", "75b0f21e1", "77dc741a1", "8de574aa8", "995b4fe0b"], ["2913a892e", "5f5b6667e", "6335f8a99", "6c66865f3", "7f28fc8e9", "e3846a00c"]], "identity_text": "Improve initdb's handling of multiple equivalent names for the system time zone (Tom Lane, Andrew Gierth) Make initdb examine the /etc/localtime symbolic link, if that exists, to break ties between equivalent names for the system time zone. This makes initdb more likely to select the time zone name that the user would expect when multiple identical time zones exist. It will not change the behavior if /etc/localtime is not a symlink to a zone data file, nor if the time zone is determined from the TZ environment variable. Separately, prefer UTC over other spellings of that time zone, when neither TZ nor /etc/localtime provide a hint. This fixes an annoyance introduced by tzdata 2019a's change to make the UCT and UTC zone names equivalent: initdb was then preferring UCT, which almost nobody wants.", "commit_aliases": ["23bd3cec6", "2913a892e", "37011bcb3", "5f5b6667e", "6335f8a99", "6c66865f3", "75b0f21e1", "77dc741a1", "7f28fc8e9", "8de574aa8", "995b4fe0b", "e3846a00c"], "source_commits": ["5f5b6667e", "75b0f21e1"], "source_entry_id": "9.6.14/changes/010", "db_id": "db9d638dfd65d89220d5cf61cd517612", "patch_ids": ["429556efc2543a34bba58149a13d0819", "d2d7849fe4c66de277698d46ca632415"], "statement_hash": "7f4a77c968fe12e2e76328fdf2dd68ef7062f7658b8085c1b882a309bf505034", "relations": [{"rule": 2, "type": "equivalent", "target": "0728457310d87fd417634bd16129a04b", "evidence": {"same_day": true, "patch_ids": ["429556efc2543a34bba58149a13d0819", "d2d7849fe4c66de277698d46ca632415"], "statement_hash": "7f4a77c968fe12e2e76328fdf2dd68ef7062f7658b8085c1b882a309bf505034"}}, {"rule": 2, "type": "equivalent", "target": "11ce04410301a153e6e0050f897d608d", "evidence": {"same_day": true, "patch_ids": ["429556efc2543a34bba58149a13d0819", "d2d7849fe4c66de277698d46ca632415"], "statement_hash": "7f4a77c968fe12e2e76328fdf2dd68ef7062f7658b8085c1b882a309bf505034"}}, {"rule": 2, "type": "equivalent", "target": "2497b4a144d095fd21f0460b26be5306", "evidence": {"same_day": true, "patch_ids": ["429556efc2543a34bba58149a13d0819", "d2d7849fe4c66de277698d46ca632415"], "statement_hash": "7f4a77c968fe12e2e76328fdf2dd68ef7062f7658b8085c1b882a309bf505034"}}, {"rule": 2, "type": "equivalent", "target": "29f18f1ebe746d38221ceef434727be3", "evidence": {"same_day": true, "patch_ids": ["429556efc2543a34bba58149a13d0819", "d2d7849fe4c66de277698d46ca632415"], "statement_hash": "7f4a77c968fe12e2e76328fdf2dd68ef7062f7658b8085c1b882a309bf505034"}}], "version": "9.6.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "2497b4a144d095fd21f0460b26be5306", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "Improve initdb's handling of multiple equivalent names for the system time zone", "evidence": {"same_day": true, "patch_ids": ["429556efc2543a34bba58149a13d0819", "d2d7849fe4c66de277698d46ca632415"], "statement_hash": "7f4a77c968fe12e2e76328fdf2dd68ef7062f7658b8085c1b882a309bf505034"}, "url": "/docs/compare/?release=11.4#11.4-d3315b83db12d0f7", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "0728457310d87fd417634bd16129a04b", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "Improve initdb's handling of multiple equivalent names for the system time zone", "evidence": {"same_day": true, "patch_ids": ["429556efc2543a34bba58149a13d0819", "d2d7849fe4c66de277698d46ca632415"], "statement_hash": "7f4a77c968fe12e2e76328fdf2dd68ef7062f7658b8085c1b882a309bf505034"}, "url": "/docs/compare/?release=10.9#10.9-d3315b83db12d0f7", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}, {"db_id": "11ce04410301a153e6e0050f897d608d", "kind": "equivalent", "version": "9.5.18", "label": "9.5.18", "title": "Improve initdb's handling of multiple equivalent names for the system time zone", "evidence": {"same_day": true, "patch_ids": ["429556efc2543a34bba58149a13d0819", "d2d7849fe4c66de277698d46ca632415"], "statement_hash": "7f4a77c968fe12e2e76328fdf2dd68ef7062f7658b8085c1b882a309bf505034"}, "url": "/docs/compare/?release=9.5.18#9.5.18-d3315b83db12d0f7", "source_url": "/docs/release/9.5.18/#AEN128426"}, {"db_id": "29f18f1ebe746d38221ceef434727be3", "kind": "equivalent", "version": "9.4.23", "label": "9.4.23", "title": "Improve initdb's handling of multiple equivalent names for the system time zone", "evidence": {"same_day": true, "patch_ids": ["429556efc2543a34bba58149a13d0819", "d2d7849fe4c66de277698d46ca632415"], "statement_hash": "7f4a77c968fe12e2e76328fdf2dd68ef7062f7658b8085c1b882a309bf505034"}, "url": "/docs/compare/?release=9.4.23#9.4.23-d3315b83db12d0f7", "source_url": "/docs/release/9.4.23/#AEN120257"}]}, {"id": "9.6.14-f5357d34c5109307", "cves": [], "html": "Fix ordering of GRANT commands emitted by pg_dump and pg_dumpall for databases and tablespaces (Nathan Bossart, Michael Paquier)
\nIf cascading grants had been issued, restore might fail due to the GRANT commands being given in an order that didn't respect their interdependencies.
", "text": "Fix ordering of GRANT commands emitted by pg_dump and pg_dumpall for databases and tablespaces (Nathan Bossart, Michael Paquier) If cascading grants had been issued, restore might fail due to the GRANT commands being given in an order that didn't respect their interdependencies.", "title": "Fix ordering of GRANT commands emitted by pg_dump and pg_dumpall for databases and tablespaces", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "b5e95950aabdf371f44fa268fc770c95eca1941a77c443612d6b0fdbf56f0ea3", "section_path": ["Changes"], "commit_groups": [["0c2a5a862", "8357a413f", "a21fb12e7", "b8c6014a6"], ["156c0c2df", "2ccebcd23", "a7b2fca15", "c82e8ba00"]], "identity_text": "Fix ordering of GRANT commands emitted by pg_dump and pg_dumpall for databases and tablespaces (Nathan Bossart, Michael Paquier) If cascading grants had been issued, restore might fail due to the GRANT commands being given in an order that didn't respect their interdependencies.", "commit_aliases": ["0c2a5a862", "156c0c2df", "2ccebcd23", "8357a413f", "a21fb12e7", "a7b2fca15", "b8c6014a6", "c82e8ba00"], "source_commits": ["a21fb12e7", "c82e8ba00"], "source_entry_id": "9.6.14/changes/011", "db_id": "8f8b9462a8348a08c814bea5017db5f8", "patch_ids": ["52de165cd6760b00b1e03e4d6894abb9", "8524b189c0b998af61d8dbb30864f060"], "statement_hash": "9ce94238abfe017444f88bd175269774d6a65893b498ebc98d692df324935c75", "relations": [{"rule": 2, "type": "equivalent", "target": "53c55f91fe557ae3bbfb96af0611ca2d", "evidence": {"same_day": true, "patch_ids": ["52de165cd6760b00b1e03e4d6894abb9", "8524b189c0b998af61d8dbb30864f060"], "statement_hash": "9ce94238abfe017444f88bd175269774d6a65893b498ebc98d692df324935c75"}}, {"rule": 2, "type": "equivalent", "target": "cc9ed4301021ec43bca66ca9568b003a", "evidence": {"same_day": true, "patch_ids": ["52de165cd6760b00b1e03e4d6894abb9", "8524b189c0b998af61d8dbb30864f060"], "statement_hash": "9ce94238abfe017444f88bd175269774d6a65893b498ebc98d692df324935c75"}}], "version": "9.6.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "cc9ed4301021ec43bca66ca9568b003a", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "Fix ordering of GRANT commands emitted by pg_dump and pg_dumpall for databases and tablespaces", "evidence": {"same_day": true, "patch_ids": ["52de165cd6760b00b1e03e4d6894abb9", "8524b189c0b998af61d8dbb30864f060"], "statement_hash": "9ce94238abfe017444f88bd175269774d6a65893b498ebc98d692df324935c75"}, "url": "/docs/compare/?release=11.4#11.4-f5357d34c5109307", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "53c55f91fe557ae3bbfb96af0611ca2d", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "Fix ordering of GRANT commands emitted by pg_dump and pg_dumpall for databases and tablespaces", "evidence": {"same_day": true, "patch_ids": ["52de165cd6760b00b1e03e4d6894abb9", "8524b189c0b998af61d8dbb30864f060"], "statement_hash": "9ce94238abfe017444f88bd175269774d6a65893b498ebc98d692df324935c75"}, "url": "/docs/compare/?release=10.9#10.9-f5357d34c5109307", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}]}, {"id": "9.6.14-01dbe2b7a223b830", "cves": [], "html": "Fix misleading error reports from reindexdb (Julien Rouhaud)
", "text": "Fix misleading error reports from reindexdb (Julien Rouhaud)", "title": "Fix misleading error reports from reindexdb", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "f7a2126690405613480bbda3156c9bcb1fb10333b63d66ed2db8febb2aa34e5f", "section_path": ["Changes"], "commit_groups": [["0c132d458", "82ed20e15", "c6354e943", "e16ab408f", "e17fba8d8", "e51bad8fb"]], "identity_text": "Fix misleading error reports from reindexdb (Julien Rouhaud)", "commit_aliases": ["0c132d458", "82ed20e15", "c6354e943", "e16ab408f", "e17fba8d8", "e51bad8fb"], "source_commits": ["0c132d458"], "source_entry_id": "9.6.14/changes/012", "db_id": "25db0b7e82ec00fbd8bb76aa1b4926da", "patch_ids": ["87f13351d4c357a600f278b50c6f2940"], "statement_hash": "24f236e255b0d0fda553a4a8105a9abe2535c98cf506d65eb7b5e9de3e359046", "relations": [{"rule": 2, "type": "equivalent", "target": "41d93a93d28ddfdfdfe6a075f18132b9", "evidence": {"same_day": true, "patch_ids": ["87f13351d4c357a600f278b50c6f2940"], "statement_hash": "24f236e255b0d0fda553a4a8105a9abe2535c98cf506d65eb7b5e9de3e359046"}}, {"rule": 2, "type": "equivalent", "target": "621ba5703121e17eb7c7b165ac3b8066", "evidence": {"same_day": true, "patch_ids": ["87f13351d4c357a600f278b50c6f2940"], "statement_hash": "24f236e255b0d0fda553a4a8105a9abe2535c98cf506d65eb7b5e9de3e359046"}}, {"rule": 2, "type": "equivalent", "target": "856a02cbcad008d09c38f39351e36954", "evidence": {"same_day": true, "patch_ids": ["87f13351d4c357a600f278b50c6f2940"], "statement_hash": "24f236e255b0d0fda553a4a8105a9abe2535c98cf506d65eb7b5e9de3e359046"}}, {"rule": 2, "type": "equivalent", "target": "cc0588e0008f5e9301db2d09b62acc48", "evidence": {"same_day": true, "patch_ids": ["87f13351d4c357a600f278b50c6f2940"], "statement_hash": "24f236e255b0d0fda553a4a8105a9abe2535c98cf506d65eb7b5e9de3e359046"}}], "version": "9.6.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "856a02cbcad008d09c38f39351e36954", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "Fix misleading error reports from reindexdb", "evidence": {"same_day": true, "patch_ids": ["87f13351d4c357a600f278b50c6f2940"], "statement_hash": "24f236e255b0d0fda553a4a8105a9abe2535c98cf506d65eb7b5e9de3e359046"}, "url": "/docs/compare/?release=11.4#11.4-01dbe2b7a223b830", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "621ba5703121e17eb7c7b165ac3b8066", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "Fix misleading error reports from reindexdb", "evidence": {"same_day": true, "patch_ids": ["87f13351d4c357a600f278b50c6f2940"], "statement_hash": "24f236e255b0d0fda553a4a8105a9abe2535c98cf506d65eb7b5e9de3e359046"}, "url": "/docs/compare/?release=10.9#10.9-01dbe2b7a223b830", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}, {"db_id": "41d93a93d28ddfdfdfe6a075f18132b9", "kind": "equivalent", "version": "9.5.18", "label": "9.5.18", "title": "Fix misleading error reports from reindexdb", "evidence": {"same_day": true, "patch_ids": ["87f13351d4c357a600f278b50c6f2940"], "statement_hash": "24f236e255b0d0fda553a4a8105a9abe2535c98cf506d65eb7b5e9de3e359046"}, "url": "/docs/compare/?release=9.5.18#9.5.18-01dbe2b7a223b830", "source_url": "/docs/release/9.5.18/#AEN128426"}, {"db_id": "cc0588e0008f5e9301db2d09b62acc48", "kind": "equivalent", "version": "9.4.23", "label": "9.4.23", "title": "Fix misleading error reports from reindexdb", "evidence": {"same_day": true, "patch_ids": ["87f13351d4c357a600f278b50c6f2940"], "statement_hash": "24f236e255b0d0fda553a4a8105a9abe2535c98cf506d65eb7b5e9de3e359046"}, "url": "/docs/compare/?release=9.4.23#9.4.23-01dbe2b7a223b830", "source_url": "/docs/release/9.4.23/#AEN120257"}]}, {"id": "9.6.14-032df0bcca7366dc", "cves": [], "html": "Ensure that vacuumdb returns correct status if an error occurs while using parallel jobs (Julien Rouhaud)
", "text": "Ensure that vacuumdb returns correct status if an error occurs while using parallel jobs (Julien Rouhaud)", "title": "Ensure that vacuumdb returns correct status if an error occurs while using parallel jobs", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "75a82fb689c7eea82a60352d207b1d0a7ec5ecf25a89b6e48d0b754dd740b050", "section_path": ["Changes"], "commit_groups": [["25f12acd5", "3ae3c18b3", "a475b1e77", "a9a886c6f", "db8802a99"]], "identity_text": "Ensure that vacuumdb returns correct status if an error occurs while using parallel jobs (Julien Rouhaud)", "commit_aliases": ["25f12acd5", "3ae3c18b3", "a475b1e77", "a9a886c6f", "db8802a99"], "source_commits": ["a9a886c6f"], "source_entry_id": "9.6.14/changes/013", "db_id": "56918142430354517d667af46038dd9c", "patch_ids": ["2e158c97054dfc69c66b85ef23a7b7cd"], "statement_hash": "bef6ed8f3612a529a970373d44b838d745f58c24fe34e3c7d45d72ca824215a9", "relations": [{"rule": 2, "type": "equivalent", "target": "acddf8f70b395fb3a515868a1ce8dc8b", "evidence": {"same_day": true, "patch_ids": ["2e158c97054dfc69c66b85ef23a7b7cd"], "statement_hash": "bef6ed8f3612a529a970373d44b838d745f58c24fe34e3c7d45d72ca824215a9"}}, {"rule": 2, "type": "equivalent", "target": "ad8e95706176923d6519a32fc781a1c5", "evidence": {"same_day": true, "patch_ids": ["2e158c97054dfc69c66b85ef23a7b7cd"], "statement_hash": "bef6ed8f3612a529a970373d44b838d745f58c24fe34e3c7d45d72ca824215a9"}}, {"rule": 2, "type": "equivalent", "target": "c86f22948fad07ea1827c34000c64949", "evidence": {"same_day": true, "patch_ids": ["2e158c97054dfc69c66b85ef23a7b7cd"], "statement_hash": "bef6ed8f3612a529a970373d44b838d745f58c24fe34e3c7d45d72ca824215a9"}}], "version": "9.6.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "acddf8f70b395fb3a515868a1ce8dc8b", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "Ensure that vacuumdb returns correct status if an error occurs while using parallel jobs", "evidence": {"same_day": true, "patch_ids": ["2e158c97054dfc69c66b85ef23a7b7cd"], "statement_hash": "bef6ed8f3612a529a970373d44b838d745f58c24fe34e3c7d45d72ca824215a9"}, "url": "/docs/compare/?release=11.4#11.4-032df0bcca7366dc", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "ad8e95706176923d6519a32fc781a1c5", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "Ensure that vacuumdb returns correct status if an error occurs while using parallel jobs", "evidence": {"same_day": true, "patch_ids": ["2e158c97054dfc69c66b85ef23a7b7cd"], "statement_hash": "bef6ed8f3612a529a970373d44b838d745f58c24fe34e3c7d45d72ca824215a9"}, "url": "/docs/compare/?release=10.9#10.9-032df0bcca7366dc", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}, {"db_id": "c86f22948fad07ea1827c34000c64949", "kind": "equivalent", "version": "9.5.18", "label": "9.5.18", "title": "Ensure that vacuumdb returns correct status if an error occurs while using parallel jobs", "evidence": {"same_day": true, "patch_ids": ["2e158c97054dfc69c66b85ef23a7b7cd"], "statement_hash": "bef6ed8f3612a529a970373d44b838d745f58c24fe34e3c7d45d72ca824215a9"}, "url": "/docs/compare/?release=9.5.18#9.5.18-032df0bcca7366dc", "source_url": "/docs/release/9.5.18/#AEN128426"}]}, {"id": "9.6.14-67bbf633adedc670", "cves": [], "html": "Fix contrib/auto_explain to not cause problems in parallel queries (Tom Lane)
\nPreviously, a parallel worker might try to log its query even if the parent query were not being logged by auto_explain. This would work sometimes, but it's confusing, and in some cases it resulted in failures like \"could not find key N in shm TOC\".
\nAlso, fix an off-by-one error that resulted in not necessarily logging every query even when the sampling rate is set to 1.0.
", "text": "Fix contrib/auto_explain to not cause problems in parallel queries (Tom Lane) Previously, a parallel worker might try to log its query even if the parent query were not being logged by auto_explain. This would work sometimes, but it's confusing, and in some cases it resulted in failures like \"could not find key N in shm TOC\". Also, fix an off-by-one error that resulted in not necessarily logging every query even when the sampling rate is set to 1.0.", "title": "Fix contrib/auto_explain to not cause problems in parallel queries", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "b466068400766dae46d613e3adecb05eeb87c8070856ffbd231e184a752f73eb", "section_path": ["Changes"], "commit_groups": [["2cd4e8357", "57e85fa2c", "ba38967d7", "efa121ae6"]], "identity_text": "Fix contrib/auto_explain to not cause problems in parallel queries (Tom Lane) Previously, a parallel worker might try to log its query even if the parent query were not being logged by auto_explain. This would work sometimes, but it's confusing, and in some cases it resulted in failures like could not find key N in shm TOC. Also, fix an off-by-one error that resulted in not necessarily logging every query even when the sampling rate is set to 1.0.", "commit_aliases": ["2cd4e8357", "57e85fa2c", "ba38967d7", "efa121ae6"], "source_commits": ["efa121ae6"], "source_entry_id": "9.6.14/changes/014", "db_id": "5c04af6178328e0a980d37f41159635a", "patch_ids": ["8b03a649f3fad64df38bb03da43ae49c"], "statement_hash": "bb8abec9d08fd4ad7446e3dad199fa7d0da5985dc319314302ac1ab70c2cde2e", "relations": [{"rule": 2, "type": "equivalent", "target": "867d52053103c00b03acd3f3f00152e5", "evidence": {"same_day": true, "patch_ids": ["8b03a649f3fad64df38bb03da43ae49c"], "statement_hash": "bb8abec9d08fd4ad7446e3dad199fa7d0da5985dc319314302ac1ab70c2cde2e"}}, {"rule": 2, "type": "equivalent", "target": "cbd8938dfb244e15d908617bea264247", "evidence": {"same_day": true, "patch_ids": ["8b03a649f3fad64df38bb03da43ae49c"], "statement_hash": "bb8abec9d08fd4ad7446e3dad199fa7d0da5985dc319314302ac1ab70c2cde2e"}}], "version": "9.6.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "867d52053103c00b03acd3f3f00152e5", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "Fix contrib/auto_explain to not cause problems in parallel queries", "evidence": {"same_day": true, "patch_ids": ["8b03a649f3fad64df38bb03da43ae49c"], "statement_hash": "bb8abec9d08fd4ad7446e3dad199fa7d0da5985dc319314302ac1ab70c2cde2e"}, "url": "/docs/compare/?release=11.4#11.4-67bbf633adedc670", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "cbd8938dfb244e15d908617bea264247", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "Fix contrib/auto_explain to not cause problems in parallel queries", "evidence": {"same_day": true, "patch_ids": ["8b03a649f3fad64df38bb03da43ae49c"], "statement_hash": "bb8abec9d08fd4ad7446e3dad199fa7d0da5985dc319314302ac1ab70c2cde2e"}, "url": "/docs/compare/?release=10.9#10.9-67bbf633adedc670", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}]}, {"id": "9.6.14-423d9d4b62afc98d", "cves": [], "html": "In contrib/postgres_fdw, account for possible data modifications by local BEFORE ROW UPDATE triggers (Shohei Mochizuki)
\nIf a trigger modified a column that was otherwise not changed by the UPDATE, the new value was not transmitted to the remote server.
", "text": "In contrib/postgres_fdw, account for possible data modifications by local BEFORE ROW UPDATE triggers (Shohei Mochizuki) If a trigger modified a column that was otherwise not changed by the UPDATE, the new value was not transmitted to the remote server.", "title": "In contrib/postgres_fdw, account for possible data modifications by local BEFORE ROW UPDATE triggers", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "26bce560459eb5964928ba6c97d993a1a6babdc58212880d2d09a68ae14c54b1", "section_path": ["Changes"], "commit_groups": [["0f2b23426", "1a3d9f62c", "1ade21e7f", "214460182", "8b6da83d1", "eddb79705"]], "identity_text": "In contrib/postgres_fdw, account for possible data modifications by local BEFORE ROW UPDATE triggers (Shohei Mochizuki) If a trigger modified a column that was otherwise not changed by the UPDATE, the new value was not transmitted to the remote server.", "commit_aliases": ["0f2b23426", "1a3d9f62c", "1ade21e7f", "214460182", "8b6da83d1", "eddb79705"], "source_commits": ["1ade21e7f"], "source_entry_id": "9.6.14/changes/015", "db_id": "6b4d8ed35a122c32db01a362f3e05c4c", "patch_ids": ["5bf5b1e275b587efc4ae8ca354fd1734"], "statement_hash": "f605cc079a26930ac21fcb7d17f5206538bc580ad882e830fc1d6fb72b9967c4", "relations": [{"rule": 2, "type": "equivalent", "target": "06f01d6eadd7afbc7b3d4b948b8e4f90", "evidence": {"same_day": true, "patch_ids": ["5bf5b1e275b587efc4ae8ca354fd1734"], "statement_hash": "f605cc079a26930ac21fcb7d17f5206538bc580ad882e830fc1d6fb72b9967c4"}}, {"rule": 2, "type": "equivalent", "target": "427e4bd42c0da009e711e847289b5aba", "evidence": {"same_day": true, "patch_ids": ["5bf5b1e275b587efc4ae8ca354fd1734"], "statement_hash": "f605cc079a26930ac21fcb7d17f5206538bc580ad882e830fc1d6fb72b9967c4"}}, {"rule": 2, "type": "equivalent", "target": "7ac321b9e594e3cbdf21aef118d727f0", "evidence": {"same_day": true, "patch_ids": ["5bf5b1e275b587efc4ae8ca354fd1734"], "statement_hash": "f605cc079a26930ac21fcb7d17f5206538bc580ad882e830fc1d6fb72b9967c4"}}, {"rule": 2, "type": "equivalent", "target": "a981fad680adcd9a05f4935e525de0be", "evidence": {"same_day": true, "patch_ids": ["5bf5b1e275b587efc4ae8ca354fd1734"], "statement_hash": "f605cc079a26930ac21fcb7d17f5206538bc580ad882e830fc1d6fb72b9967c4"}}], "version": "9.6.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "427e4bd42c0da009e711e847289b5aba", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "In contrib/postgres_fdw, account for possible data modifications by local BEFORE ROW UPDATE triggers", "evidence": {"same_day": true, "patch_ids": ["5bf5b1e275b587efc4ae8ca354fd1734"], "statement_hash": "f605cc079a26930ac21fcb7d17f5206538bc580ad882e830fc1d6fb72b9967c4"}, "url": "/docs/compare/?release=11.4#11.4-423d9d4b62afc98d", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "a981fad680adcd9a05f4935e525de0be", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "In contrib/postgres_fdw, account for possible data modifications by local BEFORE ROW UPDATE triggers", "evidence": {"same_day": true, "patch_ids": ["5bf5b1e275b587efc4ae8ca354fd1734"], "statement_hash": "f605cc079a26930ac21fcb7d17f5206538bc580ad882e830fc1d6fb72b9967c4"}, "url": "/docs/compare/?release=10.9#10.9-423d9d4b62afc98d", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}, {"db_id": "7ac321b9e594e3cbdf21aef118d727f0", "kind": "equivalent", "version": "9.5.18", "label": "9.5.18", "title": "In contrib/postgres_fdw, account for possible data modifications by local BEFORE ROW UPDATE triggers", "evidence": {"same_day": true, "patch_ids": ["5bf5b1e275b587efc4ae8ca354fd1734"], "statement_hash": "f605cc079a26930ac21fcb7d17f5206538bc580ad882e830fc1d6fb72b9967c4"}, "url": "/docs/compare/?release=9.5.18#9.5.18-423d9d4b62afc98d", "source_url": "/docs/release/9.5.18/#AEN128426"}, {"db_id": "06f01d6eadd7afbc7b3d4b948b8e4f90", "kind": "equivalent", "version": "9.4.23", "label": "9.4.23", "title": "In contrib/postgres_fdw, account for possible data modifications by local BEFORE ROW UPDATE triggers", "evidence": {"same_day": true, "patch_ids": ["5bf5b1e275b587efc4ae8ca354fd1734"], "statement_hash": "f605cc079a26930ac21fcb7d17f5206538bc580ad882e830fc1d6fb72b9967c4"}, "url": "/docs/compare/?release=9.4.23#9.4.23-423d9d4b62afc98d", "source_url": "/docs/release/9.4.23/#AEN120257"}]}, {"id": "9.6.14-5dc1e404f906420a", "cves": [], "html": "On Windows, avoid failure when the database encoding is set to SQL_ASCII and we attempt to log a non-ASCII string (Noah Misch)
\nThe code had been assuming that such strings must be in UTF-8, and would throw an error if they didn't appear to be validly encoded. Now, just transmit the untranslated bytes to the log.
", "text": "On Windows, avoid failure when the database encoding is set to SQL_ASCII and we attempt to log a non-ASCII string (Noah Misch) The code had been assuming that such strings must be in UTF-8, and would throw an error if they didn't appear to be validly encoded. Now, just transmit the untranslated bytes to the log.", "title": "On Windows, avoid failure when the database encoding is set to SQL_ASCII and we attempt to log a non-ASCII string", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "89c3c2b48cb06ce2ed7c7e1eb91d9020bd962923e14ed1ac01ef28f2a7344751", "section_path": ["Changes"], "commit_groups": [["08e3fd96f", "409f5303c", "4ec14e5aa", "9dc65bcf9", "d02768ddd", "ff7555c4f"]], "identity_text": "On Windows, avoid failure when the database encoding is set to SQL_ASCII and we attempt to log a non-ASCII string (Noah Misch) The code had been assuming that such strings must be in UTF-8, and would throw an error if they didn't appear to be validly encoded. Now, just transmit the untranslated bytes to the log.", "commit_aliases": ["08e3fd96f", "409f5303c", "4ec14e5aa", "9dc65bcf9", "d02768ddd", "ff7555c4f"], "source_commits": ["ff7555c4f"], "source_entry_id": "9.6.14/changes/016", "db_id": "daa633bc14def51f60e1f5f581ef3fbb", "patch_ids": ["47dc91829e094042769dab88ef8516aa"], "statement_hash": "5e03b7a9df25f330cb37ff980e6f9309d401831a8c498a88c635ff90a1dd1b1e", "relations": [{"rule": 2, "type": "equivalent", "target": "2c1931e642611d8c1ba9050fb8776a58", "evidence": {"same_day": true, "patch_ids": ["47dc91829e094042769dab88ef8516aa"], "statement_hash": "5e03b7a9df25f330cb37ff980e6f9309d401831a8c498a88c635ff90a1dd1b1e"}}, {"rule": 2, "type": "equivalent", "target": "35b6a0a367f4e2d5863af5838c3e6b28", "evidence": {"same_day": true, "patch_ids": ["47dc91829e094042769dab88ef8516aa"], "statement_hash": "5e03b7a9df25f330cb37ff980e6f9309d401831a8c498a88c635ff90a1dd1b1e"}}, {"rule": 2, "type": "equivalent", "target": "bd1665a7d5a8a6ec8893ea4f6c219cff", "evidence": {"same_day": true, "patch_ids": ["47dc91829e094042769dab88ef8516aa"], "statement_hash": "5e03b7a9df25f330cb37ff980e6f9309d401831a8c498a88c635ff90a1dd1b1e"}}, {"rule": 2, "type": "equivalent", "target": "c9bbd8496ebca7419d418dfb0f244799", "evidence": {"same_day": true, "patch_ids": ["47dc91829e094042769dab88ef8516aa"], "statement_hash": "5e03b7a9df25f330cb37ff980e6f9309d401831a8c498a88c635ff90a1dd1b1e"}}], "version": "9.6.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "35b6a0a367f4e2d5863af5838c3e6b28", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "On Windows, avoid failure when the database encoding is set to SQL_ASCII and we attempt to log a non-ASCII string", "evidence": {"same_day": true, "patch_ids": ["47dc91829e094042769dab88ef8516aa"], "statement_hash": "5e03b7a9df25f330cb37ff980e6f9309d401831a8c498a88c635ff90a1dd1b1e"}, "url": "/docs/compare/?release=11.4#11.4-5dc1e404f906420a", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "c9bbd8496ebca7419d418dfb0f244799", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "On Windows, avoid failure when the database encoding is set to SQL_ASCII and we attempt to log a non-ASCII string", "evidence": {"same_day": true, "patch_ids": ["47dc91829e094042769dab88ef8516aa"], "statement_hash": "5e03b7a9df25f330cb37ff980e6f9309d401831a8c498a88c635ff90a1dd1b1e"}, "url": "/docs/compare/?release=10.9#10.9-5dc1e404f906420a", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}, {"db_id": "bd1665a7d5a8a6ec8893ea4f6c219cff", "kind": "equivalent", "version": "9.5.18", "label": "9.5.18", "title": "On Windows, avoid failure when the database encoding is set to SQL_ASCII and we attempt to log a non-ASCII string", "evidence": {"same_day": true, "patch_ids": ["47dc91829e094042769dab88ef8516aa"], "statement_hash": "5e03b7a9df25f330cb37ff980e6f9309d401831a8c498a88c635ff90a1dd1b1e"}, "url": "/docs/compare/?release=9.5.18#9.5.18-5dc1e404f906420a", "source_url": "/docs/release/9.5.18/#AEN128426"}, {"db_id": "2c1931e642611d8c1ba9050fb8776a58", "kind": "equivalent", "version": "9.4.23", "label": "9.4.23", "title": "On Windows, avoid failure when the database encoding is set to SQL_ASCII and we attempt to log a non-ASCII string", "evidence": {"same_day": true, "patch_ids": ["47dc91829e094042769dab88ef8516aa"], "statement_hash": "5e03b7a9df25f330cb37ff980e6f9309d401831a8c498a88c635ff90a1dd1b1e"}, "url": "/docs/compare/?release=9.4.23#9.4.23-5dc1e404f906420a", "source_url": "/docs/release/9.4.23/#AEN120257"}]}, {"id": "9.6.14-2ef11ee3f4b89c49", "cves": [], "html": "Make PL/pgSQL's header files C++-safe (George Tarasov)
", "text": "Make PL/pgSQL's header files C++-safe (George Tarasov)", "title": "Make PL/pgSQL's header files C++-safe", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.6.14/#AEN133626", "source_hash": "54d81a4673a66a46160a794f8992c0a7ba9cfb71638ef15ec132b6fa13548e8c", "section_path": ["Changes"], "commit_groups": [["312017fcc", "3f61b3205", "683c17b30", "c332c94ad", "da53e4f93", "db5d99916"]], "identity_text": "Make PL/pgSQL's header files C++-safe (George Tarasov)", "commit_aliases": ["312017fcc", "3f61b3205", "683c17b30", "c332c94ad", "da53e4f93", "db5d99916"], "source_commits": ["c332c94ad"], "source_entry_id": "9.6.14/changes/017", "db_id": "77f5c99ec74a8d5ccf2159403506912d", "patch_ids": ["12741ccb4caee1d40f28177046eb9c13"], "statement_hash": "e92e5fd23e02ef2a319b40db31ffb270886e8d7f08479f5f1a87287287dd84c8", "relations": [{"rule": 2, "type": "equivalent", "target": "12a4e0e2fafe333711fec06e2d23cf8d", "evidence": {"same_day": true, "patch_ids": ["12741ccb4caee1d40f28177046eb9c13"], "statement_hash": "e92e5fd23e02ef2a319b40db31ffb270886e8d7f08479f5f1a87287287dd84c8"}}, {"rule": 2, "type": "equivalent", "target": "813c6e2c25662776741b44521132b642", "evidence": {"same_day": true, "patch_ids": ["12741ccb4caee1d40f28177046eb9c13"], "statement_hash": "e92e5fd23e02ef2a319b40db31ffb270886e8d7f08479f5f1a87287287dd84c8"}}, {"rule": 2, "type": "equivalent", "target": "90b47ae08bd532fca5546077036a11f5", "evidence": {"same_day": true, "patch_ids": ["12741ccb4caee1d40f28177046eb9c13"], "statement_hash": "e92e5fd23e02ef2a319b40db31ffb270886e8d7f08479f5f1a87287287dd84c8"}}, {"rule": 2, "type": "equivalent", "target": "b6e72893688fc4c2250cdd8b5b31822e", "evidence": {"same_day": true, "patch_ids": ["12741ccb4caee1d40f28177046eb9c13"], "statement_hash": "e92e5fd23e02ef2a319b40db31ffb270886e8d7f08479f5f1a87287287dd84c8"}}], "version": "9.6.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "813c6e2c25662776741b44521132b642", "kind": "equivalent", "version": "11.4", "label": "11.4", "title": "Make PL/pgSQL's header files C++-safe", "evidence": {"same_day": true, "patch_ids": ["12741ccb4caee1d40f28177046eb9c13"], "statement_hash": "e92e5fd23e02ef2a319b40db31ffb270886e8d7f08479f5f1a87287287dd84c8"}, "url": "/docs/compare/?release=11.4#11.4-2ef11ee3f4b89c49", "source_url": "/docs/release/11.4/#id-1.11.6.23.5"}, {"db_id": "12a4e0e2fafe333711fec06e2d23cf8d", "kind": "equivalent", "version": "10.9", "label": "10.9", "title": "Make PL/pgSQL's header files C++-safe", "evidence": {"same_day": true, "patch_ids": ["12741ccb4caee1d40f28177046eb9c13"], "statement_hash": "e92e5fd23e02ef2a319b40db31ffb270886e8d7f08479f5f1a87287287dd84c8"}, "url": "/docs/compare/?release=10.9#10.9-2ef11ee3f4b89c49", "source_url": "/docs/release/10.9/#id-1.11.6.19.5"}, {"db_id": "b6e72893688fc4c2250cdd8b5b31822e", "kind": "equivalent", "version": "9.5.18", "label": "9.5.18", "title": "Make PL/pgSQL's header files C++-safe", "evidence": {"same_day": true, "patch_ids": ["12741ccb4caee1d40f28177046eb9c13"], "statement_hash": "e92e5fd23e02ef2a319b40db31ffb270886e8d7f08479f5f1a87287287dd84c8"}, "url": "/docs/compare/?release=9.5.18#9.5.18-2ef11ee3f4b89c49", "source_url": "/docs/release/9.5.18/#AEN128426"}, {"db_id": "90b47ae08bd532fca5546077036a11f5", "kind": "equivalent", "version": "9.4.23", "label": "9.4.23", "title": "Make PL/pgSQL's header files C++-safe", "evidence": {"same_day": true, "patch_ids": ["12741ccb4caee1d40f28177046eb9c13"], "statement_hash": "e92e5fd23e02ef2a319b40db31ffb270886e8d7f08479f5f1a87287287dd84c8"}, "url": "/docs/compare/?release=9.4.23#9.4.23-2ef11ee3f4b89c49", "source_url": "/docs/release/9.4.23/#AEN120257"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 17}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 11}, {"key": "security", "label": "Security", "count": 0}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 6}], "total": 17, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 17, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}