Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id BCA5C9FB31A for ; Wed, 18 Oct 2006 21:43:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 16208-02 for ; Wed, 18 Oct 2006 21:43:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.illumen.com (unknown [64.207.29.137]) by postgresql.org (Postfix) with ESMTP id 440B19FB2E6 for ; Wed, 18 Oct 2006 21:43:45 -0300 (ADT) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6F317.A18DF00B" Subject: Rules/Triggers executio order x-mimeole: Produced By Microsoft Exchange V6.5 Date: Wed, 18 Oct 2006 18:42:21 -0600 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Rules/Triggers executio order Thread-Index: AcbzF2/brUUgTNC4Q+mkcQEuYs9zjA== From: "Benjamin Krajmalnik" To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.069 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200610/116 X-Sequence-Number: 23419 This is a multi-part message in MIME format. ------_=_NextPart_001_01C6F317.A18DF00B Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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. =20 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. =20 Thanks in advance. ------_=_NextPart_001_01C6F317.A18DF00B Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
I have = a partitioned=20 table to which I route data using a trigger.
I am = changing it to=20 use a set of rules which executes "INSTEAD" on = insert.
The = parent table=20 currently has a trigger.
 
The = system is a live=20 system.  I would prefer to not have to suspend the data=20 flow.
If I = create the=20 rules, and given the fact that they execute "INSTEAD" of the insertion = into the=20 parent table, will the trigger still execute.
I will = be removing=20 the trigger immediately after the creation of the rules, but just want = to be=20 safe and make sure I get no duplicate entries.
 
Thanks = in=20 advance.
------_=_NextPart_001_01C6F317.A18DF00B--