==================================================================================
> 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

 

What exact version of FB2.5

i tested this on WI-V2.5.3.26738 Firebird 2.5 

 

but on Windows not Linux and no problems.

Do you have free disc space? May be db try to expand?

 

 

regards,

Karol Bieniaszewski