DEFAULT SERIAL

 it should work.

did you try with other tables ?

I had the same problem with one table among 15 - 14 worked, one not. I had
deleted and recreated  the default value several times - maybe this was the
reason. 
Finally I recreated the table without default, inserted the records and then
added the default....

By the way, I am running 7.6.00.3, but this is not a version problem - I did
that on SAPDB and it worked.


I am having a problem when answering to this list - my answers are received
by the lists mailserver, but they never are added to the list. 

UH

-----Ursprüngliche Nachricht-----
Von: Erik Rehrmann [mailto:rehrmann@xxxxxx] 
Gesendet: Montag, 11. April 2005 20:31
An: maxdb@xxxxxxxxxxxxxxx
Betreff: Re: DEFAULT SERIAL

Hi,

this definitively does not work for us!

DROP DEFAULT
ADD DEFAULT SERIAL(1000)
INSERT RECORD
CURRVAL=9 (highest value in column=862)

:-(

MaxDB (7.5.00.18 on Linux, Tests via SQLStudio 7.5.00.03)

Any help is greatly appreciated

Erik


  >One can easily change the serial start value  by altering the default
  >serial(xx) to the desired  start value:
  >
  >
  >ALTER TABLE ownername.tablename COLUMN "columnname" DROP DEFAULT
  >
  >//
  >
  >ALTER TABLE ownername.tablename COLUMN "columnname" ADD DEFAULT
SERIAL(220)
  >
  >//
  >
  >Replace 220 with your record count + 1
  >
  >Greetings
  >UH

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=uha@xxxxxxxxxx




--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx