Re: [BUGS] vacumm error

2002-11-27 Thread V13
On Tuesday 26 November 2002 16:43, Rod Taylor wrote: > On Fri, 2002-11-22 at 15:51, Stefanos Harhalakis wrote: > > I'm running postgresql 7.2.1 on linux. > > > > I cannot run vacuumm on a table in a database i'm running for about 7 > > months. I get: > > > > ERROR: No one parent tuple was found >

Re: [BUGS] vacumm error

2002-11-26 Thread Tom Lane
Stefanos Harhalakis <[EMAIL PROTECTED]> writes: > I'm running postgresql 7.2.1 on linux. > I cannot run vacuumm on a table in a database i'm running for about 7 months. > I get: > ERROR: No one parent tuple was found > I've found an older posting about that but the poster said that after > rest

Re: [BUGS] vacumm error

2002-11-26 Thread Rod Taylor
On Fri, 2002-11-22 at 15:51, Stefanos Harhalakis wrote: > I'm running postgresql 7.2.1 on linux. > > I cannot run vacuumm on a table in a database i'm running for about 7 months. > I get: > > ERROR: No one parent tuple was found Your best bet, since you've crashed with fsync off, is to dump and