Re: Keys larger than 2 Billion
Mike Segel wrote:
>
> 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,
> >
> > 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
Creating a serial column in an ONLINE engine does not create a
unique index on the column (at least through straight SQL statements,
if you use the dbaccess create table menu it might).
But if you run the following SQL it will not give you an
error:
create table tab1 (col1 serial);
insert into tab1 values(1);
insert into tab1 values(1);
--
********************************************************************
* Jacques P. Renaut "I'd dazzle you with brilliance *
* Informix Advanced Support if I only had the knack..." *
* email: jrenaut@informix.com #include <disclamier.h> *
* *
* Laube on Xanadu: "The movie sucked... *
* but the music was awesome!!!!" *
********************************************************************