Re: Rewrite, normal execution vs. EXPLAIN ANALYZE - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Rewrite, normal execution vs. EXPLAIN ANALYZE
Date
Msg-id AANLkTi=nXWxQaeMteVLBu5d6_ujW7asJKhTzeqOV8on2@mail.gmail.com
Whole thread Raw
In response to Re: Rewrite, normal execution vs. EXPLAIN ANALYZE  (David Fetter <david@fetter.org>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Rewrite, normal execution vs. EXPLAIN ANALYZE
Next
From: Dimitri Fontaine
Date:
Subject: Re: bg worker: overview