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

Hello,

We are running PostgreSQL 7.4.7 on a Linux system. We have a primary DB
and hot-standby [via pg_dump/pg_restore]. A few weeks ago we had a
database corruption and had to go back to a dump from 12/20/2006.
Everything restored fine [on the primary and standby DB's] however
everytime we perform a pg_dump/pg_restore we get this error:

pg_restore: creating TABLE account_password
pg_restore: creating FUNCTION trig_account_insert()
pg_restore: creating FUNCTION trig_account_password_insert()
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
pg_restore: *** aborted because of error

Here is how we run the pg_dump command:
pg_dump -C -v -U hydra -f <backup_file> -Fc hydra
Here is how we run the pg_restore command:
pg_restore -v -C -h bvmgdb2a -U hydra -d template1 <backup_file>

I can get the pg_restore to complete if I add the -x [ignore ACL
[grant/revoke]. But my question is what is wrong with the ACL
trig_account_password_insert() and how can I fix it on the production DB
so this error can go away? The error makes zero sense. The
documentation leaves a lot to be desired.

BTW I am a Sybase/SQL Server DBA so PostgreSQL is another world to me.

Thanks,

Shahryar

--
Shahryar G. Hashemi DBA
InfoSpace Inc.
601 108th Ave NE Suite 1200
Bellevue, WA 98004 U.S.A.
Office: +1 425.201.8853 Fax: +1 425.201.6160
Alpha Pager: page-shashem(at)infospace(dot)com Numeric Pager: +1 877.252.5631
E-Mail: shashem(at)infospace(dot)com WEB: http://infospaceinc.com
<http://infospaceinc.com/>

This e-mail and any attachments may contain confidential information
that is legally privileged. The information is solely for the use of the
intended recipient(s); any disclosure, copying, distribution, or other
use of this information is strictly prohibited. If you have received
this e-mail in error, please notify the sender by return e-mail and
delete this message. Thank you.