From 43ba138637006ce6821eaa5da874e6d365557d58 Mon Sep 17 00:00:00 2001 From: adam Date: Sat, 9 Dec 2006 16:13:57 +0000 Subject: 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 --- databases/postgresql82-tsearch2/DESCR | 6 ++++++ databases/postgresql82-tsearch2/Makefile | 17 +++++++++++++++++ databases/postgresql82-tsearch2/PLIST | 12 ++++++++++++ 3 files changed, 35 insertions(+) create mode 100644 databases/postgresql82-tsearch2/DESCR create mode 100644 databases/postgresql82-tsearch2/Makefile create mode 100644 databases/postgresql82-tsearch2/PLIST (limited to 'databases/postgresql82-tsearch2') 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 -- cgit v1.2.3