From: | Vadim Chekan <vchekan(at)rogers(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Casing: bug? |
Date: | 2003-10-26 10:43:58 |
Message-ID: | 200310261043.59013.vchekan@rogers.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick Welche | 2003-10-26 13:15:26 | Re: no records returned |
Previous Message | Martijn van Oosterhout | 2003-10-26 09:29:48 | Re: Slow performance with no apparent reason |