On Jan 15, 2009, at 8:43 AM, Wright, George wrote:
> Then if there is a large amount of code all wrapped by a single
> transaction and it hangs somewhere in the code, what technique can be
> used to abort the transaction? (It's not really a deadlock)
I believe there is a statement timeout setting where an automatic
abort could be executed. If you want to abort a running query manually
see pg_cancel_backend:
http://www.postgresql.org/docs/8.3/interactive/functions-admin.html
John DeSoi, Ph.D.
