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


---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to