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

From Justin Pryzby
Subject Re: amvalidate(): cache lookup failed for operator class 123
Date
Msg-id 20210513182817.GI27406@telsasoft.com
Whole thread Raw
In response to Re: amvalidate(): cache lookup failed for operator class 123  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, May 13, 2021 at 02:22:16PM -0400, Tom Lane wrote:
> 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?

Sure, no problem.  I'm just passing on the message :)

-- 
Justin



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: amvalidate(): cache lookup failed for operator class 123
Next
From: Tom Lane
Date:
Subject: Re: compute_query_id and pg_stat_statements