Re: "command cannot affect row a second time" in INSERT ... ON CONFLICT

2024-10-31 Thread David G. Johnston
On Thu, Oct 31, 2024 at 9:52 AM Karthik Ramanathan < karthikram.3...@gmail.com> wrote: > I am looking to better understand the applicability of the error message > "command cannot affect row a second time". > > Consider the following table and data: > CREATE TABLE ioc (i int, UNIQUE(i)); > INSERT

Re: "command cannot affect row a second time" in INSERT ... ON CONFLICT

2024-10-31 Thread Aleksander Alekseev
Hi Karthik, > I am looking to better understand the applicability of the error message > "command cannot affect row a second time". > > Consider the following table and data: > CREATE TABLE ioc (i int, UNIQUE(i)); > INSERT INTO ioc VALUES (1); > > The following two queries produce different error

"command cannot affect row a second time" in INSERT ... ON CONFLICT

2024-10-31 Thread Karthik Ramanathan
Hello hackers, I am looking to better understand the applicability of the error message "command cannot affect row a second time". Consider the following table and data: CREATE TABLE ioc (i int, UNIQUE(i)); INSERT INTO ioc VALUES (1); The following two queries produce different errors: *Query 1*