Re: Keys larger than 2 Billion

Mike, no. The whole point here is that the engine does NOT create a unique index on the serial. The schema editor does, but not the engine. To have it created by the engine, you'd have to create table Mike (marco serial primary key # or unique, for that matter ..... ) So you don't even need to drop the index, if you don't use isql/dbaccess (And that was where I got confused...) ciao, Marco ____________________________________________________________________________ rem radioterapia, which I immeritately manage, seldom agrees with what I say marco greco (Catania, Italy) Work: marcog@ctonline.it rem radioterapia 39 95 447828 fax 446558 (was mar.greco@agora.stm.it) Achea 39 95 503117 --- On Mon, 23 Sep 1996 22:13:36 +0000 Mike Segel <mikey@segel.com> wrote: >marco greco wrote: > > [deleted my insightfull comment :-)] > > >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 > -----------------End of Original Message-----------------