Re: BUG #2311: Toast table chunk_id overflow - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2311: Toast table chunk_id overflow
Date
Msg-id 228.1141958866@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2311: Toast table chunk_id overflow  ("Chris Hodgson" <chodgson@refractions.net>)
List pgsql-bugs
"Chris Hodgson" <chodgson@refractions.net> writes:
> If you cycle through enough id's in your toast tables, the chunk_id goes
> past 2^32 and wraps around, leaving you  in an intermittent error state.
> Inserting further toasted chunks will fail depending on whether that
> particular next id from the sequence is already in the table or not.

This is dealt with in PG 8.1.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Chris Hodgson"
Date:
Subject: BUG #2311: Toast table chunk_id overflow
Next
From: Volkan YAZICI
Date:
Subject: Re: BUG #2309: Wrong string comparison