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:
Show quoted text
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:
Show quoted text
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
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
On Tue, Jan 26, 2021 at 09:54:48AM +0900, Michael Paquier wrote:
Yes, this page is wrong to tell that.
This one has been fixed with 32bef75 down to 12.
There is a second thing that I find confusing in the docs of
TRUNCATE:
https://www.postgresql.org/docs/devel/sql-truncate.htmlThis 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.
Not sure what to do about this part yet.
--
Michael