Received: from candle.pha.pa.us (216-55-132-35.dsl.san-diego.abac.net [216.55.132.35]) by postgresql.org (Postfix) with ESMTP id 413D8479452 for ; Mon, 15 Apr 2002 15:13:45 -0400 (EDT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id g3FJDTi10516; Mon, 15 Apr 2002 15:13:29 -0400 (EDT) From: Bruce Momjian Message-Id: <200204151913.g3FJDTi10516@candle.pha.pa.us> Subject: Re: oid and oidvector In-Reply-To: To: Camila Rocha Date: Mon, 15 Apr 2002 15:13:28 -0400 (EDT) Cc: pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL97 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200204/191 X-Sequence-Number: 7455 Camila Rocha wrote: > Hi! > > I'm from Brazil, and sorry about my english... > I'm having problems with the oid field, the field present in all tables. I > wanted to use it as a foreing key betwwen too tables, but i couldn't! is it > possible?? No, you can't use oid as a foreign key. You must use a PRIMARY column. > what about the data type oidvector?? i didn't find any documentation about > it, i wanted to use it to keep a lot of oids of other objects... like an > array of foreign keys, you know? oidvector is for internal db use. It is an array of 16 oid's. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026