Thread: find bad record

find bad record

From
"Thomas Heller"
Date:
Hi there,

i have a little problem with one of my tables. can someone explain me how to
find that record?

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?

thanks in advance,
thomas


Re: find bad record

From
Tom Lane
Date:
"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