Re: Restoring pg_dump Backup with psql Fails - Mailing list pgsql-admin

From Tom Lane
Subject Re: Restoring pg_dump Backup with psql Fails
Date
Msg-id 27312.1198895166@sss.pgh.pa.us
Whole thread Raw
In response to Restoring pg_dump Backup with psql Fails  ("Phillip Smith" <phillip.smith@weatherbeeta.com.au>)
Responses Re: Restoring pg_dump Backup with psql Fails  ("Phillip Smith" <phillip.smith@weatherbeeta.com.au>)
List 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 by date:

Previous
From: "Phillip Smith"
Date:
Subject: Restoring pg_dump Backup with psql Fails
Next
From: "Phillip Smith"
Date:
Subject: Re: Restoring pg_dump Backup with psql Fails