Subject | Problem with time of constraint checking |
---|---|
Author | dwaradzyn |
Post date | 2005-08-10T07:36:36Z |
This is what i do:
1. create some tables
2. add constraints to them
3. commit
4. fill tables with data
5. commit
I get an exception regarding violation of foreign key during last
commit. How can i make it to throw this exception at the time
inserting data, not when committing? I asked at firebird-support
list and i was assured that firebird supports only immediate
constraint checking and the behaviour i have here is opposite.
Please help. Thanks in advance.
1. create some tables
2. add constraints to them
3. commit
4. fill tables with data
5. commit
I get an exception regarding violation of foreign key during last
commit. How can i make it to throw this exception at the time
inserting data, not when committing? I asked at firebird-support
list and i was assured that firebird supports only immediate
constraint checking and the behaviour i have here is opposite.
Please help. Thanks in advance.