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 
> 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

Reply via email to