On Sun, 2007-02-11 at 22:38 -0800, tolson wrote: > Hello, > > I just finished reading through the help files and I am unclear as to when > database should be used to prefix the pragma call (i.e. PRAGMA > [database.]cache_size;).
For pager pragmas not specifying a database where it is optional is the same as specifying "main". So if you want to change the cache-size of an attached database (internally, each open database file has it's own cache with it's own cache-size parameter) then you need to specify a database. > I was also wondering about schema pramas such as > index_list(table-name). If the table is in an attached database should it > be called as index_list(database.table-name) or would > database.index_list(table-name) be more appropriate? The latter. I'm pretty sure the former won't even parse. For a schema-query pragma, not specifying a database name causes SQLite to search all attached databases for the named schema object. With an explicit database name, only the named database is searched. The online docs don't cover the "PRAGMA database.pragma(...)" version of the PRAGMA command. Not sure if this means anything about how official this syntax is or not. > Thank you, > > Tom ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
