Hi, I'm using - ON UPDATE CASCADE, or ON DELETE CASCADE options in FK declarations - when I create the FK it works - but sometimes - after backup/restore or some undefined time - I don't know - it doesn't work. I'm using FB 2.5.2 64b on windows server 2008 R2
Example - today I wanted to change the key in primary table, but It raises an error org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544466. violation of FOREIGN KEY constraint "FK_DEF_LOK_TEMA_LOKACE" on table "DEF_LOK_TEMA"|Foreign key references are present for the record so I have to Ctrl+C from DDL - ALTER TABLE DEF_LOK_TEMA ADD CONSTRAINT FK_DEF_LOK_TEMA_LOKACE FOREIGN KEY (FK_LOKACE) REFERENCES DEF_LOKACE (ID_LOKACE) ON DELETE CASCADE ON UPDATE CASCADE; drop that FK and recreate it using the same definition as there was. And now I can change the recod - but I don't know how long it will work It is not the first time I met this problem. Do you anybody know how make it work properly for all times?
