Re: Determining if a table really changed in a trigger

Поиск
Список
Период
Сортировка
От Mitar
Тема Re: Determining if a table really changed in a trigger
Дата
Msg-id CAKLmikOm34j2ZyDEbz63ZZ81NXqoma_tbsBqGHO9XReR7-R0+A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Determining if a table really changed in a trigger  (Marcos Pegoraro <marcos@f10.com.br>)
Список pgsql-general
Hi!

On Wed, Oct 27, 2021 at 12:56 PM Marcos Pegoraro <marcos@f10.com.br> wrote:
>> Oh, very interesting. I thought that this is not possible because WHEN
>> condition on triggers does not have NEW and OLD. But this is a very
>> cool way to combine rules with triggers, where a rule can still
>> operate by row.
>
> That is not true

Sorry to be imprecise. In this thread I am interested in statement
triggers, so I didn't mention this explicitly here. So statement
triggers do not have NEW and OLD. But you can combine it with a
row-level rule and this works then well together.


Mitar

-- 
http://mitar.tnode.com/
https://twitter.com/mitar_m



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump and pg_restore and foreign keys
Следующее
От: Tore Halvorsen
Дата:
Сообщение: Re: pg_dump and pg_restore and foreign keys