Proposal: Select ... AS OF Savepoint - Mailing list pgsql-hackers

From Gokulakannan Somasundaram
Subject Proposal: Select ... AS OF Savepoint
Date
Msg-id 9362e74e0711020213q725a483dke2754f4c9fdd7d87@mail.gmail.com
Whole thread Raw
Responses Re: Proposal: Select ... AS OF Savepoint  (Martijn van Oosterhout <kleptog@svana.org>)
List 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 by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: Re: Calculation of a shared memory
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Proposal: Select ... AS OF Savepoint