Changes 8.4.4:

* Enforce restrictions in plperl using an opmask applied to the whole
  interpreter, instead of using "Safe.pm"
* Prevent PL/Tcl from executing untrustworthy code from pltcl_modules
* Fix data corruption during WAL replay of ALTER ... SET TABLESPACE
* Fix possible crash if a cache reset message is received during
  rebuild of a relcache entry
* Apply per-function GUC settings while running the language
  validator for the function
* Do constraint exclusion for inherited "UPDATE" and "DELETE" target
  tables when constraint_exclusion = partition
* Do not allow an unprivileged user to reset superuser-only parameter
  settings
* Avoid possible crash during backend shutdown if shutdown occurs
  when a CONTEXT addition would be made to log entries
* Fix erroneous handling of %r parameter in recovery_end_command
* Ensure the archiver process responds to changes in archive_command
  as soon as possible
* Fix pl/pgsql's CASE statement to not fail when the case expression
  is a query that returns no rows
* Update pl/perl's "ppport.h" for modern Perl versions
* Fix assorted memory leaks in pl/python
* Handle empty-string connect parameters properly in ecpg
* Prevent infinite recursion in psql when expanding a variable that
  refers to itself
* Fix psql's \copy to not add spaces around a dot within \copy
  (select ...)
* Avoid formatting failure in psql when running in a locale context
  that doesn't match the client_encoding
* Fix unnecessary "GIN indexes do not support whole-index scans"
  errors for unsatisfiable queries using "contrib/intarray" operators
* Ensure that "contrib/pgstattuple" functions respond to cancel
  interrupts promptly
* Make server startup deal properly with the case that shmget()
  returns EINVAL for an existing shared memory segment
* Avoid possible crashes in syslogger process on Windows
* Deal more robustly with incomplete time zone information in the
  Windows registry
* Update the set of known Windows time zone names
* Update time zone data files to tzdata release 2010j for DST law
  changes in Argentina, Australian Antarctic, Bangladesh, Mexico,
  Morocco, Pakistan, Palestine, Russia, Syria, Tunisia; also
  historical corrections for Taiwan.
  Also, add PKST (Pakistan Summer Time) to the default set of
  timezone abbreviations.

3 files changed, 31 insertions, 8 deletions

diff --git a/databases/postgresql84/Makefile.common b/databases/postgresql84/Makefile.common
index cec6063ede1..380fc83079a 100644
--- a/databases/postgresql84/Makefile.common
+++ b/databases/postgresql84/Makefile.common
@@ -1,4 +1,11 @@
-# $NetBSD: Makefile.common,v 1.5 2010/04/23 16:03:24 adam Exp $
+# $NetBSD: Makefile.common,v 1.6 2010/05/20 12:36:38 adam Exp $
+#
+# used by databases/postgresql84-adminpack/Makefile
+# used by databases/postgresql84-client/Makefile
+# used by databases/postgresql84-plperl/Makefile
+# used by databases/postgresql84-plpython/Makefile
+# used by databases/postgresql84-pltcl/Makefile
+# used by databases/postgresql84-server/Makefile
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -35,7 +42,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql84/patches
 # DIST_VERS		version number on the postgresql distfile
 # BASE_VERS		pkgsrc-mangled version number (convert pl -> .)
 # Note: Do not forget jdbc-postgresql84 when updating version
-DIST_VERS?=		8.4.3
+DIST_VERS?=		8.4.4
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql84-client+=	postgresql84-client>=${BASE_VERS}
@@ -105,12 +112,12 @@ FILES_SUBST+=		PG_PREFIX=${PG_PREFIX:Q}
 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])
+.  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
 	${ECHO} "static int dummy = 0;" \
 		> ${WRKSRC}/src/backend/port/dynloader/${PG_TEMPLATE.${OPSYS}:Q}.c
-.endif
+.  endif
 	touch ${WRKSRC}/src/template/dragonfly
 	cp ${WRKSRC}/src/backend/port/dynloader/freebsd.c \
 		${WRKSRC}/src/backend/port/dynloader/dragonfly.c
diff --git a/databases/postgresql84/distinfo b/databases/postgresql84/distinfo
index f0b48042fbd..6e76c64376b 100644
--- a/databases/postgresql84/distinfo
+++ b/databases/postgresql84/distinfo
@@ -1,11 +1,12 @@
-$NetBSD: distinfo,v 1.4 2010/04/12 09:58:38 adam Exp $
+$NetBSD: distinfo,v 1.5 2010/05/20 12:36:38 adam Exp $
 
-SHA1 (postgresql-8.4.3.tar.bz2) = 5edad69e797620c4f27520cb1986bc78c173d67a
-RMD160 (postgresql-8.4.3.tar.bz2) = 4f8bba582138ea8d77059851c361d6f2fb838e52
-Size (postgresql-8.4.3.tar.bz2) = 13645257 bytes
+SHA1 (postgresql-8.4.4.tar.bz2) = 02592977a601976f8bae7bc3a5c69710d4d0344d
+RMD160 (postgresql-8.4.4.tar.bz2) = d2d45112c19a2f20d49ab82bd8f86b6ace7decd3
+Size (postgresql-8.4.4.tar.bz2) = 13853838 bytes
 SHA1 (patch-aa) = aeeeaafb38e75d8e8f6639280e997ba4c905b45f
 SHA1 (patch-ab) = 3cf9c7f0f812d2e41681281538c3f707cec232c3
 SHA1 (patch-ac) = 0b82797d0b80bdd1e9b5f3de4989fe3848adf6cb
+SHA1 (patch-ad) = fb75df841bbcc25e840ed9c2fed59232d7189200
 SHA1 (patch-af) = a73769cf05223d2ee06249c9e69c85038c2cd936
 SHA1 (patch-ag) = 85dac95e40efc16270885087f868aeb76e1b9214
 SHA1 (patch-ah) = 25102dce1b9b22385353af23500636fb18e3bf64
diff --git a/databases/postgresql84/patches/patch-ad b/databases/postgresql84/patches/patch-ad
new file mode 100644
index 00000000000..0a030a20f29
--- /dev/null
+++ b/databases/postgresql84/patches/patch-ad
@@ -0,0 +1,15 @@
+$NetBSD: patch-ad,v 1.3 2010/05/20 12:36:39 adam Exp $
+
+--- src/pl/plperl/GNUmakefile.orig	2010-05-20 07:51:50.000000000 +0000
++++ src/pl/plperl/GNUmakefile
+@@ -53,9 +53,7 @@ PSQLDIR = $(bindir)
+ include $(top_srcdir)/src/Makefile.shlib
+ 
+ 
+-all: all-lib
+-
+-plperl.o: plperl_opmask.h
++all: plperl_opmask.h all-lib
+ 
+ plperl_opmask.h: plperl_opmask.pl
+ 	$(PERL) $< $@