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:[EMAIL PROTECTED] Gesendet: Montag, 11. April 2005 20:31 An: [email protected] 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/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
