[pkgsrc/trunk]: pkgsrc/databases/postgresql74-plperl Import postgresql74-plpe...

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/22fdc341828f
branches:  trunk
changeset: 481689:22fdc341828f
user:      jdolecek <jdolecek%pkgsrc.org@localhost>
date:      Sun Oct 10 12:24:10 2004 +0000

description:
Import postgresql74-plperl. This is mostly for reference unfortunately.
If perl is built with thread support, loading the language module would
crash PostgreSQL on NetBSD - loading shared module linked against libpthread
doesn't work if the main binary isn't linked against libpthread.

For this reason, this package is currently marked as BROKEN, and only
here to save packaging work for person who'd want to finish this.

diffstat:

 databases/postgresql74-plperl/DESCR    |   5 ++++
 databases/postgresql74-plperl/MESSAGE  |   7 ++++++
 databases/postgresql74-plperl/Makefile |  39 ++++++++++++++++++++++++++++++++++
 databases/postgresql74-plperl/PLIST    |   2 +
 4 files changed, 53 insertions(+), 0 deletions(-)

diffs (69 lines):

diff -r 9a438f110444 -r 22fdc341828f databases/postgresql74-plperl/DESCR
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql74-plperl/DESCR       Sun Oct 10 12:24:10 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 9a438f110444 -r 22fdc341828f databases/postgresql74-plperl/MESSAGE
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql74-plperl/MESSAGE     Sun Oct 10 12:24:10 2004 +0000
@@ -0,0 +1,7 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1.1.1 2004/10/10 12:24:10 jdolecek Exp $
+
+Please see the PL/Perl section of the PostgreSQL Programmer's Guide
+(databases/postgresql-docs) for information on programming with
+${PKGNAME}.
+===========================================================================
diff -r 9a438f110444 -r 22fdc341828f databases/postgresql74-plperl/Makefile
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql74-plperl/Makefile    Sun Oct 10 12:24:10 2004 +0000
@@ -0,0 +1,39 @@
+# $NetBSD: Makefile,v 1.1.1.1 2004/10/10 12:24:10 jdolecek Exp $
+
+PKGNAME=               postgresql74-plperl-${BASE_VERS}
+COMMENT=               PL/Perl 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-perl
+
+LIBPERL_DIR=           ${PREFIX}/${PERL5_SUB_INSTALLARCHLIB}/CORE
+LDFLAGS+=              -Wl,-R${LIBPERL_DIR}
+
+BUILD_DIRS=            ${WRKSRC}/src/pl/plperl
+MAKEFILE=              GNUmakefile
+
+PERL5_CONFIGURE=       NO
+
+# On my 2.x system perl 5.8.4's perl & libperl.so are linked with libpthread,
+# thus the module would get linked to libpthread too. Since postmaster is not
+# threaded, loading the language will crash the SQL server.
+BROKEN=                        "crashes PostgreSQL when compiled with threaded Perl"
+
+# XXX this package requires modification of the link flags to add the
+# directory with libperl.so to the runtime library search path. Since
+# this is currently broken anyway, appropriate patch for src/Makefile.global.in
+# has not been included.
+
+.include "../../security/openssl/buildlink3.mk"
+BUILDLINK_DEPMETHOD.libperl+=  build
+.include "../postgresql74-lib/buildlink3.mk"
+.include "../../lang/libperl/buildlink3.mk"
+.include "../../lang/perl5/module.mk"
+
+.include "../../mk/bsd.pkg.mk"
diff -r 9a438f110444 -r 22fdc341828f databases/postgresql74-plperl/PLIST
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql74-plperl/PLIST       Sun Oct 10 12:24:10 2004 +0000
@@ -0,0 +1,2 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2004/10/10 12:24:10 jdolecek Exp $
+lib/postgresql/plperl.so