ob-sql posgresql windows problems

ob-sql posgresql windows problems

[Neil Cherry]

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       ncherry@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

[Bastien]

Hi Neil,

Neil Cherry <ncherry@linuxha.com> 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

Re: ob-sql posgresql windows problems

[Neil Cherry]

On 10/24/20 7:41 AM, Bastien wrote:
> Hi Neil,
> 
> Neil Cherry <ncherry@linuxha.com> 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       ncherry@linuxha.com
http://www.linuxha.com/                         Main site
http://linuxha.blogspot.com/                    My HA Blog
Author of:    	Linux Smart Homes For Dummies