Re: How to make sequence skip existing key in table?

Поиск
Список
Период
Сортировка
От Raymond Pau
Тема Re: How to make sequence skip existing key in table?
Дата
Msg-id 20030221062922.30510.qmail@web14204.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: How to make sequence skip existing key in table?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-sql
--- Josh Berkus <josh@agliodbs.com> wrote:
> Raymond,
> 
> > I am using sequence to generate to a list of
> unique
> > key id that will be used as the primary key for
> some
> > tables.
> >
> > My question is when the sequence wraps over to the
> > minimum value(1), how can I ensure that the next
> id is
> > not in the tables?
> 
> Do you really expect more than 2.4 billion rows?

No, not really.
I guess my worries are groundless after all.

Thanks.
> 
> -- 
> Josh Berkus
> Aglio Database Solutions
> San Francisco


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/


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

Предыдущее
От: "向华东"
Дата:
Сообщение: Fw:
Следующее
От: Oleg Samoylov
Дата:
Сообщение: Re: How to drop all the sequences