Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

what is the need of primary key column when we have oid..

843838Oct 30 2005 — edited Nov 1 2005
hi,
i see everywhere that almost in every table we keep a seperate column for primary key which is automatically incrementing and unique which helps in identifying different rows.

what is the need of such seperate column when we have oid already there. as i read it is a unique oid for the whole postgres installation(may be similar case for other databases too). then is there any harm in using oid instead of a seperate primary key column...or is there any advantages with making a primary key column
plz give suggestions.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 29 2005
Added on Oct 30 2005
3 comments
285 views