A dump/restore is not required for those running 9.5.X.
\nHowever, if you are upgrading from a version earlier than 9.5.13, see Section E.13.
", "compatibility_count": 0, "label": "9.5.14", "status_label": "Historical", "eol": "2021-02-11", "age_days": 2973, "support_days": -2056}, "groups": [{"date": "2018-08-09", "build": "9.5.14", "major": "9.5", "minor": 14, "manual": "9.5", "status": "stable", "doc_git": "", "version": "9.5.14", "eol_date": "2021-02-11", "date_text": "2018-08-09", "supported": false, "manual_url": "/docs/9.5/release-9-5-14.html", "source_url": "/docs/release/9.5.14/", "entry_count": 30, "placeholder": false, "content_hash": "f678fb4f5906798a63b0009befefca55b4756c5dcf2e029190b783af22cefbba", "manual_build": "9.5.25", "source_as_of": "", "changes_count": 30, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 9.5.X.
\nHowever, if you are upgrading from a version earlier than 9.5.13, see Section E.13.
", "compatibility_count": 0, "label": "9.5.14", "status_label": "Historical", "eol": "2021-02-11", "age_days": 2973, "support_days": -2056, "entries": [{"id": "9.5.14-d80cff6b3d99f931", "cves": ["CVE-2018-10915"], "html": "Fix failure to reset libpq's state fully between connection attempts (Tom Lane)
\nAn unprivileged user of dblink or postgres_fdw could bypass the checks intended to prevent use of server-side credentials, such as a ~/.pgpass file owned by the operating-system user running the server. Servers allowing peer authentication on local connections are particularly vulnerable. Other attacks such as SQL injection into a postgres_fdw session are also possible. Attacking postgres_fdw in this way requires the ability to create a foreign server object with selected connection parameters, but any user with access to dblink could exploit the problem. In general, an attacker with the ability to select the connection parameters for a libpq-using application could cause mischief, though other plausible attack scenarios are harder to think of. Our thanks to Andrew Krasichkov for reporting this issue. (CVE-2018-10915)
", "text": "Fix failure to reset libpq's state fully between connection attempts (Tom Lane) An unprivileged user of dblink or postgres_fdw could bypass the checks intended to prevent use of server-side credentials, such as a ~/.pgpass file owned by the operating-system user running the server. Servers allowing peer authentication on local connections are particularly vulnerable. Other attacks such as SQL injection into a postgres_fdw session are also possible. Attacking postgres_fdw in this way requires the ability to create a foreign server object with selected connection parameters, but any user with access to dblink could exploit the problem. In general, an attacker with the ability to select the connection parameters for a libpq-using application could cause mischief, though other plausible attack scenarios are harder to think of. Our thanks to Andrew Krasichkov for reporting this issue. (CVE-2018-10915)", "title": "Fix failure to reset libpq's state fully between connection attempts", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "f00fc376623ceedaac2518766e6f1b8a4be248cb6b2a63918246864740d3dd3b", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix failure to reset libpq's state fully between connection attempts (Tom Lane) An unprivileged user of dblink or postgres_fdw could bypass the checks intended to prevent use of server-side credentials, such as a ~/.pgpass file owned by the operating-system user running the server. Servers allowing peer authentication on local connections are particularly vulnerable. Other attacks such as SQL injection into a postgres_fdw session are also possible. Attacking postgres_fdw in this way requires the ability to create a foreign server object with selected connection parameters, but any user with access to dblink could exploit the problem. In general, an attacker with the ability to select the connection parameters for a libpq-using application could cause mischief, though other plausible attack scenarios are harder to think of. Our thanks to Andrew Krasichkov for reporting this issue. (CVE-2018-10915)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/001", "db_id": "29607663b820c5b5fee53b7793232307", "patch_ids": [], "statement_hash": "ad329a9602e5dec28c32ed4a012d732710b864b0bc70f9135ee685883d42a894", "relations": [{"rule": 2, "type": "equivalent", "target": "0d5cfb16f95275171c5876d4383372b2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ad329a9602e5dec28c32ed4a012d732710b864b0bc70f9135ee685883d42a894"}}, {"rule": 2, "type": "equivalent", "target": "1ee0462b731478038defdba984f32dd4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ad329a9602e5dec28c32ed4a012d732710b864b0bc70f9135ee685883d42a894"}}, {"rule": 2, "type": "equivalent", "target": "395fdb31804f461219c28a26580310df", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ad329a9602e5dec28c32ed4a012d732710b864b0bc70f9135ee685883d42a894"}}, {"rule": 2, "type": "equivalent", "target": "4484dc480da4deefaaf0cb9f04a8477c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ad329a9602e5dec28c32ed4a012d732710b864b0bc70f9135ee685883d42a894"}}], "version": "9.5.14", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "4484dc480da4deefaaf0cb9f04a8477c", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Fix failure to reset libpq's state fully between connection attempts", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ad329a9602e5dec28c32ed4a012d732710b864b0bc70f9135ee685883d42a894"}, "url": "/docs/compare/?release=10.5#10.5-d80cff6b3d99f931", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "0d5cfb16f95275171c5876d4383372b2", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Fix failure to reset libpq's state fully between connection attempts", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ad329a9602e5dec28c32ed4a012d732710b864b0bc70f9135ee685883d42a894"}, "url": "/docs/compare/?release=9.6.10#9.6.10-d80cff6b3d99f931", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "395fdb31804f461219c28a26580310df", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Fix failure to reset libpq's state fully between connection attempts", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ad329a9602e5dec28c32ed4a012d732710b864b0bc70f9135ee685883d42a894"}, "url": "/docs/compare/?release=9.4.19#9.4.19-d80cff6b3d99f931", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "1ee0462b731478038defdba984f32dd4", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Fix failure to reset libpq's state fully between connection attempts", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ad329a9602e5dec28c32ed4a012d732710b864b0bc70f9135ee685883d42a894"}, "url": "/docs/compare/?release=9.3.24#9.3.24-d80cff6b3d99f931", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-3e760d0542f92c95", "cves": ["CVE-2018-10925"], "html": "Fix INSERT ... ON CONFLICT UPDATE through a view that isn't just SELECT * FROM ... (Dean Rasheed, Amit Langote)
\nErroneous expansion of an updatable view could lead to crashes or \"attribute ... has the wrong type\" errors, if the view's SELECT list doesn't match one-to-one with the underlying table's columns. Furthermore, this bug could be leveraged to allow updates of columns that an attacking user lacks UPDATE privilege for, if that user has INSERT and UPDATE privileges for some other column(s) of the table. Any user could also use it for disclosure of server memory. (CVE-2018-10925)
", "text": "Fix INSERT ... ON CONFLICT UPDATE through a view that isn't just SELECT * FROM ... (Dean Rasheed, Amit Langote) Erroneous expansion of an updatable view could lead to crashes or \"attribute ... has the wrong type\" errors, if the view's SELECT list doesn't match one-to-one with the underlying table's columns. Furthermore, this bug could be leveraged to allow updates of columns that an attacking user lacks UPDATE privilege for, if that user has INSERT and UPDATE privileges for some other column(s) of the table. Any user could also use it for disclosure of server memory. (CVE-2018-10925)", "title": "Fix INSERT ... ON CONFLICT UPDATE through a view that isn't just SELECT * FROM ...", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "79c9850a9ceaad739e423cde26c39d9389470e02ae945dffa5c4c1649df148dd", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix INSERT ... ON CONFLICT UPDATE through a view that isn't just SELECT * FROM ... (Dean Rasheed, Amit Langote) Erroneous expansion of an updatable view could lead to crashes or attribute ... has the wrong type errors, if the view's SELECT list doesn't match one-to-one with the underlying table's columns. Furthermore, this bug could be leveraged to allow updates of columns that an attacking user lacks UPDATE privilege for, if that user has INSERT and UPDATE privileges for some other column(s) of the table. Any user could also use it for disclosure of server memory. (CVE-2018-10925)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/002", "db_id": "27150ec6c353f8cf45284bc75e4ec3ca", "patch_ids": [], "statement_hash": "7d9b36e0f42eb3c117d02fb4d1a66413944410df78a167abefe08e7595965292", "relations": [{"rule": 2, "type": "equivalent", "target": "da2ec324c1f899bc08a54ad2a1a57106", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7d9b36e0f42eb3c117d02fb4d1a66413944410df78a167abefe08e7595965292"}}, {"rule": 2, "type": "equivalent", "target": "dddc2d6546be8c5833b80708f1611577", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7d9b36e0f42eb3c117d02fb4d1a66413944410df78a167abefe08e7595965292"}}], "version": "9.5.14", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "dddc2d6546be8c5833b80708f1611577", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Fix INSERT ... ON CONFLICT UPDATE through a view that isn't just SELECT * FROM ...", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7d9b36e0f42eb3c117d02fb4d1a66413944410df78a167abefe08e7595965292"}, "url": "/docs/compare/?release=10.5#10.5-3e760d0542f92c95", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "da2ec324c1f899bc08a54ad2a1a57106", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Fix INSERT ... ON CONFLICT UPDATE through a view that isn't just SELECT * FROM ...", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7d9b36e0f42eb3c117d02fb4d1a66413944410df78a167abefe08e7595965292"}, "url": "/docs/compare/?release=9.6.10#9.6.10-3e760d0542f92c95", "source_url": "/docs/release/9.6.10/#AEN134332"}]}, {"id": "9.5.14-33418b4438512d6e", "cves": [], "html": "Ensure that updates to the relfrozenxid and relminmxid values for \"nailed\" system catalogs are processed in a timely fashion (Andres Freund)
\nOveroptimistic caching rules could prevent these updates from being seen by other sessions, leading to spurious errors and/or data corruption. The problem was significantly worse for shared catalogs, such as pg_authid, because the stale cache data could persist into new sessions as well as existing ones.
", "text": "Ensure that updates to the relfrozenxid and relminmxid values for \"nailed\" system catalogs are processed in a timely fashion (Andres Freund) Overoptimistic caching rules could prevent these updates from being seen by other sessions, leading to spurious errors and/or data corruption. The problem was significantly worse for shared catalogs, such as pg_authid, because the stale cache data could persist into new sessions as well as existing ones.", "title": "Ensure that updates to the relfrozenxid and relminmxid values for \"nailed\" system catalogs are processed in a timely fashion", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "5df22cebe93f8adb0804d594314a5fc8e1a7916714b60eea5dcc86a2abe7e9a4", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ensure that updates to the relfrozenxid and relminmxid values for nailed system catalogs are processed in a timely fashion (Andres Freund) Overoptimistic caching rules could prevent these updates from being seen by other sessions, leading to spurious errors and/or data corruption. The problem was significantly worse for shared catalogs, such as pg_authid, because the stale cache data could persist into new sessions as well as existing ones.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/003", "db_id": "d2ddc8d0e0d59d6e8ddf83d17dabea01", "patch_ids": [], "statement_hash": "0f40973bdecf4f197c463d71b2426f583be46d71d146da06cbab774bfe103e8d", "relations": [{"rule": 2, "type": "equivalent", "target": "32daf880b018ef0efc03b63f5bfad99d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f40973bdecf4f197c463d71b2426f583be46d71d146da06cbab774bfe103e8d"}}, {"rule": 2, "type": "equivalent", "target": "6b1508337c26fcb930a902e99a3573cf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f40973bdecf4f197c463d71b2426f583be46d71d146da06cbab774bfe103e8d"}}, {"rule": 2, "type": "equivalent", "target": "9ed27a4374d255ff38dff43efcbf92e6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f40973bdecf4f197c463d71b2426f583be46d71d146da06cbab774bfe103e8d"}}, {"rule": 2, "type": "equivalent", "target": "fe02cfd82dcb3eb66cd294a2d93301ba", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f40973bdecf4f197c463d71b2426f583be46d71d146da06cbab774bfe103e8d"}}], "version": "9.5.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "9ed27a4374d255ff38dff43efcbf92e6", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Ensure that updates to the relfrozenxid and relminmxid values for “nailed” system catalogs are processed in a timely fashion", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f40973bdecf4f197c463d71b2426f583be46d71d146da06cbab774bfe103e8d"}, "url": "/docs/compare/?release=10.5#10.5-50bb2c3cc0d92808", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "fe02cfd82dcb3eb66cd294a2d93301ba", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Ensure that updates to the relfrozenxid and relminmxid values for \"nailed\" system catalogs are processed in a timely fashion", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f40973bdecf4f197c463d71b2426f583be46d71d146da06cbab774bfe103e8d"}, "url": "/docs/compare/?release=9.6.10#9.6.10-33418b4438512d6e", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "32daf880b018ef0efc03b63f5bfad99d", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Ensure that updates to the relfrozenxid and relminmxid values for \"nailed\" system catalogs are processed in a timely fashion", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f40973bdecf4f197c463d71b2426f583be46d71d146da06cbab774bfe103e8d"}, "url": "/docs/compare/?release=9.4.19#9.4.19-33418b4438512d6e", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "6b1508337c26fcb930a902e99a3573cf", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Ensure that updates to the relfrozenxid and relminmxid values for \"nailed\" system catalogs are processed in a timely fashion", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f40973bdecf4f197c463d71b2426f583be46d71d146da06cbab774bfe103e8d"}, "url": "/docs/compare/?release=9.3.24#9.3.24-33418b4438512d6e", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-831b46110b10d7d0", "cves": [], "html": "Fix case where a freshly-promoted standby crashes before having completed its first post-recovery checkpoint (Michael Paquier, Kyotaro Horiguchi, Pavan Deolasee, Álvaro Herrera)
\nThis led to a situation where the server did not think it had reached a consistent database state during subsequent WAL replay, preventing restart.
", "text": "Fix case where a freshly-promoted standby crashes before having completed its first post-recovery checkpoint (Michael Paquier, Kyotaro Horiguchi, Pavan Deolasee, Álvaro Herrera) This led to a situation where the server did not think it had reached a consistent database state during subsequent WAL replay, preventing restart.", "title": "Fix case where a freshly-promoted standby crashes before having completed its first post-recovery checkpoint", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "fa7e8f5cc32174e46d7732bce494795003f464d53fc5b58fa5ba8db86d943b04", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix case where a freshly-promoted standby crashes before having completed its first post-recovery checkpoint (Michael Paquier, Kyotaro Horiguchi, Pavan Deolasee, Álvaro Herrera) This led to a situation where the server did not think it had reached a consistent database state during subsequent WAL replay, preventing restart.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/004", "db_id": "acd9e84bf9a88ffb7b980a511398871b", "patch_ids": [], "statement_hash": "e91754c6d4978576f71e18ac30bce445c478ff427f8ce632dc205836fb50274f", "relations": [{"rule": 2, "type": "equivalent", "target": "2f3cc96e9aaf64a7e90d7c9fdd39164e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e91754c6d4978576f71e18ac30bce445c478ff427f8ce632dc205836fb50274f"}}, {"rule": 2, "type": "equivalent", "target": "7895599dd794125ea13a3eeb6c7a5ff6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e91754c6d4978576f71e18ac30bce445c478ff427f8ce632dc205836fb50274f"}}, {"rule": 2, "type": "equivalent", "target": "8562f359facbd2be633dfe6e52bbd296", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e91754c6d4978576f71e18ac30bce445c478ff427f8ce632dc205836fb50274f"}}, {"rule": 2, "type": "equivalent", "target": "e9197d5b5d6664ac74d0054e089d2a74", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e91754c6d4978576f71e18ac30bce445c478ff427f8ce632dc205836fb50274f"}}], "version": "9.5.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2f3cc96e9aaf64a7e90d7c9fdd39164e", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Fix case where a freshly-promoted standby crashes before having completed its first post-recovery checkpoint", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e91754c6d4978576f71e18ac30bce445c478ff427f8ce632dc205836fb50274f"}, "url": "/docs/compare/?release=10.5#10.5-831b46110b10d7d0", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "7895599dd794125ea13a3eeb6c7a5ff6", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Fix case where a freshly-promoted standby crashes before having completed its first post-recovery checkpoint", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e91754c6d4978576f71e18ac30bce445c478ff427f8ce632dc205836fb50274f"}, "url": "/docs/compare/?release=9.6.10#9.6.10-831b46110b10d7d0", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "8562f359facbd2be633dfe6e52bbd296", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Fix case where a freshly-promoted standby crashes before having completed its first post-recovery checkpoint", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e91754c6d4978576f71e18ac30bce445c478ff427f8ce632dc205836fb50274f"}, "url": "/docs/compare/?release=9.4.19#9.4.19-831b46110b10d7d0", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "e9197d5b5d6664ac74d0054e089d2a74", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Fix case where a freshly-promoted standby crashes before having completed its first post-recovery checkpoint", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e91754c6d4978576f71e18ac30bce445c478ff427f8ce632dc205836fb50274f"}, "url": "/docs/compare/?release=9.3.24#9.3.24-831b46110b10d7d0", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-1b0d77f32b68d53f", "cves": [], "html": "Avoid emitting a bogus WAL record when recycling an all-zero btree page (Amit Kapila)
\nThis mistake has been seen to cause assertion failures, and potentially it could result in unnecessary query cancellations on hot standby servers.
", "text": "Avoid emitting a bogus WAL record when recycling an all-zero btree page (Amit Kapila) This mistake has been seen to cause assertion failures, and potentially it could result in unnecessary query cancellations on hot standby servers.", "title": "Avoid emitting a bogus WAL record when recycling an all-zero btree page", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "1f261ca5298c0d468e5f8e100685ee862f4ef6c3d4616b53a22ea2d517e40f7c", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid emitting a bogus WAL record when recycling an all-zero btree page (Amit Kapila) This mistake has been seen to cause assertion failures, and potentially it could result in unnecessary query cancellations on hot standby servers.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/005", "db_id": "cf21645a6589d145ccf19e984286e3f7", "patch_ids": [], "statement_hash": "068a7948ba1f16ddd35a5f5cbef739818b1ffa464aa0ba3050f488c0171e180f", "relations": [{"rule": 2, "type": "equivalent", "target": "03132998b632c02d15256b84330ab60a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "068a7948ba1f16ddd35a5f5cbef739818b1ffa464aa0ba3050f488c0171e180f"}}, {"rule": 2, "type": "equivalent", "target": "2dd037d083b0c3bfe29f7cfbbd4c5611", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "068a7948ba1f16ddd35a5f5cbef739818b1ffa464aa0ba3050f488c0171e180f"}}, {"rule": 2, "type": "equivalent", "target": "67b50d90cd1cc74144791acbcf155f1c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "068a7948ba1f16ddd35a5f5cbef739818b1ffa464aa0ba3050f488c0171e180f"}}, {"rule": 2, "type": "equivalent", "target": "a74fce06026a164587c89b59b42606e8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "068a7948ba1f16ddd35a5f5cbef739818b1ffa464aa0ba3050f488c0171e180f"}}], "version": "9.5.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "67b50d90cd1cc74144791acbcf155f1c", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Avoid emitting a bogus WAL record when recycling an all-zero btree page", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "068a7948ba1f16ddd35a5f5cbef739818b1ffa464aa0ba3050f488c0171e180f"}, "url": "/docs/compare/?release=10.5#10.5-1b0d77f32b68d53f", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "03132998b632c02d15256b84330ab60a", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Avoid emitting a bogus WAL record when recycling an all-zero btree page", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "068a7948ba1f16ddd35a5f5cbef739818b1ffa464aa0ba3050f488c0171e180f"}, "url": "/docs/compare/?release=9.6.10#9.6.10-1b0d77f32b68d53f", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "a74fce06026a164587c89b59b42606e8", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Avoid emitting a bogus WAL record when recycling an all-zero btree page", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "068a7948ba1f16ddd35a5f5cbef739818b1ffa464aa0ba3050f488c0171e180f"}, "url": "/docs/compare/?release=9.4.19#9.4.19-1b0d77f32b68d53f", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "2dd037d083b0c3bfe29f7cfbbd4c5611", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Avoid emitting a bogus WAL record when recycling an all-zero btree page", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "068a7948ba1f16ddd35a5f5cbef739818b1ffa464aa0ba3050f488c0171e180f"}, "url": "/docs/compare/?release=9.3.24#9.3.24-1b0d77f32b68d53f", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-a643f224de3a9991", "cves": [], "html": "During WAL replay, guard against corrupted record lengths exceeding 1GB (Michael Paquier)
\nTreat such a case as corrupt data. Previously, the code would try to allocate space and get a hard error, making recovery impossible.
", "text": "During WAL replay, guard against corrupted record lengths exceeding 1GB (Michael Paquier) Treat such a case as corrupt data. Previously, the code would try to allocate space and get a hard error, making recovery impossible.", "title": "During WAL replay, guard against corrupted record lengths exceeding 1GB", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "9dddf4f3e6d1ca47fd0bf7f23e5304de5c5dd7b1c82e1f3966a16a1b4d7fab2e", "section_path": ["Changes"], "commit_groups": [], "identity_text": "During WAL replay, guard against corrupted record lengths exceeding 1GB (Michael Paquier) Treat such a case as corrupt data. Previously, the code would try to allocate space and get a hard error, making recovery impossible.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/006", "db_id": "41027e0df645771c19c9446f3f1b545c", "patch_ids": [], "statement_hash": "6c009cbd40e60a45c40d556686aa558e12304cae5d4566922e19206197acf9e9", "relations": [{"rule": 2, "type": "equivalent", "target": "4b605aaca4274cb27916ae8041d62fed", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6c009cbd40e60a45c40d556686aa558e12304cae5d4566922e19206197acf9e9"}}, {"rule": 2, "type": "equivalent", "target": "ba3d8fbe57a34976503d5f20aa9dcdbf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6c009cbd40e60a45c40d556686aa558e12304cae5d4566922e19206197acf9e9"}}], "version": "9.5.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "ba3d8fbe57a34976503d5f20aa9dcdbf", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "During WAL replay, guard against corrupted record lengths exceeding 1GB", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6c009cbd40e60a45c40d556686aa558e12304cae5d4566922e19206197acf9e9"}, "url": "/docs/compare/?release=10.5#10.5-a643f224de3a9991", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "4b605aaca4274cb27916ae8041d62fed", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "During WAL replay, guard against corrupted record lengths exceeding 1GB", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6c009cbd40e60a45c40d556686aa558e12304cae5d4566922e19206197acf9e9"}, "url": "/docs/compare/?release=9.6.10#9.6.10-a643f224de3a9991", "source_url": "/docs/release/9.6.10/#AEN134332"}]}, {"id": "9.5.14-de3936c7374e3e58", "cves": [], "html": "When ending recovery, delay writing the timeline history file as long as possible (Heikki Linnakangas)
\nThis avoids some situations where a failure during recovery cleanup (such as a problem with a two-phase state file) led to inconsistent timeline state on-disk.
", "text": "When ending recovery, delay writing the timeline history file as long as possible (Heikki Linnakangas) This avoids some situations where a failure during recovery cleanup (such as a problem with a two-phase state file) led to inconsistent timeline state on-disk.", "title": "When ending recovery, delay writing the timeline history file as long as possible", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "e4ad702497dcfb78409efe66b9575b0ac6b2759104ab9b963bb8b213e4a6c6ab", "section_path": ["Changes"], "commit_groups": [], "identity_text": "When ending recovery, delay writing the timeline history file as long as possible (Heikki Linnakangas) This avoids some situations where a failure during recovery cleanup (such as a problem with a two-phase state file) led to inconsistent timeline state on-disk.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/007", "db_id": "03b56355c5d56825a10f6299f1501ca8", "patch_ids": [], "statement_hash": "0ec483036b10caf65625991b017971fd3dc13e75e76076c919a35938a47426c6", "relations": [{"rule": 2, "type": "equivalent", "target": "5ddea9e723cf34b46c793f3b04bef3f8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0ec483036b10caf65625991b017971fd3dc13e75e76076c919a35938a47426c6"}}, {"rule": 2, "type": "equivalent", "target": "f65d81dcd533494d65b6488dd9aa0008", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0ec483036b10caf65625991b017971fd3dc13e75e76076c919a35938a47426c6"}}], "version": "9.5.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "5ddea9e723cf34b46c793f3b04bef3f8", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "When ending recovery, delay writing the timeline history file as long as possible", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0ec483036b10caf65625991b017971fd3dc13e75e76076c919a35938a47426c6"}, "url": "/docs/compare/?release=10.5#10.5-de3936c7374e3e58", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "f65d81dcd533494d65b6488dd9aa0008", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "When ending recovery, delay writing the timeline history file as long as possible", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0ec483036b10caf65625991b017971fd3dc13e75e76076c919a35938a47426c6"}, "url": "/docs/compare/?release=9.6.10#9.6.10-de3936c7374e3e58", "source_url": "/docs/release/9.6.10/#AEN134332"}]}, {"id": "9.5.14-a2f995e16ca3e18e", "cves": [], "html": "Improve performance of WAL replay for transactions that drop many relations (Fujii Masao)
\nThis change reduces the number of times that shared buffers are scanned, so that it is of most benefit when that setting is large.
", "text": "Improve performance of WAL replay for transactions that drop many relations (Fujii Masao) This change reduces the number of times that shared buffers are scanned, so that it is of most benefit when that setting is large.", "title": "Improve performance of WAL replay for transactions that drop many relations", "commits": [], "section": "Changes", "category": "performance", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "7cc920f9076e43b10d60cc01c4b21850edbb0ed4aeb95ff3f54a6585449d78b1", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Improve performance of WAL replay for transactions that drop many relations (Fujii Masao) This change reduces the number of times that shared buffers are scanned, so that it is of most benefit when that setting is large.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/008", "db_id": "87e029f82b47117920a10995449b3418", "patch_ids": [], "statement_hash": "dae0982858056281ddd784b5db4d4042731d4c1115c7c137a61454406027b381", "relations": [{"rule": 2, "type": "equivalent", "target": "0a7c3a5fd7a055838a2d503121a355db", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dae0982858056281ddd784b5db4d4042731d4c1115c7c137a61454406027b381"}}, {"rule": 2, "type": "equivalent", "target": "152828386a677615583bbe556b597df0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dae0982858056281ddd784b5db4d4042731d4c1115c7c137a61454406027b381"}}, {"rule": 2, "type": "equivalent", "target": "442bd49ac88e1927ac19e63a17c88a11", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dae0982858056281ddd784b5db4d4042731d4c1115c7c137a61454406027b381"}}, {"rule": 2, "type": "equivalent", "target": "53d49ed990ec4935f62ad367fb4e998e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dae0982858056281ddd784b5db4d4042731d4c1115c7c137a61454406027b381"}}], "version": "9.5.14", "category_label": "Performance", "also_in": [], "variants": [], "related_changes": [{"db_id": "442bd49ac88e1927ac19e63a17c88a11", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Improve performance of WAL replay for transactions that drop many relations", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dae0982858056281ddd784b5db4d4042731d4c1115c7c137a61454406027b381"}, "url": "/docs/compare/?release=10.5#10.5-a2f995e16ca3e18e", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "0a7c3a5fd7a055838a2d503121a355db", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Improve performance of WAL replay for transactions that drop many relations", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dae0982858056281ddd784b5db4d4042731d4c1115c7c137a61454406027b381"}, "url": "/docs/compare/?release=9.6.10#9.6.10-a2f995e16ca3e18e", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "152828386a677615583bbe556b597df0", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Improve performance of WAL replay for transactions that drop many relations", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dae0982858056281ddd784b5db4d4042731d4c1115c7c137a61454406027b381"}, "url": "/docs/compare/?release=9.4.19#9.4.19-a2f995e16ca3e18e", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "53d49ed990ec4935f62ad367fb4e998e", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Improve performance of WAL replay for transactions that drop many relations", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dae0982858056281ddd784b5db4d4042731d4c1115c7c137a61454406027b381"}, "url": "/docs/compare/?release=9.3.24#9.3.24-a2f995e16ca3e18e", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-d18f797d6c4aca06", "cves": [], "html": "Improve performance of lock releasing in standby server WAL replay (Thomas Munro)
", "text": "Improve performance of lock releasing in standby server WAL replay (Thomas Munro)", "title": "Improve performance of lock releasing in standby server WAL replay", "commits": [], "section": "Changes", "category": "performance", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "2f9e243751b8ba8068004f0c0889fb83235c64bec6a25f3891a4f1ca722a18d0", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Improve performance of lock releasing in standby server WAL replay (Thomas Munro)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/009", "db_id": "8ba3323e8cfbe4ae8c3cf944b89bd142", "patch_ids": [], "statement_hash": "c5e832fe5b3955e163fe6a4881dd2299279821cdfbd8c26907079cafc05875a1", "relations": [{"rule": 2, "type": "equivalent", "target": "10e8bd8bbcb3a0dc654368a93dc0266c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5e832fe5b3955e163fe6a4881dd2299279821cdfbd8c26907079cafc05875a1"}}, {"rule": 2, "type": "equivalent", "target": "198f89cf0c74e8275f1b5659a253422e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5e832fe5b3955e163fe6a4881dd2299279821cdfbd8c26907079cafc05875a1"}}, {"rule": 2, "type": "equivalent", "target": "7331471ab70e53cf23524471f59d35f3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5e832fe5b3955e163fe6a4881dd2299279821cdfbd8c26907079cafc05875a1"}}, {"rule": 2, "type": "equivalent", "target": "b632ab0b0a3e766425ff17921f9d6048", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5e832fe5b3955e163fe6a4881dd2299279821cdfbd8c26907079cafc05875a1"}}], "version": "9.5.14", "category_label": "Performance", "also_in": [], "variants": [], "related_changes": [{"db_id": "7331471ab70e53cf23524471f59d35f3", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Improve performance of lock releasing in standby server WAL replay", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5e832fe5b3955e163fe6a4881dd2299279821cdfbd8c26907079cafc05875a1"}, "url": "/docs/compare/?release=10.5#10.5-d18f797d6c4aca06", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "198f89cf0c74e8275f1b5659a253422e", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Improve performance of lock releasing in standby server WAL replay", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5e832fe5b3955e163fe6a4881dd2299279821cdfbd8c26907079cafc05875a1"}, "url": "/docs/compare/?release=9.6.10#9.6.10-d18f797d6c4aca06", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "10e8bd8bbcb3a0dc654368a93dc0266c", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Improve performance of lock releasing in standby server WAL replay", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5e832fe5b3955e163fe6a4881dd2299279821cdfbd8c26907079cafc05875a1"}, "url": "/docs/compare/?release=9.4.19#9.4.19-d18f797d6c4aca06", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "b632ab0b0a3e766425ff17921f9d6048", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Improve performance of lock releasing in standby server WAL replay", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5e832fe5b3955e163fe6a4881dd2299279821cdfbd8c26907079cafc05875a1"}, "url": "/docs/compare/?release=9.3.24#9.3.24-d18f797d6c4aca06", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-28373a763daac3bd", "cves": [], "html": "Make logical WAL senders report streaming state correctly (Simon Riggs, Sawada Masahiko)
\nThe code previously mis-detected whether or not it had caught up with the upstream server.
", "text": "Make logical WAL senders report streaming state correctly (Simon Riggs, Sawada Masahiko) The code previously mis-detected whether or not it had caught up with the upstream server.", "title": "Make logical WAL senders report streaming state correctly", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "12beee5a891790873d268fe03a2a7d7a86a5650fd3c90e32dcea33ca7b84b071", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Make logical WAL senders report streaming state correctly (Simon Riggs, Sawada Masahiko) The code previously mis-detected whether or not it had caught up with the upstream server.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/010", "db_id": "ce0c374e27e67e4239351a562a480325", "patch_ids": [], "statement_hash": "4d77f60252a806f87315684495c6b6acef9bfb3745d23aaa92ad3200ef8f5a10", "relations": [{"rule": 2, "type": "equivalent", "target": "0024dddf8b0a2457e78f36aab16a9436", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4d77f60252a806f87315684495c6b6acef9bfb3745d23aaa92ad3200ef8f5a10"}}, {"rule": 2, "type": "equivalent", "target": "153b2bc4ecaec1233e1e5d5ae5e15de9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4d77f60252a806f87315684495c6b6acef9bfb3745d23aaa92ad3200ef8f5a10"}}, {"rule": 2, "type": "equivalent", "target": "63531a370ad0a7a51eb997fce1a8f295", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4d77f60252a806f87315684495c6b6acef9bfb3745d23aaa92ad3200ef8f5a10"}}], "version": "9.5.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "153b2bc4ecaec1233e1e5d5ae5e15de9", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Make logical WAL senders report streaming state correctly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4d77f60252a806f87315684495c6b6acef9bfb3745d23aaa92ad3200ef8f5a10"}, "url": "/docs/compare/?release=10.5#10.5-28373a763daac3bd", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "63531a370ad0a7a51eb997fce1a8f295", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Make logical WAL senders report streaming state correctly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4d77f60252a806f87315684495c6b6acef9bfb3745d23aaa92ad3200ef8f5a10"}, "url": "/docs/compare/?release=9.6.10#9.6.10-28373a763daac3bd", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "0024dddf8b0a2457e78f36aab16a9436", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Make logical WAL senders report streaming state correctly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4d77f60252a806f87315684495c6b6acef9bfb3745d23aaa92ad3200ef8f5a10"}, "url": "/docs/compare/?release=9.4.19#9.4.19-28373a763daac3bd", "source_url": "/docs/release/9.4.19/#AEN120815"}]}, {"id": "9.5.14-51d8fef3074d9e4a", "cves": [], "html": "Fix bugs in snapshot handling during logical decoding, allowing wrong decoding results in rare cases (Arseny Sher, Álvaro Herrera)
", "text": "Fix bugs in snapshot handling during logical decoding, allowing wrong decoding results in rare cases (Arseny Sher, Álvaro Herrera)", "title": "Fix bugs in snapshot handling during logical decoding, allowing wrong decoding results in rare cases", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "b7f0b5819259613fb23215bd6dc8f782dc0149974598072935318c62cca494e8", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix bugs in snapshot handling during logical decoding, allowing wrong decoding results in rare cases (Arseny Sher, Álvaro Herrera)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/011", "db_id": "747a23053f3fdc8513934045f4b8a8eb", "patch_ids": [], "statement_hash": "2d59a06961fcbfe2737d81b449e6ec66d6dd457093da06528417729be1ceae77", "relations": [{"rule": 2, "type": "equivalent", "target": "722dda8d255ed48f07a7f1102dc85540", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2d59a06961fcbfe2737d81b449e6ec66d6dd457093da06528417729be1ceae77"}}, {"rule": 2, "type": "equivalent", "target": "ba72487eca3d90a8965a8f78799d4a37", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2d59a06961fcbfe2737d81b449e6ec66d6dd457093da06528417729be1ceae77"}}, {"rule": 2, "type": "equivalent", "target": "ed39f60ba1d526a39605d75e09f29524", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2d59a06961fcbfe2737d81b449e6ec66d6dd457093da06528417729be1ceae77"}}], "version": "9.5.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "ed39f60ba1d526a39605d75e09f29524", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Fix bugs in snapshot handling during logical decoding, allowing wrong decoding results in rare cases", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2d59a06961fcbfe2737d81b449e6ec66d6dd457093da06528417729be1ceae77"}, "url": "/docs/compare/?release=10.5#10.5-51d8fef3074d9e4a", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "722dda8d255ed48f07a7f1102dc85540", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Fix bugs in snapshot handling during logical decoding, allowing wrong decoding results in rare cases", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2d59a06961fcbfe2737d81b449e6ec66d6dd457093da06528417729be1ceae77"}, "url": "/docs/compare/?release=9.6.10#9.6.10-51d8fef3074d9e4a", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "ba72487eca3d90a8965a8f78799d4a37", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Fix bugs in snapshot handling during logical decoding, allowing wrong decoding results in rare cases", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2d59a06961fcbfe2737d81b449e6ec66d6dd457093da06528417729be1ceae77"}, "url": "/docs/compare/?release=9.4.19#9.4.19-51d8fef3074d9e4a", "source_url": "/docs/release/9.4.19/#AEN120815"}]}, {"id": "9.5.14-2fe3092f80287884", "cves": [], "html": "Ensure a table's cached index list is correctly rebuilt after an index creation fails partway through (Peter Geoghegan)
\nPreviously, the failed index's OID could remain in the list, causing problems later in the same session.
", "text": "Ensure a table's cached index list is correctly rebuilt after an index creation fails partway through (Peter Geoghegan) Previously, the failed index's OID could remain in the list, causing problems later in the same session.", "title": "Ensure a table's cached index list is correctly rebuilt after an index creation fails partway through", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "51ef6609147a62c994f70e0a2c09017f69a5d6edafc2269070a47932b4e0f11c", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ensure a table's cached index list is correctly rebuilt after an index creation fails partway through (Peter Geoghegan) Previously, the failed index's OID could remain in the list, causing problems later in the same session.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/012", "db_id": "26e04fcb7e6cede2081c220dd2bec55f", "patch_ids": [], "statement_hash": "cd62bf70f8ea7367a437e9c84dd8160f5d842a9309758b8eb517f493440f6800", "relations": [{"rule": 2, "type": "equivalent", "target": "186e31d2cfd35855b738f0e59e37bc8a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cd62bf70f8ea7367a437e9c84dd8160f5d842a9309758b8eb517f493440f6800"}}, {"rule": 2, "type": "equivalent", "target": "323782b89f6740151049a909f0559a13", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cd62bf70f8ea7367a437e9c84dd8160f5d842a9309758b8eb517f493440f6800"}}, {"rule": 2, "type": "equivalent", "target": "58f069360214dd9f86e14701bbefcbb5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cd62bf70f8ea7367a437e9c84dd8160f5d842a9309758b8eb517f493440f6800"}}, {"rule": 2, "type": "equivalent", "target": "9816837056d8933773918134c3de8eba", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cd62bf70f8ea7367a437e9c84dd8160f5d842a9309758b8eb517f493440f6800"}}], "version": "9.5.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "58f069360214dd9f86e14701bbefcbb5", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Ensure a table's cached index list is correctly rebuilt after an index creation fails partway through", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cd62bf70f8ea7367a437e9c84dd8160f5d842a9309758b8eb517f493440f6800"}, "url": "/docs/compare/?release=10.5#10.5-2fe3092f80287884", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "186e31d2cfd35855b738f0e59e37bc8a", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Ensure a table's cached index list is correctly rebuilt after an index creation fails partway through", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cd62bf70f8ea7367a437e9c84dd8160f5d842a9309758b8eb517f493440f6800"}, "url": "/docs/compare/?release=9.6.10#9.6.10-2fe3092f80287884", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "9816837056d8933773918134c3de8eba", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Ensure a table's cached index list is correctly rebuilt after an index creation fails partway through", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cd62bf70f8ea7367a437e9c84dd8160f5d842a9309758b8eb517f493440f6800"}, "url": "/docs/compare/?release=9.4.19#9.4.19-2fe3092f80287884", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "323782b89f6740151049a909f0559a13", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Ensure a table's cached index list is correctly rebuilt after an index creation fails partway through", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cd62bf70f8ea7367a437e9c84dd8160f5d842a9309758b8eb517f493440f6800"}, "url": "/docs/compare/?release=9.3.24#9.3.24-2fe3092f80287884", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-24d6e6dd0704b31c", "cves": [], "html": "Fix mishandling of empty uncompressed posting list pages in GIN indexes (Sivasubramanian Ramasubramanian, Alexander Korotkov)
\nThis could result in an assertion failure after pg_upgrade of a pre-9.4 GIN index (9.4 and later will not create such pages).
", "text": "Fix mishandling of empty uncompressed posting list pages in GIN indexes (Sivasubramanian Ramasubramanian, Alexander Korotkov) This could result in an assertion failure after pg_upgrade of a pre-9.4 GIN index (9.4 and later will not create such pages).", "title": "Fix mishandling of empty uncompressed posting list pages in GIN indexes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "af1a4606e0baea42e268af5e6f13f7235e310d56ef2676adf64a074046021bda", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix mishandling of empty uncompressed posting list pages in GIN indexes (Sivasubramanian Ramasubramanian, Alexander Korotkov) This could result in an assertion failure after pg_upgrade of a pre-9.4 GIN index (9.4 and later will not create such pages).", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/013", "db_id": "8f189bc48d07dd9c38455eb63e078f9a", "patch_ids": [], "statement_hash": "b8a2167e84b84133e3ca3d47c7884079f82f923701fd5212458ebf05df7a6a90", "relations": [{"rule": 2, "type": "equivalent", "target": "341f4d27388876640cba6c8724119e4b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8a2167e84b84133e3ca3d47c7884079f82f923701fd5212458ebf05df7a6a90"}}, {"rule": 2, "type": "equivalent", "target": "5c9d8f690407ff5c825e0556be5cbb4d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8a2167e84b84133e3ca3d47c7884079f82f923701fd5212458ebf05df7a6a90"}}, {"rule": 2, "type": "equivalent", "target": "a6b4d547c3a7317a9933e598d026a0af", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8a2167e84b84133e3ca3d47c7884079f82f923701fd5212458ebf05df7a6a90"}}], "version": "9.5.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "a6b4d547c3a7317a9933e598d026a0af", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Fix mishandling of empty uncompressed posting list pages in GIN indexes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8a2167e84b84133e3ca3d47c7884079f82f923701fd5212458ebf05df7a6a90"}, "url": "/docs/compare/?release=10.5#10.5-24d6e6dd0704b31c", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "341f4d27388876640cba6c8724119e4b", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Fix mishandling of empty uncompressed posting list pages in GIN indexes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8a2167e84b84133e3ca3d47c7884079f82f923701fd5212458ebf05df7a6a90"}, "url": "/docs/compare/?release=9.6.10#9.6.10-24d6e6dd0704b31c", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "5c9d8f690407ff5c825e0556be5cbb4d", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Fix mishandling of empty uncompressed posting list pages in GIN indexes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8a2167e84b84133e3ca3d47c7884079f82f923701fd5212458ebf05df7a6a90"}, "url": "/docs/compare/?release=9.4.19#9.4.19-24d6e6dd0704b31c", "source_url": "/docs/release/9.4.19/#AEN120815"}]}, {"id": "9.5.14-fa6a7fa8981d11db", "cves": [], "html": "Ensure that VACUUM will respond to signals within btree page deletion loops (Andres Freund)
\nCorrupted btree indexes could result in an infinite loop here, and that previously wasn't interruptible without forcing a crash.
", "text": "Ensure that VACUUM will respond to signals within btree page deletion loops (Andres Freund) Corrupted btree indexes could result in an infinite loop here, and that previously wasn't interruptible without forcing a crash.", "title": "Ensure that VACUUM will respond to signals within btree page deletion loops", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "698fed7a82db1d2c3f06010579547106902cf451e245b911860d019b4dfff38a", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ensure that VACUUM will respond to signals within btree page deletion loops (Andres Freund) Corrupted btree indexes could result in an infinite loop here, and that previously wasn't interruptible without forcing a crash.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/014", "db_id": "e77cd5b3cc2485698c5eff5d1d373f8d", "patch_ids": [], "statement_hash": "6742ae11a896e2fd92be7b1babe613d1036f84f4921911000e38736d395a8e6c", "relations": [{"rule": 2, "type": "equivalent", "target": "4721267ab5f350035de8fbf5ef55ea6b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6742ae11a896e2fd92be7b1babe613d1036f84f4921911000e38736d395a8e6c"}}, {"rule": 2, "type": "equivalent", "target": "9daba184165b978b5048851d3664d90f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6742ae11a896e2fd92be7b1babe613d1036f84f4921911000e38736d395a8e6c"}}, {"rule": 2, "type": "equivalent", "target": "a56694ab96dd635cd3ac4625fff21988", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6742ae11a896e2fd92be7b1babe613d1036f84f4921911000e38736d395a8e6c"}}], "version": "9.5.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "9daba184165b978b5048851d3664d90f", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Ensure that VACUUM will respond to signals within btree page deletion loops", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6742ae11a896e2fd92be7b1babe613d1036f84f4921911000e38736d395a8e6c"}, "url": "/docs/compare/?release=10.5#10.5-fa6a7fa8981d11db", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "a56694ab96dd635cd3ac4625fff21988", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Ensure that VACUUM will respond to signals within btree page deletion loops", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6742ae11a896e2fd92be7b1babe613d1036f84f4921911000e38736d395a8e6c"}, "url": "/docs/compare/?release=9.6.10#9.6.10-fa6a7fa8981d11db", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "4721267ab5f350035de8fbf5ef55ea6b", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Ensure that VACUUM will respond to signals within btree page deletion loops", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6742ae11a896e2fd92be7b1babe613d1036f84f4921911000e38736d395a8e6c"}, "url": "/docs/compare/?release=9.4.19#9.4.19-fa6a7fa8981d11db", "source_url": "/docs/release/9.4.19/#AEN120815"}]}, {"id": "9.5.14-e5ba9e9e10354977", "cves": [], "html": "Fix misoptimization of equivalence classes involving composite-type columns (Tom Lane)
\nThis resulted in failure to recognize that an index on a composite column could provide the sort order needed for a mergejoin on that column.
", "text": "Fix misoptimization of equivalence classes involving composite-type columns (Tom Lane) This resulted in failure to recognize that an index on a composite column could provide the sort order needed for a mergejoin on that column.", "title": "Fix misoptimization of equivalence classes involving composite-type columns", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "5f34ec56743e8e34e885397e92591b5f7abcf68d61c46db0ac49623f23afa9a4", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix misoptimization of equivalence classes involving composite-type columns (Tom Lane) This resulted in failure to recognize that an index on a composite column could provide the sort order needed for a mergejoin on that column.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/015", "db_id": "a9b35e1d8e5e3420204fe78b358c9962", "patch_ids": [], "statement_hash": "f614996577b318997d1ad826e475da2f633c108f544ab5dfc793c89467fd4beb", "relations": [{"rule": 2, "type": "equivalent", "target": "182bf1369f6e672ae01de81e926e566b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f614996577b318997d1ad826e475da2f633c108f544ab5dfc793c89467fd4beb"}}, {"rule": 2, "type": "equivalent", "target": "1a738a8866da02b729b2a8833232d01b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f614996577b318997d1ad826e475da2f633c108f544ab5dfc793c89467fd4beb"}}, {"rule": 2, "type": "equivalent", "target": "4c8532a87fe864b0d7dd80115d45ded5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f614996577b318997d1ad826e475da2f633c108f544ab5dfc793c89467fd4beb"}}, {"rule": 2, "type": "equivalent", "target": "52cef43a8c73048f335ccbec3a8eaa20", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f614996577b318997d1ad826e475da2f633c108f544ab5dfc793c89467fd4beb"}}], "version": "9.5.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4c8532a87fe864b0d7dd80115d45ded5", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Fix misoptimization of equivalence classes involving composite-type columns", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f614996577b318997d1ad826e475da2f633c108f544ab5dfc793c89467fd4beb"}, "url": "/docs/compare/?release=10.5#10.5-e5ba9e9e10354977", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "52cef43a8c73048f335ccbec3a8eaa20", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Fix misoptimization of equivalence classes involving composite-type columns", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f614996577b318997d1ad826e475da2f633c108f544ab5dfc793c89467fd4beb"}, "url": "/docs/compare/?release=9.6.10#9.6.10-e5ba9e9e10354977", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "1a738a8866da02b729b2a8833232d01b", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Fix misoptimization of equivalence classes involving composite-type columns", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f614996577b318997d1ad826e475da2f633c108f544ab5dfc793c89467fd4beb"}, "url": "/docs/compare/?release=9.4.19#9.4.19-e5ba9e9e10354977", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "182bf1369f6e672ae01de81e926e566b", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Fix misoptimization of equivalence classes involving composite-type columns", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f614996577b318997d1ad826e475da2f633c108f544ab5dfc793c89467fd4beb"}, "url": "/docs/compare/?release=9.3.24#9.3.24-e5ba9e9e10354977", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-50e4cea141e4250f", "cves": [], "html": "Fix SQL-standard FETCH FIRST syntax to allow parameters ($n), as the standard expects (Andrew Gierth)
", "text": "Fix SQL-standard FETCH FIRST syntax to allow parameters ($n), as the standard expects (Andrew Gierth)", "title": "Fix SQL-standard FETCH FIRST syntax to allow parameters ($n), as the standard expects", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "d3b59d512ff8582c1f5997fe231357932b873177fe9f6f4d1d353476849c4043", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix SQL-standard FETCH FIRST syntax to allow parameters ($n), as the standard expects (Andrew Gierth)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/016", "db_id": "23762746b800611931fc7c4cd4b33449", "patch_ids": [], "statement_hash": "461ce3f06fb3ad3bfe5901fc90283844df681aee22c74abd9dd1b8dd8f30c649", "relations": [{"rule": 2, "type": "equivalent", "target": "1968060fb84d59b197c126ae941b4b3b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "461ce3f06fb3ad3bfe5901fc90283844df681aee22c74abd9dd1b8dd8f30c649"}}, {"rule": 2, "type": "equivalent", "target": "24bdb88062ca581f68e29dbcbd38c755", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "461ce3f06fb3ad3bfe5901fc90283844df681aee22c74abd9dd1b8dd8f30c649"}}, {"rule": 2, "type": "equivalent", "target": "490c01ca4c089acfc35b01915796225c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "461ce3f06fb3ad3bfe5901fc90283844df681aee22c74abd9dd1b8dd8f30c649"}}, {"rule": 2, "type": "equivalent", "target": "ffee22d09074ad0235653a33dd93df64", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "461ce3f06fb3ad3bfe5901fc90283844df681aee22c74abd9dd1b8dd8f30c649"}}], "version": "9.5.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "ffee22d09074ad0235653a33dd93df64", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Fix SQL-standard FETCH FIRST syntax to allow parameters ($n), as the standard expects", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "461ce3f06fb3ad3bfe5901fc90283844df681aee22c74abd9dd1b8dd8f30c649"}, "url": "/docs/compare/?release=10.5#10.5-50e4cea141e4250f", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "1968060fb84d59b197c126ae941b4b3b", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Fix SQL-standard FETCH FIRST syntax to allow parameters ($n), as the standard expects", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "461ce3f06fb3ad3bfe5901fc90283844df681aee22c74abd9dd1b8dd8f30c649"}, "url": "/docs/compare/?release=9.6.10#9.6.10-50e4cea141e4250f", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "24bdb88062ca581f68e29dbcbd38c755", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Fix SQL-standard FETCH FIRST syntax to allow parameters ($n), as the standard expects", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "461ce3f06fb3ad3bfe5901fc90283844df681aee22c74abd9dd1b8dd8f30c649"}, "url": "/docs/compare/?release=9.4.19#9.4.19-50e4cea141e4250f", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "490c01ca4c089acfc35b01915796225c", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Fix SQL-standard FETCH FIRST syntax to allow parameters ($n), as the standard expects", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "461ce3f06fb3ad3bfe5901fc90283844df681aee22c74abd9dd1b8dd8f30c649"}, "url": "/docs/compare/?release=9.3.24#9.3.24-50e4cea141e4250f", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-8931734a8b7b655f", "cves": [], "html": "Fix failure to schema-qualify some object names in getObjectDescription output (Kyotaro Horiguchi, Tom Lane)
Names of collations, conversions, and text search objects were not schema-qualified when they should be.
", "text": "Fix failure to schema-qualify some object names in getObjectDescription output (Kyotaro Horiguchi, Tom Lane) Names of collations, conversions, and text search objects were not schema-qualified when they should be.", "title": "Fix failure to schema-qualify some object names in getObjectDescription output", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "b9911075355dcd2ffdea6e474ee372351f1ba42d3a512a98d395bb314b5925ee", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix failure to schema-qualify some object names in getObjectDescription output (Kyotaro Horiguchi, Tom Lane) Names of collations, conversions, and text search objects were not schema-qualified when they should be.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/017", "db_id": "27658c43fd30fb6c922c98c6baaaac7b", "patch_ids": [], "statement_hash": "07ff116e1bc884f9d2f8cb5b05fb55fda509f7d7394a3261972c6bcfb13289ff", "relations": [{"rule": 2, "type": "equivalent", "target": "2b4777993e8637549d65833b7c3007bc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "07ff116e1bc884f9d2f8cb5b05fb55fda509f7d7394a3261972c6bcfb13289ff"}}, {"rule": 2, "type": "equivalent", "target": "5e644a697564bfbaaa39703930a024bc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "07ff116e1bc884f9d2f8cb5b05fb55fda509f7d7394a3261972c6bcfb13289ff"}}, {"rule": 2, "type": "equivalent", "target": "963261e14d052337e5dc2b4e88cbc5e0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "07ff116e1bc884f9d2f8cb5b05fb55fda509f7d7394a3261972c6bcfb13289ff"}}], "version": "9.5.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "963261e14d052337e5dc2b4e88cbc5e0", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Fix failure to schema-qualify some object names in getObjectDescription output", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "07ff116e1bc884f9d2f8cb5b05fb55fda509f7d7394a3261972c6bcfb13289ff"}, "url": "/docs/compare/?release=9.6.10#9.6.10-8931734a8b7b655f", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "2b4777993e8637549d65833b7c3007bc", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Fix failure to schema-qualify some object names in getObjectDescription output", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "07ff116e1bc884f9d2f8cb5b05fb55fda509f7d7394a3261972c6bcfb13289ff"}, "url": "/docs/compare/?release=9.4.19#9.4.19-8931734a8b7b655f", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "5e644a697564bfbaaa39703930a024bc", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Fix failure to schema-qualify some object names in getObjectDescription output", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "07ff116e1bc884f9d2f8cb5b05fb55fda509f7d7394a3261972c6bcfb13289ff"}, "url": "/docs/compare/?release=9.3.24#9.3.24-8931734a8b7b655f", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-a08da654bcba76c5", "cves": [], "html": "Widen COPY FROM's current-line-number counter from 32 to 64 bits (David Rowley)
\nThis avoids two problems with input exceeding 4G lines: COPY FROM WITH HEADER would drop a line every 4G lines, not only the first line, and error reports could show a wrong line number.
", "text": "Widen COPY FROM's current-line-number counter from 32 to 64 bits (David Rowley) This avoids two problems with input exceeding 4G lines: COPY FROM WITH HEADER would drop a line every 4G lines, not only the first line, and error reports could show a wrong line number.", "title": "Widen COPY FROM's current-line-number counter from 32 to 64 bits", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "ff4f6b93a6c284927d35c020079c03d7ad8b1580ee6a26d94a7832aaa396766b", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Widen COPY FROM's current-line-number counter from 32 to 64 bits (David Rowley) This avoids two problems with input exceeding 4G lines: COPY FROM WITH HEADER would drop a line every 4G lines, not only the first line, and error reports could show a wrong line number.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/018", "db_id": "6a29568a274d6d7c0272352ceaa8bff2", "patch_ids": [], "statement_hash": "8d31fc4a2ed333c07b1d2ccfe8dcf71234b6e2ef3078d93c716d562b5a7179b3", "relations": [{"rule": 2, "type": "equivalent", "target": "400870fbe55df9359ede788c742a20f4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8d31fc4a2ed333c07b1d2ccfe8dcf71234b6e2ef3078d93c716d562b5a7179b3"}}, {"rule": 2, "type": "equivalent", "target": "4f3380485fe76c091f58f1ddcd87dfde", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8d31fc4a2ed333c07b1d2ccfe8dcf71234b6e2ef3078d93c716d562b5a7179b3"}}, {"rule": 2, "type": "equivalent", "target": "97fc4eb2cf786b0b5d7e4acc0dfdfdc3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8d31fc4a2ed333c07b1d2ccfe8dcf71234b6e2ef3078d93c716d562b5a7179b3"}}, {"rule": 2, "type": "equivalent", "target": "b2cd9cf689a963719a5775af84071246", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8d31fc4a2ed333c07b1d2ccfe8dcf71234b6e2ef3078d93c716d562b5a7179b3"}}], "version": "9.5.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b2cd9cf689a963719a5775af84071246", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Widen COPY FROM's current-line-number counter from 32 to 64 bits", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8d31fc4a2ed333c07b1d2ccfe8dcf71234b6e2ef3078d93c716d562b5a7179b3"}, "url": "/docs/compare/?release=10.5#10.5-a08da654bcba76c5", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "400870fbe55df9359ede788c742a20f4", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Widen COPY FROM's current-line-number counter from 32 to 64 bits", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8d31fc4a2ed333c07b1d2ccfe8dcf71234b6e2ef3078d93c716d562b5a7179b3"}, "url": "/docs/compare/?release=9.6.10#9.6.10-a08da654bcba76c5", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "97fc4eb2cf786b0b5d7e4acc0dfdfdc3", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Widen COPY FROM's current-line-number counter from 32 to 64 bits", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8d31fc4a2ed333c07b1d2ccfe8dcf71234b6e2ef3078d93c716d562b5a7179b3"}, "url": "/docs/compare/?release=9.4.19#9.4.19-a08da654bcba76c5", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "4f3380485fe76c091f58f1ddcd87dfde", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Widen COPY FROM's current-line-number counter from 32 to 64 bits", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8d31fc4a2ed333c07b1d2ccfe8dcf71234b6e2ef3078d93c716d562b5a7179b3"}, "url": "/docs/compare/?release=9.3.24#9.3.24-a08da654bcba76c5", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-5c2e29b335a2b22f", "cves": [], "html": "Add a string freeing function to ecpg's pgtypes library, so that cross-module memory management problems can be avoided on Windows (Takayuki Tsunakawa)
\nOn Windows, crashes can ensue if the free call for a given chunk of memory is not made from the same DLL that malloc'ed the memory. The pgtypes library sometimes returns strings that it expects the caller to free, making it impossible to follow this rule. Add a PGTYPESchar_free() function that just wraps free, allowing applications to follow this rule.
Fix ecpg's support for long long variables on Windows, as well as other platforms that declare strtoll/strtoull nonstandardly or not at all (Dang Minh Huong, Tom Lane)
Fix misidentification of SQL statement type in PL/pgSQL, when a rule change causes a change in the semantics of a statement intra-session (Tom Lane)
\nThis error led to assertion failures, or in rare cases, failure to enforce the INTO STRICT option as expected.
", "text": "Fix misidentification of SQL statement type in PL/pgSQL, when a rule change causes a change in the semantics of a statement intra-session (Tom Lane) This error led to assertion failures, or in rare cases, failure to enforce the INTO STRICT option as expected.", "title": "Fix misidentification of SQL statement type in PL/pgSQL, when a rule change causes a change in the semantics of a statement intra-session", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "1e05635e8dadd50d3601d6b1c0fb54771e91e605e001f4a7268fc8e6626dc374", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix misidentification of SQL statement type in PL/pgSQL, when a rule change causes a change in the semantics of a statement intra-session (Tom Lane) This error led to assertion failures, or in rare cases, failure to enforce the INTO STRICT option as expected.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/021", "db_id": "66127d75d1aa478ae66eca83dcad5294", "patch_ids": [], "statement_hash": "82cb32c7a541a1d095ae2692add8c5349a737267c1e08b0e0930b8863cd61338", "relations": [{"rule": 2, "type": "equivalent", "target": "283e4e2066e3fae941f41b07645cf98d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "82cb32c7a541a1d095ae2692add8c5349a737267c1e08b0e0930b8863cd61338"}}, {"rule": 2, "type": "equivalent", "target": "5eb19d3945e05d6a36e3cba773c73980", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "82cb32c7a541a1d095ae2692add8c5349a737267c1e08b0e0930b8863cd61338"}}, {"rule": 2, "type": "equivalent", "target": "bb99b4ea43117011f5f0360b2036a7c1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "82cb32c7a541a1d095ae2692add8c5349a737267c1e08b0e0930b8863cd61338"}}, {"rule": 2, "type": "equivalent", "target": "d3b640bbeb4bf56c38af211f2774639b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "82cb32c7a541a1d095ae2692add8c5349a737267c1e08b0e0930b8863cd61338"}}], "version": "9.5.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "5eb19d3945e05d6a36e3cba773c73980", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Fix misidentification of SQL statement type in PL/pgSQL, when a rule change causes a change in the semantics of a statement intra-session", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "82cb32c7a541a1d095ae2692add8c5349a737267c1e08b0e0930b8863cd61338"}, "url": "/docs/compare/?release=10.5#10.5-fa7fc9b625602540", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "283e4e2066e3fae941f41b07645cf98d", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Fix misidentification of SQL statement type in PL/pgSQL, when a rule change causes a change in the semantics of a statement intra-session", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "82cb32c7a541a1d095ae2692add8c5349a737267c1e08b0e0930b8863cd61338"}, "url": "/docs/compare/?release=9.6.10#9.6.10-fa7fc9b625602540", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "bb99b4ea43117011f5f0360b2036a7c1", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Fix misidentification of SQL statement type in PL/pgSQL, when a rule change causes a change in the semantics of a statement intra-session", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "82cb32c7a541a1d095ae2692add8c5349a737267c1e08b0e0930b8863cd61338"}, "url": "/docs/compare/?release=9.4.19#9.4.19-fa7fc9b625602540", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "d3b640bbeb4bf56c38af211f2774639b", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Fix misidentification of SQL statement type in PL/pgSQL, when a rule change causes a change in the semantics of a statement intra-session", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "82cb32c7a541a1d095ae2692add8c5349a737267c1e08b0e0930b8863cd61338"}, "url": "/docs/compare/?release=9.3.24#9.3.24-fa7fc9b625602540", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-845a04a82e5d23f2", "cves": [], "html": "Fix password prompting in client programs so that echo is properly disabled on Windows when stdin is not the terminal (Matthew Stickney)
", "text": "Fix password prompting in client programs so that echo is properly disabled on Windows when stdin is not the terminal (Matthew Stickney)", "title": "Fix password prompting in client programs so that echo is properly disabled on Windows when stdin is not the terminal", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "add8dfb215d3abae72372460090ee1bb5a763e1611cae6cdb9305a0cca9bee24", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix password prompting in client programs so that echo is properly disabled on Windows when stdin is not the terminal (Matthew Stickney)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/022", "db_id": "74bb3ebc08ac88a7b5271ea572b2ed76", "patch_ids": [], "statement_hash": "1f2ab9b526273c711adb63e2bdeffba2541a8128e02b1a6b961e579520cd151f", "relations": [{"rule": 2, "type": "equivalent", "target": "1df1135d0a7cbdfe3a31f75380bcfdf2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1f2ab9b526273c711adb63e2bdeffba2541a8128e02b1a6b961e579520cd151f"}}, {"rule": 2, "type": "equivalent", "target": "216ec588ac11dcb3f585ce754a697f06", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1f2ab9b526273c711adb63e2bdeffba2541a8128e02b1a6b961e579520cd151f"}}, {"rule": 2, "type": "equivalent", "target": "660d6473a675ba3f8e3878a90ddfb31f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1f2ab9b526273c711adb63e2bdeffba2541a8128e02b1a6b961e579520cd151f"}}, {"rule": 2, "type": "equivalent", "target": "84b9f4946c2f108d70eef0e833d17e8f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1f2ab9b526273c711adb63e2bdeffba2541a8128e02b1a6b961e579520cd151f"}}], "version": "9.5.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "1df1135d0a7cbdfe3a31f75380bcfdf2", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Fix password prompting in client programs so that echo is properly disabled on Windows when stdin is not the terminal", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1f2ab9b526273c711adb63e2bdeffba2541a8128e02b1a6b961e579520cd151f"}, "url": "/docs/compare/?release=10.5#10.5-845a04a82e5d23f2", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "84b9f4946c2f108d70eef0e833d17e8f", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Fix password prompting in client programs so that echo is properly disabled on Windows when stdin is not the terminal", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1f2ab9b526273c711adb63e2bdeffba2541a8128e02b1a6b961e579520cd151f"}, "url": "/docs/compare/?release=9.6.10#9.6.10-845a04a82e5d23f2", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "216ec588ac11dcb3f585ce754a697f06", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Fix password prompting in client programs so that echo is properly disabled on Windows when stdin is not the terminal", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1f2ab9b526273c711adb63e2bdeffba2541a8128e02b1a6b961e579520cd151f"}, "url": "/docs/compare/?release=9.4.19#9.4.19-845a04a82e5d23f2", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "660d6473a675ba3f8e3878a90ddfb31f", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Fix password prompting in client programs so that echo is properly disabled on Windows when stdin is not the terminal", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1f2ab9b526273c711adb63e2bdeffba2541a8128e02b1a6b961e579520cd151f"}, "url": "/docs/compare/?release=9.3.24#9.3.24-845a04a82e5d23f2", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-0e7e3ba8bb250771", "cves": [], "html": "Further fix mis-quoting of values for list-valued GUC variables in dumps (Tom Lane)
\nThe previous fix for quoting of search_path and other list-valued variables in pg_dump output turned out to misbehave for empty-string list elements, and it risked truncation of long file paths.
", "text": "Further fix mis-quoting of values for list-valued GUC variables in dumps (Tom Lane) The previous fix for quoting of search_path and other list-valued variables in pg_dump output turned out to misbehave for empty-string list elements, and it risked truncation of long file paths.", "title": "Further fix mis-quoting of values for list-valued GUC variables in dumps", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "2d6bc0c8d432fc7d1ec6dadfb71d3d34e7396b21eb7d729a4d2b8e25ad88d21d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Further fix mis-quoting of values for list-valued GUC variables in dumps (Tom Lane) The previous fix for quoting of search_path and other list-valued variables in pg_dump output turned out to misbehave for empty-string list elements, and it risked truncation of long file paths.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/023", "db_id": "9b63dbd8f3ae2ab3289281d518d2a173", "patch_ids": [], "statement_hash": "afa809772dac3835f43627d537ffebaa34d52a019f22e472b785959ff2e94241", "relations": [{"rule": 2, "type": "equivalent", "target": "18842e4d5965cc8aea228715c6a1442c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "afa809772dac3835f43627d537ffebaa34d52a019f22e472b785959ff2e94241"}}, {"rule": 2, "type": "equivalent", "target": "3d2f303084793f85b50b53f7aa4e4ae1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "afa809772dac3835f43627d537ffebaa34d52a019f22e472b785959ff2e94241"}}, {"rule": 2, "type": "equivalent", "target": "c2e4c85fba0591e0216d81c8a295851f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "afa809772dac3835f43627d537ffebaa34d52a019f22e472b785959ff2e94241"}}, {"rule": 2, "type": "equivalent", "target": "d26ab5999bb6fb3eee4efa3b34edada0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "afa809772dac3835f43627d537ffebaa34d52a019f22e472b785959ff2e94241"}}], "version": "9.5.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "3d2f303084793f85b50b53f7aa4e4ae1", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Further fix mis-quoting of values for list-valued GUC variables in dumps", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "afa809772dac3835f43627d537ffebaa34d52a019f22e472b785959ff2e94241"}, "url": "/docs/compare/?release=10.5#10.5-0e7e3ba8bb250771", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "18842e4d5965cc8aea228715c6a1442c", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Further fix mis-quoting of values for list-valued GUC variables in dumps", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "afa809772dac3835f43627d537ffebaa34d52a019f22e472b785959ff2e94241"}, "url": "/docs/compare/?release=9.6.10#9.6.10-0e7e3ba8bb250771", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "d26ab5999bb6fb3eee4efa3b34edada0", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Further fix mis-quoting of values for list-valued GUC variables in dumps", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "afa809772dac3835f43627d537ffebaa34d52a019f22e472b785959ff2e94241"}, "url": "/docs/compare/?release=9.4.19#9.4.19-0e7e3ba8bb250771", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "c2e4c85fba0591e0216d81c8a295851f", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Further fix mis-quoting of values for list-valued GUC variables in dumps", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "afa809772dac3835f43627d537ffebaa34d52a019f22e472b785959ff2e94241"}, "url": "/docs/compare/?release=9.3.24#9.3.24-0e7e3ba8bb250771", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-29945844cd723b27", "cves": [], "html": "Fix pg_dump's failure to dump REPLICA IDENTITY properties for constraint indexes (Tom Lane)
\nManually created unique indexes were properly marked, but not those created by declaring UNIQUE or PRIMARY KEY constraints.
", "text": "Fix pg_dump's failure to dump REPLICA IDENTITY properties for constraint indexes (Tom Lane) Manually created unique indexes were properly marked, but not those created by declaring UNIQUE or PRIMARY KEY constraints.", "title": "Fix pg_dump's failure to dump REPLICA IDENTITY properties for constraint indexes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "bc59b10528cd272c9c34074336c438688263c4f5a1d70268bc424fe576d79c1e", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix pg_dump's failure to dump REPLICA IDENTITY properties for constraint indexes (Tom Lane) Manually created unique indexes were properly marked, but not those created by declaring UNIQUE or PRIMARY KEY constraints.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/024", "db_id": "f67129dfffc0911c61d5c7cd421e664d", "patch_ids": [], "statement_hash": "cab68c07de650c8a368f677e1fb8963e430202b9c85e5fbe52dfe065233d8b81", "relations": [{"rule": 2, "type": "equivalent", "target": "33cbdc882efe754330c28de8fc9fd78d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cab68c07de650c8a368f677e1fb8963e430202b9c85e5fbe52dfe065233d8b81"}}, {"rule": 2, "type": "equivalent", "target": "4b0730fb3ae031353c3767d68fcf4d60", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cab68c07de650c8a368f677e1fb8963e430202b9c85e5fbe52dfe065233d8b81"}}, {"rule": 2, "type": "equivalent", "target": "c1cfe2a227fb4d435a3864a5833964c4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cab68c07de650c8a368f677e1fb8963e430202b9c85e5fbe52dfe065233d8b81"}}], "version": "9.5.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4b0730fb3ae031353c3767d68fcf4d60", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Fix pg_dump's failure to dump REPLICA IDENTITY properties for constraint indexes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cab68c07de650c8a368f677e1fb8963e430202b9c85e5fbe52dfe065233d8b81"}, "url": "/docs/compare/?release=10.5#10.5-29945844cd723b27", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "c1cfe2a227fb4d435a3864a5833964c4", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Fix pg_dump's failure to dump REPLICA IDENTITY properties for constraint indexes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cab68c07de650c8a368f677e1fb8963e430202b9c85e5fbe52dfe065233d8b81"}, "url": "/docs/compare/?release=9.6.10#9.6.10-29945844cd723b27", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "33cbdc882efe754330c28de8fc9fd78d", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Fix pg_dump's failure to dump REPLICA IDENTITY properties for constraint indexes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cab68c07de650c8a368f677e1fb8963e430202b9c85e5fbe52dfe065233d8b81"}, "url": "/docs/compare/?release=9.4.19#9.4.19-29945844cd723b27", "source_url": "/docs/release/9.4.19/#AEN120815"}]}, {"id": "9.5.14-c6b9c3422e37b980", "cves": [], "html": "Make pg_upgrade check that the old server was shut down cleanly (Bruce Momjian)
\nThe previous check could be fooled by an immediate-mode shutdown.
", "text": "Make pg_upgrade check that the old server was shut down cleanly (Bruce Momjian) The previous check could be fooled by an immediate-mode shutdown.", "title": "Make pg_upgrade check that the old server was shut down cleanly", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "71bc1a7bd9f2a132a3385bd940a9ea8de31b186e2b97f1c8abf9cd2f795db5d7", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Make pg_upgrade check that the old server was shut down cleanly (Bruce Momjian) The previous check could be fooled by an immediate-mode shutdown.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/025", "db_id": "c1499885d0749c110343bddd70ca1309", "patch_ids": [], "statement_hash": "bdf17569914514a3150e2111f270f56c6dbf1c441dcea5e64bdcde79be711743", "relations": [{"rule": 2, "type": "equivalent", "target": "1954689a48854915e718dbce8ff7ab6b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bdf17569914514a3150e2111f270f56c6dbf1c441dcea5e64bdcde79be711743"}}, {"rule": 2, "type": "equivalent", "target": "4d1283c51899e26f1867c2769f6a309c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bdf17569914514a3150e2111f270f56c6dbf1c441dcea5e64bdcde79be711743"}}, {"rule": 2, "type": "equivalent", "target": "739f9fce188dadad715b9a79b61ba59a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bdf17569914514a3150e2111f270f56c6dbf1c441dcea5e64bdcde79be711743"}}, {"rule": 2, "type": "equivalent", "target": "eb47de5066dfd069f8ee0aa9c0944fff", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bdf17569914514a3150e2111f270f56c6dbf1c441dcea5e64bdcde79be711743"}}], "version": "9.5.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "eb47de5066dfd069f8ee0aa9c0944fff", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Make pg_upgrade check that the old server was shut down cleanly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bdf17569914514a3150e2111f270f56c6dbf1c441dcea5e64bdcde79be711743"}, "url": "/docs/compare/?release=10.5#10.5-c6b9c3422e37b980", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "4d1283c51899e26f1867c2769f6a309c", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Make pg_upgrade check that the old server was shut down cleanly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bdf17569914514a3150e2111f270f56c6dbf1c441dcea5e64bdcde79be711743"}, "url": "/docs/compare/?release=9.6.10#9.6.10-c6b9c3422e37b980", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "739f9fce188dadad715b9a79b61ba59a", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Make pg_upgrade check that the old server was shut down cleanly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bdf17569914514a3150e2111f270f56c6dbf1c441dcea5e64bdcde79be711743"}, "url": "/docs/compare/?release=9.4.19#9.4.19-c6b9c3422e37b980", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "1954689a48854915e718dbce8ff7ab6b", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Make pg_upgrade check that the old server was shut down cleanly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bdf17569914514a3150e2111f270f56c6dbf1c441dcea5e64bdcde79be711743"}, "url": "/docs/compare/?release=9.3.24#9.3.24-c6b9c3422e37b980", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-d632db00c34ade35", "cves": [], "html": "Fix contrib/hstore_plperl to look through Perl scalar references, and to not crash if it doesn't find a hash reference where it expects one (Tom Lane)
", "text": "Fix contrib/hstore_plperl to look through Perl scalar references, and to not crash if it doesn't find a hash reference where it expects one (Tom Lane)", "title": "Fix contrib/hstore_plperl to look through Perl scalar references, and to not crash if it doesn't find a hash reference where it expects one", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "eb5b223ce434cd397dbe9335d932849d7b250dcd46e9273d73d219e4d2d9853b", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix contrib/hstore_plperl to look through Perl scalar references, and to not crash if it doesn't find a hash reference where it expects one (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/026", "db_id": "c148b7f11f757ab5dccb2d01de8155d0", "patch_ids": [], "statement_hash": "f5edfe1b703b92ff9c9fc18907d42fe7705e0b43f5903145b601f3ef95d71621", "relations": [{"rule": 2, "type": "equivalent", "target": "02e66838f31a8874e78ef748a007397c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f5edfe1b703b92ff9c9fc18907d42fe7705e0b43f5903145b601f3ef95d71621"}}, {"rule": 2, "type": "equivalent", "target": "e406ef3e530ccb62194d156810d41e13", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f5edfe1b703b92ff9c9fc18907d42fe7705e0b43f5903145b601f3ef95d71621"}}], "version": "9.5.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "e406ef3e530ccb62194d156810d41e13", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Fix contrib/hstore_plperl to look through Perl scalar references, and to not crash if it doesn't find a hash reference where it expects one", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f5edfe1b703b92ff9c9fc18907d42fe7705e0b43f5903145b601f3ef95d71621"}, "url": "/docs/compare/?release=10.5#10.5-d632db00c34ade35", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "02e66838f31a8874e78ef748a007397c", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Fix contrib/hstore_plperl to look through Perl scalar references, and to not crash if it doesn't find a hash reference where it expects one", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f5edfe1b703b92ff9c9fc18907d42fe7705e0b43f5903145b601f3ef95d71621"}, "url": "/docs/compare/?release=9.6.10#9.6.10-d632db00c34ade35", "source_url": "/docs/release/9.6.10/#AEN134332"}]}, {"id": "9.5.14-54c2e3de3e17af5a", "cves": [], "html": "Fix crash in contrib/ltree's lca() function when the input array is empty (Pierre Ducroquet)
Fix various error-handling code paths in which an incorrect error code might be reported (Michael Paquier, Tom Lane, Magnus Hagander)
", "text": "Fix various error-handling code paths in which an incorrect error code might be reported (Michael Paquier, Tom Lane, Magnus Hagander)", "title": "Fix various error-handling code paths in which an incorrect error code might be reported", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "eb226d88cc2818a05e33386ec1a8f54af921d72d612fc646511afb752428f2b2", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix various error-handling code paths in which an incorrect error code might be reported (Michael Paquier, Tom Lane, Magnus Hagander)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/028", "db_id": "6bc786b07ebdffc9fa3a314516e966a4", "patch_ids": [], "statement_hash": "5a05d314c8d902e97894777af926545d7a1d139f8ad17e798b5f8925814e49c8", "relations": [{"rule": 2, "type": "equivalent", "target": "44343b5147cbbb9d79bd4862e5dc7084", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5a05d314c8d902e97894777af926545d7a1d139f8ad17e798b5f8925814e49c8"}}, {"rule": 2, "type": "equivalent", "target": "abc61176748d713bf18596dfa5958398", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5a05d314c8d902e97894777af926545d7a1d139f8ad17e798b5f8925814e49c8"}}, {"rule": 2, "type": "equivalent", "target": "dd5ba05fde3e4dbb1c77961c638213f0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5a05d314c8d902e97894777af926545d7a1d139f8ad17e798b5f8925814e49c8"}}, {"rule": 2, "type": "equivalent", "target": "ed7faf376a1da5be2a371fed15a0acba", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5a05d314c8d902e97894777af926545d7a1d139f8ad17e798b5f8925814e49c8"}}], "version": "9.5.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "ed7faf376a1da5be2a371fed15a0acba", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Fix various error-handling code paths in which an incorrect error code might be reported", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5a05d314c8d902e97894777af926545d7a1d139f8ad17e798b5f8925814e49c8"}, "url": "/docs/compare/?release=10.5#10.5-f3db76dd5ff992d1", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "abc61176748d713bf18596dfa5958398", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Fix various error-handling code paths in which an incorrect error code might be reported", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5a05d314c8d902e97894777af926545d7a1d139f8ad17e798b5f8925814e49c8"}, "url": "/docs/compare/?release=9.6.10#9.6.10-f3db76dd5ff992d1", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "44343b5147cbbb9d79bd4862e5dc7084", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Fix various error-handling code paths in which an incorrect error code might be reported", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5a05d314c8d902e97894777af926545d7a1d139f8ad17e798b5f8925814e49c8"}, "url": "/docs/compare/?release=9.4.19#9.4.19-f3db76dd5ff992d1", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "dd5ba05fde3e4dbb1c77961c638213f0", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Fix various error-handling code paths in which an incorrect error code might be reported", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5a05d314c8d902e97894777af926545d7a1d139f8ad17e798b5f8925814e49c8"}, "url": "/docs/compare/?release=9.3.24#9.3.24-f3db76dd5ff992d1", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-d922093c0e9e0f63", "cves": [], "html": "Rearrange makefiles to ensure that programs link to freshly-built libraries (such as libpq.so) rather than ones that might exist in the system library directories (Tom Lane)
\nThis avoids problems when building on platforms that supply old copies of PostgreSQL libraries.
", "text": "Rearrange makefiles to ensure that programs link to freshly-built libraries (such as libpq.so) rather than ones that might exist in the system library directories (Tom Lane) This avoids problems when building on platforms that supply old copies of PostgreSQL libraries.", "title": "Rearrange makefiles to ensure that programs link to freshly-built libraries (such as libpq.so) rather than ones that might exist in the system library directories", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "9fe1fb5035dc0b05720452fac376d32ae797010741c48dc3df2de54e396a9eac", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Rearrange makefiles to ensure that programs link to freshly-built libraries (such as libpq.so) rather than ones that might exist in the system library directories (Tom Lane) This avoids problems when building on platforms that supply old copies of PostgreSQL libraries.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/029", "db_id": "2add6f424e337938f103c3b77f8214ff", "patch_ids": [], "statement_hash": "8e0e1d9b06d086f4846a6b8ba0946ea4470385b68265ec27f156bce0eee67d3f", "relations": [{"rule": 2, "type": "equivalent", "target": "092ac1884398bcbc8a003e01acd466cc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8e0e1d9b06d086f4846a6b8ba0946ea4470385b68265ec27f156bce0eee67d3f"}}, {"rule": 2, "type": "equivalent", "target": "d056736e371dede2d98e0596877e08b6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8e0e1d9b06d086f4846a6b8ba0946ea4470385b68265ec27f156bce0eee67d3f"}}, {"rule": 2, "type": "equivalent", "target": "e0fe94c2f5bcc8d0829a3e2e0f1f5567", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8e0e1d9b06d086f4846a6b8ba0946ea4470385b68265ec27f156bce0eee67d3f"}}, {"rule": 2, "type": "equivalent", "target": "fb9cfc50eee8d8b0e1ae293bbf759a17", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8e0e1d9b06d086f4846a6b8ba0946ea4470385b68265ec27f156bce0eee67d3f"}}], "version": "9.5.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "092ac1884398bcbc8a003e01acd466cc", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Rearrange makefiles to ensure that programs link to freshly-built libraries (such as libpq.so) rather than ones that might exist in the system library directories", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8e0e1d9b06d086f4846a6b8ba0946ea4470385b68265ec27f156bce0eee67d3f"}, "url": "/docs/compare/?release=10.5#10.5-d922093c0e9e0f63", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "d056736e371dede2d98e0596877e08b6", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Rearrange makefiles to ensure that programs link to freshly-built libraries (such as libpq.so) rather than ones that might exist in the system library directories", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8e0e1d9b06d086f4846a6b8ba0946ea4470385b68265ec27f156bce0eee67d3f"}, "url": "/docs/compare/?release=9.6.10#9.6.10-d922093c0e9e0f63", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "fb9cfc50eee8d8b0e1ae293bbf759a17", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Rearrange makefiles to ensure that programs link to freshly-built libraries (such as libpq.so) rather than ones that might exist in the system library directories", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8e0e1d9b06d086f4846a6b8ba0946ea4470385b68265ec27f156bce0eee67d3f"}, "url": "/docs/compare/?release=9.4.19#9.4.19-d922093c0e9e0f63", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "e0fe94c2f5bcc8d0829a3e2e0f1f5567", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Rearrange makefiles to ensure that programs link to freshly-built libraries (such as libpq.so) rather than ones that might exist in the system library directories", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8e0e1d9b06d086f4846a6b8ba0946ea4470385b68265ec27f156bce0eee67d3f"}, "url": "/docs/compare/?release=9.3.24#9.3.24-d922093c0e9e0f63", "source_url": "/docs/release/9.3.24/#AEN115312"}]}, {"id": "9.5.14-d9e7fdabc8642516", "cves": [], "html": "Update time zone data files to tzdata release 2018e for DST law changes in North Korea, plus historical corrections for Czechoslovakia.
\nThis update includes a redefinition of \"daylight savings\" in Ireland, as well as for some past years in Namibia and Czechoslovakia. In those jurisdictions, legally standard time is observed in summer, and daylight savings time in winter, so that the daylight savings offset is one hour behind standard time not one hour ahead. This does not affect either the actual UTC offset or the timezone abbreviations in use; the only known effect is that the is_dst column in the pg_timezone_names view will now be true in winter and false in summer in these cases.
", "text": "Update time zone data files to tzdata release 2018e for DST law changes in North Korea, plus historical corrections for Czechoslovakia. This update includes a redefinition of \"daylight savings\" in Ireland, as well as for some past years in Namibia and Czechoslovakia. In those jurisdictions, legally standard time is observed in summer, and daylight savings time in winter, so that the daylight savings offset is one hour behind standard time not one hour ahead. This does not affect either the actual UTC offset or the timezone abbreviations in use; the only known effect is that the is_dst column in the pg_timezone_names view will now be true in winter and false in summer in these cases.", "title": "Update time zone data files to tzdata release 2018e for DST law changes in North Korea, plus historical corrections for Czechoslovakia.", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.14/#AEN129077", "source_hash": "9f37319456282bec8598cba6308a808640b0982827c1d7cd6fca8042f555e880", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Update time zone data files to tzdata release 2018e for DST law changes in North Korea, plus historical corrections for Czechoslovakia. This update includes a redefinition of daylight savings in Ireland, as well as for some past years in Namibia and Czechoslovakia. In those jurisdictions, legally standard time is observed in summer, and daylight savings time in winter, so that the daylight savings offset is one hour behind standard time not one hour ahead. This does not affect either the actual UTC offset or the timezone abbreviations in use; the only known effect is that the is_dst column in the pg_timezone_names view will now be true in winter and false in summer in these cases.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.14/changes/030", "db_id": "4665643582ca528c025ca51ef876640b", "patch_ids": [], "statement_hash": "121e90e8bc23ffc5b72b1b0813a32d1c613b718c6334e0d052ff766689a0a87c", "relations": [{"rule": 2, "type": "equivalent", "target": "5e2e95399fa99faba1ec919a703975de", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "121e90e8bc23ffc5b72b1b0813a32d1c613b718c6334e0d052ff766689a0a87c"}}, {"rule": 2, "type": "equivalent", "target": "e66a4e42e0632f51b3db77194fc6ea05", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "121e90e8bc23ffc5b72b1b0813a32d1c613b718c6334e0d052ff766689a0a87c"}}, {"rule": 2, "type": "equivalent", "target": "eab8b499ede5f2e4cd22b4228850bace", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "121e90e8bc23ffc5b72b1b0813a32d1c613b718c6334e0d052ff766689a0a87c"}}, {"rule": 2, "type": "equivalent", "target": "eae244a6dda158da8e88045e274b818f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "121e90e8bc23ffc5b72b1b0813a32d1c613b718c6334e0d052ff766689a0a87c"}}], "version": "9.5.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "e66a4e42e0632f51b3db77194fc6ea05", "kind": "equivalent", "version": "10.5", "label": "10.5", "title": "Update time zone data files to tzdata release 2018e for DST law changes in North Korea, plus historical corrections for Czechoslovakia.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "121e90e8bc23ffc5b72b1b0813a32d1c613b718c6334e0d052ff766689a0a87c"}, "url": "/docs/compare/?release=10.5#10.5-d9e7fdabc8642516", "source_url": "/docs/release/10.5/#id-1.11.6.23.5"}, {"db_id": "eae244a6dda158da8e88045e274b818f", "kind": "equivalent", "version": "9.6.10", "label": "9.6.10", "title": "Update time zone data files to tzdata release 2018e for DST law changes in North Korea, plus historical corrections for Czechoslovakia.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "121e90e8bc23ffc5b72b1b0813a32d1c613b718c6334e0d052ff766689a0a87c"}, "url": "/docs/compare/?release=9.6.10#9.6.10-d9e7fdabc8642516", "source_url": "/docs/release/9.6.10/#AEN134332"}, {"db_id": "eab8b499ede5f2e4cd22b4228850bace", "kind": "equivalent", "version": "9.4.19", "label": "9.4.19", "title": "Update time zone data files to tzdata release 2018e for DST law changes in North Korea, plus historical corrections for Czechoslovakia.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "121e90e8bc23ffc5b72b1b0813a32d1c613b718c6334e0d052ff766689a0a87c"}, "url": "/docs/compare/?release=9.4.19#9.4.19-d9e7fdabc8642516", "source_url": "/docs/release/9.4.19/#AEN120815"}, {"db_id": "5e2e95399fa99faba1ec919a703975de", "kind": "equivalent", "version": "9.3.24", "label": "9.3.24", "title": "Update time zone data files to tzdata release 2018e for DST law changes in North Korea, plus historical corrections for Czechoslovakia.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "121e90e8bc23ffc5b72b1b0813a32d1c613b718c6334e0d052ff766689a0a87c"}, "url": "/docs/compare/?release=9.3.24#9.3.24-d9e7fdabc8642516", "source_url": "/docs/release/9.3.24/#AEN115312"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 30}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 14}, {"key": "security", "label": "Security", "count": 2}, {"key": "performance", "label": "Performance", "count": 2}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 12}], "total": 30, "release_count": 1, "cross_major": false, "cve_count": 2, "cves": [{"id": "CVE-2018-10915", "url": "https://www.postgresql.org/support/security/CVE-2018-10915/", "fixed": {"10": "10.5", "9.3": "9.3.24", "9.4": "9.4.19", "9.5": "9.5.14", "9.6": "9.6.10"}, "score": 8.5, "title": "Fix failure to reset libpq's state fully between connection attempts", "vector": "AV:N/AC:H/PR:L/UI:N/S:C/C:H/I:H/A:H", "affected": {"10": "10", "9.3": "9.3", "9.4": "9.4", "9.5": "9.5", "9.6": "9.6"}, "component": "client", "published": {"10": "2018-08-09", "9.3": "2018-08-09", "9.4": "2018-08-09", "9.5": "2018-08-09", "9.6": "2018-08-09"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2018-08-09", "fixed_version": "9.5.14"}, {"id": "CVE-2018-10925", "url": "https://www.postgresql.org/support/security/CVE-2018-10925/", "fixed": {"10": "10.5", "9.5": "9.5.14", "9.6": "9.6.10"}, "score": 7.1, "title": "Fix INSERT ... ON CONFLICT UPDATE through a view that isn't just SELECT * FROM ...", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:L/A:N", "affected": {"10": "10", "9.5": "9.5", "9.6": "9.6"}, "component": "core server", "published": {"10": "2018-08-09", "9.5": "2018-08-09", "9.6": "2018-08-09"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2018-08-09", "fixed_version": "9.5.14"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 30, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}