"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 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate