Allow TRUNCATE command to truncate foreign tables

Enterprise / PostgreSQL - Fujii Masao [postgresql.org] - 8 April 2021 11:56 UTC

This commit introduces new foreign data wrapper API for TRUNCATE. It extends TRUNCATE command so that it accepts foreign tables as the targets to truncate and invokes that API. Also it extends postgres_fdw so that it can issue TRUNCATE command to foreign servers, by adding new routine for that TRUNCATE API.

The information about options specified in TRUNCATE command, e.g., ONLY, CACADE, etc is passed to FDW via API. The list of foreign tables to truncate is also passed to FDW. FDW truncates the foreign data sources that the passed foreign tables specify, based on those information. For example, postgres_fdw constructs TRUNCATE command using them and issues it to the foreign server.

For performance, TRUNCATE command invokes the FDW routine for TRUNCATE once per foreign server that foreign tables to truncate belong to.

Author: Kazutaka Onishi, Kohei KaiGai, slightly modified by Fujii Masao

8ff1c94649 Allow TRUNCATE command to truncate foreign tables.
contrib/postgres_fdw/connection.c | 3 +-
contrib/postgres_fdw/deparse.c | 38 +++++
contrib/postgres_fdw/expected/postgres_fdw.out | 201 ++++++++++++++++++++++++-
contrib/postgres_fdw/option.c | 4 +
contrib/postgres_fdw/postgres_fdw.c | 103 +++++++++++++
contrib/postgres_fdw/postgres_fdw.h | 6 +
contrib/postgres_fdw/sql/postgres_fdw.sql | 101 +++++++++++++
doc/src/sgml/fdwhandler.sgml | 61 ++++++++
doc/src/sgml/postgres-fdw.sgml | 32 +++-
doc/src/sgml/ref/truncate.sgml | 6 +-
src/backend/commands/tablecmds.c | 151 +++++++++++++++++--
src/backend/replication/logical/worker.c | 11 +-
src/include/commands/tablecmds.h | 18 ++-
src/include/foreign/fdwapi.h | 8 +
src/include/utils/rel.h | 4 +-
src/test/regress/expected/foreign_data.out | 8 +-
src/tools/pgindent/typedefs.list | 1 +
17 files changed, 725 insertions(+), 31 deletions(-)

Upstream: git.postgresql.org


  • Share