Hi, I'm trying to create in the main db a trigger on after insert on
ATTACHED_DB.TABLE but I get an error
SQL error: trigger TEST_TRIGGER cannot reference objects in database
ATTACHED_DB
Can I obtain TABLE_1 in the attached db and TABLE_2 and TRIGGER (who read
from TABLE_1 and write to TABLE_2)
You cannot create a trigger which crosses between databases because
the system cannot know that the database will be attached when the
trigger fires. Triggers are part of the consistency guarantee, so
this is bad.
It would be interesting to have something like CREATE TEMPORARY
TRIGGER ... which