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

> > > > > I'd like to add a serial column to a large (10 million rows) table and I want > > the numbering to be as if it was always there (1-10,000,000) > > > > I can figure out how to do it with load and unload, but this takes forever. > > > > Is there a faster method using SQL / 4GL? > > > > Add it as an integer then alter the table and make the column a serial. > > cheers > j. NEW BUG IN INFORMIX I found it interesting and tried in my INFORMIX-SE V5.x I created a table of 2 columns, one char(20), one integer. Added 4 rows with 2 rows duplicate of the first 2. Then altered the table to change integer to serial. While building the table got error message as cannot create index -- duplicate row ---- 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? ------- CHIDA -------