Upgrade postgresql to version 6.3.2

Many bugfixes and cosmetic changes
Changes by Scrappy and me
My additional changes:
- had to link libpgtcl.so with the crypt library to get rid of the
  pgaccess error message, that crypt is missing
- had to add -i option in the startup script, so that pgaccess is
  able to connect to the postmaster process
- removed all unnecessary patches
- updated PLIST
Thanks to the postgresql developement team, who did a great job to
simplify the postgresql port, by applying the patches and making
the autoconf mechanism more consistent.
Submitted by:	The Hermit Hacker <scrappy@hub.org>

4 files changed, 148 insertions, 77 deletions

diff --git a/databases/postgresql92-server/Makefile b/databases/postgresql92-server/Makefile
index 0cc83efe5fc4..476257fd2ee4 100644
--- a/databases/postgresql92-server/Makefile
+++ b/databases/postgresql92-server/Makefile
@@ -3,11 +3,13 @@
 # Date created:		April 2, 1997
 # Whom:			Marc G. Fournier <scrappy@FreeBSD.ORG>
 #
-# $Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp $
+# $Id: Makefile,v 1.23 1998/03/22 16:45:18 andreas Exp $
 
-DISTNAME=	postgresql-6.2.1
+PATCH_DEBUG=	yes
+
+DISTNAME=	postgresql-6.3.2
 CATEGORIES=	databases
-MASTER_SITES=	http://www.freebsd.org/~andreas/download/
+MASTER_SITES=	ftp://ftp.postgresql.org/pub/
 
 MAINTAINER=	andreas@FreeBSD.ORG
 
@@ -16,6 +18,7 @@ MAINTAINER=	andreas@FreeBSD.ORG
 .if defined(USE_TCL)
 MAKE_ENV=	USE_TCL=true TCL_INCDIR=${PREFIX}/include/tcl8.0
 LIB_DEPENDS=	tcl80\\.1\\.:${PORTSDIR}/lang/tcl80
+WITH_TCL=	--with-tcl
 .endif
 
 NO_PACKAGE=	"Requires pgsql uid"
@@ -26,26 +29,28 @@ MAKEFILE=	GNUmakefile
 HAS_CONFIGURE=	YES
 CONFIGURE_ARGS= --prefix=${PREFIX}/pgsql \
 		--enable-locale \
-		--with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'`
+		--with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` \
+		--with-includes=/usr/local/include ${WITH_TCL} \
+		--with-libraries=/usr/local/lib
 
 MAN1=		cleardbdir.1 createdb.1 createuser.1 destroydb.1 \
-		destroyuser.1 initdb.1 ipcclean.1 monitor.1 pg_dump.1 \
-		pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \
+		destroyuser.1 ecpg.1 initdb.1 ipcclean.1 initlocation.1 \
+		pg_dump.1 pg_dumpall.1 pg_passwd.1 pgintro.1 postgres.1 \
 		postmaster.1 psql.1
 MAN3=		catalogs.3 large_objects.3 libpq.3 oracle_compat.3 pgbuiltin.3
 MAN5=		bki.5 page.5 pg_hba.conf.5
-MANL=		abort.l alter_table.l begin.l close.l cluster.l \
+MANL=		abort.l alter_table.l alter_user.l begin.l close.l cluster.l \
 		commit.l copy.l create_aggregate.l create_database.l \
-		create_function.l create_index.l create_operator.l \
-		create_rule.l create_sequence.l create_table.l \
-		create_trigger.l create_type.l create_version.l \
-		create_view.l declare.l delete.l drop.l drop_aggregate.l \
-		drop_database.l drop_function.l drop_index.l drop_operator.l \
-		drop_rule.l drop_sequence.l drop_table.l drop_trigger.l \
-		drop_type.l drop_view.l end.l explain.l fetch.l grant.l \
-		insert.l listen.l load.l move.l notify.l purge.l rename.l \
-		reset.l revoke.l rollback.l select.l set.l show.l sql.l \
-		update.l vacuum.l
+		create_function.l create_index.l create_language.l \
+		create_operator.l create_rule.l create_sequence.l \
+		create_table.l create_trigger.l create_type.l create_user.l \
+		create_version.l create_view.l declare.l delete.l drop.l \
+		drop_aggregate.l drop_database.l drop_function.l drop_index.l \
+		drop_language.l drop_operator.l drop_rule.l drop_sequence.l \
+		drop_table.l drop_trigger.l drop_type.l drop_user.l \
+		drop_view.l end.l explain.l fetch.l grant.l insert.l listen.l \
+		load.l lock.l move.l notify.l reset.l revoke.l \
+		rollback.l select.l set.l show.l sql.l update.l vacuum.l
 
 MANPREFIX=	${PREFIX}/pgsql
 
diff --git a/databases/postgresql92-server/distinfo b/databases/postgresql92-server/distinfo
index 5d42f88c853a..dc42f89ecf8d 100644
--- a/databases/postgresql92-server/distinfo
+++ b/databases/postgresql92-server/distinfo
@@ -1 +1 @@
-MD5 (postgresql-6.2.1.tar.gz) = bd606dcab6b09a3a3d276d88b504a1d3
+MD5 (postgresql-6.3.2.tar.gz) = 8902842461c9a42854ba9883bee56a4c
diff --git a/databases/postgresql92-server/files/pgsql.sh.tmpl b/databases/postgresql92-server/files/pgsql.sh.tmpl
index 9fd81e4ff367..ed6c54d18839 100644
--- a/databases/postgresql92-server/files/pgsql.sh.tmpl
+++ b/databases/postgresql92-server/files/pgsql.sh.tmpl
@@ -1,6 +1,6 @@
 #!/bin/sh
 
-# $Id: pgsql.sh.tmpl,v 1.2 1997/10/03 18:26:54 andreas Exp $
+# $Id: pgsql.sh.tmpl,v 1.3 1997/10/05 21:00:49 andreas Exp $
 
 # pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested)
 
@@ -19,7 +19,7 @@
 [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib
 
 [ -x !!PREFIX!!/pgsql/bin/postmaster ] && {
-	su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster \
-		-S -o -F > !!PREFIX!!/pgsql/errlog'
+	su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/postmaster -i -S -o -F \
+		-D!!PREFIX!!/pgsql/data > !!PREFIX!!/pgsql/errlog'
 	echo -n ' pgsql' 
 }
diff --git a/databases/postgresql92-server/pkg-plist b/databases/postgresql92-server/pkg-plist
index 985c0a47ac30..5e5936ec028e 100644
--- a/databases/postgresql92-server/pkg-plist
+++ b/databases/postgresql92-server/pkg-plist
@@ -5,7 +5,10 @@ pgsql/bin/createdb
 pgsql/bin/createuser
 pgsql/bin/destroydb
 pgsql/bin/destroyuser
+pgsql/bin/ecpg
 pgsql/bin/initdb
+pgsql/bin/initlocation
+pgsql/bin/ipcclean
 pgsql/bin/pg_dump
 pgsql/bin/pg_dumpall
 pgsql/bin/pg_id
@@ -14,7 +17,6 @@ pgsql/bin/pg_version
 pgsql/bin/pgtclsh
 pgsql/bin/pgtksh
 pgsql/bin/postgres
-pgsql/bin/postmaster
 pgsql/bin/psql
 pgsql/data/PG_VERSION
 pgsql/data/base/template1/PG_VERSION
@@ -22,15 +24,17 @@ pgsql/data/base/template1/pg_aggregate
 pgsql/data/base/template1/pg_am
 pgsql/data/base/template1/pg_amop
 pgsql/data/base/template1/pg_amproc
-pgsql/data/base/template1/pg_attnameind
-pgsql/data/base/template1/pg_attnumind
 pgsql/data/base/template1/pg_attrdef
-pgsql/data/base/template1/pg_attrdefind
-pgsql/data/base/template1/pg_attrelidind
+pgsql/data/base/template1/pg_attrdef_adrelid_index
 pgsql/data/base/template1/pg_attribute
+pgsql/data/base/template1/pg_attribute_attrelid_index
+pgsql/data/base/template1/pg_attribute_relid_attnam_index
+pgsql/data/base/template1/pg_attribute_relid_attnum_index
 pgsql/data/base/template1/pg_class
-pgsql/data/base/template1/pg_classnameind
-pgsql/data/base/template1/pg_classoidind
+pgsql/data/base/template1/pg_class_oid_index
+pgsql/data/base/template1/pg_class_relname_index
+pgsql/data/base/template1/pg_description
+pgsql/data/base/template1/pg_description_objoid_index
 pgsql/data/base/template1/pg_index
 pgsql/data/base/template1/pg_inheritproc
 pgsql/data/base/template1/pg_inherits
@@ -42,35 +46,36 @@ pgsql/data/base/template1/pg_opclass
 pgsql/data/base/template1/pg_operator
 pgsql/data/base/template1/pg_parg
 pgsql/data/base/template1/pg_proc
-pgsql/data/base/template1/pg_procidind
-pgsql/data/base/template1/pg_procnameind
-pgsql/data/base/template1/pg_procsrcind
+pgsql/data/base/template1/pg_proc_oid_index
+pgsql/data/base/template1/pg_proc_proname_index
+pgsql/data/base/template1/pg_proc_prosrc_index
 pgsql/data/base/template1/pg_relcheck
-pgsql/data/base/template1/pg_relcheckind
+pgsql/data/base/template1/pg_relcheck_rcrelid_index
 pgsql/data/base/template1/pg_rewrite
 pgsql/data/base/template1/pg_statistic
 pgsql/data/base/template1/pg_trigger
-pgsql/data/base/template1/pg_trigrelidind
+pgsql/data/base/template1/pg_trigger_tgrelid_index
 pgsql/data/base/template1/pg_type
-pgsql/data/base/template1/pg_typeidind
-pgsql/data/base/template1/pg_typenameind
+pgsql/data/base/template1/pg_type_oid_index
+pgsql/data/base/template1/pg_type_typname_index
+pgsql/data/base/template1/pg_user
 pgsql/data/base/template1/pg_version
 pgsql/data/pg_database
-pgsql/data/pg_defaults
-pgsql/data/pg_demon
 pgsql/data/pg_geqo.sample
 pgsql/data/pg_group
 pgsql/data/pg_hba.conf
-pgsql/data/pg_hosts
 pgsql/data/pg_log
-pgsql/data/pg_magic
-pgsql/data/pg_server
-pgsql/data/pg_time
-pgsql/data/pg_user
+pgsql/data/pg_pwd
+pgsql/data/pg_shadow
 pgsql/data/pg_variable
+pgsql/errlog
 pgsql/include/access/attnum.h
 pgsql/include/c.h
+pgsql/include/commands/trigger.h
 pgsql/include/config.h
+pgsql/include/ecpglib.h
+pgsql/include/ecpgtype.h
+pgsql/include/executor/spi.h
 pgsql/include/fmgr.h
 pgsql/include/lib/dllist.h
 pgsql/include/libpgtcl.h
@@ -80,17 +85,20 @@ pgsql/include/libpq/pqcomm.h
 pgsql/include/os.h
 pgsql/include/postgres.h
 pgsql/include/postgres_ext.h
+pgsql/include/sqlca.h
 pgsql/include/utils/elog.h
 pgsql/include/utils/geo_decls.h
 pgsql/include/utils/palloc.h
 pgsql/lib/global1.bki.source
+pgsql/lib/global1.description
+pgsql/lib/libecpg.a
+pgsql/lib/libecpg.so.1.1
 pgsql/lib/libpgtcl.a
-pgsql/lib/libpgtcl.so
 pgsql/lib/libpgtcl.so.1.0
 pgsql/lib/libpq.a
-pgsql/lib/libpq.so
-pgsql/lib/libpq.so.1.0
+pgsql/lib/libpq.so.1.1
 pgsql/lib/local1_template1.bki.source
+pgsql/lib/local1_template1.description
 pgsql/lib/pg_geqo.sample
 pgsql/lib/pg_hba.conf.sample
 pgsql/man/man1/cleardbdir.1.gz
@@ -98,9 +106,10 @@ pgsql/man/man1/createdb.1.gz
 pgsql/man/man1/createuser.1.gz
 pgsql/man/man1/destroydb.1.gz
 pgsql/man/man1/destroyuser.1.gz
+pgsql/man/man1/ecpg.1.gz
 pgsql/man/man1/initdb.1.gz
+pgsql/man/man1/initlocation.1.gz
 pgsql/man/man1/ipcclean.1.gz
-pgsql/man/man1/monitor.1.gz
 pgsql/man/man1/pg_dump.1.gz
 pgsql/man/man1/pg_dumpall.1.gz
 pgsql/man/man1/pg_passwd.1.gz
@@ -118,6 +127,7 @@ pgsql/man/man5/page.5.gz
 pgsql/man/man5/pg_hba.conf.5.gz
 pgsql/man/manl/abort.l.gz
 pgsql/man/manl/alter_table.l.gz
+pgsql/man/manl/alter_user.l.gz
 pgsql/man/manl/begin.l.gz
 pgsql/man/manl/close.l.gz
 pgsql/man/manl/cluster.l.gz
@@ -127,12 +137,14 @@ pgsql/man/manl/create_aggregate.l.gz
 pgsql/man/manl/create_database.l.gz
 pgsql/man/manl/create_function.l.gz
 pgsql/man/manl/create_index.l.gz
+pgsql/man/manl/create_language.l.gz
 pgsql/man/manl/create_operator.l.gz
 pgsql/man/manl/create_rule.l.gz
 pgsql/man/manl/create_sequence.l.gz
 pgsql/man/manl/create_table.l.gz
 pgsql/man/manl/create_trigger.l.gz
 pgsql/man/manl/create_type.l.gz
+pgsql/man/manl/create_user.l.gz
 pgsql/man/manl/create_version.l.gz
 pgsql/man/manl/create_view.l.gz
 pgsql/man/manl/declare.l.gz
@@ -142,12 +154,14 @@ pgsql/man/manl/drop_aggregate.l.gz
 pgsql/man/manl/drop_database.l.gz
 pgsql/man/manl/drop_function.l.gz
 pgsql/man/manl/drop_index.l.gz
+pgsql/man/manl/drop_language.l.gz
 pgsql/man/manl/drop_operator.l.gz
 pgsql/man/manl/drop_rule.l.gz
 pgsql/man/manl/drop_sequence.l.gz
 pgsql/man/manl/drop_table.l.gz
 pgsql/man/manl/drop_trigger.l.gz
 pgsql/man/manl/drop_type.l.gz
+pgsql/man/manl/drop_user.l.gz
 pgsql/man/manl/drop_view.l.gz
 pgsql/man/manl/end.l.gz
 pgsql/man/manl/explain.l.gz
@@ -156,10 +170,9 @@ pgsql/man/manl/grant.l.gz
 pgsql/man/manl/insert.l.gz
 pgsql/man/manl/listen.l.gz
 pgsql/man/manl/load.l.gz
+pgsql/man/manl/lock.l.gz
 pgsql/man/manl/move.l.gz
 pgsql/man/manl/notify.l.gz
-pgsql/man/manl/purge.l.gz
-pgsql/man/manl/rename.l.gz
 pgsql/man/manl/reset.l.gz
 pgsql/man/manl/revoke.l.gz
 pgsql/man/manl/rollback.l.gz
@@ -171,51 +184,104 @@ pgsql/man/manl/update.l.gz
 pgsql/man/manl/vacuum.l.gz
 pgsql/post-install-notes
 share/doc/pgsql/FAQ
-share/doc/pgsql/FAQ-Irix
-share/doc/pgsql/FAQ-Linux
+share/doc/pgsql/FAQ_FreeBSD
+share/doc/pgsql/FAQ_Irix
+share/doc/pgsql/FAQ_Linux
+share/doc/pgsql/Makefile
 share/doc/pgsql/README.GEQO
 share/doc/pgsql/README.fsync
+share/doc/pgsql/README.mb
+share/doc/pgsql/README.mb.jp
 share/doc/pgsql/README.support
 share/doc/pgsql/TODO
 share/doc/pgsql/TODO.GEQO
+share/doc/pgsql/admin.ps.gz
+share/doc/pgsql/admin.tar.gz
 share/doc/pgsql/bug.template
-share/doc/pgsql/libpgtcl.doc
-share/doc/pgsql/manual/admin.html
-share/doc/pgsql/manual/advanced.html
-share/doc/pgsql/manual/appenda.html
-share/doc/pgsql/manual/architec.html
-share/doc/pgsql/manual/copy.html
-share/doc/pgsql/manual/extend.html
-share/doc/pgsql/manual/figure01.gif
-share/doc/pgsql/manual/figure02.gif
-share/doc/pgsql/manual/figure03.gif
-share/doc/pgsql/manual/intro.html
-share/doc/pgsql/manual/libpq.html
-share/doc/pgsql/manual/lobj.html
-share/doc/pgsql/manual/pg95user.html
-share/doc/pgsql/manual/query.html
-share/doc/pgsql/manual/refs.html
-share/doc/pgsql/manual/rules.html
-share/doc/pgsql/manual/start.html
-share/doc/pgsql/manual/xaggr.html
-share/doc/pgsql/manual/xfunc.html
-share/doc/pgsql/manual/xindex.html
-share/doc/pgsql/manual/xoper.html
-share/doc/pgsql/manual/xtypes.html
-share/doc/pgsql/spi.txt
-share/doc/pgsql/trigger.txt
+share/doc/pgsql/postgres.tar.gz
+share/doc/pgsql/programmer.ps.gz
+share/doc/pgsql/programmer.tar.gz
+share/doc/pgsql/src/Makefile
+share/doc/pgsql/src/graphics/catalogs.gif
+share/doc/pgsql/src/graphics/clientserver.ag
+share/doc/pgsql/src/graphics/clientserver.gif
+share/doc/pgsql/src/graphics/connections.ag
+share/doc/pgsql/src/graphics/connections.gif
+share/doc/pgsql/src/graphics/layout.ag
+share/doc/pgsql/src/graphics/layout.gif
+share/doc/pgsql/src/sgml/Makefile
+share/doc/pgsql/src/sgml/admin.sgml
+share/doc/pgsql/src/sgml/advanced.sgml
+share/doc/pgsql/src/sgml/arch-dev.sgml
+share/doc/pgsql/src/sgml/arch-pg.sgml
+share/doc/pgsql/src/sgml/arch.sgml
+share/doc/pgsql/src/sgml/array.sgml
+share/doc/pgsql/src/sgml/biblio.sgml
+share/doc/pgsql/src/sgml/compiler.sgml
+share/doc/pgsql/src/sgml/contacts.sgml
+share/doc/pgsql/src/sgml/datatype.sgml
+share/doc/pgsql/src/sgml/dfunc.sgml
+share/doc/pgsql/src/sgml/docguide.sgml
+share/doc/pgsql/src/sgml/ecpg.sgml
+share/doc/pgsql/src/sgml/environ.sgml
+share/doc/pgsql/src/sgml/extend.sgml
+share/doc/pgsql/src/sgml/func-ref.sgml
+share/doc/pgsql/src/sgml/geqo.sgml
+share/doc/pgsql/src/sgml/gist.sgml
+share/doc/pgsql/src/sgml/inherit.sgml
+share/doc/pgsql/src/sgml/install.sgml
+share/doc/pgsql/src/sgml/intro-pg.sgml
+share/doc/pgsql/src/sgml/intro.sgml
+share/doc/pgsql/src/sgml/jdbc.sgml
+share/doc/pgsql/src/sgml/libpgtcl.sgml
+share/doc/pgsql/src/sgml/libpq.sgml
+share/doc/pgsql/src/sgml/lobj.sgml
+share/doc/pgsql/src/sgml/manage.sgml
+share/doc/pgsql/src/sgml/odbc.sgml
+share/doc/pgsql/src/sgml/pgaccess.sgml
+share/doc/pgsql/src/sgml/ports.sgml
+share/doc/pgsql/src/sgml/postgres.sgml
+share/doc/pgsql/src/sgml/programmer.sgml
+share/doc/pgsql/src/sgml/protocol.sgml
+share/doc/pgsql/src/sgml/psql.sgml
+share/doc/pgsql/src/sgml/query-ug.sgml
+share/doc/pgsql/src/sgml/query.sgml
+share/doc/pgsql/src/sgml/recovery.sgml
+share/doc/pgsql/src/sgml/regress.sgml
+share/doc/pgsql/src/sgml/release.sgml
+share/doc/pgsql/src/sgml/rules.sgml
+share/doc/pgsql/src/sgml/spi.sgml
+share/doc/pgsql/src/sgml/start-ag.sgml
+share/doc/pgsql/src/sgml/start.sgml
+share/doc/pgsql/src/sgml/storage.sgml
+share/doc/pgsql/src/sgml/trigger.sgml
+share/doc/pgsql/src/sgml/tutorial.sgml
+share/doc/pgsql/src/sgml/user.sgml
+share/doc/pgsql/src/sgml/xaggr.sgml
+share/doc/pgsql/src/sgml/xfunc.sgml
+share/doc/pgsql/src/sgml/xindex.sgml
+share/doc/pgsql/src/sgml/xoper.sgml
+share/doc/pgsql/src/sgml/xtypes.sgml
+share/doc/pgsql/tutorial.ps.gz
+share/doc/pgsql/tutorial.tar.gz
+share/doc/pgsql/user.ps.gz
+share/doc/pgsql/user.tar.gz
 share/doc/pgsql/userguide.ps
-@dirrm share/doc/pgsql/manual
+@dirrm share/doc/pgsql/src/graphics
+@dirrm share/doc/pgsql/src/sgml
+@dirrm share/doc/pgsql/src
 @dirrm share/doc/pgsql
 @dirrm pgsql/bin
 @dirrm pgsql/data/base/template1
 @dirrm pgsql/data/base
 @dirrm pgsql/data
 @dirrm pgsql/include/access
+@dirrm pgsql/include/commands
+@dirrm pgsql/include/executor
 @dirrm pgsql/include/include
 @dirrm pgsql/include/lib
 @dirrm pgsql/include/libpq
-@dirrm pgsql/include/port/BSD44_derived
+@dirrm pgsql/include/port/bsd
 @dirrm pgsql/include/port
 @dirrm pgsql/include/utils
 @dirrm pgsql/include