Re: Rows missing from table despite FK constraint

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Rows missing from table despite FK constraint
Дата
Msg-id 4533.1262958901@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Rows missing from table despite FK constraint  (Konrad Garus <konrad.garus@gmail.com>)
Ответы Re: Rows missing from table despite FK constraint  (Konrad Garus <konrad.garus@gmail.com>)
Список pgsql-general
Konrad Garus <konrad.garus@gmail.com> writes:
> 2010/1/8 Alban Hertroys <dalroi@solfertje.student.utwente.nl>:
>> I get the impression the data you lost and the data around it hasn't been written to in a long time; it wouldn't
surpriseme if your problem would have been caused by a bad sector on a disk, but that depends on how reliable your
storageis set up to be. 

> You are correct about the first point. It's a write-only table with
> thousands of inserts daily, and the lost rows were written 7 months
> ago.

Do you know that the rows disappeared recently?

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Server name in psql prompt
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Server name in psql prompt