Subject | Re: [firebird-support] Unique constraint vs unique index, why do they have to be different? |
---|---|
Author | Elmar Haneke |
Post date | 2003-12-14T13:59:56Z |
Helen Borrie schrieb:
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.
Elmar
> Because an index is not a constraint and a constraint is not an index. AThere is one flaw hera: When trying to create an FK to fields having
> constraint has rules, one of which is that it requires a unique index to
> enforce a rule.
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.
Elmar