>>>>> "Colin" == Colin Paul Adams <[EMAIL PROTECTED]> writes:
Peter> Maybe I'm missing something, but why aren't you setting
Peter> your database transaction timeout limit to something just a
Peter> bit larger than the session timeout?
Colin> Well, I guess this is fine for a database server dedicated
Colin> to the application (which is OK for my usage). But it's
Colin> not a general solution to resources being held by sessions.
Colin> I thought I'd raise the issue while listeners were being
Colin> discussed.
In fact, checking the documentation for postgresql, it doesn't have
transaction timeout, only statement timeout, which certainly isn't adequate.
--
Colin Paul Adams
Preston Lancashire
