Subject [firebird-support] Re: Non null column, before insert trigger not filling column, Delphi
Author Svein Erling Tysvær
> My problem was/is that if I try the following:
>
> create table whatever (
> id integer,
> ...);
>
> alter table whatever add constraint pk_whatever
> primary key (id)
> using index some_index;
>
> Then an error occurs. The ID column is not changed to NOT NULL silently,
> and the command fails.
>
> Mike, on the other hand, *is* able to run the above command quite
> happily without getting an error. We are both using exactly the same
> version of Firebird - 2.1.3.

Have you checked whether your databases uses the same ODS?

Set