On lör, 2010-01-23 at 12:42 -0500, Tom Lane wrote: > Peter Eisentraut <pete...@gmx.net> writes: > > Was there a designed-in reason not to have psql tab completion for > > COMMIT/ROLLBACK PREPARED ...? It does complete the "PREPARED" but not > > the transaction identifiers. Maybe it's not a common use case, but > > these transaction identifiers sure can be nontrivial to type. > > Hmm, what's the use scenario? I would think that painfully long > gxids would come from some XA manager software, which would be > responsible for committing or canceling them. Manual override > of that would usually be a bad idea.
The scenario that I encountered is that you go around manually cleaning them up when the XA software fails for some reason. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers