Currently the code base supports SQLITE_DEFAULT_RECURSIVE_TRIGGERS which controls the default setting for PRAGMA recursive_triggers.
Can someone please add similar support for a SQLITE_DEFAULT_FOREIGN_KEYS compiler define that allows the default setting of PRAGMA foreign_keys to be controlled at compile time? Just a couple of lines need to be added around line 343 of sqliteInt.h and just a couple more around line 1621 of main.c (the flag needed there is SQLITE_ForeignKeys). It's very trivial to make these changes (and I can easily do it locally), but it would sure be nice if support for enabling foreign keys by default could make it into the official distribution. Then you could just add -DSQLITE_DEFAULT_FOREIGN_KEYS=1 to the compiler options to have foreign keys always enabled by default. Anyone else interested in having support for this compiler option? Kyle _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
