c# - SQLite conflict resolution not working -

c# - SQLite conflict resolution not working -

i have sqlite database containing 3 tables.

i trying insert row 1 of them primary key exists. primary key of type integer.

this statement should fail because of constraint violation. in c# programme not failing, not inserting either. it's working if started statement insert or ignore. if utilize insert or fail explicitly still not work. happens when opening database sqlite manager firefox plugin. if open database in sqliteman query fails it's supposed to.

is there pragma or may have missed?

edit: here table definition:

create table block(offset integer primary key,length integer,originaloffset integer,originallength integer,page integer) create unique index block_original_offset_index on block(originaloffset,offset,length)

c# sqlite