On 17 Mar 2017, at 7:49am, Dominique Devienne <ddevie...@gmail.com> wrote:
> Richard, why is SQLite ignoring an attempt to giving these an explicit > name? —DD > > […] > > sqlite> create table t (id constraint u1 unique); You are supplying a name for the constraint. But you’re still leaving it up to SQLite to create the index it will need. So SQLite gets to choose the name for the index. If you want to supply the name yourself you have to define the index yourself. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
