Bernd Lehmkuhl wrote: > > I think that the 'OR REPLACE' clause refers to the primary key, which > hasn't necessarily to do with a unique index defined elsewhere. So if > you have a primary key set on id, that would be the result. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >
Hi, basing on http://www.sqlite.org/lang_insert.html this link I supposed that the OR clause was the same as ON CONFLICT... Isn't the CONFLICT raised when a violation of a UNIQUE INDEX occurs? I don't have other keys configured on the table, just the one I wrote above... -- View this message in context: http://old.nabble.com/Multi-column-unique-constraint-in-SQLite-tp32441748p32442052.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
