Re: TRUNCATE VIEW

Поиск
Список
Период
Сортировка
От harisai hari
Тема Re: TRUNCATE VIEW
Дата
Msg-id CAEUO9HCA5V=M-DFyCV+kfAVP=t=ZDNy_gh3m-f9Hh6Xr+8r2Vw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: TRUNCATE VIEW  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-docs
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

В списке pgsql-docs по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: TRUNCATE VIEW
Следующее
От: PG Doc comments form
Дата:
Сообщение: Postgres upgrade does not mention requirement to have only 1 user