| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | harisai hari <harisai(dot)58(at)gmail(dot)com> |
| Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: TRUNCATE VIEW |
| Date: | 2021-01-25 15:22:58 |
| Message-ID: | 56514982026dea49ebb6ee33fab28e13daa9b6f5.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On Mon, 2021-01-25 at 18:45 +0530, harisai hari wrote:
>
> On Mon, 25 Jan 2021, 6:08 pm Laurenz Albe, <laurenz(dot)albe(at)cybertec(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | harisai hari | 2021-01-25 15:23:39 | Re: TRUNCATE VIEW |
| Previous Message | harisai hari | 2021-01-25 13:15:23 | Re: TRUNCATE VIEW |