Re: Rules: A Modest Proposal

On Sun, Oct 4, 2009 at 10:01 PM, Alvaro Herrera
<alvherre(at)commandprompt(dot)com> wrote:
> Robert Haas escribió:
>
>> > While I don't agree with David Fetter's premise, I think rehashing how
>> > we handle VIEWs would be a good step towards updatable views.  Right
>> > now, the implementation of that is stalled precisely because of the rule
>> > system.
>>
>> This is the last I remember hearing of it, which seems to suggest that
>> only a week's worth of work (maybe a bit more for those of us who are
>> not Tom Lane) is needed:
>
> Right, that's exactly what I meant.  Note that a week's worth of Tom
> work in that area is probably measured in months for anybody else ("a
> bit more" in your words),

:-)

> and this fits my definition of "rehashing view
> handling".

The trick is to get rid of the self-join, I suppose, but it's unclear
to me whether some change to the existing view handling would make
that easier. Do you have an idea?

...Robert