Re: Getting TOAST errors

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Getting TOAST errors
Date: 2011-09-19 21:48:52
Message-ID: CAGuHJrNN_FiRgfOZxO7eo+8GGWgm=gE-8xzVnd2x_hC9HNYdOw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> Hard to tell.  We've seen enough reports like that to make it seem like
> there may be some bug buried there, but no one has provided anything to
> do any debugging work with.  Can you create a reproducible test case?

Not really. I have a nightly process which downloads data and sticks
it into a text field. Afterwards another process reads that text data
and processes it creating rows in another table. The problem occurs in
the last step and at seemingly random intervals. For example one time
it might happen when you are creating row 1000 another time it might
be when you are creating row 2000.

>
>> Postgres 9.0 linux.
>
> 9.0.what?

9.0.4

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerry Sievers 2011-09-19 21:57:21 Re: Am I best off keeping large chunks of text in a separate table?
Previous Message Stephen Frost 2011-09-19 21:13:38 Re: Column Privileges: NULL instead of permission denied