That's funny... Your trigger should never be recursive, ie, IB does not
allow it. Or this was something that changed in Firebird (there's nothing
related in the release notes....)

Artur

----- Original Message -----
From: "fabiano_bonin" <fabiano@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, April 03, 2002 10:58 PM
Subject: [ib-support] Server shut-down


> I have a trigger in a table that is called recursively and some times
> it can be called 600 - 700 times in a single operation (when i update
> a row, for example).
>
> Inside this trigger there are some calls to stored procedures, many
> operations whith double precisions fields and variables, some queryes
> on other tables, etc...
>
> My problem is that when there are so many recursions, something above
> 300-400 recusrions, the server crashes.
>
> Does somebody knows if there is some known problem about trigger
> recursions that can be affecting me?
>
> Thanks.
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>