Re: unable to dump database, toast errors - Mailing list pgsql-general

From Tom Lane
Subject Re: unable to dump database, toast errors
Date
Msg-id 12865.1049401482@sss.pgh.pa.us
Whole thread Raw
In response to Re: unable to dump database, toast errors  (Lonni J Friedman <lfriedman@vasoftware.com>)
Responses Re: unable to dump database, toast errors  (Lonni J Friedman <lfriedman@vasoftware.com>)
List pgsql-general
Lonni J Friedman <lfriedman@vasoftware.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.

            regards, tom lane


pgsql-general by date:

Previous
From: Marc Drouin
Date:
Subject: Re: Newbie: problem Connecting to Server
Next
From: Tom Lane
Date:
Subject: Re: pgsql password when FreeBSD boots -- what's usual?