adding code before org-babel sql execution (postgres engine)

[dmg <dmg@turingmachine.org>]

[-- Attachment #1: Type: text/plain, Size: 1046 bytes --]

Hi there

I have been using or-sql with postgres backend for a long time.
There has been one annoyance that I finally fixed.

When the SQL command has an error, it simply outputs
and empty table:

#+begin_src sql :engine postgresql :cmdline  imdb
select * from abc
#+end_src

#+RESULTS:

The error is not detected. I read the documentation of psql and the problem
seems to be that psql does not return an error code by default (even with
invalid
commands).

This can be fixed two ways:

1. add to ~/.psqlrc

\set ON_ERROR_STOP on

2. By adding to the command, before it is executed by babel, this line. In
non-interactive mode psql will stop in the first error with an error code
and babel will catch it:

psql:/tmp/babel-51865ab/sql-in-5186Wyu:1: ERROR:  relation "abc" does not
exist
LINE 1: select * from abc
                      ^
I am willing to implement #2, but the question is, is there a clean, easy
way
to do this? Any hints on how to do it?

thank you very much,

--daniel




-- 
--dmg

---
Daniel M. German
http://turingmachine.org

[-- Attachment #2: Type: text/html, Size: 3889 bytes --]