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

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Sv: Re: ERROR: Aggref found in non-Agg plan node (introducesd in commit 3bf05e096b9f8375e640c5d7996aa57efd7f240c)
Date: 2018-02-27 11:25:24
Message-ID: VisenaEmail.14.1cc3a749dd01d530.161d7008756@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

På tirsdag 27. februar 2018 kl. 12:16:42, skrev Jeevan Chalke <
jeevan(dot)chalke(at)enterprisedb(dot)com <mailto: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
<mailto: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=X9kxQoL2ZqZ00E6asBt9z+rfyWbOmhXJ0+8fPAyMZ9Jg@mail.gmail.com

<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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Etsuro Fujita 2018-02-27 12:01:02 Re: [HACKERS] Add support for tuple routing to foreign partitions
Previous Message Rajkumar Raghuwanshi 2018-02-27 11:21:07 Re: parallel append vs. simple UNION ALL