Re: pg_dump: relation "..." already exists warning

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump: relation "..." already exists warning
Дата
Msg-id 11340.1127015124@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dump: relation "..." already exists warning  (Ennio-Sr <nasr.laili@tin.it>)
Ответы Re: pg_dump: relation "..." already exists warning  (Ennio-Sr <nasr.laili@tin.it>)
Список pgsql-novice
Ennio-Sr <nasr.laili@tin.it> writes:
> ...
> pg_dump finanz -t ult_qq | psql finanza ennio ult_qq    [***]
> ...
> [***] I copied this instruction somewhere from: it works,

... other than the warning it emits telling you that you've got
the psql command line syntax all wrong.  What other warnings and
error messages are you blithely ignoring?  I think you've omitted
the information needed to figure out what's wrong here.

Please post a cut-and-paste of a terminal window session showing this
sequence, not an edited transcript showing only what you think is
important.

BTW, one fairly likely guess about the problem is that you have
different schema search paths in the two databases --- so checking
the ALTER DATABASE defaults for each database wouldn't be a bad
idea.

            regards, tom lane

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

Предыдущее
От: Ennio-Sr
Дата:
Сообщение: Re: pg_dump: relation "..." already exists warning
Следующее
От: Ennio-Sr
Дата:
Сообщение: Re: pg_dump: relation "..." already exists warning