Réf. : OID's as Primary Keys - Mailing list pgsql-general

From t.ngockhoi@bpf.vnu.com
Subject Réf. : OID's as Primary Keys
Date
Msg-id C1256AFE.004ED3FA.00@bpfn01.bpf.vnu.com
Whole thread Raw
List pgsql-general
No i don't thing so. The OID can be use tu improve some sql statement, but it
can't be use as primary key. Because it can be change.

I thing the best way is create a new type for some ref key. This type have a
integer as primary key and a OID of joint's objects. The triger need tu update
automaticaly the OID of ref key.

Best regards,
Ngoc-Khoi TO.



pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: OID's as Primary Keys
Next
From: Tom Lane
Date:
Subject: Re: "Relation does not exist" error