Re: Stack Depth

From: Bricklen Anderson <banderson(at)presinet(dot)com>
To: Bob Pawley <rjpawley(at)shaw(dot)ca>
Cc: Postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Stack Depth
Date: 2006-02-01 23:48:38
Message-ID: 43E148D6.2050908@presinet.com
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".
>
> Is this normal for, what I consider, a small amount of information transfer?
>
> If so, how do I change the stack depth limit? I can't find anything in
> the documentation that describes this task.
>
> I understand the default stack depth is about 2 meg. How do I determine
> what the stack depth should be so that I avoid this error?
>
> Bob Pawley

check max_stack_depth in your postgresql.conf file

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Oualline 2006-02-02 00:09:08 postmaster startup time
Previous Message Bob Pawley 2006-02-01 23:44:28 Stack Depth