Re: How to change PQexec timeout?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: How to change PQexec timeout?
Дата
Msg-id 200311100202.hAA22kP12834@candle.pha.pa.us
обсуждение исходный текст
Ответ на How to change PQexec timeout?  (Sergey Belikov <belikov@bnl.gov>)
Список pgsql-novice
Sergey Belikov wrote:
> Dear postgreSQL experts,
> could you explain me how can I dynamically change  time-out value for
> each PQexec() call? Or at least how can I set time-out for my current
> program?
> I found
> void setQueryTimeout (int seconds)
> in libodbc++ documentation, but nothing of this kind in libpq. Should I
> install libodbc++ to manipulate time-out value, or there is something in
> postgreSQL itself?

Sure use 'SET statement_timeout = 30' for 30 milliseconds.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

В списке pgsql-novice по дате отправления:

Предыдущее
От: Michael Grant
Дата:
Сообщение: Re: 'pg_ctl status' not working
Следующее
От: Jeff Eckermann
Дата:
Сообщение: Re: COPY with null