Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name
Date
Msg-id 13775.1013786512@sss.pgh.pa.us
Whole thread Raw
In response to Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
pgsql-bugs@postgresql.org writes:
> The reason is, that the database is called "iBBS-oud" and not "ibbs-oud". The script contains the correct name of the
database,but postgres seems to convert the capitals in "iBBS-oud" to lowercase so it becomes "ibbs-oud" internally. 

Yes, pg_dump fails to quote the database name properly.  This is already
fixed for 7.2.1.  You may care to grab current sources (see the nightly
snapshot tarballs in the FTP dev/ directory) and use the latest pg_dump
to perform the dump from your 7.1.3 server.  Or just edit the connect
statements in the dump you have.

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #591: Postgres apparently not identifying users created in Caps