pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: pavna <daryani.bhawna@gmail.com>
To: pgsql-admin@postgresql.org
Subject: pg_restore error Command was: CREATE OPERATOR ~> (     PROCEDURE = plv8x.json_eval_ls,
Date: Thu, 5 Jul 2018 21:12:41 -0700 (MST)
Message-ID: <1530850361998-0.post@n3.nabble.com> (raw)

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




view thread (4+ messages)  latest in thread

Message-ID: <1530850361998-0.post@n3.nabble.com>
Permalink:  ../1530850361998-0.post@n3.nabble.com/
Also on:    postgresql.org/message-id/1530850361998-0.post@n3.nabble.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: daryani.bhawna@gmail.com
  Subject: Re: pg_restore error Command was: CREATE OPERATOR ~> (     PROCEDURE = plv8x.json_eval_ls,
  In-Reply-To: <1530850361998-0.post@n3.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox