{"format": 1, "mode": "release", "from_release": null, "to_release": {"date": "2012-09-24", "build": "9.1.6", "major": "9.1", "minor": 6, "manual": "9.1", "status": "stable", "doc_git": "", "version": "9.1.6", "eol_date": "2016-10-27", "date_text": "2012-09-24", "supported": false, "manual_url": "/docs/9.1/release-9-1-6.html", "source_url": "/docs/release/9.1.6/", "entry_count": 17, "placeholder": false, "content_hash": "9c2a3ee248d3e372bbceb9c8c6be76f69961f6686fdbf7778abeb286e2fe63b0", "manual_build": "9.1.24", "source_as_of": "", "changes_count": 17, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "

A dump/restore is not required for those running 9.1.X.

\n

However, you may need to perform REINDEX operations to recover from the effects of the data corruption bug described in the first changelog item below.

\n

Also, if you are upgrading from a version earlier than 9.1.4, see Section E.21.

", "compatibility_count": 0, "label": "9.1.6", "status_label": "Historical", "eol": "2016-10-27", "age_days": 5118, "support_days": -3624}, "groups": [{"date": "2012-09-24", "build": "9.1.6", "major": "9.1", "minor": 6, "manual": "9.1", "status": "stable", "doc_git": "", "version": "9.1.6", "eol_date": "2016-10-27", "date_text": "2012-09-24", "supported": false, "manual_url": "/docs/9.1/release-9-1-6.html", "source_url": "/docs/release/9.1.6/", "entry_count": 17, "placeholder": false, "content_hash": "9c2a3ee248d3e372bbceb9c8c6be76f69961f6686fdbf7778abeb286e2fe63b0", "manual_build": "9.1.24", "source_as_of": "", "changes_count": 17, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "

A dump/restore is not required for those running 9.1.X.

\n

However, you may need to perform REINDEX operations to recover from the effects of the data corruption bug described in the first changelog item below.

\n

Also, if you are upgrading from a version earlier than 9.1.4, see Section E.21.

", "compatibility_count": 0, "label": "9.1.6", "status_label": "Historical", "eol": "2016-10-27", "age_days": 5118, "support_days": -3624, "entries": [{"id": "9.1.6-2ee26127720b6ee5", "cves": [], "html": "

Fix persistence marking of shared buffers during WAL replay (Jeff Davis)

\n

This mistake can result in buffers not being written out during checkpoints, resulting in data corruption if the server later crashes without ever having written those buffers. Corruption can occur on any server following crash recovery, but it is significantly more likely to occur on standby slave servers since those perform much more WAL replay. There is a low probability of corruption of btree and GIN indexes. There is a much higher probability of corruption of table \"visibility maps\". Fortunately, visibility maps are non-critical data in 9.1, so the worst consequence of such corruption in 9.1 installations is transient inefficiency of vacuuming. Table data proper cannot be corrupted by this bug.

\n

While no index corruption due to this bug is known to have occurred in the field, as a precautionary measure it is recommended that production installations REINDEX all btree and GIN indexes at a convenient time after upgrading to 9.1.6.

\n

Also, if you intend to do an in-place upgrade to 9.2.X, before doing so it is recommended to perform a VACUUM of all tables while having vacuum_freeze_table_age set to zero. This will ensure that any lingering wrong data in the visibility maps is corrected before 9.2.X can depend on it. vacuum_cost_delay can be adjusted to reduce the performance impact of vacuuming, while causing it to take longer to finish.

", "text": "Fix persistence marking of shared buffers during WAL replay (Jeff Davis) This mistake can result in buffers not being written out during checkpoints, resulting in data corruption if the server later crashes without ever having written those buffers. Corruption can occur on any server following crash recovery, but it is significantly more likely to occur on standby slave servers since those perform much more WAL replay. There is a low probability of corruption of btree and GIN indexes. There is a much higher probability of corruption of table \"visibility maps\". Fortunately, visibility maps are non-critical data in 9.1, so the worst consequence of such corruption in 9.1 installations is transient inefficiency of vacuuming. Table data proper cannot be corrupted by this bug. While no index corruption due to this bug is known to have occurred in the field, as a precautionary measure it is recommended that production installations REINDEX all btree and GIN indexes at a convenient time after upgrading to 9.1.6. Also, if you intend to do an in-place upgrade to 9.2.X, before doing so it is recommended to perform a VACUUM of all tables while having vacuum_freeze_table_age set to zero. This will ensure that any lingering wrong data in the visibility maps is corrected before 9.2.X can depend on it. vacuum_cost_delay can be adjusted to reduce the performance impact of vacuuming, while causing it to take longer to finish.", "title": "Fix persistence marking of shared buffers during WAL replay", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "912043c24852084ce35417876ebea2a622278007d31671a2eee12b36954d348d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix persistence marking of shared buffers during WAL replay (Jeff Davis) This mistake can result in buffers not being written out during checkpoints, resulting in data corruption if the server later crashes without ever having written those buffers. Corruption can occur on any server following crash recovery, but it is significantly more likely to occur on standby slave servers since those perform much more WAL replay. There is a low probability of corruption of btree and GIN indexes. There is a much higher probability of corruption of table visibility maps. Fortunately, visibility maps are non-critical data in 9.1, so the worst consequence of such corruption in 9.1 installations is transient inefficiency of vacuuming. Table data proper cannot be corrupted by this bug. While no index corruption due to this bug is known to have occurred in the field, as a precautionary measure it is recommended that production installations REINDEX all btree and GIN indexes at a convenient time after upgrading to 9.1.6. Also, if you intend to do an in-place upgrade to 9.2.X, before doing so it is recommended to perform a VACUUM of all tables while having vacuum_freeze_table_age set to zero. This will ensure that any lingering wrong data in the visibility maps is corrected before 9.2.X can depend on it. vacuum_cost_delay can be adjusted to reduce the performance impact of vacuuming, while causing it to take longer to finish.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/001", "db_id": "0a840acb99b93acf03644cbc33236d39", "patch_ids": [], "statement_hash": "ef6132b4a5d2f407156952cf6e4c3ccf5cdb5fb10169dfcfe44f6b8b7924c227", "relations": [], "version": "9.1.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.1.6-bc3eae65362666f2", "cves": [], "html": "

Fix planner's assignment of executor parameters, and fix executor's rescan logic for CTE plan nodes (Tom Lane)

\n

These errors could result in wrong answers from queries that scan the same WITH subquery multiple times.

", "text": "Fix planner's assignment of executor parameters, and fix executor's rescan logic for CTE plan nodes (Tom Lane) These errors could result in wrong answers from queries that scan the same WITH subquery multiple times.", "title": "Fix planner's assignment of executor parameters, and fix executor's rescan logic for CTE plan nodes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "43f35048226997c7063b386fc359480d6087eaf3105709bc3391178841820b88", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix planner's assignment of executor parameters, and fix executor's rescan logic for CTE plan nodes (Tom Lane) These errors could result in wrong answers from queries that scan the same WITH subquery multiple times.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/002", "db_id": "c06a2faf8fe7e33717f04a653b0c566c", "patch_ids": [], "statement_hash": "303ea31cb500da251536c28a534109ccb4722d41e38da69c13c7745a2ce914bf", "relations": [{"rule": 2, "type": "equivalent", "target": "ed58d031ced6c708a1bafd28fb68ba46", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "303ea31cb500da251536c28a534109ccb4722d41e38da69c13c7745a2ce914bf"}}], "version": "9.1.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "ed58d031ced6c708a1bafd28fb68ba46", "kind": "equivalent", "version": "9.0.10", "label": "9.0.10", "title": "Fix planner's assignment of executor parameters, and fix executor's rescan logic for CTE plan nodes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "303ea31cb500da251536c28a534109ccb4722d41e38da69c13c7745a2ce914bf"}, "url": "/docs/compare/?release=9.0.10#9.0.10-bc3eae65362666f2", "source_url": "/docs/release/9.0.10/#AEN100985"}]}, {"id": "9.1.6-213762ee76f8b3f0", "cves": [], "html": "

Fix misbehavior when default_transaction_isolation is set to serializable (Kevin Grittner, Tom Lane, Heikki Linnakangas)

\n

Symptoms include crashes at process start on Windows, and crashes in hot standby operation.

", "text": "Fix misbehavior when default_transaction_isolation is set to serializable (Kevin Grittner, Tom Lane, Heikki Linnakangas) Symptoms include crashes at process start on Windows, and crashes in hot standby operation.", "title": "Fix misbehavior when default_transaction_isolation is set to serializable", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "f9fc402bc255c9ab856b05ddb52207a4bc87fc058763962aaa8a810dfcca5380", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix misbehavior when default_transaction_isolation is set to serializable (Kevin Grittner, Tom Lane, Heikki Linnakangas) Symptoms include crashes at process start on Windows, and crashes in hot standby operation.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/003", "db_id": "9fd6f8074ff35a9a710f62ea960acec4", "patch_ids": [], "statement_hash": "b86fcff61262dc590e5113d60774f81f0a7080d5603516b45ff47290fac90032", "relations": [], "version": "9.1.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.1.6-b33f7c12801e0dad", "cves": [], "html": "

Improve selectivity estimation for text search queries involving prefixes, i.e. word:* patterns (Tom Lane)

", "text": "Improve selectivity estimation for text search queries involving prefixes, i.e. word:* patterns (Tom Lane)", "title": "Improve selectivity estimation for text search queries involving prefixes, i.e. word:* patterns", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "58c0611b67c94457e37f510983c880fe44e57188906aed1955fa11f72a34e3ae", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Improve selectivity estimation for text search queries involving prefixes, i.e. word:* patterns (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/004", "db_id": "ce2a2707afd6173a834a41c93a8b3ce3", "patch_ids": [], "statement_hash": "a129380b69503d333fd7939426a54dc45e6a227d608adf207ea4294b6886892f", "relations": [{"rule": 2, "type": "equivalent", "target": "27beb6cece9a1a13f5f330c57555aef9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a129380b69503d333fd7939426a54dc45e6a227d608adf207ea4294b6886892f"}}], "version": "9.1.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "27beb6cece9a1a13f5f330c57555aef9", "kind": "equivalent", "version": "9.2.1", "label": "9.2.1", "title": "Improve selectivity estimation for text search queries involving prefixes, i.e. word:* patterns", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a129380b69503d333fd7939426a54dc45e6a227d608adf207ea4294b6886892f"}, "url": "/docs/compare/?release=9.2.1#9.2.1-b33f7c12801e0dad", "source_url": "/docs/release/9.2.1/#AEN114299"}]}, {"id": "9.1.6-068baff36aaebf84", "cves": [], "html": "

Improve page-splitting decisions in GiST indexes (Alexander Korotkov, Robert Haas, Tom Lane)

\n

Multi-column GiST indexes might suffer unexpected bloat due to this error.

", "text": "Improve page-splitting decisions in GiST indexes (Alexander Korotkov, Robert Haas, Tom Lane) Multi-column GiST indexes might suffer unexpected bloat due to this error.", "title": "Improve page-splitting decisions in GiST indexes", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "6511b0730133e02b090fc68488140603404e2326806bb803eb6a4fe6447776cf", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Improve page-splitting decisions in GiST indexes (Alexander Korotkov, Robert Haas, Tom Lane) Multi-column GiST indexes might suffer unexpected bloat due to this error.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/005", "db_id": "d78207824bf5c4c0e51b593ff8aa15fd", "patch_ids": [], "statement_hash": "f011fb58ac0821237d5d448459b15e8cf3408a4bef80f4856dc49cc39a6e462f", "relations": [{"rule": 2, "type": "equivalent", "target": "8cacc1f6e7dd584ba7cdf575bc4129fb", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f011fb58ac0821237d5d448459b15e8cf3408a4bef80f4856dc49cc39a6e462f"}}], "version": "9.1.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "8cacc1f6e7dd584ba7cdf575bc4129fb", "kind": "equivalent", "version": "9.0.10", "label": "9.0.10", "title": "Improve page-splitting decisions in GiST indexes", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "f011fb58ac0821237d5d448459b15e8cf3408a4bef80f4856dc49cc39a6e462f"}, "url": "/docs/compare/?release=9.0.10#9.0.10-068baff36aaebf84", "source_url": "/docs/release/9.0.10/#AEN100985"}]}, {"id": "9.1.6-13222edf1772c3f0", "cves": [], "html": "

Fix cascading privilege revoke to stop if privileges are still held (Tom Lane)

\n

If we revoke a grant option from some role X, but X still holds that option via a grant from someone else, we should not recursively revoke the corresponding privilege from role(s) Y that X had granted it to.

", "text": "Fix cascading privilege revoke to stop if privileges are still held (Tom Lane) If we revoke a grant option from some role X, but X still holds that option via a grant from someone else, we should not recursively revoke the corresponding privilege from role(s) Y that X had granted it to.", "title": "Fix cascading privilege revoke to stop if privileges are still held", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "33915078e28f499fe59c31abab4e56167fba7c6dcbbd2cff712bd1f35d327e7c", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix cascading privilege revoke to stop if privileges are still held (Tom Lane) If we revoke a grant option from some role X, but X still holds that option via a grant from someone else, we should not recursively revoke the corresponding privilege from role(s) Y that X had granted it to.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/006", "db_id": "7b3ad10258a3087d736206bbb232e17c", "patch_ids": [], "statement_hash": "aad8e30ad87639cf8335aa67f5ed570dd2521802b88521e87c8c52ee9d126f3b", "relations": [{"rule": 2, "type": "equivalent", "target": "482d15cd9d0cd2ab5aa6ee92239f6a7b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "aad8e30ad87639cf8335aa67f5ed570dd2521802b88521e87c8c52ee9d126f3b"}}], "version": "9.1.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "482d15cd9d0cd2ab5aa6ee92239f6a7b", "kind": "equivalent", "version": "9.0.10", "label": "9.0.10", "title": "Fix cascading privilege revoke to stop if privileges are still held", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "aad8e30ad87639cf8335aa67f5ed570dd2521802b88521e87c8c52ee9d126f3b"}, "url": "/docs/compare/?release=9.0.10#9.0.10-13222edf1772c3f0", "source_url": "/docs/release/9.0.10/#AEN100985"}]}, {"id": "9.1.6-fa93610af5f5331b", "cves": [], "html": "

Disallow extensions from containing the schema they are assigned to (Thom Brown)

\n

This situation creates circular dependencies that confuse pg_dump and probably other things. It's confusing for humans too, so disallow it.

", "text": "Disallow extensions from containing the schema they are assigned to (Thom Brown) This situation creates circular dependencies that confuse pg_dump and probably other things. It's confusing for humans too, so disallow it.", "title": "Disallow extensions from containing the schema they are assigned to", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "d97e624a3a79fc0efa4c991a8a40546e8c64f95977cae136512c567d8c48757e", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Disallow extensions from containing the schema they are assigned to (Thom Brown) This situation creates circular dependencies that confuse pg_dump and probably other things. It's confusing for humans too, so disallow it.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/007", "db_id": "a38890e3da38d0c906dd23c20f65fec9", "patch_ids": [], "statement_hash": "26c9f5d06d66dcd4cd2ec9dccf4a1976d0cf8efd49411885b9c0da6f08011007", "relations": [], "version": "9.1.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.1.6-d375c538613a2e14", "cves": [], "html": "

Improve error messages for Hot Standby misconfiguration errors (Gurjeet Singh)

", "text": "Improve error messages for Hot Standby misconfiguration errors (Gurjeet Singh)", "title": "Improve error messages for Hot Standby misconfiguration errors", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "31f3a27ff32ffcd9bfc2540b6b8eb90ae184be4a6d091002a9c488e129d6a3c5", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Improve error messages for Hot Standby misconfiguration errors (Gurjeet Singh)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/008", "db_id": "9fb026bbb9f130da498f7baf877e0c0e", "patch_ids": [], "statement_hash": "ed7e6986b5ef5dc55358284847dd5838524f8627f0892406aead003500a2b5f9", "relations": [{"rule": 2, "type": "equivalent", "target": "8e839915505bc1e1a41f5e1847e671df", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ed7e6986b5ef5dc55358284847dd5838524f8627f0892406aead003500a2b5f9"}}], "version": "9.1.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "8e839915505bc1e1a41f5e1847e671df", "kind": "equivalent", "version": "9.0.10", "label": "9.0.10", "title": "Improve error messages for Hot Standby misconfiguration errors", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ed7e6986b5ef5dc55358284847dd5838524f8627f0892406aead003500a2b5f9"}, "url": "/docs/compare/?release=9.0.10#9.0.10-d375c538613a2e14", "source_url": "/docs/release/9.0.10/#AEN100985"}]}, {"id": "9.1.6-d4e805cd9c6ff2c6", "cves": [], "html": "

Make configure probe for mbstowcs_l (Tom Lane)

\n

This fixes build failures on some versions of AIX.

", "text": "Make configure probe for mbstowcs_l (Tom Lane) This fixes build failures on some versions of AIX.", "title": "Make configure probe for mbstowcs_l", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "2127df8fdfc2d0ee0e15c68b2a17997f00d6cdcd80ce22c3a1834a5da06719b7", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Make configure probe for mbstowcs_l (Tom Lane) This fixes build failures on some versions of AIX.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/009", "db_id": "80b737db3a5ed24e4828630ecc39cd4d", "patch_ids": [], "statement_hash": "47012e31f79ac5b4801837428722f79c20a9be7e845dd6b2bd567e25c3b2946a", "relations": [], "version": "9.1.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.1.6-3c38a0907b3e9096", "cves": [], "html": "

Fix handling of SIGFPE when PL/Perl is in use (Andres Freund)

\n

Perl resets the process's SIGFPE handler to SIG_IGN, which could result in crashes later on. Restore the normal Postgres signal handler after initializing PL/Perl.

", "text": "Fix handling of SIGFPE when PL/Perl is in use (Andres Freund) Perl resets the process's SIGFPE handler to SIG_IGN, which could result in crashes later on. Restore the normal Postgres signal handler after initializing PL/Perl.", "title": "Fix handling of SIGFPE when PL/Perl is in use", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "86001c6dcf9b96524ba44de74fe119cc7f596170566c135d2e5532f41147f900", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix handling of SIGFPE when PL/Perl is in use (Andres Freund) Perl resets the process's SIGFPE handler to SIG_IGN, which could result in crashes later on. Restore the normal Postgres signal handler after initializing PL/Perl.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/010", "db_id": "48c9a99f41b78ea55b70e2738fb7953b", "patch_ids": [], "statement_hash": "a7cab7f741a640399873f42f8cec25f51fff8b47096b245a90dcf53500db9170", "relations": [{"rule": 2, "type": "equivalent", "target": "b58c83760e2caaa87b21b5e2035646c7", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a7cab7f741a640399873f42f8cec25f51fff8b47096b245a90dcf53500db9170"}}], "version": "9.1.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "b58c83760e2caaa87b21b5e2035646c7", "kind": "equivalent", "version": "9.0.10", "label": "9.0.10", "title": "Fix handling of SIGFPE when PL/Perl is in use", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "a7cab7f741a640399873f42f8cec25f51fff8b47096b245a90dcf53500db9170"}, "url": "/docs/compare/?release=9.0.10#9.0.10-3c38a0907b3e9096", "source_url": "/docs/release/9.0.10/#AEN100985"}]}, {"id": "9.1.6-b5b40269202b08bb", "cves": [], "html": "

Prevent PL/Perl from crashing if a recursive PL/Perl function is redefined while being executed (Tom Lane)

", "text": "Prevent PL/Perl from crashing if a recursive PL/Perl function is redefined while being executed (Tom Lane)", "title": "Prevent PL/Perl from crashing if a recursive PL/Perl function is redefined while being executed", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "b36aa21fc2aa15564cfd4c352381531672c30fd9c7760e7e0ca6c4f064179b12", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Prevent PL/Perl from crashing if a recursive PL/Perl function is redefined while being executed (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/011", "db_id": "6fdc69dbd04a82bf8440579c87fa8d7e", "patch_ids": [], "statement_hash": "247e05f6355b0c18f3b1c9558e4ef965312d9d6960e31a616ce980f6721a542e", "relations": [{"rule": 2, "type": "equivalent", "target": "20cdaf66b51cd04d9badb1e618c75162", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "247e05f6355b0c18f3b1c9558e4ef965312d9d6960e31a616ce980f6721a542e"}}, {"rule": 2, "type": "equivalent", "target": "2e12c5fc8c760f038a31f06b8163922d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "247e05f6355b0c18f3b1c9558e4ef965312d9d6960e31a616ce980f6721a542e"}}], "version": "9.1.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "20cdaf66b51cd04d9badb1e618c75162", "kind": "equivalent", "version": "9.2.1", "label": "9.2.1", "title": "Prevent PL/Perl from crashing if a recursive PL/Perl function is redefined while being executed", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "247e05f6355b0c18f3b1c9558e4ef965312d9d6960e31a616ce980f6721a542e"}, "url": "/docs/compare/?release=9.2.1#9.2.1-b5b40269202b08bb", "source_url": "/docs/release/9.2.1/#AEN114299"}, {"db_id": "2e12c5fc8c760f038a31f06b8163922d", "kind": "equivalent", "version": "9.0.10", "label": "9.0.10", "title": "Prevent PL/Perl from crashing if a recursive PL/Perl function is redefined while being executed", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "247e05f6355b0c18f3b1c9558e4ef965312d9d6960e31a616ce980f6721a542e"}, "url": "/docs/compare/?release=9.0.10#9.0.10-b5b40269202b08bb", "source_url": "/docs/release/9.0.10/#AEN100985"}]}, {"id": "9.1.6-9dc77f40c084543c", "cves": [], "html": "

Work around possible misoptimization in PL/Perl (Tom Lane)

\n

Some Linux distributions contain an incorrect version of pthread.h that results in incorrect compiled code in PL/Perl, leading to crashes if a PL/Perl function calls another one that throws an error.

", "text": "Work around possible misoptimization in PL/Perl (Tom Lane) Some Linux distributions contain an incorrect version of pthread.h that results in incorrect compiled code in PL/Perl, leading to crashes if a PL/Perl function calls another one that throws an error.", "title": "Work around possible misoptimization in PL/Perl", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "b5671b4626ee970576604adf4625268006d304068053e20d535b96b53bd5864d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Work around possible misoptimization in PL/Perl (Tom Lane) Some Linux distributions contain an incorrect version of pthread.h that results in incorrect compiled code in PL/Perl, leading to crashes if a PL/Perl function calls another one that throws an error.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/012", "db_id": "d48eca53239ce6adfb0ecb2ce1f3cfa5", "patch_ids": [], "statement_hash": "7ca195ad6c0693363f8205dcdbfe966c4f653f1c9aed4c63c75fc0c61c6660fd", "relations": [{"rule": 2, "type": "equivalent", "target": "742f3ee5a3dee3658b3a4619e0f3aab2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7ca195ad6c0693363f8205dcdbfe966c4f653f1c9aed4c63c75fc0c61c6660fd"}}, {"rule": 2, "type": "equivalent", "target": "eca2108a6f0e32ab28301130324e43c6", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7ca195ad6c0693363f8205dcdbfe966c4f653f1c9aed4c63c75fc0c61c6660fd"}}], "version": "9.1.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "eca2108a6f0e32ab28301130324e43c6", "kind": "equivalent", "version": "9.2.1", "label": "9.2.1", "title": "Work around possible misoptimization in PL/Perl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7ca195ad6c0693363f8205dcdbfe966c4f653f1c9aed4c63c75fc0c61c6660fd"}, "url": "/docs/compare/?release=9.2.1#9.2.1-9dc77f40c084543c", "source_url": "/docs/release/9.2.1/#AEN114299"}, {"db_id": "742f3ee5a3dee3658b3a4619e0f3aab2", "kind": "equivalent", "version": "9.0.10", "label": "9.0.10", "title": "Work around possible misoptimization in PL/Perl", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "7ca195ad6c0693363f8205dcdbfe966c4f653f1c9aed4c63c75fc0c61c6660fd"}, "url": "/docs/compare/?release=9.0.10#9.0.10-9dc77f40c084543c", "source_url": "/docs/release/9.0.10/#AEN100985"}]}, {"id": "9.1.6-0f920d4eb36dfb65", "cves": [], "html": "

Fix bugs in contrib/pg_trgm's LIKE pattern analysis code (Fujii Masao)

\n

LIKE queries using a trigram index could produce wrong results if the pattern contained LIKE escape characters.

", "text": "Fix bugs in contrib/pg_trgm's LIKE pattern analysis code (Fujii Masao) LIKE queries using a trigram index could produce wrong results if the pattern contained LIKE escape characters.", "title": "Fix bugs in contrib/pg_trgm's LIKE pattern analysis code", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "6e9e0f6e5652691bea6ba1062719f149b0ab27625bb27d2a5ff6e2aeca797cd4", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix bugs in contrib/pg_trgm's LIKE pattern analysis code (Fujii Masao) LIKE queries using a trigram index could produce wrong results if the pattern contained LIKE escape characters.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/013", "db_id": "25591a29a09f37a0ccba903401e6d63e", "patch_ids": [], "statement_hash": "2e98552c65bced8a655064ac6cedbf5a058741ab6ad87dd02a64c812af1795eb", "relations": [], "version": "9.1.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.1.6-de153e6a0eb607a6", "cves": [], "html": "

Fix pg_upgrade's handling of line endings on Windows (Andrew Dunstan)

\n

Previously, pg_upgrade might add or remove carriage returns in places such as function bodies.

", "text": "Fix pg_upgrade's handling of line endings on Windows (Andrew Dunstan) Previously, pg_upgrade might add or remove carriage returns in places such as function bodies.", "title": "Fix pg_upgrade's handling of line endings on Windows", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "e1fd8167191701b3c386969a1e10161bdd7590b75bf380910cb1e1f16a0cf46e", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix pg_upgrade's handling of line endings on Windows (Andrew Dunstan) Previously, pg_upgrade might add or remove carriage returns in places such as function bodies.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/014", "db_id": "c7879bf03c0246afe35ba7451b635ea2", "patch_ids": [], "statement_hash": "3689fa5cd613a4767592dd4312565d863189fb2d99b35223be74f5e2f6557c75", "relations": [{"rule": 2, "type": "equivalent", "target": "d8591fd7da4d86c575154fd3823cc95e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3689fa5cd613a4767592dd4312565d863189fb2d99b35223be74f5e2f6557c75"}}], "version": "9.1.6", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "d8591fd7da4d86c575154fd3823cc95e", "kind": "equivalent", "version": "9.0.10", "label": "9.0.10", "title": "Fix pg_upgrade's handling of line endings on Windows", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "3689fa5cd613a4767592dd4312565d863189fb2d99b35223be74f5e2f6557c75"}, "url": "/docs/compare/?release=9.0.10#9.0.10-de153e6a0eb607a6", "source_url": "/docs/release/9.0.10/#AEN100985"}]}, {"id": "9.1.6-5149269381c37635", "cves": [], "html": "

On Windows, make pg_upgrade use backslash path separators in the scripts it emits (Andrew Dunstan)

", "text": "On Windows, make pg_upgrade use backslash path separators in the scripts it emits (Andrew Dunstan)", "title": "On Windows, make pg_upgrade use backslash path separators in the scripts it emits", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "35ee2f9409ee996c64255249d61dcfacd719a56049d8ccb31e1e5e1502dd95c6", "section_path": ["Changes"], "commit_groups": [], "identity_text": "On Windows, make pg_upgrade use backslash path separators in the scripts it emits (Andrew Dunstan)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/015", "db_id": "5b21e9be799a3571f9cd9d29f6e8d44c", "patch_ids": [], "statement_hash": "604f1c60574da94dfe9cc61c911a84c9966d03fd790d021b8bc41baaad932d01", "relations": [{"rule": 2, "type": "equivalent", "target": "8fc6eb12af4b6c9bc4aa08063275ea55", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "604f1c60574da94dfe9cc61c911a84c9966d03fd790d021b8bc41baaad932d01"}}], "version": "9.1.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "8fc6eb12af4b6c9bc4aa08063275ea55", "kind": "equivalent", "version": "9.0.10", "label": "9.0.10", "title": "On Windows, make pg_upgrade use backslash path separators in the scripts it emits", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "604f1c60574da94dfe9cc61c911a84c9966d03fd790d021b8bc41baaad932d01"}, "url": "/docs/compare/?release=9.0.10#9.0.10-5149269381c37635", "source_url": "/docs/release/9.0.10/#AEN100985"}]}, {"id": "9.1.6-ab919537251b4055", "cves": [], "html": "

Remove unnecessary dependency on pg_config from pg_upgrade (Peter Eisentraut)

", "text": "Remove unnecessary dependency on pg_config from pg_upgrade (Peter Eisentraut)", "title": "Remove unnecessary dependency on pg_config from pg_upgrade", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "713a8cdafd9a36d0d6c8d5f7caac2244b20eb848b77b2bec4282367fd7debc4f", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Remove unnecessary dependency on pg_config from pg_upgrade (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/016", "db_id": "13eec267c3e62f76520e5b561e964352", "patch_ids": [], "statement_hash": "ac5b9aa36b497611605ac28dc05bed896ff80c972365ac5b9a05def27dd63386", "relations": [{"rule": 2, "type": "equivalent", "target": "5ded8e2c1ef0c7f29c8fe51146c7582c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ac5b9aa36b497611605ac28dc05bed896ff80c972365ac5b9a05def27dd63386"}}], "version": "9.1.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "5ded8e2c1ef0c7f29c8fe51146c7582c", "kind": "equivalent", "version": "9.2.1", "label": "9.2.1", "title": "Remove unnecessary dependency on pg_config from pg_upgrade", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "ac5b9aa36b497611605ac28dc05bed896ff80c972365ac5b9a05def27dd63386"}, "url": "/docs/compare/?release=9.2.1#9.2.1-ab919537251b4055", "source_url": "/docs/release/9.2.1/#AEN114299"}]}, {"id": "9.1.6-bb1844b83fe06768", "cves": [], "html": "

Update time zone data files to tzdata release 2012f for DST law changes in Fiji

", "text": "Update time zone data files to tzdata release 2012f for DST law changes in Fiji", "title": "Update time zone data files to tzdata release 2012f for DST law changes in Fiji", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.1.6/#AEN109439", "source_hash": "d8a80091b70fe4d863dd3841b32322b5b07e1979a8c64bcb8b7947c4facbb99e", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Update time zone data files to tzdata release 2012f for DST law changes in Fiji", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.1.6/changes/017", "db_id": "b0a01851eb79db8339550a03879ef2e3", "patch_ids": [], "statement_hash": "c6e1e4392e7c2866d9d05a00c2d80972799fba21171a3252e1d5475f2b473ba8", "relations": [{"rule": 2, "type": "equivalent", "target": "3355d171f59b6dd9ccfea042bb14942b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c6e1e4392e7c2866d9d05a00c2d80972799fba21171a3252e1d5475f2b473ba8"}}, {"rule": 2, "type": "equivalent", "target": "7b5b3e7e60e584eb09fcc994d80bf9d3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c6e1e4392e7c2866d9d05a00c2d80972799fba21171a3252e1d5475f2b473ba8"}}], "version": "9.1.6", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "7b5b3e7e60e584eb09fcc994d80bf9d3", "kind": "equivalent", "version": "9.2.1", "label": "9.2.1", "title": "Update time zone data files to tzdata release 2012f for DST law changes in Fiji", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c6e1e4392e7c2866d9d05a00c2d80972799fba21171a3252e1d5475f2b473ba8"}, "url": "/docs/compare/?release=9.2.1#9.2.1-bb1844b83fe06768", "source_url": "/docs/release/9.2.1/#AEN114299"}, {"db_id": "3355d171f59b6dd9ccfea042bb14942b", "kind": "equivalent", "version": "9.0.10", "label": "9.0.10", "title": "Update time zone data files to tzdata release 2012f for DST law changes in Fiji", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c6e1e4392e7c2866d9d05a00c2d80972799fba21171a3252e1d5475f2b473ba8"}, "url": "/docs/compare/?release=9.0.10#9.0.10-bb1844b83fe06768", "source_url": "/docs/release/9.0.10/#AEN100985"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 17}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 8}, {"key": "security", "label": "Security", "count": 0}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 9}], "total": 17, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 17, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}