From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id EgJ9M/MTGWFMJQAAgWs5BA (envelope-from ) for ; Sun, 15 Aug 2021 15:17:39 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id +DBiLvMTGWG+QgAAbx9fmQ (envelope-from ) for ; Sun, 15 Aug 2021 13:17:39 +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 C64EC1D50 for ; Sun, 15 Aug 2021 15:17:38 +0200 (CEST) Received: from localhost ([::1]:44822 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mFG1B-0008EV-0D for larch@yhetil.org; Sun, 15 Aug 2021 09:17:37 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:55928) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mFG0n-0008EL-AE for emacs-orgmode@gnu.org; Sun, 15 Aug 2021 09:17:13 -0400 Received: from esa04.ucs.mun.ca ([134.153.136.24]:32251) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mFG0l-0005YV-77 for emacs-orgmode@gnu.org; Sun, 15 Aug 2021 09:17:12 -0400 IronPort-SDR: r2kLY+EPze1UHery9BuUxO2rTyKaYC1EVf18kpMXlti7UMGgILgAmzJJIcsl7uRc9+12k1Sfwd T24OtnUyeH7FqzMWBwHYpv4O37V5zbb+kBX3hn3Y6hygt3vhlk/ZjvZB9mPMDv7+bKKjBoKGvL M9nOJP5ZezOFKN+1F2WQcF0P+/8iAxaHQZg3r9P8/4AJHqmmqXKZ/69NkOWJbbCg+/CbM6GTgj lEicoy+HYlXhBG6TZyFMMuQ1nI+1ZjWpVO3udJmOwN0d6FBi8ZI31u3mfbdUGlWVvqGckcWpIz +Z4= IronPort-HdrOrdr: =?us-ascii?q?A9a23=3AHRy7UKMG69W4xcBcTtyjsMiBIKoaSvp037?= =?us-ascii?q?BL7SBMoHNuHfBw+/rFoB15737JYVQqNk3I8OroUJVoKkmxyXca2+QsFIu5UB?= =?us-ascii?q?KjsGWlK5wK1+Df/wE=3D?= X-IronPort-AV: E=Sophos;i="5.84,322,1620700200"; d="scan'208";a="63801407" X-Amp-Result: SKIPPED(no attachment in message) X-Amp-File-Uploaded: False Received: from cpe00fc8db7a323-cm00fc8db7a320.cpe.net.cable.rogers.com (HELO pyrope.local) ([174.117.202.255]) by smtp04.ucs.mun.ca with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 15 Aug 2021 10:47:05 -0330 User-agent: mu4e 1.5.6; emacs 27.2 From: Roger Mason To: orgmode Subject: Plotting with R Date: Sun, 15 Aug 2021 10:47:02 -0230 Message-ID: MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=134.153.136.24; envelope-from=rmason@mun.ca; helo=esa04.ucs.mun.ca X-Spam_score_int: -41 X-Spam_score: -4.2 X-Spam_bar: ---- X-Spam_report: (-4.2 / 5.0 requ) BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, SPF_HELO_NONE=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-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1629033459; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type:list-id:list-help:list-unsubscribe: list-subscribe:list-post; bh=2g3no54q0qQtOyc380lnepH6TyxTSVEfUFS/kL5db5Y=; b=MRxRC/UJXB9zv459BCvIgKH1ZdrcpSQUe5BTzoAJ+J8UvFhxniwb2JoaeFgFS++3MQzvbN AsfId7nIsm/t/cJVUezuL+do5XPevnmu732bT9OXonMCvLreHxvyDsva0jUbaAMNG/4zAu oodGqK6dPO4SbfuwZt+Z5ZRExbIeRHAfTMF4gCfU8ca0YLBKpGj5su6nf+6dfshYKRnypQ G3yM8WAkORUcdyazcTJ5GZeVZSTMObyytM/g9YlkLrwAMOQYkjT5Rs4LoXo38yap1exjs/ 4MlJVvX/o2dr7K4lHq1Zb8ztucDquXBxtzqjR6WRdgeGpA8ENzzRei2G4nyKAg== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1629033459; a=rsa-sha256; cv=none; b=feeeczQzaqTNFFfa+gqjTvf3K1d2jVjs7v/h3Pp6c/3iGEevh8DE6d3aK3dtQJ37/O4mmC AXJNMgoiCYsIR97ViszdfycZP2mF2cNpLEB0ImN0IRXbjKEt1+KjLUHuNOhGxX7rkzBZaT rYdOFr8YbFsiM2e62WpsU0n6LNK0YLFVlGDcNq7SnadYBsmH/pG4Wzctv7/e7N4qtdXLwd ZwwEB6nbbik/K2EUrLEkJc3Ugz5qCie85aCuDHRrJIBhWI6f7G3PdDBM4C8EZnbprobkmh UkOQrJ79F3BS8idg3Zt7b4KYfkGIVuq3EO7ENfJrej4jL9m2OUm0n2Z+dWmp8A== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=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-Migadu-Spam-Score: -2.41 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-Migadu-Queue-Id: C64EC1D50 X-Spam-Score: -2.41 X-Migadu-Scanner: scn1.migadu.com X-TUID: kZhRzpWgbGJ6 Hello, I want graphics output from R: #+begin_src R :results output grahics file :file coa_vs_a.pdf :exports results library(tidyverse) library(RPostgreSQL) drv <- dbDriver("PostgreSQL") con <- dbConnect(drv, user="rmason",dbname="test") rs <- dbSendQuery(con,"with CTE as (select split_part(split_part(lattice_out, E'\n', 13), ' ', 18) as c, split_part(split_part(lattice_out, E'\n', 11), ' ', 11) as a from results where timestamp like '20210814-071%' order by a) select cast(a as double precision), cast(c as double precision)/ cast(a as float) as coa from CTE;") df <- fetch(rs) theplot <- ggplot(df,aes(x=a,y=coa)) + geom_point() theplot #+end_src What I expect is a file 'coa_vs_a.pdf' on my filesystem & a link to it in the org buffer. What I get is a file 'Rplots.pdf' and an empty file 'coa_vs_a.pdf' with a link to the latter in the org buffer. I've searched this topic and I _think_ the invocation above, one of many I've tried, should work. GNU Emacs 27.2 (build 1, amd64-portbld-freebsd11.4, X toolkit, cairo version 1.16.0, Xaw3d scroll bars) Org mode version 9.2.3 (release_9.2.3-390-gfb5091 @ /home/rmason/.emacs.d/org-git/lisp/) Thanks for your help. Roger