Re: timeout implementation issues - Mailing list pgsql-hackers

From Jessica Perry Hekman
Subject Re: timeout implementation issues
Date
Msg-id Pine.LNX.4.21.0204011044580.8553-100000@atalanta.dynamicdiagrams.com
Whole thread Raw
In response to Re: timeout implementation issues  (Jessica Perry Hekman <jphekman@dynamicdiagrams.com>)
Responses Re: timeout implementation issues  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: timeout implementation issues  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: RI triggers and schemas
Next
From: Jan Wieck
Date:
Subject: Re: Data integrity and sanity check