Re: TRUNCATE on foreign table - Mailing list pgsql-hackers

From Kazutaka Onishi
Subject Re: TRUNCATE on foreign table
Date
Msg-id CAJuF6cMuOijugFHYEEsmfQZJQOUjuBdGZkf6ADw3WXJ4anfT1w@mail.gmail.com
Whole thread Raw
In response to Re: TRUNCATE on foreign table  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Responses Re: TRUNCATE on foreign table
List pgsql-hackers
All,

Thank you for discussion.
I've updated the patch (v6->v7) according to the conclusion.

I'll show the modified points:
1. Comments for ExecuteTuncate()
2. Replacing extra value in frels_extra with integer to label.
3. Skipping XLOG_HEAP_TRUNCATE on foreign table

Regards,

2021年4月2日(金) 11:44 Fujii Masao <masao.fujii@oss.nttdata.com>:
>
>
>
> On 2021/04/02 9:37, Kohei KaiGai wrote:
> > It is fair enough for me to reverse the order of actual truncation.
> >
> > How about the updated comments below?
> >
> >      This is a multi-relation truncate.  We first open and grab exclusive
> >      lock on all relations involved, checking permissions (local database
> >      ACLs even if relations are foreign-tables) and otherwise verifying
> >      that the relation is OK for truncation. In CASCADE mode, ...(snip)...
> >      Finally all the relations are truncated and reindexed. If any foreign-
> >      tables are involved, its callback shall be invoked prior to the truncation
> >      of regular tables.
>
> LGTM.
>
>
> >> BTW, the latest patch doesn't seem to be applied cleanly to the master
> >> because of commit 27e1f14563. Could you rebase it?
> >>
> > Onishi-san, go ahead. :-)
>
> +1
>
> Regards,
>
> --
> Fujii Masao
> Advanced Computing Technology Center
> Research and Development Headquarters
> NTT DATA CORPORATION

Attachment

pgsql-hackers by date:

Previous
From: Bryn Llewellyn
Date:
Subject: Re: Have I found an interval arithmetic bug?
Next
From: Bruce Momjian
Date:
Subject: Re: Have I found an interval arithmetic bug?