pg_restore case sensitivity

From: John Bercik <bercikj(at)musc(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_restore case sensitivity
Date: 2004-10-05 11:46:58
Message-ID: 416289B2.6020808@musc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

--
Best Regards,

John Bercik

Systems Programmer Phone: 843-792-3371
Department of Medicine Fax: 843-792-0816

Medical University of South Carolina email: bercikj(at)musc(dot)edu
Room 826F, Clinical Science Building
96 Jonathan Lucas Street
Charleston, SC 29425

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-10-05 14:00:03 Re: -HEAD build failure on OpenBSD 3.6-current/Sparc64 +patch
Previous Message Jason Tishler 2004-10-05 11:04:48 Re: cygwin test package available