Minor ON CONFLICT related fixes

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Minor ON CONFLICT related fixes
Дата
Msg-id CAM3SWZSfqeYMbWvTYxr2J_ymXY+XkPp=s277yREqk7J5_+ccpg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Minor ON CONFLICT related fixes  (Peter Geoghegan <pg@heroku.com>)
Re: Minor ON CONFLICT related fixes  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Attached patch fixes some issues with ON CONFLICT DO UPDATE/DO
NOTHING. There is a commit message which explains the changes at a
high level. The only real bug fix is around deparsing by ruleutils.c.

Note that the patch proposes to de-support CREATE RULE with an
alternative action involving ON CONFLICT DO UPDATE. Such a rule seems
particularly questionable to me, and I'm pretty sure it was understood
that only ON CONFLICT DO NOTHING should be supported as an action for
a rule (recall that INSERT statements with ON CONFLICT can, in
general, never target relations with rules). At least, I believe
Heikki said that.

Thoughts?
--
Peter Geoghegan

Вложения

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Multi-xacts and our process problem
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Minor ON CONFLICT related fixes