diff options
| -rw-r--r-- | doc/src/sgml/release-9.2.sgml | 699 |
1 files changed, 351 insertions, 348 deletions
diff --git a/doc/src/sgml/release-9.2.sgml b/doc/src/sgml/release-9.2.sgml index 374ffb4599e..fb603d2342e 100644 --- a/doc/src/sgml/release-9.2.sgml +++ b/doc/src/sgml/release-9.2.sgml @@ -57,19 +57,19 @@ escapes special characters in string values (Florian Pflug, Radoslaw Smogura) </para> - + <para> Without this it is possible to output illegal <acronym>XML</acronym>. </para> </listitem> - + <listitem> <para> Remove <link linkend="hstore">hstore</link>'s <literal>=></> operator (Robert Haas, David Wheeler) </para> - + <para> Users should now use hstore(text, text). Since <productname>PostgreSQL</productname> 9.0, a warning message is @@ -78,20 +78,20 @@ another use. </para> </listitem> - + <listitem> <para> Have <link linkend="functions-admin-dbobject"><function>pg_relation_size()</></link> and friends return NULL if the object does not exist (Phil Sorber) </para> - + <para> This prevents queries that call these functions from returning errors during concurrent drop operations. </para> </listitem> - + <listitem> <para> Remove the <link @@ -99,7 +99,7 @@ field from <structname>pg_tablespace</> (Magnus Hagander, Tom Lane) </para> - + <para> This field was duplicative of the symbolic links already present in the data directory. This allows tablespace @@ -108,11 +108,11 @@ symbolic links. </para> </listitem> - + </itemizedlist> <sect4> - <title>Temporal Functions</title> + <title>Temporal Functions</title> <itemizedlist> @@ -123,27 +123,27 @@ a non-timezone-aware value measure the epoch from local midnight, not <acronym>UTC</acronym> midnight (Tom Lane) </para> - + <para> Having these computations depend on <acronym>UTC</acronym> was inconsistent. The old behavior is available by casting the value to timestamp with time zone. </para> </listitem> - + <listitem> <para> Properly parse time strings with trailing <literal>yesterday</>, <literal>today</>, and <literal>tomorrow</> (Dean Rasheed) </para> - + <para> Previously, <command>SELECT '04:00:00 yesterday'::timestamp</command> returned yesterday's date at midnight. </para> </listitem> - + <listitem> <para> Fix <link @@ -151,7 +151,7 @@ <function>to_timestamp()</> to wrap incomplete dates toward 2020 (Bruce Momjian) </para> - + <para> Previously, supplied years and year masks of less than four digits wrapped inconsistently. @@ -174,24 +174,27 @@ DOMAIN</command></link> from working on non-domain types (Peter Eisentraut) </para> - + <para> Owner and schema changes were previously possible on non-domain types. </para> </listitem> - + <listitem> <para> No longer auto-lowercase procedural language names (Robert Haas) </para> - + <para> - While unquoted language identifiers are still lowercased, double - and single-quoted identifiers are no longer down-cased. + While unquoted language identifiers are still lowercased, strings + and quoted identifiers are no longer forcibly down-cased. + Thus for example <literal>CREATE FUNCTION ... LANGUAGE 'C'</> + will no longer work; it must be spelled <literal>'c'</>, or better + omit the quotes. </para> </listitem> - + </itemizedlist> </sect3> @@ -208,14 +211,14 @@ linkend="APP-PSQL"><application>psql</></link> meta-command arguments (Tom Lane) </para> - + <para> Previously, such usage was only properly expanded when isolated by whitespace, e.g. <literal>'FOO'BAR</> was output as <literal>FOO BAR</>. </para> </listitem> - + <listitem> <para> No longer treat <link @@ -224,7 +227,7 @@ linkend="APP-REINDEXDB"><application>reindexdb</></link> table and index names as double-quoted (Bruce Momjian) </para> - + <para> Users must supply double-quotes in the command arguments to accomplish double-quoting behavior. @@ -239,32 +242,32 @@ Kupershmidt) </para> </listitem> - + <listitem> <para> No longer have <link linkend="APP-CREATEUSER"><application>createuser</></link> prompt for settings (Peter Eisentraut, Josh Kupershmidt) </para> - + <para> Previously <application>createuser</> prompted regarding various user settings. </para> </listitem> - + <listitem> <para> Remove <link linkend="APP-INITDB"><application>initdb</></link> support for the crypt authentication method (Peter Eisentraut) </para> - + <para> This was removed from the backend years ago. </para> </listitem> - - </itemizedlist> + + </itemizedlist> </sect3> @@ -277,43 +280,43 @@ Remove the <filename>postgresql.conf</filename> setting <varname>silent_mode</> (Heikki Linnakangas) </para> - + <para> This behavior could already be accomplished with <command>pg_ctl -l postmaster.log</>. </para> </listitem> - + <listitem> <para> Remove <acronym>GUC</acronym> <varname>wal_sender_delay</>, as it is no longer needed (Tom Lane) </para> - + <para> The new "latch" capability made this setting unnecessary. </para> </listitem> - + <listitem> <para> Remove the <varname>custom_variable_classes</> <filename>postgresql.conf</filename> parameter (Tom Lane) </para> - + <para> The checking provided by this setting was dubious. Now any setting can be prefixed by any class name. </para> </listitem> - + <listitem> <para> Add GUC <link linkend="guc-ssl-key-file">parameters</link> for specifying the locations of server-side <acronym>SSL</acronym> files (Peter Eisentraut) </para> - + <para> This allows changing the location of the files that were previously hard-coded to <filename>server.crt</>, <filename>server.key</>, @@ -322,7 +325,7 @@ names, and if specified, these files must exist. </para> </listitem> - + </itemizedlist> </sect3> @@ -338,19 +341,19 @@ to <structname>pid</>, to match other system tables (Magnus Hagander) </para> </listitem> - + <listitem> <para> Create a separate <structname>pg_stat_activity</> column to report state information, e.g. idle (Scott Mead, Magnus Hagander, Greg Smith) </para> - + <para> The last query values are preserved, allowing for enhanced analysis. </para> </listitem> - + <listitem> <para> Rename <structname>pg_stat_activity.current_query</> to @@ -358,13 +361,13 @@ completes (Magnus Hagander) </para> </listitem> - + <listitem> <para> Change all <acronym>SQL</acronym>-level statistics timing values to float8-stored milliseconds (Tom Lane) </para> - + <para> The columns affected are: <structname>pg_stat_user_functions.total_time</>, @@ -373,7 +376,7 @@ <structname>pg_stat_xact_user_functions.self_time</>. </para> </listitem> - + <listitem> <para> Change <application>pg_stat_statements</>' @@ -381,7 +384,7 @@ (Tom Lane) </para> </listitem> - + </itemizedlist> </sect3> @@ -409,7 +412,7 @@ Allow queries to retrieve data only from indexes, avoiding heap access (Robert Haas, Ibrar Ahmed, Tom Lane) </para> - + <para> This is often called "index-only scans" or "covering indexes". This is possible for heap pages with exclusively all-visible @@ -424,7 +427,7 @@ lightweight lock mechanism (Robert Haas, Jeff Davis) </para> </listitem> - + <listitem> <para> Move the frequently accessed members of the <structname>PGPROC</> @@ -432,35 +435,35 @@ Deolasee, Heikki Linnakangas, Robert Haas) </para> </listitem> - + <listitem> <para> Reduce overhead of creating virtual transaction id locks (Robert Haas, Jeff Davis) </para> </listitem> - + <listitem> <para> Reduce overhead for shared invalidation cache messages (Robert Haas, Noah Misch) </para> </listitem> - + <listitem> <para> Improve performance of transactions using many savepoints (Simon Riggs, Robert Haas) PARTIALLY REVERTED. KEEP? </para> </listitem> - + <listitem> <para> Improve <command>COPY</command> performance by adding tuples to the heap in batches (Heikki Linnakangas) </para> </listitem> - + <listitem> <para> Improve GiST box and point index performance by producing better @@ -468,21 +471,21 @@ Heikki Linnakangas, Kevin Grittner) </para> </listitem> - + <listitem> <para> Allow hint bits to be set sooner for temporary and unlogged tables (Robert Haas) </para> </listitem> - + <listitem> <para> Reduce checkpoints and <acronym>WAL</acronym> traffic on low activity servers (Simon Riggs) </para> </listitem> - + <listitem> <para> Allow sorting to be performed by inlined and faster, @@ -490,34 +493,34 @@ Geoghegan, Robert Haas, Tom Lane) </para> </listitem> - + <listitem> <para> Add the <link linkend="SPGiST">SP-GiST</link> (Space-Partitioned GiST) index access method (Teodor Sigaev, Oleg Bartunov, Tom Lane, Robert Haas) </para> - + <para> SP-GiST is comparable to GiST in flexibility, but supports non-balanced partitioned search structures rather than balanced trees. CLARIFY? </para> </listitem> - + <listitem> <para> Improve GiST index build times (Alexander Korotkov) </para> </listitem> - + <listitem> <para> Take fewer <acronym>MVCC</acronym> snapshots, for performance (Robert Haas, Dimitri Fontaine) </para> </listitem> - + <listitem> <para> Have the number of clog buffer count scale based on <link @@ -525,28 +528,28 @@ (Robert Haas) </para> </listitem> - + <listitem> <para> Reduce the overhead of serializable isolation level locks (Dan Ports, Heikki Linnakangas) </para> </listitem> - + <listitem> <para> Improve performance of <acronym>WAL</acronym> writes using group commit (Peter Geoghegan, Simon Riggs, Heikki Linnakangas) </para> </listitem> - + <listitem> <para> Improve PowerPC and Itanium spinlock performance (Manabu Ori, Tom Lane, Robert Haas) </para> </listitem> - + </itemizedlist> </sect4> @@ -561,19 +564,19 @@ Create a dedicated worker process to perform checkpoints (Simon Riggs, Dickson Guedes) </para> - + <para> Formerly the background writer did dirty page writing and checkpointing. </para> </listitem> - + <listitem> <para> Improve asynchronous commit behavior by waking up sooner (Simon Riggs) </para> - + <para> Previously, only <link linkend="guc-wal-writer-delay"><varname>wal_writer_delay</></link> @@ -582,18 +585,18 @@ writes. </para> </listitem> - + <listitem> <para> Allow backends to detect postmaster death via a pipe read failure, rather than polling (Peter Geoghegan, Heikki Linnakangas) </para> - + <para> The wait events are internally called "latches". </para> </listitem> - + <listitem> <para> Allow the <link linkend="pg-stat-bgwriter-view">bgwriter</link>, @@ -602,24 +605,24 @@ and checkpointer to sleep more efficiently during periods of inactivity (Peter Geoghegan, Heikki Linnakangas, Tom Lane) </para> - + <para> This reduces <acronym>CPU</acronym> wake-ups, which dramatically reduces power consumption on idle servers. </para> </listitem> - + <listitem> <para> Pass the safe number of file descriptors to Windows processes (Heikki Linnakangas) </para> - + <para> This allows Windows sessions to cache more open file descriptors. </para> </listitem> - + </itemizedlist> </sect4> @@ -634,7 +637,7 @@ Improve the ability of the planner to choose parameterized plans (Tom Lane) </para> - + <para> A prepared statement is now parsed, analyzed, and rewritten, but not necessarily planned. When the prepared plan is executed @@ -643,55 +646,55 @@ of a constant-specific plan. CLARIFY </para> </listitem> - + <listitem> <para> Allow the optimizer to use <literal>CHECK</> constraints defined on tables referenced in subqueries in planning decisions (Tom Lane) </para> - + <para> This is only enabled when <link linkend="guc-constraint-exclusion"><literal>constraint_exclusion = on</></link>. </para> </listitem> - + <listitem> <para> Allow <literal>indexedcol op ANY(ARRAY[...])</> conditions to be used in plain indexscans (Tom Lane) </para> </listitem> - + <listitem> <para> Improve heuristics for determining the type of unknown values by considering other data types involved in the operation (Tom Lane) </para> </listitem> - + <listitem> <para> Allow better matching of index columns with non-default operator qualifications (Tom Lane) </para> </listitem> - + <listitem> <para> Improve the planner's ability to use nested loops with inner index scans (Tom Lane) </para> </listitem> - + <listitem> <para> Support <function>MIN</>/<function>MAX</> index optimizations on boolean columns (Marti Raudsepp, Abhijit Menon-Sen) </para> </listitem> - + </itemizedlist> <sect5> @@ -704,39 +707,39 @@ subqueries (Tom Lane) </para> </listitem> - + <listitem> <para> Improve optimizer estimation for subqueries using <literal>DISTINCT</> (Tom Lane) </para> </listitem> - + <listitem> <para> Collect and use element-frequency statistics for arrays (Alexander Korotkov, Noah Misch, Nathan Boley, Tom Lane, Daniele Varrazzo) </para> - + <para> This patch improves selectivity estimation for the array <@, &&, and @> (containment and overlaps) array operators. </para> </listitem> - + <listitem> <para> Improve costing of partial indexes (Tom Lane) </para> </listitem> - + <listitem> <para> Allow analyze statistics to be collected for foreign tables (Etsuro Fujita, Shigeru Hanada, Tom Lane) </para> </listitem> - + </itemizedlist> </sect5> @@ -754,22 +757,22 @@ linkend="auth-pg-hba-conf"><filename>pg_hba.conf</filename></link> include superusers (Andrew Dunstan, Robert Haas) </para> - + <para> This makes it easier to use reject lines with group roles. </para> </listitem> - + <listitem> <para> Make superuser imply replication privilege (Noah Misch) </para> - + <para> This avoids the need to explicitly assign such privileges. </para> </listitem> - + <listitem> <para> Adjust <filename>pg_hba.conf</filename> processing to more @@ -777,17 +780,17 @@ Herrera, Pavel Stehule) </para> </listitem> - + <listitem> <para> Disallow empty <filename>pg_hba.conf</filename> files (Tom Lane) </para> - + <para> This was done to more quickly report misconfiguration. </para> </listitem> - + </itemizedlist> </sect4> @@ -803,31 +806,31 @@ (Marti Raudsepp, <acronym>PDXPUG</>, Tom Lane) </para> </listitem> - + <listitem> <para> Make logging of autovacuum I/O activity more verbose (Greg Smith, Noah Misch) </para> - + <para> This logging is triggered by <link linkend="guc-log-autovacuum-min-duration"><varname>log_autovacuum_min_duration</></link>. </para> </listitem> - + <listitem> <para> Have <acronym>WAL</acronym> replay report failures sooner (Fujii Masao) </para> - + <para> There were some cases where failures were only reported once the server went into master mode. </para> </listitem> - + <listitem> <para> Add <link @@ -835,18 +838,18 @@ to simplify xlog comparisons (Euler Taveira de Oliveira, Fujii Masao, Magnus Hagander) </para> - + <para> This is useful for computing replication lag. </para> </listitem> - + <listitem> <para> Support configurable eventlog application names on Windows (MauMau, Magnus Hagander) </para> - + <para> This allows different instances to use the eventlog with different identifiers, by setting the <link @@ -855,14 +858,14 @@ linkend="guc-syslog-ident"><varname>syslog_ident</></link> works. </para> </listitem> - + <listitem> <para> Change "unexpected EOF" message to <literal>DEBUG1</> level (Magnus Hagander) </para> </listitem> - + </itemizedlist> </sect4> @@ -879,14 +882,14 @@ system view (Tomas Vondra) </para> </listitem> - + <listitem> <para> Add a deadlock counter to the <structname>pg_stat_database</> system view (Magnus Hagander, Jaime Casanova) </para> </listitem> - + <listitem> <para> Add a <acronym>GUC</acronym> setting <link @@ -894,7 +897,7 @@ to track I/O timings (Ants Aasma, Greg Smith, Robert Haas) </para> </listitem> - + <listitem> <para> Report checkpoint timing information in <link @@ -902,7 +905,7 @@ (Greg Smith, Peter Geoghegan, Robert Haas) </para> </listitem> - + </itemizedlist> </sect4> @@ -919,7 +922,7 @@ to be set per-session by superusers, not just per-cluster (Noah Misch, Shigeru Hanada) </para> - + <para> This allows <varname>deadlock_timeout</> to be reduced for transactions that are likely to be involved in a deadlock, @@ -944,39 +947,39 @@ Sending Servers" (Fujii Masao) </para> </listitem> - + <listitem> <para> Allow a superuser to <command>SET</command> an extension's superuser-only custom variable before loading the associated extension (Tom Lane) </para> - + <para> The system now remembers whether a <command>SET</command> was performed by a superuser. </para> </listitem> - + <listitem> <para> Add <link linkend="app-postmaster">postmaster</link> <option>-C</> option to query configuration parameters (Bruce Momjian) </para> - + <para> This allows <application>pg_ctl</> to better handle configuration-only directory installations. </para> </listitem> - + <listitem> <para> Force the locale to be recorded more specifically, rather than using the empty string to mean the default (Tom Lane) </para> </listitem> - + </itemizedlist> <sect5> @@ -991,32 +994,32 @@ Andy Colson) </para> </listitem> - + <listitem> <para> Allow a reload of <filename>postgresql.conf</filename> to be processed by all backends even if there are some settings that are invalid for that session (Alexey Klyukin, Andy Colson) </para> - + <para> Previously, such not-valid-for-session errors would cause all setting changes to be ignored by that backend. </para> </listitem> - + <listitem> <para> Add an <literal>include_if_exists</> facility for configuration files (Greg Smith, Euler Taveira de Oliveira) </para> - + <para> This works the same as <literal>include</>, except that an error is not thrown if the file is missing. </para> </listitem> - + <listitem> <para> Check the server time zone during initdb, and set @@ -1025,12 +1028,12 @@ <link linkend="guc-log-timezone"><varname>log_timezone</></link> accordingly (Tom Lane) </para> - + <para> This avoids expensive time zone probes during server start. </para> </listitem> - + <listitem> <para> Allow Windows to report @@ -1039,11 +1042,11 @@ (Tom Lane) </para> </listitem> - + </itemizedlist> </sect5> - + </sect4> </sect3> @@ -1061,14 +1064,14 @@ Allow streaming replications slaves to serve other slaves (Fujii Masao, Simon Riggs) </para> - + <para> Previously, only the master server could supply streaming replication log files to standby servers. Slaves can also now do continuous archiving. (?) </para> </listitem> - + <listitem> <para> Add new <link @@ -1076,13 +1079,13 @@ replication mode <literal>remote_write</> (Fujii Masao and Simon Riggs) </para> - + <para> This only writes data to the socket, but does not wait a write to the remote disk. </para> </listitem> - + <listitem> <para> Add a <link @@ -1091,18 +1094,18 @@ than waiting for completed xlog files (Magnus Hagander) </para> </listitem> - + <listitem> <para> Send keepalive messages to standby servers (Simon Riggs) </para> - + <para> This allows administrators to accurately calculate streaming replication transfer and application latency. </para> </listitem> - + </itemizedlist> <sect5> @@ -1115,27 +1118,27 @@ Allow streaming of xlog files while <application>pg_basebackup</> is performing a backup (Magnus Hagander) </para> - + <para> This allows passing of xlog files to the standby before they are discarded on the primary. </para> </listitem> - + <listitem> <para> Allow <application>pg_basebackup</> to pull from standby servers (Jun Ishizuka, Fujii Masao) </para> </listitem> - + <listitem> <para> Exclude the postmaster.opts file from <application>pg_basebackup</> backups (Magnus Hagander) </para> </listitem> - + </itemizedlist> </sect5> @@ -1153,55 +1156,55 @@ Improve columns labels produced by subqueries (Marti Raudsepp, Kyotaro Horiugchi) </para> - + <para> Previously, the generic label <literal>?column?</> was used. </para> </listitem> - + <listitem> <para> Preserve column names in row expressions (Andrew Dunstan, Tom Lane) </para> </listitem> - + <listitem> <para> Cancel queries if clients get disconnected (Florian Pflug, Greg Jaskiewicz) </para> </listitem> - + <listitem> <para> Silently ignore nonexistent schemas specified in <link linkend="guc-search-path"><varname>search_path</></link> (Tom Lane) </para> </listitem> - + <listitem> <para> Warn about casts to and from domain types (Robert Haas) </para> - + <para> Such casts have no effect. </para> </listitem> - + <listitem> <para> When a row fails a <literal>CHECK</> or <literal>NOT NULL</> constraint, show the row's contents in errdetail (Jan Kundrát, Royce Ausburn, Tom Lane) </para> - + <para> This should make it easier to identify which row is problematic when an insert or update is processing many rows. </para> </listitem> - + </itemizedlist> </sect3> @@ -1217,19 +1220,19 @@ <acronym>DDL</acronym> (Robert Haas, Noah Misch) </para> </listitem> - + <listitem> <para> Add <literal>CONCURRENTLY</> option to <link linkend="SQL-DROPINDEX"><command>DROP INDEX CONCURRENTLY</command></link> (Simon Riggs) </para> - + <para> This allows index removal without blocking other sessions. </para> </listitem> - + </itemizedlist> <sect4> @@ -1243,13 +1246,13 @@ constraints to be declared <literal>NOT VALID</> (Álvaro Herrera, Thom Brown, Dean Rasheed, Jaime Casanova) </para> - + <para> A <literal>NOT VALID</> <literal>CHECK</> constraint can be added to a table without the table's data being verified against the constraint. New rows are verified. </para> - + <para> Such constraints are ignored by the planner when considering <varname>constraint_exclusion</>. <command>ALTER TABLE</command> / @@ -1259,38 +1262,38 @@ cached plans. </para> </listitem> - + <listitem> <para> Allow <literal>CHECK</> constraints to be declared <literal>NO INHERIT</> (Nikhil Sontakke, Alex Hunsaker) </para> - + <para> This makes them enforceable only on the parent table, not on child tables. </para> </listitem> - + <listitem> <para> Add the ability to <link linkend="SQL-ALTERTABLE">rename</link> constraints (Peter Eisentraut) </para> </listitem> - + <listitem> <para> Disallow merging of <literal>ONLY</> and non-<literal>ONLY</> constraints in child tables (Nikhil Sontakke) </para> - + <para> Such merging would cause unpredictable behavior in grandchild tables. </para> </listitem> - + </itemizedlist> </sect4> @@ -1307,19 +1310,19 @@ operations (Noah Misch) DUPLICATE? </para> </listitem> - + <listitem> <para> Add <literal>IF EXIST</> clause to <command>ALTER</command> commands (Pavel Stehule) </para> - + <para> For example, <command>ALTER FOREIGN TABLE IF EXISTS foo RENAME TO bar</command>. </para> </listitem> - + <listitem> <para> Add <link linkend="SQL-ALTERFOREIGNDATAWRAPPER"><command>ALTER @@ -1328,31 +1331,31 @@ SERVER</command></link> / <literal>RENAME</> (Peter Eisentraut) </para> </listitem> - + <listitem> <para> Add <link linkend="SQL-ALTERDOMAIN"><command>ALTER DOMAIN</command></link> / <literal>RENAME</> (Peter Eisentraut) </para> - + <para> You could already rename domains using <command>ALTER TYPE</command>. </para> </listitem> - + <listitem> <para> Throw an error for <command>ALTER DOMAIN</command> / <literal>DROP CONSTRAINT</> on a nonexistent constraint (Peter Eisentraut) </para> - + <para> An <literal>IF EXISTS</> option has been added to enable the previous behavior. </para> </listitem> - + </itemizedlist> </sect4> @@ -1369,37 +1372,37 @@ (Tom Lane) </para> </listitem> - + <listitem> <para> Support <command>CREATE TABLE (LIKE ...)</command> from foreign tables and views (Peter Eisentraut) </para> </listitem> - + <listitem> <para> Allow <command>CREATE TABLE (LIKE ...)</command> from composite type (Peter Eisentraut) </para> - + <para> This also allows a table to be created whose schema matches a view. </para> </listitem> - + <listitem> <para> Tighten creation of tables in temporary schemas (Robert Haas) </para> - + <para> Previously, it was possible to create unlogged tables in temporary schemas, and temporary tables in the temporary schemas of other sessions. </para> </listitem> - + </itemizedlist> </sect4> @@ -1415,14 +1418,14 @@ linkend="SQL-CREATEVIEW"><literal>security_barrier</></link> option for views (KaiGai Kohei, Noah Misch) </para> - + <para> This prevents <literal>security_barrier</> views from being moved into other scopes, preventing possible leakage of view-prohibited data. Such views might perform more poorly. </para> </listitem> - + <listitem> <para> Add a new <link @@ -1431,13 +1434,13 @@ into <literal>security_barrier</> views (KaiGai Kohei) </para> </listitem> - + <listitem> <para> Add support for privileges on date types (Peter Eisentraut, Yeb Havinga) </para> - + <para> This adds support for the <acronym>SQL</>-conforming <literal>USAGE</> privilege on types and domains. The intent is @@ -1445,14 +1448,14 @@ which restricts the way in which owners can alter types. </para> </listitem> - + <listitem> <para> Check for <command>INSERT</command> privileges in <command>SELECT INTO</command> / <command>CREATE TABLE AS</command> (KaiGai Kohei, Albe Laurenz) </para> - + <para> Because the object is being created by <command>SELECT INTO</command> or <command>CREATE TABLE AS</command>, it will @@ -1460,7 +1463,7 @@ PRIVILEGES</> has removed such permissions, hence the need for a permission check. </para> - </listitem> + </listitem> </itemizedlist> @@ -1478,13 +1481,13 @@ Allow vacuum to more easily skip pages that cannot be locked (Simon Riggs, Robert Haas) </para> - + <para> This change should greatly reduce the incidence of vacuum getting "stuck". </para> </listitem> - + </itemizedlist> <sect4> @@ -1498,26 +1501,26 @@ and written (Robert Haas, Fujii Masao, Greg Smith) </para> </listitem> - + <listitem> <para> Have <command>EXPLAIN ANALYZE</command> report the number of rows rejected by filter steps (Marko Tiikkaja, Marc Cousin) </para> </listitem> - + <listitem> <para> Allow <command>EXPLAIN</command> to avoid timing overhead when time values are unwanted (Tomas Vondra, Eric Theise) </para> - + <para> This is accomplished by setting <literal>TIMING</> to <literal>FALSE</>. </para> </listitem> - + </itemizedlist> </sect4> @@ -1534,13 +1537,13 @@ Add a <link linkend="datatype-json"><type>JSON</type></link> data type (Robert Haas) AUTHOR? </para> - + <para> This stores <acronym>JSON</acronym> data as text after proper validation. </para> </listitem> - + <listitem> <para> Add <link @@ -1548,38 +1551,38 @@ and <function>row_to_json()</> (Andrew Dunstan, Abhijit Menon-Sen) </para> </listitem> - + <listitem> <para> Add support for <link linkend="rangetypes">range data types</link> (Jeff Davis, Tom Lane, Alexander Korotkov) </para> - + <para> The range data type records a lower and upper bound, and supports operations like contains, overlaps, and intersection. </para> </listitem> - + <listitem> <para> Add <link linkend="datatype-serial"><type>SMALLSERIAL</></link> data type (Mike Pultz, Brar Piening, Josh Kupershmidt) </para> - + <para> This is like <type>SERIAL</>, except it stores the sequence in a two-byte integer column (int2). </para> </listitem> - + <listitem> <para> Allow <link linkend="SQL-CREATEDOMAIN">domains</link> to be declared <literal>NOT VALID</> (Álvaro Herrera, Thom Brown, Dean Rasheed, Jaime Casanova, Peter Eisentraut) </para> - + <para> This can be set at domain creation time, or via <command>ALTER DOMAIN</command> / <literal>ADD CONSTRAINT / NOT @@ -1587,19 +1590,19 @@ CONSTRAINT</> fully validates the domain. </para> </listitem> - + <listitem> <para> Support more locale-specific formatting options for the <link linkend="datatype-money">MONEY</link> data type (Tom Lane) </para> - + <para> Specifically, display the plus/minus sign, currency symbol, and separators in a locale-specific order. CORRECT? </para> </listitem> - + <listitem> <para> Add bitwise "and", "or", and "not" <link @@ -1607,7 +1610,7 @@ data type (Brendan Jurd, Fujii Masao) </para> </listitem> - + </itemizedlist> <sect4> @@ -1621,13 +1624,13 @@ <acronym>XML</acronym> array when supplied a scalar value (Florian Pflug, Radoslaw Smogura) </para> - + <para> Previously, it returned an empty array. This change will also cause <function>xpath_exists()</> to return true, not false, for such expressions. </para> - </listitem> + </listitem> <listitem> <para> @@ -1653,12 +1656,12 @@ linkend="functions-admin-signal"><function>pg_cancel_backend()</></link> (Magnus Hagander) </para> - + <para> Previously only the superuser could cancel queries. </para> </listitem> - + <listitem> <para> Allow <link @@ -1666,23 +1669,23 @@ to process bytea values (Pavel Stehule, Peter Eisentraut) </para> </listitem> - + <listitem> <para> Allow regular expressions to use back-references (Tom Lane) </para> - + <para> For example, '^(\w+)( \1)+$'. </para> </listitem> - + <listitem> <para> Allow importing and exporting of transaction snapshots (Joachim Wieland, Marko Tiikkaja, Tom Lane) </para> - + <para> Snapshots are exported via <link linkend="functions-snapshot-synchronization"><function>pg_export_snapshot()</></link>, @@ -1690,19 +1693,19 @@ Only snapshots of currently-running transactions can be imported. </para> </listitem> - + <listitem> <para> Support <link linkend="functions-info-catalog-table"><literal>COLLATION FOR</></link> on expressions (Peter Eisentraut, Jaime Casanova) </para> - + <para> This returns a string representing the collation of the expression. </para> </listitem> - + <listitem> <para> Add a <type>NUMERIC</> variant of <link @@ -1710,7 +1713,7 @@ for use with <function>pg_xlog_location_diff()</> (Fujii Masao) </para> </listitem> - + </itemizedlist> <sect4> @@ -1723,24 +1726,24 @@ Change default names of triggers to fire "action" triggers before "check" triggers (Tom Lane) </para> - + <para> This allows default-named check triggers to check post-action rows. </para> </listitem> - + <listitem> <para> Add a <link linkend="functions-info-session-table"><function>pg_trigger_depth()</></link> function (Kevin Grittner) </para> - + <para> This reports the current trigger call depth. </para> </listitem> - + </itemizedlist> </sect4> @@ -1762,21 +1765,21 @@ Allow per-column foreign data wrapper options and <literal>force_not_null</> (Shigeru Hanada, KaiGai Kohei) </para> - + <para> This allows <acronym>SQL</acronym> specification of per-column information useful to foreign data sources. Includes <application>psql</> option display support. </para> </listitem> - + <listitem> <para> Improve pretty printing of view definitions (Andrew Dunstan, Hitoshi Harada) </para> </listitem> - + </itemizedlist> </sect4> @@ -1801,52 +1804,52 @@ (Peter Eisentraut) </para> </listitem> - + <listitem> <para> Implement information schema <varname>interval_type</> columns (Peter Eisentraut) </para> </listitem> - + <listitem> <para> Add collation columns to various information schema views (Peter Eisentraut) </para> - + <para> Specifically, provide collation columns for views referencing attributes, columns, domains, and <varname>element_types</>. </para> </listitem> - + <listitem> <para> Add display of sequence <literal>USAGE</> privileges to information schema (Peter Eisentraut) </para> </listitem> - + <listitem> <para> Add a <varname>with_hierarchy</> column to the information schema privileges display (Peter Eisentraut) </para> </listitem> - + <listitem> <para> Have the information schema show default privileges (Peter Eisentraut, Abhijit Menon-Sen) </para> - + <para> Previously, default permissions generated <literal>NULL</> fields. (WAS IT NULL?) </para> </listitem> - + </itemizedlist> </sect4> @@ -1867,7 +1870,7 @@ parameters by name (Yeb Havinga, Kevin Grittner, Tom Lane) </para> </listitem> - + <listitem> <para> Add a <command>GET STACKED DIAGNOSTICS</command> PL/pgSQL command @@ -1875,28 +1878,28 @@ David Wheeler) </para> </listitem> - + <listitem> <para> Speed up PL/pgSQL array assignment by caching type information (Pavel Stehule) </para> </listitem> - + <listitem> <para> Improve performance and memory consumption of the PL/pgSQL <literal>ELSIF</> clauses (Tom Lane) </para> </listitem> - + <listitem> <para> Output the function signature, not just the name, in PL/pgSQL error messages (Pavel Stehule, Abhijit Menon-Sen, Tom Lane) </para> </listitem> - + </itemizedlist> </sect4> @@ -1912,7 +1915,7 @@ (Andrew Dunstan) DETAILS? </para> </listitem> - + </itemizedlist> </sect4> @@ -1927,7 +1930,7 @@ Add PL/Python <acronym>SPI</acronym> cursor support (Jan Urbanski, Steve Singer) </para> - + <para> This allows PL/Python to read partial result sets. </para> @@ -1938,13 +1941,13 @@ Add result metadata functions to PL/Python (Peter Eisentraut, Abhijit Menon-Sen) </para> - + <para> Specifically, this adds result object functions .colnames, .coltypes, and .coltypmods. </para> </listitem> - + </itemizedlist> </sect4> @@ -1958,14 +1961,14 @@ Allow <acronym>SQL</acronym>-language functions to reference parameters by name (Matthew Draper, Hitoshi Harada) </para> - + <para> To use this, simply name the function arguments and reference the argument names in the <acronym>SQL</acronym> function body. </para> </listitem> - </itemizedlist> + </itemizedlist> </sect4> </sect3> @@ -1981,14 +1984,14 @@ options <option>--auth-local</> and <option>--auth-host</> (Peter Eisentraut, Pavel Stehule) </para> - + <para> This allows individual control of <literal>local</> and <literal>host</> <filename>pg_hba.conf</filename> authentication settings. <option>--auth</> still controls both. </para> </listitem> - + <listitem> <para> Add <option>--replication</>/<option>--no-replication</> flags to @@ -1997,7 +2000,7 @@ Villemain) </para> </listitem> - + <listitem> <para> Add the <option>--if-exists</> option to <link @@ -2006,7 +2009,7 @@ Kupershmidt) </para> </listitem> - + <listitem> <para> Give command-line tools the ability to specify the name of the @@ -2014,7 +2017,7 @@ if a <literal>postgres</> database connection fails (Robert Haas) </para> </listitem> - + </itemizedlist> <sect4> @@ -2027,111 +2030,111 @@ Add <application>psql</> mode to auto-expand output based on the display width (Peter Eisentraut, Noah Misch) </para> - + <para> This adds the <literal>auto</> option to the <command>\x</> command, which switches to the expanded mode when the normal output would be wider than the screen. </para> </listitem> - + <listitem> <para> Allow inclusion of <application>psql</> files relative to the directory of the input file from which it was invoked (Gurjeet Singh, Josh Kupershmidt) </para> - + <para> The <application>psql</> command is <command>\ir</>. </para> </listitem> - + <listitem> <para> Add support for non-<acronym>ASCII</acronym> characters in <application>psql</> variable names (Tom Lane) </para> </listitem> - + <listitem> <para> Add support for major-version-specific <filename>.psqlrc</> files (Bruce Momjian) </para> - + <para> <application>psql</> already supported minor-version-specific <filename>.psqlrc</> files. </para> </listitem> - + <listitem> <para> Provide environment variable overrides for <application>psql</> history and startup file locations (Andrew Dunstan) </para> - + <para> Specifically, <envar>PSQL_HISTORY</envar> and <envar>PSQLRC</envar>. </para> </listitem> - + <listitem> <para> Add a <application>psql</> <command>\setenv</> command to modify the environment variables used by child processes (Andrew Dunstan, Josh Kupershmidt) </para> - + <para> This is useful in <filename>.psqlrc</> files. </para> </listitem> - + <listitem> <para> Have <application>psql</> temporary editor files use a <filename>.sql</> extension (Peter Eisentraut) </para> </listitem> - + <listitem> <para> Allows <application>psql</> to use zero-byte field and record separators (Peter Eisentraut, Abhijit Menon-Sen) </para> - + <para> Various shell tools use zero/null-byte separators, e.g. find. </para> </listitem> - + <listitem> <para> Have <application>psql</> <command>\timing</> report times for failed queries (Magnus Hagander) </para> - + <para> Previously only successful query times were reported. </para> </listitem> - + <listitem> <para> Have <application>psql</> <command>\copy</> use libpq's <function>SendQuery()</> (Noah Misch) </para> - + <para> This makes <command>\copy</> failure behavior more predictable, and honors <envar>ON_ERROR_ROLLBACK</>. </para> </listitem> - + </itemizedlist> </sect4> @@ -2146,14 +2149,14 @@ table/column name owning it (Magnus Hagander) </para> </listitem> - + <listitem> <para> Show statistics target for columns in <application>psql</> <command>\d+</> (Magnus Hagander) </para> </listitem> - + <listitem> <para> Show role password expiration dates in <application>psql</> @@ -2173,24 +2176,24 @@ Allow <application>psql</> to display comments for languages and casts (Josh Kupershmidt) </para> - + <para> These are output via <command>\dL</> and <command>\dC</>. </para> </listitem> - + <listitem> <para> Allow <application>psql</> to display comments for conversions and domains (Josh Kupershmidt) </para> - + <para> This is accomplished with the addition of <literal>+</> to <command>\dc</> and <command>\dD</> commands. </para> </listitem> - + <listitem> <para> Allow <application>psql</> to display the comments on @@ -2198,14 +2201,14 @@ mode (Josh Kupershmidt) </para> </listitem> - + <listitem> <para> Change <application>psql</>'s <command>\dd</> command to display only objects without their own backslash command (Josh Kupershmidt) </para> </listitem> - + </itemizedlist> </sect5> @@ -2225,14 +2228,14 @@ the partially-supplied word (Peter Eisentraut, Fujii Masao) </para> </listitem> - + <listitem> <para> Add <application>psql</> tab completion support for <command>EXECUTE</command> (Andreas Karlsson, Josh Kupershmidt) </para> </listitem> - + <listitem> <para> Allow tab completion of role references in @@ -2240,21 +2243,21 @@ Eisentraut, Pavel Stehule) </para> </listitem> - + <listitem> <para> Allow tab completion of file names to supply quotes, when necessary (Noah Misch) </para> </listitem> - + <listitem> <para> Change <application>psql</> tab completion support for <command>TABLE</command> to also display views (Magnus Hagander) </para> </listitem> - + </itemizedlist> </sect4> @@ -2269,19 +2272,19 @@ Add an <option>--exclude-table-data</> option to <application>pg_dump</> (Andrew Dunstan) </para> - + <para> This allows dumping of a table's definition but not its data, on a per-table basis. </para> </listitem> - + <listitem> <para> Add a <option>--section</> option to <application>pg_dump</> and <application>pg_restore</> (Andrew Dunstan, Joachim Wieland) </para> - + <para> Valid values are <literal>pre-data</>, <literal>data</>, and <literal>post-data</>. The option can be @@ -2291,20 +2294,20 @@ <literal>--section=data</>. </para> </listitem> - + <listitem> <para> Have <link linkend="APP-PG-DUMPALL"><application>pg_dumpall</></link> dump all roles first, then all configuration settings on roles (Phil Sorber) </para> - + <para> This allows a role's configuration settings to rely on other roles without generating an error. </para> </listitem> - + <listitem> <para> Allow <application>pg_dumpall</> to avoid errors if the @@ -2312,24 +2315,24 @@ (Robert Haas) </para> </listitem> - + <listitem> <para> Dump foreign server user mappings in user name order (Peter Eisentraut) </para> - + <para> This helps produce deterministic dump files. </para> </listitem> - + <listitem> <para> Dump operators in a predictable order (Peter Eisentraut) </para> </listitem> - + <listitem> <para> Tighten rules for when extension configuration tables are dumped @@ -2353,37 +2356,37 @@ Add <acronym>URI</acronym>s support to libpq connection functions (Alexander Shulgin) </para> - + <para> The syntax begins with <literal>postgres://</>. </para> </listitem> - + <listitem> <para> Add a libpq <link linkend="libpq-connect-sslcompression">connection option</link> to disable <acronym>SSL</acronym> compression (Laurenz Albe) </para> - + <para> This can be used to remove the overhead of <acronym>SSL</acronym> compression on fast networks. </para> </listitem> - + <listitem> <para> Add a row processor <acronym>API</acronym> to libpq for better handling of large result sets (Kyotaro Horiguchi, Marko Kreen) </para> - + <para> Previously, libpq collected the entire query result into memory before passing it back to the application. </para> </listitem> - + <listitem> <para> Enhance <literal>const</> qualifiers in the libpq functions @@ -2391,33 +2394,33 @@ Elie Mamane, Craig Ringer) </para> </listitem> - + <listitem> <para> Allow libpq's <filename>.pgpass</> file to process escaped characters in the password field (Robert Haas, Ross Reedstrom) </para> </listitem> - + <listitem> <para> Have library functions use <function>abort()</> instead of <function>exit()</> to terminate the executable (Peter Eisentraut) </para> - + <para> This does not interfere with the normal exit codes used by the program, and generates a signal that can be caught by the caller. </para> </listitem> - + <listitem> <para> Fix a libpq memory leak by freeing client encoding connection parameters (Peter Eisentraut) </para> </listitem> - + </itemizedlist> </sect3> @@ -2433,123 +2436,123 @@ Visual Studio 2010</link> (Brar Piening, Craig Ringer) </para> </listitem> - + <listitem> <para> Enable compiling with the MinGW-w64 32-bit compiler (Lars Kanis, Nishiyama Tomoaki) </para> </listitem> - + <listitem> <para> Install <filename>plpgsql.h</> into <filename>include/server</> during installation (Heikki Linnakangas) </para> </listitem> - + <listitem> <para> Use C flexible array members, where supported (Peter Eisentraut) </para> </listitem> - + <listitem> <para> Improve the concurrent transaction regression tests (isolationtester) (Noah Misch, Alexander Shulgin) </para> </listitem> - + <listitem> <para> Modify <application>thread_test</> to create its test files in the current directory, rather than /tmp (Bruce Momjian) </para> </listitem> - + <listitem> <para> Improve flex and bison warning and error reporting (Tom Lane, Noah Misch) </para> </listitem> - + <listitem> <para> Add memory barrier support (Robert Haas) </para> - + <para> This is currently unused. </para> </listitem> - + <listitem> <para> Modify pgindent to use a typedef file (Bruce Momjian) </para> </listitem> - + <listitem> <para> Add a hook for processing messages due to be sent to the server log (Martin Pihlak, Marti Raudsepp) </para> </listitem> - + <listitem> <para> Add object access hooks for <command>DROP</command> commands (KaiGai Kohei) </para> </listitem> - + <listitem> <para> Centralize <command>DROP</command> handling for some object types (KaiGai Kohei) </para> </listitem> - + <listitem> <para> Add a <application>pg_upgrade</> test suite (Peter Eisentraut) </para> </listitem> - + <listitem> <para> Sync regular expression code with <acronym>TCL</acronym> 8.5.11 and improve internal processing (Tom Lane) </para> </listitem> - + <listitem> <para> Move <acronym>CRC</acronym> tables to libpgport, and provide them in a separate include file (Daniel Farina, Abhijit Menon-Sen) </para> </listitem> - + <listitem> <para> Add options to <application>git_changelog</> for use in major release note creation (Bruce Momjian) </para> </listitem> - + <listitem> <para> Remove dead ports (Peter Eisentraut) </para> - + <para> The removed ports are: dgux, nextstep, sunos4, svr4, ultrix4, univel, bsdi. </para> </listitem> - + </itemizedlist> </sect3> @@ -2565,13 +2568,13 @@ using libpq's new row processor <acronym>API</acronym> (Kyotaro Horiguchi, Marko Kreen) </para> - + <para> This cannot be used by <function>dblink_send_query()</>/<function>dblink_get_result()</>. </para> </listitem> - + <listitem> <para> Add <link linkend="tcn">tcn</link> (triggered change notification) @@ -2579,19 +2582,19 @@ (Kevin Grittner) </para> </listitem> - + <listitem> <para> Implement dry-run mode for <link linkend="pgarchivecleanup"><application>pg_archivecleanup</></link> (Gabriele Bartolini, Josh Kupershmidt) </para> - + <para> This only outputs the names of files to be deleted. </para> </listitem> - + <listitem> <para> Add new <link linkend="pgbench">pgbench</link> switches @@ -2599,7 +2602,7 @@ <option>--index-tablespace</> (Robert Haas) </para> </listitem> - + <listitem> <para> Have <link linkend="vacuumlo">vacuumlo</link> remove large objects @@ -2612,7 +2615,7 @@ objects removed per transaction. </para> </listitem> - + <listitem> <para> Change <link @@ -2620,13 +2623,13 @@ for a fixed amount of time, rather than a fixed number of cycles (Bruce Momjian) </para> - + <para> The <option>-o</>/cycles option was removed, and <option>-s</>/seconds added. </para> </listitem> - + <listitem> <para> Add a <link @@ -2635,7 +2638,7 @@ Aasma, Greg Smith) </para> </listitem> - + </itemizedlist> <sect4> @@ -2649,7 +2652,7 @@ does not have a <literal>postgres</> database (Bruce Momjian) </para> </listitem> - + <listitem> <para> Allow <application>pg_upgrade</> to handle cases where some @@ -2657,31 +2660,31 @@ (Bruce Momjian) </para> </listitem> - + <listitem> <para> Allow <application>pg_upgrade</> to handle configuration-only directory installations (Bruce Momjian) </para> </listitem> - + <listitem> <para> In <application>pg_upgrade</>, add <option>-o</>/<option>-O</> options to pass parameters to the servers (Bruce Momjian) </para> - + <para> This is useful for configuration-only directory installs. </para> </listitem> - + <listitem> <para> Change <application>pg_upgrade</> to use port 50432 by default (Bruce Momjian) </para> - + <para> This helps avoid unintended client connections during the upgrade. </para> @@ -2692,7 +2695,7 @@ Overhaul <application>pg_upgrade</> logging and failure reporting (Bruce Momjian) </para> - + <para> Create four append-only log files, and delete them on success. Add <option>-r</>/<option>--retain</> option to unconditionally @@ -2701,13 +2704,13 @@ and tighten log file permissions. </para> </listitem> - + <listitem> <para> Adjust <application>pg_upgrade</> environment variables (Bruce Momjian) </para> - + <para> Rename data, bin, and port environment variables to begin with <literal>PG</>, and support @@ -2715,31 +2718,31 @@ <envar>PGPORT</envar>. INCOMPATIBILITY? </para> </listitem> - + <listitem> <para> Have <application>pg_upgrade</> create a script to incrementally generate more accurate optimizer statistics (Bruce Momjian) </para> - + <para> This reduces the time needed to generate minimal cluster statistics after an upgrade. </para> </listitem> - + <listitem> <para> Reduce cluster locking in <application>pg_upgrade</> (Bruce Momjian) </para> - + <para> Specifically, only lock the old cluster if link mode is used, and do it right after the schema is restored. </para> </listitem> - + </itemizedlist> </sect4> @@ -2755,7 +2758,7 @@ queries (Peter Geoghegan, Daniel Farina, Tom Lane) </para> </listitem> - + <listitem> <para> Improve <application>pg_stat_statements</>' handling of @@ -2763,7 +2766,7 @@ (Tom Lane) </para> </listitem> - + <listitem> <para> Add dirtied and written block counts to @@ -2771,7 +2774,7 @@ Greg Smith) </para> </listitem> - + </itemizedlist> </sect4> @@ -2785,40 +2788,40 @@ Support <literal>SECURITY LABEL</> on global objects (KaiGai Kohei, Robert Haas) </para> - + <para> Specifically, add <literal>SECURITY LABEL</>s to databases, tablespaces, and roles. </para> </listitem> - + <listitem> <para> Allow sepgsql to honor database labels (KaiGai Kohei) </para> </listitem> - + <listitem> <para> Perform sepgsql permission checks during the creation of various objects (KaiGai Kohei, Dimitri Fontaine) </para> </listitem> - + <listitem> <para> Add <function>sepgsql_setcon()</> and related functions to control the sepgsql security domain (KaiGai Kohei, Yeb Havinga) </para> </listitem> - + <listitem> <para> Add a userspace access cache to sepgsql to improve performance (KaiGai Kohei) </para> </listitem> - + </itemizedlist> </sect4> @@ -2834,18 +2837,18 @@ Add a rule to optionally build docs with the stylesheet from the website (Magnus Hagander) </para> - + <para> Use <command>make STYLE=website draft</>. </para> </listitem> - + <listitem> <para> Improve <command>EXPLAIN</command> documentation (Tom Lane) </para> </listitem> - + <listitem> <para> Document that user/database names are preserved with double-quoting @@ -2853,21 +2856,21 @@ Momjian) </para> </listitem> - + <listitem> <para> Improve the foreign data wrapper <acronym>API</acronym> and documentation (Hanada Shigeru, KaiGai Kohei) </para> </listitem> - + <listitem> <para> Document the actual string returned by the client for MD5 authentication (Cyan Ogilvie) </para> </listitem> - + </itemizedlist> </sect3> |