diff options
author | adam <adam@pkgsrc.org> | 2013-09-10 15:32:32 +0000 |
---|---|---|
committer | adam <adam@pkgsrc.org> | 2013-09-10 15:32:32 +0000 |
commit | 109fdd9f83c4e1e0843e1431814119025c8b3f62 (patch) | |
tree | ef2c53e491faea05c5ea8ccb8ccdfd9b86064cde /databases/postgresql93-datatypes | |
parent | f4227f726d2d82741a9d4592270c49194c691343 (diff) | |
download | pkgsrc-109fdd9f83c4e1e0843e1431814119025c8b3f62.tar.gz |
Major enhancements in PostgreSQL 9.3 include:
* Add materialized views
* Make simple views auto-updatable
* Add many features for the JSON data type, including operators and functions to extract elements from JSON values
* Implement SQL-standard LATERAL option for FROM-clause subqueries and function calls
* Allow foreign data wrappers to support writes (inserts/updates/deletes) on foreign tables
* Add a Postgres foreign data wrapper to allow access to other Postgres servers
* Add support for event triggers
* Add optional ability to checksum data pages and report corruption
* Prevent non-key-field row updates from blocking foreign key checks
* Greatly reduce System V shared memory requirements
Diffstat (limited to 'databases/postgresql93-datatypes')
-rw-r--r-- | databases/postgresql93-datatypes/DESCR | 43 | ||||
-rw-r--r-- | databases/postgresql93-datatypes/Makefile | 26 | ||||
-rw-r--r-- | databases/postgresql93-datatypes/PLIST | 35 |
3 files changed, 104 insertions, 0 deletions
diff --git a/databases/postgresql93-datatypes/DESCR b/databases/postgresql93-datatypes/DESCR new file mode 100644 index 00000000000..0fd1fb2d6cd --- /dev/null +++ b/databases/postgresql93-datatypes/DESCR @@ -0,0 +1,43 @@ +This package provides the following PostgreSQL modules: + - citext + - hstore + - intarray + - isn + - ltree + - lo + - uuid-ossp + - unaccent + +The "citext" module provides a case-insensitive character string type, +citext. Essentially, it internally calls lower when comparing values. +Otherwise, it behaves almost exactly like text. + +The "hstore" module implements the "hstore" data type for storing sets +of key/value pairs within a single PostgreSQL value. This can be useful +in various scenarios, such as rows with many attributes that are rarely +examined, or semi-structured data. Keys and values are simply text strings. + +The "intarray" module provides a number of useful functions and operators +for manipulating one-dimensional arrays of integers. There is also support +for indexed searches using some of the operators. + +The "isn" module provides data types for the following international +product numbering standards: EAN13, UPC, ISBN (books), ISMN (music), +and ISSN (serials). Numbers are validated on input, and correctly +hyphenated on output. + +The "ltree" module implements a data type ltree for representing +labels of data stored in a hierarchical tree-like structure. +Extensive facilities for searching through label trees are provided. + +The "lo" module provides support for managing Large Objects (also called +LOs or BLOBs). This includes a data type "lo" and a trigger "lo_manage." + +The "uuid-ossp" module provides functions to generate universally unique +identifiers (UUIDs) using one of several standard algorithms. There are +also functions to produce certain special UUID constants. + +"unaccent" is a text search dictionary that removes accents (diacritic signs) +from lexemes. It's a filtering dictionary, which means its output is always +passed to the next dictionary (if any), unlike the normal behavior of +dictionaries. This allows accent-insensitive processing for full text search. diff --git a/databases/postgresql93-datatypes/Makefile b/databases/postgresql93-datatypes/Makefile new file mode 100644 index 00000000000..23e8e0eda97 --- /dev/null +++ b/databases/postgresql93-datatypes/Makefile @@ -0,0 +1,26 @@ +# $NetBSD: Makefile,v 1.1 2013/09/10 15:32:32 adam Exp $ + +PKGNAME= ${DISTNAME:C/-/93-datatypes-/} +COMMENT= PostgreSQL data types support modules + +DEPENDS+= postgresql93-server>=${PKGVERSION_NOREV}:../../databases/postgresql93-server + +.include "../../databases/postgresql93/Makefile.common" + +CONFIGURE_ARGS+= --with-ossp-uuid +# because global pg_config.h is included, we have to define this +CPPFLAGS+= -DHAVE_UUID_H + +BUILD_DIRS+= contrib/citext +BUILD_DIRS+= contrib/hstore +BUILD_DIRS+= contrib/intarray +BUILD_DIRS+= contrib/isn +BUILD_DIRS+= contrib/ltree +BUILD_DIRS+= contrib/lo +BUILD_DIRS+= contrib/uuid-ossp +BUILD_DIRS+= contrib/unaccent +BUILD_MAKE_FLAGS= PGXS=1 + +.include "../../databases/postgresql93-client/buildlink3.mk" +.include "../../devel/ossp-uuid/buildlink3.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/postgresql93-datatypes/PLIST b/databases/postgresql93-datatypes/PLIST new file mode 100644 index 00000000000..d83c3ee7622 --- /dev/null +++ b/databases/postgresql93-datatypes/PLIST @@ -0,0 +1,35 @@ +@comment $NetBSD: PLIST,v 1.1 2013/09/10 15:32:32 adam Exp $ +lib/postgresql/_int.so +lib/postgresql/citext.so +lib/postgresql/hstore.so +lib/postgresql/isn.so +lib/postgresql/lo.so +lib/postgresql/ltree.so +lib/postgresql/unaccent.so +lib/postgresql/uuid-ossp.so +share/postgresql/extension/citext--1.0.sql +share/postgresql/extension/citext--unpackaged--1.0.sql +share/postgresql/extension/citext.control +share/postgresql/extension/hstore--1.0--1.1.sql +share/postgresql/extension/hstore--1.1.sql +share/postgresql/extension/hstore--unpackaged--1.0.sql +share/postgresql/extension/hstore.control +share/postgresql/extension/intarray--1.0.sql +share/postgresql/extension/intarray--unpackaged--1.0.sql +share/postgresql/extension/intarray.control +share/postgresql/extension/isn--1.0.sql +share/postgresql/extension/isn--unpackaged--1.0.sql +share/postgresql/extension/isn.control +share/postgresql/extension/lo--1.0.sql +share/postgresql/extension/lo--unpackaged--1.0.sql +share/postgresql/extension/lo.control +share/postgresql/extension/ltree--1.0.sql +share/postgresql/extension/ltree--unpackaged--1.0.sql +share/postgresql/extension/ltree.control +share/postgresql/extension/unaccent--1.0.sql +share/postgresql/extension/unaccent--unpackaged--1.0.sql +share/postgresql/extension/unaccent.control +share/postgresql/extension/uuid-ossp--1.0.sql +share/postgresql/extension/uuid-ossp--unpackaged--1.0.sql +share/postgresql/extension/uuid-ossp.control +share/postgresql/tsearch_data/unaccent.rules |