> From: Jim Starkey
> This is not the way I designed and implemented views with triggers.
> Ann tells me the behavior was changed around the time of Version 4.
> [Comments on the general quality of V4 engineering omitted.]
>
> It makes absolutely no sense for "updateable" views to have one
> behavior and "non-updatable" views another. The original view
> update rules were clear and consistent: A before operation trigger
> on view preempts any system level ESP. This behavior is simple,
> consistent, intuitive, and powerful.

Jim,
Just to be sure I understand you right:

CREATE TABLE tab (...);

CREATE VIEW v AS
SELECT * FROM tab;

CREATE TRIGGER tr FOR v BEFORE INSERT ...;

Are you saying that this command
INSERT INTO v (...) VALUES (123);
should fire trigger tr, but should _not_ insert 123 directly into table tab ?

Ivan