If the reindex does not work, You need to loop through the data and identify which rows are bad and delete them.
Modify the following script to suit your needs and it should help you identify which rows are bad.
DO $f$ DECLARE baddata TEXT; badid INT; BEGIN FOR badid IN SELECT id FROM badtable LOOP BEGIN SELECT badcolumn INTO columndata FROM badtable where id = badid; EXCEPTION WHEN OTHERS THEN RAISE NOTICE 'Data for ID % is corrupt', badid; CONTINUE; END; END LOOP; END; $f$
My attitude will always be based on how you treat me.
--
Thanks,
Jorge Torralba ----------------------------
Note: This communication may contain privileged or other confidential information. If you are not the intended recipient, please do not print, copy, retransmit, disseminate or otherwise use the information. Please indicate to the sender that you have received this email in error and delete the copy you received. Thank You.