On 8 June 2010 15:59, Jeff Amiel <jamiel@istreamimaging.com> 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