From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Pascal c Newsgroups: gmane.emacs.help Subject: Re: Emacs + sql-postgres Date: Wed, 29 May 2013 15:30:43 +0200 Message-ID: References: <86ip229nt7.fsf@w2139spb.ru.yotateam.com> NNTP-Posting-Host: plane.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Trace: ger.gmane.org 1369834276 30132 80.91.229.3 (29 May 2013 13:31:16 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Wed, 29 May 2013 13:31:16 +0000 (UTC) To: help-gnu-emacs Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Wed May 29 15:31:16 2013 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([208.118.235.17]) by plane.gmane.org with esmtp (Exim 4.69) (envelope-from ) id 1UhgTD-0007Lw-G8 for geh-help-gnu-emacs@m.gmane.org; Wed, 29 May 2013 15:31:15 +0200 Original-Received: from localhost ([::1]:60127 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UhgTD-0006KT-20 for geh-help-gnu-emacs@m.gmane.org; Wed, 29 May 2013 09:31:15 -0400 Original-Received: from eggs.gnu.org ([208.118.235.92]:59123) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UhgSp-0006Hc-QW for help-gnu-emacs@gnu.org; Wed, 29 May 2013 09:30:57 -0400 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1UhgSi-0008H8-OW for help-gnu-emacs@gnu.org; Wed, 29 May 2013 09:30:51 -0400 Original-Received: from mail-pb0-x235.google.com ([2607:f8b0:400e:c01::235]:38922) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UhgSi-0008Gr-6Y for help-gnu-emacs@gnu.org; Wed, 29 May 2013 09:30:44 -0400 Original-Received: by mail-pb0-f53.google.com with SMTP id un4so9127921pbc.26 for ; Wed, 29 May 2013 06:30:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=rZ42aPGoV8KniHAXIBSK6+sIlYd9LDanDHvnFhGRyN0=; b=ApS4IyiFHuM5lTcpSj/mbtweqhFF+4XTkv7DpS3SvYKtIIv11zuULx+co0/GqJ3Fcw 1SSUT2llz/Q/yoF3taGQieBMMlXfcgX7+JtF1VVvBzcGxPVYiEJfb47AERFmzdLBn1Sm KNKUFK7GDd5p0vAi6U2ACi/J8qGPMw8IYNRBwDtMHc/iRfM0MJd/jUmv8DnvxvmVaeyj jY6pKhdOKu+LQ9PVXk0HXdaPq81wD/wEAokuTin60RQzOlxxBNN+BcXIgn1S+OPUnFa/ uTyglpA5YMR8x9Z17b79QM9L+/BVNJs1nkGPoZai7DvU7H72OamQSnev6DxNe/ljk4SS zFbw== X-Received: by 10.67.2.33 with SMTP id bl1mr3492641pad.26.1369834243305; Wed, 29 May 2013 06:30:43 -0700 (PDT) Original-Received: by 10.68.125.199 with HTTP; Wed, 29 May 2013 06:30:43 -0700 (PDT) In-Reply-To: X-detected-operating-system: by eggs.gnu.org: Error: Malformed IPv6 address (bad octet value). X-Received-From: 2607:f8b0:400e:c01::235 X-Content-Filtered-By: Mailman/MimeDel 2.1.14 X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:91131 Archived-At: 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 > 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=C2=B3r Benutzer =E2=95=97 pos= tgres=C2=BD > 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 > >> 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=C2=B3r Benutzer =E2=95=97 p= ostgres=C2=BD >> > 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 >> > >