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)

1 files changed, 31 insertions, 2 deletions

diff --git a/databases/postgresql83-server/Makefile b/databases/postgresql83-server/Makefile
index 4825ec4d2984..87b62c38f9f4 100644
--- a/databases/postgresql83-server/Makefile
+++ b/databases/postgresql83-server/Makefile
@@ -7,8 +7,8 @@
 
 PORTNAME?=	postgresql
 PKGNAMESUFFIX?=	-server
-PORTVERSION?=	8.0.1
-PORTREVISION?=	3
+PORTVERSION?=	8.0.2
+PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
@@ -89,10 +89,39 @@ OPTIONS+=	LIBC_R "Link w/ libc_r, used by plpython (server)" off
 OPTIONS+=	TESTS "Allows the use of a \"check\" target (server)" off
 OPTIONS+=	DEBUG "Builds with debugging symbols" off
 
+# See http://people.freebsd.org/~girgen/postgresql-icu/README.html for more info
+OPTIONS+=	ICU   "Use ICU for unicode collation (server)" off
+
+# See http://gppl.moonbone.ru/ for more info
+OPTIONS+=	HIER  "Builds with query hierarchy (server)" off
+
+# See http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/76999 for more info
+# (requires dump/restore if modified.)
+OPTIONS+=	INTDATE "Builds with 64-bit date/time type (server)" off
+
+.  if defined(SERVER_ONLY) && defined(WITH_HIER)
+PATCH_SITES+=	http://gppl.moonbone.ru/:hier801054
+PATCHFILES+=	hier-Pg8.0.1-0.5.4.diff.gz:hier801054
+.  endif
+
+.  if defined(SERVER_ONLY) && defined(WITH_ICU)
+USE_AUTOCONF_VER=253
+CONFIGURE_ARGS+=--with-icu
+LIB_DEPENDS=	icudata.32:${PORTSDIR}/devel/icu
+PATCH_SITES+=	http://people.freebsd.org/~girgen/postgresql-icu/:icu
+PATCHFILES+=	pg-802-icu-2005-03-26.diff.gz:icu
+.  endif
+
+PATCH_DIST_STRIP=-p1
+
 .  if defined(SERVER_ONLY) && defined(WITH_PAM)
 CONFIGURE_ARGS+=--with-pam
 .  endif
 
+.  if defined(WITH_INTDATE)
+CONFIGURE_ARGS+=--enable-integer-datetimes
+.  endif
+
 . if !defined(WITHOUT_GNUGETOPT) || exists(${LOCALBASE}/include/getopt.h)
 USE_GETOPT_LONG=yes
 .  endif