Hi,

Current version of DBIC::Schema::Loader::DBI::SQLite search UNIQUE
constraint case sesitive without 'i' option in regex.
which means,

create table users (
  username text not null UNIQUE,
  ...

is ok, add_unique_constraint works automatically.

however,

create table users (
  username text not null unique,
  ...

doesn't work.

Is there any reason?  
I'm just curious, because other constraint (ex. FOREIGN) is not case
sensitive.

hide



_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/

Reply via email to