Re: BUG #13886: When INSERT ON CONFLICT DO UPDATE updates, it returns INSERT rather than UPDATE

Поиск
Список
Период
Сортировка
От Randy Westlund
Тема Re: BUG #13886: When INSERT ON CONFLICT DO UPDATE updates, it returns INSERT rather than UPDATE
Дата
Msg-id 20160125184825.GB44462@gmail.com
обсуждение исходный текст
Ответ на Re: BUG #13886: When INSERT ON CONFLICT DO UPDATE updates, it returns INSERT rather than UPDATE  (Marko Tiikkaja <marko@joh.to>)
Список pgsql-bugs
Дерево обсуждения 
On Mon, Jan 25, 2016 at 11:00:38AM +0100, Marko Tiikkaja wrote:
> On 25/01/16 08:48, rwestlun@gmail.com wrote:
> > I believe postgres should be returning "UPDATE" here instead of "INSERT"
> > because I see no way to know which operation took place.
>=20
> That seems a bit short-sighted.  What should happen if one row was added=
=20
> and one updated?

That's a good point. I'm not sure what the proper way to determine which
operation took place should be :/

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #13884: array_to_json() works incorrectly for non-0-based arrays
Следующее
От: Gavin Flower
Дата:
Сообщение: Re: BUG #13883: Very Important Facility