Re: After Trigger assignment to NEW

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: After Trigger assignment to NEW
Дата
Msg-id
3649.1140797162@sss.pgh.pa.us
Ответ на
After Trigger assignment to NEW (Achilleus Mantzios)
Список
Дерево обсуждения
After Trigger assignment to NEW Achilleus Mantzios <achill@matrix.gatewaynet.com>
Re: After Trigger assignment to NEW Tom Lane <tgl@sss.pgh.pa.us>
Re: After Trigger assignment to NEW Alvaro Herrera <alvherre@commandprompt.com>
Re: After Trigger assignment to NEW Tom Lane <tgl@sss.pgh.pa.us>
Re: After Trigger assignment to NEW Achilleus Mantzios <achill@matrix.gatewaynet.com>
Re: After Trigger assignment to NEW Achilleus Mantzios <achill@matrix.gatewaynet.com>
Achilleus Mantzios  writes:
> Is there a reason that the NEW values should remain unchanged in AFTER 
> row triggers?

By definition, an AFTER trigger is too late to change what was stored.
Use a BEFORE trigger.
		regards, tom lane

В списке pgsql-sql по дате отправления
От: Achilleus Mantzios
Дата:
От: Alvaro Herrera
Дата:
FAQ