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.