Re: records zapped to null

* Stephen Davies <scldad(at)sdc(dot)com(dot)au> [010326 21:36]:
> Hello again.
>
> I have just had to restore a database from backup because the majority
> of records in one table had "magically" become null.
>
> Last Friday morning there were some 700 valid rows in the table but yesterday
> all but 42 had become totally null.
>
> Restoring from Thursday night's backup repaired things so I am
> wondering what could have happened in between to cause this strange
> phenomenon.
What version of PostgreSQL?

What Platform?

What type of queries?

LER

>
> Cheers and thanks,
> Stephen Davies
>
>
> ========================================================================
> Stephen Davies Consulting scldad(at)sdc(dot)com(dot)au
> Adelaide, South Australia. Voice: 08-8177 1595
> Computing & Network solutions. Fax: 08-8177 0133
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749