Undoing updates not in a transaction - Mailing list pgsql-general

From Fathi Ben Nasr
Subject Undoing updates not in a transaction
Date
Msg-id 3CE614B6.2191EF8B@gnet.tn
Whole thread Raw
List 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 by date:

Previous
From: Mathieu Arnold
Date:
Subject: Re: Is there eny e-mail server that uses postgreSQL
Next
From: "Wm. G. Urquhart"
Date:
Subject: More on "What am I doing wrong!"