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

[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.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[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 database and creating an
equivalent structure, my input DDL has two-part tablenames in the
CREATE INDEX statements, and working around this syntax limitation
isn't going to do anything but slow me down a little.

Cheers!



-- 
"To avoid both financial loss and jail time, we provide security
mechanisms, including access control." -- Mike Burrows, 2006
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users