| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | "Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Postgres problems |
| Date: | 2002-08-29 03:11:14 |
| Message-ID: | 13454.1030590674@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2002-08-29 03:49:19 | Re: [Resend] Sprintf() auditing and a patch |
| Previous Message | Tom Lane | 2002-08-29 03:07:05 | Re: MemoryContextAlloc: invalid request size 1934906735 |