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