aboutsummaryrefslogtreecommitdiff
path: root/japanese/postgresql7
diff options
context:
space:
mode:
authorAkinori MUSHA <knu@FreeBSD.org>2001-05-08 12:36:01 +0000
committerAkinori MUSHA <knu@FreeBSD.org>2001-05-08 12:36:01 +0000
commit652c758fe74cd6fcb512e1d251aad4916cb5c511 (patch)
treeb01fc99dbcefe33bcfd5b8d32dc7248d42fde208 /japanese/postgresql7
parent2a28e659a7b1f95fc2c76ed38cbab3cdf9f1cd10 (diff)
downloadports-652c758fe74cd6fcb512e1d251aad4916cb5c511.tar.gz
ports-652c758fe74cd6fcb512e1d251aad4916cb5c511.zip
Notes
Diffstat (limited to 'japanese/postgresql7')
-rw-r--r--japanese/postgresql7/Makefile295
-rw-r--r--japanese/postgresql7/distinfo6
-rw-r--r--japanese/postgresql7/files/dot.cshrc.in13
-rw-r--r--japanese/postgresql7/files/dot.profile.in18
-rw-r--r--japanese/postgresql7/files/patch-ab66
-rw-r--r--japanese/postgresql7/files/patch-ac11
-rw-r--r--japanese/postgresql7/files/patch-ad11
-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-aj118
-rw-r--r--japanese/postgresql7/files/patch-bc5
-rw-r--r--japanese/postgresql7/files/patch-bd11
-rw-r--r--japanese/postgresql7/files/patch-contrib-retep-build10
-rw-r--r--japanese/postgresql7/files/patch-doc-makefile19
-rw-r--r--japanese/postgresql7/files/patch-jdbc-build-xml10
-rw-r--r--japanese/postgresql7/files/patch-jdbc1-statement13
-rw-r--r--japanese/postgresql7/files/pgsql.sh.tmpl20
-rw-r--r--japanese/postgresql7/files/pkgIndex.tcl.in4
-rw-r--r--japanese/postgresql7/files/post-install-notes16
-rw-r--r--japanese/postgresql7/files/pre-install-notes21
-rw-r--r--japanese/postgresql7/pkg-install18
-rw-r--r--japanese/postgresql7/pkg-message38
-rw-r--r--japanese/postgresql7/pkg-plist260
-rw-r--r--japanese/postgresql7/pkg-plist.doc1379
-rw-r--r--japanese/postgresql7/pkg-plist.jdbc36
-rw-r--r--japanese/postgresql7/pkg-plist.notk6
-rw-r--r--japanese/postgresql7/pkg-plist.odbc18
-rw-r--r--japanese/postgresql7/pkg-plist.tcl289
-rw-r--r--japanese/postgresql7/scripts/configure7
-rw-r--r--japanese/postgresql7/scripts/configure.postgresql277
-rw-r--r--japanese/postgresql7/scripts/createuser50
32 files changed, 1473 insertions, 1619 deletions
diff --git a/japanese/postgresql7/Makefile b/japanese/postgresql7/Makefile
index 9aa9dc2bf0bd..c3b6a527d580 100644
--- a/japanese/postgresql7/Makefile
+++ b/japanese/postgresql7/Makefile
@@ -6,20 +6,19 @@
#
PORTNAME= postgresql
-PORTVERSION= 7.0.3.20001204
+PORTVERSION= 7.1.20010429
CATEGORIES= japanese databases
-MASTER_SITES= ftp://ftp.sra.co.jp/pub/cmd/postgres/${PORTVERSION:R}/ \
- ftp://ftp.jaist.ac.jp/pub/dbms/PostgreSQL/v${PORTVERSION:R}/ \
- ftp://ftp.postgresql.org/pub/v${PORTVERSION:R}/ \
- ${MASTER_SITE_RINGSERVER}
+MASTER_SITES= ftp://ftp.sra.co.jp/pub/cmd/postgres/${PORTVERSION:R} \
+ ftp://ftp.postgresql.org/pub/v${PORTVERSION:R}/ \
+ ${MASTER_SITE_RINGSERVER}
MASTER_SITE_SUBDIR= misc/db/postgresql-jp/${PORTVERSION:R}
DISTNAME= ${PORTNAME}-${PORTVERSION:R}
DIST_SUBDIR= postgresql
PATCH_SITES= ftp://ftp.sra.co.jp/pub/cmd/postgres/${PORTVERSION:R}/patches/ \
- ftp://ftp.18software.co.jp/pub/postgres/
+ ftp://ftp.net-newbie.com/pub/postgres/
PATCHFILES= jumbo-${PORTVERSION:E}.patch.gz \
- psqlj-${PORTVERSION:R}.diff.gz
+ psqlj-${PORTVERSION:R}.diff.gz
PATCH_DIST_STRIP= -p0 -d ${WRKDIR}
MAINTAINER= saito@a2z.co.jp
@@ -30,61 +29,44 @@ BUILD_DEPENDS= ${PATCH}:${PORTSDIR}/devel/patch
BROKEN= doesn\'t build on the alpha yet
.endif
-Y2K= http://www.postgresql.org/y2k.html
-
INSTALLS_SHLIB= YES
-LDCONFIG_DIRS= %%PREFIX%%/pgsql/lib
-# if you want to use the tcl/tk frontend pgaccess, then you need to build
-# postgresql with tcl support by typing: make -DWITH_TCL
-.if defined(WITH_TCL)
-LIB_DEPENDS= tcl80jp.1:${PORTSDIR}/japanese/tcl80 \
- tk80jp.1:${PORTSDIR}/japanese/tk80
-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
-DEFAULT_ENCODING?= EUC_JP
-CONFIGURE_MULTIBYTE= --enable-multibyte="${DEFAULT_ENCODING}"
-.if defined(WITH_PERL)
-CONFIGURE_PERL= --with-perl
-.endif
-.if defined(WITH_ODBC)
-CONFIGURE_ODBC= --with-odbc
-.endif
-
-# if you want jdbc, type make -DWITH_JDBC
-# Honors JAVA_HOME if you have it set, and don't want the dependency.
-.if defined(WITH_JDBC)
-JAVA_HOME?= ${LOCALBASE}/jdk1.1.8
-BUILD_DEPENDS+= ${JAVA_HOME}/bin/javac:${PORTSDIR}/java/jdk
-SCRIPTS_ENV+= JAVA_HOME=${JAVA_HOME}
-.endif
+LDCONFIG_DIRS= %%PREFIX%%/lib
-WRKSRC= ${WRKDIR}/${DISTNAME}/src
-DOCDIR= ${WRKDIR}/${DISTNAME}/doc
+PATCH= ${LOCALBASE}/bin/gpatch
-PATCH= ${LOCALBASE}/bin/gpatch
+PLIST= ${WRKDIR}/.PLIST.generated
USE_GMAKE= YES
-MAKEFILE= GNUmakefile
HAS_CONFIGURE= YES
-CONFIGURE_ARGS= --prefix=${PREFIX}/pgsql \
- --enable-locale \
- --with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` \
+CONFIGURE_ARGS= --enable-locale \
+ --enable-syslog --with-CXX \
+ --sysconfdir=${PREFIX}/etc/postgresql \
--with-includes="${PREFIX}/include ${TCL_INCDIR} ${TK_INCDIR}" \
- ${CONFIGURE_TCL} \
- ${CONFIGURE_MULTIBYTE} \
- ${CONFIGURE_PERL} \
- ${CONFIGURE_ODBC} \
--with-libraries=${PREFIX}/lib
+.if defined(WITH_OLD_LAYOUT)
+CONFIGURE_ARGS+=--docdir=${PREFIX}/share/doc --includedir=${PREFIX}/pgsql/include \
+ --datadir=${PREFIX}/share \
+ --with-template=`uname -s | ${TR} '[A-Z]' '[a-z]'` \
+ --prefix=${PREFIX}/pgsql
+PG_PREFIX= pgsql/
+PG_INCLUDE= pgsql/include
+LDCONFIG_DIRS= %%PREFIX%%/pgsql/lib
+MANPREFIX= ${PREFIX}/pgsql
+.else
+GNU_CONFIGURE= YES
+CONFIGURE_ARGS+=--docdir=${PREFIX}/share/doc --includedir=${PREFIX}/include/pgsql
+PG_PREFIX=""
+PG_INCLUDE= include/pgsql
+.endif
+
+PLIST_SUB= PG_PREFIX="${PG_PREFIX}" PG_INCLUDE="${PG_INCLUDE}" WITH_TCL="${WITH_TCL}"
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 \
+ dropuser.1 ecpg.1 initdb.1 initlocation.1 ipcclean.1 pg_config.1 \
+ pg_ctl.1 pg_dump.1 pg_dumpall.1 pg_passwd.1 pg_restore.1 \
+ pgaccess.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 \
+ begin.l checkpoint.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 \
@@ -98,128 +80,79 @@ MANL= abort.l alter_group.l alter_table.l alter_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 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
+ set.l set_constraints.l set_transaction.l show.l \
+ truncate.l unlisten.l update.l vacuum.l
-MANPREFIX= ${PREFIX}/pgsql
+SCRIPTS_ENV= WRKDIRPREFIX="${WRKDIRPREFIX}" \
+ WRKDIR="${WRKDIR}" \
+ FILESDIR="${FILESDIR}" \
+ TOUCH="${TOUCH}" \
+ MKDIR="${MKDIR}" \
+ NO_OPENSSL="${NO_OPENSSL}" \
+ DISTNAME="${DISTNAME}"
-pre-fetch:
- @${ECHO_MSG} "To install and run postgresql you need to compile kernel with:"
- @${ECHO_MSG} " options \"SYSVSHM, SYSVSEM, SYSVMSG\""
-.if !defined(WITH_TCL)
- @${ECHO_MSG} "To build the \"PostgreSQL to Tcl interface library\", libpgtcl, type:"
- @${ECHO_MSG} " make -DWITH_TCL"
-.else
- @${ECHO_MSG} "Building PostgreSQL with \"libpgtcl\"."
+.if exists(${WRKDIRPREFIX}${.CURDIR}/Makefile.inc)
+.include "${WRKDIRPREFIX}${.CURDIR}/Makefile.inc"
.endif
-.if !defined(DEFAULT_ENCODING)
- @${ECHO_MSG} "To set the default encoding for the multibyte support, type:"
- @${ECHO_MSG} " make DEFAULT_ENCODING=<encoding>"
- @${ECHO_MSG} "where <encoding> is one of these:"
- @${ECHO_MSG} " SQL_ASCII LATIN1 LATIN2 LATIN3 LATIN4 LATIN5"
- @${ECHO_MSG} " EUC_JP EUC_CN EUC_KR EUC_TW KOI8"
- @${ECHO_MSG} " UNICODE MULE_INTERNAL WIN ALT"
+
+pre-extract:
+ @ ${SETENV} ${SCRIPTS_ENV} ${SH} ${SCRIPTDIR}/configure.postgresql
+
+pre-install:
+ @ ${SETENV} PKG_PREFIX=${PREFIX} ${SH} ${PKGDIR}/pkg-install ${PORTNAME} PRE-INSTALL
+.if !defined(BATCH)
+# remind folks twice for a while, so they really don't miss the layout shift
+ @ ${SED} "s|/usr/local|${PREFIX}|g" < ${PKGMESSAGE} | head -n 25 | more -e
.endif
- @${ECHO_MSG} "The default encoding is '${DEFAULT_ENCODING}'."
-.if !defined(WITH_JDBC)
- @${ECHO_MSG} "To build Java (JDBC) support, type:"
- @${ECHO_MSG} " make -DWITH_JDBC"
-.else
- @${ECHO_MSG} "Building PostgreSQL with \"postgresql.jar\"."
+ @ ${CP} ${PKGDIR}/pkg-plist ${PLIST}
+.if defined(WITHOUT_MULTIBYTE)
+ @${CP} ${PLIST} ${PLIST}.nomulti ;\
+ ${GREP} -v bin/pg_encoding ${PLIST}.nomulti > ${PLIST}
.endif
-.if !defined(WITH_PERL)
- @${ECHO_MSG} "To build Perl interface and pl/Perl interpreter:"
- @${ECHO_MSG} " make -DWITH_PERL"
-.else
- @${ECHO_MSG} "Building PostgreSQL with \"pl/Perl\"."
+.if defined(WITH_TCL)
+ @ ${CP} ${PLIST} ${PLIST}.notcl ;\
+ ${CAT} ${PKGDIR}/${TCL_PLIST} ${PLIST}.notcl > ${PLIST} ;\
+ ${RM} ${PLIST}.notcl
.endif
-.if !defined(WITH_ODBC)
- @${ECHO_MSG} "To build the ODBC driver package:"
- @${ECHO_MSG} " make -DWITH_ODBC"
-.else
- @${ECHO_MSG} "Building PostgreSQL with ODBC Drivers."
+.if defined(WITH_ODBC)
+ @ ${CP} ${PLIST} ${PLIST}.noodbc ;\
+ ${CAT} ${PKGDIR}/pkg-plist.odbc ${PLIST}.noodbc > ${PLIST} ;\
+ ${RM} ${PLIST}.noodbc
.endif
-
-post-patch:
- @ ${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(WITH_JDBC)
- @ cd ${WRKSRC}/interfaces/jdbc && ${GMAKE}
-.if !defined(NOPORTDOCS)
- @ cd ${WRKSRC}/interfaces/jdbc && ${GMAKE} examples
+ @ ${CP} ${PLIST} ${PLIST}.nojdbc ;\
+ ${CAT} ${PKGDIR}/pkg-plist.jdbc ${PLIST}.nojdbc > ${PLIST} ;\
+ ${RM} ${PLIST}.nojdbc
.endif
+.if !defined(NOPORTDOCS)
+ @ ${CAT} ${PKGDIR}/pkg-plist.doc >> ${PLIST}
.endif
- @ ${ECHO} "------------------------------------------------------------"
- @ ${ECHO} "Dump existing databases, before installing new db version !!"
- @ ${ECHO} "Detailed instructions, see"
- @ ${ECHO} "${WRKDIR}/${DISTNAME}/INSTALL"
- @ ${ECHO} "------------------------------------------------------------"
-
-pre-install:
-.if defined(PACKAGE_BUILDING)
- ${RM} -rf ${PREFIX}/pgsql
-.endif
- @ ${MKDIR} ${PREFIX}/pgsql
- @ ${SETENV} ${MAKE_ENV} perl ${SCRIPTDIR}/createuser
post-install:
-.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}/pgsql/.profile; \
- ${ECHO} "PGDATA=${PREFIX}/pgsql/data" \
- >> ${PREFIX}/pgsql/.profile; \
- ${ECHO} "DISPLAY=:0" \
- >> ${PREFIX}/pgsql/.profile; \
- ${ECHO} "export PATH MANPATH PGLIB PGDATA DISPLAY" \
- >> ${PREFIX}/pgsql/.profile; \
- ${ECHO} "# if you want to make regression tests use this TZ" \
- >> ${PREFIX}/pgsql/.profile; \
- ${ECHO} "#TZ=PST8PDT" \
- >> ${PREFIX}/pgsql/.profile; \
- ${ECHO} "#export TZ" \
- >> ${PREFIX}/pgsql/.profile; \
+# install shell defaults for pgsql user
+.for i in profile cshrc
+ @ ${SED} "s|%%PREFIX%%|${PREFIX}|g; s|%%PG_PREFIX%%|${PG_PREFIX}|g" \
+ < ${FILESDIR}/dot.$i.in \
+ > ${PREFIX}/share/postgresql/dot.$i.dist; \
+ ${CP} ${PREFIX}/share/postgresql/dot.$i.dist ~pgsql/; \
+ if [ ! -f ~pgsql/.$i ]; then \
+ ${CP} ${PREFIX}/share/postgresql/dot.$i.dist ~pgsql/.$i; \
fi
- @ ${CHOWN} -R pgsql:pgsql ${PREFIX}/pgsql
- @ ${CHOWN} root:pgsql ${PREFIX}/pgsql/lib
- @ ${ECHO} 'Initializing PostgreSQL Databases - this may take a few minutes...'
- @ ${SETENV} OBJFORMAT=${PORTOBJFORMAT} ${LDCONFIG} -m ${PREFIX}/pgsql/lib
- @ su -l pgsql -c 'PATH=${PREFIX}/pgsql/bin:${PATH} LD_LIBRARY_PATH=${PREFIX}/pgsql/lib ${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 ${PREFIX}/etc/rc.d/pgsql.sh
- @ ${INSTALL_DATA} ${FILESDIR}/post-install-notes ${PREFIX}/pgsql
+.endfor
+ @ ${SED} -e "s|%%PREFIX%%|${PREFIX}|g; s|%%PG_PREFIX%%|${PG_PREFIX}|g" \
+ < ${FILESDIR}/pgsql.sh.tmpl \
+ > ${PREFIX}/etc/rc.d/010.pgsql.sh
+ @ ${CHMOD} 554 ${PREFIX}/etc/rc.d/010.pgsql.sh
+ @ ${CHOWN} root.pgsql ${PREFIX}/etc/rc.d/010.pgsql.sh
.if defined(WITH_TCL)
- @${CP} ${TMPPLIST} ${TMPPLIST}.notcl
- @${CAT} ${PKGDIR}/pkg-plist.tcl ${TMPPLIST}.notcl > ${TMPPLIST}
- @${RM} ${TMPPLIST}.notcl
-.endif
-.if defined(WITH_ODBC)
- @${CP} ${TMPPLIST} ${TMPPLIST}.noodbc
- @${CAT} ${PKGDIR}/pkg-plist.odbc ${TMPPLIST}.noodbc > ${TMPPLIST}
- @${RM} ${TMPPLIST}.noodbc
+# Preparing a loadable TCL-package (pkgIndex.tcl)
+ @${MKDIR} ${PREFIX}/lib/tcl${WITH_TCL}/Pgtcl1.3
+ @${SED} "s|%%PREFIX%%|${PREFIX}|g" < ${FILESDIR}/pkgIndex.tcl.in \
+ > ${PREFIX}/lib/tcl${WITH_TCL}/Pgtcl1.3/pkgIndex.tcl
.endif
.if defined(WITH_JDBC)
@ ${MKDIR} -m 0555 ${PREFIX}/share/java/classes
- @ ${INSTALL_DATA} ${WRKSRC}/interfaces/jdbc/postgresql.jar \
+ @ ${INSTALL_DATA} ${WRKSRC}/src/interfaces/jdbc/jars/postgresql.jar \
${PREFIX}/share/java/classes/postgresql.jar
@ ${ECHO_MSG} "---------------------------------------------------------"
@ ${ECHO_MSG} "Putting postgresql.jar in"
@@ -227,36 +160,38 @@ post-install:
@ ${ECHO_MSG} "Add this to your CLASSPATH!"
@ ${ECHO_MSG} "ALSO NOTE: path inside jar file modified from 6.5.x:"
@ ${ECHO_MSG} " 'postgresql.*' -> 'org.postgresql.*'!"
- @ ${ECHO_MSG} "You will need to modify you applications' props files."
- @ ${ECHO_MSG} "---------------------------------------------------------"
- @ ${CAT} ${PKGDIR}/pkg-plist.jdbc >> ${TMPPLIST}
-.if !defined(NOPORTDOCS)
- @ ${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
- @ ${CAT} ${PKGDIR}/pkg-plist.doc >> ${TMPPLIST}
+ @ ${MKDIR} -m 0555 ${PREFIX}/share/examples/postgresql ;\
+ cd ${WRKSRC}/src/interfaces/jdbc/example ;\
+ pax -rw . ${PREFIX}/share/examples/postgresql
+.for i in README Implementation
+ @ ${INSTALL_DATA} ${WRKSRC}/src/interfaces/jdbc/$i \
+ ${PREFIX}/share/examples/postgresql
+.endfor
+ @ ${ECHO_MSG} "---------------------------------------------------------------"
+ @ ${ECHO_MSG} "Putting java examples into ${PREFIX}/share/examples/postgresql"
+ @ ${ECHO_MSG} "---------------------------------------------------------------"
.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}
+.for file in ecpg pg_dump pg_id pg_passwd pg_restore postgres psql
+ @ strip ${PREFIX}/${PG_PREFIX}bin/${file}
.endfor
.endif
+# information overload mode activated, sorry about this... ;-)
+ @ ${CAT} ${FILESDIR}/post-install-notes ${PKGMESSAGE} |\
+ ${SED} "s|/usr/local|${PREFIX}|g" |\
+ tee ${PREFIX}/share/postgresql/post-install-notes ;\
+ ${INSTALL_DATA} ${PREFIX}/share/postgresql/post-install-notes ~pgsql/. ;\
+ ${CHOWN} -R pgsql:pgsql ~pgsql/.
+.if defined(WITH_OLD_LAYOUT)
+ @ ${CHOWN} root:pgsql ${PREFIX}/${PG_PREFIX}lib
+.endif
+
+post-clean:
+ @ ${RM} -f ${WRKDIRPREFIX}${.CURDIR}/Makefile.inc
+
+post-extract: ${POSTEXTRACT}
.include <bsd.port.mk>
diff --git a/japanese/postgresql7/distinfo b/japanese/postgresql7/distinfo
index c5af8d1acc8f..bc6fb7e17a8a 100644
--- a/japanese/postgresql7/distinfo
+++ b/japanese/postgresql7/distinfo
@@ -1,3 +1,3 @@
-MD5 (postgresql/postgresql-7.0.3.tar.gz) = b416c04e6c91967160dfde866293ee6f
-MD5 (postgresql/jumbo-20001204.patch.gz) = 33cc7445672f716aad5271a346a047d9
-MD5 (postgresql/psqlj-7.0.3.diff.gz) = 7829c90358532bd232d744909283d9e1
+MD5 (postgresql/postgresql-7.1.tar.gz) = 5499444696d919f9fbf2efcaf8e54022
+MD5 (postgresql/jumbo-20010429.patch.gz) = a9a73c72e8fdbfc1d40b27b1e5c72caa
+MD5 (postgresql/psqlj-7.1.diff.gz) = a4b98390c637dffffdb168a9cdb30ff9
diff --git a/japanese/postgresql7/files/dot.cshrc.in b/japanese/postgresql7/files/dot.cshrc.in
new file mode 100644
index 000000000000..a326041bff7b
--- /dev/null
+++ b/japanese/postgresql7/files/dot.cshrc.in
@@ -0,0 +1,13 @@
+set path = ( %%PREFIX%%/%%PG_PREFIX%%bin $path )
+
+setenv PGLIB %%PREFIX%%/%%PG_PREFIX%%lib
+
+# note: PGDATA can be overridden by the -D startup option
+setenv PGDATA $HOME/data
+
+#You might want to set some locale stuff here
+#setenv PGDATESTYLE ISO
+#setenv LC_ALL sv_SE.ISO_8859-1
+
+# if you want to make regression tests use this TZ
+#setenv TZ PST8PDT
diff --git a/japanese/postgresql7/files/dot.profile.in b/japanese/postgresql7/files/dot.profile.in
new file mode 100644
index 000000000000..4aca6aadd19a
--- /dev/null
+++ b/japanese/postgresql7/files/dot.profile.in
@@ -0,0 +1,18 @@
+# both new and old layout's paths, but new path first...
+PATH=%%PREFIX%%/%%PG_PREFIX%%bin:${PATH}
+
+PGLIB=%%PREFIX%%/%%PG_PREFIX%%lib
+
+# note: PGDATA can be overridden by the -D startup option
+PGDATA=${HOME}/data
+
+export PATH PGLIB PGDATA
+
+#You might want to set some locale stuff here
+#PGDATESTYLE=ISO
+#LC_ALL=sv_SE.ISO_8859-1
+#export PGDATESTYLE LC_ALL
+
+# if you want to make regression tests use this TZ
+#TZ=PST8PDT
+#export TZ
diff --git a/japanese/postgresql7/files/patch-ab b/japanese/postgresql7/files/patch-ab
deleted file mode 100644
index 3be237663dd4..000000000000
--- a/japanese/postgresql7/files/patch-ab
+++ /dev/null
@@ -1,66 +0,0 @@
---- 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 */
-+#endif
- char *comname;
- 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);
-
-@@ -150,7 +153,7 @@
-
- if (q != NULL)
- *(q++) = '\0';
-- if (strlen(p) != 13)
-+ if (strlen(p) > _PASSWORD_LEN)
- {
- fprintf(stderr, "WARNING: %s: line %d: illegal password length.\n",
- filename, npwds + 1);
-@@ -214,7 +217,7 @@
- }
-
- static void
--encrypt_pwd(char key[9], char salt[3], char passwd[14])
-+encrypt_pwd(char key[9], char salt[3], char passwd[_PASSWORD_LEN+1])
- {
- int n;
-
-@@ -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];
-@@ -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+1) == 0 ? 1 : 0;
- }
-
- #endif
-@@ -332,7 +335,7 @@
- char salt[3];
- char key[9],
- key2[9];
-- char e_passwd[14];
-+ char e_passwd[_PASSWORD_LEN+1];
- int i;
-
- comname = argv[0];
diff --git a/japanese/postgresql7/files/patch-ac b/japanese/postgresql7/files/patch-ac
deleted file mode 100644
index f0f0ac586e74..000000000000
--- a/japanese/postgresql7/files/patch-ac
+++ /dev/null
@@ -1,11 +0,0 @@
---- 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
deleted file mode 100644
index ea1b852b3f87..000000000000
--- a/japanese/postgresql7/files/patch-ad
+++ /dev/null
@@ -1,11 +0,0 @@
---- 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
-
- # 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
deleted file mode 100644
index 82a8e0012494..000000000000
--- a/japanese/postgresql7/files/patch-ae
+++ /dev/null
@@ -1,11 +0,0 @@
---- ../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
deleted file mode 100644
index 58d833335108..000000000000
--- a/japanese/postgresql7/files/patch-af
+++ /dev/null
@@ -1,25 +0,0 @@
---- 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
deleted file mode 100644
index e15a1521b855..000000000000
--- a/japanese/postgresql7/files/patch-ag
+++ /dev/null
@@ -1,11 +0,0 @@
---- 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-aj b/japanese/postgresql7/files/patch-aj
new file mode 100644
index 000000000000..94c0d6d79991
--- /dev/null
+++ b/japanese/postgresql7/files/patch-aj
@@ -0,0 +1,118 @@
+--- src/bin/pg_passwd/pg_passwd.c.orig Sat Mar 24 01:54:55 2001
++++ src/bin/pg_passwd/pg_passwd.c Wed Apr 18 04:54:14 2001
+@@ -7,6 +7,12 @@
+ #include <errno.h>
+ #include <time.h>
+ #include <ctype.h>
++
++#if defined(__FreeBSD__)
++#include <pwd.h> /* defines _PASSWORD_LEN, max # of characters in a password */
++#include <sys/time.h> /* gettimeofday for password salt */
++#endif
++
+ #define issaltchar(c) (isalnum((unsigned char) (c)) || (c) == '.' || (c) == '/')
+
+ #ifdef HAVE_TERMIOS_H
+@@ -23,18 +29,31 @@
+ * We assume that the output of crypt(3) is always 13 characters,
+ * and that at most 8 characters can usefully be sent to it.
+ *
++ * For FreeBSD, take these values from /usr/include/pwd.h
+ * Postgres usernames are assumed to be less than NAMEDATALEN chars long.
+ */
++#if defined(__FreeBSD__)
++#define CLEAR_PASSWD_LEN _PASSWORD_LEN
++#define CRYPTED_PASSWD_LEN _PASSWORD_LEN /* max length, not containing NULL */
++#define SALT_LEN 10
++#else
+ #define CLEAR_PASSWD_LEN 8 /* not including null */
+ #define CRYPTED_PASSWD_LEN 13 /* not including null */
++#define SALT_LEN 3
++#endif
++
++static unsigned char itoa64[] = /* 0 ... 63 => ascii - 64 */
++ "./0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz";
++
+
+ const char *progname;
+
+ static void usage(void);
++static void to64(char *s, long v, int n);
+ static void read_pwd_file(char *filename);
+ static void write_pwd_file(char *filename, char *bkname);
+ static void encrypt_pwd(char key[CLEAR_PASSWD_LEN + 1],
+- char salt[3],
++ char salt[SALT_LEN],
+ char passwd[CRYPTED_PASSWD_LEN + 1]);
+ static void prompt_for_username(char *username);
+ static void prompt_for_password(char *prompt, char *password);
+@@ -47,6 +66,15 @@
+ printf("Report bugs to <pgsql-bugs@postgresql.org>.\n");
+ }
+
++static void
++to64(char *s, long v, int n)
++{
++ while (--n >= 0) {
++ *s++ = itoa64[v&0x3f];
++ v >>= 6;
++ }
++}
++
+ typedef struct
+ {
+ char *uname;
+@@ -154,7 +182,7 @@
+ if (q != NULL)
+ *(q++) = '\0';
+
+- if (strlen(p) != CRYPTED_PASSWD_LEN && strcmp(p, "+") != 0)
++ if (strlen(p) > CRYPTED_PASSWD_LEN && strcmp(p, "+") != 0)
+ {
+ fprintf(stderr, "%s:%d: warning: invalid password length\n",
+ filename, npwds + 1);
+@@ -221,15 +249,25 @@
+
+ static void
+ encrypt_pwd(char key[CLEAR_PASSWD_LEN + 1],
+- char salt[3],
++ char salt[SALT_LEN],
+ char passwd[CRYPTED_PASSWD_LEN + 1])
+ {
++#if !defined(__FreeBSD__)
+ int n;
+-
++#endif
+ /* select a salt, if not already given */
+ if (salt[0] == '\0')
+ {
++#if defined(__FreeBSD__)
++ struct timeval tv;
++ srandomdev();
++ gettimeofday(&tv,0);
++ to64(&salt[0], random(), 3);
++ to64(&salt[3], tv.tv_usec, 3);
++ to64(&salt[6], tv.tv_sec, 2);
++ salt[8] = '\0';
+ srand(time(NULL));
++#else
+ do
+ {
+ n = rand() % 256;
+@@ -241,6 +279,7 @@
+ } while (!issaltchar(n));
+ salt[1] = n;
+ salt[2] = '\0';
++#endif
+ }
+
+ /* get encrypted password */
+@@ -335,7 +374,7 @@
+ char *filename;
+ char bkname[MAXPGPATH];
+ char username[NAMEDATALEN];
+- char salt[3];
++ char salt[SALT_LEN];
+ char key[CLEAR_PASSWD_LEN + 1],
+ key2[CLEAR_PASSWD_LEN + 1];
+ char e_passwd[CRYPTED_PASSWD_LEN + 1];
diff --git a/japanese/postgresql7/files/patch-bc b/japanese/postgresql7/files/patch-bc
deleted file mode 100644
index e4e98dd945b0..000000000000
--- a/japanese/postgresql7/files/patch-bc
+++ /dev/null
@@ -1,5 +0,0 @@
---- 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/patch-bd b/japanese/postgresql7/files/patch-bd
new file mode 100644
index 000000000000..95e6d276b744
--- /dev/null
+++ b/japanese/postgresql7/files/patch-bd
@@ -0,0 +1,11 @@
+--- ./configure.orig Sat Apr 14 06:22:46 2001
++++ ./configure Thu May 3 21:42:09 2001
+@@ -3053,7 +3053,7 @@
+
+ if test "$with_tk" = yes; then
+ # Extract the first word of "wish", so it can be a program name with args.
+-set dummy wish; ac_word=$2
++set dummy wish8.0jp; ac_word=$2
+ echo $ac_n "checking for $ac_word""... $ac_c" 1>&6
+ echo "configure:3059: checking for $ac_word" >&5
+ if eval "test \"`echo '$''{'ac_cv_path_WISH'+set}'`\" = set"; then
diff --git a/japanese/postgresql7/files/patch-contrib-retep-build b/japanese/postgresql7/files/patch-contrib-retep-build
new file mode 100644
index 000000000000..30df3a0e72c9
--- /dev/null
+++ b/japanese/postgresql7/files/patch-contrib-retep-build
@@ -0,0 +1,10 @@
+--- contrib/retep/build.xml~ Fri Mar 16 22:50:36 2001
++++ contrib/retep/build.xml Wed Apr 18 09:24:20 2001
+@@ -38,6 +38,7 @@
+ <target name="compile" depends="checks,prepare">
+ <javac srcdir="${src}" destdir="${dest}">
+ <include name="${package}/**" />
++ <exclude name="${package}/**" unless="jdk1.2+" />
+ </javac>
+ </target>
+
diff --git a/japanese/postgresql7/files/patch-doc-makefile b/japanese/postgresql7/files/patch-doc-makefile
new file mode 100644
index 000000000000..fa27bed2af3f
--- /dev/null
+++ b/japanese/postgresql7/files/patch-doc-makefile
@@ -0,0 +1,19 @@
+--- doc/Makefile~ Sun Jan 7 03:03:22 2001
++++ doc/Makefile Wed Apr 18 08:12:30 2001
+@@ -43,10 +43,13 @@
+ gzip -d -c man.tar.gz | ( cd $(DESTDIR)$(mandir) && $(TAR) xf - )
+ endif
+
+-
+ installdirs:
+- $(mkinstalldirs) $(DESTDIR)$(mandir) $(DESTDIR)$(docdir)/html
+-
++ifdef found_html
++ $(mkinstalldirs) $(DESTDIR)$(docdir)/html
++endif
++ifdef found_man
++ $(mkinstalldirs) $(DESTDIR)$(mandir)
++endif
+
+ uninstall:
+ ifdef found_html
diff --git a/japanese/postgresql7/files/patch-jdbc-build-xml b/japanese/postgresql7/files/patch-jdbc-build-xml
new file mode 100644
index 000000000000..b1c703a9c978
--- /dev/null
+++ b/japanese/postgresql7/files/patch-jdbc-build-xml
@@ -0,0 +1,10 @@
+--- src/interfaces/jdbc/build.xml~ Fri Mar 16 22:50:43 2001
++++ src/interfaces/jdbc/build.xml Wed Apr 18 08:57:57 2001
+@@ -120,6 +120,7 @@
+ <javac srcdir="${src}" destdir="${dest}">
+ <include name="example/**" />
+ <exclude name="example/corba/**"/>
++ <exclude name="example/blobtest.java" unless="jdk1.2+"/>
+ </javac>
+ </target>
+
diff --git a/japanese/postgresql7/files/patch-jdbc1-statement b/japanese/postgresql7/files/patch-jdbc1-statement
new file mode 100644
index 000000000000..41a9a2971f5a
--- /dev/null
+++ b/japanese/postgresql7/files/patch-jdbc1-statement
@@ -0,0 +1,13 @@
+--- src/interfaces/jdbc/org/postgresql/jdbc1/Statement.java~ Fri Feb 23 19:12:23 2001
++++ src/interfaces/jdbc/org/postgresql/jdbc1/Statement.java Wed Apr 18 08:51:03 2001
+@@ -288,8 +288,8 @@
+ */
+ public java.sql.ResultSet getResultSet() throws SQLException
+ {
+- if (result != null) && ((org.postgresql.ResultSet)result.reallyResultSet())
+- return result;
++ if (result != null && ((org.postgresql.ResultSet)result).reallyResultSet())
++ return result;
+ return null;
+ }
+
diff --git a/japanese/postgresql7/files/pgsql.sh.tmpl b/japanese/postgresql7/files/pgsql.sh.tmpl
index e1673b4850c2..cd78771219ed 100644
--- a/japanese/postgresql7/files/pgsql.sh.tmpl
+++ b/japanese/postgresql7/files/pgsql.sh.tmpl
@@ -2,28 +2,30 @@
# $FreeBSD$
#
-# For postmaster startup options, edit $PGDATA/postmaster.opts.default
-# Preinstalled options are -i -o "-F"
+# For postmaster startup options, edit $PGDATA/postgresql.conf
+
+PGBIN=%%PREFIX%%/%%PG_PREFIX%%bin
case $1 in
start)
- [ -d !!PREFIX!!/pgsql/lib ] && /sbin/ldconfig -m !!PREFIX!!/pgsql/lib
- [ -x !!PREFIX!!/pgsql/bin/pg_ctl ] && {
+ [ -d %%PREFIX%%/%%PG_PREFIX%%lib ] && /sbin/ldconfig -m %%PREFIX%%/%%PG_PREFIX%%lib
+ [ -x ${PGBIN}/pg_ctl ] && {
su -l pgsql -c \
- 'exec !!PREFIX!!/pgsql/bin/pg_ctl -w start > !!PREFIX!!/pgsql/errlog 2>&1'
+ '[ -d ${PGDATA} ] && exec %%PREFIX%%/%%PG_PREFIX%%bin/pg_ctl start -s -w -l ~pgsql/errlog'
echo -n ' pgsql'
}
;;
stop)
- [ -x !!PREFIX!!/pgsql/bin/pg_ctl ] && {
- su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/pg_ctl -w -m fast stop'
+ [ -x ${PGBIN}/pg_ctl ] && {
+ su -l pgsql -c 'exec %%PREFIX%%/%%PG_PREFIX%%bin/pg_ctl stop -s -m fast'
+ echo -n ' pgsql'
}
;;
status)
- [ -x !!PREFIX!!/pgsql/bin/pg_ctl ] && {
- su -l pgsql -c 'exec !!PREFIX!!/pgsql/bin/pg_ctl status'
+ [ -x ${PGBIN}/pg_ctl ] && {
+ exec su -l pgsql -c 'exec %%PREFIX%%/%%PG_PREFIX%%bin/pg_ctl status'
}
;;
diff --git a/japanese/postgresql7/files/pkgIndex.tcl.in b/japanese/postgresql7/files/pkgIndex.tcl.in
new file mode 100644
index 000000000000..bd8329b15c69
--- /dev/null
+++ b/japanese/postgresql7/files/pkgIndex.tcl.in
@@ -0,0 +1,4 @@
+# Package-index file for Pgtcl-package. Enables you to load PostgreSQL
+# interface functions right into you TCL-interpreter as simply as
+# package require Pgtcl
+package ifneeded Pgtcl 1.3 "load %%PREFIX%%/lib/libpgtcl.so"
diff --git a/japanese/postgresql7/files/post-install-notes b/japanese/postgresql7/files/post-install-notes
index 289a7651109a..6b7192b31895 100644
--- a/japanese/postgresql7/files/post-install-notes
+++ b/japanese/postgresql7/files/post-install-notes
@@ -8,9 +8,15 @@ 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 built PostgreSQL with TCL support, you can install the port
-"pgaccess" to get a TCL/TK based database frontend for database
-operations.
+If you built PostgreSQL with TCL/TK support, you can use the pgaccess
+utility to get a TCL/TK based database frontend for database
+operations. You do NOT need to install the pgaccess port separately.
-To start PostgreSQL, run the startup script:
-$PREFIX/etc/rc.d/pgsql.sh start
+If you built in the TCL support, you can load the Pg package into your
+TCL scripts as easily as ``package require Pgtcl''.
+
+If you built with Java support, add
+/usr/local/share/java/classes/postgresql.jar to your classpath.
+
+If you have many tables and many clients running, consider raising
+kern.maxfiles using sysctl(8).
diff --git a/japanese/postgresql7/files/pre-install-notes b/japanese/postgresql7/files/pre-install-notes
new file mode 100644
index 000000000000..697ce3cedb79
--- /dev/null
+++ b/japanese/postgresql7/files/pre-install-notes
@@ -0,0 +1,21 @@
+ * IMPORTANT UPGRADE NOTICE * IMPORTANT UPGRADE NOTICE *
+
+The PostgreSQL port now obeys hier(7) by default, which means that it
+installs into:
+
+%%PREFIX%%/bin
+%%PREFIX%%/lib
+%%PREFIX%%/include/pgsql
+
+You *must* move away your old installation to avoid problems with
+ldconfig(8) and user's PATH:s. If you rather install using the
+old-fashion layout, cancel at next screen and run make as:
+
+$ make -DWITH_OLD_LAYOUT
+
+As always, you *must* dump existing databases before stopping and
+removing your old postgresql, as part of the update. This is *NOT*
+done by this port!
+
+If you want JAVA support, I will try to determine your JAVA_HOME using
+javavmwrapper. If you want a different JVM, please set JAVA_HOME.
diff --git a/japanese/postgresql7/pkg-install b/japanese/postgresql7/pkg-install
index 54236ee36845..ffbe8f031b17 100644
--- a/japanese/postgresql7/pkg-install
+++ b/japanese/postgresql7/pkg-install
@@ -1,18 +1,16 @@
#! /bin/sh
-# $FreeBSD: /tmp/pcvs/ports/japanese/postgresql7/Attic/pkg-install,v 1.5 2000-11-03 09:34:11 knu Exp $
+# $FreeBSD: /tmp/pcvs/ports/japanese/postgresql7/Attic/pkg-install,v 1.6 2001-05-08 12:35:59 knu Exp $
PATH=/bin:/usr/sbin
-if [ -z "${DB_DIR}" ]; then
- DB_DIR=${PKG_PREFIX}/pgsql/data
-fi
+DB_DIR=${PKG_PREFIX}/pgsql
case $2 in
-POST-INSTALL)
+PRE-INSTALL)
USER=pgsql
GROUP=${USER}
- UID=89
+ UID=70
GID=${UID}
if pw group show "${GROUP}" 2>/dev/null; then
@@ -30,7 +28,7 @@ POST-INSTALL)
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"
+ -d ${DB_DIR} -c "PostgreSQL Daemon"
then
echo "Added user \"${USER}\"."
else
@@ -39,6 +37,10 @@ POST-INSTALL)
fi
fi
- chown -R ${USER}.${GROUP} ${DB_DIR}
+ if ! [ -x ~pgsql ] ; then
+ mkdir -p ${DB_DIR}
+ chown pgsql:pgsql ${DB_DIR}
+ fi
;;
+
esac
diff --git a/japanese/postgresql7/pkg-message b/japanese/postgresql7/pkg-message
new file mode 100644
index 000000000000..b686422872c1
--- /dev/null
+++ b/japanese/postgresql7/pkg-message
@@ -0,0 +1,38 @@
+
+======================================================================
+
+ * IMPORTANT UPGRADE NOTICE * IMPORTANT UPGRADE NOTICE *
+
+The PostgreSQL port now obeys hier(7) by default, which means that it
+installs into:
+
+/usr/local/bin
+/usr/local/lib
+/usr/local/include/pgsql
+
+You *must* move away your old installation from users' and
+ldconfig(8)'s PATHs. If you rather install using the old-fashion
+layout, cancel now and build the port with "make -DWITH_OLD_LAYOUT".
+
+The pgsql user's home dir is /usr/local/pgsql by default, but can be
+changed with for example chpass(1). Datadir defaults to ~pgsql/data,
+but can be changed by modifying the ~pgsql/.profile script.
+
+As always, you *must* dump existing databases before stopping and
+removing your old postgresql, as part of the update. This is *NOT*
+done by this port!
+
+======================================================================
+
+To initialize the database, you should run initdb as the "pgsql" user.
+
+Example:
+
+ su -l pgsql -c initdb
+
+You can then start PostgreSQL by running:
+
+ /usr/local/etc/rc.d/010.pgsql.sh start
+
+For postmaster settings, see ~pgsql/data/postmaster.conf
+======================================================================
diff --git a/japanese/postgresql7/pkg-plist b/japanese/postgresql7/pkg-plist
index 5c17666b86b4..49fa6c4e33ad 100644
--- a/japanese/postgresql7/pkg-plist
+++ b/japanese/postgresql7/pkg-plist
@@ -1,169 +1,91 @@
-etc/rc.d/pgsql.sh
-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_encoding
-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/psqlj
-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/libpq-fs.h
-pgsql/include/libpq/pqcomm.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++.h
-pgsql/include/libpq-fe.h
-pgsql/include/libpq-int.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_hba.conf.sample
-pgsql/lib/pg_ident.conf.sample
-pgsql/lib/pg_options.sample
-pgsql/lib/plpgsql.so
-pgsql/lib/postmaster.opts.default.sample
-pgsql/post-install-notes
-@dirrm pgsql/bin
-@dirrm pgsql/data/base/template1
-@dirrm pgsql/data/base
-@dirrm pgsql/data/pg_xlog
-@dirrm pgsql/data
-@dirrm pgsql/include/access
-@dirrm pgsql/include/commands
-@dirrm pgsql/include/executor
-@dirrm pgsql/include/lib
-@dirrm pgsql/include/libpq
-@dirrm pgsql/include/libpq++
-@dirrm pgsql/include/port/freebsd
-@dirrm pgsql/include/port
-@dirrm pgsql/include/utils
-@dirrm pgsql/include
-@dirrm pgsql/lib
-@dirrm pgsql/man/man1
-@dirrm pgsql/man/manl
-@dirrm pgsql/man
-@dirrm pgsql
+%%PG_PREFIX%%bin/postmaster
+%%PG_PREFIX%%bin/postgres
+%%PG_PREFIX%%bin/ecpg
+%%PG_PREFIX%%bin/initdb
+%%PG_PREFIX%%bin/initlocation
+%%PG_PREFIX%%bin/ipcclean
+%%PG_PREFIX%%bin/pg_ctl
+%%PG_PREFIX%%bin/pg_dump
+%%PG_PREFIX%%bin/pg_restore
+%%PG_PREFIX%%bin/pg_encoding
+%%PG_PREFIX%%bin/pg_dumpall
+%%PG_PREFIX%%bin/pg_id
+%%PG_PREFIX%%bin/pg_passwd
+%%PG_PREFIX%%bin/psql
+%%PG_PREFIX%%bin/psqlj
+%%PG_PREFIX%%bin/createdb
+%%PG_PREFIX%%bin/dropdb
+%%PG_PREFIX%%bin/createuser
+%%PG_PREFIX%%bin/dropuser
+%%PG_PREFIX%%bin/droplang
+%%PG_PREFIX%%bin/vacuumdb
+%%PG_PREFIX%%bin/createlang
+%%PG_PREFIX%%bin/pg_config
+etc/rc.d/010.pgsql.sh
+%%PG_INCLUDE%%/lib/dllist.h
+@dirrm %%PG_INCLUDE%%/lib
+%%PG_INCLUDE%%/libpq/pqcomm.h
+%%PG_INCLUDE%%/libpq/libpq-fs.h
+@dirrm %%PG_INCLUDE%%/libpq
+%%PG_INCLUDE%%/libpq++/pgconnection.h
+%%PG_INCLUDE%%/libpq++/pgdatabase.h
+%%PG_INCLUDE%%/libpq++/pgtransdb.h
+%%PG_INCLUDE%%/libpq++/pgcursordb.h
+%%PG_INCLUDE%%/libpq++/pglobject.h
+@dirrm %%PG_INCLUDE%%/libpq++
+%%PG_INCLUDE%%/c.h
+%%PG_INCLUDE%%/postgres_ext.h
+%%PG_INCLUDE%%/postgres_fe.h
+%%PG_INCLUDE%%/os.h
+%%PG_INCLUDE%%/config.h
+%%PG_INCLUDE%%/libpq-fe.h
+%%PG_INCLUDE%%/libpq-int.h
+%%PG_INCLUDE%%/pqexpbuffer.h
+%%PG_INCLUDE%%/ecpgerrno.h
+%%PG_INCLUDE%%/ecpglib.h
+%%PG_INCLUDE%%/ecpgtype.h
+%%PG_INCLUDE%%/sqlca.h
+%%PG_INCLUDE%%/sql3types.h
+%%PG_INCLUDE%%/libpgeasy.h
+%%PG_INCLUDE%%/libpq++.h
+@dirrm %%PG_INCLUDE%%
+%%PG_PREFIX%%lib/libpq.so
+%%PG_PREFIX%%lib/libpq.a
+%%PG_PREFIX%%lib/libpq.so.2
+%%PG_PREFIX%%lib/libecpg.so
+%%PG_PREFIX%%lib/libecpg.a
+%%PG_PREFIX%%lib/libecpg.so.3
+%%PG_PREFIX%%lib/libpgeasy.so
+%%PG_PREFIX%%lib/libpgeasy.a
+%%PG_PREFIX%%lib/libpgeasy.so.2
+%%PG_PREFIX%%lib/libpq++.so
+%%PG_PREFIX%%lib/libpq++.a
+%%PG_PREFIX%%lib/libpq++.so.3
+%%PG_PREFIX%%lib/plpgsql.so
+share/postgresql/global.bki
+share/postgresql/global.description
+share/postgresql/post-install-notes
+share/postgresql/template1.bki
+share/postgresql/template1.description
+share/postgresql/pg_hba.conf.sample
+share/postgresql/pg_ident.conf.sample
+share/postgresql/postgresql.conf.sample
+@unexec if cmp -s ~pgsql/.profile %D/share/postgresql/dot.profile.dist; then rm -f ~pgsql/.profile; fi
+@unexec if cmp -s ~pgsql/.cshrc %D/share/postgresql/dot.cshrc.dist; then rm -f ~pgsql/.cshrc; fi
+@unexec [ -f ~pgsql/dot.profile.dist ] && rm ~pgsql/dot.profile.dist
+@unexec [ -f ~pgsql/dot.cshrc.dist ] && rm ~pgsql/dot.cshrc.dist
+@exec [ -f %D/share/postgresql/post-install-notes ] && cp %D/share/postgresql/post-install-notes ~pgsql && chown pgsql:pgsql ~pgsql/post-install-notes
+@unexec [ -f ~pgsql/post-install-notes ] && rm ~pgsql/post-install-notes
+share/postgresql/dot.profile.dist
+share/postgresql/dot.cshrc.dist
+@dirrm share/postgresql
+@exec [ -f %D/share/postgresql/dot.profile.dist ] && cp %D/share/postgresql/dot.profile.dist ~pgsql/.
+@exec [ -f %D/share/postgresql/dot.cshrc.dist ] && cp %D/share/postgresql/dot.cshrc.dist ~pgsql/.
+@exec [ -f ~pgsql/.profile ] || (cp %D/share/postgresql/dot.profile.dist ~pgsql/.profile && chown pgsql:pgsql ~pgsql/.profile)
+@exec [ -f ~pgsql/.cshrc ] || (cp %D/share/postgresql/dot.cshrc.dist ~pgsql/.cshrc && chown pgsql:pgsql ~pgsql/.cshrc)
+@unexec rmdir %D/%%PG_PREFIX%%bin 2> /dev/null || true
+@unexec rmdir %D/%%PG_PREFIX%%lib 2> /dev/null || true
+@unexec rmdir %D/%%PG_PREFIX%%man/man1 2> /dev/null || true
+@unexec rmdir %D/%%PG_PREFIX%%man/manl 2> /dev/null || true
+@unexec rmdir %D/%%PG_PREFIX%%man 2> /dev/null || true
+@unexec echo "Warning: If you will *NOT* use this package anymore, please remove %D/pgsql and the pgsql user manually."
diff --git a/japanese/postgresql7/pkg-plist.doc b/japanese/postgresql7/pkg-plist.doc
index 06b7bd9ea116..34366cec7aaa 100644
--- a/japanese/postgresql7/pkg-plist.doc
+++ b/japanese/postgresql7/pkg-plist.doc
@@ -1,888 +1,491 @@
-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/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
-@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
+share/doc/postgresql/html/admin.html
+share/doc/postgresql/html/advanced.html
+share/doc/postgresql/html/altern-locations.html
+share/doc/postgresql/html/app-createdb.html
+share/doc/postgresql/html/app-createlang.html
+share/doc/postgresql/html/app-createuser.html
+share/doc/postgresql/html/app-dropdb.html
+share/doc/postgresql/html/app-droplang.html
+share/doc/postgresql/html/app-dropuser.html
+share/doc/postgresql/html/app-ecpg.html
+share/doc/postgresql/html/app-initdb.html
+share/doc/postgresql/html/app-initlocation.html
+share/doc/postgresql/html/app-ipcclean.html
+share/doc/postgresql/html/app-pg-ctl.html
+share/doc/postgresql/html/app-pg-dumpall.html
+share/doc/postgresql/html/app-pg-passwd.html
+share/doc/postgresql/html/app-pgaccess.html
+share/doc/postgresql/html/app-pgadmin.html
+share/doc/postgresql/html/app-pgconfig.html
+share/doc/postgresql/html/app-pgdump.html
+share/doc/postgresql/html/app-pgrestore.html
+share/doc/postgresql/html/app-pgtclsh.html
+share/doc/postgresql/html/app-pgtksh.html
+share/doc/postgresql/html/app-postgres.html
+share/doc/postgresql/html/app-postmaster.html
+share/doc/postgresql/html/app-psql.html
+share/doc/postgresql/html/app-vacuumdb.html
+share/doc/postgresql/html/applevel-consistency.html
+share/doc/postgresql/html/arch-pg.html
+share/doc/postgresql/html/arch.html
+share/doc/postgresql/html/arrays.html
+share/doc/postgresql/html/auth-methods.html
+share/doc/postgresql/html/backup-file.html
+share/doc/postgresql/html/backup.html
+share/doc/postgresql/html/biblio.html
+share/doc/postgresql/html/bki-commands.html
+share/doc/postgresql/html/bki-example.html
+share/doc/postgresql/html/bki.html
+share/doc/postgresql/html/bug-reporting.html
+share/doc/postgresql/html/catalog-pg-aggregate.html
+share/doc/postgresql/html/catalog-pg-attrdef.html
+share/doc/postgresql/html/catalog-pg-attribute.html
+share/doc/postgresql/html/catalog-pg-class.html
+share/doc/postgresql/html/catalog-pg-database.html
+share/doc/postgresql/html/catalog-pg-description.html
+share/doc/postgresql/html/catalog-pg-group.html
+share/doc/postgresql/html/catalog-pg-index.html
+share/doc/postgresql/html/catalog-pg-inherits.html
+share/doc/postgresql/html/catalog-pg-language.html
+share/doc/postgresql/html/catalog-pg-operator.html
+share/doc/postgresql/html/catalog-pg-proc.html
+share/doc/postgresql/html/catalog-pg-relcheck.html
+share/doc/postgresql/html/catalog-pg-shadow.html
+share/doc/postgresql/html/catalog-pg-type.html
+share/doc/postgresql/html/catalogs.html
+share/doc/postgresql/html/charset.html
+share/doc/postgresql/html/client-authentication-problems.html
+share/doc/postgresql/html/client-authentication.html
+share/doc/postgresql/html/compiler.html
+share/doc/postgresql/html/connect-estab.html
+share/doc/postgresql/html/creating-cluster.html
+share/doc/postgresql/html/cvs-tree.html
+share/doc/postgresql/html/cvs.html
+share/doc/postgresql/html/cvsup.html
+share/doc/postgresql/html/datatype-bit.html
+share/doc/postgresql/html/datatype-boolean.html
+share/doc/postgresql/html/datatype-character.html
+share/doc/postgresql/html/datatype-datetime.html
+share/doc/postgresql/html/datatype-geometric.html
+share/doc/postgresql/html/datatype-money.html
+share/doc/postgresql/html/ecpg.html
+share/doc/postgresql/html/datatype-net-types.html
+share/doc/postgresql/html/datatype.html
+share/doc/postgresql/html/datetime-appendix.html
+share/doc/postgresql/html/db-accessing.html
+share/doc/postgresql/html/db-destroy.html
+share/doc/postgresql/html/developer.html
+share/doc/postgresql/html/doc-build.html
+share/doc/postgresql/html/doc-sources.html
+share/doc/postgresql/html/doc-toolsets.html
+share/doc/postgresql/html/docguide.html
+share/doc/postgresql/html/ecpg-concept.html
+share/doc/postgresql/html/ecpg-develop.html
+share/doc/postgresql/html/ecpg-limitations.html
+share/doc/postgresql/html/ecpg-porting.html
+share/doc/postgresql/html/ecpg-use.html
+share/doc/postgresql/html/executor.html
+share/doc/postgresql/html/explicit-joins.html
+share/doc/postgresql/html/extend.html
+share/doc/postgresql/html/functions-datetime.html
+share/doc/postgresql/html/functions-aggregate.html
+share/doc/postgresql/html/functions-comparison.html
+share/doc/postgresql/html/functions-conditional.html
+share/doc/postgresql/html/functions-formatting.html
+share/doc/postgresql/html/functions-geometry.html
+share/doc/postgresql/html/functions-matching.html
+share/doc/postgresql/html/functions-math.html
+share/doc/postgresql/html/functions-misc.html
+share/doc/postgresql/html/functions-net.html
+share/doc/postgresql/html/functions-string.html
+share/doc/postgresql/html/functions.html
+share/doc/postgresql/html/geqo-intro2.html
+share/doc/postgresql/html/geqo-pg-intro.html
+share/doc/postgresql/html/geqo.html
+share/doc/postgresql/html/gist.html
+share/doc/postgresql/html/groups.html
+share/doc/postgresql/html/history.html
+share/doc/postgresql/html/index.html
+share/doc/postgresql/html/indexcost.html
+share/doc/postgresql/html/indices-functional.html
+share/doc/postgresql/html/indices-multicolumn.html
+share/doc/postgresql/html/indices-opclass.html
+share/doc/postgresql/html/indices-types.html
+share/doc/postgresql/html/indices-unique.html
+share/doc/postgresql/html/indices.html
+share/doc/postgresql/html/inherit.html
+share/doc/postgresql/html/install-getsource.html
+share/doc/postgresql/html/install-post.html
+share/doc/postgresql/html/install-procedure.html
+share/doc/postgresql/html/install-requirements.html
+share/doc/postgresql/html/install-upgrading.html
+share/doc/postgresql/html/install-win32.html
+share/doc/postgresql/html/installation.html
+share/doc/postgresql/html/jdbc-ext.html
+share/doc/postgresql/html/jdbc-lo.html
+share/doc/postgresql/html/jdbc.html
+share/doc/postgresql/html/jdbc-query.html
+share/doc/postgresql/html/jdbc-reading.html
+share/doc/postgresql/html/jdbc-thread.html
+share/doc/postgresql/html/jdbc-update.html
+share/doc/postgresql/html/jdbc-use.html
+share/doc/postgresql/html/kernel-resources.html
+share/doc/postgresql/html/keys.html
+share/doc/postgresql/html/largeobjects.html
+share/doc/postgresql/html/libpgtcl-examples.html
+share/doc/postgresql/html/libpgtcl-ref.html
+share/doc/postgresql/html/libpq-async.html
+share/doc/postgresql/html/libpq-control.html
+share/doc/postgresql/html/libpq-copy.html
+share/doc/postgresql/html/libpq-envars.html
+share/doc/postgresql/html/libpq-example.html
+share/doc/postgresql/html/libpq-exec.html
+share/doc/postgresql/html/libpq-fastpath.html
+share/doc/postgresql/html/libpq-notify.html
+share/doc/postgresql/html/libpq.html
+share/doc/postgresql/html/libpq-threading.html
+share/doc/postgresql/html/libpq-trace.html
+share/doc/postgresql/html/libpqplusplus.html
+share/doc/postgresql/html/libpqpp-classes.html
+share/doc/postgresql/html/libpqpp-connect.html
+share/doc/postgresql/html/libpqpp-copy.html
+share/doc/postgresql/html/libpqpp-exec.html
+share/doc/postgresql/html/libpqpp-notify.html
+share/doc/postgresql/html/lisp.html
+share/doc/postgresql/html/ln11307.html
+share/doc/postgresql/html/ln1274.html
+share/doc/postgresql/html/ln15103.html
+share/doc/postgresql/html/ln24.html
+share/doc/postgresql/html/ln24896.html
+share/doc/postgresql/html/ln37046.html
+share/doc/postgresql/html/ln8.html
+share/doc/postgresql/html/lo-funcs.html
+share/doc/postgresql/html/lo-implementation.html
+share/doc/postgresql/html/lo-interfaces.html
+share/doc/postgresql/html/lo-libpq.html
+share/doc/postgresql/html/lo-sample.html
+share/doc/postgresql/html/locking-indices.html
+share/doc/postgresql/html/locking-tables.html
+share/doc/postgresql/html/manage-ag-accessdb.html
+share/doc/postgresql/html/manage-ag-dropdb.html
+share/doc/postgresql/html/manage.html
+share/doc/postgresql/html/managing-databases.html
+share/doc/postgresql/html/migration.html
+share/doc/postgresql/html/more-advanced.html
+share/doc/postgresql/html/multibyte.html
+share/doc/postgresql/html/mvcc.html
+share/doc/postgresql/html/non-atomic-values.html
+share/doc/postgresql/html/notation.html
+share/doc/postgresql/html/odbc-applixware.html
+share/doc/postgresql/html/odbc-config.html
+share/doc/postgresql/html/odbc-install.html
+share/doc/postgresql/html/odbc-windows.html
+share/doc/postgresql/html/odbc.html
+share/doc/postgresql/html/organization.html
+share/doc/postgresql/html/overview.html
+share/doc/postgresql/html/page.html
+share/doc/postgresql/html/parser-stage.html
+share/doc/postgresql/html/partial-index.html
+share/doc/postgresql/html/performance-tips.html
+share/doc/postgresql/html/perm-functions.html
+share/doc/postgresql/html/pg-system-catalogs.html
+share/doc/postgresql/html/pgeasy-chapter.html
+share/doc/postgresql/html/pgtcl-pgconndefaults.html
+share/doc/postgresql/html/pgtcl-pgconnect.html
+share/doc/postgresql/html/pgtcl-pgdisconnect.html
+share/doc/postgresql/html/pgtcl-pgexec.html
+share/doc/postgresql/html/pgtcl-pglisten.html
+share/doc/postgresql/html/pgtcl-pgloclose.html
+share/doc/postgresql/html/pgtcl-pglocreat.html
+share/doc/postgresql/html/pgtcl-pgloexport.html
+share/doc/postgresql/html/pgtcl-pgloimport.html
+share/doc/postgresql/html/pgtcl-pglolseek.html
+share/doc/postgresql/html/pgtcl-pgloopen.html
+share/doc/postgresql/html/pgtcl-pgloread.html
+share/doc/postgresql/html/pgtcl-pglotell.html
+share/doc/postgresql/html/pgtcl-pglounlink.html
+share/doc/postgresql/html/pgtcl-pglowrite.html
+share/doc/postgresql/html/pgtcl-pgresult.html
+share/doc/postgresql/html/pgtcl-pgselect.html
+share/doc/postgresql/html/pgtcl.html
+share/doc/postgresql/html/planner-optimizer.html
+share/doc/postgresql/html/plperl-use.html
+share/doc/postgresql/html/plperl.html
+share/doc/postgresql/html/plpgsql-description.html
+share/doc/postgresql/html/plpgsql-examples.html
+share/doc/postgresql/html/plpgsql-porting.html
+share/doc/postgresql/html/plpgsql-trigger.html
+share/doc/postgresql/html/plpgsql.html
+share/doc/postgresql/html/pltcl-description.html
+share/doc/postgresql/html/pltcl.html
+share/doc/postgresql/html/populate.html
+share/doc/postgresql/html/postgres.html
+share/doc/postgresql/html/postmaster-shutdown.html
+share/doc/postgresql/html/postmaster-start.html
+share/doc/postgresql/html/preface.html
+share/doc/postgresql/html/privileges.html
+share/doc/postgresql/html/programmer-client.html
+share/doc/postgresql/html/programmer-pl.html
+share/doc/postgresql/html/programmer-server.html
+share/doc/postgresql/html/programmer.html
+share/doc/postgresql/html/protocol-message-formats.html
+share/doc/postgresql/html/protocol-message-types.html
+share/doc/postgresql/html/protocol-protocol.html
+share/doc/postgresql/html/protocol.html
+share/doc/postgresql/html/pygresql.html
+share/doc/postgresql/html/pygresql-close.html
+share/doc/postgresql/html/pygresql-connect.html
+share/doc/postgresql/html/pygresql-db-api.html
+share/doc/postgresql/html/pygresql-db-clear.html
+share/doc/postgresql/html/pygresql-db-delete.html
+share/doc/postgresql/html/pygresql-db-get-attnames.html
+share/doc/postgresql/html/pygresql-db-get-databases.html
+share/doc/postgresql/html/pygresql-db-get-tables.html
+share/doc/postgresql/html/pygresql-db-get.html
+share/doc/postgresql/html/pygresql-db-insert.html
+share/doc/postgresql/html/pygresql-db-pkey.html
+share/doc/postgresql/html/pygresql-db-update.html
+share/doc/postgresql/html/pygresql-endcopy.html
+share/doc/postgresql/html/pygresql-fileno.html
+share/doc/postgresql/html/pygresql-get-defbase.html
+share/doc/postgresql/html/pygresql-get-defhost.html
+share/doc/postgresql/html/pygresql-get-defopt.html
+share/doc/postgresql/html/pygresql-get-defport.html
+share/doc/postgresql/html/pygresql-get-deftty.html
+share/doc/postgresql/html/pygresql-getline.html
+share/doc/postgresql/html/pygresql-getlo.html
+share/doc/postgresql/html/pygresql-getnotify.html
+share/doc/postgresql/html/pygresql-inserttable.html
+share/doc/postgresql/html/pygresql-locreate.html
+share/doc/postgresql/html/pygresql-loimport.html
+share/doc/postgresql/html/pygresql-pg-db.html
+share/doc/postgresql/html/pygresql-pg-functions.html
+share/doc/postgresql/html/pygresql-pg-pglarge.html
+share/doc/postgresql/html/pygresql-pg-pgobject.html
+share/doc/postgresql/html/pygresql-pg-pgqueryobject.html
+share/doc/postgresql/html/pygresql-pglargeobject-close.html
+share/doc/postgresql/html/pygresql-pglargeobject-export.html
+share/doc/postgresql/html/pygresql-pglargeobject-open.html
+share/doc/postgresql/html/pygresql-pglargeobject-read.html
+share/doc/postgresql/html/pygresql-pglargeobject-seek.html
+share/doc/postgresql/html/pygresql-pglargeobject-size.html
+share/doc/postgresql/html/pygresql-pglargeobject-tell.html
+share/doc/postgresql/html/pygresql-pglargeobject-unlink.html
+share/doc/postgresql/html/pygresql-pglargeobject-write.html
+share/doc/postgresql/html/pygresql-pgqueryobject-dictresult.html
+share/doc/postgresql/html/pygresql-pgqueryobject-fieldname.html
+share/doc/postgresql/html/query.html
+share/doc/postgresql/html/pygresql-pgqueryobject-fieldnum.html
+share/doc/postgresql/html/pygresql-pgqueryobject-getresult.html
+share/doc/postgresql/html/pygresql-pgqueryobject-listfields.html
+share/doc/postgresql/html/pygresql-pgqueryobject-ntuples.html
+share/doc/postgresql/html/pygresql-putline.html
+share/doc/postgresql/html/pygresql-query.html
+share/doc/postgresql/html/pygresql-reset.html
+share/doc/postgresql/html/pygresql-set-defbase.html
+share/doc/postgresql/html/pygresql-set-defhost.html
+share/doc/postgresql/html/pygresql-set-defopt.html
+share/doc/postgresql/html/pygresql-set-defport.html
+share/doc/postgresql/html/pygresql-set-deftty.html
+share/doc/postgresql/html/queries-limit.html
+share/doc/postgresql/html/queries-order.html
+share/doc/postgresql/html/queries-select-lists.html
+share/doc/postgresql/html/queries-union.html
+share/doc/postgresql/html/queries.html
+share/doc/postgresql/html/query-agg.html
+share/doc/postgresql/html/query-concepts.html
+share/doc/postgresql/html/query-delete.html
+share/doc/postgresql/html/query-join.html
+share/doc/postgresql/html/query-populate.html
+share/doc/postgresql/html/query-query.html
+share/doc/postgresql/html/query-selectinto.html
+share/doc/postgresql/html/query-table.html
+share/doc/postgresql/html/query-update.html
+share/doc/postgresql/html/recode.html
+share/doc/postgresql/html/recovery.html
+share/doc/postgresql/html/reference-client.html
+share/doc/postgresql/html/reference-server.html
+share/doc/postgresql/html/reference.html
+share/doc/postgresql/html/regress-platform.html
+share/doc/postgresql/html/regress.html
+share/doc/postgresql/html/release-0-01.html
+share/doc/postgresql/html/release-0-02.html
+share/doc/postgresql/html/release-0-03.html
+share/doc/postgresql/html/release-1-0.html
+share/doc/postgresql/html/release-1-01.html
+share/doc/postgresql/html/release-1-02.html
+share/doc/postgresql/html/release-1-09.html
+share/doc/postgresql/html/release-6-0.html
+share/doc/postgresql/html/release-6-1-1.html
+share/doc/postgresql/html/release-6-1.html
+share/doc/postgresql/html/release-6-2-1.html
+share/doc/postgresql/html/release-6-2.html
+share/doc/postgresql/html/release-6-3-1.html
+share/doc/postgresql/html/release-6-3-2.html
+share/doc/postgresql/html/release-6-3.html
+share/doc/postgresql/html/release-6-4-1.html
+share/doc/postgresql/html/release-6-4-2.html
+share/doc/postgresql/html/release-6-4.html
+share/doc/postgresql/html/release-6-5-1.html
+share/doc/postgresql/html/release-6-5-2.html
+share/doc/postgresql/html/release-6-5-3.html
+share/doc/postgresql/html/release-6-5.html
+share/doc/postgresql/html/release-7-0-1.html
+share/doc/postgresql/html/release-7-0-2.html
+share/doc/postgresql/html/release-7-0-3.html
+share/doc/postgresql/html/release-7-0.html
+share/doc/postgresql/html/release.html
+share/doc/postgresql/html/relmodel-formal.html
+share/doc/postgresql/html/relmodel-oper.html
+share/doc/postgresql/html/resources.html
+share/doc/postgresql/html/rule-system.html
+share/doc/postgresql/html/rules-insert.html
+share/doc/postgresql/html/rules-permissions.html
+share/doc/postgresql/html/rules-triggers.html
+share/doc/postgresql/html/rules-views.html
+share/doc/postgresql/html/rules.html
+share/doc/postgresql/html/runtime-config.html
+share/doc/postgresql/html/runtime.html
+share/doc/postgresql/html/source.html
+share/doc/postgresql/html/spi-examples.html
+share/doc/postgresql/html/spi-interface-support.html
+share/doc/postgresql/html/spi-memory.html
+share/doc/postgresql/html/spi-spiconnect.html
+share/doc/postgresql/html/spi-spicopytuple.html
+share/doc/postgresql/html/spi-spiexec.html
+share/doc/postgresql/html/spi-spiexecp.html
+share/doc/postgresql/html/spi-spifinish.html
+share/doc/postgresql/html/spi-spifname.html
+share/doc/postgresql/html/spi-spifnumber.html
+share/doc/postgresql/html/spi-spigetbinval.html
+share/doc/postgresql/html/spi-spigetrelname.html
+share/doc/postgresql/html/spi-spigettype.html
+share/doc/postgresql/html/spi-spigettypeid.html
+share/doc/postgresql/html/spi-spigetvalue.html
+share/doc/postgresql/html/spi-spimodifytuple.html
+share/doc/postgresql/html/spi-spipalloc.html
+share/doc/postgresql/html/spi-spipfree.html
+share/doc/postgresql/html/spi-spiprepare.html
+share/doc/postgresql/html/spi-spirepalloc.html
+share/doc/postgresql/html/spi-spisaveplan.html
+share/doc/postgresql/html/spi-visibility.html
+share/doc/postgresql/html/spi.html
+share/doc/postgresql/html/sql-abort.html
+share/doc/postgresql/html/sql-altergroup.html
+share/doc/postgresql/html/sql-altertable.html
+share/doc/postgresql/html/sql-alteruser.html
+share/doc/postgresql/html/sql-begin.html
+share/doc/postgresql/html/sql-checkpoint.html
+share/doc/postgresql/html/sql-close.html
+share/doc/postgresql/html/sql-cluster.html
+share/doc/postgresql/html/sql-commands.html
+share/doc/postgresql/html/sql-comment.html
+share/doc/postgresql/html/sql-commit.html
+share/doc/postgresql/html/sql-copy.html
+share/doc/postgresql/html/sql-createaggregate.html
+share/doc/postgresql/html/sql-createconstraint.html
+share/doc/postgresql/html/sql-createdatabase.html
+share/doc/postgresql/html/sql-createfunction.html
+share/doc/postgresql/html/sql-creategroup.html
+share/doc/postgresql/html/sql-createindex.html
+share/doc/postgresql/html/sql-createlanguage.html
+share/doc/postgresql/html/sql-createoperator.html
+share/doc/postgresql/html/sql-createrule.html
+share/doc/postgresql/html/sql-createsequence.html
+share/doc/postgresql/html/sql-createtable.html
+share/doc/postgresql/html/sql-createtableas.html
+share/doc/postgresql/html/sql-createtrigger.html
+share/doc/postgresql/html/sql-createtype.html
+share/doc/postgresql/html/sql-createuser.html
+share/doc/postgresql/html/sql-createview.html
+share/doc/postgresql/html/sql-declare.html
+share/doc/postgresql/html/sql-delete.html
+share/doc/postgresql/html/sql-dropaggregate.html
+share/doc/postgresql/html/sql-dropdatabase.html
+share/doc/postgresql/html/sql-dropfunction.html
+share/doc/postgresql/html/sql-dropgroup.html
+share/doc/postgresql/html/sql-dropindex.html
+share/doc/postgresql/html/sql-droplanguage.html
+share/doc/postgresql/html/sql-dropoperator.html
+share/doc/postgresql/html/sql-droprule.html
+share/doc/postgresql/html/sql-dropsequence.html
+share/doc/postgresql/html/sql-droptable.html
+share/doc/postgresql/html/sql-droptrigger.html
+share/doc/postgresql/html/sql-droptype.html
+share/doc/postgresql/html/sql-dropuser.html
+share/doc/postgresql/html/sql-dropview.html
+share/doc/postgresql/html/sql-end.html
+share/doc/postgresql/html/sql-explain.html
+share/doc/postgresql/html/sql-expressions.html
+share/doc/postgresql/html/sql-fetch.html
+share/doc/postgresql/html/sql-grant.html
+share/doc/postgresql/html/sql-insert.html
+share/doc/postgresql/html/sql-keywords-appendix.html
+share/doc/postgresql/html/sql-language.html
+share/doc/postgresql/html/sql-listen.html
+share/doc/postgresql/html/sql-load.html
+share/doc/postgresql/html/sql-lock.html
+share/doc/postgresql/html/sql-move.html
+share/doc/postgresql/html/sql-notify.html
+share/doc/postgresql/html/sql-precedence.html
+share/doc/postgresql/html/sql-reindex.html
+share/doc/postgresql/html/sql-reset.html
+share/doc/postgresql/html/sql-revoke.html
+share/doc/postgresql/html/sql-rollback.html
+share/doc/postgresql/html/sql-select.html
+share/doc/postgresql/html/sql-selectinto.html
+share/doc/postgresql/html/sql-set-constraints.html
+share/doc/postgresql/html/sql-set-transaction.html
+share/doc/postgresql/html/sql-set.html
+share/doc/postgresql/html/sql-show.html
+share/doc/postgresql/html/sql-syntax-columns.html
+share/doc/postgresql/html/sql-syntax.html
+share/doc/postgresql/html/sql-truncate.html
+share/doc/postgresql/html/sql-unlisten.html
+share/doc/postgresql/html/sql-update.html
+share/doc/postgresql/html/sql-vacuum.html
+share/doc/postgresql/html/sql.html
+share/doc/postgresql/html/ssh-tunnels.html
+share/doc/postgresql/html/ssl-tcp.html
+share/doc/postgresql/html/start-manage-db.html
+share/doc/postgresql/html/start-psql.html
+share/doc/postgresql/html/start.html
+share/doc/postgresql/html/storage.html
+share/doc/postgresql/html/supported-platforms.html
+share/doc/postgresql/html/timing-results.html
+share/doc/postgresql/html/transaction-iso.html
+share/doc/postgresql/html/trigger-datachanges.html
+share/doc/postgresql/html/trigger-examples.html
+share/doc/postgresql/html/trigger-manager.html
+share/doc/postgresql/html/triggers.html
+share/doc/postgresql/html/tutorial.html
+share/doc/postgresql/html/type-system.html
+share/doc/postgresql/html/typeconv-func.html
+share/doc/postgresql/html/typeconv-oper.html
+share/doc/postgresql/html/typeconv-query.html
+share/doc/postgresql/html/typeconv-union-case.html
+share/doc/postgresql/html/typeconv.html
+share/doc/postgresql/html/units-history.html
+share/doc/postgresql/html/user-manag.html
+share/doc/postgresql/html/user.html
+share/doc/postgresql/html/wal-configuration.html
+share/doc/postgresql/html/wal-implementation.html
+share/doc/postgresql/html/wal.html
+share/doc/postgresql/html/xact-read-committed.html
+share/doc/postgresql/html/xact-serializable.html
+share/doc/postgresql/html/xaggr.html
+share/doc/postgresql/html/xfunc-c.html
+share/doc/postgresql/html/xfunc-internal.html
+share/doc/postgresql/html/xfunc-overload.html
+share/doc/postgresql/html/xfunc-pl.html
+share/doc/postgresql/html/xfunc.html
+share/doc/postgresql/html/xindex.html
+share/doc/postgresql/html/xoper.html
+share/doc/postgresql/html/xplang.html
+share/doc/postgresql/html/xtypes.html
+share/doc/postgresql/html/y2k.html
+share/doc/postgresql/html/catalogs.gif
+share/doc/postgresql/html/clientserver.gif
+share/doc/postgresql/html/connections.gif
+@dirrm share/doc/postgresql/html
+@dirrm share/doc/postgresql
diff --git a/japanese/postgresql7/pkg-plist.jdbc b/japanese/postgresql7/pkg-plist.jdbc
index bef5d75506b4..8f7bd41a54d7 100644
--- a/japanese/postgresql7/pkg-plist.jdbc
+++ b/japanese/postgresql7/pkg-plist.jdbc
@@ -1,13 +1,27 @@
-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/examples/postgresql/corba/StockClient.java
+share/examples/postgresql/corba/StockDB.java
+share/examples/postgresql/corba/StockDispenserImpl.java
+share/examples/postgresql/corba/StockItemImpl.java
+share/examples/postgresql/corba/StockServer.java
+share/examples/postgresql/corba/readme
+share/examples/postgresql/corba/stock.idl
+share/examples/postgresql/corba/stock.sql
+@dirrm share/examples/postgresql/corba
+share/examples/postgresql/ImageViewer.java
+share/examples/postgresql/Unicode.java
+share/examples/postgresql/basic.java
+share/examples/postgresql/blobtest.java
+share/examples/postgresql/datestyle.java
+share/examples/postgresql/metadata.java
+share/examples/postgresql/psql.java
+share/examples/postgresql/threadsafe.java
+share/examples/postgresql/README
+share/examples/postgresql/Implementation
+@dirrm share/examples/postgresql
+share/postgresql/java/postgresql-examples.jar
+share/postgresql/java/postgresql.jar
+share/postgresql/java/retepTools.jar
+@dirrm share/postgresql/java
share/java/classes/postgresql.jar
+@unexec rmdir %D/share/java/classes 2>/dev/null || true
@unexec rmdir %D/share/java 2>/dev/null || true
diff --git a/japanese/postgresql7/pkg-plist.notk b/japanese/postgresql7/pkg-plist.notk
new file mode 100644
index 000000000000..8dcbc5f88bd6
--- /dev/null
+++ b/japanese/postgresql7/pkg-plist.notk
@@ -0,0 +1,6 @@
+%%PG_PREFIX%%bin/pgtclsh
+%%PG_INCLUDE%%/libpgtcl.h
+%%PG_PREFIX%%lib/libpgtcl.a
+%%PG_PREFIX%%lib/libpgtcl.so
+%%PG_PREFIX%%lib/libpgtcl.so.2
+%%PG_PREFIX%%lib/pltcl.so
diff --git a/japanese/postgresql7/pkg-plist.odbc b/japanese/postgresql7/pkg-plist.odbc
index c849e26dbc88..f047b7cb64a1 100644
--- a/japanese/postgresql7/pkg-plist.odbc
+++ b/japanese/postgresql7/pkg-plist.odbc
@@ -1,8 +1,10 @@
-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
+%%PG_INCLUDE%%/iodbc/iodbc.h
+%%PG_INCLUDE%%/iodbc/isql.h
+%%PG_INCLUDE%%/iodbc/isqlext.h
+@dirrm %%PG_INCLUDE%%/iodbc
+%%PG_PREFIX%%lib/libpsqlodbc.a
+%%PG_PREFIX%%lib/libpsqlodbc.so
+%%PG_PREFIX%%lib/libpsqlodbc.so.0
+etc/postgresql/odbcinst.ini
+@dirrm etc/postgresql
+share/postgresql/odbc.sql
diff --git a/japanese/postgresql7/pkg-plist.tcl b/japanese/postgresql7/pkg-plist.tcl
index b01eaf1571ed..da5f4367cb80 100644
--- a/japanese/postgresql7/pkg-plist.tcl
+++ b/japanese/postgresql7/pkg-plist.tcl
@@ -1,141 +1,148 @@
-pgsql/bin/pgaccess
-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
-pgsql/pgaccess/images/icon_button.gif
-pgsql/pgaccess/images/icon_checkbutton.gif
-pgsql/pgaccess/images/icon_entry.gif
-pgsql/pgaccess/images/icon_frame.gif
-pgsql/pgaccess/images/icon_label.gif
-pgsql/pgaccess/images/icon_listbox.gif
-pgsql/pgaccess/images/icon_query.gif
-pgsql/pgaccess/images/icon_radiobutton.gif
-pgsql/pgaccess/images/icon_text.gif
-pgsql/pgaccess/lib/database.tcl
-pgsql/pgaccess/lib/forms.tcl
-pgsql/pgaccess/lib/functions.tcl
-pgsql/pgaccess/lib/help/abort.hlp
-pgsql/pgaccess/lib/help/add_records.hlp
-pgsql/pgaccess/lib/help/alter_table.hlp
-pgsql/pgaccess/lib/help/alter_user.hlp
-pgsql/pgaccess/lib/help/author.hlp
-pgsql/pgaccess/lib/help/begin.hlp
-pgsql/pgaccess/lib/help/close.hlp
-pgsql/pgaccess/lib/help/cluster.hlp
-pgsql/pgaccess/lib/help/commit.hlp
-pgsql/pgaccess/lib/help/copy.hlp
-pgsql/pgaccess/lib/help/copyrights.hlp
-pgsql/pgaccess/lib/help/create_aggregate.hlp
-pgsql/pgaccess/lib/help/create_database.hlp
-pgsql/pgaccess/lib/help/create_function.hlp
-pgsql/pgaccess/lib/help/create_index.hlp
-pgsql/pgaccess/lib/help/create_language.hlp
-pgsql/pgaccess/lib/help/create_operator.hlp
-pgsql/pgaccess/lib/help/create_rule.hlp
-pgsql/pgaccess/lib/help/create_sequence.hlp
-pgsql/pgaccess/lib/help/create_table.hlp
-pgsql/pgaccess/lib/help/create_table_as.hlp
-pgsql/pgaccess/lib/help/create_trigger.hlp
-pgsql/pgaccess/lib/help/create_type.hlp
-pgsql/pgaccess/lib/help/create_user.hlp
-pgsql/pgaccess/lib/help/create_view.hlp
-pgsql/pgaccess/lib/help/data_types.hlp
-pgsql/pgaccess/lib/help/datefunc.hlp
-pgsql/pgaccess/lib/help/declare.hlp
-pgsql/pgaccess/lib/help/delete.hlp
-pgsql/pgaccess/lib/help/drop_aggregate.hlp
-pgsql/pgaccess/lib/help/drop_database.hlp
-pgsql/pgaccess/lib/help/drop_function.hlp
-pgsql/pgaccess/lib/help/drop_index.hlp
-pgsql/pgaccess/lib/help/drop_language.hlp
-pgsql/pgaccess/lib/help/drop_operator.hlp
-pgsql/pgaccess/lib/help/drop_rule.hlp
-pgsql/pgaccess/lib/help/drop_sequence.hlp
-pgsql/pgaccess/lib/help/drop_table.hlp
-pgsql/pgaccess/lib/help/drop_trigger.hlp
-pgsql/pgaccess/lib/help/drop_type.hlp
-pgsql/pgaccess/lib/help/drop_user.hlp
-pgsql/pgaccess/lib/help/drop_view.hlp
-pgsql/pgaccess/lib/help/explain.hlp
-pgsql/pgaccess/lib/help/fetch.hlp
-pgsql/pgaccess/lib/help/form_design.hlp
-pgsql/pgaccess/lib/help/forms.hlp
-pgsql/pgaccess/lib/help/functions.hlp
-pgsql/pgaccess/lib/help/geomfunc.hlp
-pgsql/pgaccess/lib/help/grant.hlp
-pgsql/pgaccess/lib/help/history.hlp
-pgsql/pgaccess/lib/help/index.hlp
-pgsql/pgaccess/lib/help/inheritance.hlp
-pgsql/pgaccess/lib/help/insert.hlp
-pgsql/pgaccess/lib/help/ipv4func.hlp
-pgsql/pgaccess/lib/help/isolation.hlp
-pgsql/pgaccess/lib/help/keywords.hlp
-pgsql/pgaccess/lib/help/listen.hlp
-pgsql/pgaccess/lib/help/load.hlp
-pgsql/pgaccess/lib/help/lock.hlp
-pgsql/pgaccess/lib/help/mathfunc.hlp
-pgsql/pgaccess/lib/help/move.hlp
-pgsql/pgaccess/lib/help/mvcc.hlp
-pgsql/pgaccess/lib/help/new_query.hlp
-pgsql/pgaccess/lib/help/new_table.hlp
-pgsql/pgaccess/lib/help/notify.hlp
-pgsql/pgaccess/lib/help/open_query.hlp
-pgsql/pgaccess/lib/help/open_table.hlp
-pgsql/pgaccess/lib/help/pgfunctions.hlp
-pgsql/pgaccess/lib/help/postgresql.hlp
-pgsql/pgaccess/lib/help/queries.hlp
-pgsql/pgaccess/lib/help/reports.hlp
-pgsql/pgaccess/lib/help/reset.hlp
-pgsql/pgaccess/lib/help/revoke.hlp
-pgsql/pgaccess/lib/help/rollback.hlp
-pgsql/pgaccess/lib/help/schema.hlp
-pgsql/pgaccess/lib/help/scripts.hlp
-pgsql/pgaccess/lib/help/select.hlp
-pgsql/pgaccess/lib/help/select_into.hlp
-pgsql/pgaccess/lib/help/sequences.hlp
-pgsql/pgaccess/lib/help/set.hlp
-pgsql/pgaccess/lib/help/show.hlp
-pgsql/pgaccess/lib/help/sql_guide.hlp
-pgsql/pgaccess/lib/help/sqlfunc.hlp
-pgsql/pgaccess/lib/help/stringfunc.hlp
-pgsql/pgaccess/lib/help/tables.hlp
-pgsql/pgaccess/lib/help/unlisten.hlp
-pgsql/pgaccess/lib/help/update.hlp
-pgsql/pgaccess/lib/help/users.hlp
-pgsql/pgaccess/lib/help/vacuum.hlp
-pgsql/pgaccess/lib/help/view_table_structure.hlp
-pgsql/pgaccess/lib/help/views.hlp
-pgsql/pgaccess/lib/help/visual_designer.hlp
-pgsql/pgaccess/lib/help/y2k.hlp
-pgsql/pgaccess/lib/help.tcl
-pgsql/pgaccess/lib/languages/czech
-pgsql/pgaccess/lib/languages/deutsch
-pgsql/pgaccess/lib/languages/francais
-pgsql/pgaccess/lib/languages/italiano
-pgsql/pgaccess/lib/languages/magyar
-pgsql/pgaccess/lib/languages/portugues
-pgsql/pgaccess/lib/languages/romana
-pgsql/pgaccess/lib/languages/russian.koi8r
-pgsql/pgaccess/lib/languages/russian_win
-pgsql/pgaccess/lib/languages/spanish
-pgsql/pgaccess/lib/mainlib.tcl
-pgsql/pgaccess/lib/preferences.tcl
-pgsql/pgaccess/lib/queries.tcl
-pgsql/pgaccess/lib/reports.tcl
-pgsql/pgaccess/lib/schema.tcl
-pgsql/pgaccess/lib/scripts.tcl
-pgsql/pgaccess/lib/sequences.tcl
-pgsql/pgaccess/lib/tables.tcl
-pgsql/pgaccess/lib/users.tcl
-pgsql/pgaccess/lib/views.tcl
-pgsql/pgaccess/lib/visualqb.tcl
-pgsql/pgaccess/main.tcl
-@dirrm pgsql/pgaccess/images
-@dirrm pgsql/pgaccess/lib/help
-@dirrm pgsql/pgaccess/lib/languages
-@dirrm pgsql/pgaccess/lib
-@dirrm pgsql/pgaccess
+%%PG_PREFIX%%bin/pgaccess
+%%PG_PREFIX%%bin/pgtclsh
+%%PG_PREFIX%%bin/pgtksh
+%%PG_INCLUDE%%/libpgtcl.h
+%%PG_PREFIX%%lib/libpgtcl.a
+%%PG_PREFIX%%lib/libpgtcl.so
+%%PG_PREFIX%%lib/libpgtcl.so.2
+%%PG_PREFIX%%lib/pltcl.so
+lib/tcl%%WITH_TCL%%/Pgtcl1.3/pkgIndex.tcl
+share/postgresql/pgaccess/images/icon_button.gif
+share/postgresql/pgaccess/images/icon_checkbutton.gif
+share/postgresql/pgaccess/images/icon_entry.gif
+share/postgresql/pgaccess/images/icon_frame.gif
+share/postgresql/pgaccess/images/icon_label.gif
+share/postgresql/pgaccess/images/icon_listbox.gif
+share/postgresql/pgaccess/images/icon_query.gif
+share/postgresql/pgaccess/images/icon_radiobutton.gif
+share/postgresql/pgaccess/images/icon_text.gif
+share/postgresql/pgaccess/lib/database.tcl
+share/postgresql/pgaccess/lib/forms.tcl
+share/postgresql/pgaccess/lib/functions.tcl
+share/postgresql/pgaccess/lib/help/abort.hlp
+share/postgresql/pgaccess/lib/help/add_records.hlp
+share/postgresql/pgaccess/lib/help/alter_table.hlp
+share/postgresql/pgaccess/lib/help/alter_user.hlp
+share/postgresql/pgaccess/lib/help/author.hlp
+share/postgresql/pgaccess/lib/help/begin.hlp
+share/postgresql/pgaccess/lib/help/close.hlp
+share/postgresql/pgaccess/lib/help/cluster.hlp
+share/postgresql/pgaccess/lib/help/commit.hlp
+share/postgresql/pgaccess/lib/help/copy.hlp
+share/postgresql/pgaccess/lib/help/copyrights.hlp
+share/postgresql/pgaccess/lib/help/create_aggregate.hlp
+share/postgresql/pgaccess/lib/help/create_database.hlp
+share/postgresql/pgaccess/lib/help/create_function.hlp
+share/postgresql/pgaccess/lib/help/create_index.hlp
+share/postgresql/pgaccess/lib/help/create_language.hlp
+share/postgresql/pgaccess/lib/help/create_operator.hlp
+share/postgresql/pgaccess/lib/help/create_rule.hlp
+share/postgresql/pgaccess/lib/help/create_sequence.hlp
+share/postgresql/pgaccess/lib/help/create_table.hlp
+share/postgresql/pgaccess/lib/help/create_table_as.hlp
+share/postgresql/pgaccess/lib/help/create_trigger.hlp
+share/postgresql/pgaccess/lib/help/create_type.hlp
+share/postgresql/pgaccess/lib/help/create_user.hlp
+share/postgresql/pgaccess/lib/help/create_view.hlp
+share/postgresql/pgaccess/lib/help/data_types.hlp
+share/postgresql/pgaccess/lib/help/datefunc.hlp
+share/postgresql/pgaccess/lib/help/declare.hlp
+share/postgresql/pgaccess/lib/help/delete.hlp
+share/postgresql/pgaccess/lib/help/drop_aggregate.hlp
+share/postgresql/pgaccess/lib/help/drop_database.hlp
+share/postgresql/pgaccess/lib/help/drop_function.hlp
+share/postgresql/pgaccess/lib/help/drop_index.hlp
+share/postgresql/pgaccess/lib/help/drop_language.hlp
+share/postgresql/pgaccess/lib/help/drop_operator.hlp
+share/postgresql/pgaccess/lib/help/drop_rule.hlp
+share/postgresql/pgaccess/lib/help/drop_sequence.hlp
+share/postgresql/pgaccess/lib/help/drop_table.hlp
+share/postgresql/pgaccess/lib/help/drop_trigger.hlp
+share/postgresql/pgaccess/lib/help/drop_type.hlp
+share/postgresql/pgaccess/lib/help/drop_user.hlp
+share/postgresql/pgaccess/lib/help/drop_view.hlp
+share/postgresql/pgaccess/lib/help/explain.hlp
+share/postgresql/pgaccess/lib/help/fetch.hlp
+share/postgresql/pgaccess/lib/help/form_design.hlp
+share/postgresql/pgaccess/lib/help/forms.hlp
+share/postgresql/pgaccess/lib/help/functions.hlp
+share/postgresql/pgaccess/lib/help/geomfunc.hlp
+share/postgresql/pgaccess/lib/help/grant.hlp
+share/postgresql/pgaccess/lib/help/history.hlp
+share/postgresql/pgaccess/lib/help/index.hlp
+share/postgresql/pgaccess/lib/help/inheritance.hlp
+share/postgresql/pgaccess/lib/help/insert.hlp
+share/postgresql/pgaccess/lib/help/ipv4func.hlp
+share/postgresql/pgaccess/lib/help/isolation.hlp
+share/postgresql/pgaccess/lib/help/keywords.hlp
+share/postgresql/pgaccess/lib/help/listen.hlp
+share/postgresql/pgaccess/lib/help/load.hlp
+share/postgresql/pgaccess/lib/help/lock.hlp
+share/postgresql/pgaccess/lib/help/mathfunc.hlp
+share/postgresql/pgaccess/lib/help/move.hlp
+share/postgresql/pgaccess/lib/help/mvcc.hlp
+share/postgresql/pgaccess/lib/help/new_query.hlp
+share/postgresql/pgaccess/lib/help/new_table.hlp
+share/postgresql/pgaccess/lib/help/notify.hlp
+share/postgresql/pgaccess/lib/help/open_query.hlp
+share/postgresql/pgaccess/lib/help/open_table.hlp
+share/postgresql/pgaccess/lib/help/pgfunctions.hlp
+share/postgresql/pgaccess/lib/help/postgresql.hlp
+share/postgresql/pgaccess/lib/help/queries.hlp
+share/postgresql/pgaccess/lib/help/reports.hlp
+share/postgresql/pgaccess/lib/help/reset.hlp
+share/postgresql/pgaccess/lib/help/revoke.hlp
+share/postgresql/pgaccess/lib/help/rollback.hlp
+share/postgresql/pgaccess/lib/help/schema.hlp
+share/postgresql/pgaccess/lib/help/scripts.hlp
+share/postgresql/pgaccess/lib/help/select.hlp
+share/postgresql/pgaccess/lib/help/select_into.hlp
+share/postgresql/pgaccess/lib/help/sequences.hlp
+share/postgresql/pgaccess/lib/help/set.hlp
+share/postgresql/pgaccess/lib/help/show.hlp
+share/postgresql/pgaccess/lib/help/sql_guide.hlp
+share/postgresql/pgaccess/lib/help/sqlfunc.hlp
+share/postgresql/pgaccess/lib/help/stringfunc.hlp
+share/postgresql/pgaccess/lib/help/tables.hlp
+share/postgresql/pgaccess/lib/help/unlisten.hlp
+share/postgresql/pgaccess/lib/help/update.hlp
+share/postgresql/pgaccess/lib/help/users.hlp
+share/postgresql/pgaccess/lib/help/vacuum.hlp
+share/postgresql/pgaccess/lib/help/view_table_structure.hlp
+share/postgresql/pgaccess/lib/help/views.hlp
+share/postgresql/pgaccess/lib/help/visual_designer.hlp
+share/postgresql/pgaccess/lib/help/y2k.hlp
+share/postgresql/pgaccess/lib/help.tcl
+share/postgresql/pgaccess/lib/languages/czech
+share/postgresql/pgaccess/lib/languages/chinese_big5
+share/postgresql/pgaccess/lib/languages/chinese_gb
+share/postgresql/pgaccess/lib/languages/deutsch
+share/postgresql/pgaccess/lib/languages/euskara
+share/postgresql/pgaccess/lib/languages/francais
+share/postgresql/pgaccess/lib/languages/italiano
+share/postgresql/pgaccess/lib/languages/japanese
+share/postgresql/pgaccess/lib/languages/magyar
+share/postgresql/pgaccess/lib/languages/nederlands
+share/postgresql/pgaccess/lib/languages/portugues
+share/postgresql/pgaccess/lib/languages/romana
+share/postgresql/pgaccess/lib/languages/russian.koi8r
+share/postgresql/pgaccess/lib/languages/russian_win
+share/postgresql/pgaccess/lib/languages/spanish
+share/postgresql/pgaccess/lib/mainlib.tcl
+share/postgresql/pgaccess/lib/preferences.tcl
+share/postgresql/pgaccess/lib/queries.tcl
+share/postgresql/pgaccess/lib/reports.tcl
+share/postgresql/pgaccess/lib/schema.tcl
+share/postgresql/pgaccess/lib/scripts.tcl
+share/postgresql/pgaccess/lib/sequences.tcl
+share/postgresql/pgaccess/lib/tables.tcl
+share/postgresql/pgaccess/lib/users.tcl
+share/postgresql/pgaccess/lib/views.tcl
+share/postgresql/pgaccess/lib/visualqb.tcl
+share/postgresql/pgaccess/main.tcl
+@dirrm share/postgresql/pgaccess/images
+@dirrm share/postgresql/pgaccess/lib/help
+@dirrm share/postgresql/pgaccess/lib/languages
+@dirrm share/postgresql/pgaccess/lib
+@dirrm share/postgresql/pgaccess
+@dirrm lib/tcl%%WITH_TCL%%/Pgtcl1.3
diff --git a/japanese/postgresql7/scripts/configure b/japanese/postgresql7/scripts/configure
deleted file mode 100644
index ec3586e28899..000000000000
--- a/japanese/postgresql7/scripts/configure
+++ /dev/null
@@ -1,7 +0,0 @@
-#! /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/configure.postgresql b/japanese/postgresql7/scripts/configure.postgresql
new file mode 100644
index 000000000000..68101188e78c
--- /dev/null
+++ b/japanese/postgresql7/scripts/configure.postgresql
@@ -0,0 +1,277 @@
+#!/bin/sh
+# -*- tab-width: 4; -*-
+# ex:ts=4
+#
+# $FreeBSD: /tmp/pcvs/ports/japanese/postgresql7/scripts/Attic/configure.postgresql,v 1.1 2001-05-08 12:36:01 knu Exp $
+#
+if [ -f ${WRKDIRPREFIX}${CURDIR}/Makefile.inc ]; then
+ exit
+fi
+
+if [ ! "${BATCH}" ]; then
+ dialog --title "Backup your data NOW" \
+ --msgbox "`sed -e \"s#%%PREFIX%%#${PREFIX}#\" < ${FILESDIR}/pre-install-notes`" \
+ -1 -1
+fi
+
+if [ "${BATCH}" ]; then
+ set \"MultiByte\" \"ODBC\" \"SSL\"
+else
+ /usr/bin/dialog --title "configuration options" --clear \
+ --checklist "\n\
+Please select desired options:" -1 -1 7 \
+JDBC "Java DataBase Connectivity" OFF \
+MultiByte "Multibyte for Multilingualism" ON \
+ODBC "Open Database Connectivity" ON \
+TCL "Tcl" ON \
+TCLTK "Tcl/Tk" ON \
+SSL "Secure Socket Layer" ON \
+KRB5 "Kerberos 5" OFF \
+2> /tmp/checklist.tmp.$$
+
+ retval=$?
+
+ if [ -s /tmp/checklist.tmp.$$ ]; then
+ set `cat /tmp/checklist.tmp.$$`
+ fi
+ rm -f /tmp/checklist.tmp.$$
+
+ case $retval in
+ 0) if [ -z "$*" ]; then
+ echo "Nothing selected"
+ fi
+ ;;
+ 1) echo "Cancel pressed."
+ exit 1
+ ;;
+ esac
+fi
+
+${MKDIR} -p ${WRKDIRPREFIX}${CURDIR}
+exec > ${WRKDIRPREFIX}${CURDIR}/Makefile.inc
+
+while [ "$1" ]; do
+ case $1 in
+ \"JDBC\")
+ # We use JAVA_HOME if set correctly. If the user has
+ # specified a JVM with JAVA_HOME or via the javavmwrapper,
+ # we validate that it really exists. It is unnecessarily
+ # complicated and error prone to try to figure out the
+ # correct java version just to be able to determine a
+ # BUILD_DEPEND in this case. Instead, assume that a set
+ # JAVA_HOME together with simple sanity check mean we have
+ # an installed JVM, and we don't bother setting
+ # BUILD_DEPENDS.
+
+ echo "# JDBC"
+ # if JAVA_HOME is set and exists, use it
+ if [ "${JAVA_HOME}" -a -x "${JAVA_HOME}/bin/javac" ]; then
+ echo JAVA_HOME=${JAVA_HOME}
+ else
+ # No JAVA_HOME, check javavmwrapper's config file
+ if [ -r "${LOCALBASE}/etc/javavms" ]; then
+ VMS=`/usr/bin/sed 's|#.*||' < "${LOCALBASE}/etc/javavms" | uniq`
+ for JAVAVM in ${VMS}; do
+ if [ -x "${JAVAVM}" ]; then
+ JAVA_HOME=`echo ${JAVAVM} | /usr/bin/sed 's|/bin/java$||`
+ break
+ fi
+ done
+ fi
+ if [ "${JAVA_HOME}" -a -x "${JAVA_HOME}/bin/javac" ]; then
+ # yep, wrapper was good
+ echo JAVA_HOME=${JAVA_HOME}
+ else
+ # nothing, use our boring 1.1.8, the only native non-beta jdk :(
+ echo BUILD_DEPENDS+= \${LOCALBASE}/jdk1.1.8/bin/javac:\${PORTSDIR}/java/jdk
+ echo JAVA_HOME=\${LOCALBASE}/jdk1.1.8
+ fi
+ fi
+ cat <<-EOF
+ BUILD_DEPENDS+= \${LOCALBASE}/bin/ant:\${PORTSDIR}/devel/jakarta-ant
+ CONFIGURE_ENV+= ANT=\${LOCALBASE}/bin/ant
+ WITH_JDBC=YES
+ MAKE_ENV+= JAVA_HOME=\${JAVA_HOME}
+ SCRIPTS_ENV+= JAVA_HOME=\${JAVA_HOME}
+ CONFIGURE_ARGS+= --with-java
+
+ EOF
+ ;;
+ \"MultiByte\")
+ MULTIBYTE=1
+ ;;
+ \"ODBC\")
+ cat <<-EOF
+ # ODBC
+ WITH_ODBC=YES
+ CONFIGURE_ARGS+= --with-odbc
+
+ EOF
+ ;;
+ \"TCL\")
+ TCL=1
+ ;;
+ \"TCLTK\")
+ echo "#TCLTK"
+ echo WITH_TK=YES
+ echo
+ TCL=1
+ ;;
+ \"SSL\")
+ cat <<-EOF
+ # SSL
+ USE_OPENSSL= yes
+ CFLAGS+= -DUSE_SSL
+ WITH_SSL= yes
+ CONFIGURE_ENV+= LDFLAGS="-L\${OPENSSLLIB} -lssl -lcrypto"
+ CONFIGURE_ARGS+= --with-openssl
+
+ EOF
+ ;;
+ \"KRB5\")
+ KRB5=1
+ ;;
+ \"nothing\"|true)
+ ;;
+ *)
+ echo "Invalid option(s): $*" > /dev/stderr
+ rm -f ${WRKDIRPREFIX}${CURDIR}/Makefile.inc
+ exit 1
+ ;;
+ esac
+ shift
+done
+
+exec > /dev/stderr
+
+# if multibyte, determine charset
+echo "# Multibyte" >> ${WRKDIRPREFIX}${CURDIR}/Makefile.inc
+
+if [ ! "${MULTIBYTE}" ]; then
+ echo "WITHOUT_MULTIBYTE=YES" >> ${WRKDIRPREFIX}${CURDIR}/Makefile.inc
+else
+ if [ "${BATCH}" ]; then
+ set "nothing"
+ else
+ /usr/bin/dialog --title "configuration options" --clear \
+ --radiolist "\n\
+Please select desired options:" -1 -1 16 \
+EUC_JP "EUC_JP" ON \
+SQL_ASCII "SQL_ASCII" OFF \
+LATIN1 "LATIN1" OFF \
+LATIN2 "LATIN2" OFF \
+LATIN3 "LATIN3" OFF \
+LATIN4 "LATIN4" OFF \
+LATIN5 "LATIN5" OFF \
+EUC_KR "EUC_KR" OFF \
+EUC_TW "EUC_TW" OFF \
+KOI8 "KOI8" OFF \
+UNICODE "UNICODE" OFF \
+MULE_INTERNAL "MULE_INTERNAL" OFF \
+WIN "WIN" OFF \
+ALT "ALT" OFF \
+2> /tmp/checklist.tmp.$$
+
+ retval=$?
+
+ if [ -s /tmp/checklist.tmp.$$ ]; then
+ set `cat /tmp/checklist.tmp.$$`
+ fi
+ rm -f /tmp/checklist.tmp.$$
+ if [ $retval = 1 ]; then
+ echo "Cancel pressed."
+ rm ${WRKDIRPREFIX}${CURDIR}/Makefile.inc
+ exit 1
+ fi
+ fi
+
+ if [ "$1" = "nothing" ]; then
+ echo "CONFIGURE_ARGS+= --enable-multibyte" \
+ >> ${WRKDIRPREFIX}${CURDIR}/Makefile.inc
+ else
+ echo "CONFIGURE_ARGS+= --enable-multibyte=$1" \
+ >> ${WRKDIRPREFIX}${CURDIR}/Makefile.inc
+ fi
+fi
+echo
+
+if [ "${TCL}" ]; then
+ echo "# TCL" >> ${WRKDIRPREFIX}${CURDIR}/Makefile.inc
+ if [ "${BATCH}" ]; then
+ echo WITH_TCL=8.0jp >> ${WRKDIRPREFIX}${CURDIR}/Makefile.inc
+ else
+ dialog --title "TCL version" \
+ --inputbox "Please enter japanese TCL version. Default is 8.0jp." -1 -1 "8.0jp" \
+ 2> /tmp/checklist.tmp.$$
+ retval=$?
+ if [ -s /tmp/checklist.tmp.$$ ]; then
+ set `cat /tmp/checklist.tmp.$$`
+ fi
+ rm -f /tmp/checklist.tmp.$$
+ case $retval in
+ 0) if [ -z "$*" ]; then
+ echo "Nothing selected"
+ fi
+ ;;
+ 1) echo "Cancel pressed."
+ rm -f ${WRKDIRPREFIX}${CURDIR}/Makefile.inc
+ exit 1
+ ;;
+ esac
+ echo WITH_TCL=\"$1\" >> ${WRKDIRPREFIX}${CURDIR}/Makefile.inc
+ fi
+ cat <<-EOF >> ${WRKDIRPREFIX}${CURDIR}/Makefile.inc
+ CONFIGURE_ARGS+= --with-tcl --with-tclconfig="\${TCLCONFIG}"
+ TCLV=\${WITH_TCL:S/.//}
+ TCLP=\${TCLV:S/jp//}
+ TCL_INCDIR= \${LOCALBASE}/include/tcl\${WITH_TCL}
+ MAKE_ENV+= TCL_INCDIR=\${TCL_INCDIR}
+ LIB_DEPENDS+= tcl\${TCLV}:\${PORTSDIR}/japanese/tcl\${TCLP}
+ TCLCONFIG= "\${LOCALBASE}/lib/tcl\${WITH_TCL}"
+ .if defined(WITH_TK)
+ CONFIGURE_ARGS+= --with-tkconfig="\${TKCONFIG}"
+ TK_INCDIR= \${LOCALBASE}/include/tk\${WITH_TCL}
+ CONFIGURE_ENV+= WISH=\${LOCALBASE}/bin/wish\${WITH_TCL}
+ LIB_DEPENDS+= tk\${TCLV}:\${PORTSDIR}/japanese/tk\${TCLP}
+ TKCONFIG= "\${LOCALBASE}/lib/tk\${WITH_TCL}"
+ TCLCONFIG+= \${TKCONFIG}
+ TCL_PLIST= pkg-plist.tcl
+ .else
+ TCL_PLIST= pkg-plist.notk
+ CONFIGURE_ARGS+= --without-tk
+ .endif
+
+ EOF
+fi
+
+if [ "${KRB5}" ]; then
+ if [ "${BATCH}" ]; then
+ # never gets here, but what the heck...
+ echo KRB5_HOME=\${LOCALBASE} >> ${WRKDIRPREFIX}${CURDIR}/Makefile.inc
+ else
+ dialog --inputbox "Please enter the KRB5_HOME path" -1 -1 "${KRB_HOME:-${LOCALBASE}}" \
+ 2> /tmp/checklist.tmp.$$
+ retval=$?
+ if [ -s /tmp/checklist.tmp.$$ ]; then
+ set `cat /tmp/checklist.tmp.$$`
+ fi
+ rm -f /tmp/checklist.tmp.$$
+ case $retval in
+ 0) if [ -z "$*" ]; then
+ echo "No input"
+ fi
+ ;;
+ 1) echo "Cancel pressed."
+ rm -f ${WRKDIRPREFIX}${CURDIR}/Makefile.inc
+ exit 1
+ ;;
+ esac
+ echo KRB5_HOME=\"$1\" >> ${WRKDIRPREFIX}${CURDIR}/Makefile.inc
+ fi
+ cat <<-EOF >> ${WRKDIRPREFIX}${CURDIR}/Makefile.inc
+ .if defined(KRB5_HOME) && exists(\${KRB5_HOME})
+ CONFIGURE_KRB= --with-krb5=\${KRB5_HOME}
+ .endif
+
+ EOF
+fi
diff --git a/japanese/postgresql7/scripts/createuser b/japanese/postgresql7/scripts/createuser
deleted file mode 100644
index 2abe201e7a4b..000000000000
--- a/japanese/postgresql7/scripts/createuser
+++ /dev/null
@@ -1,50 +0,0 @@
-#!/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 );
-}