summaryrefslogtreecommitdiff
path: root/databases/postgresql82-server
AgeCommit message (Collapse)AuthorFilesLines
2007-04-30Changes 8.2.4:adam1-1/+7
* Support explicit placement of the temporary-table schema within search_path, and disable searching it for functions and operators * Fix shared_preload_libraries for Windows by forcing reload in each backend * Fix to_char() so it properly upper/lower cases localized day or month names * "/contrib/tsearch2" crash fixes * Require "COMMIT PREPARED" to be executed in the same database as the transaction was prepared in * Allow "pg_dump" to do binary backups larger than two gigabytes on Windows * New traditional (Taiwan) Chinese FAQ * Prevent the statistics collector from writing to disk too frequently * Fix potential-data-corruption bug in how "VACUUM FULL" handles "UPDATE" chains * Fix bug in domains that use array types * Fix "pg_dump" so it can dump a serial column's sequence using "-t" when not also dumping the owning table * Planner fixes, including improving outer join and bitmap scan selection logic * Fix possible wrong answers or crash when a PL/pgSQL function tries to RETURN from within an EXCEPTION block * Fix PANIC during enlargement of a hash index * Fix POSIX-style timezone specs to follow new USA DST rules
2007-03-20Don't remove directory not created (missing) in PostgreSQL installation.jlam1-2/+1
2006-12-09Changes 8.2.0:adam6-0/+934
* 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