Re: Using oid as pkey

On Aug 20, 2007, at 16:58 , Ed L. wrote:

> What are the concerns with using oid as the column for a primary
> key declaration for use in trigger-based replication?

Just don't. oids are intended to be used by the database server
itself rather than as part of the user-defined data. If you're
looking for a auto-generated integer to use as a primary key, use
SERIAL. You'd have to specify your table WITH OIDS anyway as they're
no longer used by default for table rows, so there's really nothing
to be gained by using oids.

Michael Glaesemann
grzm seespotcode net