Re: pg_restore error Command was: CREATE OPERATOR ~> ( PROCEDURE = plv8x.json_eval_ls,

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_restore error Command was: CREATE OPERATOR ~> ( PROCEDURE = plv8x.json_eval_ls,
Дата
Msg-id 69653.1530910299@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_restore error Command was: CREATE OPERATOR ~> ( PROCEDURE =plv8x.json_eval_ls,  (pavna <daryani.bhawna@gmail.com>)
Список pgsql-admin
pavna <daryani.bhawna@gmail.com> writes:
> Thanks Tom for your response! Is there a way to examine the backup to find
> what was missing?  

Well, it's whatever was the commutator for that operator.  Evidently it
got dropped somewhere along the way.

It's a bit curious that you have this situation, though.  AFAICS,
dropping an operator should result in clearing the oprcom link from
its commutator sibling.  Perhaps there's some sequence of operations
that that logic fails to handle?  It'd be interesting if you can show
a way to reproduce this case.

            regards, tom lane


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

Предыдущее
От: "Campbell, Lance"
Дата:
Сообщение: Partitioning tables
Следующее
От: "Jernigan, Kevin"
Дата:
Сообщение: Re: Partitioning tables