Postgres Pro
Downloads
Home   >   mailing lists

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

From Adrian Klaver
Subject Re: INSERT ... ON CONFLICT doesn't work
Date
Msg-id ce68ab17-911b-02db-8599-6fcb68fb7209@aklaver.com
Whole thread Raw
In response to Re: INSERT ... ON CONFLICT doesn't work  (Michael Lewis <mlewis@entrata.com>)
List pgsql-general
Tree view 
On 12/1/21 20:20, Michael Lewis wrote:
> Perhaps I missed something, but why all this effort to reference the 
> column and not just reference IX_Lockers_Uuid for the on conflict clause?

Two reasons:

1) The OP thought that ON CONFLICT could only reference a column.

2) Explaining why the error occurred in the first place, which is down 
to variable/column name ambiguity.


-- 
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11
Next
From: "Sonai muthu raja M"
Date:
Subject: Re: Require details that how to find user creation date in postgresql Database