On Wed, Dec 12, 2012 at 3:40 PM, Richard Hipp <d...@sqlite.org> wrote: >On Wed, Dec 12, 2012 at 3:36 PM, Richard Hipp <d...@sqlite.org> wrote: >> On Wed, Dec 12, 2012 at 2:29 PM, Levi Haskell (BLOOMBERG/ 731 LEXIN) < >> lhask...@bloomberg.net> wrote: >> >>> My suggestion would be to have check_integrity command verify referential >>> integrity as well only if it's executed while the foreign key enforcement >>> is enabled on the connection. >>> >> >> This seems like a reasonable request. And while we are at it, we will >> likely also verify UNIQUE and CHECK constraints too.
Thank you! >> > >By the way, verifying foreign key constraints is trickier than it seems at >first glance, because you have to make sure to get it right for cases >involving NULLs and differing collating sequences and affinities between >parent and child tables. Intresting, doesn't sqlite3FkCheck() already take these into account? Just curious. - Levi _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users