Re: How to change PQexec timeout?

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