[pkgsrc/trunk]: pkgsrc Add package for PostgreSQL 7.4.5 PL/Python. PL/Python ...

[jdolecek <jdolecek%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/11dc9afec759
branches:  trunk
changeset: 481693:11dc9afec759
user:      jdolecek <jdolecek%pkgsrc.org@localhost>
date:      Sun Oct 10 12:38:21 2004 +0000

description:
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.

diffstat:

 databases/Makefile                       |   3 ++-
 databases/postgresql74-plpython/DESCR    |   5 +++++
 databases/postgresql74-plpython/MESSAGE  |  20 ++++++++++++++++++++
 databases/postgresql74-plpython/Makefile |  21 +++++++++++++++++++++
 databases/postgresql74-plpython/PLIST    |   2 ++
 doc/CHANGES                              |   3 ++-
 6 files changed, 52 insertions(+), 2 deletions(-)

diffs (95 lines):

diff -r c6f2cda59d0d -r 11dc9afec759 databases/Makefile
--- a/databases/Makefile        Sun Oct 10 12:33:35 2004 +0000
+++ b/databases/Makefile        Sun Oct 10 12:38:21 2004 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.141 2004/09/05 18:43:19 wiz Exp $
+# $NetBSD: Makefile,v 1.142 2004/10/10 12:41:02 jdolecek Exp $
 #
 
 COMMENT=       Databases
@@ -99,6 +99,7 @@
 SUBDIR+=       postgresql74-contrib
 SUBDIR+=       postgresql74-docs
 SUBDIR+=       postgresql74-lib
+SUBDIR+=       postgresql74-plpython
 SUBDIR+=       postgresql74-server
 SUBDIR+=       pxtools
 SUBDIR+=       py-IndexedCatalog
diff -r c6f2cda59d0d -r 11dc9afec759 databases/postgresql74-plpython/DESCR
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql74-plpython/DESCR     Sun Oct 10 12:38:21 2004 +0000
@@ -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 -r c6f2cda59d0d -r 11dc9afec759 databases/postgresql74-plpython/MESSAGE
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql74-plpython/MESSAGE   Sun Oct 10 12:38:21 2004 +0000
@@ -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 -r c6f2cda59d0d -r 11dc9afec759 databases/postgresql74-plpython/Makefile
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql74-plpython/Makefile  Sun Oct 10 12:38:21 2004 +0000
@@ -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 -r c6f2cda59d0d -r 11dc9afec759 databases/postgresql74-plpython/PLIST
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql74-plpython/PLIST     Sun Oct 10 12:38:21 2004 +0000
@@ -0,0 +1,2 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2004/10/10 12:38:21 jdolecek Exp $
+lib/postgresql/plpython.so
diff -r c6f2cda59d0d -r 11dc9afec759 doc/CHANGES
--- a/doc/CHANGES       Sun Oct 10 12:33:35 2004 +0000
+++ b/doc/CHANGES       Sun Oct 10 12:38:21 2004 +0000
@@ -1,4 +1,4 @@
-$NetBSD: CHANGES,v 1.7390 2004/10/10 12:32:14 wiz Exp $
+$NetBSD: CHANGES,v 1.7391 2004/10/10 12:41:02 jdolecek Exp $
 
 Changes to the packages collection and infrastructure in 2004:
 
@@ -4600,3 +4600,4 @@
        Updated pkgdiff to 0.115 [dillo 2004-10-10]
        Added p5-POE-0.29 [minskim 2004-10-10]
        Updated cdparanoia to 3.0.9.8nb2 [mycroft 2004-10-10]
+       Added postgresql74-plpython 7.4.5 [jdolecek 2004-10-10]