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 |
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 |