odbc:sql_query error using postgres
Alexey Shchepin
alexey@REDACTED
Sun Nov 13 22:42:58 CET 2005
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.
More information about the erlang-questions
mailing list