Re: distinguish update from insert (on conflict)

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: distinguish update from insert (on conflict)
Дата
Msg-id 20190522023748.GH4426@telsasoft.com
обсуждение исходный текст
Ответ на Re: distinguish update from insert (on conflict)  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: distinguish update from insert (on conflict)  (Fabio Ugo Venchiarutti <f.venchiarutti@ocado.com>)
Re: distinguish update from insert (on conflict)  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
On Tue, May 21, 2019 at 06:57:36PM -0700, Adrian Klaver wrote:
> On 5/21/19 6:34 PM, Justin Pryzby wrote:
> >Is it still impossible to distinguish whether a row was inserted vs updated ?
> 
> You will need to be more specific.

Sorry, I mean with UPSERT / "INSERT .. ON CONFLICT DO UPDATE", is it possible
to tell whether a row was inserted vs. updated ?

Thanks,
Justin



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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: distinguish update from insert (on conflict)
Следующее
От: Luca Ferrari
Дата:
Сообщение: pg_stat_user_tables.n_tup_ins empty for partitioned table