AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() ![]() This means that if the constraint is deferred there is a big difference between RESTRICT and NO ACTION.įor immediate constraints there is probably no difference unless one could perhaps write a trigger program of some sort that executes within the context of the statement that resolves the integrity violation before the end of the statement. ![]() If they are not the primary key, then the parent key columns must be collectively subject to a UNIQUE constraint or have a UNIQUE index. Even if the foreign key constraint it is attached to is deferred, configuring a RESTRICT action causes SQLite to return an error immediately if a parent key with dependent child keys is deleted or modified. 1 Answer Sorted by: 24 The documentation says: Usually, the parent key of a foreign key constraint is the primary key of the parent table. The difference between the effect of a RESTRICT action and normal foreign key constraint enforcement is that the RESTRICT action processing happens as soon as the field is updated - not at the end of the current statement as it would with an immediate constraint, or at the end of the current transaction as it would with a deferred constraint. It might be advised to read the entire page. New issue 11:22:22 Error while importing data: FOREIGN KEY constraint failed 3100 Closed pawelsalawa opened this issue on 2 comments Owner pawelsalawa commented on 3117 pawelsalawa closed this as completed on Sign up for free to join this conversation on GitHub. That depends on the circumstance see here for the difference.
0 Comments
Read More
Leave a Reply. |