raise notice causes driver to crash
От | Alex Balan |
---|---|
Тема | raise notice causes driver to crash |
Дата | |
Msg-id | 4CA234B7.8020303@carainformation.com обсуждение исходный текст |
Ответы |
Re: raise notice causes driver to crash
|
Список | 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
Вложения
В списке pgsql-odbc по дате отправления: