I call it recursivelly (not on the same record, but one time on each
record)
It's a desired behavior in this case.
But when there are many recursions, it crashes the server

--- In ib-support@y..., "Artur Anjos" <arsoft@n...> wrote:
>
> 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@l...>
> To: <ib-support@y...>
> 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@e...
> >
> >
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
> >
> >