Subject AW: [firebird-support] problem with FK
Author Alexander Gräf
> -----Ursprüngliche Nachricht-----
> Von: diegodelafuente [mailto:diegodelafuente@...]
> Gesendet: Dienstag, 8. Februar 2005 15:21
> An: firebird-support@yahoogroups.com
> Betreff: [firebird-support] problem with FK
>
> ---------- ERROR MESSAGE ----------
>
> This operation is not defined for system tables.
> unsuccessful metadata update.
> STORE RDB$INDICES failed.
> attempt to store duplicate value (visible to active
> transactions) in unique index "RDB$INDEX_5".
>

This usually occurs if you try to use the same name for the foreign key constraint twice. Those names must be globally unique.

Regards