A dump/restore is not required for those running 9.5.X.
\nHowever, if you are upgrading from a version earlier than 9.5.13, see Section E.13.
", "compatibility_count": 0, "label": "9.5.16", "status_label": "Historical", "eol": "2021-02-11", "age_days": 2784, "support_days": -2056}, "groups": [{"date": "2019-02-14", "build": "9.5.16", "major": "9.5", "minor": 16, "manual": "9.5", "status": "stable", "doc_git": "", "version": "9.5.16", "eol_date": "2021-02-11", "date_text": "2019-02-14", "supported": false, "manual_url": "/docs/9.5/release-9-5-16.html", "source_url": "/docs/release/9.5.16/", "entry_count": 39, "placeholder": false, "content_hash": "c9a9d0d33a105f3a8049081b0237087af651e877e39d170845dfe105c78ece76", "manual_build": "9.5.25", "source_as_of": "", "changes_count": 39, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 9.5.X.
\nHowever, if you are upgrading from a version earlier than 9.5.13, see Section E.13.
", "compatibility_count": 0, "label": "9.5.16", "status_label": "Historical", "eol": "2021-02-11", "age_days": 2784, "support_days": -2056, "entries": [{"id": "9.5.16-6da65f00cee39eb9", "cves": [], "html": "By default, panic instead of retrying after fsync() failure, to avoid possible data corruption (Craig Ringer, Thomas Munro)
Some popular operating systems discard kernel data buffers when unable to write them out, reporting this as fsync() failure. If we reissue the fsync() request it will succeed, but in fact the data has been lost, so continuing risks database corruption. By raising a panic condition instead, we can replay from WAL, which may contain the only remaining copy of the data in such a situation. While this is surely ugly and inefficient, there are few alternatives, and fortunately the case happens very rarely.
A new server parameter data_sync_retry has been added to control this; if you are certain that your kernel does not discard dirty data buffers in such scenarios, you can set data_sync_retry to on to restore the old behavior.
", "text": "By default, panic instead of retrying after fsync() failure, to avoid possible data corruption (Craig Ringer, Thomas Munro) Some popular operating systems discard kernel data buffers when unable to write them out, reporting this as fsync() failure. If we reissue the fsync() request it will succeed, but in fact the data has been lost, so continuing risks database corruption. By raising a panic condition instead, we can replay from WAL, which may contain the only remaining copy of the data in such a situation. While this is surely ugly and inefficient, there are few alternatives, and fortunately the case happens very rarely. A new server parameter data_sync_retry has been added to control this; if you are certain that your kernel does not discard dirty data buffers in such scenarios, you can set data_sync_retry to on to restore the old behavior.", "title": "By default, panic instead of retrying after fsync() failure, to avoid possible data corruption", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "9b8a392323eda52c556e453eb1ce2e1ac0a8a44974b689de2975316510fdd605", "section_path": ["Changes"], "commit_groups": [["312435232", "6534d544c", "9ccdd7f66", "afbe03f65", "b9cce9ddf", "f1ff5f51d"]], "identity_text": "By default, panic instead of retrying after fsync() failure, to avoid possible data corruption (Craig Ringer, Thomas Munro) Some popular operating systems discard kernel data buffers when unable to write them out, reporting this as fsync() failure. If we reissue the fsync() request it will succeed, but in fact the data has been lost, so continuing risks database corruption. By raising a panic condition instead, we can replay from WAL, which may contain the only remaining copy of the data in such a situation. While this is surely ugly and inefficient, there are few alternatives, and fortunately the case happens very rarely. A new server parameter guc-data-sync-retry has been added to control this; if you are certain that your kernel does not discard dirty data buffers in such scenarios, you can set data_sync_retry to on to restore the old behavior.", "commit_aliases": ["312435232", "6534d544c", "9ccdd7f66", "afbe03f65", "b9cce9ddf", "f1ff5f51d"], "source_commits": ["312435232"], "source_entry_id": "9.5.16/changes/001", "db_id": "2de3ac171ddc2856721ffd607512e2e2", "patch_ids": ["1cd20419bd6603ee4fa060589acd75a7"], "statement_hash": "98e41f64860dadd2ea173c160870aedaa4ce240185b3e6a65783b799ed55f23c", "relations": [{"rule": 2, "type": "equivalent", "target": "04c328284becc54430b265ccea5bb2b4", "evidence": {"same_day": true, "patch_ids": ["1cd20419bd6603ee4fa060589acd75a7"], "statement_hash": "98e41f64860dadd2ea173c160870aedaa4ce240185b3e6a65783b799ed55f23c"}}, {"rule": 2, "type": "equivalent", "target": "8618df39ed6f253f6af6ade4524563f4", "evidence": {"same_day": true, "patch_ids": ["1cd20419bd6603ee4fa060589acd75a7"], "statement_hash": "98e41f64860dadd2ea173c160870aedaa4ce240185b3e6a65783b799ed55f23c"}}, {"rule": 2, "type": "equivalent", "target": "8ce6bd55929a0b3c450ee07d29f592c1", "evidence": {"same_day": true, "patch_ids": ["1cd20419bd6603ee4fa060589acd75a7"], "statement_hash": "98e41f64860dadd2ea173c160870aedaa4ce240185b3e6a65783b799ed55f23c"}}, {"rule": 2, "type": "equivalent", "target": "c30342616267698884b38e953ccaa620", "evidence": {"same_day": true, "patch_ids": ["1cd20419bd6603ee4fa060589acd75a7"], "statement_hash": "98e41f64860dadd2ea173c160870aedaa4ce240185b3e6a65783b799ed55f23c"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "8ce6bd55929a0b3c450ee07d29f592c1", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "By default, panic instead of retrying after fsync() failure, to avoid possible data corruption", "evidence": {"same_day": true, "patch_ids": ["1cd20419bd6603ee4fa060589acd75a7"], "statement_hash": "98e41f64860dadd2ea173c160870aedaa4ce240185b3e6a65783b799ed55f23c"}, "url": "/docs/compare/?release=11.2#11.2-6da65f00cee39eb9", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "04c328284becc54430b265ccea5bb2b4", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "By default, panic instead of retrying after fsync() failure, to avoid possible data corruption", "evidence": {"same_day": true, "patch_ids": ["1cd20419bd6603ee4fa060589acd75a7"], "statement_hash": "98e41f64860dadd2ea173c160870aedaa4ce240185b3e6a65783b799ed55f23c"}, "url": "/docs/compare/?release=10.7#10.7-6da65f00cee39eb9", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "8618df39ed6f253f6af6ade4524563f4", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "By default, panic instead of retrying after fsync() failure, to avoid possible data corruption", "evidence": {"same_day": true, "patch_ids": ["1cd20419bd6603ee4fa060589acd75a7"], "statement_hash": "98e41f64860dadd2ea173c160870aedaa4ce240185b3e6a65783b799ed55f23c"}, "url": "/docs/compare/?release=9.6.12#9.6.12-6da65f00cee39eb9", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "c30342616267698884b38e953ccaa620", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "By default, panic instead of retrying after fsync() failure, to avoid possible data corruption", "evidence": {"same_day": true, "patch_ids": ["1cd20419bd6603ee4fa060589acd75a7"], "statement_hash": "98e41f64860dadd2ea173c160870aedaa4ce240185b3e6a65783b799ed55f23c"}, "url": "/docs/compare/?release=9.4.21#9.4.21-6da65f00cee39eb9", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-ee28546f0b338541", "cves": [], "html": "Include each major release branch's release notes in the documentation for only that branch, rather than that branch and all later ones (Tom Lane)
\nThe duplication induced by the previous policy was getting out of hand. Our plan is to provide a full archive of release notes on the project's web site, but not duplicate it within each release.
", "text": "Include each major release branch's release notes in the documentation for only that branch, rather than that branch and all later ones (Tom Lane) The duplication induced by the previous policy was getting out of hand. Our plan is to provide a full archive of release notes on the project's web site, but not duplicate it within each release.", "title": "Include each major release branch's release notes in the documentation for only that branch, rather than that branch and all later ones", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "eb4672b82676dd2319656528a3f5b5dd6da81540f386eb5bcdb4cfed3fb0a5a0", "section_path": ["Changes"], "commit_groups": [["0d13dd371", "2b2427115", "527b5ed1a", "60b1d6c2a", "bb428cb11", "ed64db588"]], "identity_text": "Include each major release branch's release notes in the documentation for only that branch, rather than that branch and all later ones (Tom Lane) The duplication induced by the previous policy was getting out of hand. Our plan is to provide a full archive of release notes on the project's web site, but not duplicate it within each release.", "commit_aliases": ["0d13dd371", "2b2427115", "527b5ed1a", "60b1d6c2a", "bb428cb11", "ed64db588"], "source_commits": ["ed64db588"], "source_entry_id": "9.5.16/changes/002", "db_id": "e673f6c4ec8d4ea12161e9fdfd743fc5", "patch_ids": ["3a494ea15551633c6fadd8d8b3872657"], "statement_hash": "def87da337acf6afa1339c1007c8e019555ec62f013cacbdbd412a84dae2f5ae", "relations": [{"rule": 2, "type": "equivalent", "target": "450c05467c6eb16175952aa5f906c571", "evidence": {"same_day": true, "patch_ids": ["3a494ea15551633c6fadd8d8b3872657"], "statement_hash": "def87da337acf6afa1339c1007c8e019555ec62f013cacbdbd412a84dae2f5ae"}}, {"rule": 2, "type": "equivalent", "target": "4646d309f18ac7fa2bf41e21e3575e15", "evidence": {"same_day": true, "patch_ids": ["3a494ea15551633c6fadd8d8b3872657"], "statement_hash": "def87da337acf6afa1339c1007c8e019555ec62f013cacbdbd412a84dae2f5ae"}}, {"rule": 2, "type": "equivalent", "target": "6e11681ce0757e659f9ee169e455395b", "evidence": {"same_day": true, "patch_ids": ["3a494ea15551633c6fadd8d8b3872657"], "statement_hash": "def87da337acf6afa1339c1007c8e019555ec62f013cacbdbd412a84dae2f5ae"}}, {"rule": 2, "type": "equivalent", "target": "fb65ab094feb449fa0c25a657a0529c7", "evidence": {"same_day": true, "patch_ids": ["3a494ea15551633c6fadd8d8b3872657"], "statement_hash": "def87da337acf6afa1339c1007c8e019555ec62f013cacbdbd412a84dae2f5ae"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "450c05467c6eb16175952aa5f906c571", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Include each major release branch's release notes in the documentation for only that branch, rather than that branch and all later ones", "evidence": {"same_day": true, "patch_ids": ["3a494ea15551633c6fadd8d8b3872657"], "statement_hash": "def87da337acf6afa1339c1007c8e019555ec62f013cacbdbd412a84dae2f5ae"}, "url": "/docs/compare/?release=11.2#11.2-ee28546f0b338541", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "fb65ab094feb449fa0c25a657a0529c7", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Include each major release branch's release notes in the documentation for only that branch, rather than that branch and all later ones", "evidence": {"same_day": true, "patch_ids": ["3a494ea15551633c6fadd8d8b3872657"], "statement_hash": "def87da337acf6afa1339c1007c8e019555ec62f013cacbdbd412a84dae2f5ae"}, "url": "/docs/compare/?release=10.7#10.7-ee28546f0b338541", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "4646d309f18ac7fa2bf41e21e3575e15", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Include each major release branch's release notes in the documentation for only that branch, rather than that branch and all later ones", "evidence": {"same_day": true, "patch_ids": ["3a494ea15551633c6fadd8d8b3872657"], "statement_hash": "def87da337acf6afa1339c1007c8e019555ec62f013cacbdbd412a84dae2f5ae"}, "url": "/docs/compare/?release=9.6.12#9.6.12-ee28546f0b338541", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "6e11681ce0757e659f9ee169e455395b", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Include each major release branch's release notes in the documentation for only that branch, rather than that branch and all later ones", "evidence": {"same_day": true, "patch_ids": ["3a494ea15551633c6fadd8d8b3872657"], "statement_hash": "def87da337acf6afa1339c1007c8e019555ec62f013cacbdbd412a84dae2f5ae"}, "url": "/docs/compare/?release=9.4.21#9.4.21-ee28546f0b338541", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-9de52ef5cf92768c", "cves": [], "html": "Avoid possible deadlock when acquiring multiple buffer locks (Nishant Fnu)
", "text": "Avoid possible deadlock when acquiring multiple buffer locks (Nishant Fnu)", "title": "Avoid possible deadlock when acquiring multiple buffer locks", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "8c1eb875bd1b2cfe9cab91f7e47fdeb92ab68217644d5d4c7bf34780888f5591", "section_path": ["Changes"], "commit_groups": [["073afae81", "0b8bdb3c3", "1ca33fc7b", "6a2c9c633", "904413637", "fba0a8292"]], "identity_text": "Avoid possible deadlock when acquiring multiple buffer locks (Nishant Fnu)", "commit_aliases": ["073afae81", "0b8bdb3c3", "1ca33fc7b", "6a2c9c633", "904413637", "fba0a8292"], "source_commits": ["6a2c9c633"], "source_entry_id": "9.5.16/changes/003", "db_id": "defb797ad958ab34d7af549635e5845a", "patch_ids": ["d6cdc40d09bb3828720fd4070de421ce"], "statement_hash": "fa8378628893357246e80c535a0a4cfef76fa472e73a0ea99d0e2c55b6fc13b2", "relations": [{"rule": 2, "type": "equivalent", "target": "78b9f126b3060e1d305df93bd566410a", "evidence": {"same_day": true, "patch_ids": ["d6cdc40d09bb3828720fd4070de421ce"], "statement_hash": "fa8378628893357246e80c535a0a4cfef76fa472e73a0ea99d0e2c55b6fc13b2"}}, {"rule": 2, "type": "equivalent", "target": "a6802b29e18623bb5196a29c35621a96", "evidence": {"same_day": true, "patch_ids": ["d6cdc40d09bb3828720fd4070de421ce"], "statement_hash": "fa8378628893357246e80c535a0a4cfef76fa472e73a0ea99d0e2c55b6fc13b2"}}, {"rule": 2, "type": "equivalent", "target": "d3245f2dd4ecb5ea89aa5072bf6eda4c", "evidence": {"same_day": true, "patch_ids": ["d6cdc40d09bb3828720fd4070de421ce"], "statement_hash": "fa8378628893357246e80c535a0a4cfef76fa472e73a0ea99d0e2c55b6fc13b2"}}, {"rule": 2, "type": "equivalent", "target": "ea246181e943f4546fe1ae6adaab9bdc", "evidence": {"same_day": true, "patch_ids": ["d6cdc40d09bb3828720fd4070de421ce"], "statement_hash": "fa8378628893357246e80c535a0a4cfef76fa472e73a0ea99d0e2c55b6fc13b2"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "d3245f2dd4ecb5ea89aa5072bf6eda4c", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Avoid possible deadlock when acquiring multiple buffer locks", "evidence": {"same_day": true, "patch_ids": ["d6cdc40d09bb3828720fd4070de421ce"], "statement_hash": "fa8378628893357246e80c535a0a4cfef76fa472e73a0ea99d0e2c55b6fc13b2"}, "url": "/docs/compare/?release=11.2#11.2-9de52ef5cf92768c", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "a6802b29e18623bb5196a29c35621a96", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Avoid possible deadlock when acquiring multiple buffer locks", "evidence": {"same_day": true, "patch_ids": ["d6cdc40d09bb3828720fd4070de421ce"], "statement_hash": "fa8378628893357246e80c535a0a4cfef76fa472e73a0ea99d0e2c55b6fc13b2"}, "url": "/docs/compare/?release=10.7#10.7-9de52ef5cf92768c", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "78b9f126b3060e1d305df93bd566410a", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Avoid possible deadlock when acquiring multiple buffer locks", "evidence": {"same_day": true, "patch_ids": ["d6cdc40d09bb3828720fd4070de421ce"], "statement_hash": "fa8378628893357246e80c535a0a4cfef76fa472e73a0ea99d0e2c55b6fc13b2"}, "url": "/docs/compare/?release=9.6.12#9.6.12-9de52ef5cf92768c", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "ea246181e943f4546fe1ae6adaab9bdc", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Avoid possible deadlock when acquiring multiple buffer locks", "evidence": {"same_day": true, "patch_ids": ["d6cdc40d09bb3828720fd4070de421ce"], "statement_hash": "fa8378628893357246e80c535a0a4cfef76fa472e73a0ea99d0e2c55b6fc13b2"}, "url": "/docs/compare/?release=9.4.21#9.4.21-9de52ef5cf92768c", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-57d31aab9ffa2196", "cves": [], "html": "Avoid deadlock between hot-standby queries and replay of GIN index page deletion (Alexander Korotkov)
", "text": "Avoid deadlock between hot-standby queries and replay of GIN index page deletion (Alexander Korotkov)", "title": "Avoid deadlock between hot-standby queries and replay of GIN index page deletion", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "5f4725b2aafc132a1ea86d41600409c3ffaca2c10afa4009b3e1b9126defe881", "section_path": ["Changes"], "commit_groups": [["19cf52e6c", "225b5c9c4", "80d4d8d71", "865870374", "c6ade7a8c", "f6c44e1b5"], ["bf0e5a73b"]], "identity_text": "Avoid deadlock between hot-standby queries and replay of GIN index page deletion (Alexander Korotkov)", "commit_aliases": ["19cf52e6c", "225b5c9c4", "80d4d8d71", "865870374", "bf0e5a73b", "c6ade7a8c", "f6c44e1b5"], "source_commits": ["bf0e5a73b", "f6c44e1b5"], "source_entry_id": "9.5.16/changes/004", "db_id": "67175c01685a4cc69b78be23ba91af92", "patch_ids": ["a2eedd6b8d3f5bee276bea50644a7ae1", "a3c647e6b68276d7538b4eb56aee6622"], "statement_hash": "adcffdc4a3e3255d815e645b8b4bc6160fac12eb9e5490631155be19b20f8658", "relations": [{"rule": 2, "type": "equivalent", "target": "0034f749d32ed3f471748bf57c933ffc", "evidence": {"same_day": true, "patch_ids": ["a2eedd6b8d3f5bee276bea50644a7ae1", "a3c647e6b68276d7538b4eb56aee6622"], "statement_hash": "adcffdc4a3e3255d815e645b8b4bc6160fac12eb9e5490631155be19b20f8658"}}, {"rule": 2, "type": "equivalent", "target": "04cc7864472df4a6726a934fd320ac0f", "evidence": {"same_day": true, "patch_ids": ["a2eedd6b8d3f5bee276bea50644a7ae1", "a3c647e6b68276d7538b4eb56aee6622"], "statement_hash": "adcffdc4a3e3255d815e645b8b4bc6160fac12eb9e5490631155be19b20f8658"}}, {"rule": 2, "type": "equivalent", "target": "7d3c7b87fd66a83712c5b75fe7daeaa1", "evidence": {"same_day": true, "patch_ids": ["a2eedd6b8d3f5bee276bea50644a7ae1", "a3c647e6b68276d7538b4eb56aee6622"], "statement_hash": "adcffdc4a3e3255d815e645b8b4bc6160fac12eb9e5490631155be19b20f8658"}}, {"rule": 2, "type": "equivalent", "target": "b0033c4189816213e103a6b95148d608", "evidence": {"same_day": true, "patch_ids": ["a2eedd6b8d3f5bee276bea50644a7ae1", "a3c647e6b68276d7538b4eb56aee6622"], "statement_hash": "adcffdc4a3e3255d815e645b8b4bc6160fac12eb9e5490631155be19b20f8658"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "7d3c7b87fd66a83712c5b75fe7daeaa1", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Avoid deadlock between hot-standby queries and replay of GIN index page deletion", "evidence": {"same_day": true, "patch_ids": ["a2eedd6b8d3f5bee276bea50644a7ae1", "a3c647e6b68276d7538b4eb56aee6622"], "statement_hash": "adcffdc4a3e3255d815e645b8b4bc6160fac12eb9e5490631155be19b20f8658"}, "url": "/docs/compare/?release=11.2#11.2-57d31aab9ffa2196", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "0034f749d32ed3f471748bf57c933ffc", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Avoid deadlock between hot-standby queries and replay of GIN index page deletion", "evidence": {"same_day": true, "patch_ids": ["a2eedd6b8d3f5bee276bea50644a7ae1", "a3c647e6b68276d7538b4eb56aee6622"], "statement_hash": "adcffdc4a3e3255d815e645b8b4bc6160fac12eb9e5490631155be19b20f8658"}, "url": "/docs/compare/?release=10.7#10.7-57d31aab9ffa2196", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "04cc7864472df4a6726a934fd320ac0f", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Avoid deadlock between hot-standby queries and replay of GIN index page deletion", "evidence": {"same_day": true, "patch_ids": ["a2eedd6b8d3f5bee276bea50644a7ae1", "a3c647e6b68276d7538b4eb56aee6622"], "statement_hash": "adcffdc4a3e3255d815e645b8b4bc6160fac12eb9e5490631155be19b20f8658"}, "url": "/docs/compare/?release=9.6.12#9.6.12-57d31aab9ffa2196", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "b0033c4189816213e103a6b95148d608", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Avoid deadlock between hot-standby queries and replay of GIN index page deletion", "evidence": {"same_day": true, "patch_ids": ["a2eedd6b8d3f5bee276bea50644a7ae1", "a3c647e6b68276d7538b4eb56aee6622"], "statement_hash": "adcffdc4a3e3255d815e645b8b4bc6160fac12eb9e5490631155be19b20f8658"}, "url": "/docs/compare/?release=9.4.21#9.4.21-57d31aab9ffa2196", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-cffb14ee80400d16", "cves": [], "html": "Fix possible crashes in logical replication when index expressions or predicates are in use (Peter Eisentraut)
", "text": "Fix possible crashes in logical replication when index expressions or predicates are in use (Peter Eisentraut)", "title": "Fix possible crashes in logical replication when index expressions or predicates are in use", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "81ed1909c7ce0dc74c23c85be106200139505e5b8a0f1e8324fbd81fffbafb5d", "section_path": ["Changes"], "commit_groups": [["2bac1d8c9", "452253eae", "650296f8f", "cf25498f7", "dfa774ff9", "edd8278c5"]], "identity_text": "Fix possible crashes in logical replication when index expressions or predicates are in use (Peter Eisentraut)", "commit_aliases": ["2bac1d8c9", "452253eae", "650296f8f", "cf25498f7", "dfa774ff9", "edd8278c5"], "source_commits": ["edd8278c5"], "source_entry_id": "9.5.16/changes/005", "db_id": "ba61e3eea0a6ab823ee3513474bdeffa", "patch_ids": ["ca3f14f7c5a22a796b2f51fc0c0b4bc3"], "statement_hash": "a13c110a61af0d3df64537341093d5e1b9716dc20c2fe64de3e2530d33e718f6", "relations": [{"rule": 2, "type": "equivalent", "target": "0461d4f7ca50ed8c9a3a985fb55ca168", "evidence": {"same_day": true, "patch_ids": ["ca3f14f7c5a22a796b2f51fc0c0b4bc3"], "statement_hash": "a13c110a61af0d3df64537341093d5e1b9716dc20c2fe64de3e2530d33e718f6"}}, {"rule": 2, "type": "equivalent", "target": "328ba089843dd7c8f19ff5cbf7b7165b", "evidence": {"same_day": true, "patch_ids": ["ca3f14f7c5a22a796b2f51fc0c0b4bc3"], "statement_hash": "a13c110a61af0d3df64537341093d5e1b9716dc20c2fe64de3e2530d33e718f6"}}, {"rule": 2, "type": "equivalent", "target": "7ea74fa8edd2f696d641d7ec0b11428a", "evidence": {"same_day": true, "patch_ids": ["ca3f14f7c5a22a796b2f51fc0c0b4bc3"], "statement_hash": "a13c110a61af0d3df64537341093d5e1b9716dc20c2fe64de3e2530d33e718f6"}}, {"rule": 2, "type": "equivalent", "target": "ef280c9bb22f9d27a7d505f43a5d23d9", "evidence": {"same_day": true, "patch_ids": ["ca3f14f7c5a22a796b2f51fc0c0b4bc3"], "statement_hash": "a13c110a61af0d3df64537341093d5e1b9716dc20c2fe64de3e2530d33e718f6"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "ef280c9bb22f9d27a7d505f43a5d23d9", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Fix possible crashes in logical replication when index expressions or predicates are in use", "evidence": {"same_day": true, "patch_ids": ["ca3f14f7c5a22a796b2f51fc0c0b4bc3"], "statement_hash": "a13c110a61af0d3df64537341093d5e1b9716dc20c2fe64de3e2530d33e718f6"}, "url": "/docs/compare/?release=11.2#11.2-cffb14ee80400d16", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "328ba089843dd7c8f19ff5cbf7b7165b", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Fix possible crashes in logical replication when index expressions or predicates are in use", "evidence": {"same_day": true, "patch_ids": ["ca3f14f7c5a22a796b2f51fc0c0b4bc3"], "statement_hash": "a13c110a61af0d3df64537341093d5e1b9716dc20c2fe64de3e2530d33e718f6"}, "url": "/docs/compare/?release=10.7#10.7-cffb14ee80400d16", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "0461d4f7ca50ed8c9a3a985fb55ca168", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Fix possible crashes in logical replication when index expressions or predicates are in use", "evidence": {"same_day": true, "patch_ids": ["ca3f14f7c5a22a796b2f51fc0c0b4bc3"], "statement_hash": "a13c110a61af0d3df64537341093d5e1b9716dc20c2fe64de3e2530d33e718f6"}, "url": "/docs/compare/?release=9.6.12#9.6.12-cffb14ee80400d16", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "7ea74fa8edd2f696d641d7ec0b11428a", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Fix possible crashes in logical replication when index expressions or predicates are in use", "evidence": {"same_day": true, "patch_ids": ["ca3f14f7c5a22a796b2f51fc0c0b4bc3"], "statement_hash": "a13c110a61af0d3df64537341093d5e1b9716dc20c2fe64de3e2530d33e718f6"}, "url": "/docs/compare/?release=9.4.21#9.4.21-cffb14ee80400d16", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-26f80fe3d5d519bf", "cves": [], "html": "Avoid useless and expensive logical decoding of TOAST data during a table rewrite (Tomas Vondra)
", "text": "Avoid useless and expensive logical decoding of TOAST data during a table rewrite (Tomas Vondra)", "title": "Avoid useless and expensive logical decoding of TOAST data during a table rewrite", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "536c2794747daa26615d79decca6ef61560e4a1c865a879d78008571d627674a", "section_path": ["Changes"], "commit_groups": [["4e7395d83", "77d2815e4", "b86d148ae", "c1a5caea8", "f69c959df", "f8397c955"]], "identity_text": "Avoid useless and expensive logical decoding of TOAST data during a table rewrite (Tomas Vondra)", "commit_aliases": ["4e7395d83", "77d2815e4", "b86d148ae", "c1a5caea8", "f69c959df", "f8397c955"], "source_commits": ["77d2815e4"], "source_entry_id": "9.5.16/changes/006", "db_id": "cc2d54ff133ad9241a37b0c8112efaf1", "patch_ids": ["c7ada9f9cd38c4d17098eac7ae7eb1a6"], "statement_hash": "8cf0b33217e43b9d5790a54d8cd2868939e4584873bfe2d69483791a5e395f98", "relations": [{"rule": 2, "type": "equivalent", "target": "01e1ad5b166c2fb76f0af438f882523e", "evidence": {"same_day": true, "patch_ids": ["c7ada9f9cd38c4d17098eac7ae7eb1a6"], "statement_hash": "8cf0b33217e43b9d5790a54d8cd2868939e4584873bfe2d69483791a5e395f98"}}, {"rule": 2, "type": "equivalent", "target": "8130c609a17348303d80eedbf53b7a46", "evidence": {"same_day": true, "patch_ids": ["c7ada9f9cd38c4d17098eac7ae7eb1a6"], "statement_hash": "8cf0b33217e43b9d5790a54d8cd2868939e4584873bfe2d69483791a5e395f98"}}, {"rule": 2, "type": "equivalent", "target": "90bc2f83bb21a49a601945dc9f7115bd", "evidence": {"same_day": true, "patch_ids": ["c7ada9f9cd38c4d17098eac7ae7eb1a6"], "statement_hash": "8cf0b33217e43b9d5790a54d8cd2868939e4584873bfe2d69483791a5e395f98"}}, {"rule": 2, "type": "equivalent", "target": "a013358b21559ec30543059e8e5e5344", "evidence": {"same_day": true, "patch_ids": ["c7ada9f9cd38c4d17098eac7ae7eb1a6"], "statement_hash": "8cf0b33217e43b9d5790a54d8cd2868939e4584873bfe2d69483791a5e395f98"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "90bc2f83bb21a49a601945dc9f7115bd", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Avoid useless and expensive logical decoding of TOAST data during a table rewrite", "evidence": {"same_day": true, "patch_ids": ["c7ada9f9cd38c4d17098eac7ae7eb1a6"], "statement_hash": "8cf0b33217e43b9d5790a54d8cd2868939e4584873bfe2d69483791a5e395f98"}, "url": "/docs/compare/?release=11.2#11.2-26f80fe3d5d519bf", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "01e1ad5b166c2fb76f0af438f882523e", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Avoid useless and expensive logical decoding of TOAST data during a table rewrite", "evidence": {"same_day": true, "patch_ids": ["c7ada9f9cd38c4d17098eac7ae7eb1a6"], "statement_hash": "8cf0b33217e43b9d5790a54d8cd2868939e4584873bfe2d69483791a5e395f98"}, "url": "/docs/compare/?release=10.7#10.7-26f80fe3d5d519bf", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "a013358b21559ec30543059e8e5e5344", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Avoid useless and expensive logical decoding of TOAST data during a table rewrite", "evidence": {"same_day": true, "patch_ids": ["c7ada9f9cd38c4d17098eac7ae7eb1a6"], "statement_hash": "8cf0b33217e43b9d5790a54d8cd2868939e4584873bfe2d69483791a5e395f98"}, "url": "/docs/compare/?release=9.6.12#9.6.12-26f80fe3d5d519bf", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "8130c609a17348303d80eedbf53b7a46", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Avoid useless and expensive logical decoding of TOAST data during a table rewrite", "evidence": {"same_day": true, "patch_ids": ["c7ada9f9cd38c4d17098eac7ae7eb1a6"], "statement_hash": "8cf0b33217e43b9d5790a54d8cd2868939e4584873bfe2d69483791a5e395f98"}, "url": "/docs/compare/?release=9.4.21#9.4.21-26f80fe3d5d519bf", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-bb347a9668d106b1", "cves": [], "html": "Fix logic for stopping a subset of WAL senders when synchronous replication is enabled (Paul Guo, Michael Paquier)
", "text": "Fix logic for stopping a subset of WAL senders when synchronous replication is enabled (Paul Guo, Michael Paquier)", "title": "Fix logic for stopping a subset of WAL senders when synchronous replication is enabled", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "ec0dac2d165b5fb824e0e49215cacd3f27321fb9ad56568becca7e6821ec8c6a", "section_path": ["Changes"], "commit_groups": [["04e381a19", "4c703369a", "8340eba6d", "b81d08d60", "b9bdbf8c1", "bad41764a"]], "identity_text": "Fix logic for stopping a subset of WAL senders when synchronous replication is enabled (Paul Guo, Michael Paquier)", "commit_aliases": ["04e381a19", "4c703369a", "8340eba6d", "b81d08d60", "b9bdbf8c1", "bad41764a"], "source_commits": ["b9bdbf8c1"], "source_entry_id": "9.5.16/changes/007", "db_id": "8690585395202edcbdf4fb0e2b2cde5f", "patch_ids": ["d20e5f5a40b6783989426c0d3e1645e1"], "statement_hash": "52ea76644deb231363f232adcd759c8671dbff4ffffeda9a5e273ecf6eab3990", "relations": [{"rule": 2, "type": "equivalent", "target": "44ffa5cb8eb96843c180dddb29f6ed7f", "evidence": {"same_day": true, "patch_ids": ["d20e5f5a40b6783989426c0d3e1645e1"], "statement_hash": "52ea76644deb231363f232adcd759c8671dbff4ffffeda9a5e273ecf6eab3990"}}, {"rule": 2, "type": "equivalent", "target": "4a5d6c9ae25ae162ed116ba3a7e0070d", "evidence": {"same_day": true, "patch_ids": ["d20e5f5a40b6783989426c0d3e1645e1"], "statement_hash": "52ea76644deb231363f232adcd759c8671dbff4ffffeda9a5e273ecf6eab3990"}}, {"rule": 2, "type": "equivalent", "target": "d14df341bfed88059dab45579948be4d", "evidence": {"same_day": true, "patch_ids": ["d20e5f5a40b6783989426c0d3e1645e1"], "statement_hash": "52ea76644deb231363f232adcd759c8671dbff4ffffeda9a5e273ecf6eab3990"}}, {"rule": 2, "type": "equivalent", "target": "e4b8501d9955310194b7c17f5b400613", "evidence": {"same_day": true, "patch_ids": ["d20e5f5a40b6783989426c0d3e1645e1"], "statement_hash": "52ea76644deb231363f232adcd759c8671dbff4ffffeda9a5e273ecf6eab3990"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "e4b8501d9955310194b7c17f5b400613", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Fix logic for stopping a subset of WAL senders when synchronous replication is enabled", "evidence": {"same_day": true, "patch_ids": ["d20e5f5a40b6783989426c0d3e1645e1"], "statement_hash": "52ea76644deb231363f232adcd759c8671dbff4ffffeda9a5e273ecf6eab3990"}, "url": "/docs/compare/?release=11.2#11.2-bb347a9668d106b1", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "4a5d6c9ae25ae162ed116ba3a7e0070d", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Fix logic for stopping a subset of WAL senders when synchronous replication is enabled", "evidence": {"same_day": true, "patch_ids": ["d20e5f5a40b6783989426c0d3e1645e1"], "statement_hash": "52ea76644deb231363f232adcd759c8671dbff4ffffeda9a5e273ecf6eab3990"}, "url": "/docs/compare/?release=10.7#10.7-bb347a9668d106b1", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "44ffa5cb8eb96843c180dddb29f6ed7f", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Fix logic for stopping a subset of WAL senders when synchronous replication is enabled", "evidence": {"same_day": true, "patch_ids": ["d20e5f5a40b6783989426c0d3e1645e1"], "statement_hash": "52ea76644deb231363f232adcd759c8671dbff4ffffeda9a5e273ecf6eab3990"}, "url": "/docs/compare/?release=9.6.12#9.6.12-bb347a9668d106b1", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "d14df341bfed88059dab45579948be4d", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Fix logic for stopping a subset of WAL senders when synchronous replication is enabled", "evidence": {"same_day": true, "patch_ids": ["d20e5f5a40b6783989426c0d3e1645e1"], "statement_hash": "52ea76644deb231363f232adcd759c8671dbff4ffffeda9a5e273ecf6eab3990"}, "url": "/docs/compare/?release=9.4.21#9.4.21-bb347a9668d106b1", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-7c2675cadb19eb6a", "cves": [], "html": "Avoid possibly writing an incorrect replica identity field in a tuple deletion WAL record (Stas Kelvich)
", "text": "Avoid possibly writing an incorrect replica identity field in a tuple deletion WAL record (Stas Kelvich)", "title": "Avoid possibly writing an incorrect replica identity field in a tuple deletion WAL record", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "dff21d55217350759e1e65a8fa683b95238410ccb314a45f1ab12304cf0995c4", "section_path": ["Changes"], "commit_groups": [["014763e97", "05d24cf7c", "47412e075", "478e0069f", "90f1ba7ec", "eb8c9f0bc"]], "identity_text": "Avoid possibly writing an incorrect replica identity field in a tuple deletion WAL record (Stas Kelvich)", "commit_aliases": ["014763e97", "05d24cf7c", "47412e075", "478e0069f", "90f1ba7ec", "eb8c9f0bc"], "source_commits": ["90f1ba7ec"], "source_entry_id": "9.5.16/changes/008", "db_id": "7d0c0cc6d4380eaf2ebead677ab35b7b", "patch_ids": ["40e03536fea4bcb2ac3c575edb75178e"], "statement_hash": "9ccf70c6f337df25e1b9d44f38db0997bf19ea561d397376282e030a186906cc", "relations": [{"rule": 2, "type": "equivalent", "target": "4b0fa9e7fbf47ab605f0422dafc76700", "evidence": {"same_day": true, "patch_ids": ["40e03536fea4bcb2ac3c575edb75178e"], "statement_hash": "9ccf70c6f337df25e1b9d44f38db0997bf19ea561d397376282e030a186906cc"}}, {"rule": 2, "type": "equivalent", "target": "66fb8cdc333158ee73a6fae077157490", "evidence": {"same_day": true, "patch_ids": ["40e03536fea4bcb2ac3c575edb75178e"], "statement_hash": "9ccf70c6f337df25e1b9d44f38db0997bf19ea561d397376282e030a186906cc"}}, {"rule": 2, "type": "equivalent", "target": "98ce6a70875f0f5e8fe26ab23a72ad9d", "evidence": {"same_day": true, "patch_ids": ["40e03536fea4bcb2ac3c575edb75178e"], "statement_hash": "9ccf70c6f337df25e1b9d44f38db0997bf19ea561d397376282e030a186906cc"}}, {"rule": 2, "type": "equivalent", "target": "e4a59bd60faed5b215e7f57ee7ca981c", "evidence": {"same_day": true, "patch_ids": ["40e03536fea4bcb2ac3c575edb75178e"], "statement_hash": "9ccf70c6f337df25e1b9d44f38db0997bf19ea561d397376282e030a186906cc"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "4b0fa9e7fbf47ab605f0422dafc76700", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Avoid possibly writing an incorrect replica identity field in a tuple deletion WAL record", "evidence": {"same_day": true, "patch_ids": ["40e03536fea4bcb2ac3c575edb75178e"], "statement_hash": "9ccf70c6f337df25e1b9d44f38db0997bf19ea561d397376282e030a186906cc"}, "url": "/docs/compare/?release=11.2#11.2-7c2675cadb19eb6a", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "66fb8cdc333158ee73a6fae077157490", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Avoid possibly writing an incorrect replica identity field in a tuple deletion WAL record", "evidence": {"same_day": true, "patch_ids": ["40e03536fea4bcb2ac3c575edb75178e"], "statement_hash": "9ccf70c6f337df25e1b9d44f38db0997bf19ea561d397376282e030a186906cc"}, "url": "/docs/compare/?release=10.7#10.7-7c2675cadb19eb6a", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "e4a59bd60faed5b215e7f57ee7ca981c", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Avoid possibly writing an incorrect replica identity field in a tuple deletion WAL record", "evidence": {"same_day": true, "patch_ids": ["40e03536fea4bcb2ac3c575edb75178e"], "statement_hash": "9ccf70c6f337df25e1b9d44f38db0997bf19ea561d397376282e030a186906cc"}, "url": "/docs/compare/?release=9.6.12#9.6.12-7c2675cadb19eb6a", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "98ce6a70875f0f5e8fe26ab23a72ad9d", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Avoid possibly writing an incorrect replica identity field in a tuple deletion WAL record", "evidence": {"same_day": true, "patch_ids": ["40e03536fea4bcb2ac3c575edb75178e"], "statement_hash": "9ccf70c6f337df25e1b9d44f38db0997bf19ea561d397376282e030a186906cc"}, "url": "/docs/compare/?release=9.4.21#9.4.21-7c2675cadb19eb6a", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-5e4b21994a59dd6e", "cves": [], "html": "Make the archiver prioritize WAL history files over WAL data files while choosing which file to archive next (David Steele)
", "text": "Make the archiver prioritize WAL history files over WAL data files while choosing which file to archive next (David Steele)", "title": "Make the archiver prioritize WAL history files over WAL data files while choosing which file to archive next", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "2b2cd94eb7dd94d694efcba376aad5b8f2b5c34d0c3a8d175af3ce7502157fbe", "section_path": ["Changes"], "commit_groups": [["085757577", "37126251a", "937870124", "a016f59d5", "b981df4cc"]], "identity_text": "Make the archiver prioritize WAL history files over WAL data files while choosing which file to archive next (David Steele)", "commit_aliases": ["085757577", "37126251a", "937870124", "a016f59d5", "b981df4cc"], "source_commits": ["37126251a"], "source_entry_id": "9.5.16/changes/009", "db_id": "609fc62ffbc8410492cb982d74e909ab", "patch_ids": ["172f626bc2da35c3f07181a39fe610e4"], "statement_hash": "f9f68113cbc29fac8ccf420f6686844680a87d100a4d66902b1e49eeed6d9be4", "relations": [{"rule": 2, "type": "equivalent", "target": "02aabd9c5045d5d8ca6a6184370e2454", "evidence": {"same_day": true, "patch_ids": ["172f626bc2da35c3f07181a39fe610e4"], "statement_hash": "f9f68113cbc29fac8ccf420f6686844680a87d100a4d66902b1e49eeed6d9be4"}}, {"rule": 2, "type": "equivalent", "target": "10003f32c1373df8626adf1a4222cabd", "evidence": {"same_day": true, "patch_ids": ["172f626bc2da35c3f07181a39fe610e4"], "statement_hash": "f9f68113cbc29fac8ccf420f6686844680a87d100a4d66902b1e49eeed6d9be4"}}, {"rule": 2, "type": "equivalent", "target": "f0315d811153b9463dd919591f3b4f41", "evidence": {"same_day": true, "patch_ids": ["172f626bc2da35c3f07181a39fe610e4"], "statement_hash": "f9f68113cbc29fac8ccf420f6686844680a87d100a4d66902b1e49eeed6d9be4"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "10003f32c1373df8626adf1a4222cabd", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Make the archiver prioritize WAL history files over WAL data files while choosing which file to archive next", "evidence": {"same_day": true, "patch_ids": ["172f626bc2da35c3f07181a39fe610e4"], "statement_hash": "f9f68113cbc29fac8ccf420f6686844680a87d100a4d66902b1e49eeed6d9be4"}, "url": "/docs/compare/?release=11.2#11.2-5e4b21994a59dd6e", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "f0315d811153b9463dd919591f3b4f41", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Make the archiver prioritize WAL history files over WAL data files while choosing which file to archive next", "evidence": {"same_day": true, "patch_ids": ["172f626bc2da35c3f07181a39fe610e4"], "statement_hash": "f9f68113cbc29fac8ccf420f6686844680a87d100a4d66902b1e49eeed6d9be4"}, "url": "/docs/compare/?release=10.7#10.7-5e4b21994a59dd6e", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "02aabd9c5045d5d8ca6a6184370e2454", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Make the archiver prioritize WAL history files over WAL data files while choosing which file to archive next", "evidence": {"same_day": true, "patch_ids": ["172f626bc2da35c3f07181a39fe610e4"], "statement_hash": "f9f68113cbc29fac8ccf420f6686844680a87d100a4d66902b1e49eeed6d9be4"}, "url": "/docs/compare/?release=9.6.12#9.6.12-5e4b21994a59dd6e", "source_url": "/docs/release/9.6.12/#AEN133889"}]}, {"id": "9.5.16-1b1d1da2ab0d398a", "cves": [], "html": "Fix possible crash in UPDATE with a multiple SET clause using a sub-SELECT as source (Tom Lane)
", "text": "Fix possible crash in UPDATE with a multiple SET clause using a sub-SELECT as source (Tom Lane)", "title": "Fix possible crash in UPDATE with a multiple SET clause using a sub-SELECT as source", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "7eacd1494a2c0701b496e91c4489727bcf541a416794b54212bbbaa6c8ed2d8a", "section_path": ["Changes"], "commit_groups": [["0f7ec8d9c", "10bad8c0f", "302d4eee9", "6548d62a9", "f9f63ed1f"]], "identity_text": "Fix possible crash in UPDATE with a multiple SET clause using a sub-SELECT as source (Tom Lane)", "commit_aliases": ["0f7ec8d9c", "10bad8c0f", "302d4eee9", "6548d62a9", "f9f63ed1f"], "source_commits": ["6548d62a9"], "source_entry_id": "9.5.16/changes/010", "db_id": "e44b74dbf3112b960f5bf87f3cec1360", "patch_ids": ["a8b0d3aa98deac5cc468e64a9f8886c5"], "statement_hash": "030c6a39fb8f37e8c71f2463444e806c38641b0d6575bed1d0dfd7b9286e3f97", "relations": [{"rule": 2, "type": "equivalent", "target": "7d794a0f97dc8da3a00f372bbc0c20bc", "evidence": {"same_day": true, "patch_ids": ["a8b0d3aa98deac5cc468e64a9f8886c5"], "statement_hash": "030c6a39fb8f37e8c71f2463444e806c38641b0d6575bed1d0dfd7b9286e3f97"}}, {"rule": 2, "type": "equivalent", "target": "8473fd0fff739c0a7e785221163f247a", "evidence": {"same_day": true, "patch_ids": ["a8b0d3aa98deac5cc468e64a9f8886c5"], "statement_hash": "030c6a39fb8f37e8c71f2463444e806c38641b0d6575bed1d0dfd7b9286e3f97"}}, {"rule": 2, "type": "equivalent", "target": "9988c85d19444ea8af623b4c617b881f", "evidence": {"same_day": true, "patch_ids": ["a8b0d3aa98deac5cc468e64a9f8886c5"], "statement_hash": "030c6a39fb8f37e8c71f2463444e806c38641b0d6575bed1d0dfd7b9286e3f97"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "8473fd0fff739c0a7e785221163f247a", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Fix possible crash in UPDATE with a multiple SET clause using a sub-SELECT as source", "evidence": {"same_day": true, "patch_ids": ["a8b0d3aa98deac5cc468e64a9f8886c5"], "statement_hash": "030c6a39fb8f37e8c71f2463444e806c38641b0d6575bed1d0dfd7b9286e3f97"}, "url": "/docs/compare/?release=11.2#11.2-1b1d1da2ab0d398a", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "7d794a0f97dc8da3a00f372bbc0c20bc", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Fix possible crash in UPDATE with a multiple SET clause using a sub-SELECT as source", "evidence": {"same_day": true, "patch_ids": ["a8b0d3aa98deac5cc468e64a9f8886c5"], "statement_hash": "030c6a39fb8f37e8c71f2463444e806c38641b0d6575bed1d0dfd7b9286e3f97"}, "url": "/docs/compare/?release=10.7#10.7-1b1d1da2ab0d398a", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "9988c85d19444ea8af623b4c617b881f", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Fix possible crash in UPDATE with a multiple SET clause using a sub-SELECT as source", "evidence": {"same_day": true, "patch_ids": ["a8b0d3aa98deac5cc468e64a9f8886c5"], "statement_hash": "030c6a39fb8f37e8c71f2463444e806c38641b0d6575bed1d0dfd7b9286e3f97"}, "url": "/docs/compare/?release=9.6.12#9.6.12-1b1d1da2ab0d398a", "source_url": "/docs/release/9.6.12/#AEN133889"}]}, {"id": "9.5.16-1aa7646d1b7a9e4b", "cves": [], "html": "Avoid crash if libxml2 returns a null error message (Sergio Conde Gómez)
", "text": "Avoid crash if libxml2 returns a null error message (Sergio Conde Gómez)", "title": "Avoid crash if libxml2 returns a null error message", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "375a78d302737b853c94ff31d1f7ba3f8056b4ae4f6095548dcdd60dadedff61", "section_path": ["Changes"], "commit_groups": [["0d7d71b64", "0edef16d7", "37f3a7751", "7821a4d60", "8e2956734", "ef922faea"]], "identity_text": "Avoid crash if libxml2 returns a null error message (Sergio Conde Gómez)", "commit_aliases": ["0d7d71b64", "0edef16d7", "37f3a7751", "7821a4d60", "8e2956734", "ef922faea"], "source_commits": ["7821a4d60"], "source_entry_id": "9.5.16/changes/011", "db_id": "1387d78c9243333e07793e10eea9f6e4", "patch_ids": ["756e7b21ff4acff04aeb731313e5eb12"], "statement_hash": "36824cc82ae51a6995057dd5e9f812c862c647537ed5268a803c9ed08923b7b9", "relations": [{"rule": 2, "type": "equivalent", "target": "294aa1f458016522ac69d75341bf8752", "evidence": {"same_day": true, "patch_ids": ["756e7b21ff4acff04aeb731313e5eb12"], "statement_hash": "36824cc82ae51a6995057dd5e9f812c862c647537ed5268a803c9ed08923b7b9"}}, {"rule": 2, "type": "equivalent", "target": "4fd8345e31bf46d7156f7c05feb39327", "evidence": {"same_day": true, "patch_ids": ["756e7b21ff4acff04aeb731313e5eb12"], "statement_hash": "36824cc82ae51a6995057dd5e9f812c862c647537ed5268a803c9ed08923b7b9"}}, {"rule": 2, "type": "equivalent", "target": "5541174a4de609c53f81cbb8b8bead93", "evidence": {"same_day": true, "patch_ids": ["756e7b21ff4acff04aeb731313e5eb12"], "statement_hash": "36824cc82ae51a6995057dd5e9f812c862c647537ed5268a803c9ed08923b7b9"}}, {"rule": 2, "type": "equivalent", "target": "cd0ea67859104d8dca4e73127e3466cd", "evidence": {"same_day": true, "patch_ids": ["756e7b21ff4acff04aeb731313e5eb12"], "statement_hash": "36824cc82ae51a6995057dd5e9f812c862c647537ed5268a803c9ed08923b7b9"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "294aa1f458016522ac69d75341bf8752", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Avoid crash if libxml2 returns a null error message", "evidence": {"same_day": true, "patch_ids": ["756e7b21ff4acff04aeb731313e5eb12"], "statement_hash": "36824cc82ae51a6995057dd5e9f812c862c647537ed5268a803c9ed08923b7b9"}, "url": "/docs/compare/?release=11.2#11.2-1aa7646d1b7a9e4b", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "5541174a4de609c53f81cbb8b8bead93", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Avoid crash if libxml2 returns a null error message", "evidence": {"same_day": true, "patch_ids": ["756e7b21ff4acff04aeb731313e5eb12"], "statement_hash": "36824cc82ae51a6995057dd5e9f812c862c647537ed5268a803c9ed08923b7b9"}, "url": "/docs/compare/?release=10.7#10.7-1aa7646d1b7a9e4b", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "4fd8345e31bf46d7156f7c05feb39327", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Avoid crash if libxml2 returns a null error message", "evidence": {"same_day": true, "patch_ids": ["756e7b21ff4acff04aeb731313e5eb12"], "statement_hash": "36824cc82ae51a6995057dd5e9f812c862c647537ed5268a803c9ed08923b7b9"}, "url": "/docs/compare/?release=9.6.12#9.6.12-1aa7646d1b7a9e4b", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "cd0ea67859104d8dca4e73127e3466cd", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Avoid crash if libxml2 returns a null error message", "evidence": {"same_day": true, "patch_ids": ["756e7b21ff4acff04aeb731313e5eb12"], "statement_hash": "36824cc82ae51a6995057dd5e9f812c862c647537ed5268a803c9ed08923b7b9"}, "url": "/docs/compare/?release=9.4.21#9.4.21-1aa7646d1b7a9e4b", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-24bd73b49e41e8b2", "cves": [], "html": "Fix spurious grouping-related parser errors caused by inconsistent handling of collation assignment (Andrew Gierth)
\nIn some cases, expressions that should be considered to match were not seen as matching, if they included operations on collatable data types.
", "text": "Fix spurious grouping-related parser errors caused by inconsistent handling of collation assignment (Andrew Gierth) In some cases, expressions that should be considered to match were not seen as matching, if they included operations on collatable data types.", "title": "Fix spurious grouping-related parser errors caused by inconsistent handling of collation assignment", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "6cd4d8f581fa7b847b569aabe502158f66e7a3999ce09b70deaa6a98f118eb2e", "section_path": ["Changes"], "commit_groups": [["174fab993", "409230a72", "624046abe", "91448e7dc", "d16d45387", "e74d8c508"]], "identity_text": "Fix spurious grouping-related parser errors caused by inconsistent handling of collation assignment (Andrew Gierth) In some cases, expressions that should be considered to match were not seen as matching, if they included operations on collatable data types.", "commit_aliases": ["174fab993", "409230a72", "624046abe", "91448e7dc", "d16d45387", "e74d8c508"], "source_commits": ["91448e7dc"], "source_entry_id": "9.5.16/changes/012", "db_id": "adefdbaad9b4829e6d0acd5506afe442", "patch_ids": ["1505483bf7a831488d1704cafcd0f825"], "statement_hash": "9b8b2121ff38e3866696396677aab1e475cd9087a8a7e8a0ed288e4ac118db6f", "relations": [{"rule": 2, "type": "equivalent", "target": "060be4642903ea45c671de9a768bd647", "evidence": {"same_day": true, "patch_ids": ["1505483bf7a831488d1704cafcd0f825"], "statement_hash": "9b8b2121ff38e3866696396677aab1e475cd9087a8a7e8a0ed288e4ac118db6f"}}, {"rule": 2, "type": "equivalent", "target": "1c59b58c733f2c85fcf942d986bef1a3", "evidence": {"same_day": true, "patch_ids": ["1505483bf7a831488d1704cafcd0f825"], "statement_hash": "9b8b2121ff38e3866696396677aab1e475cd9087a8a7e8a0ed288e4ac118db6f"}}, {"rule": 2, "type": "equivalent", "target": "9de8a6f3f5bf764272f6f8bc82c57111", "evidence": {"same_day": true, "patch_ids": ["1505483bf7a831488d1704cafcd0f825"], "statement_hash": "9b8b2121ff38e3866696396677aab1e475cd9087a8a7e8a0ed288e4ac118db6f"}}, {"rule": 2, "type": "equivalent", "target": "b14d1ad44f4f9a1753a80a190bb2b4af", "evidence": {"same_day": true, "patch_ids": ["1505483bf7a831488d1704cafcd0f825"], "statement_hash": "9b8b2121ff38e3866696396677aab1e475cd9087a8a7e8a0ed288e4ac118db6f"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "9de8a6f3f5bf764272f6f8bc82c57111", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Fix spurious grouping-related parser errors caused by inconsistent handling of collation assignment", "evidence": {"same_day": true, "patch_ids": ["1505483bf7a831488d1704cafcd0f825"], "statement_hash": "9b8b2121ff38e3866696396677aab1e475cd9087a8a7e8a0ed288e4ac118db6f"}, "url": "/docs/compare/?release=11.2#11.2-24bd73b49e41e8b2", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "060be4642903ea45c671de9a768bd647", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Fix spurious grouping-related parser errors caused by inconsistent handling of collation assignment", "evidence": {"same_day": true, "patch_ids": ["1505483bf7a831488d1704cafcd0f825"], "statement_hash": "9b8b2121ff38e3866696396677aab1e475cd9087a8a7e8a0ed288e4ac118db6f"}, "url": "/docs/compare/?release=10.7#10.7-24bd73b49e41e8b2", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "b14d1ad44f4f9a1753a80a190bb2b4af", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Fix spurious grouping-related parser errors caused by inconsistent handling of collation assignment", "evidence": {"same_day": true, "patch_ids": ["1505483bf7a831488d1704cafcd0f825"], "statement_hash": "9b8b2121ff38e3866696396677aab1e475cd9087a8a7e8a0ed288e4ac118db6f"}, "url": "/docs/compare/?release=9.6.12#9.6.12-24bd73b49e41e8b2", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "1c59b58c733f2c85fcf942d986bef1a3", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Fix spurious grouping-related parser errors caused by inconsistent handling of collation assignment", "evidence": {"same_day": true, "patch_ids": ["1505483bf7a831488d1704cafcd0f825"], "statement_hash": "9b8b2121ff38e3866696396677aab1e475cd9087a8a7e8a0ed288e4ac118db6f"}, "url": "/docs/compare/?release=9.4.21#9.4.21-24bd73b49e41e8b2", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-1b1b6952d6a8a94e", "cves": [], "html": "Check whether the comparison function underlying LEAST() or GREATEST() is leakproof, rather than just assuming it is (Tom Lane)
Actual information leaks from btree comparison functions are typically hard to provoke, but in principle they could happen.
", "text": "Check whether the comparison function underlying LEAST() or GREATEST() is leakproof, rather than just assuming it is (Tom Lane) Actual information leaks from btree comparison functions are typically hard to provoke, but in principle they could happen.", "title": "Check whether the comparison function underlying LEAST() or GREATEST() is leakproof, rather than just assuming it is", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "028dadf1993f6c32e6db074962e2f2e535165c9e9a1356ea80ebac5c949795a9", "section_path": ["Changes"], "commit_groups": [["099063340", "64edc788b", "68a13f28b", "c27c3993e", "d6b37cdb6", "f8b9b8097"]], "identity_text": "Check whether the comparison function underlying LEAST() or GREATEST() is leakproof, rather than just assuming it is (Tom Lane) Actual information leaks from btree comparison functions are typically hard to provoke, but in principle they could happen.", "commit_aliases": ["099063340", "64edc788b", "68a13f28b", "c27c3993e", "d6b37cdb6", "f8b9b8097"], "source_commits": ["f8b9b8097"], "source_entry_id": "9.5.16/changes/013", "db_id": "cdfd242c3e04a220e1c4e4f8cc327493", "patch_ids": ["10243ca6f385a264e2070242b9f73b72"], "statement_hash": "e296eb59769fc5095e9df54d61fbac3ec99331bc016ec251e60574a712d94bf1", "relations": [{"rule": 2, "type": "equivalent", "target": "2f4dc72bb3dab3438fcd9fb0351b5437", "evidence": {"same_day": true, "patch_ids": ["10243ca6f385a264e2070242b9f73b72"], "statement_hash": "e296eb59769fc5095e9df54d61fbac3ec99331bc016ec251e60574a712d94bf1"}}, {"rule": 2, "type": "equivalent", "target": "4a48718b3f267d0e84af709c736400f0", "evidence": {"same_day": true, "patch_ids": ["10243ca6f385a264e2070242b9f73b72"], "statement_hash": "e296eb59769fc5095e9df54d61fbac3ec99331bc016ec251e60574a712d94bf1"}}, {"rule": 2, "type": "equivalent", "target": "51fe53d8127248de741bb349f298e27a", "evidence": {"same_day": true, "patch_ids": ["10243ca6f385a264e2070242b9f73b72"], "statement_hash": "e296eb59769fc5095e9df54d61fbac3ec99331bc016ec251e60574a712d94bf1"}}, {"rule": 2, "type": "equivalent", "target": "be7605ab0906c2e02cca861022499953", "evidence": {"same_day": true, "patch_ids": ["10243ca6f385a264e2070242b9f73b72"], "statement_hash": "e296eb59769fc5095e9df54d61fbac3ec99331bc016ec251e60574a712d94bf1"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "be7605ab0906c2e02cca861022499953", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Check whether the comparison function underlying LEAST() or GREATEST() is leakproof, rather than just assuming it is", "evidence": {"same_day": true, "patch_ids": ["10243ca6f385a264e2070242b9f73b72"], "statement_hash": "e296eb59769fc5095e9df54d61fbac3ec99331bc016ec251e60574a712d94bf1"}, "url": "/docs/compare/?release=11.2#11.2-1b1b6952d6a8a94e", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "2f4dc72bb3dab3438fcd9fb0351b5437", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Check whether the comparison function underlying LEAST() or GREATEST() is leakproof, rather than just assuming it is", "evidence": {"same_day": true, "patch_ids": ["10243ca6f385a264e2070242b9f73b72"], "statement_hash": "e296eb59769fc5095e9df54d61fbac3ec99331bc016ec251e60574a712d94bf1"}, "url": "/docs/compare/?release=10.7#10.7-1b1b6952d6a8a94e", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "51fe53d8127248de741bb349f298e27a", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Check whether the comparison function underlying LEAST() or GREATEST() is leakproof, rather than just assuming it is", "evidence": {"same_day": true, "patch_ids": ["10243ca6f385a264e2070242b9f73b72"], "statement_hash": "e296eb59769fc5095e9df54d61fbac3ec99331bc016ec251e60574a712d94bf1"}, "url": "/docs/compare/?release=9.6.12#9.6.12-1b1b6952d6a8a94e", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "4a48718b3f267d0e84af709c736400f0", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Check whether the comparison function underlying LEAST() or GREATEST() is leakproof, rather than just assuming it is", "evidence": {"same_day": true, "patch_ids": ["10243ca6f385a264e2070242b9f73b72"], "statement_hash": "e296eb59769fc5095e9df54d61fbac3ec99331bc016ec251e60574a712d94bf1"}, "url": "/docs/compare/?release=9.4.21#9.4.21-1b1b6952d6a8a94e", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-4e0b11a785566acd", "cves": [], "html": "Fix incorrect planning of queries in which a lateral reference must be evaluated at a foreign table scan (Tom Lane)
", "text": "Fix incorrect planning of queries in which a lateral reference must be evaluated at a foreign table scan (Tom Lane)", "title": "Fix incorrect planning of queries in which a lateral reference must be evaluated at a foreign table scan", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "b1be77045d55b6fb84ebd6a29ccf3c7a2fa1dd9983029ba84dedbf5869dda3fc", "section_path": ["Changes"], "commit_groups": [["1eeee6909", "34ea1ab7f", "876fd37fc", "9d6d2b213", "d468da0d6", "e3101a031"]], "identity_text": "Fix incorrect planning of queries in which a lateral reference must be evaluated at a foreign table scan (Tom Lane)", "commit_aliases": ["1eeee6909", "34ea1ab7f", "876fd37fc", "9d6d2b213", "d468da0d6", "e3101a031"], "source_commits": ["1eeee6909"], "source_entry_id": "9.5.16/changes/014", "db_id": "354d2112f020f99f16e1450a3cd1025f", "patch_ids": ["5336bcec2f5932123cd50ba929c09635"], "statement_hash": "f3091c700511a6d7a2c1ce5cc02e01c0e3ef669e204ee0d11f67ad84402d15a9", "relations": [{"rule": 2, "type": "equivalent", "target": "3531afe827dc600e49c040c0ce648222", "evidence": {"same_day": true, "patch_ids": ["5336bcec2f5932123cd50ba929c09635"], "statement_hash": "f3091c700511a6d7a2c1ce5cc02e01c0e3ef669e204ee0d11f67ad84402d15a9"}}, {"rule": 2, "type": "equivalent", "target": "4f8191ef4325da8ce0c5b095f97f4db7", "evidence": {"same_day": true, "patch_ids": ["5336bcec2f5932123cd50ba929c09635"], "statement_hash": "f3091c700511a6d7a2c1ce5cc02e01c0e3ef669e204ee0d11f67ad84402d15a9"}}, {"rule": 2, "type": "equivalent", "target": "5b7564d69abdb31fc354f01bb0d390c2", "evidence": {"same_day": true, "patch_ids": ["5336bcec2f5932123cd50ba929c09635"], "statement_hash": "f3091c700511a6d7a2c1ce5cc02e01c0e3ef669e204ee0d11f67ad84402d15a9"}}, {"rule": 2, "type": "equivalent", "target": "bda1eb21f9480626ad4d9bf00073346e", "evidence": {"same_day": true, "patch_ids": ["5336bcec2f5932123cd50ba929c09635"], "statement_hash": "f3091c700511a6d7a2c1ce5cc02e01c0e3ef669e204ee0d11f67ad84402d15a9"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "bda1eb21f9480626ad4d9bf00073346e", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Fix incorrect planning of queries in which a lateral reference must be evaluated at a foreign table scan", "evidence": {"same_day": true, "patch_ids": ["5336bcec2f5932123cd50ba929c09635"], "statement_hash": "f3091c700511a6d7a2c1ce5cc02e01c0e3ef669e204ee0d11f67ad84402d15a9"}, "url": "/docs/compare/?release=11.2#11.2-4e0b11a785566acd", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "4f8191ef4325da8ce0c5b095f97f4db7", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Fix incorrect planning of queries in which a lateral reference must be evaluated at a foreign table scan", "evidence": {"same_day": true, "patch_ids": ["5336bcec2f5932123cd50ba929c09635"], "statement_hash": "f3091c700511a6d7a2c1ce5cc02e01c0e3ef669e204ee0d11f67ad84402d15a9"}, "url": "/docs/compare/?release=10.7#10.7-4e0b11a785566acd", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "5b7564d69abdb31fc354f01bb0d390c2", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Fix incorrect planning of queries in which a lateral reference must be evaluated at a foreign table scan", "evidence": {"same_day": true, "patch_ids": ["5336bcec2f5932123cd50ba929c09635"], "statement_hash": "f3091c700511a6d7a2c1ce5cc02e01c0e3ef669e204ee0d11f67ad84402d15a9"}, "url": "/docs/compare/?release=9.6.12#9.6.12-4e0b11a785566acd", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "3531afe827dc600e49c040c0ce648222", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Fix incorrect planning of queries in which a lateral reference must be evaluated at a foreign table scan", "evidence": {"same_day": true, "patch_ids": ["5336bcec2f5932123cd50ba929c09635"], "statement_hash": "f3091c700511a6d7a2c1ce5cc02e01c0e3ef669e204ee0d11f67ad84402d15a9"}, "url": "/docs/compare/?release=9.4.21#9.4.21-4e0b11a785566acd", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-7309ead3042c7c33", "cves": [], "html": "Fix corner-case underestimation of the cost of a merge join (Tom Lane)
\nThe planner could prefer a merge join when the outer key range is much smaller than the inner key range, even if there are so many duplicate keys on the inner side that this is a poor choice.
", "text": "Fix corner-case underestimation of the cost of a merge join (Tom Lane) The planner could prefer a merge join when the outer key range is much smaller than the inner key range, even if there are so many duplicate keys on the inner side that this is a poor choice.", "title": "Fix corner-case underestimation of the cost of a merge join", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "e8ccd04bdb210a7b4e24c704e36f4468e5a2efc6f629816ef9ac70931b72ab5c", "section_path": ["Changes"], "commit_groups": [["72a626e68", "7c2bc40b8", "ad425aaf0", "d16567093", "d364e8815", "ef673a32d"]], "identity_text": "Fix corner-case underestimation of the cost of a merge join (Tom Lane) The planner could prefer a merge join when the outer key range is much smaller than the inner key range, even if there are so many duplicate keys on the inner side that this is a poor choice.", "commit_aliases": ["72a626e68", "7c2bc40b8", "ad425aaf0", "d16567093", "d364e8815", "ef673a32d"], "source_commits": ["72a626e68"], "source_entry_id": "9.5.16/changes/015", "db_id": "dc36638f2802173341812995b8e58e6b", "patch_ids": ["6340549505356d918a295f3ea6c5f596"], "statement_hash": "3aa9e70862272955da108fbeba34d23fcd4accdcd545e34bcf5783c2723d3f17", "relations": [{"rule": 2, "type": "equivalent", "target": "1e50a972cb40096b25a48680c1810ea4", "evidence": {"same_day": true, "patch_ids": ["6340549505356d918a295f3ea6c5f596"], "statement_hash": "3aa9e70862272955da108fbeba34d23fcd4accdcd545e34bcf5783c2723d3f17"}}, {"rule": 2, "type": "equivalent", "target": "59072165ff62b908831246d189ccdd3f", "evidence": {"same_day": true, "patch_ids": ["6340549505356d918a295f3ea6c5f596"], "statement_hash": "3aa9e70862272955da108fbeba34d23fcd4accdcd545e34bcf5783c2723d3f17"}}, {"rule": 2, "type": "equivalent", "target": "a9b825e90ea5bfde11ce4b49ec05bbd8", "evidence": {"same_day": true, "patch_ids": ["6340549505356d918a295f3ea6c5f596"], "statement_hash": "3aa9e70862272955da108fbeba34d23fcd4accdcd545e34bcf5783c2723d3f17"}}, {"rule": 2, "type": "equivalent", "target": "f83041a6e870e795da2ed3a6ada57352", "evidence": {"same_day": true, "patch_ids": ["6340549505356d918a295f3ea6c5f596"], "statement_hash": "3aa9e70862272955da108fbeba34d23fcd4accdcd545e34bcf5783c2723d3f17"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "59072165ff62b908831246d189ccdd3f", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Fix corner-case underestimation of the cost of a merge join", "evidence": {"same_day": true, "patch_ids": ["6340549505356d918a295f3ea6c5f596"], "statement_hash": "3aa9e70862272955da108fbeba34d23fcd4accdcd545e34bcf5783c2723d3f17"}, "url": "/docs/compare/?release=11.2#11.2-7309ead3042c7c33", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "a9b825e90ea5bfde11ce4b49ec05bbd8", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Fix corner-case underestimation of the cost of a merge join", "evidence": {"same_day": true, "patch_ids": ["6340549505356d918a295f3ea6c5f596"], "statement_hash": "3aa9e70862272955da108fbeba34d23fcd4accdcd545e34bcf5783c2723d3f17"}, "url": "/docs/compare/?release=10.7#10.7-7309ead3042c7c33", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "1e50a972cb40096b25a48680c1810ea4", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Fix corner-case underestimation of the cost of a merge join", "evidence": {"same_day": true, "patch_ids": ["6340549505356d918a295f3ea6c5f596"], "statement_hash": "3aa9e70862272955da108fbeba34d23fcd4accdcd545e34bcf5783c2723d3f17"}, "url": "/docs/compare/?release=9.6.12#9.6.12-7309ead3042c7c33", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "f83041a6e870e795da2ed3a6ada57352", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Fix corner-case underestimation of the cost of a merge join", "evidence": {"same_day": true, "patch_ids": ["6340549505356d918a295f3ea6c5f596"], "statement_hash": "3aa9e70862272955da108fbeba34d23fcd4accdcd545e34bcf5783c2723d3f17"}, "url": "/docs/compare/?release=9.4.21#9.4.21-7309ead3042c7c33", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-2d36ded9270877ad", "cves": [], "html": "Avoid O(N^2) planning time growth when a query contains many thousand indexable clauses (Tom Lane)
", "text": "Avoid O(N^2) planning time growth when a query contains many thousand indexable clauses (Tom Lane)", "title": "Avoid O(N^2) planning time growth when a query contains many thousand indexable clauses", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "5132039435513b600368c80b5bfb7ae84d8353089e933d850901352fe9e388c0", "section_path": ["Changes"], "commit_groups": [["15b9d47c8", "2abc87953", "92dbbe90c", "c6b3835c7", "e3f005d97", "fe66fc6f9"]], "identity_text": "Avoid O(N^2) planning time growth when a query contains many thousand indexable clauses (Tom Lane)", "commit_aliases": ["15b9d47c8", "2abc87953", "92dbbe90c", "c6b3835c7", "e3f005d97", "fe66fc6f9"], "source_commits": ["92dbbe90c"], "source_entry_id": "9.5.16/changes/016", "db_id": "a8c9373aada4826cbc39f1c06cfbe049", "patch_ids": ["0912f086f01bc30847925ec6bc7d7489"], "statement_hash": "3195b99f61e63a1563de767582a58805cdd4a00e87311931ec01c60a5742ff73", "relations": [{"rule": 2, "type": "equivalent", "target": "0a496a38c0b0b6f4ab2f6638c619f1b4", "evidence": {"same_day": true, "patch_ids": ["0912f086f01bc30847925ec6bc7d7489"], "statement_hash": "3195b99f61e63a1563de767582a58805cdd4a00e87311931ec01c60a5742ff73"}}, {"rule": 2, "type": "equivalent", "target": "ab6454b9c1c6337e8af4edb10bfdd0f1", "evidence": {"same_day": true, "patch_ids": ["0912f086f01bc30847925ec6bc7d7489"], "statement_hash": "3195b99f61e63a1563de767582a58805cdd4a00e87311931ec01c60a5742ff73"}}, {"rule": 2, "type": "equivalent", "target": "ca0ac4ee39d73cb3de7c04797db89709", "evidence": {"same_day": true, "patch_ids": ["0912f086f01bc30847925ec6bc7d7489"], "statement_hash": "3195b99f61e63a1563de767582a58805cdd4a00e87311931ec01c60a5742ff73"}}, {"rule": 2, "type": "equivalent", "target": "e006c28481e2a55db16d28c805352633", "evidence": {"same_day": true, "patch_ids": ["0912f086f01bc30847925ec6bc7d7489"], "statement_hash": "3195b99f61e63a1563de767582a58805cdd4a00e87311931ec01c60a5742ff73"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "0a496a38c0b0b6f4ab2f6638c619f1b4", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Avoid O(N^2) planning time growth when a query contains many thousand indexable clauses", "evidence": {"same_day": true, "patch_ids": ["0912f086f01bc30847925ec6bc7d7489"], "statement_hash": "3195b99f61e63a1563de767582a58805cdd4a00e87311931ec01c60a5742ff73"}, "url": "/docs/compare/?release=11.2#11.2-2d36ded9270877ad", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "ca0ac4ee39d73cb3de7c04797db89709", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Avoid O(N^2) planning time growth when a query contains many thousand indexable clauses", "evidence": {"same_day": true, "patch_ids": ["0912f086f01bc30847925ec6bc7d7489"], "statement_hash": "3195b99f61e63a1563de767582a58805cdd4a00e87311931ec01c60a5742ff73"}, "url": "/docs/compare/?release=10.7#10.7-2d36ded9270877ad", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "ab6454b9c1c6337e8af4edb10bfdd0f1", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Avoid O(N^2) planning time growth when a query contains many thousand indexable clauses", "evidence": {"same_day": true, "patch_ids": ["0912f086f01bc30847925ec6bc7d7489"], "statement_hash": "3195b99f61e63a1563de767582a58805cdd4a00e87311931ec01c60a5742ff73"}, "url": "/docs/compare/?release=9.6.12#9.6.12-2d36ded9270877ad", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "e006c28481e2a55db16d28c805352633", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Avoid O(N^2) planning time growth when a query contains many thousand indexable clauses", "evidence": {"same_day": true, "patch_ids": ["0912f086f01bc30847925ec6bc7d7489"], "statement_hash": "3195b99f61e63a1563de767582a58805cdd4a00e87311931ec01c60a5742ff73"}, "url": "/docs/compare/?release=9.4.21#9.4.21-2d36ded9270877ad", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-b62763def122f748", "cves": [], "html": "Improve ANALYZE's handling of concurrently-updated rows (Jeff Janes, Tom Lane)
\nPreviously, rows deleted by an in-progress transaction were omitted from ANALYZE's sample, but this has been found to lead to more inconsistency than including them would do. In effect, the sample now corresponds to an MVCC snapshot as of ANALYZE's start time.
", "text": "Improve ANALYZE's handling of concurrently-updated rows (Jeff Janes, Tom Lane) Previously, rows deleted by an in-progress transaction were omitted from ANALYZE's sample, but this has been found to lead to more inconsistency than including them would do. In effect, the sample now corresponds to an MVCC snapshot as of ANALYZE's start time.", "title": "Improve ANALYZE's handling of concurrently-updated rows", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "68b92b979f0f1e1a2a34d498d6326199d215f56d8a965fba7cb66ef80b2cabea", "section_path": ["Changes"], "commit_groups": [["3010de813", "60de80cd2", "708931c2d", "7170268ef", "d2557c42a", "fc8adddd9"]], "identity_text": "Improve ANALYZE's handling of concurrently-updated rows (Jeff Janes, Tom Lane) Previously, rows deleted by an in-progress transaction were omitted from ANALYZE's sample, but this has been found to lead to more inconsistency than including them would do. In effect, the sample now corresponds to an MVCC snapshot as of ANALYZE's start time.", "commit_aliases": ["3010de813", "60de80cd2", "708931c2d", "7170268ef", "d2557c42a", "fc8adddd9"], "source_commits": ["d2557c42a"], "source_entry_id": "9.5.16/changes/017", "db_id": "45348ab6ed1c570431a1d61d73eebcd6", "patch_ids": ["3c34cbfb351f59987d9a949d4feb7c47"], "statement_hash": "913ee89a1c2564947f98228968097621de88b282c2722f24c6200ea4a49fae40", "relations": [{"rule": 2, "type": "equivalent", "target": "2fb9837020438844d1fb354dc4240f57", "evidence": {"same_day": true, "patch_ids": ["3c34cbfb351f59987d9a949d4feb7c47"], "statement_hash": "913ee89a1c2564947f98228968097621de88b282c2722f24c6200ea4a49fae40"}}, {"rule": 2, "type": "equivalent", "target": "65e06740e546a93ed9c9bb2f5c0ca8b2", "evidence": {"same_day": true, "patch_ids": ["3c34cbfb351f59987d9a949d4feb7c47"], "statement_hash": "913ee89a1c2564947f98228968097621de88b282c2722f24c6200ea4a49fae40"}}, {"rule": 2, "type": "equivalent", "target": "9a69f4d0cbaa57a27d628df448272eb9", "evidence": {"same_day": true, "patch_ids": ["3c34cbfb351f59987d9a949d4feb7c47"], "statement_hash": "913ee89a1c2564947f98228968097621de88b282c2722f24c6200ea4a49fae40"}}, {"rule": 2, "type": "equivalent", "target": "a05df9f2fd20ee32f21f0d5e0ba1dc51", "evidence": {"same_day": true, "patch_ids": ["3c34cbfb351f59987d9a949d4feb7c47"], "statement_hash": "913ee89a1c2564947f98228968097621de88b282c2722f24c6200ea4a49fae40"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "65e06740e546a93ed9c9bb2f5c0ca8b2", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Improve ANALYZE's handling of concurrently-updated rows", "evidence": {"same_day": true, "patch_ids": ["3c34cbfb351f59987d9a949d4feb7c47"], "statement_hash": "913ee89a1c2564947f98228968097621de88b282c2722f24c6200ea4a49fae40"}, "url": "/docs/compare/?release=11.2#11.2-b62763def122f748", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "2fb9837020438844d1fb354dc4240f57", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Improve ANALYZE's handling of concurrently-updated rows", "evidence": {"same_day": true, "patch_ids": ["3c34cbfb351f59987d9a949d4feb7c47"], "statement_hash": "913ee89a1c2564947f98228968097621de88b282c2722f24c6200ea4a49fae40"}, "url": "/docs/compare/?release=10.7#10.7-b62763def122f748", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "9a69f4d0cbaa57a27d628df448272eb9", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Improve ANALYZE's handling of concurrently-updated rows", "evidence": {"same_day": true, "patch_ids": ["3c34cbfb351f59987d9a949d4feb7c47"], "statement_hash": "913ee89a1c2564947f98228968097621de88b282c2722f24c6200ea4a49fae40"}, "url": "/docs/compare/?release=9.6.12#9.6.12-b62763def122f748", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "a05df9f2fd20ee32f21f0d5e0ba1dc51", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Improve ANALYZE's handling of concurrently-updated rows", "evidence": {"same_day": true, "patch_ids": ["3c34cbfb351f59987d9a949d4feb7c47"], "statement_hash": "913ee89a1c2564947f98228968097621de88b282c2722f24c6200ea4a49fae40"}, "url": "/docs/compare/?release=9.4.21#9.4.21-b62763def122f748", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-6ea49dec16e6c857", "cves": [], "html": "Make TRUNCATE ignore inheritance child tables that are temporary tables of other sessions (Amit Langote, Michael Paquier)
\nThis brings TRUNCATE into line with the behavior of other commands. Previously, such cases usually ended in failure.
", "text": "Make TRUNCATE ignore inheritance child tables that are temporary tables of other sessions (Amit Langote, Michael Paquier) This brings TRUNCATE into line with the behavior of other commands. Previously, such cases usually ended in failure.", "title": "Make TRUNCATE ignore inheritance child tables that are temporary tables of other sessions", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "9177c508f3b577a0823d2d58c891e8dbbd4d985a8f00c535da39f16c52eba7db", "section_path": ["Changes"], "commit_groups": [["0a323ae67", "1d7007671", "1e504f01d", "285abc8df", "b30b9dce1", "d4486700b"]], "identity_text": "Make TRUNCATE ignore inheritance child tables that are temporary tables of other sessions (Amit Langote, Michael Paquier) This brings TRUNCATE into line with the behavior of other commands. Previously, such cases usually ended in failure.", "commit_aliases": ["0a323ae67", "1d7007671", "1e504f01d", "285abc8df", "b30b9dce1", "d4486700b"], "source_commits": ["0a323ae67"], "source_entry_id": "9.5.16/changes/018", "db_id": "c205e6791fa6f13866b21b6fa8dc3e6a", "patch_ids": ["f92fd323b016dddd573493fc747398a4"], "statement_hash": "a99e870d67a97dea8231a9ec6a842903fcc5c68a387617d68b96f61c231754ab", "relations": [{"rule": 2, "type": "equivalent", "target": "299a173b84bdbba2b2ef7d7f5e68b412", "evidence": {"same_day": true, "patch_ids": ["f92fd323b016dddd573493fc747398a4"], "statement_hash": "a99e870d67a97dea8231a9ec6a842903fcc5c68a387617d68b96f61c231754ab"}}, {"rule": 2, "type": "equivalent", "target": "58b5ad27b1ad1e5d9ed30605286a7461", "evidence": {"same_day": true, "patch_ids": ["f92fd323b016dddd573493fc747398a4"], "statement_hash": "a99e870d67a97dea8231a9ec6a842903fcc5c68a387617d68b96f61c231754ab"}}, {"rule": 2, "type": "equivalent", "target": "ba9b63c069d724acd9ecc209c77d9c9e", "evidence": {"same_day": true, "patch_ids": ["f92fd323b016dddd573493fc747398a4"], "statement_hash": "a99e870d67a97dea8231a9ec6a842903fcc5c68a387617d68b96f61c231754ab"}}, {"rule": 2, "type": "equivalent", "target": "e6df38661dbacd724751a1c6fbdf5b3b", "evidence": {"same_day": true, "patch_ids": ["f92fd323b016dddd573493fc747398a4"], "statement_hash": "a99e870d67a97dea8231a9ec6a842903fcc5c68a387617d68b96f61c231754ab"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "e6df38661dbacd724751a1c6fbdf5b3b", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Make TRUNCATE ignore inheritance child tables that are temporary tables of other sessions", "evidence": {"same_day": true, "patch_ids": ["f92fd323b016dddd573493fc747398a4"], "statement_hash": "a99e870d67a97dea8231a9ec6a842903fcc5c68a387617d68b96f61c231754ab"}, "url": "/docs/compare/?release=11.2#11.2-6ea49dec16e6c857", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "58b5ad27b1ad1e5d9ed30605286a7461", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Make TRUNCATE ignore inheritance child tables that are temporary tables of other sessions", "evidence": {"same_day": true, "patch_ids": ["f92fd323b016dddd573493fc747398a4"], "statement_hash": "a99e870d67a97dea8231a9ec6a842903fcc5c68a387617d68b96f61c231754ab"}, "url": "/docs/compare/?release=10.7#10.7-6ea49dec16e6c857", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "299a173b84bdbba2b2ef7d7f5e68b412", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Make TRUNCATE ignore inheritance child tables that are temporary tables of other sessions", "evidence": {"same_day": true, "patch_ids": ["f92fd323b016dddd573493fc747398a4"], "statement_hash": "a99e870d67a97dea8231a9ec6a842903fcc5c68a387617d68b96f61c231754ab"}, "url": "/docs/compare/?release=9.6.12#9.6.12-6ea49dec16e6c857", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "ba9b63c069d724acd9ecc209c77d9c9e", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Make TRUNCATE ignore inheritance child tables that are temporary tables of other sessions", "evidence": {"same_day": true, "patch_ids": ["f92fd323b016dddd573493fc747398a4"], "statement_hash": "a99e870d67a97dea8231a9ec6a842903fcc5c68a387617d68b96f61c231754ab"}, "url": "/docs/compare/?release=9.4.21#9.4.21-6ea49dec16e6c857", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-64d4adee0728e5e6", "cves": [], "html": "Fix TRUNCATE to update the statistics counters for the right table (Tom Lane)
\nIf the truncated table had a TOAST table, that table's counters were reset instead.
", "text": "Fix TRUNCATE to update the statistics counters for the right table (Tom Lane) If the truncated table had a TOAST table, that table's counters were reset instead.", "title": "Fix TRUNCATE to update the statistics counters for the right table", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "bcc221c2bde8bd072142a32f291b2cfaedea27207afc5b1205c0919ae92e21fe", "section_path": ["Changes"], "commit_groups": [["078303f79", "4d5cfb911", "54f24ab76", "5deadfef2", "aedd3d4db"]], "identity_text": "Fix TRUNCATE to update the statistics counters for the right table (Tom Lane) If the truncated table had a TOAST table, that table's counters were reset instead.", "commit_aliases": ["078303f79", "4d5cfb911", "54f24ab76", "5deadfef2", "aedd3d4db"], "source_commits": ["4d5cfb911"], "source_entry_id": "9.5.16/changes/019", "db_id": "aa509203a2ac04592ea3b3f7722d70dd", "patch_ids": ["091d85d6e03614aa970210f56481f229"], "statement_hash": "6861093f180d7fde7cc198919ed21cb880f2076f996c6646491d5b389dc14677", "relations": [{"rule": 2, "type": "equivalent", "target": "353f272f0954dfe55377911bee3a0f23", "evidence": {"same_day": true, "patch_ids": ["091d85d6e03614aa970210f56481f229"], "statement_hash": "6861093f180d7fde7cc198919ed21cb880f2076f996c6646491d5b389dc14677"}}, {"rule": 2, "type": "equivalent", "target": "7d19a7f220f9178a671c8e1477fd4b2e", "evidence": {"same_day": true, "patch_ids": ["091d85d6e03614aa970210f56481f229"], "statement_hash": "6861093f180d7fde7cc198919ed21cb880f2076f996c6646491d5b389dc14677"}}, {"rule": 2, "type": "equivalent", "target": "ffbc70723fea0383b5fc8c90fdc244be", "evidence": {"same_day": true, "patch_ids": ["091d85d6e03614aa970210f56481f229"], "statement_hash": "6861093f180d7fde7cc198919ed21cb880f2076f996c6646491d5b389dc14677"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "7d19a7f220f9178a671c8e1477fd4b2e", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Fix TRUNCATE to update the statistics counters for the right table", "evidence": {"same_day": true, "patch_ids": ["091d85d6e03614aa970210f56481f229"], "statement_hash": "6861093f180d7fde7cc198919ed21cb880f2076f996c6646491d5b389dc14677"}, "url": "/docs/compare/?release=11.2#11.2-64d4adee0728e5e6", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "353f272f0954dfe55377911bee3a0f23", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Fix TRUNCATE to update the statistics counters for the right table", "evidence": {"same_day": true, "patch_ids": ["091d85d6e03614aa970210f56481f229"], "statement_hash": "6861093f180d7fde7cc198919ed21cb880f2076f996c6646491d5b389dc14677"}, "url": "/docs/compare/?release=10.7#10.7-64d4adee0728e5e6", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "ffbc70723fea0383b5fc8c90fdc244be", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Fix TRUNCATE to update the statistics counters for the right table", "evidence": {"same_day": true, "patch_ids": ["091d85d6e03614aa970210f56481f229"], "statement_hash": "6861093f180d7fde7cc198919ed21cb880f2076f996c6646491d5b389dc14677"}, "url": "/docs/compare/?release=9.6.12#9.6.12-64d4adee0728e5e6", "source_url": "/docs/release/9.6.12/#AEN133889"}]}, {"id": "9.5.16-e9d1bb9a64ebef49", "cves": [], "html": "Allow UNLISTEN in hot-standby mode (Shay Rojansky)
\nThis is necessarily a no-op, because LISTEN isn't allowed in hot-standby mode; but allowing the dummy operation simplifies session-state-reset logic in clients.
", "text": "Allow UNLISTEN in hot-standby mode (Shay Rojansky) This is necessarily a no-op, because LISTEN isn't allowed in hot-standby mode; but allowing the dummy operation simplifies session-state-reset logic in clients.", "title": "Allow UNLISTEN in hot-standby mode", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "f2739f22ad3cfc1b9e5a3920a824db91e8cd767312852a2aed69c3cac6e40c4e", "section_path": ["Changes"], "commit_groups": [["0d5b27351", "549d2a238", "741ee4890", "c0aed6959", "e8ec19cd1", "ebfe20dc7"]], "identity_text": "Allow UNLISTEN in hot-standby mode (Shay Rojansky) This is necessarily a no-op, because LISTEN isn't allowed in hot-standby mode; but allowing the dummy operation simplifies session-state-reset logic in clients.", "commit_aliases": ["0d5b27351", "549d2a238", "741ee4890", "c0aed6959", "e8ec19cd1", "ebfe20dc7"], "source_commits": ["741ee4890"], "source_entry_id": "9.5.16/changes/020", "db_id": "7b8867c396479789254d6f0f60c9c8bd", "patch_ids": ["2ba9a4b7c4ee7927fd90c84d2f4a9f19"], "statement_hash": "fab9e03189f5d0663ef17e90457644cd321e734ecc54c35abcee773819afdb55", "relations": [{"rule": 2, "type": "equivalent", "target": "6625060b7927b8eafc9245abfea8044c", "evidence": {"same_day": true, "patch_ids": ["2ba9a4b7c4ee7927fd90c84d2f4a9f19"], "statement_hash": "fab9e03189f5d0663ef17e90457644cd321e734ecc54c35abcee773819afdb55"}}, {"rule": 2, "type": "equivalent", "target": "708768e253446bd06415b86a54662152", "evidence": {"same_day": true, "patch_ids": ["2ba9a4b7c4ee7927fd90c84d2f4a9f19"], "statement_hash": "fab9e03189f5d0663ef17e90457644cd321e734ecc54c35abcee773819afdb55"}}, {"rule": 2, "type": "equivalent", "target": "94cef92c80be30a48888bcd91173fd61", "evidence": {"same_day": true, "patch_ids": ["2ba9a4b7c4ee7927fd90c84d2f4a9f19"], "statement_hash": "fab9e03189f5d0663ef17e90457644cd321e734ecc54c35abcee773819afdb55"}}, {"rule": 2, "type": "equivalent", "target": "e2fccb10c50ec1ea815a44f2d6f7296c", "evidence": {"same_day": true, "patch_ids": ["2ba9a4b7c4ee7927fd90c84d2f4a9f19"], "statement_hash": "fab9e03189f5d0663ef17e90457644cd321e734ecc54c35abcee773819afdb55"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "e2fccb10c50ec1ea815a44f2d6f7296c", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Allow UNLISTEN in hot-standby mode", "evidence": {"same_day": true, "patch_ids": ["2ba9a4b7c4ee7927fd90c84d2f4a9f19"], "statement_hash": "fab9e03189f5d0663ef17e90457644cd321e734ecc54c35abcee773819afdb55"}, "url": "/docs/compare/?release=11.2#11.2-e9d1bb9a64ebef49", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "708768e253446bd06415b86a54662152", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Allow UNLISTEN in hot-standby mode", "evidence": {"same_day": true, "patch_ids": ["2ba9a4b7c4ee7927fd90c84d2f4a9f19"], "statement_hash": "fab9e03189f5d0663ef17e90457644cd321e734ecc54c35abcee773819afdb55"}, "url": "/docs/compare/?release=10.7#10.7-e9d1bb9a64ebef49", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "94cef92c80be30a48888bcd91173fd61", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Allow UNLISTEN in hot-standby mode", "evidence": {"same_day": true, "patch_ids": ["2ba9a4b7c4ee7927fd90c84d2f4a9f19"], "statement_hash": "fab9e03189f5d0663ef17e90457644cd321e734ecc54c35abcee773819afdb55"}, "url": "/docs/compare/?release=9.6.12#9.6.12-e9d1bb9a64ebef49", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "6625060b7927b8eafc9245abfea8044c", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Allow UNLISTEN in hot-standby mode", "evidence": {"same_day": true, "patch_ids": ["2ba9a4b7c4ee7927fd90c84d2f4a9f19"], "statement_hash": "fab9e03189f5d0663ef17e90457644cd321e734ecc54c35abcee773819afdb55"}, "url": "/docs/compare/?release=9.4.21#9.4.21-e9d1bb9a64ebef49", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-2c8127f4c706b63f", "cves": [], "html": "Fix missing role dependencies in some schema and data type permissions lists (Tom Lane)
\nIn some cases it was possible to drop a role to which permissions had been granted. This caused no immediate problem, but a subsequent dump/reload or upgrade would fail, with symptoms involving attempts to grant privileges to all-numeric role names.
", "text": "Fix missing role dependencies in some schema and data type permissions lists (Tom Lane) In some cases it was possible to drop a role to which permissions had been granted. This caused no immediate problem, but a subsequent dump/reload or upgrade would fail, with symptoms involving attempts to grant privileges to all-numeric role names.", "title": "Fix missing role dependencies in some schema and data type permissions lists", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "14c30d6b1c3223bd20a46e90d3ce35fe4a7fe9a889b2dd2b10b0eec47ca6284c", "section_path": ["Changes"], "commit_groups": [["1b55acb2c", "277602dfe", "2d83863ea", "47088c599", "d431dff1a", "fa2952d8e"]], "identity_text": "Fix missing role dependencies in some schema and data type permissions lists (Tom Lane) In some cases it was possible to drop a role to which permissions had been granted. This caused no immediate problem, but a subsequent dump/reload or upgrade would fail, with symptoms involving attempts to grant privileges to all-numeric role names.", "commit_aliases": ["1b55acb2c", "277602dfe", "2d83863ea", "47088c599", "d431dff1a", "fa2952d8e"], "source_commits": ["47088c599"], "source_entry_id": "9.5.16/changes/021", "db_id": "1f9dbe8d83e50c9dfbb8a4a84ac9cf3c", "patch_ids": ["5ac55c03b44ba05b76a8d540ef004213"], "statement_hash": "982275dc540653641963ac36ffa17bd21b9593ff3ec13e97427705b369dba8ac", "relations": [{"rule": 2, "type": "equivalent", "target": "41a2c2a31ea2bddf0ea59232dc00f373", "evidence": {"same_day": true, "patch_ids": ["5ac55c03b44ba05b76a8d540ef004213"], "statement_hash": "982275dc540653641963ac36ffa17bd21b9593ff3ec13e97427705b369dba8ac"}}, {"rule": 2, "type": "equivalent", "target": "4c08124dc69c204f4ca81d42af9564a8", "evidence": {"same_day": true, "patch_ids": ["5ac55c03b44ba05b76a8d540ef004213"], "statement_hash": "982275dc540653641963ac36ffa17bd21b9593ff3ec13e97427705b369dba8ac"}}, {"rule": 2, "type": "equivalent", "target": "4eda5d9ab12a7448ef8e5446fd8c876b", "evidence": {"same_day": true, "patch_ids": ["5ac55c03b44ba05b76a8d540ef004213"], "statement_hash": "982275dc540653641963ac36ffa17bd21b9593ff3ec13e97427705b369dba8ac"}}, {"rule": 2, "type": "equivalent", "target": "f3a1e2db616132bd97c4a5cbf0c40e7d", "evidence": {"same_day": true, "patch_ids": ["5ac55c03b44ba05b76a8d540ef004213"], "statement_hash": "982275dc540653641963ac36ffa17bd21b9593ff3ec13e97427705b369dba8ac"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4c08124dc69c204f4ca81d42af9564a8", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Fix missing role dependencies in some schema and data type permissions lists", "evidence": {"same_day": true, "patch_ids": ["5ac55c03b44ba05b76a8d540ef004213"], "statement_hash": "982275dc540653641963ac36ffa17bd21b9593ff3ec13e97427705b369dba8ac"}, "url": "/docs/compare/?release=11.2#11.2-2c8127f4c706b63f", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "f3a1e2db616132bd97c4a5cbf0c40e7d", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Fix missing role dependencies in some schema and data type permissions lists", "evidence": {"same_day": true, "patch_ids": ["5ac55c03b44ba05b76a8d540ef004213"], "statement_hash": "982275dc540653641963ac36ffa17bd21b9593ff3ec13e97427705b369dba8ac"}, "url": "/docs/compare/?release=10.7#10.7-2c8127f4c706b63f", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "41a2c2a31ea2bddf0ea59232dc00f373", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Fix missing role dependencies in some schema and data type permissions lists", "evidence": {"same_day": true, "patch_ids": ["5ac55c03b44ba05b76a8d540ef004213"], "statement_hash": "982275dc540653641963ac36ffa17bd21b9593ff3ec13e97427705b369dba8ac"}, "url": "/docs/compare/?release=9.6.12#9.6.12-2c8127f4c706b63f", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "4eda5d9ab12a7448ef8e5446fd8c876b", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Fix missing role dependencies in some schema and data type permissions lists", "evidence": {"same_day": true, "patch_ids": ["5ac55c03b44ba05b76a8d540ef004213"], "statement_hash": "982275dc540653641963ac36ffa17bd21b9593ff3ec13e97427705b369dba8ac"}, "url": "/docs/compare/?release=9.4.21#9.4.21-2c8127f4c706b63f", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-dbd56677262ebe1b", "cves": [], "html": "Ensure relation caches are updated properly after renaming constraints (Amit Langote)
", "text": "Ensure relation caches are updated properly after renaming constraints (Amit Langote)", "title": "Ensure relation caches are updated properly after renaming constraints", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "5e42bf51399ea051aa38151bc0b3b244289a3e7f2214d8f33e5f8db73c357746", "section_path": ["Changes"], "commit_groups": [["25b8094d3", "5812be7b6", "b13fd344c", "d5d86e2cd", "d79cd555d", "da13d90a5"], ["419bd6371", "67915fb8e", "696c68c2b", "91fc2a088", "c7567e09d", "e83e0988d"]], "identity_text": "Ensure relation caches are updated properly after renaming constraints (Amit Langote)", "commit_aliases": ["25b8094d3", "419bd6371", "5812be7b6", "67915fb8e", "696c68c2b", "91fc2a088", "b13fd344c", "c7567e09d", "d5d86e2cd", "d79cd555d", "da13d90a5", "e83e0988d"], "source_commits": ["5812be7b6", "c7567e09d"], "source_entry_id": "9.5.16/changes/022", "db_id": "af9014d4600b1600abbfdce2728a3606", "patch_ids": ["7935b6f19f2fafdf66a2920f71fb4433", "c5b90155b42004f82cd49beca064ac22"], "statement_hash": "d7ae29c47b4519923e1534ecb7ceb8cfb548cebcf38d4650ad194e41161a23ea", "relations": [{"rule": 2, "type": "equivalent", "target": "8ae7a2b7e62bf1b39ef2e189d295ef75", "evidence": {"same_day": true, "patch_ids": ["7935b6f19f2fafdf66a2920f71fb4433", "c5b90155b42004f82cd49beca064ac22"], "statement_hash": "d7ae29c47b4519923e1534ecb7ceb8cfb548cebcf38d4650ad194e41161a23ea"}}, {"rule": 2, "type": "equivalent", "target": "9177ddb98c6a588683d9d46ee0f12f8b", "evidence": {"same_day": true, "patch_ids": ["7935b6f19f2fafdf66a2920f71fb4433", "c5b90155b42004f82cd49beca064ac22"], "statement_hash": "d7ae29c47b4519923e1534ecb7ceb8cfb548cebcf38d4650ad194e41161a23ea"}}, {"rule": 2, "type": "equivalent", "target": "b092e5abaaa4e2a09d95b524be4dcf6a", "evidence": {"same_day": true, "patch_ids": ["7935b6f19f2fafdf66a2920f71fb4433", "c5b90155b42004f82cd49beca064ac22"], "statement_hash": "d7ae29c47b4519923e1534ecb7ceb8cfb548cebcf38d4650ad194e41161a23ea"}}, {"rule": 2, "type": "equivalent", "target": "ea437fbace73394111d185889a2c5941", "evidence": {"same_day": true, "patch_ids": ["7935b6f19f2fafdf66a2920f71fb4433", "c5b90155b42004f82cd49beca064ac22"], "statement_hash": "d7ae29c47b4519923e1534ecb7ceb8cfb548cebcf38d4650ad194e41161a23ea"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "8ae7a2b7e62bf1b39ef2e189d295ef75", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Ensure relation caches are updated properly after renaming constraints", "evidence": {"same_day": true, "patch_ids": ["7935b6f19f2fafdf66a2920f71fb4433", "c5b90155b42004f82cd49beca064ac22"], "statement_hash": "d7ae29c47b4519923e1534ecb7ceb8cfb548cebcf38d4650ad194e41161a23ea"}, "url": "/docs/compare/?release=11.2#11.2-dbd56677262ebe1b", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "ea437fbace73394111d185889a2c5941", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Ensure relation caches are updated properly after renaming constraints", "evidence": {"same_day": true, "patch_ids": ["7935b6f19f2fafdf66a2920f71fb4433", "c5b90155b42004f82cd49beca064ac22"], "statement_hash": "d7ae29c47b4519923e1534ecb7ceb8cfb548cebcf38d4650ad194e41161a23ea"}, "url": "/docs/compare/?release=10.7#10.7-dbd56677262ebe1b", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "9177ddb98c6a588683d9d46ee0f12f8b", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Ensure relation caches are updated properly after renaming constraints", "evidence": {"same_day": true, "patch_ids": ["7935b6f19f2fafdf66a2920f71fb4433", "c5b90155b42004f82cd49beca064ac22"], "statement_hash": "d7ae29c47b4519923e1534ecb7ceb8cfb548cebcf38d4650ad194e41161a23ea"}, "url": "/docs/compare/?release=9.6.12#9.6.12-dbd56677262ebe1b", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "b092e5abaaa4e2a09d95b524be4dcf6a", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Ensure relation caches are updated properly after renaming constraints", "evidence": {"same_day": true, "patch_ids": ["7935b6f19f2fafdf66a2920f71fb4433", "c5b90155b42004f82cd49beca064ac22"], "statement_hash": "d7ae29c47b4519923e1534ecb7ceb8cfb548cebcf38d4650ad194e41161a23ea"}, "url": "/docs/compare/?release=9.4.21#9.4.21-dbd56677262ebe1b", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-3dba4c345dca6a5c", "cves": [], "html": "Make autovacuum more aggressive about removing leftover temporary tables, and also remove leftover temporary tables during DISCARD TEMP (Álvaro Herrera)
\nThis helps ensure that remnants from a crashed session are cleaned up more promptly.
", "text": "Make autovacuum more aggressive about removing leftover temporary tables, and also remove leftover temporary tables during DISCARD TEMP (Álvaro Herrera) This helps ensure that remnants from a crashed session are cleaned up more promptly.", "title": "Make autovacuum more aggressive about removing leftover temporary tables, and also remove leftover temporary tables during DISCARD TEMP", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "8f26a05930277b7cbd2ce4134407188d8ec7f3178c3534dc27ed97b0e5638a4c", "section_path": ["Changes"], "commit_groups": [["2602838fa", "3c4ca2109", "aa2e84d2c", "b7258a30a"], ["5199abaca", "7fc2363a6", "a6ca47cd2", "a85045ccc"]], "identity_text": "Make autovacuum more aggressive about removing leftover temporary tables, and also remove leftover temporary tables during DISCARD TEMP (Álvaro Herrera) This helps ensure that remnants from a crashed session are cleaned up more promptly.", "commit_aliases": ["2602838fa", "3c4ca2109", "5199abaca", "7fc2363a6", "a6ca47cd2", "a85045ccc", "aa2e84d2c", "b7258a30a"], "source_commits": ["a85045ccc", "b7258a30a"], "source_entry_id": "9.5.16/changes/023", "db_id": "05ef076011bdfb0351d7a612d523f872", "patch_ids": ["455619fed1294a8366e80fef6d18238d", "68bb75b8f35bfc70496671d38a09f9e6"], "statement_hash": "1fb426492ae09d2a8ff21ddf8a115c37390e99ec874d4dc94156d74a5246372f", "relations": [{"rule": 2, "type": "equivalent", "target": "40eaccd78b6f81b22d8851702823f7aa", "evidence": {"same_day": true, "patch_ids": ["455619fed1294a8366e80fef6d18238d", "68bb75b8f35bfc70496671d38a09f9e6"], "statement_hash": "1fb426492ae09d2a8ff21ddf8a115c37390e99ec874d4dc94156d74a5246372f"}}, {"rule": 2, "type": "equivalent", "target": "9de8f5cc1ca5851f7e58bbc5ae8dd71d", "evidence": {"same_day": true, "patch_ids": ["455619fed1294a8366e80fef6d18238d", "68bb75b8f35bfc70496671d38a09f9e6"], "statement_hash": "1fb426492ae09d2a8ff21ddf8a115c37390e99ec874d4dc94156d74a5246372f"}}, {"rule": 2, "type": "equivalent", "target": "df3a9825a1e11da00e756da6cd5ab7b8", "evidence": {"same_day": true, "patch_ids": ["455619fed1294a8366e80fef6d18238d", "68bb75b8f35bfc70496671d38a09f9e6"], "statement_hash": "1fb426492ae09d2a8ff21ddf8a115c37390e99ec874d4dc94156d74a5246372f"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "df3a9825a1e11da00e756da6cd5ab7b8", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Make autovacuum more aggressive about removing leftover temporary tables, and also remove leftover temporary tables during DISCARD TEMP", "evidence": {"same_day": true, "patch_ids": ["455619fed1294a8366e80fef6d18238d", "68bb75b8f35bfc70496671d38a09f9e6"], "statement_hash": "1fb426492ae09d2a8ff21ddf8a115c37390e99ec874d4dc94156d74a5246372f"}, "url": "/docs/compare/?release=10.7#10.7-3dba4c345dca6a5c", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "9de8f5cc1ca5851f7e58bbc5ae8dd71d", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Make autovacuum more aggressive about removing leftover temporary tables, and also remove leftover temporary tables during DISCARD TEMP", "evidence": {"same_day": true, "patch_ids": ["455619fed1294a8366e80fef6d18238d", "68bb75b8f35bfc70496671d38a09f9e6"], "statement_hash": "1fb426492ae09d2a8ff21ddf8a115c37390e99ec874d4dc94156d74a5246372f"}, "url": "/docs/compare/?release=9.6.12#9.6.12-3dba4c345dca6a5c", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "40eaccd78b6f81b22d8851702823f7aa", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Make autovacuum more aggressive about removing leftover temporary tables, and also remove leftover temporary tables during DISCARD TEMP", "evidence": {"same_day": true, "patch_ids": ["455619fed1294a8366e80fef6d18238d", "68bb75b8f35bfc70496671d38a09f9e6"], "statement_hash": "1fb426492ae09d2a8ff21ddf8a115c37390e99ec874d4dc94156d74a5246372f"}, "url": "/docs/compare/?release=9.4.21#9.4.21-3dba4c345dca6a5c", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-8c1229fab9e3bfa2", "cves": [], "html": "Prevent empty GIN index pages from being reclaimed too quickly, causing failures of concurrent searches (Andrey Borodin, Alexander Korotkov)
", "text": "Prevent empty GIN index pages from being reclaimed too quickly, causing failures of concurrent searches (Andrey Borodin, Alexander Korotkov)", "title": "Prevent empty GIN index pages from being reclaimed too quickly, causing failures of concurrent searches", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "8ddbfce89baacc0720052e2b2597e09a1346df0e4a2c1b5de43c0294f5751a90", "section_path": ["Changes"], "commit_groups": [["1cf175c74", "52ac6cd2d", "a0696d295", "ad6ebcfcb", "cd24b4eae", "dd951dc34"]], "identity_text": "Prevent empty GIN index pages from being reclaimed too quickly, causing failures of concurrent searches (Andrey Borodin, Alexander Korotkov)", "commit_aliases": ["1cf175c74", "52ac6cd2d", "a0696d295", "ad6ebcfcb", "cd24b4eae", "dd951dc34"], "source_commits": ["ad6ebcfcb"], "source_entry_id": "9.5.16/changes/024", "db_id": "3b43bca06e3d86d77965231396d53731", "patch_ids": ["176f89fff105e5b2fb146ac5afff4bea"], "statement_hash": "b7681bb53c5466ddf4658caa76606878d987b0c82da15b58354e7021e3bf06bc", "relations": [{"rule": 2, "type": "equivalent", "target": "c67eaad49f3b340ee599e655c5022f9c", "evidence": {"same_day": true, "patch_ids": ["176f89fff105e5b2fb146ac5afff4bea"], "statement_hash": "b7681bb53c5466ddf4658caa76606878d987b0c82da15b58354e7021e3bf06bc"}}, {"rule": 2, "type": "equivalent", "target": "e4e38acaedb25796b89997c3ca1e52ee", "evidence": {"same_day": true, "patch_ids": ["176f89fff105e5b2fb146ac5afff4bea"], "statement_hash": "b7681bb53c5466ddf4658caa76606878d987b0c82da15b58354e7021e3bf06bc"}}, {"rule": 2, "type": "equivalent", "target": "e9ee59ea363bbacadc9b0ff06e603540", "evidence": {"same_day": true, "patch_ids": ["176f89fff105e5b2fb146ac5afff4bea"], "statement_hash": "b7681bb53c5466ddf4658caa76606878d987b0c82da15b58354e7021e3bf06bc"}}, {"rule": 2, "type": "equivalent", "target": "fa9d017f7b5fe28f0e3b15789d1f24f7", "evidence": {"same_day": true, "patch_ids": ["176f89fff105e5b2fb146ac5afff4bea"], "statement_hash": "b7681bb53c5466ddf4658caa76606878d987b0c82da15b58354e7021e3bf06bc"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "fa9d017f7b5fe28f0e3b15789d1f24f7", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Prevent empty GIN index pages from being reclaimed too quickly, causing failures of concurrent searches", "evidence": {"same_day": true, "patch_ids": ["176f89fff105e5b2fb146ac5afff4bea"], "statement_hash": "b7681bb53c5466ddf4658caa76606878d987b0c82da15b58354e7021e3bf06bc"}, "url": "/docs/compare/?release=11.2#11.2-8c1229fab9e3bfa2", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "c67eaad49f3b340ee599e655c5022f9c", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Prevent empty GIN index pages from being reclaimed too quickly, causing failures of concurrent searches", "evidence": {"same_day": true, "patch_ids": ["176f89fff105e5b2fb146ac5afff4bea"], "statement_hash": "b7681bb53c5466ddf4658caa76606878d987b0c82da15b58354e7021e3bf06bc"}, "url": "/docs/compare/?release=10.7#10.7-8c1229fab9e3bfa2", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "e9ee59ea363bbacadc9b0ff06e603540", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Prevent empty GIN index pages from being reclaimed too quickly, causing failures of concurrent searches", "evidence": {"same_day": true, "patch_ids": ["176f89fff105e5b2fb146ac5afff4bea"], "statement_hash": "b7681bb53c5466ddf4658caa76606878d987b0c82da15b58354e7021e3bf06bc"}, "url": "/docs/compare/?release=9.6.12#9.6.12-8c1229fab9e3bfa2", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "e4e38acaedb25796b89997c3ca1e52ee", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Prevent empty GIN index pages from being reclaimed too quickly, causing failures of concurrent searches", "evidence": {"same_day": true, "patch_ids": ["176f89fff105e5b2fb146ac5afff4bea"], "statement_hash": "b7681bb53c5466ddf4658caa76606878d987b0c82da15b58354e7021e3bf06bc"}, "url": "/docs/compare/?release=9.4.21#9.4.21-8c1229fab9e3bfa2", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-9fdc117d5393aef9", "cves": [], "html": "Fix edge-case failures in float-to-integer coercions (Andrew Gierth, Tom Lane)
\nValues very slightly above the maximum valid integer value might not be rejected, and then would overflow, producing the minimum valid integer instead. Also, values that should round to the minimum or maximum integer value might be incorrectly rejected.
", "text": "Fix edge-case failures in float-to-integer coercions (Andrew Gierth, Tom Lane) Values very slightly above the maximum valid integer value might not be rejected, and then would overflow, producing the minimum valid integer instead. Also, values that should round to the minimum or maximum integer value might be incorrectly rejected.", "title": "Fix edge-case failures in float-to-integer coercions", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "3b74196a392cc448f3622f909708f5cc10e7dc805359d1aca611a80b948820c3", "section_path": ["Changes"], "commit_groups": [["1e78603a5", "452b637d4", "93eec1238", "c382a2b66", "d5231253e", "e473e1f2b"], ["1f99d0867", "298510cae", "3645d3193", "745871483", "bf9fb00dd"], ["cbdb8b4c0"]], "identity_text": "Fix edge-case failures in float-to-integer coercions (Andrew Gierth, Tom Lane) Values very slightly above the maximum valid integer value might not be rejected, and then would overflow, producing the minimum valid integer instead. Also, values that should round to the minimum or maximum integer value might be incorrectly rejected.", "commit_aliases": ["1e78603a5", "1f99d0867", "298510cae", "3645d3193", "452b637d4", "745871483", "93eec1238", "bf9fb00dd", "c382a2b66", "cbdb8b4c0", "d5231253e", "e473e1f2b"], "source_commits": ["1e78603a5", "298510cae", "cbdb8b4c0"], "source_entry_id": "9.5.16/changes/025", "db_id": "a8bc9a54d333b9c766b9cdd860ad0c9f", "patch_ids": ["2b7d199aea91cf666d8d1637425eeac9", "c7d5b25589c9e08d303a9743dcfebbb0", "e2b707cdc8d37ec8590791fd287e35d6"], "statement_hash": "892523caf934df8ab44c92ca64867536471202af374bae37e9065d5696806d8a", "relations": [{"rule": 2, "type": "equivalent", "target": "1ef0cef16e8053402d0790f6a3ac03aa", "evidence": {"same_day": true, "patch_ids": ["2b7d199aea91cf666d8d1637425eeac9", "c7d5b25589c9e08d303a9743dcfebbb0", "e2b707cdc8d37ec8590791fd287e35d6"], "statement_hash": "892523caf934df8ab44c92ca64867536471202af374bae37e9065d5696806d8a"}}, {"rule": 2, "type": "equivalent", "target": "81a2ae019c7c1966d10fc81a4d3110d8", "evidence": {"same_day": true, "patch_ids": ["2b7d199aea91cf666d8d1637425eeac9", "c7d5b25589c9e08d303a9743dcfebbb0", "e2b707cdc8d37ec8590791fd287e35d6"], "statement_hash": "892523caf934df8ab44c92ca64867536471202af374bae37e9065d5696806d8a"}}, {"rule": 2, "type": "equivalent", "target": "b50067b48d850e56dbdaf39760cde494", "evidence": {"same_day": true, "patch_ids": ["2b7d199aea91cf666d8d1637425eeac9", "c7d5b25589c9e08d303a9743dcfebbb0", "e2b707cdc8d37ec8590791fd287e35d6"], "statement_hash": "892523caf934df8ab44c92ca64867536471202af374bae37e9065d5696806d8a"}}, {"rule": 2, "type": "equivalent", "target": "bd715bf807d1e5defdffedec1ff0887b", "evidence": {"same_day": true, "patch_ids": ["2b7d199aea91cf666d8d1637425eeac9", "c7d5b25589c9e08d303a9743dcfebbb0", "e2b707cdc8d37ec8590791fd287e35d6"], "statement_hash": "892523caf934df8ab44c92ca64867536471202af374bae37e9065d5696806d8a"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "bd715bf807d1e5defdffedec1ff0887b", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Fix edge-case failures in float-to-integer coercions", "evidence": {"same_day": true, "patch_ids": ["2b7d199aea91cf666d8d1637425eeac9", "c7d5b25589c9e08d303a9743dcfebbb0", "e2b707cdc8d37ec8590791fd287e35d6"], "statement_hash": "892523caf934df8ab44c92ca64867536471202af374bae37e9065d5696806d8a"}, "url": "/docs/compare/?release=11.2#11.2-9fdc117d5393aef9", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "81a2ae019c7c1966d10fc81a4d3110d8", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Fix edge-case failures in float-to-integer coercions", "evidence": {"same_day": true, "patch_ids": ["2b7d199aea91cf666d8d1637425eeac9", "c7d5b25589c9e08d303a9743dcfebbb0", "e2b707cdc8d37ec8590791fd287e35d6"], "statement_hash": "892523caf934df8ab44c92ca64867536471202af374bae37e9065d5696806d8a"}, "url": "/docs/compare/?release=10.7#10.7-9fdc117d5393aef9", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "b50067b48d850e56dbdaf39760cde494", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Fix edge-case failures in float-to-integer coercions", "evidence": {"same_day": true, "patch_ids": ["2b7d199aea91cf666d8d1637425eeac9", "c7d5b25589c9e08d303a9743dcfebbb0", "e2b707cdc8d37ec8590791fd287e35d6"], "statement_hash": "892523caf934df8ab44c92ca64867536471202af374bae37e9065d5696806d8a"}, "url": "/docs/compare/?release=9.6.12#9.6.12-9fdc117d5393aef9", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "1ef0cef16e8053402d0790f6a3ac03aa", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Fix edge-case failures in float-to-integer coercions", "evidence": {"same_day": true, "patch_ids": ["2b7d199aea91cf666d8d1637425eeac9", "c7d5b25589c9e08d303a9743dcfebbb0", "e2b707cdc8d37ec8590791fd287e35d6"], "statement_hash": "892523caf934df8ab44c92ca64867536471202af374bae37e9065d5696806d8a"}, "url": "/docs/compare/?release=9.4.21#9.4.21-9fdc117d5393aef9", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-a849ddac810905c5", "cves": [], "html": "Disallow setting client_min_messages higher than ERROR (Jonah Harris, Tom Lane)
\nPreviously, it was possible to set this variable to FATAL or PANIC, which had the effect of suppressing transmission of ordinary error messages to the client. However, that's contrary to guarantees that are given in the PostgreSQL wire protocol specification, and it caused some clients to become very confused. In released branches, fix this by silently treating such settings as meaning ERROR instead. Version 12 and later will reject those alternatives altogether.
", "text": "Disallow setting client_min_messages higher than ERROR (Jonah Harris, Tom Lane) Previously, it was possible to set this variable to FATAL or PANIC, which had the effect of suppressing transmission of ordinary error messages to the client. However, that's contrary to guarantees that are given in the PostgreSQL wire protocol specification, and it caused some clients to become very confused. In released branches, fix this by silently treating such settings as meaning ERROR instead. Version 12 and later will reject those alternatives altogether.", "title": "Disallow setting client_min_messages higher than ERROR", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "6283b795fee8aa1a027a5e75e714ac86c0a2ff31d484fbef381c73d96ae75509", "section_path": ["Changes"], "commit_groups": [["041ad9a66", "2407d4807", "3d360e20c", "7b08b4a8a", "88275ac19", "c09daa910"]], "identity_text": "Disallow setting client_min_messages higher than ERROR (Jonah Harris, Tom Lane) Previously, it was possible to set this variable to FATAL or PANIC, which had the effect of suppressing transmission of ordinary error messages to the client. However, that's contrary to guarantees that are given in the PostgreSQL wire protocol specification, and it caused some clients to become very confused. In released branches, fix this by silently treating such settings as meaning ERROR instead. Version 12 and later will reject those alternatives altogether.", "commit_aliases": ["041ad9a66", "2407d4807", "3d360e20c", "7b08b4a8a", "88275ac19", "c09daa910"], "source_commits": ["88275ac19"], "source_entry_id": "9.5.16/changes/026", "db_id": "576a15adacf237a3eea4307a28cac774", "patch_ids": ["9a86cb436a2089c18bd5a31ec45c903e"], "statement_hash": "6ff305814c145e16d87d251b327ccae28792a746d8eb5bac329573c5a8792f73", "relations": [{"rule": 2, "type": "equivalent", "target": "00afac51149d596e81beb96b7961f8ac", "evidence": {"same_day": true, "patch_ids": ["9a86cb436a2089c18bd5a31ec45c903e"], "statement_hash": "6ff305814c145e16d87d251b327ccae28792a746d8eb5bac329573c5a8792f73"}}, {"rule": 2, "type": "equivalent", "target": "58f9c63185a21e00c0eb32062d09e85b", "evidence": {"same_day": true, "patch_ids": ["9a86cb436a2089c18bd5a31ec45c903e"], "statement_hash": "6ff305814c145e16d87d251b327ccae28792a746d8eb5bac329573c5a8792f73"}}, {"rule": 2, "type": "equivalent", "target": "d27351c52e3bcf245b344371ca961ac0", "evidence": {"same_day": true, "patch_ids": ["9a86cb436a2089c18bd5a31ec45c903e"], "statement_hash": "6ff305814c145e16d87d251b327ccae28792a746d8eb5bac329573c5a8792f73"}}, {"rule": 2, "type": "equivalent", "target": "e48d0ef4451aa657e2263bc107d75299", "evidence": {"same_day": true, "patch_ids": ["9a86cb436a2089c18bd5a31ec45c903e"], "statement_hash": "6ff305814c145e16d87d251b327ccae28792a746d8eb5bac329573c5a8792f73"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "58f9c63185a21e00c0eb32062d09e85b", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Disallow setting client_min_messages higher than ERROR", "evidence": {"same_day": true, "patch_ids": ["9a86cb436a2089c18bd5a31ec45c903e"], "statement_hash": "6ff305814c145e16d87d251b327ccae28792a746d8eb5bac329573c5a8792f73"}, "url": "/docs/compare/?release=11.2#11.2-a849ddac810905c5", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "00afac51149d596e81beb96b7961f8ac", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Disallow setting client_min_messages higher than ERROR", "evidence": {"same_day": true, "patch_ids": ["9a86cb436a2089c18bd5a31ec45c903e"], "statement_hash": "6ff305814c145e16d87d251b327ccae28792a746d8eb5bac329573c5a8792f73"}, "url": "/docs/compare/?release=10.7#10.7-a849ddac810905c5", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "e48d0ef4451aa657e2263bc107d75299", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Disallow setting client_min_messages higher than ERROR", "evidence": {"same_day": true, "patch_ids": ["9a86cb436a2089c18bd5a31ec45c903e"], "statement_hash": "6ff305814c145e16d87d251b327ccae28792a746d8eb5bac329573c5a8792f73"}, "url": "/docs/compare/?release=9.6.12#9.6.12-a849ddac810905c5", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "d27351c52e3bcf245b344371ca961ac0", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Disallow setting client_min_messages higher than ERROR", "evidence": {"same_day": true, "patch_ids": ["9a86cb436a2089c18bd5a31ec45c903e"], "statement_hash": "6ff305814c145e16d87d251b327ccae28792a746d8eb5bac329573c5a8792f73"}, "url": "/docs/compare/?release=9.4.21#9.4.21-a849ddac810905c5", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-428533034e41760c", "cves": [], "html": "Fix ecpglib to use uselocale() or _configthreadlocale() in preference to setlocale() (Michael Meskes, Tom Lane)
Since setlocale() is not thread-local, and might not even be thread-safe, the previous coding caused problems in multi-threaded ecpg applications.
Fix incorrect results for numeric data passed through an ecpg SQLDA (SQL Descriptor Area) (Daisuke Higuchi)
\nValues with leading zeroes were not copied correctly.
", "text": "Fix incorrect results for numeric data passed through an ecpg SQLDA (SQL Descriptor Area) (Daisuke Higuchi) Values with leading zeroes were not copied correctly.", "title": "Fix incorrect results for numeric data passed through an ecpg SQLDA (SQL Descriptor Area)", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "aba1bd79306e14b0532491247b8d57a6e1deb69d9b192a7e292b7420e9888942", "section_path": ["Changes"], "commit_groups": [["06c723447", "2e8ed4659", "41609776f", "4618fdd67", "68f30638a", "f9e25ba14"], ["32060f678", "68393f3fd", "9e5e3861c", "be38945c6", "e1f259012", "ecfd55795"]], "identity_text": "Fix incorrect results for numeric data passed through an ecpg SQLDA (SQL Descriptor Area) (Daisuke Higuchi) Values with leading zeroes were not copied correctly.", "commit_aliases": ["06c723447", "2e8ed4659", "32060f678", "41609776f", "4618fdd67", "68393f3fd", "68f30638a", "9e5e3861c", "be38945c6", "e1f259012", "ecfd55795", "f9e25ba14"], "source_commits": ["68f30638a", "be38945c6"], "source_entry_id": "9.5.16/changes/028", "db_id": "d9a5d1d2e05d9ec248430f8e7952bd18", "patch_ids": ["3e2ed163afd32784067e11ef1d92585f", "d368ed5b1a0dbe4032c0bb31b6671f10"], "statement_hash": "d0a89e5e9f09f214e6300b13c4222fefbca457a005efe79f12366b4a5f55f797", "relations": [{"rule": 2, "type": "equivalent", "target": "01d435523e7c790e12b2b8dfcc84cbf6", "evidence": {"same_day": true, "patch_ids": ["3e2ed163afd32784067e11ef1d92585f", "d368ed5b1a0dbe4032c0bb31b6671f10"], "statement_hash": "d0a89e5e9f09f214e6300b13c4222fefbca457a005efe79f12366b4a5f55f797"}}, {"rule": 2, "type": "equivalent", "target": "0c9f1340d6467102413c6d9b3b8feb42", "evidence": {"same_day": true, "patch_ids": ["3e2ed163afd32784067e11ef1d92585f", "d368ed5b1a0dbe4032c0bb31b6671f10"], "statement_hash": "d0a89e5e9f09f214e6300b13c4222fefbca457a005efe79f12366b4a5f55f797"}}, {"rule": 2, "type": "equivalent", "target": "b1c1d33dbed698c77a751b8f391cc2d1", "evidence": {"same_day": true, "patch_ids": ["3e2ed163afd32784067e11ef1d92585f", "d368ed5b1a0dbe4032c0bb31b6671f10"], "statement_hash": "d0a89e5e9f09f214e6300b13c4222fefbca457a005efe79f12366b4a5f55f797"}}, {"rule": 2, "type": "equivalent", "target": "d5e68bd908a05fdb6610828b56036d0d", "evidence": {"same_day": true, "patch_ids": ["3e2ed163afd32784067e11ef1d92585f", "d368ed5b1a0dbe4032c0bb31b6671f10"], "statement_hash": "d0a89e5e9f09f214e6300b13c4222fefbca457a005efe79f12366b4a5f55f797"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "0c9f1340d6467102413c6d9b3b8feb42", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Fix incorrect results for numeric data passed through an ecpg SQLDA (SQL Descriptor Area)", "evidence": {"same_day": true, "patch_ids": ["3e2ed163afd32784067e11ef1d92585f", "d368ed5b1a0dbe4032c0bb31b6671f10"], "statement_hash": "d0a89e5e9f09f214e6300b13c4222fefbca457a005efe79f12366b4a5f55f797"}, "url": "/docs/compare/?release=11.2#11.2-bff5b727f5e0c2c8", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "01d435523e7c790e12b2b8dfcc84cbf6", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Fix incorrect results for numeric data passed through an ecpg SQLDA (SQL Descriptor Area)", "evidence": {"same_day": true, "patch_ids": ["3e2ed163afd32784067e11ef1d92585f", "d368ed5b1a0dbe4032c0bb31b6671f10"], "statement_hash": "d0a89e5e9f09f214e6300b13c4222fefbca457a005efe79f12366b4a5f55f797"}, "url": "/docs/compare/?release=10.7#10.7-bff5b727f5e0c2c8", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "d5e68bd908a05fdb6610828b56036d0d", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Fix incorrect results for numeric data passed through an ecpg SQLDA (SQL Descriptor Area)", "evidence": {"same_day": true, "patch_ids": ["3e2ed163afd32784067e11ef1d92585f", "d368ed5b1a0dbe4032c0bb31b6671f10"], "statement_hash": "d0a89e5e9f09f214e6300b13c4222fefbca457a005efe79f12366b4a5f55f797"}, "url": "/docs/compare/?release=9.6.12#9.6.12-bff5b727f5e0c2c8", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "b1c1d33dbed698c77a751b8f391cc2d1", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Fix incorrect results for numeric data passed through an ecpg SQLDA (SQL Descriptor Area)", "evidence": {"same_day": true, "patch_ids": ["3e2ed163afd32784067e11ef1d92585f", "d368ed5b1a0dbe4032c0bb31b6671f10"], "statement_hash": "d0a89e5e9f09f214e6300b13c4222fefbca457a005efe79f12366b4a5f55f797"}, "url": "/docs/compare/?release=9.4.21#9.4.21-bff5b727f5e0c2c8", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-50cf03c981ebd665", "cves": [], "html": "Fix psql's \\g target meta-command to work with COPY TO STDOUT (Daniel Vérité)
\nPreviously, the target option was ignored, so that the copy data always went to the current query output target.
", "text": "Fix psql's \\g target meta-command to work with COPY TO STDOUT (Daniel Vérité) Previously, the target option was ignored, so that the copy data always went to the current query output target.", "title": "Fix psql's \\g target meta-command to work with COPY TO STDOUT", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "a371dcc7a0cf6388942f93044121f9509c8a48e4b32620f14523f28997e656c0", "section_path": ["Changes"], "commit_groups": [["2c50c9f23", "6d3ede5f1", "8e97a97b3", "ae4c7d5ab", "cda1e27fb"]], "identity_text": "Fix psql's \\g target meta-command to work with COPY TO STDOUT (Daniel Vérité) Previously, the target option was ignored, so that the copy data always went to the current query output target.", "commit_aliases": ["2c50c9f23", "6d3ede5f1", "8e97a97b3", "ae4c7d5ab", "cda1e27fb"], "source_commits": ["cda1e27fb"], "source_entry_id": "9.5.16/changes/029", "db_id": "84ef57936d4146c8a22f07fe791247be", "patch_ids": ["4c91209bf8d5d37142ccb5063814974e"], "statement_hash": "e7de5484878ce1791f25c1ff0718dd1d00c9e303b54d2186762352b724021130", "relations": [{"rule": 2, "type": "equivalent", "target": "7187c1ff9b64631a183928e454518eaf", "evidence": {"same_day": true, "patch_ids": ["4c91209bf8d5d37142ccb5063814974e"], "statement_hash": "e7de5484878ce1791f25c1ff0718dd1d00c9e303b54d2186762352b724021130"}}, {"rule": 2, "type": "equivalent", "target": "86760c4c16f03e7ced0f7f5cec09a558", "evidence": {"same_day": true, "patch_ids": ["4c91209bf8d5d37142ccb5063814974e"], "statement_hash": "e7de5484878ce1791f25c1ff0718dd1d00c9e303b54d2186762352b724021130"}}, {"rule": 2, "type": "equivalent", "target": "c618564ee9c72ab927a920643066d530", "evidence": {"same_day": true, "patch_ids": ["4c91209bf8d5d37142ccb5063814974e"], "statement_hash": "e7de5484878ce1791f25c1ff0718dd1d00c9e303b54d2186762352b724021130"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "7187c1ff9b64631a183928e454518eaf", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Fix psql's \\g target meta-command to work with COPY TO STDOUT", "evidence": {"same_day": true, "patch_ids": ["4c91209bf8d5d37142ccb5063814974e"], "statement_hash": "e7de5484878ce1791f25c1ff0718dd1d00c9e303b54d2186762352b724021130"}, "url": "/docs/compare/?release=11.2#11.2-50cf03c981ebd665", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "c618564ee9c72ab927a920643066d530", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Fix psql's \\g target meta-command to work with COPY TO STDOUT", "evidence": {"same_day": true, "patch_ids": ["4c91209bf8d5d37142ccb5063814974e"], "statement_hash": "e7de5484878ce1791f25c1ff0718dd1d00c9e303b54d2186762352b724021130"}, "url": "/docs/compare/?release=10.7#10.7-50cf03c981ebd665", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "86760c4c16f03e7ced0f7f5cec09a558", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Fix psql's \\g target meta-command to work with COPY TO STDOUT", "evidence": {"same_day": true, "patch_ids": ["4c91209bf8d5d37142ccb5063814974e"], "statement_hash": "e7de5484878ce1791f25c1ff0718dd1d00c9e303b54d2186762352b724021130"}, "url": "/docs/compare/?release=9.6.12#9.6.12-50cf03c981ebd665", "source_url": "/docs/release/9.6.12/#AEN133889"}]}, {"id": "9.5.16-2f59f06fd8fc3cd9", "cves": [], "html": "Make psql's LaTeX output formats render special characters properly (Tom Lane)
\nBackslash and some other ASCII punctuation characters were not rendered correctly, leading to document syntax errors or wrong characters in the output.
", "text": "Make psql's LaTeX output formats render special characters properly (Tom Lane) Backslash and some other ASCII punctuation characters were not rendered correctly, leading to document syntax errors or wrong characters in the output.", "title": "Make psql's LaTeX output formats render special characters properly", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "906a91139be6520262dddbee664afda07fbf2f9cc427d86d2015d2be4cdf2094", "section_path": ["Changes"], "commit_groups": [["18a0a8548", "70d7e507e", "74bfb5388", "815409093", "ac305ff8c", "b352cf7a8"]], "identity_text": "Make psql's LaTeX output formats render special characters properly (Tom Lane) Backslash and some other ASCII punctuation characters were not rendered correctly, leading to document syntax errors or wrong characters in the output.", "commit_aliases": ["18a0a8548", "70d7e507e", "74bfb5388", "815409093", "ac305ff8c", "b352cf7a8"], "source_commits": ["18a0a8548"], "source_entry_id": "9.5.16/changes/030", "db_id": "34cef121c7493649d500f2d8e0fc6c3e", "patch_ids": ["0d22e3a5a55971379d0c07fd29212ac8"], "statement_hash": "1780726b51bc0a6d0b5a07ecf49a5eeab18852953ebc9d571ed19f81e9392544", "relations": [{"rule": 2, "type": "equivalent", "target": "12adaa842f4599e25d434ab48835f6e0", "evidence": {"same_day": true, "patch_ids": ["0d22e3a5a55971379d0c07fd29212ac8"], "statement_hash": "1780726b51bc0a6d0b5a07ecf49a5eeab18852953ebc9d571ed19f81e9392544"}}, {"rule": 2, "type": "equivalent", "target": "41f1ae7aff68bf8c0a07d0e75df1c8cb", "evidence": {"same_day": true, "patch_ids": ["0d22e3a5a55971379d0c07fd29212ac8"], "statement_hash": "1780726b51bc0a6d0b5a07ecf49a5eeab18852953ebc9d571ed19f81e9392544"}}, {"rule": 2, "type": "equivalent", "target": "82efaccc909edce2e198d3044d547df2", "evidence": {"same_day": true, "patch_ids": ["0d22e3a5a55971379d0c07fd29212ac8"], "statement_hash": "1780726b51bc0a6d0b5a07ecf49a5eeab18852953ebc9d571ed19f81e9392544"}}, {"rule": 2, "type": "equivalent", "target": "b85bd708bcef2c922bd53a37ba150d27", "evidence": {"same_day": true, "patch_ids": ["0d22e3a5a55971379d0c07fd29212ac8"], "statement_hash": "1780726b51bc0a6d0b5a07ecf49a5eeab18852953ebc9d571ed19f81e9392544"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "41f1ae7aff68bf8c0a07d0e75df1c8cb", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Make psql's LaTeX output formats render special characters properly", "evidence": {"same_day": true, "patch_ids": ["0d22e3a5a55971379d0c07fd29212ac8"], "statement_hash": "1780726b51bc0a6d0b5a07ecf49a5eeab18852953ebc9d571ed19f81e9392544"}, "url": "/docs/compare/?release=11.2#11.2-2f59f06fd8fc3cd9", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "82efaccc909edce2e198d3044d547df2", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Make psql's LaTeX output formats render special characters properly", "evidence": {"same_day": true, "patch_ids": ["0d22e3a5a55971379d0c07fd29212ac8"], "statement_hash": "1780726b51bc0a6d0b5a07ecf49a5eeab18852953ebc9d571ed19f81e9392544"}, "url": "/docs/compare/?release=10.7#10.7-2f59f06fd8fc3cd9", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "b85bd708bcef2c922bd53a37ba150d27", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Make psql's LaTeX output formats render special characters properly", "evidence": {"same_day": true, "patch_ids": ["0d22e3a5a55971379d0c07fd29212ac8"], "statement_hash": "1780726b51bc0a6d0b5a07ecf49a5eeab18852953ebc9d571ed19f81e9392544"}, "url": "/docs/compare/?release=9.6.12#9.6.12-2f59f06fd8fc3cd9", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "12adaa842f4599e25d434ab48835f6e0", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Make psql's LaTeX output formats render special characters properly", "evidence": {"same_day": true, "patch_ids": ["0d22e3a5a55971379d0c07fd29212ac8"], "statement_hash": "1780726b51bc0a6d0b5a07ecf49a5eeab18852953ebc9d571ed19f81e9392544"}, "url": "/docs/compare/?release=9.4.21#9.4.21-2f59f06fd8fc3cd9", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-60720808eb0e1c99", "cves": [], "html": "Fix pg_dump's handling of materialized views with indirect dependencies on primary keys (Tom Lane)
\nThis led to mis-labeling of such views' dump archive entries, causing harmless warnings about \"archive items not in correct section order\"; less harmlessly, selective-restore options depending on those labels, such as --section, might misbehave.
", "text": "Fix pg_dump's handling of materialized views with indirect dependencies on primary keys (Tom Lane) This led to mis-labeling of such views' dump archive entries, causing harmless warnings about \"archive items not in correct section order\"; less harmlessly, selective-restore options depending on those labels, such as --section, might misbehave.", "title": "Fix pg_dump's handling of materialized views with indirect dependencies on primary keys", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "fa27fbf54bfff32968e30c1e82d9b35cfb2b405a98ca745af159303c03591d36", "section_path": ["Changes"], "commit_groups": [["16e0464a1", "2f93b74bf", "6e4d45b5f", "9368ba174", "b8de846a5", "dc42602f1"]], "identity_text": "Fix pg_dump's handling of materialized views with indirect dependencies on primary keys (Tom Lane) This led to mis-labeling of such views' dump archive entries, causing harmless warnings about archive items not in correct section order; less harmlessly, selective-restore options depending on those labels, such as --section, might misbehave.", "commit_aliases": ["16e0464a1", "2f93b74bf", "6e4d45b5f", "9368ba174", "b8de846a5", "dc42602f1"], "source_commits": ["9368ba174"], "source_entry_id": "9.5.16/changes/031", "db_id": "0c84a59475fdf415649c3fca62db12e9", "patch_ids": ["225a035e5d0a62deac6d9cad98b020bb"], "statement_hash": "2910d1a5028eb80b5f1d0afde01e4f07726e139e3aa8aad32ace8df485beea85", "relations": [{"rule": 2, "type": "equivalent", "target": "ac45cc38f0e92596abe6e88dd63627c4", "evidence": {"same_day": true, "patch_ids": ["225a035e5d0a62deac6d9cad98b020bb"], "statement_hash": "2910d1a5028eb80b5f1d0afde01e4f07726e139e3aa8aad32ace8df485beea85"}}, {"rule": 2, "type": "equivalent", "target": "dcc06d23939bee8c416fc5d25fc9e2f6", "evidence": {"same_day": true, "patch_ids": ["225a035e5d0a62deac6d9cad98b020bb"], "statement_hash": "2910d1a5028eb80b5f1d0afde01e4f07726e139e3aa8aad32ace8df485beea85"}}, {"rule": 2, "type": "equivalent", "target": "ed75610318f26953695685c0cc9914ea", "evidence": {"same_day": true, "patch_ids": ["225a035e5d0a62deac6d9cad98b020bb"], "statement_hash": "2910d1a5028eb80b5f1d0afde01e4f07726e139e3aa8aad32ace8df485beea85"}}, {"rule": 2, "type": "equivalent", "target": "f3494c6e100c97ff9ac7c9af38b0f919", "evidence": {"same_day": true, "patch_ids": ["225a035e5d0a62deac6d9cad98b020bb"], "statement_hash": "2910d1a5028eb80b5f1d0afde01e4f07726e139e3aa8aad32ace8df485beea85"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "f3494c6e100c97ff9ac7c9af38b0f919", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Fix pg_dump's handling of materialized views with indirect dependencies on primary keys", "evidence": {"same_day": true, "patch_ids": ["225a035e5d0a62deac6d9cad98b020bb"], "statement_hash": "2910d1a5028eb80b5f1d0afde01e4f07726e139e3aa8aad32ace8df485beea85"}, "url": "/docs/compare/?release=11.2#11.2-60720808eb0e1c99", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "ed75610318f26953695685c0cc9914ea", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Fix pg_dump's handling of materialized views with indirect dependencies on primary keys", "evidence": {"same_day": true, "patch_ids": ["225a035e5d0a62deac6d9cad98b020bb"], "statement_hash": "2910d1a5028eb80b5f1d0afde01e4f07726e139e3aa8aad32ace8df485beea85"}, "url": "/docs/compare/?release=10.7#10.7-60720808eb0e1c99", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "ac45cc38f0e92596abe6e88dd63627c4", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Fix pg_dump's handling of materialized views with indirect dependencies on primary keys", "evidence": {"same_day": true, "patch_ids": ["225a035e5d0a62deac6d9cad98b020bb"], "statement_hash": "2910d1a5028eb80b5f1d0afde01e4f07726e139e3aa8aad32ace8df485beea85"}, "url": "/docs/compare/?release=9.6.12#9.6.12-60720808eb0e1c99", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "dcc06d23939bee8c416fc5d25fc9e2f6", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Fix pg_dump's handling of materialized views with indirect dependencies on primary keys", "evidence": {"same_day": true, "patch_ids": ["225a035e5d0a62deac6d9cad98b020bb"], "statement_hash": "2910d1a5028eb80b5f1d0afde01e4f07726e139e3aa8aad32ace8df485beea85"}, "url": "/docs/compare/?release=9.4.21#9.4.21-60720808eb0e1c99", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-4aa5a780598ae0bc", "cves": [], "html": "Avoid null-pointer-dereference crash on some platforms when pg_dump or pg_restore tries to report an error (Tom Lane)
", "text": "Avoid null-pointer-dereference crash on some platforms when pg_dump or pg_restore tries to report an error (Tom Lane)", "title": "Avoid null-pointer-dereference crash on some platforms when pg_dump or pg_restore tries to report an error", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "9c4d383883044df741c3aa0d7aa17598fe49646148a68a4d9107c239b1b229c2", "section_path": ["Changes"], "commit_groups": [["2b6009e2a", "2c8332177", "4dbe19690", "73668c590", "ed46d0d32", "ef9bf3593"]], "identity_text": "Avoid null-pointer-dereference crash on some platforms when pg_dump or pg_restore tries to report an error (Tom Lane)", "commit_aliases": ["2b6009e2a", "2c8332177", "4dbe19690", "73668c590", "ed46d0d32", "ef9bf3593"], "source_commits": ["2c8332177"], "source_entry_id": "9.5.16/changes/032", "db_id": "7cd4fd1329cb6190a2d9dc9a02a62ce8", "patch_ids": ["8449bac03ac98ea37ec791b5fc11c33d"], "statement_hash": "d52b019aabe44c168eded5320c19bf9f077f75b13d187e77fbfde5f3dba93948", "relations": [{"rule": 2, "type": "equivalent", "target": "076130892bd0f29ac59b6750d52a01cf", "evidence": {"same_day": true, "patch_ids": ["8449bac03ac98ea37ec791b5fc11c33d"], "statement_hash": "d52b019aabe44c168eded5320c19bf9f077f75b13d187e77fbfde5f3dba93948"}}, {"rule": 2, "type": "equivalent", "target": "21be836bee7a64905e1235eb537030b4", "evidence": {"same_day": true, "patch_ids": ["8449bac03ac98ea37ec791b5fc11c33d"], "statement_hash": "d52b019aabe44c168eded5320c19bf9f077f75b13d187e77fbfde5f3dba93948"}}, {"rule": 2, "type": "equivalent", "target": "646b79b07847b0b3cc9f38999c955953", "evidence": {"same_day": true, "patch_ids": ["8449bac03ac98ea37ec791b5fc11c33d"], "statement_hash": "d52b019aabe44c168eded5320c19bf9f077f75b13d187e77fbfde5f3dba93948"}}, {"rule": 2, "type": "equivalent", "target": "d78f112d08578b7d46e95c08df306243", "evidence": {"same_day": true, "patch_ids": ["8449bac03ac98ea37ec791b5fc11c33d"], "statement_hash": "d52b019aabe44c168eded5320c19bf9f077f75b13d187e77fbfde5f3dba93948"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "21be836bee7a64905e1235eb537030b4", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Avoid null-pointer-dereference crash on some platforms when pg_dump or pg_restore tries to report an error", "evidence": {"same_day": true, "patch_ids": ["8449bac03ac98ea37ec791b5fc11c33d"], "statement_hash": "d52b019aabe44c168eded5320c19bf9f077f75b13d187e77fbfde5f3dba93948"}, "url": "/docs/compare/?release=11.2#11.2-4aa5a780598ae0bc", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "d78f112d08578b7d46e95c08df306243", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Avoid null-pointer-dereference crash on some platforms when pg_dump or pg_restore tries to report an error", "evidence": {"same_day": true, "patch_ids": ["8449bac03ac98ea37ec791b5fc11c33d"], "statement_hash": "d52b019aabe44c168eded5320c19bf9f077f75b13d187e77fbfde5f3dba93948"}, "url": "/docs/compare/?release=10.7#10.7-4aa5a780598ae0bc", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "646b79b07847b0b3cc9f38999c955953", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Avoid null-pointer-dereference crash on some platforms when pg_dump or pg_restore tries to report an error", "evidence": {"same_day": true, "patch_ids": ["8449bac03ac98ea37ec791b5fc11c33d"], "statement_hash": "d52b019aabe44c168eded5320c19bf9f077f75b13d187e77fbfde5f3dba93948"}, "url": "/docs/compare/?release=9.6.12#9.6.12-4aa5a780598ae0bc", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "076130892bd0f29ac59b6750d52a01cf", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Avoid null-pointer-dereference crash on some platforms when pg_dump or pg_restore tries to report an error", "evidence": {"same_day": true, "patch_ids": ["8449bac03ac98ea37ec791b5fc11c33d"], "statement_hash": "d52b019aabe44c168eded5320c19bf9f077f75b13d187e77fbfde5f3dba93948"}, "url": "/docs/compare/?release=9.4.21#9.4.21-4aa5a780598ae0bc", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-d547b2b4f9159a4a", "cves": [], "html": "Fix contrib/hstore to calculate correct hash values for empty hstore values that were created in version 8.4 or before (Andrew Gierth)
\nThe previous coding did not give the same result as for an empty hstore value created by a newer version, thus potentially causing wrong results in hash joins or hash aggregation. It is advisable to reindex any hash indexes built on hstore columns, if the table might contain data that was originally stored as far back as 8.4 and was never dumped/reloaded since then.
", "text": "Fix contrib/hstore to calculate correct hash values for empty hstore values that were created in version 8.4 or before (Andrew Gierth) The previous coding did not give the same result as for an empty hstore value created by a newer version, thus potentially causing wrong results in hash joins or hash aggregation. It is advisable to reindex any hash indexes built on hstore columns, if the table might contain data that was originally stored as far back as 8.4 and was never dumped/reloaded since then.", "title": "Fix contrib/hstore to calculate correct hash values for empty hstore values that were created in version 8.4 or before", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "126e199f6fb7baf3d476e3cef2b5eb95be4c9c9cfee8c2d555af9c4c0cc8f063", "section_path": ["Changes"], "commit_groups": [["02e669c0f", "239abfff1", "8087788f6", "bcbb68278", "d5890f49d", "e5a6ae97e"]], "identity_text": "Fix contrib/hstore to calculate correct hash values for empty hstore values that were created in version 8.4 or before (Andrew Gierth) The previous coding did not give the same result as for an empty hstore value created by a newer version, thus potentially causing wrong results in hash joins or hash aggregation. It is advisable to reindex any hash indexes built on hstore columns, if the table might contain data that was originally stored as far back as 8.4 and was never dumped/reloaded since then.", "commit_aliases": ["02e669c0f", "239abfff1", "8087788f6", "bcbb68278", "d5890f49d", "e5a6ae97e"], "source_commits": ["8087788f6"], "source_entry_id": "9.5.16/changes/033", "db_id": "97160ddd803569a7384f09ff7e91186a", "patch_ids": ["bab1287e035cd1bef1182b510084a83a"], "statement_hash": "9ea45f86214864f0c30a2635096eaf9da5a010645be120d3607d5f7be63b02b5", "relations": [{"rule": 2, "type": "equivalent", "target": "055834090bf88d5f92e466160d3bbda4", "evidence": {"same_day": true, "patch_ids": ["bab1287e035cd1bef1182b510084a83a"], "statement_hash": "9ea45f86214864f0c30a2635096eaf9da5a010645be120d3607d5f7be63b02b5"}}, {"rule": 2, "type": "equivalent", "target": "434a271b68add8d6a8b515e094e66783", "evidence": {"same_day": true, "patch_ids": ["bab1287e035cd1bef1182b510084a83a"], "statement_hash": "9ea45f86214864f0c30a2635096eaf9da5a010645be120d3607d5f7be63b02b5"}}, {"rule": 2, "type": "equivalent", "target": "876fabb14ec0313206f04e471d934643", "evidence": {"same_day": true, "patch_ids": ["bab1287e035cd1bef1182b510084a83a"], "statement_hash": "9ea45f86214864f0c30a2635096eaf9da5a010645be120d3607d5f7be63b02b5"}}, {"rule": 2, "type": "equivalent", "target": "c8cb8ec0847b1a07ec02b663fdf12de7", "evidence": {"same_day": true, "patch_ids": ["bab1287e035cd1bef1182b510084a83a"], "statement_hash": "9ea45f86214864f0c30a2635096eaf9da5a010645be120d3607d5f7be63b02b5"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "434a271b68add8d6a8b515e094e66783", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Fix contrib/hstore to calculate correct hash values for empty hstore values that were created in version 8.4 or before", "evidence": {"same_day": true, "patch_ids": ["bab1287e035cd1bef1182b510084a83a"], "statement_hash": "9ea45f86214864f0c30a2635096eaf9da5a010645be120d3607d5f7be63b02b5"}, "url": "/docs/compare/?release=11.2#11.2-d547b2b4f9159a4a", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "c8cb8ec0847b1a07ec02b663fdf12de7", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Fix contrib/hstore to calculate correct hash values for empty hstore values that were created in version 8.4 or before", "evidence": {"same_day": true, "patch_ids": ["bab1287e035cd1bef1182b510084a83a"], "statement_hash": "9ea45f86214864f0c30a2635096eaf9da5a010645be120d3607d5f7be63b02b5"}, "url": "/docs/compare/?release=10.7#10.7-d547b2b4f9159a4a", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "876fabb14ec0313206f04e471d934643", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Fix contrib/hstore to calculate correct hash values for empty hstore values that were created in version 8.4 or before", "evidence": {"same_day": true, "patch_ids": ["bab1287e035cd1bef1182b510084a83a"], "statement_hash": "9ea45f86214864f0c30a2635096eaf9da5a010645be120d3607d5f7be63b02b5"}, "url": "/docs/compare/?release=9.6.12#9.6.12-d547b2b4f9159a4a", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "055834090bf88d5f92e466160d3bbda4", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Fix contrib/hstore to calculate correct hash values for empty hstore values that were created in version 8.4 or before", "evidence": {"same_day": true, "patch_ids": ["bab1287e035cd1bef1182b510084a83a"], "statement_hash": "9ea45f86214864f0c30a2635096eaf9da5a010645be120d3607d5f7be63b02b5"}, "url": "/docs/compare/?release=9.4.21#9.4.21-d547b2b4f9159a4a", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-47c2a8e51163f4fa", "cves": [], "html": "Avoid crashes and excessive runtime with large inputs to contrib/intarray's gist__int_ops index support (Andrew Gierth)
", "text": "Avoid crashes and excessive runtime with large inputs to contrib/intarray's gist__int_ops index support (Andrew Gierth)", "title": "Avoid crashes and excessive runtime with large inputs to contrib/intarray's gist__int_ops index support", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "a402826996425792014de3d87a5c006e9e204c5d8174c83eda2a35456934f729", "section_path": ["Changes"], "commit_groups": [["2e497ed23", "2f30b311d", "5f11a500f", "757c5182f", "e193fb991", "f0bfc7a2b"]], "identity_text": "Avoid crashes and excessive runtime with large inputs to contrib/intarray's gist__int_ops index support (Andrew Gierth)", "commit_aliases": ["2e497ed23", "2f30b311d", "5f11a500f", "757c5182f", "e193fb991", "f0bfc7a2b"], "source_commits": ["f0bfc7a2b"], "source_entry_id": "9.5.16/changes/034", "db_id": "35763572b5498b6720ca94621d06af46", "patch_ids": ["862b3d2b14eb14439b1f23072c53f8d8"], "statement_hash": "25c9c9db3018edd06c81a384c659889a43ce41cb14478d2a40ee6f21fb231c91", "relations": [{"rule": 2, "type": "equivalent", "target": "457ba9fee0f51ef77ce9f6d12c17dce3", "evidence": {"same_day": true, "patch_ids": ["862b3d2b14eb14439b1f23072c53f8d8"], "statement_hash": "25c9c9db3018edd06c81a384c659889a43ce41cb14478d2a40ee6f21fb231c91"}}, {"rule": 2, "type": "equivalent", "target": "5bbebf444cc855fc74a5f10f052e6aaf", "evidence": {"same_day": true, "patch_ids": ["862b3d2b14eb14439b1f23072c53f8d8"], "statement_hash": "25c9c9db3018edd06c81a384c659889a43ce41cb14478d2a40ee6f21fb231c91"}}, {"rule": 2, "type": "equivalent", "target": "e16afb4ec1547edea943adb4b1999d71", "evidence": {"same_day": true, "patch_ids": ["862b3d2b14eb14439b1f23072c53f8d8"], "statement_hash": "25c9c9db3018edd06c81a384c659889a43ce41cb14478d2a40ee6f21fb231c91"}}, {"rule": 2, "type": "equivalent", "target": "e5e618310e7dddb6e6db3fabbc3054e9", "evidence": {"same_day": true, "patch_ids": ["862b3d2b14eb14439b1f23072c53f8d8"], "statement_hash": "25c9c9db3018edd06c81a384c659889a43ce41cb14478d2a40ee6f21fb231c91"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "e5e618310e7dddb6e6db3fabbc3054e9", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Avoid crashes and excessive runtime with large inputs to contrib/intarray's gist__int_ops index support", "evidence": {"same_day": true, "patch_ids": ["862b3d2b14eb14439b1f23072c53f8d8"], "statement_hash": "25c9c9db3018edd06c81a384c659889a43ce41cb14478d2a40ee6f21fb231c91"}, "url": "/docs/compare/?release=11.2#11.2-47c2a8e51163f4fa", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "457ba9fee0f51ef77ce9f6d12c17dce3", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Avoid crashes and excessive runtime with large inputs to contrib/intarray's gist__int_ops index support", "evidence": {"same_day": true, "patch_ids": ["862b3d2b14eb14439b1f23072c53f8d8"], "statement_hash": "25c9c9db3018edd06c81a384c659889a43ce41cb14478d2a40ee6f21fb231c91"}, "url": "/docs/compare/?release=10.7#10.7-47c2a8e51163f4fa", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "5bbebf444cc855fc74a5f10f052e6aaf", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Avoid crashes and excessive runtime with large inputs to contrib/intarray's gist__int_ops index support", "evidence": {"same_day": true, "patch_ids": ["862b3d2b14eb14439b1f23072c53f8d8"], "statement_hash": "25c9c9db3018edd06c81a384c659889a43ce41cb14478d2a40ee6f21fb231c91"}, "url": "/docs/compare/?release=9.6.12#9.6.12-47c2a8e51163f4fa", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "e16afb4ec1547edea943adb4b1999d71", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Avoid crashes and excessive runtime with large inputs to contrib/intarray's gist__int_ops index support", "evidence": {"same_day": true, "patch_ids": ["862b3d2b14eb14439b1f23072c53f8d8"], "statement_hash": "25c9c9db3018edd06c81a384c659889a43ce41cb14478d2a40ee6f21fb231c91"}, "url": "/docs/compare/?release=9.4.21#9.4.21-47c2a8e51163f4fa", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-f6289937134c95bd", "cves": [], "html": "Adjust configure's selection of threading-related compiler flags and libraries to match what later PostgreSQL releases do (Tom Lane)
\nThe coding previously used in the 9.4 and 9.5 branches fails outright on some newer platforms, so sync it with what 9.6 and later have been doing.
", "text": "Adjust configure's selection of threading-related compiler flags and libraries to match what later PostgreSQL releases do (Tom Lane) The coding previously used in the 9.4 and 9.5 branches fails outright on some newer platforms, so sync it with what 9.6 and later have been doing.", "title": "Adjust configure's selection of threading-related compiler flags and libraries to match what later PostgreSQL releases do", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "749285fb08ee268d32042acd8c8cd63df0218253df79a3e1c7f05ecb7cd2dcff", "section_path": ["Changes"], "commit_groups": [["100535bba", "7c86b9431"]], "identity_text": "Adjust configure's selection of threading-related compiler flags and libraries to match what later PostgreSQL releases do (Tom Lane) The coding previously used in the 9.4 and 9.5 branches fails outright on some newer platforms, so sync it with what 9.6 and later have been doing.", "commit_aliases": ["100535bba", "7c86b9431"], "source_commits": ["100535bba"], "source_entry_id": "9.5.16/changes/035", "db_id": "81462e8543a2870ca2b37cf35200fc6c", "patch_ids": ["4a8d51718c132f5051710e4e95b08f6e"], "statement_hash": "6d6db8d52050ab877e0d6d0659950a47c0b04f62002a1487b59e6f04d992d93e", "relations": [{"rule": 2, "type": "equivalent", "target": "8188a6b8aeabecd6654a925e8d0d45e8", "evidence": {"same_day": true, "patch_ids": ["4a8d51718c132f5051710e4e95b08f6e"], "statement_hash": "6d6db8d52050ab877e0d6d0659950a47c0b04f62002a1487b59e6f04d992d93e"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "8188a6b8aeabecd6654a925e8d0d45e8", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Adjust configure's selection of threading-related compiler flags and libraries to match what later PostgreSQL releases do", "evidence": {"same_day": true, "patch_ids": ["4a8d51718c132f5051710e4e95b08f6e"], "statement_hash": "6d6db8d52050ab877e0d6d0659950a47c0b04f62002a1487b59e6f04d992d93e"}, "url": "/docs/compare/?release=9.4.21#9.4.21-f6289937134c95bd", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-faf9604d537866b6", "cves": [], "html": "Support new Makefile variables PG_CFLAGS, PG_CXXFLAGS, and PG_LDFLAGS in pgxs builds (Christoph Berg)
\nThis simplifies customization of extension build processes.
", "text": "Support new Makefile variables PG_CFLAGS, PG_CXXFLAGS, and PG_LDFLAGS in pgxs builds (Christoph Berg) This simplifies customization of extension build processes.", "title": "Support new Makefile variables PG_CFLAGS, PG_CXXFLAGS, and PG_LDFLAGS in pgxs builds", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "7b2785fa930108cedea55e915365ae481b7523f22c793a00de54d06522cb2c02", "section_path": ["Changes"], "commit_groups": [["12ff406f3", "42b204db2", "5e63df827", "946430da6", "ac3a9afdb", "da14c9b19"]], "identity_text": "Support new Makefile variables PG_CFLAGS, PG_CXXFLAGS, and PG_LDFLAGS in pgxs builds (Christoph Berg) This simplifies customization of extension build processes.", "commit_aliases": ["12ff406f3", "42b204db2", "5e63df827", "946430da6", "ac3a9afdb", "da14c9b19"], "source_commits": ["12ff406f3"], "source_entry_id": "9.5.16/changes/036", "db_id": "905aa0c9bcd5ae5bd19ffc3cb6d8b68f", "patch_ids": ["ce4a810a3179bfb02a9c7783c12b18df"], "statement_hash": "4b60fa6125a36c0310cff0cd9db1a2cdc82bf67a538a3c9ce8381a23788bc2ad", "relations": [{"rule": 2, "type": "equivalent", "target": "49b22414c6b01d95f919cbef4b006901", "evidence": {"same_day": true, "patch_ids": ["ce4a810a3179bfb02a9c7783c12b18df"], "statement_hash": "4b60fa6125a36c0310cff0cd9db1a2cdc82bf67a538a3c9ce8381a23788bc2ad"}}, {"rule": 2, "type": "equivalent", "target": "a0fbf30e3f583db5874a0438fb748310", "evidence": {"same_day": true, "patch_ids": ["ce4a810a3179bfb02a9c7783c12b18df"], "statement_hash": "4b60fa6125a36c0310cff0cd9db1a2cdc82bf67a538a3c9ce8381a23788bc2ad"}}, {"rule": 2, "type": "equivalent", "target": "ea426904ed3ce354fd0b873bd95dae9f", "evidence": {"same_day": true, "patch_ids": ["ce4a810a3179bfb02a9c7783c12b18df"], "statement_hash": "4b60fa6125a36c0310cff0cd9db1a2cdc82bf67a538a3c9ce8381a23788bc2ad"}}, {"rule": 2, "type": "equivalent", "target": "f154fe88c596f38aeac6bd613bc0c606", "evidence": {"same_day": true, "patch_ids": ["ce4a810a3179bfb02a9c7783c12b18df"], "statement_hash": "4b60fa6125a36c0310cff0cd9db1a2cdc82bf67a538a3c9ce8381a23788bc2ad"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f154fe88c596f38aeac6bd613bc0c606", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Support new Makefile variables PG_CFLAGS, PG_CXXFLAGS, and PG_LDFLAGS in pgxs builds", "evidence": {"same_day": true, "patch_ids": ["ce4a810a3179bfb02a9c7783c12b18df"], "statement_hash": "4b60fa6125a36c0310cff0cd9db1a2cdc82bf67a538a3c9ce8381a23788bc2ad"}, "url": "/docs/compare/?release=11.2#11.2-faf9604d537866b6", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "a0fbf30e3f583db5874a0438fb748310", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Support new Makefile variables PG_CFLAGS, PG_CXXFLAGS, and PG_LDFLAGS in pgxs builds", "evidence": {"same_day": true, "patch_ids": ["ce4a810a3179bfb02a9c7783c12b18df"], "statement_hash": "4b60fa6125a36c0310cff0cd9db1a2cdc82bf67a538a3c9ce8381a23788bc2ad"}, "url": "/docs/compare/?release=10.7#10.7-faf9604d537866b6", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "49b22414c6b01d95f919cbef4b006901", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Support new Makefile variables PG_CFLAGS, PG_CXXFLAGS, and PG_LDFLAGS in pgxs builds", "evidence": {"same_day": true, "patch_ids": ["ce4a810a3179bfb02a9c7783c12b18df"], "statement_hash": "4b60fa6125a36c0310cff0cd9db1a2cdc82bf67a538a3c9ce8381a23788bc2ad"}, "url": "/docs/compare/?release=9.6.12#9.6.12-faf9604d537866b6", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "ea426904ed3ce354fd0b873bd95dae9f", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Support new Makefile variables PG_CFLAGS, PG_CXXFLAGS, and PG_LDFLAGS in pgxs builds", "evidence": {"same_day": true, "patch_ids": ["ce4a810a3179bfb02a9c7783c12b18df"], "statement_hash": "4b60fa6125a36c0310cff0cd9db1a2cdc82bf67a538a3c9ce8381a23788bc2ad"}, "url": "/docs/compare/?release=9.4.21#9.4.21-faf9604d537866b6", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-54efb1e058450472", "cves": [], "html": "Fix Perl-coded build scripts to not assume \".\" is in the search path, since recent Perl versions don't include that (Andrew Dunstan)
", "text": "Fix Perl-coded build scripts to not assume \".\" is in the search path, since recent Perl versions don't include that (Andrew Dunstan)", "title": "Fix Perl-coded build scripts to not assume \".\" is in the search path, since recent Perl versions don't include that", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "73fdc40a18fc02d73ed927d7f777a154f2799af4c81ade55afe4d1b2de9005f4", "section_path": ["Changes"], "commit_groups": [["11f11e1e0", "13e95662c", "1f28906bf", "324c92646", "592123efb", "8d2741452"], ["1a6244216", "2689e8e33", "42345284c", "59927f99a", "77173d0cc", "f83419b73"], ["1fbb9bda0", "4e7a51302", "772d4b769", "7a3763318", "a25b04933", "f884a9681"], ["51884fa16", "a82ca6ffb", "be037c11b"]], "identity_text": "Fix Perl-coded build scripts to not assume . is in the search path, since recent Perl versions don't include that (Andrew Dunstan)", "commit_aliases": ["11f11e1e0", "13e95662c", "1a6244216", "1f28906bf", "1fbb9bda0", "2689e8e33", "324c92646", "42345284c", "4e7a51302", "51884fa16", "592123efb", "59927f99a", "77173d0cc", "772d4b769", "7a3763318", "8d2741452", "a25b04933", "a82ca6ffb", "be037c11b", "f83419b73", "f884a9681"], "source_commits": ["59927f99a", "8d2741452", "a25b04933", "a82ca6ffb"], "source_entry_id": "9.5.16/changes/037", "db_id": "be020029fbce24265349fdbd6c61fd12", "patch_ids": ["0ded4067d557dad634afe0d73dc977e1", "48ae0597594a2b9db7c6f100401cd710", "9f3b6053bfeb993875e9ed0618925e2c", "ad3c5cc2c6849ea5370e52c293300028"], "statement_hash": "ddf2130d130aed3bffc4bc8148913acede169b5d15ea7632d5bcc2d83e4bad69", "relations": [{"rule": 2, "type": "equivalent", "target": "5feff61c5da811b9505a77ce4704cdc9", "evidence": {"same_day": true, "patch_ids": ["0ded4067d557dad634afe0d73dc977e1", "48ae0597594a2b9db7c6f100401cd710", "9f3b6053bfeb993875e9ed0618925e2c", "ad3c5cc2c6849ea5370e52c293300028"], "statement_hash": "ddf2130d130aed3bffc4bc8148913acede169b5d15ea7632d5bcc2d83e4bad69"}}, {"rule": 2, "type": "equivalent", "target": "babf771f2176629b4e9c39611c62f1e2", "evidence": {"same_day": true, "patch_ids": ["0ded4067d557dad634afe0d73dc977e1", "48ae0597594a2b9db7c6f100401cd710", "9f3b6053bfeb993875e9ed0618925e2c", "ad3c5cc2c6849ea5370e52c293300028"], "statement_hash": "ddf2130d130aed3bffc4bc8148913acede169b5d15ea7632d5bcc2d83e4bad69"}}, {"rule": 2, "type": "equivalent", "target": "dbce47d7369084d0a50658e294a60595", "evidence": {"same_day": true, "patch_ids": ["0ded4067d557dad634afe0d73dc977e1", "48ae0597594a2b9db7c6f100401cd710", "9f3b6053bfeb993875e9ed0618925e2c", "ad3c5cc2c6849ea5370e52c293300028"], "statement_hash": "ddf2130d130aed3bffc4bc8148913acede169b5d15ea7632d5bcc2d83e4bad69"}}, {"rule": 2, "type": "equivalent", "target": "e63b82ea5dc747d39c5403bb23e8d64b", "evidence": {"same_day": true, "patch_ids": ["0ded4067d557dad634afe0d73dc977e1", "48ae0597594a2b9db7c6f100401cd710", "9f3b6053bfeb993875e9ed0618925e2c", "ad3c5cc2c6849ea5370e52c293300028"], "statement_hash": "ddf2130d130aed3bffc4bc8148913acede169b5d15ea7632d5bcc2d83e4bad69"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "babf771f2176629b4e9c39611c62f1e2", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Fix Perl-coded build scripts to not assume “.” is in the search path, since recent Perl versions don't include that", "evidence": {"same_day": true, "patch_ids": ["0ded4067d557dad634afe0d73dc977e1", "48ae0597594a2b9db7c6f100401cd710", "9f3b6053bfeb993875e9ed0618925e2c", "ad3c5cc2c6849ea5370e52c293300028"], "statement_hash": "ddf2130d130aed3bffc4bc8148913acede169b5d15ea7632d5bcc2d83e4bad69"}, "url": "/docs/compare/?release=11.2#11.2-6ba6bacc67a69ca2", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "5feff61c5da811b9505a77ce4704cdc9", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Fix Perl-coded build scripts to not assume “.” is in the search path, since recent Perl versions don't include that", "evidence": {"same_day": true, "patch_ids": ["0ded4067d557dad634afe0d73dc977e1", "48ae0597594a2b9db7c6f100401cd710", "9f3b6053bfeb993875e9ed0618925e2c", "ad3c5cc2c6849ea5370e52c293300028"], "statement_hash": "ddf2130d130aed3bffc4bc8148913acede169b5d15ea7632d5bcc2d83e4bad69"}, "url": "/docs/compare/?release=10.7#10.7-6ba6bacc67a69ca2", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "dbce47d7369084d0a50658e294a60595", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Fix Perl-coded build scripts to not assume \".\" is in the search path, since recent Perl versions don't include that", "evidence": {"same_day": true, "patch_ids": ["0ded4067d557dad634afe0d73dc977e1", "48ae0597594a2b9db7c6f100401cd710", "9f3b6053bfeb993875e9ed0618925e2c", "ad3c5cc2c6849ea5370e52c293300028"], "statement_hash": "ddf2130d130aed3bffc4bc8148913acede169b5d15ea7632d5bcc2d83e4bad69"}, "url": "/docs/compare/?release=9.6.12#9.6.12-54efb1e058450472", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "e63b82ea5dc747d39c5403bb23e8d64b", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Fix Perl-coded build scripts to not assume \".\" is in the search path, since recent Perl versions don't include that", "evidence": {"same_day": true, "patch_ids": ["0ded4067d557dad634afe0d73dc977e1", "48ae0597594a2b9db7c6f100401cd710", "9f3b6053bfeb993875e9ed0618925e2c", "ad3c5cc2c6849ea5370e52c293300028"], "statement_hash": "ddf2130d130aed3bffc4bc8148913acede169b5d15ea7632d5bcc2d83e4bad69"}, "url": "/docs/compare/?release=9.4.21#9.4.21-54efb1e058450472", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-6596642dd33b694d", "cves": [], "html": "Fix server command-line option parsing problems on OpenBSD (Tom Lane)
", "text": "Fix server command-line option parsing problems on OpenBSD (Tom Lane)", "title": "Fix server command-line option parsing problems on OpenBSD", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "4bdf8709e7856c624af06e9cd01025016bb2e54c84dfebcc0de4c9e1138d9cfb", "section_path": ["Changes"], "commit_groups": [["139e42742", "167ba6b15", "69bcd718d", "b161ffe31", "dc2dee438", "e4ffa0dcb"]], "identity_text": "Fix server command-line option parsing problems on OpenBSD (Tom Lane)", "commit_aliases": ["139e42742", "167ba6b15", "69bcd718d", "b161ffe31", "dc2dee438", "e4ffa0dcb"], "source_commits": ["dc2dee438"], "source_entry_id": "9.5.16/changes/038", "db_id": "74b4e5f3c8390541ea96e4142d96711e", "patch_ids": ["bba58387f09acc5f86949d2b8323329d"], "statement_hash": "02c0d40cb597c765b8f274fd3040575740751391f76a68a2e33188621dd6f414", "relations": [{"rule": 2, "type": "equivalent", "target": "4d069c7e918437549867fde24d7f25f9", "evidence": {"same_day": true, "patch_ids": ["bba58387f09acc5f86949d2b8323329d"], "statement_hash": "02c0d40cb597c765b8f274fd3040575740751391f76a68a2e33188621dd6f414"}}, {"rule": 2, "type": "equivalent", "target": "65db162d02c4b6854b98a2a7673e3435", "evidence": {"same_day": true, "patch_ids": ["bba58387f09acc5f86949d2b8323329d"], "statement_hash": "02c0d40cb597c765b8f274fd3040575740751391f76a68a2e33188621dd6f414"}}, {"rule": 2, "type": "equivalent", "target": "ac12c45ea23584595c82886f75e5a3f5", "evidence": {"same_day": true, "patch_ids": ["bba58387f09acc5f86949d2b8323329d"], "statement_hash": "02c0d40cb597c765b8f274fd3040575740751391f76a68a2e33188621dd6f414"}}, {"rule": 2, "type": "equivalent", "target": "bf70a1754599d33d8fed5b4a84a1c76a", "evidence": {"same_day": true, "patch_ids": ["bba58387f09acc5f86949d2b8323329d"], "statement_hash": "02c0d40cb597c765b8f274fd3040575740751391f76a68a2e33188621dd6f414"}}], "version": "9.5.16", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "bf70a1754599d33d8fed5b4a84a1c76a", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Fix server command-line option parsing problems on OpenBSD", "evidence": {"same_day": true, "patch_ids": ["bba58387f09acc5f86949d2b8323329d"], "statement_hash": "02c0d40cb597c765b8f274fd3040575740751391f76a68a2e33188621dd6f414"}, "url": "/docs/compare/?release=11.2#11.2-6596642dd33b694d", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "65db162d02c4b6854b98a2a7673e3435", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Fix server command-line option parsing problems on OpenBSD", "evidence": {"same_day": true, "patch_ids": ["bba58387f09acc5f86949d2b8323329d"], "statement_hash": "02c0d40cb597c765b8f274fd3040575740751391f76a68a2e33188621dd6f414"}, "url": "/docs/compare/?release=10.7#10.7-6596642dd33b694d", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "4d069c7e918437549867fde24d7f25f9", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Fix server command-line option parsing problems on OpenBSD", "evidence": {"same_day": true, "patch_ids": ["bba58387f09acc5f86949d2b8323329d"], "statement_hash": "02c0d40cb597c765b8f274fd3040575740751391f76a68a2e33188621dd6f414"}, "url": "/docs/compare/?release=9.6.12#9.6.12-6596642dd33b694d", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "ac12c45ea23584595c82886f75e5a3f5", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Fix server command-line option parsing problems on OpenBSD", "evidence": {"same_day": true, "patch_ids": ["bba58387f09acc5f86949d2b8323329d"], "statement_hash": "02c0d40cb597c765b8f274fd3040575740751391f76a68a2e33188621dd6f414"}, "url": "/docs/compare/?release=9.4.21#9.4.21-6596642dd33b694d", "source_url": "/docs/release/9.4.21/#AEN120464"}]}, {"id": "9.5.16-9db43ad8145e521b", "cves": [], "html": "Update time zone data files to tzdata release 2018i for DST law changes in Kazakhstan, Metlakatla, and Sao Tome and Principe. Kazakhstan's Qyzylorda zone is split in two, creating a new zone Asia/Qostanay, as some areas did not change UTC offset. Historical corrections for Hong Kong and numerous Pacific islands.
", "text": "Update time zone data files to tzdata release 2018i for DST law changes in Kazakhstan, Metlakatla, and Sao Tome and Principe. Kazakhstan's Qyzylorda zone is split in two, creating a new zone Asia/Qostanay, as some areas did not change UTC offset. Historical corrections for Hong Kong and numerous Pacific islands.", "title": "Update time zone data files to tzdata release 2018i for DST law changes in Kazakhstan, Metlakatla, and Sao Tome and Principe. Kazakhstan's Qyzylorda zone is split in two, creating a new zone Asia/Qostanay, as some areas did not change UTC offset. Historical corrections for Hong Kong and numerous Pacific islands.", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.5.16/#AEN128667", "source_hash": "2585d8863c5519134f1915e343cacfe296bf87379c58e3b19246e526502b99d6", "section_path": ["Changes"], "commit_groups": [["09c5f045c", "4232a650b", "46b454096", "a683df403", "d63dc0aa0", "f6db9f8ab"]], "identity_text": "Update time zone data files to tzdata release 2018i for DST law changes in Kazakhstan, Metlakatla, and Sao Tome and Principe. Kazakhstan's Qyzylorda zone is split in two, creating a new zone Asia/Qostanay, as some areas did not change UTC offset. Historical corrections for Hong Kong and numerous Pacific islands.", "commit_aliases": ["09c5f045c", "4232a650b", "46b454096", "a683df403", "d63dc0aa0", "f6db9f8ab"], "source_commits": ["4232a650b"], "source_entry_id": "9.5.16/changes/039", "db_id": "8fe8423f1e22b0dc72ef463701d7b1ce", "patch_ids": ["600522b7a4fbb2aa981b105b9de13502"], "statement_hash": "10d03897798403ffce249e08c73faf46d13fdff611b447ec34239e94ca7c8895", "relations": [{"rule": 2, "type": "equivalent", "target": "712c715b99423912677db044780ae49c", "evidence": {"same_day": true, "patch_ids": ["600522b7a4fbb2aa981b105b9de13502"], "statement_hash": "10d03897798403ffce249e08c73faf46d13fdff611b447ec34239e94ca7c8895"}}, {"rule": 2, "type": "equivalent", "target": "7f0d750645e2c102237305043ce3b2be", "evidence": {"same_day": true, "patch_ids": ["600522b7a4fbb2aa981b105b9de13502"], "statement_hash": "10d03897798403ffce249e08c73faf46d13fdff611b447ec34239e94ca7c8895"}}, {"rule": 2, "type": "equivalent", "target": "9e69c9f4cb374d08796dba2770b5fb49", "evidence": {"same_day": true, "patch_ids": ["600522b7a4fbb2aa981b105b9de13502"], "statement_hash": "10d03897798403ffce249e08c73faf46d13fdff611b447ec34239e94ca7c8895"}}, {"rule": 2, "type": "equivalent", "target": "d5351f963ffd87df9396537ed3ee15ae", "evidence": {"same_day": true, "patch_ids": ["600522b7a4fbb2aa981b105b9de13502"], "statement_hash": "10d03897798403ffce249e08c73faf46d13fdff611b447ec34239e94ca7c8895"}}], "version": "9.5.16", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "712c715b99423912677db044780ae49c", "kind": "equivalent", "version": "11.2", "label": "11.2", "title": "Update time zone data files to tzdata release 2018i for DST law changes in Kazakhstan, Metlakatla, and Sao Tome and Principe. Kazakhstan's Qyzylorda zone is split in two, creating a new zone Asia/Qostanay, as some areas did not change UTC offset. Historical corrections for Hong Kong and numerous Pacific islands.", "evidence": {"same_day": true, "patch_ids": ["600522b7a4fbb2aa981b105b9de13502"], "statement_hash": "10d03897798403ffce249e08c73faf46d13fdff611b447ec34239e94ca7c8895"}, "url": "/docs/compare/?release=11.2#11.2-9db43ad8145e521b", "source_url": "/docs/release/11.2/#id-1.11.6.25.5"}, {"db_id": "7f0d750645e2c102237305043ce3b2be", "kind": "equivalent", "version": "10.7", "label": "10.7", "title": "Update time zone data files to tzdata release 2018i for DST law changes in Kazakhstan, Metlakatla, and Sao Tome and Principe. Kazakhstan's Qyzylorda zone is split in two, creating a new zone Asia/Qostanay, as some areas did not change UTC offset. Historical corrections for Hong Kong and numerous Pacific islands.", "evidence": {"same_day": true, "patch_ids": ["600522b7a4fbb2aa981b105b9de13502"], "statement_hash": "10d03897798403ffce249e08c73faf46d13fdff611b447ec34239e94ca7c8895"}, "url": "/docs/compare/?release=10.7#10.7-9db43ad8145e521b", "source_url": "/docs/release/10.7/#id-1.11.6.21.5"}, {"db_id": "d5351f963ffd87df9396537ed3ee15ae", "kind": "equivalent", "version": "9.6.12", "label": "9.6.12", "title": "Update time zone data files to tzdata release 2018i for DST law changes in Kazakhstan, Metlakatla, and Sao Tome and Principe. Kazakhstan's Qyzylorda zone is split in two, creating a new zone Asia/Qostanay, as some areas did not change UTC offset. Historical corrections for Hong Kong and numerous Pacific islands.", "evidence": {"same_day": true, "patch_ids": ["600522b7a4fbb2aa981b105b9de13502"], "statement_hash": "10d03897798403ffce249e08c73faf46d13fdff611b447ec34239e94ca7c8895"}, "url": "/docs/compare/?release=9.6.12#9.6.12-9db43ad8145e521b", "source_url": "/docs/release/9.6.12/#AEN133889"}, {"db_id": "9e69c9f4cb374d08796dba2770b5fb49", "kind": "equivalent", "version": "9.4.21", "label": "9.4.21", "title": "Update time zone data files to tzdata release 2018i for DST law changes in Kazakhstan, Metlakatla, and Sao Tome and Principe. Kazakhstan's Qyzylorda zone is split in two, creating a new zone Asia/Qostanay, as some areas did not change UTC offset. Historical corrections for Hong Kong and numerous Pacific islands.", "evidence": {"same_day": true, "patch_ids": ["600522b7a4fbb2aa981b105b9de13502"], "statement_hash": "10d03897798403ffce249e08c73faf46d13fdff611b447ec34239e94ca7c8895"}, "url": "/docs/compare/?release=9.4.21#9.4.21-9db43ad8145e521b", "source_url": "/docs/release/9.4.21/#AEN120464"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 39}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 22}, {"key": "security", "label": "Security", "count": 0}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 17}], "total": 39, "release_count": 1, "cross_major": false, "cve_count": 0, "cves": [], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 39, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}