A dump/restore is not required for those running 9.0.X.
\nHowever, if you are upgrading from a version earlier than 9.0.15, see Section E.9.
", "compatibility_count": 0, "label": "9.0.16", "status_label": "Historical", "eol": "2015-10-08", "age_days": 4604, "support_days": -4009}, "groups": [{"date": "2014-02-20", "build": "9.0.16", "major": "9.0", "minor": 16, "manual": "9.0", "status": "stable", "doc_git": "", "version": "9.0.16", "eol_date": "2015-10-08", "date_text": "2014-02-20", "supported": false, "manual_url": "/docs/9.0/release-9-0-16.html", "source_url": "/docs/release/9.0.16/", "entry_count": 37, "placeholder": false, "content_hash": "1b146bec092a2d93635e9c010ca7331f54c440b351635e85eb3b9756a24386a2", "manual_build": "9.0.23", "source_as_of": "", "changes_count": 37, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 9.0.X.
\nHowever, if you are upgrading from a version earlier than 9.0.15, see Section E.9.
", "compatibility_count": 0, "label": "9.0.16", "status_label": "Historical", "eol": "2015-10-08", "age_days": 4604, "support_days": -4009, "entries": [{"id": "9.0.16-e857ea6f6fa04038", "cves": ["CVE-2014-0060"], "html": "Shore up GRANT ... WITH ADMIN OPTION restrictions (Noah Misch)
\nGranting a role without ADMIN OPTION is supposed to prevent the grantee from adding or removing members from the granted role, but this restriction was easily bypassed by doing SET ROLE first. The security impact is mostly that a role member can revoke the access of others, contrary to the wishes of his grantor. Unapproved role member additions are a lesser concern, since an uncooperative role member could provide most of his rights to others anyway by creating views or SECURITY DEFINER functions. (CVE-2014-0060)
", "text": "Shore up GRANT ... WITH ADMIN OPTION restrictions (Noah Misch) Granting a role without ADMIN OPTION is supposed to prevent the grantee from adding or removing members from the granted role, but this restriction was easily bypassed by doing SET ROLE first. The security impact is mostly that a role member can revoke the access of others, contrary to the wishes of his grantor. Unapproved role member additions are a lesser concern, since an uncooperative role member could provide most of his rights to others anyway by creating views or SECURITY DEFINER functions. (CVE-2014-0060)", "title": "Shore up GRANT ... WITH ADMIN OPTION restrictions", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "6e37955c412d5e32a5769e3aad865f9e898e71305a81acc6327876eb0bdd1298", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Shore up GRANT ... WITH ADMIN OPTION restrictions (Noah Misch) Granting a role without ADMIN OPTION is supposed to prevent the grantee from adding or removing members from the granted role, but this restriction was easily bypassed by doing SET ROLE first. The security impact is mostly that a role member can revoke the access of others, contrary to the wishes of his grantor. Unapproved role member additions are a lesser concern, since an uncooperative role member could provide most of his rights to others anyway by creating views or SECURITY DEFINER functions. (CVE-2014-0060)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/001", "db_id": "39a7228bd3692113e40d80fa360dd96f", "patch_ids": [], "statement_hash": "f7bebec02491fcbdc7bad593125aae51e83540358514e357ec791b9f99f7db0c", "relations": [{"rule": 2, "type": "equivalent", "target": "8fed47c81bc13e310ce60e63b82d3369", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f7bebec02491fcbdc7bad593125aae51e83540358514e357ec791b9f99f7db0c"}}, {"rule": 2, "type": "equivalent", "target": "a0af19377a8f08e1c41168da3bfc8ec2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f7bebec02491fcbdc7bad593125aae51e83540358514e357ec791b9f99f7db0c"}}, {"rule": 2, "type": "equivalent", "target": "eb9eca640834341acf49af39f8eb5e82", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f7bebec02491fcbdc7bad593125aae51e83540358514e357ec791b9f99f7db0c"}}], "version": "9.0.16", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "a0af19377a8f08e1c41168da3bfc8ec2", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Shore up GRANT ... WITH ADMIN OPTION restrictions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f7bebec02491fcbdc7bad593125aae51e83540358514e357ec791b9f99f7db0c"}, "url": "/docs/compare/?release=9.3.3#9.3.3-e857ea6f6fa04038", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "eb9eca640834341acf49af39f8eb5e82", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Shore up GRANT ... WITH ADMIN OPTION restrictions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f7bebec02491fcbdc7bad593125aae51e83540358514e357ec791b9f99f7db0c"}, "url": "/docs/compare/?release=9.2.7#9.2.7-e857ea6f6fa04038", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "8fed47c81bc13e310ce60e63b82d3369", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Shore up GRANT ... WITH ADMIN OPTION restrictions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f7bebec02491fcbdc7bad593125aae51e83540358514e357ec791b9f99f7db0c"}, "url": "/docs/compare/?release=9.1.12#9.1.12-e857ea6f6fa04038", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-2fc0b7d428d533d3", "cves": ["CVE-2014-0061"], "html": "Prevent privilege escalation via manual calls to PL validator functions (Andres Freund)
\nThe primary role of PL validator functions is to be called implicitly during CREATE FUNCTION, but they are also normal SQL functions that a user can call explicitly. Calling a validator on a function actually written in some other language was not checked for and could be exploited for privilege-escalation purposes. The fix involves adding a call to a privilege-checking function in each validator function. Non-core procedural languages will also need to make this change to their own validator functions, if any. (CVE-2014-0061)
", "text": "Prevent privilege escalation via manual calls to PL validator functions (Andres Freund) The primary role of PL validator functions is to be called implicitly during CREATE FUNCTION, but they are also normal SQL functions that a user can call explicitly. Calling a validator on a function actually written in some other language was not checked for and could be exploited for privilege-escalation purposes. The fix involves adding a call to a privilege-checking function in each validator function. Non-core procedural languages will also need to make this change to their own validator functions, if any. (CVE-2014-0061)", "title": "Prevent privilege escalation via manual calls to PL validator functions", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "996f7829e9a5f62bf0f9cd98987d27d06cbdef4f3f01686ac09857f1a68851f4", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent privilege escalation via manual calls to PL validator functions (Andres Freund) The primary role of PL validator functions is to be called implicitly during CREATE FUNCTION, but they are also normal SQL functions that a user can call explicitly. Calling a validator on a function actually written in some other language was not checked for and could be exploited for privilege-escalation purposes. The fix involves adding a call to a privilege-checking function in each validator function. Non-core procedural languages will also need to make this change to their own validator functions, if any. (CVE-2014-0061)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/002", "db_id": "a9eb85599c0056790df203d46916a55a", "patch_ids": [], "statement_hash": "0915aa97bb0ab1d084da3321757774f67d891a07994d322682ceafe994ccb8db", "relations": [{"rule": 2, "type": "equivalent", "target": "02c1da92f538c5c6ea8ef875af38da59", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0915aa97bb0ab1d084da3321757774f67d891a07994d322682ceafe994ccb8db"}}, {"rule": 2, "type": "equivalent", "target": "95e3f5c8f5cd2edeccb1fb4455fee2da", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0915aa97bb0ab1d084da3321757774f67d891a07994d322682ceafe994ccb8db"}}, {"rule": 2, "type": "equivalent", "target": "fae61d73481179b6c74904102e9e2d86", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0915aa97bb0ab1d084da3321757774f67d891a07994d322682ceafe994ccb8db"}}], "version": "9.0.16", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "95e3f5c8f5cd2edeccb1fb4455fee2da", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Prevent privilege escalation via manual calls to PL validator functions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0915aa97bb0ab1d084da3321757774f67d891a07994d322682ceafe994ccb8db"}, "url": "/docs/compare/?release=9.3.3#9.3.3-2fc0b7d428d533d3", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "fae61d73481179b6c74904102e9e2d86", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Prevent privilege escalation via manual calls to PL validator functions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0915aa97bb0ab1d084da3321757774f67d891a07994d322682ceafe994ccb8db"}, "url": "/docs/compare/?release=9.2.7#9.2.7-2fc0b7d428d533d3", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "02c1da92f538c5c6ea8ef875af38da59", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Prevent privilege escalation via manual calls to PL validator functions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0915aa97bb0ab1d084da3321757774f67d891a07994d322682ceafe994ccb8db"}, "url": "/docs/compare/?release=9.1.12#9.1.12-2fc0b7d428d533d3", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-2914e7f60fc5c97d", "cves": ["CVE-2014-0062"], "html": "Avoid multiple name lookups during table and index DDL (Robert Haas, Andres Freund)
\nIf the name lookups come to different conclusions due to concurrent activity, we might perform some parts of the DDL on a different table than other parts. At least in the case of CREATE INDEX, this can be used to cause the permissions checks to be performed against a different table than the index creation, allowing for a privilege escalation attack. (CVE-2014-0062)
", "text": "Avoid multiple name lookups during table and index DDL (Robert Haas, Andres Freund) If the name lookups come to different conclusions due to concurrent activity, we might perform some parts of the DDL on a different table than other parts. At least in the case of CREATE INDEX, this can be used to cause the permissions checks to be performed against a different table than the index creation, allowing for a privilege escalation attack. (CVE-2014-0062)", "title": "Avoid multiple name lookups during table and index DDL", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "93deea8759038475a1db343860970300dcde0b0cc3a3d8000fbd41089dda6c4a", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid multiple name lookups during table and index DDL (Robert Haas, Andres Freund) If the name lookups come to different conclusions due to concurrent activity, we might perform some parts of the DDL on a different table than other parts. At least in the case of CREATE INDEX, this can be used to cause the permissions checks to be performed against a different table than the index creation, allowing for a privilege escalation attack. (CVE-2014-0062)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/003", "db_id": "f475983d0e117e81b5004e5573ac47a6", "patch_ids": [], "statement_hash": "dfc601d12769c86b1920b43ba7b4e414f01329425c25d55c38671a325df50f70", "relations": [{"rule": 2, "type": "equivalent", "target": "2c79866e4eaa6e21ca64fcf166ffbe34", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dfc601d12769c86b1920b43ba7b4e414f01329425c25d55c38671a325df50f70"}}, {"rule": 2, "type": "equivalent", "target": "86482abe5b27ee8f0d69a73a4dbcf5b8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dfc601d12769c86b1920b43ba7b4e414f01329425c25d55c38671a325df50f70"}}, {"rule": 2, "type": "equivalent", "target": "8e317c93dde468d19fb18a404e9d1206", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dfc601d12769c86b1920b43ba7b4e414f01329425c25d55c38671a325df50f70"}}], "version": "9.0.16", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "2c79866e4eaa6e21ca64fcf166ffbe34", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Avoid multiple name lookups during table and index DDL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dfc601d12769c86b1920b43ba7b4e414f01329425c25d55c38671a325df50f70"}, "url": "/docs/compare/?release=9.3.3#9.3.3-2914e7f60fc5c97d", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "86482abe5b27ee8f0d69a73a4dbcf5b8", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Avoid multiple name lookups during table and index DDL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dfc601d12769c86b1920b43ba7b4e414f01329425c25d55c38671a325df50f70"}, "url": "/docs/compare/?release=9.2.7#9.2.7-2914e7f60fc5c97d", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "8e317c93dde468d19fb18a404e9d1206", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Avoid multiple name lookups during table and index DDL", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dfc601d12769c86b1920b43ba7b4e414f01329425c25d55c38671a325df50f70"}, "url": "/docs/compare/?release=9.1.12#9.1.12-2914e7f60fc5c97d", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-5dff397c1ceafc97", "cves": ["CVE-2014-0063"], "html": "Prevent buffer overrun with long datetime strings (Noah Misch)
\nThe MAXDATELEN constant was too small for the longest possible value of type interval, allowing a buffer overrun in interval_out(). Although the datetime input functions were more careful about avoiding buffer overrun, the limit was short enough to cause them to reject some valid inputs, such as input containing a very long timezone name. The ecpg library contained these vulnerabilities along with some of its own. (CVE-2014-0063)
Prevent buffer overrun due to integer overflow in size calculations (Noah Misch, Heikki Linnakangas)
\nSeveral functions, mostly type input functions, calculated an allocation size without checking for overflow. If overflow did occur, a too-small buffer would be allocated and then written past. (CVE-2014-0064)
", "text": "Prevent buffer overrun due to integer overflow in size calculations (Noah Misch, Heikki Linnakangas) Several functions, mostly type input functions, calculated an allocation size without checking for overflow. If overflow did occur, a too-small buffer would be allocated and then written past. (CVE-2014-0064)", "title": "Prevent buffer overrun due to integer overflow in size calculations", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "041d07edca033259e1a23c7631e7e09f3016916b36560523c331786a069df5aa", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent buffer overrun due to integer overflow in size calculations (Noah Misch, Heikki Linnakangas) Several functions, mostly type input functions, calculated an allocation size without checking for overflow. If overflow did occur, a too-small buffer would be allocated and then written past. (CVE-2014-0064)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/005", "db_id": "b61e618ef531b83260a118f3e710803e", "patch_ids": [], "statement_hash": "5bd006f6697a46f251e3d72483969d0651f8a27b0d7a508b704923f5afec00ac", "relations": [{"rule": 2, "type": "equivalent", "target": "524ce52e603c56d2b6d29ce8bd8554ce", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5bd006f6697a46f251e3d72483969d0651f8a27b0d7a508b704923f5afec00ac"}}, {"rule": 2, "type": "equivalent", "target": "ab9fc7f01fa6040e520b53dbe02bf539", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5bd006f6697a46f251e3d72483969d0651f8a27b0d7a508b704923f5afec00ac"}}, {"rule": 2, "type": "equivalent", "target": "b037db4e2b1ee88e92ccf73cddee5112", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5bd006f6697a46f251e3d72483969d0651f8a27b0d7a508b704923f5afec00ac"}}], "version": "9.0.16", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "b037db4e2b1ee88e92ccf73cddee5112", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Prevent buffer overrun due to integer overflow in size calculations", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5bd006f6697a46f251e3d72483969d0651f8a27b0d7a508b704923f5afec00ac"}, "url": "/docs/compare/?release=9.3.3#9.3.3-24d3bb193a2364aa", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "524ce52e603c56d2b6d29ce8bd8554ce", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Prevent buffer overrun due to integer overflow in size calculations", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5bd006f6697a46f251e3d72483969d0651f8a27b0d7a508b704923f5afec00ac"}, "url": "/docs/compare/?release=9.2.7#9.2.7-24d3bb193a2364aa", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "ab9fc7f01fa6040e520b53dbe02bf539", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Prevent buffer overrun due to integer overflow in size calculations", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5bd006f6697a46f251e3d72483969d0651f8a27b0d7a508b704923f5afec00ac"}, "url": "/docs/compare/?release=9.1.12#9.1.12-24d3bb193a2364aa", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-617a2ec0a45a211b", "cves": ["CVE-2014-0065"], "html": "Prevent overruns of fixed-size buffers (Peter Eisentraut, Jozef Mlich)
\nUse strlcpy() and related functions to provide a clear guarantee that fixed-size buffers are not overrun. Unlike the preceding items, it is unclear whether these cases really represent live issues, since in most cases there appear to be previous constraints on the size of the input string. Nonetheless it seems prudent to silence all Coverity warnings of this type. (CVE-2014-0065)
Avoid crashing if crypt() returns NULL (Honza Horak, Bruce Momjian)
There are relatively few scenarios in which crypt() could return NULL, but contrib/chkpass would crash if it did. One practical case in which this could be an issue is if libc is configured to refuse to execute unapproved hashing algorithms (e.g., \"FIPS mode\"). (CVE-2014-0066)
Document risks of make check in the regression testing instructions (Noah Misch, Tom Lane)
\nSince the temporary server started by make check uses \"trust\" authentication, another user on the same machine could connect to it as database superuser, and then potentially exploit the privileges of the operating-system user who started the tests. A future release will probably incorporate changes in the testing procedure to prevent this risk, but some public discussion is needed first. So for the moment, just warn people against using make check when there are untrusted users on the same machine. (CVE-2014-0067)
", "text": "Document risks of make check in the regression testing instructions (Noah Misch, Tom Lane) Since the temporary server started by make check uses \"trust\" authentication, another user on the same machine could connect to it as database superuser, and then potentially exploit the privileges of the operating-system user who started the tests. A future release will probably incorporate changes in the testing procedure to prevent this risk, but some public discussion is needed first. So for the moment, just warn people against using make check when there are untrusted users on the same machine. (CVE-2014-0067)", "title": "Document risks of make check in the regression testing instructions", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "58f7fde8d209eeeb6dcff660292b11b60b6b5e0db58ad59490be114f3d497835", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Document risks of make check in the regression testing instructions (Noah Misch, Tom Lane) Since the temporary server started by make check uses trust authentication, another user on the same machine could connect to it as database superuser, and then potentially exploit the privileges of the operating-system user who started the tests. A future release will probably incorporate changes in the testing procedure to prevent this risk, but some public discussion is needed first. So for the moment, just warn people against using make check when there are untrusted users on the same machine. (CVE-2014-0067)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/008", "db_id": "1de82313af07dfbea3232d47d8ab78b1", "patch_ids": [], "statement_hash": "b1600cf50fe189145e8ef8dcc67fae6e6908511e41948d9e41ee5f3eac78c342", "relations": [{"rule": 2, "type": "equivalent", "target": "1fc7ca6d4d85f594eed0141b6b08fef5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b1600cf50fe189145e8ef8dcc67fae6e6908511e41948d9e41ee5f3eac78c342"}}, {"rule": 2, "type": "equivalent", "target": "8152bce71f31ab46c9501acebe8824b1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b1600cf50fe189145e8ef8dcc67fae6e6908511e41948d9e41ee5f3eac78c342"}}, {"rule": 2, "type": "equivalent", "target": "d832db97db43a8964c530c6f3561fa82", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b1600cf50fe189145e8ef8dcc67fae6e6908511e41948d9e41ee5f3eac78c342"}}], "version": "9.0.16", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "1fc7ca6d4d85f594eed0141b6b08fef5", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Document risks of make check in the regression testing instructions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b1600cf50fe189145e8ef8dcc67fae6e6908511e41948d9e41ee5f3eac78c342"}, "url": "/docs/compare/?release=9.3.3#9.3.3-e0182ff4c36dae37", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "8152bce71f31ab46c9501acebe8824b1", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Document risks of make check in the regression testing instructions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b1600cf50fe189145e8ef8dcc67fae6e6908511e41948d9e41ee5f3eac78c342"}, "url": "/docs/compare/?release=9.2.7#9.2.7-e0182ff4c36dae37", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "d832db97db43a8964c530c6f3561fa82", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Document risks of make check in the regression testing instructions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b1600cf50fe189145e8ef8dcc67fae6e6908511e41948d9e41ee5f3eac78c342"}, "url": "/docs/compare/?release=9.1.12#9.1.12-e0182ff4c36dae37", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-48cfe431a003ea84", "cves": [], "html": "Fix possible mis-replay of WAL records when some segments of a relation aren't full size (Greg Stark, Tom Lane)
\nThe WAL update could be applied to the wrong page, potentially many pages past where it should have been. Aside from corrupting data, this error has been observed to result in significant \"bloat\" of standby servers compared to their masters, due to updates being applied far beyond where the end-of-file should have been. This failure mode does not appear to be a significant risk during crash recovery, only when initially synchronizing a standby created from a base backup taken from a quickly-changing master.
", "text": "Fix possible mis-replay of WAL records when some segments of a relation aren't full size (Greg Stark, Tom Lane) The WAL update could be applied to the wrong page, potentially many pages past where it should have been. Aside from corrupting data, this error has been observed to result in significant \"bloat\" of standby servers compared to their masters, due to updates being applied far beyond where the end-of-file should have been. This failure mode does not appear to be a significant risk during crash recovery, only when initially synchronizing a standby created from a base backup taken from a quickly-changing master.", "title": "Fix possible mis-replay of WAL records when some segments of a relation aren't full size", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "67da68ededb4274d5005277f690d441d145fbca2820fe70a583da788d40a5014", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix possible mis-replay of WAL records when some segments of a relation aren't full size (Greg Stark, Tom Lane) The WAL update could be applied to the wrong page, potentially many pages past where it should have been. Aside from corrupting data, this error has been observed to result in significant bloat of standby servers compared to their masters, due to updates being applied far beyond where the end-of-file should have been. This failure mode does not appear to be a significant risk during crash recovery, only when initially synchronizing a standby created from a base backup taken from a quickly-changing master.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/009", "db_id": "6a64aabe3f3ed8e232a5d6564458bbf0", "patch_ids": [], "statement_hash": "5fa863dcde2a1d7341f36113f83ccf1ab25fb8fdfa8473169a331d534819dff5", "relations": [{"rule": 2, "type": "equivalent", "target": "25de053281805a245fab1b676779dcc4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5fa863dcde2a1d7341f36113f83ccf1ab25fb8fdfa8473169a331d534819dff5"}}, {"rule": 2, "type": "equivalent", "target": "2b001c634d577b177a7b6908f8431b7e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5fa863dcde2a1d7341f36113f83ccf1ab25fb8fdfa8473169a331d534819dff5"}}, {"rule": 2, "type": "equivalent", "target": "3e5bf72839871f5d922463c0b0ae582c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5fa863dcde2a1d7341f36113f83ccf1ab25fb8fdfa8473169a331d534819dff5"}}], "version": "9.0.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "25de053281805a245fab1b676779dcc4", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Fix possible mis-replay of WAL records when some segments of a relation aren't full size", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5fa863dcde2a1d7341f36113f83ccf1ab25fb8fdfa8473169a331d534819dff5"}, "url": "/docs/compare/?release=9.3.3#9.3.3-48cfe431a003ea84", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "2b001c634d577b177a7b6908f8431b7e", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Fix possible mis-replay of WAL records when some segments of a relation aren't full size", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5fa863dcde2a1d7341f36113f83ccf1ab25fb8fdfa8473169a331d534819dff5"}, "url": "/docs/compare/?release=9.2.7#9.2.7-48cfe431a003ea84", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "3e5bf72839871f5d922463c0b0ae582c", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Fix possible mis-replay of WAL records when some segments of a relation aren't full size", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5fa863dcde2a1d7341f36113f83ccf1ab25fb8fdfa8473169a331d534819dff5"}, "url": "/docs/compare/?release=9.1.12#9.1.12-48cfe431a003ea84", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-383abeea75ceab3c", "cves": [], "html": "Fix bug in determining when recovery has reached consistency (Tomonari Katsumata, Heikki Linnakangas)
\nIn some cases WAL replay would mistakenly conclude that the database was already consistent at the start of replay, thus possibly allowing hot-standby queries before the database was really consistent. Other symptoms such as \"PANIC: WAL contains references to invalid pages\" were also possible.
", "text": "Fix bug in determining when recovery has reached consistency (Tomonari Katsumata, Heikki Linnakangas) In some cases WAL replay would mistakenly conclude that the database was already consistent at the start of replay, thus possibly allowing hot-standby queries before the database was really consistent. Other symptoms such as \"PANIC: WAL contains references to invalid pages\" were also possible.", "title": "Fix bug in determining when recovery has reached consistency", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "f97a0e69bebd2f647bdbfd81a857b534b0a5647167f4f9c213c624983aee0a71", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix bug in determining when recovery has reached consistency (Tomonari Katsumata, Heikki Linnakangas) In some cases WAL replay would mistakenly conclude that the database was already consistent at the start of replay, thus possibly allowing hot-standby queries before the database was really consistent. Other symptoms such as PANIC: WAL contains references to invalid pages were also possible.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/010", "db_id": "0cda2f81c3b66f79b7213d869e10179f", "patch_ids": [], "statement_hash": "fcc6e5bdcc8b0fe8fe62ec3a44d6cf60b5c79d95f6168601d922f962078f1a07", "relations": [{"rule": 2, "type": "equivalent", "target": "0ff932aeacb12930c82887b483ca71f4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fcc6e5bdcc8b0fe8fe62ec3a44d6cf60b5c79d95f6168601d922f962078f1a07"}}, {"rule": 2, "type": "equivalent", "target": "a73b9eb084d1c6ae8789d3f1839e3542", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fcc6e5bdcc8b0fe8fe62ec3a44d6cf60b5c79d95f6168601d922f962078f1a07"}}, {"rule": 2, "type": "equivalent", "target": "e27ff0865920d9d12031284f043fc2ec", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fcc6e5bdcc8b0fe8fe62ec3a44d6cf60b5c79d95f6168601d922f962078f1a07"}}], "version": "9.0.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "a73b9eb084d1c6ae8789d3f1839e3542", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Fix bug in determining when recovery has reached consistency", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fcc6e5bdcc8b0fe8fe62ec3a44d6cf60b5c79d95f6168601d922f962078f1a07"}, "url": "/docs/compare/?release=9.3.3#9.3.3-383abeea75ceab3c", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "e27ff0865920d9d12031284f043fc2ec", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Fix bug in determining when recovery has reached consistency", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fcc6e5bdcc8b0fe8fe62ec3a44d6cf60b5c79d95f6168601d922f962078f1a07"}, "url": "/docs/compare/?release=9.2.7#9.2.7-383abeea75ceab3c", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "0ff932aeacb12930c82887b483ca71f4", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Fix bug in determining when recovery has reached consistency", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fcc6e5bdcc8b0fe8fe62ec3a44d6cf60b5c79d95f6168601d922f962078f1a07"}, "url": "/docs/compare/?release=9.1.12#9.1.12-383abeea75ceab3c", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-6c02101b4b383a92", "cves": [], "html": "Fix improper locking of btree index pages while replaying a VACUUM operation in hot-standby mode (Andres Freund, Heikki Linnakangas, Tom Lane)
\nThis error could result in \"PANIC: WAL contains references to invalid pages\" failures.
", "text": "Fix improper locking of btree index pages while replaying a VACUUM operation in hot-standby mode (Andres Freund, Heikki Linnakangas, Tom Lane) This error could result in \"PANIC: WAL contains references to invalid pages\" failures.", "title": "Fix improper locking of btree index pages while replaying a VACUUM operation in hot-standby mode", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "d787c4fafcac3eb72b3e53d10a3f621e0915911b193b24630cee5118b32c6ad1", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix improper locking of btree index pages while replaying a VACUUM operation in hot-standby mode (Andres Freund, Heikki Linnakangas, Tom Lane) This error could result in PANIC: WAL contains references to invalid pages failures.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/011", "db_id": "bc3b5b9193580c289a2ddef968dfdb5e", "patch_ids": [], "statement_hash": "fa03b39766d5e4dd2f01e26c65a65c85330255de67f43dbf335d1c727bac9a55", "relations": [{"rule": 2, "type": "equivalent", "target": "267ea97c36ade4e7c3f07d9bcf5f6b19", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fa03b39766d5e4dd2f01e26c65a65c85330255de67f43dbf335d1c727bac9a55"}}, {"rule": 2, "type": "equivalent", "target": "591dd475baa8f6028925cb450d25c233", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fa03b39766d5e4dd2f01e26c65a65c85330255de67f43dbf335d1c727bac9a55"}}, {"rule": 2, "type": "equivalent", "target": "c7a8558d89c20ffa25ace74deb3a2c98", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fa03b39766d5e4dd2f01e26c65a65c85330255de67f43dbf335d1c727bac9a55"}}], "version": "9.0.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "591dd475baa8f6028925cb450d25c233", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Fix improper locking of btree index pages while replaying a VACUUM operation in hot-standby mode", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fa03b39766d5e4dd2f01e26c65a65c85330255de67f43dbf335d1c727bac9a55"}, "url": "/docs/compare/?release=9.3.3#9.3.3-6c02101b4b383a92", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "c7a8558d89c20ffa25ace74deb3a2c98", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Fix improper locking of btree index pages while replaying a VACUUM operation in hot-standby mode", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fa03b39766d5e4dd2f01e26c65a65c85330255de67f43dbf335d1c727bac9a55"}, "url": "/docs/compare/?release=9.2.7#9.2.7-6c02101b4b383a92", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "267ea97c36ade4e7c3f07d9bcf5f6b19", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Fix improper locking of btree index pages while replaying a VACUUM operation in hot-standby mode", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fa03b39766d5e4dd2f01e26c65a65c85330255de67f43dbf335d1c727bac9a55"}, "url": "/docs/compare/?release=9.1.12#9.1.12-6c02101b4b383a92", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-9cfb98a0e5aa7de6", "cves": [], "html": "Ensure that insertions into non-leaf GIN index pages write a full-page WAL record when appropriate (Heikki Linnakangas)
\nThe previous coding risked index corruption in the event of a partial-page write during a system crash.
", "text": "Ensure that insertions into non-leaf GIN index pages write a full-page WAL record when appropriate (Heikki Linnakangas) The previous coding risked index corruption in the event of a partial-page write during a system crash.", "title": "Ensure that insertions into non-leaf GIN index pages write a full-page WAL record when appropriate", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "7d9420d051fe88e17432dbd6318eeb46d42ec0d69cef185c15c55480a1855559", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ensure that insertions into non-leaf GIN index pages write a full-page WAL record when appropriate (Heikki Linnakangas) The previous coding risked index corruption in the event of a partial-page write during a system crash.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/012", "db_id": "2eff690870453ffcdb7349755715b1aa", "patch_ids": [], "statement_hash": "9d828353466006a075a041525d37c2813faee5d9019dcbde79e954c56062a379", "relations": [{"rule": 2, "type": "equivalent", "target": "6534a8a826b2471118bd1a76206cbef0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d828353466006a075a041525d37c2813faee5d9019dcbde79e954c56062a379"}}, {"rule": 2, "type": "equivalent", "target": "76061ba322a8049243f49879f7e82f05", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d828353466006a075a041525d37c2813faee5d9019dcbde79e954c56062a379"}}, {"rule": 2, "type": "equivalent", "target": "cb26e8d99d2182f4549767cb9f38a4d5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d828353466006a075a041525d37c2813faee5d9019dcbde79e954c56062a379"}}], "version": "9.0.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "cb26e8d99d2182f4549767cb9f38a4d5", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Ensure that insertions into non-leaf GIN index pages write a full-page WAL record when appropriate", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d828353466006a075a041525d37c2813faee5d9019dcbde79e954c56062a379"}, "url": "/docs/compare/?release=9.3.3#9.3.3-9cfb98a0e5aa7de6", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "6534a8a826b2471118bd1a76206cbef0", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Ensure that insertions into non-leaf GIN index pages write a full-page WAL record when appropriate", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d828353466006a075a041525d37c2813faee5d9019dcbde79e954c56062a379"}, "url": "/docs/compare/?release=9.2.7#9.2.7-9cfb98a0e5aa7de6", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "76061ba322a8049243f49879f7e82f05", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Ensure that insertions into non-leaf GIN index pages write a full-page WAL record when appropriate", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d828353466006a075a041525d37c2813faee5d9019dcbde79e954c56062a379"}, "url": "/docs/compare/?release=9.1.12#9.1.12-9cfb98a0e5aa7de6", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-f2748170aafabc37", "cves": [], "html": "Fix race conditions during server process exit (Robert Haas)
\nEnsure that signal handlers don't attempt to use the process's MyProc pointer after it's no longer valid.
", "text": "Fix race conditions during server process exit (Robert Haas) Ensure that signal handlers don't attempt to use the process's MyProc pointer after it's no longer valid.", "title": "Fix race conditions during server process exit", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "ad3f8ce4fcc8fdb33d6b94bcbfe14345132bd1f31c2e9ed59b1f5fdc0af241ab", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix race conditions during server process exit (Robert Haas) Ensure that signal handlers don't attempt to use the process's MyProc pointer after it's no longer valid.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/013", "db_id": "2253a5527cd74ada04357261a28c088d", "patch_ids": [], "statement_hash": "e22a497e4f71c9e4081f57bad6c0f2317e85783324a5ccfdec0d7862534cf66f", "relations": [{"rule": 2, "type": "equivalent", "target": "1e1a787c2b2075910db8d64413d2429b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e22a497e4f71c9e4081f57bad6c0f2317e85783324a5ccfdec0d7862534cf66f"}}, {"rule": 2, "type": "equivalent", "target": "902b0f0f92d250a77926a1cb90366ad7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e22a497e4f71c9e4081f57bad6c0f2317e85783324a5ccfdec0d7862534cf66f"}}, {"rule": 2, "type": "equivalent", "target": "f69dda79e5a071672a7388442daca1bb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e22a497e4f71c9e4081f57bad6c0f2317e85783324a5ccfdec0d7862534cf66f"}}], "version": "9.0.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "1e1a787c2b2075910db8d64413d2429b", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Fix race conditions during server process exit", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e22a497e4f71c9e4081f57bad6c0f2317e85783324a5ccfdec0d7862534cf66f"}, "url": "/docs/compare/?release=9.3.3#9.3.3-f2748170aafabc37", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "902b0f0f92d250a77926a1cb90366ad7", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Fix race conditions during server process exit", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e22a497e4f71c9e4081f57bad6c0f2317e85783324a5ccfdec0d7862534cf66f"}, "url": "/docs/compare/?release=9.2.7#9.2.7-f2748170aafabc37", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "f69dda79e5a071672a7388442daca1bb", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Fix race conditions during server process exit", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e22a497e4f71c9e4081f57bad6c0f2317e85783324a5ccfdec0d7862534cf66f"}, "url": "/docs/compare/?release=9.1.12#9.1.12-f2748170aafabc37", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-75b9dfef93c0a900", "cves": [], "html": "Fix unsafe references to errno within error reporting logic (Christian Kruse)
\nThis would typically lead to odd behaviors such as missing or inappropriate HINT fields.
", "text": "Fix unsafe references to errno within error reporting logic (Christian Kruse) This would typically lead to odd behaviors such as missing or inappropriate HINT fields.", "title": "Fix unsafe references to errno within error reporting logic", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "caac25c70f7e301d4d2384ec0a408ae21eac194bb0d7919489123ee4c875a807", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix unsafe references to errno within error reporting logic (Christian Kruse) This would typically lead to odd behaviors such as missing or inappropriate HINT fields.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/014", "db_id": "7d0b30dd22b8070f126ec9141785cff7", "patch_ids": [], "statement_hash": "a6e7096815c0dd616d8c8a26d360cda6ce42d6b10fbbd80f22993f4eae95c51d", "relations": [{"rule": 2, "type": "equivalent", "target": "37b95577ed90367c94210a79984362d9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a6e7096815c0dd616d8c8a26d360cda6ce42d6b10fbbd80f22993f4eae95c51d"}}, {"rule": 2, "type": "equivalent", "target": "3e87d3f06c98ffe8bdeeefa70078a8bf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a6e7096815c0dd616d8c8a26d360cda6ce42d6b10fbbd80f22993f4eae95c51d"}}, {"rule": 2, "type": "equivalent", "target": "bc3f7584e4445525d6f45b7085bf401d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a6e7096815c0dd616d8c8a26d360cda6ce42d6b10fbbd80f22993f4eae95c51d"}}], "version": "9.0.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "37b95577ed90367c94210a79984362d9", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Fix unsafe references to errno within error reporting logic", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a6e7096815c0dd616d8c8a26d360cda6ce42d6b10fbbd80f22993f4eae95c51d"}, "url": "/docs/compare/?release=9.3.3#9.3.3-75b9dfef93c0a900", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "bc3f7584e4445525d6f45b7085bf401d", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Fix unsafe references to errno within error reporting logic", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a6e7096815c0dd616d8c8a26d360cda6ce42d6b10fbbd80f22993f4eae95c51d"}, "url": "/docs/compare/?release=9.2.7#9.2.7-75b9dfef93c0a900", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "3e87d3f06c98ffe8bdeeefa70078a8bf", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Fix unsafe references to errno within error reporting logic", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a6e7096815c0dd616d8c8a26d360cda6ce42d6b10fbbd80f22993f4eae95c51d"}, "url": "/docs/compare/?release=9.1.12#9.1.12-75b9dfef93c0a900", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-2bd55e8f752567f1", "cves": [], "html": "Fix possible crashes from using ereport() too early during server startup (Tom Lane)
The principal case we've seen in the field is a crash if the server is started in a directory it doesn't have permission to read.
", "text": "Fix possible crashes from using ereport() too early during server startup (Tom Lane) The principal case we've seen in the field is a crash if the server is started in a directory it doesn't have permission to read.", "title": "Fix possible crashes from using ereport() too early during server startup", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "5d0ce5580bf0d0e9e5829a5e398d19d2bec6d2857c8fb0f38b1e048d5ccacddb", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix possible crashes from using ereport() too early during server startup (Tom Lane) The principal case we've seen in the field is a crash if the server is started in a directory it doesn't have permission to read.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/015", "db_id": "f162a4f736bbc4a94390f9623f33f298", "patch_ids": [], "statement_hash": "c4b9b84f039a5a99a9daae8e6d4ab8cd02bca48e9deda6bf23002c6d835a4e18", "relations": [{"rule": 2, "type": "equivalent", "target": "4a16d4287f4ee8452465cd646d1fd781", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c4b9b84f039a5a99a9daae8e6d4ab8cd02bca48e9deda6bf23002c6d835a4e18"}}, {"rule": 2, "type": "equivalent", "target": "df3e479eecfd2500a93eff44e9e5ab59", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c4b9b84f039a5a99a9daae8e6d4ab8cd02bca48e9deda6bf23002c6d835a4e18"}}, {"rule": 2, "type": "equivalent", "target": "e6191c20bd057498459d068ab454d4d4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c4b9b84f039a5a99a9daae8e6d4ab8cd02bca48e9deda6bf23002c6d835a4e18"}}], "version": "9.0.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "df3e479eecfd2500a93eff44e9e5ab59", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Fix possible crashes from using ereport() too early during server startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c4b9b84f039a5a99a9daae8e6d4ab8cd02bca48e9deda6bf23002c6d835a4e18"}, "url": "/docs/compare/?release=9.3.3#9.3.3-2bd55e8f752567f1", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "4a16d4287f4ee8452465cd646d1fd781", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Fix possible crashes from using ereport() too early during server startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c4b9b84f039a5a99a9daae8e6d4ab8cd02bca48e9deda6bf23002c6d835a4e18"}, "url": "/docs/compare/?release=9.2.7#9.2.7-2bd55e8f752567f1", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "e6191c20bd057498459d068ab454d4d4", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Fix possible crashes from using ereport() too early during server startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c4b9b84f039a5a99a9daae8e6d4ab8cd02bca48e9deda6bf23002c6d835a4e18"}, "url": "/docs/compare/?release=9.1.12#9.1.12-2bd55e8f752567f1", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-e2e0b7535e8ea112", "cves": [], "html": "Clear retry flags properly in OpenSSL socket write function (Alexander Kukushkin)
\nThis omission could result in a server lockup after unexpected loss of an SSL-encrypted connection.
", "text": "Clear retry flags properly in OpenSSL socket write function (Alexander Kukushkin) This omission could result in a server lockup after unexpected loss of an SSL-encrypted connection.", "title": "Clear retry flags properly in OpenSSL socket write function", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "845345a5d1efdaee2d83ea1e3684a3de8b481c13775c2dab4864b5a0c8ce2dd9", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Clear retry flags properly in OpenSSL socket write function (Alexander Kukushkin) This omission could result in a server lockup after unexpected loss of an SSL-encrypted connection.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/016", "db_id": "941caa56d3c088d05a0927a7592abb33", "patch_ids": [], "statement_hash": "2108fafd4649cd4a43940fb84bb68314001285cbe39331fb36a2ae509a5be02a", "relations": [{"rule": 2, "type": "equivalent", "target": "0b007ab59ce736b143f3f709df9c5b30", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2108fafd4649cd4a43940fb84bb68314001285cbe39331fb36a2ae509a5be02a"}}, {"rule": 2, "type": "equivalent", "target": "11671fca978410389b3a726d8bea8852", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2108fafd4649cd4a43940fb84bb68314001285cbe39331fb36a2ae509a5be02a"}}, {"rule": 2, "type": "equivalent", "target": "8fef34044c53fb22630112ea37abb361", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2108fafd4649cd4a43940fb84bb68314001285cbe39331fb36a2ae509a5be02a"}}], "version": "9.0.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "11671fca978410389b3a726d8bea8852", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Clear retry flags properly in OpenSSL socket write function", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2108fafd4649cd4a43940fb84bb68314001285cbe39331fb36a2ae509a5be02a"}, "url": "/docs/compare/?release=9.3.3#9.3.3-e2e0b7535e8ea112", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "8fef34044c53fb22630112ea37abb361", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Clear retry flags properly in OpenSSL socket write function", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2108fafd4649cd4a43940fb84bb68314001285cbe39331fb36a2ae509a5be02a"}, "url": "/docs/compare/?release=9.2.7#9.2.7-e2e0b7535e8ea112", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "0b007ab59ce736b143f3f709df9c5b30", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Clear retry flags properly in OpenSSL socket write function", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2108fafd4649cd4a43940fb84bb68314001285cbe39331fb36a2ae509a5be02a"}, "url": "/docs/compare/?release=9.1.12#9.1.12-e2e0b7535e8ea112", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-23c483468b31b2aa", "cves": [], "html": "Fix length checking for Unicode identifiers (U&\"...\" syntax) containing escapes (Tom Lane)
\nA spurious truncation warning would be printed for such identifiers if the escaped form of the identifier was too long, but the identifier actually didn't need truncation after de-escaping.
", "text": "Fix length checking for Unicode identifiers (U&\"...\" syntax) containing escapes (Tom Lane) A spurious truncation warning would be printed for such identifiers if the escaped form of the identifier was too long, but the identifier actually didn't need truncation after de-escaping.", "title": "Fix length checking for Unicode identifiers (U&\"...\" syntax) containing escapes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "cf406dbc8a07c48d170f04f9bacc108069fa098ee265d9d1643248aabaa54aca", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix length checking for Unicode identifiers (U&\"...\" syntax) containing escapes (Tom Lane) A spurious truncation warning would be printed for such identifiers if the escaped form of the identifier was too long, but the identifier actually didn't need truncation after de-escaping.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/017", "db_id": "65740b7941f3e9b086e8907f001022fc", "patch_ids": [], "statement_hash": "249e8b492772c6d687ab8caae44093cbe50a88dca4bea22726c0b8fcf7b3c80a", "relations": [{"rule": 2, "type": "equivalent", "target": "42f4b233e4f166ead5bf69f9d022b760", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "249e8b492772c6d687ab8caae44093cbe50a88dca4bea22726c0b8fcf7b3c80a"}}, {"rule": 2, "type": "equivalent", "target": "c0c97674783fef61838fe77fe815ef47", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "249e8b492772c6d687ab8caae44093cbe50a88dca4bea22726c0b8fcf7b3c80a"}}, {"rule": 2, "type": "equivalent", "target": "f9b078f059a923d2bd5bd6cb576ab7fd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "249e8b492772c6d687ab8caae44093cbe50a88dca4bea22726c0b8fcf7b3c80a"}}], "version": "9.0.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "f9b078f059a923d2bd5bd6cb576ab7fd", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Fix length checking for Unicode identifiers (U&\"...\" syntax) containing escapes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "249e8b492772c6d687ab8caae44093cbe50a88dca4bea22726c0b8fcf7b3c80a"}, "url": "/docs/compare/?release=9.3.3#9.3.3-23c483468b31b2aa", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "c0c97674783fef61838fe77fe815ef47", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Fix length checking for Unicode identifiers (U&\"...\" syntax) containing escapes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "249e8b492772c6d687ab8caae44093cbe50a88dca4bea22726c0b8fcf7b3c80a"}, "url": "/docs/compare/?release=9.2.7#9.2.7-23c483468b31b2aa", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "42f4b233e4f166ead5bf69f9d022b760", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Fix length checking for Unicode identifiers (U&\"...\" syntax) containing escapes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "249e8b492772c6d687ab8caae44093cbe50a88dca4bea22726c0b8fcf7b3c80a"}, "url": "/docs/compare/?release=9.1.12#9.1.12-23c483468b31b2aa", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-02c5ebae76afcaa9", "cves": [], "html": "Allow keywords that are type names to be used in lists of roles (Stephen Frost)
\nA previous patch allowed such keywords to be used without quoting in places such as role identifiers; but it missed cases where a list of role identifiers was permitted, such as DROP ROLE.
", "text": "Allow keywords that are type names to be used in lists of roles (Stephen Frost) A previous patch allowed such keywords to be used without quoting in places such as role identifiers; but it missed cases where a list of role identifiers was permitted, such as DROP ROLE.", "title": "Allow keywords that are type names to be used in lists of roles", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "3422358a199d6c3c0f055ac6d81cf78eb7ef3839ddb980f8df92652e9d2075ae", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Allow keywords that are type names to be used in lists of roles (Stephen Frost) A previous patch allowed such keywords to be used without quoting in places such as role identifiers; but it missed cases where a list of role identifiers was permitted, such as DROP ROLE.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/018", "db_id": "5fd4ec2506ed6953d713694b1bfb2ef3", "patch_ids": [], "statement_hash": "6ba955916ebb9facdf35bdb2cafb3584e29164785f99d246aa446b3c476a0488", "relations": [{"rule": 2, "type": "equivalent", "target": "b669cceaac0688c3467ae4cc3bdfc5cf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6ba955916ebb9facdf35bdb2cafb3584e29164785f99d246aa446b3c476a0488"}}, {"rule": 2, "type": "equivalent", "target": "f7964e61818d714c7e0529b9e3c273df", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6ba955916ebb9facdf35bdb2cafb3584e29164785f99d246aa446b3c476a0488"}}, {"rule": 2, "type": "equivalent", "target": "facc82e0f268cb697ef0e460cb963a03", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6ba955916ebb9facdf35bdb2cafb3584e29164785f99d246aa446b3c476a0488"}}], "version": "9.0.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b669cceaac0688c3467ae4cc3bdfc5cf", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Allow keywords that are type names to be used in lists of roles", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6ba955916ebb9facdf35bdb2cafb3584e29164785f99d246aa446b3c476a0488"}, "url": "/docs/compare/?release=9.3.3#9.3.3-02c5ebae76afcaa9", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "facc82e0f268cb697ef0e460cb963a03", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Allow keywords that are type names to be used in lists of roles", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6ba955916ebb9facdf35bdb2cafb3584e29164785f99d246aa446b3c476a0488"}, "url": "/docs/compare/?release=9.2.7#9.2.7-02c5ebae76afcaa9", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "f7964e61818d714c7e0529b9e3c273df", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Allow keywords that are type names to be used in lists of roles", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6ba955916ebb9facdf35bdb2cafb3584e29164785f99d246aa446b3c476a0488"}, "url": "/docs/compare/?release=9.1.12#9.1.12-02c5ebae76afcaa9", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-c418cb4ac3d0d142", "cves": [], "html": "Fix possible crash due to invalid plan for nested sub-selects, such as WHERE (... x IN (SELECT ...) ...) IN (SELECT ...) (Tom Lane)
", "text": "Fix possible crash due to invalid plan for nested sub-selects, such as WHERE (... x IN (SELECT ...) ...) IN (SELECT ...) (Tom Lane)", "title": "Fix possible crash due to invalid plan for nested sub-selects, such as WHERE (... x IN (SELECT ...) ...) IN (SELECT ...)", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "62cef334d9707163a0c7e6b4f73534f10e60c719a8fb17a11a59b482fbcd3e75", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix possible crash due to invalid plan for nested sub-selects, such as WHERE (... x IN (SELECT ...) ...) IN (SELECT ...) (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/019", "db_id": "587a014707d18a9dfe4fcd7665f8ffae", "patch_ids": [], "statement_hash": "fbcaca3408ecf7bc9e81a9132fabaff24655b4499d3821dc327bb607b38a6606", "relations": [{"rule": 2, "type": "equivalent", "target": "3e1cf87c50929ba8621eacb7c7aa2815", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fbcaca3408ecf7bc9e81a9132fabaff24655b4499d3821dc327bb607b38a6606"}}, {"rule": 2, "type": "equivalent", "target": "4b54d1cbc23906d35a2c5cbb980cf685", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fbcaca3408ecf7bc9e81a9132fabaff24655b4499d3821dc327bb607b38a6606"}}, {"rule": 2, "type": "equivalent", "target": "c20e57bd97bb0aed81a85b2b4bb6fb2f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fbcaca3408ecf7bc9e81a9132fabaff24655b4499d3821dc327bb607b38a6606"}}], "version": "9.0.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "3e1cf87c50929ba8621eacb7c7aa2815", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Fix possible crash due to invalid plan for nested sub-selects, such as WHERE (... x IN (SELECT ...) ...) IN (SELECT ...)", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fbcaca3408ecf7bc9e81a9132fabaff24655b4499d3821dc327bb607b38a6606"}, "url": "/docs/compare/?release=9.3.3#9.3.3-c418cb4ac3d0d142", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "c20e57bd97bb0aed81a85b2b4bb6fb2f", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Fix possible crash due to invalid plan for nested sub-selects, such as WHERE (... x IN (SELECT ...) ...) IN (SELECT ...)", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fbcaca3408ecf7bc9e81a9132fabaff24655b4499d3821dc327bb607b38a6606"}, "url": "/docs/compare/?release=9.2.7#9.2.7-c418cb4ac3d0d142", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "4b54d1cbc23906d35a2c5cbb980cf685", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Fix possible crash due to invalid plan for nested sub-selects, such as WHERE (... x IN (SELECT ...) ...) IN (SELECT ...)", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fbcaca3408ecf7bc9e81a9132fabaff24655b4499d3821dc327bb607b38a6606"}, "url": "/docs/compare/?release=9.1.12#9.1.12-c418cb4ac3d0d142", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-475c0b7b0a62138a", "cves": [], "html": "Ensure that ANALYZE creates statistics for a table column even when all the values in it are \"too wide\" (Tom Lane)
\nANALYZE intentionally omits very wide values from its histogram and most-common-values calculations, but it neglected to do something sane in the case that all the sampled entries are too wide.
", "text": "Ensure that ANALYZE creates statistics for a table column even when all the values in it are \"too wide\" (Tom Lane) ANALYZE intentionally omits very wide values from its histogram and most-common-values calculations, but it neglected to do something sane in the case that all the sampled entries are too wide.", "title": "Ensure that ANALYZE creates statistics for a table column even when all the values in it are \"too wide\"", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "fc59333f31f1c5f6ebb654d73ad1e6f5610a47afad076778531e92abfdb7b654", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ensure that ANALYZE creates statistics for a table column even when all the values in it are too wide (Tom Lane) ANALYZE intentionally omits very wide values from its histogram and most-common-values calculations, but it neglected to do something sane in the case that all the sampled entries are too wide.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/020", "db_id": "e87f90c509b154f64680271a9e8604ff", "patch_ids": [], "statement_hash": "2ac10c14f9f8d5fe110b463afd1e86eb7ffcd3754b4ff42f64cc8fc9f34490e4", "relations": [{"rule": 2, "type": "equivalent", "target": "559a553c08451fe4dcfb5586f0f99e82", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2ac10c14f9f8d5fe110b463afd1e86eb7ffcd3754b4ff42f64cc8fc9f34490e4"}}, {"rule": 2, "type": "equivalent", "target": "75fe6c40b7de8f85e5877c5c28800ac9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2ac10c14f9f8d5fe110b463afd1e86eb7ffcd3754b4ff42f64cc8fc9f34490e4"}}, {"rule": 2, "type": "equivalent", "target": "f3695dd10fa7b17e2c880937788ec52b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2ac10c14f9f8d5fe110b463afd1e86eb7ffcd3754b4ff42f64cc8fc9f34490e4"}}], "version": "9.0.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f3695dd10fa7b17e2c880937788ec52b", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Ensure that ANALYZE creates statistics for a table column even when all the values in it are \"too wide\"", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2ac10c14f9f8d5fe110b463afd1e86eb7ffcd3754b4ff42f64cc8fc9f34490e4"}, "url": "/docs/compare/?release=9.3.3#9.3.3-475c0b7b0a62138a", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "559a553c08451fe4dcfb5586f0f99e82", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Ensure that ANALYZE creates statistics for a table column even when all the values in it are \"too wide\"", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2ac10c14f9f8d5fe110b463afd1e86eb7ffcd3754b4ff42f64cc8fc9f34490e4"}, "url": "/docs/compare/?release=9.2.7#9.2.7-475c0b7b0a62138a", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "75fe6c40b7de8f85e5877c5c28800ac9", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Ensure that ANALYZE creates statistics for a table column even when all the values in it are \"too wide\"", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2ac10c14f9f8d5fe110b463afd1e86eb7ffcd3754b4ff42f64cc8fc9f34490e4"}, "url": "/docs/compare/?release=9.1.12#9.1.12-475c0b7b0a62138a", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-c7f2cb08bdbf8d5d", "cves": [], "html": "In ALTER TABLE ... SET TABLESPACE, allow the database's default tablespace to be used without a permissions check (Stephen Frost)
\nCREATE TABLE has always allowed such usage, but ALTER TABLE didn't get the memo.
", "text": "In ALTER TABLE ... SET TABLESPACE, allow the database's default tablespace to be used without a permissions check (Stephen Frost) CREATE TABLE has always allowed such usage, but ALTER TABLE didn't get the memo.", "title": "In ALTER TABLE ... SET TABLESPACE, allow the database's default tablespace to be used without a permissions check", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "e7c7af828e141aeb095f8202e4760206ce58a87fc2740fb2616201e460f13bc1", "section_path": ["Changes"], "commit_groups": [], "identity_text": "In ALTER TABLE ... SET TABLESPACE, allow the database's default tablespace to be used without a permissions check (Stephen Frost) CREATE TABLE has always allowed such usage, but ALTER TABLE didn't get the memo.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/021", "db_id": "4d098fa538b4f461a0bf9de881e82ee6", "patch_ids": [], "statement_hash": "c6a82b8f7c102ed1bbaa42dfcc9b92f0220d24790e7deb28b84741bec1576300", "relations": [{"rule": 2, "type": "equivalent", "target": "7ded2f3aed6eb776afe95ab57579f474", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c6a82b8f7c102ed1bbaa42dfcc9b92f0220d24790e7deb28b84741bec1576300"}}, {"rule": 2, "type": "equivalent", "target": "95e0a24f610d24ea94a95e0efe62ca88", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c6a82b8f7c102ed1bbaa42dfcc9b92f0220d24790e7deb28b84741bec1576300"}}, {"rule": 2, "type": "equivalent", "target": "f4ea0d64a1dc2dd78d93bdae9255c39e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c6a82b8f7c102ed1bbaa42dfcc9b92f0220d24790e7deb28b84741bec1576300"}}], "version": "9.0.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f4ea0d64a1dc2dd78d93bdae9255c39e", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "In ALTER TABLE ... SET TABLESPACE, allow the database's default tablespace to be used without a permissions check", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c6a82b8f7c102ed1bbaa42dfcc9b92f0220d24790e7deb28b84741bec1576300"}, "url": "/docs/compare/?release=9.3.3#9.3.3-c7f2cb08bdbf8d5d", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "95e0a24f610d24ea94a95e0efe62ca88", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "In ALTER TABLE ... SET TABLESPACE, allow the database's default tablespace to be used without a permissions check", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c6a82b8f7c102ed1bbaa42dfcc9b92f0220d24790e7deb28b84741bec1576300"}, "url": "/docs/compare/?release=9.2.7#9.2.7-c7f2cb08bdbf8d5d", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "7ded2f3aed6eb776afe95ab57579f474", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "In ALTER TABLE ... SET TABLESPACE, allow the database's default tablespace to be used without a permissions check", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c6a82b8f7c102ed1bbaa42dfcc9b92f0220d24790e7deb28b84741bec1576300"}, "url": "/docs/compare/?release=9.1.12#9.1.12-c7f2cb08bdbf8d5d", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-f41cc3c5eba5bf12", "cves": [], "html": "Fix \"cannot accept a set\" error when some arms of a CASE return a set and others don't (Tom Lane)
", "text": "Fix \"cannot accept a set\" error when some arms of a CASE return a set and others don't (Tom Lane)", "title": "Fix \"cannot accept a set\" error when some arms of a CASE return a set and others don't", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "a8764b4fe1c21c34bc097b78a138576bba56daa58712464e188fd0ab1404b44c", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix cannot accept a set error when some arms of a CASE return a set and others don't (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/022", "db_id": "58542151bd1bb3c497ae9ee5b4dafc1a", "patch_ids": [], "statement_hash": "d9ea93b3ec8d5937eb3bb5e086b4e9977b111b98ced02d5e7efa3a037e0553a2", "relations": [{"rule": 2, "type": "equivalent", "target": "3c022e03cacf413d80f93c1250d3f8d8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d9ea93b3ec8d5937eb3bb5e086b4e9977b111b98ced02d5e7efa3a037e0553a2"}}, {"rule": 2, "type": "equivalent", "target": "5c0d749e9a869ed15f6aabb49321c1c6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d9ea93b3ec8d5937eb3bb5e086b4e9977b111b98ced02d5e7efa3a037e0553a2"}}, {"rule": 2, "type": "equivalent", "target": "90e4474f0a8941a41cee36d029dcd7ec", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d9ea93b3ec8d5937eb3bb5e086b4e9977b111b98ced02d5e7efa3a037e0553a2"}}], "version": "9.0.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "5c0d749e9a869ed15f6aabb49321c1c6", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Fix \"cannot accept a set\" error when some arms of a CASE return a set and others don't", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d9ea93b3ec8d5937eb3bb5e086b4e9977b111b98ced02d5e7efa3a037e0553a2"}, "url": "/docs/compare/?release=9.3.3#9.3.3-f41cc3c5eba5bf12", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "3c022e03cacf413d80f93c1250d3f8d8", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Fix \"cannot accept a set\" error when some arms of a CASE return a set and others don't", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d9ea93b3ec8d5937eb3bb5e086b4e9977b111b98ced02d5e7efa3a037e0553a2"}, "url": "/docs/compare/?release=9.2.7#9.2.7-f41cc3c5eba5bf12", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "90e4474f0a8941a41cee36d029dcd7ec", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Fix \"cannot accept a set\" error when some arms of a CASE return a set and others don't", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d9ea93b3ec8d5937eb3bb5e086b4e9977b111b98ced02d5e7efa3a037e0553a2"}, "url": "/docs/compare/?release=9.1.12#9.1.12-f41cc3c5eba5bf12", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-3a47266cbbe24075", "cves": [], "html": "Fix checks for all-zero client addresses in pgstat functions (Kevin Grittner)
", "text": "Fix checks for all-zero client addresses in pgstat functions (Kevin Grittner)", "title": "Fix checks for all-zero client addresses in pgstat functions", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "078f83ab14535c851aca537dc8afd3499c5f4fb4e31ac599b11e0c2a461b07a4", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix checks for all-zero client addresses in pgstat functions (Kevin Grittner)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/023", "db_id": "f647ad538a9bce5e0da6e05e57afcc79", "patch_ids": [], "statement_hash": "012d8dc6ae3c6bac36fa1387a792a36627ad5c8a44ff8a122a0141f75adcaa27", "relations": [{"rule": 2, "type": "equivalent", "target": "a00f19f4a4095e9a9165e129b432db14", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012d8dc6ae3c6bac36fa1387a792a36627ad5c8a44ff8a122a0141f75adcaa27"}}, {"rule": 2, "type": "equivalent", "target": "bda9cb552f7456b4075e860b04842ecc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012d8dc6ae3c6bac36fa1387a792a36627ad5c8a44ff8a122a0141f75adcaa27"}}, {"rule": 2, "type": "equivalent", "target": "f66fb5509ed7da6955cc8611eb2490e2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012d8dc6ae3c6bac36fa1387a792a36627ad5c8a44ff8a122a0141f75adcaa27"}}], "version": "9.0.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "a00f19f4a4095e9a9165e129b432db14", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Fix checks for all-zero client addresses in pgstat functions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012d8dc6ae3c6bac36fa1387a792a36627ad5c8a44ff8a122a0141f75adcaa27"}, "url": "/docs/compare/?release=9.3.3#9.3.3-3a47266cbbe24075", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "bda9cb552f7456b4075e860b04842ecc", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Fix checks for all-zero client addresses in pgstat functions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012d8dc6ae3c6bac36fa1387a792a36627ad5c8a44ff8a122a0141f75adcaa27"}, "url": "/docs/compare/?release=9.2.7#9.2.7-3a47266cbbe24075", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "f66fb5509ed7da6955cc8611eb2490e2", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Fix checks for all-zero client addresses in pgstat functions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012d8dc6ae3c6bac36fa1387a792a36627ad5c8a44ff8a122a0141f75adcaa27"}, "url": "/docs/compare/?release=9.1.12#9.1.12-3a47266cbbe24075", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-c7d55c3b179ea7c5", "cves": [], "html": "Fix possible misclassification of multibyte characters by the text search parser (Tom Lane)
\nNon-ASCII characters could be misclassified when using C locale with a multibyte encoding. On Cygwin, non-C locales could fail as well.
", "text": "Fix possible misclassification of multibyte characters by the text search parser (Tom Lane) Non-ASCII characters could be misclassified when using C locale with a multibyte encoding. On Cygwin, non-C locales could fail as well.", "title": "Fix possible misclassification of multibyte characters by the text search parser", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "d96fdef635c6f8195b28a9a30b1fccb2d9a5cec0de93b7374a04b1911d6f668c", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix possible misclassification of multibyte characters by the text search parser (Tom Lane) Non-ASCII characters could be misclassified when using C locale with a multibyte encoding. On Cygwin, non-C locales could fail as well.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/024", "db_id": "5356f043efb90dba09cddfb702db2ea9", "patch_ids": [], "statement_hash": "2c24580cfb42fb7c3c9934439a795a08627401e9cf599b45863720676b2b6aee", "relations": [{"rule": 2, "type": "equivalent", "target": "0d29215af03bfacc673f9e3040747da2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2c24580cfb42fb7c3c9934439a795a08627401e9cf599b45863720676b2b6aee"}}, {"rule": 2, "type": "equivalent", "target": "537f6a77723456e1f621b81a24ab6f9a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2c24580cfb42fb7c3c9934439a795a08627401e9cf599b45863720676b2b6aee"}}, {"rule": 2, "type": "equivalent", "target": "bdec3fe347e507ce4e004c7d0c07d9b2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2c24580cfb42fb7c3c9934439a795a08627401e9cf599b45863720676b2b6aee"}}], "version": "9.0.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "bdec3fe347e507ce4e004c7d0c07d9b2", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Fix possible misclassification of multibyte characters by the text search parser", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2c24580cfb42fb7c3c9934439a795a08627401e9cf599b45863720676b2b6aee"}, "url": "/docs/compare/?release=9.3.3#9.3.3-c7d55c3b179ea7c5", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "0d29215af03bfacc673f9e3040747da2", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Fix possible misclassification of multibyte characters by the text search parser", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2c24580cfb42fb7c3c9934439a795a08627401e9cf599b45863720676b2b6aee"}, "url": "/docs/compare/?release=9.2.7#9.2.7-c7d55c3b179ea7c5", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "537f6a77723456e1f621b81a24ab6f9a", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Fix possible misclassification of multibyte characters by the text search parser", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2c24580cfb42fb7c3c9934439a795a08627401e9cf599b45863720676b2b6aee"}, "url": "/docs/compare/?release=9.1.12#9.1.12-c7d55c3b179ea7c5", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-e1833076e60945e4", "cves": [], "html": "Fix possible misbehavior in plainto_tsquery() (Heikki Linnakangas)
Use memmove() not memcpy() for copying overlapping memory regions. There have been no field reports of this actually causing trouble, but it's certainly risky.
Accept SHIFT_JIS as an encoding name for locale checking purposes (Tatsuo Ishii)
", "text": "Accept SHIFT_JIS as an encoding name for locale checking purposes (Tatsuo Ishii)", "title": "Accept SHIFT_JIS as an encoding name for locale checking purposes", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "e93f15ff444ab0f041852e7d293ab60e755ee6cd293529e99a4d5bb4c08a980e", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Accept SHIFT_JIS as an encoding name for locale checking purposes (Tatsuo Ishii)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/026", "db_id": "a04d579b3f501ab201d3464ef69d04bf", "patch_ids": [], "statement_hash": "0f5c3694c1ae8671fa8070d5fe0319feda04bb81aa4117b1dcb50a5e6fac088d", "relations": [{"rule": 2, "type": "equivalent", "target": "866c9eaa269f0f65fb023895be9f35ee", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f5c3694c1ae8671fa8070d5fe0319feda04bb81aa4117b1dcb50a5e6fac088d"}}, {"rule": 2, "type": "equivalent", "target": "9771bff578b97b093217263738f5d2fa", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f5c3694c1ae8671fa8070d5fe0319feda04bb81aa4117b1dcb50a5e6fac088d"}}, {"rule": 2, "type": "equivalent", "target": "f6f888ec1197e21a1c8d0720e5da29fa", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f5c3694c1ae8671fa8070d5fe0319feda04bb81aa4117b1dcb50a5e6fac088d"}}], "version": "9.0.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "9771bff578b97b093217263738f5d2fa", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Accept SHIFT_JIS as an encoding name for locale checking purposes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f5c3694c1ae8671fa8070d5fe0319feda04bb81aa4117b1dcb50a5e6fac088d"}, "url": "/docs/compare/?release=9.3.3#9.3.3-9137326be68097d3", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "866c9eaa269f0f65fb023895be9f35ee", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Accept SHIFT_JIS as an encoding name for locale checking purposes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f5c3694c1ae8671fa8070d5fe0319feda04bb81aa4117b1dcb50a5e6fac088d"}, "url": "/docs/compare/?release=9.2.7#9.2.7-9137326be68097d3", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "f6f888ec1197e21a1c8d0720e5da29fa", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Accept SHIFT_JIS as an encoding name for locale checking purposes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0f5c3694c1ae8671fa8070d5fe0319feda04bb81aa4117b1dcb50a5e6fac088d"}, "url": "/docs/compare/?release=9.1.12#9.1.12-9137326be68097d3", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-271ea8652848a270", "cves": [], "html": "Fix misbehavior of PQhost() on Windows (Fujii Masao)
It should return localhost if no host has been specified.
", "text": "Fix misbehavior of PQhost() on Windows (Fujii Masao) It should return localhost if no host has been specified.", "title": "Fix misbehavior of PQhost() on Windows", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "34c1228c9ab6b2ccbf1ac607d3a4ccb0cf8f0beda5ee53f0da604f49a621329d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix misbehavior of PQhost() on Windows (Fujii Masao) It should return localhost if no host has been specified.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/027", "db_id": "2be4fa57cd17a0243188804f11d8aeb6", "patch_ids": [], "statement_hash": "475827447503f9b58237112e3d4d55ba99fd44c259e8f2c3a0fd9176c9883262", "relations": [{"rule": 2, "type": "equivalent", "target": "5db54b36acb017ea25901f1533a95c0e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "475827447503f9b58237112e3d4d55ba99fd44c259e8f2c3a0fd9176c9883262"}}, {"rule": 2, "type": "equivalent", "target": "6334cd2eb111d5b2cfd0cd06ce8e5a7b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "475827447503f9b58237112e3d4d55ba99fd44c259e8f2c3a0fd9176c9883262"}}, {"rule": 2, "type": "equivalent", "target": "844108fae0db3a59b6f24237a7ad8720", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "475827447503f9b58237112e3d4d55ba99fd44c259e8f2c3a0fd9176c9883262"}}], "version": "9.0.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "6334cd2eb111d5b2cfd0cd06ce8e5a7b", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Fix misbehavior of PQhost() on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "475827447503f9b58237112e3d4d55ba99fd44c259e8f2c3a0fd9176c9883262"}, "url": "/docs/compare/?release=9.3.3#9.3.3-271ea8652848a270", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "5db54b36acb017ea25901f1533a95c0e", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Fix misbehavior of PQhost() on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "475827447503f9b58237112e3d4d55ba99fd44c259e8f2c3a0fd9176c9883262"}, "url": "/docs/compare/?release=9.2.7#9.2.7-271ea8652848a270", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "844108fae0db3a59b6f24237a7ad8720", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Fix misbehavior of PQhost() on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "475827447503f9b58237112e3d4d55ba99fd44c259e8f2c3a0fd9176c9883262"}, "url": "/docs/compare/?release=9.1.12#9.1.12-271ea8652848a270", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-c0befc33d50deffd", "cves": [], "html": "Improve error handling in libpq and psql for failures during COPY TO STDOUT/FROM STDIN (Tom Lane)
\nIn particular this fixes an infinite loop that could occur in 9.2 and up if the server connection was lost during COPY FROM STDIN. Variants of that scenario might be possible in older versions, or with other client applications.
", "text": "Improve error handling in libpq and psql for failures during COPY TO STDOUT/FROM STDIN (Tom Lane) In particular this fixes an infinite loop that could occur in 9.2 and up if the server connection was lost during COPY FROM STDIN. Variants of that scenario might be possible in older versions, or with other client applications.", "title": "Improve error handling in libpq and psql for failures during COPY TO STDOUT/FROM STDIN", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "2dcb1de2aa726ba9700b939ad36d218272c3b92071ceb5e01e3dd652c530d4a5", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Improve error handling in libpq and psql for failures during COPY TO STDOUT/FROM STDIN (Tom Lane) In particular this fixes an infinite loop that could occur in 9.2 and up if the server connection was lost during COPY FROM STDIN. Variants of that scenario might be possible in older versions, or with other client applications.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/028", "db_id": "abb33b9a9a77e4fcf26c39103d088b1d", "patch_ids": [], "statement_hash": "c71eb87fd3f60bb83c6f0d81938071c5b92bc25ac45379ca3ce1804cb6b92703", "relations": [{"rule": 2, "type": "equivalent", "target": "18946eb065f1162c255f7a086721af24", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c71eb87fd3f60bb83c6f0d81938071c5b92bc25ac45379ca3ce1804cb6b92703"}}, {"rule": 2, "type": "equivalent", "target": "1977d3f1de2078a044157f02af2d57e2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c71eb87fd3f60bb83c6f0d81938071c5b92bc25ac45379ca3ce1804cb6b92703"}}, {"rule": 2, "type": "equivalent", "target": "a87e12de3be8565fae3a0cc05ccbec93", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c71eb87fd3f60bb83c6f0d81938071c5b92bc25ac45379ca3ce1804cb6b92703"}}], "version": "9.0.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "1977d3f1de2078a044157f02af2d57e2", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Improve error handling in libpq and psql for failures during COPY TO STDOUT/FROM STDIN", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c71eb87fd3f60bb83c6f0d81938071c5b92bc25ac45379ca3ce1804cb6b92703"}, "url": "/docs/compare/?release=9.3.3#9.3.3-c0befc33d50deffd", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "18946eb065f1162c255f7a086721af24", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Improve error handling in libpq and psql for failures during COPY TO STDOUT/FROM STDIN", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c71eb87fd3f60bb83c6f0d81938071c5b92bc25ac45379ca3ce1804cb6b92703"}, "url": "/docs/compare/?release=9.2.7#9.2.7-c0befc33d50deffd", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "a87e12de3be8565fae3a0cc05ccbec93", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Improve error handling in libpq and psql for failures during COPY TO STDOUT/FROM STDIN", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c71eb87fd3f60bb83c6f0d81938071c5b92bc25ac45379ca3ce1804cb6b92703"}, "url": "/docs/compare/?release=9.1.12#9.1.12-c0befc33d50deffd", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-7a21e1a3dd7bd03f", "cves": [], "html": "Fix misaligned descriptors in ecpg (MauMau)
", "text": "Fix misaligned descriptors in ecpg (MauMau)", "title": "Fix misaligned descriptors in ecpg", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "2364e38a98e9d05017b8dd013a0f2efc7dc4709783db81c7353f4d682e3ba302", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix misaligned descriptors in ecpg (MauMau)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/029", "db_id": "63187688b264935a9fb8c639a9e8279c", "patch_ids": [], "statement_hash": "e1db1186cbe3bdfe73043360b8f2568e87b7ba04052a239fbc39f29c728a2a0f", "relations": [{"rule": 2, "type": "equivalent", "target": "4d69980cad10a28e2496f4dd4cddc7e8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e1db1186cbe3bdfe73043360b8f2568e87b7ba04052a239fbc39f29c728a2a0f"}}, {"rule": 2, "type": "equivalent", "target": "6ade69ef56fb0dd48990328ce7dca6b0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e1db1186cbe3bdfe73043360b8f2568e87b7ba04052a239fbc39f29c728a2a0f"}}, {"rule": 2, "type": "equivalent", "target": "ec5d2ade7e0c822042799186a50168ff", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e1db1186cbe3bdfe73043360b8f2568e87b7ba04052a239fbc39f29c728a2a0f"}}], "version": "9.0.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "6ade69ef56fb0dd48990328ce7dca6b0", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Fix misaligned descriptors in ecpg", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e1db1186cbe3bdfe73043360b8f2568e87b7ba04052a239fbc39f29c728a2a0f"}, "url": "/docs/compare/?release=9.3.3#9.3.3-7a21e1a3dd7bd03f", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "4d69980cad10a28e2496f4dd4cddc7e8", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Fix misaligned descriptors in ecpg", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e1db1186cbe3bdfe73043360b8f2568e87b7ba04052a239fbc39f29c728a2a0f"}, "url": "/docs/compare/?release=9.2.7#9.2.7-7a21e1a3dd7bd03f", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "ec5d2ade7e0c822042799186a50168ff", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Fix misaligned descriptors in ecpg", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e1db1186cbe3bdfe73043360b8f2568e87b7ba04052a239fbc39f29c728a2a0f"}, "url": "/docs/compare/?release=9.1.12#9.1.12-7a21e1a3dd7bd03f", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-0c66be5eda3774e3", "cves": [], "html": "In ecpg, handle lack of a hostname in the connection parameters properly (Michael Meskes)
", "text": "In ecpg, handle lack of a hostname in the connection parameters properly (Michael Meskes)", "title": "In ecpg, handle lack of a hostname in the connection parameters properly", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "e446c9dd087e4e9630c8a7dd0a3dcbe6063cb3dbb4efa538ce2f1f2e2c26d176", "section_path": ["Changes"], "commit_groups": [], "identity_text": "In ecpg, handle lack of a hostname in the connection parameters properly (Michael Meskes)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/030", "db_id": "a9a7c28946aaa4ecbcc57c3da8a77f66", "patch_ids": [], "statement_hash": "9d833eb55bb1b2ab0d6fbbf79549cd22d15720cb59e0aaf7e0d6dd9e7033f94c", "relations": [{"rule": 2, "type": "equivalent", "target": "4afa4aeef213bb9e4d870a5d611ec8ec", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d833eb55bb1b2ab0d6fbbf79549cd22d15720cb59e0aaf7e0d6dd9e7033f94c"}}, {"rule": 2, "type": "equivalent", "target": "9ceb30ec27e9b5568d6e7846e555febe", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d833eb55bb1b2ab0d6fbbf79549cd22d15720cb59e0aaf7e0d6dd9e7033f94c"}}, {"rule": 2, "type": "equivalent", "target": "d59fea6d312588389fd5cef530e33d24", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d833eb55bb1b2ab0d6fbbf79549cd22d15720cb59e0aaf7e0d6dd9e7033f94c"}}], "version": "9.0.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "4afa4aeef213bb9e4d870a5d611ec8ec", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "In ecpg, handle lack of a hostname in the connection parameters properly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d833eb55bb1b2ab0d6fbbf79549cd22d15720cb59e0aaf7e0d6dd9e7033f94c"}, "url": "/docs/compare/?release=9.3.3#9.3.3-0c66be5eda3774e3", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "9ceb30ec27e9b5568d6e7846e555febe", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "In ecpg, handle lack of a hostname in the connection parameters properly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d833eb55bb1b2ab0d6fbbf79549cd22d15720cb59e0aaf7e0d6dd9e7033f94c"}, "url": "/docs/compare/?release=9.2.7#9.2.7-0c66be5eda3774e3", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "d59fea6d312588389fd5cef530e33d24", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "In ecpg, handle lack of a hostname in the connection parameters properly", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9d833eb55bb1b2ab0d6fbbf79549cd22d15720cb59e0aaf7e0d6dd9e7033f94c"}, "url": "/docs/compare/?release=9.1.12#9.1.12-0c66be5eda3774e3", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-35a6943053f27ecf", "cves": [], "html": "Fix performance regression in contrib/dblink connection startup (Joe Conway)
\nAvoid an unnecessary round trip when client and server encodings match.
", "text": "Fix performance regression in contrib/dblink connection startup (Joe Conway) Avoid an unnecessary round trip when client and server encodings match.", "title": "Fix performance regression in contrib/dblink connection startup", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "77ea0d7446f5da04de1c791bfa39c65606d48621270de5881bca867ddea17e82", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix performance regression in contrib/dblink connection startup (Joe Conway) Avoid an unnecessary round trip when client and server encodings match.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/031", "db_id": "4d74dcc2749f5c61e773a56a14b99eea", "patch_ids": [], "statement_hash": "0028db7ac6c71f3e2d08a3afa4922ca7c475d129e825ed766c3db1bd97df59fd", "relations": [{"rule": 2, "type": "equivalent", "target": "5cb1d3ba7445ae6a191f7724379570f4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0028db7ac6c71f3e2d08a3afa4922ca7c475d129e825ed766c3db1bd97df59fd"}}, {"rule": 2, "type": "equivalent", "target": "775f3b33cad27f641eef2602e318afa9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0028db7ac6c71f3e2d08a3afa4922ca7c475d129e825ed766c3db1bd97df59fd"}}, {"rule": 2, "type": "equivalent", "target": "98099b381e1ec49a7b3ab6e5a1ccdfca", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0028db7ac6c71f3e2d08a3afa4922ca7c475d129e825ed766c3db1bd97df59fd"}}], "version": "9.0.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "98099b381e1ec49a7b3ab6e5a1ccdfca", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Fix performance regression in contrib/dblink connection startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0028db7ac6c71f3e2d08a3afa4922ca7c475d129e825ed766c3db1bd97df59fd"}, "url": "/docs/compare/?release=9.3.3#9.3.3-35a6943053f27ecf", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "775f3b33cad27f641eef2602e318afa9", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Fix performance regression in contrib/dblink connection startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0028db7ac6c71f3e2d08a3afa4922ca7c475d129e825ed766c3db1bd97df59fd"}, "url": "/docs/compare/?release=9.2.7#9.2.7-35a6943053f27ecf", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "5cb1d3ba7445ae6a191f7724379570f4", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Fix performance regression in contrib/dblink connection startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0028db7ac6c71f3e2d08a3afa4922ca7c475d129e825ed766c3db1bd97df59fd"}, "url": "/docs/compare/?release=9.1.12#9.1.12-35a6943053f27ecf", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-7655bd6cae4f34d3", "cves": [], "html": "In contrib/isn, fix incorrect calculation of the check digit for ISMN values (Fabien Coelho)
", "text": "In contrib/isn, fix incorrect calculation of the check digit for ISMN values (Fabien Coelho)", "title": "In contrib/isn, fix incorrect calculation of the check digit for ISMN values", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "5010fce2bbc4a133e71f4272940db640ee8638e47352441b7663d7c75885bf10", "section_path": ["Changes"], "commit_groups": [], "identity_text": "In contrib/isn, fix incorrect calculation of the check digit for ISMN values (Fabien Coelho)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/032", "db_id": "c4ff74999ccd489cec6330b58a38053a", "patch_ids": [], "statement_hash": "e33e100fa66b59aa9020d4165cc261e4014e6efc27ebf95c341cb0c605684be2", "relations": [{"rule": 2, "type": "equivalent", "target": "36f14f8752af3dfa35b013a3705d8f0b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e33e100fa66b59aa9020d4165cc261e4014e6efc27ebf95c341cb0c605684be2"}}, {"rule": 2, "type": "equivalent", "target": "9141a6601bbf463730fe47d298a3829b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e33e100fa66b59aa9020d4165cc261e4014e6efc27ebf95c341cb0c605684be2"}}, {"rule": 2, "type": "equivalent", "target": "fd2cac0ffae045f6179466497f87b84c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e33e100fa66b59aa9020d4165cc261e4014e6efc27ebf95c341cb0c605684be2"}}], "version": "9.0.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "fd2cac0ffae045f6179466497f87b84c", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "In contrib/isn, fix incorrect calculation of the check digit for ISMN values", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e33e100fa66b59aa9020d4165cc261e4014e6efc27ebf95c341cb0c605684be2"}, "url": "/docs/compare/?release=9.3.3#9.3.3-7655bd6cae4f34d3", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "36f14f8752af3dfa35b013a3705d8f0b", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "In contrib/isn, fix incorrect calculation of the check digit for ISMN values", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e33e100fa66b59aa9020d4165cc261e4014e6efc27ebf95c341cb0c605684be2"}, "url": "/docs/compare/?release=9.2.7#9.2.7-7655bd6cae4f34d3", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "9141a6601bbf463730fe47d298a3829b", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "In contrib/isn, fix incorrect calculation of the check digit for ISMN values", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "e33e100fa66b59aa9020d4165cc261e4014e6efc27ebf95c341cb0c605684be2"}, "url": "/docs/compare/?release=9.1.12#9.1.12-7655bd6cae4f34d3", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-2a1051b6c39d47fc", "cves": [], "html": "Ensure client-code-only installation procedure works as documented (Peter Eisentraut)
", "text": "Ensure client-code-only installation procedure works as documented (Peter Eisentraut)", "title": "Ensure client-code-only installation procedure works as documented", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "f5e23ded6f91426b954fd0ae7245d1691dab2ce19f0cdd9e9c01825c8b994e48", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ensure client-code-only installation procedure works as documented (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/033", "db_id": "c303c36187628f862cebe9630133e7d7", "patch_ids": [], "statement_hash": "982a22ba0c0fc9f39ed5a187a45c862a30663b01fb6f99c6e1e91f02dedab011", "relations": [{"rule": 2, "type": "equivalent", "target": "58bd9f078f3ada69900a6b8cbbe2602d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "982a22ba0c0fc9f39ed5a187a45c862a30663b01fb6f99c6e1e91f02dedab011"}}, {"rule": 2, "type": "equivalent", "target": "c7b6f1186ffd36c215a6e25af968b3aa", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "982a22ba0c0fc9f39ed5a187a45c862a30663b01fb6f99c6e1e91f02dedab011"}}, {"rule": 2, "type": "equivalent", "target": "d17b909c487519e35c91540ad9a14013", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "982a22ba0c0fc9f39ed5a187a45c862a30663b01fb6f99c6e1e91f02dedab011"}}], "version": "9.0.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "58bd9f078f3ada69900a6b8cbbe2602d", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Ensure client-code-only installation procedure works as documented", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "982a22ba0c0fc9f39ed5a187a45c862a30663b01fb6f99c6e1e91f02dedab011"}, "url": "/docs/compare/?release=9.3.3#9.3.3-2a1051b6c39d47fc", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "d17b909c487519e35c91540ad9a14013", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Ensure client-code-only installation procedure works as documented", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "982a22ba0c0fc9f39ed5a187a45c862a30663b01fb6f99c6e1e91f02dedab011"}, "url": "/docs/compare/?release=9.2.7#9.2.7-2a1051b6c39d47fc", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "c7b6f1186ffd36c215a6e25af968b3aa", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Ensure client-code-only installation procedure works as documented", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "982a22ba0c0fc9f39ed5a187a45c862a30663b01fb6f99c6e1e91f02dedab011"}, "url": "/docs/compare/?release=9.1.12#9.1.12-2a1051b6c39d47fc", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-68961dfba4dba871", "cves": [], "html": "In Mingw and Cygwin builds, install the libpq DLL in the bin directory (Andrew Dunstan)
\nThis duplicates what the MSVC build has long done. It should fix problems with programs like psql failing to start because they can't find the DLL.
", "text": "In Mingw and Cygwin builds, install the libpq DLL in the bin directory (Andrew Dunstan) This duplicates what the MSVC build has long done. It should fix problems with programs like psql failing to start because they can't find the DLL.", "title": "In Mingw and Cygwin builds, install the libpq DLL in the bin directory", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "f7d5416438508338990fb8613b75ad0fc2fab9ab994a785880e329fcdaab4396", "section_path": ["Changes"], "commit_groups": [], "identity_text": "In Mingw and Cygwin builds, install the libpq DLL in the bin directory (Andrew Dunstan) This duplicates what the MSVC build has long done. It should fix problems with programs like psql failing to start because they can't find the DLL.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/034", "db_id": "89491f71df83763d94751b95b329fa93", "patch_ids": [], "statement_hash": "3241a1ed0f7d952330d81e639844192b4a36218a5e3e61baa69a488b4eaa444e", "relations": [{"rule": 2, "type": "equivalent", "target": "0302567255deea4d2411fab39bd02c56", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3241a1ed0f7d952330d81e639844192b4a36218a5e3e61baa69a488b4eaa444e"}}, {"rule": 2, "type": "equivalent", "target": "b6021cbbca322e4b8f2cd2271b75b619", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3241a1ed0f7d952330d81e639844192b4a36218a5e3e61baa69a488b4eaa444e"}}, {"rule": 2, "type": "equivalent", "target": "fee9d6a59e850baf90cda45821eecacf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3241a1ed0f7d952330d81e639844192b4a36218a5e3e61baa69a488b4eaa444e"}}], "version": "9.0.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "0302567255deea4d2411fab39bd02c56", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "In Mingw and Cygwin builds, install the libpq DLL in the bin directory", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3241a1ed0f7d952330d81e639844192b4a36218a5e3e61baa69a488b4eaa444e"}, "url": "/docs/compare/?release=9.3.3#9.3.3-68961dfba4dba871", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "fee9d6a59e850baf90cda45821eecacf", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "In Mingw and Cygwin builds, install the libpq DLL in the bin directory", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3241a1ed0f7d952330d81e639844192b4a36218a5e3e61baa69a488b4eaa444e"}, "url": "/docs/compare/?release=9.2.7#9.2.7-68961dfba4dba871", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "b6021cbbca322e4b8f2cd2271b75b619", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "In Mingw and Cygwin builds, install the libpq DLL in the bin directory", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3241a1ed0f7d952330d81e639844192b4a36218a5e3e61baa69a488b4eaa444e"}, "url": "/docs/compare/?release=9.1.12#9.1.12-68961dfba4dba871", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-e6755cdc568fba9f", "cves": [], "html": "Avoid using the deprecated dllwrap tool in Cygwin builds (Marco Atzeri)
", "text": "Avoid using the deprecated dllwrap tool in Cygwin builds (Marco Atzeri)", "title": "Avoid using the deprecated dllwrap tool in Cygwin builds", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "67e90d8a54ad13e94bd6202bf9dc78e93282a45968abc4842ce64cf91bc772f7", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid using the deprecated dllwrap tool in Cygwin builds (Marco Atzeri)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/035", "db_id": "7edd7a9bd2c1a7a388c02f3986440490", "patch_ids": [], "statement_hash": "3c61ce3593b62f42b978df4e1942c39d39146496e1ad5de2cc847af3ccfc2240", "relations": [{"rule": 2, "type": "equivalent", "target": "1d75a6e6f4b4ab0a85036c110643ff2d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c61ce3593b62f42b978df4e1942c39d39146496e1ad5de2cc847af3ccfc2240"}}, {"rule": 2, "type": "equivalent", "target": "2fbbffbfcc77e3b6cb58dfd390835926", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c61ce3593b62f42b978df4e1942c39d39146496e1ad5de2cc847af3ccfc2240"}}, {"rule": 2, "type": "equivalent", "target": "98dd7d1085b2b4e05b5546f35e08703d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c61ce3593b62f42b978df4e1942c39d39146496e1ad5de2cc847af3ccfc2240"}}], "version": "9.0.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "98dd7d1085b2b4e05b5546f35e08703d", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Avoid using the deprecated dllwrap tool in Cygwin builds", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c61ce3593b62f42b978df4e1942c39d39146496e1ad5de2cc847af3ccfc2240"}, "url": "/docs/compare/?release=9.3.3#9.3.3-e6755cdc568fba9f", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "1d75a6e6f4b4ab0a85036c110643ff2d", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Avoid using the deprecated dllwrap tool in Cygwin builds", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c61ce3593b62f42b978df4e1942c39d39146496e1ad5de2cc847af3ccfc2240"}, "url": "/docs/compare/?release=9.2.7#9.2.7-e6755cdc568fba9f", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "2fbbffbfcc77e3b6cb58dfd390835926", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Avoid using the deprecated dllwrap tool in Cygwin builds", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3c61ce3593b62f42b978df4e1942c39d39146496e1ad5de2cc847af3ccfc2240"}, "url": "/docs/compare/?release=9.1.12#9.1.12-e6755cdc568fba9f", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-07c5e90b9ccf0f04", "cves": [], "html": "Don't generate plain-text HISTORY and src/test/regress/README files anymore (Tom Lane)
\nThese text files duplicated the main HTML and PDF documentation formats. The trouble involved in maintaining them greatly outweighs the likely audience for plain-text format. Distribution tarballs will still contain files by these names, but they'll just be stubs directing the reader to consult the main documentation. The plain-text INSTALL file will still be maintained, as there is arguably a use-case for that.
", "text": "Don't generate plain-text HISTORY and src/test/regress/README files anymore (Tom Lane) These text files duplicated the main HTML and PDF documentation formats. The trouble involved in maintaining them greatly outweighs the likely audience for plain-text format. Distribution tarballs will still contain files by these names, but they'll just be stubs directing the reader to consult the main documentation. The plain-text INSTALL file will still be maintained, as there is arguably a use-case for that.", "title": "Don't generate plain-text HISTORY and src/test/regress/README files anymore", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "73fd9f7771ad7a52b74eb07cd75d12ee7e46a49abddf81169455f2016c5828d0", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Don't generate plain-text HISTORY and src/test/regress/README files anymore (Tom Lane) These text files duplicated the main HTML and PDF documentation formats. The trouble involved in maintaining them greatly outweighs the likely audience for plain-text format. Distribution tarballs will still contain files by these names, but they'll just be stubs directing the reader to consult the main documentation. The plain-text INSTALL file will still be maintained, as there is arguably a use-case for that.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/036", "db_id": "8f5abd09149c838e8965a43513b33d71", "patch_ids": [], "statement_hash": "0b9b2c925a6a1efc9e97f2c281f87569fc70e31a2ee312bc51abcee47de1f3ea", "relations": [{"rule": 2, "type": "equivalent", "target": "151af5bd1019d9736efc077efdcd8826", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0b9b2c925a6a1efc9e97f2c281f87569fc70e31a2ee312bc51abcee47de1f3ea"}}, {"rule": 2, "type": "equivalent", "target": "6366e113cf58bb2656b7567937084988", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0b9b2c925a6a1efc9e97f2c281f87569fc70e31a2ee312bc51abcee47de1f3ea"}}, {"rule": 2, "type": "equivalent", "target": "ce2a90a400c4464691f3dd8c089042fb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0b9b2c925a6a1efc9e97f2c281f87569fc70e31a2ee312bc51abcee47de1f3ea"}}], "version": "9.0.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "6366e113cf58bb2656b7567937084988", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Don't generate plain-text HISTORY and src/test/regress/README files anymore", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0b9b2c925a6a1efc9e97f2c281f87569fc70e31a2ee312bc51abcee47de1f3ea"}, "url": "/docs/compare/?release=9.3.3#9.3.3-07c5e90b9ccf0f04", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "151af5bd1019d9736efc077efdcd8826", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Don't generate plain-text HISTORY and src/test/regress/README files anymore", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0b9b2c925a6a1efc9e97f2c281f87569fc70e31a2ee312bc51abcee47de1f3ea"}, "url": "/docs/compare/?release=9.2.7#9.2.7-07c5e90b9ccf0f04", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "ce2a90a400c4464691f3dd8c089042fb", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Don't generate plain-text HISTORY and src/test/regress/README files anymore", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0b9b2c925a6a1efc9e97f2c281f87569fc70e31a2ee312bc51abcee47de1f3ea"}, "url": "/docs/compare/?release=9.1.12#9.1.12-07c5e90b9ccf0f04", "source_url": "/docs/release/9.1.12/#AEN108541"}]}, {"id": "9.0.16-1af8a63b91331a94", "cves": [], "html": "Update time zone data files to tzdata release 2013i for DST law changes in Jordan and historical changes in Cuba.
\nIn addition, the zones Asia/Riyadh87, Asia/Riyadh88, and Asia/Riyadh89 have been removed, as they are no longer maintained by IANA, and never represented actual civil timekeeping practice.
", "text": "Update time zone data files to tzdata release 2013i for DST law changes in Jordan and historical changes in Cuba. In addition, the zones Asia/Riyadh87, Asia/Riyadh88, and Asia/Riyadh89 have been removed, as they are no longer maintained by IANA, and never represented actual civil timekeeping practice.", "title": "Update time zone data files to tzdata release 2013i for DST law changes in Jordan and historical changes in Cuba.", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.16/#AEN100212", "source_hash": "2887e332c6e809ef93d1c50205f6bf370b1ba41b7a6fb50be666b8652b03e36a", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Update time zone data files to tzdata release 2013i for DST law changes in Jordan and historical changes in Cuba. In addition, the zones Asia/Riyadh87, Asia/Riyadh88, and Asia/Riyadh89 have been removed, as they are no longer maintained by IANA, and never represented actual civil timekeeping practice.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.16/changes/037", "db_id": "abe89ecfd07e3e8b4e40f90e03f43376", "patch_ids": [], "statement_hash": "69cd2c066d4e1bcf121caec87c33486ecdcf16c86786704c47ba90e8a588de37", "relations": [{"rule": 2, "type": "equivalent", "target": "4e888fdfc2f702951597a37abbd78ad8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "69cd2c066d4e1bcf121caec87c33486ecdcf16c86786704c47ba90e8a588de37"}}, {"rule": 2, "type": "equivalent", "target": "67da9ec3694c31e9359907b451b82be8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "69cd2c066d4e1bcf121caec87c33486ecdcf16c86786704c47ba90e8a588de37"}}, {"rule": 2, "type": "equivalent", "target": "6f7af8ff0b09719347f315962ff9c3e4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "69cd2c066d4e1bcf121caec87c33486ecdcf16c86786704c47ba90e8a588de37"}}], "version": "9.0.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "6f7af8ff0b09719347f315962ff9c3e4", "kind": "equivalent", "version": "9.3.3", "label": "9.3.3", "title": "Update time zone data files to tzdata release 2013i for DST law changes in Jordan and historical changes in Cuba.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "69cd2c066d4e1bcf121caec87c33486ecdcf16c86786704c47ba90e8a588de37"}, "url": "/docs/compare/?release=9.3.3#9.3.3-1af8a63b91331a94", "source_url": "/docs/release/9.3.3/#AEN118515"}, {"db_id": "67da9ec3694c31e9359907b451b82be8", "kind": "equivalent", "version": "9.2.7", "label": "9.2.7", "title": "Update time zone data files to tzdata release 2013i for DST law changes in Jordan and historical changes in Cuba.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "69cd2c066d4e1bcf121caec87c33486ecdcf16c86786704c47ba90e8a588de37"}, "url": "/docs/compare/?release=9.2.7#9.2.7-1af8a63b91331a94", "source_url": "/docs/release/9.2.7/#AEN113149"}, {"db_id": "4e888fdfc2f702951597a37abbd78ad8", "kind": "equivalent", "version": "9.1.12", "label": "9.1.12", "title": "Update time zone data files to tzdata release 2013i for DST law changes in Jordan and historical changes in Cuba.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "69cd2c066d4e1bcf121caec87c33486ecdcf16c86786704c47ba90e8a588de37"}, "url": "/docs/compare/?release=9.1.12#9.1.12-1af8a63b91331a94", "source_url": "/docs/release/9.1.12/#AEN108541"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 37}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 16}, {"key": "security", "label": "Security", "count": 8}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 13}], "total": 37, "release_count": 1, "cross_major": false, "cve_count": 8, "cves": [{"id": "CVE-2014-0062", "url": "https://www.postgresql.org/support/security/CVE-2014-0062/", "fixed": {"8.4": "8.4.20", "9.0": "9.0.16", "9.1": "9.1.12", "9.2": "9.2.7", "9.3": "9.3.3"}, "score": 8.8, "title": "Avoid multiple name lookups during table and index DDL", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H", "affected": {"8.4": "8.4", "9.0": "9.0", "9.1": "9.1", "9.2": "9.2", "9.3": "9.3"}, "component": "core server", "published": {}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": null, "fixed_version": "9.0.16"}, {"id": "CVE-2014-0061", "url": "https://www.postgresql.org/support/security/CVE-2014-0061/", "fixed": {"8.4": "8.4.20", "9.0": "9.0.16", "9.1": "9.1.12", "9.2": "9.2.7", "9.3": "9.3.3"}, "score": 7.5, "title": "Prevent privilege escalation via manual calls to PL validator functions", "vector": "AV:N/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:H", "affected": {"8.4": "8.4", "9.0": "9.0", "9.1": "9.1", "9.2": "9.2", "9.3": "9.3"}, "component": "core server", "published": {}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": null, "fixed_version": "9.0.16"}, {"id": "CVE-2014-0067", "url": "https://www.postgresql.org/support/security/CVE-2014-0067/", "fixed": {"9.0": "9.0.19", "9.1": "9.1.15", "9.2": "9.2.10", "9.3": "9.3.6", "9.4": "9.4.1"}, "score": 7.0, "title": "Document risks of make check in the regression testing instructions", "vector": "AV:L/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:H", "affected": {"9.0": "9.0", "9.1": "9.1", "9.2": "9.2", "9.3": "9.3", "9.4": "9.4"}, "component": "other", "published": {}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": null, "fixed_version": "9.0.19"}, {"id": "CVE-2014-0064", "url": "https://www.postgresql.org/support/security/CVE-2014-0064/", "fixed": {"8.4": "8.4.20", "9.0": "9.0.16", "9.1": "9.1.12", "9.2": "9.2.7", "9.3": "9.3.3"}, "score": 6.5, "title": "Prevent buffer overrun due to integer overflow in size calculations", "vector": "AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:L/A:H", "affected": {"8.4": "8.4", "9.0": "9.0", "9.1": "9.1", "9.2": "9.2", "9.3": "9.3"}, "component": "core server", "published": {}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": null, "fixed_version": "9.0.16"}, {"id": "CVE-2014-0063", "url": "https://www.postgresql.org/support/security/CVE-2014-0063/", "fixed": {"8.4": "8.4.20", "9.0": "9.0.16", "9.1": "9.1.12", "9.2": "9.2.7", "9.3": "9.3.3"}, "score": 4.3, "title": "Prevent buffer overrun with long datetime strings", "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:L/A:N", "affected": {"8.4": "8.4", "9.0": "9.0", "9.1": "9.1", "9.2": "9.2", "9.3": "9.3"}, "component": "core server", "published": {}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": null, "fixed_version": "9.0.16"}, {"id": "CVE-2014-0060", "url": "https://www.postgresql.org/support/security/CVE-2014-0060/", "fixed": {"8.4": "8.4.20", "9.0": "9.0.16", "9.1": "9.1.12", "9.2": "9.2.7", "9.3": "9.3.3"}, "score": 3.1, "title": "Shore up GRANT ... WITH ADMIN OPTION restrictions", "vector": "AV:N/AC:H/PR:L/UI:N/S:U/C:N/I:N/A:L", "affected": {"8.4": "8.4", "9.0": "9.0", "9.1": "9.1", "9.2": "9.2", "9.3": "9.3"}, "component": "core server", "published": {}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": null, "fixed_version": "9.0.16"}, {"id": "CVE-2014-0066", "url": "https://www.postgresql.org/support/security/CVE-2014-0066/", "fixed": {"8.4": "8.4.20", "9.0": "9.0.16", "9.1": "9.1.12", "9.2": "9.2.7", "9.3": "9.3.3"}, "score": 0.0, "title": "Avoid crashing if crypt() returns NULL", "vector": "AV:N/AC:H/PR:L/UI:N/S:U/C:N/I:N/A:N", "affected": {"8.4": "8.4", "9.0": "9.0", "9.1": "9.1", "9.2": "9.2", "9.3": "9.3"}, "component": "contrib module", "published": {}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": null, "fixed_version": "9.0.16"}, {"id": "CVE-2014-0065", "url": "https://www.postgresql.org/support/security/CVE-2014-0065/", "fixed": {"8.4": "8.4.20", "9.0": "9.0.16", "9.1": "9.1.12", "9.2": "9.2.7", "9.3": "9.3.3"}, "score": 0.0, "title": "Prevent overruns of fixed-size buffers", "vector": "AV:N/AC:H/PR:L/UI:N/S:U/C:N/I:N/A:N", "affected": {"8.4": "8.4", "9.0": "9.0", "9.1": "9.1", "9.2": "9.2", "9.3": "9.3"}, "component": "core server", "published": {}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": null, "fixed_version": "9.0.16"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 37, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}