On Tue, Feb 9, 2021 at 5:49 PM Bharath Rupireddy <bharath.rupireddyforpostg...@gmail.com> wrote: > > On Tue, Feb 9, 2021 at 5:31 PM Ashutosh Bapat > <ashutosh.bapat....@gmail.com> wrote: > > Why would one want to truncate a foreign table instead of truncating > > actual table wherever it is? > > I think when the deletion on foreign tables (which actually deletes > rows from the remote table?) is allowed, it does make sense to have a > way to truncate the remote table via foreign table. Also, it can avoid > going to each and every remote server and doing the truncation > instead.
DELETE is very different from TRUNCATE. Application may want to DELETE based on a join with a local table and hence it can not be executed on a foreign server. That's not true with TRUNCATE. -- Best Wishes, Ashutosh Bapat
