Hans-Jürgen Schönig <postgres@cybertec.at> writes:
> in oracle it is possible to comment transactions:
> COMMIT COMMENT 'ORA-2PC-CRASH-TEST-n';
> if we added the possibility to comment prepared transactions it would be
> far easier for DBAs to find out what to do with prepared transactions
> once something has gone wrong (at least if an application adds some
> useful data to the comment). usually when the DBA has to fix something
> it has to be done FAST - some additional info would definitely help here ...
You can do that already. All you have to do is make sure your prepared
transaction identifiers are somewhat human readable.
regards, tom lane