[ODBC] weird problem when running a sql stmt
От | sunshavi@fastmail.fm (Andrés Ramírez) |
---|---|
Тема | [ODBC] weird problem when running a sql stmt |
Дата | |
Msg-id | 87eg1ae6i0.fsf@fastmail.fm обсуждение исходный текст |
Список | 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
В списке pgsql-odbc по дате отправления:
Предыдущее
От: Igor KorotДата:
Сообщение: Re: Connection failed [was: Re: Distribution package for OSX]