Age | Commit message (Collapse) | Author | Files | Lines |
|
* Remove overly-restrictive check for type length in constraints and
functional indexes
* Fix optimization so MIN/MAX in subqueries can again use indexes
|
|
* 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
|
|
* 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".
|
|
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%.
|
|
* 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
|