On Fri, 2003-02-21 at 18:26, Doug McNaught wrote:
> Dennis Gearon <gearond@cvc.net> writes:
> > 2/ If I am updating/deleting/inserting into two tables, and both tables have triggers on them to
> > check the relationship of the data between the tables, any way of knowing which trigger will fire
> > first at the end of the transaction?
>
> I'm not sure about this one--do the docs say anything?
In 7.3, I believe triggers fire in alphabetical order. There was no
predictable order in earlier versions.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"All scripture is given by inspiration of God, and is
profitable for doctrine, for reproof, for correction,
for instruction in righteousness; That the man of God
may be perfect, thoroughly furnished unto all good
works." II Timothy 3:16,17