guaranteeing that a sequence never skips

Поиск
Список
Период
Сортировка
От David Garamond
Тема guaranteeing that a sequence never skips
Дата
Msg-id 41601392.5000800@zara.6.isreserved.com
обсуждение исходный текст
Ответы Re: guaranteeing that a sequence never skips  ("Scott Marlowe" <smarlowe@qwest.net>)
Список pgsql-general
Am I correct to assume that SERIAL does not guarantee that a sequence
won't skip (e.g. one successful INSERT gets 32 and the next might be 34)?

Sometimes a business requirement is that a serial sequence never skips,
e.g. when generating invoice/ticket/formal letter numbers. Would an
INSERT INTO t (id, ...) VALUES (SELECT MAX(col)+1 FROM t, ...) suffice,
or must I install a trigger too to do additional checking?

--
dave


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

Предыдущее
От: Mike Rylander
Дата:
Сообщение: Re: Query problem...
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: sequence rename?