"James Farrugia" <james(dot)farrugia(at)gmail(dot)com> writes:
> I'm running 8.2.1.
You really need to update to 8.2.latest. There are several known
data-corruption problems in 8.2.1, and it seems possible that one of
them ate the pg_depend row you needed.
> I cleanly forgot about pg_depend!
> Even after re-indexing I wasn't able to find an entry in pg_depend having
> the TOAST's OID. I guess that by creating foo again and linking
> pg_toast_xxx with foo in pg_depend by hand i can make it go away.
Yeah, that's probably the cleanest recovery strategy.
regards, tom lane