From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Andreas Schwab Newsgroups: gmane.emacs.bugs Subject: bug#23242: [PATCH] ob-sql.el: set PGPASSWORD environment Date: Fri, 08 Apr 2016 17:45:58 +0200 Message-ID: <87vb3s14uh.fsf@linux-m68k.org> References: <1460111062-4420-1-git-send-email-baron@bundesbrandschatzamt.de> NNTP-Posting-Host: plane.gmane.org Mime-Version: 1.0 Content-Type: text/plain X-Trace: ger.gmane.org 1460130433 5778 80.91.229.3 (8 Apr 2016 15:47:13 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Fri, 8 Apr 2016 15:47:13 +0000 (UTC) Cc: 23242@debbugs.gnu.org To: Andreas Gerler Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Fri Apr 08 17:47:13 2016 Return-path: Envelope-to: geb-bug-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([208.118.235.17]) by plane.gmane.org with esmtp (Exim 4.69) (envelope-from ) id 1aoYcq-0007Cg-73 for geb-bug-gnu-emacs@m.gmane.org; Fri, 08 Apr 2016 17:47:12 +0200 Original-Received: from localhost ([::1]:56870 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1aoYcp-0008N8-Nf for geb-bug-gnu-emacs@m.gmane.org; Fri, 08 Apr 2016 11:47:11 -0400 Original-Received: from eggs.gnu.org ([2001:4830:134:3::10]:57526) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1aoYck-0008Jr-Ap for bug-gnu-emacs@gnu.org; Fri, 08 Apr 2016 11:47:07 -0400 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1aoYch-0003Ew-4X for bug-gnu-emacs@gnu.org; Fri, 08 Apr 2016 11:47:06 -0400 Original-Received: from debbugs.gnu.org ([208.118.235.43]:42432) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1aoYch-0003Es-1C for bug-gnu-emacs@gnu.org; Fri, 08 Apr 2016 11:47:03 -0400 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1aoYcg-0000gC-Sb for bug-gnu-emacs@gnu.org; Fri, 08 Apr 2016 11:47:02 -0400 X-Loop: help-debbugs@gnu.org Resent-From: Andreas Schwab Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Fri, 08 Apr 2016 15:47:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 23242 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: patch Original-Received: via spool by 23242-submit@debbugs.gnu.org id=B23242.146013036332578 (code B ref 23242); Fri, 08 Apr 2016 15:47:02 +0000 Original-Received: (at 23242) by debbugs.gnu.org; 8 Apr 2016 15:46:03 +0000 Original-Received: from localhost ([127.0.0.1]:54765 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1aoYbj-0008TD-2h for submit@debbugs.gnu.org; Fri, 08 Apr 2016 11:46:03 -0400 Original-Received: from mail-out.m-online.net ([212.18.0.9]:57622) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1aoYbg-0008Pp-PM for 23242@debbugs.gnu.org; Fri, 08 Apr 2016 11:46:01 -0400 Original-Received: from frontend01.mail.m-online.net (unknown [192.168.8.182]) by mail-out.m-online.net (Postfix) with ESMTP id 3qhP1z4WS5z3hj06; Fri, 8 Apr 2016 17:45:59 +0200 (CEST) Original-Received: from localhost (dynscan1.mnet-online.de [192.168.6.68]) by mail.m-online.net (Postfix) with ESMTP id 3qhP1z467kzvPsq; Fri, 8 Apr 2016 17:45:59 +0200 (CEST) X-Virus-Scanned: amavisd-new at mnet-online.de Original-Received: from mail.mnet-online.de ([192.168.8.182]) by localhost (dynscan1.mail.m-online.net [192.168.6.68]) (amavisd-new, port 10024) with ESMTP id wwcHa9arhvYt; Fri, 8 Apr 2016 17:45:58 +0200 (CEST) X-Auth-Info: ph9N+26sLVeRTmwxiXSdZ0i5u//EhI7gy4X8vce8zYzWZG9Ar1LJ2QY4JC8/c7pw Original-Received: from igel.home (ppp-88-217-23-82.dynamic.mnet-online.de [88.217.23.82]) by mail.mnet-online.de (Postfix) with ESMTPA; Fri, 8 Apr 2016 17:45:58 +0200 (CEST) Original-Received: by igel.home (Postfix, from userid 1000) id 697282C31CC; Fri, 8 Apr 2016 17:45:58 +0200 (CEST) X-Yow: WHOA!! Ken and Barbie are having TOO MUCH FUN!! It must be the NEGATIVE IONS!! In-Reply-To: <1460111062-4420-1-git-send-email-baron@bundesbrandschatzamt.de> (Andreas Gerler's message of "Fri, 8 Apr 2016 10:24:22 +0000") User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.0.92 (gnu/linux) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] X-Received-From: 208.118.235.43 X-BeenThere: bug-gnu-emacs@gnu.org List-Id: "Bug reports for GNU Emacs, the Swiss army knife of text editors" List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane.org@gnu.org Original-Sender: "bug-gnu-emacs" Xref: news.gmane.org gmane.emacs.bugs:116216 Archived-At: Andreas Gerler writes: > (`postgresql (format > - "psql --set=\"ON_ERROR_STOP=1\" %s -A -P \ > + "%s psql --set=\"ON_ERROR_STOP=1\" %s -A -P \ > footer=off -F \"\t\" %s -f %s -o %s %s" > + (if dbpassword (concat "PGPASSWORD='" dbpassword "'") "") This will fail if dbpassword contains ?\'. Environment variables should be passed via process-environment. Andreas. -- Andreas Schwab, schwab@linux-m68k.org GPG Key fingerprint = 58CA 54C7 6D53 942B 1756 01D3 44D5 214B 8276 4ED5 "And now for something completely different."