Re: release.sgml, minor pg_autovacuum changes - Mailing list pgsql-patches
| From | Larry Rosenman |
|---|---|
| Subject | Re: release.sgml, minor pg_autovacuum changes |
| Date | |
| Msg-id | 223670000.1066150935@lerlaptop-red.iadfw.net Whole thread Raw |
| In response to | release.sgml, minor pg_autovacuum changes (Christopher Browne <cbbrowne@acm.org>) |
| List | pgsql-patches |
I've also run it on UnixWare 7.1.3. FWIW.
LER
--On Sunday, October 12, 2003 23:46:26 -0400 Christopher Browne
<cbbrowne@acm.org> 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 prepared
> query</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 inherited table</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 (Alvaro Herrera)</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
>
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
Attachment
pgsql-patches by date: