Changes 8.3.14:

* 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 pg_restore's text output for large objects (BLOBs) when
  standard_conforming_strings is on.
* 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, 278 deletions

diff --git a/databases/postgresql83/Makefile.common b/databases/postgresql83/Makefile.common
index d0dce1f0306..d5a0d7c6400 100644
--- a/databases/postgresql83/Makefile.common
+++ b/databases/postgresql83/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.16 2010/12/19 09:53:52 adam Exp $
+# $NetBSD: Makefile.common,v 1.17 2011/02/15 09:06:31 adam Exp $
 #
 # used by databases/postgresql83-adminpack/Makefile
 # used by databases/postgresql83-client/Makefile
@@ -17,7 +17,7 @@
 
 .include "../../databases/postgresql83/Makefile.mirrors"
 
-DISTNAME=	postgresql-8.3.13
+DISTNAME=	postgresql-8.3.14
 CATEGORIES=	databases
 MASTER_SITES=	${PGSQL_MIRRORS:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
@@ -59,11 +59,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
-
 # PostgreSQL explicitly forbids any use of -ffast-math
 BUILDLINK_TRANSFORM+=	rm:-ffast-math
 
@@ -78,8 +73,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/postgresql83/distinfo b/databases/postgresql83/distinfo
index a6d73328b03..95efe3fd480 100644
--- a/databases/postgresql83/distinfo
+++ b/databases/postgresql83/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.14 2010/12/19 09:53:52 adam Exp $
+$NetBSD: distinfo,v 1.15 2011/02/15 09:06:32 adam Exp $
 
-SHA1 (postgresql-8.3.13.tar.bz2) = 59236fc88ede4aa756970e53575a50233ebb6c19
-RMD160 (postgresql-8.3.13.tar.bz2) = 029c77475a3412f10596fd36c85437233597b63c
-Size (postgresql-8.3.13.tar.bz2) = 14337117 bytes
+SHA1 (postgresql-8.3.14.tar.bz2) = aec29d9be73e90b88b2d1d5eadff8fffc5681e59
+RMD160 (postgresql-8.3.14.tar.bz2) = 353996ca82141186f67d59a8ae37b91586413807
+Size (postgresql-8.3.14.tar.bz2) = 14345092 bytes
 SHA1 (patch-aa) = aeeeaafb38e75d8e8f6639280e997ba4c905b45f
 SHA1 (patch-ab) = 7bf5635b0b93c3c0d33acd4e122e102c92ce7b76
 SHA1 (patch-ac) = 8e3a7021fdd01810d4ebcbd20002b28164b22279
@@ -12,4 +12,3 @@ SHA1 (patch-ag) = 402d5d211af99efdfa35677299c97e91e14ed85d
 SHA1 (patch-ah) = 3640573195f66a46c37d9fca2648d6be39f5593b
 SHA1 (patch-ai) = a2364b8e1e8a3094e1c5bfb0cad2d0babe0a8841
 SHA1 (patch-aj) = c389f9b8f39ddb61e58b5fe87ffabb789c71d4e0
-SHA1 (patch-an) = 5981ccab104dd12f1b9baab8ca6c0ff32f873897
diff --git a/databases/postgresql83/files/Makefile.custom b/databases/postgresql83/files/Makefile.custom
deleted file mode 100644
index c6913ff1f4d..00000000000
--- a/databases/postgresql83/files/Makefile.custom
+++ /dev/null
@@ -1,42 +0,0 @@
-# $NetBSD: Makefile.custom,v 1.1.1.1 2008/03/04 12:41:36 adam 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
-
-# Override installation paths to avoid logic in Makefile.global.
-includedir = $(prefix)/include
-libdir = $(exec_prefix)/lib
-pkglibdir = $(libdir)/postgresql
-pkgincludedir = $(includedir)/postgresql
-
-# 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/postgresql83/files/Makefile.libtool b/databases/postgresql83/files/Makefile.libtool
deleted file mode 100644
index 8905fd7bff5..00000000000
--- a/databases/postgresql83/files/Makefile.libtool
+++ /dev/null
@@ -1,141 +0,0 @@
-#-------------------------------------------------------------------------
-#
-# Makefile.libtool
-#    Common rules for buildling libtool archives
-#
-# IDENTIFICATION
-#    $NetBSD: Makefile.libtool,v 1.2 2010/01/21 12:45:28 adam Exp $
-#
-#-------------------------------------------------------------------------
-
-##
-## Hacks/workarounds for makefiles in certain directories
-##
-
-# The following directories are building loadable shared modules, not
-# shared libraries.
-#
-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/adminpack,$(subdir)))
-shmodule	= yes
-else
-shmodule	= no
-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
-
-ifeq ($(subdir), src/pl/plpgsql/src)
-pl_gram.lo pl_handler.lo pl_comp.lo pl_exec.lo pl_funcs.lo: plpgsql.h
-pl_gram.lo: $(srcdir)/pl_scan.c
-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)
-	$(mkinstalldirs) '$(DESTDIR)$(pkglibdir)'
-else
-	$(mkinstalldirs) '$(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/postgresql83/options.mk b/databases/postgresql83/options.mk
index 9e7aeaba67f..b1e256e3b4c 100644
--- a/databases/postgresql83/options.mk
+++ b/databases/postgresql83/options.mk
@@ -1,11 +1,22 @@
-# $NetBSD: options.mk,v 1.5 2010/12/19 09:53:52 adam Exp $
+# $NetBSD: options.mk,v 1.6 2011/02/15 09:06:32 adam Exp $
 
 PKG_OPTIONS_VAR=	PKG_OPTIONS.postgresql83
-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/postgresql83/patches/patch-aj b/databases/postgresql83/patches/patch-aj
deleted file mode 100644
index e4f50e1cac8..00000000000
--- a/databases/postgresql83/patches/patch-aj
+++ /dev/null
@@ -1,66 +0,0 @@
-$NetBSD: patch-aj,v 1.2 2010/01/21 12:45:28 adam Exp $
-
---- src/makefiles/pgxs.mk	2010-01-21 12:58:01.000000000 +0100
-+++ src/makefiles/pgxs.mk.orig	2010-01-18 10:08:33.000000000 +0100
-@@ -121,9 +117,6 @@
- ifdef PROGRAM
- 	$(INSTALL_PROGRAM) $(PROGRAM)$(X) '$(DESTDIR)$(bindir)'
- endif # PROGRAM
--ifdef MODULE_big
--	$(INSTALL_SHLIB) $(shlib) '$(DESTDIR)$(pkglibdir)/$(MODULE_big)$(DLSUFFIX)'
--endif # MODULE_big
- ifdef SCRIPTS
- 	@for file in $(addprefix $(srcdir)/, $(SCRIPTS)); do \
- 	  echo "$(INSTALL_SCRIPT) $$file '$(DESTDIR)$(bindir)'"; \
-@@ -137,6 +130,10 @@
- 	done
- endif # SCRIPTS_built
- 
-+ifdef MODULE_big
-+install: install-lib
-+endif # MODULE_big
-+
- 
- installdirs:
- ifneq (,$(DATA)$(DATA_built))
-@@ -145,7 +142,7 @@
- ifneq (,$(DATA_TSEARCH))
- 	$(mkinstalldirs) '$(DESTDIR)$(datadir)/tsearch_data'
- endif
--ifneq (,$(MODULES)$(MODULE_big))
-+ifneq (,$(MODULES))
- 	$(mkinstalldirs) '$(DESTDIR)$(pkglibdir)'
- endif
- ifdef DOCS
-@@ -157,6 +154,10 @@
- 	$(mkinstalldirs) '$(DESTDIR)$(bindir)'
- endif
- 
-+ifdef MODULE_big
-+installdirs: installdirs-lib
-+endif # MODULE_big
-+
- 
- uninstall:
- ifneq (,$(DATA)$(DATA_built))
-@@ -174,9 +175,6 @@
- ifdef PROGRAM
- 	rm -f '$(DESTDIR)$(bindir)/$(PROGRAM)$(X)'
- endif
--ifdef MODULE_big
--	rm -f '$(DESTDIR)$(pkglibdir)/$(MODULE_big)$(DLSUFFIX)'
--endif
- ifdef SCRIPTS
- 	rm -f $(addprefix '$(DESTDIR)$(bindir)'/, $(SCRIPTS))
- endif
-@@ -184,6 +182,10 @@
- 	rm -f $(addprefix '$(DESTDIR)$(bindir)'/, $(SCRIPTS_built))
- endif
- 
-+ifdef MODULE_big
-+uninstall: uninstall-lib
-+endif # MODULE_big
-+
- 
- clean:
- ifdef MODULES
diff --git a/databases/postgresql83/patches/patch-an b/databases/postgresql83/patches/patch-an
deleted file mode 100644
index cdf24fcad1b..00000000000
--- a/databases/postgresql83/patches/patch-an
+++ /dev/null
@@ -1,13 +0,0 @@
-$NetBSD: patch-an,v 1.2 2010/12/19 09:53:53 adam Exp $
-
---- src/interfaces/ecpg/test/Makefile.regress.orig	2010-12-14 03:51:20.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) $(LIBS) -o $@
-+	${LIBTOOL} --mode=link $(CC) $(CPPFLAGS) $(CFLAGS) $*.o $(LDFLAGS) $(LIBS) -o $@
- 
- %.c: %.pgc ../regression.h
- 	$(ECPG) -o $@ -I$(srcdir) $<