Re: timeout implementation issues

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Jan Wieck" <janwieck(at)yahoo(dot)com>, "Jessica Perry Hekman" <jphekman(at)dynamicdiagrams(dot)com>, "Barry Lind" <barry(at)xythos(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: timeout implementation issues
Date: 2002-04-08 21:14:46
Message-ID: EKEJJICOHDIEMGPNIFIJKEMCHGAA.Inoue@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> -----Original Message-----
> From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> >
> > OK using your example, one by one
> >
> > BEGIN WORK;
> > SET query_timeout=20;
> > query fails;
> > SET query_timeout=0;
> >
> > For what the SET was issued ?
> > What command is issued if the query was successful ?
> >
> > COMMIT WORK;
>
> Here, SET should only to the query labeled "query fails".

Why should the SET query_timeout = 0 command be issued
only when the query failed ? Is it a JDBC driver's requirement
or some applications' requirements which uses the JDBC driver ?

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-04-08 21:15:41 Re: timeout implementation issues
Previous Message Bruce Momjian 2002-04-08 18:05:03 Re: timeout implementation issues