summaryrefslogtreecommitdiff
path: root/databases/postgresql82-client
AgeCommit message (Collapse)AuthorFilesLines
2007-02-08Changes 8.2.3:adam1-2/+5
* Remove overly-restrictive check for type length in constraints and functional indexes * Fix optimization so MIN/MAX in subqueries can again use indexes
2007-02-05Changes 8.2.2:adam1-2/+7
* 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
2007-01-08Changes 8.2.1:adam2-5/+10
* Fix crash with SELECT ... LIMIT ALL (also LIMIT NULL) * "Several /contrib/tsearch2" fixes * On Windows, make log messages coming from the operating system use ASCII encoding This fixes a conversion problem when there is a mismatch between the encoding of the operating system and database server. * Fix Windows linking of pg_dump using "win32.mak" * Fix planner mistakes for outer join queries * Fix several problems in queries involving sub-SELECTs * Fix potential crash in SPI during subtransaction abort This affects all PL functions since they all use SPI. * Improve build speed of PDF documentation * Re-add JST (Japan) timezone abbreviation * Improve optimization decisions related to index scans * Have psql print multi-byte combining characters as before, rather than output as \u * Improve index usage of regular expressions that use parentheses This improves psql \d performance also. * Make pg_dumpall assume that databases have public CONNECT privilege, when dumping from a pre-8.2 server This preserves the previous behavior that anyone can connect to a database if allowed by "pg_hba.conf".
2006-12-12Replace mk/bsd.prefs.mk includes with bsd.fast.prefs.mk includes.joerg1-2/+2
The redundant parsing of bsd.prefs.mk is mostly avoided now and parse time e.g. for x11/kdebase3 gets reduced by up to 10%.
2006-12-09Changes 8.2.0:adam4-0/+1659
* 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