[Dbix-class] Views and tables without primary keys

Matt S Trout dbix-class at trout.me.uk
Sun Jul 20 01:49:46 BST 2008


On Sun, Jul 06, 2008 at 01:21:22PM +0100, IvorW wrote:
> I have an application that uses a view. The application uses
> DBIx::Class::Schema::Loader, and I get a warning about primary keys,
> every time I start the app. The application works fine. In fact I get
> the warning when I use a MySQL database, but not when I use sqlite.
> 
> I've traced it in the source code to DBIx::Class::Schema::Loader::Base,
> and I attach a patch which removes the warning. In theory, this warning
> might be serving some purpose if you had a genuine table that didn't
> have a primary key, but not for a view. This warning just gets in the way.

Then you should write a patch that turns the warning off -for- -views-.

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/



More information about the DBIx-Class mailing list