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 ]
)
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 |