feature request: fire_triggers=only RI actions

[Former Member]

fire_triggers is a binary option: on or off. When off, triggers do not fire, but also you don't get any referential integrity checks or delete chaining. I'd like an option to turn off user-defined triggers, but preserve the RI actions.

The reason is that we have two apps simultaneously accessing the same db. The old app is heavily dependent on triggers. The new app is designed to NOT require triggers. We'd like to disable the triggers for connections initiated by the new app, but not lose the RI actions.

Pardon me if this is a repost: I posted yesterday but it didn't appear,probably because I had not yet validated my account here.

(PS: Hola to Breck and my other old buddies from the team!)

[Breck_Carter]

Welcome to a Charter Member of [TeamPS]... I wish there was a way to add 10,000 points to your account in recognition 🙂

[Breck_Carter]

I don't suppose you want to add a line of code to the top of each non-ri trigger?

IF VAREXISTS ( 'this_is_the_new_app' ) = 1 THEN RETURN;

and CREATE that variable in a login procedure if the connection is coming from the new application?

[VolkerBarth]

The poster of that older FAQ would have probably seconded that suggestion:

http://sqlanywhere-forum.sap.com/questions/11984/on-delete-cascade-not-functioning

I do, too.

---

FWIW, the dbsrvX -gf server option might then have to be extended, as well. Note, it is a server, not a database option, so it effects all databases on the engine.

[Former Member]

Yeah, we did something similar in sql server. would rather not revise our thousands of triggers on 750+ tables but maybe we will.

[Vlad]

I am curious, how do you develop and test the code that has thousands of triggers. Or they are isolated well from each other.

[Breck_Carter]

> thousands of triggers

[Former Member]

The old app is in Powerbuilder and has been in active development for more than 20 years. It's big. Because the design of the app does not funnel updates through a single update layer, triggers are used to assure certain business functions. We have extensive test suites, mostly regression tests using automation tools.