Correctifs appliqués

Bruce Momjian a poussé :

Tom Lane a poussé :

  • In pg_dump, show server and pg_dump versions with or without --verbose. We used to print this information only in verbose mode, but it's argued that it's useful enough to print always; one reason being that this provides some documentation about which Postgres versions the dump is meant to reload into. Jing Wang, reviewed by Jeevan Chalke http://git.postgresql.org/pg/commitdiff/7700597b34fbb26e377f419271f65be1c13c518f
  • Don't assume a subquery's output is unique if there's a SRF in its tlist. While the x output of "select x from t group by x" can be presumed unique, this does not hold for "select x, generate_series(1,10) from t group by x", because we may expand the set-returning function after the grouping step. (Perhaps that should be re-thought; but considering all the other oddities involved with SRFs in targetlists, it seems unlikely we'll change it.) Put a check in query_is_distinct_for() so it's not fooled by such cases. Back-patch to all supported branches. David Rowley http://git.postgresql.org/pg/commitdiff/9e2f2d7a0539460dc76dbf76dfae17024d5e031e
  • Implement IMPORT FOREIGN SCHEMA. This command provides an automated way to create foreign table definitions that match remote tables, thereby reducing tedium and chances for error. In this patch, we provide the necessary core-server infrastructure and implement the feature fully in the postgres_fdw foreign-data wrapper. Other wrappers will throw a "feature not supported" error until/unless they are updated. Ronan Dunklau and Michael Paquier, additional work by me http://git.postgresql.org/pg/commitdiff/59efda3e50ca4de6a9d5aa4491464e22b6329b1e
  • Fix bug with whole-row references to append subplans. ExecEvalWholeRowVar incorrectly supposed that it could "bless" the source TupleTableSlot just once per query. But if the input is coming from an Append (or, perhaps, other cases?) more than one slot might be returned over the query run. This led to "record type has not been registered" errors when a composite datum was extracted from a non-blessed slot. This bug has been there a long time; I guess it escaped notice because when dealing with subqueries the planner tends to expand whole-row Vars into RowExprs, which don't have the same problem. It is possible to trigger the problem in all active branches, though, as illustrated by the added regression test. http://git.postgresql.org/pg/commitdiff/d68581483564ec0fbfdc255e493c4f5bd165e55e

Fujii Masao a poussé :

Peter Eisentraut a poussé :

Robert Haas a poussé :

Magnus Hagander a poussé :

Andres Freund a poussé :

  • Fix decoding of consecutive MULTI_INSERTs emitted by one heap_multi_insert(). Commit 1b86c81d2d fixed the decoding of toasted columns for the rows contained in one xl_heap_multi_insert record. But that's not actually enough, because heap_multi_insert() will actually first toast all passed in rows and then emit several *_multi_insert records; one for each page it fills with tuples. Add a XLOG_HEAP_LAST_MULTI_INSERT flag which is set in xl_heap_multi_insert->flag denoting that this multi_insert record is the last emitted by one heap_multi_insert() call. Then use that flag in decode.c to only set clear_toast_afterwards in the right situation. Expand the number of rows inserted via COPY in the corresponding regression test to make sure that more than one heap page is filled with tuples by one heap_multi_insert() call. Backpatch to 9.4 like the previous commit. http://git.postgresql.org/pg/commitdiff/626bfad6cc5701eb385b8995e1431ad6a5f24928
  • Minimal psql tab completion support for SET search_path. Complete SET search_path = ... to non-temporary and non-toast schemas. Since there pretty much is no use case to add those to the search path and there can be many it's helpful to exclude them. It'd be nicer to complete multiple search path elements, but that's not easy. Jeff Janes http://git.postgresql.org/pg/commitdiff/bd409519bd19911d2d2cba64415447d2fa9d766b

Correctifs rejetés (à ce jour)

  • No one was disappointed this week

Correctifs en attente

  • Abhijit Menon-Sen sent in another revision of a patch to introduce XLogLockBlockRangeForCleanup().
  • Abhijit Menon-Sen sent in another revision of a patch to add a --stats option to xlogdump.
  • Kaigai Kouhei sent in another revision of a patch to implement a custom plan API.
  • Etsuro Fujita sent in a WIP patch to optimize updating foreign tables in the PostgreSQL FDW.
  • David Rowley sent in two more revisions of a patch to allow removing LEFT JOINs under certain circumstances.
  • Haribabu Kommi sent in another revision of a patch to add min() and max() for the inet data type.
  • Amit Kapila sent in another revision of a patch to fix an issue with duplicate parameters in ALTER SYSTEM.
  • Dilip Kumar sent in another revision of a patch to allow parallel cores to be used by vacuumdb.
  • SAWADA Masahiko and Jeevan Chalke traded patches to add line number as prompt option to psql.
  • Alvaro Herrera sent in another revision of a patch to add minmax indexes.
  • Tomonari Katsumata sent in a patch to ensure that rounding up time value is not less than its unit.
  • Furuya Osamu sent in another revision of a patch to add a synchronous mode to pg_receivexlog.
  • SAWADA Masahiko sent in a patch to fix an issue in timeout of pg_receivexlog --status-interval.
  • Alvaro Herrera sent in a patch to fix the README in anticipation of another patch for CSN-based snapshots.
  • Kyotaro HORIGUCHI and Michael Paquier traded patches to fix an issue in WAL replay.
  • Jeff Davis sent in another revision of a patch to allow IGNORE NULLS in the lead() and lag() windowing functions.
  • Jeff Davis sent in two revisions of a patch to Allow multi-byte characters as escape in SIMILAR TO and SUBSTRING.
  • Tom Lane sent in another revision of a patch to allow NOT IN to use ANTI joins.
  • Tomas Vondra sent in two more revisions of a patch to tweak NTUP_PER_BUCKET.
  • Ali Akbar sent in another revision of a patch to fix xpath() to return namespace definitions.
  • Etsuro Fujita sent in a patch to fix an incorrect comment in postgres_fdw.c.
  • Christoph Martin sent in a patch to fix the search_path default value separator.
  • Etsuro Fujita sent in a patch to add information on exact/lossy blocks for a bitmap heap scan when both the numbers of exact/lossy pages retrieved by the node are zero.
  • Noah Misch sent in a patch to fix an OpenLDAP issue.
  • Fabrízio de Royes Mello sent in another revision of a patch to add ALTER TABLE ... SET LOGGED.
  • Christoph Berg sent in another revision of a patch to secure "make check."
  • Magnus Hagander sent in a patch to include SSL compression info in a psql header.
  • Emre Hesegeli sent in a patch to add selectivity estimation for inet operators.
  • Tomas Vondra sent in another revision of a patch to fix an issue where bad estimation together with large work_mem generates slow hash joins.