Re: postgres and emacs on windows os

> From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of C(dot)Strobl(at)dlr(dot)de
> Sent: Thursday, September 07, 2006 2:46 AM
> To: pgsql-general(at)postgresql(dot)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

-----Ursprüngliche Nachricht-----
Von: Bill Bartlett [mailto:bbartlett(at)softwareanalytics(dot)com]
Gesendet: Donnerstag, 7. September 2006 20:35
An: Strobl, Christian; pgsql-general(at)postgresql(dot)org
Betreff: RE: [GENERAL] postgres and emacs on windows os

hi bill,
you are right. psql starts but it doesn't do anything. i have to close emacs and also to kill psql.
maybe the patch comes sometime, meanwhile i try cygwin.
thanks for your answer and your tip
christian