Re: [sqlite] saving pragma states in database

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

Re: [sqlite] saving pragma states in database

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. On Tue, Aug 23, 2011 at 1:24 PM, Erik Lechak wrote: > Hello all, > > Is there a way to save pragma states to

[sqlite] saving pragma states in database

Hello all, Is there a way to save pragma states to the database? I have a delete trigger that I would like to fire off on a delete ( actually a replace), but I need the database to maintain the "pragma recursive_triggers=1" state. Otherwise the trigger does not get fired. I would just like the