Re: regclass error reports improperly downcased - Mailing list pgsql-hackers

From Greg Stark
Subject Re: regclass error reports improperly downcased
Date
Msg-id CAM-w4HOQyq0Pcgb97FGw=NmDtHx2ohonLiG0Xuga5MnoHRXE+Q@mail.gmail.com
Whole thread
In response to regclass error reports improperly downcased  (Jim Nasby <jnasby@enova.com>)
List pgsql-hackers

On Fri, Nov 8, 2013 at 12:29 AM, Jim Nasby <jnasby@enova.com> wrote:
decibel@decina.cashnetusa=# SELECT 'Moo'::regclass;
ERROR:  relation "moo" does not exist at character 8

Obviously in this example it doesn't matter, but this can definitely confuse users.

I would actually say *not* downcasing would be more likely to confuse users. It's actually looking for a relation named "moo". If they actually had one named "Moo" and it said "relation "Moo" does not exist" that would be even more confusing and less likely to result in them figuring out what they've done wrong.


--
greg

pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: regclass error reports improperly downcased
Next
From: Tom Lane
Date:
Subject: Re: regclass error reports improperly downcased