BUG #16019: error pg_restore from pg_dump(windows8.1-pgadmin 4.12)
От | PG Bug reporting form |
---|---|
Тема | BUG #16019: error pg_restore from pg_dump(windows8.1-pgadmin 4.12) |
Дата | |
Msg-id | 16019-e587cdb1ee670c25@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #16019: error pg_restore from pg_dump(windows8.1-pgadmin 4.12)
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 16019 Logged by: Damian Damirof Email address: drd1@list.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 ] )
В списке pgsql-bugs по дате отправления: