Re: Help with hang on empty query (PG 7.3.2, - Mailing list pgsql-odbc

From Tom Lane
Subject Re: Help with hang on empty query (PG 7.3.2,
Date
Msg-id 7224.1068308317@sss.pgh.pa.us
Whole thread Raw
In response to Re: Help with hang on empty query (PG 7.3.2,  (Steve Wampler <swampler@noao.edu>)
List pgsql-odbc
Steve Wampler <swampler@noao.edu> writes:
>> I've installed from source psqlodbc-07.03.0200 (pthread
>> and iodbc support).  From the logs it looks as though the
>> connection is succeeding up to the point that an
>> empty query is sent (dunno why the empty query is being
>> sent - it appears to be part of the connection procedure).
>> At this point the connection hangs - no messages, or errors.

I'm just guessing, but my first guess is that the empty-query path in
the driver fails to do an fflush() to push out the query to the backend.
You could possibly confirm this by sniffing the connection with a packet
monitor to see what is the last data sent by the client side.

            regards, tom lane

pgsql-odbc by date:

Previous
From: Steve Wampler
Date:
Subject: Re: Help with hang on empty query (PG 7.3.2,
Next
From: Timothy Reaves
Date:
Subject: Re: help with OSX make problem