Re: Data version idea (please discuss)

From: "Scott Marlowe" <smarlowe(at)qwest(dot)net>
To: "webb" <wwsprague(at)ucdavis(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Data version idea (please discuss)
Date: 2004-08-06 18:22:00
Message-ID: 1091816520.27166.222.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Have you looked in contrib/spi/README.timetravel ?

On Fri, 2004-08-06 at 10:56, webb wrote:
> > :-)
> > How about using CHECKPOINT or SAVEPOINT in postgresql 8.0? (in beta now)
> > http://developer.postgresql.org/docs/postgres/sql-checkpoint.html
> > http://developer.postgresql.org/docs/postgres/sql-savepoint.html
>
> I guess checkpoint is the wrong term (duh...), since what I want is to
> save all possible versions. "REVERT TO id" would be my vote for SQL
> 2010 if this feature is enabled.
>
> Thansk to the folks above for the links. I have the snodgrass book -- I
> will check it again.
> W
> >
> > There are some examples in postgresql 7.5 new features announcements
> > over the net.
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2004-08-06 18:27:47 Re: Postgres and Tools Intro?
Previous Message Scott Marlowe 2004-08-06 18:20:45 Re: Creating blank records with sequential record numbers