[COMMITTERS] pgsql: postgres_fdw: Push down FULL JOINs with restriction clauses. - Mailing list pgsql-committers

From Robert Haas
Subject [COMMITTERS] pgsql: postgres_fdw: Push down FULL JOINs with restriction clauses.
Date
Msg-id E1coZIp-0003uy-7d@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
postgres_fdw: Push down FULL JOINs with restriction clauses.

The previous deparsing logic wasn't smart enough to produce subqueries
when deparsing; make it smart enough to do that.  However, we only do
it that way when necessary, because it generates more complicated SQL
which will be harder for any humans reading the queries to understand.

Etsuro Fujita, reviewed by Ashutosh Bapat

Discussion: http://postgr.es/m/c449261a-b033-dc02-9254-2fe5b7044795@lab.ntt.co.jp

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/b30fb56b07a885f3476fe05920249f4832ca8da5

Modified Files
--------------
contrib/postgres_fdw/deparse.c                 | 272 +++++++++++++++++++++++--
contrib/postgres_fdw/expected/postgres_fdw.out | 160 +++++++++++++--
contrib/postgres_fdw/postgres_fdw.c            |  67 +++++-
contrib/postgres_fdw/postgres_fdw.h            |  16 +-
contrib/postgres_fdw/sql/postgres_fdw.sql      |  23 +++
5 files changed, 498 insertions(+), 40 deletions(-)


pgsql-committers by date:

Previous
From: Alvaro Herrera
Date:
Subject: [COMMITTERS] pgsql: Fix ancient get_object_address_opf_member bug
Next
From: Robert Haas
Date:
Subject: [COMMITTERS] pgsql: Add pg_ls_logdir() and pg_ls_waldir() functions.