From a31ac2d008be063e64d45df6ce9e41e5cab0d3b7 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sun, 29 Mar 2009 03:58:37 +0000 Subject: [PATCH] More release note markup. --- doc/src/sgml/release.sgml | 338 ++++++++++++++++++++------------------ 1 file changed, 181 insertions(+), 157 deletions(-) diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index c2b2b8b777..482d21c5c8 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -166,46 +166,46 @@ do it for earlier branch release files. - This change was made because some users wanted a constant log - filename, for use with an external log rotation tool. + This change was made because some users wanted a fixed filename, + for use with an external log rotation tool. - Remove explain_pretty_print postgresql.conf setting + Remove explain_pretty_print postgresql.conf setting (no longer needed) (Tom) - Remove log_restartpoints from recovery.conf; - instead use log_checkpoints (Simon Riggs) + Remove log_restartpoints from recovery.conf; + instead use log_checkpoints (Simon Riggs) - Remove support for the (insecure) crypt authentication method + Remove support for the (insecure) crypt authentication method (Magnus) - This breaks compatibility with pre-7.2 versions. + This breaks compatibility with pre-PostgreSQL 7.2 versions. - Remove krb_realm and krb_server_hostname, now + Remove krb_realm and krb_server_hostname, now pg_hba.conf-only settings (Magnus) - Remove ipcclean utility command (Bruce) + Remove ipcclean utility command (Bruce) @@ -216,8 +216,8 @@ do it for earlier branch release files. - pg_hba.conf also has extensive changes related to - migration. bjm: add markup + The pg_hba.conf section below also has extensive + changes related to migration. @@ -301,7 +301,7 @@ do it for earlier branch release files. - This was already the float8 behavior. + This was already the float8 behavior. @@ -312,15 +312,15 @@ do it for earlier branch release files. - The changed behavior is more IEEE-standards - compliant. + The changed behavior is more IEEE-standards + compliant. Throw an error if an escape character is the last character in - a LIKE pattern (it has nothing to escape) (Tom) + a LIKE pattern (there is nothing to escape) (Tom) @@ -354,6 +354,11 @@ do it for earlier branch release files. (BC/AD) format designations (Brendan Jurd) + + + For example, input value ad now matches the format + string AD. + @@ -365,29 +370,31 @@ do it for earlier branch release files. - For example, input value AD does not match format - string A.D.. + For example, input value AD now does not match + format string A.D.. - DateStyle no longer controls interval output (use new variable - IntervalStyle) + DateStyle no longer controls INTERVAL + output (use new variable IntervalStyle) - Remove ~=~ and ~<>~ operators used for LIKE - index comparisons (Tom) bjm: needed? + Remove ~=~ and ~<>~ operators + used for LIKE index comparisons (Tom) bjm: needed, + pg_upgrade impact? A not-immediately-obvious incompatibility is that the sort - order within bpchar_pattern_ops indexes changes --- it had been - identical to plain strcmp, but is now trailing-blank-insensitive. - This will impact in-place upgrades, if those ever happen. + order within bpchar_pattern_ops indexes changes + --- it had been identical to plain strcmp(), but + is now trailing-blank-insensitive. This will impact in-place + upgrades, if those ever happen. @@ -493,25 +500,27 @@ do it for earlier branch release files. - Increase the default value of default_statistics_target from - 10 to 100 (Greg Sabino Mullane, Tom) + Increase the default value of default_statistics_target + from 10 to 100 (Greg Sabino Mullane, + Tom) - The maximum value was also increased from 1000 to 10000. + The maximum value was also increased from 1000 to + 10000. - Modify 'constraint_exclusion' to check for partitioned tables - by default when inheritance or UNION ALL is used - (Tom) + Modify constraint_exclusion to check for partitioned + tables by default when inheritance or UNION ALL is + used (Tom) - A new constraint_exclusion setting, partition, was - added to match this behavior. + A new constraint_exclusion setting, + partition, was added to match this behavior. @@ -521,9 +530,9 @@ do it for earlier branch release files. - The amount of read-ahead is controlled by effective_io_concurrency. - This requires posix_fadvise() support in the - kernel. + The amount of read-ahead is controlled by + effective_io_concurrency. This requires + posix_fadvise() support in the kernel. @@ -581,9 +590,10 @@ do it for earlier branch release files. - Add postgresql.conf setting cursor_tuple_fraction - to control the fraction of a cursor's rows expected to be - requested by the user (Robert Hell) + Add postgresql.conf setting + cursor_tuple_fraction to control the fraction of + a cursor's rows expected to be requested by the user (Robert + Hell) @@ -613,15 +623,15 @@ do it for earlier branch release files. Add pg_terminate_backend() to safely terminate a - backend (the SIGTERM signal also works) (Tom, Bruce) + backend (the SIGTERM signal works also) (Tom, Bruce) Add ability to track user-defined functions call counts and - runtimes via postgresql.conf variable 'track_functions' - (Martin Pihlak) + runtimes via postgresql.conf variable + track_functions (Martin Pihlak) @@ -635,7 +645,7 @@ do it for earlier branch release files. Allow specification of the maximum pg_stat_activity query string size via postgresql.conf variable - track_activity_query_size (Thomas Lee) + track_activity_query_size (Thomas Lee) @@ -648,8 +658,8 @@ do it for earlier branch release files. - Add read-only postgresql.conf variables segment_size, - wal_block_size, and wal_segment_size (Bernd Helmle) + Add read-only postgresql.conf variables segment_size, + wal_block_size, and wal_segment_size (Bernd Helmle) @@ -671,7 +681,7 @@ do it for earlier branch release files. Move the server statistics file into the subdirectory pg_stat_tmp and allow its location to be specified - via stats_temp_directory (Magnus) + via stats_temp_directory (Magnus) @@ -725,14 +735,15 @@ do it for earlier branch release files. - Previously this was only supported for ident authentication. + Previously this was only supported for ident + authentication. Allow ident authentication over Unix-domain sockets - on Solaris (Garick Hamlin) + on Solaris (Garick Hamlin) @@ -805,7 +816,7 @@ do it for earlier branch release files. Report appropriate error message for combination of MD5 - authentication and db_user_namespace enabled (Bruce) + authentication and db_user_namespace enabled (Bruce) @@ -818,8 +829,8 @@ do it for earlier branch release files. - Allow Kerberos/GSSAPI parameters to be changed - without restarting the postmaster (Magnus) + Allow Kerberos/GSSAPI parameters + to be changed without restarting the postmaster (Magnus) @@ -1088,12 +1099,12 @@ do it for earlier branch release files. Have ALTER TABLE SET WITHOUT OIDS rewrite the table - to remove oid values (Tom) + to remove OID values (Tom) Also, add ALTER TABLE SET WITH OIDS to rewrite the - table to add oids. + table to add OIDs. @@ -1205,7 +1216,7 @@ do it for earlier branch release files. Refactor multi-object DROP operations so conflicting - dependencies don't generate an error (Alex Hunsaker) + dependencies do not generate an error (Alex Hunsaker) @@ -1242,7 +1253,7 @@ do it for earlier branch release files. Allow CREATE OR REPLACE VIEW to add columns to the - end of the view (Robert Haas) + end of a view (Robert Haas) @@ -1261,15 +1272,15 @@ do it for earlier branch release files. - Previously EXPLAIN VERBOSE had output an internal + Previously EXPLAIN VERBOSE output an internal representation of the query plan. (That behavior is now - available via debug_print_plan.) + available via debug_print_plan.) - Have EXPLAIN honor debug_print_plan (Tom) + Have EXPLAIN honor debug_print_plan (Tom) @@ -1284,7 +1295,7 @@ do it for earlier branch release files. - Indexes + General Indexes @@ -1313,14 +1324,34 @@ do it for earlier branch release files. - Remove requirement to use @@@ when doing GIN - weighted lookups on full text indexes (Tom) + Special xxx_pattern_ops LIKE indexes can now be + used for simple equality comparisons (Tom) + + + + + + + + + Full Text Indexes + + + + + Remove the requirement to use @@@ when doing + GIN weighted lookups on full text indexes (Tom) + + + + The normal @@ text search operator can be used + instead. - Add optimizer selectivity function for @@ text + Add an optimizer selectivity function for @@ text search operations (Jan Urbanski) @@ -1345,13 +1376,6 @@ do it for earlier branch release files. - - - Special xxx_pattern_ops LIKE indexes can now be - used for simple equality comparisons (Tom) - - - @@ -1367,8 +1391,9 @@ do it for earlier branch release files. This allows the recording of all free space discovered by vacuum - in *.fsm files, rather than having to limit recording to a - fixed-sized shared memory area; max_fsm_pages and max_fsm_relations + in *.fsm files, rather than having to limit + recording to a fixed-sized shared memory area; + max_fsm_pages and max_fsm_relations settings have been removed. @@ -1398,9 +1423,10 @@ do it for earlier branch release files. - Add vacuum_freeze_table_age to postgresql.conf to - control when VACUUM should ignore the visibility - map and do a full table scan to set frozen xids (Heikki) + Add vacuum_freeze_table_age to + postgresql.conf to control when VACUUM + should ignore the visibility map and do a full table scan to + set frozen xids (Heikki) @@ -1505,15 +1531,15 @@ do it for earlier branch release files. - Previously these were interpreted as 1 BC. (Years + Previously these were interpreted as 1 BC; years 0 and 00 are assumed to be the year - 2000.) + 2000. - Include SGT (Singapore time) as a valid timezone + Include SGT (Singapore time) as a valid time zone abbreviation (Tom) @@ -1538,8 +1564,8 @@ do it for earlier branch release files. Formerly the precision had to be specified after the keyword - INTERVAL (the old syntax is still supported). Data - type definitions will now be output using the new format. + INTERVAL (this syntax is still supported). Data type + definitions will now be output using the new format. @@ -1551,22 +1577,22 @@ do it for earlier branch release files. - Add postgresql.conf variable IntervalStyle which - controls how interval values are output (Ron Mayer) + Add postgresql.conf variable IntervalStyle + which controls how INTERVAL values are output (Ron Mayer) Valid value are: postgres, postgres_verbose, sql_standard, iso_8601. This also - controls handling of negative INTERVAL input when only + controls the handling of negative INTERVAL input when only some fields have positive/negative designations. - Made interval seconds rounding more consistent across output - formats (Ron Mayer) + Make INTERVAL seconds rounding more consistent across + output formats (Ron Mayer) @@ -1587,14 +1613,14 @@ do it for earlier branch release files. This allows NULL ARRAY entries as long as - it is properly cast + they are properly cast. - Make the SQL ARRAY dimensions optional to - match the SQL standard (Peter) + Make SQL-syntax ARRAY dimensions optional + to match the SQL standard (Peter) @@ -1669,14 +1695,14 @@ do it for earlier branch release files. Document that setseed() allows values from - -1 to 1 (not 0 to + -1 to 1 (not just 0 to 1), and enforce the valid range (Kris Jurka) - Add server side lo_import(filename, oid) function + Add server side function lo_import(filename, oid) (Tatsuo) @@ -1749,7 +1775,7 @@ do it for earlier branch release files. Modify pg_relation_size() to handle free space - map (*.fsm) files (Heikki) + map (*.fsm) files (Heikki) @@ -1850,8 +1876,8 @@ do it for earlier branch release files. - Only trailing arguments can be of variable length, and they - all must be of the same data type. + Only trailing arguments can be optional, and they all must be + of the same data type. @@ -1891,27 +1917,27 @@ do it for earlier branch release files. - Support EXECUTE USING in PL/pgSQL (Pavel Stehule) + Support EXECUTE USING (Pavel Stehule) - Allow PL/pgSQL to loop over an open cursor using a FOR + Allow looping over an open cursor using a FOR loop (Pavel Stehule) - Support RETURN QUERY EXECUTE in PL/pgSQL (Pavel + Support RETURN QUERY EXECUTE (Pavel Stehule) - Improve the PL/pgSQL RAISE command (Pavel Stehule) + Improve the RAISE command: (Pavel Stehule) @@ -1945,7 +1971,7 @@ do it for earlier branch release files. - Allow the specification of SQLSTATE numeric codes + Allow specification of SQLSTATE numeric codes in EXCEPTION lists (Pavel Stehule) @@ -1956,21 +1982,20 @@ do it for earlier branch release files. - Support CASE statement in PL/pgSQL (Pavel Stehule) + Support the CASE statement (Pavel Stehule) - Add PL/PgSQL FOUND and GET DIAGNOSTICS - support for the RETURN QUERY - statement (Pavel Stehule) + Add FOUND and GET DIAGNOSTICS support + for the RETURN QUERY statement (Pavel Stehule) - Add PL/pgSQL translation (Alvaro) + Add message translation support (Alvaro) @@ -1984,50 +2009,49 @@ do it for earlier branch release files. - Remove psql startup banner; now just suggest help + Remove startup banner; now just suggest help (Joshua Drake) - Have psql help show common backslash commands (Greg + Have help show common backslash commands (Greg Sabino Mullane) - Add psql \pset format wrapped mode to wrap output - to screen width, or - file/pipe output too if \pset columns is set (Bryce - Nesbitt) + Add \pset format wrapped mode to wrap output to the + screen width, or file/pipe output too if \pset columns + is set (Bryce Nesbitt) - Use the psql pager for wide output (Bruce) + Use the pager for wide output (Bruce) - Require a space between a psql backslash command and the first + Require a space between a backslash command and the first argument (Bernd Helmle) - Display access control rights on multiple lines in psql (Brendan + Display access control rights on multiple lines (Brendan Jurd, Andreas Scherbaum) - Improve psql tab completion support for schema qualified and + Improve tab completion support for schema qualified and quoted identifiers (Greg Sabino Mullane) @@ -2041,32 +2065,32 @@ do it for earlier branch release files. - Add optional on/off argument to psql + Add optional on/off arguments for \timing (David Fetter) - Have psql \l show access privileges (Andrew Gilligan) + Have \l show access privileges (Andrew Gilligan) - Have psql \l+ show database sizes, if permissions + Have \l+ show database sizes, if permissions allow (Andrew Gilligan) - Add psql \ef command to edit function definitions + Add the \ef command to edit function definitions (Abhijit Menon-Sen) - \ef without a function names creates an empty + \ef without a function name creates an empty function template for editing. @@ -2081,21 +2105,21 @@ do it for earlier branch release files. - Have psql \d display references to this table as - a foreign-key constraint (Kenneth D'Souza) + Have \d show cases where this table is referenced + as a foreign-key constraint (Kenneth D'Souza) - Have psql \d show the value of sequence columns + Have \d show the value of sequence columns (Euler Taveira de Oliveira) - Add column storage type and other relation options to psql + Add column storage type and other relation options to the \d+ display (Gregory Stark, Euler Taveira de Oliveira) @@ -2103,49 +2127,49 @@ do it for earlier branch release files. - Show relation size in psql \d+ output (Dickson S. + Show relation size in \d+ output (Dickson S. Guedes) - Have all psql \d* commands show system objects only + Have all \d* commands show system objects only if S is specified (Greg Sabino Mullane) - psql \dt already behaved this way. + \dt already behaved this way. bjm: accuate? - Make psql \d and \dt consistent in + Make \d and \dt consistent in their display of system tables (Bruce) - Previously, \d pg_class would show pg_class while - \dt pg_class would not. + Previously, \d pg_class would show pg_class + while \dt pg_class would not. - Show enumerated values in psql's \dT+ (David Fetter) + Show enumerated values in \dT+ (David Fetter) - Allow psql \dC to accept wildcard patterns (Tom) + Allow \dC to accept wildcard patterns (Tom) - Allow psql \d* commands to work with versions of + Allow \d* commands to work with versions of PostgreSQL back to 7.4 (Guillaume Lelarge) @@ -2160,7 +2184,7 @@ do it for earlier branch release files. - Add --no-tablespaces option to + Add a --no-tablespaces option to pg_dump/pg_dumpall/pg_restore so dumps can be restored to clusters that have non-matching tablespace layouts (Gavin Roy) @@ -2174,7 +2198,7 @@ do it for earlier branch release files. - Use of the options does not throw an error, but it has no + Use of this option does not throw an error, but it has no effect. This option was removed because the version checks are considered necessary. @@ -2194,22 +2218,22 @@ do it for earlier branch release files. - Allows dumps to fail if unable to acquire shared lock within - the specified amount of time. + This allows dumps to fail if unable to acquire a shared lock + within the specified amount of time. Reorder pg_dump --data-only output - to dump primary-key tables referenced by foreign keys are dumped - before the foreign-key referencing tables (Tom) + to dump primary-key tables referenced by foreign keys before + the foreign-key referencing tables (Tom) This allows data loads when foreign keys are already present. - If circular references make this impossible, issue a - NOTICE. + If circular references make this impossible, a NOTICE + is issued. @@ -2223,8 +2247,8 @@ do it for earlier branch release files. - Allow pg_restore of a custom format archive to use multiple - concurrent connections to do the restore (Andrew) + Allow pg_restore of a custom format archive to + use multiple concurrent connections to do the restore (Andrew) @@ -2236,7 +2260,7 @@ do it for earlier branch release files. Add new pg_dump --binary-upgrade - flag to be used by binary upgrade utilities (Bruce) + option for use by binary upgrade utilities (Bruce) @@ -2286,13 +2310,13 @@ do it for earlier branch release files. Allow the OID to be specified when importing large - objects using libpq lo_import_with_oid() (Tatsuo) + objects using lo_import_with_oid() (Tatsuo) - Add events support to libpq (Andrew Chernow, Merlin Moncure) + Add events support (Andrew Chernow, Merlin Moncure) @@ -2303,14 +2327,14 @@ do it for earlier branch release files. - Improve libpq error handling to allow the return of multiple + Improve error handling to allow the return of multiple error messages as multi-line error reports (Magnus) - Have libpq PQexecParams() return + Have PQexecParams() return PGRES_EMPTY_QUERY for an empty query (Tom) @@ -2321,8 +2345,8 @@ do it for earlier branch release files. - Document how to avoid the libpq overhead of WSACleanup() - overhead on Windows (Andrew Chernow) + Document how to avoid the overhead of WSACleanup() + on Windows (Andrew Chernow) @@ -2336,30 +2360,30 @@ do it for earlier branch release files. - Fix libpq certificate validation for SSL connections + Fix certificate validation for SSL connections (Magnus) - libpq now verifies both the certificate and the name of the - server by default when making SSL connections. If - a root certificate is not available to use for verification, - SSL connections will fail. The sslverify - parameter can be used to disable the host and certificate - verification if required. + libpq now verifies both the certificate and + the name of the server by default when making SSL + connections. If a root certificate is not available to use for + verification, SSL connections will fail. The + sslverify parameter can be used to disable the host + and certificate verification if required. - Allow the file locations for libpq SSL certificates + Allow the file locations for client SSL certificates to be specified (Mark Woodward, Alvaro, Magnus) - Add libpq connection parameter sslverify to control + Add connection parameter sslverify to control the verification of the server's SSL certificate (Magnus) @@ -2391,7 +2415,7 @@ do it for earlier branch release files. - Add localization support for ecpg messages (Euler Taveira de + Add localization support for messages (Euler Taveira de Oliveira) @@ -2417,7 +2441,7 @@ do it for earlier branch release files. - Add SPI support for single-use plans with out-of-line + Add support for single-use plans with out-of-line parameters (Tom) -- 2.39.5