Re: BUG #2302: not a bug

From: Reece Hart <reece(at)harts(dot)net>
To: Alexander Pivovarov <apivovarov(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2302: not a bug
Date: 2006-03-06 21:21:16
Message-ID: 1141680076.1083.22.camel@tallac.gene.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2006-03-06 21:28:02 Re: BUG #2302: not a bug
Previous Message Bruce Momjian 2006-03-06 15:20:20 Re: FATAL: semctl(1672698088, 12, SETVAL, 0) failed