Re: Proposal / proof of concept: Triggers on VIEWs - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: Proposal / proof of concept: Triggers on VIEWs
Date
Msg-id AANLkTikahtRm7qY4wa8Mje-wvHBaV_bkgq5WL-0DfBKS@mail.gmail.com
Whole thread Raw
In response to Re: Proposal / proof of concept: Triggers on VIEWs  (Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>)
Responses Re: Proposal / proof of concept: Triggers on VIEWs  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List pgsql-hackers
On 14 August 2010 13:12, Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi> wrote:
> On 2010-08-08 1:45 PM +0300, I wrote:
>>
>> On 8/8/2010 12:49 PM, Dean Rasheed wrote:
>>>
>>> For those migrating code from Oracle, providing this feature as-is
>>> might be valuable, since presumably they are not too concerned about
>>> these concurrency issues. Ideally we'd want to do better though.
>>
>> Yes, you might be right.  This feature on its on can greatly simplify
>> what people now have to do to get triggers on views.
>
> This weekend I had the luxury of working with our VIEW system, and it seems
> like I greatly underestimated the power of this feature, even if the
> concurrency issues I've mentioned in this thread would be left unaddressed.
>
> I haven't looked at the patch yet (I plan to do so), but +100 for this
> feature.
>

Thanks for your feedback. I'd be interested in any ideas on the
concurrency issues.

> Should we expect a new patch any time soon?
>

I hope to look at this again tomorrow.
I'll try to post an updated patch then, with some real trigger code,
but without addressing any of the concurrency issues.

Regards,
Dean


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: more personal copyrights
Next
From: KaiGai Kohei
Date:
Subject: Re: security label support, part.2