[ODBC] weird problem when running a sql stmt - Mailing list pgsql-odbc

Hi.
I have those version:
--8<---------------cut here---------------start------------->8---
psqlodbc 09.05.0400
postgresql 9.6.1-3
--8<---------------cut here---------------end--------------->8---

This is my .odbc.ini (my odbcinst.ini file is empty):
--8<---------------cut here---------------start------------->8---
[invcross_test]
Driver              = /usr/lib/psqlodbcw.so
Database            = invcross_test
--8<---------------cut here---------------end--------------->8---

My c prg connects using dsn:
--8<---------------cut here---------------start------------->8---
dsn=invcross_test;uid=okipuyuc
--8<---------------cut here---------------end--------------->8---

This is my table:
--8<---------------cut here---------------start------------->8---
\d store_product_detail_envers
invcross_test=>                                             Table "public.store_product_detail_envers"
         Column          |            Type             |                                Modifiers
          

-------------------------+-----------------------------+--------------------------------------------------------------------------
 id                      | integer                     | not null default
nextval('store_product_detail_envers_id_seq'::regclass)
 store_product_detail_id | integer                     | not null
 value                   | numeric(19,2)               | not null
 effect_date             | timestamp without time zone | not null
 end_date                | timestamp without time zone |
 enable                  | smallint                    | not null
 type                    | character(1)                | not null
 created_by              | integer                     | not null
 updated_by              | integer                     |
 created_at              | timestamp without time zone | not null
 updated_at              | timestamp without time zone |
Indexes:
    "store_product_detail_envers_pkey" PRIMARY KEY, btree (id)
    "ifk_store_product_detail__enve" btree (store_product_detail_id)
    "store_product_detail_envers_fkindex1" btree (store_product_detail_id)
Foreign-key constraints:
    "store_product_detail_envers_store_product_detail_id_fkey" FOREIGN KEY (store_product_detail_id) REFERENCES
store_product_details(id)
--8<---------------cut here---------------end--------------->8---


When running this statement:
--8<---------------cut here---------------start------------->8---
update store_product_detail_envers set end_date =now(), updated_by =1, updated_at =now() where store_product_detail_id
=2and end_date IS NULL and type ='C'; 
--8<---------------cut here---------------end--------------->8---

I get this from the extract_error function:
--8<---------------cut here---------------start------------->8---
The driver reported the following diagnostics whilst running:
update store_product_detail_envers set end_date =now(), updated_by =1, updated_at =now() where store_product_detail_id
=2and end_date IS NULL and type ='C'; 
--8<---------------cut here---------------end--------------->8---

If the statement is run from isql (it Works):
--8<---------------cut here---------------start------------->8---
isql invcross_test okipuyuc
--8<---------------cut here---------------end--------------->8---

Any idea how to solve  Or Debug this?

Also I tried adding this on .odbc.ini (no idea where the logs are):
--8<---------------cut here---------------start------------->8---
Debug = 1
CommLog = 1
--8<---------------cut here---------------end--------------->8---

My distro is Archlinux. Regards