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. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
