Re: Possible bug in CASE evaluation

2013/6/21 Andres Freund <andres(at)2ndquadrant(dot)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(at)mail(dot)gmail(dot)com
>
> There's also a bug reported for it:
> #8237: E1Uovmc-0007FT-R4(at)wrigleys(dot)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers