NOTICE: This package has been removed from pkgsrc

./databases/postgresql94-datatypes, PostgreSQL data types support modules

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ]

Branch: CURRENT, Version: 9.4.7, Package name: postgresql94-datatypes-9.4.7, Maintainer: adam

This package provides the following PostgreSQL modules: btree_gist,
citext, hstore, intarray, isn, ltree, lo, uuid-ossp, unaccent.

The "btree_gist" module provides GIST operator classes for scalar data types.

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.


Required to run:
[devel/readline] [devel/ossp-uuid] [databases/postgresql94-server] [databases/postgresql94-client]

Master sites:

SHA1: 780c3c6bfac0860d9ca8ba8ef6c154bb38714215
RMD160: a9dcc6952e4b74c192454e6ba2f3bc86e507cf8b
Filesize: 17331.042 KB

Version history: (Expand)

CVS history: (Expand)


   2016-06-19 23:09:58 by Filip Hajny | Files touched by this commit (122) | Package removed
Log message:
Remove PostgreSQL split-up contrib packages, now replaced by
single postgresql9[1-5]-contrib packages. OK by adam@.
   2016-04-09 14:51:50 by Adam Ciarcinski | Files touched by this commit (90) | Package updated
Log message:
The PostgreSQL Global Development Group has released an update to all supported \ 
versions of our database system, including 9.5.2, 9.4.7, 9.3.12, 9.2.16, and \ 
9.1.21. This release fixes two security issues and one index corruption issue in \ 
version 9.5. It also contains a variety of bug fixes for earlier versions. Users \ 
of PostgreSQL 9.5.0 or 9.5.1 should update as soon as possible.

This release closes security hole CVE-2016-2193, where a query plan might get \ 
reused for more than one ROLE in the same session. This could cause the wrong \ 
set of Row Level Security (RLS) policies to be used for the query.

The update also fixes CVE-2016-3065, a server crash bug triggered by using \ 
pageinspect with BRIN index pages. Since an attacker might be able to expose a \ 
few bytes of server memory, this crash is being treated as a security issue.
   2016-03-05 12:29:49 by Jonathan Perkin | Files touched by this commit (1813) 
Log message:
Bump PKGREVISION for security/openssl ABI bump.
   2015-05-27 15:27:28 by Adam Ciarcinski | Files touched by this commit (20) | Package updated
Log message:
The PostgreSQL Global Development Group has released an update with multiple \ 
functionality and security fixes to all supported versions of the PostgreSQL \ 
database system, which includes minor versions 9.4.2, 9.3.7, 9.2.11, 9.1.16, and \ 
9.0.20. The update contains a critical fix for a potential data corruption issue \ 
in PostgreSQL 9.3 and 9.4; users of those versions should update their servers \ 
at the next possible opportunity.
   2015-04-23 20:23:46 by Joerg Sonnenberger | Files touched by this commit (1) 
Log message:
Link the uuid extension correctly. Bump revision.
   2015-01-14 22:01:20 by Adam Ciarcinski | Files touched by this commit (76) 
Log message:
PostgreSQL 9.4.0:
This release adds many new features which enhance PostgreSQL's flexibility, \ 
scalability and performance for many different types of database users, \ 
including improvements to JSON support, replication and index performance.