Undoing updates not in a transaction

Поиск
Список
Период
Сортировка
От Fathi Ben Nasr
Тема Undoing updates not in a transaction
Дата
Msg-id 3CE614B6.2191EF8B@gnet.tn
обсуждение исходный текст
Список pgsql-general
Hello,

    I have made a msitake (used where ...<>  in an update wher i sould
have used where ...=) and wanted to have the values back.
rollback; didn't give anything as I didn't included my upadet in a
transaction.
I now I could have back everything (if I don't make a vacuum) from the
database but don't how.
This is a database for subscriptions to trainings, is a new system using
postgres I am trying to promote and need an answer for this general
topic question, as it is not excluded I won't make similar mistakes
again.

Thank You.
Fathi Ben Nasr.


В списке pgsql-general по дате отправления:

Предыдущее
От: Mathieu Arnold
Дата:
Сообщение: Re: Is there eny e-mail server that uses postgreSQL
Следующее
От: "Wm. G. Urquhart"
Дата:
Сообщение: More on "What am I doing wrong!"