Undo Update

From: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Undo Update
Date: 2023-08-10 09:02:26
Message-ID: CAJk5AtahecUT1LqJdKkG8cYM814x=JTWU0-TQ+6Xn0F9BgetkA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Wells Oliver 2023-08-10 09:04:12 Re: Automate to rename table
Previous Message Joseph Hammerman 2023-08-09 21:55:07 Tracking the dirty tuple read rate