From f0922cbdcc54a11ea7eef955763aab4d540bf22f Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 20 Apr 2013 17:31:06 -0400 Subject: [PATCH] More 9.3 release note reorderings --- doc/src/sgml/release-9.3.sgml | 356 ++++++++++++++++++---------------- 1 file changed, 187 insertions(+), 169 deletions(-) diff --git a/doc/src/sgml/release-9.3.sgml b/doc/src/sgml/release-9.3.sgml index 72638a6b0c..30dba78c7c 100644 --- a/doc/src/sgml/release-9.3.sgml +++ b/doc/src/sgml/release-9.3.sgml @@ -584,6 +584,13 @@ + + + Add support for piping COPY and psql \copy to/from an external program (Etsuro + Fujita) + + + Improve query string error location reporting (Tom Lane) @@ -601,13 +608,6 @@ - - - Add support for piping COPY and psql \copy to/from an external program (Etsuro - Fujita) - - - @@ -702,18 +702,6 @@ - - - Internally store default foreign key matches (non-FULL, non-PARTIAL) as "simple" (Tom Lane) - - - - These were previously stored as "&unspecified&". - This changes the value stored in system column - pg_constraint.confmatchtype. BACKWARD COMPATIBILITY CHANGE - - - Change ON UPDATE SET NULL/SET DEFAULT foreign key actions to affect @@ -741,6 +729,18 @@ + + + Internally store default foreign key matches (non-FULL, non-PARTIAL) as "simple" (Tom Lane) + + + + These were previously stored as "&unspecified&". + This changes the value stored in system column + pg_constraint.confmatchtype. BACKWARD COMPATIBILITY CHANGE + + + @@ -752,7 +752,12 @@ - Add support for ALTER RULE ... RENAME (Ali Dar) + Add the ALTER TYPE ... IF NOT EXISTS clause when adding enumerated type labels (Andrew + Dunstan) + + + + This is useful for conditional label creation in transaction blocks. @@ -770,12 +775,7 @@ - Add the ALTER TYPE ... IF NOT EXISTS clause when adding enumerated type labels (Andrew - Dunstan) - - - - This is useful for conditional label creation in transaction blocks. + Add support for ALTER RULE ... RENAME (Ali Dar) @@ -790,8 +790,15 @@ - When converting a table to a view, remove its system columns (Tom Lane) - KEEP? + Add a materialized view relations (Kevin Grittner) + + + + Unlink ordinary views, where the base tables are read on every access, + materialized views create physical tables at creation or refresh time. + Access to the materialized view reads from these materialized physical + tables. There is no facility for incrementally refreshing materialized + views or auto-accessing them via base table access. @@ -825,15 +832,8 @@ - Add a materialized view relations (Kevin Grittner) - - - - Unlink ordinary views, where the base tables are read on every access, - materialized views create physical tables at creation or refresh time. - Access to the materialized view reads from these materialized physical - tables. There is no facility for incrementally refreshing materialized - views or auto-accessing them via base table access. + When converting a table to a view, remove its system columns (Tom Lane) + KEEP? @@ -848,13 +848,6 @@ - - - Allow text timezone designations, e.g. "America/Chicago" when using the - ISO "T" timestamptz format (Bruce Momjian) - - - Increase the maximum length of large objects from 2GB to 4TB (Nozomi @@ -868,10 +861,18 @@ - Add functions to convert values, records, and hstore data to JSON (Andrew Dunstan) + Allow text timezone designations, e.g. "America/Chicago" when using the + ISO "T" timestamptz format (Bruce Momjian) + + + + JSON + + + Add operators and functions to extract values from JSON data strings @@ -885,10 +886,19 @@ + + + Add functions to convert values, records, and hstore data to JSON (Andrew Dunstan) + + + + + + Functions @@ -902,27 +912,34 @@ - Have to_char(), to_date(), and to_timestamp() properly handle - negative century designations (CC) (Bruce Momjian) + Allow concat() and format() to properly expand VARIADIC-labeled + arguments (Pavel Stehule) + + - Previously the behavior was either wrong or inconsistent with - positive/AD handling, e.g. format mask 'IYYY-IW-DY'. + Improve format() to handle field width and left/right alignment + (Pavel Stehule) - In to_date() and to_timestamp(), return proper results when mixing - ISO and Gregorian week/day designations (Bruce Momjian) + Have to_char(), to_date(), and to_timestamp() properly handle + negative century designations (CC) (Bruce Momjian) + + + + Previously the behavior was either wrong or inconsistent with + positive/AD handling, e.g. format mask 'IYYY-IW-DY'. - Allow concat() and format() to properly expand VARIADIC-labeled - arguments (Pavel Stehule) + Have to_date() and to_timestamp() return proper results when mixing + ISO and Gregorian week/day designations (Bruce Momjian) @@ -944,13 +961,6 @@ - - - Improve format() to handle field width and left/right alignment - (Pavel Stehule) - - - Force cached functions to be replanned if the search_path changes (Tom Lane) @@ -987,7 +997,12 @@ - Allow greater flexibility in where keywords can be used in PL/pgSQL (Tom Lane) + Allow PL/pgSQL to use RETURN with a composite-type expressions (Asif + Rehman) + + + + Previously RETURN could only reference composite-type variables. @@ -1004,12 +1019,7 @@ - Allow PL/pgSQL to use RETURN with a composite-type expressions (Asif - Rehman) - - - - Previously RETURN could only reference composite-type variables. + Allow greater flexibility in where keywords can be used in PL/pgSQL (Tom Lane) @@ -1024,37 +1034,24 @@ - Allow PL/Python to support platform-specific include directories (Peter Eisentraut) - - - - - - Allow PL/Python on OS X to build against custom versions of Python - (Peter Eisentraut) + Add PL/Python result object string handler (Peter Eisentraut) - - - Handle SPIErrors raised explicitly with PL/Python's RAISE the same as - as internal SPI errors (Oskari Saarenmaa and Jan Urbanski) + This allows plpy.debug(rv) to output something reasonable. - Add PL/Python result object string handler (Peter Eisentraut) - - - - This allows plpy.debug(rv) to output something reasonable. + Have PL/Python convert oid values to a proper Python numeric type (Peter Eisentraut) - Have PL/Python convert oid values to a proper Python numeric type (Peter Eisentraut) + Handle SPIErrors raised explicitly with PL/Python's RAISE the same as + as internal SPI errors (Oskari Saarenmaa and Jan Urbanski) @@ -1071,22 +1068,8 @@ - Have initdb fsync the newly created data directory (Jeff Davis) - - - - This can be disabled by using --nosync. - - - - - - Add initdb --sync-only option to sync the data directory to durable - storage (Bruce Momjian) - - - - This is used by pg_upgrade. + Add command-line utility pg_isready to check if the server is ready + to accept connections (Phil Sorber) @@ -1101,20 +1084,6 @@ - - - Add command-line utility pg_isready to check if the server is ready - to accept connections (Phil Sorber) - - - - - - Have initdb issue a warning about placing the data directory at the - top of file system mount points (Bruce Momjian) - - - Add -d option to pg_dumpall, pg_basebackup, pg_receivexlog to @@ -1153,12 +1122,8 @@ - Allow the psql --single-transaction mode to work when reading from - standard input (Fabien Coelho, Robert Haas) - - - - Previously this option only worked when reading from a file. + Adjust function cost settings so psql tab completion and pattern + searching is more efficient (Tom Lane) @@ -1170,18 +1135,22 @@ - Remove psql warning when connecting to an older server (Peter Eisentraut) + Allow the psql --single-transaction mode to work when reading from + standard input (Fabien Coelho, Robert Haas) - The warning when connecting to a newer server was retained. + Previously this option only worked when reading from a file. - Adjust function cost settings so psql tab completion and pattern - searching is more efficient (Tom Lane) + Remove psql warning when connecting to an older server (Peter Eisentraut) + + + + The warning when connecting to a newer server was retained. @@ -1194,18 +1163,21 @@ - Add SSL information to psql's \conninfo command (Alastair Turner) + Add psql \watch command to repeatedly execute commands (Will + Leinweber) - In psql, do not allow \connect to use defaults if there is no active - connection (Bruce Momjian) + Add psql command \gset to store query results in psql variables + (Pavel Stehule) + + - This might be the case if the server had crashed. + Add SSL information to psql's \conninfo command (Alastair Turner) @@ -1217,31 +1189,28 @@ - Properly reset state if psql's "\g file" command failed (Tom Lane) + Allow psql \l to accept a database name pattern (Peter Eisentraut) + + - Previously failed commands discarded output from subsequent commands. + In psql, do not allow \connect to use defaults if there is no active + connection (Bruce Momjian) - - - Add psql command \gset to store query results in psql variables - (Pavel Stehule) + This might be the case if the server had crashed. - Add psql \watch command to repeatedly execute commands (Will - Leinweber) + Properly reset state if psql's "\g file" command failed (Tom Lane) - - - Allow psql \l to accept a database name pattern (Peter Eisentraut) + Previously failed commands discarded output from subsequent commands. @@ -1297,18 +1266,23 @@ - Fix tar files emitted by pg_dump and pg_basebackup to be POSIX - conformant (Brian Weaver, Tom Lane) + Add pg_dump --jobs to dump in parallel (Joachim Wieland) - Have pg_dump output functions in a predictable order (Joel Jacobson) + + + Fix tar files emitted by pg_dump and pg_basebackup to be POSIX + conformant (Brian Weaver, Tom Lane) + + + Add -d/--dbname option to pg_dump, for consistency with other client @@ -1320,9 +1294,40 @@ + + + + + + <link linkend="APP-INITDB"><application>initdb</></link> + + + - Add pg_dump --jobs to dump in parallel (Joachim Wieland) + Have initdb fsync the newly created data directory (Jeff Davis) + + + + This can be disabled by using --nosync. + + + + + + Add initdb --sync-only option to sync the data directory to durable + storage (Bruce Momjian) + + + + This is used by pg_upgrade. + + + + + + Have initdb issue a warning about placing the data directory at the + top of file system mount points (Bruce Momjian) @@ -1339,19 +1344,25 @@ - Remove typedefs for int2/int4 as they are better represented as int16/int32 (Peter Eisentraut) + Add an embedded list interface (Andres Freund) - Create a centralized timeout API (Zoltán Böszörményi) + Add infrastructure to better support plug-in background worker + processes (AlvaroAacute;lvaro Herrera) - Rewrite pgindent in Perl (Andrew Dunstan) + Create libpgcommon and move pg_malloc() and other functions there + (AlvaroAacute;lvaro Herrera, Andres Freund) + + + + This allows libpgport to be used solely for porting code. @@ -1365,55 +1376,60 @@ - Fix install-strip on Mac OS X (Peter Eisentraut) + Remove typedefs for int2/int4 as they are better represented as int16/int32 (Peter Eisentraut) - Remove configure flag --disable-shared, as it is no longer used (Bruce Momjian) + Create a centralized timeout API (Zoltán Böszörményi) - Add emacs macro to match Postgres perltidy formatting (Peter - Eisentraut) + Rewrite pgindent in Perl (Andrew Dunstan) - Run tool to check the keyword list when the backend grammar is changed (Tom Lane) + Fix install-strip on Mac OS X (Peter Eisentraut) - Standardize on naming of client-side memory allocation functions (Tom Lane) + Remove configure flag --disable-shared, as it is no longer used (Bruce Momjian) - Centralize flex and bison 'make' rules (Peter Eisentraut) + Add emacs macro to match Postgres perltidy formatting (Peter + Eisentraut) + + - This is useful for pgxs authors. + Run tool to check the keyword list when the backend grammar is changed (Tom Lane) - Add an embedded list interface (Andres Freund) + Standardize on naming of client-side memory allocation functions (Tom Lane) - Add infrastructure to better support plug-in background worker - processes (AlvaroAacute;lvaro Herrera) + Centralize flex and bison 'make' rules (Peter Eisentraut) + + + + This is useful for pgxs authors. @@ -1441,17 +1457,6 @@ - - - Create libpgcommon and move pg_malloc() and other functions there - (AlvaroAacute;lvaro Herrera, Andres Freund) - - - - This allows libpgport to be used solely for porting code. - - - Invent pre-commit/pre-prepare/pre-subcommit events for transaction @@ -1504,6 +1509,19 @@ + + + Allow PL/Python to support platform-specific include directories (Peter Eisentraut) + + + + + + Allow PL/Python on OS X to build against custom versions of Python + (Peter Eisentraut) + + + -- 2.40.0