2016-05-09 16:18 GMT+02:00 Dominique Devienne <ddevienne at gmail.com>:
> On Mon, May 9, 2016 at 3:48 PM, Dominique Devienne <ddevienne at gmail.com> > wrote: > > On Mon, May 9, 2016 at 3:46 PM, Dominique Devienne <ddevienne at gmail.com> > wrote: > >> On Mon, May 9, 2016 at 3:21 PM, Cecil Westerhof <cldwesterhof at gmail.com> > wrote: > >>> [...] Is there a way to get this information? > >> > >> Just name your CHECK constraint, and use a recent version of SQLite. > --DD > > sqlite> create table tt (v check (v in (0, 1))); > sqlite> insert into tt values (2); > Error: CHECK constraint failed: tt > ?That does the trick. Thanks. ? > Note that w/o a *named* constraint, it seems to just show the table name. > And if you meant a programmatic way to know the failure is a check > constraint, there's > ?Nope, I just wanted to see which of the many checks went wrong. -- Cecil Westerhof
