Re: [GENERAL] rollback question... - Mailing list pgsql-general

From A James Lewis
Subject Re: [GENERAL] rollback question...
Date
Msg-id Pine.LNX.3.93.981112192806.15999B-100000@vr1-workhorse1.vrtx.net
Whole thread Raw
List pgsql-general
How large is the pool of information you are dealing with..... how much
granularity are you looking for?

I suppose you could put in a rule that copied the entire table on every
update.... then age out the copies after a while...

Mabe even do a bit of re-designing the structure if possible to accomodate
a date stamp on a record and allow dupliate records.. then select only the
latest one... then you could delete any change you liked....

On Thu, 12 Nov 1998, Lorenzo Huerta wrote:

>
> but that will only happen for one single transaction correct, ie it
> can only roll back at most one set of changes? See i am accessing my
> postgres tables from php scripts and we wanted to find a way, if
> possible, to go back in history and restore a certain record. Sounds
> like the "rollback" function will only be able to restore the last
> change commited in the database. So hmm i guess what i can do is to
> either create an initial dumpfile and enter it into cvs, then
> periodically store commit the changes i make into the cvs backed up one.
>
>  Any other suggestions to help with this problem?
>
>
>
> ---A James Lewis <james@vrtx.net> wrote:
> >
> >
> > I think there is confusion here....
> >
> > every statement between the "begin work;" and the "rollback;" are
> rolled
> > back... not just one....
> >
> > If you have not defined where to begin, you cannot roll back... it's
> not a
> > case of being able to back out individual commands one by one....
> >
> > On Wed, 11 Nov 1998, David Hartwig wrote:
> >
> > > Only the current transaction can be rolled back.
> > >
> > > Lorenzo Huerta wrote:
> > >
> > > > how many levels of rollbacks can postgres handle? Is it set to
> only
> > > > rollback changes for the last transaction done on a database, or
> can
> > > > you specify how many transactions to rollback to.
> > > >
> > > > lorenzo
> > > >
> > > > _________________________________________________________
> > > > DO YOU YAHOO!?
> > > > Get your free @yahoo.com address at http://mail.yahoo.com
> > >
> > >
> >
> > James (james@linuxrocks.co.uk)
> > Vortex Internet
> > My Windows unders~1 long filena~1, and yours?
> >
> >
>
> _________________________________________________________
> DO YOU YAHOO!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>

James (james@linuxrocks.co.uk)
Vortex Internet
My Windows unders~1 long filena~1, and yours?


pgsql-general by date:

Previous
From: Edmund Mergl
Date:
Subject: [Fwd: A trouble with postgres]
Next
From: elliotj@coxnews.com
Date:
Subject: Problem installing on AIX 4.2