PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16019
PG Version9.6.2
OSCentos 7 Windows 8.1
Opened2019-09-24 09:29:28+00
Reported byDamian Damirof
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16019
Logged by:          Damian Damirof
Email address:      (redacted)
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 ]
)

Messages

DateAuthorSubject
2019-09-24 09:29:28+00PG Bug reporting formBUG #16019: error pg_restore from pg_dump(windows8.1-pgadmin 4.12)
2019-09-24 14:17:05+00Tom LaneRe: BUG #16019: error pg_restore from pg_dump(windows8.1-pgadmin 4.12)