Re: Restart a sequence regularly

From: Marco Colombo <marco(at)esi(dot)it>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Restart a sequence regularly
Date: 2007-11-21 17:44:22
Message-ID: 47446E76.8040708@esi.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)ESI(dot)it

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-11-21 17:51:03 Re: loading a funtion script from a file
Previous Message Scott Marlowe 2007-11-21 17:35:21 Re: loading a funtion script from a file