Re: Locking of auto generated sequence

Поиск
Список
Период
Сортировка
Искать
От
Richard Huxton
Тема
Re: Locking of auto generated sequence
Дата
Msg-id
41FF71C3.9000401@archonet.com
Ответ на
Список
Дерево обсуждения
Locking of auto generated sequence sid tow <siddy_tow@yahoo.com>
Re: Locking of auto generated sequence Richard Huxton <dev@archonet.com>
Re: Locking of auto generated sequence sid tow <siddy_tow@yahoo.com>
Re: Locking of auto generated sequence Richard Huxton <dev@archonet.com>
sid tow wrote:
> Hi All,
> 
> Is there a way to stop a auto generated sequence from incrementing
> for some time and then activate it to do the increments.

You might be able to do something by revoking permissions to the 
sequence, and wrapping nextval/currval with security=owner functions. If 
you can describe what you're trying to achieve and why that might help.

--
   Richard Huxton
   Archonet Ltd
В списке pgsql-general по дате отправления
От: sid tow
Дата:
От: Geoffrey
Дата:
FAQ