Re: Rules, triggers and such - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Rules, triggers and such
Date
Msg-id 200912091708.50785.guillaume@lelarge.info
Whole thread Raw
In response to Rules, triggers and such  (George Silva <georger.silva@gmail.com>)
List pgsql-general
Le mercredi 9 décembre 2009 à 17:04:32, George Silva a écrit :
> Hello all again :)
>
> I have a question: is it possible to replicate the behavior of a rule
> INSTEAD of with a TRIGGER?
>
> For some specific reasons i need to use a trigger to update a
> secondary table, but i don't want the changes to happen in the primary
> table too.
>
> Is it possible to do it? If so, how?
>

Try a BEFORE trigger, and RETURN NULL in your stored function.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

pgsql-general by date:

Previous
From: George Silva
Date:
Subject: Rules, triggers and such
Next
From: Sergey Levchenko
Date:
Subject: Problem with SET CONSTRAINTS some_constraint_fkey DEFERRED