Allow insert and update tuple routing and COPY for foreign tables.
Robert Haas <rhaas@postgresql.org>
Allow insert and update tuple routing and COPY for foreign tables. Also enable this for postgres_fdw. Etsuro Fujita, based on an earlier patch by Amit Langote. The larger patch series of which this is a part has been reviewed by Amit Langote, David Fetter, Maksim Milyutin, Álvaro Herrera, Stephen Frost, and me. Minor documentation changes to the final version by me. Discussion: http://postgr.es/m/29906a26-da12-8c86-4fb9-d8f88442f2b9@lab.ntt.co.jp
Files
| Path | Change | +/− |
|---|---|---|
| contrib/file_fdw/input/file_fdw.source | modified | +5 −0 |
| contrib/file_fdw/output/file_fdw.source | modified | +6 −3 |
| contrib/postgres_fdw/expected/postgres_fdw.out | modified | +334 −0 |
| contrib/postgres_fdw/postgres_fdw.c | modified | +96 −0 |
| contrib/postgres_fdw/sql/postgres_fdw.sql | modified | +237 −0 |
| doc/src/sgml/ddl.sgml | modified | +3 −5 |
| doc/src/sgml/fdwhandler.sgml | modified | +66 −0 |
| doc/src/sgml/ref/copy.sgml | modified | +3 −2 |
| doc/src/sgml/ref/update.sgml | modified | +3 −0 |
| src/backend/commands/copy.c | modified | +70 −26 |
| src/backend/executor/execMain.c | modified | +1 −7 |
| src/backend/executor/execPartition.c | modified | +62 −41 |
| src/backend/executor/nodeModifyTable.c | modified | +17 −6 |
| src/include/executor/execPartition.h | modified | +7 −1 |
| src/include/foreign/fdwapi.h | modified | +8 −0 |
| src/include/nodes/execnodes.h | modified | +6 −0 |
Documentation touched
Discussion
- Add support for tuple routing to foreign partitions 69 messages · 2017-06-29 → 2018-04-09