E.7.1. Migration to version 8.1.10

A dump/restore is not required for those running 8.1.X. However, if you are upgrading from a version earlier than 8.1.2, see the release notes for 8.1.2.

E.7.2. Changes

• Prevent index corruption when a transaction inserts rows and then aborts close to the end of a concurrent VACUUM on the same table (Tom)

• Make CREATE DOMAIN ... DEFAULT NULL work properly (Tom)

• Allow the interval data type to accept input consisting only of milliseconds or microseconds (Neil)

• Speed up rtree index insertion (Teodor)

• Fix excessive logging of SSL error messages (Tom)

• Fix logging so that log messages are never interleaved when using the syslogger process (Andrew)

• Fix crash when log_min_error_statement logging runs out of memory (Tom)

• Fix incorrect handling of some foreign-key corner cases (Tom)

• Prevent REINDEX and CLUSTER from failing due to attempting to process temporary tables of other sessions (Alvaro)

• Update the time zone database rules, particularly New Zealand's upcoming changes (Tom)

• Windows socket improvements (Magnus)

• Suppress timezone name (%Z) in log timestamps on Windows because of possible encoding mismatches (Tom)

• Require non-superusers who use /contrib/dblink to use only password authentication, as a security measure (Joe)