eurlix <eurlix(at)libertysurf(dot)fr> writes:
> I use Postgres 7.0 on a mandrake 8.0 and I am really novice
> with Postgres and SQL.
You really, really should update to something newer than 7.0.
The list of bugs we've fixed since then would make your blood run cold.
> 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
Is that query using an index? (Try EXPLAINing the query to find out.)
If so, I'd suggest dropping and recreating that index. 7.0 is far
enough back that I'm not sure REINDEX works real well in it, if it
has it at all.
regards, tom lane