I am facing the following problem.
Our application sends a block of queries to postgres in a begin end block. If one of the queries take a long time to finish the whole transaction is assumed to be committed by the application even though the query is still running . This results in failure of all subsequent transactions.
Although the application is programmed to catch all exceptions , it somehow is not able to figure out that the transaction is still not complete.
I am using postgres 8.3
with regards
Nalini