pkgsrc-Changes-HG archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]
[pkgsrc/trunk]: pkgsrc/databases Changes 8.2.0:
details: https://anonhg.NetBSD.org/pkgsrc/rev/0c950edcb29c
branches: trunk
changeset: 522450:0c950edcb29c
user: adam <adam%pkgsrc.org@localhost>
date: Sat Dec 09 16:13:57 2006 +0000
description:
Changes 8.2.0:
* Query language enhancements including "INSERT/UPDATE/DELETE
RETURNING", multirow VALUES lists, and optional target-table alias
in "UPDATE"/"DELETE"
* Index creation without blocking concurrent
"INSERT"/"UPDATE"/"DELETE" operations
* Many query optimization improvements, including support for
reordering outer joins
* Improved sorting performance with lower memory usage
* More efficient locking with better concurrency
* More efficient vacuuming
* Easier administration of warm standby servers
* New FILLFACTOR support for tables and indexes
* Monitoring, logging, and performance tuning additions
* More control over creating and dropping objects
* Table inheritance relationships can be defined for and removed from
pre-existing tables
* "COPY TO" can copy the output of an arbitrary "SELECT" statement
* Array improvements, including nulls in arrays
* Aggregate-function improvements, including multiple-input
aggregates and SQL:2003 statistical functions
* Many "contrib/" improvements
diffstat:
databases/postgresql82-plperl/DESCR | 5 +++++
databases/postgresql82-plperl/MESSAGE | 7 +++++++
databases/postgresql82-plperl/Makefile | 22 ++++++++++++++++++++++
databases/postgresql82-plperl/PLIST | 2 ++
databases/postgresql82-plpython/DESCR | 9 +++++++++
databases/postgresql82-plpython/MESSAGE | 17 +++++++++++++++++
databases/postgresql82-plpython/Makefile | 21 +++++++++++++++++++++
databases/postgresql82-plpython/PLIST | 2 ++
databases/postgresql82-pltcl/DESCR | 4 ++++
databases/postgresql82-pltcl/MESSAGE | 7 +++++++
databases/postgresql82-pltcl/Makefile | 23 +++++++++++++++++++++++
databases/postgresql82-pltcl/PLIST | 6 ++++++
databases/postgresql82-tsearch2/DESCR | 6 ++++++
databases/postgresql82-tsearch2/Makefile | 17 +++++++++++++++++
databases/postgresql82-tsearch2/PLIST | 12 ++++++++++++
15 files changed, 160 insertions(+), 0 deletions(-)
diffs (220 lines):
diff -r 6cba7c133025 -r 0c950edcb29c databases/postgresql82-plperl/DESCR
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql82-plperl/DESCR Sat Dec 09 16:13:57 2006 +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 6cba7c133025 -r 0c950edcb29c databases/postgresql82-plperl/MESSAGE
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql82-plperl/MESSAGE Sat Dec 09 16:13:57 2006 +0000
@@ -0,0 +1,7 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1.1.1 2006/12/09 16:15:06 adam Exp $
+
+Please see the PL/Perl section of the PostgreSQL Programmer's Guide
+(databases/postgresql-docs) for information on programming with
+${PKGNAME}.
+===========================================================================
diff -r 6cba7c133025 -r 0c950edcb29c databases/postgresql82-plperl/Makefile
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql82-plperl/Makefile Sat Dec 09 16:13:57 2006 +0000
@@ -0,0 +1,22 @@
+# $NetBSD: Makefile,v 1.1.1.1 2006/12/09 16:15:06 adam Exp $
+
+PKGNAME= postgresql82-plperl-${BASE_VERS}
+COMMENT= PL/Perl procedural language for the PostgreSQL backend
+
+DEPENDS+= postgresql82-server>=${BASE_VERS}:../../databases/postgresql82-server
+
+.include "../../databases/postgresql82/Makefile.common"
+
+PERL5_CONFIGURE= no
+CONFIGURE_ARGS+= --with-perl
+
+BUILD_DIRS= ${WRKSRC}/src/pl/plperl
+MAKE_FILE= GNUmakefile
+
+USE_LIBTOOL= yes
+PKG_LIBTOOL= ${PKG_SHLIBTOOL}
+
+.include "../../databases/postgresql82-client/buildlink3.mk"
+.include "../../lang/perl5/module.mk"
+
+.include "../../mk/bsd.pkg.mk"
diff -r 6cba7c133025 -r 0c950edcb29c databases/postgresql82-plperl/PLIST
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql82-plperl/PLIST Sat Dec 09 16:13:57 2006 +0000
@@ -0,0 +1,2 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2006/12/09 16:15:06 adam Exp $
+${PG_SUBPREFIX}lib/postgresql/plperl.la
diff -r 6cba7c133025 -r 0c950edcb29c databases/postgresql82-plpython/DESCR
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql82-plpython/DESCR Sat Dec 09 16:13:57 2006 +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 6cba7c133025 -r 0c950edcb29c databases/postgresql82-plpython/MESSAGE
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql82-plpython/MESSAGE Sat Dec 09 16:13:57 2006 +0000
@@ -0,0 +1,17 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1.1.1 2006/12/09 16:14:23 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>
+
+===========================================================================
diff -r 6cba7c133025 -r 0c950edcb29c databases/postgresql82-plpython/Makefile
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql82-plpython/Makefile Sat Dec 09 16:13:57 2006 +0000
@@ -0,0 +1,21 @@
+# $NetBSD: Makefile,v 1.1.1.1 2006/12/09 16:14:23 adam Exp $
+
+PKGNAME= postgresql82-plpython-${BASE_VERS}
+COMMENT= PL/Python procedural language for the PostgreSQL backend
+
+DEPENDS+= postgresql82-server>=${BASE_VERS}:../../databases/postgresql82-server
+
+.include "../../databases/postgresql82/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/postgresql82-client/buildlink3.mk"
+.include "../../lang/python/extension.mk"
+
+.include "../../mk/bsd.pkg.mk"
diff -r 6cba7c133025 -r 0c950edcb29c databases/postgresql82-plpython/PLIST
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql82-plpython/PLIST Sat Dec 09 16:13:57 2006 +0000
@@ -0,0 +1,2 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2006/12/09 16:14:23 adam Exp $
+${PG_SUBPREFIX}lib/postgresql/plpython.la
diff -r 6cba7c133025 -r 0c950edcb29c databases/postgresql82-pltcl/DESCR
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql82-pltcl/DESCR Sat Dec 09 16:13:57 2006 +0000
@@ -0,0 +1,4 @@
+PL/Tcl is a dynamic loadable extension for the PostgreSQL database system
+that enables the Tcl language to be used to create functions and
+trigger-procedures. It offers most of the capabilities a function
+writer has in the C language.
diff -r 6cba7c133025 -r 0c950edcb29c databases/postgresql82-pltcl/MESSAGE
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql82-pltcl/MESSAGE Sat Dec 09 16:13:57 2006 +0000
@@ -0,0 +1,7 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1.1.1 2006/12/09 16:14:46 adam Exp $
+
+Please see the PL/Tcl section of the PostgreSQL Programmer's Guide
+(databases/postgresql-docs) for information on programming with
+${PKGNAME}.
+===========================================================================
diff -r 6cba7c133025 -r 0c950edcb29c databases/postgresql82-pltcl/Makefile
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql82-pltcl/Makefile Sat Dec 09 16:13:57 2006 +0000
@@ -0,0 +1,23 @@
+# $NetBSD: Makefile,v 1.1.1.1 2006/12/09 16:14:46 adam Exp $
+
+PKGNAME= postgresql82-pltcl-${BASE_VERS}
+COMMENT= PL/Tcl procedural language for the PostgreSQL backend
+
+DEPENDS+= postgresql82-server>=${BASE_VERS}:../../databases/postgresql82-server
+
+.include "../../databases/postgresql82/Makefile.common"
+
+CONFIGURE_ARGS+= --with-tcl
+CONFIGURE_ARGS+= --with-tclconfig="${BUILDLINK_PREFIX.tcl}/lib"
+CONFIGURE_ENV+= TCLSH="${TCLSH}"
+TCLSH= ${BUILDLINK_PREFIX.tcl}/bin/tclsh
+
+BUILD_DIRS= ${WRKSRC}/src/pl/tcl
+
+USE_LIBTOOL= yes
+PKG_LIBTOOL= ${PKG_SHLIBTOOL}
+
+.include "../../databases/postgresql82-client/buildlink3.mk"
+.include "../../lang/tcl/buildlink3.mk"
+
+.include "../../mk/bsd.pkg.mk"
diff -r 6cba7c133025 -r 0c950edcb29c databases/postgresql82-pltcl/PLIST
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql82-pltcl/PLIST Sat Dec 09 16:13:57 2006 +0000
@@ -0,0 +1,6 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2006/12/09 16:14:46 adam Exp $
+${PG_SUBPREFIX}bin/pltcl_delmod
+${PG_SUBPREFIX}bin/pltcl_listmod
+${PG_SUBPREFIX}bin/pltcl_loadmod
+${PG_SUBPREFIX}lib/postgresql/pltcl.la
+${PG_SUBPREFIX}share/postgresql/unknown.pltcl
diff -r 6cba7c133025 -r 0c950edcb29c databases/postgresql82-tsearch2/DESCR
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql82-tsearch2/DESCR Sat Dec 09 16:13:57 2006 +0000
@@ -0,0 +1,6 @@
+The Tsearch2 contrib module contains an implementation of a new data
+type tsvector - a searchable data type with indexed access. In a
+nutshell, tsvector is a set of unique words along with their
+positional information in the document, organized in a special
+structure optimized for fast access and lookup. This data type can
+be used as backend for efficient full text search engines.
diff -r 6cba7c133025 -r 0c950edcb29c databases/postgresql82-tsearch2/Makefile
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql82-tsearch2/Makefile Sat Dec 09 16:13:57 2006 +0000
@@ -0,0 +1,17 @@
+# $NetBSD: Makefile,v 1.1.1.1 2006/12/09 16:13:57 adam Exp $
+
+PKGNAME= postgresql82-tsearch2-${BASE_VERS}
+COMMENT= Tsearch2 contrib module for fulltext indexing in PostgreSQL
+
+DEPENDS+= postgresql82-server>=${BASE_VERS}:../../databases/postgresql82-server
+
+.include "../../databases/postgresql82/Makefile.common"
+
+BUILD_DIRS= contrib/tsearch2/snowball contrib/tsearch2
+
+USE_LIBTOOL= yes
+PKG_LIBTOOL= ${PKG_SHLIBTOOL}
+
+.include "../../databases/postgresql82-client/buildlink3.mk"
+
+.include "../../mk/bsd.pkg.mk"
diff -r 6cba7c133025 -r 0c950edcb29c databases/postgresql82-tsearch2/PLIST
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql82-tsearch2/PLIST Sat Dec 09 16:13:57 2006 +0000
@@ -0,0 +1,12 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2006/12/09 16:13:57 adam Exp $
+${PG_SUBPREFIX}lib/postgresql/libtsearch2.la
+${PG_SUBPREFIX}share/doc/postgresql/contrib/README.tsearch2
+${PG_SUBPREFIX}share/postgresql/contrib/english.stop
+${PG_SUBPREFIX}share/postgresql/contrib/russian.stop
+${PG_SUBPREFIX}share/postgresql/contrib/russian.stop.utf8
+${PG_SUBPREFIX}share/postgresql/contrib/thesaurus
+${PG_SUBPREFIX}share/postgresql/contrib/tsearch2.sql
+${PG_SUBPREFIX}share/postgresql/contrib/uninstall_tsearch2.sql
+@dirrm share/postgresql/contrib
+@dirrm share/doc/postgresql/contrib
+@dirrm lib/postgresql
Home |
Main Index |
Thread Index |
Old Index