E.81. Release 9.2.21

Improve performance of pg_timezone_names view (Tom Lane, David Rowley)

Fix sloppy handling of corner-case errors from lseek() and close() (Tom Lane)

Neither of these system calls are likely to fail in typical situations, but if they did, fd.c could get quite confused.

Fix incorrect check for whether postmaster is running as a Windows service (Michael Paquier)

This could result in attempting to write to the event log when that isn't accessible, so that no logging happens at all.

Fix ecpg to support COMMIT PREPARED and ROLLBACK PREPARED (Masahiko Sawada)

Fix a double-free error when processing dollar-quoted string literals in ecpg (Michael Meskes)

In pg_dump , fix incorrect schema and owner marking for comments and security labels of some types of database objects (Giuseppe Broccolo, Tom Lane)

In simple cases this caused no ill effects; but for example, a schema-selective restore might omit comments it should include, because they were not marked as belonging to the schema of their associated object.

Avoid emitting an invalid list file in pg_restore -l when SQL object names contain newlines (Tom Lane)

Replace newlines by spaces, which is sufficient to make the output valid for pg_restore -L 's purposes.

Fix pg_upgrade to transfer comments and security labels attached to " large objects " (blobs) (Stephen Frost)

Previously, blobs were correctly transferred to the new database, but any comments or security labels attached to them were lost.

Improve error handling in contrib/adminpack 's pg_file_write() function (Noah Misch)

Notably, it failed to detect errors reported by fclose() .

In contrib/dblink , avoid leaking the previous unnamed connection when establishing a new unnamed connection (Joe Conway)

Support OpenSSL 1.1.0 (Heikki Linnakangas, Andreas Karlsson, Tom Lane)

This is a back-patch of work previously done in newer branches; it's needed since many platforms are adopting newer OpenSSL versions.

Support Tcl 8.6 in MSVC builds (Álvaro Herrera)

Sync our copy of the timezone library with IANA release tzcode2017b (Tom Lane)

This fixes a bug affecting some DST transitions in January 2038.

Update time zone data files to tzdata release 2017b for DST law changes in Chile, Haiti, and Mongolia, plus historical corrections for Ecuador, Kazakhstan, Liberia, and Spain. Switch to numeric abbreviations for numerous time zones in South America, the Pacific and Indian oceans, and some Asian and Middle Eastern countries.

The IANA time zone database previously provided textual abbreviations for all time zones, sometimes making up abbreviations that have little or no currency among the local population. They are in process of reversing that policy in favor of using numeric UTC offsets in zones where there is no evidence of real-world use of an English abbreviation. At least for the time being, PostgreSQL will continue to accept such removed abbreviations for timestamp input. But they will not be shown in the pg_timezone_names view nor used for output.

Use correct daylight-savings rules for POSIX-style time zone names in MSVC builds (David Rowley)

The Microsoft MSVC build scripts neglected to install the posixrules file in the timezone directory tree. This resulted in the timezone code falling back to its built-in rule about what DST behavior to assume for a POSIX-style time zone name. For historical reasons that still corresponds to the DST rules the USA was using before 2007 (i.e., change on first Sunday in April and last Sunday in October). With this fix, a POSIX-style zone name will use the current and historical DST transition dates of the US/Eastern zone. If you don't want that, remove the posixrules file, or replace it with a copy of some other zone file (see Section 8.5.3 ). Note that due to caching, you may need to restart the server to get such changes to take effect.