Thom Brown <thom@linux.com> writes:
> On 22 May 2012 16:57, Florian Pflug <fgp@phlo.org> wrote:
>> Maybe we could simply make all global role's OIDs even, and all local ones
>> odd, or something like that.
> Wouldn't that instantly make all previous versions of database
> clusters un-upgradable?
IIRC, pg_upgrade doesn't need to force role OIDs to be the same in the
new cluster, so we could get away with this trick for the specific case
of roles. It wouldn't work for introducing local/global versions of
some other types of objects though.
Another objection is that it wouldn't scale up nicely to multiple levels
of catalog hierarchy. But maybe local/global is enough.
regards, tom lane