Module Name:	pkgsrc
Committed By:	jlam
Date:		Sat May 20 19:33:01 UTC 2000

Modified Files:
	pkgsrc/databases/postgresql: Makefile Makefile.common
	pkgsrc/databases/postgresql/files: Makefile.custom md5 patch-sum
	pkgsrc/databases/postgresql/pkg: PLIST
Added Files:
	pkgsrc/databases/postgresql/files: exclude man.tcl man.tk odbcinst.ini
Removed Files:
	pkgsrc/databases/postgresql/files: odbc.ini
	pkgsrc/databases/postgresql/patches: patch-aa patch-ab patch-ac
	    patch-ad patch-ae patch-af patch-ag patch-ah patch-ai patch-aj
	    patch-ak patch-al patch-am patch-an patch-ao patch-ap patch-aq
	    patch-ar patch-as patch-at

Log Message:
Update postgresql to 7.0.  Also closes PR#8616.  Changes from 6.5.3:

   A HUGE number of bug/performance fixes and minor enhancements.

   Foreign Keys
          Foreign keys are now implemented, with the exception of PARTIAL
          MATCH foreign keys. Many users have been asking for this
          feature, and we are pleased to offer it.

   Optimizer Overhaul
          Continuing on work started a year ago, the optimizer has been
          overhauled, allowing improved query execution and better
          performance with less memory usage.

   Updated psql
          psql, our interactive terminal monitor, has been updated with a
          variety of new features. See the psql manual page for details.

   Upcoming Features
          In 7.1 or 7.2, we plan to have outer joins, storage for very
          long rows, and a write-ahead logging system.

   A dump/restore using pg_dump is required for those wishing to migrate
   data from any previous release. For those upgrading from 6.5.*, you
   can use pg_upgrade to upgrade to this release.


To generate a diff of this commit:
cvs rdiff -r1.48 -r1.49 pkgsrc/databases/postgresql/Makefile
cvs rdiff -r1.1 -r1.2 pkgsrc/databases/postgresql/Makefile.common
cvs rdiff -r1.3 -r1.4 pkgsrc/databases/postgresql/files/Makefile.custom
cvs rdiff -r0 -r1.1 pkgsrc/databases/postgresql/files/exclude \
    pkgsrc/databases/postgresql/files/man.tcl \
    pkgsrc/databases/postgresql/files/man.tk \
    pkgsrc/databases/postgresql/files/odbcinst.ini
cvs rdiff -r1.7 -r1.8 pkgsrc/databases/postgresql/files/md5
cvs rdiff -r1.1 -r0 pkgsrc/databases/postgresql/files/odbc.ini
cvs rdiff -r1.9 -r1.10 pkgsrc/databases/postgresql/files/patch-sum
cvs rdiff -r1.4 -r0 pkgsrc/databases/postgresql/patches/patch-aa \
    pkgsrc/databases/postgresql/patches/patch-am
cvs rdiff -r1.8 -r0 pkgsrc/databases/postgresql/patches/patch-ab
cvs rdiff -r1.5 -r0 pkgsrc/databases/postgresql/patches/patch-ac \
    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 -r1.6 -r0 pkgsrc/databases/postgresql/patches/patch-ad
cvs rdiff -r1.10 -r0 pkgsrc/databases/postgresql/patches/patch-ae
cvs rdiff -r1.7 -r0 pkgsrc/databases/postgresql/patches/patch-af
cvs rdiff -r1.2 -r0 pkgsrc/databases/postgresql/patches/patch-ak \
    pkgsrc/databases/postgresql/patches/patch-an \
    pkgsrc/databases/postgresql/patches/patch-ao
cvs rdiff -r1.3 -r0 pkgsrc/databases/postgresql/patches/patch-al
cvs rdiff -r1.1 -r0 pkgsrc/databases/postgresql/patches/patch-ap \
    pkgsrc/databases/postgresql/patches/patch-aq \
    pkgsrc/databases/postgresql/patches/patch-ar \
    pkgsrc/databases/postgresql/patches/patch-as \
    pkgsrc/databases/postgresql/patches/patch-at
cvs rdiff -r1.12 -r1.13 pkgsrc/databases/postgresql/pkg/PLIST

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