From: | Reece Hart <reece(at)harts(dot)net> |
---|---|
To: | Ron Teitelbaum <ron(at)usmedrec(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #2764: Capital letter in tables or columns not |
Date: | 2006-11-21 03:47:33 |
Message-ID: | 1164080853.4011.10.camel@snafu.site |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Fri, 2006-11-17 at 19:40 +0000, Ron Teitelbaum wrote:
> Description: Capital letter in tables or columns not supported
Unquoted identifiers are always smashed down to lowercase. Quoted
identifiers are taken verbatim, including case.
This is not a bug: it's documented in
http://www.postgresql.org/docs/8.1/interactive/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS . Oracle has the same behavior, but uppercase unquoted identfiers. I seem to recall reading that the SQL spec requires that identifiers be treated as one or the other, but doesn't say which (upper or lower).
rkh(at)csb-dev=> create temp table test (lccol text, Uccol text, ALLUCCOL
text, "lccol_q" text, "Uccol_q" text, "ALLUCCOL_q" text);
CREATE TABLE
Time: 233.815 ms
rkh(at)csb-dev=> \d test
Table "pg_temp_1.test"
Column | Type | Modifiers
------------+------+-----------
lccol | text |
uccol | text |
alluccol | text |
lccol_q | text |
Uccol_q | text |
ALLUCCOL_q | text |
-rEecE (take your pick on case)
--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
./universe -G 6.672e-11 -e 1.602e-19 -protonmass 1.673e-27 -uspres bush
kernel warning: universe consuming too many resources. Killing.
universe received SIGKILL due to catastrophic leadership. Try -uspres carter.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-11-21 03:50:05 | Re: BUG #2759: \df doesn't show functions with no args |
Previous Message | Euler Taveira de Oliveira | 2006-11-21 02:28:46 | Re: BUG #2771: NULL values in FOREIGN KEY fields |