summaryrefslogtreecommitdiff
path: root/databases/postgresql91-upgrade
AgeCommit message (Collapse)AuthorFilesLines
2012-07-01Security update to version 9.1.4.morr1-2/+1
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;
2012-06-14Recursive PKGREVISION bump for libxml2 buildlink addition.sbd1-1/+2
2011-09-15Version 9.1 delivers several features which users have been requesting foradam3-0/+38
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