Re: pg_dump 9.1.1 hanging (collectSecLabels gets 0 labels)

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Steve Singer <ssinger@ca.afilias.info>
Cc: PostgreSQL-development Hackers <pgsql-hackers@postgresql.org>
Date: 2011-11-09T23:35:00Z
Lists: pgsql-hackers
Steve Singer <ssinger@ca.afilias.info> writes:
> I've tracked the issue down to collectSecLabels in pg_dump.c

> SELECT label, provider, classoid, objoid, objsbid FROM 
> pg_catalog.pg_seclabel;

> returns 0 rows.

> The code in collectSecLabels() is not prepared to deal with a zero row 
> result and tries to malloc 0 bytes.

pg_seclabel is almost always empty, so I'm not convinced that you've
identified your problem correctly.

			regards, tom lane