<div dir="ltr">Hello.<br><br>As addition to the previous message on pgsql. Such code:<br><br>pgsql:pquery(Db, "INSERT INTO foo VALUES ($1)", [555])<br><br>also doesn't work, producing the error:<br><br>------------------------------------------------------------------------<br>
** exception exit: {timeout,<br>                       {gen_server,call,<br>                           [<0.131.0>,<br>                            {equery,{"INSERT INTO foo VALUES ($1)",[2]}}]}}<br>     in function  gen_server:call/2<br>
     in call from gin_test:storage/0<br>------------------------------------------------------------------------<br><br>The only way I see to do insert is:<br><br>Query = lists:flatten(io_lib:format("INSERT INTO foo VALUES (~p)", [555]))<br>
pgsql:squery(Db, Query)<br><br>But it's not so fast...<br><br>Jungerl have the same problems, since pgsql from ejabberd-modules is a fork of pgsql from jungerl.<br><br>psql from <a href="http://code.google.com/p/erlang-psql-driver/">http://code.google.com/p/erlang-psql-driver/</a> seems to be unmaitaine<strong></strong>d (Project status: this project was just a proof of concept and is currently unmaintained)<br>
<br>Driver from Erlang Consulting is too old.<br><br>ODBC?<br><br>Which driver do you you with PostgreSQL?<br><br><div class="gmail_quote"><br>Thanks.<br><br>--<br>Sergey<br></div></div>