Re: Rewrite, normal execution vs. EXPLAIN ANALYZE

On Fri, Jul 23, 2010 at 3:31 PM, David Fetter <david@fetter.org> wrote:
> On Fri, Jul 23, 2010 at 03:30:03PM -0400, Robert Haas wrote:
>> On Fri, Jul 23, 2010 at 3:19 PM, Marko Tiikkaja
>> <marko.tiikkaja@cs.helsinki.fi> wrote:
>> > This may be a bit hard to follow, but essentially what happens is
>> > that in EXPLAIN ANALYZE, the INSERT in the rule does not see the
>> > changes made by T2 to baz while in the regular execution scenario
>> > it does.
>>
>> Well that's gotta be a bug, but in what I'm not sure.
>
> I've said it before, and I'll say it again.  User-accessible RULEs are
> themselves a bug :P

Maybe so, but perhaps it would be more productive to concentrate on
solving the immediate problem first.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company