hi tom,
thanks for your answer. in fact, i succeeded in dropping and
then recreating the index without any problem.
it's such problems that do worry me, when they happen.
do you remember when i had such problems every day? we discussed it
on the list, and i finally changed the hardware...
and now, suddenly, there is another filesystem problem...
it's these things that worry me most. against programmer's bugs
i can create bugfixes -- but these system dependend stuff makes
me completely helpless.... :(
--
Mit freundlichem Gruß
Henrik Steffen
Geschäftsführer
top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen@topconcepts.com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Henrik Steffen" <steffen@city-map.de>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, November 21, 2002 3:50 PM
Subject: Re: [GENERAL] what's that error?
> "Henrik Steffen" <steffen@city-map.de> writes:
> > while vacuuming I got:
> > ERROR: cannot open segment 1 of relation basiseintrag_firma_idx (target block 808923185): No such file or
directory
>
> Apparently you have a corrupted link pointer in that index. You can
> probably recover by reindexing basiseintrag_firma_idx.
>
> As for how it got that way, would need a lot more info to investigate.
>
> regards, tom lane
>