So I should write my BLOB in another (not-indexed) table, UPDATE the indexed table copying from the other, and finally delete the line in the first table? All in one transaction?
On Sun, Apr 28, 2013 at 4:23 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 28 Apr 2013, at 3:02pm, Paolo Bolzoni <paolo.bolzoni.br...@gmail.com> > wrote: > >> And it seems quite an improvement, alas now I get this error: "cannot >> open indexed column for writing." > > You have a column of type BLOB. > It is now an indexed column. > You are trying to use the BLOB editing routines to write into that BLOB > rather than just replacing the value in one operation. > > SQLite won't let you open an indexed BLOB value in editing mode because it > doesn't know what you want the index to reflect while the value is being > edited. > > You can replace the BLOB value in a single operation (using UPDATE). Or you > can remove any index from that column. Sorry. > > Simon. > _______________________________________________ > 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