Re: BUG #2302: not a bug - Mailing list pgsql-bugs

From Reece Hart
Subject Re: BUG #2302: not a bug
Date
Msg-id 1141680076.1083.22.camel@tallac.gene.com
Whole thread Raw
In response to BUG #2302: \d command gets double quoted table name in error message - ""table_name""  ("Alexander Pivovarov" <apivovarov@gmail.com>)
Responses Re: BUG #2302: not a bug  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
On Mon, 2006-03-06 at 11:03 +0000, Alexander Pivovarov wrote:
> e.g. I have a table "weather".
> when I run:
> mydb=# \d "weatheR"
> Did not find any relation named ""weatheR"".
>
> weatheR is double quoted by "" in error message

This is not a bug.  Quoting always makes identifiers case-sensitive, per
the SQL standard.

Read section 4.1.1:
http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS

--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: FATAL: semctl(1672698088, 12, SETVAL, 0) failed
Next
From: Stephan Szabo
Date:
Subject: Re: BUG #2302: not a bug