Skip site navigation (1) Skip section navigation (2)

Bug #624: case sensitivity in pg_dumpall

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #624: case sensitivity in pg_dumpall
Date: 2002-03-26 13:53:39
Message-ID: 20020326135339.C80B5475D23@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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.

Short Description
case sensitivity in pg_dumpall

Long Description
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
	psql:/home/volkerk/postgres/backups/backup22.03.02:46: 	
	\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. 

Best wishes,
Volker Klemann

  


Sample Code


No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-03-26 15:35:00
Subject: Re: Bug #624: case sensitivity in pg_dumpall
Previous:From: Peter EisentrautDate: 2002-03-25 22:46:09
Subject: Re: Bug #623: Compling 7.2 on a Tru64 V5.1 UNIX

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group