Hello Martin,
wow 7 Minutes to scan the manual. Yes I know RTFM :o
The update trigger is not issued if this test is correct here:
sqlite> create trigger fku before update on ch for each row begin
delete from blobdata where chId=old.id; end;
sqlite> select fname from ch limit 1;
100_5763.JPG.JPG
sqlite> select * from ch limit 1;
1|100_5763.JPG.JPG|137|118|127|512
sqlite> insert or replace into ch(fname, red, green, blue, dsize)
values ('xxx', 0, 0, 0, 0);
sqlite> select chId from blobdata where chId = 1;
1
The entry is still here.
Tobias
Martin Engelschalk schrieb:
> Hello Tobi,
>
> See http://www.sqlite.org/lang_conflict.html, near the bottom:
>
> "When this conflict resolution strategy deletes rows in order to satisfy
> a constraint, it does not invoke delete triggers on those rows. This
> behavior might change in a future release."
>
> I would be interested if an UPDATE - Trigger is invoked instead. Perhaps
> you could try it?
>
> Martin
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
