Re: ob-sql posgresql windows problems
On 10/24/20 7:41 AM, Bastien wrote: Hi Neil, Neil Cherry writes: I'm on a Windows 10 System, I'm using ob-sql.el and when I C-c C-c on the src block I get: What version of Org are you using? M-x org-version RET Thanks, Org mode version 9.1.9 (release_9.1.9-65-g5e4542 @ c:/Users/NC1951/Documents/emacs-26.1/share/emacs/26.1/lisp/org/) I did fix the issue by adding an if clause for Windows NT. It was caused by the PGPASSORD being used before the command when it shouldn't have been there. I have Postgres password file setup for the machine I want to access. Since the change it's been working very well. I think you're going to suggest that I upgrade my Windows machine to the latest. I'll need to find that command after I backup my machine. -- Linux Home Automation Neil Cherry nche...@linuxha.com http://www.linuxha.com/ Main site http://linuxha.blogspot.com/My HA Blog Author of: Linux Smart Homes For Dummies
Re: ob-sql posgresql windows problems
Hi Neil, Neil Cherry writes: > I'm on a Windows 10 System, I'm using ob-sql.el and when I C-c C-c > on the src block I get: What version of Org are you using? M-x org-version RET Thanks, -- Bastien
ob-sql posgresql windows problems
I'm on a Windows 10 System, I'm using ob-sql.el and when I C-c C-c on the src block I get: 'PGPASSWORD' os mpt recognized as an internal or external command. Example block: #+name: My queries (Not working - 'PGPASSWORD' is not recognized as an internal or external) #+header: :engine postgresql #+header: :dbhost pgdb.example.com #+header: :dbuser user #+header: :dbpassword password #+header: :database db #+begin_src sql select count(*) from db.pserver #+end_src I've tried to use an elisp block to set the SHELL to the correct bash path but it still calls cmd. Any suggestions to help with debugging. -- Linux Home Automation Neil Cherry nche...@linuxha.com http://www.linuxha.com/ Main site http://linuxha.blogspot.com/My HA Blog Author of: Linux Smart Homes For Dummies