Is it possible you did not have unique=True when you created the table and added that later? sqlite does not support alter table with changing of column attributes.
On Apr 15, 3:41 pm, Keith Edmunds <[email protected]> wrote: > On Thu, 15 Apr 2010 15:25:56 -0500, [email protected] said: > > > sqlite does not enforce types/length, or uniqueness. > > I understand about types/lengths, but the uniqueness part doesn't > match with what I'm seeing: > > $ sqlite3 /dev/shm/test.db > SQLite version 3.5.9 > Enter ".help" for instructions > sqlite> create table mytable(text unique); > sqlite> insert into mytable values("mystring"); > sqlite> insert into mytable values("mystring"); > SQL error: column text is not unique > sqlite> > > Keith -- To unsubscribe, reply using "remove me" as the subject.
