diff options
| -rw-r--r-- | doc/src/sgml/release.sgml | 611 |
1 files changed, 363 insertions, 248 deletions
diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index 7aad8c50ec6..4a731ce3603 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.461 2006/10/02 15:32:03 momjian Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.462 2006/10/07 02:18:34 momjian Exp $ --> <!-- Typical markup: @@ -95,9 +95,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Query language enhancements including <literal>RETURNING</literal> - values, multi-<literal>VALUES</literal>, support, and - self-joins for <command>DELETE</command> + Query language enhancements including <literal>RETURNING</literal> + values, multi-<literal>VALUES</literal>, support, and + self-joins for <command>DELETE</command> </para> </listitem> @@ -163,13 +163,15 @@ For new features, add links to the documentation sections. <listitem> <para> - Set <varname>escape_string_warning</> to <literal>on</> by - default (Bruce) + Set <link + linkend="guc-escape-string-warning"><varname>escape_string_warning</></link> + to <literal>on</> by default (Bruce) </para> <para> - This issues a warning if backslash escapes are used in - non-escape (non-<literal>E''</>) strings. + This issues a warning if backslash escapes are used in + <link linkend="sql-syntax-strings">non-escape (non-<literal>E''</>) + strings</link>. </para> </listitem> @@ -187,24 +189,26 @@ For new features, add links to the documentation sections. <listitem> <para> - Change the row constructor syntax (<literal>ROW(...)</>) - so that list elements <literal>foo.*</> will be expanded - to a list of their member fields, rather than creating a - nested rowtype field as formerly (Tom) + Change the <link linkend="sql-syntax-row-constructors">row + constructor syntax</link> (<literal>ROW(...)</>) so that + list elements <literal>foo.*</> will be expanded to a list + of their member fields, rather than creating a nested + rowtype field as formerly (Tom) </para> <para> - The new behavior is substantially more useful since it - allows, for example, triggers to check for data changes - with <literal>IF row(new.*) IS DISTINCT FROM row(old.*)</>. - The old behavior is still available by omitting <literal>.*</>. + The new behavior is substantially more useful since it + allows, for example, triggers to check for data changes + with <literal>IF row(new.*) IS DISTINCT FROM row(old.*)</>. + The old behavior is still available by omitting <literal>.*</>. </para> </listitem> <listitem> <para> - Make row comparisons follow <acronym>SQL</> standard - semantics and allow them to be used in index scans (Tom) + Make <link linkend="row-wise-comparison">row comparisons</link> + follow <acronym>SQL</> standard semantics and allow them + to be used in index scans (Tom) </para> <para> @@ -217,8 +221,8 @@ For new features, add links to the documentation sections. <listitem> <para> - Have <command>SET CONSTRAINT</> affect only one constraint - (Kris Jurka) + Have <link linkend="SQL-SET-CONSTRAINTS"><command>SET + CONSTRAINT</></link> affect only one constraint (Kris Jurka) </para> <para> @@ -256,8 +260,8 @@ For new features, add links to the documentation sections. <listitem> <para> - Change array concatenation to match documented behavior - (Tom) + Change <link linkend="functions-array">array concatenation</link> + to match documented behavior (Tom) </para> <para> @@ -268,8 +272,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Make command-line options of <application>postmaster</> and - <application>postgres</> identical (Peter) + Make command-line options of <application>postmaster</> + and <link linkend="app-postgres"><application>postgres</></link> + identical (Peter) </para> <para> @@ -293,8 +298,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Change <varname>log_duration</> to output even if the query - is not output (Tom) + Change <link + linkend="guc-log-duration"><varname>log_duration</></link> + to output even if the query is not output (Tom) </para> <para> @@ -305,9 +311,12 @@ For new features, add links to the documentation sections. <listitem> <para> - Have <function>to_char(time)</> and <function>to_char(interval)</> - treat <literal>'HH'</> and <literal>'HH12'</> as 12-hour - intervals. + Have <link + linkend="functions-formatting"><function>to_char(time)</></link> + and <link + linkend="functions-formatting"><function>to_char(interval)</></link> + treat <literal>'HH'</> and <literal>'HH12'</> as 12-hour + intervals. </para> <para> @@ -318,8 +327,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Zero unmasked bits in conversion from <type>INET</> to - <type>CIDR</> (Tom) + Zero unmasked bits in conversion from <link + linkend="datatype-inet"><type>INET</></link> to <link + linkend="datatype-inet"><type>CIDR</></link> (Tom) </para> </listitem> @@ -341,25 +351,27 @@ For new features, add links to the documentation sections. </para> <para> - This may eliminate the need to set unrealistically small - values of <varname>random_page_cost</>. If you have been - using a very small <varname>random_page_cost</>, please - recheck your test cases. + This may eliminate the need to set unrealistically small + values of <link + linkend="guc-random-page-cost"><varname>random_page_cost</></link>. + If you have been using a very small <varname>random_page_cost</>, + please recheck your test cases. </para> </listitem> <listitem> <para> - Change <application>libpq</> <function>PQdsplen()</> to - return a useful value (Martijn van Oosterhout) + Change <link linkend="libpq"><application>libpq</></link> + <function>PQdsplen()</> to return a useful value (Martijn + van Oosterhout) </para> </listitem> <listitem> <para> - Change <application>libpq</> <function>PQgetssl()</> to - return a <literal>void *</>, rather than <literal>SSL *</> - (Martijn van Oosterhout) + Change <link linkend="libpq"><application>libpq</></link> + <function>PQgetssl()</> to return a <literal>void *</>, + rather than <literal>SSL *</> (Martijn van Oosterhout) </para> <para> @@ -429,15 +441,19 @@ For new features, add links to the documentation sections. <listitem> <para> - Improve efficiency of <literal>IN</> (list-of-expressions) - clauses (Tom) + Improve efficiency of <link + linkend="functions-comparisons"><literal>IN</> + (list-of-expressions)</link> clauses (Tom) </para> </listitem> <listitem> <para> - Increase default values for <varname>shared_buffers</> and - <varname>max_fsm_pages</> (Andrew) + Increase default values for <link + linkend="guc-shared-buffers"><varname>shared_buffers</></link> + and <link + linkend="guc-max-fsm-pages"><varname>max_fsm_pages</></link> + (Andrew) </para> </listitem> @@ -462,8 +478,10 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <literal>FILLFACTOR</> to table and index creation - (ITAGAKI Takahiro) + Add <literal>FILLFACTOR</> to <link + linkend="SQL-CREATETABLE">table</> and <link + linkend="SQL-CREATEINDEX">index</> creation (ITAGAKI + Takahiro) </para> <para> @@ -501,8 +519,8 @@ For new features, add links to the documentation sections. <listitem> <para> - Allow the planner to reorder outer joins in some circumstances - (Tom) + Allow the planner to reorder <link linkend="queries-join">outer + joins</> in some circumstances (Tom) </para> <para> @@ -518,22 +536,28 @@ For new features, add links to the documentation sections. <listitem> <para> - Improve the optimizer statistics used by <literal>LIKE</>, - <literal>ILIKE</>, and regular expression operations (Tom) + Improve the optimizer statistics used by <link + linkend="functions-like"><literal>LIKE</></link>, <link + linkend="functions-like"><literal>ILIKE</></link>, and + <link linkend="functions-posix-regexp">regular expression + operations</link> (Tom) </para> </listitem> <listitem> <para> - Improve planning of joins to inherited tables and <literal>UNION - ALL</> views (Tom) + Improve planning of joins to <link linkend="ddl-inherit">inherited + tables</> and <link linkend="queries-union"><literal>UNION + ALL</></link> views (Tom) </para> </listitem> <listitem> <para> - Allow constraint exclusion to be applied to inherited - <command>UPDATE</> and <command>DELETE</> queries (Tom) + Allow <link linkend="guc-constraint-exclusion">constraint + exclusion</> to be applied to <link + linkend="ddl-inherit">inherited</> <command>UPDATE</> and + <command>DELETE</> queries (Tom) </para> <para> @@ -557,13 +581,15 @@ For new features, add links to the documentation sections. <listitem> <para> - Improve multicolumn <acronym>GiST</> indexing (Oleg, Teodor) + Improve multicolumn <link linkend="GiST"><acronym>GiST</></link> + indexing (Oleg, Teodor) </para> </listitem> <listitem> <para> - <acronym>GiST</> indexes now are clusterable (Teodor) + <link linkend="GiST"><acronym>GiST</></link> indexes now + are clusterable (Teodor) </para> </listitem> @@ -588,11 +614,12 @@ For new features, add links to the documentation sections. </para> <para> - This is valuable for keeping continuous archiving servers - in sync with the master. xlog file switching also happens - automatically during <function>pg_stop_backup()</>. This - ensures that continuous archiving servers have all xlog - files needed for recovery. + This is valuable for keeping continuous archiving servers + in sync with the master. xlog file switching also happens + automatically during <link + linkend="functions-admin"><function>pg_stop_backup()</></link>. + This ensures that continuous archiving servers have all + xlog files needed for recovery. </para> </listitem> @@ -602,10 +629,11 @@ For new features, add links to the documentation sections. </para> <para> - Add functions for interrogating the current xlog insertion - point and determining <acronym>WAL</> filenames from the - hex <acronym>WAL</> locations displayed by - <function>pg_stop_backup()</> and friends. + Add functions for interrogating the current xlog insertion + point and determining <acronym>WAL</> filenames from the + hex <acronym>WAL</> locations displayed by <link + linkend="functions-admin"><function>pg_stop_backup()</></link> + and friends. </para> </listitem> @@ -626,8 +654,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <varname>archive_timeout</> to force xlog file switches - at a given interval (Simon) + Add <link + linkend="guc-archive-timeout"><varname>archive_timeout</></link> + to force xlog file switches at a given interval (Simon) </para> <para> @@ -637,7 +666,8 @@ For new features, add links to the documentation sections. <listitem> <para> - Add native <acronym>LDAP</> authentication (Magnus Hagander) + Add native <link linkend="auth-ldap"><acronym>LDAP</></link> + authentication (Magnus Hagander) </para> <para> @@ -648,8 +678,10 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <literal>GRANT CONNECT ON DATABASE</>, to be used in - addition to <filename>pg_hba.conf</> (Gevik Babakhani) + Add <link linkend="sql-grant-description-objects"><literal>GRANT + CONNECT ON DATABASE</></link>, to be used in addition to + <link linkend="auth-pg-hba-conf"><filename>pg_hba.conf</></link> + (Gevik Babakhani) </para> <para> @@ -661,9 +693,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Add support for <acronym>SSL</> Certificate Revocation List - (<acronym>CRL</>) files, <filename>root.crl</> (Libor - Hohoš) + Add support for <link linkend="ssl-tcp"><acronym>SSL</> + Certificate Revocation List</link> (<acronym>CRL</>) files, + <filename>root.crl</> (Libor Hohoš) </para> <para> @@ -677,7 +709,9 @@ For new features, add links to the documentation sections. </para> <para> - <literal>pg_stat_activity</> now shows autovacuum activity. + <link + linkend="monitoring-stats-views-table"><literal>pg_stat_activity</></link> + now shows autovacuum activity. </para> </listitem> @@ -699,29 +733,34 @@ For new features, add links to the documentation sections. </para> <para> - These values now appear in the <literal>pg_stat_*_tables</> - system views, and are used by autovacuum. ? + These values now appear in the <link + linkend="monitoring-stats-views-table"><literal>pg_stat_*_tables</></link> + system views, and are used by autovacuum. ? </para> </listitem> <listitem> <para> - Improve performance of statistics monitoring, especially - <varname>stats_command_string</> (Tom, Bruce) + Improve performance of statistics monitoring, especially + <link + linkend="guc-stats-command-string"><varname>stats_command_string</></link> + (Tom, Bruce) </para> <para> - This release enables <varname>stats_command_string</> by - default, now that its overhead is minimal. This means - <literal>pg_stat_activity</> will now show all active queries - by default. + This release enables <varname>stats_command_string</> by + default, now that its overhead is minimal. This means + <link + linkend="monitoring-stats-views-table"><literal>pg_stat_activity</></link> + will now show all active queries by default. </para> </listitem> <listitem> <para> - Add a <literal>waiting</> column to <literal>pg_stat_activity</> - (Tom) + Add a <literal>waiting</> column to <link + linkend="monitoring-stats-views-table"><literal>pg_stat_activity</></link> + (Tom) </para> <para> @@ -732,9 +771,10 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <acronym>GUC</> variable <varname>update_process_title</> to - control whether the <application>ps</> display is updated - for every command, default to <literal>on</> (Bruce) + Add <acronym>GUC</> variable <link + linkend="guc-update-process-title"><varname>update_process_title</></link> + to control whether the <application>ps</> display is updated + for every command, default to <literal>on</> (Bruce) </para> </listitem> @@ -745,15 +785,17 @@ For new features, add links to the documentation sections. </para> <para> - You can now set <varname>shared_buffer</> to <literal>32000kB</>, - for example. + For example, you can now set <link + linkend="guc-shared-buffers"><varname>shared_buffer</></link> + to <literal>32000kB</>. </para> </listitem> <listitem> <para> - Add support for include directives in <filename>postgresql.conf</> - (Joachim Wieland) + Add support for <link linkend="config-setting">include + directives</> in <filename>postgresql.conf</> (Joachim + Wieland) </para> </listitem> @@ -779,8 +821,10 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <command>INSERT</>/<command>UPDATE</>/<command>DELETE</> - <literal>RETURNING</> (Jonah Harris, Tom) + Add <link linkend="SQL-INSERT"><command>INSERT</></link>/<link + linkend="SQL-UPDATE"><command>UPDATE</></link>/<link + linkend="SQL-DELETE"><command>DELETE</></link> + <literal>RETURNING</> (Jonah Harris, Tom) </para> <para> @@ -792,9 +836,10 @@ For new features, add links to the documentation sections. <listitem> <para> - Add support for multiple-row <literal>VALUES</> clauses as - part of <command>INSERT</> and <command>SELECT</> statements, - per SQL standard (Joe, Tom) + Add support for multiple-row <link + linkend="queries-values"><literal>VALUES</></link> clauses + as part of <command>INSERT</> and <command>SELECT</> + statements, per SQL standard (Joe, Tom) </para> <para> @@ -808,8 +853,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Allow <command>UPDATE</> and <command>DELETE</> to use an - alias for the target table (Atsushi Ogawa) + Allow <link linkend="SQL-UPDATE"><command>UPDATE</></link> + and <link linkend="SQL-DELETE"><command>DELETE</></link> + to use an alias for the target table (Atsushi Ogawa) </para> <para> @@ -821,8 +867,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Allow <command>UPDATE</> to set multiple columns with a - list of values (Susanne Ebrecht) + Allow <link linkend="SQL-UPDATE"><command>UPDATE</></link> + to set multiple columns with a list of values (Susanne + Ebrecht) </para> <para> @@ -844,8 +891,8 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <literal>CASCADE</> option to <command>TRUNCATE</> - (Joachim Wieland) + Add <link linkend="SQL-TRUNCATE"><literal>CASCADE</></link> + option to <command>TRUNCATE</> (Joachim Wieland) </para> <para> @@ -856,14 +903,16 @@ For new features, add links to the documentation sections. <listitem> <para> - Support <literal>FOR UPDATE</> and <literal>FOR SHARE</> - in the same command (Tom) + Support <literal>FOR UPDATE</> and <literal>FOR SHARE</> + in the same <link linkend="SQL-INSERT"><literal>SELECT</></link> + command (Tom) </para> </listitem> <listitem> <para> - Add <literal>IS NOT DISTINCT FROM</> (Pavel Stehule) + Add <link linkend="functions-comparisons"><literal>IS NOT + DISTINCT FROM</></link> (Pavel Stehule) </para> <para> @@ -876,9 +925,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Improve the length output used by - <literal>UNION</>/<literal>INTERSECT</>/<literal>EXCEPT</> - (Tom) + Improve the length output used by <link + linkend="queries-union"><literal>UNION</></link>/<literal>INTERSECT</>/<literal>EXCEPT</> + (Tom) </para> <para> @@ -889,8 +938,8 @@ For new features, add links to the documentation sections. <listitem> <para> - Allow <literal>ILIKE</> to work for multi-byte encodings - (Tom) + Allow <link linkend="functions-like"><literal>ILIKE</></link> + to work for multi-byte encodings (Tom) </para> <para> @@ -902,8 +951,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Enable <varname>standard_conforming_strings</> to be turned - <literal>on</> (Kevin Grittner) + Enable <link + linkend="guc-standard-conforming-strings"><varname>standard_conforming_strings</></link> + to be turned <literal>on</> (Kevin Grittner) </para> <para> @@ -916,15 +966,17 @@ For new features, add links to the documentation sections. <listitem> <para> - Add system view <literal>pg_prepared_statements</> to show - prepared statements (Joachim Wieland, Neil) + Add system view <link + linkend="view-pg-prepared-statements"><literal>pg_prepared_statements</></link> + to show prepared statements (Joachim Wieland, Neil) </para> </listitem> <listitem> <para> - Add system view <literal>pg_cursors</> to show open cursors - (Joachim Wieland, Neil) + Add system view <link + linkend="view-pg-cursors"><literal>pg_cursors</></link> to + show open cursors (Joachim Wieland, Neil) </para> <para> @@ -935,8 +987,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Support portal parameters in <command>EXPLAIN</> and - <command>EXECUTE</> (Tom) + Support portal parameters in <link + linkend="SQL-EXPLAIN"><command>EXPLAIN</></link> and <link + linkend="SQL-EXECUTE"><command>EXECUTE</></link> (Tom) </para> <para> @@ -947,9 +1000,10 @@ For new features, add links to the documentation sections. <listitem> <para> - If <acronym>SQL</>-level <command>PREPARE</> parameters - are unspecified, infer their types from the context of the - query (Neil) + If <acronym>SQL</>-level <link + linkend="SQL-PREPARE"><command>PREPARE</></link> parameters + are unspecified, infer their types from the context of the + query (Neil) </para> <para> @@ -986,8 +1040,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <literal>TABLESPACE</> clause to <command>CREATE TABLE - AS</> (Neil) + Add <literal>TABLESPACE</> clause to <link + linkend="SQL-CREATETABLEAS"><command>CREATE TABLE AS</></link> + (Neil) </para> <para> @@ -997,8 +1052,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <literal>ON COMMIT</> clause to <command>CREATE TABLE - AS</> (Neil) + Add <literal>ON COMMIT</> clause to <link + linkend="SQL-CREATETABLEAS"><command>CREATE TABLE AS</></link> + (Neil) </para> <para> @@ -1010,8 +1066,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <literal>INCLUDING CONSTRAINTS</> to <command>CREATE - TABLE LIKE</> (Greg Stark) + Add <literal>INCLUDING CONSTRAINTS</> to <link + linkend="SQL-CREATETABLE"><command>CREATE TABLE LIKE</></link> + (Greg Stark) </para> <para> @@ -1021,8 +1078,8 @@ For new features, add links to the documentation sections. <listitem> <para> - Allow the creation of placeholder (shell) types (Martijn van - Oosterhout) + Allow the creation of placeholder (shell) <link + linkend="SQL-CREATETYPE">types</link> (Martijn van Oosterhout) </para> <para> @@ -1035,7 +1092,8 @@ For new features, add links to the documentation sections. <listitem> <para> - Add new aggregate creation syntax (Tom) + Add new aggregate creation <link + linkend="SQL-CREATEAGGREGATE">syntax</> (Tom) </para> <para> @@ -1049,15 +1107,16 @@ For new features, add links to the documentation sections. <listitem> <para> - Aggregate functions now support multiple input parameters - (Sergey Koposov, Tom) + <link linkend="SQL-CREATEAGGREGATE">Aggregate functions</> + now support multiple input parameters (Sergey Koposov, Tom) </para> </listitem> <listitem> <para> - Add <command>CREATE</>/<command>ALTER ROLE PASSWORD NULL</>, - which removes the role's password (Peter) + Add <command>CREATE</>/<command>ALTER <link + linkend="SQL-CREATEROLE">ROLE PASSWORD NULL</link></>, + which removes the role's password (Peter) </para> </listitem> @@ -1075,15 +1134,16 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <literal>DROP OWNED</> to drop all objects owned by a - role (Alvaro) + Add <link linkend="SQL-DROP-OWNED"><literal>DROP OWNED</></link> + to drop all objects owned by a role (Alvaro) </para> </listitem> <listitem> <para> - Add <literal>REASSIGN OWNED</> to reassign ownership of - all objects owned by a role (Alvaro) + Add <link linkend="SQL-REASSIGN-OWNED"><literal>REASSIGN + OWNED</></link> to reassign ownership of all objects owned + by a role (Alvaro) </para> <para> @@ -1094,7 +1154,8 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <command>GRANT ON SEQUENCE</> syntax (Bruce) + Add <link linkend="SQL-GRANT"><command>GRANT ON SEQUENCE</></link> + syntax (Bruce) </para> <para> @@ -1106,9 +1167,10 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <literal>USAGE</> permission for sequences that allows - only <function>currval()</> and <function>nextval()</>, - not <function>setval()</> (Bruce) + Add <link linkend="SQL-GRANT"><literal>USAGE</></link> + permission for sequences that allows only <function>currval()</> + and <function>nextval()</>, not <function>setval()</> + (Bruce) </para> <para> @@ -1121,7 +1183,8 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <literal>ALTER TABLE ... [ NO ] INHERIT</> (Greg Stark) + Add <link linkend="SQL-ALTERTABLE"><literal>ALTER TABLE + ... [ NO ] INHERIT</></link> (Greg Stark) </para> <para> @@ -1133,8 +1196,8 @@ For new features, add links to the documentation sections. <listitem> <para> - Allow comments on global objects to be stored globally - (Kris Jurka) + Allow <link linkend="SQL-COMMENT">comments</> on global + objects to be stored globally (Kris Jurka) </para> <para> @@ -1159,15 +1222,17 @@ For new features, add links to the documentation sections. </para> <para> - The new syntax is <command>CREATE INDEX CONCURRENTLY</>. - The default behavior is still to block table modification - while a index is being created. + The new syntax is <link linkend="SQL-CREATEINDEX"><command>CREATE + INDEX CONCURRENTLY</></link>. The default behavior is + still to block table modification while a index is being + created. </para> </listitem> <listitem> <para> - Provide advisory locking functionality (Abhijit Menon-Sen, Tom) + Provide <link linkend="functions-advisory-locks">advisory + locking</> functionality (Abhijit Menon-Sen, Tom) </para> <para> @@ -1178,8 +1243,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Allow <command>COPY</> to dump a <command>SELECT</> query - (Zoltan Boszormenyi, Karel Zak) + Allow <link linkend="SQL-COPY"><command>COPY</></link> to + dump a <command>SELECT</> query (Zoltan Boszormenyi, Karel + Zak) </para> <para> @@ -1190,24 +1256,25 @@ For new features, add links to the documentation sections. <listitem> <para> - Have the <command>COPY</> command return a command tag that - includes the number of rows copied (Volkan YAZICI) + Have the <link linkend="SQL-COPY"><command>COPY</></link> + command return a command tag that includes the number of + rows copied (Volkan YAZICI) </para> </listitem> <listitem> <para> - Allow <command>VACUUM</> to expire rows without being affected - by other concurrent <command>VACUUM</> operations (Hannu - Krossing, Alvaro, Tom) + Allow <link linkend="SQL-VACUUM"><command>VACUUM</></link> + to expire rows without being affected by other concurrent + <command>VACUUM</> operations (Hannu Krossing, Alvaro, Tom) </para> </listitem> <listitem> <para> - Have <application>initdb</> detect the operating system - locale and set the default <varname>DateStyle</> accordingly - (Peter) + Have <link linkend="APP-INITDB"><application>initdb</></link> + detect the operating system locale and set the default + <varname>DateStyle</> accordingly (Peter) </para> <para> @@ -1219,8 +1286,8 @@ For new features, add links to the documentation sections. <listitem> <para> - Avoid extra scan of tables without indexes during <command>VACUUM</> - (Greg Stark) + Avoid extra scan of tables without indexes during <link + linkend="SQL-VACUUM"><command>VACUUM</></link> (Greg Stark) </para> </listitem> @@ -1240,8 +1307,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Allow full timezone names in <type>timestamp</> values - (Joachim Wieland) + Allow full timezone names in <link + linkend="datatype-datetime"><type>timestamp</></link> values + (Joachim Wieland) </para> <para> @@ -1257,23 +1325,30 @@ For new features, add links to the documentation sections. </para> <para> - The file name is controlled by the GUC variable - <varname>timezone_abbreviations</>. + The file name is controlled by the GUC variable <link + linkend="guc-timezone-abbreviations"><varname>timezone_abbreviations</></link>. </para> </listitem> <listitem> <para> - Add <varname>pg_timezone_abbrevs</> and <varname>pg_timezone_names</> - views to show supported timezones (Magnus Hagander) + Add <link + linkend="view-pg-timezone-abbrevs"><varname>pg_timezone_abbrevs</></link> + and <link + linkend="view-pg-timezone-names"><varname>pg_timezone_names</></link> + views to show supported timezones (Magnus Hagander) </para> </listitem> <listitem> <para> - Add <function>clock_timestamp()</>, - <function>statement_timestamp()</>, and - <function>transaction_timestamp()</> (Bruce) + Add <link + linkend="functions-datetime-table"><function>clock_timestamp()</></link>, + <link + linkend="functions-datetime-table"><function>statement_timestamp()</></link>, + and <link + linkend="functions-datetime-table"><function>transaction_timestamp()</></link> + (Bruce) </para> <para> @@ -1287,16 +1362,21 @@ For new features, add links to the documentation sections. <listitem> <para> - Allow <function>to_char()</> to print localized month and - day names (Euler Taveira de Oliveira) + Allow <link + linkend="functions-formatting"><function>to_char()</></link> + to print localized month and day names (Euler Taveira de + Oliveira) </para> </listitem> <listitem> <para> - Allow <function>to_char(time)</> and <function>to_char(interval)</> - to output <acronym>AM</>/<acronym>PM</> specifications - (Bruce) + Allow <link + linkend="functions-formatting"><function>to_char(time)</></link> + and <link + linkend="functions-formatting"><function>to_char(interval)</></link> + to output <acronym>AM</>/<acronym>PM</> specifications + (Bruce) </para> <para> @@ -1307,8 +1387,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Add new function <function>justify_interval()</> to adjust - interval units (Mark Dilger) + Add new function <link + linkend="functions-datetime-table"><function>justify_interval()</></link> + to adjust interval units (Mark Dilger) </para> </listitem> @@ -1334,8 +1415,9 @@ For new features, add links to the documentation sections. <listitem> <para> - New operators for array-subset comparisons (<literal>@></>, - <literal><@</>, <literal>&&</>) (Teodor, Tom) + New <link linkend="functions-geometry-op-table">operators</> + for array-subset comparisons (<literal>@></>, + <literal><@</>, <literal>&&</>) (Teodor, Tom) </para> <para> @@ -1345,8 +1427,10 @@ For new features, add links to the documentation sections. <listitem> <para> - Add convenient arithmetic operations on <type>INET</>/<type>CIDR</> - values (Stephen R. van den Berg) + Add convenient arithmetic <link + linkend="cidr-inet-operators-table">operations</> on + <type>INET</>/<type>CIDR</> values (Stephen R. van den + Berg) </para> <para> @@ -1359,7 +1443,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Add new aggregate functions from SQL2003 (Neil) + Add new aggregate <link + linkend="functions-aggregate-statistics-table">functions</> + from SQL2003 (Neil) </para> <para> @@ -1375,7 +1461,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Add SQL2003-standard statistical aggregates (Sergey Koposov) + Add SQL2003-standard statistical <link + linkend="functions-aggregate-statistics-table">aggregates</link> + (Sergey Koposov) </para> <para> @@ -1391,14 +1479,16 @@ For new features, add links to the documentation sections. <listitem> <para> - Allow domains to be created using other domains (Tom) + Allow <link linkend="SQL-CREATEDOMAIN">domains</> to be + created using other domains (Tom) </para> </listitem> <listitem> <para> - Properly enforce domain <literal>CHECK</literal> constraints - everywhere (Neil, Tom) + Properly enforce domain <link + linkend="ddl-constraints"><literal>CHECK</></link> constraints + everywhere (Neil, Tom) </para> <para> @@ -1411,31 +1501,34 @@ For new features, add links to the documentation sections. <listitem> <para> - Fix problems with dumping renamed <type>SERIAL</> columns - (Tom) + Fix problems with dumping renamed <link + linkend="datatype-serial"><type>SERIAL</></link> columns + (Tom) </para> <para> - The fix is to dump a <type>SERIAL</> column by explicitly - specifying its <literal>DEFAULT</> and sequence elements, - and reconstructing the <type>SERIAL</> column on reload - using a new <command>ALTER SEQUENCE OWNED BY</> command. - This also allows dropping a <type>SERIAL</> column - specification. + The fix is to dump a <type>SERIAL</> column by explicitly + specifying its <literal>DEFAULT</> and sequence elements, + and reconstructing the <type>SERIAL</> column on reload + using a new <link linkend="SQL-ALTERSEQUENCE"><command>ALTER + SEQUENCE OWNED BY</></link> command. This also allows + dropping a <type>SERIAL</> column specification. </para> </listitem> <listitem> <para> - Add a server-side sleep function <function>pg_sleep()</> - (Joachim Wieland) + Add a server-side sleep function <link + linkend="functions-datetime-delay"><function>pg_sleep()</></link> + (Joachim Wieland) </para> </listitem> <listitem> <para> - Add all comparison operators for the <type>tid</> (tuple id) - data type (Mark Kirkwood, Greg Stark, Tom) + Add all comparison operators for the <link + linkend="datatype-oid"><type>tid</></link> (tuple id) data + type (Mark Kirkwood, Greg Stark, Tom) </para> </listitem> @@ -1485,8 +1578,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <literal>STRICT</> to <command>SELECT INTO</> (Matt - Miller) + Add <literal>STRICT</> to <link + linkend="plpgsql-statements-sql-onerow"><command>SELECT + INTO</></link> (Matt Miller) </para> <para> @@ -1534,7 +1628,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Honor <varname>check_function_bodies</> (Tom) + Honor <link + linkend="guc-check-function-bodies"><varname>check_function_bodies</></link> + (Tom) </para> </listitem> @@ -1591,7 +1687,7 @@ For new features, add links to the documentation sections. </sect3> <sect3> - <title><application>psql</> Changes</title> + <title><link linkend="APP-PSQL"><application>psql</></link> Changes</title> <itemizedlist> <listitem> @@ -1698,7 +1794,7 @@ For new features, add links to the documentation sections. </sect3> <sect3> - <title><application>pg_dump</> Changes</title> + <title><link linkend="APP-PGDUMP"><application>pg_dump</></link> Changes</title> <itemizedlist> <listitem> @@ -1718,17 +1814,18 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <application>pg_restore</> <literal>-X - no-data-for-failed-tables</> option to suppress loading - data if table creation failed (the table already exists) - (Martin Pitt) + Add <link linkend="APP-PGRESTORE"><application>pg_restore</></link> + <literal>-X no-data-for-failed-tables</> option to suppress + loading data if table creation failed (the table already + exists) (Martin Pitt) </para> </listitem> <listitem> <para> - Add <application>pg_restore</> option to run the entire - session in a single transaction (Simon) + Add <link linkend="APP-PGRESTORE"><application>pg_restore</></link> + option to run the entire session in a single transaction + (Simon) </para> <para> @@ -1741,24 +1838,28 @@ For new features, add links to the documentation sections. </sect3> <sect3> - <title><application>libpq</> Changes</title> + <title><link linkend="libpq"><application>libpq</></link> Changes</title> <itemizedlist> <listitem> <para> - Add <function>PQencryptPassword()</> to encrypt passwords - (Tom) + Add <link + linkend="libpq-misc"><function>PQencryptPassword()</></link> + to encrypt passwords (Tom) </para> <para> - This allows passwords to be sent encrypted for commands - like <command>ALTER USER ... PASSWORD</>. + This allows passwords to be sent encrypted for commands + like <link linkend="SQL-ALTERROLE"><command>ALTER ROLE ... + PASSWORD</></link>. </para> </listitem> <listitem> <para> - Add function <function>PQisthreadsafe()</> (Bruce) + Add function <link + linkend="libpq-threading"><function>PQisthreadsafe()</></link> + (Bruce) </para> <para> @@ -1769,25 +1870,29 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <function>PQdescribePrepared()</>, - <function>PQdescribePortal()</>, and related functions - return information about previously prepared statements - and open cursors (Volkan YAZICI) + Add <link + linkend="libpq-exec-main"><function>PQdescribePrepared()</></link>, + <link + linkend="libpq-exec-main"><function>PQdescribePortal()</></link>, + and related functions return information about previously + prepared statements and open cursors (Volkan YAZICI) </para> </listitem> <listitem> <para> - Allow <acronym>LDAP</> lookups from <filename>pg_service.conf</> - (Laurenz Albe) + Allow <acronym>LDAP</> <link linkend="libpq-ldap">lookups</> + from <link + linkend="libpq-pgservice"><filename>pg_service.conf</></link> + (Laurenz Albe) </para> </listitem> <listitem> <para> - Allow the <filename>.pgpass</> hostname to match the default - socket directory, as well as a blank <literal>pghost</> - (Bruce) + Allow the <link linkend="libpq-pgpass"><filename>.pgpass</></link> + hostname to match the default socket directory, as well as + a blank <literal>pghost</> (Bruce) </para> </listitem> @@ -1796,19 +1901,20 @@ For new features, add links to the documentation sections. </sect3> <sect3> - <title><application>ecpg</> Changes</title> + <title><link linkend="ecpg"><application>ecpg</></link> Changes</title> <itemizedlist> <listitem> <para> - Allow <command>SHOW</> to put its result into a variable - (Joachim Wieland) + Allow <link linkend="SQL-SHOW"><command>SHOW</></link> to + put its result into a variable (Joachim Wieland) </para> </listitem> <listitem> <para> - Add <command>COPY TO STDOUT</> (Joachim Wieland) + Add <link linkend="SQL-COPY"><command>COPY TO STDOUT</></link> + (Joachim Wieland) </para> </listitem> @@ -1841,8 +1947,9 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <acronym>MSVC</> support for utility commands and - <application>pg_dump </>(Hiroshi Saito) + Add <acronym>MSVC</> support for utility commands and <link + linkend="APP-PGDUMP"><application>pg_dump</></link> (Hiroshi + Saito) </para> </listitem> @@ -1899,8 +2006,8 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <acronym>GIN</> (Generalized Inverted iNdex) index - access method (Teodor) ? + Add <link linkend="GIN"><acronym>GIN</></link> (Generalized + Inverted iNdex) index access method (Teodor) ? </para> </listitem> @@ -1910,9 +2017,10 @@ For new features, add links to the documentation sections. </para> <para> - Rtree has been re-implemented using <acronym>GiST</>. Among - other differences, this means that rtree indexes now have - support for crash recovery via write-ahead logging (WAL). + Rtree has been re-implemented using <link + linkend="GiST"><acronym>GiST</></link>. Among other + differences, this means that rtree indexes now have support + for crash recovery via write-ahead logging (WAL). </para> </listitem> @@ -1930,7 +2038,8 @@ For new features, add links to the documentation sections. </para> <para> - Use configure <literal>--with-libedit-preferred</>. + Use configure <link + linkend="configure"><literal>--with-libedit-preferred</></link>. </para> </listitem> @@ -1993,16 +2102,18 @@ For new features, add links to the documentation sections. <listitem> <para> - Rename existing <acronym>GUC</> variable - <varname>preload_libraries</> to <varname>shared_preload_libraries</> - (Tom) + Rename existing <acronym>GUC</> variable + <varname>preload_libraries</> to <link + linkend="guc-shared-preload-libraries"><varname>shared_preload_libraries</></link> + (Tom) </para> </listitem> <listitem> <para> - Add new GUC variable <varname>server_version_num</> (Greg Sabino - Mullane) + Add new GUC variable <link + linkend="guc-server-version-num"><varname>server_version_num</></link> + (Greg Sabino Mullane) </para> <para> @@ -2014,14 +2125,15 @@ For new features, add links to the documentation sections. <listitem> <para> - Add a <acronym>GUC</> variable <varname>seq_page_cost</> - (Tom) + Add a <acronym>GUC</> variable <link + linkend="guc-seq-page-cost"><varname>seq_page_cost</></link> + (Tom) </para> </listitem> <listitem> <para> - Re-implement the regression test script as a C program + Re-implement the <link linkend="regress">regression test</> script as a C program (Magnus, Tom) </para> </listitem> @@ -2040,7 +2152,7 @@ For new features, add links to the documentation sections. </para> <para> - New functions <function>_PG_init()</> and <function>_PG_fini()</> + New <link linkend="xfunc-c-dynload">functions</> <function>_PG_init()</> and <function>_PG_fini()</> are called if the library defines such symbols. Hence we no longer need to specify an initialization function in <varname>shared_preload_libraries</>; we can assume that the @@ -2050,8 +2162,10 @@ For new features, add links to the documentation sections. <listitem> <para> - Add <literal>PG_MODULE_MAGIC</> header block to all shared - object files (Martijn van Oosterhout) + Add <link + linkend="xfunc-c-dynload"><literal>PG_MODULE_MAGIC</></link> + header block to all shared object files (Martijn van + Oosterhout) </para> <para> @@ -2080,7 +2194,8 @@ For new features, add links to the documentation sections. <listitem> <para> - New <acronym>XML</> documentation section (Bruce) + New <link linkend="datatype-xml"><acronym>XML</></link> + documentation section (Bruce) </para> </listitem> |