[COMMITTERS] pgsql: doc: Improve markup

2017-03-21 Thread Peter Eisentraut
doc: Improve markup Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/010505546a343820f291e0e298673108e436c696 Modified Files -- doc/src/sgml/ref/alter_table.sgml | 2 +- doc/src/sgml/ref/create_table.sgml | 2 +- 2 files changed, 2 insertions(+), 2 deletion

[COMMITTERS] pgsql: Add a direct function call mechanism using the caller's context.

2017-03-21 Thread Andrew Dunstan
Add a direct function call mechanism using the caller's context. The current DirectFunctionCall functions use NULL as the flinfo in initializing the FunctionCallInfoData for the call. That means the called function has no fn_mcxt or fn_extra to work with, and attempting to do so will result in an

[COMMITTERS] pgsql: Fix support for some operators (&<, &>, $<|, |&>) in box operato

2017-03-21 Thread Teodor Sigaev
Fix support for some operators (&<, &>, $<|, |&>) in box operator class of SP-GiST. Bug exists since initial commit of box opclass for SP-GiST, so backpath to 9.6 Author: Nikita Glukhov with minor editorization of tests by me Reviewed-by: Kyotaro Horiguchi, Anastasia Lubennikova https://commitfe

[COMMITTERS] pgsql: Fix support for some operators (&<, &>, $<|, |&>) in box operato

2017-03-21 Thread Teodor Sigaev
Fix support for some operators (&<, &>, $<|, |&>) in box operator class of SP-GiST. Bug exists since initial commit of box opclass for SP-GiST, so backpath to 9.6 Author: Nikita Glukhov with minor editorization of tests by me Reviewed-by: Kyotaro Horiguchi, Anastasia Lubennikova https://commitfe

[COMMITTERS] pgsql: Don't scan partitioned tables.

2017-03-21 Thread Robert Haas
Don't scan partitioned tables. Partitioned tables do not contain any data; only their unpartitioned descendents need to be scanned. However, the partitioned tables still need to be locked, even though they're not scanned. To make that work, Append and MergeAppend relations now need to carry a li

Re: [COMMITTERS] pgsql: Don't scan partitioned tables.

2017-03-21 Thread Simon Riggs
On 21 March 2017 at 13:48, Robert Haas wrote: > Don't scan partitioned tables. Sounds good. > Aside from the obvious advantage of avoiding some work at execution > time, this has two other advantages. First, it may improve the > planner's decision-making in some cases since the empty relation >

Re: [COMMITTERS] pgsql: Don't scan partitioned tables.

2017-03-21 Thread Robert Haas
On Tue, Mar 21, 2017 at 10:01 AM, Simon Riggs wrote: > On 21 March 2017 at 13:48, Robert Haas wrote: >> Don't scan partitioned tables. > > Sounds good. > >> Aside from the obvious advantage of avoiding some work at execution >> time, this has two other advantages. First, it may improve the >> pl

[COMMITTERS] pgsql: Add a pg_recvlogical wrapper to PostgresNode

2017-03-21 Thread Simon Riggs
Add a pg_recvlogical wrapper to PostgresNode Allows testing of logical decoding using SQL interface and/or pg_recvlogical Most logical decoding tests are in contrib/test_decoding. This module is for work that doesn't fit well there, like where server restarts are required. Craig Ringer Branch --

[COMMITTERS] pgsql: Add btree_gin support for enum types

2017-03-21 Thread Andrew Dunstan
Add btree_gin support for enum types Reviewed by Tom Lane and Anastasia Lubennikova Discussion: http://postgr.es/m/[email protected] Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/4ad0f88c443ca60de9b65cd0afd794fb80b10d86 Modified Files --

[COMMITTERS] pgsql: Add btree_gist support for enum types.

2017-03-21 Thread Andrew Dunstan
Add btree_gist support for enum types. This will allow enums to be used in exclusion constraints. The code uses the new CallerFInfoFunctionCall infrastructure in fmgr, and the support for it added to btree_gist in commit 393bb504d7. Reviewed by Tom Lane and Anastasia Lubennikova Discussion: ht

[COMMITTERS] pgsql: Use CallerFInfoFunctionCall with btree_gist for varlena types

2017-03-21 Thread Andrew Dunstan
Use CallerFInfoFunctionCall with btree_gist for varlena types Follow up to commit 393bb504d7 which did this for numeric types. Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/65a9138b9b66b2c915619344ca56f4f0d531ada7 Modified Files -- contrib/btree_gist/b

[COMMITTERS] pgsql: Use CallerFInfoFunctionCall with btree_gist for numeric types

2017-03-21 Thread Andrew Dunstan
Use CallerFInfoFunctionCall with btree_gist for numeric types None of the existing types actually need to use this mechanism, but this will allow support for enum types which will need it. A separate patch will adjust the varlena types support for consistency. Reviewed by Tom Lane and Anastasia L

[COMMITTERS] pgsql: Document btree_gin support for enums

2017-03-21 Thread Andrew Dunstan
Document btree_gin support for enums Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/80275561fffb58e48da2d3fd72b72a3bfbee8669 Modified Files -- doc/src/sgml/btree-gin.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) -- Sent via pgsql-committer

Re: [HACKERS] [COMMITTERS] pgsql: Add missing support for new node fields

2017-03-21 Thread Fabien COELHO
Hello Andres, It is not done yet, but it looks that it can work in the end with limited effort. Currently it works for copy & equal. It'd have to do out/read as well imo. Sure. This part is WIP, though. Is there some interest to generate the x00kB of sources rather than edit them everytim

[COMMITTERS] pgsql: doc: Update tool sets documentation for modern FreeBSD

2017-03-21 Thread Peter Eisentraut
doc: Update tool sets documentation for modern FreeBSD For several operating systems, we give handy package manager one-liners to install all the requirements for building our documentation. All current production FreeBSD releases have a friendly new package manager a bit like apt/yum, so give a

[COMMITTERS] pgsql: pg_dump: Only dump publications when dumping everything

2017-03-21 Thread Peter Eisentraut
pg_dump: Only dump publications when dumping everything Don't dump publications with pg_dump -t or similar cases that select specific groups of objects. Author: Petr Jelinek Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/05227e0c345247c9e9ff91445850f414e2b0bb70 M

[COMMITTERS] pgsql: Avoid Perl warning

2017-03-21 Thread Peter Eisentraut
Avoid Perl warning Perl versions before 5.12 would warn "Use of implicit split to @_ is deprecated". Author: Jeff Janes Branch -- master Details --- http://git.postgresql.org/pg/commitdiff/9ca2dd578db4086ae8a6eb6fd82ac376b7b2804e Modified Files -- src/test/recovery/t/006_l