Gary Stainburn <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
