Re: Why can't I put a BEFORE EACH ROW trigger on a view?

On 02/24/2007 06:25:54 PM, Joshua D. Drake wrote:

> create your table, create your triggers on the table.
> Use a view on top of the table for viewing (there is no such thing as
> a
> select rule (well there is, but it is called a view)).

Yes, and you can't put a BEFORE EACH ROW trigger
on a view, which is my problem.  I have _additional_
constraints to place on modifications done through
views, and trickyness involved in modifying the
underlying tables.

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein