Home > mailing lists

Stack Depth - Mailing list pgsql-general

From	Bob Pawley
Subject	Stack Depth
Date	February 1, 2006 22:45:53
Msg-id	012801c62789$70e73040$ac1d4318@owner Whole thread Raw
Responses	Re: Stack Depth (Bricklen Anderson <banderson@presinet.com>) Re: Stack Depth (Paul Tillotson <spam1011@adelphia.net>)
List	pgsql-general

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

From: Tom Lane
Date: 01 February 2006, 22:14:58
Subject: Re: NEW variable values in actions in rules

From: Bricklen Anderson
Date: 01 February 2006, 22:48:29
Subject: Re: Stack Depth