Re: records zapped to null

Поиск
Список
Период
Сортировка
От Larry Rosenman
Тема Re: records zapped to null
Дата
Msg-id 20010326213809.A23807@lerami.lerctr.org
обсуждение исходный текст
Ответ на records zapped to null  (Stephen Davies <scldad@sdc.com.au>)
Ответы Re: records zapped to null
Список 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 по дате отправления:

Предыдущее
От: Zak McGregor
Дата:
Сообщение: Re: How to copy a table?
Следующее
От: Stephen Davies
Дата:
Сообщение: Re: records zapped to null