empty role names in pg_dumpall output

From: Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: empty role names in pg_dumpall output
Date: 2012-04-25 22:56:54
Message-ID: CAP_rwwk1TtgQrETVkgYxKiKDry+Ld4S=rM69dOdpDiZVAAQ6wg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

PostgreSQL 9.0.4

I have this in pg_dumpall -g output (non-empty role names changed):

GRANT "" TO a GRANTED BY postgres;
GRANT "" TO b GRANTED BY c;
GRANT "" TO b GRANTED BY c;
GRANT "" TO b GRANTED BY c;
GRANT "" TO b GRANTED BY c;
GRANT "" TO "" GRANTED BY c;
GRANT "" TO "" GRANTED BY postgres;
GRANT "" TO "" GRANTED BY postgres;

There is no CREATE ROLE "" ... in the output.

select * from pg_authid where length(rolname)<1 -- returns no rows

I would like to get rid of these roles, but how?

I appreciate any hints / ideas.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Janne H 2012-04-25 23:17:53 How can I see if my code is "concurrency safe"?
Previous Message Rich Shepard 2012-04-25 22:40:38 Re: Formatting time for INSERT INTO