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

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: INSERT ... ON CONFLICT doesn't work
Дата
Msg-id ce68ab17-911b-02db-8599-6fcb68fb7209@aklaver.com
обсуждение исходный текст
Ответ на Re: INSERT ... ON CONFLICT doesn't work  (Michael Lewis <mlewis@entrata.com>)
Список 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.klaver@aklaver.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: ssl_crl_file Certificate Revocation List doesn't work for postgresql 11
Следующее
От: "Sonai muthu raja M"
Дата:
Сообщение: Re: Require details that how to find user creation date in postgresql Database