Module Name:	pkgsrc
Committed By:	jlam
Date:		Sun Oct 23 20:16:52 UTC 2005

Modified Files:
	pkgsrc/databases/postgresql80: Makefile Makefile.common distinfo
	    options.mk
	pkgsrc/databases/postgresql80-client: Makefile PLIST
	pkgsrc/databases/postgresql80-plperl: Makefile
	pkgsrc/databases/postgresql80-server: Makefile PLIST

Log Message:
Update postgresql80-related packages to 8.0.4.  On updating from any
previous 8.0.x release, no dump-and-restore is necessary.  Changes
from version 8.0.3 include:

postgresql80-client:
     - Clarify comment for pgsql-hier-query option to note that it is
       considered buggy by PostgreSQL developers.
     * Make psql -f filename return a nonzero exit code when opening the
       file fails
     * Change pg_dump to handle inherited check constraints more reliably

postgresql80-server:
     * Fix error that allowed "VACUUM" to remove ctid chains too soon, and
       add more checking in code that follows ctid links
       This fixes a long-standing problem that could cause crashes in very
       rare circumstances.
     * Fix CHAR() to properly pad spaces to the specified length when
       using a multiple-byte character set (Yoshiyuki Asaba)
       In prior releases, the padding of CHAR() was incorrect because it
       only padded to the specified number of bytes without considering
       how many characters were stored.
     * Force a checkpoint before committing "CREATE DATABASE"
       This should fix recent reports of "index is not a btree" failures
       when a crash occurs shortly after "CREATE DATABASE".
     * Fix the sense of the test for read-only transaction in "COPY"
       The code formerly prohibited "COPY TO", where it should prohibit
       "COPY FROM".
     * Handle consecutive embedded newlines in "COPY" CSV-mode input
     * Fix date_trunc(week) for dates near year end
     * Fix planning problem with outer-join ON clauses that reference only
       the inner-side relation
     * Further fixes for x FULL JOIN y ON true corner cases
     * Fix overenthusiastic optimization of x IN (SELECT DISTINCT ...) and
       related cases
     * Fix mis-planning of queries with small LIMIT values due to poorly
       thought out "fuzzy" cost comparison
     * Make array_in and array_recv more paranoid about validating their
       OID parameter
     * Fix missing rows in queries like UPDATE a=... WHERE a... with GiST
       index on column a
     * Improve robustness of datetime parsing
     * Improve checking for partially-written WAL pages
     * Improve robustness of signal handling when SSL is enabled
     * Improve MIPS and M68K spinlock code
     * Don't try to open more than max_files_per_process files during
       postmaster startup
     * Various memory leakage fixes
     * Various portability improvements
     * Update timezone data files
     * Fix PL/PgSQL to handle var := var correctly when the variable is of
       pass-by-reference type

postgresql80-plperl:
     * Fix PL/Perl %_SHARED so it's actually shared


To generate a diff of this commit:
cvs rdiff -r1.5 -r1.6 pkgsrc/databases/postgresql80/Makefile
cvs rdiff -r1.8 -r1.9 pkgsrc/databases/postgresql80/Makefile.common
cvs rdiff -r1.9 -r1.10 pkgsrc/databases/postgresql80/distinfo
cvs rdiff -r1.2 -r1.3 pkgsrc/databases/postgresql80/options.mk
cvs rdiff -r1.10 -r1.11 pkgsrc/databases/postgresql80-client/Makefile
cvs rdiff -r1.7 -r1.8 pkgsrc/databases/postgresql80-client/PLIST
cvs rdiff -r1.2 -r1.3 pkgsrc/databases/postgresql80-plperl/Makefile
cvs rdiff -r1.13 -r1.14 pkgsrc/databases/postgresql80-server/Makefile
cvs rdiff -r1.6 -r1.7 pkgsrc/databases/postgresql80-server/PLIST

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.