Re: timeout implementation issues

Hiroshi Inoue wrote:
> > -----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 ?

They want the timeout for only the one statement, so they have to set it
to non-zero before the statement, and to zero after the statement. In
our current code, if the query fails, the setting to zero is ignored,
meaning all following queries have the timeout, even ones outside that
transaction.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026