Relations between operators from pg_amop and classes of operators from pg_opclass - Mailing list pgsql-general

From Anna Rodionova
Subject Relations between operators from pg_amop and classes of operators from pg_opclass
Date
Msg-id CAHMBQ-jaL7jCrxwKNy-nqbGbiZw3yWH9PNy2zM6uGEFQEWYifg@mail.gmail.com
Whole thread Raw
Responses Re: Relations between operators from pg_amop and classes of operators from pg_opclass
List pgsql-general

Hi!

For each operator from system catalog pg_amop I need to know - a member of which class of operators from system catalog pg_opclass it is (in case if such class of operators exists).


In PostgreSQL versions before v14.0 I was able to get this information from system catalog pg_depend.

In case of existing relation between operator and class of operators - in pg_depend was row, in which objid was equal to the oid of this operator and refobjid was equal to oid of its class of operators.


However in PostgreSQL v14.0 it changed. Now in such rows values of refobjid are equal to values of oid of family of operators (instead of class of operators).


How can I find relations between operators from pg_amop and classes of operators from pg_opclass in v14.0?


Best regards,

Anna Rodionova

pgsql-general by date:

Previous
From: Lucas
Date:
Subject: Re: PostgreSQL 9.2 high replication lag - Part 2
Next
From: Assaf Gordon
Date:
Subject: Re: connecting multiple INSERT CTEs to same record?