records zapped to null - Mailing list pgsql-general

From Stephen Davies
Subject records zapped to null
Date
Msg-id 200103270333.NAA29055@mustang.sdc.com.au
Whole thread Raw
Responses Re: records zapped to null  (Larry Rosenman <ler@lerctr.org>)
Re: records zapped to null  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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.

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



pgsql-general by date:

Previous
From: Zak McGregor
Date:
Subject: Views, indices and pg_dump
Next
From: Zak McGregor
Date:
Subject: Re: How to auto create a unique key for each newly added record?