Re: BUG #2311: Toast table chunk_id overflow

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chris Hodgson" <chodgson(at)refractions(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2311: Toast table chunk_id overflow
Date: 2006-03-10 02:47:46
Message-ID: 228.1141958866@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Chris Hodgson" <chodgson(at)refractions(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Volkan YAZICI 2006-03-10 07:36:11 Re: BUG #2309: Wrong string comparison
Previous Message Tom Lane 2006-03-10 01:10:54 Re: BUG #2310: "ALTER TYPE name OWNER TO new_owner" not working