Re: Restoring pg_dump Backup with psql Fails

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Restoring pg_dump Backup with psql Fails
Дата
Msg-id 27312.1198895166@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Restoring pg_dump Backup with psql Fails  ("Phillip Smith" <phillip.smith@weatherbeeta.com.au>)
Ответы Re: Restoring pg_dump Backup with psql Fails  ("Phillip Smith" <phillip.smith@weatherbeeta.com.au>)
Список pgsql-admin
"Phillip Smith" <phillip.smith@weatherbeeta.com.au> writes:
> But I get a whole bunch of errors, for example:
> <snip>
> ERROR:  syntax error at or near "all"
> LINE 1: all orders over $400.00 - freight free Order 10 of any produ...
>         ^

Please show us the *first* few errors, not some randomly chosen ones.
The above looks like a COPY has failed and psql has started thinking
that copy-data lines are commands, but how or why that happened is
not in evidence.

            regards, tom lane

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

Предыдущее
От: "Phillip Smith"
Дата:
Сообщение: Restoring pg_dump Backup with psql Fails
Следующее
От: "Phillip Smith"
Дата:
Сообщение: Re: Restoring pg_dump Backup with psql Fails