* Bruce Momjian (pgman(at)candle(dot)pha(dot)pa(dot)us) wrote:
> The problem is this used in pg_dumpall --clean:
>
> DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template0');
Oh, wow. Hrmm. That certainly won't work now. It seems to me that the
correct thing to do here would be to loop through the roles and delete
them one-by-one, with cascade? I think that would clean things out
correctly. Alternatively I suppose you could delete from pg_authid and
pg_auth_members.. That seems a little ugly to me.
Thanks,
Stephen