Re: find bad record

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thomas Heller" <th(dot)heller(at)comtron(dot)net>
Cc: "psql" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: find bad record
Date: 2001-02-05 14:57:58
Message-ID: 16055.981385078@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Thomas Heller" <th(dot)heller(at)comtron(dot)net> writes:
> vacuum says:
> NOTICE: Rel mxaccounts: TID 226/18: OID IS INVALID. TUPGONE 0.
> VACUUM

> mxaccounts is my table, but how do i find the record causing this notice?

Well, it's telling you the TID. Try

select * from mxaccounts where ctid = '(226,18)';

Note that the TID will change if you update the row!

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Davis 2001-02-05 15:30:41 RE: Outer Joins
Previous Message Oliver Elphick 2001-02-05 14:02:36 Re: date in european style