Postgres Pro
Downloads
Home   >   mailing lists

Thread: ERROR: Aggref found in non-Agg plan node (introducesd in commit3bf05e096b9f8375e640c5d7996aa57efd7f240c)

ERROR: Aggref found in non-Agg plan node (introducesd in commit3bf05e096b9f8375e640c5d7996aa57efd7f240c)

From
Andreas Joseph Krogh
Date:
$subject
 
The query I'm using is 14K and I have not produced a test-case, so this is just a heads-up.
 
--
Andreas Joseph Krogh
​
 

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

From
Jeevan Chalke
Date:
Hi,

On Tue, Feb 27, 2018 at 3:46 PM, Andreas Joseph Krogh <andreas@visena.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=X9kxQoL2ZqZ00E6asBt9z+rfyWbOmhXJ0+8fPAyMZ9Jg@mail.gmail.com)

Can you please check if that fixes your test-case or not?

Thanks

 
 
--
Andreas Joseph Krogh
​
 



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

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

From
Andreas Joseph Krogh
Date:
På tirsdag 27. februar 2018 kl. 12:16:42, skrev Jeevan Chalke <jeevan.chalke@enterprisedb.com>:
Hi,
 
On Tue, Feb 27, 2018 at 3:46 PM, Andreas Joseph Krogh <andreas@visena.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=X9kxQoL2ZqZ00E6asBt9z+rfyWbOmhXJ0+8fPAyMZ9Jg@mail.gmail.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
 
 
--
Andreas Joseph Krogh
​

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

From
Jeevan Chalke
Date:


On Tue, Feb 27, 2018 at 4:55 PM, Andreas Joseph Krogh <andreas@visena.com> wrote:
På tirsdag 27. februar 2018 kl. 12:16:42, skrev Jeevan Chalke <jeevan.chalke@enterprisedb.com>:
Hi,
 
On Tue, Feb 27, 2018 at 3:46 PM, Andreas Joseph Krogh <andreas@visena.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=X9kxQoL2ZqZ00E6asBt9z+rfyWbOmhXJ0+8fPAyMZ9Jg@mail.gmail.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