Re: oid's and primary keys on insert - Mailing list pgsql-general

From Rob Brown-Bayliss
Subject Re: oid's and primary keys on insert
Date
Msg-id 1028924732.1856.36.camel@everglade.zoism.org
Whole thread Raw
In response to oid's and primary keys on insert  (Rob Brown-Bayliss <rob@zoism.org>)
Responses Re: oid's and primary keys on insert  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-general
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
*

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: oid's and primary keys on insert
Next
From: Rob Brown-Bayliss
Date:
Subject: Re: oid's and primary keys on insert