Rules/Triggers executio order - Mailing list pgsql-admin

From Benjamin Krajmalnik
Subject Rules/Triggers executio order
Date
Msg-id F4E6A2751A2823418A21D4A160B68988315B@fletch.stackdump.local
Whole thread Raw
Responses Re: Rules/Triggers executio order
List 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 by date:

Previous
From: "Duncan McDonald"
Date:
Subject: Re: Missing Earth Distance Functions Under Debian
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Rules/Triggers executio order