Version 9.1 delivers several features which users have been requesting for

years, removing roadblocks to deploying new or ported applications on
PostgreSQL. These include:
* Synchronous Replication: enable high-availability with consistency across
  multiple servers
* Per-Column Collations: support linguistically-correct sorting per database,
  table or column.
* Unlogged Tables: greatly improves performance for ephemeral data

Our community of contributors innovates with cutting-edge features. Version 9.1
includes several which are new to the database industry, such as:
* K-Nearest-Neighbor Indexing: index on "distance" for faster location and text
  search queries
* Serializable Snapshot Isolation: keeps concurrent transactions consistent
  without blocking, using "true serializability"
* Writeable Common Table Expressions: execute complex multi-stage data updates
  in a single query
* Security-Enhanced Postgres: deploy military-grade security and Mandatory
  Access Control

3 files changed, 105 insertions, 0 deletions

diff --git a/databases/postgresql91-datatypes/DESCR b/databases/postgresql91-datatypes/DESCR
new file mode 100644
index 00000000000..0fd1fb2d6cd
--- /dev/null
+++ b/databases/postgresql91-datatypes/DESCR
@@ -0,0 +1,43 @@
+This package provides the following PostgreSQL modules:
+  - citext
+  - hstore
+  - intarray
+  - isn
+  - ltree
+  - lo
+  - uuid-ossp
+  - unaccent
+
+The "citext" module provides a case-insensitive character string type,
+citext. Essentially, it internally calls lower when comparing values.
+Otherwise, it behaves almost exactly like text.
+
+The "hstore" module implements the "hstore" data type for storing sets
+of key/value pairs within a single PostgreSQL value. This can be useful
+in various scenarios, such as rows with many attributes that are rarely
+examined, or semi-structured data. Keys and values are simply text strings.
+
+The "intarray" module provides a number of useful functions and operators
+for manipulating one-dimensional arrays of integers. There is also support
+for indexed searches using some of the operators.
+
+The "isn" module provides data types for the following international
+product numbering standards: EAN13, UPC, ISBN (books), ISMN (music),
+and ISSN (serials). Numbers are validated on input, and correctly
+hyphenated on output.
+
+The "ltree" module implements a data type ltree for representing
+labels of data stored in a hierarchical tree-like structure.
+Extensive facilities for searching through label trees are provided.
+
+The "lo" module provides support for managing Large Objects (also called
+LOs or BLOBs). This includes a data type "lo" and a trigger "lo_manage."
+
+The "uuid-ossp" module provides functions to generate universally unique
+identifiers (UUIDs) using one of several standard algorithms. There are
+also functions to produce certain special UUID constants.
+
+"unaccent" is a text search dictionary that removes accents (diacritic signs)
+from lexemes. It's a filtering dictionary, which means its output is always
+passed to the next dictionary (if any), unlike the normal behavior of
+dictionaries. This allows accent-insensitive processing for full text search.
diff --git a/databases/postgresql91-datatypes/Makefile b/databases/postgresql91-datatypes/Makefile
new file mode 100644
index 00000000000..90ab4336b64
--- /dev/null
+++ b/databases/postgresql91-datatypes/Makefile
@@ -0,0 +1,28 @@
+# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:30:08 adam Exp $
+
+PKGNAME=	${DISTNAME:C/-/91-datatypes-/}
+COMMENT=	PostgreSQL data types support modules
+
+PKG_DESTDIR_SUPPORT=	user-destdir
+
+DEPENDS+=	postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server
+
+.include "../../databases/postgresql91/Makefile.common"
+
+CONFIGURE_ARGS+=	--with-ossp-uuid
+# because global pg_config.h is included, we have to define this
+CPPFLAGS+=		-DHAVE_UUID_H
+
+BUILD_DIRS+=		contrib/citext
+BUILD_DIRS+=		contrib/hstore
+BUILD_DIRS+=		contrib/intarray
+BUILD_DIRS+=		contrib/isn
+BUILD_DIRS+=		contrib/ltree
+BUILD_DIRS+=		contrib/lo
+BUILD_DIRS+=		contrib/uuid-ossp
+BUILD_DIRS+=		contrib/unaccent
+BUILD_MAKE_FLAGS=	PGXS=1
+
+.include "../../databases/postgresql91-client/buildlink3.mk"
+.include "../../devel/ossp-uuid/buildlink3.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql91-datatypes/PLIST b/databases/postgresql91-datatypes/PLIST
new file mode 100644
index 00000000000..31d3f5deaa0
--- /dev/null
+++ b/databases/postgresql91-datatypes/PLIST
@@ -0,0 +1,34 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:30:08 adam Exp $
+lib/postgresql/_int.so
+lib/postgresql/citext.so
+lib/postgresql/hstore.so
+lib/postgresql/isn.so
+lib/postgresql/lo.so
+lib/postgresql/ltree.so
+lib/postgresql/unaccent.so
+lib/postgresql/uuid-ossp.so
+share/postgresql/extension/citext--1.0.sql
+share/postgresql/extension/citext--unpackaged--1.0.sql
+share/postgresql/extension/citext.control
+share/postgresql/extension/hstore--1.0.sql
+share/postgresql/extension/hstore--unpackaged--1.0.sql
+share/postgresql/extension/hstore.control
+share/postgresql/extension/intarray--1.0.sql
+share/postgresql/extension/intarray--unpackaged--1.0.sql
+share/postgresql/extension/intarray.control
+share/postgresql/extension/isn--1.0.sql
+share/postgresql/extension/isn--unpackaged--1.0.sql
+share/postgresql/extension/isn.control
+share/postgresql/extension/lo--1.0.sql
+share/postgresql/extension/lo--unpackaged--1.0.sql
+share/postgresql/extension/lo.control
+share/postgresql/extension/ltree--1.0.sql
+share/postgresql/extension/ltree--unpackaged--1.0.sql
+share/postgresql/extension/ltree.control
+share/postgresql/extension/unaccent--1.0.sql
+share/postgresql/extension/unaccent--unpackaged--1.0.sql
+share/postgresql/extension/unaccent.control
+share/postgresql/extension/uuid-ossp--1.0.sql
+share/postgresql/extension/uuid-ossp--unpackaged--1.0.sql
+share/postgresql/extension/uuid-ossp.control
+share/postgresql/tsearch_data/unaccent.rules