> 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
psqlprogram falls into "non-interactive" mode whenever it is run from most shell programs, and thus although it is
actuallyrunning and executing your commands, it shows no output. We see this behavior whenever we run psql remotely
viaSSH, 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
tothe real psql code base.
The alternative we chose instead was to run the version of psql from Cygwin -- that version works fine from inside
shellprograms, 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
Cygwinsetup to get just these two files.)
- Bill
-----Ursprüngliche Nachricht-----
Von: Bill Bartlett [mailto:bbartlett@softwareanalytics.com]
Gesendet: Donnerstag, 7. September 2006 20:35
An: Strobl, Christian; pgsql-general@postgresql.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