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

Status:

Vendor Tag:	TNF
Release Tags:	pkgsrc-base


(adam)

PL/Python allows you to write functions in the Python programming
language that may be used in SQL queries as if they were built into
Postgres.  The PL/Python intepreter is a full Python interpreter.

PL/Python is currently only available as an "untrusted" language
(meaning it does not offer any way of restricting what users can do
in it).  It has therefore been named "plpythonu".  The trusted variant
plpython may become available again in future, if a new secure execution
mechanism is developed in Python.

# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:31:43 adam Exp $

PKGNAME=	${DISTNAME:C/-/91-plpython-/}
COMMENT=	PL/Python procedural language for the PostgreSQL backend

PKG_DESTDIR_SUPPORT=	user-destdir

DEPENDS+=	postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server

.include "../../databases/postgresql91/Makefile.common"

CONFIGURE_ARGS+=	--with-python
CONFIGURE_ENV+=		PYTHON="${PYTHONBIN}"
BUILD_MAKE_FLAGS=	PGXS=1

BUILD_DIRS=		src/pl/plpython

.include "../../databases/postgresql91-client/buildlink3.mk"
.include "../../lang/python/extension.mk"
.include "../../mk/bsd.pkg.mk"

===========================================================================
$NetBSD: MESSAGE,v 1.1.1.1 2011/09/15 08:31:43 adam Exp $

Please see the PL/Python section of the PostgreSQL Programmer's Guide
(databases/postgresql-docs) for information on programming with
${PKGNAME}.

Note that PL/Python is unrestricted language, meaning it does not
offer any way of restricting what users can do in it.  Any DB user with
access to PL/Python can run arbitrary Python code under privileges
of the PostgreSQL server process.

To enable PL/Python for database <dbname>, run following:

createlang plpythonu <dbname>

===========================================================================

@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:31:43 adam Exp $
lib/postgresql/plpython2.so
share/locale/cs/LC_MESSAGES/plpython-9.1.mo
share/locale/de/LC_MESSAGES/plpython-9.1.mo
share/locale/es/LC_MESSAGES/plpython-9.1.mo
share/locale/fr/LC_MESSAGES/plpython-9.1.mo
share/locale/ja/LC_MESSAGES/plpython-9.1.mo
share/locale/pl/LC_MESSAGES/plpython-9.1.mo
share/locale/pt_BR/LC_MESSAGES/plpython-9.1.mo
share/locale/ro/LC_MESSAGES/plpython-9.1.mo
share/locale/tr/LC_MESSAGES/plpython-9.1.mo
share/locale/zh_CN/LC_MESSAGES/plpython-9.1.mo
share/locale/zh_TW/LC_MESSAGES/plpython-9.1.mo
share/postgresql/extension/plpython2u--1.0.sql
share/postgresql/extension/plpython2u--unpackaged--1.0.sql
share/postgresql/extension/plpython2u.control
share/postgresql/extension/plpython3u--1.0.sql
share/postgresql/extension/plpython3u--unpackaged--1.0.sql
share/postgresql/extension/plpython3u.control
share/postgresql/extension/plpythonu--1.0.sql
share/postgresql/extension/plpythonu--unpackaged--1.0.sql
share/postgresql/extension/plpythonu.control