Dne 23.12.2010 12:16, Svein Erling Tysvær napsal(a):

> If this transaction is launched from a program, then you could have a table DONT_FIRE(DUMMY integer)
> and do this within the one transaction you want not to fire the trigger:
>
> INSERT INTO DONT_FIRE(DUMMY) VALUES (1);
> <do whatever you want, except commit>
> DELETE FROM DONT_FIRE;
> COMMIT;
>
> The value in DONT_FIRE will only be visible to the actual transaction since it isn't committed until after it is deleted and your trigger would check this table to see whether it should continue or not.

Good idea! This is even a better trick than comparing the transaction
ID! Thanks!

Pepak