Re: Re: ERROR: Aggref found in non-Agg plan node (introducesd in commit 3bf05e096b9f8375e640c5d7996aa57efd7f240c)

On Tue, Feb 27, 2018 at 4:55 PM, Andreas Joseph Krogh <andreas(at)visena(dot)com>
wrote:

> På tirsdag 27. februar 2018 kl. 12:16:42, skrev Jeevan Chalke <
> jeevan(dot)chalke(at)enterprisedb(dot)com>:
>
> Hi,
>
> On Tue, Feb 27, 2018 at 3:46 PM, Andreas Joseph Krogh <andreas(at)visena(dot)com>
> wrote:
>>
>> $subject
>>
>> The query I'm using is 14K and I have not produced a test-case, so this
>> is just a heads-up.
>>
>
> Rajkumar off-list shared same issue with me. And I have posted a fix for
> the same (https://www.postgresql.org/message-id/CAM2+6=X9kxQoL2ZqZ00E
> 6asBt9z+rfyWbOmhXJ0+8fPAyMZ9Jg(at)mail(dot)gmail(dot)com)
>
> Can you please check if that fixes your test-case or not?
>
>
>
> Applying fix_aggref_in_non-agg_error.patch (only) fixes the issue
>

Thank you Andreas for confirming.

>
> --
> Andreas Joseph Krogh
> ​
>

--
Jeevan Chalke
Technical Architect, Product Development
EnterpriseDB Corporation
The Enterprise PostgreSQL Company