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

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: How to make sequence skip existing key in table?
Дата
Msg-id 200302180907.21014.josh@agliodbs.com
обсуждение исходный текст
Ответ на How to make sequence skip existing key in table?  (Raymond Pau <rpau@yahoo.com>)
Ответы Re: How to make sequence skip existing key in table?  (Raymond Pau <rpau@yahoo.com>)
Список pgsql-sql
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?

--
Josh Berkus
Aglio Database Solutions
San Francisco


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

Предыдущее
От: Jeff Eckermann
Дата:
Сообщение: Re:
Следующее
От: Dave Gomboc
Дата:
Сообщение: select from update from select?