Re: unexpected chunk number

it generates following error:

ERROR: Function 'lenght(bytea)' does not exist

Unable to identify a function that satisfies the given argument types

You may need to add explicit typecasts

this row is only which has chunk_seq = 8.

why couldn´t I simply UPDATE it?

tnx

Eric

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br>
Cc: "PostgreSQL general" <pgsql-general(at)postgresql(dot)org>
Sent: Friday, August 08, 2003 12:43 PM
Subject: Re: [GENERAL] unexpected chunk number

> "Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br> writes:
> > pg_dump: dumping out the contents of table tbdmovimento
> > pg_dump: ERROR: unexpected chunk number 8 (expected 0) for toast value
6935=
> > 693
>
> Hm. Could we see the results of
>
> select chunk_seq,length(chunk_data) from <tbdmovimento's toast table>
> where chunk_id = 6935693;
>
> If you are not trusting the index then it might be good to try this
> with enable_indexscan turned off and see if you get the same answers.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)