Hi, first, here's an update of postgresql to the next major version, 8.3 [0], and thus the usual dump/restore procedure is necessary.
Second, there are some more changes that might need your attention: - tsearch2 has moved to the core distribution, some minor syntax changes, changed the pg_catalog schema and thus needs some adjustments. - postgresql-uuid is superseeded by native uuid support but has a different function naming, so it also needs some minor adjustments. The single fact that native support allows using NULL values in foreign key constraints makes uuid usage much easier in a few situations. In any case the uuid diff is required, otherwise postgresql pulls in uuid which pulls in postgresql and so on... Please test, give feedback and eventually oks. Kind regards, Simon [0] http://www.postgresql.org/docs/8.3/static/release-8-3.html
Index: Makefile =================================================================== RCS file: /cvs/ports/devel/uuid/Makefile,v retrieving revision 1.29 diff -u -p -r1.29 Makefile --- Makefile 16 Sep 2007 02:53:14 -0000 1.29 +++ Makefile 15 Mar 2008 16:05:58 -0000 @@ -4,13 +4,11 @@ SHARED_ONLY= Yes COMMENT-main= ISO-C API and CLI for generating UUIDs COMMENT-perl= UUID modules for Perl -COMMENT-pgsql= UUID extension for PostgreSQL VERSION= 1.6.0 DISTNAME= uuid-${VERSION} FULLPKGNAME-main= uuid-${VERSION} FULLPKGNAME-perl= p5-UUID-${VERSION}p0 -FULLPKGNAME-pgsql= postgresql-uuid-${VERSION} CATEGORIES= devel SHARED_LIBS= uuid 13.22 \ uuid++ 14.21 @@ -26,7 +24,7 @@ PERMIT_PACKAGE_FTP= Yes PERMIT_DISTFILES_CDROM= Yes PERMIT_DISTFILES_FTP= Yes -MULTI_PACKAGES= -main -perl -pgsql +MULTI_PACKAGES= -main -perl WANTLIB-main= c @@ -34,19 +32,10 @@ CATEGORIES-perl= devel perl5 WANTLIB-perl= LIB_DEPENDS-perl= uuid.>=12::devel/uuid -CATEGORIES-pgsql= devel databases -WANTLIB-pgsql= c -LIB_DEPENDS-pgsql= uuid.>=12::devel/uuid -RUN_DEPENDS-pgsql= :postgresql-server-*:databases/postgresql,-server -BUILD_DEPENDS+= ${RUN_DEPENDS-pgsql} - USE_LIBTOOL= Yes CONFIGURE_STYLE= gnu CONFIGURE_ARGS+= --with-perl --with-cxx \ - --without-php --with-pgsql - -pre-build: - @cp ${FILESDIR}/Makefile ${WRKSRC}/pgsql + --without-php --without-pgsql .include <bsd.port.mk> Index: files/Makefile =================================================================== RCS file: files/Makefile diff -N files/Makefile --- files/Makefile 19 Jun 2007 16:09:12 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,48 +0,0 @@ - -LIB= uuid - -PG_CONFIG?= pg_config -PG_CFLAGS!= ${PG_CONFIG} --cflags -PG_CPPFLAGS!= ${PG_CONFIG} --cppflags -PG_INCDIR!= ${PG_CONFIG} --pkgincludedir -PG_LIBDIR!= ${PG_CONFIG} --pkglibdir -PG_SHAREDIR!= ${PG_CONFIG} --sharedir -PG_DOCDIR!= ${PG_CONFIG} --docdir - -CFLAGS= ${PG_CFLAGS} -CPPFLAGS= ${PG_CPPFLAGS} -I.. -I${PG_INCDIR}/server -I${PG_INCDIR}/internal - -LDFLAGS= -L../.libs -L${PG_LIBDIR} -LDADD= -luuid -lc - -.SUFFIXES: .sql .sql.in .c .o .so - -all: ${LIB:=.sql} ${LIB:=.so} - -.sql.in.sql: - sed -e 's,MODULE_PATHNAME,$$libdir/$*,g' $< >$@ - -.c.o: - ${COMPILE.c} ${PICFLAG} -DPIC ${.IMPSRC} -o ${.TARGET} - -.o.so: - ${AR} cr ${LIB}.a uuid.o - ${RANLIB} ${LIB}.a - ${CC} ${CFLAGS} ${PICFLAG} -DPIC -shared -Wl,-x ${.IMPSRC} \ - ${LDFLAGS} ${LDADD} -o ${.TARGET} - -install: all - ${INSTALL} -d ${DESTDIR}${PG_LIBDIR} - ${INSTALL} ${LIB:=.so} ${DESTDIR}${PG_LIBDIR}/${LIB:=.so} - ${INSTALL} -d ${DESTDIR}${PG_SHAREDIR} - ${INSTALL} uuid.sql ${DESTDIR}${PG_SHAREDIR}/uuid.sql - ${INSTALL} -d ${DESTDIR}${PG_DOCDIR} - ${INSTALL} uuid.txt ${DESTDIR}${PG_DOCDIR}/uuid.txt - -clean: - rm -f a.out [Ee]rrs mklog core *.core - rm -f ${LIB:=.sql} ${LIB}*.{a,o,so} - -.PHONY: clean - -.include <bsd.own.mk> Index: pkg/DESCR-pgsql =================================================================== RCS file: pkg/DESCR-pgsql diff -N pkg/DESCR-pgsql --- pkg/DESCR-pgsql 19 Jun 2007 16:09:12 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,2 +0,0 @@ -This is the OSSP uuid binding for the PostgreSQL RDBMS, providing -native UUID data type support. Index: pkg/PLIST-pgsql =================================================================== RCS file: pkg/PLIST-pgsql diff -N pkg/PLIST-pgsql --- pkg/PLIST-pgsql 19 Jun 2007 16:09:12 -0000 1.1 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,7 +0,0 @@ [EMAIL PROTECTED] $OpenBSD: PLIST-pgsql,v 1.1 2007/06/19 16:09:12 simon Exp $ -lib/postgresql/ -lib/postgresql/uuid.so -share/doc/postgresql/ -share/doc/postgresql/uuid.txt -share/postgresql/ -share/postgresql/uuid.sql
Index: Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.114 diff -u -p -r1.114 Makefile --- Makefile 7 Jan 2008 16:34:52 -0000 1.114 +++ Makefile 4 Feb 2008 13:11:12 -0000 @@ -5,7 +5,7 @@ COMMENT-server= PostgreSQL RDBMS (server COMMENT-docs= PostgreSQL RDBMS documentation COMMENT-contrib=PostgreSQL RDBMS contributions -VERSION= 8.2.6 +VERSION= 8.3.0 DISTNAME= postgresql-${VERSION} PKGNAME-main= postgresql-client-${VERSION} PKGNAME-server= postgresql-server-${VERSION} @@ -13,10 +13,10 @@ PKGNAME-docs= postgresql-docs-${VERSION} PKGNAME-contrib=postgresql-contrib-${VERSION} CATEGORIES= databases -SHARED_LIBS= ecpg 6.0 \ - ecpg_compat 3.0 \ - pgtypes 3.0 \ - pq 5.0 +SHARED_LIBS= ecpg 7.0 \ + ecpg_compat 4.0 \ + pgtypes 4.0 \ + pq 5.1 HOMEPAGE= http://www.postgresql.org/ @@ -51,16 +51,22 @@ CONFIGURE_STYLE=gnu .include <bsd.own.mk> +INCLUDES= ${LOCALBASE}/include CONFIGURE_ARGS= --disable-rpath --with-openssl=/usr \ --with-perl \ --enable-integer-datetimes \ --includedir="${PREFIX}/include/postgresql" \ --datadir="${PREFIX}/share/postgresql" \ --with-docdir="${PREFIX}/share/doc/postgresql" \ - --with-openssl + --with-includes="${INCLUDES}" \ + --with-libraries="${LOCALBASE}/lib" \ + --with-openssl \ + --with-ossp-uuid \ + --with-libxml .if ${KERBEROS5} == "yes" -CONFIGURE_ARGS+=--with-krb5 --with-includes=/usr/include/kerberosV +CONFIGURE_ARGS+=--with-krb5 +INCLUDES+= /usr/include/kerberosV .endif # There is no spinlock support for hppa yet. Until we have access to @@ -75,12 +81,17 @@ MODGNU_CONFIG_GUESS_DIRS= ${WRKSRC}/conf INSTALL_TARGET= install +LIB_DEPENDS-main= xml2::textproc/libxml + WANTLIB-server= ${WANTLIB} perl -LIB_DEPENDS-server= pq.>=4:postgresql-client-${VERSION}:databases/postgresql +LIB_DEPENDS-server= pq.>=4:postgresql-client-${VERSION}:databases/postgresql \ + ${LIB_DEPENDS-main} RUN_DEPENDS-contrib=:postgresql-server-${VERSION}:databases/postgresql,-server -LIB_DEPENDS-contrib= pq.>=4:postgresql-client-${VERSION}:databases/postgresql +LIB_DEPENDS-contrib= pq.>=4:postgresql-client-${VERSION}:databases/postgresql \ + ${LIB_DEPENDS-main} \ + uuid::devel/uuid WANTLIB-docs= PKG_ARCH-docs= * Index: distinfo =================================================================== RCS file: /cvs/ports/databases/postgresql/distinfo,v retrieving revision 1.22 diff -u -p -r1.22 distinfo --- distinfo 7 Jan 2008 16:34:52 -0000 1.22 +++ distinfo 4 Feb 2008 13:11:12 -0000 @@ -1,5 +1,5 @@ -MD5 (postgresql-8.2.6.tar.gz) = tlqu1yYIqm3g2QGZUqAYtA== -RMD160 (postgresql-8.2.6.tar.gz) = RVa432YVBk3Fnl7H3iNp/v11DZU= -SHA1 (postgresql-8.2.6.tar.gz) = wXEOAz7a0EOQnOYAlCORRwYTYjM= -SHA256 (postgresql-8.2.6.tar.gz) = hWX0nj+RQ0Yvqs0JXA/xoj85RVeeu2NVhU0E2WzQ6fg= -SIZE (postgresql-8.2.6.tar.gz) = 15616846 +MD5 (postgresql-8.3.0.tar.gz) = IBmybEXAMLzsm7YSBFX6WA== +RMD160 (postgresql-8.3.0.tar.gz) = T8zTYcymgIQrUm5rR4OVegw4uR0= +SHA1 (postgresql-8.3.0.tar.gz) = N8jpHzdrGqLTHUepxcJJqCqzN58= +SHA256 (postgresql-8.3.0.tar.gz) = 99fcT3bhSXEqze8lvQrJXpRCQAYN2J24yh9dXwbUSGg= +SIZE (postgresql-8.3.0.tar.gz) = 17383198 Index: patches/patch-configure =================================================================== RCS file: /cvs/ports/databases/postgresql/patches/patch-configure,v retrieving revision 1.5 diff -u -p -r1.5 patch-configure --- patches/patch-configure 20 Sep 2007 19:20:48 -0000 1.5 +++ patches/patch-configure 4 Feb 2008 13:11:12 -0000 @@ -1,12 +1,12 @@ $OpenBSD: patch-configure,v 1.5 2007/09/20 19:20:48 mbalmer Exp $ ---- configure.orig Fri Sep 14 22:18:26 2007 -+++ configure Mon Sep 17 09:12:54 2007 -@@ -6535,7 +6535,7 @@ fi +--- configure.orig Fri Nov 16 05:59:25 2007 ++++ configure Tue Nov 27 15:35:52 2007 +@@ -7053,7 +7053,7 @@ fi rm -f conftest.err conftest.$ac_objext \ conftest$ac_exeext conftest.$ac_ext if test "$ac_cv_search_com_err" = no; then -- for ac_lib in krb5 'krb5 -ldes -lasn1 -lroken' com_err; do -+ for ac_lib in krb5 'krb5 -ldes -lasn1 -lroken' 'com_err -lssl -lcrypto' ; do +- for ac_lib in krb5 'krb5 -lcrypto -ldes -lasn1 -lroken' com_err; do ++ for ac_lib in krb5 'krb5 -lcrypto -ldes -lasn1 -lroken' 'com_err -lssl -lcrypto' ; do LIBS="-l$ac_lib $ac_func_search_save_LIBS" cat >conftest.$ac_ext <<_ACEOF /* confdefs.h. */ Index: patches/patch-src_interfaces_ecpg_compatlib_Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/patches/patch-src_interfaces_ecpg_compatlib_Makefile,v retrieving revision 1.2 diff -u -p -r1.2 patch-src_interfaces_ecpg_compatlib_Makefile --- patches/patch-src_interfaces_ecpg_compatlib_Makefile 17 Jan 2007 16:47:25 -0000 1.2 +++ patches/patch-src_interfaces_ecpg_compatlib_Makefile 4 Feb 2008 13:11:12 -0000 @@ -1,12 +1,12 @@ $OpenBSD: patch-src_interfaces_ecpg_compatlib_Makefile,v 1.2 2007/01/17 16:47:25 mbalmer Exp $ ---- src/interfaces/ecpg/compatlib/Makefile.orig Mon Sep 11 00:07:02 2006 -+++ src/interfaces/ecpg/compatlib/Makefile Mon Jan 15 18:08:43 2007 -@@ -13,8 +13,8 @@ top_builddir = ../../../.. +--- src/interfaces/ecpg/compatlib/Makefile.orig Fri Oct 5 03:51:40 2007 ++++ src/interfaces/ecpg/compatlib/Makefile Tue Nov 27 15:37:12 2007 +@@ -14,8 +14,8 @@ top_builddir = ../../../.. include $(top_builddir)/src/Makefile.global NAME= ecpg_compat --SO_MAJOR_VERSION= 2 --SO_MINOR_VERSION= 2 +-SO_MAJOR_VERSION= 3 +-SO_MINOR_VERSION= 0 +SO_MAJOR_VERSION= ${LIBecpg_compat_MAJOR} +SO_MINOR_VERSION= ${LIBecpg_compat_MINOR} DLTYPE= library Index: patches/patch-src_interfaces_ecpg_ecpglib_Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/patches/patch-src_interfaces_ecpg_ecpglib_Makefile,v retrieving revision 1.2 diff -u -p -r1.2 patch-src_interfaces_ecpg_ecpglib_Makefile --- patches/patch-src_interfaces_ecpg_ecpglib_Makefile 17 Jan 2007 16:47:25 -0000 1.2 +++ patches/patch-src_interfaces_ecpg_ecpglib_Makefile 4 Feb 2008 13:11:12 -0000 @@ -1,14 +1,14 @@ $OpenBSD: patch-src_interfaces_ecpg_ecpglib_Makefile,v 1.2 2007/01/17 16:47:25 mbalmer Exp $ ---- src/interfaces/ecpg/ecpglib/Makefile.orig Thu Sep 28 16:48:45 2006 -+++ src/interfaces/ecpg/ecpglib/Makefile Mon Jan 15 18:11:08 2007 -@@ -13,8 +13,8 @@ top_builddir = ../../../.. +--- src/interfaces/ecpg/ecpglib/Makefile.orig Fri Oct 5 03:51:40 2007 ++++ src/interfaces/ecpg/ecpglib/Makefile Tue Nov 27 15:38:02 2007 +@@ -14,8 +14,8 @@ top_builddir = ../../../.. include $(top_builddir)/src/Makefile.global NAME= ecpg --SO_MAJOR_VERSION= 5 --SO_MINOR_VERSION= 2 +-SO_MAJOR_VERSION= 6 +-SO_MINOR_VERSION= 0 +SO_MAJOR_VERSION= ${LIBecpg_MAJOR} +SO_MINOR_VERSION= ${LIBecpg_MINOR} DLTYPE= library - override CPPFLAGS := -DFRONTEND \ + override CPPFLAGS := -I../include -I$(top_srcdir)/src/interfaces/ecpg/include \ Index: patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile,v retrieving revision 1.3 diff -u -p -r1.3 patch-src_interfaces_ecpg_pgtypeslib_Makefile --- patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile 17 Jan 2007 16:47:25 -0000 1.3 +++ patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile 4 Feb 2008 13:11:12 -0000 @@ -1,14 +1,14 @@ $OpenBSD: patch-src_interfaces_ecpg_pgtypeslib_Makefile,v 1.3 2007/01/17 16:47:25 mbalmer Exp $ ---- src/interfaces/ecpg/pgtypeslib/Makefile.orig Mon Aug 28 18:13:11 2006 -+++ src/interfaces/ecpg/pgtypeslib/Makefile Mon Jan 15 18:11:54 2007 -@@ -13,8 +13,8 @@ top_builddir = ../../../.. +--- src/interfaces/ecpg/pgtypeslib/Makefile.orig Fri Oct 5 03:51:40 2007 ++++ src/interfaces/ecpg/pgtypeslib/Makefile Tue Nov 27 15:38:30 2007 +@@ -14,8 +14,8 @@ top_builddir = ../../../.. include $(top_builddir)/src/Makefile.global NAME= pgtypes --SO_MAJOR_VERSION= 2 --SO_MINOR_VERSION= 2 +-SO_MAJOR_VERSION= 3 +-SO_MINOR_VERSION= 0 +SO_MAJOR_VERSION= ${LIBpgtypes_MAJOR} +SO_MINOR_VERSION= ${LIBpgtypes_MINOR} DLTYPE= library - override CPPFLAGS := -DFRONTEND \ + override CPPFLAGS := -I../include -I$(top_srcdir)/src/interfaces/ecpg/include \ Index: patches/patch-src_interfaces_libpq_Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/patches/patch-src_interfaces_libpq_Makefile,v retrieving revision 1.3 diff -u -p -r1.3 patch-src_interfaces_libpq_Makefile --- patches/patch-src_interfaces_libpq_Makefile 20 Sep 2007 19:20:48 -0000 1.3 +++ patches/patch-src_interfaces_libpq_Makefile 4 Feb 2008 13:11:12 -0000 @@ -1,12 +1,12 @@ $OpenBSD: patch-src_interfaces_libpq_Makefile,v 1.3 2007/09/20 19:20:48 mbalmer Exp $ ---- src/interfaces/libpq/Makefile.orig Thu Dec 28 01:01:12 2006 -+++ src/interfaces/libpq/Makefile Mon Sep 17 09:12:54 2007 +--- src/interfaces/libpq/Makefile.orig Tue Jul 24 11:00:27 2007 ++++ src/interfaces/libpq/Makefile Tue Nov 27 15:38:54 2007 @@ -16,8 +16,8 @@ include $(top_builddir)/src/Makefile.global # shared library parameters NAME= pq -SO_MAJOR_VERSION= 5 --SO_MINOR_VERSION= 0 +-SO_MINOR_VERSION= 1 +SO_MAJOR_VERSION= ${LIBpq_MAJOR} +SO_MINOR_VERSION= ${LIBpq_MINOR} DLTYPE= library Index: pkg/PLIST-contrib =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-contrib,v retrieving revision 1.2 diff -u -p -r1.2 PLIST-contrib --- pkg/PLIST-contrib 4 Jul 2007 19:18:46 -0000 1.2 +++ pkg/PLIST-contrib 4 Feb 2008 13:11:12 -0000 @@ -1,4 +1,6 @@ @comment $OpenBSD: PLIST-contrib,v 1.2 2007/07/04 19:18:46 jasper Exp $ [EMAIL PROTECTED] postgresql-uuid-* [EMAIL PROTECTED] devel/uuid,-pgsql bin/oid2name bin/pgbench bin/vacuumlo @@ -30,6 +32,7 @@ lib/postgresql/sslinfo.so lib/postgresql/tablefunc.so lib/postgresql/timetravel.so lib/postgresql/tsearch2.so +lib/postgresql/uuid-ossp.so share/postgresql/contrib/ share/postgresql/contrib/_int.sql share/postgresql/contrib/adminpack.sql @@ -38,8 +41,9 @@ share/postgresql/contrib/btree_gist.sql share/postgresql/contrib/chkpass.sql share/postgresql/contrib/cube.sql share/postgresql/contrib/dblink.sql +share/postgresql/contrib/dict_int.sql +share/postgresql/contrib/dict_xsyn.sql share/postgresql/contrib/earthdistance.sql -share/postgresql/contrib/english.stop share/postgresql/contrib/fuzzystrmatch.sql share/postgresql/contrib/hstore.sql share/postgresql/contrib/insert_username.sql @@ -48,6 +52,7 @@ share/postgresql/contrib/isn.sql share/postgresql/contrib/lo.sql share/postgresql/contrib/ltree.sql share/postgresql/contrib/moddatetime.sql +share/postgresql/contrib/pageinspect.sql share/postgresql/contrib/pg_buffercache.sql share/postgresql/contrib/pg_freespacemap.sql share/postgresql/contrib/pg_trgm.sql @@ -55,12 +60,10 @@ share/postgresql/contrib/pgcrypto.sql share/postgresql/contrib/pgrowlocks.sql share/postgresql/contrib/pgstattuple.sql share/postgresql/contrib/refint.sql -share/postgresql/contrib/russian.stop -share/postgresql/contrib/russian.stop.utf8 share/postgresql/contrib/seg.sql share/postgresql/contrib/sslinfo.sql share/postgresql/contrib/tablefunc.sql -share/postgresql/contrib/thesaurus +share/postgresql/contrib/test_parser.sql share/postgresql/contrib/timetravel.sql share/postgresql/contrib/tsearch2.sql share/postgresql/contrib/uninstall__int.sql @@ -69,6 +72,8 @@ share/postgresql/contrib/uninstall_btree share/postgresql/contrib/uninstall_chkpass.sql share/postgresql/contrib/uninstall_cube.sql share/postgresql/contrib/uninstall_dblink.sql +share/postgresql/contrib/uninstall_dict_int.sql +share/postgresql/contrib/uninstall_dict_xsyn.sql share/postgresql/contrib/uninstall_earthdistance.sql share/postgresql/contrib/uninstall_fuzzystrmatch.sql share/postgresql/contrib/uninstall_hstore.sql @@ -76,6 +81,7 @@ share/postgresql/contrib/uninstall_int_a share/postgresql/contrib/uninstall_isn.sql share/postgresql/contrib/uninstall_lo.sql share/postgresql/contrib/uninstall_ltree.sql +share/postgresql/contrib/uninstall_pageinspect.sql share/postgresql/contrib/uninstall_pg_buffercache.sql share/postgresql/contrib/uninstall_pg_freespacemap.sql share/postgresql/contrib/uninstall_pg_trgm.sql @@ -85,4 +91,7 @@ share/postgresql/contrib/uninstall_pgsta share/postgresql/contrib/uninstall_seg.sql share/postgresql/contrib/uninstall_sslinfo.sql share/postgresql/contrib/uninstall_tablefunc.sql +share/postgresql/contrib/uninstall_test_parser.sql share/postgresql/contrib/uninstall_tsearch2.sql +share/postgresql/contrib/uninstall_uuid-ossp.sql +share/postgresql/contrib/uuid-ossp.sql Index: pkg/PLIST-docs =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v retrieving revision 1.34 diff -u -p -r1.34 PLIST-docs --- pkg/PLIST-docs 7 Jan 2008 16:34:52 -0000 1.34 +++ pkg/PLIST-docs 4 Feb 2008 13:11:12 -0000 @@ -1,5 +1,4 @@ @comment $OpenBSD: PLIST-docs,v 1.34 2008/01/07 16:34:52 mbalmer Exp $ [EMAIL PROTECTED] lib/libpq.so.5 share/doc/postgresql/COPYRIGHT share/doc/postgresql/FAQ share/doc/postgresql/FAQ_DEV @@ -10,37 +9,6 @@ share/doc/postgresql/README.mb.big5 share/doc/postgresql/README.mb.jp share/doc/postgresql/TODO share/doc/postgresql/contrib/ -share/doc/postgresql/contrib/README.adminpack -share/doc/postgresql/contrib/README.btree_gist -share/doc/postgresql/contrib/README.chkpass -share/doc/postgresql/contrib/README.cube -share/doc/postgresql/contrib/README.dblink -share/doc/postgresql/contrib/README.earthdistance -share/doc/postgresql/contrib/README.fuzzystrmatch -share/doc/postgresql/contrib/README.hstore -share/doc/postgresql/contrib/README.int_aggregate -share/doc/postgresql/contrib/README.intarray -share/doc/postgresql/contrib/README.isn -share/doc/postgresql/contrib/README.lo -share/doc/postgresql/contrib/README.ltree -share/doc/postgresql/contrib/README.oid2name -share/doc/postgresql/contrib/README.pg_buffercache -share/doc/postgresql/contrib/README.pg_freespacemap -share/doc/postgresql/contrib/README.pg_trgm -share/doc/postgresql/contrib/README.pgbench -share/doc/postgresql/contrib/README.pgbench_jis -share/doc/postgresql/contrib/README.pgcrypto -share/doc/postgresql/contrib/README.pgrowlocks -share/doc/postgresql/contrib/README.pgrowlocks.euc_jp -share/doc/postgresql/contrib/README.pgstattuple -share/doc/postgresql/contrib/README.pgstattuple.euc_jp -share/doc/postgresql/contrib/README.seg -share/doc/postgresql/contrib/README.soundex -share/doc/postgresql/contrib/README.spi -share/doc/postgresql/contrib/README.sslinfo -share/doc/postgresql/contrib/README.tablefunc -share/doc/postgresql/contrib/README.tsearch2 -share/doc/postgresql/contrib/README.vacuumlo share/doc/postgresql/contrib/autoinc.example share/doc/postgresql/contrib/insert_username.example share/doc/postgresql/contrib/moddatetime.example @@ -48,7 +16,9 @@ share/doc/postgresql/contrib/refint.exam share/doc/postgresql/contrib/timetravel.example share/doc/postgresql/html/ share/doc/postgresql/html/LEGALNOTICE.html +share/doc/postgresql/html/acronyms.html share/doc/postgresql/html/admin.html +share/doc/postgresql/html/adminpack.html share/doc/postgresql/html/anoncvs.html share/doc/postgresql/html/app-clusterdb.html share/doc/postgresql/html/app-createdb.html @@ -87,6 +57,7 @@ share/doc/postgresql/html/bki-format.htm share/doc/postgresql/html/bki-structure.html share/doc/postgresql/html/bki.html share/doc/postgresql/html/bookindex.html +share/doc/postgresql/html/btree-gist.html share/doc/postgresql/html/bug-reporting.html share/doc/postgresql/html/catalog-pg-aggregate.html share/doc/postgresql/html/catalog-pg-am.html @@ -104,6 +75,7 @@ share/doc/postgresql/html/catalog-pg-con share/doc/postgresql/html/catalog-pg-database.html share/doc/postgresql/html/catalog-pg-depend.html share/doc/postgresql/html/catalog-pg-description.html +share/doc/postgresql/html/catalog-pg-enum.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 @@ -112,6 +84,7 @@ share/doc/postgresql/html/catalog-pg-lis share/doc/postgresql/html/catalog-pg-namespace.html share/doc/postgresql/html/catalog-pg-opclass.html share/doc/postgresql/html/catalog-pg-operator.html +share/doc/postgresql/html/catalog-pg-opfamily.html share/doc/postgresql/html/catalog-pg-pltemplate.html share/doc/postgresql/html/catalog-pg-proc.html share/doc/postgresql/html/catalog-pg-rewrite.html @@ -120,17 +93,45 @@ share/doc/postgresql/html/catalog-pg-shd share/doc/postgresql/html/catalog-pg-statistic.html share/doc/postgresql/html/catalog-pg-tablespace.html share/doc/postgresql/html/catalog-pg-trigger.html +share/doc/postgresql/html/catalog-pg-ts-config-map.html +share/doc/postgresql/html/catalog-pg-ts-config.html +share/doc/postgresql/html/catalog-pg-ts-dict.html +share/doc/postgresql/html/catalog-pg-ts-parser.html +share/doc/postgresql/html/catalog-pg-ts-template.html share/doc/postgresql/html/catalog-pg-type.html share/doc/postgresql/html/catalogs-overview.html share/doc/postgresql/html/catalogs.html share/doc/postgresql/html/charset.html +share/doc/postgresql/html/chkpass.html share/doc/postgresql/html/client-authentication-problems.html share/doc/postgresql/html/client-authentication.html share/doc/postgresql/html/client-interfaces.html share/doc/postgresql/html/config-setting.html share/doc/postgresql/html/connect-estab.html share/doc/postgresql/html/continuous-archiving.html +share/doc/postgresql/html/contrib-dblink-build-sql-delete.html +share/doc/postgresql/html/contrib-dblink-build-sql-insert.html +share/doc/postgresql/html/contrib-dblink-build-sql-update.html +share/doc/postgresql/html/contrib-dblink-cancel-query.html +share/doc/postgresql/html/contrib-dblink-close.html +share/doc/postgresql/html/contrib-dblink-connect-u.html +share/doc/postgresql/html/contrib-dblink-connect.html +share/doc/postgresql/html/contrib-dblink-current-query.html +share/doc/postgresql/html/contrib-dblink-disconnect.html +share/doc/postgresql/html/contrib-dblink-error-message.html +share/doc/postgresql/html/contrib-dblink-exec.html +share/doc/postgresql/html/contrib-dblink-fetch.html +share/doc/postgresql/html/contrib-dblink-get-connections.html +share/doc/postgresql/html/contrib-dblink-get-pkey.html +share/doc/postgresql/html/contrib-dblink-get-result.html +share/doc/postgresql/html/contrib-dblink-is-busy.html +share/doc/postgresql/html/contrib-dblink-open.html +share/doc/postgresql/html/contrib-dblink-send-query.html +share/doc/postgresql/html/contrib-dblink.html +share/doc/postgresql/html/contrib-spi.html +share/doc/postgresql/html/contrib.html share/doc/postgresql/html/creating-cluster.html +share/doc/postgresql/html/cube.html share/doc/postgresql/html/cvs-tree.html share/doc/postgresql/html/cvs.html share/doc/postgresql/html/cvsup.html @@ -140,18 +141,23 @@ share/doc/postgresql/html/datatype-bit.h 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-enum.html share/doc/postgresql/html/datatype-geometric.html share/doc/postgresql/html/datatype-money.html share/doc/postgresql/html/datatype-net-types.html share/doc/postgresql/html/datatype-numeric.html share/doc/postgresql/html/datatype-oid.html share/doc/postgresql/html/datatype-pseudo.html +share/doc/postgresql/html/datatype-textsearch.html +share/doc/postgresql/html/datatype-uuid.html share/doc/postgresql/html/datatype-xml.html share/doc/postgresql/html/datatype.html share/doc/postgresql/html/datetime-appendix.html share/doc/postgresql/html/datetime-config-files.html +share/doc/postgresql/html/datetime-input-rules.html share/doc/postgresql/html/datetime-keywords.html share/doc/postgresql/html/datetime-units-history.html +share/doc/postgresql/html/dblink.html share/doc/postgresql/html/ddl-alter.html share/doc/postgresql/html/ddl-basics.html share/doc/postgresql/html/ddl-constraints.html @@ -164,6 +170,8 @@ share/doc/postgresql/html/ddl-priv.html share/doc/postgresql/html/ddl-schemas.html share/doc/postgresql/html/ddl-system-columns.html share/doc/postgresql/html/ddl.html +share/doc/postgresql/html/dict-int.html +share/doc/postgresql/html/dict-xsyn.html share/doc/postgresql/html/disk-full.html share/doc/postgresql/html/disk-usage.html share/doc/postgresql/html/diskusage.html @@ -178,6 +186,7 @@ share/doc/postgresql/html/docguide-style share/doc/postgresql/html/docguide-toolsets.html share/doc/postgresql/html/docguide.html share/doc/postgresql/html/dynamic-trace.html +share/doc/postgresql/html/earthdistance.html share/doc/postgresql/html/ecpg-commands.html share/doc/postgresql/html/ecpg-concept.html share/doc/postgresql/html/ecpg-connect.html @@ -219,6 +228,7 @@ share/doc/postgresql/html/functions-comp share/doc/postgresql/html/functions-comparisons.html share/doc/postgresql/html/functions-conditional.html share/doc/postgresql/html/functions-datetime.html +share/doc/postgresql/html/functions-enum.html share/doc/postgresql/html/functions-formatting.html share/doc/postgresql/html/functions-geometry.html share/doc/postgresql/html/functions-info.html @@ -230,7 +240,10 @@ share/doc/postgresql/html/functions-sequ share/doc/postgresql/html/functions-srf.html share/doc/postgresql/html/functions-string.html share/doc/postgresql/html/functions-subquery.html +share/doc/postgresql/html/functions-textsearch.html +share/doc/postgresql/html/functions-xml.html share/doc/postgresql/html/functions.html +share/doc/postgresql/html/fuzzystrmatch.html share/doc/postgresql/html/geqo-biblio.html share/doc/postgresql/html/geqo-intro.html share/doc/postgresql/html/geqo-intro2.html @@ -251,6 +264,7 @@ share/doc/postgresql/html/gist-recovery. share/doc/postgresql/html/gist.html share/doc/postgresql/html/high-availability.html share/doc/postgresql/html/history.html +share/doc/postgresql/html/hstore.html share/doc/postgresql/html/index-catalog.html share/doc/postgresql/html/index-cost-estimation.html share/doc/postgresql/html/index-functions.html @@ -265,6 +279,7 @@ share/doc/postgresql/html/indexes-expres share/doc/postgresql/html/indexes-intro.html share/doc/postgresql/html/indexes-multicolumn.html share/doc/postgresql/html/indexes-opclass.html +share/doc/postgresql/html/indexes-ordering.html share/doc/postgresql/html/indexes-partial.html share/doc/postgresql/html/indexes-types.html share/doc/postgresql/html/indexes-unique.html @@ -323,10 +338,15 @@ share/doc/postgresql/html/install-proced share/doc/postgresql/html/install-requirements.html share/doc/postgresql/html/install-short.html share/doc/postgresql/html/install-upgrading.html +share/doc/postgresql/html/install-win32-full.html +share/doc/postgresql/html/install-win32-libpq.html share/doc/postgresql/html/install-win32.html share/doc/postgresql/html/installation.html +share/doc/postgresql/html/intagg.html +share/doc/postgresql/html/intarray.html share/doc/postgresql/html/internals.html share/doc/postgresql/html/intro-whatis.html +share/doc/postgresql/html/isn.html share/doc/postgresql/html/kernel-resources.html share/doc/postgresql/html/largeobjects.html share/doc/postgresql/html/libpq-async.html @@ -354,9 +374,11 @@ 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-intro.html +share/doc/postgresql/html/lo.html share/doc/postgresql/html/locale.html share/doc/postgresql/html/locking-indexes.html share/doc/postgresql/html/logfile-maintenance.html +share/doc/postgresql/html/ltree.html share/doc/postgresql/html/maintenance.html share/doc/postgresql/html/manage-ag-config.html share/doc/postgresql/html/manage-ag-createdb.html @@ -377,10 +399,20 @@ share/doc/postgresql/html/nls-programmer share/doc/postgresql/html/nls-translator.html share/doc/postgresql/html/nls.html share/doc/postgresql/html/notation.html +share/doc/postgresql/html/oid2name.html share/doc/postgresql/html/overview.html +share/doc/postgresql/html/pageinspect.html share/doc/postgresql/html/parser-stage.html share/doc/postgresql/html/performance-tips.html share/doc/postgresql/html/perm-functions.html +share/doc/postgresql/html/pgbench.html +share/doc/postgresql/html/pgbuffercache.html +share/doc/postgresql/html/pgcrypto.html +share/doc/postgresql/html/pgfreespacemap.html +share/doc/postgresql/html/pgrowlocks.html +share/doc/postgresql/html/pgstandby.html +share/doc/postgresql/html/pgstattuple.html +share/doc/postgresql/html/pgtrgm.html share/doc/postgresql/html/planner-optimizer.html share/doc/postgresql/html/planner-stats-details.html share/doc/postgresql/html/planner-stats.html @@ -399,6 +431,7 @@ share/doc/postgresql/html/plpgsql-declar share/doc/postgresql/html/plpgsql-development-tips.html share/doc/postgresql/html/plpgsql-errors-and-messages.html share/doc/postgresql/html/plpgsql-expressions.html +share/doc/postgresql/html/plpgsql-implementation.html share/doc/postgresql/html/plpgsql-overview.html share/doc/postgresql/html/plpgsql-porting.html share/doc/postgresql/html/plpgsql-statements.html @@ -421,6 +454,7 @@ share/doc/postgresql/html/pltcl.html share/doc/postgresql/html/populate.html share/doc/postgresql/html/postgres-user.html share/doc/postgresql/html/preface.html +share/doc/postgresql/html/preventing-server-spoofing.html share/doc/postgresql/html/privileges.html share/doc/postgresql/html/protocol-changes.html share/doc/postgresql/html/protocol-error-fields.html @@ -562,6 +596,7 @@ share/doc/postgresql/html/release-8-2-4. share/doc/postgresql/html/release-8-2-5.html share/doc/postgresql/html/release-8-2-6.html share/doc/postgresql/html/release-8-2.html +share/doc/postgresql/html/release-8-3.html share/doc/postgresql/html/release.html share/doc/postgresql/html/resources.html share/doc/postgresql/html/role-attributes.html @@ -570,6 +605,7 @@ share/doc/postgresql/html/routine-reinde share/doc/postgresql/html/routine-vacuuming.html share/doc/postgresql/html/row-estimation-examples.html share/doc/postgresql/html/rowtypes.html +share/doc/postgresql/html/rsync.html share/doc/postgresql/html/rule-system.html share/doc/postgresql/html/rules-privileges.html share/doc/postgresql/html/rules-status.html @@ -594,6 +630,7 @@ share/doc/postgresql/html/runtime-config share/doc/postgresql/html/runtime-config-wal.html share/doc/postgresql/html/runtime-config.html share/doc/postgresql/html/runtime.html +share/doc/postgresql/html/seg.html share/doc/postgresql/html/server-programming.html share/doc/postgresql/html/server-shutdown.html share/doc/postgresql/html/server-start.html @@ -634,10 +671,13 @@ share/doc/postgresql/html/spi-spi-modify share/doc/postgresql/html/spi-spi-palloc.html share/doc/postgresql/html/spi-spi-pfree.html share/doc/postgresql/html/spi-spi-pop.html +share/doc/postgresql/html/spi-spi-prepare-cursor.html share/doc/postgresql/html/spi-spi-prepare.html share/doc/postgresql/html/spi-spi-push.html share/doc/postgresql/html/spi-spi-returntuple.html share/doc/postgresql/html/spi-spi-saveplan.html +share/doc/postgresql/html/spi-spi-scroll-cursor-fetch.html +share/doc/postgresql/html/spi-spi-scroll-cursor-move.html share/doc/postgresql/html/spi-visibility.html share/doc/postgresql/html/spi.html share/doc/postgresql/html/sql-abort.html @@ -651,14 +691,20 @@ share/doc/postgresql/html/sql-alterindex share/doc/postgresql/html/sql-alterlanguage.html share/doc/postgresql/html/sql-alteropclass.html share/doc/postgresql/html/sql-alteroperator.html +share/doc/postgresql/html/sql-alteropfamily.html share/doc/postgresql/html/sql-alterrole.html share/doc/postgresql/html/sql-alterschema.html share/doc/postgresql/html/sql-altersequence.html share/doc/postgresql/html/sql-altertable.html share/doc/postgresql/html/sql-altertablespace.html share/doc/postgresql/html/sql-altertrigger.html +share/doc/postgresql/html/sql-altertsconfig.html +share/doc/postgresql/html/sql-altertsdictionary.html +share/doc/postgresql/html/sql-altertsparser.html +share/doc/postgresql/html/sql-altertstemplate.html share/doc/postgresql/html/sql-altertype.html share/doc/postgresql/html/sql-alteruser.html +share/doc/postgresql/html/sql-alterview.html share/doc/postgresql/html/sql-analyze.html share/doc/postgresql/html/sql-begin.html share/doc/postgresql/html/sql-checkpoint.html @@ -681,6 +727,7 @@ share/doc/postgresql/html/sql-createinde share/doc/postgresql/html/sql-createlanguage.html share/doc/postgresql/html/sql-createopclass.html share/doc/postgresql/html/sql-createoperator.html +share/doc/postgresql/html/sql-createopfamily.html share/doc/postgresql/html/sql-createrole.html share/doc/postgresql/html/sql-createrule.html share/doc/postgresql/html/sql-createschema.html @@ -689,12 +736,17 @@ share/doc/postgresql/html/sql-createtabl share/doc/postgresql/html/sql-createtableas.html share/doc/postgresql/html/sql-createtablespace.html share/doc/postgresql/html/sql-createtrigger.html +share/doc/postgresql/html/sql-createtsconfig.html +share/doc/postgresql/html/sql-createtsdictionary.html +share/doc/postgresql/html/sql-createtsparser.html +share/doc/postgresql/html/sql-createtstemplate.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-deallocate.html share/doc/postgresql/html/sql-declare.html share/doc/postgresql/html/sql-delete.html +share/doc/postgresql/html/sql-discard.html share/doc/postgresql/html/sql-drop-owned.html share/doc/postgresql/html/sql-dropaggregate.html share/doc/postgresql/html/sql-dropcast.html @@ -707,6 +759,7 @@ share/doc/postgresql/html/sql-dropindex. share/doc/postgresql/html/sql-droplanguage.html share/doc/postgresql/html/sql-dropopclass.html share/doc/postgresql/html/sql-dropoperator.html +share/doc/postgresql/html/sql-dropopfamily.html share/doc/postgresql/html/sql-droprole.html share/doc/postgresql/html/sql-droprule.html share/doc/postgresql/html/sql-dropschema.html @@ -714,6 +767,10 @@ share/doc/postgresql/html/sql-dropsequen share/doc/postgresql/html/sql-droptable.html share/doc/postgresql/html/sql-droptablespace.html share/doc/postgresql/html/sql-droptrigger.html +share/doc/postgresql/html/sql-droptsconfig.html +share/doc/postgresql/html/sql-droptsdictionary.html +share/doc/postgresql/html/sql-droptsparser.html +share/doc/postgresql/html/sql-droptstemplate.html share/doc/postgresql/html/sql-droptype.html share/doc/postgresql/html/sql-dropuser.html share/doc/postgresql/html/sql-dropview.html @@ -760,18 +817,35 @@ share/doc/postgresql/html/sql-values.htm share/doc/postgresql/html/sql.html share/doc/postgresql/html/ssh-tunnels.html share/doc/postgresql/html/ssl-tcp.html +share/doc/postgresql/html/sslinfo.html share/doc/postgresql/html/storage-file-layout.html share/doc/postgresql/html/storage-page-layout.html share/doc/postgresql/html/storage-toast.html share/doc/postgresql/html/storage.html share/doc/postgresql/html/stylesheet.css share/doc/postgresql/html/supported-platforms.html +share/doc/postgresql/html/tablefunc.html +share/doc/postgresql/html/test-parser.html +share/doc/postgresql/html/textsearch-configuration.html +share/doc/postgresql/html/textsearch-controls.html +share/doc/postgresql/html/textsearch-debugging.html +share/doc/postgresql/html/textsearch-dictionaries.html +share/doc/postgresql/html/textsearch-features.html +share/doc/postgresql/html/textsearch-indexes.html +share/doc/postgresql/html/textsearch-intro.html +share/doc/postgresql/html/textsearch-limitations.html +share/doc/postgresql/html/textsearch-migration.html +share/doc/postgresql/html/textsearch-parsers.html +share/doc/postgresql/html/textsearch-psql.html +share/doc/postgresql/html/textsearch-tables.html +share/doc/postgresql/html/textsearch.html share/doc/postgresql/html/transaction-iso.html share/doc/postgresql/html/trigger-datachanges.html share/doc/postgresql/html/trigger-definition.html share/doc/postgresql/html/trigger-example.html share/doc/postgresql/html/trigger-interface.html share/doc/postgresql/html/triggers.html +share/doc/postgresql/html/tsearch2.html share/doc/postgresql/html/tutorial-accessdb.html share/doc/postgresql/html/tutorial-advanced-intro.html share/doc/postgresql/html/tutorial-advanced.html @@ -804,6 +878,8 @@ share/doc/postgresql/html/typeconv.html share/doc/postgresql/html/unsupported-features-sql-standard.html share/doc/postgresql/html/user-manag.html share/doc/postgresql/html/using-explain.html +share/doc/postgresql/html/uuid-ossp.html +share/doc/postgresql/html/vacuumlo.html share/doc/postgresql/html/view-pg-cursors.html share/doc/postgresql/html/view-pg-group.html share/doc/postgresql/html/view-pg-indexes.html @@ -821,13 +897,13 @@ share/doc/postgresql/html/view-pg-timezo share/doc/postgresql/html/view-pg-user.html share/doc/postgresql/html/view-pg-views.html share/doc/postgresql/html/views-overview.html +share/doc/postgresql/html/wal-async-commit.html share/doc/postgresql/html/wal-configuration.html share/doc/postgresql/html/wal-internals.html share/doc/postgresql/html/wal-intro.html share/doc/postgresql/html/wal-reliability.html share/doc/postgresql/html/wal.html share/doc/postgresql/html/warm-standby.html -share/doc/postgresql/html/x71195.html share/doc/postgresql/html/xaggr.html share/doc/postgresql/html/xfunc-c.html share/doc/postgresql/html/xfunc-internal.html @@ -837,6 +913,7 @@ share/doc/postgresql/html/xfunc-sql.html share/doc/postgresql/html/xfunc-volatility.html share/doc/postgresql/html/xfunc.html share/doc/postgresql/html/xindex.html +share/doc/postgresql/html/xml2.html share/doc/postgresql/html/xoper-optimization.html share/doc/postgresql/html/xoper.html share/doc/postgresql/html/xplang-install.html Index: pkg/PLIST-main =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-main,v retrieving revision 1.8 diff -u -p -r1.8 PLIST-main --- pkg/PLIST-main 7 Jan 2008 16:34:52 -0000 1.8 +++ pkg/PLIST-main 4 Feb 2008 13:11:12 -0000 @@ -54,19 +54,20 @@ include/postgresql/sql3types.h include/postgresql/sqlca.h lib/libecpg.a @comment lib/libecpg.so [EMAIL PROTECTED] lib/libecpg.so.6 [EMAIL PROTECTED] lib/libecpg.so.7 @lib lib/libecpg.so.${LIBecpg_VERSION} lib/libecpg_compat.a @comment lib/libecpg_compat.so [EMAIL PROTECTED] lib/libecpg_compat.so.3 [EMAIL PROTECTED] lib/libecpg_compat.so.4 @lib lib/libecpg_compat.so.${LIBecpg_compat_VERSION} lib/libpgport.a lib/libpgtypes.a @comment lib/libpgtypes.so [EMAIL PROTECTED] lib/libpgtypes.so.3 [EMAIL PROTECTED] lib/libpgtypes.so.4 @lib lib/libpgtypes.so.${LIBpgtypes_VERSION} lib/libpq.a @comment lib/libpq.so [EMAIL PROTECTED] lib/libpq.so.5 @lib lib/libpq.so.${LIBpq_VERSION} lib/postgresql/ lib/postgresql/pgxs/ @@ -109,14 +110,20 @@ lib/postgresql/pgxs/src/test/regress/pg_ @man man/man7/alter_language.7 @man man/man7/alter_operator.7 @man man/man7/alter_operator_class.7 [EMAIL PROTECTED] man/man7/alter_operator_family.7 @man man/man7/alter_role.7 @man man/man7/alter_schema.7 @man man/man7/alter_sequence.7 @man man/man7/alter_table.7 @man man/man7/alter_tablespace.7 [EMAIL PROTECTED] man/man7/alter_text_search_configuration.7 [EMAIL PROTECTED] man/man7/alter_text_search_dictionary.7 [EMAIL PROTECTED] man/man7/alter_text_search_parser.7 [EMAIL PROTECTED] man/man7/alter_text_search_template.7 @man man/man7/alter_trigger.7 @man man/man7/alter_type.7 @man man/man7/alter_user.7 [EMAIL PROTECTED] man/man7/alter_view.7 @man man/man7/analyze.7 @man man/man7/begin.7 @man man/man7/checkpoint.7 @@ -138,6 +145,7 @@ lib/postgresql/pgxs/src/test/regress/pg_ @man man/man7/create_language.7 @man man/man7/create_operator.7 @man man/man7/create_operator_class.7 [EMAIL PROTECTED] man/man7/create_operator_family.7 @man man/man7/create_role.7 @man man/man7/create_rule.7 @man man/man7/create_schema.7 @@ -145,6 +153,10 @@ lib/postgresql/pgxs/src/test/regress/pg_ @man man/man7/create_table.7 @man man/man7/create_table_as.7 @man man/man7/create_tablespace.7 [EMAIL PROTECTED] man/man7/create_text_search_configuration.7 [EMAIL PROTECTED] man/man7/create_text_search_dictionary.7 [EMAIL PROTECTED] man/man7/create_text_search_parser.7 [EMAIL PROTECTED] man/man7/create_text_search_template.7 @man man/man7/create_trigger.7 @man man/man7/create_type.7 @man man/man7/create_user.7 @@ -152,6 +164,7 @@ lib/postgresql/pgxs/src/test/regress/pg_ @man man/man7/deallocate.7 @man man/man7/declare.7 @man man/man7/delete.7 [EMAIL PROTECTED] man/man7/discard.7 @man man/man7/drop_aggregate.7 @man man/man7/drop_cast.7 @man man/man7/drop_conversion.7 @@ -163,6 +176,7 @@ lib/postgresql/pgxs/src/test/regress/pg_ @man man/man7/drop_language.7 @man man/man7/drop_operator.7 @man man/man7/drop_operator_class.7 [EMAIL PROTECTED] man/man7/drop_operator_family.7 @man man/man7/drop_owned.7 @man man/man7/drop_role.7 @man man/man7/drop_rule.7 @@ -170,6 +184,10 @@ lib/postgresql/pgxs/src/test/regress/pg_ @man man/man7/drop_sequence.7 @man man/man7/drop_table.7 @man man/man7/drop_tablespace.7 [EMAIL PROTECTED] man/man7/drop_text_search_configuration.7 [EMAIL PROTECTED] man/man7/drop_text_search_dictionary.7 [EMAIL PROTECTED] man/man7/drop_text_search_parser.7 [EMAIL PROTECTED] man/man7/drop_text_search_template.7 @man man/man7/drop_trigger.7 @man man/man7/drop_type.7 @man man/man7/drop_user.7 @@ -216,6 +234,7 @@ share/postgresql/information_schema.sql share/postgresql/postgres.description share/postgresql/psqlrc.sample share/postgresql/recovery.conf.sample +share/postgresql/snowball_create.sql share/postgresql/sql_features.txt share/postgresql/system_views.sql share/postgresql/timezone/ Index: pkg/PLIST-server =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v retrieving revision 1.13 diff -u -p -r1.13 PLIST-server --- pkg/PLIST-server 4 Jul 2007 19:18:46 -0000 1.13 +++ pkg/PLIST-server 4 Feb 2008 13:11:12 -0000 @@ -11,6 +11,7 @@ bin/ipcclean bin/pg_controldata bin/pg_ctl bin/pg_resetxlog +bin/pg_standby bin/postgres bin/postmaster include/postgresql/server/ @@ -32,6 +33,7 @@ include/postgresql/server/access/nbtree. include/postgresql/server/access/printtup.h include/postgresql/server/access/reloptions.h include/postgresql/server/access/relscan.h +include/postgresql/server/access/rewriteheap.h include/postgresql/server/access/rmgr.h include/postgresql/server/access/sdir.h include/postgresql/server/access/skey.h @@ -77,6 +79,7 @@ include/postgresql/server/catalog/pg_con include/postgresql/server/catalog/pg_database.h include/postgresql/server/catalog/pg_depend.h include/postgresql/server/catalog/pg_description.h +include/postgresql/server/catalog/pg_enum.h include/postgresql/server/catalog/pg_index.h include/postgresql/server/catalog/pg_inherits.h include/postgresql/server/catalog/pg_language.h @@ -85,6 +88,7 @@ include/postgresql/server/catalog/pg_lis include/postgresql/server/catalog/pg_namespace.h include/postgresql/server/catalog/pg_opclass.h include/postgresql/server/catalog/pg_operator.h +include/postgresql/server/catalog/pg_opfamily.h include/postgresql/server/catalog/pg_pltemplate.h include/postgresql/server/catalog/pg_proc.h include/postgresql/server/catalog/pg_rewrite.h @@ -93,6 +97,11 @@ include/postgresql/server/catalog/pg_shd include/postgresql/server/catalog/pg_statistic.h include/postgresql/server/catalog/pg_tablespace.h include/postgresql/server/catalog/pg_trigger.h +include/postgresql/server/catalog/pg_ts_config.h +include/postgresql/server/catalog/pg_ts_config_map.h +include/postgresql/server/catalog/pg_ts_dict.h +include/postgresql/server/catalog/pg_ts_parser.h +include/postgresql/server/catalog/pg_ts_template.h include/postgresql/server/catalog/pg_type.h include/postgresql/server/catalog/toasting.h include/postgresql/server/commands/ @@ -104,6 +113,7 @@ include/postgresql/server/commands/conve include/postgresql/server/commands/copy.h include/postgresql/server/commands/dbcommands.h include/postgresql/server/commands/defrem.h +include/postgresql/server/commands/discard.h include/postgresql/server/commands/explain.h include/postgresql/server/commands/lockcmds.h include/postgresql/server/commands/portalcmds.h @@ -236,6 +246,7 @@ include/postgresql/server/parser/parse_o include/postgresql/server/parser/parse_relation.h include/postgresql/server/parser/parse_target.h include/postgresql/server/parser/parse_type.h +include/postgresql/server/parser/parse_utilcmd.h include/postgresql/server/parser/parser.h include/postgresql/server/parser/parsetree.h include/postgresql/server/parser/scansup.h @@ -280,9 +291,25 @@ include/postgresql/server/port/win32.h @comment include/postgresql/server/port/win32/sys/ @comment include/postgresql/server/port/win32/sys/socket.h @comment include/postgresql/server/port/win32/sys/wait.h [EMAIL PROTECTED] include/postgresql/server/port/win32_msvc/ [EMAIL PROTECTED] include/postgresql/server/port/win32_msvc/dirent.h [EMAIL PROTECTED] include/postgresql/server/port/win32_msvc/sys/ [EMAIL PROTECTED] include/postgresql/server/port/win32_msvc/sys/file.h [EMAIL PROTECTED] include/postgresql/server/port/win32_msvc/sys/param.h [EMAIL PROTECTED] include/postgresql/server/port/win32_msvc/sys/time.h [EMAIL PROTECTED] include/postgresql/server/port/win32_msvc/unistd.h [EMAIL PROTECTED] include/postgresql/server/port/win32_msvc/utime.h include/postgresql/server/postgres.h include/postgresql/server/postgres_ext.h include/postgresql/server/postgres_fe.h +include/postgresql/server/postmaster/ +include/postgresql/server/postmaster/autovacuum.h +include/postgresql/server/postmaster/bgwriter.h +include/postgresql/server/postmaster/fork_process.h +include/postgresql/server/postmaster/pgarch.h +include/postgresql/server/postmaster/postmaster.h +include/postgresql/server/postmaster/syslogger.h +include/postgresql/server/postmaster/walwriter.h include/postgresql/server/regex/ include/postgresql/server/regex/regcustom.h include/postgresql/server/regex/regerrs.h @@ -296,6 +323,42 @@ include/postgresql/server/rewrite/rewrit include/postgresql/server/rewrite/rewriteRemove.h include/postgresql/server/rewrite/rewriteSupport.h include/postgresql/server/rusagestub.h +include/postgresql/server/snowball/ +include/postgresql/server/snowball/header.h +include/postgresql/server/snowball/libstemmer/ +include/postgresql/server/snowball/libstemmer/api.h +include/postgresql/server/snowball/libstemmer/header.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_danish.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_dutch.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_english.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_finnish.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_french.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_german.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_hungarian.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_italian.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_norwegian.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_porter.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_portuguese.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_spanish.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_1_swedish.h +include/postgresql/server/snowball/libstemmer/stem_ISO_8859_2_romanian.h +include/postgresql/server/snowball/libstemmer/stem_KOI8_R_russian.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_danish.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_dutch.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_english.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_finnish.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_french.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_german.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_hungarian.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_italian.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_norwegian.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_porter.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_portuguese.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_romanian.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_russian.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_spanish.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_swedish.h +include/postgresql/server/snowball/libstemmer/stem_UTF_8_turkish.h include/postgresql/server/storage/ include/postgresql/server/storage/backendid.h include/postgresql/server/storage/block.h @@ -336,6 +399,15 @@ include/postgresql/server/tcop/pquery.h include/postgresql/server/tcop/tcopdebug.h include/postgresql/server/tcop/tcopprot.h include/postgresql/server/tcop/utility.h +include/postgresql/server/tsearch/ +include/postgresql/server/tsearch/dicts/ +include/postgresql/server/tsearch/dicts/regis.h +include/postgresql/server/tsearch/dicts/spell.h +include/postgresql/server/tsearch/ts_cache.h +include/postgresql/server/tsearch/ts_locale.h +include/postgresql/server/tsearch/ts_public.h +include/postgresql/server/tsearch/ts_type.h +include/postgresql/server/tsearch/ts_utils.h include/postgresql/server/utils/ include/postgresql/server/utils/acl.h include/postgresql/server/utils/array.h @@ -343,6 +415,7 @@ include/postgresql/server/utils/ascii.h include/postgresql/server/utils/builtins.h include/postgresql/server/utils/cash.h include/postgresql/server/utils/catcache.h +include/postgresql/server/utils/combocid.h include/postgresql/server/utils/date.h include/postgresql/server/utils/datetime.h include/postgresql/server/utils/datum.h @@ -372,6 +445,7 @@ include/postgresql/server/utils/pg_crc.h include/postgresql/server/utils/pg_locale.h include/postgresql/server/utils/pg_lzcompress.h include/postgresql/server/utils/pg_rusage.h +include/postgresql/server/utils/plancache.h include/postgresql/server/utils/portal.h include/postgresql/server/utils/ps_status.h include/postgresql/server/utils/rel.h @@ -385,21 +459,30 @@ include/postgresql/server/utils/tuplesor include/postgresql/server/utils/tuplestore.h include/postgresql/server/utils/typcache.h include/postgresql/server/utils/tzparser.h +include/postgresql/server/utils/uuid.h include/postgresql/server/utils/varbit.h +include/postgresql/server/utils/xml.h lib/postgresql/ascii_and_mic.so lib/postgresql/cyrillic_and_mic.so +lib/postgresql/dict_int.so +lib/postgresql/dict_snowball.so +lib/postgresql/dict_xsyn.so lib/postgresql/euc_cn_and_mic.so +lib/postgresql/euc_jis_2004_and_shift_jis_2004.so lib/postgresql/euc_jp_and_sjis.so lib/postgresql/euc_kr_and_mic.so lib/postgresql/euc_tw_and_big5.so lib/postgresql/latin2_and_win1250.so lib/postgresql/latin_and_mic.so +lib/postgresql/pageinspect.so lib/postgresql/plperl.so lib/postgresql/plpgsql.so +lib/postgresql/test_parser.so lib/postgresql/utf8_and_ascii.so lib/postgresql/utf8_and_big5.so lib/postgresql/utf8_and_cyrillic.so lib/postgresql/utf8_and_euc_cn.so +lib/postgresql/utf8_and_euc_jis_2004.so lib/postgresql/utf8_and_euc_jp.so lib/postgresql/utf8_and_euc_kr.so lib/postgresql/utf8_and_euc_tw.so @@ -408,6 +491,7 @@ lib/postgresql/utf8_and_gbk.so lib/postgresql/utf8_and_iso8859.so lib/postgresql/utf8_and_iso8859_1.so lib/postgresql/utf8_and_johab.so +lib/postgresql/utf8_and_shift_jis_2004.so lib/postgresql/utf8_and_sjis.so lib/postgresql/utf8_and_uhc.so lib/postgresql/utf8_and_win.so @@ -426,6 +510,27 @@ share/postgresql/pg_service.conf.sample share/postgresql/postgres.bki share/postgresql/postgres.shdescription share/postgresql/postgresql.conf.sample +share/postgresql/tsearch_data/ +share/postgresql/tsearch_data/danish.stop +share/postgresql/tsearch_data/dutch.stop +share/postgresql/tsearch_data/english.stop +share/postgresql/tsearch_data/finnish.stop +share/postgresql/tsearch_data/french.stop +share/postgresql/tsearch_data/german.stop +share/postgresql/tsearch_data/hungarian.stop +share/postgresql/tsearch_data/hunspell_sample.affix +share/postgresql/tsearch_data/ispell_sample.affix +share/postgresql/tsearch_data/ispell_sample.dict +share/postgresql/tsearch_data/italian.stop +share/postgresql/tsearch_data/norwegian.stop +share/postgresql/tsearch_data/portuguese.stop +share/postgresql/tsearch_data/russian.stop +share/postgresql/tsearch_data/spanish.stop +share/postgresql/tsearch_data/swedish.stop +share/postgresql/tsearch_data/synonym_sample.syn +share/postgresql/tsearch_data/thesaurus_sample.ths +share/postgresql/tsearch_data/turkish.stop +share/postgresql/tsearch_data/xsyn_sample.rules @mode 755 @owner _postgresql @group _postgresql