Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> writes:
> On Thursday 01 July 2010 11:11:29 am Phil Jackson wrote:
>> The link says that;
>> "Identifier and key word names are case insensitive."
>> But I have renamed the source table in lowercase and this gets me one
>> step further.
> You need to go to bottom of that section where you would find :)
> ... If you want to write portable applications
> you are advised to always quote a particular name or never quote it.) "
In particular, what probably bit you here is that you created the tables
using a tool that double-quoted the mixed-case names. Once you've done
that, you are condemned to always double-quote those names forevermore.
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Scott Marlowe||Date: 2010-07-01 00:16:29|
|Subject: Re: left outer join fails because "column .. does not exist in left table?"|
|Previous:||From: Tom Lane||Date: 2010-07-01 00:05:13|
|Subject: Re: left outer join fails because "column .. does not exist in left table?" |