Re: Stack Depth

Thanks Michael

I'll keep this for future use. I beleive I was using insert into and update
when I should have been using update only.

Bob


----- Original Message -----
From: "Michael Fuhr" <mike@fuhr.org>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Bricklen Anderson" <banderson@presinet.com>; "Postgresql"
<pgsql-general@postgresql.org>
Sent: Wednesday, February 01, 2006 5:22 PM
Subject: Re: [GENERAL] Stack Depth


> On Wed, Feb 01, 2006 at 05:04:22PM -0800, Bob Pawley wrote:
>> I do think I have a recursive problem. It's just hard to see at the
>> moment.
>
> RAISE is your friend.  If you can't figure out where the recursion
> is coming from then add debugging output to the trigger functions
> to see what gets called when.
>
> --
> Michael Fuhr