Hi All -

I am getting a very strange error when trying to define a foreign key
on a machine with no other users.

alter table "testcases"
add constraint "fk_testcases_testtemplates"
foreign key ("testtemplate_id")
references "testtemplates" ("id");

Statement failed, SQLCODE = -607
unsuccessful metadata update
-STORE RDB$INDICES failed
-deadlock

The script I wrote is full of queries like this. I have a simple star
schema, the data is all loaded and has been checked for NULLs in the
PK/FK columns.

What could cause this error?

(FB 2.1.1, Win32, simple install).

TIA,
________________________________________________________
Richard Wesley Senior Software Developer Tableau
Software
Visit: http://www.trytableau.com/now.html