viewing/restoring old rows - Mailing list pgsql-general

From David Wright
Subject viewing/restoring old rows
Date
Msg-id Pine.LNX.4.33.0108151102250.20255-100000@merleau.rprc.washington.edu
Whole thread Raw
In response to Re: LARGE db dump/restore for upgrade question  (Philip Crotwell <crotwell@seis.sc.edu>)
List pgsql-general
My understanding of pgSQL is that, when a row is updated or deleted, the
old row is marked as such, but maintained in the DB until I vaccuum.
(This certainly would ease the implementation of transactions.)
Please correct me if I am mistaken. Assuming for now this is true...

Is there  some way to view the old rows or even restore one?

And doesn't this mean a timestamp must be automagically associated with
each row? How do I access these timestamps?


pgsql-general by date:

Previous
From: "Tamara D. Blum"
Date:
Subject: Error installing postgresql 7.1.2
Next
From: wsheldah@lexmark.com
Date:
Subject: Re: LARGE db dump/restore for upgrade question