A dump/restore is not required for those running 11.X.
\nHowever, if you are upgrading from a version earlier than 11.1, see Section E.22.
", "compatibility_count": 0, "label": "11.5", "status_label": "Historical", "eol": "2023-11-09", "age_days": 2609, "support_days": -1055}, "groups": [{"date": "2019-08-08", "build": "11.5", "major": "11", "minor": 5, "manual": "11", "status": "stable", "doc_git": "", "version": "11.5", "eol_date": "2023-11-09", "date_text": "2019-08-08", "supported": false, "manual_url": "/docs/11/release-11-5.html", "source_url": "/docs/release/11.5/", "entry_count": 47, "placeholder": false, "content_hash": "06682d30ec455da9918c9886b603e77dcc60620a55bda3931363d9628ed8da8d", "manual_build": "11.22", "source_as_of": "", "changes_count": 47, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 11.X.
\nHowever, if you are upgrading from a version earlier than 11.1, see Section E.22.
", "compatibility_count": 0, "label": "11.5", "status_label": "Historical", "eol": "2023-11-09", "age_days": 2609, "support_days": -1055, "entries": [{"id": "11.5-df1e4670d6c8f5ec", "cves": ["CVE-2007-2138", "CVE-2019-10208"], "html": "Require schema qualification to cast to a temporary type when using functional cast syntax (Noah Misch)
\nWe have long required invocations of temporary functions to explicitly specify the temporary schema, that is pg_temp.. Require this as well for casting to temporary types using functional notation, for example func_name(args)pg_temp.. 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)type_name(arg)
Fix execution of hashed subplans that require cross-type comparison (Tom Lane, Andreas Seltenreich)
\nHashed subplans used the outer query's original comparison operator to compare entries of the hash table. This is the wrong thing if that operator is cross-type, since all the hash table entries will be of the subquery's output type. For the set of hashable cross-type operators in core PostgreSQL, this mistake seems nearly harmless on 64-bit machines, but it can result in crashes or perhaps unauthorized disclosure of server memory on 32-bit machines. Extensions might provide hashable cross-type operators that create larger risks. (CVE-2019-10209)
", "text": "Fix execution of hashed subplans that require cross-type comparison (Tom Lane, Andreas Seltenreich) Hashed subplans used the outer query's original comparison operator to compare entries of the hash table. This is the wrong thing if that operator is cross-type, since all the hash table entries will be of the subquery's output type. For the set of hashable cross-type operators in core PostgreSQL, this mistake seems nearly harmless on 64-bit machines, but it can result in crashes or perhaps unauthorized disclosure of server memory on 32-bit machines. Extensions might provide hashable cross-type operators that create larger risks. (CVE-2019-10209)", "title": "Fix execution of hashed subplans that require cross-type comparison", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/11.5/#id-1.11.6.22.5", "source_hash": "942d62d391369aafbe166559d60916f68719648060f35c55a5fccca621b34673", "section_path": ["Changes"], "commit_groups": [["4766dce0d", "a034418cf", "de4b75c15"]], "identity_text": "Fix execution of hashed subplans that require cross-type comparison (Tom Lane, Andreas Seltenreich) Hashed subplans used the outer query's original comparison operator to compare entries of the hash table. This is the wrong thing if that operator is cross-type, since all the hash table entries will be of the subquery's output type. For the set of hashable cross-type operators in core PostgreSQL, this mistake seems nearly harmless on 64-bit machines, but it can result in crashes or perhaps unauthorized disclosure of server memory on 32-bit machines. Extensions might provide hashable cross-type operators that create larger risks. (CVE-2019-10209)", "commit_aliases": ["4766dce0d", "a034418cf", "de4b75c15"], "source_commits": ["a034418cf"], "source_entry_id": "11.5/changes/002", "db_id": "2a37072634423bebdca170f16b5ff64f", "patch_ids": ["446a3432b848baaef80941eae8a372bc"], "statement_hash": "ed94eb8539f728ce123fef3ce97d1ff1587570ad32cfcc2c0bf81a3071b060b5", "relations": [], "version": "11.5", "category_label": "Security", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.5-c4ecc987984cf907", "cves": [], "html": "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.
Prevent dropping a partitioned table's trigger if there are pending trigger events in child partitions (Álvaro Herrera)
\nThis notably applies to foreign key constraints, since those are implemented by triggers.
", "text": "Prevent dropping a partitioned table's trigger if there are pending trigger events in child partitions (Álvaro Herrera) This notably applies to foreign key constraints, since those are implemented by triggers.", "title": "Prevent dropping a partitioned table's trigger if there are pending trigger events in child partitions", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.5/#id-1.11.6.22.5", "source_hash": "543306c78449c423174badb7f508721e88413980184cb58b8bf391be3f94144d", "section_path": ["Changes"], "commit_groups": [["3ffe655c0", "5562272a4", "ec7f9a740"]], "identity_text": "Prevent dropping a partitioned table's trigger if there are pending trigger events in child partitions (Álvaro Herrera) This notably applies to foreign key constraints, since those are implemented by triggers.", "commit_aliases": ["3ffe655c0", "5562272a4", "ec7f9a740"], "source_commits": ["ec7f9a740"], "source_entry_id": "11.5/changes/004", "db_id": "7b45427c532ef337dac3c3b91ae1cdb3", "patch_ids": ["7db9cce903c8d572e1d5ad9ae84b45a3"], "statement_hash": "f750efc901e714108f6bc32b1fb9eb8572bd6df221e91fd134df993bb0a111ab", "relations": [], "version": "11.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.5-cc1d022720b3d2ba", "cves": [], "html": "Include user-specified trigger arguments when copying a trigger definition from a partitioned table to one of its partitions (Patrick McHardy)
", "text": "Include user-specified trigger arguments when copying a trigger definition from a partitioned table to one of its partitions (Patrick McHardy)", "title": "Include user-specified trigger arguments when copying a trigger definition from a partitioned table to one of its partitions", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.5/#id-1.11.6.22.5", "source_hash": "21fa4574fafb815593592ef35fe9f25f6fb7c06668e3674faf0554a8534e4f3b", "section_path": ["Changes"], "commit_groups": [["1637d959d", "2c84ea6cf", "ae0a2945b"], ["2ede93de9"]], "identity_text": "Include user-specified trigger arguments when copying a trigger definition from a partitioned table to one of its partitions (Patrick McHardy)", "commit_aliases": ["1637d959d", "2c84ea6cf", "2ede93de9", "ae0a2945b"], "source_commits": ["1637d959d", "2ede93de9"], "source_entry_id": "11.5/changes/005", "db_id": "ed772abd3c122f8f3cd912f15a3704e4", "patch_ids": ["032dda06f2fb5f1bd6b444262eb80900", "2a41ee6c2bddbfd525bb730ed50ec5a3"], "statement_hash": "672460d8834be402220f4a2e61851ea8b2c2cc85c6224189d9203b45440f8d60", "relations": [], "version": "11.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.5-fce59231c7b15abf", "cves": [], "html": "Install dependencies to prevent dropping partition key columns (Tom Lane)
\nALTER TABLE ... DROP COLUMN will refuse to drop a column that is a partition key column. However, indirect drops (such as a cascade from dropping a key column's data type) had no such check, allowing the deletion of a key column. This resulted in a badly broken partitioned table that could neither be accessed nor dropped.
This fix adds pg_depend entries that enforce that the whole partitioned table, not just the key column, will be dropped if a cascaded drop forces removal of the key column. However, such entries will only be created when a partitioned table is created; so this fix does not remove the risk for pre-existing partitioned tables. The issue can only arise for partition key columns of non-built-in data types, so it seems not to be a hazard for most users.
Ensure that column numbers are correctly mapped between a partitioned table and its default partition (Amit Langote)
\nSome operations misbehaved if the mapping wasn't exactly one-to-one, for example if there were dropped columns in one table and not the other.
", "text": "Ensure that column numbers are correctly mapped between a partitioned table and its default partition (Amit Langote) Some operations misbehaved if the mapping wasn't exactly one-to-one, for example if there were dropped columns in one table and not the other.", "title": "Ensure that column numbers are correctly mapped between a partitioned table and its default partition", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.5/#id-1.11.6.22.5", "source_hash": "1d2565d652f257eaab94f47375a789f2d45fc411f085c73cd741f73bf9fa80f3", "section_path": ["Changes"], "commit_groups": [["23cccb17f", "43085a4f6"]], "identity_text": "Ensure that column numbers are correctly mapped between a partitioned table and its default partition (Amit Langote) Some operations misbehaved if the mapping wasn't exactly one-to-one, for example if there were dropped columns in one table and not the other.", "commit_aliases": ["23cccb17f", "43085a4f6"], "source_commits": ["43085a4f6"], "source_entry_id": "11.5/changes/007", "db_id": "395bab40d07d6adcd63f329f937f73f6", "patch_ids": ["47d9e533d872410380f0dbed9c8b94cf"], "statement_hash": "4a85fcc8d5137402679643bacab65917389ac7b8794cdf8571fa71ab915910dd", "relations": [], "version": "11.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.5-cddd8828608d8aa2", "cves": [], "html": "Ignore partitions that are foreign tables when creating indexes on partitioned tables (Álvaro Herrera)
\nPreviously an error was thrown on encountering a foreign-table partition, but that's unhelpful and doesn't protect against any actual problem.
", "text": "Ignore partitions that are foreign tables when creating indexes on partitioned tables (Álvaro Herrera) Previously an error was thrown on encountering a foreign-table partition, but that's unhelpful and doesn't protect against any actual problem.", "title": "Ignore partitions that are foreign tables when creating indexes on partitioned tables", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.5/#id-1.11.6.22.5", "source_hash": "3e2872deb88e8fec11e0f85f6c4f9fb60c582b27d8c4d51b8975947ae0883a3c", "section_path": ["Changes"], "commit_groups": [["050098b14", "e4f2d4fe9"], ["55ed3defc", "9653ca219"]], "identity_text": "Ignore partitions that are foreign tables when creating indexes on partitioned tables (Álvaro Herrera) Previously an error was thrown on encountering a foreign-table partition, but that's unhelpful and doesn't protect against any actual problem.", "commit_aliases": ["050098b14", "55ed3defc", "9653ca219", "e4f2d4fe9"], "source_commits": ["9653ca219", "e4f2d4fe9"], "source_entry_id": "11.5/changes/008", "db_id": "3edd46d88ee5063b920f38689bd3a020", "patch_ids": ["8910db78361ccac6c648524785ca0f09", "9005a57f5dc2f03dd922de7467ce41e3"], "statement_hash": "d68beb062fe28ba9ebac6278dec3e68232d94c196b28708a4ba491bd0e91e6a4", "relations": [], "version": "11.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.5-4b3b38d237c6235d", "cves": [], "html": "Prune a partitioned table's default partition (that is, avoid uselessly scanning it) in more cases (Yuzuko Hosoya)
", "text": "Prune a partitioned table's default partition (that is, avoid uselessly scanning it) in more cases (Yuzuko Hosoya)", "title": "Prune a partitioned table's default partition (that is, avoid uselessly scanning it) in more cases", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.5/#id-1.11.6.22.5", "source_hash": "22219f3b8441b6bed150161f366f9ccdbcdc34e5d2eda8accb866b9250461804", "section_path": ["Changes"], "commit_groups": [["489247b0e", "865440714", "e3967a16d"]], "identity_text": "Prune a partitioned table's default partition (that is, avoid uselessly scanning it) in more cases (Yuzuko Hosoya)", "commit_aliases": ["489247b0e", "865440714", "e3967a16d"], "source_commits": ["e3967a16d"], "source_entry_id": "11.5/changes/009", "db_id": "ad0513a0f014dd752fe144366ec3c594", "patch_ids": ["f83fbdcd7c70dbb7a849bcd0430a2b4b"], "statement_hash": "1bea8b3abc343d010691136bdbc2a4575ac72ee96c89dc1e6dd8e68ea3b1a749", "relations": [], "version": "11.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.5-16ed125a7b6865cb", "cves": [], "html": "Fix possible failure to prune partitions when there are multiple partition key columns of boolean type (David Rowley)
Don't optimize away GROUP BY columns when the table involved is an inheritance parent (David Rowley)
Normally, if a table's primary key column(s) are included in GROUP BY, it's safe to drop any other grouping columns, since the primary key columns are enough to make the groups unique. This rule does not work if the query is also reading inheritance child tables, though; the parent's uniqueness does not extend to the children.
Avoid incorrect use of parallel hash join for semi-join queries (Thomas Munro)
\nThis error resulted in duplicate result rows from some EXISTS queries.
Avoid using unnecessary sort steps for some queries with GROUPING SETS (Andrew Gierth, Richard Guo)
Fix possible failure of planner's index endpoint probes (Tom Lane)
\nWhen using a recently-created index to determine the minimum or maximum value of a column, the planner could select a recently-dead tuple that does not actually contain the endpoint value. In the worst case the tuple might contain a null, resulting in a visible error “found unexpected null value in index”; more likely we would just end up using the wrong value, degrading the quality of planning estimates.
", "text": "Fix possible failure of planner's index endpoint probes (Tom Lane) When using a recently-created index to determine the minimum or maximum value of a column, the planner could select a recently-dead tuple that does not actually contain the endpoint value. In the worst case the tuple might contain a null, resulting in a visible error “found unexpected null value in index”; more likely we would just end up using the wrong value, degrading the quality of planning estimates.", "title": "Fix possible failure of planner's index endpoint probes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.5/#id-1.11.6.22.5", "source_hash": "1690c0701d1795cf3b936d2d34c7b53c48ca737c7bcd0290fdffceea74f84f17", "section_path": ["Changes"], "commit_groups": [["5c1b7edc2", "cee976c4e", "d3751adcf"]], "identity_text": "Fix possible failure of planner's index endpoint probes (Tom Lane) When using a recently-created index to determine the minimum or maximum value of a column, the planner could select a recently-dead tuple that does not actually contain the endpoint value. In the worst case the tuple might contain a null, resulting in a visible error found unexpected null value in index; more likely we would just end up using the wrong value, degrading the quality of planning estimates.", "commit_aliases": ["5c1b7edc2", "cee976c4e", "d3751adcf"], "source_commits": ["5c1b7edc2"], "source_entry_id": "11.5/changes/014", "db_id": "8183590e93cbf5bab182ed76b8308b70", "patch_ids": ["b19c810ca3b35fb342d3ba6364a478f8"], "statement_hash": "0883df93e8abaa10db477686559f8d995cff8823a4034d21d4bf2bc63d978832", "relations": [], "version": "11.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.5-387382352f2cfe41", "cves": [], "html": "Fix failure to access trigger transition tables during EvalPlanQual rechecks (Alex Aktsipetrov)
Triggers that rely on transition tables sometimes failed in the presence of concurrent updates.
", "text": "Fix failure to access trigger transition tables during EvalPlanQual rechecks (Alex Aktsipetrov) Triggers that rely on transition tables sometimes failed in the presence of concurrent updates.", "title": "Fix failure to access trigger transition tables during EvalPlanQual rechecks", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.5/#id-1.11.6.22.5", "source_hash": "b60f27661871d76c26634fe85394cde1f1165e8db2750892655df7ba1c9282f8", "section_path": ["Changes"], "commit_groups": [["72b526779", "9509173d2", "abbb2e143", "f5825853e"]], "identity_text": "Fix failure to access trigger transition tables during EvalPlanQual rechecks (Alex Aktsipetrov) Triggers that rely on transition tables sometimes failed in the presence of concurrent updates.", "commit_aliases": ["72b526779", "9509173d2", "abbb2e143", "f5825853e"], "source_commits": ["9509173d2"], "source_entry_id": "11.5/changes/015", "db_id": "0212cc9445c7b70cf3ad47605ffd74ab", "patch_ids": ["d940b606fbde6b08e0237fe94575b2b9"], "statement_hash": "bac9ab28a18f76bcbe72193dff950377d33f4b8758c40482ba916619e1d4f0f6", "relations": [{"rule": 2, "type": "equivalent", "target": "8236a15705f70d5a369bb308e935ea7b", "evidence": {"same_day": true, "patch_ids": ["d940b606fbde6b08e0237fe94575b2b9"], "statement_hash": "bac9ab28a18f76bcbe72193dff950377d33f4b8758c40482ba916619e1d4f0f6"}}], "version": "11.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "8236a15705f70d5a369bb308e935ea7b", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Fix failure to access trigger transition tables during EvalPlanQual rechecks", "evidence": {"same_day": true, "patch_ids": ["d940b606fbde6b08e0237fe94575b2b9"], "statement_hash": "bac9ab28a18f76bcbe72193dff950377d33f4b8758c40482ba916619e1d4f0f6"}, "url": "/docs/compare/?release=10.10#10.10-387382352f2cfe41", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}]}, {"id": "11.5-172682689722fe64", "cves": [], "html": "Fix mishandling of multi-column foreign keys when rebuilding a foreign key constraint (Tom Lane)
\nALTER 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.
Don't build extended statistics for inheritance trees (Tomas Vondra)
\nThis avoids a “tuple already updated by self” error during ANALYZE.
Avoid spurious deadlock errors when upgrading a tuple lock (Oleksii Kliukin)
\nWhen two or more transactions are waiting for a transaction T1 to release a tuple-level lock, and T1 upgrades its lock to a higher level, a spurious deadlock among the waiting transactions could be reported when T1 finishes.
", "text": "Avoid spurious deadlock errors when upgrading a tuple lock (Oleksii Kliukin) When two or more transactions are waiting for a transaction T1 to release a tuple-level lock, and T1 upgrades its lock to a higher level, a spurious deadlock among the waiting transactions could be reported when T1 finishes.", "title": "Avoid spurious deadlock errors when upgrading a tuple lock", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.5/#id-1.11.6.22.5", "source_hash": "50af1f5c0cbc427c69d18d63add68d97925c22646af5021db3cad55a47f24a1a", "section_path": ["Changes"], "commit_groups": [["0772d8a00", "0ba35c7c9", "5246d3e79", "8b21b416e"]], "identity_text": "Avoid spurious deadlock errors when upgrading a tuple lock (Oleksii Kliukin) When two or more transactions are waiting for a transaction T1 to release a tuple-level lock, and T1 upgrades its lock to a higher level, a spurious deadlock among the waiting transactions could be reported when T1 finishes.", "commit_aliases": ["0772d8a00", "0ba35c7c9", "5246d3e79", "8b21b416e"], "source_commits": ["5246d3e79"], "source_entry_id": "11.5/changes/018", "db_id": "4d3b6b50df223741251b93e16d47f57b", "patch_ids": ["5671c5bc9cc942f9d876e5dc6b2b9612"], "statement_hash": "fc22b942de7bb53b68e18d0ffffc29193d0efe75be9fd33e32807fb13c02585c", "relations": [{"rule": 2, "type": "equivalent", "target": "34647c105adb090adadcf76ddb4f1aa4", "evidence": {"same_day": true, "patch_ids": ["5671c5bc9cc942f9d876e5dc6b2b9612"], "statement_hash": "fc22b942de7bb53b68e18d0ffffc29193d0efe75be9fd33e32807fb13c02585c"}}, {"rule": 2, "type": "equivalent", "target": "773fdd1f1beadc08d0c1cd60c3a92d4b", "evidence": {"same_day": true, "patch_ids": ["5671c5bc9cc942f9d876e5dc6b2b9612"], "statement_hash": "fc22b942de7bb53b68e18d0ffffc29193d0efe75be9fd33e32807fb13c02585c"}}], "version": "11.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "773fdd1f1beadc08d0c1cd60c3a92d4b", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Avoid spurious deadlock errors when upgrading a tuple lock", "evidence": {"same_day": true, "patch_ids": ["5671c5bc9cc942f9d876e5dc6b2b9612"], "statement_hash": "fc22b942de7bb53b68e18d0ffffc29193d0efe75be9fd33e32807fb13c02585c"}, "url": "/docs/compare/?release=10.10#10.10-4bc3eb93d9a24c82", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "34647c105adb090adadcf76ddb4f1aa4", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Avoid spurious deadlock errors when upgrading a tuple lock", "evidence": {"same_day": true, "patch_ids": ["5671c5bc9cc942f9d876e5dc6b2b9612"], "statement_hash": "fc22b942de7bb53b68e18d0ffffc29193d0efe75be9fd33e32807fb13c02585c"}, "url": "/docs/compare/?release=9.6.15#9.6.15-4bc3eb93d9a24c82", "source_url": "/docs/release/9.6.15/#AEN133502"}]}, {"id": "11.5-a73330a55d1a0225", "cves": [], "html": "Fix failure to resolve deadlocks involving multiple parallel worker processes (Rui Hai Jiang)
\nIt is not clear whether this bug is reachable with non-artificial queries, but if it did happen, the queries involved in an otherwise-resolvable deadlock would block until canceled.
", "text": "Fix failure to resolve deadlocks involving multiple parallel worker processes (Rui Hai Jiang) It is not clear whether this bug is reachable with non-artificial queries, but if it did happen, the queries involved in an otherwise-resolvable deadlock would block until canceled.", "title": "Fix failure to resolve deadlocks involving multiple parallel worker processes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.5/#id-1.11.6.22.5", "source_hash": "b2ad4f070abd4d75588cf627159437fee049551b316147d7162b14380d530aaa", "section_path": ["Changes"], "commit_groups": [["0dcb1c6c4", "3420851a2", "af41ab50f", "c3b613e1b", "d933816c0"]], "identity_text": "Fix failure to resolve deadlocks involving multiple parallel worker processes (Rui Hai Jiang) It is not clear whether this bug is reachable with non-artificial queries, but if it did happen, the queries involved in an otherwise-resolvable deadlock would block until canceled.", "commit_aliases": ["0dcb1c6c4", "3420851a2", "af41ab50f", "c3b613e1b", "d933816c0"], "source_commits": ["0dcb1c6c4"], "source_entry_id": "11.5/changes/019", "db_id": "530573e75de1e9d61bb82e0208c101b0", "patch_ids": ["4a5a31a3638635c46fdfb49cbcd53a76"], "statement_hash": "d455b16dd65ddeb33a9b3d0876d30316fd04488478ecb9b27c801de9e8449ce6", "relations": [{"rule": 2, "type": "equivalent", "target": "03a4e101c840f1c83c6c315bc828a1e0", "evidence": {"same_day": true, "patch_ids": ["4a5a31a3638635c46fdfb49cbcd53a76"], "statement_hash": "d455b16dd65ddeb33a9b3d0876d30316fd04488478ecb9b27c801de9e8449ce6"}}, {"rule": 2, "type": "equivalent", "target": "4d910d13235e0b167aa7477f93b85744", "evidence": {"same_day": true, "patch_ids": ["4a5a31a3638635c46fdfb49cbcd53a76"], "statement_hash": "d455b16dd65ddeb33a9b3d0876d30316fd04488478ecb9b27c801de9e8449ce6"}}], "version": "11.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "4d910d13235e0b167aa7477f93b85744", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Fix failure to resolve deadlocks involving multiple parallel worker processes", "evidence": {"same_day": true, "patch_ids": ["4a5a31a3638635c46fdfb49cbcd53a76"], "statement_hash": "d455b16dd65ddeb33a9b3d0876d30316fd04488478ecb9b27c801de9e8449ce6"}, "url": "/docs/compare/?release=10.10#10.10-a73330a55d1a0225", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "03a4e101c840f1c83c6c315bc828a1e0", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Fix failure to resolve deadlocks involving multiple parallel worker processes", "evidence": {"same_day": true, "patch_ids": ["4a5a31a3638635c46fdfb49cbcd53a76"], "statement_hash": "d455b16dd65ddeb33a9b3d0876d30316fd04488478ecb9b27c801de9e8449ce6"}, "url": "/docs/compare/?release=9.6.15#9.6.15-a73330a55d1a0225", "source_url": "/docs/release/9.6.15/#AEN133502"}]}, {"id": "11.5-bde5a490135a01db", "cves": [], "html": "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.
", "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/11.5/#id-1.11.6.22.5", "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": ["477ebfc96", "f5f20deda"], "source_entry_id": "11.5/changes/020", "db_id": "0e58f3b145870b8f318a43ff5a62ad9a", "patch_ids": ["0055289fede3d0d58f40bc9a5cd8b5c5", "26d2b816955d6b94419cbe84d2fa80a3"], "statement_hash": "b5278a466e61ff1562f82babdb5ea62bf67b661d28881faa1afe55e80afad2c1", "relations": [{"rule": 2, "type": "equivalent", "target": "585f8c17b8fec07d6f69a2cfad6a5816", "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": "11.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"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"}, {"db_id": "585f8c17b8fec07d6f69a2cfad6a5816", "kind": "equivalent", "version": "9.4.24", "label": "9.4.24", "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.4.24#9.4.24-bde5a490135a01db", "source_url": "/docs/release/9.4.24/#AEN120159"}]}, {"id": "11.5-4a16362b56bd5aee", "cves": [], "html": "Fix loss of fractional digits when converting very large money values to numeric (Tom Lane)
Fix printing of BTREE_META_CLEANUP WAL records (Michael Paquier)
Prevent assertion failures due to mishandling of version-2 btree metapages (Peter Geoghegan)
", "text": "Prevent assertion failures due to mishandling of version-2 btree metapages (Peter Geoghegan)", "title": "Prevent assertion failures due to mishandling of version-2 btree metapages", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.5/#id-1.11.6.22.5", "source_hash": "5bc8f2c65e06b914725f16fb18d1dc5bb5450225a9a7e2b2e7b64bc8f7d9c6b2", "section_path": ["Changes"], "commit_groups": [["6523f2ed3", "7772dece9", "d004147eb"]], "identity_text": "Prevent assertion failures due to mishandling of version-2 btree metapages (Peter Geoghegan)", "commit_aliases": ["6523f2ed3", "7772dece9", "d004147eb"], "source_commits": ["6523f2ed3"], "source_entry_id": "11.5/changes/023", "db_id": "2bd777a6fee868889ebe1a80fc45bfd5", "patch_ids": ["da9528b091a561078d6e9e3a0dd81919"], "statement_hash": "8030d10f7e103a7ded689c2e091ff0063cc4aae0f2c225d42ea323f4265c938e", "relations": [], "version": "11.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.5-b3eae21797ed78e3", "cves": [], "html": "Fix spinlock assembly code for MIPS CPUs so that it works on MIPS r6 (YunQiang Su)
", "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/11.5/#id-1.11.6.22.5", "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": ["40dde8290"], "source_entry_id": "11.5/changes/024", "db_id": "c0e1e4e25e282e4bf82ab7c2416c1371", "patch_ids": ["421bea799bfbecfbbc7472b4f27e9621"], "statement_hash": "e32f0f67275a9c8a4eb1604238e8851ca8d3e1cff7308116c2b90be9a4ed8a64", "relations": [{"rule": 2, "type": "equivalent", "target": "148cc89d12926d613b4765f9b06c4e4f", "evidence": {"same_day": true, "patch_ids": ["421bea799bfbecfbbc7472b4f27e9621"], "statement_hash": "e32f0f67275a9c8a4eb1604238e8851ca8d3e1cff7308116c2b90be9a4ed8a64"}}, {"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"}}], "version": "11.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"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"}, {"db_id": "148cc89d12926d613b4765f9b06c4e4f", "kind": "equivalent", "version": "9.4.24", "label": "9.4.24", "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.4.24#9.4.24-b3eae21797ed78e3", "source_url": "/docs/release/9.4.24/#AEN120159"}]}, {"id": "11.5-9e48649b81126349", "cves": [], "html": "Ensure that a record or row value returned from a PL/pgSQL function is marked with the function's declared composite type (Tom Lane)
\nThis avoids problems if the result is stored directly into a table.
", "text": "Ensure that a record or row value returned from a PL/pgSQL function is marked with the function's declared composite type (Tom Lane) This avoids problems if the result is stored directly into a table.", "title": "Ensure that a record or row value returned from a PL/pgSQL function is marked with the function's declared composite type", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.5/#id-1.11.6.22.5", "source_hash": "d40dde5f2df93aac1c92ae4f3ff8fd05d9a0442e5da6f1df0a7bbf2b8d5842af", "section_path": ["Changes"], "commit_groups": [["1dd8cf1b4", "24c5c711f", "5683b3495"]], "identity_text": "Ensure that a record or row value returned from a PL/pgSQL function is marked with the function's declared composite type (Tom Lane) This avoids problems if the result is stored directly into a table.", "commit_aliases": ["1dd8cf1b4", "24c5c711f", "5683b3495"], "source_commits": ["24c5c711f"], "source_entry_id": "11.5/changes/025", "db_id": "4472f5c1be31d27c0d85290d58016f4c", "patch_ids": ["527fc22e772f1b8fa5b27c047bdbf64e"], "statement_hash": "e0dba2becf1032b8727046b29c18d6c17adb388c861dd4d6cd0740210b8ec228", "relations": [], "version": "11.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.5-bf0f884c1373cce0", "cves": [], "html": "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.
", "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/11.5/#id-1.11.6.22.5", "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": ["11a0a4db3"], "source_entry_id": "11.5/changes/026", "db_id": "f0da8881afb51e5188a214dfb856e88f", "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": "750f9c95bc91c75e18a3b866f61c9e19", "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": "f470297cc97ba5d0f05e547d29143113", "evidence": {"same_day": true, "patch_ids": ["0c52d799489d2d345afa1ce18511da67"], "statement_hash": "c9dcd72eb5cf09f829656e4496e0c3caaac9b1f3b00bac69eb2a91451db56f0f"}}], "version": "11.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"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"}, {"db_id": "750f9c95bc91c75e18a3b866f61c9e19", "kind": "equivalent", "version": "9.4.24", "label": "9.4.24", "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.4.24#9.4.24-bf0f884c1373cce0", "source_url": "/docs/release/9.4.24/#AEN120159"}]}, {"id": "11.5-cde81f874d215268", "cves": [], "html": "In psql, avoid offering incorrect tab completion options after SET (Tom Lane)variable =
Fix a small memory leak in psql's \\d command (Tom Lane)
Fix pg_dump to ensure that custom operator classes are dumped in the right order (Tom Lane)
\nIf 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.)
", "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/11.5/#id-1.11.6.22.5", "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": ["c64e29705"], "source_entry_id": "11.5/changes/029", "db_id": "d310270c03e84689653e850517303f19", "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": "9f2677746b49131ad3a83320ad497740", "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": "11.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"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"}, {"db_id": "9f2677746b49131ad3a83320ad497740", "kind": "equivalent", "version": "9.4.24", "label": "9.4.24", "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.4.24#9.4.24-ef03274c1cd42ba2", "source_url": "/docs/release/9.4.24/#AEN120159"}]}, {"id": "11.5-5b70cc1e746304bd", "cves": [], "html": "Fix possible lockup in pgbench when using -R option (Fabien Coelho)
Improve reliability of contrib/amcheck's index verification (Peter Geoghegan)
Fix handling of Perl undef values in contrib/jsonb_plperl (Ivan Panchenko)
Fix contrib/passwordcheck to coexist with other users of check_password_hook (Michael Paquier)
Fix contrib/sepgsql tests to work under recent SELinux releases (Mike Palmiotto)
Improve stability of src/test/kerberos and src/test/ldap regression tests (Thomas Munro, Tom Lane)
Improve stability of src/test/recovery regression tests (Michael Paquier)
Reduce stderr output from pg_upgrade's test script (Tom Lane)
", "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/11.5/#id-1.11.6.22.5", "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": ["8d21512dc"], "source_entry_id": "11.5/changes/037", "db_id": "f9e5fb6aaa2c517552f01d29ff6f329d", "patch_ids": ["280e12f8c3cc8d9d9eefcc0580820a84"], "statement_hash": "1c2e03648bfb3c05447129cb79c510fca3857f406bf1153e284ec8e996d7392c", "relations": [{"rule": 2, "type": "equivalent", "target": "0695b3b425f25682abe75ef8010043a3", "evidence": {"same_day": true, "patch_ids": ["280e12f8c3cc8d9d9eefcc0580820a84"], "statement_hash": "1c2e03648bfb3c05447129cb79c510fca3857f406bf1153e284ec8e996d7392c"}}, {"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": "fcbb60aeb52f513e8aa4412ec25a5680", "evidence": {"same_day": true, "patch_ids": ["280e12f8c3cc8d9d9eefcc0580820a84"], "statement_hash": "1c2e03648bfb3c05447129cb79c510fca3857f406bf1153e284ec8e996d7392c"}}], "version": "11.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"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"}, {"db_id": "0695b3b425f25682abe75ef8010043a3", "kind": "equivalent", "version": "9.4.24", "label": "9.4.24", "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.4.24#9.4.24-766e0f4a740a94dc", "source_url": "/docs/release/9.4.24/#AEN120159"}]}, {"id": "11.5-3d7f58def810e7d5", "cves": [], "html": "Fix pgbench regression tests to work on Windows (Fabien Coelho)
", "text": "Fix pgbench regression tests to work on Windows (Fabien Coelho)", "title": "Fix pgbench regression tests to work on Windows", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.5/#id-1.11.6.22.5", "source_hash": "2b77793dc7a6ca2cbbc10947373e356e1ecd07392ca12c77b79b100be1d5ed54", "section_path": ["Changes"], "commit_groups": [["1357181d4", "1a721248f", "bfa4263e7"]], "identity_text": "Fix pgbench regression tests to work on Windows (Fabien Coelho)", "commit_aliases": ["1357181d4", "1a721248f", "bfa4263e7"], "source_commits": ["1357181d4"], "source_entry_id": "11.5/changes/038", "db_id": "2486f16be249ad3c295ebed65b4bca8f", "patch_ids": ["e3b31e99dc74cd36167d56a9f76008af"], "statement_hash": "4be300b6d8309206c0a663976ecc480f496edb0ac771f51346c717db475299d8", "relations": [], "version": "11.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "11.5-2375213e38408587", "cves": [], "html": "Fix TAP tests to work with msys Perl, in cases where the build directory is on a non-root msys mount point (Noah Misch)
", "text": "Fix TAP tests to work with msys Perl, in cases where the build directory is on a non-root msys mount point (Noah Misch)", "title": "Fix TAP tests to work with msys Perl, in cases where the build directory is on a non-root msys mount point", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/11.5/#id-1.11.6.22.5", "source_hash": "b65b2bed375be1c41d7b426ea4696587caae88b05372f2cf7f188148adbd2f64", "section_path": ["Changes"], "commit_groups": [["186113b04", "6121ba9d1", "660a2b190", "a40dca815"]], "identity_text": "Fix TAP tests to work with msys Perl, in cases where the build directory is on a non-root msys mount point (Noah Misch)", "commit_aliases": ["186113b04", "6121ba9d1", "660a2b190", "a40dca815"], "source_commits": ["a40dca815"], "source_entry_id": "11.5/changes/039", "db_id": "c6848e12d77898fd354005a96d841e99", "patch_ids": ["3f373b33700d6c8d39f2cab05127a8cc"], "statement_hash": "d3ff5ff9da6ad75039c69754a1904a57bd72e8dc0736ab2709ab69e0a98d4d61", "relations": [{"rule": 2, "type": "equivalent", "target": "87cdb6a8ac0334d53c383c8dfe966f9e", "evidence": {"same_day": true, "patch_ids": ["3f373b33700d6c8d39f2cab05127a8cc"], "statement_hash": "d3ff5ff9da6ad75039c69754a1904a57bd72e8dc0736ab2709ab69e0a98d4d61"}}, {"rule": 2, "type": "equivalent", "target": "db6ed6bdd1c3a993bf06d196dd6c3b9a", "evidence": {"same_day": true, "patch_ids": ["3f373b33700d6c8d39f2cab05127a8cc"], "statement_hash": "d3ff5ff9da6ad75039c69754a1904a57bd72e8dc0736ab2709ab69e0a98d4d61"}}], "version": "11.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "db6ed6bdd1c3a993bf06d196dd6c3b9a", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Fix TAP tests to work with msys Perl, in cases where the build directory is on a non-root msys mount point", "evidence": {"same_day": true, "patch_ids": ["3f373b33700d6c8d39f2cab05127a8cc"], "statement_hash": "d3ff5ff9da6ad75039c69754a1904a57bd72e8dc0736ab2709ab69e0a98d4d61"}, "url": "/docs/compare/?release=10.10#10.10-2375213e38408587", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "87cdb6a8ac0334d53c383c8dfe966f9e", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Fix TAP tests to work with msys Perl, in cases where the build directory is on a non-root msys mount point", "evidence": {"same_day": true, "patch_ids": ["3f373b33700d6c8d39f2cab05127a8cc"], "statement_hash": "d3ff5ff9da6ad75039c69754a1904a57bd72e8dc0736ab2709ab69e0a98d4d61"}, "url": "/docs/compare/?release=9.6.15#9.6.15-2375213e38408587", "source_url": "/docs/release/9.6.15/#AEN133502"}]}, {"id": "11.5-58b13d00091fd3c5", "cves": [], "html": "Support building Postgres with Microsoft Visual Studio 2019 (Haribabu Kommi)
", "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/11.5/#id-1.11.6.22.5", "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": ["721963f24"], "source_entry_id": "11.5/changes/040", "db_id": "21e7e56d3db692178fb7d0bd54fe6e57", "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": "4b8c493fb7f376ba153f22dbdad54767", "evidence": {"same_day": true, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"], "statement_hash": "aebd4f123e80468f8ba227c891312aade7ff6a7695376ec29d541c28d64d4f9e"}}, {"rule": 2, "type": "equivalent", "target": "632436228109ad3b9a3483b7759ec462", "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": "11.5", "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": "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"}, {"db_id": "632436228109ad3b9a3483b7759ec462", "kind": "equivalent", "version": "9.4.24", "label": "9.4.24", "title": "Support building Postgres with Microsoft Visual Studio 2019", "evidence": {"same_day": true, "patch_ids": ["607ec5d7e45d9dcaeb220656b8fadb2c"], "statement_hash": "aebd4f123e80468f8ba227c891312aade7ff6a7695376ec29d541c28d64d4f9e"}, "url": "/docs/compare/?release=9.4.24#9.4.24-58b13d00091fd3c5", "source_url": "/docs/release/9.4.24/#AEN120159"}]}, {"id": "11.5-c3916aa534e57181", "cves": [], "html": "In Visual Studio builds, honor WindowsSDKVersion environment variable, if that's set (Peifeng Qiu)
This fixes build failures in some configurations.
", "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/11.5/#id-1.11.6.22.5", "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": ["e465d9d40", "fe9e63284"], "source_entry_id": "11.5/changes/041", "db_id": "cb729d691b36ad57b8100562180a6149", "patch_ids": ["0b0a0208e4eed00a5ee2853baef70360", "dc70b4b23a093a0f13ae1bed10ebc6a5"], "statement_hash": "c94deba12594ee7753416d13cf77fdefdf50c47db2b032a919e8bd327819dd3e", "relations": [{"rule": 2, "type": "equivalent", "target": "080ea81d99bca631642ed1052021fd5e", "evidence": {"same_day": true, "patch_ids": ["0b0a0208e4eed00a5ee2853baef70360", "dc70b4b23a093a0f13ae1bed10ebc6a5"], "statement_hash": "c94deba12594ee7753416d13cf77fdefdf50c47db2b032a919e8bd327819dd3e"}}, {"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": "f1a428c57186ca5712e2e8c40a2cc3b0", "evidence": {"same_day": true, "patch_ids": ["0b0a0208e4eed00a5ee2853baef70360", "dc70b4b23a093a0f13ae1bed10ebc6a5"], "statement_hash": "c94deba12594ee7753416d13cf77fdefdf50c47db2b032a919e8bd327819dd3e"}}], "version": "11.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"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"}, {"db_id": "080ea81d99bca631642ed1052021fd5e", "kind": "equivalent", "version": "9.4.24", "label": "9.4.24", "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.4.24#9.4.24-c3916aa534e57181", "source_url": "/docs/release/9.4.24/#AEN120159"}]}, {"id": "11.5-c4b7404fab589472", "cves": [], "html": "Support OpenSSL 1.1.0 and newer in Visual Studio builds (Juan José Santamaría Flecha, Michael Paquier)
", "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/11.5/#id-1.11.6.22.5", "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": ["0e08a3a1f"], "source_entry_id": "11.5/changes/042", "db_id": "3376f057c8d57fa49f9ba4d4948f3a8c", "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": "585e5d8fbdcd12f97da18b21f2f71830", "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": "11.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"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"}, {"db_id": "585e5d8fbdcd12f97da18b21f2f71830", "kind": "equivalent", "version": "9.4.24", "label": "9.4.24", "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.4.24#9.4.24-c4b7404fab589472", "source_url": "/docs/release/9.4.24/#AEN120159"}]}, {"id": "11.5-bd84a06de216e24d", "cves": [], "html": "Allow make options to be passed down to gmake when non-GNU make is invoked at the top level (Thomas Munro)
", "text": "Allow make options to be passed down to gmake when non-GNU make is invoked at the top level (Thomas Munro)", "title": "Allow make options to be passed down to gmake when non-GNU make is invoked at the top level", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/11.5/#id-1.11.6.22.5", "source_hash": "f5fa4d07958775662d7dfa56993093241bcd49746557a892b6cd736beef5cf59", "section_path": ["Changes"], "commit_groups": [["0089c3059", "2839bf353", "3a3b361cc", "956611e4c", "9ad5ea82d"]], "identity_text": "Allow make options to be passed down to gmake when non-GNU make is invoked at the top level (Thomas Munro)", "commit_aliases": ["0089c3059", "2839bf353", "3a3b361cc", "956611e4c", "9ad5ea82d"], "source_commits": ["2839bf353"], "source_entry_id": "11.5/changes/043", "db_id": "553a4a7c52d922fe873de9ac4aa62a2b", "patch_ids": ["7c5da8cc4831bd421c5503f52f2e672b"], "statement_hash": "de2e0d3d12f04c30b0b9ba97321067f114ae9e36626128c925f7b7796b9d1c4c", "relations": [{"rule": 2, "type": "equivalent", "target": "2133c3b83b805236e61b5c161d74e10a", "evidence": {"same_day": true, "patch_ids": ["7c5da8cc4831bd421c5503f52f2e672b"], "statement_hash": "de2e0d3d12f04c30b0b9ba97321067f114ae9e36626128c925f7b7796b9d1c4c"}}, {"rule": 2, "type": "equivalent", "target": "367a44d632adbecc7f19ff59ba53d74d", "evidence": {"same_day": true, "patch_ids": ["7c5da8cc4831bd421c5503f52f2e672b"], "statement_hash": "de2e0d3d12f04c30b0b9ba97321067f114ae9e36626128c925f7b7796b9d1c4c"}}, {"rule": 2, "type": "equivalent", "target": "79f703f315215a6ebacb568ad3d750d4", "evidence": {"same_day": true, "patch_ids": ["7c5da8cc4831bd421c5503f52f2e672b"], "statement_hash": "de2e0d3d12f04c30b0b9ba97321067f114ae9e36626128c925f7b7796b9d1c4c"}}], "version": "11.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "367a44d632adbecc7f19ff59ba53d74d", "kind": "equivalent", "version": "10.10", "label": "10.10", "title": "Allow make options to be passed down to gmake when non-GNU make is invoked at the top level", "evidence": {"same_day": true, "patch_ids": ["7c5da8cc4831bd421c5503f52f2e672b"], "statement_hash": "de2e0d3d12f04c30b0b9ba97321067f114ae9e36626128c925f7b7796b9d1c4c"}, "url": "/docs/compare/?release=10.10#10.10-bd84a06de216e24d", "source_url": "/docs/release/10.10/#id-1.11.6.18.5"}, {"db_id": "2133c3b83b805236e61b5c161d74e10a", "kind": "equivalent", "version": "9.6.15", "label": "9.6.15", "title": "Allow make options to be passed down to gmake when non-GNU make is invoked at the top level", "evidence": {"same_day": true, "patch_ids": ["7c5da8cc4831bd421c5503f52f2e672b"], "statement_hash": "de2e0d3d12f04c30b0b9ba97321067f114ae9e36626128c925f7b7796b9d1c4c"}, "url": "/docs/compare/?release=9.6.15#9.6.15-bd84a06de216e24d", "source_url": "/docs/release/9.6.15/#AEN133502"}, {"db_id": "79f703f315215a6ebacb568ad3d750d4", "kind": "equivalent", "version": "9.5.19", "label": "9.5.19", "title": "Allow make options to be passed down to gmake when non-GNU make is invoked at the top level", "evidence": {"same_day": true, "patch_ids": ["7c5da8cc4831bd421c5503f52f2e672b"], "statement_hash": "de2e0d3d12f04c30b0b9ba97321067f114ae9e36626128c925f7b7796b9d1c4c"}, "url": "/docs/compare/?release=9.5.19#9.5.19-bd84a06de216e24d", "source_url": "/docs/release/9.5.19/#AEN128323"}]}, {"id": "11.5-c91b4840d57e40b9", "cves": [], "html": "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.
", "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/11.5/#id-1.11.6.22.5", "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": ["4459266bf"], "source_entry_id": "11.5/changes/044", "db_id": "77053372da7af5c46b1bec1d886d85a8", "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": "df87d555f2babb058977abd9daf3ecfd", "evidence": {"same_day": true, "patch_ids": ["fd131fa8b8a4461a6064daa8fe8c1db0"], "statement_hash": "35ffa55d1deeb8d498068ccdd098deef71049f39677b2bc78488c831419c6568"}}], "version": "11.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"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"}, {"db_id": "df87d555f2babb058977abd9daf3ecfd", "kind": "equivalent", "version": "9.4.24", "label": "9.4.24", "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.4.24#9.4.24-c91b4840d57e40b9", "source_url": "/docs/release/9.4.24/#AEN120159"}]}, {"id": "11.5-ae1a5672e8d0d548", "cves": [], "html": "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.
Sync our copy of the timezone library with IANA tzcode release 2019b (Tom Lane)
\nThis 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.
Update time zone data files to tzdata release 2019b for DST law changes in Brazil, plus historical corrections for Hong Kong, Italy, and Palestine.
", "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/11.5/#id-1.11.6.22.5", "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": ["bcafb675a"], "source_entry_id": "11.5/changes/047", "db_id": "ed0eefba318199db1daa78df9e376570", "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": "f3ef38a6e778452ae46b46d3f5bbc7bd", "evidence": {"same_day": true, "patch_ids": ["0f1540aee091ba8ff6fe78f53e0b74dd"], "statement_hash": "6d732895efa004b27a61a334019a52f16fb169bb69d438150092c54b3e8fb989"}}], "version": "11.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"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"}, {"db_id": "f3ef38a6e778452ae46b46d3f5bbc7bd", "kind": "equivalent", "version": "9.4.24", "label": "9.4.24", "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.4.24#9.4.24-06a880645c10a33c", "source_url": "/docs/release/9.4.24/#AEN120159"}]}]}], "stats": [{"key": "all", "label": "All changes", "count": 47}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 18}, {"key": "security", "label": "Security", "count": 2}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 27}], "total": 47, "release_count": 1, "cross_major": false, "cve_count": 3, "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": "11.5"}, {"id": "CVE-2019-10209", "url": "https://www.postgresql.org/support/security/CVE-2019-10209/", "fixed": {"11": "11.5"}, "score": 3.1, "title": "Fix execution of hashed subplans that require cross-type comparison", "vector": "AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:N/A:N", "affected": {"11": "11"}, "component": "core server", "published": {"11": "2019-08-08"}, "introduced": {}, "cvss_version": "3.0", "description_en": "In a database containing hypothetical, user-defined hash equality operators, an attacker could read arbitrary bytes of server memory. For an attack to become possible, a superuser would need to create unusual operators. It is possible for operators not purpose-crafted for attack to have the properties that enable an attack, but we are not aware of specific examples.\n\nThe PostgreSQL project thanks Andreas Seltenreich for reporting this problem.", "first_published": "2019-08-08", "fixed_version": "11.5"}, {"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": 47, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}