Re: Restart a sequence regularly

On Nov 21, 2007 11:44 AM, Marco Colombo <marco@esi.it> wrote:
> Scott Marlowe wrote:
> > revoke all privs on the sequence to anyone but the user about to reset it
> > reset it
> > grant the options back
>
> Quoting the OP:
> > That means, when others want to access the sequence between
> > 31-Dec 23:59:55 and 1-Jan 00:00:05, they are waiting instead of
> > getting an error.
>
> If you remove the privs, clients will get an error, unless I'm missing
> something.

Good point.  I'm guessing if you need a way to make other users wait,
not get an error, you'll need to use a funtion with a security definer
that will sleep or something during that period.

hmmmmm.