pgsql: Reduce memory consumption for multi-statement query strings.

2019-07-10 Thread Tom Lane
Reduce memory consumption for multi-statement query strings. Previously, exec_simple_query always ran parse analysis, rewrite, and planning in MessageContext, allowing all the data generated thereby to persist until the end of processing of the whole query string. That's fine for single-command st

pgsql: docs: remove pg_roles mention of the oid column being displayed

2019-07-10 Thread Bruce Momjian
docs: remove pg_roles mention of the oid column being displayed It is now always displayed in PG 12+. Discussion: https://postgr.es/m/b6ec6167-5dd5-6347-ac1d-1fd493820...@2ndquadrant.com Author: Ian Barwick Backpatch-through: 12 Branch -- master Details --- https://git.postgresql.or

pgsql: docs: remove pg_roles mention of the oid column being displayed

2019-07-10 Thread Bruce Momjian
docs: remove pg_roles mention of the oid column being displayed It is now always displayed in PG 12+. Discussion: https://postgr.es/m/b6ec6167-5dd5-6347-ac1d-1fd493820...@2ndquadrant.com Author: Ian Barwick Backpatch-through: 12 Branch -- REL_12_STABLE Details --- https://git.postgr

pgsql: Mention limitation of unique in partitioned tables

2019-07-10 Thread Alvaro Herrera
Mention limitation of unique in partitioned tables Per gripe from Phil Bayer. Authors: Amit Langote and others Discussion: https://postgr.es/m/156236160709.1192.4498528196556144...@wrigleys.postgresql.org Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/5918

pgsql: Mention limitation of unique in partitioned tables

2019-07-10 Thread Alvaro Herrera
Mention limitation of unique in partitioned tables Per gripe from Phil Bayer. Authors: Amit Langote and others Discussion: https://postgr.es/m/156236160709.1192.4498528196556144...@wrigleys.postgresql.org Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/2208

pgsql: Fix compile failure

2019-07-10 Thread Alvaro Herrera
Fix compile failure REL_11_STABLE's configure does not select C99 mode by default, so using C99 block initializer broke the build for some compilers. Revert to C89 in that branch. Author: Michaƫl Paquier Discussion: https://postgr.es/m/20190710070122.ge1...@paquier.xyz Branch -- REL_11_STAB

pgsql: Mention limitation of unique in partitioned tables

2019-07-10 Thread Alvaro Herrera
Mention limitation of unique in partitioned tables Per gripe from Phil Bayer. Authors: Amit Langote and others Discussion: https://postgr.es/m/156236160709.1192.4498528196556144...@wrigleys.postgresql.org Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/ec4eaab78b0

Re: pgsql: Propagate trigger arguments to partitions

2019-07-10 Thread Michael Paquier
On Wed, Jul 10, 2019 at 08:53:36AM -0400, Alvaro Herrera wrote: > I kinda like block-scoped variables, braindead though they are in > C, so I'll just patch pg11. It's not like this code changes too much > anyway (famous last words). Thanks! That's fine by me. -- Michael signature.asc Descripti

Re: pgsql: Propagate trigger arguments to partitions

2019-07-10 Thread Alvaro Herrera
On 2019-Jul-10, Michael Paquier wrote: Hello > This commit has broken the buildfarm on REL_11_STABLE for a couple of > animals: > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=prion&dt=2019-07-10%2006%3A27%3A02 Argh. You say "a couple", you mean "half the buildfarm for that branch" :-

pgsql: Assorted fixes for jsonpath documentation

2019-07-10 Thread Alexander Korotkov
Assorted fixes for jsonpath documentation This commit contains assorted fixes for jsonpath documentation including: grammar fixes, incorrect examples fixes as well as wording improvements. Discussion: https://postgr.es/m/CAA-aLv4VVX%3Db9RK5hkfPXJczqaiTdqO04teW9i0wiQVhdKcqzw%40mail.gmail.com Auth

Re: pgsql: Propagate trigger arguments to partitions

2019-07-10 Thread Michael Paquier
Hi Alvaro, On Tue, Jul 09, 2019 at 09:23:45PM +, Alvaro Herrera wrote: > Propagate trigger arguments to partitions > > We were creating the cloned triggers with an empty list of arguments, > losing the ones that had been specified by the user when creating the > trigger in the partitioned tab