Réf. : OID's as Primary Keys

From: t(dot)ngockhoi(at)bpf(dot)vnu(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Réf. : OID's as Primary Keys
Date: 2001-11-08 14:20:58
Message-ID: C1256AFE.004ED3FA.00@bpfn01.bpf.vnu.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-11-08 14:31:30 Re: OID's as Primary Keys
Previous Message Martijn van Oosterhout 2001-11-08 14:04:17 Re: OID's as Primary Keys