Re: release.sgml, minor pg_autovacuum changes - Mailing list pgsql-patches
| From | Bruce Momjian |
|---|---|
| Subject | Re: release.sgml, minor pg_autovacuum changes |
| Date | |
| Msg-id | 200310160347.h9G3lBd28604@candle.pha.pa.us Whole thread Raw |
| In response to | release.sgml, minor pg_autovacuum changes (Christopher Browne <cbbrowne@acm.org>) |
| List | pgsql-patches |
Patch applied. Thanks.
---------------------------------------------------------------------------
Christopher Browne wrote:
> I have run pg_autovacuum on AIX, so that can, at least loosely, be
> considered "tested."
>
> And I have turned all of the 7.4 HISTORY material into DocBook for
> release.sgml
>
> Index: contrib/pg_autovacuum/README.pg_autovacuum
> ===================================================================
> RCS file: /projects/cvsroot/pgsql-server/contrib/pg_autovacuum/README.pg_autovacuum,v
> retrieving revision 1.4
> diff -u -r1.4 README.pg_autovacuum
> --- contrib/pg_autovacuum/README.pg_autovacuum 8 Oct 2003 18:18:04 -0000 1.4
> +++ contrib/pg_autovacuum/README.pg_autovacuum 13 Oct 2003 03:41:59 -0000
> @@ -30,15 +30,17 @@
> -------------
>
> pg_autovacuum has been tested under Redhat Linux (by me) and Debian
> -GNU/Linux and Solaris (by Christopher B. Browne) and all known bugs
> -have been resolved. Please report any problems to the hackers list.
> +GNU/Linux, Solaris, and AIX (by Christopher B. Browne) and all known
> +bugs have been resolved. Please report any problems to the hackers
> +list.
>
> pg_autovacuum requires that the statistics system be enabled and
> reporting row level stats. The overhead of the stats system has been
> -shown to have a significant cost under certain workloads. For instance,
> -a tight loop of queries performing "select 1" was found to run nearly
> -30% slower when stats were enabled. However, in practice, with more
> -realistic workloads, the stats system overhead is usually nominal.
> +shown to have a significant cost under certain workloads. For
> +instance, a tight loop of queries performing "select 1" was found to
> +run nearly 30% slower when stats were enabled. However, in practice,
> +with more realistic workloads, the stats system overhead is usually
> +nominal.
>
> pg_autovacuum does not get started automatically by either the
> postmaster or by pg_ctl. Similarly, when the postmaster exits, no one
> @@ -67,6 +69,10 @@
> introduce this sort of functionality by providing arguments to specify
> the database and schema in which to find a configuration table.
>
> +It would also be desirable for the daemon to monitor how busy the
> +system is, with a view to deferring vacuums until there is less other
> +activity.
> +
> INSTALL:
> --------
>
> @@ -78,7 +84,8 @@
> If you are using an earlier version of PostgreSQL, uncompress the
> tar.gz file into the contrib directory and modify the contrib/Makefile
> to include the pg_autovacuum directory. pg_autovacuum will then be
> -built as part of the standard postgresql install.
> +built as part of the standard postgresql install. It is known to work
> +with v7.3 releases; it is not presently compatible with v7.2.
>
> make sure that the following are set in postgresql.conf:
>
> Index: doc/src/sgml/release.sgml
> ===================================================================
> RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/release.sgml,v
> retrieving revision 1.209
> diff -u -r1.209 release.sgml
> --- doc/src/sgml/release.sgml 29 Sep 2003 18:15:12 -0000 1.209
> +++ doc/src/sgml/release.sgml 13 Oct 2003 03:42:27 -0000
> @@ -24,42 +24,520 @@
> worries about funny characters.
> -->
> <literallayout><![CDATA[
> -EXTRACT(TIMEZONE) and SET/SHOW TIMEZONE now follow SQL sign convention
> - (positive = east of UTC)
> -DATESTYLE can now be set to DMY, YMD, or MDY to specify input field order
> -Input date order must now be YYYY-MM-DD (with 4-digit year) or match DATESTYLE
> -Output of SHOW DATESTYLE is now in the same format accepted by SET DATESTYLE
> -PL/Python is now an untrusted language, and is renamed to 'plpythonu'
> -Dollar sign ($) is no longer allowed in operator names
> -Dollar sign ($) can be a non-first character in identifiers
> -Precision in FLOAT(p) is now interpreted as bits, not decimal digits
> -Functional indexes have been generalized into expressional indexes
> -CHAR(n) to TEXT conversion automatically strips trailing blanks
> -Pattern matching operations can use indexes regardless of locale
> -New frontend/backend protocol supports many long-requested features
> -SET AUTOCOMMIT TO OFF is no longer supported; psql has an AUTOCOMMIT variable
> -Reimplementation of NUMERIC datatype for more speed
> -New regular expression package, many more regexp features (most of Perl5)
> -Can now do EXPLAIN ... EXECUTE to see plan used for a prepared query
> -Explicit JOINs no longer constrain query plan, unless JOIN_COLLAPSE_LIMIT = 1
> -Performance of "foo IN (SELECT ...)" queries has been considerably improved
> -FETCH 0 now re-fetches cursor's current row, per SQL spec
> -Revised executor state representation; plan trees are read-only to executor now
> -Information schema
> -Domains now support CHECK constraints
> -psql backslash commands for listing conversions, casts, and schemas
> -TRUNCATE TABLE is transaction-safe
> -CLUSTER can re-cluster a previously clustered table, or all such tables
> -Statement-level triggers
> -System can use either hash- or sort-based strategy for grouped aggregation
> -ON COMMIT options for temp tables
> -extra_float_digits option allows pg_dump to dump float data accurately
> -Long options for psql and pg_dump are now available on all platforms
> -Read-only transactions
> -Object owners can allow grantees to grant the privilege to others (grant option)
> ]]></literallayout>
>
> - </sect1>
> +<sect2><title>Overview</title>
> +<para> Major changes in this release:
> +<glosslist>
> +
> +<glossentry> <glossterm> IPv6</glossterm>
> +
> +<glossdef><para> Full support for IPv6 connections and IPv6 address
> +data types</para></glossdef>
> +</glossentry>
> +
> +<glossentry><glossterm> SSL</glossterm>
> +
> +<glosssdef><para> Major improvements in SSL performance and
> +reliability</para></glosssdef>
> +</glossentry>
> +
> +<glossentry><glossterm> Index Growth Prevention</glossterm>
> +
> +<glossdef><para> Allow free space map to efficiently reuse empty index
> +pages, and other free space management improvements.</para></glossdef>
> +</glossentry>
> +
> +<glossentry><glossterm> Standards Compliance</glossterm>
> +
> +<glossdef><para> Implement information schema Support for read-only
> +transactions </para>
> +
> +<para>Make cursors comply more closely with the SQL standard
> +</para></glossdef>
> +
> +</glossentry>
> +
> +<glossentry><glossterm> New Client/Server Communication
> +Protocol</glossterm>
> +
> +<glossdef><para> New protocol improves connection speed/reliability,
> +and adds error codes, status information, a binary protocol, error
> +reporting verbosity, and cleaner startup packets.</para></glossdef>
> +</glossentry>
> +
> +<glossentry><glossterm> Performance</glossterm>
> +
> +<glossdef><para> IN/NOT IN subqueries now perform as efficiently as
> +joins</para>
> +
> +<para> Improved GROUP BY processing by using hash buckets</para>
> +
> +<para> New multi-key hash join capability</para>
> +
> +<para> ANSI joins are now better optimized</para>
> +
> +<para> Faster and more powerful regular expression code</para>
> +
> +<para> Function-inlining for simple SQL functions</para></glossdef>
> +</glossentry>
> +
> +<glossentry><glossterm> Holdable Cursors</glossterm>
> +
> +<glossdef><para> Allow cursors to exist outside transactions
> +</para></glossdef>
> +</glossentry>
> +
> +<glossentry><glossterm> Threads</glossterm>
> +
> +<glossdef><para> libpq and ecpg are now fully thread-safe with
> +--enable-thread-safety</para></glossdef>
> +</glossentry>
> +
> +<glossentry><glossterm> Contrib</glossterm>
> +
> +<glossdef><para> New version of full text indexing (tsearch2)</para>
> +
> +<para> New autovacuum tool</para>
> +
> +<para> Array handling has been improved and moved into the main
> +server</para></glossdef>
> +</glossentry>
> +</glosslist></para></sect2>
> +
> +<sect2><title> Migration to version 7.4</title>
> +
> +<para> A dump/restore using <application>pg_dump</application> is
> +required for those wishing to migrate data from any previous release.</para>
> +
> +<para> Observe the following incompatibilities:
> +<itemizedlist>
> + <listitem><para> The server-side autocommit setting was removed and reimplemented
> + in client applications and languages.</para></listitem>
> + <listitem><para> Error message wording has changed substantially in this release,
> + and error codes have been added.</para></listitem>
> + <listitem><para> ANSI joins may behave differently because they are now better optimized</para></listitem>
> + <listitem><para> A number of server variables have been renamed for clarity</para></listitem>
> + <listitem><para> MOVE/FETCH 0 now does nothing; return value of MOVE/FETCH 1/0
> + varies based on the current offset in the cursor</para></listitem>
> + <listitem><para> COPY now can process carriage-return/line-feed and carriage-return
> + terminated files. Literal carriage-returns and line-feeds are no
> + longer accepted as data values; use \r and \n instead.</para></listitem>
> + <listitem><para> Trailing spaces are now trimmed when converting
> + from <type>CHAR(n)</type> to
> + <type>VARCHAR(n)</type> / <type>TEXT</type></para></listitem>
> + <listitem><para> <function>FLOAT(p)</function> now measures 'p' in bits, not digits</para></listitem>
> + <listitem><para> Ambiguous date values now must match the ordering specified by DateStyle</para></listitem>
> + <listitem><para> The <function>oidrand()</function>, <function>oidsrand()</function>,
> + and <function>userfntest()</function> functions have been
> + removed.</para></listitem>
> +</itemizedlist></para></sect2>
> +
> +<sect2> <title> Changes </title>
> +
> +<sect3><title> Server Operation</title>
> +<itemizedlist>
> +<listitem><para>Allow IPv6 server connections (Nigel Kukard, Johan Jordaan, Bruce, Tom, Kurt
> + Roeckx, Andrew Dunstan)</para></listitem>
> +<listitem><para>Fix SSL to handle errors cleanly (Nathan Mueller)</para></listitem>
> +<listitem><para>SSL protocol security and performance improvements (Sean Chittenden)</para></listitem>
> +<listitem><para>Print lock information when a deadlock is detected (Tom)</para></listitem>
> +<listitem><para>Update <filename>/tmp</filename> socket mod. times regularly to avoid their removal
(Tom)</para></listitem>
> +<listitem><para>Enable PAM for MAC OS X (Aaron Hillegass)</para></listitem>
> +<listitem><para>Make btree indexes fully WAL-safe (Tom)</para></listitem>
> +<listitem><para>Allow btree index compaction and empty page reuse (Tom)</para></listitem>
> +<listitem><para>Fix inconsistent index lookups during split of first root page (Tom)</para></listitem>
> +<listitem><para>Improve free space map allocation logic (Tom)</para></listitem>
> +<listitem><para>Preserve free space information between postmaster restarts (Tom)</para></listitem>
> +<listitem><para>Set proper schema permissions in initdb (Peter)</para></listitem>
> +<listitem><para>Add start time to pg_stat_activity (Neil)</para></listitem>
> +<listitem><para>New code to detect corrupt disk pages; erase with zero_damaged_pages (Tom)</para></listitem>
> +<listitem><para>New client/server protocol: faster, no username length limit, allow
> + clean exit from COPY (Tom)</para></listitem>
> +<listitem><para>Add transaction status, tableid, columnid to backend protocol (Tom)</para></listitem>
> +<listitem><para>Add new binary I/O protocol (Tom)</para></listitem>
> +<listitem><para>Remove autocommit server setting; move to client applications (Tom)</para></listitem>
> +<listitem><para>New error message wording, error codes, and three levels of error detail (Tom)</para></listitem>
> +</itemizedlist></sect3>
> +
> +<sect3><title>Performance</title>
> +
> +<itemizedlist>
> +
> +<listitem><para>Add hashing for GROUP BY aggregates (Tom)</para></listitem>
> +<listitem><para>Allow nested loops to be smarter about multicolumn indexes (Tom)</para></listitem>
> +<listitem><para>Allow multi-key hash joins (Tom)</para></listitem>
> +<listitem><para>Improve constant folding (Tom)</para></listitem>
> +<listitem><para>Add ability to inline simple SQL functions (Tom)</para></listitem>
> +<listitem><para>Reduce memory usage for queries using complex functions (Tom)</para></listitem>
> +<listitem><para>Improve GEQO optimizer performance (Tom)</para></listitem>
> +<listitem><para>Allow IN/NOT IN to be handled via hash tables (Tom)</para></listitem>
> +<listitem><para>Improve NOT IN (subquery) performance (Tom)</para></listitem>
> +<listitem><para>Allow most IN subqueries to be processed as joins (Tom)</para></listitem>
> +<listitem><para>Allow the postmaster to preload libraries using preload_libraries (Joe)</para></listitem>
> +<listitem><para>Improve optimizer cost computations, particularly for subqueries (Tom)</para></listitem>
> +<listitem><para>Avoid sort when subquery ORDER BY matches upper query (Tom)</para></listitem>
> +<listitem><para>Assume WHERE a.x = b.y and b.y = 42 also means a.x = 42 (Tom)</para></listitem>
> +<listitem><para>Allow hash/merge joins on complex joins (Tom)</para></listitem>
> +<listitem><para>Allow hash joins for more data types (Tom)</para></listitem>
> +<listitem><para>Allow join optimization of ANSI joins, disable with join_collapse_limit (Tom)</para></listitem>
> +<listitem><para>Add from_collapse_limit to control conversion of subqueries to joins (Tom)</para></listitem>
> +<listitem><para>Use faster regular expression code from TCL (Henry Spencer, Tom)</para></listitem>
> +<listitem><para>Use bit-mapped relation sets in the optimizer (Tom)</para></listitem>
> +<listitem><para>Improve backend startup time (Tom)</para></listitem>
> +<listitem><para>Improve trigger/constraint performance (Stephan)</para></listitem>
> +<listitem><para>Improve speed of col IN (const, const, const, ...) (Tom)</para></listitem>
> +<listitem><para>Fix hash indexes which were broken in rare cases (Tom)</para></listitem>
> +<listitem><para>Improve hash index concurrency and speed (Tom)</para></listitem>
> +<listitem><para>Align shared buffers on 32-byte boundary for copy speed improvement</para></listitem>
> +</itemizedlist></sect3>
> +
> +<sect3><title>Server Configuration</title>
> +
> +<itemizedlist>
> +<listitem><para>Rename server parameter server_min_messages to log_min_messages (Bruce)</para></listitem>
> +<listitem><para>Rename show_*_stats to log_*_stats (Bruce)</para></listitem>
> +<listitem><para>Rename show_source_port to log_source_port (Bruce)</para></listitem>
> +<listitem><para>Rename hostname_lookup to log_hostname (Bruce)</para></listitem>
> +<listitem><para>Add checkpoint_warning to warn of excessive checkpointing (Bruce)</para></listitem>
> +<listitem><para>New read-only server parameters for localization (Tom)</para></listitem>
> +<listitem><para>Change debug server log messages to output as DEBUG rather than LOG (Bruce)</para></listitem>
> +<listitem><para>Prevent server log variables from being turned off by non-super users (Bruce)</para></listitem>
> +<listitem><para>log_min_messages/client_min_messages now controls debug_* output (Bruce)</para></listitem>
> +<listitem><para>Add Rendezvous server support (Chris Campbell)</para></listitem>
> +<listitem><para>Add ability to print only slow statements using log_min_duration_statement
> + (Christopher)</para></listitem>
> +<listitem><para>Allow pg_hba.conf to accept netmasks in CIDR format (Andrew Dunstan)</para></listitem>
> +<listitem><para>New is_superuser read-only variable (Tom)</para></listitem>
> +<listitem><para>New server-side parameter log_error_verbosity to control error detail (Tom)</para></listitem>
> +<listitem><para>postgres --help-config now dumps server config variables (Aizaz Ahmed)</para></listitem>
> +<listitem><para>Make default shared_buffers 1000 and max_connections 100, if possible (Tom)</para></listitem>
> +<listitem><para>Add new columns in pg_settings: context, type, source , min_val, max_val (Joe)</para></listitem>
> +<listitem><para>New pg_hba.conf 'hostnossl' to prevent SSL connections (Jon Jensen)</para></listitem>
> +<listitem><para>Remove geqo_random_seed server parameter (Tom)</para></listitem>
> +</itemizedlist></sect3>
> +
> +<sect3><title>Queries</title>
> +<itemizedlist>
> +
> +<listitem><para>New SQL-standard information schema (Peter)</para></listitem>
> +<listitem><para>Add read-only transactions (Peter)</para></listitem>
> +<listitem><para>Add server variable regex_flavor to control regular expression
> + processing (Tom)</para></listitem>
> +<listitem><para>Print key name and value in foreign-key violation messages (Dmitry Tkach)</para></listitem>
> +<listitem><para>Allow users to see their own queries in pg_stat_activity (Kevin Brown)</para></listitem>
> +<listitem><para>Fix subquery aggregates of upper query columns to match SQL spec. (Tom)</para></listitem>
> +<listitem><para>Add option to prevent auto-addition of tables referenced in query (Nigel J.
> + Andrews)</para></listitem>
> +<listitem><para>Allow UPDATE ... SET col = DEFAULT (Rod)</para></listitem>
> +<listitem><para>Allow expressions to be used in LIMIT/OFFSET (Tom)</para></listitem>
> +<listitem><para>Change EXECUTE INTO to CREATE TABLE AS EXECUTE (Peter)</para></listitem>
> +</itemizedlist></sect3>
> +
> +<sect3><title>Object Manipulation</title>
> +
> +<itemizedlist>
> +<listitem><para>Make CREATE SEQUENCE grammar more SQL1999 standards compliant (Neil)</para></listitem>
> +<listitem><para>Add FOR EACH STATEMENT statement-level triggers (Neil)</para></listitem>
> +<listitem><para>Add DOMAIN CHECK constraints (Rod)</para></listitem>
> +<listitem><para>Add ALTER DOMAIN .. SET / DROP NOT NULL, SET / DROP DEFAULT, ADD / DROP
> + CONSTRAINT (Rod)</para></listitem>
> +<listitem><para>Fix several zero-column table bugs (Tom)</para></listitem>
> +<listitem><para>Have ALTER TABLE ... ADD PRIMARY KEY add NOT NULL constraint (Rod)</para></listitem>
> +<listitem><para>Add ALTER DOMAIN OWNER (Rod)</para></listitem>
> +<listitem><para>Add ALTER TABLE ... WITHOUT OIDS (Rod)</para></listitem>
> +<listitem><para>Add ALTER SEQUENCE to modify min/max/increment/cache/cycle values (Rod)</para></listitem>
> +<listitem><para>Add ALTER TABLE ... CLUSTER ON (Alvaro Herrera)</para></listitem>
> +<listitem><para>Improve DOMAIN automatic type casting (Rod, Tom)</para></listitem>
> +<listitem><para>Allow dollar signs in identifiers, except as first character (Tom)</para></listitem>
> +<listitem><para>Disallow dollar signs in operator names, so x=$1 works (Tom)</para></listitem>
> +<listitem><para>Allow SQL200X inheritance syntax LIKE <emphasis>subtable</emphasis>, INCLUDING DEFAULTS
(Rod)</para></listitem>
> +<listitem><para>Add WITH GRANT OPTION clause to GRANT, per SQL spec (Peter)</para></listitem>
> +</itemizedlist></sect3>
> +
> +<sect3><title>Utility Commands</title>
> +<itemizedlist>
> +<listitem><para>Add ON COMMIT PRESERVE ROWS for temp tables (Gavin)</para></listitem>
> +<listitem><para>Allow cursors outside transactions using WITH HOLD (Neil)</para></listitem>
> +<listitem><para>Make MOVE/FETCH 0 actually move/fetch 0 (Bruce)</para></listitem>
> +<listitem><para>Cause FETCH 1 to return the current cursor row, or zero if at
> + beginning/end of cursor, per SQL spec (Bruce)</para></listitem>
> +<listitem><para>Have MOVE return 0 or 1 depending on cursor position (Bruce)</para></listitem>
> +<listitem><para>Properly handle SCROLL with cursors, or report an error (Neil)</para></listitem>
> +<listitem><para>Implement SQL92-compatible FIRST, LAST, ABSOLUTE n, RELATIVE n options
> + for FETCH and MOVE (Tom)</para></listitem>
> +<listitem><para>Allow EXPLAIN on DECLARE CURSOR (Tom)</para></listitem>
> +<listitem><para>Allow CLUSTER to use index marked as pre-clustered by default (Alvaro Herrera)</para></listitem>
> +<listitem><para>Allow CLUSTER to cluster all tables (Alvaro Herrera)</para></listitem>
> +<listitem><para>Prevent CLUSTER on partial indexes (Tom)</para></listitem>
> +<listitem><para>Allow \r and \r\n termination for COPY files (Bruce)</para></listitem>
> +<listitem><para>Disallow literal carriage return as a data value, backslash-carriage-return
> + and \r are still allowed (Bruce)</para></listitem>
> +<listitem><para>COPY changes (binary, \.)? (Tom)</para></listitem>
> +<listitem><para>Recover from COPY IN/OUT failure cleanly (Tom)</para></listitem>
> +<listitem><para>Prevent possible memory leaks in COPY (Tom)</para></listitem>
> +<listitem><para>Make TRUNCATE transaction-safe (Rod)</para></listitem>
> +<listitem><para>Multiple pg_dump fixes, including tar format and large objects</para></listitem>
> +<listitem><para>Allow pg_dump to dump specific schemas (Neil)</para></listitem>
> +<listitem><para>Allow pg_dump to preserve column storage characteristics (Christopher)</para></listitem>
> +<listitem><para>Allow pg_dump to preserve CLUSTER characteristics (Christopher)</para></listitem>
> +<listitem><para>Have pg_dumpall use GRANT/REVOKE to dump database-level permissions (Tom)</para></listitem>
> +<listitem><para>Allow pg_dumpall to support the -a, -s, -x options of pg_dump (Tom)</para></listitem>
> +<listitem><para>Prevent pg_dump from lowercasing identifiers specified on the command line (Tom)</para></listitem>
> +<listitem><para>Allow PREPARE/bind of utility commands like FETCH and EXPLAIN (Tom)</para></listitem>
> +<listitem><para>Add EXPLAIN EXECUTE (Neil)</para></listitem>
> +<listitem><para>Allow pg_get_constraintdef() to support UNIQUE, PRIMARY KEY and
> + CHECK constraints (Christopher)</para></listitem>
> +<listitem><para>Improve VACUUM performance on indexes by reducing WAL traffic (Tom)</para></listitem>
> +<listitem><para>Allow pg_ctl to better handle non-standard ports (Greg)</para></listitem>
> +<listitem><para>Functional indexes now support indexes on column expressions (Tom)</para></listitem>
> +<listitem><para>Syntax errors now reported as 'syntax error' rather than 'parse error' (Tom)</para></listitem>
> +<listitem><para>Have SHOW TRANSACTION_ISOLATION match input to SET TRANSACTION_ISOLATION (Tom)</para></listitem>
> +<listitem><para>Have COMMENT ON DATABASE on non-local database generate a warning (Rod)</para></listitem>
> +<listitem><para>Improve reliability of LISTEN/NOTIFY (Tom)</para></listitem>
> +<listitem><para>Allow REINDEX to reliably reindex non-shared system catalog indexes (Tom)</para></listitem>
> +<listitem><para>pg_dump --use-set-session-authorization and --no-reconnect now do nothing,
> + all dumps use SET SESSION AUTHORIZATION</para></listitem>
> +</itemizedlist></sect3>
> +
> +
> +<sect3><title>Data Types and Functions</title>
> +<itemizedlist>
> +<listitem><para>New extra_float_digits server parameter to control float precision display
> + (Pedro Ferreira, Tom)</para></listitem>
> +<listitem><para>Allow +1300 as a numeric timezone specifier, for FJST (Tom)</para></listitem>
> +<listitem><para>Remove rarely used oidrand(), oidsrand(), and userfntest() functions (Neil)</para></listitem>
> +<listitem><para>Add md5() function to main server, already in /contrib/pgcrypto (Joe)</para></listitem>
> +<listitem><para>Increase date range of timestamp (John Cochran)</para></listitem>
> +<listitem><para>Change EXTRACT(EPOCH FROM timestamp) so timestamp without time zone
> + is assumed to be in local time, not GMT (Tom)</para></listitem>
> +<listitem><para>Trap division by zero in case the operating system doesn't prevent it (Tom)</para></listitem>
> +<listitem><para>Change the NUMERIC data type internally to base 10000 (Tom)</para></listitem>
> +<listitem><para>New hostmask() function (Greg Wickham)</para></listitem>
> +<listitem><para>Fixes for to_char() (Karel)</para></listitem>
> +<listitem><para>Allow functions that can take any argument data type and return
> + any data type, using ANYELEMENT and ANYARRAY (Joe)</para></listitem>
> +<listitem><para>Arrays may now be specified as ARRAY[1,2,3], ARRAY[['a','b'],['c','d']],
> + or ARRAY[ARRAY[ARRAY[2]]] (Joe)</para></listitem>
> +<listitem><para>Allow proper comparisons for arrays (Joe)</para></listitem>
> +<listitem><para>Allow array concatenation with '||' (Joe)</para></listitem>
> +<listitem><para>Allow indexes on array columns, and used in ORDER BY and DISTINCT (Joe)</para></listitem>
> +<listitem><para>Allow WHERE qualification 'expr <oper> ANY/SOME/ALL (array-expr)' (Joe)
> +<listitem><para>Allow polymorphic SQL functions (Joe)</para></listitem>
> +<listitem><para>New array functions array_append(), array_cat(), array_lower(),
> + array_prepend(), array_to_string(), array_upper(), string_to_array() (Joe)</para></listitem>
> +<listitem><para>Allow user defined aggregates to use polymorphic functions (Joe)</para></listitem>
> +<listitem><para>Allow polymorphic user defined aggregates (Joe)</para></listitem>
> +<listitem><para>Allow assignments to empty arrays (Joe)</para></listitem>
> +<listitem><para>Allow 60 in seconds fields of timestamp, time, interval input values (Tom)</para></listitem>
> +<listitem><para>Allow CIDR data type to be cast to text (Tom)</para></listitem>
> +<listitem><para>Allow the creation of special LIKE indexes for non-C locales (Peter)</para></listitem>
> +<listitem><para>Disallow invalid timezone names (Tom)</para></listitem>
> +<listitem><para>Trim trailing spaces when CHAR() data is cast to VARCHAR or TEXT (Tom)</para></listitem>
> +<listitem><para>Make FLOAT(p) measure the precision p in bits, not decimal digits (Tom)</para></listitem>
> +<listitem><para>Add IPv6 support to the inet and cidr data types (Michael Graff)</para></listitem>
> +<listitem><para>Add family() function to report whether address is IPv4 or IPv6 (Michael Graff)</para></listitem>
> +<listitem><para>Have SHOW DATESTYLE generate output similar to that used by SET DATESTYLE (Tom)</para></listitem>
> +<listitem><para>Change DATESTYLE to output its value in a more common format (Tom)</para></listitem>
> +<listitem><para>Make EXTRACT(TIMEZONE) and SET/SHOW TIMEZONE follow the SQL convention
> + for the sign of timezone offsets, ie, positive is east from UTC (Tom)</para></listitem>
> +<listitem><para>Fix date_trunc('quarter',...) (B?jthe Zolt?n)</para></listitem>
> +<listitem><para>Make initcap() more compatible with Oracle (Mike Nolan)</para></listitem>
> +<listitem><para>Allow only DateStyle field order for date values not in ISO format (Greg)</para></listitem>
> +<listitem><para>Add new DateStyle values MDY, DMY, and YMD, honor US and European for
> + backward compatibility (Tom)</para></listitem>
> +<listitem><para>'now' will no longer work as a column default, use now() (change required for
> + prepared statements) (Tom)</para></listitem>
> +<listitem><para>Assume NaN value to be larger than any other value in MIN()/MAX() (Tom)</para></listitem>
> +<listitem><para>Prevent interval from suppressing ':00' seconds display</para></listitem>
> +<listitem><para>New pg_get_triggerdef(prettyprint) and pg_constraint_is_visible() functions</para></listitem>
> +<listitem><para>Allow time to be specified as '040506' or '0405' (Tom)</para></listitem></oper></para></listitem>
> +</itemizedlist></sect3>
> +
> +<sect3><title>Server-side Languages</title>
> +
> +<itemizedlist>
> +<listitem><para>Prevent PL/pgSQL crash when RETURN NEXT is used on a zero-row record var. (Tom)</para></listitem>
> +<listitem><para>Make PL/python's spi_execute interface handle NULLs properly (Andrew Bosma)</para></listitem>
> +<listitem><para>Allow PL/pgSQL to declare variables of composite types without %ROWTYPE (Tom)</para></listitem>
> +<listitem><para>Fix PL/python _quote() function to handle big integers (?)</para></listitem>
> +<listitem><para>Make PL/python an untrusted language, now called plpythonu (Kevin Jacobs, Tom)</para></listitem>
> +<listitem><para>Allow polymorphic PL/pgSQL functions (Tom, Joe)</para></listitem>
> +<listitem><para>Improved compiled function caching mechanism in PL/pgSQL with full
> + support for polymorphism (Joe)</para></listitem>
> +<listitem><para>Add new $0 parameter in PL/pgSQL representing the function's actual
> + return type (Joe)</para></listitem>
> +<listitem><para>Allow pltcl and plpython use the same trigger on multiple tables (Tom)</para></listitem>
> +<listitem><para>Fixed PL/Tcl's spi_prepare to accept full qualified type names in
> + the parameter type list (Jan)</para></listitem>
> +</itemizedlist></sect3>
> +
> +<sect3><title>Psql</title>
> +
> +<itemizedlist>
> +<listitem><para>Add "\pset pager always" to always use pager (Greg)</para></listitem>
> +<listitem><para>Improve tab completion (Rod, Ross Reedstrom, Ian Barwick)</para></listitem>
> +<listitem><para>Reorder \? help into groupings (Harald Armin Massa, Bruce)</para></listitem>
> +<listitem><para>Add schema, cast, and conversion backslash commands (Christopher)</para></listitem>
> +<listitem><para>\encoding now changes based on client_encoding server variable (Tom)</para></listitem>
> +<listitem><para>Save edit history into readline history (Ross)</para></listitem>
> +<listitem><para>Improve \d display (Christopher)</para></listitem>
> +<listitem><para>Enhance HTML mode to be more standards-compliant (Greg)</para></listitem>
> +<listitem><para>New '\set AUTOCOMMIT off' capability (Tom)</para></listitem>
> +<listitem><para>New '\set VERBOSITY' to control error detail (Tom)</para></listitem>
> +<listitem><para>New %T prompt string to show transaction status (Tom)</para></listitem>
> +</itemizedlist></sect3>
> +
> +<sect3><title>Libpq</title>
> +
> +<itemizedlist>
> +<listitem><para>Allow PQcmdTuples() to return row counts for MOVE and FETCH (Neil)</para></listitem>
> +<listitem><para>Add PQfreemem() for freeing memory on Win32, suggest for NOTIFY (Bruce)</para></listitem>
> +<listitem><para>Document service capability, and add sample file (Bruce)</para></listitem>
> +<listitem><para>Make PQsetdbLogin() have the same defaults as PQconnectdb() (Tom)</para></listitem>
> +<listitem><para>Allow libpq to cleanly fail when result sets are too large (Tom)</para></listitem>
> +<listitem><para>Improve performance of PGunescapeBytea() (Ben Lamb)</para></listitem>
> +<listitem><para>Allow thread-safe libpq with --enable-thread-safety (Lee Kindness, Philip Yarra)</para></listitem>
> +<listitem><para>Allow pqInternalNotice() to accept a format string and args instead of
> + just a preformatted message (Tom, Sean Chittenden)</para></listitem>
> +<listitem><para>Allow control SSL negotiation with sslmode values "disable", "allow",
> + "Prefer", and "require" (Jon Jensen)</para></listitem>
> +<listitem><para>Allow new error codes and levels of text (Tom)</para></listitem>
> +<listitem><para>Allow access to the underlying table and column of a query result (Tom)</para></listitem>
> +<listitem><para>Allow access to the current transaction status (Tom)</para></listitem>
> +<listitem><para>Add ability to pass binary data directly to the backend (Tom)</para></listitem>
> +<listitem><para>Add PQexecPrepared() and PQsendQueryPrepared() functions which
> + perform Bind/Execute of previously prepared statements (Tom)</para></listitem>
> +</itemizedlist></sect3>
> +
> +<sect3><title>JDBC</title>
> +
> +<itemizedlist>
> +<listitem><para>Allow setNull on updateable resultsets</para></listitem>
> +<listitem><para>Allow executeBatch on a prepared statement (Barry)</para></listitem>
> +<listitem><para>Support SSL connections (Barry)</para></listitem>
> +<listitem><para>Handle schema names in result sets (Paul Sorenson)</para></listitem>
> +<listitem><para>Add refcursor support (Nic Ferrier)</para></listitem>
> +</itemizedlist></sect3>
> +
> +<sect3><title>Miscellaneous Interfaces</title>
> +<itemizedlist>
> +<listitem><para>Prevent possible memory leak or core dump during libpgtcl shutdown (Tom)</para></listitem>
> +<listitem><para>Add ecpg Informix compatibility (Michael)</para></listitem>
> +<listitem><para>Add ecpg DECIMAL type that is fixed length, for Informix (Michael)</para></listitem>
> +<listitem><para>Allow thread-safe ecpg with --enable-thread-safety (Lee Kindness, Bruce)</para></listitem>
> +<listitem><para>Move python client interface to http://www.pygresql.org (Marc)</para></listitem>
> +</itemizedlist></sect3>
> +
> +<sect3><title>Source Code</title>
> +
> +<itemizedlist>
> +
> +<listitem><para>Prevent need for separate platform geometry regression result files (Tom)</para></listitem>
> +<listitem><para>Improved PPC locking primitive (Reinhard Max)</para></listitem>
> +<listitem><para>Embed LD_LIBRARY_PATH used for build process into binaries (Billy)</para></listitem>
> +<listitem><para>New palloc0 to allocate and clear memory (Bruce)</para></listitem>
> +<listitem><para>Fix locking code for s390x CPU (64-bit) (Tom)</para></listitem>
> +<listitem><para>Allow OpenBSD to use local ident credentials (William Ahern)</para></listitem>
> +<listitem><para>Make query plan trees read-only to executor (Tom)</para></listitem>
> +<listitem><para>Add Darwin startup scripts (David Wheeler)</para></listitem>
> +<listitem><para>Allow libpq to compile with Borland C++ compiler (Lester Godwin, Karl Waclawek)</para></listitem>
> +<listitem><para>Use our own version of getopt_long() if needed (Peter)</para></listitem>
> +<listitem><para>Convert administration scripts to C (Peter)</para></listitem>
> +<listitem><para>Bison >=1.85 is now required for grammar changes</para></listitem>
> +<listitem><para>Merge documentation into one book (Peter)</para></listitem>
> +<listitem><para>Add Win32 compatibility functions (Bruce)</para></listitem>
> +<listitem><para>Allow client interfaces to compile under MinGW/Win32 (Bruce)</para></listitem>
> +<listitem><para>New ereport() function for error reporting (Tom)</para></listitem>
> +<listitem><para>Support Intel Linux compiler (Peter)</para></listitem>
> +<listitem><para>Improve Linux startup scripts (Slawomir Sudnik, Darko Prenosil)</para></listitem>
> +<listitem><para>Add support for AMD Opteron and Itanium (Jeffrey W. Baker, Bruce)</para></listitem>
> +<listitem><para>Remove configure --enable-recode</para></listitem>
> +<listitem><para>Generate a compile error if spinlock code is not found (Bruce)</para></listitem>
> +</itemizedlist></sect3>
> +
> +<sect3><title>Contrib</title>
> +
> +<itemizedlist>
> +<listitem><para>Change dbmirror license to BSD</para></listitem>
> +<listitem><para>Improve earthdistance (Bruno Wolff III)</para></listitem>
> +<listitem><para>Portability improvements to pgcrypto (Marko Kreen)</para></listitem>
> +<listitem><para>Prevent xml crash (John Gray, Michael Richards)</para></listitem>
> +<listitem><para>Update oracle</para></listitem>
> +<listitem><para>Update mysql</para></listitem>
> +<listitem><para>Update cube (Bruno Wolff III)</para></listitem>
> +<listitem><para>Update earthdistance to use cube (Bruno Wolff III)</para></listitem>
> +<listitem><para>Update btree_gist (Oleg)</para></listitem>
> +<listitem><para>New tsearch2 full-text search module (Oleg, Teodor)</para></listitem>
> +<listitem><para>Add hashed based crosstab function to tablefuncs (Joe)</para></listitem>
> +<listitem><para>Add serial column to order connectby() siblings in tablefuncs (Nabil Sayegh,Joe)</para></listitem>
> +<listitem><para>Add named persistent connections to dblink (Shridhar Daithanka)</para></listitem>
> +<listitem><para>New pg_autovacuum allows automatic VACUUM (Matthew T. O'Connor)</para></listitem>
> +<listitem><para>Allow pgbench to honor PGHOST, PGPORT, PGUSER env. variables (Tatsuo)</para></listitem>
> +<listitem><para>Improve intarray (Teodor Sigaev)</para></listitem>
> +<listitem><para>Improve pgstattuple (Rod)</para></listitem>
> +<listitem><para>Fix bug in metaphone() in fuzzystrmatch</para></listitem>
> +<listitem><para>Improve adddepend (Rod)</para></listitem>
> +<listitem><para>Update spi/timetravel (B?jthe Zolt?n)</para></listitem>
> +<listitem><para>Fix dbase -s option and improve non-ASCII handling (Thomas Behr,M?rcio Smiderle)</para></listitem>
> +<listitem><para>Remove array module because features now included by default (Joe)</para></listitem>
> +</itemizedlist></sect3>
> +
> +<sect3> <title> Other Uncategorized</title>
> +<itemizedlist>
> +<listitem><para><function>EXTRACT(TIMEZONE)</function> and <command>SET/SHOW
> + TIMEZONE </command> now follow SQL sign convention
> + (positive = east of UTC)</para></listitem>
> +<listitem><para><command>DATESTYLE</command> can now be set to DMY, YMD, or MDY to specify input field
order</para></listitem>
> +<listitem><para>Input date order must now be YYYY-MM-DD (with 4-digit
> + year) or match <envar>DATESTYLE</envar></para></listitem>
> +<listitem><para>Output of <command>SHOW DATESTYLE</command> is now in the same
> + format accepted by <command>SET DATESTYLE</command></para></listitem>
> +<listitem><para>PL/Python is now an untrusted language, and is renamed
> + to <function>plpythonu</function></para></listitem>
> +<listitem><para>Dollar sign ($) is no longer allowed in operator names</para></listitem>
> +<listitem><para>Dollar sign ($) can be a non-first character in identifiers</para></listitem>
> +<listitem><para>Precision in <function> FLOAT(p)</function> is now interpreted as bits, not decimal
digits</para></listitem>
> +<listitem><para>Functional indexes have been generalized into expressional indexes</para></listitem>
> +<listitem><para><function>CHAR(n)</function> to <function>TEXT</function> conversion automatically strips trailing
blanks</para></listitem>
> +<listitem><para>Pattern matching operations can use indexes regardless of locale</para></listitem>
> +<listitem><para>New frontend/backend protocol supports many long-requested features</para></listitem>
> +<listitem><para><command>SET AUTOCOMMIT TO OFF</command> is no longer
> + supported; psql has an <envar>AUTOCOMMIT</envar> variable</para></listitem>
> +<listitem><para>Reimplementation of NUMERIC datatype for more speed</para></listitem>
> +<listitem><para>New regular expression package, many more regexp features (most of Perl5)</para></listitem>
> +<listitem><para>Can now do <command> EXPLAIN</command> ... <command>EXECUTE</command> to see plan used for a
preparedquery</para></listitem>
> +<listitem><para>Explicit <command>JOIN</command>s no longer constrain query
> + plan, unless <command>JOIN_COLLAPSE_LIMIT = 1</command></para></listitem>
> +<listitem><para>Performance of <command>foo IN (SELECT ...)</command> queries has been considerably
improved</para></listitem>
> +<listitem><para><command>FETCH 0</command> now re-fetches cursor's current row, per SQL spec</para></listitem>
> +<listitem><para>Revised executor state representation; plan trees are read-only to executor now</para></listitem>
> +<listitem><para>Information schema</para></listitem>
> +<listitem><para>Domains now support <command>CHECK</command> constraints</para></listitem>
> +<listitem><para><application>psql</application> backslash commands for listing conversions, casts, and
schemas</para></listitem>
> +<listitem><para><command>TRUNCATE TABLE</command> is transaction-safe</para></listitem>
> +<listitem><para><command>CLUSTER</command> can re-cluster a previously clustered table, or all such
tables</para></listitem>
> +<listitem><para>Statement-level triggers</para></listitem>
> +<listitem><para>System can use either hash- or sort-based strategy for grouped aggregation</para></listitem>
> +<listitem><para><command>ON COMMIT</command> options for temp tables</para></listitem>
> +<listitem><para>extra_float_digits option allows <application>pg_dump</application> to dump float data
accurately</para></listitem>
> +<listitem><para>Long options for <application>psql</application> and
> + <application>pg_dump</application> are now available on all platforms</para></listitem>
> +<listitem><para>Read-only transactions</para></listitem>
> +<listitem><para>Object owners can allow grantees to grant the
> + privilege to others (grant option)</para></listitem>
> +
> +<listitem><para> Added <filename>contrib</filename> module for
> +<application> pg_autovacuum </application> which monitors inserts and
> +deletes, and does <command>ANALYZE</command> or <command> VACUUM
> +ANALYZE </command> when quantities exceed specified
> +thresholds.</para></listitem>
> +
> +</itemizedlist></sect3>
> +
> +</sect2>
> +
> +</sect1>
>
>
> <sect1 id="release-7-3-4">
> @@ -129,70 +607,80 @@
> <itemizedlist>
> <listitem><para>Repair sometimes-incorrect computation of StartUpID after a crash</para></listitem>
> <listitem><para>Avoid slowness with lots of deferred triggers in one transaction (Stephan)</para></listitem>
> -<listitem><para>Don't lock referenced row when UPDATE doesn't change foreign key's value (Jan)</para></listitem>
> -<listitem><para>Use -fPIC not -fpic on Sparc (Tom Callaway)</para></listitem>
> +<listitem><para>Don't lock referenced row when <command>UPDATE</command> doesn't change foreign key's value
(Jan)</para></listitem>
> +<listitem><para>Use <command>-fPIC</command> not <command>-fpic</command> on Sparc (Tom Callaway)</para></listitem>
> <listitem><para>Repair lack of schema-awareness in contrib/reindexdb</para></listitem>
> <listitem><para>Fix contrib/intarray error for zero-element result array (Teodor)</para></listitem>
> <listitem><para>Ensure createuser script will exit on control-C (Oliver)</para></listitem>
> <listitem><para>Fix errors when the type of a dropped column has itself been dropped</para></listitem>
> -<listitem><para>CHECKPOINT does not cause database panic on failure in noncritical steps</para></listitem>
> +<listitem><para><command>CHECKPOINT</command> does not cause database panic on failure in noncritical
steps</para></listitem>
> <listitem><para>Accept 60 in seconds fields of timestamp, time, interval input values</para></listitem>
> -<listitem><para>Issue notice, not error, if TIMESTAMP, TIME, or INTERVAL precision too large</para></listitem>
> -<listitem><para>Fix abstime-to-time cast function (fix is not applied unless you initdb)</para></listitem>
> -<listitem><para>Fix pg_proc entry for timestamptz_izone (fix is not applied unless you initdb)</para></listitem>
> -<listitem><para>Make EXTRACT(EPOCH FROM timestamp without time zone) treat input as local time</para></listitem>
> -<listitem><para>'now'::timestamptz gave wrong answer if timezone changed earlier in transaction</para></listitem>
> -<listitem><para>HAVE_INT64_TIMESTAMP code for time with timezone overwrote its input</para></listitem>
> -<listitem><para>Accept GLOBAL TEMP/TEMPORARY as a synonym for TEMPORARY</para></listitem>
> +<listitem><para>Issue notice, not error, if <type>TIMESTAMP</type>,
> +<type> TIME</type>, or <type>INTERVAL</type> precision too large</para></listitem>
> +<listitem><para>Fix <function>abstime-to-time</function> cast function (fix is
> + not applied unless you <application>initdb</application>)</para></listitem>
> +<listitem><para>Fix <application>pg_proc</application> entry for
> +<type> <type>timestampt_izone</type> (fix is not applied unless you
> + <application>initdb</application>)</para></listitem>
> +<listitem><para>Make <function>EXTRACT(EPOCH FROM timestamp without time zone)</function> treat input as local
time</para></listitem>
> +<listitem><para><command>'now'::timestamptz</command> gave wrong answer if timezone changed earlier in
transaction</para></listitem>
> +<listitem><para><envar>HAVE_INT64_TIMESTAMP</envar> code for time with timezone overwrote its
input</para></listitem>
> +<listitem><para>Accept <command>GLOBAL TEMP/TEMPORARY</command> as a
> + synonym for <command>TEMPORARY</command></para></listitem>
> <listitem><para>Avoid improper schema-permissions-check failure in foreign-key triggers</para></listitem>
> -<listitem><para>Fix bugs in foreign-key triggers for SET DEFAULT action</para></listitem>
> -<listitem><para>Fix incorrect time-qual check in row fetch for UPDATE and DELETE triggers</para></listitem>
> -<listitem><para>Foreign-key clauses were parsed but ignored in ALTER TABLE ADD COLUMN</para></listitem>
> +<listitem><para>Fix bugs in foreign-key triggers for <command>SET DEFAULT</command> action</para></listitem>
> +<listitem><para>Fix incorrect time-qual check in row fetch for
> + <command>UPDATE</command> and <command>DELETE</command> triggers</para></listitem>
> +<listitem><para>Foreign-key clauses were parsed but ignored in
> + <command>ALTER TABLE ADD COLUMN</command></para></listitem>
> <listitem><para>Fix createlang script breakage for case where handler function already exists</para></listitem>
> -<listitem><para>Fix misbehavior on zero-column tables in pg_dump, COPY, ANALYZE, other places</para></listitem>
> -<listitem><para>Fix misbehavior of func_error() on type names containing '%'</para></listitem>
> -<listitem><para>Fix misbehavior of replace() on strings containing '%'</para></listitem>
> +<listitem><para>Fix misbehavior on zero-column tables in <application>pg_dump</application>, COPY, ANALYZE, other
places</para></listitem>
> +<listitem><para>Fix misbehavior of <function>func_error()</function> on type names containing '%'</para></listitem>
> +<listitem><para>Fix misbehavior of <function>replace()</function> on strings containing '%'</para></listitem>
> <listitem><para>Regular-expression patterns containing certain multibyte characters failed</para></listitem>
> -<listitem><para>Account correctly for NULLs in more cases in join size estimation</para></listitem>
> -<listitem><para>Avoid conflict with system definition of isblank() function or macro</para></listitem>
> +<listitem><para>Account correctly for <command>NULL</command>s in more cases in join size
estimation</para></listitem>
> +<listitem><para>Avoid conflict with system definition of <function>isblank()</function> function or
macro</para></listitem>
> <listitem><para>Fix failure to convert large code point values in EUC_TW conversions (Tatsuo)</para></listitem>
> -<listitem><para>Fix error recovery for SSL_read/SSL_write calls</para></listitem>
> +<listitem><para>Fix error recovery for <function>SSL_read</function>/<function>SSL_write</function>
calls</para></listitem>
> <listitem><para>Don't do early constant-folding of type coercion expressions</para></listitem>
> <listitem><para>Validate page header fields immediately after reading in any page</para></listitem>
> <listitem><para>Repair incorrect check for ungrouped variables in unnamed joins</para></listitem>
> -<listitem><para>Fix buffer overrun in to_ascii (Guido Notari)</para></listitem>
> +<listitem><para>Fix buffer overrun in <function>to_ascii</function> (Guido Notari)</para></listitem>
> <listitem><para>contrib/ltree fixes (Teodor)</para></listitem>
> <listitem><para>Fix core dump in deadlock detection on machines where char is unsigned</para></listitem>
> <listitem><para>Avoid running out of buffers in many-way indexscan (bug introduced in 7.3)</para></listitem>
> <listitem><para>Fix planner's selectivity estimation functions to handle domains properly</para></listitem>
> -<listitem><para>Fix dbmirror memory-allocation bug (Steven Singer)</para></listitem>
> -<listitem><para>Prevent infinite loop in ln(numeric) due to roundoff error</para></listitem>
> -<listitem><para>GROUP BY got confused if there were multiple equal GROUP BY items</para></listitem>
> -<listitem><para>Fix bad plan when inherited UPDATE/DELETE references another inherited table</para></listitem>
> +<listitem><para>Fix <application>dbmirror</application> memory-allocation bug (Steven Singer)</para></listitem>
> +<listitem><para>Prevent infinite loop in <function>ln(numeric)</function> due to roundoff error</para></listitem>
> +<listitem><para><command>GROUP BY</command> got confused if there were multiple equal GROUP BY
items</para></listitem>
> +<listitem><para>Fix bad plan when inherited <command>UPDATE</command>/<command>DELETE</command> references another
inheritedtable</para></listitem>
> <listitem><para>Prevent clustering on incomplete (partial or non-NULL-storing) indexes</para></listitem>
> <listitem><para>Service shutdown request at proper time if it arrives while still starting up</para></listitem>
> <listitem><para>Fix left-links in temporary indexes (could make backwards scans miss entries)</para></listitem>
> <listitem><para>Fix incorrect handling of client_encoding setting in postgresql.conf (Tatsuo)</para></listitem>
> -<listitem><para>Fix failure to respond to 'pg_ctl stop -m fast' after Async_NotifyHandler runs</para></listitem>
> +<listitem><para>Fix failure to respond to <command>pg_ctl stop -m fast</command> after Async_NotifyHandler
runs</para></listitem>
> <listitem><para>Fix SPI for case where rule contains multiple statements of the same type</para></listitem>
> <listitem><para>Fix problem with checking for wrong type of access permission in rule query</para></listitem>
> -<listitem><para>Fix problem with EXCEPT in CREATE RULE</para></listitem>
> +<listitem><para>Fix problem with <command>EXCEPT</command> in <command>CREATE RULE</command></para></listitem>
> <listitem><para>Prevent problem with dropping temp tables having serial columns</para></listitem>
> <listitem><para>Fix replace_vars_with_subplan_refs failure in complex views</para></listitem>
> <listitem><para>Fix regexp slowness in single-byte encodings (Tatsuo)</para></listitem>
> -<listitem><para>Allow qualified type names in CREATE CAST and DROP CAST</para></listitem>
> -<listitem><para>Accept 'SETOF type[]', which formerly had to be written 'SETOF _type'</para></listitem>
> -<listitem><para>Fix pg_dump core dump in some cases with procedural languages</para></listitem>
> -<listitem><para>Force ISO datestyle in pg_dump output, for portability (Oliver)</para></listitem>
> -<listitem><para>pg_dump failed to handle error return from lo_read (Oleg Drokin)</para></listitem>
> -<listitem><para>pg_dumpall failed with groups having no members (Nick Eskelinen)</para></listitem>
> -<listitem><para>pg_dumpall failed to recognize --globals-only switch</para></listitem>
> +<listitem><para>Allow qualified type names in <command>CREATE CAST</command>
> + and <command> DROP CAST</command></para></listitem>
> +<listitem><para>Accept <function>SETOF type[]</function>, which formerly had to
> + be written <function>SETOF _type</function></para></listitem>
> +<listitem><para>Fix <application>pg_dump</application> core dump in some cases with procedural
languages</para></listitem>
> +<listitem><para>Force ISO datestyle in <application>pg_dump</application> output, for portability
(Oliver)</para></listitem>
> +<listitem><para><application>pg_dump</application> failed to handle error return
> + from <function>lo_read</function> (Oleg Drokin)</para></listitem>
> +<listitem><para><application>pg_dumpall</application> failed with groups having no members (Nick
Eskelinen)</para></listitem>
> +<listitem><para><application>pg_dumpall</application> failed to recognize --globals-only switch</para></listitem>
> <listitem><para>pg_restore failed to restore blobs if -X disable-triggers is specified</para></listitem>
> <listitem><para>Repair intrafunction memory leak in plpgsql</para></listitem>
> -<listitem><para>pltcl's elog command dumped core if given wrong parameters (Ian Harding)</para></listitem>
> -<listitem><para>plpython used wrong value of atttypmod (Brad McLean)</para></listitem>
> +<listitem><para>pltcl's <command>elog</command> command dumped core if given wrong parameters (Ian
Harding)</para></listitem>
> +<listitem><para>plpython used wrong value of <envar>atttypmod</envar> (Brad McLean)</para></listitem>
> <listitem><para>Fix improper quoting of boolean values in Python interface (D'Arcy)</para></listitem>
> -<listitem><para>Added addDataType() method to PGConnection interface for JDBC</para></listitem>
> +<listitem><para>Added <function>addDataType()</function> method to PGConnection interface for JDBC</para></listitem>
> <listitem><para>Fixed various problems with updateable ResultSets for JDBC (Shawn Green)</para></listitem>
> <listitem><para>Fixed various problems with DatabaseMetaData for JDBC (Kris Jurka, Peter Royal)</para></listitem>
> <listitem><para>Fixed problem with parsing table ACLs in JDBC</para></listitem>
> @@ -229,13 +717,13 @@
>
> <itemizedlist>
> <listitem><para>Restore creation of OID column in CREATE TABLE AS / SELECT INTO</para></listitem>
> -<listitem><para>Fix pg_dump core dump when dumping views having comments</para></listitem>
> +<listitem><para>Fix <application/pg_dump/ core dump when dumping views having comments</para></listitem>
> <listitem><para>Dump DEFERRABLE/INITIALLY DEFERRED constraints properly</para></listitem>
> <listitem><para>Fix UPDATE when child table's column numbering differs from parent</para></listitem>
> <listitem><para>Increase default value of max_fsm_relations</para></listitem>
> <listitem><para>Fix problem when fetching backwards in a cursor for a single-row query</para></listitem>
> <listitem><para>Make backward fetch work properly with cursor on SELECT DISTINCT query</para></listitem>
> -<listitem><para>Fix problems with loading pg_dump files containing contrib/lo usage</para></listitem>
> +<listitem><para>Fix problems with loading <application/pg_dump/ files containing contrib/lo usage</para></listitem>
> <listitem><para>Fix problem with all-numeric user names</para></listitem>
> <listitem><para>Fix possible memory leak and core dump during disconnect in libpgtcl</para></listitem>
> <listitem><para>Make plpython's spi_execute command handle nulls properly (Andrew Bosma)</para></listitem>
> @@ -293,7 +781,7 @@
>
> <itemizedlist>
> <listitem><para>Fix a core dump of COPY TO when client/server encodings don't match (Tom)</para></listitem>
> -<listitem><para>Allow pg_dump to work with pre-7.2 servers (Philip)</para></listitem>
> +<listitem><para>Allow <application/pg_dump/ to work with pre-7.2 servers (Philip)</para></listitem>
> <listitem><para>contrib/adddepend fixes (Tom)</para></listitem>
> <listitem><para>Fix problem with deletion of per-user/per-database config settings (Tom)</para></listitem>
> <listitem><para>contrib/vacuumlo fix (Tom)</para></listitem>
> @@ -691,7 +1179,7 @@
> <itemizedlist>
> <listitem><para>Have COPY TO output embedded carriage returns and newlines as \r and \n (Tom)</para></listitem>
> <listitem><para>Allow DELIMITER in COPY FROM to be 8-bit clean (Tatsuo)</para></listitem>
> -<listitem><para>Make pg_dump use ALTER TABLE ADD PRIMARY KEY, for performance (Neil)</para></listitem>
> +<listitem><para>Make <application/pg_dump/ use ALTER TABLE ADD PRIMARY KEY, for performance (Neil)</para></listitem>
> <listitem><para>Disable brackets in multistatement rules (Bruce)</para></listitem>
> <listitem><para>Disable VACUUM from being called inside a function (Bruce)</para></listitem>
> <listitem><para>Allow dropdb and other scripts to use identifiers with spaces (Bruce)</para></listitem>
> @@ -703,7 +1191,7 @@
> <listitem><para>Add 'SET LOCAL var = value' to set configuration variables for a single transaction
(Tom)</para></listitem>
> <listitem><para>Allow ANALYZE to run in a transaction (Bruce)</para></listitem>
> <listitem><para>Improve COPY syntax using new WITH clauses, keep backward compatibility (Bruce)</para></listitem>
> -<listitem><para>Fix pg_dump to consistently output tags in non-ASCII dumps (Bruce)</para></listitem>
> +<listitem><para>Fix <application/pg_dump/ to consistently output tags in non-ASCII dumps (Bruce)</para></listitem>
> <listitem><para>Make foreign key constraints clearer in dump file (Rod)</para></listitem>
> <listitem><para>Add COMMENT ON CONSTRAINT (Rod)</para></listitem>
> <listitem><para>Allow COPY TO/FROM to specify column names (Brent Verner)</para></listitem>
> @@ -712,9 +1200,9 @@
> <listitem><para>Generate failure on short COPY lines rather than pad NULLs (Neil)</para></listitem>
> <listitem><para>Fix CLUSTER to preserve all table attributes (Alvaro Herrera)</para></listitem>
> <listitem><para>New pg_settings table to view/modify GUC settings (Joe)</para></listitem>
> -<listitem><para>Add smart quoting, portability improvements to pg_dump output (Peter)</para></listitem>
> +<listitem><para>Add smart quoting, portability improvements to <application/pg_dump/ output
(Peter)</para></listitem>
> <listitem><para>Dump serial columns out as SERIAL (Tom)</para></listitem>
> -<listitem><para>Enable large file support, >2G for pg_dump (Peter, Philip Warner, Bruce)</para></listitem>
> +<listitem><para>Enable large file support, >2G for <application/pg_dump/ (Peter, Philip Warner,
Bruce)</para></listitem>
> <listitem><para>Disallow TRUNCATE on tables that are involved in referential constraints (Rod)</para></listitem>
> <listitem><para>Have TRUNCATE also auto-truncate the toast table of the relation (Tom)</para></listitem>
> <listitem><para>Add clusterdb utility that will auto-cluster an entire database based on previous CLUSTER operations
(AlvaroHerrera)</para></listitem>
> @@ -1022,7 +1510,7 @@
> <listitem><para>Handle pre-1970 date values in newer versions of glibc (Tom)</para></listitem>
> <listitem><para>Fix possible hang during server shutdown</para></listitem>
> <listitem><para>Prevent spinlock hangs on SMP PPC machines (Tomoyuki Niijima)</para></listitem>
> -<listitem><para>Fix pg_dump to properly dump FULL JOIN USING (Tom)</para></listitem>
> +<listitem><para>Fix <application/pg_dump/ to properly dump FULL JOIN USING (Tom)</para></listitem>
> </itemizedlist>
> </sect2>
> </sect1>
> @@ -1056,7 +1544,7 @@
> <listitem><para>Allow EXECUTE of "CREATE TABLE AS ... SELECT" in PL/pgSQL (Tom)</para></listitem>
> <listitem><para>Fix for compressed transaction log id wraparound (Tom)</para></listitem>
> <listitem><para>Fix PQescapeBytea/PQunescapeBytea so that they handle bytes > 0x7f (Tatsuo)</para></listitem>
> -<listitem><para>Fix for psql and pg_dump crashing when invoked with non-existent long options
(Tatsuo)</para></listitem>
> +<listitem><para>Fix for psql and <application/pg_dump/ crashing when invoked with non-existent long options
(Tatsuo)</para></listitem>
> <listitem><para>Fix crash when invoking geometric operators (Tom)</para></listitem>
> <listitem><para>Allow OPEN cursor(args) (Tom)</para></listitem>
> <listitem><para>Fix for rtree_gist index build (Teodor)</para></listitem>
> @@ -1466,7 +1954,7 @@
> <sect3>
> <title>Internationalization</title>
> <itemizedlist>
> -<listitem><para>National language support in psql, pg_dump, libpq, and server (Peter E)</para></listitem>
> +<listitem><para>National language support in psql, <application/pg_dump/, libpq, and server (Peter
E)</para></listitem>
> <listitem><para>Message translations in Chinese (simplified, traditional), Czech, French, German, Hungarian,
Russian,Swedish (Peter E, Serguei A. Mokhov, Karel Zak, Weiping He, Zhenbang Wei, Kovacs Zoltan)</para></listitem>
> <listitem><para>Make trim, ltrim, rtrim, btrim, lpad, rpad, translate multibyte aware (Tatsuo)</para></listitem>
> <listitem><para>Add LATIN5,6,7,8,9,10 support (Tatsuo)</para></listitem>
> @@ -1612,7 +2100,7 @@
> <listitem><para>Python fix fetchone() (Gerhard Haring)</para></listitem>
> <listitem><para>Use UTF, Unicode in Tcl where appropriate (Vsevolod Lobko, Reinhard Max)</para></listitem>
> <listitem><para>Add Tcl COPY TO/FROM (ljb)</para></listitem>
> -<listitem><para>Prevent output of default index op class in pg_dump (Tom)</para></listitem>
> +<listitem><para>Prevent output of default index op class in <application/pg_dump/ (Tom)</para></listitem>
> <listitem><para>Fix libpgeasy memory leak (Bruce)</para></listitem>
> </itemizedlist>
> </sect3>
>
> --
> select 'cbbrowne' || '@' || 'ntlug.org';
> http://cbbrowne.com/info/internet.html
> "Have you noticed that, when we were young, we were told that
> `everybody else is doing it' was a really stupid reason to do
> something, but now it's the standard reason for picking a particular
> software package?" -- Barry Gehm
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
pgsql-patches by date: