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

Jim Nasby <jnasby@enova.com> writes:
> decibel@decina.cashnetusa=# SELECT 'Moo'::regclass;
> ERROR:  relation "moo" does not exist at character 8

That's doing what it's supposed to.  Compare

regression=# select 'Moo'::regclass;
ERROR:  relation "moo" does not exist
LINE 1: select 'Moo'::regclass;              ^
regression=# select '"Moo"'::regclass;
ERROR:  relation "Moo" does not exist
LINE 1: select '"Moo"'::regclass;              ^

The regclass input converter applies the same case-folding rules as
the SQL parser does, ie, fold unless double-quoted.
        regards, tom lane