find bad record

From: "Thomas Heller" <th(dot)heller(at)comtron(dot)net>
To: "psql" <pgsql-admin(at)postgresql(dot)org>
Subject: find bad record
Date: 2001-02-05 13:08:18
Message-ID: 000d01c08f74$b5655830$b7217fd4@kjkafjuprmkaec
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Oliver Elphick 2001-02-05 14:02:36 Re: date in european style
Previous Message R D 2001-02-05 12:42:34 Indexes & Cluster - more information.