Update to 7.3.10

Posted on 2005-05-12:

In order to address several security issues identified over the past two
weeks, as well as one "low probability" race condition, we are releasing new
version of PostgreSQL as far back as the 7.2.x branch.

Please note that the security issues were those already reported by Tom Lane,
as well as a manual fix for them. These releases are mainly to ensure that
those installing and/or upgrading existing installations have those fixes
automatically.

For details on the fixes, please see the HISTORY file included in the Release,
but a summary consists of:

* Change encoding function signature to prevent misuse
* Change "contrib/tsearch2" to avoid unsafe use of INTERNAL function results
* Repair race condition between relation extension and VACUUM This could
  theoretically have caused loss of a page's worth of freshly-inserted data,
  although the scenario seems of very low probability. There are no known
  cases of it having caused more than an Assert failure.

7 files changed, 16 insertions, 77 deletions

diff --git a/databases/postgresql73-docs/PLIST b/databases/postgresql73-docs/PLIST
index 2f58c364431..01990d6b47a 100644
--- a/databases/postgresql73-docs/PLIST
+++ b/databases/postgresql73-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.4 2005/02/20 00:03:40 wiz Exp $
+@comment $NetBSD: PLIST,v 1.5 2005/08/07 18:19:16 adrianp Exp $
 share/doc/html/postgresql/admin-preface.html
 share/doc/html/postgresql/admin.html
 share/doc/html/postgresql/app-clusterdb.html
@@ -192,10 +192,10 @@ share/doc/html/postgresql/libpq-threading.html
 share/doc/html/postgresql/libpq-trace.html
 share/doc/html/postgresql/libpq.html
 share/doc/html/postgresql/ln17992.html
+share/doc/html/postgresql/ln26577.html
+share/doc/html/postgresql/ln39021.html
+share/doc/html/postgresql/ln53737.html
 share/doc/html/postgresql/ln25.html
-share/doc/html/postgresql/ln26479.html
-share/doc/html/postgresql/ln38923.html
-share/doc/html/postgresql/ln53639.html
 share/doc/html/postgresql/ln659.html
 share/doc/html/postgresql/lo-funcs.html
 share/doc/html/postgresql/lo-implementation.html
@@ -388,6 +388,7 @@ share/doc/html/postgresql/release-7-2-4.html
 share/doc/html/postgresql/release-7-2-5.html
 share/doc/html/postgresql/release-7-2-6.html
 share/doc/html/postgresql/release-7-2-7.html
+share/doc/html/postgresql/release-7-2-8.html
 share/doc/html/postgresql/release-7-2.html
 share/doc/html/postgresql/release-7-3-1.html
 share/doc/html/postgresql/release-7-3-2.html
@@ -397,6 +398,7 @@ share/doc/html/postgresql/release-7-3-5.html
 share/doc/html/postgresql/release-7-3-6.html
 share/doc/html/postgresql/release-7-3-7.html
 share/doc/html/postgresql/release-7-3-8.html
+share/doc/html/postgresql/release-7-3-9.html
 share/doc/html/postgresql/release-7-3.html
 share/doc/html/postgresql/release.html
 share/doc/html/postgresql/resources.html
diff --git a/databases/postgresql73-lib/Makefile b/databases/postgresql73-lib/Makefile
index 112cf1154a0..f5868d48c01 100644
--- a/databases/postgresql73-lib/Makefile
+++ b/databases/postgresql73-lib/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2005/07/15 18:27:48 jlam Exp $
+# $NetBSD: Makefile,v 1.12 2005/08/07 18:19:16 adrianp Exp $
 
 PKGNAME=		postgresql73-lib-${BASE_VERS}
-PKGREVISION=		2
 SVR4_PKGNAME=		pstgl
 COMMENT=		PostgreSQL database headers and libraries
 
diff --git a/databases/postgresql73-lib/buildlink3.mk b/databases/postgresql73-lib/buildlink3.mk
index 4a42e4099dd..e19439d17ed 100644
--- a/databases/postgresql73-lib/buildlink3.mk
+++ b/databases/postgresql73-lib/buildlink3.mk
@@ -1,4 +1,4 @@
-# $NetBSD: buildlink3.mk,v 1.2 2005/03/18 19:57:31 jlam Exp $
+# $NetBSD: buildlink3.mk,v 1.3 2005/08/07 18:19:16 adrianp Exp $
 
 BUILDLINK_DEPTH:=		${BUILDLINK_DEPTH}+
 POSTGRESQL73_LIB_BUILDLINK3_MK:=	${POSTGRESQL73_LIB_BUILDLINK3_MK}+
@@ -11,7 +11,7 @@ BUILDLINK_PACKAGES:=	${BUILDLINK_PACKAGES:Npostgresql73-lib}
 BUILDLINK_PACKAGES+=	postgresql73-lib
 
 .if !empty(POSTGRESQL73_LIB_BUILDLINK3_MK:M+)
-BUILDLINK_DEPENDS.postgresql73-lib+=	postgresql73-lib>=7.3.6
+BUILDLINK_DEPENDS.postgresql73-lib+=	postgresql73-lib>=7.3.10
 BUILDLINK_PKGSRCDIR.postgresql73-lib?=	../../databases/postgresql73-lib
 BUILDLINK_INCDIRS.postgresql73-lib?=	include/postgresql
 BUILDLINK_FILES.postgresql73-lib+=	include/pgsql/*
diff --git a/databases/postgresql73-plperl/Makefile b/databases/postgresql73-plperl/Makefile
index da044a71cc9..7a7abd38a46 100644
--- a/databases/postgresql73-plperl/Makefile
+++ b/databases/postgresql73-plperl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2005/08/06 06:19:07 jlam Exp $
+# $NetBSD: Makefile,v 1.6 2005/08/07 18:19:16 adrianp Exp $
 
 PKGNAME=		postgresql73-plperl-${BASE_VERS}
-PKGREVISION=		2
 COMMENT=		PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql73-server>=${BASE_VERS}:../../databases/postgresql73-server
diff --git a/databases/postgresql73/Makefile.common b/databases/postgresql73/Makefile.common
index c9abb89c934..a38696866a6 100644
--- a/databases/postgresql73/Makefile.common
+++ b/databases/postgresql73/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.10 2005/07/13 15:34:01 jschauma Exp $
+# $NetBSD: Makefile.common,v 1.11 2005/08/07 18:19:16 adrianp Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -33,7 +33,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql73/patches
 # BASE_VERS		pkgsrc-mangled version number (convert pl -> .)
 #
 # Note: Do not forget jdbc-postgresql when updating version
-DIST_VERS?=		7.3.9
+DIST_VERS?=		7.3.10
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_DEPENDS.postgresql73-lib?=	postgresql73-lib>=${BASE_VERS}
diff --git a/databases/postgresql73/distinfo b/databases/postgresql73/distinfo
index 42d495d1e86..ffa55cef9bd 100644
--- a/databases/postgresql73/distinfo
+++ b/databases/postgresql73/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.9 2005/05/02 02:14:23 markd Exp $
+$NetBSD: distinfo,v 1.10 2005/08/07 18:19:16 adrianp Exp $
 
-SHA1 (postgresql-7.3.9.tar.gz) = 01481f3af507cb6b361bd71fc51c0fb8c06905da
-RMD160 (postgresql-7.3.9.tar.gz) = 61b97bd71cee3e107419598b75d0ec0734df2791
-Size (postgresql-7.3.9.tar.gz) = 11288172 bytes
+SHA1 (postgresql-7.3.10.tar.gz) = 173bfb9c4ae7d4bd84a90babdbf34d420fcb90c2
+RMD160 (postgresql-7.3.10.tar.gz) = 544602d752a8e2f0d2b90e1e2e4c50431b98c44b
+Size (postgresql-7.3.10.tar.gz) = 11296380 bytes
 SHA1 (patch-aa) = 61fbeb664b0d89c83a36c79cca3fbdc78d6f5059
 SHA1 (patch-ab) = d45df2da17b1ff67f5f82b4ff743afe350500786
 SHA1 (patch-ac) = 5a647cc31873ae81a5bd5a6cf4ec6f44a43448e7
@@ -14,4 +14,3 @@ SHA1 (patch-ah) = 210c0dda3c32481280fe5f2a9525d33f1d989c6d
 SHA1 (patch-ai) = d7889e05ab7963f2b93b46c953cbf1a44e9c0fe5
 SHA1 (patch-aj) = 4c46173cba1dd36296d8b3fcca8cdfebcc717162
 SHA1 (patch-ak) = a983f23b5e47a4c2f31ba284ff3db51b53cf8414
-SHA1 (patch-al) = f2827e29d063d3aa8dfcead3f16f9aa27459bbf7
diff --git a/databases/postgresql73/patches/patch-al b/databases/postgresql73/patches/patch-al
deleted file mode 100644
index bbc02a6fdf4..00000000000
--- a/databases/postgresql73/patches/patch-al
+++ /dev/null
@@ -1,60 +0,0 @@
-$NetBSD: patch-al,v 1.2 2005/05/02 02:14:23 markd Exp $
-
---- src/pl/plpgsql/src/gram.y.orig	2005-01-26 20:44:42.000000000 -0500
-+++ src/pl/plpgsql/src/gram.y	2005-03-17 16:34:50.000000000 -0500
-@@ -1626,6 +1626,13 @@
- 		}
- 	}
- 
-+	/* Check for array overflow */
-+	if (nparams >= 1024)
-+	{
-+		plpgsql_error_lineno = lno;
-+		elog(ERROR, "too many variables specified in SQL statement");
-+	}
-+
- 	expr = malloc(sizeof(PLpgSQL_expr) + sizeof(int) * nparams - sizeof(int));
- 	expr->dtype			= PLPGSQL_DTYPE_EXPR;
- 	expr->query			= strdup(plpgsql_dstring_get(&ds));
-@@ -1761,6 +1768,13 @@
- 
- 					while ((tok = yylex()) == ',')
- 					{
-+						/* Check for array overflow */
-+						if (nfields >= 1024)
-+						{
-+							plpgsql_error_lineno = yylineno;
-+							elog(ERROR, "too many variables specified in SQL statement");
-+						}
-+
- 						tok = yylex();
- 						switch(tok)
- 						{
-@@ -1821,6 +1835,13 @@
- 				plpgsql_dstring_append(&ds, yytext);
- 				break;
- 		}
-+
-+		/* Check for array overflow */
-+		if (nparams >= 1024)
-+		{
-+			plpgsql_error_lineno = yylineno;
-+			elog(ERROR, "too many variables specified in SQL statement");
-+		}
- 	}
- 
- 	expr = malloc(sizeof(PLpgSQL_expr) + sizeof(int) * nparams - sizeof(int));
-@@ -1892,6 +1913,13 @@
- 
- 				while ((tok = yylex()) == ',')
- 				{
-+					/* Check for array overflow */
-+					if (nfields >= 1024)
-+					{
-+						plpgsql_error_lineno = yylineno;
-+						elog(ERROR, "too many variables specified in SQL statement");
-+					}
-+
- 					tok = yylex();
- 					switch(tok)
- 					{