Re: Emacs + sql-postgres

[Pascal c <pch.netz@gmail.com>]

Hi,

I got it runing !
Acutually it worked from the begning but after to validate my password, I
didn't get any information that the connection was successful.
So to just execute a SQL requestion, I entry for exemple : select * from
table then press ENTER and I got the result !

Thank you !

Cheers,

Pascal


2013/5/29 Pascal c <pch.netz@gmail.com>

> hi Filipp,
>
> thank you for your reply.
> As you can read into my email I'm using psql from cygwin :
>
> >Password for user  postgres:
> >psql: FATAL:  Passwort-Authentifizierung f³r Benutzer ╗ postgres½
> fehlgeschlagen
>
> >Into my .emacs I have written the line :
> >(setq sql-postgres-program "C:\\cygwin\\bin\\psql.exe")
>
> or mybe this is not the psql from cygwin ?
>
> Thank you,
>
>
> Cheers,
>
> Pascal
>
>
> 2013/5/29 Filipp Gunbin <fgunbin@fastmail.fm>
>
>> On 29/05/2013 11:22 +0400, Pascal c wrote:
>>
>> > If I use sql-postgres, I got the prompt to entry my user, host and
>> database.
>> > Then I got the prompt from psql to entry my password. But this doesn't
>> > work.
>> > I got the following state :
>> >
>> > Password for user  postgres:
>> > psql: FATAL:  Passwort-Authentifizierung f³r Benutzer ╗ postgres½
>> > fehlgeschlagen
>>
>> The simplest case is using cygwin Postgres (with psql) from cygwin
>> Emacs.  Try that, if that does not work then probably you have some
>> authentication problems.
>>
>> As for issuing commands, you can do that either from interactive sql
>> buffer, which runs psql and therefore accepts its commands, or from any
>> sql buffer which have an associated interactive buffer (then commands
>> like `C-c C-r' for sending a query to the interactive buffer apply).
>>
>> `sql-set-sqli-buffer' allows to choose such an interactive buffer.
>> `sql-set-product' with an argument of `sql-postgres' may be required
>> before `sql-set-sqli-buffer'.
>>
>> Filipp
>>
>
>