Re: Memory Errors...

"Ian Harding" <ianh(at)tpchd(dot)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