Disruptive corruption of data during an update
От | Ennio-Sr |
---|---|
Тема | Disruptive corruption of data during an update |
Дата | |
Msg-id | 20120329114901.GA26650@deby.ei.hnet обсуждение исходный текст |
Ответы |
Re: Disruptive corruption of data during an update
|
Список | 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 <-- !!!
В списке pgsql-novice по дате отправления: