Proposal: Select ... AS OF Savepoint
От | Gokulakannan Somasundaram |
---|---|
Тема | Proposal: Select ... AS OF Savepoint |
Дата | |
Msg-id | 9362e74e0711020213q725a483dke2754f4c9fdd7d87@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Proposal: Select ... AS OF Savepoint
|
Список | pgsql-hackers |
Hi,<br /> I would like to propose an additional feature for Postgres to enable time-travelling inside a transaction.<br/><br />I went through the source code and i found Savepoint is already saving the necessary information.But currently it doesn't store the CommandId. <br /><br />This change, if implemented would save the commandid into savepoint state, increase the command id counter for every savepoint and finally we can issue a command like<br />(One more global variable to store the current state) <br />Select ... as of savepoint savepoint-name.<br /><br/>This would reduce the requirement for Serializable transactions in some cases and adds one more feature under theumbrella of postgres.<br /><br />-- <br />Thanks,<br />Gokul. <br />CertoSQL Project,<br />Allied Solution Groups.<br/>(<a href="http://www.alliedgroups.com">www.alliedgroups.com</a>)
В списке pgsql-hackers по дате отправления: