Relations between operators from pg_amop and classes of operators from pg_opclass

Поиск
Список
Период
Сортировка
От Anna Rodionova
Тема Relations between operators from pg_amop and classes of operators from pg_opclass
Дата
Msg-id CAHMBQ-jaL7jCrxwKNy-nqbGbiZw3yWH9PNy2zM6uGEFQEWYifg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Relations between operators from pg_amop and classes of operators from pg_opclass  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Lucas
Дата:
Сообщение: Re: PostgreSQL 9.2 high replication lag - Part 2
Следующее
От: Assaf Gordon
Дата:
Сообщение: Re: connecting multiple INSERT CTEs to same record?