On Nov 21, 2007 11:44 AM, Marco Colombo <marco@xxxxxx> 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
