A dump/restore is not required for those running 9.5.X.
", "compatibility_count": 0, "label": "9.5.1", "status_label": "Historical", "eol": "2021-02-11", "age_days": 3883, "support_days": -2056}, "groups": [{"date": "2016-02-11", "build": "9.5.1", "major": "9.5", "minor": 1, "manual": "9.5", "status": "stable", "doc_git": "", "version": "9.5.1", "eol_date": "2021-02-11", "date_text": "2016-02-11", "supported": false, "manual_url": "/docs/9.5/release-9-5-1.html", "source_url": "/docs/release/9.5.1/", "entry_count": 23, "placeholder": false, "content_hash": "29a0629af3198500c984dded76468dd0b0616005da639cce4af7fde7ff9950ea", "manual_build": "9.5.25", "source_as_of": "", "changes_count": 23, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 9.5.X.
", "compatibility_count": 0, "label": "9.5.1", "status_label": "Historical", "eol": "2021-02-11", "age_days": 3883, "support_days": -2056, "entries": [{"id": "9.5.1-2350534a235e20d8", "cves": ["CVE-2016-0773"], "html": "Fix infinite loops and buffer-overrun problems in regular expressions (Tom Lane)
\nVery large character ranges in bracket expressions could cause infinite loops in some cases, and memory overwrites in other cases. (CVE-2016-0773)
", "text": "Fix infinite loops and buffer-overrun problems in regular expressions (Tom Lane) Very large character ranges in bracket expressions could cause infinite loops in some cases, and memory overwrites in other cases. (CVE-2016-0773)", "title": "Fix infinite loops and buffer-overrun problems in regular expressions", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "eb0438a45957947108c61c598f04acd2ec453dd2b563c4193f035f6b8b92e868", "section_path": ["Changes"], "commit_groups": [["3bb3f42f3", "6403a6b74", "98d6b7305", "a61de2bc1", "e93516cf7", "fdc3139e2"]], "identity_text": "Fix infinite loops and buffer-overrun problems in regular expressions (Tom Lane) Very large character ranges in bracket expressions could cause infinite loops in some cases, and memory overwrites in other cases. (CVE-2016-0773)", "commit_aliases": ["3bb3f42f3", "6403a6b74", "98d6b7305", "a61de2bc1", "e93516cf7", "fdc3139e2"], "source_commits": ["a61de2bc1"], "source_entry_id": "9.5.1/changes/001", "db_id": "acbbe23ea65dd41f0174374de68d073f", "patch_ids": ["fff99eddfbc31c3eb5f41a8529895bbd"], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c", "relations": [{"rule": 2, "type": "equivalent", "target": "859232add61df95d2630e724ae0f4618", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c"}}, {"rule": 2, "type": "equivalent", "target": "a209620754197e56fafec1ecd0cd9842", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c"}}, {"rule": 2, "type": "equivalent", "target": "eb48871d4635001988ed54c5482d6ada", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c"}}, {"rule": 2, "type": "equivalent", "target": "f82b2c278b85f75fb51729724ed1a13f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c"}}], "version": "9.5.1", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "eb48871d4635001988ed54c5482d6ada", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "Fix infinite loops and buffer-overrun problems in regular expressions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c"}, "url": "/docs/compare/?release=9.4.6#9.4.6-2350534a235e20d8", "source_url": "/docs/release/9.4.6/#AEN122667"}, {"db_id": "f82b2c278b85f75fb51729724ed1a13f", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "Fix infinite loops and buffer-overrun problems in regular expressions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c"}, "url": "/docs/compare/?release=9.3.11#9.3.11-2350534a235e20d8", "source_url": "/docs/release/9.3.11/#AEN116895"}, {"db_id": "a209620754197e56fafec1ecd0cd9842", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "Fix infinite loops and buffer-overrun problems in regular expressions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c"}, "url": "/docs/compare/?release=9.2.15#9.2.15-2350534a235e20d8", "source_url": "/docs/release/9.2.15/#AEN111801"}, {"db_id": "859232add61df95d2630e724ae0f4618", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "Fix infinite loops and buffer-overrun problems in regular expressions", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "86c3969d7d94649f2681aaabfba3eb2e2d707639975ebea74333022223b0914c"}, "url": "/docs/compare/?release=9.1.20#9.1.20-2350534a235e20d8", "source_url": "/docs/release/9.1.20/#AEN107334"}]}, {"id": "9.5.1-f6473bb5f7f703ef", "cves": [], "html": "Fix an oversight that caused hash joins to miss joining to some tuples of the inner relation in rare cases (Tomas Vondra, Tom Lane)
", "text": "Fix an oversight that caused hash joins to miss joining to some tuples of the inner relation in rare cases (Tomas Vondra, Tom Lane)", "title": "Fix an oversight that caused hash joins to miss joining to some tuples of the inner relation in rare cases", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "8d20690639eba4a374b434eb9303f58e209ff57c6ed0a28ae9857db442d80ca5", "section_path": ["Changes"], "commit_groups": [["129db3cbe", "f867ce551"]], "identity_text": "Fix an oversight that caused hash joins to miss joining to some tuples of the inner relation in rare cases (Tomas Vondra, Tom Lane)", "commit_aliases": ["129db3cbe", "f867ce551"], "source_commits": ["129db3cbe"], "source_entry_id": "9.5.1/changes/002", "db_id": "932c11915038d8b55a76e79b35c0abdd", "patch_ids": ["9e554408b05a7d34ef156283a1b8668d"], "statement_hash": "f054de5e9bc1d649ca06dd7c4c74a3f5011c0959e939ff93ac70784bb7ff123f", "relations": [], "version": "9.5.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.1-1ebe77af55a3f9ab", "cves": [], "html": "Avoid pushdown of HAVING clauses when grouping sets are used (Andrew Gierth)
", "text": "Avoid pushdown of HAVING clauses when grouping sets are used (Andrew Gierth)", "title": "Avoid pushdown of HAVING clauses when grouping sets are used", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "6f9617097f5a5b852007b305055dbd8a21b4cc454e695ef73bd6068be35beedf", "section_path": ["Changes"], "commit_groups": [["87dbc72a7", "a6897efab"]], "identity_text": "Avoid pushdown of HAVING clauses when grouping sets are used (Andrew Gierth)", "commit_aliases": ["87dbc72a7", "a6897efab"], "source_commits": ["87dbc72a7"], "source_entry_id": "9.5.1/changes/003", "db_id": "a81d08446582da4d624d0fca8eec950b", "patch_ids": ["cce6cb50a00901ba9dc0f769d0b5b032"], "statement_hash": "c917f9723e0b54ee747a5cef4027630f946f1419653be12054112333a84b4076", "relations": [], "version": "9.5.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.1-f7d48d04fe562df7", "cves": [], "html": "Fix deparsing of ON CONFLICT arbiter WHERE clauses (Peter Geoghegan)
", "text": "Fix deparsing of ON CONFLICT arbiter WHERE clauses (Peter Geoghegan)", "title": "Fix deparsing of ON CONFLICT arbiter WHERE clauses", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "31512443676c2ac3bbb1ee213bb6d0b065400e7b64a33d7c82abc7ff0ee7cc4f", "section_path": ["Changes"], "commit_groups": [["82406d6ff", "cc2ca9319"]], "identity_text": "Fix deparsing of ON CONFLICT arbiter WHERE clauses (Peter Geoghegan)", "commit_aliases": ["82406d6ff", "cc2ca9319"], "source_commits": ["82406d6ff"], "source_entry_id": "9.5.1/changes/004", "db_id": "8a40745385ecf37b6c3e6228eea3bb67", "patch_ids": ["020eb461cfa64ace114f900472459c9e"], "statement_hash": "f81bab630f83d06b767a041109a5ee8580aebb53ade2f9458b3843e7909930dc", "relations": [], "version": "9.5.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.1-bdae358c081d9890", "cves": [], "html": "Make %h and %r escapes in log_line_prefix work for messages emitted due to log_connections (Tom Lane)
\nPreviously, %h/%r started to work just after a new session had emitted the \"connection received\" log message; now they work for that message too.
", "text": "Make %h and %r escapes in log_line_prefix work for messages emitted due to log_connections (Tom Lane) Previously, %h/%r started to work just after a new session had emitted the \"connection received\" log message; now they work for that message too.", "title": "Make %h and %r escapes in log_line_prefix work for messages emitted due to log_connections", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "524ab5fc9127fa1fe1203725d7a634010f9983154f06673adeb85dfbacb1b42b", "section_path": ["Changes"], "commit_groups": [["2acb682f6", "2b3983158", "3a7af9d73", "9bbfca8fd", "b043df093", "b8682a715"]], "identity_text": "Make %h and %r escapes in log_line_prefix work for messages emitted due to log_connections (Tom Lane) Previously, %h/%r started to work just after a new session had emitted the connection received log message; now they work for that message too.", "commit_aliases": ["2acb682f6", "2b3983158", "3a7af9d73", "9bbfca8fd", "b043df093", "b8682a715"], "source_commits": ["2acb682f6"], "source_entry_id": "9.5.1/changes/005", "db_id": "6cc1fd169e073e22555fc531aff02d28", "patch_ids": ["8070190b021dab3e3dd6de9c25508d94"], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc", "relations": [{"rule": 2, "type": "equivalent", "target": "7caf7f1373b5cb1b3c69c8e5a4f8f302", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc"}}, {"rule": 2, "type": "equivalent", "target": "7cbb23e7d2754a3bd8e761e886e63406", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc"}}, {"rule": 2, "type": "equivalent", "target": "885ed48fb5fbfb10eada458542befc93", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc"}}, {"rule": 2, "type": "equivalent", "target": "dbb4d11812f0944feba47107395dba8f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc"}}], "version": "9.5.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "7caf7f1373b5cb1b3c69c8e5a4f8f302", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "Make %h and %r escapes in log_line_prefix work for messages emitted due to log_connections", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc"}, "url": "/docs/compare/?release=9.4.6#9.4.6-bdae358c081d9890", "source_url": "/docs/release/9.4.6/#AEN122667"}, {"db_id": "885ed48fb5fbfb10eada458542befc93", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "Make %h and %r escapes in log_line_prefix work for messages emitted due to log_connections", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc"}, "url": "/docs/compare/?release=9.3.11#9.3.11-bdae358c081d9890", "source_url": "/docs/release/9.3.11/#AEN116895"}, {"db_id": "7cbb23e7d2754a3bd8e761e886e63406", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "Make %h and %r escapes in log_line_prefix work for messages emitted due to log_connections", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc"}, "url": "/docs/compare/?release=9.2.15#9.2.15-bdae358c081d9890", "source_url": "/docs/release/9.2.15/#AEN111801"}, {"db_id": "dbb4d11812f0944feba47107395dba8f", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "Make %h and %r escapes in log_line_prefix work for messages emitted due to log_connections", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "fde27ff894818314fdc8ea270864cc6f5f13055f8344c2ef3495f3d94f0a75cc"}, "url": "/docs/compare/?release=9.1.20#9.1.20-bdae358c081d9890", "source_url": "/docs/release/9.1.20/#AEN107334"}]}, {"id": "9.5.1-feaa713f6f96765b", "cves": [], "html": "Avoid leaking a token handle during SSPI authentication (Christian Ullrich)
", "text": "Avoid leaking a token handle during SSPI authentication (Christian Ullrich)", "title": "Avoid leaking a token handle during SSPI authentication", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "6e00352525219b364bf7bec2bdd6b5991a0d8e7f973838f788d127d1e4f09497", "section_path": ["Changes"], "commit_groups": [["3276ca303", "6a61d1ff9", "77d8edcf5", "ab49f87d5", "b1c0f92eb", "df0bd5a0f"]], "identity_text": "Avoid leaking a token handle during SSPI authentication (Christian Ullrich)", "commit_aliases": ["3276ca303", "6a61d1ff9", "77d8edcf5", "ab49f87d5", "b1c0f92eb", "df0bd5a0f"], "source_commits": ["3276ca303"], "source_entry_id": "9.5.1/changes/006", "db_id": "5e825f5f564b8ef9b8c2ffbaf04b47cb", "patch_ids": ["043850648c6e2fcf66f222c23e6cdeb7"], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160", "relations": [{"rule": 2, "type": "equivalent", "target": "2e51514f5864394cf46f8e85f7419104", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160"}}, {"rule": 2, "type": "equivalent", "target": "438714cc5e6c71db4312eb35fbebec55", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160"}}, {"rule": 2, "type": "equivalent", "target": "a4a1520f5f054523d7c0e2fe9df3ced2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160"}}, {"rule": 2, "type": "equivalent", "target": "f3b2f1ddac374281dba34c16bc28d77e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160"}}], "version": "9.5.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "f3b2f1ddac374281dba34c16bc28d77e", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "Avoid leaking a token handle during SSPI authentication", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160"}, "url": "/docs/compare/?release=9.4.6#9.4.6-feaa713f6f96765b", "source_url": "/docs/release/9.4.6/#AEN122667"}, {"db_id": "438714cc5e6c71db4312eb35fbebec55", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "Avoid leaking a token handle during SSPI authentication", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160"}, "url": "/docs/compare/?release=9.3.11#9.3.11-feaa713f6f96765b", "source_url": "/docs/release/9.3.11/#AEN116895"}, {"db_id": "2e51514f5864394cf46f8e85f7419104", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "Avoid leaking a token handle during SSPI authentication", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160"}, "url": "/docs/compare/?release=9.2.15#9.2.15-feaa713f6f96765b", "source_url": "/docs/release/9.2.15/#AEN111801"}, {"db_id": "a4a1520f5f054523d7c0e2fe9df3ced2", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "Avoid leaking a token handle during SSPI authentication", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "012913b378f1f48c997b8ee492e4b5b37c9a4c93f4afddd3ff1c98326e4a2160"}, "url": "/docs/compare/?release=9.1.20#9.1.20-feaa713f6f96765b", "source_url": "/docs/release/9.1.20/#AEN107334"}]}, {"id": "9.5.1-8d701cd74d9933b6", "cves": [], "html": "Fix psql's \\det command to interpret its pattern argument the same way as other \\d commands with potentially schema-qualified patterns do (Reece Hart)
", "text": "Fix psql's \\det command to interpret its pattern argument the same way as other \\d commands with potentially schema-qualified patterns do (Reece Hart)", "title": "Fix psql's \\det command to interpret its pattern argument the same way as other \\d commands with potentially schema-qualified patterns do", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "2934761f32aeac456966ea22ed7d360753afeefcfcb88be526134be654340215", "section_path": ["Changes"], "commit_groups": [["56251f396", "5849b6e32", "7e2247047", "a362cc2e3", "db678ca16", "ed5f57218"]], "identity_text": "Fix psql's \\det command to interpret its pattern argument the same way as other \\d commands with potentially schema-qualified patterns do (Reece Hart)", "commit_aliases": ["56251f396", "5849b6e32", "7e2247047", "a362cc2e3", "db678ca16", "ed5f57218"], "source_commits": ["56251f396"], "source_entry_id": "9.5.1/changes/007", "db_id": "56543181c886e0a9e02d16ceb110d586", "patch_ids": ["980fc05fa3fb10b765e92533448afdf2"], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44", "relations": [{"rule": 2, "type": "equivalent", "target": "72c2989920da86c253ab09eecb31b14e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44"}}, {"rule": 2, "type": "equivalent", "target": "a44ae03d4941be3dc2e2c64890df9f35", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44"}}, {"rule": 2, "type": "equivalent", "target": "ae26b564c233409889218223f5607057", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44"}}, {"rule": 2, "type": "equivalent", "target": "c2275e8ef3b9fe637be3a173f5a783ae", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44"}}], "version": "9.5.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c2275e8ef3b9fe637be3a173f5a783ae", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "Fix psql's \\det command to interpret its pattern argument the same way as other \\d commands with potentially schema-qualified patterns do", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44"}, "url": "/docs/compare/?release=9.4.6#9.4.6-8d701cd74d9933b6", "source_url": "/docs/release/9.4.6/#AEN122667"}, {"db_id": "a44ae03d4941be3dc2e2c64890df9f35", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "Fix psql's \\det command to interpret its pattern argument the same way as other \\d commands with potentially schema-qualified patterns do", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44"}, "url": "/docs/compare/?release=9.3.11#9.3.11-8d701cd74d9933b6", "source_url": "/docs/release/9.3.11/#AEN116895"}, {"db_id": "ae26b564c233409889218223f5607057", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "Fix psql's \\det command to interpret its pattern argument the same way as other \\d commands with potentially schema-qualified patterns do", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44"}, "url": "/docs/compare/?release=9.2.15#9.2.15-8d701cd74d9933b6", "source_url": "/docs/release/9.2.15/#AEN111801"}, {"db_id": "72c2989920da86c253ab09eecb31b14e", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "Fix psql's \\det command to interpret its pattern argument the same way as other \\d commands with potentially schema-qualified patterns do", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "79256d97ef2ed9e364cc39b322679681500fab10ebe923dfc4f0522d3545fe44"}, "url": "/docs/compare/?release=9.1.20#9.1.20-8d701cd74d9933b6", "source_url": "/docs/release/9.1.20/#AEN107334"}]}, {"id": "9.5.1-39e06b647a4dcf2a", "cves": [], "html": "In pg_ctl on Windows, check service status to decide where to send output, rather than checking if standard output is a terminal (Michael Paquier)
", "text": "In pg_ctl on Windows, check service status to decide where to send output, rather than checking if standard output is a terminal (Michael Paquier)", "title": "In pg_ctl on Windows, check service status to decide where to send output, rather than checking if standard output is a terminal", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "5725a069624b9666f0fa1ef408405403512d70dc60fdb5543bda4a3f60c91408", "section_path": ["Changes"], "commit_groups": [["5c4cbd5d1", "744d01c9a", "74d4009b8", "a96761391", "b96f6f444", "c7aca3d45"]], "identity_text": "In pg_ctl on Windows, check service status to decide where to send output, rather than checking if standard output is a terminal (Michael Paquier)", "commit_aliases": ["5c4cbd5d1", "744d01c9a", "74d4009b8", "a96761391", "b96f6f444", "c7aca3d45"], "source_commits": ["744d01c9a"], "source_entry_id": "9.5.1/changes/008", "db_id": "fc55b81ca38dd48fd637c4b89b222440", "patch_ids": ["efbbf5bf90d3be34215d8f56c82effd2"], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d", "relations": [{"rule": 2, "type": "equivalent", "target": "46bc5c70bec439f4ae601fe91c34c983", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d"}}, {"rule": 2, "type": "equivalent", "target": "50a28c9cf76d98dccd0ae115ab281817", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d"}}, {"rule": 2, "type": "equivalent", "target": "998f6731981001ad75f03a48efe6cfa2", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d"}}, {"rule": 2, "type": "equivalent", "target": "f2c17c58b814d10bbb6e43d22001d01f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d"}}], "version": "9.5.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f2c17c58b814d10bbb6e43d22001d01f", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "In pg_ctl on Windows, check service status to decide where to send output, rather than checking if standard output is a terminal", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d"}, "url": "/docs/compare/?release=9.4.6#9.4.6-39e06b647a4dcf2a", "source_url": "/docs/release/9.4.6/#AEN122667"}, {"db_id": "46bc5c70bec439f4ae601fe91c34c983", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "In pg_ctl on Windows, check service status to decide where to send output, rather than checking if standard output is a terminal", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d"}, "url": "/docs/compare/?release=9.3.11#9.3.11-39e06b647a4dcf2a", "source_url": "/docs/release/9.3.11/#AEN116895"}, {"db_id": "998f6731981001ad75f03a48efe6cfa2", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "In pg_ctl on Windows, check service status to decide where to send output, rather than checking if standard output is a terminal", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d"}, "url": "/docs/compare/?release=9.2.15#9.2.15-39e06b647a4dcf2a", "source_url": "/docs/release/9.2.15/#AEN111801"}, {"db_id": "50a28c9cf76d98dccd0ae115ab281817", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "In pg_ctl on Windows, check service status to decide where to send output, rather than checking if standard output is a terminal", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b404d198beded8192b6c56dd9af3ca99944268276d611688f7d3cf39aeb4571d"}, "url": "/docs/compare/?release=9.1.20#9.1.20-39e06b647a4dcf2a", "source_url": "/docs/release/9.1.20/#AEN107334"}]}, {"id": "9.5.1-1a73f2c2be5b2e5e", "cves": [], "html": "Fix assorted corner-case bugs in pg_dump's processing of extension member objects (Tom Lane)
", "text": "Fix assorted corner-case bugs in pg_dump's processing of extension member objects (Tom Lane)", "title": "Fix assorted corner-case bugs in pg_dump's processing of extension member objects", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "2e319798e33c8ba0526134260735925be957264ad5cb5636acc8bf83d281fe93", "section_path": ["Changes"], "commit_groups": [["5108013db", "7393208b5", "b87403f70", "be2b27651", "c42df2d46", "e72d7d853"]], "identity_text": "Fix assorted corner-case bugs in pg_dump's processing of extension member objects (Tom Lane)", "commit_aliases": ["5108013db", "7393208b5", "b87403f70", "be2b27651", "c42df2d46", "e72d7d853"], "source_commits": ["c42df2d46"], "source_entry_id": "9.5.1/changes/009", "db_id": "731b97a7fd7086f0d44dbe80bb27f8a5", "patch_ids": ["47aa462eac36b1bcd14ef32c7166d0e5"], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4", "relations": [{"rule": 2, "type": "equivalent", "target": "2457804d08df483237bb75a8f59d49cd", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4"}}, {"rule": 2, "type": "equivalent", "target": "73af11867b35c973d9c8af24f2b31875", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4"}}, {"rule": 2, "type": "equivalent", "target": "e630fa430c08c62d366dea55d599cfc4", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4"}}, {"rule": 2, "type": "equivalent", "target": "fadd4c514c362343f3f596b4eee319e5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4"}}], "version": "9.5.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "73af11867b35c973d9c8af24f2b31875", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "Fix assorted corner-case bugs in pg_dump's processing of extension member objects", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4"}, "url": "/docs/compare/?release=9.4.6#9.4.6-1a73f2c2be5b2e5e", "source_url": "/docs/release/9.4.6/#AEN122667"}, {"db_id": "fadd4c514c362343f3f596b4eee319e5", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "Fix assorted corner-case bugs in pg_dump's processing of extension member objects", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4"}, "url": "/docs/compare/?release=9.3.11#9.3.11-1a73f2c2be5b2e5e", "source_url": "/docs/release/9.3.11/#AEN116895"}, {"db_id": "2457804d08df483237bb75a8f59d49cd", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "Fix assorted corner-case bugs in pg_dump's processing of extension member objects", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4"}, "url": "/docs/compare/?release=9.2.15#9.2.15-1a73f2c2be5b2e5e", "source_url": "/docs/release/9.2.15/#AEN111801"}, {"db_id": "e630fa430c08c62d366dea55d599cfc4", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "Fix assorted corner-case bugs in pg_dump's processing of extension member objects", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "2280fab706b4c2ed445a351017a4d11c031a77ae47bf936aa42b41be487b7fe4"}, "url": "/docs/compare/?release=9.1.20#9.1.20-1a73f2c2be5b2e5e", "source_url": "/docs/release/9.1.20/#AEN107334"}]}, {"id": "9.5.1-717143c34a0c0313", "cves": [], "html": "Fix improper quoting of domain constraint names in pg_dump (Elvis Pranskevichus)
", "text": "Fix improper quoting of domain constraint names in pg_dump (Elvis Pranskevichus)", "title": "Fix improper quoting of domain constraint names in pg_dump", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "4248a4e9dfa49c2be52983f84c88ca0aecbeb76f2008b9dc613ce5042ce8e9b8", "section_path": ["Changes"], "commit_groups": [["1e910cf5b", "df43fcf45"]], "identity_text": "Fix improper quoting of domain constraint names in pg_dump (Elvis Pranskevichus)", "commit_aliases": ["1e910cf5b", "df43fcf45"], "source_commits": ["1e910cf5b"], "source_entry_id": "9.5.1/changes/010", "db_id": "0c42970b0b6922a74212ca2a3e41d178", "patch_ids": ["89e8811d9d7fe86c032a439a8c0942b0"], "statement_hash": "aed83ff5617aaa2b75b1d172725cb7b08b3f01cd39781a0ce7ebb41dc8b34156", "relations": [], "version": "9.5.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.1-237cb3f7526babac", "cves": [], "html": "Make pg_dump mark a view's triggers as needing to be processed after its rule, to prevent possible failure during parallel pg_restore (Tom Lane)
", "text": "Make pg_dump mark a view's triggers as needing to be processed after its rule, to prevent possible failure during parallel pg_restore (Tom Lane)", "title": "Make pg_dump mark a view's triggers as needing to be processed after its rule, to prevent possible failure during parallel pg_restore", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "77701c0eed34d059806bb959fb9962cf60619e0e8b5014e1a21b88cd5a15e04f", "section_path": ["Changes"], "commit_groups": [["0ed707e9b", "411e2b0d5", "4f58a7003", "9c704632c", "aefbc208b", "b99dd7170"]], "identity_text": "Make pg_dump mark a view's triggers as needing to be processed after its rule, to prevent possible failure during parallel pg_restore (Tom Lane)", "commit_aliases": ["0ed707e9b", "411e2b0d5", "4f58a7003", "9c704632c", "aefbc208b", "b99dd7170"], "source_commits": ["b99dd7170"], "source_entry_id": "9.5.1/changes/011", "db_id": "b2e8b7cf11bd9b63b30920bdeb93c80d", "patch_ids": ["f068a51d7bdecc3c0281c9345157d145"], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3", "relations": [{"rule": 2, "type": "equivalent", "target": "639282d960c0c0b620edebea4b414918", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3"}}, {"rule": 2, "type": "equivalent", "target": "63b8a63bbdbf13afeea084b329b5de75", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3"}}, {"rule": 2, "type": "equivalent", "target": "7164bcf02cc88ab85c08ce3c606ae32c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3"}}, {"rule": 2, "type": "equivalent", "target": "e36862b792e753bdfce395af7b742909", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3"}}], "version": "9.5.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "7164bcf02cc88ab85c08ce3c606ae32c", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "Make pg_dump mark a view's triggers as needing to be processed after its rule, to prevent possible failure during parallel pg_restore", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3"}, "url": "/docs/compare/?release=9.4.6#9.4.6-237cb3f7526babac", "source_url": "/docs/release/9.4.6/#AEN122667"}, {"db_id": "63b8a63bbdbf13afeea084b329b5de75", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "Make pg_dump mark a view's triggers as needing to be processed after its rule, to prevent possible failure during parallel pg_restore", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3"}, "url": "/docs/compare/?release=9.3.11#9.3.11-237cb3f7526babac", "source_url": "/docs/release/9.3.11/#AEN116895"}, {"db_id": "e36862b792e753bdfce395af7b742909", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "Make pg_dump mark a view's triggers as needing to be processed after its rule, to prevent possible failure during parallel pg_restore", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3"}, "url": "/docs/compare/?release=9.2.15#9.2.15-237cb3f7526babac", "source_url": "/docs/release/9.2.15/#AEN111801"}, {"db_id": "639282d960c0c0b620edebea4b414918", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "Make pg_dump mark a view's triggers as needing to be processed after its rule, to prevent possible failure during parallel pg_restore", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "dc6aaf1f5385330a98f6748b2c1e31c2c612076c0e3c2e8f033d3bdc03ff77a3"}, "url": "/docs/compare/?release=9.1.20#9.1.20-237cb3f7526babac", "source_url": "/docs/release/9.1.20/#AEN107334"}]}, {"id": "9.5.1-ee485decb10f28d9", "cves": [], "html": "Install guards in pgbench against corner-case overflow conditions during evaluation of script-specified division or modulo operators (Fabien Coelho, Michael Paquier)
", "text": "Install guards in pgbench against corner-case overflow conditions during evaluation of script-specified division or modulo operators (Fabien Coelho, Michael Paquier)", "title": "Install guards in pgbench against corner-case overflow conditions during evaluation of script-specified division or modulo operators", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "aed2a0ec093010ea8eb85c16b4a0826a6d8a11475174d1920558c04aaf69eca5", "section_path": ["Changes"], "commit_groups": [["014796aa3", "4c8b07d3c", "64f5edca2", "829757c8a", "b63a4f418", "c33d1a8d5"]], "identity_text": "Install guards in pgbench against corner-case overflow conditions during evaluation of script-specified division or modulo operators (Fabien Coelho, Michael Paquier)", "commit_aliases": ["014796aa3", "4c8b07d3c", "64f5edca2", "829757c8a", "b63a4f418", "c33d1a8d5"], "source_commits": ["829757c8a"], "source_entry_id": "9.5.1/changes/012", "db_id": "9acad733ddf9374f74a8f9a01331be18", "patch_ids": ["dbcead3e052783268db3eb4290d0645b"], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0", "relations": [{"rule": 2, "type": "equivalent", "target": "4429311b4c20fda04d0ca5162000d686", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0"}}, {"rule": 2, "type": "equivalent", "target": "463b7c278954267c51dffc4cc837224d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0"}}, {"rule": 2, "type": "equivalent", "target": "8343cc2c0cc89f60b2a1ea88aed18d6f", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0"}}, {"rule": 2, "type": "equivalent", "target": "a93a7956fc7b9f395d4fc12c4ba43568", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0"}}], "version": "9.5.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "463b7c278954267c51dffc4cc837224d", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "Install guards in pgbench against corner-case overflow conditions during evaluation of script-specified division or modulo operators", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0"}, "url": "/docs/compare/?release=9.4.6#9.4.6-ee485decb10f28d9", "source_url": "/docs/release/9.4.6/#AEN122667"}, {"db_id": "a93a7956fc7b9f395d4fc12c4ba43568", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "Install guards in pgbench against corner-case overflow conditions during evaluation of script-specified division or modulo operators", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0"}, "url": "/docs/compare/?release=9.3.11#9.3.11-ee485decb10f28d9", "source_url": "/docs/release/9.3.11/#AEN116895"}, {"db_id": "8343cc2c0cc89f60b2a1ea88aed18d6f", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "Install guards in pgbench against corner-case overflow conditions during evaluation of script-specified division or modulo operators", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0"}, "url": "/docs/compare/?release=9.2.15#9.2.15-ee485decb10f28d9", "source_url": "/docs/release/9.2.15/#AEN111801"}, {"db_id": "4429311b4c20fda04d0ca5162000d686", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "Install guards in pgbench against corner-case overflow conditions during evaluation of script-specified division or modulo operators", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6fa6f9c75d6b8001063fd0b5e76296556c995444580bfe40bb47117e6b139dd0"}, "url": "/docs/compare/?release=9.1.20#9.1.20-ee485decb10f28d9", "source_url": "/docs/release/9.1.20/#AEN107334"}]}, {"id": "9.5.1-b448e3f608814067", "cves": [], "html": "Suppress useless warning message when pg_receivexlog connects to a pre-9.4 server (Marco Nenciarini)
", "text": "Suppress useless warning message when pg_receivexlog connects to a pre-9.4 server (Marco Nenciarini)", "title": "Suppress useless warning message when pg_receivexlog connects to a pre-9.4 server", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "0fe30a54379bd2338d8e58f616c693ea4be90e647c638d9fbad1677f96bd253e", "section_path": ["Changes"], "commit_groups": [["4aecd22d3", "7ef311eb4"]], "identity_text": "Suppress useless warning message when pg_receivexlog connects to a pre-9.4 server (Marco Nenciarini)", "commit_aliases": ["4aecd22d3", "7ef311eb4"], "source_commits": ["7ef311eb4"], "source_entry_id": "9.5.1/changes/013", "db_id": "d75f44ac472b001f60323a653062ab34", "patch_ids": ["4f85028094a2ca8f0c0d3adc238c9239"], "statement_hash": "fdb6a52fe1bb01a328d28b47228b6fe4dbd7328b369af638e8993565fbd00755", "relations": [], "version": "9.5.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.1-20bcfad43cf9c2d8", "cves": [], "html": "Avoid dump/reload problems when using both plpython2 and plpython3 (Tom Lane)
\nIn principle, both versions of PL/Python can be used in the same database, though not in the same session (because the two versions of libpython cannot safely be used concurrently). However, pg_restore and pg_upgrade both do things that can fall foul of the same-session restriction. Work around that by changing the timing of the check.
", "text": "Avoid dump/reload problems when using both plpython2 and plpython3 (Tom Lane) In principle, both versions of PL/Python can be used in the same database, though not in the same session (because the two versions of libpython cannot safely be used concurrently). However, pg_restore and pg_upgrade both do things that can fall foul of the same-session restriction. Work around that by changing the timing of the check.", "title": "Avoid dump/reload problems when using both plpython2 and plpython3", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "552fa7de07fa605440aef3fd02ef0ecce882d2734845ecd8afb209ff2f02b59f", "section_path": ["Changes"], "commit_groups": [["0ddeaba7e", "22815752e", "3843ba510", "866566a69", "db8fa56d6"], ["5ef26b8de", "fb6fcbd33"]], "identity_text": "Avoid dump/reload problems when using both plpython2 and plpython3 (Tom Lane) In principle, both versions of PL/Python can be used in the same database, though not in the same session (because the two versions of libpython cannot safely be used concurrently). However, pg_restore and pg_upgrade both do things that can fall foul of the same-session restriction. Work around that by changing the timing of the check.", "commit_aliases": ["0ddeaba7e", "22815752e", "3843ba510", "5ef26b8de", "866566a69", "db8fa56d6", "fb6fcbd33"], "source_commits": ["5ef26b8de", "db8fa56d6"], "source_entry_id": "9.5.1/changes/014", "db_id": "73bfe5d2b41d97c4d9debc1380abac6d", "patch_ids": ["33155a03c349caa0f3b86db8350bb26f", "3cbfc8ffb21ad3584938fd2b08b31dfa"], "statement_hash": "b2c01f4b617880c0b4e4761aee6ee4f8e87a36a38ced76f9fceb6655ee777068", "relations": [{"rule": 2, "type": "equivalent", "target": "5c4e991f8d4a642900a543199662451d", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b2c01f4b617880c0b4e4761aee6ee4f8e87a36a38ced76f9fceb6655ee777068"}}, {"rule": 2, "type": "equivalent", "target": "7fdfe610b682c284f5187886cab8f091", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b2c01f4b617880c0b4e4761aee6ee4f8e87a36a38ced76f9fceb6655ee777068"}}, {"rule": 2, "type": "equivalent", "target": "f96612f238be71ec939b6687fd44e0ef", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b2c01f4b617880c0b4e4761aee6ee4f8e87a36a38ced76f9fceb6655ee777068"}}], "version": "9.5.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "7fdfe610b682c284f5187886cab8f091", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "Avoid dump/reload problems when using both plpython2 and plpython3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b2c01f4b617880c0b4e4761aee6ee4f8e87a36a38ced76f9fceb6655ee777068"}, "url": "/docs/compare/?release=9.4.6#9.4.6-20bcfad43cf9c2d8", "source_url": "/docs/release/9.4.6/#AEN122667"}, {"db_id": "5c4e991f8d4a642900a543199662451d", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "Avoid dump/reload problems when using both plpython2 and plpython3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b2c01f4b617880c0b4e4761aee6ee4f8e87a36a38ced76f9fceb6655ee777068"}, "url": "/docs/compare/?release=9.3.11#9.3.11-20bcfad43cf9c2d8", "source_url": "/docs/release/9.3.11/#AEN116895"}, {"db_id": "f96612f238be71ec939b6687fd44e0ef", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "Avoid dump/reload problems when using both plpython2 and plpython3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b2c01f4b617880c0b4e4761aee6ee4f8e87a36a38ced76f9fceb6655ee777068"}, "url": "/docs/compare/?release=9.2.15#9.2.15-20bcfad43cf9c2d8", "source_url": "/docs/release/9.2.15/#AEN111801"}]}, {"id": "9.5.1-65f5ddc7aeb03765", "cves": [], "html": "Fix PL/Python regression tests to pass with Python 3.5 (Peter Eisentraut)
", "text": "Fix PL/Python regression tests to pass with Python 3.5 (Peter Eisentraut)", "title": "Fix PL/Python regression tests to pass with Python 3.5", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "5416494c28506e35c4e5c6199da40e786243910596e4da9b594da441a8c96b16", "section_path": ["Changes"], "commit_groups": [["82076c1e4", "a37ab812c", "f1b898759"], ["a66c1fcdd"]], "identity_text": "Fix PL/Python regression tests to pass with Python 3.5 (Peter Eisentraut)", "commit_aliases": ["82076c1e4", "a37ab812c", "a66c1fcdd", "f1b898759"], "source_commits": ["a66c1fcdd", "f1b898759"], "source_entry_id": "9.5.1/changes/015", "db_id": "87806806231c4a8aae83fd9987903150", "patch_ids": ["0c0e045e40fea071e4b57a1bc47fc096", "eb846bdeeb31a393a1a53b301d044b79"], "statement_hash": "237dcc688f27a213242316d250ad373c3d96ed314c1e3cea371795c31275bc9d", "relations": [{"rule": 2, "type": "equivalent", "target": "55b28d130ac75b6dc9cfaabf8bcdb824", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "237dcc688f27a213242316d250ad373c3d96ed314c1e3cea371795c31275bc9d"}}, {"rule": 2, "type": "equivalent", "target": "a5ea72bcf0bc30d1ac85879513b1a196", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "237dcc688f27a213242316d250ad373c3d96ed314c1e3cea371795c31275bc9d"}}, {"rule": 2, "type": "equivalent", "target": "d386cbd1ac4a9f26bef75a9d608f038a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "237dcc688f27a213242316d250ad373c3d96ed314c1e3cea371795c31275bc9d"}}], "version": "9.5.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "d386cbd1ac4a9f26bef75a9d608f038a", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "Fix PL/Python regression tests to pass with Python 3.5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "237dcc688f27a213242316d250ad373c3d96ed314c1e3cea371795c31275bc9d"}, "url": "/docs/compare/?release=9.4.6#9.4.6-65f5ddc7aeb03765", "source_url": "/docs/release/9.4.6/#AEN122667"}, {"db_id": "a5ea72bcf0bc30d1ac85879513b1a196", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "Fix PL/Python regression tests to pass with Python 3.5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "237dcc688f27a213242316d250ad373c3d96ed314c1e3cea371795c31275bc9d"}, "url": "/docs/compare/?release=9.3.11#9.3.11-65f5ddc7aeb03765", "source_url": "/docs/release/9.3.11/#AEN116895"}, {"db_id": "55b28d130ac75b6dc9cfaabf8bcdb824", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "Fix PL/Python regression tests to pass with Python 3.5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "237dcc688f27a213242316d250ad373c3d96ed314c1e3cea371795c31275bc9d"}, "url": "/docs/compare/?release=9.2.15#9.2.15-65f5ddc7aeb03765", "source_url": "/docs/release/9.2.15/#AEN111801"}]}, {"id": "9.5.1-4fa6f15eb32b6cbe", "cves": ["CVE-2016-0766"], "html": "Prevent certain PL/Java parameters from being set by non-superusers (Noah Misch)
\nThis change mitigates a PL/Java security bug (CVE-2016-0766), which was fixed in PL/Java by marking these parameters as superuser-only. To fix the security hazard for sites that update PostgreSQL more frequently than PL/Java, make the core code aware of them also.
", "text": "Prevent certain PL/Java parameters from being set by non-superusers (Noah Misch) This change mitigates a PL/Java security bug (CVE-2016-0766), which was fixed in PL/Java by marking these parameters as superuser-only. To fix the security hazard for sites that update PostgreSQL more frequently than PL/Java, make the core code aware of them also.", "title": "Prevent certain PL/Java parameters from being set by non-superusers", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "65ada80d16c184c7b2bfa993f528e031432a64b029e02243e50a34e77fb06ecc", "section_path": ["Changes"], "commit_groups": [["0089dd34a", "34e91736b", "b1f591c50", "de9766d39", "ed6deeb7a", "f4aa3a18a"]], "identity_text": "Prevent certain PL/Java parameters from being set by non-superusers (Noah Misch) This change mitigates a PL/Java security bug (CVE-2016-0766), which was fixed in PL/Java by marking these parameters as superuser-only. To fix the security hazard for sites that update PostgreSQL more frequently than PL/Java, make the core code aware of them also.", "commit_aliases": ["0089dd34a", "34e91736b", "b1f591c50", "de9766d39", "ed6deeb7a", "f4aa3a18a"], "source_commits": ["0089dd34a"], "source_entry_id": "9.5.1/changes/016", "db_id": "97dc39fa0e7bec5e2534a2b04109f605", "patch_ids": ["c03a543ab7fae4ba45f27501433bf595"], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11", "relations": [{"rule": 2, "type": "equivalent", "target": "4917d87c69fd2381f0cd0bb043dd7284", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11"}}, {"rule": 2, "type": "equivalent", "target": "c75a2e5f772bd39312a83d259c6eca92", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11"}}, {"rule": 2, "type": "equivalent", "target": "da4a43b885b72a66ad8ccbcf7f4c082b", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11"}}, {"rule": 2, "type": "equivalent", "target": "e039ea2a4900d0587260a96ef5854826", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11"}}], "version": "9.5.1", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "c75a2e5f772bd39312a83d259c6eca92", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "Prevent certain PL/Java parameters from being set by non-superusers", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11"}, "url": "/docs/compare/?release=9.4.6#9.4.6-4fa6f15eb32b6cbe", "source_url": "/docs/release/9.4.6/#AEN122667"}, {"db_id": "e039ea2a4900d0587260a96ef5854826", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "Prevent certain PL/Java parameters from being set by non-superusers", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11"}, "url": "/docs/compare/?release=9.3.11#9.3.11-4fa6f15eb32b6cbe", "source_url": "/docs/release/9.3.11/#AEN116895"}, {"db_id": "da4a43b885b72a66ad8ccbcf7f4c082b", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "Prevent certain PL/Java parameters from being set by non-superusers", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11"}, "url": "/docs/compare/?release=9.2.15#9.2.15-4fa6f15eb32b6cbe", "source_url": "/docs/release/9.2.15/#AEN111801"}, {"db_id": "4917d87c69fd2381f0cd0bb043dd7284", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "Prevent certain PL/Java parameters from being set by non-superusers", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b7641a8f14767c8e49f5f56ee76f2f9bf1af49b7c7045d413e7ea1f09a6f7f11"}, "url": "/docs/compare/?release=9.1.20#9.1.20-4fa6f15eb32b6cbe", "source_url": "/docs/release/9.1.20/#AEN107334"}]}, {"id": "9.5.1-b36dd56f1a8e27e0", "cves": [], "html": "Fix ecpg-supplied header files to not contain comments continued from a preprocessor directive line onto the next line (Michael Meskes)
\nSuch a comment is rejected by ecpg. It's not yet clear whether ecpg itself should be changed.
", "text": "Fix ecpg-supplied header files to not contain comments continued from a preprocessor directive line onto the next line (Michael Meskes) Such a comment is rejected by ecpg. It's not yet clear whether ecpg itself should be changed.", "title": "Fix ecpg-supplied header files to not contain comments continued from a preprocessor directive line onto the next line", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "dc136081e9898e255bf89931c5ff9b85e5904e7d50b0a9329a1128145ef8e0df", "section_path": ["Changes"], "commit_groups": [["0b55fef39", "40482e606", "79782b407", "7a58d19b0", "d9ce5d201"], ["33b26426e"]], "identity_text": "Fix ecpg-supplied header files to not contain comments continued from a preprocessor directive line onto the next line (Michael Meskes) Such a comment is rejected by ecpg. It's not yet clear whether ecpg itself should be changed.", "commit_aliases": ["0b55fef39", "33b26426e", "40482e606", "79782b407", "7a58d19b0", "d9ce5d201"], "source_commits": ["33b26426e", "40482e606"], "source_entry_id": "9.5.1/changes/017", "db_id": "25923104378ff078f6db6dfc3a69ed95", "patch_ids": ["1a951dfc20a8eff451ba0d82eabc2f99", "1b977972875e2576ffa817c974a98cdd"], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90", "relations": [{"rule": 2, "type": "equivalent", "target": "0bf8a231c2b475eb4b99b5b31cdf39ee", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90"}}, {"rule": 2, "type": "equivalent", "target": "46427e125a70e51c6f0c98928b775de3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90"}}, {"rule": 2, "type": "equivalent", "target": "50f0a9e0cfb049a7cead7166e0526ccf", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90"}}, {"rule": 2, "type": "equivalent", "target": "d63bda274e38217adfc55e5c5421c6d9", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90"}}], "version": "9.5.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "50f0a9e0cfb049a7cead7166e0526ccf", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "Fix ecpg-supplied header files to not contain comments continued from a preprocessor directive line onto the next line", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90"}, "url": "/docs/compare/?release=9.4.6#9.4.6-b36dd56f1a8e27e0", "source_url": "/docs/release/9.4.6/#AEN122667"}, {"db_id": "d63bda274e38217adfc55e5c5421c6d9", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "Fix ecpg-supplied header files to not contain comments continued from a preprocessor directive line onto the next line", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90"}, "url": "/docs/compare/?release=9.3.11#9.3.11-b36dd56f1a8e27e0", "source_url": "/docs/release/9.3.11/#AEN116895"}, {"db_id": "46427e125a70e51c6f0c98928b775de3", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "Fix ecpg-supplied header files to not contain comments continued from a preprocessor directive line onto the next line", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90"}, "url": "/docs/compare/?release=9.2.15#9.2.15-b36dd56f1a8e27e0", "source_url": "/docs/release/9.2.15/#AEN111801"}, {"db_id": "0bf8a231c2b475eb4b99b5b31cdf39ee", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "Fix ecpg-supplied header files to not contain comments continued from a preprocessor directive line onto the next line", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "d373359c60c9b2678de3e08e31b5db658d4c439df52a1da3998a616757e8fb90"}, "url": "/docs/compare/?release=9.1.20#9.1.20-b36dd56f1a8e27e0", "source_url": "/docs/release/9.1.20/#AEN107334"}]}, {"id": "9.5.1-c477fe792cb0677d", "cves": [], "html": "Fix hstore_to_json_loose()'s test for whether an hstore value can be converted to a JSON number (Tom Lane)
Previously this function could be fooled by non-alphanumeric trailing characters, leading to emitting syntactically-invalid JSON.
", "text": "Fix hstore_to_json_loose()'s test for whether an hstore value can be converted to a JSON number (Tom Lane) Previously this function could be fooled by non-alphanumeric trailing characters, leading to emitting syntactically-invalid JSON.", "title": "Fix hstore_to_json_loose()'s test for whether an hstore value can be converted to a JSON number", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "66e58b57c6881dab8412ed70ed75cc97f99b7fe5dfb5851ccc4e3757ae44ba32", "section_path": ["Changes"], "commit_groups": [["1c291624b", "1f2b195eb", "aa223a037", "e6ecc93a1"]], "identity_text": "Fix hstore_to_json_loose()'s test for whether an hstore value can be converted to a JSON number (Tom Lane) Previously this function could be fooled by non-alphanumeric trailing characters, leading to emitting syntactically-invalid JSON.", "commit_aliases": ["1c291624b", "1f2b195eb", "aa223a037", "e6ecc93a1"], "source_commits": ["1c291624b"], "source_entry_id": "9.5.1/changes/018", "db_id": "0c8d921d241d195812cf1b0b980d872a", "patch_ids": ["74ddec990a472a59cd4decea8f9df92c"], "statement_hash": "0af8bbd9bec4ee929e53a8ba062ce284da2e6662bf12024a57f4329ee6b33bc8", "relations": [{"rule": 2, "type": "equivalent", "target": "03f2410191b24ef609506ead82abc566", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0af8bbd9bec4ee929e53a8ba062ce284da2e6662bf12024a57f4329ee6b33bc8"}}, {"rule": 2, "type": "equivalent", "target": "04bda60ae91abda4ba10b35de91c4e22", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0af8bbd9bec4ee929e53a8ba062ce284da2e6662bf12024a57f4329ee6b33bc8"}}], "version": "9.5.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "04bda60ae91abda4ba10b35de91c4e22", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "Fix hstore_to_json_loose()'s test for whether an hstore value can be converted to a JSON number", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0af8bbd9bec4ee929e53a8ba062ce284da2e6662bf12024a57f4329ee6b33bc8"}, "url": "/docs/compare/?release=9.4.6#9.4.6-c477fe792cb0677d", "source_url": "/docs/release/9.4.6/#AEN122667"}, {"db_id": "03f2410191b24ef609506ead82abc566", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "Fix hstore_to_json_loose()'s test for whether an hstore value can be converted to a JSON number", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "0af8bbd9bec4ee929e53a8ba062ce284da2e6662bf12024a57f4329ee6b33bc8"}, "url": "/docs/compare/?release=9.3.11#9.3.11-c477fe792cb0677d", "source_url": "/docs/release/9.3.11/#AEN116895"}]}, {"id": "9.5.1-279b22774cf5d926", "cves": [], "html": "In contrib/postgres_fdw, fix bugs triggered by use of tableoid in data-modifying commands (Etsuro Fujita, Robert Haas)
", "text": "In contrib/postgres_fdw, fix bugs triggered by use of tableoid in data-modifying commands (Etsuro Fujita, Robert Haas)", "title": "In contrib/postgres_fdw, fix bugs triggered by use of tableoid in data-modifying commands", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "43331eab26eba41b01203a6c31a5dd2d7b0cf29e431cd84ad3bd9735e0fbc60b", "section_path": ["Changes"], "commit_groups": [["1f3294c22", "453d40817", "9418d79a7"], ["2099b911d", "37c84570b", "d160e2a34"]], "identity_text": "In contrib/postgres_fdw, fix bugs triggered by use of tableoid in data-modifying commands (Etsuro Fujita, Robert Haas)", "commit_aliases": ["1f3294c22", "2099b911d", "37c84570b", "453d40817", "9418d79a7", "d160e2a34"], "source_commits": ["453d40817", "d160e2a34"], "source_entry_id": "9.5.1/changes/019", "db_id": "c4c2ba6603cd54bca3e4d0558afedff5", "patch_ids": ["b8f1a6a792d35e65d2c8f40a017b8491", "f3086b86a159941be300c18eec4c5247"], "statement_hash": "b50820b450dca25e0fa742e53e3618238b1e7b8647181de22971a4a85648ed32", "relations": [{"rule": 2, "type": "equivalent", "target": "d7c09d03805867d10fad0549fb0b2120", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b50820b450dca25e0fa742e53e3618238b1e7b8647181de22971a4a85648ed32"}}], "version": "9.5.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "d7c09d03805867d10fad0549fb0b2120", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "In contrib/postgres_fdw, fix bugs triggered by use of tableoid in data-modifying commands", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "b50820b450dca25e0fa742e53e3618238b1e7b8647181de22971a4a85648ed32"}, "url": "/docs/compare/?release=9.4.6#9.4.6-279b22774cf5d926", "source_url": "/docs/release/9.4.6/#AEN122667"}]}, {"id": "9.5.1-f80ebdea7e368780", "cves": [], "html": "Fix ill-advised restriction of NAMEDATALEN to be less than 256 (Robert Haas, Tom Lane)
", "text": "Fix ill-advised restriction of NAMEDATALEN to be less than 256 (Robert Haas, Tom Lane)", "title": "Fix ill-advised restriction of NAMEDATALEN to be less than 256", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "2d5f7aa2020be3dcccd8c9eeee360e950465d41f546a599de3488ff79264340b", "section_path": ["Changes"], "commit_groups": [["47acf3add", "a396144ac"]], "identity_text": "Fix ill-advised restriction of NAMEDATALEN to be less than 256 (Robert Haas, Tom Lane)", "commit_aliases": ["47acf3add", "a396144ac"], "source_commits": ["47acf3add"], "source_entry_id": "9.5.1/changes/020", "db_id": "331ac25a117f5cde477b5b290ff37df8", "patch_ids": ["b6c98bb271905aaeb3ad961fb409d279"], "statement_hash": "f22a31f1117714a6171d61007f2b54fe10f01f1b5c404997c3c0fd82471950a5", "relations": [], "version": "9.5.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.5.1-7fa7c91c711f3f89", "cves": [], "html": "Improve reproducibility of build output by ensuring filenames are given to the linker in a fixed order (Christoph Berg)
\nThis avoids possible bitwise differences in the produced executable files from one build to the next.
", "text": "Improve reproducibility of build output by ensuring filenames are given to the linker in a fixed order (Christoph Berg) This avoids possible bitwise differences in the produced executable files from one build to the next.", "title": "Improve reproducibility of build output by ensuring filenames are given to the linker in a fixed order", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "199fdef18ba63db71265f40385e6d5746ff6dcde6f83d902e00915b4855978e3", "section_path": ["Changes"], "commit_groups": [["3343ea9e8", "6d899f098", "8805af088", "8c558b2e9"]], "identity_text": "Improve reproducibility of build output by ensuring filenames are given to the linker in a fixed order (Christoph Berg) This avoids possible bitwise differences in the produced executable files from one build to the next.", "commit_aliases": ["3343ea9e8", "6d899f098", "8805af088", "8c558b2e9"], "source_commits": ["8805af088"], "source_entry_id": "9.5.1/changes/021", "db_id": "f7e1414cc27ba5e639b640d4543e7178", "patch_ids": ["828b2fb73c9968b9f9e55f2c8cd0976a"], "statement_hash": "6f3f8d895e1f4d6fe829ed428f3184029a3c175fcb43a82fed9db6214a5c25c2", "relations": [{"rule": 2, "type": "equivalent", "target": "6c585d6778a3d2697d5dcc424f1d350c", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6f3f8d895e1f4d6fe829ed428f3184029a3c175fcb43a82fed9db6214a5c25c2"}}, {"rule": 2, "type": "equivalent", "target": "7866311e30659f5004aabe65ed6de911", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6f3f8d895e1f4d6fe829ed428f3184029a3c175fcb43a82fed9db6214a5c25c2"}}], "version": "9.5.1", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "7866311e30659f5004aabe65ed6de911", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "Improve reproducibility of build output by ensuring filenames are given to the linker in a fixed order", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6f3f8d895e1f4d6fe829ed428f3184029a3c175fcb43a82fed9db6214a5c25c2"}, "url": "/docs/compare/?release=9.4.6#9.4.6-7fa7c91c711f3f89", "source_url": "/docs/release/9.4.6/#AEN122667"}, {"db_id": "6c585d6778a3d2697d5dcc424f1d350c", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "Improve reproducibility of build output by ensuring filenames are given to the linker in a fixed order", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "6f3f8d895e1f4d6fe829ed428f3184029a3c175fcb43a82fed9db6214a5c25c2"}, "url": "/docs/compare/?release=9.3.11#9.3.11-7fa7c91c711f3f89", "source_url": "/docs/release/9.3.11/#AEN116895"}]}, {"id": "9.5.1-b06bdf5928357485", "cves": [], "html": "Ensure that dynloader.h is included in the installed header files in MSVC builds (Bruce Momjian, Michael Paquier)
", "text": "Ensure that dynloader.h is included in the installed header files in MSVC builds (Bruce Momjian, Michael Paquier)", "title": "Ensure that dynloader.h is included in the installed header files in MSVC builds", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "aeda060b735fbc220542de8d385a4decdba8f6d898707cb355495b9cb3e1fa7d", "section_path": ["Changes"], "commit_groups": [["216d56843", "34bda20ae", "49d65e857", "7a47262ce", "8b3d52801", "b1bc38144"]], "identity_text": "Ensure that dynloader.h is included in the installed header files in MSVC builds (Bruce Momjian, Michael Paquier)", "commit_aliases": ["216d56843", "34bda20ae", "49d65e857", "7a47262ce", "8b3d52801", "b1bc38144"], "source_commits": ["34bda20ae"], "source_entry_id": "9.5.1/changes/022", "db_id": "da1850390a9c1f327882277c4eb3def9", "patch_ids": ["878e29a9bf792d0f42bad5cb4d088176"], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83", "relations": [{"rule": 2, "type": "equivalent", "target": "24615ed3777f4cc8415f1be5cb3c6886", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83"}}, {"rule": 2, "type": "equivalent", "target": "3620494c7d45e6dfc1d177208fe06745", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83"}}, {"rule": 2, "type": "equivalent", "target": "d7a602e7b3be1c6f91455ba18fac8ae3", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83"}}, {"rule": 2, "type": "equivalent", "target": "f15b775bc084b37a970dbfe86e6aba76", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83"}}], "version": "9.5.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "d7a602e7b3be1c6f91455ba18fac8ae3", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "Ensure that dynloader.h is included in the installed header files in MSVC builds", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83"}, "url": "/docs/compare/?release=9.4.6#9.4.6-b06bdf5928357485", "source_url": "/docs/release/9.4.6/#AEN122667"}, {"db_id": "24615ed3777f4cc8415f1be5cb3c6886", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "Ensure that dynloader.h is included in the installed header files in MSVC builds", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83"}, "url": "/docs/compare/?release=9.3.11#9.3.11-b06bdf5928357485", "source_url": "/docs/release/9.3.11/#AEN116895"}, {"db_id": "3620494c7d45e6dfc1d177208fe06745", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "Ensure that dynloader.h is included in the installed header files in MSVC builds", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83"}, "url": "/docs/compare/?release=9.2.15#9.2.15-b06bdf5928357485", "source_url": "/docs/release/9.2.15/#AEN111801"}, {"db_id": "f15b775bc084b37a970dbfe86e6aba76", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "Ensure that dynloader.h is included in the installed header files in MSVC builds", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "eb43a65f20af59d1229f53f762d7a70750b26fc149366d58b3dd6099d368dd83"}, "url": "/docs/compare/?release=9.1.20#9.1.20-b06bdf5928357485", "source_url": "/docs/release/9.1.20/#AEN107334"}]}, {"id": "9.5.1-22b0211a2c18ef18", "cves": [], "html": "Update time zone data files to tzdata release 2016a for DST law changes in Cayman Islands, Metlakatla, and Trans-Baikal Territory (Zabaykalsky Krai), plus historical corrections for Pakistan.
", "text": "Update time zone data files to tzdata release 2016a for DST law changes in Cayman Islands, Metlakatla, and Trans-Baikal Territory (Zabaykalsky Krai), plus historical corrections for Pakistan.", "title": "Update time zone data files to tzdata release 2016a for DST law changes in Cayman Islands, Metlakatla, and Trans-Baikal Territory (Zabaykalsky Krai), plus historical corrections for Pakistan.", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.1/#AEN131269", "source_hash": "0de04b7c71cb7bf3b6c6f53e7740a355957f07616d0fef41ee07fc13a33efe77", "section_path": ["Changes"], "commit_groups": [["31b792f61", "32f17a2e7", "37e694632", "6887d72d0", "9a3475b84", "a73311e52"]], "identity_text": "Update time zone data files to tzdata release 2016a for DST law changes in Cayman Islands, Metlakatla, and Trans-Baikal Territory (Zabaykalsky Krai), plus historical corrections for Pakistan.", "commit_aliases": ["31b792f61", "32f17a2e7", "37e694632", "6887d72d0", "9a3475b84", "a73311e52"], "source_commits": ["37e694632"], "source_entry_id": "9.5.1/changes/023", "db_id": "5597e80195585ed30008c59306886b22", "patch_ids": ["2c0e98564b1797f57b28da97f4f95fc4"], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8", "relations": [{"rule": 2, "type": "equivalent", "target": "2dd502f3961a7bc4d19efd4ee63e9da5", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8"}}, {"rule": 2, "type": "equivalent", "target": "dcb5b295c36a7627a763f51c946763ec", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8"}}, {"rule": 2, "type": "equivalent", "target": "dfb917d07e1c239db68c9dd1bf24ca9a", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8"}}, {"rule": 2, "type": "equivalent", "target": "f08f6b2c87032eb0ae56d29afd228106", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8"}}], "version": "9.5.1", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f08f6b2c87032eb0ae56d29afd228106", "kind": "equivalent", "version": "9.4.6", "label": "9.4.6", "title": "Update time zone data files to tzdata release 2016a for DST law changes in Cayman Islands, Metlakatla, and Trans-Baikal Territory (Zabaykalsky Krai), plus historical corrections for Pakistan.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8"}, "url": "/docs/compare/?release=9.4.6#9.4.6-22b0211a2c18ef18", "source_url": "/docs/release/9.4.6/#AEN122667"}, {"db_id": "2dd502f3961a7bc4d19efd4ee63e9da5", "kind": "equivalent", "version": "9.3.11", "label": "9.3.11", "title": "Update time zone data files to tzdata release 2016a for DST law changes in Cayman Islands, Metlakatla, and Trans-Baikal Territory (Zabaykalsky Krai), plus historical corrections for Pakistan.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8"}, "url": "/docs/compare/?release=9.3.11#9.3.11-22b0211a2c18ef18", "source_url": "/docs/release/9.3.11/#AEN116895"}, {"db_id": "dcb5b295c36a7627a763f51c946763ec", "kind": "equivalent", "version": "9.2.15", "label": "9.2.15", "title": "Update time zone data files to tzdata release 2016a for DST law changes in Cayman Islands, Metlakatla, and Trans-Baikal Territory (Zabaykalsky Krai), plus historical corrections for Pakistan.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8"}, "url": "/docs/compare/?release=9.2.15#9.2.15-22b0211a2c18ef18", "source_url": "/docs/release/9.2.15/#AEN111801"}, {"db_id": "dfb917d07e1c239db68c9dd1bf24ca9a", "kind": "equivalent", "version": "9.1.20", "label": "9.1.20", "title": "Update time zone data files to tzdata release 2016a for DST law changes in Cayman Islands, Metlakatla, and Trans-Baikal Territory (Zabaykalsky Krai), plus historical corrections for Pakistan.", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "638399189025dc0c121b79118fc69a6e45ded5ed4e52b9f4393ef2458a3201c8"}, "url": "/docs/compare/?release=9.1.20#9.1.20-22b0211a2c18ef18", "source_url": "/docs/release/9.1.20/#AEN107334"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 23}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 12}, {"key": "security", "label": "Security", "count": 2}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 9}], "total": 23, "release_count": 1, "cross_major": false, "cve_count": 2, "cves": [{"id": "CVE-2016-0773", "url": "https://www.postgresql.org/support/security/CVE-2016-0773/", "fixed": {"9.1": "9.1.20", "9.2": "9.2.15", "9.3": "9.3.11", "9.4": "9.4.6", "9.5": "9.5.1"}, "score": 6.5, "title": "Fix infinite loops and buffer-overrun problems in regular expressions", "vector": "AV:N/AC:H/PR:N/UI:N/S:U/C:N/I:L/A:H", "affected": {"9.1": "9.1", "9.2": "9.2", "9.3": "9.3", "9.4": "9.4", "9.5": "9.5"}, "component": "core server", "published": {"9.1": "2016-02-11", "9.2": "2016-02-11", "9.3": "2016-02-11", "9.4": "2016-02-11", "9.5": "2016-02-11"}, "introduced": {}, "cvss_version": "3.0", "description_en": "", "first_published": "2016-02-11", "fixed_version": "9.5.1"}, {"id": "CVE-2016-0766", "url": "https://www.postgresql.org/support/security/CVE-2016-0766/", "fixed_version": "", "title": "Prevent certain PL/Java parameters from being set by non-superusers"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 23, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}