Re: Locking of auto generated sequence - Mailing list pgsql-general

From Richard Huxton
Subject Re: Locking of auto generated sequence
Date
Msg-id 41FF71C3.9000401@archonet.com
Whole thread Raw
In response to Locking of auto generated sequence  (sid tow <siddy_tow@yahoo.com>)
Responses Re: Locking of auto generated sequence
List 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 by date:

Previous
From: sid tow
Date:
Subject: Locking of auto generated sequence
Next
From: Geoffrey
Date:
Subject: Re: PostgreSQL Security Release