Re: find bad record - Mailing list pgsql-admin

From Tom Lane
Subject Re: find bad record
Date
Msg-id 16055.981385078@sss.pgh.pa.us
Whole thread Raw
In response to find bad record  ("Thomas Heller" <th.heller@comtron.net>)
List pgsql-admin
"Thomas Heller" <th.heller@comtron.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

pgsql-admin by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: date in european style
Next
From: Michael Davis
Date:
Subject: RE: Outer Joins