"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> 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