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 69178.1530894011@sss.pgh.pa.us
Whole thread Raw
In response to pg_restore error Command was: CREATE OPERATOR ~> ( PROCEDURE =plv8x.json_eval_ls,  (pavna <daryani.bhawna@gmail.com>)
Responses Re: pg_restore error Command was: CREATE OPERATOR ~> ( PROCEDURE =plv8x.json_eval_ls,
List pgsql-admin
pavna <daryani.bhawna@gmail.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


pgsql-admin by date:

Previous
From: Shreeyansh Dba
Date:
Subject: Re: logical Replication
Next
From: pavna
Date:
Subject: Re: pg_restore error Command was: CREATE OPERATOR ~> ( PROCEDURE =plv8x.json_eval_ls,