|Subject||Re: [IB-Architect] Updatable views|
> From: Jim StarkeyJim,
> 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.
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 ?