Re: OID and PK/FK KEYS - Mailing list pgsql-general

From Kevin Barnard
Subject Re: OID and PK/FK KEYS
Date
Msg-id b068057c041020135920697ae@mail.gmail.com
Whole thread Raw
In response to OID and PK/FK KEYS  (kilomegabyte@freemail.it (Raffaele Spizzuoco))
List pgsql-general
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
>

pgsql-general by date:

Previous
From: Thomas F.O'Connell
Date:
Subject: CREATE TEMPORARY TABLE AS ... ON COMMIT?
Next
From: "Gary Doades"
Date:
Subject: Re: how much ram do i give postgres?