On 8/20/07, Michael Glaesemann <grzm@xxxxxxxxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
