> Thanks Martijn
>
> So it will work on FireBird 2.0 ?

Firebird 2.0 increases the possible maximum index size, so probably yes.

However, you might want to re-visit this particular PK anyway, given it's
horrendous number of columns.

>
> --- In firebird-support@yahoogroups.com, "Martijn Tonies"
> <m.tonies@u...> wrote:
> >
> >
> > > CREATE TABLE ispFmt10 (RCA SMALLINT DEFAULT 1 NOT NULL,DORD
> VARCHAR
> > > (1) NOT NULL,DNME VARCHAR(100),MMOD VARCHAR(50) NOT NULL,MODL
> VARCHAR
> > > (50) NOT NULL,SMOD VARCHAR(50) NOT NULL,CurrOpt VARCHAR(1) NOT
> > > NULL,DTYP VARCHAR(3) NOT NULL,SID INTEGER DEFAULT 0 NOT NULL,SNODE
> > > VARCHAR(50),FL1 VARCHAR(50),FLDFR VARCHAR(50),MDBN VARCHAR
> (50),LnkMdb
> > > VARCHAR(50),LKT VARCHAR(50) PRIMARY KEY
> > > (RCA,DORD,MODL,MMOD,SMOD,DTYP,SID))
> > >
> > > While Executing the query it gives the following error
> > >
> > > key size too big for index RDB$PRIMARY13.
> >
> > Well, the server is right, assuming Firebird < 2.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com