Proposal: Select ... AS OF Savepoint

From: "Gokulakannan Somasundaram" <gokul007(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Proposal: Select ... AS OF Savepoint
Date: 2007-11-02 09:13:44
Message-ID: 9362e74e0711020213q725a483dke2754f4c9fdd7d87@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,
I would like to propose an additional feature for Postgres to enable
time-travelling inside a transaction.

I went through the source code and i found Savepoint is already saving the
necessary information. But currently it doesn't store the CommandId.

This change, if implemented would save the command id into savepoint state,
increase the command id counter for every savepoint and finally we can issue
a command like
(One more global variable to store the current state)
Select ... as of savepoint savepoint-name.

This would reduce the requirement for Serializable transactions in some
cases and adds one more feature under the umbrella of postgres.

--
Thanks,
Gokul.
CertoSQL Project,
Allied Solution Groups.
(www.alliedgroups.com)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2007-11-02 09:19:58 Re: Proposal: Select ... AS OF Savepoint
Previous Message Hiroshi Saito 2007-11-02 03:15:25 Re: Calculation of a shared memory