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

[BUGS] vacumm error

2002-11-26 Thread Stefanos Harhalakis
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 restarting it was fixed. In my case this is not true. I've rest