Stack Depth

From: Bob Pawley <rjpawley(at)shaw(dot)ca>
To: Postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Stack Depth
Date: 2006-02-01 23:44:28
Message-ID: 012801c62789$70e73040$ac1d4318@owner
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bricklen Anderson 2006-02-01 23:48:38 Re: Stack Depth
Previous Message Tom Lane 2006-02-01 23:14:56 Re: NEW variable values in actions in rules