Column with recycled sequence value

From: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Column with recycled sequence value
Date: 2005-01-13 17:08:20
Message-ID: ED4E30DD9C43D5118DFB00508BBBA76EB1654B@neptun.sonorys.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

suppose I have a let's say heavy used table. There's a column containing
UNIQUE in4
values. The data type musn't exceed 32-Bit. Since however the table is heavy
used 2^32 will be reached soon and then? There are far less than 4G-records
saved thus these values may be reused. How can this be accomplished?

I already defined a sequence but then?

I appreciate your help.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2005-01-13 19:49:00 Re: Column with recycled sequence value
Previous Message Andrew Sullivan 2005-01-13 13:25:32 Re: Syntax error while altering col-type