On Fri, 11 Mar 2005, Eric Hochmeister wrote:
>Hi,
>
>I'm trying to figure out how to set the PRAGMA synchronous attribute
>to ON permanently for my database. I've read the pragma docs at
>(http://www.sqlite.org/pragma.html) and looked at the source code and
>haven't been able to figure it out.
>
>I am able to load up my database with sqlite3 and send the PRAGMA
>synchronous=on; command which sets it only for the duration that I'm
>using sqlite3 to view/manipulate the database. Once I quit and access
>it again, the synchronous attribute is reset.
>
>How can I save the PRAGMA synchronous attribute to be equal to 'ON'
>permanently? (so that its saved in the database)
That ability was removed for 3.x. The 2.8.x releases had a
"default_synchronous" pragma, but it wasn't carried over to 3.x. It was
considered a mis-feature that can be dangerous for your data.
>
>
>Thanks,
>
>Eric
>
Christian
--
/"\
\ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \