Horton

Directly modify foreign tables.

Robert Haas <rhaas@postgresql.org>

View on postgr.es
Commit: 0bf3ae88af330496517722e391e7c975e6bad219
Author: Robert Haas <rhaas@postgresql.org>
Date: 2016-03-18T17:55:52Z
Releases: 9.6.0 
Directly modify foreign tables.

postgres_fdw can now sent an UPDATE or DELETE statement directly to
the foreign server in simple cases, rather than sending a SELECT FOR
UPDATE statement and then updating or deleting rows one-by-one.

Etsuro Fujita, reviewed by Rushabh Lathia, Shigeru Hanada, Kyotaro
Horiguchi, Albe Laurenz, Thom Brown, and me.

Files

PathChange+/−
contrib/postgres_fdw/deparse.c modified +100 −0
contrib/postgres_fdw/expected/postgres_fdw.out modified +285 −29
contrib/postgres_fdw/postgres_fdw.c modified +612 −71
contrib/postgres_fdw/postgres_fdw.h modified +14 −0
contrib/postgres_fdw/sql/postgres_fdw.sql modified +100 −5
doc/src/sgml/fdwhandler.sgml modified +178 −2
doc/src/sgml/postgres-fdw.sgml modified +9 −0
src/backend/commands/explain.c modified +50 −5
src/backend/executor/execMain.c modified +1 −0
src/backend/executor/nodeForeignscan.c modified +14 −3
src/backend/executor/nodeModifyTable.c modified +50 −10
src/backend/nodes/copyfuncs.c modified +2 −0
src/backend/nodes/outfuncs.c modified +2 −0
src/backend/nodes/readfuncs.c modified +1 −0
src/backend/optimizer/plan/createplan.c modified +21 −0
src/backend/optimizer/util/plancat.c modified +47 −0
src/include/foreign/fdwapi.h modified +20 −0
src/include/nodes/execnodes.h modified +2 −0
src/include/nodes/pg_list.h modified +3 −0
src/include/nodes/plannodes.h modified +2 −0
src/include/optimizer/plancat.h modified +2 −0

Documentation touched