Subject Re: [firebird-support] Re: 1.5.3 NONE -> 2.5 UNICODE_FSS
Author Paul Vinkenoog
Hi,

> > > *** IBPP::SQLException ***
> > > Context: Transaction::Commit
> > >
> > > SQL Message : -607
> > > This operation is not defined for system tables.
> > >
> > > Engine Code : 335544351
> > > Engine Message :
> > > unsuccessful metadata update
> > > cannot create index PK_TEST_1
> > >
> > > This is a very simple index on an not null integer column (and no data in table, of course).
> > >
> > > Any clues?
> >
> > Care to send me a metadata backup of your database privately and I will
> > give it go with the most recent versio of DBW?
> >
> >
>
> That was a generous offer, but I am not ready to give up yet :)
>
> The error above came from me using 'now' and 'today' literals in domain definitions. It seems they are no longer in use.

They are still in use, and they can be used in domain definitions. But you said that the failing index was on an _integer_ column.


Cheers,
Paul Vinkenoog