Re: views & triggers

From: Lieven Van Acker <lieven(at)elisa(dot)be>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: views & triggers
Date: 2001-05-07 16:22:35
Message-ID: 3AF6CBCB.201BA217@elisa.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

> Lieven Van Acker <lieven(at)elisa(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-05-07 16:24:46 Re: bugs or no in PostgreSQL 7.1 ?
Previous Message David Wall 2001-05-07 16:20:35 Re: Timestamp Resolution in Postgres