Re: [sqlite] Confusion on 'foreign key mismatch' errors

2012-11-12 Thread Simon Slavin
On 12 Nov 2012, at 7:54am, Darren Spruell wrote: > If I'm not mistaken, that's a problem too, as type definitions are > ignored on FTS columns: Oh. You're trying to mess with a table used in an FTS definition. Okay. Don't do that unless you understand how FTS works.

Re: [sqlite] Confusion on 'foreign key mismatch' errors

2012-11-11 Thread Darren Spruell
On Sun, Nov 11, 2012 at 11:16 PM, Simon Slavin wrote: > > On 12 Nov 2012, at 5:49am, Darren Spruell wrote: > >> sqlite> CREATE TABLE ip ( >> ...> id INTEGER PRIMARY KEY, date_added DEFAULT CURRENT_DATE, >> ...> ip

Re: [sqlite] Confusion on 'foreign key mismatch' errors

2012-11-11 Thread Simon Slavin
On 12 Nov 2012, at 5:49am, Darren Spruell wrote: > sqlite> CREATE TABLE ip ( > ...> id INTEGER PRIMARY KEY, date_added DEFAULT CURRENT_DATE, > ...> ip VARCHAR(15) NOT NULL UNIQUE, comment INTEGER NOT NULL, > ...> FOREIGN

Re: [sqlite] Confusion on 'foreign key mismatch' errors

2012-11-11 Thread Pavel Ivanov
> # http://answers.oreilly.com/topic/1955-how-to-use-full-text-search-in-sqlite/ > Unlike traditional tables, the ROWID of an FTS table is stable through > a vacuum (VACUUM in Appendix C), so it can be reliably referenced > through a foreign key. I'm not sure who wrote that but this page

[sqlite] Confusion on 'foreign key mismatch' errors

2012-11-11 Thread Darren Spruell
I'm stuck on some errors related to my use of foreign key constraints in my application. The following illustrates: $ sqlite3 SQLite version 3.7.9 --SOURCE-ID-- Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> PRAGMA foreign_keys = ON; sqlite> CREATE VIRTUAL TABLE