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.
In response to
pgsql-bugs by date
|Next:||From: Jean-Luc Lachance||Date: 2002-11-26 21:15:28|
|Subject: order by in for loop in plpgsql does not work|
|Previous:||From: bpalmer||Date: 2002-11-26 20:59:21|
|Subject: regression hickups w/ freebsd.|