{"format": 1, "mode": "release", "from_release": null, "to_release": {"date": "2019-08-08", "build": "9.4.24", "major": "9.4", "minor": 24, "manual": "9.4", "status": "stable", "doc_git": "", "version": "9.4.24", "eol_date": "2020-02-13", "date_text": "2019-08-08", "supported": false, "manual_url": "/docs/9.4/release-9-4-24.html", "source_url": "/docs/release/9.4.24/", "entry_count": 18, "placeholder": false, "content_hash": "439f25a6a04022e7d9280bb96e5f35e9631e392a20c797855bf1401f1163edf8", "manual_build": "9.4.26", "source_as_of": "", "changes_count": 18, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "<p>A dump/restore is not required for those running 9.4.X.</p>\n<p>However, if you are upgrading from a version earlier than 9.4.18, see <a href=\"/docs/9.4/release-9-4-18.html\">Section E.9</a>.</p>", "compatibility_count": 0, "label": "9.4.24", "status_label": "Historical", "eol": "2020-02-13", "age_days": 2609, "support_days": -2420}, "groups": [{"date": "2019-08-08", "build": "9.4.24", "major": "9.4", "minor": 24, "manual": "9.4", "status": "stable", "doc_git": "", "version": "9.4.24", "eol_date": "2020-02-13", "date_text": "2019-08-08", "supported": false, "manual_url": "/docs/9.4/release-9-4-24.html", "source_url": "/docs/release/9.4.24/", "entry_count": 18, "placeholder": false, "content_hash": "439f25a6a04022e7d9280bb96e5f35e9631e392a20c797855bf1401f1163edf8", "manual_build": "9.4.26", "source_as_of": "", "changes_count": 18, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "<p>A dump/restore is not required for those running 9.4.X.</p>\n<p>However, if you are upgrading from a version earlier than 9.4.18, see <a href=\"/docs/9.4/release-9-4-18.html\">Section E.9</a>.</p>", "compatibility_count": 0, "label": "9.4.24", "status_label": "Historical", "eol": "2020-02-13", "age_days": 2609, "support_days": -2420, "entries": [{"id": "9.4.24-df1e4670d6c8f5ec", "cves": ["CVE-2007-2138", "CVE-2019-10208"], "html": "<p>Require schema qualification to cast to a temporary type when using functional cast syntax (Noah Misch)</p>\n<p>We have long required invocations of temporary functions to explicitly specify the temporary schema, that is pg_temp.<i>func_name</i>(<i>args</i>). Require this as well for casting to temporary types using functional notation, for example pg_temp.<i>type_name</i>(<i>arg</i>). Otherwise it's possible to capture a function call using a temporary object, allowing privilege escalation in much the same ways that we blocked in CVE-2007-2138. (CVE-2019-10208)</p>", "text": "Require schema qualification to cast to a temporary type when using functional cast syntax (Noah Misch) We have long required invocations of temporary functions to explicitly specify the temporary schema, that is pg_temp.func_name(args). Require this as well for casting to temporary types using functional notation, for example pg_temp.type_name(arg). Otherwise it's possible to capture a function call using a temporary object, allowing privilege escalation in much the same ways that we blocked in CVE-2007-2138. (CVE-2019-10208)", "title": "Require schema qualification to cast to a temporary type when using functional cast syntax", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "c4ccab8890db89c4e74d2af463dec4e5b573e7ed185e091631649a87251c5221", "section_path": ["Changes"], "commit_groups": [["2062007cb", "21f94c51f", "752fa3dbf", "7da46192d", "86737438b", "9993fa9dd", "ffa2d37e5"]], "identity_text": "Require schema qualification to cast to a temporary type when using functional cast syntax (Noah Misch) We have long required invocations of temporary functions to explicitly specify the temporary schema, that is pg_temp.func_name(args). Require this as well for casting to temporary types using functional notation, for example pg_temp.type_name(arg). Otherwise it's possible to capture a function call using a temporary object, allowing privilege escalation in much the same ways that we blocked in CVE-2007-2138. (CVE-2019-10208)", "commit_aliases": ["2062007cb", "21f94c51f", "752fa3dbf", "7da46192d", "86737438b", "9993fa9dd", "ffa2d37e5"], "source_commits": ["86737438b"], "source_entry_id": "9.4.24/changes/001", "db_id": "4ead40eb1a73d156352d6965e0c2e833", "patch_ids": ["65b124caa944e034539f5e82e98c754f"], "statement_hash": "6301db346f6b9a542180562e62db8b1ca6afbff6d21b0956212ae4ec6f33562a", "relations": [{"rule": 2, "type": "equivalent", "target": "2e1380da5c384e9841ef99506e57154c", "evidence": {"same_day": true, "patch_ids": ["65b124caa944e034539f5e82e98c754f"], "statement_hash": "6301db346f6b9a542180562e62db8b1ca6afbff6d21b0956212ae4ec6f33562a"}}, {"rule": 2, "type": "equivalent", "target": "57b9b455efe831edd464a0a1b92d3638", "evidence": {"same_day": true, "patch_ids": ["65b124caa944e034539f5e82e98c754f"], "statement_hash": "6301db346f6b9a542180562e62db8b1ca6afbff6d21b0956212ae4ec6f33562a"}}, {"rule": 2, "type": "equivalent", "target": "b1483cae7422c63eb52dc92db4d84965", "evidence": {"same_day": true, "patch_ids": ["65b124caa944e034539f5e82e98c754f"], "statement_hash": "6301db346f6b9a542180562e62db8b1ca6afbff6d21b0956212ae4ec6f33562a"}}, {"rule": 2, "type": "equivalent", "target": "cbafa803ad06f9f27b4bbe75ba7c7e3f", "evidence": {"same_day": true, "patch_ids": ["65b124caa944e034539f5e82e98c754f"], "statement_hash": "6301db346f6b9a542180562e62db8b1ca6afbff6d21b0956212ae4ec6f33562a"}}], "version": "9.4.24", "category_label": "Security", "also_in": [], "variants": [], "related_changes": [{"db_id": "57b9b455efe831edd464a0a1b92d3638", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Require schema qualification to cast to a temporary type when using functional cast syntax", "evidence": {"same_day": true, "patch_ids": ["65b124caa944e034539f5e82e98c754f"], "statement_hash": "6301db346f6b9a542180562e62db8b1ca6afbff6d21b0956212ae4ec6f33562a"}, "url": "/docs/compare/?release=11.5#11.5-df1e4670d6c8f5ec", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "2e1380da5c384e9841ef99506e57154c", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Require schema qualification to cast to a temporary type when using functional cast syntax", "evidence": {"same_day": true, "patch_ids": ["65b124caa944e034539f5e82e98c754f"], "statement_hash": "6301db346f6b9a542180562e62db8b1ca6afbff6d21b0956212ae4ec6f33562a"}, "url": "/docs/compare/?release=10.10#10.10-df1e4670d6c8f5ec", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "cbafa803ad06f9f27b4bbe75ba7c7e3f", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Require schema qualification to cast to a temporary type when using functional cast syntax", "evidence": {"same_day": true, "patch_ids": ["65b124caa944e034539f5e82e98c754f"], "statement_hash": "6301db346f6b9a542180562e62db8b1ca6afbff6d21b0956212ae4ec6f33562a"}, "url": "/docs/compare/?release=9.6.15#9.6.15-df1e4670d6c8f5ec", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "b1483cae7422c63eb52dc92db4d84965", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Require schema qualification to cast to a temporary type when using functional cast syntax", "evidence": {"same_day": true, "patch_ids": ["65b124caa944e034539f5e82e98c754f"], "statement_hash": "6301db346f6b9a542180562e62db8b1ca6afbff6d21b0956212ae4ec6f33562a"}, "url": "/docs/compare/?release=9.5.19#9.5.19-df1e4670d6c8f5ec", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-c4ecc987984cf907", "cves": [], "html": "<p>Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when altering multiple columns' types in one command (Tom Lane)</p>\n<p>This fixes a regression introduced in the most recent minor releases: indexes using the altered columns were not processed correctly, leading to strange failures during ALTER TABLE.</p>", "text": "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when altering multiple columns' types in one command (Tom Lane) This fixes a regression introduced in the most recent minor releases: indexes using the altered columns were not processed correctly, leading to strange failures during ALTER TABLE.", "title": "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when altering multiple columns' types in one command", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "1d64d706347e05442a6ee8a50e034a51b6cce8377262d4400f2cec149340d278", "section_path": ["Changes"], "commit_groups": [["316f68932", "afaf48afb", "cb8962ce8", "da1041fc3", "ddfb1b2ee", "f946a4091"]], "identity_text": "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when altering multiple columns' types in one command (Tom Lane) This fixes a regression introduced in the most recent minor releases: indexes using the altered columns were not processed correctly, leading to strange failures during ALTER TABLE.", "commit_aliases": ["316f68932", "afaf48afb", "cb8962ce8", "da1041fc3", "ddfb1b2ee", "f946a4091"], "source_commits": ["ddfb1b2ee"], "source_entry_id": "9.4.24/changes/002", "db_id": "2a0bca167f251b2cd29370adec7eaee3", "patch_ids": ["af42394c923a81624887434181501839"], "statement_hash": "6a040d6c69a8e031cc00505b02e82cb4539f0f61d30186a4c5a355d4e50e3433", "relations": [{"rule": 2, "type": "equivalent", "target": "2bc25a84dc95a7781a44f9b4acd4cd68", "evidence": {"same_day": true, "patch_ids": ["af42394c923a81624887434181501839"], "statement_hash": "6a040d6c69a8e031cc00505b02e82cb4539f0f61d30186a4c5a355d4e50e3433"}}, {"rule": 2, "type": "equivalent", "target": "991b2bf86a34a36e3324f983c91aafaf", "evidence": {"same_day": true, "patch_ids": ["af42394c923a81624887434181501839"], "statement_hash": "6a040d6c69a8e031cc00505b02e82cb4539f0f61d30186a4c5a355d4e50e3433"}}, {"rule": 2, "type": "equivalent", "target": "e765c1b126a0441fdebbea41fada1622", "evidence": {"same_day": true, "patch_ids": ["af42394c923a81624887434181501839"], "statement_hash": "6a040d6c69a8e031cc00505b02e82cb4539f0f61d30186a4c5a355d4e50e3433"}}, {"rule": 2, "type": "equivalent", "target": "fe9cbebe5808f24b99c7cb69f70986de", "evidence": {"same_day": true, "patch_ids": ["af42394c923a81624887434181501839"], "statement_hash": "6a040d6c69a8e031cc00505b02e82cb4539f0f61d30186a4c5a355d4e50e3433"}}], "version": "9.4.24", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "e765c1b126a0441fdebbea41fada1622", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when altering multiple columns' types in one command", "evidence": {"same_day": true, "patch_ids": ["af42394c923a81624887434181501839"], "statement_hash": "6a040d6c69a8e031cc00505b02e82cb4539f0f61d30186a4c5a355d4e50e3433"}, "url": "/docs/compare/?release=11.5#11.5-c4ecc987984cf907", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "fe9cbebe5808f24b99c7cb69f70986de", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when altering multiple columns' types in one command", "evidence": {"same_day": true, "patch_ids": ["af42394c923a81624887434181501839"], "statement_hash": "6a040d6c69a8e031cc00505b02e82cb4539f0f61d30186a4c5a355d4e50e3433"}, "url": "/docs/compare/?release=10.10#10.10-c4ecc987984cf907", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "991b2bf86a34a36e3324f983c91aafaf", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when altering multiple columns' types in one command", "evidence": {"same_day": true, "patch_ids": ["af42394c923a81624887434181501839"], "statement_hash": "6a040d6c69a8e031cc00505b02e82cb4539f0f61d30186a4c5a355d4e50e3433"}, "url": "/docs/compare/?release=9.6.15#9.6.15-c4ecc987984cf907", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "2bc25a84dc95a7781a44f9b4acd4cd68", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when altering multiple columns' types in one command", "evidence": {"same_day": true, "patch_ids": ["af42394c923a81624887434181501839"], "statement_hash": "6a040d6c69a8e031cc00505b02e82cb4539f0f61d30186a4c5a355d4e50e3433"}, "url": "/docs/compare/?release=9.5.19#9.5.19-c4ecc987984cf907", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-172682689722fe64", "cves": [], "html": "<p>Fix mishandling of multi-column foreign keys when rebuilding a foreign key constraint (Tom Lane)</p>\n<p>ALTER TABLE could make an incorrect decision about whether revalidation of a foreign key is necessary, if not all columns of the key are of the same type. It seems likely that the error would always have been in the conservative direction, that is revalidating unnecessarily.</p>", "text": "Fix mishandling of multi-column foreign keys when rebuilding a foreign key constraint (Tom Lane) ALTER TABLE could make an incorrect decision about whether revalidation of a foreign key is necessary, if not all columns of the key are of the same type. It seems likely that the error would always have been in the conservative direction, that is revalidating unnecessarily.", "title": "Fix mishandling of multi-column foreign keys when rebuilding a foreign key constraint", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "763b4c728bf503c95a667ae199b76e22ba0797780e01ebf86d9a1be7b9343cec", "section_path": ["Changes"], "commit_groups": [["3093eb2b8", "46e2a18d0", "583025c3c", "67bd6adcb", "a6e7eb42d", "e0d13dc6f", "f9208f246"]], "identity_text": "Fix mishandling of multi-column foreign keys when rebuilding a foreign key constraint (Tom Lane) ALTER TABLE could make an incorrect decision about whether revalidation of a foreign key is necessary, if not all columns of the key are of the same type. It seems likely that the error would always have been in the conservative direction, that is revalidating unnecessarily.", "commit_aliases": ["3093eb2b8", "46e2a18d0", "583025c3c", "67bd6adcb", "a6e7eb42d", "e0d13dc6f", "f9208f246"], "source_commits": ["67bd6adcb"], "source_entry_id": "9.4.24/changes/003", "db_id": "b7fd32db17d9c47e575183542eccac90", "patch_ids": ["e2182a026bceaaf4b5503fe32395729e"], "statement_hash": "89f3fed3ac2dc8f5b25ba7314fcf4f5db75733178068d72305670139d7e1b3b0", "relations": [{"rule": 2, "type": "equivalent", "target": "540cf144bc454fe55e5093cc306867d3", "evidence": {"same_day": true, "patch_ids": ["e2182a026bceaaf4b5503fe32395729e"], "statement_hash": "89f3fed3ac2dc8f5b25ba7314fcf4f5db75733178068d72305670139d7e1b3b0"}}, {"rule": 2, "type": "equivalent", "target": "547a9e601081a21eba115551e7181b39", "evidence": {"same_day": true, "patch_ids": ["e2182a026bceaaf4b5503fe32395729e"], "statement_hash": "89f3fed3ac2dc8f5b25ba7314fcf4f5db75733178068d72305670139d7e1b3b0"}}, {"rule": 2, "type": "equivalent", "target": "8df47d5cf36018f32aeb1d09d5b455df", "evidence": {"same_day": true, "patch_ids": ["e2182a026bceaaf4b5503fe32395729e"], "statement_hash": "89f3fed3ac2dc8f5b25ba7314fcf4f5db75733178068d72305670139d7e1b3b0"}}, {"rule": 2, "type": "equivalent", "target": "c6739c68f9b1734a690345cfc948c4e4", "evidence": {"same_day": true, "patch_ids": ["e2182a026bceaaf4b5503fe32395729e"], "statement_hash": "89f3fed3ac2dc8f5b25ba7314fcf4f5db75733178068d72305670139d7e1b3b0"}}], "version": "9.4.24", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "540cf144bc454fe55e5093cc306867d3", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Fix mishandling of multi-column foreign keys when rebuilding a foreign key constraint", "evidence": {"same_day": true, "patch_ids": ["e2182a026bceaaf4b5503fe32395729e"], "statement_hash": "89f3fed3ac2dc8f5b25ba7314fcf4f5db75733178068d72305670139d7e1b3b0"}, "url": "/docs/compare/?release=11.5#11.5-172682689722fe64", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "c6739c68f9b1734a690345cfc948c4e4", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Fix mishandling of multi-column foreign keys when rebuilding a foreign key constraint", "evidence": {"same_day": true, "patch_ids": ["e2182a026bceaaf4b5503fe32395729e"], "statement_hash": "89f3fed3ac2dc8f5b25ba7314fcf4f5db75733178068d72305670139d7e1b3b0"}, "url": "/docs/compare/?release=10.10#10.10-172682689722fe64", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "547a9e601081a21eba115551e7181b39", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Fix mishandling of multi-column foreign keys when rebuilding a foreign key constraint", "evidence": {"same_day": true, "patch_ids": ["e2182a026bceaaf4b5503fe32395729e"], "statement_hash": "89f3fed3ac2dc8f5b25ba7314fcf4f5db75733178068d72305670139d7e1b3b0"}, "url": "/docs/compare/?release=9.6.15#9.6.15-172682689722fe64", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "8df47d5cf36018f32aeb1d09d5b455df", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Fix mishandling of multi-column foreign keys when rebuilding a foreign key constraint", "evidence": {"same_day": true, "patch_ids": ["e2182a026bceaaf4b5503fe32395729e"], "statement_hash": "89f3fed3ac2dc8f5b25ba7314fcf4f5db75733178068d72305670139d7e1b3b0"}, "url": "/docs/compare/?release=9.5.19#9.5.19-172682689722fe64", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-bde5a490135a01db", "cves": [], "html": "<p>Prevent incorrect canonicalization of date ranges with infinity endpoints (Laurenz Albe)</p>\n<p>It's incorrect to try to convert an open range to a closed one or vice versa by incrementing or decrementing the endpoint value, if the endpoint is infinite; so leave the range alone in such cases.</p>", "text": "Prevent incorrect canonicalization of date ranges with infinity endpoints (Laurenz Albe) It's incorrect to try to convert an open range to a closed one or vice versa by incrementing or decrementing the endpoint value, if the endpoint is infinite; so leave the range alone in such cases.", "title": "Prevent incorrect canonicalization of date ranges with infinity endpoints", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "5cc38ccaf03333c059939b7c92b14a50676ee9d5fe884e847d2ce20c29918a4f", "section_path": ["Changes"], "commit_groups": [["2be355498", "56afeb765", "613eabcd5", "8af1fccba", "955089d4d", "e6feef571", "f5f20deda"], ["390bf90f7", "477ebfc96", "5245552dd", "812623b69", "b0a7e0f07", "b538c90b1", "f1c72294b"]], "identity_text": "Prevent incorrect canonicalization of date ranges with infinity endpoints (Laurenz Albe) It's incorrect to try to convert an open range to a closed one or vice versa by incrementing or decrementing the endpoint value, if the endpoint is infinite; so leave the range alone in such cases.", "commit_aliases": ["2be355498", "390bf90f7", "477ebfc96", "5245552dd", "56afeb765", "613eabcd5", "812623b69", "8af1fccba", "955089d4d", "b0a7e0f07", "b538c90b1", "e6feef571", "f1c72294b", "f5f20deda"], "source_commits": ["2be355498", "812623b69"], "source_entry_id": "9.4.24/changes/004", "db_id": "585f8c17b8fec07d6f69a2cfad6a5816", "patch_ids": ["0055289fede3d0d58f40bc9a5cd8b5c5", "26d2b816955d6b94419cbe84d2fa80a3"], "statement_hash": "b5278a466e61ff1562f82babdb5ea62bf67b661d28881faa1afe55e80afad2c1", "relations": [{"rule": 2, "type": "equivalent", "target": "0e58f3b145870b8f318a43ff5a62ad9a", "evidence": {"same_day": true, "patch_ids": ["0055289fede3d0d58f40bc9a5cd8b5c5", "26d2b816955d6b94419cbe84d2fa80a3"], "statement_hash": "b5278a466e61ff1562f82babdb5ea62bf67b661d28881faa1afe55e80afad2c1"}}, {"rule": 2, "type": "equivalent", "target": "bb52f28cb1b49f77d0d1c61835abdfef", "evidence": {"same_day": true, "patch_ids": ["0055289fede3d0d58f40bc9a5cd8b5c5", "26d2b816955d6b94419cbe84d2fa80a3"], "statement_hash": "b5278a466e61ff1562f82babdb5ea62bf67b661d28881faa1afe55e80afad2c1"}}, {"rule": 2, "type": "equivalent", "target": "bd67eaaa0b0614b83c5bcdda1379baaa", "evidence": {"same_day": true, "patch_ids": ["0055289fede3d0d58f40bc9a5cd8b5c5", "26d2b816955d6b94419cbe84d2fa80a3"], "statement_hash": "b5278a466e61ff1562f82babdb5ea62bf67b661d28881faa1afe55e80afad2c1"}}, {"rule": 2, "type": "equivalent", "target": "fd6b4bdf38695151d42034a3d302f7de", "evidence": {"same_day": true, "patch_ids": ["0055289fede3d0d58f40bc9a5cd8b5c5", "26d2b816955d6b94419cbe84d2fa80a3"], "statement_hash": "b5278a466e61ff1562f82babdb5ea62bf67b661d28881faa1afe55e80afad2c1"}}], "version": "9.4.24", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "0e58f3b145870b8f318a43ff5a62ad9a", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Prevent incorrect canonicalization of date ranges with infinity endpoints", "evidence": {"same_day": true, "patch_ids": ["0055289fede3d0d58f40bc9a5cd8b5c5", "26d2b816955d6b94419cbe84d2fa80a3"], "statement_hash": "b5278a466e61ff1562f82babdb5ea62bf67b661d28881faa1afe55e80afad2c1"}, "url": "/docs/compare/?release=11.5#11.5-bde5a490135a01db", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "bb52f28cb1b49f77d0d1c61835abdfef", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Prevent incorrect canonicalization of date ranges with infinity endpoints", "evidence": {"same_day": true, "patch_ids": ["0055289fede3d0d58f40bc9a5cd8b5c5", "26d2b816955d6b94419cbe84d2fa80a3"], "statement_hash": "b5278a466e61ff1562f82babdb5ea62bf67b661d28881faa1afe55e80afad2c1"}, "url": "/docs/compare/?release=10.10#10.10-bde5a490135a01db", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "bd67eaaa0b0614b83c5bcdda1379baaa", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Prevent incorrect canonicalization of date ranges with infinity endpoints", "evidence": {"same_day": true, "patch_ids": ["0055289fede3d0d58f40bc9a5cd8b5c5", "26d2b816955d6b94419cbe84d2fa80a3"], "statement_hash": "b5278a466e61ff1562f82babdb5ea62bf67b661d28881faa1afe55e80afad2c1"}, "url": "/docs/compare/?release=9.6.15#9.6.15-bde5a490135a01db", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "fd6b4bdf38695151d42034a3d302f7de", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Prevent incorrect canonicalization of date ranges with infinity endpoints", "evidence": {"same_day": true, "patch_ids": ["0055289fede3d0d58f40bc9a5cd8b5c5", "26d2b816955d6b94419cbe84d2fa80a3"], "statement_hash": "b5278a466e61ff1562f82babdb5ea62bf67b661d28881faa1afe55e80afad2c1"}, "url": "/docs/compare/?release=9.5.19#9.5.19-bde5a490135a01db", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-4a16362b56bd5aee", "cves": [], "html": "<p>Fix loss of fractional digits when converting very large money values to numeric (Tom Lane)</p>", "text": "Fix loss of fractional digits when converting very large money values to numeric (Tom Lane)", "title": "Fix loss of fractional digits when converting very large money values to numeric", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "94b1be31b813fc7c92b5b83015f7944cf8847c6708dbf479af48ffdffd0eb535", "section_path": ["Changes"], "commit_groups": [["01e0538e8", "13e493cf6", "30bed9f63", "81b29c871", "b9d2c5c7a", "ca918f99a", "fa854112f"]], "identity_text": "Fix loss of fractional digits when converting very large money values to numeric (Tom Lane)", "commit_aliases": ["01e0538e8", "13e493cf6", "30bed9f63", "81b29c871", "b9d2c5c7a", "ca918f99a", "fa854112f"], "source_commits": ["81b29c871"], "source_entry_id": "9.4.24/changes/005", "db_id": "684d5d8de43f64a2f9375814951dd67c", "patch_ids": ["592963fc1c49c889926948092c98ffce"], "statement_hash": "adfdfefd5571d513e023a105d938103e941a300785a4c78fbb879a238c9d776b", "relations": [{"rule": 2, "type": "equivalent", "target": "16dc15d7906f99d527995e8715273d59", "evidence": {"same_day": true, "patch_ids": ["592963fc1c49c889926948092c98ffce"], "statement_hash": "adfdfefd5571d513e023a105d938103e941a300785a4c78fbb879a238c9d776b"}}, {"rule": 2, "type": "equivalent", "target": "4f3baa03230cea46f9710ff75232f106", "evidence": {"same_day": true, "patch_ids": ["592963fc1c49c889926948092c98ffce"], "statement_hash": "adfdfefd5571d513e023a105d938103e941a300785a4c78fbb879a238c9d776b"}}, {"rule": 2, "type": "equivalent", "target": "dcb7fef54ff9b537a843525e499fe109", "evidence": {"same_day": true, "patch_ids": ["592963fc1c49c889926948092c98ffce"], "statement_hash": "adfdfefd5571d513e023a105d938103e941a300785a4c78fbb879a238c9d776b"}}, {"rule": 2, "type": "equivalent", "target": "ebd3cd01b9fbe01267534ad889c25ccd", "evidence": {"same_day": true, "patch_ids": ["592963fc1c49c889926948092c98ffce"], "statement_hash": "adfdfefd5571d513e023a105d938103e941a300785a4c78fbb879a238c9d776b"}}], "version": "9.4.24", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4f3baa03230cea46f9710ff75232f106", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Fix loss of fractional digits when converting very large money values to numeric", "evidence": {"same_day": true, "patch_ids": ["592963fc1c49c889926948092c98ffce"], "statement_hash": "adfdfefd5571d513e023a105d938103e941a300785a4c78fbb879a238c9d776b"}, "url": "/docs/compare/?release=11.5#11.5-4a16362b56bd5aee", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "16dc15d7906f99d527995e8715273d59", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Fix loss of fractional digits when converting very large money values to numeric", "evidence": {"same_day": true, "patch_ids": ["592963fc1c49c889926948092c98ffce"], "statement_hash": "adfdfefd5571d513e023a105d938103e941a300785a4c78fbb879a238c9d776b"}, "url": "/docs/compare/?release=10.10#10.10-4a16362b56bd5aee", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "dcb7fef54ff9b537a843525e499fe109", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Fix loss of fractional digits when converting very large money values to numeric", "evidence": {"same_day": true, "patch_ids": ["592963fc1c49c889926948092c98ffce"], "statement_hash": "adfdfefd5571d513e023a105d938103e941a300785a4c78fbb879a238c9d776b"}, "url": "/docs/compare/?release=9.6.15#9.6.15-4a16362b56bd5aee", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "ebd3cd01b9fbe01267534ad889c25ccd", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Fix loss of fractional digits when converting very large money values to numeric", "evidence": {"same_day": true, "patch_ids": ["592963fc1c49c889926948092c98ffce"], "statement_hash": "adfdfefd5571d513e023a105d938103e941a300785a4c78fbb879a238c9d776b"}, "url": "/docs/compare/?release=9.5.19#9.5.19-4a16362b56bd5aee", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-b3eae21797ed78e3", "cves": [], "html": "<p>Fix spinlock assembly code for MIPS CPUs so that it works on MIPS r6 (YunQiang Su)</p>", "text": "Fix spinlock assembly code for MIPS CPUs so that it works on MIPS r6 (YunQiang Su)", "title": "Fix spinlock assembly code for MIPS CPUs so that it works on MIPS r6", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "296b8d8079ec31ed44dfa15d0680266fd100ddf648df573e5e4ede81936ea1c4", "section_path": ["Changes"], "commit_groups": [["05399b148", "1323bfce5", "2854e2ab6", "36d2c3ad3", "40dde8290", "9895e3a36"]], "identity_text": "Fix spinlock assembly code for MIPS CPUs so that it works on MIPS r6 (YunQiang Su)", "commit_aliases": ["05399b148", "1323bfce5", "2854e2ab6", "36d2c3ad3", "40dde8290", "9895e3a36"], "source_commits": ["2854e2ab6"], "source_entry_id": "9.4.24/changes/006", "db_id": "148cc89d12926d613b4765f9b06c4e4f", "patch_ids": ["421bea799bfbecfbbc7472b4f27e9621"], "statement_hash": "e32f0f67275a9c8a4eb1604238e8851ca8d3e1cff7308116c2b90be9a4ed8a64", "relations": [{"rule": 2, "type": "equivalent", "target": "4da3a1833367fec8c97699f51233ba82", "evidence": {"same_day": true, "patch_ids": ["421bea799bfbecfbbc7472b4f27e9621"], "statement_hash": "e32f0f67275a9c8a4eb1604238e8851ca8d3e1cff7308116c2b90be9a4ed8a64"}}, {"rule": 2, "type": "equivalent", "target": "7b6e138aaa61876ad696d64a950926f5", "evidence": {"same_day": true, "patch_ids": ["421bea799bfbecfbbc7472b4f27e9621"], "statement_hash": "e32f0f67275a9c8a4eb1604238e8851ca8d3e1cff7308116c2b90be9a4ed8a64"}}, {"rule": 2, "type": "equivalent", "target": "ab19c7cf11419d91689e99bf9e39b9b0", "evidence": {"same_day": true, "patch_ids": ["421bea799bfbecfbbc7472b4f27e9621"], "statement_hash": "e32f0f67275a9c8a4eb1604238e8851ca8d3e1cff7308116c2b90be9a4ed8a64"}}, {"rule": 2, "type": "equivalent", "target": "c0e1e4e25e282e4bf82ab7c2416c1371", "evidence": {"same_day": true, "patch_ids": ["421bea799bfbecfbbc7472b4f27e9621"], "statement_hash": "e32f0f67275a9c8a4eb1604238e8851ca8d3e1cff7308116c2b90be9a4ed8a64"}}], "version": "9.4.24", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "c0e1e4e25e282e4bf82ab7c2416c1371", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Fix spinlock assembly code for MIPS CPUs so that it works on MIPS r6", "evidence": {"same_day": true, "patch_ids": ["421bea799bfbecfbbc7472b4f27e9621"], "statement_hash": "e32f0f67275a9c8a4eb1604238e8851ca8d3e1cff7308116c2b90be9a4ed8a64"}, "url": "/docs/compare/?release=11.5#11.5-b3eae21797ed78e3", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "4da3a1833367fec8c97699f51233ba82", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Fix spinlock assembly code for MIPS CPUs so that it works on MIPS r6", "evidence": {"same_day": true, "patch_ids": ["421bea799bfbecfbbc7472b4f27e9621"], "statement_hash": "e32f0f67275a9c8a4eb1604238e8851ca8d3e1cff7308116c2b90be9a4ed8a64"}, "url": "/docs/compare/?release=10.10#10.10-b3eae21797ed78e3", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "ab19c7cf11419d91689e99bf9e39b9b0", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Fix spinlock assembly code for MIPS CPUs so that it works on MIPS r6", "evidence": {"same_day": true, "patch_ids": ["421bea799bfbecfbbc7472b4f27e9621"], "statement_hash": "e32f0f67275a9c8a4eb1604238e8851ca8d3e1cff7308116c2b90be9a4ed8a64"}, "url": "/docs/compare/?release=9.6.15#9.6.15-b3eae21797ed78e3", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "7b6e138aaa61876ad696d64a950926f5", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Fix spinlock assembly code for MIPS CPUs so that it works on MIPS r6", "evidence": {"same_day": true, "patch_ids": ["421bea799bfbecfbbc7472b4f27e9621"], "statement_hash": "e32f0f67275a9c8a4eb1604238e8851ca8d3e1cff7308116c2b90be9a4ed8a64"}, "url": "/docs/compare/?release=9.5.19#9.5.19-b3eae21797ed78e3", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-bf0f884c1373cce0", "cves": [], "html": "<p>Make <span>libpq</span> ignore carriage return (\\r) in connection service files (Tom Lane, Michael Paquier)</p>\n<p>In some corner cases, service files containing Windows-style newlines could be mis-parsed, resulting in connection failures.</p>", "text": "Make libpq ignore carriage return (\\r) in connection service files (Tom Lane, Michael Paquier) In some corner cases, service files containing Windows-style newlines could be mis-parsed, resulting in connection failures.", "title": "Make libpq ignore carriage return (\\r) in connection service files", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "68edf79da26e258fba74e131b34de3d956eff11a80097d2453b125f0d792d2d4", "section_path": ["Changes"], "commit_groups": [["11a0a4db3", "6266654db", "8c52b77dd", "b654714f9", "ba27151d1", "c58cf97f2", "cb65b454f"]], "identity_text": "Make libpq ignore carriage return (\\r) in connection service files (Tom Lane, Michael Paquier) In some corner cases, service files containing Windows-style newlines could be mis-parsed, resulting in connection failures.", "commit_aliases": ["11a0a4db3", "6266654db", "8c52b77dd", "b654714f9", "ba27151d1", "c58cf97f2", "cb65b454f"], "source_commits": ["8c52b77dd"], "source_entry_id": "9.4.24/changes/007", "db_id": "750f9c95bc91c75e18a3b866f61c9e19", "patch_ids": ["0c52d799489d2d345afa1ce18511da67"], "statement_hash": "c9dcd72eb5cf09f829656e4496e0c3caaac9b1f3b00bac69eb2a91451db56f0f", "relations": [{"rule": 2, "type": "equivalent", "target": "63c59a865186e922f6f9868a577993f7", "evidence": {"same_day": true, "patch_ids": ["0c52d799489d2d345afa1ce18511da67"], "statement_hash": "c9dcd72eb5cf09f829656e4496e0c3caaac9b1f3b00bac69eb2a91451db56f0f"}}, {"rule": 2, "type": "equivalent", "target": "8de98742bede407ff055f3a1f907fa02", "evidence": {"same_day": true, "patch_ids": ["0c52d799489d2d345afa1ce18511da67"], "statement_hash": "c9dcd72eb5cf09f829656e4496e0c3caaac9b1f3b00bac69eb2a91451db56f0f"}}, {"rule": 2, "type": "equivalent", "target": "f0da8881afb51e5188a214dfb856e88f", "evidence": {"same_day": true, "patch_ids": ["0c52d799489d2d345afa1ce18511da67"], "statement_hash": "c9dcd72eb5cf09f829656e4496e0c3caaac9b1f3b00bac69eb2a91451db56f0f"}}, {"rule": 2, "type": "equivalent", "target": "f470297cc97ba5d0f05e547d29143113", "evidence": {"same_day": true, "patch_ids": ["0c52d799489d2d345afa1ce18511da67"], "statement_hash": "c9dcd72eb5cf09f829656e4496e0c3caaac9b1f3b00bac69eb2a91451db56f0f"}}], "version": "9.4.24", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f0da8881afb51e5188a214dfb856e88f", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Make libpq ignore carriage return (\\r) in connection service files", "evidence": {"same_day": true, "patch_ids": ["0c52d799489d2d345afa1ce18511da67"], "statement_hash": "c9dcd72eb5cf09f829656e4496e0c3caaac9b1f3b00bac69eb2a91451db56f0f"}, "url": "/docs/compare/?release=11.5#11.5-bf0f884c1373cce0", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "f470297cc97ba5d0f05e547d29143113", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Make libpq ignore carriage return (\\r) in connection service files", "evidence": {"same_day": true, "patch_ids": ["0c52d799489d2d345afa1ce18511da67"], "statement_hash": "c9dcd72eb5cf09f829656e4496e0c3caaac9b1f3b00bac69eb2a91451db56f0f"}, "url": "/docs/compare/?release=10.10#10.10-bf0f884c1373cce0", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "8de98742bede407ff055f3a1f907fa02", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Make libpq ignore carriage return (\\r) in connection service files", "evidence": {"same_day": true, "patch_ids": ["0c52d799489d2d345afa1ce18511da67"], "statement_hash": "c9dcd72eb5cf09f829656e4496e0c3caaac9b1f3b00bac69eb2a91451db56f0f"}, "url": "/docs/compare/?release=9.6.15#9.6.15-bf0f884c1373cce0", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "63c59a865186e922f6f9868a577993f7", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Make libpq ignore carriage return (\\r) in connection service files", "evidence": {"same_day": true, "patch_ids": ["0c52d799489d2d345afa1ce18511da67"], "statement_hash": "c9dcd72eb5cf09f829656e4496e0c3caaac9b1f3b00bac69eb2a91451db56f0f"}, "url": "/docs/compare/?release=9.5.19#9.5.19-bf0f884c1373cce0", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-ef03274c1cd42ba2", "cves": [], "html": "<p>Fix <span>pg_dump</span> to ensure that custom operator classes are dumped in the right order (Tom Lane)</p>\n<p>If a user-defined opclass is the subtype opclass of a user-defined range type, related objects were dumped in the wrong order, producing an unrestorable dump. (The underlying failure to handle opclass dependencies might manifest in other cases too, but this is the only known case.)</p>", "text": "Fix pg_dump to ensure that custom operator classes are dumped in the right order (Tom Lane) If a user-defined opclass is the subtype opclass of a user-defined range type, related objects were dumped in the wrong order, producing an unrestorable dump. (The underlying failure to handle opclass dependencies might manifest in other cases too, but this is the only known case.)", "title": "Fix pg_dump to ensure that custom operator classes are dumped in the right order", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "2590b20edb4c9a12840633a1050438195302132bdf21a24ac7f3f2539665ea6b", "section_path": ["Changes"], "commit_groups": [["07b39083c", "408f75938", "4e10b6f82", "7615afa48", "9dd74ba5a", "b31a98022", "c64e29705"]], "identity_text": "Fix pg_dump to ensure that custom operator classes are dumped in the right order (Tom Lane) If a user-defined opclass is the subtype opclass of a user-defined range type, related objects were dumped in the wrong order, producing an unrestorable dump. (The underlying failure to handle opclass dependencies might manifest in other cases too, but this is the only known case.)", "commit_aliases": ["07b39083c", "408f75938", "4e10b6f82", "7615afa48", "9dd74ba5a", "b31a98022", "c64e29705"], "source_commits": ["4e10b6f82"], "source_entry_id": "9.4.24/changes/008", "db_id": "9f2677746b49131ad3a83320ad497740", "patch_ids": ["70fdf9c165e267a20afb1eaf20bb5ed5"], "statement_hash": "c6670be03438303a67bb0da4b7b2d26c5d0eb52ea181a8e32fdeb653c42f93de", "relations": [{"rule": 2, "type": "equivalent", "target": "09734321368e7f07237a0d5bde37c769", "evidence": {"same_day": true, "patch_ids": ["70fdf9c165e267a20afb1eaf20bb5ed5"], "statement_hash": "c6670be03438303a67bb0da4b7b2d26c5d0eb52ea181a8e32fdeb653c42f93de"}}, {"rule": 2, "type": "equivalent", "target": "d310270c03e84689653e850517303f19", "evidence": {"same_day": true, "patch_ids": ["70fdf9c165e267a20afb1eaf20bb5ed5"], "statement_hash": "c6670be03438303a67bb0da4b7b2d26c5d0eb52ea181a8e32fdeb653c42f93de"}}, {"rule": 2, "type": "equivalent", "target": "e02a0d241ddabea15ae65033c24244c3", "evidence": {"same_day": true, "patch_ids": ["70fdf9c165e267a20afb1eaf20bb5ed5"], "statement_hash": "c6670be03438303a67bb0da4b7b2d26c5d0eb52ea181a8e32fdeb653c42f93de"}}, {"rule": 2, "type": "equivalent", "target": "e3a9f1a2711f5c8e08a1f2a2f96c8656", "evidence": {"same_day": true, "patch_ids": ["70fdf9c165e267a20afb1eaf20bb5ed5"], "statement_hash": "c6670be03438303a67bb0da4b7b2d26c5d0eb52ea181a8e32fdeb653c42f93de"}}], "version": "9.4.24", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "d310270c03e84689653e850517303f19", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Fix pg_dump to ensure that custom operator classes are dumped in the right order", "evidence": {"same_day": true, "patch_ids": ["70fdf9c165e267a20afb1eaf20bb5ed5"], "statement_hash": "c6670be03438303a67bb0da4b7b2d26c5d0eb52ea181a8e32fdeb653c42f93de"}, "url": "/docs/compare/?release=11.5#11.5-ef03274c1cd42ba2", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "e02a0d241ddabea15ae65033c24244c3", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Fix pg_dump to ensure that custom operator classes are dumped in the right order", "evidence": {"same_day": true, "patch_ids": ["70fdf9c165e267a20afb1eaf20bb5ed5"], "statement_hash": "c6670be03438303a67bb0da4b7b2d26c5d0eb52ea181a8e32fdeb653c42f93de"}, "url": "/docs/compare/?release=10.10#10.10-ef03274c1cd42ba2", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "09734321368e7f07237a0d5bde37c769", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Fix pg_dump to ensure that custom operator classes are dumped in the right order", "evidence": {"same_day": true, "patch_ids": ["70fdf9c165e267a20afb1eaf20bb5ed5"], "statement_hash": "c6670be03438303a67bb0da4b7b2d26c5d0eb52ea181a8e32fdeb653c42f93de"}, "url": "/docs/compare/?release=9.6.15#9.6.15-ef03274c1cd42ba2", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "e3a9f1a2711f5c8e08a1f2a2f96c8656", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Fix pg_dump to ensure that custom operator classes are dumped in the right order", "evidence": {"same_day": true, "patch_ids": ["70fdf9c165e267a20afb1eaf20bb5ed5"], "statement_hash": "c6670be03438303a67bb0da4b7b2d26c5d0eb52ea181a8e32fdeb653c42f93de"}, "url": "/docs/compare/?release=9.5.19#9.5.19-ef03274c1cd42ba2", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-7f1a9a75793f2316", "cves": [], "html": "<p>Fix contrib/passwordcheck to coexist with other users of check_password_hook (Michael Paquier)</p>", "text": "Fix contrib/passwordcheck to coexist with other users of check_password_hook (Michael Paquier)", "title": "Fix contrib/passwordcheck to coexist with other users of check_password_hook", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "393a9fa361ab2a35921dd58a1ce9ac372bccd36a835795a429548ab7fd6b72e1", "section_path": ["Changes"], "commit_groups": [["20f5cb195", "4536e494f", "957b822b5", "a7eb28d0c", "b2a3d706b", "cb0074417", "eea28a3cb"]], "identity_text": "Fix contrib/passwordcheck to coexist with other users of check_password_hook (Michael Paquier)", "commit_aliases": ["20f5cb195", "4536e494f", "957b822b5", "a7eb28d0c", "b2a3d706b", "cb0074417", "eea28a3cb"], "source_commits": ["eea28a3cb"], "source_entry_id": "9.4.24/changes/009", "db_id": "bd0b9493e717514df4b87e129c03a91d", "patch_ids": ["53194b916cc16779b91a5234ee5f6537"], "statement_hash": "a1666b6fa5abd9f7cdb7b486fd6ee3f361fcb92b3f39cfe98a46bfd46f548a00", "relations": [{"rule": 2, "type": "equivalent", "target": "4c10491c391eb08e2ee611428186d6fb", "evidence": {"same_day": true, "patch_ids": ["53194b916cc16779b91a5234ee5f6537"], "statement_hash": "a1666b6fa5abd9f7cdb7b486fd6ee3f361fcb92b3f39cfe98a46bfd46f548a00"}}, {"rule": 2, "type": "equivalent", "target": "7176d75b344cf415db5014720bc53cd4", "evidence": {"same_day": true, "patch_ids": ["53194b916cc16779b91a5234ee5f6537"], "statement_hash": "a1666b6fa5abd9f7cdb7b486fd6ee3f361fcb92b3f39cfe98a46bfd46f548a00"}}, {"rule": 2, "type": "equivalent", "target": "da912bf84ad3684545dca24b0b21d950", "evidence": {"same_day": true, "patch_ids": ["53194b916cc16779b91a5234ee5f6537"], "statement_hash": "a1666b6fa5abd9f7cdb7b486fd6ee3f361fcb92b3f39cfe98a46bfd46f548a00"}}, {"rule": 2, "type": "equivalent", "target": "eed66cc7c792fcaa4b1de1a0ddd5b38c", "evidence": {"same_day": true, "patch_ids": ["53194b916cc16779b91a5234ee5f6537"], "statement_hash": "a1666b6fa5abd9f7cdb7b486fd6ee3f361fcb92b3f39cfe98a46bfd46f548a00"}}], "version": "9.4.24", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "eed66cc7c792fcaa4b1de1a0ddd5b38c", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Fix contrib/passwordcheck to coexist with other users of check_password_hook", "evidence": {"same_day": true, "patch_ids": ["53194b916cc16779b91a5234ee5f6537"], "statement_hash": "a1666b6fa5abd9f7cdb7b486fd6ee3f361fcb92b3f39cfe98a46bfd46f548a00"}, "url": "/docs/compare/?release=11.5#11.5-7f1a9a75793f2316", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "da912bf84ad3684545dca24b0b21d950", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Fix contrib/passwordcheck to coexist with other users of check_password_hook", "evidence": {"same_day": true, "patch_ids": ["53194b916cc16779b91a5234ee5f6537"], "statement_hash": "a1666b6fa5abd9f7cdb7b486fd6ee3f361fcb92b3f39cfe98a46bfd46f548a00"}, "url": "/docs/compare/?release=10.10#10.10-7f1a9a75793f2316", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "7176d75b344cf415db5014720bc53cd4", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Fix contrib/passwordcheck to coexist with other users of check_password_hook", "evidence": {"same_day": true, "patch_ids": ["53194b916cc16779b91a5234ee5f6537"], "statement_hash": "a1666b6fa5abd9f7cdb7b486fd6ee3f361fcb92b3f39cfe98a46bfd46f548a00"}, "url": "/docs/compare/?release=9.6.15#9.6.15-7f1a9a75793f2316", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "4c10491c391eb08e2ee611428186d6fb", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Fix contrib/passwordcheck to coexist with other users of check_password_hook", "evidence": {"same_day": true, "patch_ids": ["53194b916cc16779b91a5234ee5f6537"], "statement_hash": "a1666b6fa5abd9f7cdb7b486fd6ee3f361fcb92b3f39cfe98a46bfd46f548a00"}, "url": "/docs/compare/?release=9.5.19#9.5.19-7f1a9a75793f2316", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-2541f968ec49bf76", "cves": [], "html": "<p>Fix contrib/sepgsql tests to work under recent SELinux releases (Mike Palmiotto)</p>", "text": "Fix contrib/sepgsql tests to work under recent SELinux releases (Mike Palmiotto)", "title": "Fix contrib/sepgsql tests to work under recent SELinux releases", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "b4a7469b1a091622c9afbc489478c92a6b09a09ba36aed7889e722b70cc96def", "section_path": ["Changes"], "commit_groups": [["0a9ba5baa", "0e259d4bc", "5a1c61bdf", "5c3d47287", "665329abe", "b22e24983", "f5a4ab23e"]], "identity_text": "Fix contrib/sepgsql tests to work under recent SELinux releases (Mike Palmiotto)", "commit_aliases": ["0a9ba5baa", "0e259d4bc", "5a1c61bdf", "5c3d47287", "665329abe", "b22e24983", "f5a4ab23e"], "source_commits": ["0e259d4bc"], "source_entry_id": "9.4.24/changes/010", "db_id": "158e66ff651071a0087d2dcd8b63edfb", "patch_ids": ["ab3a51382f318a17cef31ba82a144ce8"], "statement_hash": "aa2db5f039c0978384f136e095ecc68dbf48f9752e08d708ac9735c201e60a71", "relations": [{"rule": 2, "type": "equivalent", "target": "1557899b72777b524a07807efdfa8e12", "evidence": {"same_day": true, "patch_ids": ["ab3a51382f318a17cef31ba82a144ce8"], "statement_hash": "aa2db5f039c0978384f136e095ecc68dbf48f9752e08d708ac9735c201e60a71"}}, {"rule": 2, "type": "equivalent", "target": "6b633c815eff75f6064683878c2e8569", "evidence": {"same_day": true, "patch_ids": ["ab3a51382f318a17cef31ba82a144ce8"], "statement_hash": "aa2db5f039c0978384f136e095ecc68dbf48f9752e08d708ac9735c201e60a71"}}, {"rule": 2, "type": "equivalent", "target": "cc4c7c0fe2c130d0a351021380e44790", "evidence": {"same_day": true, "patch_ids": ["ab3a51382f318a17cef31ba82a144ce8"], "statement_hash": "aa2db5f039c0978384f136e095ecc68dbf48f9752e08d708ac9735c201e60a71"}}, {"rule": 2, "type": "equivalent", "target": "d48dc89df9bf06cc4a261afa2a1cf979", "evidence": {"same_day": true, "patch_ids": ["ab3a51382f318a17cef31ba82a144ce8"], "statement_hash": "aa2db5f039c0978384f136e095ecc68dbf48f9752e08d708ac9735c201e60a71"}}], "version": "9.4.24", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "cc4c7c0fe2c130d0a351021380e44790", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Fix contrib/sepgsql tests to work under recent SELinux releases", "evidence": {"same_day": true, "patch_ids": ["ab3a51382f318a17cef31ba82a144ce8"], "statement_hash": "aa2db5f039c0978384f136e095ecc68dbf48f9752e08d708ac9735c201e60a71"}, "url": "/docs/compare/?release=11.5#11.5-2541f968ec49bf76", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "d48dc89df9bf06cc4a261afa2a1cf979", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Fix contrib/sepgsql tests to work under recent SELinux releases", "evidence": {"same_day": true, "patch_ids": ["ab3a51382f318a17cef31ba82a144ce8"], "statement_hash": "aa2db5f039c0978384f136e095ecc68dbf48f9752e08d708ac9735c201e60a71"}, "url": "/docs/compare/?release=10.10#10.10-2541f968ec49bf76", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "6b633c815eff75f6064683878c2e8569", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Fix contrib/sepgsql tests to work under recent SELinux releases", "evidence": {"same_day": true, "patch_ids": ["ab3a51382f318a17cef31ba82a144ce8"], "statement_hash": "aa2db5f039c0978384f136e095ecc68dbf48f9752e08d708ac9735c201e60a71"}, "url": "/docs/compare/?release=9.6.15#9.6.15-2541f968ec49bf76", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "1557899b72777b524a07807efdfa8e12", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Fix contrib/sepgsql tests to work under recent SELinux releases", "evidence": {"same_day": true, "patch_ids": ["ab3a51382f318a17cef31ba82a144ce8"], "statement_hash": "aa2db5f039c0978384f136e095ecc68dbf48f9752e08d708ac9735c201e60a71"}, "url": "/docs/compare/?release=9.5.19#9.5.19-2541f968ec49bf76", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-766e0f4a740a94dc", "cves": [], "html": "<p>Reduce <span>stderr</span> output from <span>pg_upgrade</span>'s test script (Tom Lane)</p>", "text": "Reduce stderr output from pg_upgrade's test script (Tom Lane)", "title": "Reduce stderr output from pg_upgrade's test script", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "7b17de229b7d7e3ff2692af88479f1d0d94d0f5ff460486c3041ab9fba708739", "section_path": ["Changes"], "commit_groups": [["19f9a5aed", "69c3d5191", "75348a733", "7ac7bf50c", "8d21512dc", "eb9812f27"]], "identity_text": "Reduce stderr output from pg_upgrade's test script (Tom Lane)", "commit_aliases": ["19f9a5aed", "69c3d5191", "75348a733", "7ac7bf50c", "8d21512dc", "eb9812f27"], "source_commits": ["19f9a5aed"], "source_entry_id": "9.4.24/changes/011", "db_id": "0695b3b425f25682abe75ef8010043a3", "patch_ids": ["280e12f8c3cc8d9d9eefcc0580820a84"], "statement_hash": "1c2e03648bfb3c05447129cb79c510fca3857f406bf1153e284ec8e996d7392c", "relations": [{"rule": 2, "type": "equivalent", "target": "79ce47cd56b0d700706ef94f5489a57f", "evidence": {"same_day": true, "patch_ids": ["280e12f8c3cc8d9d9eefcc0580820a84"], "statement_hash": "1c2e03648bfb3c05447129cb79c510fca3857f406bf1153e284ec8e996d7392c"}}, {"rule": 2, "type": "equivalent", "target": "9987687f82c177fb959d7cb535d38b96", "evidence": {"same_day": true, "patch_ids": ["280e12f8c3cc8d9d9eefcc0580820a84"], "statement_hash": "1c2e03648bfb3c05447129cb79c510fca3857f406bf1153e284ec8e996d7392c"}}, {"rule": 2, "type": "equivalent", "target": "f9e5fb6aaa2c517552f01d29ff6f329d", "evidence": {"same_day": true, "patch_ids": ["280e12f8c3cc8d9d9eefcc0580820a84"], "statement_hash": "1c2e03648bfb3c05447129cb79c510fca3857f406bf1153e284ec8e996d7392c"}}, {"rule": 2, "type": "equivalent", "target": "fcbb60aeb52f513e8aa4412ec25a5680", "evidence": {"same_day": true, "patch_ids": ["280e12f8c3cc8d9d9eefcc0580820a84"], "statement_hash": "1c2e03648bfb3c05447129cb79c510fca3857f406bf1153e284ec8e996d7392c"}}], "version": "9.4.24", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "f9e5fb6aaa2c517552f01d29ff6f329d", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Reduce stderr output from pg_upgrade's test script", "evidence": {"same_day": true, "patch_ids": ["280e12f8c3cc8d9d9eefcc0580820a84"], "statement_hash": "1c2e03648bfb3c05447129cb79c510fca3857f406bf1153e284ec8e996d7392c"}, "url": "/docs/compare/?release=11.5#11.5-766e0f4a740a94dc", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "fcbb60aeb52f513e8aa4412ec25a5680", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Reduce stderr output from pg_upgrade's test script", "evidence": {"same_day": true, "patch_ids": ["280e12f8c3cc8d9d9eefcc0580820a84"], "statement_hash": "1c2e03648bfb3c05447129cb79c510fca3857f406bf1153e284ec8e996d7392c"}, "url": "/docs/compare/?release=10.10#10.10-766e0f4a740a94dc", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "79ce47cd56b0d700706ef94f5489a57f", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Reduce stderr output from pg_upgrade's test script", "evidence": {"same_day": true, "patch_ids": ["280e12f8c3cc8d9d9eefcc0580820a84"], "statement_hash": "1c2e03648bfb3c05447129cb79c510fca3857f406bf1153e284ec8e996d7392c"}, "url": "/docs/compare/?release=9.6.15#9.6.15-766e0f4a740a94dc", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "9987687f82c177fb959d7cb535d38b96", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Reduce stderr output from pg_upgrade's test script", "evidence": {"same_day": true, "patch_ids": ["280e12f8c3cc8d9d9eefcc0580820a84"], "statement_hash": "1c2e03648bfb3c05447129cb79c510fca3857f406bf1153e284ec8e996d7392c"}, "url": "/docs/compare/?release=9.5.19#9.5.19-766e0f4a740a94dc", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-58b13d00091fd3c5", "cves": [], "html": "<p>Support building Postgres with Microsoft Visual Studio 2019 (Haribabu Kommi)</p>", "text": "Support building Postgres with Microsoft Visual Studio 2019 (Haribabu Kommi)", "title": "Support building Postgres with Microsoft Visual Studio 2019", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "ac6102c0f251708432b0bc309c2124ed830963e56a75a841a620ea4f3d506195", "section_path": ["Changes"], "commit_groups": [["0ce8e49b2", "2b1394fc2", "3337fd192", "721963f24", "78aaffd28", "d49c127d9", "f2d069ce9"]], "identity_text": "Support building Postgres with Microsoft Visual Studio 2019 (Haribabu Kommi)", "commit_aliases": ["0ce8e49b2", "2b1394fc2", "3337fd192", "721963f24", "78aaffd28", "d49c127d9", "f2d069ce9"], "source_commits": ["d49c127d9"], "source_entry_id": "9.4.24/changes/012", "db_id": "632436228109ad3b9a3483b7759ec462", "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"], "statement_hash": "aebd4f123e80468f8ba227c891312aade7ff6a7695376ec29d541c28d64d4f9e", "relations": [{"rule": 2, "type": "equivalent", "target": "0e81425d9ba9c954cffb7949ff2b81c0", "evidence": {"same_day": true, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"], "statement_hash": "aebd4f123e80468f8ba227c891312aade7ff6a7695376ec29d541c28d64d4f9e"}}, {"rule": 2, "type": "related", "target": "1db6a4dc5fd31f460b731b1b06a65ee3", "evidence": {"same_day": false, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"]}}, {"rule": 2, "type": "equivalent", "target": "21e7e56d3db692178fb7d0bd54fe6e57", "evidence": {"same_day": true, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"], "statement_hash": "aebd4f123e80468f8ba227c891312aade7ff6a7695376ec29d541c28d64d4f9e"}}, {"rule": 2, "type": "equivalent", "target": "4b8c493fb7f376ba153f22dbdad54767", "evidence": {"same_day": true, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"], "statement_hash": "aebd4f123e80468f8ba227c891312aade7ff6a7695376ec29d541c28d64d4f9e"}}, {"rule": 2, "type": "equivalent", "target": "f70b8de3c87cd0730cef6bf5df43d9ae", "evidence": {"same_day": true, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"], "statement_hash": "aebd4f123e80468f8ba227c891312aade7ff6a7695376ec29d541c28d64d4f9e"}}], "version": "9.4.24", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "1db6a4dc5fd31f460b731b1b06a65ee3", "kind": "related", "version": "13.0", "label": "13.0", "title": "Add support for building on Visual Studio 2019", "evidence": {"same_day": false, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"]}, "url": "/docs/compare/?release=13.0#13.0-a7359873726eaf5e", "source_url": "/docs/release/13.0/#id-1.11.6.29.5.13"}, {"db_id": "21e7e56d3db692178fb7d0bd54fe6e57", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Support building Postgres with Microsoft Visual Studio 2019", "evidence": {"same_day": true, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"], "statement_hash": "aebd4f123e80468f8ba227c891312aade7ff6a7695376ec29d541c28d64d4f9e"}, "url": "/docs/compare/?release=11.5#11.5-58b13d00091fd3c5", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "4b8c493fb7f376ba153f22dbdad54767", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Support building Postgres with Microsoft Visual Studio 2019", "evidence": {"same_day": true, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"], "statement_hash": "aebd4f123e80468f8ba227c891312aade7ff6a7695376ec29d541c28d64d4f9e"}, "url": "/docs/compare/?release=10.10#10.10-58b13d00091fd3c5", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "0e81425d9ba9c954cffb7949ff2b81c0", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Support building Postgres with Microsoft Visual Studio 2019", "evidence": {"same_day": true, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"], "statement_hash": "aebd4f123e80468f8ba227c891312aade7ff6a7695376ec29d541c28d64d4f9e"}, "url": "/docs/compare/?release=9.6.15#9.6.15-58b13d00091fd3c5", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "f70b8de3c87cd0730cef6bf5df43d9ae", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Support building Postgres with Microsoft Visual Studio 2019", "evidence": {"same_day": true, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"], "statement_hash": "aebd4f123e80468f8ba227c891312aade7ff6a7695376ec29d541c28d64d4f9e"}, "url": "/docs/compare/?release=9.5.19#9.5.19-58b13d00091fd3c5", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-c3916aa534e57181", "cves": [], "html": "<p>In Visual Studio builds, honor WindowsSDKVersion environment variable, if that's set (Peifeng Qiu)</p>\n<p>This fixes build failures in some configurations.</p>", "text": "In Visual Studio builds, honor WindowsSDKVersion environment variable, if that's set (Peifeng Qiu) This fixes build failures in some configurations.", "title": "In Visual Studio builds, honor WindowsSDKVersion environment variable, if that's set", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "4191bbc291798eda4f8158e9a03a0c872dccb0e8234ac32651b24abf556dfec6", "section_path": ["Changes"], "commit_groups": [["09fa17160", "165f4eecf", "20e99cddd", "4f435f78d", "53fd0f04b", "6e5417d77", "fe9e63284"], ["3f1c6d048", "4583605e6", "7ea91ae19", "b24537046", "cb9bb1578", "e465d9d40", "ed304d1e2"]], "identity_text": "In Visual Studio builds, honor WindowsSDKVersion environment variable, if that's set (Peifeng Qiu) This fixes build failures in some configurations.", "commit_aliases": ["09fa17160", "165f4eecf", "20e99cddd", "3f1c6d048", "4583605e6", "4f435f78d", "53fd0f04b", "6e5417d77", "7ea91ae19", "b24537046", "cb9bb1578", "e465d9d40", "ed304d1e2", "fe9e63284"], "source_commits": ["53fd0f04b", "7ea91ae19"], "source_entry_id": "9.4.24/changes/013", "db_id": "080ea81d99bca631642ed1052021fd5e", "patch_ids": ["0b0a0208e4eed00a5ee2853baef70360", "dc70b4b23a093a0f13ae1bed10ebc6a5"], "statement_hash": "c94deba12594ee7753416d13cf77fdefdf50c47db2b032a919e8bd327819dd3e", "relations": [{"rule": 2, "type": "equivalent", "target": "3a1b5f6bba74f14d3b97062ac69c3101", "evidence": {"same_day": true, "patch_ids": ["0b0a0208e4eed00a5ee2853baef70360", "dc70b4b23a093a0f13ae1bed10ebc6a5"], "statement_hash": "c94deba12594ee7753416d13cf77fdefdf50c47db2b032a919e8bd327819dd3e"}}, {"rule": 2, "type": "equivalent", "target": "3cf6799c0a9b5dddba8d392a0c1a5057", "evidence": {"same_day": true, "patch_ids": ["0b0a0208e4eed00a5ee2853baef70360", "dc70b4b23a093a0f13ae1bed10ebc6a5"], "statement_hash": "c94deba12594ee7753416d13cf77fdefdf50c47db2b032a919e8bd327819dd3e"}}, {"rule": 2, "type": "equivalent", "target": "cb729d691b36ad57b8100562180a6149", "evidence": {"same_day": true, "patch_ids": ["0b0a0208e4eed00a5ee2853baef70360", "dc70b4b23a093a0f13ae1bed10ebc6a5"], "statement_hash": "c94deba12594ee7753416d13cf77fdefdf50c47db2b032a919e8bd327819dd3e"}}, {"rule": 2, "type": "equivalent", "target": "f1a428c57186ca5712e2e8c40a2cc3b0", "evidence": {"same_day": true, "patch_ids": ["0b0a0208e4eed00a5ee2853baef70360", "dc70b4b23a093a0f13ae1bed10ebc6a5"], "statement_hash": "c94deba12594ee7753416d13cf77fdefdf50c47db2b032a919e8bd327819dd3e"}}], "version": "9.4.24", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "cb729d691b36ad57b8100562180a6149", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "In Visual Studio builds, honor WindowsSDKVersion environment variable, if that's set", "evidence": {"same_day": true, "patch_ids": ["0b0a0208e4eed00a5ee2853baef70360", "dc70b4b23a093a0f13ae1bed10ebc6a5"], "statement_hash": "c94deba12594ee7753416d13cf77fdefdf50c47db2b032a919e8bd327819dd3e"}, "url": "/docs/compare/?release=11.5#11.5-c3916aa534e57181", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "f1a428c57186ca5712e2e8c40a2cc3b0", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "In Visual Studio builds, honor WindowsSDKVersion environment variable, if that's set", "evidence": {"same_day": true, "patch_ids": ["0b0a0208e4eed00a5ee2853baef70360", "dc70b4b23a093a0f13ae1bed10ebc6a5"], "statement_hash": "c94deba12594ee7753416d13cf77fdefdf50c47db2b032a919e8bd327819dd3e"}, "url": "/docs/compare/?release=10.10#10.10-c3916aa534e57181", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "3cf6799c0a9b5dddba8d392a0c1a5057", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "In Visual Studio builds, honor WindowsSDKVersion environment variable, if that's set", "evidence": {"same_day": true, "patch_ids": ["0b0a0208e4eed00a5ee2853baef70360", "dc70b4b23a093a0f13ae1bed10ebc6a5"], "statement_hash": "c94deba12594ee7753416d13cf77fdefdf50c47db2b032a919e8bd327819dd3e"}, "url": "/docs/compare/?release=9.6.15#9.6.15-c3916aa534e57181", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "3a1b5f6bba74f14d3b97062ac69c3101", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "In Visual Studio builds, honor WindowsSDKVersion environment variable, if that's set", "evidence": {"same_day": true, "patch_ids": ["0b0a0208e4eed00a5ee2853baef70360", "dc70b4b23a093a0f13ae1bed10ebc6a5"], "statement_hash": "c94deba12594ee7753416d13cf77fdefdf50c47db2b032a919e8bd327819dd3e"}, "url": "/docs/compare/?release=9.5.19#9.5.19-c3916aa534e57181", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-c4b7404fab589472", "cves": [], "html": "<p>Support OpenSSL 1.1.0 and newer in Visual Studio builds (Juan José Santamaría Flecha, Michael Paquier)</p>", "text": "Support OpenSSL 1.1.0 and newer in Visual Studio builds (Juan José Santamaría Flecha, Michael Paquier)", "title": "Support OpenSSL 1.1.0 and newer in Visual Studio builds", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "a2591b2d4fd2b2261ca96f02a8647dd006ff405b4ccefbdf5162d49fdd6113d1", "section_path": ["Changes"], "commit_groups": [["05b2758c3", "0e08a3a1f", "532960669", "a55980559", "d908a0087", "d993e0fb8"]], "identity_text": "Support OpenSSL 1.1.0 and newer in Visual Studio builds (Juan José Santamaría Flecha, Michael Paquier)", "commit_aliases": ["05b2758c3", "0e08a3a1f", "532960669", "a55980559", "d908a0087", "d993e0fb8"], "source_commits": ["05b2758c3"], "source_entry_id": "9.4.24/changes/014", "db_id": "585e5d8fbdcd12f97da18b21f2f71830", "patch_ids": ["562b6d58209e71365c6277368696b322"], "statement_hash": "b3cf545640f7dcb4fb99fe9daf559d06b296bff2dc60bb0fd3590e06df3c8e0b", "relations": [{"rule": 2, "type": "equivalent", "target": "146944c3eb978b894ef9dbce813b51c5", "evidence": {"same_day": true, "patch_ids": ["562b6d58209e71365c6277368696b322"], "statement_hash": "b3cf545640f7dcb4fb99fe9daf559d06b296bff2dc60bb0fd3590e06df3c8e0b"}}, {"rule": 2, "type": "equivalent", "target": "308b14a4c61b88fd5d3d03a271606193", "evidence": {"same_day": true, "patch_ids": ["562b6d58209e71365c6277368696b322"], "statement_hash": "b3cf545640f7dcb4fb99fe9daf559d06b296bff2dc60bb0fd3590e06df3c8e0b"}}, {"rule": 2, "type": "equivalent", "target": "3376f057c8d57fa49f9ba4d4948f3a8c", "evidence": {"same_day": true, "patch_ids": ["562b6d58209e71365c6277368696b322"], "statement_hash": "b3cf545640f7dcb4fb99fe9daf559d06b296bff2dc60bb0fd3590e06df3c8e0b"}}, {"rule": 2, "type": "equivalent", "target": "b5dd8a7d13a16a5383dd9a7459c32830", "evidence": {"same_day": true, "patch_ids": ["562b6d58209e71365c6277368696b322"], "statement_hash": "b3cf545640f7dcb4fb99fe9daf559d06b296bff2dc60bb0fd3590e06df3c8e0b"}}], "version": "9.4.24", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "3376f057c8d57fa49f9ba4d4948f3a8c", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Support OpenSSL 1.1.0 and newer in Visual Studio builds", "evidence": {"same_day": true, "patch_ids": ["562b6d58209e71365c6277368696b322"], "statement_hash": "b3cf545640f7dcb4fb99fe9daf559d06b296bff2dc60bb0fd3590e06df3c8e0b"}, "url": "/docs/compare/?release=11.5#11.5-c4b7404fab589472", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "308b14a4c61b88fd5d3d03a271606193", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Support OpenSSL 1.1.0 and newer in Visual Studio builds", "evidence": {"same_day": true, "patch_ids": ["562b6d58209e71365c6277368696b322"], "statement_hash": "b3cf545640f7dcb4fb99fe9daf559d06b296bff2dc60bb0fd3590e06df3c8e0b"}, "url": "/docs/compare/?release=10.10#10.10-c4b7404fab589472", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "b5dd8a7d13a16a5383dd9a7459c32830", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Support OpenSSL 1.1.0 and newer in Visual Studio builds", "evidence": {"same_day": true, "patch_ids": ["562b6d58209e71365c6277368696b322"], "statement_hash": "b3cf545640f7dcb4fb99fe9daf559d06b296bff2dc60bb0fd3590e06df3c8e0b"}, "url": "/docs/compare/?release=9.6.15#9.6.15-c4b7404fab589472", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "146944c3eb978b894ef9dbce813b51c5", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Support OpenSSL 1.1.0 and newer in Visual Studio builds", "evidence": {"same_day": true, "patch_ids": ["562b6d58209e71365c6277368696b322"], "statement_hash": "b3cf545640f7dcb4fb99fe9daf559d06b296bff2dc60bb0fd3590e06df3c8e0b"}, "url": "/docs/compare/?release=9.5.19#9.5.19-c4b7404fab589472", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-c91b4840d57e40b9", "cves": [], "html": "<p>Avoid choosing localtime or posixrules as TimeZone during <span>initdb</span> (Tom Lane)</p>\n<p>In some cases <span>initdb</span> would choose one of these artificial zone names over the <span>\"real\"</span> zone name. Prefer any other match to the C library's timezone behavior over these two.</p>", "text": "Avoid choosing localtime or posixrules as TimeZone during initdb (Tom Lane) In some cases initdb would choose one of these artificial zone names over the \"real\" zone name. Prefer any other match to the C library's timezone behavior over these two.", "title": "Avoid choosing localtime or posixrules as TimeZone during initdb", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "245c6d78e81682bd0caec4dc4d03ff24efb68d7ca6107ae07171ed9eb4d3b940", "section_path": ["Changes"], "commit_groups": [["3754113f3", "4459266bf", "51b47471f", "6c4ffab76", "9ef811742", "ae9b91be7", "e31dfe99c"]], "identity_text": "Avoid choosing localtime or posixrules as TimeZone during initdb (Tom Lane) In some cases initdb would choose one of these artificial zone names over the real zone name. Prefer any other match to the C library's timezone behavior over these two.", "commit_aliases": ["3754113f3", "4459266bf", "51b47471f", "6c4ffab76", "9ef811742", "ae9b91be7", "e31dfe99c"], "source_commits": ["6c4ffab76"], "source_entry_id": "9.4.24/changes/015", "db_id": "df87d555f2babb058977abd9daf3ecfd", "patch_ids": ["fd131fa8b8a4461a6064daa8fe8c1db0"], "statement_hash": "35ffa55d1deeb8d498068ccdd098deef71049f39677b2bc78488c831419c6568", "relations": [{"rule": 2, "type": "equivalent", "target": "033ba373303032af152d3ad2101f38ca", "evidence": {"same_day": true, "patch_ids": ["fd131fa8b8a4461a6064daa8fe8c1db0"], "statement_hash": "35ffa55d1deeb8d498068ccdd098deef71049f39677b2bc78488c831419c6568"}}, {"rule": 2, "type": "equivalent", "target": "5a13f504e355439184c44ee579a48f82", "evidence": {"same_day": true, "patch_ids": ["fd131fa8b8a4461a6064daa8fe8c1db0"], "statement_hash": "35ffa55d1deeb8d498068ccdd098deef71049f39677b2bc78488c831419c6568"}}, {"rule": 2, "type": "equivalent", "target": "75c54bce7e00f2302122362de847a5b0", "evidence": {"same_day": true, "patch_ids": ["fd131fa8b8a4461a6064daa8fe8c1db0"], "statement_hash": "35ffa55d1deeb8d498068ccdd098deef71049f39677b2bc78488c831419c6568"}}, {"rule": 2, "type": "equivalent", "target": "77053372da7af5c46b1bec1d886d85a8", "evidence": {"same_day": true, "patch_ids": ["fd131fa8b8a4461a6064daa8fe8c1db0"], "statement_hash": "35ffa55d1deeb8d498068ccdd098deef71049f39677b2bc78488c831419c6568"}}], "version": "9.4.24", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "77053372da7af5c46b1bec1d886d85a8", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Avoid choosing localtime or posixrules as TimeZone during initdb", "evidence": {"same_day": true, "patch_ids": ["fd131fa8b8a4461a6064daa8fe8c1db0"], "statement_hash": "35ffa55d1deeb8d498068ccdd098deef71049f39677b2bc78488c831419c6568"}, "url": "/docs/compare/?release=11.5#11.5-c91b4840d57e40b9", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "033ba373303032af152d3ad2101f38ca", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Avoid choosing localtime or posixrules as TimeZone during initdb", "evidence": {"same_day": true, "patch_ids": ["fd131fa8b8a4461a6064daa8fe8c1db0"], "statement_hash": "35ffa55d1deeb8d498068ccdd098deef71049f39677b2bc78488c831419c6568"}, "url": "/docs/compare/?release=10.10#10.10-c91b4840d57e40b9", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "75c54bce7e00f2302122362de847a5b0", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Avoid choosing localtime or posixrules as TimeZone during initdb", "evidence": {"same_day": true, "patch_ids": ["fd131fa8b8a4461a6064daa8fe8c1db0"], "statement_hash": "35ffa55d1deeb8d498068ccdd098deef71049f39677b2bc78488c831419c6568"}, "url": "/docs/compare/?release=9.6.15#9.6.15-c91b4840d57e40b9", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "5a13f504e355439184c44ee579a48f82", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Avoid choosing localtime or posixrules as TimeZone during initdb", "evidence": {"same_day": true, "patch_ids": ["fd131fa8b8a4461a6064daa8fe8c1db0"], "statement_hash": "35ffa55d1deeb8d498068ccdd098deef71049f39677b2bc78488c831419c6568"}, "url": "/docs/compare/?release=9.5.19#9.5.19-c91b4840d57e40b9", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-ae1a5672e8d0d548", "cves": [], "html": "<p>Adjust pg_timezone_names view to show the Factory time zone if and only if it has a short abbreviation (Tom Lane)</p>\n<p>Historically, IANA set up this artificial zone with an <span>\"abbreviation\"</span> like Local time zone must be set--see zic manual page. Modern versions of the tzdb database show -00 instead, but some platforms alter the data to show one or another of the historical phrases. Show this zone only if it uses the modern abbreviation.</p>", "text": "Adjust pg_timezone_names view to show the Factory time zone if and only if it has a short abbreviation (Tom Lane) Historically, IANA set up this artificial zone with an \"abbreviation\" like Local time zone must be set--see zic manual page. Modern versions of the tzdb database show -00 instead, but some platforms alter the data to show one or another of the historical phrases. Show this zone only if it uses the modern abbreviation.", "title": "Adjust pg_timezone_names view to show the Factory time zone if and only if it has a short abbreviation", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "46366316293d6ea35319b7f0c4a53ba5db83bfc972689a9270565e90c61bdc67", "section_path": ["Changes"], "commit_groups": [["55862b2e9", "8ab66081c", "d095b2fe6", "d304313b0", "e49132e63", "f227aecb9", "f6c7c64e9"]], "identity_text": "Adjust pg_timezone_names view to show the Factory time zone if and only if it has a short abbreviation (Tom Lane) Historically, IANA set up this artificial zone with an abbreviation like Local time zone must be set--see zic manual page. Modern versions of the tzdb database show -00 instead, but some platforms alter the data to show one or another of the historical phrases. Show this zone only if it uses the modern abbreviation.", "commit_aliases": ["55862b2e9", "8ab66081c", "d095b2fe6", "d304313b0", "e49132e63", "f227aecb9", "f6c7c64e9"], "source_commits": ["e49132e63"], "source_entry_id": "9.4.24/changes/016", "db_id": "6e8de7df6e0762293df9c27ee3bd9ec2", "patch_ids": ["7a108e63776bc2dc495e31bffc849802"], "statement_hash": "c16b7760a6738c6a18416de6022303d6f27163d551ae91c82a174c28b53a5a02", "relations": [{"rule": 2, "type": "equivalent", "target": "14c34882fd6a6bc89f3dcb4a8a32b473", "evidence": {"same_day": true, "patch_ids": ["7a108e63776bc2dc495e31bffc849802"], "statement_hash": "c16b7760a6738c6a18416de6022303d6f27163d551ae91c82a174c28b53a5a02"}}, {"rule": 2, "type": "equivalent", "target": "3044626b654d3861e33a608bbce560fb", "evidence": {"same_day": true, "patch_ids": ["7a108e63776bc2dc495e31bffc849802"], "statement_hash": "c16b7760a6738c6a18416de6022303d6f27163d551ae91c82a174c28b53a5a02"}}, {"rule": 2, "type": "equivalent", "target": "68837577519dd64c99025c999bffe36e", "evidence": {"same_day": true, "patch_ids": ["7a108e63776bc2dc495e31bffc849802"], "statement_hash": "c16b7760a6738c6a18416de6022303d6f27163d551ae91c82a174c28b53a5a02"}}, {"rule": 2, "type": "equivalent", "target": "e2690d514420ed8436f89b08744ca88d", "evidence": {"same_day": true, "patch_ids": ["7a108e63776bc2dc495e31bffc849802"], "statement_hash": "c16b7760a6738c6a18416de6022303d6f27163d551ae91c82a174c28b53a5a02"}}], "version": "9.4.24", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "14c34882fd6a6bc89f3dcb4a8a32b473", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Adjust pg_timezone_names view to show the Factory time zone if and only if it has a short abbreviation", "evidence": {"same_day": true, "patch_ids": ["7a108e63776bc2dc495e31bffc849802"], "statement_hash": "c16b7760a6738c6a18416de6022303d6f27163d551ae91c82a174c28b53a5a02"}, "url": "/docs/compare/?release=11.5#11.5-ae1a5672e8d0d548", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "e2690d514420ed8436f89b08744ca88d", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Adjust pg_timezone_names view to show the Factory time zone if and only if it has a short abbreviation", "evidence": {"same_day": true, "patch_ids": ["7a108e63776bc2dc495e31bffc849802"], "statement_hash": "c16b7760a6738c6a18416de6022303d6f27163d551ae91c82a174c28b53a5a02"}, "url": "/docs/compare/?release=10.10#10.10-ae1a5672e8d0d548", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "3044626b654d3861e33a608bbce560fb", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Adjust pg_timezone_names view to show the Factory time zone if and only if it has a short abbreviation", "evidence": {"same_day": true, "patch_ids": ["7a108e63776bc2dc495e31bffc849802"], "statement_hash": "c16b7760a6738c6a18416de6022303d6f27163d551ae91c82a174c28b53a5a02"}, "url": "/docs/compare/?release=9.6.15#9.6.15-ae1a5672e8d0d548", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "68837577519dd64c99025c999bffe36e", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Adjust pg_timezone_names view to show the Factory time zone if and only if it has a short abbreviation", "evidence": {"same_day": true, "patch_ids": ["7a108e63776bc2dc495e31bffc849802"], "statement_hash": "c16b7760a6738c6a18416de6022303d6f27163d551ae91c82a174c28b53a5a02"}, "url": "/docs/compare/?release=9.5.19#9.5.19-ae1a5672e8d0d548", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-680ec5f92e9e5197", "cves": [], "html": "<p>Sync our copy of the timezone library with IANA tzcode release 2019b (Tom Lane)</p>\n<p>This adds support for <span>zic</span>'s new -b slim option to reduce the size of the installed zone files. We are not currently using that, but may enable it in future.</p>", "text": "Sync our copy of the timezone library with IANA tzcode release 2019b (Tom Lane) This adds support for zic's new -b slim option to reduce the size of the installed zone files. We are not currently using that, but may enable it in future.", "title": "Sync our copy of the timezone library with IANA tzcode release 2019b", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "8368488dffbdac60edf3a22779e7d6d2c8b1312b63d858686a60203afda9c20e", "section_path": ["Changes"], "commit_groups": [["1d1ff50d2", "22e73dea3", "417845646", "59cea8f36", "6db29a8fc", "ccc323b57", "f285322f9"], ["421466863", "533522846", "847561c1d", "8a4fa297a", "caa22d72a", "e480d8350", "ee9417a04"]], "identity_text": "Sync our copy of the timezone library with IANA tzcode release 2019b (Tom Lane) This adds support for zic's new -b slim option to reduce the size of the installed zone files. We are not currently using that, but may enable it in future.", "commit_aliases": ["1d1ff50d2", "22e73dea3", "417845646", "421466863", "533522846", "59cea8f36", "6db29a8fc", "847561c1d", "8a4fa297a", "caa22d72a", "ccc323b57", "e480d8350", "ee9417a04", "f285322f9"], "source_commits": ["6db29a8fc", "847561c1d"], "source_entry_id": "9.4.24/changes/017", "db_id": "297028b8c175881017159644c7810a31", "patch_ids": ["7f33d402225bc3e2d977b4bf937b9737", "e1850c16de3d2f00f0fa58a1cac6064c"], "statement_hash": "e3ab5a0fc260ddbb620e8e206addd3f1b4c419748364631ac6b9000472de8ed6", "relations": [{"rule": 2, "type": "equivalent", "target": "66704aa46bc346ce49af8b4232115efc", "evidence": {"same_day": true, "patch_ids": ["7f33d402225bc3e2d977b4bf937b9737", "e1850c16de3d2f00f0fa58a1cac6064c"], "statement_hash": "e3ab5a0fc260ddbb620e8e206addd3f1b4c419748364631ac6b9000472de8ed6"}}, {"rule": 2, "type": "equivalent", "target": "b33f40e33ec82a24d3017ce45ab435d6", "evidence": {"same_day": true, "patch_ids": ["7f33d402225bc3e2d977b4bf937b9737", "e1850c16de3d2f00f0fa58a1cac6064c"], "statement_hash": "e3ab5a0fc260ddbb620e8e206addd3f1b4c419748364631ac6b9000472de8ed6"}}, {"rule": 2, "type": "equivalent", "target": "b67ca0d937f4b5114307e258fe7ce818", "evidence": {"same_day": true, "patch_ids": ["7f33d402225bc3e2d977b4bf937b9737", "e1850c16de3d2f00f0fa58a1cac6064c"], "statement_hash": "e3ab5a0fc260ddbb620e8e206addd3f1b4c419748364631ac6b9000472de8ed6"}}, {"rule": 2, "type": "equivalent", "target": "ea533fe16899568bc48a569550740487", "evidence": {"same_day": true, "patch_ids": ["7f33d402225bc3e2d977b4bf937b9737", "e1850c16de3d2f00f0fa58a1cac6064c"], "statement_hash": "e3ab5a0fc260ddbb620e8e206addd3f1b4c419748364631ac6b9000472de8ed6"}}], "version": "9.4.24", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "ea533fe16899568bc48a569550740487", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Sync our copy of the timezone library with IANA tzcode release 2019b", "evidence": {"same_day": true, "patch_ids": ["7f33d402225bc3e2d977b4bf937b9737", "e1850c16de3d2f00f0fa58a1cac6064c"], "statement_hash": "e3ab5a0fc260ddbb620e8e206addd3f1b4c419748364631ac6b9000472de8ed6"}, "url": "/docs/compare/?release=11.5#11.5-680ec5f92e9e5197", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "66704aa46bc346ce49af8b4232115efc", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Sync our copy of the timezone library with IANA tzcode release 2019b", "evidence": {"same_day": true, "patch_ids": ["7f33d402225bc3e2d977b4bf937b9737", "e1850c16de3d2f00f0fa58a1cac6064c"], "statement_hash": "e3ab5a0fc260ddbb620e8e206addd3f1b4c419748364631ac6b9000472de8ed6"}, "url": "/docs/compare/?release=10.10#10.10-680ec5f92e9e5197", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "b33f40e33ec82a24d3017ce45ab435d6", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Sync our copy of the timezone library with IANA tzcode release 2019b", "evidence": {"same_day": true, "patch_ids": ["7f33d402225bc3e2d977b4bf937b9737", "e1850c16de3d2f00f0fa58a1cac6064c"], "statement_hash": "e3ab5a0fc260ddbb620e8e206addd3f1b4c419748364631ac6b9000472de8ed6"}, "url": "/docs/compare/?release=9.6.15#9.6.15-680ec5f92e9e5197", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "b67ca0d937f4b5114307e258fe7ce818", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Sync our copy of the timezone library with IANA tzcode release 2019b", "evidence": {"same_day": true, "patch_ids": ["7f33d402225bc3e2d977b4bf937b9737", "e1850c16de3d2f00f0fa58a1cac6064c"], "statement_hash": "e3ab5a0fc260ddbb620e8e206addd3f1b4c419748364631ac6b9000472de8ed6"}, "url": "/docs/compare/?release=9.5.19#9.5.19-680ec5f92e9e5197", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "9.4.24-06a880645c10a33c", "cves": [], "html": "<p>Update time zone data files to <span>tzdata</span> release 2019b for DST law changes in Brazil, plus historical corrections for Hong Kong, Italy, and Palestine.</p>", "text": "Update time zone data files to tzdata release 2019b for DST law changes in Brazil, plus historical corrections for Hong Kong, Italy, and Palestine.", "title": "Update time zone data files to tzdata release 2019b for DST law changes in Brazil, plus historical corrections for Hong Kong, Italy, and Palestine.", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.4.24/#AEN120159", "source_hash": "50d8c502f5c868f2d611e8d5147e7379baa3dbd7eb79080f4f4c3fe4050322f5", "section_path": ["Changes"], "commit_groups": [["53256e892", "8474656d9", "93907478e", "a0c905f23", "bcafb675a", "d4f283162", "e3441b2a2"]], "identity_text": "Update time zone data files to tzdata release 2019b for DST law changes in Brazil, plus historical corrections for Hong Kong, Italy, and Palestine.", "commit_aliases": ["53256e892", "8474656d9", "93907478e", "a0c905f23", "bcafb675a", "d4f283162", "e3441b2a2"], "source_commits": ["8474656d9"], "source_entry_id": "9.4.24/changes/018", "db_id": "f3ef38a6e778452ae46b46d3f5bbc7bd", "patch_ids": ["0f1540aee091ba8ff6fe78f53e0b74dd"], "statement_hash": "6d732895efa004b27a61a334019a52f16fb169bb69d438150092c54b3e8fb989", "relations": [{"rule": 2, "type": "equivalent", "target": "402ac918a8402137d85c11e35e716686", "evidence": {"same_day": true, "patch_ids": ["0f1540aee091ba8ff6fe78f53e0b74dd"], "statement_hash": "6d732895efa004b27a61a334019a52f16fb169bb69d438150092c54b3e8fb989"}}, {"rule": 2, "type": "equivalent", "target": "70c9c93891f4fa24bd7d895981d079eb", "evidence": {"same_day": true, "patch_ids": ["0f1540aee091ba8ff6fe78f53e0b74dd"], "statement_hash": "6d732895efa004b27a61a334019a52f16fb169bb69d438150092c54b3e8fb989"}}, {"rule": 2, "type": "equivalent", "target": "9c3341e8f4d5fb8e50cfd0e22095dbb9", "evidence": {"same_day": true, "patch_ids": ["0f1540aee091ba8ff6fe78f53e0b74dd"], "statement_hash": "6d732895efa004b27a61a334019a52f16fb169bb69d438150092c54b3e8fb989"}}, {"rule": 2, "type": "equivalent", "target": "ed0eefba318199db1daa78df9e376570", "evidence": {"same_day": true, "patch_ids": ["0f1540aee091ba8ff6fe78f53e0b74dd"], "statement_hash": "6d732895efa004b27a61a334019a52f16fb169bb69d438150092c54b3e8fb989"}}], "version": "9.4.24", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "ed0eefba318199db1daa78df9e376570", "kind": "equivalent", "version": "11.5", "label": "11.5", "title": "Update time zone data files to tzdata release 2019b for DST law changes in Brazil, plus historical corrections for Hong Kong, Italy, and Palestine.", "evidence": {"same_day": true, "patch_ids": ["0f1540aee091ba8ff6fe78f53e0b74dd"], "statement_hash": "6d732895efa004b27a61a334019a52f16fb169bb69d438150092c54b3e8fb989"}, "url": "/docs/compare/?release=11.5#11.5-06a880645c10a33c", "source_url": "/docs/release/11.5/#id-1.11.6.22.5"}, {"db_id": "9c3341e8f4d5fb8e50cfd0e22095dbb9", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Update time zone data files to tzdata release 2019b for DST law changes in Brazil, plus historical corrections for Hong Kong, Italy, and Palestine.", "evidence": {"same_day": true, "patch_ids": ["0f1540aee091ba8ff6fe78f53e0b74dd"], "statement_hash": "6d732895efa004b27a61a334019a52f16fb169bb69d438150092c54b3e8fb989"}, "url": "/docs/compare/?release=10.10#10.10-06a880645c10a33c", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "70c9c93891f4fa24bd7d895981d079eb", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Update time zone data files to tzdata release 2019b for DST law changes in Brazil, plus historical corrections for Hong Kong, Italy, and Palestine.", "evidence": {"same_day": true, "patch_ids": ["0f1540aee091ba8ff6fe78f53e0b74dd"], "statement_hash": "6d732895efa004b27a61a334019a52f16fb169bb69d438150092c54b3e8fb989"}, "url": "/docs/compare/?release=9.6.15#9.6.15-06a880645c10a33c", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "402ac918a8402137d85c11e35e716686", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Update time zone data files to tzdata release 2019b for DST law changes in Brazil, plus historical corrections for Hong Kong, Italy, and Palestine.", "evidence": {"same_day": true, "patch_ids": ["0f1540aee091ba8ff6fe78f53e0b74dd"], "statement_hash": "6d732895efa004b27a61a334019a52f16fb169bb69d438150092c54b3e8fb989"}, "url": "/docs/compare/?release=9.5.19#9.5.19-06a880645c10a33c", "source_url": "/docs/release/9.5.19/#AEN128323"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 18}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 7}, {"key": "security", "label": "Security", "count": 1}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 10}], "total": 18, "release_count": 1, "cross_major": false, "cve_count": 2, "cves": [{"id": "CVE-2019-10208", "url": "https://www.postgresql.org/support/security/CVE-2019-10208/", "fixed": {"10": "10.10", "11": "11.5", "9.4": "9.4.24", "9.5": "9.5.19", "9.6": "9.6.15"}, "score": 7.5, "title": "Require schema qualification to cast to a temporary type when using functional cast syntax", "vector": "AV:N/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:H", "affected": {"10": "10", "11": "11", "9.4": "9.4", "9.5": "9.5", "9.6": "9.6"}, "component": "core server", "published": {"10": "2019-08-08", "11": "2019-08-08", "9.4": "2019-08-08", "9.5": "2019-08-08", "9.6": "2019-08-08"}, "introduced": {}, "cvss_version": "3.0", "description_en": "Given a suitable SECURITY DEFINER function, an attacker can execute arbitrary SQL under the identity of the function owner. An attack requires EXECUTE permission on the function, which must itself contain a function call having inexact argument type match. For example, length('foo'::varchar) and length('foo') are inexact, while length('foo'::text) is exact.\n\nAs part of exploiting this vulnerability, the attacker uses CREATE DOMAIN to create a type in a pg_temp schema. The attack pattern and fix are similar to that for CVE-2007-2138 .\n\nWriting SECURITY DEFINER functions continues to require following the considerations noted in the documentation:\n\nhttps://www.postgresql.org/docs/current/sql-createfunction.html#SQL-CREATEFUNCTION-SECURITY\n\nThe PostgreSQL project thanks Tom Lane for reporting this problem.", "first_published": "2019-08-08", "fixed_version": "9.4.24"}, {"id": "CVE-2007-2138", "url": "https://www.postgresql.org/support/security/CVE-2007-2138/", "fixed": {"7.3": "7.3.19", "7.4": "7.4.17", "8.0": "8.0.13", "8.1": "8.1.9", "8.2": "8.2.4"}, "score": null, "title": "Require schema qualification to cast to a temporary type when using functional cast syntax", "vector": "", "affected": {"7.3": "7.3", "7.4": "7.4", "8.0": "8.0", "8.1": "8.1", "8.2": "8.2"}, "component": "", "published": {}, "introduced": {}, "cvss_version": "", "description_en": "", "first_published": null, "fixed_version": ""}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 18, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}