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.
 _____/ _____/  _/                     [EMAIL PROTECTED]


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

Reply via email to