Jim Nasby <jnasby(at)enova(dot)com> writes:
> decibel(at)decina(dot)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