At 12:58 PM 12/4/01 +0100, Ivan Prenosil wrote:

>> That is correct. Any pre-insert trigger was presumed to override
>> any automatic view insert semantics.
>
>o.k., here is one more exaple:
>
>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 ?
>

That rather depends on what the trigger "trw" does. If it
does an insert into view "v", then yes, of course. If not,
then no, of course not.

Jim Starkey