| 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 05:56:00 |
| Message-ID: | 20020512055600.19033.qmail@web21210.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Wayne | 2002-05-12 06:23:05 | Use of OIDS as primary keys |
| Previous Message | Randall Perry | 2002-05-12 03:21:14 | Re: Can this be done in one query? |