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 16:20:11
Message-ID: 69178.1530894011@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:
> When I pg_restore I get errors.

> pg_restore: [archiver (db)] could not execute query: ERROR: argument of
> commutator must be a name
> Command was: CREATE OPERATOR |> (
> PROCEDURE = plv8x.json_eval,
> LEFTARG = plv8x.json,
> RIGHTARG = text,
> COMMUTATOR = 27561
> ...

Seems like there's something broken in your source database, ie that
operator has a commutator link that didn't point to an existing operator.
Hard to say any more than that with no more information.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message pavna 2018-07-06 17:08:10 Re: pg_restore error Command was: CREATE OPERATOR ~> ( PROCEDURE = plv8x.json_eval_ls,
Previous Message Shreeyansh Dba 2018-07-06 15:32:33 Re: logical Replication