[ANNOUNCE] == PostgreSQL Weekly News - October 29 2017 ==

== PostgreSQL Weekly News - October 29 2017 ==

The German-speaking PostgreSQL Conference 2018 will take place on April 13th,
2018 in Berlin.  The CfP is open until January 09, 2018 at
http://2018.pgconf.de/de/callforpapers.html and the conference site is at
http://2018.pgconf.de/

== PostgreSQL Product News ==

Amazon Aurora with PostgreSQL compatibility released.

https://aws.amazon.com/about-aws/whats-new/2017/10/announcing-general-availability-of-amazon-aurora-with-postgresql-compatibility/

A PostgreSQL RPM repository for SLES 12 has been set up at:
https://zypp.postgresql.org/

pg_filedump 10.0 a utility to format PostgreSQL heap/index/control files into a
human-readable form, released.
https://wiki.postgresql.org/wiki/Pg_filedump

== PostgreSQL Jobs for October ==

http://archives.postgresql.org/pgsql-jobs/2017-10/

== PostgreSQL Local ==

pgday.Seoul 2017 will be held in Seoul, South Korea on November 4, 2017.
Korean language information is here:
                               
 
http://pgday.postgresql.kr/

2ndQuadrant PostgreSQL Conference 2017 (2Q PGConf, for short) will be hosted on
November 6th & 7th in New York City, and November 9th in Chicago.
http://www.2qpgconf.com/

PGConf Local: Seattle will be held November 13 - 14, 2017.
https://www.pgconf.us/#Seattle2017

PGDay Australia 2017 will be held on November 17 in Melbourne.
http://2017.pgday.com.au/

PostgreSQL Session will take place November 17th, 2017, in Paris, France.  
http://www.postgresql-sessions.org/en/9/start

PGDAY Brasilia 2017 will take place December 2, 2017.  The CfP
is open at 
http://www.pgdaybrasilia.com.br/submissao-de-palestra/

PGConf Local: Austin will be held December 4 - 5, 2017. Call for Papers is
now open at https://www.pgconf.us/conferences/Austin2017

PGConf.ASIA 2017 will take place on December 4-6 2017 in Akihabara, Tokyo,
Japan.
http://www.pgconf.asia/EN/2017/

FOSDEM PGDay 2018, a one day conference held before the main FOSDEM event will
be held in Brussels, Belgium, on Feb 2nd, 2018.
https://2018.fosdempgday.org/

PGConf India 2018 will be on February 22-23, 2018 in Bengaluru, Karnataka.
Proposals are due via https://goo.gl/forms/F9hRjOIsaNasVOAz2 by October 31st, 2017.
http://pgconf.in/

PostgreSQL@SCaLE is a two day, two track event which takes place on
March 8-9, 2018, at Pasadena Convention Center, as part of SCaLE 16X.
The CfP is open through October 31, 2017 at
http://www.socallinuxexpo.org/scale/16x/cfp

PGConf APAC 2018 will be held in Singapore March 22-24, 2018.  The CfP is open
at http://2018.pgconfapac.org/cfp through December 4, 2017.
http://2018.pgconfapac.org/

== PostgreSQL in the News ==

Planet PostgreSQL: http://planet.postgresql.org/

PostgreSQL Weekly News is brought to you this week by David Fetter

Submit news and announcements by Sunday at 3:00pm EST5EDT.  Please send English
language ones to david@fetter.org, German language to pwn@pgug.de, Italian
language to pwn@itpug.org.

== Applied Patches ==

Tom Lane pushed:

- Adjust psql \d query to avoid use of @> operator.  It seems that the parray_gin extension has seen fit to introduce a
"text[]@> text[]" operator, which conflicts with the core "anyarray @> anyarray" operator, causing ambiguous-operator
failuresif the input arguments are coercible to text[] without being exactly that type.  This strikes me as a bad idea,
butit's out there and people use it.  As of v10, that breaks psql's query that tries to test "pg_statistic_ext.stxkind
@>'{d}'", since stxkind is char[].  The best workaround seems to be to avoid use of that operator.  We can use a
scalar-vs-arraytest "'d' = any(stxkind)" instead; that's arguably more readable anyway.  Per report from Justin Pryzby.
Backpatch to v10 where this query was added.  Discussion: https://postgr.es/m/20171022181525.GA21884@telsasoft.com
https://git.postgresql.org/pg/commitdiff/471d55859c11b40059aef7dd82f82b3a0dc338b1

- Adjust psql \d query to avoid use of @> operator.  It seems that the parray_gin extension has seen fit to introduce a
"text[]@> text[]" operator, which conflicts with the core "anyarray @> anyarray" operator, causing ambiguous-operator
failuresif the input arguments are coercible to text[] without being exactly that type.  This strikes me as a bad idea,
butit's out there and people use it.  As of v10, that breaks psql's query that tries to test "pg_statistic_ext.stxkind
@>'{d}'", since stxkind is char[].  The best workaround seems to be to avoid use of that operator.  We can use a
scalar-vs-arraytest "'d' = any(stxkind)" instead; that's arguably more readable anyway.  Per report from Justin Pryzby.
Backpatch to v10 where this query was added.  Discussion: https://postgr.es/m/20171022181525.GA21884@telsasoft.com
https://git.postgresql.org/pg/commitdiff/471d55859c11b40059aef7dd82f82b3a0dc338b1

- Sync our copy of the timezone library with IANA release tzcode2017c.  This is a trivial update containing only
cosmeticchanges.  The point is just to get back to being synced with an official release of tzcode, rather than some
ad-hocpoint in their commit history, which is where commit 47f849a3c left it.
https://git.postgresql.org/pg/commitdiff/24a1897ab92646795bf065aa1b9d266aba74469f

- Update time zone data files to tzdata release 2017c.  DST law changes in Fiji, Namibia, Northern Cyprus, Sudan,
Tonga,and Turks & Caicos Islands. Historical corrections for Alaska, Apia, Burma, Calcutta, Detroit, Ireland, Namibia,
andPago Pago. https://git.postgresql.org/pg/commitdiff/8df4ce1eac7835d87d89a4fc4d5d3ae5554f87b7
 

- Documentation improvements around domain types.  I was a bit surprised to find that domains were almost completely
unmentionedin the main SGML documentation, outside of the reference pages for CREATE/ALTER/DROP DOMAIN. In particular,
noplacewas it mentioned that we don't support domains over composite, making it hard to document the planned fix for
that. Hence, add a section about domains to chapter 8 (Data Types).  Also, modernize the type system overview in
section37.2; it had never heard of range types, and insisted on calling arrays base types, which seems a bit odd from a
user'sperspective; furthermore it didn't fit well with the fact that we now support arrays over types other than base
types. It seems appropriate to use the term "container types" to describe all of arrays, composites, and ranges, so
let'sdo that.  Also a few other minor improvements, notably improve an example query in rowtypes.sgml by using a
LATERALfunction instead of an ad-hoc OFFSET 0 clause.  In part this is mop-up for commit c12d570fa, which missed
updating37.2 to reflect the fact that it added arrays of domains.  We could possibly back-patch this without that
claim,but I don't feel a strong need to.
https://git.postgresql.org/pg/commitdiff/a32c0923b4da7f7df95616aaecbb85ef9f12f93f

- Documentation improvements around domain types.  I was a bit surprised to find that domains were almost completely
unmentionedin the main SGML documentation, outside of the reference pages for CREATE/ALTER/DROP DOMAIN. In particular,
noplacewas it mentioned that we don't support domains over composite, making it hard to document the planned fix for
that. Hence, add a section about domains to chapter 8 (Data Types).  Also, modernize the type system overview in
section37.2; it had never heard of range types, and insisted on calling arrays base types, which seems a bit odd from a
user'sperspective; furthermore it didn't fit well with the fact that we now support arrays over types other than base
types. It seems appropriate to use the term "container types" to describe all of arrays, composites, and ranges, so
let'sdo that.  Also a few other minor improvements, notably improve an example query in rowtypes.sgml by using a
LATERALfunction instead of an ad-hoc OFFSET 0 clause.  In part this is mop-up for commit c12d570fa, which missed
updating37.2 to reflect the fact that it added arrays of domains.  We could possibly back-patch this without that
claim,but I don't feel a strong need to.
https://git.postgresql.org/pg/commitdiff/a32c0923b4da7f7df95616aaecbb85ef9f12f93f

- Documentation improvements around domain types.  I was a bit surprised to find that domains were almost completely
unmentionedin the main SGML documentation, outside of the reference pages for CREATE/ALTER/DROP DOMAIN. In particular,
noplacewas it mentioned that we don't support domains over composite, making it hard to document the planned fix for
that. Hence, add a section about domains to chapter 8 (Data Types).  Also, modernize the type system overview in
section37.2; it had never heard of range types, and insisted on calling arrays base types, which seems a bit odd from a
user'sperspective; furthermore it didn't fit well with the fact that we now support arrays over types other than base
types. It seems appropriate to use the term "container types" to describe all of arrays, composites, and ranges, so
let'sdo that.  Also a few other minor improvements, notably improve an example query in rowtypes.sgml by using a
LATERALfunction instead of an ad-hoc OFFSET 0 clause.  In part this is mop-up for commit c12d570fa, which missed
updating37.2 to reflect the fact that it added arrays of domains.  We could possibly back-patch this without that
claim,but I don't feel a strong need to.
https://git.postgresql.org/pg/commitdiff/a32c0923b4da7f7df95616aaecbb85ef9f12f93f

- Make setrefs.c match by ressortgroupref even for plain Vars.  Previously, we skipped using
search_indexed_tlist_for_sortgroupref()if the tlist expression being sought in the child plan node was merely a Var.
Thisis purely an optimization, based on the theory that search_indexed_tlist_for_var() is faster, and one copy of a Var
shouldbe as good as another.  However, the GROUPING SETS patch broke the latter assumption: grouping columns containing
the"same" Var can sometimes have different outputs, as shown in the test case added here.  So do it the hard way
whenevera ressortgroupref marking exists. (If this seems like a bottleneck, we could imagine building a tlist index
datastructure for ressortgroupref values, as we do for Vars.  But I'll let that idea go until there's some evidence
it'sworthwhile.) Back-patch to 9.6.  The problem also exists in 9.5 where GROUPING SETS came in, but this patch is
insufficientto resolve the problem in 9.5: there is some obscure dependency on the upper-planner-pathification work
thathappened in 9.6.  Given that this is such a weird corner case, and no end users have complained about it, it
doesn'tseem worth the work to develop a fix for 9.5.  Patch by me, per a report from Heikki Linnakangas.  (This does
notfix Heikki's original complaint, just the follow-on one.) Discussion:
https://postgr.es/m/aefc657e-edb2-64d5-6df1-a0828f6e9104@iki.fi
https://git.postgresql.org/pg/commitdiff/08f1e1f0a47b4b0e87b07b9794698747b279c711

- Support domains over composite types.  This is the last major omission in our domains feature: you can now make a
domainover anything that's not a pseudotype.  The major complication from an implementation standpoint is that places
thatmight be creating tuples of a domain type now need to be prepared to apply domain_check().  It seems better that
unpreparedcode fail with an error like "<type> is not composite" than that it silently fail to apply domain
constraints. Therefore, relevant infrastructure like get_func_result_type() and lookup_rowtype_tupdesc() has been
adjustedto treat domain-over-composite as a distinct case that unprepared code won't recognize, rather than just
transparentlytreating it the same as plain composite.  This isn't a 100% solution to the possibility of overlooked
domainchecks, but it catches most places.  In passing, improve typcache.c's support for domains (it can now cache the
identityof a domain's base type), and rewrite the argument handling logic in jsonfuncs.c's populate_record[set]_worker
toreduce duplicative per-call lookups.  I believe this is code-complete so far as the core and contrib code go.  The
PLsneed varying amounts of work, which will be tackled in followup patches.  Discussion:
https://postgr.es/m/4206.1499798337@sss.pgh.pa.us
https://git.postgresql.org/pg/commitdiff/37a795a60b4f4b1def11c615525ec5e0e9449e05

- Support domains over composite types in PL/Tcl.  Since PL/Tcl does little with SQL types internally, this is just a
matterof making it work with composite-domain function arguments and results.  In passing, make it allow RECORD-type
arguments--- that's a trivial change that nobody had bothered with up to now.  Discussion:
https://postgr.es/m/4206.1499798337@sss.pgh.pa.us
https://git.postgresql.org/pg/commitdiff/820c0305f64507490f00b6220f9175a303c821dd

- Doc: mention that you can't PREPARE TRANSACTION after NOTIFY.  The NOTIFY page said this already, but the PREPARE
TRANSACTIONpage missed it.  Discussion: https://postgr.es/m/20171024010602.1488.80066@wrigleys.postgresql.org
https://git.postgresql.org/pg/commitdiff/e4fbf22831c2bbcf032ee60a327b871d2364b3f5

- Rethink the dependencies recorded for FieldSelect/FieldStore nodes.  On closer investigation, commits f3ea3e3e8 et al
werea few bricks shy of a load.  What we need is not so much to lock down the result type of a FieldSelect, as to lock
downthe existence of the column it's trying to extract.  Otherwise, we can break it by dropping that column.  The
dependencyon the result type is then held indirectly through the column, and doesn't need to be recorded explicitly.
Outof paranoia, I left in the code to record a dependency on the result type, but it's used only if we can't identify
thepg_class OID for the column.  That shouldn't ever happen right now, AFAICS, but it seems possible that in future the
inputnode could be marked as being of type RECORD rather than some specific composite type.  Likewise for FieldStore.
Likethe previous patch, back-patch to all supported branches.  Discussion:
https://postgr.es/m/22571.1509064146@sss.pgh.pa.us
https://git.postgresql.org/pg/commitdiff/6784d7a1dc69d53b7f41eebf62bf7ffd63885294

- Fix crash when columns have been added to the end of a view.  expandRTE() supposed that an RTE_SUBQUERY subquery must
haveexactly as many non-junk tlist items as the RTE has column aliases for it.  This was true at the time the code was
written,and is still true so far as parse analysis is concerned --- but when the function is used during planning, the
subquerymight have appeared through insertion of a view that now has more columns than it did when the outer query was
parsed. This results in a core dump if, for instance, we have to expand a whole-row Var that references the subquery.
Toavoid crashing, we can either stop expanding the RTE when we run out of aliases, or invent new aliases for the added
columns. While the latter might be more useful, the former is consistent with what expandRTE() does for
composite-returningfunctions in the RTE_FUNCTION case, so it seems like we'd better do it that way.  Per bug #14876
fromSamuel Horwitz.  This has been busted since commit ff1ea2173 allowed views to acquire more columns, so back-patch
toall supported branches.  Discussion: https://postgr.es/m/20171026184035.1471.82810@wrigleys.postgresql.org
https://git.postgresql.org/pg/commitdiff/d5b760ecb5e172252810fae877e6d6193b818167

- Dept of second thoughts: keep aliasp_item in sync with tlistitem.  Commit d5b760ecb wasn't quite right, on second
thought:if the caller didn't ask for column names then it would happily emit more Vars than if the caller did ask for
columnnames.  This is surely not a good idea.  Advance the aliasp_item whether or not we're preparing a colnames list.
https://git.postgresql.org/pg/commitdiff/d76886c2d33123299ce7c8255a71e39b9e53711b

- Support domains over composite types in PL/Perl.  In passing, don't insist on rsi->expectedDesc being set unless we
actuallyneed it; this allows succeeding in a couple of cases where PL/Perl functions returning setof composite would
havefailed before, and makes the error message more apropos in other cases. Discussion:
https://postgr.es/m/4206.1499798337@sss.pgh.pa.us
https://git.postgresql.org/pg/commitdiff/60651e4cddbb77e8f1a0c7fc0be6a7e7bf626fe0

Andrew Dunstan pushed:

- Add a utility function to extract variadic function arguments.  This is epecially useful in the case or "VARIADIC
ANY"functions. The caller can get the artguments and types regardless of whether or not and explicit VARIADIC array
argumenthas been used. The function also provides an option to convert arguments on type "unknown" to to "text".
MichaelPaquier and me, reviewed by Tom Lane.  Backpatch to 9.4 in order to support the following json bug fix.
https://git.postgresql.org/pg/commitdiff/f3c6e8a27a8f8436cada9a42e4f57338ed38c785

- Process variadic arguments consistently in json functions.  json_build_object and json_build_array and the jsonb
equivalentsdid not correctly process explicit VARIADIC arguments. They are modified to use the new
extract_variadic_args()utility function which abstracts away the details of the call method.  Michael Paquier, reviewed
byTom Lane and Dmitry Dolgov. Backpatch to 9.5 for the jsonb fixes and 9.4 for the json fixes, as that's where they
originated.https://git.postgresql.org/pg/commitdiff/18fc4ecf4afafe40bd7e7577bd611e5caf74c9fd
 

- Undo inadvertent change in capitalization in commit 18fc4ec.
https://git.postgresql.org/pg/commitdiff/adee9e4e317169463816d005e8bf901333271917

- Improve gendef.pl diagnostic on failure to open sym file.  There have been numerous buildfarm failures but the
diagnosticis currently silent about the reason for failure to open the file. Let's see if we can get to the bottom of
it. Backpatch to all live branches. https://git.postgresql.org/pg/commitdiff/74d2c0dbfd94aa5512be3828a793b4c2d43df2d0
 

Michael Meskes pushed:

- Fixed handling of escape character in libecpg.  Patch by Tsunakawa Takayuki <tsunakawa.takay@jp.fujitsu.com>
https://git.postgresql.org/pg/commitdiff/0af98a95cf8397d36202a34cd615f222faf24e9a

Robert Haas pushed:

- In relevant log messages, indicate whether vacuums are aggressive.  Kyotaro Horiguchi, reviewed Masahiko Sawada,
DavidG. Johnston, Álvaro Herrera, and me.  Grammar correction to the final posted patch by me.  Discussion:
http://postgr.es/m/20170329.124649.193656100.horiguchi.kyotaro@lab.ntt.co.jp
https://git.postgresql.org/pg/commitdiff/b55509332f50f998b6e8b3830a51c5b9d8f666aa

- Fix mistaken failure to allow parallelism in corner case.  If we try to run a parallel plan in serial mode because,
forexample, it's going to be scanned via a cursor, but for some reason we're already in parallel mode (for example
becausean outer query is running in parallel), we'd incorrectly try to launch workers.  Fix by adding a flag to the
EState,so that we can be certain that ExecutePlan() and ExecGather()/ExecGatherMerge() will have the same idea about
whetherwe are executing serially or in parallel.  Report and fix by Amit Kapila with help from Kuntal Ghosh.  A few
tweaksby me.  Discussion: http://postgr.es/m/CAA4eK1+_BuZrmVCeua5Eqnm4Co9DAXdM5HPAOE2J19ePbR912Q@mail.gmail.com
https://git.postgresql.org/pg/commitdiff/639c1a6bb9ee08fe4757a6fab1ddbd01291515e1

- Move new structure member to the end.  Reduces ABI breakage.  Per Tom Lane. Discussion:
http://postgr.es/m/4035.1509113974@sss.pgh.pa.us
https://git.postgresql.org/pg/commitdiff/94d622f27be6d48e61a68496da4f2efb06fe8746

- Revert "Move new structure member to the end.".  This reverts commit 94d622f27be6d48e61a68496da4f2efb06fe8746.  That
commitwas supposed to get pushed to REL_10_STABLE, but I messed up.
https://git.postgresql.org/pg/commitdiff/f0392e677ed098e9e514ad5e4d5dc148c0474c63

- Allow parallel query for prepared statements with generic plans.  This was always intended to work, but due to an
oversightin max_parallel_hazard_walker, it didn't.  In testing, we missed the fact that it was only working for custom
plans,where the parameter value has been substituted for the parameter itself early enough that everything worked.  In
ageneric plan, the Param node survives and must be treated as parallel-safe. SerializeParamList provides for the
transmissionof parameter values to workers.  Amit Kapila with help from Kuntal Ghosh.  Some changes by me. Discussion:
http://postgr.es/m/CAA4eK1+_BuZrmVCeua5Eqnm4Co9DAXdM5HPAOE2J19ePbR912Q@mail.gmail.com
https://git.postgresql.org/pg/commitdiff/682ce911f8f30de39b13cf211fc8ceb8c6cbc01b

- Fix misplaced ReleaseSysCache call in get_default_partition_oid.  Julien Rouhaud Discussion:
http://postgr.es/m/CAOBaU_Y4omLA+VbsVdA-JwBLoJWiPxfdKCkMjrZM7NMZxa1fKw@mail.gmail.com
https://git.postgresql.org/pg/commitdiff/1310ac258c773ab9d41650b509098dd01cb4ecf3

- Fix grammar.  Etsuro Fujita Discussion: http://postgr.es/m/cc7767b6-6a1b-74a2-8b3c-48b8e64c12ed@lab.ntt.co.jp
https://git.postgresql.org/pg/commitdiff/24fd674a1affe1ca9776bd6b21b2b35feb0fe6ed

- Add table_constraint synopsis to ALTER TABLE documentation.  This is already present in the CREATE TABLE
documentation,but it's nicer not to have to refer to CREATE TABLE to find out the syntax for ALTER TABLE.  Lætitia
Avrothttps://git.postgresql.org/pg/commitdiff/9f295c08f8776213ccb592de0c4f094738d6d841
 

- Improve comments for parallel executor estimation functions.  The previous comment (which was copied as boilerplate
fromone file to the next) implied that it was the executor node itself which was being serialized, but that's not
right. We're not serializing the executor nodes; we're just allowing them to store some additional information in DSM.
Adjuststhe comment to reflect this.  Discussion:
http://postgr.es/m/CA+TgmoaHVinxG=3h6qBAsyV8xaDyQwbzK7YZnYfE8nJFMK1=FA@mail.gmail.com
https://git.postgresql.org/pg/commitdiff/11c1d555cebe8045a45bc0ee10d0673fad8d4895

- Fix typo.  Eiji Seki Discussion: http://postgr.es/m/A11BD0E1A40FAC479D740CEFA373E203397E5276@g01jpexmbkw05
https://git.postgresql.org/pg/commitdiff/c6fd5cd7062283575a436ec4ea3ed7899ace79a0

- Add hash_combine64.  Extracted from a larger patch by Amul Sul, with some comment additions by me.  Discussion:
http://postgr.es/m/20171024113004.hn5qajypin4dy5sw@alap3.anarazel.de
https://git.postgresql.org/pg/commitdiff/b7f3eb31405f1dbbf086e5a8f88569a6dc85157a

- pg_receivewal: Add --no-sync option.  Michael Paquier, reviewed by Kuntal Ghosh and by me.  I did a little
wordsmithingon the documentation, too. Discussion:
http://postgr.es/m/CAB7nPqTuXuyEoVKcWcExh_b0uAjgWd_14KfGLrCTccBZ=VA0KA@mail.gmail.com
https://git.postgresql.org/pg/commitdiff/5f3971291fc231bb65a38198b1bcb1c29ef63108

- Fix problems with the "role" GUC and parallel query.  Without this fix, dropping a role can sometimes result in
parallelquery failures in sessions that have used "SET ROLE" to assume the dropped role, even if that setting isn't
activeany more.  Report by Pavan Deolasee.  Patch by Amit Kapila, reviewed by me.  Discussion:
http://postgr.es/m/CABOikdOomRcZsLsLK+Z+qENM1zxyaWnAvFh3MJZzZnnKiF+REg@mail.gmail.com
https://git.postgresql.org/pg/commitdiff/846fcc85167c417873865099d70068ed85f758a8

== Pending Patches ==

Tom Lane sent in a patch to fix an asymmetry in parse_func.c.

Amit Langote and Tom Lane traded patches to fix an infelicity in
joinaliasvars uncovered by sqlsmith.

Álvaro Herrera sent in two revisions of a patch to fix autovacuum work items.

Amit Khandekar sent in two more revisions of a patch to implement UPDATE of
partition keys in declaratively partitioned tables so that tuples move to the
appropriate partition as needed.

Doug Rady sent in another revision of a patch to pgbench which adds an option to
build using ppoll() for larger connection counts.

Ivan Kartyshov sent in three more revisions of a patch to make async subscribers
to wait for lsn to be replayed.

Amit Langote sent in five more revisions of a patch to prune partitions faster.

Álvaro Herrera sent in two more revisions of a patch to enable indexes on
partitions to be unique.

Thomas Munro sent in two more revisions of a patch to implement parallel hash.

Anthony Bykov sent in a patch to add a JSONB TRANSFORM for PL/Perl.

Simon Riggs sent in a patch to remove the code that maintained two checkpoint's
WAL files and all associated stuff.

Masahiko Sawada sent in another revision of a patch to allow atomic commits on
foreign servers.

Amul Sul sent in two more revisions of a patch to add hash partitioning.

Anthony Bykov sent in a patch to create a JSONB TRANSFORM for PL/Python2U.

Tomas Vondra sent in two revisions of a patch to implement BRIN multi-range
indexes.

Michaël Paquier sent in three revisions of a patch to implement pg_receivewal
--no-sync.

Jing Wang sent in a patch to support unicode host variables in ECPG.

Gao Zengqi (高增琦) sent in a patch to fix an endless loop in ECPG in informix
mode.

Petr Jelínek sent in a patch to prevent resetting additional columns on the
logical subscriber to NULL after UPDATE.  When the subscriber's table had extra
columns, this was happening, and was usually the wrong thing.

Rushabh Lathia sent in another revision of a patch to add parallel B-tree index
build sorting.

Masahiko Sawada sent in another revision of a patch to move relation extension
locks out of the heavyweight lock manager.

Michaël Paquier sent in a patch to place the timeline ID in the backup_label
file.

Kyotaro HORIGUCHI sent in another revision of a patch to enable switching WAL
source in the midst of a record.

Etsuro Fujita sent in two more revisions of a patch to add support for tuple
routing to foreign partitions.

Peter Eisentraut sent in a patch to convert ids to upper case at build time.

Yura Sokolov sent in two more revisions of a patch to implement logical decoding
of two-phase transactions.

Lætitia Avrot sent in a patch to add a table_constraint description to the ALTER
TABLE synopsis.

Andrey Borodin sent in two revisions of a patch to add index-only scan for cube
and seg.

Peter Eisentraut sent in another revision of a patch to replace hand-tooled
boolean handling with stdbool.h.

Robert Haas sent in another revision of a patch to enable libpq protocol negotiation.

Jeevan Chalke sent in another revision of a patch to implement partition-wise
aggregation/grouping.

Takayuki Tsunakawa sent in two revisions of a patch to fix a startup crash on
Windows.

Julien Rouhaud sent in a patch to fix unsafe tuple releasing in
get_default_partition_oid.

Pavel Stěhule sent in a patch to enable psql to take sorting arguments for some
of its \ commands.

Chris Travers sent in a patch to restrict pg_rewind to data/wal directories.

Amit Kapila sent in another revision of a patch to make extern params parallel
safe.

Amit Kapila sent in another revision of a patch to fix role handling in parallel
workers.

Nikolay Shaplov sent in a patch to better document some regression tests for
reloptions.

Dmitry Dolgov sent in another revision of a patch to implement generic type
subscripting.



-- 
Sent via pgsql-announce mailing list (pgsql-announce@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-announce