Re: 2PC-induced lockup

Andrew Sullivan wrote:
> On Wed, Jul 11, 2007 at 06:15:12PM +0100, Heikki Linnakangas wrote:
>> It's effectively the same as manually issuing a ROLLBACK PREPARED. It 
>> will brake the atomicity of the global transaction, if some branches of 
>> that global transaction in other resource managers have already been 
>> committed.
> 
> But how do you know which file to delete?  Is it keyed to the
> transaction identifier or something?

The xid is encoded in the filename. If you can't start up the database 
and look at pg_locks, you can't do much other than guess.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com