Use of OIDS as primary keys

From: Alan Wayne <alanjwayne(at)yahoo(dot)com>
To: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Use of OIDS as primary keys
Date: 2002-05-12 06:23:05
Message-ID: 20020512062305.85145.qmail@web21208.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I'm wondering how I can use the system generated OIDS
as primary keys. Does postgre automatically fill in
the system generated oid when a field of type oid is
created as the primary key? And if so, how do I read
it back on a record just created so I can use it as a
secondary key in another table? And lastly, is it even
a good idea to use the oid as keys at all when I'm
going to eventually migrate the data from one machine
to another?

Any help would be appreciated,
AJW

__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Dimov 2002-05-12 06:36:13 Trigger performance
Previous Message Alan Wayne 2002-05-12 05:56:00 Use of OIDS as primary keys