[GENERAL] INSERT and ON CONFLICT

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема [GENERAL] INSERT and ON CONFLICT
Дата
Msg-id alpine.LNX.2.11.1703100930000.26081@localhost
обсуждение исходный текст
Ответы Re: [GENERAL] INSERT and ON CONFLICT  (Brian Dunavant <brian@omniti.com>)
Список pgsql-general
   I'm filling a table with rows and have the first batch successfully
inserted. When I add more rows there may be some that already exist in the
table and I would prefer that they be ignored and the insert process
continue.

   The syntax page for INSERT suggests that ON CONFLICT DO NOTHING is exactly
what I want to include in the command. Have I correctly interpreted what the
DO NOTHING option does when a row to be inserted already is present in the
table?

Rich


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

Предыдущее
От: Rich Shepard
Дата:
Сообщение: [GENERAL] Upgradede -9.6.1 to -9.6.2; postmaster will not start
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Upgradede -9.6.1 to -9.6.2; postmaster will not start