A dump/restore is not required for those running 9.0.X.
\nHowever, if you are upgrading from a version earlier than 9.0.4, see Section E.20.
", "compatibility_count": 0, "label": "9.0.5", "status_label": "Historical", "eol": "2015-10-08", "age_days": 5482, "support_days": -4009}, "groups": [{"date": "2011-09-26", "build": "9.0.5", "major": "9.0", "minor": 5, "manual": "9.0", "status": "stable", "doc_git": "", "version": "9.0.5", "eol_date": "2015-10-08", "date_text": "2011-09-26", "supported": false, "manual_url": "/docs/9.0/release-9-0-5.html", "source_url": "/docs/release/9.0.5/", "entry_count": 64, "placeholder": false, "content_hash": "6720710920cc95ebad2a68e185933d6403825d4e528c19b48690368e8a9b877e", "manual_build": "9.0.23", "source_as_of": "", "changes_count": 64, "doc_loaded_at": "2026-09-25T02:22:44.760693", "migration_html": "A dump/restore is not required for those running 9.0.X.
\nHowever, if you are upgrading from a version earlier than 9.0.4, see Section E.20.
", "compatibility_count": 0, "label": "9.0.5", "status_label": "Historical", "eol": "2015-10-08", "age_days": 5482, "support_days": -4009, "entries": [{"id": "9.0.5-70737f1cf721022d", "cves": [], "html": "Fix catalog cache invalidation after a VACUUM FULL or CLUSTER on a system catalog (Tom Lane)
\nIn some cases the relocation of a system catalog row to another place would not be recognized by concurrent server processes, allowing catalog corruption to occur if they then tried to update that row. The worst-case outcome could be as bad as complete loss of a table.
", "text": "Fix catalog cache invalidation after a VACUUM FULL or CLUSTER on a system catalog (Tom Lane) In some cases the relocation of a system catalog row to another place would not be recognized by concurrent server processes, allowing catalog corruption to occur if they then tried to update that row. The worst-case outcome could be as bad as complete loss of a table.", "title": "Fix catalog cache invalidation after a VACUUM FULL or CLUSTER on a system catalog", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "c20d4c45cfff3c07585a526b32023088f505a102feb830d631270e2edf9a77f5", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix catalog cache invalidation after a VACUUM FULL or CLUSTER on a system catalog (Tom Lane) In some cases the relocation of a system catalog row to another place would not be recognized by concurrent server processes, allowing catalog corruption to occur if they then tried to update that row. The worst-case outcome could be as bad as complete loss of a table.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/001", "db_id": "856e9d5d223d74d568f0e17f5afbbfc2", "patch_ids": [], "statement_hash": "63863d095ef33e79cedb032eb30c9fd047099049cc60f677b5ea37d6dcdbc862", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-82e3a12bb9213afc", "cves": [], "html": "Fix incorrect order of operations during sinval reset processing, and ensure that TOAST OIDs are preserved in system catalogs (Tom Lane)
\nThese mistakes could lead to transient failures after a VACUUM FULL or CLUSTER on a system catalog.
", "text": "Fix incorrect order of operations during sinval reset processing, and ensure that TOAST OIDs are preserved in system catalogs (Tom Lane) These mistakes could lead to transient failures after a VACUUM FULL or CLUSTER on a system catalog.", "title": "Fix incorrect order of operations during sinval reset processing, and ensure that TOAST OIDs are preserved in system catalogs", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "ae0c040c454f08084d3396d97155b7d30fe30ab8a9ec9f04659020d85452c94a", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix incorrect order of operations during sinval reset processing, and ensure that TOAST OIDs are preserved in system catalogs (Tom Lane) These mistakes could lead to transient failures after a VACUUM FULL or CLUSTER on a system catalog.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/002", "db_id": "447cf27aad36ec45d993fc170834c613", "patch_ids": [], "statement_hash": "248ec099036427aabc2b9fbf033f2d1c6e0755a0238ff85d8c48d3bc76caa360", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-1e494e711173b117", "cves": [], "html": "Fix bugs in indexing of in-doubt HOT-updated tuples (Tom Lane)
\nThese bugs could result in index corruption after reindexing a system catalog. They are not believed to affect user indexes.
", "text": "Fix bugs in indexing of in-doubt HOT-updated tuples (Tom Lane) These bugs could result in index corruption after reindexing a system catalog. They are not believed to affect user indexes.", "title": "Fix bugs in indexing of in-doubt HOT-updated tuples", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "5d6ca5c3d96472de04f7cbbf2e1ba620e95401a447468540fd0f09081dd34b0f", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix bugs in indexing of in-doubt HOT-updated tuples (Tom Lane) These bugs could result in index corruption after reindexing a system catalog. They are not believed to affect user indexes.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/003", "db_id": "694bb6b55270e077158b51ac03a7c398", "patch_ids": [], "statement_hash": "7e3f920bad95df37786f12de0335c438fc09b2ba045ec55436c2d0aef18cf501", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-cc480c8eb689983b", "cves": [], "html": "Fix multiple bugs in GiST index page split processing (Heikki Linnakangas)
\nThe probability of occurrence was low, but these could lead to index corruption.
", "text": "Fix multiple bugs in GiST index page split processing (Heikki Linnakangas) The probability of occurrence was low, but these could lead to index corruption.", "title": "Fix multiple bugs in GiST index page split processing", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "26ed948fc24a56125611747ae40ab4dd55d9d4e6a016d3fc9ec89200b4ed7483", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix multiple bugs in GiST index page split processing (Heikki Linnakangas) The probability of occurrence was low, but these could lead to index corruption.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/004", "db_id": "65356b0cef0cbd777ceeb26e78dfdc18", "patch_ids": [], "statement_hash": "85c5527676fcc8624e3aec3fa758cf8407520bac6bc88d650ebfce4a1dd000b5", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-f940f9e21069dcd9", "cves": [], "html": "Fix possible buffer overrun in tsvector_concat() (Tom Lane)
The function could underestimate the amount of memory needed for its result, leading to server crashes.
", "text": "Fix possible buffer overrun in tsvector_concat() (Tom Lane) The function could underestimate the amount of memory needed for its result, leading to server crashes.", "title": "Fix possible buffer overrun in tsvector_concat()", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "9781609519add05cb38c06b912c4d52fc129b3438a75273b9501b923ab4588e8", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix possible buffer overrun in tsvector_concat() (Tom Lane) The function could underestimate the amount of memory needed for its result, leading to server crashes.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/005", "db_id": "f7c63b89903fb3a8c2a478abff3496f6", "patch_ids": [], "statement_hash": "6fe54e948134cccddc2f0168daa3aaa99e0a7412033d1e2c070e5fa0a0c1f7b4", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-a5da9f69eec770c1", "cves": [], "html": "Fix crash in xml_recv when processing a \"standalone\" parameter (Tom Lane)
Make pg_options_to_table return NULL for an option with no value (Tom Lane)
Previously such cases would result in a server crash.
", "text": "Make pg_options_to_table return NULL for an option with no value (Tom Lane) Previously such cases would result in a server crash.", "title": "Make pg_options_to_table return NULL for an option with no value", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "ef2c4fc70b5bfc80d699a96673e3d789c23325a49e97565fcfedf20919eca37b", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Make pg_options_to_table return NULL for an option with no value (Tom Lane) Previously such cases would result in a server crash.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/007", "db_id": "3275f538db4250626cf3e2aa565b86e3", "patch_ids": [], "statement_hash": "c5a91c96a58e17d12b264f8f1d6c5d86d29e514b4299ea3b821b642e03ac9f0b", "relations": [{"rule": 2, "type": "equivalent", "target": "5b6cb6d2b65558c733595876dca7678e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5a91c96a58e17d12b264f8f1d6c5d86d29e514b4299ea3b821b642e03ac9f0b"}}], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": [{"db_id": "5b6cb6d2b65558c733595876dca7678e", "kind": "equivalent", "version": "9.1.1", "label": "9.1.1", "title": "Make pg_options_to_table return NULL for an option with no value", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "c5a91c96a58e17d12b264f8f1d6c5d86d29e514b4299ea3b821b642e03ac9f0b"}, "url": "/docs/compare/?release=9.1.1#9.1.1-2743ca23e1d6c508", "source_url": "/docs/release/9.1.1/#AEN110354"}]}, {"id": "9.0.5-e129ac1e8ae585bb", "cves": [], "html": "Avoid possibly accessing off the end of memory in ANALYZE and in SJIS-2004 encoding conversion (Noah Misch)
\nThis fixes some very-low-probability server crash scenarios.
", "text": "Avoid possibly accessing off the end of memory in ANALYZE and in SJIS-2004 encoding conversion (Noah Misch) This fixes some very-low-probability server crash scenarios.", "title": "Avoid possibly accessing off the end of memory in ANALYZE and in SJIS-2004 encoding conversion", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "c3d1d102b63f6310954b6049ee7f546c4e39e1615eb7925670c13da9039b04a4", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid possibly accessing off the end of memory in ANALYZE and in SJIS-2004 encoding conversion (Noah Misch) This fixes some very-low-probability server crash scenarios.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/008", "db_id": "b15ac05af66b011a2bbfd3e21b7bff04", "patch_ids": [], "statement_hash": "4186b29ee691ee044380791f0b587ea72dae6f25e0c1ebb3c15a3ccea612782f", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-0eed688dd47faf0f", "cves": [], "html": "Protect pg_stat_reset_shared() against NULL input (Magnus Hagander)
Fix possible failure when a recovery conflict deadlock is detected within a sub-transaction (Tom Lane)
", "text": "Fix possible failure when a recovery conflict deadlock is detected within a sub-transaction (Tom Lane)", "title": "Fix possible failure when a recovery conflict deadlock is detected within a sub-transaction", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "5ed8c395829e609e26f953ee7565d2852a46e0ef0a1247555e852bad67e2c092", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix possible failure when a recovery conflict deadlock is detected within a sub-transaction (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/010", "db_id": "dcf64558c3fa1974ae2244457843775c", "patch_ids": [], "statement_hash": "0973d9b455346e91c4d83873a3f16a9e881e840f15a590276e1413b0d8ba17fe", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-2ac0e1bf916ef378", "cves": [], "html": "Avoid spurious conflicts while recycling btree index pages during hot standby (Noah Misch, Simon Riggs)
", "text": "Avoid spurious conflicts while recycling btree index pages during hot standby (Noah Misch, Simon Riggs)", "title": "Avoid spurious conflicts while recycling btree index pages during hot standby", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "f9cf2cbc69caa94d1a9069f82b7dc522c1e0e9572755ce63d6d3de5ac7a4d6ec", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid spurious conflicts while recycling btree index pages during hot standby (Noah Misch, Simon Riggs)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/011", "db_id": "f53165e2b121acf845fc00e43a6b09b5", "patch_ids": [], "statement_hash": "b04ee02920bbdb0c84980fe57fb033d60eaebf11f2d1964b86752c70c65d0228", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-8c67319c8367378a", "cves": [], "html": "Shut down WAL receiver if it's still running at end of recovery (Heikki Linnakangas)
\nThe postmaster formerly panicked in this situation, but it's actually a legitimate case.
", "text": "Shut down WAL receiver if it's still running at end of recovery (Heikki Linnakangas) The postmaster formerly panicked in this situation, but it's actually a legitimate case.", "title": "Shut down WAL receiver if it's still running at end of recovery", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "307065e1847fa3e9c61b9adeb9423f1874a8df604e2d17ebe14f4ba3bd418fbb", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Shut down WAL receiver if it's still running at end of recovery (Heikki Linnakangas) The postmaster formerly panicked in this situation, but it's actually a legitimate case.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/012", "db_id": "ac7799aef9cb07e00ee702eb95c994f1", "patch_ids": [], "statement_hash": "95c7c6fdc183c0038ec2b7d655734aa9e8669b9026940631ee2b5beba7ca4147", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-4dc7e8d40f5b87cf", "cves": [], "html": "Fix race condition in relcache init file invalidation (Tom Lane)
\nThere was a window wherein a new backend process could read a stale init file but miss the inval messages that would tell it the data is stale. The result would be bizarre failures in catalog accesses, typically \"could not read block 0 in file ...\" later during startup.
", "text": "Fix race condition in relcache init file invalidation (Tom Lane) There was a window wherein a new backend process could read a stale init file but miss the inval messages that would tell it the data is stale. The result would be bizarre failures in catalog accesses, typically \"could not read block 0 in file ...\" later during startup.", "title": "Fix race condition in relcache init file invalidation", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "8848e6ed14a8bf17ef585d48f0788fc5916b2f69403abef8090da7b8ce2c0fc5", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix race condition in relcache init file invalidation (Tom Lane) There was a window wherein a new backend process could read a stale init file but miss the inval messages that would tell it the data is stale. The result would be bizarre failures in catalog accesses, typically could not read block 0 in file ... later during startup.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/013", "db_id": "6551ce20b6d12f5ac4a62be33f11a9a5", "patch_ids": [], "statement_hash": "9568f308fc0b02167a5a672baeecbf160a6f018e18bad2a4e2836c468ff21fe7", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-3214d8c6072190b1", "cves": [], "html": "Fix memory leak at end of a GiST index scan (Tom Lane)
\nCommands that perform many separate GiST index scans, such as verification of a new GiST-based exclusion constraint on a table already containing many rows, could transiently require large amounts of memory due to this leak.
", "text": "Fix memory leak at end of a GiST index scan (Tom Lane) Commands that perform many separate GiST index scans, such as verification of a new GiST-based exclusion constraint on a table already containing many rows, could transiently require large amounts of memory due to this leak.", "title": "Fix memory leak at end of a GiST index scan", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "fdb92f56027c9ddb6a06f1a7c1a8d3eabbd8f28e1f0a26aa2ddb28460dbbe33f", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix memory leak at end of a GiST index scan (Tom Lane) Commands that perform many separate GiST index scans, such as verification of a new GiST-based exclusion constraint on a table already containing many rows, could transiently require large amounts of memory due to this leak.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/014", "db_id": "5663370bfa82647a3e2d0d54fa53390d", "patch_ids": [], "statement_hash": "8874e4cbab18a89732c29a6ac6e39590040bb8903e77ecc7207f67ff9d1b8d9c", "relations": [{"rule": 2, "type": "equivalent", "target": "fa34ca25147b2f0661795577525fb45e", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8874e4cbab18a89732c29a6ac6e39590040bb8903e77ecc7207f67ff9d1b8d9c"}}], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": [{"db_id": "fa34ca25147b2f0661795577525fb45e", "kind": "equivalent", "version": "9.1.1", "label": "9.1.1", "title": "Fix memory leak at end of a GiST index scan", "evidence": {"same_day": true, "patch_ids": [], "statement_hash": "8874e4cbab18a89732c29a6ac6e39590040bb8903e77ecc7207f67ff9d1b8d9c"}, "url": "/docs/compare/?release=9.1.1#9.1.1-3214d8c6072190b1", "source_url": "/docs/release/9.1.1/#AEN110354"}]}, {"id": "9.0.5-2ae7e8012d303ccb", "cves": [], "html": "Fix memory leak when encoding conversion has to be done on incoming command strings and LISTEN is active (Tom Lane)
", "text": "Fix memory leak when encoding conversion has to be done on incoming command strings and LISTEN is active (Tom Lane)", "title": "Fix memory leak when encoding conversion has to be done on incoming command strings and LISTEN is active", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "8293189a75d056e27f46d9750bc15fabf686c0989b03125310efeecd6945ba10", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix memory leak when encoding conversion has to be done on incoming command strings and LISTEN is active (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/015", "db_id": "af59f65f61654b847c7788988c94361a", "patch_ids": [], "statement_hash": "cdd5cb03934c910ad7f52513ddf61274529989dc4cd535f1b1117b96b22d9b4a", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-6ec50725a5b0fac0", "cves": [], "html": "Fix incorrect memory accounting (leading to possible memory bloat) in tuplestores supporting holdable cursors and plpgsql's RETURN NEXT command (Tom Lane)
", "text": "Fix incorrect memory accounting (leading to possible memory bloat) in tuplestores supporting holdable cursors and plpgsql's RETURN NEXT command (Tom Lane)", "title": "Fix incorrect memory accounting (leading to possible memory bloat) in tuplestores supporting holdable cursors and plpgsql's RETURN NEXT command", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "6b8d88e22ef10075039edc4436f829c8e3a2d585a1b326a720b5ff49ee94670d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix incorrect memory accounting (leading to possible memory bloat) in tuplestores supporting holdable cursors and plpgsql's RETURN NEXT command (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/016", "db_id": "22568f3287258d608e50fe915c6d001c", "patch_ids": [], "statement_hash": "b0e38a1946570ed2dc6271b314ae7cedc2861ec9f69ae4ccb0c1beda5016dd1f", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-ce336e3c9f957f63", "cves": [], "html": "Fix trigger WHEN conditions when both BEFORE and AFTER triggers exist (Tom Lane)
\nEvaluation of WHEN conditions for AFTER ROW UPDATE triggers could crash if there had been a BEFORE ROW trigger fired for the same update.
", "text": "Fix trigger WHEN conditions when both BEFORE and AFTER triggers exist (Tom Lane) Evaluation of WHEN conditions for AFTER ROW UPDATE triggers could crash if there had been a BEFORE ROW trigger fired for the same update.", "title": "Fix trigger WHEN conditions when both BEFORE and AFTER triggers exist", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "bc070d7d0309506446a2f74c037a95dbc388e4114aa327c57b9966eb1e9587cc", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix trigger WHEN conditions when both BEFORE and AFTER triggers exist (Tom Lane) Evaluation of WHEN conditions for AFTER ROW UPDATE triggers could crash if there had been a BEFORE ROW trigger fired for the same update.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/017", "db_id": "8812d18aa06489526250e6c6492a37ee", "patch_ids": [], "statement_hash": "d0efaefc1fe59fca219af6ae6af3585d49e137a731f08f8b0299062cfee6780a", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-1a32f52875f7ed46", "cves": [], "html": "Fix performance problem when constructing a large, lossy bitmap (Tom Lane)
", "text": "Fix performance problem when constructing a large, lossy bitmap (Tom Lane)", "title": "Fix performance problem when constructing a large, lossy bitmap", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "b85224e0f6a8b93e2351815fb20a2503c37e04e35e70fc2f5d62e63f6d9556d8", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix performance problem when constructing a large, lossy bitmap (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/018", "db_id": "55cc6f55cba55ffa93ef57961be2ac95", "patch_ids": [], "statement_hash": "e44ebdbcbb59cf95f8c20bc38cd4e83e633de9440fdefc182753b42951bc8531", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-4f80ed4637f07068", "cves": [], "html": "Fix join selectivity estimation for unique columns (Tom Lane)
\nThis fixes an erroneous planner heuristic that could lead to poor estimates of the result size of a join.
", "text": "Fix join selectivity estimation for unique columns (Tom Lane) This fixes an erroneous planner heuristic that could lead to poor estimates of the result size of a join.", "title": "Fix join selectivity estimation for unique columns", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "905ec20ae679c45d08d02bc727e9826ea1433ccdb194e3f1b6480afe38379014", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix join selectivity estimation for unique columns (Tom Lane) This fixes an erroneous planner heuristic that could lead to poor estimates of the result size of a join.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/019", "db_id": "7dad43c8353783a77a650810dae8791b", "patch_ids": [], "statement_hash": "a87da81d67ddab08c882787371b18e36ad654341a685b5aee4e0c2a345945018", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-d6d11689e77f088d", "cves": [], "html": "Fix nested PlaceHolderVar expressions that appear only in sub-select target lists (Tom Lane)
\nThis mistake could result in outputs of an outer join incorrectly appearing as NULL.
", "text": "Fix nested PlaceHolderVar expressions that appear only in sub-select target lists (Tom Lane) This mistake could result in outputs of an outer join incorrectly appearing as NULL.", "title": "Fix nested PlaceHolderVar expressions that appear only in sub-select target lists", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "6d4fac7e348a57bcd2e2ff08b929b0ec01aed237b9e90042764c7b39fde76b7a", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix nested PlaceHolderVar expressions that appear only in sub-select target lists (Tom Lane) This mistake could result in outputs of an outer join incorrectly appearing as NULL.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/020", "db_id": "1ec15e5aa85689c10c679e5644ecdbb3", "patch_ids": [], "statement_hash": "a1ebaf9d60cf87245f05e4ca30d1c9519a35b410ad3bfa5187a254be8277046e", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-bb34cb9eeb4dc5a5", "cves": [], "html": "Allow the planner to assume that empty parent tables really are empty (Tom Lane)
\nNormally an empty table is assumed to have a certain minimum size for planning purposes; but this heuristic seems to do more harm than good for the parent table of an inheritance hierarchy, which often is permanently empty.
", "text": "Allow the planner to assume that empty parent tables really are empty (Tom Lane) Normally an empty table is assumed to have a certain minimum size for planning purposes; but this heuristic seems to do more harm than good for the parent table of an inheritance hierarchy, which often is permanently empty.", "title": "Allow the planner to assume that empty parent tables really are empty", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "b795a1b013ccaebf53d936042a5f25065dc105d45f5137249635bae3af007ade", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Allow the planner to assume that empty parent tables really are empty (Tom Lane) Normally an empty table is assumed to have a certain minimum size for planning purposes; but this heuristic seems to do more harm than good for the parent table of an inheritance hierarchy, which often is permanently empty.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/021", "db_id": "c8f7aab04e542ab8eef63ad57ad69a58", "patch_ids": [], "statement_hash": "59b6c8414da6433822282d9a7285d01cd2bb6c6c848bc70bcaf78952d5f3869c", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-9c2dea44a1c3ded3", "cves": [], "html": "Allow nested EXISTS queries to be optimized properly (Tom Lane)
", "text": "Allow nested EXISTS queries to be optimized properly (Tom Lane)", "title": "Allow nested EXISTS queries to be optimized properly", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "abbe7021646a675c5a3674a1fbde6ecfaeed34272aea284bc5c2f5c1acd35986", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Allow nested EXISTS queries to be optimized properly (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/022", "db_id": "f6a8d525781f247b1a0254e2b4a48382", "patch_ids": [], "statement_hash": "dcef8b96e4b546e00bc6c7cd1bc4374b0e11912df74c689eeb6cf36160edf55f", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-7e21593182fd8645", "cves": [], "html": "Fix array- and path-creating functions to ensure padding bytes are zeroes (Tom Lane)
\nThis avoids some situations where the planner will think that semantically-equal constants are not equal, resulting in poor optimization.
", "text": "Fix array- and path-creating functions to ensure padding bytes are zeroes (Tom Lane) This avoids some situations where the planner will think that semantically-equal constants are not equal, resulting in poor optimization.", "title": "Fix array- and path-creating functions to ensure padding bytes are zeroes", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "26c7a7b1c06241926ad8f93b103d50d184e3da400ade9e90fd3392994afe7ec2", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix array- and path-creating functions to ensure padding bytes are zeroes (Tom Lane) This avoids some situations where the planner will think that semantically-equal constants are not equal, resulting in poor optimization.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/023", "db_id": "9497e669ed72fd24145b3791e61de4b8", "patch_ids": [], "statement_hash": "2e65199111f2b15f6deee34a853bdf0cc3826ec7ad190f3699234311b56fd59d", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-c8037bea6424c2d0", "cves": [], "html": "Fix EXPLAIN to handle gating Result nodes within inner-indexscan subplans (Tom Lane)
\nThe usual symptom of this oversight was \"bogus varno\" errors.
", "text": "Fix EXPLAIN to handle gating Result nodes within inner-indexscan subplans (Tom Lane) The usual symptom of this oversight was \"bogus varno\" errors.", "title": "Fix EXPLAIN to handle gating Result nodes within inner-indexscan subplans", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "6d311a694997f8629e88d29471d8fc0a1eb12f400d1fee677d825f6fa0fa46fc", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix EXPLAIN to handle gating Result nodes within inner-indexscan subplans (Tom Lane) The usual symptom of this oversight was bogus varno errors.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/024", "db_id": "3c1a8717a3e2be7ba66ba978a99be412", "patch_ids": [], "statement_hash": "e2e76fd9f19e74a4e3aea822bd1a9996bc1e63c2c5498f3059347a930f80877a", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-af1406cd43558f5d", "cves": [], "html": "Fix btree preprocessing of indexedcol IS NULL conditions (Dean Rasheed)
\nSuch a condition is unsatisfiable if combined with any other type of btree-indexable condition on the same index column. The case was handled incorrectly in 9.0.0 and later, leading to query output where there should be none.
", "text": "Fix btree preprocessing of indexedcol IS NULL conditions (Dean Rasheed) Such a condition is unsatisfiable if combined with any other type of btree-indexable condition on the same index column. The case was handled incorrectly in 9.0.0 and later, leading to query output where there should be none.", "title": "Fix btree preprocessing of indexedcol IS NULL conditions", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "95b1cfec18daf2c89f04a9ec59d110a6a116b02bab52b69ab507354ba2a1f8ac", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix btree preprocessing of indexedcol IS NULL conditions (Dean Rasheed) Such a condition is unsatisfiable if combined with any other type of btree-indexable condition on the same index column. The case was handled incorrectly in 9.0.0 and later, leading to query output where there should be none.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/025", "db_id": "52c1de0a09fc66d1715dd4b67ad7cd0e", "patch_ids": [], "statement_hash": "f2ebf8238a47175eaf86883f453b54351b830b826350d910f5d0e1d38514d92c", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-a181c4ebc8c0574f", "cves": [], "html": "Work around gcc 4.6.0 bug that breaks WAL replay (Tom Lane)
\nThis could lead to loss of committed transactions after a server crash.
", "text": "Work around gcc 4.6.0 bug that breaks WAL replay (Tom Lane) This could lead to loss of committed transactions after a server crash.", "title": "Work around gcc 4.6.0 bug that breaks WAL replay", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "c2ffe9cd686a8a73ab92ae7834f46833a99e673d0ac32e066621f69329faf181", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Work around gcc 4.6.0 bug that breaks WAL replay (Tom Lane) This could lead to loss of committed transactions after a server crash.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/026", "db_id": "e88cfc316fc676ded841ba7a66217586", "patch_ids": [], "statement_hash": "8bb8b96335a07e88bac007bf3bfde12d46e8a1671f066097ad5f7dbc430c5428", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-4ce281967ce3b220", "cves": [], "html": "Fix dump bug for VALUES in a view (Tom Lane)
", "text": "Fix dump bug for VALUES in a view (Tom Lane)", "title": "Fix dump bug for VALUES in a view", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "629f994d1adf5ea7f4954ac800a4f3c28291043f40cbb4f0e35cd2c40bc738f3", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix dump bug for VALUES in a view (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/027", "db_id": "a9bfd38da546eed615afbd3d607a6a23", "patch_ids": [], "statement_hash": "9f960f1184908c5db3b4f5ba0263fa71977bfa10b91a8217e65307aa443aba61", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-7fd8eb127fd69c8c", "cves": [], "html": "Disallow SELECT FOR UPDATE/SHARE on sequences (Tom Lane)
\nThis operation doesn't work as expected and can lead to failures.
", "text": "Disallow SELECT FOR UPDATE/SHARE on sequences (Tom Lane) This operation doesn't work as expected and can lead to failures.", "title": "Disallow SELECT FOR UPDATE/SHARE on sequences", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "70fdc4e13c14e4621f265195984a05d3d15a43f5c2e65b2c5cd437e30dac4975", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Disallow SELECT FOR UPDATE/SHARE on sequences (Tom Lane) This operation doesn't work as expected and can lead to failures.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/028", "db_id": "e4e9bff2da207c3597b9846ce5f98556", "patch_ids": [], "statement_hash": "e340a2209a2573f31d2d74657e9db8987726a88b80640dd6450ba3bef8872335", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-a543beb5c2d70dc3", "cves": [], "html": "Fix VACUUM so that it always updates pg_class.reltuples/relpages (Tom Lane)
\nThis fixes some scenarios where autovacuum could make increasingly poor decisions about when to vacuum tables.
", "text": "Fix VACUUM so that it always updates pg_class.reltuples/relpages (Tom Lane) This fixes some scenarios where autovacuum could make increasingly poor decisions about when to vacuum tables.", "title": "Fix VACUUM so that it always updates pg_class.reltuples/relpages", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "4a0f450a9436ec3c5f1de00d3ad3d15309321ab56d2d83e7e77559608854fcb3", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix VACUUM so that it always updates pg_class.reltuples/relpages (Tom Lane) This fixes some scenarios where autovacuum could make increasingly poor decisions about when to vacuum tables.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/029", "db_id": "17150a9b8c992338101b85c58ad82304", "patch_ids": [], "statement_hash": "0f5790194aaaee7128f9e6ac233fba2540e29afdc136c3c5756badf884a5fc05", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-3ad7e0949c347cfb", "cves": [], "html": "Defend against integer overflow when computing size of a hash table (Tom Lane)
", "text": "Defend against integer overflow when computing size of a hash table (Tom Lane)", "title": "Defend against integer overflow when computing size of a hash table", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "098fd8c0a20624203516b865f8fd7c310ac29b1d093f9070030a4d4f1f8fb632", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Defend against integer overflow when computing size of a hash table (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/030", "db_id": "2579443088e1eea68df44d485fb4a18c", "patch_ids": [], "statement_hash": "11bdc5c76fc2b17a837929748392dd3c8e1628814149c9860b744512c540df6d", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-236bce6710178bd3", "cves": [], "html": "Fix cases where CLUSTER might attempt to access already-removed TOAST data (Tom Lane)
", "text": "Fix cases where CLUSTER might attempt to access already-removed TOAST data (Tom Lane)", "title": "Fix cases where CLUSTER might attempt to access already-removed TOAST data", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "6827e20bbc7efc3ffc7f479ff5a862d7cd6856607d543770770f187d7ba3eefa", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix cases where CLUSTER might attempt to access already-removed TOAST data (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/031", "db_id": "c72ef84acc516077dd9cd60b715b9d60", "patch_ids": [], "statement_hash": "580e9de0e176ab5203c6f021892377c1bc8b7ba56fd66a693a704f754e51ccd7", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-6a0c62956a300c06", "cves": [], "html": "Fix premature timeout failures during initial authentication transaction (Tom Lane)
", "text": "Fix premature timeout failures during initial authentication transaction (Tom Lane)", "title": "Fix premature timeout failures during initial authentication transaction", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "730a4bcc23571e31d929c47196fe9ac3e788133bfb4b35885261d1be9624122e", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix premature timeout failures during initial authentication transaction (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/032", "db_id": "15a9237fa68fae4b0d10cbfc65641d21", "patch_ids": [], "statement_hash": "732936b06c1497e801443b1408493c8dd6bd35cf4dc94249cdc36682895e6934", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-fe521511ebbdcf6f", "cves": [], "html": "Fix portability bugs in use of credentials control messages for \"peer\" authentication (Tom Lane)
", "text": "Fix portability bugs in use of credentials control messages for \"peer\" authentication (Tom Lane)", "title": "Fix portability bugs in use of credentials control messages for \"peer\" authentication", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "707e792a951a2481edd7e5198168c90e0248908585623a95eaa798f6d1ff482c", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix portability bugs in use of credentials control messages for peer authentication (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/033", "db_id": "6f6808ceee482a9ed9d8b55a2085d442", "patch_ids": [], "statement_hash": "cb6fbd738a87b296793cc48ca50f75cc9bd6f8097aa344261656ac5898e950e5", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-79157c64d345f33f", "cves": [], "html": "Fix SSPI login when multiple roundtrips are required (Ahmed Shinwari, Magnus Hagander)
\nThe typical symptom of this problem was \"The function requested is not supported\" errors during SSPI login.
", "text": "Fix SSPI login when multiple roundtrips are required (Ahmed Shinwari, Magnus Hagander) The typical symptom of this problem was \"The function requested is not supported\" errors during SSPI login.", "title": "Fix SSPI login when multiple roundtrips are required", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "f1f3975518d8eff680f5c29ae7d80eeb58b8fe6e3eda5868fe2dc4b0ccb40b3b", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix SSPI login when multiple roundtrips are required (Ahmed Shinwari, Magnus Hagander) The typical symptom of this problem was The function requested is not supported errors during SSPI login.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/034", "db_id": "de930a64439fe15c6fb5927b1a514612", "patch_ids": [], "statement_hash": "ab01a1b223d43d2a06696c29615f44109d67e8e53fd9e73b29f96228b99bf650", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-7ffd2c19f96a5540", "cves": [], "html": "Fix failure when adding a new variable of a custom variable class to postgresql.conf (Tom Lane)
", "text": "Fix failure when adding a new variable of a custom variable class to postgresql.conf (Tom Lane)", "title": "Fix failure when adding a new variable of a custom variable class to postgresql.conf", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "4a730688e140cf7576fd0467a689781d2a0c2b65795b5e873cf42c98a9f56d91", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix failure when adding a new variable of a custom variable class to postgresql.conf (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/035", "db_id": "2429c675b934971d682aca5c5a2a51a0", "patch_ids": [], "statement_hash": "860673118bbda9f103f29c41b94491705df2bc27d885e8c3a28677f65aef1481", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-07a9b8384516e637", "cves": [], "html": "Throw an error if pg_hba.conf contains hostssl but SSL is disabled (Tom Lane)
\nThis was concluded to be more user-friendly than the previous behavior of silently ignoring such lines.
", "text": "Throw an error if pg_hba.conf contains hostssl but SSL is disabled (Tom Lane) This was concluded to be more user-friendly than the previous behavior of silently ignoring such lines.", "title": "Throw an error if pg_hba.conf contains hostssl but SSL is disabled", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "8982feb6f172ac9516467958ba21f5fd0bba63b25632751c7c33d647d7c070ff", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Throw an error if pg_hba.conf contains hostssl but SSL is disabled (Tom Lane) This was concluded to be more user-friendly than the previous behavior of silently ignoring such lines.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/036", "db_id": "3bc5bad025281e1d8dfd4cd091d37411", "patch_ids": [], "statement_hash": "c2f35d109c4dc81195dd7b963c6e4252915f05aea85b001d78188bf8ff764393", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-6c28412136473442", "cves": [], "html": "Fix failure when DROP OWNED BY attempts to remove default privileges on sequences (Shigeru Hanada)
", "text": "Fix failure when DROP OWNED BY attempts to remove default privileges on sequences (Shigeru Hanada)", "title": "Fix failure when DROP OWNED BY attempts to remove default privileges on sequences", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "5df2b0b8bda503738445a525582394d4ab8bab53fe97b3dd2a4f9e1f32ae0c3c", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix failure when DROP OWNED BY attempts to remove default privileges on sequences (Shigeru Hanada)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/037", "db_id": "a0dc2b3a31aa65c92e80428f8ebed71e", "patch_ids": [], "statement_hash": "8adfc2fc84bd5880acee351fdc7b516cd689cf78c485ed8e1f02c9c2f4145d31", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-971125e0f8eb8d14", "cves": [], "html": "Fix typo in pg_srand48 seed initialization (Andres Freund)
This led to failure to use all bits of the provided seed. This function is not used on most platforms (only those without srandom), and the potential security exposure from a less-random-than-expected seed seems minimal in any case.
Avoid integer overflow when the sum of LIMIT and OFFSET values exceeds 2^63 (Heikki Linnakangas)
", "text": "Avoid integer overflow when the sum of LIMIT and OFFSET values exceeds 2^63 (Heikki Linnakangas)", "title": "Avoid integer overflow when the sum of LIMIT and OFFSET values exceeds 2^63", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "cbff0cd5e458765535aafff1b67fb705e452f4d7a543a564039dfe7669c38297", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Avoid integer overflow when the sum of LIMIT and OFFSET values exceeds 2^63 (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/039", "db_id": "3290d9413373e594e9f3d16c22b95063", "patch_ids": [], "statement_hash": "df1103b9b1d8136ab89450a9726f7d52ff2b187e15d20c2f99ad5bc0cc081c8a", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-ef148390ffa9747f", "cves": [], "html": "Add overflow checks to int4 and int8 versions of generate_series() (Robert Haas)
Fix trailing-zero removal in to_char() (Marti Raudsepp)
In a format with FM and no digit positions after the decimal point, zeroes to the left of the decimal point could be removed incorrectly.
", "text": "Fix trailing-zero removal in to_char() (Marti Raudsepp) In a format with FM and no digit positions after the decimal point, zeroes to the left of the decimal point could be removed incorrectly.", "title": "Fix trailing-zero removal in to_char()", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "77f445402e0bba2b6c603b84d6588e215599762946cfbd630eed0efac13ae4e0", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix trailing-zero removal in to_char() (Marti Raudsepp) In a format with FM and no digit positions after the decimal point, zeroes to the left of the decimal point could be removed incorrectly.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/041", "db_id": "29fee015b85b064dbe56a39bd2d43f89", "patch_ids": [], "statement_hash": "74a1cb9a6c71025cc94e282f923c5fd5efd2eb5d38d77873e690ba73f2dcd453", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-26d8d27be4d22621", "cves": [], "html": "Fix pg_size_pretty() to avoid overflow for inputs close to 2^63 (Tom Lane)
Weaken plpgsql's check for typmod matching in record values (Tom Lane)
\nAn overly enthusiastic check could lead to discarding length modifiers that should have been kept.
", "text": "Weaken plpgsql's check for typmod matching in record values (Tom Lane) An overly enthusiastic check could lead to discarding length modifiers that should have been kept.", "title": "Weaken plpgsql's check for typmod matching in record values", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "08b79c31cb927f9fe618aceef340960d24be3847cb653738b99f11b820993446", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Weaken plpgsql's check for typmod matching in record values (Tom Lane) An overly enthusiastic check could lead to discarding length modifiers that should have been kept.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/043", "db_id": "aa5c1fc267ab4160fca5c4b2d84f5083", "patch_ids": [], "statement_hash": "cad4edd036a183354d872eec2c4c84858fb28b0c988301e582c1b18543fcb0a1", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-f4540588a38622db", "cves": [], "html": "Correctly handle quotes in locale names during initdb (Heikki Linnakangas)
\nThe case can arise with some Windows locales, such as \"People's Republic of China\".
", "text": "Correctly handle quotes in locale names during initdb (Heikki Linnakangas) The case can arise with some Windows locales, such as \"People's Republic of China\".", "title": "Correctly handle quotes in locale names during initdb", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "cd44d96038b8d61704ab9f6996a310da211855039d0c85b76a1c9fa8bcacf7a5", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Correctly handle quotes in locale names during initdb (Heikki Linnakangas) The case can arise with some Windows locales, such as People's Republic of China.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/044", "db_id": "5a38c8c5ca59255222e5985f0a9bdf0c", "patch_ids": [], "statement_hash": "4d0a997eb7763684cee9e01ea136e39c98657c75d954f3f9c65b6baa4944248b", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-72aa93c34c619faa", "cves": [], "html": "In pg_upgrade, avoid dumping orphaned temporary tables (Bruce Momjian)
\nThis prevents situations wherein table OID assignments could get out of sync between old and new installations.
", "text": "In pg_upgrade, avoid dumping orphaned temporary tables (Bruce Momjian) This prevents situations wherein table OID assignments could get out of sync between old and new installations.", "title": "In pg_upgrade, avoid dumping orphaned temporary tables", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "833100418cbcbcafcf60497ce8292624bfc8c69a0de75bdef107584197b1484c", "section_path": ["Changes"], "commit_groups": [], "identity_text": "In pg_upgrade, avoid dumping orphaned temporary tables (Bruce Momjian) This prevents situations wherein table OID assignments could get out of sync between old and new installations.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/045", "db_id": "765c8c68aa3b0490a3144b5de0374973", "patch_ids": [], "statement_hash": "c33616aeadca6719d71e7f27485695b8da8c2070c734f3f96ba51c7887464d95", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-b2375574807f4216", "cves": [], "html": "Fix pg_upgrade to preserve toast tables' relfrozenxids during an upgrade from 8.3 (Bruce Momjian)
\nFailure to do this could lead to pg_clog files being removed too soon after the upgrade.
", "text": "Fix pg_upgrade to preserve toast tables' relfrozenxids during an upgrade from 8.3 (Bruce Momjian) Failure to do this could lead to pg_clog files being removed too soon after the upgrade.", "title": "Fix pg_upgrade to preserve toast tables' relfrozenxids during an upgrade from 8.3", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "55b103784c1a48d9797ebde9cd3be98d5f818fb214c1c62e32fdb72f7012ff4e", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix pg_upgrade to preserve toast tables' relfrozenxids during an upgrade from 8.3 (Bruce Momjian) Failure to do this could lead to pg_clog files being removed too soon after the upgrade.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/046", "db_id": "8415c1c3dc08f38f1d45d652f862a1bd", "patch_ids": [], "statement_hash": "ddc1c6526624820884e9f9bc0e99ac5f553bc01deb160b27459d3be5b7c959d4", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-253f93f54fcee263", "cves": [], "html": "In pg_upgrade, fix the -l (log) option to work on Windows (Bruce Momjian)
", "text": "In pg_upgrade, fix the -l (log) option to work on Windows (Bruce Momjian)", "title": "In pg_upgrade, fix the -l (log) option to work on Windows", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "b767a553ac2357ab2e5840bd1ebf4708de28b1612708f74349c83e3992337f96", "section_path": ["Changes"], "commit_groups": [], "identity_text": "In pg_upgrade, fix the -l (log) option to work on Windows (Bruce Momjian)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/047", "db_id": "a9824c0aa58301fc7d30e458e944f408", "patch_ids": [], "statement_hash": "99bd558234664f9b2640a6181cc522c38b44ee08c0f165e6db4aa77147d08e2c", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-dcc613c986f376b1", "cves": [], "html": "In pg_ctl, support silent mode for service registrations on Windows (MauMau)
", "text": "In pg_ctl, support silent mode for service registrations on Windows (MauMau)", "title": "In pg_ctl, support silent mode for service registrations on Windows", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "33f01ca79eb91e9b23c37a613e543ab8df36c5365b047c5c567dfe96eadc1b8f", "section_path": ["Changes"], "commit_groups": [], "identity_text": "In pg_ctl, support silent mode for service registrations on Windows (MauMau)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/048", "db_id": "7ccef7a9a042c981506ef45de83bb0af", "patch_ids": [], "statement_hash": "960e1bccb5b0eaa28fb129275454cc70f79491ecd9d16481356db89e8af55cfa", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-689669ac27235970", "cves": [], "html": "Fix psql's counting of script file line numbers during COPY from a different file (Tom Lane)
", "text": "Fix psql's counting of script file line numbers during COPY from a different file (Tom Lane)", "title": "Fix psql's counting of script file line numbers during COPY from a different file", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "c0fab1c24befa47d9816567b268ab22ad0af69bdfc879edc62a1d5fbe29a2aa0", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix psql's counting of script file line numbers during COPY from a different file (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/049", "db_id": "f54baf1859489d2b302ddeeb303fd1af", "patch_ids": [], "statement_hash": "519db0e5cadc52e87f6c27e43c26d5d968d11c033c846fc027aa2540184df5b0", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-604a89365000f6d2", "cves": [], "html": "Fix pg_restore's direct-to-database mode for standard_conforming_strings (Tom Lane)
\npg_restore could emit incorrect commands when restoring directly to a database server from an archive file that had been made with standard_conforming_strings set to on.
", "text": "Fix pg_restore's direct-to-database mode for standard_conforming_strings (Tom Lane) pg_restore could emit incorrect commands when restoring directly to a database server from an archive file that had been made with standard_conforming_strings set to on.", "title": "Fix pg_restore's direct-to-database mode for standard_conforming_strings", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "b7882366a9c1a43ddbbcdf17484cbcc9a7468440c8ba51369729aab9e7948f85", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix pg_restore's direct-to-database mode for standard_conforming_strings (Tom Lane) pg_restore could emit incorrect commands when restoring directly to a database server from an archive file that had been made with standard_conforming_strings set to on.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/050", "db_id": "cc8678655d5aa3b16b31676a4f667d50", "patch_ids": [], "statement_hash": "d467006aeaf351bfe5f4a918f505d5e3ae36913a993ebc5cf938382f245115ac", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-c6f27f556e5f2840", "cves": [], "html": "Be more user-friendly about unsupported cases for parallel pg_restore (Tom Lane)
\nThis change ensures that such cases are detected and reported before any restore actions have been taken.
", "text": "Be more user-friendly about unsupported cases for parallel pg_restore (Tom Lane) This change ensures that such cases are detected and reported before any restore actions have been taken.", "title": "Be more user-friendly about unsupported cases for parallel pg_restore", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "e01c339f5f08e217a5548656802a1a546c2e8357e78f1069ae0242c3ab33255d", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Be more user-friendly about unsupported cases for parallel pg_restore (Tom Lane) This change ensures that such cases are detected and reported before any restore actions have been taken.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/051", "db_id": "9ae3e4f65ca6d29df28d7d88ef3f706b", "patch_ids": [], "statement_hash": "e00782bcc74c2bc8778ccbc4a6bea49945060044e6340863f689fa2febcf9519", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-244176cc8865992c", "cves": [], "html": "Fix write-past-buffer-end and memory leak in libpq's LDAP service lookup code (Albe Laurenz)
", "text": "Fix write-past-buffer-end and memory leak in libpq's LDAP service lookup code (Albe Laurenz)", "title": "Fix write-past-buffer-end and memory leak in libpq's LDAP service lookup code", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "42b1fc497673eb77704d769c83fdfd6a169505a73120eac6a3b17f7ccfcdf4d6", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix write-past-buffer-end and memory leak in libpq's LDAP service lookup code (Albe Laurenz)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/052", "db_id": "917cf5d250528bd3875516340bb75fd2", "patch_ids": [], "statement_hash": "bd4dcb56ef61729730f9dbf2a2cd5a60227019c86baf545975db44829284ee49", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-07ec315bd0e40960", "cves": [], "html": "In libpq, avoid failures when using nonblocking I/O and an SSL connection (Martin Pihlak, Tom Lane)
", "text": "In libpq, avoid failures when using nonblocking I/O and an SSL connection (Martin Pihlak, Tom Lane)", "title": "In libpq, avoid failures when using nonblocking I/O and an SSL connection", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "a32e2369b8348097d32661a445d02d079dc08724da1d8a945d9f705326effa42", "section_path": ["Changes"], "commit_groups": [], "identity_text": "In libpq, avoid failures when using nonblocking I/O and an SSL connection (Martin Pihlak, Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/053", "db_id": "6784e623de94a233a03e77ec426a68d5", "patch_ids": [], "statement_hash": "53b787c5b6935585b58d4337feb835dadfbb96b49f5bb783930d8dc2d4037da6", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-757a301393e60c03", "cves": [], "html": "Improve libpq's handling of failures during connection startup (Tom Lane)
\nIn particular, the response to a server report of fork() failure during SSL connection startup is now saner.
Improve libpq's error reporting for SSL failures (Tom Lane)
", "text": "Improve libpq's error reporting for SSL failures (Tom Lane)", "title": "Improve libpq's error reporting for SSL failures", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "dcb9d57f3052090ee17199fe01b19fe37badbb965406f2992e40d12ae129f803", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Improve libpq's error reporting for SSL failures (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/055", "db_id": "2da6cd33cd6257df7bd32170cbc8cbee", "patch_ids": [], "statement_hash": "804f0119bbe102ff21ef4975ee11f69540630023e00cc072e1b8a1e49b5da912", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-cced0d1cfc10cbff", "cves": [], "html": "Fix PQsetvalue() to avoid possible crash when adding a new tuple to a PGresult originally obtained from a server query (Andrew Chernow)
Make ecpglib write double values with 15 digits precision (Akira Kurosawa)
", "text": "Make ecpglib write double values with 15 digits precision (Akira Kurosawa)", "title": "Make ecpglib write double values with 15 digits precision", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "8cf58ed2e410ab492228bb8281ae2c441ea2d2e906bb26242aee059ee6956c20", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Make ecpglib write double values with 15 digits precision (Akira Kurosawa)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/057", "db_id": "32cce2f386b93225e8c1512983a0775e", "patch_ids": [], "statement_hash": "ab2cb34b99e58c77332ebe45246e9ce93b901e3b8144d6cb26c5ee1c0058f1db", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-f9b68db3a61001aa", "cves": [], "html": "In ecpglib, be sure LC_NUMERIC setting is restored after an error (Michael Meskes)
", "text": "In ecpglib, be sure LC_NUMERIC setting is restored after an error (Michael Meskes)", "title": "In ecpglib, be sure LC_NUMERIC setting is restored after an error", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "69d0e25a293adf973ae955741d715d93880ef67fda7109646672864cd27f0271", "section_path": ["Changes"], "commit_groups": [], "identity_text": "In ecpglib, be sure LC_NUMERIC setting is restored after an error (Michael Meskes)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/058", "db_id": "c4c61e913a9b8376eeb4c1539cba75c5", "patch_ids": [], "statement_hash": "d50580bab4e2e322065c472ab7b671751d5213921e5d84a0b3e9b4d7cad668da", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-d53b3cb5f513201f", "cves": ["CVE-2011-2483"], "html": "Apply upstream fix for blowfish signed-character bug (CVE-2011-2483) (Tom Lane)
\ncontrib/pg_crypto's blowfish encryption code could give wrong results on platforms where char is signed (which is most), leading to encrypted passwords being weaker than they should be.
", "text": "Apply upstream fix for blowfish signed-character bug (CVE-2011-2483) (Tom Lane) contrib/pg_crypto's blowfish encryption code could give wrong results on platforms where char is signed (which is most), leading to encrypted passwords being weaker than they should be.", "title": "Apply upstream fix for blowfish signed-character bug (CVE-2011-2483)", "commits": [], "section": "Changes", "category": "security", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "8cc298dd27eea7530b7c835b7a588b7cf712ae5ba17aa774fc4f4aefed85e2e6", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Apply upstream fix for blowfish signed-character bug (CVE-2011-2483) (Tom Lane) contrib/pg_crypto's blowfish encryption code could give wrong results on platforms where char is signed (which is most), leading to encrypted passwords being weaker than they should be.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/059", "db_id": "651ec42de4f2d053dfaeed3d9006d138", "patch_ids": [], "statement_hash": "e7599445eba73f2a0ab35becc6321fa0a10ab6d4b609fedfa286dcaf49e12e83", "relations": [], "version": "9.0.5", "category_label": "Security", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-8a475c0a89042b50", "cves": [], "html": "Fix memory leak in contrib/seg (Heikki Linnakangas)
", "text": "Fix memory leak in contrib/seg (Heikki Linnakangas)", "title": "Fix memory leak in contrib/seg", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "451095d637b2d4150954c168a1251e134f9fa9339e1433dcf0cbc9508c354eec", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix memory leak in contrib/seg (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/060", "db_id": "d6557f7f6c6aa560e0dafb9bfc9a2cda", "patch_ids": [], "statement_hash": "67a306816788ac7314daec3934f3e2c9615399c265e7dbe47ebf796fd0a7c9e8", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-30022c3adb26291e", "cves": [], "html": "Fix pgstatindex() to give consistent results for empty indexes (Tom Lane)
Allow building with perl 5.14 (Alex Hunsaker)
", "text": "Allow building with perl 5.14 (Alex Hunsaker)", "title": "Allow building with perl 5.14", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "2e13d277be584a5c9cb5a19aa4ea51096f05ed3dff3a702a6c31c71824f5e5fa", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Allow building with perl 5.14 (Alex Hunsaker)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/062", "db_id": "12181919e797977fd6a8eb4604be0f38", "patch_ids": [], "statement_hash": "8da45459c0723dc9f9270d845d7831a2a1fba49fe2b0715f16416dccef7db06c", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-1616ab4508d31b2c", "cves": [], "html": "Fix assorted issues with build and install file paths containing spaces (Tom Lane)
", "text": "Fix assorted issues with build and install file paths containing spaces (Tom Lane)", "title": "Fix assorted issues with build and install file paths containing spaces", "commits": [], "section": "Changes", "category": "bugfix", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "a03ec91891f0c6438a8f27d211d85bd89cb583495c43a797fed4402818979c9c", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Fix assorted issues with build and install file paths containing spaces (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/063", "db_id": "70c32ab657796b82a95e1f86f2b0c16a", "patch_ids": [], "statement_hash": "611b0c2aa93036b38510e3236a6a739f9631a0cd714fcda610b2f520496d31f8", "relations": [], "version": "9.0.5", "category_label": "Bug fixes", "also_in": [], "variants": [], "related_changes": []}, {"id": "9.0.5-452bcac0a8f6b2eb", "cves": [], "html": "Update time zone data files to tzdata release 2011i for DST law changes in Canada, Egypt, Russia, Samoa, and South Sudan.
", "text": "Update time zone data files to tzdata release 2011i for DST law changes in Canada, Egypt, Russia, Samoa, and South Sudan.", "title": "Update time zone data files to tzdata release 2011i for DST law changes in Canada, Egypt, Russia, Samoa, and South Sudan.", "commits": [], "section": "Changes", "category": "improvement", "source_url": "/docs/release/9.0.5/#AEN101607", "source_hash": "c7b1e5361546c15140f3f2c0461e5cf344d7a1929675dcfbfda0a219bd647810", "section_path": ["Changes"], "commit_groups": [], "identity_text": "Update time zone data files to tzdata release 2011i for DST law changes in Canada, Egypt, Russia, Samoa, and South Sudan.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.0.5/changes/064", "db_id": "96a19602f4b237484f0fb352155f3ed8", "patch_ids": [], "statement_hash": "5a1b869d950438d25a1f8a65efc5256ff3b6ed06abf97a28ac8cc6b34237c8a2", "relations": [], "version": "9.0.5", "category_label": "Improvements", "also_in": [], "variants": [], "related_changes": []}]}], "stats": [{"key": "all", "label": "All changes", "count": 64}, {"key": "feature", "label": "Features", "count": 0}, {"key": "bugfix", "label": "Bug fixes", "count": 39}, {"key": "security", "label": "Security", "count": 1}, {"key": "performance", "label": "Performance", "count": 0}, {"key": "compatibility", "label": "Compatibility", "count": 0}, {"key": "improvement", "label": "Improvements", "count": 24}], "total": 64, "release_count": 1, "cross_major": false, "cve_count": 1, "cves": [{"id": "CVE-2011-2483", "url": "https://www.postgresql.org/support/security/CVE-2011-2483/", "fixed_version": "", "title": "Apply upstream fix for blowfish signed-character bug (CVE-2011-2483)"}], "cve_available": true, "remaining_cves": [], "security_regressions": [], "warnings": [], "candidate_count": 64, "already_in_source_count": 0, "duplicate_count": 0, "excluded_count": 0, "exclusions": [], "source_as_of": "2026-09-26", "security_as_of": "2026-09-26"}