Re: Patch for disaster recovery

On Sun, Feb 20, 2005 at 02:21:00AM -0500, Tom Lane wrote:

> Just brainstorming here, but it seems to me that what might make some
> kind of sense is a command to "undelete all tuples in this table".

Would it be possible to start a transaction with specific snapshot
parameters?  Could you "time warp" that way, assuming that what
you're looking for hasn't already been vacuumed away?  Rather than
modifying anything, you'd SELECT or COPY the data somewhere and
then restore it when you came "back to the future."  Just another
brainstorm...certainly not thought very far through yet.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/