"Shahryar G. Hashemi" <Shahryar(dot)Hashemi(at)infospace(dot)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