From: | "Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br> |
---|---|
To: | "PostgreSQL general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: unexpected chunk number |
Date: | 2003-08-08 16:44:43 |
Message-ID: | 011201c35dcc$5e8f0a50$0701a8c0@netterm |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
sorry about dumb ´lenght´ instead ´length´.
the length of chunk_data is 255.
tnx.
Eric
----- Original Message -----
From: "Eric Anderson Vianet SAO" <eric(at)vianet-express(dot)com(dot)br>
To: "PostgreSQL general" <pgsql-general(at)postgresql(dot)org>
Sent: Friday, August 08, 2003 1:14 PM
Subject: Re: [GENERAL] 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)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
From | Date | Subject | |
---|---|---|---|
Next Message | Eric Anderson Vianet SAO | 2003-08-08 17:14:06 | Re: unexpected chunk number |
Previous Message | scott.marlowe | 2003-08-08 16:40:23 | Re: Auditing idea |