Hi, I was wondering about the lock state when one the TRIGGER are getting invoked? I would like to apologize, if I missed the explanation in the documentation or in previous thread.
For example: the INSERT inserts a row into table and invokes registered ON INSERT (AFTER) trigger.Would the state of database lock be RESERVED (presuming there is space in cache)? If trigger invokes an IPC that result in another process reading the INSERTED row, it should use the TRANSACTION IMMEDIATE. This way the later process would get SQLITE_BUSY until the first one commits the INSERT. Right? Similarly ON UPDATE and ON DELETE.. Thanks in advance, Mark _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
