in reply to Re^4: Rose::DB and DBIx
in thread Rose::DB and DBIx

Can Rose::DB use a primary key that spans multiple columns? Also, does anyone know if of a support matrix comparing supported features of roseDB with DBIC and CDBI?

Replies are listed 'Best First'.
Re^6: Rose::DB and DBIx
by Anonymous Monk on Apr 08, 2008 at 17:26 UTC
    Well, I found the answer to the first part of my question tucked away in the tutorial:
    The table must have a primary key, and may have zero or more unique keys. The primary key and each unique key may contain multiple columns.

    Also, if you are desparate there is even a workaround for not having a primary key:
    If the table has a multi-column primary key or does not use a column type that supports auto-generated values, you can define a custom primary key generator function using the primary_key_generator method of the Rose::DB::Object::Metadata-derived object that contains the metadata for this class.