Re: Problem with pg_upgrade (8.4 -> 9.0) due to ALTER DATABASE SET ROLE

Robert Treat <rob@xzilla.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