head	1.6;
access;
symbols
	pkgsrc-2016Q1:1.5.0.12
	pkgsrc-2016Q1-base:1.5
	pkgsrc-2015Q4:1.5.0.10
	pkgsrc-2015Q4-base:1.5
	pkgsrc-2015Q3:1.5.0.8
	pkgsrc-2015Q3-base:1.5
	pkgsrc-2015Q2:1.5.0.6
	pkgsrc-2015Q2-base:1.5
	pkgsrc-2015Q1:1.5.0.4
	pkgsrc-2015Q1-base:1.5
	pkgsrc-2014Q4:1.5.0.2
	pkgsrc-2014Q4-base:1.5
	pkgsrc-2014Q3:1.4.0.8
	pkgsrc-2014Q3-base:1.4
	pkgsrc-2014Q2:1.4.0.6
	pkgsrc-2014Q2-base:1.4
	pkgsrc-2014Q1:1.4.0.4
	pkgsrc-2014Q1-base:1.4
	pkgsrc-2013Q4:1.4.0.2
	pkgsrc-2013Q4-base:1.4
	pkgsrc-2013Q3:1.3.0.4
	pkgsrc-2013Q3-base:1.3
	pkgsrc-2013Q2:1.3.0.2
	pkgsrc-2013Q2-base:1.3
	pkgsrc-2013Q1:1.1.1.1.0.14
	pkgsrc-2013Q1-base:1.1.1.1
	pkgsrc-2012Q4:1.1.1.1.0.12
	pkgsrc-2012Q4-base:1.1.1.1
	pkgsrc-2012Q3:1.1.1.1.0.10
	pkgsrc-2012Q3-base:1.1.1.1
	pkgsrc-2012Q2:1.1.1.1.0.8
	pkgsrc-2012Q2-base:1.1.1.1
	pkgsrc-2012Q1:1.1.1.1.0.6
	pkgsrc-2012Q1-base:1.1.1.1
	pkgsrc-2011Q4:1.1.1.1.0.4
	pkgsrc-2011Q4-base:1.1.1.1
	pkgsrc-2011Q3:1.1.1.1.0.2
	pkgsrc-2011Q3-base:1.1.1.1
	pkgsrc-base:1.1.1.1
	TNF:1.1.1;
locks; strict;
comment	@# @;


1.6
date	2016.06.19.21.09.54;	author fhajny;	state dead;
branches;
next	1.5;
commitid	Bzim37w30LJKv7bz;

1.5
date	2014.10.01.19.25.35;	author joerg;	state Exp;
branches;
next	1.4;
commitid	heogjAp2mk7O5xSx;

1.4
date	2013.12.10.22.32.57;	author adam;	state Exp;
branches;
next	1.3;
commitid	ohMN3aaPeA02CDgx;

1.3
date	2013.04.08.18.29.40;	author asau;	state Exp;
branches;
next	1.2;

1.2
date	2013.04.07.20.49.32;	author rodent;	state Exp;
branches;
next	1.1;

1.1
date	2011.09.15.08.30.08;	author adam;	state Exp;
branches
	1.1.1.1;
next	;

1.1.1.1
date	2011.09.15.08.30.08;	author adam;	state Exp;
branches;
next	;


desc
@@


1.6
log
@Remove PostgreSQL split-up contrib packages, now replaced by
single postgresql9[1-5]-contrib packages. OK by adam@@.
@
text
@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.
@


1.5
log
@Include btree-gist module, useful e.g. for range exclusions.
@
text
@@


1.4
log
@The PostgreSQL Global Development Group has released a critical update to all supported versions of the PostgreSQL database system, which includes minor versions 9.3.2, 9.2.6, 9.1.11, 9.0.15, and 8.4.19. This update fixes three serious data-loss bugs affecting replication and database maintenance. All users are urged to update their installations at the earliest opportunity.

The replication issue affects some users of PostgreSQL binary replication, and can cause minor data loss between the master and the standby. While not all users are affected, it is difficult to predict when the bug will occur, so we urge all users of replication and continuous backup (PITR) to update immediately. Additionally, users who had replication running under PostgreSQL minor versions 9.3.0, 9.3.1, 9.2.5, 9.1.10, or 9.0.14 should plan to take a fresh base backup of each standby after update, in order to ensure no prior data corruption already exists.

This release also fixes two timing issues with VACUUM, which can cause old, overwritten or deleted rows to re-appear at a later date under some circumstances. Users with very high transaction rates, particularly those who experience "transaction ID wraparound" every few weeks or less, are the most at risk for this issue. Those users should set vacuum_freeze_table_age to 0, and run a database-wide VACUUM after the update. The second of the two VACUUM issues affects only 9.3, making it expecially important for 9.3 users to update.
@
text
@d1 4
a4 2
This package provides the following PostgreSQL modules: citext, hstore,
intarray, isn, ltree, lo, uuid-ossp, unaccent.
@


1.3
log
@Revert pkglint-induced nonsense.
@
text
@d1 2
a2 9
This package provides the following PostgreSQL modules:
  - citext
  - hstore
  - intarray
  - isn
  - ltree
  - lo
  - uuid-ossp
  - unaccent
@


1.2
log
@Edited DESCR in the case of:
 File too long (should be no more than 24 lines).
 Line too long (should be no more than 80 characters).
 Trailing empty lines.
 Trailing white-space.
Trucated the long files as best as possible while preserving the most info
contained in them.
@
text
@d1 31
a31 3
This package provides the following PostgreSQL modules: citext, hstore,
intarray, isn, ltree, lo, uuid-ossp, and unaccent. The "citext" module provides
a case-insensitive character string type, citext.
d33 2
a34 14
The "hstore" module implements the "hstore" data type for storing sets of
key/value pairs within a single PostgreSQL value.

The "intarray" module provides a number of useful functions and operators for
manipulating one-dimensional arrays of integers.

The "isn" module provides data types for the following international product
numbering standards: EAN13, UPC, ISBN (books), ISMN (music), and ISSN (serials).

The "ltree" module implements a data type ltree for representing labels of data
stored in a hierarchical tree-like structure.

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."
d37 2
a38 1
identifiers (UUIDs) using one of several standard algorithms.
d41 3
a43 1
from lexemes.
@


1.1
log
@Initial revision
@
text
@d1 3
a3 31
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.
d5 14
a18 2
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."
d21 1
a21 2
identifiers (UUIDs) using one of several standard algorithms. There are
also functions to produce certain special UUID constants.
d24 1
a24 3
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.
@


1.1.1.1
log
@Version 9.1 delivers several features which users have been requesting for
years, removing roadblocks to deploying new or ported applications on
PostgreSQL. These include:
* Synchronous Replication: enable high-availability with consistency across
  multiple servers
* Per-Column Collations: support linguistically-correct sorting per database,
  table or column.
* Unlogged Tables: greatly improves performance for ephemeral data

Our community of contributors innovates with cutting-edge features. Version 9.1
includes several which are new to the database industry, such as:
* K-Nearest-Neighbor Indexing: index on "distance" for faster location and text
  search queries
* Serializable Snapshot Isolation: keeps concurrent transactions consistent
  without blocking, using "true serializability"
* Writeable Common Table Expressions: execute complex multi-stage data updates
  in a single query
* Security-Enhanced Postgres: deploy military-grade security and Mandatory
  Access Control
@
text
@@