Changes 8.2.17:

* 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 possible crash if a cache reset message is received during
  rebuild of a relcache entry
* 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
* Update pl/perl's "ppport.h" for modern Perl versions
* Fix assorted memory leaks in pl/python
* 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 ...)
* 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, 32 insertions, 8 deletions

diff --git a/databases/postgresql82/Makefile.common b/databases/postgresql82/Makefile.common
index 62744b4cbc9..758eefd4949 100644
--- a/databases/postgresql82/Makefile.common
+++ b/databases/postgresql82/Makefile.common
@@ -1,4 +1,12 @@
-# $NetBSD: Makefile.common,v 1.20 2010/04/23 16:03:24 adam Exp $
+# $NetBSD: Makefile.common,v 1.21 2010/05/20 12:36:14 adam Exp $
+#
+# used by databases/postgresql82-adminpack/Makefile
+# used by databases/postgresql82-client/Makefile
+# used by databases/postgresql82-plperl/Makefile
+# used by databases/postgresql82-plpython/Makefile
+# used by databases/postgresql82-pltcl/Makefile
+# used by databases/postgresql82-server/Makefile
+# used by databases/postgresql82-tsearch2/Makefile
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -35,7 +43,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql82/patches
 # DIST_VERS		version number on the postgresql distfile
 # BASE_VERS		pkgsrc-mangled version number (convert pl -> .)
 # Note: Do not forget jdbc-postgresql82 when updating version
-DIST_VERS?=		8.2.16
+DIST_VERS?=		8.2.17
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql82-client+=	postgresql82-client>=${BASE_VERS}
@@ -111,12 +119,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/postgresql82/distinfo b/databases/postgresql82/distinfo
index 48889b505f4..14b00c78674 100644
--- a/databases/postgresql82/distinfo
+++ b/databases/postgresql82/distinfo
@@ -1,11 +1,12 @@
-$NetBSD: distinfo,v 1.19 2010/04/12 09:48:48 adam Exp $
+$NetBSD: distinfo,v 1.20 2010/05/20 12:36:14 adam Exp $
 
-SHA1 (postgresql-8.2.16.tar.bz2) = 092e95438b6db24b65469433439c05dc6435d335
-RMD160 (postgresql-8.2.16.tar.bz2) = 5d3fe8ab522f3f0d744f902b3d31b2eab514e0f4
-Size (postgresql-8.2.16.tar.bz2) = 12637799 bytes
+SHA1 (postgresql-8.2.17.tar.bz2) = 6387d14cc875b9217d89d52d842a1fbdd61ca66d
+RMD160 (postgresql-8.2.17.tar.bz2) = 0e78ae8015c61c9538b7de45703a2b050d99bb50
+Size (postgresql-8.2.17.tar.bz2) = 12714721 bytes
 SHA1 (patch-aa) = 850a02acbd718a01d3597a99e929e3b3f663f07c
 SHA1 (patch-ab) = d09e44921e9dd005e1b1dfbb5da4e56737ea05ab
 SHA1 (patch-ac) = cbd302a60d43171854c37171b57ee7bbf1194ad9
+SHA1 (patch-ad) = fb75df841bbcc25e840ed9c2fed59232d7189200
 SHA1 (patch-af) = 89cb9318946cb7c34ad79dbae107ce66bd1c5022
 SHA1 (patch-ag) = 402d5d211af99efdfa35677299c97e91e14ed85d
 SHA1 (patch-ah) = 3640573195f66a46c37d9fca2648d6be39f5593b
diff --git a/databases/postgresql82/patches/patch-ad b/databases/postgresql82/patches/patch-ad
new file mode 100644
index 00000000000..55dcc56c1bb
--- /dev/null
+++ b/databases/postgresql82/patches/patch-ad
@@ -0,0 +1,15 @@
+$NetBSD: patch-ad,v 1.4 2010/05/20 12:36:14 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) $< $@