Postgres Pro
Downloads
Home   >   mailing lists

Re: data types oid and oidvector - Mailing list pgadmin-support

From Dave Page
Subject Re: data types oid and oidvector
Date
Msg-id FED2B709E3270E4B903EB0175A49BCB129336A@dogbert.vale-housing.co.uk
Whole thread Raw
In response to data types oid and oidvector  ("Camila Rocha" <camilarrocha@hotmail.com>)
List pgadmin-support
Tree view
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@postgresql.org.
 
Regards, Dave.
-----Original Message-----
From: Camila Rocha [mailto:camilarrocha@hotmail.com]
Sent: 09 April 2002 20:45
To: pgadmin-support@postgresql.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

pgadmin-support by date:

Previous
From: "fnievinski2"
Date:
Subject: null rows - importing a table with
Next
From: Dave Page
Date:
Subject: Re: null rows - importing a table with