Re: [pgadmin-support] data types oid and oidvector

[Dave Page]

Title: Message

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 [EMAIL PROTECTED].   Regards, Dave. -----Original Message----- From: Camila Rocha [mailto:[EMAIL PROTECTED]] Sent: 09 April 2002 20:45 To: [EMAIL PROTECTED] 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