Re: INSERT ... ON CONFLICT doesn't work - Mailing list pgsql-general

From David G. Johnston
Subject Re: INSERT ... ON CONFLICT doesn't work
Date
Msg-id CAKFQuwZEAOUEyXA07JCpU3zu6JZyDV5sEzJdjLfaQNvY_EDE_w@mail.gmail.com
Whole thread Raw
In response to Re: INSERT ... ON CONFLICT doesn't work  ("Jenda Krynicky" <Jenda@Krynicky.cz>)
List pgsql-general
On Wed, Dec 1, 2021 at 1:04 PM Jenda Krynicky <Jenda@krynicky.cz> wrote:
I did not create the table and I did not forget the quotes. I removed
them in one of many attempts to appease PostgreSQL. I've already
learned about those braindead rules.


Nothing is perfect, especially something that started decades ago and has to be concerned about ongoing compatibility.  The best part is you got some clarification (that the RETURNS column is indeed the main cause of the issue) quickly from two different people and eventually came across the #variable_conflict hack that at least here is the least invasive solution to what is arguably a deficiency in the interaction between SQL and pl/pgsql.  They happen, again nothing is perfect.

David J.
 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: INSERT ... ON CONFLICT doesn't work
Next
From: Adrian Klaver
Date:
Subject: Re: INSERT ... ON CONFLICT doesn't work