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.

PRAGMA quick_check is still available for users who do not want to take the
extra overhead of verifying UNIQUE, CHECK, and foreign key constraints.

Does anybody know of any reason why we should not do this?

-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to