-
Notifications
You must be signed in to change notification settings - Fork 327
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Enabling foreign key constraints #147
Comments
Yeah, I have it enabled by default on my system sqlite (via compilation flag) but most system installs do not have this, so I've added a new CLI option -- use |
Excellent! Thank you for the super-quick update! |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hi,
This is a useful project! It has been working well for me but I've recently bumped into a couple data issues because constraints I expected weren't enforced (e.g., creating a reference to a nonexistent user and deletes not cascading). I think the
foreign_keys
pragma isOFF
(at least it looks like that based on an ad-hoc query of the value), and based on #76 (comment) I don't think there is a way to change that.Any chance of a new CLI option to turn on FK constraints?
Thanks.
The text was updated successfully, but these errors were encountered: