Received: from chapur.com (du-148-233-219-143.prodigy.net.mx [148.233.219.143]) by hub.org (8.10.1/8.10.1) with ESMTP id e9BJI4r21111 for ; Wed, 11 Oct 2000 15:18:04 -0400 (EDT) Received: from desa03 ([192.168.103.49]) by 0chapur.com (8.8.7/8.8.7) with SMTP id OAA23512 for ; Wed, 11 Oct 2000 14:13:22 -0500 Message-ID: <013401c033b8$087d91e0$3167a8c0@chapur> From: "Franz J Fortuny" To: Subject: Referential integrity: broken rule? Date: Wed, 11 Oct 2000 14:18:26 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200010/109 X-Sequence-Number: 1771 This table: create table things ( idthing integer not null, isthis boolean not null primary key(idthing,isthis) .... ) would be referenced by this one: create table forthings ( fromthing integer not null references things(idthing), .... ) The above SHOULD NOT be accepted, since table "things" did not declare idthing as UNIQUE. However, it IS accepted under PostgreSQL (7.0.2). Am I wrong? Best regards, F J Fortuny