Update postgresql to 6.4.2. Among bugfixes and new features, this also

adds patches for m68k support, provided in pr 6664 by MOCHIDA Shuji.

8 files changed, 487 insertions, 245 deletions

diff --git a/databases/postgresql/Makefile b/databases/postgresql/Makefile
index 2cb08bcf262..d6c4be84013 100644
--- a/databases/postgresql/Makefile
+++ b/databases/postgresql/Makefile
@@ -1,9 +1,11 @@
-# $NetBSD: Makefile,v 1.21 1999/01/03 13:13:12 frueauf Exp $
+# $NetBSD: Makefile,v 1.22 1999/01/04 13:05:01 frueauf Exp $
 # FreeBSD Id: Makefile,v 1.22 1997/12/24 01:21:37 alex Exp
 
-DISTNAME=	postgresql-6.3.2
+DISTNAME=	postgresql-6.4.2
+WRKSRC=		${WRKDIR}/${DISTNAME}/src
 CATEGORIES=	databases
 MASTER_SITES=	ftp://ftp.PostgreSQL.org/pub/ \
+		ftp://ftp.sunsite.auc.dk/mirrors/www.postgresql.org/pub/ \
 		ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/
 
 MAINTAINER=	packages@netbsd.org
@@ -14,12 +16,12 @@ DEPENDS+=	tcl-8.0p2:../../lang/tcl80
 DEPENDS+=	addnerd-1.6:../../sysutils/addnerd
 DEPENDS+=	bison-1.25:../../devel/bison
 
+CONFLICTS=	postgresql-6.3.2
+
 NOT_FOR_ARCHS=	alpha	# Needs ELF clue
-NOT_FOR_ARCHS+=	m68k
 
 NO_PACKAGE=	"Requires pgsql uid"
 
-WRKSRC=		${WRKDIR}/${DISTNAME}/src
 PLIST_SRC=	${WRKDIR}/PLIST.tmp
 
 PGUSER?=	pgsql
@@ -31,9 +33,11 @@ HAS_CONFIGURE=	yes
 CONFIGURE_ARGS= --prefix=${PREFIX}/${PGUSER} \
 		--enable-locale \
 		--with-tcl \
+		--with-tclconfig=${PREFIX}/lib/tcl8.0 \
 		--with-includes=${PREFIX}/include \
 		--with-libs=${PREFIX}/lib \
 		--with-template=`${ECHO} ${OPSYS} | ${TR} '[A-Z]' '[a-z]'`
+CONFIGURE_ENV+=	CPPFLAGS="-I${PREFIX}/include/tcl8.0 -I${PREFIX}/include/tk8.0"
 
 .include "../../mk/bsd.prefs.mk"
 
@@ -103,15 +107,22 @@ post-install:
 		${ECHO} "************** WARNING ********************";		\
 		;;								\
 	esac
+	${LDCONFIG} ${PREFIX}/${PGUSER}/lib || ${TRUE}
 	@${ECHO} '${SETENV} PATH=${PREFIX}/${PGUSER}/bin:$$PATH ${PREFIX}/${PGUSER}/bin/initdb --pglib=${PREFIX}/${PGUSER}/lib --pgdata=${PREFIX}/${PGUSER}/data' | su -l ${PGUSER}
-	@${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \
-		> ${PREFIX}/etc/rc.d/pgsql.sh
+	@${SED} -e "s=!!PREFIX!!=${PREFIX}=g" -e "s=!!PGUSER!!=${PGUSER}=g" \
+		< ${FILESDIR}/pgsql.sh.tmpl > ${PREFIX}/etc/rc.d/pgsql.sh
 	@/bin/chmod 554 ${PREFIX}/etc/rc.d/pgsql.sh
 	@/usr/sbin/chown root.${PGGROUP} ${PREFIX}/etc/rc.d/pgsql.sh
-	@${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/${PGUSER}
+	@${INSTALL} -c -o ${PGUSER} -g ${PGGROUP} -m 444 \
+		${FILESDIR}/post-install-notes ${PREFIX}/${PGUSER}
 .if !defined(NOPORTDOCS)
 	${MKDIR} ${PREFIX}/share/doc/pgsql
 	${CP} -R ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/pgsql
+	${RM} -rf ${PREFIX}/share/doc/pgsql/src/CVS \
+		${PREFIX}/share/doc/pgsql/src/graphics/CVS \
+		${PREFIX}/share/doc/pgsql/src/sgml/ref/CVS \
+		${PREFIX}/share/doc/pgsql/src/sgml/CVS \
+		${PREFIX}/share/doc/pgsql/CVS
 .endif
 .if !defined(BATCH)
 	@${CAT} ${FILESDIR}/post-install-notes
diff --git a/databases/postgresql/files/md5 b/databases/postgresql/files/md5
index e30b3335640..8f7850213bf 100644
--- a/databases/postgresql/files/md5
+++ b/databases/postgresql/files/md5
@@ -1,3 +1,3 @@
-$NetBSD: md5,v 1.3 1998/08/07 13:17:05 agc Exp $
+$NetBSD: md5,v 1.4 1999/01/04 13:05:01 frueauf Exp $
 
-MD5 (postgresql-6.3.2.tar.gz) = 8902842461c9a42854ba9883bee56a4c
+MD5 (postgresql-6.4.2.tar.gz) = 4f5e0409921892ca08fff2d8c099b3d7
diff --git a/databases/postgresql/patches/patch-aa b/databases/postgresql/patches/patch-aa
new file mode 100644
index 00000000000..65822590641
--- /dev/null
+++ b/databases/postgresql/patches/patch-aa
@@ -0,0 +1,35 @@
+$NetBSD: patch-aa,v 1.1 1999/01/04 13:05:01 frueauf Exp $
+
+--- include/utils/memutils.h.orig	Mon Sep  7 07:35:48 1998
++++ include/utils/memutils.h	Tue Dec 29 00:50:38 1998
+@@ -58,13 +58,17 @@
+ #define SHORTALIGN(LEN)\
+ 		(((long)(LEN) + (sizeof (short) - 1)) & ~(sizeof (short) - 1))
+ 
++#if defined(m68k)
++#define INTALIGN(LEN)	 SHORTALIGN(LEN)
++#else
+ #define INTALIGN(LEN)\
+ 		(((long)(LEN) + (sizeof (int) - 1)) & ~(sizeof (int) -1))
++#endif
+ 
+ /*
+  *		LONGALIGN(LEN)	- length (or address) aligned for longs
+  */
+-#if defined(sun) && ! defined(sparc)
++#if (defined(sun) && ! defined(sparc)) || defined(m68k)
+ #define LONGALIGN(LEN)	SHORTALIGN(LEN)
+ #elif defined (__alpha)
+ 
+@@ -81,7 +85,10 @@
+ 		(((long)(LEN) + (sizeof (long) - 1)) & ~(sizeof (long) -1))
+ #endif
+ 
+-#if ! defined(sco)
++#if defined(m68k)
++#define DOUBLEALIGN(LEN) SHORTALIGN(LEN)
++#define MAXALIGN(LEN)	 SHORTALIGN(LEN)
++#elif ! defined(sco)
+ #define DOUBLEALIGN(LEN)\
+ 		(((long)(LEN) + (sizeof (double) - 1)) & ~(sizeof (double) -1))
+ 
diff --git a/databases/postgresql/patches/patch-ab b/databases/postgresql/patches/patch-ab
index 6a1e59a0fea..a3cca8ffbf6 100644
--- a/databases/postgresql/patches/patch-ab
+++ b/databases/postgresql/patches/patch-ab
@@ -1,13 +1,30 @@
-$NetBSD: patch-ab,v 1.4 1998/08/07 10:40:19 agc Exp $
+$NetBSD: patch-ab,v 1.5 1999/01/04 13:05:01 frueauf Exp $
 
---- bin/initdb/initdb.orig	Mon Apr  6 02:05:52 1998
-+++ bin/initdb/initdb	Wed Jun 10 13:13:18 1998
-@@ -286,7 +286,7 @@
- #----------------------------------------------------------------------------
+--- backend/storage/buffer/s_lock.c.orig	Fri Sep 18 19:18:39 1998
++++ backend/storage/buffer/s_lock.c	Tue Dec 29 00:50:38 1998
+@@ -117,6 +117,25 @@
  
- if [ $template_only -eq 0 ]; then
--    echo "Creating global classes in $PG_DATA/base"
-+    echo "Creating global classes in $PGDATA/base"
-     echo "Running: postgres $BACKENDARGS template1"
+ #endif	 /* PPC */
  
-     cat $GLOBAL \
++#if defined(__m68k__)
++static void
++tas_dummy()	/* really means: extern int tas(slock_t **lock); */
++{
++	__asm__("		\n\
++.global		_tas		\n\
++_tas:				\n\
++	movel   sp@(0x4),a0	\n\
++	tas a0@			\n\
++	beq _success		\n\
++	moveq   #-128,d0	\n\
++	rts			\n\
++_success:			\n\
++	moveq   #0,d0		\n\
++	rts			\n\
++	");
++}
++
++#endif	 /* __m68k__ */
+ 
+ 
+ #else							/* defined(__GNUC__) */
diff --git a/databases/postgresql/patches/patch-ac b/databases/postgresql/patches/patch-ac
new file mode 100644
index 00000000000..9776f054f7a
--- /dev/null
+++ b/databases/postgresql/patches/patch-ac
@@ -0,0 +1,25 @@
+$NetBSD: patch-ac,v 1.3 1999/01/04 13:05:01 frueauf Exp $
+
+--- configure.in-orig	Sun Dec 13 21:08:20 1998
++++ configure.in	Tue Dec 29 01:33:56 1998
+@@ -786,7 +786,7 @@
+ dnl If --with-tclconfig was given, don't check for tclsh, tcl
+ if test -z "$TCL_DIRS"
+ then
+-	AC_PATH_PROG(TCLSH, tclsh)
++	AC_PATH_PROG(TCLSH, tclsh8.0)
+ 	if test -z "$TCLSH"
+ 	then
+ 		AC_PATH_PROG(TCLSH, tcl)
+@@ -834,9 +834,9 @@
+ 	# library_dirs are set in the check for TCL
+ 	for dir in $library_dirs
+ 	do
+-		if test -d "$dir" -a -r "$dir/tkConfig.sh"
++		if test -d "$dir" -a -r "$dir/../tk8.0/tkConfig.sh"
+ 		then
+-			TK_CONFIG_SH=$dir/tkConfig.sh
++			TK_CONFIG_SH=$dir/../tk8.0/tkConfig.sh
+ 			break
+ 		fi
+ 	done
diff --git a/databases/postgresql/patches/patch-ad b/databases/postgresql/patches/patch-ad
new file mode 100644
index 00000000000..46c895b60ff
--- /dev/null
+++ b/databases/postgresql/patches/patch-ad
@@ -0,0 +1,27 @@
+$NetBSD: patch-ad,v 1.4 1999/01/04 13:05:01 frueauf Exp $
+
+--- configure-orig	Sun Dec 13 21:08:20 1998
++++ configure	Tue Dec 29 01:34:06 1998
+@@ -5315,8 +5315,8 @@
+ 
+ if test -z "$TCL_DIRS"
+ then
+-	# Extract the first word of "tclsh", so it can be a program name with args.
+-set dummy tclsh; ac_word=$2
++	# Extract the first word of "tclsh8.0", so it can be a program name with args.
++set dummy tclsh8.0; ac_word=$2
+ echo $ac_n "checking for $ac_word""... $ac_c" 1>&6
+ echo "configure:5322: checking for $ac_word" >&5
+ if eval "test \"`echo '$''{'ac_cv_path_TCLSH'+set}'`\" = set"; then
+@@ -5424,9 +5424,9 @@
+ 	# library_dirs are set in the check for TCL
+ 	for dir in $library_dirs
+ 	do
+-		if test -d "$dir" -a -r "$dir/tkConfig.sh"
++		if test -d "$dir" -a -r "$dir/../tk8.0/tkConfig.sh"
+ 		then
+-			TK_CONFIG_SH=$dir/tkConfig.sh
++			TK_CONFIG_SH=$dir/../tk8.0/tkConfig.sh
+ 			break
+ 		fi
+ 	done
diff --git a/databases/postgresql/patches/patch-ae b/databases/postgresql/patches/patch-ae
new file mode 100644
index 00000000000..7460617857c
--- /dev/null
+++ b/databases/postgresql/patches/patch-ae
@@ -0,0 +1,13 @@
+$NetBSD: patch-ae,v 1.4 1999/01/04 13:05:02 frueauf Exp $
+
+--- GNUmakefile.in-orig	Sun Oct 18 06:16:07 1998
++++ GNUmakefile.in	Tue Dec 29 14:40:02 1998
+@@ -34,7 +34,7 @@
+ 	echo All of PostgreSQL is successfully made.  Ready to install. ;\
+         fi
+ 
+-install:
++install: install-man
+ 	$(MAKE) lexverify
+ 	$(MAKE) -C utils install
+ 	$(MAKE) -C backend install
diff --git a/databases/postgresql/pkg/PLIST b/databases/postgresql/pkg/PLIST
index 05c29627675..12c6b139e3c 100644
--- a/databases/postgresql/pkg/PLIST
+++ b/databases/postgresql/pkg/PLIST
@@ -1,226 +1,84 @@
-@comment $NetBSD: PLIST,v 1.7 1998/07/15 12:40:14 agc Exp $
+@comment $NetBSD: PLIST,v 1.8 1999/01/04 13:05:02 frueauf Exp $
 etc/rc.d/pgsql.sh
-@PGUSER@/.profile
-@PGUSER@/bin/cleardbdir
-@PGUSER@/bin/createdb
-@PGUSER@/bin/createuser
-@PGUSER@/bin/destroydb
-@PGUSER@/bin/destroyuser
-@PGUSER@/bin/ecpg
-@PGUSER@/bin/initdb
-@PGUSER@/bin/initlocation
-@PGUSER@/bin/ipcclean
-@PGUSER@/bin/pg_dump
-@PGUSER@/bin/pg_dumpall
-@PGUSER@/bin/pg_id
-@PGUSER@/bin/pg_passwd
-@PGUSER@/bin/pg_version
-@unexec rm -f %D/@PGUSER@/bin/pgtclsh
-@unexec rm -f %D/@PGUSER@/bin/pgtksh
-@unexec rm -f %D/@PGUSER@/bin/pgaccess
-@PGUSER@/bin/postgres
-@PGUSER@/bin/postmaster
-@PGUSER@/bin/psql
-@PGUSER@/data/PG_VERSION
-@PGUSER@/data/base/template1/PG_VERSION
-@PGUSER@/data/base/template1/pg_aggregate
-@PGUSER@/data/base/template1/pg_am
-@PGUSER@/data/base/template1/pg_amop
-@PGUSER@/data/base/template1/pg_amproc
-@PGUSER@/data/base/template1/pg_attrdef
-@PGUSER@/data/base/template1/pg_attribute
-@PGUSER@/data/base/template1/pg_class
-@PGUSER@/data/base/template1/pg_index
-@PGUSER@/data/base/template1/pg_inheritproc
-@PGUSER@/data/base/template1/pg_inherits
-@PGUSER@/data/base/template1/pg_internal.init
-@PGUSER@/data/base/template1/pg_ipl
-@PGUSER@/data/base/template1/pg_language
-@PGUSER@/data/base/template1/pg_listener
-@PGUSER@/data/base/template1/pg_opclass
-@PGUSER@/data/base/template1/pg_operator
-@PGUSER@/data/base/template1/pg_parg
-@PGUSER@/data/base/template1/pg_proc
-@PGUSER@/data/base/template1/pg_relcheck
-@PGUSER@/data/base/template1/pg_rewrite
-@PGUSER@/data/base/template1/pg_statistic
-@PGUSER@/data/base/template1/pg_trigger
-@PGUSER@/data/base/template1/pg_type
-@PGUSER@/data/base/template1/pg_version
-@PGUSER@/data/base/template1/pg_description
-@PGUSER@/data/base/template1/pg_attribute_relid_attnam_index
-@PGUSER@/data/base/template1/pg_proc_oid_index
-@PGUSER@/data/base/template1/pg_attribute_relid_attnum_index
-@PGUSER@/data/base/template1/pg_attribute_attrelid_index
-@PGUSER@/data/base/template1/pg_proc_proname_index
-@PGUSER@/data/base/template1/pg_proc_prosrc_index
-@PGUSER@/data/base/template1/pg_type_oid_index
-@PGUSER@/data/base/template1/pg_type_typname_index
-@PGUSER@/data/base/template1/pg_class_oid_index
-@PGUSER@/data/base/template1/pg_class_relname_index
-@PGUSER@/data/base/template1/pg_attrdef_adrelid_index
-@PGUSER@/data/base/template1/pg_relcheck_rcrelid_index
-@PGUSER@/data/base/template1/pg_trigger_tgrelid_index
-@PGUSER@/data/base/template1/pg_description_objoid_index
-@PGUSER@/data/base/template1/pg_user
-@PGUSER@/data/pg_shadow
-@PGUSER@/data/pg_pwd
-@PGUSER@/data/pg_database
-@PGUSER@/data/pg_geqo.sample
-@PGUSER@/data/pg_group
-@PGUSER@/data/pg_hba.conf
-@PGUSER@/data/pg_log
-@PGUSER@/data/pg_variable
-@PGUSER@/include/access/attnum.h
-@PGUSER@/include/c.h
-@PGUSER@/include/config.h
-@PGUSER@/include/commands/trigger.h
-@PGUSER@/include/executor/spi.h
-@PGUSER@/include/fmgr.h
-@PGUSER@/include/lib/dllist.h
-@unexec rm -f %D/@PGUSER@/include/libpgtcl.h
-@PGUSER@/include/libpq-fe.h
-@PGUSER@/include/libpq/libpq-fs.h
-@PGUSER@/include/libpq/pqcomm.h
-@PGUSER@/include/os.h
-@PGUSER@/include/postgres.h
-@PGUSER@/include/postgres_ext.h
-@PGUSER@/include/utils/elog.h
-@PGUSER@/include/utils/geo_decls.h
-@PGUSER@/include/utils/palloc.h
-@PGUSER@/include/ecpglib.h
-@PGUSER@/include/ecpgtype.h
-@PGUSER@/include/sqlca.h
-@PGUSER@/lib/global1.bki.source
-@unexec rm -f %D/@PGUSER@/lib/libpgtcl.a
-@unexec rm -f %D/@PGUSER@/lib/libpgtcl.so
-@unexec rm -f %D/@PGUSER@/lib/libpgtcl.so.1.0
-@PGUSER@/lib/libpq.a
-@PGUSER@/lib/libpq.so
-@PGUSER@/lib/local1_template1.bki.source
-@PGUSER@/lib/pg_geqo.sample
-@PGUSER@/lib/pg_hba.conf.sample
-@PGUSER@/lib/global1.description
-@PGUSER@/lib/local1_template1.description
-@PGUSER@/lib/libpq.so.1.1
-@PGUSER@/lib/libecpg.so.1.1
-@PGUSER@/lib/libecpg.so
-@PGUSER@/lib/libecpg.a
-@PGUSER@/man/man1/cleardbdir.1.gz
-@PGUSER@/man/man1/createdb.1.gz
-@PGUSER@/man/man1/createuser.1.gz
-@PGUSER@/man/man1/destroydb.1.gz
-@PGUSER@/man/man1/destroyuser.1.gz
-@PGUSER@/man/man1/initdb.1.gz
-@PGUSER@/man/man1/ipcclean.1.gz
-@PGUSER@/man/man1/pg_dump.1.gz
-@PGUSER@/man/man1/pg_dumpall.1.gz
-@PGUSER@/man/man1/pg_passwd.1.gz
-@PGUSER@/man/man1/pgintro.1.gz
-@PGUSER@/man/man1/postgres.1.gz
-@PGUSER@/man/man1/postmaster.1.gz
-@PGUSER@/man/man1/psql.1.gz
-@PGUSER@/man/man3/catalogs.3.gz
-@PGUSER@/man/man3/large_objects.3.gz
-@PGUSER@/man/man3/libpq.3.gz
-@PGUSER@/man/man3/oracle_compat.3.gz
-@PGUSER@/man/man3/pgbuiltin.3.gz
-@PGUSER@/man/man5/bki.5.gz
-@PGUSER@/man/man5/page.5.gz
-@PGUSER@/man/man5/pg_hba.conf.5.gz
-@PGUSER@/man/manl/abort.l.gz
-@PGUSER@/man/manl/alter_table.l.gz
-@PGUSER@/man/manl/begin.l.gz
-@PGUSER@/man/manl/close.l.gz
-@PGUSER@/man/manl/cluster.l.gz
-@PGUSER@/man/manl/commit.l.gz
-@PGUSER@/man/manl/copy.l.gz
-@PGUSER@/man/manl/create_aggregate.l.gz
-@PGUSER@/man/manl/create_database.l.gz
-@PGUSER@/man/manl/create_function.l.gz
-@PGUSER@/man/manl/create_index.l.gz
-@PGUSER@/man/manl/create_operator.l.gz
-@PGUSER@/man/manl/create_rule.l.gz
-@PGUSER@/man/manl/create_sequence.l.gz
-@PGUSER@/man/manl/create_table.l.gz
-@PGUSER@/man/manl/create_trigger.l.gz
-@PGUSER@/man/manl/create_type.l.gz
-@PGUSER@/man/manl/create_version.l.gz
-@PGUSER@/man/manl/create_view.l.gz
-@PGUSER@/man/manl/declare.l.gz
-@PGUSER@/man/manl/delete.l.gz
-@PGUSER@/man/manl/drop.l.gz
-@PGUSER@/man/manl/drop_aggregate.l.gz
-@PGUSER@/man/manl/drop_database.l.gz
-@PGUSER@/man/manl/drop_function.l.gz
-@PGUSER@/man/manl/drop_index.l.gz
-@PGUSER@/man/manl/drop_operator.l.gz
-@PGUSER@/man/manl/drop_rule.l.gz
-@PGUSER@/man/manl/drop_sequence.l.gz
-@PGUSER@/man/manl/drop_table.l.gz
-@PGUSER@/man/manl/drop_trigger.l.gz
-@PGUSER@/man/manl/drop_type.l.gz
-@PGUSER@/man/manl/drop_view.l.gz
-@PGUSER@/man/manl/end.l.gz
-@PGUSER@/man/manl/explain.l.gz
-@PGUSER@/man/manl/fetch.l.gz
-@PGUSER@/man/manl/grant.l.gz
-@PGUSER@/man/manl/insert.l.gz
-@PGUSER@/man/manl/listen.l.gz
-@PGUSER@/man/manl/load.l.gz
-@PGUSER@/man/manl/move.l.gz
-@PGUSER@/man/manl/notify.l.gz
-@PGUSER@/man/manl/reset.l.gz
-@PGUSER@/man/manl/revoke.l.gz
-@PGUSER@/man/manl/rollback.l.gz
-@PGUSER@/man/manl/select.l.gz
-@PGUSER@/man/manl/set.l.gz
-@PGUSER@/man/manl/show.l.gz
-@PGUSER@/man/manl/sql.l.gz
-@PGUSER@/man/manl/update.l.gz
-@PGUSER@/man/manl/vacuum.l.gz
-@PGUSER@/man/man1/initlocation.1
-@PGUSER@/man/man1/ecpg.1
-@PGUSER@/man/manl/lock.l
-@PGUSER@/man/manl/drop_user.l
-@PGUSER@/man/manl/drop_language.l
-@PGUSER@/man/manl/create_user.l
-@PGUSER@/man/manl/create_language.l
-@PGUSER@/man/manl/alter_user.l
-@PGUSER@/post-install-notes
-share/doc/pgsql/FAQ
-share/doc/pgsql/FAQ_Irix
-share/doc/pgsql/FAQ_Linux
-share/doc/pgsql/README.GEQO
-share/doc/pgsql/README.fsync
-share/doc/pgsql/README.support
-share/doc/pgsql/TODO
-share/doc/pgsql/TODO.GEQO
-share/doc/pgsql/bug.template
-share/doc/pgsql/userguide.ps
-share/doc/pgsql/FAQ_FreeBSD
-share/doc/pgsql/Makefile
-share/doc/pgsql/README.mb
-share/doc/pgsql/README.mb.jp
-share/doc/pgsql/admin.ps.gz
-share/doc/pgsql/admin.tar.gz
-share/doc/pgsql/postgres.tar.gz
-share/doc/pgsql/programmer.ps.gz
-share/doc/pgsql/programmer.tar.gz
-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/src/Makefile
-share/doc/pgsql/src/graphics/
 share/doc/pgsql/src/graphics/catalogs.gif
+share/doc/pgsql/src/graphics/catalogs.ps
 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/ref/abort.sgml
+share/doc/pgsql/src/sgml/ref/allfiles.sgml
+share/doc/pgsql/src/sgml/ref/alter_table.sgml
+share/doc/pgsql/src/sgml/ref/alter_user.sgml
+share/doc/pgsql/src/sgml/ref/begin.sgml
+share/doc/pgsql/src/sgml/ref/close.sgml
+share/doc/pgsql/src/sgml/ref/cluster.sgml
+share/doc/pgsql/src/sgml/ref/commands.sgml
+share/doc/pgsql/src/sgml/ref/commit.sgml
+share/doc/pgsql/src/sgml/ref/copy.sgml
+share/doc/pgsql/src/sgml/ref/create_aggregate.sgml
+share/doc/pgsql/src/sgml/ref/create_database.sgml
+share/doc/pgsql/src/sgml/ref/create_function.sgml
+share/doc/pgsql/src/sgml/ref/create_index.sgml
+share/doc/pgsql/src/sgml/ref/create_language.sgml
+share/doc/pgsql/src/sgml/ref/create_operator.sgml
+share/doc/pgsql/src/sgml/ref/create_rule.sgml
+share/doc/pgsql/src/sgml/ref/create_sequence.sgml
+share/doc/pgsql/src/sgml/ref/create_table.sgml
+share/doc/pgsql/src/sgml/ref/create_trigger.sgml
+share/doc/pgsql/src/sgml/ref/create_type.sgml
+share/doc/pgsql/src/sgml/ref/create_user.sgml
+share/doc/pgsql/src/sgml/ref/create_view.sgml
+share/doc/pgsql/src/sgml/ref/createdb.sgml
+share/doc/pgsql/src/sgml/ref/createuser.sgml
+share/doc/pgsql/src/sgml/ref/current_date.sgml
+share/doc/pgsql/src/sgml/ref/current_time.sgml
+share/doc/pgsql/src/sgml/ref/current_timestamp.sgml
+share/doc/pgsql/src/sgml/ref/current_user.sgml
+share/doc/pgsql/src/sgml/ref/declare.sgml
+share/doc/pgsql/src/sgml/ref/delete.sgml
+share/doc/pgsql/src/sgml/ref/destroydb.sgml
+share/doc/pgsql/src/sgml/ref/destroyuser.sgml
+share/doc/pgsql/src/sgml/ref/drop_aggregate.sgml
+share/doc/pgsql/src/sgml/ref/drop_database.sgml
+share/doc/pgsql/src/sgml/ref/drop_function.sgml
+share/doc/pgsql/src/sgml/ref/drop_index.sgml
+share/doc/pgsql/src/sgml/ref/drop_language.sgml
+share/doc/pgsql/src/sgml/ref/drop_operator.sgml
+share/doc/pgsql/src/sgml/ref/drop_rule.sgml
+share/doc/pgsql/src/sgml/ref/drop_sequence.sgml
+share/doc/pgsql/src/sgml/ref/drop_table.sgml
+share/doc/pgsql/src/sgml/ref/drop_trigger.sgml
+share/doc/pgsql/src/sgml/ref/drop_type.sgml
+share/doc/pgsql/src/sgml/ref/drop_user.sgml
+share/doc/pgsql/src/sgml/ref/drop_view.sgml
+share/doc/pgsql/src/sgml/ref/explain.sgml
+share/doc/pgsql/src/sgml/ref/fetch.sgml
+share/doc/pgsql/src/sgml/ref/grant.sgml
+share/doc/pgsql/src/sgml/ref/initdb.sgml
+share/doc/pgsql/src/sgml/ref/initlocation.sgml
+share/doc/pgsql/src/sgml/ref/insert.sgml
+share/doc/pgsql/src/sgml/ref/listen.sgml
+share/doc/pgsql/src/sgml/ref/load.sgml
+share/doc/pgsql/src/sgml/ref/lock.sgml
+share/doc/pgsql/src/sgml/ref/move.sgml
+share/doc/pgsql/src/sgml/ref/notify.sgml
+share/doc/pgsql/src/sgml/ref/pg_dump.sgml
+share/doc/pgsql/src/sgml/ref/pg_dumpall.sgml
+share/doc/pgsql/src/sgml/ref/pg_upgrade.sgml
+share/doc/pgsql/src/sgml/ref/psql-ref.sgml
+share/doc/pgsql/src/sgml/ref/reset.sgml
+share/doc/pgsql/src/sgml/ref/revoke.sgml
+share/doc/pgsql/src/sgml/ref/rollback.sgml
+share/doc/pgsql/src/sgml/ref/select.sgml
+share/doc/pgsql/src/sgml/ref/set.sgml
+share/doc/pgsql/src/sgml/ref/show.sgml
+share/doc/pgsql/src/sgml/ref/unlisten.sgml
+share/doc/pgsql/src/sgml/ref/update.sgml
+share/doc/pgsql/src/sgml/ref/vacuum.sgml
+share/doc/pgsql/src/sgml/about.sgml
 share/doc/pgsql/src/sgml/admin.sgml
 share/doc/pgsql/src/sgml/advanced.sgml
 share/doc/pgsql/src/sgml/arch-dev.sgml
@@ -228,8 +86,11 @@ 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/bki.sgml
 share/doc/pgsql/src/sgml/compiler.sgml
+share/doc/pgsql/src/sgml/config.sgml
 share/doc/pgsql/src/sgml/contacts.sgml
+share/doc/pgsql/src/sgml/current.sgml
 share/doc/pgsql/src/sgml/datatype.sgml
 share/doc/pgsql/src/sgml/dfunc.sgml
 share/doc/pgsql/src/sgml/docguide.sgml
@@ -237,18 +98,31 @@ 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/func.sgml
 share/doc/pgsql/src/sgml/geqo.sgml
 share/doc/pgsql/src/sgml/gist.sgml
+share/doc/pgsql/src/sgml/history.sgml
+share/doc/pgsql/src/sgml/indices.sgml
+share/doc/pgsql/src/sgml/info.sgml
 share/doc/pgsql/src/sgml/inherit.sgml
 share/doc/pgsql/src/sgml/install.sgml
+share/doc/pgsql/src/sgml/installation.sgml
+share/doc/pgsql/src/sgml/intro-ag.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/keys.sgml
+share/doc/pgsql/src/sgml/legal.sgml
 share/doc/pgsql/src/sgml/libpgtcl.sgml
+share/doc/pgsql/src/sgml/libpq++.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/notation.sgml
 share/doc/pgsql/src/sgml/odbc.sgml
+share/doc/pgsql/src/sgml/oper.sgml
+share/doc/pgsql/src/sgml/page.sgml
+share/doc/pgsql/src/sgml/pg_options.sgml
 share/doc/pgsql/src/sgml/pgaccess.sgml
 share/doc/pgsql/src/sgml/ports.sgml
 share/doc/pgsql/src/sgml/postgres.sgml
@@ -258,39 +132,274 @@ 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/reference.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/runtime.sgml
+share/doc/pgsql/src/sgml/security.sgml
+share/doc/pgsql/src/sgml/signals.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/syntax.sgml
 share/doc/pgsql/src/sgml/trigger.sgml
 share/doc/pgsql/src/sgml/tutorial.sgml
+share/doc/pgsql/src/sgml/typeconv.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/xplang.sgml
 share/doc/pgsql/src/sgml/xtypes.sgml
-@dirrm share/doc/pgsql/src/graphics
-@dirrm share/doc/pgsql/src/sgml
-@dirrm share/doc/pgsql/src
-@dirrm share/doc/pgsql
-@dirrm @PGUSER@/bin
+share/doc/pgsql/src/sgml/y2k.sgml
+share/doc/pgsql/src/sgml/Makefile
+share/doc/pgsql/src/Makefile
+share/doc/pgsql/tutorial.tar.gz
+share/doc/pgsql/tutorial.ps.gz
+share/doc/pgsql/programmer.tar.gz
+share/doc/pgsql/programmer.ps.gz
+share/doc/pgsql/postgres.tar.gz
+share/doc/pgsql/bug.template
+share/doc/pgsql/admin.tar.gz
+share/doc/pgsql/admin.ps.gz
+share/doc/pgsql/TODO
+share/doc/pgsql/README.mb.jp
+share/doc/pgsql/user.tar.gz
+share/doc/pgsql/README.locale
+share/doc/pgsql/README.inet
+share/doc/pgsql/README.fsync
+share/doc/pgsql/Makefile
+share/doc/pgsql/FAQ_Linux
+share/doc/pgsql/FAQ_Irix
+share/doc/pgsql/FAQ_HPUX
+share/doc/pgsql/FAQ_FreeBSD
+share/doc/pgsql/FAQ_DEV
+share/doc/pgsql/FAQ_CVS
+share/doc/pgsql/FAQ
+share/doc/pgsql/README.mb
+share/doc/pgsql/user.ps.gz
+@PGUSER@/lib/global1.bki.source
+@PGUSER@/lib/global1.description
+@PGUSER@/lib/local1_template1.bki.source
+@PGUSER@/lib/local1_template1.description
+@PGUSER@/lib/pg_hba.conf.sample
+@PGUSER@/lib/pg_geqo.sample
+@PGUSER@/lib/libpq.a
+@PGUSER@/lib/libpq.so.2.0
+@PGUSER@/lib/libpq.so.2
+@PGUSER@/lib/libpq.so
+@PGUSER@/lib/libecpg.a
+@PGUSER@/lib/libecpg.so.2.6.2
+@PGUSER@/lib/libecpg.so.2
+@PGUSER@/lib/libecpg.so
+@PGUSER@/lib/libpq++.a
+@PGUSER@/lib/libpq++.so.2.0
+@PGUSER@/lib/libpq++.so.2
+@PGUSER@/lib/libpq++.so
+@PGUSER@/lib/libpgtcl.a
+@PGUSER@/lib/libpgtcl.so.2.0
+@PGUSER@/lib/libpgtcl.so.2
+@PGUSER@/lib/libpgtcl.so
+@PGUSER@/lib/plpgsql.so
+@PGUSER@/lib/pltcl.so
+@PGUSER@/bin/postgres
+@PGUSER@/bin/postmaster
+@PGUSER@/bin/ecpg
+@PGUSER@/bin/pg_id
+@PGUSER@/bin/pg_version
+@PGUSER@/bin/psql
+@PGUSER@/bin/pg_dump
+@PGUSER@/bin/pg_dumpall
+@PGUSER@/bin/pg_upgrade
+@PGUSER@/bin/pg_passwd
+@PGUSER@/bin/cleardbdir
+@PGUSER@/bin/createdb
+@PGUSER@/bin/createuser
+@PGUSER@/bin/destroydb
+@PGUSER@/bin/destroyuser
+@PGUSER@/bin/initdb
+@PGUSER@/bin/initlocation
+@PGUSER@/bin/ipcclean
+@PGUSER@/bin/pgaccess
+@PGUSER@/bin/pgtclsh
+@PGUSER@/bin/pgtksh
+@PGUSER@/man/man1/cleardbdir.1
+@PGUSER@/man/man1/createdb.1
+@PGUSER@/man/man1/createuser.1
+@PGUSER@/man/man1/destroydb.1
+@PGUSER@/man/man1/destroyuser.1
+@PGUSER@/man/man1/ecpg.1
+@PGUSER@/man/man1/initdb.1
+@PGUSER@/man/man1/initlocation.1
+@PGUSER@/man/man1/ipcclean.1
+@PGUSER@/man/man1/pg_dump.1
+@PGUSER@/man/man1/pg_dumpall.1
+@PGUSER@/man/man1/pg_passwd.1
+@PGUSER@/man/man1/pg_upgrade.1
+@PGUSER@/man/man1/postgres.1
+@PGUSER@/man/man1/postmaster.1
+@PGUSER@/man/man1/psql.1
+@PGUSER@/man/man3/catalogs.3
+@PGUSER@/man/man3/libpq.3
+@PGUSER@/man/man5/pg_hba.conf.5
+@PGUSER@/man/manl/abort.l
+@PGUSER@/man/manl/alter_table.l
+@PGUSER@/man/manl/alter_user.l
+@PGUSER@/man/manl/begin.l
+@PGUSER@/man/manl/close.l
+@PGUSER@/man/manl/cluster.l
+@PGUSER@/man/manl/commit.l
+@PGUSER@/man/manl/copy.l
+@PGUSER@/man/manl/create_aggregate.l
+@PGUSER@/man/manl/create_database.l
+@PGUSER@/man/manl/create_function.l
+@PGUSER@/man/manl/create_index.l
+@PGUSER@/man/manl/create_language.l
+@PGUSER@/man/manl/create_operator.l
+@PGUSER@/man/manl/create_rule.l
+@PGUSER@/man/manl/create_sequence.l
+@PGUSER@/man/manl/create_table.l
+@PGUSER@/man/manl/create_trigger.l
+@PGUSER@/man/manl/create_type.l
+@PGUSER@/man/manl/create_user.l
+@PGUSER@/man/manl/create_version.l
+@PGUSER@/man/manl/create_view.l
+@PGUSER@/man/manl/declare.l
+@PGUSER@/man/manl/delete.l
+@PGUSER@/man/manl/drop.l
+@PGUSER@/man/manl/drop_aggregate.l
+@PGUSER@/man/manl/drop_database.l
+@PGUSER@/man/manl/drop_function.l
+@PGUSER@/man/manl/drop_index.l
+@PGUSER@/man/manl/drop_language.l
+@PGUSER@/man/manl/drop_operator.l
+@PGUSER@/man/manl/drop_rule.l
+@PGUSER@/man/manl/drop_sequence.l
+@PGUSER@/man/manl/drop_table.l
+@PGUSER@/man/manl/drop_trigger.l
+@PGUSER@/man/manl/drop_type.l
+@PGUSER@/man/manl/drop_user.l
+@PGUSER@/man/manl/drop_view.l
+@PGUSER@/man/manl/end.l
+@PGUSER@/man/manl/explain.l
+@PGUSER@/man/manl/fetch.l
+@PGUSER@/man/manl/grant.l
+@PGUSER@/man/manl/insert.l
+@PGUSER@/man/manl/listen.l
+@PGUSER@/man/manl/load.l
+@PGUSER@/man/manl/lock.l
+@PGUSER@/man/manl/move.l
+@PGUSER@/man/manl/notify.l
+@PGUSER@/man/manl/reset.l
+@PGUSER@/man/manl/revoke.l
+@PGUSER@/man/manl/rollback.l
+@PGUSER@/man/manl/select.l
+@PGUSER@/man/manl/set.l
+@PGUSER@/man/manl/show.l
+@PGUSER@/man/manl/sql.l
+@PGUSER@/man/manl/update.l
+@PGUSER@/man/manl/vacuum.l
+@PGUSER@/data/base/template1/pg_proc
+@PGUSER@/data/base/template1/pg_type
+@PGUSER@/data/base/template1/pg_attribute
+@PGUSER@/data/base/template1/pg_class
+@PGUSER@/data/base/template1/pg_inherits
+@PGUSER@/data/base/template1/pg_index
+@PGUSER@/data/base/template1/pg_statistic
+@PGUSER@/data/base/template1/pg_operator
+@PGUSER@/data/base/template1/pg_opclass
+@PGUSER@/data/base/template1/pg_am
+@PGUSER@/data/base/template1/pg_amop
+@PGUSER@/data/base/template1/pg_amproc
+@PGUSER@/data/base/template1/pg_language
+@PGUSER@/data/base/template1/pg_parg
+@PGUSER@/data/base/template1/pg_aggregate
+@PGUSER@/data/base/template1/pg_ipl
+@PGUSER@/data/base/template1/pg_inheritproc
+@PGUSER@/data/base/template1/pg_rewrite
+@PGUSER@/data/base/template1/pg_listener
+@PGUSER@/data/base/template1/pg_description
+@PGUSER@/data/base/template1/pg_attribute_relid_attnam_index
+@PGUSER@/data/base/template1/pg_attribute_relid_attnum_index
+@PGUSER@/data/base/template1/pg_attribute_attrelid_index
+@PGUSER@/data/base/template1/pg_proc_oid_index
+@PGUSER@/data/base/template1/pg_proc_proname_narg_type_index
+@PGUSER@/data/base/template1/pg_proc_prosrc_index
+@PGUSER@/data/base/template1/pg_type_oid_index
+@PGUSER@/data/base/template1/pg_type_typname_index
+@PGUSER@/data/base/template1/pg_class_oid_index
+@PGUSER@/data/base/template1/pg_class_relname_index
+@PGUSER@/data/base/template1/pg_attrdef
+@PGUSER@/data/base/template1/pg_attrdef_adrelid_index
+@PGUSER@/data/base/template1/pg_relcheck
+@PGUSER@/data/base/template1/pg_relcheck_rcrelid_index
+@PGUSER@/data/base/template1/pg_trigger
+@PGUSER@/data/base/template1/pg_trigger_tgrelid_index
+@PGUSER@/data/base/template1/pg_description_objoid_index
+@PGUSER@/data/base/template1/PG_VERSION
+@PGUSER@/data/base/template1/pg_internal.init
+@PGUSER@/data/base/template1/pg_user
+@PGUSER@/data/base/template1/pg_rules
+@PGUSER@/data/base/template1/pg_views
+@PGUSER@/data/base/template1/pg_tables
+@PGUSER@/data/base/template1/pg_indexes
+@PGUSER@/data/pg_variable
+@PGUSER@/data/pg_database
+@PGUSER@/data/pg_shadow
+@PGUSER@/data/pg_group
+@PGUSER@/data/pg_log
+@PGUSER@/data/PG_VERSION
+@PGUSER@/data/pg_hba.conf
+@PGUSER@/data/pg_geqo.sample
+@PGUSER@/data/pg_pwd
+@PGUSER@/include/fmgr.h
+@PGUSER@/include/port/bsd
+@PGUSER@/include/lib/dllist.h
+@PGUSER@/include/libpq/pqcomm.h
+@PGUSER@/include/libpq/libpq-fs.h
+@PGUSER@/include/utils/geo_decls.h
+@PGUSER@/include/utils/elog.h
+@PGUSER@/include/utils/palloc.h
+@PGUSER@/include/access/attnum.h
+@PGUSER@/include/executor/spi.h
+@PGUSER@/include/commands/trigger.h
+@PGUSER@/include/os.h
+@PGUSER@/include/config.h
+@PGUSER@/include/c.h
+@PGUSER@/include/postgres.h
+@PGUSER@/include/postgres_ext.h
+@PGUSER@/include/libpq-fe.h
+@PGUSER@/include/libpq-int.h
+@PGUSER@/include/ecpgerrno.h
+@PGUSER@/include/ecpglib.h
+@PGUSER@/include/ecpgtype.h
+@PGUSER@/include/sqlca.h
+@PGUSER@/include/libpq++/pgenv.h
+@PGUSER@/include/libpq++/pgconnection.h
+@PGUSER@/include/libpq++/pgdatabase.h
+@PGUSER@/include/libpq++/pgtransdb.h
+@PGUSER@/include/libpq++/pgcursordb.h
+@PGUSER@/include/libpq++/pglobject.h
+@PGUSER@/include/libpq++.h
+@PGUSER@/include/libpgtcl.h
+@PGUSER@/.profile
+@PGUSER@/post-install-notes
 @dirrm @PGUSER@/data/base/template1
 @dirrm @PGUSER@/data/base
 @dirrm @PGUSER@/data
-@dirrm @PGUSER@/include/access
+@dirrm @PGUSER@/include/libpq++
 @dirrm @PGUSER@/include/commands
 @dirrm @PGUSER@/include/executor
-@dirrm @PGUSER@/include/include
-@dirrm @PGUSER@/include/lib
-@dirrm @PGUSER@/include/libpq
-@dirrm @PGUSER@/include/port/bsd
-@dirrm @PGUSER@/include/port
+@dirrm @PGUSER@/include/access
 @dirrm @PGUSER@/include/utils
+@dirrm @PGUSER@/include/port
+@dirrm @PGUSER@/include/libpq
+@dirrm @PGUSER@/include/lib
 @dirrm @PGUSER@/include
+@dirrm @PGUSER@/bin
 @dirrm @PGUSER@/lib
 @dirrm @PGUSER@/man/man1
 @dirrm @PGUSER@/man/man3
@@ -298,3 +407,8 @@ share/doc/pgsql/src/sgml/xtypes.sgml
 @dirrm @PGUSER@/man/manl
 @dirrm @PGUSER@/man
 @dirrm @PGUSER@
+@dirrm share/doc/pgsql/src/sgml/ref
+@dirrm share/doc/pgsql/src/sgml
+@dirrm share/doc/pgsql/src/graphics
+@dirrm share/doc/pgsql/src
+@dirrm share/doc/pgsql