Re: WIP: Triggers on VIEWs

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: WIP: Triggers on VIEWs
Date: 2010-09-23 11:57:24
Message-ID: 3D83DE881171345EC3EC804F@amenophis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

--On 23. September 2010 08:59:32 +0100 Dean Rasheed
<dean(dot)a(dot)rasheed(at)gmail(dot)com> wrote:

> Yes, I agree. To me this is the least surprising behaviour. I think a
> more common case would be where the trigger computed a value (such as
> the 'last updated' example). The executor doesn't have any kind of a
> handle on the row inserted by the trigger, so it has to rely on the
> function return value to support RETURNING.

I didn't mean to forbid it altogether, but at least to document
explicitely, that the trigger returns a VIEW's NEW tuple, not the one of
the base table (and may modify it). But you've already adressed this in
your doc patches, so nothing to worry about further.

--
Thanks

Bernd

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Csaba Nagy 2010-09-23 12:26:13 Re: Configuring synchronous replication
Previous Message Marko Tiikkaja 2010-09-23 11:55:29 Re: ask for review of MERGE