That makes sense. I've checked your change.
Thanks for the help.
Ben
On Sat, 2008-04-26 at 14:17 +0200, Daniel Böhringer wrote:
> i know of no reserved meaning of uc names. however, postgres turns
> unquoted column names to lowercase before executing SQL.
> errors like "no such column xxx" result, when you omit the quotes in
> SQL statements refering e.g. to xXx.
> in general, it is thus wise to refrain from using uc names in columns.
> If there only were not these legacy DBs...
>
> thanks and kind regards,
>
> daniel
>
> Am 25.04.2008 um 23:14 schrieb Ben Faga:
>
> > Thanks for the letting us know about this. It seems like a reasonable
> > suggestion since double quotes are a valid way to refer to column
> > names.
> >
> > I'll probably make the change to the svn repository later tonight.
> >
> > I'm curious though, why are quotes needed for uppercase columns? Is
> > there some sort of reserved meaning for uc names?
> >
> > Ben
> >
> >
> > On Fri, 2008-04-25 at 10:32 +0200, Daniel Böhringer wrote:
> >> Dear list,
> >>
> >> in order to support uppercase foreign key target-columns
> >>
> >> line 608 has to be changed from
> >>
> >>
> >> parens_word_list : '(' WORD(s /,/) ')'
> >> to
> >>
> >>
> >> parens_word_list : '(' name_with_opt_quotes(s /,/) ')'
> >>
> >>
> >> thanks and kind regards,
> >>
> >> daniel boehringer
> >>
> >>
> >> -------------------------------------------------------------------------
> >> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> >> Don't miss this year's exciting event. There's still time to save
> >> $100.
> >> Use priority code J8TL2D2.
> >> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> >
>
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
--
sqlfairy-developers mailing list
sqlfairy-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
