zero-length delimited identifier in pg_dumpall file

Question posted by: Randall Smith (Guest) on November 23rd, 2005 02:21 AM

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

Quote | Subscribe