Tom Lane wrote: > Jan Wieck <[EMAIL PROTECTED]> writes: > > Could we get out of this by defining that "timeout" is > > automatically reset at next statement end? > > I was hoping to avoid that, because it seems like a wart. OTOH, > it'd be less of a wart than the global changes of semantics that > Bruce is proposing :-( > > How exactly would you make this happen? The simplest way I can think of > to do it (reset timeout in outer loop in postgres.c) would not work, > because it'd reset the timeout as soon as the SET statement completes. > How would you get the setting to survive for exactly one additional > statement?
I would vote for a general callback registering mechanism, where you can specify an event, a function and an opaque pointer. Possible events then would be end of statement, end of transaction, commit, abort, regular end of session. Sure, it looks like total overkill for this minor JDBC problem. But I like general support structures to be in place early. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] # ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster