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

Re: Cannot open table in new database

From: Phil Jackson <sapient(at)clear(dot)net(dot)nz>
To: adrian(dot)klaver(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cannot open table in new database
Date: 2010-07-01 19:11:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Hi Adrian

I had missed that bit. That makes sense now.


Phil Jackson
On 6/30/2010 5:04 PM, Adrian Klaver wrote:
> On Thursday 01 July 2010 11:11:29 am Phil Jackson wrote:
>> Hi Adrian
>> 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.
>> I'll carry on and see what happens next.
>> Cheers
>> Phil Jackson
> You need to go to bottom of that section where you would find :)
> "Quoting an identifier also makes it case-sensitive, whereas unquoted names are
> always folded to lower case. For example, the identifiers FOO, foo, and "foo"
> are considered the same by PostgreSQL, but "Foo"  and "FOO" are different from
> these three and each other. (The folding of unquoted names to lower case in
> PostgreSQL is incompatible with the SQL standard, which says that unquoted
> names should be folded to upper case. Thus, foo should be equivalent to "FOO"
> not "foo" according to the standard. If you want to write portable applications
> you are advised to always quote a particular name or never quote it.) "

In response to

pgsql-general by date

Next:From: Peter GeogheganDate: 2010-07-01 20:44:24
Subject: Re: problems with encoding and accent letters
Previous:From: Thomas MarkusDate: 2010-07-01 18:26:14
Subject: Re: Uncable to commit: transaction marked for rollback

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