Re: [sqlite] bus error with SQLite 3.5.6

On Mar 3, 2008, at 12:03 PM, P Kishor wrote: > Dan, > > > On 3/2/08, Dan <[EMAIL PROTECTED]> wrote: >> >> Hi, >> >> I tried this script here with the latest CVS version and >> it didn't crash: >> >>CREATE TABLE pages(page_id INTEGER PRIMARY KEY, page_name TEXT, >> page_text TEXT); >>C

Re: [sqlite] bus error with SQLite 3.5.6

posting an update here -- I DROPped the insert_fts TRIGGER, and now the db works fine. No more crash on inserting a new row. So, the error was because of the trigger CREATE TRIGGER insert_fts AFTER INSERT ON pages BEGIN INSERT INTO fts_pages (rowid, page_text) VALUES (new.page_id, new.page_te

Re: [sqlite] bus error with SQLite 3.5.6

Dan, On 3/2/08, Dan <[EMAIL PROTECTED]> wrote: > > Hi, > > I tried this script here with the latest CVS version and > it didn't crash: > >CREATE TABLE pages(page_id INTEGER PRIMARY KEY, page_name TEXT, > page_text TEXT); >CREATE VIRTUAL TABLE fts_pages USING fts3(page_name, page_text)

Re: [sqlite] bus error with SQLite 3.5.6

Hi, I tried this script here with the latest CVS version and it didn't crash: CREATE TABLE pages(page_id INTEGER PRIMARY KEY, page_name TEXT, page_text TEXT); CREATE VIRTUAL TABLE fts_pages USING fts3(page_name, page_text); CREATE TRIGGER delete_fts AFTER DELETE ON pages BEGIN

[sqlite] bus error with SQLite 3.5.6

I have a fairly simple db with fts3 TABLE pages (page_id INTEGER PRIMARY KEY, page_name TEXT, page_text TEXT); VIRTUAL TABLE fts_pages USING fts3 (page_name, page_text); and the following triggers -- CREATE TRIGGER delete_fts AFTER DELETE ON pages BEGIN DELETE FROM fts_pages WHERE rowid = ol