From: | Evan Howarth <EHowarth(at)Intellicall(dot)com> |
---|---|
To: | "'Clark Evans'" <clark(dot)evans(at)manhattanproject(dot)com>, pgsql general mailing list <pgsql-general(at)postgreSQL(dot)org> |
Subject: | RE: [GENERAL] OID |
Date: | 1999-01-15 21:57:20 |
Message-ID: | 1155F985F268D211B25700A0C9E1C7610818C2@MAIL |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>I'm designing a database schema and have questions about OID.
> First, I assume that OID are system assigned? [yes]
> Second, Can I use OID as a primary key? [no]
Perhaps in ignorance, I have used the system assigned OID
as a non-topical primary key. Instead of using the
"PRIMARY KEY" key words, I explicitly created an index
on the OID column.
> Third, Is the OID invariant under an import/export process? [no]
> Fourth, Can I create table with an OID type for referencing
> another table? [no]
You can create a row of type OID. I have used them
as foreign keys the times I used the OID field as the
primary key.
From | Date | Subject | |
---|---|---|---|
Next Message | Jackson, DeJuan | 1999-01-15 22:10:27 | RE: [GENERAL] OID |
Previous Message | Clark Evans | 1999-01-15 21:22:43 | OID |