Postgres Pro
Downloads
Home   >   mailing lists

Re: references table(multiple columns go here) - Mailing list pgsql-sql

From Tom Lane
Subject Re: references table(multiple columns go here)
Date
Msg-id 18473.1040311033@sss.pgh.pa.us
Whole thread Raw
In response to Re: references table(multiple columns go here)  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
Responses Re: references table(multiple columns go here)  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List pgsql-sql
Tree view 
Gary Stainburn <gary.stainburn@ringways.co.uk> 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

pgsql-sql by date:

Previous
From: Robert Treat
Date:
Subject: Re: unsubscribe
Next
From: Gary Stainburn
Date:
Subject: Re: references table(multiple columns go here)