> Find the row containing the busted toast reference, and delete that row
> (or just UPDATE it with some new value for the toasted column).  You can
> home in on it with the usual sorts of search methods --- look in the PG
> list archives for previous discussions of locating corrupted rows.

Thanks Tom. I ended up restoring the table from the last dump (created by 
pg_dump) up to the point where corruption starts. Not the most surgical 
solution but justified for my use case.


-- 
Milos Prudek

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to