raise notice causes driver to crash

From: Alex Balan <alex(dot)balan(at)carainformation(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: raise notice causes driver to crash
Date: 2010-09-28 18:32:23
Message-ID: 4CA234B7.8020303@carainformation.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

raise notice - displaying string having length over 4096 characters
causes crash in ODBC ANSI driver but seems to be ok on 7.4.3 driver.

Driver: psqlODBC ANSI ver. 8.4.2
Database: PostgreSQL 8.1.5 on i686-redhat-linux-gnu
Error: Faulting application vb6.exe, version 6.0.97.82,
faulting module psqlodbc30a.dll, version 8.4.2.0, fault
address 0x00045431.

Notes: Version 7.4.3 of psqlodbc driver driver does not expose
this issue

Calling procedure from VB

Const strConnect = "DRIVER={PostgreSQL
ANSI};DATABASE=test-medsql-alder;SERVER=192.168.100.77;PORT=5432;

UID=postgres;PWD=secret;ByteaAsLongVarBinary=1;MaxLongVarcharSize=-4;"
conn.ConnectionString = strConnect
conn.Open
Set RCS = conn.Execute("SELECT * FROM
select_patient_all_visit_data(77.00,'')")

Called pl/pgsql function

--sqltext is dynamically built here with a LENGTH OVER 4096 characters

--next line if enabled causes crash
--*********************************
--raise notice '%',sqltext;
--*********************************

FOR ret_row IN EXECUTE sqltext LOOP
return next ret_row;
END LOOP;
return;

Hope this helps track down the issue(s) if any...
Alex Balan

Attachment Content-Type Size
mylog_3260.log text/plain 27.8 KB

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2010-09-29 00:04:26 Re: raise notice causes driver to crash
Previous Message Allen Krause 2010-09-27 19:27:41 unable to connect to postgresql datasource