Re: pg_dump: WARNING: could not find operator

On Jul 12, 2023, at 2:26 AM, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
> To find out which operators are causing the trouble, you can run queries like
>
> SELECT * FROM pg_operator
> WHERE oprcom IN (2234078, 2234199)
> OR oprnegate IN (2234078, 2234199);
>
> and test everything that uses these broken operators particularly well.

OK, I found them in one of our databases. Based on the oprcode values, they seem to be related to an extension we have installed (pgsphere, in case anyone is curious). Probably from an old version of the extension, I'm guessing, as the current pgsphere passes all regression testing.

So how do I clean up these dangling operators? Is it as easy as the following?

DELETE FROM pg_operator
WHERE oprcom IN (2234078, 2234199)
OR oprnegate IN (2234078, 2234199);

Thanks,
Ed