De-/activating a trigger should not have influence of possible metadata
changes, however there are alternatives for doing the same. How about using
special generators (set 0 or 1) or user accounts (IF (User="REPLICA") then
... else ...) for conditional running trigger?

Mit freundlichem Gruss & Best Regards

Andreas Pohl
apohl@...
http://www.ibp-consult.com

-----Ursprüngliche Nachricht-----
Von: <ib-support@egroups.com>
An: <ib-support@egroups.com>
Gesendet: Donnerstag, 11. Januar 2001 10:29
Betreff: [ib-support] Digest Number 35


Date: Wed, 10 Jan 2001 09:35:14 +0100
From: Fabrice Vendé - INFOCOB <fabrice@...>
Subject: Unsuccessful metadata update...

Hello,

With Interbase 6.0.
I try to activate or desactivate a trigger with :

ALTER TRIGGER PRODUCT_AINSERT INACTIVE;

Interbase return me the following error message :
"Unsuccessful metadata update
TABLE PRODUITFICHE
too many versions
Statement: ALTER TRIGGER PRODUCT_AINSERT INACTIVE;"

I have heard that message come after 255 (256 ?) update.

I need to exchange data between interbase databases. When I exchange data I
need to desactivate some triggers.
One of them generate a new product number on insert ?

Does this error message will happen after 255 update ?

Fabrice Vende
fabrice@...

-
SARL I N F O C O B
Developpement, formation, matériel, logiciel
http://www.infocob.com