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