Re: Emacs + sql-postgres

[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
>