Re: pg_restore case sensitivity - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_restore case sensitivity
Date
Msg-id 5187.1097505841@sss.pgh.pa.us
Whole thread Raw
In response to pg_restore case sensitivity  (John Bercik <bercikj@musc.edu>)
List pgsql-hackers
John Bercik <bercikj@musc.edu> writes:
> I'm in PG 8.0b3 and in it's psql i perform an -Fc pg_dump on a 7.4 db.  
> When I go to restore in PG 8.0b3 I get errors because of schemas that 
> have capital letters ("EMRImporting").  It creates schema "emrimporting" 
> and fails upon trying to restore data to "EMRImporting" schema because 
> it doesn't exist.  Thanks for any help.

Can you give us a complete example?  I don't see any unquoted schema
names in a quick test.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unit testing
Next
From: Andrew Dunstan
Date:
Subject: Re: Unit testing