Re: views & triggers

Tom Lane wrote:

> Lieven Van Acker <lieven@elisa.be> writes:
> > does Postgresql 7.1 support triggers on a view actions?
>
> No, triggers apply to actual tuple insertions/updates/deletions,
> and a view never has any of those.  You'd need to set the triggers
> on the underlying real tables, instead.
>
> > Problem is I cannot easily set the trigger on the tables because of
> > permission issues...
>
> I think the long-term plan is for trigger functions to execute setuid
> to the table owner.  Will that help?

This should do for my current requirements.

Lieven