[Dbix-class] Quoting and separation of (wierd) names
Matt S Trout
dbix-class at trout.me.uk
Tue May 16 00:57:47 CEST 2006
Stephan Szabo wrote:
> The "ENUM values..." thread got off onto discussion of names and case
> sensitivity and the like. Since mst asked me to ask my question about
> period containing names in a new thread, here it is.
>
> Is there any way to reference the column in a table definition like this?
> create table "Test" (
> "This.That" varchar(5)
> );
>
> I think the correct reference for something where we're giving a table
> correlation name would look something like:
> select "me"."This.That" from "Test" me;
>
> I don't know if any combination of current arguments will allow that apart
> from forcing quoting off and actually making the quotes part of the names
> (which would probably then foul up things like column_info).
>
> With only quote_char it sounds like we can get references like
> "me.This.That" and with quote_char and name_sep it looks like we'd get
> "me"."This"."That" (which fails on pg and is supposed to fail on sql
> compatible dbs I think).
You're absolutely right. And to be entirely honest, I have no idea
whatsoever what we could do that would make this work.
Anybody? Bueller?
More information about the Dbix-class
mailing list