On Wed, 13 Mar 2002, Bruce Momjian wrote: > You bet, but it would be done in the backend, not in jdbc. Is that OK?
Theoretically this is okay. I am more comfortable in Java than in C and I hadn't looked at the backend code at all, but I'll take a peek and see if it looks like something I'd feel comfortable doing. > I have some ideas that should make it pretty easy. If you set an > alarm() in the backend on transaction start, then call the query > cancel() code if the alarm() goes off, that should do it. Of course, > you reset the alarm if the query finishes before the timeout. Sounds straightforward enough. Hopefully I'll get a chance to look at this before the end of this week. Thanks! Jessica ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html