Re: [q-lang-users] Cannot query table after odbc_columns

[Jiri S. <jir...@bl...>]

Albert Graef wrote:
> I don't have an ODBC install right now to test this, but I remember 
> running this on Linux (using MySQL, I guess) and it worked. The code 
> looks ok (in fact I lifted it from an MSDN page). Can you reproduce this 
> with Postgres on Linux?
> 

Yes, I can:

==> import odbc

==> def A = odbc_connect "DSN=efom"

==> odbc_columns A "units"
[("sector","varchar",(),()),("producer","varchar",(),()), ..............

==> sql A "select * from units" ()
q[pid 8967]: caught signal 11 (Segmentation fault), printing 
backtrace... 2 stack frames
q(__qq__segv_handler+0x8c)[0x8050d8c]
[0xb7f4b420]
Segmentation fault

OTOH, it is nothing urgent. There is an easy workaround - I can open the 
DB twice and perform SSQLs on the second DB handle.

Cheers,

Jiri