On 2004-03-30, at 19.11, Will Leshner wrote:
On Mar 30, 2004, at 9:04 AM, Jacob Engstrand wrote:
For example, I created an index using the following in 2.7.5:
CREATE INDEX 'addressesZipIndex' ON 'addresses' (zip)
Hmm. This might be a bug, actually, but if you wrapped your index name in single quotes like that, then the quotes became part of the name. I just created one like that and now I can't delete it. I think the names of indexes probably shouldn't be wrapped in quotes when they are created.
Yes, I thought about that, but the quotes are not part of the name in the SQLITE_MASTER table. Of course, I did try to "DROP INDEX 'addressesZipIndex'" too, but no success... :(
/jak
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
