DB corrupted ?
От | eurlix |
---|---|
Тема | DB corrupted ? |
Дата | |
Msg-id | 20030129104656.53d6448a.eurlix@libertysurf.fr обсуждение исходный текст |
Ответы |
Re: DB corrupted ?
|
Список | pgsql-novice |
Hi all, I use Postgres 7.0 on a mandrake 8.0 and I am really novice with Postgres and SQL. If I try : select * from cpjo order by joMA, joJNL, joFOL ; I obtain : ERROR: cannot open segment 1 of relation cpjo (target block 1346502656): No such file or directory but the same request on an other table works well and if if try : select * from cpjo where joma='200201' order by joMA, joJNL, joFOL ; ================ this works fine also ! joma, jojnl and jofol are the primary key of cpjo and there is nothing before '200201' in it. It seem to me that the DB is corrupted but what I must do for repairs it ? VACUUM, REINDEX ? Thanks, -- Alain Lucari Eurlix 1, rue Reine Elisabeth von Witellsbach (Reine des Belges) 13001 Marseille FRANCE
В списке pgsql-novice по дате отправления: