Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id EB1531337B97 for ; Thu, 5 May 2011 19:47:25 -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 71731-03 for ; Thu, 5 May 2011 22:47:16 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from out02.mta.xmission.com (out02.mta.xmission.com [166.70.13.232]) by mail.postgresql.org (Postfix) with ESMTP id C0F8F1337A5D for ; Thu, 5 May 2011 19:47:14 -0300 (ADT) Received: from in02.mta.xmission.com ([166.70.13.52]) by out02.mta.xmission.com with esmtps (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1QI7KD-0006CP-BA; Thu, 05 May 2011 16:47:13 -0600 Received: from [208.187.158.94] (helo=[172.16.1.234]) by in02.mta.xmission.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1QI7KD-0002VI-3u; Thu, 05 May 2011 16:47:13 -0600 Message-ID: <4DC328ED.1000705@gmail.com> Date: Thu, 05 May 2011 16:47:09 -0600 From: Rob Sargent User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.14) Gecko/20110221 SUSE/3.1.8 Lightning/1.0b2 Thunderbird/3.1.8 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: slightly OT - Using psql from Emacs with sql.el References: <87sjssajtb.fsf@kolob.sebmags.homelinux.org> In-Reply-To: <87sjssajtb.fsf@kolob.sebmags.homelinux.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-XM-SPF: eid=; ; ; mid=; ; ; hst=in02.mta.xmission.com; ; ; ip=208.187.158.94; ; ; frm=robjsargent@gmail.com; ; ; spf=neutral X-XM-AID: U2FsdGVkX18fywuZA3Ju3Bf+ZTb3tNPNTbZVlNLccHw= X-SA-Exim-Connect-IP: 208.187.158.94 X-SA-Exim-Mail-From: robjsargent@gmail.com X-SA-Exim-Scanned: No (on in02.mta.xmission.com); SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.888 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201105/28 X-Sequence-Number: 35312 On 05/05/2011 04:01 PM, Seb wrote: > 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, > Doesn't appear to. I use sql-mode alot/daily. The multiple prompts never bothers me, though the output not starting at the left kind of does.