Re: [CDBI] column case sensitivity (Pg)
Matt S Trout <dbix-class-uY5y5/[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.class-dbi |
|---|---|
| Message-ID | <[email protected]> |
Erik Sluiters wrote:
> Hi all,
> The postgres database i work on unfortunatly makes use of case sensitive
> column names. It was a wrong database design decision (not by me thankfully),
> i wish i could just change column names but it just breaks too much in the
> interface to do.
> I'm really impressed by the functionality of ClassDBI but unfortunatly
> ClassDBI doesn't work with column names with uppercases in it. I took a peek
> at the ClassDBI code and found that it is quite trivial to make it work with
> case sensitive column names, basically i just removed all conversions to
> lowercase.
> I've listed the changes below, unless there is a good reason to have ClassDBI
> only work with lowercase column names maybe this could be incorporated in the
> main branch of ClassDBI? That way anyone can have a lousily designed database
> and still use ClassDBI...
That wouldn't be backwards compatible.
You'd probably be better switching to DBIx::Class, which already supports this.
--
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/ +