Re: 8.4.0 data loss / HOT-related bug - Mailing list pgsql-bugs

From Radoslaw Zielinski
Subject Re: 8.4.0 data loss / HOT-related bug
Date
Msg-id 20090823080025.GA2592@bzium
Whole thread Raw
In response to Re: 8.4.0 data loss / HOT-related bug  (Greg Stark <gsstark@mit.edu>)
List pgsql-bugs
Greg Stark <gsstark@mit.edu> [2009-08-23 03:40]:
> 2009/8/22 Radoslaw Zielinski <radek@pld-linux.org>:
>> =C2=A0bug=3D# select length(opis_szczeg) from promocje where id =3D 4300;
>> =C2=A0ERROR: =C2=A0missing chunk number 0 for toast value 120741 in pg_t=
oast_29644
> Sorry, what datatype is this again? And what encoding?

text, UTF-8 (locale C).

> Perhaps I should have said octet_length() instead of length().

  bug=3D# select octet_length(opis_szczeg) from promocje where id =3D 4300;
   octet_length=20
  --------------
           3081
  (1 row)

--=20
Rados=C5=82aw Zieli=C5=84ski <radek@pld-linux.org>

pgsql-bugs by date:

Previous
From: Greg Stark
Date:
Subject: Re: BUG #4996: postgres.exe memory consumption keeps going up
Next
From: Radoslaw Zielinski
Date:
Subject: Re: 8.4.0 data loss / HOT-related bug