Re: Triggers on Views fire for table?

"Luch" <optimaljedi_at_nospam.net> ha scritto nel messaggio news:dFXO7.26383$WC1.2733755_at_newsread2.prod.itd.earthlink.net...
> I have table t_table with view v_view on it (create view v_view as select
*
> from t_table;)
>
> What I want is to place a trigger on the view v_view, so that when an
insert
> or upate is done into t_table the trigger fires. Is this possible? The
> reason I ask is because I only have access to the v_view, and I don't even
> know (or have rights) to what table it's coming from.
>
> When I try placing a trigger on v_view, it only fires if an insert/update
is
> done "through" the view itself, but not the table. Is this the only way
> triggers on views work?

The trigger fires when an event on the object they are based occurs, not when en event on some other object....
The view is unaware of the changes on the table untill it is queryied.

Giovanni Bronzini
>
> --
> Luch
> replace nospam with usa for e-mail.
>
>
>
>
Received on Sun Dec 09 2001 - 17:49:28 CST