Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B1C62476F5A for ; Thu, 19 Dec 2002 10:18:33 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 80CA3476CE7 for ; Thu, 19 Dec 2002 10:17:23 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id gBJFHEpd018474; Thu, 19 Dec 2002 10:17:14 -0500 (EST) To: Gary Stainburn Cc: Tomasz Myrta , pgsql-sql@postgresql.org Subject: Re: references table(multiple columns go here) In-reply-to: <200212190928.19736.gary.stainburn@ringways.co.uk> References: <200212181625.11316.gary.stainburn@ringways.co.uk> <200212181718.42870.gary.stainburn@ringways.co.uk> <8026.1040233829@sss.pgh.pa.us> <200212190928.19736.gary.stainburn@ringways.co.uk> Comments: In-reply-to Gary Stainburn message dated "Thu, 19 Dec 2002 09:28:19 +0000" Date: Thu, 19 Dec 2002 10:17:13 -0500 Message-ID: <18473.1040311033@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/239 X-Sequence-Number: 10827 Gary Stainburn writes: > That did the trick. However, I now have another problem with the constraint > complaining about there not being an index to refer to. However, there is. No there isn't: > jrank int4 not null references ranks(rrank), -- needs sorting ^^^^^^^^^^^^^^^^^^^^^^^ You have no index constraining rrank (by itself) to be unique. regards, tom lane