Re: timeout implementation issues

Поиск
Список
Период
Сортировка
Искать
От
Zeugswetter Andreas SB SD
Тема
Re: timeout implementation issues
Дата
Msg-id
46C15C39FEB2C44BA555E356FBCD6FA4961D97@m0114.s-mxs.net
Список
Дерево обсуждения
timeout implementation issues Jessica Perry Hekman <jphekman@dynamicdiagrams.com>
Re: timeout implementation issues Tom Lane <tgl@sss.pgh.pa.us>
Re: timeout implementation issues Bruce Momjian <pgman@candle.pha.pa.us>
Re: timeout implementation issues Jessica Perry Hekman <jphekman@dynamicdiagrams.com>
Re: timeout implementation issues Tom Lane <tgl@sss.pgh.pa.us>
Re: timeout implementation issues Jessica Perry Hekman <jphekman@dynamicdiagrams.com>
Re: timeout implementation issues Tom Lane <tgl@sss.pgh.pa.us>
Re: timeout implementation issues Jessica Perry Hekman <jphekman@dynamicdiagrams.com>
Re: timeout implementation issues Jessica Perry Hekman <jphekman@dynamicdiagrams.com>
Re: timeout implementation issues Bruce Momjian <pgman@candle.pha.pa.us>
Re: timeout implementation issues Tom Lane <tgl@sss.pgh.pa.us>
Re: timeout implementation issues Jan Wieck <janwieck@yahoo.com>
Re: timeout implementation issues Jessica Perry Hekman <jphekman@dynamicdiagrams.com>
Re: timeout implementation issues Tom Lane <tgl@sss.pgh.pa.us>
Re: timeout implementation issues Jessica Perry Hekman <jphekman@dynamicdiagrams.com>
Re: timeout implementation issues Bruce Momjian <pgman@candle.pha.pa.us>
Re: timeout implementation issues Jessica Perry Hekman <jphekman@dynamicdiagrams.com>
Re: timeout implementation issues Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] timeout implementation issues
Re: timeout implementation issues Jessica Perry Hekman <jphekman@dynamicdiagrams.com>

> So the work that would need to be done is asking the driver to request the
> timeout via "BEGIN WORK TIMEOUT 5"; getting the backend to parse that
> request and set the alarm on each query in that transaction; getting the

Well imho that interpretation would be completely unobvious. 
My first guess would have been, that with this syntax the whole transaction 
must commit or rollback within 5 seconds.

Thus I think we only need statement_timeout. ODBC, same as JDBC wants it at the 
statement handle level. ODBC also provides for a default that applies to all 
statement handles of this connection (They call the statement attr QUERY_TIMEOUT,
so imho there is room for interpretation whether it applies to selects only, which 
I would find absurd).

Andreas

В списке pgsql-hackers по дате отправления
От: Robert Schrem
Дата:
От: Hiroshi Inoue
Дата:
FAQ