Re: [CDBI] Re: postgres and case sensitive table names
Carlos Vicente <cvicente-zZ82ZiX1S8l+u43qRgrggVnYRNhDb3e+9nwVQlTi/[email protected]> Thu, 28 Jun 2007 12:09:05 -0700
| Newsgroups | gmane.comp.lang.perl.modules.class-dbi |
|---|---|
| Message-ID | <[email protected]> |
>> Try a variation of the following:
>>
>> __PACKAGE__->table('"YourMixedCaseTableName"');
>>
>> Hope this helps,
>> Ed
>>
>>
>
>
> That seems to do the trick. Thank you!
>
> cv
>
Well, I was too quick. It actually it complains:
Can't insert new Zone: DBD::Pg::db last_insert_id failed: Could not find
the table ""Zone"" [for Statement "SELECT c.oid FROM pg_catalog.pg_class c
WHERE relname = ?"] at /usr/local/share/perl/5.8.8/Class/DBI.pm line 609.
although I see the records being inserted with incremental id's.
?
cv