Re: Undo an update

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Undo an update
Date: 2006-08-11 17:41:51
Message-ID: a55915760608111041w2272736eya9d2377d92209a1c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

If it was inside a transaction, and the transaction is still open,
then just rollback.

Otherwise, no.

I'm not sure if there's any way of doing some kind of PITR, no familiar with it.

If not, best bet is to recover from the newest backup set you have.

Regards,

Rodrigo

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Aaron Bono 2006-08-11 18:04:47 Re: timestamp (MS SQLServer's rowversion) functionality
Previous Message Judith 2006-08-11 17:26:44 Undo an update