Re: [sqlite] UPDATE TRIGGER not called on INSERT OR REPLACE statement

> 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. Oh!! May be I was wrong in thinking that INSERT OR REPLACE would keep the PRIMARY KEY as it is.. Am a stupid guy.. Thanks Igor for your

Re: [sqlite] UPDATE TRIGGER not called on INSERT OR REPLACE statement

"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

[sqlite] UPDATE TRIGGER not called on INSERT OR REPLACE statement

Hello Sqlite users, experts, I am in a state of confusion and I request you to help me out please. Can "INSERT OR REPLACE" trigger if actual operation performed is REPLACE? Say , For example, if I have 2 triggers on table T1, one trigger, say insert_trigger, is set to trigger after INSERT,