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 485520.1660227795@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, Tom Lane wrote:
>> 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.

> I tried, but couldn't find the location anywhere.  None of the nodes for
> ModifyTable statements have location :-(

Ah, right, in particular MergeStmt doesn't.

> We could add one now -- while
> it's a bit late for 15, we're likely going to have a catversion bump due
> to the JSON revert, so it might be fine.

Nah, not worth it just for this.

            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: Ajin Cherian
Date:
Subject: Re: Excessive number of replication slots for 12->14 logical replication