Thread: OID and PK/FK KEYS

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

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
>