Re: before/after triggers

On Wednesday 26 Mar 2003 10:30 pm, Dennis Gearon wrote:
> If I have a before trigger on table 'A' modify  table 'B' and an after
> trigger on table 'A' fails for that transaction:

All triggers take place within a single transaction.

> 1/ Is the change to table 'B' visible to anybody except that tranaction at
> any time?

Shouldn't be. It will never be committed.

> 2/ Does the change to table 'B' disappear/never show up when the after
> trigger fails?

Yes.

> 3/ Would all after triggers in that transaction see the change to table 'B'
> before the one particular after trigger fails?

Should do - they're in the same transaction. See chapter 9.2 of the user guide
"Transaction Isolation" for details

> 4/ do all the major DB's have this functionality? I.E.
>
>     Oracle
>     Sybase
>     MSSQL (yuck)
>     DB2
>     <other examples welcome>

Sorry, can't comment. All should offer similar functionality, but whether the
behaviour is identical I wouldn't want to say without testing.
--
  Richard Huxton