Postgres Pro
Downloads
Home   >   mailing lists

find bad record - Mailing list pgsql-admin

From Thomas Heller
Subject find bad record
Date
Msg-id 000d01c08f74$b5655830$b7217fd4@kjkafjuprmkaec
Whole thread Raw
Responses Re: find bad record  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: R D
Date:
Subject: Indexes & Cluster - more information.
Next
From: "Oliver Elphick"
Date:
Subject: Re: date in european style