Re: data types oid and oidvector

It's not a good idea to use oid's as foreign keys as they may change if you
dump/reload your database. For this reason, I think PostgreSQL disallows the
use of them.

iirc, the oidvector column is an array of oid's type. You should look in the
PostgreSQL manuals (in the pgAdmin helpfile) for more details, if not, try a
post to pgsql-general(at)postgresql(dot)org <mailto:pgsql-general(at)postgresql(dot)org> .

Regards, Dave.

-----Original Message-----
From: Camila Rocha [mailto:camilarrocha(at)hotmail(dot)com]
Sent: 09 April 2002 20:45
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] data types oid and oidvector

hey!

i wanted to know if there's a way to use the column oid (which is present in
every table) as a foreign key in another table. I tried, but i couldn't do
it.
and what about the type oidvector?? where can i find more information about
it? i want to put in it another objetc's oids.

thanks!

Camila
GO/Brazil