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

2007-01-01 Thread Tom Lane
"Shahryar G. Hashemi" <[EMAIL PROTECTED]> 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 t

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

2007-01-01 Thread Shahryar G. Hashemi
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 per