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.226.
A dump/restore is not required for those running 8.1.X.
However, if you have any hash indexes on interval
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.211.
Disallow 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 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 interval
(Tom)
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.
Treat to_char(..., 'TH')
as an uppercase ordinal
suffix with 'HH'
/'HH12'
(Heikki)
It was previously handled as 'th'
(lowercase).
Fix overflow for INTERVAL '
when x
ms'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.
Fix money
data type to work in locales where currency
amounts have no fractional digits, e.g. Japan (Itagaki Takahiro)
Properly round datetime input like
00:12:57.9999999999999999999999999999
(Tom)
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
postgresql.conf
is empty (Jeff Davis)
Fix contrib/xml2
's xslt_process()
to
properly handle the maximum number of parameters (twenty) (Tom)
Improve robustness of libpq's code to recover
from errors during COPY FROM STDIN
(Tom)
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.