comments on prepared transactions ...
От | Hans-Jürgen Schönig |
---|---|
Тема | comments on prepared transactions ... |
Дата | |
Msg-id | 43455B54.8000700@cybertec.at обсуждение исходный текст |
Ответы |
Re: comments on prepared transactions ...
Re: comments on prepared transactions ... |
Список | pgsql-hackers |
i had to deal with oracle in the past couple of days (*mega sigh*) i have seen a very interesting feature which would make sense for PostgreSQL users. currently we have: test=# \h PREPARE TRANSACTION Command: PREPARE TRANSACTION Description: prepare the current transaction for two-phase commit Syntax: PREPARE TRANSACTION transaction_id 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 ... what do people think about this? best regards, hans -- Cybertec Geschwinde & Schönig GmbH Schöngrabern 134; A-2020 Hollabrunn Tel: +43/1/205 10 35 / 340 www.postgresql.at, www.cybertec.at
В списке pgsql-hackers по дате отправления: