Participants
Fathi Ben Nasr
Fathi Ben Nasr
Attachments
Show all attachments
Thread Outline
#1Fathi Ben NasrFathi Ben Nasr
May 18, 2002
#2Fathi Ben Nasr↳Fathi Ben Nasrto Fathi Ben Nasr (#1)
May 23, 2002

Undoing updates not in a transaction

Started by Fathi Ben Nasralmost 24 years ago2 messagesgeneral
Jump to latest
#1Fathi Ben Nasr
Fathi Ben Nasr
fathi.engineer@gnet.tn

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.

#2Fathi Ben Nasr
Fathi Ben Nasr
fathi.engineer@gnet.tn
In reply to: Fathi Ben Nasr (#1)
Re: Undoing updates not in a transaction

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
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.
<p>Andrew Sullivan a &eacute;crit :
<blockquote TYPE=CITE>On Sat, May 18, 2002 at 10:45:42AM +0200, Fathi Ben
Nasr wrote:
<br>> Hello,
<br>>
<br>>&nbsp;&nbsp;&nbsp;&nbsp; I have made a msitake (used where ...&lt;>&nbsp;
in an update wher i sould
<br>> have used where ...=) and wanted to have the values back.
<br>> rollback; didn't give anything as I didn't included my upadet in
a
<br>> transaction.
<p>Then they're gone.
<p>> I now I could have back everything (if I don't make a vacuum) from
the
<br>> database but don't how.
<p>Restore from backups.
<p>A
<p>--
<br>----
<br>Andrew Sullivan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
87 Mowat Avenue
<br>Liberty RMS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Toronto, Ontario Canada
<br>&lt;andrew@libertyrms.info>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
M6K 3E3
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
+1 416 646 3304 x110</blockquote>
</html>

← Back to Topics