Gregg Jaskiewicz wrote:
> Also, on the subject of prepared transactions (2PC), the "select *
> from pg_prepared_xacts ;" query simply does not reveal anything,
> despite the fact that I know that there should be at least two of
> those open.
> Unless it only list saved transactions, not a transaction in the
> middle of operation.
Transactions only appear there between the PREPARE statement and the
COMMIT. Hopefully that is a small window of time for each
transaction.
-Kevin
