Andrea,

> I'm facing a quite serious problem. Please tell me whether I'm doing
> something wrong or I've found a bug.

One thing I can tell you for sure is that you've missed a feature.
Firebird allows you to define multiple triggers and specify the order of
firing and the operation on which they will be fired. The reason for
allowing multiple triggers is to avoid piles of spaghetti code and
sequences of unrelated actions - each trigger performs a specific
operation and can be deactivated for testing.

As a general thing, using double quotes on object names is a waste of
time. If you need to use a reserved word as a column or table or
procedure or view name, OK, that's a good reasons. If you need to use a
name with a space or a non-ascii character, OK, that's a good reason.
If you like typing double quotes everywhere, that's a reason but not one
that's going to please many of us who answer questions on this list.

When I finish disentangling your trigger, I'll try to have a better answer.

Regards,


Ann