Subject Failure to create primary key - 2.5, 64 bit, Linux
Author Tim Ward
==================================================================================
> CREATE TABLE TBLCSTAGASSETS
> (
> ELEMENTID BIGINT NOT NULL,
> USERID INTEGER NOT NULL,
> CONSTRAINT PK_TBLCSTAGASSETS PRIMARY KEY (ELEMENTID, USERID)
> )

> commit

< ERROR:

unsuccessful metadata update
cannot create index PK_TBLCSTAGASSETS

> script processed in 0.055 sec
==================================================================================

This works when run against a 32 bit 2.1 database but fails when run
against a 64 bit 2.5 database. What's going on please?

--
Tim Ward