| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Reece Hart <reece(at)harts(dot)net> |
| Cc: | Alexander Pivovarov <apivovarov(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #2302: not a bug |
| Date: | 2006-03-06 21:28:02 |
| Message-ID: | 20060306132543.E10372@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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".
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Pivovarov | 2006-03-07 11:49:41 | BUG #2304: Time zone bug: '05:04 GMT+3' processing as '05:04:00 -03' |
| Previous Message | Reece Hart | 2006-03-06 21:21:16 | Re: BUG #2302: not a bug |