Re: oid's and primary keys on insert

On Sat, 2002-08-10 at 08:13, Elaine Lindelef wrote:

> Add another column of type SERIAL and use it to store a plain
> incremented integer, and use it like you used to use OIDs.

Except that this brings me back to the reason for not useing a sequence
as a primary key:

What happens when site2 has already placed a row with value 1234 in this
column and site1's sequence is up to 1233, I insert the row, and now I
have two rows with 1234 as the ID row...

At least OID's will be unique as when inserting rows from another site
they still use the OID from the local machine.


--

*
*  Rob Brown-Bayliss
*