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

From: pavna <daryani(dot)bhawna(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_restore error Command was: CREATE OPERATOR ~> ( PROCEDURE = plv8x.json_eval_ls,
Date: 2018-07-06 04:12:41
Message-ID: 1530850361998-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

When I pg_restore I get errors.
Postgres version : PostgreSQL 9.4.0 on x86_64-unknown-linux-gnu, compiled
by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit
plv8.version : 1.5.0-dev1

pg_restore: processing item 2532 OPERATOR |
pg_restore: creating OPERATOR |
pg_restore: processing item 2533 OPERATOR |
pg_restore: creating OPERATOR |
pg_restore: processing item 2536 OPERATOR |>
pg_restore: creating OPERATOR |>
pg_restore: processing item 2537 OPERATOR |>
pg_restore: creating OPERATOR |>
pg_restore: [archiver (db)] Error from TOC entry 2537; 2617 27562 OPERATOR
|> employeeDB
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
...
pg_restore: processing item 2534 OPERATOR ~
pg_restore: creating OPERATOR ~
pg_restore: processing item 2540 OPERATOR ~>
pg_restore: creating OPERATOR ~>
pg_restore: [archiver (db)] Error from TOC entry 2540; 2617 27566 OPERATOR
~> employeeDB
pg_restore: [archiver (db)] could not execute query: ERROR: argument of
commutator must be a name
Command was: CREATE OPERATOR ~> (
PROCEDURE = plv8x.json_eval_ls,
LEFTARG = plv8x.json,
RIGHTARG = text,
COMMUTATOR = 275...
pg_restore: processing item 2535 OPERATOR ~~
pg_restore: creating OPERATOR ~~
pg_restore: processing item 2670 OPERATOR CLASS gist__int_ops
pg_restore: creating OPERATOR CLASS gist__int_ops
pg_restore: processing item 347 TABLE account_setting
pg_restore: creating TABLE account_setting
pg_restore: processing item 348 SEQUENCE account_setting_id_seq
pg_restore: creating SEQUENCE account_setting_id_seq
pg_restore: processing item 4780 SEQUENCE OWNED BY account_setting_id_seq
pg_restore: creating SEQUENCE OWNED BY account_setting_id_seq

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Anjul Tyagi 2018-07-06 07:11:28 logical Replication
Previous Message Cheng Zhou 2018-07-05 17:00:30 Failback and resume replication