Subject Re: [firebird-support] Foreign key violation - but why???
Author Bjoern Reimer
Hi,




AWH> Bjoern Reimer wrote:

>>
>> violation of FOREIGN KEY constraint "".
>> violation of FOREIGN KEY constraint "PK_XPERT_ANMELDUNGEN" on table "XPERT_ANMELDUNGEN".
>>

AWH> Did you commit the inserts to the two tables? I'm surprised that you
AWH> were able to create a foreign key if you have a connection that's
AWH> already touched the tables - typically that gets an error about "table
AWH> in use".

Yes, of course. The inserts have been done by a web application. The
foreign key should have been made by IBExpert.

Solved the problem with the No 1 FB problem solution: Recreate
database from IBExperts ASCII export. Then the foreign keys were no
problem.


Björn

--
Björn Reimer -- RRZE
Tel: +49-9131 - 85-27809
Fax: +49-9131 - 302941
Martensstr. 1 / 2.021
D - 9 1 0 5 8 Erlangen
www.rrze.uni-erlangen.de