Hiroshi Inoue wrote: > > > Why should the timeout be reset automatically ? > > > > It doesn't need to be reset automatically, but the problem is that if > > you are doing a timeout for single statement in a transaction, and that > > statement aborts the transaction, the SET command after it to reset the > > timeout fails. > > As for ODBC, there's no state that *abort* but still inside > a transaction currently.
Yes, the strange thing is that SET inside a transaction _after_ the transaction aborts is ignored, while SET before inside a transaction before the transaction aborts is accepted. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
