Subject | Re: [IB-Architect] Updatable views |
---|---|
Author | Ivan Prenosil |
Post date | 2001-12-04T11:58:46Z |
> That is correct. Any pre-insert trigger was presumed to overrideo.k., here is one more exaple:
> any automatic view insert semantics.
CREATE TABLE tab (...);
CREATE VIEW v AS
SELECT * FROM tab;
CREATE TRIGGER trv FOR v BEFORE INSERT ...;
CREATE VIEW w AS
SELECT * FROM v;
CREATE TRIGGER trw FOR w BEFORE INSERT ...;
Should this command
INSERT INTO w (...) ...;
fire both triggers trv and trw, or only trw ?
Ivan