Re: Memory Errors...

"Ian Harding" <ianh@tpchd.org> writes:
> It calls another function that now uses a temporary table.  It
> creates, uses and drops the table.  It is usually called only once per
> transaction, but it is called repeatedly from the main function in
> this case.  When I run the function, the memory numbers reported by
> top climb quickly until it blows up.  I wonder if this has anything to
> do with it.

This sounds like a memory leak inside plpgsql.  We've plugged some of
those over the last few releases, but I bet there are more.

If you are not on 7.2.*, please update.  If you are, could we see the
function definitions?

            regards, tom lane