Skip site navigation (1) Skip section navigation (2)

Re: Cannot open table in new database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: adrian(dot)klaver(at)gmail(dot)com
Cc: sapient(at)clear(dot)net(dot)nz, pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot open table in new database
Date: 2010-07-01 00:12:27
Message-ID: 20590.1277943147@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
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 MarloweDate: 2010-07-01 00:16:29
Subject: Re: left outer join fails because "column .. does not exist in left table?"
Previous:From: Tom LaneDate: 2010-07-01 00:05:13
Subject: Re: left outer join fails because "column .. does not exist in left table?"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group