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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
