On Mon, Jun 01, 2009 at 12:37:35PM +0200, Simon Bertrang wrote: > Hi, > to all brave and/or interested database people, here's an update to > postgresql version 8.4beta2. > I'm totally in love with recursive join support for example... pick your > own favorite from > http://www.postgresql.org/docs/8.4/static/release-8-4.html :-) >
Hi, development is heading into release and here's the first release candidate. The configure patch isn't required anymore since our fixes were accepted upstream. I'm currently considering to get rid of the Makefile patches by changing variables via make flags; any thoughts to this? I'll probably suggest that with the next version/patch if it works. Kind regards, Simon (having fun with recursion and window functions) Index: Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.120 diff -u -p -r1.120 Makefile --- Makefile 18 Mar 2009 14:34:10 -0000 1.120 +++ Makefile 19 Jun 2009 16:23:40 -0000 @@ -5,7 +5,7 @@ COMMENT-server= PostgreSQL RDBMS (server COMMENT-docs= PostgreSQL RDBMS documentation COMMENT-contrib=PostgreSQL RDBMS contributions -VERSION= 8.3.7 +VERSION= 8.4rc1 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 7.0 \ - ecpg_compat 4.0 \ - pgtypes 4.0 \ - pq 5.1 +SHARED_LIBS= ecpg 7.1 \ + ecpg_compat 4.1 \ + pgtypes 4.1 \ + pq 5.2 HOMEPAGE= http://www.postgresql.org/ @@ -57,7 +57,7 @@ CONFIGURE_ARGS= --disable-rpath --with-o --enable-integer-datetimes \ --includedir="${PREFIX}/include/postgresql" \ --datadir="${PREFIX}/share/postgresql" \ - --with-docdir="${PREFIX}/share/doc/postgresql" \ + --docdir="${PREFIX}/share/doc/postgresql" \ --with-includes="${INCLUDES}" \ --with-libraries="${LOCALBASE}/lib" \ --with-openssl \ @@ -121,7 +121,7 @@ NO_REGRESS= Yes DOCS= ${WRKSRC}/COPYRIGHT ${WRKSRC}/HISTORY \ ${WRKSRC}/INSTALL ${WRKSRC}/README \ ${WRKSRC}/doc/README.mb.big5 ${WRKSRC}/doc/README.mb.jp \ - ${WRKSRC}/doc/FAQ ${WRKSRC}/doc/FAQ_DEV ${WRKSRC}/doc/TODO + ${WRKSRC}/doc/TODO post-build: cd ${WRKBUILD}/contrib && exec ${SETENV} ${MAKE_ENV} \ Index: distinfo =================================================================== RCS file: /cvs/ports/databases/postgresql/distinfo,v retrieving revision 1.28 diff -u -p -r1.28 distinfo --- distinfo 18 Mar 2009 14:34:10 -0000 1.28 +++ distinfo 19 Jun 2009 16:23:40 -0000 @@ -1,5 +1,5 @@ -MD5 (postgresql-8.3.7.tar.gz) = bjbztN0nrgw1I3bqn4Q94g== -RMD160 (postgresql-8.3.7.tar.gz) = giNm0YBlKKoCqV+ML1WmzOLtMkY= -SHA1 (postgresql-8.3.7.tar.gz) = FkmeggthWu+L2PeBEVQ00MJW98g= -SHA256 (postgresql-8.3.7.tar.gz) = O767S2AHRAmJvciL3nP2A0xTrNpwDriKxddJpHks0k8= -SIZE (postgresql-8.3.7.tar.gz) = 17613234 +MD5 (postgresql-8.4rc1.tar.gz) = Wj0CjDMj24kvnWzQaNXmig== +RMD160 (postgresql-8.4rc1.tar.gz) = sJE3UGLCzzKEiVGmKmcOaLAq7RA= +SHA1 (postgresql-8.4rc1.tar.gz) = joZUjRQPZ66SVYcon9jPbJjFXLI= +SHA256 (postgresql-8.4rc1.tar.gz) = JFe3zvbJOChnYnC0Uxw5xRX06va3Pliq7hTpL577dSw= +SIZE (postgresql-8.4rc1.tar.gz) = 18642493 Index: patches/patch-configure =================================================================== RCS file: patches/patch-configure diff -N patches/patch-configure --- patches/patch-configure 18 Jul 2008 06:57:30 -0000 1.7 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,12 +0,0 @@ -$OpenBSD: patch-configure,v 1.7 2008/07/18 06:57:30 brad Exp $ ---- configure.orig Sun Jun 8 20:38:40 2008 -+++ configure Sun Jul 6 22:32:09 2008 -@@ -7107,7 +7107,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 -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_Makefile_shlib =================================================================== RCS file: /cvs/ports/databases/postgresql/patches/patch-src_Makefile_shlib,v retrieving revision 1.6 diff -u -p -r1.6 patch-src_Makefile_shlib --- patches/patch-src_Makefile_shlib 24 May 2006 11:18:29 -0000 1.6 +++ patches/patch-src_Makefile_shlib 19 Jun 2009 16:23:40 -0000 @@ -1,12 +1,12 @@ $OpenBSD: patch-src_Makefile_shlib,v 1.6 2006/05/24 11:18:29 bernd Exp $ ---- src/Makefile.shlib.orig Sat Dec 3 21:16:39 2005 -+++ src/Makefile.shlib Wed May 24 11:01:21 2006 -@@ -119,7 +119,7 @@ endif - - ifeq ($(PORTNAME), openbsd) +--- src/Makefile.shlib.orig Mon Jan 5 10:27:19 2009 ++++ src/Makefile.shlib Sun May 31 11:58:20 2009 +@@ -154,7 +154,7 @@ ifeq ($(PORTNAME), openbsd) ifdef ELF_SYSTEM -- LINK.shared = $(COMPILER) -shared -Wl,-x,-soname,$(soname) -+ LINK.shared = $(COMPILER) -shared -Wl,-x + LINK.shared = $(COMPILER) -shared + ifdef soname +- LINK.shared += -Wl,-x,-soname,$(soname) ++ LINK.shared += -Wl,-x + endif SHLIB_LINK += -lc else - LINK.shared = $(LD) -x -Bshareable -Bforcearchive 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.3 diff -u -p -r1.3 patch-src_interfaces_ecpg_compatlib_Makefile --- patches/patch-src_interfaces_ecpg_compatlib_Makefile 24 Mar 2008 17:26:12 -0000 1.3 +++ patches/patch-src_interfaces_ecpg_compatlib_Makefile 19 Jun 2009 16:23:40 -0000 @@ -1,14 +1,14 @@ $OpenBSD: patch-src_interfaces_ecpg_compatlib_Makefile,v 1.3 2008/03/24 17:26:12 simon Exp $ ---- 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 +--- src/interfaces/ecpg/compatlib/Makefile.orig Thu Jan 1 18:24:02 2009 ++++ src/interfaces/ecpg/compatlib/Makefile Sun May 31 11:59:15 2009 @@ -14,8 +14,8 @@ top_builddir = ../../../.. include $(top_builddir)/src/Makefile.global NAME= ecpg_compat -SO_MAJOR_VERSION= 3 --SO_MINOR_VERSION= 0 +-SO_MINOR_VERSION= 1 +SO_MAJOR_VERSION= ${LIBecpg_compat_MAJOR} +SO_MINOR_VERSION= ${LIBecpg_compat_MINOR} - DLTYPE= library override CPPFLAGS := -I../include -I$(top_srcdir)/src/interfaces/ecpg/include \ + -I$(libpq_srcdir) -I$(top_srcdir)/src/include/utils $(CPPFLAGS) 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.3 diff -u -p -r1.3 patch-src_interfaces_ecpg_ecpglib_Makefile --- patches/patch-src_interfaces_ecpg_ecpglib_Makefile 24 Mar 2008 17:26:12 -0000 1.3 +++ patches/patch-src_interfaces_ecpg_ecpglib_Makefile 19 Jun 2009 16:23:40 -0000 @@ -1,14 +1,14 @@ $OpenBSD: patch-src_interfaces_ecpg_ecpglib_Makefile,v 1.3 2008/03/24 17:26:12 simon Exp $ ---- 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 +--- src/interfaces/ecpg/ecpglib/Makefile.orig Sat Feb 7 18:17:34 2009 ++++ src/interfaces/ecpg/ecpglib/Makefile Sun May 31 11:59:50 2009 @@ -14,8 +14,8 @@ top_builddir = ../../../.. include $(top_builddir)/src/Makefile.global NAME= ecpg -SO_MAJOR_VERSION= 6 --SO_MINOR_VERSION= 0 +-SO_MINOR_VERSION= 1 +SO_MAJOR_VERSION= ${LIBecpg_MAJOR} +SO_MINOR_VERSION= ${LIBecpg_MINOR} - DLTYPE= library override CPPFLAGS := -I../include -I$(top_srcdir)/src/interfaces/ecpg/include \ + -I$(libpq_srcdir) -I$(top_builddir)/src/port $(CPPFLAGS) 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.4 diff -u -p -r1.4 patch-src_interfaces_ecpg_pgtypeslib_Makefile --- patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile 24 Mar 2008 17:26:12 -0000 1.4 +++ patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile 19 Jun 2009 16:23:40 -0000 @@ -1,14 +1,14 @@ $OpenBSD: patch-src_interfaces_ecpg_pgtypeslib_Makefile,v 1.4 2008/03/24 17:26:12 simon Exp $ ---- 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 +--- src/interfaces/ecpg/pgtypeslib/Makefile.orig Thu Jan 1 18:24:02 2009 ++++ src/interfaces/ecpg/pgtypeslib/Makefile Sun May 31 12:00:20 2009 @@ -14,8 +14,8 @@ top_builddir = ../../../.. include $(top_builddir)/src/Makefile.global NAME= pgtypes -SO_MAJOR_VERSION= 3 --SO_MINOR_VERSION= 0 +-SO_MINOR_VERSION= 1 +SO_MAJOR_VERSION= ${LIBpgtypes_MAJOR} +SO_MINOR_VERSION= ${LIBpgtypes_MINOR} - DLTYPE= library override CPPFLAGS := -I../include -I$(top_srcdir)/src/interfaces/ecpg/include \ + -I$(top_srcdir)/src/include/utils -I$(libpq_srcdir) $(CPPFLAGS) Index: patches/patch-src_interfaces_libpq_Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/patches/patch-src_interfaces_libpq_Makefile,v retrieving revision 1.5 diff -u -p -r1.5 patch-src_interfaces_libpq_Makefile --- patches/patch-src_interfaces_libpq_Makefile 18 Jul 2008 06:57:30 -0000 1.5 +++ patches/patch-src_interfaces_libpq_Makefile 19 Jun 2009 16:23:40 -0000 @@ -1,14 +1,14 @@ $OpenBSD: patch-src_interfaces_libpq_Makefile,v 1.5 2008/07/18 06:57:30 brad Exp $ ---- src/interfaces/libpq/Makefile.orig Wed Apr 16 10:21:22 2008 -+++ src/interfaces/libpq/Makefile Sun Jul 6 22:32:09 2008 +--- src/interfaces/libpq/Makefile.orig Mon Jan 5 10:27:19 2009 ++++ src/interfaces/libpq/Makefile Sun May 31 12:00:52 2009 @@ -16,8 +16,8 @@ include $(top_builddir)/src/Makefile.global # shared library parameters NAME= pq -SO_MAJOR_VERSION= 5 --SO_MINOR_VERSION= 1 +-SO_MINOR_VERSION= 2 +SO_MAJOR_VERSION= ${LIBpq_MAJOR} +SO_MINOR_VERSION= ${LIBpq_MINOR} - DLTYPE= library - override CPPFLAGS := -DFRONTEND -DUNSAFE_STAT_OK -I$(srcdir) $(CPPFLAGS) -I$(top_builddir)/src/port + override CPPFLAGS := -DFRONTEND -DUNSAFE_STAT_OK -I$(srcdir) $(CPPFLAGS) -I$(top_builddir)/src/port -I$(top_srcdir)/src/port + ifneq ($(PORTNAME), win32) Index: pkg/PLIST-contrib =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-contrib,v retrieving revision 1.4 diff -u -p -r1.4 PLIST-contrib --- pkg/PLIST-contrib 18 Jul 2008 06:57:30 -0000 1.4 +++ pkg/PLIST-contrib 19 Jun 2009 16:23:40 -0000 @@ -6,22 +6,25 @@ @bin bin/vacuumlo lib/postgresql/_int.so lib/postgresql/adminpack.so +lib/postgresql/auto_explain.so lib/postgresql/autoinc.so +lib/postgresql/btree_gin.so lib/postgresql/btree_gist.so lib/postgresql/chkpass.so +lib/postgresql/citext.so lib/postgresql/cube.so lib/postgresql/dblink.so lib/postgresql/earthdistance.so lib/postgresql/fuzzystrmatch.so lib/postgresql/hstore.so lib/postgresql/insert_username.so -lib/postgresql/int_aggregate.so lib/postgresql/isn.so lib/postgresql/lo.so lib/postgresql/ltree.so lib/postgresql/moddatetime.so lib/postgresql/pg_buffercache.so lib/postgresql/pg_freespacemap.so +lib/postgresql/pg_stat_statements.so lib/postgresql/pg_trgm.so lib/postgresql/pgcrypto.so lib/postgresql/pgrowlocks.so @@ -38,8 +41,10 @@ share/postgresql/contrib/ share/postgresql/contrib/_int.sql share/postgresql/contrib/adminpack.sql share/postgresql/contrib/autoinc.sql +share/postgresql/contrib/btree_gin.sql share/postgresql/contrib/btree_gist.sql share/postgresql/contrib/chkpass.sql +share/postgresql/contrib/citext.sql share/postgresql/contrib/cube.sql share/postgresql/contrib/dblink.sql share/postgresql/contrib/dict_int.sql @@ -56,6 +61,7 @@ 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_stat_statements.sql share/postgresql/contrib/pg_trgm.sql share/postgresql/contrib/pgcrypto.sql share/postgresql/contrib/pgrowlocks.sql @@ -70,8 +76,10 @@ share/postgresql/contrib/timetravel.sql share/postgresql/contrib/tsearch2.sql share/postgresql/contrib/uninstall__int.sql share/postgresql/contrib/uninstall_adminpack.sql +share/postgresql/contrib/uninstall_btree_gin.sql share/postgresql/contrib/uninstall_btree_gist.sql share/postgresql/contrib/uninstall_chkpass.sql +share/postgresql/contrib/uninstall_citext.sql share/postgresql/contrib/uninstall_cube.sql share/postgresql/contrib/uninstall_dblink.sql share/postgresql/contrib/uninstall_dict_int.sql @@ -86,6 +94,7 @@ share/postgresql/contrib/uninstall_ltree 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_stat_statements.sql share/postgresql/contrib/uninstall_pg_trgm.sql share/postgresql/contrib/uninstall_pgcrypto.sql share/postgresql/contrib/uninstall_pgrowlocks.sql Index: pkg/PLIST-docs =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v retrieving revision 1.40 diff -u -p -r1.40 PLIST-docs --- pkg/PLIST-docs 18 Mar 2009 14:34:10 -0000 1.40 +++ pkg/PLIST-docs 19 Jun 2009 16:23:40 -0000 @@ -1,7 +1,5 @@ @comment $OpenBSD: PLIST-docs,v 1.40 2009/03/18 14:34:10 pea Exp $ share/doc/postgresql/COPYRIGHT -share/doc/postgresql/FAQ -share/doc/postgresql/FAQ_DEV share/doc/postgresql/HISTORY share/doc/postgresql/INSTALL share/doc/postgresql/README @@ -29,7 +27,6 @@ share/doc/postgresql/html/app-droplang.h 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-ipcclean.html share/doc/postgresql/html/app-pg-ctl.html share/doc/postgresql/html/app-pg-dumpall.html share/doc/postgresql/html/app-pgconfig.html @@ -47,6 +44,8 @@ share/doc/postgresql/html/applevel-consi share/doc/postgresql/html/arrays.html share/doc/postgresql/html/auth-methods.html share/doc/postgresql/html/auth-pg-hba-conf.html +share/doc/postgresql/html/auth-username-maps.html +share/doc/postgresql/html/auto-explain.html share/doc/postgresql/html/backup-dump.html share/doc/postgresql/html/backup-file.html share/doc/postgresql/html/backup.html @@ -57,6 +56,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-gin.html share/doc/postgresql/html/btree-gist.html share/doc/postgresql/html/bug-reporting.html share/doc/postgresql/html/catalog-pg-aggregate.html @@ -67,7 +67,6 @@ share/doc/postgresql/html/catalog-pg-att share/doc/postgresql/html/catalog-pg-attribute.html share/doc/postgresql/html/catalog-pg-auth-members.html share/doc/postgresql/html/catalog-pg-authid.html -share/doc/postgresql/html/catalog-pg-autovacuum.html share/doc/postgresql/html/catalog-pg-cast.html share/doc/postgresql/html/catalog-pg-class.html share/doc/postgresql/html/catalog-pg-constraint.html @@ -76,6 +75,8 @@ share/doc/postgresql/html/catalog-pg-dat 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-foreign-data-wrapper.html +share/doc/postgresql/html/catalog-pg-foreign-server.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 @@ -99,10 +100,12 @@ share/doc/postgresql/html/catalog-pg-ts- 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/catalog-pg-user-mapping.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/citext.html share/doc/postgresql/html/client-authentication-problems.html share/doc/postgresql/html/client-authentication.html share/doc/postgresql/html/client-interfaces.html @@ -116,7 +119,6 @@ share/doc/postgresql/html/contrib-dblink 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 @@ -241,6 +243,8 @@ share/doc/postgresql/html/functions-srf. 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-trigger.html +share/doc/postgresql/html/functions-window.html share/doc/postgresql/html/functions-xml.html share/doc/postgresql/html/functions.html share/doc/postgresql/html/fuzzystrmatch.html @@ -303,6 +307,10 @@ share/doc/postgresql/html/infoschema-dom share/doc/postgresql/html/infoschema-domains.html share/doc/postgresql/html/infoschema-element-types.html share/doc/postgresql/html/infoschema-enabled-roles.html +share/doc/postgresql/html/infoschema-foreign-data-wrapper-options.html +share/doc/postgresql/html/infoschema-foreign-data-wrappers.html +share/doc/postgresql/html/infoschema-foreign-server-options.html +share/doc/postgresql/html/infoschema-foreign-servers.html share/doc/postgresql/html/infoschema-information-schema-catalog-name.html share/doc/postgresql/html/infoschema-key-column-usage.html share/doc/postgresql/html/infoschema-parameters.html @@ -328,6 +336,8 @@ share/doc/postgresql/html/infoschema-tab share/doc/postgresql/html/infoschema-tables.html share/doc/postgresql/html/infoschema-triggers.html share/doc/postgresql/html/infoschema-usage-privileges.html +share/doc/postgresql/html/infoschema-user-mapping-options.html +share/doc/postgresql/html/infoschema-user-mappings.html share/doc/postgresql/html/infoschema-view-column-usage.html share/doc/postgresql/html/infoschema-view-routine-usage.html share/doc/postgresql/html/infoschema-view-table-usage.html @@ -341,6 +351,7 @@ share/doc/postgresql/html/install-upgrad 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-platform-notes.html share/doc/postgresql/html/installation.html share/doc/postgresql/html/intagg.html share/doc/postgresql/html/intarray.html @@ -356,6 +367,7 @@ share/doc/postgresql/html/libpq-connect. 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-events.html share/doc/postgresql/html/libpq-example.html share/doc/postgresql/html/libpq-exec.html share/doc/postgresql/html/libpq-fastpath.html @@ -411,6 +423,7 @@ 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/pgstatstatements.html share/doc/postgresql/html/pgstattuple.html share/doc/postgresql/html/pgtrgm.html share/doc/postgresql/html/planner-optimizer.html @@ -470,12 +483,14 @@ share/doc/postgresql/html/queries-select share/doc/postgresql/html/queries-table-expressions.html share/doc/postgresql/html/queries-union.html share/doc/postgresql/html/queries-values.html +share/doc/postgresql/html/queries-with.html share/doc/postgresql/html/queries.html share/doc/postgresql/html/query-path.html share/doc/postgresql/html/querytree.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-coverage.html share/doc/postgresql/html/regress-evaluation.html share/doc/postgresql/html/regress-run.html share/doc/postgresql/html/regress-variant.html @@ -629,6 +644,7 @@ share/doc/postgresql/html/release-8-3-5. share/doc/postgresql/html/release-8-3-6.html share/doc/postgresql/html/release-8-3-7.html share/doc/postgresql/html/release-8-3.html +share/doc/postgresql/html/release-8-4.html share/doc/postgresql/html/release.html share/doc/postgresql/html/resources.html share/doc/postgresql/html/role-attributes.html @@ -679,10 +695,12 @@ share/doc/postgresql/html/spi-spi-cursor share/doc/postgresql/html/spi-spi-cursor-fetch.html share/doc/postgresql/html/spi-spi-cursor-find.html share/doc/postgresql/html/spi-spi-cursor-move.html +share/doc/postgresql/html/spi-spi-cursor-open-with-args.html share/doc/postgresql/html/spi-spi-cursor-open.html share/doc/postgresql/html/spi-spi-exec.html share/doc/postgresql/html/spi-spi-execp.html share/doc/postgresql/html/spi-spi-execute-plan.html +share/doc/postgresql/html/spi-spi-execute-with-args.html share/doc/postgresql/html/spi-spi-execute.html share/doc/postgresql/html/spi-spi-finish.html share/doc/postgresql/html/spi-spi-fname.html @@ -717,6 +735,7 @@ share/doc/postgresql/html/sql-alteraggre share/doc/postgresql/html/sql-alterconversion.html share/doc/postgresql/html/sql-alterdatabase.html share/doc/postgresql/html/sql-alterdomain.html +share/doc/postgresql/html/sql-alterforeigndatawrapper.html share/doc/postgresql/html/sql-alterfunction.html share/doc/postgresql/html/sql-altergroup.html share/doc/postgresql/html/sql-alterindex.html @@ -727,6 +746,7 @@ share/doc/postgresql/html/sql-alteropfam 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-alterserver.html share/doc/postgresql/html/sql-altertable.html share/doc/postgresql/html/sql-altertablespace.html share/doc/postgresql/html/sql-altertrigger.html @@ -736,6 +756,7 @@ share/doc/postgresql/html/sql-altertspar 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-alterusermapping.html share/doc/postgresql/html/sql-alterview.html share/doc/postgresql/html/sql-analyze.html share/doc/postgresql/html/sql-begin.html @@ -753,6 +774,7 @@ share/doc/postgresql/html/sql-createcons share/doc/postgresql/html/sql-createconversion.html share/doc/postgresql/html/sql-createdatabase.html share/doc/postgresql/html/sql-createdomain.html +share/doc/postgresql/html/sql-createforeigndatawrapper.html share/doc/postgresql/html/sql-createfunction.html share/doc/postgresql/html/sql-creategroup.html share/doc/postgresql/html/sql-createindex.html @@ -764,6 +786,7 @@ share/doc/postgresql/html/sql-createrole share/doc/postgresql/html/sql-createrule.html share/doc/postgresql/html/sql-createschema.html share/doc/postgresql/html/sql-createsequence.html +share/doc/postgresql/html/sql-createserver.html share/doc/postgresql/html/sql-createtable.html share/doc/postgresql/html/sql-createtableas.html share/doc/postgresql/html/sql-createtablespace.html @@ -774,6 +797,7 @@ share/doc/postgresql/html/sql-createtspa 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-createusermapping.html share/doc/postgresql/html/sql-createview.html share/doc/postgresql/html/sql-deallocate.html share/doc/postgresql/html/sql-declare.html @@ -785,6 +809,7 @@ share/doc/postgresql/html/sql-dropcast.h share/doc/postgresql/html/sql-dropconversion.html share/doc/postgresql/html/sql-dropdatabase.html share/doc/postgresql/html/sql-dropdomain.html +share/doc/postgresql/html/sql-dropforeigndatawrapper.html share/doc/postgresql/html/sql-dropfunction.html share/doc/postgresql/html/sql-dropgroup.html share/doc/postgresql/html/sql-dropindex.html @@ -796,6 +821,7 @@ share/doc/postgresql/html/sql-droprole.h share/doc/postgresql/html/sql-droprule.html share/doc/postgresql/html/sql-dropschema.html share/doc/postgresql/html/sql-dropsequence.html +share/doc/postgresql/html/sql-dropserver.html share/doc/postgresql/html/sql-droptable.html share/doc/postgresql/html/sql-droptablespace.html share/doc/postgresql/html/sql-droptrigger.html @@ -805,6 +831,7 @@ share/doc/postgresql/html/sql-droptspars 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-dropusermapping.html share/doc/postgresql/html/sql-dropview.html share/doc/postgresql/html/sql-end.html share/doc/postgresql/html/sql-execute.html @@ -851,6 +878,7 @@ share/doc/postgresql/html/ssh-tunnels.ht 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-fsm.html share/doc/postgresql/html/storage-page-layout.html share/doc/postgresql/html/storage-toast.html share/doc/postgresql/html/storage.html @@ -900,6 +928,7 @@ share/doc/postgresql/html/tutorial-table share/doc/postgresql/html/tutorial-transactions.html share/doc/postgresql/html/tutorial-update.html share/doc/postgresql/html/tutorial-views.html +share/doc/postgresql/html/tutorial-window.html share/doc/postgresql/html/tutorial.html share/doc/postgresql/html/typeconv-func.html share/doc/postgresql/html/typeconv-oper.html @@ -926,6 +955,7 @@ share/doc/postgresql/html/view-pg-stats. share/doc/postgresql/html/view-pg-tables.html share/doc/postgresql/html/view-pg-timezone-abbrevs.html share/doc/postgresql/html/view-pg-timezone-names.html +share/doc/postgresql/html/view-pg-user-mappings.html share/doc/postgresql/html/view-pg-user.html share/doc/postgresql/html/view-pg-views.html share/doc/postgresql/html/views-overview.html Index: pkg/PLIST-main =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-main,v retrieving revision 1.13 diff -u -p -r1.13 PLIST-main --- pkg/PLIST-main 7 Feb 2009 16:56:32 -0000 1.13 +++ pkg/PLIST-main 19 Jun 2009 16:23:40 -0000 @@ -39,6 +39,7 @@ include/postgresql/internal/port.h include/postgresql/internal/postgres_fe.h include/postgresql/internal/pqexpbuffer.h include/postgresql/libpq/ +include/postgresql/libpq-events.h include/postgresql/libpq-fe.h include/postgresql/libpq/libpq-fs.h include/postgresql/pg_config.h @@ -99,6 +100,8 @@ lib/postgresql/pgxs/src/test/regress/ @man man/man1/psql.1 @man man/man1/reindexdb.1 @man man/man1/vacuumdb.1 +...@man man/man7/TABLE.7 +...@man man/man7/WITH.7 @man man/man7/abort.7 @man man/man7/alter_aggregate.7 @man man/man7/alter_conversion.7 Index: pkg/PLIST-server =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v retrieving revision 1.15 diff -u -p -r1.15 PLIST-server --- pkg/PLIST-server 18 Jul 2008 06:57:30 -0000 1.15 +++ pkg/PLIST-server 19 Jun 2009 16:23:40 -0000 @@ -7,7 +7,6 @@ @newgroup _postgresql:503 @newuser _postgresql:503:_postgresql:daemon:PostgreSQL Manager:/var/postgresql:/bin/sh @bin bin/initdb -bin/ipcclean @bin bin/pg_controldata @bin bin/pg_ctl @bin bin/pg_resetxlog @@ -39,6 +38,7 @@ include/postgresql/server/access/sdir.h include/postgresql/server/access/skey.h include/postgresql/server/access/slru.h include/postgresql/server/access/subtrans.h +include/postgresql/server/access/sysattr.h include/postgresql/server/access/transam.h include/postgresql/server/access/tupdesc.h include/postgresql/server/access/tupmacs.h @@ -46,6 +46,7 @@ include/postgresql/server/access/tuptoas include/postgresql/server/access/twophase.h include/postgresql/server/access/twophase_rmgr.h include/postgresql/server/access/valid.h +include/postgresql/server/access/visibilitymap.h include/postgresql/server/access/xact.h include/postgresql/server/access/xlog.h include/postgresql/server/access/xlog_internal.h @@ -58,6 +59,7 @@ include/postgresql/server/catalog/ include/postgresql/server/catalog/catalog.h include/postgresql/server/catalog/catversion.h include/postgresql/server/catalog/dependency.h +include/postgresql/server/catalog/genbki.h include/postgresql/server/catalog/heap.h include/postgresql/server/catalog/index.h include/postgresql/server/catalog/indexing.h @@ -70,18 +72,21 @@ include/postgresql/server/catalog/pg_att include/postgresql/server/catalog/pg_attribute.h include/postgresql/server/catalog/pg_auth_members.h include/postgresql/server/catalog/pg_authid.h -include/postgresql/server/catalog/pg_autovacuum.h include/postgresql/server/catalog/pg_cast.h include/postgresql/server/catalog/pg_class.h include/postgresql/server/catalog/pg_constraint.h include/postgresql/server/catalog/pg_control.h include/postgresql/server/catalog/pg_conversion.h +include/postgresql/server/catalog/pg_conversion_fn.h 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_foreign_data_wrapper.h +include/postgresql/server/catalog/pg_foreign_server.h include/postgresql/server/catalog/pg_index.h include/postgresql/server/catalog/pg_inherits.h +include/postgresql/server/catalog/pg_inherits_fn.h include/postgresql/server/catalog/pg_language.h include/postgresql/server/catalog/pg_largeobject.h include/postgresql/server/catalog/pg_listener.h @@ -91,6 +96,7 @@ include/postgresql/server/catalog/pg_ope 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_proc_fn.h include/postgresql/server/catalog/pg_rewrite.h include/postgresql/server/catalog/pg_shdepend.h include/postgresql/server/catalog/pg_shdescription.h @@ -103,6 +109,9 @@ include/postgresql/server/catalog/pg_ts_ 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/pg_type_fn.h +include/postgresql/server/catalog/pg_user_mapping.h +include/postgresql/server/catalog/storage.h include/postgresql/server/catalog/toasting.h include/postgresql/server/commands/ include/postgresql/server/commands/alter.h @@ -145,6 +154,7 @@ include/postgresql/server/executor/nodeB include/postgresql/server/executor/nodeBitmapHeapscan.h include/postgresql/server/executor/nodeBitmapIndexscan.h include/postgresql/server/executor/nodeBitmapOr.h +include/postgresql/server/executor/nodeCtescan.h include/postgresql/server/executor/nodeFunctionscan.h include/postgresql/server/executor/nodeGroup.h include/postgresql/server/executor/nodeHash.h @@ -154,6 +164,7 @@ include/postgresql/server/executor/nodeL include/postgresql/server/executor/nodeMaterial.h include/postgresql/server/executor/nodeMergejoin.h include/postgresql/server/executor/nodeNestloop.h +include/postgresql/server/executor/nodeRecursiveunion.h include/postgresql/server/executor/nodeResult.h include/postgresql/server/executor/nodeSeqscan.h include/postgresql/server/executor/nodeSetOp.h @@ -163,6 +174,8 @@ include/postgresql/server/executor/nodeS include/postgresql/server/executor/nodeTidscan.h include/postgresql/server/executor/nodeUnique.h include/postgresql/server/executor/nodeValuesscan.h +include/postgresql/server/executor/nodeWindowAgg.h +include/postgresql/server/executor/nodeWorktablescan.h include/postgresql/server/executor/spi.h include/postgresql/server/executor/spi_priv.h include/postgresql/server/executor/tstoreReceiver.h @@ -222,6 +235,7 @@ include/postgresql/server/optimizer/geqo include/postgresql/server/optimizer/joininfo.h include/postgresql/server/optimizer/pathnode.h include/postgresql/server/optimizer/paths.h +include/postgresql/server/optimizer/placeholder.h include/postgresql/server/optimizer/plancat.h include/postgresql/server/optimizer/planmain.h include/postgresql/server/optimizer/planner.h @@ -233,12 +247,14 @@ include/postgresql/server/optimizer/tlis include/postgresql/server/optimizer/var.h include/postgresql/server/parser/ include/postgresql/server/parser/analyze.h +include/postgresql/server/parser/gram.h include/postgresql/server/parser/gramparse.h include/postgresql/server/parser/keywords.h -include/postgresql/server/parser/parse.h +include/postgresql/server/parser/kwlist.h include/postgresql/server/parser/parse_agg.h include/postgresql/server/parser/parse_clause.h include/postgresql/server/parser/parse_coerce.h +include/postgresql/server/parser/parse_cte.h include/postgresql/server/parser/parse_expr.h include/postgresql/server/parser/parse_func.h include/postgresql/server/parser/parse_node.h @@ -299,6 +315,8 @@ include/postgresql/server/port/win32.h @comment include/postgresql/server/port/win32_msvc/sys/time.h @comment include/postgresql/server/port/win32_msvc/unistd.h @comment include/postgresql/server/port/win32_msvc/utime.h +include/postgresql/server/portability/ +include/postgresql/server/portability/instr_time.h include/postgresql/server/postgres.h include/postgresql/server/postgres_ext.h include/postgresql/server/postgres_fe.h @@ -369,10 +387,11 @@ include/postgresql/server/storage/bufmgr include/postgresql/server/storage/bufpage.h include/postgresql/server/storage/fd.h include/postgresql/server/storage/freespace.h +include/postgresql/server/storage/fsm_internals.h +include/postgresql/server/storage/indexfsm.h include/postgresql/server/storage/ipc.h include/postgresql/server/storage/item.h include/postgresql/server/storage/itemid.h -include/postgresql/server/storage/itempos.h include/postgresql/server/storage/itemptr.h include/postgresql/server/storage/large_object.h include/postgresql/server/storage/lmgr.h @@ -447,11 +466,14 @@ include/postgresql/server/utils/pg_lzcom include/postgresql/server/utils/pg_rusage.h include/postgresql/server/utils/plancache.h include/postgresql/server/utils/portal.h +include/postgresql/server/utils/probes.h include/postgresql/server/utils/ps_status.h include/postgresql/server/utils/rel.h include/postgresql/server/utils/relcache.h include/postgresql/server/utils/resowner.h include/postgresql/server/utils/selfuncs.h +include/postgresql/server/utils/snapmgr.h +include/postgresql/server/utils/snapshot.h include/postgresql/server/utils/syscache.h include/postgresql/server/utils/timestamp.h include/postgresql/server/utils/tqual.h @@ -462,6 +484,7 @@ include/postgresql/server/utils/tzparser include/postgresql/server/utils/uuid.h include/postgresql/server/utils/varbit.h include/postgresql/server/utils/xml.h +include/postgresql/server/windowapi.h lib/postgresql/ascii_and_mic.so lib/postgresql/cyrillic_and_mic.so lib/postgresql/dict_int.so @@ -496,7 +519,6 @@ lib/postgresql/utf8_and_sjis.so lib/postgresql/utf8_and_uhc.so lib/postgresql/utf8_and_win.so @man man/man1/initdb.1 -...@man man/man1/ipcclean.1 @man man/man1/pg_controldata.1 @man man/man1/pg_ctl.1 @man man/man1/pg_resetxlog.1