Dmitri Bichko wrote:
> Hi,
>
> Would it be possible to have DBIx::Class always quote all table
> identifiers to avoid namespace conflicts?
>
> For example, here's the SQL generated for a many-to-many relationship I
> have:
>
> SELECT group.group_id, group.type, group.name, group.description FROM
> categories me JOIN groups group ON ( group.group_id = me.group_id )
> WHERE ( me.sample_id = 58471)
>
> Since group is a database keyword, Postgres doesn't like it. Easy to
> work around in this case, but is there a reason NOT to add the quotes?
> I guess another way to do it would be to add a DBIC-specific prefix to
> the autogenerated table aliases.
Quoting is supported but turned off by default (it's a bit of a performance
hit during the SQL generation).
$schema->storage->sql_maker->quote_char("`");
$schema->storage->sql_maker->name_sep(".");
should do the trick for you,
> PS Just wanted to say Thank You for DBIC - after years of headaches with
> Class::DBI, it's just a pleasure to work with.
That was the object of the exercise. Thanks :)
--
Matt S Trout Offering custom development, consultancy and support
Technical Director contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd. mst (at) shadowcatsystems.co.uk for more information
+ Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
