Re: pg_dumpall 8.1.4 large objects error

I wrote:
>> This is computing obj_description() redundantly for each pg_largeobject
>> chunk. Perhaps there is a memory leak in obj_description() in 7.3.2?

Actually, obj_description() is a SQL-language function, and we had
horrendous problems with end-of-function-call memory leakage in SQL
functions in every version before 7.4. So this is undoubtedly the
source of Jeff's problem.

Jeff Frost <jeff(at)frostconsultingllc(dot)com> writes:
> I'll alter pg_dump and recompile, then give a test. Does pg_dumpall just call
> pg_dump or do I need to change it there too?

pg_dumpall calls pg_dump, so only one place to fix. I've already
committed the fix in CVS, if you'd prefer to use a tested patch.
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.c.diff?r1=1.422.2.3;r2=1.422.2.4

regards, tom lane