A dump/restore is not required for those running 9.4.X.
\nHowever, if your installation has been affected by the bug described in the first changelog entry below, then after updating you may need to take action to repair corrupted free space maps.
\nAlso, if you are upgrading from a version earlier than 9.4.6, see Section E.21.
", "compatibility_count": 0, "label": "9.4.10", "status_label": "Historical", "eol": "2020-02-13", "age_days": 3624, "support_days": -2420}, "groups": [{"date": "2016-10-27", "build": "9.4.10", "major": "9.4", "minor": 10, "manual": "9.4", "status": "stable", "doc_git": "", "version": "9.4.10", "eol_date": "2020-02-13", "date_text": "2016-10-27", "supported": false, "manual_url": "/docs/9.4/release-9-4-10.html", "source_url": "/docs/release/9.4.10/", "entry_count": 34, "placeholder": false, "content_hash": "ee06e3140176bd33352aa5febf9ff3840586cfe42d78b982ebf2c5eac772536b", "manual_build": "9.4.26", "source_as_of": "", "changes_count": 34, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 9.4.X.
\nHowever, if your installation has been affected by the bug described in the first changelog entry below, then after updating you may need to take action to repair corrupted free space maps.
\nAlso, if you are upgrading from a version earlier than 9.4.6, see Section E.21.
", "compatibility_count": 0, "label": "9.4.10", "status_label": "Historical", "eol": "2020-02-13", "age_days": 3624, "support_days": -2420, "entries": [{"id": "9.4.10-3182bd69069db480", "cves": [], "html": "Fix WAL-logging of truncation of relation free space maps and visibility maps (Pavan Deolasee, Heikki Linnakangas)
\nIt was possible for these files to not be correctly restored during crash recovery, or to be written incorrectly on a standby server. Bogus entries in a free space map could lead to attempts to access pages that have been truncated away from the relation itself, typically producing errors like \"could not read block XXX: read only 0 of 8192 bytes\". Checksum failures in the visibility map are also possible, if checksumming is enabled.
\nProcedures for determining whether there is a problem and repairing it if so are discussed at https://wiki.postgresql.org/wiki/Free_Space_Map_Problems.
", "text": "Fix WAL-logging of truncation of relation free space maps and visibility maps (Pavan Deolasee, Heikki Linnakangas) It was possible for these files to not be correctly restored during crash recovery, or to be written incorrectly on a standby server. Bogus entries in a free space map could lead to attempts to access pages that have been truncated away from the relation itself, typically producing errors like \"could not read block XXX: read only 0 of 8192 bytes\". Checksum failures in the visibility map are also possible, if checksumming is enabled. Procedures for determining whether there is a problem and repairing it if so are discussed at https://wiki.postgresql.org/wiki/Free_Space_Map_Problems.", "title": "Fix WAL-logging of truncation of relation free space maps and visibility maps", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "dedb870c93a58c7b297dfbdceb99a67c9cd045fcacedfb23fc768ef5d758ec6b", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix WAL-logging of truncation of relation free space maps and visibility maps (Pavan Deolasee, Heikki Linnakangas) It was possible for these files to not be correctly restored during crash recovery, or to be written incorrectly on a standby server. Bogus entries in a free space map could lead to attempts to access pages that have been truncated away from the relation itself, typically producing errors like could not read block XXX: read only 0 of 8192 bytes. Checksum failures in the visibility map are also possible, if checksumming is enabled. Procedures for determining whether there is a problem and repairing it if so are discussed at .", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/001", "db_id": "ec09950c4b42590a3a372f8dbd97440b", "patch_ids": [], "statement_hash": "27cdeeeff24fa935a7c84bfda055fcf082be79fb96036a1751c3a8e5058cc734", "relations": [{"rule": 2, "type": "equivalent", "target": "2e98beda261d76d5e2d451d7d589fe76", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27cdeeeff24fa935a7c84bfda055fcf082be79fb96036a1751c3a8e5058cc734"}}, {"rule": 2, "type": "equivalent", "target": "b8931467596606ee308ef7bf67015c41", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27cdeeeff24fa935a7c84bfda055fcf082be79fb96036a1751c3a8e5058cc734"}}, {"rule": 2, "type": "equivalent", "target": "f7aa35ae515033d8874d9c9a6d5aa129", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27cdeeeff24fa935a7c84bfda055fcf082be79fb96036a1751c3a8e5058cc734"}}], "version": "9.4.10", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "f7aa35ae515033d8874d9c9a6d5aa129", "kind": "equivalent", "version": "9.6.1", "label": "9.6.1", "title": "Fix WAL-logging of truncation of relation free space maps and visibility maps", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27cdeeeff24fa935a7c84bfda055fcf082be79fb96036a1751c3a8e5058cc734"}, "url": "/docs/compare/?release=9.6.1#9.6.1-3182bd69069db480", "source_url": "/docs/release/9.6.1/#AEN136022"}, {"db_id": "2e98beda261d76d5e2d451d7d589fe76", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix WAL-logging of truncation of relation free space maps and visibility maps", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27cdeeeff24fa935a7c84bfda055fcf082be79fb96036a1751c3a8e5058cc734"}, "url": "/docs/compare/?release=9.5.5#9.5.5-3182bd69069db480", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "b8931467596606ee308ef7bf67015c41", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Fix WAL-logging of truncation of relation free space maps and visibility maps", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "27cdeeeff24fa935a7c84bfda055fcf082be79fb96036a1751c3a8e5058cc734"}, "url": "/docs/compare/?release=9.3.15#9.3.15-3182bd69069db480", "source_url": "/docs/release/9.3.15/#AEN116409"}]}, {"id": "9.4.10-b45989bd5ce428aa", "cves": [], "html": "Fix incorrect creation of GIN index WAL records on big-endian machines (Tom Lane)
\nThe typical symptom was \"unexpected GIN leaf action\" errors during WAL replay.
", "text": "Fix incorrect creation of GIN index WAL records on big-endian machines (Tom Lane) The typical symptom was \"unexpected GIN leaf action\" errors during WAL replay.", "title": "Fix incorrect creation of GIN index WAL records on big-endian machines", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "c9cd22af205df5e0d6977236d8f48ecd8c2cc33ca64797ed73aa4288bfa56f56", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix incorrect creation of GIN index WAL records on big-endian machines (Tom Lane) The typical symptom was unexpected GIN leaf action errors during WAL replay.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/002", "db_id": "eb4d0c525c0ef44c220a825fb0b508d7", "patch_ids": [], "statement_hash": "2d9e8e4cc29b638a190aaa83b7bb6147c57da6516bbde75b816b992317cb3fb8", "relations": [{"rule": 2, "type": "equivalent", "target": "6cd082caf9be4eb78ad4256a09b6d86e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2d9e8e4cc29b638a190aaa83b7bb6147c57da6516bbde75b816b992317cb3fb8"}}], "version": "9.4.10", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "6cd082caf9be4eb78ad4256a09b6d86e", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix incorrect creation of GIN index WAL records on big-endian machines", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2d9e8e4cc29b638a190aaa83b7bb6147c57da6516bbde75b816b992317cb3fb8"}, "url": "/docs/compare/?release=9.5.5#9.5.5-b45989bd5ce428aa", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.4.10-d981b03eab7461b3", "cves": [], "html": "Fix SELECT FOR UPDATE/SHARE to correctly lock tuples that have been updated by a subsequently-aborted transaction (Álvaro Herrera)
\nIn 9.5 and later, the SELECT would sometimes fail to return such tuples at all. A failure has not been proven to occur in earlier releases, but might be possible with concurrent updates.
", "text": "Fix SELECT FOR UPDATE/SHARE to correctly lock tuples that have been updated by a subsequently-aborted transaction (Álvaro Herrera) In 9.5 and later, the SELECT would sometimes fail to return such tuples at all. A failure has not been proven to occur in earlier releases, but might be possible with concurrent updates.", "title": "Fix SELECT FOR UPDATE/SHARE to correctly lock tuples that have been updated by a subsequently-aborted transaction", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "f978d3ffd9dea4bf36af2deea9652dcf6fa18a53b3945decf138d0c95f340fd5", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix SELECT FOR UPDATE/SHARE to correctly lock tuples that have been updated by a subsequently-aborted transaction (Álvaro Herrera) In 9.5 and later, the SELECT would sometimes fail to return such tuples at all. A failure has not been proven to occur in earlier releases, but might be possible with concurrent updates.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/003", "db_id": "7c87550f2317efb9f2362234580f3f1e", "patch_ids": [], "statement_hash": "0a144b49adada71071be4ca3d4de4af3e8c9eb389e9be0dde2ca6bd2d1f41ddf", "relations": [{"rule": 2, "type": "equivalent", "target": "8b6aba51defd566c424604d159108cd1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0a144b49adada71071be4ca3d4de4af3e8c9eb389e9be0dde2ca6bd2d1f41ddf"}}, {"rule": 2, "type": "equivalent", "target": "b80c379abd79da59846ca10cf5e8e526", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0a144b49adada71071be4ca3d4de4af3e8c9eb389e9be0dde2ca6bd2d1f41ddf"}}], "version": "9.4.10", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "8b6aba51defd566c424604d159108cd1", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix SELECT FOR UPDATE/SHARE to correctly lock tuples that have been updated by a subsequently-aborted transaction", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0a144b49adada71071be4ca3d4de4af3e8c9eb389e9be0dde2ca6bd2d1f41ddf"}, "url": "/docs/compare/?release=9.5.5#9.5.5-d981b03eab7461b3", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "b80c379abd79da59846ca10cf5e8e526", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Fix SELECT FOR UPDATE/SHARE to correctly lock tuples that have been updated by a subsequently-aborted transaction", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0a144b49adada71071be4ca3d4de4af3e8c9eb389e9be0dde2ca6bd2d1f41ddf"}, "url": "/docs/compare/?release=9.3.15#9.3.15-d981b03eab7461b3", "source_url": "/docs/release/9.3.15/#AEN116409"}]}, {"id": "9.4.10-67b610bf9d81c508", "cves": [], "html": "Fix EvalPlanQual rechecks involving CTE scans (Tom Lane)
\nThe recheck would always see the CTE as returning no rows, typically leading to failure to update rows that were recently updated.
", "text": "Fix EvalPlanQual rechecks involving CTE scans (Tom Lane) The recheck would always see the CTE as returning no rows, typically leading to failure to update rows that were recently updated.", "title": "Fix EvalPlanQual rechecks involving CTE scans", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "934f64db561426b4fb2731286513fbfc3a6d01248ae274203642ce636ab3d585", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix EvalPlanQual rechecks involving CTE scans (Tom Lane) The recheck would always see the CTE as returning no rows, typically leading to failure to update rows that were recently updated.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/004", "db_id": "148b0fed49731389ecd14f2ebc3d1067", "patch_ids": [], "statement_hash": "3922d3edd8ef9a6128553b94e92bb013dc6c62c46c5dc805ef648aea848cd84b", "relations": [{"rule": 2, "type": "equivalent", "target": "0a6f14182f50b9a5c9c9ea74490ccc30", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3922d3edd8ef9a6128553b94e92bb013dc6c62c46c5dc805ef648aea848cd84b"}}, {"rule": 2, "type": "equivalent", "target": "a48b38961155ef2e30667a393641fa53", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3922d3edd8ef9a6128553b94e92bb013dc6c62c46c5dc805ef648aea848cd84b"}}, {"rule": 2, "type": "equivalent", "target": "b38da6d063494a10eabf2dd1ce5243c0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3922d3edd8ef9a6128553b94e92bb013dc6c62c46c5dc805ef648aea848cd84b"}}, {"rule": 2, "type": "equivalent", "target": "ca8b268793e0e49d7ceb1df2a66e0437", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3922d3edd8ef9a6128553b94e92bb013dc6c62c46c5dc805ef648aea848cd84b"}}], "version": "9.4.10", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "b38da6d063494a10eabf2dd1ce5243c0", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix EvalPlanQual rechecks involving CTE scans", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3922d3edd8ef9a6128553b94e92bb013dc6c62c46c5dc805ef648aea848cd84b"}, "url": "/docs/compare/?release=9.5.5#9.5.5-67b610bf9d81c508", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "ca8b268793e0e49d7ceb1df2a66e0437", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Fix EvalPlanQual rechecks involving CTE scans", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3922d3edd8ef9a6128553b94e92bb013dc6c62c46c5dc805ef648aea848cd84b"}, "url": "/docs/compare/?release=9.3.15#9.3.15-67b610bf9d81c508", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "a48b38961155ef2e30667a393641fa53", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Fix EvalPlanQual rechecks involving CTE scans", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3922d3edd8ef9a6128553b94e92bb013dc6c62c46c5dc805ef648aea848cd84b"}, "url": "/docs/compare/?release=9.2.19#9.2.19-67b610bf9d81c508", "source_url": "/docs/release/9.2.19/#AEN111404"}, {"db_id": "0a6f14182f50b9a5c9c9ea74490ccc30", "kind": "equivalent", "version": "9.1.24", "label": "9.1.24", "title": "Fix EvalPlanQual rechecks involving CTE scans", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3922d3edd8ef9a6128553b94e92bb013dc6c62c46c5dc805ef648aea848cd84b"}, "url": "/docs/compare/?release=9.1.24#9.1.24-67b610bf9d81c508", "source_url": "/docs/release/9.1.24/#AEN106976"}]}, {"id": "9.4.10-55e16768bded3f09", "cves": [], "html": "Fix improper repetition of previous results from hashed aggregation in a subquery (Andrew Gierth)
\nThe test to see if we can reuse a previously-computed hash table of the aggregate state values neglected the possibility of an outer query reference appearing in an aggregate argument expression. A change in the value of such a reference should lead to recalculating the hash table, but did not.
", "text": "Fix improper repetition of previous results from hashed aggregation in a subquery (Andrew Gierth) The test to see if we can reuse a previously-computed hash table of the aggregate state values neglected the possibility of an outer query reference appearing in an aggregate argument expression. A change in the value of such a reference should lead to recalculating the hash table, but did not.", "title": "Fix improper repetition of previous results from hashed aggregation in a subquery", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "667ebcb76b27edbb0e8d87c218b6cdb7eeccdb846db5137425092b2b564edbd7", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix improper repetition of previous results from hashed aggregation in a subquery (Andrew Gierth) The test to see if we can reuse a previously-computed hash table of the aggregate state values neglected the possibility of an outer query reference appearing in an aggregate argument expression. A change in the value of such a reference should lead to recalculating the hash table, but did not.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/005", "db_id": "2020a7bdb0fbf3ca85de8798e0305bf1", "patch_ids": [], "statement_hash": "26bb3f470abaf63521436764cda9a018275d21c7262ddddde93473add7b9af0d", "relations": [{"rule": 2, "type": "equivalent", "target": "00d5f51d3260f5e9e1b91bd6cbeec4ce", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "26bb3f470abaf63521436764cda9a018275d21c7262ddddde93473add7b9af0d"}}, {"rule": 2, "type": "equivalent", "target": "53320ec46d8b47b6ac4020cf83467a0a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "26bb3f470abaf63521436764cda9a018275d21c7262ddddde93473add7b9af0d"}}, {"rule": 2, "type": "equivalent", "target": "79952d6e4a60f982e06c23562ae2bd7f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "26bb3f470abaf63521436764cda9a018275d21c7262ddddde93473add7b9af0d"}}, {"rule": 2, "type": "equivalent", "target": "867a54d1479298adf343b084a19b61e2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "26bb3f470abaf63521436764cda9a018275d21c7262ddddde93473add7b9af0d"}}], "version": "9.4.10", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "00d5f51d3260f5e9e1b91bd6cbeec4ce", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix improper repetition of previous results from hashed aggregation in a subquery", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "26bb3f470abaf63521436764cda9a018275d21c7262ddddde93473add7b9af0d"}, "url": "/docs/compare/?release=9.5.5#9.5.5-55e16768bded3f09", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "867a54d1479298adf343b084a19b61e2", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Fix improper repetition of previous results from hashed aggregation in a subquery", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "26bb3f470abaf63521436764cda9a018275d21c7262ddddde93473add7b9af0d"}, "url": "/docs/compare/?release=9.3.15#9.3.15-55e16768bded3f09", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "79952d6e4a60f982e06c23562ae2bd7f", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Fix improper repetition of previous results from hashed aggregation in a subquery", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "26bb3f470abaf63521436764cda9a018275d21c7262ddddde93473add7b9af0d"}, "url": "/docs/compare/?release=9.2.19#9.2.19-55e16768bded3f09", "source_url": "/docs/release/9.2.19/#AEN111404"}, {"db_id": "53320ec46d8b47b6ac4020cf83467a0a", "kind": "equivalent", "version": "9.1.24", "label": "9.1.24", "title": "Fix improper repetition of previous results from hashed aggregation in a subquery", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "26bb3f470abaf63521436764cda9a018275d21c7262ddddde93473add7b9af0d"}, "url": "/docs/compare/?release=9.1.24#9.1.24-55e16768bded3f09", "source_url": "/docs/release/9.1.24/#AEN106976"}]}, {"id": "9.4.10-c4aabeb3a8399bb0", "cves": [], "html": "Fix query-lifespan memory leak in a bulk UPDATE on a table with a PRIMARY KEY or REPLICA IDENTITY index (Tom Lane)
", "text": "Fix query-lifespan memory leak in a bulk UPDATE on a table with a PRIMARY KEY or REPLICA IDENTITY index (Tom Lane)", "title": "Fix query-lifespan memory leak in a bulk UPDATE on a table with a PRIMARY KEY or REPLICA IDENTITY index", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "abfc799837400ae77c3f4912456e0d386c0b1bbaaaf966264d129d0990c55d19", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix query-lifespan memory leak in a bulk UPDATE on a table with a PRIMARY KEY or REPLICA IDENTITY index (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/006", "db_id": "eac60a695d3e9acd71bfc4b2b8d33448", "patch_ids": [], "statement_hash": "728f6d20b34ce5985dcd26f1b69756d76ccd77244c316694a9f40eeeac84def2", "relations": [{"rule": 2, "type": "equivalent", "target": "62848c362b33387e01af49e0111bc76f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "728f6d20b34ce5985dcd26f1b69756d76ccd77244c316694a9f40eeeac84def2"}}], "version": "9.4.10", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "62848c362b33387e01af49e0111bc76f", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix query-lifespan memory leak in a bulk UPDATE on a table with a PRIMARY KEY or REPLICA IDENTITY index", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "728f6d20b34ce5985dcd26f1b69756d76ccd77244c316694a9f40eeeac84def2"}, "url": "/docs/compare/?release=9.5.5#9.5.5-c4aabeb3a8399bb0", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.4.10-353e840feef16b9a", "cves": [], "html": "Fix EXPLAIN to emit valid XML when track_io_timing is on (Markus Winand)
\nPreviously the XML output-format option produced syntactically invalid tags such as <I/O-Read-Time>. That is now rendered as <I-O-Read-Time>.
", "text": "Fix EXPLAIN to emit valid XML when track_io_timing is on (Markus Winand) Previously the XML output-format option produced syntactically invalid tags such as . That is now rendered asSuppress printing of zeroes for unmeasured times in EXPLAIN (Maksim Milyutin)
\nCertain option combinations resulted in printing zero values for times that actually aren't ever measured in that combination. Our general policy in EXPLAIN is not to print such fields at all, so do that consistently in all cases.
", "text": "Suppress printing of zeroes for unmeasured times in EXPLAIN (Maksim Milyutin) Certain option combinations resulted in printing zero values for times that actually aren't ever measured in that combination. Our general policy in EXPLAIN is not to print such fields at all, so do that consistently in all cases.", "title": "Suppress printing of zeroes for unmeasured times in EXPLAIN", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "2c7edfbe528d1c971c3a6605f87f7ab02d1942d7b53eecbea37a3ef0c2f56e36", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Suppress printing of zeroes for unmeasured times in EXPLAIN (Maksim Milyutin) Certain option combinations resulted in printing zero values for times that actually aren't ever measured in that combination. Our general policy in EXPLAIN is not to print such fields at all, so do that consistently in all cases.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/008", "db_id": "d24172a3af57a138185911bdf4ae8731", "patch_ids": [], "statement_hash": "c6bf184d53e5909258f39ab47dce71afad2e272336c14d18475da673b29837b8", "relations": [{"rule": 2, "type": "equivalent", "target": "522257de20e54cfe8122c8f9c559c49c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c6bf184d53e5909258f39ab47dce71afad2e272336c14d18475da673b29837b8"}}, {"rule": 2, "type": "equivalent", "target": "67ee677c366a316903ec4b2e54b471d3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c6bf184d53e5909258f39ab47dce71afad2e272336c14d18475da673b29837b8"}}, {"rule": 2, "type": "equivalent", "target": "e56603a7f48fddbe68c96e0a63a33cb2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c6bf184d53e5909258f39ab47dce71afad2e272336c14d18475da673b29837b8"}}], "version": "9.4.10", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "522257de20e54cfe8122c8f9c559c49c", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Suppress printing of zeroes for unmeasured times in EXPLAIN", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c6bf184d53e5909258f39ab47dce71afad2e272336c14d18475da673b29837b8"}, "url": "/docs/compare/?release=9.5.5#9.5.5-2e8359cbd4beca64", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "67ee677c366a316903ec4b2e54b471d3", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Suppress printing of zeroes for unmeasured times in EXPLAIN", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c6bf184d53e5909258f39ab47dce71afad2e272336c14d18475da673b29837b8"}, "url": "/docs/compare/?release=9.3.15#9.3.15-2e8359cbd4beca64", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "e56603a7f48fddbe68c96e0a63a33cb2", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Suppress printing of zeroes for unmeasured times in EXPLAIN", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c6bf184d53e5909258f39ab47dce71afad2e272336c14d18475da673b29837b8"}, "url": "/docs/compare/?release=9.2.19#9.2.19-2e8359cbd4beca64", "source_url": "/docs/release/9.2.19/#AEN111404"}]}, {"id": "9.4.10-de9f7d5895562a71", "cves": [], "html": "Fix timeout length when VACUUM is waiting for exclusive table lock so that it can truncate the table (Simon Riggs)
\nThe timeout was meant to be 50 milliseconds, but it was actually only 50 microseconds, causing VACUUM to give up on truncation much more easily than intended. Set it to the intended value.
", "text": "Fix timeout length when VACUUM is waiting for exclusive table lock so that it can truncate the table (Simon Riggs) The timeout was meant to be 50 milliseconds, but it was actually only 50 microseconds, causing VACUUM to give up on truncation much more easily than intended. Set it to the intended value.", "title": "Fix timeout length when VACUUM is waiting for exclusive table lock so that it can truncate the table", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "a88a1a8f2b6919d53f15eeaeedf61fb8d38d9c4039061e621a4e0a0d81ee59b0", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix timeout length when VACUUM is waiting for exclusive table lock so that it can truncate the table (Simon Riggs) The timeout was meant to be 50 milliseconds, but it was actually only 50 microseconds, causing VACUUM to give up on truncation much more easily than intended. Set it to the intended value.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/009", "db_id": "b6e519c98f89f30c1819fa8ae87b9238", "patch_ids": [], "statement_hash": "8e1750cd34b1da6ea50cda2bcea08aad7bae5f29bba6a05fdeaa3950bbdffb63", "relations": [{"rule": 2, "type": "equivalent", "target": "1cb079dbd3940fef26c1064d66af44f7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8e1750cd34b1da6ea50cda2bcea08aad7bae5f29bba6a05fdeaa3950bbdffb63"}}, {"rule": 2, "type": "equivalent", "target": "56e997b4a49879750a680dce08d3c5c3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8e1750cd34b1da6ea50cda2bcea08aad7bae5f29bba6a05fdeaa3950bbdffb63"}}, {"rule": 2, "type": "equivalent", "target": "5b3e6ca70c68eb8f46e1990a4fd3c678", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8e1750cd34b1da6ea50cda2bcea08aad7bae5f29bba6a05fdeaa3950bbdffb63"}}, {"rule": 2, "type": "equivalent", "target": "e22909c1e13ebaf44cf39bdd22fb0be2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8e1750cd34b1da6ea50cda2bcea08aad7bae5f29bba6a05fdeaa3950bbdffb63"}}], "version": "9.4.10", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "1cb079dbd3940fef26c1064d66af44f7", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix timeout length when VACUUM is waiting for exclusive table lock so that it can truncate the table", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8e1750cd34b1da6ea50cda2bcea08aad7bae5f29bba6a05fdeaa3950bbdffb63"}, "url": "/docs/compare/?release=9.5.5#9.5.5-de9f7d5895562a71", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "5b3e6ca70c68eb8f46e1990a4fd3c678", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Fix timeout length when VACUUM is waiting for exclusive table lock so that it can truncate the table", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8e1750cd34b1da6ea50cda2bcea08aad7bae5f29bba6a05fdeaa3950bbdffb63"}, "url": "/docs/compare/?release=9.3.15#9.3.15-de9f7d5895562a71", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "56e997b4a49879750a680dce08d3c5c3", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Fix timeout length when VACUUM is waiting for exclusive table lock so that it can truncate the table", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8e1750cd34b1da6ea50cda2bcea08aad7bae5f29bba6a05fdeaa3950bbdffb63"}, "url": "/docs/compare/?release=9.2.19#9.2.19-de9f7d5895562a71", "source_url": "/docs/release/9.2.19/#AEN111404"}, {"db_id": "e22909c1e13ebaf44cf39bdd22fb0be2", "kind": "equivalent", "version": "9.1.24", "label": "9.1.24", "title": "Fix timeout length when VACUUM is waiting for exclusive table lock so that it can truncate the table", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8e1750cd34b1da6ea50cda2bcea08aad7bae5f29bba6a05fdeaa3950bbdffb63"}, "url": "/docs/compare/?release=9.1.24#9.1.24-de9f7d5895562a71", "source_url": "/docs/release/9.1.24/#AEN106976"}]}, {"id": "9.4.10-c92ac7bad376f3b4", "cves": [], "html": "Fix bugs in merging inherited CHECK constraints while creating or altering a table (Tom Lane, Amit Langote)
\nAllow identical CHECK constraints to be added to a parent and child table in either order. Prevent merging of a valid constraint from the parent table with a NOT VALID constraint on the child. Likewise, prevent merging of a NO INHERIT child constraint with an inherited constraint.
", "text": "Fix bugs in merging inherited CHECK constraints while creating or altering a table (Tom Lane, Amit Langote) Allow identical CHECK constraints to be added to a parent and child table in either order. Prevent merging of a valid constraint from the parent table with a NOT VALID constraint on the child. Likewise, prevent merging of a NO INHERIT child constraint with an inherited constraint.", "title": "Fix bugs in merging inherited CHECK constraints while creating or altering a table", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "5664e9a5115fa888916d0ee1a063a08c848230561c141770c8e17294e7920d23", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix bugs in merging inherited CHECK constraints while creating or altering a table (Tom Lane, Amit Langote) Allow identical CHECK constraints to be added to a parent and child table in either order. Prevent merging of a valid constraint from the parent table with a NOT VALID constraint on the child. Likewise, prevent merging of a NO INHERIT child constraint with an inherited constraint.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/010", "db_id": "864da9828cbc9dedf3a48fbb88838d2c", "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a", "relations": [{"rule": 2, "type": "equivalent", "target": "17c3b5c88a4e18eeb9db0d79f1bd4738", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a"}}, {"rule": 2, "type": "equivalent", "target": "820976eee5d0d58fc24e6faef69ef024", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a"}}, {"rule": 2, "type": "equivalent", "target": "cf4210aa72e5ceb04465bf6396e92fd3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a"}}, {"rule": 2, "type": "equivalent", "target": "d0ba967b9080e8d3d7c374af62b71ddc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a"}}], "version": "9.4.10", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "820976eee5d0d58fc24e6faef69ef024", "kind": "equivalent", "version": "9.6.1", "label": "9.6.1", "title": "Fix bugs in merging inherited CHECK constraints while creating or altering a table", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a"}, "url": "/docs/compare/?release=9.6.1#9.6.1-c92ac7bad376f3b4", "source_url": "/docs/release/9.6.1/#AEN136022"}, {"db_id": "d0ba967b9080e8d3d7c374af62b71ddc", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix bugs in merging inherited CHECK constraints while creating or altering a table", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a"}, "url": "/docs/compare/?release=9.5.5#9.5.5-c92ac7bad376f3b4", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "cf4210aa72e5ceb04465bf6396e92fd3", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Fix bugs in merging inherited CHECK constraints while creating or altering a table", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a"}, "url": "/docs/compare/?release=9.3.15#9.3.15-c92ac7bad376f3b4", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "17c3b5c88a4e18eeb9db0d79f1bd4738", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Fix bugs in merging inherited CHECK constraints while creating or altering a table", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c6b2020261c2724cfab703b00857db00700c29782efcb621b3753fb01eaa86a"}, "url": "/docs/compare/?release=9.2.19#9.2.19-c92ac7bad376f3b4", "source_url": "/docs/release/9.2.19/#AEN111404"}]}, {"id": "9.4.10-eb67448d3399e1e3", "cves": [], "html": "Remove artificial restrictions on the values accepted by numeric_in() and numeric_recv() (Tom Lane)
We allow numeric values up to the limit of the storage format (more than 1e100000), so it seems fairly pointless that numeric_in() rejected scientific-notation exponents above 1000. Likewise, it was silly for numeric_recv() to reject more than 1000 digits in an input value.
Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock (Thomas Munro, Peter Geoghegan, Tom Lane)
", "text": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock (Thomas Munro, Peter Geoghegan, Tom Lane)", "title": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "2088d92c0623ce8060de46d34e6c772b1f84018e689d34acab32b10abccbee9d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock (Thomas Munro, Peter Geoghegan, Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/012", "db_id": "53b0b52d899de881f8586469efa7f5aa", "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37", "relations": [{"rule": 2, "type": "equivalent", "target": "6ca408c5775b0169d72f4bf6b3f53cbe", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}}, {"rule": 2, "type": "equivalent", "target": "ae85002bd79a9c04b168f6dc9ace9ce5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}}, {"rule": 2, "type": "equivalent", "target": "f765abee4edf5f8c07e5c00859b6aef5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}}, {"rule": 2, "type": "equivalent", "target": "faba4ef996319c8db73db30748abf489", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}}, {"rule": 2, "type": "equivalent", "target": "fec739de452ca83cbdf70ca3235da08b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}}], "version": "9.4.10", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "faba4ef996319c8db73db30748abf489", "kind": "equivalent", "version": "9.6.1", "label": "9.6.1", "title": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}, "url": "/docs/compare/?release=9.6.1#9.6.1-e29f106759f1d612", "source_url": "/docs/release/9.6.1/#AEN136022"}, {"db_id": "fec739de452ca83cbdf70ca3235da08b", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}, "url": "/docs/compare/?release=9.5.5#9.5.5-e29f106759f1d612", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "f765abee4edf5f8c07e5c00859b6aef5", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}, "url": "/docs/compare/?release=9.3.15#9.3.15-e29f106759f1d612", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "6ca408c5775b0169d72f4bf6b3f53cbe", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}, "url": "/docs/compare/?release=9.2.19#9.2.19-e29f106759f1d612", "source_url": "/docs/release/9.2.19/#AEN111404"}, {"db_id": "ae85002bd79a9c04b168f6dc9ace9ce5", "kind": "equivalent", "version": "9.1.24", "label": "9.1.24", "title": "Avoid very-low-probability data corruption due to testing tuple visibility without holding buffer lock", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc3a7ed96669ea608d4c733bb9f23d94722acad9fff15a88d593a50d15116c37"}, "url": "/docs/compare/?release=9.1.24#9.1.24-e29f106759f1d612", "source_url": "/docs/release/9.1.24/#AEN106976"}]}, {"id": "9.4.10-588c3e1995825d77", "cves": [], "html": "Fix logical WAL decoding to work properly when a subtransaction's WAL output is large enough to spill to disk (Andres Freund)
", "text": "Fix logical WAL decoding to work properly when a subtransaction's WAL output is large enough to spill to disk (Andres Freund)", "title": "Fix logical WAL decoding to work properly when a subtransaction's WAL output is large enough to spill to disk", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "b458bfae4ac627222bd7ba147b4b9b31945589a1e7d82d28f69e29ac875827d3", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix logical WAL decoding to work properly when a subtransaction's WAL output is large enough to spill to disk (Andres Freund)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/013", "db_id": "523527d73ae0b1bd4d93ce8d8679d2ff", "patch_ids": [], "statement_hash": "fb79dd6fa77aee0939f4bd03a29e002dc5b2c387280a8afe3431ec8d2cdb5550", "relations": [{"rule": 2, "type": "equivalent", "target": "470a039e7a7d709e873acc07b7315fed", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fb79dd6fa77aee0939f4bd03a29e002dc5b2c387280a8afe3431ec8d2cdb5550"}}, {"rule": 2, "type": "equivalent", "target": "7fbb078e2be4bbd5ba0ce87dfe2ac2b2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fb79dd6fa77aee0939f4bd03a29e002dc5b2c387280a8afe3431ec8d2cdb5550"}}], "version": "9.4.10", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "7fbb078e2be4bbd5ba0ce87dfe2ac2b2", "kind": "equivalent", "version": "9.6.1", "label": "9.6.1", "title": "Fix logical WAL decoding to work properly when a subtransaction's WAL output is large enough to spill to disk", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fb79dd6fa77aee0939f4bd03a29e002dc5b2c387280a8afe3431ec8d2cdb5550"}, "url": "/docs/compare/?release=9.6.1#9.6.1-588c3e1995825d77", "source_url": "/docs/release/9.6.1/#AEN136022"}, {"db_id": "470a039e7a7d709e873acc07b7315fed", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix logical WAL decoding to work properly when a subtransaction's WAL output is large enough to spill to disk", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fb79dd6fa77aee0939f4bd03a29e002dc5b2c387280a8afe3431ec8d2cdb5550"}, "url": "/docs/compare/?release=9.5.5#9.5.5-588c3e1995825d77", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.4.10-08b87182da0ae5a7", "cves": [], "html": "Fix buffer overread in logical WAL decoding (Tom Lane)
\nLogical decoding of a tuple update record read 23 bytes too many, which was usually harmless but with very bad luck could result in a crash.
", "text": "Fix buffer overread in logical WAL decoding (Tom Lane) Logical decoding of a tuple update record read 23 bytes too many, which was usually harmless but with very bad luck could result in a crash.", "title": "Fix buffer overread in logical WAL decoding", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "2139de9aca97b54b530cfc639437c225e0b375cb6c327a07add7754baa6647c2", "section_path": ["Changes"], "commit_groups": [["10ad15f48"]], "identity_text": "Fix buffer overread in logical WAL decoding (Tom Lane) Logical decoding of a tuple update record read 23 bytes too many, which was usually harmless but with very bad luck could result in a crash.", "commit_aliases": ["10ad15f48"], "source_commits": ["10ad15f48"], "source_entry_id": "9.4.10/changes/014", "db_id": "52567e959c751908669e44f50e5c70e9", "patch_ids": ["c0b022764576bd09722054338c645937"], "statement_hash": "5188932e981be09baaafa5e901bf4e86bf1a868d616ea08f83347607f1844b73", "relations": [], "version": "9.4.10", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.4.10-aeb33b54712610b8", "cves": [], "html": "Fix file descriptor leakage when truncating a temporary relation of more than 1GB (Andres Freund)
", "text": "Fix file descriptor leakage when truncating a temporary relation of more than 1GB (Andres Freund)", "title": "Fix file descriptor leakage when truncating a temporary relation of more than 1GB", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "9a53c0088d60382ad47e1fe04bc5a4341b1f90e32f9de51b92c74bf8854332db", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix file descriptor leakage when truncating a temporary relation of more than 1GB (Andres Freund)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/015", "db_id": "ab4fc2910d13bf23ffd61316064bb01c", "patch_ids": [], "statement_hash": "d7cf9bd3d4ed2d44b98b0685eab1a96a80439eb3b83f955881792a0666dd7ab3", "relations": [{"rule": 2, "type": "equivalent", "target": "83d2e2fe32c55c203f2ded6cd8374eca", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d7cf9bd3d4ed2d44b98b0685eab1a96a80439eb3b83f955881792a0666dd7ab3"}}, {"rule": 2, "type": "equivalent", "target": "aa88f9f6926279796753592c45883a86", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d7cf9bd3d4ed2d44b98b0685eab1a96a80439eb3b83f955881792a0666dd7ab3"}}, {"rule": 2, "type": "equivalent", "target": "b968a9e8dab9d2bfdbe1558ed1e6c414", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d7cf9bd3d4ed2d44b98b0685eab1a96a80439eb3b83f955881792a0666dd7ab3"}}, {"rule": 2, "type": "equivalent", "target": "e18dd780cb4b753fd2ebe6b802d3c37f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d7cf9bd3d4ed2d44b98b0685eab1a96a80439eb3b83f955881792a0666dd7ab3"}}], "version": "9.4.10", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "aa88f9f6926279796753592c45883a86", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix file descriptor leakage when truncating a temporary relation of more than 1GB", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d7cf9bd3d4ed2d44b98b0685eab1a96a80439eb3b83f955881792a0666dd7ab3"}, "url": "/docs/compare/?release=9.5.5#9.5.5-aeb33b54712610b8", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "83d2e2fe32c55c203f2ded6cd8374eca", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Fix file descriptor leakage when truncating a temporary relation of more than 1GB", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d7cf9bd3d4ed2d44b98b0685eab1a96a80439eb3b83f955881792a0666dd7ab3"}, "url": "/docs/compare/?release=9.3.15#9.3.15-aeb33b54712610b8", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "e18dd780cb4b753fd2ebe6b802d3c37f", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Fix file descriptor leakage when truncating a temporary relation of more than 1GB", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d7cf9bd3d4ed2d44b98b0685eab1a96a80439eb3b83f955881792a0666dd7ab3"}, "url": "/docs/compare/?release=9.2.19#9.2.19-aeb33b54712610b8", "source_url": "/docs/release/9.2.19/#AEN111404"}, {"db_id": "b968a9e8dab9d2bfdbe1558ed1e6c414", "kind": "equivalent", "version": "9.1.24", "label": "9.1.24", "title": "Fix file descriptor leakage when truncating a temporary relation of more than 1GB", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d7cf9bd3d4ed2d44b98b0685eab1a96a80439eb3b83f955881792a0666dd7ab3"}, "url": "/docs/compare/?release=9.1.24#9.1.24-aeb33b54712610b8", "source_url": "/docs/release/9.1.24/#AEN106976"}]}, {"id": "9.4.10-f635ecbe16f5c2db", "cves": [], "html": "Disallow starting a standalone backend with standby_mode turned on (Michael Paquier)
\nThis can't do anything useful, since there will be no WAL receiver process to fetch more WAL data; and it could result in misbehavior in code that wasn't designed with this situation in mind.
", "text": "Disallow starting a standalone backend with standby_mode turned on (Michael Paquier) This can't do anything useful, since there will be no WAL receiver process to fetch more WAL data; and it could result in misbehavior in code that wasn't designed with this situation in mind.", "title": "Disallow starting a standalone backend with standby_mode turned on", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "5aa9396bc0c7bf820c271dbcf9603cb6dd4984916a0dd0ad36b9a749ee2e5c97", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Disallow starting a standalone backend with standby_mode turned on (Michael Paquier) This can't do anything useful, since there will be no WAL receiver process to fetch more WAL data; and it could result in misbehavior in code that wasn't designed with this situation in mind.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/016", "db_id": "ac1759edd7767fc474e87059273b5158", "patch_ids": [], "statement_hash": "d01bfcbddf2c65c32e5e7a2d049baaacae2f5fb02e5cec4950d3675c9c165d38", "relations": [{"rule": 2, "type": "equivalent", "target": "158516e1eddd49983f3b4f829956eec1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d01bfcbddf2c65c32e5e7a2d049baaacae2f5fb02e5cec4950d3675c9c165d38"}}, {"rule": 2, "type": "equivalent", "target": "17b6d5fba75136b8d707e13f8a93e3bb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d01bfcbddf2c65c32e5e7a2d049baaacae2f5fb02e5cec4950d3675c9c165d38"}}, {"rule": 2, "type": "equivalent", "target": "775c280a36f8bbb4957832f77d57a7b7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d01bfcbddf2c65c32e5e7a2d049baaacae2f5fb02e5cec4950d3675c9c165d38"}}, {"rule": 2, "type": "equivalent", "target": "c86ab88b8e5235177f445a4e1c359640", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d01bfcbddf2c65c32e5e7a2d049baaacae2f5fb02e5cec4950d3675c9c165d38"}}], "version": "9.4.10", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "17b6d5fba75136b8d707e13f8a93e3bb", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Disallow starting a standalone backend with standby_mode turned on", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d01bfcbddf2c65c32e5e7a2d049baaacae2f5fb02e5cec4950d3675c9c165d38"}, "url": "/docs/compare/?release=9.5.5#9.5.5-f635ecbe16f5c2db", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "775c280a36f8bbb4957832f77d57a7b7", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Disallow starting a standalone backend with standby_mode turned on", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d01bfcbddf2c65c32e5e7a2d049baaacae2f5fb02e5cec4950d3675c9c165d38"}, "url": "/docs/compare/?release=9.3.15#9.3.15-f635ecbe16f5c2db", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "158516e1eddd49983f3b4f829956eec1", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Disallow starting a standalone backend with standby_mode turned on", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d01bfcbddf2c65c32e5e7a2d049baaacae2f5fb02e5cec4950d3675c9c165d38"}, "url": "/docs/compare/?release=9.2.19#9.2.19-f635ecbe16f5c2db", "source_url": "/docs/release/9.2.19/#AEN111404"}, {"db_id": "c86ab88b8e5235177f445a4e1c359640", "kind": "equivalent", "version": "9.1.24", "label": "9.1.24", "title": "Disallow starting a standalone backend with standby_mode turned on", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d01bfcbddf2c65c32e5e7a2d049baaacae2f5fb02e5cec4950d3675c9c165d38"}, "url": "/docs/compare/?release=9.1.24#9.1.24-f635ecbe16f5c2db", "source_url": "/docs/release/9.1.24/#AEN106976"}]}, {"id": "9.4.10-d48ba12a13fe3871", "cves": [], "html": "Properly initialize replication slot state when recycling a previously-used slot (Michael Paquier)
\nThis failure to reset all of the fields of the slot could prevent VACUUM from removing dead tuples.
", "text": "Properly initialize replication slot state when recycling a previously-used slot (Michael Paquier) This failure to reset all of the fields of the slot could prevent VACUUM from removing dead tuples.", "title": "Properly initialize replication slot state when recycling a previously-used slot", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "e205ef8fb463923acfda6e7a3c44841dc4f663223fabb95ded1a46d3de6d7f59", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Properly initialize replication slot state when recycling a previously-used slot (Michael Paquier) This failure to reset all of the fields of the slot could prevent VACUUM from removing dead tuples.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/017", "db_id": "c480c56a6c3e73c6550cd4a2b253963a", "patch_ids": [], "statement_hash": "8c38c129d6988171b05dae6f5b8db37180ab031c305242cddea2bffb4f26c946", "relations": [{"rule": 2, "type": "equivalent", "target": "aa2600090c7c138237ab6c24bce0a003", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8c38c129d6988171b05dae6f5b8db37180ab031c305242cddea2bffb4f26c946"}}], "version": "9.4.10", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "aa2600090c7c138237ab6c24bce0a003", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Properly initialize replication slot state when recycling a previously-used slot", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8c38c129d6988171b05dae6f5b8db37180ab031c305242cddea2bffb4f26c946"}, "url": "/docs/compare/?release=9.5.5#9.5.5-d48ba12a13fe3871", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.4.10-6eb27c2c26383bc7", "cves": [], "html": "Round shared-memory allocation request to a multiple of the actual huge page size when attempting to use huge pages on Linux (Tom Lane)
\nThis avoids possible failures during munmap() on systems with atypical default huge page sizes. Except in crash-recovery cases, there were no ill effects other than a log message.
Use a more random value for the dynamic shared memory control segment's ID (Robert Haas, Tom Lane)
\nPreviously, the same value would be chosen every time, because it was derived from random() but srandom() had not yet been called. While relatively harmless, this was not the intended behavior.
On Windows, retry creation of the dynamic shared memory control segment after an access-denied error (Kyotaro Horiguchi, Amit Kapila)
\nWindows sometimes returns ERROR_ACCESS_DENIED rather than ERROR_ALREADY_EXISTS when there is an existing segment. This led to postmaster startup failure due to believing that the former was an unrecoverable error.
", "text": "On Windows, retry creation of the dynamic shared memory control segment after an access-denied error (Kyotaro Horiguchi, Amit Kapila) Windows sometimes returns ERROR_ACCESS_DENIED rather than ERROR_ALREADY_EXISTS when there is an existing segment. This led to postmaster startup failure due to believing that the former was an unrecoverable error.", "title": "On Windows, retry creation of the dynamic shared memory control segment after an access-denied error", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "964605c5d581123723b353f00ff2e27758d6d26a1f5fb86ce6caf8f38d2b2826", "section_path": ["Changes"], "commit_groups": [], "identity_text": "On Windows, retry creation of the dynamic shared memory control segment after an access-denied error (Kyotaro Horiguchi, Amit Kapila) Windows sometimes returns ERROR_ACCESS_DENIED rather than ERROR_ALREADY_EXISTS when there is an existing segment. This led to postmaster startup failure due to believing that the former was an unrecoverable error.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/020", "db_id": "fc3dd85a25f500ef5ff0c2b37429bae6", "patch_ids": [], "statement_hash": "8874db656c76c9270702a3cc8674c4f595856024b24f4911580a59724acee4b6", "relations": [{"rule": 2, "type": "equivalent", "target": "504b9b899ec78865c5f917084a763665", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8874db656c76c9270702a3cc8674c4f595856024b24f4911580a59724acee4b6"}}], "version": "9.4.10", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "504b9b899ec78865c5f917084a763665", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "On Windows, retry creation of the dynamic shared memory control segment after an access-denied error", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8874db656c76c9270702a3cc8674c4f595856024b24f4911580a59724acee4b6"}, "url": "/docs/compare/?release=9.5.5#9.5.5-8acfd38a71bad791", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.4.10-6d29334411af4cef", "cves": [], "html": "Don't try to share SSL contexts across multiple connections in libpq (Heikki Linnakangas)
\nThis led to assorted corner-case bugs, particularly when trying to use different SSL parameters for different connections.
", "text": "Don't try to share SSL contexts across multiple connections in libpq (Heikki Linnakangas) This led to assorted corner-case bugs, particularly when trying to use different SSL parameters for different connections.", "title": "Don't try to share SSL contexts across multiple connections in libpq", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "39c58d256746dddeb5985975affc084f1f580e434421afec12e9f80792262683", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Don't try to share SSL contexts across multiple connections in libpq (Heikki Linnakangas) This led to assorted corner-case bugs, particularly when trying to use different SSL parameters for different connections.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/021", "db_id": "6cf72552733f502b0431bb9d9b3679f7", "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679", "relations": [{"rule": 2, "type": "equivalent", "target": "5797a86f9ccff5c9d9bc62cededb71ea", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}}, {"rule": 2, "type": "equivalent", "target": "78f23bf21615092d97ff903e3cbe4886", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}}, {"rule": 2, "type": "equivalent", "target": "8e470a25f92f8433de8ca041850612c3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}}, {"rule": 2, "type": "equivalent", "target": "dd8ac44910aec9313eac765230d29672", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}}, {"rule": 2, "type": "equivalent", "target": "e4e858812dc39cda82cd0c879258e22e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}}], "version": "9.4.10", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "e4e858812dc39cda82cd0c879258e22e", "kind": "equivalent", "version": "9.6.1", "label": "9.6.1", "title": "Don't try to share SSL contexts across multiple connections in libpq", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}, "url": "/docs/compare/?release=9.6.1#9.6.1-6d29334411af4cef", "source_url": "/docs/release/9.6.1/#AEN136022"}, {"db_id": "78f23bf21615092d97ff903e3cbe4886", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Don't try to share SSL contexts across multiple connections in libpq", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}, "url": "/docs/compare/?release=9.5.5#9.5.5-6d29334411af4cef", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "8e470a25f92f8433de8ca041850612c3", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Don't try to share SSL contexts across multiple connections in libpq", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}, "url": "/docs/compare/?release=9.3.15#9.3.15-6d29334411af4cef", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "dd8ac44910aec9313eac765230d29672", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Don't try to share SSL contexts across multiple connections in libpq", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}, "url": "/docs/compare/?release=9.2.19#9.2.19-6d29334411af4cef", "source_url": "/docs/release/9.2.19/#AEN111404"}, {"db_id": "5797a86f9ccff5c9d9bc62cededb71ea", "kind": "equivalent", "version": "9.1.24", "label": "9.1.24", "title": "Don't try to share SSL contexts across multiple connections in libpq", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bdce0efd0e728656918668f39af1d03df422501f0a4f0d9ef15d30efce81679"}, "url": "/docs/compare/?release=9.1.24#9.1.24-6d29334411af4cef", "source_url": "/docs/release/9.1.24/#AEN106976"}]}, {"id": "9.4.10-146da81fa7fafcdd", "cves": [], "html": "Avoid corner-case memory leak in libpq (Tom Lane)
\nThe reported problem involved leaking an error report during PQreset(), but there might be related cases.
Make ecpg's --help and --version options work consistently with our other executables (Haribabu Kommi)
", "text": "Make ecpg's --help and --version options work consistently with our other executables (Haribabu Kommi)", "title": "Make ecpg's --help and --version options work consistently with our other executables", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "0afbd62d6f50d76344c8bf02e9e9f0ad669e43b7ed03991efe04aa3c23720008", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Make ecpg's --help and --version options work consistently with our other executables (Haribabu Kommi)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/023", "db_id": "1659101e0086790df02e1950ab4440e8", "patch_ids": [], "statement_hash": "d40f0b8552d5f34084ba6f54d31af1d3b275af576416d83375ccdffc325f845f", "relations": [{"rule": 2, "type": "equivalent", "target": "339f6f243a994ed5be7aee0f49aef1fe", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d40f0b8552d5f34084ba6f54d31af1d3b275af576416d83375ccdffc325f845f"}}, {"rule": 2, "type": "equivalent", "target": "5c5b1a7cd2e44b591bff258e7b9e924a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d40f0b8552d5f34084ba6f54d31af1d3b275af576416d83375ccdffc325f845f"}}, {"rule": 2, "type": "equivalent", "target": "c3222ac30548b14f58131955d74c5e16", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d40f0b8552d5f34084ba6f54d31af1d3b275af576416d83375ccdffc325f845f"}}, {"rule": 2, "type": "equivalent", "target": "fc5034e388a6016454326e2b73a1a750", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d40f0b8552d5f34084ba6f54d31af1d3b275af576416d83375ccdffc325f845f"}}], "version": "9.4.10", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "c3222ac30548b14f58131955d74c5e16", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Make ecpg's --help and --version options work consistently with our other executables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d40f0b8552d5f34084ba6f54d31af1d3b275af576416d83375ccdffc325f845f"}, "url": "/docs/compare/?release=9.5.5#9.5.5-2d727a5adc420d70", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "5c5b1a7cd2e44b591bff258e7b9e924a", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Make ecpg's --help and --version options work consistently with our other executables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d40f0b8552d5f34084ba6f54d31af1d3b275af576416d83375ccdffc325f845f"}, "url": "/docs/compare/?release=9.3.15#9.3.15-2d727a5adc420d70", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "fc5034e388a6016454326e2b73a1a750", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Make ecpg's --help and --version options work consistently with our other executables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d40f0b8552d5f34084ba6f54d31af1d3b275af576416d83375ccdffc325f845f"}, "url": "/docs/compare/?release=9.2.19#9.2.19-2d727a5adc420d70", "source_url": "/docs/release/9.2.19/#AEN111404"}, {"db_id": "339f6f243a994ed5be7aee0f49aef1fe", "kind": "equivalent", "version": "9.1.24", "label": "9.1.24", "title": "Make ecpg's --help and --version options work consistently with our other executables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d40f0b8552d5f34084ba6f54d31af1d3b275af576416d83375ccdffc325f845f"}, "url": "/docs/compare/?release=9.1.24#9.1.24-2d727a5adc420d70", "source_url": "/docs/release/9.1.24/#AEN106976"}]}, {"id": "9.4.10-5dc80a24a4171805", "cves": [], "html": "Fix pgbench's calculation of average latency (Fabien Coelho)
\nThe calculation was incorrect when there were \\sleep commands in the script, or when the test duration was specified in number of transactions rather than total time.
", "text": "Fix pgbench's calculation of average latency (Fabien Coelho) The calculation was incorrect when there were \\sleep commands in the script, or when the test duration was specified in number of transactions rather than total time.", "title": "Fix pgbench's calculation of average latency", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "00247f1065d11adfad6308bd424edad6a5c35653992b79cfd019b0c149288c34", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix pgbench's calculation of average latency (Fabien Coelho) The calculation was incorrect when there were \\sleep commands in the script, or when the test duration was specified in number of transactions rather than total time.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/024", "db_id": "9e5d49a1e718308cc2d71572e7a67c2a", "patch_ids": [], "statement_hash": "60012fd4326a48fa04b6d6c96d492005513e34f39565735941f2f6c365386d2b", "relations": [{"rule": 2, "type": "equivalent", "target": "3e392d73b9daedfe824cc3ac0de5e469", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "60012fd4326a48fa04b6d6c96d492005513e34f39565735941f2f6c365386d2b"}}], "version": "9.4.10", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "3e392d73b9daedfe824cc3ac0de5e469", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix pgbench's calculation of average latency", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "60012fd4326a48fa04b6d6c96d492005513e34f39565735941f2f6c365386d2b"}, "url": "/docs/compare/?release=9.5.5#9.5.5-5dc80a24a4171805", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.4.10-ca68b47e75d6beb4", "cves": [], "html": "In pg_dump, never dump range constructor functions (Tom Lane)
\nThis oversight led to pg_upgrade failures with extensions containing range types, due to duplicate creation of the constructor functions.
", "text": "In pg_dump, never dump range constructor functions (Tom Lane) This oversight led to pg_upgrade failures with extensions containing range types, due to duplicate creation of the constructor functions.", "title": "In pg_dump, never dump range constructor functions", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "7e9764b38ad4deb812081e00f91eb95b248e0feb9c4c88bc096ace39a107fa5a", "section_path": ["Changes"], "commit_groups": [], "identity_text": "In pg_dump, never dump range constructor functions (Tom Lane) This oversight led to pg_upgrade failures with extensions containing range types, due to duplicate creation of the constructor functions.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/025", "db_id": "ddd2576c9b8acb7403028207cd9cbdd0", "patch_ids": [], "statement_hash": "d5bf8efc77acb573dcdcc234a2efdfd482bff1f0075ec509ee7c8662fb75e952", "relations": [{"rule": 2, "type": "equivalent", "target": "45805377ff61f58f54c6e0f320c5c06b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d5bf8efc77acb573dcdcc234a2efdfd482bff1f0075ec509ee7c8662fb75e952"}}, {"rule": 2, "type": "equivalent", "target": "6286726427ae08d053a9c2b837dac3b1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d5bf8efc77acb573dcdcc234a2efdfd482bff1f0075ec509ee7c8662fb75e952"}}, {"rule": 2, "type": "equivalent", "target": "6758ee8a8d57ab2e9be9471f1385751d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d5bf8efc77acb573dcdcc234a2efdfd482bff1f0075ec509ee7c8662fb75e952"}}], "version": "9.4.10", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "45805377ff61f58f54c6e0f320c5c06b", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "In pg_dump, never dump range constructor functions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d5bf8efc77acb573dcdcc234a2efdfd482bff1f0075ec509ee7c8662fb75e952"}, "url": "/docs/compare/?release=9.5.5#9.5.5-ca68b47e75d6beb4", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "6758ee8a8d57ab2e9be9471f1385751d", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "In pg_dump, never dump range constructor functions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d5bf8efc77acb573dcdcc234a2efdfd482bff1f0075ec509ee7c8662fb75e952"}, "url": "/docs/compare/?release=9.3.15#9.3.15-ca68b47e75d6beb4", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "6286726427ae08d053a9c2b837dac3b1", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "In pg_dump, never dump range constructor functions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d5bf8efc77acb573dcdcc234a2efdfd482bff1f0075ec509ee7c8662fb75e952"}, "url": "/docs/compare/?release=9.2.19#9.2.19-ca68b47e75d6beb4", "source_url": "/docs/release/9.2.19/#AEN111404"}]}, {"id": "9.4.10-d6c2b719b3c71ef8", "cves": [], "html": "In pg_xlogdump, retry opening new WAL segments when using --follow option (Magnus Hagander)
\nThis allows for a possible delay in the server's creation of the next segment.
", "text": "In pg_xlogdump, retry opening new WAL segments when using --follow option (Magnus Hagander) This allows for a possible delay in the server's creation of the next segment.", "title": "In pg_xlogdump, retry opening new WAL segments when using --follow option", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "2996780c666d4ac7f291aae339067028f0b3e25d19845a00e5c1ee7f347eb6b8", "section_path": ["Changes"], "commit_groups": [], "identity_text": "In pg_xlogdump, retry opening new WAL segments when using --follow option (Magnus Hagander) This allows for a possible delay in the server's creation of the next segment.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/026", "db_id": "95a5bd12885de7f441144ce2c9527398", "patch_ids": [], "statement_hash": "cc129e42363d4b76d77a04575b50b11e577ea99eb260c4e34c9e6a17e9b0fb1a", "relations": [{"rule": 2, "type": "equivalent", "target": "2113e3ca11fc4e23dbedd995bafef047", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc129e42363d4b76d77a04575b50b11e577ea99eb260c4e34c9e6a17e9b0fb1a"}}, {"rule": 2, "type": "equivalent", "target": "76feb8e100587752206df4baba988197", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc129e42363d4b76d77a04575b50b11e577ea99eb260c4e34c9e6a17e9b0fb1a"}}, {"rule": 2, "type": "equivalent", "target": "f2af211971ec3653a813cd132d95e373", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc129e42363d4b76d77a04575b50b11e577ea99eb260c4e34c9e6a17e9b0fb1a"}}], "version": "9.4.10", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "76feb8e100587752206df4baba988197", "kind": "equivalent", "version": "9.6.1", "label": "9.6.1", "title": "In pg_xlogdump, retry opening new WAL segments when using --follow option", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc129e42363d4b76d77a04575b50b11e577ea99eb260c4e34c9e6a17e9b0fb1a"}, "url": "/docs/compare/?release=9.6.1#9.6.1-d6c2b719b3c71ef8", "source_url": "/docs/release/9.6.1/#AEN136022"}, {"db_id": "2113e3ca11fc4e23dbedd995bafef047", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "In pg_xlogdump, retry opening new WAL segments when using --follow option", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc129e42363d4b76d77a04575b50b11e577ea99eb260c4e34c9e6a17e9b0fb1a"}, "url": "/docs/compare/?release=9.5.5#9.5.5-d6c2b719b3c71ef8", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "f2af211971ec3653a813cd132d95e373", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "In pg_xlogdump, retry opening new WAL segments when using --follow option", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc129e42363d4b76d77a04575b50b11e577ea99eb260c4e34c9e6a17e9b0fb1a"}, "url": "/docs/compare/?release=9.3.15#9.3.15-d6c2b719b3c71ef8", "source_url": "/docs/release/9.3.15/#AEN116409"}]}, {"id": "9.4.10-2cc983f54b68e7c0", "cves": [], "html": "Fix pg_xlogdump to cope with a WAL file that begins with a continuation record spanning more than one page (Pavan Deolasee)
", "text": "Fix pg_xlogdump to cope with a WAL file that begins with a continuation record spanning more than one page (Pavan Deolasee)", "title": "Fix pg_xlogdump to cope with a WAL file that begins with a continuation record spanning more than one page", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "0fb2a5a90a1cc69987d8ad5d6baef6c01e097ff1740c1fd5cc2605096f41ea00", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix pg_xlogdump to cope with a WAL file that begins with a continuation record spanning more than one page (Pavan Deolasee)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/027", "db_id": "1fa1b083505cca8a3abe727a733bca7e", "patch_ids": [], "statement_hash": "f88ce84ac85d4dcb3931362d27e57890b59c0d11bf42aa62c5b38af39319db94", "relations": [{"rule": 2, "type": "equivalent", "target": "191b24290bddfb26a1b9fe0a19e62b1f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f88ce84ac85d4dcb3931362d27e57890b59c0d11bf42aa62c5b38af39319db94"}}, {"rule": 2, "type": "equivalent", "target": "3f77b1204e9ac32cd41ef7bc2b0596c7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f88ce84ac85d4dcb3931362d27e57890b59c0d11bf42aa62c5b38af39319db94"}}], "version": "9.4.10", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "191b24290bddfb26a1b9fe0a19e62b1f", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix pg_xlogdump to cope with a WAL file that begins with a continuation record spanning more than one page", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f88ce84ac85d4dcb3931362d27e57890b59c0d11bf42aa62c5b38af39319db94"}, "url": "/docs/compare/?release=9.5.5#9.5.5-2cc983f54b68e7c0", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "3f77b1204e9ac32cd41ef7bc2b0596c7", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Fix pg_xlogdump to cope with a WAL file that begins with a continuation record spanning more than one page", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f88ce84ac85d4dcb3931362d27e57890b59c0d11bf42aa62c5b38af39319db94"}, "url": "/docs/compare/?release=9.3.15#9.3.15-2cc983f54b68e7c0", "source_url": "/docs/release/9.3.15/#AEN116409"}]}, {"id": "9.4.10-2f4907a3b0b30b78", "cves": [], "html": "Fix contrib/pg_buffercache to work when shared_buffers exceeds 256GB (KaiGai Kohei)
", "text": "Fix contrib/pg_buffercache to work when shared_buffers exceeds 256GB (KaiGai Kohei)", "title": "Fix contrib/pg_buffercache to work when shared_buffers exceeds 256GB", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "e2a4377d934609315789c11539c857491c70d3395f128d1512153b130735d911", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix contrib/pg_buffercache to work when shared_buffers exceeds 256GB (KaiGai Kohei)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/028", "db_id": "aa8db93079c150b4f674cbe90a8583b5", "patch_ids": [], "statement_hash": "1c050e95e9395c824e4b1d706bdc2e9831189d8dba1e289502414c97dfebeebd", "relations": [{"rule": 2, "type": "equivalent", "target": "c2d6cc68ae58ef2c19e6324fe66e4d36", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1c050e95e9395c824e4b1d706bdc2e9831189d8dba1e289502414c97dfebeebd"}}], "version": "9.4.10", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c2d6cc68ae58ef2c19e6324fe66e4d36", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix contrib/pg_buffercache to work when shared_buffers exceeds 256GB", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1c050e95e9395c824e4b1d706bdc2e9831189d8dba1e289502414c97dfebeebd"}, "url": "/docs/compare/?release=9.5.5#9.5.5-2f4907a3b0b30b78", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.4.10-9c716e6f079898e9", "cves": [], "html": "Fix contrib/intarray/bench/bench.pl to print the results of the EXPLAIN it does when given the -e option (Daniel Gustafsson)
", "text": "Fix contrib/intarray/bench/bench.pl to print the results of the EXPLAIN it does when given the -e option (Daniel Gustafsson)", "title": "Fix contrib/intarray/bench/bench.pl to print the results of the EXPLAIN it does when given the -e option", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "7b5f586fbf91b0245f7f87535c542fd871ecb13a658614c489d8bd2662439f8f", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix contrib/intarray/bench/bench.pl to print the results of the EXPLAIN it does when given the -e option (Daniel Gustafsson)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/029", "db_id": "f7a1ae4f312b1995da02acf347333172", "patch_ids": [], "statement_hash": "9420134ff7c10c51247f87cdec5ac3767f018ff424db34d2044c3161fa4ef0af", "relations": [{"rule": 2, "type": "equivalent", "target": "0afe03d9c13386818a87770d67e74516", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9420134ff7c10c51247f87cdec5ac3767f018ff424db34d2044c3161fa4ef0af"}}, {"rule": 2, "type": "equivalent", "target": "16bfdd1ebb9bc5431be3dd0810325ab0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9420134ff7c10c51247f87cdec5ac3767f018ff424db34d2044c3161fa4ef0af"}}, {"rule": 2, "type": "equivalent", "target": "8b5f7f4d86e14acc040472393303f9e8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9420134ff7c10c51247f87cdec5ac3767f018ff424db34d2044c3161fa4ef0af"}}, {"rule": 2, "type": "equivalent", "target": "afd918ad19c19455b21959aadd0fa8d5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9420134ff7c10c51247f87cdec5ac3767f018ff424db34d2044c3161fa4ef0af"}}], "version": "9.4.10", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "8b5f7f4d86e14acc040472393303f9e8", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Fix contrib/intarray/bench/bench.pl to print the results of the EXPLAIN it does when given the -e option", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9420134ff7c10c51247f87cdec5ac3767f018ff424db34d2044c3161fa4ef0af"}, "url": "/docs/compare/?release=9.5.5#9.5.5-9c716e6f079898e9", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "0afe03d9c13386818a87770d67e74516", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Fix contrib/intarray/bench/bench.pl to print the results of the EXPLAIN it does when given the -e option", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9420134ff7c10c51247f87cdec5ac3767f018ff424db34d2044c3161fa4ef0af"}, "url": "/docs/compare/?release=9.3.15#9.3.15-9c716e6f079898e9", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "16bfdd1ebb9bc5431be3dd0810325ab0", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Fix contrib/intarray/bench/bench.pl to print the results of the EXPLAIN it does when given the -e option", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9420134ff7c10c51247f87cdec5ac3767f018ff424db34d2044c3161fa4ef0af"}, "url": "/docs/compare/?release=9.2.19#9.2.19-9c716e6f079898e9", "source_url": "/docs/release/9.2.19/#AEN111404"}, {"db_id": "afd918ad19c19455b21959aadd0fa8d5", "kind": "equivalent", "version": "9.1.24", "label": "9.1.24", "title": "Fix contrib/intarray/bench/bench.pl to print the results of the EXPLAIN it does when given the -e option", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9420134ff7c10c51247f87cdec5ac3767f018ff424db34d2044c3161fa4ef0af"}, "url": "/docs/compare/?release=9.1.24#9.1.24-9c716e6f079898e9", "source_url": "/docs/release/9.1.24/#AEN106976"}]}, {"id": "9.4.10-51624ac4a9f2cac6", "cves": [], "html": "Install TAP test infrastructure so that it's available for extension testing (Craig Ringer)
\nWhen PostgreSQL has been configured with --enable-tap-tests, \"make install\" will now install the Perl support files for TAP testing where PGXS can find them. This allows non-core extensions to use $(prove_check) without extra tests.
", "text": "Install TAP test infrastructure so that it's available for extension testing (Craig Ringer) When PostgreSQL has been configured with --enable-tap-tests, \"make install\" will now install the Perl support files for TAP testing where PGXS can find them. This allows non-core extensions to use $(prove_check) without extra tests.", "title": "Install TAP test infrastructure so that it's available for extension testing", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "140a531da2edbeefd1d1ac5111977d18179465a6dac1a4dc661effcf54bef501", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Install TAP test infrastructure so that it's available for extension testing (Craig Ringer) When PostgreSQL has been configured with --enable-tap-tests, make install will now install the Perl support files for TAP testing where PGXS can find them. This allows non-core extensions to use $(prove_check) without extra tests.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/030", "db_id": "668ed2d59fbe6ad19562e96c88dbf687", "patch_ids": [], "statement_hash": "625aad3af2feb62c0a0c916776661c7e453afe99ade993e9e7d626d3ba5058ee", "relations": [{"rule": 2, "type": "equivalent", "target": "5b9e9aae0abacb5759a1671bf37135ce", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "625aad3af2feb62c0a0c916776661c7e453afe99ade993e9e7d626d3ba5058ee"}}], "version": "9.4.10", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "5b9e9aae0abacb5759a1671bf37135ce", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Install TAP test infrastructure so that it's available for extension testing", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "625aad3af2feb62c0a0c916776661c7e453afe99ade993e9e7d626d3ba5058ee"}, "url": "/docs/compare/?release=9.5.5#9.5.5-51624ac4a9f2cac6", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.4.10-b419ef923c791b1f", "cves": [], "html": "In MSVC builds, include pg_recvlogical in a client-only installation (MauMau)
", "text": "In MSVC builds, include pg_recvlogical in a client-only installation (MauMau)", "title": "In MSVC builds, include pg_recvlogical in a client-only installation", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "ead0062b897dcff75341d56a03e7e0c4f99766a20a790afd8e3b631a75a5ddfd", "section_path": ["Changes"], "commit_groups": [], "identity_text": "In MSVC builds, include pg_recvlogical in a client-only installation (MauMau)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/031", "db_id": "96a28da5b6064a286edb38bee738a473", "patch_ids": [], "statement_hash": "65ad53d99cf7be8c24c2ebbd72b485de5d1f4dacf7b5887ff62119b6439cf7fc", "relations": [{"rule": 2, "type": "equivalent", "target": "40ec45c35752459021ff63f1eab808bd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "65ad53d99cf7be8c24c2ebbd72b485de5d1f4dacf7b5887ff62119b6439cf7fc"}}], "version": "9.4.10", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "40ec45c35752459021ff63f1eab808bd", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "In MSVC builds, include pg_recvlogical in a client-only installation", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "65ad53d99cf7be8c24c2ebbd72b485de5d1f4dacf7b5887ff62119b6439cf7fc"}, "url": "/docs/compare/?release=9.5.5#9.5.5-b419ef923c791b1f", "source_url": "/docs/release/9.5.5/#AEN130514"}]}, {"id": "9.4.10-f557224a0eb337ce", "cves": [], "html": "Update Windows time zone mapping to recognize some time zone names added in recent Windows versions (Michael Paquier)
", "text": "Update Windows time zone mapping to recognize some time zone names added in recent Windows versions (Michael Paquier)", "title": "Update Windows time zone mapping to recognize some time zone names added in recent Windows versions", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "556fb70f9bbe200c607d7189b978f1d7791f7bc6d09e3559f9845da4dcdfc30d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Update Windows time zone mapping to recognize some time zone names added in recent Windows versions (Michael Paquier)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/032", "db_id": "303b126cbdf7b2f603b153bd85b9ec15", "patch_ids": [], "statement_hash": "a5f2e61a4e81589849f2584aebebae6a6dc61e2d4a60776b2c13d59549eb9f02", "relations": [{"rule": 2, "type": "equivalent", "target": "01222902cd56ceb67b87f9da8850094c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a5f2e61a4e81589849f2584aebebae6a6dc61e2d4a60776b2c13d59549eb9f02"}}, {"rule": 2, "type": "equivalent", "target": "32cb494f8b870eb0a9738a2a41d404ad", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a5f2e61a4e81589849f2584aebebae6a6dc61e2d4a60776b2c13d59549eb9f02"}}, {"rule": 2, "type": "equivalent", "target": "f895fb7f193e14fd82c57cfa43eaaddd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a5f2e61a4e81589849f2584aebebae6a6dc61e2d4a60776b2c13d59549eb9f02"}}], "version": "9.4.10", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "01222902cd56ceb67b87f9da8850094c", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Update Windows time zone mapping to recognize some time zone names added in recent Windows versions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a5f2e61a4e81589849f2584aebebae6a6dc61e2d4a60776b2c13d59549eb9f02"}, "url": "/docs/compare/?release=9.5.5#9.5.5-f557224a0eb337ce", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "f895fb7f193e14fd82c57cfa43eaaddd", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Update Windows time zone mapping to recognize some time zone names added in recent Windows versions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a5f2e61a4e81589849f2584aebebae6a6dc61e2d4a60776b2c13d59549eb9f02"}, "url": "/docs/compare/?release=9.3.15#9.3.15-f557224a0eb337ce", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "32cb494f8b870eb0a9738a2a41d404ad", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Update Windows time zone mapping to recognize some time zone names added in recent Windows versions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a5f2e61a4e81589849f2584aebebae6a6dc61e2d4a60776b2c13d59549eb9f02"}, "url": "/docs/compare/?release=9.2.19#9.2.19-f557224a0eb337ce", "source_url": "/docs/release/9.2.19/#AEN111404"}]}, {"id": "9.4.10-d1888cfb2338d0d3", "cves": [], "html": "Prevent failure of obsolete dynamic time zone abbreviations (Tom Lane)
\nIf a dynamic time zone abbreviation does not match any entry in the referenced time zone, treat it as equivalent to the time zone name. This avoids unexpected failures when IANA removes abbreviations from their time zone database, as they did in tzdata release 2016f and seem likely to do again in the future. The consequences were not limited to not recognizing the individual abbreviation; any mismatch caused the pg_timezone_abbrevs view to fail altogether.
", "text": "Prevent failure of obsolete dynamic time zone abbreviations (Tom Lane) If a dynamic time zone abbreviation does not match any entry in the referenced time zone, treat it as equivalent to the time zone name. This avoids unexpected failures when IANA removes abbreviations from their time zone database, as they did in tzdata release 2016f and seem likely to do again in the future. The consequences were not limited to not recognizing the individual abbreviation; any mismatch caused the pg_timezone_abbrevs view to fail altogether.", "title": "Prevent failure of obsolete dynamic time zone abbreviations", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "a2097fca9617b10e9fb35371bfb26fcbbcfcb50eeb5dfdcbb87ef9b699150ed6", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent failure of obsolete dynamic time zone abbreviations (Tom Lane) If a dynamic time zone abbreviation does not match any entry in the referenced time zone, treat it as equivalent to the time zone name. This avoids unexpected failures when IANA removes abbreviations from their time zone database, as they did in tzdata release 2016f and seem likely to do again in the future. The consequences were not limited to not recognizing the individual abbreviation; any mismatch caused the pg_timezone_abbrevs view to fail altogether.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/033", "db_id": "dc1afb1d01533caa8aae0cf843da733b", "patch_ids": [], "statement_hash": "35d45066f14462f4493102a420364b5089af97901d4244fc255bdedf7fa35d59", "relations": [{"rule": 2, "type": "equivalent", "target": "195a934a80213ad9d10533d9ec6910bb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "35d45066f14462f4493102a420364b5089af97901d4244fc255bdedf7fa35d59"}}, {"rule": 2, "type": "equivalent", "target": "347843adccf78436c54349829d70ac0e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "35d45066f14462f4493102a420364b5089af97901d4244fc255bdedf7fa35d59"}}, {"rule": 2, "type": "equivalent", "target": "81013ca3e28e75920b95bb9d099b8774", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "35d45066f14462f4493102a420364b5089af97901d4244fc255bdedf7fa35d59"}}, {"rule": 2, "type": "equivalent", "target": "edf77d6193d7ad0c8b055bfe401a7729", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "35d45066f14462f4493102a420364b5089af97901d4244fc255bdedf7fa35d59"}}], "version": "9.4.10", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "edf77d6193d7ad0c8b055bfe401a7729", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Prevent failure of obsolete dynamic time zone abbreviations", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "35d45066f14462f4493102a420364b5089af97901d4244fc255bdedf7fa35d59"}, "url": "/docs/compare/?release=9.5.5#9.5.5-d1888cfb2338d0d3", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "81013ca3e28e75920b95bb9d099b8774", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Prevent failure of obsolete dynamic time zone abbreviations", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "35d45066f14462f4493102a420364b5089af97901d4244fc255bdedf7fa35d59"}, "url": "/docs/compare/?release=9.3.15#9.3.15-d1888cfb2338d0d3", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "195a934a80213ad9d10533d9ec6910bb", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Prevent failure of obsolete dynamic time zone abbreviations", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "35d45066f14462f4493102a420364b5089af97901d4244fc255bdedf7fa35d59"}, "url": "/docs/compare/?release=9.2.19#9.2.19-d1888cfb2338d0d3", "source_url": "/docs/release/9.2.19/#AEN111404"}, {"db_id": "347843adccf78436c54349829d70ac0e", "kind": "equivalent", "version": "9.1.24", "label": "9.1.24", "title": "Prevent failure of obsolete dynamic time zone abbreviations", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "35d45066f14462f4493102a420364b5089af97901d4244fc255bdedf7fa35d59"}, "url": "/docs/compare/?release=9.1.24#9.1.24-d1888cfb2338d0d3", "source_url": "/docs/release/9.1.24/#AEN106976"}]}, {"id": "9.4.10-8f8c191547e6f04d", "cves": [], "html": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka.
\nThe IANA time zone database previously provided textual abbreviations for all time zones, sometimes making up abbreviations that have little or no currency among the local population. They are in process of reversing that policy in favor of using numeric UTC offsets in zones where there is no evidence of real-world use of an English abbreviation. At least for the time being, PostgreSQL will continue to accept such removed abbreviations for timestamp input. But they will not be shown in the pg_timezone_names view nor used for output.
\nIn this update, AMT is no longer shown as being in use to mean Armenia Time. Therefore, we have changed the Default abbreviation set to interpret it as Amazon Time, thus UTC-4 not UTC+4.
", "text": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka. The IANA time zone database previously provided textual abbreviations for all time zones, sometimes making up abbreviations that have little or no currency among the local population. They are in process of reversing that policy in favor of using numeric UTC offsets in zones where there is no evidence of real-world use of an English abbreviation. At least for the time being, PostgreSQL will continue to accept such removed abbreviations for timestamp input. But they will not be shown in the pg_timezone_names view nor used for output. In this update, AMT is no longer shown as being in use to mean Armenia Time. Therefore, we have changed the Default abbreviation set to interpret it as Amazon Time, thus UTC-4 not UTC+4.", "title": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka.", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.10/#AEN122083", "source_hash": "5d876926e92fe088eeeeaa314b9c7614b9d93ea3fe45dee46c9c7d6b75e45bde", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka. The IANA time zone database previously provided textual abbreviations for all time zones, sometimes making up abbreviations that have little or no currency among the local population. They are in process of reversing that policy in favor of using numeric UTC offsets in zones where there is no evidence of real-world use of an English abbreviation. At least for the time being, PostgreSQL will continue to accept such removed abbreviations for timestamp input. But they will not be shown in the pg_timezone_names view nor used for output. In this update, AMT is no longer shown as being in use to mean Armenia Time. Therefore, we have changed the Default abbreviation set to interpret it as Amazon Time, thus UTC-4 not UTC+4.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.4.10/changes/034", "db_id": "22efdf8d456fcfa0566c2bec71378820", "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc", "relations": [{"rule": 2, "type": "equivalent", "target": "0beb84d0b5ea7d442a7e372ee1f44a0f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}}, {"rule": 2, "type": "equivalent", "target": "48ce47c9c15ba40810e3bf5ec621c6e2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}}, {"rule": 2, "type": "equivalent", "target": "649e25bc93cef830346c3561540e67e2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}}, {"rule": 2, "type": "equivalent", "target": "7dbf3562cb1733646d00e2c34c95c08d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}}, {"rule": 2, "type": "equivalent", "target": "acf105f7b3890b7ae360a1c91e091c35", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}}], "version": "9.4.10", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "48ce47c9c15ba40810e3bf5ec621c6e2", "kind": "equivalent", "version": "9.6.1", "label": "9.6.1", "title": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}, "url": "/docs/compare/?release=9.6.1#9.6.1-8f8c191547e6f04d", "source_url": "/docs/release/9.6.1/#AEN136022"}, {"db_id": "649e25bc93cef830346c3561540e67e2", "kind": "equivalent", "version": "9.5.5", "label": "9.5.5", "title": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}, "url": "/docs/compare/?release=9.5.5#9.5.5-8f8c191547e6f04d", "source_url": "/docs/release/9.5.5/#AEN130514"}, {"db_id": "7dbf3562cb1733646d00e2c34c95c08d", "kind": "equivalent", "version": "9.3.15", "label": "9.3.15", "title": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}, "url": "/docs/compare/?release=9.3.15#9.3.15-8f8c191547e6f04d", "source_url": "/docs/release/9.3.15/#AEN116409"}, {"db_id": "0beb84d0b5ea7d442a7e372ee1f44a0f", "kind": "equivalent", "version": "9.2.19", "label": "9.2.19", "title": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}, "url": "/docs/compare/?release=9.2.19#9.2.19-8f8c191547e6f04d", "source_url": "/docs/release/9.2.19/#AEN111404"}, {"db_id": "acf105f7b3890b7ae360a1c91e091c35", "kind": "equivalent", "version": "9.1.24", "label": "9.1.24", "title": "Update time zone data files to tzdata release 2016h for DST law changes in Palestine and Turkey, plus historical corrections for Turkey and some regions of Russia. Switch to numeric abbreviations for some time zones in Antarctica, the former Soviet Union, and Sri Lanka.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0cb45bb3cd4941ccdd512f55ef1911c539dd4baf115c1558d9c9521d14beb8fc"}, "url": "/docs/compare/?release=9.1.24#9.1.24-8f8c191547e6f04d", "source_url": "/docs/release/9.1.24/#AEN106976"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 34}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 18}, {"key": "security", "label": "Security", "count": 0}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 16}], "total": 34, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 34, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}