Robert Treat <rob(at)xzilla(dot)net> writes:
> Did anything ever come of this discussion?
I think it's a TODO --- nothing done about it as yet, AFAIR.
> On one of the databases I
> was upgrading, I ran into a similar problem with roles that are set as
> roles. The problem seems to stem from pg_dumpall dumping roles in
> alphabetical order:
> CREATE ROLE asha;
> ALTER ROLE asha SET role TO 'omniti';
> .. sometime later ...
> CREATE ROLE omniti;
That seems like a pretty bizarre thing to do. Why would you want such a
setting?
regards, tom lane