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)
Список
Дерево обсуждения
INSERT ... ON CONFLICT doesn't work "Jenda Krynicky" <Jenda@Krynicky.cz>
Re: INSERT ... ON CONFLICT doesn't work "David G. Johnston" <david.g.johnston@gmail.com>
Re: INSERT ... ON CONFLICT doesn't work Tom Lane <tgl@sss.pgh.pa.us>
Re: INSERT ... ON CONFLICT doesn't work "Jenda Krynicky" <Jenda@Krynicky.cz>
Re: INSERT ... ON CONFLICT doesn't work Tom Lane <tgl@sss.pgh.pa.us>
Re: INSERT ... ON CONFLICT doesn't work "David G. Johnston" <david.g.johnston@gmail.com>
Re: INSERT ... ON CONFLICT doesn't work "David G. Johnston" <david.g.johnston@gmail.com>
Re: INSERT ... ON CONFLICT doesn't work "Jenda Krynicky" <Jenda@Krynicky.cz>
Re: INSERT ... ON CONFLICT doesn't work "David G. Johnston" <david.g.johnston@gmail.com>
Re: INSERT ... ON CONFLICT doesn't work "Jenda Krynicky" <Jenda@Krynicky.cz>
Re: INSERT ... ON CONFLICT doesn't work "David G. Johnston" <david.g.johnston@gmail.com>
Re: INSERT ... ON CONFLICT doesn't work Adrian Klaver <adrian.klaver@aklaver.com>
Re: INSERT ... ON CONFLICT doesn't work "Jenda Krynicky" <Jenda@Krynicky.cz>
Re: INSERT ... ON CONFLICT doesn't work Adrian Klaver <adrian.klaver@aklaver.com>
Re: INSERT ... ON CONFLICT doesn't work Adrian Klaver <adrian.klaver@aklaver.com>
Re: INSERT ... ON CONFLICT doesn't work Michael Lewis <mlewis@entrata.com>
Re: INSERT ... ON CONFLICT doesn't work Adrian Klaver <adrian.klaver@aklaver.com> 
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
Дата:
Следующее
От: Sonai muthu raja M
Дата:
FAQ