Column with recycled sequence value

Поиск
Список
Период
Сортировка
От KÖPFERL Robert
Тема Column with recycled sequence value
Дата
Msg-id ED4E30DD9C43D5118DFB00508BBBA76EB1654B@neptun.sonorys.at
обсуждение исходный текст
Ответы Re: Column with recycled sequence value  (Bruno Wolff III <bruno@wolff.to>)
Re: Column with recycled sequence value  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: Column with recycled sequence value  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список 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. 



В списке pgsql-sql по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Syntax error while altering col-type
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Column with recycled sequence value