Add package for PostgreSQL 7.4.5 PL/Python. PL/Python procedural language

allows PostgreSQL functions to be written in Python language.

Fixes PR pkg/23349 by Michal Pasternak.

4 files changed, 48 insertions, 0 deletions

diff --git a/databases/postgresql74-plpython/DESCR b/databases/postgresql74-plpython/DESCR
new file mode 100644
index 00000000000..9057591c0ba
--- /dev/null
+++ b/databases/postgresql74-plpython/DESCR
@@ -0,0 +1,5 @@
+PL/Perl allows you to write functions in the Perl programming language
+that may be used in SQL queries as if they were built into Postgres.
+The PL/Perl intepreter is a full Perl interpreter.  However, certain
+operations have been disabled in order to maintain the security of the
+system.
diff --git a/databases/postgresql74-plpython/MESSAGE b/databases/postgresql74-plpython/MESSAGE
new file mode 100644
index 00000000000..c1a3dee898c
--- /dev/null
+++ b/databases/postgresql74-plpython/MESSAGE
@@ -0,0 +1,20 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1.1.1 2004/10/10 12:38:21 jdolecek 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 configure PostgreSQL to enable PL/Python, run this as DBA:
+
+CREATE FUNCTION plpython_call_handler() RETURNS language_handler AS
+	'$libdir/plpython' LANGUAGE C;
+
+CREATE PROCEDURAL LANGUAGE plpythonu HANDLER plpython_call_handler;
+
+===========================================================================
diff --git a/databases/postgresql74-plpython/Makefile b/databases/postgresql74-plpython/Makefile
new file mode 100644
index 00000000000..472e07532fd
--- /dev/null
+++ b/databases/postgresql74-plpython/Makefile
@@ -0,0 +1,21 @@
+# $NetBSD: Makefile,v 1.1.1.1 2004/10/10 12:38:21 jdolecek Exp $
+
+PKGNAME=		postgresql74-plpython-${BASE_VERS}
+COMMENT=		PL/Python procedural language for the PostgreSQL backend
+
+DEPENDS+=	postgresql74-server>=${BASE_VERS}:../../databases/postgresql74-server
+
+USE_BUILDLINK3=		yes
+
+.include "../postgresql74/Makefile.common"
+
+CONFIGURE_ARGS+=	--with-openssl=${SSLBASE}
+CONFIGURE_ARGS+=	--with-python
+
+BUILD_DIRS=		${WRKSRC}/src/pl/plpython
+
+.include "../../security/openssl/buildlink3.mk"
+.include "../postgresql74-lib/buildlink3.mk"
+.include "../../lang/python/extension.mk"
+
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql74-plpython/PLIST b/databases/postgresql74-plpython/PLIST
new file mode 100644
index 00000000000..b08db33bd1b
--- /dev/null
+++ b/databases/postgresql74-plpython/PLIST
@@ -0,0 +1,2 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2004/10/10 12:38:21 jdolecek Exp $
+lib/postgresql/plpython.so