another transaction question

From: "Wright, George" <George(dot)Wright(at)infimatic(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: another transaction question
Date: 2009-01-14 19:56:10
Message-ID: 51548D6D5BEB57468163194A8C1A0E980161AB1B@MAGPTCPEXC02.na.mag-ias.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

There doesn't appear to be a 'transaction timeout' mechanism for the
transaction that wraps a PL/pgSQL function. So if the code hangs, it
would appear that the transaction will as well unless statement_timeout
is set.

Is there a better way to prevent a transaction hang without globally
limiting a statement timeout?

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Raphael Bauduin 2009-01-15 11:29:17 order by differences: locale problem?
Previous Message Christopher Browne 2009-01-14 15:47:54 Re: function transaction scope question