Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 01BC12E30C2 for ; Fri, 28 Dec 2007 22:26:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 55732-02 for ; Fri, 28 Dec 2007 22:26:00 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 3B7EC2E0071 for ; Fri, 28 Dec 2007 22:26:08 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lBT2Q6lr027313; Fri, 28 Dec 2007 21:26:06 -0500 (EST) To: "Phillip Smith" cc: pgsql-admin@postgresql.org Subject: Re: Restoring pg_dump Backup with psql Fails In-reply-to: <003501c849b1$95ed1200$9b0014ac@wbaus090> References: <003501c849b1$95ed1200$9b0014ac@wbaus090> Comments: In-reply-to "Phillip Smith" message dated "Sat, 29 Dec 2007 11:27:25 +1100" Date: Fri, 28 Dec 2007 21:26:06 -0500 Message-ID: <27312.1198895166@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/237 X-Sequence-Number: 27754 "Phillip Smith" writes: > But I get a whole bunch of errors, for example: > > 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