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

BUG #1843: pg_restore -O restores lowercase schemanaam

From: "D(dot)J(dot) Kniep" <dick(at)kniep(dot)nl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1843: pg_restore -O restores lowercase schemanaam
Date: 2005-08-23 11:04:50
Message-ID: 20050823110450.6EB30F0DAD@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1843
Logged by:          D.J. Kniep
Email address:      dick(at)kniep(dot)nl
PostgreSQL version: 7.4.8
Operating system:   Linux (SuSE 9.3)
Description:        pg_restore -O restores lowercase schemanaam
Details: 

I make a backup using 

pg_dump -f /tmp/dumpdb -F c -Z 5 cvix

When I try to restore this file, it fails with

postgres(at)linux:/tmp> pg_restore -O -d cvix2 /tmp/dumpdb
pg_restore: [archiver (db)] could not execute query: ERROR:  schema "Lindix"

does not exist

After checking, the schema lindix does exist (Note the lowercase l), but is
empty.

If I turn on statement logging, I see the following when running
pg_restore -O:

CREATE SCHEMA Test;

If I run pg_restore without -O, I see the following:

CREATE SCHEMA "Test" AUTHORIZATION postgres;

Off course this should be
CREATE SCHEMA "Test";

Responses

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2005-08-23 11:39:57
Subject: Re: BUG #1840: Does not install
Previous:From: Michael MeskesDate: 2005-08-23 07:45:25
Subject: Re: BUG #1815: ECPGdebug causes crash on Windows XP

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