Re: Table whose name has Capital letters

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Table whose name has Capital letters
Дата
Msg-id 659.975170806@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Table whose name has Capital letters  (Jeff Davis <jdavis@wasabimg.com>)
Список pgsql-general
Jeff Davis <jdavis@wasabimg.com> writes:
> The way it is supposed to work, everything should be
> case-insensitive. It should not matter whether you ask for nov2000 or
> Nov2000, it should be the same table, and should give you an error if
> you try to make both tables.

I am betting that he initially did CREATE TABLE "Nov2000", and is now
trying to access the table without using double quotes around its name.
Which won't work...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Sql-bench
Следующее
От: "Joel Burton"
Дата:
Сообщение: Warning: Don't delete those /tmp/.PGSQL.* files