Re: [sqlite] Max page count not being remembered across close/open in SQLite 3.7.6.3

That is exactly the problem: such limits are app-specific logic, and that 3rd-party db manager cannot know about app-specific logic. No, that is a metadata which belongs to the DB. Forcing this pragma to always apply would in fact hinder some cases, e.g. creating a backup copy of a table

Re: [sqlite] Max page count not being remembered across close/open in SQLite 3.7.6.3

On Tue, Aug 30, 2011 at 6:15 PM, Jean-Christophe Deschamps wrote: > I also hope this can get changed someday, as this particular pragma can > have a devastating effect when the schema expects it to be set and you're > using a third-party manager (not your well coded

Re: [sqlite] Max page count not being remembered across close/open in SQLite 3.7.6.3

BTW this pragma should be applicable to a list of tables or * for all tables. I realize I didn't state I was talking about recursive_triggers pragma. Sorry for not having made this clear in the previous post. -- j...@antichoc.net

Re: [sqlite] Max page count not being remembered across close/open in SQLite 3.7.6.3

> 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. > Ok, thanks, If that is the case for this PRAGMA I did not realise. Similar to the page_count PRAGMA I would

Re: [sqlite] Max page count not being remembered across close/open in SQLite 3.7.6.3

On 30 Aug 2011, at 5:03pm, Nick wrote: > On 30 Aug 2011, at 16:53, Simon Slavin wrote: > >> 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. > > Ok,

Re: [sqlite] Max page count not being remembered across close/open in SQLite 3.7.6.3

On 30 Aug 2011, at 16:53, Simon Slavin wrote: > > 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. > Ok, thanks, If that is the case for this PRAGMA I did

Re: [sqlite] Max page count not being remembered across close/open in SQLite 3.7.6.3

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

[sqlite] Max page count not being remembered across close/open in SQLite 3.7.6.3

Hi When performing some testing I noticed that SQLite was not enforcing the max_page_count pragma. Using the test case below is appears SQLite is not remembering the max_page_count across closing and opening a database file. Instead of the expected 12800 from PRAGMA max_page_count; I got