Re: Possible bug in CASE evaluation - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Possible bug in CASE evaluation
Date
Msg-id CAFj8pRBAmhXO1ne-Xc2EjgPeM5S+R=CzZt5M50rMU8BjhyOW0Q@mail.gmail.com
Whole thread Raw
In response to Re: Possible bug in CASE evaluation  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
2013/6/21 Andres Freund <andres@2ndquadrant.com>:
> Hi,
>
>
> On 2013-06-21 08:16:22 +0000, Albe Laurenz wrote:
>> I want to draw attention to this thread on -general:
>> CAMQ5dGq4SuJPbhT2-9XLAPAsvKNUL2-bb0cPyci2Fp+pfSfc3g@mail.gmail.com
>
> There's also a bug reported for it:
> #8237: E1Uovmc-0007FT-R4@wrigleys.postgresql.org
>
>> Would you concur that this is a bug?
>
> Yes, I think it's pretty clearly a bug - Tom doesn't seem think so
> though. If we can agree it is, the fix outlined over on -bugs seems to
> be easily enough implemented...

fix is not easy :-( you should to catch any possible exception, so it
means, so you should to do some optimalization under subtransactions -
or you should not do this kind of optimizations.

Pavel

>
> Greetings,
>
> Andres Freund
>
> --
>  Andres Freund                     http://www.2ndQuadrant.com/
>  PostgreSQL Development, 24x7 Support, Training & Services
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers



pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: [PATCH] Add session_preload_libraries configuration parameter
Next
From: Hitoshi Harada
Date:
Subject: Re: Patch for removng unused targets