From: | Stephen Frost <sfrost(at)snowman(dot)net> |
---|---|
To: | Jeff Amiel <jamiel(at)istreamimaging(dot)com> |
Cc: | Thom Brown <thombrown(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Restore roles with same oid |
Date: | 2010-06-08 15:47:11 |
Message-ID: | 20100608154711.GQ21875@tamriel.snowman.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
* Jeff Amiel (jamiel(at)istreamimaging(dot)com) wrote:
> On 6/8/10 10:39 AM, "Stephen Frost" <sfrost(at)snowman(dot)net> wrote:
> > I'm afriad you're not going to have a choice.. I would recommend
> > creating a mapping from the old IDs to the new ones as part of this
> > upgrade, to keep the historical information. Guess it's not nice to
> > point this out- but you really shouldn't have ever used OIDs for
> > something external to PG (or even internally, really). :)
>
> To be honest...this was done early in our postgresql careers (back in the
> 7.X days). We knew so little. :)
Then you've been through this before.. Perhaps you should go check out
what you did then. Back before 8.1, we didn't use OIDs for
users/groups. :) Changing to OIDs was part of the work that I did to
add role support.
Thanks,
Stephen
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Amiel | 2010-06-08 15:52:23 | Re: Restore roles with same oid |
Previous Message | Jeff Amiel | 2010-06-08 15:42:39 | Re: Restore roles with same oid |