summaryrefslogtreecommitdiff
path: root/databases/postgresql82-tsearch2
diff options
context:
space:
mode:
authoradam <adam>2006-12-09 16:13:57 +0000
committeradam <adam>2006-12-09 16:13:57 +0000
commit43ba138637006ce6821eaa5da874e6d365557d58 (patch)
treefb650d7c4a34eb86ae6950930a1957f5c77d8217 /databases/postgresql82-tsearch2
parent9393de2dd51fc4c3d1b60a4297d253b146de6f4c (diff)
downloadpkgsrc-43ba138637006ce6821eaa5da874e6d365557d58.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/postgresql82-tsearch2')
-rw-r--r--databases/postgresql82-tsearch2/DESCR6
-rw-r--r--databases/postgresql82-tsearch2/Makefile17
-rw-r--r--databases/postgresql82-tsearch2/PLIST12
3 files changed, 35 insertions, 0 deletions
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