Re: timeout implementation issues

Jessica Perry Hekman <jphekman@dynamicdiagrams.com>

From: Jessica Perry Hekman <jphekman@dynamicdiagrams.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, pgsql-hackers@postgresql.org
Date: 2002-04-01T15:49:04Z
Lists: pgsql-hackers
> On Sat, 30 Mar 2002, Tom Lane wrote:
> 
> > Au contraire, it is not assuming anything.  It is sending off a cancel
> > request and then waiting to see what happens.  Maybe the query will be

Okay, I see now: when processCancelRequest() is called, a return of 127 is
sent. That would indeed work; thanks for walking me through it.

My other question was how to send the timeout value to the backend. Bruce
said at one point:

> Timeout can be part of BEGIN, or a SET value, which would work from
> jdbc.

I'm not sure how this would work. The timeout value would be sent as part
of a SQL query?

j