[Dbix-class] DBIx::Class::Schema->deploy and DB views.

[kevin montuori]

hi all -- i have a couple questions about using DBIC::Schema->deploy
and views:

first, i'be been defining views in the schema just like i would any
other table then adding a $sqlt_schema->drop_table("view name") to the
sqlt_deploy_hook().  is this ok or is there a best practice here that
i'm ignoring?

second, if i define a relationship between a real table and a view a
foreign key constraint is created when i run deploy().  this isn't
unexpected but it is problematic.  i'm sure there's mention in the
documentation about how to supress the generation of constraints but i
don't seem to be able to find it.  can someone point me in the right
direction?

thanks for any help.

cheers!
k.

-- 
kevin montuori
montuori at gmail.com