Re: Stack Depth - Mailing list pgsql-general

From Paul Tillotson
Subject Re: Stack Depth
Date
Msg-id 43E151DB.1010305@adelphia.net
Whole thread Raw
In response to Stack Depth  (Bob Pawley <rjpawley@shaw.ca>)
List pgsql-general
Bob Pawley wrote:

> Hi Folks
>
> I have three triggers and associated functions that fire on one insert
> and moves row ID information to five different tables..
>
> I am getting an error message "stack depth limit exceeded".
>
> [snip]

You've almost certainly got a recursive trigger in there.  The default
stack depth should be good for hundreds of function calls, but if your
triggers are recursive then no depth will be enough.

Regards,

Paul Tillotson


pgsql-general by date:

Previous
From: "Steve Oualline"
Date:
Subject: postmaster startup time
Next
From: Michael Fuhr
Date:
Subject: Re: Stack Depth