Ivan Shmakov wrote:
> I wonder if I'm on safe side when I use, say:
>
> INSERT OR IGNORE INTO "foo" ("foo")
> VALUES (?1);
>
> I mean, if the first INSERT fails for the reason other than the
> UNIQUE constraint set
<http://sqlite.org/lang_conflict.html> says:
| The ON CONFLICT clause applies to UNIQUE and NOT NULL constraints (and
| to PRIMARY KEY constraints which for the purposes of this section are
| the same thing as UNIQUE constraints). The ON CONFLICT algorithm does
| not apply to FOREIGN KEY constraints.
If it fails for any other reason, you get a normal error.
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
