Re: Undo Update - Mailing list pgsql-admin

From Holger Jakobs
Subject Re: Undo Update
Date
Msg-id 89095BFA-4C53-4E34-AB59-F58551B8F909@jakobs.com
Whole thread Raw
In response to Undo Update  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Responses Re: Undo Update  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
List pgsql-admin
I'm afraid you will have to execute the SQL statement undoing it. Of you don't know the previous values, you're out of luck.

Then a backup is your best friend.


Am 10. August 2023 11:02:26 MESZ schrieb Rajesh Kumar <rajeshkumar.dba09@gmail.com>:
Hi friends

I was given a query to update the record in table A with where clause. But I executed it in production mistakenly without where clause so it updated incorrectly for all rows.

How do I resolve this?

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: Automate to rename table
Next
From: Rajesh Kumar
Date:
Subject: Re: Undo Update