Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: ORDER/GROUP BY expression not found in targetlist - Mailing list pgsql-hackers

From Rajkumar Raghuwanshi
Subject Re: ERROR: ORDER/GROUP BY expression not found in targetlist
Date
Msg-id CAKcux6njve6G2gkBtijEXWS2U8F+3ggGYOybtKOi4cHPJU3m0A@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: ORDER/GROUP BY expression not found in targetlist  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view
Thanks for commit. I have verified reported case. it is fixed now.

Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation

On Thu, Jun 21, 2018 at 1:54 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
I wrote:
> Thanks for the report.  I traced through this, and the problem seems to
> be that split_pathtarget_at_srfs() is neglecting to attach sortgroupref
> labeling to the extra PathTargets it constructs.  I don't remember
> whether that code is my fault or Andres', but I'll take a look at
> fixing it.

Here's a proposed patch for that.

                        regards, tom lane


pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Speeding up INSERTs and UPDATEs to partitioned tables
Next
From: Rajkumar Raghuwanshi
Date:
Subject: Re: partition table and stddev() /variance() behaviour