Changes 8.1.6:

* Improve handling of getaddrinfo() on AIX
  This fixes a problem with starting the statistics collector, among
  other things.
* Fix pg_restore to handle a tar-format backup that contains large
  objects (blobs) with comments
* Fix "failed to re-find parent key" errors in "VACUUM"
* Clean out "pg_internal.init" cache files during server restart
  This avoids a hazard that the cache files might contain stale data
  after PITR recovery.
* Fix race condition for truncation of a large relation across a
  gigabyte boundary by "VACUUM"
* Fix bug causing needless deadlock errors on row-level locks
* Fix bugs affecting multi-gigabyte hash indexes
* Fix possible deadlock in Windows signal handling
* Fix error when constructing an ARRAY[] made up of multiple empty
  elements
* Fix ecpg memory leak during connection
* Fix for Darwin (OS X) compilation
* to_number() and to_char(numeric) are now STABLE, not IMMUTABLE, for
  new initdb installs
  This is because lc_numeric can potentially change the output of
  these functions.
* Improve index usage of regular expressions that use parentheses
  This improves psql \d performance also.
* Update timezone database
  This affects Australian and Canadian daylight-savings rules in
  particular.

12 files changed, 50 insertions, 49 deletions

diff --git a/databases/postgresql81-client/Makefile b/databases/postgresql81-client/Makefile
index c51a36a625e..165d2d4250e 100644
--- a/databases/postgresql81-client/Makefile
+++ b/databases/postgresql81-client/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.5 2006/11/05 17:42:30 joerg Exp $
+# $NetBSD: Makefile,v 1.6 2007/01/08 18:55:38 adam Exp $
 
 PKGNAME=	postgresql81-client-${BASE_VERS}
 COMMENT=	PostgreSQL database client programs
@@ -13,8 +13,8 @@ CONFIGURE_ARGS+=	--with-openssl
 CONFIGURE_ARGS+=	--with-readline
 CONFIGURE_ARGS+=	--with-zlib
 
-CONFLICTS+=	postgresql81-lib-*
-CONFLICTS+=	postgresql81-docs-*
+CONFLICTS+=	postgresql81-lib-[0-9]*
+CONFLICTS+=	postgresql81-docs-[0-9]*
 
 # 1. The thread-safety test in ${WRSRC}/src/tools/thread does not pass on
 # NetBSD (missing strerror_r) or DragonFly.
@@ -33,15 +33,15 @@ CONFIGURE_ARGS+=	--enable-thread-safety
 .  endif
 .endif
 
-INSTALL_DIRS=	${WRKSRC}/src/include
-INSTALL_DIRS+=	${WRKSRC}/src/interfaces
-INSTALL_DIRS+=	${WRKSRC}/src/bin
-INSTALL_DIRS+=	${WRKSRC}/doc
+INSTALL_DIRS=	src/include
+INSTALL_DIRS+=	src/interfaces
+INSTALL_DIRS+=	src/bin
+INSTALL_DIRS+=	doc
 
 BUILD_DIRS=	${INSTALL_DIRS}
 
 # Without this, the Darwin build fails (related to -bundle_loader).
-BUILD_DIRS+=	${WRKSRC}/src/backend
+BUILD_DIRS+=	src/backend
 
 PKG_OPTIONS_VAR=	PKG_OPTIONS.postgresql81-client
 .include "../../databases/postgresql81/options.mk"
diff --git a/databases/postgresql81-client/PLIST b/databases/postgresql81-client/PLIST
index 7f8cf939b75..6cf26e7896d 100644
--- a/databases/postgresql81-client/PLIST
+++ b/databases/postgresql81-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.3 2006/10/18 16:33:21 adam Exp $
+@comment $NetBSD: PLIST,v 1.4 2007/01/08 18:55:38 adam Exp $
 ${PG_SUBPREFIX}bin/clusterdb
 ${PG_SUBPREFIX}bin/createdb
 ${PG_SUBPREFIX}bin/createlang
@@ -950,6 +950,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-13.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-14.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-15.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-16.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-17.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-4.html
@@ -965,6 +966,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-11.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-12.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-13.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-14.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-15.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
@@ -975,6 +977,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-8.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-9.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-1.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-10.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
@@ -988,6 +991,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-1.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
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-5.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/resources.html
diff --git a/databases/postgresql81-client/buildlink3.mk b/databases/postgresql81-client/buildlink3.mk
index 7a35b79577f..7b93ad345d8 100644
--- a/databases/postgresql81-client/buildlink3.mk
+++ b/databases/postgresql81-client/buildlink3.mk
@@ -1,11 +1,11 @@
-# $NetBSD: buildlink3.mk,v 1.7 2006/12/12 21:52:35 joerg Exp $
+# $NetBSD: buildlink3.mk,v 1.8 2007/01/08 18:55:38 adam Exp $
 
 BUILDLINK_DEPTH:=			${BUILDLINK_DEPTH}+
 POSTGRESQL81_CLIENT_BUILDLINK3_MK:=	${POSTGRESQL81_CLIENT_BUILDLINK3_MK}+
 
 .include "../../mk/bsd.fast.prefs.mk"
 
-.if !empty(BUILDLINK_DEPTH:M+)
+.if ${BUILDLINK_DEPTH} == "+"
 BUILDLINK_DEPENDS+=	postgresql81-client
 .endif
 
@@ -13,7 +13,7 @@ BUILDLINK_PACKAGES:=	${BUILDLINK_PACKAGES:Npostgresql81-client}
 BUILDLINK_PACKAGES+=	postgresql81-client
 BUILDLINK_ORDER:=	${BUILDLINK_ORDER} ${BUILDLINK_DEPTH}postgresql81-client
 
-.if !empty(POSTGRESQL81_CLIENT_BUILDLINK3_MK:M+)
+.if ${POSTGRESQL81_CLIENT_BUILDLINK3_MK} == "+"
 BUILDLINK_API_DEPENDS.postgresql81-client+=		postgresql81-client>=8.1.0
 BUILDLINK_PKGSRCDIR.postgresql81-client?=	../../databases/postgresql81-client
 
diff --git a/databases/postgresql81-plperl/Makefile b/databases/postgresql81-plperl/Makefile
index f7dcf85d26e..8eddeb29645 100644
--- a/databases/postgresql81-plperl/Makefile
+++ b/databases/postgresql81-plperl/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.3 2006/09/09 02:41:56 obache Exp $
+# $NetBSD: Makefile,v 1.4 2007/01/08 18:55:38 adam Exp $
 
 PKGNAME=	postgresql81-plperl-${BASE_VERS}
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
@@ -10,7 +10,7 @@ DEPENDS+=	postgresql81-server>=${BASE_VERS}:../../databases/postgresql81-server
 PERL5_CONFIGURE=	NO
 CONFIGURE_ARGS+=	--with-perl
 
-BUILD_DIRS=		${WRKSRC}/src/pl/plperl
+BUILD_DIRS=		src/pl/plperl
 MAKE_FILE=		GNUmakefile
 
 USE_LIBTOOL=		yes
diff --git a/databases/postgresql81-plpython/Makefile b/databases/postgresql81-plpython/Makefile
index c9e056fbcec..b55eb3dcde5 100644
--- a/databases/postgresql81-plpython/Makefile
+++ b/databases/postgresql81-plpython/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.2 2006/03/21 06:39:33 martti Exp $
+# $NetBSD: Makefile,v 1.3 2007/01/08 18:55:38 adam Exp $
 
 PKGNAME=	postgresql81-plpython-${BASE_VERS}
 COMMENT=	PL/Python procedural language for the PostgreSQL backend
@@ -10,7 +10,7 @@ DEPENDS+=	postgresql81-server>=${BASE_VERS}:../../databases/postgresql81-server
 CONFIGURE_ARGS+=	--with-python
 CONFIGURE_ENV+=		PYTHON="${PYTHONBIN}"
 
-BUILD_DIRS=		${WRKSRC}/src/pl/plpython
+BUILD_DIRS=		src/pl/plpython
 
 USE_LIBTOOL=		yes
 PKG_LIBTOOL=		${PKG_SHLIBTOOL}
diff --git a/databases/postgresql81-pltcl/Makefile b/databases/postgresql81-pltcl/Makefile
index c90fb5e5b9d..8bd5ea94e58 100644
--- a/databases/postgresql81-pltcl/Makefile
+++ b/databases/postgresql81-pltcl/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.2 2006/03/21 06:39:33 martti Exp $
+# $NetBSD: Makefile,v 1.3 2007/01/08 18:55:38 adam Exp $
 
 PKGNAME=	postgresql81-pltcl-${BASE_VERS}
 COMMENT=	PL/Tcl procedural language for the PostgreSQL backend
@@ -12,7 +12,7 @@ CONFIGURE_ARGS+=	--with-tclconfig="${BUILDLINK_PREFIX.tcl}/lib"
 CONFIGURE_ENV+=		TCLSH="${TCLSH}"
 TCLSH=			${BUILDLINK_PREFIX.tcl}/bin/tclsh
 
-BUILD_DIRS=		${WRKSRC}/src/pl/tcl
+BUILD_DIRS=		src/pl/tcl
 
 USE_LIBTOOL=		yes
 PKG_LIBTOOL=		${PKG_SHLIBTOOL}
diff --git a/databases/postgresql81-server/Makefile b/databases/postgresql81-server/Makefile
index f36abec6d9e..0fac65e3a05 100644
--- a/databases/postgresql81-server/Makefile
+++ b/databases/postgresql81-server/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.6 2006/11/05 17:42:30 joerg Exp $
+# $NetBSD: Makefile,v 1.7 2007/01/08 18:55:39 adam Exp $
 
 PKGNAME=	postgresql81-server-${BASE_VERS}
 COMMENT=	PostgreSQL database server programs
@@ -18,10 +18,10 @@ MESSAGE_SRC=		${.CURDIR}/MESSAGE
 
 CONFIGURE_ARGS+=	--with-openssl
 
-BUILD_DIRS=		${WRKSRC}/src/backend
-BUILD_DIRS+=		${WRKSRC}/src/backend/utils/mb/conversion_procs
-BUILD_DIRS+=		${WRKSRC}/src/timezone
-BUILD_DIRS+=		${WRKSRC}/src/pl
+BUILD_DIRS=	src/backend
+BUILD_DIRS+=	src/backend/utils/mb/conversion_procs
+BUILD_DIRS+=	src/timezone
+BUILD_DIRS+=	src/pl
 
 # PostgreSQL has loadable server-side language modules.
 #
diff --git a/databases/postgresql81-server/PLIST b/databases/postgresql81-server/PLIST
index 1be46d9a31d..4f8c6305e2e 100644
--- a/databases/postgresql81-server/PLIST
+++ b/databases/postgresql81-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1.1.1 2006/03/20 14:45:52 uebayasi Exp $
+@comment $NetBSD: PLIST,v 1.2 2007/01/08 18:55:39 adam Exp $
 ${PG_SUBPREFIX}bin/postgres
 ${PG_SUBPREFIX}bin/postmaster
 ${PG_SUBPREFIX}lib/postgresql/ascii_and_mic.la
@@ -129,11 +129,13 @@ ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Tucuman
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Ushuaia
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Aruba
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Asuncion
+${PG_SUBPREFIX}share/postgresql/timezone/America/Atikokan
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Atka
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Bahia
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Barbados
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Belem
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Belize
+${PG_SUBPREFIX}share/postgresql/timezone/America/Blanc-Sablon
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Boa_Vista
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Bogota
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Boise
@@ -179,8 +181,11 @@ ${PG_SUBPREFIX}share/postgresql/timezone/America/Hermosillo
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Indianapolis
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Knox
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Marengo
+${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Petersburg
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Vevay
+${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Vincennes
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Indianapolis
+${PG_SUBPREFIX}share/postgresql/timezone/America/Moncton
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Inuvik
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Iqaluit
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Jamaica
@@ -213,6 +218,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/America/Nipigon
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Nome
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Noronha
 ${PG_SUBPREFIX}share/postgresql/timezone/America/North_Dakota/Center
+${PG_SUBPREFIX}share/postgresql/timezone/America/North_Dakota/New_Salem
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Panama
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Pangnirtung
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Paramaribo
@@ -454,10 +460,13 @@ ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Chisinau
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Copenhagen
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Dublin
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Gibraltar
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Guernsey
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Kiev
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Isle_of_Man
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Jersey
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Helsinki
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Istanbul
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Kaliningrad
-${PG_SUBPREFIX}share/postgresql/timezone/Europe/Kiev
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Lisbon
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Ljubljana
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/London
@@ -471,6 +480,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Moscow
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Nicosia
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Oslo
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Paris
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Podgorica
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Prague
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Riga
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Rome
@@ -489,6 +499,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Vaduz
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Vatican
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Vienna
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Vilnius
+${PG_SUBPREFIX}share/postgresql/timezone/Europe/Volgograd
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Warsaw
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Zagreb
 ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Zaporozhye
@@ -580,19 +591,6 @@ ${PG_SUBPREFIX}share/postgresql/timezone/Portugal
 ${PG_SUBPREFIX}share/postgresql/timezone/ROC
 ${PG_SUBPREFIX}share/postgresql/timezone/ROK
 ${PG_SUBPREFIX}share/postgresql/timezone/Singapore
-${PG_SUBPREFIX}share/postgresql/timezone/SystemV/AST4
-${PG_SUBPREFIX}share/postgresql/timezone/SystemV/AST4ADT
-${PG_SUBPREFIX}share/postgresql/timezone/SystemV/CST6
-${PG_SUBPREFIX}share/postgresql/timezone/SystemV/CST6CDT
-${PG_SUBPREFIX}share/postgresql/timezone/SystemV/EST5
-${PG_SUBPREFIX}share/postgresql/timezone/SystemV/EST5EDT
-${PG_SUBPREFIX}share/postgresql/timezone/SystemV/HST10
-${PG_SUBPREFIX}share/postgresql/timezone/SystemV/MST7
-${PG_SUBPREFIX}share/postgresql/timezone/SystemV/MST7MDT
-${PG_SUBPREFIX}share/postgresql/timezone/SystemV/PST8
-${PG_SUBPREFIX}share/postgresql/timezone/SystemV/PST8PDT
-${PG_SUBPREFIX}share/postgresql/timezone/SystemV/YST9
-${PG_SUBPREFIX}share/postgresql/timezone/SystemV/YST9YDT
 ${PG_SUBPREFIX}share/postgresql/timezone/Turkey
 ${PG_SUBPREFIX}share/postgresql/timezone/UCT
 ${PG_SUBPREFIX}share/postgresql/timezone/US/Alaska
@@ -614,7 +612,6 @@ ${PG_SUBPREFIX}share/postgresql/timezone/W-SU
 ${PG_SUBPREFIX}share/postgresql/timezone/WET
 ${PG_SUBPREFIX}share/postgresql/timezone/Zulu
 @dirrm ${PG_SUBPREFIX}share/postgresql/timezone/US
-@dirrm ${PG_SUBPREFIX}share/postgresql/timezone/SystemV
 @dirrm ${PG_SUBPREFIX}share/postgresql/timezone/Pacific
 @dirrm ${PG_SUBPREFIX}share/postgresql/timezone/Mideast
 @dirrm ${PG_SUBPREFIX}share/postgresql/timezone/Mexico
diff --git a/databases/postgresql81-tsearch2/Makefile b/databases/postgresql81-tsearch2/Makefile
index 6ceafd88572..6592f314191 100644
--- a/databases/postgresql81-tsearch2/Makefile
+++ b/databases/postgresql81-tsearch2/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.2 2006/12/01 20:15:12 joerg Exp $
+# $NetBSD: Makefile,v 1.3 2007/01/08 18:55:39 adam Exp $
 
 PKGNAME=	postgresql81-tsearch2-${BASE_VERS}
 COMMENT=	Tsearch2 contrib module for fulltext indexing in PostgreSQL
@@ -7,7 +7,8 @@ DEPENDS+=	postgresql81-server>=${BASE_VERS}:../../databases/postgresql81-server
 
 .include "../../databases/postgresql81/Makefile.common"
 
-BUILD_DIRS=		${WRKSRC}/contrib/tsearch2/snowball ${WRKSRC}/contrib/tsearch2
+BUILD_DIRS=		contrib/tsearch2/snowball
+BUILD_DIRS+=		contrib/tsearch2
 
 USE_LIBTOOL=		yes
 PKG_LIBTOOL=		${PKG_SHLIBTOOL}
diff --git a/databases/postgresql81-tsearch2/PLIST b/databases/postgresql81-tsearch2/PLIST
index 45de092e933..76dbc24c4aa 100644
--- a/databases/postgresql81-tsearch2/PLIST
+++ b/databases/postgresql81-tsearch2/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1.1.1 2006/12/01 20:13:49 joerg Exp $
+@comment $NetBSD: PLIST,v 1.2 2007/01/08 18:55:39 adam Exp $
 ${PG_SUBPREFIX}lib/postgresql/tsearch2.la
 ${PG_SUBPREFIX}share/doc/postgresql/contrib/README.tsearch2
 ${PG_SUBPREFIX}share/postgresql/contrib/english.stop
@@ -7,4 +7,3 @@ ${PG_SUBPREFIX}share/postgresql/contrib/tsearch2.sql
 ${PG_SUBPREFIX}share/postgresql/contrib/untsearch2.sql
 @dirrm share/postgresql/contrib
 @dirrm share/doc/postgresql/contrib
-@dirrm lib/postgresql
diff --git a/databases/postgresql81/Makefile.common b/databases/postgresql81/Makefile.common
index 0bdd700ad45..e36ef0ead9d 100644
--- a/databases/postgresql81/Makefile.common
+++ b/databases/postgresql81/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.7 2006/10/18 16:31:24 adam Exp $
+# $NetBSD: Makefile.common,v 1.8 2007/01/08 18:55:38 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -32,7 +32,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql81/patches
 #
 # Note: Do not forget jdbc-postgresql81 when updating version
 #
-DIST_VERS?=		8.1.5
+DIST_VERS?=		8.1.6
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql81-client+=	postgresql81-client>=${BASE_VERS}
diff --git a/databases/postgresql81/distinfo b/databases/postgresql81/distinfo
index e40653d87f9..d6d26e8c783 100644
--- a/databases/postgresql81/distinfo
+++ b/databases/postgresql81/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.4 2006/12/01 20:10:18 joerg Exp $
+$NetBSD: distinfo,v 1.5 2007/01/08 18:55:38 adam Exp $
 
-SHA1 (postgresql-8.1.5.tar.bz2) = 6d819ad4e2344db1eac2aaab13f8034820ac8868
-RMD160 (postgresql-8.1.5.tar.bz2) = 02a8aab23e424b5006b24bf884d6920c4818f907
-Size (postgresql-8.1.5.tar.bz2) = 11616301 bytes
+SHA1 (postgresql-8.1.6.tar.bz2) = d2a849e5e5d93a102dacaa1e420b1148d564837b
+RMD160 (postgresql-8.1.6.tar.bz2) = d61ca7541ff4806bf9216ce156377588589b12dd
+Size (postgresql-8.1.6.tar.bz2) = 11646873 bytes
 SHA1 (patch-aa) = a7112ce2e9fc28f638afcf2e196d3cdc0f4c254d
 SHA1 (patch-ab) = 8d09f4e274aeb4ac2b15db73e7801376a5627d27
 SHA1 (patch-ac) = cbd302a60d43171854c37171b57ee7bbf1194ad9