Rename replication_timeout to wal_sender_timeout (Amit Kapila)
\nThis setting controls the WAL sender timeout.
", "text": "Rename replication_timeout to wal_sender_timeout (Amit Kapila) This setting controls the WAL sender timeout.", "title": "Rename replication_timeout to wal_sender_timeout", "commits": [], "section": "Server Settings", "category": "compatibility", "source_url": "/docs/release/9.3.0/#AEN119075", "source_hash": "7d3a5111f5998c54522a9b5d5d3b1c5bb9ff9a5675e99a3681d958ac5cea2720", "section_path": ["Server Settings"], "commit_groups": [], "identity_text": "Rename replication_timeout to wal_sender_timeout (Amit Kapila) This setting controls the WAL sender timeout.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/migration/001", "db_id": "777c38872b71678d3a54bcb0a09285eb", "patch_ids": [], "statement_hash": "6cc3ce1243bc11ed9e6b46ad30c2586106189c659d24a4ecc20ca3da37638112", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=9.3.0#9.3.0-04650593f620fd5f", "migration": true}, {"id": "9.3.0-bd24110e01f1f0cb", "cves": [], "html": "Require superuser privileges to set commit_delay because it can now potentially delay other sessions (Simon Riggs)
", "text": "Require superuser privileges to set commit_delay because it can now potentially delay other sessions (Simon Riggs)", "title": "Require superuser privileges to set commit_delay because it can now potentially delay other sessions", "commits": [], "section": "Server Settings", "category": "compatibility", "source_url": "/docs/release/9.3.0/#AEN119075", "source_hash": "c6282703484b1687855ee95e61a0151cc229f09bc7f06b02c8eb5627e4d30461", "section_path": ["Server Settings"], "commit_groups": [], "identity_text": "Require superuser privileges to set commit_delay because it can now potentially delay other sessions (Simon Riggs)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/migration/002", "db_id": "2b6e74ac5ec9281a05eda02ededd813d", "patch_ids": [], "statement_hash": "7b03f46095c788f77e92048bd306fdbb0f084bca149ed233995576ad66f79eca", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=9.3.0#9.3.0-bd24110e01f1f0cb", "migration": true}, {"id": "9.3.0-ed4db0fc4d3f0083", "cves": [], "html": "Allow in-memory sorts to use their full memory allocation (Jeff Janes)
\nUsers who have set work_mem based on the previous behavior may need to revisit that setting.
", "text": "Allow in-memory sorts to use their full memory allocation (Jeff Janes) Users who have set work_mem based on the previous behavior may need to revisit that setting.", "title": "Allow in-memory sorts to use their full memory allocation", "commits": [], "section": "Server Settings", "category": "compatibility", "source_url": "/docs/release/9.3.0/#AEN119075", "source_hash": "e32e36d7b7b1b72efbfc099a55747863955b4b3a084e9cfe387e142cf3aa588e", "section_path": ["Server Settings"], "commit_groups": [], "identity_text": "Allow in-memory sorts to use their full memory allocation (Jeff Janes) Users who have set work_mem based on the previous behavior may need to revisit that setting.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/migration/003", "db_id": "6245043f14052870314e2ba5565d4358", "patch_ids": [], "statement_hash": "741080d12f08813ebb89f640366d082587ca9490da6eb287c8562adf9af979b7", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=9.3.0#9.3.0-ed4db0fc4d3f0083", "migration": true}, {"id": "9.3.0-33892a8afce160fa", "cves": [], "html": "Throw an error if a tuple to be updated or deleted has already been updated or deleted by a BEFORE trigger (Kevin Grittner)
\nFormerly, the originally-intended update was silently skipped, resulting in logical inconsistency since the trigger might have propagated data to other places based on the intended update. Now an error is thrown to prevent the inconsistent results from being committed. If this change affects your application, the best solution is usually to move the data-propagation actions to an AFTER trigger.
\nThis error will also be thrown if a query invokes a volatile function that modifies rows that are later modified by the query itself. Such cases likewise previously resulted in silently skipping updates.
", "text": "Throw an error if a tuple to be updated or deleted has already been updated or deleted by a BEFORE trigger (Kevin Grittner) Formerly, the originally-intended update was silently skipped, resulting in logical inconsistency since the trigger might have propagated data to other places based on the intended update. Now an error is thrown to prevent the inconsistent results from being committed. If this change affects your application, the best solution is usually to move the data-propagation actions to an AFTER trigger. This error will also be thrown if a query invokes a volatile function that modifies rows that are later modified by the query itself. Such cases likewise previously resulted in silently skipping updates.", "title": "Throw an error if a tuple to be updated or deleted has already been updated or deleted by a BEFORE trigger", "commits": [], "section": "Other", "category": "compatibility", "source_url": "/docs/release/9.3.0/#AEN119095", "source_hash": "846a38d188b88a9328f2c107d17f37ec7bc8c3bae1fed31e0625d87e9dda1dcd", "section_path": ["Other"], "commit_groups": [], "identity_text": "Throw an error if a tuple to be updated or deleted has already been updated or deleted by a BEFORE trigger (Kevin Grittner) Formerly, the originally-intended update was silently skipped, resulting in logical inconsistency since the trigger might have propagated data to other places based on the intended update. Now an error is thrown to prevent the inconsistent results from being committed. If this change affects your application, the best solution is usually to move the data-propagation actions to an AFTER trigger. This error will also be thrown if a query invokes a volatile function that modifies rows that are later modified by the query itself. Such cases likewise previously resulted in silently skipping updates.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/migration/004", "db_id": "55e64fba7ece2ed63167bad5bf54bfe7", "patch_ids": [], "statement_hash": "77be53654d0b21d5eea320e46652350e7b2deb021b9cae0095281c46578fe901", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=9.3.0#9.3.0-33892a8afce160fa", "migration": true}, {"id": "9.3.0-e5c01dd81fde83c9", "cves": [], "html": "Change multicolumn ON UPDATE SET NULL/SET DEFAULT foreign key actions to affect all columns of the constraint, not just those changed in the UPDATE (Tom Lane)
\nPreviously, we would set only those referencing columns that correspond to referenced columns that were changed by the UPDATE. This was what was required by SQL-92, but more recent editions of the SQL standard specify the new behavior.
", "text": "Change multicolumn ON UPDATE SET NULL/SET DEFAULT foreign key actions to affect all columns of the constraint, not just those changed in the UPDATE (Tom Lane) Previously, we would set only those referencing columns that correspond to referenced columns that were changed by the UPDATE. This was what was required by SQL-92, but more recent editions of the SQL standard specify the new behavior.", "title": "Change multicolumn ON UPDATE SET NULL/SET DEFAULT foreign key actions to affect all columns of the constraint, not just those changed in the UPDATE", "commits": [], "section": "Other", "category": "compatibility", "source_url": "/docs/release/9.3.0/#AEN119095", "source_hash": "6d1eaa1e419abefce841b641739b32298fb6c3301c0da39714ddfb8c397a5d54", "section_path": ["Other"], "commit_groups": [], "identity_text": "Change multicolumn ON UPDATE SET NULL/SET DEFAULT foreign key actions to affect all columns of the constraint, not just those changed in the UPDATE (Tom Lane) Previously, we would set only those referencing columns that correspond to referenced columns that were changed by the UPDATE. This was what was required by SQL-92, but more recent editions of the SQL standard specify the new behavior.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/migration/005", "db_id": "ef8e0b035e97e06f5160c17f130840a2", "patch_ids": [], "statement_hash": "9f2b004c6abc3aa5ccdd6859fa7fac3855edcc1770dce3a7d5cdcb948afdf22b", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=9.3.0#9.3.0-e5c01dd81fde83c9", "migration": true}, {"id": "9.3.0-98766ce3aea392cf", "cves": [], "html": "Force cached plans to be replanned if the search_path changes (Tom Lane)
\nPreviously, cached plans already generated in the current session were not redone if the query was re-executed with a new search_path setting, resulting in surprising behavior.
", "text": "Force cached plans to be replanned if the search_path changes (Tom Lane) Previously, cached plans already generated in the current session were not redone if the query was re-executed with a new search_path setting, resulting in surprising behavior.", "title": "Force cached plans to be replanned if the search_path changes", "commits": [], "section": "Other", "category": "compatibility", "source_url": "/docs/release/9.3.0/#AEN119095", "source_hash": "cb493e57aeb821bfd1152a5a99d8e723c0a475b9ab295ad075a5abc12266a236", "section_path": ["Other"], "commit_groups": [], "identity_text": "Force cached plans to be replanned if the search_path changes (Tom Lane) Previously, cached plans already generated in the current session were not redone if the query was re-executed with a new search_path setting, resulting in surprising behavior.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/migration/006", "db_id": "65188fc87f3b7c326ea0cfb72d117d9a", "patch_ids": [], "statement_hash": "2f26882a450e32a79665b3171a9660ee7b8cd8bf9c0e0ac4520a953ccc905bc6", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=9.3.0#9.3.0-98766ce3aea392cf", "migration": true}, {"id": "9.3.0-cbbb58ceec629e32", "cves": [], "html": "Fix to_number() to properly handle a period used as a thousands separator (Tom Lane)
Previously, a period was considered to be a decimal point even when the locale says it isn't and the D format code is used to specify use of the locale-specific decimal point. This resulted in wrong answers if FM format was also used.
", "text": "Fix to_number() to properly handle a period used as a thousands separator (Tom Lane) Previously, a period was considered to be a decimal point even when the locale says it isn't and the D format code is used to specify use of the locale-specific decimal point. This resulted in wrong answers if FM format was also used.", "title": "Fix to_number() to properly handle a period used as a thousands separator", "commits": [], "section": "Other", "category": "compatibility", "source_url": "/docs/release/9.3.0/#AEN119095", "source_hash": "113fb4a7606e734176af27d447d7dee7d3de3b27e540f8b85f4414a32316c376", "section_path": ["Other"], "commit_groups": [], "identity_text": "Fix to_number() to properly handle a period used as a thousands separator (Tom Lane) Previously, a period was considered to be a decimal point even when the locale says it isn't and the D format code is used to specify use of the locale-specific decimal point. This resulted in wrong answers if FM format was also used.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/migration/007", "db_id": "1e4974095835e7b46ea6fc5c6b755aba", "patch_ids": [], "statement_hash": "fd33581be7d0f26b3dc0f1336009ef49d4338b40ff4d44e4bde2062c6c016768", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=9.3.0#9.3.0-cbbb58ceec629e32", "migration": true}, {"id": "9.3.0-537688222a749925", "cves": [], "html": "Fix STRICT non-set-returning functions that have set-returning functions in their arguments to properly return null rows (Tom Lane)
\nA null value passed to the strict function should result in a null output, but instead, that output row was suppressed entirely.
", "text": "Fix STRICT non-set-returning functions that have set-returning functions in their arguments to properly return null rows (Tom Lane) A null value passed to the strict function should result in a null output, but instead, that output row was suppressed entirely.", "title": "Fix STRICT non-set-returning functions that have set-returning functions in their arguments to properly return null rows", "commits": [], "section": "Other", "category": "compatibility", "source_url": "/docs/release/9.3.0/#AEN119095", "source_hash": "acb27fd1f97e331d075bf1acbaad8a957717d4374846542b062517e30357109c", "section_path": ["Other"], "commit_groups": [], "identity_text": "Fix STRICT non-set-returning functions that have set-returning functions in their arguments to properly return null rows (Tom Lane) A null value passed to the strict function should result in a null output, but instead, that output row was suppressed entirely.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/migration/008", "db_id": "63a2863d7bc6cf75ae87a01afb364ed7", "patch_ids": [], "statement_hash": "f79adf80b607e1c5bf9ab3f1aba9bb221b87b03cd0aa36e449b4d91e2455473a", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=9.3.0#9.3.0-537688222a749925", "migration": true}, {"id": "9.3.0-febba0dac7a198ac", "cves": [], "html": "Store WAL in a continuous stream, rather than skipping the last 16MB segment every 4GB (Heikki Linnakangas)
\nPreviously, WAL files with names ending in FF were not used because of this skipping. If you have WAL backup or restore scripts that took this behavior into account, they will need to be adjusted.
", "text": "Store WAL in a continuous stream, rather than skipping the last 16MB segment every 4GB (Heikki Linnakangas) Previously, WAL files with names ending in FF were not used because of this skipping. If you have WAL backup or restore scripts that took this behavior into account, they will need to be adjusted.", "title": "Store WAL in a continuous stream, rather than skipping the last 16MB segment every 4GB", "commits": [], "section": "Other", "category": "compatibility", "source_url": "/docs/release/9.3.0/#AEN119095", "source_hash": "c98e9f83498de614368daf6b5726a38c3247dfdd79e1c2e40332dd47e8686840", "section_path": ["Other"], "commit_groups": [], "identity_text": "Store WAL in a continuous stream, rather than skipping the last 16MB segment every 4GB (Heikki Linnakangas) Previously, WAL files with names ending in FF were not used because of this skipping. If you have WAL backup or restore scripts that took this behavior into account, they will need to be adjusted.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/migration/009", "db_id": "0a39dac684ea2f362a61bdcbe7e55a4a", "patch_ids": [], "statement_hash": "c3cd5f51e45a42066d2ae5b5cee8eef03533fa98f00b9151fe30ee2e3d9977fd", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=9.3.0#9.3.0-febba0dac7a198ac", "migration": true}, {"id": "9.3.0-d1e6043437d63474", "cves": [], "html": "In pg_constraint.confmatchtype, store the default foreign key match type (non-FULL, non-PARTIAL) as s for \"simple\" (Tom Lane)
\nPreviously this case was represented by u for \"unspecified\".
", "text": "In pg_constraint.confmatchtype, store the default foreign key match type (non-FULL, non-PARTIAL) as s for \"simple\" (Tom Lane) Previously this case was represented by u for \"unspecified\".", "title": "In pg_constraint.confmatchtype, store the default foreign key match type (non-FULL, non-PARTIAL) as s for \"simple\"", "commits": [], "section": "Other", "category": "compatibility", "source_url": "/docs/release/9.3.0/#AEN119095", "source_hash": "e0e58713659aad01f658e3a5ac0dc542fbcd3399916da5245255b5434ef1abcf", "section_path": ["Other"], "commit_groups": [], "identity_text": "In pg_constraint.confmatchtype, store the default foreign key match type (non-FULL, non-PARTIAL) as s for simple (Tom Lane) Previously this case was represented by u for unspecified.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/migration/010", "db_id": "3557d5db1bd582f5b1cf0d38a6088381", "patch_ids": [], "statement_hash": "f6af09b8b0002efed733b3a05d925697e8435f09477abc7c44bbab64e324c75e", "relations": [], "category_label": "Compatibility", "url": "/docs/compare/?release=9.3.0#9.3.0-d1e6043437d63474", "migration": true}, {"id": "9.3.0-c1d05d36a304229d", "cves": [], "html": "Prevent non-key-field row updates from blocking foreign key checks (\u00c1lvaro Herrera, Noah Misch, Andres Freund, Alexander Shulgin, Marti Raudsepp, Alexander Shulgin)
\nThis change improves concurrency and reduces the probability of deadlocks when updating tables involved in a foreign-key constraint. UPDATEs that do not change any columns referenced in a foreign key now take the new NO KEY UPDATE lock mode on the row, while foreign key checks use the new KEY SHARE lock mode, which does not conflict with NO KEY UPDATE. So there is no blocking unless a foreign-key column is changed.
", "text": "Prevent non-key-field row updates from blocking foreign key checks (\u00c1lvaro Herrera, Noah Misch, Andres Freund, Alexander Shulgin, Marti Raudsepp, Alexander Shulgin) This change improves concurrency and reduces the probability of deadlocks when updating tables involved in a foreign-key constraint. UPDATEs that do not change any columns referenced in a foreign key now take the new NO KEY UPDATE lock mode on the row, while foreign key checks use the new KEY SHARE lock mode, which does not conflict with NO KEY UPDATE. So there is no blocking unless a foreign-key column is changed.", "title": "Prevent non-key-field row updates from blocking foreign key checks", "commits": [], "section": "Server / Locking", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119153", "source_hash": "ee23323d802d4fb1dd56196e31c273e260d27c9703880ad8dd265de2d67affb9", "section_path": ["Server", "Locking"], "commit_groups": [], "identity_text": "Prevent non-key-field row updates from blocking foreign key checks (\u00c1lvaro Herrera, Noah Misch, Andres Freund, Alexander Shulgin, Marti Raudsepp, Alexander Shulgin) This change improves concurrency and reduces the probability of deadlocks when updating tables involved in a foreign-key constraint. UPDATEs that do not change any columns referenced in a foreign key now take the new NO KEY UPDATE lock mode on the row, while foreign key checks use the new KEY SHARE lock mode, which does not conflict with NO KEY UPDATE. So there is no blocking unless a foreign-key column is changed.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/001", "db_id": "2d2a614cf51c52db5b34307d4779f381", "patch_ids": [], "statement_hash": "58c2059a5b368b5e658d91c49df8b44e9efdd97be4f02dab8ba0a767d86a75d3", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-c1d05d36a304229d", "migration": false}, {"id": "9.3.0-10eb8442fdce85de", "cves": [], "html": "Add configuration variable lock_timeout to allow limiting how long a session will wait to acquire any one lock (Zolt\u00e1n B\u00f6sz\u00f6rm\u00e9nyi)
", "text": "Add configuration variable lock_timeout to allow limiting how long a session will wait to acquire any one lock (Zolt\u00e1n B\u00f6sz\u00f6rm\u00e9nyi)", "title": "Add configuration variable lock_timeout to allow limiting how long a session will wait to acquire any one lock", "commits": [], "section": "Server / Locking", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119153", "source_hash": "188b43d8229d68bf1bfc956270f6f4e64f46fc613c6d6509b7f8a57f5f7691c4", "section_path": ["Server", "Locking"], "commit_groups": [], "identity_text": "Add configuration variable lock_timeout to allow limiting how long a session will wait to acquire any one lock (Zolt\u00e1n B\u00f6sz\u00f6rm\u00e9nyi)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/002", "db_id": "63d924caed16654968c09ade3e4409b4", "patch_ids": [], "statement_hash": "f41090eee02f1152003c36c74241f7c9ee5e9aa27b478151394b349276d3f29c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-10eb8442fdce85de", "migration": false}, {"id": "9.3.0-75a784e3adbad7ee", "cves": [], "html": "Add SP-GiST support for range data types (Alexander Korotkov)
", "text": "Add SP-GiST support for range data types (Alexander Korotkov)", "title": "Add SP-GiST support for range data types", "commits": [], "section": "Server / Indexes", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119167", "source_hash": "601be84b258abe182b1fe739dcb6a970b71585cd91a1c7b1dde70a3c1ab0ccc2", "section_path": ["Server", "Indexes"], "commit_groups": [], "identity_text": "Add SP-GiST support for range data types (Alexander Korotkov)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/003", "db_id": "b392646bf016083ecd42961d6717105b", "patch_ids": [], "statement_hash": "f8b3f1c1323bdcde8efad24e66412ec0820b800fe32432578c9fd1202d8b3ffe", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-75a784e3adbad7ee", "migration": false}, {"id": "9.3.0-9fdd8b2ce4fd19ba", "cves": [], "html": "Allow GiST indexes to be unlogged (Jeevan Chalke)
", "text": "Allow GiST indexes to be unlogged (Jeevan Chalke)", "title": "Allow GiST indexes to be unlogged", "commits": [], "section": "Server / Indexes", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119167", "source_hash": "1ca4580e36af63f0a5b7cfd315cd0a61e933008f222b5f190e86b38e6e8d8de3", "section_path": ["Server", "Indexes"], "commit_groups": [], "identity_text": "Allow GiST indexes to be unlogged (Jeevan Chalke)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/004", "db_id": "4ac09cb88dc87b8469c137936e0c5ed9", "patch_ids": [], "statement_hash": "f96353572ed8524ae50fbf5214ec6857b6ef9bfdcd292064504f51945ae14fb3", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-9fdd8b2ce4fd19ba", "migration": false}, {"id": "9.3.0-24068d4a6553bf46", "cves": [], "html": "Improve performance of GiST index insertion by randomizing the choice of which page to descend to when there are multiple equally good alternatives (Heikki Linnakangas)
", "text": "Improve performance of GiST index insertion by randomizing the choice of which page to descend to when there are multiple equally good alternatives (Heikki Linnakangas)", "title": "Improve performance of GiST index insertion by randomizing the choice of which page to descend to when there are multiple equally good alternatives", "commits": [], "section": "Server / Indexes", "category": "performance", "source_url": "/docs/release/9.3.0/#AEN119167", "source_hash": "83490d75dbfcddffe7018a7511b5036f94ae94fe3e76e0ec5ce500d00533be45", "section_path": ["Server", "Indexes"], "commit_groups": [], "identity_text": "Improve performance of GiST index insertion by randomizing the choice of which page to descend to when there are multiple equally good alternatives (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/005", "db_id": "b459f7caf5cedd9b7c8a7d03fd49f4ff", "patch_ids": [], "statement_hash": "f12264f2ea92fa22fed32b3d4c26a73de949ba2910b373d83fdb2d2f25484522", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=9.3.0#9.3.0-24068d4a6553bf46", "migration": false}, {"id": "9.3.0-dc3d4dbe306c93f2", "cves": [], "html": "Improve concurrency of hash index operations (Robert Haas)
", "text": "Improve concurrency of hash index operations (Robert Haas)", "title": "Improve concurrency of hash index operations", "commits": [], "section": "Server / Indexes", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119167", "source_hash": "59e6a341222f61f4a37070720d8b67fcb1f8b5ee8109b04174c8fec83caba3e4", "section_path": ["Server", "Indexes"], "commit_groups": [], "identity_text": "Improve concurrency of hash index operations (Robert Haas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/006", "db_id": "32ba77b6fd77233256282b8ce5a21c8d", "patch_ids": [], "statement_hash": "77f8bcc4d9d4ebcde0a9ffd021ec3a685ed85134acc211119e57dae0bb34c0f1", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-dc3d4dbe306c93f2", "migration": false}, {"id": "9.3.0-602f4e2308a7d127", "cves": [], "html": "Collect and use histograms of upper and lower bounds, as well as range lengths, for range types (Alexander Korotkov)
", "text": "Collect and use histograms of upper and lower bounds, as well as range lengths, for range types (Alexander Korotkov)", "title": "Collect and use histograms of upper and lower bounds, as well as range lengths, for range types", "commits": [], "section": "Server / Optimizer", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119183", "source_hash": "1b63c7a142fbf6e257fb2f1592d972f6803c5b883d8260982e19a7c7a3cbfc19", "section_path": ["Server", "Optimizer"], "commit_groups": [], "identity_text": "Collect and use histograms of upper and lower bounds, as well as range lengths, for range types (Alexander Korotkov)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/007", "db_id": "4ad3472263d3c2f3cb83c18c8c295ff1", "patch_ids": [], "statement_hash": "9d788da3027855223fbb2e02d97aec82b7eae7606d773f76f29d74512cd73728", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-602f4e2308a7d127", "migration": false}, {"id": "9.3.0-45a03e1e6461cc7a", "cves": [], "html": "Improve optimizer's cost estimation for index access (Tom Lane)
", "text": "Improve optimizer's cost estimation for index access (Tom Lane)", "title": "Improve optimizer's cost estimation for index access", "commits": [], "section": "Server / Optimizer", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119183", "source_hash": "c201d69d46404fa0d12f8074269df31a74a4362ba389e23199fef6f9249b3954", "section_path": ["Server", "Optimizer"], "commit_groups": [], "identity_text": "Improve optimizer's cost estimation for index access (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/008", "db_id": "1890122515cf3a4f3742db95c6dd6c1c", "patch_ids": [], "statement_hash": "23fa2df5cb074f3b0ae81dc936f881580b106e09127ccb3e5ec77e7de6276967", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-45a03e1e6461cc7a", "migration": false}, {"id": "9.3.0-b6b08cbe24eb64b7", "cves": [], "html": "Improve optimizer's hash table size estimate for doing DISTINCT via hash aggregation (Tom Lane)
", "text": "Improve optimizer's hash table size estimate for doing DISTINCT via hash aggregation (Tom Lane)", "title": "Improve optimizer's hash table size estimate for doing DISTINCT via hash aggregation", "commits": [], "section": "Server / Optimizer", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119183", "source_hash": "c5c6b9820d00451454d421de9263ceae31d35e277a2877dfc779427ee0701ef6", "section_path": ["Server", "Optimizer"], "commit_groups": [], "identity_text": "Improve optimizer's hash table size estimate for doing DISTINCT via hash aggregation (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/009", "db_id": "35326212aa1267f5232e7f93890e6fe2", "patch_ids": [], "statement_hash": "39ac9a1fbac5f00073c52288ef3df58d9649078d7841a685df19cd2c93a20f9a", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-b6b08cbe24eb64b7", "migration": false}, {"id": "9.3.0-0f0f7ca020f8c108", "cves": [], "html": "Suppress no-op Result and Limit plan nodes (Kyotaro Horiguchi, Amit Kapila, Tom Lane)
", "text": "Suppress no-op Result and Limit plan nodes (Kyotaro Horiguchi, Amit Kapila, Tom Lane)", "title": "Suppress no-op Result and Limit plan nodes", "commits": [], "section": "Server / Optimizer", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119183", "source_hash": "724d57bf1df75a48963a547f90a9a90e197f4fcd6ebeea874cfc10c8a456b5ea", "section_path": ["Server", "Optimizer"], "commit_groups": [], "identity_text": "Suppress no-op Result and Limit plan nodes (Kyotaro Horiguchi, Amit Kapila, Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/010", "db_id": "83496f034c16e09c5416cffc0d35521b", "patch_ids": [], "statement_hash": "fba389f32834d8a99d182e23cbc2468114f5e10e96e3ef2c16ed09493bfa6f3e", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-0f0f7ca020f8c108", "migration": false}, {"id": "9.3.0-adaa65156fc078b1", "cves": [], "html": "Reduce optimizer overhead by not keeping plans on the basis of cheap startup cost when the optimizer only cares about total cost overall (Tom Lane)
", "text": "Reduce optimizer overhead by not keeping plans on the basis of cheap startup cost when the optimizer only cares about total cost overall (Tom Lane)", "title": "Reduce optimizer overhead by not keeping plans on the basis of cheap startup cost when the optimizer only cares about total cost overall", "commits": [], "section": "Server / Optimizer", "category": "performance", "source_url": "/docs/release/9.3.0/#AEN119183", "source_hash": "b4c30027f31bbaa02937c71016a1f71ac33ae18a62b37c6b734f6f0112ed3996", "section_path": ["Server", "Optimizer"], "commit_groups": [], "identity_text": "Reduce optimizer overhead by not keeping plans on the basis of cheap startup cost when the optimizer only cares about total cost overall (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/011", "db_id": "35291572af4ca38e8cbf427436e68ce6", "patch_ids": [], "statement_hash": "bbb8fc0524c9a667b3b5c214c97c68fd970fc4839a71aa3e7679b155414869d0", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=9.3.0#9.3.0-adaa65156fc078b1", "migration": false}, {"id": "9.3.0-206e5ece89f9c177", "cves": [], "html": "Add COPY FREEZE option to avoid the overhead of marking tuples as frozen later (Simon Riggs, Jeff Davis)
", "text": "Add COPY FREEZE option to avoid the overhead of marking tuples as frozen later (Simon Riggs, Jeff Davis)", "title": "Add COPY FREEZE option to avoid the overhead of marking tuples as frozen later", "commits": [], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/9.3.0/#AEN119198", "source_hash": "8df18fb2d255e33c994ee9c4fa3a4d585d7412afdfc8448ca7eab7caf7982bb8", "section_path": ["Server", "General Performance"], "commit_groups": [], "identity_text": "Add COPY FREEZE option to avoid the overhead of marking tuples as frozen later (Simon Riggs, Jeff Davis)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/012", "db_id": "af9808f8c0ddcf432fd52903fda6dc1d", "patch_ids": [], "statement_hash": "72be1c614853f4fd172c1fa19e42404cdee60c8f7bacc16cbb9328d30a8df2d8", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=9.3.0#9.3.0-206e5ece89f9c177", "migration": false}, {"id": "9.3.0-0b654fd228ff2eca", "cves": [], "html": "Improve performance of NUMERIC calculations (Kyotaro Horiguchi)
", "text": "Improve performance of NUMERIC calculations (Kyotaro Horiguchi)", "title": "Improve performance of NUMERIC calculations", "commits": [], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/9.3.0/#AEN119198", "source_hash": "3435e615e100d171522585846b9fc8e80bfbf0197b412ad57f0a54b4394adeba", "section_path": ["Server", "General Performance"], "commit_groups": [], "identity_text": "Improve performance of NUMERIC calculations (Kyotaro Horiguchi)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/013", "db_id": "8a48940eeefc861b5ac95e05d9fa4bcb", "patch_ids": [], "statement_hash": "86e9be225ba5ba774db6a6b7681892ab57e0a55c7a4966a0d16f5d4aedb47b59", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=9.3.0#9.3.0-0b654fd228ff2eca", "migration": false}, {"id": "9.3.0-a6550365aefe5636", "cves": [], "html": "Improve synchronization of sessions waiting for commit_delay (Peter Geoghegan)
\nThis greatly improves the usefulness of commit_delay.
", "text": "Improve synchronization of sessions waiting for commit_delay (Peter Geoghegan) This greatly improves the usefulness of commit_delay.", "title": "Improve synchronization of sessions waiting for commit_delay", "commits": [], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/9.3.0/#AEN119198", "source_hash": "426a18738b0db9437739bdc8e8fea16451dcd3b3d7c36e8a83402263e86472d5", "section_path": ["Server", "General Performance"], "commit_groups": [], "identity_text": "Improve synchronization of sessions waiting for commit_delay (Peter Geoghegan) This greatly improves the usefulness of commit_delay.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/014", "db_id": "e62107f6573b104afb9360803668b761", "patch_ids": [], "statement_hash": "a4e59ffb8a21d0b8d06f0f3f69889a71db102488542141ee49342909c3d41ba8", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=9.3.0#9.3.0-a6550365aefe5636", "migration": false}, {"id": "9.3.0-2fd4dab526a7ead3", "cves": [], "html": "Improve performance of the CREATE TEMPORARY TABLE ... ON COMMIT DELETE ROWS option by not truncating such temporary tables in transactions that haven't touched any temporary tables (Heikki Linnakangas)
", "text": "Improve performance of the CREATE TEMPORARY TABLE ... ON COMMIT DELETE ROWS option by not truncating such temporary tables in transactions that haven't touched any temporary tables (Heikki Linnakangas)", "title": "Improve performance of the CREATE TEMPORARY TABLE ... ON COMMIT DELETE ROWS option by not truncating such temporary tables in transactions that haven't touched any temporary tables", "commits": [], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/9.3.0/#AEN119198", "source_hash": "1a422d816ca9bd42e9b95e131e881cbcf88ec3865b1030766da8e5b556bbd73a", "section_path": ["Server", "General Performance"], "commit_groups": [], "identity_text": "Improve performance of the CREATE TEMPORARY TABLE ... ON COMMIT DELETE ROWS option by not truncating such temporary tables in transactions that haven't touched any temporary tables (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/015", "db_id": "e16d1ca466ea3435cd93c10133df7717", "patch_ids": [], "statement_hash": "dcee926ba37998773e00e55bfcd80318379c60e8ca66c9392bf81d5be8963fdb", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=9.3.0#9.3.0-2fd4dab526a7ead3", "migration": false}, {"id": "9.3.0-2e9621d2d856d56f", "cves": [], "html": "Make vacuum recheck visibility after it has removed expired tuples (Pavan Deolasee)
\nThis increases the chance of a page being marked as all-visible.
", "text": "Make vacuum recheck visibility after it has removed expired tuples (Pavan Deolasee) This increases the chance of a page being marked as all-visible.", "title": "Make vacuum recheck visibility after it has removed expired tuples", "commits": [], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/9.3.0/#AEN119198", "source_hash": "4b0ba2f7f9d5419df31a0adc2b4c002349fa4261a7d9a5ca095c899c6adbd1d3", "section_path": ["Server", "General Performance"], "commit_groups": [], "identity_text": "Make vacuum recheck visibility after it has removed expired tuples (Pavan Deolasee) This increases the chance of a page being marked as all-visible.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/016", "db_id": "bf5376301d4af3baa2feed771f2a9dd9", "patch_ids": [], "statement_hash": "0afa2f4f7a582dcd6eb58401d4e78f61500944d6cd7d5f6b8ab26609cecb1245", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=9.3.0#9.3.0-2e9621d2d856d56f", "migration": false}, {"id": "9.3.0-ec973634a6023204", "cves": [], "html": "Add per-resource-owner lock caches (Jeff Janes)
\nThis speeds up lock bookkeeping at statement completion in multi-statement transactions that hold many locks; it is particularly useful for pg_dump.
", "text": "Add per-resource-owner lock caches (Jeff Janes) This speeds up lock bookkeeping at statement completion in multi-statement transactions that hold many locks; it is particularly useful for pg_dump.", "title": "Add per-resource-owner lock caches", "commits": [], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/9.3.0/#AEN119198", "source_hash": "d243e4115d713ebb06ea8b033532fcb03130e5bfdac67d7cffe1f2b8f3012f57", "section_path": ["Server", "General Performance"], "commit_groups": [], "identity_text": "Add per-resource-owner lock caches (Jeff Janes) This speeds up lock bookkeeping at statement completion in multi-statement transactions that hold many locks; it is particularly useful for pg_dump.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/017", "db_id": "f1217498a8bc4928e5b7adade86443b4", "patch_ids": [], "statement_hash": "0c67bfb4c03ed8d1f5015303257f6f6b5515e7ffba8acbf38b63ab92d1af7f46", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=9.3.0#9.3.0-ec973634a6023204", "migration": false}, {"id": "9.3.0-865388885e1529e0", "cves": [], "html": "Avoid scanning the entire relation cache at commit of a transaction that creates a new relation (Jeff Janes)
\nThis speeds up sessions that create many tables in successive small transactions, such as a pg_restore run.
", "text": "Avoid scanning the entire relation cache at commit of a transaction that creates a new relation (Jeff Janes) This speeds up sessions that create many tables in successive small transactions, such as a pg_restore run.", "title": "Avoid scanning the entire relation cache at commit of a transaction that creates a new relation", "commits": [], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/9.3.0/#AEN119198", "source_hash": "5e7c8eeaf4d133dfa185e18ff3cc228a87924de5b670d3630eeccfc31fbbee63", "section_path": ["Server", "General Performance"], "commit_groups": [], "identity_text": "Avoid scanning the entire relation cache at commit of a transaction that creates a new relation (Jeff Janes) This speeds up sessions that create many tables in successive small transactions, such as a pg_restore run.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/018", "db_id": "dfe2b2d500877e6f75a3b5b10c127a95", "patch_ids": [], "statement_hash": "c21bd37e434829801a74842e8eb7a069a80831e87c3feafc35a2afd504a6fcfb", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=9.3.0#9.3.0-865388885e1529e0", "migration": false}, {"id": "9.3.0-9af1c780701788e7", "cves": [], "html": "Improve performance of transactions that drop many relations (Tomas Vondra)
", "text": "Improve performance of transactions that drop many relations (Tomas Vondra)", "title": "Improve performance of transactions that drop many relations", "commits": [], "section": "Server / General Performance", "category": "performance", "source_url": "/docs/release/9.3.0/#AEN119198", "source_hash": "1c51964d412f4f062b0ae237b0bff4118a3361e358ae0874100f316a7e7a73af", "section_path": ["Server", "General Performance"], "commit_groups": [], "identity_text": "Improve performance of transactions that drop many relations (Tomas Vondra)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/019", "db_id": "3d6f9d39b157dfdd1a39413a172bc8db", "patch_ids": [], "statement_hash": "0a66132fff8060636c01885608a01f1080115d259496b8e87844b44878163daa", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=9.3.0#9.3.0-9af1c780701788e7", "migration": false}, {"id": "9.3.0-1bac30923ad01c75", "cves": [], "html": "Add optional ability to checksum data pages and report corruption (Simon Riggs, Jeff Davis, Greg Smith, Ants Aasma)
\nThe checksum option can be set during initdb.
", "text": "Add optional ability to checksum data pages and report corruption (Simon Riggs, Jeff Davis, Greg Smith, Ants Aasma) The checksum option can be set during initdb.", "title": "Add optional ability to checksum data pages and report corruption", "commits": [], "section": "Server / Monitoring", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119232", "source_hash": "23f98385aeef664b0fc5865d2c042cdc7cbd4235a56bfabc719b9634400d3185", "section_path": ["Server", "Monitoring"], "commit_groups": [], "identity_text": "Add optional ability to checksum data pages and report corruption (Simon Riggs, Jeff Davis, Greg Smith, Ants Aasma) The checksum option can be set during initdb.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/020", "db_id": "ecd83bc3bd3ca65b7dfd8cf0d7f1efc4", "patch_ids": [], "statement_hash": "1e55c25dd20b6db4f6ff3997ca6dd1e988561a6dba8b5c0f44a6ffe9b54564b7", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-1bac30923ad01c75", "migration": false}, {"id": "9.3.0-6d236f2e03b5b3ec", "cves": [], "html": "Split the statistics collector's data file into separate global and per-database files (Tomas Vondra)
\nThis reduces the I/O required for statistics tracking.
", "text": "Split the statistics collector's data file into separate global and per-database files (Tomas Vondra) This reduces the I/O required for statistics tracking.", "title": "Split the statistics collector's data file into separate global and per-database files", "commits": [], "section": "Server / Monitoring", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119232", "source_hash": "64d8fb8a3221134b93662c9e7d8073d91807c1efa2fd3856c9433048bb8ac1f6", "section_path": ["Server", "Monitoring"], "commit_groups": [], "identity_text": "Split the statistics collector's data file into separate global and per-database files (Tomas Vondra) This reduces the I/O required for statistics tracking.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/021", "db_id": "c7167cf36993840d96ef122cc95b8cfb", "patch_ids": [], "statement_hash": "e00fc433b1a2e32495c8f37ec1c631a3432da220c77369c1ca6905899ce230bd", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-6d236f2e03b5b3ec", "migration": false}, {"id": "9.3.0-11f193f9a52dd505", "cves": [], "html": "Fix the statistics collector to operate properly in cases where the system clock goes backwards (Tom Lane)
\nPreviously, statistics collection would stop until the time again reached the latest time previously recorded.
", "text": "Fix the statistics collector to operate properly in cases where the system clock goes backwards (Tom Lane) Previously, statistics collection would stop until the time again reached the latest time previously recorded.", "title": "Fix the statistics collector to operate properly in cases where the system clock goes backwards", "commits": [], "section": "Server / Monitoring", "category": "bugfix", "source_url": "/docs/release/9.3.0/#AEN119232", "source_hash": "586254a9a4dd71b4c6347765302b1ed28a5f6ef015e5d3bb42e67c3e2d50eaa9", "section_path": ["Server", "Monitoring"], "commit_groups": [], "identity_text": "Fix the statistics collector to operate properly in cases where the system clock goes backwards (Tom Lane) Previously, statistics collection would stop until the time again reached the latest time previously recorded.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/022", "db_id": "46d7fd411dcca710382d1e065051afb4", "patch_ids": [], "statement_hash": "906ac7fcfa38eba10d25d02f4441130bf79734a666965d68eba79db4f652e493", "relations": [], "category_label": "Bug fixes", "url": "/docs/compare/?release=9.3.0#9.3.0-11f193f9a52dd505", "migration": false}, {"id": "9.3.0-ad70b3a5eadb6737", "cves": [], "html": "Emit an informative message to postmaster standard error when we are about to stop logging there (Tom Lane)
\nThis should help reduce user confusion about where to look for log output in common configurations that log to standard error only during postmaster startup.
", "text": "Emit an informative message to postmaster standard error when we are about to stop logging there (Tom Lane) This should help reduce user confusion about where to look for log output in common configurations that log to standard error only during postmaster startup.", "title": "Emit an informative message to postmaster standard error when we are about to stop logging there", "commits": [], "section": "Server / Monitoring", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119232", "source_hash": "1211d0de634fa434c83804d4c7054980c024ce08f1a4895187340fb702d5b653", "section_path": ["Server", "Monitoring"], "commit_groups": [], "identity_text": "Emit an informative message to postmaster standard error when we are about to stop logging there (Tom Lane) This should help reduce user confusion about where to look for log output in common configurations that log to standard error only during postmaster startup.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/023", "db_id": "3a732ba920643bc67fc84aa173dcfc62", "patch_ids": [], "statement_hash": "5678420bfb572c72679c628e04553c28965bd7504d281fba21787ebf9f8299c9", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-ad70b3a5eadb6737", "migration": false}, {"id": "9.3.0-02651842b440e895", "cves": [], "html": "When an authentication failure occurs, log the relevant pg_hba.conf line, to ease debugging of unintended failures (Magnus Hagander)
", "text": "When an authentication failure occurs, log the relevant pg_hba.conf line, to ease debugging of unintended failures (Magnus Hagander)", "title": "When an authentication failure occurs, log the relevant pg_hba.conf line, to ease debugging of unintended failures", "commits": [], "section": "Server / Authentication", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119250", "source_hash": "313bccd0e2f120910c42aa41da7b223ca222c78b2fa705e08c7ad59076f4e30d", "section_path": ["Server", "Authentication"], "commit_groups": [], "identity_text": "When an authentication failure occurs, log the relevant pg_hba.conf line, to ease debugging of unintended failures (Magnus Hagander)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/024", "db_id": "8d08ae3cfaa94b976e49a9ecfd7be681", "patch_ids": [], "statement_hash": "0e298295fa814bf87ff71bbc22c6d83467a0b94c9cf2a1af13cb11527c96a137", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-02651842b440e895", "migration": false}, {"id": "9.3.0-009071e410f474f9", "cves": [], "html": "Improve LDAP error reporting and documentation (Peter Eisentraut)
", "text": "Improve LDAP error reporting and documentation (Peter Eisentraut)", "title": "Improve LDAP error reporting and documentation", "commits": [], "section": "Server / Authentication", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119250", "source_hash": "eb346d8eb68390925d3383710e9e64b717a9e66ca5def6a66fde7597bdef3667", "section_path": ["Server", "Authentication"], "commit_groups": [], "identity_text": "Improve LDAP error reporting and documentation (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/025", "db_id": "817988d3f6995071edf060c74bd421f5", "patch_ids": [], "statement_hash": "ad38c2cd89c519fb3c1dbd60d6a387852ab0ec4d314d55dfc0aa7bfe00aa0462", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-009071e410f474f9", "migration": false}, {"id": "9.3.0-9c302d8f98c97d6c", "cves": [], "html": "Add support for specifying LDAP authentication parameters in URL format, per RFC 4516 (Peter Eisentraut)
", "text": "Add support for specifying LDAP authentication parameters in URL format, per RFC 4516 (Peter Eisentraut)", "title": "Add support for specifying LDAP authentication parameters in URL format, per RFC 4516", "commits": [], "section": "Server / Authentication", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119250", "source_hash": "220c33de1af771075f342369f1919a98403deadc85693c1582352f53195eb6a0", "section_path": ["Server", "Authentication"], "commit_groups": [], "identity_text": "Add support for specifying LDAP authentication parameters in URL format, per RFC 4516 (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/026", "db_id": "6ab3d01a60dbfcbd681d5fd5154c33de", "patch_ids": [], "statement_hash": "8e9117974a8bc55558babe5c7f54899a7c0b67d8fcf0eceab5bea37d1b3937bd", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-9c302d8f98c97d6c", "migration": false}, {"id": "9.3.0-50a6ddf84b8b8276", "cves": [], "html": "Change the ssl_ciphers parameter to start with DEFAULT, rather than ALL, then remove insecure ciphers (Magnus Hagander)
\nThis should yield a more appropriate SSL cipher set.
", "text": "Change the ssl_ciphers parameter to start with DEFAULT, rather than ALL, then remove insecure ciphers (Magnus Hagander) This should yield a more appropriate SSL cipher set.", "title": "Change the ssl_ciphers parameter to start with DEFAULT, rather than ALL, then remove insecure ciphers", "commits": [], "section": "Server / Authentication", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119250", "source_hash": "312ec140eb874d6bb0c47810c663cbe4db5e814410b7d8106795a3637d477a77", "section_path": ["Server", "Authentication"], "commit_groups": [], "identity_text": "Change the ssl_ciphers parameter to start with DEFAULT, rather than ALL, then remove insecure ciphers (Magnus Hagander) This should yield a more appropriate SSL cipher set.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/027", "db_id": "35724f936530e46d9607361fb5ea3d23", "patch_ids": [], "statement_hash": "7fa7bf8c3271f8771b8b0f6b8b44940b7c1e382c27ca33275457cded91b16826", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-50a6ddf84b8b8276", "migration": false}, {"id": "9.3.0-8f22361065b3f26e", "cves": [], "html": "Parse and load pg_ident.conf once, not during each connection (Amit Kapila)
\nThis is similar to how pg_hba.conf is processed.
", "text": "Parse and load pg_ident.conf once, not during each connection (Amit Kapila) This is similar to how pg_hba.conf is processed.", "title": "Parse and load pg_ident.conf once, not during each connection", "commits": [], "section": "Server / Authentication", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119250", "source_hash": "69580fff9989761ac9f1e01ad58b32422c962e3d5d7e2252ffb94362d2d9c3f3", "section_path": ["Server", "Authentication"], "commit_groups": [], "identity_text": "Parse and load pg_ident.conf once, not during each connection (Amit Kapila) This is similar to how pg_hba.conf is processed.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/028", "db_id": "b2f55909ef6e8eb166ea7c448439ba4b", "patch_ids": [], "statement_hash": "97a79305435e698802035815d4ab2089631d99393653019e0c79231b2d4e0fa8", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-8f22361065b3f26e", "migration": false}, {"id": "9.3.0-d69fa4d248fad320", "cves": [], "html": "Greatly reduce System V shared memory requirements (Robert Haas)
\nOn Unix-like systems, mmap() is now used for most of PostgreSQL's shared memory. For most users, this will eliminate any need to adjust kernel parameters for shared memory.
Allow the postmaster to listen on multiple Unix-domain sockets (Honza Hor\u00e1k)
\nThe configuration parameter unix_socket_directory is replaced by unix_socket_directories, which accepts a list of directories.
", "text": "Allow the postmaster to listen on multiple Unix-domain sockets (Honza Hor\u00e1k) The configuration parameter unix_socket_directory is replaced by unix_socket_directories, which accepts a list of directories.", "title": "Allow the postmaster to listen on multiple Unix-domain sockets", "commits": [], "section": "Server / Server Settings", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119278", "source_hash": "e9c2726d33286715070fb8c2017565917bf061a705845eab082f84b3d5f777e5", "section_path": ["Server", "Server Settings"], "commit_groups": [], "identity_text": "Allow the postmaster to listen on multiple Unix-domain sockets (Honza Hor\u00e1k) The configuration parameter unix_socket_directory is replaced by unix_socket_directories, which accepts a list of directories.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/030", "db_id": "bb2c8204e469a794bd00d9f3c4e53575", "patch_ids": [], "statement_hash": "719867222dc7c896d99c5ce924e51f171f53fb9bd878b606a9e73d124149dfc6", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-c163ce87c3ca1a75", "migration": false}, {"id": "9.3.0-9666a76eca545d6f", "cves": [], "html": "Allow a directory of configuration files to be processed (Magnus Hagander, Greg Smith, Selena Deckelmann)
\nSuch a directory is specified with include_dir in the server configuration file.
", "text": "Allow a directory of configuration files to be processed (Magnus Hagander, Greg Smith, Selena Deckelmann) Such a directory is specified with include_dir in the server configuration file.", "title": "Allow a directory of configuration files to be processed", "commits": [], "section": "Server / Server Settings", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119278", "source_hash": "737ecf3c63b490706b0cfcc39cfbdeb417b17f202e2b37d038850e0b87354e14", "section_path": ["Server", "Server Settings"], "commit_groups": [], "identity_text": "Allow a directory of configuration files to be processed (Magnus Hagander, Greg Smith, Selena Deckelmann) Such a directory is specified with include_dir in the server configuration file.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/031", "db_id": "46d594c543f46c342cdc21d448d1a00e", "patch_ids": [], "statement_hash": "8d2fe37f3fdf22259c6a10c22aa171211871fbdf6902f0acbe324ee3797dfc33", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-9666a76eca545d6f", "migration": false}, {"id": "9.3.0-f6b3dd64f5ddd5b0", "cves": [], "html": "Increase the maximum initdb-configured value for shared_buffers to 128MB (Robert Haas)
\nThis is the maximum value that initdb will attempt to set in postgresql.conf; the previous maximum was 32MB.
", "text": "Increase the maximum initdb-configured value for shared_buffers to 128MB (Robert Haas) This is the maximum value that initdb will attempt to set in postgresql.conf; the previous maximum was 32MB.", "title": "Increase the maximum initdb-configured value for shared_buffers to 128MB", "commits": [], "section": "Server / Server Settings", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119278", "source_hash": "c91806cf7dda8b795dfbf36b3174c7e158cff07abc1efecabeade95b3d45f9e1", "section_path": ["Server", "Server Settings"], "commit_groups": [], "identity_text": "Increase the maximum initdb-configured value for shared_buffers to 128MB (Robert Haas) This is the maximum value that initdb will attempt to set in postgresql.conf; the previous maximum was 32MB.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/032", "db_id": "3655232058d66fb6ff1812d97f6cd814", "patch_ids": [], "statement_hash": "6b3cdcd4c096ec12042c7abef10a68d7eaf43779116d6063a87ff0f8cc0ba132", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-f6b3dd64f5ddd5b0", "migration": false}, {"id": "9.3.0-78c76371ff9eeb69", "cves": [], "html": "Remove the external PID file, if any, on postmaster exit (Peter Eisentraut)
", "text": "Remove the external PID file, if any, on postmaster exit (Peter Eisentraut)", "title": "Remove the external PID file, if any, on postmaster exit", "commits": [], "section": "Server / Server Settings", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119278", "source_hash": "feedbd294fbf10be8d36457b23fd3e64fd231fd0e147447312fc7070d81078ec", "section_path": ["Server", "Server Settings"], "commit_groups": [], "identity_text": "Remove the external PID file, if any, on postmaster exit (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/033", "db_id": "45ff702cefe500ac83700aad651328b6", "patch_ids": [], "statement_hash": "6cf4f06d2f1a5df6403ac500e1d83ec6677b37bc6bd3ba51320541fe97fa752f", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-78c76371ff9eeb69", "migration": false}, {"id": "9.3.0-ccd958255993d09d", "cves": [], "html": "Allow a streaming replication standby to follow a timeline switch (Heikki Linnakangas)
\nThis allows streaming standby servers to receive WAL data from a slave newly promoted to master status. Previously, other standbys would require a resync to begin following the new master.
", "text": "Allow a streaming replication standby to follow a timeline switch (Heikki Linnakangas) This allows streaming standby servers to receive WAL data from a slave newly promoted to master status. Previously, other standbys would require a resync to begin following the new master.", "title": "Allow a streaming replication standby to follow a timeline switch", "commits": [], "section": "Replication and Recovery", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119310", "source_hash": "689bbc57cc34d9433b2104d0ab38f9c6e94c82a4958a74428b7a939bd40f26cd", "section_path": ["Replication and Recovery"], "commit_groups": [], "identity_text": "Allow a streaming replication standby to follow a timeline switch (Heikki Linnakangas) This allows streaming standby servers to receive WAL data from a slave newly promoted to master status. Previously, other standbys would require a resync to begin following the new master.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/034", "db_id": "e88de651c646e2ffae5b8c360d85c52c", "patch_ids": [], "statement_hash": "b7fa3a263b18b12b7b7da79e9a62aa49a92307ebf4be16dec7ff6865851985b3", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-ccd958255993d09d", "migration": false}, {"id": "9.3.0-2ecb03951496baed", "cves": [], "html": "Add SQL functions pg_is_in_backup() and pg_backup_start_time() (Gilles Darold)
These functions report the status of base backups.
", "text": "Add SQL functions pg_is_in_backup() and pg_backup_start_time() (Gilles Darold) These functions report the status of base backups.", "title": "Add SQL functions pg_is_in_backup() and pg_backup_start_time()", "commits": [], "section": "Replication and Recovery", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119310", "source_hash": "47913e8619a3da1195bc032bdf98bac4f2e2c94dcdeed391c06c647bfa03d5a6", "section_path": ["Replication and Recovery"], "commit_groups": [], "identity_text": "Add SQL functions pg_is_in_backup() and pg_backup_start_time() (Gilles Darold) These functions report the status of base backups.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/035", "db_id": "c79741e8887d5130b54b039edad9ffcc", "patch_ids": [], "statement_hash": "4e4abfa7fcfb2f48b012c229eeee39faaf8c09609da429fd84956e8b121859c0", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-2ecb03951496baed", "migration": false}, {"id": "9.3.0-45aa6b239f9aff71", "cves": [], "html": "Improve performance of streaming log shipping with synchronous_commit disabled (Andres Freund)
", "text": "Improve performance of streaming log shipping with synchronous_commit disabled (Andres Freund)", "title": "Improve performance of streaming log shipping with synchronous_commit disabled", "commits": [], "section": "Replication and Recovery", "category": "performance", "source_url": "/docs/release/9.3.0/#AEN119310", "source_hash": "1d6516fcaab0e075e829eb552d5e587a300db9c82bffed3e9ab4eaf8989da300", "section_path": ["Replication and Recovery"], "commit_groups": [], "identity_text": "Improve performance of streaming log shipping with synchronous_commit disabled (Andres Freund)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/036", "db_id": "a02bf999ead322bcb3640d67f8eae9b5", "patch_ids": [], "statement_hash": "804156b915b7acccff1a5cd51159fed9e0b6850018b6d96017503ad663b64220", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=9.3.0#9.3.0-45aa6b239f9aff71", "migration": false}, {"id": "9.3.0-949eae5196999678", "cves": [], "html": "Allow much faster promotion of a streaming standby to primary (Simon Riggs, Kyotaro Horiguchi)
", "text": "Allow much faster promotion of a streaming standby to primary (Simon Riggs, Kyotaro Horiguchi)", "title": "Allow much faster promotion of a streaming standby to primary", "commits": [], "section": "Replication and Recovery", "category": "performance", "source_url": "/docs/release/9.3.0/#AEN119310", "source_hash": "a855832eac09b5971b4b590091a48ce3ae1d5e283e50b6bcc4609f3e0e968ddf", "section_path": ["Replication and Recovery"], "commit_groups": [], "identity_text": "Allow much faster promotion of a streaming standby to primary (Simon Riggs, Kyotaro Horiguchi)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/037", "db_id": "50f288af198d64505c556040d4132466", "patch_ids": [], "statement_hash": "d75c9aa06cca5db1d5ea4b3619968e0e9e49f2b3fc29a81bbe1b3d26524a93e9", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=9.3.0#9.3.0-949eae5196999678", "migration": false}, {"id": "9.3.0-84b00aac3da59f5e", "cves": [], "html": "Add the last checkpoint's redo location to pg_controldata's output (Fujii Masao)
\nThis information is useful for determining which WAL files are needed for restore.
", "text": "Add the last checkpoint's redo location to pg_controldata's output (Fujii Masao) This information is useful for determining which WAL files are needed for restore.", "title": "Add the last checkpoint's redo location to pg_controldata's output", "commits": [], "section": "Replication and Recovery", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119310", "source_hash": "b2ba39bc59858e099354ff0f37448f06090fb8b6d2245ef62206faabdda637df", "section_path": ["Replication and Recovery"], "commit_groups": [], "identity_text": "Add the last checkpoint's redo location to pg_controldata's output (Fujii Masao) This information is useful for determining which WAL files are needed for restore.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/038", "db_id": "68ea514e58a7278417ceaecc4d8941a4", "patch_ids": [], "statement_hash": "366e91bc53ea8a3be0634a8ab76a0bf4caed577cef7744dc09bc89a393c04ca5", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-84b00aac3da59f5e", "migration": false}, {"id": "9.3.0-cf5bb74a72c20f70", "cves": [], "html": "Allow tools like pg_receivexlog to run on computers with different architectures (Heikki Linnakangas)
\nWAL files can still only be replayed on servers with the same architecture as the primary; but they can now be transmitted to and stored on machines of any architecture, since the streaming replication protocol is now machine-independent.
", "text": "Allow tools like pg_receivexlog to run on computers with different architectures (Heikki Linnakangas) WAL files can still only be replayed on servers with the same architecture as the primary; but they can now be transmitted to and stored on machines of any architecture, since the streaming replication protocol is now machine-independent.", "title": "Allow tools like pg_receivexlog to run on computers with different architectures", "commits": [], "section": "Replication and Recovery", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119310", "source_hash": "bce63399f007768ed27caa9616577c256fe5018a295e8b4c7aa9d9fbcfa8a9b0", "section_path": ["Replication and Recovery"], "commit_groups": [], "identity_text": "Allow tools like pg_receivexlog to run on computers with different architectures (Heikki Linnakangas) WAL files can still only be replayed on servers with the same architecture as the primary; but they can now be transmitted to and stored on machines of any architecture, since the streaming replication protocol is now machine-independent.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/039", "db_id": "3a5d9a73901f3de18b0d9ce577d06041", "patch_ids": [], "statement_hash": "c1942247f2e02d10fb5904d79a1c8f0a1650f6d16b696e33cef42394fca4f327", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-cf5bb74a72c20f70", "migration": false}, {"id": "9.3.0-ee91d3cc7fd04e93", "cves": [], "html": "Make pg_basebackup --write-recovery-conf output a minimal recovery.conf file (Zolt\u00e1n B\u00f6sz\u00f6rm\u00e9nyi, Magnus Hagander)
\nThis simplifies setting up a standby server.
", "text": "Make pg_basebackup --write-recovery-conf output a minimal recovery.conf file (Zolt\u00e1n B\u00f6sz\u00f6rm\u00e9nyi, Magnus Hagander) This simplifies setting up a standby server.", "title": "Make pg_basebackup --write-recovery-conf output a minimal recovery.conf file", "commits": [], "section": "Replication and Recovery", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119310", "source_hash": "d6ea6b3405eca6038630deafda076342bd0c9908496d83af60cf765c497a7c70", "section_path": ["Replication and Recovery"], "commit_groups": [], "identity_text": "Make pg_basebackup --write-recovery-conf output a minimal recovery.conf file (Zolt\u00e1n B\u00f6sz\u00f6rm\u00e9nyi, Magnus Hagander) This simplifies setting up a standby server.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/040", "db_id": "858cf86f2245b5ab5403c6667fe212ce", "patch_ids": [], "statement_hash": "1b464be08e5c98862180011abbef6f3c2d8393f14ebdb923a647074c1b4ef7b9", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-ee91d3cc7fd04e93", "migration": false}, {"id": "9.3.0-5e08cf4e13815a2e", "cves": [], "html": "Allow pg_receivexlog and pg_basebackup --xlog-method to handle streaming timeline switches (Heikki Linnakangas)
", "text": "Allow pg_receivexlog and pg_basebackup --xlog-method to handle streaming timeline switches (Heikki Linnakangas)", "title": "Allow pg_receivexlog and pg_basebackup --xlog-method to handle streaming timeline switches", "commits": [], "section": "Replication and Recovery", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119310", "source_hash": "0bfb46d4acbf294a921c74fe9dd50d4648c2a4ebf1e7ecb9c26c335a65272cad", "section_path": ["Replication and Recovery"], "commit_groups": [], "identity_text": "Allow pg_receivexlog and pg_basebackup --xlog-method to handle streaming timeline switches (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/041", "db_id": "936069856cefe1fbc499d2983eb8bfd7", "patch_ids": [], "statement_hash": "062164bd2e1b785acdbb358639b97842092cfb08031a080bac51cf1d6103801c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-5e08cf4e13815a2e", "migration": false}, {"id": "9.3.0-a53c50f085b3690b", "cves": [], "html": "Add wal_receiver_timeout parameter to control the WAL receiver's timeout (Amit Kapila)
\nThis allows more rapid detection of connection failure.
", "text": "Add wal_receiver_timeout parameter to control the WAL receiver's timeout (Amit Kapila) This allows more rapid detection of connection failure.", "title": "Add wal_receiver_timeout parameter to control the WAL receiver's timeout", "commits": [], "section": "Replication and Recovery", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119310", "source_hash": "4d5969c17e353e16e65eb381bc4ee570a3641e35499d8f15226719c32706d480", "section_path": ["Replication and Recovery"], "commit_groups": [], "identity_text": "Add wal_receiver_timeout parameter to control the WAL receiver's timeout (Amit Kapila) This allows more rapid detection of connection failure.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/042", "db_id": "71ffd7cf4455adf14b143bf2789927a8", "patch_ids": [], "statement_hash": "45470d874be1d59473b93e81e7526cfbcccdcef834d1e82313d5fedbf9c4cec0", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-a53c50f085b3690b", "migration": false}, {"id": "9.3.0-495f8335cca85e00", "cves": [], "html": "Change the WAL record format to allow splitting the record header across pages (Heikki Linnakangas)
\nThe new format is slightly more compact, and is more efficient to write.
", "text": "Change the WAL record format to allow splitting the record header across pages (Heikki Linnakangas) The new format is slightly more compact, and is more efficient to write.", "title": "Change the WAL record format to allow splitting the record header across pages", "commits": [], "section": "Replication and Recovery", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119310", "source_hash": "89fc029ded27849c4484fb0ca984ef8fab8f000fb76f69ee49bfd54b8ab1fd32", "section_path": ["Replication and Recovery"], "commit_groups": [], "identity_text": "Change the WAL record format to allow splitting the record header across pages (Heikki Linnakangas) The new format is slightly more compact, and is more efficient to write.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/043", "db_id": "355030fdc343065b52e1db05b43075de", "patch_ids": [], "statement_hash": "36c49488b8fd68e60a38f0c4246c2407eabea77824374d9cb9c4248edfd21355", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-495f8335cca85e00", "migration": false}, {"id": "9.3.0-29a4aaa7cac224d4", "cves": [], "html": "Implement SQL-standard LATERAL option for FROM-clause subqueries and function calls (Tom Lane)
\nThis feature allows subqueries and functions in FROM to reference columns from other tables in the FROM clause. The LATERAL keyword is optional for functions.
", "text": "Implement SQL-standard LATERAL option for FROM-clause subqueries and function calls (Tom Lane) This feature allows subqueries and functions in FROM to reference columns from other tables in the FROM clause. The LATERAL keyword is optional for functions.", "title": "Implement SQL-standard LATERAL option for FROM-clause subqueries and function calls", "commits": [], "section": "Queries", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119367", "source_hash": "ef9fca2cda4b1547be2d2d488855a543f768ea22ea8bdfc034fafdbd1e10eb6e", "section_path": ["Queries"], "commit_groups": [], "identity_text": "Implement SQL-standard LATERAL option for FROM-clause subqueries and function calls (Tom Lane) This feature allows subqueries and functions in FROM to reference columns from other tables in the FROM clause. The LATERAL keyword is optional for functions.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/044", "db_id": "49bd98dbff41b6fd6c29972ad4f9dc97", "patch_ids": [], "statement_hash": "e3dbe1d7ee55188a7235b7ab7bb1f5078da911be318dd8d134ac2b6f66955214", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-29a4aaa7cac224d4", "migration": false}, {"id": "9.3.0-e8332668dcd2837f", "cves": [], "html": "Add support for piping COPY and psql \\copy data to/from an external program (Etsuro Fujita)
", "text": "Add support for piping COPY and psql \\copy data to/from an external program (Etsuro Fujita)", "title": "Add support for piping COPY and psql \\copy data to/from an external program", "commits": [], "section": "Queries", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119367", "source_hash": "65406727f8f2d005528246db1d5333c1973b45799936b9ab3d12c8e9d327cfa1", "section_path": ["Queries"], "commit_groups": [], "identity_text": "Add support for piping COPY and psql \\copy data to/from an external program (Etsuro Fujita)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/045", "db_id": "7f502a4dce05b9adfc8df1ac0166966b", "patch_ids": [], "statement_hash": "6f914f7d10ebe9f3544bda44074e89e778cf6fb25a2a585e057cb5e2db7d2c86", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-e8332668dcd2837f", "migration": false}, {"id": "9.3.0-d4685efea7023efa", "cves": [], "html": "Allow a multirow VALUES clause in a rule to reference OLD/NEW (Tom Lane)
", "text": "Allow a multirow VALUES clause in a rule to reference OLD/NEW (Tom Lane)", "title": "Allow a multirow VALUES clause in a rule to reference OLD/NEW", "commits": [], "section": "Queries", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119367", "source_hash": "3ef1d70b7fb08de773e202d8f68b3381f669ae4a1a303ec6429058d00f0420ab", "section_path": ["Queries"], "commit_groups": [], "identity_text": "Allow a multirow VALUES clause in a rule to reference OLD/NEW (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/046", "db_id": "99ca017a92d8cc849a5855cbbded30df", "patch_ids": [], "statement_hash": "b463330670567c6efae782367ca06559c75007680cf44d408455def39064983c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-d4685efea7023efa", "migration": false}, {"id": "9.3.0-f122702cfe0f665d", "cves": [], "html": "Add support for event triggers (Dimitri Fontaine, Robert Haas, \u00c1lvaro Herrera)
\nThis allows server-side functions written in event-enabled languages to be called when DDL commands are run.
", "text": "Add support for event triggers (Dimitri Fontaine, Robert Haas, \u00c1lvaro Herrera) This allows server-side functions written in event-enabled languages to be called when DDL commands are run.", "title": "Add support for event triggers", "commits": [], "section": "Object Manipulation", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119393", "source_hash": "de9fc765b5d9d1da608da685aacec20d38fcbd284abaa8443d171790734280ea", "section_path": ["Object Manipulation"], "commit_groups": [], "identity_text": "Add support for event triggers (Dimitri Fontaine, Robert Haas, \u00c1lvaro Herrera) This allows server-side functions written in event-enabled languages to be called when DDL commands are run.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/047", "db_id": "4b8974af2479bd542cfd5714f26dcdf8", "patch_ids": [], "statement_hash": "15f1115423d5d789f7961d899b071a93d5fef56282592a74fb52d96135caa8e8", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-f122702cfe0f665d", "migration": false}, {"id": "9.3.0-a8e8b19a3f9adfbf", "cves": [], "html": "Allow foreign data wrappers to support writes (inserts/updates/deletes) on foreign tables (KaiGai Kohei)
", "text": "Allow foreign data wrappers to support writes (inserts/updates/deletes) on foreign tables (KaiGai Kohei)", "title": "Allow foreign data wrappers to support writes (inserts/updates/deletes) on foreign tables", "commits": [], "section": "Object Manipulation", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119393", "source_hash": "2c7dbdf51455562208b8418466c1bdd2b43fac3f82cfd708752a02ad6140e120", "section_path": ["Object Manipulation"], "commit_groups": [], "identity_text": "Allow foreign data wrappers to support writes (inserts/updates/deletes) on foreign tables (KaiGai Kohei)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/048", "db_id": "2f2dca91b57532d0be7ce2d652b02981", "patch_ids": [], "statement_hash": "21c159bda64a1d643b701443cd0d7f6d178801373653bb3199a96c54a72276d7", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-a8e8b19a3f9adfbf", "migration": false}, {"id": "9.3.0-5f2576c6fc2e479f", "cves": [], "html": "Add CREATE SCHEMA ... IF NOT EXISTS clause (Fabr\u00edzio de Royes Mello)
", "text": "Add CREATE SCHEMA ... IF NOT EXISTS clause (Fabr\u00edzio de Royes Mello)", "title": "Add CREATE SCHEMA ... IF NOT EXISTS clause", "commits": [], "section": "Object Manipulation", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119393", "source_hash": "424625f55cae56d13ee1c75b2bbb33a864151bb61cb7b5e4fead676d9c5ef6b7", "section_path": ["Object Manipulation"], "commit_groups": [], "identity_text": "Add CREATE SCHEMA ... IF NOT EXISTS clause (Fabr\u00edzio de Royes Mello)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/049", "db_id": "5e7b01eeab3cf7edb09b988e745cd5c2", "patch_ids": [], "statement_hash": "f7a133be1bbc7c414dcb69684b1eb7d838b6109b7075f9788ce10ddfa09b68d2", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-5f2576c6fc2e479f", "migration": false}, {"id": "9.3.0-bbfe482ea006662c", "cves": [], "html": "Make REASSIGN OWNED also change ownership of shared objects (\u00c1lvaro Herrera)
", "text": "Make REASSIGN OWNED also change ownership of shared objects (\u00c1lvaro Herrera)", "title": "Make REASSIGN OWNED also change ownership of shared objects", "commits": [], "section": "Object Manipulation", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119393", "source_hash": "47d3d51bb57e20e7b0171e9d103af48b95c724797fe7da284e1daa994ec58b68", "section_path": ["Object Manipulation"], "commit_groups": [], "identity_text": "Make REASSIGN OWNED also change ownership of shared objects (\u00c1lvaro Herrera)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/050", "db_id": "5805b7eeaec9d68ca6162d467b5bbd21", "patch_ids": [], "statement_hash": "4c360381b8a441f6f33993d3a15d89b98c99db1bbf836bc9cde9d9cf7db805b7", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-bbfe482ea006662c", "migration": false}, {"id": "9.3.0-af034db8a3df0617", "cves": [], "html": "Make CREATE AGGREGATE complain if the given initial value string is not valid input for the transition datatype (Tom Lane)
", "text": "Make CREATE AGGREGATE complain if the given initial value string is not valid input for the transition datatype (Tom Lane)", "title": "Make CREATE AGGREGATE complain if the given initial value string is not valid input for the transition datatype", "commits": [], "section": "Object Manipulation", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119393", "source_hash": "a0d15f33d197c1b0a30d58edd0e45fa1deac8456c076a76f5d648fcc34086b7e", "section_path": ["Object Manipulation"], "commit_groups": [], "identity_text": "Make CREATE AGGREGATE complain if the given initial value string is not valid input for the transition datatype (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/051", "db_id": "10a0ce4e8eb13f80036faaee922e71bb", "patch_ids": [], "statement_hash": "1d748bd24d56643f209000fa5061a2946fee9e627c4addfada47ebe88e2fc686", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-af034db8a3df0617", "migration": false}, {"id": "9.3.0-031900665b1789ac", "cves": [], "html": "Suppress CREATE TABLE's messages about implicit index and sequence creation (Robert Haas)
\nThese messages now appear at DEBUG1 verbosity, so that they will not be shown by default.
", "text": "Suppress CREATE TABLE's messages about implicit index and sequence creation (Robert Haas) These messages now appear at DEBUG1 verbosity, so that they will not be shown by default.", "title": "Suppress CREATE TABLE's messages about implicit index and sequence creation", "commits": [], "section": "Object Manipulation", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119393", "source_hash": "daec8f7e2496479bcd2890e19650c11e4f7a41b483b5c9fb4005704fa54e6d34", "section_path": ["Object Manipulation"], "commit_groups": [], "identity_text": "Suppress CREATE TABLE's messages about implicit index and sequence creation (Robert Haas) These messages now appear at DEBUG1 verbosity, so that they will not be shown by default.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/052", "db_id": "546c548e73356d5047d1bd0910629c70", "patch_ids": [], "statement_hash": "0b66b27db4cd60e2289cb3a9ef0ef475e9231b08f54dc436c2d3e47883f06704", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-031900665b1789ac", "migration": false}, {"id": "9.3.0-fa14a68471fae6c1", "cves": [], "html": "Allow DROP TABLE IF EXISTS to succeed when a non-existent schema is specified in the table name (Bruce Momjian)
\nPreviously, it threw an error if the schema did not exist.
", "text": "Allow DROP TABLE IF EXISTS to succeed when a non-existent schema is specified in the table name (Bruce Momjian) Previously, it threw an error if the schema did not exist.", "title": "Allow DROP TABLE IF EXISTS to succeed when a non-existent schema is specified in the table name", "commits": [], "section": "Object Manipulation", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119393", "source_hash": "0fad3dea892335e45512966946406c47569c6684d1635581599e0082da8c3e12", "section_path": ["Object Manipulation"], "commit_groups": [], "identity_text": "Allow DROP TABLE IF EXISTS to succeed when a non-existent schema is specified in the table name (Bruce Momjian) Previously, it threw an error if the schema did not exist.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/053", "db_id": "6d1cf8499e8168222a134a5232c5e545", "patch_ids": [], "statement_hash": "fd2bc1334f58c7cae6e824a6d92939d4d5d68e1e470871023f63e21e815cdb25", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-fa14a68471fae6c1", "migration": false}, {"id": "9.3.0-1611c5eec587bc49", "cves": [], "html": "Provide clients with constraint violation details as separate fields (Pavel Stehule)
\nThis allows clients to retrieve table, column, data type, or constraint name error details. Previously such information had to be extracted from error strings. Client library support is required to access these fields.
", "text": "Provide clients with constraint violation details as separate fields (Pavel Stehule) This allows clients to retrieve table, column, data type, or constraint name error details. Previously such information had to be extracted from error strings. Client library support is required to access these fields.", "title": "Provide clients with constraint violation details as separate fields", "commits": [], "section": "Object Manipulation", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119393", "source_hash": "64e96841513dcd4beb816183b6f964371c128582d60c628f16f8b8ccc6f7a277", "section_path": ["Object Manipulation"], "commit_groups": [], "identity_text": "Provide clients with constraint violation details as separate fields (Pavel Stehule) This allows clients to retrieve table, column, data type, or constraint name error details. Previously such information had to be extracted from error strings. Client library support is required to access these fields.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/054", "db_id": "35ef4cec60906274080460ca0a130658", "patch_ids": [], "statement_hash": "c2e4d5b06f511fccc9b583751d4a3a636e51982f8010206d87422c4a05160422", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-1611c5eec587bc49", "migration": false}, {"id": "9.3.0-9ef809acb782cfa5", "cves": [], "html": "Support IF NOT EXISTS option in ALTER TYPE ... ADD VALUE (Andrew Dunstan)
\nThis is useful for conditionally adding values to enumerated types.
", "text": "Support IF NOT EXISTS option in ALTER TYPE ... ADD VALUE (Andrew Dunstan) This is useful for conditionally adding values to enumerated types.", "title": "Support IF NOT EXISTS option in ALTER TYPE ... ADD VALUE", "commits": [], "section": "Object Manipulation / ALTER", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119430", "source_hash": "cf62630c8a9cfb0b80c25af8206066d23f5687bcc55aadc5d84b590e1f4fc9c6", "section_path": ["Object Manipulation", "ALTER"], "commit_groups": [], "identity_text": "Support IF NOT EXISTS option in ALTER TYPE ... ADD VALUE (Andrew Dunstan) This is useful for conditionally adding values to enumerated types.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/055", "db_id": "5e54eea8d23ea2311b24d0f77acce7b6", "patch_ids": [], "statement_hash": "9fde160e34e6d2e56b4c2183c346634a598aa6a3d87b4aa70c6261e963447bc6", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-9ef809acb782cfa5", "migration": false}, {"id": "9.3.0-28e90ce27e11569b", "cves": [], "html": "Add ALTER ROLE ALL SET to establish settings for all users (Peter Eisentraut)
\nThis allows settings to apply to all users in all databases. ALTER DATABASE SET already allowed addition of settings for all users in a single database. postgresql.conf has a similar effect.
", "text": "Add ALTER ROLE ALL SET to establish settings for all users (Peter Eisentraut) This allows settings to apply to all users in all databases. ALTER DATABASE SET already allowed addition of settings for all users in a single database. postgresql.conf has a similar effect.", "title": "Add ALTER ROLE ALL SET to establish settings for all users", "commits": [], "section": "Object Manipulation / ALTER", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119430", "source_hash": "5efa3eaf7baf4d1cf8d64dcde1c80a3d63b050a5978672489e7d1381b097b225", "section_path": ["Object Manipulation", "ALTER"], "commit_groups": [], "identity_text": "Add ALTER ROLE ALL SET to establish settings for all users (Peter Eisentraut) This allows settings to apply to all users in all databases. ALTER DATABASE SET already allowed addition of settings for all users in a single database. postgresql.conf has a similar effect.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/056", "db_id": "6cc9368f35d8d42c69b4077a8fcee94a", "patch_ids": [], "statement_hash": "79b03ec65091ad3b360a2c8e944f0604a2e155eee414bcac084ec34c80625cd0", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-28e90ce27e11569b", "migration": false}, {"id": "9.3.0-77dba2f52fb395c0", "cves": [], "html": "Add support for ALTER RULE ... RENAME (Ali Dar)
", "text": "Add support for ALTER RULE ... RENAME (Ali Dar)", "title": "Add support for ALTER RULE ... RENAME", "commits": [], "section": "Object Manipulation / ALTER", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119430", "source_hash": "96a5adad7ec1122c0e2d0e906e1691407f4632a97e9c6f422b84181b352a91e3", "section_path": ["Object Manipulation", "ALTER"], "commit_groups": [], "identity_text": "Add support for ALTER RULE ... RENAME (Ali Dar)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/057", "db_id": "d2334a91907c74726f5dc67a331780b1", "patch_ids": [], "statement_hash": "39f75dae40f27082f2fda1ed690d84bbf2d6131e87a6a5b2699cffaee371fe79", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-77dba2f52fb395c0", "migration": false}, {"id": "9.3.0-8cacc2d680087ebf", "cves": [], "html": "Add materialized views (Kevin Grittner)
\nUnlike ordinary views, where the base tables are read on every access, materialized views create physical tables at creation or refresh time. Access to the materialized view then reads from its physical table. There is not yet any facility for incrementally refreshing materialized views or auto-accessing them via base table access.
", "text": "Add materialized views (Kevin Grittner) Unlike ordinary views, where the base tables are read on every access, materialized views create physical tables at creation or refresh time. Access to the materialized view then reads from its physical table. There is not yet any facility for incrementally refreshing materialized views or auto-accessing them via base table access.", "title": "Add materialized views", "commits": [], "section": "Object Manipulation / VIEWs", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119452", "source_hash": "17479cf06d5c0d66bea14a4f1f19651e2fb70136e35dfacce7e026650c7cbf84", "section_path": ["Object Manipulation", "VIEWs"], "commit_groups": [], "identity_text": "Add materialized views (Kevin Grittner) Unlike ordinary views, where the base tables are read on every access, materialized views create physical tables at creation or refresh time. Access to the materialized view then reads from its physical table. There is not yet any facility for incrementally refreshing materialized views or auto-accessing them via base table access.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/058", "db_id": "4b09e9c1cec1909f60d8df6980db8f74", "patch_ids": [], "statement_hash": "640a22a8fcc0f9ae13944549b529a58028f34a056e0d6fee824bdb4f888bb24b", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-8cacc2d680087ebf", "migration": false}, {"id": "9.3.0-72f7ef9ea893fb38", "cves": [], "html": "Make simple views auto-updatable (Dean Rasheed)
\nSimple views that reference some or all columns from a single base table are now updatable by default. More complex views can be made updatable using INSTEAD OF triggers or INSTEAD rules.
", "text": "Make simple views auto-updatable (Dean Rasheed) Simple views that reference some or all columns from a single base table are now updatable by default. More complex views can be made updatable using INSTEAD OF triggers or INSTEAD rules.", "title": "Make simple views auto-updatable", "commits": [], "section": "Object Manipulation / VIEWs", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119452", "source_hash": "f9e341dd9302ccdce2de7da06aee7817a02721907083f2da0cf993de79f40072", "section_path": ["Object Manipulation", "VIEWs"], "commit_groups": [], "identity_text": "Make simple views auto-updatable (Dean Rasheed) Simple views that reference some or all columns from a single base table are now updatable by default. More complex views can be made updatable using INSTEAD OF triggers or INSTEAD rules.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/059", "db_id": "23257c0c64acd2d818ca839b4e2e90f6", "patch_ids": [], "statement_hash": "2c5b7f5059a50c2925cf27666b20ae624b32f7082e367e77b3eada2e8f9f80fe", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-72f7ef9ea893fb38", "migration": false}, {"id": "9.3.0-f22c10841bb8eae0", "cves": [], "html": "Add CREATE RECURSIVE VIEW syntax (Peter Eisentraut)
\nInternally this is translated into CREATE VIEW ... WITH RECURSIVE ....
", "text": "Add CREATE RECURSIVE VIEW syntax (Peter Eisentraut) Internally this is translated into CREATE VIEW ... WITH RECURSIVE ....", "title": "Add CREATE RECURSIVE VIEW syntax", "commits": [], "section": "Object Manipulation / VIEWs", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119452", "source_hash": "33043511786c016942dfd1e6d85e5344947b4ac2a2fb470c19996e0285dc48d3", "section_path": ["Object Manipulation", "VIEWs"], "commit_groups": [], "identity_text": "Add CREATE RECURSIVE VIEW syntax (Peter Eisentraut) Internally this is translated into CREATE VIEW ... WITH RECURSIVE ....", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/060", "db_id": "eb3aff6cf17810d8c6937cbf951e78c0", "patch_ids": [], "statement_hash": "88ac4bd64b7b4c48fd0f67f63f23c5b7b70812592d6e2e0f109c308547e79941", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-f22c10841bb8eae0", "migration": false}, {"id": "9.3.0-8b6fe5f02809d53c", "cves": [], "html": "Improve view/rule printing code to handle cases where referenced tables are renamed, or columns are renamed, added, or dropped (Tom Lane)
\nTable and column renamings can produce cases where, if we merely substitute the new name into the original text of a rule or view, the result is ambiguous. This change fixes the rule-dumping code to insert manufactured table and column aliases when needed to preserve the original semantics.
", "text": "Improve view/rule printing code to handle cases where referenced tables are renamed, or columns are renamed, added, or dropped (Tom Lane) Table and column renamings can produce cases where, if we merely substitute the new name into the original text of a rule or view, the result is ambiguous. This change fixes the rule-dumping code to insert manufactured table and column aliases when needed to preserve the original semantics.", "title": "Improve view/rule printing code to handle cases where referenced tables are renamed, or columns are renamed, added, or dropped", "commits": [], "section": "Object Manipulation / VIEWs", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119452", "source_hash": "33e67afcb4976ce82ad2fb361b3bd273968a3e7c6bf8527b97184b84a71aa6e1", "section_path": ["Object Manipulation", "VIEWs"], "commit_groups": [], "identity_text": "Improve view/rule printing code to handle cases where referenced tables are renamed, or columns are renamed, added, or dropped (Tom Lane) Table and column renamings can produce cases where, if we merely substitute the new name into the original text of a rule or view, the result is ambiguous. This change fixes the rule-dumping code to insert manufactured table and column aliases when needed to preserve the original semantics.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/061", "db_id": "8663efad86a567467f638870969d6371", "patch_ids": [], "statement_hash": "83849c999584d906121a590fc0d2287fc770149f1d83d0a8e487817dff08b33c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-8b6fe5f02809d53c", "migration": false}, {"id": "9.3.0-977c90deb6f30398", "cves": [], "html": "Increase the maximum size of large objects from 2GB to 4TB (Nozomi Anzai, Yugo Nagata)
\nThis change includes adding 64-bit-capable large object access functions, both in the server and in libpq.
", "text": "Increase the maximum size of large objects from 2GB to 4TB (Nozomi Anzai, Yugo Nagata) This change includes adding 64-bit-capable large object access functions, both in the server and in libpq.", "title": "Increase the maximum size of large objects from 2GB to 4TB", "commits": [], "section": "Data Types", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119478", "source_hash": "6e8dfc3df952c0494264b73ff10d05e4b3b580a50aaa5439d2d44d9b15928f7a", "section_path": ["Data Types"], "commit_groups": [], "identity_text": "Increase the maximum size of large objects from 2GB to 4TB (Nozomi Anzai, Yugo Nagata) This change includes adding 64-bit-capable large object access functions, both in the server and in libpq.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/062", "db_id": "e391d7c1a3ee25c4b357f883ef3e6f86", "patch_ids": [], "statement_hash": "9967e0fe855cab6ac2845910c9619fa9612136e85c84cfb565b42efafddeac55", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-977c90deb6f30398", "migration": false}, {"id": "9.3.0-806e778c6c79e656", "cves": [], "html": "Allow text timezone designations, e.g. \"America/Chicago\", in the \"T\" field of ISO-format timestamptz input (Bruce Momjian)
", "text": "Allow text timezone designations, e.g. \"America/Chicago\", in the \"T\" field of ISO-format timestamptz input (Bruce Momjian)", "title": "Allow text timezone designations, e.g. \"America/Chicago\", in the \"T\" field of ISO-format timestamptz input", "commits": [], "section": "Data Types", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119478", "source_hash": "ee0eaba874b277a4e304535664c7a2928836ed06e8eea036c8a078bab741106d", "section_path": ["Data Types"], "commit_groups": [], "identity_text": "Allow text timezone designations, e.g. America/Chicago, in the T field of ISO-format timestamptz input (Bruce Momjian)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/063", "db_id": "10a95bccb4a8110bf5098d2f2a8e11f3", "patch_ids": [], "statement_hash": "2974905cbc442826ee1b3a00434dab3dad57c099a2d5c0183101d781dd862e80", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-806e778c6c79e656", "migration": false}, {"id": "9.3.0-52a3c8c64bb46615", "cves": [], "html": "Add operators and functions to extract elements from JSON values (Andrew Dunstan)
", "text": "Add operators and functions to extract elements from JSON values (Andrew Dunstan)", "title": "Add operators and functions to extract elements from JSON values", "commits": [], "section": "Data Types / JSON", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119492", "source_hash": "e157e91bf1bcc3b7d77bdb4c128bea4dd6ff0118e4cbf816aa520364f8fffab3", "section_path": ["Data Types", "JSON"], "commit_groups": [], "identity_text": "Add operators and functions to extract elements from JSON values (Andrew Dunstan)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/064", "db_id": "371651fe9e417e3b6135c55b566cca2d", "patch_ids": [], "statement_hash": "f4f69ca127fd649cae9a780b24fda89e0284a9a55d456139e0da4c5cc39e3355", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-52a3c8c64bb46615", "migration": false}, {"id": "9.3.0-75fdcbf0f85bedeb", "cves": [], "html": "Allow JSON values to be converted into records (Andrew Dunstan)
", "text": "Allow JSON values to be converted into records (Andrew Dunstan)", "title": "Allow JSON values to be converted into records", "commits": [], "section": "Data Types / JSON", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119492", "source_hash": "8e2e0000985f17b0c0ba34ac32bfeeed1fa99027c1144e58b000f5ad0198b61f", "section_path": ["Data Types", "JSON"], "commit_groups": [], "identity_text": "Allow JSON values to be converted into records (Andrew Dunstan)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/065", "db_id": "1715c11d45895929118f8d5cd50ce995", "patch_ids": [], "statement_hash": "12f7c235503d12a3c50259b8aaa29d278b7b4d348206caa6af1bca0ab17d624d", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-75fdcbf0f85bedeb", "migration": false}, {"id": "9.3.0-7b9e17429a02c7d6", "cves": [], "html": "Add functions to convert scalars, records, and hstore values to JSON (Andrew Dunstan)
", "text": "Add functions to convert scalars, records, and hstore values to JSON (Andrew Dunstan)", "title": "Add functions to convert scalars, records, and hstore values to JSON", "commits": [], "section": "Data Types / JSON", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119492", "source_hash": "e7eb4cbf70f52025c5448af7b8eb3d41486df30e9132ef386f359ec877ebee2a", "section_path": ["Data Types", "JSON"], "commit_groups": [], "identity_text": "Add functions to convert scalars, records, and hstore values to JSON (Andrew Dunstan)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/066", "db_id": "1df8dc8f65b2ca63d915d5ea68a24eaa", "patch_ids": [], "statement_hash": "42095cdc395dbd5351c84207df778be8e5ebcc6b8934ade333cc3b43ee9d18de", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-7b9e17429a02c7d6", "migration": false}, {"id": "9.3.0-27f279c7533a19dc", "cves": [], "html": "Add array_remove() and array_replace() functions (Marco Nenciarini, Gabriele Bartolini)
Allow concat() and format() to properly expand VARIADIC-labeled arguments (Pavel Stehule)
Improve format() to provide field width and left/right alignment options (Pavel Stehule)
Make to_char(), to_date(), and to_timestamp() handle negative (BC) century values properly (Bruce Momjian)
Previously the behavior was either wrong or inconsistent with positive/AD handling, e.g. with the format mask \"IYYY-IW-DY\".
", "text": "Make to_char(), to_date(), and to_timestamp() handle negative (BC) century values properly (Bruce Momjian) Previously the behavior was either wrong or inconsistent with positive/AD handling, e.g. with the format mask \"IYYY-IW-DY\".", "title": "Make to_char(), to_date(), and to_timestamp() handle negative (BC) century values properly", "commits": [], "section": "Functions", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119510", "source_hash": "61066378b449688481e6d4759c0747aa85c467ef005407797ac59747af194415", "section_path": ["Functions"], "commit_groups": [], "identity_text": "Make to_char(), to_date(), and to_timestamp() handle negative (BC) century values properly (Bruce Momjian) Previously the behavior was either wrong or inconsistent with positive/AD handling, e.g. with the format mask IYYY-IW-DY.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/070", "db_id": "976b783cf4da04b5f2b322a29d0e88df", "patch_ids": [], "statement_hash": "cf9be287a54f17366ac246040588c54df35f2acb618d017fb4cf232e1f7440bb", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-027ba32cb8eeabd1", "migration": false}, {"id": "9.3.0-dad5095ce200f5b8", "cves": [], "html": "Make to_date() and to_timestamp() return proper results when mixing ISO and Gregorian week/day designations (Bruce Momjian)
Cause pg_get_viewdef() to start a new line by default after each SELECT target list entry and FROM entry (Marko Tiikkaja)
This reduces line length in view printing, for instance in pg_dump output.
", "text": "Cause pg_get_viewdef() to start a new line by default after each SELECT target list entry and FROM entry (Marko Tiikkaja) This reduces line length in view printing, for instance in pg_dump output.", "title": "Cause pg_get_viewdef() to start a new line by default after each SELECT target list entry and FROM entry", "commits": [], "section": "Functions", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119510", "source_hash": "b625d54e2269f65b5b513adba4dcd869d020e434c0a1fd0bef56f35bd49ed46f", "section_path": ["Functions"], "commit_groups": [], "identity_text": "Cause pg_get_viewdef() to start a new line by default after each SELECT target list entry and FROM entry (Marko Tiikkaja) This reduces line length in view printing, for instance in pg_dump output.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/072", "db_id": "9c4d35594b62636266335a32d37a08d3", "patch_ids": [], "statement_hash": "51e9f2ea0b4cc1ce4b9a345de21897cf3eb11abb9a64b5ee16f8f4b36fcadaf3", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-cb0bf4dd54cfb0b5", "migration": false}, {"id": "9.3.0-1b2ff974d03194fb", "cves": [], "html": "Fix map_sql_value_to_xml_value() to print values of domain types the same way their base type would be printed (Pavel Stehule)
There are special formatting rules for certain built-in types such as boolean; these rules now also apply to domains over these types.
", "text": "Fix map_sql_value_to_xml_value() to print values of domain types the same way their base type would be printed (Pavel Stehule) There are special formatting rules for certain built-in types such as boolean; these rules now also apply to domains over these types.", "title": "Fix map_sql_value_to_xml_value() to print values of domain types the same way their base type would be printed", "commits": [], "section": "Functions", "category": "bugfix", "source_url": "/docs/release/9.3.0/#AEN119510", "source_hash": "7cc150fa3062a1e7d7e232111007ae33a0c7c97c05fd7f9ed177927d0d8d59ef", "section_path": ["Functions"], "commit_groups": [], "identity_text": "Fix map_sql_value_to_xml_value() to print values of domain types the same way their base type would be printed (Pavel Stehule) There are special formatting rules for certain built-in types such as boolean; these rules now also apply to domains over these types.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/073", "db_id": "91ad75eb3ec78c9b4e91dcc1ff1d8df5", "patch_ids": [], "statement_hash": "2e03765ba3641d8a86e85af4cd08c12649bb0ed41aa5e2f6804d0eaaf4cc4f7e", "relations": [], "category_label": "Bug fixes", "url": "/docs/compare/?release=9.3.0#9.3.0-1b2ff974d03194fb", "migration": false}, {"id": "9.3.0-59fc9520ee7ed1c1", "cves": [], "html": "Allow PL/pgSQL to use RETURN with a composite-type expression (Asif Rehman)
\nPreviously, in a function returning a composite type, RETURN could only reference a variable of that type.
", "text": "Allow PL/pgSQL to use RETURN with a composite-type expression (Asif Rehman) Previously, in a function returning a composite type, RETURN could only reference a variable of that type.", "title": "Allow PL/pgSQL to use RETURN with a composite-type expression", "commits": [], "section": "Server-Side Languages / PL/pgSQL Server-Side Language", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119564", "source_hash": "2a7efef6b0ae5c01d60bc8389d9018d7903fa2b07d187f5ce602beb7e6c8f728", "section_path": ["Server-Side Languages", "PL/pgSQL Server-Side Language"], "commit_groups": [], "identity_text": "Allow PL/pgSQL to use RETURN with a composite-type expression (Asif Rehman) Previously, in a function returning a composite type, RETURN could only reference a variable of that type.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/074", "db_id": "46d9728f1961702b218f926c02532b8c", "patch_ids": [], "statement_hash": "2a6bac16948a009293da81af82126ad1a61e877070c886845d9409186149e2dd", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-59fc9520ee7ed1c1", "migration": false}, {"id": "9.3.0-347f7fd98f2b7557", "cves": [], "html": "Allow PL/pgSQL to access constraint violation details as separate fields (Pavel Stehule)
", "text": "Allow PL/pgSQL to access constraint violation details as separate fields (Pavel Stehule)", "title": "Allow PL/pgSQL to access constraint violation details as separate fields", "commits": [], "section": "Server-Side Languages / PL/pgSQL Server-Side Language", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119564", "source_hash": "266c1d8a604ca555d999b268f12cd7d09a99194d84459133fc55ffe67b065bd4", "section_path": ["Server-Side Languages", "PL/pgSQL Server-Side Language"], "commit_groups": [], "identity_text": "Allow PL/pgSQL to access constraint violation details as separate fields (Pavel Stehule)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/075", "db_id": "22e885cae698d174c8f842744f97bcf9", "patch_ids": [], "statement_hash": "d706c248996c301350afcc7539acbbb5d41621561f4bd1c48c2db06d26300cf5", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-347f7fd98f2b7557", "migration": false}, {"id": "9.3.0-e563ce74faa259fa", "cves": [], "html": "Allow PL/pgSQL to access the number of rows processed by COPY (Pavel Stehule)
\nA COPY executed in a PL/pgSQL function now updates the value retrieved by GET DIAGNOSTICS x = ROW_COUNT.
", "text": "Allow PL/pgSQL to access the number of rows processed by COPY (Pavel Stehule) A COPY executed in a PL/pgSQL function now updates the value retrieved by GET DIAGNOSTICS x = ROW_COUNT.", "title": "Allow PL/pgSQL to access the number of rows processed by COPY", "commits": [], "section": "Server-Side Languages / PL/pgSQL Server-Side Language", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119564", "source_hash": "a58905d7dab8701d0a4500b921d20cefa63a5982148b42a5d8b288bf0d59e00f", "section_path": ["Server-Side Languages", "PL/pgSQL Server-Side Language"], "commit_groups": [], "identity_text": "Allow PL/pgSQL to access the number of rows processed by COPY (Pavel Stehule) A COPY executed in a PL/pgSQL function now updates the value retrieved by GET DIAGNOSTICS x = ROW_COUNT.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/076", "db_id": "2ca40ca3d3ea2af191bdb9972d2f1905", "patch_ids": [], "statement_hash": "bb7993378f3a10bbdfc3e7eb392de348f86bc76a0c812b9d32124cb1e2c5d435", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-e563ce74faa259fa", "migration": false}, {"id": "9.3.0-626c6fb0590833e3", "cves": [], "html": "Allow unreserved keywords to be used as identifiers everywhere in PL/pgSQL (Tom Lane)
\nIn certain places in the PL/pgSQL grammar, keywords had to be quoted to be used as identifiers, even if they were nominally unreserved.
", "text": "Allow unreserved keywords to be used as identifiers everywhere in PL/pgSQL (Tom Lane) In certain places in the PL/pgSQL grammar, keywords had to be quoted to be used as identifiers, even if they were nominally unreserved.", "title": "Allow unreserved keywords to be used as identifiers everywhere in PL/pgSQL", "commits": [], "section": "Server-Side Languages / PL/pgSQL Server-Side Language", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119564", "source_hash": "73dd87451def36e20cf6125ab8db433fbf6c5225db17974a3ff1a14415cdce8d", "section_path": ["Server-Side Languages", "PL/pgSQL Server-Side Language"], "commit_groups": [], "identity_text": "Allow unreserved keywords to be used as identifiers everywhere in PL/pgSQL (Tom Lane) In certain places in the PL/pgSQL grammar, keywords had to be quoted to be used as identifiers, even if they were nominally unreserved.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/077", "db_id": "752feefb6ee7fe81b4f9f295dead0656", "patch_ids": [], "statement_hash": "6d8b16c7f9bbbfa0ec6fd079c0d7359e5112e6a37fcfc0981412305ade2f0f21", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-626c6fb0590833e3", "migration": false}, {"id": "9.3.0-16f6787714b1b6a4", "cves": [], "html": "Add PL/Python result object string handler (Peter Eisentraut)
\nThis allows plpy.debug(rv) to output something reasonable.
", "text": "Add PL/Python result object string handler (Peter Eisentraut) This allows plpy.debug(rv) to output something reasonable.", "title": "Add PL/Python result object string handler", "commits": [], "section": "Server-Side Languages / PL/Python Server-Side Language", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119587", "source_hash": "aab0c1653c0b815e3cadeff14eee1bb0081aad5805082aea6ff17685c7927ac7", "section_path": ["Server-Side Languages", "PL/Python Server-Side Language"], "commit_groups": [], "identity_text": "Add PL/Python result object string handler (Peter Eisentraut) This allows plpy.debug(rv) to output something reasonable.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/078", "db_id": "22821db25015b14593f57a6eb15b6ca9", "patch_ids": [], "statement_hash": "0facfdae13221763cc075da58e83ee1560034ecb7a396b47b992aba3b70cbff1", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-16f6787714b1b6a4", "migration": false}, {"id": "9.3.0-205417cd34dde954", "cves": [], "html": "Make PL/Python convert OID values to a proper Python numeric type (Peter Eisentraut)
", "text": "Make PL/Python convert OID values to a proper Python numeric type (Peter Eisentraut)", "title": "Make PL/Python convert OID values to a proper Python numeric type", "commits": [], "section": "Server-Side Languages / PL/Python Server-Side Language", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119587", "source_hash": "e9fc4941d7c64fbfc9001692f09fd98318ac61aa999aced165cde6d2c7a2512e", "section_path": ["Server-Side Languages", "PL/Python Server-Side Language"], "commit_groups": [], "identity_text": "Make PL/Python convert OID values to a proper Python numeric type (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/079", "db_id": "88b4b8afe7279bd20edaa52baed9f60c", "patch_ids": [], "statement_hash": "08de7411404a54ad775824109e2319164b49ad286dd32d94ae8847cabf260549", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-205417cd34dde954", "migration": false}, {"id": "9.3.0-7ecd323ba4090672", "cves": [], "html": "Handle SPI errors raised explicitly (with PL/Python's RAISE) the same as internal SPI errors (Oskari Saarenmaa and Jan Urbanski)
", "text": "Handle SPI errors raised explicitly (with PL/Python's RAISE) the same as internal SPI errors (Oskari Saarenmaa and Jan Urbanski)", "title": "Handle SPI errors raised explicitly (with PL/Python's RAISE) the same as internal SPI errors", "commits": [], "section": "Server-Side Languages / PL/Python Server-Side Language", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119587", "source_hash": "b5e3d6be5008cd7093508414faee1e690593e4b7d98ccb126cc44bb159eeac66", "section_path": ["Server-Side Languages", "PL/Python Server-Side Language"], "commit_groups": [], "identity_text": "Handle SPI errors raised explicitly (with PL/Python's RAISE) the same as internal SPI errors (Oskari Saarenmaa and Jan Urbanski)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/080", "db_id": "0fd2357619cb79c3f1e38e5da9527475", "patch_ids": [], "statement_hash": "46f6db81e00d9f3d0c8ec124b47c3d2c6f19fc57d202c75361dc039959027fd6", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-7ecd323ba4090672", "migration": false}, {"id": "9.3.0-80260b7955a6dac1", "cves": [], "html": "Prevent leakage of SPI tuple tables during subtransaction abort (Tom Lane)
\nAt the end of any failed subtransaction, the core SPI code now releases any SPI tuple tables that were created during that subtransaction. This avoids the need for SPI-using code to keep track of such tuple tables and release them manually in error-recovery code. Failure to do so caused a number of transaction-lifespan memory leakage issues in PL/pgSQL and perhaps other SPI clients. SPI_freetuptable() now protects itself against multiple freeing requests, so any existing code that did take care to clean up shouldn't be broken by this change.
Allow SPI functions to access the number of rows processed by COPY (Pavel Stehule)
", "text": "Allow SPI functions to access the number of rows processed by COPY (Pavel Stehule)", "title": "Allow SPI functions to access the number of rows processed by COPY", "commits": [], "section": "Server Programming Interface (SPI)", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119603", "source_hash": "a3c20d0d492f619f7e3cd0f357b1ee1d3eb1e29a8c24462af16f0509f9d59799", "section_path": ["Server Programming Interface (SPI)"], "commit_groups": [], "identity_text": "Allow SPI functions to access the number of rows processed by COPY (Pavel Stehule)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/082", "db_id": "ee5a8b812d355d132b6d03ee02c46896", "patch_ids": [], "statement_hash": "0cc3e84330d2f4fabc98830c303b949e8fd4d4a75e2d4fc124632b781a7eab00", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-de05666ccac2db0c", "migration": false}, {"id": "9.3.0-154c3ece4c269b04", "cves": [], "html": "Add command-line utility pg_isready to check if the server is ready to accept connections (Phil Sorber)
", "text": "Add command-line utility pg_isready to check if the server is ready to accept connections (Phil Sorber)", "title": "Add command-line utility pg_isready to check if the server is ready to accept connections", "commits": [], "section": "Client Applications", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119618", "source_hash": "665cb88c66e3a9fc491a6708920fb7633c312d96ddb821abc1572909219371ff", "section_path": ["Client Applications"], "commit_groups": [], "identity_text": "Add command-line utility pg_isready to check if the server is ready to accept connections (Phil Sorber)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/083", "db_id": "0eaf4c0c000afd7bc6fbf74f53c07eec", "patch_ids": [], "statement_hash": "d32b5cacd924e81e06628af61d9bf825d0fec4e41f86e978c18c129cc134a2b8", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-154c3ece4c269b04", "migration": false}, {"id": "9.3.0-a491365cb5ab44f4", "cves": [], "html": "Support multiple --table arguments for pg_restore, clusterdb, reindexdb, and vacuumdb (Josh Kupershmidt)
\nThis is similar to the way pg_dump's --table option works.
", "text": "Support multiple --table arguments for pg_restore, clusterdb, reindexdb, and vacuumdb (Josh Kupershmidt) This is similar to the way pg_dump's --table option works.", "title": "Support multiple --table arguments for pg_restore, clusterdb, reindexdb, and vacuumdb", "commits": [], "section": "Client Applications", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119618", "source_hash": "2fa5f98804084b9866d50550379de52a049c262717fd48c264ac2f01715b6afb", "section_path": ["Client Applications"], "commit_groups": [], "identity_text": "Support multiple --table arguments for pg_restore, clusterdb, reindexdb, and vacuumdb (Josh Kupershmidt) This is similar to the way pg_dump's --table option works.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/084", "db_id": "f67e5b8d705de4fe7e6618ee9b5debba", "patch_ids": [], "statement_hash": "90488e5f2e0a6d89ed13e8155905a813feada26f0d4967c1cf6d6c073a200406", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-a491365cb5ab44f4", "migration": false}, {"id": "9.3.0-b808701fbf6c610b", "cves": [], "html": "Add --dbname option to pg_dumpall, pg_basebackup, and pg_receivexlog to allow specifying a connection string (Amit Kapila)
", "text": "Add --dbname option to pg_dumpall, pg_basebackup, and pg_receivexlog to allow specifying a connection string (Amit Kapila)", "title": "Add --dbname option to pg_dumpall, pg_basebackup, and pg_receivexlog to allow specifying a connection string", "commits": [], "section": "Client Applications", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119618", "source_hash": "b878402ba1058c50c6c34c3378a2579bd19d581bf7a8b772d07cdfd7d5a5015c", "section_path": ["Client Applications"], "commit_groups": [], "identity_text": "Add --dbname option to pg_dumpall, pg_basebackup, and pg_receivexlog to allow specifying a connection string (Amit Kapila)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/085", "db_id": "3bdfe55366322449751f85d2f9ceb4df", "patch_ids": [], "statement_hash": "2a46a8a7cc9be24699dc1e1a251c1a88611695ea27d47434b6ac79f523124d70", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-b808701fbf6c610b", "migration": false}, {"id": "9.3.0-3340d05be462737c", "cves": [], "html": "Add libpq function PQconninfo() to return connection information (Zolt\u00e1n B\u00f6sz\u00f6rm\u00e9nyi, Magnus Hagander)
Adjust function cost settings so psql tab completion and pattern searching are more efficient (Tom Lane)
", "text": "Adjust function cost settings so psql tab completion and pattern searching are more efficient (Tom Lane)", "title": "Adjust function cost settings so psql tab completion and pattern searching are more efficient", "commits": [], "section": "Client Applications / psql", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119653", "source_hash": "0b657245ee3ff195e8c11dd69930a33040b7788dc2b70c50365d79fec254bdbf", "section_path": ["Client Applications", "psql"], "commit_groups": [], "identity_text": "Adjust function cost settings so psql tab completion and pattern searching are more efficient (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/087", "db_id": "7f1d6d10439cba73a339bc9724284b7a", "patch_ids": [], "statement_hash": "adbf15a8614dad476bc94edae7d5e4a9120ec65c28d26cf3325ca7a66041ae4c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-6ba4651d37be22fa", "migration": false}, {"id": "9.3.0-8e3897afd60067ac", "cves": [], "html": "Improve psql's tab completion coverage (Jeff Janes, Dean Rasheed, Peter Eisentraut, Magnus Hagander)
", "text": "Improve psql's tab completion coverage (Jeff Janes, Dean Rasheed, Peter Eisentraut, Magnus Hagander)", "title": "Improve psql's tab completion coverage", "commits": [], "section": "Client Applications / psql", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119653", "source_hash": "698c98e9b2496778817310f71ba082ad4cc0a1acde7da5b1509ed1cd4500ce59", "section_path": ["Client Applications", "psql"], "commit_groups": [], "identity_text": "Improve psql's tab completion coverage (Jeff Janes, Dean Rasheed, Peter Eisentraut, Magnus Hagander)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/088", "db_id": "c4498ee92931005eb23c899f5840be14", "patch_ids": [], "statement_hash": "efc5b8eec417d2d8c9905969160193614174a02bcc1968da90f7531c79e379e6", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-8e3897afd60067ac", "migration": false}, {"id": "9.3.0-97a5040be0dc84d5", "cves": [], "html": "Allow the psql --single-transaction mode to work when reading from standard input (Fabien Coelho, Robert Haas)
\nPreviously this option only worked when reading from a file.
", "text": "Allow the psql --single-transaction mode to work when reading from standard input (Fabien Coelho, Robert Haas) Previously this option only worked when reading from a file.", "title": "Allow the psql --single-transaction mode to work when reading from standard input", "commits": [], "section": "Client Applications / psql", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119653", "source_hash": "de07fe5e430f76ba53fff1c1fba60619b6599f375835f11f469827a5fc5b744c", "section_path": ["Client Applications", "psql"], "commit_groups": [], "identity_text": "Allow the psql --single-transaction mode to work when reading from standard input (Fabien Coelho, Robert Haas) Previously this option only worked when reading from a file.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/089", "db_id": "bceff64103aaa64e2fa46dab44c7cea1", "patch_ids": [], "statement_hash": "55fb8d132ea5fa6ac2aad469c51d279fa8a42151b8fcc159b1bbb9be20c17e28", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-97a5040be0dc84d5", "migration": false}, {"id": "9.3.0-3a9a1a402bfc63bd", "cves": [], "html": "Remove psql warning when connecting to an older server (Peter Eisentraut)
\nA warning is still issued when connecting to a server of a newer major version than psql's.
", "text": "Remove psql warning when connecting to an older server (Peter Eisentraut) A warning is still issued when connecting to a server of a newer major version than psql's.", "title": "Remove psql warning when connecting to an older server", "commits": [], "section": "Client Applications / psql", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119653", "source_hash": "724f2765afb2b19e10291133bee66eb203549dc5107880268d019aada2dc213c", "section_path": ["Client Applications", "psql"], "commit_groups": [], "identity_text": "Remove psql warning when connecting to an older server (Peter Eisentraut) A warning is still issued when connecting to a server of a newer major version than psql's.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/090", "db_id": "b972e9183a669174fc49de85ede6e6a4", "patch_ids": [], "statement_hash": "090d2effcfa78b0992985317d340d9699f3411aa0f73476eccbaf76a54952419", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-3a9a1a402bfc63bd", "migration": false}, {"id": "9.3.0-bae3bfc6218313d9", "cves": [], "html": "Add psql command \\watch to repeatedly execute a SQL command (Will Leinweber)
", "text": "Add psql command \\watch to repeatedly execute a SQL command (Will Leinweber)", "title": "Add psql command \\watch to repeatedly execute a SQL command", "commits": [], "section": "Client Applications / psql / Backslash Commands", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119674", "source_hash": "b0cdcc73b0cd6ad65de0f9ba97b46c27a1c7c65bae5098d04d2a5d7426968391", "section_path": ["Client Applications", "psql", "Backslash Commands"], "commit_groups": [], "identity_text": "Add psql command \\watch to repeatedly execute a SQL command (Will Leinweber)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/091", "db_id": "05a9604f0b27cce96ed9f0fc6dc195f6", "patch_ids": [], "statement_hash": "7b6a8b2b2194864b5dc909029d1ed436067d6ce879cd4448bb568faa34db88a1", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-bae3bfc6218313d9", "migration": false}, {"id": "9.3.0-e6f8f063fc600f81", "cves": [], "html": "Add psql command \\gset to store query results in psql variables (Pavel Stehule)
", "text": "Add psql command \\gset to store query results in psql variables (Pavel Stehule)", "title": "Add psql command \\gset to store query results in psql variables", "commits": [], "section": "Client Applications / psql / Backslash Commands", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119674", "source_hash": "2c94f1f2c722733aa42685df520ef8e59411728f3ee2f46bc23a3abee7c5872c", "section_path": ["Client Applications", "psql", "Backslash Commands"], "commit_groups": [], "identity_text": "Add psql command \\gset to store query results in psql variables (Pavel Stehule)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/092", "db_id": "ce765d07e973c77a95484d5e051218a8", "patch_ids": [], "statement_hash": "e491a2ded259c4044dffbaa657a3e0fc6fb35e31dcc8bacee10fd21773f1ee03", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-e6f8f063fc600f81", "migration": false}, {"id": "9.3.0-7f166cf60266a06e", "cves": [], "html": "Add SSL information to psql's \\conninfo command (Alastair Turner)
", "text": "Add SSL information to psql's \\conninfo command (Alastair Turner)", "title": "Add SSL information to psql's \\conninfo command", "commits": [], "section": "Client Applications / psql / Backslash Commands", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119674", "source_hash": "9c9cc9fac614a768fc0fddbf9722326f1fd689a376d39bbe9e34399d09dfc90e", "section_path": ["Client Applications", "psql", "Backslash Commands"], "commit_groups": [], "identity_text": "Add SSL information to psql's \\conninfo command (Alastair Turner)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/093", "db_id": "89f04e136879c538107e75b78646bed9", "patch_ids": [], "statement_hash": "ac02205911c14f30babb08981d3e6e8d8f00eb71bcefa1f221867d0aaf955944", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-7f166cf60266a06e", "migration": false}, {"id": "9.3.0-21bceb106db95d75", "cves": [], "html": "Add \"Security\" column to psql's \\df+ output (Jon Erdman)
", "text": "Add \"Security\" column to psql's \\df+ output (Jon Erdman)", "title": "Add \"Security\" column to psql's \\df+ output", "commits": [], "section": "Client Applications / psql / Backslash Commands", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119674", "source_hash": "5da3457bcb1da040dc355911d6273b406bc13c5058950efdc4f8e407f5783bfb", "section_path": ["Client Applications", "psql", "Backslash Commands"], "commit_groups": [], "identity_text": "Add Security column to psql's \\df+ output (Jon Erdman)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/094", "db_id": "09e61eb9966718f6d77a596d7e2569d5", "patch_ids": [], "statement_hash": "bcb4063e086b9589c1eb0aef6c76b11eacb3ec1fd0f22a8f579d3073252dc490", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-21bceb106db95d75", "migration": false}, {"id": "9.3.0-f6be5ea013468a55", "cves": [], "html": "Allow psql command \\l to accept a database name pattern (Peter Eisentraut)
", "text": "Allow psql command \\l to accept a database name pattern (Peter Eisentraut)", "title": "Allow psql command \\l to accept a database name pattern", "commits": [], "section": "Client Applications / psql / Backslash Commands", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119674", "source_hash": "362928c74bc154f1b1a25f56d66000f94a4a0b963d81f5ee4635e7bb440ef240", "section_path": ["Client Applications", "psql", "Backslash Commands"], "commit_groups": [], "identity_text": "Allow psql command \\l to accept a database name pattern (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/095", "db_id": "3544a4b572c4576e74172ffff0a9fd56", "patch_ids": [], "statement_hash": "4589ffef1804d48fdef2cf96d24292463d357931fe28a9ca8098fe9e2b3daa50", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-f6be5ea013468a55", "migration": false}, {"id": "9.3.0-693ff3650403e7c5", "cves": [], "html": "In psql, do not allow \\connect to use defaults if there is no active connection (Bruce Momjian)
\nThis might be the case if the server had crashed.
", "text": "In psql, do not allow \\connect to use defaults if there is no active connection (Bruce Momjian) This might be the case if the server had crashed.", "title": "In psql, do not allow \\connect to use defaults if there is no active connection", "commits": [], "section": "Client Applications / psql / Backslash Commands", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119674", "source_hash": "3235c140bd51cb9de896d46da6372ca1ec3d8ee91666757a684332e11a447785", "section_path": ["Client Applications", "psql", "Backslash Commands"], "commit_groups": [], "identity_text": "In psql, do not allow \\connect to use defaults if there is no active connection (Bruce Momjian) This might be the case if the server had crashed.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/096", "db_id": "ee99997bcdfc89860bef46dc2e284751", "patch_ids": [], "statement_hash": "f513f90cd17a83dd78e3d749273e34ca2f871755a6efb31f01b881e2721362e1", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-693ff3650403e7c5", "migration": false}, {"id": "9.3.0-f58e90bca8cd0be6", "cves": [], "html": "Properly reset state after failure of a SQL command executed with psql's \\g file (Tom Lane)
\nPreviously, the output from subsequent SQL commands would unexpectedly continue to go to the same file.
", "text": "Properly reset state after failure of a SQL command executed with psql's \\g file (Tom Lane) Previously, the output from subsequent SQL commands would unexpectedly continue to go to the same file.", "title": "Properly reset state after failure of a SQL command executed with psql's \\g file", "commits": [], "section": "Client Applications / psql / Backslash Commands", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119674", "source_hash": "cae76b8f89273ed809590ccf12a8781a901b8f26e132fd446419e8ccda96c6af", "section_path": ["Client Applications", "psql", "Backslash Commands"], "commit_groups": [], "identity_text": "Properly reset state after failure of a SQL command executed with psql's \\g file (Tom Lane) Previously, the output from subsequent SQL commands would unexpectedly continue to go to the same file.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/097", "db_id": "254b9634511e5feffa03053dcbac2355", "patch_ids": [], "statement_hash": "be6bada342ad42aab684791ee5d149017d89ddd95b84799303c5fcdd7e818eda", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-f58e90bca8cd0be6", "migration": false}, {"id": "9.3.0-4bbd84b140f1ace4", "cves": [], "html": "Add a latex-longtable output format to psql (Bruce Momjian)
\nThis format allows tables to span multiple pages.
", "text": "Add a latex-longtable output format to psql (Bruce Momjian) This format allows tables to span multiple pages.", "title": "Add a latex-longtable output format to psql", "commits": [], "section": "Client Applications / psql / Output", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119712", "source_hash": "1650d6de7309ddb400c0ab3533c73ef834f40f794a165ac1ff99dc29c563d261", "section_path": ["Client Applications", "psql", "Output"], "commit_groups": [], "identity_text": "Add a latex-longtable output format to psql (Bruce Momjian) This format allows tables to span multiple pages.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/098", "db_id": "54a23d53126a7e7d289d25595e1d44d3", "patch_ids": [], "statement_hash": "7b7318ddc99c61345c0f769a585b4672259bf0dc4e2e4d05800d6e14ecc820a0", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-4bbd84b140f1ace4", "migration": false}, {"id": "9.3.0-859a3bc30528d19d", "cves": [], "html": "Add a border=3 output mode to the psql latex format (Bruce Momjian)
", "text": "Add a border=3 output mode to the psql latex format (Bruce Momjian)", "title": "Add a border=3 output mode to the psql latex format", "commits": [], "section": "Client Applications / psql / Output", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119712", "source_hash": "525d331d057921f547367f74ebc8f599bac11d4e30a70cfb9ea550965d43f118", "section_path": ["Client Applications", "psql", "Output"], "commit_groups": [], "identity_text": "Add a border=3 output mode to the psql latex format (Bruce Momjian)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/099", "db_id": "a2dd3f8a953f76d39382c584f53a3a9b", "patch_ids": [], "statement_hash": "30ef9c882df19cf209c28352642a879858ca2abb56984facb5765bb068c7e293", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-859a3bc30528d19d", "migration": false}, {"id": "9.3.0-4ba99630adddc585", "cves": [], "html": "In psql's tuples-only and expanded output modes, no longer emit \"(No rows)\" for zero rows (Peter Eisentraut)
", "text": "In psql's tuples-only and expanded output modes, no longer emit \"(No rows)\" for zero rows (Peter Eisentraut)", "title": "In psql's tuples-only and expanded output modes, no longer emit \"(No rows)\" for zero rows", "commits": [], "section": "Client Applications / psql / Output", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119712", "source_hash": "3e0294ec03dc68974672f0d5327ff757168f6ec1a5a5920fa1f715de1816e7bd", "section_path": ["Client Applications", "psql", "Output"], "commit_groups": [], "identity_text": "In psql's tuples-only and expanded output modes, no longer emit (No rows) for zero rows (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/100", "db_id": "78634e5e7a1c2722854aa973984f508b", "patch_ids": [], "statement_hash": "182e569802367693572ee8543a5834e18f65a6d113db030ca45f217534b4cd10", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-4ba99630adddc585", "migration": false}, {"id": "9.3.0-1b1ed1d4187c47d2", "cves": [], "html": "In psql's unaligned, expanded output mode, no longer print an empty line for zero rows (Peter Eisentraut)
", "text": "In psql's unaligned, expanded output mode, no longer print an empty line for zero rows (Peter Eisentraut)", "title": "In psql's unaligned, expanded output mode, no longer print an empty line for zero rows", "commits": [], "section": "Client Applications / psql / Output", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119712", "source_hash": "b0e3387d0131f114c9727a2259736b1d297f5ce27eb0d1e48ebf7b154dae8df9", "section_path": ["Client Applications", "psql", "Output"], "commit_groups": [], "identity_text": "In psql's unaligned, expanded output mode, no longer print an empty line for zero rows (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/101", "db_id": "38044f06b26ae79bb7f9ed2e100c9661", "patch_ids": [], "statement_hash": "ceea91ace73810989f6d925c620287f3168dd481db429edda13ec7ae89425617", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-1b1ed1d4187c47d2", "migration": false}, {"id": "9.3.0-6de39ec64e321969", "cves": [], "html": "Add pg_dump --jobs option to dump tables in parallel (Joachim Wieland)
", "text": "Add pg_dump --jobs option to dump tables in parallel (Joachim Wieland)", "title": "Add pg_dump --jobs option to dump tables in parallel", "commits": [], "section": "Client Applications / pg_dump", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119732", "source_hash": "579d09df295f9e29c176e2f7ad96a31cc7d4a45472eb153cb354e3d1318bacbb", "section_path": ["Client Applications", "pg_dump"], "commit_groups": [], "identity_text": "Add pg_dump --jobs option to dump tables in parallel (Joachim Wieland)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/102", "db_id": "a42399785ad107b14b049ee68a17d997", "patch_ids": [], "statement_hash": "aedde0d030ccb030a1120a308cb8a722403759f6b58110a8d0e8d4ba7e3320f7", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-6de39ec64e321969", "migration": false}, {"id": "9.3.0-79c96b2846056b3d", "cves": [], "html": "Make pg_dump output functions in a more predictable order (Joel Jacobson)
", "text": "Make pg_dump output functions in a more predictable order (Joel Jacobson)", "title": "Make pg_dump output functions in a more predictable order", "commits": [], "section": "Client Applications / pg_dump", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119732", "source_hash": "adc5c37d661ac88fdfa0e12db290a48be327e8f7494fa517037566311273f56c", "section_path": ["Client Applications", "pg_dump"], "commit_groups": [], "identity_text": "Make pg_dump output functions in a more predictable order (Joel Jacobson)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/103", "db_id": "daba41edd9c698b068616e7115f1031b", "patch_ids": [], "statement_hash": "09ef02eb364e01c43c614be59bcb6956175d53c97dbe3cc9980f01aedb996acd", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-79c96b2846056b3d", "migration": false}, {"id": "9.3.0-e4e6e7172d335867", "cves": [], "html": "Fix tar files emitted by pg_dump to be POSIX conformant (Brian Weaver, Tom Lane)
", "text": "Fix tar files emitted by pg_dump to be POSIX conformant (Brian Weaver, Tom Lane)", "title": "Fix tar files emitted by pg_dump to be POSIX conformant", "commits": [], "section": "Client Applications / pg_dump", "category": "bugfix", "source_url": "/docs/release/9.3.0/#AEN119732", "source_hash": "c15ff84ad85b4a3864062fbda4ad20c47dcf3fec15e8c45d1ad23574dca37cd4", "section_path": ["Client Applications", "pg_dump"], "commit_groups": [], "identity_text": "Fix tar files emitted by pg_dump to be POSIX conformant (Brian Weaver, Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/104", "db_id": "55a73edba422d9342c50ae63c4cbcf2c", "patch_ids": [], "statement_hash": "e5dd8beb187c8ecbbf269546833024f5e52436b905da4631bff86db9330a71e9", "relations": [], "category_label": "Bug fixes", "url": "/docs/compare/?release=9.3.0#9.3.0-e4e6e7172d335867", "migration": false}, {"id": "9.3.0-5c3a6175341103fd", "cves": [], "html": "Add --dbname option to pg_dump, for consistency with other client commands (Heikki Linnakangas)
\nThe database name could already be supplied last without a flag.
", "text": "Add --dbname option to pg_dump, for consistency with other client commands (Heikki Linnakangas) The database name could already be supplied last without a flag.", "title": "Add --dbname option to pg_dump, for consistency with other client commands", "commits": [], "section": "Client Applications / pg_dump", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119732", "source_hash": "8e9def7ed4b1dab8bb15ec05c5fcafe50f7dcbc3f61f5909bf17035c8bea67f9", "section_path": ["Client Applications", "pg_dump"], "commit_groups": [], "identity_text": "Add --dbname option to pg_dump, for consistency with other client commands (Heikki Linnakangas) The database name could already be supplied last without a flag.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/105", "db_id": "52b50aeb95881efa2a30e15b08ba6e36", "patch_ids": [], "statement_hash": "26ec1b4495793205c561dce62f001c7996ec8ec15bb3a64d1f9ff73cc3389293", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-5c3a6175341103fd", "migration": false}, {"id": "9.3.0-b279fb9f97d2207a", "cves": [], "html": "Make initdb fsync the newly created data directory (Jeff Davis)
\nThis insures data integrity in event of a system crash shortly after initdb. This can be disabled by using --nosync.
", "text": "Make initdb fsync the newly created data directory (Jeff Davis) This insures data integrity in event of a system crash shortly after initdb. This can be disabled by using --nosync.", "title": "Make initdb fsync the newly created data directory", "commits": [], "section": "Client Applications / initdb", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119753", "source_hash": "e996854e4d22dd595c3a1ab1dbaf1fc8e67a44d6555110fa18908e05012a0d4c", "section_path": ["Client Applications", "initdb"], "commit_groups": [], "identity_text": "Make initdb fsync the newly created data directory (Jeff Davis) This insures data integrity in event of a system crash shortly after initdb. This can be disabled by using --nosync.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/106", "db_id": "5b6f0be291d107470cbb28f6fe2392f2", "patch_ids": [], "statement_hash": "7103d05619b31582be6ec4ed7e4cf3bf72e9a461f31ec7c27a75ab1be4727af8", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-b279fb9f97d2207a", "migration": false}, {"id": "9.3.0-ee18346cc3d025b7", "cves": [], "html": "Add initdb --sync-only option to sync the data directory to durable storage (Bruce Momjian)
\nThis is used by pg_upgrade.
", "text": "Add initdb --sync-only option to sync the data directory to durable storage (Bruce Momjian) This is used by pg_upgrade.", "title": "Add initdb --sync-only option to sync the data directory to durable storage", "commits": [], "section": "Client Applications / initdb", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119753", "source_hash": "25715ca0a3fe403f25c1a9eaa404e6f81a7c14e6bfe79be68d3feabcbb80c711", "section_path": ["Client Applications", "initdb"], "commit_groups": [], "identity_text": "Add initdb --sync-only option to sync the data directory to durable storage (Bruce Momjian) This is used by pg_upgrade.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/107", "db_id": "88e76dc9a125c741143e45723336dfbb", "patch_ids": [], "statement_hash": "dac6ac87e0ea032633344839cdf4175571960c56288f0fd389f7def7b326ac48", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-ee18346cc3d025b7", "migration": false}, {"id": "9.3.0-ef2d63548296f557", "cves": [], "html": "Make initdb issue a warning about placing the data directory at the top of a file system mount point (Bruce Momjian)
", "text": "Make initdb issue a warning about placing the data directory at the top of a file system mount point (Bruce Momjian)", "title": "Make initdb issue a warning about placing the data directory at the top of a file system mount point", "commits": [], "section": "Client Applications / initdb", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119753", "source_hash": "9abe7e2ef184408443c8271e7a3aa3382081b6a7b86f13d90e31c669304253d0", "section_path": ["Client Applications", "initdb"], "commit_groups": [], "identity_text": "Make initdb issue a warning about placing the data directory at the top of a file system mount point (Bruce Momjian)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/108", "db_id": "bfc213b4174f68d8aed9e6cd9f32e3c0", "patch_ids": [], "statement_hash": "5a11e9251ccb3c031aa57b21751e3aa6dc9225c6955f79df1f64a942accc1e16", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-ef2d63548296f557", "migration": false}, {"id": "9.3.0-2e3ae38b7dc223c1", "cves": [], "html": "Add infrastructure to allow plug-in background worker processes (\u00c1lvaro Herrera)
", "text": "Add infrastructure to allow plug-in background worker processes (\u00c1lvaro Herrera)", "title": "Add infrastructure to allow plug-in background worker processes", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "20b471e3f869109f75f9d784669fcccd79d3fcf82c171c0098a6f916fdbb1236", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Add infrastructure to allow plug-in background worker processes (\u00c1lvaro Herrera)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/109", "db_id": "15792967c5078a24793716531fc12bb6", "patch_ids": [], "statement_hash": "87d27110e2c6765f2a520238a07ef7576f4bc1184be886e99022a85cfe28918f", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-2e3ae38b7dc223c1", "migration": false}, {"id": "9.3.0-832c1b4f9453d096", "cves": [], "html": "Create a centralized timeout API (Zolt\u00e1n B\u00f6sz\u00f6rm\u00e9nyi)
", "text": "Create a centralized timeout API (Zolt\u00e1n B\u00f6sz\u00f6rm\u00e9nyi)", "title": "Create a centralized timeout API", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "885ef14b356fdfb6ba85d33a16e341f8483aed894cdd0229dcd4d6bf3e6e79cb", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Create a centralized timeout API (Zolt\u00e1n B\u00f6sz\u00f6rm\u00e9nyi)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/110", "db_id": "c17e13477600629c5f66bfb06f99f237", "patch_ids": [], "statement_hash": "daeb23df7aff5bd24998904a124a8907155b3fca444aa0e3fc750e0cfa92a815", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-832c1b4f9453d096", "migration": false}, {"id": "9.3.0-893e327c174e7edd", "cves": [], "html": "Create libpgcommon and move pg_malloc() and other functions there (\u00c1lvaro Herrera, Andres Freund)
This allows libpgport to be used solely for portability-related code.
", "text": "Create libpgcommon and move pg_malloc() and other functions there (\u00c1lvaro Herrera, Andres Freund) This allows libpgport to be used solely for portability-related code.", "title": "Create libpgcommon and move pg_malloc() and other functions there", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "53dc57649b12f710c72fd5f9d0f6351573c03cbf9f2a3b86118a6d5f6128d14c", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Create libpgcommon and move pg_malloc() and other functions there (\u00c1lvaro Herrera, Andres Freund) This allows libpgport to be used solely for portability-related code.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/111", "db_id": "ad35de3ae5106e53b546dcf673180acb", "patch_ids": [], "statement_hash": "5807f942987a38b4cadd80ff0198b2cd4de17b9ad60aed56db2394aff91c47dc", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-893e327c174e7edd", "migration": false}, {"id": "9.3.0-4a4afacec340f971", "cves": [], "html": "Add support for list links embedded in larger structs (Andres Freund)
", "text": "Add support for list links embedded in larger structs (Andres Freund)", "title": "Add support for list links embedded in larger structs", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "9abf6fda0503a7aff9733c496181aefe2ba06cca0cbde65bb97f7e692966c041", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Add support for list links embedded in larger structs (Andres Freund)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/112", "db_id": "f905ae0518032770b2f16c035aba5e19", "patch_ids": [], "statement_hash": "732ead2b59b3a818c44cd95910866ac18955dbba80d2c3c9fd438426f3bbfd94", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-4a4afacec340f971", "migration": false}, {"id": "9.3.0-9447bd929fd5c932", "cves": [], "html": "Use SA_RESTART for all signals, including SIGALRM (Tom Lane)
", "text": "Use SA_RESTART for all signals, including SIGALRM (Tom Lane)", "title": "Use SA_RESTART for all signals, including SIGALRM", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "3769bdef27d1fe6368d8764ee1ea5285e59429bad38b29f1fb07d5a3fc0106d0", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Use SA_RESTART for all signals, including SIGALRM (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/113", "db_id": "f89ee143ac169e4b28ddef18746b0c0a", "patch_ids": [], "statement_hash": "b0a4f8bb3843181fd601f3ff7d05d8682908f9d81b43ff1de01d4dd1b40ba029", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-9447bd929fd5c932", "migration": false}, {"id": "9.3.0-6f30212430afb163", "cves": [], "html": "Ensure that the correct text domain is used when translating errcontext() messages (Heikki Linnakangas)
Standardize naming of client-side memory allocation functions (Tom Lane)
", "text": "Standardize naming of client-side memory allocation functions (Tom Lane)", "title": "Standardize naming of client-side memory allocation functions", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "105e64847ee61b8ee0a9f127cfa8b20652fe9edcd3a6133cd3d6ad37c94f5e60", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Standardize naming of client-side memory allocation functions (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/115", "db_id": "b83cec2970c4ce93292fa3c26f8a2140", "patch_ids": [], "statement_hash": "83d5f54f0f499697a51388c3a36f79cdfd54e32a1a8282b4ada26802f6e1f11c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-a05a4feed7bdc024", "migration": false}, {"id": "9.3.0-324f0e3519f92a23", "cves": [], "html": "Provide support for \"static assertions\" that will fail at compile time if some compile-time-constant condition is not met (Andres Freund, Tom Lane)
", "text": "Provide support for \"static assertions\" that will fail at compile time if some compile-time-constant condition is not met (Andres Freund, Tom Lane)", "title": "Provide support for \"static assertions\" that will fail at compile time if some compile-time-constant condition is not met", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "90b36f1b4d5eca6d1ac3b7c5da2afdb2553449057e6da3392f1e8c59554219ec", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Provide support for static assertions that will fail at compile time if some compile-time-constant condition is not met (Andres Freund, Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/116", "db_id": "df55323df9de65cd6cc31903f93ca45b", "patch_ids": [], "statement_hash": "8dfafedcfed4e840bfe9eb2f267d957df5c1d7d30519d2dd539d6019a60fe58a", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-324f0e3519f92a23", "migration": false}, {"id": "9.3.0-b384bc8d792c47ae", "cves": [], "html": "Support Assert() in client-side code (Andrew Dunstan)
Add decoration to inform the C compiler that some ereport() and elog() calls do not return (Peter Eisentraut, Andres Freund, Tom Lane, Heikki Linnakangas)
Allow options to be passed to the regression test output comparison utility via PG_REGRESS_DIFF_OPTS (Peter Eisentraut)
", "text": "Allow options to be passed to the regression test output comparison utility via PG_REGRESS_DIFF_OPTS (Peter Eisentraut)", "title": "Allow options to be passed to the regression test output comparison utility via PG_REGRESS_DIFF_OPTS", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "2edec5e5fa990c87e76d167e6e754f08fca72ff9e5bcbfaacab28ad82e9acbba", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Allow options to be passed to the regression test output comparison utility via PG_REGRESS_DIFF_OPTS (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/119", "db_id": "83f381c938f45fe34d83de449b833080", "patch_ids": [], "statement_hash": "2fd1c726818f0429e9e6a02b37f163c32e28fb9fb2088d7f8f6f07c51e172063", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-bbb37c09f8997dee", "migration": false}, {"id": "9.3.0-be9f458bb2aa1126", "cves": [], "html": "Add isolation tests for CREATE INDEX CONCURRENTLY (Abhijit Menon-Sen)
", "text": "Add isolation tests for CREATE INDEX CONCURRENTLY (Abhijit Menon-Sen)", "title": "Add isolation tests for CREATE INDEX CONCURRENTLY", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "5aa66147163fbadad1b3bf6c167285ce3661fc83a6ffac1fa4766ffebbfce80b", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Add isolation tests for CREATE INDEX CONCURRENTLY (Abhijit Menon-Sen)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/120", "db_id": "4e33870b96b1bd3e3dfae844ca1ed791", "patch_ids": [], "statement_hash": "18932eb4efaaad6987efcbd73aa8ba1639d91534cabd5151e357767c097363e0", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-be9f458bb2aa1126", "migration": false}, {"id": "9.3.0-c9d7eee7a7f28775", "cves": [], "html": "Remove typedefs for int2/int4 as they are better represented as int16/int32 (Peter Eisentraut)
", "text": "Remove typedefs for int2/int4 as they are better represented as int16/int32 (Peter Eisentraut)", "title": "Remove typedefs for int2/int4 as they are better represented as int16/int32", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "df51ca94541a47cb733a2290d35549b4e432a2bc58d94afa157b35b632a700ef", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Remove typedefs for int2/int4 as they are better represented as int16/int32 (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/121", "db_id": "b653629271714bc2e48bf8184efddf0d", "patch_ids": [], "statement_hash": "92afbd7309e8cf287aeecc56083918266329fc5c0f6a7b316d61feb3f196891c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-c9d7eee7a7f28775", "migration": false}, {"id": "9.3.0-e13cfa9c058d0e2b", "cves": [], "html": "Fix install-strip on Mac OS X (Peter Eisentraut)
", "text": "Fix install-strip on Mac OS X (Peter Eisentraut)", "title": "Fix install-strip on Mac OS X", "commits": [], "section": "Source Code", "category": "bugfix", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "4e3c9097253c895c222f0cea537751bb7e50a16fbe64e530f85f25892a8d584f", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Fix install-strip on Mac OS X (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/122", "db_id": "8ca4f1d35bcb2f1e6cf018083deb2a23", "patch_ids": [], "statement_hash": "c0ebb4c836a7ce2ce5bf5484a01f14c968516bd9b340c2594a6b1577383a90ec", "relations": [], "category_label": "Bug fixes", "url": "/docs/compare/?release=9.3.0#9.3.0-e13cfa9c058d0e2b", "migration": false}, {"id": "9.3.0-e3f70fa6821cc424", "cves": [], "html": "Remove configure flag --disable-shared, as it is no longer supported (Bruce Momjian)
", "text": "Remove configure flag --disable-shared, as it is no longer supported (Bruce Momjian)", "title": "Remove configure flag --disable-shared, as it is no longer supported", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "6ca0cde37308617cd03017281f241ccceb353a70ece627ae28a8c97a86a82c7d", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Remove configure flag --disable-shared, as it is no longer supported (Bruce Momjian)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/123", "db_id": "9e560523b95f6aee57a31e492cf36548", "patch_ids": [], "statement_hash": "179353bf32dc936b6ee73776108f807f747ba13633e566da1b2543bcfd3970ab", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-e3f70fa6821cc424", "migration": false}, {"id": "9.3.0-97be7a2681caeb00", "cves": [], "html": "Rewrite pgindent in Perl (Andrew Dunstan)
", "text": "Rewrite pgindent in Perl (Andrew Dunstan)", "title": "Rewrite pgindent in Perl", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "3e7794dc3f5932df7d5317dd0b6147f83a7f4dd75c35e414c61684ad58dd01db", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Rewrite pgindent in Perl (Andrew Dunstan)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/124", "db_id": "92141a325995012bb6b2c89866a0447a", "patch_ids": [], "statement_hash": "5981058d788ae756ec5a907e4eff637426d9a60f8934e9c81df201bb6285483f", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-97be7a2681caeb00", "migration": false}, {"id": "9.3.0-422da138d39b7eae", "cves": [], "html": "Provide Emacs macro to set Perl formatting to match PostgreSQL's perltidy settings (Peter Eisentraut)
", "text": "Provide Emacs macro to set Perl formatting to match PostgreSQL's perltidy settings (Peter Eisentraut)", "title": "Provide Emacs macro to set Perl formatting to match PostgreSQL's perltidy settings", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "2850c5ca24e032601b0da59f9d0c28f89f0a142833d91a191933b281e6451023", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Provide Emacs macro to set Perl formatting to match PostgreSQL's perltidy settings (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/125", "db_id": "e677e52fc1a7e908506f79ac7e10d6f6", "patch_ids": [], "statement_hash": "3bd36a8af0b4c7bea80379fbf80ec56fcddca33acb2c796c4c442419dccbfeae", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-422da138d39b7eae", "migration": false}, {"id": "9.3.0-03143d9bb568a755", "cves": [], "html": "Run tool to check the keyword list whenever the backend grammar is changed (Tom Lane)
", "text": "Run tool to check the keyword list whenever the backend grammar is changed (Tom Lane)", "title": "Run tool to check the keyword list whenever the backend grammar is changed", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "ae87af70a9c53ecc678c43c64218cbd37f658d2582d9b2db4c3c5f341ba201a5", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Run tool to check the keyword list whenever the backend grammar is changed (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/126", "db_id": "c4a4b9351a1c5eaf5adc516c16fd63c8", "patch_ids": [], "statement_hash": "9f795cb87394c92cf37ce7c6ce9c1a7cbc26dd69abc4e3500ebcb63347c27ae9", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-03143d9bb568a755", "migration": false}, {"id": "9.3.0-eec586b1a25d1b67", "cves": [], "html": "Change the way UESCAPE is lexed, to significantly reduce the size of the lexer tables (Heikki Linnakangas)
", "text": "Change the way UESCAPE is lexed, to significantly reduce the size of the lexer tables (Heikki Linnakangas)", "title": "Change the way UESCAPE is lexed, to significantly reduce the size of the lexer tables", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "1c481ffbd2168d096067730a3e276946f951bdeef60b1dcf72ad27bca2a816ce", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Change the way UESCAPE is lexed, to significantly reduce the size of the lexer tables (Heikki Linnakangas)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/127", "db_id": "02054b00b070e027d7f556b59fd85dc1", "patch_ids": [], "statement_hash": "d254d6c7d209fe6ee731a6748d9094dcdadfcfc3387fcf6b69231b89e6a546d9", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-eec586b1a25d1b67", "migration": false}, {"id": "9.3.0-a3ca2d32d6d14b45", "cves": [], "html": "Centralize flex and bison make rules (Peter Eisentraut)
\nThis is useful for pgxs authors.
", "text": "Centralize flex and bison make rules (Peter Eisentraut) This is useful for pgxs authors.", "title": "Centralize flex and bison make rules", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "d1359414a31888776cf9efa89f60ac0e9486e455b79dfc13d713e423d16cb75d", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Centralize flex and bison make rules (Peter Eisentraut) This is useful for pgxs authors.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/128", "db_id": "f81e1b3f1aab4e28d47dfcd56896e1d0", "patch_ids": [], "statement_hash": "d8a16c20e974ccf6734096782f108259fe64b1e16196b79cf90b7ada139c6854", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-a3ca2d32d6d14b45", "migration": false}, {"id": "9.3.0-de1ced4bf2add3d4", "cves": [], "html": "Change many internal backend functions to return object OIDs rather than void (Dimitri Fontaine)
\nThis is useful for event triggers.
", "text": "Change many internal backend functions to return object OIDs rather than void (Dimitri Fontaine) This is useful for event triggers.", "title": "Change many internal backend functions to return object OIDs rather than void", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "ea01f022047f5859ee0229d815b1aba776938d40c8b06aaca207dd59e7585373", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Change many internal backend functions to return object OIDs rather than void (Dimitri Fontaine) This is useful for event triggers.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/129", "db_id": "5def974891c3e1982c34ce528fcda9e3", "patch_ids": [], "statement_hash": "61c83ad93205088d960630e670aec2f6bfe037656be079ca4d1fe2d191ff5ca7", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-de1ced4bf2add3d4", "migration": false}, {"id": "9.3.0-b0f873ef623b740c", "cves": [], "html": "Invent pre-commit/pre-prepare/pre-subcommit events for transaction callbacks (Tom Lane)
\nLoadable modules that use transaction callbacks might need modification to handle these new event types.
", "text": "Invent pre-commit/pre-prepare/pre-subcommit events for transaction callbacks (Tom Lane) Loadable modules that use transaction callbacks might need modification to handle these new event types.", "title": "Invent pre-commit/pre-prepare/pre-subcommit events for transaction callbacks", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "4441bc1f30e19e9f79730ca342d3965c9625af8abe655842812b5508819c55bf", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Invent pre-commit/pre-prepare/pre-subcommit events for transaction callbacks (Tom Lane) Loadable modules that use transaction callbacks might need modification to handle these new event types.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/130", "db_id": "6777a1a397ca02def1ccbe554dd2a8ac", "patch_ids": [], "statement_hash": "678c392511b74a3e2f3b8e126c95675972c749439eb365ac65a73cc84fbb0c4e", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-b0f873ef623b740c", "migration": false}, {"id": "9.3.0-c05503d3510751ad", "cves": [], "html": "Add function pg_identify_object() to produce a machine-readable description of a database object (\u00c1lvaro Herrera)
Add post-ALTER-object server hooks (KaiGai Kohei)
", "text": "Add post-ALTER-object server hooks (KaiGai Kohei)", "title": "Add post-ALTER-object server hooks", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "8513ea0de91ad58aa831f33821f438aef99ee83204a13e550604a4422719a52b", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Add post-ALTER-object server hooks (KaiGai Kohei)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/132", "db_id": "dc0aa4482c0c4659bd882978d034d328", "patch_ids": [], "statement_hash": "37856b64390a1532711dc2f563bf3380b5e93e2b669616754178c061c6e7b91c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-e7442b805073c199", "migration": false}, {"id": "9.3.0-50e5fbc3abd36be3", "cves": [], "html": "Implement a generic binary heap and use it for Merge-Append operations (Abhijit Menon-Sen)
", "text": "Implement a generic binary heap and use it for Merge-Append operations (Abhijit Menon-Sen)", "title": "Implement a generic binary heap and use it for Merge-Append operations", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "1d6d03a30513e32e63e2de8193edbb4a4ed419422fe11f3f064211e6b6a71d0d", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Implement a generic binary heap and use it for Merge-Append operations (Abhijit Menon-Sen)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/133", "db_id": "06df031509a06126c04d24b868c70da0", "patch_ids": [], "statement_hash": "4ca603884d2e33833ff64d35a15cc4aa7a845f63703f953d2fd70b7c806ba748", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-50e5fbc3abd36be3", "migration": false}, {"id": "9.3.0-d6ff951ee1322148", "cves": [], "html": "Provide a tool to help detect timezone abbreviation changes when updating the src/timezone/data files (Tom Lane)
", "text": "Provide a tool to help detect timezone abbreviation changes when updating the src/timezone/data files (Tom Lane)", "title": "Provide a tool to help detect timezone abbreviation changes when updating the src/timezone/data files", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "e0cfbcde2912ed466d7a44236308e9cf8eb46632c0f56956ae047799c569543b", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Provide a tool to help detect timezone abbreviation changes when updating the src/timezone/data files (Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/134", "db_id": "f954c03e7d8f4dafecf255114afa2482", "patch_ids": [], "statement_hash": "cf24b46fccbbf8b0b543bd313dd9502696dab35d2e94e5037fedf41fcc74e953", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-d6ff951ee1322148", "migration": false}, {"id": "9.3.0-c5ede161e7cad4ea", "cves": [], "html": "Add pkg-config support for libpq and ecpg libraries (Peter Eisentraut)
", "text": "Add pkg-config support for libpq and ecpg libraries (Peter Eisentraut)", "title": "Add pkg-config support for libpq and ecpg libraries", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "07e02090813b6273234325cc387d7d6fc419c4adf890d3792b494139c1173fb5", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Add pkg-config support for libpq and ecpg libraries (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/135", "db_id": "673e2f6b9adef239dbac41052c94427a", "patch_ids": [], "statement_hash": "3f8db7fdd96efdf86c20b3f53d4457a733b557ae7a92e2e7ecb5b0f5c12c3538", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-c5ede161e7cad4ea", "migration": false}, {"id": "9.3.0-c9c4d38e4e887cde", "cves": [], "html": "Remove src/tools/backend, now that the content is on the PostgreSQL wiki (Bruce Momjian)
", "text": "Remove src/tools/backend, now that the content is on the PostgreSQL wiki (Bruce Momjian)", "title": "Remove src/tools/backend, now that the content is on the PostgreSQL wiki", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "189f9645495d7fb0b9f592f2d1ea387dd59f08d0c399d3d79e0f87deb85c39c3", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Remove src/tools/backend, now that the content is on the PostgreSQL wiki (Bruce Momjian)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/136", "db_id": "2b6b2ee7b339653ab18c4441840b2636", "patch_ids": [], "statement_hash": "583c694386f630201fd92475c558dacd5982f77968cf7e6d0e74930d0c41f833", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-c9c4d38e4e887cde", "migration": false}, {"id": "9.3.0-6e113356b89c3a37", "cves": [], "html": "Split out WAL reading as an independent facility (Heikki Linnakangas, Andres Freund)
", "text": "Split out WAL reading as an independent facility (Heikki Linnakangas, Andres Freund)", "title": "Split out WAL reading as an independent facility", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "68361866a465ea70a347ded4858871dc33d527e4ad4066a76496a8153ea849e5", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Split out WAL reading as an independent facility (Heikki Linnakangas, Andres Freund)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/137", "db_id": "4c1a290968c5bb9dc7ffe021d6af71eb", "patch_ids": [], "statement_hash": "a194bf6952e457db6ad96fe33beb219edf3a4a74748aaeaa104a8d136b092a24", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-6e113356b89c3a37", "migration": false}, {"id": "9.3.0-386d2153bce847a7", "cves": [], "html": "Use a 64-bit integer to represent WAL positions (XLogRecPtr) instead of two 32-bit integers (Heikki Linnakangas)
\nGenerally, tools that need to read the WAL format will need to be adjusted.
", "text": "Use a 64-bit integer to represent WAL positions (XLogRecPtr) instead of two 32-bit integers (Heikki Linnakangas) Generally, tools that need to read the WAL format will need to be adjusted.", "title": "Use a 64-bit integer to represent WAL positions (XLogRecPtr) instead of two 32-bit integers", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "f00835ef9de9258d970dcedb6b4dceffe45bcd71a4ab1a436881e7e8daceb3d2", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Use a 64-bit integer to represent WAL positions (XLogRecPtr) instead of two 32-bit integers (Heikki Linnakangas) Generally, tools that need to read the WAL format will need to be adjusted.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/138", "db_id": "78f2fe55283d235965df7cd32822c2ae", "patch_ids": [], "statement_hash": "db8725a77388b2ef197261c9c7327f0ffdc7d66e871f3bf4fe5634e88f9e0b9c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-386d2153bce847a7", "migration": false}, {"id": "9.3.0-0aad605d820228ec", "cves": [], "html": "Allow PL/Python to support platform-specific include directories (Peter Eisentraut)
", "text": "Allow PL/Python to support platform-specific include directories (Peter Eisentraut)", "title": "Allow PL/Python to support platform-specific include directories", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "6ea85385766da3bade3b844e5f1dba869f71d187eafc410309239f01645dd3b9", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Allow PL/Python to support platform-specific include directories (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/139", "db_id": "b50af788b353207fed0675bcdf73334b", "patch_ids": [], "statement_hash": "03490685044308dde55518c5c727fb5841970b40ae38c1d1e3396fa37051b5ad", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-0aad605d820228ec", "migration": false}, {"id": "9.3.0-349562d873229f0b", "cves": [], "html": "Allow PL/Python on OS X to build against custom versions of Python (Peter Eisentraut)
", "text": "Allow PL/Python on OS X to build against custom versions of Python (Peter Eisentraut)", "title": "Allow PL/Python on OS X to build against custom versions of Python", "commits": [], "section": "Source Code", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119770", "source_hash": "a8e4bb10123d388b79b530726fc3385e75ba94ebf0eb7f4a4b361d2ea8f1a9e8", "section_path": ["Source Code"], "commit_groups": [], "identity_text": "Allow PL/Python on OS X to build against custom versions of Python (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/140", "db_id": "c6d17fea9073c5b731fa8a75d34071a5", "patch_ids": [], "statement_hash": "cdb150840ffaf6a4b433b84f07328ecc314f30c1b191dc3157a26090a071ca82", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-349562d873229f0b", "migration": false}, {"id": "9.3.0-58b80bc370b2123d", "cves": [], "html": "Add a Postgres foreign data wrapper contrib module to allow access to other Postgres servers (Shigeru Hanada)
\nThis foreign data wrapper supports writes.
", "text": "Add a Postgres foreign data wrapper contrib module to allow access to other Postgres servers (Shigeru Hanada) This foreign data wrapper supports writes.", "title": "Add a Postgres foreign data wrapper contrib module to allow access to other Postgres servers", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119891", "source_hash": "7b43638668bccc75ce6255028928da3442853bcb370d174c6cd91c3fee396834", "section_path": ["Additional Modules"], "commit_groups": [], "identity_text": "Add a Postgres foreign data wrapper contrib module to allow access to other Postgres servers (Shigeru Hanada) This foreign data wrapper supports writes.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/141", "db_id": "d312256857869efb141d2330bd374286", "patch_ids": [], "statement_hash": "7b42e61a3f2c50076ce7672b2d50cf94ac34a9a801953e8f9c09ad6de4b713b6", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-58b80bc370b2123d", "migration": false}, {"id": "9.3.0-dc47dcc836334996", "cves": [], "html": "Add pg_xlogdump contrib program (Andres Freund)
", "text": "Add pg_xlogdump contrib program (Andres Freund)", "title": "Add pg_xlogdump contrib program", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119891", "source_hash": "791a0521eaf7b6bd51d17cdb305a4597e10264cce880cb7170ede5d2a9e45618", "section_path": ["Additional Modules"], "commit_groups": [], "identity_text": "Add pg_xlogdump contrib program (Andres Freund)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/142", "db_id": "a979f45ac99db5c7775e0be888cf413f", "patch_ids": [], "statement_hash": "084d718ed5e85851f2ed97b92e7ef1f73bb43f1dfd0461760670f9b8704e6f52", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-dc47dcc836334996", "migration": false}, {"id": "9.3.0-c66a0ec0ac0ea62c", "cves": [], "html": "Add support for indexing of regular-expression searches in pg_trgm (Alexander Korotkov)
", "text": "Add support for indexing of regular-expression searches in pg_trgm (Alexander Korotkov)", "title": "Add support for indexing of regular-expression searches in pg_trgm", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119891", "source_hash": "5536e014bd5922b478019a5bdaf75909f08d3aa20750d6d2850828a8fd1c6808", "section_path": ["Additional Modules"], "commit_groups": [], "identity_text": "Add support for indexing of regular-expression searches in pg_trgm (Alexander Korotkov)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/143", "db_id": "b9c9c11643622f69d15131c42c81d3eb", "patch_ids": [], "statement_hash": "716b876db48ad6a5cd185874c35204d32c30c5b3558587386eb21a5b77d25e50", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-c66a0ec0ac0ea62c", "migration": false}, {"id": "9.3.0-fb56853c25474c56", "cves": [], "html": "Improve pg_trgm's handling of multibyte characters (Tom Lane)
\nOn a platform that does not have the wcstombs() or towlower() library functions, this could result in an incompatible change in the contents of pg_trgm indexes for non-ASCII data. In such cases, REINDEX those indexes to ensure correct search results.
", "text": "Improve pg_trgm's handling of multibyte characters (Tom Lane) On a platform that does not have the wcstombs() or towlower() library functions, this could result in an incompatible change in the contents of pg_trgm indexes for non-ASCII data. In such cases, REINDEX those indexes to ensure correct search results.", "title": "Improve pg_trgm's handling of multibyte characters", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119891", "source_hash": "1173d118e07f255d04c45fac8b1d0bbd012fa1c43b01b375501a2007f0e41133", "section_path": ["Additional Modules"], "commit_groups": [], "identity_text": "Improve pg_trgm's handling of multibyte characters (Tom Lane) On a platform that does not have the wcstombs() or towlower() library functions, this could result in an incompatible change in the contents of pg_trgm indexes for non-ASCII data. In such cases, REINDEX those indexes to ensure correct search results.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/144", "db_id": "34fdf76b40d696a5f65b6a4c7503cd5f", "patch_ids": [], "statement_hash": "5301427bd5dbb4cb9594afec751e14c2f439f17a92504696ee0c9eaac43716ef", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-fb56853c25474c56", "migration": false}, {"id": "9.3.0-d0eacd89349b3560", "cves": [], "html": "Add a pgstattuple function to report the size of the pending-insertions list of a GIN index (Fujii Masao)
", "text": "Add a pgstattuple function to report the size of the pending-insertions list of a GIN index (Fujii Masao)", "title": "Add a pgstattuple function to report the size of the pending-insertions list of a GIN index", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119891", "source_hash": "80bedde307d47c4893ff1782bdc7560604de4aa8ac429868f80a89f96d423ff1", "section_path": ["Additional Modules"], "commit_groups": [], "identity_text": "Add a pgstattuple function to report the size of the pending-insertions list of a GIN index (Fujii Masao)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/145", "db_id": "40b4b40424fd448bba8756299a8b0327", "patch_ids": [], "statement_hash": "f1c519c40d01c4b7688e576927c5df17d9544363c8d0c52187284a2b3ab91cb6", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-d0eacd89349b3560", "migration": false}, {"id": "9.3.0-8b082620a894b8e6", "cves": [], "html": "Make oid2name, pgbench, and vacuumlo set fallback_application_name (Amit Kapila)
", "text": "Make oid2name, pgbench, and vacuumlo set fallback_application_name (Amit Kapila)", "title": "Make oid2name, pgbench, and vacuumlo set fallback_application_name", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119891", "source_hash": "aa5c05368e71727da72c4f238e66f03c310b35dbabf79204d0a13db32bc25cfd", "section_path": ["Additional Modules"], "commit_groups": [], "identity_text": "Make oid2name, pgbench, and vacuumlo set fallback_application_name (Amit Kapila)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/146", "db_id": "7c769fc135f2116fcd75a9a88137c433", "patch_ids": [], "statement_hash": "f6ed314f8953671bcb8e2f444f710c23a8af0013ff2be10eaf0231849cf34b8c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-8b082620a894b8e6", "migration": false}, {"id": "9.3.0-76af5875e458c648", "cves": [], "html": "Improve output of pg_test_timing (Bruce Momjian)
", "text": "Improve output of pg_test_timing (Bruce Momjian)", "title": "Improve output of pg_test_timing", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119891", "source_hash": "b5705cd332998045581ba185a98e978c5c5905d4761adc9f139aeb24bb73b7d9", "section_path": ["Additional Modules"], "commit_groups": [], "identity_text": "Improve output of pg_test_timing (Bruce Momjian)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/147", "db_id": "e484f4070c766958e894219d8d23cffb", "patch_ids": [], "statement_hash": "60f4a13d321c75a9aa94aa768704d7c69a9a59c0cc31dba24bb33c84919accee", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-76af5875e458c648", "migration": false}, {"id": "9.3.0-d2f0c196a84c6c01", "cves": [], "html": "Improve output of pg_test_fsync (Peter Geoghegan)
", "text": "Improve output of pg_test_fsync (Peter Geoghegan)", "title": "Improve output of pg_test_fsync", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119891", "source_hash": "dfcf68c25d079488b155aa32ca603a2417833b3fc59cb9396da8c6b6a4aaa7c7", "section_path": ["Additional Modules"], "commit_groups": [], "identity_text": "Improve output of pg_test_fsync (Peter Geoghegan)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/148", "db_id": "f435c1ac359ab18a6ec6d17938f606f2", "patch_ids": [], "statement_hash": "feaf45c6e78c8c6e2121f15a8edc975a41209d8e14a0d6d13af5b1ae47c0a55c", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-d2f0c196a84c6c01", "migration": false}, {"id": "9.3.0-8cd6f814b1c9076a", "cves": [], "html": "Create a dedicated foreign data wrapper, with its own option validator function, for dblink (Shigeru Hanada)
\nWhen using this FDW to define the target of a dblink connection, instead of using a hard-wired list of connection options, the underlying libpq library is consulted to see what connection options it supports.
", "text": "Create a dedicated foreign data wrapper, with its own option validator function, for dblink (Shigeru Hanada) When using this FDW to define the target of a dblink connection, instead of using a hard-wired list of connection options, the underlying libpq library is consulted to see what connection options it supports.", "title": "Create a dedicated foreign data wrapper, with its own option validator function, for dblink", "commits": [], "section": "Additional Modules", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119891", "source_hash": "41fc346502519859c7e6cb4f1910bdcfcdebbefa49c1f3b9d0391c3c4c7c1346", "section_path": ["Additional Modules"], "commit_groups": [], "identity_text": "Create a dedicated foreign data wrapper, with its own option validator function, for dblink (Shigeru Hanada) When using this FDW to define the target of a dblink connection, instead of using a hard-wired list of connection options, the underlying libpq library is consulted to see what connection options it supports.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/149", "db_id": "f569eef6a2530d263b8969af199d0e2b", "patch_ids": [], "statement_hash": "303050be2a70640c7651477858d88ceb6b1bce7516a306b3d32851cfd20ad03e", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-8cd6f814b1c9076a", "migration": false}, {"id": "9.3.0-05a78bdf65104672", "cves": [], "html": "Allow pg_upgrade to do dumps and restores in parallel (Bruce Momjian, Andrew Dunstan)
\nThis allows parallel schema dump/restore of databases, as well as parallel copy/link of data files per tablespace. Use the --jobs option to specify the level of parallelism.
", "text": "Allow pg_upgrade to do dumps and restores in parallel (Bruce Momjian, Andrew Dunstan) This allows parallel schema dump/restore of databases, as well as parallel copy/link of data files per tablespace. Use the --jobs option to specify the level of parallelism.", "title": "Allow pg_upgrade to do dumps and restores in parallel", "commits": [], "section": "Additional Modules / pg_upgrade", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119942", "source_hash": "8ff6859d4dfbbe4df330cd3c75a2550dae750039223d20a4af78502bf6851ae2", "section_path": ["Additional Modules", "pg_upgrade"], "commit_groups": [], "identity_text": "Allow pg_upgrade to do dumps and restores in parallel (Bruce Momjian, Andrew Dunstan) This allows parallel schema dump/restore of databases, as well as parallel copy/link of data files per tablespace. Use the --jobs option to specify the level of parallelism.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/150", "db_id": "05ce6c2cc221595aa7ccbec95887a96d", "patch_ids": [], "statement_hash": "a545f2c915b3a26b2460ba4c7e5eed11f172e39367aa6e22b25c0ca74a2bf870", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-05a78bdf65104672", "migration": false}, {"id": "9.3.0-16cc8f2cd5484d7b", "cves": [], "html": "Make pg_upgrade create Unix-domain sockets in the current directory (Bruce Momjian, Tom Lane)
\nThis reduces the possibility that someone will accidentally connect during the upgrade.
", "text": "Make pg_upgrade create Unix-domain sockets in the current directory (Bruce Momjian, Tom Lane) This reduces the possibility that someone will accidentally connect during the upgrade.", "title": "Make pg_upgrade create Unix-domain sockets in the current directory", "commits": [], "section": "Additional Modules / pg_upgrade", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119942", "source_hash": "7bae12c2e58d0556dec8b31ace54635617f781b9e2716b41a51d9809446941b1", "section_path": ["Additional Modules", "pg_upgrade"], "commit_groups": [], "identity_text": "Make pg_upgrade create Unix-domain sockets in the current directory (Bruce Momjian, Tom Lane) This reduces the possibility that someone will accidentally connect during the upgrade.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/151", "db_id": "c14a9295efc6b6922fcfb0285e167fbc", "patch_ids": [], "statement_hash": "f15acce93d62027b33931c1237e851df306e461316ac809eab30a820e7a59dcb", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-16cc8f2cd5484d7b", "migration": false}, {"id": "9.3.0-5cf29988800521e0", "cves": [], "html": "Make pg_upgrade --check mode properly detect the location of non-default socket directories (Bruce Momjian, Tom Lane)
", "text": "Make pg_upgrade --check mode properly detect the location of non-default socket directories (Bruce Momjian, Tom Lane)", "title": "Make pg_upgrade --check mode properly detect the location of non-default socket directories", "commits": [], "section": "Additional Modules / pg_upgrade", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119942", "source_hash": "c5384b505ecd177f623d6a1af3f6b6bc3a167a9b0827267aeb1dd21b30028176", "section_path": ["Additional Modules", "pg_upgrade"], "commit_groups": [], "identity_text": "Make pg_upgrade --check mode properly detect the location of non-default socket directories (Bruce Momjian, Tom Lane)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/152", "db_id": "cd1b22c7005107f567d196689b4fd660", "patch_ids": [], "statement_hash": "b0d55fd68d41a4938e5d8c5f1a5cb26c279751f531cae4a897f06ebe400fe119", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-5cf29988800521e0", "migration": false}, {"id": "9.3.0-eb30cae5c6253926", "cves": [], "html": "Improve performance of pg_upgrade for databases with many tables (Bruce Momjian)
", "text": "Improve performance of pg_upgrade for databases with many tables (Bruce Momjian)", "title": "Improve performance of pg_upgrade for databases with many tables", "commits": [], "section": "Additional Modules / pg_upgrade", "category": "performance", "source_url": "/docs/release/9.3.0/#AEN119942", "source_hash": "684d8ab817036d78fdb2c423cd68d29669c106eda732459d200abd9c434ab557", "section_path": ["Additional Modules", "pg_upgrade"], "commit_groups": [], "identity_text": "Improve performance of pg_upgrade for databases with many tables (Bruce Momjian)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/153", "db_id": "0c17be42d4421d315a361b13fbc92bf3", "patch_ids": [], "statement_hash": "af767b90adf46210f750caf9c336ab929ed242c055d5a98fc81a48e75706fe84", "relations": [], "category_label": "Performance", "url": "/docs/compare/?release=9.3.0#9.3.0-eb30cae5c6253926", "migration": false}, {"id": "9.3.0-1caa9dba1ad01fcd", "cves": [], "html": "Improve pg_upgrade's logs by showing executed commands (\u00c1lvaro Herrera)
", "text": "Improve pg_upgrade's logs by showing executed commands (\u00c1lvaro Herrera)", "title": "Improve pg_upgrade's logs by showing executed commands", "commits": [], "section": "Additional Modules / pg_upgrade", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119942", "source_hash": "0d66959d50ecb6e6e9a12a345880bb2af00060cfc61e832aaf15512dfddba4ad", "section_path": ["Additional Modules", "pg_upgrade"], "commit_groups": [], "identity_text": "Improve pg_upgrade's logs by showing executed commands (\u00c1lvaro Herrera)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/154", "db_id": "a46282274140c5264dccac324de87442", "patch_ids": [], "statement_hash": "5ec5cbb1fc87ffe00b86a59f558af5bea8af0ed3e79cfe752e109f274758a437", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-1caa9dba1ad01fcd", "migration": false}, {"id": "9.3.0-adad04b03d40eb4c", "cves": [], "html": "Improve pg_upgrade's status display during copy/link (Bruce Momjian)
", "text": "Improve pg_upgrade's status display during copy/link (Bruce Momjian)", "title": "Improve pg_upgrade's status display during copy/link", "commits": [], "section": "Additional Modules / pg_upgrade", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119942", "source_hash": "f045d2f1065f0af44424a8e3887515fe61044988527f0a39e37bc0decbbd674e", "section_path": ["Additional Modules", "pg_upgrade"], "commit_groups": [], "identity_text": "Improve pg_upgrade's status display during copy/link (Bruce Momjian)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/155", "db_id": "7e80fd8793179485d2f8acf0c598b48e", "patch_ids": [], "statement_hash": "d85ed56b84e346661441c7f571ea71eed12b9f3e65f1b5e515aaaa9c52f49b7d", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-adad04b03d40eb4c", "migration": false}, {"id": "9.3.0-832fc41e96381918", "cves": [], "html": "Add --foreign-keys option to pgbench (Jeff Janes)
\nThis adds foreign key constraints to the standard tables created by pgbench, for use in foreign key performance testing.
", "text": "Add --foreign-keys option to pgbench (Jeff Janes) This adds foreign key constraints to the standard tables created by pgbench, for use in foreign key performance testing.", "title": "Add --foreign-keys option to pgbench", "commits": [], "section": "Additional Modules / pgbench", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119969", "source_hash": "9fcee64c46f809c13ead14dda18f3c1911aa42a1f1102bf24c0d17f03b40a985", "section_path": ["Additional Modules", "pgbench"], "commit_groups": [], "identity_text": "Add --foreign-keys option to pgbench (Jeff Janes) This adds foreign key constraints to the standard tables created by pgbench, for use in foreign key performance testing.", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/156", "db_id": "b46927cd0a867cba138cb5c5c8dce6ef", "patch_ids": [], "statement_hash": "97d386f1c4f7a960d4b660998075c751a6e09893817a977408fc79e134247ba1", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-832fc41e96381918", "migration": false}, {"id": "9.3.0-dd70967ef3e575c6", "cves": [], "html": "Allow pgbench to aggregate performance statistics and produce output every --aggregate-interval seconds (Tomas Vondra)
", "text": "Allow pgbench to aggregate performance statistics and produce output every --aggregate-interval seconds (Tomas Vondra)", "title": "Allow pgbench to aggregate performance statistics and produce output every --aggregate-interval seconds", "commits": [], "section": "Additional Modules / pgbench", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119969", "source_hash": "7159544d7f17a7516c7120b7705d86d17afb754a61e6789649a78426bd3b3015", "section_path": ["Additional Modules", "pgbench"], "commit_groups": [], "identity_text": "Allow pgbench to aggregate performance statistics and produce output every --aggregate-interval seconds (Tomas Vondra)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/157", "db_id": "2833a0aabd6261b7fe58d9de6d2d062b", "patch_ids": [], "statement_hash": "e3aa537957207090683efaea6a1d30bbf74231cfea0f0a991e300077577f7c06", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-dd70967ef3e575c6", "migration": false}, {"id": "9.3.0-5db22f3ba9f71295", "cves": [], "html": "Add pgbench --sampling-rate option to control the percentage of transactions logged (Tomas Vondra)
", "text": "Add pgbench --sampling-rate option to control the percentage of transactions logged (Tomas Vondra)", "title": "Add pgbench --sampling-rate option to control the percentage of transactions logged", "commits": [], "section": "Additional Modules / pgbench", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119969", "source_hash": "91ca44ec0845857150e4e3d752d806fbf545057dbe25079aa100291204fb4571", "section_path": ["Additional Modules", "pgbench"], "commit_groups": [], "identity_text": "Add pgbench --sampling-rate option to control the percentage of transactions logged (Tomas Vondra)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/158", "db_id": "0f0073245cdfe7713794e22bd10fb32f", "patch_ids": [], "statement_hash": "113c08b7595302724bd4a8f4b986e8c71f7be7125e046714bfde8247cf3475ff", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-5db22f3ba9f71295", "migration": false}, {"id": "9.3.0-5be24bc4c0f8a6cb", "cves": [], "html": "Reduce and improve the status message output of pgbench's initialization mode (Robert Haas, Peter Eisentraut)
", "text": "Reduce and improve the status message output of pgbench's initialization mode (Robert Haas, Peter Eisentraut)", "title": "Reduce and improve the status message output of pgbench's initialization mode", "commits": [], "section": "Additional Modules / pgbench", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119969", "source_hash": "33cbdc87dbce964ff97f722a63cd6911e7d7e31a9d3f3fa68de98c5065ae822d", "section_path": ["Additional Modules", "pgbench"], "commit_groups": [], "identity_text": "Reduce and improve the status message output of pgbench's initialization mode (Robert Haas, Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/159", "db_id": "3af45419d318dd2a97d85532dd0a9cf0", "patch_ids": [], "statement_hash": "1e9493a5de723e1dd79d98c43cca74f1097091411c690fa925294c7b84ce392b", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-5be24bc4c0f8a6cb", "migration": false}, {"id": "9.3.0-f2986efa42c8e26e", "cves": [], "html": "Add pgbench -q mode to print one output line every five seconds (Tomas Vondra)
", "text": "Add pgbench -q mode to print one output line every five seconds (Tomas Vondra)", "title": "Add pgbench -q mode to print one output line every five seconds", "commits": [], "section": "Additional Modules / pgbench", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119969", "source_hash": "12eeaa286a8fba837088cc0a91ad1a856d042fdc80793859236ecbd9d1094438", "section_path": ["Additional Modules", "pgbench"], "commit_groups": [], "identity_text": "Add pgbench -q mode to print one output line every five seconds (Tomas Vondra)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/160", "db_id": "e97e90f0c87a8900e2bae546bfc2044a", "patch_ids": [], "statement_hash": "5bd6a3d09cf35ff10b8e10ec76c65ad577b607eb3b5010229242e9e4027fda73", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-f2986efa42c8e26e", "migration": false}, {"id": "9.3.0-464fd7f77160e9e2", "cves": [], "html": "Output pgbench elapsed and estimated remaining time during initialization (Tomas Vondra)
", "text": "Output pgbench elapsed and estimated remaining time during initialization (Tomas Vondra)", "title": "Output pgbench elapsed and estimated remaining time during initialization", "commits": [], "section": "Additional Modules / pgbench", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119969", "source_hash": "a6dfe17914d93362f2384c184af157ab3315e63ee1e4bd388c96ddb3f0a61958", "section_path": ["Additional Modules", "pgbench"], "commit_groups": [], "identity_text": "Output pgbench elapsed and estimated remaining time during initialization (Tomas Vondra)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/161", "db_id": "93812c53fe958ab21ca1702c996e6a78", "patch_ids": [], "statement_hash": "8375170c1073b538b375e69f876c056f68cb62239aa5a4ee020a9994615338a3", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-464fd7f77160e9e2", "migration": false}, {"id": "9.3.0-7ed70a86858b4242", "cves": [], "html": "Allow pgbench to use much larger scale factors, by changing relevant columns from integer to bigint when the requested scale factor exceeds 20000 (Greg Smith)
", "text": "Allow pgbench to use much larger scale factors, by changing relevant columns from integer to bigint when the requested scale factor exceeds 20000 (Greg Smith)", "title": "Allow pgbench to use much larger scale factors, by changing relevant columns from integer to bigint when the requested scale factor exceeds 20000", "commits": [], "section": "Additional Modules / pgbench", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN119969", "source_hash": "e8423a7b94482015bc49899abaafd1d2224bb8225bc90407fe21ecb778692cc8", "section_path": ["Additional Modules", "pgbench"], "commit_groups": [], "identity_text": "Allow pgbench to use much larger scale factors, by changing relevant columns from integer to bigint when the requested scale factor exceeds 20000 (Greg Smith)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/162", "db_id": "45bc1202cbd463509c498cd27f81f3da", "patch_ids": [], "statement_hash": "c30f55ab8ba362937e8ff4c14ac051c25d370c0000ccec70081bcb830d0a9677", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-7ed70a86858b4242", "migration": false}, {"id": "9.3.0-1f3aab200a8c5548", "cves": [], "html": "Allow EPUB-format documentation to be created (Peter Eisentraut)
", "text": "Allow EPUB-format documentation to be created (Peter Eisentraut)", "title": "Allow EPUB-format documentation to be created", "commits": [], "section": "Documentation", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN120003", "source_hash": "cfd031bfccaa687456f2d281f02c96d28a2fcb60eafea820f8a1036b2f8a9d3f", "section_path": ["Documentation"], "commit_groups": [], "identity_text": "Allow EPUB-format documentation to be created (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/163", "db_id": "1ba9c824dcca5f707eb9a3e636466bd2", "patch_ids": [], "statement_hash": "1b0ea18d1870b7c039358c5b01ce6fbe8b0f9a33f959c4c3026e5309078ace4b", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-1f3aab200a8c5548", "migration": false}, {"id": "9.3.0-29775d86411b635e", "cves": [], "html": "Update FreeBSD kernel configuration documentation (Brad Davis)
", "text": "Update FreeBSD kernel configuration documentation (Brad Davis)", "title": "Update FreeBSD kernel configuration documentation", "commits": [], "section": "Documentation", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN120003", "source_hash": "22aa6381937d44d2427ae73f6c2dec2fd38e36a85acb0c0db35d112223c4469c", "section_path": ["Documentation"], "commit_groups": [], "identity_text": "Update FreeBSD kernel configuration documentation (Brad Davis)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/164", "db_id": "2e2e5b8bb10986fcfd9569ef98b49dac", "patch_ids": [], "statement_hash": "0f9f13dcf6b0ca56efcf13bef10c81cef0985a0d0b1532a1932976a1b17f8537", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-29775d86411b635e", "migration": false}, {"id": "9.3.0-c3a73fa8cb2734e6", "cves": [], "html": "Improve WINDOW function documentation (Bruce Momjian, Florian Pflug)
", "text": "Improve WINDOW function documentation (Bruce Momjian, Florian Pflug)", "title": "Improve WINDOW function documentation", "commits": [], "section": "Documentation", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN120003", "source_hash": "e0d28a24102c0641ff891537045a8b6470bbe8d20340609dcce972ff1aa2b7f2", "section_path": ["Documentation"], "commit_groups": [], "identity_text": "Improve WINDOW function documentation (Bruce Momjian, Florian Pflug)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/165", "db_id": "a1ce2a69a3078711c5fb744d739142ef", "patch_ids": [], "statement_hash": "310ff2eb89516e2876f00d58852629531523da829168bf48f9c22a640507c50a", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-c3a73fa8cb2734e6", "migration": false}, {"id": "9.3.0-3f5e01d6e3939965", "cves": [], "html": "Add instructions for setting up the documentation tool chain on macOS (Peter Eisentraut)
", "text": "Add instructions for setting up the documentation tool chain on macOS (Peter Eisentraut)", "title": "Add instructions for setting up the documentation tool chain on macOS", "commits": [], "section": "Documentation", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN120003", "source_hash": "da663b07d2a23f9ad44d248c48b01b09ae9e5bd74a19afb975775b96e3e2dfb3", "section_path": ["Documentation"], "commit_groups": [], "identity_text": "Add instructions for setting up the documentation tool chain on macOS (Peter Eisentraut)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/166", "db_id": "8becde451eca6edfb202359e7449adb6", "patch_ids": [], "statement_hash": "ab365dee6c2e020ab5f557ab99e92fd1e120104b2e20501ca493540cea392696", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-3f5e01d6e3939965", "migration": false}, {"id": "9.3.0-c0354fac477475b4", "cves": [], "html": "Improve commit_delay documentation (Peter Geoghegan)
", "text": "Improve commit_delay documentation (Peter Geoghegan)", "title": "Improve commit_delay documentation", "commits": [], "section": "Documentation", "category": "feature", "source_url": "/docs/release/9.3.0/#AEN120003", "source_hash": "cfac7ce6358fe1dcf227a47e80cfe7908b3e1d522c917b8c0f4cb3bd8a8cb22f", "section_path": ["Documentation"], "commit_groups": [], "identity_text": "Improve commit_delay documentation (Peter Geoghegan)", "commit_aliases": [], "source_commits": [], "source_entry_id": "9.3.0/changes/167", "db_id": "fb71d25ea2b2204ca496171ff4d82cd6", "patch_ids": [], "statement_hash": "a9645b36b9235e80733991d722bf00f5e64aff5afe6180439bff0af8365684bc", "relations": [], "category_label": "Features", "url": "/docs/compare/?release=9.3.0#9.3.0-c0354fac477475b4", "migration": false}], "initial_entry_count": 177, "migration_html": "A dump/restore using pg_dumpall, or use of pg_upgrade, is required for those wishing to migrate data from any previous release.
\nVersion 9.3 contains a number of changes that may affect compatibility with previous releases. Observe the following incompatibilities:
\n\n