Subject Re: [firebird-support] unwanted triggers present
Author Thomas Steinmaurer

> in my db some tables have strange triggers: 'CHECK_X' ACTIVE POSITION 1
> AFTER UPDATE or AFTER DELETE where the 'X' is a number. All these
> triggers are empty (seeing them with flamerobin).
> I tried to delete them but after this i have had to restore a backup
> because the db was malfunctioning.
> It was originally created with interbase and then moved to firebird.
> The DB works properly but these 'presences' are very odd.

This are internal/system triggers used by Firebird to implement
field-based CHECK constraints.

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.