query timeout

From: Ondrej Dzivy Balucha <balucha(at)horizon(dot)sk>
To: pgsql-odbc(at)postgresql(dot)org
Subject: query timeout
Date: 2015-12-21 13:27:36
Message-ID: 5677FE48.8010100@horizon.sk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi

Is there any keyword to setup query timeout? I have ODBC connection to
remote PostgreSQL database.
I connect to db with isql (for example), send query and i get result.
Now connection lost(disconnected cable or other problem) and I send next
query. No answer or error message and isql waiting and waiting and ....
waiting(I was waiting for 20 minutes and no response). Is there any way
to setup timeout in odbc.ini or odbcinst.ini?

I know that ibm DB2 has this keyword in db2 client(ReceiveTimeout = time
in seconds to wait for a reply from the server on an established
connection before terminating the attempt and generating a communication
timeout error). If I setup ReceiveTimeout = 5 , than I get error after 5
seconds when no response.
I need setup this for PostgreSQL.

Regards

--
Ondrej Dzivy Balucha
Horizon, s.r.o. Prešov
Francisciho 21
08001 Prešov
tel/fax +421517491400/02

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Heikki Linnakangas 2015-12-21 13:34:13 Re: query timeout
Previous Message Heikki Linnakangas 2015-12-21 12:58:57 Re: SQL_DATA_AT_EXEC processing broken for large objects in nightly git