Re: BUG #5319: recursion in the triggers - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5319: recursion in the triggers
Date
Msg-id 603c8f071002072052q7a0cc2c7m3e834e49f533ea12@mail.gmail.com
Whole thread Raw
In response to BUG #5319: recursion in the triggers  ("Michail Antonov" <atin65536@gmail.com>)
List pgsql-bugs
On Sun, Feb 7, 2010 at 8:03 PM, Michail Antonov <atin65536@gmail.com> wrote:
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05319
> Logged by: =A0 =A0 =A0 =A0 =A0Michail Antonov
> Email address: =A0 =A0 =A0atin65536@gmail.com
> PostgreSQL version: 8.4.2
> Operating system: =A0 Windows XP
> Description: =A0 =A0 =A0 =A0recursion in the triggers
> Details:
>
> I have 'after insert' trigger, which call function, which insert row in t=
he
> same table. I expect, that trigger will be called again, but it does not
> heppened.
>
> Reply me, is it a bug or feature?

I don't believe there's anything in the server that would prevent
infinite recursion in a case like this, so my guess is that your code
isn't working the way you think it's working.  Since you haven't
provided a test case it's hard to speculate as to what the problem
might be.

...Robert

pgsql-bugs by date:

Previous
From: "Michail Antonov"
Date:
Subject: BUG #5319: recursion in the triggers
Next
From: Russell Smith
Date:
Subject: Re: BUG #5319: recursion in the triggers