Обсуждение: raise notice causes driver to crash

Поиск
Список
Период
Сортировка

raise notice causes driver to crash

От
Alex Balan
Дата:
  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
Вложения

Re: raise notice causes driver to crash

От
Hiroshi Inoue
Дата:
Hi Alex,

(2010/09/29 3:32), Alex Balan wrote:
> 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.

Maybe this bug was already fixed.
Could you please try the drivers on testing for 8.4.0202 at
  http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/
?

regards,
Hiroshi Inoue

> 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