Re: Undo Update

Поиск
Список
Период
Сортировка
От Holger Jakobs
Тема Re: Undo Update
Дата
Msg-id 89095BFA-4C53-4E34-AB59-F58551B8F909@jakobs.com
обсуждение исходный текст
Ответ на Undo Update  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Ответы Re: Undo Update  (Rajesh Kumar <rajeshkumar.dba09@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Wells Oliver
Дата:
Сообщение: Re: Automate to rename table
Следующее
От: Rajesh Kumar
Дата:
Сообщение: Re: Undo Update