How to make sequence skip existing key in table?

Поиск
Список
Период
Сортировка
От Raymond Pau
Тема How to make sequence skip existing key in table?
Дата
Msg-id 20030218100134.91784.qmail@web14204.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: trigger after with cursor  (Christoph Haller <ch@rodos.fzk.de>)
Ответы Re: How to make sequence skip existing key in table?  (Bruno Wolff III <bruno@wolff.to>)
Re: How to make sequence skip existing key in table?  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-sql
Дерево обсуждения 
Hi List,

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?

Regards,

Raymond Pau

__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com

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

Предыдущее
От: Christoph Haller
Дата:
Сообщение: Re: trigger after with cursor
Следующее
От: Rajesh Kumar Mallah
Дата:
Сообщение: " Adding missing FROM-clause entry for table .... " problem.