Hello, On Mon, Mar 12, 2012 at 11:52 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 12 Mar 2012, at 10:11pm, Alex Queiroz <asand...@gmail.com> wrote: > >> - If I try to reindex the table, it fails; >> - If I drop the index and try to add it again, it fails. > > For both the above ... > > What command are you issuing, and what result are you getting from SQLite > when it fails ? (i.e. what is it doing instead of working ?) >
sqlite> reindex 'user_identity'; Error: indexed columns are not unique sqlite> drop index userIdentityByUcgID; sqlite> CREATE UNIQUE INDEX IF NOT EXISTS 'userIdentityByUcgID' ON 'user_identity' (shortName ASC, ucgID ASC); Error: indexed columns are not unique Cheers, -- -alex http://www.artisancoder.com/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users