Re: ERROR: cache lookup failed for function 0 - Mailing list pgsql-bugs

"David E. Wheeler" <david@kineticode.com> writes:
> I ran into this error on 8.2 a while ago, and just figured out what
> was causing it. Here's a quick example on 8.2:

Seems to be fixed in HEAD:

regression=# SELECT '{foo}'::name[] <> '{bar}'::name[];
ERROR:  operator is only a shell: name[] <> name[]
LINE 1: SELECT '{foo}'::name[] <> '{bar}'::name[];
                               ^

            regards, tom lane