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
