Fabiano: I reaaly don't understand what you mean by 'calling it recursively
but one time on each record' !

Do you want to email privately in portuguese to talk about this?

Artur

----- Original Message -----
From: "fabiano_bonin" <fabiano@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, April 05, 2002 12:08 PM
Subject: [ib-support] Re: Server shut-down


> 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.
> > >
> > >
>
>
> 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.
>
>