| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Michael Lewis <mlewis(at)entrata(dot)com> |
| Cc: | Jenda Krynicky <jenda(at)krynicky(dot)cz>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: INSERT ... ON CONFLICT doesn't work |
| Date: | 2021-12-02 05:22:29 |
| Message-ID: | ce68ab17-911b-02db-8599-6fcb68fb7209@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sonai muthu raja M | 2021-12-02 09:51:56 | Re: Require details that how to find user creation date in postgresql Database |
| Previous Message | Kyotaro Horiguchi | 2021-12-02 04:46:19 | Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11 |