Re: Using oid as pkey - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Using oid as pkey
Date
Msg-id 449E8EE1-EB20-4AB0-8D4E-FEDB99611D31@seespotcode.net
Whole thread Raw
In response to Using oid as pkey  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: Using oid as pkey  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: Using oid as pkey  ("D. Dante Lorenso" <dante@lorenso.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Using oid as pkey
Next
From: "Scott Marlowe"
Date:
Subject: Re: Using oid as pkey