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  (sid tow <siddy_tow@yahoo.com>)
Список pgsql-general
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
Дата:
Сообщение: Locking of auto generated sequence
Следующее
От: Geoffrey
Дата:
Сообщение: Re: PostgreSQL Security Release