Re: Restart a sequence regularly

From: "Kathy Lo" <kathy(dot)lo(dot)ky(at)gmail(dot)com>
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-22 01:39:11
Message-ID: c10e7feb0711211739w42140dbesaa82e7da16b759dd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/22/07, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Nov 21, 2007 11:44 AM, Marco Colombo <marco(at)esi(dot)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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
Thanks for your help!

Would you mind to give me an example on how to write this kind of function?

--
Kathy Lo

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2007-11-22 02:20:30 Re: [GENERAL] POLL: Women-sized t-shirts for PostgreSQL
Previous Message Kathy Lo 2007-11-22 01:37:38 Re: Restart a sequence regularly