it is a test case for the this PRAGMA... in reality, yes, just one call is good enough.
On Tue, Apr 21, 2009 at 12:37 PM, John Machin <sjmac...@lexicon.net> wrote: > On 21/04/2009 2:07 PM, julian qian wrote: >> HI, >> call PRAGMA page_size =xxx twice immediately, only first time it has >> effect, immediately call it second times, the value can't be changed. >> is this predefined? http://www.sqlite.org/pragma.html#pragma_page_size >> only say "The page_size pragma will only cause an immediate change in >> the page size if it is issued while the database is still empty, prior >> to the first CREATE TABLE statement" > > Do you have any good reason for wanting to call the pragma twice in a > row with two different values? Can't you just call it once with the > value that you use currently on the second call? > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users