zero-length delimited identifier in pg_dumpall file

From: Randall Smith <randall(at)tnr(dot)cc>
To: pgsql-general(at)postgresql(dot)org
Subject: zero-length delimited identifier in pg_dumpall file
Date: 2004-09-30 04:34:05
Message-ID: 21M6d.2745$uY3.841@fed1read03
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Ed L. 2004-09-30 05:23:52 Re: 7.3.4 vacuum/analyze error
Previous Message Murali Mohan Kasetty 2004-09-30 04:31:25 How do I unsubscribe?