Re: amvalidate(): cache lookup failed for operator class 123 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: amvalidate(): cache lookup failed for operator class 123
Date
Msg-id 1579224.1620930136@sss.pgh.pa.us
Whole thread Raw
In response to amvalidate(): cache lookup failed for operator class 123  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: amvalidate(): cache lookup failed for operator class 123
Re: amvalidate(): cache lookup failed for operator class 123
List pgsql-hackers
Justin Pryzby <pryzby@telsasoft.com> writes:
> Per sqlsmith.
> postgres=# select amvalidate(123);
> ERROR:  cache lookup failed for operator class 123
> postgres=# \errverbose
> ERROR:  XX000: cache lookup failed for operator class 123
> LOCATION:  amvalidate, amapi.c:125

> The usual expectation is that sql callable functions should return null rather
> than hitting elog().

Meh.  I'm not convinced that that position ought to apply to amvalidate.
Under what circumstances would you be calling that on an opclass that
might be about to be dropped?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: compute_query_id and pg_stat_statements
Next
From: Justin Pryzby
Date:
Subject: Re: amvalidate(): cache lookup failed for operator class 123