Received: from vayron.anpe.fr ([195.101.137.18]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8BEwr764388 for ; Tue, 11 Sep 2001 10:58:53 -0400 (EDT) (envelope-from patrick.jacquot@anpe.fr) Received: from anpe.fr (localhost.localdomain [127.0.0.1]) by vayron.anpe.fr (Postfix) with ESMTP id A880F2329B for ; Tue, 11 Sep 2001 17:00:13 +0200 (CEST) Message-ID: <3B9E269B.B56278F6@anpe.fr> Date: Tue, 11 Sep 2001 16:58:35 +0200 From: patrick.jacquot@anpe.fr Organization: anpe X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.9-19mdk i586) X-Accept-Language: en MIME-Version: 1.0 To: liste SQL Subject: referencing oid impozsible ? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200109/54 X-Sequence-Number: 4700 hello all I tried recently (pgsql 7.1.2) to establish the oid of one table as foreign key in another. To no avail : there was no uniqueness constraint on that column Naturally, it seems impossible to add a uniqueness constraint to such a system column. As far as i know, the oid is by nature unique, excepting for the case of wrapping of their sequence. Is there any workaround ?