Re: Keys larger than 2 Billion

marco greco wrote: > > Sorry, guys my fault. > > I was honestly convinced that serial uniqueness was enforced even without any unique index on the serial column. This false belief dates back to ver 1.xx.xx, when no integrity checks were available in the create table statement: an acritic read of the manuals ("serials are unique sequential integers assigned automatically by informix"), coupled with the fact that you had to create the unique index by hand, or rely on isql to have it automatically created, convinced me of this. Of course, I've n > > OK - serial w/o unique index + timestamp is just fine. > OK, Now I am confused. (Yes, that does happen occasionally when I sober up. ;-) A serial field by definition creates a unique index on the serial column. Are you suggesting to create the table, then either alter the index or drop the index on a serial column? Is that possible? -Mikey