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;
Pullup ticket #3846 - requested by joerg
mk: improve shared library check

Revisions pulled up:
- mk/check/check-shlibs.mk                                      1.21
- mk/pkgformat/pkg/depends.mk                                   1.2
- mk/pkgformat/pkg/reduce-resolved-depends.awk                  1.1

---
   Module Name:	pkgsrc
   Committed By:	joerg
   Date:		Mon Jul  2 14:53:13 UTC 2012

   Modified Files:
   	pkgsrc/mk/check: check-shlibs.mk
   	pkgsrc/mk/pkgformat/pkg: depends.mk
   Added Files:
   	pkgsrc/mk/pkgformat/pkg: reduce-resolved-depends.awk

   Log Message:
   Expand the list of full dependencies, so that the shared library check
   can work without further calls for indirect full dependencies.
Pullup tickets #3843, #3844 and #3846.