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