=?utf-8?Q?=C3=81lvaro?= Herrera <alvherre@alvh.no-ip.org> writes:
> Hmm, I think fixing the bug as Tom suggests downthread is probably a
> good idea, but I think we should in addition change pg_dumpall to avoid
> printing a GRANT line if there's no grantee.
On the one hand, my proposed patch can do nothing to fix existing
dangling entries in pg_auth_members, so hacking pg_dump seems like
a good workaround if the problem already exists. On the other hand,
if we make pg_dump do that then we won't detect future problems of
the same ilk.
> Maybe turning one of these LEFT
> JOINs into a regular inner join is a sufficient fix for that:
Probably change all three, if we're to do this at all.
regards, tom lane