Hi,

> 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
http://www.upscene.com/

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