A dump/restore is not required for those running 9.3.X.
\nHowever, this release corrects a logic error in pg_upgrade, as well as an index corruption problem in some GiST indexes. See the first two changelog entries below to find out whether your installation has been affected and what steps you should take if so.
\nAlso, if you are upgrading from a version earlier than 9.3.4, see Section E.22.
", "compatibility_count": 0, "label": "9.3.5", "status_label": "Historical", "eol": "2018-11-08", "age_days": 4450, "support_days": -2882}, "groups": [{"date": "2014-07-24", "build": "9.3.5", "major": "9.3", "minor": 5, "manual": "9.3", "status": "stable", "doc_git": "", "version": "9.3.5", "eol_date": "2018-11-08", "date_text": "2014-07-24", "supported": false, "manual_url": "/docs/9.3/release-9-3-5.html", "source_url": "/docs/release/9.3.5/", "entry_count": 54, "placeholder": false, "content_hash": "f40be34774d1b2caabd7dabd2b7de2d43dc19dd953082d2963db32d32df4d113", "manual_build": "9.3.25", "source_as_of": "", "changes_count": 54, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 9.3.X.
\nHowever, this release corrects a logic error in pg_upgrade, as well as an index corruption problem in some GiST indexes. See the first two changelog entries below to find out whether your installation has been affected and what steps you should take if so.
\nAlso, if you are upgrading from a version earlier than 9.3.4, see Section E.22.
", "compatibility_count": 0, "label": "9.3.5", "status_label": "Historical", "eol": "2018-11-08", "age_days": 4450, "support_days": -2882, "entries": [{"id": "9.3.5-339b451f003d84b5", "cves": [], "html": "In pg_upgrade, remove pg_multixact files left behind by initdb (Bruce Momjian)
\nIf you used a pre-9.3.5 version of pg_upgrade to upgrade a database cluster to 9.3, it might have left behind a file $PGDATA/pg_multixact/offsets/0000 that should not be there and will eventually cause problems in VACUUM. However, in common cases this file is actually valid and must not be removed. To determine whether your installation has this problem, run this query as superuser, in any database of the cluster:
\nWITH list(file) AS (SELECT * FROM pg_ls_dir('pg_multixact/offsets'))\nSELECT EXISTS (SELECT * FROM list WHERE file = '0000') AND\n NOT EXISTS (SELECT * FROM list WHERE file = '0001') AND\n NOT EXISTS (SELECT * FROM list WHERE file = 'FFFF') AND\n EXISTS (SELECT * FROM list WHERE file != '0000')\n AS file_0000_removal_required;\n\nIf this query returns t, manually remove the file $PGDATA/pg_multixact/offsets/0000. Do nothing if the query returns f.
", "text": "In pg_upgrade, remove pg_multixact files left behind by initdb (Bruce Momjian) If you used a pre-9.3.5 version of pg_upgrade to upgrade a database cluster to 9.3, it might have left behind a file $PGDATA/pg_multixact/offsets/0000 that should not be there and will eventually cause problems in VACUUM. However, in common cases this file is actually valid and must not be removed. To determine whether your installation has this problem, run this query as superuser, in any database of the cluster: WITH list(file) AS (SELECT * FROM pg_ls_dir('pg_multixact/offsets')) SELECT EXISTS (SELECT * FROM list WHERE file = '0000') AND NOT EXISTS (SELECT * FROM list WHERE file = '0001') AND NOT EXISTS (SELECT * FROM list WHERE file = 'FFFF') AND EXISTS (SELECT * FROM list WHERE file != '0000') AS file_0000_removal_required; If this query returns t, manually remove the file $PGDATA/pg_multixact/offsets/0000. Do nothing if the query returns f.", "title": "In pg_upgrade, remove pg_multixact files left behind by initdb", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "de1628ca71c91b8579fa3793ce0598d8527ce78b8a712f116dfd3813becb7319", "section_path": ["Changes"], "commit_groups": [["0f7482733", "cc5841809", "dd5369047"]], "identity_text": "In pg_upgrade, remove pg_multixact files left behind by initdb (Bruce Momjian) If you used a pre-9.3.5 version of pg_upgrade to upgrade a database cluster to 9.3, it might have left behind a file $PGDATA/pg_multixact/offsets/0000 that should not be there and will eventually cause problems in VACUUM. However, in common cases this file is actually valid and must not be removed. To determine whether your installation has this problem, run this query as superuser, in any database of the cluster: WITH list(file) AS (SELECT * FROM pg_ls_dir('pg_multixact/offsets')) SELECT EXISTS (SELECT * FROM list WHERE file = '0000') AND NOT EXISTS (SELECT * FROM list WHERE file = '0001') AND NOT EXISTS (SELECT * FROM list WHERE file = 'FFFF') AND EXISTS (SELECT * FROM list WHERE file != '0000') AS file_0000_removal_required; If this query returns t, manually remove the file $PGDATA/pg_multixact/offsets/0000. Do nothing if the query returns f.", "commit_aliases": ["0f7482733", "cc5841809", "dd5369047"], "source_commits": ["cc5841809"], "source_entry_id": "9.3.5/changes/001", "db_id": "72715be972cf2aaad5c9cfc89231d612", "patch_ids": ["0d78774302292602bfaada7d902ba4d0"], "statement_hash": "ff7aebda71582817f6406048b9e7122de47837a1e06b7fc486d95f860db7d142", "relations": [], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.5-b48f4253f9ea5cf9", "cves": [], "html": "Correctly initialize padding bytes in contrib/btree_gist indexes on bit columns (Heikki Linnakangas)
\nThis error could result in incorrect query results due to values that should compare equal not being seen as equal. Users with GiST indexes on bit or bit varying columns should REINDEX those indexes after installing this update.
", "text": "Correctly initialize padding bytes in contrib/btree_gist indexes on bit columns (Heikki Linnakangas) This error could result in incorrect query results due to values that should compare equal not being seen as equal. Users with GiST indexes on bit or bit varying columns should REINDEX those indexes after installing this update.", "title": "Correctly initialize padding bytes in contrib/btree_gist indexes on bit columns", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "709d713e12d304166f987b54c4dce9fb04d23a1afead525014a2a3ee1f10e32f", "section_path": ["Changes"], "commit_groups": [["0d8d0d027", "1913d0f28", "540ac7cea", "c87c43f08", "d5b912c90", "e31d77c96"]], "identity_text": "Correctly initialize padding bytes in contrib/btree_gist indexes on bit columns (Heikki Linnakangas) This error could result in incorrect query results due to values that should compare equal not being seen as equal. Users with GiST indexes on bit or bit varying columns should REINDEX those indexes after installing this update.", "commit_aliases": ["0d8d0d027", "1913d0f28", "540ac7cea", "c87c43f08", "d5b912c90", "e31d77c96"], "source_commits": ["d5b912c90"], "source_entry_id": "9.3.5/changes/002", "db_id": "5d8b301dac7ea946159414f417b80e20", "patch_ids": ["c9664c6a684af10fa9dd057232b79dfd"], "statement_hash": "c5ec7f05650e8d35c9b6ce456cec4314dd5b264d089fd9a8a65ddb5c8d01bf11", "relations": [{"rule": 2, "type": "equivalent", "target": "bb8c4a129b84f2137f55859616c7a7c6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5ec7f05650e8d35c9b6ce456cec4314dd5b264d089fd9a8a65ddb5c8d01bf11"}}, {"rule": 2, "type": "equivalent", "target": "c08b5ee3c4feadbdf794e02f47e53d44", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5ec7f05650e8d35c9b6ce456cec4314dd5b264d089fd9a8a65ddb5c8d01bf11"}}, {"rule": 2, "type": "equivalent", "target": "c4f7127cc64d8fe10e55c425915ade36", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5ec7f05650e8d35c9b6ce456cec4314dd5b264d089fd9a8a65ddb5c8d01bf11"}}], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "bb8c4a129b84f2137f55859616c7a7c6", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Correctly initialize padding bytes in contrib/btree_gist indexes on bit columns", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5ec7f05650e8d35c9b6ce456cec4314dd5b264d089fd9a8a65ddb5c8d01bf11"}, "url": "/docs/compare/?release=9.2.9#9.2.9-b48f4253f9ea5cf9", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "c4f7127cc64d8fe10e55c425915ade36", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Correctly initialize padding bytes in contrib/btree_gist indexes on bit columns", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5ec7f05650e8d35c9b6ce456cec4314dd5b264d089fd9a8a65ddb5c8d01bf11"}, "url": "/docs/compare/?release=9.1.14#9.1.14-b48f4253f9ea5cf9", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "c08b5ee3c4feadbdf794e02f47e53d44", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Correctly initialize padding bytes in contrib/btree_gist indexes on bit columns", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5ec7f05650e8d35c9b6ce456cec4314dd5b264d089fd9a8a65ddb5c8d01bf11"}, "url": "/docs/compare/?release=9.0.18#9.0.18-b48f4253f9ea5cf9", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-61dba0500021a2b5", "cves": [], "html": "Protect against torn pages when deleting GIN list pages (Heikki Linnakangas)
\nThis fix prevents possible index corruption if a system crash occurs while the page update is being written to disk.
", "text": "Protect against torn pages when deleting GIN list pages (Heikki Linnakangas) This fix prevents possible index corruption if a system crash occurs while the page update is being written to disk.", "title": "Protect against torn pages when deleting GIN list pages", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "afcb91dde071d7de5a6c7fcbe1316c8991d363ec78826005a4d89b02863e4d4a", "section_path": ["Changes"], "commit_groups": [["31633f992", "34572920c", "4f7bb4b2a", "686a7194e", "8b4efe1f3", "be7830596"]], "identity_text": "Protect against torn pages when deleting GIN list pages (Heikki Linnakangas) This fix prevents possible index corruption if a system crash occurs while the page update is being written to disk.", "commit_aliases": ["31633f992", "34572920c", "4f7bb4b2a", "686a7194e", "8b4efe1f3", "be7830596"], "source_commits": ["34572920c"], "source_entry_id": "9.3.5/changes/003", "db_id": "9c3944d9105c97482a4dc2fb8776b26f", "patch_ids": ["c20841a63b3d8ed03a2f66546d670e37"], "statement_hash": "3069a09e51a039b54312df352e46e435116f1aab6749579fa61617bc1036c4dc", "relations": [{"rule": 2, "type": "equivalent", "target": "8329b9d263d6d6befba8bbe22cd17322", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3069a09e51a039b54312df352e46e435116f1aab6749579fa61617bc1036c4dc"}}, {"rule": 2, "type": "equivalent", "target": "b73f1e86dca122120bdb13fac7f9140e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3069a09e51a039b54312df352e46e435116f1aab6749579fa61617bc1036c4dc"}}, {"rule": 2, "type": "equivalent", "target": "ee04033d30f9bad8474c949135bf2bef", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3069a09e51a039b54312df352e46e435116f1aab6749579fa61617bc1036c4dc"}}], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "ee04033d30f9bad8474c949135bf2bef", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Protect against torn pages when deleting GIN list pages", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3069a09e51a039b54312df352e46e435116f1aab6749579fa61617bc1036c4dc"}, "url": "/docs/compare/?release=9.2.9#9.2.9-61dba0500021a2b5", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "b73f1e86dca122120bdb13fac7f9140e", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Protect against torn pages when deleting GIN list pages", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3069a09e51a039b54312df352e46e435116f1aab6749579fa61617bc1036c4dc"}, "url": "/docs/compare/?release=9.1.14#9.1.14-61dba0500021a2b5", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "8329b9d263d6d6befba8bbe22cd17322", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Protect against torn pages when deleting GIN list pages", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3069a09e51a039b54312df352e46e435116f1aab6749579fa61617bc1036c4dc"}, "url": "/docs/compare/?release=9.0.18#9.0.18-61dba0500021a2b5", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-17edac81833aeb37", "cves": [], "html": "Don't clear the right-link of a GiST index page while replaying updates from WAL (Heikki Linnakangas)
\nThis error could lead to transiently wrong answers from GiST index scans performed in Hot Standby.
", "text": "Don't clear the right-link of a GiST index page while replaying updates from WAL (Heikki Linnakangas) This error could lead to transiently wrong answers from GiST index scans performed in Hot Standby.", "title": "Don't clear the right-link of a GiST index page while replaying updates from WAL", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "a5857dd9de60f280e88715cfdfa6c6cf03562cd2eb6799d62bee57c753c789df", "section_path": ["Changes"], "commit_groups": [["02b9fd73e", "601c01e08", "7ca32e255", "ac0078c1d", "d034e9b3b"]], "identity_text": "Don't clear the right-link of a GiST index page while replaying updates from WAL (Heikki Linnakangas) This error could lead to transiently wrong answers from GiST index scans performed in Hot Standby.", "commit_aliases": ["02b9fd73e", "601c01e08", "7ca32e255", "ac0078c1d", "d034e9b3b"], "source_commits": ["601c01e08"], "source_entry_id": "9.3.5/changes/004", "db_id": "fedab52c93a87fca93f07ce5578f54d9", "patch_ids": ["be63ecf3ca60bc501865f95b1a663210"], "statement_hash": "def835604a6dace9bf61c26a054e374964e1352d8428f232acb25e794b113b19", "relations": [{"rule": 2, "type": "equivalent", "target": "5425fcaaa9bd29ad257e597861d9667b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "def835604a6dace9bf61c26a054e374964e1352d8428f232acb25e794b113b19"}}, {"rule": 2, "type": "equivalent", "target": "5a9b0ae5835cea90e10cdfaf0e83b577", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "def835604a6dace9bf61c26a054e374964e1352d8428f232acb25e794b113b19"}}, {"rule": 2, "type": "equivalent", "target": "979dc6be64dc95c5598f2e4eb26071f6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "def835604a6dace9bf61c26a054e374964e1352d8428f232acb25e794b113b19"}}], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "5425fcaaa9bd29ad257e597861d9667b", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Don't clear the right-link of a GiST index page while replaying updates from WAL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "def835604a6dace9bf61c26a054e374964e1352d8428f232acb25e794b113b19"}, "url": "/docs/compare/?release=9.2.9#9.2.9-17edac81833aeb37", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "5a9b0ae5835cea90e10cdfaf0e83b577", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Don't clear the right-link of a GiST index page while replaying updates from WAL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "def835604a6dace9bf61c26a054e374964e1352d8428f232acb25e794b113b19"}, "url": "/docs/compare/?release=9.1.14#9.1.14-17edac81833aeb37", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "979dc6be64dc95c5598f2e4eb26071f6", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Don't clear the right-link of a GiST index page while replaying updates from WAL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "def835604a6dace9bf61c26a054e374964e1352d8428f232acb25e794b113b19"}, "url": "/docs/compare/?release=9.0.18#9.0.18-17edac81833aeb37", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-b1410ca10b61eb52", "cves": [], "html": "Fix corner-case infinite loop during insertion into an SP-GiST text index (Tom Lane)
", "text": "Fix corner-case infinite loop during insertion into an SP-GiST text index (Tom Lane)", "title": "Fix corner-case infinite loop during insertion into an SP-GiST text index", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "bab566d99881200bd3ffdd03d690b57c42b725c66209ac47d6d2c43d15449f48", "section_path": ["Changes"], "commit_groups": [["717c116f1", "93328b2df", "c170655cc"]], "identity_text": "Fix corner-case infinite loop during insertion into an SP-GiST text index (Tom Lane)", "commit_aliases": ["717c116f1", "93328b2df", "c170655cc"], "source_commits": ["717c116f1"], "source_entry_id": "9.3.5/changes/005", "db_id": "b1c7bceaf36d10d7b51d6c06c18c6a65", "patch_ids": ["412d3eecadc981cd90268b71e6fe525f"], "statement_hash": "32152d4528e8561a4549a029ccc18a16a7372bdd7ce8db4d8c6298fdc9d4a2e0", "relations": [{"rule": 2, "type": "equivalent", "target": "b4d9612e11b01921602c7b39aef2f076", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "32152d4528e8561a4549a029ccc18a16a7372bdd7ce8db4d8c6298fdc9d4a2e0"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "b4d9612e11b01921602c7b39aef2f076", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix corner-case infinite loop during insertion into an SP-GiST text index", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "32152d4528e8561a4549a029ccc18a16a7372bdd7ce8db4d8c6298fdc9d4a2e0"}, "url": "/docs/compare/?release=9.2.9#9.2.9-b1410ca10b61eb52", "source_url": "/docs/release/9.2.9/#AEN112895"}]}, {"id": "9.3.5-0884332108c1e2bf", "cves": [], "html": "Fix incorrect answers from SP-GiST index searches with -|- (range adjacency) operator (Heikki Linnakangas)
", "text": "Fix incorrect answers from SP-GiST index searches with -|- (range adjacency) operator (Heikki Linnakangas)", "title": "Fix incorrect answers from SP-GiST index searches with -|- (range adjacency) operator", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "271f203f3ee25dd9971cedf15a49e866873d1a266b733f3b520a3dee0c030612", "section_path": ["Changes"], "commit_groups": [["1264ef31a", "9b3ef66af", "a4867d041"]], "identity_text": "Fix incorrect answers from SP-GiST index searches with -|- (range adjacency) operator (Heikki Linnakangas)", "commit_aliases": ["1264ef31a", "9b3ef66af", "a4867d041"], "source_commits": ["a4867d041"], "source_entry_id": "9.3.5/changes/006", "db_id": "fded549efa16387b3abcf5c44e73d76b", "patch_ids": ["6bc355fc67d053a11732ca4f0e5f501a"], "statement_hash": "a44dab89f5ef0d082a10e2af7c192d3919d525f3dcd0fe7a0bfcc17e88fcd705", "relations": [], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.5-f263e474d7b4c151", "cves": [], "html": "Fix wraparound handling for pg_multixact/members (Álvaro Herrera)
", "text": "Fix wraparound handling for pg_multixact/members (Álvaro Herrera)", "title": "Fix wraparound handling for pg_multixact/members", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "12fcdfd793741e6d46daa67e64f439cea69b1c400c877c2639d6178b91b8ac74", "section_path": ["Changes"], "commit_groups": [["167a2535f", "b0b263baa"]], "identity_text": "Fix wraparound handling for pg_multixact/members (Álvaro Herrera)", "commit_aliases": ["167a2535f", "b0b263baa"], "source_commits": ["167a2535f"], "source_entry_id": "9.3.5/changes/007", "db_id": "e3c7e81269b7cb866b3916b403fc69dd", "patch_ids": ["b24b3eaf3fd8b0e893ac8a08458e3dac"], "statement_hash": "ea25d13cd6c3282c816b9180aeda9865e0204c813829fa31515124a39b029bf2", "relations": [], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.5-4cbce9b49b28ae68", "cves": [], "html": "Truncate pg_multixact during checkpoints, not during VACUUM (Álvaro Herrera)
\nThis change ensures that pg_multixact segments can't be removed if they'd still be needed during WAL replay after a crash.
", "text": "Truncate pg_multixact during checkpoints, not during VACUUM (Álvaro Herrera) This change ensures that pg_multixact segments can't be removed if they'd still be needed during WAL replay after a crash.", "title": "Truncate pg_multixact during checkpoints, not during VACUUM", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "68a1809e359b6cec8a98fdf99249c9d64102fd123bd8cc8045448e46a636ca8f", "section_path": ["Changes"], "commit_groups": [["56f86bb76", "9a28c3752", "f741300c9"]], "identity_text": "Truncate pg_multixact during checkpoints, not during VACUUM (Álvaro Herrera) This change ensures that pg_multixact segments can't be removed if they'd still be needed during WAL replay after a crash.", "commit_aliases": ["56f86bb76", "9a28c3752", "f741300c9"], "source_commits": ["9a28c3752"], "source_entry_id": "9.3.5/changes/008", "db_id": "162bb83877dad11a2097460b7b11b8eb", "patch_ids": ["b4293433cb0d5e0a46d763fa4072ffde"], "statement_hash": "888727f14045defb326a785cd35dcf9a854c6f23aee581dde85aacc790bf9160", "relations": [], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.5-383e5733feddbec0", "cves": [], "html": "Fix possible inconsistency of all-visible flags after WAL recovery (Heikki Linnakangas)
", "text": "Fix possible inconsistency of all-visible flags after WAL recovery (Heikki Linnakangas)", "title": "Fix possible inconsistency of all-visible flags after WAL recovery", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "9883c2bcf6bbbbd919a951aa2eb0dba0536a15a9f476b5ea71f45e337c50b483", "section_path": ["Changes"], "commit_groups": [["2a8e1ac59", "95aa823eb"]], "identity_text": "Fix possible inconsistency of all-visible flags after WAL recovery (Heikki Linnakangas)", "commit_aliases": ["2a8e1ac59", "95aa823eb"], "source_commits": ["95aa823eb"], "source_entry_id": "9.3.5/changes/009", "db_id": "55667e0de6bb68f6b173d23f7ea3dbf4", "patch_ids": ["45c4e2edb313f3e86c4fc37540822b5f"], "statement_hash": "97e7cdc6d4f3fac63942061372ebb0e8ff9ace98aba07057bfb3193e7f06e5f2", "relations": [], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.5-039e6d024ef5b91f", "cves": [], "html": "Fix possibly-incorrect cache invalidation during nested calls to ReceiveSharedInvalidMessages (Andres Freund)
Fix race condition when updating a tuple concurrently locked by another process (Andres Freund, Álvaro Herrera)
", "text": "Fix race condition when updating a tuple concurrently locked by another process (Andres Freund, Álvaro Herrera)", "title": "Fix race condition when updating a tuple concurrently locked by another process", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "2681e12f7b8ed6ea74fee59addb97b1038da88210f1a7943609c40fe0e1898c5", "section_path": ["Changes"], "commit_groups": [["1a917ae86", "c0bd128c8"]], "identity_text": "Fix race condition when updating a tuple concurrently locked by another process (Andres Freund, Álvaro Herrera)", "commit_aliases": ["1a917ae86", "c0bd128c8"], "source_commits": ["c0bd128c8"], "source_entry_id": "9.3.5/changes/011", "db_id": "a2a7194f85e1e8b1ee6c2b144edb5746", "patch_ids": ["13c2be202c9aed3efa0567bdce5aaee3"], "statement_hash": "e38f733c5f48f7aea89076d6840cee7e665282cb71959568e9eebd8f4304bc91", "relations": [], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.5-63779d987f2fa1fa", "cves": [], "html": "Fix \"could not find pathkey item to sort\" planner failures with UNION ALL over subqueries reading from tables with inheritance children (Tom Lane)
", "text": "Fix \"could not find pathkey item to sort\" planner failures with UNION ALL over subqueries reading from tables with inheritance children (Tom Lane)", "title": "Fix \"could not find pathkey item to sort\" planner failures with UNION ALL over subqueries reading from tables with inheritance children", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "f2f761f70854a0a3b4670c3e4745ae224af0cfa4b83cedcd457e7f11d44ad88c", "section_path": ["Changes"], "commit_groups": [["0cf16686b", "555d0b200", "a2db7b7d0"]], "identity_text": "Fix could not find pathkey item to sort planner failures with UNION ALL over subqueries reading from tables with inheritance children (Tom Lane)", "commit_aliases": ["0cf16686b", "555d0b200", "a2db7b7d0"], "source_commits": ["a2db7b7d0"], "source_entry_id": "9.3.5/changes/012", "db_id": "19ad847390bbccd2556bd202966fe736", "patch_ids": ["75b8ba42f30411d144bb6d57151d2481"], "statement_hash": "1c3a3b845c2829e8b7e7b646d7f2fa9b6d65f769c183643981b22e4bbec939fc", "relations": [{"rule": 2, "type": "equivalent", "target": "4b8b73c22f7dc41abb2dd702bebf1e01", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1c3a3b845c2829e8b7e7b646d7f2fa9b6d65f769c183643981b22e4bbec939fc"}}, {"rule": 2, "type": "equivalent", "target": "f5fd1221762c82e9a95f2d0fe6e0f23a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1c3a3b845c2829e8b7e7b646d7f2fa9b6d65f769c183643981b22e4bbec939fc"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "f5fd1221762c82e9a95f2d0fe6e0f23a", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix \"could not find pathkey item to sort\" planner failures with UNION ALL over subqueries reading from tables with inheritance children", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1c3a3b845c2829e8b7e7b646d7f2fa9b6d65f769c183643981b22e4bbec939fc"}, "url": "/docs/compare/?release=9.2.9#9.2.9-63779d987f2fa1fa", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "4b8b73c22f7dc41abb2dd702bebf1e01", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Fix \"could not find pathkey item to sort\" planner failures with UNION ALL over subqueries reading from tables with inheritance children", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1c3a3b845c2829e8b7e7b646d7f2fa9b6d65f769c183643981b22e4bbec939fc"}, "url": "/docs/compare/?release=9.1.14#9.1.14-63779d987f2fa1fa", "source_url": "/docs/release/9.1.14/#AEN108337"}]}, {"id": "9.3.5-794e1c9af7e00de0", "cves": [], "html": "Don't assume a subquery's output is unique if there's a set-returning function in its targetlist (David Rowley)
\nThis oversight could lead to misoptimization of constructs like WHERE x IN (SELECT y, generate_series(1,10) FROM t GROUP BY y).
", "text": "Don't assume a subquery's output is unique if there's a set-returning function in its targetlist (David Rowley) This oversight could lead to misoptimization of constructs like WHERE x IN (SELECT y, generate_series(1,10) FROM t GROUP BY y).", "title": "Don't assume a subquery's output is unique if there's a set-returning function in its targetlist", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "e3cdb5e885713fbb6e916a461cea8a5edd6d8b8eca4f8d00b6d8d07c14c51ad3", "section_path": ["Changes"], "commit_groups": [["189bd09cb", "2865d5952", "2e7469dc8", "6d36aee5b", "9e2f2d7a0", "ac45aa1dd", "fa21a760b"]], "identity_text": "Don't assume a subquery's output is unique if there's a set-returning function in its targetlist (David Rowley) This oversight could lead to misoptimization of constructs like WHERE x IN (SELECT y, generate_series(1,10) FROM t GROUP BY y).", "commit_aliases": ["189bd09cb", "2865d5952", "2e7469dc8", "6d36aee5b", "9e2f2d7a0", "ac45aa1dd", "fa21a760b"], "source_commits": ["6d36aee5b"], "source_entry_id": "9.3.5/changes/013", "db_id": "84948cbdcbf960a5938ea2bb5322a55f", "patch_ids": ["730b6738a71084712b6c3e7a69efc5fb"], "statement_hash": "8b3826bda5d95d5a7ef8820f8e0f7a01f1b7473cb23bd437ff1eb481ac76cd8f", "relations": [{"rule": 2, "type": "equivalent", "target": "11db6efc9d4ec2ae33c51444e0bb7f14", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8b3826bda5d95d5a7ef8820f8e0f7a01f1b7473cb23bd437ff1eb481ac76cd8f"}}, {"rule": 2, "type": "equivalent", "target": "3f0de4ee4478bf34317072fe1e1d1d75", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8b3826bda5d95d5a7ef8820f8e0f7a01f1b7473cb23bd437ff1eb481ac76cd8f"}}, {"rule": 2, "type": "equivalent", "target": "4091f69cd098522abf12a3f99c116f25", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8b3826bda5d95d5a7ef8820f8e0f7a01f1b7473cb23bd437ff1eb481ac76cd8f"}}], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "4091f69cd098522abf12a3f99c116f25", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Don't assume a subquery's output is unique if there's a set-returning function in its targetlist", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8b3826bda5d95d5a7ef8820f8e0f7a01f1b7473cb23bd437ff1eb481ac76cd8f"}, "url": "/docs/compare/?release=9.2.9#9.2.9-794e1c9af7e00de0", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "3f0de4ee4478bf34317072fe1e1d1d75", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Don't assume a subquery's output is unique if there's a set-returning function in its targetlist", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8b3826bda5d95d5a7ef8820f8e0f7a01f1b7473cb23bd437ff1eb481ac76cd8f"}, "url": "/docs/compare/?release=9.1.14#9.1.14-794e1c9af7e00de0", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "11db6efc9d4ec2ae33c51444e0bb7f14", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Don't assume a subquery's output is unique if there's a set-returning function in its targetlist", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8b3826bda5d95d5a7ef8820f8e0f7a01f1b7473cb23bd437ff1eb481ac76cd8f"}, "url": "/docs/compare/?release=9.0.18#9.0.18-794e1c9af7e00de0", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-6c5942926f7e4d27", "cves": [], "html": "Improve planner to drop constant-NULL inputs of AND/OR when possible (Tom Lane)
\nThis change fixes some cases where the more aggressive parameter substitution done by 9.2 and later can lead to a worse plan than older versions produced.
", "text": "Improve planner to drop constant-NULL inputs of AND/OR when possible (Tom Lane) This change fixes some cases where the more aggressive parameter substitution done by 9.2 and later can lead to a worse plan than older versions produced.", "title": "Improve planner to drop constant-NULL inputs of AND/OR when possible", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "58af886fa15f716f4de13e39688e39c0bcf5bbc7930745f1fade0206ec585f61", "section_path": ["Changes"], "commit_groups": [["0901dbab3", "150a44e83", "95811032d"]], "identity_text": "Improve planner to drop constant-NULL inputs of AND/OR when possible (Tom Lane) This change fixes some cases where the more aggressive parameter substitution done by 9.2 and later can lead to a worse plan than older versions produced.", "commit_aliases": ["0901dbab3", "150a44e83", "95811032d"], "source_commits": ["150a44e83"], "source_entry_id": "9.3.5/changes/014", "db_id": "f8cc8bde41a89cf1bbbd3110ccf9ad45", "patch_ids": ["ebff781a7ac87222192db7534ca91d11"], "statement_hash": "30e6c742d1b2e76fb7e5465108675e5a8100382d8df30e6232e16a4aa7a61249", "relations": [{"rule": 2, "type": "equivalent", "target": "ba501da22c351fce63fa7d3c61f8960b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "30e6c742d1b2e76fb7e5465108675e5a8100382d8df30e6232e16a4aa7a61249"}}], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "ba501da22c351fce63fa7d3c61f8960b", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Improve planner to drop constant-NULL inputs of AND/OR when possible", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "30e6c742d1b2e76fb7e5465108675e5a8100382d8df30e6232e16a4aa7a61249"}, "url": "/docs/compare/?release=9.2.9#9.2.9-6c5942926f7e4d27", "source_url": "/docs/release/9.2.9/#AEN112895"}]}, {"id": "9.3.5-2794a6a79cb486b1", "cves": [], "html": "Ensure that the planner sees equivalent VARIADIC and non-VARIADIC function calls as equivalent (Tom Lane)
\nThis bug could for example result in failure to use expression indexes involving variadic functions. It might be necessary to re-create such indexes, and/or re-create views including variadic function calls that should match the indexes, for the fix to be effective for existing 9.3 installations.
", "text": "Ensure that the planner sees equivalent VARIADIC and non-VARIADIC function calls as equivalent (Tom Lane) This bug could for example result in failure to use expression indexes involving variadic functions. It might be necessary to re-create such indexes, and/or re-create views including variadic function calls that should match the indexes, for the fix to be effective for existing 9.3 installations.", "title": "Ensure that the planner sees equivalent VARIADIC and non-VARIADIC function calls as equivalent", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "161549eb4bde9f818571b2ef8be6f8b76873bb7124699833cde545e90ee531a8", "section_path": ["Changes"], "commit_groups": [["c7b353959", "d359f71ac"]], "identity_text": "Ensure that the planner sees equivalent VARIADIC and non-VARIADIC function calls as equivalent (Tom Lane) This bug could for example result in failure to use expression indexes involving variadic functions. It might be necessary to re-create such indexes, and/or re-create views including variadic function calls that should match the indexes, for the fix to be effective for existing 9.3 installations.", "commit_aliases": ["c7b353959", "d359f71ac"], "source_commits": ["d359f71ac"], "source_entry_id": "9.3.5/changes/015", "db_id": "0f747306dd4b8c4a96175fd82dc61444", "patch_ids": ["0c7ca875b0eb838718cb245c05954a86"], "statement_hash": "f4701c19fa992c8ea9aa60a5efccc4aa59baeacb4b07a2c44129a08198fd3d92", "relations": [], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.5-859193ba964b165b", "cves": [], "html": "Fix handling of nested JSON objects in json_populate_recordset() and friends (Michael Paquier, Tom Lane)
A nested JSON object could result in previous fields of the parent object not being shown in the output.
", "text": "Fix handling of nested JSON objects in json_populate_recordset() and friends (Michael Paquier, Tom Lane) A nested JSON object could result in previous fields of the parent object not being shown in the output.", "title": "Fix handling of nested JSON objects in json_populate_recordset() and friends", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "1d6500d2a31549e0e7d4cab6386b599ac5758b7095a7b01f8e81018e9e96fe7c", "section_path": ["Changes"], "commit_groups": [["57d8c1270", "a1fc36495", "a331512de"]], "identity_text": "Fix handling of nested JSON objects in json_populate_recordset() and friends (Michael Paquier, Tom Lane) A nested JSON object could result in previous fields of the parent object not being shown in the output.", "commit_aliases": ["57d8c1270", "a1fc36495", "a331512de"], "source_commits": ["a1fc36495"], "source_entry_id": "9.3.5/changes/016", "db_id": "41c3cec18c5aed70809162aa32f1cddb", "patch_ids": ["e8b2ea1c1f0f797ef3884a42a9e9aa91"], "statement_hash": "db2b02ba468fc5359d6564c76fe8d3268c0325a863b31bcd677c5f0f99bbe076", "relations": [], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.5-a841b0c45405dfb9", "cves": [], "html": "Fix identification of input type category in to_json() and friends (Tom Lane)
This is known to have led to inadequate quoting of money fields in the JSON result, and there may have been wrong results for other data types as well.
", "text": "Fix identification of input type category in to_json() and friends (Tom Lane) This is known to have led to inadequate quoting of money fields in the JSON result, and there may have been wrong results for other data types as well.", "title": "Fix identification of input type category in to_json() and friends", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "abde78964a68266340dbed611e9f2cfc9d6b0a8b9a5801964fd4906d5f66849e", "section_path": ["Changes"], "commit_groups": [["0ca6bda8e", "13c679995", "25c933c5c"]], "identity_text": "Fix identification of input type category in to_json() and friends (Tom Lane) This is known to have led to inadequate quoting of money fields in the JSON result, and there may have been wrong results for other data types as well.", "commit_aliases": ["0ca6bda8e", "13c679995", "25c933c5c"], "source_commits": ["13c679995"], "source_entry_id": "9.3.5/changes/017", "db_id": "a8cb266fd3926dcba458a79e89f190ea", "patch_ids": ["e9c6180c20dc089b222b2bd2934c20db"], "statement_hash": "d36c02c46b4612d9d671e59c20a3e3c9653a335301fc897fbda1a28e9ca9abb3", "relations": [{"rule": 2, "type": "equivalent", "target": "eed7da4ff3cf10798fdd66dccbb65d09", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d36c02c46b4612d9d671e59c20a3e3c9653a335301fc897fbda1a28e9ca9abb3"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "eed7da4ff3cf10798fdd66dccbb65d09", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix identification of input type category in to_json() and friends", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d36c02c46b4612d9d671e59c20a3e3c9653a335301fc897fbda1a28e9ca9abb3"}, "url": "/docs/compare/?release=9.2.9#9.2.9-a841b0c45405dfb9", "source_url": "/docs/release/9.2.9/#AEN112895"}]}, {"id": "9.3.5-bd8a5f1e089b76ed", "cves": [], "html": "Fix failure to detoast fields in composite elements of structured types (Tom Lane)
\nThis corrects cases where TOAST pointers could be copied into other tables without being dereferenced. If the original data is later deleted, it would lead to errors like \"missing chunk number 0 for toast value ...\" when the now-dangling pointer is used.
", "text": "Fix failure to detoast fields in composite elements of structured types (Tom Lane) This corrects cases where TOAST pointers could be copied into other tables without being dereferenced. If the original data is later deleted, it would lead to errors like \"missing chunk number 0 for toast value ...\" when the now-dangling pointer is used.", "title": "Fix failure to detoast fields in composite elements of structured types", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "38154f67a0e2975afbac7fb88e7afa4b9f409aa658c945df42c14da9fab43137", "section_path": ["Changes"], "commit_groups": [["3f8c8e3c6", "70debcf09", "7a4f114f3", "8c43980a1", "b72e90bc3", "db1fdc945"]], "identity_text": "Fix failure to detoast fields in composite elements of structured types (Tom Lane) This corrects cases where TOAST pointers could be copied into other tables without being dereferenced. If the original data is later deleted, it would lead to errors like missing chunk number 0 for toast value ... when the now-dangling pointer is used.", "commit_aliases": ["3f8c8e3c6", "70debcf09", "7a4f114f3", "8c43980a1", "b72e90bc3", "db1fdc945"], "source_commits": ["b72e90bc3"], "source_entry_id": "9.3.5/changes/018", "db_id": "bb5e5d0ca78271a17828f482f87c7451", "patch_ids": ["a441d535c1efd6f6c59999ccf14f1349"], "statement_hash": "a0e8b940d866af211905ef8b5188ad06eeeb9f6d59793cca6810091274d49204", "relations": [{"rule": 2, "type": "equivalent", "target": "7df54a2467eba0e9a74d4a38f1f98353", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a0e8b940d866af211905ef8b5188ad06eeeb9f6d59793cca6810091274d49204"}}, {"rule": 2, "type": "equivalent", "target": "d5cdc42fb546efa978e3758bf6fabe38", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a0e8b940d866af211905ef8b5188ad06eeeb9f6d59793cca6810091274d49204"}}, {"rule": 2, "type": "equivalent", "target": "eaec842655e68490e08ca8bb73072d29", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a0e8b940d866af211905ef8b5188ad06eeeb9f6d59793cca6810091274d49204"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "7df54a2467eba0e9a74d4a38f1f98353", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix failure to detoast fields in composite elements of structured types", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a0e8b940d866af211905ef8b5188ad06eeeb9f6d59793cca6810091274d49204"}, "url": "/docs/compare/?release=9.2.9#9.2.9-bd8a5f1e089b76ed", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "d5cdc42fb546efa978e3758bf6fabe38", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Fix failure to detoast fields in composite elements of structured types", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a0e8b940d866af211905ef8b5188ad06eeeb9f6d59793cca6810091274d49204"}, "url": "/docs/compare/?release=9.1.14#9.1.14-bd8a5f1e089b76ed", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "eaec842655e68490e08ca8bb73072d29", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Fix failure to detoast fields in composite elements of structured types", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a0e8b940d866af211905ef8b5188ad06eeeb9f6d59793cca6810091274d49204"}, "url": "/docs/compare/?release=9.0.18#9.0.18-bd8a5f1e089b76ed", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-ce58020dd27adaa1", "cves": [], "html": "Fix \"record type has not been registered\" failures with whole-row references to the output of Append plan nodes (Tom Lane)
", "text": "Fix \"record type has not been registered\" failures with whole-row references to the output of Append plan nodes (Tom Lane)", "title": "Fix \"record type has not been registered\" failures with whole-row references to the output of Append plan nodes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "0424902d4b6849536a3cbce8fc811183ae475434144c17ff46a02dbd01b5b845", "section_path": ["Changes"], "commit_groups": [["261f954e7", "a81fbcfb3", "b77e6b959", "c45841f9e", "cd8ba91a0", "d68581483", "f280eff94"]], "identity_text": "Fix record type has not been registered failures with whole-row references to the output of Append plan nodes (Tom Lane)", "commit_aliases": ["261f954e7", "a81fbcfb3", "b77e6b959", "c45841f9e", "cd8ba91a0", "d68581483", "f280eff94"], "source_commits": ["b77e6b959"], "source_entry_id": "9.3.5/changes/019", "db_id": "a5bff8c32cfcc751d43d2d9715dbfc69", "patch_ids": ["8dd6ecdf6fd56bfe113db40fbb0a64ef"], "statement_hash": "907e00465ed3de22da88d87431176f161c3e33879f9d1561a047130e5f1d128c", "relations": [{"rule": 2, "type": "equivalent", "target": "943f89e82d9b9416e4544d7a538b55cf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "907e00465ed3de22da88d87431176f161c3e33879f9d1561a047130e5f1d128c"}}, {"rule": 2, "type": "equivalent", "target": "b6b468de37aae5bd9ac064219792b112", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "907e00465ed3de22da88d87431176f161c3e33879f9d1561a047130e5f1d128c"}}, {"rule": 2, "type": "equivalent", "target": "e13b6c867000757d183dd0b92153c3c0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "907e00465ed3de22da88d87431176f161c3e33879f9d1561a047130e5f1d128c"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "943f89e82d9b9416e4544d7a538b55cf", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix \"record type has not been registered\" failures with whole-row references to the output of Append plan nodes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "907e00465ed3de22da88d87431176f161c3e33879f9d1561a047130e5f1d128c"}, "url": "/docs/compare/?release=9.2.9#9.2.9-ce58020dd27adaa1", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "e13b6c867000757d183dd0b92153c3c0", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Fix \"record type has not been registered\" failures with whole-row references to the output of Append plan nodes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "907e00465ed3de22da88d87431176f161c3e33879f9d1561a047130e5f1d128c"}, "url": "/docs/compare/?release=9.1.14#9.1.14-ce58020dd27adaa1", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "b6b468de37aae5bd9ac064219792b112", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Fix \"record type has not been registered\" failures with whole-row references to the output of Append plan nodes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "907e00465ed3de22da88d87431176f161c3e33879f9d1561a047130e5f1d128c"}, "url": "/docs/compare/?release=9.0.18#9.0.18-ce58020dd27adaa1", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-275fc38a83d85728", "cves": [], "html": "Fix possible crash when invoking a user-defined function while rewinding a cursor (Tom Lane)
", "text": "Fix possible crash when invoking a user-defined function while rewinding a cursor (Tom Lane)", "title": "Fix possible crash when invoking a user-defined function while rewinding a cursor", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "94abbbcfa564b8a44185412e42da300f7c31a6ad876e090f3b2672ced904f489", "section_path": ["Changes"], "commit_groups": [["022b5f2b2", "04e5025be", "229101db4", "2a527baa3", "7f66ade71", "fc58c39d4"]], "identity_text": "Fix possible crash when invoking a user-defined function while rewinding a cursor (Tom Lane)", "commit_aliases": ["022b5f2b2", "04e5025be", "229101db4", "2a527baa3", "7f66ade71", "fc58c39d4"], "source_commits": ["fc58c39d4"], "source_entry_id": "9.3.5/changes/020", "db_id": "03176a786830cf8e48a92ec1d8f49cd5", "patch_ids": ["0b56454471885c7b44f40767a72cd06b"], "statement_hash": "7e47f72c2cb634cac94f6dda8abf3e611183e97495532a610813a79492b4f80a", "relations": [{"rule": 2, "type": "equivalent", "target": "6794b5b236dec9c71441bd8d31d2de11", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7e47f72c2cb634cac94f6dda8abf3e611183e97495532a610813a79492b4f80a"}}, {"rule": 2, "type": "equivalent", "target": "7a33bc45d19644a4fa8bacb9cd4cde75", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7e47f72c2cb634cac94f6dda8abf3e611183e97495532a610813a79492b4f80a"}}, {"rule": 2, "type": "equivalent", "target": "f0683b60085c78c315c325a0a29373b7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7e47f72c2cb634cac94f6dda8abf3e611183e97495532a610813a79492b4f80a"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "6794b5b236dec9c71441bd8d31d2de11", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix possible crash when invoking a user-defined function while rewinding a cursor", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7e47f72c2cb634cac94f6dda8abf3e611183e97495532a610813a79492b4f80a"}, "url": "/docs/compare/?release=9.2.9#9.2.9-275fc38a83d85728", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "f0683b60085c78c315c325a0a29373b7", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Fix possible crash when invoking a user-defined function while rewinding a cursor", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7e47f72c2cb634cac94f6dda8abf3e611183e97495532a610813a79492b4f80a"}, "url": "/docs/compare/?release=9.1.14#9.1.14-275fc38a83d85728", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "7a33bc45d19644a4fa8bacb9cd4cde75", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Fix possible crash when invoking a user-defined function while rewinding a cursor", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7e47f72c2cb634cac94f6dda8abf3e611183e97495532a610813a79492b4f80a"}, "url": "/docs/compare/?release=9.0.18#9.0.18-275fc38a83d85728", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-0003476c6b5b99a0", "cves": [], "html": "Fix query-lifespan memory leak while evaluating the arguments for a function in FROM (Tom Lane)
", "text": "Fix query-lifespan memory leak while evaluating the arguments for a function in FROM (Tom Lane)", "title": "Fix query-lifespan memory leak while evaluating the arguments for a function in FROM", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "ec6ab20fb05aaf60ca7ba16dd99a583f75f065994fdcda495c91fb83fac0abcb", "section_path": ["Changes"], "commit_groups": [["06d5eacbc", "1044e79a0", "45b0f3572", "83131e634", "b568d3836", "c1f8fb9bf", "d297c91d4"]], "identity_text": "Fix query-lifespan memory leak while evaluating the arguments for a function in FROM (Tom Lane)", "commit_aliases": ["06d5eacbc", "1044e79a0", "45b0f3572", "83131e634", "b568d3836", "c1f8fb9bf", "d297c91d4"], "source_commits": ["c1f8fb9bf"], "source_entry_id": "9.3.5/changes/021", "db_id": "41cd78a1fbcdab8a53229962882ca0b4", "patch_ids": ["e89723b778c58a3e776fb321802adc3b"], "statement_hash": "86384f1f46f7632ad7228fd92790058d972a5e5b6f320f413866e3c433795999", "relations": [{"rule": 2, "type": "equivalent", "target": "1a048d9e7e109fe833d9e6a9e0540084", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86384f1f46f7632ad7228fd92790058d972a5e5b6f320f413866e3c433795999"}}, {"rule": 2, "type": "equivalent", "target": "2c789e694ad162374eea2a3cecb509a4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86384f1f46f7632ad7228fd92790058d972a5e5b6f320f413866e3c433795999"}}, {"rule": 2, "type": "equivalent", "target": "c32372665831e6929e90b6d8512dcbee", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86384f1f46f7632ad7228fd92790058d972a5e5b6f320f413866e3c433795999"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2c789e694ad162374eea2a3cecb509a4", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix query-lifespan memory leak while evaluating the arguments for a function in FROM", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86384f1f46f7632ad7228fd92790058d972a5e5b6f320f413866e3c433795999"}, "url": "/docs/compare/?release=9.2.9#9.2.9-0003476c6b5b99a0", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "1a048d9e7e109fe833d9e6a9e0540084", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Fix query-lifespan memory leak while evaluating the arguments for a function in FROM", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86384f1f46f7632ad7228fd92790058d972a5e5b6f320f413866e3c433795999"}, "url": "/docs/compare/?release=9.1.14#9.1.14-0003476c6b5b99a0", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "c32372665831e6929e90b6d8512dcbee", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Fix query-lifespan memory leak while evaluating the arguments for a function in FROM", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86384f1f46f7632ad7228fd92790058d972a5e5b6f320f413866e3c433795999"}, "url": "/docs/compare/?release=9.0.18#9.0.18-0003476c6b5b99a0", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-7908617274f72faa", "cves": [], "html": "Fix session-lifespan memory leaks in regular-expression processing (Tom Lane, Arthur O'Dwyer, Greg Stark)
", "text": "Fix session-lifespan memory leaks in regular-expression processing (Tom Lane, Arthur O'Dwyer, Greg Stark)", "title": "Fix session-lifespan memory leaks in regular-expression processing", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "9aaead3bfbaf099a0fe7b9fdd4175a27c0f4a84924180f8a75e516025da25d4b", "section_path": ["Changes"], "commit_groups": [["1567e659a", "4a66f0f2d", "5ef588b22", "8a817785a", "a223b9e36", "b8c24f7ab", "e0a233744"]], "identity_text": "Fix session-lifespan memory leaks in regular-expression processing (Tom Lane, Arthur O'Dwyer, Greg Stark)", "commit_aliases": ["1567e659a", "4a66f0f2d", "5ef588b22", "8a817785a", "a223b9e36", "b8c24f7ab", "e0a233744"], "source_commits": ["5ef588b22"], "source_entry_id": "9.3.5/changes/022", "db_id": "eeb0bf25c9ae2d48c7186e65ae9b1ff9", "patch_ids": ["3b857b32bc3201bdd9749ab88ba4a01a"], "statement_hash": "5be82c5605f010d5bbba9389d1e8e446f5d64d76581c451a8d6256265a3758a0", "relations": [{"rule": 2, "type": "equivalent", "target": "0b4fd6206cb4bbf88806d495bbf3cc90", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5be82c5605f010d5bbba9389d1e8e446f5d64d76581c451a8d6256265a3758a0"}}, {"rule": 2, "type": "equivalent", "target": "25991b347a474942acebc8de0eaff080", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5be82c5605f010d5bbba9389d1e8e446f5d64d76581c451a8d6256265a3758a0"}}, {"rule": 2, "type": "equivalent", "target": "383752e01bb4550a7f1914986b8e0c3a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5be82c5605f010d5bbba9389d1e8e446f5d64d76581c451a8d6256265a3758a0"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "25991b347a474942acebc8de0eaff080", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix session-lifespan memory leaks in regular-expression processing", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5be82c5605f010d5bbba9389d1e8e446f5d64d76581c451a8d6256265a3758a0"}, "url": "/docs/compare/?release=9.2.9#9.2.9-7908617274f72faa", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "0b4fd6206cb4bbf88806d495bbf3cc90", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Fix session-lifespan memory leaks in regular-expression processing", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5be82c5605f010d5bbba9389d1e8e446f5d64d76581c451a8d6256265a3758a0"}, "url": "/docs/compare/?release=9.1.14#9.1.14-7908617274f72faa", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "383752e01bb4550a7f1914986b8e0c3a", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Fix session-lifespan memory leaks in regular-expression processing", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5be82c5605f010d5bbba9389d1e8e446f5d64d76581c451a8d6256265a3758a0"}, "url": "/docs/compare/?release=9.0.18#9.0.18-7908617274f72faa", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-65c252cd02f8d46a", "cves": [], "html": "Fix data encoding error in hungarian.stop (Tom Lane)
", "text": "Fix data encoding error in hungarian.stop (Tom Lane)", "title": "Fix data encoding error in hungarian.stop", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "48803e15e50bc09f82d0b004425a9f1eee128e173863da1282cb3111b1bd2921", "section_path": ["Changes"], "commit_groups": [["4d5ea4290", "62f134954", "7f9fbb842", "802323535", "87db9534a", "f3f40434b", "fd90b5d57"]], "identity_text": "Fix data encoding error in hungarian.stop (Tom Lane)", "commit_aliases": ["4d5ea4290", "62f134954", "7f9fbb842", "802323535", "87db9534a", "f3f40434b", "fd90b5d57"], "source_commits": ["87db9534a"], "source_entry_id": "9.3.5/changes/023", "db_id": "264f904d5d08ad625ac4fe46a29711e1", "patch_ids": ["63be7b008802dcac89b344d3178bc87e"], "statement_hash": "f036016e3ff0dd160b1087e2ecde2a6826685336921ee4cdd4fdcdbc9d06bdee", "relations": [{"rule": 2, "type": "equivalent", "target": "38ba3cd0011d5007ee11a447df513fa0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f036016e3ff0dd160b1087e2ecde2a6826685336921ee4cdd4fdcdbc9d06bdee"}}, {"rule": 2, "type": "equivalent", "target": "84ff1fd0250a21afab5aeeb41175a0a0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f036016e3ff0dd160b1087e2ecde2a6826685336921ee4cdd4fdcdbc9d06bdee"}}, {"rule": 2, "type": "equivalent", "target": "d02b618f97b84480c63ea8f630a9a517", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f036016e3ff0dd160b1087e2ecde2a6826685336921ee4cdd4fdcdbc9d06bdee"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "38ba3cd0011d5007ee11a447df513fa0", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix data encoding error in hungarian.stop", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f036016e3ff0dd160b1087e2ecde2a6826685336921ee4cdd4fdcdbc9d06bdee"}, "url": "/docs/compare/?release=9.2.9#9.2.9-65c252cd02f8d46a", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "84ff1fd0250a21afab5aeeb41175a0a0", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Fix data encoding error in hungarian.stop", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f036016e3ff0dd160b1087e2ecde2a6826685336921ee4cdd4fdcdbc9d06bdee"}, "url": "/docs/compare/?release=9.1.14#9.1.14-65c252cd02f8d46a", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "d02b618f97b84480c63ea8f630a9a517", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Fix data encoding error in hungarian.stop", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f036016e3ff0dd160b1087e2ecde2a6826685336921ee4cdd4fdcdbc9d06bdee"}, "url": "/docs/compare/?release=9.0.18#9.0.18-65c252cd02f8d46a", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-15dbd658baa16594", "cves": [], "html": "Prevent foreign tables from being created with OIDS when default_with_oids is true (Etsuro Fujita)
", "text": "Prevent foreign tables from being created with OIDS when default_with_oids is true (Etsuro Fujita)", "title": "Prevent foreign tables from being created with OIDS when default_with_oids is true", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "3570a586b71a647903ae03bfdc9612c8eb55d9591cb0b0e58095672e8540f386", "section_path": ["Changes"], "commit_groups": [["1818ae0a7", "1c9f9e888", "2a7512bc7", "a87a7dc8b", "dd1a5b09b"]], "identity_text": "Prevent foreign tables from being created with OIDS when guc-default-with-oids is true (Etsuro Fujita)", "commit_aliases": ["1818ae0a7", "1c9f9e888", "2a7512bc7", "a87a7dc8b", "dd1a5b09b"], "source_commits": ["2a7512bc7"], "source_entry_id": "9.3.5/changes/024", "db_id": "6e736cb3322b1f55e6dd7ad1a49ba51e", "patch_ids": ["3a11f770a5dcc909f1c0be690544f9e9"], "statement_hash": "0c5d6924e91115d2c06ede70d3eace773034fdcf29191aa60f505d152021f943", "relations": [{"rule": 2, "type": "equivalent", "target": "6e264876511a90aa898b99cbf552379e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0c5d6924e91115d2c06ede70d3eace773034fdcf29191aa60f505d152021f943"}}, {"rule": 2, "type": "equivalent", "target": "9ac3a9d83688f1efb8ed6afac4f6db50", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0c5d6924e91115d2c06ede70d3eace773034fdcf29191aa60f505d152021f943"}}], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "9ac3a9d83688f1efb8ed6afac4f6db50", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Prevent foreign tables from being created with OIDS when default_with_oids is true", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0c5d6924e91115d2c06ede70d3eace773034fdcf29191aa60f505d152021f943"}, "url": "/docs/compare/?release=9.2.9#9.2.9-15dbd658baa16594", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "6e264876511a90aa898b99cbf552379e", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Prevent foreign tables from being created with OIDS when default_with_oids is true", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0c5d6924e91115d2c06ede70d3eace773034fdcf29191aa60f505d152021f943"}, "url": "/docs/compare/?release=9.1.14#9.1.14-15dbd658baa16594", "source_url": "/docs/release/9.1.14/#AEN108337"}]}, {"id": "9.3.5-a0ab90a75c90466e", "cves": [], "html": "Fix liveness checks for rows that were inserted in the current transaction and then deleted by a now-rolled-back subtransaction (Andres Freund)
\nThis could cause problems (at least spurious warnings, and at worst an infinite loop) if CREATE INDEX or CLUSTER were done later in the same transaction.
", "text": "Fix liveness checks for rows that were inserted in the current transaction and then deleted by a now-rolled-back subtransaction (Andres Freund) This could cause problems (at least spurious warnings, and at worst an infinite loop) if CREATE INDEX or CLUSTER were done later in the same transaction.", "title": "Fix liveness checks for rows that were inserted in the current transaction and then deleted by a now-rolled-back subtransaction", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "7ae6868be95d9b4b8faa9b7d554e6deed0d34639df495ea2a884011b04019cf0", "section_path": ["Changes"], "commit_groups": [["037c6fb9f", "315442c01", "621a99a66", "6bf6e528a", "80d45ae4e", "edde59db1"]], "identity_text": "Fix liveness checks for rows that were inserted in the current transaction and then deleted by a now-rolled-back subtransaction (Andres Freund) This could cause problems (at least spurious warnings, and at worst an infinite loop) if CREATE INDEX or CLUSTER were done later in the same transaction.", "commit_aliases": ["037c6fb9f", "315442c01", "621a99a66", "6bf6e528a", "80d45ae4e", "edde59db1"], "source_commits": ["edde59db1"], "source_entry_id": "9.3.5/changes/025", "db_id": "116d8d34d4d0b4eff3945173d9a62e51", "patch_ids": ["1fddd448e2a854ce0097d6b37c84fa3e"], "statement_hash": "0407dc03f159e299ade1fec7314eb1de83d6c6fc23777bc71894d8ba15944a31", "relations": [{"rule": 2, "type": "equivalent", "target": "434f2385f9554696517f8f50bb5ecccd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0407dc03f159e299ade1fec7314eb1de83d6c6fc23777bc71894d8ba15944a31"}}, {"rule": 2, "type": "equivalent", "target": "b5fe3b8610961d74024c709d4db93170", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0407dc03f159e299ade1fec7314eb1de83d6c6fc23777bc71894d8ba15944a31"}}, {"rule": 2, "type": "equivalent", "target": "baf0f18b7d66cdd113769591a089af77", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0407dc03f159e299ade1fec7314eb1de83d6c6fc23777bc71894d8ba15944a31"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "baf0f18b7d66cdd113769591a089af77", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix liveness checks for rows that were inserted in the current transaction and then deleted by a now-rolled-back subtransaction", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0407dc03f159e299ade1fec7314eb1de83d6c6fc23777bc71894d8ba15944a31"}, "url": "/docs/compare/?release=9.2.9#9.2.9-a0ab90a75c90466e", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "434f2385f9554696517f8f50bb5ecccd", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Fix liveness checks for rows that were inserted in the current transaction and then deleted by a now-rolled-back subtransaction", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0407dc03f159e299ade1fec7314eb1de83d6c6fc23777bc71894d8ba15944a31"}, "url": "/docs/compare/?release=9.1.14#9.1.14-a0ab90a75c90466e", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "b5fe3b8610961d74024c709d4db93170", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Fix liveness checks for rows that were inserted in the current transaction and then deleted by a now-rolled-back subtransaction", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0407dc03f159e299ade1fec7314eb1de83d6c6fc23777bc71894d8ba15944a31"}, "url": "/docs/compare/?release=9.0.18#9.0.18-a0ab90a75c90466e", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-823c621aa743d1f7", "cves": [], "html": "Clear pg_stat_activity.xact_start during PREPARE TRANSACTION (Andres Freund)
\nAfter the PREPARE, the originating session is no longer in a transaction, so it should not continue to display a transaction start time.
", "text": "Clear pg_stat_activity.xact_start during PREPARE TRANSACTION (Andres Freund) After the PREPARE, the originating session is no longer in a transaction, so it should not continue to display a transaction start time.", "title": "Clear pg_stat_activity.xact_start during PREPARE TRANSACTION", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "d95f549ef943b1661189002e146bccb045f8593853dc88180c9edf9b760ab3ea", "section_path": ["Changes"], "commit_groups": [["12e41a5d7", "70e7be264", "82fbd88a7", "b7a3e1173", "d19bd29f0", "ea9ac7741"]], "identity_text": "Clear pg_stat_activity.xact_start during PREPARE TRANSACTION (Andres Freund) After the PREPARE, the originating session is no longer in a transaction, so it should not continue to display a transaction start time.", "commit_aliases": ["12e41a5d7", "70e7be264", "82fbd88a7", "b7a3e1173", "d19bd29f0", "ea9ac7741"], "source_commits": ["12e41a5d7"], "source_entry_id": "9.3.5/changes/026", "db_id": "d20b9d109f7e0a680be94af055771645", "patch_ids": ["e1f06bd083b2db8dc8b5a9125172680d"], "statement_hash": "642ef4bdb94b619d66e23824a190f24539619a99612365fbf4681bbc2a7a4e4c", "relations": [{"rule": 2, "type": "equivalent", "target": "53fed2609faead97a15f4688071e57af", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "642ef4bdb94b619d66e23824a190f24539619a99612365fbf4681bbc2a7a4e4c"}}, {"rule": 2, "type": "equivalent", "target": "66c6ffb4b1967b64700194b1fe3ca2aa", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "642ef4bdb94b619d66e23824a190f24539619a99612365fbf4681bbc2a7a4e4c"}}, {"rule": 2, "type": "equivalent", "target": "fc5f7050ba78e0c05e9e87fac8f1df45", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "642ef4bdb94b619d66e23824a190f24539619a99612365fbf4681bbc2a7a4e4c"}}], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "fc5f7050ba78e0c05e9e87fac8f1df45", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Clear pg_stat_activity.xact_start during PREPARE TRANSACTION", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "642ef4bdb94b619d66e23824a190f24539619a99612365fbf4681bbc2a7a4e4c"}, "url": "/docs/compare/?release=9.2.9#9.2.9-823c621aa743d1f7", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "53fed2609faead97a15f4688071e57af", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Clear pg_stat_activity.xact_start during PREPARE TRANSACTION", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "642ef4bdb94b619d66e23824a190f24539619a99612365fbf4681bbc2a7a4e4c"}, "url": "/docs/compare/?release=9.1.14#9.1.14-823c621aa743d1f7", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "66c6ffb4b1967b64700194b1fe3ca2aa", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Clear pg_stat_activity.xact_start during PREPARE TRANSACTION", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "642ef4bdb94b619d66e23824a190f24539619a99612365fbf4681bbc2a7a4e4c"}, "url": "/docs/compare/?release=9.0.18#9.0.18-823c621aa743d1f7", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-ac21589f693edd01", "cves": [], "html": "Fix REASSIGN OWNED to not fail for text search objects (Álvaro Herrera)
", "text": "Fix REASSIGN OWNED to not fail for text search objects (Álvaro Herrera)", "title": "Fix REASSIGN OWNED to not fail for text search objects", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "c18ab5ab3b27be5baa6c7b0d9d8b12414aad251b94ab9a772eeeb4c49a14779c", "section_path": ["Changes"], "commit_groups": [["12c5bbdcb", "4b767789d", "6bdf4b9c7", "a41dc7321", "b42f09fc8", "bf08864b8", "e45229bb6"]], "identity_text": "Fix REASSIGN OWNED to not fail for text search objects (Álvaro Herrera)", "commit_aliases": ["12c5bbdcb", "4b767789d", "6bdf4b9c7", "a41dc7321", "b42f09fc8", "bf08864b8", "e45229bb6"], "source_commits": ["12c5bbdcb"], "source_entry_id": "9.3.5/changes/027", "db_id": "bc2a550a6fbef954d308390070d59d44", "patch_ids": ["625429fc9887735d34b89a44296d4434"], "statement_hash": "30e7cf5ee800fa2df1c69283465239aff305f90a0f0f10286e1e4a077ac09f74", "relations": [{"rule": 2, "type": "equivalent", "target": "315ae6f5bb995c0e6d88f41345b36cb6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "30e7cf5ee800fa2df1c69283465239aff305f90a0f0f10286e1e4a077ac09f74"}}, {"rule": 2, "type": "equivalent", "target": "d9fb0682c8c03fe0a2b49ad032bc8328", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "30e7cf5ee800fa2df1c69283465239aff305f90a0f0f10286e1e4a077ac09f74"}}, {"rule": 2, "type": "equivalent", "target": "ed417d10032b5dce01be16e2497fba90", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "30e7cf5ee800fa2df1c69283465239aff305f90a0f0f10286e1e4a077ac09f74"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "d9fb0682c8c03fe0a2b49ad032bc8328", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix REASSIGN OWNED to not fail for text search objects", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "30e7cf5ee800fa2df1c69283465239aff305f90a0f0f10286e1e4a077ac09f74"}, "url": "/docs/compare/?release=9.2.9#9.2.9-ac21589f693edd01", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "315ae6f5bb995c0e6d88f41345b36cb6", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Fix REASSIGN OWNED to not fail for text search objects", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "30e7cf5ee800fa2df1c69283465239aff305f90a0f0f10286e1e4a077ac09f74"}, "url": "/docs/compare/?release=9.1.14#9.1.14-ac21589f693edd01", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "ed417d10032b5dce01be16e2497fba90", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Fix REASSIGN OWNED to not fail for text search objects", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "30e7cf5ee800fa2df1c69283465239aff305f90a0f0f10286e1e4a077ac09f74"}, "url": "/docs/compare/?release=9.0.18#9.0.18-ac21589f693edd01", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-08603bbff5cf1c2b", "cves": [], "html": "Prevent pg_class.relminmxid values from going backwards during VACUUM FULL (Álvaro Herrera)
", "text": "Prevent pg_class.relminmxid values from going backwards during VACUUM FULL (Álvaro Herrera)", "title": "Prevent pg_class.relminmxid values from going backwards during VACUUM FULL", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "e96bcd695acd9c9ec1943d0d1c91ede638e7f8140ba8c9a3e308edccb259eb04", "section_path": ["Changes"], "commit_groups": [["9eecc8a7c", "b7e51d9c0", "e86cfc4bb"]], "identity_text": "Prevent pg_class.relminmxid values from going backwards during VACUUM FULL (Álvaro Herrera)", "commit_aliases": ["9eecc8a7c", "b7e51d9c0", "e86cfc4bb"], "source_commits": ["e86cfc4bb"], "source_entry_id": "9.3.5/changes/028", "db_id": "4b0ca4b5e7382e6ee14e4e101cecdcd6", "patch_ids": ["f12c5f1ceb9eaa1bc6440b4824c727d1"], "statement_hash": "94f7b749a636d18f142362c68b903abc8214d7ac7f56ae891bff0fcff7d73bc2", "relations": [], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.5-5e9c6493f4b2a28e", "cves": [], "html": "Reduce indentation in rule/view dumps to improve readability and avoid excessive whitespace (Greg Stark, Tom Lane)
\nThis change reduces the amount of indentation applied to nested constructs, including some cases that the user probably doesn't think of as nested, such as UNION lists. Previously, deeply nested constructs were printed with an amount of whitespace growing as O(N^2), which created a performance problem and even risk of out-of-memory failures. Now the indentation is reduced modulo 40, which is initially odd to look at but seems to preserve readability better than simply limiting the indentation would do. Redundant parenthesization of UNION lists has been reduced as well.
", "text": "Reduce indentation in rule/view dumps to improve readability and avoid excessive whitespace (Greg Stark, Tom Lane) This change reduces the amount of indentation applied to nested constructs, including some cases that the user probably doesn't think of as nested, such as UNION lists. Previously, deeply nested constructs were printed with an amount of whitespace growing as O(N^2), which created a performance problem and even risk of out-of-memory failures. Now the indentation is reduced modulo 40, which is initially odd to look at but seems to preserve readability better than simply limiting the indentation would do. Redundant parenthesization of UNION lists has been reduced as well.", "title": "Reduce indentation in rule/view dumps to improve readability and avoid excessive whitespace", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "9f773c36fe3f6622c97309c41a3394c3fe52e21e67846670d37cbf23a73d53eb", "section_path": ["Changes"], "commit_groups": [["0652d77fb", "41de93c53"]], "identity_text": "Reduce indentation in rule/view dumps to improve readability and avoid excessive whitespace (Greg Stark, Tom Lane) This change reduces the amount of indentation applied to nested constructs, including some cases that the user probably doesn't think of as nested, such as UNION lists. Previously, deeply nested constructs were printed with an amount of whitespace growing as O(N^2), which created a performance problem and even risk of out-of-memory failures. Now the indentation is reduced modulo 40, which is initially odd to look at but seems to preserve readability better than simply limiting the indentation would do. Redundant parenthesization of UNION lists has been reduced as well.", "commit_aliases": ["0652d77fb", "41de93c53"], "source_commits": ["0652d77fb"], "source_entry_id": "9.3.5/changes/029", "db_id": "1250445d61174b41d2a58fc9fd97175f", "patch_ids": ["1d98ce5e1e8bb7464d20466991d1016e"], "statement_hash": "350296c916a3e8dc0e3eb19ca616292ae0d28a4b1c79e865667373c3802d9fa0", "relations": [], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.5-22b4ae2a6d7aa200", "cves": [], "html": "Fix dumping of rules/views when subsequent addition of a column has resulted in multiple input columns matching a USING specification (Tom Lane)
", "text": "Fix dumping of rules/views when subsequent addition of a column has resulted in multiple input columns matching a USING specification (Tom Lane)", "title": "Fix dumping of rules/views when subsequent addition of a column has resulted in multiple input columns matching a USING specification", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "9f5aae45a2c47da9346a99a596fba6b870a4562bba9e022bf11d5a6742466b91", "section_path": ["Changes"], "commit_groups": [["91e16b980", "e31193d49"]], "identity_text": "Fix dumping of rules/views when subsequent addition of a column has resulted in multiple input columns matching a USING specification (Tom Lane)", "commit_aliases": ["91e16b980", "e31193d49"], "source_commits": ["e31193d49"], "source_entry_id": "9.3.5/changes/030", "db_id": "5bd680f91bf3e45fd2e7ef12bd8eac41", "patch_ids": ["901a6b916275ba2760b4bb0da35c23a9"], "statement_hash": "897ff72ab132ae820009c03acb04a2461462438ee970f8a50d47ac0e8423da91", "relations": [], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.5-d6c6777bc211d59a", "cves": [], "html": "Repair view printing for some cases involving functions in FROM that return a composite type containing dropped columns (Tom Lane)
", "text": "Repair view printing for some cases involving functions in FROM that return a composite type containing dropped columns (Tom Lane)", "title": "Repair view printing for some cases involving functions in FROM that return a composite type containing dropped columns", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "33fa4e545c87fded84b13b256683558706edbb2296dcc1cb04e73e82609bee49", "section_path": ["Changes"], "commit_groups": [["9b35ddce9", "b978ab5f6", "f0a497e4c"]], "identity_text": "Repair view printing for some cases involving functions in FROM that return a composite type containing dropped columns (Tom Lane)", "commit_aliases": ["9b35ddce9", "b978ab5f6", "f0a497e4c"], "source_commits": ["b978ab5f6"], "source_entry_id": "9.3.5/changes/031", "db_id": "d7b2f602ed192fa2318bfbbb946fa925", "patch_ids": ["3b8944540059a49ae09f86be3c53885e"], "statement_hash": "7065e92733f8708560cd561fc3c69be6ff09a247fca828258e161df0d6bdc37f", "relations": [], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.5-bb832f7097716a1e", "cves": [], "html": "Block signals during postmaster startup (Tom Lane)
\nThis ensures that the postmaster will properly clean up after itself if, for example, it receives SIGINT while still starting up.
", "text": "Block signals during postmaster startup (Tom Lane) This ensures that the postmaster will properly clean up after itself if, for example, it receives SIGINT while still starting up.", "title": "Block signals during postmaster startup", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "905feabf83e6b988a13f32c82e3fe3a42c35ecd996f5da819c42361a076b1445", "section_path": ["Changes"], "commit_groups": [["093d3da1d", "21aa47d01", "53463e247", "5c26ab659", "5d8117e1f", "969735cf1"]], "identity_text": "Block signals during postmaster startup (Tom Lane) This ensures that the postmaster will properly clean up after itself if, for example, it receives SIGINT while still starting up.", "commit_aliases": ["093d3da1d", "21aa47d01", "53463e247", "5c26ab659", "5d8117e1f", "969735cf1"], "source_commits": ["21aa47d01"], "source_entry_id": "9.3.5/changes/032", "db_id": "ea67567d42c2f81930ebd68ee20d1666", "patch_ids": ["2674a2e8c76aad48d98b960e6fc33fa5"], "statement_hash": "8986f77d637b9a3105e635f5ce57c021b64961ade1d74f906871180bb6092d56", "relations": [{"rule": 2, "type": "equivalent", "target": "008dd7c42f272dcfed2925215fe3e960", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8986f77d637b9a3105e635f5ce57c021b64961ade1d74f906871180bb6092d56"}}, {"rule": 2, "type": "equivalent", "target": "69cca2f3deeea63837fbbd935c27ec06", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8986f77d637b9a3105e635f5ce57c021b64961ade1d74f906871180bb6092d56"}}, {"rule": 2, "type": "equivalent", "target": "fe83700f9afe7966cb2db312f46f5dc8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8986f77d637b9a3105e635f5ce57c021b64961ade1d74f906871180bb6092d56"}}], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "008dd7c42f272dcfed2925215fe3e960", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Block signals during postmaster startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8986f77d637b9a3105e635f5ce57c021b64961ade1d74f906871180bb6092d56"}, "url": "/docs/compare/?release=9.2.9#9.2.9-bb832f7097716a1e", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "69cca2f3deeea63837fbbd935c27ec06", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Block signals during postmaster startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8986f77d637b9a3105e635f5ce57c021b64961ade1d74f906871180bb6092d56"}, "url": "/docs/compare/?release=9.1.14#9.1.14-bb832f7097716a1e", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "fe83700f9afe7966cb2db312f46f5dc8", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Block signals during postmaster startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8986f77d637b9a3105e635f5ce57c021b64961ade1d74f906871180bb6092d56"}, "url": "/docs/compare/?release=9.0.18#9.0.18-bb832f7097716a1e", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-eb6f67d2868dfbf8", "cves": [], "html": "Fix client host name lookup when processing pg_hba.conf entries that specify host names instead of IP addresses (Tom Lane)
\nEnsure that reverse-DNS lookup failures are reported, instead of just silently not matching such entries. Also ensure that we make only one reverse-DNS lookup attempt per connection, not one per host name entry, which is what previously happened if the lookup attempts failed.
", "text": "Fix client host name lookup when processing pg_hba.conf entries that specify host names instead of IP addresses (Tom Lane) Ensure that reverse-DNS lookup failures are reported, instead of just silently not matching such entries. Also ensure that we make only one reverse-DNS lookup attempt per connection, not one per host name entry, which is what previously happened if the lookup attempts failed.", "title": "Fix client host name lookup when processing pg_hba.conf entries that specify host names instead of IP addresses", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "1c5d08bcb27dc1509aa0af14534d193b718c3ac6a5309fc71cd0c44adfd62cda", "section_path": ["Changes"], "commit_groups": [["029decfec", "65183fb78", "b7a424371", "fc752505a"]], "identity_text": "Fix client host name lookup when processing pg_hba.conf entries that specify host names instead of IP addresses (Tom Lane) Ensure that reverse-DNS lookup failures are reported, instead of just silently not matching such entries. Also ensure that we make only one reverse-DNS lookup attempt per connection, not one per host name entry, which is what previously happened if the lookup attempts failed.", "commit_aliases": ["029decfec", "65183fb78", "b7a424371", "fc752505a"], "source_commits": ["65183fb78"], "source_entry_id": "9.3.5/changes/033", "db_id": "8fad6156289231d320c05e360bda6d60", "patch_ids": ["287e10e4f66712f136e227af6642b4fc"], "statement_hash": "4274ba20c8ff3a87dff46213bc27461ce499e5ddd1a889133787a5f1f5fad4dc", "relations": [{"rule": 2, "type": "equivalent", "target": "0c31bb1f7da100c24cafaed31aa745e5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4274ba20c8ff3a87dff46213bc27461ce499e5ddd1a889133787a5f1f5fad4dc"}}, {"rule": 2, "type": "equivalent", "target": "958f57b66124225bfbdd3cb36789ea94", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4274ba20c8ff3a87dff46213bc27461ce499e5ddd1a889133787a5f1f5fad4dc"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "0c31bb1f7da100c24cafaed31aa745e5", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix client host name lookup when processing pg_hba.conf entries that specify host names instead of IP addresses", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4274ba20c8ff3a87dff46213bc27461ce499e5ddd1a889133787a5f1f5fad4dc"}, "url": "/docs/compare/?release=9.2.9#9.2.9-eb6f67d2868dfbf8", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "958f57b66124225bfbdd3cb36789ea94", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Fix client host name lookup when processing pg_hba.conf entries that specify host names instead of IP addresses", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4274ba20c8ff3a87dff46213bc27461ce499e5ddd1a889133787a5f1f5fad4dc"}, "url": "/docs/compare/?release=9.1.14#9.1.14-eb6f67d2868dfbf8", "source_url": "/docs/release/9.1.14/#AEN108337"}]}, {"id": "9.3.5-1e3bdf11ecfe1015", "cves": [], "html": "Allow the root user to use postgres -C variable and postgres --describe-config (MauMau)
\nThe prohibition on starting the server as root does not need to extend to these operations, and relaxing it prevents failure of pg_ctl in some scenarios.
", "text": "Allow the root user to use postgres -C variable and postgres --describe-config (MauMau) The prohibition on starting the server as root does not need to extend to these operations, and relaxing it prevents failure of pg_ctl in some scenarios.", "title": "Allow the root user to use postgres -C variable and postgres --describe-config", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "ce4081bfed7f2914ffe20ba9fa14947625312df6b863d1cdad9edfce8a45e638", "section_path": ["Changes"], "commit_groups": [["6d25eb314", "7d1a0f585", "b203c57bb"]], "identity_text": "Allow the root user to use postgres -C variable and postgres --describe-config (MauMau) The prohibition on starting the server as root does not need to extend to these operations, and relaxing it prevents failure of pg_ctl in some scenarios.", "commit_aliases": ["6d25eb314", "7d1a0f585", "b203c57bb"], "source_commits": ["7d1a0f585"], "source_entry_id": "9.3.5/changes/034", "db_id": "a996e9005aeeae369f9c0f3583547895", "patch_ids": ["9cf57a794cdb687c98932b382d41241f"], "statement_hash": "c1ed32d060e6a567bf895cec1f4e4b64b3ad1b24913c0b09e758ac037a1b423d", "relations": [{"rule": 2, "type": "equivalent", "target": "a2b4b4c700d767c1d6fcec2a42940dd9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c1ed32d060e6a567bf895cec1f4e4b64b3ad1b24913c0b09e758ac037a1b423d"}}], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "a2b4b4c700d767c1d6fcec2a42940dd9", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Allow the root user to use postgres -C variable and postgres --describe-config", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c1ed32d060e6a567bf895cec1f4e4b64b3ad1b24913c0b09e758ac037a1b423d"}, "url": "/docs/compare/?release=9.2.9#9.2.9-1e3bdf11ecfe1015", "source_url": "/docs/release/9.2.9/#AEN112895"}]}, {"id": "9.3.5-0dee77640e5cf5c0", "cves": ["CVE-2014-0067"], "html": "Secure Unix-domain sockets of temporary postmasters started during make check (Noah Misch)
\nAny local user able to access the socket file could connect as the server's bootstrap superuser, then proceed to execute arbitrary code as the operating-system user running the test, as we previously noted in CVE-2014-0067. This change defends against that risk by placing the server's socket in a temporary, mode 0700 subdirectory of /tmp. The hazard remains however on platforms where Unix sockets are not supported, notably Windows, because then the temporary postmaster must accept local TCP connections.
\nA useful side effect of this change is to simplify make check testing in builds that override DEFAULT_PGSOCKET_DIR. Popular non-default values like /var/run/postgresql are often not writable by the build user, requiring workarounds that will no longer be necessary.
", "text": "Secure Unix-domain sockets of temporary postmasters started during make check (Noah Misch) Any local user able to access the socket file could connect as the server's bootstrap superuser, then proceed to execute arbitrary code as the operating-system user running the test, as we previously noted in CVE-2014-0067. This change defends against that risk by placing the server's socket in a temporary, mode 0700 subdirectory of /tmp. The hazard remains however on platforms where Unix sockets are not supported, notably Windows, because then the temporary postmaster must accept local TCP connections. A useful side effect of this change is to simplify make check testing in builds that override DEFAULT_PGSOCKET_DIR. Popular non-default values like /var/run/postgresql are often not writable by the build user, requiring workarounds that will no longer be necessary.", "title": "Secure Unix-domain sockets of temporary postmasters started during make check", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "0bebe9514a66af36ee038667af54903701b4b68d102e95beca976ca9e8d5514d", "section_path": ["Changes"], "commit_groups": [["1442b426e", "453a5d91d", "481831b43", "5f09c583c", "6583a75b2", "95cefd30e", "be76a6d39"]], "identity_text": "Secure Unix-domain sockets of temporary postmasters started during make check (Noah Misch) Any local user able to access the socket file could connect as the server's bootstrap superuser, then proceed to execute arbitrary code as the operating-system user running the test, as we previously noted in CVE-2014-0067. This change defends against that risk by placing the server's socket in a temporary, mode 0700 subdirectory of /tmp. The hazard remains however on platforms where Unix sockets are not supported, notably Windows, because then the temporary postmaster must accept local TCP connections. A useful side effect of this change is to simplify make check testing in builds that override DEFAULT_PGSOCKET_DIR. Popular non-default values like /var/run/postgresql are often not writable by the build user, requiring workarounds that will no longer be necessary.", "commit_aliases": ["1442b426e", "453a5d91d", "481831b43", "5f09c583c", "6583a75b2", "95cefd30e", "be76a6d39"], "source_commits": ["1442b426e"], "source_entry_id": "9.3.5/changes/035", "db_id": "e5db1e1a4f47f7dbe939381198c5dad5", "patch_ids": ["998881a7f9ad30cb478abfb97353cebe"], "statement_hash": "421edc0e245507d52e97074221ccf85a880e4b1010e62e6ef47292e6fec25061", "relations": [{"rule": 2, "type": "equivalent", "target": "32ac210b2021f4d10180396115d807a2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "421edc0e245507d52e97074221ccf85a880e4b1010e62e6ef47292e6fec25061"}}, {"rule": 2, "type": "equivalent", "target": "4562d96c599a876fbaa708785af45cf9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "421edc0e245507d52e97074221ccf85a880e4b1010e62e6ef47292e6fec25061"}}, {"rule": 2, "type": "equivalent", "target": "a3829053c54dcf4d2636f219426f3672", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "421edc0e245507d52e97074221ccf85a880e4b1010e62e6ef47292e6fec25061"}}], "version": "9.3.5", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "32ac210b2021f4d10180396115d807a2", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Secure Unix-domain sockets of temporary postmasters started during make check", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "421edc0e245507d52e97074221ccf85a880e4b1010e62e6ef47292e6fec25061"}, "url": "/docs/compare/?release=9.2.9#9.2.9-0dee77640e5cf5c0", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "a3829053c54dcf4d2636f219426f3672", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Secure Unix-domain sockets of temporary postmasters started during make check", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "421edc0e245507d52e97074221ccf85a880e4b1010e62e6ef47292e6fec25061"}, "url": "/docs/compare/?release=9.1.14#9.1.14-0dee77640e5cf5c0", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "4562d96c599a876fbaa708785af45cf9", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Secure Unix-domain sockets of temporary postmasters started during make check", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "421edc0e245507d52e97074221ccf85a880e4b1010e62e6ef47292e6fec25061"}, "url": "/docs/compare/?release=9.0.18#9.0.18-0dee77640e5cf5c0", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-38d3e02579616e2d", "cves": [], "html": "Fix tablespace creation WAL replay to work on Windows (MauMau)
", "text": "Fix tablespace creation WAL replay to work on Windows (MauMau)", "title": "Fix tablespace creation WAL replay to work on Windows", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "8496748c6fe383087db0df421a017bc32fa7b52ab32972feace597d320a41fc2", "section_path": ["Changes"], "commit_groups": [["1a496a12b", "634056567", "84520f91c", "abe075dff", "af7738fe6"]], "identity_text": "Fix tablespace creation WAL replay to work on Windows (MauMau)", "commit_aliases": ["1a496a12b", "634056567", "84520f91c", "abe075dff", "af7738fe6"], "source_commits": ["84520f91c"], "source_entry_id": "9.3.5/changes/036", "db_id": "9216ca2e9821acf8d60b4ae88f36b7f0", "patch_ids": ["2056f6211d20c7a1d54deb73532916f6"], "statement_hash": "0951bd8a33873cc51b53c3191ef701e028a04a6dea63a3f266e3ab1f026b50dd", "relations": [{"rule": 2, "type": "equivalent", "target": "176e76f0277971aa24026e7a9a0c0cb0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0951bd8a33873cc51b53c3191ef701e028a04a6dea63a3f266e3ab1f026b50dd"}}, {"rule": 2, "type": "equivalent", "target": "9959e561fe05f1b007aed8b129812efb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0951bd8a33873cc51b53c3191ef701e028a04a6dea63a3f266e3ab1f026b50dd"}}, {"rule": 2, "type": "equivalent", "target": "eef99bb4e5e9a46062773101dc0d1818", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0951bd8a33873cc51b53c3191ef701e028a04a6dea63a3f266e3ab1f026b50dd"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "eef99bb4e5e9a46062773101dc0d1818", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix tablespace creation WAL replay to work on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0951bd8a33873cc51b53c3191ef701e028a04a6dea63a3f266e3ab1f026b50dd"}, "url": "/docs/compare/?release=9.2.9#9.2.9-38d3e02579616e2d", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "9959e561fe05f1b007aed8b129812efb", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Fix tablespace creation WAL replay to work on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0951bd8a33873cc51b53c3191ef701e028a04a6dea63a3f266e3ab1f026b50dd"}, "url": "/docs/compare/?release=9.1.14#9.1.14-38d3e02579616e2d", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "176e76f0277971aa24026e7a9a0c0cb0", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Fix tablespace creation WAL replay to work on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0951bd8a33873cc51b53c3191ef701e028a04a6dea63a3f266e3ab1f026b50dd"}, "url": "/docs/compare/?release=9.0.18#9.0.18-38d3e02579616e2d", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-36e96134ddd68eae", "cves": [], "html": "Fix detection of socket creation failures on Windows (Bruce Momjian)
", "text": "Fix detection of socket creation failures on Windows (Bruce Momjian)", "title": "Fix detection of socket creation failures on Windows", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "66d413ecf2eb396556056867c9e7d0625c1c2eb0066e52fa4e103951c83c59c3", "section_path": ["Changes"], "commit_groups": [["418093465", "966f015b6", "a86b2daff", "bed499ed1", "f716c3250"]], "identity_text": "Fix detection of socket creation failures on Windows (Bruce Momjian)", "commit_aliases": ["418093465", "966f015b6", "a86b2daff", "bed499ed1", "f716c3250"], "source_commits": ["f716c3250"], "source_entry_id": "9.3.5/changes/037", "db_id": "ebe4a8d79d3ba17586c56dd3274dec04", "patch_ids": ["f97773e0ecdab3076a362fbd735ce6f6"], "statement_hash": "fd240b5a5bbb4d5ce397d2abea8477493415a23886d10b79edf8a3570dd40d0a", "relations": [{"rule": 2, "type": "equivalent", "target": "17554d240e1e1bf0abcb437338abcc15", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fd240b5a5bbb4d5ce397d2abea8477493415a23886d10b79edf8a3570dd40d0a"}}, {"rule": 2, "type": "equivalent", "target": "30dc1321491065a0d4c6caa538598c6c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fd240b5a5bbb4d5ce397d2abea8477493415a23886d10b79edf8a3570dd40d0a"}}, {"rule": 2, "type": "equivalent", "target": "a9b9ce2de83b5af9746463adf52afc66", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fd240b5a5bbb4d5ce397d2abea8477493415a23886d10b79edf8a3570dd40d0a"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "17554d240e1e1bf0abcb437338abcc15", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix detection of socket creation failures on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fd240b5a5bbb4d5ce397d2abea8477493415a23886d10b79edf8a3570dd40d0a"}, "url": "/docs/compare/?release=9.2.9#9.2.9-36e96134ddd68eae", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "a9b9ce2de83b5af9746463adf52afc66", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Fix detection of socket creation failures on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fd240b5a5bbb4d5ce397d2abea8477493415a23886d10b79edf8a3570dd40d0a"}, "url": "/docs/compare/?release=9.1.14#9.1.14-36e96134ddd68eae", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "30dc1321491065a0d4c6caa538598c6c", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Fix detection of socket creation failures on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fd240b5a5bbb4d5ce397d2abea8477493415a23886d10b79edf8a3570dd40d0a"}, "url": "/docs/compare/?release=9.0.18#9.0.18-36e96134ddd68eae", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-19736c8b0d991900", "cves": [], "html": "On Windows, allow new sessions to absorb values of PGC_BACKEND parameters (such as log_connections) from the configuration file (Amit Kapila)
\nPreviously, if such a parameter were changed in the file post-startup, the change would have no effect.
", "text": "On Windows, allow new sessions to absorb values of PGC_BACKEND parameters (such as log_connections) from the configuration file (Amit Kapila) Previously, if such a parameter were changed in the file post-startup, the change would have no effect.", "title": "On Windows, allow new sessions to absorb values of PGC_BACKEND parameters (such as log_connections) from the configuration file", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "98f4ec758a567202a3bc664081313c2190be021ce182fccc57cd34aab87412da", "section_path": ["Changes"], "commit_groups": [["18db2150c", "30e434bdf", "6862ca697", "9500d8f89", "bdc3e95c2", "cb11f4d8d"]], "identity_text": "On Windows, allow new sessions to absorb values of PGC_BACKEND parameters (such as guc-log-connections ) from the configuration file (Amit Kapila) Previously, if such a parameter were changed in the file post-startup, the change would have no effect.", "commit_aliases": ["18db2150c", "30e434bdf", "6862ca697", "9500d8f89", "bdc3e95c2", "cb11f4d8d"], "source_commits": ["18db2150c"], "source_entry_id": "9.3.5/changes/038", "db_id": "218104825d14bd97a422e9ab79b1704a", "patch_ids": ["cd2daf94bfc16548a90dc48421b68327"], "statement_hash": "5765359658e9917736f21873a6a7cb64f4ecf035d9d1b7f548c72cba07f367e1", "relations": [{"rule": 2, "type": "equivalent", "target": "0149ee36e50d0a3426d4baddce68a3f2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5765359658e9917736f21873a6a7cb64f4ecf035d9d1b7f548c72cba07f367e1"}}, {"rule": 2, "type": "equivalent", "target": "764a1b6cf15f0cdc425deb42a9a207e3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5765359658e9917736f21873a6a7cb64f4ecf035d9d1b7f548c72cba07f367e1"}}, {"rule": 2, "type": "equivalent", "target": "8491d20a9cd982f29e6148ac2beec587", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5765359658e9917736f21873a6a7cb64f4ecf035d9d1b7f548c72cba07f367e1"}}], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "0149ee36e50d0a3426d4baddce68a3f2", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "On Windows, allow new sessions to absorb values of PGC_BACKEND parameters (such as log_connections) from the configuration file", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5765359658e9917736f21873a6a7cb64f4ecf035d9d1b7f548c72cba07f367e1"}, "url": "/docs/compare/?release=9.2.9#9.2.9-19736c8b0d991900", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "8491d20a9cd982f29e6148ac2beec587", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "On Windows, allow new sessions to absorb values of PGC_BACKEND parameters (such as log_connections) from the configuration file", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5765359658e9917736f21873a6a7cb64f4ecf035d9d1b7f548c72cba07f367e1"}, "url": "/docs/compare/?release=9.1.14#9.1.14-19736c8b0d991900", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "764a1b6cf15f0cdc425deb42a9a207e3", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "On Windows, allow new sessions to absorb values of PGC_BACKEND parameters (such as log_connections) from the configuration file", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5765359658e9917736f21873a6a7cb64f4ecf035d9d1b7f548c72cba07f367e1"}, "url": "/docs/compare/?release=9.0.18#9.0.18-19736c8b0d991900", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-b2e83cb664d47bd7", "cves": [], "html": "Properly quote executable path names on Windows (Nikhil Deshpande)
\nThis oversight could cause initdb and pg_upgrade to fail on Windows, if the installation path contained both spaces and @ signs.
", "text": "Properly quote executable path names on Windows (Nikhil Deshpande) This oversight could cause initdb and pg_upgrade to fail on Windows, if the installation path contained both spaces and @ signs.", "title": "Properly quote executable path names on Windows", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "1a955431fd03266b9a33a9c717f6d123e9240427ffc50e3c5fe9f039b426cbd3", "section_path": ["Changes"], "commit_groups": [["503de5462", "8a90a39b4", "94095e341", "c06b7219a", "e2558e016", "e3f273ff6"]], "identity_text": "Properly quote executable path names on Windows (Nikhil Deshpande) This oversight could cause initdb and pg_upgrade to fail on Windows, if the installation path contained both spaces and @ signs.", "commit_aliases": ["503de5462", "8a90a39b4", "94095e341", "c06b7219a", "e2558e016", "e3f273ff6"], "source_commits": ["8a90a39b4"], "source_entry_id": "9.3.5/changes/039", "db_id": "a00c57cfe7cf06a59131c5ff0d3a8612", "patch_ids": ["bada571964929922275b02b0b5a78074"], "statement_hash": "87cad73827ef54d373b81f858c97fd722e136bbe0522e3687f49130bfab547b7", "relations": [{"rule": 2, "type": "equivalent", "target": "082751823ea21e0f5ff5f2891d7639e2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "87cad73827ef54d373b81f858c97fd722e136bbe0522e3687f49130bfab547b7"}}, {"rule": 2, "type": "equivalent", "target": "3b999fd58f8dc69b0e938c7f9c84d747", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "87cad73827ef54d373b81f858c97fd722e136bbe0522e3687f49130bfab547b7"}}, {"rule": 2, "type": "equivalent", "target": "b4d3f8a47b553650493ed8ee653be2a0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "87cad73827ef54d373b81f858c97fd722e136bbe0522e3687f49130bfab547b7"}}], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "3b999fd58f8dc69b0e938c7f9c84d747", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Properly quote executable path names on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "87cad73827ef54d373b81f858c97fd722e136bbe0522e3687f49130bfab547b7"}, "url": "/docs/compare/?release=9.2.9#9.2.9-b2e83cb664d47bd7", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "082751823ea21e0f5ff5f2891d7639e2", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Properly quote executable path names on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "87cad73827ef54d373b81f858c97fd722e136bbe0522e3687f49130bfab547b7"}, "url": "/docs/compare/?release=9.1.14#9.1.14-b2e83cb664d47bd7", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "b4d3f8a47b553650493ed8ee653be2a0", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Properly quote executable path names on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "87cad73827ef54d373b81f858c97fd722e136bbe0522e3687f49130bfab547b7"}, "url": "/docs/compare/?release=9.0.18#9.0.18-b2e83cb664d47bd7", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-44bb6540ac9bfce7", "cves": [], "html": "Fix linking of libpython on macOS (Tom Lane)
\nThe method we previously used can fail with the Python library supplied by Xcode 5.0 and later.
", "text": "Fix linking of libpython on macOS (Tom Lane) The method we previously used can fail with the Python library supplied by Xcode 5.0 and later.", "title": "Fix linking of libpython on macOS", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "086f26fa210fbf00461002918aed95a6a499f73b2fe1d77a55a6a41c55a83e7b", "section_path": ["Changes"], "commit_groups": [["20561acf9", "4f5f4da79", "4f725bbc4", "83ed4598b", "a784a39c4", "ae41bb4be"]], "identity_text": "Fix linking of libpython on macOS (Tom Lane) The method we previously used can fail with the Python library supplied by Xcode 5.0 and later.", "commit_aliases": ["20561acf9", "4f5f4da79", "4f725bbc4", "83ed4598b", "a784a39c4", "ae41bb4be"], "source_commits": ["4f5f4da79"], "source_entry_id": "9.3.5/changes/040", "db_id": "52dfed10ea11bb1fce0f9546f2fd724b", "patch_ids": ["3760c3c074ac7c718c2ef75bd2ba791d"], "statement_hash": "6a4ed094e3684b42cec1b046cffd1b0a717533f1abac539beb717951e1a8196e", "relations": [{"rule": 2, "type": "equivalent", "target": "03f943fa073c1a44ceaaa49277947867", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6a4ed094e3684b42cec1b046cffd1b0a717533f1abac539beb717951e1a8196e"}}, {"rule": 2, "type": "equivalent", "target": "734f5598eb1c3658f9210b5ba8d197c3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6a4ed094e3684b42cec1b046cffd1b0a717533f1abac539beb717951e1a8196e"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "03f943fa073c1a44ceaaa49277947867", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix linking of libpython on macOS", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6a4ed094e3684b42cec1b046cffd1b0a717533f1abac539beb717951e1a8196e"}, "url": "/docs/compare/?release=9.2.9#9.2.9-44bb6540ac9bfce7", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "734f5598eb1c3658f9210b5ba8d197c3", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Fix linking of libpython on macOS", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6a4ed094e3684b42cec1b046cffd1b0a717533f1abac539beb717951e1a8196e"}, "url": "/docs/compare/?release=9.1.14#9.1.14-44bb6540ac9bfce7", "source_url": "/docs/release/9.1.14/#AEN108337"}]}, {"id": "9.3.5-8949a3582b5b8943", "cves": [], "html": "Avoid buffer bloat in libpq when the server consistently sends data faster than the client can absorb it (Shin-ichi Morita, Tom Lane)
\nlibpq could be coerced into enlarging its input buffer until it runs out of memory (which would be reported misleadingly as \"lost synchronization with server\"). Under ordinary circumstances it's quite far-fetched that data could be continuously transmitted more quickly than the recv() loop can absorb it, but this has been observed when the client is artificially slowed by scheduler constraints.
Ensure that LDAP lookup attempts in libpq time out as intended (Laurenz Albe)
", "text": "Ensure that LDAP lookup attempts in libpq time out as intended (Laurenz Albe)", "title": "Ensure that LDAP lookup attempts in libpq time out as intended", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "e8e508c44720b3cb9da2143fec637661b27d1bcddca7fafcbc59693708153ad7", "section_path": ["Changes"], "commit_groups": [["585bca393", "96752b02d", "b4ae2e37d", "b764080ee", "c4bf15b9c", "cc269272c"]], "identity_text": "Ensure that LDAP lookup attempts in libpq time out as intended (Laurenz Albe)", "commit_aliases": ["585bca393", "96752b02d", "b4ae2e37d", "b764080ee", "c4bf15b9c", "cc269272c"], "source_commits": ["cc269272c"], "source_entry_id": "9.3.5/changes/042", "db_id": "fae35e9a2cb6f22e727f26504ec1bf29", "patch_ids": ["1ec1c054780a33b8054b72669b4e64d7"], "statement_hash": "9dd31e73a7f7b653f065c8b0769c8fad6f56b106c355205b355057b2c66a3292", "relations": [{"rule": 2, "type": "equivalent", "target": "47a792f9478fb28694a84953205d03a3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9dd31e73a7f7b653f065c8b0769c8fad6f56b106c355205b355057b2c66a3292"}}, {"rule": 2, "type": "equivalent", "target": "77b8f10623b200635653a4a8e40d9023", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9dd31e73a7f7b653f065c8b0769c8fad6f56b106c355205b355057b2c66a3292"}}, {"rule": 2, "type": "equivalent", "target": "93e8b6c34b4b9e5c8f46e6f20483ab43", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9dd31e73a7f7b653f065c8b0769c8fad6f56b106c355205b355057b2c66a3292"}}], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "77b8f10623b200635653a4a8e40d9023", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Ensure that LDAP lookup attempts in libpq time out as intended", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9dd31e73a7f7b653f065c8b0769c8fad6f56b106c355205b355057b2c66a3292"}, "url": "/docs/compare/?release=9.2.9#9.2.9-86fc0b1dc1b94c71", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "93e8b6c34b4b9e5c8f46e6f20483ab43", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Ensure that LDAP lookup attempts in libpq time out as intended", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9dd31e73a7f7b653f065c8b0769c8fad6f56b106c355205b355057b2c66a3292"}, "url": "/docs/compare/?release=9.1.14#9.1.14-86fc0b1dc1b94c71", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "47a792f9478fb28694a84953205d03a3", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Ensure that LDAP lookup attempts in libpq time out as intended", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9dd31e73a7f7b653f065c8b0769c8fad6f56b106c355205b355057b2c66a3292"}, "url": "/docs/compare/?release=9.0.18#9.0.18-86fc0b1dc1b94c71", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-9ffdbbfeee221ac1", "cves": [], "html": "Fix ecpg to do the right thing when an array of char * is the target for a FETCH statement returning more than one row, as well as some other array-handling fixes (Ashutosh Bapat)
", "text": "Fix ecpg to do the right thing when an array of char * is the target for a FETCH statement returning more than one row, as well as some other array-handling fixes (Ashutosh Bapat)", "title": "Fix ecpg to do the right thing when an array of char * is the target for a FETCH statement returning more than one row, as well as some other array-handling fixes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "154dd8503b9fceb97107f980d27eb887ce90b6a586a1797173c466d926aa2a1f", "section_path": ["Changes"], "commit_groups": [["0c2eb989e", "0de106836", "2b3136de9", "3b8fda676", "f91796853"], ["3a024c110", "8d6a07fa0", "91c8c106f", "b4eeb9d58", "fb66e88cf"]], "identity_text": "Fix ecpg to do the right thing when an array of char * is the target for a FETCH statement returning more than one row, as well as some other array-handling fixes (Ashutosh Bapat)", "commit_aliases": ["0c2eb989e", "0de106836", "2b3136de9", "3a024c110", "3b8fda676", "8d6a07fa0", "91c8c106f", "b4eeb9d58", "f91796853", "fb66e88cf"], "source_commits": ["3b8fda676", "b4eeb9d58"], "source_entry_id": "9.3.5/changes/043", "db_id": "03951a03f69cc7a7ccf5e67eaa50748e", "patch_ids": ["0e980eefb4ec2ddf3cd6395c2398fbc2", "f72f197abe3067c386dde2cbdc2ce225"], "statement_hash": "bbf5a7b8dea2c6d469f7cd4ddb525ccbe9be895afdc8a4c0fd2041aa66cc83c1", "relations": [{"rule": 2, "type": "equivalent", "target": "5fe77e7c94032b304ecf46028b3be13d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bbf5a7b8dea2c6d469f7cd4ddb525ccbe9be895afdc8a4c0fd2041aa66cc83c1"}}, {"rule": 2, "type": "equivalent", "target": "60a69e69d0f9f9787bb74a801b09eced", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bbf5a7b8dea2c6d469f7cd4ddb525ccbe9be895afdc8a4c0fd2041aa66cc83c1"}}, {"rule": 2, "type": "equivalent", "target": "803965b25515c92205c976328c2eb0a4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bbf5a7b8dea2c6d469f7cd4ddb525ccbe9be895afdc8a4c0fd2041aa66cc83c1"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "5fe77e7c94032b304ecf46028b3be13d", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix ecpg to do the right thing when an array of char * is the target for a FETCH statement returning more than one row, as well as some other array-handling fixes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bbf5a7b8dea2c6d469f7cd4ddb525ccbe9be895afdc8a4c0fd2041aa66cc83c1"}, "url": "/docs/compare/?release=9.2.9#9.2.9-9ffdbbfeee221ac1", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "60a69e69d0f9f9787bb74a801b09eced", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Fix ecpg to do the right thing when an array of char * is the target for a FETCH statement returning more than one row, as well as some other array-handling fixes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bbf5a7b8dea2c6d469f7cd4ddb525ccbe9be895afdc8a4c0fd2041aa66cc83c1"}, "url": "/docs/compare/?release=9.1.14#9.1.14-9ffdbbfeee221ac1", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "803965b25515c92205c976328c2eb0a4", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Fix ecpg to do the right thing when an array of char * is the target for a FETCH statement returning more than one row, as well as some other array-handling fixes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bbf5a7b8dea2c6d469f7cd4ddb525ccbe9be895afdc8a4c0fd2041aa66cc83c1"}, "url": "/docs/compare/?release=9.0.18#9.0.18-9ffdbbfeee221ac1", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-63ef2c591035ea96", "cves": [], "html": "Fix pg_dump to cope with a materialized view that depends on a table's primary key (Tom Lane)
\nThis occurs if the view's query relies on functional dependency to abbreviate a GROUP BY list. pg_dump got sufficiently confused that it dumped the materialized view as a regular view.
", "text": "Fix pg_dump to cope with a materialized view that depends on a table's primary key (Tom Lane) This occurs if the view's query relies on functional dependency to abbreviate a GROUP BY list. pg_dump got sufficiently confused that it dumped the materialized view as a regular view.", "title": "Fix pg_dump to cope with a materialized view that depends on a table's primary key", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "6e89374f0ebd8398dd9f66f0e174e9945da41d9b06bbfc56f39dbd03d1a05059", "section_path": ["Changes"], "commit_groups": [["3080bbaa9", "62215de29"]], "identity_text": "Fix pg_dump to cope with a materialized view that depends on a table's primary key (Tom Lane) This occurs if the view's query relies on functional dependency to abbreviate a GROUP BY list. pg_dump got sufficiently confused that it dumped the materialized view as a regular view.", "commit_aliases": ["3080bbaa9", "62215de29"], "source_commits": ["3080bbaa9"], "source_entry_id": "9.3.5/changes/044", "db_id": "8ac68623b9ad1c757df0f25a37ee3b2b", "patch_ids": ["ac5b049e737590689dfba87e70138d4f"], "statement_hash": "feed8d02d02e6643104be11b975971bfb899bc883debd0b0ee3de254f374c0e6", "relations": [], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.5-63897aa08015d622", "cves": [], "html": "Fix parsing of pg_dumpall's -i switch (Tom Lane)
", "text": "Fix parsing of pg_dumpall's -i switch (Tom Lane)", "title": "Fix parsing of pg_dumpall's -i switch", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "50c0db9894071f7e1ed4e6046f3968d98ea9704d8d08e56c7c700c62dc11d840", "section_path": ["Changes"], "commit_groups": [["19f2d6cda", "63817f86b"]], "identity_text": "Fix parsing of pg_dumpall's -i switch (Tom Lane)", "commit_aliases": ["19f2d6cda", "63817f86b"], "source_commits": ["63817f86b"], "source_entry_id": "9.3.5/changes/045", "db_id": "d882c86ec40f078ff44ec620344b3cf0", "patch_ids": ["38957b0278fec42c42663445c2461163"], "statement_hash": "cb02bbd5f5adff9cb2ba010b619674d59894ee407186739f5dae8af5cb1d006c", "relations": [], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.5-4f733d22025ad5a3", "cves": [], "html": "Fix pg_restore's processing of old-style large object comments (Tom Lane)
\nA direct-to-database restore from an archive file generated by a pre-9.0 version of pg_dump would usually fail if the archive contained more than a few comments for large objects.
", "text": "Fix pg_restore's processing of old-style large object comments (Tom Lane) A direct-to-database restore from an archive file generated by a pre-9.0 version of pg_dump would usually fail if the archive contained more than a few comments for large objects.", "title": "Fix pg_restore's processing of old-style large object comments", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "7650937f2600938e1652de97c3c00d1231de72967692ca7276a24ad7968c977c", "section_path": ["Changes"], "commit_groups": [["294a48985", "3fec825f9", "6adddac8a", "a11577f47", "c3c1401ca", "c81e63d85", "ce7fc4fbb"]], "identity_text": "Fix pg_restore's processing of old-style large object comments (Tom Lane) A direct-to-database restore from an archive file generated by a pre-9.0 version of pg_dump would usually fail if the archive contained more than a few comments for large objects.", "commit_aliases": ["294a48985", "3fec825f9", "6adddac8a", "a11577f47", "c3c1401ca", "c81e63d85", "ce7fc4fbb"], "source_commits": ["a11577f47"], "source_entry_id": "9.3.5/changes/046", "db_id": "da83d1898e5b2c300cfb0fad7355a0cb", "patch_ids": ["dc09a3b50ecd4ca8497c9020f8c828df"], "statement_hash": "810f62d2bad25f30a19392d14d2f235e536c1310f924633aff7f134363fb5ec0", "relations": [{"rule": 2, "type": "equivalent", "target": "82fd6a93aa95c840ae3aea81590e8700", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "810f62d2bad25f30a19392d14d2f235e536c1310f924633aff7f134363fb5ec0"}}, {"rule": 2, "type": "equivalent", "target": "854416bf297531ff4f4f9015bab857f9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "810f62d2bad25f30a19392d14d2f235e536c1310f924633aff7f134363fb5ec0"}}, {"rule": 2, "type": "equivalent", "target": "ebf06686a05aa24118cb50052c738ec5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "810f62d2bad25f30a19392d14d2f235e536c1310f924633aff7f134363fb5ec0"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "82fd6a93aa95c840ae3aea81590e8700", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix pg_restore's processing of old-style large object comments", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "810f62d2bad25f30a19392d14d2f235e536c1310f924633aff7f134363fb5ec0"}, "url": "/docs/compare/?release=9.2.9#9.2.9-4f733d22025ad5a3", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "854416bf297531ff4f4f9015bab857f9", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Fix pg_restore's processing of old-style large object comments", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "810f62d2bad25f30a19392d14d2f235e536c1310f924633aff7f134363fb5ec0"}, "url": "/docs/compare/?release=9.1.14#9.1.14-4f733d22025ad5a3", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "ebf06686a05aa24118cb50052c738ec5", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Fix pg_restore's processing of old-style large object comments", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "810f62d2bad25f30a19392d14d2f235e536c1310f924633aff7f134363fb5ec0"}, "url": "/docs/compare/?release=9.0.18#9.0.18-4f733d22025ad5a3", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-05457a7aecb9275f", "cves": [], "html": "Fix pg_upgrade for cases where the new server creates a TOAST table but the old version did not (Bruce Momjian)
\nThis rare situation would manifest as \"relation OID mismatch\" errors.
", "text": "Fix pg_upgrade for cases where the new server creates a TOAST table but the old version did not (Bruce Momjian) This rare situation would manifest as \"relation OID mismatch\" errors.", "title": "Fix pg_upgrade for cases where the new server creates a TOAST table but the old version did not", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "c22b1e9617357af92d1047f95a887c873d423c85499c6576da09d9ef7425b659", "section_path": ["Changes"], "commit_groups": [["3088cc370", "759c9fb63", "f1d7ff5bb", "f64fe2cbe"]], "identity_text": "Fix pg_upgrade for cases where the new server creates a TOAST table but the old version did not (Bruce Momjian) This rare situation would manifest as relation OID mismatch errors.", "commit_aliases": ["3088cc370", "759c9fb63", "f1d7ff5bb", "f64fe2cbe"], "source_commits": ["f1d7ff5bb"], "source_entry_id": "9.3.5/changes/047", "db_id": "e1d8e96af8fc4c845a900bbfc327c8cf", "patch_ids": ["da4489878fc7ee209c94c9d53e70d248"], "statement_hash": "bc01710955da972814e716873a9f7ac2ab7fcd5ece43c34f8d3f879ec87069c5", "relations": [{"rule": 2, "type": "equivalent", "target": "cddc66904a1df9729425e072ec46abcf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc01710955da972814e716873a9f7ac2ab7fcd5ece43c34f8d3f879ec87069c5"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "cddc66904a1df9729425e072ec46abcf", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix pg_upgrade for cases where the new server creates a TOAST table but the old version did not", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bc01710955da972814e716873a9f7ac2ab7fcd5ece43c34f8d3f879ec87069c5"}, "url": "/docs/compare/?release=9.2.9#9.2.9-05457a7aecb9275f", "source_url": "/docs/release/9.2.9/#AEN112895"}]}, {"id": "9.3.5-c3756dff5b6f70bd", "cves": [], "html": "In pg_upgrade, preserve pg_database.datminmxid and pg_class.relminmxid values from the old cluster, or insert reasonable values when upgrading from pre-9.3; also defend against unreasonable values in the core server (Bruce Momjian, Álvaro Herrera, Tom Lane)
\nThese changes prevent scenarios in which autovacuum might insist on scanning the entire cluster's contents immediately upon starting the new cluster, or in which tracking of unfrozen MXID values might be disabled completely.
", "text": "In pg_upgrade, preserve pg_database.datminmxid and pg_class.relminmxid values from the old cluster, or insert reasonable values when upgrading from pre-9.3; also defend against unreasonable values in the core server (Bruce Momjian, Álvaro Herrera, Tom Lane) These changes prevent scenarios in which autovacuum might insist on scanning the entire cluster's contents immediately upon starting the new cluster, or in which tracking of unfrozen MXID values might be disabled completely.", "title": "In pg_upgrade, preserve pg_database.datminmxid and pg_class.relminmxid values from the old cluster, or insert reasonable values when upgrading from pre-9.3; also defend against unreasonable values in the core server", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "c180f26b0c942592c19f34810a7ce860415f33e491b262ef5cadb84c9c156f0f", "section_path": ["Changes"], "commit_groups": [["3d2e18510", "a61daa14d", "b446a384b"], ["78db307bb", "d122387d7", "e7984cca0"]], "identity_text": "In pg_upgrade, preserve pg_database.datminmxid and pg_class.relminmxid values from the old cluster, or insert reasonable values when upgrading from pre-9.3; also defend against unreasonable values in the core server (Bruce Momjian, Álvaro Herrera, Tom Lane) These changes prevent scenarios in which autovacuum might insist on scanning the entire cluster's contents immediately upon starting the new cluster, or in which tracking of unfrozen MXID values might be disabled completely.", "commit_aliases": ["3d2e18510", "78db307bb", "a61daa14d", "b446a384b", "d122387d7", "e7984cca0"], "source_commits": ["3d2e18510", "e7984cca0"], "source_entry_id": "9.3.5/changes/048", "db_id": "2ef27d63bcf749604f17755bfbe0291c", "patch_ids": ["147a9b4b0a1f433f93e765910ec76d20", "b40cf1cfbd41687780d7540fe2e5a1ea"], "statement_hash": "4c3fe7297f90251df724cc2e7580135b383378c275fcf4d2d4a0e737fc6df925", "relations": [], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.3.5-8aae3d4e04fdf88a", "cves": [], "html": "Prevent contrib/auto_explain from changing the output of a user's EXPLAIN (Tom Lane)
\nIf auto_explain is active, it could cause an EXPLAIN (ANALYZE, TIMING OFF) command to nonetheless print timing information.
", "text": "Prevent contrib/auto_explain from changing the output of a user's EXPLAIN (Tom Lane) If auto_explain is active, it could cause an EXPLAIN (ANALYZE, TIMING OFF) command to nonetheless print timing information.", "title": "Prevent contrib/auto_explain from changing the output of a user's EXPLAIN", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "7174054a047152bf74553102f124a4148c45f21292e4b2541add7fc54f99c636", "section_path": ["Changes"], "commit_groups": [["0266a9c78", "31f579f09", "e416830a2"]], "identity_text": "Prevent contrib/auto_explain from changing the output of a user's EXPLAIN (Tom Lane) If auto_explain is active, it could cause an EXPLAIN (ANALYZE, TIMING OFF) command to nonetheless print timing information.", "commit_aliases": ["0266a9c78", "31f579f09", "e416830a2"], "source_commits": ["0266a9c78"], "source_entry_id": "9.3.5/changes/049", "db_id": "3df678852927dbe67ad10e05c5838d14", "patch_ids": ["df9697a6c804ae31cf7fbaf7ac0ca174"], "statement_hash": "339b402957aa04f4efaa5be2e35669293a1170c25e2eb84f558e2f307b6608e2", "relations": [{"rule": 2, "type": "equivalent", "target": "ecb207e5f03a0c87de60518e18f3f6dd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "339b402957aa04f4efaa5be2e35669293a1170c25e2eb84f558e2f307b6608e2"}}], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "ecb207e5f03a0c87de60518e18f3f6dd", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Prevent contrib/auto_explain from changing the output of a user's EXPLAIN", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "339b402957aa04f4efaa5be2e35669293a1170c25e2eb84f558e2f307b6608e2"}, "url": "/docs/compare/?release=9.2.9#9.2.9-8aae3d4e04fdf88a", "source_url": "/docs/release/9.2.9/#AEN112895"}]}, {"id": "9.3.5-70766c181d53f362", "cves": [], "html": "Fix query-lifespan memory leak in contrib/dblink (MauMau, Joe Conway)
", "text": "Fix query-lifespan memory leak in contrib/dblink (MauMau, Joe Conway)", "title": "Fix query-lifespan memory leak in contrib/dblink", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "0df80b45ae0cdbfcaf19832ceb28f6271d2a1694476353ef8868dc85d1637996", "section_path": ["Changes"], "commit_groups": [["1dde5782e", "3e2cfa42f", "9d884a34c", "b3a3f3d2f"]], "identity_text": "Fix query-lifespan memory leak in contrib/dblink (MauMau, Joe Conway)", "commit_aliases": ["1dde5782e", "3e2cfa42f", "9d884a34c", "b3a3f3d2f"], "source_commits": ["b3a3f3d2f"], "source_entry_id": "9.3.5/changes/050", "db_id": "9e3cd4ee0fc5c915cd33a3c6bb673094", "patch_ids": ["e2a0c75c2a5f8f6bc1358537b0a42128"], "statement_hash": "b9d2cbbf3dc31f537e4ea94ef2f94798eeb8cdd6b28ed23dd8d6ab50cda332c4", "relations": [{"rule": 2, "type": "equivalent", "target": "0bf0da56a8be6b7a8a403cad56024e84", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b9d2cbbf3dc31f537e4ea94ef2f94798eeb8cdd6b28ed23dd8d6ab50cda332c4"}}], "version": "9.3.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "0bf0da56a8be6b7a8a403cad56024e84", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Fix query-lifespan memory leak in contrib/dblink", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b9d2cbbf3dc31f537e4ea94ef2f94798eeb8cdd6b28ed23dd8d6ab50cda332c4"}, "url": "/docs/compare/?release=9.2.9#9.2.9-70766c181d53f362", "source_url": "/docs/release/9.2.9/#AEN112895"}]}, {"id": "9.3.5-fe85ea310afe9618", "cves": [], "html": "In contrib/pgcrypto functions, ensure sensitive information is cleared from stack variables before returning (Marko Kreen)
", "text": "In contrib/pgcrypto functions, ensure sensitive information is cleared from stack variables before returning (Marko Kreen)", "title": "In contrib/pgcrypto functions, ensure sensitive information is cleared from stack variables before returning", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "1025118a5bda595d60aa9795f8d47bfb0dd8391f224c66593d654eb823979ad6", "section_path": ["Changes"], "commit_groups": [["9fe55259f", "a1b9c4630", "df2e62603", "ea8725a8b", "fc02b87e2", "fc72e94a1"]], "identity_text": "In contrib/pgcrypto functions, ensure sensitive information is cleared from stack variables before returning (Marko Kreen)", "commit_aliases": ["9fe55259f", "a1b9c4630", "df2e62603", "ea8725a8b", "fc02b87e2", "fc72e94a1"], "source_commits": ["fc72e94a1"], "source_entry_id": "9.3.5/changes/051", "db_id": "1950470d6df3ffce099f00fdf31d8a6e", "patch_ids": ["a50dc55c85dcf3b5e0ff72e3cba88f76"], "statement_hash": "5efa83f80cfe0fdc6d4ef2579cd86e4982ceb6a50ddd77a58d599dd9c3f4a9d6", "relations": [{"rule": 2, "type": "equivalent", "target": "da3c1ef853655f747a6a5c63dbbec939", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5efa83f80cfe0fdc6d4ef2579cd86e4982ceb6a50ddd77a58d599dd9c3f4a9d6"}}, {"rule": 2, "type": "equivalent", "target": "e46ff2eeb859e50d67e0065ff01d7479", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5efa83f80cfe0fdc6d4ef2579cd86e4982ceb6a50ddd77a58d599dd9c3f4a9d6"}}, {"rule": 2, "type": "equivalent", "target": "f78027492cdf29e6121d9de1919885c4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5efa83f80cfe0fdc6d4ef2579cd86e4982ceb6a50ddd77a58d599dd9c3f4a9d6"}}], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f78027492cdf29e6121d9de1919885c4", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "In contrib/pgcrypto functions, ensure sensitive information is cleared from stack variables before returning", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5efa83f80cfe0fdc6d4ef2579cd86e4982ceb6a50ddd77a58d599dd9c3f4a9d6"}, "url": "/docs/compare/?release=9.2.9#9.2.9-fe85ea310afe9618", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "e46ff2eeb859e50d67e0065ff01d7479", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "In contrib/pgcrypto functions, ensure sensitive information is cleared from stack variables before returning", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5efa83f80cfe0fdc6d4ef2579cd86e4982ceb6a50ddd77a58d599dd9c3f4a9d6"}, "url": "/docs/compare/?release=9.1.14#9.1.14-fe85ea310afe9618", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "da3c1ef853655f747a6a5c63dbbec939", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "In contrib/pgcrypto functions, ensure sensitive information is cleared from stack variables before returning", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5efa83f80cfe0fdc6d4ef2579cd86e4982ceb6a50ddd77a58d599dd9c3f4a9d6"}, "url": "/docs/compare/?release=9.0.18#9.0.18-fe85ea310afe9618", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-bbd3f6d2ff05a8ea", "cves": [], "html": "Prevent use of already-freed memory in contrib/pgstattuple's pgstat_heap() (Noah Misch)
In contrib/uuid-ossp, cache the state of the OSSP UUID library across calls (Tom Lane)
\nThis improves the efficiency of UUID generation and reduces the amount of entropy drawn from /dev/urandom, on platforms that have that.
", "text": "In contrib/uuid-ossp, cache the state of the OSSP UUID library across calls (Tom Lane) This improves the efficiency of UUID generation and reduces the amount of entropy drawn from /dev/urandom, on platforms that have that.", "title": "In contrib/uuid-ossp, cache the state of the OSSP UUID library across calls", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "8e091162a23dcadae6708f895e00dd13f63972a735bd53935ffedb7884e33ee4", "section_path": ["Changes"], "commit_groups": [["2fb9fb661", "3606754da", "961dd203a", "b2f6754d2", "c941aed96", "fd785441f"]], "identity_text": "In contrib/uuid-ossp, cache the state of the OSSP UUID library across calls (Tom Lane) This improves the efficiency of UUID generation and reduces the amount of entropy drawn from /dev/urandom, on platforms that have that.", "commit_aliases": ["2fb9fb661", "3606754da", "961dd203a", "b2f6754d2", "c941aed96", "fd785441f"], "source_commits": ["961dd203a"], "source_entry_id": "9.3.5/changes/053", "db_id": "1326b033b2b56a25227df3cbe1617a36", "patch_ids": ["21d79ba79d1edb3f05bd52144ef3ceb2"], "statement_hash": "bd095415b79f203d378a5a281e6ea63ea7822660df35fd025f8c77580c43717b", "relations": [{"rule": 2, "type": "equivalent", "target": "2d2932d1495af96400c3a66a5188eb46", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bd095415b79f203d378a5a281e6ea63ea7822660df35fd025f8c77580c43717b"}}, {"rule": 2, "type": "equivalent", "target": "e76d1e6b1ab7c2cd7f6aeb6112cdd519", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bd095415b79f203d378a5a281e6ea63ea7822660df35fd025f8c77580c43717b"}}, {"rule": 2, "type": "equivalent", "target": "f10275f87e34a2c9c4ff6de64101c8f6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bd095415b79f203d378a5a281e6ea63ea7822660df35fd025f8c77580c43717b"}}], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "2d2932d1495af96400c3a66a5188eb46", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "In contrib/uuid-ossp, cache the state of the OSSP UUID library across calls", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bd095415b79f203d378a5a281e6ea63ea7822660df35fd025f8c77580c43717b"}, "url": "/docs/compare/?release=9.2.9#9.2.9-8fb92ab1e432e4c6", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "e76d1e6b1ab7c2cd7f6aeb6112cdd519", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "In contrib/uuid-ossp, cache the state of the OSSP UUID library across calls", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bd095415b79f203d378a5a281e6ea63ea7822660df35fd025f8c77580c43717b"}, "url": "/docs/compare/?release=9.1.14#9.1.14-8fb92ab1e432e4c6", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "f10275f87e34a2c9c4ff6de64101c8f6", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "In contrib/uuid-ossp, cache the state of the OSSP UUID library across calls", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "bd095415b79f203d378a5a281e6ea63ea7822660df35fd025f8c77580c43717b"}, "url": "/docs/compare/?release=9.0.18#9.0.18-8fb92ab1e432e4c6", "source_url": "/docs/release/9.0.18/#AEN100028"}]}, {"id": "9.3.5-e8a7de08f947c2d3", "cves": [], "html": "Update time zone data files to tzdata release 2014e for DST law changes in Crimea, Egypt, and Morocco.
", "text": "Update time zone data files to tzdata release 2014e for DST law changes in Crimea, Egypt, and Morocco.", "title": "Update time zone data files to tzdata release 2014e for DST law changes in Crimea, Egypt, and Morocco.", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.3.5/#AEN118153", "source_hash": "ac45f6a95c3457f4cd1c7a5dfbb10a37b6f13c2ab6bce94dddebbc70f24137bf", "section_path": ["Changes"], "commit_groups": [["40ccb6530", "7659b6913", "7d09e4854", "b1864fabf", "bd5458f52", "c51da696b", "e5ea60e80"]], "identity_text": "Update time zone data files to tzdata release 2014e for DST law changes in Crimea, Egypt, and Morocco.", "commit_aliases": ["40ccb6530", "7659b6913", "7d09e4854", "b1864fabf", "bd5458f52", "c51da696b", "e5ea60e80"], "source_commits": ["bd5458f52"], "source_entry_id": "9.3.5/changes/054", "db_id": "0be25c77e3001279f17afc62b5ad0e26", "patch_ids": ["4a0e7dad7bdb0230b538d3287552f7fd"], "statement_hash": "7abe05ad3e342400b3a6f53223c04884cf12ae063e388445fb302f2025000f1a", "relations": [{"rule": 2, "type": "equivalent", "target": "40de67ee53d71ae301c40a9ffdc80562", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7abe05ad3e342400b3a6f53223c04884cf12ae063e388445fb302f2025000f1a"}}, {"rule": 2, "type": "equivalent", "target": "baaed6e0e43e79f2a9ebad4377a39a4f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7abe05ad3e342400b3a6f53223c04884cf12ae063e388445fb302f2025000f1a"}}, {"rule": 2, "type": "equivalent", "target": "f0379227a70a81072cf0b0270ac81b05", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7abe05ad3e342400b3a6f53223c04884cf12ae063e388445fb302f2025000f1a"}}], "version": "9.3.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f0379227a70a81072cf0b0270ac81b05", "kind": "equivalent", "version": "9.2.9", "label": "9.2.9", "title": "Update time zone data files to tzdata release 2014e for DST law changes in Crimea, Egypt, and Morocco.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7abe05ad3e342400b3a6f53223c04884cf12ae063e388445fb302f2025000f1a"}, "url": "/docs/compare/?release=9.2.9#9.2.9-e8a7de08f947c2d3", "source_url": "/docs/release/9.2.9/#AEN112895"}, {"db_id": "baaed6e0e43e79f2a9ebad4377a39a4f", "kind": "equivalent", "version": "9.1.14", "label": "9.1.14", "title": "Update time zone data files to tzdata release 2014e for DST law changes in Crimea, Egypt, and Morocco.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7abe05ad3e342400b3a6f53223c04884cf12ae063e388445fb302f2025000f1a"}, "url": "/docs/compare/?release=9.1.14#9.1.14-e8a7de08f947c2d3", "source_url": "/docs/release/9.1.14/#AEN108337"}, {"db_id": "40de67ee53d71ae301c40a9ffdc80562", "kind": "equivalent", "version": "9.0.18", "label": "9.0.18", "title": "Update time zone data files to tzdata release 2014e for DST law changes in Crimea, Egypt, and Morocco.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7abe05ad3e342400b3a6f53223c04884cf12ae063e388445fb302f2025000f1a"}, "url": "/docs/compare/?release=9.0.18#9.0.18-e8a7de08f947c2d3", "source_url": "/docs/release/9.0.18/#AEN100028"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 54}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 29}, {"key": "security", "label": "Security", "count": 1}, {"key": "performance", "label": "Performance", "count": 1}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 23}], "total": 54, "release_count": 1, "cross_major": false, "cve_count": 1, "cves": [{"id": "CVE-2014-0067", "url": "https://www.postgresql.org/support/security/CVE-2014-0067/", "fixed": {"9.0": "9.0.19", "9.1": "9.1.15", "9.2": "9.2.10", "9.3": "9.3.6", "9.4": "9.4.1"}, "score": 7.0, "title": "Secure Unix-domain sockets of temporary postmasters started during make check", "vector": "AV:L/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:H", "affected": {"9.0": "9.0", "9.1": "9.1", "9.2": "9.2", "9.3": "9.3", "9.4": "9.4"}, "component": "other", "published": {}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": null, "fixed_version": "9.3.6"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 54, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}