On 30 Aug 2011, at 4:46pm, Nick wrote: > Using the test case below is appears SQLite is not remembering the > max_page_count across closing and opening a database file.
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. Actually, it might be worth stating that at the top of the appropriate page in the documentation. Many users assume the opposite. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users