Re: Restart a sequence regularly - Mailing list pgsql-general

From Marco Colombo
Subject Re: Restart a sequence regularly
Date
Msg-id 47446E76.8040708@esi.it
Whole thread Raw
In response to Re: Restart a sequence regularly  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
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.

.TM.
--
      ____/  ____/   /
     /      /       /            Marco Colombo
    ___/  ___  /   /              Technical Manager
   /          /   /             ESI s.r.l.
 _____/ _____/  _/               Colombo@ESI.it


pgsql-general by date:

Previous
From: Sascha Bohnenkamp
Date:
Subject: Re: select with recursive support
Next
From: Sascha Bohnenkamp
Date:
Subject: Re: Primary Key