From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id OLtTMT25h1/6DgAA0tVLHw (envelope-from ) for ; Thu, 15 Oct 2020 02:51:41 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id 1koULT25h1+pJgAAbx9fmQ (envelope-from ) for ; Thu, 15 Oct 2020 02:51:41 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 2828594053D for ; Thu, 15 Oct 2020 02:51:41 +0000 (UTC) Received: from localhost ([::1]:53628 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kStMg-0005X6-9f for larch@yhetil.org; Wed, 14 Oct 2020 22:51:38 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:44340) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kStMG-0005WX-HR for emacs-orgmode@gnu.org; Wed, 14 Oct 2020 22:51:13 -0400 Received: from mout.perfora.net ([74.208.4.196]:58237) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kStMD-0001dj-6h for emacs-orgmode@gnu.org; Wed, 14 Oct 2020 22:51:12 -0400 Received: from [192.168.24.2] ([69.142.220.70]) by mrelay.perfora.net (mreueus003 [74.208.5.2]) with ESMTPSA (Nemesis) id 0LllQs-1jtYba0g3U-00ZPdD for ; Thu, 15 Oct 2020 04:51:06 +0200 To: emacs-orgmode@gnu.org From: Neil Cherry Subject: ob-sql posgresql windows problems Message-ID: <8ca746ff-f406-939f-59a0-2cd1f0dbecc3@linuxha.com> Date: Wed, 14 Oct 2020 22:51:04 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.3.1 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:bZwW/oBVCGL67fntX7Svnc0kWqWxdGf9Q116G0bRr0L8SOUBGLt WeRZfIr60qAMIOM0JO4nXggih19Ujr/9EVt/BC+4OC2X+SbWr5z+TmNTGf4S3NSi3P+jbHj eIImB+u57X7c+0g2rbgQsjZNp5/+Icj8OdD3fm8Sj9F2i/zeTG/b7cI1UbAOFHzzkob6wKd /XFW0ybgjUTGpMtc+OluA== X-UI-Out-Filterresults: notjunk:1;V03:K0:ToVCPFnc+7E=:mpIE5gfCyb5Tzv6we/sIJn uzpF7e8YA7JO7Qgw0C+WRaFPjgNR6fPsCBRMuYc/inJVVXXm/oGUqLnSFCmEKkJVC2eWbyeod U8UmTI+4IS5oQM067cUf56qP8O85c0mQxHAIuDhMaSAu3fR8cyWJdEl2d9Pl0SRvpBdNLiGGS U5eHDat1jQNBUoCXNNeJbZnuTbJSAD0e38CYrqTJ0mYB9k7OfMg04BYeRfv2fsZYbu5ocWn37 hBO9gJ5J3NNwWE0p/t92GZQcpGHVVo2HlYaZjCwUalTuVo7cHMtMERAxcfo80wMvIGesOO64F 6vP2G1JAynXcI5IVYO8PHkADyiEGl9S3rwhkCpmiWSMwY5OS8KtRtLLUTWsfWWxYb3ESxsNEZ ea+kO51obBIxi2m6IETY+YOBUQHdOX7xN9bNc5ARMva5ono8ZHgfgEpcWcDKlvtqS32ROt5FF R/C93FWnjw== Received-SPF: pass client-ip=74.208.4.196; envelope-from=ncherry@linuxha.com; helo=mout.perfora.net X-detected-operating-system: by eggs.gnu.org: First seen = 2020/10/14 22:51:06 X-ACL-Warn: Detected OS = Linux 2.2.x-3.x [generic] X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Spam-Score: -1.01 X-TUID: f5yiE9RTQb2F 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