Re: [sqlite] Cannot set page_size pragma from file

[Andrew Finkenstadt]

On 6/27/07, Neil Hughes <[EMAIL PROTECTED]> wrote:

PRAGMA default_cache_size=250000;
PRAGMA page_size=4096;
CREATE TABLE timestamp (date TEXT, time TEXT, script_version REAL);
INSERT INTO timestamp VALUES('27/06/07', '14:38:18', '0.01');

I've only just learned this today during an "innocent" refactoring.
page_size need be the first statement executed against a newly-created
database file.

--andy