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.
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
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
> # 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
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
5 matches
Mail list logo