Re: unexpected chunk number
От | Eric Anderson Vianet SAO |
---|---|
Тема | Re: unexpected chunk number |
Дата | |
Msg-id | 010201c35dc8$2ff036a0$0701a8c0@netterm обсуждение исходный текст |
Ответ на | unexpected chunk number ("Eric Anderson Vianet SAO" <eric@vianet-express.com.br>) |
Список | pgsql-general |
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@sss.pgh.pa.us> To: "Eric Anderson Vianet SAO" <eric@vianet-express.com.br> Cc: "PostgreSQL general" <pgsql-general@postgresql.org> Sent: Friday, August 08, 2003 12:43 PM Subject: Re: [GENERAL] unexpected chunk number > "Eric Anderson Vianet SAO" <eric@vianet-express.com.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@postgresql.org)
В списке pgsql-general по дате отправления: