Re: distinguish update from insert (on conflict)

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: distinguish update from insert (on conflict)
Дата
Msg-id 106c0789-7a13-7f9c-8d49-3562556bcdd8@aklaver.com
обсуждение исходный текст
Ответ на distinguish update from insert (on conflict)  (Justin Pryzby <pryzby@telsasoft.com>)
Ответы Re: distinguish update from insert (on conflict)  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-general
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.

On a hunch, see transition relation info here:
https://www.postgresql.org/docs/10/sql-createtrigger.html

> 
> The latest I can see is here:
> https://wiki.postgresql.org/wiki/UPSERT#RETURNING_behavior
> 
> ..but I'm hopeful that the 4 year old wiki page is out of date.
> 
> Justin
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: distinguish update from insert (on conflict)
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: distinguish update from insert (on conflict)