Sequence Roll Over

Поиск
Список
Период
Сортировка
От Mat
Тема Sequence Roll Over
Дата
Msg-id 1057501791.3175.5.camel@Arakis
обсуждение исходный текст
Ответы Re: Sequence Roll Over
Список pgsql-general
What happens when a sequence for auto-numbered records gets to its
maximum value and another record is added?

Does using a sequence for this limit the amount of records the table can
hold?

If records are deleted, is there a standard way of renumbering all
records so their ID's are consecutive starting from zero and then
reseting the sequence to the highest ID value?

Thanks,

M


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