Module Name:	pkgsrc
Committed By:	jlam
Date:		Mon May 14 14:52:39 UTC 2001

Modified Files:
	pkgsrc/databases/postgresql: Makefile Makefile.common distinfo
	pkgsrc/databases/postgresql/files: Makefile.custom
	pkgsrc/databases/postgresql/patches: patch-ab patch-ac patch-ad
	    patch-ae patch-af patch-ag patch-ah patch-ai patch-aj
	pkgsrc/databases/postgresql/pkg: DESCR PLIST
Added Files:
	pkgsrc/databases/postgresql: Makefile.getopt Makefile.readline
	    Makefile.ssl
	pkgsrc/databases/postgresql/files: GNUmakefile.libpq
	pkgsrc/databases/postgresql/patches: patch-aa patch-ak
Removed Files:
	pkgsrc/databases/postgresql/files: exclude man.tcl man.tk odbcinst.ini
	    pgsql.sh post-install-notes postgresql-7.0.3-alpha.diff
	    profile.pgsql
	pkgsrc/databases/postgresql/pkg: DEINSTALL INSTALL PLIST.dirrm
	    PLIST.spi

Log Message:
Update postgresql to 7.1.1  Pkgsrc changes include splitting into:

	postgresql-lib
	postgresql-client
	postgresql-server
	postgresql-doc

with postgresql as a meta-package.  Major changes from version 7.1.1
include:

	Write-ahead Log (WAL) - To maintain database consistency in
case of an operating system crash, previous releases of PostgreSQL
have forced all data modifications to disk before each transaction
commit.  With WAL, only one log file must be flushed to disk, greatly
improving performance.  If you have been using -F in previous releases
to disable disk flushes, you may want to consider discontinuing its
use.

	TOAST - Previous releases had a compiled-in row length limit,
typically 8 - 32 kB.  This limit made storage of long text fields
difficult.  With TOAST, long rows of any length can be stored with
good performance.

	Outer Joins - We now support outer joins.  The UNION/NOT IN
workaround for outer joins is no longer required.  We use the SQL92
outer join syntax.

	Function Manager - The previous C function manager did not
handle NULLs properly, nor did it support 64-bit CPU's (Alpha).  The
new function manager does.  You can continue using your old custom
functions, but you may want to rewrite them in the future to use the
new function manager call interface.

	Complex Queries - A large number of complex queries that were
unsupported in previous releases now work.  Many combinations of
views, aggregates, UNION, LIMIT, cursors, subqueries, and inherited
tables now work properly. Inherited tables are now accessed by
default.  Subqueries in FROM are now supported.

Migration to 7.1.1

   A dump/restore using pg_dump is required for those wishing to migrate
   data from any previous release.


To generate a diff of this commit:
cvs rdiff -r1.63 -r1.64 pkgsrc/databases/postgresql/Makefile
cvs rdiff -r1.11 -r1.12 pkgsrc/databases/postgresql/Makefile.common
cvs rdiff -r0 -r1.1 pkgsrc/databases/postgresql/Makefile.getopt \
    pkgsrc/databases/postgresql/Makefile.readline \
    pkgsrc/databases/postgresql/Makefile.ssl
cvs rdiff -r1.2 -r1.3 pkgsrc/databases/postgresql/distinfo
cvs rdiff -r0 -r1.1 pkgsrc/databases/postgresql/files/GNUmakefile.libpq
cvs rdiff -r1.4 -r1.5 pkgsrc/databases/postgresql/files/Makefile.custom
cvs rdiff -r1.1 -r0 pkgsrc/databases/postgresql/files/exclude \
    pkgsrc/databases/postgresql/files/man.tcl \
    pkgsrc/databases/postgresql/files/man.tk \
    pkgsrc/databases/postgresql/files/odbcinst.ini \
    pkgsrc/databases/postgresql/files/postgresql-7.0.3-alpha.diff \
    pkgsrc/databases/postgresql/files/profile.pgsql
cvs rdiff -r1.3 -r0 pkgsrc/databases/postgresql/files/pgsql.sh
cvs rdiff -r1.6 -r0 pkgsrc/databases/postgresql/files/post-install-notes
cvs rdiff -r0 -r1.8 pkgsrc/databases/postgresql/patches/patch-aa
cvs rdiff -r1.10 -r1.11 pkgsrc/databases/postgresql/patches/patch-ab
cvs rdiff -r1.8 -r1.9 pkgsrc/databases/postgresql/patches/patch-ac
cvs rdiff -r1.9 -r1.10 pkgsrc/databases/postgresql/patches/patch-ad
cvs rdiff -r1.12 -r1.13 pkgsrc/databases/postgresql/patches/patch-ae \
    pkgsrc/databases/postgresql/patches/patch-af
cvs rdiff -r1.7 -r1.8 pkgsrc/databases/postgresql/patches/patch-ag \
    pkgsrc/databases/postgresql/patches/patch-ah \
    pkgsrc/databases/postgresql/patches/patch-ai \
    pkgsrc/databases/postgresql/patches/patch-aj
cvs rdiff -r0 -r1.4 pkgsrc/databases/postgresql/patches/patch-ak
cvs rdiff -r1.5 -r0 pkgsrc/databases/postgresql/pkg/DEINSTALL
cvs rdiff -r1.2 -r1.3 pkgsrc/databases/postgresql/pkg/DESCR
cvs rdiff -r1.4 -r0 pkgsrc/databases/postgresql/pkg/INSTALL
cvs rdiff -r1.18 -r1.19 pkgsrc/databases/postgresql/pkg/PLIST
cvs rdiff -r1.3 -r0 pkgsrc/databases/postgresql/pkg/PLIST.dirrm
cvs rdiff -r1.1 -r0 pkgsrc/databases/postgresql/pkg/PLIST.spi

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