Tom Lane wrote: > > Hannu Krosing <[EMAIL PROTECTED]> writes: > > Is there a way to automatically ROLLBACK transactions that are > > in "idle in transaction" for too long ? > > Nope, we don't have anything for that. Not clear to me that it's > appropriate as a server-side function anyway.
This can't be done from the client side and we do have other types of deadlock detection on server side so this seems to quite appropriate from where I stand. I guess it would be quite nice to have as a connection-level setting, so that things that benefit from it can set it to some reasonable value while others that want to behave unsocially can do it as well ;) The default could be 1-3 sec of idle time in transaction for typical client-server and web apps while command line clients (like psql) could set it to something more automatically. ----------------- Hannu ---------------------------(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
