Changes 8.2.11:

* Fix GiST index corruption due to marking the wrong index entry
  "dead" after a deletion.
  This would result in index searches failing to find rows they
  should have found.
* Fix backend crash when the client encoding cannot represent a
  localized error message.
  We have addressed similar issues before, but it would still fail if
  the "character has no equivalent" message itself couldn't be
  converted. The fix is to disable localization and send the plain
  ASCII error message when we detect such a situation.
* Fix possible crash when deeply nested functions are invoked from a
  trigger.
* Improve optimization of "expression" IN ("expression-list") queries.
  Cases in which there are query variables on the right-hand side had
  been handled less efficiently in 8.2.x and 8.3.x than in prior
  versions. The fix restores 8.1 behavior for such cases.
* Fix mis-expansion of rule queries when a sub-SELECT appears in a
  function call in FROM, a multi-row VALUES list, or a RETURNING list.
* Fix memory leak during rescan of a hashed aggregation plan.
* Ensure an error is reported when a newly-defined PL/pgSQL trigger
  function is invoked as a normal function.
* Prevent possible collision of relfilenode numbers when moving a
  table to another tablespace with "ALTER SET TABLESPACE".
  The command tried to re-use the existing filename, instead of
  picking one that is known unused in the destination directory.
* Fix incorrect tsearch2 headline generation when single query item
  matches first word of text.
* Fix improper display of fractional seconds in interval values when
  using a non-ISO datestyle in an "--enable-integer-datetimes" build.
* Ensure SPI_getvalue and SPI_getbinval behave correctly when the
  passed tuple and tuple descriptor have different numbers of columns.
* Fix ecpg's parsing of "CREATE ROLE".
* Fix recent breakage of pg_ctl restart.
* Ensure "pg_control" is opened in binary mode.
  pg_controldata and pg_resetxlog did this incorrectly, and so could
  fail on Windows.
* Update time zone data files to tzdata release 2008i (for DST law
  changes in Argentina, Brazil, Mauritius, Syria)

5 files changed, 14 insertions, 10 deletions

diff --git a/databases/postgresql82-client/PLIST b/databases/postgresql82-client/PLIST
index 164aae9ee29..ad92dd90b47 100644
--- a/databases/postgresql82-client/PLIST
+++ b/databases/postgresql82-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.10 2008/10/06 09:45:55 adam Exp $
+@comment $NetBSD: PLIST,v 1.11 2008/11/04 09:52:39 adam Exp $
 ${PG_SUBPREFIX}${PKGLOCALEDIR}/locale/af/LC_MESSAGES/libpq.mo
 ${PG_SUBPREFIX}${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/initdb.mo
 ${PG_SUBPREFIX}${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/libpq.mo
@@ -1198,6 +1198,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-19.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-20.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-21.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-22.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-23.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-4.html
@@ -1217,6 +1218,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-15.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-16.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-17.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-18.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-19.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-4.html
@@ -1232,6 +1234,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-11.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-12.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-13.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-14.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-15.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-4.html
@@ -1244,6 +1247,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-1.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-10.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-11.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-4.html
diff --git a/databases/postgresql82-plperl/Makefile b/databases/postgresql82-plperl/Makefile
index e2e06d317fb..3cbc72d321d 100644
--- a/databases/postgresql82-plperl/Makefile
+++ b/databases/postgresql82-plperl/Makefile
@@ -1,8 +1,7 @@
-# $NetBSD: Makefile,v 1.7 2008/10/19 19:17:46 he Exp $
+# $NetBSD: Makefile,v 1.8 2008/11/04 09:52:39 adam Exp $
 
 PKGNAME=	postgresql82-plperl-${BASE_VERS}
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
-PKGREVISION=	1
 
 DEPENDS+=	postgresql82-server>=${BASE_VERS}:../../databases/postgresql82-server
 
diff --git a/databases/postgresql82-server/PLIST b/databases/postgresql82-server/PLIST
index 545f9b7546b..1ef8deff02c 100644
--- a/databases/postgresql82-server/PLIST
+++ b/databases/postgresql82-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.7 2008/10/06 09:45:56 adam Exp $
+@comment $NetBSD: PLIST,v 1.8 2008/11/04 09:52:39 adam Exp $
 ${PG_SUBPREFIX}bin/postgres
 ${PG_SUBPREFIX}bin/postmaster
 ${PG_SUBPREFIX}lib/postgresql/ascii_and_mic.la
@@ -124,6 +124,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Mendoza
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Rio_Gallegos
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/San_Juan
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/San_Luis
+${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Salta
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Tucuman
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Ushuaia
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Aruba
diff --git a/databases/postgresql82/Makefile.common b/databases/postgresql82/Makefile.common
index 8e523140de1..9b29a9f5284 100644
--- a/databases/postgresql82/Makefile.common
+++ b/databases/postgresql82/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.13 2008/10/06 09:45:55 adam Exp $
+# $NetBSD: Makefile.common,v 1.14 2008/11/04 09:52:39 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.10
+DIST_VERS?=		8.2.11
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql82-client+=	postgresql82-client>=${BASE_VERS}
diff --git a/databases/postgresql82/distinfo b/databases/postgresql82/distinfo
index 2363925a704..cf60804aa27 100644
--- a/databases/postgresql82/distinfo
+++ b/databases/postgresql82/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.13 2008/10/06 09:45:55 adam Exp $
+$NetBSD: distinfo,v 1.14 2008/11/04 09:52:39 adam Exp $
 
-SHA1 (postgresql-8.2.10.tar.bz2) = 2b4508ba70f18d350715d7113595e8529680e687
-RMD160 (postgresql-8.2.10.tar.bz2) = 46c7a3e98705dfa0d68c2893773c40d4b73d5eca
-Size (postgresql-8.2.10.tar.bz2) = 12551773 bytes
+SHA1 (postgresql-8.2.11.tar.bz2) = 5410c25a369f19fc4a376f942351553aff710d8f
+RMD160 (postgresql-8.2.11.tar.bz2) = 30e1f792a9168fa78b1c7d27742c6f98a7e2a08c
+Size (postgresql-8.2.11.tar.bz2) = 12564132 bytes
 SHA1 (patch-aa) = a7112ce2e9fc28f638afcf2e196d3cdc0f4c254d
 SHA1 (patch-ab) = 138221d6b3b2fe33d68d8d4aacf23b6913f6c809
 SHA1 (patch-ac) = cbd302a60d43171854c37171b57ee7bbf1194ad9