--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> Check the name of the foreign key constraint in the *other* table.

I bet

> it's called "PK_CUSTOMERS" too. Constraint identifiers have to be

globally

> unique (as do index identifiers).
>
> ./heLen

nope. pk_customers is the primary key on the customers table. the
other fk is fk_calls_customers. anyway i restarted the server and
tried it again and it worked ok. maybe a transaction hadn't been
committed (or rolled back)?

thanks for your help
mark