At 02:59 PM 14/12/2003 +0100, you wrote:

>Helen Borrie schrieb:
>
> > Because an index is not a constraint and a constraint is not an index. A
> > constraint has rules, one of which is that it requires a unique index to
> > enforce a rule.
>
>There is one flaw hera: When trying to create an FK to fields having
>an unique index only you get an error mesage indicating that an unique
>index is required. This message should be changed to indicate an
>unique constraint to be required - else it is rather confusing.

Yep, this wrong message text was reported and discussed a while ago. I
*think* it got fixed in RC7's firebird.msg. You could ask on
firebird-devel if you're doubtful.

/h