A dump/restore is not required for those running 9.1.X.
\nHowever, if you are upgrading from a version earlier than 9.1.6, see Section E.19.
", "compatibility_count": 0, "label": "9.1.7", "status_label": "Historical", "eol": "2016-10-27", "age_days": 5045, "support_days": -3624}, "groups": [{"date": "2012-12-06", "build": "9.1.7", "major": "9.1", "minor": 7, "manual": "9.1", "status": "stable", "doc_git": "", "version": "9.1.7", "eol_date": "2016-10-27", "date_text": "2012-12-06", "supported": false, "manual_url": "/docs/9.1/release-9-1-7.html", "source_url": "/docs/release/9.1.7/", "entry_count": 40, "placeholder": false, "content_hash": "f265d9af682622f64da9c646f33f8f4c18dcbd3074bae99ff86d66a0620fdeab", "manual_build": "9.1.24", "source_as_of": "", "changes_count": 40, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 9.1.X.
\nHowever, if you are upgrading from a version earlier than 9.1.6, see Section E.19.
", "compatibility_count": 0, "label": "9.1.7", "status_label": "Historical", "eol": "2016-10-27", "age_days": 5045, "support_days": -3624, "entries": [{"id": "9.1.7-72a152ea470fd693", "cves": [], "html": "Fix multiple bugs associated with CREATE INDEX CONCURRENTLY (Andres Freund, Tom Lane)
\nFix CREATE INDEX CONCURRENTLY to use in-place updates when changing the state of an index's pg_index row. This prevents race conditions that could cause concurrent sessions to miss updating the target index, thus resulting in corrupt concurrently-created indexes.
\nAlso, fix various other operations to ensure that they ignore invalid indexes resulting from a failed CREATE INDEX CONCURRENTLY command. The most important of these is VACUUM, because an auto-vacuum could easily be launched on the table before corrective action can be taken to fix or remove the invalid index.
", "text": "Fix multiple bugs associated with CREATE INDEX CONCURRENTLY (Andres Freund, Tom Lane) Fix CREATE INDEX CONCURRENTLY to use in-place updates when changing the state of an index's pg_index row. This prevents race conditions that could cause concurrent sessions to miss updating the target index, thus resulting in corrupt concurrently-created indexes. Also, fix various other operations to ensure that they ignore invalid indexes resulting from a failed CREATE INDEX CONCURRENTLY command. The most important of these is VACUUM, because an auto-vacuum could easily be launched on the table before corrective action can be taken to fix or remove the invalid index.", "title": "Fix multiple bugs associated with CREATE INDEX CONCURRENTLY", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "6a52ae275bbd3333fff930b487a2922474e0768f8875360a90877c4f907340e6", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix multiple bugs associated with CREATE INDEX CONCURRENTLY (Andres Freund, Tom Lane) Fix CREATE INDEX CONCURRENTLY to use in-place updates when changing the state of an index's pg_index row. This prevents race conditions that could cause concurrent sessions to miss updating the target index, thus resulting in corrupt concurrently-created indexes. Also, fix various other operations to ensure that they ignore invalid indexes resulting from a failed CREATE INDEX CONCURRENTLY command. The most important of these is VACUUM, because an auto-vacuum could easily be launched on the table before corrective action can be taken to fix or remove the invalid index.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/001", "db_id": "499c27583c780cd5c3db07e09d09dc90", "patch_ids": [], "statement_hash": "54dd5f9a185fcd2f5a896a4ee94697467d661c2bac02edebd986c5fb78ba029a", "relations": [{"rule": 2, "type": "equivalent", "target": "b2840c276b352f4023446d129bc7a65b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "54dd5f9a185fcd2f5a896a4ee94697467d661c2bac02edebd986c5fb78ba029a"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "b2840c276b352f4023446d129bc7a65b", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Fix multiple bugs associated with CREATE INDEX CONCURRENTLY", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "54dd5f9a185fcd2f5a896a4ee94697467d661c2bac02edebd986c5fb78ba029a"}, "url": "/docs/compare/?release=9.0.11#9.0.11-72a152ea470fd693", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-3faf76ae3a5ef741", "cves": [], "html": "Fix buffer locking during WAL replay (Tom Lane)
\nThe WAL replay code was insufficiently careful about locking buffers when replaying WAL records that affect more than one page. This could result in hot standby queries transiently seeing inconsistent states, resulting in wrong answers or unexpected failures.
", "text": "Fix buffer locking during WAL replay (Tom Lane) The WAL replay code was insufficiently careful about locking buffers when replaying WAL records that affect more than one page. This could result in hot standby queries transiently seeing inconsistent states, resulting in wrong answers or unexpected failures.", "title": "Fix buffer locking during WAL replay", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "f3ad85a69cb0fe4f28e73af374c610f73e8a6ca20b12192d848ba7101078bf65", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix buffer locking during WAL replay (Tom Lane) The WAL replay code was insufficiently careful about locking buffers when replaying WAL records that affect more than one page. This could result in hot standby queries transiently seeing inconsistent states, resulting in wrong answers or unexpected failures.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/002", "db_id": "51098e75a70f44f43bede962baf0776b", "patch_ids": [], "statement_hash": "e60c460aec8e3c9fc9dadf8e58b4d72ff7a4b7734c8a83dc7aba0cdf554f03cb", "relations": [{"rule": 2, "type": "equivalent", "target": "40ae178c8033f11d304a3c3509516eac", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e60c460aec8e3c9fc9dadf8e58b4d72ff7a4b7734c8a83dc7aba0cdf554f03cb"}}, {"rule": 2, "type": "equivalent", "target": "c90990678a48b2df18d527d1a6597839", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e60c460aec8e3c9fc9dadf8e58b4d72ff7a4b7734c8a83dc7aba0cdf554f03cb"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c90990678a48b2df18d527d1a6597839", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix buffer locking during WAL replay", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e60c460aec8e3c9fc9dadf8e58b4d72ff7a4b7734c8a83dc7aba0cdf554f03cb"}, "url": "/docs/compare/?release=9.2.2#9.2.2-3faf76ae3a5ef741", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "40ae178c8033f11d304a3c3509516eac", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Fix buffer locking during WAL replay", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e60c460aec8e3c9fc9dadf8e58b4d72ff7a4b7734c8a83dc7aba0cdf554f03cb"}, "url": "/docs/compare/?release=9.0.11#9.0.11-3faf76ae3a5ef741", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-05dad3feb78887a6", "cves": [], "html": "Fix an error in WAL generation logic for GIN indexes (Tom Lane)
\nThis could result in index corruption, if a torn-page failure occurred.
", "text": "Fix an error in WAL generation logic for GIN indexes (Tom Lane) This could result in index corruption, if a torn-page failure occurred.", "title": "Fix an error in WAL generation logic for GIN indexes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "8cd84ace00cac71de460526697f63628f127b72b111c0b96122ddb7a7ee37a0d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix an error in WAL generation logic for GIN indexes (Tom Lane) This could result in index corruption, if a torn-page failure occurred.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/003", "db_id": "8207df19f289120274af27c78d800fbe", "patch_ids": [], "statement_hash": "6adaef02f5128971832f4f52b2eb357eab62949951a055b67884f2ec00423c9d", "relations": [{"rule": 2, "type": "equivalent", "target": "635e3c5d90dacf55981ea265aefd4964", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6adaef02f5128971832f4f52b2eb357eab62949951a055b67884f2ec00423c9d"}}, {"rule": 2, "type": "equivalent", "target": "e4d26ec763e422d94eb9141ced9f4baf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6adaef02f5128971832f4f52b2eb357eab62949951a055b67884f2ec00423c9d"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "e4d26ec763e422d94eb9141ced9f4baf", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix an error in WAL generation logic for GIN indexes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6adaef02f5128971832f4f52b2eb357eab62949951a055b67884f2ec00423c9d"}, "url": "/docs/compare/?release=9.2.2#9.2.2-05dad3feb78887a6", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "635e3c5d90dacf55981ea265aefd4964", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Fix an error in WAL generation logic for GIN indexes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6adaef02f5128971832f4f52b2eb357eab62949951a055b67884f2ec00423c9d"}, "url": "/docs/compare/?release=9.0.11#9.0.11-05dad3feb78887a6", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-db97be21ad2a5ddd", "cves": [], "html": "Properly remove startup process's virtual XID lock when promoting a hot standby server to normal running (Simon Riggs)
\nThis oversight could prevent subsequent execution of certain operations such as CREATE INDEX CONCURRENTLY.
", "text": "Properly remove startup process's virtual XID lock when promoting a hot standby server to normal running (Simon Riggs) This oversight could prevent subsequent execution of certain operations such as CREATE INDEX CONCURRENTLY.", "title": "Properly remove startup process's virtual XID lock when promoting a hot standby server to normal running", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "f9f08a000a77ffc265b056b8fef86da92f8aa0646b5d6f700de547f57cd09403", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Properly remove startup process's virtual XID lock when promoting a hot standby server to normal running (Simon Riggs) This oversight could prevent subsequent execution of certain operations such as CREATE INDEX CONCURRENTLY.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/004", "db_id": "9cc10929afd331b2305654f79430dcf8", "patch_ids": [], "statement_hash": "4a9b2c80ac821dd5928b1876cdc8462934249088a00d592e929c1bee51b00ded", "relations": [{"rule": 2, "type": "equivalent", "target": "b61e982a76c8926258760d94b1704113", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4a9b2c80ac821dd5928b1876cdc8462934249088a00d592e929c1bee51b00ded"}}, {"rule": 2, "type": "equivalent", "target": "c466a121372cdd90134fd1b120a87e93", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4a9b2c80ac821dd5928b1876cdc8462934249088a00d592e929c1bee51b00ded"}}], "version": "9.1.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "c466a121372cdd90134fd1b120a87e93", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Properly remove startup process's virtual XID lock when promoting a hot standby server to normal running", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4a9b2c80ac821dd5928b1876cdc8462934249088a00d592e929c1bee51b00ded"}, "url": "/docs/compare/?release=9.2.2#9.2.2-db97be21ad2a5ddd", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "b61e982a76c8926258760d94b1704113", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Properly remove startup process's virtual XID lock when promoting a hot standby server to normal running", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4a9b2c80ac821dd5928b1876cdc8462934249088a00d592e929c1bee51b00ded"}, "url": "/docs/compare/?release=9.0.11#9.0.11-db97be21ad2a5ddd", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-1ddb9cd7df22022e", "cves": [], "html": "Avoid bogus \"out-of-sequence timeline ID\" errors in standby mode (Heikki Linnakangas)
", "text": "Avoid bogus \"out-of-sequence timeline ID\" errors in standby mode (Heikki Linnakangas)", "title": "Avoid bogus \"out-of-sequence timeline ID\" errors in standby mode", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "abdf5933d88a9d85ef219bf8d3a66042810f12e1700f5949c13102d0a7af39c1", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid bogus out-of-sequence timeline ID errors in standby mode (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/005", "db_id": "944a6245c1950c2f542905a7b945924b", "patch_ids": [], "statement_hash": "070e01732b0c4aae3265e7558b8bc1e9b7096f4343c11c05390d846ebfdbdb4e", "relations": [{"rule": 2, "type": "equivalent", "target": "a73ebde118090b70ad873ee747ae6fce", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "070e01732b0c4aae3265e7558b8bc1e9b7096f4343c11c05390d846ebfdbdb4e"}}, {"rule": 2, "type": "equivalent", "target": "b049f106277487122b03a575e1920a9d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "070e01732b0c4aae3265e7558b8bc1e9b7096f4343c11c05390d846ebfdbdb4e"}}], "version": "9.1.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b049f106277487122b03a575e1920a9d", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Avoid bogus \"out-of-sequence timeline ID\" errors in standby mode", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "070e01732b0c4aae3265e7558b8bc1e9b7096f4343c11c05390d846ebfdbdb4e"}, "url": "/docs/compare/?release=9.2.2#9.2.2-1ddb9cd7df22022e", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "a73ebde118090b70ad873ee747ae6fce", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Avoid bogus \"out-of-sequence timeline ID\" errors in standby mode", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "070e01732b0c4aae3265e7558b8bc1e9b7096f4343c11c05390d846ebfdbdb4e"}, "url": "/docs/compare/?release=9.0.11#9.0.11-1ddb9cd7df22022e", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-8e04c71a842b6307", "cves": [], "html": "Prevent the postmaster from launching new child processes after it's received a shutdown signal (Tom Lane)
\nThis mistake could result in shutdown taking longer than it should, or even never completing at all without additional user action.
", "text": "Prevent the postmaster from launching new child processes after it's received a shutdown signal (Tom Lane) This mistake could result in shutdown taking longer than it should, or even never completing at all without additional user action.", "title": "Prevent the postmaster from launching new child processes after it's received a shutdown signal", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "449a9186f9989a6820a44762e3aba7bff93f81732b475746ebd1663dbe293451", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent the postmaster from launching new child processes after it's received a shutdown signal (Tom Lane) This mistake could result in shutdown taking longer than it should, or even never completing at all without additional user action.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/006", "db_id": "91dfcffb3a9197d924b2e4b668ca9e4f", "patch_ids": [], "statement_hash": "99fd94185ca0637ca1c92b531dffc37cd7bcc00f111ae89e0e474d2579475dc1", "relations": [{"rule": 2, "type": "equivalent", "target": "7bb04e99a81c258771653ee206166f8c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "99fd94185ca0637ca1c92b531dffc37cd7bcc00f111ae89e0e474d2579475dc1"}}, {"rule": 2, "type": "equivalent", "target": "cc631e18ec7f9c6daa6037bb9bc71d30", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "99fd94185ca0637ca1c92b531dffc37cd7bcc00f111ae89e0e474d2579475dc1"}}], "version": "9.1.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "cc631e18ec7f9c6daa6037bb9bc71d30", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Prevent the postmaster from launching new child processes after it's received a shutdown signal", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "99fd94185ca0637ca1c92b531dffc37cd7bcc00f111ae89e0e474d2579475dc1"}, "url": "/docs/compare/?release=9.2.2#9.2.2-8e04c71a842b6307", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "7bb04e99a81c258771653ee206166f8c", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Prevent the postmaster from launching new child processes after it's received a shutdown signal", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "99fd94185ca0637ca1c92b531dffc37cd7bcc00f111ae89e0e474d2579475dc1"}, "url": "/docs/compare/?release=9.0.11#9.0.11-8e04c71a842b6307", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-fb7447585a5d9f55", "cves": [], "html": "Avoid corruption of internal hash tables when out of memory (Hitoshi Harada)
", "text": "Avoid corruption of internal hash tables when out of memory (Hitoshi Harada)", "title": "Avoid corruption of internal hash tables when out of memory", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "a8294e9464bf1147c27b90a4910cd6e56f7bd182e44c6587c7a83e725b1082c5", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid corruption of internal hash tables when out of memory (Hitoshi Harada)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/007", "db_id": "b450e9ab7f4b930fa19f8dc789b0b3d3", "patch_ids": [], "statement_hash": "692dad544f7fd81c5f29ab0c6fafa30584c4bac66915d29dc7ba7dadfaac1e6c", "relations": [{"rule": 2, "type": "equivalent", "target": "3efd3d2a6c52b704801ca0bac42dc0dd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "692dad544f7fd81c5f29ab0c6fafa30584c4bac66915d29dc7ba7dadfaac1e6c"}}, {"rule": 2, "type": "equivalent", "target": "ccd960e69197616945fb716f47fd5dbb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "692dad544f7fd81c5f29ab0c6fafa30584c4bac66915d29dc7ba7dadfaac1e6c"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "ccd960e69197616945fb716f47fd5dbb", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Avoid corruption of internal hash tables when out of memory", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "692dad544f7fd81c5f29ab0c6fafa30584c4bac66915d29dc7ba7dadfaac1e6c"}, "url": "/docs/compare/?release=9.2.2#9.2.2-fb7447585a5d9f55", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "3efd3d2a6c52b704801ca0bac42dc0dd", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Avoid corruption of internal hash tables when out of memory", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "692dad544f7fd81c5f29ab0c6fafa30584c4bac66915d29dc7ba7dadfaac1e6c"}, "url": "/docs/compare/?release=9.0.11#9.0.11-fb7447585a5d9f55", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-04a814c172f9e7c4", "cves": [], "html": "Prevent file descriptors for dropped tables from being held open past transaction end (Tom Lane)
\nThis should reduce problems with long-since-dropped tables continuing to occupy disk space.
", "text": "Prevent file descriptors for dropped tables from being held open past transaction end (Tom Lane) This should reduce problems with long-since-dropped tables continuing to occupy disk space.", "title": "Prevent file descriptors for dropped tables from being held open past transaction end", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "d4e049db33a633fdcc538bceb7e0862b6975bcdcaa274fa94f9eb233a56373bd", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent file descriptors for dropped tables from being held open past transaction end (Tom Lane) This should reduce problems with long-since-dropped tables continuing to occupy disk space.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/008", "db_id": "6e66ce2e8c8f93c1f4fa828afda55a0b", "patch_ids": [], "statement_hash": "a779b6476a507f403fa28e4a688301b1c35e51f3123dab951471998392d0076d", "relations": [{"rule": 2, "type": "equivalent", "target": "6ce12a724fd73e1b58d9c01cf31948a5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a779b6476a507f403fa28e4a688301b1c35e51f3123dab951471998392d0076d"}}], "version": "9.1.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "6ce12a724fd73e1b58d9c01cf31948a5", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Prevent file descriptors for dropped tables from being held open past transaction end", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a779b6476a507f403fa28e4a688301b1c35e51f3123dab951471998392d0076d"}, "url": "/docs/compare/?release=9.2.2#9.2.2-04a814c172f9e7c4", "source_url": "/docs/release/9.2.2/#AEN114013"}]}, {"id": "9.1.7-5178f533861fcab9", "cves": [], "html": "Prevent database-wide crash and restart when a new child process is unable to create a pipe for its latch (Tom Lane)
\nAlthough the new process must fail, there is no good reason to force a database-wide restart, so avoid that. This improves robustness when the kernel is nearly out of file descriptors.
", "text": "Prevent database-wide crash and restart when a new child process is unable to create a pipe for its latch (Tom Lane) Although the new process must fail, there is no good reason to force a database-wide restart, so avoid that. This improves robustness when the kernel is nearly out of file descriptors.", "title": "Prevent database-wide crash and restart when a new child process is unable to create a pipe for its latch", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "b63f9e26ce474ff675205c35aef0c70062859f8a380eec49c23b484bd490caf2", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent database-wide crash and restart when a new child process is unable to create a pipe for its latch (Tom Lane) Although the new process must fail, there is no good reason to force a database-wide restart, so avoid that. This improves robustness when the kernel is nearly out of file descriptors.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/009", "db_id": "00a2b56bed2c0e2e3b716aea1d88aec6", "patch_ids": [], "statement_hash": "a9e60e42dcf2a246ad5e97d7c9dda2ee6b9b49e99efe41d54fdb9d8626035505", "relations": [{"rule": 2, "type": "equivalent", "target": "e3a7e046628b9c7e0d7dc0cc8aa895ac", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9e60e42dcf2a246ad5e97d7c9dda2ee6b9b49e99efe41d54fdb9d8626035505"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "e3a7e046628b9c7e0d7dc0cc8aa895ac", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Prevent database-wide crash and restart when a new child process is unable to create a pipe for its latch", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a9e60e42dcf2a246ad5e97d7c9dda2ee6b9b49e99efe41d54fdb9d8626035505"}, "url": "/docs/compare/?release=9.2.2#9.2.2-5178f533861fcab9", "source_url": "/docs/release/9.2.2/#AEN114013"}]}, {"id": "9.1.7-360318898a468ac8", "cves": [], "html": "Fix planning of non-strict equivalence clauses above outer joins (Tom Lane)
\nThe planner could derive incorrect constraints from a clause equating a non-strict construct to something else, for example WHERE COALESCE(foo, 0) = 0 when foo is coming from the nullable side of an outer join.
", "text": "Fix planning of non-strict equivalence clauses above outer joins (Tom Lane) The planner could derive incorrect constraints from a clause equating a non-strict construct to something else, for example WHERE COALESCE(foo, 0) = 0 when foo is coming from the nullable side of an outer join.", "title": "Fix planning of non-strict equivalence clauses above outer joins", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "237ec65016a8b7bb1375bbc9ce07bc2b52909bbaa9101e9baec28a20395e1b0f", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix planning of non-strict equivalence clauses above outer joins (Tom Lane) The planner could derive incorrect constraints from a clause equating a non-strict construct to something else, for example WHERE COALESCE(foo, 0) = 0 when foo is coming from the nullable side of an outer join.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/010", "db_id": "fcf142b1ad5d013312f6364395d1f527", "patch_ids": [], "statement_hash": "d2f4d0b4d2e98da344c0c70bb910fca8fdfd0d4e770069c510d085e77b5325d4", "relations": [{"rule": 2, "type": "equivalent", "target": "1d07e402072cfad037c33e7653b6b251", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d2f4d0b4d2e98da344c0c70bb910fca8fdfd0d4e770069c510d085e77b5325d4"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "1d07e402072cfad037c33e7653b6b251", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Fix planning of non-strict equivalence clauses above outer joins", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d2f4d0b4d2e98da344c0c70bb910fca8fdfd0d4e770069c510d085e77b5325d4"}, "url": "/docs/compare/?release=9.0.11#9.0.11-360318898a468ac8", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-3e03b12e4725fe1f", "cves": [], "html": "Fix SELECT DISTINCT with index-optimized MIN/MAX on an inheritance tree (Tom Lane)
The planner would fail with \"failed to re-find MinMaxAggInfo record\" given this combination of factors.
", "text": "Fix SELECT DISTINCT with index-optimized MIN/MAX on an inheritance tree (Tom Lane) The planner would fail with \"failed to re-find MinMaxAggInfo record\" given this combination of factors.", "title": "Fix SELECT DISTINCT with index-optimized MIN/MAX on an inheritance tree", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "fcec2135a04bf655e7f9c7be129fdc4f017712503f6cea0ed254ef56c3c31c6e", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix SELECT DISTINCT with index-optimized MIN/MAX on an inheritance tree (Tom Lane) The planner would fail with failed to re-find MinMaxAggInfo record given this combination of factors.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/011", "db_id": "a7723dfb5c90c9c8ffe5c46e170276f7", "patch_ids": [], "statement_hash": "edf4fe22357b70fd0ac9bdd1bc5a0a4c900951151b9aedf7d7690ec8e0b0c4bf", "relations": [{"rule": 2, "type": "equivalent", "target": "77dbfd50bbe61e3e4dcdf868550af6a6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "edf4fe22357b70fd0ac9bdd1bc5a0a4c900951151b9aedf7d7690ec8e0b0c4bf"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "77dbfd50bbe61e3e4dcdf868550af6a6", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix SELECT DISTINCT with index-optimized MIN/MAX on an inheritance tree", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "edf4fe22357b70fd0ac9bdd1bc5a0a4c900951151b9aedf7d7690ec8e0b0c4bf"}, "url": "/docs/compare/?release=9.2.2#9.2.2-3e03b12e4725fe1f", "source_url": "/docs/release/9.2.2/#AEN114013"}]}, {"id": "9.1.7-512e9d623e42c94b", "cves": [], "html": "Improve planner's ability to prove exclusion constraints from equivalence classes (Tom Lane)
", "text": "Improve planner's ability to prove exclusion constraints from equivalence classes (Tom Lane)", "title": "Improve planner's ability to prove exclusion constraints from equivalence classes", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "67b86c5282f84a4eb939d7ed7607f2fe476fbd2f48c5530c8687442738101f33", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Improve planner's ability to prove exclusion constraints from equivalence classes (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/012", "db_id": "85637202a3c850b068330ec258f3b8ef", "patch_ids": [], "statement_hash": "d4f25cd0593297709d677f0beb85dea1481f971e634184dd7a0ee5167717f4ab", "relations": [{"rule": 2, "type": "equivalent", "target": "3f8fe58094a84d0377600ce86a339ccc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d4f25cd0593297709d677f0beb85dea1481f971e634184dd7a0ee5167717f4ab"}}, {"rule": 2, "type": "equivalent", "target": "74f9254e5a11fc7184ce90ca95b8f939", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d4f25cd0593297709d677f0beb85dea1481f971e634184dd7a0ee5167717f4ab"}}], "version": "9.1.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "74f9254e5a11fc7184ce90ca95b8f939", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Improve planner's ability to prove exclusion constraints from equivalence classes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d4f25cd0593297709d677f0beb85dea1481f971e634184dd7a0ee5167717f4ab"}, "url": "/docs/compare/?release=9.2.2#9.2.2-512e9d623e42c94b", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "3f8fe58094a84d0377600ce86a339ccc", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Improve planner's ability to prove exclusion constraints from equivalence classes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d4f25cd0593297709d677f0beb85dea1481f971e634184dd7a0ee5167717f4ab"}, "url": "/docs/compare/?release=9.0.11#9.0.11-512e9d623e42c94b", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-90f0d1f4c42052d6", "cves": [], "html": "Fix partial-row matching in hashed subplans to handle cross-type cases correctly (Tom Lane)
\nThis affects multicolumn NOT IN subplans, such as WHERE (a, b) NOT IN (SELECT x, y FROM ...) when for instance b and y are int4 and int8 respectively. This mistake led to wrong answers or crashes depending on the specific datatypes involved.
", "text": "Fix partial-row matching in hashed subplans to handle cross-type cases correctly (Tom Lane) This affects multicolumn NOT IN subplans, such as WHERE (a, b) NOT IN (SELECT x, y FROM ...) when for instance b and y are int4 and int8 respectively. This mistake led to wrong answers or crashes depending on the specific datatypes involved.", "title": "Fix partial-row matching in hashed subplans to handle cross-type cases correctly", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "8aa2aa16e5317c596c05b16a1c7170ee068954a2b699339dc57376889bea4397", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix partial-row matching in hashed subplans to handle cross-type cases correctly (Tom Lane) This affects multicolumn NOT IN subplans, such as WHERE (a, b) NOT IN (SELECT x, y FROM ...) when for instance b and y are int4 and int8 respectively. This mistake led to wrong answers or crashes depending on the specific datatypes involved.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/013", "db_id": "968ccf662bdc209f7d0afbaed04bf1ad", "patch_ids": [], "statement_hash": "5f8da0a2ed6413f53f3ec45b9d401dcb16912e656443acb2cb74ee9d5a6ef8cf", "relations": [{"rule": 2, "type": "equivalent", "target": "5265841a4909c6cbf5c996eee40a0979", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f8da0a2ed6413f53f3ec45b9d401dcb16912e656443acb2cb74ee9d5a6ef8cf"}}, {"rule": 2, "type": "equivalent", "target": "7919d810a7c9a9b0539688c6e499d336", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f8da0a2ed6413f53f3ec45b9d401dcb16912e656443acb2cb74ee9d5a6ef8cf"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "5265841a4909c6cbf5c996eee40a0979", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix partial-row matching in hashed subplans to handle cross-type cases correctly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f8da0a2ed6413f53f3ec45b9d401dcb16912e656443acb2cb74ee9d5a6ef8cf"}, "url": "/docs/compare/?release=9.2.2#9.2.2-90f0d1f4c42052d6", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "7919d810a7c9a9b0539688c6e499d336", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Fix partial-row matching in hashed subplans to handle cross-type cases correctly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5f8da0a2ed6413f53f3ec45b9d401dcb16912e656443acb2cb74ee9d5a6ef8cf"}, "url": "/docs/compare/?release=9.0.11#9.0.11-90f0d1f4c42052d6", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-8131a9f2cde5f89d", "cves": [], "html": "Acquire buffer lock when re-fetching the old tuple for an AFTER ROW UPDATE/DELETE trigger (Andres Freund)
\nIn very unusual circumstances, this oversight could result in passing incorrect data to a trigger WHEN condition, or to the precheck logic for a foreign-key enforcement trigger. That could result in a crash, or in an incorrect decision about whether to fire the trigger.
", "text": "Acquire buffer lock when re-fetching the old tuple for an AFTER ROW UPDATE/DELETE trigger (Andres Freund) In very unusual circumstances, this oversight could result in passing incorrect data to a trigger WHEN condition, or to the precheck logic for a foreign-key enforcement trigger. That could result in a crash, or in an incorrect decision about whether to fire the trigger.", "title": "Acquire buffer lock when re-fetching the old tuple for an AFTER ROW UPDATE/DELETE trigger", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "f9376417f22c1c489300dd90480deabe03f873955d2f1371d26adfcc1285b729", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Acquire buffer lock when re-fetching the old tuple for an AFTER ROW UPDATE/DELETE trigger (Andres Freund) In very unusual circumstances, this oversight could result in passing incorrect data to a trigger WHEN condition, or to the precheck logic for a foreign-key enforcement trigger. That could result in a crash, or in an incorrect decision about whether to fire the trigger.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/014", "db_id": "3cf3ced6a733e5aa39958ba11f149fa2", "patch_ids": [], "statement_hash": "d3b49daf2cdcaba953da22aaf23a47cf6b3c743687239a0372a175ef7f77ef7d", "relations": [{"rule": 2, "type": "equivalent", "target": "baa0d25eb6e4db0113e2f1c94090ddf9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d3b49daf2cdcaba953da22aaf23a47cf6b3c743687239a0372a175ef7f77ef7d"}}], "version": "9.1.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "baa0d25eb6e4db0113e2f1c94090ddf9", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Acquire buffer lock when re-fetching the old tuple for an AFTER ROW UPDATE/DELETE trigger", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d3b49daf2cdcaba953da22aaf23a47cf6b3c743687239a0372a175ef7f77ef7d"}, "url": "/docs/compare/?release=9.2.2#9.2.2-8131a9f2cde5f89d", "source_url": "/docs/release/9.2.2/#AEN114013"}]}, {"id": "9.1.7-dc606579338ba705", "cves": [], "html": "Fix ALTER COLUMN TYPE to handle inherited check constraints properly (Pavan Deolasee)
\nThis worked correctly in pre-8.4 releases, and now works correctly in 8.4 and later.
", "text": "Fix ALTER COLUMN TYPE to handle inherited check constraints properly (Pavan Deolasee) This worked correctly in pre-8.4 releases, and now works correctly in 8.4 and later.", "title": "Fix ALTER COLUMN TYPE to handle inherited check constraints properly", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "8f21e7583b619c7004600fbaba4f1eb25813276a0f50c7f9f90ca5a218ec0628", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix ALTER COLUMN TYPE to handle inherited check constraints properly (Pavan Deolasee) This worked correctly in pre-8.4 releases, and now works correctly in 8.4 and later.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/015", "db_id": "f26e0ba2a0e6fcd438f2ab4bbf34ccf9", "patch_ids": [], "statement_hash": "7f2a4685500560146dfaf2c599e148c1e701249c82e53f7f451020b766a4f680", "relations": [{"rule": 2, "type": "equivalent", "target": "3f077e626bcccab27699d61b9d045f1c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7f2a4685500560146dfaf2c599e148c1e701249c82e53f7f451020b766a4f680"}}, {"rule": 2, "type": "equivalent", "target": "c1030cf8dc27a2e3b7f6cb10b4fb1ea5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7f2a4685500560146dfaf2c599e148c1e701249c82e53f7f451020b766a4f680"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "3f077e626bcccab27699d61b9d045f1c", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix ALTER COLUMN TYPE to handle inherited check constraints properly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7f2a4685500560146dfaf2c599e148c1e701249c82e53f7f451020b766a4f680"}, "url": "/docs/compare/?release=9.2.2#9.2.2-dc606579338ba705", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "c1030cf8dc27a2e3b7f6cb10b4fb1ea5", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Fix ALTER COLUMN TYPE to handle inherited check constraints properly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7f2a4685500560146dfaf2c599e148c1e701249c82e53f7f451020b766a4f680"}, "url": "/docs/compare/?release=9.0.11#9.0.11-dc606579338ba705", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-d29731a2bcb608d9", "cves": [], "html": "Fix ALTER EXTENSION SET SCHEMA's failure to move some subsidiary objects into the new schema (Álvaro Herrera, Dimitri Fontaine)
", "text": "Fix ALTER EXTENSION SET SCHEMA's failure to move some subsidiary objects into the new schema (Álvaro Herrera, Dimitri Fontaine)", "title": "Fix ALTER EXTENSION SET SCHEMA's failure to move some subsidiary objects into the new schema", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "3e151374874b5e391548cc6c9349bcece4bea23eb12119be629f11b5ede795b8", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix ALTER EXTENSION SET SCHEMA's failure to move some subsidiary objects into the new schema (Álvaro Herrera, Dimitri Fontaine)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/016", "db_id": "a02f46093564bc9aff8fec0d28007a9e", "patch_ids": [], "statement_hash": "a1392e72dad6bf15ef28242ba90d8024dc5c17817dda0c1ad1e3a0acf099b1fa", "relations": [{"rule": 2, "type": "equivalent", "target": "3cef992570913f29f7a35a1c0fddb3b1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a1392e72dad6bf15ef28242ba90d8024dc5c17817dda0c1ad1e3a0acf099b1fa"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "3cef992570913f29f7a35a1c0fddb3b1", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix ALTER EXTENSION SET SCHEMA's failure to move some subsidiary objects into the new schema", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a1392e72dad6bf15ef28242ba90d8024dc5c17817dda0c1ad1e3a0acf099b1fa"}, "url": "/docs/compare/?release=9.2.2#9.2.2-d29731a2bcb608d9", "source_url": "/docs/release/9.2.2/#AEN114013"}]}, {"id": "9.1.7-01768e146ee8cd57", "cves": [], "html": "Fix REASSIGN OWNED to handle grants on tablespaces (Álvaro Herrera)
", "text": "Fix REASSIGN OWNED to handle grants on tablespaces (Álvaro Herrera)", "title": "Fix REASSIGN OWNED to handle grants on tablespaces", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "003e929338cadf69ea5ebfbf966fa52189695edb1d4c5f74746894c0cf0f825f", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix REASSIGN OWNED to handle grants on tablespaces (Álvaro Herrera)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/017", "db_id": "d0eafe2aae5f2e3038279ddd8ed7e41c", "patch_ids": [], "statement_hash": "762a6558fe21e9c0de32e15bfe3f2c2a45d7c990b37cd41ea19688a73ea16ee9", "relations": [{"rule": 2, "type": "equivalent", "target": "343395ba7a3fc6573e2bf11c722c65e5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "762a6558fe21e9c0de32e15bfe3f2c2a45d7c990b37cd41ea19688a73ea16ee9"}}, {"rule": 2, "type": "equivalent", "target": "41f99fd79892368c78b07728abad1417", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "762a6558fe21e9c0de32e15bfe3f2c2a45d7c990b37cd41ea19688a73ea16ee9"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "41f99fd79892368c78b07728abad1417", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix REASSIGN OWNED to handle grants on tablespaces", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "762a6558fe21e9c0de32e15bfe3f2c2a45d7c990b37cd41ea19688a73ea16ee9"}, "url": "/docs/compare/?release=9.2.2#9.2.2-01768e146ee8cd57", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "343395ba7a3fc6573e2bf11c722c65e5", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Fix REASSIGN OWNED to handle grants on tablespaces", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "762a6558fe21e9c0de32e15bfe3f2c2a45d7c990b37cd41ea19688a73ea16ee9"}, "url": "/docs/compare/?release=9.0.11#9.0.11-01768e146ee8cd57", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-c631d6072c2d7a6b", "cves": [], "html": "Ignore incorrect pg_attribute entries for system columns for views (Tom Lane)
\nViews do not have any system columns. However, we forgot to remove such entries when converting a table to a view. That's fixed properly for 9.3 and later, but in previous branches we need to defend against existing mis-converted views.
", "text": "Ignore incorrect pg_attribute entries for system columns for views (Tom Lane) Views do not have any system columns. However, we forgot to remove such entries when converting a table to a view. That's fixed properly for 9.3 and later, but in previous branches we need to defend against existing mis-converted views.", "title": "Ignore incorrect pg_attribute entries for system columns for views", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "60ea0ad133be44ce162bab2cac97b135288f599e45f7a50e14e57688eef22775", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ignore incorrect pg_attribute entries for system columns for views (Tom Lane) Views do not have any system columns. However, we forgot to remove such entries when converting a table to a view. That's fixed properly for 9.3 and later, but in previous branches we need to defend against existing mis-converted views.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/018", "db_id": "5d9f53f7dd56eb777809de1e839fb733", "patch_ids": [], "statement_hash": "29602b24f8ee1fea98692ce519778907107ec2e1d964d9d68e8e8de3af26e7fa", "relations": [{"rule": 2, "type": "equivalent", "target": "24fc828ca925559f1894bd2b55b7940e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29602b24f8ee1fea98692ce519778907107ec2e1d964d9d68e8e8de3af26e7fa"}}, {"rule": 2, "type": "equivalent", "target": "33fcdb36e1fd3344ac7f97f5f85d11ca", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29602b24f8ee1fea98692ce519778907107ec2e1d964d9d68e8e8de3af26e7fa"}}], "version": "9.1.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "24fc828ca925559f1894bd2b55b7940e", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Ignore incorrect pg_attribute entries for system columns for views", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29602b24f8ee1fea98692ce519778907107ec2e1d964d9d68e8e8de3af26e7fa"}, "url": "/docs/compare/?release=9.2.2#9.2.2-c631d6072c2d7a6b", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "33fcdb36e1fd3344ac7f97f5f85d11ca", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Ignore incorrect pg_attribute entries for system columns for views", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29602b24f8ee1fea98692ce519778907107ec2e1d964d9d68e8e8de3af26e7fa"}, "url": "/docs/compare/?release=9.0.11#9.0.11-c631d6072c2d7a6b", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-b582f0ce98109cd6", "cves": [], "html": "Fix rule printing to dump INSERT INTO table DEFAULT VALUES correctly (Tom Lane)
", "text": "Fix rule printing to dump INSERT INTO table DEFAULT VALUES correctly (Tom Lane)", "title": "Fix rule printing to dump INSERT INTO table DEFAULT VALUES correctly", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "7d1e0039c3e1bdc497e2894a726ad64b3ee200a2f60c3524a00ebbca6aafa2c4", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix rule printing to dump INSERT INTO table DEFAULT VALUES correctly (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/019", "db_id": "90d7be8c560f20e25cf3ada554e902c3", "patch_ids": [], "statement_hash": "067c993595773130e8eec4e9aa087a1e6c502d30f2cdcb0e6fc9884f1d570e7a", "relations": [{"rule": 2, "type": "equivalent", "target": "274a016bd3de73befac193b7851d22a0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "067c993595773130e8eec4e9aa087a1e6c502d30f2cdcb0e6fc9884f1d570e7a"}}, {"rule": 2, "type": "equivalent", "target": "69f1ef7b4b3db99d894e0751399cb649", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "067c993595773130e8eec4e9aa087a1e6c502d30f2cdcb0e6fc9884f1d570e7a"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "274a016bd3de73befac193b7851d22a0", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix rule printing to dump INSERT INTO table DEFAULT VALUES correctly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "067c993595773130e8eec4e9aa087a1e6c502d30f2cdcb0e6fc9884f1d570e7a"}, "url": "/docs/compare/?release=9.2.2#9.2.2-b582f0ce98109cd6", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "69f1ef7b4b3db99d894e0751399cb649", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Fix rule printing to dump INSERT INTO table DEFAULT VALUES correctly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "067c993595773130e8eec4e9aa087a1e6c502d30f2cdcb0e6fc9884f1d570e7a"}, "url": "/docs/compare/?release=9.0.11#9.0.11-b582f0ce98109cd6", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-2ef3fcc972719c1f", "cves": [], "html": "Guard against stack overflow when there are too many UNION/INTERSECT/EXCEPT clauses in a query (Tom Lane)
", "text": "Guard against stack overflow when there are too many UNION/INTERSECT/EXCEPT clauses in a query (Tom Lane)", "title": "Guard against stack overflow when there are too many UNION/INTERSECT/EXCEPT clauses in a query", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "77512726d7653c37802ba262c7c0dd04e9300cd87d45fc0c6b0e3b445b8119ac", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Guard against stack overflow when there are too many UNION/INTERSECT/EXCEPT clauses in a query (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/020", "db_id": "02af39bcd41b8188f9592d9ed7d08aec", "patch_ids": [], "statement_hash": "1450e9825a8ad22603eced43d6ecff0b7eb858d190e20342013832a4e755620e", "relations": [{"rule": 2, "type": "equivalent", "target": "481004e97fd680ac9920c0781f9e9786", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1450e9825a8ad22603eced43d6ecff0b7eb858d190e20342013832a4e755620e"}}, {"rule": 2, "type": "equivalent", "target": "84ce0fdf3b32c5c0dd5cda3d876d6208", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1450e9825a8ad22603eced43d6ecff0b7eb858d190e20342013832a4e755620e"}}], "version": "9.1.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "481004e97fd680ac9920c0781f9e9786", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Guard against stack overflow when there are too many UNION/INTERSECT/EXCEPT clauses in a query", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1450e9825a8ad22603eced43d6ecff0b7eb858d190e20342013832a4e755620e"}, "url": "/docs/compare/?release=9.2.2#9.2.2-2ef3fcc972719c1f", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "84ce0fdf3b32c5c0dd5cda3d876d6208", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Guard against stack overflow when there are too many UNION/INTERSECT/EXCEPT clauses in a query", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1450e9825a8ad22603eced43d6ecff0b7eb858d190e20342013832a4e755620e"}, "url": "/docs/compare/?release=9.0.11#9.0.11-2ef3fcc972719c1f", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-9ad685cfadb0c8a4", "cves": [], "html": "Prevent platform-dependent failures when dividing the minimum possible integer value by -1 (Xi Wang, Tom Lane)
", "text": "Prevent platform-dependent failures when dividing the minimum possible integer value by -1 (Xi Wang, Tom Lane)", "title": "Prevent platform-dependent failures when dividing the minimum possible integer value by -1", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "1b7df5f7bfc6d736b0b12fbeaf9e431f5a35b47cdd8bb47b07d513b171b8d44d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent platform-dependent failures when dividing the minimum possible integer value by -1 (Xi Wang, Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/021", "db_id": "7329af02fec039c07ee6db77246ed06b", "patch_ids": [], "statement_hash": "053df3d33e982daec41e10e7e7a52d1733bc52f57dfed410c2a7a15d0dd13eda", "relations": [{"rule": 2, "type": "equivalent", "target": "3e618f46cc6d08632858ccbe53d9f379", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "053df3d33e982daec41e10e7e7a52d1733bc52f57dfed410c2a7a15d0dd13eda"}}, {"rule": 2, "type": "equivalent", "target": "b9768a094fffe40495c8ec3a027a14fc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "053df3d33e982daec41e10e7e7a52d1733bc52f57dfed410c2a7a15d0dd13eda"}}], "version": "9.1.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "3e618f46cc6d08632858ccbe53d9f379", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Prevent platform-dependent failures when dividing the minimum possible integer value by -1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "053df3d33e982daec41e10e7e7a52d1733bc52f57dfed410c2a7a15d0dd13eda"}, "url": "/docs/compare/?release=9.2.2#9.2.2-9ad685cfadb0c8a4", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "b9768a094fffe40495c8ec3a027a14fc", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Prevent platform-dependent failures when dividing the minimum possible integer value by -1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "053df3d33e982daec41e10e7e7a52d1733bc52f57dfed410c2a7a15d0dd13eda"}, "url": "/docs/compare/?release=9.0.11#9.0.11-9ad685cfadb0c8a4", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-8d0492e9329d8a55", "cves": [], "html": "Fix possible access past end of string in date parsing (Hitoshi Harada)
", "text": "Fix possible access past end of string in date parsing (Hitoshi Harada)", "title": "Fix possible access past end of string in date parsing", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "1d43afffe89435b07e9c5b0e8f28ec74ed63286a4a4a537a537ebaa2ec17fe68", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix possible access past end of string in date parsing (Hitoshi Harada)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/022", "db_id": "de93e88a162543f2a33608cebc01921e", "patch_ids": [], "statement_hash": "b8b60e160031f49e4c1d50def21440917b398f9f64cac865dcdd0675bd60b317", "relations": [{"rule": 2, "type": "equivalent", "target": "37d10567707f1fb59eacdcddacdc4acb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8b60e160031f49e4c1d50def21440917b398f9f64cac865dcdd0675bd60b317"}}, {"rule": 2, "type": "equivalent", "target": "d65abcc5f53c804de848de918001f632", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8b60e160031f49e4c1d50def21440917b398f9f64cac865dcdd0675bd60b317"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "37d10567707f1fb59eacdcddacdc4acb", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix possible access past end of string in date parsing", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8b60e160031f49e4c1d50def21440917b398f9f64cac865dcdd0675bd60b317"}, "url": "/docs/compare/?release=9.2.2#9.2.2-8d0492e9329d8a55", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "d65abcc5f53c804de848de918001f632", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Fix possible access past end of string in date parsing", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b8b60e160031f49e4c1d50def21440917b398f9f64cac865dcdd0675bd60b317"}, "url": "/docs/compare/?release=9.0.11#9.0.11-8d0492e9329d8a55", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-7e041d2737dc761d", "cves": [], "html": "Fix failure to advance XID epoch if XID wraparound happens during a checkpoint and wal_level is hot_standby (Tom Lane, Andres Freund)
\nWhile this mistake had no particular impact on PostgreSQL itself, it was bad for applications that rely on txid_current() and related functions: the TXID value would appear to go backwards.
Fix display of pg_stat_replication.sync_state at a page boundary (Kyotaro Horiguchi)
", "text": "Fix display of pg_stat_replication.sync_state at a page boundary (Kyotaro Horiguchi)", "title": "Fix display of pg_stat_replication.sync_state at a page boundary", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "0c0b7e0143029ac63668f79dd73d716c25e4d103a4f3d42d899bb64b6ea8a917", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix display of pg_stat_replication.sync_state at a page boundary (Kyotaro Horiguchi)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/024", "db_id": "4ae3e6873e06755c9f1cfb95c283f945", "patch_ids": [], "statement_hash": "e675847f8e783b85bd744dbdb068cf4fd020149ac8f658123c20abd4245ef300", "relations": [{"rule": 2, "type": "equivalent", "target": "be59d3f49b7aeb812e1afebc36c43a55", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e675847f8e783b85bd744dbdb068cf4fd020149ac8f658123c20abd4245ef300"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "be59d3f49b7aeb812e1afebc36c43a55", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix display of pg_stat_replication.sync_state at a page boundary", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e675847f8e783b85bd744dbdb068cf4fd020149ac8f658123c20abd4245ef300"}, "url": "/docs/compare/?release=9.2.2#9.2.2-0392d68fc9468aa1", "source_url": "/docs/release/9.2.2/#AEN114013"}]}, {"id": "9.1.7-08eba448e0366bb2", "cves": [], "html": "Produce an understandable error message if the length of the path name for a Unix-domain socket exceeds the platform-specific limit (Tom Lane, Andrew Dunstan)
\nFormerly, this would result in something quite unhelpful, such as \"Non-recoverable failure in name resolution\".
", "text": "Produce an understandable error message if the length of the path name for a Unix-domain socket exceeds the platform-specific limit (Tom Lane, Andrew Dunstan) Formerly, this would result in something quite unhelpful, such as \"Non-recoverable failure in name resolution\".", "title": "Produce an understandable error message if the length of the path name for a Unix-domain socket exceeds the platform-specific limit", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "ec4a5a13a30ca7cd473967894fe7b3f9f2fc1e7992c3eb9ca4851fc3ce93ddd9", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Produce an understandable error message if the length of the path name for a Unix-domain socket exceeds the platform-specific limit (Tom Lane, Andrew Dunstan) Formerly, this would result in something quite unhelpful, such as Non-recoverable failure in name resolution.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/025", "db_id": "8b4afadb80fca126ee808db9d81f07da", "patch_ids": [], "statement_hash": "ed7d6493553f125d1a87aa5e19322b8e7ed4fb7d8a9182efbe28fffa1b65da3b", "relations": [{"rule": 2, "type": "equivalent", "target": "5e4ef2a68eda76677b36c6d7911d32db", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ed7d6493553f125d1a87aa5e19322b8e7ed4fb7d8a9182efbe28fffa1b65da3b"}}, {"rule": 2, "type": "equivalent", "target": "e5de37f6158d6ded52fb1e3cfa49cc86", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ed7d6493553f125d1a87aa5e19322b8e7ed4fb7d8a9182efbe28fffa1b65da3b"}}], "version": "9.1.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "5e4ef2a68eda76677b36c6d7911d32db", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Produce an understandable error message if the length of the path name for a Unix-domain socket exceeds the platform-specific limit", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ed7d6493553f125d1a87aa5e19322b8e7ed4fb7d8a9182efbe28fffa1b65da3b"}, "url": "/docs/compare/?release=9.2.2#9.2.2-08eba448e0366bb2", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "e5de37f6158d6ded52fb1e3cfa49cc86", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Produce an understandable error message if the length of the path name for a Unix-domain socket exceeds the platform-specific limit", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ed7d6493553f125d1a87aa5e19322b8e7ed4fb7d8a9182efbe28fffa1b65da3b"}, "url": "/docs/compare/?release=9.0.11#9.0.11-08eba448e0366bb2", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-12a2b11168124744", "cves": [], "html": "Fix memory leaks when sending composite column values to the client (Tom Lane)
", "text": "Fix memory leaks when sending composite column values to the client (Tom Lane)", "title": "Fix memory leaks when sending composite column values to the client", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "e6ac537d29016aa7c03972001834b711662feb9589dbf38523c3eb64e9459b5f", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix memory leaks when sending composite column values to the client (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/026", "db_id": "94ad792f70087ba4a8f3c5169cbdb11c", "patch_ids": [], "statement_hash": "94041bc5dbcc26bd2cb30df95d7847a85ddc7f9c01bb9948c8d07a9c7ec8576e", "relations": [{"rule": 2, "type": "equivalent", "target": "29587f182d2fa5e79c706d9bf47dd8c2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "94041bc5dbcc26bd2cb30df95d7847a85ddc7f9c01bb9948c8d07a9c7ec8576e"}}, {"rule": 2, "type": "equivalent", "target": "845266b9d6f758be85ffece6eb32864d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "94041bc5dbcc26bd2cb30df95d7847a85ddc7f9c01bb9948c8d07a9c7ec8576e"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "29587f182d2fa5e79c706d9bf47dd8c2", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix memory leaks when sending composite column values to the client", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "94041bc5dbcc26bd2cb30df95d7847a85ddc7f9c01bb9948c8d07a9c7ec8576e"}, "url": "/docs/compare/?release=9.2.2#9.2.2-12a2b11168124744", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "845266b9d6f758be85ffece6eb32864d", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Fix memory leaks when sending composite column values to the client", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "94041bc5dbcc26bd2cb30df95d7847a85ddc7f9c01bb9948c8d07a9c7ec8576e"}, "url": "/docs/compare/?release=9.0.11#9.0.11-12a2b11168124744", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-8574029f16fc8f48", "cves": [], "html": "Make pg_ctl more robust about reading the postmaster.pid file (Heikki Linnakangas)
\nFix race conditions and possible file descriptor leakage.
", "text": "Make pg_ctl more robust about reading the postmaster.pid file (Heikki Linnakangas) Fix race conditions and possible file descriptor leakage.", "title": "Make pg_ctl more robust about reading the postmaster.pid file", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "3d5483d553ce3999f91f1c4dcae12be8497b6467dd392bf57763ce70da920cde", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Make pg_ctl more robust about reading the postmaster.pid file (Heikki Linnakangas) Fix race conditions and possible file descriptor leakage.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/027", "db_id": "7da180688507f8a131c936a362e943e8", "patch_ids": [], "statement_hash": "fc179b7fd41ac47bcb533bbebe6d8601161de890fbf3159aa91280e9194083bc", "relations": [{"rule": 2, "type": "equivalent", "target": "debe75e3ec5239205d3f38c55aeafaea", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fc179b7fd41ac47bcb533bbebe6d8601161de890fbf3159aa91280e9194083bc"}}], "version": "9.1.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "debe75e3ec5239205d3f38c55aeafaea", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Make pg_ctl more robust about reading the postmaster.pid file", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fc179b7fd41ac47bcb533bbebe6d8601161de890fbf3159aa91280e9194083bc"}, "url": "/docs/compare/?release=9.0.11#9.0.11-8574029f16fc8f48", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-6a5be007a039b1e6", "cves": [], "html": "Fix possible crash in psql if incorrectly-encoded data is presented and the client_encoding setting is a client-only encoding, such as SJIS (Jiang Guiqing)
", "text": "Fix possible crash in psql if incorrectly-encoded data is presented and the client_encoding setting is a client-only encoding, such as SJIS (Jiang Guiqing)", "title": "Fix possible crash in psql if incorrectly-encoded data is presented and the client_encoding setting is a client-only encoding, such as SJIS", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "0538584ee124ed272c32a43f9749ee1c01c641193e25b9f7cd9f0185139ac905", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix possible crash in psql if incorrectly-encoded data is presented and the client_encoding setting is a client-only encoding, such as SJIS (Jiang Guiqing)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/028", "db_id": "bfd3a3b64b6be83f8a9a1eb95aa72880", "patch_ids": [], "statement_hash": "7601038850abbb31283e151280bbff27797061e933b5a55473ceabcad85b9d55", "relations": [{"rule": 2, "type": "equivalent", "target": "bbcafb2292209fa0337753b5958ec7fd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7601038850abbb31283e151280bbff27797061e933b5a55473ceabcad85b9d55"}}, {"rule": 2, "type": "equivalent", "target": "eb261ab2484b3655d9825439be7e4fcb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7601038850abbb31283e151280bbff27797061e933b5a55473ceabcad85b9d55"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "bbcafb2292209fa0337753b5958ec7fd", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix possible crash in psql if incorrectly-encoded data is presented and the client_encoding setting is a client-only encoding, such as SJIS", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7601038850abbb31283e151280bbff27797061e933b5a55473ceabcad85b9d55"}, "url": "/docs/compare/?release=9.2.2#9.2.2-6a5be007a039b1e6", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "eb261ab2484b3655d9825439be7e4fcb", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Fix possible crash in psql if incorrectly-encoded data is presented and the client_encoding setting is a client-only encoding, such as SJIS", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7601038850abbb31283e151280bbff27797061e933b5a55473ceabcad85b9d55"}, "url": "/docs/compare/?release=9.0.11#9.0.11-6a5be007a039b1e6", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-62eba2031bdbcde8", "cves": [], "html": "Make pg_dump dump SEQUENCE SET items in the data not pre-data section of the archive (Tom Lane)
\nThis change fixes dumping of sequences that are marked as extension configuration tables.
", "text": "Make pg_dump dump SEQUENCE SET items in the data not pre-data section of the archive (Tom Lane) This change fixes dumping of sequences that are marked as extension configuration tables.", "title": "Make pg_dump dump SEQUENCE SET items in the data not pre-data section of the archive", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "5df633de785e7590514a06e418fbd080a40114fc86d3b51f7eecca8f4ebb7789", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Make pg_dump dump SEQUENCE SET items in the data not pre-data section of the archive (Tom Lane) This change fixes dumping of sequences that are marked as extension configuration tables.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/029", "db_id": "5b16697176fac9929ead7e0ee9fb5343", "patch_ids": [], "statement_hash": "f86b74235455db49e35cc160a741f66c92ef57afb757d93442a13023d8b0ef18", "relations": [], "version": "9.1.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.1.7-059516428973083e", "cves": [], "html": "Fix bugs in the restore.sql script emitted by pg_dump in tar output format (Tom Lane)
\nThe script would fail outright on tables whose names include upper-case characters. Also, make the script capable of restoring data in --inserts mode as well as the regular COPY mode.
", "text": "Fix bugs in the restore.sql script emitted by pg_dump in tar output format (Tom Lane) The script would fail outright on tables whose names include upper-case characters. Also, make the script capable of restoring data in --inserts mode as well as the regular COPY mode.", "title": "Fix bugs in the restore.sql script emitted by pg_dump in tar output format", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "233a7d47bd6db01a3f62ecb9c97120b554a4b0ae38fca90746d4e40fbf405391", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix bugs in the restore.sql script emitted by pg_dump in tar output format (Tom Lane) The script would fail outright on tables whose names include upper-case characters. Also, make the script capable of restoring data in --inserts mode as well as the regular COPY mode.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/030", "db_id": "9b17d2dea6f423dfca8ab39753913699", "patch_ids": [], "statement_hash": "743ea37f7de3775ac6e5fb3b825b04a235c953be937e15f03e6d592e958da788", "relations": [{"rule": 2, "type": "equivalent", "target": "0fbaf302362b99ceb1b7f934fee66c89", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "743ea37f7de3775ac6e5fb3b825b04a235c953be937e15f03e6d592e958da788"}}, {"rule": 2, "type": "equivalent", "target": "97cf44ff6bc6e3e37334890b48df6a0c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "743ea37f7de3775ac6e5fb3b825b04a235c953be937e15f03e6d592e958da788"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "97cf44ff6bc6e3e37334890b48df6a0c", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix bugs in the restore.sql script emitted by pg_dump in tar output format", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "743ea37f7de3775ac6e5fb3b825b04a235c953be937e15f03e6d592e958da788"}, "url": "/docs/compare/?release=9.2.2#9.2.2-059516428973083e", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "0fbaf302362b99ceb1b7f934fee66c89", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Fix bugs in the restore.sql script emitted by pg_dump in tar output format", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "743ea37f7de3775ac6e5fb3b825b04a235c953be937e15f03e6d592e958da788"}, "url": "/docs/compare/?release=9.0.11#9.0.11-059516428973083e", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-9c9299766c533f3b", "cves": [], "html": "Fix pg_restore to accept POSIX-conformant tar files (Brian Weaver, Tom Lane)
\nThe original coding of pg_dump's tar output mode produced files that are not fully conformant with the POSIX standard. This has been corrected for version 9.3. This patch updates previous branches so that they will accept both the incorrect and the corrected formats, in hopes of avoiding compatibility problems when 9.3 comes out.
", "text": "Fix pg_restore to accept POSIX-conformant tar files (Brian Weaver, Tom Lane) The original coding of pg_dump's tar output mode produced files that are not fully conformant with the POSIX standard. This has been corrected for version 9.3. This patch updates previous branches so that they will accept both the incorrect and the corrected formats, in hopes of avoiding compatibility problems when 9.3 comes out.", "title": "Fix pg_restore to accept POSIX-conformant tar files", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "0566639c2379aa0448ee49466bfc314257bd0b476db42ade86ada79af169b2dc", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix pg_restore to accept POSIX-conformant tar files (Brian Weaver, Tom Lane) The original coding of pg_dump's tar output mode produced files that are not fully conformant with the POSIX standard. This has been corrected for version 9.3. This patch updates previous branches so that they will accept both the incorrect and the corrected formats, in hopes of avoiding compatibility problems when 9.3 comes out.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/031", "db_id": "f0e2ab9964db40d1bfa9fcbfacdbff81", "patch_ids": [], "statement_hash": "40b34fbe6c0ce3014832a07f496e2cccb058a72f4f9f73bf956b972849f9d8dd", "relations": [{"rule": 2, "type": "equivalent", "target": "19974f58b09e48de0ad5f6b2ac35bbf7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "40b34fbe6c0ce3014832a07f496e2cccb058a72f4f9f73bf956b972849f9d8dd"}}, {"rule": 2, "type": "equivalent", "target": "b8805482ba721f9dfdbda828bf6df8e9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "40b34fbe6c0ce3014832a07f496e2cccb058a72f4f9f73bf956b972849f9d8dd"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "b8805482ba721f9dfdbda828bf6df8e9", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix pg_restore to accept POSIX-conformant tar files", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "40b34fbe6c0ce3014832a07f496e2cccb058a72f4f9f73bf956b972849f9d8dd"}, "url": "/docs/compare/?release=9.2.2#9.2.2-9c9299766c533f3b", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "19974f58b09e48de0ad5f6b2ac35bbf7", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Fix pg_restore to accept POSIX-conformant tar files", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "40b34fbe6c0ce3014832a07f496e2cccb058a72f4f9f73bf956b972849f9d8dd"}, "url": "/docs/compare/?release=9.0.11#9.0.11-9c9299766c533f3b", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-c000e09fc20bd824", "cves": [], "html": "Fix tar files emitted by pg_basebackup to be POSIX conformant (Brian Weaver, Tom Lane)
", "text": "Fix tar files emitted by pg_basebackup to be POSIX conformant (Brian Weaver, Tom Lane)", "title": "Fix tar files emitted by pg_basebackup to be POSIX conformant", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "f8f046ddf2bcd727913125a2f6a688df5b4dbf5b8f43b6b84397e53975b8a7e9", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix tar files emitted by pg_basebackup to be POSIX conformant (Brian Weaver, Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/032", "db_id": "7fd20daf0b04635053d7050e17ff7b81", "patch_ids": [], "statement_hash": "82b791857fe12b63413de16010da4d42d22d0549638441d483422cd27a35dc14", "relations": [{"rule": 2, "type": "equivalent", "target": "4b45350b80211b97339fb937c470cd5c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "82b791857fe12b63413de16010da4d42d22d0549638441d483422cd27a35dc14"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4b45350b80211b97339fb937c470cd5c", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix tar files emitted by pg_basebackup to be POSIX conformant", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "82b791857fe12b63413de16010da4d42d22d0549638441d483422cd27a35dc14"}, "url": "/docs/compare/?release=9.2.2#9.2.2-c000e09fc20bd824", "source_url": "/docs/release/9.2.2/#AEN114013"}]}, {"id": "9.1.7-684db6d0506db291", "cves": [], "html": "Fix pg_resetxlog to locate postmaster.pid correctly when given a relative path to the data directory (Tom Lane)
\nThis mistake could lead to pg_resetxlog not noticing that there is an active postmaster using the data directory.
", "text": "Fix pg_resetxlog to locate postmaster.pid correctly when given a relative path to the data directory (Tom Lane) This mistake could lead to pg_resetxlog not noticing that there is an active postmaster using the data directory.", "title": "Fix pg_resetxlog to locate postmaster.pid correctly when given a relative path to the data directory", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "cd171ace921ec1d2cd90ab7c2a00246f22ea477f9f357e8246881867e0b6ac3a", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix pg_resetxlog to locate postmaster.pid correctly when given a relative path to the data directory (Tom Lane) This mistake could lead to pg_resetxlog not noticing that there is an active postmaster using the data directory.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/033", "db_id": "06fc1858e102b767bb412ea6db60ac13", "patch_ids": [], "statement_hash": "7caf8cc7b3f02b5844757f17686d9fac5bdf47eaad7825675106bce61c63e669", "relations": [{"rule": 2, "type": "equivalent", "target": "5f23fc6d20daa7b78f92317b68a3d656", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7caf8cc7b3f02b5844757f17686d9fac5bdf47eaad7825675106bce61c63e669"}}, {"rule": 2, "type": "equivalent", "target": "a197f30d4a419afe22ed352eed6c455f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7caf8cc7b3f02b5844757f17686d9fac5bdf47eaad7825675106bce61c63e669"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "5f23fc6d20daa7b78f92317b68a3d656", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix pg_resetxlog to locate postmaster.pid correctly when given a relative path to the data directory", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7caf8cc7b3f02b5844757f17686d9fac5bdf47eaad7825675106bce61c63e669"}, "url": "/docs/compare/?release=9.2.2#9.2.2-684db6d0506db291", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "a197f30d4a419afe22ed352eed6c455f", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Fix pg_resetxlog to locate postmaster.pid correctly when given a relative path to the data directory", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7caf8cc7b3f02b5844757f17686d9fac5bdf47eaad7825675106bce61c63e669"}, "url": "/docs/compare/?release=9.0.11#9.0.11-684db6d0506db291", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-0ca912552a5a5af3", "cves": [], "html": "Fix libpq's lo_import() and lo_export() functions to report file I/O errors properly (Tom Lane)
Fix ecpg's processing of nested structure pointer variables (Muhammad Usama)
", "text": "Fix ecpg's processing of nested structure pointer variables (Muhammad Usama)", "title": "Fix ecpg's processing of nested structure pointer variables", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "f66693bf5a9ffc30ec5408256006670f17056e553f19e59c26a5b76e7161daa0", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix ecpg's processing of nested structure pointer variables (Muhammad Usama)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/035", "db_id": "cda221c16bc82f7d72ec2fc78e8dac16", "patch_ids": [], "statement_hash": "9fd1209f4bf6fbf17e1e75f61f4f9db696c1b28331f0a9f7ac4c3f26f5aa7400", "relations": [{"rule": 2, "type": "equivalent", "target": "41df92a6020bf58d60a096b38c9b2191", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9fd1209f4bf6fbf17e1e75f61f4f9db696c1b28331f0a9f7ac4c3f26f5aa7400"}}, {"rule": 2, "type": "equivalent", "target": "64f48e2eedaa8745234640d84045defd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9fd1209f4bf6fbf17e1e75f61f4f9db696c1b28331f0a9f7ac4c3f26f5aa7400"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "64f48e2eedaa8745234640d84045defd", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix ecpg's processing of nested structure pointer variables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9fd1209f4bf6fbf17e1e75f61f4f9db696c1b28331f0a9f7ac4c3f26f5aa7400"}, "url": "/docs/compare/?release=9.2.2#9.2.2-9bfac1f9ff88c0fc", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "41df92a6020bf58d60a096b38c9b2191", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Fix ecpg's processing of nested structure pointer variables", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9fd1209f4bf6fbf17e1e75f61f4f9db696c1b28331f0a9f7ac4c3f26f5aa7400"}, "url": "/docs/compare/?release=9.0.11#9.0.11-9bfac1f9ff88c0fc", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-3cc49324ae446e4a", "cves": [], "html": "Fix ecpg's ecpg_get_data function to handle arrays properly (Michael Meskes)
Make contrib/pageinspect's btree page inspection functions take buffer locks while examining pages (Tom Lane)
", "text": "Make contrib/pageinspect's btree page inspection functions take buffer locks while examining pages (Tom Lane)", "title": "Make contrib/pageinspect's btree page inspection functions take buffer locks while examining pages", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "dd13edf5c1c38cc173432ead3db7a4b4d406c0836be67c04e8092fb2852b89b7", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Make contrib/pageinspect's btree page inspection functions take buffer locks while examining pages (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/037", "db_id": "50004f2450d7e9ef28d51c2afc69d34a", "patch_ids": [], "statement_hash": "aac1d07d86a1b0919daea13c909f5e92e75792304935a64affe58dd8a67c6b35", "relations": [{"rule": 2, "type": "equivalent", "target": "6db7793b105ce365d08d9e2075a9b1cc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "aac1d07d86a1b0919daea13c909f5e92e75792304935a64affe58dd8a67c6b35"}}, {"rule": 2, "type": "equivalent", "target": "92b55b3c92184c6da0b9418e568c58f2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "aac1d07d86a1b0919daea13c909f5e92e75792304935a64affe58dd8a67c6b35"}}], "version": "9.1.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "92b55b3c92184c6da0b9418e568c58f2", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Make contrib/pageinspect's btree page inspection functions take buffer locks while examining pages", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "aac1d07d86a1b0919daea13c909f5e92e75792304935a64affe58dd8a67c6b35"}, "url": "/docs/compare/?release=9.2.2#9.2.2-f4410fa626b1a999", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "6db7793b105ce365d08d9e2075a9b1cc", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Make contrib/pageinspect's btree page inspection functions take buffer locks while examining pages", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "aac1d07d86a1b0919daea13c909f5e92e75792304935a64affe58dd8a67c6b35"}, "url": "/docs/compare/?release=9.0.11#9.0.11-f4410fa626b1a999", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-7cc2d637f77979d1", "cves": [], "html": "Ensure that make install for an extension creates the extension installation directory (Cédric Villemain)
\nPreviously, this step was missed if MODULEDIR was set in the extension's Makefile.
", "text": "Ensure that make install for an extension creates the extension installation directory (Cédric Villemain) Previously, this step was missed if MODULEDIR was set in the extension's Makefile.", "title": "Ensure that make install for an extension creates the extension installation directory", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "6c67936ec6c24599ebaaa624f2fdefdc35032491b95484445b7110afd3ef8091", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ensure that make install for an extension creates the extension installation directory (Cédric Villemain) Previously, this step was missed if MODULEDIR was set in the extension's Makefile.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/038", "db_id": "d843dd772ca1aaf46749cee6e8c885d4", "patch_ids": [], "statement_hash": "352c908634796010526837995ce0c046ab96fccd1c12cc4db3deaa8a872b4874", "relations": [{"rule": 2, "type": "equivalent", "target": "853b6ab6c768eb825ed130545a5d4b63", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "352c908634796010526837995ce0c046ab96fccd1c12cc4db3deaa8a872b4874"}}], "version": "9.1.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "853b6ab6c768eb825ed130545a5d4b63", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Ensure that make install for an extension creates the extension installation directory", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "352c908634796010526837995ce0c046ab96fccd1c12cc4db3deaa8a872b4874"}, "url": "/docs/compare/?release=9.2.2#9.2.2-7cc2d637f77979d1", "source_url": "/docs/release/9.2.2/#AEN114013"}]}, {"id": "9.1.7-3e192c43d3bd4170", "cves": [], "html": "Fix pgxs support for building loadable modules on AIX (Tom Lane)
\nBuilding modules outside the original source tree didn't work on AIX.
", "text": "Fix pgxs support for building loadable modules on AIX (Tom Lane) Building modules outside the original source tree didn't work on AIX.", "title": "Fix pgxs support for building loadable modules on AIX", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "944708fa5ac503f8f09a02b13dbc4aab2ec17f7a6b306d9505e4db826d99b6f9", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix pgxs support for building loadable modules on AIX (Tom Lane) Building modules outside the original source tree didn't work on AIX.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/039", "db_id": "4cd7f6e5b1c444af94d81b73fc62872d", "patch_ids": [], "statement_hash": "8eb6e11a0cdd4ad9eb440056655425188977dec2564763abdd10adb3def1e098", "relations": [{"rule": 2, "type": "equivalent", "target": "15dabc8824d91d197d3137936927273b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8eb6e11a0cdd4ad9eb440056655425188977dec2564763abdd10adb3def1e098"}}, {"rule": 2, "type": "equivalent", "target": "718f43ca78112555364550f686794edf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8eb6e11a0cdd4ad9eb440056655425188977dec2564763abdd10adb3def1e098"}}], "version": "9.1.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "718f43ca78112555364550f686794edf", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Fix pgxs support for building loadable modules on AIX", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8eb6e11a0cdd4ad9eb440056655425188977dec2564763abdd10adb3def1e098"}, "url": "/docs/compare/?release=9.2.2#9.2.2-3e192c43d3bd4170", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "15dabc8824d91d197d3137936927273b", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Fix pgxs support for building loadable modules on AIX", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8eb6e11a0cdd4ad9eb440056655425188977dec2564763abdd10adb3def1e098"}, "url": "/docs/compare/?release=9.0.11#9.0.11-3e192c43d3bd4170", "source_url": "/docs/release/9.0.11/#AEN100835"}]}, {"id": "9.1.7-51a708188453003a", "cves": [], "html": "Update time zone data files to tzdata release 2012j for DST law changes in Cuba, Israel, Jordan, Libya, Palestine, Western Samoa, and portions of Brazil.
", "text": "Update time zone data files to tzdata release 2012j for DST law changes in Cuba, Israel, Jordan, Libya, Palestine, Western Samoa, and portions of Brazil.", "title": "Update time zone data files to tzdata release 2012j for DST law changes in Cuba, Israel, Jordan, Libya, Palestine, Western Samoa, and portions of Brazil.", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.7/#AEN109251", "source_hash": "7d64428e0beac28d1093c3faa0faa44131729bac38bc4ca4bbaed0c6527b3772", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Update time zone data files to tzdata release 2012j for DST law changes in Cuba, Israel, Jordan, Libya, Palestine, Western Samoa, and portions of Brazil.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.7/changes/040", "db_id": "8d3974c67dd220e19c661173e02581b0", "patch_ids": [], "statement_hash": "b97eec4dfb4854efeb77895b2bb2829f50b77c47d05be588661b563c55522638", "relations": [{"rule": 2, "type": "equivalent", "target": "1fe15744872be7b056e551e5765d535c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b97eec4dfb4854efeb77895b2bb2829f50b77c47d05be588661b563c55522638"}}, {"rule": 2, "type": "equivalent", "target": "b3fd6413f3478cca8738ba1f1bb39969", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b97eec4dfb4854efeb77895b2bb2829f50b77c47d05be588661b563c55522638"}}], "version": "9.1.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b3fd6413f3478cca8738ba1f1bb39969", "kind": "equivalent", "version": "9.2.2", "label": "9.2.2", "title": "Update time zone data files to tzdata release 2012j for DST law changes in Cuba, Israel, Jordan, Libya, Palestine, Western Samoa, and portions of Brazil.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b97eec4dfb4854efeb77895b2bb2829f50b77c47d05be588661b563c55522638"}, "url": "/docs/compare/?release=9.2.2#9.2.2-51a708188453003a", "source_url": "/docs/release/9.2.2/#AEN114013"}, {"db_id": "1fe15744872be7b056e551e5765d535c", "kind": "equivalent", "version": "9.0.11", "label": "9.0.11", "title": "Update time zone data files to tzdata release 2012j for DST law changes in Cuba, Israel, Jordan, Libya, Palestine, Western Samoa, and portions of Brazil.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b97eec4dfb4854efeb77895b2bb2829f50b77c47d05be588661b563c55522638"}, "url": "/docs/compare/?release=9.0.11#9.0.11-51a708188453003a", "source_url": "/docs/release/9.0.11/#AEN100835"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 40}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 25}, {"key": "security", "label": "Security", "count": 0}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 15}], "total": 40, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 40, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}