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:17:29 |
Message-ID: | 20120329111729.GA26284@deby.ei.hnet |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 <-- !!!
From | Date | Subject | |
---|---|---|---|
Next Message | Binand Sethumadhavan | 2012-03-29 11:33:03 | Re: Disruptive corruption of data during an update |
Previous Message | Mephysto | 2012-03-29 07:10:26 | Re: Show stored function code |