Search Postgresql Archives

Re: INSERT ... ON CONFLICT doesn't work

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Dec 1, 2021 at 1:04 PM Jenda Krynicky <Jenda@xxxxxxxxxxx> 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.
 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux