Changes 8.2.7:

* Fix character string comparison for Windows locales that consider
  different character combinations as equal
* Repair potential deadlock between concurrent "VACUUM FULL"
  operations on different system catalogs
* Fix longstanding "LISTEN"/"NOTIFY" race condition
* Disallow "LISTEN" and "UNLISTEN" within a prepared transaction
* Disallow dropping a temporary table within a prepared transaction
* Fix rare crash when an error occurs during a query using a hash
  index
* Fix memory leaks in certain usages of set-returning functions
* Fix input of datetime values for February 29 in years BC
* Fix "unrecognized node type" error in some variants of "ALTER
  OWNER"
* Ensure pg_stat_activity.waiting flag is cleared when a lock wait is
  aborted
* Fix handling of process permissions on Windows Vista
* More...

4 files changed, 19 insertions, 20 deletions

diff --git a/databases/postgresql82/Makefile.common b/databases/postgresql82/Makefile.common
index c390e996f37..e7bb435a4e8 100644
--- a/databases/postgresql82/Makefile.common
+++ b/databases/postgresql82/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.9 2008/03/04 13:31:29 adam Exp $
+# $NetBSD: Makefile.common,v 1.10 2008/04/05 16:40:08 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -36,7 +36,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql82/patches
 #
 # Note: Do not forget jdbc-postgresql82 when updating version
 #
-DIST_VERS?=		8.2.6
+DIST_VERS?=		8.2.7
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql82-client+=	postgresql82-client>=${BASE_VERS}
diff --git a/databases/postgresql82/distinfo b/databases/postgresql82/distinfo
index e8358022d64..9df3bf3e9be 100644
--- a/databases/postgresql82/distinfo
+++ b/databases/postgresql82/distinfo
@@ -1,12 +1,12 @@
-$NetBSD: distinfo,v 1.10 2008/01/07 20:14:36 adam Exp $
+$NetBSD: distinfo,v 1.11 2008/04/05 16:40:08 adam Exp $
 
-SHA1 (postgresql-8.2.6.tar.bz2) = 8934dfbd4c1d8c4f2945cb80f02072611681f967
-RMD160 (postgresql-8.2.6.tar.bz2) = fa12ce310919cb52be3558d38a7e329bc73bbe33
-Size (postgresql-8.2.6.tar.bz2) = 12559117 bytes
+SHA1 (postgresql-8.2.7.tar.bz2) = 0be0dbaa488810ebcba77ac7246180c5b2a9b669
+RMD160 (postgresql-8.2.7.tar.bz2) = 96700e91c3b9e733c686b0fe377c7ba661710942
+Size (postgresql-8.2.7.tar.bz2) = 12576126 bytes
 SHA1 (patch-aa) = a7112ce2e9fc28f638afcf2e196d3cdc0f4c254d
-SHA1 (patch-ab) = d952d47918f0294cdc1462233b1cfd39e3bc2f73
+SHA1 (patch-ab) = 0cd699b7f9ea3e90e2cbf1a8e516dc224ee3b5f7
 SHA1 (patch-ac) = cbd302a60d43171854c37171b57ee7bbf1194ad9
-SHA1 (patch-ad) = ce322ef8b279e1e25b4ed018ab975a25e82a69a1
+SHA1 (patch-ad) = 84ce70fa661b44f267a502ea73fe01b84776c91c
 SHA1 (patch-ae) = 8b3e47320dfe05d94b769c9b079fd7ca6d26f5d6
 SHA1 (patch-af) = 89cb9318946cb7c34ad79dbae107ce66bd1c5022
 SHA1 (patch-ag) = 402d5d211af99efdfa35677299c97e91e14ed85d
diff --git a/databases/postgresql82/patches/patch-ab b/databases/postgresql82/patches/patch-ab
index 63e3f22c29d..362b64e54a9 100644
--- a/databases/postgresql82/patches/patch-ab
+++ b/databases/postgresql82/patches/patch-ab
@@ -1,6 +1,6 @@
-$NetBSD: patch-ab,v 1.2 2007/10/09 20:17:08 adam Exp $
+$NetBSD: patch-ab,v 1.3 2008/04/05 16:40:08 adam Exp $
 
---- configure.orig	2007-10-09 22:07:59.000000000 +0200
+--- configure.orig	2008-03-14 04:30:53.000000000 +0100
 +++ configure
 @@ -1504,6 +1504,7 @@ case $host_os in
    darwin*) template=darwin ;;
@@ -10,7 +10,7 @@ $NetBSD: patch-ab,v 1.2 2007/10/09 20:17:08 adam Exp $
      hpux*) template=hpux ;;
      irix*) template=irix ;;
   linux*|gnu*|k*bsd*-gnu)
-@@ -4899,9 +4900,7 @@ echo "${ECHO_T}$perl_useshrplib" >&6
+@@ -4953,9 +4954,7 @@ echo "${ECHO_T}$perl_useshrplib" >&6
  
  echo "$as_me:$LINENO: checking for flags to link embedded Perl" >&5
  echo $ECHO_N "checking for flags to link embedded Perl... $ECHO_C" >&6
@@ -21,7 +21,7 @@ $NetBSD: patch-ab,v 1.2 2007/10/09 20:17:08 adam Exp $
  echo "$as_me:$LINENO: result: $perl_embed_ldflags" >&5
  echo "${ECHO_T}$perl_embed_ldflags" >&6
  fi
-@@ -21910,16 +21909,12 @@ cat >>conftest.$ac_ext <<_ACEOF
+@@ -22087,16 +22086,12 @@ cat >>conftest.$ac_ext <<_ACEOF
  /* end confdefs.h.  */
  
  /* Override any gcc2 internal prototype to avoid an error.  */
@@ -41,7 +41,7 @@ $NetBSD: patch-ab,v 1.2 2007/10/09 20:17:08 adam Exp $
    ;
    return 0;
  }
-@@ -21965,16 +21960,12 @@ cat >>conftest.$ac_ext <<_ACEOF
+@@ -22142,16 +22137,12 @@ cat >>conftest.$ac_ext <<_ACEOF
  /* end confdefs.h.  */
  
  /* Override any gcc2 internal prototype to avoid an error.  */
diff --git a/databases/postgresql82/patches/patch-ad b/databases/postgresql82/patches/patch-ad
index f44ecac0695..46fd11c5049 100644
--- a/databases/postgresql82/patches/patch-ad
+++ b/databases/postgresql82/patches/patch-ad
@@ -1,8 +1,8 @@
-$NetBSD: patch-ad,v 1.1.1.1 2006/12/09 15:34:13 adam Exp $
+$NetBSD: patch-ad,v 1.2 2008/04/05 16:40:08 adam Exp $
 
---- src/backend/port/dynloader/netbsd.c.orig	2006-03-11 05:38:31.000000000 +0100
+--- src/backend/port/dynloader/netbsd.c.orig	2008-04-05 11:33:08.000000000 +0200
 +++ src/backend/port/dynloader/netbsd.c
-@@ -46,65 +46,30 @@ static char sccsid[] = "@(#)dl.c	5.4 (Be
+@@ -46,64 +46,30 @@ static char sccsid[] = "@(#)dl.c	5.4 (Be
  
  #include "dynloader.h"
  
@@ -25,7 +25,7 @@ $NetBSD: patch-ad,v 1.1.1.1 2006/12/09 15:34:13 adam Exp $
 -BSD44_derived_dlopen(const char *file, int num)
 +pg_dlopen(const char *file, int num)
  {
--#if defined(__mips__)
+-#if !defined(HAVE_DLOPEN)
 -	snprintf(error_message, sizeof(error_message),
 -			 "dlopen (%s) not supported", file);
 +	elog(ERROR, "dynamic load not supported");
@@ -44,7 +44,7 @@ $NetBSD: patch-ad,v 1.1.1.1 2006/12/09 15:34:13 adam Exp $
 -BSD44_derived_dlsym(void *handle, const char *name)
 +pg_dlsym(void *handle, const char *name)
  {
--#if defined(__mips__)
+-#if !defined(HAVE_DLOPEN)
 -	snprintf(error_message, sizeof(error_message),
 -			 "dlsym (%s) failed", name);
  	return NULL;
@@ -70,8 +70,7 @@ $NetBSD: patch-ad,v 1.1.1.1 2006/12/09 15:34:13 adam Exp $
 -BSD44_derived_dlclose(void *handle)
 +pg_dlclose(void *handle)
  {
--#if defined(__mips__)
--#else
+-#if defined(HAVE_DLOPEN)
 -	dlclose(handle);
 -#endif
  }