[firebird-support] unwanted triggers present

2014-08-13 Thread fvillan...@essedata.it [firebird-support]
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

Re: [firebird-support] unwanted triggers present

2014-08-13 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
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

[firebird-support] Triggers

2014-08-13 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Hello. Is it possible to change/delete a trigger while it´s in use? -- Atenciosamente, Hugo Eyng

Re: [firebird-support] Triggers

2014-08-13 Thread Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
Hi Hugo, in use means, the database is attached? You can change triggers at any time, but as far as I konw, the change gets visible only after transaction is committed. Thomas Am 13.08.2014 19:53, schrieb Hugo Eyng hugoe...@msn.com [firebird-support]: Hello. Is it possible to