Postgres Pro
Downloads
Home   >   mailing lists

Re: missing chunk number 0 for toast value - Mailing list pgsql-general

From Tom Lane
Subject Re: missing chunk number 0 for toast value
Date
Msg-id 5122.1114647089@sss.pgh.pa.us
Whole thread Raw
In response to Re: missing chunk number 0 for toast value  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: missing chunk number 0 for toast value  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
Tree view 
"Ed L." <pgsql@bluepolka.net> writes:
> Does this shed any light?  pg_toast_6221538 is the relevant toast
> table...

> $ psql -c "set enable_indexscan=off; select chunk_seq,
> length(chunk_data) from pg_toast.pg_toast_6221538 where chunk_id
> = 19319495 order by chunk_seq;"
>  chunk_seq | length
> -----------+--------
> (0 rows)

Doesn't look very promising :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Tzahi Fadida
Date:
Subject: SPI cursors pinned buffer and moving to the first tuple.
Next
From: "Ed L."
Date:
Subject: Re: missing chunk number 0 for toast value