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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #16019: error pg_restore from pg_dump(windows8.1-pgadmin 4.12)
Дата
Msg-id 14701.1569334625@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #16019: error pg_restore from pg_dump(windows8.1-pgadmin 4.12)  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> 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.>"

This:

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

indicates that you're using v11 or later pg_dump (prior versions
would print "PROCEDURE" not "FUNCTION" here).  Don't do that
for this application.  In general, the version of pg_dump you use
must be >= the version of the source server, but <= the version
of the server you intend to restore to.

            regards, tom lane



В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16019: error pg_restore from pg_dump(windows8.1-pgadmin 4.12)
Следующее
От: "Alfred R. Fuller"
Дата:
Сообщение: Bug with "CHECK" when part of ALTER TABLE ... ADD COLUMN IF NOTEXISTS ... CHECK ...