Re: Restoring pg_dump Backup with psql Fails

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Restoring pg_dump Backup with psql Fails
Date: 2007-12-29 02:26:06
Message-ID: 27312.1198895166@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Phillip Smith 2007-12-29 03:48:53 Re: Restoring pg_dump Backup with psql Fails
Previous Message Phillip Smith 2007-12-29 00:27:25 Restoring pg_dump Backup with psql Fails