"Bharath Booshan L" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > IF INSERT OR REPLACE statement performs REPLACE operation, then again > insert_trigger is being invoked, which as per the documentation ( i.e > it > actually performs DELETE and INSERT) is fine. > > Am I wrong in expecting that INSERT OR REPLACE should trigger > update_trigger
Yes. Didn't you just explain why it doesn't happen? > when on the whole the operation performed is actually an UPDATE? Well, if I epxlicitly run DELETE and then INSERT, would you also expect an UPDATE trigger to run? After all, "on the whole" the operation is an update. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
