Re: Stack Depth

From: Paul Tillotson <spam1011(at)adelphia(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Stack Depth
Date: 2006-02-02 00:27:07
Message-ID: 43E151DB.1010305@adelphia.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-02-02 00:52:26 Re: Stack Depth
Previous Message Steve Oualline 2006-02-02 00:09:08 postmaster startup time