From: | eurlix <eurlix(at)libertysurf(dot)fr> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | DB corrupted ? |
Date: | 2003-01-29 09:46:56 |
Message-ID: | 20030129104656.53d6448a.eurlix@libertysurf.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | paul butler | 2003-01-29 10:03:31 | Re: Developing a forms based web application |
Previous Message | Tom Lane | 2003-01-29 07:02:10 | Re: Database connection |