Release date: 2009-09-09
This release contains a variety of fixes from 8.2.13. For information about new features in the 8.2 major release, see Section E.229.
A dump/restore is not required for those running 8.2.X.
However, if you have any hash indexes on
interval columns, you must
REINDEX them after updating to 8.2.14. Also,
if you are upgrading from a version earlier than 8.2.11, see
Force WAL segment switch during
This avoids corner cases that could render a base backup unusable.
RESET ROLE and
RESET SESSION AUTHORIZATION
inside security-definer functions (Tom, Heikki)
This covers a case that was missed in the previous
patch that disallowed
AUTHORIZATION inside security-definer functions.
LOAD of an
already-loaded loadable module into a no-op (Tom)
attempt to unload and re-load the module, but this is
unsafe and not all that useful.
Disallow empty passwords during LDAP authentication (Magnus)
Fix handling of sub-SELECTs appearing in the arguments of an outer-level aggregate function (Tom)
Fix bugs associated with fetching a whole-row value from the output of a Sort or Materialize plan node (Tom)
Revert planner change that disabled partial-index and constraint exclusion optimizations when there were more than 100 clauses in an AND or OR list (Tom)
Fix hash calculation for data type
This corrects wrong results for hash joins on interval
values. It also changes the contents of hash indexes on
interval columns. If you have any such indexes, you must
REINDEX them after
as an uppercase ordinal suffix with
It was previously handled as
Fix overflow for
x is more
than 2 million and integer datetimes are in use (Alex
Fix calculation of distance between a point and a line segment (Tom)
This led to incorrect results from a number of geometric operators.
money data type to work
in locales where currency amounts have no fractional
digits, e.g. Japan (Itagaki Takahiro)
Properly round datetime input like
Fix poor choice of page split point in GiST R-tree operator classes (Teodor)
Avoid performance degradation in bulk inserts into GIN indexes when the input values are (nearly) in sorted order (Tom)
Correctly enforce NOT NULL domain constraints in some contexts in PL/pgSQL (Tom)
Fix portability issues in plperl initialization (Andrew Dunstan)
Fix pg_ctl to not go
into an infinite loop if
postgresql.conf is empty (Jeff
throw an error when a key or value is too long to fit in
its data structure, rather than silently truncating it
xslt_process() to properly
handle the maximum number of parameters (twenty)
Improve robustness of libpq's code to recover from errors
COPY FROM STDIN
Avoid including conflicting readline and editline header files when both libraries are installed (Zdenek Kotala)
Update time zone data files to tzdata release 2009l for DST law changes in Bangladesh, Egypt, Jordan, Pakistan, Argentina/San_Luis, Cuba, Jordan (historical correction only), Mauritius, Morocco, Palestine, Syria, Tunisia.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.