Changes 9.0.3:

* Before exiting walreceiver, ensure all the received WAL is fsync'd to disk
* Avoid excess fsync activity in walreceiver
* Make "ALTER TABLE" revalidate uniqueness and exclusion constraints when needed
* Fix EvalPlanQual for "UPDATE" of an inheritance tree in which the tables are
  not all alike
* Avoid failures when "EXPLAIN" tries to display a simple-form CASE expression
* Fix assignment to an array slice that is before the existing range of
  subscripts
* Avoid unexpected conversion overflow in planner for very distant date values
* Fix PL/Python crash when an array contains null entries
* Remove ecpg's fixed length limit for constants defining an array dimension
* Fix erroneous parsing of tsquery values containing ... &
  !(subexpression) | ...
* Fix buffer overrun in "contrib/intarray"'s input function for the query_int
  type
* Fix bug in "contrib/seg"'s GiST picksplit algorithm

7 files changed, 19 insertions, 221 deletions

diff --git a/databases/postgresql90/Makefile.common b/databases/postgresql90/Makefile.common
index de690f09161..16a918854ce 100644
--- a/databases/postgresql90/Makefile.common
+++ b/databases/postgresql90/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.8 2010/12/24 06:30:03 asau Exp $
+# $NetBSD: Makefile.common,v 1.9 2011/02/09 08:48:16 adam Exp $
 #
 # used by databases/postgresql90-adminpack/Makefile
 # used by databases/postgresql90-client/Makefile
@@ -22,7 +22,7 @@
 
 .include "../../databases/postgresql90/Makefile.mirrors"
 
-DISTNAME=	postgresql-9.0.2
+DISTNAME=	postgresql-9.0.3
 CATEGORIES=	databases
 MASTER_SITES=	${PGSQL_MIRRORS:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
@@ -82,11 +82,6 @@ CONFIGURE_ARGS+=	--without-readline
 CONFIGURE_ARGS+=	--without-tcl
 CONFIGURE_ARGS+=	--without-zlib
 
-# Enable Bonjour on Mac OS X
-.if ${OPSYS} == "Darwin"
-CONFIGURE_ARGS+=	--with-bonjour
-.endif
-
 # PGSQL_BLCKSZ is the size in bytes of a PostgreSQL disk page or block.
 # This also limits the size of a tuple.  The valid values are powers
 # of 2 up to 32768, and the default size is 8196.  Please don't change
@@ -110,8 +105,6 @@ USE_LIBLTDL?=		no
 
 .if !defined(META_PACKAGE)
 post-extract:
-	cp -f ${COMMON_FILESDIR}/Makefile.custom ${WRKSRC}/src/Makefile.custom
-	cp -f ${COMMON_FILESDIR}/Makefile.libtool ${WRKSRC}/src/Makefile.shlib
 .  if !empty(USE_LIBLTDL:M[yY][eE][sS])
 	cp -f ${COMMON_FILESDIR}/dynloader-ltdl.h \
 		${WRKSRC}/src/backend/port/dynloader/${PG_TEMPLATE.${OPSYS}:Q}.h
diff --git a/databases/postgresql90/distinfo b/databases/postgresql90/distinfo
index 6f421a4430b..65b08189fa8 100644
--- a/databases/postgresql90/distinfo
+++ b/databases/postgresql90/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.3 2010/12/19 09:53:27 adam Exp $
+$NetBSD: distinfo,v 1.4 2011/02/09 08:48:17 adam Exp $
 
-SHA1 (postgresql-9.0.2.tar.bz2) = 42a9518a2f11fa1d09a23bc628b00e992d3bcf4a
-RMD160 (postgresql-9.0.2.tar.bz2) = 3313b4bafe3af6282f68f198da7d50af4d5c01c4
-Size (postgresql-9.0.2.tar.bz2) = 14024244 bytes
+SHA1 (postgresql-9.0.3.tar.bz2) = ea7b4729427f668cbf36184efbc58fd828a2d3ab
+RMD160 (postgresql-9.0.3.tar.bz2) = 9f5e0584018265282a75be8597fb7ac51ccaa23a
+Size (postgresql-9.0.3.tar.bz2) = 14040705 bytes
 SHA1 (patch-aa) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0
 SHA1 (patch-ab) = 6adfc53e325abe69582f1c7971f56144c697e9c1
 SHA1 (patch-ac) = 76ddd3015d93b19cdd6000eaffc4f53cbd4965b5
diff --git a/databases/postgresql90/files/Makefile.custom b/databases/postgresql90/files/Makefile.custom
deleted file mode 100644
index 675f0bf4afb..00000000000
--- a/databases/postgresql90/files/Makefile.custom
+++ /dev/null
@@ -1,36 +0,0 @@
-# $NetBSD: Makefile.custom,v 1.2 2010/12/24 03:41:38 asau Exp $
-#
-# This file is included at the end of Makefile.global, which is included
-# by every sub-Makefile in the build tree.  Makefiles for shared
-# libraries include Makefile.global then Makefile.shlib.
-#
-
-# Override any OS-specific locations for where to put SQL man pages.
-sqlmansect = 7
-
-# INSTALLED_LIBPQ is passed in from the environment and tells the build
-# system how to link to an installed libpq.*.
-#
-ifdef INSTALLED_LIBPQ
-libpq = -lpq
-else
-ifdef LIBTOOL
-libpq = $(libpq_builddir)/libpq.la
-endif
-ifdef PGFILEDESC
-libpq = -L$(libpq_builddir)/.libs -lpq
-endif
-endif
-
-# In pkgsrc, libpython is always present as a shared library.
-shared_libpython = yes
-
-# $(libpq_builddir)/libpq.a is used in several places as a dependency,
-# but if we're building with libtool, then we don't actually want to
-# create that file since it will mess up the re-linking process.
-# Declare it to be phony to prevent GNU make from thinking it's a
-# target.
-#
-ifdef LIBTOOL
-.PHONY: $(libpq_builddir)/libpq.a
-endif
diff --git a/databases/postgresql90/files/Makefile.libtool b/databases/postgresql90/files/Makefile.libtool
deleted file mode 100644
index ac41902d7db..00000000000
--- a/databases/postgresql90/files/Makefile.libtool
+++ /dev/null
@@ -1,140 +0,0 @@
-#-------------------------------------------------------------------------
-#
-# Makefile.libtool
-#    Common rules for buildling libtool archives
-#
-# IDENTIFICATION
-#    $NetBSD: Makefile.libtool,v 1.3 2010/12/11 17:15:24 asau Exp $
-#
-#-------------------------------------------------------------------------
-
-##
-## Hacks/workarounds for makefiles in certain directories
-##
-
-# The following directories are building loadable shared modules, not
-# shared libraries.
-#
-ifneq (,$(findstring src/backend/replication/libpqwalreceiver,$(subdir)))
-shmodule	= yes
-else
-ifneq (,$(findstring src/backend/utils/mb/conversion_procs/,$(subdir)))
-shmodule	= yes
-else
-ifneq (,$(findstring src/backend/snowball,$(subdir)))
-shmodule	= yes
-else
-ifneq (,$(findstring src/pl/,$(subdir)))
-shmodule	= yes
-else
-ifneq (,$(findstring contrib/,$(subdir)))
-shmodule	= yes
-else
-shmodule	= no
-endif
-endif
-endif
-endif
-endif
-
-# Fix dependencies in some makefiles that assume the target matches
-# %.o so that when built for libtool, the target matches the corresponding
-# %.lo.
-#
-ifeq ($(subdir), src/interfaces/ecpg/ecpglib)
-path.lo: path.c $(top_builddir)/src/port/pg_config_paths.h
-endif
-
-ifeq ($(subdir), src/interfaces/libpq)
-fe-connect.lo: fe-connect.c $(top_builddir)/src/port/pg_config_paths.h
-endif
-
-
-##
-## VARIABLE DEFINITIONS
-##
-
-# Loadable shared modules are named differently from shared libraries
-# and are installed into $(pkglibdir).
-#
-ifeq ($(shmodule),yes)
-ltlib		= $(NAME)$(DLSUFFIX)
-ltmodule	= -module
-rpathdir	= $(pkglibdir)
-else
-ltlib		= lib$(NAME)$(DLSUFFIX)
-ltmodule	=
-endif
-
-DLSUFFIX	= .la
-SO_MAJOR_VERSION?=0
-SO_MINOR_VERSION?=0
-
-LTCOMPILE	= $(LIBTOOL) --mode=compile $(CC) $(CFLAGS) $(CPPFLAGS)
-LTLINK		= $(LIBTOOL) --mode=link $(CC) $(LDFLAGS) $(ltmodule) -rpath $(rpathdir) -version-info $(SO_MAJOR_VERSION):$(SO_MINOR_VERSION)
-LTOBJS		= $(OBJS:%.o=%.lo)
-
-# Define INSTALL_SHLIB and shlib for the benefit of Makefiles for
-# loadable modules that have their own target for installing the
-# module.
-#
-INSTALL_LTLIB	= $(LIBTOOL) --mode=install $(INSTALL)
-INSTALL_STLIB	= $(INSTALL_LTLIB)
-INSTALL_SHLIB	= $(INSTALL_LTLIB)
-shlib		= $(ltlib)
-
-%.lo : %.c
-	$(LTCOMPILE) -c $< -o $@
-
-
-##
-## BUILD
-##
-
-.PHONY: all-lib all-static-lib all-shared-lib all-la-lib
-all-lib all-static-lib all-shared-lib: all-la-lib
-
-all-la-lib: $(ltlib)
-
-$(ltlib): $(LTOBJS)
-	$(LTLINK) -o $@ $(LTOBJS) $(SHLIB_LINK)
-
-
-##
-## INSTALL
-##
-
-.PHONY: install-lib install-lib-static install-lib-shared installdirs-lib install-lib-la
-install-lib install-static-lib install-shared-lib: install-lib-la
-
-install-lib-la: $(ltlib)
-ifeq ($(shmodule),yes)
-	$(INSTALL_LTLIB) $< $(DESTDIR)$(pkglibdir)/$(shlib)
-else
-	$(INSTALL_LTLIB) $< $(DESTDIR)$(libdir)/$(ltlib)
-endif
-
-installdirs-lib:
-ifeq ($(shmodule),yes)
-	$(MKDIR_P) '$(DESTDIR)$(pkglibdir)'
-else
-	$(MKDIR_P) '$(DESTDIR)$(libdir)'
-endif
-
-
-##
-## UNINSTALL
-##
-
-.PHONY: uninstall-lib
-uninstall-lib:
-	$(LIBTOOL) --mode=uninstall rm -f $(DESTDIR)$(libdir)/$(ltlib)
-
-
-##
-## CLEAN
-##
-
-.PHONY: clean-lib
-clean-lib:
-	$(LIBTOOL) --mode=clean rm -f $(ltlib) $(LTOBJS)
diff --git a/databases/postgresql90/options.mk b/databases/postgresql90/options.mk
index 1a42d82ae1e..11b7d298515 100644
--- a/databases/postgresql90/options.mk
+++ b/databases/postgresql90/options.mk
@@ -1,11 +1,22 @@
-# $NetBSD: options.mk,v 1.4 2010/12/19 09:53:27 adam Exp $
+# $NetBSD: options.mk,v 1.5 2011/02/09 08:48:17 adam Exp $
 
 PKG_OPTIONS_VAR=	PKG_OPTIONS.postgresql90
-PKG_SUPPORTED_OPTIONS=	gssapi kerberos ldap pam xml
+PKG_SUPPORTED_OPTIONS=	bonjour gssapi kerberos ldap pam xml
 
 .include "../../mk/bsd.options.mk"
 
 ###
+### Bonjour support.
+###
+.if !empty(PKG_OPTIONS:Mbonjour)
+CONFIGURE_ARGS+=	--with-bonjour
+.  if ${OPSYS} != "Darwin"
+LIBS+=			-ldns_sd
+.  endif
+.  include "../../net/mDNSResponder/buildlink3.mk"
+.endif
+
+###
 ### GSSAPI authentication for the PostgreSQL backend.
 ###
 .if !empty(PKG_OPTIONS:Mgssapi)
diff --git a/databases/postgresql90/patches/patch-ae b/databases/postgresql90/patches/patch-ae
deleted file mode 100644
index 945bd98f230..00000000000
--- a/databases/postgresql90/patches/patch-ae
+++ /dev/null
@@ -1,17 +0,0 @@
-$NetBSD: patch-ae,v 1.1 2010/12/19 09:53:27 adam Exp $
-
---- src/makefiles/Makefile.darwin.orig	2010-12-17 18:28:46.000000000 +0000
-+++ src/makefiles/Makefile.darwin
-@@ -2,11 +2,7 @@ AROPT = crs
-  
- DLSUFFIX = .so
- 
--ifdef PGXS
--  BE_DLLLIBS = -bundle_loader $(bindir)/postgres
--else
--  BE_DLLLIBS = -bundle_loader $(top_builddir)/src/backend/postgres
--endif
-+BE_DLLLIBS = -bundle_loader $(bindir)/postgres
- 
- # Rule for building a shared library from a single .o file
- %.so: %.o
diff --git a/databases/postgresql90/patches/patch-an b/databases/postgresql90/patches/patch-an
deleted file mode 100644
index 902c36da53f..00000000000
--- a/databases/postgresql90/patches/patch-an
+++ /dev/null
@@ -1,13 +0,0 @@
-$NetBSD: patch-an,v 1.2 2010/12/19 09:53:27 adam Exp $
-
---- src/interfaces/ecpg/test/Makefile.regress.orig	2010-12-14 02:55:50.000000000 +0000
-+++ src/interfaces/ecpg/test/Makefile.regress
-@@ -9,7 +9,7 @@ ECPG = ../../preproc/ecpg --regression -
- 
- %: %.c
- 	$(CC) $(CPPFLAGS) $(CFLAGS) -c $< -o $*.o
--	$(CC) $(CPPFLAGS) $(CFLAGS) $*.o $(LDFLAGS) $(LDFLAGS_EX) $(LIBS) -o $@
-+	${LIBTOOL} --mode=link $(CC) $(CPPFLAGS) $(CFLAGS) $*.o $(LDFLAGS) $(LDFLAGS_EX) $(LIBS) -o $@
- 
- %.c: %.pgc ../regression.h
- 	$(ECPG) -o $@ -I$(srcdir) $<