OK. I'm assuming this is not a regular pattern that has an idiomatic workaround?
Ben -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: 07 July 2011 05:18 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] DROP TABLE yields SQLITE_LOCKED from user-defined function > Is there something special one needs to do in order to drop a table from > inside a user-defined function? > > To test, I call it simply like so: > SELECT my_function(); It shouldn't be ever possible to change the database from within a function called from SELECT statement. SELECT query doesn't ever changes any data. Pavel On Thu, Jul 7, 2011 at 10:38 AM, Ben Harper <b...@imqs.co.za> 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? > > To test, I call it simply like so: > SELECT my_function(); > > Thanks, > Ben > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users