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 > > Your best bet, since you've crashed with fsync off, is to dump and > reload the database. This should clean up any data issues you currently > have -- assuming pg_dump functions on it. > > That said, 7.2.3 has several vacuum fixes, but I don't think they'll fix > your problem.
I did a SELECT * FROM table FOR UPDATE; and it solved the problem... thnx for your answer. <<V13>> ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
