Upgrade PostgreSQL to 8.0.2. Here's the brief release note:

  Over the past several weeks, Tom Lane has been working on replacing
  our old Cache Management Alorithm (ARC) with a new, patent free one
  (2Q).

  In order to reduce the number of 8.x deployments out there that are
  using the old manager, we have just released 8.0.2, and encourage
  adminstrators to upgrade at their earliest convience.

  For those already running 8.x on your production servers, please
  note that this upgrade does *NOT* require a dump restore, but due to
  a bump in the major version number for the client library (libpq),
  it *WILL* require all client applications to be recompiled at the
  same time.

For full release info, see
http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0-2

Apart from the upgrade, three new config options are added:

 A patch (experimental) for supporting proper collation
 of utf-8 encoded locales, using IBM's ICU package (devel/icu). See
 http://people.freebsd.org/~girgen/postgresql-icu/README.html for more
 info.

 An optional patch written by Evgen Potemkin, which allows
 PostgreSQL to make hierarchical queries à la Oracle [1].

 An option is added that allows the use of 64 bit ints to
 store dates [2].

PR: ports/79165 [1], ports/76999 [2]
Submitted by: Marcos Tischer Vallim [1], Christian Ullrich [2]
Approved by: ade, seanc (implicit)

2 files changed, 0 insertions, 171 deletions

diff --git a/databases/postgresql82-server/files/patch-src-pl-plpgsql-src-gram-y b/databases/postgresql82-server/files/patch-src-pl-plpgsql-src-gram-y
deleted file mode 100644
index 672745ce2760..000000000000
--- a/databases/postgresql82-server/files/patch-src-pl-plpgsql-src-gram-y
+++ /dev/null
@@ -1,80 +0,0 @@
---- src/pl/plpgsql/src/gram.y	2005/01/21 00:17:02	1.64.4.1 REL8_0_1
-+++ src/pl/plpgsql/src/gram.y	2005/02/08 18:21:59	1.64.4.3 REL8_0_STABLE
-@@ -4,7 +4,7 @@
-  *						  procedural language
-  *
-  * IDENTIFICATION
-- *	  $PostgreSQL: pgsql/src/pl/plpgsql/src/gram.y,v 1.64.4.1 2005/01/21 00:17:02 neilc Exp $
-+ *	  $PostgreSQL: pgsql/src/pl/plpgsql/src/gram.y,v 1.64.4.2 2005/02/07 03:52:22 neilc Exp $
-  *
-  *	  This software is copyrighted by Jan Wieck - Hamburg.
-  *
-@@ -1766,8 +1766,19 @@ read_sql_construct(int until,
- 						 errmsg("missing \"%s\" at end of SQL statement",
- 								expected)));
- 		}
-+
- 		if (plpgsql_SpaceScanned)
- 			plpgsql_dstring_append(&ds, " ");
-+
-+		/* Check for array overflow */
-+		if (nparams >= 1024)
-+		{
-+			plpgsql_error_lineno = lno;
-+			ereport(ERROR,
-+					(errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
-+					 errmsg("too many variables specified in SQL statement")));
-+		}
-+
- 		switch (tok)
- 		{
- 			case T_SCALAR:
-@@ -1940,6 +1951,15 @@ make_select_stmt(void)
- 
- 					while ((tok = yylex()) == ',')
- 					{
-+						/* Check for array overflow */
-+						if (nfields >= 1024)
-+						{
-+							plpgsql_error_lineno = plpgsql_scanner_lineno();
-+							ereport(ERROR,
-+									(errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
-+									 errmsg("too many INTO variables specified")));
-+						}
-+
- 						tok = yylex();
- 						switch(tok)
- 						{
-@@ -1990,6 +2010,16 @@ make_select_stmt(void)
- 
- 		if (plpgsql_SpaceScanned)
- 			plpgsql_dstring_append(&ds, " ");
-+
-+		/* Check for array overflow */
-+		if (nparams >= 1024)
-+		{
-+			plpgsql_error_lineno = plpgsql_scanner_lineno();
-+			ereport(ERROR,
-+					(errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
-+					 errmsg("too many variables specified in SQL statement")));
-+		}
-+
- 		switch (tok)
- 		{
- 			case T_SCALAR:
-@@ -2085,6 +2115,15 @@ make_fetch_stmt(void)
- 
- 				while ((tok = yylex()) == ',')
- 				{
-+					/* Check for array overflow */
-+					if (nfields >= 1024)
-+					{
-+						plpgsql_error_lineno = plpgsql_scanner_lineno();
-+						ereport(ERROR,
-+								(errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
-+								 errmsg("too many INTO variables specified")));
-+					}
-+
- 					tok = yylex();
- 					switch(tok)
- 					{
diff --git a/databases/postgresql82-server/files/patch-src-pl-plpgsql-src-pl-gram-c b/databases/postgresql82-server/files/patch-src-pl-plpgsql-src-pl-gram-c
deleted file mode 100644
index e4cb940fda72..000000000000
--- a/databases/postgresql82-server/files/patch-src-pl-plpgsql-src-pl-gram-c
+++ /dev/null
@@ -1,91 +0,0 @@
---- /opt/portbuild/tmp/opt/ports/databases/postgresql80-server/work/postgresql-8.0.1/src/pl/plpgsql/src/pl_gram.c	Mon Jan 31 02:41:48 2005
-+++ src/pl/plpgsql/src/pl_gram.c	Sun Feb 20 02:19:34 2005
-@@ -191,7 +191,7 @@
-  *						  procedural language
-  *
-  * IDENTIFICATION
-- *	  $PostgreSQL: pgsql/src/pl/plpgsql/src/gram.y,v 1.64.4.1 2005/01/21 00:17:02 neilc Exp $
-+ *	  $PostgreSQL: pgsql/src/pl/plpgsql/src/gram.y,v 1.64.4.2 2005/02/07 03:52:22 neilc Exp $
-  *
-  *	  This software is copyrighted by Jan Wieck - Hamburg.
-  *
-@@ -3426,8 +3412,19 @@
- 						 errmsg("missing \"%s\" at end of SQL statement",
- 								expected)));
- 		}
-+
- 		if (plpgsql_SpaceScanned)
- 			plpgsql_dstring_append(&ds, " ");
-+
-+		/* Check for array overflow */
-+		if (nparams >= 1024)
-+		{
-+			plpgsql_error_lineno = lno;
-+			ereport(ERROR,
-+					(errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
-+					 errmsg("too many variables specified in SQL statement")));
-+		}
-+
- 		switch (tok)
- 		{
- 			case T_SCALAR:
-@@ -3600,6 +3597,15 @@
- 
- 					while ((tok = plpgsql_yylex()) == ',')
- 					{
-+						/* Check for array overflow */
-+						if (nfields >= 1024)
-+						{
-+							plpgsql_error_lineno = plpgsql_scanner_lineno();
-+							ereport(ERROR,
-+									(errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
-+									 errmsg("too many INTO variables specified")));
-+						}
-+
- 						tok = plpgsql_yylex();
- 						switch(tok)
- 						{
-@@ -3650,6 +3656,16 @@
- 
- 		if (plpgsql_SpaceScanned)
- 			plpgsql_dstring_append(&ds, " ");
-+
-+		/* Check for array overflow */
-+		if (nparams >= 1024)
-+		{
-+			plpgsql_error_lineno = plpgsql_scanner_lineno();
-+			ereport(ERROR,
-+					(errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
-+					 errmsg("too many variables specified in SQL statement")));
-+		}
-+
- 		switch (tok)
- 		{
- 			case T_SCALAR:
-@@ -3745,6 +3761,15 @@
- 
- 				while ((tok = plpgsql_yylex()) == ',')
- 				{
-+					/* Check for array overflow */
-+					if (nfields >= 1024)
-+					{
-+						plpgsql_error_lineno = plpgsql_scanner_lineno();
-+						ereport(ERROR,
-+								(errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
-+								 errmsg("too many INTO variables specified")));
-+					}
-+
- 					tok = plpgsql_yylex();
- 					switch(tok)
- 					{
---- src/pl/plpgsql/src/pl.tab.h.orig	Sun Feb 20 06:27:24 2005
-+++ src/pl/plpgsql/src/pl.tab.h	Sun Feb 20 06:27:34 2005
-@@ -209,7 +209,7 @@
- 		PLpgSQL_exceptions		*exceptions;
- 		PLpgSQL_nsitem			*nsitem;
- } PLPGSQL_YYSTYPE;
--/* Line 1248 of yacc.c.  */
-+/* Line 1238 of yacc.c.  */
- #line 213 "y.tab.h"
- # define plpgsql_yystype PLPGSQL_YYSTYPE /* obsolescent; will be withdrawn */
- # define PLPGSQL_YYSTYPE_IS_DECLARED 1