From mboxrd@z Thu Jan  1 00:00:00 1970
From: Seb <spluque@gmail.com>
Subject: SQL support in Babel
Date: Thu, 20 Nov 2014 09:23:20 -0600
Message-ID: <87vbm9hp5j.fsf@net82.ceos.umanitoba.ca>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:34654)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1XrTa7-0008C8-Gc
	for emacs-orgmode@gnu.org; Thu, 20 Nov 2014 10:23:45 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1XrTa1-000299-7Y
	for emacs-orgmode@gnu.org; Thu, 20 Nov 2014 10:23:39 -0500
Received: from plane.gmane.org ([80.91.229.3]:45371)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1XrTa1-00028r-1f
	for emacs-orgmode@gnu.org; Thu, 20 Nov 2014 10:23:33 -0500
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1XrTZz-0007h4-Tj
	for emacs-orgmode@gnu.org; Thu, 20 Nov 2014 16:23:31 +0100
Received: from net82.ceos.umanitoba.ca ([130.179.67.82])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Thu, 20 Nov 2014 16:23:31 +0100
Received: from spluque by net82.ceos.umanitoba.ca with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Thu, 20 Nov 2014 16:23:31 +0100
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

Hi,

The last code block in ob-doc-sql¹ suggests I should be able to place a
number of #+HEADER lines above my SQL source code to specify the
connection string.  I am trying to connect to a remote PostgreSQL
server, and after lots of experimentation, the only way this works for
me is to have a single #+HEADER line with a :cmdline with the entire
connection string.  All the other header arguments (:database, :dbuser,
etc.), whether in separate lines or in a single one, seem to be
completely ignored.  Using Org 8.2.10 and Emacs 24.4.1 from Debian Sid
packages.  Is this a problem with this version combination, or does the
functionality of the header arguments depend on the engine being used?
Thanks.


+--- Footnotes ---+
¹ http://orgmode.org/worg/org-contrib/babel/languages/ob-doc-sql.html

-- 
Seb