Bug: babel can't locate psql [8.2.10 (release_8.2.10 @ /Applications/Emacs.app/Contents/Resources/lisp/org/)]

Bug: babel can't locate psql [8.2.10 (release_8.2.10 @ /Applications/Emacs.app/Contents/Resources/lisp/org/)]

[Barbara Shirtcliff]

Remember to cover the basics, that is, what you expected to happen and
what in fact did happen.  You don't know how to make a good report?  See

     http://orgmode.org/manual/Feedback.html#Feedback

Your bug report will be posted to the Org-mode mailing list.
------------------------------------------------------------------------

Executing a block of psql produces the error: "/bin/bash: psql:
command not found".

Bash is able to find psql.  So is M-: (executable-find "psql").  I
have a brew-installed psql in the standard brew-installed location for
my computer, at /usr/local/bin/psql.  As far as I can tell, the
location of psql is hard-coded into ob-sql.el and is not configurable.

The command that ob-sql logs in the *Messages* buffer works in an
emacs shell session.  But that, of course, is not the point.

Emacs  : GNU Emacs 24.5.1 (x86_64-apple-darwin13.4.0, NS apple-appkit-1265.21)
 of 2015-04-10 on builder10-9.porkrind.org
Package: Org-mode version 8.2.10 (release_8.2.10 @ /Applications/Emacs.app/Contents/Resources/lisp/org/)

current state:
==============
(setq
 org-tab-first-hook '(org-hide-block-toggle-maybe
                      org-src-native-tab-command-maybe
                      org-babel-hide-result-toggle-maybe
                      org-babel-header-arg-expand)
 org-speed-command-hook '(org-speed-command-default-hook
                          org-babel-speed-command-hook)
 org-occur-hook '(org-first-headline-recenter)
 org-metaup-hook '(org-babel-load-in-session-maybe)
 org-confirm-shell-link-function 'yes-or-no-p
 org-after-todo-state-change-hook '(org-clock-out-if-current)
 org-from-is-user-regexp "\\<Barbara Shirtcliff\\>"
 org-src-mode-hook '(org-src-babel-configure-edit-buffer
                     org-src-mode-configure-edit-buffer)
 org-agenda-before-write-hook '(org-agenda-add-entry-text)
 org-babel-pre-tangle-hook '(save-buffer)
 org-mode-hook '(#[nil "\300\301\302\303\304$\207"
                   [org-add-hook change-major-mode-hook org-show-block-all append
                    local]
                   5]
                 #[nil "\300\301\302\303\304$\207"
                   [org-add-hook change-major-mode-hook org-babel-show-result-all
                    append local]
                   5]
                 org-babel-result-hide-spec org-babel-hide-all-hashes)
 org-ctrl-c-ctrl-c-hook '(org-babel-hash-at-point org-babel-execute-safely-maybe)
 org-cycle-hook '(org-cycle-hide-archived-subtrees org-cycle-hide-drawers
                  org-cycle-hide-inline-tasks org-cycle-show-empty-lines
                  org-optimize-window-after-visibility-change)
 org-babel-tangle-lang-exts '(("python" . "py") ("emacs-lisp" . "el"))
 org-confirm-elisp-link-function 'yes-or-no-p
 org-metadown-hook '(org-babel-pop-to-session-maybe)
 org-babel-load-languages '((sql . t))
 org-clock-out-hook '(org-clock-remove-empty-clock-drawer)
 )

Re: Bug: babel can't locate psql [8.2.10 (release_8.2.10 @ /Applications/Emacs.app/Contents/Resources/lisp/org/)]

[Thomas S. Dye]

Aloha Barbara,

Barbara Shirtcliff writes:

> Remember to cover the basics, that is, what you expected to happen and
> what in fact did happen.  You don't know how to make a good report?  See
>
>      http://orgmode.org/manual/Feedback.html#Feedback
>
> Your bug report will be posted to the Org-mode mailing list.
> ------------------------------------------------------------------------
>
> Executing a block of psql produces the error: "/bin/bash: psql:
> command not found".
>
> Bash is able to find psql.  So is M-: (executable-find "psql").  I
> have a brew-installed psql in the standard brew-installed location for
> my computer, at /usr/local/bin/psql.  As far as I can tell, the
> location of psql is hard-coded into ob-sql.el and is not configurable.
>
> The command that ob-sql logs in the *Messages* buffer works in an
> emacs shell session.  But that, of course, is not the point.

Perhaps the exec-path-from-shell package would help in this instance?

hth,
Tom

-- 
Thomas S. Dye
http://www.tsdye.com