Quick Links

Rules, triggers and such

From:	George Silva <georger(dot)silva(at)gmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Rules, triggers and such
Date:	2009-12-09 16:04:32
Message-ID:	9aa147370912090804o42608e3dn903f9130f0172177@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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?

I thought of using a instead of rule with a procedure, but a trigger
is just so much easier :P

Thanks

--
George R. C. Silva

	From	Date	Subject
Next Message	Guillaume Lelarge	2009-12-09 16:08:50	Re: Rules, triggers and such
Previous Message	Guillaume Lelarge	2009-12-09 15:57:50	Unix ODBC on SPARC 64 bits