Volker Klemann (volkerk(at)gfz-potsdam(dot)de) reports a bug with a severity of 2
The lower the number the more severe it is.
case sensitivity in pg_dumpall
Dear people from postgres,
Don't know if I am the first where this bug appeared:
While updating from 7.1.2 to 7.2 I used pg_dumpall to dump
my data as recommended by the INSTALL manual.
When re-instaling the database using
psql -d template1 -f dumpfile
I got the error
\connect: FATAL 1: Database "rsl" does not exist in the system catalog.
The corresponding lines in the script produced by pg_dumpall are:
45 CREATE DATABASE "RSL" WITH TEMPLATE = template0;
46 \connect RSL volkerk
So, while considering upper and lower cases in 45: using collons
the program missed them in 46:, and tried to log into rsl instead of RSL.
Took me some time to find it, because first 'was searching for
inconsistencies, in the new installation.
No file was uploaded with this report
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2002-03-26 15:35:00|
|Subject: Re: Bug #624: case sensitivity in pg_dumpall |
|Previous:||From: Peter Eisentraut||Date: 2002-03-25 22:46:09|
|Subject: Re: Bug #623: Compling 7.2 on a Tru64 V5.1 UNIX|