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

From Stephan Szabo
Subject Re: BUG #2302: not a bug
Date
Msg-id 20060306132543.E10372@megazone.bigpanda.com
Whole thread Raw
In response to Re: BUG #2302: not a bug  (Reece Hart <reece@harts.net>)
List pgsql-bugs
On Mon, 6 Mar 2006, Reece Hart wrote:

> 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.

I think the problem being reported is the fact that the double quoted
identifier is itself double quoted in the error message, not the fact
that it gave an error in the first place. Presumably the error should be:
 Did not find any relation named "weatheR".

pgsql-bugs by date:

Previous
From: Reece Hart
Date:
Subject: Re: BUG #2302: not a bug
Next
From: "Massimo Fidanza"
Date:
Subject: BUG #2303: UPDATE from manual is incorrect