Re: unable to dump database, toast errors

On Mon, 07 Apr 2003 07:34:47 -0400, Jan Wieck <JanWieck@Yahoo.com>
wrote:
>Is there any of those other columns that could identify a single row
>uniquely? If so, that could work as a key for this purpose.
>
>If you have that, let's call it <keycolumn>.

Lonni,

let me add that if there is no such *user* column, you can always use
the system column ctid:

    SELECT ctid FROM artifact_file LIMIT 1 OFFSET 694;

 ctid
--------
 (42,7)

Now check whether this is really your broken tuple:

    SELECT length(bin_data) FROM artifact_file
     WHERE ctid = '(42,7)';  -- should give an ERROR

... and that all other tuples are ok as suggested by Jan:

    SELECT sum(length(bin_data)) FROM artifact_file
     WHERE NOT ctid = '(42,7)';  -- should work

Note that you have to use 'NOT ctid =', because operator '!=' is not
defined for datatype tid.

Servus
 Manfred