Re: [sqlite] INSERT OR REPLACE in trigger body fails with UNIQUE constraint

Mike _ wrote: > The trigger documentation says: "An ON CONFLICT clause may be specified as > part of an UPDATE or INSERT action within the body of the trigger. However > if an ON CONFLICT clause is specified as part of the statement causing the > trigger to fire, then conflict handling policy of

[sqlite] INSERT OR REPLACE in trigger body fails with UNIQUE constraint

Hello mailing list, happy new year! I was wondering if anyone can help explain why this is an error: --- sqlite> pragma foreign_keys = on; sqlite> drop table if exists child; sqlite> drop table if exists parent; sqlite> drop table if exists changelog; sqlite> create table parent ( ...>