On Fri, Apr 27, 2012 at 10:23 AM, Tom Lane wrote:
> Ah-ha. How about the member and grantor OIDs in those rows --- do
> they correspond to still-existing roles? (I believe "10" would be
> the bootstrap superuser, so that should certainly still exist, but
> those other numbers are for user-made
=?UTF-8?Q?Filip_Rembia=C5=82kowski?= writes:
> On Wed, Apr 25, 2012 at 8:56 PM, Tom Lane wrote:
>> Hmm. A look at the code in pg_dumpall suggests that the problem is
>> unmatched entries in pg_auth_members, ie this query:
>>
>> SELECT ur.rolname AS roleid
>> FROM pg_auth_members a LEFT JOIN pg_
On Wed, Apr 25, 2012 at 8:56 PM, Tom Lane wrote:
> =?UTF-8?Q?Filip_Rembia=C5=82kowski?= writes:
>> 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;
>> GR
=?UTF-8?Q?Filip_Rembia=C5=82kowski?= writes:
> 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;
> GR
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 post
