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

From Tom Lane
Subject Re: Problem with pg_upgrade (8.4 -> 9.0) due to ALTER DATABASE SET ROLE
Date
Msg-id 14763.1298870466@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem with pg_upgrade (8.4 -> 9.0) due to ALTER DATABASE SET ROLE  (Robert Treat <rob@xzilla.net>)
Responses Re: Problem with pg_upgrade (8.4 -> 9.0) due to ALTER DATABASE SET ROLE  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: Problem with pg_upgrade (8.4 -> 9.0) due to ALTER DATABASE SET ROLE
Next
From: Tom Lane
Date:
Subject: Re: wCTE: about the name of the feature