Hi Ivan,

Thanks for your answer, that's what I have a "Update conflict", reported as
a deadlock. What action should I take to avoid it, because I cannot say to
user Y to close that reord in the screen.

thanks, Nico

-----Oorspronkelijk bericht-----
Van: Ivan Prenosil [mailto:prenosil@...]
Verzonden: maandag 18 juni 2001 15:36
Aan: ib-support@yahoogroups.com
Onderwerp: Re: [ib-support] Trigger question

> I'm wondering if a trigger can cause a deadlock ?

There is nothing special about triggers - if the statment can cause
deadlock,
than the same statement in trigger will cause deadlock too.

> I guess triggers are
> out of transaction control ?

No, triggers run in the context of the same transaction
as the statment that caused trigger to fire.

> Example : User X is inserting a record in
> table A, a after insert trigger is updating a record in table B, and user

Y

> is busy changing that same record from table B --> could that situation
> cause a deadlock ?

It will not cause deadlock but rather update conflict.
(that is however sometimes reported as deadlock).

Ivan
prenosil@...
http://www.volny.cz/iprenosil/interbase


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/