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@xxxxxx ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/