A dump/restore is not required for those running 9.2.X.
\nHowever, this release corrects a number of potential data corruption issues. See the first two changelog entries below to find out whether your installation has been affected and what steps you can take if so.
\nAlso, if you are upgrading from a version earlier than 9.2.4, see Section E.21.
", "compatibility_count": 0, "label": "9.2.6", "status_label": "Historical", "eol": "2017-11-09", "age_days": 4681, "support_days": -3246}, "groups": [{"date": "2013-12-05", "build": "9.2.6", "major": "9.2", "minor": 6, "manual": "9.2", "status": "stable", "doc_git": "", "version": "9.2.6", "eol_date": "2017-11-09", "date_text": "2013-12-05", "supported": false, "manual_url": "/docs/9.2/release-9-2-6.html", "source_url": "/docs/release/9.2.6/", "entry_count": 26, "placeholder": false, "content_hash": "e5c8cc0475b67adcd415f148c724a1faf33a68e0aa1715f63301304c73d6c6b1", "manual_build": "9.2.24", "source_as_of": "", "changes_count": 26, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 9.2.X.
\nHowever, this release corrects a number of potential data corruption issues. See the first two changelog entries below to find out whether your installation has been affected and what steps you can take if so.
\nAlso, if you are upgrading from a version earlier than 9.2.4, see Section E.21.
", "compatibility_count": 0, "label": "9.2.6", "status_label": "Historical", "eol": "2017-11-09", "age_days": 4681, "support_days": -3246, "entries": [{"id": "9.2.6-b6f10ca65f634275", "cves": [], "html": "Fix VACUUM's tests to see whether it can update relfrozenxid (Andres Freund)
\nIn some cases VACUUM (either manual or autovacuum) could incorrectly advance a table's relfrozenxid value, allowing tuples to escape freezing, causing those rows to become invisible once 2^31 transactions have elapsed. The probability of data loss is fairly low since multiple incorrect advancements would need to happen before actual loss occurs, but it's not zero. In 9.2.0 and later, the probability of loss is higher, and it's also possible to get \"could not access status of transaction\" errors as a consequence of this bug. Users upgrading from releases 9.0.4 or 8.4.8 or earlier are not affected, but all later versions contain the bug.
\nThe issue can be ameliorated by, after upgrading, vacuuming all tables in all databases while having vacuum_freeze_table_age set to zero. This will fix any latent corruption but will not be able to fix all pre-existing data errors. However, an installation can be presumed safe after performing this vacuuming if it has executed fewer than 2^31 update transactions in its lifetime (check this with SELECT txid_current() < 2^31).
", "text": "Fix VACUUM's tests to see whether it can update relfrozenxid (Andres Freund) In some cases VACUUM (either manual or autovacuum) could incorrectly advance a table's relfrozenxid value, allowing tuples to escape freezing, causing those rows to become invisible once 2^31 transactions have elapsed. The probability of data loss is fairly low since multiple incorrect advancements would need to happen before actual loss occurs, but it's not zero. In 9.2.0 and later, the probability of loss is higher, and it's also possible to get \"could not access status of transaction\" errors as a consequence of this bug. Users upgrading from releases 9.0.4 or 8.4.8 or earlier are not affected, but all later versions contain the bug. The issue can be ameliorated by, after upgrading, vacuuming all tables in all databases while having vacuum_freeze_table_age set to zero. This will fix any latent corruption but will not be able to fix all pre-existing data errors. However, an installation can be presumed safe after performing this vacuuming if it has executed fewer than 2^31 update transactions in its lifetime (check this with SELECT txid_current() < 2^31).", "title": "Fix VACUUM's tests to see whether it can update relfrozenxid", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "0e4d67f0544ea3c9b775745358e9aaae876e2b01af47f415e7591e3375b750e4", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix VACUUM's tests to see whether it can update relfrozenxid (Andres Freund) In some cases VACUUM (either manual or autovacuum) could incorrectly advance a table's relfrozenxid value, allowing tuples to escape freezing, causing those rows to become invisible once 2^31 transactions have elapsed. The probability of data loss is fairly low since multiple incorrect advancements would need to happen before actual loss occurs, but it's not zero. In 9.2.0 and later, the probability of loss is higher, and it's also possible to get could not access status of transaction errors as a consequence of this bug. Users upgrading from releases 9.0.4 or 8.4.8 or earlier are not affected, but all later versions contain the bug. The issue can be ameliorated by, after upgrading, vacuuming all tables in all databases while having vacuum_freeze_table_age set to zero. This will fix any latent corruption but will not be able to fix all pre-existing data errors. However, an installation can be presumed safe after performing this vacuuming if it has executed fewer than 2^31 update transactions in its lifetime (check this with SELECT txid_current() < 2^31).", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/001", "db_id": "40a37229f32a1a4d8227503685cb88c7", "patch_ids": [], "statement_hash": "2120ae1b60ab99c872851c49d00100a9ec8458028d02a05da1fb5639c6e4b18c", "relations": [{"rule": 2, "type": "equivalent", "target": "e856fecdad9ecd4960731d940a36a796", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2120ae1b60ab99c872851c49d00100a9ec8458028d02a05da1fb5639c6e4b18c"}}], "version": "9.2.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "e856fecdad9ecd4960731d940a36a796", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Fix VACUUM's tests to see whether it can update relfrozenxid", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2120ae1b60ab99c872851c49d00100a9ec8458028d02a05da1fb5639c6e4b18c"}, "url": "/docs/compare/?release=9.3.2#9.3.2-b6f10ca65f634275", "source_url": "/docs/release/9.3.2/#AEN118826"}]}, {"id": "9.2.6-cf6f574969d9743c", "cves": [], "html": "Fix initialization of pg_clog and pg_subtrans during hot standby startup (Andres Freund, Heikki Linnakangas)
\nThis bug can cause data loss on standby servers at the moment they start to accept hot-standby queries, by marking committed transactions as uncommitted. The likelihood of such corruption is small unless, at the time of standby startup, the primary server has executed many updating transactions since its last checkpoint. Symptoms include missing rows, rows that should have been deleted being still visible, and obsolete versions of updated rows being still visible alongside their newer versions.
\nThis bug was introduced in versions 9.3.0, 9.2.5, 9.1.10, and 9.0.14. Standby servers that have only been running earlier releases are not at risk. It's recommended that standby servers that have ever run any of the buggy releases be re-cloned from the primary (e.g., with a new base backup) after upgrading.
", "text": "Fix initialization of pg_clog and pg_subtrans during hot standby startup (Andres Freund, Heikki Linnakangas) This bug can cause data loss on standby servers at the moment they start to accept hot-standby queries, by marking committed transactions as uncommitted. The likelihood of such corruption is small unless, at the time of standby startup, the primary server has executed many updating transactions since its last checkpoint. Symptoms include missing rows, rows that should have been deleted being still visible, and obsolete versions of updated rows being still visible alongside their newer versions. This bug was introduced in versions 9.3.0, 9.2.5, 9.1.10, and 9.0.14. Standby servers that have only been running earlier releases are not at risk. It's recommended that standby servers that have ever run any of the buggy releases be re-cloned from the primary (e.g., with a new base backup) after upgrading.", "title": "Fix initialization of pg_clog and pg_subtrans during hot standby startup", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "6dae40bcb201811047a319c5216ac6bec23e8131658441c15860b671bc23ed18", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix initialization of pg_clog and pg_subtrans during hot standby startup (Andres Freund, Heikki Linnakangas) This bug can cause data loss on standby servers at the moment they start to accept hot-standby queries, by marking committed transactions as uncommitted. The likelihood of such corruption is small unless, at the time of standby startup, the primary server has executed many updating transactions since its last checkpoint. Symptoms include missing rows, rows that should have been deleted being still visible, and obsolete versions of updated rows being still visible alongside their newer versions. This bug was introduced in versions 9.3.0, 9.2.5, 9.1.10, and 9.0.14. Standby servers that have only been running earlier releases are not at risk. It's recommended that standby servers that have ever run any of the buggy releases be re-cloned from the primary (e.g., with a new base backup) after upgrading.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/002", "db_id": "901efd8aebaf77a6339dc8eb68def63e", "patch_ids": [], "statement_hash": "4611244681fcbdfbcafaa4c61bd63516f6a7f240970fa8e7ac1910a4cda32913", "relations": [{"rule": 2, "type": "equivalent", "target": "0ef1879d1e53afd7f1388c2bfb67b1d4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4611244681fcbdfbcafaa4c61bd63516f6a7f240970fa8e7ac1910a4cda32913"}}, {"rule": 2, "type": "equivalent", "target": "4354cc947d1a9e224823cb48f97baa29", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4611244681fcbdfbcafaa4c61bd63516f6a7f240970fa8e7ac1910a4cda32913"}}, {"rule": 2, "type": "equivalent", "target": "be0f921e1ac97bf95d24f7ccbbfc3cd4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4611244681fcbdfbcafaa4c61bd63516f6a7f240970fa8e7ac1910a4cda32913"}}], "version": "9.2.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4354cc947d1a9e224823cb48f97baa29", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Fix initialization of pg_clog and pg_subtrans during hot standby startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4611244681fcbdfbcafaa4c61bd63516f6a7f240970fa8e7ac1910a4cda32913"}, "url": "/docs/compare/?release=9.3.2#9.3.2-cf6f574969d9743c", "source_url": "/docs/release/9.3.2/#AEN118826"}, {"db_id": "0ef1879d1e53afd7f1388c2bfb67b1d4", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "Fix initialization of pg_clog and pg_subtrans during hot standby startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4611244681fcbdfbcafaa4c61bd63516f6a7f240970fa8e7ac1910a4cda32913"}, "url": "/docs/compare/?release=9.1.11#9.1.11-cf6f574969d9743c", "source_url": "/docs/release/9.1.11/#AEN108742"}, {"db_id": "be0f921e1ac97bf95d24f7ccbbfc3cd4", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "Fix initialization of pg_clog and pg_subtrans during hot standby startup", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "4611244681fcbdfbcafaa4c61bd63516f6a7f240970fa8e7ac1910a4cda32913"}, "url": "/docs/compare/?release=9.0.15#9.0.15-cf6f574969d9743c", "source_url": "/docs/release/9.0.15/#AEN100394"}]}, {"id": "9.2.6-a92d08a9658d727e", "cves": [], "html": "Fix dangling-pointer problem in fast-path locking (Tom Lane)
\nThis could lead to corruption of the lock data structures in shared memory, causing \"lock already held\" and other odd errors.
", "text": "Fix dangling-pointer problem in fast-path locking (Tom Lane) This could lead to corruption of the lock data structures in shared memory, causing \"lock already held\" and other odd errors.", "title": "Fix dangling-pointer problem in fast-path locking", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "2281a33a72c79d471ed91e5a642290940d5f53ada32063fe715c56e34374ff67", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix dangling-pointer problem in fast-path locking (Tom Lane) This could lead to corruption of the lock data structures in shared memory, causing lock already held and other odd errors.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/003", "db_id": "2486a4438d3abc57225f8f26b280fe9f", "patch_ids": [], "statement_hash": "020f282ee518184028bea679963a34d1570c06bcb386bbea1109a99c6d72a8bc", "relations": [{"rule": 2, "type": "equivalent", "target": "c517f677b2703c4049cc3bf0adc59a4b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "020f282ee518184028bea679963a34d1570c06bcb386bbea1109a99c6d72a8bc"}}], "version": "9.2.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c517f677b2703c4049cc3bf0adc59a4b", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Fix dangling-pointer problem in fast-path locking", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "020f282ee518184028bea679963a34d1570c06bcb386bbea1109a99c6d72a8bc"}, "url": "/docs/compare/?release=9.3.2#9.3.2-a92d08a9658d727e", "source_url": "/docs/release/9.3.2/#AEN118826"}]}, {"id": "9.2.6-4e91516670d26a1d", "cves": [], "html": "Truncate pg_multixact contents during WAL replay (Andres Freund)
\nThis avoids ever-increasing disk space consumption in standby servers.
", "text": "Truncate pg_multixact contents during WAL replay (Andres Freund) This avoids ever-increasing disk space consumption in standby servers.", "title": "Truncate pg_multixact contents during WAL replay", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "1f0e1d3f4baab9df0a9d0dd015b5991613eb990edad968ec1234a9d36ac3aa2e", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Truncate pg_multixact contents during WAL replay (Andres Freund) This avoids ever-increasing disk space consumption in standby servers.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/004", "db_id": "714c9a65006f2669cc88af918eeedf2d", "patch_ids": [], "statement_hash": "29faa1b46cf68bb6bb0936f1efff9ff5cbf3126d3a02443747732ea2953a8938", "relations": [{"rule": 2, "type": "equivalent", "target": "2ab09ab16fc74bcd964e8dbf67d0b5a0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29faa1b46cf68bb6bb0936f1efff9ff5cbf3126d3a02443747732ea2953a8938"}}, {"rule": 2, "type": "equivalent", "target": "bba9adb4cf79576fe7660d52aac70f83", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29faa1b46cf68bb6bb0936f1efff9ff5cbf3126d3a02443747732ea2953a8938"}}, {"rule": 2, "type": "equivalent", "target": "cd2378a1b741e9efcd50ec64673f309e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29faa1b46cf68bb6bb0936f1efff9ff5cbf3126d3a02443747732ea2953a8938"}}], "version": "9.2.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "cd2378a1b741e9efcd50ec64673f309e", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Truncate pg_multixact contents during WAL replay", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29faa1b46cf68bb6bb0936f1efff9ff5cbf3126d3a02443747732ea2953a8938"}, "url": "/docs/compare/?release=9.3.2#9.3.2-4e91516670d26a1d", "source_url": "/docs/release/9.3.2/#AEN118826"}, {"db_id": "2ab09ab16fc74bcd964e8dbf67d0b5a0", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "Truncate pg_multixact contents during WAL replay", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29faa1b46cf68bb6bb0936f1efff9ff5cbf3126d3a02443747732ea2953a8938"}, "url": "/docs/compare/?release=9.1.11#9.1.11-4e91516670d26a1d", "source_url": "/docs/release/9.1.11/#AEN108742"}, {"db_id": "bba9adb4cf79576fe7660d52aac70f83", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "Truncate pg_multixact contents during WAL replay", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "29faa1b46cf68bb6bb0936f1efff9ff5cbf3126d3a02443747732ea2953a8938"}, "url": "/docs/compare/?release=9.0.15#9.0.15-4e91516670d26a1d", "source_url": "/docs/release/9.0.15/#AEN100394"}]}, {"id": "9.2.6-45aef96314736c20", "cves": [], "html": "Ensure an anti-wraparound VACUUM counts a page as scanned when it's only verified that no tuples need freezing (Sergey Burladyan, Jeff Janes)
\nThis bug could result in failing to advance relfrozenxid, so that the table would still be thought to need another anti-wraparound vacuum. In the worst case the database might even shut down to prevent wraparound.
", "text": "Ensure an anti-wraparound VACUUM counts a page as scanned when it's only verified that no tuples need freezing (Sergey Burladyan, Jeff Janes) This bug could result in failing to advance relfrozenxid, so that the table would still be thought to need another anti-wraparound vacuum. In the worst case the database might even shut down to prevent wraparound.", "title": "Ensure an anti-wraparound VACUUM counts a page as scanned when it's only verified that no tuples need freezing", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "a07069e7032656a65069bd4efc178198f7dc2888af77d5127282c75fe898994e", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Ensure an anti-wraparound VACUUM counts a page as scanned when it's only verified that no tuples need freezing (Sergey Burladyan, Jeff Janes) This bug could result in failing to advance relfrozenxid, so that the table would still be thought to need another anti-wraparound vacuum. In the worst case the database might even shut down to prevent wraparound.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/005", "db_id": "eaa899b49990c5cfa6a56551435f82af", "patch_ids": [], "statement_hash": "d8c65a4738849d16aa8bcf7fda08e5a8994a997950a31a7af75ae91f79fe481b", "relations": [{"rule": 2, "type": "equivalent", "target": "7ea998c16fef7ac669aedea035a9af76", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d8c65a4738849d16aa8bcf7fda08e5a8994a997950a31a7af75ae91f79fe481b"}}], "version": "9.2.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "7ea998c16fef7ac669aedea035a9af76", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Ensure an anti-wraparound VACUUM counts a page as scanned when it's only verified that no tuples need freezing", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d8c65a4738849d16aa8bcf7fda08e5a8994a997950a31a7af75ae91f79fe481b"}, "url": "/docs/compare/?release=9.3.2#9.3.2-45aef96314736c20", "source_url": "/docs/release/9.3.2/#AEN118826"}]}, {"id": "9.2.6-b89a2354c45829a0", "cves": [], "html": "Fix race condition in GIN index posting tree page deletion (Heikki Linnakangas)
\nThis could lead to transient wrong answers or query failures.
", "text": "Fix race condition in GIN index posting tree page deletion (Heikki Linnakangas) This could lead to transient wrong answers or query failures.", "title": "Fix race condition in GIN index posting tree page deletion", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "91c8de29d0767b8dc6411f04e599bafa6ec014779ade9cf26fab54b16b59c731", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix race condition in GIN index posting tree page deletion (Heikki Linnakangas) This could lead to transient wrong answers or query failures.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/006", "db_id": "e61288b4d8d31e702a099b6c442953d6", "patch_ids": [], "statement_hash": "361069838280eea16e9ef539e7627e35249581b15690457108420218bf8de9a0", "relations": [{"rule": 2, "type": "equivalent", "target": "789d7ff24e2fea7a05dbdfb17d12c20d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "361069838280eea16e9ef539e7627e35249581b15690457108420218bf8de9a0"}}, {"rule": 2, "type": "equivalent", "target": "96fd2c00f600bb1490cdeef970027a27", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "361069838280eea16e9ef539e7627e35249581b15690457108420218bf8de9a0"}}, {"rule": 2, "type": "equivalent", "target": "c05264daf32f008727a03c0e9d1634dc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "361069838280eea16e9ef539e7627e35249581b15690457108420218bf8de9a0"}}], "version": "9.2.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c05264daf32f008727a03c0e9d1634dc", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Fix race condition in GIN index posting tree page deletion", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "361069838280eea16e9ef539e7627e35249581b15690457108420218bf8de9a0"}, "url": "/docs/compare/?release=9.3.2#9.3.2-b89a2354c45829a0", "source_url": "/docs/release/9.3.2/#AEN118826"}, {"db_id": "96fd2c00f600bb1490cdeef970027a27", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "Fix race condition in GIN index posting tree page deletion", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "361069838280eea16e9ef539e7627e35249581b15690457108420218bf8de9a0"}, "url": "/docs/compare/?release=9.1.11#9.1.11-b89a2354c45829a0", "source_url": "/docs/release/9.1.11/#AEN108742"}, {"db_id": "789d7ff24e2fea7a05dbdfb17d12c20d", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "Fix race condition in GIN index posting tree page deletion", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "361069838280eea16e9ef539e7627e35249581b15690457108420218bf8de9a0"}, "url": "/docs/compare/?release=9.0.15#9.0.15-b89a2354c45829a0", "source_url": "/docs/release/9.0.15/#AEN100394"}]}, {"id": "9.2.6-7b240f390c753ec3", "cves": [], "html": "Fix \"unexpected spgdoinsert() failure\" error during SP-GiST index creation (Teodor Sigaev)
", "text": "Fix \"unexpected spgdoinsert() failure\" error during SP-GiST index creation (Teodor Sigaev)", "title": "Fix \"unexpected spgdoinsert() failure\" error during SP-GiST index creation", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "2a5d1537535ba108c10568526b596f39a18cfb6f76e742546ae4c5126c4202dd", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix unexpected spgdoinsert() failure error during SP-GiST index creation (Teodor Sigaev)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/007", "db_id": "8109c1b7fda854702607ce1bf1c239d5", "patch_ids": [], "statement_hash": "9c38bae562368fd9cea0a62122d3cf8c44e2d57919b1618df75fe92f145c52b0", "relations": [{"rule": 2, "type": "equivalent", "target": "2b98839819d91f11cc4139cc49119418", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9c38bae562368fd9cea0a62122d3cf8c44e2d57919b1618df75fe92f145c52b0"}}], "version": "9.2.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "2b98839819d91f11cc4139cc49119418", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Fix \"unexpected spgdoinsert() failure\" error during SP-GiST index creation", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9c38bae562368fd9cea0a62122d3cf8c44e2d57919b1618df75fe92f145c52b0"}, "url": "/docs/compare/?release=9.3.2#9.3.2-7b240f390c753ec3", "source_url": "/docs/release/9.3.2/#AEN118826"}]}, {"id": "9.2.6-0389cdf46696f4ca", "cves": [], "html": "Avoid flattening a subquery whose SELECT list contains a volatile function wrapped inside a sub-SELECT (Tom Lane)
\nThis avoids unexpected results due to extra evaluations of the volatile function.
", "text": "Avoid flattening a subquery whose SELECT list contains a volatile function wrapped inside a sub-SELECT (Tom Lane) This avoids unexpected results due to extra evaluations of the volatile function.", "title": "Avoid flattening a subquery whose SELECT list contains a volatile function wrapped inside a sub-SELECT", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "36f673840f0b68373a4bec3cac1343cbc17356df61e0c217db78552e5897858d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid flattening a subquery whose SELECT list contains a volatile function wrapped inside a sub-SELECT (Tom Lane) This avoids unexpected results due to extra evaluations of the volatile function.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/008", "db_id": "f9bdc2a201976a72575aab9fdbdd57b1", "patch_ids": [], "statement_hash": "f1ea247a1af9ea49cc4c1f3f7800a33edd46ef276b227c080eb986bde425a4bb", "relations": [{"rule": 2, "type": "equivalent", "target": "097f89eb3d95a428d6d9eb09740567b8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f1ea247a1af9ea49cc4c1f3f7800a33edd46ef276b227c080eb986bde425a4bb"}}, {"rule": 2, "type": "equivalent", "target": "df73986505d42b26f2af65e7291f2c03", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f1ea247a1af9ea49cc4c1f3f7800a33edd46ef276b227c080eb986bde425a4bb"}}, {"rule": 2, "type": "equivalent", "target": "e9f8dfb4a813cd5095b24d286270230d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f1ea247a1af9ea49cc4c1f3f7800a33edd46ef276b227c080eb986bde425a4bb"}}], "version": "9.2.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "df73986505d42b26f2af65e7291f2c03", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Avoid flattening a subquery whose SELECT list contains a volatile function wrapped inside a sub-SELECT", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f1ea247a1af9ea49cc4c1f3f7800a33edd46ef276b227c080eb986bde425a4bb"}, "url": "/docs/compare/?release=9.3.2#9.3.2-0389cdf46696f4ca", "source_url": "/docs/release/9.3.2/#AEN118826"}, {"db_id": "e9f8dfb4a813cd5095b24d286270230d", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "Avoid flattening a subquery whose SELECT list contains a volatile function wrapped inside a sub-SELECT", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f1ea247a1af9ea49cc4c1f3f7800a33edd46ef276b227c080eb986bde425a4bb"}, "url": "/docs/compare/?release=9.1.11#9.1.11-0389cdf46696f4ca", "source_url": "/docs/release/9.1.11/#AEN108742"}, {"db_id": "097f89eb3d95a428d6d9eb09740567b8", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "Avoid flattening a subquery whose SELECT list contains a volatile function wrapped inside a sub-SELECT", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f1ea247a1af9ea49cc4c1f3f7800a33edd46ef276b227c080eb986bde425a4bb"}, "url": "/docs/compare/?release=9.0.15#9.0.15-0389cdf46696f4ca", "source_url": "/docs/release/9.0.15/#AEN100394"}]}, {"id": "9.2.6-0ef5770dd4aafb4a", "cves": [], "html": "Fix planner's processing of non-simple-variable subquery outputs nested within outer joins (Tom Lane)
\nThis error could lead to incorrect plans for queries involving multiple levels of subqueries within JOIN syntax.
", "text": "Fix planner's processing of non-simple-variable subquery outputs nested within outer joins (Tom Lane) This error could lead to incorrect plans for queries involving multiple levels of subqueries within JOIN syntax.", "title": "Fix planner's processing of non-simple-variable subquery outputs nested within outer joins", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "ada1ec4664f7285e5b564fd30bda2445696ab35d571a477e36c3f2f7fecc4f3d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix planner's processing of non-simple-variable subquery outputs nested within outer joins (Tom Lane) This error could lead to incorrect plans for queries involving multiple levels of subqueries within JOIN syntax.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/009", "db_id": "eb5dca2b440ae228ba854c17897dc4be", "patch_ids": [], "statement_hash": "eedf8e5c1fb5dfd7ba629eddc6543b5925c6245cd1a3b2fed4c345035f8a955f", "relations": [{"rule": 2, "type": "equivalent", "target": "83db0c7067a3dd635b0fc421851c89f0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eedf8e5c1fb5dfd7ba629eddc6543b5925c6245cd1a3b2fed4c345035f8a955f"}}, {"rule": 2, "type": "equivalent", "target": "bfd610ae371a5c43bd8012820ecdbb5c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eedf8e5c1fb5dfd7ba629eddc6543b5925c6245cd1a3b2fed4c345035f8a955f"}}, {"rule": 2, "type": "equivalent", "target": "e43436cc1913184a43329fe231db587c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eedf8e5c1fb5dfd7ba629eddc6543b5925c6245cd1a3b2fed4c345035f8a955f"}}], "version": "9.2.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "83db0c7067a3dd635b0fc421851c89f0", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Fix planner's processing of non-simple-variable subquery outputs nested within outer joins", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eedf8e5c1fb5dfd7ba629eddc6543b5925c6245cd1a3b2fed4c345035f8a955f"}, "url": "/docs/compare/?release=9.3.2#9.3.2-0ef5770dd4aafb4a", "source_url": "/docs/release/9.3.2/#AEN118826"}, {"db_id": "e43436cc1913184a43329fe231db587c", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "Fix planner's processing of non-simple-variable subquery outputs nested within outer joins", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eedf8e5c1fb5dfd7ba629eddc6543b5925c6245cd1a3b2fed4c345035f8a955f"}, "url": "/docs/compare/?release=9.1.11#9.1.11-0ef5770dd4aafb4a", "source_url": "/docs/release/9.1.11/#AEN108742"}, {"db_id": "bfd610ae371a5c43bd8012820ecdbb5c", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "Fix planner's processing of non-simple-variable subquery outputs nested within outer joins", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eedf8e5c1fb5dfd7ba629eddc6543b5925c6245cd1a3b2fed4c345035f8a955f"}, "url": "/docs/compare/?release=9.0.15#9.0.15-0ef5770dd4aafb4a", "source_url": "/docs/release/9.0.15/#AEN100394"}]}, {"id": "9.2.6-3b10710aa99a6483", "cves": [], "html": "Fix incorrect planning in cases where the same non-strict expression appears in multiple WHERE and outer JOIN equality clauses (Tom Lane)
", "text": "Fix incorrect planning in cases where the same non-strict expression appears in multiple WHERE and outer JOIN equality clauses (Tom Lane)", "title": "Fix incorrect planning in cases where the same non-strict expression appears in multiple WHERE and outer JOIN equality clauses", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "e3a850ddf6442b802a47bbdf0a2809e696511c0747cc49904f7a75f451a3993d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix incorrect planning in cases where the same non-strict expression appears in multiple WHERE and outer JOIN equality clauses (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/010", "db_id": "7fb0525b25e0ba989e91179903b4e15d", "patch_ids": [], "statement_hash": "1a07cde888787578e0cd41391ad15a4d650634bbefd7c44ec3fd05e42482c962", "relations": [{"rule": 2, "type": "equivalent", "target": "e60892c36d1507ec27e6b3b2c9dd065f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1a07cde888787578e0cd41391ad15a4d650634bbefd7c44ec3fd05e42482c962"}}], "version": "9.2.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "e60892c36d1507ec27e6b3b2c9dd065f", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Fix incorrect planning in cases where the same non-strict expression appears in multiple WHERE and outer JOIN equality clauses", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "1a07cde888787578e0cd41391ad15a4d650634bbefd7c44ec3fd05e42482c962"}, "url": "/docs/compare/?release=9.3.2#9.3.2-3b10710aa99a6483", "source_url": "/docs/release/9.3.2/#AEN118826"}]}, {"id": "9.2.6-b8259a68f1755e98", "cves": [], "html": "Fix planner crash with whole-row reference to a subquery (Tom Lane)
", "text": "Fix planner crash with whole-row reference to a subquery (Tom Lane)", "title": "Fix planner crash with whole-row reference to a subquery", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "412ac78a3f4fc515185c01ccda6211c2bce9451bef109ba0d5b5f68481ae58b5", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix planner crash with whole-row reference to a subquery (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/011", "db_id": "a9ca73f6071f71970df2f90376ffdad3", "patch_ids": [], "statement_hash": "179c1e2f723447912f0b97ac0f27d79b59627b35ba60a2e92d50e1e687c869e6", "relations": [{"rule": 2, "type": "equivalent", "target": "a569976016af70e6b700555b04ab6a5d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "179c1e2f723447912f0b97ac0f27d79b59627b35ba60a2e92d50e1e687c869e6"}}], "version": "9.2.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "a569976016af70e6b700555b04ab6a5d", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Fix planner crash with whole-row reference to a subquery", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "179c1e2f723447912f0b97ac0f27d79b59627b35ba60a2e92d50e1e687c869e6"}, "url": "/docs/compare/?release=9.3.2#9.3.2-b8259a68f1755e98", "source_url": "/docs/release/9.3.2/#AEN118826"}]}, {"id": "9.2.6-63d26ce2858b714a", "cves": [], "html": "Fix incorrect generation of optimized MIN()/MAX() plans for inheritance trees (Tom Lane)
\nThe planner could fail in cases where the MIN()/MAX() argument was an expression rather than a simple variable.
", "text": "Fix incorrect generation of optimized MIN()/MAX() plans for inheritance trees (Tom Lane) The planner could fail in cases where the MIN()/MAX() argument was an expression rather than a simple variable.", "title": "Fix incorrect generation of optimized MIN()/MAX() plans for inheritance trees", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "cea3433b008f7c49859e05e9da2ee8207bd997bc151d0b278522d86eab2b4d01", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix incorrect generation of optimized MIN()/MAX() plans for inheritance trees (Tom Lane) The planner could fail in cases where the MIN()/MAX() argument was an expression rather than a simple variable.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/012", "db_id": "f01f8238f135123e84d73bcc9822e19d", "patch_ids": [], "statement_hash": "cdc4f628005617b6d51f3e5befa42b906f36bae45e9832781c08e18b4b81bd61", "relations": [{"rule": 2, "type": "equivalent", "target": "339ffd90456fa9cba8be03a6d01df826", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cdc4f628005617b6d51f3e5befa42b906f36bae45e9832781c08e18b4b81bd61"}}, {"rule": 2, "type": "equivalent", "target": "c8d909f561ae33e6df161be0742d3c51", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cdc4f628005617b6d51f3e5befa42b906f36bae45e9832781c08e18b4b81bd61"}}], "version": "9.2.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c8d909f561ae33e6df161be0742d3c51", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Fix incorrect generation of optimized MIN()/MAX() plans for inheritance trees", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cdc4f628005617b6d51f3e5befa42b906f36bae45e9832781c08e18b4b81bd61"}, "url": "/docs/compare/?release=9.3.2#9.3.2-63d26ce2858b714a", "source_url": "/docs/release/9.3.2/#AEN118826"}, {"db_id": "339ffd90456fa9cba8be03a6d01df826", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "Fix incorrect generation of optimized MIN()/MAX() plans for inheritance trees", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "cdc4f628005617b6d51f3e5befa42b906f36bae45e9832781c08e18b4b81bd61"}, "url": "/docs/compare/?release=9.1.11#9.1.11-63d26ce2858b714a", "source_url": "/docs/release/9.1.11/#AEN108742"}]}, {"id": "9.2.6-38a6d7ef5fc14fae", "cves": [], "html": "Fix premature deletion of temporary files (Andres Freund)
", "text": "Fix premature deletion of temporary files (Andres Freund)", "title": "Fix premature deletion of temporary files", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "e5e91dd3a5106b0714f7cf93ae357cce871b0b72eb44ebc2466cb59f7abc8403", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix premature deletion of temporary files (Andres Freund)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/013", "db_id": "60928172601d5b6dda085390441c12fa", "patch_ids": [], "statement_hash": "3119a2cb4319db76d2a1881224b309ca85f6beeebce5a68d55b6318fc5c29355", "relations": [{"rule": 2, "type": "equivalent", "target": "0215f444a73bfa2ac623668492cbf9da", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3119a2cb4319db76d2a1881224b309ca85f6beeebce5a68d55b6318fc5c29355"}}, {"rule": 2, "type": "equivalent", "target": "794c783639e28fe65ce37ad20e41d06f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3119a2cb4319db76d2a1881224b309ca85f6beeebce5a68d55b6318fc5c29355"}}, {"rule": 2, "type": "equivalent", "target": "eea4af0d1602c8ce09fc3f6cf6e9923f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3119a2cb4319db76d2a1881224b309ca85f6beeebce5a68d55b6318fc5c29355"}}], "version": "9.2.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "794c783639e28fe65ce37ad20e41d06f", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Fix premature deletion of temporary files", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3119a2cb4319db76d2a1881224b309ca85f6beeebce5a68d55b6318fc5c29355"}, "url": "/docs/compare/?release=9.3.2#9.3.2-38a6d7ef5fc14fae", "source_url": "/docs/release/9.3.2/#AEN118826"}, {"db_id": "eea4af0d1602c8ce09fc3f6cf6e9923f", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "Fix premature deletion of temporary files", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3119a2cb4319db76d2a1881224b309ca85f6beeebce5a68d55b6318fc5c29355"}, "url": "/docs/compare/?release=9.1.11#9.1.11-38a6d7ef5fc14fae", "source_url": "/docs/release/9.1.11/#AEN108742"}, {"db_id": "0215f444a73bfa2ac623668492cbf9da", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "Fix premature deletion of temporary files", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3119a2cb4319db76d2a1881224b309ca85f6beeebce5a68d55b6318fc5c29355"}, "url": "/docs/compare/?release=9.0.15#9.0.15-38a6d7ef5fc14fae", "source_url": "/docs/release/9.0.15/#AEN100394"}]}, {"id": "9.2.6-bc7085651541432e", "cves": [], "html": "Prevent intra-transaction memory leak when printing range values (Tom Lane)
\nThis fix actually cures transient memory leaks in any datatype output function, but range types are the only ones known to have had a significant problem.
", "text": "Prevent intra-transaction memory leak when printing range values (Tom Lane) This fix actually cures transient memory leaks in any datatype output function, but range types are the only ones known to have had a significant problem.", "title": "Prevent intra-transaction memory leak when printing range values", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "c0f815efe44a4d5ad93c7c35306eab22cdd02d4e772a81c88c35a260a8a55ef8", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent intra-transaction memory leak when printing range values (Tom Lane) This fix actually cures transient memory leaks in any datatype output function, but range types are the only ones known to have had a significant problem.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/014", "db_id": "e4f07bc495985d5f3a2f0c0033ac58a0", "patch_ids": [], "statement_hash": "fcb0b015590f6d5b196f3085f0ec4717cc0e91e1131380314f3bedc5204621de", "relations": [{"rule": 2, "type": "equivalent", "target": "fa91aece2c4def2398ffacd427ff008f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fcb0b015590f6d5b196f3085f0ec4717cc0e91e1131380314f3bedc5204621de"}}], "version": "9.2.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "fa91aece2c4def2398ffacd427ff008f", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Prevent intra-transaction memory leak when printing range values", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fcb0b015590f6d5b196f3085f0ec4717cc0e91e1131380314f3bedc5204621de"}, "url": "/docs/compare/?release=9.3.2#9.3.2-bc7085651541432e", "source_url": "/docs/release/9.3.2/#AEN118826"}]}, {"id": "9.2.6-4dfca88b75babb49", "cves": [], "html": "Prevent incorrect display of dropped columns in NOT NULL and CHECK constraint violation messages (Michael Paquier and Tom Lane)
", "text": "Prevent incorrect display of dropped columns in NOT NULL and CHECK constraint violation messages (Michael Paquier and Tom Lane)", "title": "Prevent incorrect display of dropped columns in NOT NULL and CHECK constraint violation messages", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "586d005abc73af1d69b3646614a68b286614dcb0a83f50548d4419357b72be8b", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent incorrect display of dropped columns in NOT NULL and CHECK constraint violation messages (Michael Paquier and Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/015", "db_id": "f042db5bc5ef684661e5a3ee5d1741d4", "patch_ids": [], "statement_hash": "5e971ef7855dd62c24022dabf41e47ec1898e43ffb391ade31e97b7155bf615b", "relations": [{"rule": 2, "type": "equivalent", "target": "9a9cdbc2ea819cba1ca239f19de50ecc", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5e971ef7855dd62c24022dabf41e47ec1898e43ffb391ade31e97b7155bf615b"}}], "version": "9.2.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "9a9cdbc2ea819cba1ca239f19de50ecc", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Prevent incorrect display of dropped columns in NOT NULL and CHECK constraint violation messages", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5e971ef7855dd62c24022dabf41e47ec1898e43ffb391ade31e97b7155bf615b"}, "url": "/docs/compare/?release=9.3.2#9.3.2-4dfca88b75babb49", "source_url": "/docs/release/9.3.2/#AEN118826"}]}, {"id": "9.2.6-d0f956b362829fd5", "cves": [], "html": "Allow default arguments and named-argument notation for window functions (Tom Lane)
\nPreviously, these cases were likely to crash.
", "text": "Allow default arguments and named-argument notation for window functions (Tom Lane) Previously, these cases were likely to crash.", "title": "Allow default arguments and named-argument notation for window functions", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "5b500017abb9ef4cdeeea04082ca2d21fdb9098ebed936deecb5e21e7519c47a", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Allow default arguments and named-argument notation for window functions (Tom Lane) Previously, these cases were likely to crash.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/016", "db_id": "08d74fbaaca370df8f0371f1ccab6f9a", "patch_ids": [], "statement_hash": "a2c8bf238db48fc6d86051097c35bfa514e17314aae8a44ceef651dbb5b64d5b", "relations": [{"rule": 2, "type": "equivalent", "target": "db2d61b2cd6d9a46030ac60bebe9d59a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a2c8bf238db48fc6d86051097c35bfa514e17314aae8a44ceef651dbb5b64d5b"}}], "version": "9.2.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "db2d61b2cd6d9a46030ac60bebe9d59a", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Allow default arguments and named-argument notation for window functions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a2c8bf238db48fc6d86051097c35bfa514e17314aae8a44ceef651dbb5b64d5b"}, "url": "/docs/compare/?release=9.3.2#9.3.2-d0f956b362829fd5", "source_url": "/docs/release/9.3.2/#AEN118826"}]}, {"id": "9.2.6-4975e1d7adf77516", "cves": [], "html": "Fix possible read past end of memory in rule printing (Peter Eisentraut)
", "text": "Fix possible read past end of memory in rule printing (Peter Eisentraut)", "title": "Fix possible read past end of memory in rule printing", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "b7e02dbd5dcef5e0a25f1d8c9c6836cfec403ca5c343aa0aedf299f85ce04093", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix possible read past end of memory in rule printing (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/017", "db_id": "faa18fe51c0b4eebc64a07aeca34c7e2", "patch_ids": [], "statement_hash": "5e488ca5a20725bf6dbab20d569a58aa64ec0fa9a96803f768b8335050d79762", "relations": [{"rule": 2, "type": "equivalent", "target": "52a1895a8d0fca9d245787982a39c754", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5e488ca5a20725bf6dbab20d569a58aa64ec0fa9a96803f768b8335050d79762"}}, {"rule": 2, "type": "equivalent", "target": "5f850f0c90891244795995e7648334db", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5e488ca5a20725bf6dbab20d569a58aa64ec0fa9a96803f768b8335050d79762"}}, {"rule": 2, "type": "equivalent", "target": "ced8771b6066f828b8d7a8a2dfbfed08", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5e488ca5a20725bf6dbab20d569a58aa64ec0fa9a96803f768b8335050d79762"}}], "version": "9.2.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "52a1895a8d0fca9d245787982a39c754", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Fix possible read past end of memory in rule printing", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5e488ca5a20725bf6dbab20d569a58aa64ec0fa9a96803f768b8335050d79762"}, "url": "/docs/compare/?release=9.3.2#9.3.2-4975e1d7adf77516", "source_url": "/docs/release/9.3.2/#AEN118826"}, {"db_id": "5f850f0c90891244795995e7648334db", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "Fix possible read past end of memory in rule printing", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5e488ca5a20725bf6dbab20d569a58aa64ec0fa9a96803f768b8335050d79762"}, "url": "/docs/compare/?release=9.1.11#9.1.11-4975e1d7adf77516", "source_url": "/docs/release/9.1.11/#AEN108742"}, {"db_id": "ced8771b6066f828b8d7a8a2dfbfed08", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "Fix possible read past end of memory in rule printing", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "5e488ca5a20725bf6dbab20d569a58aa64ec0fa9a96803f768b8335050d79762"}, "url": "/docs/compare/?release=9.0.15#9.0.15-4975e1d7adf77516", "source_url": "/docs/release/9.0.15/#AEN100394"}]}, {"id": "9.2.6-fa9ff8670ce5756a", "cves": [], "html": "Fix array slicing of int2vector and oidvector values (Tom Lane)
\nExpressions of this kind are now implicitly promoted to regular int2 or oid arrays.
", "text": "Fix array slicing of int2vector and oidvector values (Tom Lane) Expressions of this kind are now implicitly promoted to regular int2 or oid arrays.", "title": "Fix array slicing of int2vector and oidvector values", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "61fb352f48de36bbce9e4cb28c4b4585b2bae1aa1de7eaeb58693792f2e64d20", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix array slicing of int2vector and oidvector values (Tom Lane) Expressions of this kind are now implicitly promoted to regular int2 or oid arrays.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/018", "db_id": "9be7bb1fc5e28d74cd34bda19911fca0", "patch_ids": [], "statement_hash": "77021f1107eec1c16ba347fb52395459b31a1b7c467927781e0dcbdef259a31e", "relations": [{"rule": 2, "type": "equivalent", "target": "13f4e2e1a5cc3f7f7d5cd9798bd393be", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "77021f1107eec1c16ba347fb52395459b31a1b7c467927781e0dcbdef259a31e"}}, {"rule": 2, "type": "equivalent", "target": "54de529e59b6fc81b5ec0feceb0e20de", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "77021f1107eec1c16ba347fb52395459b31a1b7c467927781e0dcbdef259a31e"}}, {"rule": 2, "type": "equivalent", "target": "6a8247adb515ac81561744f033628349", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "77021f1107eec1c16ba347fb52395459b31a1b7c467927781e0dcbdef259a31e"}}], "version": "9.2.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "13f4e2e1a5cc3f7f7d5cd9798bd393be", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Fix array slicing of int2vector and oidvector values", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "77021f1107eec1c16ba347fb52395459b31a1b7c467927781e0dcbdef259a31e"}, "url": "/docs/compare/?release=9.3.2#9.3.2-fa9ff8670ce5756a", "source_url": "/docs/release/9.3.2/#AEN118826"}, {"db_id": "6a8247adb515ac81561744f033628349", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "Fix array slicing of int2vector and oidvector values", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "77021f1107eec1c16ba347fb52395459b31a1b7c467927781e0dcbdef259a31e"}, "url": "/docs/compare/?release=9.1.11#9.1.11-fa9ff8670ce5756a", "source_url": "/docs/release/9.1.11/#AEN108742"}, {"db_id": "54de529e59b6fc81b5ec0feceb0e20de", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "Fix array slicing of int2vector and oidvector values", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "77021f1107eec1c16ba347fb52395459b31a1b7c467927781e0dcbdef259a31e"}, "url": "/docs/compare/?release=9.0.15#9.0.15-fa9ff8670ce5756a", "source_url": "/docs/release/9.0.15/#AEN100394"}]}, {"id": "9.2.6-614d1aed08d90926", "cves": [], "html": "Fix incorrect behaviors when using a SQL-standard, simple GMT offset timezone (Tom Lane)
\nIn some cases, the system would use the simple GMT offset value when it should have used the regular timezone setting that had prevailed before the simple offset was selected. This change also causes the timeofday function to honor the simple GMT offset zone.
Prevent possible misbehavior when logging translations of Windows error codes (Tom Lane)
", "text": "Prevent possible misbehavior when logging translations of Windows error codes (Tom Lane)", "title": "Prevent possible misbehavior when logging translations of Windows error codes", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "b534a69735517531237cb1d9be94f15b96841831c95d9f3733b41e4921cbb667", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent possible misbehavior when logging translations of Windows error codes (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/020", "db_id": "aeede94f946c1ded6bedcaa1abc527b3", "patch_ids": [], "statement_hash": "2f81cdd275a66bb7372ad55845ae169c02ed02ad108b59507118f7bf2cadec3b", "relations": [{"rule": 2, "type": "equivalent", "target": "11c80cc0b7a2fc53ad9812bcf14375c2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2f81cdd275a66bb7372ad55845ae169c02ed02ad108b59507118f7bf2cadec3b"}}, {"rule": 2, "type": "equivalent", "target": "13b0387ae30ee6ae7463f9d748e7dcf1", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2f81cdd275a66bb7372ad55845ae169c02ed02ad108b59507118f7bf2cadec3b"}}, {"rule": 2, "type": "equivalent", "target": "54820da474bebf8b921bae7f57eada98", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2f81cdd275a66bb7372ad55845ae169c02ed02ad108b59507118f7bf2cadec3b"}}], "version": "9.2.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "13b0387ae30ee6ae7463f9d748e7dcf1", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Prevent possible misbehavior when logging translations of Windows error codes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2f81cdd275a66bb7372ad55845ae169c02ed02ad108b59507118f7bf2cadec3b"}, "url": "/docs/compare/?release=9.3.2#9.3.2-ab675f3e842d1619", "source_url": "/docs/release/9.3.2/#AEN118826"}, {"db_id": "54820da474bebf8b921bae7f57eada98", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "Prevent possible misbehavior when logging translations of Windows error codes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2f81cdd275a66bb7372ad55845ae169c02ed02ad108b59507118f7bf2cadec3b"}, "url": "/docs/compare/?release=9.1.11#9.1.11-ab675f3e842d1619", "source_url": "/docs/release/9.1.11/#AEN108742"}, {"db_id": "11c80cc0b7a2fc53ad9812bcf14375c2", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "Prevent possible misbehavior when logging translations of Windows error codes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2f81cdd275a66bb7372ad55845ae169c02ed02ad108b59507118f7bf2cadec3b"}, "url": "/docs/compare/?release=9.0.15#9.0.15-ab675f3e842d1619", "source_url": "/docs/release/9.0.15/#AEN100394"}]}, {"id": "9.2.6-d7d9d630dea2068a", "cves": [], "html": "Properly quote generated command lines in pg_ctl (Naoya Anzai and Tom Lane)
\nThis fix applies only to Windows.
", "text": "Properly quote generated command lines in pg_ctl (Naoya Anzai and Tom Lane) This fix applies only to Windows.", "title": "Properly quote generated command lines in pg_ctl", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "7c654722e991126168400db1cb093d0408c5692c6d3cdb6f49dcd2208b8b9736", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Properly quote generated command lines in pg_ctl (Naoya Anzai and Tom Lane) This fix applies only to Windows.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/021", "db_id": "b1f08684e6cfbb31c79a0dccb63be1f8", "patch_ids": [], "statement_hash": "9e1fc4c55afd877c990135b900334b6624f58a4c56a45b03050a34c9fd4e355f", "relations": [{"rule": 2, "type": "equivalent", "target": "06ef602928ccb464f7de8ec282bf722b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9e1fc4c55afd877c990135b900334b6624f58a4c56a45b03050a34c9fd4e355f"}}, {"rule": 2, "type": "equivalent", "target": "8b28d4028101ea2d3477d14a5442e5f3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9e1fc4c55afd877c990135b900334b6624f58a4c56a45b03050a34c9fd4e355f"}}, {"rule": 2, "type": "equivalent", "target": "bbe0bde4d80cb9deabba661cfb328a9b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9e1fc4c55afd877c990135b900334b6624f58a4c56a45b03050a34c9fd4e355f"}}], "version": "9.2.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "bbe0bde4d80cb9deabba661cfb328a9b", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Properly quote generated command lines in pg_ctl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9e1fc4c55afd877c990135b900334b6624f58a4c56a45b03050a34c9fd4e355f"}, "url": "/docs/compare/?release=9.3.2#9.3.2-d7d9d630dea2068a", "source_url": "/docs/release/9.3.2/#AEN118826"}, {"db_id": "06ef602928ccb464f7de8ec282bf722b", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "Properly quote generated command lines in pg_ctl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9e1fc4c55afd877c990135b900334b6624f58a4c56a45b03050a34c9fd4e355f"}, "url": "/docs/compare/?release=9.1.11#9.1.11-d7d9d630dea2068a", "source_url": "/docs/release/9.1.11/#AEN108742"}, {"db_id": "8b28d4028101ea2d3477d14a5442e5f3", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "Properly quote generated command lines in pg_ctl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9e1fc4c55afd877c990135b900334b6624f58a4c56a45b03050a34c9fd4e355f"}, "url": "/docs/compare/?release=9.0.15#9.0.15-d7d9d630dea2068a", "source_url": "/docs/release/9.0.15/#AEN100394"}]}, {"id": "9.2.6-2b0ff9566f339929", "cves": [], "html": "Fix pg_dumpall to work when a source database sets default_transaction_read_only via ALTER DATABASE SET (Kevin Grittner)
\nPreviously, the generated script would fail during restore.
", "text": "Fix pg_dumpall to work when a source database sets default_transaction_read_only via ALTER DATABASE SET (Kevin Grittner) Previously, the generated script would fail during restore.", "title": "Fix pg_dumpall to work when a source database sets default_transaction_read_only via ALTER DATABASE SET", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "ddc1f4d975a82f4f14f87600c1439f1a838c022e32eb2c8312fa545b25203fe5", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix pg_dumpall to work when a source database sets default_transaction_read_only via ALTER DATABASE SET (Kevin Grittner) Previously, the generated script would fail during restore.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/022", "db_id": "af9bf6db44c025c5eb9a27b06c7074d4", "patch_ids": [], "statement_hash": "f566ed1155756fc0be4b5b06a7f2b4ae5f91129a5576307b194edab556032b8c", "relations": [{"rule": 2, "type": "equivalent", "target": "48525738e3d068e0af15f93585c27c23", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f566ed1155756fc0be4b5b06a7f2b4ae5f91129a5576307b194edab556032b8c"}}, {"rule": 2, "type": "equivalent", "target": "6185cd94f5d883265aac461185ec82d6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f566ed1155756fc0be4b5b06a7f2b4ae5f91129a5576307b194edab556032b8c"}}, {"rule": 2, "type": "equivalent", "target": "9f630319d7135ae6876108b30d324497", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f566ed1155756fc0be4b5b06a7f2b4ae5f91129a5576307b194edab556032b8c"}}], "version": "9.2.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "6185cd94f5d883265aac461185ec82d6", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Fix pg_dumpall to work when a source database sets default_transaction_read_only via ALTER DATABASE SET", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f566ed1155756fc0be4b5b06a7f2b4ae5f91129a5576307b194edab556032b8c"}, "url": "/docs/compare/?release=9.3.2#9.3.2-2b0ff9566f339929", "source_url": "/docs/release/9.3.2/#AEN118826"}, {"db_id": "9f630319d7135ae6876108b30d324497", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "Fix pg_dumpall to work when a source database sets default_transaction_read_only via ALTER DATABASE SET", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f566ed1155756fc0be4b5b06a7f2b4ae5f91129a5576307b194edab556032b8c"}, "url": "/docs/compare/?release=9.1.11#9.1.11-2b0ff9566f339929", "source_url": "/docs/release/9.1.11/#AEN108742"}, {"db_id": "48525738e3d068e0af15f93585c27c23", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "Fix pg_dumpall to work when a source database sets default_transaction_read_only via ALTER DATABASE SET", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f566ed1155756fc0be4b5b06a7f2b4ae5f91129a5576307b194edab556032b8c"}, "url": "/docs/compare/?release=9.0.15#9.0.15-2b0ff9566f339929", "source_url": "/docs/release/9.0.15/#AEN100394"}]}, {"id": "9.2.6-a642b4a86a13cdbe", "cves": [], "html": "Make ecpg search for quoted cursor names case-sensitively (Zoltán Böszörményi)
", "text": "Make ecpg search for quoted cursor names case-sensitively (Zoltán Böszörményi)", "title": "Make ecpg search for quoted cursor names case-sensitively", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "6df5cbd43360788b6b5779a71cab630f9d5042c45ce1635dd94e00855f77f7f4", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Make ecpg search for quoted cursor names case-sensitively (Zoltán Böszörményi)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/023", "db_id": "c56f1d7cc6c344b0e448dd10bfeaf87b", "patch_ids": [], "statement_hash": "ebd5c332236992b1020dd35801d4cc84554af80d2fb34ab014f90b36cbf4e1c4", "relations": [{"rule": 2, "type": "equivalent", "target": "664f2a70f76b238ff7461dd363b63e85", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ebd5c332236992b1020dd35801d4cc84554af80d2fb34ab014f90b36cbf4e1c4"}}, {"rule": 2, "type": "equivalent", "target": "9c81d9ba335c94e5da5b3d4e1131fc37", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ebd5c332236992b1020dd35801d4cc84554af80d2fb34ab014f90b36cbf4e1c4"}}], "version": "9.2.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "664f2a70f76b238ff7461dd363b63e85", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Make ecpg search for quoted cursor names case-sensitively", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ebd5c332236992b1020dd35801d4cc84554af80d2fb34ab014f90b36cbf4e1c4"}, "url": "/docs/compare/?release=9.3.2#9.3.2-a642b4a86a13cdbe", "source_url": "/docs/release/9.3.2/#AEN118826"}, {"db_id": "9c81d9ba335c94e5da5b3d4e1131fc37", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "Make ecpg search for quoted cursor names case-sensitively", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ebd5c332236992b1020dd35801d4cc84554af80d2fb34ab014f90b36cbf4e1c4"}, "url": "/docs/compare/?release=9.1.11#9.1.11-a642b4a86a13cdbe", "source_url": "/docs/release/9.1.11/#AEN108742"}]}, {"id": "9.2.6-610b408b9caa5c8a", "cves": [], "html": "Fix ecpg's processing of lists of variables declared varchar (Zoltán Böszörményi)
", "text": "Fix ecpg's processing of lists of variables declared varchar (Zoltán Böszörményi)", "title": "Fix ecpg's processing of lists of variables declared varchar", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "121fa10fd9b56cf238b3c1cb1fc0cb82f1aa650be0e89cdf1984b3b484ce6e21", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix ecpg's processing of lists of variables declared varchar (Zoltán Böszörményi)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/024", "db_id": "48a2db9656972f75ddf74f63fdada832", "patch_ids": [], "statement_hash": "9f7d0c921686af985b2a7e97d9f422fe9d039b0e5ac979b9a2c70d647b0fe2b5", "relations": [{"rule": 2, "type": "equivalent", "target": "2ddb8bb0d99ab38a47d5d489357b1f83", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9f7d0c921686af985b2a7e97d9f422fe9d039b0e5ac979b9a2c70d647b0fe2b5"}}, {"rule": 2, "type": "equivalent", "target": "409d0da964e2a790d4e8a35adbf048e0", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9f7d0c921686af985b2a7e97d9f422fe9d039b0e5ac979b9a2c70d647b0fe2b5"}}, {"rule": 2, "type": "equivalent", "target": "6884256e8627c74d9b8423dfb2718376", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9f7d0c921686af985b2a7e97d9f422fe9d039b0e5ac979b9a2c70d647b0fe2b5"}}], "version": "9.2.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "6884256e8627c74d9b8423dfb2718376", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Fix ecpg's processing of lists of variables declared varchar", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9f7d0c921686af985b2a7e97d9f422fe9d039b0e5ac979b9a2c70d647b0fe2b5"}, "url": "/docs/compare/?release=9.3.2#9.3.2-610b408b9caa5c8a", "source_url": "/docs/release/9.3.2/#AEN118826"}, {"db_id": "2ddb8bb0d99ab38a47d5d489357b1f83", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "Fix ecpg's processing of lists of variables declared varchar", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9f7d0c921686af985b2a7e97d9f422fe9d039b0e5ac979b9a2c70d647b0fe2b5"}, "url": "/docs/compare/?release=9.1.11#9.1.11-610b408b9caa5c8a", "source_url": "/docs/release/9.1.11/#AEN108742"}, {"db_id": "409d0da964e2a790d4e8a35adbf048e0", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "Fix ecpg's processing of lists of variables declared varchar", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "9f7d0c921686af985b2a7e97d9f422fe9d039b0e5ac979b9a2c70d647b0fe2b5"}, "url": "/docs/compare/?release=9.0.15#9.0.15-610b408b9caa5c8a", "source_url": "/docs/release/9.0.15/#AEN100394"}]}, {"id": "9.2.6-b428c200c09af9d5", "cves": [], "html": "Make contrib/lo defend against incorrect trigger definitions (Marc Cousin)
", "text": "Make contrib/lo defend against incorrect trigger definitions (Marc Cousin)", "title": "Make contrib/lo defend against incorrect trigger definitions", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "19a94c48a0476749b046f6a5a768cc86414d1018c40dc4a59005fd4e42c723de", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Make contrib/lo defend against incorrect trigger definitions (Marc Cousin)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/025", "db_id": "2f8e51d914589bae202909aaf246a538", "patch_ids": [], "statement_hash": "0db6010f21580c107f19f45f9efc17bc08327c585441aa7875034bd49f0ebe3c", "relations": [{"rule": 2, "type": "equivalent", "target": "496c8f49b5a01ad5bd55d5f53020526d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0db6010f21580c107f19f45f9efc17bc08327c585441aa7875034bd49f0ebe3c"}}, {"rule": 2, "type": "equivalent", "target": "62aeb6faec8c5b77f9bb01b48e03c696", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0db6010f21580c107f19f45f9efc17bc08327c585441aa7875034bd49f0ebe3c"}}, {"rule": 2, "type": "equivalent", "target": "6f70c73a712890b7ccaf0fd83dbdabaa", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0db6010f21580c107f19f45f9efc17bc08327c585441aa7875034bd49f0ebe3c"}}], "version": "9.2.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "6f70c73a712890b7ccaf0fd83dbdabaa", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Make contrib/lo defend against incorrect trigger definitions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0db6010f21580c107f19f45f9efc17bc08327c585441aa7875034bd49f0ebe3c"}, "url": "/docs/compare/?release=9.3.2#9.3.2-b428c200c09af9d5", "source_url": "/docs/release/9.3.2/#AEN118826"}, {"db_id": "496c8f49b5a01ad5bd55d5f53020526d", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "Make contrib/lo defend against incorrect trigger definitions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0db6010f21580c107f19f45f9efc17bc08327c585441aa7875034bd49f0ebe3c"}, "url": "/docs/compare/?release=9.1.11#9.1.11-b428c200c09af9d5", "source_url": "/docs/release/9.1.11/#AEN108742"}, {"db_id": "62aeb6faec8c5b77f9bb01b48e03c696", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "Make contrib/lo defend against incorrect trigger definitions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0db6010f21580c107f19f45f9efc17bc08327c585441aa7875034bd49f0ebe3c"}, "url": "/docs/compare/?release=9.0.15#9.0.15-b428c200c09af9d5", "source_url": "/docs/release/9.0.15/#AEN100394"}]}, {"id": "9.2.6-35fb5b0e51fedc27", "cves": [], "html": "Update time zone data files to tzdata release 2013h for DST law changes in Argentina, Brazil, Jordan, Libya, Liechtenstein, Morocco, and Palestine. Also, new timezone abbreviations WIB, WIT, WITA for Indonesia.
", "text": "Update time zone data files to tzdata release 2013h for DST law changes in Argentina, Brazil, Jordan, Libya, Liechtenstein, Morocco, and Palestine. Also, new timezone abbreviations WIB, WIT, WITA for Indonesia.", "title": "Update time zone data files to tzdata release 2013h for DST law changes in Argentina, Brazil, Jordan, Libya, Liechtenstein, Morocco, and Palestine. Also, new timezone abbreviations WIB, WIT, WITA for Indonesia.", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.2.6/#AEN113376", "source_hash": "d3c55877b3d6f9247c68d1738d2e6e2c385bd03687a37412e5673a1173491117", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Update time zone data files to tzdata release 2013h for DST law changes in Argentina, Brazil, Jordan, Libya, Liechtenstein, Morocco, and Palestine. Also, new timezone abbreviations WIB, WIT, WITA for Indonesia.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.2.6/changes/026", "db_id": "424125e8e6a645f6b06c795a699f69d0", "patch_ids": [], "statement_hash": "a19549acc73fc0d26f6eb4c09c6a93500ce32e170f9c7570ae6ca1ca0bcafc8f", "relations": [{"rule": 2, "type": "equivalent", "target": "7be18ae3b11bb3941b2b0b756054a0c8", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a19549acc73fc0d26f6eb4c09c6a93500ce32e170f9c7570ae6ca1ca0bcafc8f"}}, {"rule": 2, "type": "equivalent", "target": "7c44c32d94b8860307e11c5103c052c9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a19549acc73fc0d26f6eb4c09c6a93500ce32e170f9c7570ae6ca1ca0bcafc8f"}}, {"rule": 2, "type": "equivalent", "target": "873dbd191790e30b273777ef978761ed", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a19549acc73fc0d26f6eb4c09c6a93500ce32e170f9c7570ae6ca1ca0bcafc8f"}}], "version": "9.2.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "873dbd191790e30b273777ef978761ed", "kind": "equivalent", "version": "9.3.2", "label": "9.3.2", "title": "Update time zone data files to tzdata release 2013h for DST law changes in Argentina, Brazil, Jordan, Libya, Liechtenstein, Morocco, and Palestine. Also, new timezone abbreviations WIB, WIT, WITA for Indonesia.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a19549acc73fc0d26f6eb4c09c6a93500ce32e170f9c7570ae6ca1ca0bcafc8f"}, "url": "/docs/compare/?release=9.3.2#9.3.2-35fb5b0e51fedc27", "source_url": "/docs/release/9.3.2/#AEN118826"}, {"db_id": "7be18ae3b11bb3941b2b0b756054a0c8", "kind": "equivalent", "version": "9.1.11", "label": "9.1.11", "title": "Update time zone data files to tzdata release 2013h for DST law changes in Argentina, Brazil, Jordan, Libya, Liechtenstein, Morocco, and Palestine. Also, new timezone abbreviations WIB, WIT, WITA for Indonesia.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a19549acc73fc0d26f6eb4c09c6a93500ce32e170f9c7570ae6ca1ca0bcafc8f"}, "url": "/docs/compare/?release=9.1.11#9.1.11-35fb5b0e51fedc27", "source_url": "/docs/release/9.1.11/#AEN108742"}, {"db_id": "7c44c32d94b8860307e11c5103c052c9", "kind": "equivalent", "version": "9.0.15", "label": "9.0.15", "title": "Update time zone data files to tzdata release 2013h for DST law changes in Argentina, Brazil, Jordan, Libya, Liechtenstein, Morocco, and Palestine. Also, new timezone abbreviations WIB, WIT, WITA for Indonesia.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a19549acc73fc0d26f6eb4c09c6a93500ce32e170f9c7570ae6ca1ca0bcafc8f"}, "url": "/docs/compare/?release=9.0.15#9.0.15-35fb5b0e51fedc27", "source_url": "/docs/release/9.0.15/#AEN100394"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 26}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 16}, {"key": "security", "label": "Security", "count": 0}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 10}], "total": 26, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 26, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}