Re: Locking of auto generated sequence

From: Richard Huxton <dev(at)archonet(dot)com>
To: sid tow <siddy_tow(at)yahoo(dot)com>
Cc: psql mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Locking of auto generated sequence
Date: 2005-02-01 12:10:43
Message-ID: 41FF71C3.9000401@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey 2005-02-01 13:42:56 Re: PostgreSQL Security Release
Previous Message sid tow 2005-02-01 11:00:07 Locking of auto generated sequence