Re: [sqlite] Fts4 table + triggers

[Alexey Pechnikov]

Use view + triggers on view. Triggers on view can modify FTS4 table
and any other.

2011/11/22 Ephraim Stevens :
> Greetings all,
>
> It is well known that you cannot create triggers against virtual tables and
> fts4 tables are a form of virtual table.
>
> Has anyone developed a work around method for this or simulating the end
> effect?
>
> I have a full text search table which is comprised of joining and selecting
> from some underlying tables. I need to synch this full text search table
> with underlying tables upon insert or update (of the full text search
> table).
>
> A trigger would be ideal here but you can't use them against virtual
> tables. I'm sure someone has run into this same dillema. Thanks for any
> suggestions.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Fts4 table + triggers

[Ephraim Stevens]

Greetings all,

It is well known that you cannot create triggers against virtual tables and
fts4 tables are a form of virtual table.

Has anyone developed a work around method for this or simulating the end
effect?

I have a full text search table which is comprised of joining and selecting
from some underlying tables. I need to synch this full text search table
with underlying tables upon insert or update (of the full text search
table).

A trigger would be ideal here but you can't use them against virtual
tables. I'm sure someone has run into this same dillema. Thanks for any
suggestions.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users