BUG #4337: psql -c case insensitive
The following bug has been logged online:
Bug reference: 4337
Logged by: none
Email address: nomind@mailinator.com
PostgreSQL version: 8.2.3
Operating system: windows xp
Description: psql -c case insensitive
Details:
I'm programming an application that uses psql (...) -c "ALTER DATABASE
\"MyBase\" RENAME TO \"MyBase2\" and it doesn't work because it looks for a
"mybase" database name.
I'm using c# respecting case sensitive arguments, so I think the error is
with psql.
Check it ;)
"none" <nomind@mailinator.com> writes:
I'm programming an application that uses psql (...) -c "ALTER DATABASE
\"MyBase\" RENAME TO \"MyBase2\" and it doesn't work because it looks for a
"mybase" database name.
Works for me. I speculate that your scripting language is losing the
embedded double-quotes somewhere before psql gets them. I don't know
much about Windows scripting so it's hard to say more than that; but
an extra interpretation pass over the command string would probably
cause such a problem.
regards, tom lane
Tom Lane wrote:
"none" <nomind@mailinator.com> writes:
I'm programming an application that uses psql (...) -c "ALTER DATABASE
\"MyBase\" RENAME TO \"MyBase2\" and it doesn't work because it looks for a
"mybase" database name.Works for me. I speculate that your scripting language is losing the
embedded double-quotes somewhere before psql gets them. I don't know
much about Windows scripting so it's hard to say more than that; but
an extra interpretation pass over the command string would probably
cause such a problem.
Most likely you're bit by the completely insane rules of quoting in the
windows commandshell. See for example the comments around it in
src/port.h in the PostgreSQL distribution.
//Magnus