Re: [BUGS] BUG #4337: psql -c case insensitive

2008-08-01 Thread Magnus Hagander
Tom Lane wrote:
> "none" <[EMAIL PROTECTED]> 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

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


[BUGS] psql's copy binary to stdout

2008-08-01 Thread Heeman Lee
I found that 7.4 psql's 'copy binary to stdout' doesn't work. While
8.3's work fine. 
I saw there were couple of discussions regarding this back in 2005, but
don't know if it was classified as a bug.
Is this a known bug in 7.4?

Thanks.

-- 
Heeman Lee