Re: Undoing updates not in a transaction

From: Fathi Ben Nasr <fathi(dot)engineer(at)gnet(dot)tn>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Undoing updates not in a transaction
Date: 2002-05-23 11:10:09
Message-ID: 3CECCE11.D649BACB@gnet.tn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!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(at)libertyrms(dot)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>

Attachment Content-Type Size
unknown_filename text/html 1.8 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message tony 2002-05-23 11:16:07 Anyone interested in MySQL training?
Previous Message Sander Steffann 2002-05-23 09:27:54 Re: How to select rows with values set to NULL