Re: BUG #17579: 15beta2: strange error when trying to use MERGE statement as a CTE - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #17579: 15beta2: strange error when trying to use MERGE statement as a CTE
Date
Msg-id 481803.1660225028@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #17579: 15beta2: strange error when trying to use MERGE statement as a CTE  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: BUG #17579: 15beta2: strange error when trying to use MERGE statement as a CTE
List pgsql-bugs
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> On 2022-Aug-11, Richard Guo wrote:
>> +1 to disallow it for now.

> This patch does that.

The parse error location seems quite oddly chosen.  Can you make
it point at the MERGE instead?  I think exprLocation(cte->ctequery)
might work, but not sure.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #17579: 15beta2: strange error when trying to use MERGE statement as a CTE
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #17579: 15beta2: strange error when trying to use MERGE statement as a CTE