On 30 Aug 2011, at 16:53, Simon Slavin wrote: > > Most PRAGMAs, including others which modify engine behaviour like > recursive_triggers, are not stored in the database but have to be restated > every time you open the database file. >
Ok, thanks, If that is the case for this PRAGMA I did not realise. Similar to the page_count PRAGMA I would have intuitively expected max_page_count would not need restating every time the database file is open. Nick _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users