Re: Dumped SQL failed to execute with ERROR "GROUP BY position -1 is not in select list" - Mailing list pgsql-hackers

From David Rowley
Subject Re: Dumped SQL failed to execute with ERROR "GROUP BY position -1 is not in select list"
Date
Msg-id CAApHDvp2Bvjjd0gVha0s-8CBkN8k5t5VjOBWVTqQ_jDdFDD87w@mail.gmail.com
Whole thread Raw
In response to 答复: Dumped SQL failed to execute with ERROR "GROUP BY position -1 is not in select list"  (Haotian Chen <charliett2233@outlook.com>)
Responses Re: Dumped SQL failed to execute with ERROR "GROUP BY position -1 is not in select list"
List pgsql-hackers
On Mon, 4 Dec 2023 at 02:38, Haotian Chen <charliett2233@outlook.com> wrote:
> Yes, I updated my patch and just used oid numbers 558 and 1751 stand for
> int4um and numeric_uminus. Maybe we could define a macro for them,
> but seems unnecessary.

The thing to do here is modify pg_operator.dat and give both of these
operators an "oid_symbol". Perhaps Int4NegOperator is ok.  (I think
Int4UnaryMinusOperator might be on the verbose side.).  The code that
parses pg_operator.dat will then define that constant in
pg_operator_d.h.  You can then use that and the other ones you defined
for the numeric operator instead of hard coding the Oids in the patch.

David



pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Change GUC hashtable to use simplehash?
Next
From: Davin Shearer
Date:
Subject: Re: Emitting JSON to file using COPY TO