| Subject: | Need ability to add indexes without foreign key constraints |
We're using DBIx in particular DBIx::Class::Schema to automagically
construct our SQL. We'd like to be able to add indexes to fields
generally, and in particular, be able to have foreign key references,
with indexes for performance, but without constraints.
For example we have
__PACKAGE__-->belongs_to(...., { "foo.id" => "self.foo_id"},
{ is_foreign_key_constraint => 0 } );
where 'foo_id' might be null, and/or rows in 'foo' might be deleted
WITHOUT removing rows in 'self'. I'd like to be able to add an option
like { do_index=> 1 } and get SQL code to make an index, without adding
the foreign key constraint which is causing problems when rows in
Any chance of this getting implemented?