Re: [sqlite] call PRAGMA page_size twice?

On Mon, Apr 20, 2009 at 11: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

Re: [sqlite] call PRAGMA page_size twice?

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 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,

Re: [sqlite] call PRAGMA page_size twice?

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

[sqlite] call PRAGMA page_size twice?

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