find bad record
find bad record
От:
"Thomas Heller" <th.heller@comtron.net>
Дата:
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
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"Thomas Heller" 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