Release date: 2009-09-09
This release contains a variety of fixes from 8.1.17. For information about new features in the 8.1 major release, see Section E.251.
A dump/restore is not required for those running 8.1.X. However,
if you have any hash indexes on
columns, you must
REINDEX them after
updating to 8.1.18. Also, if you are upgrading from a version
earlier than 8.1.15, see Section E.236.
RESET ROLE and
RESET SESSION AUTHORIZATION inside
security-definer functions (Tom, Heikki)
This covers a case that was missed in the previous patch that
SET ROLE and
SET SESSION AUTHORIZATION inside security-definer
functions. (See CVE-2007-6600)
Fix handling of sub-SELECTs appearing in the arguments of an outer-level aggregate function (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 updating.
to_char(..., 'TH') as an
uppercase ordinal suffix with
It was previously handled as
Fix overflow for
INTERVAL ' when
x is more than 2 million and
integer datetimes are in use (Alex Hunsaker)
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
Properly round datetime input like
Fix poor choice of page split point in GiST R-tree operator classes (Teodor)
Fix portability issues in plperl initialization (Andrew Dunstan)
Fix pg_ctl to not go into an
infinite loop if
empty (Jeff Davis)
xslt_process() to properly handle the maximum
number of parameters (twenty) (Tom)
Improve robustness of libpq's
code to recover from errors during
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.