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?
regards, tom lane