Re: Cannot open table in new database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Cannot open table in new database
Дата
Msg-id 20590.1277943147@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Cannot open table in new database  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
Adrian Klaver <adrian.klaver@gmail.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: left outer join fails because "column .. does not exist in left table?"
Следующее
От: Phil Jackson
Дата:
Сообщение: Re: Cannot open table in new database