[Monetdb-developers] next val, to be higher than the highest value

Fabian Groffen Fabian.Groffen at cwi.nl
Thu Aug 21 14:08:27 CEST 2008

On 21-08-2008 13:04:50 +0200, Stefan de Konink wrote:
> Niels Nes schreef:
> > You can restart your serial/auto_increment or sequence number if you
> > have a sequence number object name.
> Is it technically correct that after a ROLLBACK a sequence is still 
> increased? Or is this the only way to guarantee safe transactions?

yep, a serial is always unique, and every value is only handed out once.

More information about the developers-list mailing list