Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 82A8A9FA2EE for ; Mon, 1 Jan 2007 22:42:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 23623-08 for ; Mon, 1 Jan 2007 22:42:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id CA4659F9CE3 for ; Mon, 1 Jan 2007 22:42:16 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l022gEq3022537; Mon, 1 Jan 2007 21:42:14 -0500 (EST) To: "Shahryar G. Hashemi" cc: pgsql-admin@postgresql.org Subject: Re: pg_restore: [archiver (db)] could not execute query: ERROR: zero-length delimited identifier at or near """" at character 60 In-reply-to: <8459AE1CDB7A0441A1ED87C375891E4602DB7A92@EXCHIS5BV.inspinc.ad> References: <8459AE1CDB7A0441A1ED87C375891E4602DB7A92@EXCHIS5BV.inspinc.ad> Comments: In-reply-to "Shahryar G. Hashemi" message dated "Mon, 01 Jan 2007 18:14:37 -0800" Date: Mon, 01 Jan 2007 21:42:14 -0500 Message-ID: <22536.1167705734@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/2 X-Sequence-Number: 24158 "Shahryar G. Hashemi" writes: > pg_restore: creating ACL trig_account_password_insert() > pg_restore: [archiver (db)] could not execute query: ERROR: zero-length > delimited identifier at or near """" at character 60 Since 8.0, pg_dump/pg_restore have been careful to include the failing SQL command in messages like this, but 7.x didn't always do so. You could enable statement logging on the server to find out what the failed command was. Offhand it looks like a quoting problem but without more detail one can't tell. regards, tom lane