Re: records zapped to null - Mailing list pgsql-general

From Larry Rosenman
Subject Re: records zapped to null
Date
Msg-id 20010326213809.A23807@lerami.lerctr.org
Whole thread Raw
In response to records zapped to null  (Stephen Davies <scldad@sdc.com.au>)
Responses Re: records zapped to null  (Stephen Davies <scldad@sdc.com.au>)
List pgsql-general
* Stephen Davies <scldad@sdc.com.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@sdc.com.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@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

pgsql-general by date:

Previous
From: Zak McGregor
Date:
Subject: Re: How to copy a table?
Next
From: Stephen Davies
Date:
Subject: Re: records zapped to null