> From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of C.Strobl@dlr.de
> Sent: Thursday, September 07, 2006 2:46 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] postgres and emacs on windows os
>
> hi all,
>
> has anybody experience using psql with emacs (M-x sql-postgres) on
windows. if i execute this command
> emacs prompts for user, database and host, but not for the password,
so i think there is no response
> from psql. but if am looking at the emacs messages there is no error
message
>
> if try to execute sql-statements or some psql commands nothing
happens, but thats not unexpected, because witout the specification of
the password i can't be logged in.
>
> thanks and greetings from munich
> christian
Christian,
Are you sure that nothing is actually happening, or are you just seeing
no output? Unfortunately, the native Win32 psql program falls into
"non-interactive" mode whenever it is run from most shell programs, and
thus although it is actually running and executing your commands, it
shows no output. We see this behavior whenever we run psql remotely via
SSH, and I believe we've also seen it when we run psql from emacs.
There was a patch posted a while back that added a "force interactive
mode" flag to psql, but this was never added in to the real psql code
base.
The alternative we chose instead was to run the version of psql from
Cygwin -- that version works fine from inside shell programs, and since
we were already using Cygwin to provide remote SSH services among other
things, it was an easy switch. (All you need are psql.exe and pq.dll,
although you may need to install the complete PostgreSQL server from the
Cygwin setup to get just these two files.)
- Bill
