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