Re: WIP: Triggers on VIEWs

Поиск
Список
Период
Сортировка
Искать
От
Bernd Helmle
Тема
Re: WIP: Triggers on VIEWs
Дата
Msg-id
3D83DE881171345EC3EC804F@amenophis
Ответ на
Список
Дерево обсуждения
WIP: Triggers on VIEWs Dean Rasheed <dean.a.rasheed@gmail.com>
Re: WIP: Triggers on VIEWs Dean Rasheed <dean.a.rasheed@gmail.com>
Re: WIP: Triggers on VIEWs Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: Triggers on VIEWs Dean Rasheed <dean.a.rasheed@gmail.com>
Re: WIP: Triggers on VIEWs Dean Rasheed <dean.a.rasheed@gmail.com>
Re: WIP: Triggers on VIEWs Bernd Helmle <mailings@oopsware.de>
Re: WIP: Triggers on VIEWs Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>
Re: WIP: Triggers on VIEWs Dean Rasheed <dean.a.rasheed@gmail.com>
Re: WIP: Triggers on VIEWs Bernd Helmle <mailings@oopsware.de>
Re: WIP: Triggers on VIEWs David Christensen <david@endpoint.com>
Re: WIP: Triggers on VIEWs Dean Rasheed <dean.a.rasheed@gmail.com>
Re: WIP: Triggers on VIEWs Dean Rasheed <dean.a.rasheed@gmail.com>
Re: WIP: Triggers on VIEWs Bernd Helmle <mailings@oopsware.de>
Re: WIP: Triggers on VIEWs Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: Triggers on VIEWs Dean Rasheed <dean.a.rasheed@gmail.com>
Re: WIP: Triggers on VIEWs Dean Rasheed <dean.a.rasheed@gmail.com>


--On 23. September 2010 08:59:32 +0100 Dean Rasheed 
 wrote:

> Yes, I agree. To me this is the least surprising behaviour. I think a
> more common case would be where the trigger computed a value (such as
> the 'last updated' example). The executor doesn't have any kind of a
> handle on the row inserted by the trigger, so it has to rely on the
> function return value to support RETURNING.

I didn't mean to forbid it altogether, but at least to document 
explicitely, that the trigger returns a VIEW's NEW tuple, not the one of 
the base table (and may modify it). But you've already adressed this in 
your doc patches, so nothing to worry about further.

-- 
Thanks
Bernd

В списке pgsql-hackers по дате отправления
От: Marko Tiikkaja
Дата:
Сообщение: Re: ask for review of MERGE
От: subham@cse.iitb.ac.in
Дата:
Сообщение: Re: Needs Suggestion
FAQ