Message-ID: <4DC32F9D.6010405@gmail.com>
Date: Thu, 05 May 2011 17:15:41 -0600
From: Rob Sargent <robjsargent@gmail.com>
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>
	<4DC328ED.1000705@gmail.com>
	<87ipto21w4.fsf@kolob.sebmags.homelinux.org>
In-Reply-To: <87ipto21w4.fsf@kolob.sebmags.homelinux.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


On 05/05/2011 04:55 PM, Seb wrote:
> On Thu, 05 May 2011 16:47:09 -0600,
> Rob Sargent<robjsargent@gmail.com>  wrote:
>
> [...]
>
>> 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.
>
> I've adapted someone's suggestion at the Emacs Wiki for that:
>
> (defun sl/sql-add-newline-before-output (output)
>    "Add newline to beginning of OUTPUT for `comint-preoutput-filter-functions'"
>    (concat "\n" output))
>
> (add-hook 'sql-interactive-mode-hook
> 	  (lambda ()
> 	    (add-hook 'comint-preoutput-filter-functions
> 		      'sl/sql-add-newline-before-output)))
>
> ... but this breaks navigation (e.g. 'C-c C-p')
>
>
Oooo, can't have that.  Though my usage (sql-send-paragraph) does not 
get registered in the command history, I still like have a proper record 
of what I have typed into the *SQL* buffer.  If I want a history of what 
I sent from my working buffer (of sql statements) I wipe/yank into 
*SQL*.  Then the entire block returns on M-p.