* Ensure txid_current() reports the correct epoch when executed in hot standby * Fix text to name and char to name casts to perform string truncation correctly in multibyte encodings

* Fix timestamp conversion to cope when the given time is exactly the last DST transition time for the current timezone This oversight has been there a long time, but was not noticed previously because most DST-using zones are presumed to have an indefinite sequence of future DST transitions. This could result in dumped data values being rejected during reload. * Allow numeric timezone offsets in timestamp input to be up to 16 hours away from UTC Some historical time zones have offsets larger than 15 hours, the previous limit. See the 9.1.2 release notes for more information about doing this. As before, if you have already run the upgrade script, you'll need to run the collation update commands by hand instead. This release extends the module's upgrade script to handle these cases.

* Make contrib/citext's upgrade script fix collations of citext arrays and domains over citext Release 9.1.2 provided a fix for collations of citext columns and indexes in databases upgraded or reloaded from pre-9.1 installations, but that fix was incomplete: it neglected to handle arrays and domains over citext. * Ignore SECURITY DEFINER and SET attributes for a procedural language's call handler Applying such attributes to a call handler could crash the server. Any stored password values that are affected by this bug will thus no longer match, so the stored values may need to be updated. With this fix, the rest of the string is properly included in the DES hash. * Fix incorrect password transformation in contrib/pgcrypto's DES crypt() function (Solar Designer) If a password string contained the byte value 0x80, the remainder of the password was ignored, causing the password to be much weaker than it appeared.

Postgresql 9.2 install dblink