TRUNCATE on foreign table

From: Kazutaka Onishi <onishi(at)heterodb(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc: Kohei KaiGai <kaigai(at)heterodb(dot)com>
Subject: TRUNCATE on foreign table
Date: 2021-02-06 13:11:14
Message-ID: CAJuF6cMWDDqU-vn_knZgma+2GMaout68YUgn1uyDnexRhqqM5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)heterodb(dot)com)

Attachment Content-Type Size
pgsql14-truncate-on-foreign-table.v1.patch application/x-patch 37.9 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2021-02-06 13:28:48 Re: Fuzz testing COPY FROM parsing
Previous Message Amit Kapila 2021-02-06 12:17:01 Re: pg_replication_origin_drop API potential race condition