zero-length delimited identifier in pg_dumpall file - Mailing list pgsql-general

From Randall Smith
Subject zero-length delimited identifier in pg_dumpall file
Date
Msg-id 21M6d.2745$uY3.841@fed1read03
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: "Igor Kryltsov"
Date:
Subject: Upgrade 7.3.3 to 7.4.5
Next
From: Steve Gollery
Date:
Subject: problem getting started with PostgreSQL 8 beta 3 on XP