Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group