A dump/restore is not required for those running 9.1.X.
\nHowever, if you are upgrading from a version earlier than 9.1.4, see Section E.21.
", "compatibility_count": 0, "label": "9.1.5", "status_label": "Historical", "eol": "2016-10-27", "age_days": 5156, "support_days": -3624}, "groups": [{"date": "2012-08-17", "build": "9.1.5", "major": "9.1", "minor": 5, "manual": "9.1", "status": "stable", "doc_git": "", "version": "9.1.5", "eol_date": "2016-10-27", "date_text": "2012-08-17", "supported": false, "manual_url": "/docs/9.1/release-9-1-5.html", "source_url": "/docs/release/9.1.5/", "entry_count": 30, "placeholder": false, "content_hash": "8b3b0178525cbfcaf08abc5732ff8d4daf1e2dd3262618fbad094658e2275f3c", "manual_build": "9.1.24", "source_as_of": "", "changes_count": 30, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 9.1.X.
\nHowever, if you are upgrading from a version earlier than 9.1.4, see Section E.21.
", "compatibility_count": 0, "label": "9.1.5", "status_label": "Historical", "eol": "2016-10-27", "age_days": 5156, "support_days": -3624, "entries": [{"id": "9.1.5-5c3b094f9d56fa89", "cves": ["CVE-2012-3489"], "html": "Prevent access to external files/URLs via XML entity references (Noah Misch, Tom Lane)
\nxml_parse() would attempt to fetch external files or URLs as needed to resolve DTD and entity references in an XML value, thus allowing unprivileged database users to attempt to fetch data with the privileges of the database server. While the external data wouldn't get returned directly to the user, portions of it could be exposed in error messages if the data didn't parse as valid XML; and in any case the mere ability to check existence of a file might be useful to an attacker. (CVE-2012-3489)
Prevent access to external files/URLs via contrib/xml2's xslt_process() (Peter Eisentraut)
libxslt offers the ability to read and write both files and URLs through stylesheet commands, thus allowing unprivileged database users to both read and write data with the privileges of the database server. Disable that through proper use of libxslt's security options. (CVE-2012-3488)
\nAlso, remove xslt_process()'s ability to fetch documents and stylesheets from external files/URLs. While this was a documented \"feature\", it was long regarded as a bad idea. The fix for CVE-2012-3489 broke that capability, and rather than expend effort on trying to fix it, we're just going to summarily remove it.
Prevent too-early recycling of btree index pages (Noah Misch)
\nWhen we allowed read-only transactions to skip assigning XIDs, we introduced the possibility that a deleted btree page could be recycled while a read-only transaction was still in flight to it. This would result in incorrect index search results. The probability of such an error occurring in the field seems very low because of the timing requirements, but nonetheless it should be fixed.
", "text": "Prevent too-early recycling of btree index pages (Noah Misch) When we allowed read-only transactions to skip assigning XIDs, we introduced the possibility that a deleted btree page could be recycled while a read-only transaction was still in flight to it. This would result in incorrect index search results. The probability of such an error occurring in the field seems very low because of the timing requirements, but nonetheless it should be fixed.", "title": "Prevent too-early recycling of btree index pages", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "143bd3621f8904490904efdc96eea5620bf4242c01017e726244d289400995de", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent too-early recycling of btree index pages (Noah Misch) When we allowed read-only transactions to skip assigning XIDs, we introduced the possibility that a deleted btree page could be recycled while a read-only transaction was still in flight to it. This would result in incorrect index search results. The probability of such an error occurring in the field seems very low because of the timing requirements, but nonetheless it should be fixed.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/003", "db_id": "07ead3a6bded50621943d455566a3a9c", "patch_ids": [], "statement_hash": "9376e2480687801694aeb8b7494f7b1ca6a24bd8923ae61b9d76bfcfff194d7d", "relations": [{"rule": 2, "type": "equivalent", "target": "b153a4cf63fb975902cfb36655588ab0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9376e2480687801694aeb8b7494f7b1ca6a24bd8923ae61b9d76bfcfff194d7d"}}], "version": "9.1.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b153a4cf63fb975902cfb36655588ab0", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Prevent too-early recycling of btree index pages", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9376e2480687801694aeb8b7494f7b1ca6a24bd8923ae61b9d76bfcfff194d7d"}, "url": "/docs/compare/?release=9.0.9#9.0.9-c93d295eb78e22c9", "source_url": "/docs/release/9.0.9/#AEN101039"}]}, {"id": "9.1.5-94244bb84e2d2cb8", "cves": [], "html": "Fix crash-safety bug with newly-created-or-reset sequences (Tom Lane)
\nIf ALTER SEQUENCE was executed on a freshly created or reset sequence, and then precisely one nextval() call was made on it, and then the server crashed, WAL replay would restore the sequence to a state in which it appeared that no nextval() had been done, thus allowing the first sequence value to be returned again by the next nextval() call. In particular this could manifest for serial columns, since creation of a serial column's sequence includes an ALTER SEQUENCE OWNED BY step.
Fix race condition in enum-type value comparisons (Robert Haas, Tom Lane)
\nComparisons could fail when encountering an enum value added since the current query started.
", "text": "Fix race condition in enum-type value comparisons (Robert Haas, Tom Lane) Comparisons could fail when encountering an enum value added since the current query started.", "title": "Fix race condition in enum-type value comparisons", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "47a1aaa6c15c3fd2b9edd716117bf91e98e5bfa6945e7231a4704daec26cf5fe", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix race condition in enum-type value comparisons (Robert Haas, Tom Lane) Comparisons could fail when encountering an enum value added since the current query started.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/005", "db_id": "d0d0f119aba3848ca1358d7a1ca62c30", "patch_ids": [], "statement_hash": "d3eb9d4a1281500521df52581813b6c19ece19774cea1ab2c1a9ccdeb5a8110a", "relations": [], "version": "9.1.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.1.5-fee46c300e6d2817", "cves": [], "html": "Fix txid_current() to report the correct epoch when not in hot standby (Heikki Linnakangas)
This fixes a regression introduced in the previous minor release.
", "text": "Fix txid_current() to report the correct epoch when not in hot standby (Heikki Linnakangas) This fixes a regression introduced in the previous minor release.", "title": "Fix txid_current() to report the correct epoch when not in hot standby", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "76cdacdf5c3f091e33d76201bd37bf4870512fb9765f59654f6aa4aa219ba678", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix txid_current() to report the correct epoch when not in hot standby (Heikki Linnakangas) This fixes a regression introduced in the previous minor release.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/006", "db_id": "a067552706629f50b1c9e991d724f6b1", "patch_ids": [], "statement_hash": "36cabc451de4fa9e1bfcc97cc24fd968191aa13fcd67c5bab1dd18059e9ad3bf", "relations": [{"rule": 2, "type": "equivalent", "target": "9041f612b14ba62621d965c6e2f631a2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "36cabc451de4fa9e1bfcc97cc24fd968191aa13fcd67c5bab1dd18059e9ad3bf"}}], "version": "9.1.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "9041f612b14ba62621d965c6e2f631a2", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Fix txid_current() to report the correct epoch when not in hot standby", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "36cabc451de4fa9e1bfcc97cc24fd968191aa13fcd67c5bab1dd18059e9ad3bf"}, "url": "/docs/compare/?release=9.0.9#9.0.9-fee46c300e6d2817", "source_url": "/docs/release/9.0.9/#AEN101039"}]}, {"id": "9.1.5-e49202e868b00ca2", "cves": [], "html": "Prevent selection of unsuitable replication connections as the synchronous standby (Fujii Masao)
\nThe master might improperly choose pseudo-servers such as pg_receivexlog or pg_basebackup as the synchronous standby, and then wait indefinitely for them.
", "text": "Prevent selection of unsuitable replication connections as the synchronous standby (Fujii Masao) The master might improperly choose pseudo-servers such as pg_receivexlog or pg_basebackup as the synchronous standby, and then wait indefinitely for them.", "title": "Prevent selection of unsuitable replication connections as the synchronous standby", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "4c08cb1dd73e2f605c11c943d9f5c70ddb6aceba10bc5b19280553570b9dbd05", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent selection of unsuitable replication connections as the synchronous standby (Fujii Masao) The master might improperly choose pseudo-servers such as pg_receivexlog or pg_basebackup as the synchronous standby, and then wait indefinitely for them.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/007", "db_id": "bc7390f6a9bc761fac6478cc1c73600c", "patch_ids": [], "statement_hash": "e98a2cf79dcf719945920b3bf5019823a73d90c168d42880c84df4f6ef066df0", "relations": [], "version": "9.1.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.1.5-aa57e2ed9e0ef9c0", "cves": [], "html": "Fix bug in startup of Hot Standby when a master transaction has many subtransactions (Andres Freund)
\nThis mistake led to failures reported as \"out-of-order XID insertion in KnownAssignedXids\".
", "text": "Fix bug in startup of Hot Standby when a master transaction has many subtransactions (Andres Freund) This mistake led to failures reported as \"out-of-order XID insertion in KnownAssignedXids\".", "title": "Fix bug in startup of Hot Standby when a master transaction has many subtransactions", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "670702f64ada41d7bc53e87ded43a60a8c4ef243b26c9f11f5ac73bbee0c2e70", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix bug in startup of Hot Standby when a master transaction has many subtransactions (Andres Freund) This mistake led to failures reported as out-of-order XID insertion in KnownAssignedXids.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/008", "db_id": "d74cd45279f701529aa637d37cd4d856", "patch_ids": [], "statement_hash": "328c792f75844b3385c7fab8976ad00ebdf7ded73058b0124e6a6c34be38ddde", "relations": [{"rule": 2, "type": "equivalent", "target": "80bcd213614b69d13571b755eaeb9ab9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "328c792f75844b3385c7fab8976ad00ebdf7ded73058b0124e6a6c34be38ddde"}}], "version": "9.1.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "80bcd213614b69d13571b755eaeb9ab9", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Fix bug in startup of Hot Standby when a master transaction has many subtransactions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "328c792f75844b3385c7fab8976ad00ebdf7ded73058b0124e6a6c34be38ddde"}, "url": "/docs/compare/?release=9.0.9#9.0.9-aa57e2ed9e0ef9c0", "source_url": "/docs/release/9.0.9/#AEN101039"}]}, {"id": "9.1.5-7ec672425f204d05", "cves": [], "html": "Ensure the backup_label file is fsync'd after pg_start_backup() (Dave Kerr)
Fix timeout handling in walsender processes (Tom Lane)
\nWAL sender background processes neglected to establish a SIGALRM handler, meaning they would wait forever in some corner cases where a timeout ought to happen.
", "text": "Fix timeout handling in walsender processes (Tom Lane) WAL sender background processes neglected to establish a SIGALRM handler, meaning they would wait forever in some corner cases where a timeout ought to happen.", "title": "Fix timeout handling in walsender processes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "b33ca10e6ae8f6bb58111050c8ef4cb3f888f0a8c068cd2c9444e0854b113de1", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix timeout handling in walsender processes (Tom Lane) WAL sender background processes neglected to establish a SIGALRM handler, meaning they would wait forever in some corner cases where a timeout ought to happen.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/010", "db_id": "b5635c171f4a52e8f6126a150f3dce44", "patch_ids": [], "statement_hash": "1c415476b1fad6885e0d64939e780f43b405489c8ba3711e85f9e0bec1ebb5ce", "relations": [{"rule": 2, "type": "equivalent", "target": "2023e5354e16641f20d57c327ece2f71", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1c415476b1fad6885e0d64939e780f43b405489c8ba3711e85f9e0bec1ebb5ce"}}], "version": "9.1.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2023e5354e16641f20d57c327ece2f71", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Fix timeout handling in walsender processes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1c415476b1fad6885e0d64939e780f43b405489c8ba3711e85f9e0bec1ebb5ce"}, "url": "/docs/compare/?release=9.0.9#9.0.9-5bf5ed994b9a5a07", "source_url": "/docs/release/9.0.9/#AEN101039"}]}, {"id": "9.1.5-ff6e39bd52767bd1", "cves": [], "html": "Wake walsenders after each background flush by walwriter (Andres Freund, Simon Riggs)
\nThis greatly reduces replication delay when the workload contains only asynchronously-committed transactions.
", "text": "Wake walsenders after each background flush by walwriter (Andres Freund, Simon Riggs) This greatly reduces replication delay when the workload contains only asynchronously-committed transactions.", "title": "Wake walsenders after each background flush by walwriter", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "a9cbc978ca0141e0ec72802b580b60831ae5bc82a120c7ebfd2f4c07857d392d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Wake walsenders after each background flush by walwriter (Andres Freund, Simon Riggs) This greatly reduces replication delay when the workload contains only asynchronously-committed transactions.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/011", "db_id": "f5d74ed76377d4b2aaff13a84a83c66e", "patch_ids": [], "statement_hash": "1d17f1c0c6792adffe9e995f674603a7c397147e0f3012e9fadf55c817253ea6", "relations": [], "version": "9.1.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.1.5-a551ef7ff6bbe8ee", "cves": [], "html": "Fix LISTEN/NOTIFY to cope better with I/O problems, such as out of disk space (Tom Lane)
\nAfter a write failure, all subsequent attempts to send more NOTIFY messages would fail with messages like \"Could not read from file \"pg_notify/nnnn\" at offset nnnnn: Success\".
", "text": "Fix LISTEN/NOTIFY to cope better with I/O problems, such as out of disk space (Tom Lane) After a write failure, all subsequent attempts to send more NOTIFY messages would fail with messages like \"Could not read from file \"pg_notify/nnnn\" at offset nnnnn: Success\".", "title": "Fix LISTEN/NOTIFY to cope better with I/O problems, such as out of disk space", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "9aed13cd301571f58956bf797589bdf41a56438bfe537b1256fe6d766d35888b", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix LISTEN/NOTIFY to cope better with I/O problems, such as out of disk space (Tom Lane) After a write failure, all subsequent attempts to send more NOTIFY messages would fail with messages like Could not read from file \"pg_notify/nnnn\" at offset nnnnn: Success.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/012", "db_id": "5f21a6ef115d600e1e7ba8cc06b62d8f", "patch_ids": [], "statement_hash": "2d2020798c1edede37e5f28fe629fe1d824aedda9d228b85e75a95e4c22ddfe5", "relations": [{"rule": 2, "type": "equivalent", "target": "3158a61fbdea6a04314ac47c9bf7f620", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2d2020798c1edede37e5f28fe629fe1d824aedda9d228b85e75a95e4c22ddfe5"}}], "version": "9.1.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "3158a61fbdea6a04314ac47c9bf7f620", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Fix LISTEN/NOTIFY to cope better with I/O problems, such as out of disk space", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2d2020798c1edede37e5f28fe629fe1d824aedda9d228b85e75a95e4c22ddfe5"}, "url": "/docs/compare/?release=9.0.9#9.0.9-a551ef7ff6bbe8ee", "source_url": "/docs/release/9.0.9/#AEN101039"}]}, {"id": "9.1.5-4a8275a58023bde8", "cves": [], "html": "Only allow autovacuum to be auto-canceled by a directly blocked process (Tom Lane)
\nThe original coding could allow inconsistent behavior in some cases; in particular, an autovacuum could get canceled after less than deadlock_timeout grace period.
", "text": "Only allow autovacuum to be auto-canceled by a directly blocked process (Tom Lane) The original coding could allow inconsistent behavior in some cases; in particular, an autovacuum could get canceled after less than deadlock_timeout grace period.", "title": "Only allow autovacuum to be auto-canceled by a directly blocked process", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "404e89d8455e25494afb6c3e13169cba227dfa2025350fe23aff4ca1dc142a0e", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Only allow autovacuum to be auto-canceled by a directly blocked process (Tom Lane) The original coding could allow inconsistent behavior in some cases; in particular, an autovacuum could get canceled after less than deadlock_timeout grace period.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/013", "db_id": "c8c37fa6986136f15a3210d8d923724c", "patch_ids": [], "statement_hash": "6e1539dc1dba826d8f8080f236fcdefe4d67d6d75b7e2107a8088d4915efa718", "relations": [{"rule": 2, "type": "equivalent", "target": "103446aac3e3f017add1249c1e455767", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6e1539dc1dba826d8f8080f236fcdefe4d67d6d75b7e2107a8088d4915efa718"}}], "version": "9.1.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "103446aac3e3f017add1249c1e455767", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Only allow autovacuum to be auto-canceled by a directly blocked process", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6e1539dc1dba826d8f8080f236fcdefe4d67d6d75b7e2107a8088d4915efa718"}, "url": "/docs/compare/?release=9.0.9#9.0.9-4a8275a58023bde8", "source_url": "/docs/release/9.0.9/#AEN101039"}]}, {"id": "9.1.5-d102a994d830ea2f", "cves": [], "html": "Improve logging of autovacuum cancels (Robert Haas)
", "text": "Improve logging of autovacuum cancels (Robert Haas)", "title": "Improve logging of autovacuum cancels", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "6e597de1ea2ef8a8fe3bb6373b26a8eca0add4add863aadabe30886dbeed83fa", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Improve logging of autovacuum cancels (Robert Haas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/014", "db_id": "fcca657b594088becba32ddbc6599af7", "patch_ids": [], "statement_hash": "f0a7a1e4f1d2143bb0d016bbe28b789cc8c48b97b31ad90e3e24f9bb4e70affd", "relations": [{"rule": 2, "type": "equivalent", "target": "b6ce52c9d02da958e2e4c990d4e85c30", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0a7a1e4f1d2143bb0d016bbe28b789cc8c48b97b31ad90e3e24f9bb4e70affd"}}], "version": "9.1.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "b6ce52c9d02da958e2e4c990d4e85c30", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Improve logging of autovacuum cancels", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f0a7a1e4f1d2143bb0d016bbe28b789cc8c48b97b31ad90e3e24f9bb4e70affd"}, "url": "/docs/compare/?release=9.0.9#9.0.9-d102a994d830ea2f", "source_url": "/docs/release/9.0.9/#AEN101039"}]}, {"id": "9.1.5-1ff63cf3a10f7d95", "cves": [], "html": "Fix log collector so that log_truncate_on_rotation works during the very first log rotation after server start (Tom Lane)
", "text": "Fix log collector so that log_truncate_on_rotation works during the very first log rotation after server start (Tom Lane)", "title": "Fix log collector so that log_truncate_on_rotation works during the very first log rotation after server start", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "176f36a3bd115c5866897aa8192c7de1e9474f7fe58b4c1f6e65ba56bfebbedf", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix log collector so that log_truncate_on_rotation works during the very first log rotation after server start (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/015", "db_id": "2e8994b7650c6b40c025f6fc4431e2eb", "patch_ids": [], "statement_hash": "4b1e5979dbb78cbb7f0e96362c68ffbeb53cbe186b4032bc6d6b7a8178cc9950", "relations": [{"rule": 2, "type": "equivalent", "target": "95da9af1253fc1ff9b3608f5f1118524", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4b1e5979dbb78cbb7f0e96362c68ffbeb53cbe186b4032bc6d6b7a8178cc9950"}}], "version": "9.1.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "95da9af1253fc1ff9b3608f5f1118524", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Fix log collector so that log_truncate_on_rotation works during the very first log rotation after server start", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4b1e5979dbb78cbb7f0e96362c68ffbeb53cbe186b4032bc6d6b7a8178cc9950"}, "url": "/docs/compare/?release=9.0.9#9.0.9-1ff63cf3a10f7d95", "source_url": "/docs/release/9.0.9/#AEN101039"}]}, {"id": "9.1.5-8486d1dbe2512b49", "cves": [], "html": "Fix WITH attached to a nested set operation (UNION/INTERSECT/EXCEPT) (Tom Lane)
", "text": "Fix WITH attached to a nested set operation (UNION/INTERSECT/EXCEPT) (Tom Lane)", "title": "Fix WITH attached to a nested set operation (UNION/INTERSECT/EXCEPT)", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "b9b4a64a60c3e3d47029f174be2033f9f2a92582a350746a9d12415518ab460c", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix WITH attached to a nested set operation (UNION/INTERSECT/EXCEPT) (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/016", "db_id": "1e782338af3c3d32b9f7a47ca4e5a376", "patch_ids": [], "statement_hash": "09d03806a9c5fbed69e9547ebb836ecdcd0622c3367925257a167ba820d33b03", "relations": [{"rule": 2, "type": "equivalent", "target": "4877db670c9074b96cbae24d05e366c8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "09d03806a9c5fbed69e9547ebb836ecdcd0622c3367925257a167ba820d33b03"}}], "version": "9.1.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4877db670c9074b96cbae24d05e366c8", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Fix WITH attached to a nested set operation (UNION/INTERSECT/EXCEPT)", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "09d03806a9c5fbed69e9547ebb836ecdcd0622c3367925257a167ba820d33b03"}, "url": "/docs/compare/?release=9.0.9#9.0.9-8486d1dbe2512b49", "source_url": "/docs/release/9.0.9/#AEN101039"}]}, {"id": "9.1.5-79f8e35367abfe46", "cves": [], "html": "Ensure that a whole-row reference to a subquery doesn't include any extra GROUP BY or ORDER BY columns (Tom Lane)
", "text": "Ensure that a whole-row reference to a subquery doesn't include any extra GROUP BY or ORDER BY columns (Tom Lane)", "title": "Ensure that a whole-row reference to a subquery doesn't include any extra GROUP BY or ORDER BY columns", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "f8a8c23c7c58fef85057be84d3794dc4c594188e4a7d0410fefa7b260f48d1f4", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ensure that a whole-row reference to a subquery doesn't include any extra GROUP BY or ORDER BY columns (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/017", "db_id": "04efb7bc8ae944f6440c85f2ab909df0", "patch_ids": [], "statement_hash": "1c6c1bcb7872536f154baec2aefc7b530bae344cb4e47f50f69d12dea264ee7e", "relations": [{"rule": 2, "type": "equivalent", "target": "084e32d63dd0f51e2402832e8e54b800", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1c6c1bcb7872536f154baec2aefc7b530bae344cb4e47f50f69d12dea264ee7e"}}], "version": "9.1.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "084e32d63dd0f51e2402832e8e54b800", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Ensure that a whole-row reference to a subquery doesn't include any extra GROUP BY or ORDER BY columns", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1c6c1bcb7872536f154baec2aefc7b530bae344cb4e47f50f69d12dea264ee7e"}, "url": "/docs/compare/?release=9.0.9#9.0.9-79f8e35367abfe46", "source_url": "/docs/release/9.0.9/#AEN101039"}]}, {"id": "9.1.5-bddc52b5c2134644", "cves": [], "html": "Fix dependencies generated during ALTER TABLE ... ADD CONSTRAINT USING INDEX (Tom Lane)
\nThis command left behind a redundant pg_depend entry for the index, which could confuse later operations, notably ALTER TABLE ... ALTER COLUMN TYPE on one of the indexed columns.
", "text": "Fix dependencies generated during ALTER TABLE ... ADD CONSTRAINT USING INDEX (Tom Lane) This command left behind a redundant pg_depend entry for the index, which could confuse later operations, notably ALTER TABLE ... ALTER COLUMN TYPE on one of the indexed columns.", "title": "Fix dependencies generated during ALTER TABLE ... ADD CONSTRAINT USING INDEX", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "fc242959f0c8ed43bfce6c2f22b1437e63383f81783ee7173d559a1553c42071", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix dependencies generated during ALTER TABLE ... ADD CONSTRAINT USING INDEX (Tom Lane) This command left behind a redundant pg_depend entry for the index, which could confuse later operations, notably ALTER TABLE ... ALTER COLUMN TYPE on one of the indexed columns.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/018", "db_id": "e5d3af3ee4b320f44b661e1b7796062f", "patch_ids": [], "statement_hash": "43ce1ecde97240ce7b0aaf371a5b6eb22bddd3d4eaa24a92a05fbc4a82e1a95c", "relations": [], "version": "9.1.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.1.5-5ddb582f83e6dc27", "cves": [], "html": "Fix REASSIGN OWNED to work on extensions (Alvaro Herrera)
", "text": "Fix REASSIGN OWNED to work on extensions (Alvaro Herrera)", "title": "Fix REASSIGN OWNED to work on extensions", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "45f20f404ef1343a45e10e6b6fd7522a44105aaa72eff4ec620db2fc4e7b054f", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix REASSIGN OWNED to work on extensions (Alvaro Herrera)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/019", "db_id": "ce02336849ff626c7a8535a039dfd97b", "patch_ids": [], "statement_hash": "7d318a3d315687a2a9c0d986b704605c0a214e2d4a9167260361976375028cff", "relations": [], "version": "9.1.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.1.5-2201f8b31e7dbaad", "cves": [], "html": "Disallow copying whole-row references in CHECK constraints and index definitions during CREATE TABLE (Tom Lane)
\nThis situation can arise in CREATE TABLE with LIKE or INHERITS. The copied whole-row variable was incorrectly labeled with the row type of the original table not the new one. Rejecting the case seems reasonable for LIKE, since the row types might well diverge later. For INHERITS we should ideally allow it, with an implicit coercion to the parent table's row type; but that will require more work than seems safe to back-patch.
", "text": "Disallow copying whole-row references in CHECK constraints and index definitions during CREATE TABLE (Tom Lane) This situation can arise in CREATE TABLE with LIKE or INHERITS. The copied whole-row variable was incorrectly labeled with the row type of the original table not the new one. Rejecting the case seems reasonable for LIKE, since the row types might well diverge later. For INHERITS we should ideally allow it, with an implicit coercion to the parent table's row type; but that will require more work than seems safe to back-patch.", "title": "Disallow copying whole-row references in CHECK constraints and index definitions during CREATE TABLE", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "9ae5291d6827bd39f49c4e62f764cef9998817dac0312b2a62318fedac7f2286", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Disallow copying whole-row references in CHECK constraints and index definitions during CREATE TABLE (Tom Lane) This situation can arise in CREATE TABLE with LIKE or INHERITS. The copied whole-row variable was incorrectly labeled with the row type of the original table not the new one. Rejecting the case seems reasonable for LIKE, since the row types might well diverge later. For INHERITS we should ideally allow it, with an implicit coercion to the parent table's row type; but that will require more work than seems safe to back-patch.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/020", "db_id": "1d48425a12e4c18b7735438ddaf2be07", "patch_ids": [], "statement_hash": "760c794d9ebc06dac889c171a706fec128d4fe6a44721becf2e740e55539ef5f", "relations": [{"rule": 2, "type": "equivalent", "target": "1b38b3af136078a8f8f3663ba18fae6a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "760c794d9ebc06dac889c171a706fec128d4fe6a44721becf2e740e55539ef5f"}}], "version": "9.1.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "1b38b3af136078a8f8f3663ba18fae6a", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Disallow copying whole-row references in CHECK constraints and index definitions during CREATE TABLE", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "760c794d9ebc06dac889c171a706fec128d4fe6a44721becf2e740e55539ef5f"}, "url": "/docs/compare/?release=9.0.9#9.0.9-2201f8b31e7dbaad", "source_url": "/docs/release/9.0.9/#AEN101039"}]}, {"id": "9.1.5-745fdc08f7a77fcd", "cves": [], "html": "Fix memory leak in ARRAY(SELECT ...) subqueries (Heikki Linnakangas, Tom Lane)
", "text": "Fix memory leak in ARRAY(SELECT ...) subqueries (Heikki Linnakangas, Tom Lane)", "title": "Fix memory leak in ARRAY(SELECT ...) subqueries", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "fe0194bf066c7b2b59cc7ade1ecded6768a7ae83dedbf0bee1e01d4dab5cfacf", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix memory leak in ARRAY(SELECT ...) subqueries (Heikki Linnakangas, Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/021", "db_id": "bc012ad4f39a0f0c66d998f6cfb9924a", "patch_ids": [], "statement_hash": "b0d6f65f080ca13202d5e83941c4f07444966f866265bcc67f221d5751bfaf80", "relations": [{"rule": 2, "type": "equivalent", "target": "8688b0cd63e3f818379de112cad2fe14", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b0d6f65f080ca13202d5e83941c4f07444966f866265bcc67f221d5751bfaf80"}}], "version": "9.1.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "8688b0cd63e3f818379de112cad2fe14", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Fix memory leak in ARRAY(SELECT ...) subqueries", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b0d6f65f080ca13202d5e83941c4f07444966f866265bcc67f221d5751bfaf80"}, "url": "/docs/compare/?release=9.0.9#9.0.9-745fdc08f7a77fcd", "source_url": "/docs/release/9.0.9/#AEN101039"}]}, {"id": "9.1.5-4b041929014b55f7", "cves": [], "html": "Fix planner to pass correct collation to operator selectivity estimators (Tom Lane)
\nThis was not previously required by any core selectivity estimation function, but third-party code might need it.
", "text": "Fix planner to pass correct collation to operator selectivity estimators (Tom Lane) This was not previously required by any core selectivity estimation function, but third-party code might need it.", "title": "Fix planner to pass correct collation to operator selectivity estimators", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "208468050a5e56d5b32e9fabfe6e759b4149915d70a102bfac85fb1579e60fd1", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix planner to pass correct collation to operator selectivity estimators (Tom Lane) This was not previously required by any core selectivity estimation function, but third-party code might need it.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/022", "db_id": "c11321bdd111b08c714061d0180db548", "patch_ids": [], "statement_hash": "4a9942ba43df8820ca021bc6bd3ee23aca5ecf0a55c5a0e0ee999d8dd05bda55", "relations": [], "version": "9.1.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.1.5-16f0f918729e3bf0", "cves": [], "html": "Fix extraction of common prefixes from regular expressions (Tom Lane)
\nThe code could get confused by quantified parenthesized subexpressions, such as ^(foo)?bar. This would lead to incorrect index optimization of searches for such patterns.
", "text": "Fix extraction of common prefixes from regular expressions (Tom Lane) The code could get confused by quantified parenthesized subexpressions, such as ^(foo)?bar. This would lead to incorrect index optimization of searches for such patterns.", "title": "Fix extraction of common prefixes from regular expressions", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "91aa9d89dfff5af83b926ccf0d2a1909dd6f67d77dce4e49c9c58f3c4cb52e76", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix extraction of common prefixes from regular expressions (Tom Lane) The code could get confused by quantified parenthesized subexpressions, such as ^(foo)?bar. This would lead to incorrect index optimization of searches for such patterns.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/023", "db_id": "f36203443c0f711654b57a1754b54226", "patch_ids": [], "statement_hash": "0c5726403215cf31b228491b9a70b7b0ef786d8a7f1c8e4af8ba23116db3eaf0", "relations": [{"rule": 2, "type": "equivalent", "target": "4cf52b135c67668937aef0b58593e73f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0c5726403215cf31b228491b9a70b7b0ef786d8a7f1c8e4af8ba23116db3eaf0"}}], "version": "9.1.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4cf52b135c67668937aef0b58593e73f", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Fix extraction of common prefixes from regular expressions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0c5726403215cf31b228491b9a70b7b0ef786d8a7f1c8e4af8ba23116db3eaf0"}, "url": "/docs/compare/?release=9.0.9#9.0.9-16f0f918729e3bf0", "source_url": "/docs/release/9.0.9/#AEN101039"}]}, {"id": "9.1.5-920819ad92d72a84", "cves": [], "html": "Fix bugs with parsing signed hh:mm and hh:mm:ss fields in interval constants (Amit Kapila, Tom Lane)
", "text": "Fix bugs with parsing signed hh:mm and hh:mm:ss fields in interval constants (Amit Kapila, Tom Lane)", "title": "Fix bugs with parsing signed hh:mm and hh:mm:ss fields in interval constants", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "de3a806c880eaa8ea44e49fcc32f0ac887c29f42b41bbe510e754eba924e3a30", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix bugs with parsing signed hh:mm and hh:mm:ss fields in interval constants (Amit Kapila, Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/024", "db_id": "de4a1dd86dfe959c200ccee30e81d45a", "patch_ids": [], "statement_hash": "ebfa4fc3096bea13425e775272a3d504a945d295a14de8d7adb314bde5e53000", "relations": [{"rule": 2, "type": "equivalent", "target": "bfa675853a121630a60adeb448c34056", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ebfa4fc3096bea13425e775272a3d504a945d295a14de8d7adb314bde5e53000"}}], "version": "9.1.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "bfa675853a121630a60adeb448c34056", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Fix bugs with parsing signed hh:mm and hh:mm:ss fields in interval constants", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ebfa4fc3096bea13425e775272a3d504a945d295a14de8d7adb314bde5e53000"}, "url": "/docs/compare/?release=9.0.9#9.0.9-920819ad92d72a84", "source_url": "/docs/release/9.0.9/#AEN101039"}]}, {"id": "9.1.5-b7b03a61a1cb8490", "cves": [], "html": "Fix pg_dump to better handle views containing partial GROUP BY lists (Tom Lane)
\nA view that lists only a primary key column in GROUP BY, but uses other table columns as if they were grouped, gets marked as depending on the primary key. Improper handling of such primary key dependencies in pg_dump resulted in poorly-ordered dumps, which at best would be inefficient to restore and at worst could result in outright failure of a parallel pg_restore run.
", "text": "Fix pg_dump to better handle views containing partial GROUP BY lists (Tom Lane) A view that lists only a primary key column in GROUP BY, but uses other table columns as if they were grouped, gets marked as depending on the primary key. Improper handling of such primary key dependencies in pg_dump resulted in poorly-ordered dumps, which at best would be inefficient to restore and at worst could result in outright failure of a parallel pg_restore run.", "title": "Fix pg_dump to better handle views containing partial GROUP BY lists", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "84a78bceb6dc697dd1826b6e48ec99d9183fe444ad9488cfe4f2174cfc6fe094", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix pg_dump to better handle views containing partial GROUP BY lists (Tom Lane) A view that lists only a primary key column in GROUP BY, but uses other table columns as if they were grouped, gets marked as depending on the primary key. Improper handling of such primary key dependencies in pg_dump resulted in poorly-ordered dumps, which at best would be inefficient to restore and at worst could result in outright failure of a parallel pg_restore run.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/025", "db_id": "8fdca72680e1370f1a4aab03f1e91968", "patch_ids": [], "statement_hash": "dfa545f52aed5205838a203ad63650ef4d5cab368db62e00bb9ec784e038e4bf", "relations": [], "version": "9.1.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.1.5-7846b1124c785488", "cves": [], "html": "In PL/Perl, avoid setting UTF8 flag when in SQL_ASCII encoding (Alex Hunsaker, Kyotaro Horiguchi, Alvaro Herrera)
", "text": "In PL/Perl, avoid setting UTF8 flag when in SQL_ASCII encoding (Alex Hunsaker, Kyotaro Horiguchi, Alvaro Herrera)", "title": "In PL/Perl, avoid setting UTF8 flag when in SQL_ASCII encoding", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "8fe2b4e0f8c1548b041ee205bd2b97a89521c80ccaab12159efeead034243278", "section_path": ["Changes"], "commit_groups": [], "identity_text": "In PL/Perl, avoid setting UTF8 flag when in SQL_ASCII encoding (Alex Hunsaker, Kyotaro Horiguchi, Alvaro Herrera)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/026", "db_id": "0c515b0209d5eabcd56d9a11cbbd47b6", "patch_ids": [], "statement_hash": "bb630965415f30603fd3e24b1f0b5d37692e59e2f03c7eeb3c435675ff789123", "relations": [], "version": "9.1.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.1.5-5c20b85ffd2abff6", "cves": [], "html": "Use Postgres' encoding conversion functions, not Python's, when converting a Python Unicode string to the server encoding in PL/Python (Jan Urbanski)
\nThis avoids some corner-case problems, notably that Python doesn't support all the encodings Postgres does. A notable functional change is that if the server encoding is SQL_ASCII, you will get the UTF-8 representation of the string; formerly, any non-ASCII characters in the string would result in an error.
", "text": "Use Postgres' encoding conversion functions, not Python's, when converting a Python Unicode string to the server encoding in PL/Python (Jan Urbanski) This avoids some corner-case problems, notably that Python doesn't support all the encodings Postgres does. A notable functional change is that if the server encoding is SQL_ASCII, you will get the UTF-8 representation of the string; formerly, any non-ASCII characters in the string would result in an error.", "title": "Use Postgres' encoding conversion functions, not Python's, when converting a Python Unicode string to the server encoding in PL/Python", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "f8a1873a8c5b059de10f9e021cf231ad49926729f56d6f867c03d047e2032b52", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Use Postgres' encoding conversion functions, not Python's, when converting a Python Unicode string to the server encoding in PL/Python (Jan Urbanski) This avoids some corner-case problems, notably that Python doesn't support all the encodings Postgres does. A notable functional change is that if the server encoding is SQL_ASCII, you will get the UTF-8 representation of the string; formerly, any non-ASCII characters in the string would result in an error.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/027", "db_id": "080bec2ed777ebf87d524bfc43d7b08d", "patch_ids": [], "statement_hash": "8ceccafb05d6ac158c35a27524065fe41865bc2631064c70104865c5910b62db", "relations": [{"rule": 2, "type": "equivalent", "target": "6e3c410cefd90131da3b37322b3bbe5a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8ceccafb05d6ac158c35a27524065fe41865bc2631064c70104865c5910b62db"}}], "version": "9.1.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "6e3c410cefd90131da3b37322b3bbe5a", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Use Postgres' encoding conversion functions, not Python's, when converting a Python Unicode string to the server encoding in PL/Python", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8ceccafb05d6ac158c35a27524065fe41865bc2631064c70104865c5910b62db"}, "url": "/docs/compare/?release=9.0.9#9.0.9-5c20b85ffd2abff6", "source_url": "/docs/release/9.0.9/#AEN101039"}]}, {"id": "9.1.5-ddde9304582636f1", "cves": [], "html": "Fix mapping of PostgreSQL encodings to Python encodings in PL/Python (Jan Urbanski)
", "text": "Fix mapping of PostgreSQL encodings to Python encodings in PL/Python (Jan Urbanski)", "title": "Fix mapping of PostgreSQL encodings to Python encodings in PL/Python", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "4d57cd52b5215efba928214ee8ff119883b8c030f048f6769d83477970600911", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix mapping of PostgreSQL encodings to Python encodings in PL/Python (Jan Urbanski)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/028", "db_id": "362f6953d5e4e7330ca4d3113c432e3a", "patch_ids": [], "statement_hash": "984566dfa271b9b7ce8d0c32011370101ec8cbe789ec8245b87a383bc41a0c8b", "relations": [{"rule": 2, "type": "equivalent", "target": "e2e684e26dbec7497ecfa8c5b1db9dce", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "984566dfa271b9b7ce8d0c32011370101ec8cbe789ec8245b87a383bc41a0c8b"}}], "version": "9.1.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "e2e684e26dbec7497ecfa8c5b1db9dce", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Fix mapping of PostgreSQL encodings to Python encodings in PL/Python", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "984566dfa271b9b7ce8d0c32011370101ec8cbe789ec8245b87a383bc41a0c8b"}, "url": "/docs/compare/?release=9.0.9#9.0.9-ddde9304582636f1", "source_url": "/docs/release/9.0.9/#AEN101039"}]}, {"id": "9.1.5-e78423cb2d054a6d", "cves": [], "html": "Report errors properly in contrib/xml2's xslt_process() (Tom Lane)
Update time zone data files to tzdata release 2012e for DST law changes in Morocco and Tokelau
", "text": "Update time zone data files to tzdata release 2012e for DST law changes in Morocco and Tokelau", "title": "Update time zone data files to tzdata release 2012e for DST law changes in Morocco and Tokelau", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.5/#AEN109535", "source_hash": "f5570407bce72d3d472401fd7367b1a6cd5fd2255ad3365d1b4024158f921227", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Update time zone data files to tzdata release 2012e for DST law changes in Morocco and Tokelau", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.5/changes/030", "db_id": "dedf0acf047dd2b04189342a4bde3417", "patch_ids": [], "statement_hash": "24e4fb24a20b5a0a02a7a687ec3fd980ed28ec71ed34d52fc874f8970a222b98", "relations": [{"rule": 2, "type": "equivalent", "target": "82cfac29d68a0457b1ed7275ed7063ca", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "24e4fb24a20b5a0a02a7a687ec3fd980ed28ec71ed34d52fc874f8970a222b98"}}], "version": "9.1.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "82cfac29d68a0457b1ed7275ed7063ca", "kind": "equivalent", "version": "9.0.9", "label": "9.0.9", "title": "Update time zone data files to tzdata release 2012e for DST law changes in Morocco and Tokelau", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "24e4fb24a20b5a0a02a7a687ec3fd980ed28ec71ed34d52fc874f8970a222b98"}, "url": "/docs/compare/?release=9.0.9#9.0.9-93535c6c8317ade4", "source_url": "/docs/release/9.0.9/#AEN101039"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 30}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 16}, {"key": "security", "label": "Security", "count": 2}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 12}], "total": 30, "release_count": 1, "cross_major": false, "cve_count": 2, "cves": [{"id": "CVE-2012-3489", "url": "https://www.postgresql.org/support/security/CVE-2012-3489/", "fixed": {"8.3": "8.3.20", "8.4": "8.4.13", "9.0": "9.0.9", "9.1": "9.1.5"}, "score": null, "title": "Prevent access to external files/URLs via XML entity references", "vector": "", "affected": {"8.3": "8.3", "8.4": "8.4", "9.0": "9.0", "9.1": "9.1"}, "component": "", "published": {}, "introduced": {}, "cvss_version": "", "description_en": "", "first_published": null, "fixed_version": "9.1.5"}, {"id": "CVE-2012-3488", "url": "https://www.postgresql.org/support/security/CVE-2012-3488/", "fixed": {"8.3": "8.3.20", "8.4": "8.4.13", "9.0": "9.0.9", "9.1": "9.1.5"}, "score": null, "title": "Prevent access to external files/URLs via contrib/xml2's xslt_process()", "vector": "", "affected": {"8.3": "8.3", "8.4": "8.4", "9.0": "9.0", "9.1": "9.1"}, "component": "", "published": {}, "introduced": {}, "cvss_version": "", "description_en": "", "first_published": null, "fixed_version": "9.1.5"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 30, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}