Disruptive corruption of data during an update

Поиск
Список
Период
Сортировка
От Ennio-Sr
Тема Disruptive corruption of data during an update
Дата
Msg-id 20120329111729.GA26284@deby.ei.hnet
обсуждение исходный текст
Ответы Re: Disruptive corruption of data during an update  (Binand Sethumadhavan <binand@gmx.net>)
Список pgsql-novice
[Using postgresql-8.4.8-0squeeze1 under GNU-linux/debian]


Hi all!

an entire table of my db has been corrupted as a consequence of this erroneous
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?
I realized the single quote was missing after the closing parenthesis
and just wrote it plus a second semicolon ';' ....

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 по дате отправления:

Предыдущее
От: Mephysto
Дата:
Сообщение: Re: Show stored function code
Следующее
От: Binand Sethumadhavan
Дата:
Сообщение: Re: Disruptive corruption of data during an update