Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 3A3281337BFA
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu,  5 May 2011 19:01:51 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 44743-04 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu,  5 May 2011 22:01:43 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from lo.gmane.org (lo.gmane.org [80.91.229.12])
	by mail.postgresql.org (Postfix) with ESMTP id 268E91337BD8
	for <pgsql-sql@postgresql.org>; Thu,  5 May 2011 19:01:41 -0300 (ADT)
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1QI6c1-00024s-Hg
	for pgsql-sql@postgresql.org; Fri, 06 May 2011 00:01:33 +0200
Received: from s01060015e975d7fb.wp.shawcable.net ([24.77.73.195])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Fri, 06 May 2011 00:01:33 +0200
Received: from spluque by s01060015e975d7fb.wp.shawcable.net with local
	(Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Fri, 06 May 2011 00:01:33 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-sql@postgresql.org
From: Seb <spluque@gmail.com>
Subject: slightly OT - Using psql from Emacs with sql.el
Date: Thu, 05 May 2011 17:01:20 -0500
Organization: Church of Emacs
Lines: 26
Message-ID: <87sjssajtb.fsf@kolob.sebmags.homelinux.org>
Mime-Version: 1.0
Content-Type: text/plain
X-Complaints-To: usenet@dough.gmane.org
X-Gmane-NNTP-Posting-Host: s01060015e975d7fb.wp.shawcable.net
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.3 (gnu/linux)
Cancel-Lock: sha1:5aDZPTeQc+Zxgc/ylBj97lXDE7E=
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	FREEMAIL_FROM=0.001, T_RP_MATCHES_RCVD=-0.01,
	T_TO_NO_BRKTS_FREEMAIL=0.01
X-Spam-Level: 
X-Archive-Number: 201105/27
X-Sequence-Number: 35311

Hi,

When working with psql via sql.el, multiple prompts accumulate in a
single line when sending multi-line input to the SQLi buffer.  For
example, sending the following:

SELECT a,
    b,
    c,
FROM some_table;

with 'C-c C-r' results in these lines in the SQLi buffer:

database_name=# database_name-# database_name-# database_name-# 

before showing the output of the query.

This doesn't happen when working with psql directly from a shell.

Has someone dealt with this problem or can suggest some ideas to avoid
this?

Thanks,

-- 
Seb