A better solution is to use the serial data type. OID is depreciated
and may go away.
http://www.postgresql.org/docs/7.4/static/datatype.html#DATATYPE-SERIAL
On 19 Oct 2004 07:54:36 -0700, Raffaele Spizzuoco
<kilomegabyte@freemail.it> wrote:
> Hi!
>
> I'm from Italy, and sorry about my english...
> I have a question that I know it is already said in the groups but I
> have however some doubts
> I have seen it is technically possible to use OID as PRIMARY KEY and
> as FOREIGN KEY but it is correct to do so for the database's logical
> integrity?
> Is it better I use in any case other keys and not oid to avoid the
> possible wraparound? or the wraparound is an extreme case and so I can
> use quietly OID as PRIMARY and FOREIGN KEY?
>
> Thanks
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>