Sorry, I misread your reply. You are correct. In your scenario, after step 3 the trigger references a table that no longer exists. A similar issue exists with foreign keys.
Bogdan On Sun, Oct 20, 2013 at 10:11 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 20 Oct 2013, at 4:09pm, Bogdan Ureche <bogdan...@gmail.com> wrote: > > > I tried without success to reproduce this scenario. > > > > create table t1(c); > > create temporary trigger tr1 after insert on t1 begin select raise(abort, > > 'error'); end; > > insert into t1(c) values(1); -- error is raised here > > drop table t1; > > create table t1(c); > > insert into t1(c) values(1); -- no error here > > > > It seems that, when the table dies, it takes the associated trigger down > > with it. > > Not that table. The other table. Suppose you had a trigger on table t1 > which inserted a row into t2. Then you can DROP and reCREATE t2 while the > trigger exists. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users