Re: TRUNCATE VIEW

Thank you!

On Mon, 25 Jan 2021, 8:53 pm Laurenz Albe, <laurenz.albe@cybertec.at> wrote:

> On Mon, 2021-01-25 at 18:45 +0530, harisai hari wrote:
> >
> > On Mon, 25 Jan 2021, 6:08 pm Laurenz Albe, <laurenz.albe@cybertec.at>
> wrote:
> > > On Mon, 2021-01-25 at 12:06 +0000, PG Doc comments form wrote:
> > > > In this link https://www.postgresql.org/docs/12/ddl-priv.html you
> mentioned
> > > > like Truncate of view, Is it possible?
> > > >
> > > > TRUNCATE
> > > > Allows TRUNCATE on a table, view, etc.
> > >
> > > Yes, if you define an INSTEAD OF TRUNCATE trigger on the view.
> >
> > Could you please provide documentation link, I couldn't find it.
>
> Checking again, I realize that I wrote nonsense, and you are right.
>
> I concur that this should be simplified to
>
>   Allows TRUNCATE on a table.
>
> Yours,
> Laurenz Albe
>
>