Re: pg_dump: WARNING: could not find operator

On Tue, 2023-07-11 at 18:30 -0400, Ed Sabol wrote:
> On Jul 11, 2023, at 6:24 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > While you could clean it up manually, pg_dump
> > is just going to omit those clauses from its output, so there's no
> > real need to do anything if that outcome is sufficient.
>
> I'm mainly concerned about the pg_upgrade going smoothly. I'd like to minimize
> downtime as much as possible. I was planning to use "pg_upgrade --link", if it matters.

Then you should test the upgrade first.

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.

Yours,
Laurenz Albe