Skip site navigation (1) Skip section navigation (2)

Re: Clarification on a Time travel feature

From: "Gokulakannan Somasundaram" <gokul007(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Clarification on a Time travel feature
Date: 2007-10-31 10:36:50
Message-ID: 9362e74e0710310336h6752edbdx8bb2cf7fcf5de5d4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
This is the complete question.

Hi,
   I went through the mailing list and couldn't get answer to the question.

a) Is there a proposal in place for going back in time within a transaction?

I am thinking of some functionality like this.

BEGIN
select ... (command id 1)
update ... (command id 10)
..

select ... as of command id 1.

END;


b) I know time travel doesn't allow to change the details of the past. But
is it possible to provide an alternative to rollback
by means of changing the data with older command id.

But i just want to clarify once more that i am restricting the scope of time
travel within a transaction..





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

In response to

Responses

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2007-10-31 10:41:31
Subject: Re: Clarification on a Time travel feature
Previous:From: Gokulakannan SomasundaramDate: 2007-10-31 10:31:07
Subject: Clarification on a Time travel feature

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group