[BUGS] Can't read oprcode from remote pg_operator

Поиск
Список
Период
Сортировка
От Thom Brown
Тема [BUGS] Can't read oprcode from remote pg_operator
Дата
Msg-id CAA-aLv4y3ixwu2znpa6dNHbf7zNbwa9DGnQiWsLusN7remySRw@mail.gmail.com
обсуждение исходный текст
Ответы Re: [BUGS] Can't read oprcode from remote pg_operator  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
It seems that, if you have a foreign table pointing to pg_operator in
another cluster, you cannot return the oprcode column for certain
rows.  I'm getting this on 10 beta 3.

I have imported pg_operator using IMPORT FOREIGN SCHEMA, and I get the
following errors:

# SELECT * FROM pg.pg_operator ORDER BY oprname DESC, oprleft,
oprright LIMIT 701;
ERROR:  more than one function named "pg_catalog.tsquery_phrase"
CONTEXT:  column "oprcode" of foreign table "pg_operator"


# SELECT * FROM pg.pg_operator ORDER BY oprname, oprleft, oprright LIMIT 701;
ERROR:  more than one function named "pg_catalog.jsonb_delete"
CONTEXT:  column "oprcode" of foreign table "pg_operator"

This seems like a bug, although I suspect this may be explainable as
expected and wanted behaviour.

Regards

Thom


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [BUGS] pg_dump and pg_restore on inherited tables problem
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: [BUGS] BUG #14788: `pg_restore -c` won't restore schema access privileges.