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

From Martijn van Oosterhout
Subject Re: Proposal: Select ... AS OF Savepoint
Date
Msg-id 20071102091957.GA9936@svana.org
Whole thread Raw
In response to Proposal: Select ... AS OF Savepoint  ("Gokulakannan Somasundaram" <gokul007@gmail.com>)
Responses Re: Proposal: Select ... AS OF Savepoint
List pgsql-hackers
On Fri, Nov 02, 2007 at 02:43:44PM +0530, Gokulakannan Somasundaram wrote:
> Hi,
>    I would like to propose an additional feature for Postgres to enable
> time-travelling inside a transaction.

<snip>

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

I'm still confused. Why on earth would you want to run a query against
an old snapshot? If you want a stable view, I'd think of opening a
cursor or using a temporary table. And where does serializable come
into this?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

pgsql-hackers by date:

Previous
From: "Gokulakannan Somasundaram"
Date:
Subject: Proposal: Select ... AS OF Savepoint
Next
From: Florian Weimer
Date:
Subject: Asynchronous commit documentation gap