Hi Dave.

The second line isn't indicated in the property columns of unique index (multi column).
Please Apply it.

ex.)
CREATE TABLE xxxx (a int, b int, unique(a,b));
b is missing, and falls.

regards,
Hiroshi Saito

Attachment: dlgIndex_patch
Description: Binary data

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to