pg.ddx.io pgsql-docs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Oid and Oid Vector 2+ messages / 2 participants [nested] [flat]
* Oid and Oid Vector @ 2002-04-13 19:58 Camila Rocha <camilarrocha@hotmail.com> 0 siblings, 1 reply; 2+ messages in thread From: camilarrocha@hotmail.com @ 2002-04-13 19:58 UTC (permalink / raw) To: pgsql-docs@postgresql.org.pgsql-general Hi! I'd like to know why the field Oid can't be used as a foreign key. And more information about the type oidvector. What is it??????????????????? I can't find information about it anywhere. I'm asking these questions because i wanted to use the oid field as primary key of may tables, and relate them using the oid too. I i wanted to use the oidvector for this kind of things too. help! Thankx, Camila Goiania/GO/Brazil ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Oid and Oid Vector @ 2002-04-15 13:20 Roberto Mello <rmello@cc.usu.edu> parent: Camila Rocha <camilarrocha@hotmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Roberto Mello @ 2002-04-15 13:20 UTC (permalink / raw) To: Camila Rocha <camilarrocha@hotmail.com>; +Cc: pgsql-docs On Sat, Apr 13, 2002 at 12:58:37PM -0700, Camila Rocha wrote: > Hi! Oi :-) > I'd like to know why the field Oid can't be used as a foreign key. And oid is for PostgreSQL internal use, and AFAIK not meant to have other semantic meaning applied to it. oid's change when you restore backups for example, probably not a good thing for your application. Just create id attributes in your tables. Make them of type int or int8 or serial depending on your needs. > more information about the type oidvector. What is > it??????????????????? I can't find information about it anywhere. Honestly I don't know. > I'm asking these questions because i wanted to use the oid field as > primary key of may tables, and relate them using the oid too. I i > wanted to use the oidvector for this kind of things too. What did you want to do with oidvectors? -Roberto P.S.: Next time don't send this type of questions to the -docs list, which is for documentation discussions. The -general (which you seem to have cross-posted to) or the -sql list seem more appropriate. -- +----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-04-15 13:20 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2002-04-13 19:58 Oid and Oid Vector Camila Rocha <camilarrocha@hotmail.com> 2002-04-15 13:20 ` Roberto Mello <rmello@cc.usu.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox