Am Sat, 14 Oct 2017 13:01:59 -0400 schrieb Richard Damon: > you could create a record in the other table without a corresponding > record in the blob table, but that is sort of needed to avoid chicken > and egg issues with creating new records (not sure when foreign key > requirements are tested), [...]
Depends on how the foreign key was defined; in order to avoid chicken and egg issues, a Deferred Foreign Key Constraint is recommended: http://www.sqlite.org/foreignkeys.html#fk_deferred AFAIK, at least. ;-) _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users