Looks like using replace on a fts3 table doesn't seem to work: SQLite version 3.6.23.1 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create virtual table fts using fts3(message); sqlite> insert into fts (docid, message) values (1,'bob'); sqlite> insert into fts (docid, message) values (1,'bob'); Error: constraint failed sqlite> replace into fts (docid, message) values (1,'bob'); Error: constraint failed
That should've worked I think. sqlite> sqlite> create table nonfts(docid INTEGER PRIMARY KEY, message TEXT); sqlite> insert into nonfts (docid, message) values (1,'bob'); sqlite> insert into nonfts (docid, message) values (1,'bob'); Error: PRIMARY KEY must be unique sqlite> replace into nonfts (docid, message) values (1,'bob'); sqlite> Thanks, - Nasron Cheong _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
