On 8 June 2010 15:59, Jeff Amiel <jamiel@xxxxxxxxxxxxxxxxxx> 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 restoring. > > No matter what options I throw ad pg_dumpall, it gives me 'create role' > commands...and obviously no preservation of the oids. > > Any suggestions on how I can manage this? > Can't you switch to using role names? I don't think oids are intended to be used by anything other than PostgreSQL. Thom -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
