Re: Sql-mode calls tramp for no reason

[Michael Albinus]

Nikolay Kudryavtsev <nikolay.kudryavtsev@gmail.com> writes:

> Hello.

Hi,

> Is there any way to force sql-product-interactive to run sql program
> on local machine only?
>
> After I use tramp for some time and then call sql-product-interactive
> it tries to run sql program on one of the open tramp connections,
> instead of my local machine. It does not matter if I call it while
> having dired open on local machine or even local sql file open. Even
> calling M-x cd beforehand does not help. It still tries to run sql
> program on a host over tramp. After some sequence of actions that I
> haven't fully figured out, it finally goes away and uses local machine
> paths.

I don't know sql.el, but it looks like it uses comint. When a new sql call
is run, comint uses either the local host or the remote one, depending
on default-directory of the current buffer.

Further calls of sql-product-interactive seem to reuse the buffer, its
name is kept in the variable sql-buffer.

Maybe you could add some code via sql-set-sqli-hook. Something like
(completely untested):

;; Force sql-product-interactive to run on the local host.
(add-hook 'sql-set-sqli-hook (lambda () (setq default-directory "/")))

Best regards, Michael.