On Mon, 2015-02-23 at 14:01 +0400, Jan Eskilsson wrote:
Is there a way to make DBIx automatically quote table and field names
in the generated SQL ?
Yes, with the quote_names option:
https://metacpan.org/pod/DBIx::Class::Storage::DBI#quote_names
Regards,
Andy
Hi Andrew
Super thanks, excatly what i needed, saved my day !
Best Regards
Jan Eskilsson
2015-02-23 14:11 GMT+04:00 Andrew Beverley a...@andybev.com:
On Mon, 2015-02-23 at 14:01 +0400, Jan Eskilsson wrote:
Is there a way to make DBIx automatically quote table and field names
in the
Hi All
I'm in a situation where i need to connect to a legacy PostgreSQL database
where field and table names are written in Camel Case hence in Postgres
they need to be quoted. Is there a way to make DBIx automatically quote
table and field names in the generated SQL ?
For example
SELECT City
Random guess, DBIx::Class is working around a database limitation.
For example see
http://search.cpan.org/~ribasushi/DBIx-Class-0.082810/lib/DBIx/Class/Storage/DBI/Oracle/Generic.pm#relname_to_table_alias
for how your situation could have happened.
On Mon, Feb 23, 2015 at 4:36 PM, Greg Coates
One note: The ' at ' in the table name should have been an actual at sign.
Greg
On 2/23/2015 4:36 PM, Greg Coates wrote:
Is there code somewhere in DBIx::Class that limits the length of a
table name?
I have a schema package with the following table name:
Is there code somewhere in DBIx::Class that limits the length of a table
name?
I have a schema package with the following table name:
__PACKAGE__-table('RDSPRD.REC_CLASS_MTG_INSTRUCTOR_DTL@FRONT1');
When I try to access data from this table, I get an error saying the
table does not exist,
That looks to be what is happening. Is there any way to turn this
behavior off? This is a legitimate table name with a dblink and schema
appended. It works in a direct query.
Thanks,
Greg
On 2/23/2015 4:49 PM, Ben Tilly wrote:
Random guess, DBIx::Class is working around a database
On 02/24/2015 01:36 AM, Greg Coates wrote:
Is there code somewhere in DBIx::Class that limits the length of a table
name?
I have a schema package with the following table name:
__PACKAGE__-table('RDSPRD.REC_CLASS_MTG_INSTRUCTOR_DTL@FRONT1');
Please try with: