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



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to