Re: Using oid as pkey

On 8/20/07, Michael Glaesemann <grzm@seespotcode.net> wrote:
>
> 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.

And they wrap around, so there's a chance of collision with oids.