Horton

TRUNCATE on foreign table

Kazutaka Onishi <onishi@heterodb.com>

View thread View on postgr.es
From: Kazutaka Onishi <onishi@heterodb.com>
To: pgsql-hackers@lists.postgresql.org
Cc: Kohei KaiGai <kaigai@heterodb.com>
Date: 2021-02-06T13:11:14Z
Lists: pgsql-hackers

Attachments

Hello,

The attached patch is for supporting "TRUNCATE" on  foreign tables.

This patch includes:
* Adding "ExecForeignTruncate" function into FdwRoutine.
* Enabling "postgres_fdw" to use TRUNCATE.

This patch was proposed by Kaigai-san in March 2020,
but it was returned because it can't be applied to the latest source codes.

Please refer to the discussion.
https://www.postgresql.org/message-id/flat/CAOP8fzb-t3WVNLjGMC%2B4sV4AZa9S%3DMAQ7Q6pQoADMCf_1jp4ew%40mail.gmail.com#3b6c6ff85ff5c722b36c7a09b2dd7165

I have fixed the patch due to submit it to Commit Fest 2021-03.

regards,

--
------------------
Kazutaka Onishi
(onishi@heterodb.com)

Commits

  1. doc: Review for "Allow TRUNCATE command to truncate foreign tables".

  2. Don't pass "ONLY" options specified in TRUNCATE to foreign data wrapper.

  3. Support tab-complete for TRUNCATE on foreign tables.

  4. Allow TRUNCATE command to truncate foreign tables.

  5. Add support for asynchronous execution.