diff options
author | adam <adam> | 2006-12-09 16:13:57 +0000 |
---|---|---|
committer | adam <adam> | 2006-12-09 16:13:57 +0000 |
commit | 09e4eed0ffe4a89efb99d172f14a286b599470d1 (patch) | |
tree | fb650d7c4a34eb86ae6950930a1957f5c77d8217 /databases | |
parent | a514b2702bf03d383c37bc2bf778ab57060bb765 (diff) | |
download | pkgsrc-09e4eed0ffe4a89efb99d172f14a286b599470d1.tar.gz |
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 (limited to 'databases')
-rw-r--r-- | databases/postgresql82-plperl/DESCR | 5 | ||||
-rw-r--r-- | databases/postgresql82-plperl/MESSAGE | 7 | ||||
-rw-r--r-- | databases/postgresql82-plperl/Makefile | 22 | ||||
-rw-r--r-- | databases/postgresql82-plperl/PLIST | 2 | ||||
-rw-r--r-- | databases/postgresql82-plpython/DESCR | 9 | ||||
-rw-r--r-- | databases/postgresql82-plpython/MESSAGE | 17 | ||||
-rw-r--r-- | databases/postgresql82-plpython/Makefile | 21 | ||||
-rw-r--r-- | databases/postgresql82-plpython/PLIST | 2 | ||||
-rw-r--r-- | databases/postgresql82-pltcl/DESCR | 4 | ||||
-rw-r--r-- | databases/postgresql82-pltcl/MESSAGE | 7 | ||||
-rw-r--r-- | databases/postgresql82-pltcl/Makefile | 23 | ||||
-rw-r--r-- | databases/postgresql82-pltcl/PLIST | 6 | ||||
-rw-r--r-- | databases/postgresql82-tsearch2/DESCR | 6 | ||||
-rw-r--r-- | databases/postgresql82-tsearch2/Makefile | 17 | ||||
-rw-r--r-- | databases/postgresql82-tsearch2/PLIST | 12 |
15 files changed, 160 insertions, 0 deletions
diff --git a/databases/postgresql82-plperl/DESCR b/databases/postgresql82-plperl/DESCR new file mode 100644 index 00000000000..9057591c0ba --- /dev/null +++ b/databases/postgresql82-plperl/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/postgresql82-plperl/MESSAGE b/databases/postgresql82-plperl/MESSAGE new file mode 100644 index 00000000000..8180a231764 --- /dev/null +++ b/databases/postgresql82-plperl/MESSAGE @@ -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 --git a/databases/postgresql82-plperl/Makefile b/databases/postgresql82-plperl/Makefile new file mode 100644 index 00000000000..2fbc738d43a --- /dev/null +++ b/databases/postgresql82-plperl/Makefile @@ -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 --git a/databases/postgresql82-plperl/PLIST b/databases/postgresql82-plperl/PLIST new file mode 100644 index 00000000000..c6fc40664fe --- /dev/null +++ b/databases/postgresql82-plperl/PLIST @@ -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 --git a/databases/postgresql82-plpython/DESCR b/databases/postgresql82-plpython/DESCR new file mode 100644 index 00000000000..142bb15309d --- /dev/null +++ b/databases/postgresql82-plpython/DESCR @@ -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 --git a/databases/postgresql82-plpython/MESSAGE b/databases/postgresql82-plpython/MESSAGE new file mode 100644 index 00000000000..452dd11607a --- /dev/null +++ b/databases/postgresql82-plpython/MESSAGE @@ -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 --git a/databases/postgresql82-plpython/Makefile b/databases/postgresql82-plpython/Makefile new file mode 100644 index 00000000000..9ce53c0a684 --- /dev/null +++ b/databases/postgresql82-plpython/Makefile @@ -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 --git a/databases/postgresql82-plpython/PLIST b/databases/postgresql82-plpython/PLIST new file mode 100644 index 00000000000..21fbc4c551d --- /dev/null +++ b/databases/postgresql82-plpython/PLIST @@ -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 --git a/databases/postgresql82-pltcl/DESCR b/databases/postgresql82-pltcl/DESCR new file mode 100644 index 00000000000..e1aca2980b9 --- /dev/null +++ b/databases/postgresql82-pltcl/DESCR @@ -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 --git a/databases/postgresql82-pltcl/MESSAGE b/databases/postgresql82-pltcl/MESSAGE new file mode 100644 index 00000000000..ec394622bba --- /dev/null +++ b/databases/postgresql82-pltcl/MESSAGE @@ -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 --git a/databases/postgresql82-pltcl/Makefile b/databases/postgresql82-pltcl/Makefile new file mode 100644 index 00000000000..cfbce001264 --- /dev/null +++ b/databases/postgresql82-pltcl/Makefile @@ -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 --git a/databases/postgresql82-pltcl/PLIST b/databases/postgresql82-pltcl/PLIST new file mode 100644 index 00000000000..85b8dceeae5 --- /dev/null +++ b/databases/postgresql82-pltcl/PLIST @@ -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 --git a/databases/postgresql82-tsearch2/DESCR b/databases/postgresql82-tsearch2/DESCR new file mode 100644 index 00000000000..cceb66da784 --- /dev/null +++ b/databases/postgresql82-tsearch2/DESCR @@ -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 --git a/databases/postgresql82-tsearch2/Makefile b/databases/postgresql82-tsearch2/Makefile new file mode 100644 index 00000000000..60361ad9f24 --- /dev/null +++ b/databases/postgresql82-tsearch2/Makefile @@ -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 --git a/databases/postgresql82-tsearch2/PLIST b/databases/postgresql82-tsearch2/PLIST new file mode 100644 index 00000000000..458ae47dab9 --- /dev/null +++ b/databases/postgresql82-tsearch2/PLIST @@ -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 |