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-2fe5b7044...@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(-) -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers