aboutsummaryrefslogtreecommitdiffstats
path: root/japanese
diff options
context:
space:
mode:
authorkuriyama <kuriyama@FreeBSD.org>2000-07-19 09:18:08 +0800
committerkuriyama <kuriyama@FreeBSD.org>2000-07-19 09:18:08 +0800
commit784573807f762b59a1965b6ca28ce3458e15eb3b (patch)
treec264754965b20209c0d81225c40f3b4390ba9f6d /japanese
parentd8a93609f187d2b2fe4b82b5007c383ae6b733fa (diff)
downloadfreebsd-ports-gnome-784573807f762b59a1965b6ca28ce3458e15eb3b.tar.gz
freebsd-ports-gnome-784573807f762b59a1965b6ca28ce3458e15eb3b.tar.zst
freebsd-ports-gnome-784573807f762b59a1965b6ca28ce3458e15eb3b.zip
Japannese configured PostgreSQL v7.
(after repository copy from japanese/postgresql).
Diffstat (limited to 'japanese')
-rw-r--r--japanese/postgresql-tcltk/Makefile289
-rw-r--r--japanese/postgresql-tcltk/distinfo2
-rw-r--r--japanese/postgresql-tcltk/files/patch-ab41
-rw-r--r--japanese/postgresql-tcltk/files/patch-ac22
-rw-r--r--japanese/postgresql-tcltk/files/patch-ad20
-rw-r--r--japanese/postgresql-tcltk/files/patch-ae11
-rw-r--r--japanese/postgresql-tcltk/files/patch-af25
-rw-r--r--japanese/postgresql-tcltk/files/patch-ag11
-rw-r--r--japanese/postgresql-tcltk/files/patch-bc5
-rw-r--r--japanese/postgresql-tcltk/files/pgsql.sh.tmpl53
-rw-r--r--japanese/postgresql-tcltk/files/post-install-notes18
-rw-r--r--japanese/postgresql-tcltk/pkg-comment2
-rw-r--r--japanese/postgresql-tcltk/pkg-descr2
-rw-r--r--japanese/postgresql-tcltk/pkg-install130
-rw-r--r--japanese/postgresql-tcltk/pkg-plist1325
-rw-r--r--japanese/postgresql-tcltk/pkg-plist.jdbc13
-rw-r--r--japanese/postgresql-tcltk/pkg-plist.odbc15
-rw-r--r--japanese/postgresql-tcltk/pkg-plist.tcl136
-rw-r--r--japanese/postgresql-tcltk/scripts/configure7
-rw-r--r--japanese/postgresql-tcltk/scripts/createuser50
-rw-r--r--japanese/postgresql7/Makefile289
-rw-r--r--japanese/postgresql7/distinfo2
-rw-r--r--japanese/postgresql7/files/patch-ab41
-rw-r--r--japanese/postgresql7/files/patch-ac22
-rw-r--r--japanese/postgresql7/files/patch-ad20
-rw-r--r--japanese/postgresql7/files/patch-ae11
-rw-r--r--japanese/postgresql7/files/patch-af25
-rw-r--r--japanese/postgresql7/files/patch-ag11
-rw-r--r--japanese/postgresql7/files/patch-bc5
-rw-r--r--japanese/postgresql7/files/pgsql.sh.tmpl53
-rw-r--r--japanese/postgresql7/files/post-install-notes18
-rw-r--r--japanese/postgresql7/pkg-comment2
-rw-r--r--japanese/postgresql7/pkg-descr2
-rw-r--r--japanese/postgresql7/pkg-install130
-rw-r--r--japanese/postgresql7/pkg-plist1325
-rw-r--r--japanese/postgresql7/pkg-plist.jdbc13
-rw-r--r--japanese/postgresql7/pkg-plist.odbc15
-rw-r--r--japanese/postgresql7/pkg-plist.tcl136
-rw-r--r--japanese/postgresql7/scripts/configure7
-rw-r--r--japanese/postgresql7/scripts/createuser50
40 files changed, 2942 insertions, 1412 deletions
diff --git a/japanese/postgresql-tcltk/Makefile b/japanese/postgresql-tcltk/Makefile
index e99deb40e890..ee410effc32d 100644
--- a/japanese/postgresql-tcltk/Makefile
+++ b/japanese/postgresql-tcltk/Makefile
@@ -1,177 +1,228 @@
-# New ports collection makefile for: PostgreSQL-j
-# Date created: 09 Nov 1999
-# Whom: Ichiro Fukuhara <ichiro@ichiro.org>
+# New ports collection makefile for: PostgreSQL
+# Date created: 7 Jun 2000
+# Whom: Tomokatsu Saito <saito@a2z.co.jp>
#
# $FreeBSD$
#
PORTNAME= postgresql
-PORTVERSION= 6.5.3
+PORTVERSION= 7.0.2
CATEGORIES= japanese databases
-MASTER_SITES= ftp://ftp.jaist.ac.jp/pub/dbms/PostgreSQL/ \
+MASTER_SITES= ftp://ftp.jaist.ac.jp/pub/dbms/PostgreSQL/v${PORTVERSION}/ \
ftp://ftp.sra.co.jp/pub/cmd/postgres/${PORTVERSION}/ \
- ftp://ftp.postgresql.org/pub/
+ ftp://ftp.postgresql.org/pub/v${PORTVERSION}/
+DISTNAME= ${PORTNAME}-${PORTVERSION}
-MAINTAINER= kuriyama@FreeBSD.org
+MAINTAINER= saito@a2z.co.jp
-WRKSRC= ${WRKDIR}/${DISTNAME}/src
-PLISTS=
+.if ${MACHINE_ARCH} == "alpha"
+BROKEN= doesn\'t build on the alpha yet
+.endif
+
+Y2K= http://www.postgresql.org/y2k.html
# if you want to use the tcl/tk frontend pgaccess, then you need to build
-# postgresql with tcl support by typing: make WITH_TCL=yes
-.if defined(WITH_TCL)
-TCL_INCDIR= ${PREFIX}/include/tcl8.0jp
-TK_INCDIR= ${PREFIX}/include/tk8.0jp
-MAKE_ENV= USE_TCL=true USE_TK=true TCL_INCDIR=${TCL_INCDIR}
-CONFIGURE_ARGS= --with-tcl --with-tk \
- --with-tclconfig=${PREFIX}/lib/tcl8.0jp \
- --with-tkconfig=${PREFIX}/lib/tk8.0jp
+# postgresql with tcl support by typing: make USE_TCL=yes
+.if defined(USE_TCL)
LIB_DEPENDS= tcl80jp.1:${PORTSDIR}/japanese/tcl80 \
tk80jp.1:${PORTSDIR}/japanese/tk80
-PLISTS+= PLIST.tcl
+TCL_INCDIR= ${LOCALBASE}/include/tcl8.0jp
+TK_INCDIR= ${LOCALBASE}/include/tk8.0jp
+MAKE_ENV+= TCL_INCDIR=${TCL_INCDIR}
+CONFIGURE_TCL= --with-tcl --with-tclconfig=${LOCALBASE}/lib/tcl8.0jp --with-tkconfig=${LOCALBASE}/lib/tk8.0jp
.endif
.if defined(MULTIBYTE)
-CONFIGURE_ARGS+= --with-mb=${MULTIBYTE}
+WITH_MB= --enable-multibyte=${MULTIBYTE}
.endif
-.if defined(WITH_PERL)
-CONFIGURE_ARGS+= --with-perl
-PLISTS+= PLIST.pl
+.if defined(USE_PERL)
+WITH_PERL= --with-perl
.endif
-.if defined(WITH_ODBC)
-CONFIGURE_ARGS+= --with-odbc
-PLISTS+= PLIST.odbc
+.if defined(USE_ODBC)
+WITH_ODBC= --with-odbc
+.endif
+
+# if you want jdbc, type make USE_JDBC=yes
+# Honors JAVA_HOME if you have it set, and don't want the dependency.
+.if defined(USE_JDBC)
+JAVA_HOME?= ${LOCALBASE}/jdk1.1.8
+BUILD_DEPENDS= ${JAVA_HOME}/bin/javac:${PORTSDIR}/java/jdk
+#MAKE_ENV+= JAVA_HOME=${JAVA_HOME}
+#CONFIGURE_ENV+= JAVA_HOME=${JAVA_HOME}
+SCRIPTS_ENV+= JAVA_HOME=${JAVA_HOME}
.endif
-NO_PACKAGE= "Requires ${PGSQL_UID} uid"
+WRKSRC= ${WRKDIR}/${PORTNAME}-${PORTVERSION}/src
+DOCDIR= ${WRKDIR}/${PORTNAME}-${PORTVERSION}/doc
USE_GMAKE= YES
MAKEFILE= GNUmakefile
HAS_CONFIGURE= YES
-CONFIGURE_ARGS+= --prefix=${PREFIX}/${INSTALL_DIR} \
+CONFIGURE_ARGS= --prefix=${LOCALBASE}/pgsql \
+ --enable-locale \
--with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` \
- --with-includes="${PREFIX}/include ${TCL_INCDIR} ${TK_INCDIR}" \
- --with-libraries=${PREFIX}/lib
-
-INSTALL_TARGET= install install-man
-
-MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \
- destroyuser.1 ecpg.1 initdb.1 initlocation.1 \
- ipcclean.1 pg_dump.1 pg_dumpall.1 pg_passwd.1 \
- pg_upgrade.1 postgres.1 postmaster.1 psql.1
-MAN3= catalogs.3 libpq.3
-MAN5= pg_hba.conf.5
-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_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 \
+ ${WITH_MB} ${WITH_PERL} ${WITH_ODBC} \
+ --with-includes="${LOCALBASE}/include ${TCL_INCDIR} ${TK_INCDIR}" \
+ ${CONFIGURE_TCL} \
+ --with-libraries=${LOCALBASE}/lib
+
+MAN1= createdb.1 createlang.1 createuser.1 dropdb.1 droplang.1 \
+ dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 pg_ctl.1 \
+ pg_dump.1 \
+ pg_dumpall.1 pg_passwd.1 pg_upgrade.1 pgaccess.1 pgadmin.1 \
+ pgtclsh.1 \
+ pgtksh.1 postgres.1 postmaster.1 psql.1 vacuumdb.1
+MANL= abort.l alter_group.l alter_table.l alter_user.l begin.l \
+ close.l \
+ cluster.l comment.l commit.l copy.l create_aggregate.l \
+ create_constraint_trigger.l create_database.l \
+ create_function.l \
+ create_group.l create_index.l create_language.l \
+ create_operator.l \
+ create_rule.l create_sequence.l create_table.l \
+ create_table_as.l \
+ create_trigger.l create_type.l create_user.l create_view.l \
+ declare.l \
+ delete.l drop_aggregate.l drop_database.l drop_function.l \
+ drop_group.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}/${INSTALL_DIR}
-INSTALLS_SHLIB= yes
-LDCONFIG_DIRS= ${PREFIX}/${INSTALL_DIR}/lib
-
-PLIST_SUB= INSTALL_DIR=${INSTALL_DIR}
-PLIST= ${WRKDIR}/PLIST
+ drop_view.l \
+ end.l explain.l fetch.l grant.l insert.l listen.l load.l \
+ lock.l \
+ move.l notify.l reindex.l reset.l revoke.l rollback.l select.l \
+ select_into.l set.l show.l truncate.l unlisten.l update.l \
+ vacuum.l
-# These values are easily overridable like as
-# "make PGQL_UID=postgresql PGSQL_GID=postgresql install"
-INSTALL_DIR= pgsql
-PGSQL_UID= pgsql
-PGSQL_GID= pgsql
+MANPREFIX= ${PREFIX}/pgsql
pre-fetch:
-.if !defined(WITH_TCL) & !defined(WITH_PERL) & !defined(WITH_ODBC) & !defined(MULTIBYTE)
-
- @${ECHO_MSG} "To build the \"MULTIBYTE PostgreSQL\", type:"
- @${ECHO_MSG} " make MULTIBYTE={EUC_JP,EUC_CN,EUC_KR,EUC_TW,UNICODE,MULE_INTERNAL,LATIN1-5}"
- @${ECHO_MSG} " WITH_TCL=yes, WITH_PERL=yes, WITH_ODBC=yes"
- @${ECHO_MSG} ""
+ @${ECHO_MSG} "To install and run postgresql you need to compile kernel with:"
+ @${ECHO_MSG} " options \"SYSVSHM, SYSVSEM, SYSVMSG\""
+.if !defined(USE_TCL)
@${ECHO_MSG} "To build the \"PostgreSQL to Tcl interface library\", libpgtcl, type:"
- @${ECHO_MSG} " make WITH_TCL=yes"
+ @${ECHO_MSG} " make USE_TCL=yes"
.else
@${ECHO_MSG} "Building PostgreSQL with \"libpgtcl\"."
.endif
-
-.include <bsd.port.pre.mk>
+.if !defined(USE_JDBC)
+ @ ${ECHO_MSG} "To build Java (JDBC) support, type:"
+ @ ${ECHO_MSG} " make USE_JDBC=yes"
+.else
+ @ ${ECHO_MSG} "Building PostgreSQL with \"postgresql.jar\"."
+.endif
post-patch:
- find ${WRKDIR} -name '*.orig' -exec ${RM} {} \;
-
+ @ ${MV} ${WRKSRC}/template/freebsd ${WRKSRC}/template/freebsd.orig
+ @ ${SED} -e 's#CFLAGS:-O2 -m486 -pipe#CFLAGS:${CFLAGS}#' \
+ -e 's#USE_LOCALE:no#USE_LOCALE:yes#' \
+ ${WRKSRC}/template/freebsd.orig >> ${WRKSRC}/template/freebsd
+ @ ${MV} ${WRKSRC}/Makefile.global.in ${WRKSRC}/Makefile.global.in.old
+ @ ${SED} -e 's=!!PREFIX!!=${PREFIX}=g' \
+ ${WRKSRC}/Makefile.global.in.old \
+ >> ${WRKSRC}/Makefile.global.in
post-build:
+.if defined(USE_JDBC)
+ @ cd ${WRKSRC}/interfaces/jdbc && ${GMAKE}
+.if !defined(NOPORTDOCS)
+ @ cd ${WRKSRC}/interfaces/jdbc && ${GMAKE} examples
+.endif
+.endif
@ ${ECHO} "------------------------------------------------------------"
@ ${ECHO} "Dump existing databases, before installing new db version !!"
- @ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}... "
+ @ ${ECHO} "Detailed instructions, see"
+ @ ${ECHO} "${WRKDIR}/${DISTNAME}/INSTALL"
@ ${ECHO} "------------------------------------------------------------"
- @${RM} -f ${WRKDIR}/PLIST
-.for i in ${PLISTS} PLIST
- ${CAT} ${PKGDIR}/${i} >> ${WRKDIR}/PLIST
-.endfor
-.if defined(WITH_TCL)
- ${CAT} ${PKGDIR}/PLIST.tcl.dirrm >> ${WRKDIR}/PLIST
-.endif
-.if defined(WITH_ODBC)
- ${CAT} ${PKGDIR}/PLIST.odbc.dirrm >> ${WRKDIR}/PLIST
-.endif
- ${CAT} ${PKGDIR}/PLIST.dirrm >> ${WRKDIR}/PLIST
pre-install:
.if defined(PACKAGE_BUILDING)
- ${RM} -rf ${PREFIX}/${INSTALL_DIR}
+ ${RM} -rf ${PREFIX}/pgsql
.endif
- @ ${MKDIR} ${PREFIX}/${INSTALL_DIR}
- @ ${SETENV} INSTALL_DIR=${INSTALL_DIR} \
- PGSQL_UID=${PGSQL_UID} PGSQL_GID=${PGSQL_GID} \
- PKG_PREFIX=${PREFIX} \
- ${SH} ${PKGDIR}/INSTALL ${PKGNAME} PRE-INSTALL
+ @ ${MKDIR} ${PREFIX}/pgsql
+ @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser
+
post-install:
- @ if [ ! -f ${PREFIX}/${INSTALL_DIR}/.profile ]; then \
- ${ECHO} "PATH=${PATH}:${PREFIX}/${INSTALL_DIR}/bin" \
- > ${PREFIX}/${INSTALL_DIR}/.profile; \
- ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/${INSTALL_DIR}/bin" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
- ${ECHO} "PGLIB=${PREFIX}/${INSTALL_DIR}/lib" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
+.if defined(NOPORTDOCS)
+ @ ( cd ${DOCDIR}; ${GMAKE} man )
+.else
+ @ ( cd ${DOCDIR}; ${GMAKE} install )
+.endif
+ @ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \
+ ${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \
+ > ${PREFIX}/pgsql/.profile; \
+ ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/man" \
+ >> ${PREFIX}/pgsql/.profile; \
+ ${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \
+ >> ${PREFIX}/pgsql/.profile; \
${ECHO} "# note: PGDATA overwrites the -D startup option" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
- ${ECHO} "PGDATA=${PREFIX}/${INSTALL_DIR}/data" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
+ >> ${PREFIX}/pgsql/.profile; \
+ ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \
+ >> ${PREFIX}/pgsql/.profile; \
${ECHO} "DISPLAY=:0" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
+ >> ${PREFIX}/pgsql/.profile; \
${ECHO} "export PATH MANPATH PGLIB PGDATA DISPLAY" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
+ >> ${PREFIX}/pgsql/.profile; \
${ECHO} "# if you want to make regression tests use this TZ" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
+ >> ${PREFIX}/pgsql/.profile; \
${ECHO} "#TZ=PST8PDT" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
+ >> ${PREFIX}/pgsql/.profile; \
${ECHO} "#export TZ" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
+ >> ${PREFIX}/pgsql/.profile; \
fi
- @ ${CHOWN} -R ${PGSQL_UID}:${PGSQL_GID} ${PREFIX}/${INSTALL_DIR}
+ @ ${CHOWN} -R pgsql:pgsql ${PREFIX}/pgsql
@ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...'
- @ ${LDCONFIG} -m ${PREFIX}/${INSTALL_DIR}/lib
- @ /usr/bin/su -l ${PGSQL_UID} -c '${PREFIX}/${INSTALL_DIR}/bin/initdb --pglib=${PREFIX}/${INSTALL_DIR}/lib --pgdata=${PREFIX}/${INSTALL_DIR}/data'
- @ ${SED} "s=!!PG_PATH!!=${PREFIX}/${INSTALL_DIR}=g ; s=!!PGSQL_UID!!=${PGSQL_UID}=g" \
- < ${FILESDIR}/pgsql.sh.tmpl > ${PREFIX}/etc/rc.d/pgsql.sh
+ @ ${SETENV} OBJFORMAT=${PORTOBJFORMAT} ${LDCONFIG} -m ${PREFIX}/pgsql/lib
+ @ su -l pgsql -c 'PATH=${PREFIX}/pgsql/bin:${PATH} ${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data'
+ @ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \
+ > ${PREFIX}/etc/rc.d/pgsql.sh
@ ${CHMOD} 554 ${PREFIX}/etc/rc.d/pgsql.sh
- @ ${CHOWN} root.${PGSQL_GID} ${PREFIX}/etc/rc.d/pgsql.sh
- @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/${INSTALL_DIR}
+ @ ${CHOWN} root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh
+ @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql
+.if defined(USE_TCL)
+ @${CP} ${TMPPLIST} ${TMPPLIST}.notcl
+ @${CAT} ${PKGDIR}/PLIST.tcl ${TMPPLIST}.notcl > ${TMPPLIST}
+ @${RM} ${TMPPLIST}.notcl
+.endif
+.if defined(USE_ODBC)
+ @${CP} ${TMPPLIST} ${TMPPLIST}.noodbc
+ @${CAT} ${PKGDIR}/PLIST.odbc ${TMPPLIST}.noodbc > ${TMPPLIST}
+ @${RM} ${TMPPLIST}.noodbc
+.endif
+.if defined(USE_JDBC)
+ @ ${MKDIR} -m 0555 ${PREFIX}/share/java
+ @ ${INSTALL_DATA} ${WRKSRC}/interfaces/jdbc/postgresql.jar \
+ ${PREFIX}/share/java/postgresql.jar
+ @ ${ECHO_MSG} "---------------------------------------------------------"
+ @ ${ECHO_MSG} "Putting postgresql.jar in ${PREFIX}/share/java"
+ @ ${ECHO_MSG} "Add this to your CLASSPATH!"
+ @ ${ECHO_MSG} "---------------------------------------------------------"
+ ${CAT} ${PKGDIR}/PLIST.jdbc >> ${TMPPLIST}
.if !defined(NOPORTDOCS)
- ${MKDIR} ${PREFIX}/share/doc/${INSTALL_DIR}
- ${CP} -R ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/${INSTALL_DIR}
-.for f in . src src/sgml src/sgml/ref src/graphics
- @${RM} -rf ${PREFIX}/share/doc/${INSTALL_DIR}/$f/CVS
- @${RM} -f ${PREFIX}/share/doc/${INSTALL_DIR}/$f/#cvs*
-.endfor
+ @ ${MKDIR} -m 0555 ${PREFIX}/share/examples/pgsql/jdbc
+ @ ${INSTALL_DATA} ${WRKSRC}/interfaces/jdbc/example/*java \
+ ${PREFIX}/share/examples/pgsql/jdbc
+ @ ${INSTALL_DATA} ${WRKSRC}/interfaces/jdbc/README* \
+ ${PREFIX}/share/examples/pgsql/jdbc
+ @ ${ECHO_MSG} "---------------------------------------------------------"
+ @ ${ECHO_MSG} "Putting jdbc examples into ${PREFIX}/share/examples/pgsql"
+ @ ${ECHO_MSG} "---------------------------------------------------------"
+.endif
+.endif
+.if !defined(NOPORTDOCS)
+ ${MKDIR} ${PREFIX}/share/doc/pgsql
+ @ ${GMAKE} -C ${WRKDIR}/${DISTNAME}/doc install
+ ${INSTALL_MAN} ${WRKDIR}/${DISTNAME}/doc/FAQ* ${PREFIX}/share/doc/pgsql
+ ${INSTALL_MAN} ${WRKDIR}/${DISTNAME}/doc/README* ${PREFIX}/share/doc/pgsql
+ ${INSTALL_MAN} ${WRKDIR}/${DISTNAME}/doc/TODO ${PREFIX}/share/doc/pgsql
+ ${INSTALL_MAN} ${WRKDIR}/${DISTNAME}/doc/*ps ${PREFIX}/share/doc/pgsql
.endif
.if !defined(BATCH)
@ more -e ${FILESDIR}/post-install-notes
.endif
+.if !defined(DEBUG_FLAGS)
+.for file in ecpg pg_dump pg_id pg_passwd pg_version postgres psql
+ @ strip ${PREFIX}/pgsql/bin/${file}
+.endfor
+.endif
-.include <bsd.port.post.mk>
+.include <bsd.port.mk>
diff --git a/japanese/postgresql-tcltk/distinfo b/japanese/postgresql-tcltk/distinfo
index d831c26206f7..8ae9ac603336 100644
--- a/japanese/postgresql-tcltk/distinfo
+++ b/japanese/postgresql-tcltk/distinfo
@@ -1 +1 @@
-MD5 (postgresql-6.5.3.tar.gz) = 098d1ee4316500a2d033ced3ebd5b831
+MD5 (postgresql-7.0.2.tar.gz) = fc512e38394256e2749299fdd69a937e
diff --git a/japanese/postgresql-tcltk/files/patch-ab b/japanese/postgresql-tcltk/files/patch-ab
index cb53b5b7de93..3be237663dd4 100644
--- a/japanese/postgresql-tcltk/files/patch-ab
+++ b/japanese/postgresql-tcltk/files/patch-ab
@@ -1,25 +1,22 @@
---- bin/pg_passwd/pg_passwd.c.orig Thu May 27 16:00:40 1999
-+++ bin/pg_passwd/pg_passwd.c Tue Jun 15 19:27:47 1999
-@@ -26,11 +26,17 @@
+--- bin/pg_passwd/pg_passwd.c.orig Mon Apr 17 12:45:18 2000
++++ bin/pg_passwd/pg_passwd.c Wed May 10 03:39:18 2000
+@@ -18,11 +18,14 @@
#endif
+#ifndef _POSIX_SOURCE
-+# define _PASSWORD_LEN 128 /* max length, not containing NULL */
++# define _PASSWORD_LEN 128 /* max length, not containing NULL */
+#endif
-+
-+
char *comname;
- static void usage(FILE *stream);
- static void read_pwd_file(char *filename);
-+static void encrypt_pwd(char key[9], char salt[3], char passwd[_PASSWORD_LEN+1]);
-+int check_pwd(char key[9], char passwd[_PASSWORD_LEN+1]);
- static void write_pwd_file(char *filename, char *bkname);
--static void encrypt_pwd(char key[9], char salt[3], char passwd[14]);
- static void prompt_for_username(char *username);
- static void prompt_for_password(char *prompt, char *password);
+ static void usage(FILE *stream);
+ static void read_pwd_file(char *filename);
+ static void write_pwd_file(char *filename, char *bkname);
+-static void encrypt_pwd(char key[9], char salt[3], char passwd[14]);
++static void encrypt_pwd(char key[9], char salt[3], char passwd[_PASSWORD_LEN+1]);
+ static void prompt_for_username(char *username);
+ static void prompt_for_password(char *prompt, char *password);
-@@ -158,7 +164,7 @@
+@@ -150,7 +153,7 @@
if (q != NULL)
*(q++) = '\0';
@@ -28,7 +25,7 @@
{
fprintf(stderr, "WARNING: %s: line %d: illegal password length.\n",
filename, npwds + 1);
-@@ -222,7 +228,7 @@
+@@ -214,7 +217,7 @@
}
static void
@@ -37,26 +34,28 @@
{
int n;
-@@ -254,9 +260,7 @@
+@@ -246,9 +249,9 @@
#ifdef NOT_USED
static int
-check_pwd(char key[9], char passwd[14])
++check_pwd(char key[9], char passwd[_PASSWORD_LEN+1])
{
- char shouldbe[14];
++ char shouldbe[_PASSWORD_LEN+1];
char salt[3];
salt[0] = passwd[0];
-@@ -264,7 +268,7 @@
+@@ -256,7 +259,7 @@
salt[2] = '\0';
encrypt_pwd(key, salt, shouldbe);
- return strncmp(shouldbe, passwd, 13) == 0 ? 1 : 0;
-+ return strncmp(shouldbe, passwd, _PASSWORD_LEN) == 0 ? 1 : 0;
++ return strncmp(shouldbe, passwd, _PASSWORD_LEN+1) == 0 ? 1 : 0;
}
- #endif
-@@ -339,7 +343,7 @@
+ #endif
+@@ -332,7 +335,7 @@
char salt[3];
char key[9],
key2[9];
diff --git a/japanese/postgresql-tcltk/files/patch-ac b/japanese/postgresql-tcltk/files/patch-ac
index 2a9e180e0958..f0f0ac586e74 100644
--- a/japanese/postgresql-tcltk/files/patch-ac
+++ b/japanese/postgresql-tcltk/files/patch-ac
@@ -1,11 +1,11 @@
---- interfaces/libpgtcl/Makefile.in.orig Mon Feb 8 07:10:45 1999
-+++ interfaces/libpgtcl/Makefile.in Tue Jun 15 19:32:36 1999
-@@ -27,7 +27,7 @@
-
- OBJS= pgtcl.o pgtclCmds.o pgtclId.o
-
--SHLIB_LINK+= -L../libpq -lpq
-+SHLIB_LINK+= -L../libpq -lpq -lcrypt
-
- # If crypt is a separate library, rather than part of libc, it may need
- # to be referenced separately to keep (broken) linkers happy. (This is
+--- configure.orig Thu May 4 04:10:55 2000
++++ configure Wed May 10 03:46:37 2000
+@@ -1472,7 +1472,7 @@
+ ELF_SYS=true
+ else
+ rm -rf conftest*
+- if test "X$elf" = "Xyes"
++ if test "X$PORTOBJFORMAT" = "Xelf"
+ then
+ ELF_SYS=true
+ else
diff --git a/japanese/postgresql-tcltk/files/patch-ad b/japanese/postgresql-tcltk/files/patch-ad
index ce5713717369..ea1b852b3f87 100644
--- a/japanese/postgresql-tcltk/files/patch-ad
+++ b/japanese/postgresql-tcltk/files/patch-ad
@@ -1,13 +1,11 @@
---- pl/tcl/Makefile.org Mon Dec 14 08:47:17 1998
-+++ pl/tcl/Makefile Thu Feb 25 22:20:28 1999
-@@ -55,8 +55,8 @@
- SHLIB_EXTRA_LIBS=
- endif
+--- Makefile.global.in.orig Wed May 10 03:47:24 2000
++++ Makefile.global.in Wed May 10 03:48:37 2000
+@@ -87,7 +87,7 @@
+ POSTMANDIR= $(POSTGRESDIR)/man
--%$(TCL_SHLIB_SUFFIX): %.o
-- $(TCL_SHLIB_LD) -o $@ $< $(TCL_LIB_SPEC) $(SHLIB_EXTRA_LIBS)
-+#%$(TCL_SHLIB_SUFFIX): %.o
-+# $(TCL_SHLIB_LD) -o $@ $< $(TCL_LIB_SPEC) $(SHLIB_EXTRA_LIBS)
+ # Where the formatted documents (e.g., the reference manual) get installed.
+-POSTDOCDIR= $(POSTGRESDIR)/doc
++POSTDOCDIR= !!PREFIX!!/share/doc/pgsql
-
- #
+ # Where the header files necessary to build frontend programs get installed.
+ HEADERDIR= $(POSTGRESDIR)/include
diff --git a/japanese/postgresql-tcltk/files/patch-ae b/japanese/postgresql-tcltk/files/patch-ae
new file mode 100644
index 000000000000..82a8e0012494
--- /dev/null
+++ b/japanese/postgresql-tcltk/files/patch-ae
@@ -0,0 +1,11 @@
+--- ../doc/Makefile.orig Mon Dec 6 06:23:00 1999
++++ ../doc/Makefile Wed May 10 03:50:13 2000
+@@ -12,7 +12,7 @@
+ #
+ #----------------------------------------------------------------------------
+
+-PGDOCS= $(POSTGRESDIR)/doc
++PGDOCS= $(POSTDOCDIR)
+ SRCDIR= ../src
+
+ TAR= tar
diff --git a/japanese/postgresql-tcltk/files/patch-af b/japanese/postgresql-tcltk/files/patch-af
new file mode 100644
index 000000000000..58d833335108
--- /dev/null
+++ b/japanese/postgresql-tcltk/files/patch-af
@@ -0,0 +1,25 @@
+--- interfaces/jdbc/Makefile.orig Tue May 9 12:47:50 2000
++++ interfaces/jdbc/Makefile Wed May 10 03:53:41 2000
+@@ -10,10 +10,10 @@
+
+ FIND = find
+ IDL2JAVA = idltojava -fno-cpp -fno-tie
+-JAR = jar
+-JAVA = java
+-JAVAC = javac -g
+-JAVADOC = javadoc
++JAR = !!JAVA_HOME!!/bin/jar
++JAVA = !!JAVA_HOME!!/bin/java
++JAVAC = !!JAVA_HOME!!/bin/javac
++JAVADOC = !!JAVA_HOME!!/bin/javadoc
+ RM = rm -f
+ TOUCH = touch
+
+@@ -49,6 +49,7 @@
+ @echo JVM.
+ @echo
+ @echo ------------------------------------------------------------
++ $(MAKE) jdbc1
+
+ msg:
+ @echo ------------------------------------------------------------
diff --git a/japanese/postgresql-tcltk/files/patch-ag b/japanese/postgresql-tcltk/files/patch-ag
new file mode 100644
index 000000000000..e15a1521b855
--- /dev/null
+++ b/japanese/postgresql-tcltk/files/patch-ag
@@ -0,0 +1,11 @@
+--- pl/tcl/Makefile.orig Sun Apr 30 02:45:42 2000
++++ pl/tcl/Makefile Fri May 12 21:31:07 2000
+@@ -66,7 +66,7 @@
+ # Instead use TCL's CFLAGS plus necessary -I directives.
+
+ # Can choose either TCL_CFLAGS_OPTIMIZE or TCL_CFLAGS_DEBUG here, as needed
+-CFLAGS= $(TCL_CFLAGS_OPTIMIZE)
++CFLAGS+= $(TCL_CFLAGS_OPTIMIZE)
+
+ CFLAGS+= $(TCL_SHLIB_CFLAGS) $(TCL_DEFS)
+
diff --git a/japanese/postgresql-tcltk/files/patch-bc b/japanese/postgresql-tcltk/files/patch-bc
new file mode 100644
index 000000000000..e4e98dd945b0
--- /dev/null
+++ b/japanese/postgresql-tcltk/files/patch-bc
@@ -0,0 +1,5 @@
+--- bin/pg_ctl/postmaster.opts.default.sample.org Tue Jun 6 15:23:50 2000
++++ bin/pg_ctl/postmaster.opts.default.sample Tue Jun 6 15:24:08 2000
+@@ -1 +1 @@
+-
++-i -o "-F"
diff --git a/japanese/postgresql-tcltk/files/pgsql.sh.tmpl b/japanese/postgresql-tcltk/files/pgsql.sh.tmpl
index d3f0af6cb802..e1673b4850c2 100644
--- a/japanese/postgresql-tcltk/files/pgsql.sh.tmpl
+++ b/japanese/postgresql-tcltk/files/pgsql.sh.tmpl
@@ -1,39 +1,34 @@
#!/bin/sh
# $FreeBSD$
-
-# pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested)
-
-# Changes:
-# - renamed startup script to be in sync with INSTALL file
-# - merged ldconfig start sequence from former postgrsql.sh script (andreas)
-# - modified the postmaster startup sequence as suggested in the
-# INSTALL file which was given as example for FreeBSD 2.2 (andreas)
-# - removed the commandline option
-# -D!!PG_PATH!!/data \
-# because the postmaster process, which starts up under the
-# environment of the pgsql user, sets this with the PGDATA
-# environment variable in !!PG_PATH!!/.profile
#
+# For postmaster startup options, edit $PGDATA/postmaster.opts.default
+# Preinstalled options are -i -o "-F"
-case "$1" in
+case $1 in
start)
- [ -d !!PG_PATH!!/lib ] && /sbin/ldconfig -m !!PG_PATH!!/lib
+ [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib
+ [ -x !!PREFIX!!/pgsql/bin/pg_ctl ] && {
+ su -l pgsql -c \
+ 'exec !!PREFIX!!/pgsql/bin/pg_ctl -w start > !!PREFIX!!/pgsql/errlog 2>&1'
+ echo -n ' pgsql'
+ }
+ ;;
- [ -x !!PG_PATH!!/bin/postmaster ] && {
- su -l !!PGSQL_UID!! -c 'exec !!PG_PATH!!/bin/postmaster -i -S -o -F \
- -D!!PG_PATH!!/data > !!PG_PATH!!/errlog'
- echo -n ' PostgreSQL'
- }
- ;;
stop)
- # XXX some pgsql user should check this --tg
- killall !!PG_PATH!!/bin/postmaster
- ;;
+ [ -x !!PREFIX!!/pgsql/bin/pg_ctl ] && {
+ su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/pg_ctl -w -m fast stop'
+ }
+ ;;
+
+status)
+ [ -x !!PREFIX!!/pgsql/bin/pg_ctl ] && {
+ su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/pg_ctl status'
+ }
+ ;;
+
*)
- echo "Usage: `basename $0` {start|stop}" >&2
- exit 64
- ;;
+ echo "usage: `basename $0` {start|stop|status}" >&2
+ exit 64
+ ;;
esac
-
-exit 0
diff --git a/japanese/postgresql-tcltk/files/post-install-notes b/japanese/postgresql-tcltk/files/post-install-notes
index 4e6e8df02c33..d99f47615730 100644
--- a/japanese/postgresql-tcltk/files/post-install-notes
+++ b/japanese/postgresql-tcltk/files/post-install-notes
@@ -1,24 +1,14 @@
-Now that PostgreSQL-j was installed, you should read the documentation and
+Now that PostgreSQL is installed, you should read the documentation and
implementation guides. These can be found at:
http://www.PostgreSQL.org/docs
-Documentations for the Multibyte-extention can be found at:
-
- doc/README.mb (English)
- doc/README.mb.jp (Japanese)
-
You may wish to subscribe to the PostgreSQL user-support mailing list.
Send an e-mail to pgsql-questions-request@postgresql.org with the
text "subscribe" in the message body.
-If you understand Japanese, you might want to visit:
-
- http://www.sra.co.jp/people/t-ishii/PostgreSQL
-
-to subscribe a local mailing list for Japanese speakers.
-
-If you build PostgreSQL with TCL support, then you can use the
-TCL/TK based database frontend "pgaccess" for database operations.
+If you built PostgreSQL with TCL support, you can install the port
+"pgaccess" to get a TCL/TK based database frontend for database
+operations.
diff --git a/japanese/postgresql-tcltk/pkg-comment b/japanese/postgresql-tcltk/pkg-comment
index b51d5a751f5a..2125016b133c 100644
--- a/japanese/postgresql-tcltk/pkg-comment
+++ b/japanese/postgresql-tcltk/pkg-comment
@@ -1 +1 @@
-A robust, next generation, object-relational DBMS plus Multibyte-patch
+A robust, next generation, object-relational DBMS
diff --git a/japanese/postgresql-tcltk/pkg-descr b/japanese/postgresql-tcltk/pkg-descr
index c8fed1c9b1be..f48a33337e55 100644
--- a/japanese/postgresql-tcltk/pkg-descr
+++ b/japanese/postgresql-tcltk/pkg-descr
@@ -21,4 +21,4 @@ support mailing list (questions@PostgreSQL.ORG).
PostgreSQL is free and the complete source is available.
-WWW: http://www.PostgreSQL.ORG/
+WWW: http://www.postgresql.org
diff --git a/japanese/postgresql-tcltk/pkg-install b/japanese/postgresql-tcltk/pkg-install
index 1fb5e347efe5..d24c95fd12c6 100644
--- a/japanese/postgresql-tcltk/pkg-install
+++ b/japanese/postgresql-tcltk/pkg-install
@@ -1,98 +1,44 @@
-#!/bin/sh
-# an installation script for postgresql
+#! /bin/sh
-check_pw()
-{
- if which -s pw; then
- :
- else
- cat <<EOF
+# $FreeBSD: /tmp/pcvs/ports/japanese/postgresql-tcltk/Attic/pkg-install,v 1.4 2000-07-19 01:18:07 kuriyama Exp $
-This system looks like a pre-2.2 version of FreeBSD. We see that it
-is missing the "pw" utility. We need this utility. Please get and
-install it, and try again. You can get the source from:
+PATH=/bin:/usr/sbin
- ftp://ftp.freebsd.org/pub/FreeBSD/FreeBSD-current/src/usr.sbin/pw.tar.gz
-
-EOF
- exit 1
- fi
-}
-
-ask() {
- local question default answer
-
- question=$1
- default=$2
- if [ -z "${PACKAGE_BUILDING}" ]; then
- read -p "${question} (y/n) [${default}]? " answer
- fi
- if [ x${answer} = x ]; then
- answer=${default}
- fi
- echo ${answer}
-}
-
-yesno() {
- local dflt question answer
-
- question=$1
- dflt=$2
- while :; do
- answer=$(ask "${question}" "${dflt}")
- case "${answer}" in
- [Yy]*) return 0;;
- [Nn]*) return 1;;
- esac
- echo "Please answer yes or no."
- done
-}
+if [ -z "${DB_DIR}" ]; then
+ DB_DIR=/usr/local/pgsql/data
+fi
case $2 in
-PRE-INSTALL)
-
- ## Hack /etc/master.passwd ##
- # check
- id_70=`id -nu 70 2> /dev/null`
- id_pgsql=`id -u ${PGSQL_UID} 2> /dev/null`
- if [ X"$id_pgsql" != X ]; then
- exit 0
- elif [ X"$id_70" != X ]; then
- cat <<EOF
-
-+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-This system already has an account whose name is '$id_70' and ID number is 70.
-
- '`id $id_70`'
-
-For PostgreSQL in this port or package, UID:GID of '${PGSQL_UID}' has to be 70:70.
-Please try again after you delete the account.
-+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-EOF
- exit 1
- fi
-
- # add an account of PostgreSQL to this system
- echo ""
- echo "You need a group '${PGSQL_GID}' whose ID number is 70"
- if yesno "Would you like to create it automatically?" y; then
- # We need a command 'pw(8)'
- check_pw
- pw groupadd ${PGSQL_GID} -g 70 || exit
- else
- echo "Please create it, and try again."
- exit 1
- fi
- echo ""
- echo "You need an account '${PGSQL_UID}' whose ID number is 70"
- if yesno "Would you like to create it automatically?" y; then
- # We need a command 'pw(8)'
- check_pw
- pw useradd ${PGSQL_UID} -u 70 -g ${PGSQL_GID} -h - -d ${PKG_PREFIX}/${INSTALL_DIR} \
- -s /bin/sh -c "PostgreSQL pseudo-user" || exit
- else
- echo "Please create it, and try again."
- exit 1
- fi
- ;;
+POST-INSTALL)
+ USER=pgsql
+ GROUP=${USER}
+ UID=89
+ GID=${UID}
+
+ if pw group show "${GROUP}" 2>/dev/null; then
+ echo "You already have a group \"${GROUP}\", so I will use it."
+ else
+ if pw groupadd ${GROUP} -g ${GID}; then
+ echo "Added group \"${GROUP}\"."
+ else
+ echo "Adding group \"${GROUP}\" failed..."
+ exit 1
+ fi
+ fi
+
+ if pw user show "${USER}" 2>/dev/null; then
+ echo "You already have a user \"${USER}\", so I will use it."
+ else
+ if pw useradd ${USER} -u ${UID} -g ${GROUP} -h - \
+ -d ${DB_DIR} -s /sbin/nologin -c "PostgreSQL Daemon"
+ then
+ echo "Added user \"${USER}\"."
+ else
+ echo "Adding user \"${USER}\" failed..."
+ exit 1
+ fi
+ fi
+
+ chown -R ${USER}.${GROUP} ${DB_DIR}
+ ;;
esac
diff --git a/japanese/postgresql-tcltk/pkg-plist b/japanese/postgresql-tcltk/pkg-plist
index 8e2e081e3d1d..88947ef7b47c 100644
--- a/japanese/postgresql-tcltk/pkg-plist
+++ b/japanese/postgresql-tcltk/pkg-plist
@@ -1,271 +1,1056 @@
etc/rc.d/pgsql.sh
-%%INSTALL_DIR%%/.profile
-%%INSTALL_DIR%%/bin/cleardbdir
-%%INSTALL_DIR%%/bin/createdb
-%%INSTALL_DIR%%/bin/createlang
-%%INSTALL_DIR%%/bin/createuser
-%%INSTALL_DIR%%/bin/destroydb
-%%INSTALL_DIR%%/bin/destroylang
-%%INSTALL_DIR%%/bin/destroyuser
-%%INSTALL_DIR%%/bin/ecpg
-%%INSTALL_DIR%%/bin/initdb
-%%INSTALL_DIR%%/bin/initlocation
-%%INSTALL_DIR%%/bin/ipcclean
-%%INSTALL_DIR%%/bin/pg_dump
-%%INSTALL_DIR%%/bin/pg_dumpall
-%%INSTALL_DIR%%/bin/pg_id
-%%INSTALL_DIR%%/bin/pg_passwd
-%%INSTALL_DIR%%/bin/pg_upgrade
-%%INSTALL_DIR%%/bin/pg_version
-%%INSTALL_DIR%%/bin/postgres
-%%INSTALL_DIR%%/bin/postmaster
-%%INSTALL_DIR%%/bin/psql
-%%INSTALL_DIR%%/bin/vacuumdb
-%%INSTALL_DIR%%/lib/global1.bki.source
-%%INSTALL_DIR%%/lib/global1.description
-%%INSTALL_DIR%%/lib/libecpg.a
-%%INSTALL_DIR%%/lib/libecpg.so
-%%INSTALL_DIR%%/lib/libecpg.so.3
-%%INSTALL_DIR%%/lib/libpq++.a
-%%INSTALL_DIR%%/lib/libpq++.so
-%%INSTALL_DIR%%/lib/libpq++.so.3
-%%INSTALL_DIR%%/lib/libpq.a
-%%INSTALL_DIR%%/lib/libpq.so
-%%INSTALL_DIR%%/lib/libpq.so.2
-%%INSTALL_DIR%%/lib/local1_template1.bki.source
-%%INSTALL_DIR%%/lib/local1_template1.description
-%%INSTALL_DIR%%/lib/pg_geqo.sample
-%%INSTALL_DIR%%/lib/pg_hba.conf.sample
-%%INSTALL_DIR%%/lib/plpgsql.so
-%%INSTALL_DIR%%/include/c.h
-%%INSTALL_DIR%%/include/config.h
-%%INSTALL_DIR%%/include/ecpgerrno.h
-%%INSTALL_DIR%%/include/ecpglib.h
-%%INSTALL_DIR%%/include/ecpgtype.h
-%%INSTALL_DIR%%/include/fmgr.h
-%%INSTALL_DIR%%/include/libpq++.H
-%%INSTALL_DIR%%/include/libpq-fe.h
-%%INSTALL_DIR%%/include/libpq-int.h
-%%INSTALL_DIR%%/include/os.h
-%%INSTALL_DIR%%/include/postgres.h
-%%INSTALL_DIR%%/include/postgres_ext.h
-%%INSTALL_DIR%%/include/sqlca.h
-%%INSTALL_DIR%%/include/access/attnum.h
-%%INSTALL_DIR%%/include/commands/trigger.h
-%%INSTALL_DIR%%/include/executor/spi.h
-%%INSTALL_DIR%%/include/lib/dllist.h
-%%INSTALL_DIR%%/include/libpq/pqcomm.h
-%%INSTALL_DIR%%/include/libpq/libpq-fs.h
-%%INSTALL_DIR%%/include/libpq++/pgconnection.h
-%%INSTALL_DIR%%/include/libpq++/pgcursordb.h
-%%INSTALL_DIR%%/include/libpq++/pgdatabase.h
-%%INSTALL_DIR%%/include/libpq++/pglobject.h
-%%INSTALL_DIR%%/include/libpq++/pgtransdb.h
-%%INSTALL_DIR%%/include/utils/elog.h
-%%INSTALL_DIR%%/include/utils/geo_decls.h
-%%INSTALL_DIR%%/include/utils/mcxt.h
-%%INSTALL_DIR%%/include/utils/palloc.h
-%%INSTALL_DIR%%/post-install-notes
-share/doc/%%INSTALL_DIR%%/src/graphics/catalogs.ag
-share/doc/%%INSTALL_DIR%%/src/graphics/catalogs.cgm
-share/doc/%%INSTALL_DIR%%/src/graphics/catalogs.gif
-share/doc/%%INSTALL_DIR%%/src/graphics/catalogs.ps
-share/doc/%%INSTALL_DIR%%/src/graphics/clientserver.ag
-share/doc/%%INSTALL_DIR%%/src/graphics/clientserver.gif
-share/doc/%%INSTALL_DIR%%/src/graphics/connections.ag
-share/doc/%%INSTALL_DIR%%/src/graphics/connections.gif
-share/doc/%%INSTALL_DIR%%/src/graphics/layout.ag
-share/doc/%%INSTALL_DIR%%/src/graphics/layout.gif
-share/doc/%%INSTALL_DIR%%/src/sgml/Makefile
-share/doc/%%INSTALL_DIR%%/src/sgml/about.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/admin.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/advanced.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/arch-dev.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/arch-pg.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/arch.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/array.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/biblio.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/bki.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/compiler.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/config.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/contacts.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/cvs.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/datatype.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/datetime.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/dfunc.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/docguide.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ecpg.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/environ.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/extend.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/func-ref.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/func.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/geqo.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/gist.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/history.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/indices.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/info.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/inherit.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/install-win32.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/install.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/installation.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/intro-ag.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/intro-pg.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/intro.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/jdbc.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/keys.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/layout.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/legal.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/libpgtcl.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/libpq++.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/libpq.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/lobj.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/manage.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/manage-ag.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/mvcc.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/notation.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/odbc.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/oper.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/page.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/pg_options.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ports.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/postgres.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/programmer.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/protocol.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/query.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/recovery.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/reference.ced
-share/doc/%%INSTALL_DIR%%/src/sgml/reference.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/regress.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/release.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/rules.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/runtime.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/security.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/signals.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/spi.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/sql.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/start-ag.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/start.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/storage.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/syntax.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/trigger.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/trouble.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/tutorial.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/typeconv.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/user.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/xaggr.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/xfunc.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/xindex.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/xoper.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/xplang.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/xtypes.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/y2k.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/abort.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/allfiles.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/alter_table.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/alter_user.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/begin.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/close.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/cluster.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/commands.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/commit.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/copy.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_aggregate.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_database.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_function.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_index.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_language.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_operator.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_rule.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_sequence.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_table.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_table_as.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_trigger.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_type.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_user.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_view.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/createdb.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/createuser.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/current_date.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/current_time.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/current_timestamp.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/current_user.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/declare.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/delete.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/destroydb.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/destroyuser.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_aggregate.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_database.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_function.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_index.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_language.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_operator.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_rule.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_sequence.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_table.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_trigger.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_type.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_user.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_view.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/explain.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/fetch.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/grant.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/initdb.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/initlocation.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/insert.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/listen.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/load.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/lock.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/move.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/notify.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/pg_dump.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/pg_dumpall.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/pg_upgrade.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/pgaccess-ref.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/pgadmin-ref.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/postgres-ref.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/postmaster.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/psql-ref.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/reset.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/revoke.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/rollback.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/select.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/select_into.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/set.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/show.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/unlisten.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/update.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/vacuum.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/vacuumdb.sgml
-share/doc/%%INSTALL_DIR%%/src/Makefile
-share/doc/%%INSTALL_DIR%%/user.tar.gz
-share/doc/%%INSTALL_DIR%%/internals.ps
-share/doc/%%INSTALL_DIR%%/user.ps.gz
-share/doc/%%INSTALL_DIR%%/tutorial.tar.gz
-share/doc/%%INSTALL_DIR%%/tutorial.ps.gz
-share/doc/%%INSTALL_DIR%%/programmer.tar.gz
-share/doc/%%INSTALL_DIR%%/programmer.ps.gz
-share/doc/%%INSTALL_DIR%%/postgres.tar.gz
-share/doc/%%INSTALL_DIR%%/bug.template
-share/doc/%%INSTALL_DIR%%/admin.tar.gz
-share/doc/%%INSTALL_DIR%%/admin.ps.gz
-share/doc/%%INSTALL_DIR%%/TODO
-share/doc/%%INSTALL_DIR%%/README.fsync
-share/doc/%%INSTALL_DIR%%/README.inet
-share/doc/%%INSTALL_DIR%%/README.locale
-share/doc/%%INSTALL_DIR%%/README.mb
-share/doc/%%INSTALL_DIR%%/README.mb.jp
-share/doc/%%INSTALL_DIR%%/Makefile
-share/doc/%%INSTALL_DIR%%/FAQ
-share/doc/%%INSTALL_DIR%%/FAQ_AIX
-share/doc/%%INSTALL_DIR%%/FAQ_DEV
-share/doc/%%INSTALL_DIR%%/FAQ_DigitalUnix
-share/doc/%%INSTALL_DIR%%/FAQ_FreeBSD
-share/doc/%%INSTALL_DIR%%/FAQ_HPUX
-share/doc/%%INSTALL_DIR%%/FAQ_Irix
-share/doc/%%INSTALL_DIR%%/FAQ_Linux
-share/doc/%%INSTALL_DIR%%/FAQ_SCO
-share/doc/%%INSTALL_DIR%%/FAQ_Solaris
-share/doc/%%INSTALL_DIR%%/KNOWN_BUGS
-share/doc/%%INSTALL_DIR%%/MISSING_FEATURES
-share/doc/%%INSTALL_DIR%%/README.Charsets
-share/doc/%%INSTALL_DIR%%/README.NT
+pgsql/.profile
+pgsql/bin/createdb
+pgsql/bin/createlang
+pgsql/bin/createuser
+pgsql/bin/dropdb
+pgsql/bin/droplang
+pgsql/bin/dropuser
+pgsql/bin/ecpg
+pgsql/bin/initdb
+pgsql/bin/initlocation
+pgsql/bin/ipcclean
+pgsql/bin/pg_ctl
+pgsql/bin/pg_dump
+pgsql/bin/pg_dumpall
+pgsql/bin/pg_id
+pgsql/bin/pg_passwd
+pgsql/bin/pg_upgrade
+pgsql/bin/pg_version
+pgsql/bin/postgres
+pgsql/bin/postmaster
+pgsql/bin/psql
+pgsql/bin/vacuumdb
+pgsql/data/PG_VERSION
+pgsql/data/base/template1/PG_VERSION
+pgsql/data/base/template1/pg_aggregate
+pgsql/data/base/template1/pg_aggregate_name_type_index
+pgsql/data/base/template1/pg_am
+pgsql/data/base/template1/pg_am_name_index
+pgsql/data/base/template1/pg_amop
+pgsql/data/base/template1/pg_amop_opid_index
+pgsql/data/base/template1/pg_amop_strategy_index
+pgsql/data/base/template1/pg_amproc
+pgsql/data/base/template1/pg_attrdef
+pgsql/data/base/template1/pg_attrdef_adrelid_index
+pgsql/data/base/template1/pg_attribute
+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_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_index_indexrelid_index
+pgsql/data/base/template1/pg_indexes
+pgsql/data/base/template1/pg_inheritproc
+pgsql/data/base/template1/pg_inherits
+pgsql/data/base/template1/pg_inherits_relid_seqno_index
+pgsql/data/base/template1/pg_ipl
+pgsql/data/base/template1/pg_language
+pgsql/data/base/template1/pg_language_name_index
+pgsql/data/base/template1/pg_language_oid_index
+pgsql/data/base/template1/pg_listener
+pgsql/data/base/template1/pg_listener_relname_pid_index
+pgsql/data/base/template1/pg_opclass
+pgsql/data/base/template1/pg_opclass_deftype_index
+pgsql/data/base/template1/pg_opclass_name_index
+pgsql/data/base/template1/pg_operator
+pgsql/data/base/template1/pg_operator_oid_index
+pgsql/data/base/template1/pg_operator_oprname_l_r_k_index
+pgsql/data/base/template1/pg_proc
+pgsql/data/base/template1/pg_proc_oid_index
+pgsql/data/base/template1/pg_proc_proname_narg_type_index
+pgsql/data/base/template1/pg_relcheck
+pgsql/data/base/template1/pg_relcheck_rcrelid_index
+pgsql/data/base/template1/pg_rewrite
+pgsql/data/base/template1/pg_rewrite_oid_index
+pgsql/data/base/template1/pg_rewrite_rulename_index
+pgsql/data/base/template1/pg_rules
+pgsql/data/base/template1/pg_statistic
+pgsql/data/base/template1/pg_statistic_relid_att_index
+pgsql/data/base/template1/pg_tables
+pgsql/data/base/template1/pg_trigger
+pgsql/data/base/template1/pg_trigger_tgconstrname_index
+pgsql/data/base/template1/pg_trigger_tgconstrrelid_index
+pgsql/data/base/template1/pg_trigger_tgrelid_index
+pgsql/data/base/template1/pg_type
+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_views
+pgsql/data/pg_control
+pgsql/data/pg_database
+pgsql/data/pg_geqo.sample
+pgsql/data/pg_group
+pgsql/data/pg_group_name_index
+pgsql/data/pg_group_sysid_index
+pgsql/data/pg_hba.conf
+pgsql/data/pg_log
+pgsql/data/pg_shadow
+pgsql/data/pg_variable
+pgsql/data/postmaster.opts.default
+pgsql/include/access/attnum.h
+pgsql/include/c.h
+pgsql/include/commands/trigger.h
+pgsql/include/config.h
+pgsql/include/ecpgerrno.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/libpgeasy.h
+pgsql/include/libpq++.h
+pgsql/include/libpq++/pgconnection.h
+pgsql/include/libpq++/pgcursordb.h
+pgsql/include/libpq++/pgdatabase.h
+pgsql/include/libpq++/pglobject.h
+pgsql/include/libpq++/pgtransdb.h
+pgsql/include/libpq-fe.h
+pgsql/include/libpq-int.h
+pgsql/include/libpq/libpq-fs.h
+pgsql/include/libpq/pqcomm.h
+pgsql/include/os.h
+pgsql/include/postgres.h
+pgsql/include/postgres_ext.h
+pgsql/include/pqexpbuffer.h
+pgsql/include/sql3types.h
+pgsql/include/sqlca.h
+pgsql/include/utils/elog.h
+pgsql/include/utils/geo_decls.h
+pgsql/include/utils/mcxt.h
+pgsql/include/utils/palloc.h
+pgsql/lib/global1.bki.source
+pgsql/lib/global1.description
+pgsql/lib/libecpg.a
+pgsql/lib/libecpg.so
+pgsql/lib/libecpg.so.3
+pgsql/lib/libpgeasy.a
+pgsql/lib/libpgeasy.so
+pgsql/lib/libpgeasy.so.2
+pgsql/lib/libpq++.a
+pgsql/lib/libpq++.so
+pgsql/lib/libpq++.so.3
+pgsql/lib/libpq.a
+pgsql/lib/libpq.so
+pgsql/lib/libpq.so.2
+pgsql/lib/local1_template1.bki.source
+pgsql/lib/local1_template1.description
+pgsql/lib/pg_geqo.sample
+pgsql/lib/pg_ident.conf.sample
+pgsql/lib/pg_hba.conf.sample
+pgsql/lib/pg_options.sample
+pgsql/lib/plpgsql.so
+pgsql/lib/postmaster.opts.default.sample
+@exec /usr/bin/env OBJFORMAT=%%PORTOBJFORMAT%% /sbin/ldconfig -m %B
+@unexec /usr/bin/env OBJFORMAT=%%PORTOBJFORMAT%% /sbin/ldconfig -R
+pgsql/post-install-notes
+share/doc/pgsql/FAQ
+share/doc/pgsql/FAQ_AIX
+share/doc/pgsql/FAQ_BSDI
+share/doc/pgsql/FAQ_DEV
+share/doc/pgsql/FAQ_DigitalUnix
+share/doc/pgsql/FAQ_FreeBSD
+share/doc/pgsql/FAQ_HPUX
+share/doc/pgsql/FAQ_Irix
+share/doc/pgsql/FAQ_Linux
+share/doc/pgsql/FAQ_QNX4
+share/doc/pgsql/FAQ_SCO
+share/doc/pgsql/FAQ_Solaris
+share/doc/pgsql/README.Charsets
+share/doc/pgsql/README.NT
+share/doc/pgsql/README.fsync
+share/doc/pgsql/README.inet
+share/doc/pgsql/README.locale
+share/doc/pgsql/README.mb
+share/doc/pgsql/README.mb.jp
+share/doc/pgsql/TODO
+share/doc/pgsql/internals.ps
+share/doc/pgsql/admin/admin.htm
+share/doc/pgsql/admin/admin.html
+share/doc/pgsql/admin/biblio.htm
+share/doc/pgsql/admin/c573.htm
+share/doc/pgsql/admin/c573602.htm
+share/doc/pgsql/admin/c573680.htm
+share/doc/pgsql/admin/c573717.htm
+share/doc/pgsql/admin/copyright.htm
+share/doc/pgsql/admin/disk.htm
+share/doc/pgsql/admin/index.html
+share/doc/pgsql/admin/install-win32.htm
+share/doc/pgsql/admin/install-win321073.htm
+share/doc/pgsql/admin/install-win321082.htm
+share/doc/pgsql/admin/install.htm
+share/doc/pgsql/admin/install855.htm
+share/doc/pgsql/admin/intro-ag.htm
+share/doc/pgsql/admin/intro-ag162.htm
+share/doc/pgsql/admin/layout.gif
+share/doc/pgsql/admin/layout.htm
+share/doc/pgsql/admin/manage-ag.htm
+share/doc/pgsql/admin/manage-ag1604.htm
+share/doc/pgsql/admin/manage-ag1646.htm
+share/doc/pgsql/admin/manage-ag1655.htm
+share/doc/pgsql/admin/newuser.htm
+share/doc/pgsql/admin/notation.htm
+share/doc/pgsql/admin/pg-options.htm
+share/doc/pgsql/admin/ports.htm
+share/doc/pgsql/admin/ports481.htm
+share/doc/pgsql/admin/postmaster.htm
+share/doc/pgsql/admin/preface.htm
+share/doc/pgsql/admin/recovery.htm
+share/doc/pgsql/admin/regress.htm
+share/doc/pgsql/admin/regress1861.htm
+share/doc/pgsql/admin/regress1895.htm
+share/doc/pgsql/admin/regress1941.htm
+share/doc/pgsql/admin/release.htm
+share/doc/pgsql/admin/release2009.htm
+share/doc/pgsql/admin/release2020.htm
+share/doc/pgsql/admin/release2031.htm
+share/doc/pgsql/admin/release2042.htm
+share/doc/pgsql/admin/release2124.htm
+share/doc/pgsql/admin/release2135.htm
+share/doc/pgsql/admin/release2146.htm
+share/doc/pgsql/admin/release2187.htm
+share/doc/pgsql/admin/release2203.htm
+share/doc/pgsql/admin/release2222.htm
+share/doc/pgsql/admin/release2266.htm
+share/doc/pgsql/admin/release2288.htm
+share/doc/pgsql/admin/release2303.htm
+share/doc/pgsql/admin/release2312.htm
+share/doc/pgsql/admin/release2335.htm
+share/doc/pgsql/admin/release2349.htm
+share/doc/pgsql/admin/release2352.htm
+share/doc/pgsql/admin/release2377.htm
+share/doc/pgsql/admin/release2414.htm
+share/doc/pgsql/admin/release2421.htm
+share/doc/pgsql/admin/release2428.htm
+share/doc/pgsql/admin/release2435.htm
+share/doc/pgsql/admin/release2439.htm
+share/doc/pgsql/admin/runtime.htm
+share/doc/pgsql/admin/security.htm
+share/doc/pgsql/admin/security1450.htm
+share/doc/pgsql/admin/security1485.htm
+share/doc/pgsql/admin/security1509.htm
+share/doc/pgsql/admin/security1530.htm
+share/doc/pgsql/admin/terminology.htm
+share/doc/pgsql/admin/trouble.htm
+share/doc/pgsql/admin/trouble1721.htm
+share/doc/pgsql/admin/trouble1738.htm
+share/doc/pgsql/admin/y2k.htm
+share/doc/pgsql/postgres/about.htm
+share/doc/pgsql/postgres/advanced.htm
+share/doc/pgsql/postgres/advanced27923.htm
+share/doc/pgsql/postgres/advanced27945.htm
+share/doc/pgsql/postgres/app-createdb.htm
+share/doc/pgsql/postgres/app-createlang.htm
+share/doc/pgsql/postgres/app-createuser.htm
+share/doc/pgsql/postgres/app-dropdb.htm
+share/doc/pgsql/postgres/app-droplang.htm
+share/doc/pgsql/postgres/app-dropuser.htm
+share/doc/pgsql/postgres/app-ecpg.htm
+share/doc/pgsql/postgres/app-initdb.htm
+share/doc/pgsql/postgres/app-initlocation.htm
+share/doc/pgsql/postgres/app-ipcclean.htm
+share/doc/pgsql/postgres/app-pg-passwd.htm
+share/doc/pgsql/postgres/app-pg-upgrade.htm
+share/doc/pgsql/postgres/app-pgaccess.htm
+share/doc/pgsql/postgres/app-pgadmin.htm
+share/doc/pgsql/postgres/app-pgctl.htm
+share/doc/pgsql/postgres/app-pgdump.htm
+share/doc/pgsql/postgres/app-pgdumpall.htm
+share/doc/pgsql/postgres/app-pgtclsh.htm
+share/doc/pgsql/postgres/app-pgtksh.htm
+share/doc/pgsql/postgres/app-postgres.htm
+share/doc/pgsql/postgres/app-postmaster.htm
+share/doc/pgsql/postgres/app-psql.htm
+share/doc/pgsql/postgres/app-vacuumdb.htm
+share/doc/pgsql/postgres/applications.htm
+share/doc/pgsql/postgres/arch-pg.htm
+share/doc/pgsql/postgres/arch.htm
+share/doc/pgsql/postgres/arrays.htm
+share/doc/pgsql/postgres/biblio.htm
+share/doc/pgsql/postgres/bki.htm
+share/doc/pgsql/postgres/bki26573.htm
+share/doc/pgsql/postgres/bki26657.htm
+share/doc/pgsql/postgres/bki26681.htm
+share/doc/pgsql/postgres/bki26742.htm
+share/doc/pgsql/postgres/c16883.htm
+share/doc/pgsql/postgres/c1688316912.htm
+share/doc/pgsql/postgres/c1688316990.htm
+share/doc/pgsql/postgres/c1688317027.htm
+share/doc/pgsql/postgres/c19986.htm
+share/doc/pgsql/postgres/c21722.htm
+share/doc/pgsql/postgres/c2172221764.htm
+share/doc/pgsql/postgres/c2172221782.htm
+share/doc/pgsql/postgres/c2172221924.htm
+share/doc/pgsql/postgres/c2172221936.htm
+share/doc/pgsql/postgres/c2172221956.htm
+share/doc/pgsql/postgres/c2172221961.htm
+share/doc/pgsql/postgres/c25129.htm
+share/doc/pgsql/postgres/c4091.htm
+share/doc/pgsql/postgres/c40914117.htm
+share/doc/pgsql/postgres/c40914344.htm
+share/doc/pgsql/postgres/c4362.htm
+share/doc/pgsql/postgres/c43624375.htm
+share/doc/pgsql/postgres/c4888.htm
+share/doc/pgsql/postgres/c4933.htm
+share/doc/pgsql/postgres/c49334943.htm
+share/doc/pgsql/postgres/c49334947.htm
+share/doc/pgsql/postgres/catalogs.gif
+share/doc/pgsql/postgres/clientserver.gif
+share/doc/pgsql/postgres/compiler.htm
+share/doc/pgsql/postgres/connections.gif
+share/doc/pgsql/postgres/copyright.htm
+share/doc/pgsql/postgres/cvs.htm
+share/doc/pgsql/postgres/cvs28436.htm
+share/doc/pgsql/postgres/cvs28492.htm
+share/doc/pgsql/postgres/datatype.htm
+share/doc/pgsql/postgres/datatype1038.htm
+share/doc/pgsql/postgres/datatype1070.htm
+share/doc/pgsql/postgres/datatype1134.htm
+share/doc/pgsql/postgres/datatype1649.htm
+share/doc/pgsql/postgres/datatype1681.htm
+share/doc/pgsql/postgres/datatype1920.htm
+share/doc/pgsql/postgres/datetime-appendix.htm
+share/doc/pgsql/postgres/datetime-appendix28356.htm
+share/doc/pgsql/postgres/dfunc.htm
+share/doc/pgsql/postgres/dfunc20136.htm
+share/doc/pgsql/postgres/dfunc20146.htm
+share/doc/pgsql/postgres/disk.htm
+share/doc/pgsql/postgres/docguide.htm
+share/doc/pgsql/postgres/docguide28718.htm
+share/doc/pgsql/postgres/docguide28749.htm
+share/doc/pgsql/postgres/docguide28840.htm
+share/doc/pgsql/postgres/docguide28861.htm
+share/doc/pgsql/postgres/docguide28887.htm
+share/doc/pgsql/postgres/docguide29024.htm
+share/doc/pgsql/postgres/docguide29362.htm
+share/doc/pgsql/postgres/environ.htm
+share/doc/pgsql/postgres/extend.htm
+share/doc/pgsql/postgres/extend18852.htm
+share/doc/pgsql/postgres/extend18864.htm
+share/doc/pgsql/postgres/func-ref.htm
+share/doc/pgsql/postgres/functions.htm
+share/doc/pgsql/postgres/functions2593.htm
+share/doc/pgsql/postgres/functions2733.htm
+share/doc/pgsql/postgres/functions2876.htm
+share/doc/pgsql/postgres/functions2976.htm
+share/doc/pgsql/postgres/functions3443.htm
+share/doc/pgsql/postgres/functions3641.htm
+share/doc/pgsql/postgres/geqo-biblio.htm
+share/doc/pgsql/postgres/geqo.htm
+share/doc/pgsql/postgres/geqo25594.htm
+share/doc/pgsql/postgres/geqo25617.htm
+share/doc/pgsql/postgres/geqo25655.htm
+share/doc/pgsql/postgres/gist.htm
+share/doc/pgsql/postgres/index.html
+share/doc/pgsql/postgres/indices.htm
+share/doc/pgsql/postgres/inherit.htm
+share/doc/pgsql/postgres/install-win32.htm
+share/doc/pgsql/postgres/install-win3217383.htm
+share/doc/pgsql/postgres/install-win3217392.htm
+share/doc/pgsql/postgres/install.htm
+share/doc/pgsql/postgres/install17165.htm
+share/doc/pgsql/postgres/intro.htm
+share/doc/pgsql/postgres/intro176.htm
+share/doc/pgsql/postgres/intro304.htm
+share/doc/pgsql/postgres/intro60.htm
+share/doc/pgsql/postgres/jdbc.htm
+share/doc/pgsql/postgres/jdbc24909.htm
+share/doc/pgsql/postgres/jdbc24921.htm
+share/doc/pgsql/postgres/jdbc24927.htm
+share/doc/pgsql/postgres/jdbc24935.htm
+share/doc/pgsql/postgres/jdbc24953.htm
+share/doc/pgsql/postgres/jdbc24990.htm
+share/doc/pgsql/postgres/jdbc25021.htm
+share/doc/pgsql/postgres/jdbc25026.htm
+share/doc/pgsql/postgres/jdbc25030.htm
+share/doc/pgsql/postgres/jdbc25056.htm
+share/doc/pgsql/postgres/jdbc25086.htm
+share/doc/pgsql/postgres/largeobjects.htm
+share/doc/pgsql/postgres/largeobjects21625.htm
+share/doc/pgsql/postgres/largeobjects21628.htm
+share/doc/pgsql/postgres/largeobjects21707.htm
+share/doc/pgsql/postgres/largeobjects21714.htm
+share/doc/pgsql/postgres/largeobjects21718.htm
+share/doc/pgsql/postgres/layout.gif
+share/doc/pgsql/postgres/layout.htm
+share/doc/pgsql/postgres/libpq-chapter.htm
+share/doc/pgsql/postgres/libpq-chapter22422.htm
+share/doc/pgsql/postgres/libpq-chapter22577.htm
+share/doc/pgsql/postgres/libpq-chapter22724.htm
+share/doc/pgsql/postgres/libpq-chapter22736.htm
+share/doc/pgsql/postgres/libpq-chapter22774.htm
+share/doc/pgsql/postgres/libpq-chapter22844.htm
+share/doc/pgsql/postgres/libpq-chapter22857.htm
+share/doc/pgsql/postgres/libpq-chapter22942.htm
+share/doc/pgsql/postgres/libpq-envars.htm
+share/doc/pgsql/postgres/libpq-threading.htm
+share/doc/pgsql/postgres/libpqplusplus.htm
+share/doc/pgsql/postgres/libpqplusplus23034.htm
+share/doc/pgsql/postgres/libpqplusplus23044.htm
+share/doc/pgsql/postgres/libpqplusplus23074.htm
+share/doc/pgsql/postgres/libpqplusplus23179.htm
+share/doc/pgsql/postgres/libpqplusplus23202.htm
+share/doc/pgsql/postgres/lisp.htm
+share/doc/pgsql/postgres/manage-ag.htm
+share/doc/pgsql/postgres/manage-ag17914.htm
+share/doc/pgsql/postgres/manage-ag17956.htm
+share/doc/pgsql/postgres/manage-ag17965.htm
+share/doc/pgsql/postgres/manage.htm
+share/doc/pgsql/postgres/manage4814.htm
+share/doc/pgsql/postgres/manage4838.htm
+share/doc/pgsql/postgres/manage4880.htm
+share/doc/pgsql/postgres/mvcc.htm
+share/doc/pgsql/postgres/mvcc4568.htm
+share/doc/pgsql/postgres/mvcc4621.htm
+share/doc/pgsql/postgres/mvcc4633.htm
+share/doc/pgsql/postgres/mvcc4646.htm
+share/doc/pgsql/postgres/mvcc4723.htm
+share/doc/pgsql/postgres/mvcc4744.htm
+share/doc/pgsql/postgres/newuser.htm
+share/doc/pgsql/postgres/notation.htm
+share/doc/pgsql/postgres/odbc.htm
+share/doc/pgsql/postgres/odbc24433.htm
+share/doc/pgsql/postgres/odbc24471.htm
+share/doc/pgsql/postgres/odbc24644.htm
+share/doc/pgsql/postgres/odbc24666.htm
+share/doc/pgsql/postgres/operators.htm
+share/doc/pgsql/postgres/operators2127.htm
+share/doc/pgsql/postgres/operators2198.htm
+share/doc/pgsql/postgres/operators2267.htm
+share/doc/pgsql/postgres/operators2377.htm
+share/doc/pgsql/postgres/operators2436.htm
+share/doc/pgsql/postgres/operators2490.htm
+share/doc/pgsql/postgres/overview.htm
+share/doc/pgsql/postgres/overview25194.htm
+share/doc/pgsql/postgres/overview25219.htm
+share/doc/pgsql/postgres/overview25347.htm
+share/doc/pgsql/postgres/overview25403.htm
+share/doc/pgsql/postgres/overview25457.htm
+share/doc/pgsql/postgres/page.htm
+share/doc/pgsql/postgres/page26805.htm
+share/doc/pgsql/postgres/page26819.htm
+share/doc/pgsql/postgres/part-admin.htm
+share/doc/pgsql/postgres/part-appendix.htm
+share/doc/pgsql/postgres/part-developer.htm
+share/doc/pgsql/postgres/part-interfaces.htm
+share/doc/pgsql/postgres/part-programmer.htm
+share/doc/pgsql/postgres/part-tutorial.htm
+share/doc/pgsql/postgres/part-user.htm
+share/doc/pgsql/postgres/partial-index.htm
+share/doc/pgsql/postgres/pg-options-dev.htm
+share/doc/pgsql/postgres/pg-options.htm
+share/doc/pgsql/postgres/pgeasy-chapter.htm
+share/doc/pgsql/postgres/pgtcl-pgconndefaults.htm
+share/doc/pgsql/postgres/pgtcl-pgconnect.htm
+share/doc/pgsql/postgres/pgtcl-pgdisconnect.htm
+share/doc/pgsql/postgres/pgtcl-pgexec.htm
+share/doc/pgsql/postgres/pgtcl-pglisten.htm
+share/doc/pgsql/postgres/pgtcl-pgloclose.htm
+share/doc/pgsql/postgres/pgtcl-pglocreat.htm
+share/doc/pgsql/postgres/pgtcl-pgloexport.htm
+share/doc/pgsql/postgres/pgtcl-pgloimport.htm
+share/doc/pgsql/postgres/pgtcl-pglolseek.htm
+share/doc/pgsql/postgres/pgtcl-pgloopen.htm
+share/doc/pgsql/postgres/pgtcl-pgloread.htm
+share/doc/pgsql/postgres/pgtcl-pglotell.htm
+share/doc/pgsql/postgres/pgtcl-pglounlink.htm
+share/doc/pgsql/postgres/pgtcl-pglowrite.htm
+share/doc/pgsql/postgres/pgtcl-pgresult.htm
+share/doc/pgsql/postgres/pgtcl-pgselect.htm
+share/doc/pgsql/postgres/pgtcl.htm
+share/doc/pgsql/postgres/pgtcl23317.htm
+share/doc/pgsql/postgres/pgtcl23321.htm
+share/doc/pgsql/postgres/pl-perl.htm
+share/doc/pgsql/postgres/pl-perl4533.htm
+share/doc/pgsql/postgres/pl-perl4542.htm
+share/doc/pgsql/postgres/ports.htm
+share/doc/pgsql/postgres/ports16791.htm
+share/doc/pgsql/postgres/postgres.htm
+share/doc/pgsql/postgres/postgres.html
+share/doc/pgsql/postgres/postmaster.htm
+share/doc/pgsql/postgres/preface.htm
+share/doc/pgsql/postgres/protocol.htm
+share/doc/pgsql/postgres/protocol25770.htm
+share/doc/pgsql/postgres/protocol25925.htm
+share/doc/pgsql/postgres/protocol25962.htm
+share/doc/pgsql/postgres/query.htm
+share/doc/pgsql/postgres/query27752.htm
+share/doc/pgsql/postgres/query27768.htm
+share/doc/pgsql/postgres/query27790.htm
+share/doc/pgsql/postgres/query27799.htm
+share/doc/pgsql/postgres/query27817.htm
+share/doc/pgsql/postgres/query27825.htm
+share/doc/pgsql/postgres/query27844.htm
+share/doc/pgsql/postgres/query27849.htm
+share/doc/pgsql/postgres/query27856.htm
+share/doc/pgsql/postgres/recovery.htm
+share/doc/pgsql/postgres/regress.htm
+share/doc/pgsql/postgres/regress18171.htm
+share/doc/pgsql/postgres/regress18205.htm
+share/doc/pgsql/postgres/regress18251.htm
+share/doc/pgsql/postgres/release.htm
+share/doc/pgsql/postgres/release18319.htm
+share/doc/pgsql/postgres/release18330.htm
+share/doc/pgsql/postgres/release18341.htm
+share/doc/pgsql/postgres/release18352.htm
+share/doc/pgsql/postgres/release18434.htm
+share/doc/pgsql/postgres/release18445.htm
+share/doc/pgsql/postgres/release18456.htm
+share/doc/pgsql/postgres/release18497.htm
+share/doc/pgsql/postgres/release18513.htm
+share/doc/pgsql/postgres/release18532.htm
+share/doc/pgsql/postgres/release18576.htm
+share/doc/pgsql/postgres/release18598.htm
+share/doc/pgsql/postgres/release18613.htm
+share/doc/pgsql/postgres/release18622.htm
+share/doc/pgsql/postgres/release18645.htm
+share/doc/pgsql/postgres/release18659.htm
+share/doc/pgsql/postgres/release18662.htm
+share/doc/pgsql/postgres/release18687.htm
+share/doc/pgsql/postgres/release18724.htm
+share/doc/pgsql/postgres/release18731.htm
+share/doc/pgsql/postgres/release18738.htm
+share/doc/pgsql/postgres/release18745.htm
+share/doc/pgsql/postgres/release18749.htm
+share/doc/pgsql/postgres/rules.htm
+share/doc/pgsql/postgres/rules19478.htm
+share/doc/pgsql/postgres/rules19639.htm
+share/doc/pgsql/postgres/rules19770.htm
+share/doc/pgsql/postgres/rules19784.htm
+share/doc/pgsql/postgres/runtime.htm
+share/doc/pgsql/postgres/security.htm
+share/doc/pgsql/postgres/security17760.htm
+share/doc/pgsql/postgres/security17795.htm
+share/doc/pgsql/postgres/security17819.htm
+share/doc/pgsql/postgres/security17840.htm
+share/doc/pgsql/postgres/signals.htm
+share/doc/pgsql/postgres/spi-spiconnect.htm
+share/doc/pgsql/postgres/spi-spicopytuple.htm
+share/doc/pgsql/postgres/spi-spiexec.htm
+share/doc/pgsql/postgres/spi-spiexecp.htm
+share/doc/pgsql/postgres/spi-spifinish.htm
+share/doc/pgsql/postgres/spi-spifname.htm
+share/doc/pgsql/postgres/spi-spifnumber.htm
+share/doc/pgsql/postgres/spi-spigetbinval.htm
+share/doc/pgsql/postgres/spi-spigetrelname.htm
+share/doc/pgsql/postgres/spi-spigettype.htm
+share/doc/pgsql/postgres/spi-spigettypeid.htm
+share/doc/pgsql/postgres/spi-spigetvalue.htm
+share/doc/pgsql/postgres/spi-spimodifytuple.htm
+share/doc/pgsql/postgres/spi-spipalloc.htm
+share/doc/pgsql/postgres/spi-spipfree.htm
+share/doc/pgsql/postgres/spi-spiprepare.htm
+share/doc/pgsql/postgres/spi-spirepalloc.htm
+share/doc/pgsql/postgres/spi-spisaveplan.htm
+share/doc/pgsql/postgres/spi.htm
+share/doc/pgsql/postgres/spi20808.htm
+share/doc/pgsql/postgres/spi21521.htm
+share/doc/pgsql/postgres/spi21543.htm
+share/doc/pgsql/postgres/spi21548.htm
+share/doc/pgsql/postgres/sql-abort.htm
+share/doc/pgsql/postgres/sql-altergroup.htm
+share/doc/pgsql/postgres/sql-altertable.htm
+share/doc/pgsql/postgres/sql-alteruser.htm
+share/doc/pgsql/postgres/sql-begin.htm
+share/doc/pgsql/postgres/sql-close.htm
+share/doc/pgsql/postgres/sql-cluster.htm
+share/doc/pgsql/postgres/sql-commands.htm
+share/doc/pgsql/postgres/sql-comment.htm
+share/doc/pgsql/postgres/sql-commit.htm
+share/doc/pgsql/postgres/sql-copy.htm
+share/doc/pgsql/postgres/sql-createaggregate.htm
+share/doc/pgsql/postgres/sql-createconstraint.htm
+share/doc/pgsql/postgres/sql-createdatabase.htm
+share/doc/pgsql/postgres/sql-createfunction.htm
+share/doc/pgsql/postgres/sql-creategroup.htm
+share/doc/pgsql/postgres/sql-createindex.htm
+share/doc/pgsql/postgres/sql-createlanguage.htm
+share/doc/pgsql/postgres/sql-createoperator.htm
+share/doc/pgsql/postgres/sql-createrule.htm
+share/doc/pgsql/postgres/sql-createsequence.htm
+share/doc/pgsql/postgres/sql-createtable.htm
+share/doc/pgsql/postgres/sql-createtableas.htm
+share/doc/pgsql/postgres/sql-createtrigger.htm
+share/doc/pgsql/postgres/sql-createtype.htm
+share/doc/pgsql/postgres/sql-createuser.htm
+share/doc/pgsql/postgres/sql-createview.htm
+share/doc/pgsql/postgres/sql-declare.htm
+share/doc/pgsql/postgres/sql-delete.htm
+share/doc/pgsql/postgres/sql-dropaggregate.htm
+share/doc/pgsql/postgres/sql-dropdatabase.htm
+share/doc/pgsql/postgres/sql-dropfunction.htm
+share/doc/pgsql/postgres/sql-dropgroup.htm
+share/doc/pgsql/postgres/sql-dropindex.htm
+share/doc/pgsql/postgres/sql-droplanguage.htm
+share/doc/pgsql/postgres/sql-dropoperator.htm
+share/doc/pgsql/postgres/sql-droprule.htm
+share/doc/pgsql/postgres/sql-dropsequence.htm
+share/doc/pgsql/postgres/sql-droptable.htm
+share/doc/pgsql/postgres/sql-droptrigger.htm
+share/doc/pgsql/postgres/sql-droptype.htm
+share/doc/pgsql/postgres/sql-dropuser.htm
+share/doc/pgsql/postgres/sql-dropview.htm
+share/doc/pgsql/postgres/sql-end.htm
+share/doc/pgsql/postgres/sql-explain.htm
+share/doc/pgsql/postgres/sql-fetch.htm
+share/doc/pgsql/postgres/sql-grant.htm
+share/doc/pgsql/postgres/sql-insert.htm
+share/doc/pgsql/postgres/sql-language.htm
+share/doc/pgsql/postgres/sql-listen.htm
+share/doc/pgsql/postgres/sql-load.htm
+share/doc/pgsql/postgres/sql-lock.htm
+share/doc/pgsql/postgres/sql-move.htm
+share/doc/pgsql/postgres/sql-notify.htm
+share/doc/pgsql/postgres/sql-reindex.htm
+share/doc/pgsql/postgres/sql-reset.htm
+share/doc/pgsql/postgres/sql-revoke.htm
+share/doc/pgsql/postgres/sql-rollback.htm
+share/doc/pgsql/postgres/sql-select.htm
+share/doc/pgsql/postgres/sql-selectinto.htm
+share/doc/pgsql/postgres/sql-set.htm
+share/doc/pgsql/postgres/sql-show.htm
+share/doc/pgsql/postgres/sql-truncate.htm
+share/doc/pgsql/postgres/sql-unlisten.htm
+share/doc/pgsql/postgres/sql-update.htm
+share/doc/pgsql/postgres/sql-vacuum.htm
+share/doc/pgsql/postgres/sql.htm
+share/doc/pgsql/postgres/sql26902.htm
+share/doc/pgsql/postgres/sql27020.htm
+share/doc/pgsql/postgres/start.htm
+share/doc/pgsql/postgres/start27628.htm
+share/doc/pgsql/postgres/start27650.htm
+share/doc/pgsql/postgres/storage.htm
+share/doc/pgsql/postgres/syntax.htm
+share/doc/pgsql/postgres/syntax519.htm
+share/doc/pgsql/postgres/syntax525.htm
+share/doc/pgsql/postgres/syntax543.htm
+share/doc/pgsql/postgres/syntax608.htm
+share/doc/pgsql/postgres/syntax653.htm
+share/doc/pgsql/postgres/syntax658.htm
+share/doc/pgsql/postgres/terminology.htm
+share/doc/pgsql/postgres/triggers.htm
+share/doc/pgsql/postgres/triggers20224.htm
+share/doc/pgsql/postgres/triggers20281.htm
+share/doc/pgsql/postgres/triggers20290.htm
+share/doc/pgsql/postgres/trouble.htm
+share/doc/pgsql/postgres/trouble18031.htm
+share/doc/pgsql/postgres/trouble18048.htm
+share/doc/pgsql/postgres/typeconv.htm
+share/doc/pgsql/postgres/typeconv3759.htm
+share/doc/pgsql/postgres/typeconv3822.htm
+share/doc/pgsql/postgres/typeconv3875.htm
+share/doc/pgsql/postgres/typeconv3895.htm
+share/doc/pgsql/postgres/utilities.htm
+share/doc/pgsql/postgres/xaggr.htm
+share/doc/pgsql/postgres/xfunc.htm
+share/doc/pgsql/postgres/xfunc19011.htm
+share/doc/pgsql/postgres/xfunc19017.htm
+share/doc/pgsql/postgres/xfunc19022.htm
+share/doc/pgsql/postgres/xfunc19254.htm
+share/doc/pgsql/postgres/xindex.htm
+share/doc/pgsql/postgres/xoper.htm
+share/doc/pgsql/postgres/xplang.htm
+share/doc/pgsql/postgres/xtypes.htm
+share/doc/pgsql/postgres/y2k.htm
+share/doc/pgsql/programmer/arch-pg.htm
+share/doc/pgsql/programmer/biblio.htm
+share/doc/pgsql/programmer/bki.htm
+share/doc/pgsql/programmer/bki8058.htm
+share/doc/pgsql/programmer/bki8142.htm
+share/doc/pgsql/programmer/bki8166.htm
+share/doc/pgsql/programmer/bki8227.htm
+share/doc/pgsql/programmer/c1486.htm
+share/doc/pgsql/programmer/c5391.htm
+share/doc/pgsql/programmer/c53915433.htm
+share/doc/pgsql/programmer/c53915451.htm
+share/doc/pgsql/programmer/c53915593.htm
+share/doc/pgsql/programmer/c53915605.htm
+share/doc/pgsql/programmer/c53915625.htm
+share/doc/pgsql/programmer/c53915630.htm
+share/doc/pgsql/programmer/c6614.htm
+share/doc/pgsql/programmer/catalogs.gif
+share/doc/pgsql/programmer/compiler.htm
+share/doc/pgsql/programmer/connections.gif
+share/doc/pgsql/programmer/copyright.htm
+share/doc/pgsql/programmer/cvs.htm
+share/doc/pgsql/programmer/cvs8365.htm
+share/doc/pgsql/programmer/cvs8421.htm
+share/doc/pgsql/programmer/dfunc.htm
+share/doc/pgsql/programmer/dfunc1679.htm
+share/doc/pgsql/programmer/dfunc1689.htm
+share/doc/pgsql/programmer/docguide.htm
+share/doc/pgsql/programmer/docguide8647.htm
+share/doc/pgsql/programmer/docguide8678.htm
+share/doc/pgsql/programmer/docguide8769.htm
+share/doc/pgsql/programmer/docguide8790.htm
+share/doc/pgsql/programmer/docguide8816.htm
+share/doc/pgsql/programmer/docguide8953.htm
+share/doc/pgsql/programmer/docguide9291.htm
+share/doc/pgsql/programmer/extend.htm
+share/doc/pgsql/programmer/extend352.htm
+share/doc/pgsql/programmer/extend364.htm
+share/doc/pgsql/programmer/geqo-biblio.htm
+share/doc/pgsql/programmer/geqo.htm
+share/doc/pgsql/programmer/geqo7079.htm
+share/doc/pgsql/programmer/geqo7102.htm
+share/doc/pgsql/programmer/geqo7140.htm
+share/doc/pgsql/programmer/gist.htm
+share/doc/pgsql/programmer/index.html
+share/doc/pgsql/programmer/intro-pg.htm
+share/doc/pgsql/programmer/intro-pg167.htm
+share/doc/pgsql/programmer/jdbc.htm
+share/doc/pgsql/programmer/jdbc6398.htm
+share/doc/pgsql/programmer/jdbc6410.htm
+share/doc/pgsql/programmer/jdbc6416.htm
+share/doc/pgsql/programmer/jdbc6424.htm
+share/doc/pgsql/programmer/jdbc6442.htm
+share/doc/pgsql/programmer/jdbc6479.htm
+share/doc/pgsql/programmer/jdbc6510.htm
+share/doc/pgsql/programmer/jdbc6515.htm
+share/doc/pgsql/programmer/jdbc6519.htm
+share/doc/pgsql/programmer/jdbc6545.htm
+share/doc/pgsql/programmer/jdbc6575.htm
+share/doc/pgsql/programmer/largeobjects.htm
+share/doc/pgsql/programmer/largeobjects3114.htm
+share/doc/pgsql/programmer/largeobjects3117.htm
+share/doc/pgsql/programmer/largeobjects3196.htm
+share/doc/pgsql/programmer/largeobjects3203.htm
+share/doc/pgsql/programmer/largeobjects3207.htm
+share/doc/pgsql/programmer/libpq-chapter.htm
+share/doc/pgsql/programmer/libpq-chapter3419.htm
+share/doc/pgsql/programmer/libpq-chapter3574.htm
+share/doc/pgsql/programmer/libpq-chapter3721.htm
+share/doc/pgsql/programmer/libpq-chapter3733.htm
+share/doc/pgsql/programmer/libpq-chapter3771.htm
+share/doc/pgsql/programmer/libpq-chapter3841.htm
+share/doc/pgsql/programmer/libpq-chapter3854.htm
+share/doc/pgsql/programmer/libpq-chapter3939.htm
+share/doc/pgsql/programmer/libpq-envars.htm
+share/doc/pgsql/programmer/libpq-threading.htm
+share/doc/pgsql/programmer/libpqplusplus.htm
+share/doc/pgsql/programmer/libpqplusplus4031.htm
+share/doc/pgsql/programmer/libpqplusplus4041.htm
+share/doc/pgsql/programmer/libpqplusplus4071.htm
+share/doc/pgsql/programmer/libpqplusplus4176.htm
+share/doc/pgsql/programmer/libpqplusplus4199.htm
+share/doc/pgsql/programmer/lisp.htm
+share/doc/pgsql/programmer/notation.htm
+share/doc/pgsql/programmer/odbc.htm
+share/doc/pgsql/programmer/odbc5922.htm
+share/doc/pgsql/programmer/odbc5960.htm
+share/doc/pgsql/programmer/odbc6133.htm
+share/doc/pgsql/programmer/odbc6155.htm
+share/doc/pgsql/programmer/overview.htm
+share/doc/pgsql/programmer/overview6679.htm
+share/doc/pgsql/programmer/overview6704.htm
+share/doc/pgsql/programmer/overview6832.htm
+share/doc/pgsql/programmer/overview6888.htm
+share/doc/pgsql/programmer/overview6942.htm
+share/doc/pgsql/programmer/page.htm
+share/doc/pgsql/programmer/page8290.htm
+share/doc/pgsql/programmer/page8304.htm
+share/doc/pgsql/programmer/pg-options-dev.htm
+share/doc/pgsql/programmer/pgeasy-chapter.htm
+share/doc/pgsql/programmer/pgtcl-pgconndefaults.htm
+share/doc/pgsql/programmer/pgtcl-pgconnect.htm
+share/doc/pgsql/programmer/pgtcl-pgdisconnect.htm
+share/doc/pgsql/programmer/pgtcl-pgexec.htm
+share/doc/pgsql/programmer/pgtcl-pglisten.htm
+share/doc/pgsql/programmer/pgtcl-pgloclose.htm
+share/doc/pgsql/programmer/pgtcl-pglocreat.htm
+share/doc/pgsql/programmer/pgtcl-pgloexport.htm
+share/doc/pgsql/programmer/pgtcl-pgloimport.htm
+share/doc/pgsql/programmer/pgtcl-pglolseek.htm
+share/doc/pgsql/programmer/pgtcl-pgloopen.htm
+share/doc/pgsql/programmer/pgtcl-pgloread.htm
+share/doc/pgsql/programmer/pgtcl-pglotell.htm
+share/doc/pgsql/programmer/pgtcl-pglounlink.htm
+share/doc/pgsql/programmer/pgtcl-pglowrite.htm
+share/doc/pgsql/programmer/pgtcl-pgresult.htm
+share/doc/pgsql/programmer/pgtcl-pgselect.htm
+share/doc/pgsql/programmer/pgtcl.htm
+share/doc/pgsql/programmer/pgtcl4314.htm
+share/doc/pgsql/programmer/pgtcl4318.htm
+share/doc/pgsql/programmer/preface.htm
+share/doc/pgsql/programmer/programmer.htm
+share/doc/pgsql/programmer/programmer.html
+share/doc/pgsql/programmer/protocol.htm
+share/doc/pgsql/programmer/protocol7255.htm
+share/doc/pgsql/programmer/protocol7410.htm
+share/doc/pgsql/programmer/protocol7447.htm
+share/doc/pgsql/programmer/rules.htm
+share/doc/pgsql/programmer/rules1139.htm
+share/doc/pgsql/programmer/rules1270.htm
+share/doc/pgsql/programmer/rules1284.htm
+share/doc/pgsql/programmer/rules978.htm
+share/doc/pgsql/programmer/signals.htm
+share/doc/pgsql/programmer/spi-spiconnect.htm
+share/doc/pgsql/programmer/spi-spicopytuple.htm
+share/doc/pgsql/programmer/spi-spiexec.htm
+share/doc/pgsql/programmer/spi-spiexecp.htm
+share/doc/pgsql/programmer/spi-spifinish.htm
+share/doc/pgsql/programmer/spi-spifname.htm
+share/doc/pgsql/programmer/spi-spifnumber.htm
+share/doc/pgsql/programmer/spi-spigetbinval.htm
+share/doc/pgsql/programmer/spi-spigetrelname.htm
+share/doc/pgsql/programmer/spi-spigettype.htm
+share/doc/pgsql/programmer/spi-spigettypeid.htm
+share/doc/pgsql/programmer/spi-spigetvalue.htm
+share/doc/pgsql/programmer/spi-spimodifytuple.htm
+share/doc/pgsql/programmer/spi-spipalloc.htm
+share/doc/pgsql/programmer/spi-spipfree.htm
+share/doc/pgsql/programmer/spi-spiprepare.htm
+share/doc/pgsql/programmer/spi-spirepalloc.htm
+share/doc/pgsql/programmer/spi-spisaveplan.htm
+share/doc/pgsql/programmer/spi.htm
+share/doc/pgsql/programmer/spi2351.htm
+share/doc/pgsql/programmer/spi3064.htm
+share/doc/pgsql/programmer/spi3086.htm
+share/doc/pgsql/programmer/spi3091.htm
+share/doc/pgsql/programmer/terminology.htm
+share/doc/pgsql/programmer/triggers.htm
+share/doc/pgsql/programmer/triggers1767.htm
+share/doc/pgsql/programmer/triggers1824.htm
+share/doc/pgsql/programmer/triggers1833.htm
+share/doc/pgsql/programmer/xaggr.htm
+share/doc/pgsql/programmer/xfunc.htm
+share/doc/pgsql/programmer/xfunc511.htm
+share/doc/pgsql/programmer/xfunc517.htm
+share/doc/pgsql/programmer/xfunc522.htm
+share/doc/pgsql/programmer/xfunc754.htm
+share/doc/pgsql/programmer/xindex.htm
+share/doc/pgsql/programmer/xoper.htm
+share/doc/pgsql/programmer/xplang.htm
+share/doc/pgsql/programmer/xtypes.htm
+share/doc/pgsql/programmer/y2k.htm
+share/doc/pgsql/tutorial/about.htm
+share/doc/pgsql/tutorial/advanced.htm
+share/doc/pgsql/tutorial/advanced1511.htm
+share/doc/pgsql/tutorial/advanced1533.htm
+share/doc/pgsql/tutorial/arch.htm
+share/doc/pgsql/tutorial/biblio.htm
+share/doc/pgsql/tutorial/clientserver.gif
+share/doc/pgsql/tutorial/copyright.htm
+share/doc/pgsql/tutorial/f17.htm
+share/doc/pgsql/tutorial/index.html
+share/doc/pgsql/tutorial/intro.htm
+share/doc/pgsql/tutorial/intro172.htm
+share/doc/pgsql/tutorial/intro300.htm
+share/doc/pgsql/tutorial/intro56.htm
+share/doc/pgsql/tutorial/notation.htm
+share/doc/pgsql/tutorial/query.htm
+share/doc/pgsql/tutorial/query1340.htm
+share/doc/pgsql/tutorial/query1356.htm
+share/doc/pgsql/tutorial/query1378.htm
+share/doc/pgsql/tutorial/query1387.htm
+share/doc/pgsql/tutorial/query1405.htm
+share/doc/pgsql/tutorial/query1413.htm
+share/doc/pgsql/tutorial/query1432.htm
+share/doc/pgsql/tutorial/query1437.htm
+share/doc/pgsql/tutorial/query1444.htm
+share/doc/pgsql/tutorial/sql-language.htm
+share/doc/pgsql/tutorial/sql.htm
+share/doc/pgsql/tutorial/sql490.htm
+share/doc/pgsql/tutorial/sql608.htm
+share/doc/pgsql/tutorial/start.htm
+share/doc/pgsql/tutorial/start1216.htm
+share/doc/pgsql/tutorial/start1238.htm
+share/doc/pgsql/tutorial/terminology.htm
+share/doc/pgsql/tutorial/tutorial.htm
+share/doc/pgsql/tutorial/tutorial.html
+share/doc/pgsql/tutorial/y2k.htm
+share/doc/pgsql/user/about.htm
+share/doc/pgsql/user/app-createdb.htm
+share/doc/pgsql/user/app-createlang.htm
+share/doc/pgsql/user/app-createuser.htm
+share/doc/pgsql/user/app-dropdb.htm
+share/doc/pgsql/user/app-droplang.htm
+share/doc/pgsql/user/app-dropuser.htm
+share/doc/pgsql/user/app-ecpg.htm
+share/doc/pgsql/user/app-initdb.htm
+share/doc/pgsql/user/app-initlocation.htm
+share/doc/pgsql/user/app-ipcclean.htm
+share/doc/pgsql/user/app-pg-passwd.htm
+share/doc/pgsql/user/app-pg-upgrade.htm
+share/doc/pgsql/user/app-pgaccess.htm
+share/doc/pgsql/user/app-pgadmin.htm
+share/doc/pgsql/user/app-pgctl.htm
+share/doc/pgsql/user/app-pgdump.htm
+share/doc/pgsql/user/app-pgdumpall.htm
+share/doc/pgsql/user/app-pgtclsh.htm
+share/doc/pgsql/user/app-pgtksh.htm
+share/doc/pgsql/user/app-postgres.htm
+share/doc/pgsql/user/app-postmaster.htm
+share/doc/pgsql/user/app-psql.htm
+share/doc/pgsql/user/app-vacuumdb.htm
+share/doc/pgsql/user/applications.htm
+share/doc/pgsql/user/arrays.htm
+share/doc/pgsql/user/biblio.htm
+share/doc/pgsql/user/c4087.htm
+share/doc/pgsql/user/c40874113.htm
+share/doc/pgsql/user/c40874340.htm
+share/doc/pgsql/user/c4358.htm
+share/doc/pgsql/user/c43584371.htm
+share/doc/pgsql/user/c4884.htm
+share/doc/pgsql/user/c4929.htm
+share/doc/pgsql/user/c49294939.htm
+share/doc/pgsql/user/c49294943.htm
+share/doc/pgsql/user/copyright.htm
+share/doc/pgsql/user/datatype.htm
+share/doc/pgsql/user/datatype1034.htm
+share/doc/pgsql/user/datatype1066.htm
+share/doc/pgsql/user/datatype1130.htm
+share/doc/pgsql/user/datatype1645.htm
+share/doc/pgsql/user/datatype1677.htm
+share/doc/pgsql/user/datatype1916.htm
+share/doc/pgsql/user/datetime-appendix.htm
+share/doc/pgsql/user/datetime-appendix16981.htm
+share/doc/pgsql/user/environ.htm
+share/doc/pgsql/user/functions.htm
+share/doc/pgsql/user/functions2589.htm
+share/doc/pgsql/user/functions2729.htm
+share/doc/pgsql/user/functions2872.htm
+share/doc/pgsql/user/functions2972.htm
+share/doc/pgsql/user/functions3439.htm
+share/doc/pgsql/user/functions3637.htm
+share/doc/pgsql/user/index.html
+share/doc/pgsql/user/indices.htm
+share/doc/pgsql/user/inherit.htm
+share/doc/pgsql/user/intro.htm
+share/doc/pgsql/user/intro172.htm
+share/doc/pgsql/user/intro300.htm
+share/doc/pgsql/user/intro56.htm
+share/doc/pgsql/user/manage.htm
+share/doc/pgsql/user/manage4810.htm
+share/doc/pgsql/user/manage4834.htm
+share/doc/pgsql/user/manage4876.htm
+share/doc/pgsql/user/mvcc.htm
+share/doc/pgsql/user/mvcc4564.htm
+share/doc/pgsql/user/mvcc4617.htm
+share/doc/pgsql/user/mvcc4629.htm
+share/doc/pgsql/user/mvcc4642.htm
+share/doc/pgsql/user/mvcc4719.htm
+share/doc/pgsql/user/mvcc4740.htm
+share/doc/pgsql/user/notation.htm
+share/doc/pgsql/user/operators.htm
+share/doc/pgsql/user/operators2123.htm
+share/doc/pgsql/user/operators2194.htm
+share/doc/pgsql/user/operators2263.htm
+share/doc/pgsql/user/operators2373.htm
+share/doc/pgsql/user/operators2432.htm
+share/doc/pgsql/user/operators2486.htm
+share/doc/pgsql/user/partial-index.htm
+share/doc/pgsql/user/pl-perl.htm
+share/doc/pgsql/user/pl-perl4529.htm
+share/doc/pgsql/user/pl-perl4538.htm
+share/doc/pgsql/user/preface.htm
+share/doc/pgsql/user/sql-abort.htm
+share/doc/pgsql/user/sql-altergroup.htm
+share/doc/pgsql/user/sql-altertable.htm
+share/doc/pgsql/user/sql-alteruser.htm
+share/doc/pgsql/user/sql-begin.htm
+share/doc/pgsql/user/sql-close.htm
+share/doc/pgsql/user/sql-cluster.htm
+share/doc/pgsql/user/sql-commands.htm
+share/doc/pgsql/user/sql-comment.htm
+share/doc/pgsql/user/sql-commit.htm
+share/doc/pgsql/user/sql-copy.htm
+share/doc/pgsql/user/sql-createaggregate.htm
+share/doc/pgsql/user/sql-createconstraint.htm
+share/doc/pgsql/user/sql-createdatabase.htm
+share/doc/pgsql/user/sql-createfunction.htm
+share/doc/pgsql/user/sql-creategroup.htm
+share/doc/pgsql/user/sql-createindex.htm
+share/doc/pgsql/user/sql-createlanguage.htm
+share/doc/pgsql/user/sql-createoperator.htm
+share/doc/pgsql/user/sql-createrule.htm
+share/doc/pgsql/user/sql-createsequence.htm
+share/doc/pgsql/user/sql-createtable.htm
+share/doc/pgsql/user/sql-createtableas.htm
+share/doc/pgsql/user/sql-createtrigger.htm
+share/doc/pgsql/user/sql-createtype.htm
+share/doc/pgsql/user/sql-createuser.htm
+share/doc/pgsql/user/sql-createview.htm
+share/doc/pgsql/user/sql-declare.htm
+share/doc/pgsql/user/sql-delete.htm
+share/doc/pgsql/user/sql-dropaggregate.htm
+share/doc/pgsql/user/sql-dropdatabase.htm
+share/doc/pgsql/user/sql-dropfunction.htm
+share/doc/pgsql/user/sql-dropgroup.htm
+share/doc/pgsql/user/sql-dropindex.htm
+share/doc/pgsql/user/sql-droplanguage.htm
+share/doc/pgsql/user/sql-dropoperator.htm
+share/doc/pgsql/user/sql-droprule.htm
+share/doc/pgsql/user/sql-dropsequence.htm
+share/doc/pgsql/user/sql-droptable.htm
+share/doc/pgsql/user/sql-droptrigger.htm
+share/doc/pgsql/user/sql-droptype.htm
+share/doc/pgsql/user/sql-dropuser.htm
+share/doc/pgsql/user/sql-dropview.htm
+share/doc/pgsql/user/sql-end.htm
+share/doc/pgsql/user/sql-explain.htm
+share/doc/pgsql/user/sql-fetch.htm
+share/doc/pgsql/user/sql-grant.htm
+share/doc/pgsql/user/sql-insert.htm
+share/doc/pgsql/user/sql-listen.htm
+share/doc/pgsql/user/sql-load.htm
+share/doc/pgsql/user/sql-lock.htm
+share/doc/pgsql/user/sql-move.htm
+share/doc/pgsql/user/sql-notify.htm
+share/doc/pgsql/user/sql-reindex.htm
+share/doc/pgsql/user/sql-reset.htm
+share/doc/pgsql/user/sql-revoke.htm
+share/doc/pgsql/user/sql-rollback.htm
+share/doc/pgsql/user/sql-select.htm
+share/doc/pgsql/user/sql-selectinto.htm
+share/doc/pgsql/user/sql-set.htm
+share/doc/pgsql/user/sql-show.htm
+share/doc/pgsql/user/sql-truncate.htm
+share/doc/pgsql/user/sql-unlisten.htm
+share/doc/pgsql/user/sql-update.htm
+share/doc/pgsql/user/sql-vacuum.htm
+share/doc/pgsql/user/storage.htm
+share/doc/pgsql/user/syntax.htm
+share/doc/pgsql/user/syntax515.htm
+share/doc/pgsql/user/syntax521.htm
+share/doc/pgsql/user/syntax539.htm
+share/doc/pgsql/user/syntax604.htm
+share/doc/pgsql/user/syntax649.htm
+share/doc/pgsql/user/syntax654.htm
+share/doc/pgsql/user/terminology.htm
+share/doc/pgsql/user/typeconv.htm
+share/doc/pgsql/user/typeconv3755.htm
+share/doc/pgsql/user/typeconv3818.htm
+share/doc/pgsql/user/typeconv3871.htm
+share/doc/pgsql/user/typeconv3891.htm
+share/doc/pgsql/user/user.htm
+share/doc/pgsql/user/user.html
+share/doc/pgsql/user/utilities.htm
+share/doc/pgsql/user/y2k.htm
+@exec mkdir -p %D/pgsql/include/port/freebsd
+@exec mkdir -p %D/pgsql/data/pg_xlog
+@dirrm share/doc/pgsql/admin
+@dirrm share/doc/pgsql/postgres
+@dirrm share/doc/pgsql/programmer
+@dirrm share/doc/pgsql/tutorial
+@dirrm share/doc/pgsql/user
+@dirrm share/doc/pgsql
+@dirrm pgsql/bin
+@dirrm pgsql/man/manl
+@dirrm pgsql/man/man1
+@dirrm pgsql/man
+@dirrm pgsql/lib
+@dirrm pgsql/include/port/freebsd
+@dirrm pgsql/include/port
+@dirrm pgsql/include/utils
+@dirrm pgsql/include/libpq++
+@dirrm pgsql/include/libpq
+@dirrm pgsql/include/lib
+@dirrm pgsql/include/executor
+@dirrm pgsql/include/commands
+@dirrm pgsql/include/access
+@dirrm pgsql/include
+@unexec rm -fr %D/pgsql 2>/dev/null || true
diff --git a/japanese/postgresql-tcltk/pkg-plist.jdbc b/japanese/postgresql-tcltk/pkg-plist.jdbc
new file mode 100644
index 000000000000..7c59ed439420
--- /dev/null
+++ b/japanese/postgresql-tcltk/pkg-plist.jdbc
@@ -0,0 +1,13 @@
+share/examples/pgsql/jdbc/ImageViewer.java
+share/examples/pgsql/jdbc/basic.java
+share/examples/pgsql/jdbc/blobtest.java
+share/examples/pgsql/jdbc/datestyle.java
+share/examples/pgsql/jdbc/metadata.java
+share/examples/pgsql/jdbc/psql.java
+share/examples/pgsql/jdbc/threadsafe.java
+share/examples/pgsql/jdbc/README
+share/examples/pgsql/jdbc/README_6.3
+@dirrm share/examples/pgsql/jdbc
+@dirrm share/examples/pgsql
+share/java/postgresql.jar
+@unexec rmdir %D/share/java 2>/dev/null || true
diff --git a/japanese/postgresql-tcltk/pkg-plist.odbc b/japanese/postgresql-tcltk/pkg-plist.odbc
index 8cba0e5c977c..c849e26dbc88 100644
--- a/japanese/postgresql-tcltk/pkg-plist.odbc
+++ b/japanese/postgresql-tcltk/pkg-plist.odbc
@@ -1,7 +1,8 @@
-%%INSTALL_DIR%%/lib/libpsqlodbc.a
-%%INSTALL_DIR%%/lib/libpsqlodbc.so
-%%INSTALL_DIR%%/lib/libpsqlodbc.so.0
-%%INSTALL_DIR%%/include/iodbc/iodbc.h
-%%INSTALL_DIR%%/include/iodbc/isql.h
-%%INSTALL_DIR%%/include/iodbc/isqlext.h
-%%INSTALL_DIR%%/odbcinst.ini
+pgsql/include/iodbc/iodbc.h
+pgsql/include/iodbc/isql.h
+pgsql/include/iodbc/isqlext.h
+pgsql/lib/libpsqlodbc.a
+pgsql/lib/libpsqlodbc.so
+pgsql/lib/libpsqlodbc.so.0
+pgsql/odbcinst.ini
+@dirrm pgsql/include/iodbc
diff --git a/japanese/postgresql-tcltk/pkg-plist.tcl b/japanese/postgresql-tcltk/pkg-plist.tcl
index 1752c248ce13..f3d0a042d747 100644
--- a/japanese/postgresql-tcltk/pkg-plist.tcl
+++ b/japanese/postgresql-tcltk/pkg-plist.tcl
@@ -1,129 +1,7 @@
-%%INSTALL_DIR%%/bin/pgtclsh
-%%INSTALL_DIR%%/bin/pgtksh
-%%INSTALL_DIR%%/bin/pgaccess
-%%INSTALL_DIR%%/lib/libpgtcl.a
-%%INSTALL_DIR%%/lib/libpgtcl.so
-%%INSTALL_DIR%%/lib/libpgtcl.so.2
-%%INSTALL_DIR%%/include/libpgtcl.h
-%%INSTALL_DIR%%/pgaccess/images/icon_button.gif
-%%INSTALL_DIR%%/pgaccess/images/icon_checkbutton.gif
-%%INSTALL_DIR%%/pgaccess/images/icon_entry.gif
-%%INSTALL_DIR%%/pgaccess/images/icon_frame.gif
-%%INSTALL_DIR%%/pgaccess/images/icon_label.gif
-%%INSTALL_DIR%%/pgaccess/images/icon_listbox.gif
-%%INSTALL_DIR%%/pgaccess/images/icon_query.gif
-%%INSTALL_DIR%%/pgaccess/images/icon_radiobutton.gif
-%%INSTALL_DIR%%/pgaccess/images/icon_text.gif
-%%INSTALL_DIR%%/pgaccess/lib/help/abort.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/add_records.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/alter_table.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/alter_user.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/author.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/begin.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/close.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/cluster.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/commit.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/copy.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/copyrights.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_aggregate.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_database.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_function.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_index.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_language.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_operator.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_rule.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_sequence.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_table.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_table_as.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_trigger.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_type.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_user.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_view.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/data_types.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/datefunc.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/declare.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/delete.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_aggregate.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_database.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_function.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_index.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_language.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_operator.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_rule.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_sequence.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_table.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_trigger.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_type.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_user.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_view.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/explain.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/fetch.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/form_design.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/forms.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/functions.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/geomfunc.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/grant.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/history.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/index.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/inheritance.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/insert.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/ipv4func.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/isolation.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/keywords.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/listen.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/load.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/lock.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/mathfunc.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/move.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/mvcc.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/new_query.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/new_table.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/notify.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/open_query.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/open_table.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/pgfunctions.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/postgresql.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/queries.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/reports.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/reset.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/revoke.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/rollback.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/schema.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/scripts.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/select.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/select_into.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/sequences.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/set.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/show.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/sql_guide.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/sqlfunc.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/stringfunc.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/tables.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/unlisten.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/update.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/users.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/vacuum.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/view_table_structure.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/views.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/visual_designer.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/y2k.hlp
-%%INSTALL_DIR%%/pgaccess/lib/languages/francais
-%%INSTALL_DIR%%/pgaccess/lib/languages/italiano
-%%INSTALL_DIR%%/pgaccess/lib/languages/magyar
-%%INSTALL_DIR%%/pgaccess/lib/languages/romana
-%%INSTALL_DIR%%/pgaccess/main.tcl
-%%INSTALL_DIR%%/pgaccess/lib/database.tcl
-%%INSTALL_DIR%%/pgaccess/lib/forms.tcl
-%%INSTALL_DIR%%/pgaccess/lib/functions.tcl
-%%INSTALL_DIR%%/pgaccess/lib/help.tcl
-%%INSTALL_DIR%%/pgaccess/lib/mainlib.tcl
-%%INSTALL_DIR%%/pgaccess/lib/preferences.tcl
-%%INSTALL_DIR%%/pgaccess/lib/queries.tcl
-%%INSTALL_DIR%%/pgaccess/lib/reports.tcl
-%%INSTALL_DIR%%/pgaccess/lib/schema.tcl
-%%INSTALL_DIR%%/pgaccess/lib/scripts.tcl
-%%INSTALL_DIR%%/pgaccess/lib/sequences.tcl
-%%INSTALL_DIR%%/pgaccess/lib/tables.tcl
-%%INSTALL_DIR%%/pgaccess/lib/users.tcl
-%%INSTALL_DIR%%/pgaccess/lib/views.tcl
-%%INSTALL_DIR%%/pgaccess/lib/visualqb.tcl
+pgsql/bin/pgtclsh
+pgsql/bin/pgtksh
+pgsql/include/libpgtcl.h
+pgsql/lib/libpgtcl.a
+pgsql/lib/libpgtcl.so
+pgsql/lib/libpgtcl.so.2
+pgsql/lib/pltcl.so
diff --git a/japanese/postgresql-tcltk/scripts/configure b/japanese/postgresql-tcltk/scripts/configure
new file mode 100644
index 000000000000..89d6fd0e2405
--- /dev/null
+++ b/japanese/postgresql-tcltk/scripts/configure
@@ -0,0 +1,7 @@
+#! /bin/sh
+
+# $FreeBSD: /tmp/pcvs/ports/japanese/postgresql-tcltk/scripts/Attic/configure,v 1.1 2000-07-19 01:18:08 kuriyama Exp $
+
+cd $WRKSRC || exit 1
+
+perl -pi -e "s=!!JAVA_HOME!!=${JAVA_HOME}=; s=!!PREFIX!!=${PREFIX}=" ${WRKSRC}/interfaces/jdbc/Makefile
diff --git a/japanese/postgresql-tcltk/scripts/createuser b/japanese/postgresql-tcltk/scripts/createuser
new file mode 100644
index 000000000000..2abe201e7a4b
--- /dev/null
+++ b/japanese/postgresql-tcltk/scripts/createuser
@@ -0,0 +1,50 @@
+#!/usr/bin/perl
+#
+
+eval '(exit $?0)' && eval 'exec /usr/bin/perl -S $0 ${1+"$@"}'
+& eval 'exec /usr/bin/perl -S $0 $argv:q'
+if 0;
+
+if( $> ) {
+ print "\nYou must be root to run this step!\n\n";
+ exit 1;
+}
+
+if( getpwnam( "pgsql" ) ) {
+ ( $null, $null, $pgUID ) = getpwnam( "pgsql" );
+} else {
+ $pgUID = 70;
+ while( getpwuid( $pgUID ) ) {
+ $pgUID++;
+ }
+}
+
+if( getgrnam( "pgsql" ) ) {
+ ( $null, $null, $pgGID ) = getgrnam( "pgsql" );
+} else {
+ $pgGID = 70;
+ while( getgrgid( $pgGID ) ) {
+ $pgGID++;
+ }
+ &append_file( "/etc/group", "pgsql:*:$pgGID:" );
+}
+
+print "pgsql user using uid $pgUID\n";
+print "pgsql user using gid $pgGID\n";
+
+system( "/usr/bin/chpass -a \"pgsql:*:$pgUID:$pgGID\:\:0:0:PostgreSQL pseudo-user:$ENV{'PREFIX'}/pgsql:/bin/sh\"" );
+
+sub append_file {
+ local($file,@list) = @_;
+ local($LOCK_EX) = 2;
+ local($LOCK_NB) = 4;
+ local($LOCK_UN) = 8;
+
+ open(F, ">> $file") || die "$file: $!\n";
+ while( ! flock( F, $LOCK_EX | $LOCK_NB ) ) {
+ exit 1;
+ }
+ print F join( "\n", @list) . "\n";
+ close F;
+ flock( F, $LOCK_UN );
+}
diff --git a/japanese/postgresql7/Makefile b/japanese/postgresql7/Makefile
index e99deb40e890..ee410effc32d 100644
--- a/japanese/postgresql7/Makefile
+++ b/japanese/postgresql7/Makefile
@@ -1,177 +1,228 @@
-# New ports collection makefile for: PostgreSQL-j
-# Date created: 09 Nov 1999
-# Whom: Ichiro Fukuhara <ichiro@ichiro.org>
+# New ports collection makefile for: PostgreSQL
+# Date created: 7 Jun 2000
+# Whom: Tomokatsu Saito <saito@a2z.co.jp>
#
# $FreeBSD$
#
PORTNAME= postgresql
-PORTVERSION= 6.5.3
+PORTVERSION= 7.0.2
CATEGORIES= japanese databases
-MASTER_SITES= ftp://ftp.jaist.ac.jp/pub/dbms/PostgreSQL/ \
+MASTER_SITES= ftp://ftp.jaist.ac.jp/pub/dbms/PostgreSQL/v${PORTVERSION}/ \
ftp://ftp.sra.co.jp/pub/cmd/postgres/${PORTVERSION}/ \
- ftp://ftp.postgresql.org/pub/
+ ftp://ftp.postgresql.org/pub/v${PORTVERSION}/
+DISTNAME= ${PORTNAME}-${PORTVERSION}
-MAINTAINER= kuriyama@FreeBSD.org
+MAINTAINER= saito@a2z.co.jp
-WRKSRC= ${WRKDIR}/${DISTNAME}/src
-PLISTS=
+.if ${MACHINE_ARCH} == "alpha"
+BROKEN= doesn\'t build on the alpha yet
+.endif
+
+Y2K= http://www.postgresql.org/y2k.html
# if you want to use the tcl/tk frontend pgaccess, then you need to build
-# postgresql with tcl support by typing: make WITH_TCL=yes
-.if defined(WITH_TCL)
-TCL_INCDIR= ${PREFIX}/include/tcl8.0jp
-TK_INCDIR= ${PREFIX}/include/tk8.0jp
-MAKE_ENV= USE_TCL=true USE_TK=true TCL_INCDIR=${TCL_INCDIR}
-CONFIGURE_ARGS= --with-tcl --with-tk \
- --with-tclconfig=${PREFIX}/lib/tcl8.0jp \
- --with-tkconfig=${PREFIX}/lib/tk8.0jp
+# postgresql with tcl support by typing: make USE_TCL=yes
+.if defined(USE_TCL)
LIB_DEPENDS= tcl80jp.1:${PORTSDIR}/japanese/tcl80 \
tk80jp.1:${PORTSDIR}/japanese/tk80
-PLISTS+= PLIST.tcl
+TCL_INCDIR= ${LOCALBASE}/include/tcl8.0jp
+TK_INCDIR= ${LOCALBASE}/include/tk8.0jp
+MAKE_ENV+= TCL_INCDIR=${TCL_INCDIR}
+CONFIGURE_TCL= --with-tcl --with-tclconfig=${LOCALBASE}/lib/tcl8.0jp --with-tkconfig=${LOCALBASE}/lib/tk8.0jp
.endif
.if defined(MULTIBYTE)
-CONFIGURE_ARGS+= --with-mb=${MULTIBYTE}
+WITH_MB= --enable-multibyte=${MULTIBYTE}
.endif
-.if defined(WITH_PERL)
-CONFIGURE_ARGS+= --with-perl
-PLISTS+= PLIST.pl
+.if defined(USE_PERL)
+WITH_PERL= --with-perl
.endif
-.if defined(WITH_ODBC)
-CONFIGURE_ARGS+= --with-odbc
-PLISTS+= PLIST.odbc
+.if defined(USE_ODBC)
+WITH_ODBC= --with-odbc
+.endif
+
+# if you want jdbc, type make USE_JDBC=yes
+# Honors JAVA_HOME if you have it set, and don't want the dependency.
+.if defined(USE_JDBC)
+JAVA_HOME?= ${LOCALBASE}/jdk1.1.8
+BUILD_DEPENDS= ${JAVA_HOME}/bin/javac:${PORTSDIR}/java/jdk
+#MAKE_ENV+= JAVA_HOME=${JAVA_HOME}
+#CONFIGURE_ENV+= JAVA_HOME=${JAVA_HOME}
+SCRIPTS_ENV+= JAVA_HOME=${JAVA_HOME}
.endif
-NO_PACKAGE= "Requires ${PGSQL_UID} uid"
+WRKSRC= ${WRKDIR}/${PORTNAME}-${PORTVERSION}/src
+DOCDIR= ${WRKDIR}/${PORTNAME}-${PORTVERSION}/doc
USE_GMAKE= YES
MAKEFILE= GNUmakefile
HAS_CONFIGURE= YES
-CONFIGURE_ARGS+= --prefix=${PREFIX}/${INSTALL_DIR} \
+CONFIGURE_ARGS= --prefix=${LOCALBASE}/pgsql \
+ --enable-locale \
--with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` \
- --with-includes="${PREFIX}/include ${TCL_INCDIR} ${TK_INCDIR}" \
- --with-libraries=${PREFIX}/lib
-
-INSTALL_TARGET= install install-man
-
-MAN1= cleardbdir.1 createdb.1 createuser.1 destroydb.1 \
- destroyuser.1 ecpg.1 initdb.1 initlocation.1 \
- ipcclean.1 pg_dump.1 pg_dumpall.1 pg_passwd.1 \
- pg_upgrade.1 postgres.1 postmaster.1 psql.1
-MAN3= catalogs.3 libpq.3
-MAN5= pg_hba.conf.5
-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_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 \
+ ${WITH_MB} ${WITH_PERL} ${WITH_ODBC} \
+ --with-includes="${LOCALBASE}/include ${TCL_INCDIR} ${TK_INCDIR}" \
+ ${CONFIGURE_TCL} \
+ --with-libraries=${LOCALBASE}/lib
+
+MAN1= createdb.1 createlang.1 createuser.1 dropdb.1 droplang.1 \
+ dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 pg_ctl.1 \
+ pg_dump.1 \
+ pg_dumpall.1 pg_passwd.1 pg_upgrade.1 pgaccess.1 pgadmin.1 \
+ pgtclsh.1 \
+ pgtksh.1 postgres.1 postmaster.1 psql.1 vacuumdb.1
+MANL= abort.l alter_group.l alter_table.l alter_user.l begin.l \
+ close.l \
+ cluster.l comment.l commit.l copy.l create_aggregate.l \
+ create_constraint_trigger.l create_database.l \
+ create_function.l \
+ create_group.l create_index.l create_language.l \
+ create_operator.l \
+ create_rule.l create_sequence.l create_table.l \
+ create_table_as.l \
+ create_trigger.l create_type.l create_user.l create_view.l \
+ declare.l \
+ delete.l drop_aggregate.l drop_database.l drop_function.l \
+ drop_group.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}/${INSTALL_DIR}
-INSTALLS_SHLIB= yes
-LDCONFIG_DIRS= ${PREFIX}/${INSTALL_DIR}/lib
-
-PLIST_SUB= INSTALL_DIR=${INSTALL_DIR}
-PLIST= ${WRKDIR}/PLIST
+ drop_view.l \
+ end.l explain.l fetch.l grant.l insert.l listen.l load.l \
+ lock.l \
+ move.l notify.l reindex.l reset.l revoke.l rollback.l select.l \
+ select_into.l set.l show.l truncate.l unlisten.l update.l \
+ vacuum.l
-# These values are easily overridable like as
-# "make PGQL_UID=postgresql PGSQL_GID=postgresql install"
-INSTALL_DIR= pgsql
-PGSQL_UID= pgsql
-PGSQL_GID= pgsql
+MANPREFIX= ${PREFIX}/pgsql
pre-fetch:
-.if !defined(WITH_TCL) & !defined(WITH_PERL) & !defined(WITH_ODBC) & !defined(MULTIBYTE)
-
- @${ECHO_MSG} "To build the \"MULTIBYTE PostgreSQL\", type:"
- @${ECHO_MSG} " make MULTIBYTE={EUC_JP,EUC_CN,EUC_KR,EUC_TW,UNICODE,MULE_INTERNAL,LATIN1-5}"
- @${ECHO_MSG} " WITH_TCL=yes, WITH_PERL=yes, WITH_ODBC=yes"
- @${ECHO_MSG} ""
+ @${ECHO_MSG} "To install and run postgresql you need to compile kernel with:"
+ @${ECHO_MSG} " options \"SYSVSHM, SYSVSEM, SYSVMSG\""
+.if !defined(USE_TCL)
@${ECHO_MSG} "To build the \"PostgreSQL to Tcl interface library\", libpgtcl, type:"
- @${ECHO_MSG} " make WITH_TCL=yes"
+ @${ECHO_MSG} " make USE_TCL=yes"
.else
@${ECHO_MSG} "Building PostgreSQL with \"libpgtcl\"."
.endif
-
-.include <bsd.port.pre.mk>
+.if !defined(USE_JDBC)
+ @ ${ECHO_MSG} "To build Java (JDBC) support, type:"
+ @ ${ECHO_MSG} " make USE_JDBC=yes"
+.else
+ @ ${ECHO_MSG} "Building PostgreSQL with \"postgresql.jar\"."
+.endif
post-patch:
- find ${WRKDIR} -name '*.orig' -exec ${RM} {} \;
-
+ @ ${MV} ${WRKSRC}/template/freebsd ${WRKSRC}/template/freebsd.orig
+ @ ${SED} -e 's#CFLAGS:-O2 -m486 -pipe#CFLAGS:${CFLAGS}#' \
+ -e 's#USE_LOCALE:no#USE_LOCALE:yes#' \
+ ${WRKSRC}/template/freebsd.orig >> ${WRKSRC}/template/freebsd
+ @ ${MV} ${WRKSRC}/Makefile.global.in ${WRKSRC}/Makefile.global.in.old
+ @ ${SED} -e 's=!!PREFIX!!=${PREFIX}=g' \
+ ${WRKSRC}/Makefile.global.in.old \
+ >> ${WRKSRC}/Makefile.global.in
post-build:
+.if defined(USE_JDBC)
+ @ cd ${WRKSRC}/interfaces/jdbc && ${GMAKE}
+.if !defined(NOPORTDOCS)
+ @ cd ${WRKSRC}/interfaces/jdbc && ${GMAKE} examples
+.endif
+.endif
@ ${ECHO} "------------------------------------------------------------"
@ ${ECHO} "Dump existing databases, before installing new db version !!"
- @ ${ECHO} "Detailed instructions, see INSTALL file under ${WRKDIR}... "
+ @ ${ECHO} "Detailed instructions, see"
+ @ ${ECHO} "${WRKDIR}/${DISTNAME}/INSTALL"
@ ${ECHO} "------------------------------------------------------------"
- @${RM} -f ${WRKDIR}/PLIST
-.for i in ${PLISTS} PLIST
- ${CAT} ${PKGDIR}/${i} >> ${WRKDIR}/PLIST
-.endfor
-.if defined(WITH_TCL)
- ${CAT} ${PKGDIR}/PLIST.tcl.dirrm >> ${WRKDIR}/PLIST
-.endif
-.if defined(WITH_ODBC)
- ${CAT} ${PKGDIR}/PLIST.odbc.dirrm >> ${WRKDIR}/PLIST
-.endif
- ${CAT} ${PKGDIR}/PLIST.dirrm >> ${WRKDIR}/PLIST
pre-install:
.if defined(PACKAGE_BUILDING)
- ${RM} -rf ${PREFIX}/${INSTALL_DIR}
+ ${RM} -rf ${PREFIX}/pgsql
.endif
- @ ${MKDIR} ${PREFIX}/${INSTALL_DIR}
- @ ${SETENV} INSTALL_DIR=${INSTALL_DIR} \
- PGSQL_UID=${PGSQL_UID} PGSQL_GID=${PGSQL_GID} \
- PKG_PREFIX=${PREFIX} \
- ${SH} ${PKGDIR}/INSTALL ${PKGNAME} PRE-INSTALL
+ @ ${MKDIR} ${PREFIX}/pgsql
+ @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser
+
post-install:
- @ if [ ! -f ${PREFIX}/${INSTALL_DIR}/.profile ]; then \
- ${ECHO} "PATH=${PATH}:${PREFIX}/${INSTALL_DIR}/bin" \
- > ${PREFIX}/${INSTALL_DIR}/.profile; \
- ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/${INSTALL_DIR}/bin" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
- ${ECHO} "PGLIB=${PREFIX}/${INSTALL_DIR}/lib" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
+.if defined(NOPORTDOCS)
+ @ ( cd ${DOCDIR}; ${GMAKE} man )
+.else
+ @ ( cd ${DOCDIR}; ${GMAKE} install )
+.endif
+ @ if [ ! -f ${PREFIX}/pgsql/.profile ]; then \
+ ${ECHO} "PATH=${PATH}:${PREFIX}/pgsql/bin" \
+ > ${PREFIX}/pgsql/.profile; \
+ ${ECHO} "MANPATH=${MANPATH}:${PREFIX}/pgsql/man" \
+ >> ${PREFIX}/pgsql/.profile; \
+ ${ECHO} "PGLIB=${PREFIX}/pgsql/lib" \
+ >> ${PREFIX}/pgsql/.profile; \
${ECHO} "# note: PGDATA overwrites the -D startup option" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
- ${ECHO} "PGDATA=${PREFIX}/${INSTALL_DIR}/data" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
+ >> ${PREFIX}/pgsql/.profile; \
+ ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \
+ >> ${PREFIX}/pgsql/.profile; \
${ECHO} "DISPLAY=:0" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
+ >> ${PREFIX}/pgsql/.profile; \
${ECHO} "export PATH MANPATH PGLIB PGDATA DISPLAY" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
+ >> ${PREFIX}/pgsql/.profile; \
${ECHO} "# if you want to make regression tests use this TZ" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
+ >> ${PREFIX}/pgsql/.profile; \
${ECHO} "#TZ=PST8PDT" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
+ >> ${PREFIX}/pgsql/.profile; \
${ECHO} "#export TZ" \
- >> ${PREFIX}/${INSTALL_DIR}/.profile; \
+ >> ${PREFIX}/pgsql/.profile; \
fi
- @ ${CHOWN} -R ${PGSQL_UID}:${PGSQL_GID} ${PREFIX}/${INSTALL_DIR}
+ @ ${CHOWN} -R pgsql:pgsql ${PREFIX}/pgsql
@ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...'
- @ ${LDCONFIG} -m ${PREFIX}/${INSTALL_DIR}/lib
- @ /usr/bin/su -l ${PGSQL_UID} -c '${PREFIX}/${INSTALL_DIR}/bin/initdb --pglib=${PREFIX}/${INSTALL_DIR}/lib --pgdata=${PREFIX}/${INSTALL_DIR}/data'
- @ ${SED} "s=!!PG_PATH!!=${PREFIX}/${INSTALL_DIR}=g ; s=!!PGSQL_UID!!=${PGSQL_UID}=g" \
- < ${FILESDIR}/pgsql.sh.tmpl > ${PREFIX}/etc/rc.d/pgsql.sh
+ @ ${SETENV} OBJFORMAT=${PORTOBJFORMAT} ${LDCONFIG} -m ${PREFIX}/pgsql/lib
+ @ su -l pgsql -c 'PATH=${PREFIX}/pgsql/bin:${PATH} ${PREFIX}/pgsql/bin/initdb --pglib=${PREFIX}/pgsql/lib --pgdata=${PREFIX}/pgsql/data'
+ @ ${SED} -e "s=!!PREFIX!!=${PREFIX}=g" < ${FILESDIR}/pgsql.sh.tmpl \
+ > ${PREFIX}/etc/rc.d/pgsql.sh
@ ${CHMOD} 554 ${PREFIX}/etc/rc.d/pgsql.sh
- @ ${CHOWN} root.${PGSQL_GID} ${PREFIX}/etc/rc.d/pgsql.sh
- @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/${INSTALL_DIR}
+ @ ${CHOWN} root.pgsql ${PREFIX}/etc/rc.d/pgsql.sh
+ @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql
+.if defined(USE_TCL)
+ @${CP} ${TMPPLIST} ${TMPPLIST}.notcl
+ @${CAT} ${PKGDIR}/PLIST.tcl ${TMPPLIST}.notcl > ${TMPPLIST}
+ @${RM} ${TMPPLIST}.notcl
+.endif
+.if defined(USE_ODBC)
+ @${CP} ${TMPPLIST} ${TMPPLIST}.noodbc
+ @${CAT} ${PKGDIR}/PLIST.odbc ${TMPPLIST}.noodbc > ${TMPPLIST}
+ @${RM} ${TMPPLIST}.noodbc
+.endif
+.if defined(USE_JDBC)
+ @ ${MKDIR} -m 0555 ${PREFIX}/share/java
+ @ ${INSTALL_DATA} ${WRKSRC}/interfaces/jdbc/postgresql.jar \
+ ${PREFIX}/share/java/postgresql.jar
+ @ ${ECHO_MSG} "---------------------------------------------------------"
+ @ ${ECHO_MSG} "Putting postgresql.jar in ${PREFIX}/share/java"
+ @ ${ECHO_MSG} "Add this to your CLASSPATH!"
+ @ ${ECHO_MSG} "---------------------------------------------------------"
+ ${CAT} ${PKGDIR}/PLIST.jdbc >> ${TMPPLIST}
.if !defined(NOPORTDOCS)
- ${MKDIR} ${PREFIX}/share/doc/${INSTALL_DIR}
- ${CP} -R ${WRKDIR}/${DISTNAME}/doc/* ${PREFIX}/share/doc/${INSTALL_DIR}
-.for f in . src src/sgml src/sgml/ref src/graphics
- @${RM} -rf ${PREFIX}/share/doc/${INSTALL_DIR}/$f/CVS
- @${RM} -f ${PREFIX}/share/doc/${INSTALL_DIR}/$f/#cvs*
-.endfor
+ @ ${MKDIR} -m 0555 ${PREFIX}/share/examples/pgsql/jdbc
+ @ ${INSTALL_DATA} ${WRKSRC}/interfaces/jdbc/example/*java \
+ ${PREFIX}/share/examples/pgsql/jdbc
+ @ ${INSTALL_DATA} ${WRKSRC}/interfaces/jdbc/README* \
+ ${PREFIX}/share/examples/pgsql/jdbc
+ @ ${ECHO_MSG} "---------------------------------------------------------"
+ @ ${ECHO_MSG} "Putting jdbc examples into ${PREFIX}/share/examples/pgsql"
+ @ ${ECHO_MSG} "---------------------------------------------------------"
+.endif
+.endif
+.if !defined(NOPORTDOCS)
+ ${MKDIR} ${PREFIX}/share/doc/pgsql
+ @ ${GMAKE} -C ${WRKDIR}/${DISTNAME}/doc install
+ ${INSTALL_MAN} ${WRKDIR}/${DISTNAME}/doc/FAQ* ${PREFIX}/share/doc/pgsql
+ ${INSTALL_MAN} ${WRKDIR}/${DISTNAME}/doc/README* ${PREFIX}/share/doc/pgsql
+ ${INSTALL_MAN} ${WRKDIR}/${DISTNAME}/doc/TODO ${PREFIX}/share/doc/pgsql
+ ${INSTALL_MAN} ${WRKDIR}/${DISTNAME}/doc/*ps ${PREFIX}/share/doc/pgsql
.endif
.if !defined(BATCH)
@ more -e ${FILESDIR}/post-install-notes
.endif
+.if !defined(DEBUG_FLAGS)
+.for file in ecpg pg_dump pg_id pg_passwd pg_version postgres psql
+ @ strip ${PREFIX}/pgsql/bin/${file}
+.endfor
+.endif
-.include <bsd.port.post.mk>
+.include <bsd.port.mk>
diff --git a/japanese/postgresql7/distinfo b/japanese/postgresql7/distinfo
index d831c26206f7..8ae9ac603336 100644
--- a/japanese/postgresql7/distinfo
+++ b/japanese/postgresql7/distinfo
@@ -1 +1 @@
-MD5 (postgresql-6.5.3.tar.gz) = 098d1ee4316500a2d033ced3ebd5b831
+MD5 (postgresql-7.0.2.tar.gz) = fc512e38394256e2749299fdd69a937e
diff --git a/japanese/postgresql7/files/patch-ab b/japanese/postgresql7/files/patch-ab
index cb53b5b7de93..3be237663dd4 100644
--- a/japanese/postgresql7/files/patch-ab
+++ b/japanese/postgresql7/files/patch-ab
@@ -1,25 +1,22 @@
---- bin/pg_passwd/pg_passwd.c.orig Thu May 27 16:00:40 1999
-+++ bin/pg_passwd/pg_passwd.c Tue Jun 15 19:27:47 1999
-@@ -26,11 +26,17 @@
+--- bin/pg_passwd/pg_passwd.c.orig Mon Apr 17 12:45:18 2000
++++ bin/pg_passwd/pg_passwd.c Wed May 10 03:39:18 2000
+@@ -18,11 +18,14 @@
#endif
+#ifndef _POSIX_SOURCE
-+# define _PASSWORD_LEN 128 /* max length, not containing NULL */
++# define _PASSWORD_LEN 128 /* max length, not containing NULL */
+#endif
-+
-+
char *comname;
- static void usage(FILE *stream);
- static void read_pwd_file(char *filename);
-+static void encrypt_pwd(char key[9], char salt[3], char passwd[_PASSWORD_LEN+1]);
-+int check_pwd(char key[9], char passwd[_PASSWORD_LEN+1]);
- static void write_pwd_file(char *filename, char *bkname);
--static void encrypt_pwd(char key[9], char salt[3], char passwd[14]);
- static void prompt_for_username(char *username);
- static void prompt_for_password(char *prompt, char *password);
+ static void usage(FILE *stream);
+ static void read_pwd_file(char *filename);
+ static void write_pwd_file(char *filename, char *bkname);
+-static void encrypt_pwd(char key[9], char salt[3], char passwd[14]);
++static void encrypt_pwd(char key[9], char salt[3], char passwd[_PASSWORD_LEN+1]);
+ static void prompt_for_username(char *username);
+ static void prompt_for_password(char *prompt, char *password);
-@@ -158,7 +164,7 @@
+@@ -150,7 +153,7 @@
if (q != NULL)
*(q++) = '\0';
@@ -28,7 +25,7 @@
{
fprintf(stderr, "WARNING: %s: line %d: illegal password length.\n",
filename, npwds + 1);
-@@ -222,7 +228,7 @@
+@@ -214,7 +217,7 @@
}
static void
@@ -37,26 +34,28 @@
{
int n;
-@@ -254,9 +260,7 @@
+@@ -246,9 +249,9 @@
#ifdef NOT_USED
static int
-check_pwd(char key[9], char passwd[14])
++check_pwd(char key[9], char passwd[_PASSWORD_LEN+1])
{
- char shouldbe[14];
++ char shouldbe[_PASSWORD_LEN+1];
char salt[3];
salt[0] = passwd[0];
-@@ -264,7 +268,7 @@
+@@ -256,7 +259,7 @@
salt[2] = '\0';
encrypt_pwd(key, salt, shouldbe);
- return strncmp(shouldbe, passwd, 13) == 0 ? 1 : 0;
-+ return strncmp(shouldbe, passwd, _PASSWORD_LEN) == 0 ? 1 : 0;
++ return strncmp(shouldbe, passwd, _PASSWORD_LEN+1) == 0 ? 1 : 0;
}
- #endif
-@@ -339,7 +343,7 @@
+ #endif
+@@ -332,7 +335,7 @@
char salt[3];
char key[9],
key2[9];
diff --git a/japanese/postgresql7/files/patch-ac b/japanese/postgresql7/files/patch-ac
index 2a9e180e0958..f0f0ac586e74 100644
--- a/japanese/postgresql7/files/patch-ac
+++ b/japanese/postgresql7/files/patch-ac
@@ -1,11 +1,11 @@
---- interfaces/libpgtcl/Makefile.in.orig Mon Feb 8 07:10:45 1999
-+++ interfaces/libpgtcl/Makefile.in Tue Jun 15 19:32:36 1999
-@@ -27,7 +27,7 @@
-
- OBJS= pgtcl.o pgtclCmds.o pgtclId.o
-
--SHLIB_LINK+= -L../libpq -lpq
-+SHLIB_LINK+= -L../libpq -lpq -lcrypt
-
- # If crypt is a separate library, rather than part of libc, it may need
- # to be referenced separately to keep (broken) linkers happy. (This is
+--- configure.orig Thu May 4 04:10:55 2000
++++ configure Wed May 10 03:46:37 2000
+@@ -1472,7 +1472,7 @@
+ ELF_SYS=true
+ else
+ rm -rf conftest*
+- if test "X$elf" = "Xyes"
++ if test "X$PORTOBJFORMAT" = "Xelf"
+ then
+ ELF_SYS=true
+ else
diff --git a/japanese/postgresql7/files/patch-ad b/japanese/postgresql7/files/patch-ad
index ce5713717369..ea1b852b3f87 100644
--- a/japanese/postgresql7/files/patch-ad
+++ b/japanese/postgresql7/files/patch-ad
@@ -1,13 +1,11 @@
---- pl/tcl/Makefile.org Mon Dec 14 08:47:17 1998
-+++ pl/tcl/Makefile Thu Feb 25 22:20:28 1999
-@@ -55,8 +55,8 @@
- SHLIB_EXTRA_LIBS=
- endif
+--- Makefile.global.in.orig Wed May 10 03:47:24 2000
++++ Makefile.global.in Wed May 10 03:48:37 2000
+@@ -87,7 +87,7 @@
+ POSTMANDIR= $(POSTGRESDIR)/man
--%$(TCL_SHLIB_SUFFIX): %.o
-- $(TCL_SHLIB_LD) -o $@ $< $(TCL_LIB_SPEC) $(SHLIB_EXTRA_LIBS)
-+#%$(TCL_SHLIB_SUFFIX): %.o
-+# $(TCL_SHLIB_LD) -o $@ $< $(TCL_LIB_SPEC) $(SHLIB_EXTRA_LIBS)
+ # Where the formatted documents (e.g., the reference manual) get installed.
+-POSTDOCDIR= $(POSTGRESDIR)/doc
++POSTDOCDIR= !!PREFIX!!/share/doc/pgsql
-
- #
+ # Where the header files necessary to build frontend programs get installed.
+ HEADERDIR= $(POSTGRESDIR)/include
diff --git a/japanese/postgresql7/files/patch-ae b/japanese/postgresql7/files/patch-ae
new file mode 100644
index 000000000000..82a8e0012494
--- /dev/null
+++ b/japanese/postgresql7/files/patch-ae
@@ -0,0 +1,11 @@
+--- ../doc/Makefile.orig Mon Dec 6 06:23:00 1999
++++ ../doc/Makefile Wed May 10 03:50:13 2000
+@@ -12,7 +12,7 @@
+ #
+ #----------------------------------------------------------------------------
+
+-PGDOCS= $(POSTGRESDIR)/doc
++PGDOCS= $(POSTDOCDIR)
+ SRCDIR= ../src
+
+ TAR= tar
diff --git a/japanese/postgresql7/files/patch-af b/japanese/postgresql7/files/patch-af
new file mode 100644
index 000000000000..58d833335108
--- /dev/null
+++ b/japanese/postgresql7/files/patch-af
@@ -0,0 +1,25 @@
+--- interfaces/jdbc/Makefile.orig Tue May 9 12:47:50 2000
++++ interfaces/jdbc/Makefile Wed May 10 03:53:41 2000
+@@ -10,10 +10,10 @@
+
+ FIND = find
+ IDL2JAVA = idltojava -fno-cpp -fno-tie
+-JAR = jar
+-JAVA = java
+-JAVAC = javac -g
+-JAVADOC = javadoc
++JAR = !!JAVA_HOME!!/bin/jar
++JAVA = !!JAVA_HOME!!/bin/java
++JAVAC = !!JAVA_HOME!!/bin/javac
++JAVADOC = !!JAVA_HOME!!/bin/javadoc
+ RM = rm -f
+ TOUCH = touch
+
+@@ -49,6 +49,7 @@
+ @echo JVM.
+ @echo
+ @echo ------------------------------------------------------------
++ $(MAKE) jdbc1
+
+ msg:
+ @echo ------------------------------------------------------------
diff --git a/japanese/postgresql7/files/patch-ag b/japanese/postgresql7/files/patch-ag
new file mode 100644
index 000000000000..e15a1521b855
--- /dev/null
+++ b/japanese/postgresql7/files/patch-ag
@@ -0,0 +1,11 @@
+--- pl/tcl/Makefile.orig Sun Apr 30 02:45:42 2000
++++ pl/tcl/Makefile Fri May 12 21:31:07 2000
+@@ -66,7 +66,7 @@
+ # Instead use TCL's CFLAGS plus necessary -I directives.
+
+ # Can choose either TCL_CFLAGS_OPTIMIZE or TCL_CFLAGS_DEBUG here, as needed
+-CFLAGS= $(TCL_CFLAGS_OPTIMIZE)
++CFLAGS+= $(TCL_CFLAGS_OPTIMIZE)
+
+ CFLAGS+= $(TCL_SHLIB_CFLAGS) $(TCL_DEFS)
+
diff --git a/japanese/postgresql7/files/patch-bc b/japanese/postgresql7/files/patch-bc
new file mode 100644
index 000000000000..e4e98dd945b0
--- /dev/null
+++ b/japanese/postgresql7/files/patch-bc
@@ -0,0 +1,5 @@
+--- bin/pg_ctl/postmaster.opts.default.sample.org Tue Jun 6 15:23:50 2000
++++ bin/pg_ctl/postmaster.opts.default.sample Tue Jun 6 15:24:08 2000
+@@ -1 +1 @@
+-
++-i -o "-F"
diff --git a/japanese/postgresql7/files/pgsql.sh.tmpl b/japanese/postgresql7/files/pgsql.sh.tmpl
index d3f0af6cb802..e1673b4850c2 100644
--- a/japanese/postgresql7/files/pgsql.sh.tmpl
+++ b/japanese/postgresql7/files/pgsql.sh.tmpl
@@ -1,39 +1,34 @@
#!/bin/sh
# $FreeBSD$
-
-# pgsql.sh - postgresql startup file for FreeBSD and possibly *BSD (untested)
-
-# Changes:
-# - renamed startup script to be in sync with INSTALL file
-# - merged ldconfig start sequence from former postgrsql.sh script (andreas)
-# - modified the postmaster startup sequence as suggested in the
-# INSTALL file which was given as example for FreeBSD 2.2 (andreas)
-# - removed the commandline option
-# -D!!PG_PATH!!/data \
-# because the postmaster process, which starts up under the
-# environment of the pgsql user, sets this with the PGDATA
-# environment variable in !!PG_PATH!!/.profile
#
+# For postmaster startup options, edit $PGDATA/postmaster.opts.default
+# Preinstalled options are -i -o "-F"
-case "$1" in
+case $1 in
start)
- [ -d !!PG_PATH!!/lib ] && /sbin/ldconfig -m !!PG_PATH!!/lib
+ [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib
+ [ -x !!PREFIX!!/pgsql/bin/pg_ctl ] && {
+ su -l pgsql -c \
+ 'exec !!PREFIX!!/pgsql/bin/pg_ctl -w start > !!PREFIX!!/pgsql/errlog 2>&1'
+ echo -n ' pgsql'
+ }
+ ;;
- [ -x !!PG_PATH!!/bin/postmaster ] && {
- su -l !!PGSQL_UID!! -c 'exec !!PG_PATH!!/bin/postmaster -i -S -o -F \
- -D!!PG_PATH!!/data > !!PG_PATH!!/errlog'
- echo -n ' PostgreSQL'
- }
- ;;
stop)
- # XXX some pgsql user should check this --tg
- killall !!PG_PATH!!/bin/postmaster
- ;;
+ [ -x !!PREFIX!!/pgsql/bin/pg_ctl ] && {
+ su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/pg_ctl -w -m fast stop'
+ }
+ ;;
+
+status)
+ [ -x !!PREFIX!!/pgsql/bin/pg_ctl ] && {
+ su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/pg_ctl status'
+ }
+ ;;
+
*)
- echo "Usage: `basename $0` {start|stop}" >&2
- exit 64
- ;;
+ echo "usage: `basename $0` {start|stop|status}" >&2
+ exit 64
+ ;;
esac
-
-exit 0
diff --git a/japanese/postgresql7/files/post-install-notes b/japanese/postgresql7/files/post-install-notes
index 4e6e8df02c33..d99f47615730 100644
--- a/japanese/postgresql7/files/post-install-notes
+++ b/japanese/postgresql7/files/post-install-notes
@@ -1,24 +1,14 @@
-Now that PostgreSQL-j was installed, you should read the documentation and
+Now that PostgreSQL is installed, you should read the documentation and
implementation guides. These can be found at:
http://www.PostgreSQL.org/docs
-Documentations for the Multibyte-extention can be found at:
-
- doc/README.mb (English)
- doc/README.mb.jp (Japanese)
-
You may wish to subscribe to the PostgreSQL user-support mailing list.
Send an e-mail to pgsql-questions-request@postgresql.org with the
text "subscribe" in the message body.
-If you understand Japanese, you might want to visit:
-
- http://www.sra.co.jp/people/t-ishii/PostgreSQL
-
-to subscribe a local mailing list for Japanese speakers.
-
-If you build PostgreSQL with TCL support, then you can use the
-TCL/TK based database frontend "pgaccess" for database operations.
+If you built PostgreSQL with TCL support, you can install the port
+"pgaccess" to get a TCL/TK based database frontend for database
+operations.
diff --git a/japanese/postgresql7/pkg-comment b/japanese/postgresql7/pkg-comment
index b51d5a751f5a..2125016b133c 100644
--- a/japanese/postgresql7/pkg-comment
+++ b/japanese/postgresql7/pkg-comment
@@ -1 +1 @@
-A robust, next generation, object-relational DBMS plus Multibyte-patch
+A robust, next generation, object-relational DBMS
diff --git a/japanese/postgresql7/pkg-descr b/japanese/postgresql7/pkg-descr
index c8fed1c9b1be..f48a33337e55 100644
--- a/japanese/postgresql7/pkg-descr
+++ b/japanese/postgresql7/pkg-descr
@@ -21,4 +21,4 @@ support mailing list (questions@PostgreSQL.ORG).
PostgreSQL is free and the complete source is available.
-WWW: http://www.PostgreSQL.ORG/
+WWW: http://www.postgresql.org
diff --git a/japanese/postgresql7/pkg-install b/japanese/postgresql7/pkg-install
index 1fb5e347efe5..c46fb4b50e75 100644
--- a/japanese/postgresql7/pkg-install
+++ b/japanese/postgresql7/pkg-install
@@ -1,98 +1,44 @@
-#!/bin/sh
-# an installation script for postgresql
+#! /bin/sh
-check_pw()
-{
- if which -s pw; then
- :
- else
- cat <<EOF
+# $FreeBSD: /tmp/pcvs/ports/japanese/postgresql7/Attic/pkg-install,v 1.4 2000-07-19 01:18:07 kuriyama Exp $
-This system looks like a pre-2.2 version of FreeBSD. We see that it
-is missing the "pw" utility. We need this utility. Please get and
-install it, and try again. You can get the source from:
+PATH=/bin:/usr/sbin
- ftp://ftp.freebsd.org/pub/FreeBSD/FreeBSD-current/src/usr.sbin/pw.tar.gz
-
-EOF
- exit 1
- fi
-}
-
-ask() {
- local question default answer
-
- question=$1
- default=$2
- if [ -z "${PACKAGE_BUILDING}" ]; then
- read -p "${question} (y/n) [${default}]? " answer
- fi
- if [ x${answer} = x ]; then
- answer=${default}
- fi
- echo ${answer}
-}
-
-yesno() {
- local dflt question answer
-
- question=$1
- dflt=$2
- while :; do
- answer=$(ask "${question}" "${dflt}")
- case "${answer}" in
- [Yy]*) return 0;;
- [Nn]*) return 1;;
- esac
- echo "Please answer yes or no."
- done
-}
+if [ -z "${DB_DIR}" ]; then
+ DB_DIR=/usr/local/pgsql/data
+fi
case $2 in
-PRE-INSTALL)
-
- ## Hack /etc/master.passwd ##
- # check
- id_70=`id -nu 70 2> /dev/null`
- id_pgsql=`id -u ${PGSQL_UID} 2> /dev/null`
- if [ X"$id_pgsql" != X ]; then
- exit 0
- elif [ X"$id_70" != X ]; then
- cat <<EOF
-
-+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-This system already has an account whose name is '$id_70' and ID number is 70.
-
- '`id $id_70`'
-
-For PostgreSQL in this port or package, UID:GID of '${PGSQL_UID}' has to be 70:70.
-Please try again after you delete the account.
-+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-EOF
- exit 1
- fi
-
- # add an account of PostgreSQL to this system
- echo ""
- echo "You need a group '${PGSQL_GID}' whose ID number is 70"
- if yesno "Would you like to create it automatically?" y; then
- # We need a command 'pw(8)'
- check_pw
- pw groupadd ${PGSQL_GID} -g 70 || exit
- else
- echo "Please create it, and try again."
- exit 1
- fi
- echo ""
- echo "You need an account '${PGSQL_UID}' whose ID number is 70"
- if yesno "Would you like to create it automatically?" y; then
- # We need a command 'pw(8)'
- check_pw
- pw useradd ${PGSQL_UID} -u 70 -g ${PGSQL_GID} -h - -d ${PKG_PREFIX}/${INSTALL_DIR} \
- -s /bin/sh -c "PostgreSQL pseudo-user" || exit
- else
- echo "Please create it, and try again."
- exit 1
- fi
- ;;
+POST-INSTALL)
+ USER=pgsql
+ GROUP=${USER}
+ UID=89
+ GID=${UID}
+
+ if pw group show "${GROUP}" 2>/dev/null; then
+ echo "You already have a group \"${GROUP}\", so I will use it."
+ else
+ if pw groupadd ${GROUP} -g ${GID}; then
+ echo "Added group \"${GROUP}\"."
+ else
+ echo "Adding group \"${GROUP}\" failed..."
+ exit 1
+ fi
+ fi
+
+ if pw user show "${USER}" 2>/dev/null; then
+ echo "You already have a user \"${USER}\", so I will use it."
+ else
+ if pw useradd ${USER} -u ${UID} -g ${GROUP} -h - \
+ -d ${DB_DIR} -s /sbin/nologin -c "PostgreSQL Daemon"
+ then
+ echo "Added user \"${USER}\"."
+ else
+ echo "Adding user \"${USER}\" failed..."
+ exit 1
+ fi
+ fi
+
+ chown -R ${USER}.${GROUP} ${DB_DIR}
+ ;;
esac
diff --git a/japanese/postgresql7/pkg-plist b/japanese/postgresql7/pkg-plist
index 8e2e081e3d1d..88947ef7b47c 100644
--- a/japanese/postgresql7/pkg-plist
+++ b/japanese/postgresql7/pkg-plist
@@ -1,271 +1,1056 @@
etc/rc.d/pgsql.sh
-%%INSTALL_DIR%%/.profile
-%%INSTALL_DIR%%/bin/cleardbdir
-%%INSTALL_DIR%%/bin/createdb
-%%INSTALL_DIR%%/bin/createlang
-%%INSTALL_DIR%%/bin/createuser
-%%INSTALL_DIR%%/bin/destroydb
-%%INSTALL_DIR%%/bin/destroylang
-%%INSTALL_DIR%%/bin/destroyuser
-%%INSTALL_DIR%%/bin/ecpg
-%%INSTALL_DIR%%/bin/initdb
-%%INSTALL_DIR%%/bin/initlocation
-%%INSTALL_DIR%%/bin/ipcclean
-%%INSTALL_DIR%%/bin/pg_dump
-%%INSTALL_DIR%%/bin/pg_dumpall
-%%INSTALL_DIR%%/bin/pg_id
-%%INSTALL_DIR%%/bin/pg_passwd
-%%INSTALL_DIR%%/bin/pg_upgrade
-%%INSTALL_DIR%%/bin/pg_version
-%%INSTALL_DIR%%/bin/postgres
-%%INSTALL_DIR%%/bin/postmaster
-%%INSTALL_DIR%%/bin/psql
-%%INSTALL_DIR%%/bin/vacuumdb
-%%INSTALL_DIR%%/lib/global1.bki.source
-%%INSTALL_DIR%%/lib/global1.description
-%%INSTALL_DIR%%/lib/libecpg.a
-%%INSTALL_DIR%%/lib/libecpg.so
-%%INSTALL_DIR%%/lib/libecpg.so.3
-%%INSTALL_DIR%%/lib/libpq++.a
-%%INSTALL_DIR%%/lib/libpq++.so
-%%INSTALL_DIR%%/lib/libpq++.so.3
-%%INSTALL_DIR%%/lib/libpq.a
-%%INSTALL_DIR%%/lib/libpq.so
-%%INSTALL_DIR%%/lib/libpq.so.2
-%%INSTALL_DIR%%/lib/local1_template1.bki.source
-%%INSTALL_DIR%%/lib/local1_template1.description
-%%INSTALL_DIR%%/lib/pg_geqo.sample
-%%INSTALL_DIR%%/lib/pg_hba.conf.sample
-%%INSTALL_DIR%%/lib/plpgsql.so
-%%INSTALL_DIR%%/include/c.h
-%%INSTALL_DIR%%/include/config.h
-%%INSTALL_DIR%%/include/ecpgerrno.h
-%%INSTALL_DIR%%/include/ecpglib.h
-%%INSTALL_DIR%%/include/ecpgtype.h
-%%INSTALL_DIR%%/include/fmgr.h
-%%INSTALL_DIR%%/include/libpq++.H
-%%INSTALL_DIR%%/include/libpq-fe.h
-%%INSTALL_DIR%%/include/libpq-int.h
-%%INSTALL_DIR%%/include/os.h
-%%INSTALL_DIR%%/include/postgres.h
-%%INSTALL_DIR%%/include/postgres_ext.h
-%%INSTALL_DIR%%/include/sqlca.h
-%%INSTALL_DIR%%/include/access/attnum.h
-%%INSTALL_DIR%%/include/commands/trigger.h
-%%INSTALL_DIR%%/include/executor/spi.h
-%%INSTALL_DIR%%/include/lib/dllist.h
-%%INSTALL_DIR%%/include/libpq/pqcomm.h
-%%INSTALL_DIR%%/include/libpq/libpq-fs.h
-%%INSTALL_DIR%%/include/libpq++/pgconnection.h
-%%INSTALL_DIR%%/include/libpq++/pgcursordb.h
-%%INSTALL_DIR%%/include/libpq++/pgdatabase.h
-%%INSTALL_DIR%%/include/libpq++/pglobject.h
-%%INSTALL_DIR%%/include/libpq++/pgtransdb.h
-%%INSTALL_DIR%%/include/utils/elog.h
-%%INSTALL_DIR%%/include/utils/geo_decls.h
-%%INSTALL_DIR%%/include/utils/mcxt.h
-%%INSTALL_DIR%%/include/utils/palloc.h
-%%INSTALL_DIR%%/post-install-notes
-share/doc/%%INSTALL_DIR%%/src/graphics/catalogs.ag
-share/doc/%%INSTALL_DIR%%/src/graphics/catalogs.cgm
-share/doc/%%INSTALL_DIR%%/src/graphics/catalogs.gif
-share/doc/%%INSTALL_DIR%%/src/graphics/catalogs.ps
-share/doc/%%INSTALL_DIR%%/src/graphics/clientserver.ag
-share/doc/%%INSTALL_DIR%%/src/graphics/clientserver.gif
-share/doc/%%INSTALL_DIR%%/src/graphics/connections.ag
-share/doc/%%INSTALL_DIR%%/src/graphics/connections.gif
-share/doc/%%INSTALL_DIR%%/src/graphics/layout.ag
-share/doc/%%INSTALL_DIR%%/src/graphics/layout.gif
-share/doc/%%INSTALL_DIR%%/src/sgml/Makefile
-share/doc/%%INSTALL_DIR%%/src/sgml/about.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/admin.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/advanced.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/arch-dev.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/arch-pg.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/arch.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/array.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/biblio.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/bki.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/compiler.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/config.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/contacts.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/cvs.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/datatype.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/datetime.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/dfunc.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/docguide.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ecpg.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/environ.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/extend.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/func-ref.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/func.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/geqo.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/gist.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/history.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/indices.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/info.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/inherit.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/install-win32.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/install.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/installation.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/intro-ag.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/intro-pg.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/intro.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/jdbc.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/keys.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/layout.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/legal.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/libpgtcl.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/libpq++.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/libpq.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/lobj.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/manage.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/manage-ag.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/mvcc.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/notation.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/odbc.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/oper.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/page.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/pg_options.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ports.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/postgres.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/programmer.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/protocol.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/query.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/recovery.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/reference.ced
-share/doc/%%INSTALL_DIR%%/src/sgml/reference.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/regress.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/release.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/rules.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/runtime.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/security.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/signals.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/spi.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/sql.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/start-ag.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/start.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/storage.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/syntax.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/trigger.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/trouble.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/tutorial.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/typeconv.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/user.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/xaggr.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/xfunc.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/xindex.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/xoper.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/xplang.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/xtypes.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/y2k.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/abort.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/allfiles.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/alter_table.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/alter_user.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/begin.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/close.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/cluster.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/commands.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/commit.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/copy.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_aggregate.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_database.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_function.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_index.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_language.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_operator.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_rule.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_sequence.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_table.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_table_as.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_trigger.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_type.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_user.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/create_view.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/createdb.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/createuser.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/current_date.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/current_time.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/current_timestamp.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/current_user.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/declare.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/delete.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/destroydb.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/destroyuser.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_aggregate.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_database.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_function.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_index.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_language.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_operator.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_rule.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_sequence.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_table.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_trigger.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_type.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_user.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/drop_view.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/explain.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/fetch.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/grant.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/initdb.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/initlocation.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/insert.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/listen.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/load.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/lock.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/move.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/notify.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/pg_dump.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/pg_dumpall.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/pg_upgrade.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/pgaccess-ref.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/pgadmin-ref.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/postgres-ref.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/postmaster.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/psql-ref.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/reset.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/revoke.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/rollback.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/select.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/select_into.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/set.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/show.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/unlisten.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/update.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/vacuum.sgml
-share/doc/%%INSTALL_DIR%%/src/sgml/ref/vacuumdb.sgml
-share/doc/%%INSTALL_DIR%%/src/Makefile
-share/doc/%%INSTALL_DIR%%/user.tar.gz
-share/doc/%%INSTALL_DIR%%/internals.ps
-share/doc/%%INSTALL_DIR%%/user.ps.gz
-share/doc/%%INSTALL_DIR%%/tutorial.tar.gz
-share/doc/%%INSTALL_DIR%%/tutorial.ps.gz
-share/doc/%%INSTALL_DIR%%/programmer.tar.gz
-share/doc/%%INSTALL_DIR%%/programmer.ps.gz
-share/doc/%%INSTALL_DIR%%/postgres.tar.gz
-share/doc/%%INSTALL_DIR%%/bug.template
-share/doc/%%INSTALL_DIR%%/admin.tar.gz
-share/doc/%%INSTALL_DIR%%/admin.ps.gz
-share/doc/%%INSTALL_DIR%%/TODO
-share/doc/%%INSTALL_DIR%%/README.fsync
-share/doc/%%INSTALL_DIR%%/README.inet
-share/doc/%%INSTALL_DIR%%/README.locale
-share/doc/%%INSTALL_DIR%%/README.mb
-share/doc/%%INSTALL_DIR%%/README.mb.jp
-share/doc/%%INSTALL_DIR%%/Makefile
-share/doc/%%INSTALL_DIR%%/FAQ
-share/doc/%%INSTALL_DIR%%/FAQ_AIX
-share/doc/%%INSTALL_DIR%%/FAQ_DEV
-share/doc/%%INSTALL_DIR%%/FAQ_DigitalUnix
-share/doc/%%INSTALL_DIR%%/FAQ_FreeBSD
-share/doc/%%INSTALL_DIR%%/FAQ_HPUX
-share/doc/%%INSTALL_DIR%%/FAQ_Irix
-share/doc/%%INSTALL_DIR%%/FAQ_Linux
-share/doc/%%INSTALL_DIR%%/FAQ_SCO
-share/doc/%%INSTALL_DIR%%/FAQ_Solaris
-share/doc/%%INSTALL_DIR%%/KNOWN_BUGS
-share/doc/%%INSTALL_DIR%%/MISSING_FEATURES
-share/doc/%%INSTALL_DIR%%/README.Charsets
-share/doc/%%INSTALL_DIR%%/README.NT
+pgsql/.profile
+pgsql/bin/createdb
+pgsql/bin/createlang
+pgsql/bin/createuser
+pgsql/bin/dropdb
+pgsql/bin/droplang
+pgsql/bin/dropuser
+pgsql/bin/ecpg
+pgsql/bin/initdb
+pgsql/bin/initlocation
+pgsql/bin/ipcclean
+pgsql/bin/pg_ctl
+pgsql/bin/pg_dump
+pgsql/bin/pg_dumpall
+pgsql/bin/pg_id
+pgsql/bin/pg_passwd
+pgsql/bin/pg_upgrade
+pgsql/bin/pg_version
+pgsql/bin/postgres
+pgsql/bin/postmaster
+pgsql/bin/psql
+pgsql/bin/vacuumdb
+pgsql/data/PG_VERSION
+pgsql/data/base/template1/PG_VERSION
+pgsql/data/base/template1/pg_aggregate
+pgsql/data/base/template1/pg_aggregate_name_type_index
+pgsql/data/base/template1/pg_am
+pgsql/data/base/template1/pg_am_name_index
+pgsql/data/base/template1/pg_amop
+pgsql/data/base/template1/pg_amop_opid_index
+pgsql/data/base/template1/pg_amop_strategy_index
+pgsql/data/base/template1/pg_amproc
+pgsql/data/base/template1/pg_attrdef
+pgsql/data/base/template1/pg_attrdef_adrelid_index
+pgsql/data/base/template1/pg_attribute
+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_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_index_indexrelid_index
+pgsql/data/base/template1/pg_indexes
+pgsql/data/base/template1/pg_inheritproc
+pgsql/data/base/template1/pg_inherits
+pgsql/data/base/template1/pg_inherits_relid_seqno_index
+pgsql/data/base/template1/pg_ipl
+pgsql/data/base/template1/pg_language
+pgsql/data/base/template1/pg_language_name_index
+pgsql/data/base/template1/pg_language_oid_index
+pgsql/data/base/template1/pg_listener
+pgsql/data/base/template1/pg_listener_relname_pid_index
+pgsql/data/base/template1/pg_opclass
+pgsql/data/base/template1/pg_opclass_deftype_index
+pgsql/data/base/template1/pg_opclass_name_index
+pgsql/data/base/template1/pg_operator
+pgsql/data/base/template1/pg_operator_oid_index
+pgsql/data/base/template1/pg_operator_oprname_l_r_k_index
+pgsql/data/base/template1/pg_proc
+pgsql/data/base/template1/pg_proc_oid_index
+pgsql/data/base/template1/pg_proc_proname_narg_type_index
+pgsql/data/base/template1/pg_relcheck
+pgsql/data/base/template1/pg_relcheck_rcrelid_index
+pgsql/data/base/template1/pg_rewrite
+pgsql/data/base/template1/pg_rewrite_oid_index
+pgsql/data/base/template1/pg_rewrite_rulename_index
+pgsql/data/base/template1/pg_rules
+pgsql/data/base/template1/pg_statistic
+pgsql/data/base/template1/pg_statistic_relid_att_index
+pgsql/data/base/template1/pg_tables
+pgsql/data/base/template1/pg_trigger
+pgsql/data/base/template1/pg_trigger_tgconstrname_index
+pgsql/data/base/template1/pg_trigger_tgconstrrelid_index
+pgsql/data/base/template1/pg_trigger_tgrelid_index
+pgsql/data/base/template1/pg_type
+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_views
+pgsql/data/pg_control
+pgsql/data/pg_database
+pgsql/data/pg_geqo.sample
+pgsql/data/pg_group
+pgsql/data/pg_group_name_index
+pgsql/data/pg_group_sysid_index
+pgsql/data/pg_hba.conf
+pgsql/data/pg_log
+pgsql/data/pg_shadow
+pgsql/data/pg_variable
+pgsql/data/postmaster.opts.default
+pgsql/include/access/attnum.h
+pgsql/include/c.h
+pgsql/include/commands/trigger.h
+pgsql/include/config.h
+pgsql/include/ecpgerrno.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/libpgeasy.h
+pgsql/include/libpq++.h
+pgsql/include/libpq++/pgconnection.h
+pgsql/include/libpq++/pgcursordb.h
+pgsql/include/libpq++/pgdatabase.h
+pgsql/include/libpq++/pglobject.h
+pgsql/include/libpq++/pgtransdb.h
+pgsql/include/libpq-fe.h
+pgsql/include/libpq-int.h
+pgsql/include/libpq/libpq-fs.h
+pgsql/include/libpq/pqcomm.h
+pgsql/include/os.h
+pgsql/include/postgres.h
+pgsql/include/postgres_ext.h
+pgsql/include/pqexpbuffer.h
+pgsql/include/sql3types.h
+pgsql/include/sqlca.h
+pgsql/include/utils/elog.h
+pgsql/include/utils/geo_decls.h
+pgsql/include/utils/mcxt.h
+pgsql/include/utils/palloc.h
+pgsql/lib/global1.bki.source
+pgsql/lib/global1.description
+pgsql/lib/libecpg.a
+pgsql/lib/libecpg.so
+pgsql/lib/libecpg.so.3
+pgsql/lib/libpgeasy.a
+pgsql/lib/libpgeasy.so
+pgsql/lib/libpgeasy.so.2
+pgsql/lib/libpq++.a
+pgsql/lib/libpq++.so
+pgsql/lib/libpq++.so.3
+pgsql/lib/libpq.a
+pgsql/lib/libpq.so
+pgsql/lib/libpq.so.2
+pgsql/lib/local1_template1.bki.source
+pgsql/lib/local1_template1.description
+pgsql/lib/pg_geqo.sample
+pgsql/lib/pg_ident.conf.sample
+pgsql/lib/pg_hba.conf.sample
+pgsql/lib/pg_options.sample
+pgsql/lib/plpgsql.so
+pgsql/lib/postmaster.opts.default.sample
+@exec /usr/bin/env OBJFORMAT=%%PORTOBJFORMAT%% /sbin/ldconfig -m %B
+@unexec /usr/bin/env OBJFORMAT=%%PORTOBJFORMAT%% /sbin/ldconfig -R
+pgsql/post-install-notes
+share/doc/pgsql/FAQ
+share/doc/pgsql/FAQ_AIX
+share/doc/pgsql/FAQ_BSDI
+share/doc/pgsql/FAQ_DEV
+share/doc/pgsql/FAQ_DigitalUnix
+share/doc/pgsql/FAQ_FreeBSD
+share/doc/pgsql/FAQ_HPUX
+share/doc/pgsql/FAQ_Irix
+share/doc/pgsql/FAQ_Linux
+share/doc/pgsql/FAQ_QNX4
+share/doc/pgsql/FAQ_SCO
+share/doc/pgsql/FAQ_Solaris
+share/doc/pgsql/README.Charsets
+share/doc/pgsql/README.NT
+share/doc/pgsql/README.fsync
+share/doc/pgsql/README.inet
+share/doc/pgsql/README.locale
+share/doc/pgsql/README.mb
+share/doc/pgsql/README.mb.jp
+share/doc/pgsql/TODO
+share/doc/pgsql/internals.ps
+share/doc/pgsql/admin/admin.htm
+share/doc/pgsql/admin/admin.html
+share/doc/pgsql/admin/biblio.htm
+share/doc/pgsql/admin/c573.htm
+share/doc/pgsql/admin/c573602.htm
+share/doc/pgsql/admin/c573680.htm
+share/doc/pgsql/admin/c573717.htm
+share/doc/pgsql/admin/copyright.htm
+share/doc/pgsql/admin/disk.htm
+share/doc/pgsql/admin/index.html
+share/doc/pgsql/admin/install-win32.htm
+share/doc/pgsql/admin/install-win321073.htm
+share/doc/pgsql/admin/install-win321082.htm
+share/doc/pgsql/admin/install.htm
+share/doc/pgsql/admin/install855.htm
+share/doc/pgsql/admin/intro-ag.htm
+share/doc/pgsql/admin/intro-ag162.htm
+share/doc/pgsql/admin/layout.gif
+share/doc/pgsql/admin/layout.htm
+share/doc/pgsql/admin/manage-ag.htm
+share/doc/pgsql/admin/manage-ag1604.htm
+share/doc/pgsql/admin/manage-ag1646.htm
+share/doc/pgsql/admin/manage-ag1655.htm
+share/doc/pgsql/admin/newuser.htm
+share/doc/pgsql/admin/notation.htm
+share/doc/pgsql/admin/pg-options.htm
+share/doc/pgsql/admin/ports.htm
+share/doc/pgsql/admin/ports481.htm
+share/doc/pgsql/admin/postmaster.htm
+share/doc/pgsql/admin/preface.htm
+share/doc/pgsql/admin/recovery.htm
+share/doc/pgsql/admin/regress.htm
+share/doc/pgsql/admin/regress1861.htm
+share/doc/pgsql/admin/regress1895.htm
+share/doc/pgsql/admin/regress1941.htm
+share/doc/pgsql/admin/release.htm
+share/doc/pgsql/admin/release2009.htm
+share/doc/pgsql/admin/release2020.htm
+share/doc/pgsql/admin/release2031.htm
+share/doc/pgsql/admin/release2042.htm
+share/doc/pgsql/admin/release2124.htm
+share/doc/pgsql/admin/release2135.htm
+share/doc/pgsql/admin/release2146.htm
+share/doc/pgsql/admin/release2187.htm
+share/doc/pgsql/admin/release2203.htm
+share/doc/pgsql/admin/release2222.htm
+share/doc/pgsql/admin/release2266.htm
+share/doc/pgsql/admin/release2288.htm
+share/doc/pgsql/admin/release2303.htm
+share/doc/pgsql/admin/release2312.htm
+share/doc/pgsql/admin/release2335.htm
+share/doc/pgsql/admin/release2349.htm
+share/doc/pgsql/admin/release2352.htm
+share/doc/pgsql/admin/release2377.htm
+share/doc/pgsql/admin/release2414.htm
+share/doc/pgsql/admin/release2421.htm
+share/doc/pgsql/admin/release2428.htm
+share/doc/pgsql/admin/release2435.htm
+share/doc/pgsql/admin/release2439.htm
+share/doc/pgsql/admin/runtime.htm
+share/doc/pgsql/admin/security.htm
+share/doc/pgsql/admin/security1450.htm
+share/doc/pgsql/admin/security1485.htm
+share/doc/pgsql/admin/security1509.htm
+share/doc/pgsql/admin/security1530.htm
+share/doc/pgsql/admin/terminology.htm
+share/doc/pgsql/admin/trouble.htm
+share/doc/pgsql/admin/trouble1721.htm
+share/doc/pgsql/admin/trouble1738.htm
+share/doc/pgsql/admin/y2k.htm
+share/doc/pgsql/postgres/about.htm
+share/doc/pgsql/postgres/advanced.htm
+share/doc/pgsql/postgres/advanced27923.htm
+share/doc/pgsql/postgres/advanced27945.htm
+share/doc/pgsql/postgres/app-createdb.htm
+share/doc/pgsql/postgres/app-createlang.htm
+share/doc/pgsql/postgres/app-createuser.htm
+share/doc/pgsql/postgres/app-dropdb.htm
+share/doc/pgsql/postgres/app-droplang.htm
+share/doc/pgsql/postgres/app-dropuser.htm
+share/doc/pgsql/postgres/app-ecpg.htm
+share/doc/pgsql/postgres/app-initdb.htm
+share/doc/pgsql/postgres/app-initlocation.htm
+share/doc/pgsql/postgres/app-ipcclean.htm
+share/doc/pgsql/postgres/app-pg-passwd.htm
+share/doc/pgsql/postgres/app-pg-upgrade.htm
+share/doc/pgsql/postgres/app-pgaccess.htm
+share/doc/pgsql/postgres/app-pgadmin.htm
+share/doc/pgsql/postgres/app-pgctl.htm
+share/doc/pgsql/postgres/app-pgdump.htm
+share/doc/pgsql/postgres/app-pgdumpall.htm
+share/doc/pgsql/postgres/app-pgtclsh.htm
+share/doc/pgsql/postgres/app-pgtksh.htm
+share/doc/pgsql/postgres/app-postgres.htm
+share/doc/pgsql/postgres/app-postmaster.htm
+share/doc/pgsql/postgres/app-psql.htm
+share/doc/pgsql/postgres/app-vacuumdb.htm
+share/doc/pgsql/postgres/applications.htm
+share/doc/pgsql/postgres/arch-pg.htm
+share/doc/pgsql/postgres/arch.htm
+share/doc/pgsql/postgres/arrays.htm
+share/doc/pgsql/postgres/biblio.htm
+share/doc/pgsql/postgres/bki.htm
+share/doc/pgsql/postgres/bki26573.htm
+share/doc/pgsql/postgres/bki26657.htm
+share/doc/pgsql/postgres/bki26681.htm
+share/doc/pgsql/postgres/bki26742.htm
+share/doc/pgsql/postgres/c16883.htm
+share/doc/pgsql/postgres/c1688316912.htm
+share/doc/pgsql/postgres/c1688316990.htm
+share/doc/pgsql/postgres/c1688317027.htm
+share/doc/pgsql/postgres/c19986.htm
+share/doc/pgsql/postgres/c21722.htm
+share/doc/pgsql/postgres/c2172221764.htm
+share/doc/pgsql/postgres/c2172221782.htm
+share/doc/pgsql/postgres/c2172221924.htm
+share/doc/pgsql/postgres/c2172221936.htm
+share/doc/pgsql/postgres/c2172221956.htm
+share/doc/pgsql/postgres/c2172221961.htm
+share/doc/pgsql/postgres/c25129.htm
+share/doc/pgsql/postgres/c4091.htm
+share/doc/pgsql/postgres/c40914117.htm
+share/doc/pgsql/postgres/c40914344.htm
+share/doc/pgsql/postgres/c4362.htm
+share/doc/pgsql/postgres/c43624375.htm
+share/doc/pgsql/postgres/c4888.htm
+share/doc/pgsql/postgres/c4933.htm
+share/doc/pgsql/postgres/c49334943.htm
+share/doc/pgsql/postgres/c49334947.htm
+share/doc/pgsql/postgres/catalogs.gif
+share/doc/pgsql/postgres/clientserver.gif
+share/doc/pgsql/postgres/compiler.htm
+share/doc/pgsql/postgres/connections.gif
+share/doc/pgsql/postgres/copyright.htm
+share/doc/pgsql/postgres/cvs.htm
+share/doc/pgsql/postgres/cvs28436.htm
+share/doc/pgsql/postgres/cvs28492.htm
+share/doc/pgsql/postgres/datatype.htm
+share/doc/pgsql/postgres/datatype1038.htm
+share/doc/pgsql/postgres/datatype1070.htm
+share/doc/pgsql/postgres/datatype1134.htm
+share/doc/pgsql/postgres/datatype1649.htm
+share/doc/pgsql/postgres/datatype1681.htm
+share/doc/pgsql/postgres/datatype1920.htm
+share/doc/pgsql/postgres/datetime-appendix.htm
+share/doc/pgsql/postgres/datetime-appendix28356.htm
+share/doc/pgsql/postgres/dfunc.htm
+share/doc/pgsql/postgres/dfunc20136.htm
+share/doc/pgsql/postgres/dfunc20146.htm
+share/doc/pgsql/postgres/disk.htm
+share/doc/pgsql/postgres/docguide.htm
+share/doc/pgsql/postgres/docguide28718.htm
+share/doc/pgsql/postgres/docguide28749.htm
+share/doc/pgsql/postgres/docguide28840.htm
+share/doc/pgsql/postgres/docguide28861.htm
+share/doc/pgsql/postgres/docguide28887.htm
+share/doc/pgsql/postgres/docguide29024.htm
+share/doc/pgsql/postgres/docguide29362.htm
+share/doc/pgsql/postgres/environ.htm
+share/doc/pgsql/postgres/extend.htm
+share/doc/pgsql/postgres/extend18852.htm
+share/doc/pgsql/postgres/extend18864.htm
+share/doc/pgsql/postgres/func-ref.htm
+share/doc/pgsql/postgres/functions.htm
+share/doc/pgsql/postgres/functions2593.htm
+share/doc/pgsql/postgres/functions2733.htm
+share/doc/pgsql/postgres/functions2876.htm
+share/doc/pgsql/postgres/functions2976.htm
+share/doc/pgsql/postgres/functions3443.htm
+share/doc/pgsql/postgres/functions3641.htm
+share/doc/pgsql/postgres/geqo-biblio.htm
+share/doc/pgsql/postgres/geqo.htm
+share/doc/pgsql/postgres/geqo25594.htm
+share/doc/pgsql/postgres/geqo25617.htm
+share/doc/pgsql/postgres/geqo25655.htm
+share/doc/pgsql/postgres/gist.htm
+share/doc/pgsql/postgres/index.html
+share/doc/pgsql/postgres/indices.htm
+share/doc/pgsql/postgres/inherit.htm
+share/doc/pgsql/postgres/install-win32.htm
+share/doc/pgsql/postgres/install-win3217383.htm
+share/doc/pgsql/postgres/install-win3217392.htm
+share/doc/pgsql/postgres/install.htm
+share/doc/pgsql/postgres/install17165.htm
+share/doc/pgsql/postgres/intro.htm
+share/doc/pgsql/postgres/intro176.htm
+share/doc/pgsql/postgres/intro304.htm
+share/doc/pgsql/postgres/intro60.htm
+share/doc/pgsql/postgres/jdbc.htm
+share/doc/pgsql/postgres/jdbc24909.htm
+share/doc/pgsql/postgres/jdbc24921.htm
+share/doc/pgsql/postgres/jdbc24927.htm
+share/doc/pgsql/postgres/jdbc24935.htm
+share/doc/pgsql/postgres/jdbc24953.htm
+share/doc/pgsql/postgres/jdbc24990.htm
+share/doc/pgsql/postgres/jdbc25021.htm
+share/doc/pgsql/postgres/jdbc25026.htm
+share/doc/pgsql/postgres/jdbc25030.htm
+share/doc/pgsql/postgres/jdbc25056.htm
+share/doc/pgsql/postgres/jdbc25086.htm
+share/doc/pgsql/postgres/largeobjects.htm
+share/doc/pgsql/postgres/largeobjects21625.htm
+share/doc/pgsql/postgres/largeobjects21628.htm
+share/doc/pgsql/postgres/largeobjects21707.htm
+share/doc/pgsql/postgres/largeobjects21714.htm
+share/doc/pgsql/postgres/largeobjects21718.htm
+share/doc/pgsql/postgres/layout.gif
+share/doc/pgsql/postgres/layout.htm
+share/doc/pgsql/postgres/libpq-chapter.htm
+share/doc/pgsql/postgres/libpq-chapter22422.htm
+share/doc/pgsql/postgres/libpq-chapter22577.htm
+share/doc/pgsql/postgres/libpq-chapter22724.htm
+share/doc/pgsql/postgres/libpq-chapter22736.htm
+share/doc/pgsql/postgres/libpq-chapter22774.htm
+share/doc/pgsql/postgres/libpq-chapter22844.htm
+share/doc/pgsql/postgres/libpq-chapter22857.htm
+share/doc/pgsql/postgres/libpq-chapter22942.htm
+share/doc/pgsql/postgres/libpq-envars.htm
+share/doc/pgsql/postgres/libpq-threading.htm
+share/doc/pgsql/postgres/libpqplusplus.htm
+share/doc/pgsql/postgres/libpqplusplus23034.htm
+share/doc/pgsql/postgres/libpqplusplus23044.htm
+share/doc/pgsql/postgres/libpqplusplus23074.htm
+share/doc/pgsql/postgres/libpqplusplus23179.htm
+share/doc/pgsql/postgres/libpqplusplus23202.htm
+share/doc/pgsql/postgres/lisp.htm
+share/doc/pgsql/postgres/manage-ag.htm
+share/doc/pgsql/postgres/manage-ag17914.htm
+share/doc/pgsql/postgres/manage-ag17956.htm
+share/doc/pgsql/postgres/manage-ag17965.htm
+share/doc/pgsql/postgres/manage.htm
+share/doc/pgsql/postgres/manage4814.htm
+share/doc/pgsql/postgres/manage4838.htm
+share/doc/pgsql/postgres/manage4880.htm
+share/doc/pgsql/postgres/mvcc.htm
+share/doc/pgsql/postgres/mvcc4568.htm
+share/doc/pgsql/postgres/mvcc4621.htm
+share/doc/pgsql/postgres/mvcc4633.htm
+share/doc/pgsql/postgres/mvcc4646.htm
+share/doc/pgsql/postgres/mvcc4723.htm
+share/doc/pgsql/postgres/mvcc4744.htm
+share/doc/pgsql/postgres/newuser.htm
+share/doc/pgsql/postgres/notation.htm
+share/doc/pgsql/postgres/odbc.htm
+share/doc/pgsql/postgres/odbc24433.htm
+share/doc/pgsql/postgres/odbc24471.htm
+share/doc/pgsql/postgres/odbc24644.htm
+share/doc/pgsql/postgres/odbc24666.htm
+share/doc/pgsql/postgres/operators.htm
+share/doc/pgsql/postgres/operators2127.htm
+share/doc/pgsql/postgres/operators2198.htm
+share/doc/pgsql/postgres/operators2267.htm
+share/doc/pgsql/postgres/operators2377.htm
+share/doc/pgsql/postgres/operators2436.htm
+share/doc/pgsql/postgres/operators2490.htm
+share/doc/pgsql/postgres/overview.htm
+share/doc/pgsql/postgres/overview25194.htm
+share/doc/pgsql/postgres/overview25219.htm
+share/doc/pgsql/postgres/overview25347.htm
+share/doc/pgsql/postgres/overview25403.htm
+share/doc/pgsql/postgres/overview25457.htm
+share/doc/pgsql/postgres/page.htm
+share/doc/pgsql/postgres/page26805.htm
+share/doc/pgsql/postgres/page26819.htm
+share/doc/pgsql/postgres/part-admin.htm
+share/doc/pgsql/postgres/part-appendix.htm
+share/doc/pgsql/postgres/part-developer.htm
+share/doc/pgsql/postgres/part-interfaces.htm
+share/doc/pgsql/postgres/part-programmer.htm
+share/doc/pgsql/postgres/part-tutorial.htm
+share/doc/pgsql/postgres/part-user.htm
+share/doc/pgsql/postgres/partial-index.htm
+share/doc/pgsql/postgres/pg-options-dev.htm
+share/doc/pgsql/postgres/pg-options.htm
+share/doc/pgsql/postgres/pgeasy-chapter.htm
+share/doc/pgsql/postgres/pgtcl-pgconndefaults.htm
+share/doc/pgsql/postgres/pgtcl-pgconnect.htm
+share/doc/pgsql/postgres/pgtcl-pgdisconnect.htm
+share/doc/pgsql/postgres/pgtcl-pgexec.htm
+share/doc/pgsql/postgres/pgtcl-pglisten.htm
+share/doc/pgsql/postgres/pgtcl-pgloclose.htm
+share/doc/pgsql/postgres/pgtcl-pglocreat.htm
+share/doc/pgsql/postgres/pgtcl-pgloexport.htm
+share/doc/pgsql/postgres/pgtcl-pgloimport.htm
+share/doc/pgsql/postgres/pgtcl-pglolseek.htm
+share/doc/pgsql/postgres/pgtcl-pgloopen.htm
+share/doc/pgsql/postgres/pgtcl-pgloread.htm
+share/doc/pgsql/postgres/pgtcl-pglotell.htm
+share/doc/pgsql/postgres/pgtcl-pglounlink.htm
+share/doc/pgsql/postgres/pgtcl-pglowrite.htm
+share/doc/pgsql/postgres/pgtcl-pgresult.htm
+share/doc/pgsql/postgres/pgtcl-pgselect.htm
+share/doc/pgsql/postgres/pgtcl.htm
+share/doc/pgsql/postgres/pgtcl23317.htm
+share/doc/pgsql/postgres/pgtcl23321.htm
+share/doc/pgsql/postgres/pl-perl.htm
+share/doc/pgsql/postgres/pl-perl4533.htm
+share/doc/pgsql/postgres/pl-perl4542.htm
+share/doc/pgsql/postgres/ports.htm
+share/doc/pgsql/postgres/ports16791.htm
+share/doc/pgsql/postgres/postgres.htm
+share/doc/pgsql/postgres/postgres.html
+share/doc/pgsql/postgres/postmaster.htm
+share/doc/pgsql/postgres/preface.htm
+share/doc/pgsql/postgres/protocol.htm
+share/doc/pgsql/postgres/protocol25770.htm
+share/doc/pgsql/postgres/protocol25925.htm
+share/doc/pgsql/postgres/protocol25962.htm
+share/doc/pgsql/postgres/query.htm
+share/doc/pgsql/postgres/query27752.htm
+share/doc/pgsql/postgres/query27768.htm
+share/doc/pgsql/postgres/query27790.htm
+share/doc/pgsql/postgres/query27799.htm
+share/doc/pgsql/postgres/query27817.htm
+share/doc/pgsql/postgres/query27825.htm
+share/doc/pgsql/postgres/query27844.htm
+share/doc/pgsql/postgres/query27849.htm
+share/doc/pgsql/postgres/query27856.htm
+share/doc/pgsql/postgres/recovery.htm
+share/doc/pgsql/postgres/regress.htm
+share/doc/pgsql/postgres/regress18171.htm
+share/doc/pgsql/postgres/regress18205.htm
+share/doc/pgsql/postgres/regress18251.htm
+share/doc/pgsql/postgres/release.htm
+share/doc/pgsql/postgres/release18319.htm
+share/doc/pgsql/postgres/release18330.htm
+share/doc/pgsql/postgres/release18341.htm
+share/doc/pgsql/postgres/release18352.htm
+share/doc/pgsql/postgres/release18434.htm
+share/doc/pgsql/postgres/release18445.htm
+share/doc/pgsql/postgres/release18456.htm
+share/doc/pgsql/postgres/release18497.htm
+share/doc/pgsql/postgres/release18513.htm
+share/doc/pgsql/postgres/release18532.htm
+share/doc/pgsql/postgres/release18576.htm
+share/doc/pgsql/postgres/release18598.htm
+share/doc/pgsql/postgres/release18613.htm
+share/doc/pgsql/postgres/release18622.htm
+share/doc/pgsql/postgres/release18645.htm
+share/doc/pgsql/postgres/release18659.htm
+share/doc/pgsql/postgres/release18662.htm
+share/doc/pgsql/postgres/release18687.htm
+share/doc/pgsql/postgres/release18724.htm
+share/doc/pgsql/postgres/release18731.htm
+share/doc/pgsql/postgres/release18738.htm
+share/doc/pgsql/postgres/release18745.htm
+share/doc/pgsql/postgres/release18749.htm
+share/doc/pgsql/postgres/rules.htm
+share/doc/pgsql/postgres/rules19478.htm
+share/doc/pgsql/postgres/rules19639.htm
+share/doc/pgsql/postgres/rules19770.htm
+share/doc/pgsql/postgres/rules19784.htm
+share/doc/pgsql/postgres/runtime.htm
+share/doc/pgsql/postgres/security.htm
+share/doc/pgsql/postgres/security17760.htm
+share/doc/pgsql/postgres/security17795.htm
+share/doc/pgsql/postgres/security17819.htm
+share/doc/pgsql/postgres/security17840.htm
+share/doc/pgsql/postgres/signals.htm
+share/doc/pgsql/postgres/spi-spiconnect.htm
+share/doc/pgsql/postgres/spi-spicopytuple.htm
+share/doc/pgsql/postgres/spi-spiexec.htm
+share/doc/pgsql/postgres/spi-spiexecp.htm
+share/doc/pgsql/postgres/spi-spifinish.htm
+share/doc/pgsql/postgres/spi-spifname.htm
+share/doc/pgsql/postgres/spi-spifnumber.htm
+share/doc/pgsql/postgres/spi-spigetbinval.htm
+share/doc/pgsql/postgres/spi-spigetrelname.htm
+share/doc/pgsql/postgres/spi-spigettype.htm
+share/doc/pgsql/postgres/spi-spigettypeid.htm
+share/doc/pgsql/postgres/spi-spigetvalue.htm
+share/doc/pgsql/postgres/spi-spimodifytuple.htm
+share/doc/pgsql/postgres/spi-spipalloc.htm
+share/doc/pgsql/postgres/spi-spipfree.htm
+share/doc/pgsql/postgres/spi-spiprepare.htm
+share/doc/pgsql/postgres/spi-spirepalloc.htm
+share/doc/pgsql/postgres/spi-spisaveplan.htm
+share/doc/pgsql/postgres/spi.htm
+share/doc/pgsql/postgres/spi20808.htm
+share/doc/pgsql/postgres/spi21521.htm
+share/doc/pgsql/postgres/spi21543.htm
+share/doc/pgsql/postgres/spi21548.htm
+share/doc/pgsql/postgres/sql-abort.htm
+share/doc/pgsql/postgres/sql-altergroup.htm
+share/doc/pgsql/postgres/sql-altertable.htm
+share/doc/pgsql/postgres/sql-alteruser.htm
+share/doc/pgsql/postgres/sql-begin.htm
+share/doc/pgsql/postgres/sql-close.htm
+share/doc/pgsql/postgres/sql-cluster.htm
+share/doc/pgsql/postgres/sql-commands.htm
+share/doc/pgsql/postgres/sql-comment.htm
+share/doc/pgsql/postgres/sql-commit.htm
+share/doc/pgsql/postgres/sql-copy.htm
+share/doc/pgsql/postgres/sql-createaggregate.htm
+share/doc/pgsql/postgres/sql-createconstraint.htm
+share/doc/pgsql/postgres/sql-createdatabase.htm
+share/doc/pgsql/postgres/sql-createfunction.htm
+share/doc/pgsql/postgres/sql-creategroup.htm
+share/doc/pgsql/postgres/sql-createindex.htm
+share/doc/pgsql/postgres/sql-createlanguage.htm
+share/doc/pgsql/postgres/sql-createoperator.htm
+share/doc/pgsql/postgres/sql-createrule.htm
+share/doc/pgsql/postgres/sql-createsequence.htm
+share/doc/pgsql/postgres/sql-createtable.htm
+share/doc/pgsql/postgres/sql-createtableas.htm
+share/doc/pgsql/postgres/sql-createtrigger.htm
+share/doc/pgsql/postgres/sql-createtype.htm
+share/doc/pgsql/postgres/sql-createuser.htm
+share/doc/pgsql/postgres/sql-createview.htm
+share/doc/pgsql/postgres/sql-declare.htm
+share/doc/pgsql/postgres/sql-delete.htm
+share/doc/pgsql/postgres/sql-dropaggregate.htm
+share/doc/pgsql/postgres/sql-dropdatabase.htm
+share/doc/pgsql/postgres/sql-dropfunction.htm
+share/doc/pgsql/postgres/sql-dropgroup.htm
+share/doc/pgsql/postgres/sql-dropindex.htm
+share/doc/pgsql/postgres/sql-droplanguage.htm
+share/doc/pgsql/postgres/sql-dropoperator.htm
+share/doc/pgsql/postgres/sql-droprule.htm
+share/doc/pgsql/postgres/sql-dropsequence.htm
+share/doc/pgsql/postgres/sql-droptable.htm
+share/doc/pgsql/postgres/sql-droptrigger.htm
+share/doc/pgsql/postgres/sql-droptype.htm
+share/doc/pgsql/postgres/sql-dropuser.htm
+share/doc/pgsql/postgres/sql-dropview.htm
+share/doc/pgsql/postgres/sql-end.htm
+share/doc/pgsql/postgres/sql-explain.htm
+share/doc/pgsql/postgres/sql-fetch.htm
+share/doc/pgsql/postgres/sql-grant.htm
+share/doc/pgsql/postgres/sql-insert.htm
+share/doc/pgsql/postgres/sql-language.htm
+share/doc/pgsql/postgres/sql-listen.htm
+share/doc/pgsql/postgres/sql-load.htm
+share/doc/pgsql/postgres/sql-lock.htm
+share/doc/pgsql/postgres/sql-move.htm
+share/doc/pgsql/postgres/sql-notify.htm
+share/doc/pgsql/postgres/sql-reindex.htm
+share/doc/pgsql/postgres/sql-reset.htm
+share/doc/pgsql/postgres/sql-revoke.htm
+share/doc/pgsql/postgres/sql-rollback.htm
+share/doc/pgsql/postgres/sql-select.htm
+share/doc/pgsql/postgres/sql-selectinto.htm
+share/doc/pgsql/postgres/sql-set.htm
+share/doc/pgsql/postgres/sql-show.htm
+share/doc/pgsql/postgres/sql-truncate.htm
+share/doc/pgsql/postgres/sql-unlisten.htm
+share/doc/pgsql/postgres/sql-update.htm
+share/doc/pgsql/postgres/sql-vacuum.htm
+share/doc/pgsql/postgres/sql.htm
+share/doc/pgsql/postgres/sql26902.htm
+share/doc/pgsql/postgres/sql27020.htm
+share/doc/pgsql/postgres/start.htm
+share/doc/pgsql/postgres/start27628.htm
+share/doc/pgsql/postgres/start27650.htm
+share/doc/pgsql/postgres/storage.htm
+share/doc/pgsql/postgres/syntax.htm
+share/doc/pgsql/postgres/syntax519.htm
+share/doc/pgsql/postgres/syntax525.htm
+share/doc/pgsql/postgres/syntax543.htm
+share/doc/pgsql/postgres/syntax608.htm
+share/doc/pgsql/postgres/syntax653.htm
+share/doc/pgsql/postgres/syntax658.htm
+share/doc/pgsql/postgres/terminology.htm
+share/doc/pgsql/postgres/triggers.htm
+share/doc/pgsql/postgres/triggers20224.htm
+share/doc/pgsql/postgres/triggers20281.htm
+share/doc/pgsql/postgres/triggers20290.htm
+share/doc/pgsql/postgres/trouble.htm
+share/doc/pgsql/postgres/trouble18031.htm
+share/doc/pgsql/postgres/trouble18048.htm
+share/doc/pgsql/postgres/typeconv.htm
+share/doc/pgsql/postgres/typeconv3759.htm
+share/doc/pgsql/postgres/typeconv3822.htm
+share/doc/pgsql/postgres/typeconv3875.htm
+share/doc/pgsql/postgres/typeconv3895.htm
+share/doc/pgsql/postgres/utilities.htm
+share/doc/pgsql/postgres/xaggr.htm
+share/doc/pgsql/postgres/xfunc.htm
+share/doc/pgsql/postgres/xfunc19011.htm
+share/doc/pgsql/postgres/xfunc19017.htm
+share/doc/pgsql/postgres/xfunc19022.htm
+share/doc/pgsql/postgres/xfunc19254.htm
+share/doc/pgsql/postgres/xindex.htm
+share/doc/pgsql/postgres/xoper.htm
+share/doc/pgsql/postgres/xplang.htm
+share/doc/pgsql/postgres/xtypes.htm
+share/doc/pgsql/postgres/y2k.htm
+share/doc/pgsql/programmer/arch-pg.htm
+share/doc/pgsql/programmer/biblio.htm
+share/doc/pgsql/programmer/bki.htm
+share/doc/pgsql/programmer/bki8058.htm
+share/doc/pgsql/programmer/bki8142.htm
+share/doc/pgsql/programmer/bki8166.htm
+share/doc/pgsql/programmer/bki8227.htm
+share/doc/pgsql/programmer/c1486.htm
+share/doc/pgsql/programmer/c5391.htm
+share/doc/pgsql/programmer/c53915433.htm
+share/doc/pgsql/programmer/c53915451.htm
+share/doc/pgsql/programmer/c53915593.htm
+share/doc/pgsql/programmer/c53915605.htm
+share/doc/pgsql/programmer/c53915625.htm
+share/doc/pgsql/programmer/c53915630.htm
+share/doc/pgsql/programmer/c6614.htm
+share/doc/pgsql/programmer/catalogs.gif
+share/doc/pgsql/programmer/compiler.htm
+share/doc/pgsql/programmer/connections.gif
+share/doc/pgsql/programmer/copyright.htm
+share/doc/pgsql/programmer/cvs.htm
+share/doc/pgsql/programmer/cvs8365.htm
+share/doc/pgsql/programmer/cvs8421.htm
+share/doc/pgsql/programmer/dfunc.htm
+share/doc/pgsql/programmer/dfunc1679.htm
+share/doc/pgsql/programmer/dfunc1689.htm
+share/doc/pgsql/programmer/docguide.htm
+share/doc/pgsql/programmer/docguide8647.htm
+share/doc/pgsql/programmer/docguide8678.htm
+share/doc/pgsql/programmer/docguide8769.htm
+share/doc/pgsql/programmer/docguide8790.htm
+share/doc/pgsql/programmer/docguide8816.htm
+share/doc/pgsql/programmer/docguide8953.htm
+share/doc/pgsql/programmer/docguide9291.htm
+share/doc/pgsql/programmer/extend.htm
+share/doc/pgsql/programmer/extend352.htm
+share/doc/pgsql/programmer/extend364.htm
+share/doc/pgsql/programmer/geqo-biblio.htm
+share/doc/pgsql/programmer/geqo.htm
+share/doc/pgsql/programmer/geqo7079.htm
+share/doc/pgsql/programmer/geqo7102.htm
+share/doc/pgsql/programmer/geqo7140.htm
+share/doc/pgsql/programmer/gist.htm
+share/doc/pgsql/programmer/index.html
+share/doc/pgsql/programmer/intro-pg.htm
+share/doc/pgsql/programmer/intro-pg167.htm
+share/doc/pgsql/programmer/jdbc.htm
+share/doc/pgsql/programmer/jdbc6398.htm
+share/doc/pgsql/programmer/jdbc6410.htm
+share/doc/pgsql/programmer/jdbc6416.htm
+share/doc/pgsql/programmer/jdbc6424.htm
+share/doc/pgsql/programmer/jdbc6442.htm
+share/doc/pgsql/programmer/jdbc6479.htm
+share/doc/pgsql/programmer/jdbc6510.htm
+share/doc/pgsql/programmer/jdbc6515.htm
+share/doc/pgsql/programmer/jdbc6519.htm
+share/doc/pgsql/programmer/jdbc6545.htm
+share/doc/pgsql/programmer/jdbc6575.htm
+share/doc/pgsql/programmer/largeobjects.htm
+share/doc/pgsql/programmer/largeobjects3114.htm
+share/doc/pgsql/programmer/largeobjects3117.htm
+share/doc/pgsql/programmer/largeobjects3196.htm
+share/doc/pgsql/programmer/largeobjects3203.htm
+share/doc/pgsql/programmer/largeobjects3207.htm
+share/doc/pgsql/programmer/libpq-chapter.htm
+share/doc/pgsql/programmer/libpq-chapter3419.htm
+share/doc/pgsql/programmer/libpq-chapter3574.htm
+share/doc/pgsql/programmer/libpq-chapter3721.htm
+share/doc/pgsql/programmer/libpq-chapter3733.htm
+share/doc/pgsql/programmer/libpq-chapter3771.htm
+share/doc/pgsql/programmer/libpq-chapter3841.htm
+share/doc/pgsql/programmer/libpq-chapter3854.htm
+share/doc/pgsql/programmer/libpq-chapter3939.htm
+share/doc/pgsql/programmer/libpq-envars.htm
+share/doc/pgsql/programmer/libpq-threading.htm
+share/doc/pgsql/programmer/libpqplusplus.htm
+share/doc/pgsql/programmer/libpqplusplus4031.htm
+share/doc/pgsql/programmer/libpqplusplus4041.htm
+share/doc/pgsql/programmer/libpqplusplus4071.htm
+share/doc/pgsql/programmer/libpqplusplus4176.htm
+share/doc/pgsql/programmer/libpqplusplus4199.htm
+share/doc/pgsql/programmer/lisp.htm
+share/doc/pgsql/programmer/notation.htm
+share/doc/pgsql/programmer/odbc.htm
+share/doc/pgsql/programmer/odbc5922.htm
+share/doc/pgsql/programmer/odbc5960.htm
+share/doc/pgsql/programmer/odbc6133.htm
+share/doc/pgsql/programmer/odbc6155.htm
+share/doc/pgsql/programmer/overview.htm
+share/doc/pgsql/programmer/overview6679.htm
+share/doc/pgsql/programmer/overview6704.htm
+share/doc/pgsql/programmer/overview6832.htm
+share/doc/pgsql/programmer/overview6888.htm
+share/doc/pgsql/programmer/overview6942.htm
+share/doc/pgsql/programmer/page.htm
+share/doc/pgsql/programmer/page8290.htm
+share/doc/pgsql/programmer/page8304.htm
+share/doc/pgsql/programmer/pg-options-dev.htm
+share/doc/pgsql/programmer/pgeasy-chapter.htm
+share/doc/pgsql/programmer/pgtcl-pgconndefaults.htm
+share/doc/pgsql/programmer/pgtcl-pgconnect.htm
+share/doc/pgsql/programmer/pgtcl-pgdisconnect.htm
+share/doc/pgsql/programmer/pgtcl-pgexec.htm
+share/doc/pgsql/programmer/pgtcl-pglisten.htm
+share/doc/pgsql/programmer/pgtcl-pgloclose.htm
+share/doc/pgsql/programmer/pgtcl-pglocreat.htm
+share/doc/pgsql/programmer/pgtcl-pgloexport.htm
+share/doc/pgsql/programmer/pgtcl-pgloimport.htm
+share/doc/pgsql/programmer/pgtcl-pglolseek.htm
+share/doc/pgsql/programmer/pgtcl-pgloopen.htm
+share/doc/pgsql/programmer/pgtcl-pgloread.htm
+share/doc/pgsql/programmer/pgtcl-pglotell.htm
+share/doc/pgsql/programmer/pgtcl-pglounlink.htm
+share/doc/pgsql/programmer/pgtcl-pglowrite.htm
+share/doc/pgsql/programmer/pgtcl-pgresult.htm
+share/doc/pgsql/programmer/pgtcl-pgselect.htm
+share/doc/pgsql/programmer/pgtcl.htm
+share/doc/pgsql/programmer/pgtcl4314.htm
+share/doc/pgsql/programmer/pgtcl4318.htm
+share/doc/pgsql/programmer/preface.htm
+share/doc/pgsql/programmer/programmer.htm
+share/doc/pgsql/programmer/programmer.html
+share/doc/pgsql/programmer/protocol.htm
+share/doc/pgsql/programmer/protocol7255.htm
+share/doc/pgsql/programmer/protocol7410.htm
+share/doc/pgsql/programmer/protocol7447.htm
+share/doc/pgsql/programmer/rules.htm
+share/doc/pgsql/programmer/rules1139.htm
+share/doc/pgsql/programmer/rules1270.htm
+share/doc/pgsql/programmer/rules1284.htm
+share/doc/pgsql/programmer/rules978.htm
+share/doc/pgsql/programmer/signals.htm
+share/doc/pgsql/programmer/spi-spiconnect.htm
+share/doc/pgsql/programmer/spi-spicopytuple.htm
+share/doc/pgsql/programmer/spi-spiexec.htm
+share/doc/pgsql/programmer/spi-spiexecp.htm
+share/doc/pgsql/programmer/spi-spifinish.htm
+share/doc/pgsql/programmer/spi-spifname.htm
+share/doc/pgsql/programmer/spi-spifnumber.htm
+share/doc/pgsql/programmer/spi-spigetbinval.htm
+share/doc/pgsql/programmer/spi-spigetrelname.htm
+share/doc/pgsql/programmer/spi-spigettype.htm
+share/doc/pgsql/programmer/spi-spigettypeid.htm
+share/doc/pgsql/programmer/spi-spigetvalue.htm
+share/doc/pgsql/programmer/spi-spimodifytuple.htm
+share/doc/pgsql/programmer/spi-spipalloc.htm
+share/doc/pgsql/programmer/spi-spipfree.htm
+share/doc/pgsql/programmer/spi-spiprepare.htm
+share/doc/pgsql/programmer/spi-spirepalloc.htm
+share/doc/pgsql/programmer/spi-spisaveplan.htm
+share/doc/pgsql/programmer/spi.htm
+share/doc/pgsql/programmer/spi2351.htm
+share/doc/pgsql/programmer/spi3064.htm
+share/doc/pgsql/programmer/spi3086.htm
+share/doc/pgsql/programmer/spi3091.htm
+share/doc/pgsql/programmer/terminology.htm
+share/doc/pgsql/programmer/triggers.htm
+share/doc/pgsql/programmer/triggers1767.htm
+share/doc/pgsql/programmer/triggers1824.htm
+share/doc/pgsql/programmer/triggers1833.htm
+share/doc/pgsql/programmer/xaggr.htm
+share/doc/pgsql/programmer/xfunc.htm
+share/doc/pgsql/programmer/xfunc511.htm
+share/doc/pgsql/programmer/xfunc517.htm
+share/doc/pgsql/programmer/xfunc522.htm
+share/doc/pgsql/programmer/xfunc754.htm
+share/doc/pgsql/programmer/xindex.htm
+share/doc/pgsql/programmer/xoper.htm
+share/doc/pgsql/programmer/xplang.htm
+share/doc/pgsql/programmer/xtypes.htm
+share/doc/pgsql/programmer/y2k.htm
+share/doc/pgsql/tutorial/about.htm
+share/doc/pgsql/tutorial/advanced.htm
+share/doc/pgsql/tutorial/advanced1511.htm
+share/doc/pgsql/tutorial/advanced1533.htm
+share/doc/pgsql/tutorial/arch.htm
+share/doc/pgsql/tutorial/biblio.htm
+share/doc/pgsql/tutorial/clientserver.gif
+share/doc/pgsql/tutorial/copyright.htm
+share/doc/pgsql/tutorial/f17.htm
+share/doc/pgsql/tutorial/index.html
+share/doc/pgsql/tutorial/intro.htm
+share/doc/pgsql/tutorial/intro172.htm
+share/doc/pgsql/tutorial/intro300.htm
+share/doc/pgsql/tutorial/intro56.htm
+share/doc/pgsql/tutorial/notation.htm
+share/doc/pgsql/tutorial/query.htm
+share/doc/pgsql/tutorial/query1340.htm
+share/doc/pgsql/tutorial/query1356.htm
+share/doc/pgsql/tutorial/query1378.htm
+share/doc/pgsql/tutorial/query1387.htm
+share/doc/pgsql/tutorial/query1405.htm
+share/doc/pgsql/tutorial/query1413.htm
+share/doc/pgsql/tutorial/query1432.htm
+share/doc/pgsql/tutorial/query1437.htm
+share/doc/pgsql/tutorial/query1444.htm
+share/doc/pgsql/tutorial/sql-language.htm
+share/doc/pgsql/tutorial/sql.htm
+share/doc/pgsql/tutorial/sql490.htm
+share/doc/pgsql/tutorial/sql608.htm
+share/doc/pgsql/tutorial/start.htm
+share/doc/pgsql/tutorial/start1216.htm
+share/doc/pgsql/tutorial/start1238.htm
+share/doc/pgsql/tutorial/terminology.htm
+share/doc/pgsql/tutorial/tutorial.htm
+share/doc/pgsql/tutorial/tutorial.html
+share/doc/pgsql/tutorial/y2k.htm
+share/doc/pgsql/user/about.htm
+share/doc/pgsql/user/app-createdb.htm
+share/doc/pgsql/user/app-createlang.htm
+share/doc/pgsql/user/app-createuser.htm
+share/doc/pgsql/user/app-dropdb.htm
+share/doc/pgsql/user/app-droplang.htm
+share/doc/pgsql/user/app-dropuser.htm
+share/doc/pgsql/user/app-ecpg.htm
+share/doc/pgsql/user/app-initdb.htm
+share/doc/pgsql/user/app-initlocation.htm
+share/doc/pgsql/user/app-ipcclean.htm
+share/doc/pgsql/user/app-pg-passwd.htm
+share/doc/pgsql/user/app-pg-upgrade.htm
+share/doc/pgsql/user/app-pgaccess.htm
+share/doc/pgsql/user/app-pgadmin.htm
+share/doc/pgsql/user/app-pgctl.htm
+share/doc/pgsql/user/app-pgdump.htm
+share/doc/pgsql/user/app-pgdumpall.htm
+share/doc/pgsql/user/app-pgtclsh.htm
+share/doc/pgsql/user/app-pgtksh.htm
+share/doc/pgsql/user/app-postgres.htm
+share/doc/pgsql/user/app-postmaster.htm
+share/doc/pgsql/user/app-psql.htm
+share/doc/pgsql/user/app-vacuumdb.htm
+share/doc/pgsql/user/applications.htm
+share/doc/pgsql/user/arrays.htm
+share/doc/pgsql/user/biblio.htm
+share/doc/pgsql/user/c4087.htm
+share/doc/pgsql/user/c40874113.htm
+share/doc/pgsql/user/c40874340.htm
+share/doc/pgsql/user/c4358.htm
+share/doc/pgsql/user/c43584371.htm
+share/doc/pgsql/user/c4884.htm
+share/doc/pgsql/user/c4929.htm
+share/doc/pgsql/user/c49294939.htm
+share/doc/pgsql/user/c49294943.htm
+share/doc/pgsql/user/copyright.htm
+share/doc/pgsql/user/datatype.htm
+share/doc/pgsql/user/datatype1034.htm
+share/doc/pgsql/user/datatype1066.htm
+share/doc/pgsql/user/datatype1130.htm
+share/doc/pgsql/user/datatype1645.htm
+share/doc/pgsql/user/datatype1677.htm
+share/doc/pgsql/user/datatype1916.htm
+share/doc/pgsql/user/datetime-appendix.htm
+share/doc/pgsql/user/datetime-appendix16981.htm
+share/doc/pgsql/user/environ.htm
+share/doc/pgsql/user/functions.htm
+share/doc/pgsql/user/functions2589.htm
+share/doc/pgsql/user/functions2729.htm
+share/doc/pgsql/user/functions2872.htm
+share/doc/pgsql/user/functions2972.htm
+share/doc/pgsql/user/functions3439.htm
+share/doc/pgsql/user/functions3637.htm
+share/doc/pgsql/user/index.html
+share/doc/pgsql/user/indices.htm
+share/doc/pgsql/user/inherit.htm
+share/doc/pgsql/user/intro.htm
+share/doc/pgsql/user/intro172.htm
+share/doc/pgsql/user/intro300.htm
+share/doc/pgsql/user/intro56.htm
+share/doc/pgsql/user/manage.htm
+share/doc/pgsql/user/manage4810.htm
+share/doc/pgsql/user/manage4834.htm
+share/doc/pgsql/user/manage4876.htm
+share/doc/pgsql/user/mvcc.htm
+share/doc/pgsql/user/mvcc4564.htm
+share/doc/pgsql/user/mvcc4617.htm
+share/doc/pgsql/user/mvcc4629.htm
+share/doc/pgsql/user/mvcc4642.htm
+share/doc/pgsql/user/mvcc4719.htm
+share/doc/pgsql/user/mvcc4740.htm
+share/doc/pgsql/user/notation.htm
+share/doc/pgsql/user/operators.htm
+share/doc/pgsql/user/operators2123.htm
+share/doc/pgsql/user/operators2194.htm
+share/doc/pgsql/user/operators2263.htm
+share/doc/pgsql/user/operators2373.htm
+share/doc/pgsql/user/operators2432.htm
+share/doc/pgsql/user/operators2486.htm
+share/doc/pgsql/user/partial-index.htm
+share/doc/pgsql/user/pl-perl.htm
+share/doc/pgsql/user/pl-perl4529.htm
+share/doc/pgsql/user/pl-perl4538.htm
+share/doc/pgsql/user/preface.htm
+share/doc/pgsql/user/sql-abort.htm
+share/doc/pgsql/user/sql-altergroup.htm
+share/doc/pgsql/user/sql-altertable.htm
+share/doc/pgsql/user/sql-alteruser.htm
+share/doc/pgsql/user/sql-begin.htm
+share/doc/pgsql/user/sql-close.htm
+share/doc/pgsql/user/sql-cluster.htm
+share/doc/pgsql/user/sql-commands.htm
+share/doc/pgsql/user/sql-comment.htm
+share/doc/pgsql/user/sql-commit.htm
+share/doc/pgsql/user/sql-copy.htm
+share/doc/pgsql/user/sql-createaggregate.htm
+share/doc/pgsql/user/sql-createconstraint.htm
+share/doc/pgsql/user/sql-createdatabase.htm
+share/doc/pgsql/user/sql-createfunction.htm
+share/doc/pgsql/user/sql-creategroup.htm
+share/doc/pgsql/user/sql-createindex.htm
+share/doc/pgsql/user/sql-createlanguage.htm
+share/doc/pgsql/user/sql-createoperator.htm
+share/doc/pgsql/user/sql-createrule.htm
+share/doc/pgsql/user/sql-createsequence.htm
+share/doc/pgsql/user/sql-createtable.htm
+share/doc/pgsql/user/sql-createtableas.htm
+share/doc/pgsql/user/sql-createtrigger.htm
+share/doc/pgsql/user/sql-createtype.htm
+share/doc/pgsql/user/sql-createuser.htm
+share/doc/pgsql/user/sql-createview.htm
+share/doc/pgsql/user/sql-declare.htm
+share/doc/pgsql/user/sql-delete.htm
+share/doc/pgsql/user/sql-dropaggregate.htm
+share/doc/pgsql/user/sql-dropdatabase.htm
+share/doc/pgsql/user/sql-dropfunction.htm
+share/doc/pgsql/user/sql-dropgroup.htm
+share/doc/pgsql/user/sql-dropindex.htm
+share/doc/pgsql/user/sql-droplanguage.htm
+share/doc/pgsql/user/sql-dropoperator.htm
+share/doc/pgsql/user/sql-droprule.htm
+share/doc/pgsql/user/sql-dropsequence.htm
+share/doc/pgsql/user/sql-droptable.htm
+share/doc/pgsql/user/sql-droptrigger.htm
+share/doc/pgsql/user/sql-droptype.htm
+share/doc/pgsql/user/sql-dropuser.htm
+share/doc/pgsql/user/sql-dropview.htm
+share/doc/pgsql/user/sql-end.htm
+share/doc/pgsql/user/sql-explain.htm
+share/doc/pgsql/user/sql-fetch.htm
+share/doc/pgsql/user/sql-grant.htm
+share/doc/pgsql/user/sql-insert.htm
+share/doc/pgsql/user/sql-listen.htm
+share/doc/pgsql/user/sql-load.htm
+share/doc/pgsql/user/sql-lock.htm
+share/doc/pgsql/user/sql-move.htm
+share/doc/pgsql/user/sql-notify.htm
+share/doc/pgsql/user/sql-reindex.htm
+share/doc/pgsql/user/sql-reset.htm
+share/doc/pgsql/user/sql-revoke.htm
+share/doc/pgsql/user/sql-rollback.htm
+share/doc/pgsql/user/sql-select.htm
+share/doc/pgsql/user/sql-selectinto.htm
+share/doc/pgsql/user/sql-set.htm
+share/doc/pgsql/user/sql-show.htm
+share/doc/pgsql/user/sql-truncate.htm
+share/doc/pgsql/user/sql-unlisten.htm
+share/doc/pgsql/user/sql-update.htm
+share/doc/pgsql/user/sql-vacuum.htm
+share/doc/pgsql/user/storage.htm
+share/doc/pgsql/user/syntax.htm
+share/doc/pgsql/user/syntax515.htm
+share/doc/pgsql/user/syntax521.htm
+share/doc/pgsql/user/syntax539.htm
+share/doc/pgsql/user/syntax604.htm
+share/doc/pgsql/user/syntax649.htm
+share/doc/pgsql/user/syntax654.htm
+share/doc/pgsql/user/terminology.htm
+share/doc/pgsql/user/typeconv.htm
+share/doc/pgsql/user/typeconv3755.htm
+share/doc/pgsql/user/typeconv3818.htm
+share/doc/pgsql/user/typeconv3871.htm
+share/doc/pgsql/user/typeconv3891.htm
+share/doc/pgsql/user/user.htm
+share/doc/pgsql/user/user.html
+share/doc/pgsql/user/utilities.htm
+share/doc/pgsql/user/y2k.htm
+@exec mkdir -p %D/pgsql/include/port/freebsd
+@exec mkdir -p %D/pgsql/data/pg_xlog
+@dirrm share/doc/pgsql/admin
+@dirrm share/doc/pgsql/postgres
+@dirrm share/doc/pgsql/programmer
+@dirrm share/doc/pgsql/tutorial
+@dirrm share/doc/pgsql/user
+@dirrm share/doc/pgsql
+@dirrm pgsql/bin
+@dirrm pgsql/man/manl
+@dirrm pgsql/man/man1
+@dirrm pgsql/man
+@dirrm pgsql/lib
+@dirrm pgsql/include/port/freebsd
+@dirrm pgsql/include/port
+@dirrm pgsql/include/utils
+@dirrm pgsql/include/libpq++
+@dirrm pgsql/include/libpq
+@dirrm pgsql/include/lib
+@dirrm pgsql/include/executor
+@dirrm pgsql/include/commands
+@dirrm pgsql/include/access
+@dirrm pgsql/include
+@unexec rm -fr %D/pgsql 2>/dev/null || true
diff --git a/japanese/postgresql7/pkg-plist.jdbc b/japanese/postgresql7/pkg-plist.jdbc
new file mode 100644
index 000000000000..7c59ed439420
--- /dev/null
+++ b/japanese/postgresql7/pkg-plist.jdbc
@@ -0,0 +1,13 @@
+share/examples/pgsql/jdbc/ImageViewer.java
+share/examples/pgsql/jdbc/basic.java
+share/examples/pgsql/jdbc/blobtest.java
+share/examples/pgsql/jdbc/datestyle.java
+share/examples/pgsql/jdbc/metadata.java
+share/examples/pgsql/jdbc/psql.java
+share/examples/pgsql/jdbc/threadsafe.java
+share/examples/pgsql/jdbc/README
+share/examples/pgsql/jdbc/README_6.3
+@dirrm share/examples/pgsql/jdbc
+@dirrm share/examples/pgsql
+share/java/postgresql.jar
+@unexec rmdir %D/share/java 2>/dev/null || true
diff --git a/japanese/postgresql7/pkg-plist.odbc b/japanese/postgresql7/pkg-plist.odbc
index 8cba0e5c977c..c849e26dbc88 100644
--- a/japanese/postgresql7/pkg-plist.odbc
+++ b/japanese/postgresql7/pkg-plist.odbc
@@ -1,7 +1,8 @@
-%%INSTALL_DIR%%/lib/libpsqlodbc.a
-%%INSTALL_DIR%%/lib/libpsqlodbc.so
-%%INSTALL_DIR%%/lib/libpsqlodbc.so.0
-%%INSTALL_DIR%%/include/iodbc/iodbc.h
-%%INSTALL_DIR%%/include/iodbc/isql.h
-%%INSTALL_DIR%%/include/iodbc/isqlext.h
-%%INSTALL_DIR%%/odbcinst.ini
+pgsql/include/iodbc/iodbc.h
+pgsql/include/iodbc/isql.h
+pgsql/include/iodbc/isqlext.h
+pgsql/lib/libpsqlodbc.a
+pgsql/lib/libpsqlodbc.so
+pgsql/lib/libpsqlodbc.so.0
+pgsql/odbcinst.ini
+@dirrm pgsql/include/iodbc
diff --git a/japanese/postgresql7/pkg-plist.tcl b/japanese/postgresql7/pkg-plist.tcl
index 1752c248ce13..f3d0a042d747 100644
--- a/japanese/postgresql7/pkg-plist.tcl
+++ b/japanese/postgresql7/pkg-plist.tcl
@@ -1,129 +1,7 @@
-%%INSTALL_DIR%%/bin/pgtclsh
-%%INSTALL_DIR%%/bin/pgtksh
-%%INSTALL_DIR%%/bin/pgaccess
-%%INSTALL_DIR%%/lib/libpgtcl.a
-%%INSTALL_DIR%%/lib/libpgtcl.so
-%%INSTALL_DIR%%/lib/libpgtcl.so.2
-%%INSTALL_DIR%%/include/libpgtcl.h
-%%INSTALL_DIR%%/pgaccess/images/icon_button.gif
-%%INSTALL_DIR%%/pgaccess/images/icon_checkbutton.gif
-%%INSTALL_DIR%%/pgaccess/images/icon_entry.gif
-%%INSTALL_DIR%%/pgaccess/images/icon_frame.gif
-%%INSTALL_DIR%%/pgaccess/images/icon_label.gif
-%%INSTALL_DIR%%/pgaccess/images/icon_listbox.gif
-%%INSTALL_DIR%%/pgaccess/images/icon_query.gif
-%%INSTALL_DIR%%/pgaccess/images/icon_radiobutton.gif
-%%INSTALL_DIR%%/pgaccess/images/icon_text.gif
-%%INSTALL_DIR%%/pgaccess/lib/help/abort.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/add_records.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/alter_table.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/alter_user.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/author.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/begin.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/close.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/cluster.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/commit.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/copy.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/copyrights.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_aggregate.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_database.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_function.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_index.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_language.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_operator.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_rule.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_sequence.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_table.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_table_as.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_trigger.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_type.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_user.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/create_view.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/data_types.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/datefunc.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/declare.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/delete.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_aggregate.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_database.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_function.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_index.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_language.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_operator.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_rule.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_sequence.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_table.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_trigger.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_type.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_user.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/drop_view.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/explain.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/fetch.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/form_design.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/forms.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/functions.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/geomfunc.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/grant.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/history.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/index.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/inheritance.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/insert.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/ipv4func.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/isolation.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/keywords.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/listen.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/load.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/lock.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/mathfunc.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/move.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/mvcc.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/new_query.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/new_table.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/notify.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/open_query.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/open_table.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/pgfunctions.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/postgresql.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/queries.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/reports.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/reset.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/revoke.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/rollback.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/schema.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/scripts.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/select.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/select_into.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/sequences.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/set.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/show.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/sql_guide.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/sqlfunc.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/stringfunc.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/tables.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/unlisten.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/update.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/users.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/vacuum.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/view_table_structure.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/views.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/visual_designer.hlp
-%%INSTALL_DIR%%/pgaccess/lib/help/y2k.hlp
-%%INSTALL_DIR%%/pgaccess/lib/languages/francais
-%%INSTALL_DIR%%/pgaccess/lib/languages/italiano
-%%INSTALL_DIR%%/pgaccess/lib/languages/magyar
-%%INSTALL_DIR%%/pgaccess/lib/languages/romana
-%%INSTALL_DIR%%/pgaccess/main.tcl
-%%INSTALL_DIR%%/pgaccess/lib/database.tcl
-%%INSTALL_DIR%%/pgaccess/lib/forms.tcl
-%%INSTALL_DIR%%/pgaccess/lib/functions.tcl
-%%INSTALL_DIR%%/pgaccess/lib/help.tcl
-%%INSTALL_DIR%%/pgaccess/lib/mainlib.tcl
-%%INSTALL_DIR%%/pgaccess/lib/preferences.tcl
-%%INSTALL_DIR%%/pgaccess/lib/queries.tcl
-%%INSTALL_DIR%%/pgaccess/lib/reports.tcl
-%%INSTALL_DIR%%/pgaccess/lib/schema.tcl
-%%INSTALL_DIR%%/pgaccess/lib/scripts.tcl
-%%INSTALL_DIR%%/pgaccess/lib/sequences.tcl
-%%INSTALL_DIR%%/pgaccess/lib/tables.tcl
-%%INSTALL_DIR%%/pgaccess/lib/users.tcl
-%%INSTALL_DIR%%/pgaccess/lib/views.tcl
-%%INSTALL_DIR%%/pgaccess/lib/visualqb.tcl
+pgsql/bin/pgtclsh
+pgsql/bin/pgtksh
+pgsql/include/libpgtcl.h
+pgsql/lib/libpgtcl.a
+pgsql/lib/libpgtcl.so
+pgsql/lib/libpgtcl.so.2
+pgsql/lib/pltcl.so
diff --git a/japanese/postgresql7/scripts/configure b/japanese/postgresql7/scripts/configure
new file mode 100644
index 000000000000..ec3586e28899
--- /dev/null
+++ b/japanese/postgresql7/scripts/configure
@@ -0,0 +1,7 @@
+#! /bin/sh
+
+# $FreeBSD: /tmp/pcvs/ports/japanese/postgresql7/scripts/Attic/configure,v 1.1 2000-07-19 01:18:08 kuriyama Exp $
+
+cd $WRKSRC || exit 1
+
+perl -pi -e "s=!!JAVA_HOME!!=${JAVA_HOME}=; s=!!PREFIX!!=${PREFIX}=" ${WRKSRC}/interfaces/jdbc/Makefile
diff --git a/japanese/postgresql7/scripts/createuser b/japanese/postgresql7/scripts/createuser
new file mode 100644
index 000000000000..2abe201e7a4b
--- /dev/null
+++ b/japanese/postgresql7/scripts/createuser
@@ -0,0 +1,50 @@
+#!/usr/bin/perl
+#
+
+eval '(exit $?0)' && eval 'exec /usr/bin/perl -S $0 ${1+"$@"}'
+& eval 'exec /usr/bin/perl -S $0 $argv:q'
+if 0;
+
+if( $> ) {
+ print "\nYou must be root to run this step!\n\n";
+ exit 1;
+}
+
+if( getpwnam( "pgsql" ) ) {
+ ( $null, $null, $pgUID ) = getpwnam( "pgsql" );
+} else {
+ $pgUID = 70;
+ while( getpwuid( $pgUID ) ) {
+ $pgUID++;
+ }
+}
+
+if( getgrnam( "pgsql" ) ) {
+ ( $null, $null, $pgGID ) = getgrnam( "pgsql" );
+} else {
+ $pgGID = 70;
+ while( getgrgid( $pgGID ) ) {
+ $pgGID++;
+ }
+ &append_file( "/etc/group", "pgsql:*:$pgGID:" );
+}
+
+print "pgsql user using uid $pgUID\n";
+print "pgsql user using gid $pgGID\n";
+
+system( "/usr/bin/chpass -a \"pgsql:*:$pgUID:$pgGID\:\:0:0:PostgreSQL pseudo-user:$ENV{'PREFIX'}/pgsql:/bin/sh\"" );
+
+sub append_file {
+ local($file,@list) = @_;
+ local($LOCK_EX) = 2;
+ local($LOCK_NB) = 4;
+ local($LOCK_UN) = 8;
+
+ open(F, ">> $file") || die "$file: $!\n";
+ while( ! flock( F, $LOCK_EX | $LOCK_NB ) ) {
+ exit 1;
+ }
+ print F join( "\n", @list) . "\n";
+ close F;
+ flock( F, $LOCK_UN );
+}