Re: Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ruud(at)stress(dot)utwente(dot)nl, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name
Date: 2002-02-15 15:21:52
Message-ID: 13775.1013786512@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Torres Abarca Jaime 2002-02-15 16:40:49 Compiling error
Previous Message Detlef Plotzky 2002-02-15 14:07:16 Bug with SQL-COPY in 7.2