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.
Re: TRUNCATE VIEW
On Mon, 2021-01-25 at 12:06 +, 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
Re: TRUNCATE VIEW
Could you please provide documentation link, I couldn't find it. On Mon, 25 Jan 2021, 6:08 pm Laurenz Albe, wrote: > On Mon, 2021-01-25 at 12:06 +, 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 > >
Re: TRUNCATE VIEW
On Mon, 2021-01-25 at 18:45 +0530, harisai hari wrote: > > On Mon, 25 Jan 2021, 6:08 pm Laurenz Albe, wrote: > > On Mon, 2021-01-25 at 12:06 +, 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
Re: TRUNCATE VIEW
Thank you! On Mon, 25 Jan 2021, 8:53 pm Laurenz Albe, wrote: > On Mon, 2021-01-25 at 18:45 +0530, harisai hari wrote: > > > > On Mon, 25 Jan 2021, 6:08 pm Laurenz Albe, > wrote: > > > On Mon, 2021-01-25 at 12:06 +, 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 > >
Re: TRUNCATE VIEW
On Mon, Jan 25, 2021 at 08:53:39PM +0530, harisai hari wrote: > Thank you! Yes, this page is wrong to tell that. There is a second thing that I find confusing in the docs of TRUNCATE: https://www.postgresql.org/docs/devel/sql-truncate.html This does not mention at all partitioned tables, describing only "descendant tables". Partitioning is a case of "descendant tables" but that's a bit confusing IMO and a reader would need to guess that. Thoughts? -- Michael signature.asc Description: PGP signature
