Re: [sqlite] page_size: bug with PRAGMA or documentation?

Thanks Richard, that's much clearer. Just one thing: "The page_size pragma will only set in the page size if ..." The "in" looks out of place :) -Rowan On 12 September 2016 at 19:43, Richard Hipp wrote: > On 9/12/16, Rowan Worth wrote: > > The docs for

Re: [sqlite] page_size: bug with PRAGMA or documentation?

On 9/12/16, Rowan Worth wrote: > The docs for PRAGMA page_size say that it is effective if issued "prior to > the first CREATE statement". Fixed at https://www.sqlite.org/draft/pragma.html#pragma_page_size This will be pushed to the main website at the next release. -- D.

Re: [sqlite] page_size: bug with PRAGMA or documentation?

[mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Rowan Worth Gesendet: Montag, 12. September 2016 12:14 An: General Discussion of SQLite Database <sqlite-users@mailinglists.sqlite.org> Betreff: [sqlite] page_size: bug with PRAGMA or documentation? Hey guys, Th

[sqlite] page_size: bug with PRAGMA or documentation?

Hey guys, The docs for PRAGMA page_size say that it is effective if issued "prior to the first CREATE statement". So imagine my surprise when I found page_size to be ineffective without ever issuing a CREATE statement! The sequence goes like so: $ rm /tmp/lol.db; sqlite3 /tmp/lol.db SQLite