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? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
