Thread: zero-length delimited identifier in pg_dumpall file

zero-length delimited identifier in pg_dumpall file

From
Randall Smith
Date:
Got this error on a pg_dumpall file dumped from a postgresql-7.4-0.3PGDG
database and imported into 7.4.5-3 database.

ERROR:  zero-length delimited identifier at or near """" at character 37

 From looking at the output, I think maybe this is the line that caused
the error.

CREATE SCHEMA "MSV80" AUTHORIZATION "";

There is another statement a few lines down that looks like this:

CREATE SCHEMA msv80 AUTHORIZATION dba;

Is this a but in the pg_dumall program?

Randall