"Simon Riggs" <simon@2ndquadrant.com> 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 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 focus on database startup time. That's
not where the problem is.
regards, tom lane