Re: [ADMIN] find bad record

[Tom Lane]

"Thomas Heller" <[EMAIL PROTECTED]> 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