On 6/8/10 10:47 AM, "Stephen Frost" wrote:
> 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.
Hmmm...this code has b
* Jeff Amiel (jam...@istreamimaging.com) wrote:
> On 6/8/10 10:39 AM, "Stephen Frost" 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 no
On 6/8/10 10:39 AM, "Stephen Frost" 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 h
* Jeff Amiel (jam...@istreamimaging.com) wrote:
> On 6/8/10 10:30 AM, "Thom Brown" wrote:
> > Can't you switch to using role names? I don't think oids are intended
> > to be used by anything other than PostgreSQL.
>
> :( If only I couldmassive audit tables contain these IDs with years of
> d
On 6/8/10 10:30 AM, "Thom Brown" wrote:
> Can't you switch to using role names? I don't think oids are intended
> to be used by anything other than PostgreSQL.
:( If only I couldmassive audit tables contain these IDs with years of
data
We have a plan to change to sequence values store
On 8 June 2010 15:59, Jeff Amiel wrote:
> We currently use the 'usesysid' column from pg_shadow (which is really
> pg_authid.oid I assume) for a trigger-based auditing mechanism.
>
> We are about to do a dump from an 8.2 database into 8.4 and would like to
> preserve the usesysid/oid when restorin
We currently use the 'usesysid' column from pg_shadow (which is really
pg_authid.oid I assume) for a trigger-based auditing mechanism.
We are about to do a dump from an 8.2 database into 8.4 and would like to
preserve the usesysid/oid when restoring.
No matter what options I throw ad pg_dumpall,
