> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.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