On 7/7/2011 10:38 AM, Ben Harper wrote: > I have a user-defined function that I register with create_function. > > Inside my function I try to drop an r-tree virtual table, but I get the error > SQLITE_LOCKED. > > Is there something special one needs to do in order to drop a table from > inside a user-defined function?
You can't change the database schema, from a user-defined function or otherwise, as long as there's any SELECT, INSERT, UPDATE or DELETE statement still in progress (one on which step was called but reset or finalize wasn't). Corollary: there's no way to drop a table from a user-defined function. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
