Message-ID: <56514982026dea49ebb6ee33fab28e13daa9b6f5.camel@cybertec.at>
Subject: Re: TRUNCATE VIEW
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: harisai hari <harisai.58@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Date: Mon, 25 Jan 2021 16:22:58 +0100
In-Reply-To: 
 <CAEUO9HBg=G0--ySsG1R1cjJZkq-WALCHEDBhuac_r_=DyqRxJA@mail.gmail.com>
References: 
	<161157636877.14625.15340884663716426087@wrigleys.postgresql.org>
	 <4d8ee45bb0d07a09da5d64d6cba114e7db5777b3.camel@cybertec.at>
	 <CAEUO9HBg=G0--ySsG1R1cjJZkq-WALCHEDBhuac_r_=DyqRxJA@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) 
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: bulk

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