Re: wCTE behaviour - Mailing list pgsql-hackers

From Tom Lane
Subject Re: wCTE behaviour
Date
Msg-id 26007.1298654275@sss.pgh.pa.us
Whole thread Raw
In response to Re: wCTE behaviour  (Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>)
List pgsql-hackers
Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi> writes:
> On 2011-02-25 6:12 PM, Tom Lane wrote:
>> The current implementation with everything in one plantree
>> really ought to look just like a SELECT so far as the portal code
>> is concerned.

> The problem was that the old code was using PORTAL_MULTI_QUERY whenever 
> a wCTE was present.  Are you saying that you are using 
> PORTAL_ONE_SELECT?  Doesn't that have problems with triggers, for example?

Hmmm ... good question.  I notice the lack of any regression test cases
involving triggers.  Will check this.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: WIP: cross column correlation ...
Next
From: Greg Stark
Date:
Subject: Re: wCTE: why not finish sub-updates at the end, not the beginning?