[Monetdb-developers] next val, to be higher than the highest value
Hello,
I have run in some unexpected troubles related to the serial datatype. Is it possible to force the next value to be higher than the highest value already present in the sequence?
The behavior I now see is counter intuitive and starts to fill the empty values before this value first.
Stefan
On Thu, Aug 21, 2008 at 03:13:47AM +0200, Stefan de Konink wrote:
Hello,
I have run in some unexpected troubles related to the serial datatype. Is it possible to force the next value to be higher than the highest value already present in the sequence?
You can restart your serial/auto_increment or sequence number if you have a sequence number object name.
To see the sequence numbers
SELECT q.name, s.name, q."start", q."minvalue", q."maxvalue", q."increment", q.cacheinc, q."cycle" FROM SEQUENCES q, SCHEMAS s where s.id = q.schema_id;
example restart
ALTER SEQUENCE "mytest" RESTART WITH 10;
Niels
The behavior I now see is counter intuitive and starts to fill the empty values before this value first.
Stefan
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 Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
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.
participants (3)
-
Fabian Groffen
-
Niels Nes
-
Stefan de Konink