Re: transaction timeout

We have statement_timeout, but no transaction timeout.  Does that help?

---------------------------------------------------------------------------

Eugene Strulyov wrote:
> Hi everybody,
>
> Our aplpication uses PostgreSQL for data store. We have a problem with the way
> long-running transactions are handled.
>
> Our application had a bug (from what I understand it went into an infinite
> loop). As a result, the transaction it was processing was neither committed
> nor rolled back. Because of that, the misbehaving process was left holding
> the locks and none of the other processes were able to do transactions.
>
> My question is, how do I get PostgreSQL to automatically abort transactions
> that take longer than a certain timeout?
>
> thanks in advance,
>
> Eugene
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073