On Nov 24, 2008, at 5:07 PM, Christophe Leske wrote: > Hello, > > i have a rtree table which I dynamically opulate with results. > > Sometimes however, I get a "constraint failed" error from SQLite. > After > some poking, I found that it occurs whenever my statement tries to > insert a record which has an ID that is already in the rtree-table, > which is ok, as the ID is to be unique. > > However, the insert statement is written as followed: > > insert or ignore into idlookup select * from (select * from cl2) > where ( > lomi>2.64 and loma<3.29 and lami>42.48 and lama<42.82); > SQL error: constraint failed > > Like i said, the error occurs because one of the records to be added > are > already in the idlookup table. > > It would be my understanding however that the "or ignore" statement > would silently let those inserts fail if they are already in? > > What´s wrong here?
I don't think any of the conflict handling clauses (OR IGNORE, OR ROLLBACK etc.) work with virtual tables (rtree, fts3). Dan. > > > > -- > Christophe Leske > > www.multimedial.de - [EMAIL PROTECTED] > http://www.linkedin.com/in/multimedial > Lessingstr. 5 - 40227 Duesseldorf - Germany > 0211 261 32 12 - 0177 249 70 31 > > > _______________________________________________ > 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