Tom Lane wrote:
"Simon Riggs" <[EMAIL PROTECTED]> writes:
We only care when they break, otherwise its just situation normal, yes?
No, the trouble case is where the XA manager that owns the transaction
has forgotten about it.
Yeah, and there's no way the DBMS can detect that.
Is there a way
On Fri, 3 Nov 2006, Tom Lane wrote:
>
> > Is there a way to see prepared transactions where the original session
> > that prepared then has died? Perhaps the message at startup should be
> > "you have at least one prepared transaction that needs resolution".
>
> I am completely baffled by this foc
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> We only care when they break, otherwise its just situation normal, yes?
No, the trouble case is where the XA manager that owns the transaction
has forgotten about it.
> Is there a way to see prepared transactions where the original session
> that prepar
On Fri, 2006-11-03 at 01:48 -0500, Tom Lane wrote:
> I agree that there's a usability issue here though; I've been burnt by
> forgotten prepared xacts myself (eg by control-C'ing pg_regress at just
> the wrong time). Would it help if we included prepared xacts in the
> pg_stat_activity view?
>
