Path to this page:
./
databases/postgresql90-datatypes,
PostgreSQL data types support modules
Branch: pkgsrc-2012Q2,
Version: 9.0.8,
Package name: postgresql90-datatypes-9.0.8,
Maintainer: adamThis 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/postgresql90-client]
Master sites: (Expand)
SHA1: 240d2d45bc87d8cdad8e2b74cf378f5668b604fe
RMD160: fab8564774c99300ca8a69298417eec960e70601
Filesize: 14646.548 KB
Version history: (Expand)
- (2012-07-05) Package added to pkgsrc.se, version postgresql90-datatypes-9.0.8 (created)
CVS history: (Expand)
2012-07-04 09:46:11 by Matthias Scheler | Files touched by this commit (20) | |
Log message:
Pullup ticket #3847 - requested by morr
databases/postgresql90: security update
databases/postgresql90-adminpack: security update
databases/postgresql90-client: security update
databases/postgresql90-datatypes: security update
databases/postgresql90-dblink: security update
databases/postgresql90-docs: security update
databases/postgresql90-fuzzystrmatch: security update
databases/postgresql90-monitoring: security update
databases/postgresql90-pgcrypto: security update
databases/postgresql90-plperl: security update
databases/postgresql90-plpython: security update
databases/postgresql90-pltcl: security update
databases/postgresql90-replicationtools: security update
databases/postgresql90-server: security update
databases/postgresql90-upgrade: security update
databases/postgresql90-uuid: security update
Revisions pulled up:
- databases/postgresql90-adminpack/Makefile 1.6
- databases/postgresql90-client/Makefile 1.13
- databases/postgresql90-datatypes/Makefile 1.6
- databases/postgresql90-dblink/Makefile 1.6
- databases/postgresql90-docs/Makefile 1.7
- databases/postgresql90-docs/PLIST 1.10
- databases/postgresql90-fuzzystrmatch/Makefile 1.5
- databases/postgresql90-monitoring/Makefile 1.7
- databases/postgresql90-pgcrypto/Makefile 1.6
- databases/postgresql90-plperl/Makefile 1.8
- databases/postgresql90-plpython/Makefile 1.7
- databases/postgresql90-pltcl/Makefile 1.6
- databases/postgresql90-replicationtools/Makefile 1.4
- databases/postgresql90-server/Makefile 1.11
- databases/postgresql90-server/PLIST 1.10
- databases/postgresql90-upgrade/Makefile 1.6
- databases/postgresql90-uuid/Makefile 1.3
- databases/postgresql90/Makefile 1.4
- databases/postgresql90/Makefile.common 1.18
- databases/postgresql90/distinfo 1.11
---
Module Name: pkgsrc
Committed By: morr
Date: Sun Jul 1 19:42:08 UTC 2012
Modified Files:
pkgsrc/databases/postgresql90: Makefile Makefile.common distinfo
pkgsrc/databases/postgresql90-adminpack: Makefile
pkgsrc/databases/postgresql90-client: Makefile
pkgsrc/databases/postgresql90-datatypes: Makefile
pkgsrc/databases/postgresql90-dblink: Makefile
pkgsrc/databases/postgresql90-docs: Makefile PLIST
pkgsrc/databases/postgresql90-fuzzystrmatch: Makefile
pkgsrc/databases/postgresql90-monitoring: Makefile
pkgsrc/databases/postgresql90-pgcrypto: Makefile
pkgsrc/databases/postgresql90-plperl: Makefile
pkgsrc/databases/postgresql90-plpython: Makefile
pkgsrc/databases/postgresql90-pltcl: Makefile
pkgsrc/databases/postgresql90-replicationtools: Makefile
pkgsrc/databases/postgresql90-server: Makefile PLIST
pkgsrc/databases/postgresql90-upgrade: Makefile
pkgsrc/databases/postgresql90-uuid: Makefile
Log message:
Security update to version 9.0.8.
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)
* 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 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)
* 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 WAL replay logic for GIN indexes to not fail if the index was
subsequently dropped (Tom Lane)
* 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)
* 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
*bjects (Jeff Janes, Tom Lane)
* 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
*bjects (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;
|