[COMMITTERS] pgsql: Doc: add a section in Part II concerning RETURNING.

2016-11-22 Thread Tom Lane
Doc: add a section in Part II concerning RETURNING. There are assorted references to RETURNING in Part II, but nothing that would qualify as an explanation of the feature, which seems like an oversight considering how useful it is. Add something. Noted while looking for a place to point a cross-

[COMMITTERS] pgsql: Doc: add a section in Part II concerning RETURNING.

2016-11-22 Thread Tom Lane
Doc: add a section in Part II concerning RETURNING. There are assorted references to RETURNING in Part II, but nothing that would qualify as an explanation of the feature, which seems like an oversight considering how useful it is. Add something. Noted while looking for a place to point a cross-

[COMMITTERS] pgsql: Doc: add a section in Part II concerning RETURNING.

2016-11-22 Thread Tom Lane
Doc: add a section in Part II concerning RETURNING. There are assorted references to RETURNING in Part II, but nothing that would qualify as an explanation of the feature, which seems like an oversight considering how useful it is. Add something. Noted while looking for a place to point a cross-

[COMMITTERS] pgsql: Doc: add a section in Part II concerning RETURNING.

2016-11-22 Thread Tom Lane
Doc: add a section in Part II concerning RETURNING. There are assorted references to RETURNING in Part II, but nothing that would qualify as an explanation of the feature, which seems like an oversight considering how useful it is. Add something. Noted while looking for a place to point a cross-

[COMMITTERS] pgsql: Doc: add a section in Part II concerning RETURNING.

2016-11-22 Thread Tom Lane
Doc: add a section in Part II concerning RETURNING. There are assorted references to RETURNING in Part II, but nothing that would qualify as an explanation of the feature, which seems like an oversight considering how useful it is. Add something. Noted while looking for a place to point a cross-

[COMMITTERS] pgsql: Doc: add a section in Part II concerning RETURNING.

2016-11-22 Thread Tom Lane
Doc: add a section in Part II concerning RETURNING. There are assorted references to RETURNING in Part II, but nothing that would qualify as an explanation of the feature, which seems like an oversight considering how useful it is. Add something. Noted while looking for a place to point a cross-

[COMMITTERS] pgsql: Support condition variables.

2016-11-22 Thread Robert Haas
Support condition variables. Condition variables provide a flexible way to sleep until a cooperating process causes an arbitrary condition to become true. In simple cases, this can be accomplished with a WaitLatch/ResetLatch loop; the cooperating process can call SetLatch after performing work th

[COMMITTERS] pgsql: Improve handling of "UPDATE ... SET (column_list) = row_construc

2016-11-22 Thread Tom Lane
Improve handling of "UPDATE ... SET (column_list) = row_constructor". Previously, the right-hand side of a multiple-column assignment, if it wasn't a sub-SELECT, had to be a simple parenthesized expression list, because gram.y was responsible for "bursting" the construct into independent column as

[COMMITTERS] pgsql: Code review for commit 274bb2b3857cc987cfa21d14775cae9b0dababa5.

2016-11-22 Thread Robert Haas
Code review for commit 274bb2b3857cc987cfa21d14775cae9b0dababa5. Avoid memory leak in conninfo_uri_parse_options. Use the current host rather than the comma-separated list of host names when the host name is needed for GSS, SSPI, or SSL authentication. Document the way connect_timeout interacts

[COMMITTERS] pgsql: Doc: improve documentation about composite-value usage.

2016-11-22 Thread Tom Lane
Doc: improve documentation about composite-value usage. Create a section specifically for the syntactic rules around whole-row variable usage, such as expansion of "foo.*". This was previously documented only haphazardly, with some critical info buried in unexpected places like xfunc-sql-composit

[COMMITTERS] pgsql: Doc: improve documentation about composite-value usage.

2016-11-22 Thread Tom Lane
Doc: improve documentation about composite-value usage. Create a section specifically for the syntactic rules around whole-row variable usage, such as expansion of "foo.*". This was previously documented only haphazardly, with some critical info buried in unexpected places like xfunc-sql-composit

[COMMITTERS] pgsql: Doc: improve documentation about composite-value usage.

2016-11-22 Thread Tom Lane
Doc: improve documentation about composite-value usage. Create a section specifically for the syntactic rules around whole-row variable usage, such as expansion of "foo.*". This was previously documented only haphazardly, with some critical info buried in unexpected places like xfunc-sql-composit

[COMMITTERS] pgsql: Doc: improve documentation about composite-value usage.

2016-11-22 Thread Tom Lane
Doc: improve documentation about composite-value usage. Create a section specifically for the syntactic rules around whole-row variable usage, such as expansion of "foo.*". This was previously documented only haphazardly, with some critical info buried in unexpected places like xfunc-sql-composit

[COMMITTERS] pgsql: Doc: improve documentation about composite-value usage.

2016-11-22 Thread Tom Lane
Doc: improve documentation about composite-value usage. Create a section specifically for the syntactic rules around whole-row variable usage, such as expansion of "foo.*". This was previously documented only haphazardly, with some critical info buried in unexpected places like xfunc-sql-composit

[COMMITTERS] pgsql: Doc: improve documentation about composite-value usage.

2016-11-22 Thread Tom Lane
Doc: improve documentation about composite-value usage. Create a section specifically for the syntactic rules around whole-row variable usage, such as expansion of "foo.*". This was previously documented only haphazardly, with some critical info buried in unexpected places like xfunc-sql-composit

[COMMITTERS] pgsql: Doc: in back branches, don't call it a row constructor if it isn

2016-11-22 Thread Tom Lane
Doc: in back branches, don't call it a row constructor if it isn't really. Before commit 906bfcad7, we were not actually processing the righthand side of a multiple-column assignment in UPDATE as a row constructor: it was just a parenthesized list of expressions. Call it that rather than risking

[COMMITTERS] pgsql: Doc: in back branches, don't call it a row constructor if it isn

2016-11-22 Thread Tom Lane
Doc: in back branches, don't call it a row constructor if it isn't really. Before commit 906bfcad7, we were not actually processing the righthand side of a multiple-column assignment in UPDATE as a row constructor: it was just a parenthesized list of expressions. Call it that rather than risking

Re: [COMMITTERS] pgsql: Doc: improve documentation about composite-value usage.

2016-11-22 Thread David G. Johnston
On Tue, Nov 22, 2016 at 3:56 PM, Tom Lane wrote: > Doc: improve documentation about composite-value usage. > > Create a section specifically for the syntactic rules around whole-row > variable usage, such as expansion of "foo.*". This was previously > documented only haphazardly, with some criti

[COMMITTERS] pgsql: Remove barrier.h

2016-11-22 Thread Robert Haas
Remove barrier.h A new thing also called a "barrier" is proposed, but whether we decide to take that patch or not, this file seems to have outlived its usefulness. Thomas Munro Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/e343dfa42bff35983c582da3916b205763aeac90

Re: [COMMITTERS] pgsql: Doc: improve documentation about composite-value usage.

2016-11-22 Thread Tom Lane
"David G. Johnston" writes: > ​I found it notable that you choose to introduce the OFFSET 0 hack instead > of writing a LATERAL query in the "optimization failure" example.​ > SELECT (m).* FROM (SELECT myfunc(x) AS m FROM some_table OFFSET 0) ss; > instead of​ > SELECT (m).* FROM some_table, LATER