Erlang Mailing Lists
Author Message

<  Erlang bugs mailing list  ~  odbc:sql_query error using postgres
alexey at sevcom.net
Posted: Sun Nov 13, 2005 9:47 pm Reply with quote
Guest
Hi!

When using postresql 7.4 or 8.0, odbc:sql_query returns error result if
DELETE query remove no records from table, while it should return {update,0}:

$ erl
Erlang (BEAM) emulator version 5.4.10 [source] [threads:0]

Eshell V5.4.10 (abort with ^G)
1> {ok, Ref} = odbc:connect("DSN=ejabberd;UID=ejabberd;PWD=ejabberd", [{scrollable_cursors, off}]).

=INFO REPORT==== 13-Nov-2005::23:16:10 ===
The odbc application was not started. Has now been started as a temporary application.
{ok,<0.38.0>}
2> odbc:sql_query(Ref, "delete from users where username='zzz'").
{error,"No SQL-driver information available."}
3> odbc:sql_query(Ref, "insert into users values ('zzz', 'zzz')").
{updated,1}
4> odbc:sql_query(Ref, "delete from users where username='zzz'").
{updated,1}
5> odbc:sql_query(Ref, "delete from users where username='zzz'").
{error,"No SQL-driver information available."}

Tested on R10B-7 and R10B-8.


Post generated using Mail2Forum (http://m2f.sourceforge.net)
Back to top

Display posts from previous:  

All times are GMT
View next topic
View previous topic
Page 1 of 1
Erlang Forum - Trap Exit Forum Index  ~  Erlang bugs mailing list
This forum is locked: you cannot post, reply to, or edit topics.

Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
Hosted by Erlang Solutions    |    Powered by phpBB and NoseBleed v1.14