Re: unable to dump database, toast errors

On Thu, 3 Apr 2003, Tom Lane wrote:
> Lonni J Friedman <lfriedman(at)vasoftware(dot)com> writes:
> > Do you mean the fields/rows in pg_toast_302323 or artifact_file ?
>
> The ones in artifact_file.
>
> > How
> > would i determine which ones reference broken toast entries?
>
> If you get the toast error when you try to read the field's value, then
> it's broken ...
>
> You may find yourself doing things like "select * from artifact_file
> limit N" to try to narrow down which rows contain broken values. If so,
> keep in mind that (in 7.2) LIMIT will read one more row than it returns;
> so if you can select N rows but not N+1 rows, the problem is actually in
> row N+2.

ok, i've got 786 rows to play with, joy. once i find a broken row/field,
how do I map that back to pg_toast_302323?

thanks.