BUG #16019: error pg_restore from pg_dump(windows8.1-pgadmin 4.12)

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: drd1(at)list(dot)ru
Subject: BUG #16019: error pg_restore from pg_dump(windows8.1-pgadmin 4.12)
Date: 2019-09-24 09:29:28
Message-ID: 16019-e587cdb1ee670c25@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16019
Logged by: Damian Damirof
Email address: drd1(at)list(dot)ru
PostgreSQL version: 9.6.2
Operating system: Centos 7 Windows 8.1
Description:

Then Make backup database from Pgadmin version 4.12(OS Windows 8.1)
,PostgreSQL 9.6.2 (OS Centos 7) . pg_restore(OS Windows 8.1 with PGAdmin)
with error CREATE OPERATOR
make backup database from pg_dump(centos 7) and pg_restore(centos 7) is
OK.
This is ERROR pg_dump(Windows 8.1-Pgadmin 4.12) pg_restore(Windows
8.1-Pgadmin 4.12)
190923072510779341,pg_restore: creating OPERATOR "public.>"

190923072510780341,pg_restore: ПРЕДУПРЕЖДЕНИЕ: атрибут оператора "function"
не распознан

190923072510780341,pg_restore: [archiver (db)] Error while PROCESSING TOC:

190923072510780341,pg_restore: [archiver (db)] Error from TOC entry 11708;
2617 118942406 OPERATOR > postgres

190923072510780341,pg_restore: [archiver (db)] could not execute query:
ОШИБКА: должна быть указана процедура оператора

190923072510780341, Command was: CREATE OPERATOR "public".> (

190923072510780341, FUNCTION = "public"."mchar_icase_gt",

190923072510780341, LEFTARG = "public"."mchar",

190923072510780341, RIGHTARG = "public"."mchar",

190923072510780341, COMMUTATOR = OPERATOR("public".<),

190923072510780341, NEGATOR = OPERATOR("public".<=),

190923072510780341, RESTRICT = "scalargtsel",

190923072510780341, JOIN = "scalargtjoinsel"

This is OK pg_dump(Centos7 posgtresql 9.6.2), pg_restore(windows 8.1
pgadmin 4.12) or pg_restore(Centos 7 postgresql 9.6.2)
190923100208718231,pg_restore: creating OPERATOR "public.>"

CREATE OPERATOR for posgtresql version 9.6.2
CREATE OPERATOR name (
PROCEDURE = function_name \\\\\for only pg_dump
(Centos 7 posgtresql 9.6.2)
[, LEFTARG = left_type ] [, RIGHTARG = right_type ]
[, COMMUTATOR = com_op ] [, NEGATOR = neg_op ]
[, RESTRICT = res_proc ] [, JOIN = join_proc ]
[, HASHES ] [, MERGES ]
)

BUT CREATE OPERATOR for postgresql version 11
CREATE OPERATOR name (
{FUNCTION|PROCEDURE} = function_name \\\\only for new version
postgresql 11 for pg_dump(windows pgadmin 4.12)
[, LEFTARG = left_type ] [, RIGHTARG = right_type ]
[, COMMUTATOR = com_op ] [, NEGATOR = neg_op ]
[, RESTRICT = res_proc ] [, JOIN = join_proc ]
[, HASHES ] [, MERGES ]
)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2019-09-24 14:17:05 Re: BUG #16019: error pg_restore from pg_dump(windows8.1-pgadmin 4.12)
Previous Message Ashesh Vashi 2019-09-24 05:11:39 Re: Query tool won't load