Thanks for the reply, > You could always create a table that stores the pragma values in which > you're interested, then have code that checks on start up to set those > pragmas to those values.
I was thinking the same thing, but only as a last resort. It seems like the database should be able to remember that I set recursive_triggers to true or that I turned case_sensitive_like on. I'd like to be able to declare it once in my schema and let sqlite handle the details rather than reminding it every time that I open the database. It's obvious that some of the pragmas (freelist_count for example) should not be saved because they act like queries. But maybe others should have persistence. Am I just missing how to persist these values, or does the current implementation not have this capability? There could also be a completely great reason why these values don't persist, and I'm just not seeing it. --Erik Lechak _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
