--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
wrote:

> Sorry, I don't see any difference here from the original report.

In the first example 'number' column has a PK constraint, in the
second one a foreign key constraint (with possible duplications),
but it's seems to me the problem is the same.

>
> >In more realistic situations, Firebird sometimes reports SQLCODE -
> >902.
>
> Could that be because you are trying to add constraints/data to
> tables that you haven't committed?
>
> ./heLen

It happens also with committed data, but I haven't a simple,
repeatable, testcase for error code -902.


Manlio Morini