From 6186d0bd615ed2eb921ad13ccdf4ceed19d3f7a8 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 11 May 2018 14:47:26 -0400 Subject: [PATCH] doc: markup for PG 11 release notes and included email tips --- doc/src/sgml/release-11.sgml | 950 ++++++++++++++++++++--------------- 1 file changed, 554 insertions(+), 396 deletions(-) diff --git a/doc/src/sgml/release-11.sgml b/doc/src/sgml/release-11.sgml index 1b5db2912c9..3f64bf60bdc 100644 --- a/doc/src/sgml/release-11.sgml +++ b/doc/src/sgml/release-11.sgml @@ -54,33 +54,42 @@ --> - Have pg_dump dump all aspects of a database (Haribabu Kommi) + Have pg_dump dump all aspects of a + database (Haribabu Kommi) - Previously database attributes like GRANT/REVOKE permissions and ALTER - DATABASE SET and ALTER ROLE IN DATABASE SET variable settings were only - dumped by pg_dumpall. Now pg_dump --create and pg_restore --create - will restore all database aspects. pg_dumpall -g will now only output - role and tablespace-related attributes. pg_dumpall's output (without - -g) is unchanged. + Previously database attributes like + GRANT/REVOKE permissions + and ALTER DATABASE SET and ALTER + ROLE IN DATABASE SET variable settings were only dumped + by pg_dumpall. Now pg_dump + --create and pg_restore --create will + restore all database aspects. pg_dumpall -g + will now only output role and tablespace-related attributes. + pg_dumpall's output (without + ) is unchanged. - pg_dump and pg_restore, without --clean, no longer dump/restore database - comments and security labels. + pg_dump and + pg_restore, without + , no longer dump/restore database comments + and security labels. - pg_dumpall --clean now restores the "postgres" and "template1" databases - with the original locale and encoding settings. + pg_dumpall --clean now restores the "postgres" + and "template1" databases with the original locale and encoding + settings. - A restore of pg_dumpall will now create databases with their original - locale and encoding, and will fail if the creation fails. Previously - CREATE DATABASE would be dumped without such specifications if the - database locale and encoding matched the old cluster's defaults. + A restore of pg_dumpall will now create + databases with their original locale and encoding, and will fail if + the creation fails. Previously CREATE DATABASE + would be dumped without such specifications if the database locale + and encoding matched the old cluster's defaults. @@ -94,8 +103,10 @@ --> - Correct information schema column tables.table_type to return 'FOREIGN' - instead of 'FOREIGN TABLE' (Peter Eisentraut) + Correct information schema column + tables.table_type + to return FOREIGN instead of FOREIGN + TABLE (Peter Eisentraut) @@ -110,7 +121,8 @@ Change the ps process display labels to match the - pg_stat_activity.backend_type labels (Peter Eisentraut) + pg_stat_activity.backend_type + labels (Peter Eisentraut) @@ -120,14 +132,16 @@ --> - Prevent to_number() from consuming characters when the template - separator does not match (Oliver Ford) + Prevent to_number() from consuming characters + when the template separator does not match (Oliver Ford) - Specifically, SELECT to_number('1234', '9,999') used to return '134'. It - will now return '1234'. "L" and "TH" now only consume characters that - are not digits, positive/negative signs, decimal points, and commas. + Specifically, SELECT to_number('1234', '9,999') + used to return 134. It will now + return 1234. L and + TH now only consume characters that are not + digits, positive/negative signs, decimal points, and commas. @@ -137,8 +151,10 @@ --> - Fix to_date(), to_number(), and to_timestamp() to skip a character for - each template character (Tom Lane) + Fix to_date(), + to_number(), and + to_timestamp() to skip a character for each + template character (Tom Lane) @@ -152,8 +168,10 @@ --> - Adjust the handling of backslashes inside double-quotes in template - strings for to_char(), to_number(), and to_timestamp(). + Adjust the handling of backslashes inside double-quotes in + template strings for to_char(), + to_number(), and + to_timestamp(). @@ -168,15 +186,16 @@ --> - Have libpq's PQhost() always return the actual connected host (Hari - Babu) + Have libpq's PQhost() always return the + actual connected host (Hari Babu) - Previously PQhost() often returned the supplied host parameters, which - could contain several hosts. The same is true of PQport(), which now - returns the actual port number, not the multiple supplied port numbers. - ACCURATE? + Previously PQhost() often returned the + supplied host parameters, which could contain several hosts. + The same is true of PQport(), which now + returns the actual port number, not the multiple supplied port + numbers. ACCURATE? @@ -186,11 +205,13 @@ --> - Remove relhaspkey column from system table pg_class (Peter Eisentraut) + Remove relhaspkey column from system table + pg_class (Peter Eisentraut) - Applications needing to check for a primary key should consult pg_index. + Applications needing to check for a primary key should consult + pg_index. @@ -200,8 +221,10 @@ --> - Replace system table pg_proc's proisagg and proiswindow with prokind - (Peter Eisentraut) + Replace system table pg_proc's + proisagg and + proiswindow with + prokind (Peter Eisentraut) @@ -217,8 +240,8 @@ --> - Cause large object permission checks to happen on large object open, - lo_open(), not read/write (Tom Lane) + Cause large object permission checks to happen on large object + open, lo_open(), not read/write (Tom Lane) @@ -228,14 +251,16 @@ --> - Remove deprecated contrib/adminpack functions pg_file_read(), - pg_file_length(), and pg_logfile_rotate() (Stephen Frost) + Remove deprecated contrib/adminpack functions + pg_file_read(), + pg_file_length(), and + pg_logfile_rotate() (Stephen Frost) - These function are now present by default. Old adminpack installs will - continue to have access to these functions until they are updated via - ALTER EXTENSION ... UPDATE. + These function are now present by default. Old adminpack installs + will continue to have access to these functions until they are + updated via ALTER EXTENSION ... UPDATE. @@ -245,14 +270,14 @@ --> - Honor the capitalization of double-quoted command options (Daniel - Gustafsson) + Honor the capitalization of double-quoted command options + (Daniel Gustafsson) Previously index options names like ("FillFactor" = 50) were - automatically lower-cased. This quoted capitalization will now generate - an error. + automatically lower-cased. This quoted capitalization will now + generate an error. @@ -262,12 +287,13 @@ --> - Remove WITH clause in CREATE FUNCTION (Michael Paquier) + Remove WITH clause in CREATE + FUNCTION (Michael Paquier) - Postgres has long supported a more standard-compliant syntax for this - capability. + PostgreSQL has long supported a more + standard-compliant syntax for this capability. @@ -302,8 +328,8 @@ --> - Allow faster partition elimination during query processing (Amit Langote, - David Rowley, Dilip Kumar) + Allow faster partition elimination during query processing (Amit + Langote, David Rowley, Dilip Kumar) @@ -317,14 +343,14 @@ --> - Allow partition elimination during query execution (David Rowley, Beena - Emerson) + Allow partition elimination during query execution (David Rowley, + Beena Emerson) - Previously partition elimination could only happen at planning time, - meaning many joins and prepared queries could not use partition - elimination. + Previously partition elimination could only happen at planning + time, meaning many joins and prepared queries could not use + partition elimination. @@ -344,8 +370,8 @@ --> - Allow updated rows to automatically move to new partitions based on the - new row contents (Amit Khandekar) + Allow updated rows to automatically move to new partitions based + on the new row contents (Amit Khandekar) @@ -361,8 +387,8 @@ - The default partition can store rows that don't match any of the other - defined partitions, and is searched accordingly. + The default partition can store rows that don't match any of the + other defined partitions, and is searched accordingly. @@ -373,8 +399,9 @@ --> - Allow UNIQUE indexes on partitioned tables if the partition key - guarantees uniqueness (Álvaro Herrera, Amit Langote) + Allow UNIQUE indexes on partitioned tables if + the partition key guarantees uniqueness (Álvaro Herrera, + Amit Langote) @@ -384,14 +411,15 @@ --> - Allow indexes on a partitioned table to be automatically created in any - child partitions (Álvaro Herrera) + Allow indexes on a partitioned table to be automatically created + in any child partitions (Álvaro Herrera) - The new command ALTER INDEX ATTACH PARTITION allows indexes to be attached - to partitions. This does not behave as a global index since the - contents are private to each index. WARN WHEN USING AN EXISTING INDEX? + The new command ALTER INDEX ATTACH PARTITION + allows indexes to be attached to partitions. This does not behave + as a global index since the contents are private to each index. + WARN WHEN USING AN EXISTING INDEX? @@ -411,12 +439,14 @@ --> - Allow INSERTs, UPDATEs, and COPY on partitioned tables to properly route + Allow INSERT, UPDATE, and + COPY on partitioned tables to properly route rows to foreign partitions (Etsuro Fujita, Amit Langote) - This is supported by postgres_fdw foreign tables. + This is supported by postgres_fdw + foreign tables. @@ -426,13 +456,14 @@ --> - Allow FOR EACH ROW triggers on partitioned tables (Álvaro Herrera) + Allow FOR EACH ROW triggers on partitioned + tables (Álvaro Herrera) Creation of a trigger on partitioned tables automatically creates - triggers on all partition tables, and on newly-created ones. This also - allows deferred unique constraints on partitioned tables. + triggers on all partition tables, and on newly-created ones. + This also allows deferred unique constraints on partitioned tables. @@ -445,13 +476,13 @@ Allow equality joins between partitioned tables with identically - partitioned child tables to join the child tables directly (Ashutosh - Bapat) + partitioned child tables to join the child tables directly + (Ashutosh Bapat) This features is disabled by default but can be enabled by changing - enable_partitionwise_join. + enable_partitionwise_join. @@ -468,7 +499,7 @@ This features is disabled by default but can be enabled by changing - enable_partitionwise_aggregate. + enable_partitionwise_aggregate. @@ -478,8 +509,8 @@ --> - Allow postgres_fdw to push down aggregates to foreign tables that are - partitions (Jeevan Chalke) + Allow postgres_fdw to push down + aggregates to foreign tables that are partitions (Jeevan Chalke) @@ -499,8 +530,8 @@ --> - Allow indexes to be built in parallel (Peter - Geoghegan, Rushabh Lathia, Heikki Linnakangas) + Allow indexes to be built in parallel (Peter Geoghegan, Rushabh + Lathia, Heikki Linnakangas) @@ -510,8 +541,8 @@ --> - Allow hash joins to be performed in parallel using a shared hash table - (Thomas Munro) + Allow hash joins to be performed in parallel using a shared hash + table (Thomas Munro) @@ -522,8 +553,10 @@ --> - Allow UNION to run each SELECT in parallel if the individual SELECTs cannot be - parallelized (Amit Khandekar, Robert Haas, Amul Sul) + Allow UNION to run each + SELECT in parallel if the individual + SELECTs cannot be parallelized (Amit Khandekar, + Robert Haas, Amul Sul) @@ -535,8 +568,8 @@ same commits as above --> - Allow partition scans to more efficiently use parallel workers (Amit Khandekar, Robert - Haas, Amul Sul) + Allow partition scans to more efficiently use parallel workers + (Amit Khandekar, Robert Haas, Amul Sul) @@ -546,12 +579,13 @@ same commits as above --> - Allow LIMIT to be passed to parallel workers (Robert Haas, Tom Lane) + Allow LIMIT to be passed to parallel workers + (Robert Haas, Tom Lane) - This allows workers to reduce returned results and use targeted index - scans. + This allows workers to reduce returned results and use targeted + index scans. @@ -561,8 +595,8 @@ same commits as above --> - Add server option parallel_leader_participation to control if the leader - executes subplans (Thomas Munro) + Add server option parallel_leader_participation + to control if the leader executes subplans (Thomas Munro) @@ -576,8 +610,9 @@ same commits as above --> - Allow parallelization of commands CREATE TABLE .. AS, SELECT INTO, and CREATE - MATERIALIZED VIEW (Haribabu Kommi) + Allow parallelization of commands CREATE TABLE + .. AS, SELECT INTO, and + CREATE MATERIALIZED VIEW (Haribabu Kommi) @@ -587,7 +622,8 @@ same commits as above --> - Add reporting of parallel worker sort activity to EXPLAIN (Robert Haas, Tom Lane) + Add reporting of parallel worker sort activity to + EXPLAIN (Robert Haas, Tom Lane) @@ -607,13 +643,14 @@ same commits as above --> - Allow indexes to INCLUDE columns that are not part of the unique - constraint but are available for index-only scans (Anastasia - Lubennikova, Alexander Korotkov, Teodor Sigaev) + Allow indexes to INCLUDE columns that are not + part of the unique constraint but are available for index-only + scans (Anastasia Lubennikova, Alexander Korotkov, Teodor Sigaev) - This is also useful for including columns that don't have btree support. + This is also useful for including columns that don't have btree + support. @@ -624,8 +661,9 @@ same commits as above --> - Remember the highest btree index page to optimize future monotonically - increasing index additions (Pavan Deolasee, Peter Geoghegan) + Remember the highest btree index page to optimize future + monotonically increasing index additions (Pavan Deolasee, Peter + Geoghegan) @@ -652,11 +690,12 @@ same commits as above --> - Add predicate locking for Hash, GiST and GIN indexes (Shubham Barai) + Add predicate locking for Hash, GiST and GIN indexes (Shubham + Barai) - This reduces the likelyhood of serialization conflicts. ACCURATE? + This reduces the likelihood of serialization conflicts. ACCURATE? @@ -666,8 +705,9 @@ same commits as above --> - Allow heap-only-tuple (HOT) updates for expression indexes when the - values of the expressions are unchanged (Konstantin Knizhnik) + Allow heap-only-tuple (HOT) updates for + expression indexes when the values of the expressions are unchanged + (Konstantin Knizhnik) @@ -685,12 +725,13 @@ same commits as above --> - Add TEXT prefix operator ^@ which is supported by SP-GiST (Ildus - Kurbangaliev) + Add TEXT prefix operator ^@ which is supported by + SP-GiST (Ildus Kurbangaliev) - This is similar to using LIKE 'word%' with btree indexes, but is more efficient. + This is similar to using LIKE 'word%' with + btree indexes, but is more efficient. @@ -700,8 +741,8 @@ same commits as above --> - Allow polygons to be indexed with SP-GiST (Nikita Glukhov, Alexander - Korotkov) + Allow polygons to be indexed with SP-GiST (Nikita Glukhov, + Alexander Korotkov) @@ -734,15 +775,17 @@ same commits as above --> - Improve the selection of the optimizer statistics' most-common-values - (Jeff Janes, Dean Rasheed) + Improve the selection of the optimizer statistics' + most-common-values (Jeff Janes, Dean Rasheed) - Previously most-common-values (MCV) were chosen based on their - significance compared to all column values. Now, MCV are chosen based - on their significance compared to the non-MCV values. This improves the - statistics for uniform (fewer) and non-uniform (more) distributions. + Previously most-common-values (MCV) were + chosen based on their significance compared to all column + values. Now, MCV are chosen based on their + significance compared to the non-MCV values. + This improves the statistics for uniform (fewer) and non-uniform + (more) distributions. @@ -752,14 +795,14 @@ same commits as above --> - Improve selectivity estimates for >= and <= when the constants are not - common values (Tom Lane) + Improve selectivity estimates for >= and <= when the + constants are not common values (Tom Lane) - Previously such cases used the same selectivity as > and <, - respectively. This change is particularly useful for BETWEEN with - small ranges. + Previously such cases used the same selectivity as > and + <, respectively. This change is particularly useful for + BETWEEN with small ranges. @@ -769,7 +812,8 @@ same commits as above --> - Optimize var = var to var IS NOT NULL where equivalent (Tom Lane) + Optimize var = var to var IS NOT NULL where + equivalent (Tom Lane) @@ -783,8 +827,8 @@ same commits as above --> - Improve row count optimizer estimates for EXISTS and NOT EXISTS queries (Tom - Lane) + Improve row count optimizer estimates for EXISTS + and NOT EXISTS queries (Tom Lane) @@ -794,7 +838,8 @@ same commits as above --> - Add optimizer selectivity costs for HAVING clauses (Tom Lane) + Add optimizer selectivity costs for HAVING + clauses (Tom Lane) @@ -819,7 +864,8 @@ same commits as above --> - Add Just-In-time (JIT) compilation of plans run the by the executor + Add Just-In-Time (JIT) compilation of plans + run the by the executor (Andres Freund) @@ -830,14 +876,14 @@ same commits as above --> - Allow bitmap scans to perform index-only scans when possible (Alexander - Kuzmenkov) + Allow bitmap scans to perform index-only scans when possible + (Alexander Kuzmenkov) @@ -856,7 +902,8 @@ same commits as above --> - Improve performance of committing multiple concurrent transactions (Amit Kapila) + Improve performance of committing multiple concurrent transactions + (Amit Kapila) @@ -866,8 +913,8 @@ same commits as above --> - Reduce memory usage for queries using set-returning functions in their - target lists (Andres Freund) + Reduce memory usage for queries using set-returning functions in + their target lists (Andres Freund) @@ -877,12 +924,14 @@ same commits as above --> - Allow postgres_fdw to push UPDATEs and DELETEs using joins to foreign - servers (Etsuro Fujita) + Allow postgres_fdw to push + UPDATEs and DELETEs using + joins to foreign servers (Etsuro Fujita) - Previously only non-join UPDATEs and DELETEs were pushed. + Previously only non-join UPDATEs and + DELETEs were pushed. @@ -902,8 +951,11 @@ same commits as above --> - Show memory usage in log_statement_stats, log_parser_stats, - log_planner_stats, log_executor_stats (Justin Pryzby, Peter Eisentraut) + Show memory usage in log_statement_stats, + log_parser_stats, + log_planner_stats, + log_executor_stats (Justin Pryzby, Peter + Eisentraut) @@ -913,17 +965,20 @@ same commits as above --> - Add pg_stat_activity.backend_type now shows the type of background worker -(Peter Eisentraut) + Add + pg_stat_activity.backend_type + now shows the type of background worker (Peter Eisentraut) - Add bgw_type to the background worker C structure (Peter Eisentraut) + Add bgw_type to the background worker + C structure (Peter Eisentraut) - This is displayed to the user in pg_stat_activity.backend_type and ps - output. + This is displayed to the user in + pg_stat_activity.backend_type + and ps output. @@ -933,8 +988,8 @@ same commits as above --> - Have log_autovacuum_min_duration log skipped tables that are - concurrently being dropped (Nathan Bossart) + Have log_autovacuum_min_duration log skipped + tables that are concurrently being dropped (Nathan Bossart) @@ -952,14 +1007,17 @@ same commits as above --> - Add information_schema columns related to table constraints and triggers - (Michael Paquier) + Add information_schema columns related to table constraints and + triggers (Michael Paquier) - Specifically, table_constraints.enforced, triggers.action_order, - triggers.action_reference_old_table, and - triggers.action_reference_new_table. + Specifically, + table_constraints.enforced, + triggers.action_order, + triggers.action_reference_old_table, + and + triggers.action_reference_new_table. @@ -982,20 +1040,22 @@ same commits as above --> - Add libpq option to support channel binding when using SCRAM - authentication (Michael Paquier) + Add libpq option to support channel binding when using + SCRAM authentication (Michael Paquier) - Channel binding requires the server end of the TLS connection to prove + Channel binding requires the server end of + the TLS connection to prove that it knows the password. The options are - 'scram_channel_binding=tls-unique' and - 'scram_channel_binding=tls-server-end-point'. + and + . - WHAT DOES THIS DOC TEXT MEAN? "An empty value specifies that the client will not - use channel binding. The default value is tls-unique." + WHAT DOES THIS DOC TEXT MEAN? "An empty value specifies that + the client will not use channel binding. The default value + is tls-unique." @@ -1005,13 +1065,13 @@ same commits as above --> - Allow the server to specify more complex LDAP specifications in - search+bind mode (Thomas Munro) + Allow the server to specify more complex LDAP + specifications in search+bind mode (Thomas Munro) Specifically, "ldapsearchfilter" allows pattern matching using - combinations of LDAP attributes. + combinations of LDAP attributes. @@ -1022,12 +1082,15 @@ same commits as above --> - Allow LDAP authentication to use ldaps (Thomas Munro) + Allow LDAP authentication to use ldaps + (Thomas Munro) - We already supported LDAP over TLS by using ldaptls=1. This new TLS - LDAP method of encrypted LDAP is enabled with ldapscheme=ldaps or + We already supported LDAP over + TLS by using ldaptls=1. This new + TLS LDAP method of encrypted + LDAP is enabled with ldapscheme=ldaps or ldapurl=ldaps://. @@ -1038,7 +1101,7 @@ same commits as above --> - Improve LDAP logging of errors (Thomas Munro) + Improve LDAP logging of errors (Thomas Munro) @@ -1063,11 +1126,13 @@ same commits as above - Specifically, the new roles are: pg_read_server_files, - pg_write_server_files, pg_execute_server_program. These roles now also - control who can use COPY and extension file_fdw. Previously only - super-users could use these functions, and that is still the default - behavior. + Specifically, the new roles are: + pg_read_server_files, + pg_write_server_files, + pg_execute_server_program. These roles now + also control who can use COPY and extension + file_fdw. Previously only super-users + could use these functions, and that is still the default behavior. @@ -1077,13 +1142,17 @@ same commits as above --> - Allow access to file system functions to be controlled by GRANT/REVOKE - permissions, rather than super-user checks (Michael Paquier) + Allow access to file system functions to be controlled by + GRANT/REVOKE permissions, + rather than super-user checks (Michael Paquier) - Specifically, these functions were modified: pg_ls_dir(), pg_read_file(), - pg_read_binary_file(), pg_stat_file(). + Specifically, these functions were + modified: pg_ls_dir(), + pg_read_file(), + pg_read_binary_file(), + pg_stat_file(). @@ -1094,8 +1163,9 @@ same commits as above --> - Use GRANT/REVOKE to control access to lo_import() and lo_export() - (Michael Paquier) + Use GRANT/REVOKE + to control access to lo_import() and + lo_export() (Michael Paquier) @@ -1114,14 +1184,17 @@ same commits as above --> - Use view owner not session owner when preventing non-password access to - postgres_fdw tables (Robert Haas) + Use view owner not session owner when preventing non-password + access to postgres_fdw tables + (Robert Haas) - Postgres only allows super-users to access postgres_fdw tables without - passwords, e.g. via peer. Previously the session owner had to be a - super-user to allow such access; now the view owner is checked instead. + PostgreSQL only allows super-users to + access postgres_fdw tables without + passwords, e.g. via peer. Previously the session owner had to + be a super-user to allow such access; now the view owner is + checked instead. @@ -1131,8 +1204,8 @@ same commits as above --> - Fix invalid locking permission check in SELECT FOR UPDATE on views (Tom - Lane) + Fix invalid locking permission check in SELECT FOR + UPDATE on views (Tom Lane) @@ -1152,13 +1225,15 @@ same commits as above --> - Add server setting ssl_passphrase_command to allow supplying of the the - passphrase for SSL key files (Peter Eisentraut) + Add server setting ssl_passphrase_command to + allow supplying of the the passphrase for SSL + key files (Peter Eisentraut) - Also add ssl_passphrase_command_supports_reload to specify whether the - the SSL configuration should be reloaded and ssl_passphrase_command + Also add ssl_passphrase_command_supports_reload + to specify whether the the SSL configuration + should be reloaded and ssl_passphrase_command called during a server configuration reload. @@ -1169,12 +1244,14 @@ same commits as above --> - Add server variable toast_tuple_target to control the minimum length - before TOAST storage will be considered for new rows (Simon Riggs) + Add server variable toast_tuple_target + to control the minimum length before TOAST + storage will be considered for new rows (Simon Riggs) - The default TOAST threshold has not been changed. + The default TOAST threshold has not been + changed. @@ -1184,7 +1261,8 @@ same commits as above --> - Allow bytes to be specified for server variable sizes (Beena Emerson) + Allow bytes to be specified for server variable sizes (Beena + Emerson) @@ -1208,7 +1286,8 @@ same commits as above --> - Allow the WAL file size to be set via initdb (Beena Emerson) + Allow the WAL file size to be set via initdb + (Beena Emerson) @@ -1222,11 +1301,13 @@ same commits as above --> - No longer retain WAL that spans two checkpoints (Simon Riggs) + No longer retain WAL that spans two checkpoints + (Simon Riggs) - The retention of WAL records for only one checkpoint is required. + The retention of WAL records for only one + checkpoint is required. @@ -1236,8 +1317,9 @@ same commits as above --> - Fill the unused portion of force-switched WAL segment files with zeros - for improved compressibility (Chapman Flack) + Fill the unused portion of force-switched WAL + segment files with zeros for improved compressibility (Chapman + Flack) @@ -1260,8 +1342,8 @@ same commits as above --> - Replicate TRUNCATE activity when using logical replication (Simon Riggs, - Marco Nenciarini, Peter Eisentraut) + Replicate TRUNCATE activity when using logical + replication (Simon Riggs, Marco Nenciarini, Peter Eisentraut) @@ -1271,8 +1353,8 @@ same commits as above --> - Pass prepared transaction information to logical replication subscribers - (Nikhil Sontakke, Stas Kelvich) + Pass prepared transaction information to logical replication + subscribers (Nikhil Sontakke, Stas Kelvich) @@ -1283,8 +1365,8 @@ same commits as above --> - Exclude unlogged and temporary tables from streaming base backups (David - Steele) + Exclude unlogged and temporary tables from streaming base backups + (David Steele) @@ -1298,8 +1380,8 @@ same commits as above --> - Allow heap pages checksums to be checked during streaming base backup - (Michael Banck) + Allow heap pages checksums to be checked during streaming base + backup (Michael Banck) @@ -1309,13 +1391,14 @@ same commits as above --> - Allow replication slots to be advanced programatically, rather than be - consumed by subscribers (Petr Jelinek) + Allow replication slots to be advanced programatically, rather + than be consumed by subscribers (Petr Jelinek) - This allows efficient advancement replication slots when the contents do - not need to be consumed. This is performed by pg_replication_slot_advance(). + This allows efficient advancement replication slots when the + contents do not need to be consumed. This is performed by + pg_replication_slot_advance(). @@ -1325,12 +1408,13 @@ same commits as above --> - Add timeline information to the backup_label file (Simon Riggs) + Add timeline information to the backup_label + file (Simon Riggs) - Also add a check that the WAL timeline matches the backup_label file's - timeline. + Also add a check that the WAL timeline matches + the backup_label file's timeline. @@ -1340,8 +1424,9 @@ same commits as above --> - Add host and port connection information to the pg_stat_wal_receiver - system view (Haribabu Kommi) + Add host and port connection information to the + pg_stat_wal_receiver system view + (Haribabu Kommi) @@ -1351,8 +1436,8 @@ same commits as above --> - Document that pg_internal.init files do not need to be included in the - base backup (David Steele) + Document that pg_internal.init files do not + need to be included in the base backup (David Steele) @@ -1373,15 +1458,16 @@ same commits as above --> - Add window function features to complete SQL:2011 compliance (Oliver - Ford, Tom Lane) + Add window function features to complete SQL:2011 compliance + (Oliver Ford, Tom Lane) - Specifically, allow RANGE mode to use PRECEDING and FOLLOWING to specify - peer groups with values plus or minus the specified offset. Add - GROUPS mode to include plus or minus the number of peer groups. Frame - exclusion syntax was also added. + Specifically, allow RANGE mode to use + PRECEDING and FOLLOWING to + specify peer groups with values plus or minus the specified offset. + Add GROUPS mode to include plus or minus the + number of peer groups. Frame exclusion syntax was also added. @@ -1401,8 +1487,8 @@ same commits as above --> - Allow NOT NULL to be added to columns without requiring a table rewrite - (Andrew Dunstan, Serge Rielau) + Allow NOT NULL to be added to columns without + requiring a table rewrite (Andrew Dunstan, Serge Rielau) @@ -1413,7 +1499,8 @@ same commits as above --> - Allow views to be locked by locking the underlying tables (Yugo Nagata) + Allow views to be locked by locking the underlying tables + (Yugo Nagata) @@ -1423,12 +1510,13 @@ same commits as above --> - Allow ALTER INDEX to set statistics-gathering targets for expression - indexes (Alexander Korotkov, Adrien nayrat) + Allow ALTER INDEX to set statistics-gathering + targets for expression indexes (Alexander Korotkov, Adrien nayrat) - In psql, \d+ now shows the statistics target for indexes. + In psql, \d+ now shows the statistics + target for indexes. @@ -1438,13 +1526,16 @@ same commits as above --> - Allow multiple tables to be specified in one VACUUM or ANALYZE command + Allow multiple tables to be specified in one + VACUUM or ANALYZE command (Nathan Bossart) - Also, if any table mentioned in VACUUM uses a column list, then ANALYZE - keyword must be supplied; previously ANALYZE was implied in such cases. + Also, if any table mentioned in VACUUM uses + a column list, then ANALYZE keyword must be + supplied; previously ANALYZE was implied in + such cases. @@ -1454,11 +1545,13 @@ same commits as above --> - Add parenthesized options syntax to ANALYZE (Nathan Bossart) + Add parenthesized options syntax to ANALYZE + (Nathan Bossart) - This is similar to the syntax supported by VACUUM. + This is similar to the syntax supported by + VACUUM. @@ -1469,13 +1562,13 @@ same commits as above --> - Add CREATE AGGREGATE option to specify the behavior of the aggregate - finalization function (Tom Lane) + Add CREATE AGGREGATE option to specify the + behavior of the aggregate finalization function (Tom Lane) - This is useful for allowing aggregate functions be optimized and to work - as window functions. + This is useful for allowing aggregate functions be optimized and + to work as window functions. @@ -1499,7 +1592,8 @@ same commits as above - This also allows array_agg() to be used on domains. + This also allows array_agg() to be used + on domains. @@ -1516,8 +1610,9 @@ same commits as above - Also allow PL/PL/Perl, PL/Python, and PL/Tcl to handle composite-domain - function arguments and results. Also improve PL/Python domain handling. + Also allow PL/PL/Perl, PL/Python, and PL/Tcl to handle + composite-domain function arguments and results. Also improve + PL/Python domain handling. @@ -1548,11 +1643,14 @@ same commits as above --> - Add SHA-2 family of hash functions (Peter Eisentraut) + Add SHA-2 family of hash functions (Peter + Eisentraut) - Specifically, sha224(), sha256(), sha384(), sha512() were added. + Specifically, sha224(), + sha256(), sha384(), + sha512() were added. @@ -1562,7 +1660,8 @@ same commits as above --> - Add support for 64-bit non-cryptographic hash functions (Robert Haas, Amul Sul) + Add support for 64-bit non-cryptographic hash functions (Robert + Haas, Amul Sul) @@ -1572,17 +1671,22 @@ same commits as above --> - Allow to_char() and to_timestamp() to specify the time zone's hours and - minutes from UTC (Nikita Glukhov, Andrew Dunstan) + Allow to_char() and + to_timestamp() to specify the time zone's + hours and minutes from UTC (Nikita Glukhov, + Andrew Dunstan) - This is done with format specifications TZH and TZM. - + This is done with format specifications TZH + and TZM. + + + + - Improve the speed of aggregate computations (Andres Freund) @@ -1595,9 +1699,10 @@ same commits as above --> - Add text search function websearch_to_tsquery() that supports a queries - syntax similar to that used by web search engines (Victor Drobny, Dmitry - Ivanov) + Add text search function + websearch_to_tsquery() that supports a queries + syntax similar to that used by web search engines (Victor Drobny, + Dmitry Ivanov) @@ -1607,8 +1712,9 @@ same commits as above --> - Add functionjson(b)_to_tsvector to create usable text search queries - matching JSON/JSONB values (Dmitry Dolgov) + Add function json(b)_to_tsvector() to create + text search query for matching JSON/JSONB + values (Dmitry Dolgov) @@ -1631,14 +1737,16 @@ same commits as above --> - Add SQL procedures, which can start and commit their own transactions + Add SQL procedures, which can start and commit their own + transactions (Peter Eisentraut) - They are created with the new CREATE PROCEDURE command and invoked via - CALL. The new ALTER/DROP ROUTINE commands allows altering/dropping of - procedures, functions, and aggregates. + They are created with the new CREATE PROCEDURE + command and invoked via CALL. The new + ALTER/DROP ROUTINE commands + allows altering/dropping of procedures, functions, and aggregates. @@ -1651,14 +1759,16 @@ same commits as above --> - Add transaction control to PL/pgSQL, PL/Perl, PL/Python, PL/Tcl, and SPI - server-side languages (Peter Eisentraut) + Add transaction control to PL/pgSQL, PL/Perl, PL/Python, PL/Tcl, + and SPI server-side languages (Peter Eisentraut) - Transaction control is only available to top-transaction-level CALLs or - in nested PL/pgSQL DO and CALL blocks that only contain other PL/pgSQL - DO and CALL blocks. ACCURATE? + Transaction control is only available to top-transaction-level + CALLs or in nested PL/pgSQL DO and + CALL blocks that only contain other PL/pgSQL + DO and CALL blocks. + ACCURATE? @@ -1668,8 +1778,8 @@ same commits as above --> - Add the ability to define PL/pgSQL record types as not null, constant, or - with initial values (Tom Lane) + Add the ability to define PL/pgSQL record types as not null, + constant, or with initial values (Tom Lane) @@ -1679,8 +1789,9 @@ same commits as above --> - Add extension jsonb_plpython to transform JSONB to/from PL/Python - types (Anthony Bykov) + Add extension jsonb_plpython to + transform JSONB to/from PL/Python types (Anthony + Bykov) @@ -1690,8 +1801,8 @@ same commits as above --> - Add extension jsonb_plpython to transform JSONB to/from PL/Perl types - (Anthony Bykov) + Add extension jsonb_plperl to + transform JSONB to/from PL/Perl types (Anthony Bykov) @@ -1730,23 +1841,24 @@ same commits as above - Compression is already disabled in modern OpenSSL versions and the libpq - setting had no effect in that case. + Compression is already disabled in modern OpenSSL versions and + the libpq setting had no effect in that case. - Add DO CONTINUE action to the ECPG WHENEVER statement (Vinayak Pokale) + Add DO CONTINUE action to the ECPG + WHENEVER statement (Vinayak Pokale) - This generates a C 'continue' statement, causing a return to the top of - the contained loop when the specified condition occurs. + This generates a C 'continue' statement, causing a return to the + top of the contained loop when the specified condition occurs. @@ -1760,7 +1872,7 @@ same commits as above - This mode is enabled with -C. + This mode is enabled with . @@ -1783,8 +1895,8 @@ same commits as above --> - Add psql command \gdesc to display the column names and types of the - query output (Pavel Stehule) + Add psql command \gdesc to display + the column names and types of the query output (Pavel Stehule) @@ -1794,12 +1906,15 @@ same commits as above --> - Add psql variables to report query activity and errors (Fabien Coelho) + Add psql variables to report query + activity and errors (Fabien Coelho) - Specifically, the new variables are ERROR, SQLSTATE, ROW_COUNT, - LAST_ERROR_MESSAGE, and LAST_ERROR_SQLSTATE. + Specifically, the new variables are ERROR, + SQLSTATE, ROW_COUNT, + LAST_ERROR_MESSAGE, and + LAST_ERROR_SQLSTATE. @@ -1809,12 +1924,13 @@ same commits as above --> - Allow psql to test for the existence of a variable (Fabien Coelho) + Allow psql to test for the existence + of a variable (Fabien Coelho) - Specifically , the syntax :{?variable_name} allows a variable's - existence to be tested in an \if statement. + Specifically , the syntax :{?variable_name} + allows a variable's existence to be tested in an \if statement. @@ -1824,13 +1940,15 @@ same commits as above --> - Add PSQL_PAGER to control psql's pager (Pavel Stehule) + Add PSQL_PAGER to control + psql's pager (Pavel Stehule) - This allows psql's default pager to be specified as a separate environment - variable from the pager for other applications. PAGER is still honored - if PSQL_PAGER is not set. + This allows psql's default pager to + be specified as a separate environment variable from the pager + for other applications. PAGER is still honored + if PSQL_PAGER is not set. @@ -1840,12 +1958,13 @@ same commits as above --> - Have psql \d+ show a partition count of zero (Amit Langote) + Have psql \d+ show a partition count + of zero (Amit Langote) - Previously no partition information would be displayed for such tables. - Also indicate which partitions are themselves partitioned. + Previously no partition information would be displayed for such + tables. Also indicate which partitions are themselves partitioned. ACCURATE? @@ -1856,14 +1975,15 @@ same commits as above --> - Have psql report the proper user name before the password prompt (Tom - Lane) + Have psql report the proper user name + before the password prompt (Tom Lane) - Previously, combinations of -U and a user name embedded in a URI caused - incorrect reporting. Also suppress the user name before the password - prompt when --password is specified. + Previously, combinations of and a user name + embedded in a URI caused incorrect reporting. + Also suppress the user name before the password prompt when + is specified. @@ -1873,13 +1993,13 @@ same commits as above --> - Allow 'quit' and 'exit' to exit psql when used in an empty buffer (Bruce - Momjian) + Allow 'quit' and 'exit' to exit psql + when used in an empty buffer (Bruce Momjian) - Also add hints of how to exit when 'quit' and 'exit' are used alone on a - line in a non-empty buffer. Add a similar hint for 'help'. + Also add hints of how to exit when 'quit' and 'exit' are used alone + on a line in a non-empty buffer. Add a similar hint for 'help'. @@ -1889,8 +2009,8 @@ same commits as above --> - Have psql hint at using control-D when \q is entered alone on a line but - ignored (Bruce Momjian) + Have psql hint at using control-D when + \q is entered alone on a line but ignored (Bruce Momjian) @@ -1904,7 +2024,8 @@ same commits as above --> - Improve tab-completion for ALTER INDEX RESET/SET (Masahiko Sawada) + Improve tab-completion for ALTER INDEX + RESET/SET (Masahiko Sawada) @@ -1914,8 +2035,9 @@ same commits as above --> - Add infrastructure to allow psql to customize tab completion queries - based on the server version (Tom Lane) + Add infrastructure to allow psql + to customize tab completion queries based on the server version + (Tom Lane) @@ -1939,7 +2061,8 @@ same commits as above --> - Add major scripting features to pgbench (Fabien Coelho) + Add pgbench expressions support for NULLs, booleans, and some + functions and operators (Fabien Coelho) @@ -1949,7 +2072,7 @@ same commits as above --> - Add \if macro support to pgbench (Fabien Coelho) + Add \if conditional support to pgbench (Fabien Coelho) @@ -1959,8 +2082,8 @@ same commits as above --> - Allow the use of non-ASCII characters in pgbench variable names (Fabien - Coelho) + Allow the use of non-ASCII characters in + pgbench variable names (Fabien Coelho) @@ -1970,8 +2093,8 @@ same commits as above --> - Add pgbench option --init-steps to control the initialization steps - performed (Masahiko Sawada) + Add pgbench option to control the + initialization steps performed (Masahiko Sawada) @@ -1981,8 +2104,8 @@ same commits as above --> - Add approximated Zipfian-distributed random generator to pgbench (Alik - Khilazhev) + Add approximated Zipfian-distributed random generator to pgbench + (Alik Khilazhev) @@ -2002,8 +2125,9 @@ same commits as above --> - Allow pgbench to do exponentiation with pow() and power() (Raúl - Marín Rodríguez) + Allow pgbench to do exponentiation with pow() + and power() (Raúl Marín + Rodríguez) @@ -2024,8 +2148,9 @@ same commits as above --> - Make pgbench statistics more accurate when using --latency-limit and - --rate (Fabien Coelho) + Make pgbench statistics more accurate when using + and + (Fabien Coelho) @@ -2047,16 +2172,20 @@ same commits as above --> - Add pg_basebackup option to create a named replication slot (Michael Banck) + Add pg_basebackup option to create a + named replication slot (Michael Banck) - The option --create-slot creates the named replication slot (--slot) - when the WAL streaming method (-wal-method=stream) is used. + The option creates + the named replication slot () + when the WAL streaming method + () is used. - IS IT CLEAR FROM THE DOCS THAT THE REPLICATION SLOT IS NOT TEMPORARY? + IS IT CLEAR FROM THE DOCS THAT THE REPLICATION SLOT IS NOT + TEMPORARY? @@ -2066,15 +2195,17 @@ same commits as above --> - Allow initdb to set group read access to the data directory (David - Steele) + Allow initdb to set group read access to the data directory + (David Steele) - This is accomplished with the initdb --allow-group-access flag. - Administrators can also set group permissions on the empty data - directory before running initdb. Server variable data_directory_mode - allows reading of data directory group permissions. + This is accomplished with the initdb + flag. Administrators + can also set group permissions on the empty data + directory before running initdb. Server variable + data_directory_mode allows reading of data + directory group permissions. @@ -2085,8 +2216,8 @@ same commits as above --> - Add pg_verify_checksums tool to verify database checksums while offline - (Magnus Hagander) + Add pg_verify_checksums tool to verify + database checksums while offline (Magnus Hagander) @@ -2096,8 +2227,9 @@ same commits as above --> - Allow pg_resetwal to change the WAL segment size via --wal-segsize (Nathan - Bossart) + Allow pg_resetwal to + change the WAL segment size via + (Nathan Bossart) @@ -2107,7 +2239,8 @@ same commits as above --> - Add long options to pg_resetwal and pg_controldata (Nathan Bossart, + Add long options to pg_resetwal + and pg_controldata (Nathan Bossart, Peter Eisentraut) @@ -2118,8 +2251,9 @@ same commits as above --> - Add pg_receivewal option --no-sync to prevent synchronous WAL writes - (Michael Paquier) + Add pg_receivewal option + to prevent synchronous + WAL writes (Michael Paquier) @@ -2129,8 +2263,9 @@ same commits as above --> - Add pg_receivewal option --endpos to specify when WAL receiving should - stop (Michael Paquier) + Add pg_receivewal option + to specify when WAL + receiving should stop (Michael Paquier) @@ -2140,7 +2275,8 @@ same commits as above --> - Allow pg_ctl to send the SIGKILL signal to processes (Andres Freund) + Allow pg_ctl to send the + SIGKILL signal to processes (Andres Freund) @@ -2154,7 +2290,8 @@ same commits as above --> - Reduce the number of files copied by pg_rewind (Michael Paquier) + Reduce the number of files copied by + pg_rewind (Michael Paquier) @@ -2164,7 +2301,8 @@ same commits as above --> - Prevent pg_rewind from running as root (Magnus Hagander) + Prevent pg_rewind from running as + root (Magnus Hagander) @@ -2184,11 +2322,12 @@ same commits as above --> - Add pg_dumpall option --encoding to control encoding (Michael Paquier) + Add pg_dumpall option + to control encoding (Michael Paquier) - pg_dump already had this option. + pg_dump already had this option. @@ -2198,14 +2337,17 @@ same commits as above --> - Add pg_dump option --load-via-partition-root to force loading of data - into the partition's root table, rather than the original partitions + Add pg_dump option + to force loading of + data into the partition's root table, rather than the original + partitions (Rushabh Lathia) This is useful if the system to be loaded has a different collation - definitions or endianness, requiring the rows to be stored in different partitions. + definitions or endianness, requiring the rows to be stored in + different partitions. @@ -2215,11 +2357,15 @@ same commits as above --> - Add ability to suppress dumping and restoring of comments (Robins Tharakan) + Add ability to suppress dumping and restoring of comments + (Robins Tharakan) - The new pg_dump, pg_dumpall, and pg_restore option is --no-comments. + The new pg_dump, + pg_dumpall, and + pg_restore option is + . @@ -2241,8 +2387,8 @@ same commits as above --> - Add support for with huge(large) pages on Windows (Takayuki Tsunakawa, - Thomas Munro) + Add support for with huge(large) pages on Windows (Takayuki + Tsunakawa, Thomas Munro) @@ -2252,7 +2398,8 @@ same commits as above --> - Add support for ARMv8 hardware CRC calculations (Yuqi Gu, Heikki Linnakangas) + Add support for ARMv8 hardware + CRC calculations (Yuqi Gu, Heikki Linnakangas) @@ -2262,7 +2409,8 @@ same commits as above --> - Add configure flag --with-llvm to test for LLVM support (Andres Freund) + Add configure flag to test for + LLVM support (Andres Freund) @@ -2272,8 +2420,8 @@ same commits as above --> - Have configure check for the availability of a C++ compiler (Andres - Freund) + Have configure check for the availability of a C++ compiler + (Andres Freund) @@ -2286,13 +2434,13 @@ same commits as above --> - Convert documentation to DocBook XML (Peter Eisentraut, Alexander - Lakhin, Jürgen Purtz) + Convert documentation to DocBook XML (Peter + Eisentraut, Alexander Lakhin, Jürgen Purtz) - The file names still use an 'sgml' extension for compatibility with back - branches. + The file names still use an 'sgml' extension for compatibility + with back branches. @@ -2304,8 +2452,8 @@ same commits as above --> - Overhaul the way system tables are defined for bootstrap use (John - Naylor) + Overhaul the way system tables are defined for bootstrap use + (John Naylor) @@ -2315,8 +2463,8 @@ same commits as above --> - Allow background workers to attach to databases that normally disallow - connections (Magnus Hagander) + Allow background workers to attach to databases that normally + disallow connections (Magnus Hagander) @@ -2326,7 +2474,8 @@ same commits as above --> - Speed up lookups of builtin function names matching oids (Andres Freund) + Speed up lookups of builtin function names matching oids (Andres + Freund) @@ -2375,7 +2524,9 @@ same commits as above --> - Make the computation of system column pg_class.reltuples consistent + Make the computation of system column + pg_class.reltuples + consistent (Tomas Vondra) @@ -2400,8 +2551,8 @@ same commits as above - Replacement sorts were determined to be no longer useful. Also remove - server variable replacement sorts. + Replacement sorts were determined to be no longer useful. + Also remove server variable replacement sorts. @@ -2421,14 +2572,16 @@ same commits as above --> - Allow extension pg_prewarm to restore the previous shared buffer - contents on startup (Mithun Cy, Robert Haas) + Allow extension pg_prewarm to restore + the previous shared buffer contents on startup (Mithun Cy, + Robert Haas) - This is accomplished by having pg_prewarm store the shared buffer - relation/offset values to disk occasionally during server operation and - shutdown. + This is accomplished by having + pg_prewarm store the shared buffer + relation/offset values to disk occasionally during server operation + and shutdown. @@ -2438,14 +2591,15 @@ same commits as above --> - Add pgtrgm function strict_word_similarity() to compute the similarity - of whole words (Alexander Korotkov) + Add pgtrgm function strict_word_similarity() + to compute the similarity of whole words (Alexander Korotkov) - The function word_similarity() already existed for this purpose, but it - was designed to find similar parts of words, while - strict_word_similarity() computes the similarity to whole words. + The function word_similarity() already + existed for this purpose, but it was designed to find similar + parts of words, while strict_word_similarity() + computes the similarity to whole words. @@ -2455,13 +2609,13 @@ same commits as above --> - Allow creation of indexes on citext-extension columns that can be used - by LIKE comparisons (Alexey Chernyshov) + Allow creation of indexes on citext-extension columns that can + be used by LIKE comparisons (Alexey Chernyshov) - Specifically, indexes must be created using the citext_pattern_ops - operator class. + Specifically, indexes must be created using the + citext_pattern_ops operator class. @@ -2471,8 +2625,9 @@ same commits as above --> - Allow btree_gin to index bool, bpchar, name and uuid data types (Matheus - Oliveira) + Allow btree_gin to index + bool, bpchar, name and + uuid data types (Matheus Oliveira) @@ -2482,8 +2637,8 @@ same commits as above --> - Allow cube and seg extensions using GiST indexes to perform index-only - scans (Andrey Borodin) + Allow cube and seg extensions using GiST indexes to perform + index-only scans (Andrey Borodin) @@ -2493,8 +2648,8 @@ same commits as above --> - Allow retrieval of negative cube coordinates using the ~> operator - (Alexander Korotkov) + Allow retrieval of negative cube coordinates using the ~> + operator (Alexander Korotkov) @@ -2508,7 +2663,8 @@ same commits as above --> - Add Vietnamese letter detection to the unaccent extension (Dang Minh Huong, Michael Paquier) + Add Vietnamese letter detection to the unaccent extension (Dang + Minh Huong, Michael Paquier) @@ -2518,7 +2674,8 @@ same commits as above --> - Enhance contrib/amcheck to check that each heap tuple has an index entry + Enhance contrib/amcheck to check that each heap tuple has an + index entry (Peter Geoghegan) @@ -2534,8 +2691,8 @@ same commits as above - Previously only super-users could call adminpack functions; now role - permissions are checked. + Previously only super-users could call adminpack functions; + now role permissions are checked. @@ -2545,12 +2702,13 @@ same commits as above --> - Increase pg_stat_statement's query id to 64 bits (Robert Haas) + Increase pg_stat_statement's query id + to 64 bits (Robert Haas) - This greatly reduces the chance of query id hash collisions. The query - id can now potentially display as a negative value. + This greatly reduces the chance of query id hash collisions. + The query id can now potentially display as a negative value. @@ -2560,8 +2718,8 @@ same commits as above --> - Install errcodes.txt to provide access to the error codes reported by - Postgres (Thomas Munro) + Install errcodes.txt to provide access to the error codes reported + by PostgreSQL (Thomas Munro) @@ -2571,8 +2729,8 @@ same commits as above --> - Prevent extensions from creating custom server variables that take a - quoted list of values (Tom Lane) + Prevent extensions from creating custom server variables that + take a quoted list of values (Tom Lane) @@ -2586,8 +2744,8 @@ same commits as above --> - Remove contrib/start-scripts/osx since they are no longer recommended - (Tom Lane) + Remove contrib/start-scripts/osx since they are no longer + recommended (Tom Lane) @@ -2601,8 +2759,8 @@ same commits as above - This extension no longer served as a usable security tool or example of - how to write an extension. + This extension no longer served as a usable security tool or + example of how to write an extension. -- 2.39.5