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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pavna <daryani(dot)bhawna(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_restore error Command was: CREATE OPERATOR ~> ( PROCEDURE = plv8x.json_eval_ls,
Date: 2018-07-06 20:51:39
Message-ID: 69653.1530910299@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

pavna <daryani(dot)bhawna(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jernigan, Kevin 2018-07-06 21:39:50 Re: Partitioning tables
Previous Message Campbell, Lance 2018-07-06 18:05:27 Partitioning tables