I agree that something like that would be nice, at this point I think it's just backwards compatability issues preventing that.
The best you can do at the moment is to compile anything you use/write yourself with... SQLITE_DEFAULT_FOREIGN_KEYS=1 ...but if you're not in a situation where you have full control over who accesses your databases and with what tool version, then that's only going to help prevent you from messing it up by accident, and not others. -----Original Message----- From: sqlite-users [mailto:[email protected]] On Behalf Of John G Sent: Friday, April 21, 2017 1:40 PM To: SQLite mailing list Subject: Re: [sqlite] Which pragmas are persistent? PRAGMA foreign_keys=1 is transient, but it would be nice if it were persistent. John G On 13 April 2017 at 12:35, Tony Papadimitriou <[email protected]> wrote: > -----Original Message----- From: [email protected] > >> What would be useful (at least via the shell CLI) is a "list_pragmas" >> pragma that shows for example something like this: >> >> sqlite> PRAGMA list_pragmas; >> > > PRAGMA list; > > would be less redundant. > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
