A dump/restore is not required for those running 9.5.X.
\nHowever, if you use foreign data servers that make use of user passwords for authentication, see the first changelog entry below.
\nAlso, if you are using third-party replication tools that depend on \"logical decoding\", see the fourth changelog entry below.
\nAlso, if you are upgrading from a version earlier than 9.5.6, see Section E.20.
", "compatibility_count": 0, "label": "9.5.7", "status_label": "Historical", "eol": "2021-02-11", "age_days": 3428, "support_days": -2056}, "groups": [{"date": "2017-05-11", "build": "9.5.7", "major": "9.5", "minor": 7, "manual": "9.5", "status": "stable", "doc_git": "", "version": "9.5.7", "eol_date": "2021-02-11", "date_text": "2017-05-11", "supported": false, "manual_url": "/docs/9.5/release-9-5-7.html", "source_url": "/docs/release/9.5.7/", "entry_count": 40, "placeholder": false, "content_hash": "850ff3269831f89289626b43c061c9d2564016040bc2b962bf73e225cf4d8749", "manual_build": "9.5.25", "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.5.X.
\nHowever, if you use foreign data servers that make use of user passwords for authentication, see the first changelog entry below.
\nAlso, if you are using third-party replication tools that depend on \"logical decoding\", see the fourth changelog entry below.
\nAlso, if you are upgrading from a version earlier than 9.5.6, see Section E.20.
", "compatibility_count": 0, "label": "9.5.7", "status_label": "Historical", "eol": "2021-02-11", "age_days": 3428, "support_days": -2056, "entries": [{"id": "9.5.7-3578fe21dc58d774", "cves": ["CVE-2017-7486", "CVE-2017-7547"], "html": "Restrict visibility of pg_user_mappings.umoptions, to protect passwords stored as user mapping options (Michael Paquier, Feike Steenbergen)
\nThe previous coding allowed the owner of a foreign server object, or anyone he has granted server USAGE permission to, to see the options for all user mappings associated with that server. This might well include passwords for other users. Adjust the view definition to match the behavior of information_schema.user_mapping_options, namely that these options are visible to the user being mapped, or if the mapping is for PUBLIC and the current user is the server owner, or if the current user is a superuser. (CVE-2017-7486)
\nBy itself, this patch will only fix the behavior in newly initdb'd databases. If you wish to apply this change in an existing database, follow the corrected procedure shown in the changelog entry for CVE-2017-7547, in Section E.18.
", "text": "Restrict visibility of pg_user_mappings.umoptions, to protect passwords stored as user mapping options (Michael Paquier, Feike Steenbergen) The previous coding allowed the owner of a foreign server object, or anyone he has granted server USAGE permission to, to see the options for all user mappings associated with that server. This might well include passwords for other users. Adjust the view definition to match the behavior of information_schema.user_mapping_options, namely that these options are visible to the user being mapped, or if the mapping is for PUBLIC and the current user is the server owner, or if the current user is a superuser. (CVE-2017-7486) By itself, this patch will only fix the behavior in newly initdb'd databases. If you wish to apply this change in an existing database, follow the corrected procedure shown in the changelog entry for CVE-2017-7547, in Section E.18.", "title": "Restrict visibility of pg_user_mappings.umoptions, to protect passwords stored as user mapping options", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "31570337cb05f988e416c6190d0bd16c7c48670bfc68f9bd95446e9f0c102998", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Restrict visibility of pg_user_mappings.umoptions, to protect passwords stored as user mapping options (Michael Paquier, Feike Steenbergen) The previous coding allowed the owner of a foreign server object, or anyone he has granted server USAGE permission to, to see the options for all user mappings associated with that server. This might well include passwords for other users. Adjust the view definition to match the behavior of information_schema.user_mapping_options, namely that these options are visible to the user being mapped, or if the mapping is for PUBLIC and the current user is the server owner, or if the current user is a superuser. (CVE-2017-7486) By itself, this patch will only fix the behavior in newly initdb'd databases. If you wish to apply this change in an existing database, follow the corrected procedure shown in the changelog entry for CVE-2017-7547, in release-9-5-8 .", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/001", "db_id": "f77e240082ec954d687b58a4122346a0", "patch_ids": [], "statement_hash": "84a85218acb9376b003adea8f95ee4502fbb61400f0dcee4f03572e763575b20", "relations": [], "version": "9.5.7", "category_label": "Security", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.7-87eaa9ade53cb66b", "cves": ["CVE-2017-7484"], "html": "Prevent exposure of statistical information via leaky operators (Peter Eisentraut)
\nSome selectivity estimation functions in the planner will apply user-defined operators to values obtained from pg_statistic, such as most common values and histogram entries. This occurs before table permissions are checked, so a nefarious user could exploit the behavior to obtain these values for table columns he does not have permission to read. To fix, fall back to a default estimate if the operator's implementation function is not certified leak-proof and the calling user does not have permission to read the table column whose statistics are needed. At least one of these criteria is satisfied in most cases in practice. (CVE-2017-7484)
", "text": "Prevent exposure of statistical information via leaky operators (Peter Eisentraut) Some selectivity estimation functions in the planner will apply user-defined operators to values obtained from pg_statistic, such as most common values and histogram entries. This occurs before table permissions are checked, so a nefarious user could exploit the behavior to obtain these values for table columns he does not have permission to read. To fix, fall back to a default estimate if the operator's implementation function is not certified leak-proof and the calling user does not have permission to read the table column whose statistics are needed. At least one of these criteria is satisfied in most cases in practice. (CVE-2017-7484)", "title": "Prevent exposure of statistical information via leaky operators", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "356e17300fb0d7c39d849c640fb723d9912eccd029bddcce89fc02f4e526c904", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent exposure of statistical information via leaky operators (Peter Eisentraut) Some selectivity estimation functions in the planner will apply user-defined operators to values obtained from pg_statistic, such as most common values and histogram entries. This occurs before table permissions are checked, so a nefarious user could exploit the behavior to obtain these values for table columns he does not have permission to read. To fix, fall back to a default estimate if the operator's implementation function is not certified leak-proof and the calling user does not have permission to read the table column whose statistics are needed. At least one of these criteria is satisfied in most cases in practice. (CVE-2017-7484)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/002", "db_id": "bf395c1f6a9c6ae6f5fb7af55beb6d79", "patch_ids": [], "statement_hash": "2302fdc9ede25dd70923fd1e8d3e93edc77b192bd27593b4221b2a1ac089c938", "relations": [{"rule": 2, "type": "equivalent", "target": "55ae062c0da94da274405a272c224d04", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2302fdc9ede25dd70923fd1e8d3e93edc77b192bd27593b4221b2a1ac089c938"}}, {"rule": 2, "type": "equivalent", "target": "828d8b499b868526013825cd04ce744e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2302fdc9ede25dd70923fd1e8d3e93edc77b192bd27593b4221b2a1ac089c938"}}, {"rule": 2, "type": "equivalent", "target": "b4b75c05a5ed8817af23933ab3fcec8f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2302fdc9ede25dd70923fd1e8d3e93edc77b192bd27593b4221b2a1ac089c938"}}, {"rule": 2, "type": "equivalent", "target": "f34602fe908d4a966c6ed06935e1f04d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2302fdc9ede25dd70923fd1e8d3e93edc77b192bd27593b4221b2a1ac089c938"}}], "version": "9.5.7", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "f34602fe908d4a966c6ed06935e1f04d", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Prevent exposure of statistical information via leaky operators", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2302fdc9ede25dd70923fd1e8d3e93edc77b192bd27593b4221b2a1ac089c938"}, "url": "/docs/compare/?release=9.6.3#9.6.3-87eaa9ade53cb66b", "source_url": "/docs/release/9.6.3/#AEN135466"}, {"db_id": "55ae062c0da94da274405a272c224d04", "kind": "equivalent", "version": "9.4.12", "label": "9.4.12", "title": "Prevent exposure of statistical information via leaky operators", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2302fdc9ede25dd70923fd1e8d3e93edc77b192bd27593b4221b2a1ac089c938"}, "url": "/docs/compare/?release=9.4.12#9.4.12-87eaa9ade53cb66b", "source_url": "/docs/release/9.4.12/#AEN121715"}, {"db_id": "b4b75c05a5ed8817af23933ab3fcec8f", "kind": "equivalent", "version": "9.3.17", "label": "9.3.17", "title": "Prevent exposure of statistical information via leaky operators", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2302fdc9ede25dd70923fd1e8d3e93edc77b192bd27593b4221b2a1ac089c938"}, "url": "/docs/compare/?release=9.3.17#9.3.17-87eaa9ade53cb66b", "source_url": "/docs/release/9.3.17/#AEN116096"}, {"db_id": "828d8b499b868526013825cd04ce744e", "kind": "equivalent", "version": "9.2.21", "label": "9.2.21", "title": "Prevent exposure of statistical information via leaky operators", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2302fdc9ede25dd70923fd1e8d3e93edc77b192bd27593b4221b2a1ac089c938"}, "url": "/docs/compare/?release=9.2.21#9.2.21-87eaa9ade53cb66b", "source_url": "/docs/release/9.2.21/#AEN111124"}]}, {"id": "9.5.7-559cb25c3768477b", "cves": ["CVE-2017-7485"], "html": "Restore libpq's recognition of the PGREQUIRESSL environment variable (Daniel Gustafsson)
\nProcessing of this environment variable was unintentionally dropped in PostgreSQL 9.3, but its documentation remained. This creates a security hazard, since users might be relying on the environment variable to force SSL-encrypted connections, but that would no longer be guaranteed. Restore handling of the variable, but give it lower priority than PGSSLMODE, to avoid breaking configurations that work correctly with post-9.3 code. (CVE-2017-7485)
", "text": "Restore libpq's recognition of the PGREQUIRESSL environment variable (Daniel Gustafsson) Processing of this environment variable was unintentionally dropped in PostgreSQL 9.3, but its documentation remained. This creates a security hazard, since users might be relying on the environment variable to force SSL-encrypted connections, but that would no longer be guaranteed. Restore handling of the variable, but give it lower priority than PGSSLMODE, to avoid breaking configurations that work correctly with post-9.3 code. (CVE-2017-7485)", "title": "Restore libpq's recognition of the PGREQUIRESSL environment variable", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "c9693c36e566d2a389039af6bd7c0e421d72e430848195d029efc50b1e9dff69", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Restore libpq's recognition of the PGREQUIRESSL environment variable (Daniel Gustafsson) Processing of this environment variable was unintentionally dropped in PostgreSQL 9.3, but its documentation remained. This creates a security hazard, since users might be relying on the environment variable to force SSL-encrypted connections, but that would no longer be guaranteed. Restore handling of the variable, but give it lower priority than PGSSLMODE, to avoid breaking configurations that work correctly with post-9.3 code. (CVE-2017-7485)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/003", "db_id": "4b178f576c006f92f17dafd5040b63d4", "patch_ids": [], "statement_hash": "7a18b2d433b86e8d648028e83dbd0ce8fd745e426e4895860e0e154a27b10b2f", "relations": [{"rule": 2, "type": "equivalent", "target": "8a663d8273a94d653ea47ed9e7245db6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7a18b2d433b86e8d648028e83dbd0ce8fd745e426e4895860e0e154a27b10b2f"}}, {"rule": 2, "type": "equivalent", "target": "c438ebbc5a20590f4d47bd544943e961", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7a18b2d433b86e8d648028e83dbd0ce8fd745e426e4895860e0e154a27b10b2f"}}, {"rule": 2, "type": "equivalent", "target": "d56eea5fbb1a7d7e8d1587729ca0cf14", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7a18b2d433b86e8d648028e83dbd0ce8fd745e426e4895860e0e154a27b10b2f"}}], "version": "9.5.7", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "c438ebbc5a20590f4d47bd544943e961", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Restore libpq's recognition of the PGREQUIRESSL environment variable", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7a18b2d433b86e8d648028e83dbd0ce8fd745e426e4895860e0e154a27b10b2f"}, "url": "/docs/compare/?release=9.6.3#9.6.3-559cb25c3768477b", "source_url": "/docs/release/9.6.3/#AEN135466"}, {"db_id": "8a663d8273a94d653ea47ed9e7245db6", "kind": "equivalent", "version": "9.4.12", "label": "9.4.12", "title": "Restore libpq's recognition of the PGREQUIRESSL environment variable", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7a18b2d433b86e8d648028e83dbd0ce8fd745e426e4895860e0e154a27b10b2f"}, "url": "/docs/compare/?release=9.4.12#9.4.12-559cb25c3768477b", "source_url": "/docs/release/9.4.12/#AEN121715"}, {"db_id": "d56eea5fbb1a7d7e8d1587729ca0cf14", "kind": "equivalent", "version": "9.3.17", "label": "9.3.17", "title": "Restore libpq's recognition of the PGREQUIRESSL environment variable", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7a18b2d433b86e8d648028e83dbd0ce8fd745e426e4895860e0e154a27b10b2f"}, "url": "/docs/compare/?release=9.3.17#9.3.17-559cb25c3768477b", "source_url": "/docs/release/9.3.17/#AEN116096"}]}, {"id": "9.5.7-6b238a397321deb0", "cves": [], "html": "Fix possibly-invalid initial snapshot during logical decoding (Petr Jelinek, Andres Freund)
\nThe initial snapshot created for a logical decoding replication slot was potentially incorrect. This could cause third-party tools that use logical decoding to copy incomplete/inconsistent initial data. This was more likely to happen if the source server was busy at the time of slot creation, or if another logical slot already existed.
\nIf you are using a replication tool that depends on logical decoding, and it should have copied a nonempty data set at the start of replication, it is advisable to recreate the replica after installing this update, or to verify its contents against the source server.
", "text": "Fix possibly-invalid initial snapshot during logical decoding (Petr Jelinek, Andres Freund) The initial snapshot created for a logical decoding replication slot was potentially incorrect. This could cause third-party tools that use logical decoding to copy incomplete/inconsistent initial data. This was more likely to happen if the source server was busy at the time of slot creation, or if another logical slot already existed. If you are using a replication tool that depends on logical decoding, and it should have copied a nonempty data set at the start of replication, it is advisable to recreate the replica after installing this update, or to verify its contents against the source server.", "title": "Fix possibly-invalid initial snapshot during logical decoding", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "d0499ae4dcd93333def12d1e3b902e481b5e97451a9d2fbd201468895173a41e", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix possibly-invalid initial snapshot during logical decoding (Petr Jelinek, Andres Freund) The initial snapshot created for a logical decoding replication slot was potentially incorrect. This could cause third-party tools that use logical decoding to copy incomplete/inconsistent initial data. This was more likely to happen if the source server was busy at the time of slot creation, or if another logical slot already existed. If you are using a replication tool that depends on logical decoding, and it should have copied a nonempty data set at the start of replication, it is advisable to recreate the replica after installing this update, or to verify its contents against the source server.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/004", "db_id": "f08f755d70b75ef35c30ae8a6d955c81", "patch_ids": [], "statement_hash": "55d08845b87209b80c37af90ff97947d7d431c9408916fb27e34455eb88b258d", "relations": [{"rule": 2, "type": "equivalent", "target": "2baaf2e665774e8e2c87b37d9edb045e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "55d08845b87209b80c37af90ff97947d7d431c9408916fb27e34455eb88b258d"}}, {"rule": 2, "type": "equivalent", "target": "5b13f9321266666fc498dfe67c993479", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "55d08845b87209b80c37af90ff97947d7d431c9408916fb27e34455eb88b258d"}}], "version": "9.5.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2baaf2e665774e8e2c87b37d9edb045e", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Fix possibly-invalid initial snapshot during logical decoding", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "55d08845b87209b80c37af90ff97947d7d431c9408916fb27e34455eb88b258d"}, "url": "/docs/compare/?release=9.6.3#9.6.3-6b238a397321deb0", "source_url": "/docs/release/9.6.3/#AEN135466"}, {"db_id": "5b13f9321266666fc498dfe67c993479", "kind": "equivalent", "version": "9.4.12", "label": "9.4.12", "title": "Fix possibly-invalid initial snapshot during logical decoding", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "55d08845b87209b80c37af90ff97947d7d431c9408916fb27e34455eb88b258d"}, "url": "/docs/compare/?release=9.4.12#9.4.12-6b238a397321deb0", "source_url": "/docs/release/9.4.12/#AEN121715"}]}, {"id": "9.5.7-713a97279226cff7", "cves": [], "html": "Fix possible corruption of \"init forks\" of unlogged indexes (Robert Haas, Michael Paquier)
\nThis could result in an unlogged index being set to an invalid state after a crash and restart. Such a problem would persist until the index was dropped and rebuilt.
", "text": "Fix possible corruption of \"init forks\" of unlogged indexes (Robert Haas, Michael Paquier) This could result in an unlogged index being set to an invalid state after a crash and restart. Such a problem would persist until the index was dropped and rebuilt.", "title": "Fix possible corruption of \"init forks\" of unlogged indexes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "97489d0a9aa069ca4c56582f52bc241c0a19dfe8b5ae4cc8a5b775d69e0d83a8", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix possible corruption of init forks of unlogged indexes (Robert Haas, Michael Paquier) This could result in an unlogged index being set to an invalid state after a crash and restart. Such a problem would persist until the index was dropped and rebuilt.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/005", "db_id": "bd24590e475333f4790f5fe53c61411a", "patch_ids": [], "statement_hash": "72154e11e8954b335d0bac05809c8026ca9489a2b55963899b1c9caca08b7e95", "relations": [{"rule": 2, "type": "equivalent", "target": "3cd432e6bf2afd9768a1ca6668a16b11", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "72154e11e8954b335d0bac05809c8026ca9489a2b55963899b1c9caca08b7e95"}}, {"rule": 2, "type": "equivalent", "target": "4211c712a1cafeeda59a3774d3215bb6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "72154e11e8954b335d0bac05809c8026ca9489a2b55963899b1c9caca08b7e95"}}, {"rule": 2, "type": "equivalent", "target": "78b68e1b952f1ca693a0b48ee6e72d22", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "72154e11e8954b335d0bac05809c8026ca9489a2b55963899b1c9caca08b7e95"}}, {"rule": 2, "type": "equivalent", "target": "ca9e7897b0b819057bd22c3e412c2a31", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "72154e11e8954b335d0bac05809c8026ca9489a2b55963899b1c9caca08b7e95"}}], "version": "9.5.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "ca9e7897b0b819057bd22c3e412c2a31", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Fix possible corruption of \"init forks\" of unlogged indexes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "72154e11e8954b335d0bac05809c8026ca9489a2b55963899b1c9caca08b7e95"}, "url": "/docs/compare/?release=9.6.3#9.6.3-713a97279226cff7", "source_url": "/docs/release/9.6.3/#AEN135466"}, {"db_id": "4211c712a1cafeeda59a3774d3215bb6", "kind": "equivalent", "version": "9.4.12", "label": "9.4.12", "title": "Fix possible corruption of \"init forks\" of unlogged indexes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "72154e11e8954b335d0bac05809c8026ca9489a2b55963899b1c9caca08b7e95"}, "url": "/docs/compare/?release=9.4.12#9.4.12-713a97279226cff7", "source_url": "/docs/release/9.4.12/#AEN121715"}, {"db_id": "3cd432e6bf2afd9768a1ca6668a16b11", "kind": "equivalent", "version": "9.3.17", "label": "9.3.17", "title": "Fix possible corruption of \"init forks\" of unlogged indexes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "72154e11e8954b335d0bac05809c8026ca9489a2b55963899b1c9caca08b7e95"}, "url": "/docs/compare/?release=9.3.17#9.3.17-713a97279226cff7", "source_url": "/docs/release/9.3.17/#AEN116096"}, {"db_id": "78b68e1b952f1ca693a0b48ee6e72d22", "kind": "equivalent", "version": "9.2.21", "label": "9.2.21", "title": "Fix possible corruption of \"init forks\" of unlogged indexes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "72154e11e8954b335d0bac05809c8026ca9489a2b55963899b1c9caca08b7e95"}, "url": "/docs/compare/?release=9.2.21#9.2.21-713a97279226cff7", "source_url": "/docs/release/9.2.21/#AEN111124"}]}, {"id": "9.5.7-e4a83b9f8d78bc1f", "cves": [], "html": "Fix incorrect reconstruction of pg_subtrans entries when a standby server replays a prepared but uncommitted two-phase transaction (Tom Lane)
\nIn most cases this turned out to have no visible ill effects, but in corner cases it could result in circular references in pg_subtrans, potentially causing infinite loops in queries that examine rows modified by the two-phase transaction.
", "text": "Fix incorrect reconstruction of pg_subtrans entries when a standby server replays a prepared but uncommitted two-phase transaction (Tom Lane) In most cases this turned out to have no visible ill effects, but in corner cases it could result in circular references in pg_subtrans, potentially causing infinite loops in queries that examine rows modified by the two-phase transaction.", "title": "Fix incorrect reconstruction of pg_subtrans entries when a standby server replays a prepared but uncommitted two-phase transaction", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "e98290481636176c1da6e93d34b3bbfd7ddea2672cb1edf5a47af918bf8505fe", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix incorrect reconstruction of pg_subtrans entries when a standby server replays a prepared but uncommitted two-phase transaction (Tom Lane) In most cases this turned out to have no visible ill effects, but in corner cases it could result in circular references in pg_subtrans, potentially causing infinite loops in queries that examine rows modified by the two-phase transaction.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/006", "db_id": "75c0cadf13ce21c94069e1147a75546c", "patch_ids": [], "statement_hash": "1646bb71052a636d7ea91585c578d6b36f95ecebe2e215e01cef7972ed52fa36", "relations": [{"rule": 2, "type": "equivalent", "target": "214a1b3821d5a36db45f6c05c6441387", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1646bb71052a636d7ea91585c578d6b36f95ecebe2e215e01cef7972ed52fa36"}}, {"rule": 2, "type": "equivalent", "target": "3a8a1634b4824238c9d0aaf6c493651e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1646bb71052a636d7ea91585c578d6b36f95ecebe2e215e01cef7972ed52fa36"}}, {"rule": 2, "type": "equivalent", "target": "5565ced6b2c6375ed2a7adcb94929f22", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1646bb71052a636d7ea91585c578d6b36f95ecebe2e215e01cef7972ed52fa36"}}, {"rule": 2, "type": "equivalent", "target": "a3e69383f90c4a60d164e139ede77344", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1646bb71052a636d7ea91585c578d6b36f95ecebe2e215e01cef7972ed52fa36"}}], "version": "9.5.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "214a1b3821d5a36db45f6c05c6441387", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Fix incorrect reconstruction of pg_subtrans entries when a standby server replays a prepared but uncommitted two-phase transaction", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1646bb71052a636d7ea91585c578d6b36f95ecebe2e215e01cef7972ed52fa36"}, "url": "/docs/compare/?release=9.6.3#9.6.3-e4a83b9f8d78bc1f", "source_url": "/docs/release/9.6.3/#AEN135466"}, {"db_id": "5565ced6b2c6375ed2a7adcb94929f22", "kind": "equivalent", "version": "9.4.12", "label": "9.4.12", "title": "Fix incorrect reconstruction of pg_subtrans entries when a standby server replays a prepared but uncommitted two-phase transaction", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1646bb71052a636d7ea91585c578d6b36f95ecebe2e215e01cef7972ed52fa36"}, "url": "/docs/compare/?release=9.4.12#9.4.12-e4a83b9f8d78bc1f", "source_url": "/docs/release/9.4.12/#AEN121715"}, {"db_id": "3a8a1634b4824238c9d0aaf6c493651e", "kind": "equivalent", "version": "9.3.17", "label": "9.3.17", "title": "Fix incorrect reconstruction of pg_subtrans entries when a standby server replays a prepared but uncommitted two-phase transaction", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1646bb71052a636d7ea91585c578d6b36f95ecebe2e215e01cef7972ed52fa36"}, "url": "/docs/compare/?release=9.3.17#9.3.17-e4a83b9f8d78bc1f", "source_url": "/docs/release/9.3.17/#AEN116096"}, {"db_id": "a3e69383f90c4a60d164e139ede77344", "kind": "equivalent", "version": "9.2.21", "label": "9.2.21", "title": "Fix incorrect reconstruction of pg_subtrans entries when a standby server replays a prepared but uncommitted two-phase transaction", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1646bb71052a636d7ea91585c578d6b36f95ecebe2e215e01cef7972ed52fa36"}, "url": "/docs/compare/?release=9.2.21#9.2.21-e4a83b9f8d78bc1f", "source_url": "/docs/release/9.2.21/#AEN111124"}]}, {"id": "9.5.7-1642c21f7d0331f5", "cves": [], "html": "Avoid possible crash in walsender due to failure to initialize a string buffer (Stas Kelvich, Fujii Masao)
", "text": "Avoid possible crash in walsender due to failure to initialize a string buffer (Stas Kelvich, Fujii Masao)", "title": "Avoid possible crash in walsender due to failure to initialize a string buffer", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "69e20a4a78d706efecc3b02afe1928ef697d557c458f4f1939df2830dfcf31f3", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid possible crash in walsender due to failure to initialize a string buffer (Stas Kelvich, Fujii Masao)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/007", "db_id": "4d108db450f3badf1c6cd090153a2648", "patch_ids": [], "statement_hash": "78c990a8e3916aac85819e0d441e44667ec95b081dcf7bb346767d9305e7a503", "relations": [{"rule": 2, "type": "equivalent", "target": "032864fc749f4c992f33733cdff5027a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "78c990a8e3916aac85819e0d441e44667ec95b081dcf7bb346767d9305e7a503"}}, {"rule": 2, "type": "equivalent", "target": "13a1d8ef35101865ff0224e06755e4c6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "78c990a8e3916aac85819e0d441e44667ec95b081dcf7bb346767d9305e7a503"}}], "version": "9.5.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "13a1d8ef35101865ff0224e06755e4c6", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Avoid possible crash in walsender due to failure to initialize a string buffer", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "78c990a8e3916aac85819e0d441e44667ec95b081dcf7bb346767d9305e7a503"}, "url": "/docs/compare/?release=9.6.3#9.6.3-1642c21f7d0331f5", "source_url": "/docs/release/9.6.3/#AEN135466"}, {"db_id": "032864fc749f4c992f33733cdff5027a", "kind": "equivalent", "version": "9.4.12", "label": "9.4.12", "title": "Avoid possible crash in walsender due to failure to initialize a string buffer", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "78c990a8e3916aac85819e0d441e44667ec95b081dcf7bb346767d9305e7a503"}, "url": "/docs/compare/?release=9.4.12#9.4.12-1642c21f7d0331f5", "source_url": "/docs/release/9.4.12/#AEN121715"}]}, {"id": "9.5.7-9b5f1dfe9c927f3a", "cves": [], "html": "Fix possible crash when rescanning a nearest-neighbor index-only scan on a GiST index (Tom Lane)
", "text": "Fix possible crash when rescanning a nearest-neighbor index-only scan on a GiST index (Tom Lane)", "title": "Fix possible crash when rescanning a nearest-neighbor index-only scan on a GiST index", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "9727a007ab4c6e3693aa2b4d55434a7f43ad0f8a7715d5798f35c0a977e5b683", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix possible crash when rescanning a nearest-neighbor index-only scan on a GiST index (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/008", "db_id": "848ec67f014cc1773892db9fb138409a", "patch_ids": [], "statement_hash": "da0fe145de3873dd50be80b13b9c123ea764887e0a86cf7f27cee5eb2b39af71", "relations": [{"rule": 2, "type": "equivalent", "target": "708eb8c8884994fd2a9bde107b8b20e3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "da0fe145de3873dd50be80b13b9c123ea764887e0a86cf7f27cee5eb2b39af71"}}], "version": "9.5.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "708eb8c8884994fd2a9bde107b8b20e3", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Fix possible crash when rescanning a nearest-neighbor index-only scan on a GiST index", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "da0fe145de3873dd50be80b13b9c123ea764887e0a86cf7f27cee5eb2b39af71"}, "url": "/docs/compare/?release=9.6.3#9.6.3-9b5f1dfe9c927f3a", "source_url": "/docs/release/9.6.3/#AEN135466"}]}, {"id": "9.5.7-54a4d31c01245cc6", "cves": [], "html": "Fix postmaster's handling of fork() failure for a background worker process (Tom Lane)
Previously, the postmaster updated portions of its state as though the process had been launched successfully, resulting in subsequent confusion.
", "text": "Fix postmaster's handling of fork() failure for a background worker process (Tom Lane) Previously, the postmaster updated portions of its state as though the process had been launched successfully, resulting in subsequent confusion.", "title": "Fix postmaster's handling of fork() failure for a background worker process", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "07feb8b447a5fca59124522f2b2741716c98bf534dbbfb784a1b95e3541b6a46", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix postmaster's handling of fork() failure for a background worker process (Tom Lane) Previously, the postmaster updated portions of its state as though the process had been launched successfully, resulting in subsequent confusion.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/009", "db_id": "e4a035b7ce4d85af690ca996cd09f523", "patch_ids": [], "statement_hash": "c1f121c35aed08692450221269d3c58854ee2d89697e0ee044c7e73ece604d11", "relations": [{"rule": 2, "type": "equivalent", "target": "227f3ff0d82b87f4d6dabda4f15bfd7e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c1f121c35aed08692450221269d3c58854ee2d89697e0ee044c7e73ece604d11"}}, {"rule": 2, "type": "equivalent", "target": "7021976579f14345872a9d74e0dfb7b6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c1f121c35aed08692450221269d3c58854ee2d89697e0ee044c7e73ece604d11"}}], "version": "9.5.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "227f3ff0d82b87f4d6dabda4f15bfd7e", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Fix postmaster's handling of fork() failure for a background worker process", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c1f121c35aed08692450221269d3c58854ee2d89697e0ee044c7e73ece604d11"}, "url": "/docs/compare/?release=9.6.3#9.6.3-54a4d31c01245cc6", "source_url": "/docs/release/9.6.3/#AEN135466"}, {"db_id": "7021976579f14345872a9d74e0dfb7b6", "kind": "equivalent", "version": "9.4.12", "label": "9.4.12", "title": "Fix postmaster's handling of fork() failure for a background worker process", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c1f121c35aed08692450221269d3c58854ee2d89697e0ee044c7e73ece604d11"}, "url": "/docs/compare/?release=9.4.12#9.4.12-54a4d31c01245cc6", "source_url": "/docs/release/9.4.12/#AEN121715"}]}, {"id": "9.5.7-7d3937fefbbd4a8b", "cves": [], "html": "Fix crash or wrong answers when a GROUPING SETS column's data type is hashable but not sortable (Pavan Deolasee)
", "text": "Fix crash or wrong answers when a GROUPING SETS column's data type is hashable but not sortable (Pavan Deolasee)", "title": "Fix crash or wrong answers when a GROUPING SETS column's data type is hashable but not sortable", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "a31a8c62f3870301312ebc6fa613c70dd37348eb6a97eaec9eac8865d0f7a7e2", "section_path": ["Changes"], "commit_groups": [["7be3678a8"]], "identity_text": "Fix crash or wrong answers when a GROUPING SETS column's data type is hashable but not sortable (Pavan Deolasee)", "commit_aliases": ["7be3678a8"], "source_commits": ["7be3678a8"], "source_entry_id": "9.5.7/changes/010", "db_id": "fcc75dca0f4e28c9cbb75c4dc40d8e87", "patch_ids": ["6ebb14f92e467aec998284a351459c90"], "statement_hash": "b2dc9eb6052413d779872f79bc3e71a9212691084fc0ebc95010eca310499c61", "relations": [], "version": "9.5.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.7-d3b5428f4c9f7c21", "cves": [], "html": "Avoid applying \"physical targetlist\" optimization to custom scans (Dmitry Ivanov, Tom Lane)
\nThis optimization supposed that retrieving all columns of a tuple is inexpensive, which is true for ordinary Postgres tuples; but it might not be the case for a custom scan provider.
", "text": "Avoid applying \"physical targetlist\" optimization to custom scans (Dmitry Ivanov, Tom Lane) This optimization supposed that retrieving all columns of a tuple is inexpensive, which is true for ordinary Postgres tuples; but it might not be the case for a custom scan provider.", "title": "Avoid applying \"physical targetlist\" optimization to custom scans", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "9760ed1ad5fdef02faeaf0da61815f9d9bf0db73041e9be5130def22bc30abc2", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid applying physical targetlist optimization to custom scans (Dmitry Ivanov, Tom Lane) This optimization supposed that retrieving all columns of a tuple is inexpensive, which is true for ordinary Postgres tuples; but it might not be the case for a custom scan provider.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/011", "db_id": "7610e1b5bb1b863453b18ad7692044d5", "patch_ids": [], "statement_hash": "19cc96774d0cc9fc83e961f896e44e635018b698b9a939e82978f9350873645d", "relations": [{"rule": 2, "type": "equivalent", "target": "c3c35c72c24cf657ddc462236e622179", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "19cc96774d0cc9fc83e961f896e44e635018b698b9a939e82978f9350873645d"}}], "version": "9.5.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "c3c35c72c24cf657ddc462236e622179", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Avoid applying \"physical targetlist\" optimization to custom scans", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "19cc96774d0cc9fc83e961f896e44e635018b698b9a939e82978f9350873645d"}, "url": "/docs/compare/?release=9.6.3#9.6.3-d3b5428f4c9f7c21", "source_url": "/docs/release/9.6.3/#AEN135466"}]}, {"id": "9.5.7-16b690610ab64037", "cves": [], "html": "Use the correct sub-expression when applying a FOR ALL row-level-security policy (Stephen Frost)
\nIn some cases the WITH CHECK restriction would be applied when the USING restriction is more appropriate.
", "text": "Use the correct sub-expression when applying a FOR ALL row-level-security policy (Stephen Frost) In some cases the WITH CHECK restriction would be applied when the USING restriction is more appropriate.", "title": "Use the correct sub-expression when applying a FOR ALL row-level-security policy", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "490cc6c1d659cdbea4e719135a0aab62a4037bc60b06628efb256fcd85103842", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Use the correct sub-expression when applying a FOR ALL row-level-security policy (Stephen Frost) In some cases the WITH CHECK restriction would be applied when the USING restriction is more appropriate.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/012", "db_id": "631fae68b9bdbc1d475bad275f143336", "patch_ids": [], "statement_hash": "3d0b5f900a8abf2b47d4fa9057a8f3ad9817d70e1ff352397cf5e7f9aba6626d", "relations": [{"rule": 2, "type": "equivalent", "target": "2750f7cebe204ecf0be51bb1e2064e0f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3d0b5f900a8abf2b47d4fa9057a8f3ad9817d70e1ff352397cf5e7f9aba6626d"}}], "version": "9.5.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2750f7cebe204ecf0be51bb1e2064e0f", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Use the correct sub-expression when applying a FOR ALL row-level-security policy", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3d0b5f900a8abf2b47d4fa9057a8f3ad9817d70e1ff352397cf5e7f9aba6626d"}, "url": "/docs/compare/?release=9.6.3#9.6.3-16b690610ab64037", "source_url": "/docs/release/9.6.3/#AEN135466"}]}, {"id": "9.5.7-c9328ee99c42c738", "cves": [], "html": "Ensure parsing of queries in extension scripts sees the results of immediately-preceding DDL (Julien Rouhaud, Tom Lane)
\nDue to lack of a cache flush step between commands in an extension script file, non-utility queries might not see the effects of an immediately preceding catalog change, such as ALTER TABLE ... RENAME.
", "text": "Ensure parsing of queries in extension scripts sees the results of immediately-preceding DDL (Julien Rouhaud, Tom Lane) Due to lack of a cache flush step between commands in an extension script file, non-utility queries might not see the effects of an immediately preceding catalog change, such as ALTER TABLE ... RENAME.", "title": "Ensure parsing of queries in extension scripts sees the results of immediately-preceding DDL", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "984c9075ece4152f93a8def878c245a5a7c6c0a06a3b0ce8a96ac799da243115", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ensure parsing of queries in extension scripts sees the results of immediately-preceding DDL (Julien Rouhaud, Tom Lane) Due to lack of a cache flush step between commands in an extension script file, non-utility queries might not see the effects of an immediately preceding catalog change, such as ALTER TABLE ... RENAME.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/013", "db_id": "0d4f2f20b3107b81483a53a687d59d55", "patch_ids": [], "statement_hash": "7cd007e80d6ca53d427cc836baf56b899b99eb8558570ed85e8ed98e90181210", "relations": [{"rule": 2, "type": "equivalent", "target": "091e27d5a961049388f50641f611f375", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7cd007e80d6ca53d427cc836baf56b899b99eb8558570ed85e8ed98e90181210"}}, {"rule": 2, "type": "equivalent", "target": "1a7d8686c8e50760b935ef10ee916805", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7cd007e80d6ca53d427cc836baf56b899b99eb8558570ed85e8ed98e90181210"}}, {"rule": 2, "type": "equivalent", "target": "5ceac09fd9d4bab483dfd2a50194800a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7cd007e80d6ca53d427cc836baf56b899b99eb8558570ed85e8ed98e90181210"}}, {"rule": 2, "type": "equivalent", "target": "8b609346c52066839e272fc58725e644", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7cd007e80d6ca53d427cc836baf56b899b99eb8558570ed85e8ed98e90181210"}}], "version": "9.5.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "1a7d8686c8e50760b935ef10ee916805", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Ensure parsing of queries in extension scripts sees the results of immediately-preceding DDL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7cd007e80d6ca53d427cc836baf56b899b99eb8558570ed85e8ed98e90181210"}, "url": "/docs/compare/?release=9.6.3#9.6.3-c9328ee99c42c738", "source_url": "/docs/release/9.6.3/#AEN135466"}, {"db_id": "8b609346c52066839e272fc58725e644", "kind": "equivalent", "version": "9.4.12", "label": "9.4.12", "title": "Ensure parsing of queries in extension scripts sees the results of immediately-preceding DDL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7cd007e80d6ca53d427cc836baf56b899b99eb8558570ed85e8ed98e90181210"}, "url": "/docs/compare/?release=9.4.12#9.4.12-c9328ee99c42c738", "source_url": "/docs/release/9.4.12/#AEN121715"}, {"db_id": "5ceac09fd9d4bab483dfd2a50194800a", "kind": "equivalent", "version": "9.3.17", "label": "9.3.17", "title": "Ensure parsing of queries in extension scripts sees the results of immediately-preceding DDL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7cd007e80d6ca53d427cc836baf56b899b99eb8558570ed85e8ed98e90181210"}, "url": "/docs/compare/?release=9.3.17#9.3.17-c9328ee99c42c738", "source_url": "/docs/release/9.3.17/#AEN116096"}, {"db_id": "091e27d5a961049388f50641f611f375", "kind": "equivalent", "version": "9.2.21", "label": "9.2.21", "title": "Ensure parsing of queries in extension scripts sees the results of immediately-preceding DDL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7cd007e80d6ca53d427cc836baf56b899b99eb8558570ed85e8ed98e90181210"}, "url": "/docs/compare/?release=9.2.21#9.2.21-c9328ee99c42c738", "source_url": "/docs/release/9.2.21/#AEN111124"}]}, {"id": "9.5.7-59c256fd7f157862", "cves": [], "html": "Skip tablespace privilege checks when ALTER TABLE ... ALTER COLUMN TYPE rebuilds an existing index (Noah Misch)
\nThe command failed if the calling user did not currently have CREATE privilege for the tablespace containing the index. That behavior seems unhelpful, so skip the check, allowing the index to be rebuilt where it is.
", "text": "Skip tablespace privilege checks when ALTER TABLE ... ALTER COLUMN TYPE rebuilds an existing index (Noah Misch) The command failed if the calling user did not currently have CREATE privilege for the tablespace containing the index. That behavior seems unhelpful, so skip the check, allowing the index to be rebuilt where it is.", "title": "Skip tablespace privilege checks when ALTER TABLE ... ALTER COLUMN TYPE rebuilds an existing index", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "af8c71b5295519e056fae5be3fa25978e42be4bf8a28c1677c9ecf324362802e", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Skip tablespace privilege checks when ALTER TABLE ... ALTER COLUMN TYPE rebuilds an existing index (Noah Misch) The command failed if the calling user did not currently have CREATE privilege for the tablespace containing the index. That behavior seems unhelpful, so skip the check, allowing the index to be rebuilt where it is.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/014", "db_id": "ed422045ecccee371ff7ba838d17ba51", "patch_ids": [], "statement_hash": "e3c9d71ababcb3e97b2d38558157f78acc3278e6fa2b08f35fd85bc457ef276d", "relations": [{"rule": 2, "type": "equivalent", "target": "18c29c84842d816ad4eb40f996fba562", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e3c9d71ababcb3e97b2d38558157f78acc3278e6fa2b08f35fd85bc457ef276d"}}, {"rule": 2, "type": "equivalent", "target": "4e28fe4f9a051cff71b36536cbe0197c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e3c9d71ababcb3e97b2d38558157f78acc3278e6fa2b08f35fd85bc457ef276d"}}, {"rule": 2, "type": "equivalent", "target": "c38965b3989e4d845a4faf6c853a63b2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e3c9d71ababcb3e97b2d38558157f78acc3278e6fa2b08f35fd85bc457ef276d"}}, {"rule": 2, "type": "equivalent", "target": "e56aa9bff7867a1f9479bee0dc1ff003", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e3c9d71ababcb3e97b2d38558157f78acc3278e6fa2b08f35fd85bc457ef276d"}}], "version": "9.5.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "18c29c84842d816ad4eb40f996fba562", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Skip tablespace privilege checks when ALTER TABLE ... ALTER COLUMN TYPE rebuilds an existing index", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e3c9d71ababcb3e97b2d38558157f78acc3278e6fa2b08f35fd85bc457ef276d"}, "url": "/docs/compare/?release=9.6.3#9.6.3-59c256fd7f157862", "source_url": "/docs/release/9.6.3/#AEN135466"}, {"db_id": "4e28fe4f9a051cff71b36536cbe0197c", "kind": "equivalent", "version": "9.4.12", "label": "9.4.12", "title": "Skip tablespace privilege checks when ALTER TABLE ... ALTER COLUMN TYPE rebuilds an existing index", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e3c9d71ababcb3e97b2d38558157f78acc3278e6fa2b08f35fd85bc457ef276d"}, "url": "/docs/compare/?release=9.4.12#9.4.12-59c256fd7f157862", "source_url": "/docs/release/9.4.12/#AEN121715"}, {"db_id": "e56aa9bff7867a1f9479bee0dc1ff003", "kind": "equivalent", "version": "9.3.17", "label": "9.3.17", "title": "Skip tablespace privilege checks when ALTER TABLE ... ALTER COLUMN TYPE rebuilds an existing index", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e3c9d71ababcb3e97b2d38558157f78acc3278e6fa2b08f35fd85bc457ef276d"}, "url": "/docs/compare/?release=9.3.17#9.3.17-59c256fd7f157862", "source_url": "/docs/release/9.3.17/#AEN116096"}, {"db_id": "c38965b3989e4d845a4faf6c853a63b2", "kind": "equivalent", "version": "9.2.21", "label": "9.2.21", "title": "Skip tablespace privilege checks when ALTER TABLE ... ALTER COLUMN TYPE rebuilds an existing index", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e3c9d71ababcb3e97b2d38558157f78acc3278e6fa2b08f35fd85bc457ef276d"}, "url": "/docs/compare/?release=9.2.21#9.2.21-59c256fd7f157862", "source_url": "/docs/release/9.2.21/#AEN111124"}]}, {"id": "9.5.7-e175fb06a3203f9a", "cves": [], "html": "Fix ALTER TABLE ... VALIDATE CONSTRAINT to not recurse to child tables when the constraint is marked NO INHERIT (Amit Langote)
\nThis fix prevents unwanted \"constraint does not exist\" failures when no matching constraint is present in the child tables.
", "text": "Fix ALTER TABLE ... VALIDATE CONSTRAINT to not recurse to child tables when the constraint is marked NO INHERIT (Amit Langote) This fix prevents unwanted \"constraint does not exist\" failures when no matching constraint is present in the child tables.", "title": "Fix ALTER TABLE ... VALIDATE CONSTRAINT to not recurse to child tables when the constraint is marked NO INHERIT", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "d274dc8059c34097046f2168454c889cf70b0badadeaa397fceec4aa7a43bf04", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix ALTER TABLE ... VALIDATE CONSTRAINT to not recurse to child tables when the constraint is marked NO INHERIT (Amit Langote) This fix prevents unwanted constraint does not exist failures when no matching constraint is present in the child tables.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/015", "db_id": "879aff98f14e268327e22c922d4e9089", "patch_ids": [], "statement_hash": "506e016e739d202330f73387c06195571792dfa786d626323d84c373db03b4a7", "relations": [{"rule": 2, "type": "equivalent", "target": "81d23cfd99a39dc495d69e569baa889e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506e016e739d202330f73387c06195571792dfa786d626323d84c373db03b4a7"}}, {"rule": 2, "type": "equivalent", "target": "9133d2a12ec3fd2b0a6cea89d097df83", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506e016e739d202330f73387c06195571792dfa786d626323d84c373db03b4a7"}}, {"rule": 2, "type": "equivalent", "target": "cb079a253c7af9722536a1bd69e85265", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506e016e739d202330f73387c06195571792dfa786d626323d84c373db03b4a7"}}, {"rule": 2, "type": "equivalent", "target": "dae34339a2ec9467a3ace74f31bb3942", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506e016e739d202330f73387c06195571792dfa786d626323d84c373db03b4a7"}}], "version": "9.5.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "9133d2a12ec3fd2b0a6cea89d097df83", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Fix ALTER TABLE ... VALIDATE CONSTRAINT to not recurse to child tables when the constraint is marked NO INHERIT", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506e016e739d202330f73387c06195571792dfa786d626323d84c373db03b4a7"}, "url": "/docs/compare/?release=9.6.3#9.6.3-e175fb06a3203f9a", "source_url": "/docs/release/9.6.3/#AEN135466"}, {"db_id": "81d23cfd99a39dc495d69e569baa889e", "kind": "equivalent", "version": "9.4.12", "label": "9.4.12", "title": "Fix ALTER TABLE ... VALIDATE CONSTRAINT to not recurse to child tables when the constraint is marked NO INHERIT", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506e016e739d202330f73387c06195571792dfa786d626323d84c373db03b4a7"}, "url": "/docs/compare/?release=9.4.12#9.4.12-e175fb06a3203f9a", "source_url": "/docs/release/9.4.12/#AEN121715"}, {"db_id": "cb079a253c7af9722536a1bd69e85265", "kind": "equivalent", "version": "9.3.17", "label": "9.3.17", "title": "Fix ALTER TABLE ... VALIDATE CONSTRAINT to not recurse to child tables when the constraint is marked NO INHERIT", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506e016e739d202330f73387c06195571792dfa786d626323d84c373db03b4a7"}, "url": "/docs/compare/?release=9.3.17#9.3.17-e175fb06a3203f9a", "source_url": "/docs/release/9.3.17/#AEN116096"}, {"db_id": "dae34339a2ec9467a3ace74f31bb3942", "kind": "equivalent", "version": "9.2.21", "label": "9.2.21", "title": "Fix ALTER TABLE ... VALIDATE CONSTRAINT to not recurse to child tables when the constraint is marked NO INHERIT", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "506e016e739d202330f73387c06195571792dfa786d626323d84c373db03b4a7"}, "url": "/docs/compare/?release=9.2.21#9.2.21-e175fb06a3203f9a", "source_url": "/docs/release/9.2.21/#AEN111124"}]}, {"id": "9.5.7-6e4ed89cb2b008ba", "cves": [], "html": "Avoid dangling pointer in COPY ... TO when row-level security is active for the source table (Tom Lane)
\nUsually this had no ill effects, but sometimes it would cause unexpected errors or crashes.
", "text": "Avoid dangling pointer in COPY ... TO when row-level security is active for the source table (Tom Lane) Usually this had no ill effects, but sometimes it would cause unexpected errors or crashes.", "title": "Avoid dangling pointer in COPY ... TO when row-level security is active for the source table", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "3f1cb363b236f8175e0d9d9336f31b0b764ce62d88805c2708aa81f7ad186157", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid dangling pointer in COPY ... TO when row-level security is active for the source table (Tom Lane) Usually this had no ill effects, but sometimes it would cause unexpected errors or crashes.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/016", "db_id": "785bb0b6ad6b1baa90f2a9b38ed532f2", "patch_ids": [], "statement_hash": "dbe58913005d303dcb2791e2ffb817f07097e8c0352834ae0a458810d05db34e", "relations": [{"rule": 2, "type": "equivalent", "target": "21e6a4bce9ed30487aef9cb7d36ae609", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dbe58913005d303dcb2791e2ffb817f07097e8c0352834ae0a458810d05db34e"}}], "version": "9.5.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "21e6a4bce9ed30487aef9cb7d36ae609", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Avoid dangling pointer in COPY ... TO when row-level security is active for the source table", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dbe58913005d303dcb2791e2ffb817f07097e8c0352834ae0a458810d05db34e"}, "url": "/docs/compare/?release=9.6.3#9.6.3-6e4ed89cb2b008ba", "source_url": "/docs/release/9.6.3/#AEN135466"}]}, {"id": "9.5.7-f3e5cdfad21d121d", "cves": [], "html": "Avoid accessing an already-closed relcache entry in CLUSTER and VACUUM FULL (Tom Lane)
\nWith some bad luck, this could lead to indexes on the target relation getting rebuilt with the wrong persistence setting.
", "text": "Avoid accessing an already-closed relcache entry in CLUSTER and VACUUM FULL (Tom Lane) With some bad luck, this could lead to indexes on the target relation getting rebuilt with the wrong persistence setting.", "title": "Avoid accessing an already-closed relcache entry in CLUSTER and VACUUM FULL", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "2a2fa3c919091827252145436afaf8b2768969211e209b94475b941d772107bd", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid accessing an already-closed relcache entry in CLUSTER and VACUUM FULL (Tom Lane) With some bad luck, this could lead to indexes on the target relation getting rebuilt with the wrong persistence setting.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/017", "db_id": "a6733bd383f23d62fcc72015919cdb38", "patch_ids": [], "statement_hash": "07f8cf5e468233ecceca3bbb87645395bef0b8aa04363346062f8e750f7cd89c", "relations": [{"rule": 2, "type": "equivalent", "target": "e889ca676777b58dc8828550e7345907", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "07f8cf5e468233ecceca3bbb87645395bef0b8aa04363346062f8e750f7cd89c"}}], "version": "9.5.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "e889ca676777b58dc8828550e7345907", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Avoid accessing an already-closed relcache entry in CLUSTER and VACUUM FULL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "07f8cf5e468233ecceca3bbb87645395bef0b8aa04363346062f8e750f7cd89c"}, "url": "/docs/compare/?release=9.6.3#9.6.3-f3e5cdfad21d121d", "source_url": "/docs/release/9.6.3/#AEN135466"}]}, {"id": "9.5.7-f9e735bcb23211e8", "cves": [], "html": "Fix VACUUM to account properly for pages that could not be scanned due to conflicting page pins (Andrew Gierth)
\nThis tended to lead to underestimation of the number of tuples in the table. In the worst case of a small heavily-contended table, VACUUM could incorrectly report that the table contained no tuples, leading to very bad planning choices.
", "text": "Fix VACUUM to account properly for pages that could not be scanned due to conflicting page pins (Andrew Gierth) This tended to lead to underestimation of the number of tuples in the table. In the worst case of a small heavily-contended table, VACUUM could incorrectly report that the table contained no tuples, leading to very bad planning choices.", "title": "Fix VACUUM to account properly for pages that could not be scanned due to conflicting page pins", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "41e9f26c06fbff14261498b886cb7bb75db1861ac3de56eae011302d722f699d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix VACUUM to account properly for pages that could not be scanned due to conflicting page pins (Andrew Gierth) This tended to lead to underestimation of the number of tuples in the table. In the worst case of a small heavily-contended table, VACUUM could incorrectly report that the table contained no tuples, leading to very bad planning choices.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/018", "db_id": "2d36e5ed81ee210a164b25727a73040f", "patch_ids": [], "statement_hash": "c539ad1307b5499f55caf526e5f45f749931d5ae8869a8a2e3ae8f2959215c85", "relations": [{"rule": 2, "type": "equivalent", "target": "4f92bff860b6c34082de43b62fb3256d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c539ad1307b5499f55caf526e5f45f749931d5ae8869a8a2e3ae8f2959215c85"}}, {"rule": 2, "type": "equivalent", "target": "67e235deb3d83dbacc19f40a3784496f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c539ad1307b5499f55caf526e5f45f749931d5ae8869a8a2e3ae8f2959215c85"}}, {"rule": 2, "type": "equivalent", "target": "71333b3f0782b3c754f54310fafc44f2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c539ad1307b5499f55caf526e5f45f749931d5ae8869a8a2e3ae8f2959215c85"}}, {"rule": 2, "type": "equivalent", "target": "738d1e7d0259c62f5e61aedc1e31d390", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c539ad1307b5499f55caf526e5f45f749931d5ae8869a8a2e3ae8f2959215c85"}}], "version": "9.5.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "67e235deb3d83dbacc19f40a3784496f", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Fix VACUUM to account properly for pages that could not be scanned due to conflicting page pins", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c539ad1307b5499f55caf526e5f45f749931d5ae8869a8a2e3ae8f2959215c85"}, "url": "/docs/compare/?release=9.6.3#9.6.3-f9e735bcb23211e8", "source_url": "/docs/release/9.6.3/#AEN135466"}, {"db_id": "738d1e7d0259c62f5e61aedc1e31d390", "kind": "equivalent", "version": "9.4.12", "label": "9.4.12", "title": "Fix VACUUM to account properly for pages that could not be scanned due to conflicting page pins", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c539ad1307b5499f55caf526e5f45f749931d5ae8869a8a2e3ae8f2959215c85"}, "url": "/docs/compare/?release=9.4.12#9.4.12-f9e735bcb23211e8", "source_url": "/docs/release/9.4.12/#AEN121715"}, {"db_id": "4f92bff860b6c34082de43b62fb3256d", "kind": "equivalent", "version": "9.3.17", "label": "9.3.17", "title": "Fix VACUUM to account properly for pages that could not be scanned due to conflicting page pins", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c539ad1307b5499f55caf526e5f45f749931d5ae8869a8a2e3ae8f2959215c85"}, "url": "/docs/compare/?release=9.3.17#9.3.17-f9e735bcb23211e8", "source_url": "/docs/release/9.3.17/#AEN116096"}, {"db_id": "71333b3f0782b3c754f54310fafc44f2", "kind": "equivalent", "version": "9.2.21", "label": "9.2.21", "title": "Fix VACUUM to account properly for pages that could not be scanned due to conflicting page pins", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c539ad1307b5499f55caf526e5f45f749931d5ae8869a8a2e3ae8f2959215c85"}, "url": "/docs/compare/?release=9.2.21#9.2.21-f9e735bcb23211e8", "source_url": "/docs/release/9.2.21/#AEN111124"}]}, {"id": "9.5.7-71bfa252a436aa00", "cves": [], "html": "Ensure that bulk-tuple-transfer loops within a hash join are interruptible by query cancel requests (Tom Lane, Thomas Munro)
", "text": "Ensure that bulk-tuple-transfer loops within a hash join are interruptible by query cancel requests (Tom Lane, Thomas Munro)", "title": "Ensure that bulk-tuple-transfer loops within a hash join are interruptible by query cancel requests", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "1607f1f0650306afd724a89bb6264f8f8acc9cf6aba843827b2128ab6dd65651", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ensure that bulk-tuple-transfer loops within a hash join are interruptible by query cancel requests (Tom Lane, Thomas Munro)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/019", "db_id": "b9dbfae1d26849c91b891fd3f3043668", "patch_ids": [], "statement_hash": "1562a4c4c3bb33538f2e69ea858db766d61467d12edcd1161c46a760bc7920a9", "relations": [{"rule": 2, "type": "equivalent", "target": "44a80c2bde78d80851b1a09ce27946cd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1562a4c4c3bb33538f2e69ea858db766d61467d12edcd1161c46a760bc7920a9"}}, {"rule": 2, "type": "equivalent", "target": "4ebb29373a0e5c0d4208e6dd79e23c12", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1562a4c4c3bb33538f2e69ea858db766d61467d12edcd1161c46a760bc7920a9"}}, {"rule": 2, "type": "equivalent", "target": "e032b7048304783de6b9cf719a0a16f0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1562a4c4c3bb33538f2e69ea858db766d61467d12edcd1161c46a760bc7920a9"}}, {"rule": 2, "type": "equivalent", "target": "efdfecf5ad98e461aed2bca8807b220a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1562a4c4c3bb33538f2e69ea858db766d61467d12edcd1161c46a760bc7920a9"}}], "version": "9.5.7", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "efdfecf5ad98e461aed2bca8807b220a", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Ensure that bulk-tuple-transfer loops within a hash join are interruptible by query cancel requests", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1562a4c4c3bb33538f2e69ea858db766d61467d12edcd1161c46a760bc7920a9"}, "url": "/docs/compare/?release=9.6.3#9.6.3-71bfa252a436aa00", "source_url": "/docs/release/9.6.3/#AEN135466"}, {"db_id": "4ebb29373a0e5c0d4208e6dd79e23c12", "kind": "equivalent", "version": "9.4.12", "label": "9.4.12", "title": "Ensure that bulk-tuple-transfer loops within a hash join are interruptible by query cancel requests", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1562a4c4c3bb33538f2e69ea858db766d61467d12edcd1161c46a760bc7920a9"}, "url": "/docs/compare/?release=9.4.12#9.4.12-71bfa252a436aa00", "source_url": "/docs/release/9.4.12/#AEN121715"}, {"db_id": "44a80c2bde78d80851b1a09ce27946cd", "kind": "equivalent", "version": "9.3.17", "label": "9.3.17", "title": "Ensure that bulk-tuple-transfer loops within a hash join are interruptible by query cancel requests", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1562a4c4c3bb33538f2e69ea858db766d61467d12edcd1161c46a760bc7920a9"}, "url": "/docs/compare/?release=9.3.17#9.3.17-71bfa252a436aa00", "source_url": "/docs/release/9.3.17/#AEN116096"}, {"db_id": "e032b7048304783de6b9cf719a0a16f0", "kind": "equivalent", "version": "9.2.21", "label": "9.2.21", "title": "Ensure that bulk-tuple-transfer loops within a hash join are interruptible by query cancel requests", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1562a4c4c3bb33538f2e69ea858db766d61467d12edcd1161c46a760bc7920a9"}, "url": "/docs/compare/?release=9.2.21#9.2.21-71bfa252a436aa00", "source_url": "/docs/release/9.2.21/#AEN111124"}]}, {"id": "9.5.7-e207493ed9ad3365", "cves": [], "html": "Fix integer-overflow problems in interval comparison (Kyotaro Horiguchi, Tom Lane)
\nThe comparison operators for type interval could yield wrong answers for intervals larger than about 296000 years. Indexes on columns containing such large values should be reindexed, since they may be corrupt.
", "text": "Fix integer-overflow problems in interval comparison (Kyotaro Horiguchi, Tom Lane) The comparison operators for type interval could yield wrong answers for intervals larger than about 296000 years. Indexes on columns containing such large values should be reindexed, since they may be corrupt.", "title": "Fix integer-overflow problems in interval comparison", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.7/#AEN130075", "source_hash": "c4b2fc0f9ad31c4c97ab853c78e89a7437179466ef1ebd79e03742ff7416f531", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix integer-overflow problems in interval comparison (Kyotaro Horiguchi, Tom Lane) The comparison operators for type interval could yield wrong answers for intervals larger than about 296000 years. Indexes on columns containing such large values should be reindexed, since they may be corrupt.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.5.7/changes/020", "db_id": "0a0db6affb7f39f7ea35725bbbea34d7", "patch_ids": [], "statement_hash": "92b2e5bb9d07607656f3c8b5a8c7f06cfb758ec6708a10b8fd97cb3f35acdfc4", "relations": [{"rule": 2, "type": "equivalent", "target": "0077b71b1a112508522b6344a237e809", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "92b2e5bb9d07607656f3c8b5a8c7f06cfb758ec6708a10b8fd97cb3f35acdfc4"}}, {"rule": 2, "type": "equivalent", "target": "ecaa09538553f74070da8438db8e8b6b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "92b2e5bb9d07607656f3c8b5a8c7f06cfb758ec6708a10b8fd97cb3f35acdfc4"}}], "version": "9.5.7", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "0077b71b1a112508522b6344a237e809", "kind": "equivalent", "version": "9.6.3", "label": "9.6.3", "title": "Fix integer-overflow problems in interval comparison", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "92b2e5bb9d07607656f3c8b5a8c7f06cfb758ec6708a10b8fd97cb3f35acdfc4"}, "url": "/docs/compare/?release=9.6.3#9.6.3-e207493ed9ad3365", "source_url": "/docs/release/9.6.3/#AEN135466"}, {"db_id": "ecaa09538553f74070da8438db8e8b6b", "kind": "equivalent", "version": "9.4.12", "label": "9.4.12", "title": "Fix integer-overflow problems in interval comparison", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "92b2e5bb9d07607656f3c8b5a8c7f06cfb758ec6708a10b8fd97cb3f35acdfc4"}, "url": "/docs/compare/?release=9.4.12#9.4.12-e207493ed9ad3365", "source_url": "/docs/release/9.4.12/#AEN121715"}]}, {"id": "9.5.7-1c78b5dbf5d29389", "cves": [], "html": "Fix cursor_to_xml() to produce valid output with tableforest = false (Thomas Munro, Peter Eisentraut)
Previously it failed to produce a wrapping <table> element.
", "text": "Fix cursor_to_xml() to produce valid output with tableforest = false (Thomas Munro, Peter Eisentraut) Previously it failed to produce a wrapping