Re: pg_restore error Command was: CREATE OPERATOR ~> ( PROCEDURE = plv8x.json_eval_ls, - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_restore error Command was: CREATE OPERATOR ~> ( PROCEDURE = plv8x.json_eval_ls,
Date
Msg-id 69653.1530910299@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_restore error Command was: CREATE OPERATOR ~> ( PROCEDURE =plv8x.json_eval_ls,  (pavna <daryani.bhawna@gmail.com>)
List 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 by date:

Previous
From: "Campbell, Lance"
Date:
Subject: Partitioning tables
Next
From: "Jernigan, Kevin"
Date:
Subject: Re: Partitioning tables