PostgreSQL

By default, panic instead of retrying after fsync() failure, to avoid possible data corruption (Craig Ringer, Thomas Munro)

Include each major release branch’s release notes in the documentation for only that branch, rather than that branch and all later ones (Tom Lane)

Fix handling of unique indexes with INCLUDE columns on partitioned tables (Álvaro Herrera)

Ensure that NOT NULL constraints of a partitioned table are honored within its partitions (Álvaro Herrera, Amit Langote)

Update catalog state correctly for partition table constraints when detaching their partition (Amit Langote, Álvaro Herrera)

Create or delete foreign key enforcement triggers correctly when attaching or detaching a partition in a partitioned table that has a foreign-key constraint (Amit Langote, Álvaro Herrera)

Avoid useless creation of duplicate foreign key constraints in partitioned tables (Álvaro Herrera)

When an index is created on a partitioned table using ONLY, and there are no partitions yet, mark it valid immediately (Álvaro Herrera)

Use a safe table lock level when detaching a partition (Álvaro Herrera)

Fix problems with applying ON COMMIT DROP and ON COMMIT DELETE ROWS to partitioned tables and tables with inheritance children (Michael Paquier)

Disallow COPY FREEZE on partitioned tables (David Rowley)

Fix possible index corruption when the indexed column has a “[.quote]#fast default”# (that is, it was added by ALTER TABLE ADD COLUMN with a constant non-NULL default value specified, after the table already contained some rows) (Andres Freund)

Correctly adjust “[.quote]#fast default”# values during ALTER TABLE ... ALTER COLUMN TYPE (Andrew Dunstan)

Avoid possible deadlock when acquiring multiple buffer locks (Nishant Fnu)

Avoid deadlock between GIN vacuuming and concurrent index insertions (Alexander Korotkov, Andrey Borodin, Peter Geoghegan)

Avoid deadlock between hot-standby queries and replay of GIN index page deletion (Alexander Korotkov)

Fix possible crashes in logical replication when index expressions or predicates are in use (Peter Eisentraut)

Avoid useless and expensive logical decoding of TOAST data during a table rewrite (Tomas Vondra)

Fix logic for stopping a subset of WAL senders when synchronous replication is enabled (Paul Guo, Michael Paquier)

Avoid possibly writing an incorrect replica identity field in a tuple deletion WAL record (Stas Kelvich)

Prevent incorrect use of WAL-skipping optimization during COPY to a view or foreign table (Amit Langote, Michael Paquier)

Make the archiver prioritize WAL history files over WAL data files while choosing which file to archive next (David Steele)

Fix possible crash in UPDATE with a multiple SET clause using a sub-SELECT as source (Tom Lane)

Fix crash when zero rows are fed to json[b]_populate_recordset() or json[b]_to_recordset() (Tom Lane)

Avoid crash if libxml2 returns a null error message (Sergio Conde Gómez)

Fix incorrect JIT tuple deforming code for tables with many columns (more than approximately 800) (Andres Freund)

Fix performance and memory leakage issues in hash-based grouping (Andres Freund)

Fix spurious grouping-related parser errors caused by inconsistent handling of collation assignment (Andrew Gierth)

Fix parsing of collation-sensitive expressions in the arguments of a CALL statement (Peter Eisentraut)

Ensure proper cleanup after detecting an error in the argument list of a CALL statement (Tom Lane)

Check whether the comparison function underlying LEAST() or GREATEST() is leakproof, rather than just assuming it is (Tom Lane)

Fix incorrect planning of queries involving nested loops both above and below a Gather plan node (Tom Lane)

Fix incorrect planning of queries in which a lateral reference must be evaluated at a foreign table scan (Tom Lane)

Fix planner failure when the first column of a row comparison matches an index column, but later column(s) do not, and the index has included (non-key) columns (Tom Lane)

Fix corner-case underestimation of the cost of a merge join (Tom Lane)

Avoid O(N^2) planning time growth when a query contains many thousand indexable clauses (Tom Lane)

Improve planning speed for large inheritance or partitioning table groups (Amit Langote, Etsuro Fujita)

Improve `ANALYZE’s handling of concurrently-updated rows (Jeff Janes, Tom Lane)

Make TRUNCATE ignore inheritance child tables that are temporary tables of other sessions (Amit Langote, Michael Paquier)

Fix TRUNCATE to update the statistics counters for the right table (Tom Lane)

Process ALTER TABLE ONLY ADD COLUMN IF NOT EXISTS correctly (Greg Stark)

Allow UNLISTEN in hot-standby mode (Shay Rojansky)

Fix missing role dependencies in some schema and data type permissions lists (Tom Lane)

Prevent use of a session’s temporary schema within a two-phase transaction (Michael Paquier)

Ensure relation caches are updated properly after adding or removing foreign key constraints (Álvaro Herrera)

Ensure relation caches are updated properly after renaming constraints (Amit Langote)

Fix replay of GiST index micro-vacuum operations so that concurrent hot-standby queries do not see inconsistent state (Alexander Korotkov)

Prevent empty GIN index pages from being reclaimed too quickly, causing failures of concurrent searches (Andrey Borodin, Alexander Korotkov)

Fix edge-case failures in float-to-integer coercions (Andrew Gierth, Tom Lane)

Fix parsing of space-separated lists of host names in the ldapserver parameter of LDAP authentication entries in pg_hba.conf (Thomas Munro)

When making a PAM authentication request, don’t set the PAM_RHOST variable if the connection is via a Unix socket (Thomas Munro)

Disallow setting client_min_messages higher than ERROR (Jonah Harris, Tom Lane)

Fix ecpglib to use uselocale() or _configthreadlocale() in preference to setlocale() (Michael Meskes, Tom Lane)

Fix incorrect results for numeric data passed through an ecpg SQLDA (SQL Descriptor Area) (Daisuke Higuchi)

Fix psql’s \g `target meta-command to work with `COPY TO STDOUT (Daniel Vérité)

Make psql’s LaTeX output formats render special characters properly (Tom Lane)

Make pgbench’s random number generation fully deterministic and platform-independent when --random-seed=`N` is specified (Fabien Coelho, Tom Lane)

Fix pg_basebackup and pg_verify_checksums to ignore temporary files appropriately (Michael Banck, Michael Paquier)

Fix pg_dump’s handling of materialized views with indirect dependencies on primary keys (Tom Lane)

Make pg_dump include ALTER INDEX SET STATISTICS commands (Michael Paquier)

Fix pg_dump’s dumping of tables that have OIDs (Peter Eisentraut)

Avoid null-pointer-dereference crash on some platforms when pg_dump or pg_restore tries to report an error (Tom Lane)

Prevent false index-corruption reports from contrib/amcheck caused by inline-compressed data (Peter Geoghegan)

Properly disregard SIGPIPE errors if COPY FROM PROGRAM stops reading the program’s output early (Tom Lane)

Fix contrib/hstore to calculate correct hash values for empty hstore values that were created in version 8.4 or before (Andrew Gierth)

Avoid crashes and excessive runtime with large inputs to contrib/intarray’s `gist__int_ops index support (Andrew Gierth)

In configure, look for python3 and then python2 if python isn’t found (Peter Eisentraut)

Include JIT-related headers in the installed set of header files (Donald Dong)

Support new Makefile variables PG_CFLAGS, PG_CXXFLAGS, and PG_LDFLAGS in pgxs builds (Christoph Berg)

Fix Perl-coded build scripts to not assume “[.quote].” is in the search path, since recent Perl versions don’t include that (Andrew Dunstan)

Fix server command-line option parsing problems on OpenBSD (Tom Lane)

Relocate call of set_rel_pathlist_hook so that extensions can use it to supply partial paths for parallel queries (KaiGai Kohei)

Update time zone data files to tzdata release 2018i for DST law changes in Kazakhstan, Metlakatla, and Sao Tome and Principe. Kazakhstan’s Qyzylorda zone is split in two, creating a new zone Asia/Qostanay, as some areas did not change UTC offset. Historical corrections for Hong Kong and numerous Pacific islands.