Re: [sqlite] fts3 - primary key doesn't seem to do anything

This is because fts tables intentionally do not support things like primary keys. There is the rowid/docid, and there are text columns, and that is all. If you want to add key support, you can use an auxiliary table with a one-to-one mapping on docid. -scott On Sat, Jan 19, 2008 at 12:33 PM,

[sqlite] fts3 - primary key doesn't seem to do anything

SQLite version 3.5.4 sqlite> create virtual table foo using fts3(content, id primary key); sqlite> insert or replace into foo values('anything', 1); sqlite> insert or replace into foo values('anything', 1); sqlite> insert or replace into foo values('anything else', 1); sqlite> select * from foo;