<!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 écrit :
<blockquote TYPE=CITE>On Sat, May 18, 2002 at 10:45:42AM +0200, Fathi Ben
Nasr wrote:
<br>> Hello,
<br>>
<br>> I have made a msitake (used where ...<>
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
87 Mowat Avenue
<br>Liberty RMS
Toronto, Ontario Canada
<br><andrew(at)libertyrms(dot)info>
M6K 3E3
<br>
+1 416 646 3304 x110</blockquote>
</html>