"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> I seem to have recovered from my Postgres probs.  I decided to do a vacuum
> full to clean things up.  I got this about halfway through:

> usa=# vacuum full analyze;
> ERROR:  No one parent tuple was found

> Any fix for that?

Try a "SELECT * FROM <table> FOR UPDATE" outside any transaction block.
That should clear the problem and let you vacuum.  This is fixed in CVS
tip but there's no fix in 7.2.2.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to