[sqlite] feature request: specify database name in table-name part of CREATE INDEX

2010-05-11 Thread David Nicol
http://www.sqlite.org/lang_createindex.html shows the optional [DATABASE] DOT for where the index lives, but not for where the indexed table lives. Just in case anyone is keeping track of weird edge cases that are actually being used somewhere and why, I'm modifying a DDL dump from a different

Re: [sqlite] feature request: specify database name in table-name part of CREATE INDEX

2010-05-11 Thread David Nicol
Sorry, big duh. Of course a SQLite index needs to be in the same file as the indexed table; and that is specified. Having an index for a table in one database stored in a different database would not be consistent with SQLite, as both would need to be opened together.