In theory you can set quoting on table and field names:
http://search.cpan.org/~ash/DBIx-Class-0.08010/lib/DBIx/Class/Manual/Cookbook.pod#Setting_quoting_for_the_generated_SQL.
In practice, though, that doesn't work 100% on DBs like Oracle and
it's hard to
spot all the reserved words so it may be easier on the sanity to use a table
prefix in your schema definition, like the following:
package Schema::User;
use base qw(DBIx::Class);
...
__PACKAGE__->table('az_user'); # reserved Oracle keyword 'user' is no good as
table name
then in caller:
my $rs = $self->schema->resultset('User')->find( 'foo' );
Regards, Peter
http://perl.dragonstaff.co.uk
Quoting Jesse Sheidlower <[EMAIL PROTECTED]>:
try aliasing the table to grp instead of group, my guess is that
group is a reserved word
Uh, yeah, that would be it.
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
