Re: BUG #18587: PLPGSQL : conflict between variable and ON CONFLICT (a_column)
От | David G. Johnston |
---|---|
Тема | Re: BUG #18587: PLPGSQL : conflict between variable and ON CONFLICT (a_column) |
Дата | |
Msg-id | CAKFQuwb1AxxOBR-0BkUwZypjs8tqdFLSsTa46Xwxkkm+xdQxbg@mail.gmail.com обсуждение исходный текст |
Ответ на | BUG #18587: PLPGSQL : conflict between variable and ON CONFLICT (a_column) (PG Bug reporting form <noreply@postgresql.org>) |
Ответы |
Re: BUG #18587: PLPGSQL : conflict between variable and ON CONFLICT (a_column)
|
Список | pgsql-bugs |
On Wednesday, August 21, 2024, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 18587
Logged by: Rémi Cura
Email address: remi.cura@gmail.com
PostgreSQL version: 16.3
Operating system: Linux
Description:
Writing a PLPGSQL function returning a table with a column named id, and
using the same column name id in a INSERT ON CONFLICT (id) makes plpgsql
error.
See prior discussions.
In short, the benefit-to-cost ratio to change things here is very low so it’s likewise a very low priority for everyone who write patches (and probably needs a fairly experienced hacker too).
David J.
В списке pgsql-bugs по дате отправления: