RE: [GENERAL] OID

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.

Browse pgsql-general by date

  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