Subject cannot build an integrity constraint
Author Duilio Foschi
I use Firebird v. WI-T1.0.0.679 .

1. I create a unique index on tableA:

create unique index foo_index on tableA (field1, field2)

The index is built ok.

2. I try to create a reference on tableB:

ALTER TABLE tableB add FOREIGN KEY (field1, field2) REFERENCES tableA
(field1, field2)

When I do so, I get the error message

"could not find unique index with specified columns"

When I do this using only 1 column, ev works ok.

Besides, if I try to build a reference on a multi-column primary index, ev
works ok.

Any idea ?


Duilio Foschi