> > Just out of curiosity, I want to ask one more question. > > How can FK constraint fail if I am removing (replacing) row from the > > 'child' table? > > The FK constraint can fail because a new row is being inserted into the > child table. The reason statement rollback may be required is because > any replaced rows will be removed before SQLite has a chance to figure > out if the INSERT actually does violate the PK constraint. >
I see, thank you for explanation, Dan. Best regards, Paul _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
