Disruptive corruption of data during an update

From: Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: Disruptive corruption of data during an update
Date: 2012-03-29 11:49:01
Message-ID: 20120329114901.GA26650@deby.ei.hnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

A few minutes ago I wrote:
---- quote
update command:
--------
mydb=> update bibl set argomento='curatori', autore='DELLA VOLPE Galvano \
(con due capitoli aggiunti e note di) where n_prog=3285;
mydb'> ';

UPDATE 12845
mydb=>
--------

Having an adequate back-up I think I'll be able to recover the data, but
can someone explain what the hell happened?

-------- unquote

Having come out of the initial panic I reconsidered the thing with calm
and of course 'discovered' that the program has done exactly what I told
it to do, as the 'where' clause was incorporated within the two «'».

My question now is:
is there any possibility to recover such type of error while postgres is
still running and no other transacion has been committed?

Regards,
ennio

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
Ricevo solo messaggi Content-Type: plain/text (no html o multipart). )=(
!!! --> e-mail a mio nome via OE (M$) sono false e infette <-- !!!

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Steve T 2012-03-29 12:40:55 Re: Disruptive corruption of data during an update
Previous Message Binand Sethumadhavan 2012-03-29 11:33:03 Re: Disruptive corruption of data during an update