Casing: bug?
От | Vadim Chekan |
---|---|
Тема | Casing: bug? |
Дата | |
Msg-id | 200310261043.59013.vchekan@rogers.com обсуждение исходный текст |
Ответы |
Re: Casing: bug?
Re: Casing: bug? |
Список | pgsql-general |
Hello there, I have quite problem with PG 7.3 & 7.4b5 I create tables using pgAdmin3 v-1.0.1 I created a table "xType". Pay attention to capital "T" letter. Than I tryed to insert data to it using psql tool. But I have error: 'ERROR: relation "xtype" does not exist' In error all chars are small! If I create table in pgAdmin using all small chars, everithing works fine. Note: when I create table with a capital chars from psql, it is created with small chars. Ok, as I write this mail I found ansver to my question: I have to wrap table names in quote chars to avoid downcasing. I have to write: select * from "xType"; than it works. So now question is: why "select * from xTypes" is a wrong query, why table name is downcasing if it is not wrapped in quote? Is it a bug, or it's according to some standard? Doesn't it violate documentation: ========================== Identifier and key word names are case insensitive. Therefore UPDATE MY_TABLE SET A = 5; can equivalently be written as uPDaTE my_TabLE SeT a = 5; ========================== Thanks, Vadim Chekan.
В списке pgsql-general по дате отправления: