Re: Error message: cannot identify operator 184 - Mailing list pgsql-admin

From Tom Lane
Subject Re: Error message: cannot identify operator 184
Date
Msg-id 7788.1121404707@sss.pgh.pa.us
Whole thread Raw
In response to Re: Error message: cannot identify operator 184  (Michael Fuhr <mike@fuhr.org>)
List pgsql-admin
Michael Fuhr <mike@fuhr.org> writes:
> I'm wondering if the error means you're missing that function, which
> is used to compare oid values.

A system without oideq would be so dead in the water it's not funny ---
consider that all the major catalogs are indexed by oid.  It sounds to
me that one particular index's "strategy map" (ie, its in-memory copy
of the relevant indexable-operator info) got trashed.  It's hard to
guess why though.  Could have been a hardware problem (RAM dropped a
bit) or a software problem (wild store that happened to trash this data
structure rather than anything else).

            regards, tom lane

pgsql-admin by date:

Previous
From: Ezequiel Tolnay
Date:
Subject: Re: functions vs stored procedures
Next
From: Alvaro Herrera
Date:
Subject: Re: functions vs stored procedures