Re: BUG #17579: 15beta2: strange error when trying to use MERGE statement as a CTE

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #17579: 15beta2: strange error when trying to use MERGE statement as a CTE
Дата
Msg-id 485520.1660227795@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #17579: 15beta2: strange error when trying to use MERGE statement as a CTE  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: BUG #17579: 15beta2: strange error when trying to use MERGE statement as a CTE  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #17579: 15beta2: strange error when trying to use MERGE statement as a CTE
Следующее
От: Ajin Cherian
Дата:
Сообщение: Re: Excessive number of replication slots for 12->14 logical replication