Обсуждение: Undoing updates not in a transaction

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.

I think I read somewhere (sorry for not being precise) that when someone
issues a query, postgresql gives a snapshot of the database at that time
and that it is also possible to get a snaphshot of the database at any
time if a vacuum have not been done.
Andrew Sullivan a écrit :
On Sat, May 18, 2002 at 10:45:42AM +0200, Fathi Ben
Nasr wrote:
> 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.
Then they're gone.
> I now I could have back everything (if I don't make a vacuum) from
the
> database but don't how.
Restore from backups.
A
--
----
Andrew
Sullivan                              
87 Mowat Avenue
Liberty
RMS                          
Toronto, Ontario Canada

<andrew@libertyrms.info>                             
M6K 3E3

                                        
+1 416 646 3304 x110