views & triggers

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

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