| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Hans-Jürgen Schönig <postgres(at)cybertec(dot)at> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: comments on prepared transactions ... |
| Date: | 2005-10-06 19:58:59 |
| Message-ID: | 25149.1128628739@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <postgres(at)cybertec(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2005-10-06 20:14:47 | Re: [PERFORM] A Better External Sort? |
| Previous Message | Tom Lane | 2005-10-06 19:57:38 | Re: [HACKERS] A Better External Sort? |