Rules/Triggers executio order

Поиск
Список
Период
Сортировка
От Benjamin Krajmalnik
Тема Rules/Triggers executio order
Дата
Msg-id F4E6A2751A2823418A21D4A160B68988315B@fletch.stackdump.local
обсуждение исходный текст
Ответы Re: Rules/Triggers executio order  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-admin
I have a partitioned table to which I route data using a trigger.
I am changing it to use a set of rules which executes "INSTEAD" on insert.
The parent table currently has a trigger.
 
The system is a live system.  I would prefer to not have to suspend the data flow.
If I create the rules, and given the fact that they execute "INSTEAD" of the insertion into the parent table, will the trigger still execute.
I will be removing the trigger immediately after the creation of the rules, but just want to be safe and make sure I get no duplicate entries.
 
Thanks in advance.

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

Предыдущее
От: "Duncan McDonald"
Дата:
Сообщение: Re: Missing Earth Distance Functions Under Debian
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Rules/Triggers executio order