summaryrefslogtreecommitdiff
path: root/databases/postgresql82-pltcl
AgeCommit message (Collapse)AuthorFilesLines
2007-02-05Changes 8.2.2:adam1-2/+2
* Remove security vulnerabilities that allowed connected users to read backend memory * Fix not-so-rare-anymore bug wherein btree index page splits could fail due to choosing an infeasible split point * Fix Borland C compile scripts * Properly handle to_char('CC') for years ending in 00 Year 2000 is in the twentieth century, not the twenty-first. * "/contrib/tsearch2" localization improvements * Fix incorrect permission check in information_schema.key_column_usage view * Improve "VACUUM" performance for databases with many tables * Fix for rare Assert() crash triggered by UNION * Fix potentially incorrect results from index searches using ROW inequality conditions * Tighten security of multi-byte character processing for UTF8 sequences over three bytes long * Fix bogus "permission denied" failures occurring on Windows due to attempts to fsync already-deleted files * Fix bug that could cause the statistics collector to hang on Windows * Fix possible crashes when an already-in-use PL/pgSQL function is updated * Improve PL/pgSQL handling of domain types * Fix possible errors in processing PL/pgSQL exception blocks
2006-12-09Changes 8.2.0:adam4-0/+40
* Query language enhancements including "INSERT/UPDATE/DELETE RETURNING", multirow VALUES lists, and optional target-table alias in "UPDATE"/"DELETE" * Index creation without blocking concurrent "INSERT"/"UPDATE"/"DELETE" operations * Many query optimization improvements, including support for reordering outer joins * Improved sorting performance with lower memory usage * More efficient locking with better concurrency * More efficient vacuuming * Easier administration of warm standby servers * New FILLFACTOR support for tables and indexes * Monitoring, logging, and performance tuning additions * More control over creating and dropping objects * Table inheritance relationships can be defined for and removed from pre-existing tables * "COPY TO" can copy the output of an arbitrary "SELECT" statement * Array improvements, including nulls in arrays * Aggregate-function improvements, including multiple-input aggregates and SQL:2003 statistical functions * Many "contrib/" improvements