Thread: TRUNCATE VIEW
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/ddl-priv.html Description: Dear Team, 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.
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. Yours, Laurenz Albe
Could you please provide documentation link, I couldn't find it.
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.
Yours,
Laurenz Albe
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
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