[pkgsrc/trunk]: pkgsrc/databases/postgresql80-plpython Import databases/postg...

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/4e2758858c97
branches:  trunk
changeset: 497861:4e2758858c97
user:      jlam <jlam%pkgsrc.org@localhost>
date:      Sat Aug 06 06:25:12 2005 +0000

description:
Import databases/postgresql80-plpython-8.0.3.

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.

diffstat:

 databases/postgresql80-plpython/DESCR    |   9 +++++++++
 databases/postgresql80-plpython/MESSAGE  |  17 +++++++++++++++++
 databases/postgresql80-plpython/Makefile |  21 +++++++++++++++++++++
 databases/postgresql80-plpython/PLIST    |   2 ++
 4 files changed, 49 insertions(+), 0 deletions(-)

diffs (65 lines):

diff -r 886943de86cd -r 4e2758858c97 databases/postgresql80-plpython/DESCR
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql80-plpython/DESCR     Sat Aug 06 06:25:12 2005 +0000
@@ -0,0 +1,9 @@
+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.
diff -r 886943de86cd -r 4e2758858c97 databases/postgresql80-plpython/MESSAGE
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql80-plpython/MESSAGE   Sat Aug 06 06:25:12 2005 +0000
@@ -0,0 +1,17 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1.1.1 2005/08/06 06:25:12 jlam 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>
+
+===========================================================================
diff -r 886943de86cd -r 4e2758858c97 databases/postgresql80-plpython/Makefile
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql80-plpython/Makefile  Sat Aug 06 06:25:12 2005 +0000
@@ -0,0 +1,21 @@
+# $NetBSD: Makefile,v 1.1.1.1 2005/08/06 06:25:12 jlam Exp $
+
+PKGNAME=       postgresql80-plpython-${BASE_VERS}
+COMMENT=       PL/Python procedural language for the PostgreSQL backend
+
+DEPENDS+=      postgresql80-server>=${BASE_VERS}:../../databases/postgresql80-server
+
+.include "../../databases/postgresql80/Makefile.common"
+
+CONFIGURE_ARGS+=       --with-python
+CONFIGURE_ENV+=                PYTHON="${PYTHONBIN}"
+
+BUILD_DIRS=            ${WRKSRC}/src/pl/plpython
+
+USE_LIBTOOL=           yes
+PKG_LIBTOOL=           ${PKG_SHLIBTOOL}
+
+.include "../../databases/postgresql80-client/buildlink3.mk"
+.include "../../lang/python/extension.mk"
+
+.include "../../mk/bsd.pkg.mk"
diff -r 886943de86cd -r 4e2758858c97 databases/postgresql80-plpython/PLIST
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql80-plpython/PLIST     Sat Aug 06 06:25:12 2005 +0000
@@ -0,0 +1,2 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2005/08/06 06:25:12 jlam Exp $
+${PG_SUBPREFIX}lib/postgresql/plpython.la