Update PostgreSQL to latest versions. 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.

Security:	http://www.postgresql.org/about/news.315

4 files changed, 10 insertions, 159 deletions

diff --git a/databases/postgresql73-server/Makefile b/databases/postgresql73-server/Makefile
index 1fa1722ac869..c54b7cb8f700 100644
--- a/databases/postgresql73-server/Makefile
+++ b/databases/postgresql73-server/Makefile
@@ -7,8 +7,8 @@
 
 PORTNAME?=	postgresql
 PKGNAMESUFFIX?=	-server
-PORTVERSION?=	7.3.9
-PORTREVISION?=	3
+PORTVERSION?=	7.3.10
+PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
diff --git a/databases/postgresql73-server/distinfo b/databases/postgresql73-server/distinfo
index 92e9164cea55..adafb8961655 100644
--- a/databases/postgresql73-server/distinfo
+++ b/databases/postgresql73-server/distinfo
@@ -1,8 +1,8 @@
-MD5 (postgresql/postgresql-base-7.3.9.tar.bz2) = acf807dfbc7389556dd8b9745588d04c
-SIZE (postgresql/postgresql-base-7.3.9.tar.bz2) = 5644088
-MD5 (postgresql/postgresql-docs-7.3.9.tar.bz2) = 0e19d3bad8b8bb9c56a0c466e5765449
-SIZE (postgresql/postgresql-docs-7.3.9.tar.bz2) = 2343410
-MD5 (postgresql/postgresql-opt-7.3.9.tar.bz2) = cc5df63bb78d6b021477fb8c4596037c
-SIZE (postgresql/postgresql-opt-7.3.9.tar.bz2) = 340736
-MD5 (postgresql/postgresql-test-7.3.9.tar.bz2) = fafbb055b70bc0345a39241bf8be59a6
-SIZE (postgresql/postgresql-test-7.3.9.tar.bz2) = 907750
+MD5 (postgresql/postgresql-base-7.3.10.tar.bz2) = d0c5131bad7330b35a0168f871a87711
+SIZE (postgresql/postgresql-base-7.3.10.tar.bz2) = 5645041
+MD5 (postgresql/postgresql-docs-7.3.10.tar.bz2) = 4e3d402834f19677ef1fe5076589b56a
+SIZE (postgresql/postgresql-docs-7.3.10.tar.bz2) = 2347114
+MD5 (postgresql/postgresql-opt-7.3.10.tar.bz2) = 7ffe5bd823436f77f40c6c2e236cac15
+SIZE (postgresql/postgresql-opt-7.3.10.tar.bz2) = 340962
+MD5 (postgresql/postgresql-test-7.3.10.tar.bz2) = b6d0600ad86f35283bda39e94421940a
+SIZE (postgresql/postgresql-test-7.3.10.tar.bz2) = 908349
diff --git a/databases/postgresql73-server/files/patch-src-pl-plpgsql-src-gram-y b/databases/postgresql73-server/files/patch-src-pl-plpgsql-src-gram-y
deleted file mode 100644
index e9d23cac61ea..000000000000
--- a/databases/postgresql73-server/files/patch-src-pl-plpgsql-src-gram-y
+++ /dev/null
@@ -1,69 +0,0 @@
---- src/pl/plpgsql/src/gram.y	2005/01/27 01:44:42	1.39.2.1 REL7_3_9
-+++ src/pl/plpgsql/src/gram.y	2005/02/08 18:22:45	1.39.2.2 REL7_3_STABLE
-@@ -4,7 +4,7 @@
-  *						  procedural language
-  *
-  * IDENTIFICATION
-- *	  $Header: /cvsroot/pgsql/src/pl/plpgsql/src/gram.y,v 1.39.2.1 2005/01/27 01:44:42 neilc Exp $
-+ *	  $Header: /cvsroot/pgsql/src/pl/plpgsql/src/gram.y,v 1.39.2.2 2005/02/08 18:22:45 tgl Exp $
-  *
-  *	  This software is copyrighted by Jan Wieck - Hamburg.
-  *
-@@ -1612,6 +1612,14 @@ read_sql_construct(int until,
- 		}
- 		if (plpgsql_SpaceScanned)
- 			plpgsql_dstring_append(&ds, " ");
-+
-+		/* Check for array overflow */
-+		if (nparams >= 1024)
-+		{
-+			plpgsql_error_lineno = lno;
-+			elog(ERROR, "too many variables specified in SQL statement");
-+		}
-+
- 		switch (tok)
- 		{
- 			case T_VARIABLE:
-@@ -1761,6 +1769,13 @@ make_select_stmt(void)
- 
- 					while ((tok = yylex()) == ',')
- 					{
-+						/* Check for array overflow */
-+						if (nfields >= 1024)
-+						{
-+							plpgsql_error_lineno = yylineno;
-+							elog(ERROR, "too many INTO variables specified");
-+						}
-+
- 						tok = yylex();
- 						switch(tok)
- 						{
-@@ -1809,6 +1824,14 @@ make_select_stmt(void)
- 
- 		if (plpgsql_SpaceScanned)
- 			plpgsql_dstring_append(&ds, " ");
-+
-+		/* Check for array overflow */
-+		if (nparams >= 1024)
-+		{
-+			plpgsql_error_lineno = yylineno;
-+			elog(ERROR, "too many variables specified in SQL statement");
-+		}
-+
- 		switch (tok)
- 		{
- 			case T_VARIABLE:
-@@ -1892,6 +1915,13 @@ make_fetch_stmt(void)
- 
- 				while ((tok = yylex()) == ',')
- 				{
-+					/* Check for array overflow */
-+					if (nfields >= 1024)
-+					{
-+						plpgsql_error_lineno = yylineno;
-+						elog(ERROR, "too many INTO variables specified");
-+					}
-+
- 					tok = yylex();
- 					switch(tok)
- 					{
diff --git a/databases/postgresql73-server/files/patch-src-pl-plpgsql-src-pl-gram-c b/databases/postgresql73-server/files/patch-src-pl-plpgsql-src-pl-gram-c
deleted file mode 100644
index b45f80e433f3..000000000000
--- a/databases/postgresql73-server/files/patch-src-pl-plpgsql-src-pl-gram-c
+++ /dev/null
@@ -1,80 +0,0 @@
---- /opt/portbuild/tmp/opt/ports/databases/postgresql73-server/work/postgresql-7.3.9/src/pl/plpgsql/src/pl.tab.h	Sun Feb 20 03:13:44 2005
-+++ src/pl/plpgsql/src/pl.tab.h	Sun Feb 20 05:40:07 2005
-@@ -203,7 +203,7 @@
- 		PLpgSQL_stmt_block		*program;
- 		PLpgSQL_nsitem			*nsitem;
- } PLPGSQL_YYSTYPE;
--/* Line 1248 of yacc.c.  */
-+/* Line 1238 of yacc.c.  */
- #line 207 "y.tab.h"
- # define plpgsql_yystype PLPGSQL_YYSTYPE /* obsolescent; will be withdrawn */
- # define PLPGSQL_YYSTYPE_IS_DECLARED 1
---- /opt/portbuild/tmp/opt/ports/databases/postgresql73-server/work/postgresql-7.3.9/src/pl/plpgsql/src/pl_gram.c	Mon Jan 31 18:17:16 2005
-+++ src/pl/plpgsql/src/pl_gram.c	Sun Feb 20 05:40:07 2005
-@@ -191,7 +191,7 @@
-  *						  procedural language
-  *
-  * IDENTIFICATION
-- *	  $Header: /cvsroot/pgsql/src/pl/plpgsql/src/gram.y,v 1.39.2.1 2005/01/27 01:44:42 neilc Exp $
-+ *	  $Header: /cvsroot/pgsql/src/pl/plpgsql/src/gram.y,v 1.39.2.2 2005/02/08 18:22:45 tgl Exp $
-  *
-  *	  This software is copyrighted by Jan Wieck - Hamburg.
-  *
-@@ -3247,6 +3233,14 @@
- 		}
- 		if (plpgsql_SpaceScanned)
- 			plpgsql_dstring_append(&ds, " ");
-+
-+		/* Check for array overflow */
-+		if (nparams >= 1024)
-+		{
-+			plpgsql_error_lineno = lno;
-+			elog(ERROR, "too many variables specified in SQL statement");
-+		}
-+
- 		switch (tok)
- 		{
- 			case T_VARIABLE:
-@@ -3396,6 +3390,13 @@
- 
- 					while ((tok = plpgsql_yylex()) == ',')
- 					{
-+						/* Check for array overflow */
-+						if (nfields >= 1024)
-+						{
-+							plpgsql_error_lineno = plpgsql_yylineno;
-+							elog(ERROR, "too many INTO variables specified");
-+						}
-+
- 						tok = plpgsql_yylex();
- 						switch(tok)
- 						{
-@@ -3444,6 +3445,14 @@
- 
- 		if (plpgsql_SpaceScanned)
- 			plpgsql_dstring_append(&ds, " ");
-+
-+		/* Check for array overflow */
-+		if (nparams >= 1024)
-+		{
-+			plpgsql_error_lineno = plpgsql_yylineno;
-+			elog(ERROR, "too many variables specified in SQL statement");
-+		}
-+
- 		switch (tok)
- 		{
- 			case T_VARIABLE:
-@@ -3527,6 +3536,13 @@
- 
- 				while ((tok = plpgsql_yylex()) == ',')
- 				{
-+					/* Check for array overflow */
-+					if (nfields >= 1024)
-+					{
-+						plpgsql_error_lineno = plpgsql_yylineno;
-+						elog(ERROR, "too many INTO variables specified");
-+					}
-+
- 					tok = plpgsql_yylex();
- 					switch(tok)
- 					{