[KLUG Members] SuSe 9.2 & unixODBC

[Adam Tauno Williams]

> > Has anyone used a unixODBC connection in SuSe 9.2?  In particular I am
> > using the PostgreSQL driver.  I can connect, and query, but upon
> > disconnect (db_close) the process hangs; this happens in all the
> > applications.  Anyone else see this behaviour?
> I haven't tried it yet on SuSE 9.2, but I have been thinking about it.
> Which process hangs?

And I'm mistaken,  this WORKS on my SuSe 9.2 box, and NOT on my 9.1 box.

throw:~ # isql ogo adam *********
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select count(*) from enterprise;
+---------------------+
| count               |
+---------------------+
| 705                 |
+---------------------+
SQLRowCount returns 1
1 rows fetched
SQL> quit

Hung now!

strace output -

write(1, "SQLRowCount returns 1\n", 22SQLRowCount returns 1
) = 22
write(1, "1 rows fetched\n", 151 rows fetched
)        = 15
semop(1376271, 0xbfff7180, 2)           = 0
semop(1376271, 0xbfff7190, 1)           = 0
write(1, "SQL> ", 5SQL> )                    = 5
read(0, quit
"quit\n", 1024)                 = 5
send(3, "X\0", 2, 0x4000)               = 2
send(3, "X", 1, 0x4000)                 = 1
close(3)                                = 0
munmap(0x401f8000, 442292)              = 0
munmap(0x4026c000, 85152)               = 0
munmap(0x40281000, 197692)              = 0
munmap(0x402b2000, 137712)              = 0