> -----Original Message-----
> From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
> > 
> > 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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to