Thanks a lot for your explanations. I misread the doc...
I intuitively thought that INSERT OR REPLACE operates only on a "one input -> one affected record" ("or in place") logic (as exercised for the PK constraint) and that UNIQUE constraint had some higher priority against "replace" : a kind of "if not respected, do nothing" command not "if not respected, you can kill me"(*) (as done for the PK) -> so my expectation of an exception to be raised.
Regards. Jean-Marie Cuaz (*) "and eventualy others" for UNIQUE _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
