A dump/restore is not required for those running 9.0.X.
\nHowever, if you are upgrading from a version earlier than 9.0.13, see Section E.11.
", "compatibility_count": 0, "label": "9.0.14", "status_label": "Historical", "eol": "2015-10-08", "age_days": 4737, "support_days": -4009}, "groups": [{"date": "2013-10-10", "build": "9.0.14", "major": "9.0", "minor": 14, "manual": "9.0", "status": "stable", "doc_git": "", "version": "9.0.14", "eol_date": "2015-10-08", "date_text": "2013-10-10", "supported": false, "manual_url": "/docs/9.0/release-9-0-14.html", "source_url": "/docs/release/9.0.14/", "entry_count": 26, "placeholder": false, "content_hash": "a74126ff069f9f70e98d574ea5794a55d9ae5bcf8a1fefd32bee1f3c3de5eb00", "manual_build": "9.0.23", "source_as_of": "", "changes_count": 26, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 9.0.X.
\nHowever, if you are upgrading from a version earlier than 9.0.13, see Section E.11.
", "compatibility_count": 0, "label": "9.0.14", "status_label": "Historical", "eol": "2015-10-08", "age_days": 4737, "support_days": -4009, "entries": [{"id": "9.0.14-4788c97eb34df15e", "cves": [], "html": "Prevent corruption of multi-byte characters when attempting to case-fold identifiers (Andrew Dunstan)
\nPostgreSQL case-folds non-ASCII characters only when using a single-byte server encoding.
", "text": "Prevent corruption of multi-byte characters when attempting to case-fold identifiers (Andrew Dunstan) PostgreSQL case-folds non-ASCII characters only when using a single-byte server encoding.", "title": "Prevent corruption of multi-byte characters when attempting to case-fold identifiers", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "11a06fa6929a2a0541da741e1d6c9645de1176b7e2a7eaa7d3a6c6993b7a166c", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent corruption of multi-byte characters when attempting to case-fold identifiers (Andrew Dunstan) PostgreSQL case-folds non-ASCII characters only when using a single-byte server encoding.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/001", "db_id": "7542aeda2d3e673506ae4452f9d1b340", "patch_ids": [], "statement_hash": "b5d1ad072c70f9f300ff57aea85501a36d733d18d86da01ffefef77e7b88ec3e", "relations": [{"rule": 2, "type": "equivalent", "target": "0a70cbd04367b3c99b361d487ea3c3fe", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b5d1ad072c70f9f300ff57aea85501a36d733d18d86da01ffefef77e7b88ec3e"}}, {"rule": 2, "type": "equivalent", "target": "70121dc524aaebe1c211fc12ef344c52", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b5d1ad072c70f9f300ff57aea85501a36d733d18d86da01ffefef77e7b88ec3e"}}], "version": "9.0.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "0a70cbd04367b3c99b361d487ea3c3fe", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Prevent corruption of multi-byte characters when attempting to case-fold identifiers", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b5d1ad072c70f9f300ff57aea85501a36d733d18d86da01ffefef77e7b88ec3e"}, "url": "/docs/compare/?release=9.2.5#9.2.5-4788c97eb34df15e", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "70121dc524aaebe1c211fc12ef344c52", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Prevent corruption of multi-byte characters when attempting to case-fold identifiers", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b5d1ad072c70f9f300ff57aea85501a36d733d18d86da01ffefef77e7b88ec3e"}, "url": "/docs/compare/?release=9.1.10#9.1.10-4788c97eb34df15e", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-df68b0b274d1d97d", "cves": [], "html": "Fix checkpoint memory leak in background writer when wal_level = hot_standby (Naoya Anzai)
", "text": "Fix checkpoint memory leak in background writer when wal_level = hot_standby (Naoya Anzai)", "title": "Fix checkpoint memory leak in background writer when wal_level = hot_standby", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "df74181d0930439f43ec3307acc7280b5e72600b7641664ee8075cc9ee785591", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix checkpoint memory leak in background writer when wal_level = hot_standby (Naoya Anzai)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/002", "db_id": "b2473f1a7e469c8900b92ca621567bb6", "patch_ids": [], "statement_hash": "e5b3af68d32c7827551c7393ed5dabe13d392a26d4305af1020fc080e93bccdd", "relations": [{"rule": 2, "type": "equivalent", "target": "09c9c313bfb0ba27aaa3080e77617922", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e5b3af68d32c7827551c7393ed5dabe13d392a26d4305af1020fc080e93bccdd"}}, {"rule": 2, "type": "equivalent", "target": "36e8deec6bb06913c333a9cf9f4ce58d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e5b3af68d32c7827551c7393ed5dabe13d392a26d4305af1020fc080e93bccdd"}}], "version": "9.0.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "36e8deec6bb06913c333a9cf9f4ce58d", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Fix checkpoint memory leak in background writer when wal_level = hot_standby", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e5b3af68d32c7827551c7393ed5dabe13d392a26d4305af1020fc080e93bccdd"}, "url": "/docs/compare/?release=9.2.5#9.2.5-df68b0b274d1d97d", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "09c9c313bfb0ba27aaa3080e77617922", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Fix checkpoint memory leak in background writer when wal_level = hot_standby", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e5b3af68d32c7827551c7393ed5dabe13d392a26d4305af1020fc080e93bccdd"}, "url": "/docs/compare/?release=9.1.10#9.1.10-df68b0b274d1d97d", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-f03d995dadb45be3", "cves": [], "html": "Fix memory leak caused by lo_open() failure (Heikki Linnakangas)
Fix memory overcommit bug when work_mem is using more than 24GB of memory (Stephen Frost)
", "text": "Fix memory overcommit bug when work_mem is using more than 24GB of memory (Stephen Frost)", "title": "Fix memory overcommit bug when work_mem is using more than 24GB of memory", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "dac46b900844be782b8c23bd6028a78366eb8e2f9622323ef0ca1ede58ecb402", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix memory overcommit bug when work_mem is using more than 24GB of memory (Stephen Frost)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/004", "db_id": "63d5291ebd45fc0979e17d1b677928b3", "patch_ids": [], "statement_hash": "1e7cf91f221b7e95f26136b8a9fd9a94179df4c4b6d2f18133377d4511936ed0", "relations": [{"rule": 2, "type": "equivalent", "target": "9b19ab0744703238ddf91599d1ad31d8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1e7cf91f221b7e95f26136b8a9fd9a94179df4c4b6d2f18133377d4511936ed0"}}, {"rule": 2, "type": "equivalent", "target": "ea87665aed325b2a400f33b5e213ecba", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1e7cf91f221b7e95f26136b8a9fd9a94179df4c4b6d2f18133377d4511936ed0"}}], "version": "9.0.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "ea87665aed325b2a400f33b5e213ecba", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Fix memory overcommit bug when work_mem is using more than 24GB of memory", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1e7cf91f221b7e95f26136b8a9fd9a94179df4c4b6d2f18133377d4511936ed0"}, "url": "/docs/compare/?release=9.2.5#9.2.5-4f95ad99bebcd478", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "9b19ab0744703238ddf91599d1ad31d8", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Fix memory overcommit bug when work_mem is using more than 24GB of memory", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1e7cf91f221b7e95f26136b8a9fd9a94179df4c4b6d2f18133377d4511936ed0"}, "url": "/docs/compare/?release=9.1.10#9.1.10-4f95ad99bebcd478", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-f5f890101162d2d4", "cves": [], "html": "Fix deadlock bug in libpq when using SSL (Stephen Frost)
", "text": "Fix deadlock bug in libpq when using SSL (Stephen Frost)", "title": "Fix deadlock bug in libpq when using SSL", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "3fba32b17ef4948a36223661c41e75f719ceb04594bb4256366df0b16a443229", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix deadlock bug in libpq when using SSL (Stephen Frost)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/005", "db_id": "57c1c2b14328df07d1fff5b5855231d5", "patch_ids": [], "statement_hash": "984982162628393d0e46c8710db3a0bc436993546530df45ff69a60ea6c2371f", "relations": [{"rule": 2, "type": "equivalent", "target": "237ecc0fb2de96e0467467b4a6ddc257", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "984982162628393d0e46c8710db3a0bc436993546530df45ff69a60ea6c2371f"}}, {"rule": 2, "type": "equivalent", "target": "6aa0428b6fdf47b0a1bcf5230033bf4d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "984982162628393d0e46c8710db3a0bc436993546530df45ff69a60ea6c2371f"}}, {"rule": 2, "type": "equivalent", "target": "9c82054ba2b8bff7fe6cbd12ce8ce608", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "984982162628393d0e46c8710db3a0bc436993546530df45ff69a60ea6c2371f"}}], "version": "9.0.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "6aa0428b6fdf47b0a1bcf5230033bf4d", "kind": "equivalent", "version": "9.3.1", "label": "9.3.1", "title": "Fix deadlock bug in libpq when using SSL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "984982162628393d0e46c8710db3a0bc436993546530df45ff69a60ea6c2371f"}, "url": "/docs/compare/?release=9.3.1#9.3.1-f5f890101162d2d4", "source_url": "/docs/release/9.3.1/#AEN118992"}, {"db_id": "9c82054ba2b8bff7fe6cbd12ce8ce608", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Fix deadlock bug in libpq when using SSL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "984982162628393d0e46c8710db3a0bc436993546530df45ff69a60ea6c2371f"}, "url": "/docs/compare/?release=9.2.5#9.2.5-f5f890101162d2d4", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "237ecc0fb2de96e0467467b4a6ddc257", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Fix deadlock bug in libpq when using SSL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "984982162628393d0e46c8710db3a0bc436993546530df45ff69a60ea6c2371f"}, "url": "/docs/compare/?release=9.1.10#9.1.10-f5f890101162d2d4", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-bbbe42a2db5bffd6", "cves": [], "html": "Fix possible SSL state corruption in threaded libpq applications (Nick Phillips, Stephen Frost)
", "text": "Fix possible SSL state corruption in threaded libpq applications (Nick Phillips, Stephen Frost)", "title": "Fix possible SSL state corruption in threaded libpq applications", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "3f2477da1ed28bee3e4f18e570e2220ba41b11f004d4b528d7c7ed101fcd33dc", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix possible SSL state corruption in threaded libpq applications (Nick Phillips, Stephen Frost)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/006", "db_id": "b254a8445459d944142e870ce4f1e716", "patch_ids": [], "statement_hash": "6c48127c24c77fc19f07babaaa8ededaf968ef303f3c8e2b2aaadea8cb5f0e8f", "relations": [{"rule": 2, "type": "equivalent", "target": "cc499787f74e0b03f2c45b7755625cb3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6c48127c24c77fc19f07babaaa8ededaf968ef303f3c8e2b2aaadea8cb5f0e8f"}}, {"rule": 2, "type": "equivalent", "target": "ed1bd2051a3fb060b9155b1b09810032", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6c48127c24c77fc19f07babaaa8ededaf968ef303f3c8e2b2aaadea8cb5f0e8f"}}], "version": "9.0.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "cc499787f74e0b03f2c45b7755625cb3", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Fix possible SSL state corruption in threaded libpq applications", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6c48127c24c77fc19f07babaaa8ededaf968ef303f3c8e2b2aaadea8cb5f0e8f"}, "url": "/docs/compare/?release=9.2.5#9.2.5-bbbe42a2db5bffd6", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "ed1bd2051a3fb060b9155b1b09810032", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Fix possible SSL state corruption in threaded libpq applications", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6c48127c24c77fc19f07babaaa8ededaf968ef303f3c8e2b2aaadea8cb5f0e8f"}, "url": "/docs/compare/?release=9.1.10#9.1.10-bbbe42a2db5bffd6", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-84b0cca19e5255aa", "cves": [], "html": "Properly compute row estimates for boolean columns containing many NULL values (Andrew Gierth)
\nPreviously tests like col IS NOT TRUE and col IS NOT FALSE did not properly factor in NULL values when estimating plan costs.
", "text": "Properly compute row estimates for boolean columns containing many NULL values (Andrew Gierth) Previously tests like col IS NOT TRUE and col IS NOT FALSE did not properly factor in NULL values when estimating plan costs.", "title": "Properly compute row estimates for boolean columns containing many NULL values", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "0d1c5257038d7c5ac39b13708f5cfd938d74e42488b3bdabf7f30ef4ee361c94", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Properly compute row estimates for boolean columns containing many NULL values (Andrew Gierth) Previously tests like col IS NOT TRUE and col IS NOT FALSE did not properly factor in NULL values when estimating plan costs.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/007", "db_id": "e1c7c31d4d4c930790cea3087b7bd1d1", "patch_ids": [], "statement_hash": "acd9771c5a977d1b1e9f63bfb90798762458e23d3df4da3e93b7652a6982b540", "relations": [{"rule": 2, "type": "equivalent", "target": "71fcd8debff3ada481a788d9ab8bb817", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "acd9771c5a977d1b1e9f63bfb90798762458e23d3df4da3e93b7652a6982b540"}}, {"rule": 2, "type": "equivalent", "target": "95b025bba0b5dfb270a39c1b98bb099c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "acd9771c5a977d1b1e9f63bfb90798762458e23d3df4da3e93b7652a6982b540"}}], "version": "9.0.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "95b025bba0b5dfb270a39c1b98bb099c", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Properly compute row estimates for boolean columns containing many NULL values", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "acd9771c5a977d1b1e9f63bfb90798762458e23d3df4da3e93b7652a6982b540"}, "url": "/docs/compare/?release=9.2.5#9.2.5-84b0cca19e5255aa", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "71fcd8debff3ada481a788d9ab8bb817", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Properly compute row estimates for boolean columns containing many NULL values", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "acd9771c5a977d1b1e9f63bfb90798762458e23d3df4da3e93b7652a6982b540"}, "url": "/docs/compare/?release=9.1.10#9.1.10-84b0cca19e5255aa", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-3ebeb6b8672c220f", "cves": [], "html": "Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT subqueries (Tom Lane)
\nSubqueries of a UNION or INTERSECT that contain set-returning functions or volatile functions in their SELECT lists could be improperly optimized, leading to run-time errors or incorrect query results.
", "text": "Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT subqueries (Tom Lane) Subqueries of a UNION or INTERSECT that contain set-returning functions or volatile functions in their SELECT lists could be improperly optimized, leading to run-time errors or incorrect query results.", "title": "Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT subqueries", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "d1575cef4c99a8688f6eeb385480427a90b9b28cdb4bfc293823d1e33066fd07", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT subqueries (Tom Lane) Subqueries of a UNION or INTERSECT that contain set-returning functions or volatile functions in their SELECT lists could be improperly optimized, leading to run-time errors or incorrect query results.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/008", "db_id": "eb6ed6a15490cd526d82847a776e45c4", "patch_ids": [], "statement_hash": "3b26b9301ec481ef8f8255e151d75d0a59c356a78adb502f92c2b597fa12c71e", "relations": [{"rule": 2, "type": "equivalent", "target": "143581629a716b10db750d76fb0bfcd8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3b26b9301ec481ef8f8255e151d75d0a59c356a78adb502f92c2b597fa12c71e"}}, {"rule": 2, "type": "equivalent", "target": "5b6f6b627157035c78e19e81ac017d28", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3b26b9301ec481ef8f8255e151d75d0a59c356a78adb502f92c2b597fa12c71e"}}], "version": "9.0.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "143581629a716b10db750d76fb0bfcd8", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT subqueries", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3b26b9301ec481ef8f8255e151d75d0a59c356a78adb502f92c2b597fa12c71e"}, "url": "/docs/compare/?release=9.2.5#9.2.5-3ebeb6b8672c220f", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "5b6f6b627157035c78e19e81ac017d28", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Prevent pushing down WHERE clauses into unsafe UNION/INTERSECT subqueries", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3b26b9301ec481ef8f8255e151d75d0a59c356a78adb502f92c2b597fa12c71e"}, "url": "/docs/compare/?release=9.1.10#9.1.10-3ebeb6b8672c220f", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-8e9fe62d5a915d11", "cves": [], "html": "Fix rare case of \"failed to locate grouping columns\" planner failure (Tom Lane)
", "text": "Fix rare case of \"failed to locate grouping columns\" planner failure (Tom Lane)", "title": "Fix rare case of \"failed to locate grouping columns\" planner failure", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "b16165c6c7e8cb98931be1edfba6f8b0a95543954d9a9780bddd9a5b95714a47", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix rare case of failed to locate grouping columns planner failure (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/009", "db_id": "ccd832f07c22869e8cc7441967c12072", "patch_ids": [], "statement_hash": "970d7e3ab2640ea269042d80cb2cecd9d868a95e990122eba428cc099008b126", "relations": [{"rule": 2, "type": "equivalent", "target": "69b3b5cc732989a23dcbe44045632073", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "970d7e3ab2640ea269042d80cb2cecd9d868a95e990122eba428cc099008b126"}}, {"rule": 2, "type": "equivalent", "target": "dea49ad831cc86034dc9f1cb8326580b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "970d7e3ab2640ea269042d80cb2cecd9d868a95e990122eba428cc099008b126"}}], "version": "9.0.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "69b3b5cc732989a23dcbe44045632073", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Fix rare case of \"failed to locate grouping columns\" planner failure", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "970d7e3ab2640ea269042d80cb2cecd9d868a95e990122eba428cc099008b126"}, "url": "/docs/compare/?release=9.2.5#9.2.5-8e9fe62d5a915d11", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "dea49ad831cc86034dc9f1cb8326580b", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Fix rare case of \"failed to locate grouping columns\" planner failure", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "970d7e3ab2640ea269042d80cb2cecd9d868a95e990122eba428cc099008b126"}, "url": "/docs/compare/?release=9.1.10#9.1.10-8e9fe62d5a915d11", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-31c1c41cc0ab9658", "cves": [], "html": "Improve view dumping code's handling of dropped columns in referenced tables (Tom Lane)
", "text": "Improve view dumping code's handling of dropped columns in referenced tables (Tom Lane)", "title": "Improve view dumping code's handling of dropped columns in referenced tables", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "edd20863c50b1aaf790aa7e45648b49955a3f29b58b58acf1b876a1a5c6388a5", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Improve view dumping code's handling of dropped columns in referenced tables (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/010", "db_id": "e7e36cc4981b3e16bbe63d25d7eca0af", "patch_ids": [], "statement_hash": "5dc06c245ea4e3c3ed6ad7f50f3829f6da126e4513db103f92f5dfd1b7aca22e", "relations": [{"rule": 2, "type": "equivalent", "target": "81ee2f983abfd8b0131b512c9350f0a1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5dc06c245ea4e3c3ed6ad7f50f3829f6da126e4513db103f92f5dfd1b7aca22e"}}, {"rule": 2, "type": "equivalent", "target": "cd6e07eeed1dd934e9e80f82f71d7097", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5dc06c245ea4e3c3ed6ad7f50f3829f6da126e4513db103f92f5dfd1b7aca22e"}}], "version": "9.0.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "81ee2f983abfd8b0131b512c9350f0a1", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Improve view dumping code's handling of dropped columns in referenced tables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5dc06c245ea4e3c3ed6ad7f50f3829f6da126e4513db103f92f5dfd1b7aca22e"}, "url": "/docs/compare/?release=9.2.5#9.2.5-31c1c41cc0ab9658", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "cd6e07eeed1dd934e9e80f82f71d7097", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Improve view dumping code's handling of dropped columns in referenced tables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5dc06c245ea4e3c3ed6ad7f50f3829f6da126e4513db103f92f5dfd1b7aca22e"}, "url": "/docs/compare/?release=9.1.10#9.1.10-31c1c41cc0ab9658", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-05e9f1d39fbd9a2b", "cves": [], "html": "Properly record index comments created using UNIQUE and PRIMARY KEY syntax (Andres Freund)
\nThis fixes a parallel pg_restore failure.
", "text": "Properly record index comments created using UNIQUE and PRIMARY KEY syntax (Andres Freund) This fixes a parallel pg_restore failure.", "title": "Properly record index comments created using UNIQUE and PRIMARY KEY syntax", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "7e117aaa89ff09bda2bf2b9314ff33c27f515a640b38872fa18b8f251f27b8b5", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Properly record index comments created using UNIQUE and PRIMARY KEY syntax (Andres Freund) This fixes a parallel pg_restore failure.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/011", "db_id": "213090e885c6702e2269f49eb8c805cf", "patch_ids": [], "statement_hash": "a4f815f24b33e1ace54df4b23b0bdf97eebee8456a5e0b2b888255fea3904161", "relations": [{"rule": 2, "type": "equivalent", "target": "28017140b2415e1ab9f23d37ccea9c8b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a4f815f24b33e1ace54df4b23b0bdf97eebee8456a5e0b2b888255fea3904161"}}, {"rule": 2, "type": "equivalent", "target": "ad5ef03d0909bb13782689bcf2c31c86", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a4f815f24b33e1ace54df4b23b0bdf97eebee8456a5e0b2b888255fea3904161"}}], "version": "9.0.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "ad5ef03d0909bb13782689bcf2c31c86", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Properly record index comments created using UNIQUE and PRIMARY KEY syntax", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a4f815f24b33e1ace54df4b23b0bdf97eebee8456a5e0b2b888255fea3904161"}, "url": "/docs/compare/?release=9.2.5#9.2.5-05e9f1d39fbd9a2b", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "28017140b2415e1ab9f23d37ccea9c8b", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Properly record index comments created using UNIQUE and PRIMARY KEY syntax", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a4f815f24b33e1ace54df4b23b0bdf97eebee8456a5e0b2b888255fea3904161"}, "url": "/docs/compare/?release=9.1.10#9.1.10-05e9f1d39fbd9a2b", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-1651dffe82f10616", "cves": [], "html": "Fix REINDEX TABLE and REINDEX DATABASE to properly revalidate constraints and mark invalidated indexes as valid (Noah Misch)
\nREINDEX INDEX has always worked properly.
", "text": "Fix REINDEX TABLE and REINDEX DATABASE to properly revalidate constraints and mark invalidated indexes as valid (Noah Misch) REINDEX INDEX has always worked properly.", "title": "Fix REINDEX TABLE and REINDEX DATABASE to properly revalidate constraints and mark invalidated indexes as valid", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "7ef9dfc92027edca1b54905b6b22dfb5e0a1c992f73ae9ab4550032ced655a82", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix REINDEX TABLE and REINDEX DATABASE to properly revalidate constraints and mark invalidated indexes as valid (Noah Misch) REINDEX INDEX has always worked properly.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/012", "db_id": "9bf0ba3f2719837330299f84814a77c2", "patch_ids": [], "statement_hash": "e808ce552a71424934f6979c5957cbb58c736c2825209130973b02092995e289", "relations": [{"rule": 2, "type": "equivalent", "target": "b798973f5d9c73404a9660cebcc12192", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e808ce552a71424934f6979c5957cbb58c736c2825209130973b02092995e289"}}, {"rule": 2, "type": "equivalent", "target": "bd7ed2622d8ff054de82ca4b7b8fa044", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e808ce552a71424934f6979c5957cbb58c736c2825209130973b02092995e289"}}], "version": "9.0.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "bd7ed2622d8ff054de82ca4b7b8fa044", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Fix REINDEX TABLE and REINDEX DATABASE to properly revalidate constraints and mark invalidated indexes as valid", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e808ce552a71424934f6979c5957cbb58c736c2825209130973b02092995e289"}, "url": "/docs/compare/?release=9.2.5#9.2.5-1651dffe82f10616", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "b798973f5d9c73404a9660cebcc12192", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Fix REINDEX TABLE and REINDEX DATABASE to properly revalidate constraints and mark invalidated indexes as valid", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e808ce552a71424934f6979c5957cbb58c736c2825209130973b02092995e289"}, "url": "/docs/compare/?release=9.1.10#9.1.10-1651dffe82f10616", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-79361d36ee5c56d8", "cves": [], "html": "Fix possible deadlock during concurrent CREATE INDEX CONCURRENTLY operations (Tom Lane)
", "text": "Fix possible deadlock during concurrent CREATE INDEX CONCURRENTLY operations (Tom Lane)", "title": "Fix possible deadlock during concurrent CREATE INDEX CONCURRENTLY operations", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "9b0d57e1ecf4be87608ba59861f66724e8a0c407f70f9ceb56cadf1f02e4e45c", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix possible deadlock during concurrent CREATE INDEX CONCURRENTLY operations (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/013", "db_id": "34d803e0faf05502579cd2c749c4d06c", "patch_ids": [], "statement_hash": "6bbc423de7b8b33d5399038be308e289004ccbf65eb5f0ec62b383801aded9fe", "relations": [{"rule": 2, "type": "equivalent", "target": "597ad5f9ac792018f03f656fcaed7b08", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bbc423de7b8b33d5399038be308e289004ccbf65eb5f0ec62b383801aded9fe"}}, {"rule": 2, "type": "equivalent", "target": "a6e72b65cf2d3ce1ac39cdca7c6677bb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bbc423de7b8b33d5399038be308e289004ccbf65eb5f0ec62b383801aded9fe"}}], "version": "9.0.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "597ad5f9ac792018f03f656fcaed7b08", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Fix possible deadlock during concurrent CREATE INDEX CONCURRENTLY operations", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bbc423de7b8b33d5399038be308e289004ccbf65eb5f0ec62b383801aded9fe"}, "url": "/docs/compare/?release=9.2.5#9.2.5-79361d36ee5c56d8", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "a6e72b65cf2d3ce1ac39cdca7c6677bb", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Fix possible deadlock during concurrent CREATE INDEX CONCURRENTLY operations", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6bbc423de7b8b33d5399038be308e289004ccbf65eb5f0ec62b383801aded9fe"}, "url": "/docs/compare/?release=9.1.10#9.1.10-79361d36ee5c56d8", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-fa9f85bcf997d8d3", "cves": [], "html": "Fix regexp_matches() handling of zero-length matches (Jeevan Chalke)
Previously, zero-length matches like '^' could return too many matches.
", "text": "Fix regexp_matches() handling of zero-length matches (Jeevan Chalke) Previously, zero-length matches like '^' could return too many matches.", "title": "Fix regexp_matches() handling of zero-length matches", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "22374c4b5161e16d6c03538cabc23c2064d039264b8088a36d845366dab9665f", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix regexp_matches() handling of zero-length matches (Jeevan Chalke) Previously, zero-length matches like '^' could return too many matches.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/014", "db_id": "6511e37c5c9c85dd3ed499e05bef81e4", "patch_ids": [], "statement_hash": "3f081543591cb151c0a0fbb43aa0f4b894b790b86bb48db337acc979495cf4ec", "relations": [{"rule": 2, "type": "equivalent", "target": "a475d3560abf5f280d85e3efe8965619", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3f081543591cb151c0a0fbb43aa0f4b894b790b86bb48db337acc979495cf4ec"}}, {"rule": 2, "type": "equivalent", "target": "f8b2d522976f38acc9099d4b41603906", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3f081543591cb151c0a0fbb43aa0f4b894b790b86bb48db337acc979495cf4ec"}}], "version": "9.0.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "a475d3560abf5f280d85e3efe8965619", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Fix regexp_matches() handling of zero-length matches", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3f081543591cb151c0a0fbb43aa0f4b894b790b86bb48db337acc979495cf4ec"}, "url": "/docs/compare/?release=9.2.5#9.2.5-fa9f85bcf997d8d3", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "f8b2d522976f38acc9099d4b41603906", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Fix regexp_matches() handling of zero-length matches", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3f081543591cb151c0a0fbb43aa0f4b894b790b86bb48db337acc979495cf4ec"}, "url": "/docs/compare/?release=9.1.10#9.1.10-fa9f85bcf997d8d3", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-bf87323801a7930d", "cves": [], "html": "Fix crash for overly-complex regular expressions (Heikki Linnakangas)
", "text": "Fix crash for overly-complex regular expressions (Heikki Linnakangas)", "title": "Fix crash for overly-complex regular expressions", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "45ab2fc351cee279603c9a6dd8a14eb3267828fe43db8182546b1e557ff176e1", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix crash for overly-complex regular expressions (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/015", "db_id": "e8f536eba73f883e86ab7c9670247535", "patch_ids": [], "statement_hash": "184dd1657b138851c4a71789544d9a5dd1e05a9372ccda9f8a62d82d8406fca8", "relations": [{"rule": 2, "type": "equivalent", "target": "2bb0df631faf418882dfc5d1e1fd7dda", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "184dd1657b138851c4a71789544d9a5dd1e05a9372ccda9f8a62d82d8406fca8"}}, {"rule": 2, "type": "equivalent", "target": "d55d42495cf06636b5f2d8ee454f2536", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "184dd1657b138851c4a71789544d9a5dd1e05a9372ccda9f8a62d82d8406fca8"}}], "version": "9.0.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2bb0df631faf418882dfc5d1e1fd7dda", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Fix crash for overly-complex regular expressions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "184dd1657b138851c4a71789544d9a5dd1e05a9372ccda9f8a62d82d8406fca8"}, "url": "/docs/compare/?release=9.2.5#9.2.5-bf87323801a7930d", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "d55d42495cf06636b5f2d8ee454f2536", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Fix crash for overly-complex regular expressions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "184dd1657b138851c4a71789544d9a5dd1e05a9372ccda9f8a62d82d8406fca8"}, "url": "/docs/compare/?release=9.1.10#9.1.10-bf87323801a7930d", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-5f87384fb05ebde9", "cves": [], "html": "Fix regular expression match failures for back references combined with non-greedy quantifiers (Jeevan Chalke)
", "text": "Fix regular expression match failures for back references combined with non-greedy quantifiers (Jeevan Chalke)", "title": "Fix regular expression match failures for back references combined with non-greedy quantifiers", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "261feecea3243213cda8b1f2ee6b31547bfc38ce2ff6292b16b291f35b18fd13", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix regular expression match failures for back references combined with non-greedy quantifiers (Jeevan Chalke)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/016", "db_id": "bacaffbafcdc345f1f8dc11456b087b4", "patch_ids": [], "statement_hash": "d507bfe0e0088860cfbba49a25c9ed82185512af4f09900c1f4268648c2662b0", "relations": [{"rule": 2, "type": "equivalent", "target": "3b3f4a21b29a8d3dc5ba3c6f7a7e8c61", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d507bfe0e0088860cfbba49a25c9ed82185512af4f09900c1f4268648c2662b0"}}, {"rule": 2, "type": "equivalent", "target": "8cbbe988eacbecd86eed1031c64c6bcb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d507bfe0e0088860cfbba49a25c9ed82185512af4f09900c1f4268648c2662b0"}}], "version": "9.0.14", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "3b3f4a21b29a8d3dc5ba3c6f7a7e8c61", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Fix regular expression match failures for back references combined with non-greedy quantifiers", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d507bfe0e0088860cfbba49a25c9ed82185512af4f09900c1f4268648c2662b0"}, "url": "/docs/compare/?release=9.2.5#9.2.5-5f87384fb05ebde9", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "8cbbe988eacbecd86eed1031c64c6bcb", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Fix regular expression match failures for back references combined with non-greedy quantifiers", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d507bfe0e0088860cfbba49a25c9ed82185512af4f09900c1f4268648c2662b0"}, "url": "/docs/compare/?release=9.1.10#9.1.10-5f87384fb05ebde9", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-b03405d9f39f9186", "cves": [], "html": "Prevent CREATE FUNCTION from checking SET variables unless function body checking is enabled (Tom Lane)
", "text": "Prevent CREATE FUNCTION from checking SET variables unless function body checking is enabled (Tom Lane)", "title": "Prevent CREATE FUNCTION from checking SET variables unless function body checking is enabled", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "bd9e8c215fa2f75455ad26ec6fb8e733df68be9a3245d6d918a74a3c473a4128", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent CREATE FUNCTION from checking SET variables unless function body checking is enabled (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/017", "db_id": "0cc8abd693ef1496bda0846c2a0be99d", "patch_ids": [], "statement_hash": "83af4d120cca6f2f5fb585cb136dc024ff3def29b9dbc29ed3e29e633da65ef2", "relations": [{"rule": 2, "type": "equivalent", "target": "4b7ff29db9a4dd18c6378a2775cece9c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "83af4d120cca6f2f5fb585cb136dc024ff3def29b9dbc29ed3e29e633da65ef2"}}, {"rule": 2, "type": "equivalent", "target": "952098d7106adf07d8708504ded36cdc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "83af4d120cca6f2f5fb585cb136dc024ff3def29b9dbc29ed3e29e633da65ef2"}}, {"rule": 2, "type": "equivalent", "target": "bab837642eb334b82c387136f2b5db7a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "83af4d120cca6f2f5fb585cb136dc024ff3def29b9dbc29ed3e29e633da65ef2"}}], "version": "9.0.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "952098d7106adf07d8708504ded36cdc", "kind": "equivalent", "version": "9.3.1", "label": "9.3.1", "title": "Prevent CREATE FUNCTION from checking SET variables unless function body checking is enabled", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "83af4d120cca6f2f5fb585cb136dc024ff3def29b9dbc29ed3e29e633da65ef2"}, "url": "/docs/compare/?release=9.3.1#9.3.1-b03405d9f39f9186", "source_url": "/docs/release/9.3.1/#AEN118992"}, {"db_id": "4b7ff29db9a4dd18c6378a2775cece9c", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Prevent CREATE FUNCTION from checking SET variables unless function body checking is enabled", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "83af4d120cca6f2f5fb585cb136dc024ff3def29b9dbc29ed3e29e633da65ef2"}, "url": "/docs/compare/?release=9.2.5#9.2.5-b03405d9f39f9186", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "bab837642eb334b82c387136f2b5db7a", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Prevent CREATE FUNCTION from checking SET variables unless function body checking is enabled", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "83af4d120cca6f2f5fb585cb136dc024ff3def29b9dbc29ed3e29e633da65ef2"}, "url": "/docs/compare/?release=9.1.10#9.1.10-b03405d9f39f9186", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-c4763471ad29c1b3", "cves": [], "html": "Allow ALTER DEFAULT PRIVILEGES to operate on schemas without requiring CREATE permission (Tom Lane)
", "text": "Allow ALTER DEFAULT PRIVILEGES to operate on schemas without requiring CREATE permission (Tom Lane)", "title": "Allow ALTER DEFAULT PRIVILEGES to operate on schemas without requiring CREATE permission", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "2e88e6a1ef73221c5baf639d24db044e58dc5e3b7a7397a0b29d3d70dc28497a", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Allow ALTER DEFAULT PRIVILEGES to operate on schemas without requiring CREATE permission (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/018", "db_id": "ed1fa9a0964254054b8b97a0c8cb89b3", "patch_ids": [], "statement_hash": "3dadddc190109b5af0593979e711241828934ce634a867ac55e888a13614b662", "relations": [{"rule": 2, "type": "equivalent", "target": "17d543029b439d30c459e6ac4af1b9e9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3dadddc190109b5af0593979e711241828934ce634a867ac55e888a13614b662"}}, {"rule": 2, "type": "equivalent", "target": "76758e22eeb09e42b36e71ad1ef2edab", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3dadddc190109b5af0593979e711241828934ce634a867ac55e888a13614b662"}}], "version": "9.0.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "17d543029b439d30c459e6ac4af1b9e9", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Allow ALTER DEFAULT PRIVILEGES to operate on schemas without requiring CREATE permission", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3dadddc190109b5af0593979e711241828934ce634a867ac55e888a13614b662"}, "url": "/docs/compare/?release=9.2.5#9.2.5-c4763471ad29c1b3", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "76758e22eeb09e42b36e71ad1ef2edab", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Allow ALTER DEFAULT PRIVILEGES to operate on schemas without requiring CREATE permission", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3dadddc190109b5af0593979e711241828934ce634a867ac55e888a13614b662"}, "url": "/docs/compare/?release=9.1.10#9.1.10-c4763471ad29c1b3", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-1e0e947fd6a411ba", "cves": [], "html": "Loosen restriction on keywords used in queries (Tom Lane)
\nSpecifically, lessen keyword restrictions for role names, language names, EXPLAIN and COPY options, and SET values. This allows COPY ... (FORMAT BINARY) to work as expected; previously BINARY needed to be quoted.
", "text": "Loosen restriction on keywords used in queries (Tom Lane) Specifically, lessen keyword restrictions for role names, language names, EXPLAIN and COPY options, and SET values. This allows COPY ... (FORMAT BINARY) to work as expected; previously BINARY needed to be quoted.", "title": "Loosen restriction on keywords used in queries", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "dcf425236ea15c47418d5c19b67979ac5ed4ea2064fa35512003e93c10272418", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Loosen restriction on keywords used in queries (Tom Lane) Specifically, lessen keyword restrictions for role names, language names, EXPLAIN and COPY options, and SET values. This allows COPY ... (FORMAT BINARY) to work as expected; previously BINARY needed to be quoted.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/019", "db_id": "778b513ca23debcf6ed633e3deb4822b", "patch_ids": [], "statement_hash": "133c2d7168397d3958833e22719ea9b78678ed52f004f023dc0c0e4737307593", "relations": [{"rule": 2, "type": "equivalent", "target": "8cb6845a33ed6ddefd8d5ac8ca8b5f2f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "133c2d7168397d3958833e22719ea9b78678ed52f004f023dc0c0e4737307593"}}, {"rule": 2, "type": "equivalent", "target": "d23e8108c2ee2dc596a8a5a0251b2bcd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "133c2d7168397d3958833e22719ea9b78678ed52f004f023dc0c0e4737307593"}}], "version": "9.0.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "d23e8108c2ee2dc596a8a5a0251b2bcd", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Loosen restriction on keywords used in queries", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "133c2d7168397d3958833e22719ea9b78678ed52f004f023dc0c0e4737307593"}, "url": "/docs/compare/?release=9.2.5#9.2.5-1e0e947fd6a411ba", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "8cb6845a33ed6ddefd8d5ac8ca8b5f2f", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Loosen restriction on keywords used in queries", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "133c2d7168397d3958833e22719ea9b78678ed52f004f023dc0c0e4737307593"}, "url": "/docs/compare/?release=9.1.10#9.1.10-1e0e947fd6a411ba", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-418d6bb0808e3cb1", "cves": [], "html": "Fix pgp_pub_decrypt() so it works for secret keys with passwords (Marko Kreen)
Remove rare inaccurate warning during vacuum of index-less tables (Heikki Linnakangas)
", "text": "Remove rare inaccurate warning during vacuum of index-less tables (Heikki Linnakangas)", "title": "Remove rare inaccurate warning during vacuum of index-less tables", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "7aa5eb89f3c6a0ec137fcbd5c9f38f57c97d7957ebc7569bce7ae77132ce0c3d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Remove rare inaccurate warning during vacuum of index-less tables (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/021", "db_id": "f19dec60ba95d259d851bea1ba274eb5", "patch_ids": [], "statement_hash": "f2968be5e00a32929b39816877d8ba644f35c32c2b62614107a0c7638403ed39", "relations": [{"rule": 2, "type": "equivalent", "target": "1cd4e08d8d8118ced058999f7694a5df", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2968be5e00a32929b39816877d8ba644f35c32c2b62614107a0c7638403ed39"}}, {"rule": 2, "type": "equivalent", "target": "35fa6bf292d6d773149d2968283feee6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2968be5e00a32929b39816877d8ba644f35c32c2b62614107a0c7638403ed39"}}, {"rule": 2, "type": "equivalent", "target": "b693deb5d849d6fa745ce608ef1c7b19", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2968be5e00a32929b39816877d8ba644f35c32c2b62614107a0c7638403ed39"}}], "version": "9.0.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "35fa6bf292d6d773149d2968283feee6", "kind": "equivalent", "version": "9.3.1", "label": "9.3.1", "title": "Remove rare inaccurate warning during vacuum of index-less tables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2968be5e00a32929b39816877d8ba644f35c32c2b62614107a0c7638403ed39"}, "url": "/docs/compare/?release=9.3.1#9.3.1-36de488529f17611", "source_url": "/docs/release/9.3.1/#AEN118992"}, {"db_id": "1cd4e08d8d8118ced058999f7694a5df", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Remove rare inaccurate warning during vacuum of index-less tables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2968be5e00a32929b39816877d8ba644f35c32c2b62614107a0c7638403ed39"}, "url": "/docs/compare/?release=9.2.5#9.2.5-36de488529f17611", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "b693deb5d849d6fa745ce608ef1c7b19", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Remove rare inaccurate warning during vacuum of index-less tables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f2968be5e00a32929b39816877d8ba644f35c32c2b62614107a0c7638403ed39"}, "url": "/docs/compare/?release=9.1.10#9.1.10-36de488529f17611", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-1a78ef1321d9d965", "cves": [], "html": "Ensure that VACUUM ANALYZE still runs the ANALYZE phase if its attempt to truncate the file is cancelled due to lock conflicts (Kevin Grittner)
", "text": "Ensure that VACUUM ANALYZE still runs the ANALYZE phase if its attempt to truncate the file is cancelled due to lock conflicts (Kevin Grittner)", "title": "Ensure that VACUUM ANALYZE still runs the ANALYZE phase if its attempt to truncate the file is cancelled due to lock conflicts", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "881f0e0c6ff3e436b528ade7f45d8de4154dea90e3e130e9ed40aaaf873132ec", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ensure that VACUUM ANALYZE still runs the ANALYZE phase if its attempt to truncate the file is cancelled due to lock conflicts (Kevin Grittner)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/022", "db_id": "e44245b453c01c01b78957813101a36d", "patch_ids": [], "statement_hash": "f1ae966156c78dae9a9602775d7f27071e0bcc13d355654bd12c511900f4e8a0", "relations": [{"rule": 2, "type": "equivalent", "target": "329d9ef42297e4348384a8790f1183a2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f1ae966156c78dae9a9602775d7f27071e0bcc13d355654bd12c511900f4e8a0"}}, {"rule": 2, "type": "equivalent", "target": "e16fc46a6be285e4b688120496344804", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f1ae966156c78dae9a9602775d7f27071e0bcc13d355654bd12c511900f4e8a0"}}], "version": "9.0.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "329d9ef42297e4348384a8790f1183a2", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Ensure that VACUUM ANALYZE still runs the ANALYZE phase if its attempt to truncate the file is cancelled due to lock conflicts", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f1ae966156c78dae9a9602775d7f27071e0bcc13d355654bd12c511900f4e8a0"}, "url": "/docs/compare/?release=9.2.5#9.2.5-1a78ef1321d9d965", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "e16fc46a6be285e4b688120496344804", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Ensure that VACUUM ANALYZE still runs the ANALYZE phase if its attempt to truncate the file is cancelled due to lock conflicts", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f1ae966156c78dae9a9602775d7f27071e0bcc13d355654bd12c511900f4e8a0"}, "url": "/docs/compare/?release=9.1.10#9.1.10-1a78ef1321d9d965", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-ad10ce9af7697552", "cves": [], "html": "Avoid possible failure when performing transaction control commands (e.g ROLLBACK) in prepared queries (Tom Lane)
", "text": "Avoid possible failure when performing transaction control commands (e.g ROLLBACK) in prepared queries (Tom Lane)", "title": "Avoid possible failure when performing transaction control commands (e.g ROLLBACK) in prepared queries", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "94bd992ec812b2c0256537f35d03ba9dca96253229b63fff82e9183570576068", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid possible failure when performing transaction control commands (e.g ROLLBACK) in prepared queries (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/023", "db_id": "3bdb9eef2523e1c419cee9ac485fa8c3", "patch_ids": [], "statement_hash": "f20c1fba0f6315ea0c4f56ae950d030dd0b0ef3f318bcfe11736e2cb3eb4ffde", "relations": [{"rule": 2, "type": "equivalent", "target": "099f366475e9805dd5b4cacd95613bbd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f20c1fba0f6315ea0c4f56ae950d030dd0b0ef3f318bcfe11736e2cb3eb4ffde"}}, {"rule": 2, "type": "equivalent", "target": "cfb3145c217068c70d2506d8888b9e4a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f20c1fba0f6315ea0c4f56ae950d030dd0b0ef3f318bcfe11736e2cb3eb4ffde"}}], "version": "9.0.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "099f366475e9805dd5b4cacd95613bbd", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Avoid possible failure when performing transaction control commands (e.g ROLLBACK) in prepared queries", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f20c1fba0f6315ea0c4f56ae950d030dd0b0ef3f318bcfe11736e2cb3eb4ffde"}, "url": "/docs/compare/?release=9.2.5#9.2.5-ad10ce9af7697552", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "cfb3145c217068c70d2506d8888b9e4a", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Avoid possible failure when performing transaction control commands (e.g ROLLBACK) in prepared queries", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f20c1fba0f6315ea0c4f56ae950d030dd0b0ef3f318bcfe11736e2cb3eb4ffde"}, "url": "/docs/compare/?release=9.1.10#9.1.10-ad10ce9af7697552", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-0cdfdbff292c1359", "cves": [], "html": "Ensure that floating-point data input accepts standard spellings of \"infinity\" on all platforms (Tom Lane)
\nThe C99 standard says that allowable spellings are inf, +inf, -inf, infinity, +infinity, and -infinity. Make sure we recognize these even if the platform's strtod function doesn't.
Expand ability to compare rows to records and arrays (Rafal Rzepecki, Tom Lane)
", "text": "Expand ability to compare rows to records and arrays (Rafal Rzepecki, Tom Lane)", "title": "Expand ability to compare rows to records and arrays", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "aaf2be50cb5549081c920550c1227da592059f7c8613b77d11ff0a59bc1da7a8", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Expand ability to compare rows to records and arrays (Rafal Rzepecki, Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/025", "db_id": "1b3122e225254f5fc0a24dd7aeb691e4", "patch_ids": [], "statement_hash": "cc060c998f552a7bbdfb26921cd9062f207e679a40f64080d6f326630f5a2a98", "relations": [{"rule": 2, "type": "equivalent", "target": "70036d240e6fe9f29afef9c496dfab89", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc060c998f552a7bbdfb26921cd9062f207e679a40f64080d6f326630f5a2a98"}}, {"rule": 2, "type": "equivalent", "target": "9855ad016b5e0ab86a8df92448726524", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc060c998f552a7bbdfb26921cd9062f207e679a40f64080d6f326630f5a2a98"}}], "version": "9.0.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "70036d240e6fe9f29afef9c496dfab89", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Expand ability to compare rows to records and arrays", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc060c998f552a7bbdfb26921cd9062f207e679a40f64080d6f326630f5a2a98"}, "url": "/docs/compare/?release=9.2.5#9.2.5-38d603bd36b0592d", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "9855ad016b5e0ab86a8df92448726524", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Expand ability to compare rows to records and arrays", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cc060c998f552a7bbdfb26921cd9062f207e679a40f64080d6f326630f5a2a98"}, "url": "/docs/compare/?release=9.1.10#9.1.10-38d603bd36b0592d", "source_url": "/docs/release/9.1.10/#AEN108834"}]}, {"id": "9.0.14-b607fb1a097dc08b", "cves": [], "html": "Update time zone data files to tzdata release 2013d for DST law changes in Israel, Morocco, Palestine, and Paraguay. Also, historical zone data corrections for Macquarie Island.
", "text": "Update time zone data files to tzdata release 2013d for DST law changes in Israel, Morocco, Palestine, and Paraguay. Also, historical zone data corrections for Macquarie Island.", "title": "Update time zone data files to tzdata release 2013d for DST law changes in Israel, Morocco, Palestine, and Paraguay. Also, historical zone data corrections for Macquarie Island.", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.14/#AEN100480", "source_hash": "0971b99e00dafa59672e6a97380c44bfa5e351821497acffc2c99eec1221d969", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Update time zone data files to tzdata release 2013d for DST law changes in Israel, Morocco, Palestine, and Paraguay. Also, historical zone data corrections for Macquarie Island.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.14/changes/026", "db_id": "b278718a133b05177d8594b3d6d307fc", "patch_ids": [], "statement_hash": "08508412bf38f9d298431494294852d308b35e618c05bf24a40f8b00356cbf8b", "relations": [{"rule": 2, "type": "equivalent", "target": "6ac228e374f30e6ab6340c2340835596", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "08508412bf38f9d298431494294852d308b35e618c05bf24a40f8b00356cbf8b"}}, {"rule": 2, "type": "equivalent", "target": "caf175df83719743a7e3dd3a70deae2a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "08508412bf38f9d298431494294852d308b35e618c05bf24a40f8b00356cbf8b"}}], "version": "9.0.14", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "6ac228e374f30e6ab6340c2340835596", "kind": "equivalent", "version": "9.2.5", "label": "9.2.5", "title": "Update time zone data files to tzdata release 2013d for DST law changes in Israel, Morocco, Palestine, and Paraguay. Also, historical zone data corrections for Macquarie Island.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "08508412bf38f9d298431494294852d308b35e618c05bf24a40f8b00356cbf8b"}, "url": "/docs/compare/?release=9.2.5#9.2.5-b607fb1a097dc08b", "source_url": "/docs/release/9.2.5/#AEN113495"}, {"db_id": "caf175df83719743a7e3dd3a70deae2a", "kind": "equivalent", "version": "9.1.10", "label": "9.1.10", "title": "Update time zone data files to tzdata release 2013d for DST law changes in Israel, Morocco, Palestine, and Paraguay. Also, historical zone data corrections for Macquarie Island.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "08508412bf38f9d298431494294852d308b35e618c05bf24a40f8b00356cbf8b"}, "url": "/docs/compare/?release=9.1.10#9.1.10-b607fb1a097dc08b", "source_url": "/docs/release/9.1.10/#AEN108834"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 26}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 13}, {"key": "security", "label": "Security", "count": 0}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 13}], "total": 26, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 26, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}