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
