Re: help with triggers and mutating tables

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 15 May 2007 19:52:30 +0200
Message-ID: <f2d100$2bf$1@news4.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

heidi schreef:
> The problem is not in any individual update in the trigger. I can
> update the relevant columns by themselves and the trigger fires fine.
> The problem is when I try updating both columns in one statement.
> Only the first update in the trigger will fire.
>

Do you expect a *row* trigger to fire two times because you changed the values of two columns of the same *row*?

Think again. It'll fire once - as designed.

It's up to you to check which columns are changed, using the :old and :new column values, or create a trigger for each and every column - which is not a good idea, as indicated and explained by Sybrand and Daniel.

-- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGSfNeLw8L4IAs830RAqHqAKCJipmOUvPu7dciGEde9PDgH194vQCeN2Iw 64ri/OnpYJnamhUpwMM1QCQ=
=PLFX
-----END PGP SIGNATURE----- Received on Tue May 15 2007 - 12:52:30 CDT