Re: Adding a serial column to a table. (fwd)

-- chida@psi.ernet.in wrote: >... > But INFOMIX altered the table with serial column without unique index. > > and the table contains duplicate values for serial column. > > Isn't it a bug? No. SERIAL isn't guaranteed unique without a UNIQUE INDEX (or PRIMARY KEY CONSTRAINT, which is the moral equivalent), INSERT statements with the serial value = 0 are guaranteed unique, but ALTERing or INSERTing with a specific value will work. This is documented, and is how it always worked, and I'll bet the way it always will. ======================================================== ////////// // Dennis J. Pimple Informix Software, Inc. ////// / /// Principal Consultant 5299 DTC Blvd Suite 740 ///// // //// dennisp@informix.com Englewood CO 80111 //// // ///// /// // ////// recept: 303-850-0210 // // /////// direct: 303-740-5611 Opinions expressed are mine, / /////////// fax: 303-843-6408 and do not necessarily //////////////// http://www.informix.com reflect those of my employer