Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore: [archiver (db)] could not execute query: ERROR: zero-length delimited identifier at or near """" at character 60 - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_restore: [archiver (db)] could not execute query: ERROR: zero-length delimited identifier at or near """" at character 60
Date
Msg-id 22536.1167705734@sss.pgh.pa.us
Whole thread Raw
In response to pg_restore: [archiver (db)] could not execute query: ERROR: zero-length delimited identifier at or near """" at character 60  ("Shahryar G. Hashemi" <Shahryar.Hashemi@infospace.com>)
List pgsql-admin
Tree view 
"Shahryar G. Hashemi" <Shahryar.Hashemi@infospace.com> 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

pgsql-admin by date:

Previous
From: "Shahryar G. Hashemi"
Date:
Subject: pg_restore: [archiver (db)] could not execute query: ERROR: zero-length delimited identifier at or near """" at character 60
Next
From: Alban Hertroys
Date:
Subject: Re: [GENERAL] OUTER JOIN IS SLOW