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

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: pkgsrc-2012Q2, Version: 9.1.4, Package name: postgresql91-datatypes-9.1.4, Maintainer: adam

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.


Required to run:
[databases/postgresql91-client] [databases/postgresql91-server]

Master sites: (Expand)

SHA1: c75fd5696af02a275a104260eac8b3a4abe35682
RMD160: ff08ad702c7ffc0172b3f66aa4819d4865f0e77b
Filesize: 15265.521 KB

Version history: (Expand)


CVS history: (Expand)


   2012-07-04 01:23:09 by Matthias Scheler | Files touched by this commit (19) | Package updated
Log message:
Pullup ticket #3844 - requested by morr
databases/postgresql91: security update
databases/postgresql91-adminpack: security update
databases/postgresql91-client: security update
databases/postgresql91-datatypes: security update
databases/postgresql91-dblink: security update
databases/postgresql91-docs: security update
databases/postgresql91-fuzzystrmatch: security update
databases/postgresql91-monitoring: security update
databases/postgresql91-pgcrypto: security update
databases/postgresql91-plperl: security update
databases/postgresql91-plpython: security update
databases/postgresql91-pltcl: security update
databases/postgresql91-replicationtools: security update
databases/postgresql91-server: security update
databases/postgresql91-upgrade: security update

Revisions pulled up:
- databases/postgresql91-adminpack/Makefile                     1.3
- databases/postgresql91-client/Makefile                        1.7
- databases/postgresql91-datatypes/Makefile                     1.3
- databases/postgresql91-dblink/Makefile                        1.3
- databases/postgresql91-docs/Makefile                          1.3
- databases/postgresql91-docs/PLIST                             1.6
- databases/postgresql91-fuzzystrmatch/Makefile                 1.3
- databases/postgresql91-monitoring/Makefile                    1.3
- databases/postgresql91-pgcrypto/Makefile                      1.3
- databases/postgresql91-plperl/Makefile                        1.3
- databases/postgresql91-plpython/Makefile                      1.4
- databases/postgresql91-pltcl/Makefile                         1.3
- databases/postgresql91-replicationtools/Makefile              1.3
- databases/postgresql91-server/Makefile                        1.3
- databases/postgresql91-server/PLIST                           1.5
- databases/postgresql91-upgrade/Makefile                       1.3
- databases/postgresql91/Makefile                               1.3
- databases/postgresql91/Makefile.common                        1.7
- databases/postgresql91/distinfo                               1.6

---
   Module Name:	pkgsrc
   Committed By:	morr
   Date:		Sun Jul  1 19:49:26 UTC 2012

   Modified Files:
   	pkgsrc/databases/postgresql91: Makefile Makefile.common distinfo
   	pkgsrc/databases/postgresql91-adminpack: Makefile
   	pkgsrc/databases/postgresql91-client: Makefile
   	pkgsrc/databases/postgresql91-datatypes: Makefile
   	pkgsrc/databases/postgresql91-dblink: Makefile
   	pkgsrc/databases/postgresql91-docs: Makefile PLIST
   	pkgsrc/databases/postgresql91-fuzzystrmatch: Makefile
   	pkgsrc/databases/postgresql91-monitoring: Makefile
   	pkgsrc/databases/postgresql91-pgcrypto: Makefile
   	pkgsrc/databases/postgresql91-plperl: Makefile
   	pkgsrc/databases/postgresql91-plpython: Makefile
   	pkgsrc/databases/postgresql91-pltcl: Makefile
   	pkgsrc/databases/postgresql91-replicationtools: Makefile
   	pkgsrc/databases/postgresql91-server: Makefile PLIST
   	pkgsrc/databases/postgresql91-upgrade: Makefile

   Log message:
   Security update to version 9.1.4.

   Changes:

   * Fix incorrect password transformation in contrib/pgcrypto's DES crypt()
   function (Solar Designer)
   * Ignore SECURITY DEFINER and SET attributes for a procedural language's call
   handler (Tom Lane)
   * Make contrib/citext's upgrade script fix collations of citext arrays and
   domains over citext (Tom Lane)
   * Allow numeric timezone offsets in timestamp input to be up to 16 hours away
   from UTC (Tom Lane)
   * Fix timestamp conversion to cope when the given time is exactly the last DST
   transition time for the current timezone (Tom Lane)
   * Fix text to name and char to name casts to perform string truncation
   correctly in multibyte encodings (Karl Schnaitter)
   * Fix memory copying bug in to_tsquery() (Heikki Linnakangas)
   * Ensure txid_current() reports the correct epoch when executed in hot standby
   (Simon Riggs)
   * Fix planner's handling of outer PlaceHolderVars within subqueries (Tom Lane)
   * Fix planning of UNION ALL subqueries with output columns that are not simple
   variables (Tom Lane)
   * Fix slow session startup when pg_attribute is very large (Tom Lane)
   * Ensure sequential scans check for query cancel reasonably often (Merlin
   Moncure)
   * Ensure the Windows implementation of PGSemaphoreLock() clears
   ImmediateInterruptOK before returning (Tom Lane)
   * Show whole-row variables safely when printing views or rules (Abbas Butt, Tom
   Lane)
   * Fix COPY FROM to properly handle null marker strings that correspond to
   invalid encoding (Tom Lane)
   * Fix EXPLAIN VERBOSE for writable CTEs containing RETURNING clauses (Tom Lane)
   * Fix PREPARE TRANSACTION to work correctly in the presence of advisory locks
   (Tom Lane)
   * Fix truncation of unlogged tables (Robert Haas)
   * Ignore missing schemas during non-interactive assignments of search_path (Tom
   Lane)
   * Fix bugs with temporary or transient tables used in extension scripts (Tom
   Lane)
   * Ensure autovacuum worker processes perform stack depth checking properly
   (Heikki Linnakangas)
   * Fix logging collector to not lose log coherency under high load (Andrew
   Dunstan)
   * Fix logging collector to ensure it will restart file rotation after receiving
   SIGHUP (Tom Lane)
   * Fix "too many LWLocks taken" failure in GiST indexes (Heikki \ 
Linnakangas)
   * Fix WAL replay logic for GIN indexes to not fail if the index was
   subsequently dropped (Tom Lane)
   * Correctly detect SSI conflicts of prepared transactions after a crash (Dan
   Ports)
   * Avoid synchronous replication delay when committing a transaction that only
   modified temporary tables (Heikki Linnakangas)
   * Fix error handling in pg_basebackup (Thomas Ogrisegg, Fujii Masao)
   * Fix walsender to not go into a busy loop if connection is terminated (Fujii
   Masao)
   * Fix memory leak in PL/pgSQL's RETURN NEXT command (Joe Conway)
   * Fix PL/pgSQL's GET DIAGNOSTICS command when the target is the function's
   first variable (Tom Lane)
   * Ensure that PL/Perl package-qualifies the _TD variable (Alex Hunsaker)
   * Fix PL/Python functions returning composite types to accept a string for
   their result value (Jan Urbanski)
   * Fix potential access off the end of memory in psql's expanded display (\x)
   mode (Peter Eisentraut)
   * Fix several performance problems in pg_dump when the database contains many
   objects (Jeff Janes, Tom Lane)
   * Fix memory and file descriptor leaks in pg_restore when reading a
   directory-format archive (Peter Eisentraut)
   * Fix pg_upgrade for the case that a database stored in a non-default
   tablespace contains a table in the cluster's default tablespace (Bruce Momjian)
   * In ecpg, fix rare memory leaks and possible overwrite of one byte after the
   sqlca_t structure (Peter Eisentraut)
   * Fix contrib/dblink's dblink_exec() to not leak temporary database connections
   upon error (Tom Lane)
   * Fix contrib/dblink to report the correct connection name in error messages
   (Kyotaro Horiguchi)
   * Fix contrib/vacuumlo to use multiple transactions when dropping many large
   objects (Tim Lewis, Robert Haas, Tom Lane)
   * Update time zone data files to tzdata release 2012c for DST law changes in
   Antarctica, Armenia, Chile, Cuba, Falkland Islands, Gaza, Haiti, Hebron,
   Morocco, Syria, and Tokelau Islands;